ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where "date" is on date 2020-03-26 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
- Buchanan 1
- Carroll 1
- Cedar 1
- Cerro Gordo 1
- Clayton 1
- Dallas 1
- Des Moines 1
- Dubuque 1
- Fayette 1
- Hancock 1
- Harrison 1
- Henry 1
- Jasper 1
- Johnson 1
- Kossuth 1
- Linn 1
- Mahaska 1
- Monona 1
- Muscatine 1
- Page 1
- Polk 1
- Pottawattamie 1
- Poweshiek 1
- Scott 1
- Sioux 1
- …
state 1
- Iowa · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12845 | 12845 | 2020-03-26 | Adair | Iowa | 19001 | 1 | 0 |
12846 | 12846 | 2020-03-26 | Allamakee | Iowa | 19005 | 7 | 0 |
12847 | 12847 | 2020-03-26 | Appanoose | Iowa | 19007 | 1 | 0 |
12848 | 12848 | 2020-03-26 | Benton | Iowa | 19011 | 2 | 0 |
12849 | 12849 | 2020-03-26 | Black Hawk | Iowa | 19013 | 5 | 0 |
12850 | 12850 | 2020-03-26 | Buchanan | Iowa | 19019 | 1 | 0 |
12851 | 12851 | 2020-03-26 | Carroll | Iowa | 19027 | 1 | 0 |
12852 | 12852 | 2020-03-26 | Cedar | Iowa | 19031 | 4 | 0 |
12853 | 12853 | 2020-03-26 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
12854 | 12854 | 2020-03-26 | Clayton | Iowa | 19043 | 1 | 0 |
12855 | 12855 | 2020-03-26 | Dallas | Iowa | 19049 | 7 | 0 |
12856 | 12856 | 2020-03-26 | Des Moines | Iowa | 19057 | 1 | 0 |
12857 | 12857 | 2020-03-26 | Dubuque | Iowa | 19061 | 6 | 1 |
12858 | 12858 | 2020-03-26 | Fayette | Iowa | 19065 | 1 | 0 |
12859 | 12859 | 2020-03-26 | Hancock | Iowa | 19081 | 3 | 0 |
12860 | 12860 | 2020-03-26 | Harrison | Iowa | 19085 | 3 | 0 |
12861 | 12861 | 2020-03-26 | Henry | Iowa | 19087 | 1 | 0 |
12862 | 12862 | 2020-03-26 | Jasper | Iowa | 19099 | 2 | 0 |
12863 | 12863 | 2020-03-26 | Johnson | Iowa | 19103 | 49 | 0 |
12864 | 12864 | 2020-03-26 | Kossuth | Iowa | 19109 | 1 | 0 |
12865 | 12865 | 2020-03-26 | Linn | Iowa | 19113 | 12 | 0 |
12866 | 12866 | 2020-03-26 | Mahaska | Iowa | 19123 | 1 | 0 |
12867 | 12867 | 2020-03-26 | Monona | Iowa | 19133 | 1 | 0 |
12868 | 12868 | 2020-03-26 | Muscatine | Iowa | 19139 | 6 | 0 |
12869 | 12869 | 2020-03-26 | Page | Iowa | 19145 | 1 | 0 |
12870 | 12870 | 2020-03-26 | Polk | Iowa | 19153 | 24 | 0 |
12871 | 12871 | 2020-03-26 | Pottawattamie | Iowa | 19155 | 3 | 0 |
12872 | 12872 | 2020-03-26 | Poweshiek | Iowa | 19157 | 4 | 0 |
12873 | 12873 | 2020-03-26 | Scott | Iowa | 19163 | 7 | 0 |
12874 | 12874 | 2020-03-26 | Sioux | Iowa | 19167 | 2 | 0 |
12875 | 12875 | 2020-03-26 | Story | Iowa | 19169 | 2 | 0 |
12876 | 12876 | 2020-03-26 | Tama | Iowa | 19171 | 4 | 0 |
12877 | 12877 | 2020-03-26 | Wapello | Iowa | 19179 | 1 | 0 |
12878 | 12878 | 2020-03-26 | Warren | Iowa | 19181 | 1 | 0 |
12879 | 12879 | 2020-03-26 | Washington | Iowa | 19183 | 8 | 0 |
12880 | 12880 | 2020-03-26 | Winneshiek | Iowa | 19191 | 1 | 0 |
12881 | 12881 | 2020-03-26 | Woodbury | Iowa | 19193 | 2 | 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);