ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 105 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
784809 | 784809 | 2020-12-01 | Pope | Illinois | 17151 | 105 | 1 |
745821 | 745821 | 2020-11-19 | Hardin | Illinois | 17069 | 105 | 0 |
658207 | 658207 | 2020-10-23 | Brown | Illinois | 17009 | 105 | 0 |
658226 | 658226 | 2020-10-23 | Edwards | Illinois | 17047 | 105 | 0 |
648498 | 648498 | 2020-10-20 | Gallatin | Illinois | 17059 | 105 | 2 |
645253 | 645253 | 2020-10-19 | Gallatin | Illinois | 17059 | 105 | 2 |
638731 | 638731 | 2020-10-17 | Alexander | Illinois | 17003 | 105 | 1 |
635485 | 635485 | 2020-10-16 | Alexander | Illinois | 17003 | 105 | 1 |
632239 | 632239 | 2020-10-15 | Alexander | Illinois | 17003 | 105 | 1 |
577152 | 577152 | 2020-09-28 | Ford | Illinois | 17053 | 105 | 5 |
577184 | 577184 | 2020-09-28 | Marshall | Illinois | 17123 | 105 | 0 |
564177 | 564177 | 2020-09-24 | De Witt | Illinois | 17039 | 105 | 1 |
538279 | 538279 | 2020-09-16 | Edgar | Illinois | 17045 | 105 | 3 |
535043 | 535043 | 2020-09-15 | Edgar | Illinois | 17045 | 105 | 3 |
483301 | 483301 | 2020-08-30 | Greene | Illinois | 17061 | 105 | 1 |
480130 | 480130 | 2020-08-29 | Wabash | Illinois | 17185 | 105 | 1 |
470382 | 470382 | 2020-08-26 | Johnson | Illinois | 17087 | 105 | 0 |
460728 | 460728 | 2020-08-23 | Pulaski | Illinois | 17153 | 105 | 1 |
454208 | 454208 | 2020-08-21 | Clark | Illinois | 17023 | 105 | 2 |
434905 | 434905 | 2020-08-15 | Moultrie | Illinois | 17139 | 105 | 0 |
415535 | 415535 | 2020-08-09 | Jersey | Illinois | 17083 | 105 | 2 |
409107 | 409107 | 2020-08-07 | Livingston | Illinois | 17105 | 105 | 2 |
389833 | 389833 | 2020-08-01 | Saline | Illinois | 17165 | 105 | 1 |
376910 | 376910 | 2020-07-28 | Franklin | Illinois | 17055 | 105 | 0 |
322534 | 322534 | 2020-07-11 | Lee | Illinois | 17103 | 105 | 2 |
319355 | 319355 | 2020-07-10 | Lee | Illinois | 17103 | 105 | 2 |
275117 | 275117 | 2020-06-26 | Jefferson | Illinois | 17081 | 105 | 17 |
271975 | 271975 | 2020-06-25 | Jefferson | Illinois | 17081 | 105 | 17 |
234569 | 234569 | 2020-06-13 | Morgan | Illinois | 17137 | 105 | 2 |
231463 | 231463 | 2020-06-12 | Morgan | Illinois | 17137 | 105 | 2 |
228358 | 228358 | 2020-06-11 | Monroe | Illinois | 17133 | 105 | 12 |
225256 | 225256 | 2020-06-10 | Monroe | Illinois | 17133 | 105 | 12 |
222142 | 222142 | 2020-06-09 | Knox | Illinois | 17095 | 105 | 0 |
222161 | 222161 | 2020-06-09 | Monroe | Illinois | 17133 | 105 | 12 |
219047 | 219047 | 2020-06-08 | Knox | Illinois | 17095 | 105 | 0 |
145867 | 145867 | 2020-05-15 | Warren | Illinois | 17187 | 105 | 0 |
142867 | 142867 | 2020-05-14 | Warren | Illinois | 17187 | 105 | 0 |
139868 | 139868 | 2020-05-13 | Union | Illinois | 17181 | 105 | 1 |
139871 | 139871 | 2020-05-13 | Warren | Illinois | 17187 | 105 | 0 |
133847 | 133847 | 2020-05-11 | LaSalle | Illinois | 17099 | 105 | 5 |
130856 | 130856 | 2020-05-10 | LaSalle | Illinois | 17099 | 105 | 5 |
118969 | 118969 | 2020-05-06 | Unknown | Illinois | 105 | 0 | |
104449 | 104449 | 2020-05-01 | DeKalb | Illinois | 17037 | 105 | 1 |
98775 | 98775 | 2020-04-29 | Macon | Illinois | 17115 | 105 | 11 |
93115 | 93115 | 2020-04-27 | Ogle | Illinois | 17141 | 105 | 1 |
90237 | 90237 | 2020-04-26 | Champaign | Illinois | 17019 | 105 | 5 |
54389 | 54389 | 2020-04-13 | Rock Island | Illinois | 17161 | 105 | 3 |
51676 | 51676 | 2020-04-12 | Kendall | Illinois | 17093 | 105 | 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);