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

87,758 rows where province_or_state = "Michigan" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Michigan · 87,758 ✖

country_or_region 1

  • US 87,758
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-29 US Michigan Alcona 26001 1896 77 0   44.6846864 -83.59507875 2022-12-30 04:21:04 Alcona, Michigan, US
2022-12-29 US Michigan Alger 26003 2081 18 0   46.41292944 -86.60260122 2022-12-30 04:21:04 Alger, Michigan, US
2022-12-29 US Michigan Allegan 26005 31656 391 0   42.59147037 -85.89102866 2022-12-30 04:21:04 Allegan, Michigan, US
2022-12-29 US Michigan Alpena 26007 6388 154 0   45.03477666 -83.62212411 2022-12-30 04:21:04 Alpena, Michigan, US
2022-12-29 US Michigan Antrim 26009 5182 76 0   44.99690221 -85.15503082 2022-12-30 04:21:04 Antrim, Michigan, US
2022-12-29 US Michigan Arenac 26011 3830 82 0   44.0636262 -83.89277559 2022-12-30 04:21:04 Arenac, Michigan, US
2022-12-29 US Michigan Baraga 26013 2536 58 0   46.6720582 -88.36363591 2022-12-30 04:21:04 Baraga, Michigan, US
2022-12-29 US Michigan Barry 26015 16611 188 0   42.59513984 -85.30834519 2022-12-30 04:21:04 Barry, Michigan, US
2022-12-29 US Michigan Bay 26017 31252 663 0   43.70639106 -83.98731479 2022-12-30 04:21:04 Bay, Michigan, US
2022-12-29 US Michigan Benzie 26019 4064 77 0   44.63899297 -86.01608482 2022-12-30 04:21:04 Benzie, Michigan, US
2022-12-29 US Michigan Berrien 26021 41231 670 0   41.95447397 -86.4131308 2022-12-30 04:21:04 Berrien, Michigan, US
2022-12-29 US Michigan Branch 26023 13166 204 0   41.91600556 -85.05929476 2022-12-30 04:21:04 Branch, Michigan, US
2022-12-29 US Michigan Calhoun 26025 41806 657 0   42.24633834 -85.00493569 2022-12-30 04:21:04 Calhoun, Michigan, US
2022-12-29 US Michigan Cass 26027 12882 166 0   41.91522292 -85.99405727 2022-12-30 04:21:04 Cass, Michigan, US
2022-12-29 US Michigan Charlevoix 26029 5783 68 0   45.37790017 -85.19614053 2022-12-30 04:21:04 Charlevoix, Michigan, US
2022-12-29 US Michigan Cheboygan 26031 5667 128 0   45.44787015 -84.50122149 2022-12-30 04:21:04 Cheboygan, Michigan, US
2022-12-29 US Michigan Chippewa 26033 10056 117 0   46.29552653 -84.54353449 2022-12-30 04:21:04 Chippewa, Michigan, US
2022-12-29 US Michigan Clare 26035 8004 178 0   43.98794227 -84.8481986 2022-12-30 04:21:04 Clare, Michigan, US
2022-12-29 US Michigan Clinton 26037 27396 230 0   42.94400871 -84.60145248 2022-12-30 04:21:04 Clinton, Michigan, US
2022-12-29 US Michigan Crawford 26039 3143 37 0   44.68255561 -84.61006219 2022-12-30 04:21:04 Crawford, Michigan, US
2022-12-29 US Michigan Delta 26041 12193 180 0   45.9048491 -86.9080745 2022-12-30 04:21:04 Delta, Michigan, US
2022-12-29 US Michigan Dickinson 26043 9212 127 0   46.00999672 -87.86961634 2022-12-30 04:21:04 Dickinson, Michigan, US
2022-12-29 US Michigan Eaton 26045 34147 454 0   42.59599185 -84.83740035 2022-12-30 04:21:04 Eaton, Michigan, US
2022-12-29 US Michigan Emmet 26047 7496 106 0   45.52625509 -84.89083249 2022-12-30 04:21:04 Emmet, Michigan, US
2022-12-29 US Michigan Federal Correctional Institution (FCI)   329 5 0   47.63197653 0.0 2022-12-30 04:21:04 Federal Correctional Institution (FCI), Michigan, US
2022-12-29 US Michigan Genesee 26049 122861 1947 0   43.02244215 -83.70589709 2022-12-30 04:21:04 Genesee, Michigan, US
2022-12-29 US Michigan Gladwin 26051 6662 133 0   43.98901072 -84.38774817 2022-12-30 04:21:04 Gladwin, Michigan, US
2022-12-29 US Michigan Gogebic 26053 4213 77 0   46.40862701 -89.69377193 2022-12-30 04:21:04 Gogebic, Michigan, US
2022-12-29 US Michigan Grand Traverse 26055 21131 269 0   44.69565625 -85.55585247 2022-12-30 04:21:04 Grand Traverse, Michigan, US
2022-12-29 US Michigan Gratiot 26057 12637 206 0   43.29265605 -84.60505416 2022-12-30 04:21:04 Gratiot, Michigan, US
2022-12-29 US Michigan Hillsdale 26059 12458 220 0   41.88753639 -84.59312019 2022-12-30 04:21:04 Hillsdale, Michigan, US
2022-12-29 US Michigan Houghton 26061 9371 106 0   46.89988536 -88.68495385 2022-12-30 04:21:04 Houghton, Michigan, US
2022-12-29 US Michigan Huron 26063 9620 161 0   43.83353985 -83.04078453 2022-12-30 04:21:04 Huron, Michigan, US
2022-12-29 US Michigan Ingham 26065 82544 876 0   42.59716886 -84.37472069 2022-12-30 04:21:04 Ingham, Michigan, US
2022-12-29 US Michigan Ionia 26067 19552 202 0   42.94502238 -85.07413319 2022-12-30 04:21:04 Ionia, Michigan, US
2022-12-29 US Michigan Iosco 26069 5583 169 0   44.35486835 -83.63484895 2022-12-30 04:21:04 Iosco, Michigan, US
2022-12-29 US Michigan Iron 26071 3469 99 0   46.20974132 -88.53136251 2022-12-30 04:21:04 Iron, Michigan, US
2022-12-29 US Michigan Isabella 26073 17685 231 0   43.64060976 -84.84664923 2022-12-30 04:21:04 Isabella, Michigan, US
2022-12-29 US Michigan Jackson 26075 49266 629 0   42.24807035 -84.42258681 2022-12-30 04:21:04 Jackson, Michigan, US
2022-12-29 US Michigan Kalamazoo 26077 74189 771 0   42.24542231 -85.53038622 2022-12-30 04:21:04 Kalamazoo, Michigan, US
2022-12-29 US Michigan Kalkaska 26079 4428 69 0   44.68512729 -85.09085699 2022-12-30 04:21:04 Kalkaska, Michigan, US
2022-12-29 US Michigan Kent 26081 198143 1766 0   43.03197711 -85.54934642 2022-12-30 04:21:04 Kent, Michigan, US
2022-12-29 US Michigan Keweenaw 26083 643 15 0   47.63197653 -88.41434263 2022-12-30 04:21:04 Keweenaw, Michigan, US
2022-12-29 US Michigan Lake 26085 2361 42 0   43.99050893 -85.802173 2022-12-30 04:21:04 Lake, Michigan, US
2022-12-29 US Michigan Lapeer 26087 23871 465 0   43.09052506 -83.22153148 2022-12-30 04:21:04 Lapeer, Michigan, US
2022-12-29 US Michigan Leelanau 26089 4350 66 0   44.94430054 -85.80150326 2022-12-30 04:21:04 Leelanau, Michigan, US
2022-12-29 US Michigan Lenawee 26091 30175 356 0   41.89475156 -84.06603727 2022-12-30 04:21:04 Lenawee, Michigan, US
2022-12-29 US Michigan Livingston 26093 56554 517 0   42.60302282 -83.91297209 2022-12-30 04:21:04 Livingston, Michigan, US
2022-12-29 US Michigan Luce 26095 1642 20 0   46.47227431 -85.54471223 2022-12-30 04:21:04 Luce, Michigan, US
2022-12-29 US Michigan Mackinac 26097 2929 38 0   46.07028979 -85.04980537 2022-12-30 04:21:04 Mackinac, Michigan, US
2022-12-29 US Michigan Macomb 26099 292848 4453 0   42.69158356 -82.92752801 2022-12-30 04:21:04 Macomb, Michigan, US
2022-12-29 US Michigan Manistee 26101 4771 106 0   44.33352407 -86.05626916 2022-12-30 04:21:04 Manistee, Michigan, US
2022-12-29 US Michigan Marquette 26103 18679 161 0   46.4338914 -87.64043701 2022-12-30 04:21:04 Marquette, Michigan, US
2022-12-29 US Michigan Mason 26105 8175 111 0   43.99509218 -86.24988902 2022-12-30 04:21:04 Mason, Michigan, US
2022-12-29 US Michigan Mecosta 26107 10046 124 0   43.64064262 -85.32463223 2022-12-30 04:21:04 Mecosta, Michigan, US
2022-12-29 US Michigan Menominee 26109 6902 77 0   45.58038692 -87.55370409 2022-12-30 04:21:04 Menominee, Michigan, US
2022-12-29 US Michigan Michigan Department of Corrections (MDOC)   41679 181 0   47.63197653 0.0 2022-12-30 04:21:04 Michigan Department of Corrections (MDOC), Michigan, US
2022-12-29 US Michigan Midland 26111 23062 251 0   43.64330771 -84.38804374 2022-12-30 04:21:04 Midland, Michigan, US
2022-12-29 US Michigan Missaukee 26113 3528 69 0   44.33772443 -85.09256478 2022-12-30 04:21:04 Missaukee, Michigan, US
2022-12-29 US Michigan Monroe 26115 47135 520 0   41.92734151 -83.53749864 2022-12-30 04:21:04 Monroe, Michigan, US
2022-12-29 US Michigan Montcalm 26117 17637 238 0   43.31082541 -85.15252824 2022-12-30 04:21:04 Montcalm, Michigan, US
2022-12-29 US Michigan Montmorency 26119 1962 52 0   45.0275929 -84.12696227 2022-12-30 04:21:04 Montmorency, Michigan, US
2022-12-29 US Michigan Muskegon 26121 47721 704 0   43.29123859 -86.15176712 2022-12-30 04:21:04 Muskegon, Michigan, US
2022-12-29 US Michigan Newaygo 26123 13447 180 0   43.554374 -85.80070107 2022-12-30 04:21:04 Newaygo, Michigan, US
2022-12-29 US Michigan Oakland 26125 374914 4379 0   42.66090111 -83.38595416 2022-12-30 04:21:04 Oakland, Michigan, US
2022-12-29 US Michigan Oceana 26127 7561 103 0   43.64124435 -86.26726673 2022-12-30 04:21:04 Oceana, Michigan, US
2022-12-29 US Michigan Ogemaw 26129 4977 116 0   44.33481032 -84.12725175 2022-12-30 04:21:04 Ogemaw, Michigan, US
2022-12-29 US Michigan Ontonagon 26131 1305 44 0   46.6652262 -89.31390481 2022-12-30 04:21:04 Ontonagon, Michigan, US
2022-12-29 US Michigan Osceola 26133 5879 97 0   43.98992088 -85.32566756 2022-12-30 04:21:04 Osceola, Michigan, US
2022-12-29 US Michigan Oscoda 26135 1674 60 0   44.68192279 -84.12939244 2022-12-30 04:21:04 Oscoda, Michigan, US
2022-12-29 US Michigan Otsego 26137 6665 115 0   45.02085831 -84.59898295 2022-12-30 04:21:04 Otsego, Michigan, US
2022-12-29 US Michigan Ottawa 26139 86474 893 0   42.95996803 -85.9969107 2022-12-30 04:21:04 Ottawa, Michigan, US
2022-12-29 US Michigan Out of MI 80026 9150 52 0   47.63197653 0.0 2022-12-30 04:21:04 Out of MI, Michigan, US
2022-12-29 US Michigan Presque Isle 26141 2363 66 0   45.34018577 -83.91498656 2022-12-30 04:21:04 Presque Isle, Michigan, US
2022-12-29 US Michigan Roscommon 26143 5524 128 0   44.33473082 -84.61067651 2022-12-30 04:21:04 Roscommon, Michigan, US
2022-12-29 US Michigan Saginaw 26145 59965 1057 0   43.33433923 -84.0513121 2022-12-30 04:21:04 Saginaw, Michigan, US
2022-12-29 US Michigan Sanilac 26151 10374 219 0   43.42406072 -82.82055898 2022-12-30 04:21:04 Sanilac, Michigan, US
2022-12-29 US Michigan Schoolcraft 26153 2165 18 0   46.19235734 -86.19972234 2022-12-30 04:21:04 Schoolcraft, Michigan, US
2022-12-29 US Michigan Shiawassee 26155 21658 256 0   42.953928 -84.14585902 2022-12-30 04:21:04 Shiawassee, Michigan, US
2022-12-29 US Michigan St. Clair 26147 49546 919 0   42.92655373 -82.67937954 2022-12-30 04:21:04 St. Clair, Michigan, US
2022-12-29 US Michigan St. Joseph 26149 15799 234 0   41.91441767 -85.52797979 2022-12-30 04:21:04 St. Joseph, Michigan, US
2022-12-29 US Michigan Tuscola 26157 15472 305 0   43.46606813 -83.41897025 2022-12-30 04:21:04 Tuscola, Michigan, US
2022-12-29 US Michigan Unassigned 90026 42 0 0   47.63197653 0.0 2022-12-30 04:21:04 Unassigned, Michigan, US
2022-12-29 US Michigan Van Buren 26159 20435 322 0   42.25190229 -86.01939087 2022-12-30 04:21:04 Van Buren, Michigan, US
2022-12-29 US Michigan Washtenaw 26161 106278 620 0   42.253105 -83.83853204 2022-12-30 04:21:04 Washtenaw, Michigan, US
2022-12-29 US Michigan Wayne 26163 519952 8852 0   42.28098405 -83.281255 2022-12-30 04:21:04 Wayne, Michigan, US
2022-12-29 US Michigan Wexford 26165 8546 124 0   44.33853602 -85.57712739 2022-12-30 04:21:04 Wexford, Michigan, US
2022-12-28 US Michigan Alcona 26001 1896 77 0   44.6846864 -83.59507875 2022-12-29 04:21:01 Alcona, Michigan, US
2022-12-28 US Michigan Alger 26003 2081 18 0   46.41292944 -86.60260122 2022-12-29 04:21:01 Alger, Michigan, US
2022-12-28 US Michigan Allegan 26005 31656 391 0   42.59147037 -85.89102866 2022-12-29 04:21:01 Allegan, Michigan, US
2022-12-28 US Michigan Alpena 26007 6388 154 0   45.03477666 -83.62212411 2022-12-29 04:21:01 Alpena, Michigan, US
2022-12-28 US Michigan Antrim 26009 5182 76 0   44.99690221 -85.15503082 2022-12-29 04:21:01 Antrim, Michigan, US
2022-12-28 US Michigan Arenac 26011 3830 82 0   44.0636262 -83.89277559 2022-12-29 04:21:01 Arenac, Michigan, US
2022-12-28 US Michigan Baraga 26013 2536 58 0   46.6720582 -88.36363591 2022-12-29 04:21:01 Baraga, Michigan, US
2022-12-28 US Michigan Barry 26015 16611 188 0   42.59513984 -85.30834519 2022-12-29 04:21:01 Barry, Michigan, US
2022-12-28 US Michigan Bay 26017 31252 663 0   43.70639106 -83.98731479 2022-12-29 04:21:01 Bay, Michigan, US
2022-12-28 US Michigan Benzie 26019 4064 77 0   44.63899297 -86.01608482 2022-12-29 04:21:01 Benzie, Michigan, US
2022-12-28 US Michigan Berrien 26021 41231 670 0   41.95447397 -86.4131308 2022-12-29 04:21:01 Berrien, Michigan, US
2022-12-28 US Michigan Branch 26023 13166 204 0   41.91600556 -85.05929476 2022-12-29 04:21:01 Branch, Michigan, US
2022-12-28 US Michigan Calhoun 26025 41806 657 0   42.24633834 -85.00493569 2022-12-29 04:21:01 Calhoun, Michigan, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;