ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36071 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 |
---|---|---|---|---|---|---|---|
2176077 | 2176077 | 2022-02-02 | Orange | New York | 36071 | 103350 | 916 |
2172824 | 2172824 | 2022-02-01 | Orange | New York | 36071 | 103156 | 915 |
2169571 | 2169571 | 2022-01-31 | Orange | New York | 36071 | 102974 | 913 |
2166316 | 2166316 | 2022-01-30 | Orange | New York | 36071 | 102866 | 910 |
2163061 | 2163061 | 2022-01-29 | Orange | New York | 36071 | 102655 | 906 |
2159806 | 2159806 | 2022-01-28 | Orange | New York | 36071 | 102371 | 904 |
2156551 | 2156551 | 2022-01-27 | Orange | New York | 36071 | 102091 | 899 |
2153298 | 2153298 | 2022-01-26 | Orange | New York | 36071 | 101745 | 895 |
2150046 | 2150046 | 2022-01-25 | Orange | New York | 36071 | 101429 | 893 |
2146794 | 2146794 | 2022-01-24 | Orange | New York | 36071 | 101213 | 893 |
2143540 | 2143540 | 2022-01-23 | Orange | New York | 36071 | 100966 | 892 |
2140285 | 2140285 | 2022-01-22 | Orange | New York | 36071 | 100622 | 891 |
2137029 | 2137029 | 2022-01-21 | Orange | New York | 36071 | 100123 | 890 |
2133776 | 2133776 | 2022-01-20 | Orange | New York | 36071 | 99470 | 890 |
2130524 | 2130524 | 2022-01-19 | Orange | New York | 36071 | 98800 | 887 |
2127270 | 2127270 | 2022-01-18 | Orange | New York | 36071 | 98262 | 885 |
2124018 | 2124018 | 2022-01-17 | Orange | New York | 36071 | 97746 | 879 |
2120766 | 2120766 | 2022-01-16 | Orange | New York | 36071 | 97260 | 875 |
2117514 | 2117514 | 2022-01-15 | Orange | New York | 36071 | 96279 | 873 |
2114263 | 2114263 | 2022-01-14 | Orange | New York | 36071 | 95215 | 870 |
2111011 | 2111011 | 2022-01-13 | Orange | New York | 36071 | 94116 | 868 |
2107759 | 2107759 | 2022-01-12 | Orange | New York | 36071 | 92502 | 866 |
2104508 | 2104508 | 2022-01-11 | Orange | New York | 36071 | 91320 | 862 |
2101257 | 2101257 | 2022-01-10 | Orange | New York | 36071 | 90387 | 855 |
2098006 | 2098006 | 2022-01-09 | Orange | New York | 36071 | 89585 | 854 |
2094754 | 2094754 | 2022-01-08 | Orange | New York | 36071 | 87905 | 853 |
2091502 | 2091502 | 2022-01-07 | Orange | New York | 36071 | 85768 | 848 |
2088251 | 2088251 | 2022-01-06 | Orange | New York | 36071 | 84302 | 842 |
2084999 | 2084999 | 2022-01-05 | Orange | New York | 36071 | 82692 | 838 |
2081747 | 2081747 | 2022-01-04 | Orange | New York | 36071 | 81137 | 836 |
2078495 | 2078495 | 2022-01-03 | Orange | New York | 36071 | 80073 | 835 |
2075244 | 2075244 | 2022-01-02 | Orange | New York | 36071 | 79148 | 834 |
2071993 | 2071993 | 2022-01-01 | Orange | New York | 36071 | 77891 | 834 |
2068742 | 2068742 | 2021-12-31 | Orange | New York | 36071 | 76136 | 832 |
2065491 | 2065491 | 2021-12-30 | Orange | New York | 36071 | 74512 | 830 |
2062241 | 2062241 | 2021-12-29 | Orange | New York | 36071 | 72914 | 830 |
2058992 | 2058992 | 2021-12-28 | Orange | New York | 36071 | 71402 | 826 |
2055743 | 2055743 | 2021-12-27 | Orange | New York | 36071 | 70941 | 826 |
2052493 | 2052493 | 2021-12-26 | Orange | New York | 36071 | 70624 | 823 |
2049243 | 2049243 | 2021-12-25 | Orange | New York | 36071 | 69527 | 822 |
2045993 | 2045993 | 2021-12-24 | Orange | New York | 36071 | 69527 | 822 |
2042743 | 2042743 | 2021-12-23 | Orange | New York | 36071 | 68811 | 820 |
2039494 | 2039494 | 2021-12-22 | Orange | New York | 36071 | 68239 | 817 |
2036244 | 2036244 | 2021-12-21 | Orange | New York | 36071 | 67769 | 817 |
2032994 | 2032994 | 2021-12-20 | Orange | New York | 36071 | 67485 | 817 |
2029744 | 2029744 | 2021-12-19 | Orange | New York | 36071 | 67177 | 814 |
2026493 | 2026493 | 2021-12-18 | Orange | New York | 36071 | 66809 | 813 |
2023242 | 2023242 | 2021-12-17 | Orange | New York | 36071 | 66426 | 812 |
2019991 | 2019991 | 2021-12-16 | Orange | New York | 36071 | 66080 | 812 |
2016740 | 2016740 | 2021-12-15 | Orange | New York | 36071 | 65744 | 812 |
2013490 | 2013490 | 2021-12-14 | Orange | New York | 36071 | 65468 | 812 |
2010239 | 2010239 | 2021-12-13 | Orange | New York | 36071 | 65244 | 811 |
2006988 | 2006988 | 2021-12-12 | Orange | New York | 36071 | 65087 | 810 |
2003737 | 2003737 | 2021-12-11 | Orange | New York | 36071 | 64832 | 807 |
2000486 | 2000486 | 2021-12-10 | Orange | New York | 36071 | 64574 | 806 |
1997236 | 1997236 | 2021-12-09 | Orange | New York | 36071 | 64293 | 805 |
1993985 | 1993985 | 2021-12-08 | Orange | New York | 36071 | 64034 | 804 |
1990734 | 1990734 | 2021-12-07 | Orange | New York | 36071 | 63776 | 803 |
1987483 | 1987483 | 2021-12-06 | Orange | New York | 36071 | 63624 | 802 |
1984233 | 1984233 | 2021-12-05 | Orange | New York | 36071 | 63494 | 801 |
1980983 | 1980983 | 2021-12-04 | Orange | New York | 36071 | 63197 | 800 |
1977733 | 1977733 | 2021-12-03 | Orange | New York | 36071 | 63009 | 800 |
1974483 | 1974483 | 2021-12-02 | Orange | New York | 36071 | 62692 | 799 |
1971234 | 1971234 | 2021-12-01 | Orange | New York | 36071 | 62425 | 798 |
1967984 | 1967984 | 2021-11-30 | Orange | New York | 36071 | 62198 | 798 |
1964733 | 1964733 | 2021-11-29 | Orange | New York | 36071 | 62057 | 798 |
1961481 | 1961481 | 2021-11-28 | Orange | New York | 36071 | 61929 | 798 |
1958230 | 1958230 | 2021-11-27 | Orange | New York | 36071 | 61736 | 798 |
1954979 | 1954979 | 2021-11-26 | Orange | New York | 36071 | 61648 | 798 |
1951728 | 1951728 | 2021-11-25 | Orange | New York | 36071 | 61488 | 798 |
1948477 | 1948477 | 2021-11-24 | Orange | New York | 36071 | 61278 | 797 |
1945226 | 1945226 | 2021-11-23 | Orange | New York | 36071 | 61112 | 796 |
1941975 | 1941975 | 2021-11-22 | Orange | New York | 36071 | 61012 | 796 |
1938725 | 1938725 | 2021-11-21 | Orange | New York | 36071 | 60876 | 794 |
1935475 | 1935475 | 2021-11-20 | Orange | New York | 36071 | 60731 | 792 |
1932225 | 1932225 | 2021-11-19 | Orange | New York | 36071 | 60576 | 791 |
1928974 | 1928974 | 2021-11-18 | Orange | New York | 36071 | 60416 | 791 |
1925724 | 1925724 | 2021-11-17 | Orange | New York | 36071 | 60233 | 790 |
1922475 | 1922475 | 2021-11-16 | Orange | New York | 36071 | 60071 | 788 |
1919225 | 1919225 | 2021-11-15 | Orange | New York | 36071 | 59966 | 788 |
1915975 | 1915975 | 2021-11-14 | Orange | New York | 36071 | 59888 | 787 |
1912725 | 1912725 | 2021-11-13 | Orange | New York | 36071 | 59769 | 787 |
1909475 | 1909475 | 2021-11-12 | Orange | New York | 36071 | 59632 | 787 |
1906226 | 1906226 | 2021-11-11 | Orange | New York | 36071 | 59485 | 787 |
1902977 | 1902977 | 2021-11-10 | Orange | New York | 36071 | 59321 | 787 |
1899727 | 1899727 | 2021-11-09 | Orange | New York | 36071 | 59177 | 785 |
1896477 | 1896477 | 2021-11-08 | Orange | New York | 36071 | 59090 | 785 |
1893227 | 1893227 | 2021-11-07 | Orange | New York | 36071 | 59015 | 785 |
1889977 | 1889977 | 2021-11-06 | Orange | New York | 36071 | 58918 | 785 |
1886727 | 1886727 | 2021-11-05 | Orange | New York | 36071 | 58798 | 783 |
1883478 | 1883478 | 2021-11-04 | Orange | New York | 36071 | 58697 | 783 |
1880229 | 1880229 | 2021-11-03 | Orange | New York | 36071 | 58595 | 783 |
1876980 | 1876980 | 2021-11-02 | Orange | New York | 36071 | 58517 | 782 |
1873731 | 1873731 | 2021-11-01 | Orange | New York | 36071 | 58439 | 782 |
1870482 | 1870482 | 2021-10-31 | Orange | New York | 36071 | 58360 | 780 |
1867233 | 1867233 | 2021-10-30 | Orange | New York | 36071 | 58280 | 780 |
1863984 | 1863984 | 2021-10-29 | Orange | New York | 36071 | 58164 | 780 |
1860735 | 1860735 | 2021-10-28 | Orange | New York | 36071 | 58078 | 779 |
1857486 | 1857486 | 2021-10-27 | Orange | New York | 36071 | 57986 | 779 |
1854237 | 1854237 | 2021-10-26 | Orange | New York | 36071 | 57893 | 777 |
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);