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:
King County is seeing a rise in new cases that matches the state average.
Seattle shows a similar uptick in cases from about a week before, though it remains below the overall average of King County itself.
King County cities ranked as of 3/29/2020
- Only cities with population > 5k
- All of USA, WA and King County are included as reference points.
Charts for top 5 cities
Auburn, Enumclaw, Maple Valley, Hobart, Pacific all supercede the average for the entire USA by at least 10 cases per 100k.
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.