About this Dataset

Police Department Stop Data

UPDATE 1/7/2025: On June 28th 2023, the San Francisco Police Department (SFPD) changed its Stops Data Collection System (SDCS). As a result of this change, record identifiers have changed from the Department of Justice (DOJ) identifier to an internal record numbering system (referred to as "LEA Record ID"). The data that SFPD uploads to the DOJ system will contain the internal record number which can be used for joins with the data available on DataSF. A. SUMMARY The San Francisco Police Department (SFPD) Stop Data was designed to capture information to comply with the Racial and Identity Profiling Act (RIPA), or California Assembly Bill (AB)953. SFPD officers collect specific information on each stop, including elements of the stop, circumstances and the perceived identity characteristics of the individual(s) stopped. The information obtained by officers is reported to the California Department of Justice. This dataset includes data on stops starting on July 1st, 2018, which is when the data collection program went into effect. Read the detailed overview for this dataset here. B. HOW THE DATASET IS CREATED By the end of each shift, officers enter all stop data into the Stop Data Collection System, which is automatically submitted to the California Department of Justice (CA DOJ). Once a quarter the Department receives a stops data file from CA DOJ. The SFPD conducts several transformations of this data to ensure privacy, accuracy and compliance with State law and regulation. For increased usability, text descriptions have also been added for several data fields which include numeric codes (including traffic, suspicion, citation, and custodial arrest offense codes, and actions taken as a result of a stop). See the data dictionaries below for explanations of all coded data fields. Read more about the data collection, and transformation, including geocoding and PII cleaning processes, in the detailed overview of this dataset. C. UPDATE PROCESS Information is updated on a quarterly basis. D. HOW TO USE THIS DATASET This dataset includes information about police stops that occurred, including some details about the person(s) stopped, and what happened during the stop. Each row is a person stopped with a record identifier for the stop and a unique identifier for the person. A single stop may involve multiple people and may produce more than one associated unique identifier for the same record identifier. A certain percentage of stops have stop information that can’t be geocoded. This may be due to errors in data input at the officer level (typos in entry or providing an address that doesn't exist). More often, this is due to officers providing a level of detail that isn't codable to a geographic coordinate - most often at the Airport (ie: Terminal 3, door 22.) In these cases, the location of the stops is coded as unknown. E. DATA DICTIONARIES CJIS Offense Codes data look up table Look up table for other coded data fields
Organization: City of San Francisco
Last updated: 2023-09-29T16:06:49.758615
Tags: ab953, police-department, ripa, sfpd, stops

Tables

Table 1

@usgov.city_of_san_francisco_police_department_stop_data.table_1

24.6 MB
290862 rows
95 columns


CREATE TABLE table_1 (
  "doj_record_id" VARCHAR,
  "person_number" DOUBLE,
  "unique_identifier" VARCHAR,
  "lea_record_id" VARCHAR,
  "stop_data_record_status" VARCHAR,
  "agency_ori" VARCHAR,
  "nfia_flag" VARCHAR,
  "stop_datetime" VARCHAR,
  "stop_type" VARCHAR,
  "duration_of_stop" DOUBLE,
  "is_stop_response_to_call" VARCHAR,
  "location" VARCHAR,
  "district" VARCHAR,
  "city" VARCHAR,
  "is_location_k12_pub_school" VARCHAR,
  "k_12_school_code" VARCHAR,
  "perceived_race_ethnicity" VARCHAR,
  "perceived_gender" VARCHAR,
  "is_lgbt" VARCHAR,
  "perceived_age" DOUBLE,
  "perceived_age_group" VARCHAR,
  "had_limited_or_no_english" VARCHAR,
  "perceived_or_known_disability" VARCHAR,
  "if_k12_school_is_student" VARCHAR,
  "is_person_unhoused" VARCHAR,
  "is_welfare_check" VARCHAR,
  "reason_for_stop" VARCHAR,
  "reason_given_for_stop" VARCHAR,
  "traffic_violation_type" VARCHAR,
  "traffic_viol_cjis_off_code" DOUBLE,
  "traffic_viol_off_code" VARCHAR,
  "traffic_viol_off_statute" VARCHAR,
  "traffic_viol_off_type" VARCHAR,
  "traffic_viol_off_type_charge" VARCHAR,
  "suspicion_cjis_off_code" DOUBLE,
  "suspicion_off_code_txt" VARCHAR,
  "suspicion_off_statute" VARCHAR,
  "suspicion_off_type_statute" VARCHAR,
  "suspicion_off_type_charge" VARCHAR,
  "suspicion_sub_type" VARCHAR,
  "education_code_section" VARCHAR,
  "education_code_subdivision" VARCHAR,
  "actions_taken" VARCHAR,
  "force_actions_taken" VARCHAR,
  "nonforce_actions_taken" VARCHAR,
  "basis_for_search" VARCHAR,
  "basis_for_property_seizure" VARCHAR,
  "type_of_property_seized" VARCHAR,
  "contraband_or_evidence" VARCHAR,
  "results_of_stop" VARCHAR,
  "warning_cjis_off_code" VARCHAR,
  "warning_off_code_txt" VARCHAR,
  "warning_off_statute" VARCHAR,
  "warning_off_type_statute" VARCHAR,
  "warning_off_type_charge" VARCHAR,
  "citation_cjis_off_code" VARCHAR,
  "citation_off_code_txt" VARCHAR,
  "citation_off_statute" VARCHAR,
  "citation_off_type_statute" VARCHAR,
  "citation_off_type_charge" VARCHAR,
  "cite_release_cjis_off_code" VARCHAR,
  "cite_release_off_code_txt" VARCHAR,
  "cite_release_off_statute" VARCHAR,
  "cite_release_off_type_statute" VARCHAR,
  "cite_release_off_type_charge" VARCHAR,
  "cust_arrest_cjis_off_code" VARCHAR,
  "cust_arrest_off_code_txt" VARCHAR,
  "cust_arrest_off_statute" VARCHAR,
  "cust_arrest_off_type_statute" VARCHAR,
  "cust_arrest_off_type_charge" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "point" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "stop_data_record_status_code" BIGINT,
  "perceived_race_ethnicity_code" DOUBLE,
  "perceived_gender_code" DOUBLE,
  "perceived_gender_nonconforming_code" DOUBLE,
  "perceived_or_known_disability_code" VARCHAR,
  "reason_for_stop_code" DOUBLE,
  "traffic_violation_type_code" DOUBLE,
  "actions_taken_code" VARCHAR,
  "basis_for_search_code" VARCHAR,
  "basis_for_property_seizure_code" VARCHAR,
  "type_of_property_seized_code" VARCHAR,
  "contraband_or_evidence_code" VARCHAR,
  "suspicion_sub_type_code" VARCHAR,
  "force_actions_taken_code" VARCHAR,
  "nonforce_actions_taken_code" VARCHAR,
  "reason_given_for_stop_code" DOUBLE,
  "stop_type_code" DOUBLE,
  "results_of_stop_code" VARCHAR
);