19 million cases (Daily COVID-19 data update CXLV)

Graphs day 145, pandemic day 152, day 222 since the first cases were diagnosed. Remember that Very Exciting New Idea that I was working on last week? I’ve spent almost the entire weekend working on it, and It’s almost done – you’ll definitely see it this week! For today, here’s a quick update on COVID-19 numbers around the world.

Total cases of COVID-19 diagnosed worldwide: 19,637,506

Total deaths: 726,781

Happy Independence Day to Singapore, we’ll include their numbers in today’s graphs. And some countries have changed categories today.

Usual graphs and labels for all five categories today. All five graphs are in the usual styles. The main graph is on the regular scale, from zero to 200 new cases diagnosed per day per million people. Where there are smaller inset graphs, they are on the “Qatar scale,” which runs from zero to 700 cases per million people. Each country gets a unique color in each graph (although the colors can repeat across graphs). Line labels show the name of the region, and also the mortality rate (cumulative deaths per million people) in the region – cumulative because the dead stay dead. The thickness of the lines and the size of the labels depend on the cumulative case fatality rate – the number of people who died divided by the number diagnosed.

Regions where COVID-19 was quickly contained

Regions where COVID-19 was quickly contained

No changes to this category. In fact, New Zealand has now gone 100 days without community transmission (virus transmission from one person to another within New Zealand). That is an incredible achievement.

Regions where COVID-19 is currently under control(-ish)

Regions where COVID-19 is currently under control

The last two weeks have seen a worrying increase in cases in France, but not enough to move France out of the under control category.

Regions moving in the right direction(-ish)

Regions where cases are decreasing

Welcome to getting better, Serbia!

And the rate of new cases reported in Sweden continues at a level lower than Russia and Saudi Arabia. Sweden took a risk by having less restrictive social distancing laws than nearby countries. Is the risk paying off? Not so far – even though cases are low right now, the death rate in Sweden is far higher than other countries. Sweden is playing the long game, betting that in the long run their approach will be more sustainable and deaths in other countries will inevitably catch up. We’ll see. The long game is the only game worth playing.

Regions experiencing a second wave of COVID-19 cases

Regions experiencing a second wave of COVID-19

This is the graph where Singapore goes, where cases have been increasing since early July. Also, it’s been a while since we’ve checked in with Iran, where cases started to increase in late April but have stayed at a fairly low level since.

Regions where the first wave of COVID-19 continues to get worse

Regions where things are getting worse

Reported cases continue to decrease in Florida.

Want to give it a try? Please do! Here is version 7.2 of my spreadsheet.

Pandemic updates tomorrow, and every day until the pandemic ends or I do.

Georgia on my mind (Daily COVID-19 data update CXLIII)

Graphs day 143, pandemic day 150, day 220 since the first cases were diagnosed.

I can’t believe it’s been CXLIII days and I haven’t made this joke yet, but let’s look at COVID-19 cases in Georgia. And Georgia.

But first, we hit another milestone number today:

Total cases of COVID-19 diagnosed worldwide: 19,097,149

Total deaths: 714,940

While COVID-19 continues to ravage Georgia, Georgia has mostly escaped the heavy toll of the disease so far. The graph below shows the number of cases reported per day in both places. The main graph is on the regular scale, from zero to 200 new cases diagnosed per day per million people. The smaller inset graph is on the “Qatar scale,” which runs from zero to 700 cases per million people. The label also gives the mortality rate (cumulative deaths per million people) in the region – cumulative because the dead stay dead. The thickness of the lines and the size of the labels depend on the cumulative case fatality rate – the number of people who died divided by the number diagnosed.

Trends in the COVID-19 epidemic in Georgia

Which Georgia is which? You can probably guess.

Want to try these graphs yourself? Go for it!!!

I have updated my template spreadsheet to version 7.2 to include The Georgias, and also a special bonus graph I’ll show tomorrow. If you have questions about how to use it, please ask – leave a comment, messenge me on social media, or send me an email at jordan.raddick@gmail.com.

Another update on the state of the pandemic tomorrow, and every day until the pandemic ends or I do.

I’m right and I hate it (Daily COVID-19 data update CXLI)

Graphs day 141, pandemic day 148, day 218 since the first cases were diagnosed.

I hope you enjoyed Rules for protest, in the style of Dr. Seuss – or at least found it an uncomfortably accurate depiction of current attitudes toward the racial justice protests all over the world.

Two months ago, I made a prediction that Earth would reach seven hundred thousand deaths on August 5, 2020. Here we are, it’s August 5th, and:

Total cases of COVID-19 diagnosed worldwide: 18,540,119

Total deaths: 700,647

I hate being right.

Beyond this successful prediction, a quick graph to update the high case rates the regions that I first showed on Monday:

New York City, Miami, Houston, Phoenix, Orlando, Hubei, Italy, Brazil

For the areas in the United States, what we’re looking at is metropolitan statistical area (MSAs), which usually consists of several counties around the core city. Wikipedia’s List of metropolitan statistical areas shows which counties are included in which MSAs. The graph is below. The graph is on the “Qatar scale,” which runs from zero to 700 cases per million people. Each region gets a unique color and is labeled close to the line with the same color. The label also gives the mortality rate (cumulative deaths per million people) in the region – cumulative because the dead stay dead. The thickness of the lines and the size of the labels depend on the cumulative case fatality rate – the number of people who died divided by the number diagnosed.

New cases diagnosed per day per million people in hot zones around the world

The precipitous drop in cases in Miami looks like good news, and it probably is. But keep in mind that testing centers in Florida were closed for a few days this week because of Hurricane Isaias. Cases had started to drop before that, so I think cases are really dropping – but not dropping as quickly as it appears from this graph.

Want to try these graphs yourself? Go for it!!!

I have updated my template spreadsheet to version 7.1. If you have questions about how to use it, please ask – leave a comment, messenge me on social media, or send me an email at jordan.raddick@gmail.com.

Another update on the state of the pandemic tomorrow, and every day until the pandemic ends or I do.

Rules for protest, in the style of Dr. Seuss

Colin Kapernick kneels during the national anthem
You must not protest with a knee

Regular COVD-19 data update coming tonight, but first…

You must not protest with a knee
You must not protest in D.C.

You must not protest on the street
You must not protest on your feet

You must not protest here or there
You must not protest anywhere!

You must not protest in D.C.

You must not protest with a march
You must not protest at the Arch

You must not protest on a horse
You must not protest on a course

You must not protest here or there
You must not protest anywhere!

You must not protest in a play
You must not protest in Bombay

You must not protest with a riot
You must not protest if you’re quiet

You must not protest here or there
You must not protest anywhere!

You must not protest, not at all
Yeah, there’s no second line here, I think we’ve gotten to the root of the problem

Some states looking better? (Daily COVID-19 data update CXL)

Graphs day 140, pandemic day 147, day 217 since the first cases were diagnosed. I had to look up how to write 140 in Roman numerals. Worst franchise ever.

Just a quick update of some national- and state-level data while I work on SOMETHING REALLY EXCITING!

Total cases of COVID-19 diagnosed worldwide: 18,282,208

Total deaths: 693,694

Earth is quickly headed for the new milestone of 700,000 deaths, probably later this week.

Today’s update is for some of the countries and states we have been following where cases continue at high rates. The main graph is on a slightly modified regular scale, running from zero to 250 cases per million people per day. The inset is on the infamous Qatar scale (0-700 cases per million people per day). Each region gets a unique color and is labeled close to the line with the same color. The label also gives the mortality rate (cumulative deaths per million people) in the region – cumulative because the dead stay dead. The thickness of the lines and the size of the labels depend on the cumulative case fatality rate – the number of people who died divided by the number diagnosed.

New cases diagnosed per day per million people in hot zones around the world

Florida is definitely doing better. California and Texas are a bit less clear, but hopefully they are moving in the right direction.

Stay tuned for SOMETHING REALLY EXCITING! Probably not tomorrow, but soon.

Want to try these graphs yourself? Go for it!!! I’ve updated my spreadsheet (still version 7) to restore the formulas. The upside is that you can now more easily make changes to make the graphs your own; the downside is that unless you are on a high-end computer, the calculations will be slooooooooooooooooow. To speed up calculations, replace formulas with values once you decide you have the right formulas. If you’re not sure how to do that, just ask – leave a comment, messenge me on social media, or send me an email at jordan.raddick@gmail.com.