johns_hopkins_csse_daily_reports

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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

57,403 rows where province_or_state = "Iowa" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state

  • Iowa · 57,403 ✖

country_or_region

  • US 57,403
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
33440 33440 2021-10-23 US Iowa Adair 19001 1053 35 0   41.33075609 -94.47105874 2021-10-24 04:21:22 Adair, Iowa, US
33441 33441 2021-10-23 US Iowa Adams 19003 509 5 0   41.02903567 -94.69932645 2021-10-24 04:21:22 Adams, Iowa, US
33442 33442 2021-10-23 US Iowa Allamakee 19005 1947 53 0   43.28383218 -91.37860922 2021-10-24 04:21:22 Allamakee, Iowa, US
33443 33443 2021-10-23 US Iowa Appanoose 19007 1808 50 0   40.74324454 -92.86865906 2021-10-24 04:21:22 Appanoose, Iowa, US
33444 33444 2021-10-23 US Iowa Audubon 19009 668 14 0   41.6844628 -94.90581859 2021-10-24 04:21:22 Audubon, Iowa, US
33445 33445 2021-10-23 US Iowa Benton 19011 3592 57 0   42.08011739 -92.06463573 2021-10-24 04:21:22 Benton, Iowa, US
33446 33446 2021-10-23 US Iowa Black Hawk 19013 20335 358 0   42.4704581 -92.30524729 2021-10-24 04:21:22 Black Hawk, Iowa, US
33447 33447 2021-10-23 US Iowa Boone 19015 3509 37 0   42.03657094 -93.9313999 2021-10-24 04:21:22 Boone, Iowa, US
33448 33448 2021-10-23 US Iowa Bremer 19017 3571 68 0   42.77461496 -92.31795937 2021-10-24 04:21:22 Bremer, Iowa, US
33449 33449 2021-10-23 US Iowa Buchanan 19019 2790 39 0   42.4709188 -91.83510825 2021-10-24 04:21:22 Buchanan, Iowa, US
33450 33450 2021-10-23 US Iowa Buena Vista 19021 4917 46 0   42.73545875 -95.15100162 2021-10-24 04:21:22 Buena Vista, Iowa, US
33451 33451 2021-10-23 US Iowa Butler 19023 2066 38 0   42.73172833 -92.79015971 2021-10-24 04:21:22 Butler, Iowa, US
33452 33452 2021-10-23 US Iowa Calhoun 19025 1861 16 0   42.38521079 -94.64046046 2021-10-24 04:21:22 Calhoun, Iowa, US
33453 33453 2021-10-23 US Iowa Carroll 19027 3463 53 0   42.03617207 -94.86032705 2021-10-24 04:21:22 Carroll, Iowa, US
33454 33454 2021-10-23 US Iowa Cass 19029 2015 57 0   41.33149454 -94.92792482 2021-10-24 04:21:22 Cass, Iowa, US
33455 33455 2021-10-23 US Iowa Cedar 19031 2495 26 0   41.77233777 -91.13246684 2021-10-24 04:21:22 Cedar, Iowa, US
33456 33456 2021-10-23 US Iowa Cerro Gordo 19033 6951 110 0   43.08177563 -93.2612239 2021-10-24 04:21:22 Cerro Gordo, Iowa, US
33457 33457 2021-10-23 US Iowa Cherokee 19035 1938 44 0   42.73538914 -95.62389402 2021-10-24 04:21:22 Cherokee, Iowa, US
33458 33458 2021-10-23 US Iowa Chickasaw 19037 1593 18 0   43.06001295 -92.31773347 2021-10-24 04:21:22 Chickasaw, Iowa, US
33459 33459 2021-10-23 US Iowa Clarke 19039 1413 28 0   41.02868181 -93.78499767 2021-10-24 04:21:22 Clarke, Iowa, US
33460 33460 2021-10-23 US Iowa Clay 19041 2791 33 0   43.08247182 -95.15096481 2021-10-24 04:21:22 Clay, Iowa, US
33461 33461 2021-10-23 US Iowa Clayton 19043 2145 58 0   42.84443388 -91.34133693 2021-10-24 04:21:22 Clayton, Iowa, US
33462 33462 2021-10-23 US Iowa Clinton 19045 6929 101 0   41.89981633 -90.53275096 2021-10-24 04:21:22 Clinton, Iowa, US
33463 33463 2021-10-23 US Iowa Crawford 19047 3393 47 0   42.03718237 -95.3819718 2021-10-24 04:21:22 Crawford, Iowa, US
33464 33464 2021-10-23 US Iowa Dallas 19049 14109 108 0   41.68560356 -94.04127625 2021-10-24 04:21:22 Dallas, Iowa, US
33465 33465 2021-10-23 US Iowa Davis 19051 1152 25 0   40.74773536 -92.41005468 2021-10-24 04:21:22 Davis, Iowa, US
33466 33466 2021-10-23 US Iowa Decatur 19053 826 12 0   40.73742757 -93.78645949 2021-10-24 04:21:22 Decatur, Iowa, US
33467 33467 2021-10-23 US Iowa Delaware 19055 2585 46 0   42.47104597 -91.3664492 2021-10-24 04:21:22 Delaware, Iowa, US
33468 33468 2021-10-23 US Iowa Des Moines 19057 6675 94 0   40.92012606 -91.18326592 2021-10-24 04:21:22 Des Moines, Iowa, US
33469 33469 2021-10-23 US Iowa Dickinson 19059 3010 52 0   43.37787725 -95.1510206 2021-10-24 04:21:22 Dickinson, Iowa, US
33470 33470 2021-10-23 US Iowa Dubuque 19061 15834 229 0   42.46815349 -90.88181925 2021-10-24 04:21:22 Dubuque, Iowa, US
33471 33471 2021-10-23 US Iowa Emmet 19063 1671 46 0   43.37782951 -94.67858943 2021-10-24 04:21:22 Emmet, Iowa, US
33472 33472 2021-10-23 US Iowa Fayette 19065 2606 49 0   42.86271799 -91.84412309999999 2021-10-24 04:21:22 Fayette, Iowa, US
33473 33473 2021-10-23 US Iowa Floyd 19067 2218 45 0   43.06000529999999 -92.78940097 2021-10-24 04:21:22 Floyd, Iowa, US
33474 33474 2021-10-23 US Iowa Franklin 19069 1646 28 0   42.73270384 -93.26256925 2021-10-24 04:21:22 Franklin, Iowa, US
33475 33475 2021-10-23 US Iowa Fremont 19071 861 11 0   40.74542720000001 -95.60129045 2021-10-24 04:21:22 Fremont, Iowa, US
33476 33476 2021-10-23 US Iowa Greene 19073 1163 15 0   42.03614551 -94.39658081 2021-10-24 04:21:22 Greene, Iowa, US
33477 33477 2021-10-23 US Iowa Grundy 19075 1685 37 0   42.40183723 -92.78829551 2021-10-24 04:21:22 Grundy, Iowa, US
33478 33478 2021-10-23 US Iowa Guthrie 19077 1554 34 0   41.68378965 -94.50111014 2021-10-24 04:21:22 Guthrie, Iowa, US
33479 33479 2021-10-23 US Iowa Hamilton 19079 2339 54 0   42.38382428 -93.70197703 2021-10-24 04:21:22 Hamilton, Iowa, US
33480 33480 2021-10-23 US Iowa Hancock 19081 1876 39 0   43.08178477 -93.73454884 2021-10-24 04:21:22 Hancock, Iowa, US
33481 33481 2021-10-23 US Iowa Hardin 19083 2702 49 0   42.38353877 -93.23654611 2021-10-24 04:21:22 Hardin, Iowa, US
33482 33482 2021-10-23 US Iowa Harrison 19085 2177 77 0   41.68330137 -95.81558439 2021-10-24 04:21:22 Harrison, Iowa, US
33483 33483 2021-10-23 US Iowa Henry 19087 3898 47 0   40.98767962 -91.54436349 2021-10-24 04:21:22 Henry, Iowa, US
33484 33484 2021-10-23 US Iowa Howard 19089 1282 22 0   43.35671042 -92.31702714 2021-10-24 04:21:22 Howard, Iowa, US
33485 33485 2021-10-23 US Iowa Humboldt 19091 1677 27 0   42.7764426 -94.20722537 2021-10-24 04:21:22 Humboldt, Iowa, US
33486 33486 2021-10-23 US Iowa Ida 19093 1186 41 0   42.38696136 -95.51355387 2021-10-24 04:21:22 Ida, Iowa, US
33487 33487 2021-10-23 US Iowa Iowa 19095 2080 29 0   41.68630265 -92.0643373 2021-10-24 04:21:22 Iowa, Iowa, US
33488 33488 2021-10-23 US Iowa Jackson 19097 2735 46 0   42.17178824 -90.57354837 2021-10-24 04:21:22 Jackson, Iowa, US
33489 33489 2021-10-23 US Iowa Jasper 19099 5782 79 0   41.68576082 -93.05567785 2021-10-24 04:21:22 Jasper, Iowa, US
33490 33490 2021-10-23 US Iowa Jefferson 19101 2010 40 0   41.03192394 -91.94849466 2021-10-24 04:21:22 Jefferson, Iowa, US
33491 33491 2021-10-23 US Iowa Johnson 19103 17988 100 0   41.67169354 -91.58754744 2021-10-24 04:21:22 Johnson, Iowa, US
33492 33492 2021-10-23 US Iowa Jones 19105 3708 61 0   42.12118609 -91.13139641 2021-10-24 04:21:22 Jones, Iowa, US
33493 33493 2021-10-23 US Iowa Keokuk 19107 1396 35 0   41.33649833 -92.1785067 2021-10-24 04:21:22 Keokuk, Iowa, US
33494 33494 2021-10-23 US Iowa Kossuth 19109 2718 73 0   43.20405458 -94.20691791 2021-10-24 04:21:22 Kossuth, Iowa, US
33495 33495 2021-10-23 US Iowa Lee 19111 5656 89 0   40.64181461 -91.48183025 2021-10-24 04:21:22 Lee, Iowa, US
33496 33496 2021-10-23 US Iowa Linn 19113 29194 394 0   42.07923082 -91.59809485 2021-10-24 04:21:22 Linn, Iowa, US
33497 33497 2021-10-23 US Iowa Louisa 19115 1710 52 0   41.21842119 -91.26102611 2021-10-24 04:21:22 Louisa, Iowa, US
33498 33498 2021-10-23 US Iowa Lucas 19117 1137 24 0   41.02958964 -93.32780803 2021-10-24 04:21:22 Lucas, Iowa, US
33499 33499 2021-10-23 US Iowa Lyon 19119 1929 41 0   43.38107862 -96.20926845 2021-10-24 04:21:22 Lyon, Iowa, US
33500 33500 2021-10-23 US Iowa Madison 19121 2169 25 0   41.33081904 -94.01554631 2021-10-24 04:21:22 Madison, Iowa, US
33501 33501 2021-10-23 US Iowa Mahaska 19123 3228 56 0   41.33521503 -92.64083907 2021-10-24 04:21:22 Mahaska, Iowa, US
33502 33502 2021-10-23 US Iowa Marion 19125 5081 91 0   41.33445101 -93.09934783 2021-10-24 04:21:22 Marion, Iowa, US
33503 33503 2021-10-23 US Iowa Marshall 19127 6418 85 0   42.03586837 -92.99908190000001 2021-10-24 04:21:22 Marshall, Iowa, US
33504 33504 2021-10-23 US Iowa Mills 19129 1999 29 0   41.03299766 -95.61920963 2021-10-24 04:21:22 Mills, Iowa, US
33505 33505 2021-10-23 US Iowa Mitchell 19131 1640 43 0   43.35638371 -92.78887719 2021-10-24 04:21:22 Mitchell, Iowa, US
33506 33506 2021-10-23 US Iowa Monona 19133 1087 38 0   42.05220391 -95.95743843 2021-10-24 04:21:22 Monona, Iowa, US
33507 33507 2021-10-23 US Iowa Monroe 19135 1343 35 0   41.02988815 -92.8690667 2021-10-24 04:21:22 Monroe, Iowa, US
33508 33508 2021-10-23 US Iowa Montgomery 19137 1423 42 0   41.03018714 -95.15642896 2021-10-24 04:21:22 Montgomery, Iowa, US
33509 33509 2021-10-23 US Iowa Muscatine 19139 6352 113 0   41.48370744 -91.11216970000001 2021-10-24 04:21:22 Muscatine, Iowa, US
33510 33510 2021-10-23 US Iowa O'Brien 19141 2275 63 0   43.08310673 -95.62474482 2021-10-24 04:21:22 O'Brien, Iowa, US
33511 33511 2021-10-23 US Iowa Osceola 19143 940 17 0   43.37824276 -95.62422844 2021-10-24 04:21:22 Osceola, Iowa, US
33512 33512 2021-10-23 US Iowa Page 19145 2493 28 0   40.7393172 -95.1497813 2021-10-24 04:21:22 Page, Iowa, US
33513 33513 2021-10-23 US Iowa Palo Alto 19147 1420 32 0   43.08193849 -94.67824621 2021-10-24 04:21:22 Palo Alto, Iowa, US
33514 33514 2021-10-23 US Iowa Plymouth 19149 4634 87 0   42.737633 -96.21366621 2021-10-24 04:21:22 Plymouth, Iowa, US
33515 33515 2021-10-23 US Iowa Pocahontas 19151 1114 23 0   42.73420133 -94.67862564 2021-10-24 04:21:22 Pocahontas, Iowa, US
33516 33516 2021-10-23 US Iowa Polk 19153 74657 729 0   41.68679484 -93.57767461 2021-10-24 04:21:22 Polk, Iowa, US
33517 33517 2021-10-23 US Iowa Pottawattamie 19155 14276 200 0   41.33640314 -95.53907776 2021-10-24 04:21:22 Pottawattamie, Iowa, US
33518 33518 2021-10-23 US Iowa Poweshiek 19157 2117 41 0   41.68625425 -92.53155731 2021-10-24 04:21:22 Poweshiek, Iowa, US
33519 33519 2021-10-23 US Iowa Ringgold 19159 677 27 0   40.73518949 -94.24368535 2021-10-24 04:21:22 Ringgold, Iowa, US
33520 33520 2021-10-23 US Iowa Sac 19161 1579 24 0   42.38624071 -95.10547892 2021-10-24 04:21:22 Sac, Iowa, US
33521 33521 2021-10-23 US Iowa Scott 19163 24733 274 0   41.63935978 -90.61959493 2021-10-24 04:21:22 Scott, Iowa, US
33522 33522 2021-10-23 US Iowa Shelby 19165 1784 39 0   41.6850066 -95.31015553 2021-10-24 04:21:22 Shelby, Iowa, US
33523 33523 2021-10-23 US Iowa Sioux 19167 5656 76 0   43.08221074 -96.17675679999999 2021-10-24 04:21:22 Sioux, Iowa, US
33524 33524 2021-10-23 US Iowa Story 19169 12885 51 0   42.03621213 -93.46499005 2021-10-24 04:21:22 Story, Iowa, US
33525 33525 2021-10-23 US Iowa Tama 19171 2649 76 0   42.07991767 -92.53266945 2021-10-24 04:21:22 Tama, Iowa, US
33526 33526 2021-10-23 US Iowa Taylor 19173 797 13 0   40.73710579 -94.69778563 2021-10-24 04:21:22 Taylor, Iowa, US
33527 33527 2021-10-23 US Iowa Unassigned 90019 38 0 0   43.38107862 0.0 2021-10-24 04:21:22 Unassigned, Iowa, US
33528 33528 2021-10-23 US Iowa Union 19175 1626 37 0   41.0277278 -94.24234847 2021-10-24 04:21:22 Union, Iowa, US
33529 33529 2021-10-23 US Iowa Van Buren 19177 842 21 0   40.75326764 -91.95017958 2021-10-24 04:21:22 Van Buren, Iowa, US
33530 33530 2021-10-23 US Iowa Wapello 19179 5936 137 0   41.03064984 -92.40954728 2021-10-24 04:21:22 Wapello, Iowa, US
33531 33531 2021-10-23 US Iowa Warren 19181 7742 96 0   41.33559454 -93.56007641 2021-10-24 04:21:22 Warren, Iowa, US
33532 33532 2021-10-23 US Iowa Washington 19183 3668 56 0   41.33577126 -91.71725711 2021-10-24 04:21:22 Washington, Iowa, US
33533 33533 2021-10-23 US Iowa Wayne 19185 748 24 0   40.73969028 -93.32752197 2021-10-24 04:21:22 Wayne, Iowa, US
33534 33534 2021-10-23 US Iowa Webster 19187 6950 111 0   42.42853483 -94.17987389 2021-10-24 04:21:22 Webster, Iowa, US
33535 33535 2021-10-23 US Iowa Winnebago 19189 1866 33 0   43.37751174 -93.73407298 2021-10-24 04:21:22 Winnebago, Iowa, US
33536 33536 2021-10-23 US Iowa Winneshiek 19191 2333 38 0   43.29094334 -91.84422722 2021-10-24 04:21:22 Winneshiek, Iowa, US
33537 33537 2021-10-23 US Iowa Woodbury 19193 19207 244 0   42.38979414 -96.0459439 2021-10-24 04:21:22 Woodbury, Iowa, US
33538 33538 2021-10-23 US Iowa Worth 19195 1081 8 0   43.37750768 -93.26087602 2021-10-24 04:21:22 Worth, Iowa, US
33539 33539 2021-10-23 US Iowa Wright 19197 2436 45 0   42.73305373 -93.73515113 2021-10-24 04:21:22 Wright, Iowa, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);