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

50,174 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

  • Michigan · 50,174 ✖

country_or_region

  • US 50,174
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
33891 33891 2021-10-23 US Michigan Alcona 26001 1097 41 0   44.6846864 -83.59507875 2021-10-24 04:21:22 Alcona, Michigan, US
33892 33892 2021-10-23 US Michigan Alger 26003 844 8 0   46.41292944 -86.60260122 2021-10-24 04:21:22 Alger, Michigan, US
33893 33893 2021-10-23 US Michigan Allegan 26005 14505 188 0   42.59147037 -85.89102866 2021-10-24 04:21:22 Allegan, Michigan, US
33894 33894 2021-10-23 US Michigan Alpena 26007 3068 70 0   45.03477666 -83.62212411 2021-10-24 04:21:22 Alpena, Michigan, US
33895 33895 2021-10-23 US Michigan Antrim 26009 2330 37 0   44.99690221 -85.15503082 2021-10-24 04:21:22 Antrim, Michigan, US
33896 33896 2021-10-23 US Michigan Arenac 26011 1774 33 0   44.0636262 -83.89277559 2021-10-24 04:21:22 Arenac, Michigan, US
33897 33897 2021-10-23 US Michigan Baraga 26013 1114 46 0   46.6720582 -88.36363591 2021-10-24 04:21:22 Baraga, Michigan, US
33898 33898 2021-10-23 US Michigan Barry 26015 7701 83 0   42.59513984 -85.30834519 2021-10-24 04:21:22 Barry, Michigan, US
33899 33899 2021-10-23 US Michigan Bay 26017 14638 387 0   43.70639106 -83.98731479 2021-10-24 04:21:22 Bay, Michigan, US
33900 33900 2021-10-23 US Michigan Benzie 26019 1627 40 0   44.63899297 -86.01608482 2021-10-24 04:21:22 Benzie, Michigan, US
33901 33901 2021-10-23 US Michigan Berrien 26021 19073 330 0   41.95447397 -86.41313079999998 2021-10-24 04:21:22 Berrien, Michigan, US
33902 33902 2021-10-23 US Michigan Branch 26023 6366 110 0   41.91600556 -85.05929476 2021-10-24 04:21:22 Branch, Michigan, US
33903 33903 2021-10-23 US Michigan Calhoun 26025 18582 351 0   42.24633834 -85.00493569 2021-10-24 04:21:22 Calhoun, Michigan, US
33904 33904 2021-10-23 US Michigan Cass 26027 7045 89 0   41.91522292 -85.99405727 2021-10-24 04:21:22 Cass, Michigan, US
33905 33905 2021-10-23 US Michigan Charlevoix 26029 2504 32 0   45.37790017 -85.19614053 2021-10-24 04:21:22 Charlevoix, Michigan, US
33906 33906 2021-10-23 US Michigan Cheboygan 26031 2822 63 0   45.44787015 -84.50122149 2021-10-24 04:21:22 Cheboygan, Michigan, US
33907 33907 2021-10-23 US Michigan Chippewa 26033 3721 48 0   46.29552653 -84.54353449 2021-10-24 04:21:22 Chippewa, Michigan, US
33908 33908 2021-10-23 US Michigan Clare 26035 3711 98 0   43.98794227 -84.84819859999998 2021-10-24 04:21:22 Clare, Michigan, US
33909 33909 2021-10-23 US Michigan Clinton 26037 9897 106 0   42.94400871 -84.60145248 2021-10-24 04:21:22 Clinton, Michigan, US
33910 33910 2021-10-23 US Michigan Crawford 26039 1323 16 0   44.68255561 -84.61006219 2021-10-24 04:21:22 Crawford, Michigan, US
33911 33911 2021-10-23 US Michigan Delta 26041 5709 104 0   45.90484910000001 -86.9080745 2021-10-24 04:21:22 Delta, Michigan, US
33912 33912 2021-10-23 US Michigan Dickinson 26043 3951 80 0   46.00999672 -87.86961634 2021-10-24 04:21:22 Dickinson, Michigan, US
33913 33913 2021-10-23 US Michigan Eaton 26045 13034 241 0   42.59599185 -84.83740035 2021-10-24 04:21:22 Eaton, Michigan, US
33914 33914 2021-10-23 US Michigan Emmet 26047 3381 49 0   45.52625509 -84.89083249 2021-10-24 04:21:22 Emmet, Michigan, US
33915 33915 2021-10-23 US Michigan Federal Correctional Institution (FCI)   321 5 0   47.63197653 0.0 2021-10-24 04:21:22 Federal Correctional Institution (FCI), Michigan, US
33916 33916 2021-10-23 US Michigan Genesee 26049 51443 1078 0   43.02244215 -83.70589709 2021-10-24 04:21:22 Genesee, Michigan, US
33917 33917 2021-10-23 US Michigan Gladwin 26051 3232 69 0   43.98901072 -84.38774817 2021-10-24 04:21:22 Gladwin, Michigan, US
33918 33918 2021-10-23 US Michigan Gogebic 26053 1802 53 0   46.40862701 -89.69377193 2021-10-24 04:21:22 Gogebic, Michigan, US
33919 33919 2021-10-23 US Michigan Grand Traverse 26055 8770 120 0   44.69565625 -85.55585247 2021-10-24 04:21:22 Grand Traverse, Michigan, US
33920 33920 2021-10-23 US Michigan Gratiot 26057 5656 126 0   43.29265605 -84.60505416 2021-10-24 04:21:22 Gratiot, Michigan, US
33921 33921 2021-10-23 US Michigan Hillsdale 26059 6123 122 0   41.88753639 -84.59312019 2021-10-24 04:21:22 Hillsdale, Michigan, US
33922 33922 2021-10-23 US Michigan Houghton 26061 3994 55 0   46.89988536 -88.68495385 2021-10-24 04:21:22 Houghton, Michigan, US
33923 33923 2021-10-23 US Michigan Huron 26063 4760 90 0   43.83353985 -83.04078453 2021-10-24 04:21:22 Huron, Michigan, US
33924 33924 2021-10-23 US Michigan Ingham 26065 30627 452 0   42.59716886 -84.37472069 2021-10-24 04:21:22 Ingham, Michigan, US
33925 33925 2021-10-23 US Michigan Ionia 26067 8646 93 0   42.94502238 -85.07413319 2021-10-24 04:21:22 Ionia, Michigan, US
33926 33926 2021-10-23 US Michigan Iosco 26069 2938 93 0   44.35486835 -83.63484895 2021-10-24 04:21:22 Iosco, Michigan, US
33927 33927 2021-10-23 US Michigan Iron 26071 1408 56 0   46.20974132 -88.53136251 2021-10-24 04:21:22 Iron, Michigan, US
33928 33928 2021-10-23 US Michigan Isabella 26073 8853 116 0   43.64060976 -84.84664923 2021-10-24 04:21:22 Isabella, Michigan, US
33929 33929 2021-10-23 US Michigan Jackson 26075 20380 328 0   42.24807035 -84.42258681 2021-10-24 04:21:22 Jackson, Michigan, US
33930 33930 2021-10-23 US Michigan Kalamazoo 26077 29317 450 0   42.24542231 -85.53038622 2021-10-24 04:21:22 Kalamazoo, Michigan, US
33931 33931 2021-10-23 US Michigan Kalkaska 26079 1749 37 0   44.68512729 -85.09085699 2021-10-24 04:21:22 Kalkaska, Michigan, US
33932 33932 2021-10-23 US Michigan Kent 26081 92227 983 0   43.03197711 -85.54934642 2021-10-24 04:21:22 Kent, Michigan, US
33933 33933 2021-10-23 US Michigan Keweenaw 26083 246 4 0   47.63197653 -88.41434263 2021-10-24 04:21:22 Keweenaw, Michigan, US
33934 33934 2021-10-23 US Michigan Lake 26085 940 21 0   43.99050893 -85.802173 2021-10-24 04:21:22 Lake, Michigan, US
33935 33935 2021-10-23 US Michigan Lapeer 26087 11470 241 0   43.09052506 -83.22153148 2021-10-24 04:21:22 Lapeer, Michigan, US
33936 33936 2021-10-23 US Michigan Leelanau 26089 1599 25 0   44.94430054 -85.80150326 2021-10-24 04:21:22 Leelanau, Michigan, US
33937 33937 2021-10-23 US Michigan Lenawee 26091 12887 193 0   41.89475156 -84.06603727 2021-10-24 04:21:22 Lenawee, Michigan, US
33938 33938 2021-10-23 US Michigan Livingston 26093 22748 238 0   42.60302282 -83.91297209 2021-10-24 04:21:22 Livingston, Michigan, US
33939 33939 2021-10-23 US Michigan Luce 26095 714 5 0   46.47227431 -85.54471223 2021-10-24 04:21:22 Luce, Michigan, US
33940 33940 2021-10-23 US Michigan Mackinac 26097 1267 9 0   46.07028979 -85.04980537 2021-10-24 04:21:22 Mackinac, Michigan, US
33941 33941 2021-10-23 US Michigan Macomb 26099 119936 2665 0   42.69158356 -82.92752801 2021-10-24 04:21:22 Macomb, Michigan, US
33942 33942 2021-10-23 US Michigan Manistee 26101 1713 34 0   44.33352407 -86.05626916 2021-10-24 04:21:22 Manistee, Michigan, US
33943 33943 2021-10-23 US Michigan Marquette 26103 7013 77 0   46.4338914 -87.64043701 2021-10-24 04:21:22 Marquette, Michigan, US
33944 33944 2021-10-23 US Michigan Mason 26105 3066 47 0   43.99509218 -86.24988902 2021-10-24 04:21:22 Mason, Michigan, US
33945 33945 2021-10-23 US Michigan Mecosta 26107 4607 45 0   43.64064262 -85.32463223 2021-10-24 04:21:22 Mecosta, Michigan, US
33946 33946 2021-10-23 US Michigan Menominee 26109 3319 51 0   45.58038692 -87.55370409 2021-10-24 04:21:22 Menominee, Michigan, US
33947 33947 2021-10-23 US Michigan Michigan Department of Corrections (MDOC)   27257 152 0   47.63197653 0.0 2021-10-24 04:21:22 Michigan Department of Corrections (MDOC), Michigan, US
33948 33948 2021-10-23 US Michigan Midland 26111 10164 129 0   43.64330771 -84.38804374 2021-10-24 04:21:22 Midland, Michigan, US
33949 33949 2021-10-23 US Michigan Missaukee 26113 1819 37 0   44.33772443 -85.09256478 2021-10-24 04:21:22 Missaukee, Michigan, US
33950 33950 2021-10-23 US Michigan Monroe 26115 20157 299 0   41.92734151 -83.53749864 2021-10-24 04:21:22 Monroe, Michigan, US
33951 33951 2021-10-23 US Michigan Montcalm 26117 8526 126 0   43.31082541 -85.15252824 2021-10-24 04:21:22 Montcalm, Michigan, US
33952 33952 2021-10-23 US Michigan Montmorency 26119 916 26 0   45.0275929 -84.12696227 2021-10-24 04:21:22 Montmorency, Michigan, US
33953 33953 2021-10-23 US Michigan Muskegon 26121 20986 416 0   43.29123859 -86.15176712 2021-10-24 04:21:22 Muskegon, Michigan, US
33954 33954 2021-10-23 US Michigan Newaygo 26123 6497 82 0   43.554373999999996 -85.80070107 2021-10-24 04:21:22 Newaygo, Michigan, US
33955 33955 2021-10-23 US Michigan Oakland 26125 144272 2665 0   42.66090111 -83.38595416 2021-10-24 04:21:22 Oakland, Michigan, US
33956 33956 2021-10-23 US Michigan Oceana 26127 3638 70 0   43.64124435 -86.26726673 2021-10-24 04:21:22 Oceana, Michigan, US
33957 33957 2021-10-23 US Michigan Ogemaw 26129 2693 59 0   44.33481032 -84.12725175 2021-10-24 04:21:22 Ogemaw, Michigan, US
33958 33958 2021-10-23 US Michigan Ontonagon 26131 602 22 0   46.665226200000006 -89.31390481 2021-10-24 04:21:22 Ontonagon, Michigan, US
33959 33959 2021-10-23 US Michigan Osceola 26133 2989 40 0   43.98992088 -85.32566756 2021-10-24 04:21:22 Osceola, Michigan, US
33960 33960 2021-10-23 US Michigan Oscoda 26135 942 34 0   44.68192279 -84.12939244 2021-10-24 04:21:22 Oscoda, Michigan, US
33961 33961 2021-10-23 US Michigan Otsego 26137 3185 53 0   45.02085831 -84.59898295 2021-10-24 04:21:22 Otsego, Michigan, US
33962 33962 2021-10-23 US Michigan Ottawa 26139 40850 499 0   42.95996803 -85.9969107 2021-10-24 04:21:22 Ottawa, Michigan, US
33963 33963 2021-10-23 US Michigan Out of MI 80026 2353 23 0   47.63197653 0.0 2021-10-24 04:21:22 Out of MI, Michigan, US
33964 33964 2021-10-23 US Michigan Presque Isle 26141 1347 37 0   45.34018577 -83.91498656 2021-10-24 04:21:22 Presque Isle, Michigan, US
33965 33965 2021-10-23 US Michigan Roscommon 26143 2484 64 0   44.33473082 -84.61067651 2021-10-24 04:21:22 Roscommon, Michigan, US
33966 33966 2021-10-23 US Michigan Saginaw 26145 26911 664 0   43.33433923 -84.05131209999998 2021-10-24 04:21:22 Saginaw, Michigan, US
33967 33967 2021-10-23 US Michigan Sanilac 26151 4925 135 0   43.42406072 -82.82055898 2021-10-24 04:21:22 Sanilac, Michigan, US
33968 33968 2021-10-23 US Michigan Schoolcraft 26153 796 5 0   46.19235734 -86.19972234 2021-10-24 04:21:22 Schoolcraft, Michigan, US
33969 33969 2021-10-23 US Michigan Shiawassee 26155 8564 129 0   42.95392800000001 -84.14585902 2021-10-24 04:21:22 Shiawassee, Michigan, US
33970 33970 2021-10-23 US Michigan St. Clair 26147 22132 511 0   42.92655373 -82.67937954 2021-10-24 04:21:22 St. Clair, Michigan, US
33971 33971 2021-10-23 US Michigan St. Joseph 26149 8304 121 0   41.91441767 -85.52797979 2021-10-24 04:21:22 St. Joseph, Michigan, US
33972 33972 2021-10-23 US Michigan Tuscola 26157 7308 194 0   43.46606813 -83.41897025 2021-10-24 04:21:22 Tuscola, Michigan, US
33973 33973 2021-10-23 US Michigan Unassigned 90026 37 0 0   47.63197653 0.0 2021-10-24 04:21:22 Unassigned, Michigan, US
33974 33974 2021-10-23 US Michigan Van Buren 26159 9159 163 0   42.25190229 -86.01939087 2021-10-24 04:21:22 Van Buren, Michigan, US
33975 33975 2021-10-23 US Michigan Washtenaw 26161 32943 325 0   42.253105 -83.83853204 2021-10-24 04:21:22 Washtenaw, Michigan, US
33976 33976 2021-10-23 US Michigan Wayne 26163 197078 5546 0   42.28098405 -83.281255 2021-10-24 04:21:22 Wayne, Michigan, US
33977 33977 2021-10-23 US Michigan Wexford 26165 3601 52 0   44.33853602 -85.57712739 2021-10-24 04:21:22 Wexford, Michigan, US
314375 314375 2021-10-22 US Michigan Alcona 26001 1097 41 0   44.6846864 -83.59507875 2021-10-23 04:21:32 Alcona, Michigan, US
314376 314376 2021-10-22 US Michigan Alger 26003 844 8 0   46.41292944 -86.60260122 2021-10-23 04:21:32 Alger, Michigan, US
314377 314377 2021-10-22 US Michigan Allegan 26005 14505 188 0   42.59147037 -85.89102866 2021-10-23 04:21:32 Allegan, Michigan, US
314378 314378 2021-10-22 US Michigan Alpena 26007 3068 70 0   45.03477666 -83.62212411 2021-10-23 04:21:32 Alpena, Michigan, US
314379 314379 2021-10-22 US Michigan Antrim 26009 2330 37 0   44.99690221 -85.15503082 2021-10-23 04:21:32 Antrim, Michigan, US
314380 314380 2021-10-22 US Michigan Arenac 26011 1774 33 0   44.0636262 -83.89277559 2021-10-23 04:21:32 Arenac, Michigan, US
314381 314381 2021-10-22 US Michigan Baraga 26013 1114 46 0   46.6720582 -88.36363591 2021-10-23 04:21:32 Baraga, Michigan, US
314382 314382 2021-10-22 US Michigan Barry 26015 7701 83 0   42.59513984 -85.30834519 2021-10-23 04:21:32 Barry, Michigan, US
314383 314383 2021-10-22 US Michigan Bay 26017 14638 387 0   43.70639106 -83.98731479 2021-10-23 04:21:32 Bay, Michigan, US
314384 314384 2021-10-22 US Michigan Benzie 26019 1627 40 0   44.63899297 -86.01608482 2021-10-23 04:21:32 Benzie, Michigan, US
314385 314385 2021-10-22 US Michigan Berrien 26021 19073 330 0   41.95447397 -86.41313079999998 2021-10-23 04:21:32 Berrien, Michigan, US
314386 314386 2021-10-22 US Michigan Branch 26023 6366 110 0   41.91600556 -85.05929476 2021-10-23 04:21:32 Branch, Michigan, US
314387 314387 2021-10-22 US Michigan Calhoun 26025 18582 351 0   42.24633834 -85.00493569 2021-10-23 04:21:32 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]);