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.
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.
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.
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.
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.
West
Finally, the West also seems mixed. Nothing stands out to my eye quite like the way the Northeast or South does.
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
Wikipedia: Wikipedia has broken out their tables into four links, separating out the cases from deaths and separating out the years.
New Cases 2021: https://en.wikipedia.org/wiki/Template:2019–20_coronavirus_pandemic_data/United_States_medical_cases
New Cases 2020: https://en.wikipedia.org/wiki/Template:COVID-19_pandemic_data/United_States_daily_cases_in_2020
New Deaths 2021: https://en.wikipedia.org/wiki/Template:COVID-19_pandemic_data/United_States_daily_deaths
New Deaths 2020: https://en.wikipedia.org/wiki/Template:COVID-19_pandemic_data/United_States_daily_deaths_in_2020
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
You must be logged in to post a comment.