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

33,770 rows where state = "Iowa" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Iowa · 33,770 ✖
Link rowid date ▲ county state fips cases deaths
1093248 1093248 2021-03-06 Adair Iowa 19001 790 30
1093249 1093249 2021-03-06 Adams Iowa 19003 317 4
1093250 1093250 2021-03-06 Allamakee Iowa 19005 1386 48
1093251 1093251 2021-03-06 Appanoose Iowa 19007 1202 47
1093252 1093252 2021-03-06 Audubon Iowa 19009 464 9
1093253 1093253 2021-03-06 Benton Iowa 19011 2320 54
1093254 1093254 2021-03-06 Black Hawk Iowa 19013 14757 293
1093255 1093255 2021-03-06 Boone Iowa 19015 2380 30
1093256 1093256 2021-03-06 Bremer Iowa 19017 2628 55
1093257 1093257 2021-03-06 Buchanan Iowa 19019 1732 29
1093258 1093258 2021-03-06 Buena Vista Iowa 19021 4058 37
1093259 1093259 2021-03-06 Butler Iowa 19023 1570 31
1093260 1093260 2021-03-06 Calhoun Iowa 19025 1274 11
1093261 1093261 2021-03-06 Carroll Iowa 19027 2639 49
1093262 1093262 2021-03-06 Cass Iowa 19029 1241 51
1093263 1093263 2021-03-06 Cedar Iowa 19031 1650 23
1093264 1093264 2021-03-06 Cerro Gordo Iowa 19033 4939 83
1093265 1093265 2021-03-06 Cherokee Iowa 19035 1431 36
1093266 1093266 2021-03-06 Chickasaw Iowa 19037 1180 15
1093267 1093267 2021-03-06 Clarke Iowa 19039 922 20
1093268 1093268 2021-03-06 Clay Iowa 19041 1823 25
1093269 1093269 2021-03-06 Clayton Iowa 19043 1588 54
1093270 1093270 2021-03-06 Clinton Iowa 19045 4914 84
1093271 1093271 2021-03-06 Crawford Iowa 19047 2471 35
1093272 1093272 2021-03-06 Dallas Iowa 19049 9905 93
1093273 1093273 2021-03-06 Davis Iowa 19051 749 23
1093274 1093274 2021-03-06 Decatur Iowa 19053 550 9
1093275 1093275 2021-03-06 Delaware Iowa 19055 1844 40
1093276 1093276 2021-03-06 Des Moines Iowa 19057 4186 61
1093277 1093277 2021-03-06 Dickinson Iowa 19059 1989 40
1093278 1093278 2021-03-06 Dubuque Iowa 19061 12202 196
1093279 1093279 2021-03-06 Emmet Iowa 19063 1136 40
1093280 1093280 2021-03-06 Fayette Iowa 19065 1757 35
1093281 1093281 2021-03-06 Floyd Iowa 19067 1462 41
1093282 1093282 2021-03-06 Franklin Iowa 19069 1082 19
1093283 1093283 2021-03-06 Fremont Iowa 19071 548 9
1093284 1093284 2021-03-06 Greene Iowa 19073 722 10
1093285 1093285 2021-03-06 Grundy Iowa 19075 1294 30
1093286 1093286 2021-03-06 Guthrie Iowa 19077 1074 28
1093287 1093287 2021-03-06 Hamilton Iowa 19079 1719 42
1093288 1093288 2021-03-06 Hancock Iowa 19081 1362 30
1093289 1093289 2021-03-06 Hardin Iowa 19083 1660 39
1093290 1093290 2021-03-06 Harrison Iowa 19085 1650 70
1093291 1093291 2021-03-06 Henry Iowa 19087 2774 37
1093292 1093292 2021-03-06 Howard Iowa 19089 974 22
1093293 1093293 2021-03-06 Humboldt Iowa 19091 1118 25
1093294 1093294 2021-03-06 Ida Iowa 19093 804 32
1093295 1093295 2021-03-06 Iowa Iowa 19095 1365 23
1093296 1093296 2021-03-06 Jackson Iowa 19097 2075 39
1093297 1093297 2021-03-06 Jasper Iowa 19099 3692 67
1093298 1093298 2021-03-06 Jefferson Iowa 19101 1267 34
1093299 1093299 2021-03-06 Johnson Iowa 19103 12906 75
1093300 1093300 2021-03-06 Jones Iowa 19105 2835 55
1093301 1093301 2021-03-06 Keokuk Iowa 19107 904 29
1093302 1093302 2021-03-06 Kossuth Iowa 19109 1941 55
1093303 1093303 2021-03-06 Lee Iowa 19111 3483 53
1093304 1093304 2021-03-06 Linn Iowa 19113 19202 317
1093305 1093305 2021-03-06 Louisa Iowa 19115 1203 44
1093306 1093306 2021-03-06 Lucas Iowa 19117 695 21
1093307 1093307 2021-03-06 Lyon Iowa 19119 1440 41
1093308 1093308 2021-03-06 Madison Iowa 19121 1379 18
1093309 1093309 2021-03-06 Mahaska Iowa 19123 2120 46
1093310 1093310 2021-03-06 Marion Iowa 19125 3346 71
1093311 1093311 2021-03-06 Marshall Iowa 19127 4569 73
1093312 1093312 2021-03-06 Mills Iowa 19129 1461 20
1093313 1093313 2021-03-06 Mitchell Iowa 19131 1189 40
1093314 1093314 2021-03-06 Monona Iowa 19133 757 27
1093315 1093315 2021-03-06 Monroe Iowa 19135 873 28
1093316 1093316 2021-03-06 Montgomery Iowa 19137 958 36
1093317 1093317 2021-03-06 Muscatine Iowa 19139 4138 93
1093318 1093318 2021-03-06 O'Brien Iowa 19141 1774 58
1093319 1093319 2021-03-06 Osceola Iowa 19143 667 15
1093320 1093320 2021-03-06 Page Iowa 19145 1692 19
1093321 1093321 2021-03-06 Palo Alto Iowa 19147 988 21
1093322 1093322 2021-03-06 Plymouth Iowa 19149 3630 78
1093323 1093323 2021-03-06 Pocahontas Iowa 19151 804 19
1093324 1093324 2021-03-06 Polk Iowa 19153 50544 560
1093325 1093325 2021-03-06 Pottawattamie Iowa 19155 9666 146
1093326 1093326 2021-03-06 Poweshiek Iowa 19157 1455 30
1093327 1093327 2021-03-06 Ringgold Iowa 19159 495 20
1093328 1093328 2021-03-06 Sac Iowa 19161 1160 18
1093329 1093329 2021-03-06 Scott Iowa 19163 16852 212
1093330 1093330 2021-03-06 Shelby Iowa 19165 1135 34
1093331 1093331 2021-03-06 Sioux Iowa 19167 4719 69
1093332 1093332 2021-03-06 Story Iowa 19169 9363 45
1093333 1093333 2021-03-06 Tama Iowa 19171 1985 65
1093334 1093334 2021-03-06 Taylor Iowa 19173 634 12
1093335 1093335 2021-03-06 Union Iowa 19175 1177 31
1093336 1093336 2021-03-06 Unknown Iowa   8656 0
1093337 1093337 2021-03-06 Van Buren Iowa 19177 533 18
1093338 1093338 2021-03-06 Wapello Iowa 19179 3877 110
1093339 1093339 2021-03-06 Warren Iowa 19181 5002 76
1093340 1093340 2021-03-06 Washington Iowa 19183 2370 47
1093341 1093341 2021-03-06 Wayne Iowa 19185 443 21
1093342 1093342 2021-03-06 Webster Iowa 19187 4872 88
1093343 1093343 2021-03-06 Winnebago Iowa 19189 1275 31
1093344 1093344 2021-03-06 Winneshiek Iowa 19191 1783 28
1093345 1093345 2021-03-06 Woodbury Iowa 19193 13559 214
1093346 1093346 2021-03-06 Worth Iowa 19195 650 8
1093347 1093347 2021-03-06 Wright Iowa 19197 1716 31

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);