Demo on getting gun death data, reminder on Actuarial News, and reading over Meep's Shoulder
BISY NOT NECESSARILY BACKSON
Howdy all, while I’m busy with other things (end of the school year, publication deadlines at work, grading actuarial exams, yadda yadda), here are a couple of items.
Pulling gun death info from CDC WONDER
And a warning about working with provisional data from 2021.
As I note in the video, I have seen some people go with wonky numbers because they don’t realize that certain causes of death will get reported rapidly, and certain causes you will not get an enumeration for at least 6 months.
I demonstrate one technique you can use if you want to make year-over-year comparisons (you can also do the “12-month ending” comparison, but then you’d have to use a spreadsheet).
Read over my shoulder: Actuarial News
A reminder about my other website Actuarial News, where I’m mainly saving stories as I’m reading them for my general interests.
It’s not just a matter of not being able to blog about everything as it passes by (I’M BUSY), but that I’m often building up patterns in my brain that are fairly long term. Sometimes, I don’t know if something is noise or signal, so I just stick a pin in it. Just because I grab something does not mean I agree with it, think it’s truthful, factual, or otherwise. Sometimes I’m just trying to grab some sentiment at the time.
Most of the time, though, I’m just trying to grab decisions being made in real-time, or predictions being made, so I can come back to them years later.
Read after me – some of my spring 2022 reading
Reading in general is my entertainment. Here are some of the books I read this spring.
I do like to look at a variety of fiction and non-fiction for entertainment purposes. Every so often something new, but a lot of them are re-reads (in the video above, the re-reads are Parker Pyne Investigates; I, Robot; and Dombey and Son. The Hitchhiker’s Guide to the Galaxy one semi-counts as a re-read in that I recognized all the scenes he performed, but the particular dramatic reading was new to me.)
Enjoy!
Great video. I too initially got fooled by just how much lag there is in the data collected into the various CDC databases and reports. I thought I was being generous allowing for 6-8 weeks of lag, but especially in the case of accidental deaths, it takes 6 months to get a clear picture.
I started taking weekly snapshots of the CDC report "Weekly Provisional Counts of Deaths by State and Select Causes, 2020-2022"[1] starting in May of 2020 to analyze the rate of change week-to-week so I could forecast better, currently I have 104 consecutive snapshots of that data set - It seems to be the fastest way to keep tabs on All-Cause Mortality, Covid Mortality, and Accidental Deaths. Unfortunately the other causes tracked aren't that reliable (Cancer, Septicemia, Heart Disease, etc), so need to rely on the cumbersome Wonder for that drill down.
Long story short, having the snapshot data we can see just how long the accidental deaths take to be reported into the CDC.
Here is a table pulling the snapshots together for accidental deaths, for 2021.
Column A is the Week # of the year (1-52 for 2021), then each subsequent column shows the accidental deaths tracked to each snapshot - row 3 lists the date of the snapshot.
On 1/28/2021 the CDC got its first record for the year, week 1 they collected 900 accidental deaths. The next update (Column C) they added 133 more deaths to week 1 and made entry to week 2 of 457. This continues and continues as you move along to the right.
In rows 1 and 2 I added "% complete" for Week 1 and total Year, respectively.
For example, there would eventually be 5,872 deaths reported in the first week of 2021, so that first entry of 900 would only represent 15% of the total eventual deaths recorded.
There were at least 310,106 deaths for the total year so that first entry of 900 represents .3% of the eventual total.
As each snapshot adds more data, the % complete in rows 1 and 2 grow, but what is interesting is that it would 6 full months just to get 95% of the first week of 2021 (Column X). By the July 1st snapshot that year the CDC had tracked 5,557 deaths. It would take another 3 months just to get to 99% complete for that very first week of January 2021.
Even now, 18 months later, we are still tinkering (albeit only minor) with the final count. The 6/2/2022 update added another 6 deaths to the first week of January 2021.
Examining the full year total (tracked in row 2 % complete) note that it took us until April 10th 2022 to record 95% of the total accidental deaths (Column BH), getting to 295,167, but still 15,000 short of what looks to be the FINAL total, 310,106.
It might go higher than that though. The week-to-week increases were slowing down, but the most recent update on 6/2 added 1100 more deaths after a few weeks of being <+400. I had forecast initially 300,000 back in December of 2021, then revised to 310K by late January, now it seems it *might* nudge up another 2-5K.
It's notable that 310,000 accidental deaths breaks even 2020's record of 290,000 accidental deaths (previous 5 years ranged from 218K to 252K).
https://docs.google.com/spreadsheets/d/1U8XEbIaLnGYgRNzMGlnkFXrCJoL6TwYkTw57HF_Y75Y/edit?usp=sharing
[1] https://data.cdc.gov/NCHS/Weekly-Provisional-Counts-of-Deaths-by-State-and-S/muzy-jte6