ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2020-04-14 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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
- Cass 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
- …
state 1
- Iowa · 82 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
57193 | 57193 | 2020-04-14 | Adair | Iowa | 19001 | 1 | 0 |
57194 | 57194 | 2020-04-14 | Allamakee | Iowa | 19005 | 24 | 1 |
57195 | 57195 | 2020-04-14 | Appanoose | Iowa | 19007 | 1 | 1 |
57196 | 57196 | 2020-04-14 | Audubon | Iowa | 19009 | 1 | 0 |
57197 | 57197 | 2020-04-14 | Benton | Iowa | 19011 | 20 | 1 |
57198 | 57198 | 2020-04-14 | Black Hawk | Iowa | 19013 | 78 | 0 |
57199 | 57199 | 2020-04-14 | Boone | Iowa | 19015 | 4 | 0 |
57200 | 57200 | 2020-04-14 | Bremer | Iowa | 19017 | 9 | 0 |
57201 | 57201 | 2020-04-14 | Buchanan | Iowa | 19019 | 8 | 0 |
57202 | 57202 | 2020-04-14 | Buena Vista | Iowa | 19021 | 2 | 0 |
57203 | 57203 | 2020-04-14 | Butler | Iowa | 19023 | 1 | 0 |
57204 | 57204 | 2020-04-14 | Carroll | Iowa | 19027 | 1 | 0 |
57205 | 57205 | 2020-04-14 | Cass | Iowa | 19029 | 1 | 0 |
57206 | 57206 | 2020-04-14 | Cedar | Iowa | 19031 | 21 | 0 |
57207 | 57207 | 2020-04-14 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
57208 | 57208 | 2020-04-14 | Chickasaw | Iowa | 19037 | 2 | 0 |
57209 | 57209 | 2020-04-14 | Clarke | Iowa | 19039 | 2 | 0 |
57210 | 57210 | 2020-04-14 | Clay | Iowa | 19041 | 2 | 0 |
57211 | 57211 | 2020-04-14 | Clayton | Iowa | 19043 | 7 | 0 |
57212 | 57212 | 2020-04-14 | Clinton | Iowa | 19045 | 36 | 0 |
57213 | 57213 | 2020-04-14 | Crawford | Iowa | 19047 | 6 | 1 |
57214 | 57214 | 2020-04-14 | Dallas | Iowa | 19049 | 37 | 0 |
57215 | 57215 | 2020-04-14 | Delaware | Iowa | 19055 | 2 | 0 |
57216 | 57216 | 2020-04-14 | Des Moines | Iowa | 19057 | 7 | 0 |
57217 | 57217 | 2020-04-14 | Dickinson | Iowa | 19059 | 1 | 0 |
57218 | 57218 | 2020-04-14 | Dubuque | Iowa | 19061 | 35 | 1 |
57219 | 57219 | 2020-04-14 | Fayette | Iowa | 19065 | 5 | 0 |
57220 | 57220 | 2020-04-14 | Franklin | Iowa | 19069 | 1 | 0 |
57221 | 57221 | 2020-04-14 | Greene | Iowa | 19073 | 1 | 0 |
57222 | 57222 | 2020-04-14 | Grundy | Iowa | 19075 | 1 | 0 |
57223 | 57223 | 2020-04-14 | Guthrie | Iowa | 19077 | 1 | 0 |
57224 | 57224 | 2020-04-14 | Hamilton | Iowa | 19079 | 2 | 0 |
57225 | 57225 | 2020-04-14 | Hancock | Iowa | 19081 | 3 | 0 |
57226 | 57226 | 2020-04-14 | Hardin | Iowa | 19083 | 2 | 0 |
57227 | 57227 | 2020-04-14 | Harrison | Iowa | 19085 | 12 | 0 |
57228 | 57228 | 2020-04-14 | Henry | Iowa | 19087 | 22 | 1 |
57229 | 57229 | 2020-04-14 | Howard | Iowa | 19089 | 1 | 0 |
57230 | 57230 | 2020-04-14 | Iowa | Iowa | 19095 | 7 | 0 |
57231 | 57231 | 2020-04-14 | Jackson | Iowa | 19097 | 4 | 0 |
57232 | 57232 | 2020-04-14 | Jasper | Iowa | 19099 | 15 | 0 |
57233 | 57233 | 2020-04-14 | Jefferson | Iowa | 19101 | 4 | 0 |
57234 | 57234 | 2020-04-14 | Johnson | Iowa | 19103 | 216 | 2 |
57235 | 57235 | 2020-04-14 | Jones | Iowa | 19105 | 11 | 0 |
57236 | 57236 | 2020-04-14 | Keokuk | Iowa | 19107 | 2 | 0 |
57237 | 57237 | 2020-04-14 | Kossuth | Iowa | 19109 | 1 | 0 |
57238 | 57238 | 2020-04-14 | Lee | Iowa | 19111 | 2 | 0 |
57239 | 57239 | 2020-04-14 | Linn | Iowa | 19113 | 265 | 19 |
57240 | 57240 | 2020-04-14 | Louisa | Iowa | 19115 | 149 | 0 |
57241 | 57241 | 2020-04-14 | Lyon | Iowa | 19119 | 4 | 0 |
57242 | 57242 | 2020-04-14 | Madison | Iowa | 19121 | 3 | 1 |
57243 | 57243 | 2020-04-14 | Mahaska | Iowa | 19123 | 5 | 0 |
57244 | 57244 | 2020-04-14 | Marion | Iowa | 19125 | 3 | 0 |
57245 | 57245 | 2020-04-14 | Marshall | Iowa | 19127 | 42 | 0 |
57246 | 57246 | 2020-04-14 | Mills | Iowa | 19129 | 2 | 0 |
57247 | 57247 | 2020-04-14 | Mitchell | Iowa | 19131 | 2 | 0 |
57248 | 57248 | 2020-04-14 | Monona | Iowa | 19133 | 6 | 0 |
57249 | 57249 | 2020-04-14 | Montgomery | Iowa | 19137 | 1 | 0 |
57250 | 57250 | 2020-04-14 | Muscatine | Iowa | 19139 | 122 | 2 |
57251 | 57251 | 2020-04-14 | O'Brien | Iowa | 19141 | 3 | 0 |
57252 | 57252 | 2020-04-14 | Osceola | Iowa | 19143 | 2 | 0 |
57253 | 57253 | 2020-04-14 | Page | Iowa | 19145 | 3 | 0 |
57254 | 57254 | 2020-04-14 | Plymouth | Iowa | 19149 | 4 | 0 |
57255 | 57255 | 2020-04-14 | Polk | Iowa | 19153 | 213 | 5 |
57256 | 57256 | 2020-04-14 | Pottawattamie | Iowa | 19155 | 14 | 1 |
57257 | 57257 | 2020-04-14 | Poweshiek | Iowa | 19157 | 6 | 1 |
57258 | 57258 | 2020-04-14 | Scott | Iowa | 19163 | 124 | 1 |
57259 | 57259 | 2020-04-14 | Shelby | Iowa | 19165 | 6 | 0 |
57260 | 57260 | 2020-04-14 | Sioux | Iowa | 19167 | 7 | 0 |
57261 | 57261 | 2020-04-14 | Story | Iowa | 19169 | 11 | 0 |
57262 | 57262 | 2020-04-14 | Tama | Iowa | 19171 | 108 | 2 |
57263 | 57263 | 2020-04-14 | Taylor | Iowa | 19173 | 1 | 0 |
57264 | 57264 | 2020-04-14 | Union | Iowa | 19175 | 1 | 0 |
57265 | 57265 | 2020-04-14 | Van Buren | Iowa | 19177 | 8 | 0 |
57266 | 57266 | 2020-04-14 | Wapello | Iowa | 19179 | 7 | 0 |
57267 | 57267 | 2020-04-14 | Warren | Iowa | 19181 | 15 | 0 |
57268 | 57268 | 2020-04-14 | Washington | Iowa | 19183 | 95 | 4 |
57269 | 57269 | 2020-04-14 | Webster | Iowa | 19187 | 2 | 0 |
57270 | 57270 | 2020-04-14 | Winnebago | Iowa | 19189 | 2 | 0 |
57271 | 57271 | 2020-04-14 | Winneshiek | Iowa | 19191 | 5 | 0 |
57272 | 57272 | 2020-04-14 | Woodbury | Iowa | 19193 | 20 | 0 |
57273 | 57273 | 2020-04-14 | Worth | Iowa | 19195 | 1 | 0 |
57274 | 57274 | 2020-04-14 | 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);