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

  • 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

Nationally, there has been a rise in positive cases. Washington state maintains a consistent below-average relationship to this trend. In fact, in the past 2 weeks, the gap between WA and USA has grown from a difference of about 7 to 10.

King County

King County’s performance is up for debate. Zooming into the last two weeks, although the County is below average against the state-wide and national average, the slope of the King County curve is in an uptrend. Visually, it appears to mimic the same slope as the national count.

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

Here is a ranked list of all counties as of 10/23/2020. I have added Washington State as a whole to help contextualize the numbers.

Walla Walla County shows a sharp increase over the state average

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

Whitman County

Finally, despite improvements in the past month, Whitman County continues to lead the table at a rate three times higher than the state average.

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.

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/

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store