search

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

Vaccines in Locations.csv out of date compared with WHO data?? #1368

Closed DrBazUK closed 3 years ago

DrBazUK commented 3 years ago

@edomt Is there any way to update the vaccines included per country in the locations.csv file?

WHO has a feed https://covid19.who.int/who-data/vaccination-data.csv which lists all the vaccinations in use in each country (and some dependent territories).

As of 18 May, OWID has more vaccines listed than WHO for these countries:

Armenia Cayman Islands Guernsey Kazakhstan Kenya Malta Uzbekistan

There are about 90 countries where WHO>OWID in terms of number of vaccines listed.

I lack the coding experience to help automate a check but wonder if this could be done?

Thanks in advance, Baz

lucasrodes commented 3 years ago

Hi @DrBazUK, Thanks for your message and interest in the data.

We are aware of WHO listing the vaccines in use per country. We are trying to regularly check to find potential discrepancies.

We prefer the use of https://covid19.who.int/who-data/vaccination-metadata.csv, as it tells us precisely which vaccines have been accepted and which are in use.

We are currently implementing a series of automated sanity checks to contrast our data with theirs. Will likely be under vax.tracking utils. Will keep you posted.

DrBazUK commented 3 years ago

@lucasrodes many thanks for the confirmation. Hadn't spotted the metadata.csv file but will add it to my own comparison (in Excel) until I learn enough to do it in a proper data science tool :)

lucasrodes commented 3 years ago

The functionality has been added.

You can run 

cowid-vax-track missing-vaccines-who --to-csv

which will generate the file vaccines-missing-who.tmp.csv containing differences in vaccine records in WHO and OWID. I will be examining a bit closer the mismatches these days. The logic itself is found in:

https://github.com/owid/covid-19-data/blob/4f77a7d716014a3b337b386efc940088bc4462a9/scripts/scripts/vaccinations/src/vax/tracking/vaccines.py#L213

Note: To run command cowid-vax-track make sure you have the vaccinations library installed.