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

29,990 rows where province_or_state = "Michigan" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • Michigan · 29,990 ✖

country_or_region

  • US 29,990
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
954922 954922 2021-03-05 US Michigan Alcona 26001 431 24 0 407 44.6846864 -83.59507875 2021-03-06 04:23:41 Alcona, Michigan, US
954923 954923 2021-03-05 US Michigan Alger 26003 436 5 0 431 46.41292944 -86.60260122 2021-03-06 04:23:41 Alger, Michigan, US
954924 954924 2021-03-05 US Michigan Allegan 26005 7394 118 0 7276 42.59147037 -85.89102866 2021-03-06 04:23:41 Allegan, Michigan, US
954925 954925 2021-03-05 US Michigan Alpena 26007 1500 48 0 1452 45.03477666 -83.62212411 2021-03-06 04:23:41 Alpena, Michigan, US
954926 954926 2021-03-05 US Michigan Antrim 26009 977 20 0 957 44.99690221 -85.15503082 2021-03-06 04:23:41 Antrim, Michigan, US
954927 954927 2021-03-05 US Michigan Arenac 26011 766 25 0 741 44.0636262 -83.89277559 2021-03-06 04:23:41 Arenac, Michigan, US
954928 954928 2021-03-05 US Michigan Baraga 26013 606 32 0 574 46.6720582 -88.36363591 2021-03-06 04:23:41 Baraga, Michigan, US
954929 954929 2021-03-05 US Michigan Barry 26015 3809 46 0 3763 42.59513984 -85.30834519 2021-03-06 04:23:41 Barry, Michigan, US
954930 954930 2021-03-05 US Michigan Bay 26017 7531 293 0 7238 43.70639106 -83.98731479 2021-03-06 04:23:41 Bay, Michigan, US
954931 954931 2021-03-05 US Michigan Benzie 26019 928 31 0 897 44.63899297 -86.01608482 2021-03-06 04:23:41 Benzie, Michigan, US
954932 954932 2021-03-05 US Michigan Berrien 26021 11611 245 0 11366 41.95447397 -86.41313079999998 2021-03-06 04:23:41 Berrien, Michigan, US
954933 954933 2021-03-05 US Michigan Branch 26023 3771 86 0 3685 41.91600556 -85.05929476 2021-03-06 04:23:41 Branch, Michigan, US
954934 954934 2021-03-05 US Michigan Calhoun 26025 9784 235 0 9549 42.24633834 -85.00493569 2021-03-06 04:23:41 Calhoun, Michigan, US
954935 954935 2021-03-05 US Michigan Cass 26027 4079 64 0 4015 41.91522292 -85.99405727 2021-03-06 04:23:41 Cass, Michigan, US
954936 954936 2021-03-05 US Michigan Charlevoix 26029 1061 13 0 1048 45.37790017 -85.19614053 2021-03-06 04:23:41 Charlevoix, Michigan, US
954937 954937 2021-03-05 US Michigan Cheboygan 26031 1032 37 0 995 45.44787015 -84.50122149 2021-03-06 04:23:41 Cheboygan, Michigan, US
954938 954938 2021-03-05 US Michigan Chippewa 26033 1772 27 0 1745 46.29552653 -84.54353449 2021-03-06 04:23:41 Chippewa, Michigan, US
954939 954939 2021-03-05 US Michigan Clare 26035 1625 69 0 1556 43.98794227 -84.84819859999998 2021-03-06 04:23:41 Clare, Michigan, US
954940 954940 2021-03-05 US Michigan Clinton 26037 5090 71 0 5019 42.94400871 -84.60145248 2021-03-06 04:23:41 Clinton, Michigan, US
954941 954941 2021-03-05 US Michigan Crawford 26039 606 5 0 601 44.68255561 -84.61006219 2021-03-06 04:23:41 Crawford, Michigan, US
954942 954942 2021-03-05 US Michigan Delta 26041 3156 84 0 3072 45.90484910000001 -86.9080745 2021-03-06 04:23:41 Delta, Michigan, US
954943 954943 2021-03-05 US Michigan Dickinson 26043 2373 70 0 2303 46.00999672 -87.86961634 2021-03-06 04:23:41 Dickinson, Michigan, US
954944 954944 2021-03-05 US Michigan Eaton 26045 6388 156 0 6232 42.59599185 -84.83740035 2021-03-06 04:23:41 Eaton, Michigan, US
954945 954945 2021-03-05 US Michigan Emmet 26047 1555 39 0 1516 45.52625509 -84.89083249 2021-03-06 04:23:41 Emmet, Michigan, US
954946 954946 2021-03-05 US Michigan Federal Correctional Institution (FCI)   314 5 0 309 47.63197653 0.0 2021-03-06 04:23:41 Federal Correctional Institution (FCI), Michigan, US
954947 954947 2021-03-05 US Michigan Genesee 26049 26041 756 0 25285 43.02244215 -83.70589709 2021-03-06 04:23:41 Genesee, Michigan, US
954948 954948 2021-03-05 US Michigan Gladwin 26051 1499 43 0 1456 43.98901072 -84.38774817 2021-03-06 04:23:41 Gladwin, Michigan, US
954949 954949 2021-03-05 US Michigan Gogebic 26053 1288 48 0 1240 46.40862701 -89.69377193 2021-03-06 04:23:41 Gogebic, Michigan, US
954950 954950 2021-03-05 US Michigan Grand Traverse 26055 4330 70 0 4260 44.69565625 -85.55585247 2021-03-06 04:23:41 Grand Traverse, Michigan, US
954951 954951 2021-03-05 US Michigan Gratiot 26057 2786 103 0 2683 43.29265605 -84.60505416 2021-03-06 04:23:41 Gratiot, Michigan, US
954952 954952 2021-03-05 US Michigan Hillsdale 26059 3388 76 0 3312 41.88753639 -84.59312019 2021-03-06 04:23:41 Hillsdale, Michigan, US
954953 954953 2021-03-05 US Michigan Houghton 26061 2685 40 0 2645 46.89988536 -88.68495385 2021-03-06 04:23:41 Houghton, Michigan, US
954954 954954 2021-03-05 US Michigan Huron 26063 2189 59 0 2130 43.83353985 -83.04078453 2021-03-06 04:23:41 Huron, Michigan, US
954955 954955 2021-03-05 US Michigan Ingham 26065 16617 281 0 16336 42.59716886 -84.37472069 2021-03-06 04:23:41 Ingham, Michigan, US
954956 954956 2021-03-05 US Michigan Ionia 26067 4243 71 0 4172 42.94502238 -85.07413319 2021-03-06 04:23:41 Ionia, Michigan, US
954957 954957 2021-03-05 US Michigan Iosco 26069 1282 67 0 1215 44.35486835 -83.63484895 2021-03-06 04:23:41 Iosco, Michigan, US
954958 954958 2021-03-05 US Michigan Iron 26071 928 49 0 879 46.20974132 -88.53136251 2021-03-06 04:23:41 Iron, Michigan, US
954959 954959 2021-03-05 US Michigan Isabella 26073 4054 73 0 3981 43.64060976 -84.84664923 2021-03-06 04:23:41 Isabella, Michigan, US
954960 954960 2021-03-05 US Michigan Jackson 26075 9721 223 0 9498 42.24807035 -84.42258681 2021-03-06 04:23:41 Jackson, Michigan, US
954961 954961 2021-03-05 US Michigan Kalamazoo 26077 15222 324 0 14898 42.24542231 -85.53038622 2021-03-06 04:23:41 Kalamazoo, Michigan, US
954962 954962 2021-03-05 US Michigan Kalkaska 26079 628 15 0 613 44.68512729 -85.09085699 2021-03-06 04:23:41 Kalkaska, Michigan, US
954963 954963 2021-03-05 US Michigan Kent 26081 52231 714 0 51517 43.03197711 -85.54934642 2021-03-06 04:23:41 Kent, Michigan, US
954964 954964 2021-03-05 US Michigan Keweenaw 26083 145 2 0 143 47.63197653 -88.41434263 2021-03-06 04:23:41 Keweenaw, Michigan, US
954965 954965 2021-03-05 US Michigan Lake 26085 367 11 0 356 43.99050893 -85.802173 2021-03-06 04:23:41 Lake, Michigan, US
954966 954966 2021-03-05 US Michigan Lapeer 26087 5148 122 0 5026 43.09052506 -83.22153148 2021-03-06 04:23:41 Lapeer, Michigan, US
954967 954967 2021-03-05 US Michigan Leelanau 26089 888 15 0 873 44.94430054 -85.80150326 2021-03-06 04:23:41 Leelanau, Michigan, US
954968 954968 2021-03-05 US Michigan Lenawee 26091 6400 122 0 6278 41.89475156 -84.06603727 2021-03-06 04:23:41 Lenawee, Michigan, US
954969 954969 2021-03-05 US Michigan Livingston 26093 10488 146 0 10342 42.60302282 -83.91297209 2021-03-06 04:23:41 Livingston, Michigan, US
954970 954970 2021-03-05 US Michigan Luce 26095 230 1 0 229 46.47227431 -85.54471223 2021-03-06 04:23:41 Luce, Michigan, US
954971 954971 2021-03-05 US Michigan Mackinac 26097 447 3 0 444 46.07028979 -85.04980537 2021-03-06 04:23:41 Mackinac, Michigan, US
954972 954972 2021-03-05 US Michigan Macomb 26099 59941 1973 0 57968 42.69158356 -82.92752801 2021-03-06 04:23:41 Macomb, Michigan, US
954973 954973 2021-03-05 US Michigan Manistee 26101 792 21 0 771 44.33352407 -86.05626916 2021-03-06 04:23:41 Manistee, Michigan, US
954974 954974 2021-03-05 US Michigan Marquette 26103 3975 56 0 3919 46.4338914 -87.64043701 2021-03-06 04:23:41 Marquette, Michigan, US
954975 954975 2021-03-05 US Michigan Mason 26105 1248 26 0 1222 43.99509218 -86.24988902 2021-03-06 04:23:41 Mason, Michigan, US
954976 954976 2021-03-05 US Michigan Mecosta 26107 2040 20 0 2020 43.64064262 -85.32463223 2021-03-06 04:23:41 Mecosta, Michigan, US
954977 954977 2021-03-05 US Michigan Menominee 26109 1882 38 0 1844 45.58038692 -87.55370409 2021-03-06 04:23:41 Menominee, Michigan, US
954978 954978 2021-03-05 US Michigan Michigan Department of Corrections (MDOC)   24971 148 0 24823 47.63197653 0.0 2021-03-06 04:23:41 Michigan Department of Corrections (MDOC), Michigan, US
954979 954979 2021-03-05 US Michigan Midland 26111 5064 65 0 4999 43.64330771 -84.38804374 2021-03-06 04:23:41 Midland, Michigan, US
954980 954980 2021-03-05 US Michigan Missaukee 26113 808 17 0 791 44.33772443 -85.09256478 2021-03-06 04:23:41 Missaukee, Michigan, US
954981 954981 2021-03-05 US Michigan Monroe 26115 9969 204 0 9765 41.92734151 -83.53749864 2021-03-06 04:23:41 Monroe, Michigan, US
954982 954982 2021-03-05 US Michigan Montcalm 26117 3550 88 0 3462 43.31082541 -85.15252824 2021-03-06 04:23:41 Montcalm, Michigan, US
954983 954983 2021-03-05 US Michigan Montmorency 26119 369 17 0 352 45.0275929 -84.12696227 2021-03-06 04:23:41 Montmorency, Michigan, US
954984 954984 2021-03-05 US Michigan Muskegon 26121 10606 306 0 10300 43.29123859 -86.15176712 2021-03-06 04:23:41 Muskegon, Michigan, US
954985 954985 2021-03-05 US Michigan Newaygo 26123 2915 52 0 2863 43.554374 -85.80070107 2021-03-06 04:23:41 Newaygo, Michigan, US
954986 954986 2021-03-05 US Michigan Oakland 26125 75649 2008 0 73641 42.66090111 -83.38595416 2021-03-06 04:23:41 Oakland, Michigan, US
954987 954987 2021-03-05 US Michigan Oceana 26127 1889 50 0 1839 43.64124435 -86.26726673 2021-03-06 04:23:41 Oceana, Michigan, US
954988 954988 2021-03-05 US Michigan Ogemaw 26129 1116 34 0 1082 44.33481032 -84.12725175 2021-03-06 04:23:41 Ogemaw, Michigan, US
954989 954989 2021-03-05 US Michigan Ontonagon 26131 413 20 0 393 46.665226200000006 -89.31390481 2021-03-06 04:23:41 Ontonagon, Michigan, US
954990 954990 2021-03-05 US Michigan Osceola 26133 1068 23 0 1045 43.98992088 -85.32566756 2021-03-06 04:23:41 Osceola, Michigan, US
954991 954991 2021-03-05 US Michigan Oscoda 26135 401 19 0 382 44.68192279 -84.12939244 2021-03-06 04:23:41 Oscoda, Michigan, US
954992 954992 2021-03-05 US Michigan Otsego 26137 1178 27 0 1151 45.02085831 -84.59898295 2021-03-06 04:23:41 Otsego, Michigan, US
954993 954993 2021-03-05 US Michigan Ottawa 26139 22509 357 0 22152 42.95996803 -85.9969107 2021-03-06 04:23:41 Ottawa, Michigan, US
954994 954994 2021-03-05 US Michigan Out of MI 80026 1498 11 0 1487 47.63197653 0.0 2021-03-06 04:23:41 Out of MI, Michigan, US
954995 954995 2021-03-05 US Michigan Presque Isle 26141 668 28 0 640 45.34018577 -83.91498656 2021-03-06 04:23:41 Presque Isle, Michigan, US
954996 954996 2021-03-05 US Michigan Roscommon 26143 1186 33 0 1153 44.33473082 -84.61067651 2021-03-06 04:23:41 Roscommon, Michigan, US
954997 954997 2021-03-05 US Michigan Saginaw 26145 14997 517 0 14480 43.33433923 -84.05131209999998 2021-03-06 04:23:41 Saginaw, Michigan, US
954998 954998 2021-03-05 US Michigan Sanilac 26151 2137 77 0 2060 43.42406072 -82.82055898 2021-03-06 04:23:41 Sanilac, Michigan, US
954999 954999 2021-03-05 US Michigan Schoolcraft 26153 258 5 0 253 46.19235734 -86.19972234 2021-03-06 04:23:41 Schoolcraft, Michigan, US
955000 955000 2021-03-05 US Michigan Shiawassee 26155 3879 80 0 3799 42.95392800000001 -84.14585902 2021-03-06 04:23:41 Shiawassee, Michigan, US
955001 955001 2021-03-05 US Michigan St. Clair 26147 8830 260 0 8570 42.92655373 -82.67937954 2021-03-06 04:23:41 St. Clair, Michigan, US
955002 955002 2021-03-05 US Michigan St. Joseph 26149 4767 85 0 4682 41.91441767 -85.52797979 2021-03-06 04:23:41 St. Joseph, Michigan, US
955003 955003 2021-03-05 US Michigan Tuscola 26157 3264 138 0 3126 43.46606813 -83.41897025 2021-03-06 04:23:41 Tuscola, Michigan, US
955004 955004 2021-03-05 US Michigan Unassigned 90026 19 0 0 19 47.63197653 0.0 2021-03-06 04:23:41 Unassigned, Michigan, US
955005 955005 2021-03-05 US Michigan Van Buren 26159 5020 96 0 4924 42.25190229 -86.01939087 2021-03-06 04:23:41 Van Buren, Michigan, US
955006 955006 2021-03-05 US Michigan Washtenaw 26161 18910 244 0 18666 42.253105 -83.83853204 2021-03-06 04:23:41 Washtenaw, Michigan, US
955007 955007 2021-03-05 US Michigan Wayne 26163 103282 4156 0 99126 42.28098405 -83.281255 2021-03-06 04:23:41 Wayne, Michigan, US
955008 955008 2021-03-05 US Michigan Wexford 26165 1472 20 0 1452 44.33853602 -85.57712739 2021-03-06 04:23:41 Wexford, Michigan, US
902282 902282 2021-03-04 US Michigan Alcona 26001 431 24 0 407 44.6846864 -83.59507875 2021-03-05 05:26:29 Alcona, Michigan, US
902283 902283 2021-03-04 US Michigan Alger 26003 435 5 0 430 46.41292944 -86.60260122 2021-03-05 05:26:29 Alger, Michigan, US
902284 902284 2021-03-04 US Michigan Allegan 26005 7367 118 0 7249 42.59147037 -85.89102866 2021-03-05 05:26:29 Allegan, Michigan, US
902285 902285 2021-03-04 US Michigan Alpena 26007 1497 48 0 1449 45.03477666 -83.62212411 2021-03-05 05:26:29 Alpena, Michigan, US
902286 902286 2021-03-04 US Michigan Antrim 26009 973 20 0 953 44.99690221 -85.15503082 2021-03-05 05:26:29 Antrim, Michigan, US
902287 902287 2021-03-04 US Michigan Arenac 26011 765 25 0 740 44.0636262 -83.89277559 2021-03-05 05:26:29 Arenac, Michigan, US
902288 902288 2021-03-04 US Michigan Baraga 26013 607 32 0 575 46.6720582 -88.36363591 2021-03-05 05:26:29 Baraga, Michigan, US
902289 902289 2021-03-04 US Michigan Barry 26015 3799 46 0 3753 42.59513984 -85.30834519 2021-03-05 05:26:29 Barry, Michigan, US
902290 902290 2021-03-04 US Michigan Bay 26017 7508 293 0 7215 43.70639106 -83.98731479 2021-03-05 05:26:29 Bay, Michigan, US
902291 902291 2021-03-04 US Michigan Benzie 26019 925 31 0 894 44.63899297 -86.01608482 2021-03-05 05:26:29 Benzie, Michigan, US
902292 902292 2021-03-04 US Michigan Berrien 26021 11570 245 0 11325 41.95447397 -86.41313079999998 2021-03-05 05:26:29 Berrien, Michigan, US
902293 902293 2021-03-04 US Michigan Branch 26023 3763 86 0 3677 41.91600556 -85.05929476 2021-03-05 05:26:29 Branch, Michigan, US
902294 902294 2021-03-04 US Michigan Calhoun 26025 9753 235 0 9518 42.24633834 -85.00493569 2021-03-05 05:26: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]);