ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,502 rows where state = "Illinois" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 17089 788
- 17097 788
- 17111 788
- 17143 788
- 17163 788
- 17167 788
- 17195 788
- 17197 788
- 17201 788
- 17203 788
- 17027 787
- 17031 787
- 17035 787
- 17043 787
- 17077 787
- 17091 787
- 17093 787
- 17099 787
- 17119 787
- 17189 787
- 17199 787
- 17001 785
- 17021 785
- 17113 785
- 17037 784
- 17019 783
- 17085 783
- 17105 783
- 17161 783
- 17177 783
- …
county >30
- Kane 788
- Lake 788
- McHenry 788
- Peoria 788
- Sangamon 788
- St. Clair 788
- Whiteside 788
- Will 788
- Winnebago 788
- Woodford 788
- Clinton 787
- Cook 787
- Cumberland 787
- DuPage 787
- Jackson 787
- Kankakee 787
- Kendall 787
- LaSalle 787
- Madison 787
- Washington 787
- Williamson 787
- Adams 785
- Christian 785
- McLean 785
- DeKalb 784
- Champaign 783
- Jo Daviess 783
- Livingston 783
- Rock Island 783
- Stephenson 783
- …
state 1
- Illinois · 79,402 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3364 | 3364 | 2020-03-17 | Kane | Illinois | 17089 | 3 | 0 |
3365 | 3365 | 2020-03-17 | Lake | Illinois | 17097 | 7 | 0 |
3366 | 3366 | 2020-03-17 | McHenry | Illinois | 17111 | 2 | 0 |
3367 | 3367 | 2020-03-17 | Peoria | Illinois | 17143 | 1 | 0 |
3368 | 3368 | 2020-03-17 | Sangamon | Illinois | 17167 | 3 | 0 |
3369 | 3369 | 2020-03-17 | St. Clair | Illinois | 17163 | 2 | 0 |
3370 | 3370 | 2020-03-17 | Whiteside | Illinois | 17195 | 1 | 0 |
3371 | 3371 | 2020-03-17 | Will | Illinois | 17197 | 2 | 0 |
3372 | 3372 | 2020-03-17 | Winnebago | Illinois | 17201 | 1 | 0 |
3373 | 3373 | 2020-03-17 | Woodford | Illinois | 17203 | 1 | 0 |
3923 | 3923 | 2020-03-18 | Clinton | Illinois | 17027 | 3 | 0 |
3924 | 3924 | 2020-03-18 | Cook | Illinois | 17031 | 179 | 1 |
3925 | 3925 | 2020-03-18 | Cumberland | Illinois | 17035 | 1 | 0 |
3926 | 3926 | 2020-03-18 | DuPage | Illinois | 17043 | 45 | 0 |
3927 | 3927 | 2020-03-18 | Jackson | Illinois | 17077 | 1 | 0 |
3928 | 3928 | 2020-03-18 | Kane | Illinois | 17089 | 4 | 0 |
3929 | 3929 | 2020-03-18 | Kankakee | Illinois | 17091 | 1 | 0 |
3930 | 3930 | 2020-03-18 | Kendall | Illinois | 17093 | 3 | 0 |
3931 | 3931 | 2020-03-18 | LaSalle | Illinois | 17099 | 1 | 0 |
3932 | 3932 | 2020-03-18 | Lake | Illinois | 17097 | 18 | 0 |
3933 | 3933 | 2020-03-18 | Madison | Illinois | 17119 | 1 | 0 |
3934 | 3934 | 2020-03-18 | McHenry | Illinois | 17111 | 4 | 0 |
3935 | 3935 | 2020-03-18 | Peoria | Illinois | 17143 | 3 | 0 |
3936 | 3936 | 2020-03-18 | Sangamon | Illinois | 17167 | 4 | 0 |
3937 | 3937 | 2020-03-18 | St. Clair | Illinois | 17163 | 3 | 0 |
3938 | 3938 | 2020-03-18 | Washington | Illinois | 17189 | 1 | 0 |
3939 | 3939 | 2020-03-18 | Whiteside | Illinois | 17195 | 1 | 0 |
3940 | 3940 | 2020-03-18 | Will | Illinois | 17197 | 9 | 0 |
3941 | 3941 | 2020-03-18 | Williamson | Illinois | 17199 | 1 | 0 |
3942 | 3942 | 2020-03-18 | Winnebago | Illinois | 17201 | 1 | 0 |
3943 | 3943 | 2020-03-18 | Woodford | Illinois | 17203 | 2 | 0 |
4599 | 4599 | 2020-03-19 | Clinton | Illinois | 17027 | 3 | 0 |
4600 | 4600 | 2020-03-19 | Cook | Illinois | 17031 | 279 | 2 |
4601 | 4601 | 2020-03-19 | Cumberland | Illinois | 17035 | 1 | 0 |
4602 | 4602 | 2020-03-19 | DuPage | Illinois | 17043 | 54 | 0 |
4603 | 4603 | 2020-03-19 | Jackson | Illinois | 17077 | 1 | 0 |
4604 | 4604 | 2020-03-19 | Kane | Illinois | 17089 | 6 | 0 |
4605 | 4605 | 2020-03-19 | Kankakee | Illinois | 17091 | 1 | 0 |
4606 | 4606 | 2020-03-19 | Kendall | Illinois | 17093 | 3 | 0 |
4607 | 4607 | 2020-03-19 | LaSalle | Illinois | 17099 | 1 | 0 |
4608 | 4608 | 2020-03-19 | Lake | Illinois | 17097 | 37 | 0 |
4609 | 4609 | 2020-03-19 | Madison | Illinois | 17119 | 1 | 0 |
4610 | 4610 | 2020-03-19 | McHenry | Illinois | 17111 | 6 | 0 |
4611 | 4611 | 2020-03-19 | Peoria | Illinois | 17143 | 3 | 0 |
4612 | 4612 | 2020-03-19 | Sangamon | Illinois | 17167 | 4 | 1 |
4613 | 4613 | 2020-03-19 | St. Clair | Illinois | 17163 | 3 | 0 |
4614 | 4614 | 2020-03-19 | Washington | Illinois | 17189 | 1 | 0 |
4615 | 4615 | 2020-03-19 | Whiteside | Illinois | 17195 | 1 | 0 |
4616 | 4616 | 2020-03-19 | Will | Illinois | 17197 | 11 | 1 |
4617 | 4617 | 2020-03-19 | Williamson | Illinois | 17199 | 1 | 0 |
4618 | 4618 | 2020-03-19 | Winnebago | Illinois | 17201 | 1 | 0 |
4619 | 4619 | 2020-03-19 | Woodford | Illinois | 17203 | 2 | 0 |
5402 | 5402 | 2020-03-20 | Adams | Illinois | 17001 | 1 | 0 |
5403 | 5403 | 2020-03-20 | Christian | Illinois | 17021 | 1 | 0 |
5404 | 5404 | 2020-03-20 | Clinton | Illinois | 17027 | 3 | 0 |
5405 | 5405 | 2020-03-20 | Cook | Illinois | 17031 | 412 | 3 |
5406 | 5406 | 2020-03-20 | Cumberland | Illinois | 17035 | 1 | 0 |
5407 | 5407 | 2020-03-20 | DuPage | Illinois | 17043 | 57 | 0 |
5408 | 5408 | 2020-03-20 | Jackson | Illinois | 17077 | 1 | 0 |
5409 | 5409 | 2020-03-20 | Kane | Illinois | 17089 | 8 | 0 |
5410 | 5410 | 2020-03-20 | Kankakee | Illinois | 17091 | 1 | 0 |
5411 | 5411 | 2020-03-20 | Kendall | Illinois | 17093 | 3 | 0 |
5412 | 5412 | 2020-03-20 | LaSalle | Illinois | 17099 | 1 | 0 |
5413 | 5413 | 2020-03-20 | Lake | Illinois | 17097 | 52 | 0 |
5414 | 5414 | 2020-03-20 | Madison | Illinois | 17119 | 1 | 0 |
5415 | 5415 | 2020-03-20 | McHenry | Illinois | 17111 | 8 | 0 |
5416 | 5416 | 2020-03-20 | McLean | Illinois | 17113 | 4 | 0 |
5417 | 5417 | 2020-03-20 | Peoria | Illinois | 17143 | 3 | 0 |
5418 | 5418 | 2020-03-20 | Sangamon | Illinois | 17167 | 4 | 1 |
5419 | 5419 | 2020-03-20 | St. Clair | Illinois | 17163 | 3 | 0 |
5420 | 5420 | 2020-03-20 | Washington | Illinois | 17189 | 1 | 0 |
5421 | 5421 | 2020-03-20 | Whiteside | Illinois | 17195 | 1 | 0 |
5422 | 5422 | 2020-03-20 | Will | Illinois | 17197 | 12 | 1 |
5423 | 5423 | 2020-03-20 | Williamson | Illinois | 17199 | 1 | 0 |
5424 | 5424 | 2020-03-20 | Winnebago | Illinois | 17201 | 2 | 0 |
5425 | 5425 | 2020-03-20 | Woodford | Illinois | 17203 | 2 | 0 |
6336 | 6336 | 2020-03-21 | Adams | Illinois | 17001 | 1 | 0 |
6337 | 6337 | 2020-03-21 | Christian | Illinois | 17021 | 1 | 0 |
6338 | 6338 | 2020-03-21 | Clinton | Illinois | 17027 | 3 | 0 |
6339 | 6339 | 2020-03-21 | Cook | Illinois | 17031 | 548 | 4 |
6340 | 6340 | 2020-03-21 | Cumberland | Illinois | 17035 | 1 | 0 |
6341 | 6341 | 2020-03-21 | DeKalb | Illinois | 17037 | 1 | 0 |
6342 | 6342 | 2020-03-21 | DuPage | Illinois | 17043 | 68 | 0 |
6343 | 6343 | 2020-03-21 | Jackson | Illinois | 17077 | 1 | 0 |
6344 | 6344 | 2020-03-21 | Kane | Illinois | 17089 | 8 | 0 |
6345 | 6345 | 2020-03-21 | Kankakee | Illinois | 17091 | 2 | 0 |
6346 | 6346 | 2020-03-21 | Kendall | Illinois | 17093 | 3 | 0 |
6347 | 6347 | 2020-03-21 | LaSalle | Illinois | 17099 | 1 | 0 |
6348 | 6348 | 2020-03-21 | Lake | Illinois | 17097 | 63 | 0 |
6349 | 6349 | 2020-03-21 | Madison | Illinois | 17119 | 2 | 0 |
6350 | 6350 | 2020-03-21 | McHenry | Illinois | 17111 | 11 | 0 |
6351 | 6351 | 2020-03-21 | McLean | Illinois | 17113 | 6 | 0 |
6352 | 6352 | 2020-03-21 | Peoria | Illinois | 17143 | 3 | 0 |
6353 | 6353 | 2020-03-21 | Sangamon | Illinois | 17167 | 4 | 1 |
6354 | 6354 | 2020-03-21 | St. Clair | Illinois | 17163 | 3 | 0 |
6355 | 6355 | 2020-03-21 | Washington | Illinois | 17189 | 1 | 0 |
6356 | 6356 | 2020-03-21 | Whiteside | Illinois | 17195 | 1 | 0 |
6357 | 6357 | 2020-03-21 | Will | Illinois | 17197 | 12 | 1 |
6358 | 6358 | 2020-03-21 | Williamson | Illinois | 17199 | 1 | 0 |
6359 | 6359 | 2020-03-21 | Winnebago | Illinois | 17201 | 4 | 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);