Topic: People (331)

Monitoring the COVID-19 Surge Peak in Whatcom County - Update 2

With his modelling skills David Swanson continues to keep us apprised of the COVID-19 spread in Whatcom County and its likely trajectory.

With his modelling skills David Swanson continues to keep us apprised of the COVID-19 spread in Whatcom County and its likely trajectory.

By

On March 30th, Northwest Citizen published a baseline COVID-19 surge peak forecast I did for Whatcom County. The forecast used March 28th as its launch point. It showed 6,151 total confirmed cases by April 25th, the date that this initial surge will likely peak. While the baseline reflected the social distancing and other containment measures that were proclaimed by Governor Inslee on March 25th, they had not long been in place. As such, the baseline largely represents what could be expected by April 25th in the absence of them. On April 3rd I provided the first update, which suggested that the social distancing and other containment measures were having the desired effect: The update showed 2,696 total confirmed cases by April 25th, a 56 percent reduction in the number of total confirmed cases.

This 2nd update shows 1,118 total confirmed cases by April 25th, of which 102 would be added on that day. Clearly, the social distancing and containment measures are continuing to drive down the total number of confirmed cases. Here is a comparison between this second update, on the one hand, and the baseline and 1st update, on the other.

Click graph to enlarge.
Click graph to enlarge.

Keep in mind that I deliberately used a simple geometric model to do the forecasts for Whatcom County because sophisticated ones require so much data that they typically are not usable for a small area finding itself in the initial surge of a pandemic. I believe it is vital that people living in counties and small towns have some idea of what they might be facing rather than remaining in the dark. Now that more data has become available, I am moving toward a more sophisticated approach.

As I concluded in the article describing the 1st update, this second update brings welcome news. Keep in mind, however, that these new results suggest that by the time we expect this initial surge to peak, there is still a noticeable impact on the population of Whatcom County and its healthcare system. It suggests we can expect that between 715 (0.3 percent) and 1,207 (0.5 percent) of people in Whatcom County will have been infected by April 25th. With 21 deaths recorded as of April 9th and 243 confirmed cases, we can expect between 41 and 83 more deaths by April 25th.

In addition to providing this update, I am now able to give you some idea of the reliability and validity of the simple geometric models I have been using. With 17 days of data (March 24th to April 9th), I turned to a more complex model, exponential in nature, to generate a forecast. In addition to using all of the information available – the 17 days of data – the adequacy of the model can be assessed and, importantly, it generates a probabilistic forecast. This simultaneously allows us to both assess the uncertainty in the model and to assess the accuracy of the simple geometric model because the exponential model provides “prediction intervals. To get to the point, I will described the exponential model, its “goodness of fit” to the 17 days of data, and describe its prediction intervals. Those interested in more details should feel free to contact me.

The exponential model takes the following form:

Predicted number of cases = e((0.0787)*((Day)-(-54.2867)))

Where e = 2.71828…, the base of the “natural logarithms.”

Day = number of days from the start of the data (March 24th)
for which a forecast is desired. For example, April 10th is Day 18
and April 25th is Day 33.

The coefficient of determination (r2) for this model is 0.94. This suggests that the model reduces the variance by 94 percent beyond what would be found if we were using the mean number of confirmed cases for the 17 days of reported observations as the expected daily number in the future. This interpretation is often expressed as “the model explains 94 percent of the variation in the variable of interest.” Either interpretation suggests that the model provides a good fit to the data we have on hand.

The exponential model yields a forecast of 961 total confirmed COVID-19 cases as of April 25th and the prediction interval states that with a 95 percent degree of certainty the lower limit of the forecast is 715 cases and the upper limit is 1,207 cases. Importantly, the prediction limits contain the April 25th forecast provided by the simple exponential model, 1,118 confirmed COVID-19 cases. This suggests that the simple geometric model is doing a reasonable job.

A second issue to keep in mind is that the simple geometric model not only requires fewer data points to construct, but it provides a crucial piece of information that is not directly available from the exponential model, namely, the average daily rate of change ( r ). We can get it indirectly, however, by using its forecasted number for April 25th in conjunction with the number found on March 24th, the start of the base period for the baseline, update 1, and update 2. In this case, the daily rate of change is 1.0982, where r = (961/48)(1/32). You can see how close this is to 1.1001, the daily rate of change used in this 2nd update of the simple geometric model. Not surprisingly, the difference between the two models as of April 25th is small as well, only 157 confirmed COVID-19 cases, a relative difference of 16.3 percent, where 16.3 = [(1,118 –961)/961]*100.

About David A. Swanson

Posting Citizen Journalist • Member since Mar 31, 2020

Comments by Readers

David MacLeod

Apr 10, 2020

Excellent work, thank you!

 

Read More...

Sam Crawford

Apr 11, 2020

This is hard for me to comprehend. But here’s what I understand where we are tonight (4/11):

Whatcom County confirmed cases: Approx. 250

Whatcom County population: 225,000

Assume half of all who have Covid 19 are either asymptomatic or are otherwise not reported (inferring 500 Whatcom cases at this time).

(Conclusion: About 1/10 of one percent of Whatcom population currently infected.)

So your model indicates we will have an addtional 868 (reported) cases in the next 2 weeks? That’d raise the percentage to about half of one percent of our population. Pretty long odds of near-term infection for most folks, if that’s the case.

Read More...

David A. Swanson

Apr 13, 2020

See the forthcoming article by Ron Cossman and me on the number of positive, uncofirmed cases in the county and the potential they have for infecting others.

Read More...

Janet Lutz-Smith

Apr 14, 2020

I t seems to me that the biggest “boggle” everywhere is the problem of getting enough Testing Kits! 

When I looked for Companies making these tests there were at least 10 making these Testing Kits. 

BUT, even if more are being made they cost MONEY!  Some as high as $250 dollars for just one! 

So, how to overcome this “boggle” , and that is essential to saving lives and identifying who has 

the Virus, we are more or less STUCK with staying home for probably up to 18 months!  

Janet Lutz-Smith-Lummi island

Read More...

Wynne Lee

Apr 14, 2020

I’d love to see County Council release some of our precious tax dollars to help with the cost of testing. But as of the last Council meeting, 4 council members (Browne, Elenbaas, Kershner & Boyd) seem unwilling willing to consider that option.

Read More...
To comment, Log In or Register

Monitoring the COVID-19 Surge Peak in Whatcom County - Update 2

By David A. SwansonOn Apr 10, 2020

With his modelling skills David Swanson continues to keep us apprised of the COVID-19 spread in Whatcom County and its likely trajectory.

5 comments, most recent 3 years ago

COVID-19 Hospitalizations in Whatcom County

By David A. SwansonOn Apr 05, 2020

What to expect with COVID hospitalizations in Whatcom County and a preview of the hospitalization situation in other counties in Washington.

13 comments, most recent 3 years ago

Monitoring the COVID-19 Surge Peak in Whatcom County - Update I

By David A. SwansonOn Apr 03, 2020

Updated: Immediate action needed to avoid overwhelming peak of COVID-19 cases by April 25th in Whatcom County

12 comments, most recent 3 years ago

Alex Ramel appointed as 40th District state representative

By John ServaisOn Jan 06, 2020

Alex Ramel was chosen today by votes of three county councils to a vacated seat on the state Legislature.

Dinner, Anyone?

By Guest WriterOn Nov 06, 2019

MADA (Make America Dinner Again) Invites You to Dinner… Across the Aisle

Chanan Suarez’s Local Base Is Grassroots—We’re Just Too Poor To Buy Elections

By Guest WriterOn Oct 24, 2019

Sage Jones responds to Dick Conoboy’s article on Chanan Suarez who is a candidate for Bellingham City Council. Suarez is running for the 5th Ward seat against Lisa Anderson.

1 comment, most recent 4 years ago

Seth Fleetwood for Mayor

By Tip JohnsonOn Oct 15, 2019

Electoral Perspective from a long-time neighborhood advocate

8 comments, most recent 4 years ago

Chanan Suarez – Grass Roots Candidate?

By Dick ConoboyOn Oct 14, 2019

Donations tell a far different story. Grass roots/local support is weak.

DEROS + 50 Years

By Dick ConoboyOn Oct 12, 2019

Today marks 50 years since I returned home to the U.S., from Vietnam.

4 comments, most recent 4 years ago

Ted Carlson Resigns as Bellingham Public Works Director

By John ServaisOn Jul 31, 2019

An unexpected resignation by one of the top administrators in Bellingham city government

Seattle Times to Doug Ericksen: Step Down

By Elisabeth BrittOn May 19, 2019

Unprincipled Whatcom County State Senator Doug Ericksen is urged to resign. Britt and Riordan first broke the news of his Cambodia hijinks on NW Citizen.

8 comments, most recent 4 years ago

Saving The Orca And Salmon - Does Inslee Have The Political Will?

By Juliette DanielsOn Mar 20, 2019

We need immediate action to save the canaries in our coal mine, the Southern Resident Orca and Salmon. Take down obsolete salmon-blocking dams before it’s too late.

7 comments, most recent 4 years ago

Rud Browne and His Wanderlust

By John ServaisOn Feb 07, 2019

Rud Browne’s antics during the selection of Liz Lovelett for state Senator was only the latest weird act during his first year of his second term on the Whatcom County Council.

3 comments, most recent 4 years ago

The NFL Sowed Its Own Problem With The National Anthem

By Dick ConoboyOn May 30, 2018

Myopic leadership in the NFL is the problem.

The Human Adventure Is Just Beginning If….

By Jon HumphreyOn May 10, 2018

The goal of this article is to highlight a few amazing scientific discoveries in the hopes that it will motivate us to create an economy based on science instead of war.

3 comments, most recent 5 years ago

Jim Peterson … from Homeless to Advocate for the Homeless

By Lisa E. PappOn Apr 14, 2018

Jim Peterson knows what it’s like to be homeless. He’s grateful to be on the other side now. But he won’t rest until every homeless person in our community is housed.

4 comments, most recent 5 years ago

Justin Trudeau’s “Bengal Bungle”

By John LesowOn Mar 04, 2018

Perception Clashes with Reality on the Prime Minister’s Latest Gambol to India

6 comments, most recent 4 years ago

Justin Trudeau’s Slippery Slide

By John LesowOn Feb 03, 2018

The road gets rocky for the selfie-obsessed prime minister

10 comments, most recent 5 years ago

Dick Conoboy awarded Paul deArmond Citizen Journalism Award

By John ServaisOn Jan 10, 2018

Dick Conoboy has written for over 10 years about Bellingham city hall not enforcing its own laws and the slow destruction of single family neighborhoods. The award is well earned.

3 comments, most recent 5 years ago

Doug Ericksen’s Use of Surplus Campaign Funds

By Michael RiordanOn Jul 05, 2017

Based on available evidence, it looks like Ericksen was using his surplus campaign account to help cover travel expenses incurred in connection with his involvement in the Trump regime.

2 comments, most recent 6 years ago