Here are charts for Washington State counties. These charts rely on the New York Times’ published data on COVID-19 in the United States. I am primarily use their county-level data set together with population estimates (Wikipedia reports on US Census data from 2019).
I have produced charts of new cases of COVID-19 as
- 7-day trailing averages
- scaled to cases per 100k.
Google sheets link
All of my charts and tables are shared in a public Google sheets document:
https://docs.google.com/spreadsheets/d/1kNc6XTZSKerv5-Uk2kgoMUXPQHPjHKsLq0fMSZMkyuw/edit?usp=sharing
Charts
Washington State trends downward; diverging from a national rise in November
King County is lower than the state average by about 10 cases/100k and also has a downward trend.
Chelan case counts are notably higher than even the US average — though there may be data inconsistencies
Chelan has long stretches with no data reported. (e.g., 11/2 to 11/8 has no data — explaining the drastic dip). Despite this, it is still evident that Chelan county surpasses the state and national average.
All counties ranked by trailing average case per 100k as of 11/24/2021
Here is a ranked list of all counties as of 11/24/2021. I have added the nation and Washington State as a whole to help contextualize the numbers.
All counties are improved compared to the peak in September.
Graphs for top five counties in the state
Chelan
Douglas
Skagit
Grays
Mason
Notes
I chose trailing averages and scaled to population (“per 100k”) to help readers identify how COVID-19 is trending in each chart and to allow readers to make fairly direct comparisons county-to-county.
These charts compare each county against the entire state. This allows us to say whether or not a county has generally been doing better or worse than the rest of the state. I am using the trailing averages and trend line comparison to mitigate the way that testing patterns have changed since the early months.
I have refrained from speculation about the reasons for each county’s performance in this post and concentrated on simple language: above vs below average and a month to month comparison.
Links
Google sheet of WA counties
WACovid-Charts
Google sheet with all King County cities
https://docs.google.com/spreadsheets/d/16HXKTs5ZPGFnli3FRcTALsA40CovxCQoS-JF2GrETaY/edit?usp=sharing
Subreddit with daily reports from various contributors
https://www.reddit.com/r/CoronavirusWA/
