Sky

Sep 17, 2020

3 min read

COVID in Washington state, charts per county (Sept 16, 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

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

King County

All counties ranked by trailing average case per 100k as of 9/16/2020

Here is a ranked list of all counties as of 9/16/2020. I have added Washington State as a whole to help contextualize the numbers. Due to its small population, Garfield’s second place ranking is not a concern. It records new cases in single digits.

Whitman County continues to lead Washington State in cases

Whitman remains at the top of the list at 55.60 which is almost 10 times worse than the state average (5.98). It has held this position for almost three full weeks.

Adams County

Adams’ holds a 3rd place position at 32.17. One might ask if this is a numeric anomaly with its smaller population (~20k). It has maintained an average of 6–10 new cases a day for the past two weeks. I’ve provided its chart below.

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/