ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where "date" is on date 2020-05-25 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adair 1
- Adams 1
- Allamakee 1
- Appanoose 1
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Bremer 1
- Buchanan 1
- Buena Vista 1
- Butler 1
- Calhoun 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
- Davis 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- …
state 1
- Iowa · 99 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
176218 | 176218 | 2020-05-25 | Adair | Iowa | 19001 | 8 | 0 |
176219 | 176219 | 2020-05-25 | Adams | Iowa | 19003 | 5 | 0 |
176220 | 176220 | 2020-05-25 | Allamakee | Iowa | 19005 | 118 | 4 |
176221 | 176221 | 2020-05-25 | Appanoose | Iowa | 19007 | 12 | 3 |
176222 | 176222 | 2020-05-25 | Audubon | Iowa | 19009 | 12 | 1 |
176223 | 176223 | 2020-05-25 | Benton | Iowa | 19011 | 37 | 1 |
176224 | 176224 | 2020-05-25 | Black Hawk | Iowa | 19013 | 1686 | 39 |
176225 | 176225 | 2020-05-25 | Boone | Iowa | 19015 | 55 | 0 |
176226 | 176226 | 2020-05-25 | Bremer | Iowa | 19017 | 67 | 6 |
176227 | 176227 | 2020-05-25 | Buchanan | Iowa | 19019 | 32 | 0 |
176228 | 176228 | 2020-05-25 | Buena Vista | Iowa | 19021 | 246 | 0 |
176229 | 176229 | 2020-05-25 | Butler | Iowa | 19023 | 15 | 0 |
176230 | 176230 | 2020-05-25 | Calhoun | Iowa | 19025 | 3 | 0 |
176231 | 176231 | 2020-05-25 | Carroll | Iowa | 19027 | 9 | 0 |
176232 | 176232 | 2020-05-25 | Cass | Iowa | 19029 | 11 | 0 |
176233 | 176233 | 2020-05-25 | Cedar | Iowa | 19031 | 46 | 1 |
176234 | 176234 | 2020-05-25 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
176235 | 176235 | 2020-05-25 | Cherokee | Iowa | 19035 | 18 | 0 |
176236 | 176236 | 2020-05-25 | Chickasaw | Iowa | 19037 | 8 | 0 |
176237 | 176237 | 2020-05-25 | Clarke | Iowa | 19039 | 34 | 0 |
176238 | 176238 | 2020-05-25 | Clay | Iowa | 19041 | 10 | 0 |
176239 | 176239 | 2020-05-25 | Clayton | Iowa | 19043 | 30 | 3 |
176240 | 176240 | 2020-05-25 | Clinton | Iowa | 19045 | 60 | 1 |
176241 | 176241 | 2020-05-25 | Crawford | Iowa | 19047 | 486 | 2 |
176242 | 176242 | 2020-05-25 | Dallas | Iowa | 19049 | 865 | 15 |
176243 | 176243 | 2020-05-25 | Davis | Iowa | 19051 | 20 | 0 |
176244 | 176244 | 2020-05-25 | Delaware | Iowa | 19055 | 15 | 0 |
176245 | 176245 | 2020-05-25 | Des Moines | Iowa | 19057 | 56 | 1 |
176246 | 176246 | 2020-05-25 | Dickinson | Iowa | 19059 | 9 | 0 |
176247 | 176247 | 2020-05-25 | Dubuque | Iowa | 19061 | 324 | 16 |
176248 | 176248 | 2020-05-25 | Emmet | Iowa | 19063 | 7 | 0 |
176249 | 176249 | 2020-05-25 | Fayette | Iowa | 19065 | 26 | 0 |
176250 | 176250 | 2020-05-25 | Floyd | Iowa | 19067 | 18 | 1 |
176251 | 176251 | 2020-05-25 | Franklin | Iowa | 19069 | 8 | 0 |
176252 | 176252 | 2020-05-25 | Fremont | Iowa | 19071 | 4 | 0 |
176253 | 176253 | 2020-05-25 | Greene | Iowa | 19073 | 13 | 0 |
176254 | 176254 | 2020-05-25 | Grundy | Iowa | 19075 | 19 | 0 |
176255 | 176255 | 2020-05-25 | Guthrie | Iowa | 19077 | 43 | 3 |
176256 | 176256 | 2020-05-25 | Hamilton | Iowa | 19079 | 26 | 0 |
176257 | 176257 | 2020-05-25 | Hancock | Iowa | 19081 | 13 | 0 |
176258 | 176258 | 2020-05-25 | Hardin | Iowa | 19083 | 13 | 0 |
176259 | 176259 | 2020-05-25 | Harrison | Iowa | 19085 | 19 | 0 |
176260 | 176260 | 2020-05-25 | Henry | Iowa | 19087 | 63 | 1 |
176261 | 176261 | 2020-05-25 | Howard | Iowa | 19089 | 12 | 0 |
176262 | 176262 | 2020-05-25 | Humboldt | Iowa | 19091 | 13 | 0 |
176263 | 176263 | 2020-05-25 | Ida | Iowa | 19093 | 13 | 0 |
176264 | 176264 | 2020-05-25 | Iowa | Iowa | 19095 | 33 | 0 |
176265 | 176265 | 2020-05-25 | Jackson | Iowa | 19097 | 12 | 0 |
176266 | 176266 | 2020-05-25 | Jasper | Iowa | 19099 | 256 | 16 |
176267 | 176267 | 2020-05-25 | Jefferson | Iowa | 19101 | 18 | 0 |
176268 | 176268 | 2020-05-25 | Johnson | Iowa | 19103 | 603 | 7 |
176269 | 176269 | 2020-05-25 | Jones | Iowa | 19105 | 36 | 0 |
176270 | 176270 | 2020-05-25 | Keokuk | Iowa | 19107 | 14 | 0 |
176271 | 176271 | 2020-05-25 | Kossuth | Iowa | 19109 | 7 | 0 |
176272 | 176272 | 2020-05-25 | Lee | Iowa | 19111 | 23 | 0 |
176273 | 176273 | 2020-05-25 | Linn | Iowa | 19113 | 935 | 75 |
176274 | 176274 | 2020-05-25 | Louisa | Iowa | 19115 | 335 | 7 |
176275 | 176275 | 2020-05-25 | Lucas | Iowa | 19117 | 6 | 0 |
176276 | 176276 | 2020-05-25 | Lyon | Iowa | 19119 | 19 | 0 |
176277 | 176277 | 2020-05-25 | Madison | Iowa | 19121 | 24 | 1 |
176278 | 176278 | 2020-05-25 | Mahaska | Iowa | 19123 | 85 | 7 |
176279 | 176279 | 2020-05-25 | Marion | Iowa | 19125 | 30 | 0 |
176280 | 176280 | 2020-05-25 | Marshall | Iowa | 19127 | 870 | 11 |
176281 | 176281 | 2020-05-25 | Mills | Iowa | 19129 | 16 | 0 |
176282 | 176282 | 2020-05-25 | Mitchell | Iowa | 19131 | 4 | 0 |
176283 | 176283 | 2020-05-25 | Monona | Iowa | 19133 | 24 | 0 |
176284 | 176284 | 2020-05-25 | Monroe | Iowa | 19135 | 33 | 4 |
176285 | 176285 | 2020-05-25 | Montgomery | Iowa | 19137 | 6 | 0 |
176286 | 176286 | 2020-05-25 | Muscatine | Iowa | 19139 | 545 | 39 |
176287 | 176287 | 2020-05-25 | O'Brien | Iowa | 19141 | 24 | 0 |
176288 | 176288 | 2020-05-25 | Osceola | Iowa | 19143 | 32 | 0 |
176289 | 176289 | 2020-05-25 | Page | Iowa | 19145 | 10 | 0 |
176290 | 176290 | 2020-05-25 | Palo Alto | Iowa | 19147 | 3 | 0 |
176291 | 176291 | 2020-05-25 | Plymouth | Iowa | 19149 | 117 | 0 |
176292 | 176292 | 2020-05-25 | Pocahontas | Iowa | 19151 | 4 | 0 |
176293 | 176293 | 2020-05-25 | Polk | Iowa | 19153 | 3795 | 109 |
176294 | 176294 | 2020-05-25 | Pottawattamie | Iowa | 19155 | 215 | 7 |
176295 | 176295 | 2020-05-25 | Poweshiek | Iowa | 19157 | 88 | 8 |
176296 | 176296 | 2020-05-25 | Ringgold | Iowa | 19159 | 4 | 0 |
176297 | 176297 | 2020-05-25 | Sac | Iowa | 19161 | 13 | 0 |
176298 | 176298 | 2020-05-25 | Scott | Iowa | 19163 | 338 | 9 |
176299 | 176299 | 2020-05-25 | Shelby | Iowa | 19165 | 31 | 0 |
176300 | 176300 | 2020-05-25 | Sioux | Iowa | 19167 | 207 | 0 |
176301 | 176301 | 2020-05-25 | Story | Iowa | 19169 | 95 | 1 |
176302 | 176302 | 2020-05-25 | Tama | Iowa | 19171 | 395 | 23 |
176303 | 176303 | 2020-05-25 | Taylor | Iowa | 19173 | 39 | 0 |
176304 | 176304 | 2020-05-25 | Union | Iowa | 19175 | 7 | 0 |
176305 | 176305 | 2020-05-25 | Unknown | Iowa | 6 | 0 | |
176306 | 176306 | 2020-05-25 | Van Buren | Iowa | 19177 | 10 | 0 |
176307 | 176307 | 2020-05-25 | Wapello | Iowa | 19179 | 514 | 4 |
176308 | 176308 | 2020-05-25 | Warren | Iowa | 19181 | 112 | 0 |
176309 | 176309 | 2020-05-25 | Washington | Iowa | 19183 | 184 | 8 |
176310 | 176310 | 2020-05-25 | Wayne | Iowa | 19185 | 1 | 0 |
176311 | 176311 | 2020-05-25 | Webster | Iowa | 19187 | 27 | 1 |
176312 | 176312 | 2020-05-25 | Winnebago | Iowa | 19189 | 10 | 0 |
176313 | 176313 | 2020-05-25 | Winneshiek | Iowa | 19191 | 23 | 0 |
176314 | 176314 | 2020-05-25 | Woodbury | Iowa | 19193 | 2635 | 24 |
176315 | 176315 | 2020-05-25 | Worth | Iowa | 19195 | 3 | 0 |
176316 | 176316 | 2020-05-25 | Wright | Iowa | 19197 | 123 | 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);