Difference between revisions of "Estimates of how many are child patents"
Jump to navigation
Jump to search
Line 32: | Line 32: | ||
|group by=Patents.Office,Patents.Year_filed,Patents.First_filing | |group by=Patents.Office,Patents.Year_filed,Patents.First_filing | ||
|order by=Patents.Office,Patents.Year_filed | |order by=Patents.Office,Patents.Year_filed | ||
+ | |format=table | ||
+ | }} | ||
+ | |||
+ | ; Counts by First-filing by country and year and relevant-to-aircraft. can transform into xtab and do regressions | ||
+ | {{#cargo_query: | ||
+ | tables=Patents | ||
+ | |fields=Patents.Office,Patents.Year_filed,Patents.First_filing, Related_to_aircraft,count(Patents.First_filing)=Number of entries | ||
+ | |group by=Patents.Office,Patents.Year_filed,Patents.First_filing,Related_to_aircraft | ||
+ | |order by=Patents.Office,Patents.Year_filed,Related_to_aircraft | ||
|format=table | |format=table | ||
}} | }} |
Revision as of 18:07, 18 September 2021
Count of database entries for different technology types
- Report 6 based on year filed
First filing | Number of entries |
---|---|
0 | |
No | 4,883 |
Yes | 8,206 |
- First filing y/n by country; can make a crosstab format from this
Office | First filing | Number of entries |
---|---|---|
0 | ||
No | 3 | |
Yes | 4 | |
?? | 0 | |
AH | 0 | |
AH | Yes | 1 |
AT | 0 | |
AT | No | 99 |
AT | Yes | 83 |
AU | 0 | |
AU | No | 15 |
AU | Yes | 10 |
BE | 0 | |
BE | No | 138 |
BE | Yes | 88 |
CA | 0 | |
CA | No | 60 |
CA | Yes | 41 |
CH | 0 | |
CH | No | 40 |
CH | Yes | 34 |
CL | 0 | |
CU | 0 | |
DE | 0 | |
DE | No | 358 |
DE | Yes | 355 |
DEG | 0 | |
DEG | Yes | 7 |
DK | 0 | |
DK | No | 24 |
DK | Yes | 5 |
ES | 0 | |
ES | No | 43 |
ES | Yes | 11 |
FI | 0 | |
FI | No | 4 |
FI | Yes | 2 |
FR | 0 | |
FR | No | 2,839 |
FR | Yes | 1,872 |
GB | 0 | |
GB | No | 597 |
GB | Yes | 2,019 |
GR | 0 | |
HU | 0 | |
HU | No | 263 |
HU | Yes | 92 |
IN | 0 | |
IN | No | 8 |
IT | 0 | |
IT | No | 33 |
IT | Yes | 21 |
JP | 0 | |
JP | Yes | 1 |
LU | 0 | |
LU | No | 5 |
MX | 0 | |
MX | No | 4 |
MX | Yes | 47 |
NL | 0 | |
NL | No | 8 |
NL | Yes | 8 |
NO | 0 | |
NO | No | 12 |
NO | Yes | 9 |
NZ | 0 | |
NZ | No | 3 |
NZ | Yes | 3 |
RU | 0 | |
RU | No | 47 |
RU | Yes | 23 |
SAX | Yes | 1 |
SE | Yes | 3 |
SU | Yes | 5 |
UN | 0 | |
US | 0 | |
US | No | 280 |
US | Yes | 3,461 |
- Counts by First-filing by year. a crosstab will be a better format
Year filed | First filing | Number of entries |
---|---|---|
0 | ||
No | 489 | |
Yes | 443 | |
1802 | 0 | |
1815 | Yes | 1 |
1817 | 0 | |
1818 | No | 1 |
1820 | 0 | |
1823 | Yes | 1 |
1826 | No | 1 |
1826 | Yes | 1 |
1827 | 0 | |
1831 | No | 1 |
1832 | Yes | 1 |
1833 | 0 | |
1834 | 0 | |
1835 | No | 1 |
1836 | 0 | |
1836 | Yes | 2 |
1837 | 0 | |
1837 | No | 3 |
1837 | Yes | 1 |
1838 | No | 2 |
1838 | Yes | 2 |
1839 | 0 | |
1840 | 0 | |
1840 | No | 1 |
1840 | Yes | 2 |
1841 | No | 2 |
1841 | Yes | 3 |
1842 | No | 2 |
1842 | Yes | 1 |
1843 | 0 | |
1843 | No | 5 |
1843 | Yes | 3 |
1844 | 0 | |
1844 | Yes | 3 |
1845 | 0 | |
1845 | No | 4 |
1845 | Yes | 3 |
1846 | 0 | |
1846 | No | 3 |
1846 | Yes | 1 |
1847 | No | 4 |
1847 | Yes | 1 |
1848 | 0 | |
1848 | No | 2 |
1848 | Yes | 1 |
1849 | No | 2 |
1849 | Yes | 1 |
1850 | 0 | |
1850 | No | 11 |
1850 | Yes | 3 |
1851 | 0 | |
1851 | No | 8 |
1851 | Yes | 4 |
1852 | 0 | |
1852 | No | 3 |
1852 | Yes | 3 |
1853 | 0 | |
1853 | No | 12 |
1853 | Yes | 11 |
1854 | 0 | |
1854 | No | 9 |
1854 | Yes | 7 |
1855 | 0 | |
1855 | No | 7 |
1855 | Yes | 8 |
1856 | 0 | |
1856 | No | 5 |
1856 | Yes | 5 |
1857 | 0 | |
1857 | No | 7 |
1857 | Yes | 11 |
1858 | 0 | |
1858 | No | 1 |
1858 | Yes | 5 |
1859 | 0 | |
1859 | No | 2 |
1859 | Yes | 7 |
1860 | 0 | |
1860 | No | 5 |
1860 | Yes | 10 |
1861 | No | 4 |
1861 | Yes | 7 |
1862 | 0 | |
1862 | Yes | 5 |
1863 | 0 | |
1863 | No | 4 |
1863 | Yes | 11 |
1864 | 0 | |
1864 | No | 3 |
1864 | Yes | 8 |
1865 | No | 1 |
1865 | Yes | 7 |
1866 | 0 | |
1866 | No | 1 |
1866 | Yes | 10 |
1867 | 0 | |
1867 | No | 7 |
1867 | Yes | 11 |
1868 | 0 | |
1868 | No | 4 |
1868 | Yes | 9 |
1869 | 0 | |
1869 | No | 1 |
1869 | Yes | 10 |
1870 | 0 | |
1870 | No | 5 |
1870 | Yes | 11 |
1871 | 0 | |
1871 | No | 6 |
1871 | Yes | 9 |
1872 | 0 | |
1872 | No | 4 |
1872 | Yes | 9 |
1873 | 0 | |
1873 | No | 10 |
1873 | Yes | 9 |
1874 | 0 | |
1874 | No | 3 |
1874 | Yes | 10 |
1875 | 0 | |
1875 | No | 4 |
1875 | Yes | 9 |
1876 | 0 | |
1876 | No | 3 |
1876 | Yes | 12 |
1877 | 0 | |
1877 | No | 4 |
1877 | Yes | 15 |
1878 | 0 | |
1878 | No | 1 |
1878 | Yes | 20 |
1879 | 0 | |
1879 | No | 7 |
1879 | Yes | 14 |
1880 | 0 | |
1880 | No | 19 |
1880 | Yes | 17 |
1881 | 0 | |
1881 | No | 9 |
1881 | Yes | 23 |
1882 | 0 | |
1882 | No | 8 |
1882 | Yes | 23 |
1883 | 0 | |
1883 | No | 11 |
1883 | Yes | 23 |
1884 | 0 | |
1884 | No | 3 |
1884 | Yes | 11 |
1885 | 0 | |
1885 | No | 7 |
1885 | Yes | 13 |
1886 | 0 | |
1886 | No | 2 |
1886 | Yes | 16 |
1887 | 0 | |
1887 | No | 7 |
1887 | Yes | 13 |
1888 | 0 | |
1888 | No | 8 |
1888 | Yes | 13 |
1889 | 0 | |
1889 | No | 5 |
1889 | Yes | 21 |
1890 | 0 | |
1890 | No | 8 |
1890 | Yes | 19 |
1891 | 0 | |
1891 | No | 21 |
1891 | Yes | 19 |
1892 | 0 | |
1892 | No | 14 |
1892 | Yes | 27 |
1893 | 0 | |
1893 | No | 30 |
1893 | Yes | 22 |
1894 | 0 | |
1894 | No | 13 |
1894 | Yes | 36 |
1895 | 0 | |
1895 | No | 10 |
1895 | Yes | 21 |
1896 | 0 | |
1896 | No | 18 |
1896 | Yes | 28 |
1897 | 0 | |
1897 | No | 24 |
1897 | Yes | 32 |
1898 | 0 | |
1898 | No | 22 |
1898 | Yes | 62 |
1899 | 0 | |
1899 | No | 20 |
1899 | Yes | 54 |
1900 | 0 | |
1900 | No | 22 |
1900 | Yes | 65 |
1901 | 0 | |
1901 | No | 23 |
1901 | Yes | 88 |
1902 | 0 | |
1902 | No | 79 |
1902 | Yes | 74 |
1903 | 0 | |
1903 | No | 48 |
1903 | Yes | 77 |
1904 | 0 | |
1904 | No | 40 |
1904 | Yes | 104 |
1905 | 0 | |
1905 | No | 34 |
1905 | Yes | 88 |
1906 | 0 | |
1906 | No | 61 |
1906 | Yes | 157 |
1907 | 0 | |
1907 | No | 135 |
1907 | Yes | 193 |
1908 | 0 | |
1908 | No | 259 |
1908 | Yes | 408 |
1909 | 0 | |
1909 | No | 517 |
1909 | Yes | 839 |
1910 | 0 | |
1910 | No | 616 |
1910 | Yes | 901 |
1911 | 0 | |
1911 | No | 438 |
1911 | Yes | 785 |
1912 | 0 | |
1912 | No | 445 |
1912 | Yes | 621 |
1913 | 0 | |
1913 | No | 411 |
1913 | Yes | 540 |
1914 | 0 | |
1914 | No | 215 |
1914 | Yes | 355 |
1915 | 0 | |
1915 | No | 127 |
1915 | Yes | 332 |
1916 | 0 | |
1916 | No | 125 |
1916 | Yes | 327 |
1917 | 0 | |
1917 | No | 183 |
1917 | Yes | 463 |
1918 | 0 | |
1918 | No | 138 |
1918 | Yes | 508 |
1919 | 0 | |
1919 | No | 19 |
1919 | Yes | 14 |
1920 | 0 | |
1920 | No | 12 |
1920 | Yes | 9 |
1921 | 0 | |
1921 | No | 3 |
1921 | Yes | 9 |
1922 | 0 | |
1922 | No | 2 |
1922 | Yes | 8 |
1923 | No | 3 |
1924 | Yes | 2 |
1926 | No | 1 |
1926 | Yes | 1 |
1927 | 0 | |
1927 | No | 1 |
1927 | Yes | 2 |
1928 | No | 1 |
1928 | Yes | 1 |
1929 | Yes | 1 |
1930 | 0 | |
1930 | No | 1 |
2019 | 0 |
- Counts by First-filing by country and year. can transform into xtab and do regressions
Office | Year filed | First filing | Number of entries |
---|---|---|---|
0 | |||
No | 1 | ||
Yes | 3 | ||
1871 | No | 1 | |
1909 | Yes | 1 | |
1912 | No | 1 | |
?? | 0 | ||
AH | 0 | ||
AH | 1890 | Yes | 1 |
AT | No | 1 | |
AT | 1884 | Yes | 1 |
AT | 1898 | 0 | |
AT | 1899 | 0 | |
AT | 1899 | No | 2 |
AT | 1900 | 0 | |
AT | 1900 | No | 2 |
AT | 1901 | 0 | |
AT | 1901 | No | 2 |
AT | 1901 | Yes | 2 |
AT | 1902 | 0 | |
AT | 1902 | No | 3 |
AT | 1902 | Yes | 1 |
AT | 1903 | 0 | |
AT | 1903 | No | 2 |
AT | 1903 | Yes | 1 |
AT | 1904 | 0 | |
AT | 1904 | No | 2 |
AT | 1904 | Yes | 1 |
AT | 1905 | 0 | |
AT | 1905 | No | 1 |
AT | 1906 | 0 | |
AT | 1906 | No | 1 |
AT | 1906 | Yes | 1 |
AT | 1907 | 0 | |
AT | 1907 | No | 1 |
AT | 1907 | Yes | 3 |
AT | 1908 | 0 | |
AT | 1908 | No | 9 |
AT | 1908 | Yes | 8 |
AT | 1909 | 0 | |
AT | 1909 | No | 9 |
AT | 1909 | Yes | 10 |
AT | 1910 | 0 | |
AT | 1910 | No | 16 |
AT | 1910 | Yes | 10 |
AT | 1911 | 0 | |
AT | 1911 | No | 7 |
AT | 1911 | Yes | 5 |
AT | 1912 | 0 | |
AT | 1912 | No | 8 |
AT | 1912 | Yes | 9 |
AT | 1913 | 0 | |
AT | 1913 | No | 18 |
AT | 1913 | Yes | 8 |
AT | 1914 | 0 | |
AT | 1914 | No | 2 |
AT | 1914 | Yes | 3 |
AT | 1915 | 0 | |
AT | 1915 | No | 6 |
AT | 1915 | Yes | 7 |
AT | 1916 | 0 | |
AT | 1916 | No | 2 |
AT | 1916 | Yes | 5 |
AT | 1917 | 0 | |
AT | 1917 | No | 4 |
AT | 1917 | Yes | 7 |
AT | 1918 | 0 | |
AT | 1918 | Yes | 1 |
AT | 1919 | No | 1 |
AT | 1920 | 0 | |
AU | 1904 | 0 | |
AU | 1905 | Yes | 1 |
AU | 1908 | 0 | |
AU | 1909 | 0 | |
AU | 1909 | No | 3 |
AU | 1909 | Yes | 1 |
AU | 1910 | 0 | |
AU | 1910 | No | 1 |
AU | 1911 | 0 | |
AU | 1911 | No | 1 |
AU | 1911 | Yes | 1 |
AU | 1912 | 0 | |
AU | 1912 | No | 2 |
AU | 1913 | 0 | |
AU | 1913 | No | 1 |
AU | 1913 | Yes | 1 |
AU | 1914 | 0 | |
AU | 1914 | No | 2 |
AU | 1914 | Yes | 1 |
AU | 1916 | 0 | |
AU | 1916 | Yes | 2 |
AU | 1917 | No | 4 |
AU | 1917 | Yes | 1 |
AU | 1918 | 0 | |
AU | 1919 | No | 1 |
AU | 1920 | Yes | 2 |
BE | No | 7 | |
BE | 1831 | No | 1 |
BE | 1835 | No | 1 |
BE | 1851 | No | 2 |
BE | 1855 | No | 1 |
BE | 1860 | No | 3 |
BE | 1885 | No | 1 |
BE | 1887 | No | 1 |
BE | 1897 | No | 1 |
BE | 1900 | 0 | |
BE | 1900 | No | 1 |
BE | 1900 | Yes | 3 |
BE | 1904 | No | 1 |
BE | 1906 | Yes | 1 |
BE | 1907 | 0 | |
BE | 1907 | No | 8 |
BE | 1907 | Yes | 10 |
BE | 1908 | 0 | |
BE | 1909 | 0 | |
BE | 1909 | No | 28 |
BE | 1909 | Yes | 4 |
BE | 1910 | 0 | |
BE | 1910 | No | 29 |
BE | 1910 | Yes | 4 |
BE | 1911 | 0 | |
BE | 1911 | No | 9 |
BE | 1911 | Yes | 5 |
BE | 1912 | 0 | |
BE | 1912 | No | 12 |
BE | 1912 | Yes | 10 |
BE | 1913 | 0 | |
BE | 1913 | No | 8 |
BE | 1913 | Yes | 5 |
BE | 1914 | 0 | |
BE | 1914 | No | 19 |
BE | 1914 | Yes | 46 |
BE | 1915 | 0 | |
BE | 1915 | No | 3 |
BE | 1916 | 0 | |
BE | 1916 | No | 1 |
BE | 1926 | No | 1 |
CA | 0 | ||
CA | No | 2 | |
CA | Yes | 2 | |
CA | 1871 | 0 | |
CA | 1878 | 0 | |
CA | 1880 | Yes | 1 |
CA | 1881 | 0 | |
CA | 1881 | Yes | 2 |
CA | 1883 | Yes | 1 |
CA | 1886 | Yes | 1 |
CA | 1889 | Yes | 1 |
CA | 1890 | Yes | 1 |
CA | 1892 | No | 1 |
CA | 1893 | 0 | |
CA | 1894 | Yes | 2 |
CA | 1897 | No | 1 |
CA | 1898 | Yes | 1 |
CA | 1899 | 0 | |
CA | 1899 | No | 1 |
CA | 1900 | 0 | |
CA | 1901 | 0 | |
CA | 1901 | No | 1 |
CA | 1902 | 0 | |
CA | 1902 | No | 1 |
CA | 1903 | No | 1 |
CA | 1904 | No | 1 |
CA | 1904 | Yes | 2 |
CA | 1905 | 0 | |
CA | 1905 | No | 1 |
CA | 1905 | Yes | 1 |
CA | 1907 | 0 | |
CA | 1907 | Yes | 1 |
CA | 1908 | No | 1 |
CA | 1908 | Yes | 2 |
CA | 1909 | 0 | |
CA | 1909 | No | 8 |
CA | 1909 | Yes | 2 |
CA | 1910 | 0 | |
CA | 1910 | No | 6 |
CA | 1910 | Yes | 3 |
CA | 1911 | 0 | |
CA | 1911 | No | 5 |
CA | 1911 | Yes | 2 |
CA | 1912 | 0 | |
CA | 1912 | No | 3 |
CA | 1912 | Yes | 2 |
CA | 1913 | 0 | |
CA | 1913 | No | 4 |
CA | 1913 | Yes | 1 |
CA | 1914 | No | 2 |
CA | 1914 | Yes | 3 |
CA | 1915 | 0 | |
CA | 1915 | No | 4 |
CA | 1915 | Yes | 3 |
CA | 1916 | 0 | |
CA | 1916 | No | 4 |
CA | 1916 | Yes | 1 |
CA | 1917 | 0 | |
CA | 1917 | No | 8 |
CA | 1917 | Yes | 3 |
CA | 1918 | 0 | |
CA | 1918 | No | 3 |
CA | 1918 | Yes | 1 |
CA | 1919 | No | 2 |
CA | 1920 | Yes | 1 |
CA | 1921 | Yes | 1 |
CH | No | 1 | |
CH | Yes | 1 | |
CH | 1889 | Yes | 1 |
CH | 1890 | No | 1 |
CH | 1891 | 0 | |
CH | 1891 | No | 1 |
CH | 1891 | Yes | 2 |
CH | 1892 | 0 | |
CH | 1893 | No | 1 |
CH | 1893 | Yes | 1 |
CH | 1894 | 0 | |
CH | 1894 | No | 1 |
CH | 1894 | Yes | 1 |
CH | 1896 | Yes | 1 |
CH | 1897 | No | 1 |
CH | 1898 | 0 | |
CH | 1899 | 0 | |
CH | 1900 | 0 | |
CH | 1900 | No | 1 |
CH | 1901 | 0 | |
CH | 1901 | No | 2 |
CH | 1902 | No | 1 |
CH | 1903 | 0 | |
CH | 1903 | Yes | 1 |
CH | 1905 | 0 | |
CH | 1906 | 0 | |
CH | 1907 | 0 | |
CH | 1907 | No | 3 |
CH | 1907 | Yes | 2 |
CH | 1908 | 0 | |
CH | 1908 | No | 1 |
CH | 1908 | Yes | 2 |
CH | 1909 | 0 | |
CH | 1909 | No | 5 |
CH | 1909 | Yes | 5 |
CH | 1910 | 0 | |
CH | 1910 | No | 6 |
CH | 1910 | Yes | 3 |
CH | 1911 | 0 | |
CH | 1911 | No | 1 |
CH | 1911 | Yes | 5 |
CH | 1912 | 0 | |
CH | 1912 | No | 2 |
CH | 1912 | Yes | 2 |
CH | 1913 | 0 | |
CH | 1913 | No | 4 |
CH | 1913 | Yes | 1 |
CH | 1914 | 0 | |
CH | 1914 | No | 2 |
CH | 1915 | 0 | |
CH | 1915 | No | 1 |
CH | 1915 | Yes | 2 |
CH | 1916 | 0 | |
CH | 1916 | No | 1 |
CH | 1916 | Yes | 1 |
CH | 1917 | No | 3 |
CH | 1917 | Yes | 2 |
CH | 1918 | No | 1 |
CH | 1918 | Yes | 1 |
CL | 1902 | 0 | |
CU | 1909 | 0 | |
DE | 0 | ||
DE | No | 153 | |
DE | Yes | 11 | |
DE | 1877 | 0 | |
DE | 1877 | Yes | 2 |
DE | 1878 | 0 | |
DE | 1878 | Yes | 2 |
DE | 1879 | No | 3 |
DE | 1879 | Yes | 4 |
DE | 1880 | No | 3 |
DE | 1880 | Yes | 3 |
DE | 1881 | 0 | |
DE | 1881 | No | 3 |
DE | 1881 | Yes | 6 |
DE | 1882 | 0 | |
DE | 1882 | No | 2 |
DE | 1882 | Yes | 6 |
DE | 1883 | 0 | |
DE | 1883 | No | 2 |
DE | 1883 | Yes | 3 |
DE | 1884 | No | 1 |
DE | 1884 | Yes | 2 |
DE | 1885 | 0 | |
DE | 1885 | Yes | 2 |
DE | 1886 | 0 | |
DE | 1887 | No | 1 |
DE | 1887 | Yes | 3 |
DE | 1888 | 0 | |
DE | 1888 | Yes | 2 |
DE | 1889 | No | 2 |
DE | 1889 | Yes | 5 |
DE | 1890 | No | 2 |
DE | 1890 | Yes | 8 |
DE | 1891 | 0 | |
DE | 1891 | No | 2 |
DE | 1891 | Yes | 5 |
DE | 1892 | 0 | |
DE | 1892 | No | 5 |
DE | 1892 | Yes | 2 |
DE | 1893 | 0 | |
DE | 1893 | No | 15 |
DE | 1893 | Yes | 9 |
DE | 1894 | 0 | |
DE | 1894 | No | 3 |
DE | 1894 | Yes | 12 |
DE | 1895 | 0 | |
DE | 1895 | Yes | 6 |
DE | 1896 | 0 | |
DE | 1896 | No | 2 |
DE | 1896 | Yes | 4 |
DE | 1897 | 0 | |
DE | 1897 | No | 6 |
DE | 1897 | Yes | 1 |
DE | 1898 | 0 | |
DE | 1898 | No | 7 |
DE | 1898 | Yes | 1 |
DE | 1899 | 0 | |
DE | 1899 | No | 6 |
DE | 1899 | Yes | 3 |
DE | 1900 | 0 | |
DE | 1900 | No | 4 |
DE | 1900 | Yes | 5 |
DE | 1901 | 0 | |
DE | 1901 | No | 3 |
DE | 1901 | Yes | 7 |
DE | 1902 | 0 | |
DE | 1902 | No | 5 |
DE | 1902 | Yes | 10 |
DE | 1903 | 0 | |
DE | 1903 | No | 2 |
DE | 1903 | Yes | 1 |
DE | 1904 | 0 | |
DE | 1904 | No | 4 |
DE | 1905 | 0 | |
DE | 1905 | No | 1 |
DE | 1905 | Yes | 5 |
DE | 1906 | 0 | |
DE | 1906 | No | 7 |
DE | 1906 | Yes | 3 |
DE | 1907 | 0 | |
DE | 1907 | No | 13 |
DE | 1907 | Yes | 14 |
DE | 1908 | 0 | |
DE | 1908 | No | 7 |
DE | 1908 | Yes | 25 |
DE | 1909 | 0 | |
DE | 1909 | No | 11 |
DE | 1909 | Yes | 21 |
DE | 1910 | 0 | |
DE | 1910 | No | 7 |
DE | 1910 | Yes | 15 |
DE | 1911 | 0 | |
DE | 1911 | No | 5 |
DE | 1911 | Yes | 8 |
DE | 1912 | 0 | |
DE | 1912 | No | 6 |
DE | 1912 | Yes | 12 |
DE | 1913 | 0 | |
DE | 1913 | No | 11 |
DE | 1913 | Yes | 22 |
DE | 1914 | 0 | |
DE | 1914 | No | 9 |
DE | 1914 | Yes | 12 |
DE | 1915 | 0 | |
DE | 1915 | No | 1 |
DE | 1915 | Yes | 22 |
DE | 1916 | 0 | |
DE | 1916 | No | 15 |
DE | 1916 | Yes | 19 |
DE | 1917 | 0 | |
DE | 1917 | No | 17 |
DE | 1917 | Yes | 19 |
DE | 1918 | 0 | |
DE | 1918 | No | 10 |
DE | 1918 | Yes | 21 |
DE | 1919 | 0 | |
DE | 1919 | Yes | 5 |
DE | 1920 | 0 | |
DE | 1920 | No | 1 |
DE | 1921 | 0 | |
DE | 1921 | Yes | 3 |
DE | 1922 | 0 | |
DE | 1922 | Yes | 3 |
DE | 1924 | Yes | 1 |
DE | 1928 | No | 1 |
DE | 2019 | 0 | |
DEG | 1899 | 0 | |
DEG | 1900 | 0 | |
DEG | 1903 | 0 | |
DEG | 1907 | 0 | |
DEG | 1908 | 0 | |
DEG | 1909 | Yes | 2 |
DEG | 1912 | Yes | 2 |
DEG | 1913 | 0 | |
DEG | 1913 | Yes | 3 |
DEG | 1914 | 0 |
- Counts by First-filing by country and year and relevant-to-aircraft. can transform into xtab and do regressions
Office | Year filed | First filing | Related to aircraft | Number of entries |
---|---|---|---|---|
0 | ||||
Yes | 1 | |||
No | 1 | |||
Yes | 1 | 1 | ||
Yes | Yes | 1 | ||
1871 | No | No | 1 | |
1909 | Yes | 1 | 1 | |
1912 | No | 1 | ||
?? | 1 | 0 | ||
?? | Yes | 0 | ||
AH | Yes | 0 | ||
AH | 1890 | Yes | 1 | 1 |
AT | No | No | 1 | |
AT | 1884 | Yes | Yes | 1 |
AT | 1898 | 1 | 0 | |
AT | 1899 | 1 | 0 | |
AT | 1899 | No | 1 | 1 |
AT | 1899 | No | Yes | 1 |
AT | 1900 | 1 | 0 | |
AT | 1900 | No | Yes | 2 |
AT | 1901 | Yes | 0 | 1 |
AT | 1901 | 1 | 0 | |
AT | 1901 | Yes | 1 | 1 |
AT | 1901 | No | Yes | 2 |
AT | 1902 | 1 | 0 | |
AT | 1902 | No | 1 | 3 |
AT | 1902 | Yes | 1 | 1 |
AT | 1903 | No | 1 | 1 |
AT | 1903 | 1 | 0 | |
AT | 1903 | Yes | 1 | 1 |
AT | 1903 | No | Yes | 1 |
AT | 1904 | No | 1 | 2 |
AT | 1904 | Yes | 1 | 1 |
AT | 1904 | 1 | 0 | |
AT | 1905 | 1 | 0 | |
AT | 1905 | Yes | 0 | |
AT | 1905 | No | Yes | 1 |
AT | 1906 | No | 1 | 1 |
AT | 1906 | Yes | 1 | 1 |
AT | 1906 | 1 | 0 | |
AT | 1907 | 1 | 0 | |
AT | 1907 | No | 1 | 1 |
AT | 1907 | Yes | 1 | 2 |
AT | 1907 | Yes | Yes | 1 |
AT | 1908 | No | 1 | |
AT | 1908 | No | .5 | 1 |
AT | 1908 | No | 0.5 | 1 |
AT | 1908 | 1 | 0 | |
AT | 1908 | No | 1 | 4 |
AT | 1908 | Yes | 1 | 2 |
AT | 1908 | No | Yes | 2 |
AT | 1908 | Yes | Yes | 6 |
AT | 1909 | Yes | 0 | 1 |
AT | 1909 | Yes | 1 | 7 |
AT | 1909 | No | 1 | 5 |
AT | 1909 | 1 | 0 | |
AT | 1909 | 1/2 | 0 | |
AT | 1909 | No | No | 1 |
AT | 1909 | No | 0 | |
AT | 1909 | No | Yes | 3 |
AT | 1909 | Yes | Yes | 2 |
AT | 1909 | Yes | 0 | |
AT | 1910 | No | 1 | |
AT | 1910 | Yes | 1 | 9 |
AT | 1910 | 1 | 0 | |
AT | 1910 | No | 1 | 10 |
AT | 1910 | No | Yes | 5 |
AT | 1910 | Yes | Yes | 1 |
AT | 1911 | No | 1 | |
AT | 1911 | 1 | 0 | |
AT | 1911 | No | 1 | 4 |
AT | 1911 | Yes | 1 | 5 |
AT | 1911 | 1/2 | 0 | |
AT | 1911 | No | Yes | 2 |
AT | 1912 | -1 | 0 | |
AT | 1912 | Yes | 1 | 9 |
AT | 1912 | No | 1 | 5 |
AT | 1912 | 1 | 0 | |
AT | 1912 | Yes | 0 | |
AT | 1912 | No | Yes | 3 |
AT | 1913 | 1 | 0 | |
AT | 1913 | No | 1 | 11 |
AT | 1913 | Yes | 1 | 3 |
AT | 1913 | No | Yes | 7 |
AT | 1913 | Yes | Yes | 5 |
AT | 1914 | Yes | 1 | 1 |
AT | 1914 | 1 | 0 | |
AT | 1914 | No | 1 | 2 |
AT | 1914 | Yes | Yes | 2 |
AT | 1914 | Yes | 0 | |
AT | 1915 | Yes | 1 | 4 |
AT | 1915 | 1 | 0 | |
AT | 1915 | No | 1 | 5 |
AT | 1915 | 1/2 | 0 | |
AT | 1915 | No | Yes | 1 |
AT | 1915 | Yes | Yes | 3 |
AT | 1916 | Yes | 1 | 4 |
AT | 1916 | 1 | 0 | |
AT | 1916 | Yes | Yes | 1 |
AT | 1916 | No | Yes | 2 |
AT | 1917 | 0 | ||
AT | 1917 | Yes | 1 | 6 |
AT | 1917 | No | 1 | 1 |
AT | 1917 | 1 | 0 | |
AT | 1917 | Yes | Yes | 1 |
AT | 1917 | Yes | 0 | |
AT | 1917 | No | Yes | 3 |
AT | 1918 | 1 | 0 | |
AT | 1918 | Yes | 0 | |
AT | 1918 | Yes | Yes | 1 |
AT | 1919 | No | 1 | 1 |
AT | 1920 | Yes | 0 | |
AU | 1904 | 1 | 0 | |
AU | 1905 | Yes | .5 | 1 |
AU | 1908 | 1 | 0 | |
AU | 1909 | 1 | 0 | |
AU | 1909 | Yes | 1 | 1 |
AU | 1909 | No | 1 | 2 |
AU | 1909 | No | Yes | 1 |
AU | 1910 | 1 | 0 | |
AU | 1910 | No | Yes | 1 |
AU | 1911 | 0.5 | 0 | |
AU | 1911 | 1 | 0 | |
AU | 1911 | No | Yes | 1 |
AU | 1911 | Yes | Yes | 1 |
AU | 1912 | 1 | 0 | |
AU | 1912 | Yes | 0 | |
AU | 1912 | No | Yes | 2 |
AU | 1913 | 1 | 0 | |
AU | 1913 | Yes | 1 | 1 |
AU | 1913 | No | Yes | 1 |
AU | 1914 | Yes | 1 | 1 |
AU | 1914 | No | 1 | 1 |
AU | 1914 | 1 | 0 | |
AU | 1914 | No | Yes | 1 |
AU | 1916 | 1 | 0 | |
AU | 1916 | Yes | 1 | 2 |
AU | 1917 | No | 1 | 4 |
AU | 1917 | Yes | 1 | 1 |
AU | 1918 | 1 | 0 | |
AU | 1919 | No | 1 | 1 |
AU | 1920 | Yes | 1 | 2 |
BE | No | 1 | ||
BE | No | Yes | 6 | |
BE | 1831 | No | Yes | 1 |
BE | 1835 | No | 1 | |
BE | 1851 | No | No | 1 |
BE | 1851 | No | Partially | 1 |
BE | 1855 | No | Yes | 1 |
BE | 1860 | No | No | 2 |
BE | 1860 | No | Partially | 1 |
BE | 1885 | No | Yes | 1 |
BE | 1887 | No | 1 | 1 |
BE | 1897 | No | Yes | 1 |
BE | 1900 | Yes | 1 | 3 |
BE | 1900 | 1 | 0 | |
BE | 1900 | No | Yes | 1 |
BE | 1904 | No | Yes | 1 |
BE | 1906 | Yes | Yes | 1 |
BE | 1907 | 1 | 0 | |
BE | 1907 | Yes | 1 | 8 |
BE | 1907 | No | 1 | 1 |
BE | 1907 | No | Yes | 7 |
BE | 1907 | Yes | Yes | 2 |
BE | 1908 | 1 | 0 | |
BE | 1909 | Yes | 1 | 4 |
BE | 1909 | 1 | 0 | |
BE | 1909 | No | Yes | 28 |
BE | 1910 | Yes | 1 | 4 |
BE | 1910 | 1 | 0 | |
BE | 1910 | No | Yes | 29 |
BE | 1911 | 1 | 0 | |
BE | 1911 | Yes | 1 | 2 |
BE | 1911 | No | Yes | 9 |
BE | 1911 | Yes | Yes | 3 |
BE | 1912 | 1 | 0 | |
BE | 1912 | Yes | 1 | 5 |
BE | 1912 | Yes | Yes | 5 |
BE | 1912 | No | Yes | 12 |
BE | 1912 | Yes | 0 | |
BE | 1913 | No | 1 | 2 |
BE | 1913 | 1 | 0 | |
BE | 1913 | Yes | 1 | 4 |
BE | 1913 | Yes | Yes | 1 |
BE | 1913 | Yes | 0 | |
BE | 1913 | No | Yes | 6 |
BE | 1914 | No | 1 | |
BE | 1914 | -1 | 0 | |
BE | 1914 | No | 1 | 3 |
BE | 1914 | Yes | 1 | 35 |
BE | 1914 | 1 | 0 | |
BE | 1914 | No | No | 1 |
BE | 1914 | No | Yes | 14 |
BE | 1914 | Yes | Yes | 11 |
BE | 1915 | No | 1 | |
BE | 1915 | -1 | 0 | |
BE | 1915 | 1 | 0 | |
BE | 1915 | No | Yes | 2 |
BE | 1915 | yes | 0 | |
BE | 1916 | -1 | 0 | |
BE | 1916 | 1 | 0 | |
BE | 1916 | No | Yes | 1 |
BE | 1916 | yes | 0 | |
BE | 1926 | No | Yes | 1 |
CA | No | 1 | ||
CA | .5 | 0 | ||
CA | 1 | 0 | ||
CA | Yes | 1 | 2 | |
CA | No | Yes | 1 | |
CA | 1871 | 1 | 0 | |
CA | 1878 | 1 | 0 | |
CA | 1880 | Yes | Yes | 1 |
CA | 1881 | Yes | 1 | 1 |
CA | 1881 | 1 | 0 | |
CA | 1881 | Yes | Yes | 1 |
CA | 1883 | Yes | 1 | 1 |
CA | 1886 | Yes | Yes | 1 |
CA | 1889 | Yes | 1 | 1 |
CA | 1890 | Yes | 1 | 1 |
CA | 1892 | No | 1 | 1 |
CA | 1893 | 1 | 0 | |
CA | 1894 | Yes | 0 | 1 |
CA | 1894 | Yes | 1 | 1 |
CA | 1897 | No | Yes | 1 |
CA | 1898 | Yes | 1 | 1 |
CA | 1899 | No | 1 | 1 |
CA | 1899 | 1 | 0 | |
CA | 1900 | 1 | 0 | |
CA | 1901 | 1 | 0 | |
CA | 1901 | No | 1 | 1 |
CA | 1902 | -1 | 0 | |
CA | 1902 | No | 1 | 1 |
CA | 1902 | 1 | 0 | |
CA | 1903 | No | Yes | 1 |
CA | 1904 | No | 0 | 1 |
CA | 1904 | Yes | 0 | 1 |
CA | 1904 | Yes | 1 | 1 |
CA | 1905 | Yes | 0 | 1 |
CA | 1905 | 1 | 0 | |
CA | 1905 | No | Yes | 1 |
CA | 1907 | 1 | 0 | |
CA | 1907 | Yes | 1 | 1 |
CA | 1908 | Yes | 1 | 1 |
CA | 1908 | No | 1 | 1 |
CA | 1908 | Yes | Yes | 1 |
CA | 1909 | -1 | 0 | |
CA | 1909 | Yes | 1 | 2 |
CA | 1909 | No | 1 | 6 |
CA | 1909 | 1 | 0 | |
CA | 1909 | No | Yes | 2 |
CA | 1910 | 1 | 0 | |
CA | 1910 | Yes | 1 | 2 |
CA | 1910 | No | 1 | 3 |
CA | 1910 | No | Yes | 3 |
CA | 1910 | Yes | Yes | 1 |
CA | 1911 | No | 1 | |
CA | 1911 | Yes | 1 | 2 |
CA | 1911 | 1 | 0 | |
CA | 1911 | No | 1 | 2 |
CA | 1911 | yes | 0 | |
CA | 1911 | No | Yes | 2 |
CA | 1912 | 1 | 0 | |
CA | 1912 | Yes | 1 | 2 |
CA | 1912 | No | 1 | 2 |
CA | 1912 | No | Partially | 1 |
CA | 1913 | -1 | 0 | |
CA | 1913 | No | 1 | 4 |
CA | 1913 | 1 | 0 | |
CA | 1913 | Yes | 1 | 1 |
CA | 1914 | No | 1 | 2 |
CA | 1914 | Yes | 1 | 3 |
CA | 1915 | Yes | 1 | 3 |
CA | 1915 | No | 1 | 4 |
CA | 1915 | 1 | 0 | |
CA | 1915 | Yes | 0 | |
CA | 1916 | No | 1 | 4 |
CA | 1916 | Yes | 1 | 1 |
CA | 1916 | 1 | 0 | |
CA | 1917 | Yes | 1 | 2 |
CA | 1917 | No | 1 | 8 |
CA | 1917 | 1 | 0 | |
CA | 1917 | Yes | Yes | 1 |
CA | 1918 | 1 | 0 | |
CA | 1918 | No | 1 | 1 |
CA | 1918 | Yes | 1 | 1 |
CA | 1918 | Yes | 0 | |
CA | 1918 | No | Yes | 2 |
CA | 1919 | No | 1 | 2 |
CA | 1920 | Yes | .5 | 1 |
CA | 1921 | Yes | 1 | 1 |
CH | Yes | 1 | 1 | |
CH | No | 1 | 1 | |
CH | 1889 | Yes | 0.5 | 1 |
CH | 1890 | No | 1 | 1 |
CH | 1891 | 0 | 0 | |
CH | 1891 | Yes | 0 | 2 |
CH | 1891 | 1 | 0 | |
CH | 1891 | No | Yes | 1 |
CH | 1892 | 1 | 0 | |
CH | 1893 | Yes | 0 | 1 |
CH | 1893 | No | Yes | 1 |
CH | 1894 | Yes | 0 | 1 |
CH | 1894 | 1 | 0 | |
CH | 1894 | No | Yes | 1 |
CH | 1896 | Yes | .5 | 1 |
CH | 1897 | No | Yes | 1 |
CH | 1898 | 1 | 0 | |
CH | 1899 | 1 | 0 | |
CH | 1900 | 1 | 0 | |
CH | 1900 | No | Yes | 1 |
CH | 1901 | 1 | 0 | |
CH | 1901 | No | Yes | 2 |
CH | 1902 | No | Yes | 1 |
CH | 1903 | Yes | 1 | 1 |
CH | 1903 | 1 | 0 | |
CH | 1905 | 1 | 0 | |
CH | 1906 | 1 | 0 | |
CH | 1907 | No | 1 | 3 |
CH | 1907 | 1 | 0 | |
CH | 1907 | Yes | 1 | 2 |
CH | 1908 | Yes | .5 | 1 |
CH | 1908 | No | 1 | 1 |
CH | 1908 | 1 | 0 | |
CH | 1908 | Yes | Yes | 1 |
CH | 1909 | No | 1 | 4 |
CH | 1909 | Yes | 1 | 5 |
CH | 1909 | 1 | 0 | |
CH | 1909 | Yes | 0 | |
CH | 1909 | No | Yes | 1 |
CH | 1910 | No | 1 | 3 |
CH | 1910 | 1 | 0 | |
CH | 1910 | Yes | 1 | 2 |
CH | 1910 | Yes | 0 | |
CH | 1910 | No | Yes | 3 |
CH | 1910 | Yes | Yes | 1 |
CH | 1911 | No | 1 | |
CH | 1911 | 1 | 0 | |
CH | 1911 | Yes | 1 | 4 |
CH | 1911 | Yes | yes | 1 |
CH | 1912 | 0 | ||
CH | 1912 | 1 | 0 | |
CH | 1912 | Yes | 1 | 2 |
CH | 1912 | No | 1 | 2 |
CH | 1912 | Partially | 0 | |
CH | 1913 | No | 1 | |
CH | 1913 | Yes | 1 | 1 |
CH | 1913 | 1 | 0 | |
CH | 1913 | No | 1 | 1 |
CH | 1913 | No | Yes | 2 |
CH | 1914 | 1 | 0 | |
CH | 1914 | No | Yes | 2 |
CH | 1915 | 1 | 0 | |
CH | 1915 | No | Yes | 1 |
CH | 1915 | Yes | Yes | 2 |
CH | 1916 | Yes | 1 | 1 |
CH | 1916 | 1 | 0 | |
CH | 1916 | No | Yes | 1 |
CH | 1917 | Yes | 1 | 2 |
CH | 1917 | No | 1 | 2 |
CH | 1917 | No | Yes | 1 |
CH | 1918 | No | 1 | 1 |
CH | 1918 | Yes | Yes | 1 |
CL | 1902 | 1 | 0 | |
CU | 1909 | 1 | 0 | |
DE | 0 | |||
DE | 0.5 | 0 | ||
DE | No | 1 | 107 | |
DE | Yes | 1 | 4 | |
DE | 1 | 0 | ||
DE | No | No | 6 | |
DE | No | 0 | ||
DE | No | Partially | 1 | |
DE | Yes | Yes | 7 | |
DE | Yes | 0 | ||
DE | No | Yes | 39 | |
DE | 1877 | 1 | 0 | |
DE | 1877 | Yes | No | 1 |
DE | 1877 | Yes | Yes | 1 |
DE | 1878 | 1 | 0 | |
DE | 1878 | Yes | Yes | 2 |
DE | 1879 | Yes | 1 | 1 |
DE | 1879 | No | Yes | 3 |
DE | 1879 | Yes | Yes | 3 |
DE | 1880 | Yes | 0 | 1 |
DE | 1880 | No | Yes | 3 |
DE | 1880 | Yes | Yes | 2 |
DE | 1881 | 1 | 0 | |
DE | 1881 | Yes | 1 | 2 |
DE | 1881 | Yes | No | 1 |
DE | 1881 | Yes | Yes | 3 |
DE | 1881 | No | Yes | 3 |
DE | 1882 | 1 | 0 | |
DE | 1882 | Yes | 1 | 1 |
DE | 1882 | No | Yes | 2 |
DE | 1882 | Yes | Yes | 5 |
DE | 1883 | Yes | Yes | 3 |
DE | 1883 | No | Yes | 2 |
DE | 1883 | Yes | 0 | |
DE | 1884 | Yes | No | 2 |
DE | 1884 | No | Yes | 1 |