"scrapping data from RKI excel failed" - Perhaps due to new layout of RKI excel sheet about rki-vaccination-data

[ThisIsBenny]

@einstweilen they have reordered the columns and added new columns, why the values are not correct anymore.

[ThisIsBenny]

Hi @Viet2503, thanks for the hint. I will have a look on it.

[ThisIsBenny]

@Viet2503 issue is fixed 😊

[Viet2503]

Thanks for fixing! @ThisIsBenny :)

Unfortunately there seems to be a bug with scraping data for Thüringen. Numbers for vaccinations by vaccine type are missing here.

End of API JSON:
"Th\u00fcringen": {"total": 2133378}}, "vaccinated": 6966082, "2nd_vaccination": {"vaccinated": 197754, "difference_to_the_previous_day": 328615}, "sum_vaccine_doses": 7163836, "difference_to_the_previous_day": 4597478, "vaccinations_per_1000_inhabitants": 83.76, "total": 83166711, "quote": 8.38}

[einstweilen]

@ThisIsBenny
The data is still messed up.

e.g. "Bayern"
difference_to_the_previous_day: 820570 (should be: 36116)
quote: 783482
etc.

2021-04-08, 15:05
"Bayern": {"total": 13124737, "rs": "09", "vaccinated": 1155316, "vaccinated_by_accine": {"biontech": 92528, "moderna": 482057, "astrazeneca": 36116}, "difference_to_the_previous_day": 820570, "vaccinations_per_1000_inhabitants": 88.03, "quote": 783482, "2nd_vaccination": {"vaccinated": 36988, "vaccinated_by_accine": {"biontech": 100, "moderna": 13445, "astrazeneca": 89523}, "difference_to_the_previous_day": 59487, "quote": 73}}

Thank you in advance!

[ThisIsBenny]

@Viet2503 they have added a new row in the header rows, why the loop ends by "Schleswig-Holstein".

this fix the issue: 25940b3

and fix is available on dev stage: https://rki-vaccination-data-git-develop-thisisbenny.vercel.app/api

I will check all values in detail if there are any other changes.

[ThisIsBenny]

issues will be fixed with #34