| |

New Year’s Day Surge!

I was going to do a post purely on hoping for a better year and what not. Not sure what I would have written about, but it would have steered away from the coronavirus. However, with the surge and the terrible weather at the end of the year, I feel like I need to briefly note these events.

A vertical wall of surge

The last few nights I’ve been disbelieving what I was seeing and going back to the original source of data to make sure my Power Query was pulling in the data correctly. The numbers are just EYE-POPPING.

When I first pull data, I start off with the world as a whole and delve into the continents and individual countries. After I get a brief overview of the world, I then head over to the US, the regions and then the states. Finally, I delve specifically into my state and hometown to see what is going on where I live.

In the early days, the daily change in the cumulative number would hover around 300,000. Later on, the daily count would drift up to around 600K and sometimes even up to 900K, but never did I see the counts broach 1 million until a couple of days ago – maybe on December 29th when the count broached 1.3 million. That was a Wednesday. On Thursday, it was 1.5 million. Yesterday it hit 2 million. I thought the count I was receiving might have been catch up due to the holidays, although I would normally expect that to occur on Mondays, not Wednesdays.

But no, in all of this time, up until Wednesday December 29, the daily count never went above 1 million.

Here is a graph of the continents’ surge and you will see the vertical aspect of the surge, especially with US and Europe. The orange line is the US, the pink is Europe – driven mainly by UK, France, Italy and Spain, and the purple is South America led by Argentina.

Note: all graphs for countries around the world comes from Wikipedia. See “Sources of Data” box at end of post.

Image 1: Continents

Here’s a graphic of the top 10 contries in the world in terms of cumulative cases over the last 14 days since December 31, 2021:

Image 2: Top 10 Countries in daily cases in last 14 days

I highlighted Canada and Argentina because I don’t think either of these countries have ever been in the top 10 list since the pandemic’s inception. Canada’s surge is so vertical that I’m surprised I haven’t read anything about Canada.

I highlighted the US’s, UK’s and France’s numbers because I don’t think those countries ever reached those levels of cases. The US might have been around 1.2 to 1.5 million for a while but not 2 million or 3. As a matter of fact, when I saw those numbers, I had to go back to the source of data to double check that my Excel was pulling in the right numbers. I was simply stunned at how rapidly the US went to 3 million – in just a matter of days. The week before Christmas, the daily count was around 1.6 million and then the week after it shot to 2 million before reaching 3 million in the last two days.

For the UK, the week before Christmas, its count hovered around 900K. After Christmas, the count breached 1 million daily count, and hasn’t gone down yet.

France broke the 1 million barrier on December 30, 2021.

I highlighted the sum total of 9.4 million because before Christmas that total was in the 4 to 5 million range.

Individual countries

The data for these charts come from Wikipedia.

Image 3: Canada

You can see the straight up vertical surge happening in Canada. Shocking I haven’t heard anything about Canada.

Image 5: Africa

South Africa was where the Omicron first made its appearance around Thanksgiving and this country underwent its vertical surge during Thanksgiving/Christmas holidays timeframe. In this chart, you can see the dramatic decline, so the hope is that the rest of the world will see the same kind of drop.

Image 7: South America

Here, I’m circling Argentina’s vertical surge while the arrow points at Brazil’s bright blue line showing its own surge – although not as dramatic.

Image 4: Europe

Again, you can see Europe doing the straight up surge. I highlighted UK and France because I don’t think they have ever reached over 1 million cases in 14 cases. Denmark, Greece and Portugal are new to the top 10 list in Europe.

Image 6: Asia

Nothing to report for Asia. Turkey might be undergoing a bit of a surge but it is too early to tell.

USA

Before I go much further, I do want to point out that because of the vaccination, looking at cases alone may not be the right way of tracking the progress of the coronavirus. The vaccination appears to be decoupling the infection from hospitalization and deaths, so for the US, I want to pay more attention to the hospitalization because that would be an indicator of possible more deaths to come. I do want to see the cases only to test the decoupling assertion and I believe cases could be a forerunner to overwhelmed hospitals.

Data comes from the CDC.

Image 8: Cases as of 12/30/2021

Image 9: Hospitalization as of 12/31/2021

Image 10: Deaths as of 12/30/2021

You can see cases surging vertically as never before and in all regions of the US. Hospitalization has barely begun to rise, at least relatively to the cases, but I do expect the hospitalization to go up. If hospitalization starts to strain, I expect to see deaths to start rising. Right now, Deaths has stabilized at a somewhat high level

Northeast

Here, the Northeast is actually showing surging hospitalization and deaths, so it is understandable that the news has been highlighting the situation.

Image 11: Northeast Cases as of 12/30/2021

Image 12: Northeast Hospitalization as of 12/31/2021

Image 13: NE Deaths as of 12/30/2021

South

Cases are surging and some states are seeing rises in hospitalization, but deaths haven’t started going up dramatically. I expect the South to start overtaking the Northeast. Florida in particular is showing dramatic surges.

Image 14: South Cases as of 12/30/2021

Image 15: South Hospitalization as of 12/31/2021

Image 16: South Deaths as of 12/30/2021

Midwest

The Midwest is kind of mixed. I see some dramatic surges, but hospitalization seems to be quiescent. The hospitalization is kind of at an elevated level, but it is not surging.

Image 17: Midwest Cases as of 12/30/2021

Image 18: Midwest Hospitalization as of 12/31/2021

Image 19: Midwest Deaths as of 12/30/2021

West

Finally, the West also seems mixed. Nothing stands out to my eye quite like the way the Northeast or South does.

Image 20: West Cases as of 12/30/2021

Image 21: West Hospitalization as of 12/31/2021

Image 22: West Deaths as of 12/30/2021

That’s it for tonight. It is time for me to go gather today’s data, although being New Year’s Day, I don’t expect much data to have come in. We’re still in holiday mode.

Also, I’m going to look at the weather – tornadic weather is expected for the South tonight. I had wanted to talk about the weather that has been happening in December but I’m running out of time. Maybe tomorrow.

Sources of Data

WORLD : Cases and deaths from Wikipedia website https://en.wikipedia.org/wiki/COVID-19_pandemic_by_country_and_territory

US and STATES : Five main sources of data are available – Wikipedia, COVID Tracking Project, CDC, JHU, and HHS

COVID Tracking Project: The COVID Tracking Project was a collaborative effort of free labor overseen by The Atlantic. This project ended on 3/7/2021. The Atlantic’s COVID Tracking Project was provided under Common Creative license “CC BY-NC-4.0” and covered cases, deaths, hospitalization, and positivity, amongst other data.
API: https://covidtracking.com/api/v1/states/daily.csv
Table: daily

CDC: CDC has become a replacement for the COVID Tracking Project for me although the data will often come in a few days later. Hospitalization comes in a week later. I’m tracking cases, deaths, hospitalization, and positivity.
Centers for Disease Control and Prevention, COVID-19 Response. COVID-19 Case Surveillance Public Data Access, Summary, and Limitations
Table: rows

API:
Cases and deaths: https://data.cdc.gov/api/views/9mfq-cb36/rows.csv
Hospitalization: https://beta.healthdata.gov/api/views/g62h-syeh/rows.csv (Good data doesn’t start until about 7/15/2020)
Testing: https://beta.healthdata.gov/api/views/j8mb-icvb/rows.csv
Positivity: https://beta.healthdata.gov/api/views/j8mb-icvb/rows.csv

John Hopkins University (JHU): I rarely show these sets of data; I mostly use Wikipedia or CDC but sometimes I like to reference the JHU.

Please cite our Lancet Article for any use of this data in a publication (link)
Provided by Johns Hopkins University
Center for Systems Science and Engineering (JHU CSSE):

https://systems.jhu.edu/

Terms of Use:

1. This data set is licensed under the Creative Commons Attribution 4.0 International (CC BY 4.0) by the Johns Hopkins University on behalf of its Center for Systems Science in Engineering. Copyright Johns Hopkins University 2020.

2. Attribute the data as the “COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University” or “JHU CSSE COVID-19 Data” for short, and the

url: https://github.com/CSSEGISandData/COVID-19.

3. For publications that use the data, please cite the following publication: “Dong E, Du H, Gardner L. An interactive web-based dashboard to track COVID-19 in real time. Lancet Inf Dis. 20(5):533-534. doi: 10.1016/S1473-3099(20)30120-1”

Website https://github.com/CSSEGISandData/COVID-19

HHS: Hospitalization data for US – can be US level, state level or county level

url: https://healthdata.gov/api/views/anag-cw7u/rows.csv

Similar Posts