Community Connector: The AHRQ Social Determinants of Health Data Viz Challenge Winner

Community Connector: The AHRQ Social Determinants of Health Data Viz Challenge Winner

Published: Aug 20, 2020
Publisher: Health Services Research, vol. 55, issue S1

Kelsey Skvoretz

Margaret Luo

Research Objective

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.

Study Design

Our Community Connector tool ( 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.

Population Studied

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.

Principal Findings

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