ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 78 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 |
---|---|---|---|---|---|---|---|
723106 | 723106 | 2020-11-12 | Hardin | Illinois | 17069 | 78 | 0 |
719863 | 719863 | 2020-11-11 | Hardin | Illinois | 17069 | 78 | 0 |
642064 | 642064 | 2020-10-18 | Stark | Illinois | 17175 | 78 | 2 |
638817 | 638817 | 2020-10-17 | Stark | Illinois | 17175 | 78 | 2 |
635567 | 635567 | 2020-10-16 | Schuyler | Illinois | 17169 | 78 | 1 |
635571 | 635571 | 2020-10-16 | Stark | Illinois | 17175 | 78 | 2 |
622513 | 622513 | 2020-10-12 | Brown | Illinois | 17009 | 78 | 0 |
619269 | 619269 | 2020-10-11 | Brown | Illinois | 17009 | 78 | 0 |
616027 | 616027 | 2020-10-10 | Brown | Illinois | 17009 | 78 | 0 |
609563 | 609563 | 2020-10-08 | Edwards | Illinois | 17047 | 78 | 0 |
603090 | 603090 | 2020-10-06 | Henderson | Illinois | 17071 | 78 | 0 |
599841 | 599841 | 2020-10-05 | Gallatin | Illinois | 17059 | 78 | 2 |
599847 | 599847 | 2020-10-05 | Henderson | Illinois | 17071 | 78 | 0 |
596599 | 596599 | 2020-10-04 | Gallatin | Illinois | 17059 | 78 | 2 |
596602 | 596602 | 2020-10-04 | Hamilton | Illinois | 17065 | 78 | 2 |
573968 | 573968 | 2020-09-27 | Scott | Illinois | 17171 | 78 | 0 |
570725 | 570725 | 2020-09-26 | Scott | Illinois | 17171 | 78 | 0 |
522137 | 522137 | 2020-09-11 | Massac | Illinois | 17127 | 78 | 1 |
502752 | 502752 | 2020-09-05 | Richland | Illinois | 17159 | 78 | 4 |
499513 | 499513 | 2020-09-04 | Pike | Illinois | 17149 | 78 | 0 |
486522 | 486522 | 2020-08-31 | Crawford | Illinois | 17033 | 78 | 0 |
483283 | 483283 | 2020-08-30 | Clay | Illinois | 17025 | 78 | 0 |
483344 | 483344 | 2020-08-30 | Piatt | Illinois | 17147 | 78 | 0 |
480110 | 480110 | 2020-08-29 | Piatt | Illinois | 17147 | 78 | 0 |
454236 | 454236 | 2020-08-21 | Jasper | Illinois | 17079 | 78 | 7 |
447836 | 447836 | 2020-08-19 | Washington | Illinois | 17189 | 78 | 1 |
444544 | 444544 | 2020-08-18 | Greene | Illinois | 17061 | 78 | 0 |
438087 | 438087 | 2020-08-16 | Fayette | Illinois | 17051 | 78 | 3 |
438105 | 438105 | 2020-08-16 | Johnson | Illinois | 17087 | 78 | 0 |
434861 | 434861 | 2020-08-15 | Fayette | Illinois | 17051 | 78 | 3 |
434901 | 434901 | 2020-08-15 | Mercer | Illinois | 17131 | 78 | 4 |
370461 | 370461 | 2020-07-26 | Bureau | Illinois | 17011 | 78 | 2 |
370466 | 370466 | 2020-07-26 | Christian | Illinois | 17021 | 78 | 5 |
351250 | 351250 | 2020-07-20 | Franklin | Illinois | 17055 | 78 | 0 |
303546 | 303546 | 2020-07-05 | Vermilion | Illinois | 17183 | 78 | 2 |
275113 | 275113 | 2020-06-26 | Henry | Illinois | 17073 | 78 | 1 |
271971 | 271971 | 2020-06-25 | Henry | Illinois | 17073 | 78 | 1 |
246948 | 246948 | 2020-06-17 | Cass | Illinois | 17017 | 78 | 0 |
203664 | 203664 | 2020-06-03 | Tazewell | Illinois | 17179 | 78 | 5 |
121936 | 121936 | 2020-05-07 | Stephenson | Illinois | 17177 | 78 | 0 |
110254 | 110254 | 2020-05-03 | Warren | Illinois | 17187 | 78 | 0 |
95948 | 95948 | 2020-04-28 | Peoria | Illinois | 17143 | 78 | 2 |
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);