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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Cook 156
- Kane 110
- McHenry 110
- Lake 109
- Woodford 107
- Cumberland 106
- DuPage 106
- Sangamon 106
- St. Clair 106
- Winnebago 106
- Clinton 105
- Whiteside 105
- Peoria 104
- Will 104
- Jackson 102
- Kankakee 102
- Kendall 102
- LaSalle 102
- Madison 102
- Washington 102
- Williamson 102
- Adams 100
- Christian 100
- McLean 100
- DeKalb 99
- Champaign 98
- Jo Daviess 98
- Livingston 98
- Rock Island 98
- Stephenson 98
- …
state 1
- Illinois · 9,038 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281473 | 281473 | 2020-06-28 | Winnebago | Illinois | 17201 | 3004 | 92 |
281474 | 281474 | 2020-06-28 | Woodford | Illinois | 17203 | 34 | 2 |
278225 | 278225 | 2020-06-27 | Adams | Illinois | 17001 | 77 | 1 |
278226 | 278226 | 2020-06-27 | Alexander | Illinois | 17003 | 22 | 0 |
278227 | 278227 | 2020-06-27 | Bond | Illinois | 17005 | 13 | 1 |
278228 | 278228 | 2020-06-27 | Boone | Illinois | 17007 | 572 | 21 |
278229 | 278229 | 2020-06-27 | Brown | Illinois | 17009 | 10 | 0 |
278230 | 278230 | 2020-06-27 | Bureau | Illinois | 17011 | 24 | 1 |
278231 | 278231 | 2020-06-27 | Calhoun | Illinois | 17013 | 1 | 0 |
278232 | 278232 | 2020-06-27 | Carroll | Illinois | 17015 | 21 | 2 |
278233 | 278233 | 2020-06-27 | Cass | Illinois | 17017 | 127 | 1 |
278234 | 278234 | 2020-06-27 | Champaign | Illinois | 17019 | 839 | 12 |
278235 | 278235 | 2020-06-27 | Christian | Illinois | 17021 | 43 | 5 |
278236 | 278236 | 2020-06-27 | Clark | Illinois | 17023 | 14 | 0 |
278237 | 278237 | 2020-06-27 | Clay | Illinois | 17025 | 2 | 0 |
278238 | 278238 | 2020-06-27 | Clinton | Illinois | 17027 | 231 | 17 |
278239 | 278239 | 2020-06-27 | Coles | Illinois | 17029 | 158 | 17 |
278240 | 278240 | 2020-06-27 | Cook | Illinois | 17031 | 89407 | 4536 |
278241 | 278241 | 2020-06-27 | Crawford | Illinois | 17033 | 18 | 0 |
278242 | 278242 | 2020-06-27 | Cumberland | Illinois | 17035 | 11 | 0 |
278243 | 278243 | 2020-06-27 | De Witt | Illinois | 17039 | 4 | 0 |
278244 | 278244 | 2020-06-27 | DeKalb | Illinois | 17037 | 558 | 18 |
278245 | 278245 | 2020-06-27 | Douglas | Illinois | 17041 | 47 | 0 |
278246 | 278246 | 2020-06-27 | DuPage | Illinois | 17043 | 8922 | 468 |
278247 | 278247 | 2020-06-27 | Edgar | Illinois | 17045 | 9 | 0 |
278248 | 278248 | 2020-06-27 | Edwards | Illinois | 17047 | 2 | 0 |
278249 | 278249 | 2020-06-27 | Effingham | Illinois | 17049 | 11 | 1 |
278250 | 278250 | 2020-06-27 | Fayette | Illinois | 17051 | 23 | 3 |
278251 | 278251 | 2020-06-27 | Ford | Illinois | 17053 | 30 | 1 |
278252 | 278252 | 2020-06-27 | Franklin | Illinois | 17055 | 13 | 0 |
278253 | 278253 | 2020-06-27 | Fulton | Illinois | 17057 | 15 | 0 |
278254 | 278254 | 2020-06-27 | Gallatin | Illinois | 17059 | 2 | 0 |
278255 | 278255 | 2020-06-27 | Greene | Illinois | 17061 | 9 | 0 |
278256 | 278256 | 2020-06-27 | Grundy | Illinois | 17063 | 160 | 4 |
278257 | 278257 | 2020-06-27 | Hamilton | Illinois | 17065 | 4 | 0 |
278258 | 278258 | 2020-06-27 | Hancock | Illinois | 17067 | 18 | 1 |
278259 | 278259 | 2020-06-27 | Hardin | Illinois | 17069 | 1 | 0 |
278260 | 278260 | 2020-06-27 | Henderson | Illinois | 17071 | 8 | 0 |
278261 | 278261 | 2020-06-27 | Henry | Illinois | 17073 | 79 | 1 |
278262 | 278262 | 2020-06-27 | Iroquois | Illinois | 17075 | 156 | 5 |
278263 | 278263 | 2020-06-27 | Jackson | Illinois | 17077 | 329 | 19 |
278264 | 278264 | 2020-06-27 | Jasper | Illinois | 17079 | 46 | 7 |
278265 | 278265 | 2020-06-27 | Jefferson | Illinois | 17081 | 106 | 17 |
278266 | 278266 | 2020-06-27 | Jersey | Illinois | 17083 | 35 | 1 |
278267 | 278267 | 2020-06-27 | Jo Daviess | Illinois | 17085 | 40 | 1 |
278268 | 278268 | 2020-06-27 | Johnson | Illinois | 17087 | 20 | 0 |
278269 | 278269 | 2020-06-27 | Kane | Illinois | 17089 | 7656 | 265 |
278270 | 278270 | 2020-06-27 | Kankakee | Illinois | 17091 | 1342 | 64 |
278271 | 278271 | 2020-06-27 | Kendall | Illinois | 17093 | 990 | 23 |
278272 | 278272 | 2020-06-27 | Knox | Illinois | 17095 | 124 | 0 |
278273 | 278273 | 2020-06-27 | LaSalle | Illinois | 17099 | 205 | 17 |
278274 | 278274 | 2020-06-27 | Lake | Illinois | 17097 | 9608 | 414 |
278275 | 278275 | 2020-06-27 | Lawrence | Illinois | 17101 | 7 | 0 |
278276 | 278276 | 2020-06-27 | Lee | Illinois | 17103 | 97 | 2 |
278277 | 278277 | 2020-06-27 | Livingston | Illinois | 17105 | 42 | 2 |
278278 | 278278 | 2020-06-27 | Logan | Illinois | 17107 | 13 | 0 |
278279 | 278279 | 2020-06-27 | Macon | Illinois | 17115 | 227 | 22 |
278280 | 278280 | 2020-06-27 | Macoupin | Illinois | 17117 | 51 | 3 |
278281 | 278281 | 2020-06-27 | Madison | Illinois | 17119 | 903 | 68 |
278282 | 278282 | 2020-06-27 | Marion | Illinois | 17121 | 65 | 0 |
278283 | 278283 | 2020-06-27 | Marshall | Illinois | 17123 | 8 | 0 |
278284 | 278284 | 2020-06-27 | Mason | Illinois | 17125 | 22 | 0 |
278285 | 278285 | 2020-06-27 | Massac | Illinois | 17127 | 10 | 0 |
278286 | 278286 | 2020-06-27 | McDonough | Illinois | 17109 | 100 | 15 |
278287 | 278287 | 2020-06-27 | McHenry | Illinois | 17111 | 1991 | 97 |
278288 | 278288 | 2020-06-27 | McLean | Illinois | 17113 | 256 | 13 |
278289 | 278289 | 2020-06-27 | Menard | Illinois | 17129 | 24 | 0 |
278290 | 278290 | 2020-06-27 | Mercer | Illinois | 17131 | 20 | 0 |
278291 | 278291 | 2020-06-27 | Monroe | Illinois | 17133 | 123 | 13 |
278292 | 278292 | 2020-06-27 | Montgomery | Illinois | 17135 | 41 | 0 |
278293 | 278293 | 2020-06-27 | Morgan | Illinois | 17137 | 126 | 3 |
278294 | 278294 | 2020-06-27 | Moultrie | Illinois | 17139 | 17 | 0 |
278295 | 278295 | 2020-06-27 | Ogle | Illinois | 17141 | 252 | 4 |
278296 | 278296 | 2020-06-27 | Peoria | Illinois | 17143 | 468 | 27 |
278297 | 278297 | 2020-06-27 | Perry | Illinois | 17145 | 49 | 0 |
278298 | 278298 | 2020-06-27 | Piatt | Illinois | 17147 | 19 | 0 |
278299 | 278299 | 2020-06-27 | Pike | Illinois | 17149 | 2 | 0 |
278300 | 278300 | 2020-06-27 | Pope | Illinois | 17151 | 1 | 0 |
278301 | 278301 | 2020-06-27 | Pulaski | Illinois | 17153 | 74 | 0 |
278302 | 278302 | 2020-06-27 | Putnam | Illinois | 17155 | 1 | 0 |
278303 | 278303 | 2020-06-27 | Randolph | Illinois | 17157 | 279 | 7 |
278304 | 278304 | 2020-06-27 | Richland | Illinois | 17159 | 4 | 0 |
278305 | 278305 | 2020-06-27 | Rock Island | Illinois | 17161 | 913 | 28 |
278306 | 278306 | 2020-06-27 | Saline | Illinois | 17165 | 9 | 0 |
278307 | 278307 | 2020-06-27 | Sangamon | Illinois | 17167 | 408 | 33 |
278308 | 278308 | 2020-06-27 | Schuyler | Illinois | 17169 | 13 | 0 |
278309 | 278309 | 2020-06-27 | Shelby | Illinois | 17173 | 16 | 1 |
278310 | 278310 | 2020-06-27 | St. Clair | Illinois | 17163 | 1956 | 138 |
278311 | 278311 | 2020-06-27 | Stark | Illinois | 17175 | 3 | 0 |
278312 | 278312 | 2020-06-27 | Stephenson | Illinois | 17177 | 268 | 5 |
278313 | 278313 | 2020-06-27 | Tazewell | Illinois | 17179 | 120 | 7 |
278314 | 278314 | 2020-06-27 | Union | Illinois | 17181 | 183 | 19 |
278315 | 278315 | 2020-06-27 | Unknown | Illinois | 1053 | 201 | |
278316 | 278316 | 2020-06-27 | Vermilion | Illinois | 17183 | 58 | 2 |
278317 | 278317 | 2020-06-27 | Wabash | Illinois | 17185 | 22 | 0 |
278318 | 278318 | 2020-06-27 | Warren | Illinois | 17187 | 133 | 0 |
278319 | 278319 | 2020-06-27 | Washington | Illinois | 17189 | 19 | 0 |
278320 | 278320 | 2020-06-27 | Wayne | Illinois | 17191 | 12 | 1 |
278321 | 278321 | 2020-06-27 | White | Illinois | 17193 | 4 | 0 |
278322 | 278322 | 2020-06-27 | Whiteside | Illinois | 17195 | 183 | 15 |
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);