ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29,869 rows where state = "Illinois" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 17031 359
- 17089 313
- 17111 313
- 17097 312
- 17035 309
- 17043 309
- 17163 309
- 17167 309
- 17203 309
- 17027 308
- 17195 308
- 17201 308
- 17143 307
- 17197 307
- 17077 305
- 17091 305
- 17093 305
- 17099 305
- 17119 305
- 17189 305
- 17199 305
- 17001 303
- 17021 303
- 17113 303
- 17037 302
- 17019 301
- 17085 301
- 17105 301
- 17161 301
- 17177 301
- ...
county
- Cook 359
- Kane 313
- McHenry 313
- Lake 312
- Cumberland 309
- DuPage 309
- Sangamon 309
- St. Clair 309
- Woodford 309
- Clinton 308
- Whiteside 308
- Winnebago 308
- Peoria 307
- Will 307
- Jackson 305
- Kankakee 305
- Kendall 305
- LaSalle 305
- Madison 305
- Washington 305
- Williamson 305
- Adams 303
- Christian 303
- McLean 303
- DeKalb 302
- Champaign 301
- Jo Daviess 301
- Livingston 301
- Rock Island 301
- Stephenson 301
- ...
state
- Illinois · 29,869 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934099 | 934099 | 2021-01-16 | Adams | Illinois | 17001 | 7329 | 117 |
934100 | 934100 | 2021-01-16 | Alexander | Illinois | 17003 | 384 | 7 |
934101 | 934101 | 2021-01-16 | Bond | Illinois | 17005 | 1726 | 24 |
934102 | 934102 | 2021-01-16 | Boone | Illinois | 17007 | 5513 | 77 |
934103 | 934103 | 2021-01-16 | Brown | Illinois | 17009 | 606 | 11 |
934104 | 934104 | 2021-01-16 | Bureau | Illinois | 17011 | 2993 | 84 |
934105 | 934105 | 2021-01-16 | Calhoun | Illinois | 17013 | 437 | 4 |
934106 | 934106 | 2021-01-16 | Carroll | Illinois | 17015 | 1422 | 33 |
934107 | 934107 | 2021-01-16 | Cass | Illinois | 17017 | 1741 | 31 |
934108 | 934108 | 2021-01-16 | Champaign | Illinois | 17019 | 15288 | 96 |
934109 | 934109 | 2021-01-16 | Christian | Illinois | 17021 | 2964 | 74 |
934110 | 934110 | 2021-01-16 | Clark | Illinois | 17023 | 1459 | 29 |
934111 | 934111 | 2021-01-16 | Clay | Illinois | 17025 | 1304 | 39 |
934112 | 934112 | 2021-01-16 | Clinton | Illinois | 17027 | 4979 | 85 |
934113 | 934113 | 2021-01-16 | Coles | Illinois | 17029 | 4684 | 80 |
934114 | 934114 | 2021-01-16 | Cook | Illinois | 17031 | 431385 | 8980 |
934115 | 934115 | 2021-01-16 | Crawford | Illinois | 17033 | 1749 | 34 |
934116 | 934116 | 2021-01-16 | Cumberland | Illinois | 17035 | 1070 | 27 |
934117 | 934117 | 2021-01-16 | De Witt | Illinois | 17039 | 1130 | 27 |
934118 | 934118 | 2021-01-16 | DeKalb | Illinois | 17037 | 7469 | 92 |
934119 | 934119 | 2021-01-16 | Douglas | Illinois | 17041 | 1986 | 33 |
934120 | 934120 | 2021-01-16 | DuPage | Illinois | 17043 | 68534 | 1144 |
934121 | 934121 | 2021-01-16 | Edgar | Illinois | 17045 | 1428 | 53 |
934122 | 934122 | 2021-01-16 | Edwards | Illinois | 17047 | 461 | 9 |
934123 | 934123 | 2021-01-16 | Effingham | Illinois | 17049 | 4285 | 68 |
934124 | 934124 | 2021-01-16 | Fayette | Illinois | 17051 | 2892 | 53 |
934125 | 934125 | 2021-01-16 | Ford | Illinois | 17053 | 1380 | 49 |
934126 | 934126 | 2021-01-16 | Franklin | Illinois | 17055 | 3803 | 68 |
934127 | 934127 | 2021-01-16 | Fulton | Illinois | 17057 | 2536 | 49 |
934128 | 934128 | 2021-01-16 | Gallatin | Illinois | 17059 | 383 | 4 |
934129 | 934129 | 2021-01-16 | Greene | Illinois | 17061 | 1252 | 42 |
934130 | 934130 | 2021-01-16 | Grundy | Illinois | 17063 | 4318 | 54 |
934131 | 934131 | 2021-01-16 | Hamilton | Illinois | 17065 | 711 | 16 |
934132 | 934132 | 2021-01-16 | Hancock | Illinois | 17067 | 1467 | 33 |
934133 | 934133 | 2021-01-16 | Hardin | Illinois | 17069 | 300 | 8 |
934134 | 934134 | 2021-01-16 | Henderson | Illinois | 17071 | 448 | 16 |
934135 | 934135 | 2021-01-16 | Henry | Illinois | 17073 | 3990 | 76 |
934136 | 934136 | 2021-01-16 | Iroquois | Illinois | 17075 | 2569 | 56 |
934137 | 934137 | 2021-01-16 | Jackson | Illinois | 17077 | 4132 | 67 |
934138 | 934138 | 2021-01-16 | Jasper | Illinois | 17079 | 1030 | 16 |
934139 | 934139 | 2021-01-16 | Jefferson | Illinois | 17081 | 3392 | 104 |
934140 | 934140 | 2021-01-16 | Jersey | Illinois | 17083 | 2184 | 56 |
934141 | 934141 | 2021-01-16 | Jo Daviess | Illinois | 17085 | 1478 | 24 |
934142 | 934142 | 2021-01-16 | Johnson | Illinois | 17087 | 1210 | 15 |
934143 | 934143 | 2021-01-16 | Kane | Illinois | 17089 | 45493 | 675 |
934144 | 934144 | 2021-01-16 | Kankakee | Illinois | 17091 | 11401 | 179 |
934145 | 934145 | 2021-01-16 | Kendall | Illinois | 17093 | 9681 | 78 |
934146 | 934146 | 2021-01-16 | Knox | Illinois | 17095 | 4553 | 140 |
934147 | 934147 | 2021-01-16 | LaSalle | Illinois | 17099 | 9328 | 247 |
934148 | 934148 | 2021-01-16 | Lake | Illinois | 17097 | 52834 | 884 |
934149 | 934149 | 2021-01-16 | Lawrence | Illinois | 17101 | 2167 | 30 |
934150 | 934150 | 2021-01-16 | Lee | Illinois | 17103 | 3018 | 72 |
934151 | 934151 | 2021-01-16 | Livingston | Illinois | 17105 | 3608 | 66 |
934152 | 934152 | 2021-01-16 | Logan | Illinois | 17107 | 3060 | 56 |
934153 | 934153 | 2021-01-16 | Macon | Illinois | 17115 | 8739 | 179 |
934154 | 934154 | 2021-01-16 | Macoupin | Illinois | 17117 | 3795 | 94 |
934155 | 934155 | 2021-01-16 | Madison | Illinois | 17119 | 23998 | 461 |
934156 | 934156 | 2021-01-16 | Marion | Illinois | 17121 | 3938 | 111 |
934157 | 934157 | 2021-01-16 | Marshall | Illinois | 17123 | 657 | 13 |
934158 | 934158 | 2021-01-16 | Mason | Illinois | 17125 | 1159 | 40 |
934159 | 934159 | 2021-01-16 | Massac | Illinois | 17127 | 1013 | 30 |
934160 | 934160 | 2021-01-16 | McDonough | Illinois | 17109 | 2117 | 51 |
934161 | 934161 | 2021-01-16 | McHenry | Illinois | 17111 | 21395 | 248 |
934162 | 934162 | 2021-01-16 | McLean | Illinois | 17113 | 13093 | 159 |
934163 | 934163 | 2021-01-16 | Menard | Illinois | 17129 | 864 | 10 |
934164 | 934164 | 2021-01-16 | Mercer | Illinois | 17131 | 1167 | 29 |
934165 | 934165 | 2021-01-16 | Monroe | Illinois | 17133 | 3533 | 70 |
934166 | 934166 | 2021-01-16 | Montgomery | Illinois | 17135 | 3006 | 40 |
934167 | 934167 | 2021-01-16 | Morgan | Illinois | 17137 | 3306 | 90 |
934168 | 934168 | 2021-01-16 | Moultrie | Illinois | 17139 | 1361 | 28 |
934169 | 934169 | 2021-01-16 | Ogle | Illinois | 17141 | 4571 | 71 |
934170 | 934170 | 2021-01-16 | Peoria | Illinois | 17143 | 14860 | 238 |
934171 | 934171 | 2021-01-16 | Perry | Illinois | 17145 | 2612 | 60 |
934172 | 934172 | 2021-01-16 | Piatt | Illinois | 17147 | 1162 | 16 |
934173 | 934173 | 2021-01-16 | Pike | Illinois | 17149 | 1538 | 46 |
934174 | 934174 | 2021-01-16 | Pope | Illinois | 17151 | 243 | 2 |
934175 | 934175 | 2021-01-16 | Pulaski | Illinois | 17153 | 609 | 3 |
934176 | 934176 | 2021-01-16 | Putnam | Illinois | 17155 | 344 | 2 |
934177 | 934177 | 2021-01-16 | Randolph | Illinois | 17157 | 3693 | 67 |
934178 | 934178 | 2021-01-16 | Richland | Illinois | 17159 | 1522 | 44 |
934179 | 934179 | 2021-01-16 | Rock Island | Illinois | 17161 | 11805 | 302 |
934180 | 934180 | 2021-01-16 | Saline | Illinois | 17165 | 2005 | 53 |
934181 | 934181 | 2021-01-16 | Sangamon | Illinois | 17167 | 14406 | 234 |
934182 | 934182 | 2021-01-16 | Schuyler | Illinois | 17169 | 615 | 16 |
934183 | 934183 | 2021-01-16 | Scott | Illinois | 17171 | 373 | 1 |
934184 | 934184 | 2021-01-16 | Shelby | Illinois | 17173 | 1957 | 35 |
934185 | 934185 | 2021-01-16 | St. Clair | Illinois | 17163 | 24172 | 424 |
934186 | 934186 | 2021-01-16 | Stark | Illinois | 17175 | 493 | 20 |
934187 | 934187 | 2021-01-16 | Stephenson | Illinois | 17177 | 3495 | 74 |
934188 | 934188 | 2021-01-16 | Tazewell | Illinois | 17179 | 11825 | 242 |
934189 | 934189 | 2021-01-16 | Union | Illinois | 17181 | 1968 | 32 |
934190 | 934190 | 2021-01-16 | Vermilion | Illinois | 17183 | 7404 | 112 |
934191 | 934191 | 2021-01-16 | Wabash | Illinois | 17185 | 1163 | 14 |
934192 | 934192 | 2021-01-16 | Warren | Illinois | 17187 | 1577 | 43 |
934193 | 934193 | 2021-01-16 | Washington | Illinois | 17189 | 1440 | 25 |
934194 | 934194 | 2021-01-16 | Wayne | Illinois | 17191 | 1501 | 43 |
934195 | 934195 | 2021-01-16 | White | Illinois | 17193 | 1319 | 30 |
934196 | 934196 | 2021-01-16 | Whiteside | Illinois | 17195 | 5342 | 173 |
934197 | 934197 | 2021-01-16 | Will | Illinois | 17197 | 57707 | 867 |
934198 | 934198 | 2021-01-16 | Williamson | Illinois | 17199 | 6119 | 115 |
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]);