ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
291 rows where cases = 7 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Massac 33
- Piatt 26
- Stark 25
- Saline 24
- Johnson 15
- Schuyler 11
- Lawrence 10
- Logan 10
- Putnam 8
- Effingham 7
- Greene 7
- Hamilton 7
- Washington 7
- Mercer 6
- Pope 6
- Woodford 6
- Boone 4
- Carroll 4
- Henderson 4
- Iroquois 4
- McLean 4
- Bureau 3
- Calhoun 3
- Edgar 3
- Alexander 2
- Fayette 2
- Gallatin 2
- Henry 2
- Marshall 2
- Menard 2
- …
state 1
- Illinois · 291 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
447828 | 447828 | 2020-08-19 | Stark | Illinois | 17175 | 7 | 0 |
444601 | 444601 | 2020-08-18 | Stark | Illinois | 17175 | 7 | 0 |
441375 | 441375 | 2020-08-17 | Stark | Illinois | 17175 | 7 | 0 |
438149 | 438149 | 2020-08-16 | Stark | Illinois | 17175 | 7 | 0 |
434923 | 434923 | 2020-08-15 | Stark | Illinois | 17175 | 7 | 0 |
431698 | 431698 | 2020-08-14 | Stark | Illinois | 17175 | 7 | 0 |
428470 | 428470 | 2020-08-13 | Stark | Illinois | 17175 | 7 | 0 |
425246 | 425246 | 2020-08-12 | Stark | Illinois | 17175 | 7 | 0 |
422025 | 422025 | 2020-08-11 | Stark | Illinois | 17175 | 7 | 0 |
418802 | 418802 | 2020-08-10 | Stark | Illinois | 17175 | 7 | 0 |
415581 | 415581 | 2020-08-09 | Stark | Illinois | 17175 | 7 | 0 |
412361 | 412361 | 2020-08-08 | Stark | Illinois | 17175 | 7 | 0 |
409142 | 409142 | 2020-08-07 | Stark | Illinois | 17175 | 7 | 0 |
405922 | 405922 | 2020-08-06 | Stark | Illinois | 17175 | 7 | 0 |
402704 | 402704 | 2020-08-05 | Stark | Illinois | 17175 | 7 | 0 |
399488 | 399488 | 2020-08-04 | Stark | Illinois | 17175 | 7 | 0 |
396191 | 396191 | 2020-08-03 | Calhoun | Illinois | 17013 | 7 | 0 |
396272 | 396272 | 2020-08-03 | Stark | Illinois | 17175 | 7 | 0 |
392975 | 392975 | 2020-08-02 | Calhoun | Illinois | 17013 | 7 | 0 |
393046 | 393046 | 2020-08-02 | Putnam | Illinois | 17155 | 7 | 0 |
393056 | 393056 | 2020-08-02 | Stark | Illinois | 17175 | 7 | 0 |
389758 | 389758 | 2020-08-01 | Calhoun | Illinois | 17013 | 7 | 0 |
389827 | 389827 | 2020-08-01 | Pope | Illinois | 17151 | 7 | 0 |
389829 | 389829 | 2020-08-01 | Putnam | Illinois | 17155 | 7 | 0 |
389839 | 389839 | 2020-08-01 | Stark | Illinois | 17175 | 7 | 0 |
386610 | 386610 | 2020-07-31 | Pope | Illinois | 17151 | 7 | 0 |
386612 | 386612 | 2020-07-31 | Putnam | Illinois | 17155 | 7 | 0 |
386622 | 386622 | 2020-07-31 | Stark | Illinois | 17175 | 7 | 0 |
383392 | 383392 | 2020-07-30 | Pope | Illinois | 17151 | 7 | 0 |
383394 | 383394 | 2020-07-30 | Putnam | Illinois | 17155 | 7 | 0 |
383401 | 383401 | 2020-07-30 | Scott | Illinois | 17171 | 7 | 0 |
380175 | 380175 | 2020-07-29 | Pope | Illinois | 17151 | 7 | 0 |
380177 | 380177 | 2020-07-29 | Putnam | Illinois | 17155 | 7 | 0 |
380187 | 380187 | 2020-07-29 | Stark | Illinois | 17175 | 7 | 0 |
376906 | 376906 | 2020-07-28 | Edwards | Illinois | 17047 | 7 | 0 |
376958 | 376958 | 2020-07-28 | Pope | Illinois | 17151 | 7 | 0 |
376960 | 376960 | 2020-07-28 | Putnam | Illinois | 17155 | 7 | 0 |
373743 | 373743 | 2020-07-27 | Pope | Illinois | 17151 | 7 | 0 |
370533 | 370533 | 2020-07-26 | Putnam | Illinois | 17155 | 7 | 0 |
367323 | 367323 | 2020-07-25 | Putnam | Illinois | 17155 | 7 | 0 |
357714 | 357714 | 2020-07-22 | Stark | Illinois | 17175 | 7 | 0 |
354459 | 354459 | 2020-07-21 | Hardin | Illinois | 17069 | 7 | 0 |
348110 | 348110 | 2020-07-19 | Stark | Illinois | 17175 | 7 | 0 |
344909 | 344909 | 2020-07-18 | Stark | Illinois | 17175 | 7 | 0 |
335262 | 335262 | 2020-07-15 | Hamilton | Illinois | 17065 | 7 | 0 |
332066 | 332066 | 2020-07-14 | Gallatin | Illinois | 17059 | 7 | 0 |
332069 | 332069 | 2020-07-14 | Hamilton | Illinois | 17065 | 7 | 0 |
328879 | 328879 | 2020-07-13 | Gallatin | Illinois | 17059 | 7 | 0 |
328882 | 328882 | 2020-07-13 | Hamilton | Illinois | 17065 | 7 | 0 |
325696 | 325696 | 2020-07-12 | Hamilton | Illinois | 17065 | 7 | 0 |
325738 | 325738 | 2020-07-12 | Pike | Illinois | 17149 | 7 | 0 |
322515 | 322515 | 2020-07-11 | Hamilton | Illinois | 17065 | 7 | 0 |
319336 | 319336 | 2020-07-10 | Hamilton | Illinois | 17065 | 7 | 0 |
319391 | 319391 | 2020-07-10 | Stark | Illinois | 17175 | 7 | 0 |
316163 | 316163 | 2020-07-09 | Hamilton | Illinois | 17065 | 7 | 0 |
313036 | 313036 | 2020-07-08 | Richland | Illinois | 17159 | 7 | 0 |
309866 | 309866 | 2020-07-07 | Richland | Illinois | 17159 | 7 | 0 |
306669 | 306669 | 2020-07-06 | Lawrence | Illinois | 17101 | 7 | 0 |
303504 | 303504 | 2020-07-05 | Lawrence | Illinois | 17101 | 7 | 0 |
300340 | 300340 | 2020-07-04 | Lawrence | Illinois | 17101 | 7 | 0 |
297178 | 297178 | 2020-07-03 | Lawrence | Illinois | 17101 | 7 | 0 |
294021 | 294021 | 2020-07-02 | Lawrence | Illinois | 17101 | 7 | 0 |
290867 | 290867 | 2020-07-01 | Lawrence | Illinois | 17101 | 7 | 0 |
287717 | 287717 | 2020-06-30 | Lawrence | Illinois | 17101 | 7 | 0 |
284568 | 284568 | 2020-06-29 | Lawrence | Illinois | 17101 | 7 | 0 |
281423 | 281423 | 2020-06-28 | Lawrence | Illinois | 17101 | 7 | 0 |
278275 | 278275 | 2020-06-27 | Lawrence | Illinois | 17101 | 7 | 0 |
275135 | 275135 | 2020-06-26 | Marshall | Illinois | 17123 | 7 | 0 |
271993 | 271993 | 2020-06-25 | Marshall | Illinois | 17123 | 7 | 0 |
268820 | 268820 | 2020-06-24 | Edgar | Illinois | 17045 | 7 | 0 |
265690 | 265690 | 2020-06-23 | Edgar | Illinois | 17045 | 7 | 0 |
265728 | 265728 | 2020-06-23 | Massac | Illinois | 17127 | 7 | 0 |
262562 | 262562 | 2020-06-22 | Edgar | Illinois | 17045 | 7 | 0 |
262600 | 262600 | 2020-06-22 | Massac | Illinois | 17127 | 7 | 0 |
259473 | 259473 | 2020-06-21 | Massac | Illinois | 17127 | 7 | 0 |
256347 | 256347 | 2020-06-20 | Massac | Illinois | 17127 | 7 | 0 |
253227 | 253227 | 2020-06-19 | Massac | Illinois | 17127 | 7 | 0 |
250112 | 250112 | 2020-06-18 | Massac | Illinois | 17127 | 7 | 0 |
247000 | 247000 | 2020-06-17 | Massac | Illinois | 17127 | 7 | 0 |
247021 | 247021 | 2020-06-17 | Saline | Illinois | 17165 | 7 | 0 |
243887 | 243887 | 2020-06-16 | Massac | Illinois | 17127 | 7 | 0 |
243908 | 243908 | 2020-06-16 | Saline | Illinois | 17165 | 7 | 0 |
240746 | 240746 | 2020-06-15 | Greene | Illinois | 17061 | 7 | 0 |
240776 | 240776 | 2020-06-15 | Massac | Illinois | 17127 | 7 | 0 |
240797 | 240797 | 2020-06-15 | Saline | Illinois | 17165 | 7 | 0 |
237638 | 237638 | 2020-06-14 | Greene | Illinois | 17061 | 7 | 0 |
237668 | 237668 | 2020-06-14 | Massac | Illinois | 17127 | 7 | 0 |
237689 | 237689 | 2020-06-14 | Saline | Illinois | 17165 | 7 | 0 |
234531 | 234531 | 2020-06-13 | Greene | Illinois | 17061 | 7 | 0 |
234561 | 234561 | 2020-06-13 | Massac | Illinois | 17127 | 7 | 0 |
234582 | 234582 | 2020-06-13 | Saline | Illinois | 17165 | 7 | 0 |
231425 | 231425 | 2020-06-12 | Greene | Illinois | 17061 | 7 | 0 |
231455 | 231455 | 2020-06-12 | Massac | Illinois | 17127 | 7 | 0 |
231476 | 231476 | 2020-06-12 | Saline | Illinois | 17165 | 7 | 0 |
228322 | 228322 | 2020-06-11 | Greene | Illinois | 17061 | 7 | 0 |
228352 | 228352 | 2020-06-11 | Massac | Illinois | 17127 | 7 | 0 |
228373 | 228373 | 2020-06-11 | Saline | Illinois | 17165 | 7 | 0 |
225220 | 225220 | 2020-06-10 | Greene | Illinois | 17061 | 7 | 0 |
225250 | 225250 | 2020-06-10 | Massac | Illinois | 17127 | 7 | 0 |
225271 | 225271 | 2020-06-10 | Saline | Illinois | 17165 | 7 | 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);