search

mathiasbynens / covid-19-vaccinations-germany

Historical data on COVID-19 vaccination doses administered in Germany, per state.
https://mathiasbynens.github.io/covid-19-vaccinations-germany/
MIT License
52 stars 10 forks source link

RKI data bug for date=2021-03-02 × pubDate=2021-03-03: doses administered per 100 inhabitants in Mecklenburg-Vorpommern #12

Closed mathiasbynens closed 3 years ago

mathiasbynens commented 3 years ago

The RKI’s reported data for date=2021-03-02 × pubDate=2021-03-03 is incorrect for the state of Mecklenburg-Vorpommern. Specifically, the firstDosesPercent is 1.33520883958219 where it was 5.037254265492141 the day before, and the secondDosesPercent is 0.8047925598910954 when it was 3.105579247552138 before. As a result, https://mathiasbynens.github.io/covid-19-vaccinations-germany/#percent currently looks like this:

Luckily, we can compute the correct value ourselves, based on the reported firstDosesCumulative=83959 and the population-per-state metrics RKI is using, this boils down to firstDosesPercent=5.220882785. Similarly, secondDosesCumulative=50606 corresponds to secondDosesPercent=3.146869236.

I’ve reported this to the RKI. If they don’t publish an updated version today, I’ll manually correct the CSV data tomorrow.

It might be easier for the RKI to use a VLOOKUP instead of manually computing and entering these percentages for each state every day…

mathiasbynens commented 3 years ago

This is now fixed upstream. 8dfe2e7553cbcd3e6dff4ecd14fc17f46b1dade7