SELECT "year", SUM("count")
FROM @kaggle.robikscube_us_baby_name_popularity.names
WHERE
"name" = 'Rose'
GROUP by "year"
ORDER by "year" DESC
year | sum(count) |
---|---|
2021 | 2377 |
2020 | 2377 |
2019 | 2522 |
2018 | 2451 |
2017 | 2080 |
2016 | 2039 |
2015 | 1950 |
2014 | 1697 |
2013 | 1427 |
2012 | 1251 |
2011 | 1098 |
2010 | 962 |
2009 | 939 |
2008 | 974 |
2007 | 942 |
2006 | 961 |
2005 | 967 |
2004 | 894 |
2003 | 853 |
2002 | 922 |
2001 | 1029 |
2000 | 1080 |
1999 | 1132 |
1998 | 1019 |
1997 | 666 |
1996 | 703 |
1995 | 787 |
1994 | 791 |
1993 | 749 |
1992 | 864 |
1991 | 894 |
1990 | 901 |
1989 | 905 |
1988 | 877 |
1987 | 836 |
1986 | 832 |
1985 | 978 |
1984 | 1065 |
1983 | 1066 |
1982 | 1107 |
1981 | 1101 |
1980 | 1142 |
1979 | 928 |
1978 | 920 |
1977 | 965 |
1976 | 972 |
1975 | 947 |
1974 | 1064 |
1973 | 1102 |
1972 | 1319 |
1971 | 1441 |
1970 | 1794 |
1969 | 1880 |
1968 | 1961 |
1967 | 2260 |
1966 | 2546 |
1965 | 2876 |
1964 | 3501 |
1963 | 3718 |
1962 | 4027 |
1961 | 4331 |
1960 | 4906 |
1959 | 5466 |
1958 | 6073 |
1957 | 6920 |
1956 | 7359 |
1955 | 7870 |
1954 | 8022 |
1953 | 7027 |
1952 | 6569 |
1951 | 6202 |
1950 | 5391 |
1949 | 5395 |
1948 | 5580 |
1947 | 5673 |
1946 | 5192 |
1945 | 4574 |
1944 | 4722 |
1943 | 5237 |
1942 | 5275 |
1941 | 4989 |
1940 | 5230 |
1939 | 5080 |
1938 | 5329 |
1937 | 5488 |
1936 | 5732 |
1935 | 5264 |
1934 | 5628 |
1933 | 5813 |
1932 | 6518 |
1931 | 6913 |
1930 | 7751 |
1929 | 7837 |
1928 | 8204 |
1927 | 8544 |
1926 | 8555 |
1925 | 8315 |
1924 | 8506 |
1923 | 8471 |
1922 | 8828 |
1921 | 9372 |
1920 | 9035 |
1919 | 9229 |
1918 | 9603 |
1917 | 9821 |
1916 | 9643 |
1915 | 9398 |
1914 | 7612 |
1913 | 6188 |
1912 | 5445 |
1911 | 4173 |
1910 | 3853 |
1909 | 3397 |
1908 | 3405 |
1907 | 3140 |
1906 | 2920 |
1905 | 2741 |
1904 | 2641 |
1903 | 2493 |
1902 | 2451 |
1901 | 2220 |
1900 | 2855 |
1899 | 2210 |
1898 | 2444 |
1897 | 2328 |
1896 | 2351 |
1895 | 2270 |
1894 | 2132 |
1893 | 2020 |
1892 | 2039 |
1891 | 1701 |
1890 | 1733 |
1889 | 1561 |
1888 | 1599 |
1887 | 1248 |
1886 | 1267 |
1885 | 1173 |
1884 | 1065 |
1883 | 882 |
1882 | 886 |
1881 | 734 |
1880 | 707 |