The following plots offer two alternative perspectives to the reported mortality data shared on the state comparison page. Those data are based on mortality reports, which could be off by days, weeks, or even months from the actual date of death. These data are based on provisional data that reflect the actual date of death. We can use these data to explore differences between report date and actual date of death as well as excess mortality.
A routine criticism of mortality data during the COVID-19 pandemic has been that they do not accurately reflect current temporal trends because deaths are often reported weeks or months after they occur. While the reported data do not perfectly match the actual death trend, they are also not radically different for much of the course of the pandemic to this point.
“Excess deaths” refer to deaths that occur beyond what we would expect in a given time period. This plot shows a forecast of mortality based on all-cause mortality dating back to 1999. The difference between the red line (provisional mortality during COVID-19) and the forecast suggests the burden of excess death experienced during the COVID-19 pandemic. These plots are created and maintained by Timothy Wiemken, Ph.D.
Both excess mortality plots below use the same fundamental data - all-cause mortality data from the CDC as well as the State of Missouri. We forecast mortality during the pandemic using all-cause mortality data dating back to 1999, and then overlay the provisional observed mortality during the COVID-19 pandemic in red. The confidence bands highlight the estimated amount of uncertainty in the forecast. 80 out of 100 estimates fall within the 80% confidence band, while 95 out of 100 estimates fall in the 95% band. By comparing the red line to the forecast trend as well as the confidence bands, we can get a sense of where the observed (but provisional) mortality trend fits within the forecast’s expected variation.
All-cause mortality data in Missouri from January 1, 1999 through December 2018 were gathered from CDC WONDER grouped by month.
Provisional all-cause mortality from January 2019-Present were gathered from The Missouri Department of Health & Senior Services Vital Statistics.
Analysis is conducted using the Seasonal and Trend decomposition using Loess Forecasting model, as implemented in the Forecast package in R.
Forecasting is done on data from January 1999 through February 2020, since COVID-19 began circulating more in March 2020 in the USA. There is a 36 month forecast.
The black lines on the plot are the actual observed mortality in the USA during the pre-COVID-19 time frame (mortality counts from 2019 and 2020 are still considered provisional).
Observed all-cause mortality is plotted through July, 2020.
All-cause mortality data in the USA from January 1, 1999 through December 2018 were gathered from CDC WONDER grouped by month.
Provisional all-cause mortality from January 2019-December 2019 were gathered from The National Center for Health Statistics.
Finally, provisional all-cause mortality data for January, 2020 to present are scraped on-demand from the CDC COVID View website.
Analysis is conducted using the Seasonal and Trend decomposition using Loess Forecasting model, as implemented in the Forecast package in R.
Forecasting is done on data from January 1999 through February 2020, since COVID-19 began circulating more in March 2020 in the USA. There is a 36 month forecast.
The black lines on the plot are the actual observed mortality in the USA during the pre-COVID-19 time frame (mortality counts from 2019 and 2020 are still considered provisional).
Observed all-cause mortality is plotted through September, 2020.
Copyright © 2020-2021 Christopher Prener, Ph.D. All code, data, website content, and images are available under a Creative Commons Attribution 4.0 International License.