Difference between revisions of "User:Econterms/Patents spike project"

From Inventing aviation
Jump to navigation Jump to search
(→‎More for the paper: flesh out another early measure of commercialization)
(→‎Basic charts and reports: first pass reports on British grant dates and on publications)
Line 36: Line 36:
 
|where=Patents.office='GB' AND Patents.Year_filed>'1902'
 
|where=Patents.office='GB' AND Patents.Year_filed>'1902'
 
|order by=Patents.Year_filed DESC
 
|order by=Patents.Year_filed DESC
 +
|format=
 +
}}
 +
 +
; Britain by year granted
 +
{{#cargo_query:
 +
tables=Patents
 +
|fields=Patents.Year_filed,COUNT(*)
 +
|group by=Patents.Year_granted
 +
|where=Patents.office='GB' AND Patents.Year_granted>'1902'
 +
|order by=Patents.Year_granted DESC
 
|format=
 
|format=
 
}}
 
}}
Line 66: Line 76:
 
|where=Patents.office='US' AND Patents.Year_filed>'1902'
 
|where=Patents.office='US' AND Patents.Year_filed>'1902'
 
|order by=Patents.Year_filed DESC
 
|order by=Patents.Year_filed DESC
 +
|format=
 +
}}
 +
 +
; Publications in Britain by year published
 +
{{#cargo_query:
 +
tables=Publications
 +
|fields=Publications.Countries,COUNT(*)
 +
|group by=Publications.Date
 +
|where=Publications.Countries HOLDS 'GB' AND Publications.Date>'1902'
 +
|order by=Publications.Date DESC
 
|format=
 
|format=
 
}}
 
}}

Revision as of 21:10, 14 January 2019

Patent literature to refer to

  • Katherine C. Epstein. Intellectual property and national security: the case of the hardcastle superheater, 1905–1927. Pages 126-156 | Published online: 16 Dec 2018 https://doi.org/10.1080/07341512.2018.1544106. Compressed abstract: This invention by a naval officer was valuable to British security and commercially. This article explores complex and changing relationships between technological development, intellectual property, and national security. The British state had an interest in acquiring control of the intellectual property to maintain Britain’s naval supremacy. That was not aligned with the interests of the inventors, especially fraught for inventors in government service. ("service inventors") The government's inventors played a crucial role in maintaining Britain’s naval-technological edge, were governed by special regulations. They used state resources for their inventive work.
  • Katherine C. Epstein's book on Torpedo -- ordered. The time period starts in the 1890s. Bart Hacker reviewed it favorably in Isis (Dec 2015).
  • Fabian Lorenz Schrey job market paper http://www.flschrey.com/jmp (printed at the office)

More for the paper

  • I just saw a couple of assignees in NYC. Are assignees usually connected to big cities, money, and manufacturing capability?
  • Show counts or proportions of patents with assignees over time. Presumably this is one of the things that goes up in a period of commercialization

Basic charts and reports

Patent counts by year filed across all countries
All countries, patent counts by date granted
Britain by year filed
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='GB' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

Britain by year granted
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='GB' AND `aero_cargo__Patents`.`Year_granted`>'1902' GROUP BY `aero_cargo__Patents`.`Year_granted` ORDER BY `aero_cargo__Patents`.`Year_granted` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

France
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='GB' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

Deutsch
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='DE' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

United States
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='US' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

Publications in Britain by year published
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Countries__full` AS `Countries`,COUNT(*) FROM `aero_cargo__Publications` WHERE `aero_cargo__Publications`.`_ID` IN (SELECT `_rowID` FROM `aero_cargo__Publications__Countries` WHERE `_value`= 'GB') AND `aero_cargo__Publications`.`Date`>'1902' GROUP BY `aero_cargo__Publications`.`Date` ORDER BY `aero_cargo__Publications`.`Date` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)