ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36031 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 |
---|---|---|---|---|---|---|---|
2176058 | 2176058 | 2022-02-02 | Essex | New York | 36031 | 5147 | 52 |
2172805 | 2172805 | 2022-02-01 | Essex | New York | 36031 | 5133 | 52 |
2169552 | 2169552 | 2022-01-31 | Essex | New York | 36031 | 5115 | 52 |
2166297 | 2166297 | 2022-01-30 | Essex | New York | 36031 | 5098 | 52 |
2163042 | 2163042 | 2022-01-29 | Essex | New York | 36031 | 5070 | 52 |
2159787 | 2159787 | 2022-01-28 | Essex | New York | 36031 | 5022 | 52 |
2156532 | 2156532 | 2022-01-27 | Essex | New York | 36031 | 4985 | 52 |
2153279 | 2153279 | 2022-01-26 | Essex | New York | 36031 | 4951 | 52 |
2150027 | 2150027 | 2022-01-25 | Essex | New York | 36031 | 4911 | 52 |
2146775 | 2146775 | 2022-01-24 | Essex | New York | 36031 | 4897 | 52 |
2143521 | 2143521 | 2022-01-23 | Essex | New York | 36031 | 4880 | 52 |
2140266 | 2140266 | 2022-01-22 | Essex | New York | 36031 | 4829 | 52 |
2137010 | 2137010 | 2022-01-21 | Essex | New York | 36031 | 4765 | 52 |
2133757 | 2133757 | 2022-01-20 | Essex | New York | 36031 | 4728 | 52 |
2130505 | 2130505 | 2022-01-19 | Essex | New York | 36031 | 4677 | 52 |
2127251 | 2127251 | 2022-01-18 | Essex | New York | 36031 | 4639 | 52 |
2123999 | 2123999 | 2022-01-17 | Essex | New York | 36031 | 4626 | 52 |
2120747 | 2120747 | 2022-01-16 | Essex | New York | 36031 | 4603 | 52 |
2117495 | 2117495 | 2022-01-15 | Essex | New York | 36031 | 4555 | 52 |
2114244 | 2114244 | 2022-01-14 | Essex | New York | 36031 | 4491 | 50 |
2110992 | 2110992 | 2022-01-13 | Essex | New York | 36031 | 4446 | 50 |
2107740 | 2107740 | 2022-01-12 | Essex | New York | 36031 | 4378 | 50 |
2104489 | 2104489 | 2022-01-11 | Essex | New York | 36031 | 4320 | 49 |
2101238 | 2101238 | 2022-01-10 | Essex | New York | 36031 | 4285 | 49 |
2097987 | 2097987 | 2022-01-09 | Essex | New York | 36031 | 4238 | 49 |
2094735 | 2094735 | 2022-01-08 | Essex | New York | 36031 | 4177 | 49 |
2091483 | 2091483 | 2022-01-07 | Essex | New York | 36031 | 4070 | 48 |
2088232 | 2088232 | 2022-01-06 | Essex | New York | 36031 | 3995 | 48 |
2084980 | 2084980 | 2022-01-05 | Essex | New York | 36031 | 3943 | 48 |
2081728 | 2081728 | 2022-01-04 | Essex | New York | 36031 | 3887 | 48 |
2078476 | 2078476 | 2022-01-03 | Essex | New York | 36031 | 3857 | 48 |
2075225 | 2075225 | 2022-01-02 | Essex | New York | 36031 | 3833 | 48 |
2071974 | 2071974 | 2022-01-01 | Essex | New York | 36031 | 3767 | 48 |
2068723 | 2068723 | 2021-12-31 | Essex | New York | 36031 | 3702 | 48 |
2065472 | 2065472 | 2021-12-30 | Essex | New York | 36031 | 3632 | 48 |
2062222 | 2062222 | 2021-12-29 | Essex | New York | 36031 | 3585 | 47 |
2058973 | 2058973 | 2021-12-28 | Essex | New York | 36031 | 3545 | 47 |
2055724 | 2055724 | 2021-12-27 | Essex | New York | 36031 | 3538 | 47 |
2052474 | 2052474 | 2021-12-26 | Essex | New York | 36031 | 3535 | 47 |
2049224 | 2049224 | 2021-12-25 | Essex | New York | 36031 | 3501 | 47 |
2045974 | 2045974 | 2021-12-24 | Essex | New York | 36031 | 3501 | 47 |
2042724 | 2042724 | 2021-12-23 | Essex | New York | 36031 | 3478 | 46 |
2039475 | 2039475 | 2021-12-22 | Essex | New York | 36031 | 3451 | 45 |
2036225 | 2036225 | 2021-12-21 | Essex | New York | 36031 | 3427 | 45 |
2032975 | 2032975 | 2021-12-20 | Essex | New York | 36031 | 3418 | 45 |
2029725 | 2029725 | 2021-12-19 | Essex | New York | 36031 | 3403 | 45 |
2026474 | 2026474 | 2021-12-18 | Essex | New York | 36031 | 3381 | 45 |
2023223 | 2023223 | 2021-12-17 | Essex | New York | 36031 | 3354 | 45 |
2019972 | 2019972 | 2021-12-16 | Essex | New York | 36031 | 3317 | 45 |
2016721 | 2016721 | 2021-12-15 | Essex | New York | 36031 | 3299 | 44 |
2013471 | 2013471 | 2021-12-14 | Essex | New York | 36031 | 3272 | 44 |
2010220 | 2010220 | 2021-12-13 | Essex | New York | 36031 | 3266 | 44 |
2006969 | 2006969 | 2021-12-12 | Essex | New York | 36031 | 3256 | 44 |
2003718 | 2003718 | 2021-12-11 | Essex | New York | 36031 | 3228 | 43 |
2000467 | 2000467 | 2021-12-10 | Essex | New York | 36031 | 3213 | 43 |
1997217 | 1997217 | 2021-12-09 | Essex | New York | 36031 | 3185 | 42 |
1993966 | 1993966 | 2021-12-08 | Essex | New York | 36031 | 3159 | 41 |
1990715 | 1990715 | 2021-12-07 | Essex | New York | 36031 | 3127 | 40 |
1987464 | 1987464 | 2021-12-06 | Essex | New York | 36031 | 3110 | 40 |
1984214 | 1984214 | 2021-12-05 | Essex | New York | 36031 | 3097 | 38 |
1980964 | 1980964 | 2021-12-04 | Essex | New York | 36031 | 3081 | 38 |
1977714 | 1977714 | 2021-12-03 | Essex | New York | 36031 | 3067 | 38 |
1974464 | 1974464 | 2021-12-02 | Essex | New York | 36031 | 3043 | 38 |
1971215 | 1971215 | 2021-12-01 | Essex | New York | 36031 | 3013 | 38 |
1967965 | 1967965 | 2021-11-30 | Essex | New York | 36031 | 2992 | 38 |
1964714 | 1964714 | 2021-11-29 | Essex | New York | 36031 | 2983 | 37 |
1961462 | 1961462 | 2021-11-28 | Essex | New York | 36031 | 2972 | 37 |
1958211 | 1958211 | 2021-11-27 | Essex | New York | 36031 | 2961 | 37 |
1954960 | 1954960 | 2021-11-26 | Essex | New York | 36031 | 2954 | 37 |
1951709 | 1951709 | 2021-11-25 | Essex | New York | 36031 | 2935 | 37 |
1948458 | 1948458 | 2021-11-24 | Essex | New York | 36031 | 2915 | 37 |
1945207 | 1945207 | 2021-11-23 | Essex | New York | 36031 | 2898 | 37 |
1941956 | 1941956 | 2021-11-22 | Essex | New York | 36031 | 2890 | 37 |
1938706 | 1938706 | 2021-11-21 | Essex | New York | 36031 | 2878 | 37 |
1935456 | 1935456 | 2021-11-20 | Essex | New York | 36031 | 2868 | 37 |
1932206 | 1932206 | 2021-11-19 | Essex | New York | 36031 | 2848 | 37 |
1928955 | 1928955 | 2021-11-18 | Essex | New York | 36031 | 2813 | 37 |
1925705 | 1925705 | 2021-11-17 | Essex | New York | 36031 | 2802 | 37 |
1922456 | 1922456 | 2021-11-16 | Essex | New York | 36031 | 2794 | 37 |
1919206 | 1919206 | 2021-11-15 | Essex | New York | 36031 | 2786 | 37 |
1915956 | 1915956 | 2021-11-14 | Essex | New York | 36031 | 2775 | 37 |
1912706 | 1912706 | 2021-11-13 | Essex | New York | 36031 | 2755 | 37 |
1909456 | 1909456 | 2021-11-12 | Essex | New York | 36031 | 2731 | 37 |
1906207 | 1906207 | 2021-11-11 | Essex | New York | 36031 | 2705 | 36 |
1902958 | 1902958 | 2021-11-10 | Essex | New York | 36031 | 2693 | 36 |
1899708 | 1899708 | 2021-11-09 | Essex | New York | 36031 | 2678 | 36 |
1896458 | 1896458 | 2021-11-08 | Essex | New York | 36031 | 2659 | 36 |
1893208 | 1893208 | 2021-11-07 | Essex | New York | 36031 | 2642 | 36 |
1889958 | 1889958 | 2021-11-06 | Essex | New York | 36031 | 2612 | 36 |
1886708 | 1886708 | 2021-11-05 | Essex | New York | 36031 | 2591 | 36 |
1883459 | 1883459 | 2021-11-04 | Essex | New York | 36031 | 2566 | 35 |
1880210 | 1880210 | 2021-11-03 | Essex | New York | 36031 | 2542 | 35 |
1876961 | 1876961 | 2021-11-02 | Essex | New York | 36031 | 2512 | 35 |
1873712 | 1873712 | 2021-11-01 | Essex | New York | 36031 | 2501 | 35 |
1870463 | 1870463 | 2021-10-31 | Essex | New York | 36031 | 2484 | 35 |
1867214 | 1867214 | 2021-10-30 | Essex | New York | 36031 | 2456 | 35 |
1863965 | 1863965 | 2021-10-29 | Essex | New York | 36031 | 2441 | 35 |
1860716 | 1860716 | 2021-10-28 | Essex | New York | 36031 | 2414 | 35 |
1857467 | 1857467 | 2021-10-27 | Essex | New York | 36031 | 2401 | 34 |
1854218 | 1854218 | 2021-10-26 | Essex | New York | 36031 | 2388 | 34 |
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);