owid / covid-19-data

Data on COVID-19 (coronavirus) cases, deaths, hospitalizations, tests • All countries • Updated daily by Our World in Data
https://ourworldindata.org/coronavirus
5.66k stars 3.64k forks source link

Fully vaccinated - Slovakia #2237

Closed MartinHBA closed 2 years ago

MartinHBA commented 2 years ago

hello, you are reporting 45% fully vax for Slovakia, based on your description you are calculating from https://github.com/Institut-Zdravotnych-Analyz/covid19-data however seems that it's somehow miscalculated or some problem there. Based on ECDC data (European CDC) collecting daily from all member states, Slovakia is 48% at the moment, you can use ECDC vaccination data from here: https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea

lucasrodes commented 2 years ago

Hi @MartinHBA, Thanks for your message.

I answer your points below:

hello, you are reporting 45% fully vax for Slovakia, based on your description you are calculating from https://github.com/Institut-Zdravotnych-Analyz/covid19-data however seems that it's somehow miscalculated or some problem there.

Based on the official data provided, we report the following figures:

Together with the UNWPP estimate on population for Slovakia of 5,460,726 we obtain the per-capita metrics.

Based on ECDC data (European CDC) collecting daily from all member states, Slovakia is 48% at the moment, you can use ECDC vaccination data from here: https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea

We lean towards using official national reports as they usually provide more frequent data updates when compared to ECDC, which reports twice a week.

I hope that this helps.

MartinHBA commented 2 years ago

hi @lucasrodes I now fully understand where is problem, you are using column with doses but taking "fully" from it. this "fully" is based on 2 weeks after 2nd shot of mRNA vaccina and 3 weeks after single shot vaccine Jenssen. This is epidemiology info about "fully protected" individual, not "fully vaccinated" person in terms of having 2 doses. If you take 2 doses and all 1st doses of Jenssen you would see 48% same as ECDC is showing.

lucasrodes commented 2 years ago

Hi @MartinHBA, I am not sure if I understand you correctly, but we currently obtain the number of fully vaccinated people by adding the number of administered second doses and first doses of Janssen (see here). Therefore, our metric for fully vaccinated already accounts for two-dose and single-dose vaccines.

MartinHBA commented 2 years ago

hi @lucasrodes, here is table from file with vaccines and doses administered, if you take 2nd doses of all other vaccines and 1st doses administered of JANSSEN you will get 2,621,728 in total (fully vax) not 2,438,400 image

lucasrodes commented 2 years ago

Hi @MartinHBA, Could you share more details on where the table that you share originates from? Which file/URL are you using?

Thanks

MartinHBA commented 2 years ago

hi @lucasrodes , it's this one: https://github.com/Institut-Zdravotnych-Analyz/covid19-data/blob/main/Vaccination/OpenData_Slovakia_Vaccination_AgeGroup_District.csv

lucasrodes commented 2 years ago

Thanks for bringing this to our attention, @MartinHBA.

I found a small bug and just corrected it. The data will be live in the next hours, but in the meantime, you can find a preliminary version for Slovakia here.

Thanks once again for your help

MartinHBA commented 2 years ago

@lucasrodes thx for updating code. I've closed issue. However after that I've noticed that still your fully vax number is only 2580269, compared to table above is still lot less 🤷‍♂️

MartinHBA commented 2 years ago

See last comment pls

lucasrodes commented 2 years ago

There appear to be differences in the file that we currently use (https://github.com/Institut-Zdravotnych-Analyz/covid19-data/blob/main/Vaccination/OpenData_Slovakia_Vaccination_Regions.csv) and the one that you cite (https://github.com/Institut-Zdravotnych-Analyz/covid19-data/blob/main/Vaccination/OpenData_Slovakia_Vaccination_AgeGroup_District.csv).

As both come from the same source, I opened the issue https://github.com/Institut-Zdravotnych-Analyz/covid19-data/issues/148 in their project to continue this discussion.

Thanks for your help!

MartinHBA commented 2 years ago

hi @lucasrodes , seems they close it with suggestion not to use regions anymore, will you please update your Python code to use different CSV as source?

lucasrodes commented 2 years ago

Refactor done in fc4edda83da25fa897ef3b984b1e30e7d6655915

MartinHBA commented 2 years ago

@lucasrodes , much appreciated! I love your Python code, nice and sleek ;)