User:Econterms/Patents spike project
- 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)
- 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)