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

38,945 rows where province_or_state = "Missouri" sorted by day descending

View and edit SQL

province_or_state

  • Missouri · 38,945

country_or_region

  • US 38,945
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
803144 2021-03-01 US Missouri Adair 29001 2076 16 0 2060 40.19058551 -92.60078167 2021-03-02 05:23:30 Adair, Missouri, US
803145 2021-03-01 US Missouri Andrew 29003 1284 17 0 1267 39.98492163 -94.80163024 2021-03-02 05:23:30 Andrew, Missouri, US
803146 2021-03-01 US Missouri Atchison 29005 290 6 0 284 40.43238737 -95.42970639 2021-03-02 05:23:30 Atchison, Missouri, US
803147 2021-03-01 US Missouri Audrain 29007 2075 58 0 2017 39.215877 -91.84242683 2021-03-02 05:23:30 Audrain, Missouri, US
803148 2021-03-01 US Missouri Barry 29009 2193 44 0 2149 36.70978521 -93.82919888 2021-03-02 05:23:30 Barry, Missouri, US
803149 2021-03-01 US Missouri Barton 29011 967 12 0 955 37.50207671 -94.34757022 2021-03-02 05:23:30 Barton, Missouri, US
803150 2021-03-01 US Missouri Bates 29013 1083 23 0 1060 38.25271289 -94.34113157 2021-03-02 05:23:30 Bates, Missouri, US
803151 2021-03-01 US Missouri Benton 29015 1453 26 0 1427 38.29503305 -93.28756116 2021-03-02 05:23:30 Benton, Missouri, US
803152 2021-03-01 US Missouri Bollinger 29017 1053 12 0 1041 37.32449052 -90.02725304 2021-03-02 05:23:30 Bollinger, Missouri, US
803153 2021-03-01 US Missouri Boone 29019 15903 80 0 15823 38.99186229 -92.30723575 2021-03-02 05:23:30 Boone, Missouri, US
803154 2021-03-01 US Missouri Buchanan 29021 6956 135 0 6821 39.65816401 -94.80138942 2021-03-02 05:23:30 Buchanan, Missouri, US
803155 2021-03-01 US Missouri Butler 29023 3504 34 0 3470 36.71462476 -90.40421163 2021-03-02 05:23:30 Butler, Missouri, US
803156 2021-03-01 US Missouri Caldwell 29025 641 10 0 631 39.65620858 -93.98308093 2021-03-02 05:23:30 Caldwell, Missouri, US
803157 2021-03-01 US Missouri Callaway 29027 4494 43 0 4451 38.83674754 -91.92186505 2021-03-02 05:23:30 Callaway, Missouri, US
803158 2021-03-01 US Missouri Camden 29029 3725 81 0 3644 38.02199522 -92.76083747 2021-03-02 05:23:30 Camden, Missouri, US
803159 2021-03-01 US Missouri Cape Girardeau 29031 7518 125 0 7393 37.38489388 -89.6843587 2021-03-02 05:23:30 Cape Girardeau, Missouri, US
803160 2021-03-01 US Missouri Carroll 29033 835 23 0 812 39.42762566 -93.50626255 2021-03-02 05:23:30 Carroll, Missouri, US
803161 2021-03-01 US Missouri Carter 29035 424 8 0 416 36.94160441 -90.96051322 2021-03-02 05:23:30 Carter, Missouri, US
803162 2021-03-01 US Missouri Cass 29037 7246 89 0 7157 38.64789422 -94.353399 2021-03-02 05:23:30 Cass, Missouri, US
803163 2021-03-01 US Missouri Cedar 29039 704 18 0 686 37.72391475 -93.85445441 2021-03-02 05:23:30 Cedar, Missouri, US
803164 2021-03-01 US Missouri Chariton 29041 422 6 0 416 39.51499357 -92.9629191 2021-03-02 05:23:30 Chariton, Missouri, US
803165 2021-03-01 US Missouri Christian 29043 6877 78 0 6799 36.9711783 -93.18537118 2021-03-02 05:23:30 Christian, Missouri, US
803166 2021-03-01 US Missouri Clark 29045 471 6 0 465 40.41040752 -91.73661677 2021-03-02 05:23:30 Clark, Missouri, US
803167 2021-03-01 US Missouri Clay 29047 7898 144 0 7754 39.31132056 -94.41850862 2021-03-02 05:23:30 Clay, Missouri, US
803168 2021-03-01 US Missouri Clinton 29049 1525 64 0 1461 39.6013098 -94.40465394 2021-03-02 05:23:30 Clinton, Missouri, US
803169 2021-03-01 US Missouri Cole 29051 8580 114 0 8466 38.50455671 -92.27860244 2021-03-02 05:23:30 Cole, Missouri, US
803170 2021-03-01 US Missouri Cooper 29053 1694 26 0 1668 38.844478 -92.80896081 2021-03-02 05:23:30 Cooper, Missouri, US
803171 2021-03-01 US Missouri Crawford 29055 2052 30 0 2022 37.97663738 -91.30528104 2021-03-02 05:23:30 Crawford, Missouri, US
803172 2021-03-01 US Missouri Dade 29057 420 13 0 407 37.431814 -93.8503345 2021-03-02 05:23:30 Dade, Missouri, US
803173 2021-03-01 US Missouri Dallas 29059 826 24 0 802 37.6811355 -93.02127031 2021-03-02 05:23:30 Dallas, Missouri, US
803174 2021-03-01 US Missouri Daviess 29061 587 11 0 576 39.96145298 -93.98519678 2021-03-02 05:23:30 Daviess, Missouri, US
803175 2021-03-01 US Missouri DeKalb 29063 921 27 0 894 39.89201062 -94.40476508 2021-03-02 05:23:30 DeKalb, Missouri, US
803176 2021-03-01 US Missouri Dent 29065 820 16 0 804 37.60663134 -91.50790473 2021-03-02 05:23:30 Dent, Missouri, US
803177 2021-03-01 US Missouri Douglas 29067 769 25 0 744 36.9325593 -92.49905109 2021-03-02 05:23:30 Douglas, Missouri, US
803178 2021-03-01 US Missouri Dunklin 29069 2413 19 0 2394 36.27167174 -90.09122243 2021-03-02 05:23:30 Dunklin, Missouri, US
803179 2021-03-01 US Missouri Franklin 29071 8423 154 0 8269 38.41127108 -91.07522826 2021-03-02 05:23:30 Franklin, Missouri, US
803180 2021-03-01 US Missouri Gasconade 29073 878 39 0 839 38.43947277 -91.50847147 2021-03-02 05:23:30 Gasconade, Missouri, US
803181 2021-03-01 US Missouri Gentry 29075 734 20 0 714 40.21097916 -94.40944419 2021-03-02 05:23:30 Gentry, Missouri, US
803182 2021-03-01 US Missouri Greene 29077 23428 427 0 23001 37.2575872 -93.34230916 2021-03-02 05:23:30 Greene, Missouri, US
803183 2021-03-01 US Missouri Grundy 29079 828 34 0 794 40.11406587 -93.56509276 2021-03-02 05:23:30 Grundy, Missouri, US
803184 2021-03-01 US Missouri Harrison 29081 827 14 0 813 40.35570088 -93.99222144 2021-03-02 05:23:30 Harrison, Missouri, US
803185 2021-03-01 US Missouri Henry 29083 1743 36 0 1707 38.38482826 -93.79293734 2021-03-02 05:23:30 Henry, Missouri, US
803186 2021-03-01 US Missouri Hickory 29085 467 13 0 454 37.94163617 -93.3203037 2021-03-02 05:23:30 Hickory, Missouri, US
803187 2021-03-01 US Missouri Holt 29087 366 10 0 356 40.09799248 -95.2163888 2021-03-02 05:23:30 Holt, Missouri, US
803188 2021-03-01 US Missouri Howard 29089 721 5 0 716 39.1435761 -92.69756691 2021-03-02 05:23:30 Howard, Missouri, US
803189 2021-03-01 US Missouri Howell 29091 2821 42 0 2779 36.77383887 -91.88683935 2021-03-02 05:23:30 Howell, Missouri, US
803190 2021-03-01 US Missouri Iron 29093 464 5 0 459 37.55487945 -90.7735296 2021-03-02 05:23:30 Iron, Missouri, US
803191 2021-03-01 US Missouri Jackson 29095 30137 381 0 29756 39.01002188 -94.34724536 2021-03-02 05:23:30 Jackson, Missouri, US
803192 2021-03-01 US Missouri Jasper 29097 12224 219 0 12005 37.20351921 -94.34050458 2021-03-02 05:23:30 Jasper, Missouri, US
803193 2021-03-01 US Missouri Jefferson 29099 19006 210 0 18796 38.25926778 -90.53870896 2021-03-02 05:23:30 Jefferson, Missouri, US
803194 2021-03-01 US Missouri Johnson 29101 3865 45 0 3820 38.74719601 -93.80691168 2021-03-02 05:23:30 Johnson, Missouri, US
803195 2021-03-01 US Missouri Kansas City   36687 514 0 36173 39.0997 -94.5786 2021-03-02 05:23:30 Kansas City, Missouri, US
803196 2021-03-01 US Missouri Knox 29103 179 2 0 177 40.12699751 -92.14780832 2021-03-02 05:23:30 Knox, Missouri, US
803197 2021-03-01 US Missouri Laclede 29105 2923 66 0 2857 37.65896829 -92.5888493 2021-03-02 05:23:30 Laclede, Missouri, US
803198 2021-03-01 US Missouri Lafayette 29107 2557 54 0 2503 39.06986886 -93.78076396 2021-03-02 05:23:30 Lafayette, Missouri, US
803199 2021-03-01 US Missouri Lawrence 29109 2763 72 0 2691 37.10626634 -93.83293097 2021-03-02 05:23:30 Lawrence, Missouri, US
803200 2021-03-01 US Missouri Lewis 29111 631 7 0 624 40.09673161 -91.72070156 2021-03-02 05:23:30 Lewis, Missouri, US
803201 2021-03-01 US Missouri Lincoln 29113 4299 36 0 4263 39.05345619 -90.95588181 2021-03-02 05:23:30 Lincoln, Missouri, US
803202 2021-03-01 US Missouri Linn 29115 544 12 0 532 39.87001769 -93.10704106 2021-03-02 05:23:30 Linn, Missouri, US
803203 2021-03-01 US Missouri Livingston 29117 1331 37 0 1294 39.78110272 -93.54645978 2021-03-02 05:23:30 Livingston, Missouri, US
803204 2021-03-01 US Missouri Macon 29121 1211 14 0 1197 39.83049768 -92.56453089 2021-03-02 05:23:30 Macon, Missouri, US
803205 2021-03-01 US Missouri Madison 29123 1345 16 0 1329 37.47865134 -90.3467143 2021-03-02 05:23:30 Madison, Missouri, US
803206 2021-03-01 US Missouri Maries 29125 536 7 0 529 38.16193985 -91.92249662 2021-03-02 05:23:30 Maries, Missouri, US
803207 2021-03-01 US Missouri Marion 29127 2646 41 0 2605 39.80601912 -91.62203062 2021-03-02 05:23:30 Marion, Missouri, US
803208 2021-03-01 US Missouri McDonald 29119 1922 26 0 1896 36.62869595 -94.34867205 2021-03-02 05:23:30 McDonald, Missouri, US
803209 2021-03-01 US Missouri Mercer 29129 178 2 0 176 40.42212303 -93.5682959 2021-03-02 05:23:30 Mercer, Missouri, US
803210 2021-03-01 US Missouri Miller 29131 2316 49 0 2267 38.21450288 -92.42610898 2021-03-02 05:23:30 Miller, Missouri, US
803211 2021-03-01 US Missouri Mississippi 29133 1270 24 0 1246 36.82516239 -89.29505753 2021-03-02 05:23:30 Mississippi, Missouri, US
803212 2021-03-01 US Missouri Moniteau 29135 1681 29 0 1652 38.63571781 -92.57976951 2021-03-02 05:23:30 Moniteau, Missouri, US
803213 2021-03-01 US Missouri Monroe 29137 597 10 0 587 39.49593978 -92.00043978 2021-03-02 05:23:30 Monroe, Missouri, US
803214 2021-03-01 US Missouri Montgomery 29139 568 10 0 558 38.94022054 -91.47000721 2021-03-02 05:23:30 Montgomery, Missouri, US
803215 2021-03-01 US Missouri Morgan 29141 1622 40 0 1582 38.4181765 -92.88791859 2021-03-02 05:23:30 Morgan, Missouri, US
803216 2021-03-01 US Missouri New Madrid 29143 1768 45 0 1723 36.59666326 -89.66070007 2021-03-02 05:23:30 New Madrid, Missouri, US
803217 2021-03-01 US Missouri Newton 29145 4080 66 0 4014 36.90519407 -94.3394104 2021-03-02 05:23:30 Newton, Missouri, US
803218 2021-03-01 US Missouri Nodaway 29147 2577 24 0 2553 40.36079813 -94.88133008 2021-03-02 05:23:30 Nodaway, Missouri, US
803219 2021-03-01 US Missouri Oregon 29149 676 3 0 673 36.68710164 -91.4033755 2021-03-02 05:23:30 Oregon, Missouri, US
803220 2021-03-01 US Missouri Osage 29151 1403 13 0 1390 38.46036182 -91.8613635 2021-03-02 05:23:30 Osage, Missouri, US
803221 2021-03-01 US Missouri Ozark 29153 550 13 0 537 36.64916339 -92.44459066 2021-03-02 05:23:30 Ozark, Missouri, US
803222 2021-03-01 US Missouri Pemiscot 29155 1412 28 0 1384 36.2130572 -89.78742322 2021-03-02 05:23:30 Pemiscot, Missouri, US
803223 2021-03-01 US Missouri Perry 29157 2051 26 0 2025 37.70660776 -89.82741088 2021-03-02 05:23:30 Perry, Missouri, US
803224 2021-03-01 US Missouri Pettis 29159 4787 76 0 4711 38.72798918 -93.28471706 2021-03-02 05:23:30 Pettis, Missouri, US
803225 2021-03-01 US Missouri Phelps 29161 3020 121 0 2899 37.87736118 -91.79351727 2021-03-02 05:23:30 Phelps, Missouri, US
803226 2021-03-01 US Missouri Pike 29163 1488 22 0 1466 39.34310674 -91.16980779 2021-03-02 05:23:30 Pike, Missouri, US
803227 2021-03-01 US Missouri Platte 29165 3119 42 0 3077 39.38154439 -94.77068479 2021-03-02 05:23:30 Platte, Missouri, US
803228 2021-03-01 US Missouri Polk 29167 2162 31 0 2131 37.6162296 -93.39828174 2021-03-02 05:23:30 Polk, Missouri, US
803229 2021-03-01 US Missouri Pulaski 29169 2990 44 0 2946 37.82462075 -92.20783203 2021-03-02 05:23:30 Pulaski, Missouri, US
803230 2021-03-01 US Missouri Putnam 29171 225 3 0 222 40.47942497 -93.02042674 2021-03-02 05:23:30 Putnam, Missouri, US
803231 2021-03-01 US Missouri Ralls 29173 758 12 0 746 39.52817427 -91.51838643 2021-03-02 05:23:30 Ralls, Missouri, US
803232 2021-03-01 US Missouri Randolph 29175 1813 29 0 1784 39.44007257 -92.4971374 2021-03-02 05:23:30 Randolph, Missouri, US
803233 2021-03-01 US Missouri Ray 29177 1517 24 0 1493 39.3537468 -93.98905745 2021-03-02 05:23:30 Ray, Missouri, US
803234 2021-03-01 US Missouri Reynolds 29179 260 3 0 257 37.36085952 -90.97009925 2021-03-02 05:23:30 Reynolds, Missouri, US
803235 2021-03-01 US Missouri Ripley 29181 854 14 0 840 36.65460667 -90.85990261 2021-03-02 05:23:30 Ripley, Missouri, US
803236 2021-03-01 US Missouri Saline 29195 2427 35 0 2392 39.13734288 -93.20259964 2021-03-02 05:23:30 Saline, Missouri, US
803237 2021-03-01 US Missouri Schuyler 29197 274 3 0 271 40.46921489 -92.52311943 2021-03-02 05:23:30 Schuyler, Missouri, US
803238 2021-03-01 US Missouri Scotland 29199 263 3 0 260 40.45214695 -92.14709064 2021-03-02 05:23:30 Scotland, Missouri, US
803239 2021-03-01 US Missouri Scott 29201 3833 76 0 3757 37.05588075 -89.56474493 2021-03-02 05:23:30 Scott, Missouri, US
803240 2021-03-01 US Missouri Shannon 29203 482 10 0 472 37.15772072 -91.40190382 2021-03-02 05:23:30 Shannon, Missouri, US
803241 2021-03-01 US Missouri Shelby 29205 354 7 0 347 39.79742518 -92.07634971 2021-03-02 05:23:30 Shelby, Missouri, US
803242 2021-03-01 US Missouri St. Charles 29183 32961 413 0 32548 38.77875681 -90.66662425 2021-03-02 05:23:30 St. Charles, Missouri, US
803243 2021-03-01 US Missouri St. Clair 29185 583 7 0 576 38.03699437 -93.77631447 2021-03-02 05:23:30 St. Clair, 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] 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]);