RIPA police stop data - actions taken

Police Updated Jan 6, 2024 Quarterly

About this dataset

Actions an officer took toward a person stopped by the San Diego Police Department.

Data were collected according to requirements set forth in Government Code section 12525.5 that was enacted as a result of the Racial and Identity Profiling Act of 2015 (AB 953), also known as RIPA. Beginning in 2024, actions taken were split into force and non-force actions, which can be found under related datasets.

The file contains one row per action per person stopped by Police. An officer may have taken more than one action toward a person. The person stopped is uniquely identified in the pid field, and the stop is uniquely identified in the stop_id field. These two fields can be used to join this dataset to the other RIPA datasets available.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name Download actions File Format File size
Actions taken Download

Copy URL

CSV

6.46 MB

Actions taken - Historic Download

Copy URL

CSV

40.99 MB

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field Sample Value
id4866
pid1
actionPerson removed from vehicle by order
personsearchconsentFalse
propertysearchconsentTrue
insertdatetime2024-06-25 11:14:59.810000

Understand the data

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Download dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
FieldField_typeDescriptionPossible_values
uidstrunique identifer for stop
idint64unique identifer for stop
pidint64unique identifer for person on a stop
actionstrofficer's actions toward the person stoppedhttps://oag.ca.gov/system/files/media/ripa-final-text-of-proposed-regulations.pdf
consentedstrresponse by person stopped if officer asked for consent to searchYes or blank
insertdatetimedatetime
  • PublisherPolice
  • Last Updated Jan 6, 2024
  • Update Frequency Quarterly
  • Date Issued Apr 16, 2019
  • Available Formats .CSV
  • License View License

Data & Analytics

data@sandiego.gov