ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-03-15" 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 |
---|---|---|---|---|---|---|---|
1122271 | 1122271 | 2021-03-15 | Adams | Illinois | 17001 | 8052 | 144 |
1122272 | 1122272 | 2021-03-15 | Alexander | Illinois | 17003 | 453 | 10 |
1122273 | 1122273 | 2021-03-15 | Bond | Illinois | 17005 | 1919 | 30 |
1122274 | 1122274 | 2021-03-15 | Boone | Illinois | 17007 | 5989 | 82 |
1122275 | 1122275 | 2021-03-15 | Brown | Illinois | 17009 | 675 | 12 |
1122276 | 1122276 | 2021-03-15 | Bureau | Illinois | 17011 | 3376 | 91 |
1122277 | 1122277 | 2021-03-15 | Calhoun | Illinois | 17013 | 485 | 5 |
1122278 | 1122278 | 2021-03-15 | Carroll | Illinois | 17015 | 1595 | 36 |
1122279 | 1122279 | 2021-03-15 | Cass | Illinois | 17017 | 1899 | 33 |
1122280 | 1122280 | 2021-03-15 | Champaign | Illinois | 17019 | 18602 | 140 |
1122281 | 1122281 | 2021-03-15 | Christian | Illinois | 17021 | 3359 | 89 |
1122282 | 1122282 | 2021-03-15 | Clark | Illinois | 17023 | 1696 | 40 |
1122283 | 1122283 | 2021-03-15 | Clay | Illinois | 17025 | 1445 | 47 |
1122284 | 1122284 | 2021-03-15 | Clinton | Illinois | 17027 | 5603 | 98 |
1122285 | 1122285 | 2021-03-15 | Coles | Illinois | 17029 | 5314 | 95 |
1122286 | 1122286 | 2021-03-15 | Cook | Illinois | 17031 | 483282 | 10077 |
1122287 | 1122287 | 2021-03-15 | Crawford | Illinois | 17033 | 2019 | 40 |
1122288 | 1122288 | 2021-03-15 | Cumberland | Illinois | 17035 | 1225 | 30 |
1122289 | 1122289 | 2021-03-15 | De Witt | Illinois | 17039 | 1293 | 29 |
1122290 | 1122290 | 2021-03-15 | DeKalb | Illinois | 17037 | 8615 | 120 |
1122291 | 1122291 | 2021-03-15 | Douglas | Illinois | 17041 | 2497 | 39 |
1122292 | 1122292 | 2021-03-15 | DuPage | Illinois | 17043 | 79010 | 1298 |
1122293 | 1122293 | 2021-03-15 | Edgar | Illinois | 17045 | 1602 | 59 |
1122294 | 1122294 | 2021-03-15 | Edwards | Illinois | 17047 | 534 | 13 |
1122295 | 1122295 | 2021-03-15 | Effingham | Illinois | 17049 | 4510 | 80 |
1122296 | 1122296 | 2021-03-15 | Fayette | Illinois | 17051 | 3069 | 57 |
1122297 | 1122297 | 2021-03-15 | Ford | Illinois | 17053 | 1621 | 54 |
1122298 | 1122298 | 2021-03-15 | Franklin | Illinois | 17055 | 4185 | 78 |
1122299 | 1122299 | 2021-03-15 | Fulton | Illinois | 17057 | 2979 | 56 |
1122300 | 1122300 | 2021-03-15 | Gallatin | Illinois | 17059 | 443 | 5 |
1122301 | 1122301 | 2021-03-15 | Greene | Illinois | 17061 | 1389 | 45 |
1122302 | 1122302 | 2021-03-15 | Grundy | Illinois | 17063 | 5282 | 70 |
1122303 | 1122303 | 2021-03-15 | Hamilton | Illinois | 17065 | 796 | 18 |
1122304 | 1122304 | 2021-03-15 | Hancock | Illinois | 17067 | 1687 | 40 |
1122305 | 1122305 | 2021-03-15 | Hardin | Illinois | 17069 | 352 | 12 |
1122306 | 1122306 | 2021-03-15 | Henderson | Illinois | 17071 | 507 | 23 |
1122307 | 1122307 | 2021-03-15 | Henry | Illinois | 17073 | 4385 | 87 |
1122308 | 1122308 | 2021-03-15 | Iroquois | Illinois | 17075 | 2802 | 65 |
1122309 | 1122309 | 2021-03-15 | Jackson | Illinois | 17077 | 4650 | 73 |
1122310 | 1122310 | 2021-03-15 | Jasper | Illinois | 17079 | 1114 | 19 |
1122311 | 1122311 | 2021-03-15 | Jefferson | Illinois | 17081 | 4014 | 119 |
1122312 | 1122312 | 2021-03-15 | Jersey | Illinois | 17083 | 2518 | 67 |
1122313 | 1122313 | 2021-03-15 | Jo Daviess | Illinois | 17085 | 1629 | 25 |
1122314 | 1122314 | 2021-03-15 | Johnson | Illinois | 17087 | 1362 | 18 |
1122315 | 1122315 | 2021-03-15 | Kane | Illinois | 17089 | 51672 | 784 |
1122316 | 1122316 | 2021-03-15 | Kankakee | Illinois | 17091 | 12742 | 199 |
1122317 | 1122317 | 2021-03-15 | Kendall | Illinois | 17093 | 11772 | 97 |
1122318 | 1122318 | 2021-03-15 | Knox | Illinois | 17095 | 5035 | 164 |
1122319 | 1122319 | 2021-03-15 | LaSalle | Illinois | 17099 | 11026 | 278 |
1122320 | 1122320 | 2021-03-15 | Lake | Illinois | 17097 | 60810 | 1014 |
1122321 | 1122321 | 2021-03-15 | Lawrence | Illinois | 17101 | 2345 | 33 |
1122322 | 1122322 | 2021-03-15 | Lee | Illinois | 17103 | 3466 | 84 |
1122323 | 1122323 | 2021-03-15 | Livingston | Illinois | 17105 | 4310 | 91 |
1122324 | 1122324 | 2021-03-15 | Logan | Illinois | 17107 | 3337 | 67 |
1122325 | 1122325 | 2021-03-15 | Macon | Illinois | 17115 | 9672 | 196 |
1122326 | 1122326 | 2021-03-15 | Macoupin | Illinois | 17117 | 4424 | 109 |
1122327 | 1122327 | 2021-03-15 | Madison | Illinois | 17119 | 28540 | 548 |
1122328 | 1122328 | 2021-03-15 | Marion | Illinois | 17121 | 4296 | 119 |
1122329 | 1122329 | 2021-03-15 | Marshall | Illinois | 17123 | 867 | 17 |
1122330 | 1122330 | 2021-03-15 | Mason | Illinois | 17125 | 1297 | 42 |
1122331 | 1122331 | 2021-03-15 | Massac | Illinois | 17127 | 1299 | 39 |
1122332 | 1122332 | 2021-03-15 | McDonough | Illinois | 17109 | 2352 | 53 |
1122333 | 1122333 | 2021-03-15 | McHenry | Illinois | 17111 | 24919 | 294 |
1122334 | 1122334 | 2021-03-15 | McLean | Illinois | 17113 | 14935 | 198 |
1122335 | 1122335 | 2021-03-15 | Menard | Illinois | 17129 | 1056 | 12 |
1122336 | 1122336 | 2021-03-15 | Mercer | Illinois | 17131 | 1297 | 33 |
1122337 | 1122337 | 2021-03-15 | Monroe | Illinois | 17133 | 4120 | 89 |
1122338 | 1122338 | 2021-03-15 | Montgomery | Illinois | 17135 | 3563 | 77 |
1122339 | 1122339 | 2021-03-15 | Morgan | Illinois | 17137 | 3713 | 100 |
1122340 | 1122340 | 2021-03-15 | Moultrie | Illinois | 17139 | 1513 | 32 |
1122341 | 1122341 | 2021-03-15 | Ogle | Illinois | 17141 | 5170 | 84 |
1122342 | 1122342 | 2021-03-15 | Peoria | Illinois | 17143 | 17386 | 286 |
1122343 | 1122343 | 2021-03-15 | Perry | Illinois | 17145 | 3091 | 68 |
1122344 | 1122344 | 2021-03-15 | Piatt | Illinois | 17147 | 1367 | 20 |
1122345 | 1122345 | 2021-03-15 | Pike | Illinois | 17149 | 1716 | 53 |
1122346 | 1122346 | 2021-03-15 | Pope | Illinois | 17151 | 289 | 3 |
1122347 | 1122347 | 2021-03-15 | Pulaski | Illinois | 17153 | 673 | 7 |
1122348 | 1122348 | 2021-03-15 | Putnam | Illinois | 17155 | 427 | 4 |
1122349 | 1122349 | 2021-03-15 | Randolph | Illinois | 17157 | 3999 | 86 |
1122350 | 1122350 | 2021-03-15 | Richland | Illinois | 17159 | 1646 | 48 |
1122351 | 1122351 | 2021-03-15 | Rock Island | Illinois | 17161 | 13342 | 333 |
1122352 | 1122352 | 2021-03-15 | Saline | Illinois | 17165 | 2369 | 65 |
1122353 | 1122353 | 2021-03-15 | Sangamon | Illinois | 17167 | 16422 | 266 |
1122354 | 1122354 | 2021-03-15 | Schuyler | Illinois | 17169 | 683 | 17 |
1122355 | 1122355 | 2021-03-15 | Scott | Illinois | 17171 | 451 | 1 |
1122356 | 1122356 | 2021-03-15 | Shelby | Illinois | 17173 | 2179 | 38 |
1122357 | 1122357 | 2021-03-15 | St. Clair | Illinois | 17163 | 28779 | 525 |
1122358 | 1122358 | 2021-03-15 | Stark | Illinois | 17175 | 546 | 23 |
1122359 | 1122359 | 2021-03-15 | Stephenson | Illinois | 17177 | 4180 | 97 |
1122360 | 1122360 | 2021-03-15 | Tazewell | Illinois | 17179 | 13878 | 276 |
1122361 | 1122361 | 2021-03-15 | Union | Illinois | 17181 | 2214 | 43 |
1122362 | 1122362 | 2021-03-15 | Unknown | Illinois | 0 | 248 | |
1122363 | 1122363 | 2021-03-15 | Vermilion | Illinois | 17183 | 8733 | 136 |
1122364 | 1122364 | 2021-03-15 | Wabash | Illinois | 17185 | 1308 | 15 |
1122365 | 1122365 | 2021-03-15 | Warren | Illinois | 17187 | 1667 | 47 |
1122366 | 1122366 | 2021-03-15 | Washington | Illinois | 17189 | 1597 | 31 |
1122367 | 1122367 | 2021-03-15 | Wayne | Illinois | 17191 | 1694 | 50 |
1122368 | 1122368 | 2021-03-15 | White | Illinois | 17193 | 1632 | 35 |
1122369 | 1122369 | 2021-03-15 | Whiteside | Illinois | 17195 | 6088 | 193 |
1122370 | 1122370 | 2021-03-15 | Will | Illinois | 17197 | 66632 | 996 |
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);