Difference between revisions of "User:Econterms/Patents spike project"
(→Basic charts and reports: first pass reports on British grant dates and on publications) |
(record queries for big data downloads) |
||
Line 1: | Line 1: | ||
+ | === Data downloads === | ||
+ | * This grabs the first 5000 with all fields. [http://aero.referata.com/w/index.php?title=Special:ViewData&limit=5000&offset=0&tables=Patents&fields=_pageName%3DPage%2CYear_filed%3DYear+filed%2CYear_granted%3DYear+granted%2COffice%3DOffice%2CPatent_number%3DPatent+number%2CInventors__full%3DInventors%2CInventor_country__full%3DInventor+country%2CApplicant_person__full%3DApplicant+person%2CApplicant_firm__full%3DApplicant+firm%2CApplicant_type__full%3DApplicant+type%2CApplicant_is_inventor%3DApplicant+is+inventor%2COriginal_title%3DOriginal+title%2CEnglish_title%3DEnglish+title%2CTech_fields__full%3DTech+fields%2CFiling_date%3DFiling+date%2CFull_specification_filed_date%3DFull+specification+filed+date%2CApplication_number%3DApplication+number%2CGrant_date%3DGrant+date%2CGranted%3DGranted%2CPublication_date%3DPublication+date%2CSupplementary_to_patent__full%3DSupplementary+to+patent%2CRelated_to_aircraft%3DRelated+to+aircraft%2CSerial_number%3DSerial+number%2CPatent_agent%3DPatent+agent%2CAssigned_to%3DAssigned+to%2CNational_tech_categories__full%3DNational+tech+categories%2CIPCs__full%3DIPCs%2CCPCs__full%3DCPCs%2CFamily_year%3DFamily+year%2CFirst_filing%3DFirst+filing%2CNumber_of_citations%3DNumber+of+citations%2CCited_by__full%3DCited+by%2CApplication_ID%3DApplication+ID%2CINPADOC_family_ID%3DINPADOC+family+ID%2CNumber_of_text_pages%3DNumber+of+text+pages%2CNumber_of_diagram_pages%3DNumber+of+diagram+pages%2CNumber_of_figures%3DNumber+of+figures%2CNumber_of_claims%3DNumber+of+claims&order_by=%60_pageName%60%2C+%60Year_filed%60%2C+%60Year_granted%60%2C+%60Office%60%2C+%60Patent_number%60&max+display+chars=300] | ||
+ | * This drops several columns not needed for the patent spike project - serial number, application number, application ID, INPADOC family ID, full-spec-filed-date, publication date, and cited by: [http://aero.referata.com/w/index.php?title=Special:ViewData&limit=5000&offset=0&tables=Patents&fields=_pageName%3DPage%2CYear_filed%3DYear+filed%2CYear_granted%3DYear+granted%2COffice%3DOffice%2CPatent_number%3DPatent+number%2CInventors__full%3DInventors%2CInventor_country__full%3DInventor+country%2CApplicant_person__full%3DApplicant+person%2CApplicant_firm__full%3DApplicant+firm%2CApplicant_type__full%3DApplicant+type%2CApplicant_is_inventor%3DApplicant+is+inventor%2COriginal_title%3DOriginal+title%2CEnglish_title%3DEnglish+title%2CTech_fields__full%3DTech+fields%2CFiling_date%3DFiling+date%2CGrant_date%3DGrant+date%2CGranted%3DGranted%2CSupplementary_to_patent__full%3DSupplementary+to+patent%2CRelated_to_aircraft%3DRelated+to+aircraft%2CPatent_agent%3DPatent+agent%2CAssigned_to%3DAssigned+to%2CNational_tech_categories__full%3DNational+tech+categories%2CIPCs__full%3DIPCs%2CCPCs__full%3DCPCs%2CFamily_year%3DFamily+year%2CFirst_filing%3DFirst+filing%2CNumber_of_citations%3DNumber+of+citations%2CNumber_of_text_pages%3DNumber+of+text+pages%2CNumber_of_diagram_pages%3DNumber+of+diagram+pages%2CNumber_of_figures%3DNumber+of+figures%2CNumber_of_claims%3DNumber+of+claims&order_by=%60_pageName%60%2C+%60Year_filed%60%2C+%60Year_granted%60%2C+%60Office%60%2C+%60Patent_number%60&max+display+chars=300] | ||
+ | |||
=== Patent literature to refer to === | === Patent literature to refer to === | ||
* Katherine C. Epstein. [https://www.tandfonline.com/doi/full/10.1080/07341512.2018.1544106?scroll=top&needAccess=true 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. [https://www.tandfonline.com/doi/full/10.1080/07341512.2018.1544106?scroll=top&needAccess=true 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. | ||
Line 5: | Line 9: | ||
=== More for the paper === | === More for the paper === | ||
− | * | + | * Consider 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 | * 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 | ||
* | * |
Revision as of 11:49, 1 February 2019
Contents
Data downloads
- This grabs the first 5000 with all fields. [1]
- This drops several columns not needed for the patent spike project - serial number, application number, application ID, INPADOC family ID, full-spec-filed-date, publication date, and cited by: [2]
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
- Consider 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
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
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
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
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
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
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)