ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 172 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
817218 | 817218 | 2020-12-11 | Hardin | Illinois | 17069 | 172 | 4 |
739316 | 739316 | 2020-11-17 | Edwards | Illinois | 17047 | 172 | 3 |
723156 | 723156 | 2020-11-12 | Scott | Illinois | 17171 | 172 | 0 |
710133 | 710133 | 2020-11-08 | Henderson | Illinois | 17071 | 172 | 0 |
687454 | 687454 | 2020-11-01 | Massac | Illinois | 17127 | 172 | 2 |
619338 | 619338 | 2020-10-11 | Piatt | Illinois | 17147 | 172 | 0 |
609633 | 609633 | 2020-10-08 | Wabash | Illinois | 17185 | 172 | 4 |
590130 | 590130 | 2020-10-02 | Johnson | Illinois | 17087 | 172 | 0 |
590146 | 590146 | 2020-10-02 | Mason | Illinois | 17125 | 172 | 1 |
570652 | 570652 | 2020-09-26 | Clark | Illinois | 17023 | 172 | 2 |
541589 | 541589 | 2020-09-17 | Washington | Illinois | 17189 | 172 | 1 |
518870 | 518870 | 2020-09-10 | Greene | Illinois | 17061 | 172 | 1 |
515622 | 515622 | 2020-09-09 | Cumberland | Illinois | 17035 | 172 | 4 |
489764 | 489764 | 2020-09-01 | Fayette | Illinois | 17051 | 172 | 3 |
470391 | 470391 | 2020-08-26 | Livingston | Illinois | 17105 | 172 | 4 |
431668 | 431668 | 2020-08-14 | Marion | Illinois | 17121 | 172 | 0 |
425261 | 425261 | 2020-08-12 | Woodford | Illinois | 17203 | 172 | 3 |
376977 | 376977 | 2020-07-28 | Warren | Illinois | 17187 | 172 | 0 |
322572 | 322572 | 2020-07-11 | Tazewell | Illinois | 17179 | 172 | 8 |
319341 | 319341 | 2020-07-10 | Iroquois | Illinois | 17075 | 172 | 5 |
303468 | 303468 | 2020-07-05 | Coles | Illinois | 17029 | 172 | 17 |
300304 | 300304 | 2020-07-04 | Coles | Illinois | 17029 | 172 | 17 |
259510 | 259510 | 2020-06-21 | Whiteside | Illinois | 17195 | 172 | 15 |
234590 | 234590 | 2020-06-13 | Union | Illinois | 17181 | 172 | 17 |
231484 | 231484 | 2020-06-12 | Union | Illinois | 17181 | 172 | 17 |
228381 | 228381 | 2020-06-11 | Union | Illinois | 17181 | 172 | 15 |
225238 | 225238 | 2020-06-10 | LaSalle | Illinois | 17099 | 172 | 16 |
225279 | 225279 | 2020-06-10 | Union | Illinois | 17181 | 172 | 15 |
68011 | 68011 | 2020-04-18 | Winnebago | Illinois | 17201 | 172 | 9 |
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);