About this Dataset

District Attorney Cases Prosecuted

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 all cases presented to the District Attorney’s Office in which the office has taken action to prosecute a case, either by filing new criminal charges or by filing a motion to revoke probation or parole (MTR). This does not include cases in which the San Francisco Adult Probation Department or the state Division of Adult Parole Operations files a motion to revoke. For cases in which SFDA files a new criminal charge, the most serious offense type is categorized as the most serious offense for which SFDA prosecuted the defendant. For cases in which SFDA files an MTR, the most serious offense is categorized as the most serious offense for which the person was initially prosecuted. This is because a filing of an MTR means that new criminal charges were not filed for the new arresting offense, but rather that the District Attorney’s Office is seeking a new sanction as part of the sentence of a prior criminal conviction. For MTRs, the filing date is based on the date when SFDA filed the MTR for the new arrest. More information about this dataset can be found under the “Cases Prosecuted” 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 District Attorney’s Office takes action to prosecute a case, 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 “Cases Prosecuted” section on the Data Dashboards page for more information about this dataset. E. Related DATASETS District Attorney Actions Taken on Arrests Presented District Attorney Case Resolutions
Organization: City of San Francisco
Last updated: 2022-04-28T05:21:33.071019

Tables

Table 1

@usgov.city_of_san_francisco_district_attorney_cases_prosecuted.table_1

2.9 MB
113008 rows
11 columns


CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "court_number" BIGINT,
  "arrest_date" TIMESTAMP,
  "list_of_filed_charges" VARCHAR,
  "filed_case_type" VARCHAR,
  "crime_type" VARCHAR,
  "dv_case" VARCHAR,
  "da_action_taken" VARCHAR,
  "case_status" VARCHAR,
  "data_as_of" TIMESTAMP,
  "data_loaded_at" VARCHAR
);