About this Dataset

District Attorney Case Resolutions

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 data set includes all criminal cases prosecuted by the District Attorney’s Office that have reached a final resolution, or disposition. A case is resolved when a final determination has been made in court (i.e., an acquittal, conviction, dismissal, or a judge finds a defendant has successfully completed diversion). A case may also be resolved through other means. For example, a case may be re-indicted, a defendant may be released to another agency's custody, etc. Because of the case tracking systems used in the San Francisco Superior Court, these cases are assigned new court numbers and thus show up as distinct cases in the data available to the District Attorney’s Office. Lastly, sometimes a defendant will have multiple criminal cases related to the same incident or similar types of crimes. The defendant may plead guilty to one case, and in exchange, the other cases will be dropped. The San Francisco Superior Court codes these cases as "1385 PC - Guilty Plea to Other Charge". More information about this dataset can be found under the “Case Resolutions” 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 a case prosecuted by the District Attorney’s Office reaches a final resolution, or disposition, 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 “Case Resolutions” section on the Data Dashboards page for more information about this dataset. E. Related DATASETS District Attorney Actions Taken on Arrests Presented District Attorney Cases Prosecuted
Organization: City of San Francisco
Last updated: 2022-04-28T05:22:14.855832

Tables

Table 1

@usgov.city_of_san_francisco_district_attorney_case_resolutions.table_1

2.59 MB
76,152 rows
14 columns

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