Skip to main content
U.S. flag

An official website of the United States government

District Attorney Case Resolutions

Published by data.sf.gov | City of San Francisco | Catalog Last Checked: September 16, 2026 at 06:50 PM | Dataset Last Updated: September 15, 2026
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

Resources

3 resources available

Find Related Datasets

Search by Tags

Click any tag below to search for similar datasets

Complete Metadata
@type dcat:Dataset
accessLevel public
contactPoint 
{
  "fn": "OpenData",
  "@type": "vcard:Contact",
  "hasEmail": "mailto:no-reply@data.sf.gov"
}
description <strong>A. SUMMARY</strong> <strong><i>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 <u><a href=”mailto:districtattorney@sfgov.org”>districtattorney@sfgov.org</a></u>.</strong></i> 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 <u><a href="https://sfdistrictattorney.org/policy/data-dashboards/#case-resolutions">Data Dashboards page</a></u> <strong><i>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.</strong></i> <strong>B. HOW THE DATASET IS CREATED</strong> 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. <strong>C. UPDATE PROCESS</strong> 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. <strong>D. HOW TO USE THIS DATASET</strong> Please review the “Case Resolutions” section on the <u><a href="https://sfdistrictattorney.org/policy/data-dashboards/#case-resolutions">Data Dashboards page</a></u> for more information about this dataset. <strong>E. Related DATASETS</strong> <u><a href="https://data.sfgov.org/d/czsm-3ei3">District Attorney Actions Taken on Arrests Presented</a></u> <u><a href="https://data.sfgov.org/d/dcjk-vw8q">District Attorney Cases Prosecuted</a></u>
distribution 
[
  {
    "@type": "dcat:Distribution",
    "mediaType": "application/json",
    "describedBy": "https://data.sf.gov/api/views/ynfy-z5kt/columns.json",
    "downloadURL": "https://data.sf.gov/api/v3/views/ynfy-z5kt/query.json?accessType=DOWNLOAD",
    "describedByType": "application/json"
  },
  {
    "@type": "dcat:Distribution",
    "mediaType": "application/xml",
    "describedBy": "https://data.sf.gov/api/views/ynfy-z5kt/columns.xml",
    "downloadURL": "https://data.sf.gov/api/v3/views/ynfy-z5kt/query.xml?accessType=DOWNLOAD",
    "describedByType": "application/xml"
  },
  {
    "@type": "dcat:Distribution",
    "mediaType": "text/csv",
    "downloadURL": "https://data.sf.gov/api/v3/views/ynfy-z5kt/export.csv?accessType=DOWNLOAD"
  }
]
identifier https://data.sf.gov/api/views/ynfy-z5kt
issued 2022-03-30
keyword 
[
  "untagged"
]
landingPage https://data.sf.gov/d/ynfy-z5kt
license http://opendatacommons.org/licenses/pddl/1.0/
modified 2026-09-15
publisher 
{
  "name": "data.sf.gov",
  "@type": "org:Organization"
}
theme 
[
  "Public Safety"
]
title District Attorney Case Resolutions

data.gov

An official website of the GSA's Technology Transformation Services

Looking for U.S. government information and services?
Visit USA.gov