Connectors

/

RKI Covid

RKI Covid

Others

Sync RKI Covid data anywhere.

RKI stands for the Robert Koch Institute is continuously monitoring the situation, evaluating all available information, estimating the risk for the population in Germany. RKI Corvid provides selected information on COVID-19 available in English. In the connector source RKI Corvid we want to add streams for the states that include history data , incidence rate , cases , deaths and so on.

  • Standard
  • Alpha
  • 8 streams
  • 8Streams
  • 50+Destinations
One connector

Everything RKI Covid can do in Airbyte

  • Sync to your warehouse

    Land 8 RKI Covid tables in 50+ destinations on a schedule you control.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • Cloud or self-hosted

    Run the RKI Covid connector on Cloud, Self-Managed Enterprise.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • NamespacesNot supported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version0.1.41

Set up in 10 steps

  1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
  2. Click on the "Add Source" button in the top right corner of the screen.
  3. In the search bar, type "RKI Covid" and select the RKI Covid source connector from the list of available sources.
  4. Enter the necessary credentials for the RKI Covid source connector, including the API key and any other required information.
  5. Once the credentials have been entered, click on the "Test" button to ensure that the connection is working properly.
  6. If the test is successful, click on the "Save" button to save the RKI Covid source connector to your list of sources.
  7. You can now use the RKI Covid source connector to extract data from the RKI Covid API and integrate it with other data sources in Airbyte.
  8. To set up a data integration pipeline using the RKI Covid source connector, navigate to the "Destinations" tab on the left-hand side of the screen and select the destination you want to use.
  9. Follow the prompts to set up the data integration pipeline, including selecting the RKI Covid source connector as the source and the destination you want to use.
  10. Once the pipeline is set up, you can run it to extract data from the RKI Covid API and integrate it with your other data sources.
8 streams

Every table you can sync from RKI Covid

  • Germany

  • Germany by age and groups

  • Germany cases by days

  • Germany incidences by days

  • Germany deaths by days

  • Germany recovered by days

  • Germany frozen-incidence by days

  • Germany hospitalization by days

FAQ

Common questions

What is ETL?

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

What data can you extract from RKI Covid?

The RKI Covid's API provides access to a wide range of data related to the Covid-19 pandemic in Germany. The data can be categorized into the following categories:

1. Case data: This includes information on the number of confirmed cases, deaths, and recoveries in Germany.
2. Testing data: This includes information on the number of tests conducted, the positivity rate, and the number of tests per capita.
3. Hospitalization data: This includes information on the number of hospitalizations, ICU admissions, and ventilator use.
4. Vaccination data: This includes information on the number of people vaccinated, the number of doses administered, and the percentage of the population vaccinated.
5. Geographic data: This includes information on the number of cases and deaths by state, district, and municipality.
6. Demographic data: This includes information on the age, gender, and ethnicity of Covid-19 patients.
7. Time series data: This includes information on the daily and cumulative number of cases, deaths, and vaccinations over time.

Overall, the RKI Covid's API provides a comprehensive set of data that can be used to track the spread of Covid-19 in Germany and inform public health policies and interventions.

How do I transfer data from RKI Covid?

1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
2. Click on the "Add Source" button in the top right corner of the screen.
3. In the search bar, type "RKI Covid" and select the RKI Covid source connector from the list of available sources.
4. Enter the necessary credentials for the RKI Covid source connector, including the API key and any other required information.
5. Once the credentials have been entered, click on the "Test" button to ensure that the connection is working properly.
6. If the test is successful, click on the "Save" button to save the RKI Covid source connector to your list of sources.
7. You can now use the RKI Covid source connector to extract data from the RKI Covid API and integrate it with other data sources in Airbyte.
8. To set up a data integration pipeline using the RKI Covid source connector, navigate to the "Destinations" tab on the left-hand side of the screen and select the destination you want to use.
9. Follow the prompts to set up the data integration pipeline, including selecting the RKI Covid source connector as the source and the destination you want to use.
10. Once the pipeline is set up, you can run it to extract data from the RKI Covid API and integrate it with your other data sources.

What are top ETL tools to transfer data from RKI Covid?

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

What is ELT?

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

Difference between ETL and ELT?

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving RKI Covid data today

Free for 14 days on Airbyte Cloud. Set up the RKI Covid connector once and let Airbyte keep it in sync.