Regenstrief COVID-19 Dashboard

Regenstrief Institute developed the interactive COVID-19 Dashboard on March 23, 2020 to support Indiana’s public health response to the COVID-19 pandemic. The dashboard grew to inform state leaders, media and the public about the status of the outbreak across the state and was used by nearly 125,000 people in its first year.

The Tool
The dashboard was a Tableau-based visualization application that collated information on individuals tested for and infected with COVID-19 in parallel with data on individuals with COVID-like illnesses, including influenza and pneumonia. It displayed data from a number of sources, including hospitals and clinics connected to the Indiana Network for Patient Care, managed by the Indiana Health Information Exchange.

The dashboard harmonized that collective data to inform situational awareness with respect to COVID-related testing, cases, hospitalizations, emergency department visits, intensive care utilization, mortality, recovery, comorbidity, demographics and geography.

History
The dashboard debuted with a series of bar charts reporting individuals tested for COVID-19 or influenza. Demographics for each person were displayed using stacked bar charts, and line graphs depicted cumulative hospitalizations since the start of the outbreak. Users could filter results by selecting a geographic area of interest (e.g., county, zip code) or use a radio button to filter results to a specific diagnosis or laboratory test of interest. Users could also narrow results to a time period of interest, allowing examination of data before or after certain events, such as the governor’s stay-at-home order or the Fourth of July. These filters performed a recalculation of the descriptive statistics.

At the height of pandemic, analysts from Regenstrief’s Data Services team queried data once per day and transformed them into an analytical dataset for the dashboard. The 24/7 process of querying involved data extraction, linkage and deduplication functionality, as well as descriptive statistical calculations. As the number of cases and severity of infections decreased over four years, dashboard updates decreased to three times per week, and then once per week before the decision was made to cease operations.

The process of creating the dashboards was the subject of a peer-reviewed paper in the Journal of the American Medical Informatics Association and served as a model for other states and nations to address the pandemic and future public health crises. A later paper titled, “Dashboards Are Trendy, Visible Components of Data Management in Public Health: Sustaining Their Use After the Pandemic Requires a Broader View” was published in the American Journal of Public Health.

Awards
Indiana Governor Eric Holcomb declared September 21-27, 2020, as Regenstrief Institute Recognition Week in thanks for its dedication to state public health.

The institute also received the Indiana State Health Commissioner’s Award for Excellence in Public Health from Kristina Box, M.D., for its contributions to promoting and protecting the health of Hoosiers during the pandemic.

A cross-disciplinary team from Regenstrief received a Health Care Heroes award from the Indianapolis Business Journal for the institute’s work contributing to Indiana’s pandemic response.

Regenstrief was also among the finalists for TechPoint’s Mira Award for Pandemic Pivot of the Year.

The dashboard was updated for the last time on Wednesday, May 29, 2024. Should there be a re-activation of the public health emergency or a significant increase in disease burden, the dashboard may be reactivated. For official data on COVID cases and deaths, please see the State of Indiana COVID-19 Dashboard.