COVID-19 cases by Region of the World

COVID-19 by Region of the World

I wanted to build another Coronavirus dashboard in Google Data Studio, this time looking at the number of COVID-19 cases by region of the world.

COVID-19 Cases by Region of the World dashboard in Google Data Studio

Below is the dashboard showing the number of Coronavirus cases by geographic region.

Using the Johns Hopkins University COVID-19 Public Data set

It’s made using a public data set provided by Johns Hopkins University and available to connect to on Google BigQuery.

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

The JHU dataset includes the location and number of confirmed COVID-19 cases, deaths, and recoveries for affected countries.

The data set is updated daily and you can connect to it using the Google BigQuery connector.

Add BigQuery data source
Add BigQuery data source

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

Looking at the Number of COVID-19 Deaths by Region

With this dashboard I’ve made deaths the primary metric that displays first on the geo map and in the table. This is because the number of tests done between countries differs greatly, and that the increase in the number of cases in a country can be linked to more testing and not necessarily an increased spread of Coronavirus.

A map and table made in google data studio showing the number of COVID-19 deaths by country and COVID-19 cases by Region of the World

Another component of this dashboard showing COVID-19 cases by region of the world is a graph showing the number of deaths, cases and deaths / cases over time using a logarithmic scale.

Using a CASE statement to separate countries into custom geographic regions

I used a custom CASE statement to make new regions in this Google Data Studio report.

CASE 
WHEN Country / Region IN ("Angola","Benin","Botswana","Burkina Faso","Burundi","Cameroon","Cabo Verde","Central African Republic","Chad","Comoros","Congo (Brazzaville)","Congo (Kinshasa)","Cote d'Ivoire","Djibouti","Equatorial Guinea","Eritrea","Ethiopia","Gabon","Gambia","Ghana","Guinea","Guinea-Bissau","Kenya","Lesotho","Liberia","Madagascar","Malawi","Mali","Mauritania","Mauritius","Mozambique","Namibia","Niger","Nigeria","Rwanda","Sao Tome and Principe","Senegal","Seychelles","Sierra Leone","Somalia","South Africa","South Sudan","Sudan","Eswatini","Tanzania","Togo","Uganda","Zambia","Zimbabwe") THEN "Sub-Saharan Africa"
WHEN Country / Region IN ("Algeria","Egypt","Libya","Morocco","Tunisia","Western Sahara") THEN "North Africa"
WHEN Country / Region IN ("Mainland China","China") THEN "China"
WHEN Country / Region IN ("Japan","Mongolia","Korea, North","Korea, South","Taiwan*") THEN "East Asia"
WHEN Country / Region IN ("Brunei","Cambodia","Timor-Leste","Indonesia","Laos","Malaysia","Burma","Philippines","Singapore","Thailand","Vietnam") THEN "South East Asia"
WHEN Country / Region IN ("Afghanistan","Bangladesh","Bhutan","Maldives","Nepal","Pakistan","Sri Lanka") THEN "South Asia"
WHEN Country / Region IN ("India") THEN "India"
WHEN Country / Region IN ("Kazakhstan","Kyrgyzstan","Tajikistan","Turkmenistan","Uzbekistan") THEN "Central Asia"
WHEN Country / Region IN ("West Bank and Gaza","Armenia","Azerbaijan","Bahrain","Cyprus","Georgia","Iran","Iraq","Israel","Jordan","Kuwait","Lebanon","Oman","Qatar","Saudi Arabia","Syria","Turkey","United Arab Emirates","Yemen") THEN "Western Asia"
WHEN Country / Region IN ("Antigua and Barbuda","Anguilla","Aruba","Bahamas","Barbados","Belize","Bermuda","Bonaire","British Virgin Islands","Cayman Islands","Clipperton Island","Costa Rica","Cuba","Curacao","Dominica","Dominican Republic","El Salvador","Greenland","Grenada","Guadeloupe","Guatemala","Haiti","Honduras","Jamaica","Martinique","Montserrat","Navassa Island","Nicaragua","Panama","Puerto Rico","Saba","Saint Barthelemy","Saint Kitts and Nevis","Saint Lucia","Saint Martin","Saint Pierre and Miquelon","Saint Vincent and the Grenadines",	"Sint Eustatius","Sint Maarten","Trinidad and Tobago","Turks and Caicos","US Virgin Islands") THEN "Central America and Caribbean"
WHEN Country / Region IN ("Diamond Princess", "MS Zaandam","Holy See","Andorra","Austria","Belgium","Czechia","Denmark","Finland","France","Germany","Iceland","Ireland","Italy","Liechtenstein","Luxembourg","Malta","Monaco","Netherlands","Norway","Portugal","San Marino","Spain","Sweden","Switzerland","United Kingdom","Vatican City") THEN "Western Europe"
WHEN Country / Region IN ("Albania","Belarus","Bosnia and Herzegovina","Bulgaria","Croatia","Estonia","Greece","Hungary","Kosovo","Latvia","Lithuania","North Macedonia","Moldova","Montenegro","Poland","Romania","Serbia","Slovakia","Slovenia","Ukraine") THEN "Eastern Europe"
WHEN Country / Region IN ("Russia") THEN "Russia"
WHEN Country / Region IN ("Canada","Mexico","US") THEN "North America"
WHEN Country / Region IN ("Australia","Federated States of Micronesia","Fiji","Kiribati","Marshall Islands","Nauru","New Zealand","Palau","Papua New Guinea","Samoa","Solomon Islands",	"Tonga","Tuvalu","Vanuatu") THEN "Oceania"
WHEN Country / Region IN ("Argentina","Bolivia","Brazil","Chile","Colombia","Ecuador","Falkland Islands","French Guiana","Guyana","Paraguay","Peru","South Georgia and the South Sandwich Islands","Suriname","Uruguay","Venezuela") THEN "South America"
ELSE "Other"
END

I hope you found this useful and interesting.

Other COVID-19 dashboard

I’ve created three previous dashboard focusing on Coronavirus COVID-19 cases.

The first focuses on worldwide cases: A COVID-19 dashboard in Google Data Studio

A map showing worldwide cases of coronavirus covid-19 in various countries

The second looks at the differences in the number of cases between Europe and the United States: Comparing COVID-19 cases in the United States and Europe

Two maps created in google data studio showing the number of covid-19 cases in europe and the united states

The third focuses on COVID-19 cases in Africa.

Image

My Other Blog Posts

You might enjoy these other blog posts.