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

77,070 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 >30

county >30

state 1

  • Iowa · 77,070 ✖
Link rowid date ▲ county state fips cases deaths
2500373 2500373 2022-05-13 Adair Iowa 19001 1588 50
2500374 2500374 2022-05-13 Adams Iowa 19003 820 14
2500375 2500375 2022-05-13 Allamakee Iowa 19005 2890 60
2500376 2500376 2022-05-13 Appanoose Iowa 19007 2927 68
2500377 2500377 2022-05-13 Audubon Iowa 19009 1114 19
2500378 2500378 2022-05-13 Benton Iowa 19011 6089 77
2500379 2500379 2022-05-13 Black Hawk Iowa 19013 33140 480
2500380 2500380 2022-05-13 Boone Iowa 19015 5519 54
2500381 2500381 2022-05-13 Bremer Iowa 19017 5559 82
2500382 2500382 2022-05-13 Buchanan Iowa 19019 4619 58
2500383 2500383 2022-05-13 Buena Vista Iowa 19021 6404 58
2500384 2500384 2022-05-13 Butler Iowa 19023 3252 53
2500385 2500385 2022-05-13 Calhoun Iowa 19025 2608 25
2500386 2500386 2022-05-13 Carroll Iowa 19027 4958 66
2500387 2500387 2022-05-13 Cass Iowa 19029 2962 78
2500388 2500388 2022-05-13 Cedar Iowa 19031 4201 35
2500389 2500389 2022-05-13 Cerro Gordo Iowa 19033 11156 170
2500390 2500390 2022-05-13 Cherokee Iowa 19035 2981 62
2500391 2500391 2022-05-13 Chickasaw Iowa 19037 2701 32
2500392 2500392 2022-05-13 Clarke Iowa 19039 2271 37
2500393 2500393 2022-05-13 Clay Iowa 19041 4120 44
2500394 2500394 2022-05-13 Clayton Iowa 19043 3510 72
2500395 2500395 2022-05-13 Clinton Iowa 19045 11654 146
2500396 2500396 2022-05-13 Crawford Iowa 19047 4539 54
2500397 2500397 2022-05-13 Dallas Iowa 19049 23337 144
2500398 2500398 2022-05-13 Davis Iowa 19051 1604 32
2500399 2500399 2022-05-13 Decatur Iowa 19053 1520 26
2500400 2500400 2022-05-13 Delaware Iowa 19055 4056 68
2500401 2500401 2022-05-13 Des Moines Iowa 19057 9192 139
2500402 2500402 2022-05-13 Dickinson Iowa 19059 4140 72
2500403 2500403 2022-05-13 Dubuque Iowa 19061 26325 295
2500404 2500404 2022-05-13 Emmet Iowa 19063 2365 52
2500405 2500405 2022-05-13 Fayette Iowa 19065 4123 74
2500406 2500406 2022-05-13 Floyd Iowa 19067 3605 62
2500407 2500407 2022-05-13 Franklin Iowa 19069 2521 42
2500408 2500408 2022-05-13 Fremont Iowa 19071 1387 25
2500409 2500409 2022-05-13 Greene Iowa 19073 1745 21
2500410 2500410 2022-05-13 Grundy Iowa 19075 2576 44
2500411 2500411 2022-05-13 Guthrie Iowa 19077 2372 46
2500412 2500412 2022-05-13 Hamilton Iowa 19079 3481 72
2500413 2500413 2022-05-13 Hancock Iowa 19081 2867 47
2500414 2500414 2022-05-13 Hardin Iowa 19083 4140 62
2500415 2500415 2022-05-13 Harrison Iowa 19085 3437 95
2500416 2500416 2022-05-13 Henry Iowa 19087 5573 74
2500417 2500417 2022-05-13 Howard Iowa 19089 2077 35
2500418 2500418 2022-05-13 Humboldt Iowa 19091 2635 38
2500419 2500419 2022-05-13 Ida Iowa 19093 1831 49
2500420 2500420 2022-05-13 Iowa Iowa 19095 3711 50
2500421 2500421 2022-05-13 Jackson Iowa 19097 4644 69
2500422 2500422 2022-05-13 Jasper Iowa 19099 8707 110
2500423 2500423 2022-05-13 Jefferson Iowa 19101 3513 51
2500424 2500424 2022-05-13 Johnson Iowa 19103 35541 153
2500425 2500425 2022-05-13 Jones Iowa 19105 5511 73
2500426 2500426 2022-05-13 Keokuk Iowa 19107 2085 48
2500427 2500427 2022-05-13 Kossuth Iowa 19109 3783 88
2500428 2500428 2022-05-13 Lee Iowa 19111 7880 142
2500429 2500429 2022-05-13 Linn Iowa 19113 53125 583
2500430 2500430 2022-05-13 Louisa Iowa 19115 2497 62
2500431 2500431 2022-05-13 Lucas Iowa 19117 1763 32
2500432 2500432 2022-05-13 Lyon Iowa 19119 2747 50
2500433 2500433 2022-05-13 Madison Iowa 19121 3181 40
2500434 2500434 2022-05-13 Mahaska Iowa 19123 4934 87
2500435 2500435 2022-05-13 Marion Iowa 19125 7590 125
2500436 2500436 2022-05-13 Marshall Iowa 19127 9488 112
2500437 2500437 2022-05-13 Mills Iowa 19129 3365 41
2500438 2500438 2022-05-13 Mitchell Iowa 19131 2519 49
2500439 2500439 2022-05-13 Monona Iowa 19133 1723 48
2500440 2500440 2022-05-13 Monroe Iowa 19135 1882 49
2500441 2500441 2022-05-13 Montgomery Iowa 19137 2216 55
2500442 2500442 2022-05-13 Muscatine Iowa 19139 9699 131
2500443 2500443 2022-05-13 O'Brien Iowa 19141 3457 71
2500444 2500444 2022-05-13 Osceola Iowa 19143 1394 22
2500445 2500445 2022-05-13 Page Iowa 19145 3339 46
2500446 2500446 2022-05-13 Palo Alto Iowa 19147 2048 38
2500447 2500447 2022-05-13 Plymouth Iowa 19149 6330 100
2500448 2500448 2022-05-13 Pocahontas Iowa 19151 1608 27
2500449 2500449 2022-05-13 Polk Iowa 19153 126409 1105
2500450 2500450 2022-05-13 Pottawattamie Iowa 19155 24382 319
2500451 2500451 2022-05-13 Poweshiek Iowa 19157 3728 61
2500452 2500452 2022-05-13 Ringgold Iowa 19159 1135 34
2500453 2500453 2022-05-13 Sac Iowa 19161 2412 33
2500454 2500454 2022-05-13 Scott Iowa 19163 41418 395
2500455 2500455 2022-05-13 Shelby Iowa 19165 2724 50
2500456 2500456 2022-05-13 Sioux Iowa 19167 7987 87
2500457 2500457 2022-05-13 Story Iowa 19169 19980 90
2500458 2500458 2022-05-13 Tama Iowa 19171 3925 90
2500459 2500459 2022-05-13 Taylor Iowa 19173 1316 22
2500460 2500460 2022-05-13 Union Iowa 19175 2720 51
2500461 2500461 2022-05-13 Unknown Iowa   515 1
2500462 2500462 2022-05-13 Van Buren Iowa 19177 1382 27
2500463 2500463 2022-05-13 Wapello Iowa 19179 9003 204
2500464 2500464 2022-05-13 Warren Iowa 19181 12591 134
2500465 2500465 2022-05-13 Washington Iowa 19183 5681 79
2500466 2500466 2022-05-13 Wayne Iowa 19185 1271 33
2500467 2500467 2022-05-13 Webster Iowa 19187 10384 164
2500468 2500468 2022-05-13 Winnebago Iowa 19189 2984 47
2500469 2500469 2022-05-13 Winneshiek Iowa 19191 3906 50
2500470 2500470 2022-05-13 Woodbury Iowa 19193 28838 339
2500471 2500471 2022-05-13 Worth Iowa 19195 1781 17
2500472 2500472 2022-05-13 Wright Iowa 19197 3626 63

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