COVID deaths raw data by vaccination status from Switzerland

⁨1⁩ ⁨like⁩

Submitted ⁨⁨3⁩ ⁨years⁩ ago⁩ by ⁨iamtanmay@wolfballs.com⁩ to ⁨freeforum@wolfballs.com⁩

https://opendata.swiss/de/dataset/covid-19-schweiz/resource/a631c80f-89ac-4032-bc23-425a07717692

I saw a graph with this data, so I will try to graph it myself and I will post it here.

source

Comments

Sort:hotnew top

iamtanmay@wolfballs.com ⁨3⁩ ⁨years⁩ ago
Here are the graphs I spent all day calculating

Image

Almost no Covid deaths till age 60. Even between 60-80 deaths are roughly 100-150 for whole year for a country of 8.5 million, regardless of Vax. Above 80, is where most people die, around 80%.

Effectiveness of Vax looking at 80+ group, is debatable. Beginning of the 2021, Unvaxxed 80+ olds died 3 to 4 times more than partly vaxed (Weeks 4-20). But at the end of 2021, week 44-54, fully Vaxxed and unvaxxed deaths were same rates, and only boosters reduced deaths by 2/3rds

What triggered me was this graph here: https://flowingdata.com/2022/01/19/death-rates-by-vaccination-booster-status/

Its clear that they are misleading their viewers by mashing all ages together, and also by adding the "Unknown" vax status people as Unvaxxed. Looking at the data its clear that the Unvaxxed are not dying at 10 times the rate of Vaxxed, and under 60 you have nothing to worry about.

Original CSV link is in the header of the post. The excel file I made for calculations separated by age:

https://docs.google.com/spreadsheets/d/1wDwV222tqAlBSW8U-VR2YoDmnXOzyvRf/edit?usp=sharing&ouid=115819896693320590327&rtpof=true&sd=true

source
- iamtanmay@wolfballs.com ⁨3⁩ ⁨years⁩ ago
  @masterofballs@wolfballs.com here is the data I crunched
  
  source
  - masterofballs@wolfballs.com ⁨3⁩ ⁨years⁩ ago
    Sounds useless.
    
    source
    -> View More Comments
masterofballs@wolfballs.com ⁨3⁩ ⁨years⁩ ago
Whats the verdict ac cording to this data?

source
- iamtanmay@wolfballs.com ⁨3⁩ ⁨years⁩ ago
  The original graph that triggered my search is here:
  
  https://flowingdata.com/2022/01/19/death-rates-by-vaccination-booster-status/
  
  As you see it does not separate by age. I have downloaded the data, separated it by age into different sheets.
  
  RN I am googling to find excel (LibreOffice) functions to get the number of deaths by vax status (unvax, fullvax, +booster, unknown)
  
  Its a bit tricky because of the format of the columns/rows of the report, but I am working on it.
  
  Will post the graph + sorted data as soon as I can
  
  source