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 192
- 19155 191
- 19027 188
- 19085 187
- 19049 186
- 19005 185
- 19153 185
- 19001 183
- 19013 183
- 19183 182
- 19191 182
- 19061 181
- 19139 181
- 19065 179
- 19087 179
- 19113 179
- 19169 179
- 19033 178
- 19109 178
- 19157 178
- 19163 178
- 19167 178
- 19171 178
- 19193 178
- 19081 177
- 19179 177
- 19019 176
- 19031 176
- 19099 176
- 19181 176
- …
county >30
- Johnson 192
- Pottawattamie 191
- Carroll 188
- Harrison 187
- Dallas 186
- Allamakee 185
- Polk 185
- Adair 183
- Black Hawk 183
- Washington 182
- Winneshiek 182
- Dubuque 181
- Muscatine 181
- Fayette 179
- Henry 179
- Linn 179
- Story 179
- Cerro Gordo 178
- Kossuth 178
- Poweshiek 178
- Scott 178
- Sioux 178
- Tama 178
- Woodbury 178
- Hancock 177
- Wapello 177
- Buchanan 176
- Cedar 176
- Jasper 176
- Warren 176
- …
state 1
- Iowa · 16,570 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535216 | 535216 | 2020-09-15 | Adair | Iowa | 19001 | 57 | 1 |
535217 | 535217 | 2020-09-15 | Adams | Iowa | 19003 | 27 | 0 |
535218 | 535218 | 2020-09-15 | Allamakee | Iowa | 19005 | 224 | 5 |
535219 | 535219 | 2020-09-15 | Appanoose | Iowa | 19007 | 116 | 3 |
535220 | 535220 | 2020-09-15 | Audubon | Iowa | 19009 | 46 | 1 |
535221 | 535221 | 2020-09-15 | Benton | Iowa | 19011 | 250 | 1 |
535222 | 535222 | 2020-09-15 | Black Hawk | Iowa | 19013 | 4218 | 83 |
535223 | 535223 | 2020-09-15 | Boone | Iowa | 19015 | 429 | 6 |
535224 | 535224 | 2020-09-15 | Bremer | Iowa | 19017 | 441 | 7 |
535225 | 535225 | 2020-09-15 | Buchanan | Iowa | 19019 | 211 | 1 |
535226 | 535226 | 2020-09-15 | Buena Vista | Iowa | 19021 | 1901 | 12 |
535227 | 535227 | 2020-09-15 | Butler | Iowa | 19023 | 247 | 2 |
535228 | 535228 | 2020-09-15 | Calhoun | Iowa | 19025 | 159 | 2 |
535229 | 535229 | 2020-09-15 | Carroll | Iowa | 19027 | 562 | 5 |
535230 | 535230 | 2020-09-15 | Cass | Iowa | 19029 | 122 | 2 |
535231 | 535231 | 2020-09-15 | Cedar | Iowa | 19031 | 205 | 1 |
535232 | 535232 | 2020-09-15 | Cerro Gordo | Iowa | 19033 | 961 | 21 |
535233 | 535233 | 2020-09-15 | Cherokee | Iowa | 19035 | 165 | 2 |
535234 | 535234 | 2020-09-15 | Chickasaw | Iowa | 19037 | 193 | 0 |
535235 | 535235 | 2020-09-15 | Clarke | Iowa | 19039 | 249 | 3 |
535236 | 535236 | 2020-09-15 | Clay | Iowa | 19041 | 261 | 3 |
535237 | 535237 | 2020-09-15 | Clayton | Iowa | 19043 | 217 | 3 |
535238 | 535238 | 2020-09-15 | Clinton | Iowa | 19045 | 1008 | 17 |
535239 | 535239 | 2020-09-15 | Crawford | Iowa | 19047 | 924 | 4 |
535240 | 535240 | 2020-09-15 | Dallas | Iowa | 19049 | 2613 | 38 |
535241 | 535241 | 2020-09-15 | Davis | Iowa | 19051 | 107 | 4 |
535242 | 535242 | 2020-09-15 | Decatur | Iowa | 19053 | 57 | 0 |
535243 | 535243 | 2020-09-15 | Delaware | Iowa | 19055 | 291 | 3 |
535244 | 535244 | 2020-09-15 | Des Moines | Iowa | 19057 | 707 | 7 |
535245 | 535245 | 2020-09-15 | Dickinson | Iowa | 19059 | 453 | 6 |
535246 | 535246 | 2020-09-15 | Dubuque | Iowa | 19061 | 2436 | 38 |
535247 | 535247 | 2020-09-15 | Emmet | Iowa | 19063 | 237 | 10 |
535248 | 535248 | 2020-09-15 | Fayette | Iowa | 19065 | 173 | 1 |
535249 | 535249 | 2020-09-15 | Floyd | Iowa | 19067 | 266 | 3 |
535250 | 535250 | 2020-09-15 | Franklin | Iowa | 19069 | 325 | 17 |
535251 | 535251 | 2020-09-15 | Fremont | Iowa | 19071 | 68 | 0 |
535252 | 535252 | 2020-09-15 | Greene | Iowa | 19073 | 72 | 0 |
535253 | 535253 | 2020-09-15 | Grundy | Iowa | 19075 | 190 | 2 |
535254 | 535254 | 2020-09-15 | Guthrie | Iowa | 19077 | 206 | 5 |
535255 | 535255 | 2020-09-15 | Hamilton | Iowa | 19079 | 311 | 3 |
535256 | 535256 | 2020-09-15 | Hancock | Iowa | 19081 | 170 | 2 |
535257 | 535257 | 2020-09-15 | Hardin | Iowa | 19083 | 262 | 1 |
535258 | 535258 | 2020-09-15 | Harrison | Iowa | 19085 | 164 | 2 |
535259 | 535259 | 2020-09-15 | Henry | Iowa | 19087 | 470 | 4 |
535260 | 535260 | 2020-09-15 | Howard | Iowa | 19089 | 175 | 4 |
535261 | 535261 | 2020-09-15 | Humboldt | Iowa | 19091 | 166 | 2 |
535262 | 535262 | 2020-09-15 | Ida | Iowa | 19093 | 76 | 0 |
535263 | 535263 | 2020-09-15 | Iowa | Iowa | 19095 | 163 | 1 |
535264 | 535264 | 2020-09-15 | Jackson | Iowa | 19097 | 266 | 3 |
535265 | 535265 | 2020-09-15 | Jasper | Iowa | 19099 | 694 | 32 |
535266 | 535266 | 2020-09-15 | Jefferson | Iowa | 19101 | 129 | 1 |
535267 | 535267 | 2020-09-15 | Johnson | Iowa | 19103 | 4858 | 27 |
535268 | 535268 | 2020-09-15 | Jones | Iowa | 19105 | 227 | 3 |
535269 | 535269 | 2020-09-15 | Keokuk | Iowa | 19107 | 82 | 1 |
535270 | 535270 | 2020-09-15 | Kossuth | Iowa | 19109 | 174 | 0 |
535271 | 535271 | 2020-09-15 | Lee | Iowa | 19111 | 562 | 6 |
535272 | 535272 | 2020-09-15 | Linn | Iowa | 19113 | 3570 | 101 |
535273 | 535273 | 2020-09-15 | Louisa | Iowa | 19115 | 409 | 14 |
535274 | 535274 | 2020-09-15 | Lucas | Iowa | 19117 | 122 | 6 |
535275 | 535275 | 2020-09-15 | Lyon | Iowa | 19119 | 201 | 3 |
535276 | 535276 | 2020-09-15 | Madison | Iowa | 19121 | 186 | 2 |
535277 | 535277 | 2020-09-15 | Mahaska | Iowa | 19123 | 298 | 19 |
535278 | 535278 | 2020-09-15 | Marion | Iowa | 19125 | 674 | 3 |
535279 | 535279 | 2020-09-15 | Marshall | Iowa | 19127 | 1743 | 32 |
535280 | 535280 | 2020-09-15 | Mills | Iowa | 19129 | 152 | 1 |
535281 | 535281 | 2020-09-15 | Mitchell | Iowa | 19131 | 169 | 0 |
535282 | 535282 | 2020-09-15 | Monona | Iowa | 19133 | 121 | 1 |
535283 | 535283 | 2020-09-15 | Monroe | Iowa | 19135 | 133 | 8 |
535284 | 535284 | 2020-09-15 | Montgomery | Iowa | 19137 | 84 | 5 |
535285 | 535285 | 2020-09-15 | Muscatine | Iowa | 19139 | 1045 | 52 |
535286 | 535286 | 2020-09-15 | O'Brien | Iowa | 19141 | 267 | 8 |
535287 | 535287 | 2020-09-15 | Osceola | Iowa | 19143 | 110 | 0 |
535288 | 535288 | 2020-09-15 | Page | Iowa | 19145 | 139 | 0 |
535289 | 535289 | 2020-09-15 | Palo Alto | Iowa | 19147 | 145 | 0 |
535290 | 535290 | 2020-09-15 | Plymouth | Iowa | 19149 | 938 | 20 |
535291 | 535291 | 2020-09-15 | Pocahontas | Iowa | 19151 | 146 | 2 |
535292 | 535292 | 2020-09-15 | Polk | Iowa | 19153 | 14830 | 253 |
535293 | 535293 | 2020-09-15 | Pottawattamie | Iowa | 19155 | 1848 | 36 |
535294 | 535294 | 2020-09-15 | Poweshiek | Iowa | 19157 | 221 | 8 |
535295 | 535295 | 2020-09-15 | Ringgold | Iowa | 19159 | 39 | 2 |
535296 | 535296 | 2020-09-15 | Sac | Iowa | 19161 | 157 | 0 |
535297 | 535297 | 2020-09-15 | Scott | Iowa | 19163 | 2550 | 26 |
535298 | 535298 | 2020-09-15 | Shelby | Iowa | 19165 | 234 | 1 |
535299 | 535299 | 2020-09-15 | Sioux | Iowa | 19167 | 1137 | 3 |
535300 | 535300 | 2020-09-15 | Story | Iowa | 19169 | 3175 | 17 |
535301 | 535301 | 2020-09-15 | Tama | Iowa | 19171 | 673 | 30 |
535302 | 535302 | 2020-09-15 | Taylor | Iowa | 19173 | 116 | 1 |
535303 | 535303 | 2020-09-15 | Union | Iowa | 19175 | 105 | 3 |
535304 | 535304 | 2020-09-15 | Unknown | Iowa | 19 | 0 | |
535305 | 535305 | 2020-09-15 | Van Buren | Iowa | 19177 | 108 | 1 |
535306 | 535306 | 2020-09-15 | Wapello | Iowa | 19179 | 1200 | 57 |
535307 | 535307 | 2020-09-15 | Warren | Iowa | 19181 | 911 | 6 |
535308 | 535308 | 2020-09-15 | Washington | Iowa | 19183 | 405 | 11 |
535309 | 535309 | 2020-09-15 | Wayne | Iowa | 19185 | 76 | 2 |
535310 | 535310 | 2020-09-15 | Webster | Iowa | 19187 | 1161 | 14 |
535311 | 535311 | 2020-09-15 | Winnebago | Iowa | 19189 | 220 | 10 |
535312 | 535312 | 2020-09-15 | Winneshiek | Iowa | 19191 | 268 | 5 |
535313 | 535313 | 2020-09-15 | Woodbury | Iowa | 19193 | 4633 | 59 |
535314 | 535314 | 2020-09-15 | Worth | Iowa | 19195 | 99 | 0 |
535315 | 535315 | 2020-09-15 | Wright | Iowa | 19197 | 542 | 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);