For all those, who are struggling with gathering and preparing COVID-19 data, we've created a free API that makes it easy to integrate the latest worldwide and Germany COVID-19 data into your application. The API uses official data from the European Centre for Disease Prevention and Control (world data) as well as Robert-Koch Institute (Germany data, through this Wikipedia article) and delivers a clear and concise data structure for further processing, analysis etc.

If you have any questions, do not hesitate to open an issue or to contact us. If you use our API in your website or product, it would be great, if you could add a link to our website: https://www.statworx.com. Thank you and stay healthy!

The world API delivers data for 196 countries, queryable by their 2-character country alpha codes. If you want to query all countries, use {'code': 'ALL'} in the payload. You can invoke the API using any programming language, e.g. Python:

import requests
import json
import pandas as pd

# POST to API
payload = {'code': 'DE'}
URL = 'https://api.statworx.com/covid'
response = requests.post(url=URL, data=json.dumps(payload))

# Convert to data frame
df = pd.DataFrame.from_dict(json.loads(response.text))

or R:

library(httr)
library(jsonlite)

# Post to API
payload <- list(code = "DE")
response <- httr::POST(url = "https://api.statworx.com/covid",
                       body = toJSON(payload, auto_unbox = TRUE), encode = "json")

# Convert to data frame
content <- rawToChar(response$content)
df <- data.frame(fromJSON(content))

This is what the result looks like:

The Germany data API is very similar to the world data API, except that (at the moment) it does not require any payload. This means that you can als use simple GET-requests for querying the data. For Python, you would query the data like this:

import requests
import json
import pandas as pd

# POST to API
URL = 'https://api.statworx.com/covid/de'
response = requests.get(url=URL)

# Convert to data frame
df = pd.DataFrame.from_dict(json.loads(response.text))

Again, in R we use:

library(httr)
library(jsonlite)

# Post to API
response <- httr::GET(url = "https://api.statworx.com/covid", encode = "json")

# Convert to data frame
content <- rawToChar(response$content)
df <- data.frame(fromJSON(content))

The resulting data frame looks something like this:

The API JSON response contains the following data points:

There are several COVID-19 data sources out there. However, most of the sources are kind of quirky (e.g. wide format, bad column names etc.). Furthermore, many data sources so not contain the cumulative sum of cases or population information for relative KPIs. Our API data is arranged and named using best practices (e.g. long format, snake case variable names) and augmented with cumulative case and death numbers as well as population info on country (world API) and state (Germany API) level.

The API is built using Python 3 and deployed using Google Cloud Run, a container-based serverless function framework in the cloud.

If you have any questions or remarks, do not hesitate to open an issue or to contact us. Also, if you use our API in your website or product, it would be great, if you could add a link to our website: https://www.statworx.com. Thank you and stay healthy!