ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where deaths = 217 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Illinois · 57 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500234 | 2500234 | 2022-05-13 | Marion | Illinois | 17121 | 11933 | 217 |
2496976 | 2496976 | 2022-05-12 | Marion | Illinois | 17121 | 11929 | 217 |
2493718 | 2493718 | 2022-05-11 | Marion | Illinois | 17121 | 11925 | 217 |
2490460 | 2490460 | 2022-05-10 | Marion | Illinois | 17121 | 11919 | 217 |
2487203 | 2487203 | 2022-05-09 | Marion | Illinois | 17121 | 11916 | 217 |
2483945 | 2483945 | 2022-05-08 | Marion | Illinois | 17121 | 11914 | 217 |
2480687 | 2480687 | 2022-05-07 | Marion | Illinois | 17121 | 11914 | 217 |
2477429 | 2477429 | 2022-05-06 | Marion | Illinois | 17121 | 11914 | 217 |
2474171 | 2474171 | 2022-05-05 | Marion | Illinois | 17121 | 11911 | 217 |
2470914 | 2470914 | 2022-05-04 | Marion | Illinois | 17121 | 11911 | 217 |
2467658 | 2467658 | 2022-05-03 | Marion | Illinois | 17121 | 11909 | 217 |
2464403 | 2464403 | 2022-05-02 | Marion | Illinois | 17121 | 11907 | 217 |
2461147 | 2461147 | 2022-05-01 | Marion | Illinois | 17121 | 11901 | 217 |
2457891 | 2457891 | 2022-04-30 | Marion | Illinois | 17121 | 11901 | 217 |
2454635 | 2454635 | 2022-04-29 | Marion | Illinois | 17121 | 11901 | 217 |
2451379 | 2451379 | 2022-04-28 | Marion | Illinois | 17121 | 11899 | 217 |
2448123 | 2448123 | 2022-04-27 | Marion | Illinois | 17121 | 11891 | 217 |
2444867 | 2444867 | 2022-04-26 | Marion | Illinois | 17121 | 11887 | 217 |
2441611 | 2441611 | 2022-04-25 | Marion | Illinois | 17121 | 11885 | 217 |
2438355 | 2438355 | 2022-04-24 | Marion | Illinois | 17121 | 11879 | 217 |
2435099 | 2435099 | 2022-04-23 | Marion | Illinois | 17121 | 11879 | 217 |
2431843 | 2431843 | 2022-04-22 | Marion | Illinois | 17121 | 11879 | 217 |
2428587 | 2428587 | 2022-04-21 | Marion | Illinois | 17121 | 11877 | 217 |
2155272 | 2155272 | 2022-01-27 | Adams | Illinois | 17001 | 20809 | 217 |
2152019 | 2152019 | 2022-01-26 | Adams | Illinois | 17001 | 20660 | 217 |
2148767 | 2148767 | 2022-01-25 | Adams | Illinois | 17001 | 20519 | 217 |
2106527 | 2106527 | 2022-01-12 | Knox | Illinois | 17095 | 10468 | 217 |
2103276 | 2103276 | 2022-01-11 | Knox | Illinois | 17095 | 10342 | 217 |
2100025 | 2100025 | 2022-01-10 | Knox | Illinois | 17095 | 10221 | 217 |
2096774 | 2096774 | 2022-01-09 | Knox | Illinois | 17095 | 9893 | 217 |
2093522 | 2093522 | 2022-01-08 | Knox | Illinois | 17095 | 9893 | 217 |
2090270 | 2090270 | 2022-01-07 | Knox | Illinois | 17095 | 9893 | 217 |
2087019 | 2087019 | 2022-01-06 | Knox | Illinois | 17095 | 9543 | 217 |
2005717 | 2005717 | 2021-12-12 | Champaign | Illinois | 17019 | 31639 | 217 |
2002466 | 2002466 | 2021-12-11 | Champaign | Illinois | 17019 | 31639 | 217 |
1999216 | 1999216 | 2021-12-10 | Champaign | Illinois | 17019 | 31639 | 217 |
1995965 | 1995965 | 2021-12-09 | Champaign | Illinois | 17019 | 31449 | 217 |
1690608 | 1690608 | 2021-09-06 | Whiteside | Illinois | 17195 | 7691 | 217 |
1687358 | 1687358 | 2021-09-05 | Whiteside | Illinois | 17195 | 7691 | 217 |
1684108 | 1684108 | 2021-09-04 | Whiteside | Illinois | 17195 | 7691 | 217 |
1680857 | 1680857 | 2021-09-03 | Whiteside | Illinois | 17195 | 7691 | 217 |
1339892 | 1339892 | 2021-05-21 | McLean | Illinois | 17113 | 18341 | 217 |
1336645 | 1336645 | 2021-05-20 | McLean | Illinois | 17113 | 18321 | 217 |
1333398 | 1333398 | 2021-05-19 | McLean | Illinois | 17113 | 18296 | 217 |
1330151 | 1330151 | 2021-05-18 | McLean | Illinois | 17113 | 18281 | 217 |
1326904 | 1326904 | 2021-05-17 | McLean | Illinois | 17113 | 18236 | 217 |
1323658 | 1323658 | 2021-05-16 | McLean | Illinois | 17113 | 18225 | 217 |
1307407 | 1307407 | 2021-05-11 | Kankakee | Illinois | 17091 | 14120 | 217 |
1304161 | 1304161 | 2021-05-10 | Kankakee | Illinois | 17091 | 14087 | 217 |
1300914 | 1300914 | 2021-05-09 | Kankakee | Illinois | 17091 | 14074 | 217 |
1297667 | 1297667 | 2021-05-08 | Kankakee | Illinois | 17091 | 14058 | 217 |
885400 | 885400 | 2021-01-01 | McHenry | Illinois | 17111 | 19128 | 217 |
882155 | 882155 | 2020-12-31 | McHenry | Illinois | 17111 | 19128 | 217 |
878910 | 878910 | 2020-12-30 | McHenry | Illinois | 17111 | 18949 | 217 |
859426 | 859426 | 2020-12-24 | LaSalle | Illinois | 17099 | 8008 | 217 |
745843 | 745843 | 2020-11-19 | Madison | Illinois | 17119 | 12032 | 217 |
648555 | 648555 | 2020-10-20 | St. Clair | Illinois | 17163 | 8541 | 217 |
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);