ny_times_us_counties

Table actions
⚠️ 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

28,870 rows where state = "Iowa" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Iowa · 28,870 ✖
Link rowid date ▲ county state fips cases deaths
934293 934293 2021-01-16 Adair Iowa 19001 686 20
934294 934294 2021-01-16 Adams Iowa 19003 295 3
934295 934295 2021-01-16 Allamakee Iowa 19005 1268 27
934296 934296 2021-01-16 Appanoose Iowa 19007 1096 38
934297 934297 2021-01-16 Audubon Iowa 19009 411 8
934298 934298 2021-01-16 Benton Iowa 19011 2084 44
934299 934299 2021-01-16 Black Hawk Iowa 19013 13647 236
934300 934300 2021-01-16 Boone Iowa 19015 2163 17
934301 934301 2021-01-16 Bremer Iowa 19017 2420 48
934302 934302 2021-01-16 Buchanan Iowa 19019 1580 23
934303 934303 2021-01-16 Buena Vista Iowa 19021 3915 29
934304 934304 2021-01-16 Butler Iowa 19023 1464 24
934305 934305 2021-01-16 Calhoun Iowa 19025 1220 9
934306 934306 2021-01-16 Carroll Iowa 19027 2530 34
934307 934307 2021-01-16 Cass Iowa 19029 1125 41
934308 934308 2021-01-16 Cedar Iowa 19031 1512 19
934309 934309 2021-01-16 Cerro Gordo Iowa 19033 4629 68
934310 934310 2021-01-16 Cherokee Iowa 19035 1381 27
934311 934311 2021-01-16 Chickasaw Iowa 19037 1105 12
934312 934312 2021-01-16 Clarke Iowa 19039 781 7
934313 934313 2021-01-16 Clay Iowa 19041 1660 19
934314 934314 2021-01-16 Clayton Iowa 19043 1507 48
934315 934315 2021-01-16 Clinton Iowa 19045 4483 61
934316 934316 2021-01-16 Crawford Iowa 19047 2283 22
934317 934317 2021-01-16 Dallas Iowa 19049 8813 71
934318 934318 2021-01-16 Davis Iowa 19051 687 21
934319 934319 2021-01-16 Decatur Iowa 19053 478 4
934320 934320 2021-01-16 Delaware Iowa 19055 1722 36
934321 934321 2021-01-16 Des Moines Iowa 19057 3807 41
934322 934322 2021-01-16 Dickinson Iowa 19059 1842 26
934323 934323 2021-01-16 Dubuque Iowa 19061 11301 149
934324 934324 2021-01-16 Emmet Iowa 19063 1102 31
934325 934325 2021-01-16 Fayette Iowa 19065 1595 22
934326 934326 2021-01-16 Floyd Iowa 19067 1379 36
934327 934327 2021-01-16 Franklin Iowa 19069 1012 18
934328 934328 2021-01-16 Fremont Iowa 19071 503 6
934329 934329 2021-01-16 Greene Iowa 19073 688 7
934330 934330 2021-01-16 Grundy Iowa 19075 1200 26
934331 934331 2021-01-16 Guthrie Iowa 19077 1022 24
934332 934332 2021-01-16 Hamilton Iowa 19079 1578 29
934333 934333 2021-01-16 Hancock Iowa 19081 1289 24
934334 934334 2021-01-16 Hardin Iowa 19083 1539 29
934335 934335 2021-01-16 Harrison Iowa 19085 1544 62
934336 934336 2021-01-16 Henry Iowa 19087 2633 30
934337 934337 2021-01-16 Howard Iowa 19089 825 19
934338 934338 2021-01-16 Humboldt Iowa 19091 1042 19
934339 934339 2021-01-16 Ida Iowa 19093 738 30
934340 934340 2021-01-16 Iowa Iowa 19095 1228 22
934341 934341 2021-01-16 Jackson Iowa 19097 1908 31
934342 934342 2021-01-16 Jasper Iowa 19099 3196 58
934343 934343 2021-01-16 Jefferson Iowa 19101 1195 24
934344 934344 2021-01-16 Johnson Iowa 19103 12022 49
934345 934345 2021-01-16 Jones Iowa 19105 2696 49
934346 934346 2021-01-16 Keokuk Iowa 19107 843 25
934347 934347 2021-01-16 Kossuth Iowa 19109 1704 43
934348 934348 2021-01-16 Lee Iowa 19111 3135 30
934349 934349 2021-01-16 Linn Iowa 19113 17674 274
934350 934350 2021-01-16 Louisa Iowa 19115 1141 30
934351 934351 2021-01-16 Lucas Iowa 19117 646 8
934352 934352 2021-01-16 Lyon Iowa 19119 1336 32
934353 934353 2021-01-16 Madison Iowa 19121 1186 9
934354 934354 2021-01-16 Mahaska Iowa 19123 1907 36
934355 934355 2021-01-16 Marion Iowa 19125 3017 52
934356 934356 2021-01-16 Marshall Iowa 19127 4255 61
934357 934357 2021-01-16 Mills Iowa 19129 1360 16
934358 934358 2021-01-16 Mitchell Iowa 19131 1156 34
934359 934359 2021-01-16 Monona Iowa 19133 634 16
934360 934360 2021-01-16 Monroe Iowa 19135 805 18
934361 934361 2021-01-16 Montgomery Iowa 19137 840 22
934362 934362 2021-01-16 Muscatine Iowa 19139 3861 77
934363 934363 2021-01-16 O'Brien Iowa 19141 1683 54
934364 934364 2021-01-16 Osceola Iowa 19143 634 9
934365 934365 2021-01-16 Page Iowa 19145 1437 15
934366 934366 2021-01-16 Palo Alto Iowa 19147 901 9
934367 934367 2021-01-16 Plymouth Iowa 19149 3488 68
934368 934368 2021-01-16 Pocahontas Iowa 19151 772 11
934369 934369 2021-01-16 Polk Iowa 19153 45332 447
934370 934370 2021-01-16 Pottawattamie Iowa 19155 8934 112
934371 934371 2021-01-16 Poweshiek Iowa 19157 1323 24
934372 934372 2021-01-16 Ringgold Iowa 19159 426 9
934373 934373 2021-01-16 Sac Iowa 19161 1102 15
934374 934374 2021-01-16 Scott Iowa 19163 15355 163
934375 934375 2021-01-16 Shelby Iowa 19165 1012 26
934376 934376 2021-01-16 Sioux Iowa 19167 4533 56
934377 934377 2021-01-16 Story Iowa 19169 8634 34
934378 934378 2021-01-16 Tama Iowa 19171 1856 57
934379 934379 2021-01-16 Taylor Iowa 19173 591 9
934380 934380 2021-01-16 Union Iowa 19175 1081 22
934381 934381 2021-01-16 Unknown Iowa   920 0
934382 934382 2021-01-16 Van Buren Iowa 19177 494 12
934383 934383 2021-01-16 Wapello Iowa 19179 3407 98
934384 934384 2021-01-16 Warren Iowa 19181 4375 38
934385 934385 2021-01-16 Washington Iowa 19183 2143 31
934386 934386 2021-01-16 Wayne Iowa 19185 414 21
934387 934387 2021-01-16 Webster Iowa 19187 4673 71
934388 934388 2021-01-16 Winnebago Iowa 19189 1182 29
934389 934389 2021-01-16 Winneshiek Iowa 19191 1548 19
934390 934390 2021-01-16 Woodbury Iowa 19193 12944 175
934391 934391 2021-01-16 Worth Iowa 19195 598 3
934392 934392 2021-01-16 Wright Iowa 19197 1627 24

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
);
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]);