ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 90 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668019 | 668019 | 2020-10-26 | Schuyler | Illinois | 17169 | 90 | 1 |
664775 | 664775 | 2020-10-25 | Schuyler | Illinois | 17169 | 90 | 1 |
661524 | 661524 | 2020-10-24 | Putnam | Illinois | 17155 | 90 | 0 |
625786 | 625786 | 2020-10-13 | Henderson | Illinois | 17071 | 90 | 0 |
622541 | 622541 | 2020-10-12 | Hamilton | Illinois | 17065 | 90 | 2 |
596571 | 596571 | 2020-10-04 | Alexander | Illinois | 17003 | 90 | 1 |
544790 | 544790 | 2020-09-18 | Massac | Illinois | 17127 | 90 | 2 |
531812 | 531812 | 2020-09-14 | Ford | Illinois | 17053 | 90 | 4 |
473667 | 473667 | 2020-08-27 | Wayne | Illinois | 17191 | 90 | 2 |
470435 | 470435 | 2020-08-26 | Wayne | Illinois | 17191 | 90 | 2 |
463946 | 463946 | 2020-08-24 | Mercer | Illinois | 17131 | 90 | 4 |
460717 | 460717 | 2020-08-23 | Mercer | Illinois | 17131 | 90 | 4 |
457490 | 457490 | 2020-08-22 | Mercer | Illinois | 17131 | 90 | 4 |
425244 | 425244 | 2020-08-12 | Shelby | Illinois | 17173 | 90 | 1 |
405888 | 405888 | 2020-08-06 | Logan | Illinois | 17107 | 90 | 0 |
402670 | 402670 | 2020-08-05 | Logan | Illinois | 17107 | 90 | 0 |
389828 | 389828 | 2020-08-01 | Pulaski | Illinois | 17153 | 90 | 0 |
386611 | 386611 | 2020-07-31 | Pulaski | Illinois | 17153 | 90 | 0 |
383393 | 383393 | 2020-07-30 | Pulaski | Illinois | 17153 | 90 | 0 |
380176 | 380176 | 2020-07-29 | Pulaski | Illinois | 17153 | 90 | 0 |
376959 | 376959 | 2020-07-28 | Pulaski | Illinois | 17153 | 90 | 0 |
364066 | 364066 | 2020-07-24 | Franklin | Illinois | 17055 | 90 | 0 |
335297 | 335297 | 2020-07-15 | Montgomery | Illinois | 17135 | 90 | 1 |
332129 | 332129 | 2020-07-14 | Vermilion | Illinois | 17183 | 90 | 2 |
294007 | 294007 | 2020-07-02 | Henry | Illinois | 17073 | 90 | 1 |
250103 | 250103 | 2020-06-18 | Lee | Illinois | 17103 | 90 | 1 |
246991 | 246991 | 2020-06-17 | Lee | Illinois | 17103 | 90 | 1 |
163917 | 163917 | 2020-05-21 | Knox | Illinois | 17095 | 90 | 0 |
163936 | 163936 | 2020-05-21 | Monroe | Illinois | 17133 | 90 | 11 |
160889 | 160889 | 2020-05-20 | Knox | Illinois | 17095 | 90 | 0 |
160908 | 160908 | 2020-05-20 | Monroe | Illinois | 17133 | 90 | 11 |
157882 | 157882 | 2020-05-19 | Monroe | Illinois | 17133 | 90 | 11 |
98742 | 98742 | 2020-04-29 | DeKalb | Illinois | 17037 | 90 | 1 |
95892 | 95892 | 2020-04-28 | Clinton | Illinois | 17027 | 90 | 1 |
62446 | 62446 | 2020-04-16 | Champaign | Illinois | 17019 | 90 | 4 |
59725 | 59725 | 2020-04-15 | Champaign | Illinois | 17019 | 90 | 2 |
36164 | 36164 | 2020-04-06 | Kankakee | Illinois | 17091 | 90 | 5 |
16234 | 16234 | 2020-03-28 | Kane | Illinois | 17089 | 90 | 4 |
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);