ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Onondaga" 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 |
---|---|---|---|---|---|---|---|
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 |
1850986 | 1850986 | 2021-10-25 | Onondaga | New York | 36067 | 52624 | 765 |
1847736 | 1847736 | 2021-10-24 | Onondaga | New York | 36067 | 52461 | 765 |
1844486 | 1844486 | 2021-10-23 | Onondaga | New York | 36067 | 52355 | 765 |
1841236 | 1841236 | 2021-10-22 | Onondaga | New York | 36067 | 52166 | 762 |
1837987 | 1837987 | 2021-10-21 | Onondaga | New York | 36067 | 52054 | 761 |
1834738 | 1834738 | 2021-10-20 | Onondaga | New York | 36067 | 51911 | 760 |
1831489 | 1831489 | 2021-10-19 | Onondaga | New York | 36067 | 51689 | 758 |
1828240 | 1828240 | 2021-10-18 | Onondaga | New York | 36067 | 51624 | 757 |
1824991 | 1824991 | 2021-10-17 | Onondaga | New York | 36067 | 51456 | 755 |
1821742 | 1821742 | 2021-10-16 | Onondaga | New York | 36067 | 51242 | 755 |
1818493 | 1818493 | 2021-10-15 | Onondaga | New York | 36067 | 50966 | 753 |
1815244 | 1815244 | 2021-10-14 | Onondaga | New York | 36067 | 50637 | 751 |
1811996 | 1811996 | 2021-10-13 | Onondaga | New York | 36067 | 50426 | 749 |
1808747 | 1808747 | 2021-10-12 | Onondaga | New York | 36067 | 50231 | 746 |
1805496 | 1805496 | 2021-10-11 | Onondaga | New York | 36067 | 50137 | 744 |
1802247 | 1802247 | 2021-10-10 | Onondaga | New York | 36067 | 49878 | 744 |
1798998 | 1798998 | 2021-10-09 | Onondaga | New York | 36067 | 49737 | 744 |
1795749 | 1795749 | 2021-10-08 | Onondaga | New York | 36067 | 49517 | 743 |
1792500 | 1792500 | 2021-10-07 | Onondaga | New York | 36067 | 49204 | 739 |
1789251 | 1789251 | 2021-10-06 | Onondaga | New York | 36067 | 49000 | 738 |
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);