Community Connector: The AHRQ Social Determinants of Health Data Viz Challenge Winner
Clinical care accounts for a small part of the factors that affect population health. The rest is determined by social determinants of health (SDoH)—social, behavioral, and environmental factors that interact dynamically to keep people healthy. Many tools, such as the Opportunity Atlas, the City Health Dashboard, and the Robert Wood Johnson Foundation rankings, describe the social needs of populations but do not integrate a variety of federal, state, and local data sources and summarize only one community at a time, limiting the potential for peer-to-peer, comprehensive learning. Thus, we sought to build a common definition of local SDoH and a way to identify communities with similar needs and demographics, particularly those that have had success in addressing social needs and improving health and well-being.
Our Community Connector tool (https://communityconnector.mathematica.org/) is designed to summarize a community’s social needs in one picture, or fingerprint; identify communities with similar fingerprints; and compare communities across key indicators of health care utilization and cost. This fingerprint is based on outcome-agnostic county-level scores for six domains of SDoH identified by the Kaiser Family Foundation. We used sparse principal component analysis to determine which variables would be used in the defined SDoH scores and assigned additional variables that were not selected by this approach based on prior knowledge and strong association with the health outcomes. Each of the domain scores is a weighted average of the selected, normalized variables. The tool also provides a comparison of a county’s fingerprint to other counties with similar demographic and nonmodifiable SDoH characteristics, where the similarity is determined using a Lasso regression model.
We collected open-source federal, state, and local data for the state of Colorado and targeted health outcomes related to obesity, diabetes, and kidney disease for the prototype. We used data sources such as the Colorado Department of Public Health and Environment and the Centers for Disease Control and Prevention’s Diabetes Atlas. With additional time and funding, the tool can expand and scale nationally and present analyses on a larger set of health outcomes and utilization data.
Through developing the tool, we learned there is vast heterogeneity across community needs, outcomes, and data availability. This tool can help users understand community differences and explore similarities. As we assessed the app’s usability, we incorporated feedback from a variety of stakeholders into the app. From this feedback, we learned how to display the graphics and instructions in the most comprehensible way. As a result, the Community Connector has had about 30 000 views since its launch in mid-December.
In late January 2020, the Agency for Healthcare Research and Quality (AHRQ) announced this tool as the grand prize winner of the AHRQ’s Visualization Resources of Community-Level Social Determinants of Health Challenge.
Implications for Policy or Practice
This tool provides further resources and opportunities for communities to use SDoH data when identifying intervention opportunities. In addition to expanding nationally and across health care outcomes, the Community Connector could potentially allow localities to customize their search for similar counties by uploading their own county-level data to the tool.
How do you apply evidence?
Take our quick four-question survey to help us curate evidence and insights that serve you.Take our survey