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

48,112 rows where province_or_state = "Mississippi" 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

  • Mississippi · 48,112 ✖

country_or_region

  • US 48,112
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
34066 34066 2021-10-23 US Mississippi Adams 28001 4587 119 0   31.47669768 -91.35326037 2021-10-24 04:21:22 Adams, Mississippi, US
34067 34067 2021-10-23 US Mississippi Alcorn 28003 5669 101 0   34.88084463 -88.57996173 2021-10-24 04:21:22 Alcorn, Mississippi, US
34068 34068 2021-10-23 US Mississippi Amite 28005 2051 56 0   31.17467303 -90.80501621 2021-10-24 04:21:22 Amite, Mississippi, US
34069 34069 2021-10-23 US Mississippi Attala 28007 3315 89 0   33.08658803 -89.57838564 2021-10-24 04:21:22 Attala, Mississippi, US
34070 34070 2021-10-23 US Mississippi Benton 28009 1488 38 0   34.81681228 -89.18945516 2021-10-24 04:21:22 Benton, Mississippi, US
34071 34071 2021-10-23 US Mississippi Bolivar 28011 6317 148 0   33.79696941 -90.87372121 2021-10-24 04:21:22 Bolivar, Mississippi, US
34072 34072 2021-10-23 US Mississippi Calhoun 28013 2794 46 0   33.93683395 -89.33686647 2021-10-24 04:21:22 Calhoun, Mississippi, US
34073 34073 2021-10-23 US Mississippi Carroll 28015 1691 38 0   33.44834567 -89.91994479 2021-10-24 04:21:22 Carroll, Mississippi, US
34074 34074 2021-10-23 US Mississippi Chickasaw 28017 3003 67 0   33.91983202 -88.9481545 2021-10-24 04:21:22 Chickasaw, Mississippi, US
34075 34075 2021-10-23 US Mississippi Choctaw 28019 1334 26 0   33.34598242 -89.24809382 2021-10-24 04:21:22 Choctaw, Mississippi, US
34076 34076 2021-10-23 US Mississippi Claiborne 28021 1327 37 0   31.97061673 -90.90702196 2021-10-24 04:21:22 Claiborne, Mississippi, US
34077 34077 2021-10-23 US Mississippi Clarke 28023 2924 94 0   32.04158545 -88.68896219999998 2021-10-24 04:21:22 Clarke, Mississippi, US
34078 34078 2021-10-23 US Mississippi Clay 28025 3080 76 0   33.65358105 -88.77784255 2021-10-24 04:21:22 Clay, Mississippi, US
34079 34079 2021-10-23 US Mississippi Coahoma 28027 4160 105 0   34.22772299 -90.60415045 2021-10-24 04:21:22 Coahoma, Mississippi, US
34080 34080 2021-10-23 US Mississippi Copiah 28029 4485 92 0   31.86977774 -90.44565118 2021-10-24 04:21:22 Copiah, Mississippi, US
34081 34081 2021-10-23 US Mississippi Covington 28031 4288 94 0   31.63225413 -89.55389939 2021-10-24 04:21:22 Covington, Mississippi, US
34082 34082 2021-10-23 US Mississippi DeSoto 28033 32117 403 0   34.87625235 -89.99091418 2021-10-24 04:21:22 DeSoto, Mississippi, US
34083 34083 2021-10-23 US Mississippi Forrest 28035 13453 251 0   31.18961454 -89.25832496 2021-10-24 04:21:22 Forrest, Mississippi, US
34084 34084 2021-10-23 US Mississippi Franklin 28037 1202 28 0   31.47786634 -90.89672989 2021-10-24 04:21:22 Franklin, Mississippi, US
34085 34085 2021-10-23 US Mississippi George 28039 4968 79 0   30.86259065 -88.64436789 2021-10-24 04:21:22 George, Mississippi, US
34086 34086 2021-10-23 US Mississippi Greene 28041 2193 48 0   31.21444233 -88.63922281 2021-10-24 04:21:22 Greene, Mississippi, US
34087 34087 2021-10-23 US Mississippi Grenada 28043 3707 108 0   33.77036166 -89.80245083 2021-10-24 04:21:22 Grenada, Mississippi, US
34088 34088 2021-10-23 US Mississippi Hancock 28045 7732 127 0   30.41830223 -89.48851033 2021-10-24 04:21:22 Hancock, Mississippi, US
34089 34089 2021-10-23 US Mississippi Harrison 28047 34338 538 0   30.51359752 -89.12467576 2021-10-24 04:21:22 Harrison, Mississippi, US
34090 34090 2021-10-23 US Mississippi Hinds 28049 31939 628 0   32.2656285 -90.44435448 2021-10-24 04:21:22 Hinds, Mississippi, US
34091 34091 2021-10-23 US Mississippi Holmes 28051 2679 87 0   33.12345854 -90.08923538 2021-10-24 04:21:22 Holmes, Mississippi, US
34092 34092 2021-10-23 US Mississippi Humphreys 28053 1295 38 0   33.12825718 -90.52252707 2021-10-24 04:21:22 Humphreys, Mississippi, US
34093 34093 2021-10-23 US Mississippi Issaquena 28055 193 7 0   32.72531359 -90.97392828 2021-10-24 04:21:22 Issaquena, Mississippi, US
34094 34094 2021-10-23 US Mississippi Itawamba 28057 4636 105 0   34.27993475 -88.3606733 2021-10-24 04:21:22 Itawamba, Mississippi, US
34095 34095 2021-10-23 US Mississippi Jackson 28059 24494 382 0   30.54020656 -88.64184064 2021-10-24 04:21:22 Jackson, Mississippi, US
34096 34096 2021-10-23 US Mississippi Jasper 28061 3299 65 0   32.01922104 -89.11786866 2021-10-24 04:21:22 Jasper, Mississippi, US
34097 34097 2021-10-23 US Mississippi Jefferson 28063 945 34 0   31.73397872 -91.03764977 2021-10-24 04:21:22 Jefferson, Mississippi, US
34098 34098 2021-10-23 US Mississippi Jefferson Davis 28065 1717 43 0   31.56884708 -89.82670990000004 2021-10-24 04:21:22 Jefferson Davis, Mississippi, US
34099 34099 2021-10-23 US Mississippi Jones 28067 13851 242 0   31.62257767 -89.16896899999998 2021-10-24 04:21:22 Jones, Mississippi, US
34100 34100 2021-10-23 US Mississippi Kemper 28069 1419 41 0   32.75462946 -88.64105766 2021-10-24 04:21:22 Kemper, Mississippi, US
34101 34101 2021-10-23 US Mississippi Lafayette 28071 8550 140 0   34.35687874 -89.48490961 2021-10-24 04:21:22 Lafayette, Mississippi, US
34102 34102 2021-10-23 US Mississippi Lamar 28073 10521 135 0   31.20572971 -89.5077704 2021-10-24 04:21:22 Lamar, Mississippi, US
34103 34103 2021-10-23 US Mississippi Lauderdale 28075 11991 317 0   32.40419769 -88.66229662 2021-10-24 04:21:22 Lauderdale, Mississippi, US
34104 34104 2021-10-23 US Mississippi Lawrence 28077 2129 40 0   31.55147224 -90.10841127 2021-10-24 04:21:22 Lawrence, Mississippi, US
34105 34105 2021-10-23 US Mississippi Leake 28079 4082 88 0   32.7536828 -89.52402044 2021-10-24 04:21:22 Leake, Mississippi, US
34106 34106 2021-10-23 US Mississippi Lee 28081 15543 235 0   34.291877500000005 -88.68149954 2021-10-24 04:21:22 Lee, Mississippi, US
34107 34107 2021-10-23 US Mississippi Leflore 28083 4658 144 0   33.55545125 -90.29900733 2021-10-24 04:21:22 Leflore, Mississippi, US
34108 34108 2021-10-23 US Mississippi Lincoln 28085 5436 135 0   31.53288662 -90.45391915 2021-10-24 04:21:22 Lincoln, Mississippi, US
34109 34109 2021-10-23 US Mississippi Lowndes 28087 11050 188 0   33.47386518 -88.44191529999998 2021-10-24 04:21:22 Lowndes, Mississippi, US
34110 34110 2021-10-23 US Mississippi Madison 28089 14581 280 0   32.63389156 -90.03513564 2021-10-24 04:21:22 Madison, Mississippi, US
34111 34111 2021-10-23 US Mississippi Marion 28091 4226 108 0   31.23132643 -89.8209217 2021-10-24 04:21:22 Marion, Mississippi, US
34112 34112 2021-10-23 US Mississippi Marshall 28093 6467 134 0   34.76216286 -89.50299462 2021-10-24 04:21:22 Marshall, Mississippi, US
34113 34113 2021-10-23 US Mississippi Monroe 28095 6777 177 0   33.89236763 -88.4808438 2021-10-24 04:21:22 Monroe, Mississippi, US
34114 34114 2021-10-23 US Mississippi Montgomery 28097 1796 56 0   33.49419589 -89.61729103 2021-10-24 04:21:22 Montgomery, Mississippi, US
34115 34115 2021-10-23 US Mississippi Neshoba 28099 6637 206 0   32.75339664 -89.11726492 2021-10-24 04:21:22 Neshoba, Mississippi, US
34116 34116 2021-10-23 US Mississippi Newton 28101 3817 79 0   32.40021118 -89.11843336 2021-10-24 04:21:22 Newton, Mississippi, US
34117 34117 2021-10-23 US Mississippi Noxubee 28103 1867 40 0   33.11009499 -88.56949061 2021-10-24 04:21:22 Noxubee, Mississippi, US
34118 34118 2021-10-23 US Mississippi Oktibbeha 28105 7146 131 0   33.42491685 -88.87905132 2021-10-24 04:21:22 Oktibbeha, Mississippi, US
34119 34119 2021-10-23 US Mississippi Panola 28107 6531 131 0   34.36398677 -89.95064249 2021-10-24 04:21:22 Panola, Mississippi, US
34120 34120 2021-10-23 US Mississippi Pearl River 28109 9533 237 0   30.77090935 -89.58677275 2021-10-24 04:21:22 Pearl River, Mississippi, US
34121 34121 2021-10-23 US Mississippi Perry 28111 2055 56 0   31.17161885 -88.99281835 2021-10-24 04:21:22 Perry, Mississippi, US
34122 34122 2021-10-23 US Mississippi Pike 28113 5820 152 0   31.17507789 -90.40392572 2021-10-24 04:21:22 Pike, Mississippi, US
34123 34123 2021-10-23 US Mississippi Pontotoc 28115 6664 102 0   34.226046000000004 -89.03636807 2021-10-24 04:21:22 Pontotoc, Mississippi, US
34124 34124 2021-10-23 US Mississippi Prentiss 28117 4672 81 0   34.61810501 -88.51986294 2021-10-24 04:21:22 Prentiss, Mississippi, US
34125 34125 2021-10-23 US Mississippi Quitman 28119 1064 28 0   34.25157572 -90.28908 2021-10-24 04:21:22 Quitman, Mississippi, US
34126 34126 2021-10-23 US Mississippi Rankin 28121 21995 390 0   32.26469147 -89.94537876 2021-10-24 04:21:22 Rankin, Mississippi, US
34127 34127 2021-10-23 US Mississippi Scott 28123 4728 98 0   32.406704100000006 -89.53789439 2021-10-24 04:21:22 Scott, Mississippi, US
34128 34128 2021-10-23 US Mississippi Sharkey 28125 641 20 0   32.88149103 -90.81595379999999 2021-10-24 04:21:22 Sharkey, Mississippi, US
34129 34129 2021-10-23 US Mississippi Simpson 28127 4446 116 0   31.91282117 -89.91716179 2021-10-24 04:21:22 Simpson, Mississippi, US
34130 34130 2021-10-23 US Mississippi Smith 28129 2640 50 0   32.01744532 -89.50644846 2021-10-24 04:21:22 Smith, Mississippi, US
34131 34131 2021-10-23 US Mississippi Stone 28131 3603 64 0   30.79187949 -89.11547539 2021-10-24 04:21:22 Stone, Mississippi, US
34132 34132 2021-10-23 US Mississippi Sunflower 28133 4239 105 0   33.60192578 -90.58882684 2021-10-24 04:21:22 Sunflower, Mississippi, US
34133 34133 2021-10-23 US Mississippi Tallahatchie 28135 2280 51 0   33.95339918 -90.1729398 2021-10-24 04:21:22 Tallahatchie, Mississippi, US
34134 34134 2021-10-23 US Mississippi Tate 28137 4588 111 0   34.65133709 -89.94485778 2021-10-24 04:21:22 Tate, Mississippi, US
34135 34135 2021-10-23 US Mississippi Tippah 28139 4692 81 0   34.76872156 -88.90988194 2021-10-24 04:21:22 Tippah, Mississippi, US
34136 34136 2021-10-23 US Mississippi Tishomingo 28141 3597 92 0   34.74023475 -88.23917219 2021-10-24 04:21:22 Tishomingo, Mississippi, US
34137 34137 2021-10-23 US Mississippi Tunica 28143 1598 39 0   34.64967704 -90.37481167 2021-10-24 04:21:22 Tunica, Mississippi, US
34138 34138 2021-10-23 US Mississippi Unassigned 90028 0 0 0   34.88084463 0.0 2021-10-24 04:21:22 Unassigned, Mississippi, US
34139 34139 2021-10-23 US Mississippi Union 28145 6028 94 0   34.49162015 -89.00776006 2021-10-24 04:21:22 Union, Mississippi, US
34140 34140 2021-10-23 US Mississippi Walthall 28147 2187 63 0   31.14971548 -90.10446654 2021-10-24 04:21:22 Walthall, Mississippi, US
34141 34141 2021-10-23 US Mississippi Warren 28149 6694 176 0   32.35810271 -90.83352619 2021-10-24 04:21:22 Warren, Mississippi, US
34142 34142 2021-10-23 US Mississippi Washington 28151 7438 158 0   33.28392041 -90.94196237 2021-10-24 04:21:22 Washington, Mississippi, US
34143 34143 2021-10-23 US Mississippi Wayne 28153 4397 72 0   31.64135687 -88.69573913 2021-10-24 04:21:22 Wayne, Mississippi, US
34144 34144 2021-10-23 US Mississippi Webster 28155 2029 46 0   33.61300486 -89.28392912 2021-10-24 04:21:22 Webster, Mississippi, US
34145 34145 2021-10-23 US Mississippi Wilkinson 28157 1051 39 0   31.16078225 -91.31018819 2021-10-24 04:21:22 Wilkinson, Mississippi, US
34146 34146 2021-10-23 US Mississippi Winston 28159 3142 91 0   33.08747908 -89.03391385 2021-10-24 04:21:22 Winston, Mississippi, US
34147 34147 2021-10-23 US Mississippi Yalobusha 28161 2340 47 0   34.02824175 -89.70762049999998 2021-10-24 04:21:22 Yalobusha, Mississippi, US
34148 34148 2021-10-23 US Mississippi Yazoo 28163 4441 87 0   32.77890365 -90.39656148 2021-10-24 04:21:22 Yazoo, Mississippi, US
314550 314550 2021-10-22 US Mississippi Adams 28001 4587 119 0   31.47669768 -91.35326037 2021-10-23 04:21:32 Adams, Mississippi, US
314551 314551 2021-10-22 US Mississippi Alcorn 28003 5669 101 0   34.88084463 -88.57996173 2021-10-23 04:21:32 Alcorn, Mississippi, US
314552 314552 2021-10-22 US Mississippi Amite 28005 2051 56 0   31.17467303 -90.80501621 2021-10-23 04:21:32 Amite, Mississippi, US
314553 314553 2021-10-22 US Mississippi Attala 28007 3315 89 0   33.08658803 -89.57838564 2021-10-23 04:21:32 Attala, Mississippi, US
314554 314554 2021-10-22 US Mississippi Benton 28009 1488 38 0   34.81681228 -89.18945516 2021-10-23 04:21:32 Benton, Mississippi, US
314555 314555 2021-10-22 US Mississippi Bolivar 28011 6317 148 0   33.79696941 -90.87372121 2021-10-23 04:21:32 Bolivar, Mississippi, US
314556 314556 2021-10-22 US Mississippi Calhoun 28013 2794 46 0   33.93683395 -89.33686647 2021-10-23 04:21:32 Calhoun, Mississippi, US
314557 314557 2021-10-22 US Mississippi Carroll 28015 1691 38 0   33.44834567 -89.91994479 2021-10-23 04:21:32 Carroll, Mississippi, US
314558 314558 2021-10-22 US Mississippi Chickasaw 28017 3003 67 0   33.91983202 -88.9481545 2021-10-23 04:21:32 Chickasaw, Mississippi, US
314559 314559 2021-10-22 US Mississippi Choctaw 28019 1334 26 0   33.34598242 -89.24809382 2021-10-23 04:21:32 Choctaw, Mississippi, US
314560 314560 2021-10-22 US Mississippi Claiborne 28021 1327 37 0   31.97061673 -90.90702196 2021-10-23 04:21:32 Claiborne, Mississippi, US
314561 314561 2021-10-22 US Mississippi Clarke 28023 2924 94 0   32.04158545 -88.68896219999998 2021-10-23 04:21:32 Clarke, Mississippi, US
314562 314562 2021-10-22 US Mississippi Clay 28025 3080 76 0   33.65358105 -88.77784255 2021-10-23 04:21:32 Clay, Mississippi, US
314563 314563 2021-10-22 US Mississippi Coahoma 28027 4160 105 0   34.22772299 -90.60415045 2021-10-23 04:21:32 Coahoma, Mississippi, US
314564 314564 2021-10-22 US Mississippi Copiah 28029 4485 92 0   31.86977774 -90.44565118 2021-10-23 04:21:32 Copiah, Mississippi, US
314565 314565 2021-10-22 US Mississippi Covington 28031 4288 94 0   31.63225413 -89.55389939 2021-10-23 04:21:32 Covington, Mississippi, US
314566 314566 2021-10-22 US Mississippi DeSoto 28033 32117 403 0   34.87625235 -89.99091418 2021-10-23 04:21:32 DeSoto, Mississippi, 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]);