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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 17031 841
- 17089 795
- 17111 795
- 17097 794
- 17035 791
- 17043 791
- 17163 791
- 17167 791
- 17203 791
- 17027 790
- 17195 790
- 17201 790
- 17143 789
- 17197 789
- 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
- Cook 841
- Kane 795
- McHenry 795
- Lake 794
- Cumberland 791
- DuPage 791
- Sangamon 791
- St. Clair 791
- Woodford 791
- Clinton 790
- Whiteside 790
- Winnebago 790
- Peoria 789
- Will 789
- 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,502 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4 | 4 | 2020-01-24 | Cook | Illinois | 17031 | 1 | 0 |
7 | 7 | 2020-01-25 | Cook | Illinois | 17031 | 1 | 0 |
12 | 12 | 2020-01-26 | Cook | Illinois | 17031 | 1 | 0 |
17 | 17 | 2020-01-27 | Cook | Illinois | 17031 | 1 | 0 |
22 | 22 | 2020-01-28 | Cook | Illinois | 17031 | 1 | 0 |
27 | 27 | 2020-01-29 | Cook | Illinois | 17031 | 1 | 0 |
32 | 32 | 2020-01-30 | Cook | Illinois | 17031 | 2 | 0 |
38 | 38 | 2020-01-31 | Cook | Illinois | 17031 | 2 | 0 |
44 | 44 | 2020-02-01 | Cook | Illinois | 17031 | 2 | 0 |
52 | 52 | 2020-02-02 | Cook | Illinois | 17031 | 2 | 0 |
60 | 60 | 2020-02-03 | Cook | Illinois | 17031 | 2 | 0 |
68 | 68 | 2020-02-04 | Cook | Illinois | 17031 | 2 | 0 |
76 | 76 | 2020-02-05 | Cook | Illinois | 17031 | 2 | 0 |
85 | 85 | 2020-02-06 | Cook | Illinois | 17031 | 2 | 0 |
94 | 94 | 2020-02-07 | Cook | Illinois | 17031 | 2 | 0 |
103 | 103 | 2020-02-08 | Cook | Illinois | 17031 | 2 | 0 |
112 | 112 | 2020-02-09 | Cook | Illinois | 17031 | 2 | 0 |
122 | 122 | 2020-02-10 | Cook | Illinois | 17031 | 2 | 0 |
132 | 132 | 2020-02-11 | Cook | Illinois | 17031 | 2 | 0 |
142 | 142 | 2020-02-12 | Cook | Illinois | 17031 | 2 | 0 |
153 | 153 | 2020-02-13 | Cook | Illinois | 17031 | 2 | 0 |
164 | 164 | 2020-02-14 | Cook | Illinois | 17031 | 2 | 0 |
175 | 175 | 2020-02-15 | Cook | Illinois | 17031 | 2 | 0 |
186 | 186 | 2020-02-16 | Cook | Illinois | 17031 | 2 | 0 |
197 | 197 | 2020-02-17 | Cook | Illinois | 17031 | 2 | 0 |
209 | 209 | 2020-02-18 | Cook | Illinois | 17031 | 2 | 0 |
221 | 221 | 2020-02-19 | Cook | Illinois | 17031 | 2 | 0 |
234 | 234 | 2020-02-20 | Cook | Illinois | 17031 | 2 | 0 |
248 | 248 | 2020-02-21 | Cook | Illinois | 17031 | 2 | 0 |
262 | 262 | 2020-02-22 | Cook | Illinois | 17031 | 2 | 0 |
276 | 276 | 2020-02-23 | Cook | Illinois | 17031 | 2 | 0 |
291 | 291 | 2020-02-24 | Cook | Illinois | 17031 | 2 | 0 |
307 | 307 | 2020-02-25 | Cook | Illinois | 17031 | 2 | 0 |
327 | 327 | 2020-02-26 | Cook | Illinois | 17031 | 2 | 0 |
347 | 347 | 2020-02-27 | Cook | Illinois | 17031 | 2 | 0 |
367 | 367 | 2020-02-28 | Cook | Illinois | 17031 | 2 | 0 |
389 | 389 | 2020-02-29 | Cook | Illinois | 17031 | 3 | 0 |
414 | 414 | 2020-03-01 | Cook | Illinois | 17031 | 3 | 0 |
444 | 444 | 2020-03-02 | Cook | Illinois | 17031 | 4 | 0 |
478 | 478 | 2020-03-03 | Cook | Illinois | 17031 | 4 | 0 |
513 | 513 | 2020-03-04 | Cook | Illinois | 17031 | 4 | 0 |
555 | 555 | 2020-03-05 | Cook | Illinois | 17031 | 5 | 0 |
613 | 613 | 2020-03-06 | Cook | Illinois | 17031 | 6 | 0 |
697 | 697 | 2020-03-07 | Cook | Illinois | 17031 | 6 | 0 |
794 | 794 | 2020-03-08 | Cook | Illinois | 17031 | 7 | 0 |
914 | 914 | 2020-03-09 | Cook | Illinois | 17031 | 11 | 0 |
1055 | 1055 | 2020-03-10 | Cook | Illinois | 17031 | 17 | 0 |
1056 | 1056 | 2020-03-10 | Kane | Illinois | 17089 | 1 | 0 |
1057 | 1057 | 2020-03-10 | McHenry | Illinois | 17111 | 1 | 0 |
1229 | 1229 | 2020-03-11 | Cook | Illinois | 17031 | 22 | 0 |
1230 | 1230 | 2020-03-11 | Kane | Illinois | 17089 | 1 | 0 |
1231 | 1231 | 2020-03-11 | Lake | Illinois | 17097 | 1 | 0 |
1232 | 1232 | 2020-03-11 | McHenry | Illinois | 17111 | 1 | 0 |
1443 | 1443 | 2020-03-12 | Cook | Illinois | 17031 | 27 | 0 |
1444 | 1444 | 2020-03-12 | Kane | Illinois | 17089 | 2 | 0 |
1445 | 1445 | 2020-03-12 | Lake | Illinois | 17097 | 1 | 0 |
1446 | 1446 | 2020-03-12 | McHenry | Illinois | 17111 | 2 | 0 |
1714 | 1714 | 2020-03-13 | Cook | Illinois | 17031 | 40 | 0 |
1715 | 1715 | 2020-03-13 | Kane | Illinois | 17089 | 2 | 0 |
1716 | 1716 | 2020-03-13 | Lake | Illinois | 17097 | 2 | 0 |
1717 | 1717 | 2020-03-13 | McHenry | Illinois | 17111 | 2 | 0 |
2040 | 2040 | 2020-03-14 | Cook | Illinois | 17031 | 51 | 0 |
2041 | 2041 | 2020-03-14 | Cumberland | Illinois | 17035 | 1 | 0 |
2042 | 2042 | 2020-03-14 | DuPage | Illinois | 17043 | 1 | 0 |
2043 | 2043 | 2020-03-14 | Kane | Illinois | 17089 | 3 | 0 |
2044 | 2044 | 2020-03-14 | Lake | Illinois | 17097 | 3 | 0 |
2045 | 2045 | 2020-03-14 | McHenry | Illinois | 17111 | 2 | 0 |
2046 | 2046 | 2020-03-14 | Sangamon | Illinois | 17167 | 2 | 0 |
2047 | 2047 | 2020-03-14 | St. Clair | Illinois | 17163 | 2 | 0 |
2048 | 2048 | 2020-03-14 | Woodford | Illinois | 17203 | 1 | 0 |
2430 | 2430 | 2020-03-15 | Clinton | Illinois | 17027 | 1 | 0 |
2431 | 2431 | 2020-03-15 | Cook | Illinois | 17031 | 76 | 0 |
2432 | 2432 | 2020-03-15 | Cumberland | Illinois | 17035 | 1 | 0 |
2433 | 2433 | 2020-03-15 | DuPage | Illinois | 17043 | 1 | 0 |
2434 | 2434 | 2020-03-15 | Kane | Illinois | 17089 | 3 | 0 |
2435 | 2435 | 2020-03-15 | Lake | Illinois | 17097 | 3 | 0 |
2436 | 2436 | 2020-03-15 | McHenry | Illinois | 17111 | 2 | 0 |
2437 | 2437 | 2020-03-15 | Sangamon | Illinois | 17167 | 2 | 0 |
2438 | 2438 | 2020-03-15 | St. Clair | Illinois | 17163 | 2 | 0 |
2439 | 2439 | 2020-03-15 | Whiteside | Illinois | 17195 | 1 | 0 |
2440 | 2440 | 2020-03-15 | Winnebago | Illinois | 17201 | 1 | 0 |
2441 | 2441 | 2020-03-15 | Woodford | Illinois | 17203 | 1 | 0 |
2871 | 2871 | 2020-03-16 | Clinton | Illinois | 17027 | 1 | 0 |
2872 | 2872 | 2020-03-16 | Cook | Illinois | 17031 | 76 | 0 |
2873 | 2873 | 2020-03-16 | Cumberland | Illinois | 17035 | 1 | 0 |
2874 | 2874 | 2020-03-16 | DuPage | Illinois | 17043 | 5 | 0 |
2875 | 2875 | 2020-03-16 | Kane | Illinois | 17089 | 3 | 0 |
2876 | 2876 | 2020-03-16 | Lake | Illinois | 17097 | 6 | 0 |
2877 | 2877 | 2020-03-16 | McHenry | Illinois | 17111 | 2 | 0 |
2878 | 2878 | 2020-03-16 | Peoria | Illinois | 17143 | 1 | 0 |
2879 | 2879 | 2020-03-16 | Sangamon | Illinois | 17167 | 3 | 0 |
2880 | 2880 | 2020-03-16 | St. Clair | Illinois | 17163 | 2 | 0 |
2881 | 2881 | 2020-03-16 | Whiteside | Illinois | 17195 | 1 | 0 |
2882 | 2882 | 2020-03-16 | Will | Illinois | 17197 | 1 | 0 |
2883 | 2883 | 2020-03-16 | Winnebago | Illinois | 17201 | 1 | 0 |
2884 | 2884 | 2020-03-16 | Woodford | Illinois | 17203 | 1 | 0 |
3360 | 3360 | 2020-03-17 | Clinton | Illinois | 17027 | 2 | 0 |
3361 | 3361 | 2020-03-17 | Cook | Illinois | 17031 | 107 | 1 |
3362 | 3362 | 2020-03-17 | Cumberland | Illinois | 17035 | 1 | 0 |
3363 | 3363 | 2020-03-17 | DuPage | Illinois | 17043 | 26 | 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);