API for exploring covid-19 cases around the globe powered by FastAPI framework


As going through 2020, it is clear that the year of the Rat has NOT been friendly at all. We have experienced a series of fierce events. For instance, the tension among global giants, protesting, Australian bushfire season, extreme racial discrimination, and noticeably the COVID-19 pandemic.

COVID-19 has been spreading rapidly without showing any signs of stopping or even slowing down. Even though this pandemic has made a lot of lives miserable, we work together closely as a community to tackle this problem and prevent further damage. Hence, all the data related MUST be collected and disseminated. More importantly, the data MUST also be accurate and accessible.

Therefore, as a software engineer, I have created my version of API allowing those who are in need of the data to be able to access to the public data collected by Johns Hopkins University. I do hope that this project will be useful as a contribution.

How it works behind the scene

Data collection is always a demanding process which needs to be done. Luckily, this process was already done by Johns Hopkins University and can be accessed at COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University However, the data is raw which can be quite difficult to read without knowing what exactly we are looking for.

By using FastAPI framework, I created an API server collecting data from the data repository and pre-processing them using a Python’s data analysis and manipulation library Pandas. With those powerful tools mentioned earlier, the data is ready to be queried quickly and effortlessly. Not only it provides a faster way to create an API server, but also an automatically-generated API documentation.



As the workflow depicted above suggests, the process is fairly simple and straight forward.

  1. Get a request from a user
  2. Get the raw data from the repository
  3. Pre-process the data using Pandas
  4. Send a response with the result data as JSON
  "data": {
    "confirmed": 16682030,
    "deaths": 659374,
    "recovered": 9711187,
    "active": 5538584
  "dt": "07-29-2020",
  "ts": 1595980800


Moreover, a Dockerfile is also included. This will allow the API server to be deployed with ease by simply using

docker-compose up -d

This will deploy and run a server on the background with pre-defined configurations which can be altered as see fit. Alternatively, we can also run a server with uvicorn as shown below for debugging purposes:

$ uvicorn main:app --reload
INFO:     Uvicorn running on (Press CTRL+C to quit)
INFO:     Started reloader process [16788]
INFO:     Started server process [9784]
INFO:     Waiting for application startup.
INFO:     Application startup complete.
INFO: - "GET / HTTP/1.1" 307
INFO: - "GET /docs HTTP/1.1" 200
INFO: - "GET /openapi.json HTTP/1.1" 200


This project is an open-source API server powered by FastAPI allowing everyone to access the COVID-19 data effortlessly. With a powerful library, as such Pandas, it allows the data manipulation to be performed quickly and clearly; furthermore, the data analysis can be done more efficiently. Without a doubt, the combination of FastAPI and Pandas demonstrates how impactful open data can be.

To Learn More

Please visit the following links