Dark Mode
SFDA Prosecution Records
Government & Civic Records
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Detailed information concerning criminal cases presented to the San Francisco District Attorney’s Office (SFDA) dating back to 2011. This data includes records of cases where the SFDA decided to take action, either by filing new criminal charges or by filing a motion to revoke probation or parole (MTR). The resource provides valuable insight into case progression, charge filing decisions, and ultimate outcomes determined by the office. This data is expected to be updated on a weekly basis, ensuring currency.
Columns
The data file includes 11 distinct data points for each case record:
- incident_number: The identification number associated with the police incident report.
- court_number: The unique case number assigned by the San Francisco Superior Court, unique to each defendant involved in a single incident.
- arrest_date: The calendar date when the arrest occurred.
- list_of_filed_charges: A listing of all specific charges brought forward for the case, using California penal code designations. For MTR cases, this list reflects the charges from the original filed case.
- filed_case_type: An abbreviation representing the most serious classification among the charges filed by the SFDA, such as Felony or Misdemeanor.
- crime_type: An abbreviation indicating the most serious crime classification among the charges filed, such as Burglary or DUI.
- dv_case: A Boolean indicator identifying whether the case involves domestic violence.
- da_action_taken: The specific action initiated by the District Attorney’s office, often noting whether new charges were filed.
- case_status: The current stage or resolution of the case within the criminal process, such as Conviction or Dismissal.
- data_as_of: A timestamp reflecting when the data was last updated in the source system.
- data_loaded_at: A timestamp reflecting when the data was last updated in the data portal itself.
Distribution
This dataset contains over 90,000 individual case rows and 11 columns, packaged in a CSV file format. The file size is approximately 15.19 MB.
Usage
The records are ideally suited for analysing patterns in criminal prosecution within San Francisco. Potential uses include tracking trends in specific crime types (e.g., DUI and Burglary are highly prevalent), measuring the efficiency and outcomes of DA actions, studying the prevalence and disposition of domestic violence cases, and evaluating historical policy impacts on filing decisions and case statuses. The data supports analysis of the criminal process from arrest date through case resolution.
Coverage
The data focuses exclusively on cases handled by the District Attorney’s Office in San Francisco. The records cover arrests and subsequent actions taken over a time range spanning from 1 January 2011 up to 3 February 2023. The scope includes all cases where the DA’s office filed new criminal charges or a Motion to Revoke Probation/Parole.
License
Attribution 4.0 International (CC BY 4.0)
Who Can Use It
This material is beneficial for public safety researchers and academics studying criminal justice systems, journalists reporting on law and order issues, government analysts tracking judicial metrics, and legal professionals seeking historical context on San Francisco prosecution outcomes.
Dataset Name Suggestions
- SFDA Prosecution Records
- San Francisco Case Outcomes 2011-2023
- District Attorney Filed Charges
- SF Criminal Justice Decisions
Attributes
Original Data Source: SFDA Prosecution Records
QUALITYLoading...