A real-time COVID-19 surveillance dashboard to support epidemic response in Connecticut: lessons from an academic-health department partnership

In response to the coronavirus disease-19 (COVID-19) pandemic, numerous institutions published COVID-19 dashboards for reporting epidemiological statistics at the county, state, or national level. However, statistics for smaller cities were often not reported, requiring these areas to develop their own data processing pipelines. For under-resourced departments of health, the development of these pipelines was challenging, leading them to rely on nonspecific and often delayed infection statistics during the pandemic. To avoid this issue, the Stamford, Connecticut Department of Health (SDH) contracted with the Columbia Mailman School of Public Health to develop an online dashboard that displays real-time case, death, test, vaccination, hospitalization, and forecast data for their city, allowing SDH to monitor trends for specific demographic and geographic groups. Insights from the dashboard allowed SDH to initiate timely and targeted testing/vaccination campaigns. The dashboard is widely used and highlights the benefit of public-academic partnerships in public health, especially during the COVID-19 pandemic.