ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-12-10 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adair 1
- Adams 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
- Decatur 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- …
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
814132 | 814132 | 2020-12-10 | Adair | Iowa | 19001 | 500 | 15 |
814133 | 814133 | 2020-12-10 | Adams | Iowa | 19003 | 201 | 2 |
814134 | 814134 | 2020-12-10 | Allamakee | Iowa | 19005 | 980 | 16 |
814135 | 814135 | 2020-12-10 | Appanoose | Iowa | 19007 | 858 | 31 |
814136 | 814136 | 2020-12-10 | Audubon | Iowa | 19009 | 321 | 6 |
814137 | 814137 | 2020-12-10 | Benton | Iowa | 19011 | 1834 | 28 |
814138 | 814138 | 2020-12-10 | Black Hawk | Iowa | 19013 | 11664 | 178 |
814139 | 814139 | 2020-12-10 | Boone | Iowa | 19015 | 1579 | 14 |
814140 | 814140 | 2020-12-10 | Bremer | Iowa | 19017 | 2094 | 29 |
814141 | 814141 | 2020-12-10 | Buchanan | Iowa | 19019 | 1305 | 15 |
814142 | 814142 | 2020-12-10 | Buena Vista | Iowa | 19021 | 3291 | 17 |
814143 | 814143 | 2020-12-10 | Butler | Iowa | 19023 | 1135 | 11 |
814144 | 814144 | 2020-12-10 | Calhoun | Iowa | 19025 | 1125 | 8 |
814145 | 814145 | 2020-12-10 | Carroll | Iowa | 19027 | 2113 | 22 |
814146 | 814146 | 2020-12-10 | Cass | Iowa | 19029 | 901 | 35 |
814147 | 814147 | 2020-12-10 | Cedar | Iowa | 19031 | 1219 | 15 |
814148 | 814148 | 2020-12-10 | Cerro Gordo | Iowa | 19033 | 3937 | 48 |
814149 | 814149 | 2020-12-10 | Cherokee | Iowa | 19035 | 1062 | 13 |
814150 | 814150 | 2020-12-10 | Chickasaw | Iowa | 19037 | 945 | 9 |
814151 | 814151 | 2020-12-10 | Clarke | Iowa | 19039 | 540 | 6 |
814152 | 814152 | 2020-12-10 | Clay | Iowa | 19041 | 1354 | 10 |
814153 | 814153 | 2020-12-10 | Clayton | Iowa | 19043 | 1232 | 24 |
814154 | 814154 | 2020-12-10 | Clinton | Iowa | 19045 | 3662 | 47 |
814155 | 814155 | 2020-12-10 | Crawford | Iowa | 19047 | 1894 | 16 |
814156 | 814156 | 2020-12-10 | Dallas | Iowa | 19049 | 6983 | 59 |
814157 | 814157 | 2020-12-10 | Davis | Iowa | 19051 | 516 | 12 |
814158 | 814158 | 2020-12-10 | Decatur | Iowa | 19053 | 363 | 1 |
814159 | 814159 | 2020-12-10 | Delaware | Iowa | 19055 | 1526 | 26 |
814160 | 814160 | 2020-12-10 | Des Moines | Iowa | 19057 | 3197 | 25 |
814161 | 814161 | 2020-12-10 | Dickinson | Iowa | 19059 | 1543 | 12 |
814162 | 814162 | 2020-12-10 | Dubuque | Iowa | 19061 | 9828 | 123 |
814163 | 814163 | 2020-12-10 | Emmet | Iowa | 19063 | 864 | 23 |
814164 | 814164 | 2020-12-10 | Fayette | Iowa | 19065 | 1160 | 14 |
814165 | 814165 | 2020-12-10 | Floyd | Iowa | 19067 | 1174 | 22 |
814166 | 814166 | 2020-12-10 | Franklin | Iowa | 19069 | 793 | 17 |
814167 | 814167 | 2020-12-10 | Fremont | Iowa | 19071 | 412 | 5 |
814168 | 814168 | 2020-12-10 | Greene | Iowa | 19073 | 572 | 5 |
814169 | 814169 | 2020-12-10 | Grundy | Iowa | 19075 | 915 | 13 |
814170 | 814170 | 2020-12-10 | Guthrie | Iowa | 19077 | 830 | 22 |
814171 | 814171 | 2020-12-10 | Hamilton | Iowa | 19079 | 1274 | 17 |
814172 | 814172 | 2020-12-10 | Hancock | Iowa | 19081 | 985 | 19 |
814173 | 814173 | 2020-12-10 | Hardin | Iowa | 19083 | 1283 | 20 |
814174 | 814174 | 2020-12-10 | Harrison | Iowa | 19085 | 1199 | 48 |
814175 | 814175 | 2020-12-10 | Henry | Iowa | 19087 | 2139 | 18 |
814176 | 814176 | 2020-12-10 | Howard | Iowa | 19089 | 612 | 15 |
814177 | 814177 | 2020-12-10 | Humboldt | Iowa | 19091 | 845 | 12 |
814178 | 814178 | 2020-12-10 | Ida | Iowa | 19093 | 602 | 16 |
814179 | 814179 | 2020-12-10 | Iowa | Iowa | 19095 | 1040 | 19 |
814180 | 814180 | 2020-12-10 | Jackson | Iowa | 19097 | 1595 | 23 |
814181 | 814181 | 2020-12-10 | Jasper | Iowa | 19099 | 2430 | 48 |
814182 | 814182 | 2020-12-10 | Jefferson | Iowa | 19101 | 826 | 11 |
814183 | 814183 | 2020-12-10 | Johnson | Iowa | 19103 | 10210 | 42 |
814184 | 814184 | 2020-12-10 | Jones | Iowa | 19105 | 2429 | 28 |
814185 | 814185 | 2020-12-10 | Keokuk | Iowa | 19107 | 699 | 13 |
814186 | 814186 | 2020-12-10 | Kossuth | Iowa | 19109 | 1332 | 21 |
814187 | 814187 | 2020-12-10 | Lee | Iowa | 19111 | 2459 | 17 |
814188 | 814188 | 2020-12-10 | Linn | Iowa | 19113 | 15279 | 211 |
814189 | 814189 | 2020-12-10 | Louisa | Iowa | 19115 | 939 | 21 |
814190 | 814190 | 2020-12-10 | Lucas | Iowa | 19117 | 382 | 6 |
814191 | 814191 | 2020-12-10 | Lyon | Iowa | 19119 | 1128 | 21 |
814192 | 814192 | 2020-12-10 | Madison | Iowa | 19121 | 804 | 8 |
814193 | 814193 | 2020-12-10 | Mahaska | Iowa | 19123 | 1406 | 31 |
814194 | 814194 | 2020-12-10 | Marion | Iowa | 19125 | 2253 | 27 |
814195 | 814195 | 2020-12-10 | Marshall | Iowa | 19127 | 3701 | 50 |
814196 | 814196 | 2020-12-10 | Mills | Iowa | 19129 | 1153 | 10 |
814197 | 814197 | 2020-12-10 | Mitchell | Iowa | 19131 | 888 | 19 |
814198 | 814198 | 2020-12-10 | Monona | Iowa | 19133 | 486 | 12 |
814199 | 814199 | 2020-12-10 | Monroe | Iowa | 19135 | 483 | 14 |
814200 | 814200 | 2020-12-10 | Montgomery | Iowa | 19137 | 575 | 12 |
814201 | 814201 | 2020-12-10 | Muscatine | Iowa | 19139 | 3248 | 63 |
814202 | 814202 | 2020-12-10 | O'Brien | Iowa | 19141 | 1430 | 43 |
814203 | 814203 | 2020-12-10 | Osceola | Iowa | 19143 | 582 | 3 |
814204 | 814204 | 2020-12-10 | Page | Iowa | 19145 | 1241 | 9 |
814205 | 814205 | 2020-12-10 | Palo Alto | Iowa | 19147 | 714 | 2 |
814206 | 814206 | 2020-12-10 | Plymouth | Iowa | 19149 | 3060 | 39 |
814207 | 814207 | 2020-12-10 | Pocahontas | Iowa | 19151 | 625 | 4 |
814208 | 814208 | 2020-12-10 | Polk | Iowa | 19153 | 36754 | 362 |
814209 | 814209 | 2020-12-10 | Pottawattamie | Iowa | 19155 | 7233 | 70 |
814210 | 814210 | 2020-12-10 | Poweshiek | Iowa | 19157 | 1080 | 21 |
814211 | 814211 | 2020-12-10 | Ringgold | Iowa | 19159 | 298 | 5 |
814212 | 814212 | 2020-12-10 | Sac | Iowa | 19161 | 953 | 9 |
814213 | 814213 | 2020-12-10 | Scott | Iowa | 19163 | 12610 | 113 |
814214 | 814214 | 2020-12-10 | Shelby | Iowa | 19165 | 841 | 16 |
814215 | 814215 | 2020-12-10 | Sioux | Iowa | 19167 | 3996 | 38 |
814216 | 814216 | 2020-12-10 | Story | Iowa | 19169 | 7283 | 21 |
814217 | 814217 | 2020-12-10 | Tama | Iowa | 19171 | 1604 | 55 |
814218 | 814218 | 2020-12-10 | Taylor | Iowa | 19173 | 486 | 8 |
814219 | 814219 | 2020-12-10 | Union | Iowa | 19175 | 924 | 9 |
814220 | 814220 | 2020-12-10 | Unknown | Iowa | 720 | 0 | |
814221 | 814221 | 2020-12-10 | Van Buren | Iowa | 19177 | 410 | 11 |
814222 | 814222 | 2020-12-10 | Wapello | Iowa | 19179 | 2794 | 86 |
814223 | 814223 | 2020-12-10 | Warren | Iowa | 19181 | 3182 | 23 |
814224 | 814224 | 2020-12-10 | Washington | Iowa | 19183 | 1591 | 23 |
814225 | 814225 | 2020-12-10 | Wayne | Iowa | 19185 | 327 | 21 |
814226 | 814226 | 2020-12-10 | Webster | Iowa | 19187 | 3971 | 47 |
814227 | 814227 | 2020-12-10 | Winnebago | Iowa | 19189 | 1007 | 26 |
814228 | 814228 | 2020-12-10 | Winneshiek | Iowa | 19191 | 1165 | 15 |
814229 | 814229 | 2020-12-10 | Woodbury | Iowa | 19193 | 11237 | 140 |
814230 | 814230 | 2020-12-10 | Worth | Iowa | 19195 | 415 | 2 |
814231 | 814231 | 2020-12-10 | Wright | Iowa | 19197 | 1388 | 9 |
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);