ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Cumberland" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109748 | 2109748 | 2022-01-13 | Cumberland | Illinois | 17035 | 2651 | 43 |
2106497 | 2106497 | 2022-01-12 | Cumberland | Illinois | 17035 | 2610 | 43 |
2103246 | 2103246 | 2022-01-11 | Cumberland | Illinois | 17035 | 2571 | 43 |
2099995 | 2099995 | 2022-01-10 | Cumberland | Illinois | 17035 | 2539 | 43 |
2096744 | 2096744 | 2022-01-09 | Cumberland | Illinois | 17035 | 2488 | 43 |
2093492 | 2093492 | 2022-01-08 | Cumberland | Illinois | 17035 | 2488 | 43 |
2090240 | 2090240 | 2022-01-07 | Cumberland | Illinois | 17035 | 2488 | 43 |
2086989 | 2086989 | 2022-01-06 | Cumberland | Illinois | 17035 | 2447 | 43 |
2083737 | 2083737 | 2022-01-05 | Cumberland | Illinois | 17035 | 2418 | 42 |
2080485 | 2080485 | 2022-01-04 | Cumberland | Illinois | 17035 | 2394 | 42 |
2077233 | 2077233 | 2022-01-03 | Cumberland | Illinois | 17035 | 2378 | 42 |
2073982 | 2073982 | 2022-01-02 | Cumberland | Illinois | 17035 | 2349 | 42 |
2070731 | 2070731 | 2022-01-01 | Cumberland | Illinois | 17035 | 2349 | 42 |
2067480 | 2067480 | 2021-12-31 | Cumberland | Illinois | 17035 | 2349 | 42 |
2064229 | 2064229 | 2021-12-30 | Cumberland | Illinois | 17035 | 2349 | 42 |
2060979 | 2060979 | 2021-12-29 | Cumberland | Illinois | 17035 | 2326 | 41 |
2057730 | 2057730 | 2021-12-28 | Cumberland | Illinois | 17035 | 2316 | 41 |
2054481 | 2054481 | 2021-12-27 | Cumberland | Illinois | 17035 | 2307 | 41 |
2051231 | 2051231 | 2021-12-26 | Cumberland | Illinois | 17035 | 2286 | 41 |
2047981 | 2047981 | 2021-12-25 | Cumberland | Illinois | 17035 | 2286 | 41 |
2044731 | 2044731 | 2021-12-24 | Cumberland | Illinois | 17035 | 2286 | 41 |
2041482 | 2041482 | 2021-12-23 | Cumberland | Illinois | 17035 | 2286 | 41 |
2038232 | 2038232 | 2021-12-22 | Cumberland | Illinois | 17035 | 2274 | 41 |
2034982 | 2034982 | 2021-12-21 | Cumberland | Illinois | 17035 | 2263 | 41 |
2031732 | 2031732 | 2021-12-20 | Cumberland | Illinois | 17035 | 2254 | 41 |
2028481 | 2028481 | 2021-12-19 | Cumberland | Illinois | 17035 | 2240 | 41 |
2025230 | 2025230 | 2021-12-18 | Cumberland | Illinois | 17035 | 2240 | 41 |
2021979 | 2021979 | 2021-12-17 | Cumberland | Illinois | 17035 | 2240 | 41 |
2018728 | 2018728 | 2021-12-16 | Cumberland | Illinois | 17035 | 2230 | 41 |
2015478 | 2015478 | 2021-12-15 | Cumberland | Illinois | 17035 | 2215 | 41 |
2012227 | 2012227 | 2021-12-14 | Cumberland | Illinois | 17035 | 2207 | 41 |
2008976 | 2008976 | 2021-12-13 | Cumberland | Illinois | 17035 | 2195 | 41 |
2005725 | 2005725 | 2021-12-12 | Cumberland | Illinois | 17035 | 2175 | 40 |
2002474 | 2002474 | 2021-12-11 | Cumberland | Illinois | 17035 | 2175 | 40 |
1999224 | 1999224 | 2021-12-10 | Cumberland | Illinois | 17035 | 2175 | 40 |
1995973 | 1995973 | 2021-12-09 | Cumberland | Illinois | 17035 | 2160 | 39 |
1992722 | 1992722 | 2021-12-08 | Cumberland | Illinois | 17035 | 2145 | 39 |
1989471 | 1989471 | 2021-12-07 | Cumberland | Illinois | 17035 | 2136 | 39 |
1986221 | 1986221 | 2021-12-06 | Cumberland | Illinois | 17035 | 2119 | 39 |
1982971 | 1982971 | 2021-12-05 | Cumberland | Illinois | 17035 | 2100 | 39 |
1979721 | 1979721 | 2021-12-04 | Cumberland | Illinois | 17035 | 2100 | 39 |
1976471 | 1976471 | 2021-12-03 | Cumberland | Illinois | 17035 | 2100 | 39 |
1973222 | 1973222 | 2021-12-02 | Cumberland | Illinois | 17035 | 2089 | 39 |
1969972 | 1969972 | 2021-12-01 | Cumberland | Illinois | 17035 | 2079 | 39 |
1966722 | 1966722 | 2021-11-30 | Cumberland | Illinois | 17035 | 2074 | 39 |
1963470 | 1963470 | 2021-11-29 | Cumberland | Illinois | 17035 | 2061 | 39 |
1960219 | 1960219 | 2021-11-28 | Cumberland | Illinois | 17035 | 2044 | 39 |
1956968 | 1956968 | 2021-11-27 | Cumberland | Illinois | 17035 | 2044 | 39 |
1953717 | 1953717 | 2021-11-26 | Cumberland | Illinois | 17035 | 2044 | 39 |
1950466 | 1950466 | 2021-11-25 | Cumberland | Illinois | 17035 | 2044 | 39 |
1947215 | 1947215 | 2021-11-24 | Cumberland | Illinois | 17035 | 2044 | 39 |
1943964 | 1943964 | 2021-11-23 | Cumberland | Illinois | 17035 | 2032 | 39 |
1940714 | 1940714 | 2021-11-22 | Cumberland | Illinois | 17035 | 2020 | 39 |
1937464 | 1937464 | 2021-11-21 | Cumberland | Illinois | 17035 | 2000 | 39 |
1934214 | 1934214 | 2021-11-20 | Cumberland | Illinois | 17035 | 2000 | 39 |
1930963 | 1930963 | 2021-11-19 | Cumberland | Illinois | 17035 | 2000 | 39 |
1927712 | 1927712 | 2021-11-18 | Cumberland | Illinois | 17035 | 1993 | 39 |
1924462 | 1924462 | 2021-11-17 | Cumberland | Illinois | 17035 | 1986 | 39 |
1921213 | 1921213 | 2021-11-16 | Cumberland | Illinois | 17035 | 1980 | 39 |
1917963 | 1917963 | 2021-11-15 | Cumberland | Illinois | 17035 | 1972 | 39 |
1914713 | 1914713 | 2021-11-14 | Cumberland | Illinois | 17035 | 1962 | 39 |
1911463 | 1911463 | 2021-11-13 | Cumberland | Illinois | 17035 | 1962 | 39 |
1908214 | 1908214 | 2021-11-12 | Cumberland | Illinois | 17035 | 1962 | 39 |
1904965 | 1904965 | 2021-11-11 | Cumberland | Illinois | 17035 | 1958 | 39 |
1901715 | 1901715 | 2021-11-10 | Cumberland | Illinois | 17035 | 1958 | 39 |
1898465 | 1898465 | 2021-11-09 | Cumberland | Illinois | 17035 | 1956 | 39 |
1895215 | 1895215 | 2021-11-08 | Cumberland | Illinois | 17035 | 1955 | 39 |
1891965 | 1891965 | 2021-11-07 | Cumberland | Illinois | 17035 | 1946 | 39 |
1888715 | 1888715 | 2021-11-06 | Cumberland | Illinois | 17035 | 1946 | 39 |
1885465 | 1885465 | 2021-11-05 | Cumberland | Illinois | 17035 | 1946 | 39 |
1882216 | 1882216 | 2021-11-04 | Cumberland | Illinois | 17035 | 1938 | 39 |
1878967 | 1878967 | 2021-11-03 | Cumberland | Illinois | 17035 | 1936 | 39 |
1875718 | 1875718 | 2021-11-02 | Cumberland | Illinois | 17035 | 1933 | 39 |
1872469 | 1872469 | 2021-11-01 | Cumberland | Illinois | 17035 | 1928 | 39 |
1869220 | 1869220 | 2021-10-31 | Cumberland | Illinois | 17035 | 1919 | 39 |
1865971 | 1865971 | 2021-10-30 | Cumberland | Illinois | 17035 | 1919 | 39 |
1862722 | 1862722 | 2021-10-29 | Cumberland | Illinois | 17035 | 1919 | 39 |
1859473 | 1859473 | 2021-10-28 | Cumberland | Illinois | 17035 | 1916 | 39 |
1856224 | 1856224 | 2021-10-27 | Cumberland | Illinois | 17035 | 1911 | 38 |
1852975 | 1852975 | 2021-10-26 | Cumberland | Illinois | 17035 | 1907 | 38 |
1849726 | 1849726 | 2021-10-25 | Cumberland | Illinois | 17035 | 1905 | 38 |
1846476 | 1846476 | 2021-10-24 | Cumberland | Illinois | 17035 | 1901 | 38 |
1843226 | 1843226 | 2021-10-23 | Cumberland | Illinois | 17035 | 1901 | 38 |
1839976 | 1839976 | 2021-10-22 | Cumberland | Illinois | 17035 | 1901 | 38 |
1836727 | 1836727 | 2021-10-21 | Cumberland | Illinois | 17035 | 1902 | 38 |
1833478 | 1833478 | 2021-10-20 | Cumberland | Illinois | 17035 | 1900 | 38 |
1830229 | 1830229 | 2021-10-19 | Cumberland | Illinois | 17035 | 1896 | 38 |
1826980 | 1826980 | 2021-10-18 | Cumberland | Illinois | 17035 | 1895 | 38 |
1823731 | 1823731 | 2021-10-17 | Cumberland | Illinois | 17035 | 1885 | 38 |
1820482 | 1820482 | 2021-10-16 | Cumberland | Illinois | 17035 | 1885 | 38 |
1817233 | 1817233 | 2021-10-15 | Cumberland | Illinois | 17035 | 1885 | 38 |
1813985 | 1813985 | 2021-10-14 | Cumberland | Illinois | 17035 | 1882 | 38 |
1810736 | 1810736 | 2021-10-13 | Cumberland | Illinois | 17035 | 1880 | 38 |
1807487 | 1807487 | 2021-10-12 | Cumberland | Illinois | 17035 | 1878 | 38 |
1804236 | 1804236 | 2021-10-11 | Cumberland | Illinois | 17035 | 1866 | 38 |
1800987 | 1800987 | 2021-10-10 | Cumberland | Illinois | 17035 | 1866 | 38 |
1797738 | 1797738 | 2021-10-09 | Cumberland | Illinois | 17035 | 1866 | 38 |
1794489 | 1794489 | 2021-10-08 | Cumberland | Illinois | 17035 | 1866 | 38 |
1791241 | 1791241 | 2021-10-07 | Cumberland | Illinois | 17035 | 1865 | 38 |
1787992 | 1787992 | 2021-10-06 | Cumberland | Illinois | 17035 | 1861 | 38 |
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);