ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2020-07-16 and state = "Illinois" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
338426 | 338426 | 2020-07-16 | Adams | Illinois | 17001 | 223 | 1 |
338427 | 338427 | 2020-07-16 | Alexander | Illinois | 17003 | 27 | 0 |
338428 | 338428 | 2020-07-16 | Bond | Illinois | 17005 | 23 | 2 |
338429 | 338429 | 2020-07-16 | Boone | Illinois | 17007 | 645 | 21 |
338430 | 338430 | 2020-07-16 | Brown | Illinois | 17009 | 10 | 0 |
338431 | 338431 | 2020-07-16 | Bureau | Illinois | 17011 | 47 | 2 |
338432 | 338432 | 2020-07-16 | Calhoun | Illinois | 17013 | 2 | 0 |
338433 | 338433 | 2020-07-16 | Carroll | Illinois | 17015 | 21 | 2 |
338434 | 338434 | 2020-07-16 | Cass | Illinois | 17017 | 141 | 10 |
338435 | 338435 | 2020-07-16 | Champaign | Illinois | 17019 | 1121 | 17 |
338436 | 338436 | 2020-07-16 | Christian | Illinois | 17021 | 53 | 5 |
338437 | 338437 | 2020-07-16 | Clark | Illinois | 17023 | 45 | 0 |
338438 | 338438 | 2020-07-16 | Clay | Illinois | 17025 | 8 | 0 |
338439 | 338439 | 2020-07-16 | Clinton | Illinois | 17027 | 260 | 16 |
338440 | 338440 | 2020-07-16 | Coles | Illinois | 17029 | 212 | 17 |
338441 | 338441 | 2020-07-16 | Cook | Illinois | 17031 | 97214 | 4750 |
338442 | 338442 | 2020-07-16 | Crawford | Illinois | 17033 | 21 | 0 |
338443 | 338443 | 2020-07-16 | Cumberland | Illinois | 17035 | 31 | 1 |
338444 | 338444 | 2020-07-16 | De Witt | Illinois | 17039 | 18 | 0 |
338445 | 338445 | 2020-07-16 | DeKalb | Illinois | 17037 | 709 | 22 |
338446 | 338446 | 2020-07-16 | Douglas | Illinois | 17041 | 66 | 0 |
338447 | 338447 | 2020-07-16 | DuPage | Illinois | 17043 | 9917 | 494 |
338448 | 338448 | 2020-07-16 | Edgar | Illinois | 17045 | 20 | 0 |
338449 | 338449 | 2020-07-16 | Edwards | Illinois | 17047 | 5 | 0 |
338450 | 338450 | 2020-07-16 | Effingham | Illinois | 17049 | 35 | 2 |
338451 | 338451 | 2020-07-16 | Fayette | Illinois | 17051 | 30 | 3 |
338452 | 338452 | 2020-07-16 | Ford | Illinois | 17053 | 32 | 1 |
338453 | 338453 | 2020-07-16 | Franklin | Illinois | 17055 | 62 | 0 |
338454 | 338454 | 2020-07-16 | Fulton | Illinois | 17057 | 18 | 0 |
338455 | 338455 | 2020-07-16 | Gallatin | Illinois | 17059 | 9 | 0 |
338456 | 338456 | 2020-07-16 | Greene | Illinois | 17061 | 12 | 0 |
338457 | 338457 | 2020-07-16 | Grundy | Illinois | 17063 | 207 | 5 |
338458 | 338458 | 2020-07-16 | Hamilton | Illinois | 17065 | 8 | 0 |
338459 | 338459 | 2020-07-16 | Hancock | Illinois | 17067 | 21 | 1 |
338460 | 338460 | 2020-07-16 | Hardin | Illinois | 17069 | 3 | 0 |
338461 | 338461 | 2020-07-16 | Henderson | Illinois | 17071 | 8 | 0 |
338462 | 338462 | 2020-07-16 | Henry | Illinois | 17073 | 128 | 1 |
338463 | 338463 | 2020-07-16 | Iroquois | Illinois | 17075 | 181 | 5 |
338464 | 338464 | 2020-07-16 | Jackson | Illinois | 17077 | 373 | 19 |
338465 | 338465 | 2020-07-16 | Jasper | Illinois | 17079 | 48 | 7 |
338466 | 338466 | 2020-07-16 | Jefferson | Illinois | 17081 | 124 | 17 |
338467 | 338467 | 2020-07-16 | Jersey | Illinois | 17083 | 50 | 1 |
338468 | 338468 | 2020-07-16 | Jo Daviess | Illinois | 17085 | 58 | 1 |
338469 | 338469 | 2020-07-16 | Johnson | Illinois | 17087 | 36 | 0 |
338470 | 338470 | 2020-07-16 | Kane | Illinois | 17089 | 8320 | 288 |
338471 | 338471 | 2020-07-16 | Kankakee | Illinois | 17091 | 1529 | 66 |
338472 | 338472 | 2020-07-16 | Kendall | Illinois | 17093 | 1152 | 23 |
338473 | 338473 | 2020-07-16 | Knox | Illinois | 17095 | 179 | 0 |
338474 | 338474 | 2020-07-16 | LaSalle | Illinois | 17099 | 298 | 17 |
338475 | 338475 | 2020-07-16 | Lake | Illinois | 17097 | 10653 | 432 |
338476 | 338476 | 2020-07-16 | Lawrence | Illinois | 17101 | 16 | 0 |
338477 | 338477 | 2020-07-16 | Lee | Illinois | 17103 | 111 | 2 |
338478 | 338478 | 2020-07-16 | Livingston | Illinois | 17105 | 57 | 2 |
338479 | 338479 | 2020-07-16 | Logan | Illinois | 17107 | 30 | 0 |
338480 | 338480 | 2020-07-16 | Macon | Illinois | 17115 | 262 | 22 |
338481 | 338481 | 2020-07-16 | Macoupin | Illinois | 17117 | 76 | 3 |
338482 | 338482 | 2020-07-16 | Madison | Illinois | 17119 | 1368 | 71 |
338483 | 338483 | 2020-07-16 | Marion | Illinois | 17121 | 81 | 0 |
338484 | 338484 | 2020-07-16 | Marshall | Illinois | 17123 | 13 | 0 |
338485 | 338485 | 2020-07-16 | Mason | Illinois | 17125 | 31 | 0 |
338486 | 338486 | 2020-07-16 | Massac | Illinois | 17127 | 20 | 0 |
338487 | 338487 | 2020-07-16 | McDonough | Illinois | 17109 | 111 | 15 |
338488 | 338488 | 2020-07-16 | McHenry | Illinois | 17111 | 2418 | 105 |
338489 | 338489 | 2020-07-16 | McLean | Illinois | 17113 | 349 | 15 |
338490 | 338490 | 2020-07-16 | Menard | Illinois | 17129 | 32 | 0 |
338491 | 338491 | 2020-07-16 | Mercer | Illinois | 17131 | 30 | 0 |
338492 | 338492 | 2020-07-16 | Monroe | Illinois | 17133 | 182 | 13 |
338493 | 338493 | 2020-07-16 | Montgomery | Illinois | 17135 | 97 | 1 |
338494 | 338494 | 2020-07-16 | Morgan | Illinois | 17137 | 137 | 4 |
338495 | 338495 | 2020-07-16 | Moultrie | Illinois | 17139 | 28 | 0 |
338496 | 338496 | 2020-07-16 | Ogle | Illinois | 17141 | 343 | 5 |
338497 | 338497 | 2020-07-16 | Peoria | Illinois | 17143 | 772 | 30 |
338498 | 338498 | 2020-07-16 | Perry | Illinois | 17145 | 63 | 1 |
338499 | 338499 | 2020-07-16 | Piatt | Illinois | 17147 | 21 | 0 |
338500 | 338500 | 2020-07-16 | Pike | Illinois | 17149 | 9 | 0 |
338501 | 338501 | 2020-07-16 | Pope | Illinois | 17151 | 3 | 0 |
338502 | 338502 | 2020-07-16 | Pulaski | Illinois | 17153 | 87 | 0 |
338503 | 338503 | 2020-07-16 | Putnam | Illinois | 17155 | 1 | 0 |
338504 | 338504 | 2020-07-16 | Randolph | Illinois | 17157 | 343 | 7 |
338505 | 338505 | 2020-07-16 | Richland | Illinois | 17159 | 10 | 0 |
338506 | 338506 | 2020-07-16 | Rock Island | Illinois | 17161 | 1285 | 30 |
338507 | 338507 | 2020-07-16 | Saline | Illinois | 17165 | 28 | 0 |
338508 | 338508 | 2020-07-16 | Sangamon | Illinois | 17167 | 613 | 34 |
338509 | 338509 | 2020-07-16 | Schuyler | Illinois | 17169 | 14 | 0 |
338510 | 338510 | 2020-07-16 | Scott | Illinois | 17171 | 1 | 0 |
338511 | 338511 | 2020-07-16 | Shelby | Illinois | 17173 | 24 | 1 |
338512 | 338512 | 2020-07-16 | St. Clair | Illinois | 17163 | 2803 | 147 |
338513 | 338513 | 2020-07-16 | Stark | Illinois | 17175 | 6 | 0 |
338514 | 338514 | 2020-07-16 | Stephenson | Illinois | 17177 | 287 | 6 |
338515 | 338515 | 2020-07-16 | Tazewell | Illinois | 17179 | 204 | 8 |
338516 | 338516 | 2020-07-16 | Union | Illinois | 17181 | 217 | 21 |
338517 | 338517 | 2020-07-16 | Unknown | Illinois | 1132 | 201 | |
338518 | 338518 | 2020-07-16 | Vermilion | Illinois | 17183 | 100 | 2 |
338519 | 338519 | 2020-07-16 | Wabash | Illinois | 17185 | 23 | 0 |
338520 | 338520 | 2020-07-16 | Warren | Illinois | 17187 | 150 | 0 |
338521 | 338521 | 2020-07-16 | Washington | Illinois | 17189 | 29 | 0 |
338522 | 338522 | 2020-07-16 | Wayne | Illinois | 17191 | 20 | 1 |
338523 | 338523 | 2020-07-16 | White | Illinois | 17193 | 22 | 0 |
338524 | 338524 | 2020-07-16 | Whiteside | Illinois | 17195 | 225 | 16 |
338525 | 338525 | 2020-07-16 | Will | Illinois | 17197 | 7476 | 330 |
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);