TL;DR Short answer: RKI COVID ETL tools load German COVID-19 data from the Robert Koch Institute into a warehouse or notebook. Airbyte's RKI Covid connector reads api.corona-zahlen.org, a community-run API built on RKI data rather than an official RKI service, so check that it is responding before you build on it. For the authoritative source, read the RKI's own open-data repositories on GitHub directly. Six RKI COVID ETL tools compared:
Airbyte : an RKI Covid connector with national, state and historical streams, alongside 700+ other sources.RKI open data on GitHub : the Robert Koch Institute's official datasets, published as files you can load directly.Self-hosted rki-covid-api : the community API's open-source server, run in your own Docker environment.dlt : an open-source Python library that loads the API's JSON or RKI files into a warehouse.Python with pandas : reads RKI's CSV files straight from GitHub into a DataFrame for analysis.n8n : workflow automation that checks the API and stores new figures on a schedule.The RKI COVID constraint: routine COVID-19 reporting in Germany has been scaled back since the pandemic phase ended, so expect less frequent updates and verify the source is still active before relying on it. RKI COVID ETL tools move German COVID-19 data, such as cases, deaths, incidence, hospitalisations and vaccinations by country, state and district, into a warehouse, database or notebook for research, reporting and historical analysis. Today the data is mostly used for retrospective analysis rather than live monitoring. For other public data sources, see our guide to NASA ETL tools .
Is RKI COVID data still available? Yes, but the sources differ. The Robert Koch Institute publishes its COVID-19 datasets as open data in repositories on GitHub, which remain the authoritative source. The api.corona-zahlen.org API, which Airbyte's connector reads, is a community project by Marlon Lückert that repackages RKI data as JSON. It has had outages when the RKI feeds it depends on were unreachable, so check that it responds before scheduling syncs.
Because routine reporting has wound down, treat this data as a historical record. If you need the most reliable copy, load the RKI's files directly or self-host the community API.
Every tool here ultimately reads the Robert Koch Institute's published figures. The main data is:
National figures: cases, deaths and recoveries for Germany, with daily differences. States and districts: the same figures broken down by federal state and district. Incidence: seven-day incidence values, nationally and regionally. History: time series of cases, deaths, incidence and recoveries. Hospitalisations and vaccinations: hospitalisation incidence and vaccination figures, where published. How do the RKI COVID ETL tools compare? Tool Approach Source Best for Cost Airbyte Pre-built connector api.corona-zahlen.org RKI data next to other sources in a warehouse Free self-hosted Core; paid Cloud plans RKI on GitHub Official files Robert Koch Institute Authoritative historical data Free Self-hosted API Docker server RKI data, your own instance Teams that need the API but not its uptime risk Free, your hosting dlt Python loader API or RKI files Python teams loading a warehouse Free, open source Python with pandas CSV reading RKI files Notebooks and research Free, open source n8n HTTP Request node API Simple scheduled checks Free self-hosted; paid cloud
Which RKI COVID ETL tools should you consider? Six RKI COVID ETL tools, from a pre-built connector to the official files:
1. Airbyte Airbyte is the open-source data connectivity platform for AI and analytics, and among RKI COVID ETL tools it is the one with a pre-built connector. Its RKI Covid source syncs national, state and historical streams from api.corona-zahlen.org, with a start date for historical data. Because that API is community-run rather than an official RKI service, test the connection before scheduling syncs. For more ELT options, see our guide to ELT tools .
Airbyte runs in Airbyte Cloud, in your own environment with Airbyte Flex, or self-hosted with Airbyte Core.
Pros Cons Pre-built connector with historical streams Depends on a community-run API RKI data next to other sources Fewer updates now that reporting has wound down Cloud, Flex or self-hosted Core Not an official RKI service
2. RKI open data on GitHub The Robert Koch Institute publishes its COVID-19 datasets, such as incidence, hospitalisations and vaccinations, as versioned files in public GitHub repositories. Loading these directly gives you the authoritative data without depending on any intermediary API.
Pros Cons Official and authoritative Files to download and model yourself Versioned and citable Formats differ between datasets No API to go down Not a JSON API
3. Self-hosted rki-covid-api The community API is open source, and its server can be run in your own Docker environment. That gives you the same JSON endpoints without relying on the public instance's uptime, though you still depend on the RKI feeds it reads.
Pros Cons Same endpoints under your control You run and maintain the server Open source Still depends on RKI's upstream files Avoids public instance outages Community-maintained code
4. dlt dlt is an open-source Python library for loading data. It can call the community API or read RKI's files and load them into DuckDB, BigQuery, Snowflake or Postgres with schema inference. For more code-first options, see our guide to Python ETL tools .
Pros Cons Works with the API or files You write and schedule the pipeline Schema inference Requires Python skills Free and open source Source changes are yours to handle
5. Python with pandas pandas can read RKI's CSV files directly from their GitHub URLs into a DataFrame, which is the quickest route for notebooks, charts and research. For more on CSV pipelines, see our guide to CSV file ETL tools .
Pros Cons Fastest route for research Not a pipeline: scheduling is up to you Reads official files directly Storage and history are yours Free and open source Needs Python skills
6. n8n n8n can call the community API on a schedule, check that it responds, and store new figures in a database or sheet, with an alert if the API stops returning data.
Pros Cons Self-hosting option You run and maintain it if self-hosted Easy health checks and alerts Not built for large backfills Hundreds of destination integrations Depends on the API being available
What should you check before syncing RKI COVID data? Whichever RKI COVID ETL tools you choose, check these first:
Source status: test that api.corona-zahlen.org responds, or load the RKI's GitHub files directly.Update frequency: expect infrequent updates now that routine reporting has been scaled back.Reporting dates: distinguish the reporting date from the date of illness onset, which RKI publishes separately.Revisions: historical figures are revised as late reports arrive, so reload history rather than only appending new days.Licensing: the community API is licensed CC BY 4.0, so credit it and the RKI when you publish results.Which RKI COVID ETL tool should you choose? Choosing between RKI COVID ETL tools comes down to how much you trust the source you read. For authoritative historical analysis, load the RKI's GitHub files with pandas or dlt. For data next to other sources in a warehouse, Airbyte's connector works when the community API is up, and self-hosting the API removes that dependency. For other ways to load files and APIs, see our guide to data ingestion tools .
Load RKI COVID data with Airbyte Sync German COVID-19 figures into the same warehouse as your other data with Airbyte, in Airbyte Cloud, in your own environment with Airbyte Flex, or self-hosted with Airbyte Core.
Try Airbyte Cloud free for 14 days or talk to our team .
Frequently Asked Questions (FAQs) 1. What are the best RKI COVID ETL tools? Airbyte has an RKI Covid connector for loading data into a warehouse, and the RKI's own GitHub repositories are the authoritative source for direct loads with pandas or dlt. The community API can also be self-hosted, and n8n suits simple scheduled checks.
2. Is api.corona-zahlen.org an official RKI API? No. It is a community project by Marlon Lückert that repackages Robert Koch Institute data as JSON. The RKI publishes its official datasets in repositories on GitHub.
3. Is RKI COVID data still updated? Routine COVID-19 reporting in Germany has been scaled back since the pandemic phase ended, so updates are less frequent. Check each dataset's latest date before relying on it.
4. Can I self-host the RKI COVID API? Yes. The community API is open source and can run in your own Docker environment, which avoids depending on the public instance's uptime.
Suggested reads NASA ETL Tools
Wikipedia Pageviews ETL Tools
CSV File ETL Tools
Data Ingestion Tools