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 Cases Prosecuted

Metadata Updated: November 8, 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 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

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 November 8, 2025

Metadata Source

Harvested from SFO JSON

Additional Metadata

Resource Type Dataset
Metadata Created Date April 28, 2022
Metadata Updated Date November 8, 2025
Publisher data.sfgov.org
Maintainer
Identifier https://data.sfgov.org/api/views/dcjk-vw8q
Data First Published 2022-03-30
Data Last Modified 2025-11-04
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 8b574060-55e7-4f5c-a0e3-c8cc17fa090a
Harvest Source Id 8507fa43-f429-4095-b732-2177330ce485
Harvest Source Title SFO JSON
Homepage URL https://data.sfgov.org/d/dcjk-vw8q
License http://opendatacommons.org/licenses/pddl/1.0/
Source Datajson Identifier True
Source Hash 5c48e7c99b9526e2535637c4862a684615de23c2a612329585a8daed95669577
Source Schema Version 1.1

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