Context

COVID-19 is on a rise worldwide. It was first identified in the city of Wuhan in China in 2019 and has now spread into a global pandemic. Michigan is currently the third largest affected state in USA. The state's confirmed cases have been on a rise since early March 2020. In this dire time, it is extremely important to understand the factors affecting the spread of the virus in Michigan, identify susceptible population and predict the trajectory of the infected and dead cases on a daily basis.

Content

Update: April 4, 2020 2:00 PM Eastern Standard Time (EST)

This data currently contains information about COVID-19 confirmed cases (14225) and deaths (540) in Michigan counties. The dataset also includes percentage of COVID-19 confirmed and dead cases by age, gender, race and ethnicity. The information is published by www.michigan.gov on a daily basis at 2:00 PM EST. The results are included as of 10:00 AM every day.

Acknowledgements

Michigan.gov - Coronavirus

Inspiration

1. This dataset will be useful in understanding and predicting the trajectory of the infected and dead cases in Michigan in the coming days.
2. The dataset can also give insight about the most vulnerable age groups in Michigan.

Please consider upvoting if the data is found useful in any way. If there are any improvement suggestions, do let me know.

After over two years of public reporting, the State Profile Report will no longer be produced and distributed after February 2023. The final release was on February 23, 2023. We want to thank everyone who contributed to the design, production, and review of this report and we hope that it provided insight into the data trends throughout the COVID-19 pandemic. Data about COVID-19 will continue to be updated at CDC’s COVID Data Tracker.

The State Profile Report (SPR) is generated by the Data Strategy and Execution Workgroup in the Joint Coordination Cell, in collaboration with the White House. It is managed by an interagency team with representatives from multiple agencies and offices (including the United States Department of Health and Human Services (HHS), the Centers for Disease Control and Prevention, the HHS Assistant Secretary for Preparedness and Response, and the Indian Health Service). The SPR provides easily interpretable information on key indicators for each state, down to the county level.

It is a weekly snapshot in time that:

• Focuses on recent outcomes in the last seven days and changes relative to the month prior
• Provides additional contextual information at the county level for each state, and includes national level information
• Supports rapid visual interpretation of results with color thresholds

The New York Times is releasing a series of data files with cumulative counts of coronavirus cases in the United States, at the state and county level, over time. We are compiling this time series data from state and local governments and health departments in an attempt to provide a complete record of the ongoing outbreak.

Since late January, The Times has tracked cases of coronavirus in real time as they were identified after testing. Because of the widespread shortage of testing, however, the data is necessarily limited in the picture it presents of the outbreak.

We have used this data to power our maps and reporting tracking the outbreak, and it is now being made available to the public in response to requests from researchers, scientists and government officials who would like access to the data to better understand the outbreak.

The data begins with the first reported coronavirus case in Washington State on Jan. 21, 2020. We will publish regular updates to the data in this repository.

Reporting of new Aggregate Case and Death Count data was discontinued May 11, 2023, with the expiration of the COVID-19 public health emergency declaration. This dataset will receive a final update on June 1, 2023, to reconcile historical data through May 10, 2023, and will remain publicly available.

Aggregate Data Collection Process Since the start of the COVID-19 pandemic, data have been gathered through a robust process with the following steps:

• A CDC data team reviews and validates the information obtained from jurisdictions’ state and local websites via an overnight data review process.
• If more than one official county data source exists, CDC uses a comprehensive data selection process comparing each official county data source, and takes the highest case and death counts respectively, unless otherwise specified by the state.
• CDC compiles these data and posts the finalized information on COVID Data Tracker.
• County level data is aggregated to obtain state and territory specific totals.

This process is collaborative, with CDC and jurisdictions working together to ensure the accuracy of COVID-19 case and death numbers. County counts provide the most up-to-date numbers on cases and deaths by report date. CDC may retrospectively update counts to correct data quality issues.

Methodology Changes Several differences exist between the current, weekly-updated dataset and the archived version:

• Source: The current Weekly-Updated Version is based on county-level aggregate count data, while the Archived Version is based on State-level aggregate count data.
• Confirmed/Probable Cases/Death breakdown:  While the probable cases and deaths are included in the total case and total death counts in both versions (if applicable), they were reported separately from the confirmed cases and deaths by jurisdiction in the Archived Version.  In the current Weekly-Updated Version, the counts by jurisdiction are not reported by confirmed or probable status (See Confirmed and Probable Counts section for more detail).
• Time Series Frequency: The current Weekly-Updated Version contains weekly time series data (i.e., one record per week per jurisdiction), while the Archived Version contains daily time series data (i.e., one record per day per jurisdiction).
• Update Frequency: The current Weekly-Updated Version is updated weekly, while the Archived Version was updated twice daily up to October 20, 2022.

Important note: The counts reflected during a given time period in this dataset may not match the counts reflected for the same time period in the archived dataset noted above. Discrepancies may exist due to differences between county and state COVID-19 case surveillance and reconciliation efforts.

Confirmed and Probable Counts In this dataset, counts by jurisdiction are not displayed by confirmed or probable status. Instead, confirmed and probable cases and deaths are included in the Total Cases and Total Deaths columns, when available. Not all jurisdictions report probable cases and deaths to CDC.* Confirmed and probable case definition criteria are described here:

Council of State and Territorial Epidemiologists (ymaws.com).

Deaths CDC reports death data on other sections of the website: CDC COVID Data Tracker: Home, CDC COVID Data Tracker: Cases, Deaths, and Testing, and NCHS Provisional Death Counts. Information presented on the COVID Data Tracker pages is based on the same source (total case counts) as the present dataset; however, NCHS Death Counts are based on death certificates that use information reported by physicians, medical examiners, or coroners in the cause-of-death section of each certificate. Data from each of these pages are considered provisional (not complete and pending verification) and are therefore subject to change. Counts from previous weeks are continually revised as more records are received and processed.

Number of Jurisdictions Reporting There are currently 60 public health jurisdictions reporting cases of COVID-19. This includes the 50 states, the District of Columbia, New York City, the U.S. territories of American Samoa, Guam, the Commonwealth of the Northern Mariana Islands, Puerto Rico, and the U.S Virgin Islands as well as three independent countries in compacts of free association with the United States, Federated States of Micronesia, Republic of the Marshall Islands, and Republic of Palau. New York State’s reported case and death counts do not include New York City’s counts as they separately report nationally notifiable conditions to CDC.

CDC COVID-19 data are available to the public as summary or aggregate count files, including total counts of cases and deaths, available by state and by county. These and other data on COVID-19 are available from multiple public locations, such as:

https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/cases-in-us.html

https://www.cdc.gov/covid-data-tracker/index.html

https://www.cdc.gov/coronavirus/2019-ncov/covid-data/covidview/index.html

https://www.cdc.gov/coronavirus/2019-ncov/php/open-america/surveillance-data-analytics.html

Additional COVID-19 public use datasets, include line-level (patient-level) data, are available at: https://data.cdc.gov/browse?tags=covid-19.

Archived Data Notes:

November 3, 2022: Due to a reporting cadence issue, case rates for Missouri counties are calculated based on 11 days’ worth of case count data in the Weekly United States COVID-19 Cases and Deaths by State data released on November 3, 2022, instead of the customary 7 days’ worth of data.

November 10, 2022: Due to a reporting cadence change, case rates for Alabama counties are calculated based on 13 days’ worth of case count data in the Weekly United States COVID-19 Cases and Deaths by State data released on November 10, 2022, instead of the customary 7 days’ worth of data.

November 10, 2022: Per the request of the jurisdiction, cases and deaths among non-residents have been removed from all Hawaii county totals throughout the entire time series. Cumulative case and death counts reported by CDC will no longer match Hawaii’s COVID-19 Dashboard, which still includes non-resident cases and deaths. 

November 17, 2022: Two new columns, weekly historic cases and weekly historic deaths, were added to this dataset on November 17, 2022. These columns reflect case and death counts that were reported that week but were historical in nature and not reflective of the current burden within the jurisdiction. These historical cases and deaths are not included in the new weekly case and new weekly death columns; however, they are reflected in the cumulative totals provided for each jurisdiction. These data are used to account for artificial increases in case and death totals due to batched reporting of historical data.

December 1, 2022: Due to cadence changes over the Thanksgiving holiday, case rates for all Ohio counties are reported as 0 in the data released on December 1, 2022.

January 5, 2023: Due to North Carolina’s holiday reporting cadence, aggregate case and death data will contain 14 days’ worth of data instead of the customary 7 days. As a result, case and death metrics will appear higher than expected in the January 5, 2023, weekly release.

January 12, 2023: Due to data processing delays, Mississippi’s aggregate case and death data will be reported as 0. As a result, case and death metrics will appear lower than expected in the January 12, 2023, weekly release.

January 19, 2023: Due to a reporting cadence issue, Mississippi’s aggregate case and death data will be calculated based on 14 days’ worth of data instead of the customary 7 days in the January 19, 2023, weekly release.

January 26, 2023: Due to a reporting backlog of historic COVID-19 cases, case rates for two Michigan counties (Livingston and Washtenaw) were higher than expected in the January 19, 2023 weekly release.

January 26, 2023: Due to a backlog of historic COVID-19 cases being reported this week, aggregate case and death counts in Charlotte County and Sarasota County, Florida, will appear higher than expected in the January 26, 2023 weekly release.

January 26, 2023: Due to data processing delays, Mississippi’s aggregate case and death data will be reported as 0 in the weekly release posted on January 26, 2023.

February 2, 2023: As of the data collection deadline, CDC observed an abnormally large increase in aggregate COVID-19 cases and deaths reported for Washington State. In response, totals for new cases and new deaths released on February 2, 2023, have been displayed as zero at the state level until the issue is addressed with state officials. CDC is working with state officials to address the issue.

February 2, 2023: Due to a decrease reported in cumulative case counts by Wyoming, case rates will be reported as 0 in the February 2, 2023, weekly release. CDC is working with state officials to verify the data submitted.

February 16, 2023: Due to data processing delays, Utah’s aggregate case and death data will be reported as 0 in the weekly release posted on February 16, 2023. As a result, case and death metrics will appear lower than expected and should be interpreted with caution.

February 16, 2023: Due to a reporting cadence change, Maine’s

As of March 10, 2023, the death rate from COVID-19 in the state of New York was 397 per 100,000 people. New York is one of the states with the highest number of COVID-19 cases.

Data published on potential COVID-19 symptoms reported through NHS Pathways and 111 online Dashboard shows the total number of NHS Pathways triages through 111 and 999, and online assessments in 111 online which have received a potential COVID-19 final disposition. This data is based on potential COVID-19 symptoms reported by members of the public to NHS Pathways through NHS 111 or 999 and 111 online, and is not based on the outcomes of tests for coronavirus. This is not a count of people.

This file contains COVID-19 death counts and rates by month and year of death, jurisdiction of residence (U.S., HHS Region) and demographic characteristics (sex, age, race and Hispanic origin, and age/race and Hispanic origin). United States death counts and rates include the 50 states, plus the District of Columbia. Deaths with confirmed or presumed COVID-19, coded to ICD–10 code U07.1. Number of deaths reported in this file are the total number of COVID-19 deaths received and coded as of the date of analysis and may not represent all deaths that occurred in that period. Counts of deaths occurring before or after the reporting period are not included in the file. Data during recent periods are incomplete because of the lag in time between when the death occurred and when the death certificate is completed, submitted to NCHS and processed for reporting purposes. This delay can range from 1 week to 8 weeks or more, depending on the jurisdiction and cause of death. Death counts should not be compared across jurisdictions. Data timeliness varies by state. Some states report deaths on a daily basis, while other states report deaths weekly or monthly. The ten (10) United States Department of Health and Human Services (HHS) regions include the following jurisdictions. Region 1: Connecticut, Maine, Massachusetts, New Hampshire, Rhode Island, Vermont; Region 2: New Jersey, New York; Region 3: Delaware, District of Columbia, Maryland, Pennsylvania, Virginia, West Virginia; Region 4: Alabama, Florida, Georgia, Kentucky, Mississippi, North Carolina, South Carolina, Tennessee; Region 5: Illinois, Indiana, Michigan, Minnesota, Ohio, Wisconsin; Region 6: Arkansas, Louisiana, New Mexico, Oklahoma, Texas; Region 7: Iowa, Kansas, Missouri, Nebraska; Region 8: Colorado, Montana, North Dakota, South Dakota, Utah, Wyoming; Region 9: Arizona, California, Hawaii, Nevada; Region 10: Alaska, Idaho, Oregon, Washington. Rates were calculated using the population estimates for 2021, which are estimated as of July 1, 2021 based on the Blended Base produced by the US Census Bureau in lieu of the April 1, 2020 decennial population count. The Blended Base consists of the blend of Vintage 2020 postcensal population estimates, 2020 Demographic Analysis Estimates, and 2020 Census PL 94-171 Redistricting File (see https://www2.census.gov/programs-surveys/popest/technical-documentation/methodology/2020-2021/methods-statement-v2021.pdf). Rate are based on deaths occurring in the specified week and are age-adjusted to the 2000 standard population using the direct method (see https://www.cdc.gov/nchs/data/nvsr/nvsr70/nvsr70-08-508.pdf). These rates differ from annual age-adjusted rates, typically presented in NCHS publications based on a full year of data and annualized weekly age-adjusted rates which have been adjusted to allow comparison with annual rates. Annualization rates presents deaths per year per 100,000 population that would be expected in a year if the observed period specific (weekly) rate prevailed for a full year. Sub-national death counts between 1-9 are suppressed in accordance with NCHS data confidentiality standards. Rates based on death counts less than 20 are suppressed in accordance with NCHS standards of reliability as specified in NCHS Data Presentation Standards for Proportions (available from: https://www.cdc.gov/nchs/data/series/sr_02/sr02_175.pdf.).

With the surge of COVID-19 cases in the United States in the early months of the pandemic, the availability of hospital resources became a concern. To reduce the strain on health systems, it is important to decrease the number of COVID-19 patients requiring hospital care. Since most patients with COVID-19 only develop mild symptoms, remote monitoring and assessment of symptoms of COVID-19 patients at home may help reduce preventable hospital utilization, morbidity, and mortality. Henry Ford Allegiance Health in Jackson, Michigan implemented a nurse-led, telephone-based, active management protocol for patients that tested positive for SARS-CoV-2 at their drive through testing site and who were self-isolating at home. The objective of this retrospective study was to assess the effectiveness of the protocol in reducing hospital utilization by patients who tested positive for SARS-CoV-2 between March 23, 2020 and May 31, 2020. The study included a total of 293 patients, with 154 patients in the pre-implementation group and 139 patients in the post-implementation group. Although the difference in the 30-day probability of hospital utilization between the study groups was not statistically significant, there was a reduction seen in the post-implementation group. The protocol also allowed ongoing assessment of COVID-19 patients with limited in-person interactions, thereby reducing the risk of infection for health care workers. With the increased use of telemedicine, this protocol could be used as a guide for other health systems looking to improve access to care for COVID-19 patients without increasing hospital utilization.

Program Description DoT was founded in 2012 with a mission to increase diversity amongst medical professionals by preparing students from underrepresented communities in Detroit to successfully pursue careers in healthcare. Our program builds on a partnership between Cass Technical High School (CTHS) and the University of Michigan Medical School (UMMS). The CTHS student body is reflective of the Detroit population with more than 80% of students identifying with racial and ethnic minority backgrounds. Students with an interest in healthcare apply for the program as ninth graders. In recent years, the program has received over 60 applications for approximately 30 positions in each grade.

 DoT’s unique strength lies in its longitudinal structure. There are three branches of the program – Foundations (ninth and tenth grade), Rising (eleventh and twelfth grade) and Succeed (undergraduate). Ninth graders start out in DoT Foundations. Each student is paired with a first-year medical student mentor at UMMS for the entire academic year. DoT students travel to UMMS every month for a visit day, with activities designed to give students hands-on experiences in healthcare, such as suturing and ultrasound skills in the simulation center, and clinical shadowing. Students then meet with their medical student mentor over lunch. The latter part of the day is dedicated to working on their capstone projects. For the capstone projects, students work in small teams led by medical student leaders to identify a community health issue, partner with a local organization, and present their proposed solutions at a formal symposium at the end of the year.

;Transition to Virtual Programming In light of the recent COVID-19 pandemic, a growing number of universities cancelled all campus events including those of pipeline programs. We felt that our programming offered an important service to our students that would be greatly missed, so our team worked to quickly create and implement a virtual program. We ensured that each of our students had access to technology at home and those who did not were offered scholarships. During our introductory student session and new parent meeting, our leadership team discussed how to set up a Gmail email address for weekly communications and taught the students how to use Zoom, Google Drive, Google Docs and Google Sheets for online learning collaboration.

 For the virtual Foundations program, we offered 1-hour seminars each month, where a physician was invited to give a 30-minute presentation about different organ systems, followed by a 30-minute case-based session where students worked with medical student mentors to apply their new knowledge. We also created novel sessions such as “The Path to College and Medical School” and collaborated with members of the Black Medical Association (BMA) and Latin American and Native American Medical Association (LANAMA) to host a panel session where students could learn from medical students who identified as URiM. 

 For the mentorship aspect, we created “pods” of Foundations, Rising, and Succeed students along with medical student and physician mentors. The Foundations students and mentors met every month for an hour on Zoom, a virtual communication platform, to work on their Capstone project. Rising and Succeed students joined the group for three full-pod meetings. The goal was to increase near-peer mentorship and connections between DoT students at all levels. ;Study Population 
Due to the virtual nature of the 2020-2021 program, we accepted 100% of 9th grade applicants from CTHS. We also expanded our reach to a new school, The School at Marygrove (TSM), which is also located in Detroit, Michigan. TSM is involved in the Detroit-20 Partnership with the University of Michigan College of Education and includes a novel three-year residency program for novice teachers.

 During the 2020-2021 school year, 108 students participated in the Foundations programming with 72 of them being 9th graders and 36 being 10th graders. The students were mostly from CTHS with 12 students out of the 108 total being from TSM. Students were predominantly from an African American/Black racial background (68.4% from N=98 respondents). The students were representative of their respective schools. The majority of students at CTHS identify as black, come from low-income homes, and have variable levels of parental education.