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 country_or_region = "US", "last_update" is on date 2020-12-27 and province_or_state = "Mississippi" sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-12-26 US Mississippi Adams 28001 1745 57 0 1688 31.47669768 -91.35326037 2020-12-27 05:22:55 Adams, Mississippi, US
2020-12-26 US Mississippi Alcorn 28003 2046 39 0 2007 34.88084463 -88.57996173 2020-12-27 05:22:55 Alcorn, Mississippi, US
2020-12-26 US Mississippi Amite 28005 819 20 0 799 31.17467303 -90.80501621 2020-12-27 05:22:55 Amite, Mississippi, US
2020-12-26 US Mississippi Attala 28007 1652 44 0 1608 33.08658803 -89.57838564 2020-12-27 05:22:55 Attala, Mississippi, US
2020-12-26 US Mississippi Benton 28009 642 20 0 622 34.81681228 -89.18945516 2020-12-27 05:22:55 Benton, Mississippi, US
2020-12-26 US Mississippi Bolivar 28011 3235 95 0 3140 33.79696941 -90.87372121 2020-12-27 05:22:55 Bolivar, Mississippi, US
2020-12-26 US Mississippi Calhoun 28013 1096 16 0 1080 33.93683395 -89.33686647 2020-12-27 05:22:55 Calhoun, Mississippi, US
2020-12-26 US Mississippi Carroll 28015 910 17 0 893 33.44834567 -89.91994479 2020-12-27 05:22:55 Carroll, Mississippi, US
2020-12-26 US Mississippi Chickasaw 28017 1521 35 0 1486 33.91983202 -88.9481545 2020-12-27 05:22:55 Chickasaw, Mississippi, US
2020-12-26 US Mississippi Choctaw 28019 479 10 0 469 33.34598242 -89.24809382 2020-12-27 05:22:55 Choctaw, Mississippi, US
2020-12-26 US Mississippi Claiborne 28021 690 18 0 672 31.97061673 -90.90702196 2020-12-27 05:22:55 Claiborne, Mississippi, US
2020-12-26 US Mississippi Clarke 28023 1151 57 0 1094 32.04158545 -88.68896219999998 2020-12-27 05:22:55 Clarke, Mississippi, US
2020-12-26 US Mississippi Clay 28025 1254 30 0 1224 33.65358105 -88.77784255 2020-12-27 05:22:55 Clay, Mississippi, US
2020-12-26 US Mississippi Coahoma 28027 1897 51 0 1846 34.22772299 -90.60415045 2020-12-27 05:22:55 Coahoma, Mississippi, US
2020-12-26 US Mississippi Copiah 28029 2121 43 0 2078 31.86977774 -90.44565118 2020-12-27 05:22:55 Copiah, Mississippi, US
2020-12-26 US Mississippi Covington 28031 1758 66 0 1692 31.63225413 -89.55389939 2020-12-27 05:22:55 Covington, Mississippi, US
2020-12-26 US Mississippi DeSoto 28033 13932 132 0 13800 34.87625235 -89.99091418 2020-12-27 05:22:55 DeSoto, Mississippi, US
2020-12-26 US Mississippi Forrest 28035 5026 95 0 4931 31.18961454 -89.25832496 2020-12-27 05:22:55 Forrest, Mississippi, US
2020-12-26 US Mississippi Franklin 28037 557 7 0 550 31.47786634 -90.89672989 2020-12-27 05:22:55 Franklin, Mississippi, US
2020-12-26 US Mississippi George 28039 1666 34 0 1632 30.86259065 -88.64436789 2020-12-27 05:22:55 George, Mississippi, US
2020-12-26 US Mississippi Greene 28041 955 25 0 930 31.21444233 -88.63922281 2020-12-27 05:22:55 Greene, Mississippi, US
2020-12-26 US Mississippi Grenada 28043 1910 60 0 1850 33.77036166 -89.80245083 2020-12-27 05:22:55 Grenada, Mississippi, US
2020-12-26 US Mississippi Hancock 28045 1882 53 0 1829 30.41830223 -89.48851033 2020-12-27 05:22:55 Hancock, Mississippi, US
2020-12-26 US Mississippi Harrison 28047 10133 139 0 9994 30.51359752 -89.12467576 2020-12-27 05:22:55 Harrison, Mississippi, US
2020-12-26 US Mississippi Hinds 28049 13403 248 0 13155 32.2656285 -90.44435448 2020-12-27 05:22:55 Hinds, Mississippi, US
2020-12-26 US Mississippi Holmes 28051 1545 64 0 1481 33.12345854 -90.08923538 2020-12-27 05:22:55 Holmes, Mississippi, US
2020-12-26 US Mississippi Humphreys 28053 702 22 0 680 33.12825718 -90.52252707 2020-12-27 05:22:55 Humphreys, Mississippi, US
2020-12-26 US Mississippi Issaquena 28055 145 4 0 141 32.72531359 -90.97392828 2020-12-27 05:22:55 Issaquena, Mississippi, US
2020-12-26 US Mississippi Itawamba 28057 2162 49 0 2113 34.27993475 -88.3606733 2020-12-27 05:22:55 Itawamba, Mississippi, US
2020-12-26 US Mississippi Jackson 28059 8367 151 0 8216 30.54020656 -88.64184064 2020-12-27 05:22:55 Jackson, Mississippi, US
2020-12-26 US Mississippi Jasper 28061 1306 25 0 1281 32.01922104 -89.11786866 2020-12-27 05:22:55 Jasper, Mississippi, US
2020-12-26 US Mississippi Jefferson 28063 458 14 0 444 31.73397872 -91.03764977 2020-12-27 05:22:55 Jefferson, Mississippi, US
2020-12-26 US Mississippi Jefferson Davis 28065 733 22 0 711 31.56884708 -89.82670990000003 2020-12-27 05:22:55 Jefferson Davis, Mississippi, US
2020-12-26 US Mississippi Jones 28067 4947 95 0 4852 31.62257767 -89.16896899999998 2020-12-27 05:22:55 Jones, Mississippi, US
2020-12-26 US Mississippi Kemper 28069 639 19 0 620 32.75462946 -88.64105766 2020-12-27 05:22:55 Kemper, Mississippi, US
2020-12-26 US Mississippi Lafayette 28071 4071 76 0 3995 34.35687874 -89.48490961 2020-12-27 05:22:55 Lafayette, Mississippi, US
2020-12-26 US Mississippi Lamar 28073 3909 56 0 3853 31.20572971 -89.5077704 2020-12-27 05:22:55 Lamar, Mississippi, US
2020-12-26 US Mississippi Lauderdale 28075 4695 168 0 4527 32.40419769 -88.66229662 2020-12-27 05:22:55 Lauderdale, Mississippi, US
2020-12-26 US Mississippi Lawrence 28077 902 16 0 886 31.55147224 -90.10841127 2020-12-27 05:22:55 Lawrence, Mississippi, US
2020-12-26 US Mississippi Leake 28079 1930 49 0 1881 32.7536828 -89.52402044 2020-12-27 05:22:55 Leake, Mississippi, US
2020-12-26 US Mississippi Lee 28081 7246 111 0 7135 34.291877500000005 -88.68149954 2020-12-27 05:22:55 Lee, Mississippi, US
2020-12-26 US Mississippi Leflore 28083 2527 98 0 2429 33.55545125 -90.29900733 2020-12-27 05:22:55 Leflore, Mississippi, US
2020-12-26 US Mississippi Lincoln 28085 2434 74 0 2360 31.53288662 -90.45391915 2020-12-27 05:22:55 Lincoln, Mississippi, US
2020-12-26 US Mississippi Lowndes 28087 4094 85 0 4009 33.47386518 -88.44191529999998 2020-12-27 05:22:55 Lowndes, Mississippi, US
2020-12-26 US Mississippi Madison 28089 6815 128 0 6687 32.63389156 -90.03513564 2020-12-27 05:22:55 Madison, Mississippi, US
2020-12-26 US Mississippi Marion 28091 1691 59 0 1632 31.23132643 -89.8209217 2020-12-27 05:22:55 Marion, Mississippi, US
2020-12-26 US Mississippi Marshall 28093 2813 63 0 2750 34.76216286 -89.50299462 2020-12-27 05:22:55 Marshall, Mississippi, US
2020-12-26 US Mississippi Monroe 28095 2821 84 0 2737 33.89236763 -88.4808438 2020-12-27 05:22:55 Monroe, Mississippi, US
2020-12-26 US Mississippi Montgomery 28097 951 30 0 921 33.49419589 -89.61729103 2020-12-27 05:22:55 Montgomery, Mississippi, US
2020-12-26 US Mississippi Neshoba 28099 2873 137 0 2736 32.75339664 -89.11726492 2020-12-27 05:22:55 Neshoba, Mississippi, US
2020-12-26 US Mississippi Newton 28101 1527 32 0 1495 32.40021118 -89.11843336 2020-12-27 05:22:55 Newton, Mississippi, US
2020-12-26 US Mississippi Noxubee 28103 893 20 0 873 33.11009499 -88.56949061 2020-12-27 05:22:55 Noxubee, Mississippi, US
2020-12-26 US Mississippi Oktibbeha 28105 3221 70 0 3151 33.42491685 -88.87905132 2020-12-27 05:22:55 Oktibbeha, Mississippi, US
2020-12-26 US Mississippi Panola 28107 3027 68 0 2959 34.36398677 -89.95064249 2020-12-27 05:22:55 Panola, Mississippi, US
2020-12-26 US Mississippi Pearl River 28109 2394 79 0 2315 30.77090935 -89.58677275 2020-12-27 05:22:55 Pearl River, Mississippi, US
2020-12-26 US Mississippi Perry 28111 827 30 0 797 31.17161885 -88.99281835 2020-12-27 05:22:55 Perry, Mississippi, US
2020-12-26 US Mississippi Pike 28113 2106 65 0 2041 31.17507789 -90.40392572 2020-12-27 05:22:55 Pike, Mississippi, US
2020-12-26 US Mississippi Pontotoc 28115 2991 38 0 2953 34.226046000000004 -89.03636807 2020-12-27 05:22:55 Pontotoc, Mississippi, US
2020-12-26 US Mississippi Prentiss 28117 1987 41 0 1946 34.61810501 -88.51986294 2020-12-27 05:22:55 Prentiss, Mississippi, US
2020-12-26 US Mississippi Quitman 28119 588 7 0 581 34.25157572 -90.28908 2020-12-27 05:22:55 Quitman, Mississippi, US
2020-12-26 US Mississippi Rankin 28121 8284 156 0 8128 32.26469147 -89.94537876 2020-12-27 05:22:55 Rankin, Mississippi, US
2020-12-26 US Mississippi Scott 28123 2039 38 0 2001 32.406704100000006 -89.53789439 2020-12-27 05:22:55 Scott, Mississippi, US
2020-12-26 US Mississippi Sharkey 28125 378 17 0 361 32.88149103 -90.8159538 2020-12-27 05:22:55 Sharkey, Mississippi, US
2020-12-26 US Mississippi Simpson 28127 1904 60 0 1844 31.91282117 -89.91716179 2020-12-27 05:22:55 Simpson, Mississippi, US
2020-12-26 US Mississippi Smith 28129 971 18 0 953 32.01744532 -89.50644846 2020-12-27 05:22:55 Smith, Mississippi, US
2020-12-26 US Mississippi Stone 28131 1109 18 0 1091 30.79187949 -89.11547539 2020-12-27 05:22:55 Stone, Mississippi, US
2020-12-26 US Mississippi Sunflower 28133 2315 59 0 2256 33.60192578 -90.58882684 2020-12-27 05:22:55 Sunflower, Mississippi, US
2020-12-26 US Mississippi Tallahatchie 28135 1170 29 0 1141 33.95339918 -90.1729398 2020-12-27 05:22:55 Tallahatchie, Mississippi, US
2020-12-26 US Mississippi Tate 28137 2303 56 0 2247 34.65133709 -89.94485778 2020-12-27 05:22:55 Tate, Mississippi, US
2020-12-26 US Mississippi Tippah 28139 1871 40 0 1831 34.76872156 -88.90988194 2020-12-27 05:22:55 Tippah, Mississippi, US
2020-12-26 US Mississippi Tishomingo 28141 1498 51 0 1447 34.74023475 -88.23917219 2020-12-27 05:22:55 Tishomingo, Mississippi, US
2020-12-26 US Mississippi Tunica 28143 719 19 0 700 34.64967704 -90.37481167 2020-12-27 05:22:55 Tunica, Mississippi, US
2020-12-26 US Mississippi Unassigned 90028 0 0 0 0 34.88084463 0.0 2020-12-27 05:22:55 Unassigned, Mississippi, US
2020-12-26 US Mississippi Union 28145 2629 34 0 2595 34.49162015 -89.00776006 2020-12-27 05:22:55 Union, Mississippi, US
2020-12-26 US Mississippi Walthall 28147 951 33 0 918 31.14971548 -90.10446654 2020-12-27 05:22:55 Walthall, Mississippi, US
2020-12-26 US Mississippi Warren 28149 2487 75 0 2412 32.35810271 -90.83352619 2020-12-27 05:22:55 Warren, Mississippi, US
2020-12-26 US Mississippi Washington 28151 4075 112 0 3963 33.28392041 -90.94196237 2020-12-27 05:22:55 Washington, Mississippi, US
2020-12-26 US Mississippi Wayne 28153 1586 25 0 1561 31.64135687 -88.69573913 2020-12-27 05:22:55 Wayne, Mississippi, US
2020-12-26 US Mississippi Webster 28155 697 18 0 679 33.61300486 -89.28392912 2020-12-27 05:22:55 Webster, Mississippi, US
2020-12-26 US Mississippi Wilkinson 28157 511 22 0 489 31.16078225 -91.31018819 2020-12-27 05:22:55 Wilkinson, Mississippi, US
2020-12-26 US Mississippi Winston 28159 1753 44 0 1709 33.08747908 -89.03391385 2020-12-27 05:22:55 Winston, Mississippi, US
2020-12-26 US Mississippi Yalobusha 28161 944 31 0 913 34.02824175 -89.70762049999998 2020-12-27 05:22:55 Yalobusha, Mississippi, US
2020-12-26 US Mississippi Yazoo 28163 2012 50 0 1962 32.77890365 -90.39656148 2020-12-27 05:22:55 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;