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

83,968 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 1

  • Mississippi · 83,968 ✖

country_or_region 1

  • US 83,968
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2754692 2754692 2022-12-29 US Mississippi Adams 28001 8433 152 0   31.47669768 -91.35326037 2022-12-30 04:21:04 Adams, Mississippi, US
2754693 2754693 2022-12-29 US Mississippi Alcorn 28003 12419 166 0   34.88084463 -88.57996173 2022-12-30 04:21:04 Alcorn, Mississippi, US
2754694 2754694 2022-12-29 US Mississippi Amite 28005 3787 70 0   31.17467303 -90.80501621 2022-12-30 04:21:04 Amite, Mississippi, US
2754695 2754695 2022-12-29 US Mississippi Attala 28007 6557 123 0   33.08658803 -89.57838564 2022-12-30 04:21:04 Attala, Mississippi, US
2754696 2754696 2022-12-29 US Mississippi Benton 28009 2728 51 0   34.81681228 -89.18945516 2022-12-30 04:21:04 Benton, Mississippi, US
2754697 2754697 2022-12-29 US Mississippi Bolivar 28011 11061 189 0   33.79696941 -90.87372121 2022-12-30 04:21:04 Bolivar, Mississippi, US
2754698 2754698 2022-12-29 US Mississippi Calhoun 28013 5472 78 0   33.93683395 -89.33686647 2022-12-30 04:21:04 Calhoun, Mississippi, US
2754699 2754699 2022-12-29 US Mississippi Carroll 28015 2990 58 0   33.44834567 -89.91994479 2022-12-30 04:21:04 Carroll, Mississippi, US
2754700 2754700 2022-12-29 US Mississippi Chickasaw 28017 6755 101 0   33.91983202 -88.9481545 2022-12-30 04:21:04 Chickasaw, Mississippi, US
2754701 2754701 2022-12-29 US Mississippi Choctaw 28019 2774 36 0   33.34598242 -89.24809382 2022-12-30 04:21:04 Choctaw, Mississippi, US
2754702 2754702 2022-12-29 US Mississippi Claiborne 28021 2493 49 0   31.97061673 -90.90702196 2022-12-30 04:21:04 Claiborne, Mississippi, US
2754703 2754703 2022-12-29 US Mississippi Clarke 28023 4763 112 0   32.04158545 -88.6889622 2022-12-30 04:21:04 Clarke, Mississippi, US
2754704 2754704 2022-12-29 US Mississippi Clay 28025 5985 102 0   33.65358105 -88.77784255 2022-12-30 04:21:04 Clay, Mississippi, US
2754705 2754705 2022-12-29 US Mississippi Coahoma 28027 7905 135 0   34.22772299 -90.60415045 2022-12-30 04:21:04 Coahoma, Mississippi, US
2754706 2754706 2022-12-29 US Mississippi Copiah 28029 8864 125 0   31.86977774 -90.44565118 2022-12-30 04:21:04 Copiah, Mississippi, US
2754707 2754707 2022-12-29 US Mississippi Covington 28031 8312 118 0   31.63225413 -89.55389939 2022-12-30 04:21:04 Covington, Mississippi, US
2754708 2754708 2022-12-29 US Mississippi DeSoto 28033 59899 574 0   34.87625235 -89.99091418 2022-12-30 04:21:04 DeSoto, Mississippi, US
2754709 2754709 2022-12-29 US Mississippi Forrest 28035 26445 322 0   31.18961454 -89.25832496 2022-12-30 04:21:04 Forrest, Mississippi, US
2754710 2754710 2022-12-29 US Mississippi Franklin 28037 2274 39 0   31.47786634 -90.89672989 2022-12-30 04:21:04 Franklin, Mississippi, US
2754711 2754711 2022-12-29 US Mississippi George 28039 8462 90 0   30.86259065 -88.64436789 2022-12-30 04:21:04 George, Mississippi, US
2754712 2754712 2022-12-29 US Mississippi Greene 28041 3768 60 0   31.21444233 -88.63922281 2022-12-30 04:21:04 Greene, Mississippi, US
2754713 2754713 2022-12-29 US Mississippi Grenada 28043 6277 138 0   33.77036166 -89.80245083 2022-12-30 04:21:04 Grenada, Mississippi, US
2754714 2754714 2022-12-29 US Mississippi Hancock 28045 14613 161 0   30.41830223 -89.48851033 2022-12-30 04:21:04 Hancock, Mississippi, US
2754715 2754715 2022-12-29 US Mississippi Harrison 28047 63903 703 0   30.51359752 -89.12467576 2022-12-30 04:21:04 Harrison, Mississippi, US
2754716 2754716 2022-12-29 US Mississippi Hinds 28049 65439 838 0   32.2656285 -90.44435448 2022-12-30 04:21:04 Hinds, Mississippi, US
2754717 2754717 2022-12-29 US Mississippi Holmes 28051 5109 105 0   33.12345854 -90.08923538 2022-12-30 04:21:04 Holmes, Mississippi, US
2754718 2754718 2022-12-29 US Mississippi Humphreys 28053 2274 47 0   33.12825718 -90.52252707 2022-12-30 04:21:04 Humphreys, Mississippi, US
2754719 2754719 2022-12-29 US Mississippi Issaquena 28055 298 9 0   32.72531359 -90.97392828 2022-12-30 04:21:04 Issaquena, Mississippi, US
2754720 2754720 2022-12-29 US Mississippi Itawamba 28057 9067 147 0   34.27993475 -88.3606733 2022-12-30 04:21:04 Itawamba, Mississippi, US
2754721 2754721 2022-12-29 US Mississippi Jackson 28059 44433 493 0   30.54020656 -88.64184064 2022-12-30 04:21:04 Jackson, Mississippi, US
2754722 2754722 2022-12-29 US Mississippi Jasper 28061 5908 79 0   32.01922104 -89.11786866 2022-12-30 04:21:04 Jasper, Mississippi, US
2754723 2754723 2022-12-29 US Mississippi Jefferson 28063 1763 39 0   31.73397872 -91.03764977 2022-12-30 04:21:04 Jefferson, Mississippi, US
2754724 2754724 2022-12-29 US Mississippi Jefferson Davis 28065 3500 56 0   31.56884708 -89.8267099 2022-12-30 04:21:04 Jefferson Davis, Mississippi, US
2754725 2754725 2022-12-29 US Mississippi Jones 28067 25403 310 0   31.62257767 -89.168969 2022-12-30 04:21:04 Jones, Mississippi, US
2754726 2754726 2022-12-29 US Mississippi Kemper 28069 2529 51 0   32.75462946 -88.64105766 2022-12-30 04:21:04 Kemper, Mississippi, US
2754727 2754727 2022-12-29 US Mississippi Lafayette 28071 18275 187 0   34.35687874 -89.48490961 2022-12-30 04:21:04 Lafayette, Mississippi, US
2754728 2754728 2022-12-29 US Mississippi Lamar 28073 21124 168 0   31.20572971 -89.5077704 2022-12-30 04:21:04 Lamar, Mississippi, US
2754729 2754729 2022-12-29 US Mississippi Lauderdale 28075 21402 382 0   32.40419769 -88.66229662 2022-12-30 04:21:04 Lauderdale, Mississippi, US
2754730 2754730 2022-12-29 US Mississippi Lawrence 28077 4327 57 0   31.55147224 -90.10841127 2022-12-30 04:21:04 Lawrence, Mississippi, US
2754731 2754731 2022-12-29 US Mississippi Leake 28079 7419 125 0   32.7536828 -89.52402044 2022-12-30 04:21:04 Leake, Mississippi, US
2754732 2754732 2022-12-29 US Mississippi Lee 28081 32819 320 0   34.2918775 -88.68149954 2022-12-30 04:21:04 Lee, Mississippi, US
2754733 2754733 2022-12-29 US Mississippi Leflore 28083 8467 181 0   33.55545125 -90.29900733 2022-12-30 04:21:04 Leflore, Mississippi, US
2754734 2754734 2022-12-29 US Mississippi Lincoln 28085 10134 164 0   31.53288662 -90.45391915 2022-12-30 04:21:04 Lincoln, Mississippi, US
2754735 2754735 2022-12-29 US Mississippi Lowndes 28087 20628 250 0   33.47386518 -88.4419153 2022-12-30 04:21:04 Lowndes, Mississippi, US
2754736 2754736 2022-12-29 US Mississippi Madison 28089 30406 348 0   32.63389156 -90.03513564 2022-12-30 04:21:04 Madison, Mississippi, US
2754737 2754737 2022-12-29 US Mississippi Marion 28091 8395 143 0   31.23132643 -89.8209217 2022-12-30 04:21:04 Marion, Mississippi, US
2754738 2754738 2022-12-29 US Mississippi Marshall 28093 11666 185 0   34.76216286 -89.50299462 2022-12-30 04:21:04 Marshall, Mississippi, US
2754739 2754739 2022-12-29 US Mississippi Monroe 28095 13284 229 0   33.89236763 -88.4808438 2022-12-30 04:21:04 Monroe, Mississippi, US
2754740 2754740 2022-12-29 US Mississippi Montgomery 28097 3535 83 0   33.49419589 -89.61729103 2022-12-30 04:21:04 Montgomery, Mississippi, US
2754741 2754741 2022-12-29 US Mississippi Neshoba 28099 12336 247 0   32.75339664 -89.11726492 2022-12-30 04:21:04 Neshoba, Mississippi, US
2754742 2754742 2022-12-29 US Mississippi Newton 28101 6920 102 0   32.40021118 -89.11843336 2022-12-30 04:21:04 Newton, Mississippi, US
2754743 2754743 2022-12-29 US Mississippi Noxubee 28103 3469 51 0   33.11009499 -88.56949061 2022-12-30 04:21:04 Noxubee, Mississippi, US
2754744 2754744 2022-12-29 US Mississippi Oktibbeha 28105 13234 173 0   33.42491685 -88.87905132 2022-12-30 04:21:04 Oktibbeha, Mississippi, US
2754745 2754745 2022-12-29 US Mississippi Panola 28107 12184 179 0   34.36398677 -89.95064249 2022-12-30 04:21:04 Panola, Mississippi, US
2754746 2754746 2022-12-29 US Mississippi Pearl River 28109 17411 286 0   30.77090935 -89.58677275 2022-12-30 04:21:04 Pearl River, Mississippi, US
2754747 2754747 2022-12-29 US Mississippi Perry 28111 3622 65 0   31.17161885 -88.99281835 2022-12-30 04:21:04 Perry, Mississippi, US
2754748 2754748 2022-12-29 US Mississippi Pike 28113 12212 192 0   31.17507789 -90.40392572 2022-12-30 04:21:04 Pike, Mississippi, US
2754749 2754749 2022-12-29 US Mississippi Pontotoc 28115 12330 156 0   34.226046 -89.03636807 2022-12-30 04:21:04 Pontotoc, Mississippi, US
2754750 2754750 2022-12-29 US Mississippi Prentiss 28117 9928 112 0   34.61810501 -88.51986294 2022-12-30 04:21:04 Prentiss, Mississippi, US
2754751 2754751 2022-12-29 US Mississippi Quitman 28119 1796 33 0   34.25157572 -90.28908 2022-12-30 04:21:04 Quitman, Mississippi, US
2754752 2754752 2022-12-29 US Mississippi Rankin 28121 45167 524 0   32.26469147 -89.94537876 2022-12-30 04:21:04 Rankin, Mississippi, US
2754753 2754753 2022-12-29 US Mississippi Scott 28123 7639 122 0   32.4067041 -89.53789439 2022-12-30 04:21:04 Scott, Mississippi, US
2754754 2754754 2022-12-29 US Mississippi Sharkey 28125 1126 28 0   32.88149103 -90.8159538 2022-12-30 04:21:04 Sharkey, Mississippi, US
2754755 2754755 2022-12-29 US Mississippi Simpson 28127 8308 159 0   31.91282117 -89.91716179 2022-12-30 04:21:04 Simpson, Mississippi, US
2754756 2754756 2022-12-29 US Mississippi Smith 28129 4863 72 0   32.01744532 -89.50644846 2022-12-30 04:21:04 Smith, Mississippi, US
2754757 2754757 2022-12-29 US Mississippi Stone 28131 6514 80 0   30.79187949 -89.11547539 2022-12-30 04:21:04 Stone, Mississippi, US
2754758 2754758 2022-12-29 US Mississippi Sunflower 28133 6689 132 0   33.60192578 -90.58882684 2022-12-30 04:21:04 Sunflower, Mississippi, US
2754759 2754759 2022-12-29 US Mississippi Tallahatchie 28135 3747 64 0   33.95339918 -90.1729398 2022-12-30 04:21:04 Tallahatchie, Mississippi, US
2754760 2754760 2022-12-29 US Mississippi Tate 28137 8554 155 0   34.65133709 -89.94485778 2022-12-30 04:21:04 Tate, Mississippi, US
2754761 2754761 2022-12-29 US Mississippi Tippah 28139 8743 115 0   34.76872156 -88.90988194 2022-12-30 04:21:04 Tippah, Mississippi, US
2754762 2754762 2022-12-29 US Mississippi Tishomingo 28141 7465 123 0   34.74023475 -88.23917219 2022-12-30 04:21:04 Tishomingo, Mississippi, US
2754763 2754763 2022-12-29 US Mississippi Tunica 28143 2984 50 0   34.64967704 -90.37481167 2022-12-30 04:21:04 Tunica, Mississippi, US
2754764 2754764 2022-12-29 US Mississippi Unassigned 90028 0 0 0   34.88084463 0.0 2022-12-30 04:21:04 Unassigned, Mississippi, US
2754765 2754765 2022-12-29 US Mississippi Union 28145 11227 131 0   34.49162015 -89.00776006 2022-12-30 04:21:04 Union, Mississippi, US
2754766 2754766 2022-12-29 US Mississippi Walthall 28147 4447 83 0   31.14971548 -90.10446654 2022-12-30 04:21:04 Walthall, Mississippi, US
2754767 2754767 2022-12-29 US Mississippi Warren 28149 12272 218 0   32.35810271 -90.83352619 2022-12-30 04:21:04 Warren, Mississippi, US
2754768 2754768 2022-12-29 US Mississippi Washington 28151 12113 209 0   33.28392041 -90.94196237 2022-12-30 04:21:04 Washington, Mississippi, US
2754769 2754769 2022-12-29 US Mississippi Wayne 28153 6734 89 0   31.64135687 -88.69573913 2022-12-30 04:21:04 Wayne, Mississippi, US
2754770 2754770 2022-12-29 US Mississippi Webster 28155 3887 73 0   33.61300486 -89.28392912 2022-12-30 04:21:04 Webster, Mississippi, US
2754771 2754771 2022-12-29 US Mississippi Wilkinson 28157 1924 46 0   31.16078225 -91.31018819 2022-12-30 04:21:04 Wilkinson, Mississippi, US
2754772 2754772 2022-12-29 US Mississippi Winston 28159 6354 104 0   33.08747908 -89.03391385 2022-12-30 04:21:04 Winston, Mississippi, US
2754773 2754773 2022-12-29 US Mississippi Yalobusha 28161 4748 62 0   34.02824175 -89.7076205 2022-12-30 04:21:04 Yalobusha, Mississippi, US
2754774 2754774 2022-12-29 US Mississippi Yazoo 28163 9655 114 0   32.77890365 -90.39656148 2022-12-30 04:21:04 Yazoo, Mississippi, US
1075698 1075698 2022-12-28 US Mississippi Adams 28001 8433 152 0   31.47669768 -91.35326037 2022-12-29 04:21:01 Adams, Mississippi, US
1075699 1075699 2022-12-28 US Mississippi Alcorn 28003 12419 166 0   34.88084463 -88.57996173 2022-12-29 04:21:01 Alcorn, Mississippi, US
1075700 1075700 2022-12-28 US Mississippi Amite 28005 3787 70 0   31.17467303 -90.80501621 2022-12-29 04:21:01 Amite, Mississippi, US
1075701 1075701 2022-12-28 US Mississippi Attala 28007 6557 123 0   33.08658803 -89.57838564 2022-12-29 04:21:01 Attala, Mississippi, US
1075702 1075702 2022-12-28 US Mississippi Benton 28009 2728 51 0   34.81681228 -89.18945516 2022-12-29 04:21:01 Benton, Mississippi, US
1075703 1075703 2022-12-28 US Mississippi Bolivar 28011 11061 189 0   33.79696941 -90.87372121 2022-12-29 04:21:01 Bolivar, Mississippi, US
1075704 1075704 2022-12-28 US Mississippi Calhoun 28013 5472 78 0   33.93683395 -89.33686647 2022-12-29 04:21:01 Calhoun, Mississippi, US
1075705 1075705 2022-12-28 US Mississippi Carroll 28015 2990 58 0   33.44834567 -89.91994479 2022-12-29 04:21:01 Carroll, Mississippi, US
1075706 1075706 2022-12-28 US Mississippi Chickasaw 28017 6755 101 0   33.91983202 -88.9481545 2022-12-29 04:21:01 Chickasaw, Mississippi, US
1075707 1075707 2022-12-28 US Mississippi Choctaw 28019 2774 36 0   33.34598242 -89.24809382 2022-12-29 04:21:01 Choctaw, Mississippi, US
1075708 1075708 2022-12-28 US Mississippi Claiborne 28021 2493 49 0   31.97061673 -90.90702196 2022-12-29 04:21:01 Claiborne, Mississippi, US
1075709 1075709 2022-12-28 US Mississippi Clarke 28023 4763 112 0   32.04158545 -88.6889622 2022-12-29 04:21:01 Clarke, Mississippi, US
1075710 1075710 2022-12-28 US Mississippi Clay 28025 5985 102 0   33.65358105 -88.77784255 2022-12-29 04:21:01 Clay, Mississippi, US
1075711 1075711 2022-12-28 US Mississippi Coahoma 28027 7905 135 0   34.22772299 -90.60415045 2022-12-29 04:21:01 Coahoma, Mississippi, US
1075712 1075712 2022-12-28 US Mississippi Copiah 28029 8864 125 0   31.86977774 -90.44565118 2022-12-29 04:21:01 Copiah, Mississippi, US
1075713 1075713 2022-12-28 US Mississippi Covington 28031 8312 118 0   31.63225413 -89.55389939 2022-12-29 04:21:01 Covington, Mississippi, US
1075714 1075714 2022-12-28 US Mississippi DeSoto 28033 59899 574 0   34.87625235 -89.99091418 2022-12-29 04:21:01 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] 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]);