ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

9,973 rows where state = "Iowa" sorted by date descending

View and edit SQL

fips

county

state

  • Iowa · 9,973
Link rowid date ▲ county state fips cases deaths
317233 2020-07-11 Adair Iowa 19001 17 0
317234 2020-07-11 Adams Iowa 19003 8 0
317235 2020-07-11 Allamakee Iowa 19005 138 4
317236 2020-07-11 Appanoose Iowa 19007 21 3
317237 2020-07-11 Audubon Iowa 19009 18 1
317238 2020-07-11 Benton Iowa 19011 75 1
317239 2020-07-11 Black Hawk Iowa 19013 2492 59
317240 2020-07-11 Boone Iowa 19015 168 1
317241 2020-07-11 Bremer Iowa 19017 110 7
317242 2020-07-11 Buchanan Iowa 19019 63 1
317243 2020-07-11 Buena Vista Iowa 19021 1737 11
317244 2020-07-11 Butler Iowa 19023 68 2
317245 2020-07-11 Calhoun Iowa 19025 63 2
317246 2020-07-11 Carroll Iowa 19027 113 1
317247 2020-07-11 Cass Iowa 19029 28 0
317248 2020-07-11 Cedar Iowa 19031 95 1
317249 2020-07-11 Cerro Gordo Iowa 19033 284 1
317250 2020-07-11 Cherokee Iowa 19035 83 1
317251 2020-07-11 Chickasaw Iowa 19037 29 0
317252 2020-07-11 Clarke Iowa 19039 143 3
317253 2020-07-11 Clay Iowa 19041 149 1
317254 2020-07-11 Clayton Iowa 19043 50 3
317255 2020-07-11 Clinton Iowa 19045 132 1
317256 2020-07-11 Crawford Iowa 19047 680 3
317257 2020-07-11 Dallas Iowa 19049 1385 31
317258 2020-07-11 Davis Iowa 19051 42 1
317259 2020-07-11 Decatur Iowa 19053 13 0
317260 2020-07-11 Delaware Iowa 19055 56 1
317261 2020-07-11 Des Moines Iowa 19057 100 2
317262 2020-07-11 Dickinson Iowa 19059 299 3
317263 2020-07-11 Dubuque Iowa 19061 940 23
317264 2020-07-11 Emmet Iowa 19063 95 0
317265 2020-07-11 Fayette Iowa 19065 57 0
317266 2020-07-11 Floyd Iowa 19067 81 2
317267 2020-07-11 Franklin Iowa 19069 104 0
317268 2020-07-11 Fremont Iowa 19071 10 0
317269 2020-07-11 Greene Iowa 19073 30 0
317270 2020-07-11 Grundy Iowa 19075 47 0
317271 2020-07-11 Guthrie Iowa 19077 75 4
317272 2020-07-11 Hamilton Iowa 19079 201 1
317273 2020-07-11 Hancock Iowa 19081 60 1
317274 2020-07-11 Hardin Iowa 19083 90 0
317275 2020-07-11 Harrison Iowa 19085 60 0
317276 2020-07-11 Henry Iowa 19087 93 3
317277 2020-07-11 Howard Iowa 19089 37 0
317278 2020-07-11 Humboldt Iowa 19091 60 1
317279 2020-07-11 Ida Iowa 19093 23 0
317280 2020-07-11 Iowa Iowa 19095 63 1
317281 2020-07-11 Jackson Iowa 19097 57 0
317282 2020-07-11 Jasper Iowa 19099 344 17
317283 2020-07-11 Jefferson Iowa 19101 62 0
317284 2020-07-11 Johnson Iowa 19103 1426 8
317285 2020-07-11 Jones Iowa 19105 71 0
317286 2020-07-11 Keokuk Iowa 19107 23 1
317287 2020-07-11 Kossuth Iowa 19109 41 0
317288 2020-07-11 Lee Iowa 19111 54 2
317289 2020-07-11 Linn Iowa 19113 1381 83
317290 2020-07-11 Louisa Iowa 19115 365 13
317291 2020-07-11 Lucas Iowa 19117 35 4
317292 2020-07-11 Lyon Iowa 19119 57 0
317293 2020-07-11 Madison Iowa 19121 55 2
317294 2020-07-11 Mahaska Iowa 19123 119 17
317295 2020-07-11 Marion Iowa 19125 80 0
317296 2020-07-11 Marshall Iowa 19127 1092 19
317297 2020-07-11 Mills Iowa 19129 47 0
317298 2020-07-11 Mitchell Iowa 19131 44 0
317299 2020-07-11 Monona Iowa 19133 78 0
317300 2020-07-11 Monroe Iowa 19135 52 7
317301 2020-07-11 Montgomery Iowa 19137 12 2
317302 2020-07-11 Muscatine Iowa 19139 687 45
317303 2020-07-11 O'Brien Iowa 19141 94 1
317304 2020-07-11 Osceola Iowa 19143 68 0
317305 2020-07-11 Page Iowa 19145 21 0
317306 2020-07-11 Palo Alto Iowa 19147 51 0
317307 2020-07-11 Plymouth Iowa 19149 346 5
317308 2020-07-11 Pocahontas Iowa 19151 107 1
317309 2020-07-11 Polk Iowa 19153 7332 184
317310 2020-07-11 Pottawattamie Iowa 19155 821 12
317311 2020-07-11 Poweshiek Iowa 19157 112 8
317312 2020-07-11 Ringgold Iowa 19159 16 1
317313 2020-07-11 Sac Iowa 19161 68 0
317314 2020-07-11 Scott Iowa 19163 1031 10
317315 2020-07-11 Shelby Iowa 19165 120 0
317316 2020-07-11 Sioux Iowa 19167 501 0
317317 2020-07-11 Story Iowa 19169 857 5
317318 2020-07-11 Tama Iowa 19171 483 29
317319 2020-07-11 Taylor Iowa 19173 81 0
317320 2020-07-11 Union Iowa 19175 38 0
317321 2020-07-11 Unknown Iowa   35 0
317322 2020-07-11 Van Buren Iowa 19177 21 0
317323 2020-07-11 Wapello Iowa 19179 714 31
317324 2020-07-11 Warren Iowa 19181 319 1
317325 2020-07-11 Washington Iowa 19183 251 9
317326 2020-07-11 Wayne Iowa 19185 11 0
317327 2020-07-11 Webster Iowa 19187 365 5
317328 2020-07-11 Winnebago Iowa 19189 34 0
317329 2020-07-11 Winneshiek Iowa 19191 46 0
317330 2020-07-11 Woodbury Iowa 19193 3329 44
317331 2020-07-11 Worth Iowa 19195 22 0
317332 2020-07-11 Wright Iowa 19197 397 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1104.431ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette