ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Delaware" 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 |
---|---|---|---|---|---|---|---|
2110989 | 2110989 | 2022-01-13 | Delaware | New York | 36025 | 6402 | 61 |
2107737 | 2107737 | 2022-01-12 | Delaware | New York | 36025 | 6324 | 61 |
2104486 | 2104486 | 2022-01-11 | Delaware | New York | 36025 | 6264 | 61 |
2101235 | 2101235 | 2022-01-10 | Delaware | New York | 36025 | 6221 | 61 |
2097984 | 2097984 | 2022-01-09 | Delaware | New York | 36025 | 6184 | 61 |
2094732 | 2094732 | 2022-01-08 | Delaware | New York | 36025 | 6080 | 59 |
2091480 | 2091480 | 2022-01-07 | Delaware | New York | 36025 | 5977 | 59 |
2088229 | 2088229 | 2022-01-06 | Delaware | New York | 36025 | 5880 | 59 |
2084977 | 2084977 | 2022-01-05 | Delaware | New York | 36025 | 5762 | 59 |
2081725 | 2081725 | 2022-01-04 | Delaware | New York | 36025 | 5681 | 59 |
2078473 | 2078473 | 2022-01-03 | Delaware | New York | 36025 | 5629 | 59 |
2075222 | 2075222 | 2022-01-02 | Delaware | New York | 36025 | 5605 | 59 |
2071971 | 2071971 | 2022-01-01 | Delaware | New York | 36025 | 5555 | 59 |
2068720 | 2068720 | 2021-12-31 | Delaware | New York | 36025 | 5499 | 58 |
2065469 | 2065469 | 2021-12-30 | Delaware | New York | 36025 | 5454 | 58 |
2062219 | 2062219 | 2021-12-29 | Delaware | New York | 36025 | 5393 | 58 |
2058970 | 2058970 | 2021-12-28 | Delaware | New York | 36025 | 5338 | 57 |
2055721 | 2055721 | 2021-12-27 | Delaware | New York | 36025 | 5332 | 57 |
2052471 | 2052471 | 2021-12-26 | Delaware | New York | 36025 | 5322 | 57 |
2049221 | 2049221 | 2021-12-25 | Delaware | New York | 36025 | 5297 | 57 |
2045971 | 2045971 | 2021-12-24 | Delaware | New York | 36025 | 5297 | 57 |
2042721 | 2042721 | 2021-12-23 | Delaware | New York | 36025 | 5251 | 57 |
2039472 | 2039472 | 2021-12-22 | Delaware | New York | 36025 | 5208 | 57 |
2036222 | 2036222 | 2021-12-21 | Delaware | New York | 36025 | 5172 | 57 |
2032972 | 2032972 | 2021-12-20 | Delaware | New York | 36025 | 5147 | 57 |
2029722 | 2029722 | 2021-12-19 | Delaware | New York | 36025 | 5131 | 56 |
2026471 | 2026471 | 2021-12-18 | Delaware | New York | 36025 | 5095 | 56 |
2023220 | 2023220 | 2021-12-17 | Delaware | New York | 36025 | 5063 | 56 |
2019969 | 2019969 | 2021-12-16 | Delaware | New York | 36025 | 5029 | 56 |
2016718 | 2016718 | 2021-12-15 | Delaware | New York | 36025 | 4993 | 56 |
2013468 | 2013468 | 2021-12-14 | Delaware | New York | 36025 | 4956 | 55 |
2010217 | 2010217 | 2021-12-13 | Delaware | New York | 36025 | 4929 | 55 |
2006966 | 2006966 | 2021-12-12 | Delaware | New York | 36025 | 4912 | 55 |
2003715 | 2003715 | 2021-12-11 | Delaware | New York | 36025 | 4889 | 55 |
2000464 | 2000464 | 2021-12-10 | Delaware | New York | 36025 | 4840 | 55 |
1997214 | 1997214 | 2021-12-09 | Delaware | New York | 36025 | 4804 | 54 |
1993963 | 1993963 | 2021-12-08 | Delaware | New York | 36025 | 4761 | 54 |
1990712 | 1990712 | 2021-12-07 | Delaware | New York | 36025 | 4719 | 53 |
1987461 | 1987461 | 2021-12-06 | Delaware | New York | 36025 | 4677 | 53 |
1984211 | 1984211 | 2021-12-05 | Delaware | New York | 36025 | 4655 | 53 |
1980961 | 1980961 | 2021-12-04 | Delaware | New York | 36025 | 4625 | 53 |
1977711 | 1977711 | 2021-12-03 | Delaware | New York | 36025 | 4576 | 52 |
1974461 | 1974461 | 2021-12-02 | Delaware | New York | 36025 | 4505 | 52 |
1971212 | 1971212 | 2021-12-01 | Delaware | New York | 36025 | 4443 | 52 |
1967962 | 1967962 | 2021-11-30 | Delaware | New York | 36025 | 4399 | 51 |
1964711 | 1964711 | 2021-11-29 | Delaware | New York | 36025 | 4366 | 51 |
1961459 | 1961459 | 2021-11-28 | Delaware | New York | 36025 | 4344 | 51 |
1958208 | 1958208 | 2021-11-27 | Delaware | New York | 36025 | 4320 | 51 |
1954957 | 1954957 | 2021-11-26 | Delaware | New York | 36025 | 4301 | 51 |
1951706 | 1951706 | 2021-11-25 | Delaware | New York | 36025 | 4282 | 51 |
1948455 | 1948455 | 2021-11-24 | Delaware | New York | 36025 | 4254 | 51 |
1945204 | 1945204 | 2021-11-23 | Delaware | New York | 36025 | 4225 | 51 |
1941953 | 1941953 | 2021-11-22 | Delaware | New York | 36025 | 4211 | 51 |
1938703 | 1938703 | 2021-11-21 | Delaware | New York | 36025 | 4196 | 51 |
1935453 | 1935453 | 2021-11-20 | Delaware | New York | 36025 | 4175 | 51 |
1932203 | 1932203 | 2021-11-19 | Delaware | New York | 36025 | 4137 | 51 |
1928952 | 1928952 | 2021-11-18 | Delaware | New York | 36025 | 4088 | 50 |
1925702 | 1925702 | 2021-11-17 | Delaware | New York | 36025 | 4060 | 50 |
1922453 | 1922453 | 2021-11-16 | Delaware | New York | 36025 | 4043 | 50 |
1919203 | 1919203 | 2021-11-15 | Delaware | New York | 36025 | 4011 | 49 |
1915953 | 1915953 | 2021-11-14 | Delaware | New York | 36025 | 3997 | 49 |
1912703 | 1912703 | 2021-11-13 | Delaware | New York | 36025 | 3976 | 49 |
1909453 | 1909453 | 2021-11-12 | Delaware | New York | 36025 | 3939 | 49 |
1906204 | 1906204 | 2021-11-11 | Delaware | New York | 36025 | 3917 | 49 |
1902955 | 1902955 | 2021-11-10 | Delaware | New York | 36025 | 3880 | 49 |
1899705 | 1899705 | 2021-11-09 | Delaware | New York | 36025 | 3860 | 49 |
1896455 | 1896455 | 2021-11-08 | Delaware | New York | 36025 | 3842 | 49 |
1893205 | 1893205 | 2021-11-07 | Delaware | New York | 36025 | 3823 | 49 |
1889955 | 1889955 | 2021-11-06 | Delaware | New York | 36025 | 3792 | 49 |
1886705 | 1886705 | 2021-11-05 | Delaware | New York | 36025 | 3771 | 49 |
1883456 | 1883456 | 2021-11-04 | Delaware | New York | 36025 | 3751 | 49 |
1880207 | 1880207 | 2021-11-03 | Delaware | New York | 36025 | 3731 | 49 |
1876958 | 1876958 | 2021-11-02 | Delaware | New York | 36025 | 3709 | 48 |
1873709 | 1873709 | 2021-11-01 | Delaware | New York | 36025 | 3701 | 48 |
1870460 | 1870460 | 2021-10-31 | Delaware | New York | 36025 | 3696 | 48 |
1867211 | 1867211 | 2021-10-30 | Delaware | New York | 36025 | 3671 | 48 |
1863962 | 1863962 | 2021-10-29 | Delaware | New York | 36025 | 3662 | 48 |
1860713 | 1860713 | 2021-10-28 | Delaware | New York | 36025 | 3641 | 48 |
1857464 | 1857464 | 2021-10-27 | Delaware | New York | 36025 | 3623 | 48 |
1854215 | 1854215 | 2021-10-26 | Delaware | New York | 36025 | 3604 | 48 |
1850966 | 1850966 | 2021-10-25 | Delaware | New York | 36025 | 3603 | 48 |
1847716 | 1847716 | 2021-10-24 | Delaware | New York | 36025 | 3591 | 48 |
1844466 | 1844466 | 2021-10-23 | Delaware | New York | 36025 | 3585 | 48 |
1841216 | 1841216 | 2021-10-22 | Delaware | New York | 36025 | 3574 | 48 |
1837967 | 1837967 | 2021-10-21 | Delaware | New York | 36025 | 3560 | 47 |
1834718 | 1834718 | 2021-10-20 | Delaware | New York | 36025 | 3546 | 47 |
1831469 | 1831469 | 2021-10-19 | Delaware | New York | 36025 | 3529 | 47 |
1828220 | 1828220 | 2021-10-18 | Delaware | New York | 36025 | 3521 | 47 |
1824971 | 1824971 | 2021-10-17 | Delaware | New York | 36025 | 3507 | 47 |
1821722 | 1821722 | 2021-10-16 | Delaware | New York | 36025 | 3495 | 45 |
1818473 | 1818473 | 2021-10-15 | Delaware | New York | 36025 | 3473 | 44 |
1815224 | 1815224 | 2021-10-14 | Delaware | New York | 36025 | 3452 | 44 |
1811976 | 1811976 | 2021-10-13 | Delaware | New York | 36025 | 3436 | 44 |
1808727 | 1808727 | 2021-10-12 | Delaware | New York | 36025 | 3417 | 44 |
1805476 | 1805476 | 2021-10-11 | Delaware | New York | 36025 | 3407 | 44 |
1802227 | 1802227 | 2021-10-10 | Delaware | New York | 36025 | 3382 | 44 |
1798978 | 1798978 | 2021-10-09 | Delaware | New York | 36025 | 3368 | 44 |
1795729 | 1795729 | 2021-10-08 | Delaware | New York | 36025 | 3348 | 42 |
1792480 | 1792480 | 2021-10-07 | Delaware | New York | 36025 | 3329 | 42 |
1789231 | 1789231 | 2021-10-06 | Delaware | New York | 36025 | 3311 | 42 |
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);