About this Dataset

District Attorney Actions Taken On Arrests Presented

A. SUMMARY _Please note that the "Data Last Updated" date on this page denotes the most recent DataSF update and does not reflect the most recent update to this dataset. To confirm the completeness of this dataset please contact the District Attorney's office at districtattorney@sfgov.org._ This dataset includes information on every arrest that has been presented to the SFDA since 2011 and the “action” decision made by the office on each, based on data from the SFDA’s internal case management system. After law enforcement has made an arrest for suspected criminal activity, the arresting agency presents its evidence to the District Attorney’s Office to determine what, if any, charges can be proven beyond a reasonable doubt. This prosecutorial decision to file or to reject arrest charges represents the first, and one of the most important, decisions of the District Attorney’s Office. In addition to either filing new charges or declining to file charges (“discharging” the arrest), the prosecutor may also take other actions, such as initiating a motion to revoke probation or parole, referring the case back to the arresting agency for further investigation, or referring the case to another criminal justice agency. More information about this dataset can be found under the “District Attorney Actions on Arrests Presented” section on the Data Dashboards page _Disclaimer: The San Francisco District Attorney's Office does not guarantee the accuracy, completeness, or timeliness of the information as the data is subject to change as modifications and updates are completed._ B. HOW THE DATASET IS CREATED When an arrest is presented to the District Attorney’s office, relevant data is manually entered into the District Attorney Office's case management system. Data reports are pulled from this system on a semi-regular basis, cleaned, anonymized, and added to Open Data. C. UPDATE PROCESS We strive to update this dataset at the beginning of every week. However, the creation of this dataset requires a manual pull from the Office's case management system and is dependent on staff availability. D. HOW TO USE THIS DATASET Please review the “District Attorney Actions on Arrests Presented” section on the Data Dashboards page for more information about this dataset. E. RELATED DATASETS District Attorney Cases Prosecuted District Attorney Case Resolutions
Organization: City of San Francisco
Last updated: 2022-04-28T05:21:32.486555

Tables

Table 1

@usgov.city_of_san_francisco_district_attorney_actions_taken__de176dba.table_1

3.85 MB
166539 rows
11 columns


CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "court_number" BIGINT,
  "arrest_date" TIMESTAMP,
  "arresting_agency" VARCHAR,
  "crime_type" VARCHAR,
  "list_of_booked_charges" VARCHAR,
  "booked_case_type" VARCHAR,
  "dv_case" VARCHAR,
  "da_action_taken" VARCHAR,
  "data_as_of" TIMESTAMP,
  "data_loaded_at" VARCHAR
);