ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-12-19 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adair 1
- Adams 1
- Allamakee 1
- Appanoose 1
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Bremer 1
- Buchanan 1
- Buena Vista 1
- Butler 1
- Calhoun 1
- Carroll 1
- Cass 1
- Cedar 1
- Cerro Gordo 1
- Cherokee 1
- Chickasaw 1
- Clarke 1
- Clay 1
- Clayton 1
- Clinton 1
- Crawford 1
- Dallas 1
- Davis 1
- Decatur 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- …
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
843346 | 843346 | 2020-12-19 | Adair | Iowa | 19001 | 544 | 17 |
843347 | 843347 | 2020-12-19 | Adams | Iowa | 19003 | 229 | 2 |
843348 | 843348 | 2020-12-19 | Allamakee | Iowa | 19005 | 1087 | 18 |
843349 | 843349 | 2020-12-19 | Appanoose | Iowa | 19007 | 914 | 34 |
843350 | 843350 | 2020-12-19 | Audubon | Iowa | 19009 | 343 | 7 |
843351 | 843351 | 2020-12-19 | Benton | Iowa | 19011 | 1924 | 34 |
843352 | 843352 | 2020-12-19 | Black Hawk | Iowa | 19013 | 12209 | 204 |
843353 | 843353 | 2020-12-19 | Boone | Iowa | 19015 | 1721 | 15 |
843354 | 843354 | 2020-12-19 | Bremer | Iowa | 19017 | 2178 | 40 |
843355 | 843355 | 2020-12-19 | Buchanan | Iowa | 19019 | 1370 | 15 |
843356 | 843356 | 2020-12-19 | Buena Vista | Iowa | 19021 | 3535 | 22 |
843357 | 843357 | 2020-12-19 | Butler | Iowa | 19023 | 1187 | 16 |
843358 | 843358 | 2020-12-19 | Calhoun | Iowa | 19025 | 1157 | 9 |
843359 | 843359 | 2020-12-19 | Carroll | Iowa | 19027 | 2254 | 27 |
843360 | 843360 | 2020-12-19 | Cass | Iowa | 19029 | 982 | 38 |
843361 | 843361 | 2020-12-19 | Cedar | Iowa | 19031 | 1307 | 17 |
843362 | 843362 | 2020-12-19 | Cerro Gordo | Iowa | 19033 | 4146 | 55 |
843363 | 843363 | 2020-12-19 | Cherokee | Iowa | 19035 | 1144 | 18 |
843364 | 843364 | 2020-12-19 | Chickasaw | Iowa | 19037 | 992 | 10 |
843365 | 843365 | 2020-12-19 | Clarke | Iowa | 19039 | 590 | 6 |
843366 | 843366 | 2020-12-19 | Clay | Iowa | 19041 | 1484 | 10 |
843367 | 843367 | 2020-12-19 | Clayton | Iowa | 19043 | 1298 | 31 |
843368 | 843368 | 2020-12-19 | Clinton | Iowa | 19045 | 3933 | 52 |
843369 | 843369 | 2020-12-19 | Crawford | Iowa | 19047 | 2007 | 17 |
843370 | 843370 | 2020-12-19 | Dallas | Iowa | 19049 | 7477 | 61 |
843371 | 843371 | 2020-12-19 | Davis | Iowa | 19051 | 604 | 18 |
843372 | 843372 | 2020-12-19 | Decatur | Iowa | 19053 | 393 | 3 |
843373 | 843373 | 2020-12-19 | Delaware | Iowa | 19055 | 1581 | 28 |
843374 | 843374 | 2020-12-19 | Des Moines | Iowa | 19057 | 3362 | 30 |
843375 | 843375 | 2020-12-19 | Dickinson | Iowa | 19059 | 1638 | 13 |
843376 | 843376 | 2020-12-19 | Dubuque | Iowa | 19061 | 10233 | 131 |
843377 | 843377 | 2020-12-19 | Emmet | Iowa | 19063 | 937 | 23 |
843378 | 843378 | 2020-12-19 | Fayette | Iowa | 19065 | 1241 | 15 |
843379 | 843379 | 2020-12-19 | Floyd | Iowa | 19067 | 1232 | 28 |
843380 | 843380 | 2020-12-19 | Franklin | Iowa | 19069 | 846 | 17 |
843381 | 843381 | 2020-12-19 | Fremont | Iowa | 19071 | 442 | 5 |
843382 | 843382 | 2020-12-19 | Greene | Iowa | 19073 | 616 | 7 |
843383 | 843383 | 2020-12-19 | Grundy | Iowa | 19075 | 1000 | 14 |
843384 | 843384 | 2020-12-19 | Guthrie | Iowa | 19077 | 881 | 22 |
843385 | 843385 | 2020-12-19 | Hamilton | Iowa | 19079 | 1392 | 21 |
843386 | 843386 | 2020-12-19 | Hancock | Iowa | 19081 | 1099 | 23 |
843387 | 843387 | 2020-12-19 | Hardin | Iowa | 19083 | 1387 | 22 |
843388 | 843388 | 2020-12-19 | Harrison | Iowa | 19085 | 1326 | 51 |
843389 | 843389 | 2020-12-19 | Henry | Iowa | 19087 | 2395 | 21 |
843390 | 843390 | 2020-12-19 | Howard | Iowa | 19089 | 660 | 15 |
843391 | 843391 | 2020-12-19 | Humboldt | Iowa | 19091 | 904 | 17 |
843392 | 843392 | 2020-12-19 | Ida | Iowa | 19093 | 664 | 21 |
843393 | 843393 | 2020-12-19 | Iowa | Iowa | 19095 | 1100 | 19 |
843394 | 843394 | 2020-12-19 | Jackson | Iowa | 19097 | 1715 | 29 |
843395 | 843395 | 2020-12-19 | Jasper | Iowa | 19099 | 2673 | 50 |
843396 | 843396 | 2020-12-19 | Jefferson | Iowa | 19101 | 908 | 20 |
843397 | 843397 | 2020-12-19 | Johnson | Iowa | 19103 | 10594 | 45 |
843398 | 843398 | 2020-12-19 | Jones | Iowa | 19105 | 2522 | 37 |
843399 | 843399 | 2020-12-19 | Keokuk | Iowa | 19107 | 753 | 18 |
843400 | 843400 | 2020-12-19 | Kossuth | Iowa | 19109 | 1437 | 25 |
843401 | 843401 | 2020-12-19 | Lee | Iowa | 19111 | 2705 | 23 |
843402 | 843402 | 2020-12-19 | Linn | Iowa | 19113 | 15965 | 229 |
843403 | 843403 | 2020-12-19 | Louisa | Iowa | 19115 | 1002 | 23 |
843404 | 843404 | 2020-12-19 | Lucas | Iowa | 19117 | 470 | 7 |
843405 | 843405 | 2020-12-19 | Lyon | Iowa | 19119 | 1188 | 21 |
843406 | 843406 | 2020-12-19 | Madison | Iowa | 19121 | 883 | 8 |
843407 | 843407 | 2020-12-19 | Mahaska | Iowa | 19123 | 1581 | 32 |
843408 | 843408 | 2020-12-19 | Marion | Iowa | 19125 | 2494 | 37 |
843409 | 843409 | 2020-12-19 | Marshall | Iowa | 19127 | 3873 | 53 |
843410 | 843410 | 2020-12-19 | Mills | Iowa | 19129 | 1234 | 13 |
843411 | 843411 | 2020-12-19 | Mitchell | Iowa | 19131 | 957 | 21 |
843412 | 843412 | 2020-12-19 | Monona | Iowa | 19133 | 525 | 13 |
843413 | 843413 | 2020-12-19 | Monroe | Iowa | 19135 | 557 | 16 |
843414 | 843414 | 2020-12-19 | Montgomery | Iowa | 19137 | 671 | 13 |
843415 | 843415 | 2020-12-19 | Muscatine | Iowa | 19139 | 3407 | 71 |
843416 | 843416 | 2020-12-19 | O'Brien | Iowa | 19141 | 1530 | 48 |
843417 | 843417 | 2020-12-19 | Osceola | Iowa | 19143 | 600 | 5 |
843418 | 843418 | 2020-12-19 | Page | Iowa | 19145 | 1315 | 13 |
843419 | 843419 | 2020-12-19 | Palo Alto | Iowa | 19147 | 779 | 5 |
843420 | 843420 | 2020-12-19 | Plymouth | Iowa | 19149 | 3238 | 44 |
843421 | 843421 | 2020-12-19 | Pocahontas | Iowa | 19151 | 669 | 6 |
843422 | 843422 | 2020-12-19 | Polk | Iowa | 19153 | 39284 | 393 |
843423 | 843423 | 2020-12-19 | Pottawattamie | Iowa | 19155 | 7799 | 85 |
843424 | 843424 | 2020-12-19 | Poweshiek | Iowa | 19157 | 1142 | 22 |
843425 | 843425 | 2020-12-19 | Ringgold | Iowa | 19159 | 338 | 6 |
843426 | 843426 | 2020-12-19 | Sac | Iowa | 19161 | 1000 | 10 |
843427 | 843427 | 2020-12-19 | Scott | Iowa | 19163 | 13467 | 136 |
843428 | 843428 | 2020-12-19 | Shelby | Iowa | 19165 | 896 | 23 |
843429 | 843429 | 2020-12-19 | Sioux | Iowa | 19167 | 4190 | 40 |
843430 | 843430 | 2020-12-19 | Story | Iowa | 19169 | 7702 | 26 |
843431 | 843431 | 2020-12-19 | Tama | Iowa | 19171 | 1691 | 55 |
843432 | 843432 | 2020-12-19 | Taylor | Iowa | 19173 | 517 | 8 |
843433 | 843433 | 2020-12-19 | Union | Iowa | 19175 | 969 | 16 |
843434 | 843434 | 2020-12-19 | Unknown | Iowa | 451 | 1 | |
843435 | 843435 | 2020-12-19 | Van Buren | Iowa | 19177 | 435 | 11 |
843436 | 843436 | 2020-12-19 | Wapello | Iowa | 19179 | 2967 | 89 |
843437 | 843437 | 2020-12-19 | Warren | Iowa | 19181 | 3500 | 28 |
843438 | 843438 | 2020-12-19 | Washington | Iowa | 19183 | 1742 | 27 |
843439 | 843439 | 2020-12-19 | Wayne | Iowa | 19185 | 352 | 21 |
843440 | 843440 | 2020-12-19 | Webster | Iowa | 19187 | 4219 | 55 |
843441 | 843441 | 2020-12-19 | Winnebago | Iowa | 19189 | 1071 | 27 |
843442 | 843442 | 2020-12-19 | Winneshiek | Iowa | 19191 | 1293 | 17 |
843443 | 843443 | 2020-12-19 | Woodbury | Iowa | 19193 | 11816 | 157 |
843444 | 843444 | 2020-12-19 | Worth | Iowa | 19195 | 468 | 2 |
843445 | 843445 | 2020-12-19 | Wright | Iowa | 19197 | 1460 | 14 |
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);