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

From Inventing aviation
Jump to navigation Jump to search
(syntax fix)
(reports by filed and by granted years)
Line 1: Line 1:
−
; All countries
+
; Patent counts by year filed across all countries
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=Patents
 
tables=Patents
 
|fields=Patents.Year_filed,COUNT(*)
 
|fields=Patents.Year_filed,COUNT(*)
 
|group by=Patents.Year_filed
 
|group by=Patents.Year_filed
−
|where=Patents.office='DE' AND Patents.Year_filed>'1902'
+
|where=Patents.Year_filed>'1902'
 
|order by=Patents.Year_filed DESC
 
|order by=Patents.Year_filed DESC
 +
|format=bar chart
 +
}}
 +
; All countries, patent counts by date granted
 +
{{#cargo_query:
 +
tables=Patents
 +
|fields=Patents.Year_granted,COUNT(*)
 +
|group by=Patents.Year_granted
 +
|where=Patents.Year_granted>'1902'
 +
|order by=Patents.Year_granted DESC
 +
|format=bar chart
 
}}
 
}}
−
* If want a bar chart, add <nowiki>|format=bar chart</nowiki> to the end
 
  
−
; Britain
+
; Britain by year filed
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=Patents
 
tables=Patents

Revision as of 18:32, 26 August 2018

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)

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)

Retrieved from "http://econterms.net/aero/index.php?title=User:Econterms/Patents_spike_project&oldid=337"