daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

83,968 rows where province_or_state = "Mississippi" sorted by active

✎ View and edit SQL

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

Suggested facets: last_update (date)

province_or_state 1

  • Mississippi · 83,968 ✖

country_or_region 1

  • US 83,968
day country_or_region province_or_state admin2 fips confirmed deaths recovered active ▼ latitude longitude last_update combined_key
2021-12-02 US Mississippi Adams 28001 4775 125 0   31.47669768 -91.35326037 2021-12-03 04:23:05 Adams, Mississippi, US
2021-12-02 US Mississippi Alcorn 28003 5912 107 0   34.88084463 -88.57996173 2021-12-03 04:23:05 Alcorn, Mississippi, US
2021-12-02 US Mississippi Amite 28005 2102 57 0   31.17467303 -90.80501621 2021-12-03 04:23:05 Amite, Mississippi, US
2021-12-02 US Mississippi Attala 28007 3395 90 0   33.08658803 -89.57838564 2021-12-03 04:23:05 Attala, Mississippi, US
2021-12-02 US Mississippi Benton 28009 1532 39 0   34.81681228 -89.18945516 2021-12-03 04:23:05 Benton, Mississippi, US
2021-12-02 US Mississippi Bolivar 28011 6468 151 0   33.79696941 -90.87372121 2021-12-03 04:23:05 Bolivar, Mississippi, US
2021-12-02 US Mississippi Calhoun 28013 2863 49 0   33.93683395 -89.33686647 2021-12-03 04:23:05 Calhoun, Mississippi, US
2021-12-02 US Mississippi Carroll 28015 1752 41 0   33.44834567 -89.91994479 2021-12-03 04:23:05 Carroll, Mississippi, US
2021-12-02 US Mississippi Chickasaw 28017 3176 67 0   33.91983202 -88.9481545 2021-12-03 04:23:05 Chickasaw, Mississippi, US
2021-12-02 US Mississippi Choctaw 28019 1370 27 0   33.34598242 -89.24809382 2021-12-03 04:23:05 Choctaw, Mississippi, US
2021-12-02 US Mississippi Claiborne 28021 1346 39 0   31.97061673 -90.90702196 2021-12-03 04:23:05 Claiborne, Mississippi, US
2021-12-02 US Mississippi Clarke 28023 3016 95 0   32.04158545 -88.68896219999998 2021-12-03 04:23:05 Clarke, Mississippi, US
2021-12-02 US Mississippi Clay 28025 3127 78 0   33.65358105 -88.77784255 2021-12-03 04:23:05 Clay, Mississippi, US
2021-12-02 US Mississippi Coahoma 28027 4243 109 0   34.22772299 -90.60415045 2021-12-03 04:23:05 Coahoma, Mississippi, US
2021-12-02 US Mississippi Copiah 28029 4580 95 0   31.86977774 -90.44565118 2021-12-03 04:23:05 Copiah, Mississippi, US
2021-12-02 US Mississippi Covington 28031 4348 95 0   31.63225413 -89.55389939 2021-12-03 04:23:05 Covington, Mississippi, US
2021-12-02 US Mississippi DeSoto 28033 33342 432 0   34.87625235 -89.99091418 2021-12-03 04:23:05 DeSoto, Mississippi, US
2021-12-02 US Mississippi Forrest 28035 13829 260 0   31.18961454 -89.25832496 2021-12-03 04:23:05 Forrest, Mississippi, US
2021-12-02 US Mississippi Franklin 28037 1264 30 0   31.47786634 -90.89672989 2021-12-03 04:23:05 Franklin, Mississippi, US
2021-12-02 US Mississippi George 28039 5106 80 0   30.86259065 -88.64436789 2021-12-03 04:23:05 George, Mississippi, US
2021-12-02 US Mississippi Greene 28041 2251 49 0   31.21444233 -88.63922281 2021-12-03 04:23:05 Greene, Mississippi, US
2021-12-02 US Mississippi Grenada 28043 3786 109 0   33.77036166 -89.80245083 2021-12-03 04:23:05 Grenada, Mississippi, US
2021-12-02 US Mississippi Hancock 28045 7847 132 0   30.41830223 -89.48851033 2021-12-03 04:23:05 Hancock, Mississippi, US
2021-12-02 US Mississippi Harrison 28047 34981 557 0   30.51359752 -89.12467576 2021-12-03 04:23:05 Harrison, Mississippi, US
2021-12-02 US Mississippi Hinds 28049 32718 643 0   32.2656285 -90.44435448 2021-12-03 04:23:05 Hinds, Mississippi, US
2021-12-02 US Mississippi Holmes 28051 2725 89 0   33.12345854 -90.08923538 2021-12-03 04:23:05 Holmes, Mississippi, US
2021-12-02 US Mississippi Humphreys 28053 1322 39 0   33.12825718 -90.52252707 2021-12-03 04:23:05 Humphreys, Mississippi, US
2021-12-02 US Mississippi Issaquena 28055 195 7 0   32.72531359 -90.97392828 2021-12-03 04:23:05 Issaquena, Mississippi, US
2021-12-02 US Mississippi Itawamba 28057 4877 107 0   34.27993475 -88.3606733 2021-12-03 04:23:05 Itawamba, Mississippi, US
2021-12-02 US Mississippi Jackson 28059 24896 391 0   30.54020656 -88.64184064 2021-12-03 04:23:05 Jackson, Mississippi, US
2021-12-02 US Mississippi Jasper 28061 3412 66 0   32.01922104 -89.11786866 2021-12-03 04:23:05 Jasper, Mississippi, US
2021-12-02 US Mississippi Jefferson 28063 969 34 0   31.73397872 -91.03764977 2021-12-03 04:23:05 Jefferson, Mississippi, US
2021-12-02 US Mississippi Jefferson Davis 28065 1740 43 0   31.56884708 -89.82670990000004 2021-12-03 04:23:05 Jefferson Davis, Mississippi, US
2021-12-02 US Mississippi Jones 28067 14155 248 0   31.62257767 -89.16896899999998 2021-12-03 04:23:05 Jones, Mississippi, US
2021-12-02 US Mississippi Kemper 28069 1454 41 0   32.75462946 -88.64105766 2021-12-03 04:23:05 Kemper, Mississippi, US
2021-12-02 US Mississippi Lafayette 28071 8867 143 0   34.35687874 -89.48490961 2021-12-03 04:23:05 Lafayette, Mississippi, US
2021-12-02 US Mississippi Lamar 28073 10687 140 0   31.20572971 -89.5077704 2021-12-03 04:23:05 Lamar, Mississippi, US
2021-12-02 US Mississippi Lauderdale 28075 12305 324 0   32.40419769 -88.66229662 2021-12-03 04:23:05 Lauderdale, Mississippi, US
2021-12-02 US Mississippi Lawrence 28077 2202 41 0   31.55147224 -90.10841127 2021-12-03 04:23:05 Lawrence, Mississippi, US
2021-12-02 US Mississippi Leake 28079 4140 90 0   32.7536828 -89.52402044 2021-12-03 04:23:05 Leake, Mississippi, US
2021-12-02 US Mississippi Lee 28081 16439 245 0   34.291877500000005 -88.68149954 2021-12-03 04:23:05 Lee, Mississippi, US
2021-12-02 US Mississippi Leflore 28083 4747 144 0   33.55545125 -90.29900733 2021-12-03 04:23:05 Leflore, Mississippi, US
2021-12-02 US Mississippi Lincoln 28085 5539 136 0   31.53288662 -90.45391915 2021-12-03 04:23:05 Lincoln, Mississippi, US
2021-12-02 US Mississippi Lowndes 28087 11348 193 0   33.47386518 -88.44191529999998 2021-12-03 04:23:05 Lowndes, Mississippi, US
2021-12-02 US Mississippi Madison 28089 14949 283 0   32.63389156 -90.03513564 2021-12-03 04:23:05 Madison, Mississippi, US
2021-12-02 US Mississippi Marion 28091 4295 112 0   31.23132643 -89.8209217 2021-12-03 04:23:05 Marion, Mississippi, US
2021-12-02 US Mississippi Marshall 28093 6705 142 0   34.76216286 -89.50299462 2021-12-03 04:23:05 Marshall, Mississippi, US
2021-12-02 US Mississippi Monroe 28095 7055 179 0   33.89236763 -88.4808438 2021-12-03 04:23:05 Monroe, Mississippi, US
2021-12-02 US Mississippi Montgomery 28097 1821 57 0   33.49419589 -89.61729103 2021-12-03 04:23:05 Montgomery, Mississippi, US
2021-12-02 US Mississippi Neshoba 28099 6740 210 0   32.75339664 -89.11726492 2021-12-03 04:23:05 Neshoba, Mississippi, US
2021-12-02 US Mississippi Newton 28101 3960 82 0   32.40021118 -89.11843336 2021-12-03 04:23:05 Newton, Mississippi, US
2021-12-02 US Mississippi Noxubee 28103 1888 43 0   33.11009499 -88.56949061 2021-12-03 04:23:05 Noxubee, Mississippi, US
2021-12-02 US Mississippi Oktibbeha 28105 7228 138 0   33.42491685 -88.87905132 2021-12-03 04:23:05 Oktibbeha, Mississippi, US
2021-12-02 US Mississippi Panola 28107 6783 135 0   34.36398677 -89.95064249 2021-12-03 04:23:05 Panola, Mississippi, US
2021-12-02 US Mississippi Pearl River 28109 9739 244 0   30.77090935 -89.58677275 2021-12-03 04:23:05 Pearl River, Mississippi, US
2021-12-02 US Mississippi Perry 28111 2144 56 0   31.17161885 -88.99281835 2021-12-03 04:23:05 Perry, Mississippi, US
2021-12-02 US Mississippi Pike 28113 5941 157 0   31.17507789 -90.40392572 2021-12-03 04:23:05 Pike, Mississippi, US
2021-12-02 US Mississippi Pontotoc 28115 7026 110 0   34.226046000000004 -89.03636807 2021-12-03 04:23:05 Pontotoc, Mississippi, US
2021-12-02 US Mississippi Prentiss 28117 5077 85 0   34.61810501 -88.51986294 2021-12-03 04:23:05 Prentiss, Mississippi, US
2021-12-02 US Mississippi Quitman 28119 1078 28 0   34.25157572 -90.28908 2021-12-03 04:23:05 Quitman, Mississippi, US
2021-12-02 US Mississippi Rankin 28121 22553 404 0   32.26469147 -89.94537876 2021-12-03 04:23:05 Rankin, Mississippi, US
2021-12-02 US Mississippi Scott 28123 4787 99 0   32.406704100000006 -89.53789439 2021-12-03 04:23:05 Scott, Mississippi, US
2021-12-02 US Mississippi Sharkey 28125 653 21 0   32.88149103 -90.81595379999999 2021-12-03 04:23:05 Sharkey, Mississippi, US
2021-12-02 US Mississippi Simpson 28127 4565 117 0   31.91282117 -89.91716179 2021-12-03 04:23:05 Simpson, Mississippi, US
2021-12-02 US Mississippi Smith 28129 2699 52 0   32.01744532 -89.50644846 2021-12-03 04:23:05 Smith, Mississippi, US
2021-12-02 US Mississippi Stone 28131 3659 66 0   30.79187949 -89.11547539 2021-12-03 04:23:05 Stone, Mississippi, US
2021-12-02 US Mississippi Sunflower 28133 4318 106 0   33.60192578 -90.58882684 2021-12-03 04:23:05 Sunflower, Mississippi, US
2021-12-02 US Mississippi Tallahatchie 28135 2323 53 0   33.95339918 -90.1729398 2021-12-03 04:23:05 Tallahatchie, Mississippi, US
2021-12-02 US Mississippi Tate 28137 4774 117 0   34.65133709 -89.94485778 2021-12-03 04:23:05 Tate, Mississippi, US
2021-12-02 US Mississippi Tippah 28139 4954 83 0   34.76872156 -88.90988194 2021-12-03 04:23:05 Tippah, Mississippi, US
2021-12-02 US Mississippi Tishomingo 28141 3861 94 0   34.74023475 -88.23917219 2021-12-03 04:23:05 Tishomingo, Mississippi, US
2021-12-02 US Mississippi Tunica 28143 1635 39 0   34.64967704 -90.37481167 2021-12-03 04:23:05 Tunica, Mississippi, US
2021-12-02 US Mississippi Unassigned 90028 0 0 0   34.88084463 0.0 2021-12-03 04:23:05 Unassigned, Mississippi, US
2021-12-02 US Mississippi Union 28145 6428 98 0   34.49162015 -89.00776006 2021-12-03 04:23:05 Union, Mississippi, US
2021-12-02 US Mississippi Walthall 28147 2221 66 0   31.14971548 -90.10446654 2021-12-03 04:23:05 Walthall, Mississippi, US
2021-12-02 US Mississippi Warren 28149 6883 178 0   32.35810271 -90.83352619 2021-12-03 04:23:05 Warren, Mississippi, US
2021-12-02 US Mississippi Washington 28151 7555 169 0   33.28392041 -90.94196237 2021-12-03 04:23:05 Washington, Mississippi, US
2021-12-02 US Mississippi Wayne 28153 4434 72 0   31.64135687 -88.69573913 2021-12-03 04:23:05 Wayne, Mississippi, US
2021-12-02 US Mississippi Webster 28155 2065 48 0   33.61300486 -89.28392912 2021-12-03 04:23:05 Webster, Mississippi, US
2021-12-02 US Mississippi Wilkinson 28157 1061 39 0   31.16078225 -91.31018819 2021-12-03 04:23:05 Wilkinson, Mississippi, US
2021-12-02 US Mississippi Winston 28159 3179 92 0   33.08747908 -89.03391385 2021-12-03 04:23:05 Winston, Mississippi, US
2021-12-02 US Mississippi Yalobusha 28161 2446 47 0   34.02824175 -89.70762049999998 2021-12-03 04:23:05 Yalobusha, Mississippi, US
2021-12-02 US Mississippi Yazoo 28163 4578 92 0   32.77890365 -90.39656148 2021-12-03 04:23:05 Yazoo, Mississippi, US
2021-10-28 US Mississippi Adams 28001 4622 120 0   31.47669768 -91.35326037 2021-10-29 04:22:03 Adams, Mississippi, US
2021-10-28 US Mississippi Alcorn 28003 5701 102 0   34.88084463 -88.57996173 2021-10-29 04:22:03 Alcorn, Mississippi, US
2021-10-28 US Mississippi Amite 28005 2064 56 0   31.17467303 -90.80501621 2021-10-29 04:22:03 Amite, Mississippi, US
2021-10-28 US Mississippi Attala 28007 3352 90 0   33.08658803 -89.57838564 2021-10-29 04:22:03 Attala, Mississippi, US
2021-10-28 US Mississippi Benton 28009 1500 39 0   34.81681228 -89.18945516 2021-10-29 04:22:03 Benton, Mississippi, US
2021-10-28 US Mississippi Bolivar 28011 6339 150 0   33.79696941 -90.87372121 2021-10-29 04:22:03 Bolivar, Mississippi, US
2021-10-28 US Mississippi Calhoun 28013 2806 47 0   33.93683395 -89.33686647 2021-10-29 04:22:03 Calhoun, Mississippi, US
2021-10-28 US Mississippi Carroll 28015 1697 40 0   33.44834567 -89.91994479 2021-10-29 04:22:03 Carroll, Mississippi, US
2021-10-28 US Mississippi Chickasaw 28017 3031 67 0   33.91983202 -88.9481545 2021-10-29 04:22:03 Chickasaw, Mississippi, US
2021-10-28 US Mississippi Choctaw 28019 1347 27 0   33.34598242 -89.24809382 2021-10-29 04:22:03 Choctaw, Mississippi, US
2021-10-28 US Mississippi Claiborne 28021 1331 38 0   31.97061673 -90.90702196 2021-10-29 04:22:03 Claiborne, Mississippi, US
2021-10-28 US Mississippi Clarke 28023 2971 94 0   32.04158545 -88.68896219999998 2021-10-29 04:22:03 Clarke, Mississippi, US
2021-10-28 US Mississippi Clay 28025 3093 77 0   33.65358105 -88.77784255 2021-10-29 04:22:03 Clay, Mississippi, US
2021-10-28 US Mississippi Coahoma 28027 4186 108 0   34.22772299 -90.60415045 2021-10-29 04:22:03 Coahoma, Mississippi, US
2021-10-28 US Mississippi Copiah 28029 4500 92 0   31.86977774 -90.44565118 2021-10-29 04:22:03 Copiah, Mississippi, US
2021-10-28 US Mississippi Covington 28031 4303 94 0   31.63225413 -89.55389939 2021-10-29 04:22:03 Covington, Mississippi, US
2021-10-28 US Mississippi DeSoto 28033 32375 412 0   34.87625235 -89.99091418 2021-10-29 04:22:03 DeSoto, Mississippi, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;