Patent counts by year

Report 1 based on year filed

Use this to sort by the number within the year instead of the year:

|order by=count(*) DESC

Report 2 based on year granted

Report 3 based on year filed

Report 4 based on year filed

Year filed	COUNT(*)
1930	2
1928	2
1927	4
1926	2
1924	2
1923	3
1922	16
1921	15
1920	41
1919	51
1918	676
1917	703
1916	520
1915	527
1914	692
1913	1,044
1912	1,198
1911	1,349
1910	1,719
1909	1,537
1908	796
1907	418
1906	268
1905	142
1904	168
1903	147
1902	187
1901	150
1900	137
1899	109
1898	97
1897	82
1896	62
1895	40
1894	72
1893	80
1892	72
1891	62
1890	43
1889	46
1888	27
1887	28
1886	23
1885	27
1884	28
1883	39
1882	36
1881	39
1880	37
1879	23
1878	28
1877	22
1876	16
1875	16
1874	15
1873	20
1872	18
1871	22
1870	45
1869	14
1868	19
1867	29
1866	14
1865	8
1864	17
1863	25
1862	7
1861	11
1860	16
1859	19
1858	15
1857	22
1856	18
1855	27
1854	20
1853	35
1852	19
1851	21
1850	16
1849	3
1848	4
1847	5
1846	6
1845	10
1844	4
1843	11
1842	3
1841	5
1840	4
1839	4
1838	4
1837	5
1836	3
1826	2
	3,215

Report 5 based on year filed

Count of database entries for different technology types

Report 6 based on year filed

Year filed	Number of entries
	0
1802	1
1815	1
1817	1
1818	1
1820	1
1823	1
1826	2
1827	1
1831	1
1832	1
1833	1
1834	1
1835	1
1836	3
1837	5
1838	4
1839	4
1840	4
1841	5
1842	3
1843	11
1844	4
1845	10
1846	6
1847	5
1848	4
1849	3
1850	16
1851	21
1852	19
1853	35
1854	20
1855	27
1856	18
1857	22
1858	15
1859	19
1860	16
1861	11
1862	7
1863	25
1864	17
1865	8
1866	14
1867	29
1868	19
1869	14
1870	45
1871	22
1872	18
1873	20
1874	15
1875	16
1876	16
1877	22
1878	28
1879	23
1880	37
1881	39
1882	36
1883	39
1884	28
1885	27
1886	23
1887	28
1888	27
1889	46
1890	43
1891	62
1892	72
1893	80
1894	72
1895	40
1896	62
1897	82
1898	97
1899	109
1900	137
1901	150
1902	187
1903	147
1904	168
1905	142
1906	268
1907	418
1908	796
1909	1,537
1910	1,719
1911	1,349
1912	1,198
1913	1,044
1914	692
1915	527
1916	520
1917	703
1918	676
1919	51
1920	41
1921	15
1922	16
1923	3
1924	2
1926	2
1927	4
1928	2
1929	1
1930	2
2019	1

Mean, min and max generation capacities of technologies in the database

Report 7 based on year filed

Publications experiment

Report 1 based on year