ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 132 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 |
---|---|---|---|---|---|---|---|
706883 | 706883 | 2020-11-07 | Gallatin | Illinois | 17059 | 132 | 3 |
703640 | 703640 | 2020-11-06 | Gallatin | Illinois | 17059 | 132 | 3 |
677699 | 677699 | 2020-10-29 | Henderson | Illinois | 17071 | 132 | 0 |
671180 | 671180 | 2020-10-27 | Alexander | Illinois | 17003 | 132 | 1 |
638788 | 638788 | 2020-10-17 | Marshall | Illinois | 17123 | 132 | 3 |
635542 | 635542 | 2020-10-16 | Marshall | Illinois | 17123 | 132 | 3 |
622531 | 622531 | 2020-10-12 | Edgar | Illinois | 17045 | 132 | 8 |
564232 | 564232 | 2020-09-24 | Piatt | Illinois | 17147 | 132 | 0 |
560992 | 560992 | 2020-09-23 | Piatt | Illinois | 17147 | 132 | 0 |
531798 | 531798 | 2020-09-14 | Clay | Illinois | 17025 | 132 | 0 |
493048 | 493048 | 2020-09-02 | Pulaski | Illinois | 17153 | 132 | 1 |
489778 | 489778 | 2020-09-01 | Jasper | Illinois | 17079 | 132 | 7 |
480044 | 480044 | 2020-08-29 | Carroll | Illinois | 17015 | 132 | 4 |
480070 | 480070 | 2020-08-29 | Hancock | Illinois | 17067 | 132 | 2 |
418796 | 418796 | 2020-08-10 | Saline | Illinois | 17165 | 132 | 2 |
415575 | 415575 | 2020-08-09 | Saline | Illinois | 17165 | 132 | 2 |
396212 | 396212 | 2020-08-03 | Franklin | Illinois | 17055 | 132 | 0 |
389757 | 389757 | 2020-08-01 | Bureau | Illinois | 17011 | 132 | 2 |
389809 | 389809 | 2020-08-01 | Marion | Illinois | 17121 | 132 | 0 |
380167 | 380167 | 2020-07-29 | Montgomery | Illinois | 17135 | 132 | 5 |
319372 | 319372 | 2020-07-10 | Morgan | Illinois | 17137 | 132 | 3 |
316199 | 316199 | 2020-07-09 | Morgan | Illinois | 17137 | 132 | 3 |
313025 | 313025 | 2020-07-08 | Morgan | Illinois | 17137 | 132 | 3 |
309855 | 309855 | 2020-07-07 | Morgan | Illinois | 17137 | 132 | 3 |
303554 | 303554 | 2020-07-05 | Williamson | Illinois | 17199 | 132 | 4 |
290864 | 290864 | 2020-07-01 | Knox | Illinois | 17095 | 132 | 0 |
200537 | 200537 | 2020-06-02 | Iroquois | Illinois | 17075 | 132 | 4 |
197464 | 197464 | 2020-06-01 | Iroquois | Illinois | 17075 | 132 | 4 |
194394 | 194394 | 2020-05-31 | Iroquois | Illinois | 17075 | 132 | 4 |
145839 | 145839 | 2020-05-15 | McLean | Illinois | 17113 | 132 | 4 |
124901 | 124901 | 2020-05-08 | Peoria | Illinois | 17143 | 132 | 5 |
115942 | 115942 | 2020-05-05 | DeKalb | Illinois | 17037 | 132 | 1 |
113108 | 113108 | 2020-05-04 | Ogle | Illinois | 17141 | 132 | 3 |
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);