ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36067 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176075 | 2176075 | 2022-02-02 | Onondaga | New York | 36067 | 102848 | 980 |
2172822 | 2172822 | 2022-02-01 | Onondaga | New York | 36067 | 102348 | 975 |
2169569 | 2169569 | 2022-01-31 | Onondaga | New York | 36067 | 102108 | 974 |
2166314 | 2166314 | 2022-01-30 | Onondaga | New York | 36067 | 101867 | 974 |
2163059 | 2163059 | 2022-01-29 | Onondaga | New York | 36067 | 101518 | 969 |
2159804 | 2159804 | 2022-01-28 | Onondaga | New York | 36067 | 100975 | 966 |
2156549 | 2156549 | 2022-01-27 | Onondaga | New York | 36067 | 100596 | 960 |
2153296 | 2153296 | 2022-01-26 | Onondaga | New York | 36067 | 99999 | 958 |
2150044 | 2150044 | 2022-01-25 | Onondaga | New York | 36067 | 99337 | 955 |
2146792 | 2146792 | 2022-01-24 | Onondaga | New York | 36067 | 98669 | 952 |
2143538 | 2143538 | 2022-01-23 | Onondaga | New York | 36067 | 98269 | 948 |
2140283 | 2140283 | 2022-01-22 | Onondaga | New York | 36067 | 97726 | 944 |
2137027 | 2137027 | 2022-01-21 | Onondaga | New York | 36067 | 96720 | 939 |
2133774 | 2133774 | 2022-01-20 | Onondaga | New York | 36067 | 95860 | 935 |
2130522 | 2130522 | 2022-01-19 | Onondaga | New York | 36067 | 94516 | 931 |
2127268 | 2127268 | 2022-01-18 | Onondaga | New York | 36067 | 93776 | 927 |
2124016 | 2124016 | 2022-01-17 | Onondaga | New York | 36067 | 93076 | 924 |
2120764 | 2120764 | 2022-01-16 | Onondaga | New York | 36067 | 92358 | 923 |
2117512 | 2117512 | 2022-01-15 | Onondaga | New York | 36067 | 91347 | 922 |
2114261 | 2114261 | 2022-01-14 | Onondaga | New York | 36067 | 89688 | 919 |
2111009 | 2111009 | 2022-01-13 | Onondaga | New York | 36067 | 88707 | 915 |
2107757 | 2107757 | 2022-01-12 | Onondaga | New York | 36067 | 87307 | 910 |
2104506 | 2104506 | 2022-01-11 | Onondaga | New York | 36067 | 85964 | 908 |
2101255 | 2101255 | 2022-01-10 | Onondaga | New York | 36067 | 84975 | 905 |
2098004 | 2098004 | 2022-01-09 | Onondaga | New York | 36067 | 83866 | 904 |
2094752 | 2094752 | 2022-01-08 | Onondaga | New York | 36067 | 82087 | 902 |
2091500 | 2091500 | 2022-01-07 | Onondaga | New York | 36067 | 80188 | 897 |
2088249 | 2088249 | 2022-01-06 | Onondaga | New York | 36067 | 78104 | 893 |
2084997 | 2084997 | 2022-01-05 | Onondaga | New York | 36067 | 76730 | 891 |
2081745 | 2081745 | 2022-01-04 | Onondaga | New York | 36067 | 74960 | 891 |
2078493 | 2078493 | 2022-01-03 | Onondaga | New York | 36067 | 73874 | 891 |
2075242 | 2075242 | 2022-01-02 | Onondaga | New York | 36067 | 72921 | 887 |
2071991 | 2071991 | 2022-01-01 | Onondaga | New York | 36067 | 72173 | 885 |
2068740 | 2068740 | 2021-12-31 | Onondaga | New York | 36067 | 70960 | 882 |
2065489 | 2065489 | 2021-12-30 | Onondaga | New York | 36067 | 69885 | 880 |
2062239 | 2062239 | 2021-12-29 | Onondaga | New York | 36067 | 69041 | 880 |
2058990 | 2058990 | 2021-12-28 | Onondaga | New York | 36067 | 68287 | 878 |
2055741 | 2055741 | 2021-12-27 | Onondaga | New York | 36067 | 67978 | 877 |
2052491 | 2052491 | 2021-12-26 | Onondaga | New York | 36067 | 67800 | 873 |
2049241 | 2049241 | 2021-12-25 | Onondaga | New York | 36067 | 67046 | 871 |
2045991 | 2045991 | 2021-12-24 | Onondaga | New York | 36067 | 67046 | 871 |
2042741 | 2042741 | 2021-12-23 | Onondaga | New York | 36067 | 66615 | 871 |
2039492 | 2039492 | 2021-12-22 | Onondaga | New York | 36067 | 66123 | 869 |
2036242 | 2036242 | 2021-12-21 | Onondaga | New York | 36067 | 65719 | 865 |
2032992 | 2032992 | 2021-12-20 | Onondaga | New York | 36067 | 65494 | 863 |
2029742 | 2029742 | 2021-12-19 | Onondaga | New York | 36067 | 65258 | 861 |
2026491 | 2026491 | 2021-12-18 | Onondaga | New York | 36067 | 64961 | 855 |
2023240 | 2023240 | 2021-12-17 | Onondaga | New York | 36067 | 64567 | 851 |
2019989 | 2019989 | 2021-12-16 | Onondaga | New York | 36067 | 64227 | 849 |
2016738 | 2016738 | 2021-12-15 | Onondaga | New York | 36067 | 63907 | 844 |
2013488 | 2013488 | 2021-12-14 | Onondaga | New York | 36067 | 63582 | 841 |
2010237 | 2010237 | 2021-12-13 | Onondaga | New York | 36067 | 63396 | 839 |
2006986 | 2006986 | 2021-12-12 | Onondaga | New York | 36067 | 63178 | 838 |
2003735 | 2003735 | 2021-12-11 | Onondaga | New York | 36067 | 62935 | 837 |
2000484 | 2000484 | 2021-12-10 | Onondaga | New York | 36067 | 62668 | 832 |
1997234 | 1997234 | 2021-12-09 | Onondaga | New York | 36067 | 62372 | 832 |
1993983 | 1993983 | 2021-12-08 | Onondaga | New York | 36067 | 62018 | 831 |
1990732 | 1990732 | 2021-12-07 | Onondaga | New York | 36067 | 61679 | 829 |
1987481 | 1987481 | 2021-12-06 | Onondaga | New York | 36067 | 61428 | 826 |
1984231 | 1984231 | 2021-12-05 | Onondaga | New York | 36067 | 61261 | 825 |
1980981 | 1980981 | 2021-12-04 | Onondaga | New York | 36067 | 60869 | 824 |
1977731 | 1977731 | 2021-12-03 | Onondaga | New York | 36067 | 60557 | 823 |
1974481 | 1974481 | 2021-12-02 | Onondaga | New York | 36067 | 60114 | 819 |
1971232 | 1971232 | 2021-12-01 | Onondaga | New York | 36067 | 59728 | 818 |
1967982 | 1967982 | 2021-11-30 | Onondaga | New York | 36067 | 59393 | 818 |
1964731 | 1964731 | 2021-11-29 | Onondaga | New York | 36067 | 59188 | 817 |
1961479 | 1961479 | 2021-11-28 | Onondaga | New York | 36067 | 59057 | 816 |
1958228 | 1958228 | 2021-11-27 | Onondaga | New York | 36067 | 58942 | 813 |
1954977 | 1954977 | 2021-11-26 | Onondaga | New York | 36067 | 58795 | 808 |
1951726 | 1951726 | 2021-11-25 | Onondaga | New York | 36067 | 58601 | 808 |
1948475 | 1948475 | 2021-11-24 | Onondaga | New York | 36067 | 58327 | 807 |
1945224 | 1945224 | 2021-11-23 | Onondaga | New York | 36067 | 58070 | 806 |
1941973 | 1941973 | 2021-11-22 | Onondaga | New York | 36067 | 57914 | 806 |
1938723 | 1938723 | 2021-11-21 | Onondaga | New York | 36067 | 57751 | 805 |
1935473 | 1935473 | 2021-11-20 | Onondaga | New York | 36067 | 57449 | 802 |
1932223 | 1932223 | 2021-11-19 | Onondaga | New York | 36067 | 57247 | 801 |
1928972 | 1928972 | 2021-11-18 | Onondaga | New York | 36067 | 56962 | 799 |
1925722 | 1925722 | 2021-11-17 | Onondaga | New York | 36067 | 56645 | 798 |
1922473 | 1922473 | 2021-11-16 | Onondaga | New York | 36067 | 56370 | 798 |
1919223 | 1919223 | 2021-11-15 | Onondaga | New York | 36067 | 56228 | 797 |
1915973 | 1915973 | 2021-11-14 | Onondaga | New York | 36067 | 56093 | 796 |
1912723 | 1912723 | 2021-11-13 | Onondaga | New York | 36067 | 55934 | 794 |
1909473 | 1909473 | 2021-11-12 | Onondaga | New York | 36067 | 55714 | 793 |
1906224 | 1906224 | 2021-11-11 | Onondaga | New York | 36067 | 55512 | 792 |
1902975 | 1902975 | 2021-11-10 | Onondaga | New York | 36067 | 55282 | 791 |
1899725 | 1899725 | 2021-11-09 | Onondaga | New York | 36067 | 55074 | 791 |
1896475 | 1896475 | 2021-11-08 | Onondaga | New York | 36067 | 54953 | 789 |
1893225 | 1893225 | 2021-11-07 | Onondaga | New York | 36067 | 54811 | 787 |
1889975 | 1889975 | 2021-11-06 | Onondaga | New York | 36067 | 54627 | 785 |
1886725 | 1886725 | 2021-11-05 | Onondaga | New York | 36067 | 54461 | 784 |
1883476 | 1883476 | 2021-11-04 | Onondaga | New York | 36067 | 54275 | 780 |
1880227 | 1880227 | 2021-11-03 | Onondaga | New York | 36067 | 54094 | 779 |
1876978 | 1876978 | 2021-11-02 | Onondaga | New York | 36067 | 53927 | 778 |
1873729 | 1873729 | 2021-11-01 | Onondaga | New York | 36067 | 53813 | 777 |
1870480 | 1870480 | 2021-10-31 | Onondaga | New York | 36067 | 53686 | 773 |
1867231 | 1867231 | 2021-10-30 | Onondaga | New York | 36067 | 53532 | 771 |
1863982 | 1863982 | 2021-10-29 | Onondaga | New York | 36067 | 53379 | 771 |
1860733 | 1860733 | 2021-10-28 | Onondaga | New York | 36067 | 53074 | 770 |
1857484 | 1857484 | 2021-10-27 | Onondaga | New York | 36067 | 52942 | 769 |
1854235 | 1854235 | 2021-10-26 | Onondaga | New York | 36067 | 52686 | 768 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);