COVID in King County, charts per city (Nov 28, 2020)

Sky
3 min readNov 29, 2020

Here are charts for King County cities. These charts rely on the King County outbreak summary dashboard together with population estimates from the JC_Rook’s daily spreadsheet report on King County.

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/16HXKTs5ZPGFnli3FRcTALsA40CovxCQoS-JF2GrETaY/edit?usp=sharing

King County

King County’s chart has aligned very closely with the average rate of new cases for the entire state of Washington during November. There is a possible sharp dropdown in the King County cases in the past few days, but it will require some more time to verify this.

Seattle

Seattle, though rising in number of new cases, is not contributing to the increase in the average number of cases for King County overall. In fact, Seattle is consistently below average when mapped against King County.

King County cities ranked as of 11/28/2020

  • Only cities with population > 5k
  • All of USA, King County, Yakima County in June, and King County at the last recent peak are included as reference points.

November cities that are consistently above the King County average

Auburn
Burien
Des Moines
Federal Way
Kent
Lakeland North
Renton
SeaTac
Tukwila
White Center

Notes

I chose these the average and 100k transformations to help readers identify how COVID-19 is trending in each chart and to allow readers to make fairly direct comparisons city-to-city.

These charts compare each city against the entire county. This allows us to say whether or not a city has generally been doing better or worse than the rest of the county. I am using the trailing averages and trend line comparison to mitigate the way that testing patterns have changed since the early months.

I generally refrain 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 with all cities

Google sheet of WA counties

Subreddit with daily reports from various contributors

https://www.reddit.com/r/CoronavirusWA/

--

--