ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where "date" is on date 2020-04-04 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
31432 | 31432 | 2020-04-04 | Adair | Iowa | 19001 | 1 | 0 |
31433 | 31433 | 2020-04-04 | Allamakee | Iowa | 19005 | 16 | 1 |
31434 | 31434 | 2020-04-04 | Appanoose | Iowa | 19007 | 1 | 0 |
31435 | 31435 | 2020-04-04 | Audubon | Iowa | 19009 | 1 | 0 |
31436 | 31436 | 2020-04-04 | Benton | Iowa | 19011 | 7 | 0 |
31437 | 31437 | 2020-04-04 | Black Hawk | Iowa | 19013 | 10 | 0 |
31438 | 31438 | 2020-04-04 | Boone | Iowa | 19015 | 2 | 0 |
31439 | 31439 | 2020-04-04 | Bremer | Iowa | 19017 | 2 | 0 |
31440 | 31440 | 2020-04-04 | Buchanan | Iowa | 19019 | 3 | 0 |
31441 | 31441 | 2020-04-04 | Butler | Iowa | 19023 | 1 | 0 |
31442 | 31442 | 2020-04-04 | Carroll | Iowa | 19027 | 1 | 0 |
31443 | 31443 | 2020-04-04 | Cedar | Iowa | 19031 | 11 | 0 |
31444 | 31444 | 2020-04-04 | Cerro Gordo | Iowa | 19033 | 10 | 0 |
31445 | 31445 | 2020-04-04 | Clay | Iowa | 19041 | 2 | 0 |
31446 | 31446 | 2020-04-04 | Clayton | Iowa | 19043 | 3 | 0 |
31447 | 31447 | 2020-04-04 | Clinton | Iowa | 19045 | 15 | 0 |
31448 | 31448 | 2020-04-04 | Crawford | Iowa | 19047 | 4 | 0 |
31449 | 31449 | 2020-04-04 | Dallas | Iowa | 19049 | 33 | 0 |
31450 | 31450 | 2020-04-04 | Des Moines | Iowa | 19057 | 1 | 0 |
31451 | 31451 | 2020-04-04 | Dickinson | Iowa | 19059 | 1 | 0 |
31452 | 31452 | 2020-04-04 | Dubuque | Iowa | 19061 | 24 | 1 |
31453 | 31453 | 2020-04-04 | Fayette | Iowa | 19065 | 3 | 0 |
31454 | 31454 | 2020-04-04 | Grundy | Iowa | 19075 | 1 | 0 |
31455 | 31455 | 2020-04-04 | Guthrie | Iowa | 19077 | 1 | 0 |
31456 | 31456 | 2020-04-04 | Hancock | Iowa | 19081 | 3 | 0 |
31457 | 31457 | 2020-04-04 | Hardin | Iowa | 19083 | 1 | 0 |
31458 | 31458 | 2020-04-04 | Harrison | Iowa | 19085 | 10 | 0 |
31459 | 31459 | 2020-04-04 | Henry | Iowa | 19087 | 6 | 0 |
31460 | 31460 | 2020-04-04 | Howard | Iowa | 19089 | 1 | 0 |
31461 | 31461 | 2020-04-04 | Iowa | Iowa | 19095 | 6 | 0 |
31462 | 31462 | 2020-04-04 | Jackson | Iowa | 19097 | 3 | 0 |
31463 | 31463 | 2020-04-04 | Jasper | Iowa | 19099 | 8 | 0 |
31464 | 31464 | 2020-04-04 | Jefferson | Iowa | 19101 | 3 | 0 |
31465 | 31465 | 2020-04-04 | Johnson | Iowa | 19103 | 96 | 0 |
31466 | 31466 | 2020-04-04 | Jones | Iowa | 19105 | 5 | 0 |
31467 | 31467 | 2020-04-04 | Keokuk | Iowa | 19107 | 2 | 0 |
31468 | 31468 | 2020-04-04 | Kossuth | Iowa | 19109 | 1 | 0 |
31469 | 31469 | 2020-04-04 | Lee | Iowa | 19111 | 1 | 0 |
31470 | 31470 | 2020-04-04 | Linn | Iowa | 19113 | 139 | 4 |
31471 | 31471 | 2020-04-04 | Louisa | Iowa | 19115 | 1 | 0 |
31472 | 31472 | 2020-04-04 | Lyon | Iowa | 19119 | 2 | 0 |
31473 | 31473 | 2020-04-04 | Madison | Iowa | 19121 | 1 | 0 |
31474 | 31474 | 2020-04-04 | Mahaska | Iowa | 19123 | 3 | 0 |
31475 | 31475 | 2020-04-04 | Marshall | Iowa | 19127 | 10 | 0 |
31476 | 31476 | 2020-04-04 | Mills | Iowa | 19129 | 1 | 0 |
31477 | 31477 | 2020-04-04 | Mitchell | Iowa | 19131 | 2 | 0 |
31478 | 31478 | 2020-04-04 | Monona | Iowa | 19133 | 6 | 0 |
31479 | 31479 | 2020-04-04 | Montgomery | Iowa | 19137 | 1 | 0 |
31480 | 31480 | 2020-04-04 | Muscatine | Iowa | 19139 | 27 | 1 |
31481 | 31481 | 2020-04-04 | O'Brien | Iowa | 19141 | 3 | 0 |
31482 | 31482 | 2020-04-04 | Page | Iowa | 19145 | 2 | 0 |
31483 | 31483 | 2020-04-04 | Plymouth | Iowa | 19149 | 3 | 0 |
31484 | 31484 | 2020-04-04 | Polk | Iowa | 19153 | 109 | 1 |
31485 | 31485 | 2020-04-04 | Pottawattamie | Iowa | 19155 | 8 | 0 |
31486 | 31486 | 2020-04-04 | Poweshiek | Iowa | 19157 | 6 | 1 |
31487 | 31487 | 2020-04-04 | Scott | Iowa | 19163 | 38 | 0 |
31488 | 31488 | 2020-04-04 | Shelby | Iowa | 19165 | 5 | 0 |
31489 | 31489 | 2020-04-04 | Sioux | Iowa | 19167 | 7 | 0 |
31490 | 31490 | 2020-04-04 | Story | Iowa | 19169 | 5 | 0 |
31491 | 31491 | 2020-04-04 | Tama | Iowa | 19171 | 29 | 0 |
31492 | 31492 | 2020-04-04 | Taylor | Iowa | 19173 | 1 | 0 |
31493 | 31493 | 2020-04-04 | Van Buren | Iowa | 19177 | 6 | 0 |
31494 | 31494 | 2020-04-04 | Wapello | Iowa | 19179 | 1 | 0 |
31495 | 31495 | 2020-04-04 | Warren | Iowa | 19181 | 9 | 0 |
31496 | 31496 | 2020-04-04 | Washington | Iowa | 19183 | 47 | 2 |
31497 | 31497 | 2020-04-04 | Webster | Iowa | 19187 | 1 | 0 |
31498 | 31498 | 2020-04-04 | Winneshiek | Iowa | 19191 | 4 | 0 |
31499 | 31499 | 2020-04-04 | Woodbury | Iowa | 19193 | 8 | 0 |
31500 | 31500 | 2020-04-04 | Wright | Iowa | 19197 | 1 | 0 |
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);