Return to search results
Complaints Against Police
As part of the Philadelphia Police Department's (PPD) accountability processes, PPD publishes four 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; the Complainant Demographics dataset shows the race, sex, and age of each person who filed a complaint against a police officer by complaint number, and CAP History dataset details the timeline by which PPD released the complaint, concluded the investigation, and determined any resulting discipline. See metadata links below for dataset and field descriptions. Includes data from the past five years. Updated monthly.
Historical records for 2009-2012 are also available at: https://opendataphilly.org/datasets/complaints-against-police/
Complete Metadata
| accessLevel | public |
|---|---|
| contactPoint |
{
"fn": "City of Philadelphia Open Data Program",
"hasEmail": "mailto:michelle.argyriou@phila.gov"
}
|
| description | As part of the Philadelphia Police Department's (PPD) accountability processes, PPD publishes four 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; the Complainant Demographics dataset shows the race, sex, and age of each person who filed a complaint against a police officer by complaint number, and CAP History dataset details the timeline by which PPD released the complaint, concluded the investigation, and determined any resulting discipline. See metadata links below for dataset and field descriptions. Includes data from the past five years. Updated monthly. Historical records for 2009-2012 are also available at: https://opendataphilly.org/datasets/complaints-against-police/ |
| distribution |
[
{
"title": "CAP Findings (Metadata)",
"format": "HTML",
"accessURL": "http://metadata.phila.gov/#home/datasetdetails/5a3827b4b9464c55711a0816/representationdetails/5a3827b6b9464c55711a081a/",
"mediaType": "text/html"
},
{
"title": "Complaints Against Police (Metadata)",
"format": "HTML",
"accessURL": "http://metadata.phila.gov/#home/datasetdetails/5a3827b4b9464c55711a0816/representationdetails/5a3827dbb954635579423e0f/",
"mediaType": "text/html"
},
{
"title": "Complainant Demographics (Metadata)",
"format": "HTML",
"accessURL": "http://metadata.phila.gov/#home/datasetdetails/5a3827b4b9464c55711a0816/representationdetails/5da768d5e1847000154b928a/",
"mediaType": "text/html"
},
{
"title": "Complainant Demographics (API)",
"format": "API",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#ppd_complainant_demographics",
"mediaType": "application/http"
},
{
"title": "CAP Findings (API)",
"format": "API",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#ppd_complaint_disciplines",
"mediaType": "application/http"
},
{
"title": "Complaints Against Police (API)",
"format": "API",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#ppd_complaints",
"mediaType": "application/http"
},
{
"title": "CAP History (API)",
"format": "API",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#ppd_complaints_history",
"mediaType": "application/http"
},
{
"title": "CAP History (Metadata)",
"format": "HTML",
"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5a3827b4b9464c55711a0816/representationdetails/63c86b4ebe68e70012069642/",
"mediaType": "text/html"
},
{
"title": "Complaints Against Police (Web Application)",
"format": "APPLICATION",
"accessURL": "https://www.phillypolice.com/accountability/complaints/",
"mediaType": "text/html"
},
{
"title": "CAP History (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=ppd_complaints_history&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20ppd_complaints_history"
},
{
"title": "Complainant Demographics (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+ppd_complainant_demographics&filename=ppd_complainant_demographics&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator"
},
{
"title": "CAP Findings (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+ppd_complaint_disciplines&filename=ppd_complaint_disciplines&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator"
},
{
"title": "Complaints Against Police (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+ppd_complaints&filename=ppd_complaints&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator"
}
]
|
| identifier | complaints-against-police |
| keyword |
[
"Philadelphia Police Department",
"complaints",
"public safety"
]
|
| license | https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/ |
| modified | R/P1M |
| publisher |
{
"name": "City of Philadelphia",
"@type": "org:Organization"
}
|
| spatial | Philadelphia, Pennsylvania |
| title | Complaints Against Police |
