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 2020-06-08 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
219194 | 219194 | 2020-06-08 | Adair | Iowa | 19001 | 9 | 0 |
219195 | 219195 | 2020-06-08 | Adams | Iowa | 19003 | 7 | 0 |
219196 | 219196 | 2020-06-08 | Allamakee | Iowa | 19005 | 120 | 4 |
219197 | 219197 | 2020-06-08 | Appanoose | Iowa | 19007 | 16 | 3 |
219198 | 219198 | 2020-06-08 | Audubon | Iowa | 19009 | 13 | 1 |
219199 | 219199 | 2020-06-08 | Benton | Iowa | 19011 | 46 | 1 |
219200 | 219200 | 2020-06-08 | Black Hawk | Iowa | 19013 | 1801 | 51 |
219201 | 219201 | 2020-06-08 | Boone | Iowa | 19015 | 78 | 0 |
219202 | 219202 | 2020-06-08 | Bremer | Iowa | 19017 | 74 | 6 |
219203 | 219203 | 2020-06-08 | Buchanan | Iowa | 19019 | 34 | 1 |
219204 | 219204 | 2020-06-08 | Buena Vista | Iowa | 19021 | 1221 | 4 |
219205 | 219205 | 2020-06-08 | Butler | Iowa | 19023 | 16 | 1 |
219206 | 219206 | 2020-06-08 | Calhoun | Iowa | 19025 | 13 | 0 |
219207 | 219207 | 2020-06-08 | Carroll | Iowa | 19027 | 17 | 1 |
219208 | 219208 | 2020-06-08 | Cass | Iowa | 19029 | 13 | 0 |
219209 | 219209 | 2020-06-08 | Cedar | Iowa | 19031 | 53 | 1 |
219210 | 219210 | 2020-06-08 | Cerro Gordo | Iowa | 19033 | 32 | 1 |
219211 | 219211 | 2020-06-08 | Cherokee | Iowa | 19035 | 46 | 0 |
219212 | 219212 | 2020-06-08 | Chickasaw | Iowa | 19037 | 15 | 0 |
219213 | 219213 | 2020-06-08 | Clarke | Iowa | 19039 | 76 | 1 |
219214 | 219214 | 2020-06-08 | Clay | Iowa | 19041 | 35 | 0 |
219215 | 219215 | 2020-06-08 | Clayton | Iowa | 19043 | 34 | 3 |
219216 | 219216 | 2020-06-08 | Clinton | Iowa | 19045 | 67 | 1 |
219217 | 219217 | 2020-06-08 | Crawford | Iowa | 19047 | 576 | 2 |
219218 | 219218 | 2020-06-08 | Dallas | Iowa | 19049 | 962 | 26 |
219219 | 219219 | 2020-06-08 | Davis | Iowa | 19051 | 29 | 1 |
219220 | 219220 | 2020-06-08 | Decatur | Iowa | 19053 | 3 | 0 |
219221 | 219221 | 2020-06-08 | Delaware | Iowa | 19055 | 20 | 1 |
219222 | 219222 | 2020-06-08 | Des Moines | Iowa | 19057 | 68 | 2 |
219223 | 219223 | 2020-06-08 | Dickinson | Iowa | 19059 | 61 | 0 |
219224 | 219224 | 2020-06-08 | Dubuque | Iowa | 19061 | 370 | 21 |
219225 | 219225 | 2020-06-08 | Emmet | Iowa | 19063 | 34 | 0 |
219226 | 219226 | 2020-06-08 | Fayette | Iowa | 19065 | 28 | 0 |
219227 | 219227 | 2020-06-08 | Floyd | Iowa | 19067 | 19 | 1 |
219228 | 219228 | 2020-06-08 | Franklin | Iowa | 19069 | 34 | 0 |
219229 | 219229 | 2020-06-08 | Fremont | Iowa | 19071 | 4 | 0 |
219230 | 219230 | 2020-06-08 | Greene | Iowa | 19073 | 14 | 0 |
219231 | 219231 | 2020-06-08 | Grundy | Iowa | 19075 | 20 | 0 |
219232 | 219232 | 2020-06-08 | Guthrie | Iowa | 19077 | 55 | 3 |
219233 | 219233 | 2020-06-08 | Hamilton | Iowa | 19079 | 91 | 0 |
219234 | 219234 | 2020-06-08 | Hancock | Iowa | 19081 | 22 | 0 |
219235 | 219235 | 2020-06-08 | Hardin | Iowa | 19083 | 33 | 0 |
219236 | 219236 | 2020-06-08 | Harrison | Iowa | 19085 | 27 | 0 |
219237 | 219237 | 2020-06-08 | Henry | Iowa | 19087 | 73 | 2 |
219238 | 219238 | 2020-06-08 | Howard | Iowa | 19089 | 12 | 0 |
219239 | 219239 | 2020-06-08 | Humboldt | Iowa | 19091 | 24 | 1 |
219240 | 219240 | 2020-06-08 | Ida | Iowa | 19093 | 15 | 0 |
219241 | 219241 | 2020-06-08 | Iowa | Iowa | 19095 | 33 | 0 |
219242 | 219242 | 2020-06-08 | Jackson | Iowa | 19097 | 14 | 0 |
219243 | 219243 | 2020-06-08 | Jasper | Iowa | 19099 | 273 | 17 |
219244 | 219244 | 2020-06-08 | Jefferson | Iowa | 19101 | 38 | 0 |
219245 | 219245 | 2020-06-08 | Johnson | Iowa | 19103 | 627 | 8 |
219246 | 219246 | 2020-06-08 | Jones | Iowa | 19105 | 38 | 0 |
219247 | 219247 | 2020-06-08 | Keokuk | Iowa | 19107 | 16 | 0 |
219248 | 219248 | 2020-06-08 | Kossuth | Iowa | 19109 | 16 | 0 |
219249 | 219249 | 2020-06-08 | Lee | Iowa | 19111 | 32 | 0 |
219250 | 219250 | 2020-06-08 | Linn | Iowa | 19113 | 1000 | 80 |
219251 | 219251 | 2020-06-08 | Louisa | Iowa | 19115 | 350 | 11 |
219252 | 219252 | 2020-06-08 | Lucas | Iowa | 19117 | 22 | 2 |
219253 | 219253 | 2020-06-08 | Lyon | Iowa | 19119 | 26 | 0 |
219254 | 219254 | 2020-06-08 | Madison | Iowa | 19121 | 29 | 2 |
219255 | 219255 | 2020-06-08 | Mahaska | Iowa | 19123 | 102 | 14 |
219256 | 219256 | 2020-06-08 | Marion | Iowa | 19125 | 36 | 0 |
219257 | 219257 | 2020-06-08 | Marshall | Iowa | 19127 | 930 | 18 |
219258 | 219258 | 2020-06-08 | Mills | Iowa | 19129 | 21 | 0 |
219259 | 219259 | 2020-06-08 | Mitchell | Iowa | 19131 | 5 | 0 |
219260 | 219260 | 2020-06-08 | Monona | Iowa | 19133 | 27 | 0 |
219261 | 219261 | 2020-06-08 | Monroe | Iowa | 19135 | 44 | 6 |
219262 | 219262 | 2020-06-08 | Montgomery | Iowa | 19137 | 9 | 2 |
219263 | 219263 | 2020-06-08 | Muscatine | Iowa | 19139 | 566 | 41 |
219264 | 219264 | 2020-06-08 | O'Brien | Iowa | 19141 | 54 | 0 |
219265 | 219265 | 2020-06-08 | Osceola | Iowa | 19143 | 41 | 0 |
219266 | 219266 | 2020-06-08 | Page | Iowa | 19145 | 16 | 0 |
219267 | 219267 | 2020-06-08 | Palo Alto | Iowa | 19147 | 8 | 0 |
219268 | 219268 | 2020-06-08 | Plymouth | Iowa | 19149 | 172 | 4 |
219269 | 219269 | 2020-06-08 | Pocahontas | Iowa | 19151 | 21 | 0 |
219270 | 219270 | 2020-06-08 | Polk | Iowa | 19153 | 4841 | 150 |
219271 | 219271 | 2020-06-08 | Pottawattamie | Iowa | 19155 | 382 | 10 |
219272 | 219272 | 2020-06-08 | Poweshiek | Iowa | 19157 | 94 | 8 |
219273 | 219273 | 2020-06-08 | Ringgold | Iowa | 19159 | 6 | 0 |
219274 | 219274 | 2020-06-08 | Sac | Iowa | 19161 | 31 | 0 |
219275 | 219275 | 2020-06-08 | Scott | Iowa | 19163 | 393 | 10 |
219276 | 219276 | 2020-06-08 | Shelby | Iowa | 19165 | 39 | 0 |
219277 | 219277 | 2020-06-08 | Sioux | Iowa | 19167 | 322 | 0 |
219278 | 219278 | 2020-06-08 | Story | Iowa | 19169 | 156 | 2 |
219279 | 219279 | 2020-06-08 | Tama | Iowa | 19171 | 417 | 29 |
219280 | 219280 | 2020-06-08 | Taylor | Iowa | 19173 | 68 | 0 |
219281 | 219281 | 2020-06-08 | Union | Iowa | 19175 | 11 | 0 |
219282 | 219282 | 2020-06-08 | Unknown | Iowa | 7 | 0 | |
219283 | 219283 | 2020-06-08 | Van Buren | Iowa | 19177 | 10 | 0 |
219284 | 219284 | 2020-06-08 | Wapello | Iowa | 19179 | 654 | 21 |
219285 | 219285 | 2020-06-08 | Warren | Iowa | 19181 | 174 | 1 |
219286 | 219286 | 2020-06-08 | Washington | Iowa | 19183 | 200 | 9 |
219287 | 219287 | 2020-06-08 | Wayne | Iowa | 19185 | 2 | 0 |
219288 | 219288 | 2020-06-08 | Webster | Iowa | 19187 | 85 | 1 |
219289 | 219289 | 2020-06-08 | Winnebago | Iowa | 19189 | 12 | 0 |
219290 | 219290 | 2020-06-08 | Winneshiek | Iowa | 19191 | 24 | 0 |
219291 | 219291 | 2020-06-08 | Woodbury | Iowa | 19193 | 2939 | 37 |
219292 | 219292 | 2020-06-08 | Worth | Iowa | 19195 | 4 | 0 |
219293 | 219293 | 2020-06-08 | Wright | Iowa | 19197 | 244 | 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);