johns_hopkins_csse_daily_reports

⚠️ 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

13,703 rows where province_or_state = "Iowa" sorted by day descending

View and edit SQL

province_or_state

  • Iowa · 13,703

country_or_region

  • US 13,703
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
135196 2020-08-12 US Iowa Adair 19001 34 0 0 34 41.33075609 -94.47105874 2020-08-13 04:29:15 Adair, Iowa, US
135197 2020-08-12 US Iowa Adams 19003 17 0 0 17 41.02903567 -94.69932645 2020-08-13 04:29:15 Adams, Iowa, US
135198 2020-08-12 US Iowa Allamakee 19005 158 4 0 154 43.28383218 -91.37860922 2020-08-13 04:29:15 Allamakee, Iowa, US
135199 2020-08-12 US Iowa Appanoose 19007 52 3 0 49 40.74324454 -92.86865906 2020-08-13 04:29:15 Appanoose, Iowa, US
135200 2020-08-12 US Iowa Audubon 19009 29 1 0 28 41.6844628 -94.90581859 2020-08-13 04:29:15 Audubon, Iowa, US
135201 2020-08-12 US Iowa Benton 19011 160 1 0 159 42.08011739 -92.06463573 2020-08-13 04:29:15 Benton, Iowa, US
135202 2020-08-12 US Iowa Black Hawk 19013 3180 66 0 3114 42.4704581 -92.30524729 2020-08-13 04:29:15 Black Hawk, Iowa, US
135203 2020-08-12 US Iowa Boone 19015 266 3 0 263 42.03657094 -93.9313999 2020-08-13 04:29:15 Boone, Iowa, US
135204 2020-08-12 US Iowa Bremer 19017 231 7 0 224 42.77461496 -92.31795937 2020-08-13 04:29:15 Bremer, Iowa, US
135205 2020-08-12 US Iowa Buchanan 19019 130 1 0 129 42.4709188 -91.83510825 2020-08-13 04:29:15 Buchanan, Iowa, US
135206 2020-08-12 US Iowa Buena Vista 19021 1797 12 0 1785 42.73545875 -95.15100162 2020-08-13 04:29:15 Buena Vista, Iowa, US
135207 2020-08-12 US Iowa Butler 19023 127 2 0 125 42.73172833 -92.79015971 2020-08-13 04:29:15 Butler, Iowa, US
135208 2020-08-12 US Iowa Calhoun 19025 86 2 0 84 42.38521079 -94.64046046 2020-08-13 04:29:15 Calhoun, Iowa, US
135209 2020-08-12 US Iowa Carroll 19027 196 2 0 194 42.03617207 -94.86032705 2020-08-13 04:29:15 Carroll, Iowa, US
135210 2020-08-12 US Iowa Cass 19029 82 1 0 81 41.33149454 -94.92792482 2020-08-13 04:29:15 Cass, Iowa, US
135211 2020-08-12 US Iowa Cedar 19031 135 1 0 134 41.77233777 -91.13246684 2020-08-13 04:29:15 Cedar, Iowa, US
135212 2020-08-12 US Iowa Cerro Gordo 19033 644 17 0 627 43.08177563 -93.2612239 2020-08-13 04:29:15 Cerro Gordo, Iowa, US
135213 2020-08-12 US Iowa Cherokee 19035 110 1 0 109 42.73538914 -95.62389402 2020-08-13 04:29:15 Cherokee, Iowa, US
135214 2020-08-12 US Iowa Chickasaw 19037 56 0 0 56 43.06001295 -92.31773347 2020-08-13 04:29:15 Chickasaw, Iowa, US
135215 2020-08-12 US Iowa Clarke 19039 206 3 0 203 41.02868181 -93.78499767 2020-08-13 04:29:15 Clarke, Iowa, US
135216 2020-08-12 US Iowa Clay 19041 203 1 0 202 43.08247182 -95.15096481 2020-08-13 04:29:15 Clay, Iowa, US
135217 2020-08-12 US Iowa Clayton 19043 108 3 0 105 42.84443388 -91.34133693 2020-08-13 04:29:15 Clayton, Iowa, US
135218 2020-08-12 US Iowa Clinton 19045 421 4 0 417 41.89981633 -90.53275096 2020-08-13 04:29:15 Clinton, Iowa, US
135219 2020-08-12 US Iowa Crawford 19047 736 3 0 733 42.03718237 -95.3819718 2020-08-13 04:29:15 Crawford, Iowa, US
135220 2020-08-12 US Iowa Dallas 19049 1913 35 0 1878 41.68560356 -94.04127625 2020-08-13 04:29:15 Dallas, Iowa, US
135221 2020-08-12 US Iowa Davis 19051 61 2 0 59 40.74773536 -92.41005468 2020-08-13 04:29:15 Davis, Iowa, US
135222 2020-08-12 US Iowa Decatur 19053 26 0 0 26 40.73742757 -93.78645949 2020-08-13 04:29:15 Decatur, Iowa, US
135223 2020-08-12 US Iowa Delaware 19055 123 1 0 122 42.47104597 -91.3664492 2020-08-13 04:29:15 Delaware, Iowa, US
135224 2020-08-12 US Iowa Des Moines 19057 194 2 0 192 40.92012606 -91.18326592 2020-08-13 04:29:15 Des Moines, Iowa, US
135225 2020-08-12 US Iowa Dickinson 19059 385 4 0 381 43.37787725 -95.1510206 2020-08-13 04:29:15 Dickinson, Iowa, US
135226 2020-08-12 US Iowa Dubuque 19061 1722 31 0 1691 42.46815349 -90.88181925 2020-08-13 04:29:15 Dubuque, Iowa, US
135227 2020-08-12 US Iowa Emmet 19063 193 4 0 189 43.37782951 -94.67858943 2020-08-13 04:29:15 Emmet, Iowa, US
135228 2020-08-12 US Iowa Fayette 19065 86 0 0 86 42.86271799 -91.8441231 2020-08-13 04:29:15 Fayette, Iowa, US
135229 2020-08-12 US Iowa Floyd 19067 163 3 0 160 43.06000529999999 -92.78940097 2020-08-13 04:29:15 Floyd, Iowa, US
135230 2020-08-12 US Iowa Franklin 19069 248 12 0 236 42.73270384 -93.26256925 2020-08-13 04:29:15 Franklin, Iowa, US
135231 2020-08-12 US Iowa Fremont 19071 44 0 0 44 40.74542720000001 -95.60129045 2020-08-13 04:29:15 Fremont, Iowa, US
135232 2020-08-12 US Iowa Greene 19073 42 0 0 42 42.03614551 -94.39658081 2020-08-13 04:29:15 Greene, Iowa, US
135233 2020-08-12 US Iowa Grundy 19075 82 1 0 81 42.40183723 -92.78829551 2020-08-13 04:29:15 Grundy, Iowa, US
135234 2020-08-12 US Iowa Guthrie 19077 137 5 0 132 41.68378965 -94.50111014 2020-08-13 04:29:15 Guthrie, Iowa, US
135235 2020-08-12 US Iowa Hamilton 19079 252 1 0 251 42.38382428 -93.70197703 2020-08-13 04:29:15 Hamilton, Iowa, US
135236 2020-08-12 US Iowa Hancock 19081 123 2 0 121 43.08178477 -93.73454884 2020-08-13 04:29:15 Hancock, Iowa, US
135237 2020-08-12 US Iowa Hardin 19083 185 0 0 185 42.38353877 -93.23654611 2020-08-13 04:29:15 Hardin, Iowa, US
135238 2020-08-12 US Iowa Harrison 19085 110 1 0 109 41.68330137 -95.81558439 2020-08-13 04:29:15 Harrison, Iowa, US
135239 2020-08-12 US Iowa Henry 19087 136 4 0 132 40.98767962 -91.54436349 2020-08-13 04:29:15 Henry, Iowa, US
135240 2020-08-12 US Iowa Howard 19089 50 0 0 50 43.35671042 -92.31702714 2020-08-13 04:29:15 Howard, Iowa, US
135241 2020-08-12 US Iowa Humboldt 19091 122 1 0 121 42.7764426 -94.20722537 2020-08-13 04:29:15 Humboldt, Iowa, US
135242 2020-08-12 US Iowa Ida 19093 32 0 0 32 42.38696136 -95.51355387 2020-08-13 04:29:15 Ida, Iowa, US
135243 2020-08-12 US Iowa Iowa 19095 97 1 0 96 41.68630265 -92.0643373 2020-08-13 04:29:15 Iowa, Iowa, US
135244 2020-08-12 US Iowa Jackson 19097 158 1 0 157 42.17178824 -90.57354837 2020-08-13 04:29:15 Jackson, Iowa, US
135245 2020-08-12 US Iowa Jasper 19099 484 27 0 457 41.68576082 -93.05567785 2020-08-13 04:29:15 Jasper, Iowa, US
135246 2020-08-12 US Iowa Jefferson 19101 87 0 0 87 41.03192394 -91.94849466 2020-08-13 04:29:15 Jefferson, Iowa, US
135247 2020-08-12 US Iowa Johnson 19103 2123 20 0 2103 41.67169354 -91.58754744 2020-08-13 04:29:15 Johnson, Iowa, US
135248 2020-08-12 US Iowa Jones 19105 134 2 0 132 42.12118609 -91.13139641 2020-08-13 04:29:15 Jones, Iowa, US
135249 2020-08-12 US Iowa Keokuk 19107 39 1 0 38 41.33649833 -92.1785067 2020-08-13 04:29:15 Keokuk, Iowa, US
135250 2020-08-12 US Iowa Kossuth 19109 95 0 0 95 43.20405458 -94.20691791 2020-08-13 04:29:15 Kossuth, Iowa, US
135251 2020-08-12 US Iowa Lee 19111 121 4 0 117 40.64181461 -91.48183025 2020-08-13 04:29:15 Lee, Iowa, US
135252 2020-08-12 US Iowa Linn 19113 2445 88 0 2357 42.07923082 -91.59809485 2020-08-13 04:29:15 Linn, Iowa, US
135253 2020-08-12 US Iowa Louisa 19115 378 14 0 364 41.21842119 -91.26102611 2020-08-13 04:29:15 Louisa, Iowa, US
135254 2020-08-12 US Iowa Lucas 19117 73 4 0 69 41.02958964 -93.32780803 2020-08-13 04:29:15 Lucas, Iowa, US
135255 2020-08-12 US Iowa Lyon 19119 119 2 0 117 43.38107862 -96.20926845 2020-08-13 04:29:15 Lyon, Iowa, US
135256 2020-08-12 US Iowa Madison 19121 127 2 0 125 41.33081904 -94.01554631 2020-08-13 04:29:15 Madison, Iowa, US
135257 2020-08-12 US Iowa Mahaska 19123 142 17 0 125 41.33521503 -92.64083907 2020-08-13 04:29:15 Mahaska, Iowa, US
135258 2020-08-12 US Iowa Marion 19125 177 0 0 177 41.33445101 -93.09934783 2020-08-13 04:29:15 Marion, Iowa, US
135259 2020-08-12 US Iowa Marshall 19127 1452 26 0 1426 42.03586837 -92.9990819 2020-08-13 04:29:15 Marshall, Iowa, US
135260 2020-08-12 US Iowa Mills 19129 93 1 0 92 41.03299766 -95.61920963 2020-08-13 04:29:15 Mills, Iowa, US
135261 2020-08-12 US Iowa Mitchell 19131 80 0 0 80 43.35638371 -92.78887719 2020-08-13 04:29:15 Mitchell, Iowa, US
135262 2020-08-12 US Iowa Monona 19133 91 0 0 91 42.05220391 -95.95743843 2020-08-13 04:29:15 Monona, Iowa, US
135263 2020-08-12 US Iowa Monroe 19135 74 8 0 66 41.02988815 -92.8690667 2020-08-13 04:29:15 Monroe, Iowa, US
135264 2020-08-12 US Iowa Montgomery 19137 60 4 0 56 41.03018714 -95.15642896 2020-08-13 04:29:15 Montgomery, Iowa, US
135265 2020-08-12 US Iowa Muscatine 19139 857 48 0 809 41.48370744 -91.1121697 2020-08-13 04:29:15 Muscatine, Iowa, US
135266 2020-08-12 US Iowa O'Brien 19141 143 5 0 138 43.08310673 -95.62474482 2020-08-13 04:29:15 O'Brien, Iowa, US
135267 2020-08-12 US Iowa Osceola 19143 85 0 0 85 43.37824276 -95.62422844 2020-08-13 04:29:15 Osceola, Iowa, US
135268 2020-08-12 US Iowa Page 19145 96 0 0 96 40.7393172 -95.1497813 2020-08-13 04:29:15 Page, Iowa, US
135269 2020-08-12 US Iowa Palo Alto 19147 90 0 0 90 43.08193849 -94.67824621 2020-08-13 04:29:15 Palo Alto, Iowa, US
135270 2020-08-12 US Iowa Plymouth 19149 474 12 0 462 42.737633 -96.21366621 2020-08-13 04:29:15 Plymouth, Iowa, US
135271 2020-08-12 US Iowa Pocahontas 19151 118 2 0 116 42.73420133 -94.67862564 2020-08-13 04:29:15 Pocahontas, Iowa, US
135272 2020-08-12 US Iowa Polk 19153 10535 208 0 10327 41.68679484 -93.57767461 2020-08-13 04:29:15 Polk, Iowa, US
135273 2020-08-12 US Iowa Pottawattamie 19155 1350 29 0 1321 41.33640314 -95.53907776 2020-08-13 04:29:15 Pottawattamie, Iowa, US
135274 2020-08-12 US Iowa Poweshiek 19157 159 8 0 151 41.68625425 -92.53155731 2020-08-13 04:29:15 Poweshiek, Iowa, US
135275 2020-08-12 US Iowa Ringgold 19159 23 1 0 22 40.73518949 -94.24368535 2020-08-13 04:29:15 Ringgold, Iowa, US
135276 2020-08-12 US Iowa Sac 19161 86 0 0 86 42.38624071 -95.10547892 2020-08-13 04:29:15 Sac, Iowa, US
135277 2020-08-12 US Iowa Scott 19163 1758 14 0 1744 41.63935978 -90.61959493 2020-08-13 04:29:15 Scott, Iowa, US
135278 2020-08-12 US Iowa Shelby 19165 187 1 0 186 41.6850066 -95.31015553 2020-08-13 04:29:15 Shelby, Iowa, US
135279 2020-08-12 US Iowa Sioux 19167 650 3 0 647 43.08221074 -96.1767568 2020-08-13 04:29:15 Sioux, Iowa, US
135280 2020-08-12 US Iowa Story 19169 1181 15 0 1166 42.03621213 -93.46499005 2020-08-13 04:29:15 Story, Iowa, US
135281 2020-08-12 US Iowa Tama 19171 556 29 0 527 42.07991767 -92.53266945 2020-08-13 04:29:15 Tama, Iowa, US
135282 2020-08-12 US Iowa Taylor 19173 100 0 0 100 40.73710579 -94.69778563 2020-08-13 04:29:15 Taylor, Iowa, US
135283 2020-08-12 US Iowa Unassigned 90019 7 0 0 7 43.38107862 0.0 2020-08-13 04:29:15 Unassigned, Iowa, US
135284 2020-08-12 US Iowa Union 19175 78 1 0 77 41.0277278 -94.24234847 2020-08-13 04:29:15 Union, Iowa, US
135285 2020-08-12 US Iowa Van Buren 19177 36 1 0 35 40.75326764 -91.95017958 2020-08-13 04:29:15 Van Buren, Iowa, US
135286 2020-08-12 US Iowa Wapello 19179 927 33 0 894 41.03064984 -92.40954728 2020-08-13 04:29:15 Wapello, Iowa, US
135287 2020-08-12 US Iowa Warren 19181 582 1 0 581 41.33559454 -93.56007641 2020-08-13 04:29:15 Warren, Iowa, US
135288 2020-08-12 US Iowa Washington 19183 305 10 0 295 41.33577126 -91.71725711 2020-08-13 04:29:15 Washington, Iowa, US
135289 2020-08-12 US Iowa Wayne 19185 20 1 0 19 40.73969028 -93.32752197 2020-08-13 04:29:15 Wayne, Iowa, US
135290 2020-08-12 US Iowa Webster 19187 842 8 0 834 42.42853483 -94.17987389 2020-08-13 04:29:15 Webster, Iowa, US
135291 2020-08-12 US Iowa Winnebago 19189 89 0 0 89 43.37751174 -93.73407298 2020-08-13 04:29:15 Winnebago, Iowa, US
135292 2020-08-12 US Iowa Winneshiek 19191 97 1 0 96 43.29094334 -91.84422722 2020-08-13 04:29:15 Winneshiek, Iowa, US
135293 2020-08-12 US Iowa Woodbury 19193 3754 52 0 3702 42.38979414 -96.0459439 2020-08-13 04:29:15 Woodbury, Iowa, US
135294 2020-08-12 US Iowa Worth 19195 68 0 0 68 43.37750768 -93.26087602 2020-08-13 04:29:15 Worth, Iowa, US
135295 2020-08-12 US Iowa Wright 19197 478 1 0 477 42.73305373 -93.73515113 2020-08-13 04:29:15 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]);
Powered by Datasette · Query took 2102.514ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette