Coronavirus (COVID-19) Deaths and Infection Rate

Image by CDC on Unsplash

The coronavirus pandemic has affected nearly all aspects of our lives, sickened more than 186 million people worldwide, and more than 4 million people have died so far. In addition, it led to global lockdowns, a new era of frugality, and a third of Americans working from home. So, as it continues to feel like we could get back to normal-ish life soon in America, I decided to examine some of the data.

Alex Freberg’s Data Analyst Portfolio Project series is the influence behind this activity. I made modifications to satisfy questions I wanted to answer and avoid simply copying his work. Alex’s YouTube channel is an inspirational and aspirational treasure trove of knowledge and ideas. If you’re interested in data analytics or another related field, I highly recommend that you check him out (if you haven’t already).

You can find the data behind this undertaking here.

Note: The data extract occurred on July 11, 2021.

The code behind this project is on GitHub.

You may view the dashboard at Tableau Public.


This project utilized Visual Studio Code, Azure Data Studio, Tableau, and Azure SQL Database. Furthermore, I also used the Python pandas library to download the data and prepare it. After that, I would usually use SQL to create the necessary tables and import the data from the CSVs into them, but I couldn’t get that to work with Azure SQL Database. (The code I attempted to use to that end can be seen here and here.) Since that was the case, I enlisted the SQL Server Import extension for Azure Data Studio. Then, with the data preparation complete, I moved my attention to data querying with SQL.

The SQL Server flat-file import wizard for Azure Data Studio


First, I wanted to calculate the total cases, total deaths, and the number of totally vaccinated people. While the information for infections and deaths is in one table, vaccination data is in another table. Therefore, I joined the tables together on the location and date columns. Next, I totaled the new_cases and new_deaths columns as Total Cases and Total Deaths, respectively. Then, I used the most considerable number from the people_fully_vaccinated column of the vaccinated table as my People Fully Vaccinated total. Finally, I excluded world, continental, and non-nation-specific information from the global numbers.

COVID-19 totals from July 11, 2021.

Next, I began querying data to formulate the death count of six countries: the United States, Brazil, India, Russia, France, and China. I chose the first five countries where the death toll was most significant when I initiated this project. I also chose China due to COVID-19 allegedly originating there. Once I decided which countries to include in my query, I only needed to add the new_deaths.

COVID-19 deaths by country as of July 11, 2021.

It seems like every COVID-19 dashboard has a map. So why should mine be any different? With that in mind, I mapped the infection rate by country. First, I took the highest number from the total_cases and divided that by the population. Then, I listed the results per country and fed the results of the new table into Tableau.

The darker the color, the higher the infection rate

Finally, I wanted to examine the infection rate over time, separated by country. To do so, I used the same query that I did for the map visualization but added date as a criterion.

The United States had the highest infection rate as of July 11, 2021.

While most of the world’s attention is currently laser-focused on getting vaccines to more people to stem the spread of the coronavirus, vaccines alone will not eliminate the escalation of COVID-19. As a result, scientists have significant pressure to find a cure to help those who contract the virus.

Doctors have some medications they can use to treat the effects of COVID-19, but developing a drug that targets the virus itself is a complex and costly procedure. More than a year into the pandemic, only one antiviral treatment — remdesivir — is currently recommended for use in the US. Experts say remdesivir is not nearly effective enough, though.

Scientists are hopeful that new drugs designed to stop the virus’ deadly reproduction could reduce hospitalizations and deaths from COVID-19. In addition, the treatments offer hope and a contingency plan for unvaccinated individuals, particularly in low-income countries lagging far behind in the race to vaccinate.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
John Baker

John Baker

I operate at the intersection of business and technology. • School Data Analyst for the Florida UFSD • Views are my own. • He/Him