29 October 2020

Nine Months of COVID-19, Visualized

Johns Hopkins has maintained one of the go-to data sites for the global coronavirus pandemic, where their time series data stretches back to 22 January 2020.

Since the data shows weekly 'seasonality', where daily statistics tend to be underreported on weekends, the common trick most analysts have adopted to work around the regular noise that creates in the data is to track the seven day moving average of the daily count of newly confirmed COVID-19 cases and reported deaths. We now have nine months worth of those seven month moving averages, and with coronavirus cases surging in Europe and on the rise in the U.S., we thought it was a good time to focus just on those two regions.

Here's a chart showing the rolling seven day moving averages for the number of newly confirmed COVID-19 cases per 100,000 residents in both the United States and the 27 nations of the European Union. It shows that the EU has become the new global epicenter for the spread of SARS-CoV-2 coronavirus infections, with an average rate of spread among its residents that has skyrocketed to be more than double that in the U.S.

U.S. and EU-27: Newly Confirmed COVID-19 Cases per 100,000 Residents, 7-Day Moving Averages, 29 January 2020 - 28 October 2020

We have a second chart tracking the rolling seven day moving averages for the number of newly reported COVID-19 deaths per 100,000 residents in both the U.S. and the EU-27.

U.S. and EU-27: Newly Reported COVID-19 Deaths per 100,000 Residents, 7-Day Moving Averages, 29 January 2020 - 28 October 2020

This second chart shows a significant difference in the experience of the EU-27 and the U.S. The rate of deaths in the European Union is rising rapidly, following the basic pattern that the spread of newly confirmed cases has in the region, where it is nearing double the rate occurring in the U.S. as of 28 October 2020. What stands out here however is that the relative rate of COVID-19 deaths in the U.S. has fallen within a relatively narrow range over the last two months, even though the number of cases in the U.S. has been rising over nearly that entire period of time.

This difference between the two regions helps explain why much of Europe is retreating into lockdown mode, despite knowing the economic damage that will be caused by doing so, while the U.S. appears better positioned to weather its latest regional wave of cases.

Speaking of which, we'll close by linking to the changing map for COVID-19 deaths per 100,000 in the U.S. created by sdbernard, which is as well done as any COVID-19 data visualization we've seen:

[OC] Animation showing the number of Covid-19 deaths per 100k, by county in the US since the start of the pandemic from r/dataisbeautiful

Most of the U.S.' excess number of COVID-19 deaths can be attributed to just four states that sustained a particularly disastrous policy in the early months of the pandemic.