ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Essex" 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 |
---|---|---|---|---|---|---|---|
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 |
1850969 | 1850969 | 2021-10-25 | Essex | New York | 36031 | 2383 | 33 |
1847719 | 1847719 | 2021-10-24 | Essex | New York | 36031 | 2370 | 31 |
1844469 | 1844469 | 2021-10-23 | Essex | New York | 36031 | 2355 | 31 |
1841219 | 1841219 | 2021-10-22 | Essex | New York | 36031 | 2335 | 31 |
1837970 | 1837970 | 2021-10-21 | Essex | New York | 36031 | 2315 | 31 |
1834721 | 1834721 | 2021-10-20 | Essex | New York | 36031 | 2300 | 31 |
1831472 | 1831472 | 2021-10-19 | Essex | New York | 36031 | 2276 | 31 |
1828223 | 1828223 | 2021-10-18 | Essex | New York | 36031 | 2271 | 31 |
1824974 | 1824974 | 2021-10-17 | Essex | New York | 36031 | 2253 | 31 |
1821725 | 1821725 | 2021-10-16 | Essex | New York | 36031 | 2232 | 31 |
1818476 | 1818476 | 2021-10-15 | Essex | New York | 36031 | 2209 | 31 |
1815227 | 1815227 | 2021-10-14 | Essex | New York | 36031 | 2194 | 31 |
1811979 | 1811979 | 2021-10-13 | Essex | New York | 36031 | 2186 | 31 |
1808730 | 1808730 | 2021-10-12 | Essex | New York | 36031 | 2177 | 31 |
1805479 | 1805479 | 2021-10-11 | Essex | New York | 36031 | 2170 | 31 |
1802230 | 1802230 | 2021-10-10 | Essex | New York | 36031 | 2163 | 31 |
1798981 | 1798981 | 2021-10-09 | Essex | New York | 36031 | 2158 | 31 |
1795732 | 1795732 | 2021-10-08 | Essex | New York | 36031 | 2152 | 31 |
1792483 | 1792483 | 2021-10-07 | Essex | New York | 36031 | 2135 | 30 |
1789234 | 1789234 | 2021-10-06 | Essex | New York | 36031 | 2125 | 30 |
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);