ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2020-12-24" 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 |
---|---|---|---|---|---|---|---|
859378 | 859378 | 2020-12-24 | Adams | Illinois | 17001 | 6162 | 73 |
859379 | 859379 | 2020-12-24 | Alexander | Illinois | 17003 | 331 | 6 |
859380 | 859380 | 2020-12-24 | Bond | Illinois | 17005 | 1480 | 16 |
859381 | 859381 | 2020-12-24 | Boone | Illinois | 17007 | 4873 | 63 |
859382 | 859382 | 2020-12-24 | Brown | Illinois | 17009 | 431 | 11 |
859383 | 859383 | 2020-12-24 | Bureau | Illinois | 17011 | 2684 | 66 |
859384 | 859384 | 2020-12-24 | Calhoun | Illinois | 17013 | 354 | 3 |
859385 | 859385 | 2020-12-24 | Carroll | Illinois | 17015 | 1284 | 30 |
859386 | 859386 | 2020-12-24 | Cass | Illinois | 17017 | 1485 | 29 |
859387 | 859387 | 2020-12-24 | Champaign | Illinois | 17019 | 13335 | 85 |
859388 | 859388 | 2020-12-24 | Christian | Illinois | 17021 | 2483 | 63 |
859389 | 859389 | 2020-12-24 | Clark | Illinois | 17023 | 1119 | 24 |
859390 | 859390 | 2020-12-24 | Clay | Illinois | 17025 | 1164 | 33 |
859391 | 859391 | 2020-12-24 | Clinton | Illinois | 17027 | 4307 | 79 |
859392 | 859392 | 2020-12-24 | Coles | Illinois | 17029 | 4150 | 69 |
859393 | 859393 | 2020-12-24 | Cook | Illinois | 17031 | 380096 | 7954 |
859394 | 859394 | 2020-12-24 | Crawford | Illinois | 17033 | 1518 | 29 |
859395 | 859395 | 2020-12-24 | Cumberland | Illinois | 17035 | 897 | 23 |
859396 | 859396 | 2020-12-24 | De Witt | Illinois | 17039 | 863 | 24 |
859397 | 859397 | 2020-12-24 | DeKalb | Illinois | 17037 | 6473 | 74 |
859398 | 859398 | 2020-12-24 | Douglas | Illinois | 17041 | 1767 | 26 |
859399 | 859399 | 2020-12-24 | DuPage | Illinois | 17043 | 59212 | 971 |
859400 | 859400 | 2020-12-24 | Edgar | Illinois | 17045 | 1294 | 38 |
859401 | 859401 | 2020-12-24 | Edwards | Illinois | 17047 | 362 | 6 |
859402 | 859402 | 2020-12-24 | Effingham | Illinois | 17049 | 3698 | 54 |
859403 | 859403 | 2020-12-24 | Fayette | Illinois | 17051 | 2564 | 49 |
859404 | 859404 | 2020-12-24 | Ford | Illinois | 17053 | 1172 | 39 |
859405 | 859405 | 2020-12-24 | Franklin | Illinois | 17055 | 3129 | 49 |
859406 | 859406 | 2020-12-24 | Fulton | Illinois | 17057 | 2183 | 26 |
859407 | 859407 | 2020-12-24 | Gallatin | Illinois | 17059 | 304 | 4 |
859408 | 859408 | 2020-12-24 | Greene | Illinois | 17061 | 1084 | 41 |
859409 | 859409 | 2020-12-24 | Grundy | Illinois | 17063 | 3709 | 39 |
859410 | 859410 | 2020-12-24 | Hamilton | Illinois | 17065 | 556 | 10 |
859411 | 859411 | 2020-12-24 | Hancock | Illinois | 17067 | 1249 | 28 |
859412 | 859412 | 2020-12-24 | Hardin | Illinois | 17069 | 203 | 6 |
859413 | 859413 | 2020-12-24 | Henderson | Illinois | 17071 | 384 | 6 |
859414 | 859414 | 2020-12-24 | Henry | Illinois | 17073 | 3562 | 52 |
859415 | 859415 | 2020-12-24 | Iroquois | Illinois | 17075 | 2228 | 46 |
859416 | 859416 | 2020-12-24 | Jackson | Illinois | 17077 | 3492 | 54 |
859417 | 859417 | 2020-12-24 | Jasper | Illinois | 17079 | 869 | 14 |
859418 | 859418 | 2020-12-24 | Jefferson | Illinois | 17081 | 2764 | 73 |
859419 | 859419 | 2020-12-24 | Jersey | Illinois | 17083 | 1861 | 35 |
859420 | 859420 | 2020-12-24 | Jo Daviess | Illinois | 17085 | 1360 | 24 |
859421 | 859421 | 2020-12-24 | Johnson | Illinois | 17087 | 937 | 15 |
859422 | 859422 | 2020-12-24 | Kane | Illinois | 17089 | 39970 | 577 |
859423 | 859423 | 2020-12-24 | Kankakee | Illinois | 17091 | 10451 | 151 |
859424 | 859424 | 2020-12-24 | Kendall | Illinois | 17093 | 8102 | 69 |
859425 | 859425 | 2020-12-24 | Knox | Illinois | 17095 | 3846 | 111 |
859426 | 859426 | 2020-12-24 | LaSalle | Illinois | 17099 | 8008 | 217 |
859427 | 859427 | 2020-12-24 | Lake | Illinois | 17097 | 46551 | 772 |
859428 | 859428 | 2020-12-24 | Lawrence | Illinois | 17101 | 1762 | 24 |
859429 | 859429 | 2020-12-24 | Lee | Illinois | 17103 | 2604 | 63 |
859430 | 859430 | 2020-12-24 | Livingston | Illinois | 17105 | 2997 | 57 |
859431 | 859431 | 2020-12-24 | Logan | Illinois | 17107 | 2587 | 43 |
859432 | 859432 | 2020-12-24 | Macon | Illinois | 17115 | 7737 | 162 |
859433 | 859433 | 2020-12-24 | Macoupin | Illinois | 17117 | 3102 | 63 |
859434 | 859434 | 2020-12-24 | Madison | Illinois | 17119 | 20065 | 372 |
859435 | 859435 | 2020-12-24 | Marion | Illinois | 17121 | 3401 | 101 |
859436 | 859436 | 2020-12-24 | Marshall | Illinois | 17123 | 558 | 9 |
859437 | 859437 | 2020-12-24 | Mason | Illinois | 17125 | 962 | 36 |
859438 | 859438 | 2020-12-24 | Massac | Illinois | 17127 | 850 | 24 |
859439 | 859439 | 2020-12-24 | McDonough | Illinois | 17109 | 1938 | 46 |
859440 | 859440 | 2020-12-24 | McHenry | Illinois | 17111 | 18260 | 204 |
859441 | 859441 | 2020-12-24 | McLean | Illinois | 17113 | 11055 | 93 |
859442 | 859442 | 2020-12-24 | Menard | Illinois | 17129 | 699 | 6 |
859443 | 859443 | 2020-12-24 | Mercer | Illinois | 17131 | 1036 | 23 |
859444 | 859444 | 2020-12-24 | Monroe | Illinois | 17133 | 2928 | 56 |
859445 | 859445 | 2020-12-24 | Montgomery | Illinois | 17135 | 1729 | 22 |
859446 | 859446 | 2020-12-24 | Morgan | Illinois | 17137 | 2959 | 77 |
859447 | 859447 | 2020-12-24 | Moultrie | Illinois | 17139 | 1206 | 22 |
859448 | 859448 | 2020-12-24 | Ogle | Illinois | 17141 | 3888 | 62 |
859449 | 859449 | 2020-12-24 | Peoria | Illinois | 17143 | 12552 | 184 |
859450 | 859450 | 2020-12-24 | Perry | Illinois | 17145 | 1875 | 49 |
859451 | 859451 | 2020-12-24 | Piatt | Illinois | 17147 | 1002 | 6 |
859452 | 859452 | 2020-12-24 | Pike | Illinois | 17149 | 1317 | 36 |
859453 | 859453 | 2020-12-24 | Pope | Illinois | 17151 | 177 | 1 |
859454 | 859454 | 2020-12-24 | Pulaski | Illinois | 17153 | 547 | 2 |
859455 | 859455 | 2020-12-24 | Putnam | Illinois | 17155 | 305 | 0 |
859456 | 859456 | 2020-12-24 | Randolph | Illinois | 17157 | 3147 | 36 |
859457 | 859457 | 2020-12-24 | Richland | Illinois | 17159 | 1232 | 30 |
859458 | 859458 | 2020-12-24 | Rock Island | Illinois | 17161 | 10654 | 228 |
859459 | 859459 | 2020-12-24 | Saline | Illinois | 17165 | 1644 | 37 |
859460 | 859460 | 2020-12-24 | Sangamon | Illinois | 17167 | 12843 | 182 |
859461 | 859461 | 2020-12-24 | Schuyler | Illinois | 17169 | 525 | 12 |
859462 | 859462 | 2020-12-24 | Scott | Illinois | 17171 | 307 | 1 |
859463 | 859463 | 2020-12-24 | Shelby | Illinois | 17173 | 1739 | 33 |
859464 | 859464 | 2020-12-24 | St. Clair | Illinois | 17163 | 19779 | 326 |
859465 | 859465 | 2020-12-24 | Stark | Illinois | 17175 | 418 | 15 |
859466 | 859466 | 2020-12-24 | Stephenson | Illinois | 17177 | 3118 | 55 |
859467 | 859467 | 2020-12-24 | Tazewell | Illinois | 17179 | 9738 | 176 |
859468 | 859468 | 2020-12-24 | Union | Illinois | 17181 | 1583 | 30 |
859469 | 859469 | 2020-12-24 | Vermilion | Illinois | 17183 | 5991 | 84 |
859470 | 859470 | 2020-12-24 | Wabash | Illinois | 17185 | 982 | 11 |
859471 | 859471 | 2020-12-24 | Warren | Illinois | 17187 | 1442 | 32 |
859472 | 859472 | 2020-12-24 | Washington | Illinois | 17189 | 1131 | 19 |
859473 | 859473 | 2020-12-24 | Wayne | Illinois | 17191 | 1285 | 39 |
859474 | 859474 | 2020-12-24 | White | Illinois | 17193 | 1055 | 20 |
859475 | 859475 | 2020-12-24 | Whiteside | Illinois | 17195 | 4770 | 154 |
859476 | 859476 | 2020-12-24 | Will | Illinois | 17197 | 50238 | 741 |
859477 | 859477 | 2020-12-24 | Williamson | Illinois | 17199 | 4926 | 106 |
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);