Home › Sources › sf_dpa_policing_complaint_reports
San Francisco DPA Policing Complaint Dashboard and Reports
Source ID sf_dpa_policing_complaint_reports. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sf_dpa_policing_complaint_reports |
| Name | San Francisco DPA Policing Complaint Dashboard and Reports |
| Owner | San Francisco Department of Police Accountability |
| Layer | agency_oversight_aggregate_context |
| Coverage | Official DPA report pages and three public PowerBI Government embeds covering aggregate complaint cases opened/closed/sustained, allegation categories, and finding categories. The bounded parser promotes 37 aggregate metric rows from saved querydata for 2019-2025. |
| Formats | HTML, PDF, PowerBI querydata, JSON |
| Join keys | year, allegation_category, finding_category, metric_name |
| Caveats | Aggregate police-accountability context only., Do not merge DPA aggregate metrics into individual court case facts, officer findings, or party records. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sf_dpa_policing_complaint_reports | public_powerbi_metric_extract | - | - | - |
Full source record
| Access Mode | public_html_reports_dashboard_powerbi |
| Cadence | dashboard/report updates |
| Coverage | Official DPA report pages and three public PowerBI Government embeds covering aggregate complaint cases opened/closed/sustained, allegation categories, and finding categories. The bounded parser promotes 37 aggregate metric rows from saved querydata for 2019-2025. |
| Government Level | local_police_oversight |
| ID | sf_dpa_policing_complaint_reports |
| Layer | agency_oversight_aggregate_context |
| Name | San Francisco DPA Policing Complaint Dashboard and Reports |
| Owner | San Francisco Department of Police Accountability |
| Profile Status | promoted_bounded_powerbi_metric_extract |
| Canonical Records | court_metric, oversight_metric, source_record |
| Caveats | Aggregate police-accountability context only., Do not merge DPA aggregate metrics into individual court case facts, officer findings, or party records. |
| Evidence | artifacts/source-discovery/sf-dpa-reports-page.html, artifacts/source-discovery/sf-dpa-reports-next-data.json, artifacts/source-discovery/sf-dpa-powerbi.profile.json, artifacts/source-discovery/sf-dpa-powerbi-opened-closed-sustained-querydata-response.sample.json, artifacts/source-discovery/sf-dpa-powerbi-allegations-querydata-response.sample.json, artifacts/source-discovery/sf-dpa-powerbi-outcomes-querydata-response.sample.json, data/court_metrics_raw/sf-dpa-powerbi-metrics.json, data/court_metrics_raw/sf-dpa-powerbi-metrics.manifest.json, scripts/parse_dpa_powerbi_metrics.py |
| Formats | HTML, PDF, PowerBI querydata, JSON |
| Join Keys | year, allegation_category, finding_category, metric_name |
| Known Endpoints | PowerBI Government modelsAndExploration, PowerBI Government conceptualschema, PowerBI Government querydata?synchronous=true |
| Rate Limit Notes | Use pinned PowerBI resource keys/model IDs/query payloads for scheduled aggregate sync; do not call PowerBI per API request., Prefer official CSV/API if DPA publishes one. |
| Source Urls | https://www.sf.gov/information--reports-policing-complaints, https://www.sf.gov/data--dpa-dashboard |
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/sf_dpa_policing_complaint_reportsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sf_dpa_policing_complaint_reports&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON