ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17021 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174807 | 2174807 | 2022-02-02 | Christian | Illinois | 17021 | 9613 | 121 |
2171554 | 2171554 | 2022-02-01 | Christian | Illinois | 17021 | 9571 | 121 |
2168301 | 2168301 | 2022-01-31 | Christian | Illinois | 17021 | 9513 | 121 |
2165046 | 2165046 | 2022-01-30 | Christian | Illinois | 17021 | 9427 | 121 |
2161791 | 2161791 | 2022-01-29 | Christian | Illinois | 17021 | 9427 | 121 |
2158536 | 2158536 | 2022-01-28 | Christian | Illinois | 17021 | 9427 | 121 |
2155282 | 2155282 | 2022-01-27 | Christian | Illinois | 17021 | 9326 | 120 |
2152029 | 2152029 | 2022-01-26 | Christian | Illinois | 17021 | 9237 | 120 |
2148777 | 2148777 | 2022-01-25 | Christian | Illinois | 17021 | 9157 | 120 |
2145525 | 2145525 | 2022-01-24 | Christian | Illinois | 17021 | 9100 | 120 |
2142270 | 2142270 | 2022-01-23 | Christian | Illinois | 17021 | 8844 | 119 |
2139015 | 2139015 | 2022-01-22 | Christian | Illinois | 17021 | 8844 | 119 |
2135759 | 2135759 | 2022-01-21 | Christian | Illinois | 17021 | 8844 | 119 |
2132507 | 2132507 | 2022-01-20 | Christian | Illinois | 17021 | 8662 | 119 |
2129254 | 2129254 | 2022-01-19 | Christian | Illinois | 17021 | 8607 | 118 |
2126000 | 2126000 | 2022-01-18 | Christian | Illinois | 17021 | 8468 | 118 |
2122748 | 2122748 | 2022-01-17 | Christian | Illinois | 17021 | 8182 | 117 |
2119496 | 2119496 | 2022-01-16 | Christian | Illinois | 17021 | 8182 | 117 |
2116244 | 2116244 | 2022-01-15 | Christian | Illinois | 17021 | 8182 | 117 |
2112993 | 2112993 | 2022-01-14 | Christian | Illinois | 17021 | 8182 | 117 |
2109741 | 2109741 | 2022-01-13 | Christian | Illinois | 17021 | 8022 | 115 |
2106490 | 2106490 | 2022-01-12 | Christian | Illinois | 17021 | 7853 | 115 |
2103239 | 2103239 | 2022-01-11 | Christian | Illinois | 17021 | 7681 | 115 |
2099988 | 2099988 | 2022-01-10 | Christian | Illinois | 17021 | 7439 | 115 |
2096737 | 2096737 | 2022-01-09 | Christian | Illinois | 17021 | 7242 | 113 |
2093485 | 2093485 | 2022-01-08 | Christian | Illinois | 17021 | 7242 | 113 |
2090233 | 2090233 | 2022-01-07 | Christian | Illinois | 17021 | 7242 | 113 |
2086982 | 2086982 | 2022-01-06 | Christian | Illinois | 17021 | 7123 | 112 |
2083730 | 2083730 | 2022-01-05 | Christian | Illinois | 17021 | 7051 | 110 |
2080478 | 2080478 | 2022-01-04 | Christian | Illinois | 17021 | 6927 | 109 |
2077226 | 2077226 | 2022-01-03 | Christian | Illinois | 17021 | 6884 | 109 |
2073975 | 2073975 | 2022-01-02 | Christian | Illinois | 17021 | 6771 | 107 |
2070724 | 2070724 | 2022-01-01 | Christian | Illinois | 17021 | 6771 | 107 |
2067473 | 2067473 | 2021-12-31 | Christian | Illinois | 17021 | 6771 | 107 |
2064222 | 2064222 | 2021-12-30 | Christian | Illinois | 17021 | 6771 | 107 |
2060972 | 2060972 | 2021-12-29 | Christian | Illinois | 17021 | 6690 | 104 |
2057723 | 2057723 | 2021-12-28 | Christian | Illinois | 17021 | 6645 | 104 |
2054474 | 2054474 | 2021-12-27 | Christian | Illinois | 17021 | 6571 | 104 |
2051224 | 2051224 | 2021-12-26 | Christian | Illinois | 17021 | 6515 | 103 |
2047974 | 2047974 | 2021-12-25 | Christian | Illinois | 17021 | 6515 | 103 |
2044724 | 2044724 | 2021-12-24 | Christian | Illinois | 17021 | 6515 | 103 |
2041475 | 2041475 | 2021-12-23 | Christian | Illinois | 17021 | 6515 | 103 |
2038225 | 2038225 | 2021-12-22 | Christian | Illinois | 17021 | 6485 | 102 |
2034975 | 2034975 | 2021-12-21 | Christian | Illinois | 17021 | 6455 | 102 |
2031725 | 2031725 | 2021-12-20 | Christian | Illinois | 17021 | 6416 | 102 |
2028474 | 2028474 | 2021-12-19 | Christian | Illinois | 17021 | 6340 | 102 |
2025223 | 2025223 | 2021-12-18 | Christian | Illinois | 17021 | 6340 | 102 |
2021972 | 2021972 | 2021-12-17 | Christian | Illinois | 17021 | 6340 | 102 |
2018721 | 2018721 | 2021-12-16 | Christian | Illinois | 17021 | 6311 | 102 |
2015471 | 2015471 | 2021-12-15 | Christian | Illinois | 17021 | 6279 | 102 |
2012220 | 2012220 | 2021-12-14 | Christian | Illinois | 17021 | 6246 | 102 |
2008969 | 2008969 | 2021-12-13 | Christian | Illinois | 17021 | 6226 | 102 |
2005718 | 2005718 | 2021-12-12 | Christian | Illinois | 17021 | 6145 | 102 |
2002467 | 2002467 | 2021-12-11 | Christian | Illinois | 17021 | 6145 | 102 |
1999217 | 1999217 | 2021-12-10 | Christian | Illinois | 17021 | 6145 | 102 |
1995966 | 1995966 | 2021-12-09 | Christian | Illinois | 17021 | 6126 | 102 |
1992715 | 1992715 | 2021-12-08 | Christian | Illinois | 17021 | 6086 | 102 |
1989464 | 1989464 | 2021-12-07 | Christian | Illinois | 17021 | 6039 | 102 |
1986214 | 1986214 | 2021-12-06 | Christian | Illinois | 17021 | 5989 | 101 |
1982964 | 1982964 | 2021-12-05 | Christian | Illinois | 17021 | 5936 | 101 |
1979714 | 1979714 | 2021-12-04 | Christian | Illinois | 17021 | 5936 | 101 |
1976464 | 1976464 | 2021-12-03 | Christian | Illinois | 17021 | 5936 | 101 |
1973215 | 1973215 | 2021-12-02 | Christian | Illinois | 17021 | 5907 | 101 |
1969965 | 1969965 | 2021-12-01 | Christian | Illinois | 17021 | 5835 | 101 |
1966715 | 1966715 | 2021-11-30 | Christian | Illinois | 17021 | 5809 | 101 |
1963463 | 1963463 | 2021-11-29 | Christian | Illinois | 17021 | 5784 | 101 |
1960212 | 1960212 | 2021-11-28 | Christian | Illinois | 17021 | 5704 | 101 |
1956961 | 1956961 | 2021-11-27 | Christian | Illinois | 17021 | 5704 | 101 |
1953710 | 1953710 | 2021-11-26 | Christian | Illinois | 17021 | 5704 | 101 |
1950459 | 1950459 | 2021-11-25 | Christian | Illinois | 17021 | 5704 | 101 |
1947208 | 1947208 | 2021-11-24 | Christian | Illinois | 17021 | 5704 | 101 |
1943957 | 1943957 | 2021-11-23 | Christian | Illinois | 17021 | 5685 | 101 |
1940707 | 1940707 | 2021-11-22 | Christian | Illinois | 17021 | 5666 | 101 |
1937457 | 1937457 | 2021-11-21 | Christian | Illinois | 17021 | 5648 | 101 |
1934207 | 1934207 | 2021-11-20 | Christian | Illinois | 17021 | 5648 | 101 |
1930956 | 1930956 | 2021-11-19 | Christian | Illinois | 17021 | 5648 | 101 |
1927705 | 1927705 | 2021-11-18 | Christian | Illinois | 17021 | 5615 | 101 |
1924455 | 1924455 | 2021-11-17 | Christian | Illinois | 17021 | 5601 | 101 |
1921206 | 1921206 | 2021-11-16 | Christian | Illinois | 17021 | 5595 | 101 |
1917956 | 1917956 | 2021-11-15 | Christian | Illinois | 17021 | 5585 | 101 |
1914706 | 1914706 | 2021-11-14 | Christian | Illinois | 17021 | 5569 | 101 |
1911456 | 1911456 | 2021-11-13 | Christian | Illinois | 17021 | 5569 | 101 |
1908207 | 1908207 | 2021-11-12 | Christian | Illinois | 17021 | 5569 | 101 |
1904958 | 1904958 | 2021-11-11 | Christian | Illinois | 17021 | 5536 | 101 |
1901708 | 1901708 | 2021-11-10 | Christian | Illinois | 17021 | 5536 | 101 |
1898458 | 1898458 | 2021-11-09 | Christian | Illinois | 17021 | 5525 | 101 |
1895208 | 1895208 | 2021-11-08 | Christian | Illinois | 17021 | 5511 | 101 |
1891958 | 1891958 | 2021-11-07 | Christian | Illinois | 17021 | 5495 | 101 |
1888708 | 1888708 | 2021-11-06 | Christian | Illinois | 17021 | 5495 | 101 |
1885458 | 1885458 | 2021-11-05 | Christian | Illinois | 17021 | 5495 | 101 |
1882209 | 1882209 | 2021-11-04 | Christian | Illinois | 17021 | 5489 | 100 |
1878960 | 1878960 | 2021-11-03 | Christian | Illinois | 17021 | 5479 | 100 |
1875711 | 1875711 | 2021-11-02 | Christian | Illinois | 17021 | 5475 | 100 |
1872462 | 1872462 | 2021-11-01 | Christian | Illinois | 17021 | 5453 | 100 |
1869213 | 1869213 | 2021-10-31 | Christian | Illinois | 17021 | 5436 | 100 |
1865964 | 1865964 | 2021-10-30 | Christian | Illinois | 17021 | 5436 | 100 |
1862715 | 1862715 | 2021-10-29 | Christian | Illinois | 17021 | 5436 | 100 |
1859466 | 1859466 | 2021-10-28 | Christian | Illinois | 17021 | 5406 | 100 |
1856217 | 1856217 | 2021-10-27 | Christian | Illinois | 17021 | 5398 | 100 |
1852968 | 1852968 | 2021-10-26 | Christian | Illinois | 17021 | 5383 | 100 |
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);