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-28 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 |
---|---|---|---|---|---|---|---|
16335 | 16335 | 2020-03-28 | Adair | Iowa | 19001 | 1 | 0 |
16336 | 16336 | 2020-03-28 | Allamakee | Iowa | 19005 | 7 | 1 |
16337 | 16337 | 2020-03-28 | Appanoose | Iowa | 19007 | 1 | 0 |
16338 | 16338 | 2020-03-28 | Benton | Iowa | 19011 | 4 | 0 |
16339 | 16339 | 2020-03-28 | Black Hawk | Iowa | 19013 | 6 | 0 |
16340 | 16340 | 2020-03-28 | Boone | Iowa | 19015 | 1 | 0 |
16341 | 16341 | 2020-03-28 | Buchanan | Iowa | 19019 | 2 | 0 |
16342 | 16342 | 2020-03-28 | Butler | Iowa | 19023 | 1 | 0 |
16343 | 16343 | 2020-03-28 | Carroll | Iowa | 19027 | 1 | 0 |
16344 | 16344 | 2020-03-28 | Cedar | Iowa | 19031 | 6 | 0 |
16345 | 16345 | 2020-03-28 | Cerro Gordo | Iowa | 19033 | 4 | 0 |
16346 | 16346 | 2020-03-28 | Clayton | Iowa | 19043 | 1 | 0 |
16347 | 16347 | 2020-03-28 | Clinton | Iowa | 19045 | 1 | 0 |
16348 | 16348 | 2020-03-28 | Dallas | Iowa | 19049 | 15 | 0 |
16349 | 16349 | 2020-03-28 | Des Moines | Iowa | 19057 | 1 | 0 |
16350 | 16350 | 2020-03-28 | Dickinson | Iowa | 19059 | 1 | 0 |
16351 | 16351 | 2020-03-28 | Dubuque | Iowa | 19061 | 12 | 1 |
16352 | 16352 | 2020-03-28 | Fayette | Iowa | 19065 | 2 | 0 |
16353 | 16353 | 2020-03-28 | Hancock | Iowa | 19081 | 3 | 0 |
16354 | 16354 | 2020-03-28 | Hardin | Iowa | 19083 | 1 | 0 |
16355 | 16355 | 2020-03-28 | Harrison | Iowa | 19085 | 8 | 0 |
16356 | 16356 | 2020-03-28 | Henry | Iowa | 19087 | 2 | 0 |
16357 | 16357 | 2020-03-28 | Iowa | Iowa | 19095 | 1 | 0 |
16358 | 16358 | 2020-03-28 | Jasper | Iowa | 19099 | 3 | 0 |
16359 | 16359 | 2020-03-28 | Johnson | Iowa | 19103 | 61 | 0 |
16360 | 16360 | 2020-03-28 | Keokuk | Iowa | 19107 | 1 | 0 |
16361 | 16361 | 2020-03-28 | Kossuth | Iowa | 19109 | 1 | 0 |
16362 | 16362 | 2020-03-28 | Linn | Iowa | 19113 | 36 | 0 |
16363 | 16363 | 2020-03-28 | Mahaska | Iowa | 19123 | 2 | 0 |
16364 | 16364 | 2020-03-28 | Marshall | Iowa | 19127 | 5 | 0 |
16365 | 16365 | 2020-03-28 | Monona | Iowa | 19133 | 2 | 0 |
16366 | 16366 | 2020-03-28 | Montgomery | Iowa | 19137 | 1 | 0 |
16367 | 16367 | 2020-03-28 | Muscatine | Iowa | 19139 | 10 | 0 |
16368 | 16368 | 2020-03-28 | Page | Iowa | 19145 | 2 | 0 |
16369 | 16369 | 2020-03-28 | Polk | Iowa | 19153 | 40 | 0 |
16370 | 16370 | 2020-03-28 | Pottawattamie | Iowa | 19155 | 3 | 0 |
16371 | 16371 | 2020-03-28 | Poweshiek | Iowa | 19157 | 5 | 1 |
16372 | 16372 | 2020-03-28 | Scott | Iowa | 19163 | 10 | 0 |
16373 | 16373 | 2020-03-28 | Shelby | Iowa | 19165 | 1 | 0 |
16374 | 16374 | 2020-03-28 | Sioux | Iowa | 19167 | 2 | 0 |
16375 | 16375 | 2020-03-28 | Story | Iowa | 19169 | 2 | 0 |
16376 | 16376 | 2020-03-28 | Tama | Iowa | 19171 | 8 | 0 |
16377 | 16377 | 2020-03-28 | Taylor | Iowa | 19173 | 1 | 0 |
16378 | 16378 | 2020-03-28 | Wapello | Iowa | 19179 | 1 | 0 |
16379 | 16379 | 2020-03-28 | Warren | Iowa | 19181 | 1 | 0 |
16380 | 16380 | 2020-03-28 | Washington | Iowa | 19183 | 11 | 0 |
16381 | 16381 | 2020-03-28 | Webster | Iowa | 19187 | 1 | 0 |
16382 | 16382 | 2020-03-28 | Winneshiek | Iowa | 19191 | 2 | 0 |
16383 | 16383 | 2020-03-28 | Woodbury | Iowa | 19193 | 3 | 0 |
16384 | 16384 | 2020-03-28 | 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);