Expected Death Analysis

Covid-19 is causing a higher death rate than normal. There has been some controversy as to whether covid-19 was the cause of death, even if it was present in the deceased. To avoid this controversy, it's possible to just look at the number of deaths in a particular week and compare it with the number the same week over the past few years. (See, for example, Mortality surveillance during the COVID-19 pandemic in the Bulletin of the World Health Organization. ) The graph below uses data from the CDC ( JSON). In particular, the week of reported deaths and the percentage of expected deaths fields are used. The percent of expected deaths compares the death count in the particular week to the average for that week in 2017 throgh 2019. Comparing to same week data for previous years removes seasonal effects on death rates.

As can be seen in the data through March 14, this number is pretty stable. However, after March 14, we see the percentage of expected deaths increase dramatically. Towards the end of the dataset, the percentage of expected deaths is very low. This is because the CDC records the actual date of the death, but may not receive that report for several weeks. Their analysis of 2015 through 2016 data showed that less than 25% of the deaths were reported within the first few weeks. At least 75% of the deaths are reported within 8 weeks. In an attempt to get more current data, a "correction factor" has been developed based on how the percent expected deaths increases after the week of death as more reports are received. Data on report delays has been gathered starting June 15, 2020. This data is here. The summary data used for the predictions is here. The "Average Percent of Max" (not really shown as percent; 1.00 = 100%) is the portion of the final value that shows up the specified number of days after the end of the week of the death. The "final value" is the maximum value over time for that weeek as additional reports arrive at the CDC. The reported CDC percent of expected deaths is divided by the Average Percent of Max for the number of days between the end of the week of death and the CDC update date to yield the predicted percent of expected deaths. Based on this data, a predicted percentage of expected deaths is determined immediately following the week of death. As the CDC updates their numbers (every weekday), the correction factors are updated and the predicted percentage of expected deaths is updated.

According to this document at medium.com, the timeline for infections ending in death averages as below:

If we take the middle of each of these periods, we might estimate that death occurs about 6 weeks after exposure. We see the original upward trend in deaths at about March 21, 2020. Deaths peaked the week of April 11, 2020, then slowly declined until the week of June 6, 2020. Deaths held steady at about 110% of normal for about 4 weeks, then climbed to about 115% the week of July 11, 2020. Using the predicted results (red curve below), deaths continued to increase until stabilizing at around 120% of normal. The first increase (in March) was due to introduction of the virus to the U.S. What caused the second increase (starting the week of July 11, 2020)? There's a detailed timeline at the Project On Government Oversight, but it does not go to 6 weeks before July 11 (which would roughly indicate an increase in exposures around the week of May 30, 2020). PERHAPS the exposure increase and following death increase was due to large gatherings Memorial Day weekend (May 23 through May 25). What other conclusions can we draw from the data?

Blue line is percentage of expected deaths this week as reported by the CDC. Red line is the predicted percentage of expected deaths based on reports received from the CDC so far and corrected based on typical reporting delay. Orange line is the accumulated percentage of expected deaths based on data received from the CDC so far.

Average Age at Time of Death

The CDC does not publish data revealing the average age at death each week. They do, however, make data available showing the total number of deaths in approximate 10 year age groups each week. This data is here (CSV).

In the graph below, this data is used to compute an average age at death for each week. Records are used where the following conditions are satisfied:

The number of deaths in each age group is multiplied by the average age of that group (for example, the group 25-34 years uses an age of 30 years). These products are then added and divided by the total number of deaths in all age groups to yield an average age at death. Note that the age used for the 85 and older group is 90 years, the average in an 85 to 94 age group. Because the chart is not comparing age at time of death to historic values as the Percent of Expected Deaths chart, above, is, there may be seasonal effects that influence the chart.

At first, I was expecting the age at death to decrease due to covid-19. We could then say covid-19 has resulted in so many years loss of life. However, it appears that covid-19 has, instead, just upset the balance in the number of deaths between different age groups. It has caused more older people to die causing the average age at time of death to increase. When percentage of expected deaths peaked in April 2020, the average age at death also peaked. When the percentage of expected deaths decreased in June 2020, fewer elderly were dying, so the average age at death also decreased. Then, as the percentage of expected deaths increased in July 2020, the average age at death also increased.

It's interesting to compare this with other data. For example, the life expectancy for someone born today in the US is about 78.539 years (as of 2018). However, people dying today were not born today, so today's life expectancy is not appropriate. We might look at the median age of the US population (38.2 years according to Wikipedia. We could then look at the life expectancy for those born in 1982. The life expectancy chart shows a life expectancy of 74.361 years for those born in 1982. That is still higher than the average age at death shown in the graph above. Looking at the graph above, we are seeing people die at about age 73. Thus they were born around 1947. Life expectancy for those born in 1950 is about 68.2 years according to this CDC document. The current 73 years is between the expected 68.2 years and the expected 74.361 years. As mentioned before, there are likely to be seasonal effects, but there is a fairly dramatic variation in age at death that tracks the percentage of expected deaths.

The image below demonstrates the average age at death calculation for February 1, 2020. It can be used to verify the average age at death calculations used to create the graph.



Comments to harold@hallikainen.org