ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-05-06" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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
- Calhoun 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
- Davis 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Fayette 1
- …
state 1
- Iowa · 92 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
119073 | 119073 | 2020-05-06 | Adair | Iowa | 19001 | 3 | 0 |
119074 | 119074 | 2020-05-06 | Allamakee | Iowa | 19005 | 98 | 4 |
119075 | 119075 | 2020-05-06 | Appanoose | Iowa | 19007 | 4 | 3 |
119076 | 119076 | 2020-05-06 | Audubon | Iowa | 19009 | 8 | 0 |
119077 | 119077 | 2020-05-06 | Benton | Iowa | 19011 | 34 | 1 |
119078 | 119078 | 2020-05-06 | Black Hawk | Iowa | 19013 | 1396 | 19 |
119079 | 119079 | 2020-05-06 | Boone | Iowa | 19015 | 29 | 0 |
119080 | 119080 | 2020-05-06 | Bremer | Iowa | 19017 | 55 | 5 |
119081 | 119081 | 2020-05-06 | Buchanan | Iowa | 19019 | 22 | 0 |
119082 | 119082 | 2020-05-06 | Buena Vista | Iowa | 19021 | 16 | 0 |
119083 | 119083 | 2020-05-06 | Butler | Iowa | 19023 | 10 | 0 |
119084 | 119084 | 2020-05-06 | Calhoun | Iowa | 19025 | 1 | 0 |
119085 | 119085 | 2020-05-06 | Carroll | Iowa | 19027 | 5 | 0 |
119086 | 119086 | 2020-05-06 | Cass | Iowa | 19029 | 1 | 0 |
119087 | 119087 | 2020-05-06 | Cedar | Iowa | 19031 | 38 | 0 |
119088 | 119088 | 2020-05-06 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
119089 | 119089 | 2020-05-06 | Cherokee | Iowa | 19035 | 4 | 0 |
119090 | 119090 | 2020-05-06 | Chickasaw | Iowa | 19037 | 6 | 0 |
119091 | 119091 | 2020-05-06 | Clarke | Iowa | 19039 | 3 | 0 |
119092 | 119092 | 2020-05-06 | Clay | Iowa | 19041 | 7 | 0 |
119093 | 119093 | 2020-05-06 | Clayton | Iowa | 19043 | 18 | 2 |
119094 | 119094 | 2020-05-06 | Clinton | Iowa | 19045 | 51 | 1 |
119095 | 119095 | 2020-05-06 | Crawford | Iowa | 19047 | 103 | 1 |
119096 | 119096 | 2020-05-06 | Dallas | Iowa | 19049 | 626 | 3 |
119097 | 119097 | 2020-05-06 | Davis | Iowa | 19051 | 5 | 0 |
119098 | 119098 | 2020-05-06 | Delaware | Iowa | 19055 | 8 | 1 |
119099 | 119099 | 2020-05-06 | Des Moines | Iowa | 19057 | 24 | 1 |
119100 | 119100 | 2020-05-06 | Dickinson | Iowa | 19059 | 6 | 0 |
119101 | 119101 | 2020-05-06 | Dubuque | Iowa | 19061 | 162 | 5 |
119102 | 119102 | 2020-05-06 | Fayette | Iowa | 19065 | 24 | 0 |
119103 | 119103 | 2020-05-06 | Floyd | Iowa | 19067 | 2 | 0 |
119104 | 119104 | 2020-05-06 | Franklin | Iowa | 19069 | 6 | 0 |
119105 | 119105 | 2020-05-06 | Greene | Iowa | 19073 | 11 | 0 |
119106 | 119106 | 2020-05-06 | Grundy | Iowa | 19075 | 17 | 0 |
119107 | 119107 | 2020-05-06 | Guthrie | Iowa | 19077 | 31 | 0 |
119108 | 119108 | 2020-05-06 | Hamilton | Iowa | 19079 | 7 | 0 |
119109 | 119109 | 2020-05-06 | Hancock | Iowa | 19081 | 3 | 0 |
119110 | 119110 | 2020-05-06 | Hardin | Iowa | 19083 | 9 | 0 |
119111 | 119111 | 2020-05-06 | Harrison | Iowa | 19085 | 17 | 0 |
119112 | 119112 | 2020-05-06 | Henry | Iowa | 19087 | 40 | 1 |
119113 | 119113 | 2020-05-06 | Howard | Iowa | 19089 | 12 | 0 |
119114 | 119114 | 2020-05-06 | Humboldt | Iowa | 19091 | 4 | 0 |
119115 | 119115 | 2020-05-06 | Iowa | Iowa | 19095 | 24 | 0 |
119116 | 119116 | 2020-05-06 | Jackson | Iowa | 19097 | 5 | 0 |
119117 | 119117 | 2020-05-06 | Jasper | Iowa | 19099 | 220 | 5 |
119118 | 119118 | 2020-05-06 | Jefferson | Iowa | 19101 | 6 | 0 |
119119 | 119119 | 2020-05-06 | Johnson | Iowa | 19103 | 530 | 6 |
119120 | 119120 | 2020-05-06 | Jones | Iowa | 19105 | 25 | 0 |
119121 | 119121 | 2020-05-06 | Keokuk | Iowa | 19107 | 3 | 0 |
119122 | 119122 | 2020-05-06 | Kossuth | Iowa | 19109 | 2 | 0 |
119123 | 119123 | 2020-05-06 | Lee | Iowa | 19111 | 16 | 0 |
119124 | 119124 | 2020-05-06 | Linn | Iowa | 19113 | 770 | 55 |
119125 | 119125 | 2020-05-06 | Louisa | Iowa | 19115 | 279 | 2 |
119126 | 119126 | 2020-05-06 | Lyon | Iowa | 19119 | 15 | 0 |
119127 | 119127 | 2020-05-06 | Madison | Iowa | 19121 | 10 | 1 |
119128 | 119128 | 2020-05-06 | Mahaska | Iowa | 19123 | 19 | 1 |
119129 | 119129 | 2020-05-06 | Marion | Iowa | 19125 | 12 | 0 |
119130 | 119130 | 2020-05-06 | Marshall | Iowa | 19127 | 655 | 3 |
119131 | 119131 | 2020-05-06 | Mills | Iowa | 19129 | 5 | 0 |
119132 | 119132 | 2020-05-06 | Mitchell | Iowa | 19131 | 3 | 0 |
119133 | 119133 | 2020-05-06 | Monona | Iowa | 19133 | 11 | 0 |
119134 | 119134 | 2020-05-06 | Monroe | Iowa | 19135 | 1 | 0 |
119135 | 119135 | 2020-05-06 | Montgomery | Iowa | 19137 | 1 | 0 |
119136 | 119136 | 2020-05-06 | Muscatine | Iowa | 19139 | 435 | 17 |
119137 | 119137 | 2020-05-06 | O'Brien | Iowa | 19141 | 11 | 0 |
119138 | 119138 | 2020-05-06 | Osceola | Iowa | 19143 | 13 | 0 |
119139 | 119139 | 2020-05-06 | Page | Iowa | 19145 | 9 | 0 |
119140 | 119140 | 2020-05-06 | Plymouth | Iowa | 19149 | 34 | 0 |
119141 | 119141 | 2020-05-06 | Pocahontas | Iowa | 19151 | 3 | 0 |
119142 | 119142 | 2020-05-06 | Polk | Iowa | 19153 | 1875 | 45 |
119143 | 119143 | 2020-05-06 | Pottawattamie | Iowa | 19155 | 63 | 2 |
119144 | 119144 | 2020-05-06 | Poweshiek | Iowa | 19157 | 73 | 5 |
119145 | 119145 | 2020-05-06 | Sac | Iowa | 19161 | 2 | 0 |
119146 | 119146 | 2020-05-06 | Scott | Iowa | 19163 | 260 | 7 |
119147 | 119147 | 2020-05-06 | Shelby | Iowa | 19165 | 13 | 0 |
119148 | 119148 | 2020-05-06 | Sioux | Iowa | 19167 | 25 | 0 |
119149 | 119149 | 2020-05-06 | Story | Iowa | 19169 | 40 | 1 |
119150 | 119150 | 2020-05-06 | Tama | Iowa | 19171 | 303 | 11 |
119151 | 119151 | 2020-05-06 | Taylor | Iowa | 19173 | 1 | 0 |
119152 | 119152 | 2020-05-06 | Union | Iowa | 19175 | 1 | 0 |
119153 | 119153 | 2020-05-06 | Unknown | Iowa | 13 | 0 | |
119154 | 119154 | 2020-05-06 | Van Buren | Iowa | 19177 | 8 | 0 |
119155 | 119155 | 2020-05-06 | Wapello | Iowa | 19179 | 125 | 0 |
119156 | 119156 | 2020-05-06 | Warren | Iowa | 19181 | 34 | 0 |
119157 | 119157 | 2020-05-06 | Washington | Iowa | 19183 | 152 | 7 |
119158 | 119158 | 2020-05-06 | Wayne | Iowa | 19185 | 1 | 0 |
119159 | 119159 | 2020-05-06 | Webster | Iowa | 19187 | 8 | 0 |
119160 | 119160 | 2020-05-06 | Winnebago | Iowa | 19189 | 3 | 0 |
119161 | 119161 | 2020-05-06 | Winneshiek | Iowa | 19191 | 18 | 0 |
119162 | 119162 | 2020-05-06 | Woodbury | Iowa | 19193 | 1323 | 4 |
119163 | 119163 | 2020-05-06 | Worth | Iowa | 19195 | 1 | 0 |
119164 | 119164 | 2020-05-06 | Wright | Iowa | 19197 | 5 | 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);