How to access and query the world's COVID-19 data

Joe Drumgoole Profile picture for user Joe Drumgoole April 30, 2020
Summary:
Joe Drumgoole, Global Director of Developer Relations at MongoDB, explains how MongoDB Atlas can be used to make COVID-19 data more accessible and queryable.

If you or your organisation want simple access to the excellent Johns Hopkins COVID-19 data set you can now do that through this hosted MongoDB cluster.

You will have heard the name Johns Hopkins University (JHU) come up a lot on the news.

As the COVID-19 pandemic has swept the globe JHU has become a vital source of collated, accurate data.

Image of MongoDB COVID-19 data visualised
(Image sourced via MongoDB - Screenshot of Johns Hopkin’s live dashboard )

JHU publishes its own dashboard and makes the data available for anyone to download and query.

From clinicians to journalists, the data has become a touchpoint for people trying to better understand the spread of the disease.

However, the JHU data is delivered as a flat CSV file which needs to be downloaded for each new query.

We wanted to make it easier to access up-to-date data and to enable more people to build helpful applications.

So our developer relations team is now hosting the JHU data in a MongoDB Atlas database making it more accessible and queryable. The data is updated hourly by an automated script.

This data is free for anyone to query using the MongoDB Query language or SQL. We also support a variety of business intelligence tools directly so you can query the data with Tableau, Qlik and Excel.

The data is identical to that provided by JHU with the caveat that it has been converted to a JSON format to make it easier to index and query.

To access the data visit: https://developer.mongodb.com/article/johns-hopkins-university-covid-19-data-atlas

If you have a project that is helping to combat COVID-19 and need help with hosting, let us know.

If you have any questions, feedback or thoughts on how to improve this service, don't be shy: @jdrumgoole or [email protected].

Loading
A grey colored placeholder image