ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 76 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
609544 | 609544 | 2020-10-08 | Brown | Illinois | 17009 | 76 | 0 |
593360 | 593360 | 2020-10-03 | Hamilton | Illinois | 17065 | 76 | 2 |
593363 | 593363 | 2020-10-03 | Henderson | Illinois | 17071 | 76 | 0 |
590119 | 590119 | 2020-10-02 | Hamilton | Illinois | 17065 | 76 | 2 |
586875 | 586875 | 2020-10-01 | Gallatin | Illinois | 17059 | 76 | 2 |
567400 | 567400 | 2020-09-25 | Alexander | Illinois | 17003 | 76 | 1 |
564243 | 564243 | 2020-09-24 | Scott | Illinois | 17171 | 76 | 0 |
535079 | 535079 | 2020-09-15 | Marshall | Illinois | 17123 | 76 | 0 |
518900 | 518900 | 2020-09-10 | Massac | Illinois | 17127 | 76 | 1 |
499518 | 499518 | 2020-09-04 | Richland | Illinois | 17159 | 76 | 4 |
476877 | 476877 | 2020-08-28 | Piatt | Illinois | 17147 | 76 | 0 |
473630 | 473630 | 2020-08-27 | Mason | Illinois | 17125 | 76 | 1 |
444609 | 444609 | 2020-08-18 | Washington | Illinois | 17189 | 76 | 1 |
431644 | 431644 | 2020-08-14 | Hancock | Illinois | 17067 | 76 | 1 |
431654 | 431654 | 2020-08-14 | Johnson | Illinois | 17087 | 76 | 0 |
431676 | 431676 | 2020-08-14 | Mercer | Illinois | 17131 | 76 | 4 |
422003 | 422003 | 2020-08-11 | Mercer | Illinois | 17131 | 76 | 4 |
418780 | 418780 | 2020-08-10 | Mercer | Illinois | 17131 | 76 | 4 |
405846 | 405846 | 2020-08-06 | Clark | Illinois | 17023 | 76 | 1 |
376935 | 376935 | 2020-07-28 | Livingston | Illinois | 17105 | 76 | 2 |
367256 | 367256 | 2020-07-25 | Christian | Illinois | 17021 | 76 | 5 |
348043 | 348043 | 2020-07-19 | Douglas | Illinois | 17041 | 76 | 0 |
338481 | 338481 | 2020-07-16 | Macoupin | Illinois | 17117 | 76 | 3 |
300366 | 300366 | 2020-07-04 | Pulaski | Illinois | 17153 | 76 | 0 |
297204 | 297204 | 2020-07-03 | Pulaski | Illinois | 17153 | 76 | 0 |
294047 | 294047 | 2020-07-02 | Pulaski | Illinois | 17153 | 76 | 0 |
290893 | 290893 | 2020-07-01 | Pulaski | Illinois | 17153 | 76 | 0 |
275077 | 275077 | 2020-06-26 | Adams | Illinois | 17001 | 76 | 1 |
265704 | 265704 | 2020-06-23 | Henry | Illinois | 17073 | 76 | 1 |
243835 | 243835 | 2020-06-16 | Cass | Illinois | 17017 | 76 | 0 |
240724 | 240724 | 2020-06-15 | Cass | Illinois | 17017 | 76 | 0 |
237616 | 237616 | 2020-06-14 | Cass | Illinois | 17017 | 76 | 0 |
216007 | 216007 | 2020-06-07 | Williamson | Illinois | 17199 | 76 | 3 |
212920 | 212920 | 2020-06-06 | Williamson | Illinois | 17199 | 76 | 3 |
209745 | 209745 | 2020-06-05 | Cass | Illinois | 17017 | 76 | 0 |
182164 | 182164 | 2020-05-27 | Lee | Illinois | 17103 | 76 | 1 |
179120 | 179120 | 2020-05-26 | Lee | Illinois | 17103 | 76 | 1 |
169991 | 169991 | 2020-05-23 | Lee | Illinois | 17103 | 76 | 1 |
95972 | 95972 | 2020-04-28 | Whiteside | Illinois | 17195 | 76 | 5 |
93066 | 93066 | 2020-04-27 | DeKalb | Illinois | 17037 | 76 | 1 |
90232 | 90232 | 2020-04-26 | Boone | Illinois | 17007 | 76 | 8 |
81880 | 81880 | 2020-04-23 | Sangamon | Illinois | 17167 | 76 | 5 |
46422 | 46422 | 2020-04-10 | Unknown | Illinois | 76 | 0 | |
33712 | 33712 | 2020-04-05 | Kankakee | Illinois | 17091 | 76 | 6 |
2872 | 2872 | 2020-03-16 | Cook | Illinois | 17031 | 76 | 0 |
2431 | 2431 | 2020-03-15 | Cook | Illinois | 17031 | 76 | 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);