ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where date = "2020-03-30" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
fips >30
county >30
- Adair 1
- Allamakee 1
- Appanoose 1
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Buchanan 1
- Butler 1
- Carroll 1
- Cedar 1
- Cerro Gordo 1
- Clayton 1
- Clinton 1
- Crawford 1
- Dallas 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Fayette 1
- Guthrie 1
- Hancock 1
- Hardin 1
- Harrison 1
- Henry 1
- Iowa 1
- Jackson 1
- Jasper 1
- Johnson 1
- Jones 1
- …
state 1
- Iowa · 56 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20246 | 20246 | 2020-03-30 | Adair | Iowa | 19001 | 1 | 0 |
20247 | 20247 | 2020-03-30 | Allamakee | Iowa | 19005 | 7 | 1 |
20248 | 20248 | 2020-03-30 | Appanoose | Iowa | 19007 | 1 | 0 |
20249 | 20249 | 2020-03-30 | Audubon | Iowa | 19009 | 1 | 0 |
20250 | 20250 | 2020-03-30 | Benton | Iowa | 19011 | 7 | 0 |
20251 | 20251 | 2020-03-30 | Black Hawk | Iowa | 19013 | 6 | 0 |
20252 | 20252 | 2020-03-30 | Boone | Iowa | 19015 | 1 | 0 |
20253 | 20253 | 2020-03-30 | Buchanan | Iowa | 19019 | 2 | 0 |
20254 | 20254 | 2020-03-30 | Butler | Iowa | 19023 | 1 | 0 |
20255 | 20255 | 2020-03-30 | Carroll | Iowa | 19027 | 1 | 0 |
20256 | 20256 | 2020-03-30 | Cedar | Iowa | 19031 | 8 | 0 |
20257 | 20257 | 2020-03-30 | Cerro Gordo | Iowa | 19033 | 7 | 0 |
20258 | 20258 | 2020-03-30 | Clayton | Iowa | 19043 | 1 | 0 |
20259 | 20259 | 2020-03-30 | Clinton | Iowa | 19045 | 2 | 0 |
20260 | 20260 | 2020-03-30 | Crawford | Iowa | 19047 | 1 | 0 |
20261 | 20261 | 2020-03-30 | Dallas | Iowa | 19049 | 21 | 0 |
20262 | 20262 | 2020-03-30 | Des Moines | Iowa | 19057 | 1 | 0 |
20263 | 20263 | 2020-03-30 | Dickinson | Iowa | 19059 | 1 | 0 |
20264 | 20264 | 2020-03-30 | Dubuque | Iowa | 19061 | 21 | 1 |
20265 | 20265 | 2020-03-30 | Fayette | Iowa | 19065 | 2 | 0 |
20266 | 20266 | 2020-03-30 | Guthrie | Iowa | 19077 | 1 | 0 |
20267 | 20267 | 2020-03-30 | Hancock | Iowa | 19081 | 3 | 0 |
20268 | 20268 | 2020-03-30 | Hardin | Iowa | 19083 | 1 | 0 |
20269 | 20269 | 2020-03-30 | Harrison | Iowa | 19085 | 8 | 0 |
20270 | 20270 | 2020-03-30 | Henry | Iowa | 19087 | 3 | 0 |
20271 | 20271 | 2020-03-30 | Iowa | Iowa | 19095 | 3 | 0 |
20272 | 20272 | 2020-03-30 | Jackson | Iowa | 19097 | 1 | 0 |
20273 | 20273 | 2020-03-30 | Jasper | Iowa | 19099 | 5 | 0 |
20274 | 20274 | 2020-03-30 | Johnson | Iowa | 19103 | 70 | 0 |
20275 | 20275 | 2020-03-30 | Jones | Iowa | 19105 | 1 | 0 |
20276 | 20276 | 2020-03-30 | Keokuk | Iowa | 19107 | 1 | 0 |
20277 | 20277 | 2020-03-30 | Kossuth | Iowa | 19109 | 1 | 0 |
20278 | 20278 | 2020-03-30 | Linn | Iowa | 19113 | 71 | 2 |
20279 | 20279 | 2020-03-30 | Mahaska | Iowa | 19123 | 2 | 0 |
20280 | 20280 | 2020-03-30 | Marshall | Iowa | 19127 | 6 | 0 |
20281 | 20281 | 2020-03-30 | Monona | Iowa | 19133 | 5 | 0 |
20282 | 20282 | 2020-03-30 | Montgomery | Iowa | 19137 | 1 | 0 |
20283 | 20283 | 2020-03-30 | Muscatine | Iowa | 19139 | 13 | 0 |
20284 | 20284 | 2020-03-30 | Page | Iowa | 19145 | 2 | 0 |
20285 | 20285 | 2020-03-30 | Polk | Iowa | 19153 | 61 | 0 |
20286 | 20286 | 2020-03-30 | Pottawattamie | Iowa | 19155 | 3 | 0 |
20287 | 20287 | 2020-03-30 | Poweshiek | Iowa | 19157 | 5 | 1 |
20288 | 20288 | 2020-03-30 | Scott | Iowa | 19163 | 16 | 0 |
20289 | 20289 | 2020-03-30 | Shelby | Iowa | 19165 | 3 | 0 |
20290 | 20290 | 2020-03-30 | Sioux | Iowa | 19167 | 2 | 0 |
20291 | 20291 | 2020-03-30 | Story | Iowa | 19169 | 2 | 0 |
20292 | 20292 | 2020-03-30 | Tama | Iowa | 19171 | 10 | 0 |
20293 | 20293 | 2020-03-30 | Taylor | Iowa | 19173 | 1 | 0 |
20294 | 20294 | 2020-03-30 | Van Buren | Iowa | 19177 | 1 | 0 |
20295 | 20295 | 2020-03-30 | Wapello | Iowa | 19179 | 1 | 0 |
20296 | 20296 | 2020-03-30 | Warren | Iowa | 19181 | 1 | 0 |
20297 | 20297 | 2020-03-30 | Washington | Iowa | 19183 | 18 | 1 |
20298 | 20298 | 2020-03-30 | Webster | Iowa | 19187 | 1 | 0 |
20299 | 20299 | 2020-03-30 | Winneshiek | Iowa | 19191 | 3 | 0 |
20300 | 20300 | 2020-03-30 | Woodbury | Iowa | 19193 | 4 | 0 |
20301 | 20301 | 2020-03-30 | 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);