Rki covid

Setting up the Rki covid connector

No	Item	Required	Example	Notes
1	Start Date	Yes		UTC date in the format 2017-01-25. Any data before this date will not be replicated.

Tables in the Rki covid connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	germany_states_age_groups	7		Full Refresh
2	german_history_frozen_incidence	2		Full Refresh, Incremental	date
3	germany_age_groups	6		Full Refresh
4	states_history_deaths	4		Full Refresh	date
5	german_history_hospitalization	13		Full Refresh, Incremental	date
6	germany_history_cases	2		Full Refresh, Incremental	date
7	germany	10		Full Refresh
8	german_history_deaths	2		Full Refresh, Incremental	date
9	states_history_incidence	4		Full Refresh	date
10	german_history_incidence	2		Full Refresh, Incremental	date
11	states_history_recovered	4		Full Refresh	date
12	states_history_frozen_incidence	5		Full Refresh	date
13	states_history_cases	4		Full Refresh	date
14	states_history_hospitalization	15		Full Refresh	date
15	german_history_recovered	2		Full Refresh, Incremental	date
16	germany_states	13		Full Refresh

Table: germany_states_age_groups

No	Column Name	Type	Notes
1	A05-A14	VARCHAR
2	A60-A79	VARCHAR
3	A35-A59	VARCHAR
4	A15-A34	VARCHAR
5	abbreviation	VARCHAR
6	A80+	VARCHAR
7	A00-A04	VARCHAR

Table: german_history_frozen_incidence

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	weekIncidence	DOUBLE

Table: germany_age_groups

No	Column Name	Type	Notes
1	A05-A14	VARCHAR
2	A60-A79	VARCHAR
3	A35-A59	VARCHAR
4	A15-A34	VARCHAR
5	A80+	VARCHAR
6	A00-A04	VARCHAR

Table: states_history_deaths

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	name	VARCHAR
3	abbreviation	VARCHAR
4	deaths	INTEGER

Table: german_history_hospitalization

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	updatedCases7Days	INTEGER
3	updatedIncidence7Days	DOUBLE
4	adjustedLowerIncidence7Days	DOUBLE
5	adjustedIncidence7Days	DOUBLE
6	incidence7Days	DOUBLE
7	adjustedLowerCases7Days	INTEGER
8	adjustedCases7Days	INTEGER
9	fixedCases7Days	INTEGER
10	adjustedUpperCases7Days	INTEGER
11	adjustedUpperIncidence7Days	DOUBLE
12	cases7Days	INTEGER
13	fixedIncidence7Days	DOUBLE

Table: germany_history_cases

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	cases	INTEGER

Table: germany

No	Column Name	Type	Notes
1	recovered	INTEGER
2	r	VARCHAR
3	cases	INTEGER
4	casesPerWeek	INTEGER
5	hospitalization	VARCHAR
6	weekIncidence	DOUBLE
7	meta	VARCHAR
8	delta	VARCHAR
9	casesPer100k	DOUBLE
10	deaths	INTEGER

Table: german_history_deaths

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	deaths	INTEGER

Table: states_history_incidence

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	weekIncidence	DOUBLE
3	name	VARCHAR
4	abbreviation	VARCHAR

Table: german_history_incidence

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	weekIncidence	DOUBLE

Table: states_history_recovered

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	recovered	INTEGER
3	name	VARCHAR
4	abbreviation	VARCHAR

Table: states_history_frozen_incidence

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	weekIncidence	DOUBLE
3	name	VARCHAR
4	abbreviation	VARCHAR
5	dataSource	VARCHAR

Table: states_history_cases

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	cases	INTEGER
3	name	VARCHAR
4	abbreviation	VARCHAR

Table: states_history_hospitalization

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	updatedCases7Days	INTEGER
3	updatedIncidence7Days	DOUBLE
4	adjustedLowerIncidence7Days	DOUBLE
5	abbreviation	VARCHAR
6	adjustedIncidence7Days	DOUBLE
7	incidence7Days	DOUBLE
8	name	VARCHAR
9	adjustedLowerCases7Days	INTEGER
10	adjustedCases7Days	INTEGER
11	fixedCases7Days	INTEGER
12	adjustedUpperCases7Days	INTEGER
13	adjustedUpperIncidence7Days	DOUBLE
14	cases7Days	INTEGER
15	fixedIncidence7Days	DOUBLE

Table: german_history_recovered

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	recovered	INTEGER

Table: germany_states

No	Column Name	Type	Notes
1	cases	INTEGER
2	hospitalization	VARCHAR
3	weekIncidence	DOUBLE
4	delta	VARCHAR
5	abbreviation	VARCHAR
6	population	INTEGER
7	deathsPerWeek	INTEGER
8	recovered	INTEGER
9	casesPerWeek	INTEGER
10	name	VARCHAR
11	id	INTEGER
12	casesPer100k	DOUBLE
13	deaths	INTEGER

External Resources

• Robert Koch-institut Covid Api

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.