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 2021-02-11 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1018404 | 1018404 | 2021-02-11 | Adams | Illinois | 17001 | 7870 | 140 |
1018405 | 1018405 | 2021-02-11 | Alexander | Illinois | 17003 | 434 | 8 |
1018406 | 1018406 | 2021-02-11 | Bond | Illinois | 17005 | 1846 | 29 |
1018407 | 1018407 | 2021-02-11 | Boone | Illinois | 17007 | 5831 | 85 |
1018408 | 1018408 | 2021-02-11 | Brown | Illinois | 17009 | 648 | 12 |
1018409 | 1018409 | 2021-02-11 | Bureau | Illinois | 17011 | 3198 | 86 |
1018410 | 1018410 | 2021-02-11 | Calhoun | Illinois | 17013 | 469 | 5 |
1018411 | 1018411 | 2021-02-11 | Carroll | Illinois | 17015 | 1537 | 34 |
1018412 | 1018412 | 2021-02-11 | Cass | Illinois | 17017 | 1853 | 31 |
1018413 | 1018413 | 2021-02-11 | Champaign | Illinois | 17019 | 17254 | 118 |
1018414 | 1018414 | 2021-02-11 | Christian | Illinois | 17021 | 3232 | 80 |
1018415 | 1018415 | 2021-02-11 | Clark | Illinois | 17023 | 1637 | 36 |
1018416 | 1018416 | 2021-02-11 | Clay | Illinois | 17025 | 1402 | 45 |
1018417 | 1018417 | 2021-02-11 | Clinton | Illinois | 17027 | 5507 | 96 |
1018418 | 1018418 | 2021-02-11 | Coles | Illinois | 17029 | 5039 | 91 |
1018419 | 1018419 | 2021-02-11 | Cook | Illinois | 17031 | 463581 | 9655 |
1018420 | 1018420 | 2021-02-11 | Crawford | Illinois | 17033 | 1966 | 37 |
1018421 | 1018421 | 2021-02-11 | Cumberland | Illinois | 17035 | 1159 | 29 |
1018422 | 1018422 | 2021-02-11 | De Witt | Illinois | 17039 | 1251 | 29 |
1018423 | 1018423 | 2021-02-11 | DeKalb | Illinois | 17037 | 8178 | 113 |
1018424 | 1018424 | 2021-02-11 | Douglas | Illinois | 17041 | 2229 | 35 |
1018425 | 1018425 | 2021-02-11 | DuPage | Illinois | 17043 | 74406 | 1230 |
1018426 | 1018426 | 2021-02-11 | Edgar | Illinois | 17045 | 1524 | 56 |
1018427 | 1018427 | 2021-02-11 | Edwards | Illinois | 17047 | 514 | 10 |
1018428 | 1018428 | 2021-02-11 | Effingham | Illinois | 17049 | 4448 | 79 |
1018429 | 1018429 | 2021-02-11 | Fayette | Illinois | 17051 | 3042 | 55 |
1018430 | 1018430 | 2021-02-11 | Ford | Illinois | 17053 | 1497 | 51 |
1018431 | 1018431 | 2021-02-11 | Franklin | Illinois | 17055 | 4080 | 76 |
1018432 | 1018432 | 2021-02-11 | Fulton | Illinois | 17057 | 2764 | 52 |
1018433 | 1018433 | 2021-02-11 | Gallatin | Illinois | 17059 | 424 | 4 |
1018434 | 1018434 | 2021-02-11 | Greene | Illinois | 17061 | 1352 | 44 |
1018435 | 1018435 | 2021-02-11 | Grundy | Illinois | 17063 | 4883 | 64 |
1018436 | 1018436 | 2021-02-11 | Hamilton | Illinois | 17065 | 765 | 18 |
1018437 | 1018437 | 2021-02-11 | Hancock | Illinois | 17067 | 1624 | 37 |
1018438 | 1018438 | 2021-02-11 | Hardin | Illinois | 17069 | 334 | 11 |
1018439 | 1018439 | 2021-02-11 | Henderson | Illinois | 17071 | 490 | 17 |
1018440 | 1018440 | 2021-02-11 | Henry | Illinois | 17073 | 4252 | 82 |
1018441 | 1018441 | 2021-02-11 | Iroquois | Illinois | 17075 | 2739 | 61 |
1018442 | 1018442 | 2021-02-11 | Jackson | Illinois | 17077 | 4530 | 71 |
1018443 | 1018443 | 2021-02-11 | Jasper | Illinois | 17079 | 1094 | 19 |
1018444 | 1018444 | 2021-02-11 | Jefferson | Illinois | 17081 | 3877 | 114 |
1018445 | 1018445 | 2021-02-11 | Jersey | Illinois | 17083 | 2439 | 63 |
1018446 | 1018446 | 2021-02-11 | Jo Daviess | Illinois | 17085 | 1578 | 25 |
1018447 | 1018447 | 2021-02-11 | Johnson | Illinois | 17087 | 1333 | 16 |
1018448 | 1018448 | 2021-02-11 | Kane | Illinois | 17089 | 49376 | 751 |
1018449 | 1018449 | 2021-02-11 | Kankakee | Illinois | 17091 | 12126 | 194 |
1018450 | 1018450 | 2021-02-11 | Kendall | Illinois | 17093 | 10768 | 90 |
1018451 | 1018451 | 2021-02-11 | Knox | Illinois | 17095 | 4915 | 153 |
1018452 | 1018452 | 2021-02-11 | LaSalle | Illinois | 17099 | 10390 | 265 |
1018453 | 1018453 | 2021-02-11 | Lake | Illinois | 17097 | 57637 | 964 |
1018454 | 1018454 | 2021-02-11 | Lawrence | Illinois | 17101 | 2258 | 33 |
1018455 | 1018455 | 2021-02-11 | Lee | Illinois | 17103 | 3274 | 82 |
1018456 | 1018456 | 2021-02-11 | Livingston | Illinois | 17105 | 4039 | 82 |
1018457 | 1018457 | 2021-02-11 | Logan | Illinois | 17107 | 3276 | 64 |
1018458 | 1018458 | 2021-02-11 | Macon | Illinois | 17115 | 9321 | 189 |
1018459 | 1018459 | 2021-02-11 | Macoupin | Illinois | 17117 | 4252 | 102 |
1018460 | 1018460 | 2021-02-11 | Madison | Illinois | 17119 | 27127 | 511 |
1018461 | 1018461 | 2021-02-11 | Marion | Illinois | 17121 | 4219 | 116 |
1018462 | 1018462 | 2021-02-11 | Marshall | Illinois | 17123 | 804 | 16 |
1018463 | 1018463 | 2021-02-11 | Mason | Illinois | 17125 | 1258 | 42 |
1018464 | 1018464 | 2021-02-11 | Massac | Illinois | 17127 | 1224 | 34 |
1018465 | 1018465 | 2021-02-11 | McDonough | Illinois | 17109 | 2282 | 52 |
1018466 | 1018466 | 2021-02-11 | McHenry | Illinois | 17111 | 23497 | 282 |
1018467 | 1018467 | 2021-02-11 | McLean | Illinois | 17113 | 14239 | 186 |
1018468 | 1018468 | 2021-02-11 | Menard | Illinois | 17129 | 1013 | 10 |
1018469 | 1018469 | 2021-02-11 | Mercer | Illinois | 17131 | 1247 | 31 |
1018470 | 1018470 | 2021-02-11 | Monroe | Illinois | 17133 | 3952 | 78 |
1018471 | 1018471 | 2021-02-11 | Montgomery | Illinois | 17135 | 3372 | 73 |
1018472 | 1018472 | 2021-02-11 | Morgan | Illinois | 17137 | 3542 | 96 |
1018473 | 1018473 | 2021-02-11 | Moultrie | Illinois | 17139 | 1465 | 30 |
1018474 | 1018474 | 2021-02-11 | Ogle | Illinois | 17141 | 4894 | 79 |
1018475 | 1018475 | 2021-02-11 | Peoria | Illinois | 17143 | 16402 | 265 |
1018476 | 1018476 | 2021-02-11 | Perry | Illinois | 17145 | 2973 | 65 |
1018477 | 1018477 | 2021-02-11 | Piatt | Illinois | 17147 | 1278 | 19 |
1018478 | 1018478 | 2021-02-11 | Pike | Illinois | 17149 | 1660 | 51 |
1018479 | 1018479 | 2021-02-11 | Pope | Illinois | 17151 | 277 | 3 |
1018480 | 1018480 | 2021-02-11 | Pulaski | Illinois | 17153 | 661 | 4 |
1018481 | 1018481 | 2021-02-11 | Putnam | Illinois | 17155 | 390 | 4 |
1018482 | 1018482 | 2021-02-11 | Randolph | Illinois | 17157 | 3928 | 81 |
1018483 | 1018483 | 2021-02-11 | Richland | Illinois | 17159 | 1623 | 47 |
1018484 | 1018484 | 2021-02-11 | Rock Island | Illinois | 17161 | 12743 | 321 |
1018485 | 1018485 | 2021-02-11 | Saline | Illinois | 17165 | 2236 | 59 |
1018486 | 1018486 | 2021-02-11 | Sangamon | Illinois | 17167 | 15724 | 254 |
1018487 | 1018487 | 2021-02-11 | Schuyler | Illinois | 17169 | 666 | 17 |
1018488 | 1018488 | 2021-02-11 | Scott | Illinois | 17171 | 444 | 1 |
1018489 | 1018489 | 2021-02-11 | Shelby | Illinois | 17173 | 2086 | 36 |
1018490 | 1018490 | 2021-02-11 | St. Clair | Illinois | 17163 | 27031 | 489 |
1018491 | 1018491 | 2021-02-11 | Stark | Illinois | 17175 | 521 | 22 |
1018492 | 1018492 | 2021-02-11 | Stephenson | Illinois | 17177 | 3935 | 88 |
1018493 | 1018493 | 2021-02-11 | Tazewell | Illinois | 17179 | 13114 | 267 |
1018494 | 1018494 | 2021-02-11 | Union | Illinois | 17181 | 2163 | 35 |
1018495 | 1018495 | 2021-02-11 | Unknown | Illinois | 0 | 134 | |
1018496 | 1018496 | 2021-02-11 | Vermilion | Illinois | 17183 | 8308 | 128 |
1018497 | 1018497 | 2021-02-11 | Wabash | Illinois | 17185 | 1289 | 15 |
1018498 | 1018498 | 2021-02-11 | Warren | Illinois | 17187 | 1652 | 46 |
1018499 | 1018499 | 2021-02-11 | Washington | Illinois | 17189 | 1553 | 29 |
1018500 | 1018500 | 2021-02-11 | Wayne | Illinois | 17191 | 1642 | 45 |
1018501 | 1018501 | 2021-02-11 | White | Illinois | 17193 | 1571 | 33 |
1018502 | 1018502 | 2021-02-11 | Whiteside | Illinois | 17195 | 5796 | 184 |
1018503 | 1018503 | 2021-02-11 | Will | Illinois | 17197 | 63022 | 942 |
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);