Home › Sources › sfda_prosecuted_cases
San Francisco District Attorney Cases Prosecuted
Source ID sfda_prosecuted_cases. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfda_prosecuted_cases |
| Name | San Francisco District Attorney Cases Prosecuted |
| Owner | San Francisco District Attorney / DataSF |
| Layer | incident_arrest_prosecution |
| Coverage | Cases where SFDA filed charges or motions to revoke; the full paged Socrata pull generated 2026-06-05 captured 121,641 rows from 2011-01-01 through 2026-05-29, including 109,267 distinct court_number values and 101,352 distinct incident_number values. The local sample index and full public RDS/Postgres corpus load all prosecuted-case rows into prosecution_events and DA-derived case_outcomes with one upstream source_record per row; 24,336 full-corpus rows exact-join to court cases by normalized court_number/case_number. |
| Formats | JSON API, CSV, OData, Parquet via derived mirrors |
| Join keys | court_number, incident_number, arrest_date, list_of_filed_charges, case_status |
| Caveats | Case status must remain DA-sourced until reconciled with SFSC docket facts., May not cover all court outcomes; do not substitute for court ROA or disposition records., DA booked/filed charge tokens are source-labeled prosecution context and may not match court-owned charge rows one-for-one. |
Linked cases
21,310 matching cases for this source filter.
| Case | Filed | Division / type | Status | Named litigant | Events | Charges | Sources |
|---|---|---|---|---|---|---|---|
| CRI-26010337 | 2026-05-08 | criminal | Sentencing Observed | JOSE VELASQUEZ | 12 | 6 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26010300 | 2026-05-08 | criminal | - | VICO FOREST | 9 | 3 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26408991 | 2026-05-08 | criminal | Bench Warrant Observed | SARAH E MACKIN | 4 | 2 | sfda_prosecuted_cases |
| CRI-26010226 | 2026-05-07 | criminal | - | JONATHAN QUINTAY BROWN | 12 | 12 | sfda_arrests · sfda_case_resolutions · sfda_prosecuted_cases |
| CRI-26010215 | 2026-05-06 | criminal | Sentencing Observed | ETHAN CHA | 19 | 112 | sfda_arrests · sfda_case_resolutions · sfda_prosecuted_cases |
| CRI-26010095 | 2026-05-06 | criminal | - | COURTNEY FERROL BOSSE | 2 | 7 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26010032 | 2026-05-06 | criminal | - | ANGELICA HYDE | 7 | 4 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009943 | 2026-05-06 | criminal | - | JAMAL PEREZMANU TAUESE | 9 | 8 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009918 | 2026-05-06 | criminal | - | GABRIEL PLACENCIA | 10 | 9 | sfda_arrests · sfda_case_resolutions · sfda_prosecuted_cases |
| CRI-26010109 | 2026-05-05 | criminal | Sentencing Observed | NICHOLAS JAY DAVIDSON | 11 | 18 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009906 | 2026-05-05 | criminal | - | JOSE VICTOR GATO | 8 | 15 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009868 | 2026-05-05 | criminal | - | JOSE ANTONIO ESPINOZAFLORES | 8 | 10 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009846 | 2026-05-05 | criminal | - | CODY HATCH | 2 | 9 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009837 | 2026-05-04 | criminal | - | KAYVOOS CORDELL LEWIS | 18 | 3 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009835 | 2026-05-04 | criminal | - | KYLER ALEX SWEENEY | 16 | 3 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009826 | 2026-05-04 | criminal | - | JOSHUA DOWNS | 8 | 7 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009787 | 2026-05-04 | criminal | - | IKER ERAZO | 0 | 5 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009783 | 2026-05-04 | criminal | Dismissal Observed | DAOOD ALHALEMI | 25 | 13 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009774 | 2026-05-01 | criminal | - | NESTOR ACOSTA | 10 | 9 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009764 | 2026-05-01 | criminal | - | LEVI MICHAEL BANKS | 15 | 16 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009756 | 2026-05-01 | criminal | - | DESHAWN JERMAINE GAFFNEY | 12 | 7 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009740 | 2026-05-01 | criminal | - | TREVON SAVALAS BRITTENUIM | 10 | 9 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009732 | 2026-05-01 | criminal | - | ADOLFO DAVID RAUDALES | 17 | 8 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26009685 | 2026-05-01 | criminal | - | ANIL SAGAR | 11 | 4 | sfda_arrests · sfda_prosecuted_cases |
| CRI-26008621 | 2026-05-01 | criminal | - | MELVIN LACAP CHAVEZ | 2 | 6 | sfda_arrests · sfda_prosecuted_cases |
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sfda_prosecuted_cases | socrata_dataset | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | weekly target refresh |
| Coverage | Cases where SFDA filed charges or motions to revoke; the full paged Socrata pull generated 2026-06-05 captured 121,641 rows from 2011-01-01 through 2026-05-29, including 109,267 distinct court_number values and 101,352 distinct incident_number values. The local sample index and full public RDS/Postgres corpus load all prosecuted-case rows into prosecution_events and DA-derived case_outcomes with one upstream source_record per row; 24,336 full-corpus rows exact-join to court cases by normalized court_number/case_number. |
| Government Level | local_prosecution |
| ID | sfda_prosecuted_cases |
| Layer | incident_arrest_prosecution |
| Name | San Francisco District Attorney Cases Prosecuted |
| Owner | San Francisco District Attorney / DataSF |
| Profile Status | promoted_full_public_da_prosecution_extract |
| Canonical Records | prosecution_event, court_charge, case_outcome, source_record |
| Caveats | Case status must remain DA-sourced until reconciled with SFSC docket facts., May not cover all court outcomes; do not substitute for court ROA or disposition records., DA booked/filed charge tokens are source-labeled prosecution context and may not match court-owned charge rows one-for-one. |
| Evidence | artifacts/source-discovery/datasf-da-prosecution-context.profile.json, artifacts/source-discovery/datasf-da-cases-prosecuted-dcjk-vw8q.view.json, artifacts/source-discovery/datasf-da-cases-prosecuted-dcjk-vw8q.sample.json, artifacts/source-discovery/datasf-da-cases-prosecuted-dcjk-vw8q.profile-query.json, artifacts/source-discovery/datasf-da-cases-prosecuted-dcjk-vw8q.case-status-counts.json, artifacts/source-discovery/datasf-da-cases-prosecuted-dcjk-vw8q.linked-rows.json, data/enrichment_raw/da_cases_prosecuted.json, data/da_prosecution_raw/da_cases_prosecuted.json, data/da_prosecution_raw/manifest.json, scripts/sync_datasf_da_prosecution.py, scripts/profile_datasf_da_prosecution_context.py |
| Formats | JSON API, CSV, OData, Parquet via derived mirrors |
| Join Keys | court_number, incident_number, arrest_date, list_of_filed_charges, case_status |
| Known Endpoints | Socrata /resource/dcjk-vw8q.json |
| Rate Limit Notes | Use checkpointed Socrata paging with an app token for full sync; checkpoint by data_loaded_at plus court_number and incident_number., Normalize SFSC case_number and DA court_number for exact case joins; preserve raw DA labels beside normalized outcome categories. |
| Source Urls | https://data.sfgov.org/Public-Safety/District-Attorney-Cases-Prosecuted/dcjk-vw8q |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sources/sfda_prosecuted_casesJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfda_prosecuted_cases&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON