ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where "date" is on date 2020-04-10 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adair 1
- Allamakee 1
- Appanoose 1
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Bremer 1
- Buchanan 1
- Buena Vista 1
- Butler 1
- Carroll 1
- Cedar 1
- Cerro Gordo 1
- Chickasaw 1
- Clarke 1
- Clay 1
- Clayton 1
- Clinton 1
- Crawford 1
- Dallas 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Fayette 1
- Franklin 1
- Greene 1
- Grundy 1
- Guthrie 1
- …
state 1
- Iowa · 81 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
46521 | 46521 | 2020-04-10 | Adair | Iowa | 19001 | 1 | 0 |
46522 | 46522 | 2020-04-10 | Allamakee | Iowa | 19005 | 20 | 1 |
46523 | 46523 | 2020-04-10 | Appanoose | Iowa | 19007 | 1 | 1 |
46524 | 46524 | 2020-04-10 | Audubon | Iowa | 19009 | 1 | 0 |
46525 | 46525 | 2020-04-10 | Benton | Iowa | 19011 | 15 | 1 |
46526 | 46526 | 2020-04-10 | Black Hawk | Iowa | 19013 | 35 | 0 |
46527 | 46527 | 2020-04-10 | Boone | Iowa | 19015 | 4 | 0 |
46528 | 46528 | 2020-04-10 | Bremer | Iowa | 19017 | 2 | 0 |
46529 | 46529 | 2020-04-10 | Buchanan | Iowa | 19019 | 6 | 0 |
46530 | 46530 | 2020-04-10 | Buena Vista | Iowa | 19021 | 1 | 0 |
46531 | 46531 | 2020-04-10 | Butler | Iowa | 19023 | 1 | 0 |
46532 | 46532 | 2020-04-10 | Carroll | Iowa | 19027 | 1 | 0 |
46533 | 46533 | 2020-04-10 | Cedar | Iowa | 19031 | 20 | 0 |
46534 | 46534 | 2020-04-10 | Cerro Gordo | Iowa | 19033 | 13 | 0 |
46535 | 46535 | 2020-04-10 | Chickasaw | Iowa | 19037 | 2 | 0 |
46536 | 46536 | 2020-04-10 | Clarke | Iowa | 19039 | 2 | 0 |
46537 | 46537 | 2020-04-10 | Clay | Iowa | 19041 | 2 | 0 |
46538 | 46538 | 2020-04-10 | Clayton | Iowa | 19043 | 6 | 0 |
46539 | 46539 | 2020-04-10 | Clinton | Iowa | 19045 | 24 | 0 |
46540 | 46540 | 2020-04-10 | Crawford | Iowa | 19047 | 6 | 0 |
46541 | 46541 | 2020-04-10 | Dallas | Iowa | 19049 | 36 | 0 |
46542 | 46542 | 2020-04-10 | Delaware | Iowa | 19055 | 1 | 0 |
46543 | 46543 | 2020-04-10 | Des Moines | Iowa | 19057 | 3 | 0 |
46544 | 46544 | 2020-04-10 | Dickinson | Iowa | 19059 | 1 | 0 |
46545 | 46545 | 2020-04-10 | Dubuque | Iowa | 19061 | 32 | 1 |
46546 | 46546 | 2020-04-10 | Fayette | Iowa | 19065 | 4 | 0 |
46547 | 46547 | 2020-04-10 | Franklin | Iowa | 19069 | 1 | 0 |
46548 | 46548 | 2020-04-10 | Greene | Iowa | 19073 | 1 | 0 |
46549 | 46549 | 2020-04-10 | Grundy | Iowa | 19075 | 1 | 0 |
46550 | 46550 | 2020-04-10 | Guthrie | Iowa | 19077 | 1 | 0 |
46551 | 46551 | 2020-04-10 | Hamilton | Iowa | 19079 | 2 | 0 |
46552 | 46552 | 2020-04-10 | Hancock | Iowa | 19081 | 3 | 0 |
46553 | 46553 | 2020-04-10 | Hardin | Iowa | 19083 | 1 | 0 |
46554 | 46554 | 2020-04-10 | Harrison | Iowa | 19085 | 12 | 0 |
46555 | 46555 | 2020-04-10 | Henry | Iowa | 19087 | 17 | 1 |
46556 | 46556 | 2020-04-10 | Howard | Iowa | 19089 | 1 | 0 |
46557 | 46557 | 2020-04-10 | Iowa | Iowa | 19095 | 7 | 0 |
46558 | 46558 | 2020-04-10 | Jackson | Iowa | 19097 | 4 | 0 |
46559 | 46559 | 2020-04-10 | Jasper | Iowa | 19099 | 10 | 0 |
46560 | 46560 | 2020-04-10 | Jefferson | Iowa | 19101 | 3 | 0 |
46561 | 46561 | 2020-04-10 | Johnson | Iowa | 19103 | 185 | 1 |
46562 | 46562 | 2020-04-10 | Jones | Iowa | 19105 | 8 | 0 |
46563 | 46563 | 2020-04-10 | Keokuk | Iowa | 19107 | 2 | 0 |
46564 | 46564 | 2020-04-10 | Kossuth | Iowa | 19109 | 1 | 0 |
46565 | 46565 | 2020-04-10 | Lee | Iowa | 19111 | 1 | 0 |
46566 | 46566 | 2020-04-10 | Linn | Iowa | 19113 | 225 | 12 |
46567 | 46567 | 2020-04-10 | Louisa | Iowa | 19115 | 56 | 0 |
46568 | 46568 | 2020-04-10 | Lyon | Iowa | 19119 | 2 | 0 |
46569 | 46569 | 2020-04-10 | Madison | Iowa | 19121 | 1 | 0 |
46570 | 46570 | 2020-04-10 | Mahaska | Iowa | 19123 | 4 | 0 |
46571 | 46571 | 2020-04-10 | Marion | Iowa | 19125 | 2 | 0 |
46572 | 46572 | 2020-04-10 | Marshall | Iowa | 19127 | 20 | 0 |
46573 | 46573 | 2020-04-10 | Mills | Iowa | 19129 | 1 | 0 |
46574 | 46574 | 2020-04-10 | Mitchell | Iowa | 19131 | 2 | 0 |
46575 | 46575 | 2020-04-10 | Monona | Iowa | 19133 | 6 | 0 |
46576 | 46576 | 2020-04-10 | Montgomery | Iowa | 19137 | 1 | 0 |
46577 | 46577 | 2020-04-10 | Muscatine | Iowa | 19139 | 80 | 1 |
46578 | 46578 | 2020-04-10 | O'Brien | Iowa | 19141 | 3 | 0 |
46579 | 46579 | 2020-04-10 | Osceola | Iowa | 19143 | 1 | 0 |
46580 | 46580 | 2020-04-10 | Page | Iowa | 19145 | 3 | 0 |
46581 | 46581 | 2020-04-10 | Plymouth | Iowa | 19149 | 4 | 0 |
46582 | 46582 | 2020-04-10 | Polk | Iowa | 19153 | 147 | 5 |
46583 | 46583 | 2020-04-10 | Pottawattamie | Iowa | 19155 | 12 | 0 |
46584 | 46584 | 2020-04-10 | Poweshiek | Iowa | 19157 | 6 | 1 |
46585 | 46585 | 2020-04-10 | Scott | Iowa | 19163 | 99 | 1 |
46586 | 46586 | 2020-04-10 | Shelby | Iowa | 19165 | 6 | 0 |
46587 | 46587 | 2020-04-10 | Sioux | Iowa | 19167 | 7 | 0 |
46588 | 46588 | 2020-04-10 | Story | Iowa | 19169 | 7 | 0 |
46589 | 46589 | 2020-04-10 | Tama | Iowa | 19171 | 70 | 2 |
46590 | 46590 | 2020-04-10 | Taylor | Iowa | 19173 | 1 | 0 |
46591 | 46591 | 2020-04-10 | Union | Iowa | 19175 | 1 | 0 |
46592 | 46592 | 2020-04-10 | Van Buren | Iowa | 19177 | 6 | 0 |
46593 | 46593 | 2020-04-10 | Wapello | Iowa | 19179 | 3 | 0 |
46594 | 46594 | 2020-04-10 | Warren | Iowa | 19181 | 15 | 0 |
46595 | 46595 | 2020-04-10 | Washington | Iowa | 19183 | 70 | 3 |
46596 | 46596 | 2020-04-10 | Webster | Iowa | 19187 | 2 | 0 |
46597 | 46597 | 2020-04-10 | Winnebago | Iowa | 19189 | 2 | 0 |
46598 | 46598 | 2020-04-10 | Winneshiek | Iowa | 19191 | 5 | 0 |
46599 | 46599 | 2020-04-10 | Woodbury | Iowa | 19193 | 15 | 0 |
46600 | 46600 | 2020-04-10 | Worth | Iowa | 19195 | 1 | 0 |
46601 | 46601 | 2020-04-10 | 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);