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 |
---|---|---|---|---|---|---|---|
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 |
1850988 | 1850988 | 2021-10-25 | Orange | New York | 36071 | 57839 | 775 |
1847738 | 1847738 | 2021-10-24 | Orange | New York | 36071 | 57793 | 773 |
1844488 | 1844488 | 2021-10-23 | Orange | New York | 36071 | 57727 | 772 |
1841238 | 1841238 | 2021-10-22 | Orange | New York | 36071 | 57635 | 771 |
1837989 | 1837989 | 2021-10-21 | Orange | New York | 36071 | 57553 | 771 |
1834740 | 1834740 | 2021-10-20 | Orange | New York | 36071 | 57467 | 770 |
1831491 | 1831491 | 2021-10-19 | Orange | New York | 36071 | 57359 | 770 |
1828242 | 1828242 | 2021-10-18 | Orange | New York | 36071 | 57285 | 768 |
1824993 | 1824993 | 2021-10-17 | Orange | New York | 36071 | 57207 | 768 |
1821744 | 1821744 | 2021-10-16 | Orange | New York | 36071 | 57089 | 767 |
1818495 | 1818495 | 2021-10-15 | Orange | New York | 36071 | 56974 | 767 |
1815246 | 1815246 | 2021-10-14 | Orange | New York | 36071 | 56816 | 767 |
1811998 | 1811998 | 2021-10-13 | Orange | New York | 36071 | 56712 | 767 |
1808749 | 1808749 | 2021-10-12 | Orange | New York | 36071 | 56572 | 766 |
1805498 | 1805498 | 2021-10-11 | Orange | New York | 36071 | 56504 | 764 |
1802249 | 1802249 | 2021-10-10 | Orange | New York | 36071 | 56379 | 764 |
1799000 | 1799000 | 2021-10-09 | Orange | New York | 36071 | 56314 | 764 |
1795751 | 1795751 | 2021-10-08 | Orange | New York | 36071 | 56195 | 764 |
1792502 | 1792502 | 2021-10-07 | Orange | New York | 36071 | 56079 | 764 |
1789253 | 1789253 | 2021-10-06 | Orange | New York | 36071 | 55959 | 764 |
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);