johns_hopkins_csse_daily_reports

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

12,155 rows where province_or_state = "Michigan" sorted by day descending

View and edit SQL

Suggested facets: day (date)

province_or_state

  • Michigan · 12,155

country_or_region

  • US 12,155
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
135644 2020-08-12 US Michigan Alcona 26001 29 1 0 28 44.6846864 -83.59507875 2020-08-13 04:29:15 Alcona, Michigan, US
135645 2020-08-12 US Michigan Alger 26003 15 0 0 15 46.41292944 -86.60260122 2020-08-13 04:29:15 Alger, Michigan, US
135646 2020-08-12 US Michigan Allegan 26005 542 6 0 536 42.59147037 -85.89102866 2020-08-13 04:29:15 Allegan, Michigan, US
135647 2020-08-12 US Michigan Alpena 26007 130 13 0 117 45.03477666 -83.62212411 2020-08-13 04:29:15 Alpena, Michigan, US
135648 2020-08-12 US Michigan Antrim 26009 41 0 0 41 44.99690221 -85.15503082 2020-08-13 04:29:15 Antrim, Michigan, US
135649 2020-08-12 US Michigan Arenac 26011 43 3 0 40 44.0636262 -83.89277559 2020-08-13 04:29:15 Arenac, Michigan, US
135650 2020-08-12 US Michigan Baraga 26013 5 0 0 5 46.6720582 -88.36363591 2020-08-13 04:29:15 Baraga, Michigan, US
135651 2020-08-12 US Michigan Barry 26015 191 2 0 189 42.59513984 -85.30834519 2020-08-13 04:29:15 Barry, Michigan, US
135652 2020-08-12 US Michigan Bay 26017 654 32 0 622 43.70639106 -83.98731479 2020-08-13 04:29:15 Bay, Michigan, US
135653 2020-08-12 US Michigan Benzie 26019 30 1 0 29 44.63899297 -86.01608482 2020-08-13 04:29:15 Benzie, Michigan, US
135654 2020-08-12 US Michigan Berrien 26021 1387 67 0 1320 41.95447397 -86.41313079999998 2020-08-13 04:29:15 Berrien, Michigan, US
135655 2020-08-12 US Michigan Branch 26023 367 2 0 365 41.91600556 -85.05929476 2020-08-13 04:29:15 Branch, Michigan, US
135656 2020-08-12 US Michigan Calhoun 26025 811 42 0 769 42.24633834 -85.00493569 2020-08-13 04:29:15 Calhoun, Michigan, US
135657 2020-08-12 US Michigan Cass 26027 340 14 0 326 41.91522292 -85.99405727 2020-08-13 04:29:15 Cass, Michigan, US
135658 2020-08-12 US Michigan Charlevoix 26029 50 2 0 48 45.37790017 -85.19614053 2020-08-13 04:29:15 Charlevoix, Michigan, US
135659 2020-08-12 US Michigan Cheboygan 26031 50 2 0 48 45.44787015 -84.50122149 2020-08-13 04:29:15 Cheboygan, Michigan, US
135660 2020-08-12 US Michigan Chippewa 26033 43 0 0 43 46.29552653 -84.54353449 2020-08-13 04:29:15 Chippewa, Michigan, US
135661 2020-08-12 US Michigan Clare 26035 74 3 0 71 43.98794227 -84.84819859999998 2020-08-13 04:29:15 Clare, Michigan, US
135662 2020-08-12 US Michigan Clinton 26037 426 13 0 413 42.94400871 -84.60145248 2020-08-13 04:29:15 Clinton, Michigan, US
135663 2020-08-12 US Michigan Crawford 26039 107 5 0 102 44.68255561 -84.61006219 2020-08-13 04:29:15 Crawford, Michigan, US
135664 2020-08-12 US Michigan Delta 26041 104 3 0 101 45.90484910000001 -86.9080745 2020-08-13 04:29:15 Delta, Michigan, US
135665 2020-08-12 US Michigan Dickinson 26043 58 2 0 56 46.00999672 -87.86961634 2020-08-13 04:29:15 Dickinson, Michigan, US
135666 2020-08-12 US Michigan Eaton 26045 461 8 0 453 42.59599185 -84.83740035 2020-08-13 04:29:15 Eaton, Michigan, US
135667 2020-08-12 US Michigan Emmet 26047 65 2 0 63 45.52625509 -84.89083249 2020-08-13 04:29:15 Emmet, Michigan, US
135668 2020-08-12 US Michigan Federal Correctional Institution (FCI)   194 5 0 189 47.63197653 0.0 2020-08-13 04:29:15 Federal Correctional Institution (FCI), Michigan, US
135669 2020-08-12 US Michigan Genesee 26049 3683 296 0 3387 43.02244215 -83.70589709 2020-08-13 04:29:15 Genesee, Michigan, US
135670 2020-08-12 US Michigan Gladwin 26051 59 2 0 57 43.98901072 -84.38774817 2020-08-13 04:29:15 Gladwin, Michigan, US
135671 2020-08-12 US Michigan Gogebic 26053 125 1 0 124 46.40862701 -89.69377193 2020-08-13 04:29:15 Gogebic, Michigan, US
135672 2020-08-12 US Michigan Grand Traverse 26055 220 5 0 215 44.69565625 -85.55585247 2020-08-13 04:29:15 Grand Traverse, Michigan, US
135673 2020-08-12 US Michigan Gratiot 26057 157 15 0 142 43.29265605 -84.60505416 2020-08-13 04:29:15 Gratiot, Michigan, US
135674 2020-08-12 US Michigan Hillsdale 26059 278 25 0 253 41.88753639 -84.59312019 2020-08-13 04:29:15 Hillsdale, Michigan, US
135675 2020-08-12 US Michigan Houghton 26061 50 0 0 50 46.89988536 -88.68495385 2020-08-13 04:29:15 Houghton, Michigan, US
135676 2020-08-12 US Michigan Huron 26063 161 4 0 157 43.83353985 -83.04078453 2020-08-13 04:29:15 Huron, Michigan, US
135677 2020-08-12 US Michigan Ingham 26065 1570 32 0 1538 42.59716886 -84.37472069 2020-08-13 04:29:15 Ingham, Michigan, US
135678 2020-08-12 US Michigan Ionia 26067 274 7 0 267 42.94502238 -85.07413319 2020-08-13 04:29:15 Ionia, Michigan, US
135679 2020-08-12 US Michigan Iosco 26069 134 12 0 122 44.35486835 -83.63484895 2020-08-13 04:29:15 Iosco, Michigan, US
135680 2020-08-12 US Michigan Iron 26071 20 1 0 19 46.20974132 -88.53136251 2020-08-13 04:29:15 Iron, Michigan, US
135681 2020-08-12 US Michigan Isabella 26073 210 9 0 201 43.64060976 -84.84664923 2020-08-13 04:29:15 Isabella, Michigan, US
135682 2020-08-12 US Michigan Jackson 26075 722 34 0 688 42.24807035 -84.42258681 2020-08-13 04:29:15 Jackson, Michigan, US
135683 2020-08-12 US Michigan Kalamazoo 26077 1686 83 0 1603 42.24542231 -85.53038622 2020-08-13 04:29:15 Kalamazoo, Michigan, US
135684 2020-08-12 US Michigan Kalkaska 26079 54 4 0 50 44.68512729 -85.09085699 2020-08-13 04:29:15 Kalkaska, Michigan, US
135685 2020-08-12 US Michigan Kent 26081 7629 157 0 7472 43.03197711 -85.54934642 2020-08-13 04:29:15 Kent, Michigan, US
135686 2020-08-12 US Michigan Keweenaw 26083 3 0 0 3 47.63197653 -88.41434263 2020-08-13 04:29:15 Keweenaw, Michigan, US
135687 2020-08-12 US Michigan Lake 26085 26 0 0 26 43.99050893 -85.802173 2020-08-13 04:29:15 Lake, Michigan, US
135688 2020-08-12 US Michigan Lapeer 26087 472 33 0 439 43.09052506 -83.22153148 2020-08-13 04:29:15 Lapeer, Michigan, US
135689 2020-08-12 US Michigan Leelanau 26089 73 0 0 73 44.94430054 -85.80150326 2020-08-13 04:29:15 Leelanau, Michigan, US
135690 2020-08-12 US Michigan Lenawee 26091 440 12 0 428 41.89475156 -84.06603727 2020-08-13 04:29:15 Lenawee, Michigan, US
135691 2020-08-12 US Michigan Livingston 26093 850 28 0 822 42.60302282 -83.91297209 2020-08-13 04:29:15 Livingston, Michigan, US
135692 2020-08-12 US Michigan Luce 26095 4 0 0 4 46.47227431 -85.54471223 2020-08-13 04:29:15 Luce, Michigan, US
135693 2020-08-12 US Michigan Mackinac 26097 26 0 0 26 46.07028979 -85.04980537 2020-08-13 04:29:15 Mackinac, Michigan, US
135694 2020-08-12 US Michigan Macomb 26099 10794 949 0 9845 42.69158356 -82.92752801 2020-08-13 04:29:15 Macomb, Michigan, US
135695 2020-08-12 US Michigan Manistee 26101 40 0 0 40 44.33352407 -86.05626916 2020-08-13 04:29:15 Manistee, Michigan, US
135696 2020-08-12 US Michigan Marquette 26103 172 11 0 161 46.4338914 -87.64043701 2020-08-13 04:29:15 Marquette, Michigan, US
135697 2020-08-12 US Michigan Mason 26105 103 0 0 103 43.99509218 -86.24988902 2020-08-13 04:29:15 Mason, Michigan, US
135698 2020-08-12 US Michigan Mecosta 26107 69 2 0 67 43.64064262 -85.32463223 2020-08-13 04:29:15 Mecosta, Michigan, US
135699 2020-08-12 US Michigan Menominee 26109 150 0 0 150 45.58038692 -87.55370409 2020-08-13 04:29:15 Menominee, Michigan, US
135700 2020-08-12 US Michigan Michigan Department of Corrections (MDOC)   4598 69 0 4529 47.63197653 0.0 2020-08-13 04:29:15 Michigan Department of Corrections (MDOC), Michigan, US
135701 2020-08-12 US Michigan Midland 26111 344 10 0 334 43.64330771 -84.38804374 2020-08-13 04:29:15 Midland, Michigan, US
135702 2020-08-12 US Michigan Missaukee 26113 41 1 0 40 44.33772443 -85.09256478 2020-08-13 04:29:15 Missaukee, Michigan, US
135703 2020-08-12 US Michigan Monroe 26115 1016 25 0 991 41.92734151 -83.53749864 2020-08-13 04:29:15 Monroe, Michigan, US
135704 2020-08-12 US Michigan Montcalm 26117 193 1 0 192 43.31082541 -85.15252824 2020-08-13 04:29:15 Montcalm, Michigan, US
135705 2020-08-12 US Michigan Montmorency 26119 8 0 0 8 45.0275929 -84.12696227 2020-08-13 04:29:15 Montmorency, Michigan, US
135706 2020-08-12 US Michigan Muskegon 26121 1195 59 0 1136 43.29123859 -86.15176712 2020-08-13 04:29:15 Muskegon, Michigan, US
135707 2020-08-12 US Michigan Newaygo 26123 254 0 0 254 43.554374 -85.80070107 2020-08-13 04:29:15 Newaygo, Michigan, US
135708 2020-08-12 US Michigan Oakland 26125 15876 1133 0 14743 42.66090111 -83.38595416 2020-08-13 04:29:15 Oakland, Michigan, US
135709 2020-08-12 US Michigan Oceana 26127 479 6 0 473 43.64124435 -86.26726673 2020-08-13 04:29:15 Oceana, Michigan, US
135710 2020-08-12 US Michigan Ogemaw 26129 54 3 0 51 44.33481032 -84.12725175 2020-08-13 04:29:15 Ogemaw, Michigan, US
135711 2020-08-12 US Michigan Ontonagon 26131 18 0 0 18 46.665226200000006 -89.31390481 2020-08-13 04:29:15 Ontonagon, Michigan, US
135712 2020-08-12 US Michigan Osceola 26133 71 0 0 71 43.98992088 -85.32566756 2020-08-13 04:29:15 Osceola, Michigan, US
135713 2020-08-12 US Michigan Oscoda 26135 24 1 0 23 44.68192279 -84.12939244 2020-08-13 04:29:15 Oscoda, Michigan, US
135714 2020-08-12 US Michigan Otsego 26137 135 11 0 124 45.02085831 -84.59898295 2020-08-13 04:29:15 Otsego, Michigan, US
135715 2020-08-12 US Michigan Ottawa 26139 1856 57 0 1799 42.95996803 -85.9969107 2020-08-13 04:29:15 Ottawa, Michigan, US
135716 2020-08-12 US Michigan Out of MI 80026 102 1 0 101 47.63197653 0.0 2020-08-13 04:29:15 Out of MI, Michigan, US
135717 2020-08-12 US Michigan Presque Isle 26141 20 1 0 19 45.34018577 -83.91498656 2020-08-13 04:29:15 Presque Isle, Michigan, US
135718 2020-08-12 US Michigan Roscommon 26143 55 2 0 53 44.33473082 -84.61067651 2020-08-13 04:29:15 Roscommon, Michigan, US
135719 2020-08-12 US Michigan Saginaw 26145 2071 128 0 1943 43.33433923 -84.05131209999998 2020-08-13 04:29:15 Saginaw, Michigan, US
135720 2020-08-12 US Michigan Sanilac 26151 109 6 0 103 43.42406072 -82.82055898 2020-08-13 04:29:15 Sanilac, Michigan, US
135721 2020-08-12 US Michigan Schoolcraft 26153 13 0 0 13 46.19235734 -86.19972234 2020-08-13 04:29:15 Schoolcraft, Michigan, US
135722 2020-08-12 US Michigan Shiawassee 26155 348 28 0 320 42.95392800000001 -84.14585902 2020-08-13 04:29:15 Shiawassee, Michigan, US
135723 2020-08-12 US Michigan St. Clair 26147 829 53 0 776 42.92655373 -82.67937954 2020-08-13 04:29:15 St. Clair, Michigan, US
135724 2020-08-12 US Michigan St. Joseph 26149 603 9 0 594 41.91441767 -85.52797979 2020-08-13 04:29:15 St. Joseph, Michigan, US
135725 2020-08-12 US Michigan Tuscola 26157 362 29 0 333 43.46606813 -83.41897025 2020-08-13 04:29:15 Tuscola, Michigan, US
135726 2020-08-12 US Michigan Unassigned 90026 9 1 0 8 47.63197653 0.0 2020-08-13 04:29:15 Unassigned, Michigan, US
135727 2020-08-12 US Michigan Van Buren 26159 461 10 0 451 42.25190229 -86.01939087 2020-08-13 04:29:15 Van Buren, Michigan, US
135728 2020-08-12 US Michigan Washtenaw 26161 2613 113 0 2500 42.253105 -83.83853204 2020-08-13 04:29:15 Washtenaw, Michigan, US
135729 2020-08-12 US Michigan Wayne 26163 28391 2828 0 25563 42.28098405 -83.281255 2020-08-13 04:29:15 Wayne, Michigan, US
135730 2020-08-12 US Michigan Wexford 26165 70 4 0 66 44.33853602 -85.57712739 2020-08-13 04:29:15 Wexford, Michigan, US
502014 2020-08-11 US Michigan Alcona 26001 29 1 0 28 44.6846864 -83.59507875 2020-08-12 04:27:29 Alcona, Michigan, US
502015 2020-08-11 US Michigan Alger 26003 12 0 0 12 46.41292944 -86.60260122 2020-08-12 04:27:29 Alger, Michigan, US
502016 2020-08-11 US Michigan Allegan 26005 532 6 0 526 42.59147037 -85.89102866 2020-08-12 04:27:29 Allegan, Michigan, US
502017 2020-08-11 US Michigan Alpena 26007 130 13 0 117 45.03477666 -83.62212411 2020-08-12 04:27:29 Alpena, Michigan, US
502018 2020-08-11 US Michigan Antrim 26009 41 0 0 41 44.99690221 -85.15503082 2020-08-12 04:27:29 Antrim, Michigan, US
502019 2020-08-11 US Michigan Arenac 26011 43 3 0 40 44.0636262 -83.89277559 2020-08-12 04:27:29 Arenac, Michigan, US
502020 2020-08-11 US Michigan Baraga 26013 5 0 0 5 46.6720582 -88.36363591 2020-08-12 04:27:29 Baraga, Michigan, US
502021 2020-08-11 US Michigan Barry 26015 194 2 0 192 42.59513984 -85.30834519 2020-08-12 04:27:29 Barry, Michigan, US
502022 2020-08-11 US Michigan Bay 26017 650 31 0 619 43.70639106 -83.98731479 2020-08-12 04:27:29 Bay, Michigan, US
502023 2020-08-11 US Michigan Benzie 26019 30 1 0 29 44.63899297 -86.01608482 2020-08-12 04:27:29 Benzie, Michigan, US
502024 2020-08-11 US Michigan Berrien 26021 1381 67 0 1314 41.95447397 -86.41313079999998 2020-08-12 04:27:29 Berrien, Michigan, US
502025 2020-08-11 US Michigan Branch 26023 366 2 0 364 41.91600556 -85.05929476 2020-08-12 04:27:29 Branch, Michigan, US
502026 2020-08-11 US Michigan Calhoun 26025 802 42 0 760 42.24633834 -85.00493569 2020-08-12 04:27:29 Calhoun, Michigan, US

Next page

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] INTEGER,
   [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]);
Powered by Datasette · Query took 2001.518ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette