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 2020-09-21 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
2020-09-20 US Mississippi Adams 28001 919 36 0 883 31.47669768 -91.35326037 2020-09-21 04:23:00 Adams, Mississippi, US
2020-09-20 US Mississippi Alcorn 28003 773 11 0 762 34.88084463 -88.57996173 2020-09-21 04:23:00 Alcorn, Mississippi, US
2020-09-20 US Mississippi Amite 28005 311 10 0 301 31.17467303 -90.80501621 2020-09-21 04:23:00 Amite, Mississippi, US
2020-09-20 US Mississippi Attala 28007 641 25 0 616 33.08658803 -89.57838564 2020-09-21 04:23:00 Attala, Mississippi, US
2020-09-20 US Mississippi Benton 28009 219 1 0 218 34.81681228 -89.18945516 2020-09-21 04:23:00 Benton, Mississippi, US
2020-09-20 US Mississippi Bolivar 28011 1794 65 0 1729 33.79696941 -90.87372121 2020-09-21 04:23:00 Bolivar, Mississippi, US
2020-09-20 US Mississippi Calhoun 28013 506 12 0 494 33.93683395 -89.33686647 2020-09-21 04:23:00 Calhoun, Mississippi, US
2020-09-20 US Mississippi Carroll 28015 312 12 0 300 33.44834567 -89.91994479 2020-09-21 04:23:00 Carroll, Mississippi, US
2020-09-20 US Mississippi Chickasaw 28017 655 24 0 631 33.91983202 -88.9481545 2020-09-21 04:23:00 Chickasaw, Mississippi, US
2020-09-20 US Mississippi Choctaw 28019 179 5 0 174 33.34598242 -89.24809382 2020-09-21 04:23:00 Choctaw, Mississippi, US
2020-09-20 US Mississippi Claiborne 28021 452 16 0 436 31.97061673 -90.90702196 2020-09-21 04:23:00 Claiborne, Mississippi, US
2020-09-20 US Mississippi Clarke 28023 535 39 0 496 32.04158545 -88.6889622 2020-09-21 04:23:00 Clarke, Mississippi, US
2020-09-20 US Mississippi Clay 28025 578 17 0 561 33.65358105 -88.77784255 2020-09-21 04:23:00 Clay, Mississippi, US
2020-09-20 US Mississippi Coahoma 28027 1123 27 0 1096 34.22772299 -90.60415045 2020-09-21 04:23:00 Coahoma, Mississippi, US
2020-09-20 US Mississippi Copiah 28029 1162 33 0 1129 31.86977774 -90.44565118 2020-09-21 04:23:00 Copiah, Mississippi, US
2020-09-20 US Mississippi Covington 28031 805 22 0 783 31.63225413 -89.55389939 2020-09-21 04:23:00 Covington, Mississippi, US
2020-09-20 US Mississippi DeSoto 28033 5411 55 0 5356 34.87625235 -89.99091418 2020-09-21 04:23:00 DeSoto, Mississippi, US
2020-09-20 US Mississippi Forrest 28035 2390 70 0 2320 31.18961454 -89.25832496 2020-09-21 04:23:00 Forrest, Mississippi, US
2020-09-20 US Mississippi Franklin 28037 189 3 0 186 31.47786634 -90.89672989 2020-09-21 04:23:00 Franklin, Mississippi, US
2020-09-20 US Mississippi George 28039 749 13 0 736 30.86259065 -88.64436789 2020-09-21 04:23:00 George, Mississippi, US
2020-09-20 US Mississippi Greene 28041 345 17 0 328 31.21444233 -88.63922281 2020-09-21 04:23:00 Greene, Mississippi, US
2020-09-20 US Mississippi Grenada 28043 1061 35 0 1026 33.77036166 -89.80245083 2020-09-21 04:23:00 Grenada, Mississippi, US
2020-09-20 US Mississippi Hancock 28045 561 21 0 540 30.41830223 -89.48851033 2020-09-21 04:23:00 Hancock, Mississippi, US
2020-09-20 US Mississippi Harrison 28047 3732 72 0 3660 30.51359752 -89.12467576 2020-09-21 04:23:00 Harrison, Mississippi, US
2020-09-20 US Mississippi Hinds 28049 6974 155 0 6819 32.2656285 -90.44435448 2020-09-21 04:23:00 Hinds, Mississippi, US
2020-09-20 US Mississippi Holmes 28051 1092 58 0 1034 33.12345854 -90.08923538 2020-09-21 04:23:00 Holmes, Mississippi, US
2020-09-20 US Mississippi Humphreys 28053 373 15 0 358 33.12825718 -90.52252707 2020-09-21 04:23:00 Humphreys, Mississippi, US
2020-09-20 US Mississippi Issaquena 28055 103 3 0 100 32.72531359 -90.97392828 2020-09-21 04:23:00 Issaquena, Mississippi, US
2020-09-20 US Mississippi Itawamba 28057 762 21 0 741 34.27993475 -88.3606733 2020-09-21 04:23:00 Itawamba, Mississippi, US
2020-09-20 US Mississippi Jackson 28059 3388 67 0 3321 30.54020656 -88.64184064 2020-09-21 04:23:00 Jackson, Mississippi, US
2020-09-20 US Mississippi Jasper 28061 554 15 0 539 32.01922104 -89.11786866 2020-09-21 04:23:00 Jasper, Mississippi, US
2020-09-20 US Mississippi Jefferson 28063 242 9 0 233 31.73397872 -91.03764977 2020-09-21 04:23:00 Jefferson, Mississippi, US
2020-09-20 US Mississippi Jefferson Davis 28065 325 11 0 314 31.56884708 -89.8267099 2020-09-21 04:23:00 Jefferson Davis, Mississippi, US
2020-09-20 US Mississippi Jones 28067 2420 78 0 2342 31.62257767 -89.168969 2020-09-21 04:23:00 Jones, Mississippi, US
2020-09-20 US Mississippi Kemper 28069 286 15 0 271 32.75462946 -88.64105766 2020-09-21 04:23:00 Kemper, Mississippi, US
2020-09-20 US Mississippi Lafayette 28071 2084 39 0 2045 34.35687874 -89.48490961 2020-09-21 04:23:00 Lafayette, Mississippi, US
2020-09-20 US Mississippi Lamar 28073 1631 34 0 1597 31.20572971 -89.5077704 2020-09-21 04:23:00 Lamar, Mississippi, US
2020-09-20 US Mississippi Lauderdale 28075 1999 124 0 1875 32.40419769 -88.66229662 2020-09-21 04:23:00 Lauderdale, Mississippi, US
2020-09-20 US Mississippi Lawrence 28077 425 12 0 413 31.55147224 -90.10841127 2020-09-21 04:23:00 Lawrence, Mississippi, US
2020-09-20 US Mississippi Leake 28079 939 37 0 902 32.7536828 -89.52402044 2020-09-21 04:23:00 Leake, Mississippi, US
2020-09-20 US Mississippi Lee 28081 2606 67 0 2539 34.2918775 -88.68149954 2020-09-21 04:23:00 Lee, Mississippi, US
2020-09-20 US Mississippi Leflore 28083 1369 80 0 1289 33.55545125 -90.29900733 2020-09-21 04:23:00 Leflore, Mississippi, US
2020-09-20 US Mississippi Lincoln 28085 1067 53 0 1014 31.53288662 -90.45391915 2020-09-21 04:23:00 Lincoln, Mississippi, US
2020-09-20 US Mississippi Lowndes 28087 1399 57 0 1342 33.47386518 -88.4419153 2020-09-21 04:23:00 Lowndes, Mississippi, US
2020-09-20 US Mississippi Madison 28089 3208 86 0 3122 32.63389156 -90.03513564 2020-09-21 04:23:00 Madison, Mississippi, US
2020-09-20 US Mississippi Marion 28091 841 33 0 808 31.23132643 -89.8209217 2020-09-21 04:23:00 Marion, Mississippi, US
2020-09-20 US Mississippi Marshall 28093 1076 15 0 1061 34.76216286 -89.50299462 2020-09-21 04:23:00 Marshall, Mississippi, US
2020-09-20 US Mississippi Monroe 28095 1188 65 0 1123 33.89236763 -88.4808438 2020-09-21 04:23:00 Monroe, Mississippi, US
2020-09-20 US Mississippi Montgomery 28097 455 20 0 435 33.49419589 -89.61729103 2020-09-21 04:23:00 Montgomery, Mississippi, US
2020-09-20 US Mississippi Neshoba 28099 1536 103 0 1433 32.75339664 -89.11726492 2020-09-21 04:23:00 Neshoba, Mississippi, US
2020-09-20 US Mississippi Newton 28101 757 23 0 734 32.40021118 -89.11843336 2020-09-21 04:23:00 Newton, Mississippi, US
2020-09-20 US Mississippi Noxubee 28103 543 15 0 528 33.11009499 -88.56949061 2020-09-21 04:23:00 Noxubee, Mississippi, US
2020-09-20 US Mississippi Oktibbeha 28105 1750 50 0 1700 33.42491685 -88.87905132 2020-09-21 04:23:00 Oktibbeha, Mississippi, US
2020-09-20 US Mississippi Panola 28107 1440 27 0 1413 34.36398677 -89.95064249 2020-09-21 04:23:00 Panola, Mississippi, US
2020-09-20 US Mississippi Pearl River 28109 865 50 0 815 30.77090935 -89.58677275 2020-09-21 04:23:00 Pearl River, Mississippi, US
2020-09-20 US Mississippi Perry 28111 407 18 0 389 31.17161885 -88.99281835 2020-09-21 04:23:00 Perry, Mississippi, US
2020-09-20 US Mississippi Pike 28113 1212 48 0 1164 31.17507789 -90.40392572 2020-09-21 04:23:00 Pike, Mississippi, US
2020-09-20 US Mississippi Pontotoc 28115 1234 16 0 1218 34.226046 -89.03636807 2020-09-21 04:23:00 Pontotoc, Mississippi, US
2020-09-20 US Mississippi Prentiss 28117 811 17 0 794 34.61810501 -88.51986294 2020-09-21 04:23:00 Prentiss, Mississippi, US
2020-09-20 US Mississippi Quitman 28119 374 5 0 369 34.25157572 -90.28908 2020-09-21 04:23:00 Quitman, Mississippi, US
2020-09-20 US Mississippi Rankin 28121 3190 75 0 3115 32.26469147 -89.94537876 2020-09-21 04:23:00 Rankin, Mississippi, US
2020-09-20 US Mississippi Scott 28123 1164 25 0 1139 32.4067041 -89.53789439 2020-09-21 04:23:00 Scott, Mississippi, US
2020-09-20 US Mississippi Sharkey 28125 263 12 0 251 32.88149103 -90.8159538 2020-09-21 04:23:00 Sharkey, Mississippi, US
2020-09-20 US Mississippi Simpson 28127 1011 43 0 968 31.91282117 -89.91716179 2020-09-21 04:23:00 Simpson, Mississippi, US
2020-09-20 US Mississippi Smith 28129 523 14 0 509 32.01744532 -89.50644846 2020-09-21 04:23:00 Smith, Mississippi, US
2020-09-20 US Mississippi Stone 28131 355 11 0 344 30.79187949 -89.11547539 2020-09-21 04:23:00 Stone, Mississippi, US
2020-09-20 US Mississippi Sunflower 28133 1417 44 0 1373 33.60192578 -90.58882684 2020-09-21 04:23:00 Sunflower, Mississippi, US
2020-09-20 US Mississippi Tallahatchie 28135 754 18 0 736 33.95339918 -90.1729398 2020-09-21 04:23:00 Tallahatchie, Mississippi, US
2020-09-20 US Mississippi Tate 28137 951 37 0 914 34.65133709 -89.94485778 2020-09-21 04:23:00 Tate, Mississippi, US
2020-09-20 US Mississippi Tippah 28139 642 16 0 626 34.76872156 -88.90988194 2020-09-21 04:23:00 Tippah, Mississippi, US
2020-09-20 US Mississippi Tishomingo 28141 658 37 0 621 34.74023475 -88.23917219 2020-09-21 04:23:00 Tishomingo, Mississippi, US
2020-09-20 US Mississippi Tunica 28143 479 13 0 466 34.64967704 -90.37481167 2020-09-21 04:23:00 Tunica, Mississippi, US
2020-09-20 US Mississippi Unassigned 90028 0 0 0 0 34.88084463 0.0 2020-09-21 04:23:00 Unassigned, Mississippi, US
2020-09-20 US Mississippi Union 28145 978 24 0 954 34.49162015 -89.00776006 2020-09-21 04:23:00 Union, Mississippi, US
2020-09-20 US Mississippi Walthall 28147 593 25 0 568 31.14971548 -90.10446654 2020-09-21 04:23:00 Walthall, Mississippi, US
2020-09-20 US Mississippi Warren 28149 1381 50 0 1331 32.35810271 -90.83352619 2020-09-21 04:23:00 Warren, Mississippi, US
2020-09-20 US Mississippi Washington 28151 2179 71 0 2108 33.28392041 -90.94196237 2020-09-21 04:23:00 Washington, Mississippi, US
2020-09-20 US Mississippi Wayne 28153 877 21 0 856 31.64135687 -88.69573913 2020-09-21 04:23:00 Wayne, Mississippi, US
2020-09-20 US Mississippi Webster 28155 331 13 0 318 33.61300486 -89.28392912 2020-09-21 04:23:00 Webster, Mississippi, US
2020-09-20 US Mississippi Wilkinson 28157 302 17 0 285 31.16078225 -91.31018819 2020-09-21 04:23:00 Wilkinson, Mississippi, US
2020-09-20 US Mississippi Winston 28159 724 19 0 705 33.08747908 -89.03391385 2020-09-21 04:23:00 Winston, Mississippi, US
2020-09-20 US Mississippi Yalobusha 28161 417 14 0 403 34.02824175 -89.7076205 2020-09-21 04:23:00 Yalobusha, Mississippi, US
2020-09-20 US Mississippi Yazoo 28163 1038 29 0 1009 32.77890365 -90.39656148 2020-09-21 04:23:00 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;