Philadelphia Council District Health Dashboard (Dataset)

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