STUMP - Meep on public finance, pensions, mortality and more

Share this post
Mortality Nuggets: Videos on Death Numbers, Ranking Table for States' Mortality for 2020
marypatcampbell.substack.com
Mortality with Meep

Mortality Nuggets: Videos on Death Numbers, Ranking Table for States' Mortality for 2020

An amuse-bouche for the holiday weekend

Mary Pat Campbell
Jan 15
Comment
Share

Video Version of my Prior Post

For those who prefer videos:

I collect these videos in my Mortality with Meep playlist, which is up to 52 videos now, I see. I’ve been doing this since before the pandemic, so if you’re interested in some historical background for comparison, here is a similar video, where I discuss the 2017 version of that table:

This is the post I’m talking about with the 2020 death numbers, for your convenience:

STUMP - Meep on public finance, pensions, mortality and more
Top Causes of Death by Age Group, 2020: Raw Numbers
I looked at this very thing using a table from the CDC for the year 2017, a post I wrote in December 2019. You can go to that post to see what that CDC table looked like. I did a top causes of death post in April 2021, but that was for the whole country, and, obviously, was going to be biased by what killed the oldest people…
Read more
4 months ago · 3 likes · 1 comment · Mary Pat Campbell

Querying CDC WONDER for Leading 15 Causes of Death

This is to encourage you to do your own queries on the CDC WONDER database.

I have a playlist, Working with WONDER, which I am actively adding videos to as I pull data from WONDER. Check it out!

State Mortality Comparisons

Someone asked me about this, so here we go.

A reminder: there were two waves of COVID deaths in 2020, with the primary peak being spring 2020, centered around NYC (with a few blips around other cities like New Orleans, DC, Detroit, Chicago, etc.) There was a fall/winter wave, but it didn’t peak until January 2021.

I grabbed the age-adjusted death rates for each state (plus DC) for both 2019 and 2020, and then ranked them by their percentage change.

Here is the entire 51 ranking table: (sorry it’s pictures - I’ll embed the spreadsheet below)

A few remarks on these lists.

You need to remember this is capturing the changes in mortality across all the ages, and with age-adjusted mortality rates, increased deaths of old people, while that will likely have large effects in total death counts, will not necessarily have large effects on age-adjusted death rates.

As a refresher — here’s my primer on age-adjusted death rates:

STUMP - Meep on public finance, pensions, mortality and more
Mortality Basics with Meep: Age-Adjusted Death Rates v. Crude Death Rates for U.S. 1968-2020
I have been complaining even before 2020 about how media generally talks about mortality trends, generally using life expectancy as their hook. Here are a few posts where I do that: Mortality with Meep: U.S. Life Expectancy Fell 2.4% in 2020, and Death Rates Increased 16.1…
Read more
9 months ago · 1 comment · Mary Pat Campbell

The ranking tables do reflect where COVID hit hard in 2020 — the spring 2020 wave in the northeast, and the summer 2020 wave along the south and southwest (Texas, in particular). No, Florida didn’t show its big COVID impact until January 2021, so it’s pretty far down on this ranking table.

I prefer looking at the information this way:

This way, we can see if there are any geographic patterns. We did know the hot spots of NY, NJ, IL (mainly around Chicago), DC, TX, Louisiana (around New Orleans), Arizona. I had not been aware of Mississippi being so bad, but maybe that was spillover from New Orleans.

Here is the spreadsheet, in case you want to play with it.

State Age Adjusted Death Rates 1999 2020
207KB ∙ XLSX File
Download
Download

Though I didn’t use the information for this post, I grabbed the age-adjusted death rates and crude death rates for the states and DC going back to 1999. Interested people may wish to play with that.

CommentComment
ShareShare

Create your profile

0 subscriptions will be displayed on your profile (edit)

Skip for now

Only paid subscribers can comment on this post

Already a paid subscriber? Sign in

Check your email

For your security, we need to re-authenticate you.

Click the link we sent to , or click here to sign in.

TopNewCommunity

No posts

Ready for more?

© 2022 Mary Pat Campbell
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing