ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-03-11" 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 |
---|---|---|---|---|---|---|---|
1109285 | 1109285 | 2021-03-11 | Adams | Illinois | 17001 | 8048 | 144 |
1109286 | 1109286 | 2021-03-11 | Alexander | Illinois | 17003 | 453 | 10 |
1109287 | 1109287 | 2021-03-11 | Bond | Illinois | 17005 | 1920 | 30 |
1109288 | 1109288 | 2021-03-11 | Boone | Illinois | 17007 | 5966 | 82 |
1109289 | 1109289 | 2021-03-11 | Brown | Illinois | 17009 | 672 | 12 |
1109290 | 1109290 | 2021-03-11 | Bureau | Illinois | 17011 | 3364 | 91 |
1109291 | 1109291 | 2021-03-11 | Calhoun | Illinois | 17013 | 484 | 5 |
1109292 | 1109292 | 2021-03-11 | Carroll | Illinois | 17015 | 1586 | 36 |
1109293 | 1109293 | 2021-03-11 | Cass | Illinois | 17017 | 1898 | 32 |
1109294 | 1109294 | 2021-03-11 | Champaign | Illinois | 17019 | 18494 | 139 |
1109295 | 1109295 | 2021-03-11 | Christian | Illinois | 17021 | 3353 | 89 |
1109296 | 1109296 | 2021-03-11 | Clark | Illinois | 17023 | 1692 | 39 |
1109297 | 1109297 | 2021-03-11 | Clay | Illinois | 17025 | 1443 | 47 |
1109298 | 1109298 | 2021-03-11 | Clinton | Illinois | 17027 | 5598 | 98 |
1109299 | 1109299 | 2021-03-11 | Coles | Illinois | 17029 | 5281 | 95 |
1109300 | 1109300 | 2021-03-11 | Cook | Illinois | 17031 | 481101 | 10049 |
1109301 | 1109301 | 2021-03-11 | Crawford | Illinois | 17033 | 2016 | 40 |
1109302 | 1109302 | 2021-03-11 | Cumberland | Illinois | 17035 | 1218 | 30 |
1109303 | 1109303 | 2021-03-11 | De Witt | Illinois | 17039 | 1291 | 29 |
1109304 | 1109304 | 2021-03-11 | DeKalb | Illinois | 17037 | 8586 | 120 |
1109305 | 1109305 | 2021-03-11 | Douglas | Illinois | 17041 | 2489 | 39 |
1109306 | 1109306 | 2021-03-11 | DuPage | Illinois | 17043 | 78341 | 1293 |
1109307 | 1109307 | 2021-03-11 | Edgar | Illinois | 17045 | 1580 | 59 |
1109308 | 1109308 | 2021-03-11 | Edwards | Illinois | 17047 | 532 | 12 |
1109309 | 1109309 | 2021-03-11 | Effingham | Illinois | 17049 | 4507 | 80 |
1109310 | 1109310 | 2021-03-11 | Fayette | Illinois | 17051 | 3069 | 57 |
1109311 | 1109311 | 2021-03-11 | Ford | Illinois | 17053 | 1616 | 54 |
1109312 | 1109312 | 2021-03-11 | Franklin | Illinois | 17055 | 4177 | 78 |
1109313 | 1109313 | 2021-03-11 | Fulton | Illinois | 17057 | 2948 | 54 |
1109314 | 1109314 | 2021-03-11 | Gallatin | Illinois | 17059 | 443 | 5 |
1109315 | 1109315 | 2021-03-11 | Greene | Illinois | 17061 | 1390 | 45 |
1109316 | 1109316 | 2021-03-11 | Grundy | Illinois | 17063 | 5257 | 69 |
1109317 | 1109317 | 2021-03-11 | Hamilton | Illinois | 17065 | 797 | 18 |
1109318 | 1109318 | 2021-03-11 | Hancock | Illinois | 17067 | 1686 | 40 |
1109319 | 1109319 | 2021-03-11 | Hardin | Illinois | 17069 | 350 | 12 |
1109320 | 1109320 | 2021-03-11 | Henderson | Illinois | 17071 | 505 | 23 |
1109321 | 1109321 | 2021-03-11 | Henry | Illinois | 17073 | 4378 | 87 |
1109322 | 1109322 | 2021-03-11 | Iroquois | Illinois | 17075 | 2799 | 64 |
1109323 | 1109323 | 2021-03-11 | Jackson | Illinois | 17077 | 4639 | 72 |
1109324 | 1109324 | 2021-03-11 | Jasper | Illinois | 17079 | 1114 | 19 |
1109325 | 1109325 | 2021-03-11 | Jefferson | Illinois | 17081 | 4012 | 119 |
1109326 | 1109326 | 2021-03-11 | Jersey | Illinois | 17083 | 2509 | 66 |
1109327 | 1109327 | 2021-03-11 | Jo Daviess | Illinois | 17085 | 1621 | 25 |
1109328 | 1109328 | 2021-03-11 | Johnson | Illinois | 17087 | 1357 | 18 |
1109329 | 1109329 | 2021-03-11 | Kane | Illinois | 17089 | 51479 | 779 |
1109330 | 1109330 | 2021-03-11 | Kankakee | Illinois | 17091 | 12686 | 198 |
1109331 | 1109331 | 2021-03-11 | Kendall | Illinois | 17093 | 11747 | 97 |
1109332 | 1109332 | 2021-03-11 | Knox | Illinois | 17095 | 5029 | 164 |
1109333 | 1109333 | 2021-03-11 | LaSalle | Illinois | 17099 | 10990 | 278 |
1109334 | 1109334 | 2021-03-11 | Lake | Illinois | 17097 | 60481 | 1011 |
1109335 | 1109335 | 2021-03-11 | Lawrence | Illinois | 17101 | 2328 | 33 |
1109336 | 1109336 | 2021-03-11 | Lee | Illinois | 17103 | 3427 | 82 |
1109337 | 1109337 | 2021-03-11 | Livingston | Illinois | 17105 | 4287 | 91 |
1109338 | 1109338 | 2021-03-11 | Logan | Illinois | 17107 | 3320 | 67 |
1109339 | 1109339 | 2021-03-11 | Macon | Illinois | 17115 | 9633 | 196 |
1109340 | 1109340 | 2021-03-11 | Macoupin | Illinois | 17117 | 4410 | 109 |
1109341 | 1109341 | 2021-03-11 | Madison | Illinois | 17119 | 28418 | 541 |
1109342 | 1109342 | 2021-03-11 | Marion | Illinois | 17121 | 4290 | 119 |
1109343 | 1109343 | 2021-03-11 | Marshall | Illinois | 17123 | 860 | 17 |
1109344 | 1109344 | 2021-03-11 | Mason | Illinois | 17125 | 1294 | 42 |
1109345 | 1109345 | 2021-03-11 | Massac | Illinois | 17127 | 1299 | 38 |
1109346 | 1109346 | 2021-03-11 | McDonough | Illinois | 17109 | 2345 | 52 |
1109347 | 1109347 | 2021-03-11 | McHenry | Illinois | 17111 | 24806 | 293 |
1109348 | 1109348 | 2021-03-11 | McLean | Illinois | 17113 | 14842 | 197 |
1109349 | 1109349 | 2021-03-11 | Menard | Illinois | 17129 | 1052 | 12 |
1109350 | 1109350 | 2021-03-11 | Mercer | Illinois | 17131 | 1295 | 33 |
1109351 | 1109351 | 2021-03-11 | Monroe | Illinois | 17133 | 4105 | 89 |
1109352 | 1109352 | 2021-03-11 | Montgomery | Illinois | 17135 | 3553 | 77 |
1109353 | 1109353 | 2021-03-11 | Morgan | Illinois | 17137 | 3708 | 99 |
1109354 | 1109354 | 2021-03-11 | Moultrie | Illinois | 17139 | 1511 | 32 |
1109355 | 1109355 | 2021-03-11 | Ogle | Illinois | 17141 | 5129 | 84 |
1109356 | 1109356 | 2021-03-11 | Peoria | Illinois | 17143 | 17252 | 285 |
1109357 | 1109357 | 2021-03-11 | Perry | Illinois | 17145 | 3085 | 68 |
1109358 | 1109358 | 2021-03-11 | Piatt | Illinois | 17147 | 1357 | 20 |
1109359 | 1109359 | 2021-03-11 | Pike | Illinois | 17149 | 1710 | 53 |
1109360 | 1109360 | 2021-03-11 | Pope | Illinois | 17151 | 288 | 3 |
1109361 | 1109361 | 2021-03-11 | Pulaski | Illinois | 17153 | 672 | 6 |
1109362 | 1109362 | 2021-03-11 | Putnam | Illinois | 17155 | 426 | 4 |
1109363 | 1109363 | 2021-03-11 | Randolph | Illinois | 17157 | 3992 | 86 |
1109364 | 1109364 | 2021-03-11 | Richland | Illinois | 17159 | 1642 | 47 |
1109365 | 1109365 | 2021-03-11 | Rock Island | Illinois | 17161 | 13271 | 332 |
1109366 | 1109366 | 2021-03-11 | Saline | Illinois | 17165 | 2356 | 64 |
1109367 | 1109367 | 2021-03-11 | Sangamon | Illinois | 17167 | 16335 | 264 |
1109368 | 1109368 | 2021-03-11 | Schuyler | Illinois | 17169 | 683 | 17 |
1109369 | 1109369 | 2021-03-11 | Scott | Illinois | 17171 | 451 | 1 |
1109370 | 1109370 | 2021-03-11 | Shelby | Illinois | 17173 | 2173 | 37 |
1109371 | 1109371 | 2021-03-11 | St. Clair | Illinois | 17163 | 28606 | 523 |
1109372 | 1109372 | 2021-03-11 | Stark | Illinois | 17175 | 546 | 23 |
1109373 | 1109373 | 2021-03-11 | Stephenson | Illinois | 17177 | 4144 | 96 |
1109374 | 1109374 | 2021-03-11 | Tazewell | Illinois | 17179 | 13777 | 276 |
1109375 | 1109375 | 2021-03-11 | Union | Illinois | 17181 | 2212 | 43 |
1109376 | 1109376 | 2021-03-11 | Unknown | Illinois | 0 | 245 | |
1109377 | 1109377 | 2021-03-11 | Vermilion | Illinois | 17183 | 8691 | 136 |
1109378 | 1109378 | 2021-03-11 | Wabash | Illinois | 17185 | 1306 | 15 |
1109379 | 1109379 | 2021-03-11 | Warren | Illinois | 17187 | 1666 | 47 |
1109380 | 1109380 | 2021-03-11 | Washington | Illinois | 17189 | 1593 | 30 |
1109381 | 1109381 | 2021-03-11 | Wayne | Illinois | 17191 | 1695 | 50 |
1109382 | 1109382 | 2021-03-11 | White | Illinois | 17193 | 1629 | 35 |
1109383 | 1109383 | 2021-03-11 | Whiteside | Illinois | 17195 | 6047 | 192 |
1109384 | 1109384 | 2021-03-11 | Will | Illinois | 17197 | 66329 | 989 |
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);