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 |
---|---|---|---|---|---|---|---|
2176083 | 2176083 | 2022-02-02 | Rockland | New York | 36087 | 89813 | 881 |
2172830 | 2172830 | 2022-02-01 | Rockland | New York | 36087 | 89702 | 879 |
2169577 | 2169577 | 2022-01-31 | Rockland | New York | 36087 | 89631 | 877 |
2166322 | 2166322 | 2022-01-30 | Rockland | New York | 36087 | 89532 | 875 |
2163067 | 2163067 | 2022-01-29 | Rockland | New York | 36087 | 89435 | 874 |
2159812 | 2159812 | 2022-01-28 | Rockland | New York | 36087 | 89295 | 872 |
2156557 | 2156557 | 2022-01-27 | Rockland | New York | 36087 | 89063 | 868 |
2153304 | 2153304 | 2022-01-26 | Rockland | New York | 36087 | 88879 | 864 |
2150052 | 2150052 | 2022-01-25 | Rockland | New York | 36087 | 88469 | 861 |
2146800 | 2146800 | 2022-01-24 | Rockland | New York | 36087 | 88325 | 857 |
2143546 | 2143546 | 2022-01-23 | Rockland | New York | 36087 | 88160 | 854 |
2140291 | 2140291 | 2022-01-22 | Rockland | New York | 36087 | 87911 | 852 |
2137035 | 2137035 | 2022-01-21 | Rockland | New York | 36087 | 87552 | 851 |
2133782 | 2133782 | 2022-01-20 | Rockland | New York | 36087 | 87192 | 849 |
2130530 | 2130530 | 2022-01-19 | Rockland | New York | 36087 | 86822 | 848 |
2127276 | 2127276 | 2022-01-18 | Rockland | New York | 36087 | 86360 | 846 |
2124024 | 2124024 | 2022-01-17 | Rockland | New York | 36087 | 85695 | 841 |
2120772 | 2120772 | 2022-01-16 | Rockland | New York | 36087 | 85172 | 840 |
2117520 | 2117520 | 2022-01-15 | Rockland | New York | 36087 | 83819 | 837 |
2114269 | 2114269 | 2022-01-14 | Rockland | New York | 36087 | 82995 | 834 |
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 |
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);