ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-04-20" 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 |
---|---|---|---|---|---|---|---|
2425274 | 2425274 | 2022-04-20 | Adams | Illinois | 17001 | 22360 | 238 |
2425275 | 2425275 | 2022-04-20 | Alexander | Illinois | 17003 | 1284 | 15 |
2425276 | 2425276 | 2022-04-20 | Bond | Illinois | 17005 | 4336 | 37 |
2425277 | 2425277 | 2022-04-20 | Boone | Illinois | 17007 | 13860 | 129 |
2425278 | 2425278 | 2022-04-20 | Brown | Illinois | 17009 | 2408 | 21 |
2425279 | 2425279 | 2022-04-20 | Bureau | Illinois | 17011 | 8368 | 140 |
2425280 | 2425280 | 2022-04-20 | Calhoun | Illinois | 17013 | 1523 | 8 |
2425281 | 2425281 | 2022-04-20 | Carroll | Illinois | 17015 | 4250 | 49 |
2425282 | 2425282 | 2022-04-20 | Cass | Illinois | 17017 | 4615 | 44 |
2425283 | 2425283 | 2022-04-20 | Champaign | Illinois | 17019 | 64315 | 295 |
2425284 | 2425284 | 2022-04-20 | Christian | Illinois | 17021 | 10247 | 129 |
2425285 | 2425285 | 2022-04-20 | Clark | Illinois | 17023 | 4853 | 60 |
2425286 | 2425286 | 2022-04-20 | Clay | Illinois | 17025 | 4738 | 73 |
2425287 | 2425287 | 2022-04-20 | Clinton | Illinois | 17027 | 11974 | 122 |
2425288 | 2425288 | 2022-04-20 | Coles | Illinois | 17029 | 15354 | 175 |
2425289 | 2425289 | 2022-04-20 | Cook | Illinois | 17031 | 1146864 | 14871 |
2425290 | 2425290 | 2022-04-20 | Crawford | Illinois | 17033 | 6200 | 61 |
2425291 | 2425291 | 2022-04-20 | Cumberland | Illinois | 17035 | 3358 | 49 |
2425292 | 2425292 | 2022-04-20 | De Witt | Illinois | 17039 | 4334 | 44 |
2425293 | 2425293 | 2022-04-20 | DeKalb | Illinois | 17037 | 23559 | 199 |
2425294 | 2425294 | 2022-04-20 | Douglas | Illinois | 17041 | 6477 | 61 |
2425295 | 2425295 | 2022-04-20 | DuPage | Illinois | 17043 | 213313 | 1791 |
2425296 | 2425296 | 2022-04-20 | Edgar | Illinois | 17045 | 5172 | 79 |
2425297 | 2425297 | 2022-04-20 | Edwards | Illinois | 17047 | 1742 | 29 |
2425298 | 2425298 | 2022-04-20 | Effingham | Illinois | 17049 | 10671 | 147 |
2425299 | 2425299 | 2022-04-20 | Fayette | Illinois | 17051 | 7100 | 104 |
2425300 | 2425300 | 2022-04-20 | Ford | Illinois | 17053 | 4431 | 73 |
2425301 | 2425301 | 2022-04-20 | Franklin | Illinois | 17055 | 12261 | 177 |
2425302 | 2425302 | 2022-04-20 | Fulton | Illinois | 17057 | 10080 | 134 |
2425303 | 2425303 | 2022-04-20 | Gallatin | Illinois | 17059 | 1407 | 18 |
2425304 | 2425304 | 2022-04-20 | Greene | Illinois | 17061 | 3613 | 58 |
2425305 | 2425305 | 2022-04-20 | Grundy | Illinois | 17063 | 12711 | 140 |
2425306 | 2425306 | 2022-04-20 | Hamilton | Illinois | 17065 | 2176 | 34 |
2425307 | 2425307 | 2022-04-20 | Hancock | Illinois | 17067 | 4382 | 58 |
2425308 | 2425308 | 2022-04-20 | Hardin | Illinois | 17069 | 1054 | 20 |
2425309 | 2425309 | 2022-04-20 | Henderson | Illinois | 17071 | 1151 | 28 |
2425310 | 2425310 | 2022-04-20 | Henry | Illinois | 17073 | 12709 | 149 |
2425311 | 2425311 | 2022-04-20 | Iroquois | Illinois | 17075 | 7197 | 117 |
2425312 | 2425312 | 2022-04-20 | Jackson | Illinois | 17077 | 15581 | 130 |
2425313 | 2425313 | 2022-04-20 | Jasper | Illinois | 17079 | 2677 | 32 |
2425314 | 2425314 | 2022-04-20 | Jefferson | Illinois | 17081 | 11104 | 176 |
2425315 | 2425315 | 2022-04-20 | Jersey | Illinois | 17083 | 6243 | 91 |
2425316 | 2425316 | 2022-04-20 | Jo Daviess | Illinois | 17085 | 4035 | 39 |
2425317 | 2425317 | 2022-04-20 | Johnson | Illinois | 17087 | 4469 | 46 |
2425318 | 2425318 | 2022-04-20 | Kane | Illinois | 17089 | 127287 | 1177 |
2425319 | 2425319 | 2022-04-20 | Kankakee | Illinois | 17091 | 28925 | 373 |
2425320 | 2425320 | 2022-04-20 | Kendall | Illinois | 17093 | 31261 | 170 |
2425321 | 2425321 | 2022-04-20 | Knox | Illinois | 17095 | 12542 | 246 |
2425322 | 2425322 | 2022-04-20 | LaSalle | Illinois | 17099 | 29064 | 439 |
2425323 | 2425323 | 2022-04-20 | Lake | Illinois | 17097 | 151736 | 1454 |
2425324 | 2425324 | 2022-04-20 | Lawrence | Illinois | 17101 | 5487 | 51 |
2425325 | 2425325 | 2022-04-20 | Lee | Illinois | 17103 | 8795 | 118 |
2425326 | 2425326 | 2022-04-20 | Livingston | Illinois | 17105 | 10752 | 148 |
2425327 | 2425327 | 2022-04-20 | Logan | Illinois | 17107 | 9546 | 100 |
2425328 | 2425328 | 2022-04-20 | Macon | Illinois | 17115 | 30601 | 354 |
2425329 | 2425329 | 2022-04-20 | Macoupin | Illinois | 17117 | 12801 | 171 |
2425330 | 2425330 | 2022-04-20 | Madison | Illinois | 17119 | 70522 | 864 |
2425331 | 2425331 | 2022-04-20 | Marion | Illinois | 17121 | 11877 | 216 |
2425332 | 2425332 | 2022-04-20 | Marshall | Illinois | 17123 | 2770 | 33 |
2425333 | 2425333 | 2022-04-20 | Mason | Illinois | 17125 | 3905 | 61 |
2425334 | 2425334 | 2022-04-20 | Massac | Illinois | 17127 | 3872 | 71 |
2425335 | 2425335 | 2022-04-20 | McDonough | Illinois | 17109 | 7208 | 104 |
2425336 | 2425336 | 2022-04-20 | McHenry | Illinois | 17111 | 76536 | 506 |
2425337 | 2425337 | 2022-04-20 | McLean | Illinois | 17113 | 50395 | 327 |
2425338 | 2425338 | 2022-04-20 | Menard | Illinois | 17129 | 3515 | 24 |
2425339 | 2425339 | 2022-04-20 | Mercer | Illinois | 17131 | 4014 | 47 |
2425340 | 2425340 | 2022-04-20 | Monroe | Illinois | 17133 | 9507 | 127 |
2425341 | 2425341 | 2022-04-20 | Montgomery | Illinois | 17135 | 9818 | 111 |
2425342 | 2425342 | 2022-04-20 | Morgan | Illinois | 17137 | 9513 | 144 |
2425343 | 2425343 | 2022-04-20 | Moultrie | Illinois | 17139 | 4073 | 52 |
2425344 | 2425344 | 2022-04-20 | Ogle | Illinois | 17141 | 14019 | 136 |
2425345 | 2425345 | 2022-04-20 | Peoria | Illinois | 17143 | 46801 | 555 |
2425346 | 2425346 | 2022-04-20 | Perry | Illinois | 17145 | 7471 | 106 |
2425347 | 2425347 | 2022-04-20 | Piatt | Illinois | 17147 | 4482 | 29 |
2425348 | 2425348 | 2022-04-20 | Pike | Illinois | 17149 | 5037 | 70 |
2425349 | 2425349 | 2022-04-20 | Pope | Illinois | 17151 | 957 | 8 |
2425350 | 2425350 | 2022-04-20 | Pulaski | Illinois | 17153 | 1724 | 19 |
2425351 | 2425351 | 2022-04-20 | Putnam | Illinois | 17155 | 1147 | 10 |
2425352 | 2425352 | 2022-04-20 | Randolph | Illinois | 17157 | 10476 | 131 |
2425353 | 2425353 | 2022-04-20 | Richland | Illinois | 17159 | 5161 | 83 |
2425354 | 2425354 | 2022-04-20 | Rock Island | Illinois | 17161 | 33237 | 520 |
2425355 | 2425355 | 2022-04-20 | Saline | Illinois | 17165 | 7882 | 111 |
2425356 | 2425356 | 2022-04-20 | Sangamon | Illinois | 17167 | 55162 | 430 |
2425357 | 2425357 | 2022-04-20 | Schuyler | Illinois | 17169 | 1958 | 29 |
2425358 | 2425358 | 2022-04-20 | Scott | Illinois | 17171 | 1259 | 11 |
2425359 | 2425359 | 2022-04-20 | Shelby | Illinois | 17173 | 6211 | 80 |
2425360 | 2425360 | 2022-04-20 | St. Clair | Illinois | 17163 | 69576 | 774 |
2425361 | 2425361 | 2022-04-20 | Stark | Illinois | 17175 | 1515 | 33 |
2425362 | 2425362 | 2022-04-20 | Stephenson | Illinois | 17177 | 11500 | 176 |
2425363 | 2425363 | 2022-04-20 | Tazewell | Illinois | 17179 | 36812 | 498 |
2425364 | 2425364 | 2022-04-20 | Union | Illinois | 17181 | 5372 | 68 |
2425365 | 2425365 | 2022-04-20 | Unknown | Illinois | 0 | 2264 | |
2425366 | 2425366 | 2022-04-20 | Vermilion | Illinois | 17183 | 27976 | 313 |
2425367 | 2425367 | 2022-04-20 | Wabash | Illinois | 17185 | 3714 | 31 |
2425368 | 2425368 | 2022-04-20 | Warren | Illinois | 17187 | 4011 | 87 |
2425369 | 2425369 | 2022-04-20 | Washington | Illinois | 17189 | 3432 | 41 |
2425370 | 2425370 | 2022-04-20 | Wayne | Illinois | 17191 | 5298 | 85 |
2425371 | 2425371 | 2022-04-20 | White | Illinois | 17193 | 4403 | 59 |
2425372 | 2425372 | 2022-04-20 | Whiteside | Illinois | 17195 | 15415 | 267 |
2425373 | 2425373 | 2022-04-20 | Will | Illinois | 17197 | 163589 | 1604 |
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);