ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where "date" is on date 2020-03-29 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adair 1
- Allamakee 1
- Appanoose 1
- Benton 1
- Black Hawk 1
- Boone 1
- Buchanan 1
- Butler 1
- Carroll 1
- Cedar 1
- Cerro Gordo 1
- Clayton 1
- Clinton 1
- Dallas 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Fayette 1
- Hancock 1
- Hardin 1
- Harrison 1
- Henry 1
- Iowa 1
- Jasper 1
- Johnson 1
- Keokuk 1
- Kossuth 1
- Linn 1
- Mahaska 1
- Marshall 1
- …
state 1
- Iowa · 50 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
18240 | 18240 | 2020-03-29 | Adair | Iowa | 19001 | 1 | 0 |
18241 | 18241 | 2020-03-29 | Allamakee | Iowa | 19005 | 7 | 1 |
18242 | 18242 | 2020-03-29 | Appanoose | Iowa | 19007 | 1 | 0 |
18243 | 18243 | 2020-03-29 | Benton | Iowa | 19011 | 4 | 0 |
18244 | 18244 | 2020-03-29 | Black Hawk | Iowa | 19013 | 6 | 0 |
18245 | 18245 | 2020-03-29 | Boone | Iowa | 19015 | 1 | 0 |
18246 | 18246 | 2020-03-29 | Buchanan | Iowa | 19019 | 2 | 0 |
18247 | 18247 | 2020-03-29 | Butler | Iowa | 19023 | 1 | 0 |
18248 | 18248 | 2020-03-29 | Carroll | Iowa | 19027 | 1 | 0 |
18249 | 18249 | 2020-03-29 | Cedar | Iowa | 19031 | 7 | 0 |
18250 | 18250 | 2020-03-29 | Cerro Gordo | Iowa | 19033 | 6 | 0 |
18251 | 18251 | 2020-03-29 | Clayton | Iowa | 19043 | 1 | 0 |
18252 | 18252 | 2020-03-29 | Clinton | Iowa | 19045 | 1 | 0 |
18253 | 18253 | 2020-03-29 | Dallas | Iowa | 19049 | 17 | 0 |
18254 | 18254 | 2020-03-29 | Des Moines | Iowa | 19057 | 1 | 0 |
18255 | 18255 | 2020-03-29 | Dickinson | Iowa | 19059 | 1 | 0 |
18256 | 18256 | 2020-03-29 | Dubuque | Iowa | 19061 | 16 | 1 |
18257 | 18257 | 2020-03-29 | Fayette | Iowa | 19065 | 2 | 0 |
18258 | 18258 | 2020-03-29 | Hancock | Iowa | 19081 | 3 | 0 |
18259 | 18259 | 2020-03-29 | Hardin | Iowa | 19083 | 1 | 0 |
18260 | 18260 | 2020-03-29 | Harrison | Iowa | 19085 | 8 | 0 |
18261 | 18261 | 2020-03-29 | Henry | Iowa | 19087 | 3 | 0 |
18262 | 18262 | 2020-03-29 | Iowa | Iowa | 19095 | 2 | 0 |
18263 | 18263 | 2020-03-29 | Jasper | Iowa | 19099 | 4 | 0 |
18264 | 18264 | 2020-03-29 | Johnson | Iowa | 19103 | 65 | 0 |
18265 | 18265 | 2020-03-29 | Keokuk | Iowa | 19107 | 1 | 0 |
18266 | 18266 | 2020-03-29 | Kossuth | Iowa | 19109 | 1 | 0 |
18267 | 18267 | 2020-03-29 | Linn | Iowa | 19113 | 42 | 1 |
18268 | 18268 | 2020-03-29 | Mahaska | Iowa | 19123 | 2 | 0 |
18269 | 18269 | 2020-03-29 | Marshall | Iowa | 19127 | 6 | 0 |
18270 | 18270 | 2020-03-29 | Monona | Iowa | 19133 | 2 | 0 |
18271 | 18271 | 2020-03-29 | Montgomery | Iowa | 19137 | 1 | 0 |
18272 | 18272 | 2020-03-29 | Muscatine | Iowa | 19139 | 10 | 0 |
18273 | 18273 | 2020-03-29 | Page | Iowa | 19145 | 2 | 0 |
18274 | 18274 | 2020-03-29 | Polk | Iowa | 19153 | 50 | 0 |
18275 | 18275 | 2020-03-29 | Pottawattamie | Iowa | 19155 | 3 | 0 |
18276 | 18276 | 2020-03-29 | Poweshiek | Iowa | 19157 | 5 | 1 |
18277 | 18277 | 2020-03-29 | Scott | Iowa | 19163 | 10 | 0 |
18278 | 18278 | 2020-03-29 | Shelby | Iowa | 19165 | 1 | 0 |
18279 | 18279 | 2020-03-29 | Sioux | Iowa | 19167 | 2 | 0 |
18280 | 18280 | 2020-03-29 | Story | Iowa | 19169 | 2 | 0 |
18281 | 18281 | 2020-03-29 | Tama | Iowa | 19171 | 9 | 0 |
18282 | 18282 | 2020-03-29 | Taylor | Iowa | 19173 | 1 | 0 |
18283 | 18283 | 2020-03-29 | Wapello | Iowa | 19179 | 1 | 0 |
18284 | 18284 | 2020-03-29 | Warren | Iowa | 19181 | 1 | 0 |
18285 | 18285 | 2020-03-29 | Washington | Iowa | 19183 | 13 | 0 |
18286 | 18286 | 2020-03-29 | Webster | Iowa | 19187 | 1 | 0 |
18287 | 18287 | 2020-03-29 | Winneshiek | Iowa | 19191 | 3 | 0 |
18288 | 18288 | 2020-03-29 | Woodbury | Iowa | 19193 | 4 | 0 |
18289 | 18289 | 2020-03-29 | Wright | Iowa | 19197 | 1 | 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);