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

15,311 rows where province_or_state = "Missouri" sorted by day descending

View and edit SQL

province_or_state

  • Missouri · 15,311

country_or_region

  • US 15,311
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496439 2020-08-11 US Missouri Andrew 29003 88 1 0 87 39.98492163 -94.80163024 2020-08-12 04:27:29 Andrew, Missouri, US
496440 2020-08-11 US Missouri Butler 29023 286 2 0 284 36.71462476 -90.40421163 2020-08-12 04:27:29 Butler, Missouri, US
496441 2020-08-11 US Missouri Caldwell 29025 35 1 0 34 39.65620858 -93.98308093 2020-08-12 04:27:29 Caldwell, Missouri, US
496442 2020-08-11 US Missouri Camden 29029 363 5 0 358 38.02199522 -92.76083747 2020-08-12 04:27:29 Camden, Missouri, US
496443 2020-08-11 US Missouri Carter 29035 22 1 0 21 36.94160441 -90.96051322 2020-08-12 04:27:29 Carter, Missouri, US
496444 2020-08-11 US Missouri Cass 29037 770 9 0 761 38.64789422 -94.353399 2020-08-12 04:27:29 Cass, Missouri, US
496445 2020-08-11 US Missouri Clark 29045 21 0 0 21 40.41040752 -91.73661677 2020-08-12 04:27:29 Clark, Missouri, US
496446 2020-08-11 US Missouri Osage 29151 52 1 0 51 38.46036182 -91.8613635 2020-08-12 04:27:29 Osage, Missouri, US
496447 2020-08-11 US Missouri Grundy 29079 29 1 0 28 40.11406587 -93.56509276 2020-08-12 04:27:29 Grundy, Missouri, US
496448 2020-08-11 US Missouri Johnson 29101 494 2 0 492 38.74719601 -93.80691168 2020-08-12 04:27:29 Johnson, Missouri, US
496449 2020-08-11 US Missouri McDonald 29119 953 7 0 946 36.62869595 -94.34867205 2020-08-12 04:27:29 McDonald, Missouri, US
496450 2020-08-11 US Missouri Mercer 29129 11 0 0 11 40.42212303 -93.5682959 2020-08-12 04:27:29 Mercer, Missouri, US
496451 2020-08-11 US Missouri New Madrid 29143 259 2 0 257 36.59666326 -89.66070007 2020-08-12 04:27:29 New Madrid, Missouri, US
496452 2020-08-11 US Missouri Pemiscot 29155 237 9 0 228 36.2130572 -89.78742322 2020-08-12 04:27:29 Pemiscot, Missouri, US
496453 2020-08-11 US Missouri Howell 29091 157 2 0 155 36.77383887 -91.88683935 2020-08-12 04:27:29 Howell, Missouri, US
496454 2020-08-11 US Missouri St. Clair 29185 24 0 0 24 38.03699437 -93.77631447 2020-08-12 04:27:29 St. Clair, Missouri, US
496892 2020-08-11 US Missouri Adair 29001 161 0 0 161 40.19058551 -92.60078167 2020-08-12 04:27:29 Adair, Missouri, US
496893 2020-08-11 US Missouri Cape Girardeau 29031 668 5 0 663 37.38489388 -89.6843587 2020-08-12 04:27:29 Cape Girardeau, Missouri, US
496894 2020-08-11 US Missouri Boone 29019 1429 3 0 1426 38.99186229 -92.30723575 2020-08-12 04:27:29 Boone, Missouri, US
496895 2020-08-11 US Missouri Dallas 29059 68 1 0 67 37.6811355 -93.02127031 2020-08-12 04:27:29 Dallas, Missouri, US
496896 2020-08-11 US Missouri Dent 29065 12 0 0 12 37.60663134 -91.50790473 2020-08-12 04:27:29 Dent, Missouri, US
496897 2020-08-11 US Missouri Harrison 29081 60 1 0 59 40.35570088 -93.99222144 2020-08-12 04:27:29 Harrison, Missouri, US
496898 2020-08-11 US Missouri Henry 29083 84 3 0 81 38.38482826 -93.79293734 2020-08-12 04:27:29 Henry, Missouri, US
496899 2020-08-11 US Missouri Jefferson 29099 1663 26 0 1637 38.25926778 -90.53870896 2020-08-12 04:27:29 Jefferson, Missouri, US
496900 2020-08-11 US Missouri Lewis 29111 48 1 0 47 40.09673161 -91.72070156 2020-08-12 04:27:29 Lewis, Missouri, US
496901 2020-08-11 US Missouri Mississippi 29133 141 0 0 141 36.82516239 -89.29505753 2020-08-12 04:27:29 Mississippi, Missouri, US
496902 2020-08-11 US Missouri Morgan 29141 87 0 0 87 38.4181765 -92.88791859 2020-08-12 04:27:29 Morgan, Missouri, US
496903 2020-08-11 US Missouri Pettis 29159 560 4 0 556 38.72798918 -93.28471706 2020-08-12 04:27:29 Pettis, Missouri, US
496904 2020-08-11 US Missouri Pike 29163 110 1 0 109 39.34310674 -91.16980779 2020-08-12 04:27:29 Pike, Missouri, US
496905 2020-08-11 US Missouri Randolph 29175 73 1 0 72 39.44007257 -92.4971374 2020-08-12 04:27:29 Randolph, Missouri, US
496906 2020-08-11 US Missouri Ray 29177 119 0 0 119 39.3537468 -93.98905745 2020-08-12 04:27:29 Ray, Missouri, US
496907 2020-08-11 US Missouri Scott 29201 406 13 0 393 37.05588075 -89.56474493 2020-08-12 04:27:29 Scott, Missouri, US
496908 2020-08-11 US Missouri Worth 29227 9 0 0 9 40.47945588 -94.42328751 2020-08-12 04:27:29 Worth, Missouri, US
497397 2020-08-11 US Missouri Atchison 29005 19 0 0 19 40.43238737 -95.42970639 2020-08-12 04:27:29 Atchison, Missouri, US
497398 2020-08-11 US Missouri Daviess 29061 17 0 0 17 39.96145298 -93.98519678 2020-08-12 04:27:29 Daviess, Missouri, US
497399 2020-08-11 US Missouri Lafayette 29107 180 2 0 178 39.06986886 -93.78076396 2020-08-12 04:27:29 Lafayette, Missouri, US
497400 2020-08-11 US Missouri Linn 29115 33 1 0 32 39.87001769 -93.10704106 2020-08-12 04:27:29 Linn, Missouri, US
497401 2020-08-11 US Missouri Livingston 29117 63 0 0 63 39.78110272 -93.54645978 2020-08-12 04:27:29 Livingston, Missouri, US
497402 2020-08-11 US Missouri Madison 29123 25 0 0 25 37.47865134 -90.3467143 2020-08-12 04:27:29 Madison, Missouri, US
497403 2020-08-11 US Missouri Moniteau 29135 151 2 0 149 38.63571781 -92.57976951 2020-08-12 04:27:29 Moniteau, Missouri, US
497404 2020-08-11 US Missouri Montgomery 29139 41 0 0 41 38.94022054 -91.47000721 2020-08-12 04:27:29 Montgomery, Missouri, US
497405 2020-08-11 US Missouri Greene 29077 1621 10 0 1611 37.2575872 -93.34230916 2020-08-12 04:27:29 Greene, Missouri, US
497406 2020-08-11 US Missouri Sullivan 29211 145 0 0 145 40.2099105 -93.11150106 2020-08-12 04:27:29 Sullivan, Missouri, US
497407 2020-08-11 US Missouri Taney 29213 632 3 0 629 36.65465345 -93.04075153 2020-08-12 04:27:29 Taney, Missouri, US
497408 2020-08-11 US Missouri Wayne 29223 60 0 0 60 37.11303869 -90.46001416 2020-08-12 04:27:29 Wayne, Missouri, US
497409 2020-08-11 US Missouri Jackson 29095 4155 66 0 4089 39.01002188 -94.34724536 2020-08-12 04:27:29 Jackson, Missouri, US
497831 2020-08-11 US Missouri Audrain 29007 205 1 0 204 39.215877 -91.84242683 2020-08-12 04:27:29 Audrain, Missouri, US
497832 2020-08-11 US Missouri Callaway 29027 161 1 0 160 38.83674754 -91.92186505 2020-08-12 04:27:29 Callaway, Missouri, US
497833 2020-08-11 US Missouri Clinton 29049 85 0 0 85 39.6013098 -94.40465394 2020-08-12 04:27:29 Clinton, Missouri, US
497834 2020-08-11 US Missouri Dade 29057 15 0 0 15 37.431814 -93.8503345 2020-08-12 04:27:29 Dade, Missouri, US
497835 2020-08-11 US Missouri Hickory 29085 34 0 0 34 37.94163617 -93.3203037 2020-08-12 04:27:29 Hickory, Missouri, US
497836 2020-08-11 US Missouri Holt 29087 8 0 0 8 40.09799248 -95.2163888 2020-08-12 04:27:29 Holt, Missouri, US
497837 2020-08-11 US Missouri Knox 29103 27 0 0 27 40.12699751 -92.14780832 2020-08-12 04:27:29 Knox, Missouri, US
497838 2020-08-11 US Missouri Ralls 29173 34 0 0 34 39.52817427 -91.51838643 2020-08-12 04:27:29 Ralls, Missouri, US
497839 2020-08-11 US Missouri Shannon 29203 43 1 0 42 37.15772072 -91.40190382 2020-08-12 04:27:29 Shannon, Missouri, US
497840 2020-08-11 US Missouri Ste. Genevieve 29186 57 1 0 56 37.89090059 -90.1949941 2020-08-12 04:27:29 Ste. Genevieve, Missouri, US
497841 2020-08-11 US Missouri Stone 29209 138 1 0 137 36.75000327 -93.45256475 2020-08-12 04:27:29 Stone, Missouri, US
497842 2020-08-11 US Missouri Warren 29219 208 0 0 208 38.76529479 -91.16124662 2020-08-12 04:27:29 Warren, Missouri, US
497843 2020-08-11 US Missouri Unassigned 90029 0 0 0 0 40.47945588 0.0 2020-08-12 04:27:29 Unassigned, Missouri, US
498345 2020-08-11 US Missouri Bates 29013 48 1 0 47 38.25271289 -94.34113157 2020-08-12 04:27:29 Bates, Missouri, US
498346 2020-08-11 US Missouri Christian 29043 373 1 0 372 36.9711783 -93.18537118 2020-08-12 04:27:29 Christian, Missouri, US
498347 2020-08-11 US Missouri Howard 29089 53 0 0 53 39.1435761 -92.69756691 2020-08-12 04:27:29 Howard, Missouri, US
498349 2020-08-11 US Missouri Lincoln 29113 398 1 0 397 39.05345619 -90.95588181 2020-08-12 04:27:29 Lincoln, Missouri, US
498350 2020-08-11 US Missouri Monroe 29137 31 0 0 31 39.49593978 -92.00043978 2020-08-12 04:27:29 Monroe, Missouri, US
498351 2020-08-11 US Missouri Pulaski 29169 230 1 0 229 37.82462075 -92.20783203 2020-08-12 04:27:29 Pulaski, Missouri, US
498352 2020-08-11 US Missouri Saline 29195 441 7 0 434 39.13734288 -93.20259964 2020-08-12 04:27:29 Saline, Missouri, US
498353 2020-08-11 US Missouri Shelby 29205 38 0 0 38 39.79742518 -92.07634971 2020-08-12 04:27:29 Shelby, Missouri, US
498354 2020-08-11 US Missouri St. Charles 29183 4226 87 0 4139 38.77875681 -90.66662425 2020-08-12 04:27:29 St. Charles, Missouri, US
498355 2020-08-11 US Missouri St. Louis 29189 15284 672 0 14612 38.63770039999999 -90.4458375 2020-08-12 04:27:29 St. Louis, Missouri, US
498852 2020-08-11 US Missouri Clay 29047 1064 20 0 1044 39.31132056 -94.41850862 2020-08-12 04:27:29 Clay, Missouri, US
498853 2020-08-11 US Missouri Douglas 29067 89 2 0 87 36.9325593 -92.49905109 2020-08-12 04:27:29 Douglas, Missouri, US
498854 2020-08-11 US Missouri Franklin 29071 642 18 0 624 38.41127108 -91.07522826 2020-08-12 04:27:29 Franklin, Missouri, US
498855 2020-08-11 US Missouri Iron 29093 22 0 0 22 37.55487945 -90.7735296 2020-08-12 04:27:29 Iron, Missouri, US
498856 2020-08-11 US Missouri Macon 29121 60 0 0 60 39.83049768 -92.56453089 2020-08-12 04:27:29 Macon, Missouri, US
498857 2020-08-11 US Missouri Platte 29165 373 10 0 363 39.38154439 -94.77068479 2020-08-12 04:27:29 Platte, Missouri, US
498858 2020-08-11 US Missouri Reynolds 29179 16 0 0 16 37.36085952 -90.97009925 2020-08-12 04:27:29 Reynolds, Missouri, US
498859 2020-08-11 US Missouri Ripley 29181 54 0 0 54 36.65460667 -90.85990261 2020-08-12 04:27:29 Ripley, Missouri, US
498860 2020-08-11 US Missouri Schuyler 29197 11 0 0 11 40.46921489 -92.52311943 2020-08-12 04:27:29 Schuyler, Missouri, US
498861 2020-08-11 US Missouri Vernon 29217 54 0 0 54 37.8457799 -94.34127305 2020-08-12 04:27:29 Vernon, Missouri, US
498862 2020-08-11 US Missouri Wright 29229 62 0 0 62 37.27029221 -92.46914488 2020-08-12 04:27:29 Wright, Missouri, US
498863 2020-08-11 US Missouri Gasconade 29073 26 0 0 26 38.43947277 -91.50847147 2020-08-12 04:27:29 Gasconade, Missouri, US
498864 2020-08-11 US Missouri Gentry 29075 85 9 0 76 40.21097916 -94.40944419 2020-08-12 04:27:29 Gentry, Missouri, US
498865 2020-08-11 US Missouri DeKalb 29063 36 1 0 35 39.89201062 -94.40476508 2020-08-12 04:27:29 DeKalb, Missouri, US
499322 2020-08-11 US Missouri Benton 29015 107 1 0 106 38.29503305 -93.28756116 2020-08-12 04:27:29 Benton, Missouri, US
499323 2020-08-11 US Missouri Carroll 29033 101 0 0 101 39.42762566 -93.50626255 2020-08-12 04:27:29 Carroll, Missouri, US
499324 2020-08-11 US Missouri Cedar 29039 41 0 0 41 37.72391475 -93.85445441 2020-08-12 04:27:29 Cedar, Missouri, US
499325 2020-08-11 US Missouri Chariton 29041 20 0 0 20 39.51499357 -92.9629191 2020-08-12 04:27:29 Chariton, Missouri, US
499326 2020-08-11 US Missouri Kansas City   6885 64 0 6821 39.0997 -94.5786 2020-08-12 04:27:29 Kansas City, Missouri, US
499327 2020-08-11 US Missouri Cooper 29053 135 0 0 135 38.844478 -92.80896081 2020-08-12 04:27:29 Cooper, Missouri, US
499328 2020-08-11 US Missouri Crawford 29055 79 0 0 79 37.97663738 -91.30528104 2020-08-12 04:27:29 Crawford, Missouri, US
499329 2020-08-11 US Missouri Dunklin 29069 319 4 0 315 36.27167174 -90.09122243 2020-08-12 04:27:29 Dunklin, Missouri, US
499330 2020-08-11 US Missouri Laclede 29105 203 1 0 202 37.65896829 -92.5888493 2020-08-12 04:27:29 Laclede, Missouri, US
499331 2020-08-11 US Missouri Marion 29127 204 1 0 203 39.80601912 -91.62203062 2020-08-12 04:27:29 Marion, Missouri, US
499332 2020-08-11 US Missouri Miller 29131 135 1 0 134 38.21450288 -92.42610898 2020-08-12 04:27:29 Miller, Missouri, US
499333 2020-08-11 US Missouri Newton 29145 886 6 0 880 36.90519407 -94.3394104 2020-08-12 04:27:29 Newton, Missouri, US
499334 2020-08-11 US Missouri Oregon 29149 16 0 0 16 36.68710164 -91.4033755 2020-08-12 04:27:29 Oregon, Missouri, US
499335 2020-08-11 US Missouri Putnam 29171 13 1 0 12 40.47942497 -93.02042674 2020-08-12 04:27:29 Putnam, Missouri, US
499336 2020-08-11 US Missouri Scotland 29199 15 1 0 14 40.45214695 -92.14709064 2020-08-12 04:27:29 Scotland, Missouri, US
499337 2020-08-11 US Missouri Stoddard 29207 232 9 0 223 36.85571651 -89.9444155 2020-08-12 04:27:29 Stoddard, Missouri, US
499338 2020-08-11 US Missouri Washington 29221 87 1 0 86 37.96130078 -90.87948158 2020-08-12 04:27:29 Washington, Missouri, 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 2163.712ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette