2022-07-13: PHAC modified the way it reports Cases by Vaccination status. Lets find out which population had most infections in the last two reporting periods!
Key findings from the latest weekly PHAC 'COVID-19 epidemiology update
The update and extension of this analysis (to cases with deaths and hospitalizations) is now published in the 2022-07-15 Newsletter article.
PHAC COVID-19 epidemiology update
https://health-infobase.canada.ca/covid-19/ (Table 2)
Updated: June 24, July 1, July 8, 2022
Reporting periods: June 5 - June 12, 2022 and June 12 - June 19, 2022
Good news - PHAC added new column for the population with the second booster in Table 2 (Cases by Vaccination status).
Bad news - PHAC still reports percentages of vaccinated among cases, counting all cases since the start of the vaccination campaign on December 14, 2020 - showing “spectacular” low percentages (0.6%) for those who have recently received second booster.
Bad news - PHAC has removed columns for “Partially vaccinated” and “Cases not yet protected” (which we refer to as “1-dose people”) in Table 2
Good news - We can recover the statistics for these 1-dose people - by subtracting from Total cases the numbers that are published for 0, 2, 3, 4 dose people. And then - for each reported week, we can recompute cases relative to the size of each N-dose (N=0,…,4) population - by simply subtracting the numbers at two consecutive reports - to find out : Which population had most infections in the last two reported weeks? So lets do it!
Below is the final result and a recap of the steps performed, which you can do yourself using our Googlesheet or any other spreadsheet tool you are comfortable with.
A 7-min video from Wednesday lunch’s Live stream discussing it is included .
Step 1: copy Data from PHAC reports:
Note: in this analysis we dont use data by Age or Gender (which we analyze some other time). We use the numbers published for all all Ages and Genders, which is are shown in the top (blue) raw.
Step 2: for each population compute the difference between two consecutive reports, then divide by each N-dose population size.
Note: numbers in Red are pasted from PHAC report. Black numbers are computed from Red numbers.
Step 3: observe the finding, compare them with what is reported
This is what we observed and validated by data:
Between June 5 and June 19, the least number of infections are in 1-dose population (87+102 in a million)
The highest number infections are in 3-dose population (264+261), followed by 4-dose population (212+240)
Now you can proceed to next article, where we find out which population has smallest and largest number of Deaths and Hospitalizations - to help you to make informed decision.
And here’s a Joke of the day inspired by the above analysis.
Joke of the day:
“July 2032. Ottawa. News on radio - “Every year, we have more and more evidence that the more doses you get, the safer you are. Numbers speak for themselves - (Quoting the latest Epidemiology Update) - 'Counting the cases since the start of the vaccination campaign on December 14, 2020, of which we have over 50 million now, the smallest percentage (less than 0.0001%) is among those who received the latest 24th dose of the vaccine that was approved last month’. ”