ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-09-12" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
525313 | 525313 | 2020-09-12 | Adams | Illinois | 17001 | 874 | 10 |
525314 | 525314 | 2020-09-12 | Alexander | Illinois | 17003 | 57 | 1 |
525315 | 525315 | 2020-09-12 | Bond | Illinois | 17005 | 226 | 4 |
525316 | 525316 | 2020-09-12 | Boone | Illinois | 17007 | 956 | 23 |
525317 | 525317 | 2020-09-12 | Brown | Illinois | 17009 | 26 | 0 |
525318 | 525318 | 2020-09-12 | Bureau | Illinois | 17011 | 488 | 9 |
525319 | 525319 | 2020-09-12 | Calhoun | Illinois | 17013 | 33 | 0 |
525320 | 525320 | 2020-09-12 | Carroll | Illinois | 17015 | 158 | 4 |
525321 | 525321 | 2020-09-12 | Cass | Illinois | 17017 | 348 | 11 |
525322 | 525322 | 2020-09-12 | Champaign | Illinois | 17019 | 3992 | 20 |
525323 | 525323 | 2020-09-12 | Christian | Illinois | 17021 | 297 | 10 |
525324 | 525324 | 2020-09-12 | Clark | Illinois | 17023 | 133 | 2 |
525325 | 525325 | 2020-09-12 | Clay | Illinois | 17025 | 127 | 0 |
525326 | 525326 | 2020-09-12 | Clinton | Illinois | 17027 | 936 | 19 |
525327 | 525327 | 2020-09-12 | Coles | Illinois | 17029 | 1219 | 26 |
525328 | 525328 | 2020-09-12 | Cook | Illinois | 17031 | 134352 | 5128 |
525329 | 525329 | 2020-09-12 | Crawford | Illinois | 17033 | 239 | 1 |
525330 | 525330 | 2020-09-12 | Cumberland | Illinois | 17035 | 179 | 4 |
525331 | 525331 | 2020-09-12 | De Witt | Illinois | 17039 | 72 | 1 |
525332 | 525332 | 2020-09-12 | DeKalb | Illinois | 17037 | 1350 | 36 |
525333 | 525333 | 2020-09-12 | Douglas | Illinois | 17041 | 254 | 5 |
525334 | 525334 | 2020-09-12 | DuPage | Illinois | 17043 | 15938 | 543 |
525335 | 525335 | 2020-09-12 | Edgar | Illinois | 17045 | 101 | 3 |
525336 | 525336 | 2020-09-12 | Edwards | Illinois | 17047 | 53 | 0 |
525337 | 525337 | 2020-09-12 | Effingham | Illinois | 17049 | 737 | 1 |
525338 | 525338 | 2020-09-12 | Fayette | Illinois | 17051 | 246 | 3 |
525339 | 525339 | 2020-09-12 | Ford | Illinois | 17053 | 84 | 4 |
525340 | 525340 | 2020-09-12 | Franklin | Illinois | 17055 | 415 | 1 |
525341 | 525341 | 2020-09-12 | Fulton | Illinois | 17057 | 117 | 0 |
525342 | 525342 | 2020-09-12 | Gallatin | Illinois | 17059 | 68 | 2 |
525343 | 525343 | 2020-09-12 | Greene | Illinois | 17061 | 182 | 2 |
525344 | 525344 | 2020-09-12 | Grundy | Illinois | 17063 | 567 | 5 |
525345 | 525345 | 2020-09-12 | Hamilton | Illinois | 17065 | 52 | 0 |
525346 | 525346 | 2020-09-12 | Hancock | Illinois | 17067 | 171 | 2 |
525347 | 525347 | 2020-09-12 | Hardin | Illinois | 17069 | 25 | 0 |
525348 | 525348 | 2020-09-12 | Henderson | Illinois | 17071 | 60 | 0 |
525349 | 525349 | 2020-09-12 | Henry | Illinois | 17073 | 574 | 4 |
525350 | 525350 | 2020-09-12 | Iroquois | Illinois | 17075 | 329 | 19 |
525351 | 525351 | 2020-09-12 | Jackson | Illinois | 17077 | 1135 | 24 |
525352 | 525352 | 2020-09-12 | Jasper | Illinois | 17079 | 180 | 7 |
525353 | 525353 | 2020-09-12 | Jefferson | Illinois | 17081 | 509 | 37 |
525354 | 525354 | 2020-09-12 | Jersey | Illinois | 17083 | 353 | 12 |
525355 | 525355 | 2020-09-12 | Jo Daviess | Illinois | 17085 | 210 | 2 |
525356 | 525356 | 2020-09-12 | Johnson | Illinois | 17087 | 130 | 0 |
525357 | 525357 | 2020-09-12 | Kane | Illinois | 17089 | 12097 | 324 |
525358 | 525358 | 2020-09-12 | Kankakee | Illinois | 17091 | 2549 | 72 |
525359 | 525359 | 2020-09-12 | Kendall | Illinois | 17093 | 1852 | 26 |
525360 | 525360 | 2020-09-12 | Knox | Illinois | 17095 | 521 | 3 |
525361 | 525361 | 2020-09-12 | LaSalle | Illinois | 17099 | 1475 | 54 |
525362 | 525362 | 2020-09-12 | Lake | Illinois | 17097 | 15700 | 478 |
525363 | 525363 | 2020-09-12 | Lawrence | Illinois | 17101 | 225 | 0 |
525364 | 525364 | 2020-09-12 | Lee | Illinois | 17103 | 298 | 1 |
525365 | 525365 | 2020-09-12 | Livingston | Illinois | 17105 | 263 | 4 |
525366 | 525366 | 2020-09-12 | Logan | Illinois | 17107 | 380 | 1 |
525367 | 525367 | 2020-09-12 | Macon | Illinois | 17115 | 1209 | 32 |
525368 | 525368 | 2020-09-12 | Macoupin | Illinois | 17117 | 432 | 6 |
525369 | 525369 | 2020-09-12 | Madison | Illinois | 17119 | 4872 | 118 |
525370 | 525370 | 2020-09-12 | Marion | Illinois | 17121 | 414 | 0 |
525371 | 525371 | 2020-09-12 | Marshall | Illinois | 17123 | 67 | 0 |
525372 | 525372 | 2020-09-12 | Mason | Illinois | 17125 | 107 | 1 |
525373 | 525373 | 2020-09-12 | Massac | Illinois | 17127 | 83 | 1 |
525374 | 525374 | 2020-09-12 | McDonough | Illinois | 17109 | 398 | 15 |
525375 | 525375 | 2020-09-12 | McHenry | Illinois | 17111 | 4303 | 118 |
525376 | 525376 | 2020-09-12 | McLean | Illinois | 17113 | 2881 | 18 |
525377 | 525377 | 2020-09-12 | Menard | Illinois | 17129 | 93 | 0 |
525378 | 525378 | 2020-09-12 | Mercer | Illinois | 17131 | 116 | 5 |
525379 | 525379 | 2020-09-12 | Monroe | Illinois | 17133 | 574 | 15 |
525380 | 525380 | 2020-09-12 | Montgomery | Illinois | 17135 | 288 | 11 |
525381 | 525381 | 2020-09-12 | Morgan | Illinois | 17137 | 606 | 21 |
525382 | 525382 | 2020-09-12 | Moultrie | Illinois | 17139 | 189 | 3 |
525383 | 525383 | 2020-09-12 | Ogle | Illinois | 17141 | 575 | 5 |
525384 | 525384 | 2020-09-12 | Peoria | Illinois | 17143 | 2845 | 44 |
525385 | 525385 | 2020-09-12 | Perry | Illinois | 17145 | 318 | 13 |
525386 | 525386 | 2020-09-12 | Piatt | Illinois | 17147 | 108 | 0 |
525387 | 525387 | 2020-09-12 | Pike | Illinois | 17149 | 99 | 1 |
525388 | 525388 | 2020-09-12 | Pope | Illinois | 17151 | 23 | 1 |
525389 | 525389 | 2020-09-12 | Pulaski | Illinois | 17153 | 146 | 1 |
525390 | 525390 | 2020-09-12 | Putnam | Illinois | 17155 | 31 | 0 |
525391 | 525391 | 2020-09-12 | Randolph | Illinois | 17157 | 841 | 8 |
525392 | 525392 | 2020-09-12 | Richland | Illinois | 17159 | 109 | 4 |
525393 | 525393 | 2020-09-12 | Rock Island | Illinois | 17161 | 2664 | 71 |
525394 | 525394 | 2020-09-12 | Saline | Illinois | 17165 | 203 | 3 |
525395 | 525395 | 2020-09-12 | Sangamon | Illinois | 17167 | 2117 | 43 |
525396 | 525396 | 2020-09-12 | Schuyler | Illinois | 17169 | 33 | 0 |
525397 | 525397 | 2020-09-12 | Scott | Illinois | 17171 | 59 | 0 |
525398 | 525398 | 2020-09-12 | Shelby | Illinois | 17173 | 294 | 3 |
525399 | 525399 | 2020-09-12 | St. Clair | Illinois | 17163 | 6632 | 180 |
525400 | 525400 | 2020-09-12 | Stark | Illinois | 17175 | 43 | 1 |
525401 | 525401 | 2020-09-12 | Stephenson | Illinois | 17177 | 421 | 6 |
525402 | 525402 | 2020-09-12 | Tazewell | Illinois | 17179 | 1367 | 13 |
525403 | 525403 | 2020-09-12 | Union | Illinois | 17181 | 464 | 24 |
525404 | 525404 | 2020-09-12 | Unknown | Illinois | 2027 | 232 | |
525405 | 525405 | 2020-09-12 | Vermilion | Illinois | 17183 | 450 | 4 |
525406 | 525406 | 2020-09-12 | Wabash | Illinois | 17185 | 133 | 1 |
525407 | 525407 | 2020-09-12 | Warren | Illinois | 17187 | 282 | 1 |
525408 | 525408 | 2020-09-12 | Washington | Illinois | 17189 | 152 | 1 |
525409 | 525409 | 2020-09-12 | Wayne | Illinois | 17191 | 177 | 4 |
525410 | 525410 | 2020-09-12 | White | Illinois | 17193 | 147 | 0 |
525411 | 525411 | 2020-09-12 | Whiteside | Illinois | 17195 | 637 | 20 |
525412 | 525412 | 2020-09-12 | Will | Illinois | 17197 | 12770 | 367 |
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);