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