Development of a healthcare system COVID Hotspotting Score in California: an observational study with prospective validation

OBJECTIVE: To examine the value of health systems data as indicators of emerging COVID-19 activity. DESIGN: Observational study of health system indicators for the COVID Hotspotting Score (CHOTS) with prospective validation. SETTING AND PARTICIPANTS: An integrated healthcare delivery system in Northern California including 21 hospitals and 4.5 million members. MAIN OUTCOME MEASURES: The CHOTS incorporated 10 variables including four major (cough/cold calls, emails, new positive COVID-19 tests, COVID-19 hospital census) and six minor (COVID-19 calls, respiratory infection and COVID-19 routine and urgent visits, and respiratory viral testing) indicators assessed with change point detection and slope metrics. We quantified cross-correlations lagged by 7–42 days between CHOTS and standardised COVID-19 hospital census using observational data from 1 April to 31 May 2020 and two waves of prospective data through 21 March 2021. RESULTS: Through 30 September 2020, peak cross-correlation between CHOTS and COVID-19 hospital census occurred with a 28-day lag at 0.78; at 42 days, the correlation was 0.69. Lagged correlation between medical centre CHOTS and their COVID-19 census was highest at 42 days for one facility (0.63), at 35 days for nine facilities (0.52–0.73), at 28 days for eight facilities (0.28–0.74) and at 14 days for two facilities (0.73–0.78). The strongest correlation for individual indicators was 0.94 (COVID-19 census) and 0.90 (new positive COVID-19 tests) lagged 1–14 days and 0.83 for COVID-19 calls and urgent clinic visits lagged 14–28 days. Cross-correlation was similar (0.73) with a 35-day lag using prospective validation from 1 October 2020 to 21 March 2021. CONCLUSIONS: Passively collected health system indicators were strongly correlated with forthcoming COVID-19 hospital census up to 6 weeks before three successive COVID-19 waves. These tools could inform communities, health systems and public health officials to identify, prepare for and mitigate emerging COVID-19 activity.