Drexel Urban Health Collaborative
Published August 12, 2025 | Version v3
Dataset Open

Philadelphia Council District Health Dashboard (Dataset)

Creators

Description

Philadelphia Council District Health Dashboard - Dataset and Codebook

Description

This dataset supports the Philadelphia Council District Health Dashboard, an interactive web application that visualizes health disparities and social determinants of health across Philadelphia's 10 City Council Districts. The dashboard provides district-level insights to guide equitable policy and investment decisions by City Council members and the public.

Background

Philadelphia residents experience drastically different health outcomes across the city – differences shaped by federal, state, and local policies rather than individual choices alone. This project maps key health indicators across all 10 Philadelphia City Council Districts to show how politics and geography intersect to shape Philadelphian health.

Data Sources

  • US Census Bureau American Community Survey (ACS) 5-year estimates (2018-2022)
  • Open Data Philly (2015-2024)

Data aggregated from original geographic units to City Council District boundaries using population-weighted methods.

Dataset Contents

Files:

  • data_v1_1_1.csv - Main dataset containing health indicators by Philadelphia City Council District
  • codebook_v1_1_1.csv - Complete metadata and variable documentation

Methodology

  • Population-weighted aggregation for demographic/socioeconomic variables
  • Area-weighted aggregation for environmental variables
  • Count aggregation for incident data
  • City averages calculated as population-weighted across districts

Geographic Coverage

  • Unit: Philadelphia City Council Districts (n=10)
  • Period: 2018-2022 (ACS), 2015-2024 (Open Data Philly)

Applications

Supports policy analysis, community advocacy, academic research, and public health planning at the district level.

 

Contact 

Authors

Amber Bolli, Tamara Rushovich, Ran Li, Stephanie Hernandez, Alina Schnake-Mahl

Funding

Transform Academia for Equity grant from Robert Wood Johnson Foundation

Keywords

Philadelphia, City Council, Health Disparities, Social Determinants, Urban Health, Public Policy, Geospatial Analysis

Files

codebook_v1_1_1.csv

Files (32.3 kB)

Name Size Download all
md5:ef8e9eaf16ada94a8f9fda0ecd5d918c
22.8 kB Preview Download
md5:caba4e0ee1b0b3b0797f2647fbdc800d
9.5 kB Preview Download