Heya, maintainer of Frappe Charts here. We have v2 for frappe charts in Beta. You can check out the v2-beta branch on Github. It has some new features and other enhancements, on of it is better tooltips.

Current tooltips have this scaling problem.

This is solved in v2 with new tooltips looking like this.

I do almost weekly releases of v2 beta expecting a official release soon. You it's published under the next tag, you can try it out in your project by replacing the CDN link with this

- import { Chart } from 'https://cdn.jsdelivr.net/npm/[email protected]/dist/frappe-charts.min.esm.js';
+ import { Chart } from 'https://unpkg.com/[email protected]/dist/frappe-charts.esm.js';

I'm guessing the upstream spreadsheet structure changed once again. Investigating…

For example, we’re currently at ~78%:

A total of 4,146,348 doses have been administered so far — that’s 77.66% of the 5,339,295 total doses that have been delivered to Germany as of 2021-02-09.

It would be interesting to plot this relation over time.

Suggested by Kay Y. Chen via email: include national numbers as well. E.g. Germany as a whole currently sits at 10.1 administered doses per 1000 inhabitants. We could also list the total absolute number of doses administered, and the national 7-day average.

There's a drop on 2021-03-30 in Hamburg:

https://mathiasbynens.github.io/covid-19-vaccinations-germany/#hamburg

Looks like the RKI made another whoopsie: https://mathiasbynens.github.io/covid-19-vaccinations-germany/#brandenburg

https://mathiasbynens.github.io/covid-19-vaccinations-germany/#doses-per-day
https://mathiasbynens.github.io/covid-19-vaccinations-germany/#doses-per-week

-0.67% of all partially vaccinated people awaiting their second shot (-51,783 out of 7,715,266 people) received a Moderna dose.

It might be time to retire some of the derived metrics. Ever since vaccines started to get mixed between doses (e.g. Oxford/AstraZeneca followed by Pfizer/BioNTech) there’s no longer a way to accurately compute them.

Like https://mathiasbynens.github.io/covid-19-vaccinations-germany/#doses-per-day but clustered per 7 days.

Requested by @evilpie, here: https://twitter.com/evilpies/status/1398310284809412608

firstDosesCumulativeModerna[daten_stand = 2021-01-25] = 30311
firstDosesCumulativeModerna[daten_stand = 2021-01-26] = 23661

Any idea?

Looks like the spreadsheet structure changed yet again. See fa31bb4 for an example of a broken import.

Impfdashboard inexplicably exposes DE-Betriebe as a new “region”. e4c726f restored the roll, but we should check if build-chart.js needs updating (it might not account for this new “region” yet).

The charts page currently says “65,865,011 total doses that have been delivered to Germany as of 2021-06-13”.
However, summing up all the deliveries in the source .tsv file gives 67,563,010.

67,563,010 - 65,865,011 = 1,697,999

Currently, the generated report says something like:

Across all of Germany, 7.35% of inhabitants are fully vaccinated, and 24.67% are at least partially vaccinated.

However, this is wrong. The 24.67% metric reported by the RKI as “begonnene Impfserie” refers to people who received (at least) 1 dose of Pfizer/BioNTech, Moderna, or AstraZeneca. Notably, it excludes J&J doses.

The real metric people seem to expect is “percentage of people stuck with a needle at least once”. To provide this metric we need to add the J&J doses and then compute the resulting percentages ourselves instead of relying on the RKI-reported numbers.

Would it be possible to add predictions based on the 7 day average and current deployment of how long until 50% and 75% respectively of the population has been vaccinated?

With the usual caveat that using statistics to extrapolate numbers like this is not an actuall prediction (taking planned availability etc of doses into account)...

The delivery data contains multiple deliveries of the same vaccine to the same state on the same date. Let’s consolidate such cases into a single entry.

Based on the upstream spreadsheet formulae, the new non-state “Bund” should not count towards the total. These doses are already represented in the state data — it’s just another data point. (It would have made more sense to add a column instead of a row in that case, or even a separate sheet…)

Based on the numbers in this article, the priority groups cover…

• 6 + 16 + 12 = 34 million people
• 7 + 20 + 15 = 42% of the population

Across all of Germany, 0.00% of inhabitants (0 out of 83,166,711 people) are fully vaccinated.

Probably another upstream change?

It would be the same as data.csv, except without the state column, and with all the metrics summed up for all states + Bundeswehr per day.

We can backfill the data for the Excel files with the following pubDates:

• 2020-12-31
• 2021-01-01
• 2021-01-02

A line chart like this one, with one line per state plotting vaccinationsCumulative per day, would be amazing. Any takers?

The RKI changed their spreadsheet structure. In addition to the structural changes, there are now many more data points included, such as vaccine dosage count per specific vaccine (BioNTech/Moderna so far).

We have to rewrite https://github.com/mathiasbynens/covid-19-vaccinations-germany/blob/main/process-xlsx.js accordingly.
Unfortunately, we’ll need to change the data/data.csv structure as well.

E.g. there’s a drop in total doses from 2021-04-16 to 2021-04-17, even though there are no anomalies in the input data for that day. I suspect something is going wrong with adding the Bund data.

https://mathiasbynens.github.io/covid-19-vaccinations-germany/#nordrhein-westfalen

https://github.com/mathiasbynens/covid-19-vaccinations-germany#anomalies-in-the-data

We could look at https://impfdashboard.de/static/data/germany_vaccinations_timeseries_v2.tsv (nation-wide numbers only) and possibly figure out the correct numbers based on that (if we assume only the data for one state was wrong for any given date).

It would be awesome to have a permanently visible slider on top with which the date range can be limited. By now there is a lot of data on the dashboard and the oldest data is less and less relevant.

As of 888ba28, fullyVaccinatedCumulative is missing, causing fullyVaccinatedPercent to be NaN. The upstream spreadsheet must’ve changed.

Run 186 was successful:

https://github.com/mathiasbynens/covid-19-vaccinations-germany/runs/1743778016#step:6:1

Run 187 wasn't:

https://github.com/mathiasbynens/covid-19-vaccinations-germany/runs/1744241887#step:6:1

For some reason, curl produces no output anymore, and also doesn’t actually download + save the file. This is why auto-updating failed today.

…just like we already do for Germany.

We have the data now.

From https://www.rki.de/DE/Content/InfAZ/N/Neuartiges_Coronavirus/Daten/Impfquoten-Tab.html:

Änderung der Tabelle zum Digitalen Impfquotenmonitoring ab Montag, 7.6.2021

1. Die Impfquote nach Alter wird in 3 Gruppen ausgewiesen (<18 Jahre, 18-59 Jahre und 60+ Jahre).
2. Es werden "mindestens einmal Geimpfte" und "vollständig Geimpfte" aufgeführt (zu beachten: Personen, die mit dem COVID-19 Vaccine Janssen von Janssen-Cilag International geimpft wurden, sind in beiden Kategorien aufgeführt).
3. Impfungen werden nicht mehr nach Impfstelle (Impfzentren/mobile Teams/Krankenhäuser und Niedergelassene Ärzteschaft) ausgewiesen. Über Impfungen nach Impfstelle soll wöchentlich gesondert berichtet werden.

We'll have to wait until Monday's spreadsheet, and then update our script accordingly.

Look at the numbers for Bayern:

• ~384k total cumulative doses reported for date=2021-01-25 (pubDate=2021-01-26)
• but only ~365k reported for date=2021-01-26 (pubDate=2021-01-27)

One of these must be wrong. My best guess is that RKI misreported the results for date=2021-01-25, and fixed it when reporting the date=2021-01-26 numbers.

Hi!
This is just an "FYI" message. First of all, thanks for your amazing resource. Inspired by OWID's project, I started a global collection of regional vaccination data and I am using yours (see sociepy/covid19-vaccination-subnational) 😄 !

So far I have referenced it in a reference table in the README file, but please let me know if you'd like it to be referenced differently.

Have a great day and feel free to close this issue!

https://mathiasbynens.github.io/covid-19-vaccinations-germany/ says:

A total of 17,010,883 doses have been administered so far […]

https://impfdashboard.de/ however says:

17.035.698 Verabreichte Impfdosen

Feature request from @marjakh:

There's the "daily vaccinations" graph, but since it doesn't have the avg line, it's hard to see where the total is going, as the numbers vary a lot

The first doses (in Germany) of the AstraZeneca vaccine were administered on 2021-02-08. The upstream spreadsheets now contain a new column for the first dosage of this vaccine. In a few weeks I suspect the spreadsheet structure will change once again, to add the second dosage column.

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…