ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 85 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 |
---|---|---|---|---|---|---|---|
690645 | 690645 | 2020-11-02 | Calhoun | Illinois | 17013 | 85 | 0 |
661534 | 661534 | 2020-10-24 | Stark | Illinois | 17175 | 85 | 3 |
645301 | 645301 | 2020-10-19 | Putnam | Illinois | 17155 | 85 | 0 |
616058 | 616058 | 2020-10-10 | Henderson | Illinois | 17071 | 85 | 0 |
583607 | 583607 | 2020-09-30 | Alexander | Illinois | 17003 | 85 | 1 |
544788 | 544788 | 2020-09-18 | Marshall | Illinois | 17123 | 85 | 0 |
531846 | 531846 | 2020-09-14 | Massac | Illinois | 17127 | 85 | 1 |
515669 | 515669 | 2020-09-09 | Menard | Illinois | 17129 | 85 | 0 |
515679 | 515679 | 2020-09-09 | Pike | Illinois | 17149 | 85 | 1 |
457521 | 457521 | 2020-08-22 | Wayne | Illinois | 17191 | 85 | 2 |
434869 | 434869 | 2020-08-15 | Hancock | Illinois | 17067 | 85 | 1 |
405876 | 405876 | 2020-08-06 | Jersey | Illinois | 17083 | 85 | 1 |
393022 | 393022 | 2020-08-02 | Logan | Illinois | 17107 | 85 | 0 |
389805 | 389805 | 2020-08-01 | Logan | Illinois | 17107 | 85 | 0 |
386587 | 386587 | 2020-07-31 | Livingston | Illinois | 17105 | 85 | 2 |
332113 | 332113 | 2020-07-14 | Pulaski | Illinois | 17153 | 85 | 0 |
328926 | 328926 | 2020-07-13 | Pulaski | Illinois | 17153 | 85 | 0 |
316223 | 316223 | 2020-07-09 | Vermilion | Illinois | 17183 | 85 | 2 |
157831 | 157831 | 2020-05-19 | Coles | Illinois | 17029 | 85 | 7 |
154815 | 154815 | 2020-05-18 | Coles | Illinois | 17029 | 85 | 5 |
116012 | 116012 | 2020-05-05 | Warren | Illinois | 17187 | 85 | 0 |
113129 | 113129 | 2020-05-04 | Warren | Illinois | 17187 | 85 | 0 |
104468 | 104468 | 2020-05-01 | Jefferson | Illinois | 17081 | 85 | 12 |
98792 | 98792 | 2020-04-29 | Peoria | Illinois | 17143 | 85 | 2 |
93060 | 93060 | 2020-04-27 | Clinton | Illinois | 17027 | 85 | 1 |
87480 | 87480 | 2020-04-25 | Ogle | Illinois | 17141 | 85 | 1 |
70739 | 70739 | 2020-04-19 | McLean | Illinois | 17113 | 85 | 3 |
48984 | 48984 | 2020-04-11 | Champaign | Illinois | 17019 | 85 | 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);