Commission on Police Practices Cases 2019-2024
About this dataset
Commission on Police Practices cases. CPP is an independent body that investigates officer-involved shootings, in-custody deaths, & other significant incidents in a process that is transparent and accountable to the community.
In 2020, voter-approved Measure B created a new independent Commission on Police Practices (CPP) that replaced the Community Review Board on Police Practices (CRB). This dataset covers all cases the CPP reviewed and closed out since the beginning of FY 2020.
The mission of the Commission is to hold law enforcement accountable to the community and to increase community trust in law enforcement, resulting in increased safety for both the community and law enforcement. To learn more, visit sandiego.gov/cpp/about
Each case in this dataset is identified by a unique case id and case number. A single case may involve multiple allegations, multiple complainants and multiple officers. Each officer named in the complaint is assigned an anonymous person id in the pid field that is unique for that case id. Complainant, cases and allegations are in separate files that can be joined on the id and case_number fields. Each complainant named in the complainant file is assigned an anonymous person id in the complainant_id field that is unique for that case id.
The body worn camera details file included with this dataset lists each officer (pid) per complaint and whether that officer had a body worn camera on or off during the incident under review.
Get the data
Browse the table below for all files available for this dataset
View a data sample
Showing 1 transposed sample row. Download the full dataset or a view to get the data.
Data Sample
| Field | Sample Value |
|---|---|
| id | 25-1 |
| case_number | 2023-0459 |
| date_assigned | 1/24/24 |
| date_completed | 6/25/24 |
| date_presented | 7/3/24 |
| days_number | 153 |
| days_30_or_less | NO |
| days_60_or_less | NO |
| 90_days_or_less | NO |
| 120_days_or_less | NO |
| changes | NO |
| incident_address | 5400 University Avenue |
| pd_division | Mid City |
| pretext_stop | NO |
| vehicle_persuit | NO |
| beat | 822 |
| council_district | 9 |
Understand the data
Each field in the data is defined in the table below. Use this information to inform usage of the data.
Download dictionaryData Dictionary
| Field | Data_type | Description | Possible_values |
|---|---|---|---|
| id | Case id | ||
| case_number | Case number | ||
| date_assigned | Date assigned to CRB | ||
| date_completed | Date CRB team completed case | ||
| date_presented | Date CRB deliberated on case | ||
| days_number | Number of days for case to be reviewed | ||
| days_30_or_less | Whether the case was reviewed within 30 days of assignment. | Y, N | |
| days_60_or_less | Whether the case was reviewed within 60 days of assignment. | Y, N | |
| 90_days_or_less | Whether the case was reviewed within 90 days of assignment. | Y, N | |
| 120_days_or_less | Whether the case was reviewed within 120 days of assignment. | Y, N | |
| changes | Review Group requested changes to the Internal Affairs investigation or report during the review process. | Y, N | |
| incident_address | Nearby address of incident location | ||
| pd_division | SDPD division where incident occurred | ||
| pretext_stop | Indicates whether the incident involved an alleged pretext stop. | Y, N | |
| vehicle_persuit | Indicates whether the incident involved a vehicle pursuit. | Y, N | |
| beat | SDPD patrol beat where the incident occurred | ||
| council_district | City Council district where the incident occurred |
- PublisherCommission on Police Practices
- Last Updated Dec 3, 2025
- Update Frequency Annually
- Date Issued Sep 4, 2019
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov