ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17035 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174814 | 2174814 | 2022-02-02 | Cumberland | Illinois | 17035 | 3245 | 48 |
2171561 | 2171561 | 2022-02-01 | Cumberland | Illinois | 17035 | 3220 | 48 |
2168308 | 2168308 | 2022-01-31 | Cumberland | Illinois | 17035 | 3191 | 48 |
2165053 | 2165053 | 2022-01-30 | Cumberland | Illinois | 17035 | 3155 | 47 |
2161798 | 2161798 | 2022-01-29 | Cumberland | Illinois | 17035 | 3155 | 47 |
2158543 | 2158543 | 2022-01-28 | Cumberland | Illinois | 17035 | 3155 | 47 |
2155289 | 2155289 | 2022-01-27 | Cumberland | Illinois | 17035 | 3129 | 47 |
2152036 | 2152036 | 2022-01-26 | Cumberland | Illinois | 17035 | 3093 | 47 |
2148784 | 2148784 | 2022-01-25 | Cumberland | Illinois | 17035 | 3065 | 47 |
2145532 | 2145532 | 2022-01-24 | Cumberland | Illinois | 17035 | 3023 | 47 |
2142277 | 2142277 | 2022-01-23 | Cumberland | Illinois | 17035 | 2969 | 46 |
2139022 | 2139022 | 2022-01-22 | Cumberland | Illinois | 17035 | 2969 | 46 |
2135766 | 2135766 | 2022-01-21 | Cumberland | Illinois | 17035 | 2969 | 46 |
2132514 | 2132514 | 2022-01-20 | Cumberland | Illinois | 17035 | 2906 | 45 |
2129261 | 2129261 | 2022-01-19 | Cumberland | Illinois | 17035 | 2848 | 44 |
2126007 | 2126007 | 2022-01-18 | Cumberland | Illinois | 17035 | 2797 | 44 |
2122755 | 2122755 | 2022-01-17 | Cumberland | Illinois | 17035 | 2705 | 44 |
2119503 | 2119503 | 2022-01-16 | Cumberland | Illinois | 17035 | 2705 | 44 |
2116251 | 2116251 | 2022-01-15 | Cumberland | Illinois | 17035 | 2705 | 44 |
2113000 | 2113000 | 2022-01-14 | Cumberland | Illinois | 17035 | 2705 | 44 |
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 |
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);