ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
296 rows where cases = 8 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Henderson 70
- Alexander 22
- Greene 12
- Effingham 11
- Franklin 10
- Saline 9
- Clay 8
- Bureau 6
- Jersey 6
- Moultrie 6
- Piatt 6
- Pope 6
- Vermilion 6
- Bond 5
- Ford 5
- Marshall 5
- Clark 4
- Cumberland 4
- Mercer 4
- Stephenson 4
- White 4
- Clinton 3
- Crawford 3
- Hamilton 3
- Lawrence 3
- Montgomery 3
- Peoria 3
- Pike 3
- Union 3
- Washington 3
- …
state 1
- Illinois · 296 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
409130 | 409130 | 2020-08-07 | Pope | Illinois | 17151 | 8 | 0 |
405910 | 405910 | 2020-08-06 | Pope | Illinois | 17151 | 8 | 0 |
402623 | 402623 | 2020-08-05 | Calhoun | Illinois | 17013 | 8 | 0 |
402692 | 402692 | 2020-08-05 | Pope | Illinois | 17151 | 8 | 0 |
399407 | 399407 | 2020-08-04 | Calhoun | Illinois | 17013 | 8 | 0 |
399476 | 399476 | 2020-08-04 | Pope | Illinois | 17151 | 8 | 0 |
396260 | 396260 | 2020-08-03 | Pope | Illinois | 17151 | 8 | 0 |
396262 | 396262 | 2020-08-03 | Putnam | Illinois | 17155 | 8 | 0 |
393044 | 393044 | 2020-08-02 | Pope | Illinois | 17151 | 8 | 0 |
383404 | 383404 | 2020-07-30 | Stark | Illinois | 17175 | 8 | 0 |
373745 | 373745 | 2020-07-27 | Putnam | Illinois | 17155 | 8 | 0 |
364074 | 364074 | 2020-07-24 | Henderson | Illinois | 17071 | 8 | 0 |
360867 | 360867 | 2020-07-23 | Henderson | Illinois | 17071 | 8 | 0 |
357662 | 357662 | 2020-07-22 | Henderson | Illinois | 17071 | 8 | 0 |
354460 | 354460 | 2020-07-21 | Henderson | Illinois | 17071 | 8 | 0 |
351235 | 351235 | 2020-07-20 | Clay | Illinois | 17025 | 8 | 0 |
351258 | 351258 | 2020-07-20 | Henderson | Illinois | 17071 | 8 | 0 |
348035 | 348035 | 2020-07-19 | Clay | Illinois | 17025 | 8 | 0 |
348058 | 348058 | 2020-07-19 | Henderson | Illinois | 17071 | 8 | 0 |
344834 | 344834 | 2020-07-18 | Clay | Illinois | 17025 | 8 | 0 |
344854 | 344854 | 2020-07-18 | Hamilton | Illinois | 17065 | 8 | 0 |
344857 | 344857 | 2020-07-18 | Henderson | Illinois | 17071 | 8 | 0 |
341634 | 341634 | 2020-07-17 | Clay | Illinois | 17025 | 8 | 0 |
341654 | 341654 | 2020-07-17 | Hamilton | Illinois | 17065 | 8 | 0 |
341657 | 341657 | 2020-07-17 | Henderson | Illinois | 17071 | 8 | 0 |
338438 | 338438 | 2020-07-16 | Clay | Illinois | 17025 | 8 | 0 |
338458 | 338458 | 2020-07-16 | Hamilton | Illinois | 17065 | 8 | 0 |
338461 | 338461 | 2020-07-16 | Henderson | Illinois | 17071 | 8 | 0 |
335242 | 335242 | 2020-07-15 | Clay | Illinois | 17025 | 8 | 0 |
335259 | 335259 | 2020-07-15 | Gallatin | Illinois | 17059 | 8 | 0 |
335265 | 335265 | 2020-07-15 | Henderson | Illinois | 17071 | 8 | 0 |
335304 | 335304 | 2020-07-15 | Pike | Illinois | 17149 | 8 | 0 |
332049 | 332049 | 2020-07-14 | Clay | Illinois | 17025 | 8 | 0 |
332072 | 332072 | 2020-07-14 | Henderson | Illinois | 17071 | 8 | 0 |
332111 | 332111 | 2020-07-14 | Pike | Illinois | 17149 | 8 | 0 |
328862 | 328862 | 2020-07-13 | Clay | Illinois | 17025 | 8 | 0 |
328885 | 328885 | 2020-07-13 | Henderson | Illinois | 17071 | 8 | 0 |
328924 | 328924 | 2020-07-13 | Pike | Illinois | 17149 | 8 | 0 |
325699 | 325699 | 2020-07-12 | Henderson | Illinois | 17071 | 8 | 0 |
322513 | 322513 | 2020-07-11 | Greene | Illinois | 17061 | 8 | 0 |
322518 | 322518 | 2020-07-11 | Henderson | Illinois | 17071 | 8 | 0 |
319334 | 319334 | 2020-07-10 | Greene | Illinois | 17061 | 8 | 0 |
319339 | 319339 | 2020-07-10 | Henderson | Illinois | 17071 | 8 | 0 |
319383 | 319383 | 2020-07-10 | Richland | Illinois | 17159 | 8 | 0 |
316161 | 316161 | 2020-07-09 | Greene | Illinois | 17061 | 8 | 0 |
316166 | 316166 | 2020-07-09 | Henderson | Illinois | 17071 | 8 | 0 |
316181 | 316181 | 2020-07-09 | Lawrence | Illinois | 17101 | 8 | 0 |
316210 | 316210 | 2020-07-09 | Richland | Illinois | 17159 | 8 | 0 |
316228 | 316228 | 2020-07-09 | White | Illinois | 17193 | 8 | 0 |
312987 | 312987 | 2020-07-08 | Greene | Illinois | 17061 | 8 | 0 |
312992 | 312992 | 2020-07-08 | Henderson | Illinois | 17071 | 8 | 0 |
313007 | 313007 | 2020-07-08 | Lawrence | Illinois | 17101 | 8 | 0 |
309817 | 309817 | 2020-07-07 | Greene | Illinois | 17061 | 8 | 0 |
309822 | 309822 | 2020-07-07 | Henderson | Illinois | 17071 | 8 | 0 |
309837 | 309837 | 2020-07-07 | Lawrence | Illinois | 17101 | 8 | 0 |
309884 | 309884 | 2020-07-07 | White | Illinois | 17193 | 8 | 0 |
306654 | 306654 | 2020-07-06 | Henderson | Illinois | 17071 | 8 | 0 |
306716 | 306716 | 2020-07-06 | White | Illinois | 17193 | 8 | 0 |
303489 | 303489 | 2020-07-05 | Henderson | Illinois | 17071 | 8 | 0 |
303551 | 303551 | 2020-07-05 | White | Illinois | 17193 | 8 | 0 |
300325 | 300325 | 2020-07-04 | Henderson | Illinois | 17071 | 8 | 0 |
297163 | 297163 | 2020-07-03 | Henderson | Illinois | 17071 | 8 | 0 |
294006 | 294006 | 2020-07-02 | Henderson | Illinois | 17071 | 8 | 0 |
290852 | 290852 | 2020-07-01 | Henderson | Illinois | 17071 | 8 | 0 |
290875 | 290875 | 2020-07-01 | Marshall | Illinois | 17123 | 8 | 0 |
287702 | 287702 | 2020-06-30 | Henderson | Illinois | 17071 | 8 | 0 |
287725 | 287725 | 2020-06-30 | Marshall | Illinois | 17123 | 8 | 0 |
284553 | 284553 | 2020-06-29 | Henderson | Illinois | 17071 | 8 | 0 |
284576 | 284576 | 2020-06-29 | Marshall | Illinois | 17123 | 8 | 0 |
281408 | 281408 | 2020-06-28 | Henderson | Illinois | 17071 | 8 | 0 |
281431 | 281431 | 2020-06-28 | Marshall | Illinois | 17123 | 8 | 0 |
278260 | 278260 | 2020-06-27 | Henderson | Illinois | 17071 | 8 | 0 |
278283 | 278283 | 2020-06-27 | Marshall | Illinois | 17123 | 8 | 0 |
275099 | 275099 | 2020-06-26 | Edgar | Illinois | 17045 | 8 | 0 |
275112 | 275112 | 2020-06-26 | Henderson | Illinois | 17071 | 8 | 0 |
275158 | 275158 | 2020-06-26 | Saline | Illinois | 17165 | 8 | 0 |
271957 | 271957 | 2020-06-25 | Edgar | Illinois | 17045 | 8 | 0 |
271970 | 271970 | 2020-06-25 | Henderson | Illinois | 17071 | 8 | 0 |
271995 | 271995 | 2020-06-25 | Massac | Illinois | 17127 | 8 | 0 |
272016 | 272016 | 2020-06-25 | Saline | Illinois | 17165 | 8 | 0 |
268833 | 268833 | 2020-06-24 | Henderson | Illinois | 17071 | 8 | 0 |
268858 | 268858 | 2020-06-24 | Massac | Illinois | 17127 | 8 | 0 |
268879 | 268879 | 2020-06-24 | Saline | Illinois | 17165 | 8 | 0 |
265703 | 265703 | 2020-06-23 | Henderson | Illinois | 17071 | 8 | 0 |
265749 | 265749 | 2020-06-23 | Saline | Illinois | 17165 | 8 | 0 |
262570 | 262570 | 2020-06-22 | Greene | Illinois | 17061 | 8 | 0 |
262575 | 262575 | 2020-06-22 | Henderson | Illinois | 17071 | 8 | 0 |
262621 | 262621 | 2020-06-22 | Saline | Illinois | 17165 | 8 | 0 |
259443 | 259443 | 2020-06-21 | Greene | Illinois | 17061 | 8 | 0 |
259448 | 259448 | 2020-06-21 | Henderson | Illinois | 17071 | 8 | 0 |
259494 | 259494 | 2020-06-21 | Saline | Illinois | 17165 | 8 | 0 |
256317 | 256317 | 2020-06-20 | Greene | Illinois | 17061 | 8 | 0 |
256322 | 256322 | 2020-06-20 | Henderson | Illinois | 17071 | 8 | 0 |
256368 | 256368 | 2020-06-20 | Saline | Illinois | 17165 | 8 | 0 |
253197 | 253197 | 2020-06-19 | Greene | Illinois | 17061 | 8 | 0 |
253202 | 253202 | 2020-06-19 | Henderson | Illinois | 17071 | 8 | 0 |
253248 | 253248 | 2020-06-19 | Saline | Illinois | 17165 | 8 | 0 |
250082 | 250082 | 2020-06-18 | Greene | Illinois | 17061 | 8 | 0 |
250087 | 250087 | 2020-06-18 | Henderson | Illinois | 17071 | 8 | 0 |
250133 | 250133 | 2020-06-18 | Saline | Illinois | 17165 | 8 | 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);