johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

83 rows where "day" is on date 2022-10-08 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

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
4004456 4004456 2022-10-08 US Mississippi Adams 28001 8279 149 0   31.47669768 -91.35326037 2022-10-09 04:21:16 Adams, Mississippi, US
4004457 4004457 2022-10-08 US Mississippi Alcorn 28003 11923 163 0   34.88084463 -88.57996173 2022-10-09 04:21:16 Alcorn, Mississippi, US
4004458 4004458 2022-10-08 US Mississippi Amite 28005 3691 70 0   31.17467303 -90.80501621 2022-10-09 04:21:16 Amite, Mississippi, US
4004459 4004459 2022-10-08 US Mississippi Attala 28007 6358 119 0   33.08658803 -89.57838564 2022-10-09 04:21:16 Attala, Mississippi, US
4004460 4004460 2022-10-08 US Mississippi Benton 28009 2619 50 0   34.81681228 -89.18945516 2022-10-09 04:21:16 Benton, Mississippi, US
4004461 4004461 2022-10-08 US Mississippi Bolivar 28011 10693 186 0   33.79696941 -90.87372121 2022-10-09 04:21:16 Bolivar, Mississippi, US
4004462 4004462 2022-10-08 US Mississippi Calhoun 28013 5320 76 0   33.93683395 -89.33686647 2022-10-09 04:21:16 Calhoun, Mississippi, US
4004463 4004463 2022-10-08 US Mississippi Carroll 28015 2929 58 0   33.44834567 -89.91994479 2022-10-09 04:21:16 Carroll, Mississippi, US
4004464 4004464 2022-10-08 US Mississippi Chickasaw 28017 6575 99 0   33.91983202 -88.9481545 2022-10-09 04:21:16 Chickasaw, Mississippi, US
4004465 4004465 2022-10-08 US Mississippi Choctaw 28019 2693 35 0   33.34598242 -89.24809382 2022-10-09 04:21:16 Choctaw, Mississippi, US
4004466 4004466 2022-10-08 US Mississippi Claiborne 28021 2471 48 0   31.97061673 -90.90702196 2022-10-09 04:21:16 Claiborne, Mississippi, US
4004467 4004467 2022-10-08 US Mississippi Clarke 28023 4678 112 0   32.04158545 -88.6889622 2022-10-09 04:21:16 Clarke, Mississippi, US
4004468 4004468 2022-10-08 US Mississippi Clay 28025 5770 100 0   33.65358105 -88.77784255 2022-10-09 04:21:16 Clay, Mississippi, US
4004469 4004469 2022-10-08 US Mississippi Coahoma 28027 7599 133 0   34.22772299 -90.60415045 2022-10-09 04:21:16 Coahoma, Mississippi, US
4004470 4004470 2022-10-08 US Mississippi Copiah 28029 8641 124 0   31.86977774 -90.44565118 2022-10-09 04:21:16 Copiah, Mississippi, US
4004471 4004471 2022-10-08 US Mississippi Covington 28031 8128 117 0   31.63225413 -89.55389939 2022-10-09 04:21:16 Covington, Mississippi, US
4004472 4004472 2022-10-08 US Mississippi DeSoto 28033 57614 569 0   34.87625235 -89.99091418 2022-10-09 04:21:16 DeSoto, Mississippi, US
4004473 4004473 2022-10-08 US Mississippi Forrest 28035 25877 318 0   31.18961454 -89.25832496 2022-10-09 04:21:16 Forrest, Mississippi, US
4004474 4004474 2022-10-08 US Mississippi Franklin 28037 2239 39 0   31.47786634 -90.89672989 2022-10-09 04:21:16 Franklin, Mississippi, US
4004475 4004475 2022-10-08 US Mississippi George 28039 8345 90 0   30.86259065 -88.64436789 2022-10-09 04:21:16 George, Mississippi, US
4004476 4004476 2022-10-08 US Mississippi Greene 28041 3689 60 0   31.21444233 -88.63922281 2022-10-09 04:21:16 Greene, Mississippi, US
4004477 4004477 2022-10-08 US Mississippi Grenada 28043 6140 135 0   33.77036166 -89.80245083 2022-10-09 04:21:16 Grenada, Mississippi, US
4004478 4004478 2022-10-08 US Mississippi Hancock 28045 14357 160 0   30.41830223 -89.48851033 2022-10-09 04:21:16 Hancock, Mississippi, US
4004479 4004479 2022-10-08 US Mississippi Harrison 28047 62612 698 0   30.51359752 -89.12467576 2022-10-09 04:21:16 Harrison, Mississippi, US
4004480 4004480 2022-10-08 US Mississippi Hinds 28049 63343 825 0   32.2656285 -90.44435448 2022-10-09 04:21:16 Hinds, Mississippi, US
4004481 4004481 2022-10-08 US Mississippi Holmes 28051 4980 105 0   33.12345854 -90.08923538 2022-10-09 04:21:16 Holmes, Mississippi, US
4004482 4004482 2022-10-08 US Mississippi Humphreys 28053 2243 47 0   33.12825718 -90.52252707 2022-10-09 04:21:16 Humphreys, Mississippi, US
4004483 4004483 2022-10-08 US Mississippi Issaquena 28055 289 9 0   32.72531359 -90.97392828 2022-10-09 04:21:16 Issaquena, Mississippi, US
4004484 4004484 2022-10-08 US Mississippi Itawamba 28057 8767 147 0   34.27993475 -88.3606733 2022-10-09 04:21:16 Itawamba, Mississippi, US
4004485 4004485 2022-10-08 US Mississippi Jackson 28059 43658 486 0   30.54020656 -88.64184064 2022-10-09 04:21:16 Jackson, Mississippi, US
4004486 4004486 2022-10-08 US Mississippi Jasper 28061 5804 78 0   32.01922104 -89.11786866 2022-10-09 04:21:16 Jasper, Mississippi, US
4004487 4004487 2022-10-08 US Mississippi Jefferson 28063 1736 38 0   31.73397872 -91.03764977 2022-10-09 04:21:16 Jefferson, Mississippi, US
4004488 4004488 2022-10-08 US Mississippi Jefferson Davis 28065 3387 56 0   31.56884708 -89.8267099 2022-10-09 04:21:16 Jefferson Davis, Mississippi, US
4004489 4004489 2022-10-08 US Mississippi Jones 28067 24850 306 0   31.62257767 -89.168969 2022-10-09 04:21:16 Jones, Mississippi, US
4004490 4004490 2022-10-08 US Mississippi Kemper 28069 2472 51 0   32.75462946 -88.64105766 2022-10-09 04:21:16 Kemper, Mississippi, US
4004491 4004491 2022-10-08 US Mississippi Lafayette 28071 17738 186 0   34.35687874 -89.48490961 2022-10-09 04:21:16 Lafayette, Mississippi, US
4004492 4004492 2022-10-08 US Mississippi Lamar 28073 20611 168 0   31.20572971 -89.5077704 2022-10-09 04:21:16 Lamar, Mississippi, US
4004493 4004493 2022-10-08 US Mississippi Lauderdale 28075 20958 378 0   32.40419769 -88.66229662 2022-10-09 04:21:16 Lauderdale, Mississippi, US
4004494 4004494 2022-10-08 US Mississippi Lawrence 28077 4212 57 0   31.55147224 -90.10841127 2022-10-09 04:21:16 Lawrence, Mississippi, US
4004495 4004495 2022-10-08 US Mississippi Leake 28079 7286 124 0   32.7536828 -89.52402044 2022-10-09 04:21:16 Leake, Mississippi, US
4004496 4004496 2022-10-08 US Mississippi Lee 28081 31558 314 0   34.2918775 -88.68149954 2022-10-09 04:21:16 Lee, Mississippi, US
4004497 4004497 2022-10-08 US Mississippi Leflore 28083 8346 181 0   33.55545125 -90.29900733 2022-10-09 04:21:16 Leflore, Mississippi, US
4004498 4004498 2022-10-08 US Mississippi Lincoln 28085 9896 163 0   31.53288662 -90.45391915 2022-10-09 04:21:16 Lincoln, Mississippi, US
4004499 4004499 2022-10-08 US Mississippi Lowndes 28087 20055 247 0   33.47386518 -88.4419153 2022-10-09 04:21:16 Lowndes, Mississippi, US
4004500 4004500 2022-10-08 US Mississippi Madison 28089 29329 345 0   32.63389156 -90.03513564 2022-10-09 04:21:16 Madison, Mississippi, US
4004501 4004501 2022-10-08 US Mississippi Marion 28091 8161 141 0   31.23132643 -89.8209217 2022-10-09 04:21:16 Marion, Mississippi, US
4004502 4004502 2022-10-08 US Mississippi Marshall 28093 11200 180 0   34.76216286 -89.50299462 2022-10-09 04:21:16 Marshall, Mississippi, US
4004503 4004503 2022-10-08 US Mississippi Monroe 28095 12661 225 0   33.89236763 -88.4808438 2022-10-09 04:21:16 Monroe, Mississippi, US
4004504 4004504 2022-10-08 US Mississippi Montgomery 28097 3446 82 0   33.49419589 -89.61729103 2022-10-09 04:21:16 Montgomery, Mississippi, US
4004505 4004505 2022-10-08 US Mississippi Neshoba 28099 12076 245 0   32.75339664 -89.11726492 2022-10-09 04:21:16 Neshoba, Mississippi, US
4004506 4004506 2022-10-08 US Mississippi Newton 28101 6751 101 0   32.40021118 -89.11843336 2022-10-09 04:21:16 Newton, Mississippi, US
4004507 4004507 2022-10-08 US Mississippi Noxubee 28103 3251 49 0   33.11009499 -88.56949061 2022-10-09 04:21:16 Noxubee, Mississippi, US
4004508 4004508 2022-10-08 US Mississippi Oktibbeha 28105 12904 168 0   33.42491685 -88.87905132 2022-10-09 04:21:16 Oktibbeha, Mississippi, US
4004509 4004509 2022-10-08 US Mississippi Panola 28107 11903 176 0   34.36398677 -89.95064249 2022-10-09 04:21:16 Panola, Mississippi, US
4004510 4004510 2022-10-08 US Mississippi Pearl River 28109 17152 283 0   30.77090935 -89.58677275 2022-10-09 04:21:16 Pearl River, Mississippi, US
4004511 4004511 2022-10-08 US Mississippi Perry 28111 3537 65 0   31.17161885 -88.99281835 2022-10-09 04:21:16 Perry, Mississippi, US
4004512 4004512 2022-10-08 US Mississippi Pike 28113 11882 192 0   31.17507789 -90.40392572 2022-10-09 04:21:16 Pike, Mississippi, US
4004513 4004513 2022-10-08 US Mississippi Pontotoc 28115 11929 154 0   34.226046 -89.03636807 2022-10-09 04:21:16 Pontotoc, Mississippi, US
4004514 4004514 2022-10-08 US Mississippi Prentiss 28117 9489 109 0   34.61810501 -88.51986294 2022-10-09 04:21:16 Prentiss, Mississippi, US
4004515 4004515 2022-10-08 US Mississippi Quitman 28119 1753 32 0   34.25157572 -90.28908 2022-10-09 04:21:16 Quitman, Mississippi, US
4004516 4004516 2022-10-08 US Mississippi Rankin 28121 43752 512 0   32.26469147 -89.94537876 2022-10-09 04:21:16 Rankin, Mississippi, US
4004517 4004517 2022-10-08 US Mississippi Scott 28123 7497 121 0   32.4067041 -89.53789439 2022-10-09 04:21:16 Scott, Mississippi, US
4004518 4004518 2022-10-08 US Mississippi Sharkey 28125 1094 27 0   32.88149103 -90.8159538 2022-10-09 04:21:16 Sharkey, Mississippi, US
4004519 4004519 2022-10-08 US Mississippi Simpson 28127 8172 157 0   31.91282117 -89.91716179 2022-10-09 04:21:16 Simpson, Mississippi, US
4004520 4004520 2022-10-08 US Mississippi Smith 28129 4744 69 0   32.01744532 -89.50644846 2022-10-09 04:21:16 Smith, Mississippi, US
4004521 4004521 2022-10-08 US Mississippi Stone 28131 6376 77 0   30.79187949 -89.11547539 2022-10-09 04:21:16 Stone, Mississippi, US
4004522 4004522 2022-10-08 US Mississippi Sunflower 28133 6464 128 0   33.60192578 -90.58882684 2022-10-09 04:21:16 Sunflower, Mississippi, US
4004523 4004523 2022-10-08 US Mississippi Tallahatchie 28135 3658 64 0   33.95339918 -90.1729398 2022-10-09 04:21:16 Tallahatchie, Mississippi, US
4004524 4004524 2022-10-08 US Mississippi Tate 28137 8382 151 0   34.65133709 -89.94485778 2022-10-09 04:21:16 Tate, Mississippi, US
4004525 4004525 2022-10-08 US Mississippi Tippah 28139 8408 113 0   34.76872156 -88.90988194 2022-10-09 04:21:16 Tippah, Mississippi, US
4004526 4004526 2022-10-08 US Mississippi Tishomingo 28141 7148 122 0   34.74023475 -88.23917219 2022-10-09 04:21:16 Tishomingo, Mississippi, US
4004527 4004527 2022-10-08 US Mississippi Tunica 28143 2871 48 0   34.64967704 -90.37481167 2022-10-09 04:21:16 Tunica, Mississippi, US
4004528 4004528 2022-10-08 US Mississippi Unassigned 90028 0 0 0   34.88084463 0.0 2022-10-09 04:21:16 Unassigned, Mississippi, US
4004529 4004529 2022-10-08 US Mississippi Union 28145 10889 128 0   34.49162015 -89.00776006 2022-10-09 04:21:16 Union, Mississippi, US
4004530 4004530 2022-10-08 US Mississippi Walthall 28147 4327 83 0   31.14971548 -90.10446654 2022-10-09 04:21:16 Walthall, Mississippi, US
4004531 4004531 2022-10-08 US Mississippi Warren 28149 12083 216 0   32.35810271 -90.83352619 2022-10-09 04:21:16 Warren, Mississippi, US
4004532 4004532 2022-10-08 US Mississippi Washington 28151 11754 207 0   33.28392041 -90.94196237 2022-10-09 04:21:16 Washington, Mississippi, US
4004533 4004533 2022-10-08 US Mississippi Wayne 28153 6674 88 0   31.64135687 -88.69573913 2022-10-09 04:21:16 Wayne, Mississippi, US
4004534 4004534 2022-10-08 US Mississippi Webster 28155 3799 73 0   33.61300486 -89.28392912 2022-10-09 04:21:16 Webster, Mississippi, US
4004535 4004535 2022-10-08 US Mississippi Wilkinson 28157 1901 46 0   31.16078225 -91.31018819 2022-10-09 04:21:16 Wilkinson, Mississippi, US
4004536 4004536 2022-10-08 US Mississippi Winston 28159 6173 104 0   33.08747908 -89.03391385 2022-10-09 04:21:16 Winston, Mississippi, US
4004537 4004537 2022-10-08 US Mississippi Yalobusha 28161 4628 61 0   34.02824175 -89.7076205 2022-10-09 04:21:16 Yalobusha, Mississippi, US
4004538 4004538 2022-10-08 US Mississippi Yazoo 28163 9432 112 0   32.77890365 -90.39656148 2022-10-09 04:21:16 Yazoo, Mississippi, US

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] TEXT,
   [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]);