More Explanation and Some Links
Well hello again folks! When last we left off about 4 weeks ago, I had updated the state level mortality data provided by the CDC for 2/1/2020 – 8/11/2021. Today I’m updating through 9/8/2021, about 4 extra weeks. All the caveats from my prior post still apply, so go there for any more explanation.
First though, I wanted to clarify some things from my prior post. I find excess mortality data interesting because every state counts COVID deaths differently. There are varying reasons for this, some more valid than others. There are also lots of theories about what the non-COVID excess deaths are. I like looking at state level data because it forces us to think more critically about what those deaths might be and to avoid making sweeping generalizations. In the national press, only the biggest 4 states (California, Texas, Florida and New York) seem to get any air time. Other states may occasionally be cherry picked if something interesting is going on, but otherwise they are mostly ignored.
There is some good work going on with excess mortality, both in trying to estimate it and trying to track it. First up, some good analysis of the 2020 death data, including racial breakdown. While the early phase of the pandemic (when it hit NYC hard) was very skewed towards black and Hispanic deaths, it appears things got far more even as we got towards the winter. For example, here’s the excess death incidence rate for those > 65 years old. Bars are quarters of the year 2020:


Next up is an interesting link (explanation here, site here) to someone trying to catalogue excess mortality in real time, with the concerning hypothesis that we may be seeing an uptick in other kinds of deaths too. Now there are two competing hypotheses here: people could have put off getting treated for other medical conditions due to the pandemic, or people could be more susceptible to other medical conditions after having COVID. Actually, those aren’t competing. It could be both. We know that with the flu there is a well established link between getting the flu and subsequently having a heart attack, and there’s no reason COVID-19 couldn’t act similarly. We also know that in many places hospitals are full and it makes sense people may put off care. We will know more as the data comes in I’m sure, but it’s unfortunate. On that happy note, on to the next updates!
Excess Mortality Over Average by State
I made a more multi colored graph this time:

| State | Excess deaths above average/million 2/1/20 – 9/8/21 (change from 8/11) | Change from 8/11 rank |
| Mississippi | 4108 (+473) | No change |
| District of Columbia | 3652 (+111) | No change |
| Alabama | 3441 (+320) | +1 spots |
| Arkansas | 3404 (+392) | +2 spots |
| Arizona | 3346 (+208) | -2 spots |
| Louisiana | 3267 (+166) | -1 spots |
| South Carolina | 3127 (+238) | +1 spot |
| New York | 3086 (+76) | -1 spot |
| New Jersey | 2894 (+33) | No change |
| Nevada | 2842 (+281) | +3 spots |
Mississippi’s struggling here guys.
Excess Mortality Over Upper Bound by State
Okay, here’s the updated numbers for deaths only falling outside the upper bound:

| State | Excess deaths over upper bound 2/1/20-9/8/21 (change from 8/11) | Change from 8/11 rank |
| Mississippi | 2859 (+379) | +1 spot |
| New York | 2590 (+39) | -1 spot |
| Alabama | 2502 (+229) | +2 spots |
| Arizona | 2449 (+155) | no change |
| New Jersey | 2400 (+5) | -2 spots |
| Arkansas | 2258 (+333) | +4 spots |
| Texas | 2204 (+181) | -1 spot |
| South Carolina | 2191 (+190) | no change |
| Florida | 2148 (+454) | +8 spots |
| Louisiana | 2125 (+107) | -3 spots |
There was more motion on this ranking than I expected to see, which is sad because it means there are multiple places where we are seeing truly unusual death tolls.
States of Interest
Since everyone’s always interested in the Big 4, here they are. Change from 8/11 in parentheses:
| Excess Deaths Over Upper Bound/Million | Excess Deaths Over Average/Million | Rank in Excess Deaths Over Average | Rank in Excess Deaths Over Upper Bound | |
| New York | 2590 (+39) | 3860 (+76) | 8 | 2 |
| Florida | 2148 (+454) | 2827 (+488) | 12 | 9 |
| Texas | 2204 (+181) | 2723 (+216) | 15 | 7 |
| California | 1761 (+50) | 2285 (+92) | 30 | 20 |
And because I’m always interested in my state and those of similar size, here they are:
| Excess Deaths Over Upper Bound/Million | Excess Deaths Over Average/Million | Rank in Excess Deaths Over Average | Rank in Excess Deaths Over Upper Bound | |
| Arizona | 2449 (+155) | 3346 (+208) | 5 | 4 |
| Massachusetts | 1240 (-9) | 1642 (+25) | 40 | 34 |
| Tennessee | 1904 (+117) | 2660 (+193) | 13 | 11 |
Age Adjustments?
So on my last post Kyle Watson made an interesting point that there should be some sort of age adjustment if we were going to compare things on the state level. While some of this is sort of inherent to the entire concept of excess mortality (states with older populations likely have more expected deaths in a given year), we would expect a disease like COVID to hit states with older populations harder even if everything else was equal.
Interestingly there was some work done on this by a group using the raw COVID numbers, which also looked at international data. They found that states like Texas actually had a worse pandemic than previously reported due to their young population:

I had to ponder a bit what the fairest way of doing this was though. It turns out the CDC also publishes the numbers by week by age group, so I took a look at the US as a whole from 2015-2021:

So every age group from 45 years on showed a fairly noticeable bump last year. Actually every age group showed an increase in mortality when compared to the previous years, and it wasn’t entirely the groups I expected. It’s hard to see on the graph, but here’s the increase for each age group over the average from 2015-2019:
| Age Group | % Increase Over 2015-2019 Average |
|---|---|
| Under 25 years | 5% |
| 25-44 years | 33% |
| 45-64 years | 20% |
| 65-74 years | 30% |
| 75-84 years | 27% |
| 85 years and older | 19% |
I was surprised so many of these increases were so close together, it was just the starting numbers that were different. Please note the bin sizes are different however. There are twice as many ages contained in the 45-64 year old group as the 65-74 group, which is how you get a similar number of deaths in the younger age category.
It’s also interesting to note that while the data for this year is obviously still highly incomplete and anything could happen, there’s a chance the 85+ group may not show a large jump for 2021. Almost certainly not as large as last year.
Back to age adjustments though: I couldn’t find a great source to give me state by state age breakdowns matching the ones above, but I did find a breakdown of how many people in each state are over 65. I assumed that excess mortality followed roughly the same pattern as the overall mortality numbers, and adjusted from there. Here are the new leaders for excess deaths above average:
| State | Age-Adjusted (albeit crudely) Excess Mortality above Average 2/1/20-9/8/21 |
|---|---|
| DC | 4330 |
| Mississippi | 4100 |
| Louisiana | 3328 |
| Alabama | 3303 |
| Arkansas | 3253 |
| Texas | 3183 |
| Arizona | 3136 |
| New York | 3009 |
| South Carolina | 2915 |
| New Jersey | 2864 |
The map overall shows there’s a pretty substantial dropoff between Mississippi, DC and everywhere else:

Now here’s the big 4:
| State | Adjusted Rank for Excess Mortality Over Average (previous rank) | Adjusted Rank for Excess Mortality Over Upper Bound (previous rank) |
|---|---|---|
| New York | 8 (8) | 3 (2) |
| Florida | 24 (12) | 15 (9) |
| Texas | 6 (15) | 2 (7) |
| California | 22 (30) | 13 (20) |
Interestingly, the states most helped/hurt by this adjustment aren’t necessarily the ones you’d think of. For deaths above the upper bound, 4 states added on more than 150 deaths/million and 4 states lost more than that after the adjustment. The ones that gained deaths were: Texas, DC, Georgia and Utah. The ones that lost the most post-adjustment were Arizona, Florida, Pennsylvania and West Virginia. As mentioned, only Texas and Florida receive much air time nationally, and since this worked out differently for both of them I wouldn’t expect to see much on this any time soon.
As always, let me know if there’s more you want to see! I have a lot left on spreadsheets for individual states. Stay safe out there.








