ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-03-07" 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 |
---|---|---|---|---|---|---|---|
1096299 | 1096299 | 2021-03-07 | Adams | Illinois | 17001 | 8046 | 143 |
1096300 | 1096300 | 2021-03-07 | Alexander | Illinois | 17003 | 453 | 9 |
1096301 | 1096301 | 2021-03-07 | Bond | Illinois | 17005 | 1918 | 30 |
1096302 | 1096302 | 2021-03-07 | Boone | Illinois | 17007 | 5945 | 82 |
1096303 | 1096303 | 2021-03-07 | Brown | Illinois | 17009 | 666 | 12 |
1096304 | 1096304 | 2021-03-07 | Bureau | Illinois | 17011 | 3335 | 90 |
1096305 | 1096305 | 2021-03-07 | Calhoun | Illinois | 17013 | 482 | 5 |
1096306 | 1096306 | 2021-03-07 | Carroll | Illinois | 17015 | 1582 | 36 |
1096307 | 1096307 | 2021-03-07 | Cass | Illinois | 17017 | 1898 | 31 |
1096308 | 1096308 | 2021-03-07 | Champaign | Illinois | 17019 | 18404 | 136 |
1096309 | 1096309 | 2021-03-07 | Christian | Illinois | 17021 | 3336 | 87 |
1096310 | 1096310 | 2021-03-07 | Clark | Illinois | 17023 | 1688 | 39 |
1096311 | 1096311 | 2021-03-07 | Clay | Illinois | 17025 | 1436 | 47 |
1096312 | 1096312 | 2021-03-07 | Clinton | Illinois | 17027 | 5583 | 98 |
1096313 | 1096313 | 2021-03-07 | Coles | Illinois | 17029 | 5251 | 94 |
1096314 | 1096314 | 2021-03-07 | Cook | Illinois | 17031 | 478884 | 10008 |
1096315 | 1096315 | 2021-03-07 | Crawford | Illinois | 17033 | 2013 | 40 |
1096316 | 1096316 | 2021-03-07 | Cumberland | Illinois | 17035 | 1204 | 30 |
1096317 | 1096317 | 2021-03-07 | De Witt | Illinois | 17039 | 1284 | 29 |
1096318 | 1096318 | 2021-03-07 | DeKalb | Illinois | 17037 | 8520 | 120 |
1096319 | 1096319 | 2021-03-07 | Douglas | Illinois | 17041 | 2477 | 39 |
1096320 | 1096320 | 2021-03-07 | DuPage | Illinois | 17043 | 77882 | 1290 |
1096321 | 1096321 | 2021-03-07 | Edgar | Illinois | 17045 | 1556 | 58 |
1096322 | 1096322 | 2021-03-07 | Edwards | Illinois | 17047 | 528 | 11 |
1096323 | 1096323 | 2021-03-07 | Effingham | Illinois | 17049 | 4508 | 80 |
1096324 | 1096324 | 2021-03-07 | Fayette | Illinois | 17051 | 3071 | 55 |
1096325 | 1096325 | 2021-03-07 | Ford | Illinois | 17053 | 1604 | 54 |
1096326 | 1096326 | 2021-03-07 | Franklin | Illinois | 17055 | 4167 | 78 |
1096327 | 1096327 | 2021-03-07 | Fulton | Illinois | 17057 | 2903 | 54 |
1096328 | 1096328 | 2021-03-07 | Gallatin | Illinois | 17059 | 438 | 5 |
1096329 | 1096329 | 2021-03-07 | Greene | Illinois | 17061 | 1387 | 45 |
1096330 | 1096330 | 2021-03-07 | Grundy | Illinois | 17063 | 5209 | 67 |
1096331 | 1096331 | 2021-03-07 | Hamilton | Illinois | 17065 | 796 | 18 |
1096332 | 1096332 | 2021-03-07 | Hancock | Illinois | 17067 | 1685 | 40 |
1096333 | 1096333 | 2021-03-07 | Hardin | Illinois | 17069 | 348 | 12 |
1096334 | 1096334 | 2021-03-07 | Henderson | Illinois | 17071 | 504 | 23 |
1096335 | 1096335 | 2021-03-07 | Henry | Illinois | 17073 | 4360 | 87 |
1096336 | 1096336 | 2021-03-07 | Iroquois | Illinois | 17075 | 2789 | 64 |
1096337 | 1096337 | 2021-03-07 | Jackson | Illinois | 17077 | 4623 | 71 |
1096338 | 1096338 | 2021-03-07 | Jasper | Illinois | 17079 | 1113 | 19 |
1096339 | 1096339 | 2021-03-07 | Jefferson | Illinois | 17081 | 3998 | 118 |
1096340 | 1096340 | 2021-03-07 | Jersey | Illinois | 17083 | 2499 | 66 |
1096341 | 1096341 | 2021-03-07 | Jo Daviess | Illinois | 17085 | 1616 | 25 |
1096342 | 1096342 | 2021-03-07 | Johnson | Illinois | 17087 | 1355 | 18 |
1096343 | 1096343 | 2021-03-07 | Kane | Illinois | 17089 | 51237 | 775 |
1096344 | 1096344 | 2021-03-07 | Kankakee | Illinois | 17091 | 12605 | 198 |
1096345 | 1096345 | 2021-03-07 | Kendall | Illinois | 17093 | 11509 | 96 |
1096346 | 1096346 | 2021-03-07 | Knox | Illinois | 17095 | 5026 | 164 |
1096347 | 1096347 | 2021-03-07 | LaSalle | Illinois | 17099 | 10924 | 277 |
1096348 | 1096348 | 2021-03-07 | Lake | Illinois | 17097 | 60155 | 1005 |
1096349 | 1096349 | 2021-03-07 | Lawrence | Illinois | 17101 | 2319 | 33 |
1096350 | 1096350 | 2021-03-07 | Lee | Illinois | 17103 | 3383 | 82 |
1096351 | 1096351 | 2021-03-07 | Livingston | Illinois | 17105 | 4269 | 91 |
1096352 | 1096352 | 2021-03-07 | Logan | Illinois | 17107 | 3315 | 67 |
1096353 | 1096353 | 2021-03-07 | Macon | Illinois | 17115 | 9531 | 196 |
1096354 | 1096354 | 2021-03-07 | Macoupin | Illinois | 17117 | 4385 | 109 |
1096355 | 1096355 | 2021-03-07 | Madison | Illinois | 17119 | 28259 | 539 |
1096356 | 1096356 | 2021-03-07 | Marion | Illinois | 17121 | 4280 | 119 |
1096357 | 1096357 | 2021-03-07 | Marshall | Illinois | 17123 | 851 | 17 |
1096358 | 1096358 | 2021-03-07 | Mason | Illinois | 17125 | 1290 | 42 |
1096359 | 1096359 | 2021-03-07 | Massac | Illinois | 17127 | 1285 | 38 |
1096360 | 1096360 | 2021-03-07 | McDonough | Illinois | 17109 | 2340 | 52 |
1096361 | 1096361 | 2021-03-07 | McHenry | Illinois | 17111 | 24669 | 292 |
1096362 | 1096362 | 2021-03-07 | McLean | Illinois | 17113 | 14738 | 196 |
1096363 | 1096363 | 2021-03-07 | Menard | Illinois | 17129 | 1044 | 12 |
1096364 | 1096364 | 2021-03-07 | Mercer | Illinois | 17131 | 1289 | 33 |
1096365 | 1096365 | 2021-03-07 | Monroe | Illinois | 17133 | 4092 | 87 |
1096366 | 1096366 | 2021-03-07 | Montgomery | Illinois | 17135 | 3543 | 76 |
1096367 | 1096367 | 2021-03-07 | Morgan | Illinois | 17137 | 3684 | 99 |
1096368 | 1096368 | 2021-03-07 | Moultrie | Illinois | 17139 | 1503 | 32 |
1096369 | 1096369 | 2021-03-07 | Ogle | Illinois | 17141 | 5075 | 83 |
1096370 | 1096370 | 2021-03-07 | Peoria | Illinois | 17143 | 17144 | 285 |
1096371 | 1096371 | 2021-03-07 | Perry | Illinois | 17145 | 3074 | 66 |
1096372 | 1096372 | 2021-03-07 | Piatt | Illinois | 17147 | 1343 | 20 |
1096373 | 1096373 | 2021-03-07 | Pike | Illinois | 17149 | 1701 | 53 |
1096374 | 1096374 | 2021-03-07 | Pope | Illinois | 17151 | 284 | 3 |
1096375 | 1096375 | 2021-03-07 | Pulaski | Illinois | 17153 | 671 | 6 |
1096376 | 1096376 | 2021-03-07 | Putnam | Illinois | 17155 | 422 | 4 |
1096377 | 1096377 | 2021-03-07 | Randolph | Illinois | 17157 | 3985 | 86 |
1096378 | 1096378 | 2021-03-07 | Richland | Illinois | 17159 | 1637 | 47 |
1096379 | 1096379 | 2021-03-07 | Rock Island | Illinois | 17161 | 13203 | 330 |
1096380 | 1096380 | 2021-03-07 | Saline | Illinois | 17165 | 2339 | 64 |
1096381 | 1096381 | 2021-03-07 | Sangamon | Illinois | 17167 | 16285 | 264 |
1096382 | 1096382 | 2021-03-07 | Schuyler | Illinois | 17169 | 682 | 17 |
1096383 | 1096383 | 2021-03-07 | Scott | Illinois | 17171 | 449 | 1 |
1096384 | 1096384 | 2021-03-07 | Shelby | Illinois | 17173 | 2163 | 37 |
1096385 | 1096385 | 2021-03-07 | St. Clair | Illinois | 17163 | 28389 | 515 |
1096386 | 1096386 | 2021-03-07 | Stark | Illinois | 17175 | 543 | 23 |
1096387 | 1096387 | 2021-03-07 | Stephenson | Illinois | 17177 | 4122 | 95 |
1096388 | 1096388 | 2021-03-07 | Tazewell | Illinois | 17179 | 13677 | 275 |
1096389 | 1096389 | 2021-03-07 | Union | Illinois | 17181 | 2207 | 42 |
1096390 | 1096390 | 2021-03-07 | Unknown | Illinois | 0 | 237 | |
1096391 | 1096391 | 2021-03-07 | Vermilion | Illinois | 17183 | 8646 | 136 |
1096392 | 1096392 | 2021-03-07 | Wabash | Illinois | 17185 | 1305 | 15 |
1096393 | 1096393 | 2021-03-07 | Warren | Illinois | 17187 | 1666 | 47 |
1096394 | 1096394 | 2021-03-07 | Washington | Illinois | 17189 | 1588 | 30 |
1096395 | 1096395 | 2021-03-07 | Wayne | Illinois | 17191 | 1692 | 50 |
1096396 | 1096396 | 2021-03-07 | White | Illinois | 17193 | 1614 | 35 |
1096397 | 1096397 | 2021-03-07 | Whiteside | Illinois | 17195 | 6022 | 192 |
1096398 | 1096398 | 2021-03-07 | Will | Illinois | 17197 | 65885 | 986 |
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);