Category: Uncategorized

Graphs day 58, pandemic day 64, day 135 since the first cases were diagnosed.

Total cases diagnosed worldwide: 4,308,809

Current worldwide deaths: 296,680

By this point, we have probably already hit the sad milestone of 300,000 deaths, and it should be reflected in tomorrow’s data. The graph of global cases continues to stubbornly increase at the same rate as it has the last two months.

Today’s maps – Qatar has literally gone off the scale in cases:

…but it still very low in deaths:

In fact, Qatar is so weird that they are throwing off the scales of the graphs in both directions. So I’m removing them from the graphs for the moment, but I’ll continue to keep a close eye on them.

It’s an even-numbered day, so we’ll compare countries from the same point in their epidemics. We can, for example, compare the current situation in the U.S. to the situation in Italy at a similar point in the spread of the disease.

I picked the United States and Italy as the comparison for a reason – notice how for the first 40 days or so of their time with COVID-19, they trended together almost exactly. Over the past 30 days or so, the U.S. has blown past Italy. Imagine tracing the curves out – it seems almost inevitable that the U.S. will pass Belgium and then Spain.

For the graph of deaths, look at the U.K. and Italy.

Italy was ahead of the U.K. in death rate for the first 55 days or so, but the U.K. has now pulled ahead.

As always, you can get the data yourself from the European Centers for Disease Control’s Coronavirus Source Data; choose “all four metrics.” You are welcome to use my Excel template (version 3.2). I’d love to see what you can build with it!

Update tomorrow-ish, and every day-ish after that until this pandemic is over.

Graphs day 57, pandemic day 63, day 134 since the first cases were diagnosed.

Total cases diagnosed worldwide: 4,223,047

Current worldwide deaths: 291,519

I had some more time today to mess with the data, so I’m able to show the results in some new and interesting ways. I’ll skip the maps today and go straight to the graphs.

I realized it’s been a while since I showed you the graphs of COVID-19 cases and deaths in absolute numbers, rather than as rates per million people. It’s always good to remind yourself of what the data really means – in this case, the lines mean increasing numbers of people sick or dead.

Total cases by country by day (apologies, no data labels here, but hopefully you can get the idea from a quick glance, knowing that the line way at the top is the United States):

Total deaths by country by day (same deal):

In a way, this is a better graph, because it’s plotting the thing that ultimately matters – the sick and the dead. In a way, though, it’s a worse graph, because it puts countries on unequal footing. The position on the graph is determined as much by the total population of the country as it is by the severity of the COVID-19 epidemic there. I think that cases and deaths per million gives a more fair representation of the COVID-19 situation in each country, which is why that is the primary way I have been presenting the data. The lesson here is that the best graph to show depends on the question you are trying to answer.

Before I show the usual graphs, I decided to revisit some old friends – countries that I used to track, but stopped tracking because the curve had conclusively flattened. Here is the graph of cases, with lines labeled for the countries with the most cases and the line thickness indicating the case fatality rate in that country. Are the curves still flat?

With the exception of Iran and maybe France, yes. Lesson:

WE CAN DEFEAT COVID-19. STAY THE COURSE, IT’S WORKING!

What about the countries where the curve has not yet completely flattened? As before, some are close to flat, some continue to increase linearly, and some are so early in their local epidemics that cases and deaths continue to increase exponentially. And Qatar is weird, I’m still not sure what’s going on there.

Cases per million people:

Deaths per million people:

I’ll keep following these countries as long as they continue to produce interesting data, and I’ll occasionally check back in with our old friends too.

As always, you can get the data yourself from the European Centers for Disease Control’s Coronavirus Source Data; choose “all four metrics.” You are welcome to use my Excel template (time for a version update to include the data from the old-new countries, it’s now version 3.2). I’d love to see what you can build with it!

Update tomorrow-ish, and every day-ish after that until this pandemic is over.

Graphs day 56, pandemic day 62, day 133 since the first cases were diagnosed.

Total cases diagnosed worldwide: 4,137,193

Current worldwide deaths: 285,760

Same maps and graphs this time. Things are changing slowly now.

Qatar continues to lead the world in diagnosed cases per million people. I still think those high numbers are due to testing rather than genuine case rates, but I haven’t had a chance to look at the data to prove or disprove that hypothesis. Belgium continues to lead the world in deaths per million people.

I’ve had some interesting discussions with people on whether these numbers can be believed. Of course all measurements come with uncertainty – but the data presented here is our best guess for the extent of the COVID-19 pandemic. If you choose not to believe the data, what do you think we should do instead? Give up? Let people die?

All we can do is to make the best decisions we can with the best data we have. This is the best data we have, and the decisions we are making are the best decisions we know how to make.

As always, you can get the data yourself from the European Centers for Disease Control’s Coronavirus Source Data; choose “all four metrics.” You are welcome to use my Excel template (now at version 3.1); I’d love to see what you can build with it!

Update tomorrow-ish, and every day-ish after that until this pandemic is over.

Graphs day 55, pandemic day 61, day 132 since the first cases were diagnosed. The total number of cases worldwide has passed four million, meaning it’s time for a new scale on the graph.

Current worldwide deaths: 282,244

It turns out the highest case rate in the world (excluding micro-countries like San Marino) is Qatar. So I expanded the Europe map to include Qatar:

The fascinating thing is that, while Qatar has a very high case rate, they have a very low death rate. Here’s the same map but for death rate:

The case fatality rate in Qatar is only 0.1 percent. I suspect the reason for this is that Qatar is testing the everloving flip out of the entire country, so they are catching more mild cases than other countries are. Deeper in the data I have measures of testing by country, so we can test this hypothesis.

I have also added Qatar to the tracking of cases and deaths by day. Qatar is purple in these graphs. Comparing the graph of cases and deaths makes the situation in Qatar particularly striking.

Cases per million people since mid-February:

and deaths per million people, same scale and colors:

As always, you can get the data yourself from the European Centers for Disease Control’s Coronavirus Source Data; choose “all four metrics.” You are welcome to use my Excel template (now at version 3.1); I’d love to see what you can build with it!

Update tomorrow-ish, and every day-ish after that until this pandemic is over.

Graphs day 54, pandemic day 60, day 131 since the first cases were diagnosed. As of this morning’s data release, we haven’t quite hit four million diagnosed cases worldwide – but it’s the evening so we almost certainly have by now. That will require another graph rescaling, to be shown in tomorrow’s total worldwide cases graph.

More than 275,000 people have died of COVID-19. Numbers are hard to come by, but this appears that more people have been killed by COVID-19 than by Mexican drug cartels. Ever. Twice as many. (Source: Wikipedia, who got their numbers at least in part from this Washington Post article).

Skipping the maps for today and going straight to the graphs – it’s an even-numbered day, so here is the comparison of countries starting at equivalent points in their local epidemics.

Cases per million people:

It’s even more clear than yesterday the difference between countries where the rate of new cases has fallen to close to zero (e.g. Italy), countries where the number of cases continues at a steady rate (e.g. the United States), and countries where the rate of new cases continues to increase (e.g. Russia).

And deaths per million shows approximately the same trend:

As always, you can get the data yourself from the European Centers for Disease Control’s Coronavirus Source Data; choose “all four metrics.” You are welcome to use my Excel template (now at version 3.1); I’d love to see what you can build with it!

Update tomorrow-ish, and every day-ish after that until this pandemic is over.