ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 389 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1378819 | 1378819 | 2021-06-02 | Hardin | Illinois | 17069 | 389 | 12 |
1375573 | 1375573 | 2021-06-01 | Hardin | Illinois | 17069 | 389 | 12 |
1372328 | 1372328 | 2021-05-31 | Hardin | Illinois | 17069 | 389 | 12 |
1369083 | 1369083 | 2021-05-30 | Hardin | Illinois | 17069 | 389 | 12 |
1365837 | 1365837 | 2021-05-29 | Hardin | Illinois | 17069 | 389 | 12 |
1362591 | 1362591 | 2021-05-28 | Hardin | Illinois | 17069 | 389 | 12 |
1359344 | 1359344 | 2021-05-27 | Hardin | Illinois | 17069 | 389 | 12 |
1356098 | 1356098 | 2021-05-26 | Hardin | Illinois | 17069 | 389 | 12 |
1352852 | 1352852 | 2021-05-25 | Hardin | Illinois | 17069 | 389 | 12 |
1015236 | 1015236 | 2021-02-10 | Putnam | Illinois | 17155 | 389 | 4 |
947030 | 947030 | 2021-01-20 | Gallatin | Illinois | 17059 | 389 | 4 |
943755 | 943755 | 2021-01-19 | Alexander | Illinois | 17003 | 389 | 7 |
940510 | 940510 | 2021-01-18 | Alexander | Illinois | 17003 | 389 | 7 |
865903 | 865903 | 2020-12-26 | Henderson | Illinois | 17071 | 389 | 6 |
830256 | 830256 | 2020-12-15 | Stark | Illinois | 17175 | 389 | 10 |
703670 | 703670 | 2020-11-06 | Mason | Illinois | 17125 | 389 | 13 |
622605 | 622605 | 2020-10-12 | Wayne | Illinois | 17191 | 389 | 7 |
583673 | 583673 | 2020-09-30 | Montgomery | Illinois | 17135 | 389 | 12 |
567440 | 567440 | 2020-09-25 | Jersey | Illinois | 17083 | 389 | 15 |
564184 | 564184 | 2020-09-24 | Fayette | Illinois | 17051 | 389 | 3 |
560927 | 560927 | 2020-09-23 | Cass | Illinois | 17017 | 389 | 11 |
557699 | 557699 | 2020-09-22 | Crawford | Illinois | 17033 | 389 | 2 |
554462 | 554462 | 2020-09-21 | Crawford | Illinois | 17033 | 389 | 1 |
551309 | 551309 | 2020-09-20 | Woodford | Illinois | 17203 | 389 | 6 |
515632 | 515632 | 2020-09-09 | Franklin | Illinois | 17055 | 389 | 1 |
344860 | 344860 | 2020-07-18 | Jackson | Illinois | 17077 | 389 | 19 |
259495 | 259495 | 2020-06-21 | Sangamon | Illinois | 17167 | 389 | 33 |
256369 | 256369 | 2020-06-20 | Sangamon | Illinois | 17167 | 389 | 33 |
253249 | 253249 | 2020-06-19 | Sangamon | Illinois | 17167 | 389 | 33 |
237679 | 237679 | 2020-06-14 | Peoria | Illinois | 17143 | 389 | 20 |
169944 | 169944 | 2020-05-23 | Boone | Illinois | 17007 | 389 | 16 |
104506 | 104506 | 2020-05-01 | Rock Island | Illinois | 17161 | 389 | 9 |
22232 | 22232 | 2020-03-31 | Lake | Illinois | 17097 | 389 | 7 |
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);