Data Fireworks (COVID-19 data update CIX)

Graphs day 109, pandemic day 116, day 186 since the first cases were diagnosed. Today, Earth has passed 11 million total cases of COVID-19.

Total cases of COVID-19 diagnosed worldwide: 11,074,878

Total deaths: 525,121

Happy Fourth of July! In honor of U.S. Independence Day, we’ll take a closer look at the pattern of cases and deaths in the United States.

Total cases of COVID-19 diagnosed in the United States: 2,794,153

Total deaths: 129,434

Here’s the map of the total number of cases reported from the beginning of the epidemic in the U.S. This is total numbers rather than per capita, so naturally the larger states show more cases. The slight difference in the total is due to the fact that the number above includes the U.S. territories of Puerto Rico, Guam, the Virgin Islands, and the Northern Mariana Islands (American Samoa has had no cases).

Total cases by state (click for a larger version)

The total amounts shown on the map above show the total impact of the epidemic in the U.S. from the beginning. Another way to look at the cases reported yesterday, giving us an idea of the state of the epidemic right now. Notice which states are experiencing the most cases right now. How is this map different from the map of total cases above?

Cases reported yesterday (July 3, 2020) by state. Click for a larger version.

Three days ago, I showed, for the first time, graphs of cases over time in the U.S., in the style of the global graphs I’ve been making all along. I described several categories of states and showed two graphs: states where cases peaked early in the epidemic, and states where cases were low at the beginning, but where the epidemic has been getting worse quickly recently. I had shown several states in each category, which resulted in very complicated graphs.

I realized it would be clearer to show just one or two states in each category. And so – note that these numbers *are* per million people:

Cases in each state over time. Click for a larger version.

I showed a state that peaked in early April (New York), a state that peaked in May (Maryland), two states that have gotten much worse (Florida and Arizona), a state that started bad and is getting worse (Louisiana), and a state that has stayed fairly low throughout (Ohio).

One state I haven’t shown on this graph is the Granddaddy of Them All, California. The curve for California follows that of Ohio, but at a slightly higher level. I’ll keep an eye on California as we go, and show them on future graphs.

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 in GitHub.

You are welcome and encouraged to use my Excel templates. They’re now at version 5, and 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.

Leave a Reply