daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
87,758 rows where country_or_region = "US" and province_or_state = "Michigan" sorted by longitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
These facets timed out: province_or_state
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 | 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 | 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 | 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 | Unassigned | 90026 | 64 | 1 | 0 | 47.63197653 | 0.0 | 2021-12-03 04:23:05 | Unassigned, 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 | 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 | 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 | Unassigned | 90026 | 43 | 0 | 0 | 47.63197653 | 0.0 | 2021-10-29 04:22:03 | Unassigned, 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 | Michigan Department of Corrections (MDOC) | 6510 | 75 | 0 | 6435 | 47.63197653 | 0.0 | 2020-10-26 04:25:02 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-10-25 | US | Michigan | Out of MI | 80026 | 305 | 3 | 0 | 302 | 47.63197653 | 0.0 | 2020-10-26 04:25:02 | Out of MI, Michigan, US |
2020-10-25 | US | Michigan | Unassigned | 90026 | 24 | 0 | 0 | 24 | 47.63197653 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Michigan, US |
2021-01-26 | US | Michigan | Federal Correctional Institution (FCI) | 302 | 5 | 0 | 297 | 47.63197653 | 0.0 | 2021-01-27 05:23:41 | Federal Correctional Institution (FCI), Michigan, US | |
2021-01-26 | US | Michigan | Michigan Department of Corrections (MDOC) | 23495 | 141 | 0 | 23354 | 47.63197653 | 0.0 | 2021-01-27 05:23:41 | Michigan Department of Corrections (MDOC), Michigan, US | |
2021-01-26 | US | Michigan | Out of MI | 80026 | 1911 | 11 | 0 | 1900 | 47.63197653 | 0.0 | 2021-01-27 05:23:41 | Out of MI, Michigan, US |
2021-01-26 | US | Michigan | Unassigned | 90026 | 16 | 0 | 0 | 16 | 47.63197653 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Michigan, US |
2021-09-18 | US | Michigan | Federal Correctional Institution (FCI) | 320 | 5 | 0 | 47.63197653 | 0.0 | 2021-09-19 04:21:34 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-09-18 | US | Michigan | Michigan Department of Corrections (MDOC) | 26859 | 155 | 0 | 47.63197653 | 0.0 | 2021-09-19 04:21:34 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-09-18 | US | Michigan | Out of MI | 80026 | 2111 | 16 | 0 | 47.63197653 | 0.0 | 2021-09-19 04:21:34 | Out of MI, Michigan, US | |
2021-09-18 | US | Michigan | Unassigned | 90026 | 46 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Michigan, US | |
2021-05-28 | US | Michigan | Federal Correctional Institution (FCI) | 316 | 5 | 0 | 47.63197653 | 0.0 | 2021-05-29 04:20:41 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-05-28 | US | Michigan | Michigan Department of Corrections (MDOC) | 26877 | 150 | 0 | 47.63197653 | 0.0 | 2021-05-29 04:20:41 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-05-28 | US | Michigan | Out of MI | 80026 | 1763 | 15 | 0 | 47.63197653 | 0.0 | 2021-05-29 04:20:41 | Out of MI, Michigan, US | |
2021-05-28 | US | Michigan | Unassigned | 90026 | 28 | 0 | 0 | 47.63197653 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Michigan, US | |
2022-03-20 | US | Michigan | Federal Correctional Institution (FCI) | 325 | 5 | 0 | 47.63197653 | 0.0 | 2022-03-21 04:20:50 | Federal Correctional Institution (FCI), Michigan, US | ||
2022-03-20 | US | Michigan | Michigan Department of Corrections (MDOC) | 38284 | 176 | 0 | 47.63197653 | 0.0 | 2022-03-21 04:20:50 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2022-03-20 | US | Michigan | Out of MI | 80026 | 5689 | 39 | 0 | 47.63197653 | 0.0 | 2022-03-21 04:20:50 | Out of MI, Michigan, US | |
2022-03-20 | US | Michigan | Unassigned | 90026 | 15 | 0 | 0 | 47.63197653 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Michigan, US | |
2021-11-11 | US | Michigan | Federal Correctional Institution (FCI) | 321 | 5 | 0 | 47.63197653 | 0.0 | 2021-11-12 04:22:01 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-11-11 | US | Michigan | Michigan Department of Corrections (MDOC) | 27675 | 154 | 0 | 47.63197653 | 0.0 | 2021-11-12 04:22:01 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-11-11 | US | Michigan | Out of MI | 80026 | 2483 | 24 | 0 | 47.63197653 | 0.0 | 2021-11-12 04:22:01 | Out of MI, Michigan, US | |
2021-11-11 | US | Michigan | Unassigned | 90026 | 48 | 2 | 0 | 47.63197653 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Michigan, US | |
2021-08-25 | US | Michigan | Federal Correctional Institution (FCI) | 320 | 5 | 0 | 47.63197653 | 0.0 | 2021-08-26 04:21:28 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-08-25 | US | Michigan | Michigan Department of Corrections (MDOC) | 26815 | 155 | 0 | 47.63197653 | 0.0 | 2021-08-26 04:21:28 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-08-25 | US | Michigan | Out of MI | 80026 | 1884 | 14 | 0 | 47.63197653 | 0.0 | 2021-08-26 04:21:28 | Out of MI, Michigan, US | |
2021-08-25 | US | Michigan | Unassigned | 90026 | 40 | 0 | 0 | 47.63197653 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Michigan, US | |
2021-04-12 | US | Michigan | Federal Correctional Institution (FCI) | 316 | 5 | 0 | 47.63197653 | 0.0 | 2021-04-13 04:20:37 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-04-12 | US | Michigan | Michigan Department of Corrections (MDOC) | 26172 | 152 | 0 | 47.63197653 | 0.0 | 2021-04-13 04:20:37 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-04-12 | US | Michigan | Out of MI | 80026 | 1749 | 13 | 0 | 47.63197653 | 0.0 | 2021-04-13 04:20:37 | Out of MI, Michigan, US | |
2021-04-12 | US | Michigan | Unassigned | 90026 | 19 | 0 | 0 | 47.63197653 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Michigan, US | |
2020-04-13 | US | Michigan | Federal Correctional Institution (FCI) | 21 | 0 | 0 | 21 | 47.63197653 | 0.0 | 2020-04-13 23:07:54 | Federal Correctional Institution (FCI), Michigan, US | |
2020-04-13 | US | Michigan | Michigan Department of Corrections (MDOC) | 370 | 8 | 0 | 362 | 47.63197653 | 0.0 | 2020-04-13 23:07:54 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-04-13 | US | Michigan | Out of MI | 148 | 1 | 0 | 147 | 47.63197653 | 0.0 | 2020-04-13 23:07:54 | Out of MI, Michigan, US | |
2020-04-13 | US | Michigan | Unassigned | 90026 | 78 | 4 | 0 | 74 | 47.63197653 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Michigan, US |
2021-11-02 | US | Michigan | Federal Correctional Institution (FCI) | 321 | 5 | 0 | 47.63197653 | 0.0 | 2021-11-03 06:22:09 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-11-02 | US | Michigan | Michigan Department of Corrections (MDOC) | 27470 | 154 | 0 | 47.63197653 | 0.0 | 2021-11-03 06:22:09 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-11-02 | US | Michigan | Out of MI | 80026 | 2431 | 24 | 0 | 47.63197653 | 0.0 | 2021-11-03 06:22:09 | Out of MI, Michigan, US | |
2021-11-02 | US | Michigan | Unassigned | 90026 | 67 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Michigan, US | |
2020-04-17 | US | Michigan | Federal Correctional Institution (FCI) | 44 | 0 | 0 | 44 | 47.63197653 | 0.0 | 2020-04-17 23:30:52 | Federal Correctional Institution (FCI), Michigan, US | |
2020-04-17 | US | Michigan | Michigan Department of Corrections (MDOC) | 514 | 15 | 0 | 499 | 47.63197653 | 0.0 | 2020-04-17 23:30:52 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-04-17 | US | Michigan | Out of MI | 80026 | 71 | 2 | 0 | 69 | 47.63197653 | 0.0 | 2020-04-17 23:30:52 | Out of MI, Michigan, US |
2020-04-17 | US | Michigan | Unassigned | 90026 | 46 | 4 | 0 | 42 | 47.63197653 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Michigan, US |
2021-05-29 | US | Michigan | Federal Correctional Institution (FCI) | 316 | 5 | 0 | 47.63197653 | 0.0 | 2021-05-30 04:20:55 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-05-29 | US | Michigan | Michigan Department of Corrections (MDOC) | 26882 | 150 | 0 | 47.63197653 | 0.0 | 2021-05-30 04:20:55 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-05-29 | US | Michigan | Out of MI | 80026 | 1764 | 15 | 0 | 47.63197653 | 0.0 | 2021-05-30 04:20:55 | Out of MI, Michigan, US | |
2021-05-29 | US | Michigan | Unassigned | 90026 | 31 | 0 | 0 | 47.63197653 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Michigan, US | |
2021-03-07 | US | Michigan | Federal Correctional Institution (FCI) | 314 | 5 | 0 | 47.63197653 | 0.0 | 2021-03-08 05:24:48 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-03-07 | US | Michigan | Michigan Department of Corrections (MDOC) | 24994 | 148 | 0 | 47.63197653 | 0.0 | 2021-03-08 05:24:48 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-03-07 | US | Michigan | Out of MI | 80026 | 1502 | 11 | 0 | 47.63197653 | 0.0 | 2021-03-08 05:24:48 | Out of MI, Michigan, US | |
2021-03-07 | US | Michigan | Unassigned | 90026 | 19 | 0 | 0 | 47.63197653 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Michigan, US | |
2020-07-23 | US | Michigan | Federal Correctional Institution (FCI) | 189 | 5 | 0 | 184 | 47.63197653 | 0.0 | 2020-07-24 05:30:40 | Federal Correctional Institution (FCI), Michigan, US | |
2020-07-23 | US | Michigan | Michigan Department of Corrections (MDOC) | 4120 | 68 | 0 | 4052 | 47.63197653 | 0.0 | 2020-07-24 05:30:40 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-07-23 | US | Michigan | Out of MI | 80026 | 53 | 0 | 0 | 53 | 47.63197653 | 0.0 | 2020-07-24 05:30:40 | Out of MI, Michigan, US |
2020-07-23 | US | Michigan | Unassigned | 90026 | 8 | 0 | 0 | 8 | 47.63197653 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Michigan, US |
2022-11-12 | US | Michigan | Federal Correctional Institution (FCI) | 329 | 5 | 0 | 47.63197653 | 0.0 | 2022-11-13 04:21:14 | Federal Correctional Institution (FCI), Michigan, US | ||
2022-11-12 | US | Michigan | Michigan Department of Corrections (MDOC) | 41170 | 180 | 0 | 47.63197653 | 0.0 | 2022-11-13 04:21:14 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2022-11-12 | US | Michigan | Out of MI | 80026 | 8744 | 52 | 0 | 47.63197653 | 0.0 | 2022-11-13 04:21:14 | Out of MI, Michigan, US | |
2022-11-12 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Michigan, US | |
2021-09-01 | US | Michigan | Federal Correctional Institution (FCI) | 320 | 5 | 0 | 47.63197653 | 0.0 | 2021-09-02 04:21:15 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-09-01 | US | Michigan | Michigan Department of Corrections (MDOC) | 26821 | 155 | 0 | 47.63197653 | 0.0 | 2021-09-02 04:21:15 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-09-01 | US | Michigan | Out of MI | 80026 | 1944 | 16 | 0 | 47.63197653 | 0.0 | 2021-09-02 04:21:15 | Out of MI, Michigan, US | |
2021-09-01 | US | Michigan | Unassigned | 90026 | 33 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Michigan, US | |
2022-02-07 | US | Michigan | Federal Correctional Institution (FCI) | 324 | 5 | 0 | 47.63197653 | 0.0 | 2022-02-08 04:21:15 | Federal Correctional Institution (FCI), Michigan, US | ||
2022-02-07 | US | Michigan | Michigan Department of Corrections (MDOC) | 36715 | 173 | 0 | 47.63197653 | 0.0 | 2022-02-08 04:21:15 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2022-02-07 | US | Michigan | Out of MI | 80026 | 5784 | 37 | 0 | 47.63197653 | 0.0 | 2022-02-08 04:21:15 | Out of MI, Michigan, US | |
2022-02-07 | US | Michigan | Unassigned | 90026 | 6 | 0 | 0 | 47.63197653 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Michigan, US | |
2020-12-03 | US | Michigan | Federal Correctional Institution (FCI) | 200 | 5 | 0 | 195 | 47.63197653 | 0.0 | 2020-12-04 05:27:27 | Federal Correctional Institution (FCI), Michigan, US | |
2020-12-03 | US | Michigan | Michigan Department of Corrections (MDOC) | 13584 | 93 | 0 | 13491 | 47.63197653 | 0.0 | 2020-12-04 05:27:27 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-12-03 | US | Michigan | Out of MI | 80026 | 1116 | 7 | 0 | 1109 | 47.63197653 | 0.0 | 2020-12-04 05:27:27 | Out of MI, Michigan, US |
2020-12-03 | US | Michigan | Unassigned | 90026 | 46 | 0 | 0 | 46 | 47.63197653 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Michigan, US |
2020-10-14 | US | Michigan | Federal Correctional Institution (FCI) | 195 | 5 | 0 | 190 | 47.63197653 | 0.0 | 2020-10-15 04:24:28 | Federal Correctional Institution (FCI), Michigan, US | |
2020-10-14 | US | Michigan | Michigan Department of Corrections (MDOC) | 5796 | 75 | 0 | 5721 | 47.63197653 | 0.0 | 2020-10-15 04:24:28 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-10-14 | US | Michigan | Out of MI | 80026 | 224 | 2 | 0 | 222 | 47.63197653 | 0.0 | 2020-10-15 04:24:28 | Out of MI, Michigan, US |
2020-10-14 | US | Michigan | Unassigned | 90026 | 9 | 0 | 0 | 9 | 47.63197653 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Michigan, US |
2021-05-25 | US | Michigan | Federal Correctional Institution (FCI) | 316 | 5 | 0 | 47.63197653 | 0.0 | 2021-05-26 04:20:35 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-05-25 | US | Michigan | Michigan Department of Corrections (MDOC) | 26855 | 150 | 0 | 47.63197653 | 0.0 | 2021-05-26 04:20:35 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-05-25 | US | Michigan | Out of MI | 80026 | 2060 | 16 | 0 | 47.63197653 | 0.0 | 2021-05-26 04:20:35 | Out of MI, Michigan, US | |
2021-05-25 | US | Michigan | Unassigned | 90026 | 19 | 0 | 0 | 47.63197653 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Michigan, US | |
2021-11-09 | US | Michigan | Federal Correctional Institution (FCI) | 321 | 5 | 0 | 47.63197653 | 0.0 | 2021-11-10 04:21:38 | Federal Correctional Institution (FCI), Michigan, US | ||
2021-11-09 | US | Michigan | Michigan Department of Corrections (MDOC) | 27593 | 153 | 0 | 47.63197653 | 0.0 | 2021-11-10 04:21:38 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2021-11-09 | US | Michigan | Out of MI | 80026 | 2472 | 24 | 0 | 47.63197653 | 0.0 | 2021-11-10 04:21:38 | Out of MI, Michigan, US | |
2021-11-09 | US | Michigan | Unassigned | 90026 | 44 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Michigan, US | |
2022-07-23 | US | Michigan | Federal Correctional Institution (FCI) | 328 | 5 | 0 | 47.63197653 | 0.0 | 2022-07-24 04:20:47 | Federal Correctional Institution (FCI), Michigan, US | ||
2022-07-23 | US | Michigan | Michigan Department of Corrections (MDOC) | 38922 | 177 | 0 | 47.63197653 | 0.0 | 2022-07-24 04:20:47 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2022-07-23 | US | Michigan | Out of MI | 80026 | 7201 | 43 | 0 | 47.63197653 | 0.0 | 2022-07-24 04:20:47 | Out of MI, Michigan, US | |
2022-07-23 | US | Michigan | Unassigned | 90026 | 15 | 0 | 0 | 47.63197653 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Michigan, US | |
2020-08-04 | US | Michigan | Federal Correctional Institution (FCI) | 194 | 5 | 0 | 189 | 47.63197653 | 0.0 | 2020-08-05 04:34:43 | Federal Correctional Institution (FCI), Michigan, US | |
2020-08-04 | US | Michigan | Michigan Department of Corrections (MDOC) | 4237 | 69 | 0 | 4168 | 47.63197653 | 0.0 | 2020-08-05 04:34:43 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-08-04 | US | Michigan | Out of MI | 80026 | 116 | 0 | 0 | 116 | 47.63197653 | 0.0 | 2020-08-05 04:34:43 | Out of MI, Michigan, US |
2020-08-04 | US | Michigan | Unassigned | 90026 | 4 | 0 | 0 | 4 | 47.63197653 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;