Comparing COVID-19 cases in the United States and Europe

In this dashboard I wanted to show the differences between the number of COVID-19 cases in the United States and Europe. Thanks to Johnny Miller from Unequal Scenes for the suggestion to take a look at the data.

At the time of writing it seems that the US and Europe have become the two epicenters of the Coronavirus pandemic. Since the US and the European Union have similar populations and GDPs I thought it would be interesting to get a sense of how COVID-19 is affecting them.

In this case ‘Europe’ includes all European Union countries (Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Czechia, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, and Sweden) as well as non-EU countries like Iceland, Norway, Switzerland, and the United Kingdom.

At the time of writing the United States had 461,437 confirmed cases and 16,478 deaths. New York was clearly the centre of the virus outbreak.

Coronavirus cases across US states. New York is the centre of the COVID-19 pandemic in America.

At the same time Europe had 758,078 cases and 65,458 deaths. Spain had overtaken Italy with the highest number of cases. Germany had a very high number of cases but few deaths, and has apparently done much more testing with the Financial Times reporting that the country was doing more than 50,000 tests a day.

Coronavirus cases across Europe in early April 2020. Spain has the highest number of COVID 19 cases in Europe.

The Dataset

“This is the data repository for the 2019 Novel Coronavirus Visual Dashboard  operated by the Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE).”

JHU Coronavirus COVID-19 Global Cases used to create a COVID-19 dashboard in Google Data Studio

“This database was created in response to the Coronavirus public health emergency to track reported cases in real-time. “

“The data include the location and number of confirmed COVID-19 cases, deaths, and recoveries for all affected countries, aggregated at the appropriate province or state. It was developed to enable researchers, public health authorities and the general public to track the outbreak as it unfolds. “

Find out more about the public data set at this link.

If you’d like to learn about how to connect to the public data sets available in BigQuery you can read this blog post on the topic.

My Other Blog Posts

If you found this post interesting, you might enjoy my other blog posts.