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

11,841 rows where province_or_state = "Mississippi" sorted by day descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

province_or_state

  • Mississippi · 11,841 ✖

country_or_region

  • US 11,841
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
135819 135819 2020-08-12 US Mississippi Adams 28001 642 26 0 616 31.47669768 -91.35326037 2020-08-13 04:29:15 Adams, Mississippi, US
135820 135820 2020-08-12 US Mississippi Alcorn 28003 439 5 0 434 34.88084463 -88.57996173 2020-08-13 04:29:15 Alcorn, Mississippi, US
135821 135821 2020-08-12 US Mississippi Amite 28005 240 6 0 234 31.17467303 -90.80501621 2020-08-13 04:29:15 Amite, Mississippi, US
135822 135822 2020-08-12 US Mississippi Attala 28007 533 25 0 508 33.08658803 -89.57838564 2020-08-13 04:29:15 Attala, Mississippi, US
135823 135823 2020-08-12 US Mississippi Benton 28009 154 1 0 153 34.81681228 -89.18945516 2020-08-13 04:29:15 Benton, Mississippi, US
135824 135824 2020-08-12 US Mississippi Bolivar 28011 1156 36 0 1120 33.79696941 -90.87372121 2020-08-13 04:29:15 Bolivar, Mississippi, US
135825 135825 2020-08-12 US Mississippi Calhoun 28013 426 9 0 417 33.93683395 -89.33686647 2020-08-13 04:29:15 Calhoun, Mississippi, US
135826 135826 2020-08-12 US Mississippi Carroll 28015 262 11 0 251 33.44834567 -89.91994479 2020-08-13 04:29:15 Carroll, Mississippi, US
135827 135827 2020-08-12 US Mississippi Chickasaw 28017 488 19 0 469 33.91983202 -88.9481545 2020-08-13 04:29:15 Chickasaw, Mississippi, US
135828 135828 2020-08-12 US Mississippi Choctaw 28019 138 4 0 134 33.34598242 -89.24809382 2020-08-13 04:29:15 Choctaw, Mississippi, US
135829 135829 2020-08-12 US Mississippi Claiborne 28021 409 14 0 395 31.97061673 -90.90702196 2020-08-13 04:29:15 Claiborne, Mississippi, US
135830 135830 2020-08-12 US Mississippi Clarke 28023 343 28 0 315 32.04158545 -88.68896219999998 2020-08-13 04:29:15 Clarke, Mississippi, US
135831 135831 2020-08-12 US Mississippi Clay 28025 404 14 0 390 33.65358105 -88.77784255 2020-08-13 04:29:15 Clay, Mississippi, US
135832 135832 2020-08-12 US Mississippi Coahoma 28027 789 13 0 776 34.22772299 -90.60415045 2020-08-13 04:29:15 Coahoma, Mississippi, US
135833 135833 2020-08-12 US Mississippi Copiah 28029 971 28 0 943 31.86977774 -90.44565118 2020-08-13 04:29:15 Copiah, Mississippi, US
135834 135834 2020-08-12 US Mississippi Covington 28031 637 15 0 622 31.63225413 -89.55389939 2020-08-13 04:29:15 Covington, Mississippi, US
135835 135835 2020-08-12 US Mississippi DeSoto 28033 3753 31 0 3722 34.87625235 -89.99091418 2020-08-13 04:29:15 DeSoto, Mississippi, US
135836 135836 2020-08-12 US Mississippi Forrest 28035 1858 57 0 1801 31.18961454 -89.25832496 2020-08-13 04:29:15 Forrest, Mississippi, US
135837 135837 2020-08-12 US Mississippi Franklin 28037 135 2 0 133 31.47786634 -90.89672989 2020-08-13 04:29:15 Franklin, Mississippi, US
135838 135838 2020-08-12 US Mississippi George 28039 603 8 0 595 30.86259065 -88.64436789 2020-08-13 04:29:15 George, Mississippi, US
135839 135839 2020-08-12 US Mississippi Greene 28041 262 13 0 249 31.21444233 -88.63922281 2020-08-13 04:29:15 Greene, Mississippi, US
135840 135840 2020-08-12 US Mississippi Grenada 28043 856 26 0 830 33.77036166 -89.80245083 2020-08-13 04:29:15 Grenada, Mississippi, US
135841 135841 2020-08-12 US Mississippi Hancock 28045 409 15 0 394 30.41830223 -89.48851033 2020-08-13 04:29:15 Hancock, Mississippi, US
135842 135842 2020-08-12 US Mississippi Harrison 28047 2651 36 0 2615 30.51359752 -89.12467576 2020-08-13 04:29:15 Harrison, Mississippi, US
135843 135843 2020-08-12 US Mississippi Hinds 28049 5768 121 0 5647 32.2656285 -90.44435448 2020-08-13 04:29:15 Hinds, Mississippi, US
135844 135844 2020-08-12 US Mississippi Holmes 28051 923 49 0 874 33.12345854 -90.08923538 2020-08-13 04:29:15 Holmes, Mississippi, US
135845 135845 2020-08-12 US Mississippi Humphreys 28053 299 12 0 287 33.12825718 -90.52252707 2020-08-13 04:29:15 Humphreys, Mississippi, US
135846 135846 2020-08-12 US Mississippi Issaquena 28055 27 2 0 25 32.72531359 -90.97392828 2020-08-13 04:29:15 Issaquena, Mississippi, US
135847 135847 2020-08-12 US Mississippi Itawamba 28057 395 10 0 385 34.27993475 -88.3606733 2020-08-13 04:29:15 Itawamba, Mississippi, US
135848 135848 2020-08-12 US Mississippi Jackson 28059 2391 45 0 2346 30.54020656 -88.64184064 2020-08-13 04:29:15 Jackson, Mississippi, US
135849 135849 2020-08-12 US Mississippi Jasper 28061 408 9 0 399 32.01922104 -89.11786866 2020-08-13 04:29:15 Jasper, Mississippi, US
135850 135850 2020-08-12 US Mississippi Jefferson 28063 196 7 0 189 31.73397872 -91.03764977 2020-08-13 04:29:15 Jefferson, Mississippi, US
135851 135851 2020-08-12 US Mississippi Jefferson Davis 28065 240 6 0 234 31.56884708 -89.82670990000003 2020-08-13 04:29:15 Jefferson Davis, Mississippi, US
135852 135852 2020-08-12 US Mississippi Jones 28067 1947 62 0 1885 31.62257767 -89.16896899999998 2020-08-13 04:29:15 Jones, Mississippi, US
135853 135853 2020-08-12 US Mississippi Kemper 28069 240 14 0 226 32.75462946 -88.64105766 2020-08-13 04:29:15 Kemper, Mississippi, US
135854 135854 2020-08-12 US Mississippi Lafayette 28071 1018 20 0 998 34.35687874 -89.48490961 2020-08-13 04:29:15 Lafayette, Mississippi, US
135855 135855 2020-08-12 US Mississippi Lamar 28073 1241 15 0 1226 31.20572971 -89.5077704 2020-08-13 04:29:15 Lamar, Mississippi, US
135856 135856 2020-08-12 US Mississippi Lauderdale 28075 1439 93 0 1346 32.40419769 -88.66229662 2020-08-13 04:29:15 Lauderdale, Mississippi, US
135857 135857 2020-08-12 US Mississippi Lawrence 28077 329 8 0 321 31.55147224 -90.10841127 2020-08-13 04:29:15 Lawrence, Mississippi, US
135858 135858 2020-08-12 US Mississippi Leake 28079 799 27 0 772 32.7536828 -89.52402044 2020-08-13 04:29:15 Leake, Mississippi, US
135859 135859 2020-08-12 US Mississippi Lee 28081 1563 42 0 1521 34.291877500000005 -88.68149954 2020-08-13 04:29:15 Lee, Mississippi, US
135860 135860 2020-08-12 US Mississippi Leflore 28083 959 68 0 891 33.55545125 -90.29900733 2020-08-13 04:29:15 Leflore, Mississippi, US
135861 135861 2020-08-12 US Mississippi Lincoln 28085 846 43 0 803 31.53288662 -90.45391915 2020-08-13 04:29:15 Lincoln, Mississippi, US
135862 135862 2020-08-12 US Mississippi Lowndes 28087 1102 40 0 1062 33.47386518 -88.44191529999998 2020-08-13 04:29:15 Lowndes, Mississippi, US
135863 135863 2020-08-12 US Mississippi Madison 28089 2489 72 0 2417 32.63389156 -90.03513564 2020-08-13 04:29:15 Madison, Mississippi, US
135864 135864 2020-08-12 US Mississippi Marion 28091 689 21 0 668 31.23132643 -89.8209217 2020-08-13 04:29:15 Marion, Mississippi, US
135865 135865 2020-08-12 US Mississippi Marshall 28093 729 9 0 720 34.76216286 -89.50299462 2020-08-13 04:29:15 Marshall, Mississippi, US
135866 135866 2020-08-12 US Mississippi Monroe 28095 831 55 0 776 33.89236763 -88.4808438 2020-08-13 04:29:15 Monroe, Mississippi, US
135867 135867 2020-08-12 US Mississippi Montgomery 28097 345 6 0 339 33.49419589 -89.61729103 2020-08-13 04:29:15 Montgomery, Mississippi, US
135868 135868 2020-08-12 US Mississippi Neshoba 28099 1306 94 0 1212 32.75339664 -89.11726492 2020-08-13 04:29:15 Neshoba, Mississippi, US
135869 135869 2020-08-12 US Mississippi Newton 28101 555 11 0 544 32.40021118 -89.11843336 2020-08-13 04:29:15 Newton, Mississippi, US
135870 135870 2020-08-12 US Mississippi Noxubee 28103 463 12 0 451 33.11009499 -88.56949061 2020-08-13 04:29:15 Noxubee, Mississippi, US
135871 135871 2020-08-12 US Mississippi Oktibbeha 28105 1136 39 0 1097 33.42491685 -88.87905132 2020-08-13 04:29:15 Oktibbeha, Mississippi, US
135872 135872 2020-08-12 US Mississippi Panola 28107 1091 17 0 1074 34.36398677 -89.95064249 2020-08-13 04:29:15 Panola, Mississippi, US
135873 135873 2020-08-12 US Mississippi Pearl River 28109 567 40 0 527 30.77090935 -89.58677275 2020-08-13 04:29:15 Pearl River, Mississippi, US
135874 135874 2020-08-12 US Mississippi Perry 28111 248 8 0 240 31.17161885 -88.99281835 2020-08-13 04:29:15 Perry, Mississippi, US
135875 135875 2020-08-12 US Mississippi Pike 28113 951 37 0 914 31.17507789 -90.40392572 2020-08-13 04:29:15 Pike, Mississippi, US
135876 135876 2020-08-12 US Mississippi Pontotoc 28115 857 9 0 848 34.226046000000004 -89.03636807 2020-08-13 04:29:15 Pontotoc, Mississippi, US
135877 135877 2020-08-12 US Mississippi Prentiss 28117 441 10 0 431 34.61810501 -88.51986294 2020-08-13 04:29:15 Prentiss, Mississippi, US
135878 135878 2020-08-12 US Mississippi Quitman 28119 275 1 0 274 34.25157572 -90.28908 2020-08-13 04:29:15 Quitman, Mississippi, US
135879 135879 2020-08-12 US Mississippi Rankin 28121 2322 38 0 2284 32.26469147 -89.94537876 2020-08-13 04:29:15 Rankin, Mississippi, US
135880 135880 2020-08-12 US Mississippi Scott 28123 1017 20 0 997 32.406704100000006 -89.53789439 2020-08-13 04:29:15 Scott, Mississippi, US
135881 135881 2020-08-12 US Mississippi Sharkey 28125 206 5 0 201 32.88149103 -90.8159538 2020-08-13 04:29:15 Sharkey, Mississippi, US
135882 135882 2020-08-12 US Mississippi Simpson 28127 821 31 0 790 31.91282117 -89.91716179 2020-08-13 04:29:15 Simpson, Mississippi, US
135883 135883 2020-08-12 US Mississippi Smith 28129 412 13 0 399 32.01744532 -89.50644846 2020-08-13 04:29:15 Smith, Mississippi, US
135884 135884 2020-08-12 US Mississippi Stone 28131 224 5 0 219 30.79187949 -89.11547539 2020-08-13 04:29:15 Stone, Mississippi, US
135885 135885 2020-08-12 US Mississippi Sunflower 28133 1071 27 0 1044 33.60192578 -90.58882684 2020-08-13 04:29:15 Sunflower, Mississippi, US
135886 135886 2020-08-12 US Mississippi Tallahatchie 28135 547 11 0 536 33.95339918 -90.1729398 2020-08-13 04:29:15 Tallahatchie, Mississippi, US
135887 135887 2020-08-12 US Mississippi Tate 28137 746 30 0 716 34.65133709 -89.94485778 2020-08-13 04:29:15 Tate, Mississippi, US
135888 135888 2020-08-12 US Mississippi Tippah 28139 388 14 0 374 34.76872156 -88.90988194 2020-08-13 04:29:15 Tippah, Mississippi, US
135889 135889 2020-08-12 US Mississippi Tishomingo 28141 444 9 0 435 34.74023475 -88.23917219 2020-08-13 04:29:15 Tishomingo, Mississippi, US
135890 135890 2020-08-12 US Mississippi Tunica 28143 365 7 0 358 34.64967704 -90.37481167 2020-08-13 04:29:15 Tunica, Mississippi, US
135891 135891 2020-08-12 US Mississippi Unassigned 90028 0 0 0 0 34.88084463 0 2020-08-13 04:29:15 Unassigned, Mississippi, US
135892 135892 2020-08-12 US Mississippi Union 28145 700 17 0 683 34.49162015 -89.00776006 2020-08-13 04:29:15 Union, Mississippi, US
135893 135893 2020-08-12 US Mississippi Walthall 28147 511 21 0 490 31.14971548 -90.10446654 2020-08-13 04:29:15 Walthall, Mississippi, US
135894 135894 2020-08-12 US Mississippi Warren 28149 1137 35 0 1102 32.35810271 -90.83352619 2020-08-13 04:29:15 Warren, Mississippi, US
135895 135895 2020-08-12 US Mississippi Washington 28151 1722 44 0 1678 33.28392041 -90.94196237 2020-08-13 04:29:15 Washington, Mississippi, US
135896 135896 2020-08-12 US Mississippi Wayne 28153 789 21 0 768 31.64135687 -88.69573913 2020-08-13 04:29:15 Wayne, Mississippi, US
135897 135897 2020-08-12 US Mississippi Webster 28155 248 13 0 235 33.61300486 -89.28392912 2020-08-13 04:29:15 Webster, Mississippi, US
135898 135898 2020-08-12 US Mississippi Wilkinson 28157 220 13 0 207 31.16078225 -91.31018819 2020-08-13 04:29:15 Wilkinson, Mississippi, US
135899 135899 2020-08-12 US Mississippi Winston 28159 635 16 0 619 33.08747908 -89.03391385 2020-08-13 04:29:15 Winston, Mississippi, US
135900 135900 2020-08-12 US Mississippi Yalobusha 28161 318 10 0 308 34.02824175 -89.70762049999998 2020-08-13 04:29:15 Yalobusha, Mississippi, US
135901 135901 2020-08-12 US Mississippi Yazoo 28163 870 13 0 857 32.77890365 -90.39656148 2020-08-13 04:29:15 Yazoo, Mississippi, US
502189 502189 2020-08-11 US Mississippi Adams 28001 632 25 0 607 31.47669768 -91.35326037 2020-08-12 04:27:29 Adams, Mississippi, US
502190 502190 2020-08-11 US Mississippi Alcorn 28003 435 5 0 430 34.88084463 -88.57996173 2020-08-12 04:27:29 Alcorn, Mississippi, US
502191 502191 2020-08-11 US Mississippi Amite 28005 237 6 0 231 31.17467303 -90.80501621 2020-08-12 04:27:29 Amite, Mississippi, US
502192 502192 2020-08-11 US Mississippi Attala 28007 527 25 0 502 33.08658803 -89.57838564 2020-08-12 04:27:29 Attala, Mississippi, US
502193 502193 2020-08-11 US Mississippi Benton 28009 145 1 0 144 34.81681228 -89.18945516 2020-08-12 04:27:29 Benton, Mississippi, US
502194 502194 2020-08-11 US Mississippi Bolivar 28011 1136 35 0 1101 33.79696941 -90.87372121 2020-08-12 04:27:29 Bolivar, Mississippi, US
502195 502195 2020-08-11 US Mississippi Calhoun 28013 425 9 0 416 33.93683395 -89.33686647 2020-08-12 04:27:29 Calhoun, Mississippi, US
502196 502196 2020-08-11 US Mississippi Carroll 28015 261 11 0 250 33.44834567 -89.91994479 2020-08-12 04:27:29 Carroll, Mississippi, US
502197 502197 2020-08-11 US Mississippi Chickasaw 28017 476 19 0 457 33.91983202 -88.9481545 2020-08-12 04:27:29 Chickasaw, Mississippi, US
502198 502198 2020-08-11 US Mississippi Choctaw 28019 135 4 0 131 33.34598242 -89.24809382 2020-08-12 04:27:29 Choctaw, Mississippi, US
502199 502199 2020-08-11 US Mississippi Claiborne 28021 409 14 0 395 31.97061673 -90.90702196 2020-08-12 04:27:29 Claiborne, Mississippi, US
502200 502200 2020-08-11 US Mississippi Clarke 28023 336 26 0 310 32.04158545 -88.68896219999998 2020-08-12 04:27:29 Clarke, Mississippi, US
502201 502201 2020-08-11 US Mississippi Clay 28025 401 14 0 387 33.65358105 -88.77784255 2020-08-12 04:27:29 Clay, Mississippi, US
502202 502202 2020-08-11 US Mississippi Coahoma 28027 781 13 0 768 34.22772299 -90.60415045 2020-08-12 04:27:29 Coahoma, Mississippi, US
502203 502203 2020-08-11 US Mississippi Copiah 28029 962 28 0 934 31.86977774 -90.44565118 2020-08-12 04:27:29 Copiah, Mississippi, US
502204 502204 2020-08-11 US Mississippi Covington 28031 622 14 0 608 31.63225413 -89.55389939 2020-08-12 04:27:29 Covington, Mississippi, US
502205 502205 2020-08-11 US Mississippi DeSoto 28033 3710 31 0 3679 34.87625235 -89.99091418 2020-08-12 04:27:29 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]);
Powered by Datasette · Query took 2097.622ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette