If there were, for instance, 100 million people who were vaccinated and 472 died and only 1 million unvaccinated people, and 68 people died then the unvaxxed are dying at a higher rate, despite the raw number of vaccinated dead being larger.
I've used these simple numbers to make it easy to see the math. The normalized numbers would be:
Unvaxxed: 6,800 per 100,000,000
Vaxxed: 472 per 100,000,000
In other words, as the notes explain, you have to take the denominator into consideration. Which the authors of the study have done for us. These are the rates per 100,000 figures which normalize the data to do just what we are all looking to see.
It is provided in column H Age Specific Rate per 100,000.
You didn't include those numbers in your post, unfortunately. So I will update it to include them.
At least then we are using the correct numbers to do apple-to-apples comparisons. (Which is why the name of the chart is:)
"Table 4: Weekly age-specific mortality rates by vaccination status for all deaths, per 100,000 people, England, deaths occurring between 2 January 2021 and 24 September 2021"(See the "per 100,000" is in the title of the table! You should look at it, not the raw numbers).
Here is your post's data again (with missing Column H added at the end, in blue to make it easy to see):
24-Sep-21 | 38 | Unvaccinated | 10-59 | 68 | 0.9Now, in your data analysis you wanted to incorporate all stages of Covid testing. So, to do that here we take the average of the three phases you want to combine. (They are ratios, you have to average them, not simply add them).
24-Sep-21 | 38 | Unvaccinated | 60-69 | 65 | 24.0
24-Sep-21 | 38 | Unvaccinated | 70-79 | 78 | 59.6
24-Sep-21 | 38 | Unvaccinated | 80+ | 148 | 214.424-Sep-21 | 38 | Within 21 days of first dose | 10-59 | 4 | 1.7
24-Sep-21 | 38 | Within 21 days of first dose | 60-69 | 1 | ~0
24-Sep-21 | 38 | Within 21 days of first dose | 70-79 | 0 | ~0
24-Sep-21 | 38 | Within 21 days of first dose | 80+ | 1 | ~024-Sep-21 | 38 | 21 days or more after first dose | 10-59 | 34 | 2.1
24-Sep-21 | 38 | 21 days or more after first dose | 60-69 | 45 | 78.2
24-Sep-21 | 38 | 21 days or more after first dose | 70-79 | 46 | 152.9
24-Sep-21 | 38 | 21 days or more after first dose | 80+ | 92 |
381.524-Sep-21 | 38 | Second dose | 10-59 | 400 | 2.0
24-Sep-21 | 38 | Second dose | 60-69 | 638 | 11.9
24-Sep-21 | 38 | Second dose | 70-79 | 1,553 | 35.4
24-Sep-21 | 38 | Second dose | 80+ | 3,839 | 182.4
Death per 100,000 - all three post-vaccination phases vs. unvaccinated rate (in red), by age groups:
10-59 | 1.9 | 0.9
60-69 | 30.0 | 24.0
70-79 | 62.7 | 59.6
80-89 | 188.0 | 214.4
I don't think it's a good idea to use a single week's number s and try to get a trend from them, that's why I averaged them in my original post.
Based on this week, for instance, almost no one dies in the 21 days after the injection. That's probably just a statistical anomoly.
When you are looking at very small numbers, near zero (for instance, the claim this whole thing is built on, the 10-59 number where this week the death rate per 100,000 was indeedtwice as high, you have to realize how small it really is. Near zero in both cases. (If you are under 60 this is very good news. With or without the vax, you just probably aren't going to die).
On the other hand, if we were going to try to draw conclusions from one data point (never a good idea, but here we are, using only the most recent week's data) - it sucks to be 80. People in their 80s die with depressing regularity. Which is why there are relatively so many people in their 70s and so few in their 90s!
With the vax 188 / 100,000 without 214 / 100,000. A 14% higher likelyhood of death (if we tried to project from this, which (again) is ill-advised.
Anyway, these are the better numbers (ratio'd to normalize for population size differences) for comparison than the raw ones you were using.
Cheers!
That group, fully vaccinated (all ages) over represents “all deaths.”
Cheers!