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 2022-04-09 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2389461 | 2389461 | 2022-04-09 | Adams | Illinois | 17001 | 22297 | 238 |
2389462 | 2389462 | 2022-04-09 | Alexander | Illinois | 17003 | 1281 | 15 |
2389463 | 2389463 | 2022-04-09 | Bond | Illinois | 17005 | 4324 | 37 |
2389464 | 2389464 | 2022-04-09 | Boone | Illinois | 17007 | 13814 | 129 |
2389465 | 2389465 | 2022-04-09 | Brown | Illinois | 17009 | 2408 | 21 |
2389466 | 2389466 | 2022-04-09 | Bureau | Illinois | 17011 | 8341 | 140 |
2389467 | 2389467 | 2022-04-09 | Calhoun | Illinois | 17013 | 1521 | 8 |
2389468 | 2389468 | 2022-04-09 | Carroll | Illinois | 17015 | 4244 | 49 |
2389469 | 2389469 | 2022-04-09 | Cass | Illinois | 17017 | 4608 | 44 |
2389470 | 2389470 | 2022-04-09 | Champaign | Illinois | 17019 | 62825 | 295 |
2389471 | 2389471 | 2022-04-09 | Christian | Illinois | 17021 | 10221 | 129 |
2389472 | 2389472 | 2022-04-09 | Clark | Illinois | 17023 | 4850 | 60 |
2389473 | 2389473 | 2022-04-09 | Clay | Illinois | 17025 | 4733 | 73 |
2389474 | 2389474 | 2022-04-09 | Clinton | Illinois | 17027 | 11965 | 122 |
2389475 | 2389475 | 2022-04-09 | Coles | Illinois | 17029 | 15287 | 173 |
2389476 | 2389476 | 2022-04-09 | Cook | Illinois | 17031 | 1134146 | 14837 |
2389477 | 2389477 | 2022-04-09 | Crawford | Illinois | 17033 | 6194 | 61 |
2389478 | 2389478 | 2022-04-09 | Cumberland | Illinois | 17035 | 3348 | 49 |
2389479 | 2389479 | 2022-04-09 | De Witt | Illinois | 17039 | 4323 | 44 |
2389480 | 2389480 | 2022-04-09 | DeKalb | Illinois | 17037 | 23371 | 199 |
2389481 | 2389481 | 2022-04-09 | Douglas | Illinois | 17041 | 6459 | 61 |
2389482 | 2389482 | 2022-04-09 | DuPage | Illinois | 17043 | 210607 | 1786 |
2389483 | 2389483 | 2022-04-09 | Edgar | Illinois | 17045 | 5162 | 79 |
2389484 | 2389484 | 2022-04-09 | Edwards | Illinois | 17047 | 1744 | 29 |
2389485 | 2389485 | 2022-04-09 | Effingham | Illinois | 17049 | 10655 | 146 |
2389486 | 2389486 | 2022-04-09 | Fayette | Illinois | 17051 | 7087 | 104 |
2389487 | 2389487 | 2022-04-09 | Ford | Illinois | 17053 | 4402 | 73 |
2389488 | 2389488 | 2022-04-09 | Franklin | Illinois | 17055 | 12271 | 177 |
2389489 | 2389489 | 2022-04-09 | Fulton | Illinois | 17057 | 10055 | 134 |
2389490 | 2389490 | 2022-04-09 | Gallatin | Illinois | 17059 | 1407 | 18 |
2389491 | 2389491 | 2022-04-09 | Greene | Illinois | 17061 | 3594 | 58 |
2389492 | 2389492 | 2022-04-09 | Grundy | Illinois | 17063 | 12640 | 140 |
2389493 | 2389493 | 2022-04-09 | Hamilton | Illinois | 17065 | 2178 | 34 |
2389494 | 2389494 | 2022-04-09 | Hancock | Illinois | 17067 | 4379 | 58 |
2389495 | 2389495 | 2022-04-09 | Hardin | Illinois | 17069 | 1053 | 20 |
2389496 | 2389496 | 2022-04-09 | Henderson | Illinois | 17071 | 1148 | 27 |
2389497 | 2389497 | 2022-04-09 | Henry | Illinois | 17073 | 12655 | 149 |
2389498 | 2389498 | 2022-04-09 | Iroquois | Illinois | 17075 | 7173 | 116 |
2389499 | 2389499 | 2022-04-09 | Jackson | Illinois | 17077 | 15546 | 130 |
2389500 | 2389500 | 2022-04-09 | Jasper | Illinois | 17079 | 2674 | 32 |
2389501 | 2389501 | 2022-04-09 | Jefferson | Illinois | 17081 | 11097 | 176 |
2389502 | 2389502 | 2022-04-09 | Jersey | Illinois | 17083 | 6221 | 91 |
2389503 | 2389503 | 2022-04-09 | Jo Daviess | Illinois | 17085 | 4031 | 39 |
2389504 | 2389504 | 2022-04-09 | Johnson | Illinois | 17087 | 4467 | 46 |
2389505 | 2389505 | 2022-04-09 | Kane | Illinois | 17089 | 126267 | 1174 |
2389506 | 2389506 | 2022-04-09 | Kankakee | Illinois | 17091 | 28827 | 373 |
2389507 | 2389507 | 2022-04-09 | Kendall | Illinois | 17093 | 31010 | 170 |
2389508 | 2389508 | 2022-04-09 | Knox | Illinois | 17095 | 12520 | 245 |
2389509 | 2389509 | 2022-04-09 | LaSalle | Illinois | 17099 | 28931 | 438 |
2389510 | 2389510 | 2022-04-09 | Lake | Illinois | 17097 | 149935 | 1447 |
2389511 | 2389511 | 2022-04-09 | Lawrence | Illinois | 17101 | 5484 | 51 |
2389512 | 2389512 | 2022-04-09 | Lee | Illinois | 17103 | 8771 | 118 |
2389513 | 2389513 | 2022-04-09 | Livingston | Illinois | 17105 | 10707 | 148 |
2389514 | 2389514 | 2022-04-09 | Logan | Illinois | 17107 | 9500 | 100 |
2389515 | 2389515 | 2022-04-09 | Macon | Illinois | 17115 | 30447 | 353 |
2389516 | 2389516 | 2022-04-09 | Macoupin | Illinois | 17117 | 12771 | 171 |
2389517 | 2389517 | 2022-04-09 | Madison | Illinois | 17119 | 70321 | 861 |
2389518 | 2389518 | 2022-04-09 | Marion | Illinois | 17121 | 11858 | 216 |
2389519 | 2389519 | 2022-04-09 | Marshall | Illinois | 17123 | 2764 | 33 |
2389520 | 2389520 | 2022-04-09 | Mason | Illinois | 17125 | 3894 | 61 |
2389521 | 2389521 | 2022-04-09 | Massac | Illinois | 17127 | 3870 | 71 |
2389522 | 2389522 | 2022-04-09 | McDonough | Illinois | 17109 | 7180 | 103 |
2389523 | 2389523 | 2022-04-09 | McHenry | Illinois | 17111 | 75957 | 506 |
2389524 | 2389524 | 2022-04-09 | McLean | Illinois | 17113 | 49801 | 326 |
2389525 | 2389525 | 2022-04-09 | Menard | Illinois | 17129 | 3496 | 24 |
2389526 | 2389526 | 2022-04-09 | Mercer | Illinois | 17131 | 4006 | 47 |
2389527 | 2389527 | 2022-04-09 | Monroe | Illinois | 17133 | 9486 | 127 |
2389528 | 2389528 | 2022-04-09 | Montgomery | Illinois | 17135 | 9793 | 111 |
2389529 | 2389529 | 2022-04-09 | Morgan | Illinois | 17137 | 9494 | 144 |
2389530 | 2389530 | 2022-04-09 | Moultrie | Illinois | 17139 | 4065 | 52 |
2389531 | 2389531 | 2022-04-09 | Ogle | Illinois | 17141 | 13981 | 136 |
2389532 | 2389532 | 2022-04-09 | Peoria | Illinois | 17143 | 46508 | 555 |
2389533 | 2389533 | 2022-04-09 | Perry | Illinois | 17145 | 7464 | 106 |
2389534 | 2389534 | 2022-04-09 | Piatt | Illinois | 17147 | 4406 | 29 |
2389535 | 2389535 | 2022-04-09 | Pike | Illinois | 17149 | 5030 | 69 |
2389536 | 2389536 | 2022-04-09 | Pope | Illinois | 17151 | 955 | 8 |
2389537 | 2389537 | 2022-04-09 | Pulaski | Illinois | 17153 | 1720 | 19 |
2389538 | 2389538 | 2022-04-09 | Putnam | Illinois | 17155 | 1135 | 10 |
2389539 | 2389539 | 2022-04-09 | Randolph | Illinois | 17157 | 10464 | 131 |
2389540 | 2389540 | 2022-04-09 | Richland | Illinois | 17159 | 5158 | 83 |
2389541 | 2389541 | 2022-04-09 | Rock Island | Illinois | 17161 | 33099 | 519 |
2389542 | 2389542 | 2022-04-09 | Saline | Illinois | 17165 | 7865 | 109 |
2389543 | 2389543 | 2022-04-09 | Sangamon | Illinois | 17167 | 54881 | 427 |
2389544 | 2389544 | 2022-04-09 | Schuyler | Illinois | 17169 | 1955 | 29 |
2389545 | 2389545 | 2022-04-09 | Scott | Illinois | 17171 | 1256 | 11 |
2389546 | 2389546 | 2022-04-09 | Shelby | Illinois | 17173 | 6200 | 79 |
2389547 | 2389547 | 2022-04-09 | St. Clair | Illinois | 17163 | 69335 | 770 |
2389548 | 2389548 | 2022-04-09 | Stark | Illinois | 17175 | 1511 | 32 |
2389549 | 2389549 | 2022-04-09 | Stephenson | Illinois | 17177 | 11478 | 176 |
2389550 | 2389550 | 2022-04-09 | Tazewell | Illinois | 17179 | 36624 | 496 |
2389551 | 2389551 | 2022-04-09 | Union | Illinois | 17181 | 5369 | 68 |
2389552 | 2389552 | 2022-04-09 | Unknown | Illinois | 0 | 2269 | |
2389553 | 2389553 | 2022-04-09 | Vermilion | Illinois | 17183 | 27891 | 311 |
2389554 | 2389554 | 2022-04-09 | Wabash | Illinois | 17185 | 3714 | 31 |
2389555 | 2389555 | 2022-04-09 | Warren | Illinois | 17187 | 3999 | 87 |
2389556 | 2389556 | 2022-04-09 | Washington | Illinois | 17189 | 3427 | 41 |
2389557 | 2389557 | 2022-04-09 | Wayne | Illinois | 17191 | 5289 | 85 |
2389558 | 2389558 | 2022-04-09 | White | Illinois | 17193 | 4405 | 59 |
2389559 | 2389559 | 2022-04-09 | Whiteside | Illinois | 17195 | 15353 | 267 |
2389560 | 2389560 | 2022-04-09 | Will | Illinois | 17197 | 162230 | 1602 |
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);