Return to Headlines

ASD Covid Metrics

The ASD continues to monitor health data as we plan for a gradual return to in-person instruction. Each week we calculate the COVID metrics for the ASD. The most current data is available here.

Here is the calculation logic:

After all jurisdictions report on Wednesday (usually by 5:00), we pull the data.

 The King County COVID new case rate per 100,000 residents in the last 14 days is from this website: https://kingcounty.gov/depts/health/covid-19/data/key-indicators.aspx  

 

The King County test positivity rate for the past 14 days is from this website: https://kingcounty.gov/depts/health/covid-19/data/daily-summary.aspx

The Pierce County COVID new case rate per 100,000 residents in the last 14 days is from this website: https://www.tpchd.org/healthy-people/diseases/covid-19-information-for-schools

We use the number from the big dial, which includes a 6 day reporting lag. This is the “official” way to report this statistic, since it can take several days for a case to be included in the data. Pierce County also reports the number without the lag as footnote.

The Pierce County test positivity rate for the past 14 days is from the fourth tab on the same website: https://www.tpchd.org/healthy-people/diseases/covid-19-information-for-schools

We calculate both the 14 day case rate and 14 day test positivity rate for the Auburn School District community, based on available data. PHSKC reports daily test results by census tract. We aggregate the data from the Algona, Auburn, Lake Holm, and Pacific census tracts, which are nearly identical to the King County portion of the Auburn School District. Unfortunately, Pierce County does not report the data in the same way, so that small portion of the district is not represented in the data.

The Auburn SD COVID new case rate per 100,000 residents in the last 14 days is from this website: https://kingcounty.gov/depts/health/covid-19/data/daily-summary.aspx It is from the “City Trends” tab, filtered by our four census tracts. We enter each day’s positive case count into a spreadsheet. We use the latest available census population figures to calculate the rate per 100,000 residents: Algona (3,223), Auburn (81,464), and Lake Holm (3,468), and Pacific (7,178), for a total Auburn SD population of 95,333.

The Auburn SD test positivity rate for the past 14 days is from the same website: https://kingcounty.gov/depts/health/covid-19/data/daily-summary.aspx It is from the “City Trends” tab, filtered by our four census tracts. Under the “Past 14 days” column, we capture the count of positives and the count of all test results. We divide the sum of positives from the four census tracts by the sum of all test results to calculate the 14 day positivity rate for the district.

(Note that the health department has a backlog of test reporting from before Thanksgiving and cautions that it may be underreporting the total number of tests, which would over-report the positivity rate.)