ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,070 rows where state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 19103 213
- 19155 212
- 19027 209
- 19085 208
- 19049 207
- 19005 206
- 19153 206
- 19001 204
- 19013 204
- 19183 203
- 19191 203
- 19061 202
- 19139 202
- 19065 200
- 19087 200
- 19113 200
- 19169 200
- 19033 199
- 19109 199
- 19157 199
- 19163 199
- 19167 199
- 19171 199
- 19193 199
- 19081 198
- 19179 198
- 19019 197
- 19031 197
- 19099 197
- 19181 197
- …
county >30
- Johnson 213
- Pottawattamie 212
- Carroll 209
- Harrison 208
- Dallas 207
- Allamakee 206
- Polk 206
- Adair 204
- Black Hawk 204
- Washington 203
- Winneshiek 203
- Dubuque 202
- Muscatine 202
- Fayette 200
- Henry 200
- Linn 200
- Story 200
- Cerro Gordo 199
- Kossuth 199
- Poweshiek 199
- Scott 199
- Sioux 199
- Tama 199
- Woodbury 199
- Hancock 198
- Wapello 198
- Buchanan 197
- Cedar 197
- Jasper 197
- Warren 197
- …
state 1
- Iowa · 18,670 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
603250 | 603250 | 2020-10-06 | Adair | Iowa | 19001 | 83 | 1 |
603251 | 603251 | 2020-10-06 | Adams | Iowa | 19003 | 46 | 0 |
603252 | 603252 | 2020-10-06 | Allamakee | Iowa | 19005 | 278 | 8 |
603253 | 603253 | 2020-10-06 | Appanoose | Iowa | 19007 | 159 | 3 |
603254 | 603254 | 2020-10-06 | Audubon | Iowa | 19009 | 109 | 1 |
603255 | 603255 | 2020-10-06 | Benton | Iowa | 19011 | 372 | 1 |
603256 | 603256 | 2020-10-06 | Black Hawk | Iowa | 19013 | 4689 | 95 |
603257 | 603257 | 2020-10-06 | Boone | Iowa | 19015 | 571 | 8 |
603258 | 603258 | 2020-10-06 | Bremer | Iowa | 19017 | 530 | 7 |
603259 | 603259 | 2020-10-06 | Buchanan | Iowa | 19019 | 323 | 1 |
603260 | 603260 | 2020-10-06 | Buena Vista | Iowa | 19021 | 2066 | 12 |
603261 | 603261 | 2020-10-06 | Butler | Iowa | 19023 | 296 | 2 |
603262 | 603262 | 2020-10-06 | Calhoun | Iowa | 19025 | 215 | 3 |
603263 | 603263 | 2020-10-06 | Carroll | Iowa | 19027 | 797 | 5 |
603264 | 603264 | 2020-10-06 | Cass | Iowa | 19029 | 194 | 2 |
603265 | 603265 | 2020-10-06 | Cedar | Iowa | 19031 | 285 | 2 |
603266 | 603266 | 2020-10-06 | Cerro Gordo | Iowa | 19033 | 1119 | 23 |
603267 | 603267 | 2020-10-06 | Cherokee | Iowa | 19035 | 302 | 2 |
603268 | 603268 | 2020-10-06 | Chickasaw | Iowa | 19037 | 293 | 1 |
603269 | 603269 | 2020-10-06 | Clarke | Iowa | 19039 | 275 | 3 |
603270 | 603270 | 2020-10-06 | Clay | Iowa | 19041 | 385 | 4 |
603271 | 603271 | 2020-10-06 | Clayton | Iowa | 19043 | 295 | 3 |
603272 | 603272 | 2020-10-06 | Clinton | Iowa | 19045 | 1216 | 23 |
603273 | 603273 | 2020-10-06 | Crawford | Iowa | 19047 | 1168 | 7 |
603274 | 603274 | 2020-10-06 | Dallas | Iowa | 19049 | 2948 | 40 |
603275 | 603275 | 2020-10-06 | Davis | Iowa | 19051 | 137 | 4 |
603276 | 603276 | 2020-10-06 | Decatur | Iowa | 19053 | 76 | 0 |
603277 | 603277 | 2020-10-06 | Delaware | Iowa | 19055 | 515 | 4 |
603278 | 603278 | 2020-10-06 | Des Moines | Iowa | 19057 | 910 | 9 |
603279 | 603279 | 2020-10-06 | Dickinson | Iowa | 19059 | 580 | 7 |
603280 | 603280 | 2020-10-06 | Dubuque | Iowa | 19061 | 3778 | 47 |
603281 | 603281 | 2020-10-06 | Emmet | Iowa | 19063 | 306 | 11 |
603282 | 603282 | 2020-10-06 | Fayette | Iowa | 19065 | 258 | 2 |
603283 | 603283 | 2020-10-06 | Floyd | Iowa | 19067 | 378 | 8 |
603284 | 603284 | 2020-10-06 | Franklin | Iowa | 19069 | 353 | 18 |
603285 | 603285 | 2020-10-06 | Fremont | Iowa | 19071 | 151 | 0 |
603286 | 603286 | 2020-10-06 | Greene | Iowa | 19073 | 136 | 0 |
603287 | 603287 | 2020-10-06 | Grundy | Iowa | 19075 | 245 | 4 |
603288 | 603288 | 2020-10-06 | Guthrie | Iowa | 19077 | 302 | 12 |
603289 | 603289 | 2020-10-06 | Hamilton | Iowa | 19079 | 347 | 3 |
603290 | 603290 | 2020-10-06 | Hancock | Iowa | 19081 | 216 | 3 |
603291 | 603291 | 2020-10-06 | Hardin | Iowa | 19083 | 328 | 2 |
603292 | 603292 | 2020-10-06 | Harrison | Iowa | 19085 | 337 | 5 |
603293 | 603293 | 2020-10-06 | Henry | Iowa | 19087 | 850 | 5 |
603294 | 603294 | 2020-10-06 | Howard | Iowa | 19089 | 199 | 7 |
603295 | 603295 | 2020-10-06 | Humboldt | Iowa | 19091 | 204 | 3 |
603296 | 603296 | 2020-10-06 | Ida | Iowa | 19093 | 149 | 2 |
603297 | 603297 | 2020-10-06 | Iowa | Iowa | 19095 | 268 | 1 |
603298 | 603298 | 2020-10-06 | Jackson | Iowa | 19097 | 412 | 3 |
603299 | 603299 | 2020-10-06 | Jasper | Iowa | 19099 | 919 | 34 |
603300 | 603300 | 2020-10-06 | Jefferson | Iowa | 19101 | 156 | 1 |
603301 | 603301 | 2020-10-06 | Johnson | Iowa | 19103 | 5307 | 28 |
603302 | 603302 | 2020-10-06 | Jones | Iowa | 19105 | 325 | 3 |
603303 | 603303 | 2020-10-06 | Keokuk | Iowa | 19107 | 126 | 1 |
603304 | 603304 | 2020-10-06 | Kossuth | Iowa | 19109 | 329 | 0 |
603305 | 603305 | 2020-10-06 | Lee | Iowa | 19111 | 713 | 8 |
603306 | 603306 | 2020-10-06 | Linn | Iowa | 19113 | 4472 | 116 |
603307 | 603307 | 2020-10-06 | Louisa | Iowa | 19115 | 450 | 15 |
603308 | 603308 | 2020-10-06 | Lucas | Iowa | 19117 | 162 | 6 |
603309 | 603309 | 2020-10-06 | Lyon | Iowa | 19119 | 445 | 5 |
603310 | 603310 | 2020-10-06 | Madison | Iowa | 19121 | 273 | 2 |
603311 | 603311 | 2020-10-06 | Mahaska | Iowa | 19123 | 463 | 21 |
603312 | 603312 | 2020-10-06 | Marion | Iowa | 19125 | 817 | 9 |
603313 | 603313 | 2020-10-06 | Marshall | Iowa | 19127 | 1833 | 35 |
603314 | 603314 | 2020-10-06 | Mills | Iowa | 19129 | 236 | 1 |
603315 | 603315 | 2020-10-06 | Mitchell | Iowa | 19131 | 202 | 0 |
603316 | 603316 | 2020-10-06 | Monona | Iowa | 19133 | 180 | 1 |
603317 | 603317 | 2020-10-06 | Monroe | Iowa | 19135 | 171 | 11 |
603318 | 603318 | 2020-10-06 | Montgomery | Iowa | 19137 | 114 | 5 |
603319 | 603319 | 2020-10-06 | Muscatine | Iowa | 19139 | 1172 | 56 |
603320 | 603320 | 2020-10-06 | O'Brien | Iowa | 19141 | 471 | 9 |
603321 | 603321 | 2020-10-06 | Osceola | Iowa | 19143 | 188 | 0 |
603322 | 603322 | 2020-10-06 | Page | Iowa | 19145 | 247 | 0 |
603323 | 603323 | 2020-10-06 | Palo Alto | Iowa | 19147 | 241 | 0 |
603324 | 603324 | 2020-10-06 | Plymouth | Iowa | 19149 | 1281 | 23 |
603325 | 603325 | 2020-10-06 | Pocahontas | Iowa | 19151 | 180 | 2 |
603326 | 603326 | 2020-10-06 | Polk | Iowa | 19153 | 16587 | 271 |
603327 | 603327 | 2020-10-06 | Pottawattamie | Iowa | 19155 | 2372 | 41 |
603328 | 603328 | 2020-10-06 | Poweshiek | Iowa | 19157 | 359 | 10 |
603329 | 603329 | 2020-10-06 | Ringgold | Iowa | 19159 | 59 | 2 |
603330 | 603330 | 2020-10-06 | Sac | Iowa | 19161 | 298 | 0 |
603331 | 603331 | 2020-10-06 | Scott | Iowa | 19163 | 3362 | 29 |
603332 | 603332 | 2020-10-06 | Shelby | Iowa | 19165 | 291 | 1 |
603333 | 603333 | 2020-10-06 | Sioux | Iowa | 19167 | 1910 | 6 |
603334 | 603334 | 2020-10-06 | Story | Iowa | 19169 | 3595 | 17 |
603335 | 603335 | 2020-10-06 | Tama | Iowa | 19171 | 810 | 34 |
603336 | 603336 | 2020-10-06 | Taylor | Iowa | 19173 | 167 | 1 |
603337 | 603337 | 2020-10-06 | Union | Iowa | 19175 | 158 | 3 |
603338 | 603338 | 2020-10-06 | Unknown | Iowa | 2 | 0 | |
603339 | 603339 | 2020-10-06 | Van Buren | Iowa | 19177 | 129 | 1 |
603340 | 603340 | 2020-10-06 | Wapello | Iowa | 19179 | 1393 | 58 |
603341 | 603341 | 2020-10-06 | Warren | Iowa | 19181 | 1004 | 6 |
603342 | 603342 | 2020-10-06 | Washington | Iowa | 19183 | 531 | 11 |
603343 | 603343 | 2020-10-06 | Wayne | Iowa | 19185 | 94 | 3 |
603344 | 603344 | 2020-10-06 | Webster | Iowa | 19187 | 1400 | 14 |
603345 | 603345 | 2020-10-06 | Winnebago | Iowa | 19189 | 345 | 14 |
603346 | 603346 | 2020-10-06 | Winneshiek | Iowa | 19191 | 362 | 8 |
603347 | 603347 | 2020-10-06 | Woodbury | Iowa | 19193 | 6018 | 74 |
603348 | 603348 | 2020-10-06 | Worth | Iowa | 19195 | 118 | 0 |
603349 | 603349 | 2020-10-06 | Wright | Iowa | 19197 | 623 | 1 |
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);