thisisbenny / rki-vaccination-data Goto Github PK

Hey @ThisIsBenny thanks for this awesome offer! As the RKI data has been updated today at 08:30 but the API (https://rki-vaccination-data.vercel.app/api) still provides dates from yesterday I wanted to ask how often this data gets updated.

Thanks a lot

Hi.
Du hast gestern ja deine API an das neue Excel Format angepasst.
Dabei ist dir leider ein Fehler unterlaufen.
Habe das ganze gerade mal versucht zu finden und ich glaube ich habe es.
Habe das ganze mal für Bayern gemacht.
Bei fullyVaccinated und dann differenceToThePrerviousDay hast du 20123 stehen.
Siehe hier:

Laut Excel vom RKI sollten da aber
15987 stehen.

Die 20123 findet man eine Spalte weiter bei gesamt und nicht bei Differenz zum Vortag.

Deine Quote für die fullyVaccinated ist leider auch falsch berechnet.
Wenn du in der ExcelTabelle schaut stehen bei den Zweitimpfungen nicht mehr die Impfungen von Janssen. Diese werden nur bei den Erstimpfungen gezeigt.
Diese musst du aber für die Berechnung dazuzählen.
Vergleiche hierzu einfachmal in der Exceltabelle die Werte in Blatt eins Zelle E5 mit dem Wert in Tabellenblatte 2 Zelle I5. Die Differenz aus beiden ist in Blatt 2 Zelle G5 zu finden und das sind genau die "Erstimpfungen" von Janssen.

Und einen Wunsch hätte ich auch noch gleich:
Die Auffrischungsimpfungen müsste man ja auch noch dazu nehmen, da ich auch ausrechnen, wieviel jeden Tag gesamt geimpft wurde.
Danke

Hi @ThisIsBenny,
like expected there is now a new column for Astrazeneca for the 2nd vaccination.

Thx in advance!

It seems like something is not working. I get this when I try to GET from the API

Difference to the previous day seems incorrect. Can you please check this?
Thanks

Since September 10th or so the fully vaccinated number is far too low.
As example for Germany, September 13th: the API/v2 says 58.58% are fully vaccinated, while the RKI dashboard says 62,2 %.

Hi,

since today (Datenstand: 18.01.22, 08:00 Uhr) the RKI Excel document has new columns for 'Novavax' ('H' and 'N') on the 'Impfungen_Impfstoff' page, this breaks the parser and the API returns:

https://rki-vaccination-data.vercel.app/api and https://rki-vaccination-data.vercel.app/api/v2

{
"message": "scrapping data from RKI excel failed"
}

The raw data published by the RKI now has columns for the booster vaccinations. Would be great if this could be added to the API.

Hi @ThisIsBenny,

I don't know if this is really an issue. Janssen vaccination appears in the section "at least one vaccination" AND in the section "fully vaccinated", so the total of vaccinations given is too high (exactly about the number of Janssen vaccinations).

Hi @ThisIsBenny,

the data from the api is wrong since RKI changed their excel sheet.

Examples:

• vaccination quota is 8.3% in api, but must be 13.8%
• total vaccinated is too low
• 2nd vaccination value and quota is also too low
• column order of vaccine changed (total, biontech, moderna, astrazeneca)
• difference to previous day is much higher than it should be

Thanks in advance!

Hi.
If I try to open
https://rki-vaccination-data.vercel.app/api/v2
I get the following info and no json

Hi.
If I look at your data the value for
difference_to_the_previous_day = 208569
if I look at the excel sheet from rki (where you are getting your data from I think):
difference_to_the_previous_day = 269345
Maybe they changed again something in the format.
Thanks

Hi ThisIsBenny,
Thank You for your great work! I recognized a problems in the calculations of the value of "vaccinated" due to a newly added vaccine "Janssen". The value sums row[2] + row[12] and the new column Janssen should lead to row[2] + row[13]. Same for the values of "vaccinated_by_accine". It's just a small thing, which leads to wrong data from today on. [edit:] it is in the file "_utils/scrap_data.py"

greez

chrispfau

It seems the new 2nd_vaccination value is only available for the individual states. Would be great if the sum of all states would be available as a field for Germany. The Excel sheet contains the sum also, so I guess it should be a rather easy thing to add.

Anyway, thanks for the great API!

Hi.
Your api seems to be down.

As of today (12.02.2021), Mecklenburg-Vorpommern only contains key "total". Other keys like "rs", "vaccinated", "vaccinated_by_accine", etc. are missing.

"Mecklenburg-Vorpommern": {"total": 1608138}, "Niedersachsen":

Is something wrong with parsing data for Mecklenburg-Vorpommern?

Hi,

the RKI added a new column for the 'AstraZeneca' vaccine, so 'difference_to_the_previous_day' and all others columns behind this position are not working anymore.

As you did such a wonderful job with the vaccination data, here comes the feature request to also cover the hospitalization rate. RKI data is available as a a csv file here on GitHub.

This does not really cover the current scope of a vaccination data API. However, as the hospitalization rate grows more important, I thought I at least ask. Client scripts could then easily use the hospitalization data.

The RKI did not update the name of the sheet. The only source where the date is correct is on their page https://www.rki.de/DE/Content/InfAZ/N/Neuartiges_Coronavirus/Daten/Impfquoten-Tab.html

just FYI

Hey @ThisIsBenny,

just wanted to create this issue to let you know that as of today, scraping the RKI excel sheet fails, probably because of a new layout in the sheet.

If I find time today, I can fix that for sure :)

Have a nice day!

Moin, spricht was dagegen

Access-Control-Allow-Origin: *

zu aktivieren, das man mit jeder Website drauf zugreifen könnte?