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’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, 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
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.
Google sheet with all cities
City Charts Average new cases per 100k,New cases,Latest datapoint: 11/28/2020 Trailing 7 day average, scaled to…
Google sheet of WA counties
County Charts Average new cases per 100k,New cases,Latest Datapoint: 11/24/2020 Trailing 7 day average, scaled to…