Berkeley PD - Stop Data (October 1, 2020 - Present)
data.cityofberkeley.info | Last Updated 18 Jan 2023Berkeley PD transitioned to RIPA stop data collection effective October 1, 2020. Data collected from these stops conforms to requirements set forth in Government Code section 12525.5 that was enacted as a result of AB 953, the Racial and Identity Profiling Act (RIPA) of 2015 (https://oag.ca.gov/ab953). Berkeley PD will begin reporting RIPA data to the CA DOJ effective January 1, 2021. For more information about any of the column definitions, please download the document: One Page Narrative for Stop Data (October 1, 2020).pdf.
This dataset has the following 45 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| LEA Record ID | lea_record_id | text | BPD000021324 BPD000029844 BPD000021502 BPD000030952 BPD000024411 view top 100 |
| Person Number | person_number | number | 1 2 3 4 5 view top 100 |
| Date of Stop | date_of_stop | calendar_date | 2021-03-12T00:00:00.000 2021-03-25T00:00:00.000 2021-03-26T00:00:00.000 2022-08-26T00:00:00.000 2021-02-26T00:00:00.000 view top 100 |
| Time of Stop | time_of_stop | text | 12:00 21:40 21:50 22:30 16:50 view top 100 |
| Duration of Stop | duration_of_stop | number | 10 5 15 20 30 view top 100 |
| Is Stop Made in Response to Call for Service | is_stop_made_in_response | text | false true view top 100 |
| Information Based Stop | information_based_stop | text | no yes view top 100 |
| Type Of Stop | type_of_stop | text | Vehicle Pedestrian Bicycle view top 100 |
| Officer Type of Assignment | officer_type_of_assignment | text | Patrol, traffic enforcement, field operations Investigative/detective Special events (e.g., sports, concerts, protests) K-12 public school, including school resource officer or school police officer Task force view top 100 |
| Location | location | text | 2100 block of Martin Luther King Jr Way 2200 block of Shattuck Ave 2600 block of Telegraph Ave University Ave 800 block of University Ave view top 100 |
| City | city | text | Berkeley Emeryville Oakland Albany Hayward view top 100 |
| Is Location a K12 Public School | is_location_a_k12_public | text | false true view top 100 |
| If K12 School Is Stop of a Student | if_k12_school_is_stop_of | text | false true view top 100 |
| School Name | school_name | text | BERKELEY HIGH JOHN MUIR ELEMENTARY LONGFELLOW ARTS AND TECHNOLOGY MIDDLE CRAGMONT ELEMENTARY MALCOLM X ELEMENTARY view top 100 |
| Education Code Section | education_code_section | text | view top 100 |
| Education Code Subdivision | education_code_subdivision | text | view top 100 |
| Race Perceived Prior To Stop | raceperceivedpriortostop | text | false true view top 100 |
| Perceived Race or Ethnicity | perceived_race_or_ethnicity | text | Black/African American White Hispanic/Latino Asian Middle Eastern/South Asian view top 100 |
| Perceived Gender | perceived_gender | text | Male Female Transgender Woman/Girl Transgender Man/Boy view top 100 |
| Perceived Gender Nonconforming | perceived_gender_nonconforming | text | false true view top 100 |
| Is LGBT | is_lgbt | text | false true view top 100 |
| Perceived Age | perceived_age | number | 30 40 50 25 35 view top 100 |
| Person had Limited or No English Fluency | person_had_limited_or_no | text | false true view top 100 |
| Perceived or Known Disability | perceived_or_known_disability | text | None Mental Health Condition None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Mental Health Condition|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Other disability|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Mental Health Condition|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Mental Health Condition|None|None|None|None|Mental Health Condition|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Mental Health Condition|None|None|Intellectual or developmental disability| including dementia|None|None|None|None|None|None|None|None|None|None|None|Other disability|None|None|Mental Health Condition|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Mental Health Condition|None|None|None|Mental Health Condition|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Deafness or difficulty hearing|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|Mental Health Condition|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None|None Other disability Speech impairment or limited use of language view top 100 |
| City of Residence | city_of_residence | text | BERKELEY OAKLAND RICHMOND Unknown SAN FRANCISCO view top 100 |
| Reason for Stop | reason_for_stop | text | Traffic Violation Reasonable suspicion Knowledge of outstanding arrest warrant/wanted person Consensual encounter resulting in search Investigation to determine whether person was truant view top 100 |
| Reason for Stop Narrative | reason_for_stop_narrative | text | Car stop Traffic Matched suspect description No plates Stop sign violation view top 100 |
| Traffic Violation Type | traffic_violation_type | text | Moving Violation Equipment Violation Non-moving violation / including registration view top 100 |
| Traffic Violation Offense Codes | traffic_violation_offense | text | VC 22450(A) FAIL STOP VEH:XWALK/ETC (I) VC 21453(A) FAIL STOP LINE/ETC AT RED (I) VC 22350 UNSAFE SPEED:PREVAIL COND (I) VC 23123(A) USE CELLPH W/DRIV W/O HFD (I) VC 5200(A) DISPLAY LIC PLATES WRONG (I) view top 100 |
| Suspicion Offense Code | suspicion_offense_code | text | AA NA - XX COMMUNITY CARETAKING (X) PC 602 TRESPASSING (M) PC 484 THEFT (M) PC 459 BURGLARY (F) BP 25620 POSS OPEN ALCOHOL:PUBLIC (I) view top 100 |
| Suspicion SubType | suspicion_subtype | text | Matched suspect description Other reasonable suspicion of a crime Officer witnessed commission of a crime Matched suspect description|Witness or victim ID of suspect at the scene Witness or victim ID of suspect at the scene view top 100 |
| Actions Taken | actions_taken | text | 24 5 4 5|18 6 view top 100 |
| Basis for Search | basis_for_search | text | Incident to arrest Condition of parole/probation/PRCS/mandatory supervision Officer safety/safety of others Incident to arrest|Officer safety/safety of others| Incident to arrest|Consent given|Evidence of crime|Visible contraband|Odor of contraband| Vehicle inventory| Incident to arrest|Consent given| Incident to arrest| Incident to arrest|Officer safety/safety of others| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Evidence of crime|Officer safety/safety of others|Consent given|Visible contraband|Odor of contraband| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Evidence of crime| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Evidence of crime| Incident to arrest|Consent given| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Evidence of crime| Vehicle inventory|Suspected weapons| Incident to arrest|Officer safety/safety of others| Incident to arrest|Consent given| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Evidence of crime| Incident to arrest|Consent given|Officer safety/safety of others|Evidence of crime|Evidence of crime|Officer safety/safety of others|Condition of parole/probation/PRCS/mandatory supervision|Consent given|Visible contraband|Odor of contraband| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Consent given| Incident to arrest|Consent given|Officer safety/safety of others|Condition of parole/probation/PRCS/mandatory supervision|Officer safety/safety of others|Suspected weapons| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Consent given|Consent given|Officer safety/safety of others|Officer safety/safety of others| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Officer safety/safety of others| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Condition of parole/probation/PRCS/mandatory supervision|Officer safety/safety of others|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Consent given|Condition of parole/probation/PRCS/mandatory supervision|Officer safety/safety of others| Incident to arrest| Incident to arrest|Officer safety/safety of others| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest| Incident to arrest|Evidence of crime|Condition of parole/probation/PRCS/mandatory supervision| Vehicle inventory|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision|Evidence of crime| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision| Incident to arrest| Incident to arrest| Incident to arrest|Condition of parole/probation/PRCS/mandatory supervision Consent given view top 100 |
| Basis for Search Narrative | basis_for_search_narrative | text | Incident to arrest Arrested Search incident to arrest Consent Probable cause view top 100 |
| Basis for Property Seizure | basis_for_property_seizure | text | Evidence Evidence|Safekeeping as allowed by law/statute|Evidence|Evidence|Contraband|Evidence|Safekeeping as allowed by law/statute|Contraband|Evidence|Impound of vehicle|Evidence|Contraband|Contraband|Evidence|Evidence|Evidence|Evidence|Safekeeping as allowed by law/statute|Contraband|Evidence Contraband Contraband|Evidence Evidence|Contraband view top 100 |
| Type of Property Seized | type_of_property_seized | text | Suspected stolen property| Other contraband or evidence|Drug paraphernalia|Drugs/narcotics|Drug paraphernalia|Suspected stolen property|Drugs/narcotics|Suspected stolen property| Vehicle| Other contraband or evidence|Suspected stolen property|Drugs/narcotics|Drugs/narcotics|Suspected stolen property| Other contraband or evidence|Weapon(s) other than firearm|Drugs/narcotics|Drugs/narcotics|Drug paraphernalia Drug paraphernalia Drugs/narcotics Other contraband or evidence Drugs/narcotics|Drug paraphernalia view top 100 |
| Contraband or Evidence | contraband_or_evidence | text | view top 100 |
| Other Contraband Desc | other_contraband_desc | text | Burglary tools Tools None. BWC noting 415(2)/COVID vio Fake ID view top 100 |
| Warning Offense Codes | warning_offense_codes | text | PC 602 TRESPASSING (M) VC 21453(A) FAIL STOP LINE/ETC AT RED (I) VC 22450(A) FAIL STOP VEH:XWALK/ETC (I) VC 22350 UNSAFE SPEED:PREVAIL COND (I) VC 5200(A) DISPLAY LIC PLATES WRONG (I) view top 100 |
| Citation Offense Codes | citation_offense_codes | text | VC 23123(A) USE CELLPH W/DRIV W/O HFD (I) VC 23123.5(A) NO HND HLD DEVICE W/DRIVE (I) VC 22450(A) FAIL STOP VEH:XWALK/ETC (I) VC 21453(A) FAIL STOP LINE/ETC AT RED (I) VC 21950(A) FAIL YIELD TO PED:XWALKS (I) view top 100 |
| Result of Stop | result_of_stop | text | Warning (verbal or written) Citation for infraction No action Custodial arrest without warrant Psychiatric hold (W&I Code 5150 or 5585.20) view top 100 |
| In field cite and release Offense Codes | in_field_cite_and_release | text | HS 11364(A) POSS UNLAW PARAPHERNALIA (M) PC 484 THEFT (M) HS 11377(A) POSSESS CNTL SUB (M) HS 11377(A) POSS CONTROLLED SUBSTANCE (F) PC 602 TRESPASSING (M) view top 100 |
| Custodial arrest Offense Codes | custodial_arrest_offense | text | PC 647(F) DISORD CONDUCT:ALCOHOL (M) VC 23152(A) DUI ALCOHOL (M) PC 459 BURGLARY (F) PC 273.5 INFLICT CRPL INJ SP/COHAB (F) PC 211 ROBBERY (F) view top 100 |
| LAT | lat | number | 0.0000000000000568434 37.87037504 37.85587801 37.87046298 37.85592399 view top 100 |
| LONG | long | number | 0.0000000000000568434 -122.2735849 -122.257312 -122.25727 -122.294613 view top 100 |