ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 91 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
661530 | 661530 | 2020-10-24 | Schuyler | Illinois | 17169 | 91 | 1 |
625783 | 625783 | 2020-10-13 | Hamilton | Illinois | 17065 | 91 | 2 |
599813 | 599813 | 2020-10-05 | Alexander | Illinois | 17003 | 91 | 1 |
544756 | 544756 | 2020-09-18 | Ford | Illinois | 17053 | 91 | 4 |
518904 | 518904 | 2020-09-10 | Menard | Illinois | 17129 | 91 | 0 |
512451 | 512451 | 2020-09-08 | Richland | Illinois | 17159 | 91 | 4 |
492984 | 492984 | 2020-09-02 | Clay | Illinois | 17025 | 91 | 0 |
467149 | 467149 | 2020-08-25 | Jasper | Illinois | 17079 | 91 | 7 |
467175 | 467175 | 2020-08-25 | Mercer | Illinois | 17131 | 91 | 4 |
454227 | 454227 | 2020-08-21 | Greene | Illinois | 17061 | 91 | 0 |
431622 | 431622 | 2020-08-14 | Clark | Illinois | 17023 | 91 | 2 |
405911 | 405911 | 2020-08-06 | Pulaski | Illinois | 17153 | 91 | 0 |
402693 | 402693 | 2020-08-05 | Pulaski | Illinois | 17153 | 91 | 0 |
399477 | 399477 | 2020-08-04 | Pulaski | Illinois | 17153 | 91 | 0 |
396261 | 396261 | 2020-08-03 | Pulaski | Illinois | 17153 | 91 | 0 |
393045 | 393045 | 2020-08-02 | Pulaski | Illinois | 17153 | 91 | 0 |
389854 | 389854 | 2020-08-01 | Woodford | Illinois | 17203 | 91 | 3 |
380105 | 380105 | 2020-07-29 | Bureau | Illinois | 17011 | 91 | 2 |
367273 | 367273 | 2020-07-25 | Franklin | Illinois | 17055 | 91 | 0 |
253266 | 253266 | 2020-06-19 | Williamson | Illinois | 17199 | 91 | 4 |
250151 | 250151 | 2020-06-18 | Williamson | Illinois | 17199 | 91 | 3 |
237696 | 237696 | 2020-06-14 | Tazewell | Illinois | 17179 | 91 | 6 |
209798 | 209798 | 2020-06-05 | McDonough | Illinois | 17109 | 91 | 13 |
200561 | 200561 | 2020-06-02 | McDonough | Illinois | 17109 | 91 | 13 |
173047 | 173047 | 2020-05-24 | Monroe | Illinois | 17133 | 91 | 11 |
170006 | 170006 | 2020-05-23 | Monroe | Illinois | 17133 | 91 | 11 |
166969 | 166969 | 2020-05-22 | Monroe | Illinois | 17133 | 91 | 11 |
121899 | 121899 | 2020-05-07 | LaSalle | Illinois | 17099 | 91 | 2 |
51708 | 51708 | 2020-04-12 | Rock Island | Illinois | 17161 | 91 | 3 |
51717 | 51717 | 2020-04-12 | Unknown | Illinois | 91 | 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);