Covid-19 Dataset Analysis - Death toll by countries, U.S cities, and daily growth rates in Canada

Analyzing a Coronavirus dataset on Google Sheets

We set up a PostgreSQL database to analyze the most updated statistics regarding Covid-19’s deaths, confirmed, recovered, and active cases around the world. You can access this data by installing the Castodia Database Connector for Google Sheets and connecting to our database.


We derived insights by pulling data from the Castodia Database Connector using a SQL query to answer five commonly asked questions:

  1. What are the top ten countries with the highest coronavirus death toll?
  2. How concentrated is the death toll within each country?
  3. What are the cumulative fatalities to date listed by major U.S. cities?
  4. What is the growth rate of deaths and/or confirmed cases in Canada?
  5. What is the comparison of recovered vs. active cases in Canada?


Note: View the source data/charts used to answer all questions by clicking this link to access the entire spreadsheet. The latest data in the images/charts in the spreadsheet and on this post are updated as of May 25, 2020. However, using Castodia you can auto-refresh the spreadsheet with fresh data that’s updated daily.

1) What are the top ten countries with the highest coronavirus death toll?

The United States still stands as the country with the highest death toll at 98,220 to date. Countries following at a distant second and third are the United Kingdom and Italy, with 36,914 and 32,877 deaths, respectively.

Top 10 countries by Covid-19 deaths
Top 10 Countries by Covid-19 death toll


2) How concentrated is the death toll within each country?

Expanding the dataset we analyzed in question 1, each country was populated into a geographic world map. The largest dot, the United States, indicates the highest death toll at 98,220. The following countries are indicated with the translucent, medium-sized dots, with the United Kingdom, Italy, France, Spain and Brazil. The remaining countries follow with a smaller pink dot to indicate fewer deaths, with Qatar, Lebanon, and Liberia having the lowest number of deaths, at 26.

Click here to view the death tolls within each country.

Map of Covid-19 cases by country
Covid cases by country



3) What are the cumulative fatalities to date listed by major U.S. cities?

A few of the major cities and metropolitan areas are shown above. Key highlights include New York, with a staggering 21,259 deaths compared to West Coast cities such as Los Angeles, with 2,116 deaths to date. If you'd like access to the full dataset containing data for all states and cities in the U.S, check out our spreadsheet.

Covid-19 deaths by city in California
Covid-19 deaths by city in California

Covid-19 deaths by city in Pennsylvania
Covid-19 deaths by city in Pennsylvania

Covid-19 deaths by city in Florida
Covid-19 deaths by city in Florida

Covid-19 deaths by city in New York
Covid-19 deaths by city in New York

Covid-19 deaths by city in Illinois
Covid-19 deaths by city in Illinois

Covid-19 deaths by city in Texas
Covid-19 deaths by city in New York

4) What is the growth rate of deaths and/or confirmed cases in Canada?

The growth rate of both confirmed cases and deaths continue rising slightly every week. However, a noticeable difference in the amount of confirmed cases and deaths has decreased during the span of the past two months.  

Daily growth rate in Canada of confirmed vs deaths
Covid-19 daily growth rate in confirmed cases vs deaths in Canada


5) What is the comparison of recovered vs. active cases in Canada?

Within the past month, we have seen a surge in recovered cases versus active cases in Canada. The red line, indicating active cases, has decreased, whereas the green line, indicating recovered cases, has increased.

Recovered vs active cases in canada covid-19
Covid-19 recovered vs active cases in Canada


To view more data, click this link to access the entire spreadsheet. Reach out to us if you’d like access to our database or have questions regarding this post.

Covid-19 data sources:

Jimmy E Chan profile picture blog
Nicole Fu
Marketing
nicole@castodia.com

Connectors

Start free trial

Try Castodia free for 14 days, no credit card required.