ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2021-01-24" 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 |
---|---|---|---|---|---|---|---|
960177 | 960177 | 2021-01-24 | Adair | Iowa | 19001 | 696 | 20 |
960178 | 960178 | 2021-01-24 | Adams | Iowa | 19003 | 300 | 3 |
960179 | 960179 | 2021-01-24 | Allamakee | Iowa | 19005 | 1309 | 30 |
960180 | 960180 | 2021-01-24 | Appanoose | Iowa | 19007 | 1126 | 40 |
960181 | 960181 | 2021-01-24 | Audubon | Iowa | 19009 | 422 | 8 |
960182 | 960182 | 2021-01-24 | Benton | Iowa | 19011 | 2136 | 50 |
960183 | 960183 | 2021-01-24 | Black Hawk | Iowa | 19013 | 14090 | 243 |
960184 | 960184 | 2021-01-24 | Boone | Iowa | 19015 | 2229 | 17 |
960185 | 960185 | 2021-01-24 | Bremer | Iowa | 19017 | 2501 | 48 |
960186 | 960186 | 2021-01-24 | Buchanan | Iowa | 19019 | 1622 | 24 |
960187 | 960187 | 2021-01-24 | Buena Vista | Iowa | 19021 | 3963 | 30 |
960188 | 960188 | 2021-01-24 | Butler | Iowa | 19023 | 1517 | 24 |
960189 | 960189 | 2021-01-24 | Calhoun | Iowa | 19025 | 1234 | 9 |
960190 | 960190 | 2021-01-24 | Carroll | Iowa | 19027 | 2584 | 34 |
960191 | 960191 | 2021-01-24 | Cass | Iowa | 19029 | 1152 | 43 |
960192 | 960192 | 2021-01-24 | Cedar | Iowa | 19031 | 1556 | 19 |
960193 | 960193 | 2021-01-24 | Cerro Gordo | Iowa | 19033 | 4735 | 72 |
960194 | 960194 | 2021-01-24 | Cherokee | Iowa | 19035 | 1401 | 27 |
960195 | 960195 | 2021-01-24 | Chickasaw | Iowa | 19037 | 1137 | 12 |
960196 | 960196 | 2021-01-24 | Clarke | Iowa | 19039 | 812 | 9 |
960197 | 960197 | 2021-01-24 | Clay | Iowa | 19041 | 1725 | 21 |
960198 | 960198 | 2021-01-24 | Clayton | Iowa | 19043 | 1538 | 49 |
960199 | 960199 | 2021-01-24 | Clinton | Iowa | 19045 | 4581 | 68 |
960200 | 960200 | 2021-01-24 | Crawford | Iowa | 19047 | 2347 | 24 |
960201 | 960201 | 2021-01-24 | Dallas | Iowa | 19049 | 9089 | 72 |
960202 | 960202 | 2021-01-24 | Davis | Iowa | 19051 | 703 | 21 |
960203 | 960203 | 2021-01-24 | Decatur | Iowa | 19053 | 497 | 4 |
960204 | 960204 | 2021-01-24 | Delaware | Iowa | 19055 | 1762 | 36 |
960205 | 960205 | 2021-01-24 | Des Moines | Iowa | 19057 | 3951 | 43 |
960206 | 960206 | 2021-01-24 | Dickinson | Iowa | 19059 | 1888 | 29 |
960207 | 960207 | 2021-01-24 | Dubuque | Iowa | 19061 | 11625 | 159 |
960208 | 960208 | 2021-01-24 | Emmet | Iowa | 19063 | 1113 | 32 |
960209 | 960209 | 2021-01-24 | Fayette | Iowa | 19065 | 1660 | 24 |
960210 | 960210 | 2021-01-24 | Floyd | Iowa | 19067 | 1416 | 36 |
960211 | 960211 | 2021-01-24 | Franklin | Iowa | 19069 | 1036 | 18 |
960212 | 960212 | 2021-01-24 | Fremont | Iowa | 19071 | 524 | 6 |
960213 | 960213 | 2021-01-24 | Greene | Iowa | 19073 | 697 | 7 |
960214 | 960214 | 2021-01-24 | Grundy | Iowa | 19075 | 1226 | 28 |
960215 | 960215 | 2021-01-24 | Guthrie | Iowa | 19077 | 1044 | 24 |
960216 | 960216 | 2021-01-24 | Hamilton | Iowa | 19079 | 1623 | 30 |
960217 | 960217 | 2021-01-24 | Hancock | Iowa | 19081 | 1319 | 24 |
960218 | 960218 | 2021-01-24 | Hardin | Iowa | 19083 | 1579 | 31 |
960219 | 960219 | 2021-01-24 | Harrison | Iowa | 19085 | 1585 | 62 |
960220 | 960220 | 2021-01-24 | Henry | Iowa | 19087 | 2671 | 31 |
960221 | 960221 | 2021-01-24 | Howard | Iowa | 19089 | 859 | 19 |
960222 | 960222 | 2021-01-24 | Humboldt | Iowa | 19091 | 1068 | 19 |
960223 | 960223 | 2021-01-24 | Ida | Iowa | 19093 | 760 | 30 |
960224 | 960224 | 2021-01-24 | Iowa | Iowa | 19095 | 1277 | 22 |
960225 | 960225 | 2021-01-24 | Jackson | Iowa | 19097 | 1950 | 32 |
960226 | 960226 | 2021-01-24 | Jasper | Iowa | 19099 | 3328 | 59 |
960227 | 960227 | 2021-01-24 | Jefferson | Iowa | 19101 | 1221 | 25 |
960228 | 960228 | 2021-01-24 | Johnson | Iowa | 19103 | 12300 | 52 |
960229 | 960229 | 2021-01-24 | Jones | Iowa | 19105 | 2749 | 50 |
960230 | 960230 | 2021-01-24 | Keokuk | Iowa | 19107 | 863 | 26 |
960231 | 960231 | 2021-01-24 | Kossuth | Iowa | 19109 | 1806 | 44 |
960232 | 960232 | 2021-01-24 | Lee | Iowa | 19111 | 3246 | 32 |
960233 | 960233 | 2021-01-24 | Linn | Iowa | 19113 | 18065 | 279 |
960234 | 960234 | 2021-01-24 | Louisa | Iowa | 19115 | 1162 | 30 |
960235 | 960235 | 2021-01-24 | Lucas | Iowa | 19117 | 667 | 10 |
960236 | 960236 | 2021-01-24 | Lyon | Iowa | 19119 | 1375 | 33 |
960237 | 960237 | 2021-01-24 | Madison | Iowa | 19121 | 1239 | 10 |
960238 | 960238 | 2021-01-24 | Mahaska | Iowa | 19123 | 1979 | 37 |
960239 | 960239 | 2021-01-24 | Marion | Iowa | 19125 | 3093 | 53 |
960240 | 960240 | 2021-01-24 | Marshall | Iowa | 19127 | 4311 | 62 |
960241 | 960241 | 2021-01-24 | Mills | Iowa | 19129 | 1385 | 17 |
960242 | 960242 | 2021-01-24 | Mitchell | Iowa | 19131 | 1168 | 37 |
960243 | 960243 | 2021-01-24 | Monona | Iowa | 19133 | 685 | 18 |
960244 | 960244 | 2021-01-24 | Monroe | Iowa | 19135 | 822 | 20 |
960245 | 960245 | 2021-01-24 | Montgomery | Iowa | 19137 | 891 | 24 |
960246 | 960246 | 2021-01-24 | Muscatine | Iowa | 19139 | 3961 | 78 |
960247 | 960247 | 2021-01-24 | O'Brien | Iowa | 19141 | 1710 | 54 |
960248 | 960248 | 2021-01-24 | Osceola | Iowa | 19143 | 647 | 11 |
960249 | 960249 | 2021-01-24 | Page | Iowa | 19145 | 1471 | 15 |
960250 | 960250 | 2021-01-24 | Palo Alto | Iowa | 19147 | 924 | 11 |
960251 | 960251 | 2021-01-24 | Plymouth | Iowa | 19149 | 3532 | 70 |
960252 | 960252 | 2021-01-24 | Pocahontas | Iowa | 19151 | 782 | 11 |
960253 | 960253 | 2021-01-24 | Polk | Iowa | 19153 | 46841 | 465 |
960254 | 960254 | 2021-01-24 | Pottawattamie | Iowa | 19155 | 9166 | 115 |
960255 | 960255 | 2021-01-24 | Poweshiek | Iowa | 19157 | 1352 | 24 |
960256 | 960256 | 2021-01-24 | Ringgold | Iowa | 19159 | 451 | 11 |
960257 | 960257 | 2021-01-24 | Sac | Iowa | 19161 | 1122 | 15 |
960258 | 960258 | 2021-01-24 | Scott | Iowa | 19163 | 15872 | 172 |
960259 | 960259 | 2021-01-24 | Shelby | Iowa | 19165 | 1055 | 27 |
960260 | 960260 | 2021-01-24 | Sioux | Iowa | 19167 | 4597 | 57 |
960261 | 960261 | 2021-01-24 | Story | Iowa | 19169 | 8810 | 38 |
960262 | 960262 | 2021-01-24 | Tama | Iowa | 19171 | 1902 | 59 |
960263 | 960263 | 2021-01-24 | Taylor | Iowa | 19173 | 599 | 9 |
960264 | 960264 | 2021-01-24 | Union | Iowa | 19175 | 1116 | 23 |
960265 | 960265 | 2021-01-24 | Unknown | Iowa | 1016 | 0 | |
960266 | 960266 | 2021-01-24 | Van Buren | Iowa | 19177 | 502 | 15 |
960267 | 960267 | 2021-01-24 | Wapello | Iowa | 19179 | 3507 | 98 |
960268 | 960268 | 2021-01-24 | Warren | Iowa | 19181 | 4593 | 39 |
960269 | 960269 | 2021-01-24 | Washington | Iowa | 19183 | 2229 | 33 |
960270 | 960270 | 2021-01-24 | Wayne | Iowa | 19185 | 420 | 21 |
960271 | 960271 | 2021-01-24 | Webster | Iowa | 19187 | 4724 | 77 |
960272 | 960272 | 2021-01-24 | Winnebago | Iowa | 19189 | 1222 | 29 |
960273 | 960273 | 2021-01-24 | Winneshiek | Iowa | 19191 | 1608 | 20 |
960274 | 960274 | 2021-01-24 | Woodbury | Iowa | 19193 | 13129 | 181 |
960275 | 960275 | 2021-01-24 | Worth | Iowa | 19195 | 619 | 4 |
960276 | 960276 | 2021-01-24 | Wright | Iowa | 19197 | 1671 | 24 |
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);