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 rows where "last_update" is on date 2022-02-14 and province_or_state = "Mississippi" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Mississippi · 83 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-02-13 US Mississippi Adams 28001 7015 139 0   31.47669768 -91.35326037 2022-02-14 04:20:51 Adams, Mississippi, US
2022-02-13 US Mississippi Alcorn 28003 9702 139 0   34.88084463 -88.57996173 2022-02-14 04:20:51 Alcorn, Mississippi, US
2022-02-13 US Mississippi Amite 28005 3155 64 0   31.17467303 -90.80501621 2022-02-14 04:20:51 Amite, Mississippi, US
2022-02-13 US Mississippi Attala 28007 4804 105 0   33.08658803 -89.57838564 2022-02-14 04:20:51 Attala, Mississippi, US
2022-02-13 US Mississippi Benton 28009 2234 46 0   34.81681228 -89.18945516 2022-02-14 04:20:51 Benton, Mississippi, US
2022-02-13 US Mississippi Bolivar 28011 9014 164 0   33.79696941 -90.87372121 2022-02-14 04:20:51 Bolivar, Mississippi, US
2022-02-13 US Mississippi Calhoun 28013 4496 58 0   33.93683395 -89.33686647 2022-02-14 04:20:51 Calhoun, Mississippi, US
2022-02-13 US Mississippi Carroll 28015 2512 48 0   33.44834567 -89.91994479 2022-02-14 04:20:51 Carroll, Mississippi, US
2022-02-13 US Mississippi Chickasaw 28017 5420 88 0   33.91983202 -88.9481545 2022-02-14 04:20:51 Chickasaw, Mississippi, US
2022-02-13 US Mississippi Choctaw 28019 2051 30 0   33.34598242 -89.24809382 2022-02-14 04:20:51 Choctaw, Mississippi, US
2022-02-13 US Mississippi Claiborne 28021 2115 45 0   31.97061673 -90.90702196 2022-02-14 04:20:51 Claiborne, Mississippi, US
2022-02-13 US Mississippi Clarke 28023 4117 101 0   32.04158545 -88.68896219999998 2022-02-14 04:20:51 Clarke, Mississippi, US
2022-02-13 US Mississippi Clay 28025 4902 90 0   33.65358105 -88.77784255 2022-02-14 04:20:51 Clay, Mississippi, US
2022-02-13 US Mississippi Coahoma 28027 6337 119 0   34.22772299 -90.60415045 2022-02-14 04:20:51 Coahoma, Mississippi, US
2022-02-13 US Mississippi Copiah 28029 7006 104 0   31.86977774 -90.44565118 2022-02-14 04:20:51 Copiah, Mississippi, US
2022-02-13 US Mississippi Covington 28031 6957 102 0   31.63225413 -89.55389939 2022-02-14 04:20:51 Covington, Mississippi, US
2022-02-13 US Mississippi DeSoto 28033 48924 514 0   34.87625235 -89.99091418 2022-02-14 04:20:51 DeSoto, Mississippi, US
2022-02-13 US Mississippi Forrest 28035 21572 290 0   31.18961454 -89.25832496 2022-02-14 04:20:51 Forrest, Mississippi, US
2022-02-13 US Mississippi Franklin 28037 1894 35 0   31.47786634 -90.89672989 2022-02-14 04:20:51 Franklin, Mississippi, US
2022-02-13 US Mississippi George 28039 6990 81 0   30.86259065 -88.64436789 2022-02-14 04:20:51 George, Mississippi, US
2022-02-13 US Mississippi Greene 28041 3131 53 0   31.21444233 -88.63922281 2022-02-14 04:20:51 Greene, Mississippi, US
2022-02-13 US Mississippi Grenada 28043 5426 123 0   33.77036166 -89.80245083 2022-02-14 04:20:51 Grenada, Mississippi, US
2022-02-13 US Mississippi Hancock 28045 11947 146 0   30.41830223 -89.48851033 2022-02-14 04:20:51 Hancock, Mississippi, US
2022-02-13 US Mississippi Harrison 28047 52000 623 0   30.51359752 -89.12467576 2022-02-14 04:20:51 Harrison, Mississippi, US
2022-02-13 US Mississippi Hinds 28049 51378 729 0   32.2656285 -90.44435448 2022-02-14 04:20:51 Hinds, Mississippi, US
2022-02-13 US Mississippi Holmes 28051 4327 103 0   33.12345854 -90.08923538 2022-02-14 04:20:51 Holmes, Mississippi, US
2022-02-13 US Mississippi Humphreys 28053 1991 41 0   33.12825718 -90.52252707 2022-02-14 04:20:51 Humphreys, Mississippi, US
2022-02-13 US Mississippi Issaquena 28055 257 9 0   32.72531359 -90.97392828 2022-02-14 04:20:51 Issaquena, Mississippi, US
2022-02-13 US Mississippi Itawamba 28057 7242 134 0   34.27993475 -88.3606733 2022-02-14 04:20:51 Itawamba, Mississippi, US
2022-02-13 US Mississippi Jackson 28059 36225 423 0   30.54020656 -88.64184064 2022-02-14 04:20:51 Jackson, Mississippi, US
2022-02-13 US Mississippi Jasper 28061 4700 69 0   32.01922104 -89.11786866 2022-02-14 04:20:51 Jasper, Mississippi, US
2022-02-13 US Mississippi Jefferson 28063 1463 36 0   31.73397872 -91.03764977 2022-02-14 04:20:51 Jefferson, Mississippi, US
2022-02-13 US Mississippi Jefferson Davis 28065 2809 47 0   31.56884708 -89.82670990000004 2022-02-14 04:20:51 Jefferson Davis, Mississippi, US
2022-02-13 US Mississippi Jones 28067 20827 275 0   31.62257767 -89.16896899999998 2022-02-14 04:20:51 Jones, Mississippi, US
2022-02-13 US Mississippi Kemper 28069 2129 45 0   32.75462946 -88.64105766 2022-02-14 04:20:51 Kemper, Mississippi, US
2022-02-13 US Mississippi Lafayette 28071 14822 172 0   34.35687874 -89.48490961 2022-02-14 04:20:51 Lafayette, Mississippi, US
2022-02-13 US Mississippi Lamar 28073 16981 148 0   31.20572971 -89.5077704 2022-02-14 04:20:51 Lamar, Mississippi, US
2022-02-13 US Mississippi Lauderdale 28075 18289 344 0   32.40419769 -88.66229662 2022-02-14 04:20:51 Lauderdale, Mississippi, US
2022-02-13 US Mississippi Lawrence 28077 3509 48 0   31.55147224 -90.10841127 2022-02-14 04:20:51 Lawrence, Mississippi, US
2022-02-13 US Mississippi Leake 28079 6137 106 0   32.7536828 -89.52402044 2022-02-14 04:20:51 Leake, Mississippi, US
2022-02-13 US Mississippi Lee 28081 26057 276 0   34.291877500000005 -88.68149954 2022-02-14 04:20:51 Lee, Mississippi, US
2022-02-13 US Mississippi Leflore 28083 7247 160 0   33.55545125 -90.29900733 2022-02-14 04:20:51 Leflore, Mississippi, US
2022-02-13 US Mississippi Lincoln 28085 8108 153 0   31.53288662 -90.45391915 2022-02-14 04:20:51 Lincoln, Mississippi, US
2022-02-13 US Mississippi Lowndes 28087 17239 219 0   33.47386518 -88.44191529999998 2022-02-14 04:20:51 Lowndes, Mississippi, US
2022-02-13 US Mississippi Madison 28089 23494 310 0   32.63389156 -90.03513564 2022-02-14 04:20:51 Madison, Mississippi, US
2022-02-13 US Mississippi Marion 28091 6840 129 0   31.23132643 -89.8209217 2022-02-14 04:20:51 Marion, Mississippi, US
2022-02-13 US Mississippi Marshall 28093 9750 161 0   34.76216286 -89.50299462 2022-02-14 04:20:51 Marshall, Mississippi, US
2022-02-13 US Mississippi Monroe 28095 10749 204 0   33.89236763 -88.4808438 2022-02-14 04:20:51 Monroe, Mississippi, US
2022-02-13 US Mississippi Montgomery 28097 2884 68 0   33.49419589 -89.61729103 2022-02-14 04:20:51 Montgomery, Mississippi, US
2022-02-13 US Mississippi Neshoba 28099 10187 224 0   32.75339664 -89.11726492 2022-02-14 04:20:51 Neshoba, Mississippi, US
2022-02-13 US Mississippi Newton 28101 5804 92 0   32.40021118 -89.11843336 2022-02-14 04:20:51 Newton, Mississippi, US
2022-02-13 US Mississippi Noxubee 28103 2690 47 0   33.11009499 -88.56949061 2022-02-14 04:20:51 Noxubee, Mississippi, US
2022-02-13 US Mississippi Oktibbeha 28105 10852 154 0   33.42491685 -88.87905132 2022-02-14 04:20:51 Oktibbeha, Mississippi, US
2022-02-13 US Mississippi Panola 28107 10265 154 0   34.36398677 -89.95064249 2022-02-14 04:20:51 Panola, Mississippi, US
2022-02-13 US Mississippi Pearl River 28109 14776 259 0   30.77090935 -89.58677275 2022-02-14 04:20:51 Pearl River, Mississippi, US
2022-02-13 US Mississippi Perry 28111 2994 62 0   31.17161885 -88.99281835 2022-02-14 04:20:51 Perry, Mississippi, US
2022-02-13 US Mississippi Pike 28113 9208 171 0   31.17507789 -90.40392572 2022-02-14 04:20:51 Pike, Mississippi, US
2022-02-13 US Mississippi Pontotoc 28115 10061 127 0   34.226046000000004 -89.03636807 2022-02-14 04:20:51 Pontotoc, Mississippi, US
2022-02-13 US Mississippi Prentiss 28117 7939 96 0   34.61810501 -88.51986294 2022-02-14 04:20:51 Prentiss, Mississippi, US
2022-02-13 US Mississippi Quitman 28119 1548 30 0   34.25157572 -90.28908 2022-02-14 04:20:51 Quitman, Mississippi, US
2022-02-13 US Mississippi Rankin 28121 35740 451 0   32.26469147 -89.94537876 2022-02-14 04:20:51 Rankin, Mississippi, US
2022-02-13 US Mississippi Scott 28123 6432 109 0   32.406704100000006 -89.53789439 2022-02-14 04:20:51 Scott, Mississippi, US
2022-02-13 US Mississippi Sharkey 28125 935 23 0   32.88149103 -90.81595379999999 2022-02-14 04:20:51 Sharkey, Mississippi, US
2022-02-13 US Mississippi Simpson 28127 6831 138 0   31.91282117 -89.91716179 2022-02-14 04:20:51 Simpson, Mississippi, US
2022-02-13 US Mississippi Smith 28129 3995 66 0   32.01744532 -89.50644846 2022-02-14 04:20:51 Smith, Mississippi, US
2022-02-13 US Mississippi Stone 28131 5287 69 0   30.79187949 -89.11547539 2022-02-14 04:20:51 Stone, Mississippi, US
2022-02-13 US Mississippi Sunflower 28133 5686 116 0   33.60192578 -90.58882684 2022-02-14 04:20:51 Sunflower, Mississippi, US
2022-02-13 US Mississippi Tallahatchie 28135 3151 59 0   33.95339918 -90.1729398 2022-02-14 04:20:51 Tallahatchie, Mississippi, US
2022-02-13 US Mississippi Tate 28137 7156 135 0   34.65133709 -89.94485778 2022-02-14 04:20:51 Tate, Mississippi, US
2022-02-13 US Mississippi Tippah 28139 7117 103 0   34.76872156 -88.90988194 2022-02-14 04:20:51 Tippah, Mississippi, US
2022-02-13 US Mississippi Tishomingo 28141 6008 115 0   34.74023475 -88.23917219 2022-02-14 04:20:51 Tishomingo, Mississippi, US
2022-02-13 US Mississippi Tunica 28143 2480 43 0   34.64967704 -90.37481167 2022-02-14 04:20:51 Tunica, Mississippi, US
2022-02-13 US Mississippi Unassigned 90028 0 0 0   34.88084463 0.0 2022-02-14 04:20:51 Unassigned, Mississippi, US
2022-02-13 US Mississippi Union 28145 9305 111 0   34.49162015 -89.00776006 2022-02-14 04:20:51 Union, Mississippi, US
2022-02-13 US Mississippi Walthall 28147 3499 77 0   31.14971548 -90.10446654 2022-02-14 04:20:51 Walthall, Mississippi, US
2022-02-13 US Mississippi Warren 28149 9962 191 0   32.35810271 -90.83352619 2022-02-14 04:20:51 Warren, Mississippi, US
2022-02-13 US Mississippi Washington 28151 9991 185 0   33.28392041 -90.94196237 2022-02-14 04:20:51 Washington, Mississippi, US
2022-02-13 US Mississippi Wayne 28153 5854 83 0   31.64135687 -88.69573913 2022-02-14 04:20:51 Wayne, Mississippi, US
2022-02-13 US Mississippi Webster 28155 3077 59 0   33.61300486 -89.28392912 2022-02-14 04:20:51 Webster, Mississippi, US
2022-02-13 US Mississippi Wilkinson 28157 1771 44 0   31.16078225 -91.31018819 2022-02-14 04:20:51 Wilkinson, Mississippi, US
2022-02-13 US Mississippi Winston 28159 5026 99 0   33.08747908 -89.03391385 2022-02-14 04:20:51 Winston, Mississippi, US
2022-02-13 US Mississippi Yalobusha 28161 3997 51 0   34.02824175 -89.70762049999998 2022-02-14 04:20:51 Yalobusha, Mississippi, US
2022-02-13 US Mississippi Yazoo 28163 7918 99 0   32.77890365 -90.39656148 2022-02-14 04:20:51 Yazoo, Mississippi, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;