All Cause Mortality - A Dashboard Says A Thousands Words!
Introducing a new revealing Interactive Dashboard and crude deaths!
* If launching to dashboard from mobile phone or tablet click HERE.
I’m proud to bring you my latest viz this time on USA All Cause Mortality 2018-2021. Before I begin I want to give a big shout out to my new friend Cherie from the Menlo Park Forum brain trust. It was Cherie who alerted me to the fact San Mateo County in California is experiencing a high number of deaths in a short amount of time. So much so, a local article was written about it HERE.
So there I go sniffing around the CDC website like a truffle pig, and I’m back at the Wonder System I know all to well, at least I thought I did. I basically come across the customizable download section for all cause mortality and fortuitously noticed it had the ability to query down to county level and also had a awesome metric called Crude Death Rate. Boohay!! I think my friend Fabian over at pervaers.com is going to like this if he hasn’t already found it already. I need to mention the arbitrary file size download limitation is a pain in rump, it probably took me longer to download and model, than make this dashboard. I could have a ton more metrics like gender, ethnicity, etc. if it wasn’t for the Mickey Mouse size limits on downloads. I ended up chopping up the data and downloading a couple dozen files which meant that much more work massaging and modeling the data. Fabian deserves a plug because he is also doing excellent work out of Germany and he’s all over the CDC:
Ok so anyways, it will be wise for anybody wanting to authenticate and duplicate my work to read the “Notes” section of this new dashboard. There are a few technical blurbs from the CDC about the data.
I want to go now to that “crude rate of death” per 100,000 people and per county population. You can see in very high level overview of the USA that Los Angeles County dwarfs the rest of the nation with absolute deaths but they also have the largest county in the nation. The “crude rate deaths” viz on the right are showing many other counties with higher death rates by relative population comparison. Let’s see what just California looks like?
I know Siskiyou, Shasta, and Trinity County are small but they are between ~42%-51% above the national average of 952 dead people a year per every 100,000. The bottom half you see that this dashboard has the ability to pivot on age categories and place of death. A small disclaimer, I’m still working out the color schema and I’m noticing how the map and the Place of Death (POD) sharing the same color schema is probably no bueno.
Staying on California you can see I repeat the County and Ages graphics but this time with the histogram bars stacked by POD. Makes sense that there is hardly anybody under 55 years old in a Skilled Nursing Facility or Long Term Care (SNF/LTC), but there are a few and you can quickly drill down and see what counties they are from. Can we find any patterns in the data that stand out? Are there kids dying at a faster rate in a particular county? I wish I had the ethnicity data. Is it true rich white folks drop off their parents at high end SNF’s with cool sounding names like The Atrium, Villa Siena, or The Hotel California? Talk about a hotel you can never leave… gee that sounds familiar?
Well let’s stop gilding the lily, these are counties with the largest crude deaths, if you have any family in these counties you might want to check in on them and let them know what’s up!
Is Citrus County a big retirement community? The corresponding Crude Map to this short list of top crude rates now looks like this:
Consider this the beta version of the dashboard, it looks like I still got a little work to do with the “nulls” and the color. If you guys are lucky, I might go back to the well for the gender and ethnicity data. I’d feel a little better if I could buy myself a hamburger, please consider supporting the #1 VAERS Auditor in the world. If you can’t support financially, then like and share my work and testify on my behalf that I’m here waiting for the crazy train to come rolling through Eaglesville. God Bless
interesting that if you walk over the line from LA to Ventura you probably wont die :)
Hey Eagle. I love red, but your background is too much...hard to read