COVID-19 vaccination doses administered in Germany, per state

Archived; see https://github.com/robert-koch-institut/COVID-19-Impfungen_in_Deutschland instead.

---

The year is 2021. The RKI is sharing vaccination statistics through an Excel spreadsheet. The spreadsheet only contains detailed data for a single day at a time — meaning historical data is lost every time the sheet gets updated.

This repository aims to…

1. extract the data into CSV for easier machine-readability
2. pull in hourly, automated updates
3. preserve the historical data for each German state
4. visualize the data with charts

As of 2021-02-11, this repository also provides data on vaccine orders being delivered into Germany.

CSV details

pubDate vs. date

The CSV contains two date columns:

• pubDate refers to the “last modified” date of the source sheet, as found in the Excel file’s metadata.
• date refers to the date of the vaccination statistics, as listed in the Excel sheet’s contents.

Usually, the spreadsheets containing the statistics for day X are published on day X + 1, but there have been exceptions where the stats got published on the same day. In case multiple spreadsheets are released containing data for the same date, we only consider the latest version.

Partially vs. fully vaccinated

There’s been some confusion about what “partial” vaccination means. Given that there are multiple potentially interesting metrics that RKI does not report directly, we derive and expose the following additional columns:

• onlyPartiallyVaccinatedCumulative: the number of people who are partially vaccinated but still need a second shot. (They received exactly 1 dose of Pfizer/BioNTech, Moderna, Oxford/AstraZeneca, and still need a second dose to become fully vaccinated.)
• onlyPartiallyVaccinatedPercent
• atLeastPartiallyVaccinatedCumulative: the number of people who received at least one vaccination. (They received at least 1 dose of Pfizer/BioNTech, Moderna, Oxford/AstraZeneca, or Johnson & Johnson. This includes people who received 2 doses of Pfizer/BioNTech, Moderna, or Oxford/AstraZeneca.)
• atLeastPartiallyVaccinatedPercent
• fullyVaccinatedCumulative: the number of people who received either 1 dose of Johnson & Johnson; or 2 doses of Pfizer/BioNTech, Moderna, or Oxford/AstraZeneca.
• fullyVaccinatedPercent

Anomalies in the data

Cumulative vaccination metrics cannot decrease over time, yet sometimes the reported data contains such a “drop” (as reflected in the charts). These anomalies match the data reported by the RKI, which sometimes overreports statistics and then corrects the numbers for the next day, or vice versa. (Sadly, the RKI doesn’t publish corrected numbers for the previous day, else we could retroactively correct our data.)

date	state	metric	previous value	current value	delta
2021-01-17	Mecklenburg-Vorpommern	initial doses	37,570	37,564	-6
2021-01-17	Mecklenburg-Vorpommern	total doses	37,570	37,564	-6
2021-01-17	Sachsen-Anhalt	initial doses	33,182	33,148	-34
2021-01-19	Bremen	initial doses	12,866	12,799	-67
2021-01-19	Mecklenburg-Vorpommern	final doses	1,157	379	-778
2021-01-21	Saarland	initial doses	18,612	16,773	-1,839
2021-01-26	Bayern	final doses	93,628	86,350	-7,278
2021-01-26	Bayern	initial doses	290,683	278,653	-12,030
2021-01-26	Bayern	total doses	384,311	365,003	-19,308
2021-02-11	Mecklenburg-Vorpommern	initial doses	64,308	60,805	-3,503
2021-02-11	Mecklenburg-Vorpommern	total doses	93,200	92,448	-752
2021-02-28	Mecklenburg-Vorpommern	initial doses	79,502	79,501	-1
2021-02-28	Mecklenburg-Vorpommern	total doses	128,499	128,498	-1
2021-03-12	Nordrhein-Westfalen	final doses	558,007	514,244	-43,763
2021-03-12	Nordrhein-Westfalen	initial doses	1,240,927	1,201,981	-38,946
2021-03-12	Nordrhein-Westfalen	total doses	1,798,934	1,716,225	-82,709
2021-03-30	Hamburg	final doses	91,010	89,410	-1,600
2021-03-30	Hamburg	initial doses	219,143	209,069	-10,074
2021-03-30	Hamburg	total doses	310,153	298,479	-11,674
2021-03-30	Mecklenburg-Vorpommern	initial doses	166,043	165,242	-801
2021-03-30	Rheinland-Pfalz	final doses	182,576	177,288	-5,288
2021-03-30	Rheinland-Pfalz	initial doses	493,446	485,363	-8,083
2021-03-30	Rheinland-Pfalz	total doses	676,022	662,651	-13,371
2021-04-09	Brandenburg	initial doses	427,850	404,970	-22,880
2021-04-09	Brandenburg	total doses	554,574	536,065	-18,509
2021-04-28	Brandenburg	final doses	180,753	174,796	-5,957
2021-06-09	Sachsen-Anhalt	initial doses	956,099	936,310	-19,789
2021-06-15	Bayern	initial doses	5,953,005	5,860,235	-92,770
2021-06-15	Bayern	total doses	9,460,419	9,459,403	-1,016
2021-07-01	Sachsen	initial doses	1,910,506	1,880,100	-30,406
2021-07-01	Sachsen	total doses	3,382,361	3,370,828	-11,533
2021-08-20	Baden-Württemberg	available doses	14,243,062	14,137,462	-105,600
2021-08-20	Bayern	available doses	17,042,187	16,303,837	-738,350
2021-08-20	Berlin	available doses	5,007,440	4,953,840	-53,600
2021-08-20	Brandenburg	available doses	3,210,848	3,182,248	-28,600
2021-08-20	Bremen	available doses	930,333	911,133	-19,200
2021-08-20	Hamburg	available doses	2,569,736	2,512,736	-57,000
2021-08-20	Hessen	available doses	8,567,632	8,497,032	-70,600
2021-08-20	Mecklenburg-Vorpommern	available doses	2,155,444	2,122,644	-32,800
2021-08-20	Niedersachsen	available doses	10,909,192	10,788,792	-120,400
2021-08-20	Nordrhein-Westfalen	available doses	24,421,455	23,484,505	-936,950
2021-08-20	Rheinland-Pfalz	available doses	5,180,223	5,079,323	-100,900
2021-08-20	Sachsen-Anhalt	available doses	2,758,025	2,736,025	-22,000
2021-08-20	Sachsen	available doses	4,741,500	4,590,300	-151,200
2021-08-20	Schleswig-Holstein	available doses	3,879,656	3,836,656	-43,000
2021-08-20	Thüringen	available doses	2,711,357	2,680,557	-30,800
2021-09-03	Baden-Württemberg	available doses	14,252,102	13,935,602	-316,500
2021-09-03	Bayern	available doses	16,757,713	16,711,213	-46,500
2021-09-03	Berlin	available doses	5,137,020	5,063,120	-73,900
2021-09-03	Brandenburg	available doses	3,239,839	3,236,039	-3,800
2021-09-03	Bremen	available doses	929,979	927,279	-2,700
2021-09-03	Hamburg	available doses	2,590,178	2,549,178	-41,000
2021-09-03	Hessen	available doses	8,620,312	8,618,012	-2,300
2021-09-03	Mecklenburg-Vorpommern	available doses	2,152,487	2,140,787	-11,700
2021-09-03	Niedersachsen	available doses	10,977,066	10,785,966	-191,100
2021-09-03	Rheinland-Pfalz	available doses	5,169,921	5,146,721	-23,200
2021-09-03	Sachsen-Anhalt	available doses	2,777,221	2,735,521	-41,700
2021-09-03	Sachsen	available doses	4,671,506	4,671,006	-500
2021-09-26	Niedersachsen	available doses	11,049,130	11,039,530	-9,600
2021-10-25	Baden-Württemberg	available doses	14,739,722	14,248,422	-491,300
2021-10-25	Bayern	available doses	18,055,997	17,738,697	-317,300
2021-10-25	Brandenburg	available doses	3,413,943	3,222,943	-191,000
2021-10-25	Bremen	available doses	1,035,484	1,005,484	-30,000
2021-10-25	Hamburg	available doses	2,746,380	2,665,280	-81,100
2021-10-25	Hessen	available doses	9,205,501	8,857,501	-348,000
2021-10-25	Mecklenburg-Vorpommern	available doses	2,241,718	2,162,418	-79,300
2021-10-25	Niedersachsen	available doses	11,396,313	10,985,913	-410,400
2021-10-25	Nordrhein-Westfalen	available doses	25,555,079	25,201,179	-353,900
2021-10-25	Rheinland-Pfalz	available doses	5,491,217	5,413,417	-77,800
2021-10-25	Saarland	available doses	1,528,556	1,483,456	-45,100
2021-10-25	Sachsen-Anhalt	available doses	2,909,248	2,861,048	-48,200
2021-10-25	Sachsen	available doses	4,983,650	4,912,850	-70,800
2021-10-25	Schleswig-Holstein	available doses	4,202,133	4,142,133	-60,000
2021-10-25	Thüringen	available doses	2,942,825	2,794,025	-148,800
2021-12-19	Berlin	final doses	2,633,169	2,590,531	-42,638
2021-12-19	Berlin	initial doses	2,597,809	2,592,364	-5,445
2022-02-27	Hessen	initial doses	4,561,233	4,558,716	-2,517
2022-04-12	Rheinland-Pfalz	available doses	8,649,124	8,438,314	-210,810
2022-04-19	Thüringen	initial doses	1,392,742	1,392,721	-21
2022-04-20	Nordrhein-Westfalen	available doses	45,016,664	44,887,814	-128,850

These are not issues in our scripts!

Related projects

You can preview the raw data provided by this repository in GitHub’s Flat Viewer.

To view historical snapshots of the source Excel files from the RKI, consult evilpie/Impfquotenmonitoring or ard-data/2020-rki-impf-archive.

To view similar data for the city of Munich specifically, refer to mathiasbynens/covid-19-vaccinations-munich.

This repository complements the incredible owid/covid-19-data project, which includes vaccination data for Germany as a whole, but not for individual German states. The sociepy/covid19-vaccination-subnational project offers a global collection of regional vaccination data, and relies on our data (❤️).