About the records
The records come from the Philadelphia Police Department (PPD) shooting-victim dataset. Each row represents one person whom PPD reported as a shooting victim. One incident can have more than one row if more than one person was harmed. Records begin in 2015. The dashboard does not include records that PPD marks as officer-involved. The latest data in the dashboard runs through August 16, 2026.
Downloads contain shooting-victim records only. They do not include the citywide homicide totals on the Statistics page.
Download the records
The CSV includes every available year and has one row for each person in the dashboard. It contains 17,703 records through August 16, 2026.
Choose a year, filters, or another file type
Use the Explore page to download one year, download records that match your filters, or choose GeoJSON for mapping software. You can also view and map the same records there.
How to download a smaller set
- Choose a year or choose All Years. Use the filters if you want a smaller set of records.
- Select the Download Data button in the Explore controls.
- Choose Filtered Data for the records that match your filters. Choose All Data to include every record for the selected year. If you selected All Years, All Data includes every available year.
- Choose CSV for a table you can open in a spreadsheet program. Choose GeoJSON for mapping software. If you choose Aggregate By, the download shows totals for each area instead of one row for each person.
Area totals are counts, not rates. They do not adjust for differences in population. Consider population and other context before comparing areas. These records and maps cannot show the full harm shootings cause to people and communities or explain why they occur.
Sources and dates
“Records through” shows the latest incident date in the data used by this dashboard. It does not mean every incident up to that date has been added. PPD and other source agencies may add or change records later.
The dashboard checks PPD shooting-victim and homicide sources each day. PPD may not post new data on weekends or holidays, so the dates shown may stay the same. The automated search of UJS court records runs once a week.
| Source | How it is used | Dates in this dashboard |
|---|---|---|
| PPD shooting victims through OpenDataPhilly | Victim details, fatal or nonfatal outcome, incident date, location, race, sex, and age. | Records through August 16, 2026. Dashboard updated August 18, 2026. |
| PPD homicide statistics | All homicides citywide, whether or not a gun was involved. | Records through August 17, 2026. |
| Pennsylvania public court records | Results from an automated search of public court records using the police incident number. | Court records checked August 14, 2026. |
What to consider before using the data
- Some locations are missing or imprecise. Records without usable coordinates remain in totals and downloads but do not appear as points on the map. A mapped point should not be treated as an exact address.
- A positive court-search flag means the automated search found a result for the police incident number in the public court portal. It does not prove that someone was charged, show how a case ended, or prove that the result is tied to the shooting. A negative flag does not prove that no case exists.
Read the Methodology for the full details on what is included, how the data is prepared and checked, and its limits.
Field guide
CSV and GeoJSON downloads with one row per person include fields from the source and fields created while preparing the data. The table lists the key fields and their meanings.
| Field | Meaning |
|---|---|
dc_key | Police incident number. The same number may appear in more than one victim row. |
date | Source incident date and time, stored in a standard format. |
fatal | Whether PPD marks the victim record as fatal. |
age and age_group | Reported age, when available, and a derived age group. |
race and sex | Race and sex as reported in the source data. The displayed race value also uses the source's Latino field. |
latitude and longitude | Usable coordinates for the record, when available. GeoJSON stores these as a map point. |
street_name, block_number, and segment_id | Street and block values added while preparing the data. These are estimates, not exact addresses. |
| Geographic districts | ZIP code, neighborhood, police and City Council districts, state legislative districts, and school catchment when a location can be matched to an area. |
has_court_case | Whether the automated search found a result for the incident number in the public court portal. This field does not show how a case ended. |
Download map reference files
Each file below is GeoJSON, a common format for mapping software. Match the field listed in the shooting-victim CSV to the field with the same name in the map file. Mapping software often calls this a join. Blank values will not match a shape.
These files match the current dashboard download; they are not historical boundary files. Download the CSV and map files together because the dashboard-created street-block segment_id may change when street data are rebuilt.
| Reference file | Match this field |
|---|---|
| Download ZIP code boundaries | zip_code |
| Download Neighborhood boundaries | neighborhood |
| Download Police district boundaries | police_district |
| Download City Council district boundaries | council_district |
| Download Pennsylvania House district boundaries | house_district |
| Download Pennsylvania Senate district boundaries | senate_district |
| Download Elementary school catchment boundaries | school_name |
| Download Street blocks | segment_id |
Citing this dashboard
When citing a number, map, or download, include the Philadelphia Gun Violence Dashboard, the measure and time period, the source's “records through” date, the date you accessed the page, and the page URL. Name the Philadelphia Police Department as the original publisher when appropriate.
Example: Philadelphia Gun Violence Dashboard. “Data and downloads.” Shooting-victim records through August 16, 2026. Data from the Philadelphia Police Department via OpenDataPhilly. Accessed August 18, 2026. https://www.nickhand.dev/philly-gun-violence-map/data.
Licensing and documentation
The project's code is available under the MIT License. The MIT License covers the project code. It does not cover the source records. City and court records are still governed by their publishers' rules, including the UJS terms.
The Methodology explains how the records are prepared. The About page explains how to report a possible error.