ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 55 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Marion 13
- Stark 5
- Williamson 4
- Christian 3
- Edwards 3
- Jasper 3
- Livingston 3
- Champaign 2
- DeKalb 2
- Douglas 2
- Jo Daviess 2
- Macon 2
- Putnam 2
- Adams 1
- Cumberland 1
- Fayette 1
- Grundy 1
- Hardin 1
- Henry 1
- Johnson 1
- Kendall 1
- Lawrence 1
- Logan 1
- Macoupin 1
- Monroe 1
- Morgan 1
- Moultrie 1
- Pulaski 1
- St. Clair 1
- Wayne 1
- …
state 1
- Illinois · 64 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
671213 | 671213 | 2020-10-27 | Hardin | Illinois | 17069 | 55 | 0 |
580454 | 580454 | 2020-09-29 | Stark | Illinois | 17175 | 55 | 2 |
577213 | 577213 | 2020-09-28 | Stark | Illinois | 17175 | 55 | 2 |
573971 | 573971 | 2020-09-27 | Stark | Illinois | 17175 | 55 | 2 |
570728 | 570728 | 2020-09-26 | Stark | Illinois | 17175 | 55 | 2 |
567486 | 567486 | 2020-09-25 | Stark | Illinois | 17175 | 55 | 2 |
564236 | 564236 | 2020-09-24 | Putnam | Illinois | 17155 | 55 | 0 |
560996 | 560996 | 2020-09-23 | Putnam | Illinois | 17155 | 55 | 0 |
535044 | 535044 | 2020-09-15 | Edwards | Illinois | 17047 | 55 | 0 |
531809 | 531809 | 2020-09-14 | Edwards | Illinois | 17047 | 55 | 0 |
528572 | 528572 | 2020-09-13 | Edwards | Illinois | 17047 | 55 | 0 |
431661 | 431661 | 2020-08-14 | Lawrence | Illinois | 17101 | 55 | 0 |
415511 | 415511 | 2020-08-09 | Cumberland | Illinois | 17035 | 55 | 2 |
405874 | 405874 | 2020-08-06 | Jasper | Illinois | 17079 | 55 | 7 |
405931 | 405931 | 2020-08-06 | Wayne | Illinois | 17191 | 55 | 1 |
402656 | 402656 | 2020-08-05 | Jasper | Illinois | 17079 | 55 | 7 |
399440 | 399440 | 2020-08-04 | Jasper | Illinois | 17079 | 55 | 7 |
396254 | 396254 | 2020-08-03 | Moultrie | Illinois | 17139 | 55 | 0 |
392994 | 392994 | 2020-08-02 | Fayette | Illinois | 17051 | 55 | 3 |
389795 | 389795 | 2020-08-01 | Johnson | Illinois | 17087 | 55 | 0 |
383414 | 383414 | 2020-07-30 | White | Illinois | 17193 | 55 | 0 |
354478 | 354478 | 2020-07-21 | Logan | Illinois | 17107 | 55 | 0 |
351233 | 351233 | 2020-07-20 | Christian | Illinois | 17021 | 55 | 5 |
348033 | 348033 | 2020-07-19 | Christian | Illinois | 17021 | 55 | 5 |
344832 | 344832 | 2020-07-18 | Christian | Illinois | 17021 | 55 | 5 |
332079 | 332079 | 2020-07-14 | Jo Daviess | Illinois | 17085 | 55 | 1 |
332089 | 332089 | 2020-07-14 | Livingston | Illinois | 17105 | 55 | 2 |
328902 | 328902 | 2020-07-13 | Livingston | Illinois | 17105 | 55 | 2 |
325706 | 325706 | 2020-07-12 | Jo Daviess | Illinois | 17085 | 55 | 1 |
325716 | 325716 | 2020-07-12 | Livingston | Illinois | 17105 | 55 | 2 |
319324 | 319324 | 2020-07-10 | Douglas | Illinois | 17041 | 55 | 0 |
316151 | 316151 | 2020-07-09 | Douglas | Illinois | 17041 | 55 | 0 |
300345 | 300345 | 2020-07-04 | Macoupin | Illinois | 17117 | 55 | 3 |
259413 | 259413 | 2020-06-21 | Adams | Illinois | 17001 | 55 | 1 |
250109 | 250109 | 2020-06-18 | Marion | Illinois | 17121 | 55 | 0 |
246997 | 246997 | 2020-06-17 | Marion | Illinois | 17121 | 55 | 0 |
243884 | 243884 | 2020-06-16 | Marion | Illinois | 17121 | 55 | 0 |
240773 | 240773 | 2020-06-15 | Marion | Illinois | 17121 | 55 | 0 |
237665 | 237665 | 2020-06-14 | Marion | Illinois | 17121 | 55 | 0 |
234558 | 234558 | 2020-06-13 | Marion | Illinois | 17121 | 55 | 0 |
231452 | 231452 | 2020-06-12 | Marion | Illinois | 17121 | 55 | 0 |
228349 | 228349 | 2020-06-11 | Marion | Illinois | 17121 | 55 | 0 |
225247 | 225247 | 2020-06-10 | Marion | Illinois | 17121 | 55 | 0 |
222152 | 222152 | 2020-06-09 | Marion | Illinois | 17121 | 55 | 0 |
222163 | 222163 | 2020-06-09 | Morgan | Illinois | 17137 | 55 | 1 |
219057 | 219057 | 2020-06-08 | Marion | Illinois | 17121 | 55 | 0 |
215966 | 215966 | 2020-06-07 | Marion | Illinois | 17121 | 55 | 0 |
212879 | 212879 | 2020-06-06 | Marion | Illinois | 17121 | 55 | 0 |
200576 | 200576 | 2020-06-02 | Pulaski | Illinois | 17153 | 55 | 0 |
176123 | 176123 | 2020-05-25 | Williamson | Illinois | 17199 | 55 | 1 |
173079 | 173079 | 2020-05-24 | Williamson | Illinois | 17199 | 55 | 1 |
163968 | 163968 | 2020-05-21 | Williamson | Illinois | 17199 | 55 | 1 |
160940 | 160940 | 2020-05-20 | Williamson | Illinois | 17199 | 55 | 1 |
124861 | 124861 | 2020-05-08 | Grundy | Illinois | 17063 | 55 | 1 |
121887 | 121887 | 2020-05-07 | Henry | Illinois | 17073 | 55 | 0 |
76289 | 76289 | 2020-04-21 | Monroe | Illinois | 17133 | 55 | 7 |
73468 | 73468 | 2020-04-20 | DeKalb | Illinois | 17037 | 55 | 1 |
73500 | 73500 | 2020-04-20 | Macon | Illinois | 17115 | 55 | 9 |
70698 | 70698 | 2020-04-19 | DeKalb | Illinois | 17037 | 55 | 1 |
67968 | 67968 | 2020-04-18 | Macon | Illinois | 17115 | 55 | 7 |
36165 | 36165 | 2020-04-06 | Kendall | Illinois | 17093 | 55 | 2 |
33688 | 33688 | 2020-04-05 | Champaign | Illinois | 17019 | 55 | 0 |
31279 | 31279 | 2020-04-04 | Champaign | Illinois | 17019 | 55 | 0 |
26657 | 26657 | 2020-04-02 | St. Clair | Illinois | 17163 | 55 | 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);