ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where "date" is on date 2020-04-27 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
- Cass 1
- Cedar 1
- Cerro Gordo 1
- Cherokee 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
- …
state 1
- Iowa · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
93237 | 93237 | 2020-04-27 | Adair | Iowa | 19001 | 1 | 0 |
93238 | 93238 | 2020-04-27 | Allamakee | Iowa | 19005 | 72 | 3 |
93239 | 93239 | 2020-04-27 | Appanoose | Iowa | 19007 | 2 | 2 |
93240 | 93240 | 2020-04-27 | Audubon | Iowa | 19009 | 1 | 0 |
93241 | 93241 | 2020-04-27 | Benton | Iowa | 19011 | 27 | 1 |
93242 | 93242 | 2020-04-27 | Black Hawk | Iowa | 19013 | 844 | 11 |
93243 | 93243 | 2020-04-27 | Boone | Iowa | 19015 | 7 | 0 |
93244 | 93244 | 2020-04-27 | Bremer | Iowa | 19017 | 45 | 3 |
93245 | 93245 | 2020-04-27 | Buchanan | Iowa | 19019 | 12 | 0 |
93246 | 93246 | 2020-04-27 | Buena Vista | Iowa | 19021 | 4 | 0 |
93247 | 93247 | 2020-04-27 | Butler | Iowa | 19023 | 8 | 0 |
93248 | 93248 | 2020-04-27 | Carroll | Iowa | 19027 | 1 | 0 |
93249 | 93249 | 2020-04-27 | Cass | Iowa | 19029 | 1 | 0 |
93250 | 93250 | 2020-04-27 | Cedar | Iowa | 19031 | 28 | 0 |
93251 | 93251 | 2020-04-27 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
93252 | 93252 | 2020-04-27 | Cherokee | Iowa | 19035 | 2 | 0 |
93253 | 93253 | 2020-04-27 | Chickasaw | Iowa | 19037 | 4 | 0 |
93254 | 93254 | 2020-04-27 | Clarke | Iowa | 19039 | 2 | 0 |
93255 | 93255 | 2020-04-27 | Clay | Iowa | 19041 | 3 | 0 |
93256 | 93256 | 2020-04-27 | Clayton | Iowa | 19043 | 13 | 1 |
93257 | 93257 | 2020-04-27 | Clinton | Iowa | 19045 | 48 | 1 |
93258 | 93258 | 2020-04-27 | Crawford | Iowa | 19047 | 14 | 1 |
93259 | 93259 | 2020-04-27 | Dallas | Iowa | 19049 | 179 | 0 |
93260 | 93260 | 2020-04-27 | Delaware | Iowa | 19055 | 4 | 0 |
93261 | 93261 | 2020-04-27 | Des Moines | Iowa | 19057 | 17 | 1 |
93262 | 93262 | 2020-04-27 | Dickinson | Iowa | 19059 | 5 | 0 |
93263 | 93263 | 2020-04-27 | Dubuque | Iowa | 19061 | 87 | 2 |
93264 | 93264 | 2020-04-27 | Fayette | Iowa | 19065 | 16 | 0 |
93265 | 93265 | 2020-04-27 | Franklin | Iowa | 19069 | 2 | 0 |
93266 | 93266 | 2020-04-27 | Greene | Iowa | 19073 | 2 | 0 |
93267 | 93267 | 2020-04-27 | Grundy | Iowa | 19075 | 9 | 0 |
93268 | 93268 | 2020-04-27 | Guthrie | Iowa | 19077 | 6 | 0 |
93269 | 93269 | 2020-04-27 | Hamilton | Iowa | 19079 | 7 | 0 |
93270 | 93270 | 2020-04-27 | Hancock | Iowa | 19081 | 3 | 0 |
93271 | 93271 | 2020-04-27 | Hardin | Iowa | 19083 | 7 | 0 |
93272 | 93272 | 2020-04-27 | Harrison | Iowa | 19085 | 15 | 0 |
93273 | 93273 | 2020-04-27 | Henry | Iowa | 19087 | 32 | 1 |
93274 | 93274 | 2020-04-27 | Howard | Iowa | 19089 | 6 | 0 |
93275 | 93275 | 2020-04-27 | Humboldt | Iowa | 19091 | 4 | 0 |
93276 | 93276 | 2020-04-27 | Iowa | Iowa | 19095 | 18 | 0 |
93277 | 93277 | 2020-04-27 | Jackson | Iowa | 19097 | 5 | 0 |
93278 | 93278 | 2020-04-27 | Jasper | Iowa | 19099 | 91 | 0 |
93279 | 93279 | 2020-04-27 | Jefferson | Iowa | 19101 | 6 | 0 |
93280 | 93280 | 2020-04-27 | Johnson | Iowa | 19103 | 437 | 6 |
93281 | 93281 | 2020-04-27 | Jones | Iowa | 19105 | 19 | 0 |
93282 | 93282 | 2020-04-27 | Keokuk | Iowa | 19107 | 2 | 0 |
93283 | 93283 | 2020-04-27 | Kossuth | Iowa | 19109 | 1 | 0 |
93284 | 93284 | 2020-04-27 | Lee | Iowa | 19111 | 5 | 0 |
93285 | 93285 | 2020-04-27 | Linn | Iowa | 19113 | 613 | 34 |
93286 | 93286 | 2020-04-27 | Louisa | Iowa | 19115 | 267 | 2 |
93287 | 93287 | 2020-04-27 | Lyon | Iowa | 19119 | 9 | 0 |
93288 | 93288 | 2020-04-27 | Madison | Iowa | 19121 | 3 | 1 |
93289 | 93289 | 2020-04-27 | Mahaska | Iowa | 19123 | 9 | 1 |
93290 | 93290 | 2020-04-27 | Marion | Iowa | 19125 | 7 | 0 |
93291 | 93291 | 2020-04-27 | Marshall | Iowa | 19127 | 408 | 0 |
93292 | 93292 | 2020-04-27 | Mills | Iowa | 19129 | 3 | 0 |
93293 | 93293 | 2020-04-27 | Mitchell | Iowa | 19131 | 2 | 0 |
93294 | 93294 | 2020-04-27 | Monona | Iowa | 19133 | 7 | 0 |
93295 | 93295 | 2020-04-27 | Montgomery | Iowa | 19137 | 1 | 0 |
93296 | 93296 | 2020-04-27 | Muscatine | Iowa | 19139 | 311 | 7 |
93297 | 93297 | 2020-04-27 | O'Brien | Iowa | 19141 | 6 | 0 |
93298 | 93298 | 2020-04-27 | Osceola | Iowa | 19143 | 8 | 0 |
93299 | 93299 | 2020-04-27 | Page | Iowa | 19145 | 5 | 0 |
93300 | 93300 | 2020-04-27 | Plymouth | Iowa | 19149 | 10 | 0 |
93301 | 93301 | 2020-04-27 | Pocahontas | Iowa | 19151 | 1 | 0 |
93302 | 93302 | 2020-04-27 | Polk | Iowa | 19153 | 756 | 27 |
93303 | 93303 | 2020-04-27 | Pottawattamie | Iowa | 19155 | 27 | 1 |
93304 | 93304 | 2020-04-27 | Poweshiek | Iowa | 19157 | 50 | 2 |
93305 | 93305 | 2020-04-27 | Scott | Iowa | 19163 | 216 | 5 |
93306 | 93306 | 2020-04-27 | Shelby | Iowa | 19165 | 9 | 0 |
93307 | 93307 | 2020-04-27 | Sioux | Iowa | 19167 | 7 | 0 |
93308 | 93308 | 2020-04-27 | Story | Iowa | 19169 | 25 | 0 |
93309 | 93309 | 2020-04-27 | Tama | Iowa | 19171 | 259 | 7 |
93310 | 93310 | 2020-04-27 | Taylor | Iowa | 19173 | 1 | 0 |
93311 | 93311 | 2020-04-27 | Union | Iowa | 19175 | 1 | 0 |
93312 | 93312 | 2020-04-27 | Unknown | Iowa | 7 | 0 | |
93313 | 93313 | 2020-04-27 | Van Buren | Iowa | 19177 | 8 | 0 |
93314 | 93314 | 2020-04-27 | Wapello | Iowa | 19179 | 10 | 0 |
93315 | 93315 | 2020-04-27 | Warren | Iowa | 19181 | 20 | 0 |
93316 | 93316 | 2020-04-27 | Washington | Iowa | 19183 | 136 | 6 |
93317 | 93317 | 2020-04-27 | Webster | Iowa | 19187 | 4 | 0 |
93318 | 93318 | 2020-04-27 | Winnebago | Iowa | 19189 | 2 | 0 |
93319 | 93319 | 2020-04-27 | Winneshiek | Iowa | 19191 | 24 | 0 |
93320 | 93320 | 2020-04-27 | Woodbury | Iowa | 19193 | 495 | 1 |
93321 | 93321 | 2020-04-27 | Worth | Iowa | 19195 | 1 | 0 |
93322 | 93322 | 2020-04-27 | Wright | Iowa | 19197 | 2 | 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);