San Francisco District Attorney Actions Taken on Arrests Presented
Source ID sfda_arrests. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfda_arrests |
| Name | San Francisco District Attorney Actions Taken on Arrests Presented |
| Owner | San Francisco District Attorney / DataSF |
| Layer | incident_arrest_prosecution |
| Coverage | Every arrest presented to SFDA since 2011; the full paged Socrata pull generated 2026-06-05 captured 177,387 rows from 2011-01-01 through 2026-05-31, with data_loaded_at 2026-06-01T22:09:14.737. The local sample index and full public RDS/Postgres corpus load all 177,387 arrest-action rows into prosecution_events with one upstream source_record per row; 25,361 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, arresting_agency, list_of_booked_charges |
| Caveats | DA action is not final court disposition and should not outrank court-owned docket/ROA facts., Court-number coverage should be measured against SFSC case_number before relying on joins., DA booked/filed charge tokens are source-labeled prosecution context and may not match court-owned charge rows one-for-one. |
Linked cases
25,361 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-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 |
| CRI-26008383 | 2026-05-01 | criminal | - | SHEILALYNEE ARUWI REEDFLORES | 2 | 6 | sfda_arrests · sfda_prosecuted_cases |
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sfda_arrests | socrata_dataset | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | weekly target refresh |
| Coverage | Every arrest presented to SFDA since 2011; the full paged Socrata pull generated 2026-06-05 captured 177,387 rows from 2011-01-01 through 2026-05-31, with data_loaded_at 2026-06-01T22:09:14.737. The local sample index and full public RDS/Postgres corpus load all 177,387 arrest-action rows into prosecution_events with one upstream source_record per row; 25,361 full-corpus rows exact-join to court cases by normalized court_number/case_number. |
| Government Level | local_prosecution |
| ID | sfda_arrests |
| Layer | incident_arrest_prosecution |
| Name | San Francisco District Attorney Actions Taken on Arrests Presented |
| Owner | San Francisco District Attorney / DataSF |
| Profile Status | promoted_full_public_da_prosecution_extract |
| Canonical Records | prosecution_event, agency_action, court_charge, source_record |
| Caveats | DA action is not final court disposition and should not outrank court-owned docket/ROA facts., Court-number coverage should be measured against SFSC case_number before relying on joins., 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-actions-arrests-czsm-3ei3.view.json, artifacts/source-discovery/datasf-da-actions-arrests-czsm-3ei3.sample.json, artifacts/source-discovery/datasf-da-actions-arrests-czsm-3ei3.profile-query.json, artifacts/source-discovery/datasf-da-actions-arrests-czsm-3ei3.da-action-counts.json, artifacts/source-discovery/datasf-da-actions-arrests-czsm-3ei3.linked-rows.json, data/enrichment_raw/da_actions_arrests.json, data/da_prosecution_raw/da_actions_arrests.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, arresting_agency, list_of_booked_charges |
| Known Endpoints | Socrata /resource/czsm-3ei3.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-Actions-Taken-on-Arrests-Present/czsm-3ei3 |
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_arrestsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfda_arrests&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON