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 country_or_region

✎ View and edit SQL

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

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-10-28 US Michigan Cass 26027 7135 91 0   41.91522292 -85.99405727 2021-10-29 04:22:03 Cass, Michigan, US
2021-10-28 US Michigan Charlevoix 26029 2559 33 0   45.37790017 -85.19614053 2021-10-29 04:22:03 Charlevoix, Michigan, US
2021-10-28 US Michigan Cheboygan 26031 2866 65 0   45.44787015 -84.50122149 2021-10-29 04:22:03 Cheboygan, Michigan, US
2021-10-28 US Michigan Chippewa 26033 3800 52 0   46.29552653 -84.54353449 2021-10-29 04:22:03 Chippewa, Michigan, US
2021-10-28 US Michigan Clare 26035 3844 103 0   43.98794227 -84.84819859999998 2021-10-29 04:22:03 Clare, Michigan, US
2021-10-28 US Michigan Clinton 26037 10123 110 0   42.94400871 -84.60145248 2021-10-29 04:22:03 Clinton, Michigan, US
2021-10-28 US Michigan Crawford 26039 1356 16 0   44.68255561 -84.61006219 2021-10-29 04:22:03 Crawford, Michigan, US
2021-10-28 US Michigan Delta 26041 5802 106 0   45.90484910000001 -86.9080745 2021-10-29 04:22:03 Delta, Michigan, US
2021-10-28 US Michigan Dickinson 26043 4004 82 0   46.00999672 -87.86961634 2021-10-29 04:22:03 Dickinson, Michigan, US
2021-10-28 US Michigan Eaton 26045 13207 245 0   42.59599185 -84.83740035 2021-10-29 04:22:03 Eaton, Michigan, US
2021-10-28 US Michigan Emmet 26047 3434 50 0   45.52625509 -84.89083249 2021-10-29 04:22:03 Emmet, Michigan, US
2021-10-28 US Michigan Federal Correctional Institution (FCI)   321 5 0   47.63197653 0.0 2021-10-29 04:22:03 Federal Correctional Institution (FCI), Michigan, US
2021-10-28 US Michigan Genesee 26049 52166 1086 0   43.02244215 -83.70589709 2021-10-29 04:22:03 Genesee, Michigan, US
2021-10-28 US Michigan Gladwin 26051 3290 71 0   43.98901072 -84.38774817 2021-10-29 04:22:03 Gladwin, Michigan, US
2021-10-28 US Michigan Gogebic 26053 1816 53 0   46.40862701 -89.69377193 2021-10-29 04:22:03 Gogebic, Michigan, US
2021-10-28 US Michigan Grand Traverse 26055 8950 117 0   44.69565625 -85.55585247 2021-10-29 04:22:03 Grand Traverse, Michigan, US
2021-10-28 US Michigan Gratiot 26057 5823 128 0   43.29265605 -84.60505416 2021-10-29 04:22:03 Gratiot, Michigan, US
2021-10-28 US Michigan Hillsdale 26059 6211 124 0   41.88753639 -84.59312019 2021-10-29 04:22:03 Hillsdale, Michigan, US
2021-10-28 US Michigan Houghton 26061 4114 55 0   46.89988536 -88.68495385 2021-10-29 04:22:03 Houghton, Michigan, US
2021-10-28 US Michigan Huron 26063 4828 94 0   43.83353985 -83.04078453 2021-10-29 04:22:03 Huron, Michigan, US
2021-10-28 US Michigan Ingham 26065 31042 457 0   42.59716886 -84.37472069 2021-10-29 04:22:03 Ingham, Michigan, US
2021-10-28 US Michigan Ionia 26067 8775 95 0   42.94502238 -85.07413319 2021-10-29 04:22:03 Ionia, Michigan, US
2021-10-28 US Michigan Iosco 26069 3023 96 0   44.35486835 -83.63484895 2021-10-29 04:22:03 Iosco, Michigan, US
2021-10-28 US Michigan Iron 26071 1427 56 0   46.20974132 -88.53136251 2021-10-29 04:22:03 Iron, Michigan, US
2021-10-28 US Michigan Isabella 26073 9062 120 0   43.64060976 -84.84664923 2021-10-29 04:22:03 Isabella, Michigan, US
2021-10-28 US Michigan Jackson 26075 20825 332 0   42.24807035 -84.42258681 2021-10-29 04:22:03 Jackson, Michigan, US
2021-10-28 US Michigan Kalamazoo 26077 29723 454 0   42.24542231 -85.53038622 2021-10-29 04:22:03 Kalamazoo, Michigan, US
2021-10-28 US Michigan Kalkaska 26079 1782 37 0   44.68512729 -85.09085699 2021-10-29 04:22:03 Kalkaska, Michigan, US
2021-10-28 US Michigan Kent 26081 93560 997 0   43.03197711 -85.54934642 2021-10-29 04:22:03 Kent, Michigan, US
2021-10-28 US Michigan Keweenaw 26083 260 4 0   47.63197653 -88.41434263 2021-10-29 04:22:03 Keweenaw, Michigan, US
2021-10-28 US Michigan Lake 26085 966 22 0   43.99050893 -85.802173 2021-10-29 04:22:03 Lake, Michigan, US
2021-10-28 US Michigan Lapeer 26087 11589 244 0   43.09052506 -83.22153148 2021-10-29 04:22:03 Lapeer, Michigan, US
2021-10-28 US Michigan Leelanau 26089 1640 25 0   44.94430054 -85.80150326 2021-10-29 04:22:03 Leelanau, Michigan, US
2021-10-28 US Michigan Lenawee 26091 13191 196 0   41.89475156 -84.06603727 2021-10-29 04:22:03 Lenawee, Michigan, US
2021-10-28 US Michigan Livingston 26093 23177 240 0   42.60302282 -83.91297209 2021-10-29 04:22:03 Livingston, Michigan, US
2021-10-28 US Michigan Luce 26095 731 5 0   46.47227431 -85.54471223 2021-10-29 04:22:03 Luce, Michigan, US
2021-10-28 US Michigan Mackinac 26097 1294 11 0   46.07028979 -85.04980537 2021-10-29 04:22:03 Mackinac, Michigan, US
2021-10-28 US Michigan Macomb 26099 121524 2682 0   42.69158356 -82.92752801 2021-10-29 04:22:03 Macomb, Michigan, US
2021-10-28 US Michigan Manistee 26101 1741 36 0   44.33352407 -86.05626916 2021-10-29 04:22:03 Manistee, Michigan, US
2021-10-28 US Michigan Marquette 26103 7178 79 0   46.4338914 -87.64043701 2021-10-29 04:22:03 Marquette, Michigan, US
2021-10-28 US Michigan Mason 26105 3141 47 0   43.99509218 -86.24988902 2021-10-29 04:22:03 Mason, Michigan, US
2021-10-28 US Michigan Mecosta 26107 4707 45 0   43.64064262 -85.32463223 2021-10-29 04:22:03 Mecosta, Michigan, US
2021-10-28 US Michigan Menominee 26109 3357 51 0   45.58038692 -87.55370409 2021-10-29 04:22:03 Menominee, Michigan, US
2021-10-28 US Michigan Michigan Department of Corrections (MDOC)   27397 154 0   47.63197653 0.0 2021-10-29 04:22:03 Michigan Department of Corrections (MDOC), Michigan, US
2021-10-28 US Michigan Midland 26111 10379 134 0   43.64330771 -84.38804374 2021-10-29 04:22:03 Midland, Michigan, US
2021-10-28 US Michigan Missaukee 26113 1846 37 0   44.33772443 -85.09256478 2021-10-29 04:22:03 Missaukee, Michigan, US
2021-10-28 US Michigan Monroe 26115 20521 302 0   41.92734151 -83.53749864 2021-10-29 04:22:03 Monroe, Michigan, US
2021-10-28 US Michigan Montcalm 26117 8738 127 0   43.31082541 -85.15252824 2021-10-29 04:22:03 Montcalm, Michigan, US
2021-10-28 US Michigan Montmorency 26119 953 26 0   45.0275929 -84.12696227 2021-10-29 04:22:03 Montmorency, Michigan, US
2021-10-28 US Michigan Muskegon 26121 21353 415 0   43.29123859 -86.15176712 2021-10-29 04:22:03 Muskegon, Michigan, US
2021-10-28 US Michigan Newaygo 26123 6612 84 0   43.554373999999996 -85.80070107 2021-10-29 04:22:03 Newaygo, Michigan, US
2021-10-28 US Michigan Oakland 26125 146046 2682 0   42.66090111 -83.38595416 2021-10-29 04:22:03 Oakland, Michigan, US
2021-10-28 US Michigan Oceana 26127 3703 70 0   43.64124435 -86.26726673 2021-10-29 04:22:03 Oceana, Michigan, US
2021-10-28 US Michigan Ogemaw 26129 2737 59 0   44.33481032 -84.12725175 2021-10-29 04:22:03 Ogemaw, Michigan, US
2021-10-28 US Michigan Ontonagon 26131 613 22 0   46.665226200000006 -89.31390481 2021-10-29 04:22:03 Ontonagon, Michigan, US
2021-10-28 US Michigan Osceola 26133 3076 41 0   43.98992088 -85.32566756 2021-10-29 04:22:03 Osceola, Michigan, US
2021-10-28 US Michigan Oscoda 26135 956 38 0   44.68192279 -84.12939244 2021-10-29 04:22:03 Oscoda, Michigan, US
2021-10-28 US Michigan Otsego 26137 3249 56 0   45.02085831 -84.59898295 2021-10-29 04:22:03 Otsego, Michigan, US
2021-10-28 US Michigan Ottawa 26139 41440 505 0   42.95996803 -85.9969107 2021-10-29 04:22:03 Ottawa, Michigan, US
2021-10-28 US Michigan Out of MI 80026 2381 24 0   47.63197653 0.0 2021-10-29 04:22:03 Out of MI, Michigan, US
2021-10-28 US Michigan Presque Isle 26141 1373 39 0   45.34018577 -83.91498656 2021-10-29 04:22:03 Presque Isle, Michigan, US
2021-10-28 US Michigan Roscommon 26143 2551 65 0   44.33473082 -84.61067651 2021-10-29 04:22:03 Roscommon, Michigan, US
2021-10-28 US Michigan Saginaw 26145 27372 667 0   43.33433923 -84.05131209999998 2021-10-29 04:22:03 Saginaw, Michigan, US
2021-10-28 US Michigan Sanilac 26151 4996 135 0   43.42406072 -82.82055898 2021-10-29 04:22:03 Sanilac, Michigan, US
2021-10-28 US Michigan Schoolcraft 26153 804 5 0   46.19235734 -86.19972234 2021-10-29 04:22:03 Schoolcraft, Michigan, US
2021-10-28 US Michigan Shiawassee 26155 8727 130 0   42.95392800000001 -84.14585902 2021-10-29 04:22:03 Shiawassee, Michigan, US
2021-10-28 US Michigan St. Clair 26147 22403 515 0   42.92655373 -82.67937954 2021-10-29 04:22:03 St. Clair, Michigan, US
2021-10-28 US Michigan St. Joseph 26149 8464 121 0   41.91441767 -85.52797979 2021-10-29 04:22:03 St. Joseph, Michigan, US
2021-10-28 US Michigan Tuscola 26157 7436 195 0   43.46606813 -83.41897025 2021-10-29 04:22:03 Tuscola, Michigan, US
2021-10-28 US Michigan Unassigned 90026 43 0 0   47.63197653 0.0 2021-10-29 04:22:03 Unassigned, Michigan, US
2021-10-28 US Michigan Van Buren 26159 9282 165 0   42.25190229 -86.01939087 2021-10-29 04:22:03 Van Buren, Michigan, US
2021-10-28 US Michigan Washtenaw 26161 33322 329 0   42.253105 -83.83853204 2021-10-29 04:22:03 Washtenaw, Michigan, US
2021-10-28 US Michigan Wayne 26163 199394 5573 0   42.28098405 -83.281255 2021-10-29 04:22:03 Wayne, Michigan, US
2021-10-28 US Michigan Wexford 26165 3683 53 0   44.33853602 -85.57712739 2021-10-29 04:22:03 Wexford, Michigan, US
2020-10-25 US Michigan Alcona 26001 52 2 0 50 44.6846864 -83.59507875 2020-10-26 04:25:02 Alcona, Michigan, US
2020-10-25 US Michigan Alger 26003 105 1 0 104 46.41292944 -86.60260122 2020-10-26 04:25:02 Alger, Michigan, US
2020-10-25 US Michigan Allegan 26005 1201 7 0 1194 42.59147037 -85.89102866 2020-10-26 04:25:02 Allegan, Michigan, US
2020-10-25 US Michigan Alpena 26007 152 14 0 138 45.03477666 -83.62212411 2020-10-26 04:25:02 Alpena, Michigan, US
2020-10-25 US Michigan Antrim 26009 115 0 0 115 44.99690221 -85.15503082 2020-10-26 04:25:02 Antrim, Michigan, US
2020-10-25 US Michigan Arenac 26011 91 3 0 88 44.0636262 -83.89277559 2020-10-26 04:25:02 Arenac, Michigan, US
2020-10-25 US Michigan Baraga 26013 80 4 0 76 46.6720582 -88.36363591 2020-10-26 04:25:02 Baraga, Michigan, US
2020-10-25 US Michigan Barry 26015 626 5 0 621 42.59513984 -85.30834519 2020-10-26 04:25:02 Barry, Michigan, US
2020-10-25 US Michigan Bay 26017 1347 62 0 1285 43.70639106 -83.98731479 2020-10-26 04:25:02 Bay, Michigan, US
2020-10-25 US Michigan Benzie 26019 115 2 0 113 44.63899297 -86.01608482 2020-10-26 04:25:02 Benzie, Michigan, US
2020-10-25 US Michigan Berrien 26021 2609 80 0 2529 41.95447397 -86.41313079999998 2020-10-26 04:25:02 Berrien, Michigan, US
2020-10-25 US Michigan Branch 26023 849 11 0 838 41.91600556 -85.05929476 2020-10-26 04:25:02 Branch, Michigan, US
2020-10-25 US Michigan Calhoun 26025 2699 67 0 2632 42.24633834 -85.00493569 2020-10-26 04:25:02 Calhoun, Michigan, US
2020-10-25 US Michigan Cass 26027 944 24 0 920 41.91522292 -85.99405727 2020-10-26 04:25:02 Cass, Michigan, US
2020-10-25 US Michigan Charlevoix 26029 164 4 0 160 45.37790017 -85.19614053 2020-10-26 04:25:02 Charlevoix, Michigan, US
2020-10-25 US Michigan Cheboygan 26031 133 2 0 131 45.44787015 -84.50122149 2020-10-26 04:25:02 Cheboygan, Michigan, US
2020-10-25 US Michigan Chippewa 26033 128 0 0 128 46.29552653 -84.54353449 2020-10-26 04:25:02 Chippewa, Michigan, US
2020-10-25 US Michigan Clare 26035 254 10 0 244 43.98794227 -84.84819859999998 2020-10-26 04:25:02 Clare, Michigan, US
2020-10-25 US Michigan Clinton 26037 1050 15 0 1035 42.94400871 -84.60145248 2020-10-26 04:25:02 Clinton, Michigan, US
2020-10-25 US Michigan Crawford 26039 150 5 0 145 44.68255561 -84.61006219 2020-10-26 04:25:02 Crawford, Michigan, US
2020-10-25 US Michigan Delta 26041 1140 24 0 1116 45.90484910000001 -86.9080745 2020-10-26 04:25:02 Delta, Michigan, US
2020-10-25 US Michigan Dickinson 26043 603 18 0 585 46.00999672 -87.86961634 2020-10-26 04:25:02 Dickinson, Michigan, US
2020-10-25 US Michigan Eaton 26045 1092 11 0 1081 42.59599185 -84.83740035 2020-10-26 04:25:02 Eaton, Michigan, US
2020-10-25 US Michigan Emmet 26047 222 4 0 218 45.52625509 -84.89083249 2020-10-26 04:25:02 Emmet, Michigan, US
2020-10-25 US Michigan Federal Correctional Institution (FCI)   197 5 0 192 47.63197653 0.0 2020-10-26 04:25:02 Federal Correctional Institution (FCI), Michigan, US
2020-10-25 US Michigan Genesee 26049 6491 333 0 6158 43.02244215 -83.70589709 2020-10-26 04:25:02 Genesee, 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;