Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content
This is a Non-Federal dataset covered by different Terms of Use than Data.gov.

District Attorney Case Resolutions

Metadata Updated: June 29, 2025

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

Access & Use Information

Public: This dataset is intended for public access and use. Non-Federal: This dataset is covered by different Terms of Use than Data.gov. License: See this page for license information.

Downloads & Resources

Dates

Metadata Created Date April 28, 2022
Metadata Updated Date June 29, 2025

Metadata Source

Harvested from SFO JSON

Additional Metadata

Resource Type Dataset
Metadata Created Date April 28, 2022
Metadata Updated Date June 29, 2025
Publisher data.sfgov.org
Maintainer
Identifier https://data.sfgov.org/api/views/ynfy-z5kt
Data First Published 2022-03-30
Data Last Modified 2025-06-25
Category Public Safety
Public Access Level public
Metadata Context https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
Metadata Catalog ID https://data.sfgov.org/data.json
Schema Version https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby https://project-open-data.cio.gov/v1.1/schema/catalog.json
Harvest Object Id 9108796d-c5cf-40d7-ac94-53276b9eb2ce
Harvest Source Id 8507fa43-f429-4095-b732-2177330ce485
Harvest Source Title SFO JSON
Homepage URL https://data.sfgov.org/d/ynfy-z5kt
License http://opendatacommons.org/licenses/pddl/1.0/
Source Datajson Identifier True
Source Hash b277129320ac2ed2590200b489cd95fdba737864b2c80101719c8ab9c5fc6167
Source Schema Version 1.1

Didn't find what you're looking for? Suggest a dataset here.