RKI COVID-19
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect RKI COVID-19 to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Pull German COVID-19 statistics (nationwide, per state, and per district) into the PostHog Data warehouse from the public RKI COVID-19 API at api.corona-zahlen.org.
No credentials are needed. The API is a community-maintained wrapper (by Marlon Lückert) over published Robert Koch-Institut figures, not an official RKI service.
Optionally limit the history tables to the last N days; leave empty to sync the full history.
Configuration
| Option | Type | Required |
|---|---|---|
History window (days) | number | No |
Linking RKI COVID-19 to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select RKI COVID-19
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
germany | Current nationwide COVID-19 snapshot for Germany: cumulative cases, deaths, recoveries, week incidence, R value, and hospitalization. One row, replaced on every sync. | Full refresh | — | — |
germany_age_groups | Nationwide cases, deaths, and hospitalization broken down by age group and sex. One row per age group. Full refresh. | Full refresh | — | age_group |
germany_history_cases | Daily new reported COVID-19 cases for Germany. One row per day. Full refresh. | Full refresh | — | date |
germany_history_incidence | Daily 7-day incidence per 100k inhabitants for Germany. One row per day. Full refresh. | Full refresh | — | date |
germany_history_deaths | Daily new reported COVID-19 deaths for Germany. One row per day. Full refresh. | Full refresh | — | date |
germany_history_recovered | Daily newly recovered COVID-19 cases for Germany. One row per day. Full refresh. | Full refresh | — | date |
germany_history_frozen_incidence | Daily 7-day incidence for Germany as originally published (not retroactively corrected). One row per day. Full refresh. | Full refresh | — | date |
germany_history_hospitalization | Daily 7-day hospitalization cases and incidence for Germany, including reporting-delay adjusted values. One row per day. Full refresh. | Full refresh | — | date |
states | Current COVID-19 snapshot per German federal state (Bundesland): cases, deaths, recoveries, week incidence, and hospitalization. One row per state. Full refresh. | Full refresh | — | abbreviation |
districts | Current COVID-19 snapshot per German district (Landkreis), keyed by the official municipality key (AGS). One row per district. Full refresh. | Full refresh | — | ags |
testing_history | Weekly PCR testing figures for Germany: performed tests, positive tests, positivity rate, and reporting laboratories. One row per calendar week. Full refresh. | Full refresh | — | calendarWeek |