ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 223 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2191059 | 2191059 | 2022-02-07 | Adams | Illinois | 17001 | 21613 | 223 |
2142307 | 2142307 | 2022-01-23 | Knox | Illinois | 17095 | 11429 | 223 |
2139052 | 2139052 | 2022-01-22 | Knox | Illinois | 17095 | 11429 | 223 |
2135796 | 2135796 | 2022-01-21 | Knox | Illinois | 17095 | 11429 | 223 |
2132544 | 2132544 | 2022-01-20 | Knox | Illinois | 17095 | 11353 | 223 |
2028473 | 2028473 | 2021-12-19 | Champaign | Illinois | 17019 | 32999 | 223 |
2025222 | 2025222 | 2021-12-18 | Champaign | Illinois | 17019 | 32999 | 223 |
2021971 | 2021971 | 2021-12-17 | Champaign | Illinois | 17019 | 32999 | 223 |
1898540 | 1898540 | 2021-11-09 | Vermilion | Illinois | 17183 | 15041 | 223 |
1823812 | 1823812 | 2021-10-17 | Whiteside | Illinois | 17195 | 8351 | 223 |
1820563 | 1820563 | 2021-10-16 | Whiteside | Illinois | 17195 | 8351 | 223 |
1817314 | 1817314 | 2021-10-15 | Whiteside | Illinois | 17195 | 8351 | 223 |
1437269 | 1437269 | 2021-06-20 | McLean | Illinois | 17113 | 18553 | 223 |
1434022 | 1434022 | 2021-06-19 | McLean | Illinois | 17113 | 18553 | 223 |
1430776 | 1430776 | 2021-06-18 | McLean | Illinois | 17113 | 18553 | 223 |
1427531 | 1427531 | 2021-06-17 | McLean | Illinois | 17113 | 18552 | 223 |
1424286 | 1424286 | 2021-06-16 | McLean | Illinois | 17113 | 18547 | 223 |
1421038 | 1421038 | 2021-06-15 | McLean | Illinois | 17113 | 18544 | 223 |
1417793 | 1417793 | 2021-06-14 | McLean | Illinois | 17113 | 18544 | 223 |
1414547 | 1414547 | 2021-06-13 | McLean | Illinois | 17113 | 18544 | 223 |
1411302 | 1411302 | 2021-06-12 | McLean | Illinois | 17113 | 18540 | 223 |
1408039 | 1408039 | 2021-06-11 | Kankakee | Illinois | 17091 | 14525 | 223 |
1408057 | 1408057 | 2021-06-11 | McLean | Illinois | 17113 | 18533 | 223 |
1404811 | 1404811 | 2021-06-10 | McLean | Illinois | 17113 | 18527 | 223 |
1401566 | 1401566 | 2021-06-09 | McLean | Illinois | 17113 | 18523 | 223 |
917875 | 917875 | 2021-01-11 | Sangamon | Illinois | 17167 | 14022 | 223 |
914619 | 914619 | 2021-01-10 | Peoria | Illinois | 17143 | 14289 | 223 |
914630 | 914630 | 2021-01-10 | Sangamon | Illinois | 17167 | 13963 | 223 |
911385 | 911385 | 2021-01-09 | Sangamon | Illinois | 17167 | 13915 | 223 |
898384 | 898384 | 2021-01-05 | McHenry | Illinois | 17111 | 19766 | 223 |
849723 | 849723 | 2020-12-21 | Rock Island | Illinois | 17161 | 10423 | 223 |
684236 | 684236 | 2020-10-31 | St. Clair | Illinois | 17163 | 9344 | 223 |
677750 | 677750 | 2020-10-29 | St. Clair | Illinois | 17163 | 9152 | 223 |
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);