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

33,803 rows where province_or_state = "Iowa" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • Iowa · 33,803 ✖

country_or_region

  • US 33,803
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
802435 802435 2021-03-01 US Iowa Adair 19001 919 28 0 891 41.33075609 -94.47105874 2021-03-02 05:23:30 Adair, Iowa, US
802436 802436 2021-03-01 US Iowa Adams 19003 326 4 0 322 41.02903567 -94.69932645 2021-03-02 05:23:30 Adams, Iowa, US
802437 802437 2021-03-01 US Iowa Allamakee 19005 1456 46 0 1410 43.28383218 -91.37860922 2021-03-02 05:23:30 Allamakee, Iowa, US
802438 802438 2021-03-01 US Iowa Appanoose 19007 1391 47 0 1344 40.74324454 -92.86865906 2021-03-02 05:23:30 Appanoose, Iowa, US
802439 802439 2021-03-01 US Iowa Audubon 19009 486 9 0 477 41.6844628 -94.90581859 2021-03-02 05:23:30 Audubon, Iowa, US
802440 802440 2021-03-01 US Iowa Benton 19011 2528 54 0 2474 42.08011739 -92.06463573 2021-03-02 05:23:30 Benton, Iowa, US
802441 802441 2021-03-01 US Iowa Black Hawk 19013 16249 291 0 15958 42.4704581 -92.30524729 2021-03-02 05:23:30 Black Hawk, Iowa, US
802442 802442 2021-03-01 US Iowa Boone 19015 2596 30 0 2566 42.03657094 -93.9313999 2021-03-02 05:23:30 Boone, Iowa, US
802443 802443 2021-03-01 US Iowa Bremer 19017 2801 54 0 2747 42.77461496 -92.31795937 2021-03-02 05:23:30 Bremer, Iowa, US
802444 802444 2021-03-01 US Iowa Buchanan 19019 1851 29 0 1822 42.4709188 -91.83510825 2021-03-02 05:23:30 Buchanan, Iowa, US
802445 802445 2021-03-01 US Iowa Buena Vista 19021 4732 36 0 4696 42.73545875 -95.15100162 2021-03-02 05:23:30 Buena Vista, Iowa, US
802446 802446 2021-03-01 US Iowa Butler 19023 1663 31 0 1632 42.73172833 -92.79015971 2021-03-02 05:23:30 Butler, Iowa, US
802447 802447 2021-03-01 US Iowa Calhoun 19025 1337 11 0 1326 42.38521079 -94.64046046 2021-03-02 05:23:30 Calhoun, Iowa, US
802448 802448 2021-03-01 US Iowa Carroll 19027 2855 48 0 2807 42.03617207 -94.86032705 2021-03-02 05:23:30 Carroll, Iowa, US
802449 802449 2021-03-01 US Iowa Cass 19029 1341 51 0 1290 41.33149454 -94.92792482 2021-03-02 05:23:30 Cass, Iowa, US
802450 802450 2021-03-01 US Iowa Cedar 19031 1779 23 0 1756 41.77233777 -91.13246684 2021-03-02 05:23:30 Cedar, Iowa, US
802451 802451 2021-03-01 US Iowa Cerro Gordo 19033 5336 81 0 5255 43.08177563 -93.2612239 2021-03-02 05:23:30 Cerro Gordo, Iowa, US
802452 802452 2021-03-01 US Iowa Cherokee 19035 1539 35 0 1504 42.73538914 -95.62389402 2021-03-02 05:23:30 Cherokee, Iowa, US
802453 802453 2021-03-01 US Iowa Chickasaw 19037 1252 13 0 1239 43.06001295 -92.31773347 2021-03-02 05:23:30 Chickasaw, Iowa, US
802454 802454 2021-03-01 US Iowa Clarke 19039 1005 20 0 985 41.02868181 -93.78499767 2021-03-02 05:23:30 Clarke, Iowa, US
802455 802455 2021-03-01 US Iowa Clay 19041 1935 25 0 1910 43.08247182 -95.15096481 2021-03-02 05:23:30 Clay, Iowa, US
802456 802456 2021-03-01 US Iowa Clayton 19043 1680 53 0 1627 42.84443388 -91.34133693 2021-03-02 05:23:30 Clayton, Iowa, US
802457 802457 2021-03-01 US Iowa Clinton 19045 5432 84 0 5348 41.89981633 -90.53275096 2021-03-02 05:23:30 Clinton, Iowa, US
802458 802458 2021-03-01 US Iowa Crawford 19047 2747 35 0 2712 42.03718237 -95.3819718 2021-03-02 05:23:30 Crawford, Iowa, US
802459 802459 2021-03-01 US Iowa Dallas 19049 11358 90 0 11268 41.68560356 -94.04127625 2021-03-02 05:23:30 Dallas, Iowa, US
802460 802460 2021-03-01 US Iowa Davis 19051 826 23 0 803 40.74773536 -92.41005468 2021-03-02 05:23:30 Davis, Iowa, US
802461 802461 2021-03-01 US Iowa Decatur 19053 578 9 0 569 40.73742757 -93.78645949 2021-03-02 05:23:30 Decatur, Iowa, US
802462 802462 2021-03-01 US Iowa Delaware 19055 1888 39 0 1849 42.47104597 -91.3664492 2021-03-02 05:23:30 Delaware, Iowa, US
802463 802463 2021-03-01 US Iowa Des Moines 19057 4576 61 0 4515 40.92012606 -91.18326592 2021-03-02 05:23:30 Des Moines, Iowa, US
802464 802464 2021-03-01 US Iowa Dickinson 19059 2174 39 0 2135 43.37787725 -95.1510206 2021-03-02 05:23:30 Dickinson, Iowa, US
802465 802465 2021-03-01 US Iowa Dubuque 19061 13537 194 0 13343 42.46815349 -90.88181925 2021-03-02 05:23:30 Dubuque, Iowa, US
802466 802466 2021-03-01 US Iowa Emmet 19063 1212 40 0 1172 43.37782951 -94.67858943 2021-03-02 05:23:30 Emmet, Iowa, US
802467 802467 2021-03-01 US Iowa Fayette 19065 1850 35 0 1815 42.86271799 -91.8441231 2021-03-02 05:23:30 Fayette, Iowa, US
802468 802468 2021-03-01 US Iowa Floyd 19067 1627 40 0 1587 43.06000529999999 -92.78940097 2021-03-02 05:23:30 Floyd, Iowa, US
802469 802469 2021-03-01 US Iowa Franklin 19069 1184 19 0 1165 42.73270384 -93.26256925 2021-03-02 05:23:30 Franklin, Iowa, US
802470 802470 2021-03-01 US Iowa Fremont 19071 591 9 0 582 40.74542720000001 -95.60129045 2021-03-02 05:23:30 Fremont, Iowa, US
802471 802471 2021-03-01 US Iowa Greene 19073 773 10 0 763 42.03614551 -94.39658081 2021-03-02 05:23:30 Greene, Iowa, US
802472 802472 2021-03-01 US Iowa Grundy 19075 1390 30 0 1360 42.40183723 -92.78829551 2021-03-02 05:23:30 Grundy, Iowa, US
802473 802473 2021-03-01 US Iowa Guthrie 19077 1165 28 0 1137 41.68378965 -94.50111014 2021-03-02 05:23:30 Guthrie, Iowa, US
802474 802474 2021-03-01 US Iowa Hamilton 19079 1920 42 0 1878 42.38382428 -93.70197703 2021-03-02 05:23:30 Hamilton, Iowa, US
802475 802475 2021-03-01 US Iowa Hancock 19081 1468 29 0 1439 43.08178477 -93.73454884 2021-03-02 05:23:30 Hancock, Iowa, US
802476 802476 2021-03-01 US Iowa Hardin 19083 1810 39 0 1771 42.38353877 -93.23654611 2021-03-02 05:23:30 Hardin, Iowa, US
802477 802477 2021-03-01 US Iowa Harrison 19085 1796 69 0 1727 41.68330137 -95.81558439 2021-03-02 05:23:30 Harrison, Iowa, US
802478 802478 2021-03-01 US Iowa Henry 19087 2927 37 0 2890 40.98767962 -91.54436349 2021-03-02 05:23:30 Henry, Iowa, US
802479 802479 2021-03-01 US Iowa Howard 19089 1031 21 0 1010 43.35671042 -92.31702714 2021-03-02 05:23:30 Howard, Iowa, US
802480 802480 2021-03-01 US Iowa Humboldt 19091 1174 25 0 1149 42.7764426 -94.20722537 2021-03-02 05:23:30 Humboldt, Iowa, US
802481 802481 2021-03-01 US Iowa Ida 19093 910 32 0 878 42.38696136 -95.51355387 2021-03-02 05:23:30 Ida, Iowa, US
802482 802482 2021-03-01 US Iowa Iowa 19095 1444 23 0 1421 41.68630265 -92.0643373 2021-03-02 05:23:30 Iowa, Iowa, US
802483 802483 2021-03-01 US Iowa Jackson 19097 2214 38 0 2176 42.17178824 -90.57354837 2021-03-02 05:23:30 Jackson, Iowa, US
802484 802484 2021-03-01 US Iowa Jasper 19099 4169 66 0 4103 41.68576082 -93.05567785 2021-03-02 05:23:30 Jasper, Iowa, US
802485 802485 2021-03-01 US Iowa Jefferson 19101 1382 32 0 1350 41.03192394 -91.94849466 2021-03-02 05:23:30 Jefferson, Iowa, US
802486 802486 2021-03-01 US Iowa Johnson 19103 13834 73 0 13761 41.67169354 -91.58754744 2021-03-02 05:23:30 Johnson, Iowa, US
802487 802487 2021-03-01 US Iowa Jones 19105 2941 54 0 2887 42.12118609 -91.13139641 2021-03-02 05:23:30 Jones, Iowa, US
802488 802488 2021-03-01 US Iowa Keokuk 19107 981 29 0 952 41.33649833 -92.1785067 2021-03-02 05:23:30 Keokuk, Iowa, US
802489 802489 2021-03-01 US Iowa Kossuth 19109 2081 54 0 2027 43.20405458 -94.20691791 2021-03-02 05:23:30 Kossuth, Iowa, US
802490 802490 2021-03-01 US Iowa Lee 19111 3753 52 0 3701 40.64181461 -91.48183025 2021-03-02 05:23:30 Lee, Iowa, US
802491 802491 2021-03-01 US Iowa Linn 19113 20653 312 0 20341 42.07923082 -91.59809485 2021-03-02 05:23:30 Linn, Iowa, US
802492 802492 2021-03-01 US Iowa Louisa 19115 1282 41 0 1241 41.21842119 -91.26102611 2021-03-02 05:23:30 Louisa, Iowa, US
802493 802493 2021-03-01 US Iowa Lucas 19117 738 21 0 717 41.02958964 -93.32780803 2021-03-02 05:23:30 Lucas, Iowa, US
802494 802494 2021-03-01 US Iowa Lyon 19119 1458 41 0 1417 43.38107862 -96.20926845 2021-03-02 05:23:30 Lyon, Iowa, US
802495 802495 2021-03-01 US Iowa Madison 19121 1545 18 0 1527 41.33081904 -94.01554631 2021-03-02 05:23:30 Madison, Iowa, US
802496 802496 2021-03-01 US Iowa Mahaska 19123 2243 46 0 2197 41.33521503 -92.64083907 2021-03-02 05:23:30 Mahaska, Iowa, US
802497 802497 2021-03-01 US Iowa Marion 19125 3590 69 0 3521 41.33445101 -93.09934783 2021-03-02 05:23:30 Marion, Iowa, US
802498 802498 2021-03-01 US Iowa Marshall 19127 4962 72 0 4890 42.03586837 -92.9990819 2021-03-02 05:23:30 Marshall, Iowa, US
802499 802499 2021-03-01 US Iowa Mills 19129 1631 20 0 1611 41.03299766 -95.61920963 2021-03-02 05:23:30 Mills, Iowa, US
802500 802500 2021-03-01 US Iowa Mitchell 19131 1308 40 0 1268 43.35638371 -92.78887719 2021-03-02 05:23:30 Mitchell, Iowa, US
802501 802501 2021-03-01 US Iowa Monona 19133 816 27 0 789 42.05220391 -95.95743843 2021-03-02 05:23:30 Monona, Iowa, US
802502 802502 2021-03-01 US Iowa Monroe 19135 931 28 0 903 41.02988815 -92.8690667 2021-03-02 05:23:30 Monroe, Iowa, US
802503 802503 2021-03-01 US Iowa Montgomery 19137 1039 36 0 1003 41.03018714 -95.15642896 2021-03-02 05:23:30 Montgomery, Iowa, US
802504 802504 2021-03-01 US Iowa Muscatine 19139 4511 91 0 4420 41.48370744 -91.1121697 2021-03-02 05:23:30 Muscatine, Iowa, US
802505 802505 2021-03-01 US Iowa O'Brien 19141 1947 58 0 1889 43.08310673 -95.62474482 2021-03-02 05:23:30 O'Brien, Iowa, US
802506 802506 2021-03-01 US Iowa Osceola 19143 705 14 0 691 43.37824276 -95.62422844 2021-03-02 05:23:30 Osceola, Iowa, US
802507 802507 2021-03-01 US Iowa Page 19145 1832 19 0 1813 40.7393172 -95.1497813 2021-03-02 05:23:30 Page, Iowa, US
802508 802508 2021-03-01 US Iowa Palo Alto 19147 1049 21 0 1028 43.08193849 -94.67824621 2021-03-02 05:23:30 Palo Alto, Iowa, US
802509 802509 2021-03-01 US Iowa Plymouth 19149 3945 77 0 3868 42.737633 -96.21366621 2021-03-02 05:23:30 Plymouth, Iowa, US
802510 802510 2021-03-01 US Iowa Pocahontas 19151 855 19 0 836 42.73420133 -94.67862564 2021-03-02 05:23:30 Pocahontas, Iowa, US
802511 802511 2021-03-01 US Iowa Polk 19153 58146 549 0 57597 41.68679484 -93.57767461 2021-03-02 05:23:30 Polk, Iowa, US
802512 802512 2021-03-01 US Iowa Pottawattamie 19155 10765 143 0 10622 41.33640314 -95.53907776 2021-03-02 05:23:30 Pottawattamie, Iowa, US
802513 802513 2021-03-01 US Iowa Poweshiek 19157 1537 30 0 1507 41.68625425 -92.53155731 2021-03-02 05:23:30 Poweshiek, Iowa, US
802514 802514 2021-03-01 US Iowa Ringgold 19159 520 20 0 500 40.73518949 -94.24368535 2021-03-02 05:23:30 Ringgold, Iowa, US
802515 802515 2021-03-01 US Iowa Sac 19161 1242 18 0 1224 42.38624071 -95.10547892 2021-03-02 05:23:30 Sac, Iowa, US
802516 802516 2021-03-01 US Iowa Scott 19163 18288 207 0 18081 41.63935978 -90.61959493 2021-03-02 05:23:30 Scott, Iowa, US
802517 802517 2021-03-01 US Iowa Shelby 19165 1210 33 0 1177 41.6850066 -95.31015553 2021-03-02 05:23:30 Shelby, Iowa, US
802518 802518 2021-03-01 US Iowa Sioux 19167 4943 69 0 4874 43.08221074 -96.1767568 2021-03-02 05:23:30 Sioux, Iowa, US
802519 802519 2021-03-01 US Iowa Story 19169 10216 45 0 10171 42.03621213 -93.46499005 2021-03-02 05:23:30 Story, Iowa, US
802520 802520 2021-03-01 US Iowa Tama 19171 2134 65 0 2069 42.07991767 -92.53266945 2021-03-02 05:23:30 Tama, Iowa, US
802521 802521 2021-03-01 US Iowa Taylor 19173 664 12 0 652 40.73710579 -94.69778563 2021-03-02 05:23:30 Taylor, Iowa, US
802522 802522 2021-03-01 US Iowa Unassigned 90019 989 0 0 989 43.38107862 0.0 2021-03-02 05:23:30 Unassigned, Iowa, US
802523 802523 2021-03-01 US Iowa Union 19175 1263 31 0 1232 41.0277278 -94.24234847 2021-03-02 05:23:30 Union, Iowa, US
802524 802524 2021-03-01 US Iowa Van Buren 19177 559 18 0 541 40.75326764 -91.95017958 2021-03-02 05:23:30 Van Buren, Iowa, US
802525 802525 2021-03-01 US Iowa Wapello 19179 4330 108 0 4222 41.03064984 -92.40954728 2021-03-02 05:23:30 Wapello, Iowa, US
802526 802526 2021-03-01 US Iowa Warren 19181 5552 74 0 5478 41.33559454 -93.56007641 2021-03-02 05:23:30 Warren, Iowa, US
802527 802527 2021-03-01 US Iowa Washington 19183 2541 47 0 2494 41.33577126 -91.71725711 2021-03-02 05:23:30 Washington, Iowa, US
802528 802528 2021-03-01 US Iowa Wayne 19185 488 21 0 467 40.73969028 -93.32752197 2021-03-02 05:23:30 Wayne, Iowa, US
802529 802529 2021-03-01 US Iowa Webster 19187 5187 87 0 5100 42.42853483 -94.17987389 2021-03-02 05:23:30 Webster, Iowa, US
802530 802530 2021-03-01 US Iowa Winnebago 19189 1382 30 0 1352 43.37751174 -93.73407298 2021-03-02 05:23:30 Winnebago, Iowa, US
802531 802531 2021-03-01 US Iowa Winneshiek 19191 1884 27 0 1857 43.29094334 -91.84422722 2021-03-02 05:23:30 Winneshiek, Iowa, US
802532 802532 2021-03-01 US Iowa Woodbury 19193 14961 211 0 14750 42.38979414 -96.0459439 2021-03-02 05:23:30 Woodbury, Iowa, US
802533 802533 2021-03-01 US Iowa Worth 19195 698 7 0 691 43.37750768 -93.26087602 2021-03-02 05:23:30 Worth, Iowa, US
802534 802534 2021-03-01 US Iowa Wright 19197 1797 31 0 1766 42.73305373 -93.73515113 2021-03-02 05:23:30 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] TEXT,
   [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]);