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

56,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

county

state

  • Iowa · 56,070 ✖
Link rowid date ▲ county state fips cases deaths
1817411 1817411 2021-10-15 Adair Iowa 19001 1038 34
1817412 1817412 2021-10-15 Adams Iowa 19003 498 4
1817413 1817413 2021-10-15 Allamakee Iowa 19005 1929 52
1817414 1817414 2021-10-15 Appanoose Iowa 19007 1762 50
1817415 1817415 2021-10-15 Audubon Iowa 19009 645 14
1817416 1817416 2021-10-15 Benton Iowa 19011 3524 56
1817417 1817417 2021-10-15 Black Hawk Iowa 19013 20150 355
1817418 1817418 2021-10-15 Boone Iowa 19015 3452 37
1817419 1817419 2021-10-15 Bremer Iowa 19017 3539 67
1817420 1817420 2021-10-15 Buchanan Iowa 19019 2744 39
1817421 1817421 2021-10-15 Buena Vista Iowa 19021 4897 45
1817422 1817422 2021-10-15 Butler Iowa 19023 2033 37
1817423 1817423 2021-10-15 Calhoun Iowa 19025 1842 15
1817424 1817424 2021-10-15 Carroll Iowa 19027 3420 53
1817425 1817425 2021-10-15 Cass Iowa 19029 1906 57
1817426 1817426 2021-10-15 Cedar Iowa 19031 2464 26
1817427 1817427 2021-10-15 Cerro Gordo Iowa 19033 6842 107
1817428 1817428 2021-10-15 Cherokee Iowa 19035 1920 43
1817429 1817429 2021-10-15 Chickasaw Iowa 19037 1566 18
1817430 1817430 2021-10-15 Clarke Iowa 19039 1400 28
1817431 1817431 2021-10-15 Clay Iowa 19041 2748 31
1817432 1817432 2021-10-15 Clayton Iowa 19043 2101 58
1817433 1817433 2021-10-15 Clinton Iowa 19045 6821 100
1817434 1817434 2021-10-15 Crawford Iowa 19047 3374 45
1817435 1817435 2021-10-15 Dallas Iowa 19049 13904 107
1817436 1817436 2021-10-15 Davis Iowa 19051 1140 25
1817437 1817437 2021-10-15 Decatur Iowa 19053 812 12
1817438 1817438 2021-10-15 Delaware Iowa 19055 2538 44
1817439 1817439 2021-10-15 Des Moines Iowa 19057 6583 93
1817440 1817440 2021-10-15 Dickinson Iowa 19059 2976 51
1817441 1817441 2021-10-15 Dubuque Iowa 19061 15590 228
1817442 1817442 2021-10-15 Emmet Iowa 19063 1638 42
1817443 1817443 2021-10-15 Fayette Iowa 19065 2540 48
1817444 1817444 2021-10-15 Floyd Iowa 19067 2172 44
1817445 1817445 2021-10-15 Franklin Iowa 19069 1638 28
1817446 1817446 2021-10-15 Fremont Iowa 19071 837 11
1817447 1817447 2021-10-15 Greene Iowa 19073 1138 12
1817448 1817448 2021-10-15 Grundy Iowa 19075 1679 37
1817449 1817449 2021-10-15 Guthrie Iowa 19077 1541 34
1817450 1817450 2021-10-15 Hamilton Iowa 19079 2285 53
1817451 1817451 2021-10-15 Hancock Iowa 19081 1848 39
1817452 1817452 2021-10-15 Hardin Iowa 19083 2664 48
1817453 1817453 2021-10-15 Harrison Iowa 19085 2153 77
1817454 1817454 2021-10-15 Henry Iowa 19087 3791 47
1817455 1817455 2021-10-15 Howard Iowa 19089 1264 22
1817456 1817456 2021-10-15 Humboldt Iowa 19091 1618 26
1817457 1817457 2021-10-15 Ida Iowa 19093 1169 41
1817458 1817458 2021-10-15 Iowa Iowa 19095 2045 29
1817459 1817459 2021-10-15 Jackson Iowa 19097 2710 45
1817460 1817460 2021-10-15 Jasper Iowa 19099 5721 78
1817461 1817461 2021-10-15 Jefferson Iowa 19101 1973 40
1817462 1817462 2021-10-15 Johnson Iowa 19103 17809 100
1817463 1817463 2021-10-15 Jones Iowa 19105 3655 60
1817464 1817464 2021-10-15 Keokuk Iowa 19107 1376 34
1817465 1817465 2021-10-15 Kossuth Iowa 19109 2694 73
1817466 1817466 2021-10-15 Lee Iowa 19111 5610 87
1817467 1817467 2021-10-15 Linn Iowa 19113 28700 379
1817468 1817468 2021-10-15 Louisa Iowa 19115 1698 51
1817469 1817469 2021-10-15 Lucas Iowa 19117 1123 24
1817470 1817470 2021-10-15 Lyon Iowa 19119 1906 41
1817471 1817471 2021-10-15 Madison Iowa 19121 2147 25
1817472 1817472 2021-10-15 Mahaska Iowa 19123 3137 56
1817473 1817473 2021-10-15 Marion Iowa 19125 5000 91
1817474 1817474 2021-10-15 Marshall Iowa 19127 6358 84
1817475 1817475 2021-10-15 Mills Iowa 19129 1972 27
1817476 1817476 2021-10-15 Mitchell Iowa 19131 1626 43
1817477 1817477 2021-10-15 Monona Iowa 19133 1074 36
1817478 1817478 2021-10-15 Monroe Iowa 19135 1317 34
1817479 1817479 2021-10-15 Montgomery Iowa 19137 1389 41
1817480 1817480 2021-10-15 Muscatine Iowa 19139 6294 113
1817481 1817481 2021-10-15 O'Brien Iowa 19141 2239 63
1817482 1817482 2021-10-15 Osceola Iowa 19143 911 17
1817483 1817483 2021-10-15 Page Iowa 19145 2449 27
1817484 1817484 2021-10-15 Palo Alto Iowa 19147 1408 31
1817485 1817485 2021-10-15 Plymouth Iowa 19149 4593 87
1817486 1817486 2021-10-15 Pocahontas Iowa 19151 1093 23
1817487 1817487 2021-10-15 Polk Iowa 19153 73744 716
1817488 1817488 2021-10-15 Pottawattamie Iowa 19155 14078 197
1817489 1817489 2021-10-15 Poweshiek Iowa 19157 2068 40
1817490 1817490 2021-10-15 Ringgold Iowa 19159 668 27
1817491 1817491 2021-10-15 Sac Iowa 19161 1565 23
1817492 1817492 2021-10-15 Scott Iowa 19163 24459 271
1817493 1817493 2021-10-15 Shelby Iowa 19165 1743 39
1817494 1817494 2021-10-15 Sioux Iowa 19167 5602 76
1817495 1817495 2021-10-15 Story Iowa 19169 12754 48
1817496 1817496 2021-10-15 Tama Iowa 19171 2614 76
1817497 1817497 2021-10-15 Taylor Iowa 19173 786 12
1817498 1817498 2021-10-15 Union Iowa 19175 1595 37
1817499 1817499 2021-10-15 Unknown Iowa   16 0
1817500 1817500 2021-10-15 Van Buren Iowa 19177 827 21
1817501 1817501 2021-10-15 Wapello Iowa 19179 5815 136
1817502 1817502 2021-10-15 Warren Iowa 19181 7638 96
1817503 1817503 2021-10-15 Washington Iowa 19183 3624 55
1817504 1817504 2021-10-15 Wayne Iowa 19185 720 24
1817505 1817505 2021-10-15 Webster Iowa 19187 6877 111
1817506 1817506 2021-10-15 Winnebago Iowa 19189 1856 32
1817507 1817507 2021-10-15 Winneshiek Iowa 19191 2310 37
1817508 1817508 2021-10-15 Woodbury Iowa 19193 18878 242
1817509 1817509 2021-10-15 Worth Iowa 19195 1068 8
1817510 1817510 2021-10-15 Wright Iowa 19197 2410 45

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