ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2022-02-23 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
- Decatur 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- …
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2243286 | 2243286 | 2022-02-23 | Adair | Iowa | 19001 | 1571 | 50 |
2243287 | 2243287 | 2022-02-23 | Adams | Iowa | 19003 | 812 | 13 |
2243288 | 2243288 | 2022-02-23 | Allamakee | Iowa | 19005 | 2831 | 59 |
2243289 | 2243289 | 2022-02-23 | Appanoose | Iowa | 19007 | 2863 | 65 |
2243290 | 2243290 | 2022-02-23 | Audubon | Iowa | 19009 | 1096 | 19 |
2243291 | 2243291 | 2022-02-23 | Benton | Iowa | 19011 | 5967 | 73 |
2243292 | 2243292 | 2022-02-23 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2243293 | 2243293 | 2022-02-23 | Boone | Iowa | 19015 | 5373 | 52 |
2243294 | 2243294 | 2022-02-23 | Bremer | Iowa | 19017 | 5442 | 79 |
2243295 | 2243295 | 2022-02-23 | Buchanan | Iowa | 19019 | 4540 | 56 |
2243296 | 2243296 | 2022-02-23 | Buena Vista | Iowa | 19021 | 6412 | 54 |
2243297 | 2243297 | 2022-02-23 | Butler | Iowa | 19023 | 3174 | 51 |
2243298 | 2243298 | 2022-02-23 | Calhoun | Iowa | 19025 | 2578 | 22 |
2243299 | 2243299 | 2022-02-23 | Carroll | Iowa | 19027 | 4899 | 64 |
2243300 | 2243300 | 2022-02-23 | Cass | Iowa | 19029 | 2934 | 75 |
2243301 | 2243301 | 2022-02-23 | Cedar | Iowa | 19031 | 4085 | 32 |
2243302 | 2243302 | 2022-02-23 | Cerro Gordo | Iowa | 19033 | 10938 | 157 |
2243303 | 2243303 | 2022-02-23 | Cherokee | Iowa | 19035 | 2945 | 60 |
2243304 | 2243304 | 2022-02-23 | Chickasaw | Iowa | 19037 | 2652 | 31 |
2243305 | 2243305 | 2022-02-23 | Clarke | Iowa | 19039 | 2238 | 35 |
2243306 | 2243306 | 2022-02-23 | Clay | Iowa | 19041 | 4056 | 40 |
2243307 | 2243307 | 2022-02-23 | Clayton | Iowa | 19043 | 3429 | 72 |
2243308 | 2243308 | 2022-02-23 | Clinton | Iowa | 19045 | 11417 | 140 |
2243309 | 2243309 | 2022-02-23 | Crawford | Iowa | 19047 | 4503 | 52 |
2243310 | 2243310 | 2022-02-23 | Dallas | Iowa | 19049 | 22456 | 134 |
2243311 | 2243311 | 2022-02-23 | Davis | Iowa | 19051 | 1584 | 29 |
2243312 | 2243312 | 2022-02-23 | Decatur | Iowa | 19053 | 1497 | 23 |
2243313 | 2243313 | 2022-02-23 | Delaware | Iowa | 19055 | 3970 | 68 |
2243314 | 2243314 | 2022-02-23 | Des Moines | Iowa | 19057 | 9014 | 128 |
2243315 | 2243315 | 2022-02-23 | Dickinson | Iowa | 19059 | 4111 | 71 |
2243316 | 2243316 | 2022-02-23 | Dubuque | Iowa | 19061 | 25671 | 291 |
2243317 | 2243317 | 2022-02-23 | Emmet | Iowa | 19063 | 2339 | 51 |
2243318 | 2243318 | 2022-02-23 | Fayette | Iowa | 19065 | 4038 | 71 |
2243319 | 2243319 | 2022-02-23 | Floyd | Iowa | 19067 | 3488 | 61 |
2243320 | 2243320 | 2022-02-23 | Franklin | Iowa | 19069 | 2492 | 40 |
2243321 | 2243321 | 2022-02-23 | Fremont | Iowa | 19071 | 1371 | 24 |
2243322 | 2243322 | 2022-02-23 | Greene | Iowa | 19073 | 1703 | 19 |
2243323 | 2243323 | 2022-02-23 | Grundy | Iowa | 19075 | 2530 | 40 |
2243324 | 2243324 | 2022-02-23 | Guthrie | Iowa | 19077 | 2322 | 43 |
2243325 | 2243325 | 2022-02-23 | Hamilton | Iowa | 19079 | 3464 | 70 |
2243326 | 2243326 | 2022-02-23 | Hancock | Iowa | 19081 | 2812 | 46 |
2243327 | 2243327 | 2022-02-23 | Hardin | Iowa | 19083 | 4084 | 58 |
2243328 | 2243328 | 2022-02-23 | Harrison | Iowa | 19085 | 3403 | 93 |
2243329 | 2243329 | 2022-02-23 | Henry | Iowa | 19087 | 5509 | 65 |
2243330 | 2243330 | 2022-02-23 | Howard | Iowa | 19089 | 2022 | 30 |
2243331 | 2243331 | 2022-02-23 | Humboldt | Iowa | 19091 | 2599 | 37 |
2243332 | 2243332 | 2022-02-23 | Ida | Iowa | 19093 | 1792 | 47 |
2243333 | 2243333 | 2022-02-23 | Iowa | Iowa | 19095 | 3646 | 47 |
2243334 | 2243334 | 2022-02-23 | Jackson | Iowa | 19097 | 4572 | 67 |
2243335 | 2243335 | 2022-02-23 | Jasper | Iowa | 19099 | 8549 | 103 |
2243336 | 2243336 | 2022-02-23 | Jefferson | Iowa | 19101 | 3439 | 50 |
2243337 | 2243337 | 2022-02-23 | Johnson | Iowa | 19103 | 33520 | 138 |
2243338 | 2243338 | 2022-02-23 | Jones | Iowa | 19105 | 5412 | 71 |
2243339 | 2243339 | 2022-02-23 | Keokuk | Iowa | 19107 | 2030 | 47 |
2243340 | 2243340 | 2022-02-23 | Kossuth | Iowa | 19109 | 3751 | 86 |
2243341 | 2243341 | 2022-02-23 | Lee | Iowa | 19111 | 7779 | 136 |
2243342 | 2243342 | 2022-02-23 | Linn | Iowa | 19113 | 51314 | 555 |
2243343 | 2243343 | 2022-02-23 | Louisa | Iowa | 19115 | 2463 | 60 |
2243344 | 2243344 | 2022-02-23 | Lucas | Iowa | 19117 | 1729 | 31 |
2243345 | 2243345 | 2022-02-23 | Lyon | Iowa | 19119 | 2716 | 48 |
2243346 | 2243346 | 2022-02-23 | Madison | Iowa | 19121 | 3101 | 35 |
2243347 | 2243347 | 2022-02-23 | Mahaska | Iowa | 19123 | 4853 | 84 |
2243348 | 2243348 | 2022-02-23 | Marion | Iowa | 19125 | 7469 | 117 |
2243349 | 2243349 | 2022-02-23 | Marshall | Iowa | 19127 | 9294 | 106 |
2243350 | 2243350 | 2022-02-23 | Mills | Iowa | 19129 | 3322 | 41 |
2243351 | 2243351 | 2022-02-23 | Mitchell | Iowa | 19131 | 2439 | 49 |
2243352 | 2243352 | 2022-02-23 | Monona | Iowa | 19133 | 1699 | 46 |
2243353 | 2243353 | 2022-02-23 | Monroe | Iowa | 19135 | 1867 | 48 |
2243354 | 2243354 | 2022-02-23 | Montgomery | Iowa | 19137 | 2183 | 52 |
2243355 | 2243355 | 2022-02-23 | Muscatine | Iowa | 19139 | 9453 | 129 |
2243356 | 2243356 | 2022-02-23 | O'Brien | Iowa | 19141 | 3396 | 70 |
2243357 | 2243357 | 2022-02-23 | Osceola | Iowa | 19143 | 1388 | 22 |
2243358 | 2243358 | 2022-02-23 | Page | Iowa | 19145 | 3321 | 44 |
2243359 | 2243359 | 2022-02-23 | Palo Alto | Iowa | 19147 | 2052 | 37 |
2243360 | 2243360 | 2022-02-23 | Plymouth | Iowa | 19149 | 6292 | 96 |
2243361 | 2243361 | 2022-02-23 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2243362 | 2243362 | 2022-02-23 | Polk | Iowa | 19153 | 120214 | 1038 |
2243363 | 2243363 | 2022-02-23 | Pottawattamie | Iowa | 19155 | 23993 | 301 |
2243364 | 2243364 | 2022-02-23 | Poweshiek | Iowa | 19157 | 3525 | 60 |
2243365 | 2243365 | 2022-02-23 | Ringgold | Iowa | 19159 | 1125 | 33 |
2243366 | 2243366 | 2022-02-23 | Sac | Iowa | 19161 | 2381 | 32 |
2243367 | 2243367 | 2022-02-23 | Scott | Iowa | 19163 | 40199 | 372 |
2243368 | 2243368 | 2022-02-23 | Shelby | Iowa | 19165 | 2694 | 50 |
2243369 | 2243369 | 2022-02-23 | Sioux | Iowa | 19167 | 7959 | 85 |
2243370 | 2243370 | 2022-02-23 | Story | Iowa | 19169 | 19444 | 81 |
2243371 | 2243371 | 2022-02-23 | Tama | Iowa | 19171 | 3813 | 86 |
2243372 | 2243372 | 2022-02-23 | Taylor | Iowa | 19173 | 1310 | 21 |
2243373 | 2243373 | 2022-02-23 | Union | Iowa | 19175 | 2695 | 49 |
2243374 | 2243374 | 2022-02-23 | Unknown | Iowa | 51 | 0 | |
2243375 | 2243375 | 2022-02-23 | Van Buren | Iowa | 19177 | 1370 | 26 |
2243376 | 2243376 | 2022-02-23 | Wapello | Iowa | 19179 | 8893 | 188 |
2243377 | 2243377 | 2022-02-23 | Warren | Iowa | 19181 | 12271 | 133 |
2243378 | 2243378 | 2022-02-23 | Washington | Iowa | 19183 | 5591 | 74 |
2243379 | 2243379 | 2022-02-23 | Wayne | Iowa | 19185 | 1250 | 33 |
2243380 | 2243380 | 2022-02-23 | Webster | Iowa | 19187 | 10254 | 153 |
2243381 | 2243381 | 2022-02-23 | Winnebago | Iowa | 19189 | 2927 | 44 |
2243382 | 2243382 | 2022-02-23 | Winneshiek | Iowa | 19191 | 3760 | 46 |
2243383 | 2243383 | 2022-02-23 | Woodbury | Iowa | 19193 | 28626 | 321 |
2243384 | 2243384 | 2022-02-23 | Worth | Iowa | 19195 | 1744 | 12 |
2243385 | 2243385 | 2022-02-23 | Wright | Iowa | 19197 | 3587 | 61 |
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);