Patent counts by country where filed

From Inventing aviation
Jump to: navigation, search

Counts of patent on espacenet

If patents in our time frame are added or deleted from espacenet we might be able to detect that here. It is likely to be better to reorg this to have two columns for each country also from this system.

Year German
patents
German
patents
in
B64
French
patents
French
patents
in
B64
British
patents
British
patents
in
B64
US
patents
US
patents
in
B64
1899 193 0 0 0 >10k 0 >10k 31
1900 203 0 1 0 >10k 34 >10k 34
1901 262 0 0 0 >10k 0 >10k 24
1902 274 0 3638 28 >10k 0 >10k 44
1903 204 2 >10k 73 >10k 1 >10k 46
1904 267 0 >10k 55 >10k 0 >10k 35
1905 204 0 >10k 32 >10k 0 >10k 41
1906 299 0 >10k 54 >10k 0 >10k 53
1907 326 1 >10k 86 >10k 1 >10k 96
1908 292 0 >10k 152 >10k 1 >10k 80
1909 336 0 >10k 432 >10k 79 >10k 124
1910 371 2 >10k 586 >10k 328 >10k 151
1911 379 2 >10k 725 >10k 313 >10k 412
1912 408 4 >10k 548 >10k 234 >10k 434
1913 457 2 >10k 544 >10k 250 >10k 279
1914 369 3 >10k 277 >10k 184 >10k 259
1915 230 2 5789 147 >10k 129 >10k 221

Counts from this wiki

Patents on this wiki from a country with more than one
Office COUNT(*)
FR 5,008
US 4,760
GB 3,696
DE 821
BE 140
AT 85
CA 70
CH 49
NO 49
ES 39
IT 31
DK 16
IN 15
HU 9
8
?? 7
AU 7
RU 3
AH 2
SU 2
same but as bar chart doesn't work
This doesn't work yet
Patents on this wiki up to 1916
A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script

Query: SELECT `cargo__Patents`.`Office` AS `Office`,COUNT(*) AS `COUNT(*)` FROM `cargo__Patents` GROUP BY `cargo__Patents`.`Office` HAVING `cargo__Patents`.`Year_filed`<1917 ORDER BY COUNT(*) DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'cargo__Patents.Year_filed' in 'having clause' (localhost)

To do -- make that chart work