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 rows where country_or_region = "US", "last_update" is on date 2021-11-13 and province_or_state = "Michigan" sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-11-12 US Michigan Alcona 26001 1220 47 0   44.6846864 -83.59507875 2021-11-13 04:21:38 Alcona, Michigan, US
2021-11-12 US Michigan Alger 26003 901 9 0   46.41292944 -86.60260122 2021-11-13 04:21:38 Alger, Michigan, US
2021-11-12 US Michigan Allegan 26005 16069 201 0   42.59147037 -85.89102866 2021-11-13 04:21:38 Allegan, Michigan, US
2021-11-12 US Michigan Alpena 26007 3569 78 0   45.03477666 -83.62212411 2021-11-13 04:21:38 Alpena, Michigan, US
2021-11-12 US Michigan Antrim 26009 2577 38 0   44.99690221 -85.15503082 2021-11-13 04:21:38 Antrim, Michigan, US
2021-11-12 US Michigan Arenac 26011 1934 38 0   44.0636262 -83.89277559 2021-11-13 04:21:38 Arenac, Michigan, US
2021-11-12 US Michigan Baraga 26013 1300 46 0   46.6720582 -88.36363591 2021-11-13 04:21:38 Baraga, Michigan, US
2021-11-12 US Michigan Barry 26015 8591 92 0   42.59513984 -85.30834519 2021-11-13 04:21:38 Barry, Michigan, US
2021-11-12 US Michigan Bay 26017 15870 407 0   43.70639106 -83.98731479 2021-11-13 04:21:38 Bay, Michigan, US
2021-11-12 US Michigan Benzie 26019 1814 41 0   44.63899297 -86.01608482 2021-11-13 04:21:38 Benzie, Michigan, US
2021-11-12 US Michigan Berrien 26021 20155 336 0   41.95447397 -86.41313079999998 2021-11-13 04:21:38 Berrien, Michigan, US
2021-11-12 US Michigan Branch 26023 6951 114 0   41.91600556 -85.05929476 2021-11-13 04:21:38 Branch, Michigan, US
2021-11-12 US Michigan Calhoun 26025 19907 364 0   42.24633834 -85.00493569 2021-11-13 04:21:38 Calhoun, Michigan, US
2021-11-12 US Michigan Cass 26027 7498 95 0   41.91522292 -85.99405727 2021-11-13 04:21:38 Cass, Michigan, US
2021-11-12 US Michigan Charlevoix 26029 2744 38 0   45.37790017 -85.19614053 2021-11-13 04:21:38 Charlevoix, Michigan, US
2021-11-12 US Michigan Cheboygan 26031 3062 71 0   45.44787015 -84.50122149 2021-11-13 04:21:38 Cheboygan, Michigan, US
2021-11-12 US Michigan Chippewa 26033 4088 52 0   46.29552653 -84.54353449 2021-11-13 04:21:38 Chippewa, Michigan, US
2021-11-12 US Michigan Clare 26035 4176 110 0   43.98794227 -84.84819859999998 2021-11-13 04:21:38 Clare, Michigan, US
2021-11-12 US Michigan Clinton 26037 11080 121 0   42.94400871 -84.60145248 2021-11-13 04:21:38 Clinton, Michigan, US
2021-11-12 US Michigan Crawford 26039 1507 17 0   44.68255561 -84.61006219 2021-11-13 04:21:38 Crawford, Michigan, US
2021-11-12 US Michigan Delta 26041 6146 111 0   45.90484910000001 -86.9080745 2021-11-13 04:21:38 Delta, Michigan, US
2021-11-12 US Michigan Dickinson 26043 4245 84 0   46.00999672 -87.86961634 2021-11-13 04:21:38 Dickinson, Michigan, US
2021-11-12 US Michigan Eaton 26045 14371 254 0   42.59599185 -84.83740035 2021-11-13 04:21:38 Eaton, Michigan, US
2021-11-12 US Michigan Emmet 26047 3663 53 0   45.52625509 -84.89083249 2021-11-13 04:21:38 Emmet, Michigan, US
2021-11-12 US Michigan Federal Correctional Institution (FCI)   321 5 0   47.63197653 0.0 2021-11-13 04:21:38 Federal Correctional Institution (FCI), Michigan, US
2021-11-12 US Michigan Genesee 26049 55652 1114 0   43.02244215 -83.70589709 2021-11-13 04:21:38 Genesee, Michigan, US
2021-11-12 US Michigan Gladwin 26051 3510 79 0   43.98901072 -84.38774817 2021-11-13 04:21:38 Gladwin, Michigan, US
2021-11-12 US Michigan Gogebic 26053 1908 54 0   46.40862701 -89.69377193 2021-11-13 04:21:38 Gogebic, Michigan, US
2021-11-12 US Michigan Grand Traverse 26055 9716 122 0   44.69565625 -85.55585247 2021-11-13 04:21:38 Grand Traverse, Michigan, US
2021-11-12 US Michigan Gratiot 26057 6414 133 0   43.29265605 -84.60505416 2021-11-13 04:21:38 Gratiot, Michigan, US
2021-11-12 US Michigan Hillsdale 26059 6661 132 0   41.88753639 -84.59312019 2021-11-13 04:21:38 Hillsdale, Michigan, US
2021-11-12 US Michigan Houghton 26061 4658 56 0   46.89988536 -88.68495385 2021-11-13 04:21:38 Houghton, Michigan, US
2021-11-12 US Michigan Huron 26063 5211 97 0   43.83353985 -83.04078453 2021-11-13 04:21:38 Huron, Michigan, US
2021-11-12 US Michigan Ingham 26065 33188 471 0   42.59716886 -84.37472069 2021-11-13 04:21:38 Ingham, Michigan, US
2021-11-12 US Michigan Ionia 26067 9566 108 0   42.94502238 -85.07413319 2021-11-13 04:21:38 Ionia, Michigan, US
2021-11-12 US Michigan Iosco 26069 3263 98 0   44.35486835 -83.63484895 2021-11-13 04:21:38 Iosco, Michigan, US
2021-11-12 US Michigan Iron 26071 1547 61 0   46.20974132 -88.53136251 2021-11-13 04:21:38 Iron, Michigan, US
2021-11-12 US Michigan Isabella 26073 9677 137 0   43.64060976 -84.84664923 2021-11-13 04:21:38 Isabella, Michigan, US
2021-11-12 US Michigan Jackson 26075 22777 351 0   42.24807035 -84.42258681 2021-11-13 04:21:38 Jackson, Michigan, US
2021-11-12 US Michigan Kalamazoo 26077 31590 472 0   42.24542231 -85.53038622 2021-11-13 04:21:38 Kalamazoo, Michigan, US
2021-11-12 US Michigan Kalkaska 26079 1913 40 0   44.68512729 -85.09085699 2021-11-13 04:21:38 Kalkaska, Michigan, US
2021-11-12 US Michigan Kent 26081 99489 1027 0   43.03197711 -85.54934642 2021-11-13 04:21:38 Kent, Michigan, US
2021-11-12 US Michigan Keweenaw 26083 304 6 0   47.63197653 -88.41434263 2021-11-13 04:21:38 Keweenaw, Michigan, US
2021-11-12 US Michigan Lake 26085 1045 24 0   43.99050893 -85.802173 2021-11-13 04:21:38 Lake, Michigan, US
2021-11-12 US Michigan Lapeer 26087 12271 254 0   43.09052506 -83.22153148 2021-11-13 04:21:38 Lapeer, Michigan, US
2021-11-12 US Michigan Leelanau 26089 1826 26 0   44.94430054 -85.80150326 2021-11-13 04:21:38 Leelanau, Michigan, US
2021-11-12 US Michigan Lenawee 26091 14363 205 0   41.89475156 -84.06603727 2021-11-13 04:21:38 Lenawee, Michigan, US
2021-11-12 US Michigan Livingston 26093 25305 256 0   42.60302282 -83.91297209 2021-11-13 04:21:38 Livingston, Michigan, US
2021-11-12 US Michigan Luce 26095 795 5 0   46.47227431 -85.54471223 2021-11-13 04:21:38 Luce, Michigan, US
2021-11-12 US Michigan Mackinac 26097 1389 12 0   46.07028979 -85.04980537 2021-11-13 04:21:38 Mackinac, Michigan, US
2021-11-12 US Michigan Macomb 26099 128312 2764 0   42.69158356 -82.92752801 2021-11-13 04:21:38 Macomb, Michigan, US
2021-11-12 US Michigan Manistee 26101 1877 39 0   44.33352407 -86.05626916 2021-11-13 04:21:38 Manistee, Michigan, US
2021-11-12 US Michigan Marquette 26103 7667 85 0   46.4338914 -87.64043701 2021-11-13 04:21:38 Marquette, Michigan, US
2021-11-12 US Michigan Mason 26105 3524 50 0   43.99509218 -86.24988902 2021-11-13 04:21:38 Mason, Michigan, US
2021-11-12 US Michigan Mecosta 26107 5113 53 0   43.64064262 -85.32463223 2021-11-13 04:21:38 Mecosta, Michigan, US
2021-11-12 US Michigan Menominee 26109 3577 52 0   45.58038692 -87.55370409 2021-11-13 04:21:38 Menominee, Michigan, US
2021-11-12 US Michigan Michigan Department of Corrections (MDOC)   27757 154 0   47.63197653 0.0 2021-11-13 04:21:38 Michigan Department of Corrections (MDOC), Michigan, US
2021-11-12 US Michigan Midland 26111 11092 149 0   43.64330771 -84.38804374 2021-11-13 04:21:38 Midland, Michigan, US
2021-11-12 US Michigan Missaukee 26113 1948 41 0   44.33772443 -85.09256478 2021-11-13 04:21:38 Missaukee, Michigan, US
2021-11-12 US Michigan Monroe 26115 21952 314 0   41.92734151 -83.53749864 2021-11-13 04:21:38 Monroe, Michigan, US
2021-11-12 US Michigan Montcalm 26117 9402 134 0   43.31082541 -85.15252824 2021-11-13 04:21:38 Montcalm, Michigan, US
2021-11-12 US Michigan Montmorency 26119 1123 32 0   45.0275929 -84.12696227 2021-11-13 04:21:38 Montmorency, Michigan, US
2021-11-12 US Michigan Muskegon 26121 23131 425 0   43.29123859 -86.15176712 2021-11-13 04:21:38 Muskegon, Michigan, US
2021-11-12 US Michigan Newaygo 26123 7076 85 0   43.554373999999996 -85.80070107 2021-11-13 04:21:38 Newaygo, Michigan, US
2021-11-12 US Michigan Oakland 26125 154178 2729 0   42.66090111 -83.38595416 2021-11-13 04:21:38 Oakland, Michigan, US
2021-11-12 US Michigan Oceana 26127 3979 71 0   43.64124435 -86.26726673 2021-11-13 04:21:38 Oceana, Michigan, US
2021-11-12 US Michigan Ogemaw 26129 2871 68 0   44.33481032 -84.12725175 2021-11-13 04:21:38 Ogemaw, Michigan, US
2021-11-12 US Michigan Ontonagon 26131 660 23 0   46.665226200000006 -89.31390481 2021-11-13 04:21:38 Ontonagon, Michigan, US
2021-11-12 US Michigan Osceola 26133 3284 47 0   43.98992088 -85.32566756 2021-11-13 04:21:38 Osceola, Michigan, US
2021-11-12 US Michigan Oscoda 26135 1029 40 0   44.68192279 -84.12939244 2021-11-13 04:21:38 Oscoda, Michigan, US
2021-11-12 US Michigan Otsego 26137 3574 61 0   45.02085831 -84.59898295 2021-11-13 04:21:38 Otsego, Michigan, US
2021-11-12 US Michigan Ottawa 26139 44467 527 0   42.95996803 -85.9969107 2021-11-13 04:21:38 Ottawa, Michigan, US
2021-11-12 US Michigan Out of MI 80026 2516 24 0   47.63197653 0.0 2021-11-13 04:21:38 Out of MI, Michigan, US
2021-11-12 US Michigan Presque Isle 26141 1494 41 0   45.34018577 -83.91498656 2021-11-13 04:21:38 Presque Isle, Michigan, US
2021-11-12 US Michigan Roscommon 26143 2882 71 0   44.33473082 -84.61067651 2021-11-13 04:21:38 Roscommon, Michigan, US
2021-11-12 US Michigan Saginaw 26145 29191 683 0   43.33433923 -84.05131209999998 2021-11-13 04:21:38 Saginaw, Michigan, US
2021-11-12 US Michigan Sanilac 26151 5336 139 0   43.42406072 -82.82055898 2021-11-13 04:21:38 Sanilac, Michigan, US
2021-11-12 US Michigan Schoolcraft 26153 912 6 0   46.19235734 -86.19972234 2021-11-13 04:21:38 Schoolcraft, Michigan, US
2021-11-12 US Michigan Shiawassee 26155 9569 136 0   42.95392800000001 -84.14585902 2021-11-13 04:21:38 Shiawassee, Michigan, US
2021-11-12 US Michigan St. Clair 26147 23719 532 0   42.92655373 -82.67937954 2021-11-13 04:21:38 St. Clair, Michigan, US
2021-11-12 US Michigan St. Joseph 26149 9014 122 0   41.91441767 -85.52797979 2021-11-13 04:21:38 St. Joseph, Michigan, US
2021-11-12 US Michigan Tuscola 26157 7994 204 0   43.46606813 -83.41897025 2021-11-13 04:21:38 Tuscola, Michigan, US
2021-11-12 US Michigan Unassigned 90026 48 1 0   47.63197653 0.0 2021-11-13 04:21:38 Unassigned, Michigan, US
2021-11-12 US Michigan Van Buren 26159 9896 169 0   42.25190229 -86.01939087 2021-11-13 04:21:38 Van Buren, Michigan, US
2021-11-12 US Michigan Washtenaw 26161 35347 332 0   42.253105 -83.83853204 2021-11-13 04:21:38 Washtenaw, Michigan, US
2021-11-12 US Michigan Wayne 26163 209535 5685 0   42.28098405 -83.281255 2021-11-13 04:21:38 Wayne, Michigan, US
2021-11-12 US Michigan Wexford 26165 4025 58 0   44.33853602 -85.57712739 2021-11-13 04:21:38 Wexford, Michigan, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;