ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 71 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
752354 | 752354 | 2020-11-21 | Pope | Illinois | 17151 | 71 | 1 |
713376 | 713376 | 2020-11-09 | Hardin | Illinois | 17069 | 71 | 0 |
622592 | 622592 | 2020-10-12 | Schuyler | Illinois | 17169 | 71 | 1 |
612859 | 612859 | 2020-10-09 | Putnam | Illinois | 17155 | 71 | 0 |
599816 | 599816 | 2020-10-05 | Brown | Illinois | 17009 | 71 | 0 |
596574 | 596574 | 2020-10-04 | Brown | Illinois | 17009 | 71 | 0 |
593332 | 593332 | 2020-10-03 | Brown | Illinois | 17009 | 71 | 0 |
593351 | 593351 | 2020-10-03 | Edwards | Illinois | 17047 | 71 | 0 |
590110 | 590110 | 2020-10-02 | Edwards | Illinois | 17047 | 71 | 0 |
583641 | 583641 | 2020-09-30 | Henderson | Illinois | 17071 | 71 | 0 |
577158 | 577158 | 2020-09-28 | Hamilton | Illinois | 17065 | 71 | 2 |
567428 | 567428 | 2020-09-25 | Gallatin | Illinois | 17059 | 71 | 2 |
564188 | 564188 | 2020-09-24 | Gallatin | Illinois | 17059 | 71 | 2 |
554447 | 554447 | 2020-09-21 | Alexander | Illinois | 17003 | 71 | 1 |
551208 | 551208 | 2020-09-20 | Alexander | Illinois | 17003 | 71 | 1 |
528607 | 528607 | 2020-09-13 | Marshall | Illinois | 17123 | 71 | 0 |
489765 | 489765 | 2020-09-01 | Ford | Illinois | 17053 | 71 | 2 |
483345 | 483345 | 2020-08-30 | Pike | Illinois | 17149 | 71 | 0 |
480063 | 480063 | 2020-08-29 | Ford | Illinois | 17053 | 71 | 2 |
470412 | 470412 | 2020-08-26 | Piatt | Illinois | 17147 | 71 | 0 |
460680 | 460680 | 2020-08-23 | Fulton | Illinois | 17057 | 71 | 0 |
460725 | 460725 | 2020-08-23 | Piatt | Illinois | 17147 | 71 | 0 |
457498 | 457498 | 2020-08-22 | Piatt | Illinois | 17147 | 71 | 0 |
454270 | 454270 | 2020-08-21 | Piatt | Illinois | 17147 | 71 | 0 |
451042 | 451042 | 2020-08-20 | Piatt | Illinois | 17147 | 71 | 0 |
447814 | 447814 | 2020-08-19 | Piatt | Illinois | 17147 | 71 | 0 |
444607 | 444607 | 2020-08-18 | Wabash | Illinois | 17185 | 71 | 0 |
434866 | 434866 | 2020-08-15 | Greene | Illinois | 17061 | 71 | 0 |
428426 | 428426 | 2020-08-13 | Johnson | Illinois | 17087 | 71 | 0 |
425184 | 425184 | 2020-08-12 | Fayette | Illinois | 17051 | 71 | 3 |
421981 | 421981 | 2020-08-11 | Johnson | Illinois | 17087 | 71 | 0 |
422035 | 422035 | 2020-08-11 | White | Illinois | 17193 | 71 | 0 |
370508 | 370508 | 2020-07-26 | Livingston | Illinois | 17105 | 71 | 2 |
370558 | 370558 | 2020-07-26 | Woodford | Illinois | 17203 | 71 | 3 |
367251 | 367251 | 2020-07-25 | Bureau | Illinois | 17011 | 71 | 2 |
348050 | 348050 | 2020-07-19 | Franklin | Illinois | 17055 | 71 | 0 |
341642 | 341642 | 2020-07-17 | Douglas | Illinois | 17041 | 71 | 0 |
271935 | 271935 | 2020-06-25 | Adams | Illinois | 17001 | 71 | 1 |
246976 | 246976 | 2020-06-17 | Henry | Illinois | 17073 | 71 | 1 |
225226 | 225226 | 2020-06-10 | Henry | Illinois | 17073 | 71 | 0 |
222131 | 222131 | 2020-06-09 | Henry | Illinois | 17073 | 71 | 0 |
219036 | 219036 | 2020-06-08 | Henry | Illinois | 17073 | 71 | 0 |
203674 | 203674 | 2020-06-03 | Williamson | Illinois | 17199 | 71 | 2 |
188233 | 188233 | 2020-05-29 | Cass | Illinois | 17017 | 71 | 0 |
188313 | 188313 | 2020-05-29 | Tazewell | Illinois | 17179 | 71 | 4 |
185255 | 185255 | 2020-05-28 | Tazewell | Illinois | 17179 | 71 | 4 |
127864 | 127864 | 2020-05-09 | Knox | Illinois | 17095 | 71 | 0 |
113123 | 113123 | 2020-05-04 | Stephenson | Illinois | 17177 | 71 | 0 |
107359 | 107359 | 2020-05-02 | Monroe | Illinois | 17133 | 71 | 10 |
104494 | 104494 | 2020-05-01 | Monroe | Illinois | 17133 | 71 | 10 |
90247 | 90247 | 2020-04-26 | DeKalb | Illinois | 17037 | 71 | 1 |
87416 | 87416 | 2020-04-25 | Boone | Illinois | 17007 | 71 | 8 |
87431 | 87431 | 2020-04-25 | DeKalb | Illinois | 17037 | 71 | 1 |
81870 | 81870 | 2020-04-23 | Ogle | Illinois | 17141 | 71 | 1 |
79077 | 79077 | 2020-04-22 | Ogle | Illinois | 17141 | 71 | 1 |
65253 | 65253 | 2020-04-17 | Unknown | Illinois | 71 | 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);