ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
940 rows where cases = 1 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Calhoun 99
- Hardin 83
- Pike 69
- Pope 68
- Putnam 61
- Wabash 43
- Stark 40
- Cumberland 26
- Schuyler 25
- Marshall 20
- Washington 19
- Scott 18
- Edgar 17
- Williamson 16
- Fulton 13
- Knox 13
- Whiteside 12
- Greene 11
- Perry 11
- Franklin 10
- Jackson 10
- Jo Daviess 10
- Richland 10
- Adams 9
- Christian 9
- Gallatin 9
- Clay 8
- Menard 8
- Saline 8
- White 8
- …
state 1
- Illinois · 940 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
351307 | 351307 | 2020-07-20 | Scott | Illinois | 17171 | 1 | 0 |
348107 | 348107 | 2020-07-19 | Scott | Illinois | 17171 | 1 | 0 |
344906 | 344906 | 2020-07-18 | Scott | Illinois | 17171 | 1 | 0 |
341699 | 341699 | 2020-07-17 | Putnam | Illinois | 17155 | 1 | 0 |
341706 | 341706 | 2020-07-17 | Scott | Illinois | 17171 | 1 | 0 |
338503 | 338503 | 2020-07-16 | Putnam | Illinois | 17155 | 1 | 0 |
338510 | 338510 | 2020-07-16 | Scott | Illinois | 17171 | 1 | 0 |
335307 | 335307 | 2020-07-15 | Putnam | Illinois | 17155 | 1 | 0 |
335314 | 335314 | 2020-07-15 | Scott | Illinois | 17171 | 1 | 0 |
332071 | 332071 | 2020-07-14 | Hardin | Illinois | 17069 | 1 | 0 |
332112 | 332112 | 2020-07-14 | Pope | Illinois | 17151 | 1 | 0 |
332114 | 332114 | 2020-07-14 | Putnam | Illinois | 17155 | 1 | 0 |
332121 | 332121 | 2020-07-14 | Scott | Illinois | 17171 | 1 | 0 |
328884 | 328884 | 2020-07-13 | Hardin | Illinois | 17069 | 1 | 0 |
328925 | 328925 | 2020-07-13 | Pope | Illinois | 17151 | 1 | 0 |
328927 | 328927 | 2020-07-13 | Putnam | Illinois | 17155 | 1 | 0 |
328934 | 328934 | 2020-07-13 | Scott | Illinois | 17171 | 1 | 0 |
325670 | 325670 | 2020-07-12 | Calhoun | Illinois | 17013 | 1 | 0 |
325698 | 325698 | 2020-07-12 | Hardin | Illinois | 17069 | 1 | 0 |
325739 | 325739 | 2020-07-12 | Pope | Illinois | 17151 | 1 | 0 |
325741 | 325741 | 2020-07-12 | Putnam | Illinois | 17155 | 1 | 0 |
325748 | 325748 | 2020-07-12 | Scott | Illinois | 17171 | 1 | 0 |
322489 | 322489 | 2020-07-11 | Calhoun | Illinois | 17013 | 1 | 0 |
322558 | 322558 | 2020-07-11 | Pope | Illinois | 17151 | 1 | 0 |
322560 | 322560 | 2020-07-11 | Putnam | Illinois | 17155 | 1 | 0 |
322567 | 322567 | 2020-07-11 | Scott | Illinois | 17171 | 1 | 0 |
319310 | 319310 | 2020-07-10 | Calhoun | Illinois | 17013 | 1 | 0 |
319379 | 319379 | 2020-07-10 | Pope | Illinois | 17151 | 1 | 0 |
319381 | 319381 | 2020-07-10 | Putnam | Illinois | 17155 | 1 | 0 |
319388 | 319388 | 2020-07-10 | Scott | Illinois | 17171 | 1 | 0 |
316137 | 316137 | 2020-07-09 | Calhoun | Illinois | 17013 | 1 | 0 |
316165 | 316165 | 2020-07-09 | Hardin | Illinois | 17069 | 1 | 0 |
316206 | 316206 | 2020-07-09 | Pope | Illinois | 17151 | 1 | 0 |
316208 | 316208 | 2020-07-09 | Putnam | Illinois | 17155 | 1 | 0 |
316215 | 316215 | 2020-07-09 | Scott | Illinois | 17171 | 1 | 0 |
312963 | 312963 | 2020-07-08 | Calhoun | Illinois | 17013 | 1 | 0 |
312991 | 312991 | 2020-07-08 | Hardin | Illinois | 17069 | 1 | 0 |
313032 | 313032 | 2020-07-08 | Pope | Illinois | 17151 | 1 | 0 |
313034 | 313034 | 2020-07-08 | Putnam | Illinois | 17155 | 1 | 0 |
313041 | 313041 | 2020-07-08 | Scott | Illinois | 17171 | 1 | 0 |
309793 | 309793 | 2020-07-07 | Calhoun | Illinois | 17013 | 1 | 0 |
309821 | 309821 | 2020-07-07 | Hardin | Illinois | 17069 | 1 | 0 |
309862 | 309862 | 2020-07-07 | Pope | Illinois | 17151 | 1 | 0 |
309864 | 309864 | 2020-07-07 | Putnam | Illinois | 17155 | 1 | 0 |
309871 | 309871 | 2020-07-07 | Scott | Illinois | 17171 | 1 | 0 |
306625 | 306625 | 2020-07-06 | Calhoun | Illinois | 17013 | 1 | 0 |
306653 | 306653 | 2020-07-06 | Hardin | Illinois | 17069 | 1 | 0 |
306694 | 306694 | 2020-07-06 | Pope | Illinois | 17151 | 1 | 0 |
306696 | 306696 | 2020-07-06 | Putnam | Illinois | 17155 | 1 | 0 |
306703 | 306703 | 2020-07-06 | Scott | Illinois | 17171 | 1 | 0 |
303460 | 303460 | 2020-07-05 | Calhoun | Illinois | 17013 | 1 | 0 |
303488 | 303488 | 2020-07-05 | Hardin | Illinois | 17069 | 1 | 0 |
303529 | 303529 | 2020-07-05 | Pope | Illinois | 17151 | 1 | 0 |
303531 | 303531 | 2020-07-05 | Putnam | Illinois | 17155 | 1 | 0 |
303538 | 303538 | 2020-07-05 | Scott | Illinois | 17171 | 1 | 0 |
300296 | 300296 | 2020-07-04 | Calhoun | Illinois | 17013 | 1 | 0 |
300324 | 300324 | 2020-07-04 | Hardin | Illinois | 17069 | 1 | 0 |
300365 | 300365 | 2020-07-04 | Pope | Illinois | 17151 | 1 | 0 |
300367 | 300367 | 2020-07-04 | Putnam | Illinois | 17155 | 1 | 0 |
300374 | 300374 | 2020-07-04 | Scott | Illinois | 17171 | 1 | 0 |
297134 | 297134 | 2020-07-03 | Calhoun | Illinois | 17013 | 1 | 0 |
297162 | 297162 | 2020-07-03 | Hardin | Illinois | 17069 | 1 | 0 |
297203 | 297203 | 2020-07-03 | Pope | Illinois | 17151 | 1 | 0 |
297205 | 297205 | 2020-07-03 | Putnam | Illinois | 17155 | 1 | 0 |
297212 | 297212 | 2020-07-03 | Scott | Illinois | 17171 | 1 | 0 |
293977 | 293977 | 2020-07-02 | Calhoun | Illinois | 17013 | 1 | 0 |
294005 | 294005 | 2020-07-02 | Hardin | Illinois | 17069 | 1 | 0 |
294046 | 294046 | 2020-07-02 | Pope | Illinois | 17151 | 1 | 0 |
294048 | 294048 | 2020-07-02 | Putnam | Illinois | 17155 | 1 | 0 |
290823 | 290823 | 2020-07-01 | Calhoun | Illinois | 17013 | 1 | 0 |
290851 | 290851 | 2020-07-01 | Hardin | Illinois | 17069 | 1 | 0 |
290892 | 290892 | 2020-07-01 | Pope | Illinois | 17151 | 1 | 0 |
290894 | 290894 | 2020-07-01 | Putnam | Illinois | 17155 | 1 | 0 |
287673 | 287673 | 2020-06-30 | Calhoun | Illinois | 17013 | 1 | 0 |
287701 | 287701 | 2020-06-30 | Hardin | Illinois | 17069 | 1 | 0 |
287742 | 287742 | 2020-06-30 | Pope | Illinois | 17151 | 1 | 0 |
287744 | 287744 | 2020-06-30 | Putnam | Illinois | 17155 | 1 | 0 |
284524 | 284524 | 2020-06-29 | Calhoun | Illinois | 17013 | 1 | 0 |
284552 | 284552 | 2020-06-29 | Hardin | Illinois | 17069 | 1 | 0 |
284593 | 284593 | 2020-06-29 | Pope | Illinois | 17151 | 1 | 0 |
284595 | 284595 | 2020-06-29 | Putnam | Illinois | 17155 | 1 | 0 |
281379 | 281379 | 2020-06-28 | Calhoun | Illinois | 17013 | 1 | 0 |
281407 | 281407 | 2020-06-28 | Hardin | Illinois | 17069 | 1 | 0 |
281448 | 281448 | 2020-06-28 | Pope | Illinois | 17151 | 1 | 0 |
281450 | 281450 | 2020-06-28 | Putnam | Illinois | 17155 | 1 | 0 |
278231 | 278231 | 2020-06-27 | Calhoun | Illinois | 17013 | 1 | 0 |
278259 | 278259 | 2020-06-27 | Hardin | Illinois | 17069 | 1 | 0 |
278300 | 278300 | 2020-06-27 | Pope | Illinois | 17151 | 1 | 0 |
278302 | 278302 | 2020-06-27 | Putnam | Illinois | 17155 | 1 | 0 |
275083 | 275083 | 2020-06-26 | Calhoun | Illinois | 17013 | 1 | 0 |
275111 | 275111 | 2020-06-26 | Hardin | Illinois | 17069 | 1 | 0 |
275152 | 275152 | 2020-06-26 | Pope | Illinois | 17151 | 1 | 0 |
275154 | 275154 | 2020-06-26 | Putnam | Illinois | 17155 | 1 | 0 |
271941 | 271941 | 2020-06-25 | Calhoun | Illinois | 17013 | 1 | 0 |
271969 | 271969 | 2020-06-25 | Hardin | Illinois | 17069 | 1 | 0 |
272010 | 272010 | 2020-06-25 | Pope | Illinois | 17151 | 1 | 0 |
272012 | 272012 | 2020-06-25 | Putnam | Illinois | 17155 | 1 | 0 |
268804 | 268804 | 2020-06-24 | Calhoun | Illinois | 17013 | 1 | 0 |
268832 | 268832 | 2020-06-24 | Hardin | Illinois | 17069 | 1 | 0 |
268873 | 268873 | 2020-06-24 | Pope | Illinois | 17151 | 1 | 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);