Home › Sources › datasf_dpa_misconduct_cases_b4we_97wx
DataSF Police Accountability Misconduct Cases and Allegations
Source ID datasf_dpa_misconduct_cases_b4we_97wx. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_dpa_misconduct_cases_b4we_97wx |
| Name | DataSF Police Accountability Misconduct Cases and Allegations |
| Owner | San Francisco Department of Police Accountability / DataSF |
| Layer | agency_oversight_context |
| Coverage | Full small DataSF DPA misconduct cases/allegations extract: 8,793 rows across 2,063 distinct DPA case numbers. Complaint received dates span 2017-01-06 through 2026-03-29; findings issued dates span 2024-01-02 through 2026-03-30; latest observed data_loaded_at is 2026-05-29T12:10:00.581. Rows now load into agency_oversight_cases as source-labeled DPA allegation context. |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | unique_id, case_number, officer_involvement_id, allegation_id, complaint_received_date, findings_issued_date, incident_location, analysis_neighborhood |
| Caveats | DPA case numbers are not SFSC case numbers and must remain namespaced., DPA findings and public narratives are accountability context, not criminal charges, guilt findings, or court outcomes., Complainant demographic fields are source-labeled context and must not become person identity records., Officer involvement IDs are source identifiers, not officer names. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | datasf_dpa_misconduct_cases_b4we_97wx | socrata_full_small_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | weekly target refresh |
| Coverage | Full small DataSF DPA misconduct cases/allegations extract: 8,793 rows across 2,063 distinct DPA case numbers. Complaint received dates span 2017-01-06 through 2026-03-29; findings issued dates span 2024-01-02 through 2026-03-30; latest observed data_loaded_at is 2026-05-29T12:10:00.581. Rows now load into agency_oversight_cases as source-labeled DPA allegation context. |
| Government Level | local_police_oversight |
| ID | datasf_dpa_misconduct_cases_b4we_97wx |
| Layer | agency_oversight_context |
| Name | DataSF Police Accountability Misconduct Cases and Allegations |
| Owner | San Francisco Department of Police Accountability / DataSF |
| Profile Status | promoted_full_small_agency_oversight_extract |
| Canonical Records | agency_oversight_case, source_record |
| Caveats | DPA case numbers are not SFSC case numbers and must remain namespaced., DPA findings and public narratives are accountability context, not criminal charges, guilt findings, or court outcomes., Complainant demographic fields are source-labeled context and must not become person identity records., Officer involvement IDs are source identifiers, not officer names. |
| Evidence | artifacts/source-discovery/datasf-catalog-gap-scan.profile.json, artifacts/source-discovery/datasf-catalog-gap-b4we_97wx.view.json, artifacts/source-discovery/datasf-catalog-gap-b4we_97wx.sample.json, artifacts/source-discovery/datasf-catalog-gap-b4we_97wx.count.json, artifacts/source-discovery/datasf-dpa-misconduct-cases.profile.json, data/agency_oversight_raw/datasf-dpa-misconduct-cases-and-allegations.json, data/agency_oversight_raw/datasf-dpa-misconduct-cases-and-allegations.manifest.json, scripts/parse_datasf_dpa_misconduct_cases.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | unique_id, case_number, officer_involvement_id, allegation_id, complaint_received_date, findings_issued_date, incident_location, analysis_neighborhood |
| Known Endpoints | Socrata /resource/b4we-97wx.json |
| Rate Limit Notes | Small weekly Socrata dataset; use checkpointed paging by data_loaded_at plus unique_id and do not call per API request. |
| Source Urls | https://data.sfgov.org/City-Management-and-Ethics/Police-Accountability-Misconduct-Cases-and-Allegat/b4we-97wx, https://data.sfgov.org/resource/b4we-97wx.json |
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/datasf_dpa_misconduct_cases_b4we_97wxJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_dpa_misconduct_cases_b4we_97wx&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON