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

28,773 rows where province_or_state = "Mississippi" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state

  • Mississippi · 28,773 ✖

country_or_region

  • US 28,773
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
902457 902457 2021-03-04 US Mississippi Adams 28001 2350 78 0 2272 31.47669768 -91.35326037 2021-03-05 05:26:29 Adams, Mississippi, US
902458 902458 2021-03-04 US Mississippi Alcorn 28003 2924 63 0 2861 34.88084463 -88.57996173 2021-03-05 05:26:29 Alcorn, Mississippi, US
902459 902459 2021-03-04 US Mississippi Amite 28005 1122 35 0 1087 31.17467303 -90.80501621 2021-03-05 05:26:29 Amite, Mississippi, US
902460 902460 2021-03-04 US Mississippi Attala 28007 2068 70 0 1998 33.08658803 -89.57838564 2021-03-05 05:26:29 Attala, Mississippi, US
902461 902461 2021-03-04 US Mississippi Benton 28009 939 24 0 915 34.81681228 -89.18945516 2021-03-05 05:26:29 Benton, Mississippi, US
902462 902462 2021-03-04 US Mississippi Bolivar 28011 4620 124 0 4496 33.79696941 -90.87372121 2021-03-05 05:26:29 Bolivar, Mississippi, US
902463 902463 2021-03-04 US Mississippi Calhoun 28013 1585 28 0 1557 33.93683395 -89.33686647 2021-03-05 05:26:29 Calhoun, Mississippi, US
902464 902464 2021-03-04 US Mississippi Carroll 28015 1190 25 0 1165 33.44834567 -89.91994479 2021-03-05 05:26:29 Carroll, Mississippi, US
902465 902465 2021-03-04 US Mississippi Chickasaw 28017 2014 53 0 1961 33.91983202 -88.9481545 2021-03-05 05:26:29 Chickasaw, Mississippi, US
902466 902466 2021-03-04 US Mississippi Choctaw 28019 698 17 0 681 33.34598242 -89.24809382 2021-03-05 05:26:29 Choctaw, Mississippi, US
902467 902467 2021-03-04 US Mississippi Claiborne 28021 991 29 0 962 31.97061673 -90.90702196 2021-03-05 05:26:29 Claiborne, Mississippi, US
902468 902468 2021-03-04 US Mississippi Clarke 28023 1696 72 0 1624 32.04158545 -88.68896219999998 2021-03-05 05:26:29 Clarke, Mississippi, US
902469 902469 2021-03-04 US Mississippi Clay 28025 1792 51 0 1741 33.65358105 -88.77784255 2021-03-05 05:26:29 Clay, Mississippi, US
902470 902470 2021-03-04 US Mississippi Coahoma 28027 2820 69 0 2751 34.22772299 -90.60415045 2021-03-05 05:26:29 Coahoma, Mississippi, US
902471 902471 2021-03-04 US Mississippi Copiah 28029 2792 59 0 2733 31.86977774 -90.44565118 2021-03-05 05:26:29 Copiah, Mississippi, US
902472 902472 2021-03-04 US Mississippi Covington 28031 2497 80 0 2417 31.63225413 -89.55389939 2021-03-05 05:26:29 Covington, Mississippi, US
902473 902473 2021-03-04 US Mississippi DeSoto 28033 19731 230 0 19501 34.87625235 -89.99091418 2021-03-05 05:26:29 DeSoto, Mississippi, US
902474 902474 2021-03-04 US Mississippi Forrest 28035 7250 138 0 7112 31.18961454 -89.25832496 2021-03-05 05:26:29 Forrest, Mississippi, US
902475 902475 2021-03-04 US Mississippi Franklin 28037 762 19 0 743 31.47786634 -90.89672989 2021-03-05 05:26:29 Franklin, Mississippi, US
902476 902476 2021-03-04 US Mississippi George 28039 2324 45 0 2279 30.86259065 -88.64436789 2021-03-05 05:26:29 George, Mississippi, US
902477 902477 2021-03-04 US Mississippi Greene 28041 1279 33 0 1246 31.21444233 -88.63922281 2021-03-05 05:26:29 Greene, Mississippi, US
902478 902478 2021-03-04 US Mississippi Grenada 28043 2485 78 0 2407 33.77036166 -89.80245083 2021-03-05 05:26:29 Grenada, Mississippi, US
902479 902479 2021-03-04 US Mississippi Hancock 28045 3502 77 0 3425 30.41830223 -89.48851033 2021-03-05 05:26:29 Hancock, Mississippi, US
902480 902480 2021-03-04 US Mississippi Harrison 28047 16780 282 0 16498 30.51359752 -89.12467576 2021-03-05 05:26:29 Harrison, Mississippi, US
902481 902481 2021-03-04 US Mississippi Hinds 28049 18881 393 0 18488 32.2656285 -90.44435448 2021-03-05 05:26:29 Hinds, Mississippi, US
902482 902482 2021-03-04 US Mississippi Holmes 28051 1827 70 0 1757 33.12345854 -90.08923538 2021-03-05 05:26:29 Holmes, Mississippi, US
902483 902483 2021-03-04 US Mississippi Humphreys 28053 930 27 0 903 33.12825718 -90.52252707 2021-03-05 05:26:29 Humphreys, Mississippi, US
902484 902484 2021-03-04 US Mississippi Issaquena 28055 167 6 0 161 32.72531359 -90.97392828 2021-03-05 05:26:29 Issaquena, Mississippi, US
902485 902485 2021-03-04 US Mississippi Itawamba 28057 2902 75 0 2827 34.27993475 -88.3606733 2021-03-05 05:26:29 Itawamba, Mississippi, US
902486 902486 2021-03-04 US Mississippi Jackson 28059 12643 229 0 12414 30.54020656 -88.64184064 2021-03-05 05:26:29 Jackson, Mississippi, US
902487 902487 2021-03-04 US Mississippi Jasper 28061 2138 45 0 2093 32.01922104 -89.11786866 2021-03-05 05:26:29 Jasper, Mississippi, US
902488 902488 2021-03-04 US Mississippi Jefferson 28063 628 27 0 601 31.73397872 -91.03764977 2021-03-05 05:26:29 Jefferson, Mississippi, US
902489 902489 2021-03-04 US Mississippi Jefferson Davis 28065 1027 31 0 996 31.56884708 -89.82670990000003 2021-03-05 05:26:29 Jefferson Davis, Mississippi, US
902490 902490 2021-03-04 US Mississippi Jones 28067 8005 147 0 7858 31.62257767 -89.16896899999998 2021-03-05 05:26:29 Jones, Mississippi, US
902491 902491 2021-03-04 US Mississippi Kemper 28069 904 23 0 881 32.75462946 -88.64105766 2021-03-05 05:26:29 Kemper, Mississippi, US
902492 902492 2021-03-04 US Mississippi Lafayette 28071 5747 113 0 5634 34.35687874 -89.48490961 2021-03-05 05:26:29 Lafayette, Mississippi, US
902493 902493 2021-03-04 US Mississippi Lamar 28073 5909 80 0 5829 31.20572971 -89.5077704 2021-03-05 05:26:29 Lamar, Mississippi, US
902494 902494 2021-03-04 US Mississippi Lauderdale 28075 6847 227 0 6620 32.40419769 -88.66229662 2021-03-05 05:26:29 Lauderdale, Mississippi, US
902495 902495 2021-03-04 US Mississippi Lawrence 28077 1206 21 0 1185 31.55147224 -90.10841127 2021-03-05 05:26:29 Lawrence, Mississippi, US
902496 902496 2021-03-04 US Mississippi Leake 28079 2531 72 0 2459 32.7536828 -89.52402044 2021-03-05 05:26:29 Leake, Mississippi, US
902497 902497 2021-03-04 US Mississippi Lee 28081 9703 161 0 9542 34.291877500000005 -88.68149954 2021-03-05 05:26:29 Lee, Mississippi, US
902498 902498 2021-03-04 US Mississippi Leflore 28083 3389 119 0 3270 33.55545125 -90.29900733 2021-03-05 05:26:29 Leflore, Mississippi, US
902499 902499 2021-03-04 US Mississippi Lincoln 28085 3564 104 0 3460 31.53288662 -90.45391915 2021-03-05 05:26:29 Lincoln, Mississippi, US
902500 902500 2021-03-04 US Mississippi Lowndes 28087 6033 140 0 5893 33.47386518 -88.44191529999998 2021-03-05 05:26:29 Lowndes, Mississippi, US
902501 902501 2021-03-04 US Mississippi Madison 28089 9484 203 0 9281 32.63389156 -90.03513564 2021-03-05 05:26:29 Madison, Mississippi, US
902502 902502 2021-03-04 US Mississippi Marion 28091 2527 78 0 2449 31.23132643 -89.8209217 2021-03-05 05:26:29 Marion, Mississippi, US
902503 902503 2021-03-04 US Mississippi Marshall 28093 4044 92 0 3952 34.76216286 -89.50299462 2021-03-05 05:26:29 Marshall, Mississippi, US
902504 902504 2021-03-04 US Mississippi Monroe 28095 3993 128 0 3865 33.89236763 -88.4808438 2021-03-05 05:26:29 Monroe, Mississippi, US
902505 902505 2021-03-04 US Mississippi Montgomery 28097 1229 39 0 1190 33.49419589 -89.61729103 2021-03-05 05:26:29 Montgomery, Mississippi, US
902506 902506 2021-03-04 US Mississippi Neshoba 28099 3822 170 0 3652 32.75339664 -89.11726492 2021-03-05 05:26:29 Neshoba, Mississippi, US
902507 902507 2021-03-04 US Mississippi Newton 28101 2312 52 0 2260 32.40021118 -89.11843336 2021-03-05 05:26:29 Newton, Mississippi, US
902508 902508 2021-03-04 US Mississippi Noxubee 28103 1231 31 0 1200 33.11009499 -88.56949061 2021-03-05 05:26:29 Noxubee, Mississippi, US
902509 902509 2021-03-04 US Mississippi Oktibbeha 28105 4421 94 0 4327 33.42491685 -88.87905132 2021-03-05 05:26:29 Oktibbeha, Mississippi, US
902510 902510 2021-03-04 US Mississippi Panola 28107 4323 96 0 4227 34.36398677 -89.95064249 2021-03-05 05:26:29 Panola, Mississippi, US
902511 902511 2021-03-04 US Mississippi Pearl River 28109 4193 132 0 4061 30.77090935 -89.58677275 2021-03-05 05:26:29 Pearl River, Mississippi, US
902512 902512 2021-03-04 US Mississippi Perry 28111 1222 35 0 1187 31.17161885 -88.99281835 2021-03-05 05:26:29 Perry, Mississippi, US
902513 902513 2021-03-04 US Mississippi Pike 28113 3017 96 0 2921 31.17507789 -90.40392572 2021-03-05 05:26:29 Pike, Mississippi, US
902514 902514 2021-03-04 US Mississippi Pontotoc 28115 4107 71 0 4036 34.226046000000004 -89.03636807 2021-03-05 05:26:29 Pontotoc, Mississippi, US
902515 902515 2021-03-04 US Mississippi Prentiss 28117 2711 58 0 2653 34.61810501 -88.51986294 2021-03-05 05:26:29 Prentiss, Mississippi, US
902516 902516 2021-03-04 US Mississippi Quitman 28119 774 14 0 760 34.25157572 -90.28908 2021-03-05 05:26:29 Quitman, Mississippi, US
902517 902517 2021-03-04 US Mississippi Rankin 28121 12787 265 0 12522 32.26469147 -89.94537876 2021-03-05 05:26:29 Rankin, Mississippi, US
902518 902518 2021-03-04 US Mississippi Scott 28123 2952 71 0 2881 32.406704100000006 -89.53789439 2021-03-05 05:26:29 Scott, Mississippi, US
902519 902519 2021-03-04 US Mississippi Sharkey 28125 491 17 0 474 32.88149103 -90.8159538 2021-03-05 05:26:29 Sharkey, Mississippi, US
902520 902520 2021-03-04 US Mississippi Simpson 28127 2766 80 0 2686 31.91282117 -89.91716179 2021-03-05 05:26:29 Simpson, Mississippi, US
902521 902521 2021-03-04 US Mississippi Smith 28129 1530 33 0 1497 32.01744532 -89.50644846 2021-03-05 05:26:29 Smith, Mississippi, US
902522 902522 2021-03-04 US Mississippi Stone 28131 1730 29 0 1701 30.79187949 -89.11547539 2021-03-05 05:26:29 Stone, Mississippi, US
902523 902523 2021-03-04 US Mississippi Sunflower 28133 3192 86 0 3106 33.60192578 -90.58882684 2021-03-05 05:26:29 Sunflower, Mississippi, US
902524 902524 2021-03-04 US Mississippi Tallahatchie 28135 1714 39 0 1675 33.95339918 -90.1729398 2021-03-05 05:26:29 Tallahatchie, Mississippi, US
902525 902525 2021-03-04 US Mississippi Tate 28137 3033 74 0 2959 34.65133709 -89.94485778 2021-03-05 05:26:29 Tate, Mississippi, US
902526 902526 2021-03-04 US Mississippi Tippah 28139 2795 65 0 2730 34.76872156 -88.90988194 2021-03-05 05:26:29 Tippah, Mississippi, US
902527 902527 2021-03-04 US Mississippi Tishomingo 28141 2129 65 0 2064 34.74023475 -88.23917219 2021-03-05 05:26:29 Tishomingo, Mississippi, US
902528 902528 2021-03-04 US Mississippi Tunica 28143 995 23 0 972 34.64967704 -90.37481167 2021-03-05 05:26:29 Tunica, Mississippi, US
902529 902529 2021-03-04 US Mississippi Unassigned 90028 0 0 0 0 34.88084463 0.0 2021-03-05 05:26:29 Unassigned, Mississippi, US
902530 902530 2021-03-04 US Mississippi Union 28145 3964 74 0 3890 34.49162015 -89.00776006 2021-03-05 05:26:29 Union, Mississippi, US
902531 902531 2021-03-04 US Mississippi Walthall 28147 1245 40 0 1205 31.14971548 -90.10446654 2021-03-05 05:26:29 Walthall, Mississippi, US
902532 902532 2021-03-04 US Mississippi Warren 28149 4138 115 0 4023 32.35810271 -90.83352619 2021-03-05 05:26:29 Warren, Mississippi, US
902533 902533 2021-03-04 US Mississippi Washington 28151 5229 130 0 5099 33.28392041 -90.94196237 2021-03-05 05:26:29 Washington, Mississippi, US
902534 902534 2021-03-04 US Mississippi Wayne 28153 2545 41 0 2504 31.64135687 -88.69573913 2021-03-05 05:26:29 Wayne, Mississippi, US
902535 902535 2021-03-04 US Mississippi Webster 28155 1111 32 0 1079 33.61300486 -89.28392912 2021-03-05 05:26:29 Webster, Mississippi, US
902536 902536 2021-03-04 US Mississippi Wilkinson 28157 624 27 0 597 31.16078225 -91.31018819 2021-03-05 05:26:29 Wilkinson, Mississippi, US
902537 902537 2021-03-04 US Mississippi Winston 28159 2219 79 0 2140 33.08747908 -89.03391385 2021-03-05 05:26:29 Winston, Mississippi, US
902538 902538 2021-03-04 US Mississippi Yalobusha 28161 1455 36 0 1419 34.02824175 -89.70762049999998 2021-03-05 05:26:29 Yalobusha, Mississippi, US
902539 902539 2021-03-04 US Mississippi Yazoo 28163 2908 65 0 2843 32.77890365 -90.39656148 2021-03-05 05:26:29 Yazoo, Mississippi, US
910182 910182 2021-03-03 US Mississippi Adams 28001 2346 78 0 2268 31.47669768 -91.35326037 2021-03-04 05:24:24 Adams, Mississippi, US
910183 910183 2021-03-03 US Mississippi Alcorn 28003 2922 63 0 2859 34.88084463 -88.57996173 2021-03-04 05:24:24 Alcorn, Mississippi, US
910184 910184 2021-03-03 US Mississippi Amite 28005 1117 34 0 1083 31.17467303 -90.80501621 2021-03-04 05:24:24 Amite, Mississippi, US
910185 910185 2021-03-03 US Mississippi Attala 28007 2066 69 0 1997 33.08658803 -89.57838564 2021-03-04 05:24:24 Attala, Mississippi, US
910186 910186 2021-03-03 US Mississippi Benton 28009 938 24 0 914 34.81681228 -89.18945516 2021-03-04 05:24:24 Benton, Mississippi, US
910187 910187 2021-03-03 US Mississippi Bolivar 28011 4616 124 0 4492 33.79696941 -90.87372121 2021-03-04 05:24:24 Bolivar, Mississippi, US
910188 910188 2021-03-03 US Mississippi Calhoun 28013 1580 28 0 1552 33.93683395 -89.33686647 2021-03-04 05:24:24 Calhoun, Mississippi, US
910189 910189 2021-03-03 US Mississippi Carroll 28015 1186 25 0 1161 33.44834567 -89.91994479 2021-03-04 05:24:24 Carroll, Mississippi, US
910190 910190 2021-03-03 US Mississippi Chickasaw 28017 2014 53 0 1961 33.91983202 -88.9481545 2021-03-04 05:24:24 Chickasaw, Mississippi, US
910191 910191 2021-03-03 US Mississippi Choctaw 28019 698 17 0 681 33.34598242 -89.24809382 2021-03-04 05:24:24 Choctaw, Mississippi, US
910192 910192 2021-03-03 US Mississippi Claiborne 28021 988 29 0 959 31.97061673 -90.90702196 2021-03-04 05:24:24 Claiborne, Mississippi, US
910193 910193 2021-03-03 US Mississippi Clarke 28023 1693 71 0 1622 32.04158545 -88.68896219999998 2021-03-04 05:24:24 Clarke, Mississippi, US
910194 910194 2021-03-03 US Mississippi Clay 28025 1792 51 0 1741 33.65358105 -88.77784255 2021-03-04 05:24:24 Clay, Mississippi, US
910195 910195 2021-03-03 US Mississippi Coahoma 28027 2811 69 0 2742 34.22772299 -90.60415045 2021-03-04 05:24:24 Coahoma, Mississippi, US
910196 910196 2021-03-03 US Mississippi Copiah 28029 2787 58 0 2729 31.86977774 -90.44565118 2021-03-04 05:24:24 Copiah, Mississippi, US
910197 910197 2021-03-03 US Mississippi Covington 28031 2495 80 0 2415 31.63225413 -89.55389939 2021-03-04 05:24:24 Covington, Mississippi, US
910198 910198 2021-03-03 US Mississippi DeSoto 28033 19700 230 0 19470 34.87625235 -89.99091418 2021-03-04 05:24:24 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]);