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.

‍

‍

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.

‍

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.

‍

‍

‍

‍

‍

‍

‍

‍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.  

‍

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.

‍

‍

‍
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:

• ‍https://github.com/CSSEGISandData/COVID-19
• ‍‍https://covid19api.com/