Daily COVID-19 data update XV, no fooling

How I wish this were an April Fool’s Day post. Instead, it’s day damn 15 of graphs, day 21 of the pandemic, and day 92 since the first case reports. It’s never good when I have to rescale the graph, and I did today with the global case count. The scale used to go to up to 900,000 (thicker line), now it goes up to 1,500,000.

Current global count: 850,000 cases and 41,000 deaths. When will the world see its one millionth case of COVID-19? My projections say this Saturday.

Cases in individual countries

New graphs and new countries today. I’ve removed China and Iran and added in their place Switzerland and Germany. They have inherited the other countries’ colors (Switzerland is red and Germany is purple) – but I made the lines dashed to remind you they are not China and Iran. Why those countries? See below.

As always, this is cases of COVID-19 per million people. Thanks to my anonymous friend who suggested I add data labels (you know who you are!). I’m not sure how well it works, let me know how I can improve the look of the graph.

Note how Switzerland’s cases per capita were below Italy and above Spain for most of March, but the order has now reversed. The rate of case growth has slowed greatly in Italy, slowed somewhat in Spain, and slowed almost not at all in Spain.

For the second day in a row, the rate of case growth has slowed in Belgium. The only countries where the the rate does not appear to have slowed are Spain, the United States, and the United Kingdom.

Deaths in individual countries

And here is a graph of deaths per million people. Same countries, same colors, same data labels, same deal.

Note that, even though Germany and Switzerland have as many cases as the other countries in the case graphs, they have fewer deaths. The case fatality rates in Germany and Switzerland are both quite low.

As always, I’m not an expert, I’m just a guy on the Internet who likes to make graphs of things. I hope I’ve shown you some ways you can look into COVID-19 data for yourself. You can find the data from the European Centers for Disease Control’s Coronavirus Source Data site (download the CSV file from the “Full dataset” link), and you are welcome to use my Excel template.

Update tomorrow, and every day until this pandemic is over.

Leave a Reply