Graphs day 111, pandemic day 118, day 188 since the first cases were diagnosed. If you haven’t seen my other post today, learn the fascinating and beautiful story of the tree lobster.

Very quick update today, just with total case numbers and one updated graph.

Total cases of COVID-19 diagnosed worldwide: 11,449,707

Total deaths: 534,267

Today is independence day in the southern African nations of Comoros and Malawi. Fortunately, there are not many cases of COVID-19 in either country.

Usual graph style: each country is color-coded and labeled, labels include total deaths per million people from the beginning, label sizes and line thicknesses represent the case fatality rate.

Tomorrow is independence day in the Solomon Islands, so I’ll definitely report on cases there, but I might do graphs of U.S. states instead. What’s your preference: states or countries?

And meanwhile, I’m starting to look at cases by U.S. county, which will let us ask questions like “how bad is the epidemic in Upstate New York compared to New York City?,” and “what is the correlation between medium-scale population density and number of cases?” That’s going to be fun, updates soon.

Want to try out some of these graphs for yourself? You can get the data that I used to make the country graphs from Johns Hopkins University’s Center for Systems Science and Engineering (CSSE) COVID-19 data site. Click on csse_covid_19_data, then on csse_covid_19_time_series, then download all the CSV files. Or clone the whole repository from GitHub.

You are welcome and encouraged to use my Excel templates. I’ve tinkered enough that I’m plus-plusing the version to 5.1. I have two separate templates: a global data template and a U.S. state data template.

Update tomorrow, and every day after that until this pandemic comes to an end or I lose my mind or scientists find me hiding under a tea tree bush on Ball’s Pyramid.