Karan Sethi
4 min readMay 6, 2020

Source: Google Image

The COVID-19 outbreak has shaken the world with its reach to every country across the globe and is taking a great toll on human life. The global economy has come to a standstill and nations are struggling to curb the outbreak.

In this post, we will analyze the data publically provided by HUMANITARIAN DATA EXCHANGE.

This post is

We try to find an answer to a few simple but important questions like,

1. Which Top 5 nations across the globe are affected by COVID-19?
2. What is the rate of recovery among these nations?
3. What is the rate of mortality among these nations due to COVID-19?

Let’s begin to answer these questions….

Which Top 5 nations across the globe are affected by COVID-19?

From the data provided by WHO and compiled by HDX, we can infer that the top 5 affected nations by COVID-19 in a timespan of just 90 days were,
1. The USA
2. Spain
3. Italy
4. France
5. Germany
with about ~0.18 to 0.47 percent of the population being hit COVID19

Total count of confirmed COVID-19 cases

Total percent of the population affected

Graph showing the confirmed case over a period of 90 days

The graph shows a steep rise in no of confirmed cases in the USA compared to others.

What is the rate of recovery among these nations?

Graph of Recovery rate over 90 days span

It is observed that the rate of recovery was high in Germany as seen in other nations. We can also observe a peek of almost 100% in Spain during the last week of Feb 2020, which is because not many cases were detected in the initial phase of spread and at the same time the no of recovered cases was close to detected cases.
We can see that the percentage of total recovered by 24th April 2020 was,
1. USA →10%
2. Spain → 42%
3. Italy → 31%
4. France → 27%
5. Germany → 70%

Average Recovery Rate over 90 days.

Total percent of recovered in the last 5 days of observing timespan

What is the rate of mortality among these nations due to COVID-19?

Graph of Mortality Rate over 90 days span

The graph above shows the mortality rate due to COVID-19.

The total number deceased was highest in the USA followed by Italy, Spain, France, and Germany with the lowest count.

Count of deceased

The average mortality rate was observed to be in a range of 0.5% ~ 5.6%

Average mortality rate

This sums up all the answers we aimed to find in the post.

To explore and share more insights. Refer the links below

GitHub: Link
COVID-19 Data:
Link
World Population:
Link