COVID in Washington state, charts per county (October 24th, 2020)

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


Washington state

Without more context, we might say that either WA is doing better and better or the entire USA is doing poorly.

King County

So, even though King County is below the state-wide average, the current pattern implies that it will meet or exceed that average in the next week.

All counties ranked by trailing average case per 100k as of 10/23/2020

Walla Walla County shows a sharp increase over the state average

Walla walla is ranking 2nd worst in the state. This is accompanied by an aggressive uptrend in positive cases. This is not as dramatic as Whitman County’s outbreaks. Instead, by my quick visual review, its slope (against the state average) is reminiscent of Yakima County’s outbreak in March.

Yakima County in March 2020 shows a similar trend as Walla Walla County today.

Whitman 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.


Google sheet of WA counties

Google sheet with all King County cities

Subreddit with daily reports from various contributors