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.

Graphs day 53, pandemic day 59, day 130 since the first cases were diagnosed.

Cases diagnosed worldwide: 3,898,658

Deaths worldwide: 274,290

It looks like it’ll be Monday, or maybe even Tuesday, when we hit four million cases worldwide. Hooray? The next sad milestone will be 300,000 deaths, which we will inevitably hit by the end of this month. But someday, the disease will burn itself out and this will end. How soon that happens is up to us.

Today’s map of case rates by country in Europe and South America (cases per million people):

and deaths per million people in the same countries:

Day 53 is an odd number, so here is the still-developing history of case rates of COVID-19 in nine different countries since mid-February:

and the same for deaths per million people:

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.