User:Econterms/Aero workshop for Jan 28 2021

From Inventing aviation
Jump to navigation Jump to search
  • Newest charts are on main page
  • Need counts of patents overall in these countries. How are aero patents moving as proportion of all patents?
  • Can we test whether patents of all types were spiking around 1910?
  • Do British patents have filing data misrecorded in our wiki as grant date?? That would explain some missing patents.
  • Can we show how many Germans were patenting in the US vs vice versa? What patterns are there in who files where?
  • Can we show that they file more in the core/powerful/emitting countries? Or, how much?
  • Among the smaller countries, there are some where the applicants are mostly local (e.g. NZ), and others where it's mostly foreign (e.g IN)
  • Almost anyone filing has a western-style education and usually ethnic background too, so far as we can tell.
  • That surprises LTA, because so many Indian people were western-educated, e.g. Indian lawyers and raiload engineers.
  • We will check whether there are more corporate filings in Germany (or any country) than in other countries.

Show slides listing complexities and ancillary data

  • data on patent agents
  • data on technical classifications
  • data on patent offices -- surprisingly difficult to find
Good examples of use of wiki for historical evidence
Programming details
  • use data downloads from User:Econterms#Prep_for_data_downloads, #6, the latest 2021 one
  • stata code is in meyer/stata/airplane/2021
  • R code is in meyer/rdata/MeyerPlanes/2021

YOU NEED ALL THAT. Plus a bunch of the cleanup realistically has to be done in excel. read.xlsx() is getting something severely wrong, but possibly because of perverse empty columns or column names so see if it can be gotten into stata first.

advice from AvionH

Additions are common in FR and BE

clear in catalogs

will want to distinguish between the foreign filings and the additions

perhaps it can be progammed if the supplementary patent is in the same country

we'll want a way to mark citations.

I've previously said a patent can be "supplementary" to one it just cites gotta undo that rule.