ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 49 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
700443 | 700443 | 2020-11-05 | Pope | Illinois | 17151 | 49 | 1 |
697199 | 697199 | 2020-11-04 | Pope | Illinois | 17151 | 49 | 1 |
648503 | 648503 | 2020-10-20 | Hardin | Illinois | 17069 | 49 | 0 |
645258 | 645258 | 2020-10-19 | Hardin | Illinois | 17069 | 49 | 0 |
642011 | 642011 | 2020-10-18 | Hardin | Illinois | 17069 | 49 | 0 |
638764 | 638764 | 2020-10-17 | Hardin | Illinois | 17069 | 49 | 0 |
635518 | 635518 | 2020-10-16 | Hardin | Illinois | 17069 | 49 | 0 |
570724 | 570724 | 2020-09-26 | Schuyler | Illinois | 17169 | 49 | 0 |
567482 | 567482 | 2020-09-25 | Schuyler | Illinois | 17169 | 49 | 0 |
554523 | 554523 | 2020-09-21 | Putnam | Illinois | 17155 | 49 | 0 |
544817 | 544817 | 2020-09-18 | Stark | Illinois | 17175 | 49 | 2 |
518872 | 518872 | 2020-09-10 | Hamilton | Illinois | 17065 | 49 | 0 |
515637 | 515637 | 2020-09-09 | Hamilton | Illinois | 17065 | 49 | 0 |
499523 | 499523 | 2020-09-04 | Scott | Illinois | 17171 | 49 | 0 |
457441 | 457441 | 2020-08-22 | Crawford | Illinois | 17033 | 49 | 0 |
450991 | 450991 | 2020-08-20 | Edgar | Illinois | 17045 | 49 | 0 |
431704 | 431704 | 2020-08-14 | Wabash | Illinois | 17185 | 49 | 0 |
418741 | 418741 | 2020-08-10 | Ford | Illinois | 17053 | 49 | 2 |
415520 | 415520 | 2020-08-09 | Ford | Illinois | 17053 | 49 | 2 |
412300 | 412300 | 2020-08-08 | Ford | Illinois | 17053 | 49 | 2 |
409081 | 409081 | 2020-08-07 | Ford | Illinois | 17053 | 49 | 2 |
409084 | 409084 | 2020-08-07 | Gallatin | Illinois | 17059 | 49 | 2 |
399465 | 399465 | 2020-08-04 | Menard | Illinois | 17129 | 49 | 0 |
389754 | 389754 | 2020-08-01 | Bond | Illinois | 17005 | 49 | 2 |
376926 | 376926 | 2020-07-28 | Johnson | Illinois | 17087 | 49 | 0 |
376948 | 376948 | 2020-07-28 | Mercer | Illinois | 17131 | 49 | 0 |
376980 | 376980 | 2020-07-28 | White | Illinois | 17193 | 49 | 0 |
373707 | 373707 | 2020-07-27 | Jasper | Illinois | 17079 | 49 | 7 |
367289 | 367289 | 2020-07-25 | Johnson | Illinois | 17087 | 49 | 0 |
364078 | 364078 | 2020-07-24 | Jasper | Illinois | 17079 | 49 | 7 |
360871 | 360871 | 2020-07-23 | Jasper | Illinois | 17079 | 49 | 7 |
357666 | 357666 | 2020-07-22 | Jasper | Illinois | 17079 | 49 | 7 |
354464 | 354464 | 2020-07-21 | Jasper | Illinois | 17079 | 49 | 7 |
351262 | 351262 | 2020-07-20 | Jasper | Illinois | 17079 | 49 | 7 |
348034 | 348034 | 2020-07-19 | Clark | Illinois | 17023 | 49 | 0 |
348062 | 348062 | 2020-07-19 | Jasper | Illinois | 17079 | 49 | 7 |
344833 | 344833 | 2020-07-18 | Clark | Illinois | 17023 | 49 | 0 |
319314 | 319314 | 2020-07-10 | Christian | Illinois | 17021 | 49 | 5 |
316173 | 316173 | 2020-07-09 | Jo Daviess | Illinois | 17085 | 49 | 1 |
312999 | 312999 | 2020-07-08 | Jo Daviess | Illinois | 17085 | 49 | 1 |
306686 | 306686 | 2020-07-06 | Montgomery | Illinois | 17135 | 49 | 0 |
281445 | 281445 | 2020-06-28 | Perry | Illinois | 17145 | 49 | 0 |
278297 | 278297 | 2020-06-27 | Perry | Illinois | 17145 | 49 | 0 |
275132 | 275132 | 2020-06-26 | Macoupin | Illinois | 17117 | 49 | 3 |
259504 | 259504 | 2020-06-21 | Vermilion | Illinois | 17183 | 49 | 2 |
256378 | 256378 | 2020-06-20 | Vermilion | Illinois | 17183 | 49 | 2 |
160899 | 160899 | 2020-05-20 | Marion | Illinois | 17121 | 49 | 0 |
157873 | 157873 | 2020-05-19 | Marion | Illinois | 17121 | 49 | 0 |
133860 | 133860 | 2020-05-11 | McDonough | Illinois | 17109 | 49 | 2 |
130869 | 130869 | 2020-05-10 | McDonough | Illinois | 17109 | 49 | 2 |
127878 | 127878 | 2020-05-09 | McDonough | Illinois | 17109 | 49 | 2 |
118932 | 118932 | 2020-05-06 | Lee | Illinois | 17103 | 49 | 0 |
104464 | 104464 | 2020-05-01 | Henry | Illinois | 17073 | 49 | 0 |
98769 | 98769 | 2020-04-29 | LaSalle | Illinois | 17099 | 49 | 1 |
95925 | 95925 | 2020-04-28 | LaSalle | Illinois | 17099 | 49 | 1 |
90317 | 90317 | 2020-04-26 | Warren | Illinois | 17187 | 49 | 0 |
81895 | 81895 | 2020-04-23 | Whiteside | Illinois | 17195 | 49 | 3 |
79022 | 79022 | 2020-04-22 | Clinton | Illinois | 17027 | 49 | 0 |
59777 | 59777 | 2020-04-15 | Monroe | Illinois | 17133 | 49 | 4 |
36205 | 36205 | 2020-04-06 | Winnebago | Illinois | 17201 | 49 | 1 |
33713 | 33713 | 2020-04-05 | Kendall | Illinois | 17093 | 49 | 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);