ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Rockland" 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 |
---|---|---|---|---|---|---|---|
2111017 | 2111017 | 2022-01-13 | Rockland | New York | 36087 | 82015 | 830 |
2107765 | 2107765 | 2022-01-12 | Rockland | New York | 36087 | 80991 | 827 |
2104514 | 2104514 | 2022-01-11 | Rockland | New York | 36087 | 79971 | 825 |
2101263 | 2101263 | 2022-01-10 | Rockland | New York | 36087 | 79119 | 821 |
2098012 | 2098012 | 2022-01-09 | Rockland | New York | 36087 | 78478 | 818 |
2094760 | 2094760 | 2022-01-08 | Rockland | New York | 36087 | 77349 | 816 |
2091508 | 2091508 | 2022-01-07 | Rockland | New York | 36087 | 75775 | 814 |
2088257 | 2088257 | 2022-01-06 | Rockland | New York | 36087 | 74264 | 813 |
2085005 | 2085005 | 2022-01-05 | Rockland | New York | 36087 | 72914 | 811 |
2081753 | 2081753 | 2022-01-04 | Rockland | New York | 36087 | 71182 | 810 |
2078501 | 2078501 | 2022-01-03 | Rockland | New York | 36087 | 69935 | 808 |
2075250 | 2075250 | 2022-01-02 | Rockland | New York | 36087 | 69087 | 807 |
2071999 | 2071999 | 2022-01-01 | Rockland | New York | 36087 | 68241 | 806 |
2068748 | 2068748 | 2021-12-31 | Rockland | New York | 36087 | 66565 | 805 |
2065497 | 2065497 | 2021-12-30 | Rockland | New York | 36087 | 65029 | 803 |
2062247 | 2062247 | 2021-12-29 | Rockland | New York | 36087 | 63822 | 802 |
2058998 | 2058998 | 2021-12-28 | Rockland | New York | 36087 | 62396 | 799 |
2055749 | 2055749 | 2021-12-27 | Rockland | New York | 36087 | 61717 | 799 |
2052499 | 2052499 | 2021-12-26 | Rockland | New York | 36087 | 61500 | 798 |
2049249 | 2049249 | 2021-12-25 | Rockland | New York | 36087 | 60364 | 796 |
2045999 | 2045999 | 2021-12-24 | Rockland | New York | 36087 | 60364 | 796 |
2042749 | 2042749 | 2021-12-23 | Rockland | New York | 36087 | 59723 | 796 |
2039500 | 2039500 | 2021-12-22 | Rockland | New York | 36087 | 59161 | 795 |
2036250 | 2036250 | 2021-12-21 | Rockland | New York | 36087 | 58781 | 793 |
2033000 | 2033000 | 2021-12-20 | Rockland | New York | 36087 | 58489 | 792 |
2029750 | 2029750 | 2021-12-19 | Rockland | New York | 36087 | 58283 | 790 |
2026499 | 2026499 | 2021-12-18 | Rockland | New York | 36087 | 58012 | 788 |
2023248 | 2023248 | 2021-12-17 | Rockland | New York | 36087 | 57706 | 788 |
2019997 | 2019997 | 2021-12-16 | Rockland | New York | 36087 | 57487 | 787 |
2016746 | 2016746 | 2021-12-15 | Rockland | New York | 36087 | 57289 | 787 |
2013496 | 2013496 | 2021-12-14 | Rockland | New York | 36087 | 57095 | 786 |
2010245 | 2010245 | 2021-12-13 | Rockland | New York | 36087 | 56975 | 785 |
2006994 | 2006994 | 2021-12-12 | Rockland | New York | 36087 | 56856 | 785 |
2003743 | 2003743 | 2021-12-11 | Rockland | New York | 36087 | 56757 | 785 |
2000492 | 2000492 | 2021-12-10 | Rockland | New York | 36087 | 56632 | 785 |
1997242 | 1997242 | 2021-12-09 | Rockland | New York | 36087 | 56511 | 784 |
1993991 | 1993991 | 2021-12-08 | Rockland | New York | 36087 | 56362 | 783 |
1990740 | 1990740 | 2021-12-07 | Rockland | New York | 36087 | 56262 | 783 |
1987489 | 1987489 | 2021-12-06 | Rockland | New York | 36087 | 56166 | 783 |
1984239 | 1984239 | 2021-12-05 | Rockland | New York | 36087 | 56085 | 783 |
1980989 | 1980989 | 2021-12-04 | Rockland | New York | 36087 | 55960 | 783 |
1977739 | 1977739 | 2021-12-03 | Rockland | New York | 36087 | 55844 | 783 |
1974489 | 1974489 | 2021-12-02 | Rockland | New York | 36087 | 55730 | 783 |
1971240 | 1971240 | 2021-12-01 | Rockland | New York | 36087 | 55617 | 783 |
1967990 | 1967990 | 2021-11-30 | Rockland | New York | 36087 | 55509 | 783 |
1964739 | 1964739 | 2021-11-29 | Rockland | New York | 36087 | 55405 | 783 |
1961487 | 1961487 | 2021-11-28 | Rockland | New York | 36087 | 55357 | 783 |
1958236 | 1958236 | 2021-11-27 | Rockland | New York | 36087 | 55272 | 783 |
1954985 | 1954985 | 2021-11-26 | Rockland | New York | 36087 | 55201 | 782 |
1951734 | 1951734 | 2021-11-25 | Rockland | New York | 36087 | 55139 | 782 |
1948483 | 1948483 | 2021-11-24 | Rockland | New York | 36087 | 55056 | 782 |
1945232 | 1945232 | 2021-11-23 | Rockland | New York | 36087 | 54984 | 782 |
1941981 | 1941981 | 2021-11-22 | Rockland | New York | 36087 | 54921 | 782 |
1938731 | 1938731 | 2021-11-21 | Rockland | New York | 36087 | 54877 | 782 |
1935481 | 1935481 | 2021-11-20 | Rockland | New York | 36087 | 54824 | 782 |
1932231 | 1932231 | 2021-11-19 | Rockland | New York | 36087 | 54756 | 782 |
1928980 | 1928980 | 2021-11-18 | Rockland | New York | 36087 | 54686 | 782 |
1925730 | 1925730 | 2021-11-17 | Rockland | New York | 36087 | 54607 | 782 |
1922481 | 1922481 | 2021-11-16 | Rockland | New York | 36087 | 54533 | 782 |
1919231 | 1919231 | 2021-11-15 | Rockland | New York | 36087 | 54467 | 782 |
1915981 | 1915981 | 2021-11-14 | Rockland | New York | 36087 | 54425 | 782 |
1912731 | 1912731 | 2021-11-13 | Rockland | New York | 36087 | 54375 | 782 |
1909481 | 1909481 | 2021-11-12 | Rockland | New York | 36087 | 54317 | 782 |
1906232 | 1906232 | 2021-11-11 | Rockland | New York | 36087 | 54249 | 782 |
1902983 | 1902983 | 2021-11-10 | Rockland | New York | 36087 | 54181 | 782 |
1899733 | 1899733 | 2021-11-09 | Rockland | New York | 36087 | 54130 | 782 |
1896483 | 1896483 | 2021-11-08 | Rockland | New York | 36087 | 54068 | 780 |
1893233 | 1893233 | 2021-11-07 | Rockland | New York | 36087 | 54049 | 780 |
1889983 | 1889983 | 2021-11-06 | Rockland | New York | 36087 | 54014 | 780 |
1886733 | 1886733 | 2021-11-05 | Rockland | New York | 36087 | 53959 | 780 |
1883484 | 1883484 | 2021-11-04 | Rockland | New York | 36087 | 53878 | 780 |
1880235 | 1880235 | 2021-11-03 | Rockland | New York | 36087 | 53822 | 780 |
1876986 | 1876986 | 2021-11-02 | Rockland | New York | 36087 | 53765 | 780 |
1873737 | 1873737 | 2021-11-01 | Rockland | New York | 36087 | 53719 | 780 |
1870488 | 1870488 | 2021-10-31 | Rockland | New York | 36087 | 53682 | 780 |
1867239 | 1867239 | 2021-10-30 | Rockland | New York | 36087 | 53632 | 780 |
1863990 | 1863990 | 2021-10-29 | Rockland | New York | 36087 | 53571 | 780 |
1860741 | 1860741 | 2021-10-28 | Rockland | New York | 36087 | 53518 | 779 |
1857492 | 1857492 | 2021-10-27 | Rockland | New York | 36087 | 53426 | 779 |
1854243 | 1854243 | 2021-10-26 | Rockland | New York | 36087 | 53368 | 779 |
1850994 | 1850994 | 2021-10-25 | Rockland | New York | 36087 | 53317 | 779 |
1847744 | 1847744 | 2021-10-24 | Rockland | New York | 36087 | 53278 | 779 |
1844494 | 1844494 | 2021-10-23 | Rockland | New York | 36087 | 53233 | 779 |
1841244 | 1841244 | 2021-10-22 | Rockland | New York | 36087 | 53178 | 779 |
1837995 | 1837995 | 2021-10-21 | Rockland | New York | 36087 | 53112 | 779 |
1834746 | 1834746 | 2021-10-20 | Rockland | New York | 36087 | 53047 | 779 |
1831497 | 1831497 | 2021-10-19 | Rockland | New York | 36087 | 52979 | 779 |
1828248 | 1828248 | 2021-10-18 | Rockland | New York | 36087 | 52918 | 779 |
1824999 | 1824999 | 2021-10-17 | Rockland | New York | 36087 | 52859 | 779 |
1821750 | 1821750 | 2021-10-16 | Rockland | New York | 36087 | 52800 | 779 |
1818501 | 1818501 | 2021-10-15 | Rockland | New York | 36087 | 52711 | 777 |
1815252 | 1815252 | 2021-10-14 | Rockland | New York | 36087 | 52635 | 777 |
1812004 | 1812004 | 2021-10-13 | Rockland | New York | 36087 | 52558 | 777 |
1808755 | 1808755 | 2021-10-12 | Rockland | New York | 36087 | 52466 | 777 |
1805504 | 1805504 | 2021-10-11 | Rockland | New York | 36087 | 52412 | 776 |
1802255 | 1802255 | 2021-10-10 | Rockland | New York | 36087 | 52312 | 774 |
1799006 | 1799006 | 2021-10-09 | Rockland | New York | 36087 | 52270 | 773 |
1795757 | 1795757 | 2021-10-08 | Rockland | New York | 36087 | 52185 | 773 |
1792508 | 1792508 | 2021-10-07 | Rockland | New York | 36087 | 52101 | 773 |
1789259 | 1789259 | 2021-10-06 | Rockland | New York | 36087 | 51974 | 773 |
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);