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 province_or_state

✎ View and edit SQL

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

Suggested facets: day (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
2021-12-02 US Michigan Alcona 26001 1331 51 0   44.6846864 -83.59507875 2021-12-03 04:23:05 Alcona, Michigan, US
2021-12-02 US Michigan Alger 26003 993 9 0   46.41292944 -86.60260122 2021-12-03 04:23:05 Alger, Michigan, US
2021-12-02 US Michigan Allegan 26005 18243 222 0   42.59147037 -85.89102866 2021-12-03 04:23:05 Allegan, Michigan, US
2021-12-02 US Michigan Alpena 26007 4060 83 0   45.03477666 -83.62212411 2021-12-03 04:23:05 Alpena, Michigan, US
2021-12-02 US Michigan Antrim 26009 2866 43 0   44.99690221 -85.15503082 2021-12-03 04:23:05 Antrim, Michigan, US
2021-12-02 US Michigan Arenac 26011 2122 44 0   44.0636262 -83.89277559 2021-12-03 04:23:05 Arenac, Michigan, US
2021-12-02 US Michigan Baraga 26013 1404 46 0   46.6720582 -88.36363591 2021-12-03 04:23:05 Baraga, Michigan, US
2021-12-02 US Michigan Barry 26015 9704 106 0   42.59513984 -85.30834519 2021-12-03 04:23:05 Barry, Michigan, US
2021-12-02 US Michigan Bay 26017 17415 430 0   43.70639106 -83.98731479 2021-12-03 04:23:05 Bay, Michigan, US
2021-12-02 US Michigan Benzie 26019 2139 45 0   44.63899297 -86.01608482 2021-12-03 04:23:05 Benzie, Michigan, US
2021-12-02 US Michigan Berrien 26021 22010 349 0   41.95447397 -86.41313079999998 2021-12-03 04:23:05 Berrien, Michigan, US
2021-12-02 US Michigan Branch 26023 7723 126 0   41.91600556 -85.05929476 2021-12-03 04:23:05 Branch, Michigan, US
2021-12-02 US Michigan Calhoun 26025 22197 401 0   42.24633834 -85.00493569 2021-12-03 04:23:05 Calhoun, Michigan, US
2021-12-02 US Michigan Cass 26027 8078 104 0   41.91522292 -85.99405727 2021-12-03 04:23:05 Cass, Michigan, US
2021-12-02 US Michigan Charlevoix 26029 3048 43 0   45.37790017 -85.19614053 2021-12-03 04:23:05 Charlevoix, Michigan, US
2021-12-02 US Michigan Cheboygan 26031 3298 78 0   45.44787015 -84.50122149 2021-12-03 04:23:05 Cheboygan, Michigan, US
2021-12-02 US Michigan Chippewa 26033 4516 57 0   46.29552653 -84.54353449 2021-12-03 04:23:05 Chippewa, Michigan, US
2021-12-02 US Michigan Clare 26035 4592 120 0   43.98794227 -84.84819859999998 2021-12-03 04:23:05 Clare, Michigan, US
2021-12-02 US Michigan Clinton 26037 12576 134 0   42.94400871 -84.60145248 2021-12-03 04:23:05 Clinton, Michigan, US
2021-12-02 US Michigan Crawford 26039 1771 18 0   44.68255561 -84.61006219 2021-12-03 04:23:05 Crawford, Michigan, US
2021-12-02 US Michigan Delta 26041 6646 123 0   45.90484910000001 -86.9080745 2021-12-03 04:23:05 Delta, Michigan, US
2021-12-02 US Michigan Dickinson 26043 4684 87 0   46.00999672 -87.86961634 2021-12-03 04:23:05 Dickinson, Michigan, US
2021-12-02 US Michigan Eaton 26045 16288 282 0   42.59599185 -84.83740035 2021-12-03 04:23:05 Eaton, Michigan, US
2021-12-02 US Michigan Emmet 26047 3996 55 0   45.52625509 -84.89083249 2021-12-03 04:23:05 Emmet, Michigan, US
2021-12-02 US Michigan Federal Correctional Institution (FCI)   321 5 0   47.63197653 0.0 2021-12-03 04:23:05 Federal Correctional Institution (FCI), Michigan, US
2021-12-02 US Michigan Genesee 26049 62139 1178 0   43.02244215 -83.70589709 2021-12-03 04:23:05 Genesee, Michigan, US
2021-12-02 US Michigan Gladwin 26051 3753 86 0   43.98901072 -84.38774817 2021-12-03 04:23:05 Gladwin, Michigan, US
2021-12-02 US Michigan Gogebic 26053 2147 56 0   46.40862701 -89.69377193 2021-12-03 04:23:05 Gogebic, Michigan, US
2021-12-02 US Michigan Grand Traverse 26055 11042 145 0   44.69565625 -85.55585247 2021-12-03 04:23:05 Grand Traverse, Michigan, US
2021-12-02 US Michigan Gratiot 26057 7075 141 0   43.29265605 -84.60505416 2021-12-03 04:23:05 Gratiot, Michigan, US
2021-12-02 US Michigan Hillsdale 26059 7442 148 0   41.88753639 -84.59312019 2021-12-03 04:23:05 Hillsdale, Michigan, US
2021-12-02 US Michigan Houghton 26061 5264 61 0   46.89988536 -88.68495385 2021-12-03 04:23:05 Houghton, Michigan, US
2021-12-02 US Michigan Huron 26063 5742 103 0   43.83353985 -83.04078453 2021-12-03 04:23:05 Huron, Michigan, US
2021-12-02 US Michigan Ingham 26065 36933 509 0   42.59716886 -84.37472069 2021-12-03 04:23:05 Ingham, Michigan, US
2021-12-02 US Michigan Ionia 26067 10907 118 0   42.94502238 -85.07413319 2021-12-03 04:23:05 Ionia, Michigan, US
2021-12-02 US Michigan Iosco 26069 3530 104 0   44.35486835 -83.63484895 2021-12-03 04:23:05 Iosco, Michigan, US
2021-12-02 US Michigan Iron 26071 1727 67 0   46.20974132 -88.53136251 2021-12-03 04:23:05 Iron, Michigan, US
2021-12-02 US Michigan Isabella 26073 10443 143 0   43.64060976 -84.84664923 2021-12-03 04:23:05 Isabella, Michigan, US
2021-12-02 US Michigan Jackson 26075 26009 376 0   42.24807035 -84.42258681 2021-12-03 04:23:05 Jackson, Michigan, US
2021-12-02 US Michigan Kalamazoo 26077 35135 491 0   42.24542231 -85.53038622 2021-12-03 04:23:05 Kalamazoo, Michigan, US
2021-12-02 US Michigan Kalkaska 26079 2168 41 0   44.68512729 -85.09085699 2021-12-03 04:23:05 Kalkaska, Michigan, US
2021-12-02 US Michigan Kent 26081 110656 1107 0   43.03197711 -85.54934642 2021-12-03 04:23:05 Kent, Michigan, US
2021-12-02 US Michigan Keweenaw 26083 365 9 0   47.63197653 -88.41434263 2021-12-03 04:23:05 Keweenaw, Michigan, US
2021-12-02 US Michigan Lake 26085 1206 27 0   43.99050893 -85.802173 2021-12-03 04:23:05 Lake, Michigan, US
2021-12-02 US Michigan Lapeer 26087 13782 276 0   43.09052506 -83.22153148 2021-12-03 04:23:05 Lapeer, Michigan, US
2021-12-02 US Michigan Leelanau 26089 2157 35 0   44.94430054 -85.80150326 2021-12-03 04:23:05 Leelanau, Michigan, US
2021-12-02 US Michigan Lenawee 26091 16041 218 0   41.89475156 -84.06603727 2021-12-03 04:23:05 Lenawee, Michigan, US
2021-12-02 US Michigan Livingston 26093 28985 295 0   42.60302282 -83.91297209 2021-12-03 04:23:05 Livingston, Michigan, US
2021-12-02 US Michigan Luce 26095 874 5 0   46.47227431 -85.54471223 2021-12-03 04:23:05 Luce, Michigan, US
2021-12-02 US Michigan Mackinac 26097 1522 14 0   46.07028979 -85.04980537 2021-12-03 04:23:05 Mackinac, Michigan, US
2021-12-02 US Michigan Macomb 26099 141980 2885 0   42.69158356 -82.92752801 2021-12-03 04:23:05 Macomb, Michigan, US
2021-12-02 US Michigan Manistee 26101 2196 47 0   44.33352407 -86.05626916 2021-12-03 04:23:05 Manistee, Michigan, US
2021-12-02 US Michigan Marquette 26103 8276 89 0   46.4338914 -87.64043701 2021-12-03 04:23:05 Marquette, Michigan, US
2021-12-02 US Michigan Mason 26105 4164 58 0   43.99509218 -86.24988902 2021-12-03 04:23:05 Mason, Michigan, US
2021-12-02 US Michigan Mecosta 26107 5755 67 0   43.64064262 -85.32463223 2021-12-03 04:23:05 Mecosta, Michigan, US
2021-12-02 US Michigan Menominee 26109 3877 57 0   45.58038692 -87.55370409 2021-12-03 04:23:05 Menominee, Michigan, US
2021-12-02 US Michigan Michigan Department of Corrections (MDOC)   28091 157 0   47.63197653 0.0 2021-12-03 04:23:05 Michigan Department of Corrections (MDOC), Michigan, US
2021-12-02 US Michigan Midland 26111 12144 159 0   43.64330771 -84.38804374 2021-12-03 04:23:05 Midland, Michigan, US
2021-12-02 US Michigan Missaukee 26113 2102 42 0   44.33772443 -85.09256478 2021-12-03 04:23:05 Missaukee, Michigan, US
2021-12-02 US Michigan Monroe 26115 24044 333 0   41.92734151 -83.53749864 2021-12-03 04:23:05 Monroe, Michigan, US
2021-12-02 US Michigan Montcalm 26117 10523 147 0   43.31082541 -85.15252824 2021-12-03 04:23:05 Montcalm, Michigan, US
2021-12-02 US Michigan Montmorency 26119 1261 36 0   45.0275929 -84.12696227 2021-12-03 04:23:05 Montmorency, Michigan, US
2021-12-02 US Michigan Muskegon 26121 26312 457 0   43.29123859 -86.15176712 2021-12-03 04:23:05 Muskegon, Michigan, US
2021-12-02 US Michigan Newaygo 26123 7915 104 0   43.554373999999996 -85.80070107 2021-12-03 04:23:05 Newaygo, Michigan, US
2021-12-02 US Michigan Oakland 26125 170525 2835 0   42.66090111 -83.38595416 2021-12-03 04:23:05 Oakland, Michigan, US
2021-12-02 US Michigan Oceana 26127 4502 75 0   43.64124435 -86.26726673 2021-12-03 04:23:05 Oceana, Michigan, US
2021-12-02 US Michigan Ogemaw 26129 3101 73 0   44.33481032 -84.12725175 2021-12-03 04:23:05 Ogemaw, Michigan, US
2021-12-02 US Michigan Ontonagon 26131 695 24 0   46.665226200000006 -89.31390481 2021-12-03 04:23:05 Ontonagon, Michigan, US
2021-12-02 US Michigan Osceola 26133 3568 50 0   43.98992088 -85.32566756 2021-12-03 04:23:05 Osceola, Michigan, US
2021-12-02 US Michigan Oscoda 26135 1104 45 0   44.68192279 -84.12939244 2021-12-03 04:23:05 Oscoda, Michigan, US
2021-12-02 US Michigan Otsego 26137 3938 68 0   45.02085831 -84.59898295 2021-12-03 04:23:05 Otsego, Michigan, US
2021-12-02 US Michigan Ottawa 26139 50068 572 0   42.95996803 -85.9969107 2021-12-03 04:23:05 Ottawa, Michigan, US
2021-12-02 US Michigan Out of MI 80026 2805 32 0   47.63197653 0.0 2021-12-03 04:23:05 Out of MI, Michigan, US
2021-12-02 US Michigan Presque Isle 26141 1613 46 0   45.34018577 -83.91498656 2021-12-03 04:23:05 Presque Isle, Michigan, US
2021-12-02 US Michigan Roscommon 26143 3302 83 0   44.33473082 -84.61067651 2021-12-03 04:23:05 Roscommon, Michigan, US
2021-12-02 US Michigan Saginaw 26145 32088 714 0   43.33433923 -84.05131209999998 2021-12-03 04:23:05 Saginaw, Michigan, US
2021-12-02 US Michigan Sanilac 26151 6087 151 0   43.42406072 -82.82055898 2021-12-03 04:23:05 Sanilac, Michigan, US
2021-12-02 US Michigan Schoolcraft 26153 1050 7 0   46.19235734 -86.19972234 2021-12-03 04:23:05 Schoolcraft, Michigan, US
2021-12-02 US Michigan Shiawassee 26155 11256 153 0   42.95392800000001 -84.14585902 2021-12-03 04:23:05 Shiawassee, Michigan, US
2021-12-02 US Michigan St. Clair 26147 26600 562 0   42.92655373 -82.67937954 2021-12-03 04:23:05 St. Clair, Michigan, US
2021-12-02 US Michigan St. Joseph 26149 9938 134 0   41.91441767 -85.52797979 2021-12-03 04:23:05 St. Joseph, Michigan, US
2021-12-02 US Michigan Tuscola 26157 8948 221 0   43.46606813 -83.41897025 2021-12-03 04:23:05 Tuscola, Michigan, US
2021-12-02 US Michigan Unassigned 90026 64 1 0   47.63197653 0.0 2021-12-03 04:23:05 Unassigned, Michigan, US
2021-12-02 US Michigan Van Buren 26159 11126 186 0   42.25190229 -86.01939087 2021-12-03 04:23:05 Van Buren, Michigan, US
2021-12-02 US Michigan Washtenaw 26161 39110 349 0   42.253105 -83.83853204 2021-12-03 04:23:05 Washtenaw, Michigan, US
2021-12-02 US Michigan Wayne 26163 231197 5891 0   42.28098405 -83.281255 2021-12-03 04:23:05 Wayne, Michigan, US
2021-12-02 US Michigan Wexford 26165 4563 74 0   44.33853602 -85.57712739 2021-12-03 04:23:05 Wexford, Michigan, US
2021-10-28 US Michigan Alcona 26001 1138 42 0   44.6846864 -83.59507875 2021-10-29 04:22:03 Alcona, Michigan, US
2021-10-28 US Michigan Alger 26003 849 9 0   46.41292944 -86.60260122 2021-10-29 04:22:03 Alger, Michigan, US
2021-10-28 US Michigan Allegan 26005 14751 191 0   42.59147037 -85.89102866 2021-10-29 04:22:03 Allegan, Michigan, US
2021-10-28 US Michigan Alpena 26007 3143 73 0   45.03477666 -83.62212411 2021-10-29 04:22:03 Alpena, Michigan, US
2021-10-28 US Michigan Antrim 26009 2389 38 0   44.99690221 -85.15503082 2021-10-29 04:22:03 Antrim, Michigan, US
2021-10-28 US Michigan Arenac 26011 1809 34 0   44.0636262 -83.89277559 2021-10-29 04:22:03 Arenac, Michigan, US
2021-10-28 US Michigan Baraga 26013 1155 46 0   46.6720582 -88.36363591 2021-10-29 04:22:03 Baraga, Michigan, US
2021-10-28 US Michigan Barry 26015 7812 84 0   42.59513984 -85.30834519 2021-10-29 04:22:03 Barry, Michigan, US
2021-10-28 US Michigan Bay 26017 14910 389 0   43.70639106 -83.98731479 2021-10-29 04:22:03 Bay, Michigan, US
2021-10-28 US Michigan Benzie 26019 1653 40 0   44.63899297 -86.01608482 2021-10-29 04:22:03 Benzie, Michigan, US
2021-10-28 US Michigan Berrien 26021 19273 329 0   41.95447397 -86.41313079999998 2021-10-29 04:22:03 Berrien, Michigan, US
2021-10-28 US Michigan Branch 26023 6467 113 0   41.91600556 -85.05929476 2021-10-29 04:22:03 Branch, Michigan, US
2021-10-28 US Michigan Calhoun 26025 18818 353 0   42.24633834 -85.00493569 2021-10-29 04:22:03 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;