This represents all service and information requests since December 8th, 2014 submitted to Philly311 via the 311 mobile application, calls, walk-ins, emails, the 311 website or social media.
Please note that this is a very large dataset. Unless you are comfortable working with APIs, we recommend using the visualization to explore the data.
If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the CARTO guide in the section on making calls to the API.**
The Division of Housing and Community Development (DHCD) provides funding to developers to build and maintain affordable housing units throughout the city. This dataset includes all DHCD-funded housing projects completed since 1994 for which there is data.
Street location and types of pollutants sampled at each PDPH air monitoring station.
Number of bad AQI (air quality index) days, dating back to 1990.
The latest air quality sensor readings managed by the Air Management Systems (AMS) division of the Philadelphia Department of Public Health (PDPH)
The datasets below have been archived and will not receive further updates, but remain available for reference. The up-to-date and more comprehensive Litter Index is available here and will be updated annually going forward. For those conducting analysis using Litter Index data, please be advised that the survey design between the 2007- 2015 data is vastly different from the 2017 data, so it would not make sense to compare the two.
The Litter Index is used to compare the relative cleanliness of different areas of the city of Philadelphia.
The datasets below have been archived and will not receive further updates, but remain available for reference. The up-to-date and more comprehensive Neighborhood Food Retail data is available and will be updated annually going forward. For those conducting analysis using this data, please be advised that the previous methodology is vastly different from the more recent data, so it would not make sense to compare the two.
This dataset is derived from the Walkable Access to Healthy Foods in Philadelphia, 2012-2014 report analyses.
For matching and analyzing demographic data collected and compiled by the U.S. Census Bureau & American Community Survey(ACS) to the geography of Census Block Group boundaries within the City of Philadelphia. These boundaries can change every ten years when the decennial census is conducted.
The basic unit of aggregation published by the US Census Bureau. Population statistics published for redistricting are distributed at the block level. In an urban area, this corresponds to approximately one city block. This block map has been altered to improve accuracy and align with the City of Philadelphia’s street centerline.
For matching and analyzing demographic data collected and compiled by the U.S. Census Bureau & American Community Survey(ACS) to the geography of Census Block Group boundaries within the City of Philadelphia. These boundaries can change every ten years when the decennial census is conducted. Adjusted to City’s Standard Boundary Format.
Properties that have applied and been approved as suitable for renting.
Child Care Search is a searchable database, which yields results on child care services suited to parameters first of child age, then desired program focus, and finally by location (county). Users follow step-by-step input instructions to create a center/institute profile type, which the database tool then tries to match most closely. In addition to location and contact information, qualitative information about care centers (STAR rating system ran) are also available. All information results are freely viewable and printable, but not exportable.
Childcare Map helps Philadelphians make decisions about childcare.
Collection Process: TRF culled childcare data for the City of Philadelphia from various sources, and incorporated data from the Census related to demographics, income, poverty, and transportation. TRF also gathered overlays of various city boundaries from OpenDataPhilly and other local sources. More information on sources is available at http://www.policymap.com/files/ChildcareMapDataDirectory.pdf.
Data Purpose: TRF collected the data to provide as clear a picture as possible of the supply of and demand for childcare in the city, and to better understand where the gaps are so that stakeholders can work to address them. Intended Audience: Childcare providers, investors, policy makers, and parents. Why Collected: High-quality childcare supports positive child development and prepares children for success in school and beyond. As such, accessing high-quality care is important for the well-being of neighborhoods and families. By identifying areas where shortages of high-quality childcare exist, policymakers and investors can work towards increasing access for all.
This dataset includes checks and ACH (direct deposit) payments made by the City during the fiscal year, which runs from July 1st 2016 through June 31st 2017.
Please see full metadata to learn more detail about important notes to this data, such as:
The Community Health Assessment (CHA) is a systematic assessment of population health in Philadelphia, highlighting key public health challenges and assets and informing local public health programs, policies, and partnerships. The CHA includes indicators reflecting health behaviors, health conditions, health care factors, and social and environmental determinants of health. The Philadelphia Department of Public Health publishes an annual report of the analyses, linked to under the ‘Related’ tab. Additionally, they have released an online, interactive version of the CHA, known as the Community Health Explorer, to make the data more accessible to a broader audience.
As part of the Philadelphia Police Department’s (PPD) accountability processes, PPD publishes three datasets: The Complaints Against Police (CAP) dataset documents the civilian complaints alleging police misconduct; the CAP Findings dataset provides demographic details of the police officer involved, the allegations, and the status of the PPD’s Internal Affairs Division’s investigation of and findings (if available) about the allegation; and the Complainant Demographics dataset shows the race, sex, and age of each person who filed a complaint against a police officer by complaint number.
See metadata links below for dataset and field descriptions.
Includes data from the past five years. Updated monthly.
Street location and hours of stores and organizations that distribute PDPH Freedom Condom-branded condoms.
A dataset of free COVID-19 testing sites.
If looking for a test, please use the Testing Sites locator app. No testing site will ask you for money. You will be asked for identification and may also be asked for health insurance information. If you don’t have identification or health insurance, you can still get a test. In addition, some sites may:
Check a location’s specific details on the map. Then, call or visit the provider’s website before going for a test.
As of May 2022, these datasets moved from daily updates to weekly updates every Monday.
Shows distribution counts of first and second dose, as well as total dose information for all vaccinations performed by the health department. Also provides vaccinations by census tract, ZIP code, date, age, race, and sex. Vaccinations include residents and non-residents of Philadelphia. Updates daily.
The City of Philadelphia’s datasets are snapshots published on a daily basis. These data sets include de-identified, aggregate datasets showing COVID-19 cases, hospitalizations, and deaths by date, zip code, race, and age/sex and are made available accumulated into historical data sets of the daily snapshots collected. The cases and deaths by date, zip code, and age/sex are accumulated since 6/4/2020. Cases and death by race and hospitalizations are accumulated since 8/15/2020. Data is collected from the City’s data published at https://www.opendataphilly.org/showcase/philadelphia-covid-19-information through a daily scrape of the web site.
**As of May 2022, these datasets moved from daily updates to weekly updates. **
For greatest accuracy, please use the latest dataset for all analysis and reporting as opposed to any data you downloaded prior to September 29, 2020. All datasets now reflect counts from test collection dates instead of the previously displayed result dates. These changes will adjust, for example, the count of cases for each day. PDPH has also added 376 confirmed COVID-19 cases (positive tests) that were previously missing from the data.
Deidentified, aggregate datasets showing COVID deaths by date, zip, race, or age. You can find COVID cases datasets here. To protect the confidentiality of residents, PDPH suppresses the exact data for any categories that have less than 6 counts (i.e. of cases or fatalities).
As of May 2022, these datasets moved from daily updates to weekly updates every Monday.
A break down by census categories of the hospitalizations to date within the city limits.
As of May 2022, these datasets moved from daily updates to weekly updates every Monday.
For greatest accuracy, please use the latest dataset for all analysis and reporting as opposed to any data you downloaded prior to September 29, 2020. All datasets now reflect counts from test collection dates instead of the previously displayed result dates. To keep things clear, the field name in the COVID Outcome by Date files also changed from ‘Result_Date’ to ‘CollectionDate.’ These changes will adjust, for example, the count of cases for each day. PDPH has also added 376 confirmed COVID-19 cases (positive tests) that were previously missing from the data.
Deidentified, aggregate datasets showing COVID tests by date, zip, and outcome and cases by race, age or sex. To protect the confidentiality of residents, PDPH suppresses the exact data for any categories that have less than 6 counts (i.e. of tests or fatalities).
An RSS feed of all jobs classifieds offered on the Philadelphia Craigslist site. The structured data for each listing includes a Resource Description Framework (RDF) for that listing.
Flu shot clinic schedule and locations for the City of Philadelphia. Locations include Philadelphia Department of Public Health District Health Centers, federally qualified health centers and community flu clinics.
The location of primary care health centers.
The Health of the City report summarizes data on community health in Philadelphia through interactive charts and maps. The Health of the City table contains aggregate metrics on population statistics, social determinants of health, and health outcomes that were used to build this report.
This dataset contains location data for both Healthy Corner and Enhanced Healthy Corner Store. It is currently being updated. Please visit Food Fit Philly for information in the interim.
Street location, hours and contact information of PDPH-affiliated HealthyStart Community Resource Centers.
Describes heat vulnerability by census tract incorporating exposure and sensitivity indicators.
This point layer contains the locations of HIV testing sites in the City of Philadelphia.
To prevent homeowners from becoming homeless due to foreclosure, the City initiated the Residential Mortgage Foreclosure Prevention Program, an innovative program that links a Court of Common Pleas order requiring that homeowners facing foreclosure have an opportunity to meet with their lenders to negotiate an alternative to foreclosure with City-funded housing counseling, outreach, a hotline and legal assistance. Working together, the City and the Court have created and implemented a national model.
OHCD has long supported neighborhood-based and citywide organizations offering housing counseling services to low- and moderate-income people. OHCD-funded services provided by these agencies include mortgage counseling, default and delinquency counseling, tenant support and housing consumer education. Through these services prospective homeowners can avoid predatory loans, a significant cause of foreclosure.
Data relating to the Indego BikeShare program, including station locations and the number of available bikes. More information about the program is available at: https://www.rideindego.com/about/data/
Data relating to the Indego BikeShare program, including station locations and the number of available bikes. More information about the program is available at: https://www.rideindego.com/about/data/
This dataset tracks usage of the City’s language access services through contracts with external vendors for translation and interpretation.
To identify boundaries for City Leaf Collection Services.
The Litter Index is used to compare the relative cleanliness of different areas of the city of Philadelphia. This data will be updated annually.
DHCD’s Neighborhood Advisory Committee (NAC) Program offers community-based non-profit organizations the opportunity to lead and engage neighborhood residents in activities that support the City’s core objectives.
DHCD supports the Energy Coordinating Agency’s (ECA) Neighborhood Energy Centers, through which residents can complete applications to seek bill payment assistance, learn how to conserve water, gas and electricity, and obtain energy counseling.
This dataset is derived from the Neighborhood Food Retail in Philadelphia report. The report, and accompanying online resource gallery, looks at neighborhood availability of “high-produce supply stores” (e.g., supermarkets, produce stores, farmers’ markets) in relation to “low-produce supply stores” (like dollar stores, pharmacies, and convenience stores).
Dataset with the contact information for Housing Counseling Agencies, Neighborhood Advisory Committees, and Neighborhood Energy Centers.
.
Explore Philadelphia’s most popular open geographic data in one easy to use mapping tool. This tool was built by the City’s Office of Innovation and Technology’s CityGeo team.
Data includes location points of Pennsylvania ambulatory surgical centers, facilities for surgeries to be performed on a person who is admitted to and discharged from the location on the same day.
The PA Birth Centers includes the locations of birth facilities in Pennsylvania. A birth center is a medical facility, specializing in childbirth, that is less restrictive and more homelike than a hospital. When possible, efforts were made to confirm the rooftop location of each birth facility. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Community Mental Health Centers a database of facilities that provide prevention, treatment, and rehabilitation mental health service, sometimes organized as a practical alternative to the largely custodial care given in mental hospitals. When possible, efforts were made to confirm the rooftop location of each community mental health center. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Drug Alcohol Treatment Facilities dataset includes facilities that specialize in the evaluation and treatment of drug addiction, alcoholism and associated disorders. When possible, efforts were made to confirm the rooftop location of each drug and alcohol treatment facility. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
Locations of home health care agencies in Pennsylvania, according to the PA Department of Health’s Quality Assurance Database. Home Health care agencies specialize in providing skilled nursing services, home health aides, and other therapeutic services, such as physical therapy, in patients’ homes.
Locations of Pennsylvania hospices, according to the PA Department of Health’s quality assurance database. A hospice is a home providing care for the sick or terminally ill.
The PA Hospitals layer contains the latitude and longitude coordinates of hospitals in Pennsylvania. A hospital is an institution in which sick or injured persons are given medical or surgical treatment. When possible, efforts were made to confirm the rooftop location of each hospital. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Intermediate Care Facilities dataset includes facilities where care is provided to acute care patients who are medically stable but too unstable to be treated in alternative healthcare settings such as home, ambulatory, or traditional skilled long term care. When possible, efforts were made to confirm the rooftop location of each intermediate care facility. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Medical Marijuana Dispensaries dataset includes facilities where medical marijuana is dispensed. When possible, efforts were made to confirm the rooftop location of each medical marijuana dispensary. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Nursing Homes dataset includes facilities for people who don’t need to be in a hospital but can’t be cared for at home. When possible, efforts were made to confirm the rooftop location of each nursing home. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Physical Speech Therapy Facilities dataset includes facilities where the assessment and treatment for communication problems and speech disorders are performed. When possible, efforts were made to confirm the rooftop location of each physical speech therapists. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
The PA Psychiatric Residential Treatment Facilities dataset includes facilities that provide out-of-home psychiatric care to children, adolescents, and young adults in a non-hospital, highly structured setting. When possible, efforts were made to confirm the rooftop location of each psychiatric residential treatment facility. The accuracy of geocoding is available in Geocoding Certainty attribute field (Geocoding Certainty: Rooftop=”00”, Street=”01”, Zip Centroid=”04”, Not geocoded=”99”).
Point location features for all PPR Program site locations. This dataset includes recreation centers, playgrounds, older adult centers, swimming pools, and environmental education centers.
This dataset includes people released to Philadelphia from the Philadelphia Department of Prisons (PDP) and the Pennsylvania Department of Correction (PA DOC). Individual-level data for releases from Federal (BOP) incarceration was not available, and makes up less than 2% of people released to Philadelphia in the year analyzed. The dataset also only includes people released to Philadelphia who have been charged with a criminal non-summary type offense in the Philadelphia adult criminal justice system.
Locations and basic information on public art that is part of the Percent for Art program. Updated as needed.
The Philadelphia Housing Authority Housing Sites application is a map of public housing in the City of Philadelphia. The application enables users to filter results by type of development, number of bedrooms, and units with accessibility features. The information for each housing site includes the name, location, an image, and a link to a fact sheet with additional details.
This data has stopped receiving updates. We’re working to reestablish automation by the end of 2022.
This dataset provides a list of businesses that have registered as sweetened beverage distributors or dealers that file and pay the tax. The search application built off of this dataset allows businesses to find or confirm that their distributors or dealers are registered. Please note that this dataset shows only those Registered Distributors and Registered Dealers who consented to share their information publicly and thus this list may not be a comprehensive list of all who have registered.
This dataset includes the number of newly identified (incident) children with blood lead levels (BLL) ≥5 µg/dL, the number of children screened, and the percent of children screened with BLLs ≥5 µg/dL. The ZIP code data is for 2015 and the census tract data is for 2013-2015.
Cell counts with missing values are those with less than six observations, which was truncated to ensure confidentiality. Cells with values of zero were included.
A list of hospitals and their location in Philadelphia.
A survey assessment on home broadband and device access in the City of Philadelphia.
Vital Statistics tables that contain aggregate metrics on the mortality (deaths) of Philadelphia residents. Included in these datasets are mortality metrics by planning district or citywide. You can find natality (births) metrics, and social determinants of health metrics at the city and planning district levels of geography as well. Population metrics are provided at the city, planning district, and census tract levels of geography. Please refer to this technical notes document to access detailed technical notes and variable definitions.
Vital Statistics tables that contain aggregate metrics on the natality (births) of Philadelphia residents. Included in these datasets are natality metrics by planning district or citywide. You can find mortality (deaths) metrics, and social determinants of health metrics at the city and planning district levels of geography as well. Population metrics are provided at the city, planning district, and census tract levels of geography. Please refer to the metadata links below for variable definitions and this technical notes document to access detailed technical notes about the datasets.
Population metrics are provided at the census tract, planning district, and citywide levels of geography.
You can find related vital statistics tables that contain aggregate metrics on natality (births) and mortality (deaths) of Philadelphia residents as well as social determinants of health metrics at the city and planning district levels of geography. Please refer to the metadata links below for variable definitions and the technical notes document to access detailed technical notes and variable definitions.
Social determinants of health metrics at the city and planning district levels of geography. Please refer to the metadata links below for variable definitions and this technical notes document to access detailed technical notes and variable definitions.
You can find related vital statistics tables that contain aggregate metrics on vital events, including natality (births) metrics and mortality (deaths) by planning district or citywide. Population metrics are provided at the city, planning district, and census tract levels of geography.
This is the location and address data of all current KEYSPOT computer labs in Philadelphia.
The boundaries of the four designated pilot areas included in the Philly Rising program. Philly Rising focuses on areas with chronic quality of life concerns and works with residents and community groups to address neighborhood issues.
The City of Philadelphia’s ArcGIS Online organization that hosts references to open data releases as feature services and AGO map applications shared with the public. Maintained by the City’s Office of Innovation and Technology’s CityGeo team.
The streets (at the center of platystreet blocks) involved in the PPR Playstreets Program. This program closes designated streets to traffic so that kids have a safe place to play when school is out. A key feature of the program are the nutritious meals and snacks provided to children. This is important during the summer months when school meals are not available.
Displays the locations of adult exercise equipment located within or are maintained by Philadelphia Parks and Recreation (PPR).
Displays the locations of adult exercise equipment located within or maintained by Philadelphia Parks and Recreation (PPR).
Locations within PPR that are permittable based on PPR team. Feature designed to link with Permitting Application for PPR. BETA Version.
Displays the locations of picnic sites located within Philadelphia Parks and Recreation boundaries. Picnic sites are denoted as any location with a picnic table.
Displays the locations of playgrounds within PPR Boundaries. Playgrounds ARE designated as similar age range equipment within a definable distance (not each piece of equipment).
Polygon boundaries of PPR’s program districts as established by PPR’s GIS staff and reviewed, revised, and approved by PPR’s executive staff.
Displays the locations of tennis courts located within properties maintained by Philadelphia Parks and Recreation (PPR).
2018 data: This dataset was developed as part of an Urban Tree Canopy (UTC) assessment for Philadelphia,Pennsylvania. It shows how tree canopy changed during the period 2008-2018, highlighting trees that were gained or lost during the 10-year period. It is intended for use in monitoring patterns of change in Philadelphia,Pennsylvania tree canopy.
2015 data: Collection of tree canopy outlines and points generated by Intergraph Government Solutions (IGS) for trees >6’ diameter. Update generated off the 2015 Leaf-Off 3” AccuPLUS Imagery representing changes in tree canopy visible within the imagery. Heights have been derived separately for each tree canopy outline from 2015 LiDAR data capture.
This point layer contains the locations of PrEP providers in the City of Philadelphia.
A sewershed is the area of land where all the sewers flow to a single end point, in most cases it is a regulator/permitted outfall, but in cases when the flow can be split between multiple regulators/permitted outfalls, the area above the point of split is treated as a separate sewershed.
Locations where PWD has conducted surface water quality sampling and other types of stream assessments. Sampling activities may include water quality grab sampling, habitat assessment, and sampling of invertebrates, fish and algae from wadeable streams. Not all assessment activities are performed at all sites.
Rate of recycling per rubbish/recycling district in total tons of recycling divided by the total tons of rubbish (garbage) collected during the given time period, either fiscal year, a fiscal year through a given quarter, or within one quarter.
Locations of community gardens throughout the City of Philadelphia that are registered with the Philadelphia Parks and Recreation’s Urban Agriculture Team.
Street location, contact information and hours of PDPH-funded HIV Treatment Centers.
Data includes the boundaries for city sanitation areas (which are aggregations of Sanitation Districts).
Sites where residents can drop off household trash and recycling.
This point layer contains the locations of sharps (needle) drop boxes in the City of Philadelphia.
Tobacco-free school zones included in the tobacco retailing regulations. This part of the regulation prohibits new tobacco retailer permits within 500 feet of any K-12 school property parcel. For more information visit
Related datasets include the Tobacco Retailers Permits and Tobacco Youth Sales Violations.
Retailers apply for a tobacco permit through an online application system, entering name, address, and other relevant business information. These data are cleaned and stored in a database maintained by the Department of Public Health.
Related datasets include the Tobacco Youth Sales Violations and Tobacco-Free School Zones.
This data contains the High Injury Network. It is derived using spatial data analysis of crash data for years 2012-2016 from Pennsylvania Department of Transportation.
Hydrographic features included in Philadelphia Hydrology Map. This map was officially adopted by City Council as the official map of Philadelphia Watercourses Designated for Protection on September 13th, 2012. The geographic data depicts watercourses within Philadelphia County as they appear on the map and will not be edited or updated. For up-to-date hydrography see the Hydrolographic_Features_Poly layer under Hydrology.
Area designated by the U.S. Department of Housing and Urban Development deeming West Philadelphia as a Promise Zone. Click here to learn more about promise zones.