ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-04-23 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
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Bremer 1
- Buchanan 1
- Buena Vista 1
- Butler 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
- Delaware 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Fayette 1
- Franklin 1
- Greene 1
- …
state 1
- Iowa · 84 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
81992 | 81992 | 2020-04-23 | Adair | Iowa | 19001 | 1 | 0 |
81993 | 81993 | 2020-04-23 | Allamakee | Iowa | 19005 | 46 | 3 |
81994 | 81994 | 2020-04-23 | Appanoose | Iowa | 19007 | 2 | 2 |
81995 | 81995 | 2020-04-23 | Audubon | Iowa | 19009 | 1 | 0 |
81996 | 81996 | 2020-04-23 | Benton | Iowa | 19011 | 24 | 1 |
81997 | 81997 | 2020-04-23 | Black Hawk | Iowa | 19013 | 420 | 4 |
81998 | 81998 | 2020-04-23 | Boone | Iowa | 19015 | 6 | 0 |
81999 | 81999 | 2020-04-23 | Bremer | Iowa | 19017 | 34 | 1 |
82000 | 82000 | 2020-04-23 | Buchanan | Iowa | 19019 | 11 | 0 |
82001 | 82001 | 2020-04-23 | Buena Vista | Iowa | 19021 | 3 | 0 |
82002 | 82002 | 2020-04-23 | Butler | Iowa | 19023 | 2 | 0 |
82003 | 82003 | 2020-04-23 | Carroll | Iowa | 19027 | 1 | 0 |
82004 | 82004 | 2020-04-23 | Cass | Iowa | 19029 | 1 | 0 |
82005 | 82005 | 2020-04-23 | Cedar | Iowa | 19031 | 27 | 0 |
82006 | 82006 | 2020-04-23 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
82007 | 82007 | 2020-04-23 | Cherokee | Iowa | 19035 | 1 | 0 |
82008 | 82008 | 2020-04-23 | Chickasaw | Iowa | 19037 | 3 | 0 |
82009 | 82009 | 2020-04-23 | Clarke | Iowa | 19039 | 2 | 0 |
82010 | 82010 | 2020-04-23 | Clay | Iowa | 19041 | 3 | 0 |
82011 | 82011 | 2020-04-23 | Clayton | Iowa | 19043 | 8 | 1 |
82012 | 82012 | 2020-04-23 | Clinton | Iowa | 19045 | 44 | 0 |
82013 | 82013 | 2020-04-23 | Crawford | Iowa | 19047 | 6 | 1 |
82014 | 82014 | 2020-04-23 | Dallas | Iowa | 19049 | 67 | 0 |
82015 | 82015 | 2020-04-23 | Delaware | Iowa | 19055 | 3 | 0 |
82016 | 82016 | 2020-04-23 | Des Moines | Iowa | 19057 | 14 | 0 |
82017 | 82017 | 2020-04-23 | Dickinson | Iowa | 19059 | 3 | 0 |
82018 | 82018 | 2020-04-23 | Dubuque | Iowa | 19061 | 52 | 1 |
82019 | 82019 | 2020-04-23 | Fayette | Iowa | 19065 | 7 | 0 |
82020 | 82020 | 2020-04-23 | Franklin | Iowa | 19069 | 1 | 0 |
82021 | 82021 | 2020-04-23 | Greene | Iowa | 19073 | 1 | 0 |
82022 | 82022 | 2020-04-23 | Grundy | Iowa | 19075 | 6 | 0 |
82023 | 82023 | 2020-04-23 | Guthrie | Iowa | 19077 | 5 | 0 |
82024 | 82024 | 2020-04-23 | Hamilton | Iowa | 19079 | 3 | 0 |
82025 | 82025 | 2020-04-23 | Hancock | Iowa | 19081 | 3 | 0 |
82026 | 82026 | 2020-04-23 | Hardin | Iowa | 19083 | 4 | 0 |
82027 | 82027 | 2020-04-23 | Harrison | Iowa | 19085 | 15 | 0 |
82028 | 82028 | 2020-04-23 | Henry | Iowa | 19087 | 31 | 1 |
82029 | 82029 | 2020-04-23 | Howard | Iowa | 19089 | 4 | 0 |
82030 | 82030 | 2020-04-23 | Humboldt | Iowa | 19091 | 2 | 0 |
82031 | 82031 | 2020-04-23 | Iowa | Iowa | 19095 | 13 | 0 |
82032 | 82032 | 2020-04-23 | Jackson | Iowa | 19097 | 5 | 0 |
82033 | 82033 | 2020-04-23 | Jasper | Iowa | 19099 | 55 | 0 |
82034 | 82034 | 2020-04-23 | Jefferson | Iowa | 19101 | 7 | 0 |
82035 | 82035 | 2020-04-23 | Johnson | Iowa | 19103 | 399 | 3 |
82036 | 82036 | 2020-04-23 | Jones | Iowa | 19105 | 18 | 0 |
82037 | 82037 | 2020-04-23 | Keokuk | Iowa | 19107 | 3 | 0 |
82038 | 82038 | 2020-04-23 | Kossuth | Iowa | 19109 | 1 | 0 |
82039 | 82039 | 2020-04-23 | Lee | Iowa | 19111 | 3 | 0 |
82040 | 82040 | 2020-04-23 | Linn | Iowa | 19113 | 481 | 29 |
82041 | 82041 | 2020-04-23 | Louisa | Iowa | 19115 | 252 | 2 |
82042 | 82042 | 2020-04-23 | Lyon | Iowa | 19119 | 5 | 0 |
82043 | 82043 | 2020-04-23 | Madison | Iowa | 19121 | 3 | 1 |
82044 | 82044 | 2020-04-23 | Mahaska | Iowa | 19123 | 8 | 1 |
82045 | 82045 | 2020-04-23 | Marion | Iowa | 19125 | 5 | 0 |
82046 | 82046 | 2020-04-23 | Marshall | Iowa | 19127 | 239 | 0 |
82047 | 82047 | 2020-04-23 | Mills | Iowa | 19129 | 2 | 0 |
82048 | 82048 | 2020-04-23 | Mitchell | Iowa | 19131 | 2 | 0 |
82049 | 82049 | 2020-04-23 | Monona | Iowa | 19133 | 7 | 0 |
82050 | 82050 | 2020-04-23 | Montgomery | Iowa | 19137 | 1 | 0 |
82051 | 82051 | 2020-04-23 | Muscatine | Iowa | 19139 | 252 | 7 |
82052 | 82052 | 2020-04-23 | O'Brien | Iowa | 19141 | 3 | 0 |
82053 | 82053 | 2020-04-23 | Osceola | Iowa | 19143 | 6 | 0 |
82054 | 82054 | 2020-04-23 | Page | Iowa | 19145 | 5 | 0 |
82055 | 82055 | 2020-04-23 | Plymouth | Iowa | 19149 | 9 | 0 |
82056 | 82056 | 2020-04-23 | Polk | Iowa | 19153 | 486 | 20 |
82057 | 82057 | 2020-04-23 | Pottawattamie | Iowa | 19155 | 18 | 1 |
82058 | 82058 | 2020-04-23 | Poweshiek | Iowa | 19157 | 20 | 1 |
82059 | 82059 | 2020-04-23 | Scott | Iowa | 19163 | 189 | 3 |
82060 | 82060 | 2020-04-23 | Shelby | Iowa | 19165 | 9 | 0 |
82061 | 82061 | 2020-04-23 | Sioux | Iowa | 19167 | 7 | 0 |
82062 | 82062 | 2020-04-23 | Story | Iowa | 19169 | 22 | 0 |
82063 | 82063 | 2020-04-23 | Tama | Iowa | 19171 | 226 | 7 |
82064 | 82064 | 2020-04-23 | Taylor | Iowa | 19173 | 1 | 0 |
82065 | 82065 | 2020-04-23 | Union | Iowa | 19175 | 1 | 0 |
82066 | 82066 | 2020-04-23 | Van Buren | Iowa | 19177 | 8 | 0 |
82067 | 82067 | 2020-04-23 | Wapello | Iowa | 19179 | 7 | 0 |
82068 | 82068 | 2020-04-23 | Warren | Iowa | 19181 | 18 | 0 |
82069 | 82069 | 2020-04-23 | Washington | Iowa | 19183 | 126 | 5 |
82070 | 82070 | 2020-04-23 | Webster | Iowa | 19187 | 2 | 0 |
82071 | 82071 | 2020-04-23 | Winnebago | Iowa | 19189 | 2 | 0 |
82072 | 82072 | 2020-04-23 | Winneshiek | Iowa | 19191 | 9 | 0 |
82073 | 82073 | 2020-04-23 | Woodbury | Iowa | 19193 | 120 | 1 |
82074 | 82074 | 2020-04-23 | Worth | Iowa | 19195 | 1 | 0 |
82075 | 82075 | 2020-04-23 | Wright | Iowa | 19197 | 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);