#Sweden's infamous ~3% of deaths with unknown date sourced from @EU_Eurostat for all charts.
Adding those in more detail than before has the slightly paradoxical effect of reducing their excess by 20-25% as it makes their downward trend less steep.
And now focusing on narrower age groups as the Eurostat data is provided in 5/10 year bands. I used 10yr bands for 0-39 and 5yr for 40+ to get the highest resolution.
Younger ages have fared worst in recent weeks. Which is not good and needs further analysis. But less so in Nordics who have had life back to normal longest and no longer generally recommend testing.
NB most of these countries most recent 4 week data is for Sept/Oct.
7/
An irony of all this is that the country in Western Europe with the highest mortality rates over the last decade or so, #Denmark, have the lowest pandemic excess.
For Eurostat dataset population denominators I used midpoint of the either side year estimates as that matches HMD's methodology best.
9/
A couple of requests for the main graphs to start at 0 on the X axis....
10/
By variant/wave....for all ages.
11/
And combining the 3 baselines. Eurostat prioritized as higher resolution age data, followed by HMD 8 year then HMD 5 year.
What do people think of this format?
12/
And a bonus as I just stumbled upon it. The Economist now has "Demography adjusted" numbers per 100k. Very similar to mine at the low end, but in the middle and high end a lot lower. Unsure what baseline, population data they use, but worth posting:
Baseline 2012-19, log adjusted to account for unrealistic long term linear trend.
2/
Here are the Sweden charts broken down into men and women.
Swedish born women - nothing statistically significant as within the 95% CI's. Foreign born men - fairly significant excess mortality over the 5 years.
Of the major countries with complete and quality data for 2023, only 5 have seen an *improvement* in mortality rate for the Pandemic period 2020-23 compared to the previous 4 years.....
Australia, New Zealand, Denmark, Sweden and Norway.
1/
The two worst results here among Western countries are England/Wales ( -6.4% ), and USA ( -10.4% ). This likely reflects not just pandemic issues but also issues that predate it, such as healthcare and dietary issues.
2/
These trends will likely be closely mirrored by Life Expectancy figures when we have them for 2023.
Its also likely when their 2023 data is complete, that South Korea will be the 6th on this list.
And I'd expect Japan too if and when data ever becomes available.
3/
All one needs is age stratified deaths data going back enough years to make a decent baseline. 5 or 10 year bands is sufficient for a decent estimate.
We then multiply each death total according to something broadly resembling 100-age_at_death, and sum the total per year.
2/
An advantage of this method is that it is not just the number of excess deaths in a given period, but an actual estimate of how many *years* of life were lost.
By comparing to a good baseline we can estimate how many were lost compared to the non pandemic "counterfactual".