ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 79 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 |
---|---|---|---|---|---|---|---|
762092 | 762092 | 2020-11-24 | Pope | Illinois | 17151 | 79 | 1 |
645311 | 645311 | 2020-10-19 | Stark | Illinois | 17175 | 79 | 2 |
642060 | 642060 | 2020-10-18 | Schuyler | Illinois | 17169 | 79 | 1 |
638813 | 638813 | 2020-10-17 | Schuyler | Illinois | 17169 | 79 | 1 |
612805 | 612805 | 2020-10-09 | Edwards | Illinois | 17047 | 79 | 0 |
606326 | 606326 | 2020-10-07 | Gallatin | Illinois | 17059 | 79 | 2 |
606332 | 606332 | 2020-10-07 | Henderson | Illinois | 17071 | 79 | 0 |
603084 | 603084 | 2020-10-06 | Gallatin | Illinois | 17059 | 79 | 2 |
599844 | 599844 | 2020-10-05 | Hamilton | Illinois | 17065 | 79 | 2 |
580451 | 580451 | 2020-09-29 | Scott | Illinois | 17171 | 79 | 0 |
577210 | 577210 | 2020-09-28 | Scott | Illinois | 17171 | 79 | 0 |
515631 | 515631 | 2020-09-09 | Ford | Illinois | 17053 | 79 | 3 |
512398 | 512398 | 2020-09-08 | Ford | Illinois | 17053 | 79 | 3 |
509165 | 509165 | 2020-09-07 | Ford | Illinois | 17053 | 79 | 3 |
509203 | 509203 | 2020-09-07 | Menard | Illinois | 17129 | 79 | 0 |
505933 | 505933 | 2020-09-06 | Ford | Illinois | 17053 | 79 | 3 |
505971 | 505971 | 2020-09-06 | Menard | Illinois | 17129 | 79 | 0 |
502737 | 502737 | 2020-09-05 | Menard | Illinois | 17129 | 79 | 0 |
502747 | 502747 | 2020-09-05 | Pike | Illinois | 17149 | 79 | 0 |
486579 | 486579 | 2020-08-31 | Piatt | Illinois | 17147 | 79 | 0 |
476826 | 476826 | 2020-08-28 | Edgar | Illinois | 17045 | 79 | 0 |
441331 | 441331 | 2020-08-17 | Johnson | Illinois | 17087 | 79 | 0 |
438127 | 438127 | 2020-08-16 | Mercer | Illinois | 17131 | 79 | 4 |
434843 | 434843 | 2020-08-15 | Carroll | Illinois | 17015 | 79 | 4 |
415579 | 415579 | 2020-08-09 | Shelby | Illinois | 17173 | 79 | 1 |
412359 | 412359 | 2020-08-08 | Shelby | Illinois | 17173 | 79 | 1 |
409066 | 409066 | 2020-08-07 | Clark | Illinois | 17023 | 79 | 2 |
386588 | 386588 | 2020-07-31 | Logan | Illinois | 17107 | 79 | 0 |
380152 | 380152 | 2020-07-29 | Livingston | Illinois | 17105 | 79 | 2 |
357654 | 357654 | 2020-07-22 | Franklin | Illinois | 17055 | 79 | 0 |
354452 | 354452 | 2020-07-21 | Franklin | Illinois | 17055 | 79 | 0 |
332094 | 332094 | 2020-07-14 | Marion | Illinois | 17121 | 79 | 0 |
328907 | 328907 | 2020-07-13 | Marion | Illinois | 17121 | 79 | 0 |
316207 | 316207 | 2020-07-09 | Pulaski | Illinois | 17153 | 79 | 0 |
313033 | 313033 | 2020-07-08 | Pulaski | Illinois | 17153 | 79 | 0 |
309879 | 309879 | 2020-07-07 | Vermilion | Illinois | 17183 | 79 | 2 |
306695 | 306695 | 2020-07-06 | Pulaski | Illinois | 17153 | 79 | 0 |
306711 | 306711 | 2020-07-06 | Vermilion | Illinois | 17183 | 79 | 2 |
303530 | 303530 | 2020-07-05 | Pulaski | Illinois | 17153 | 79 | 0 |
278261 | 278261 | 2020-06-27 | Henry | Illinois | 17073 | 79 | 1 |
250060 | 250060 | 2020-06-18 | Cass | Illinois | 17017 | 79 | 0 |
206744 | 206744 | 2020-06-04 | Tazewell | Illinois | 17179 | 79 | 5 |
188276 | 188276 | 2020-05-29 | Lee | Illinois | 17103 | 79 | 1 |
185218 | 185218 | 2020-05-28 | Lee | Illinois | 17103 | 79 | 1 |
170001 | 170001 | 2020-05-23 | McDonough | Illinois | 17109 | 79 | 4 |
142823 | 142823 | 2020-05-14 | Knox | Illinois | 17095 | 79 | 0 |
139827 | 139827 | 2020-05-13 | Knox | Illinois | 17095 | 79 | 0 |
133865 | 133865 | 2020-05-11 | Monroe | Illinois | 17133 | 79 | 11 |
130874 | 130874 | 2020-05-10 | Monroe | Illinois | 17133 | 79 | 11 |
127883 | 127883 | 2020-05-09 | Monroe | Illinois | 17133 | 79 | 11 |
124896 | 124896 | 2020-05-08 | Monroe | Illinois | 17133 | 79 | 11 |
93051 | 93051 | 2020-04-27 | Boone | Illinois | 17007 | 79 | 9 |
87486 | 87486 | 2020-04-25 | Randolph | Illinois | 17157 | 79 | 1 |
84676 | 84676 | 2020-04-24 | Randolph | Illinois | 17157 | 79 | 1 |
54374 | 54374 | 2020-04-13 | McLean | Illinois | 17113 | 79 | 2 |
46353 | 46353 | 2020-04-10 | Champaign | Illinois | 17019 | 79 | 1 |
41205 | 41205 | 2020-04-08 | Kendall | Illinois | 17093 | 79 | 2 |
7392 | 7392 | 2020-03-22 | DuPage | Illinois | 17043 | 79 | 0 |
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);