Home › Sources › datasf_sfpd_victim_suspect_demographics_cd9v_umhr
DataSF Police Department Reported Victim and Suspect Demographic Data
Source ID datasf_sfpd_victim_suspect_demographics_cd9v_umhr. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_sfpd_victim_suspect_demographics_cd9v_umhr |
| Name | DataSF Police Department Reported Victim and Suspect Demographic Data |
| Owner | San Francisco Police Department / DataSF |
| Layer | aggregate_public_safety_demographic_context |
| Coverage | DataSF SFPD reported victim/suspect demographic dataset has 300,835 aggregate source rows from 2013-01-01 through 2026-01-01, latest data_as_of 2026-05-28 and data_loaded_at 2026-05-28. The prototype promotes 15,944 grouped metric rows covering category/role/quarter, recent district/category/role, recent demographic mix, and hate-crime bias aggregates into court_metrics. |
| Formats | JSON API, CSV |
| Join keys | quarter_year, person_crime_category, person_type, district, district_description, person_race_description, person_sex_description, age_range, mostseriousbias, mostseriousbiastype |
| Caveats | Aggregate context only; the source intentionally contains no individual incident, victim, suspect, defendant, or witness records., Do not join these metrics to individual court cases or people., Demographic dimensions require source labels and small-cell suppression policy if expanded beyond already public aggregate rows. |
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_sfpd_victim_suspect_demographics_cd9v_umhr | socrata_bounded_aggregate_metric_extract | - | - | - |
Full source record
| Access Mode | socrata_aggregate_group_queries |
| Cadence | quarterly target refresh |
| Coverage | DataSF SFPD reported victim/suspect demographic dataset has 300,835 aggregate source rows from 2013-01-01 through 2026-01-01, latest data_as_of 2026-05-28 and data_loaded_at 2026-05-28. The prototype promotes 15,944 grouped metric rows covering category/role/quarter, recent district/category/role, recent demographic mix, and hate-crime bias aggregates into court_metrics. |
| Government Level | local_police |
| ID | datasf_sfpd_victim_suspect_demographics_cd9v_umhr |
| Layer | aggregate_public_safety_demographic_context |
| Name | DataSF Police Department Reported Victim and Suspect Demographic Data |
| Owner | San Francisco Police Department / DataSF |
| Profile Status | promoted_bounded_aggregate_metric_extract |
| Canonical Records | court_metric, source_record |
| Caveats | Aggregate context only; the source intentionally contains no individual incident, victim, suspect, defendant, or witness records., Do not join these metrics to individual court cases or people., Demographic dimensions require source labels and small-cell suppression policy if expanded beyond already public aggregate rows. |
| Evidence | artifacts/source-discovery/datasf-catalog-gap-scan.profile.json, artifacts/source-discovery/datasf-catalog-gap-cd9v_umhr.view.json, artifacts/source-discovery/datasf-catalog-gap-cd9v_umhr.sample.json, artifacts/source-discovery/datasf-catalog-gap-cd9v_umhr.count.json, artifacts/source-discovery/datasf-sfpd-victim-suspect-demographics.profile.json, data/court_metrics_raw/datasf-sfpd-victim-suspect-demographic-metrics.json, data/court_metrics_raw/datasf-sfpd-victim-suspect-demographic-metrics.manifest.json, scripts/profile_datasf_victim_suspect_demographics.py |
| Formats | JSON API, CSV |
| Join Keys | quarter_year, person_crime_category, person_type, district, district_description, person_race_description, person_sex_description, age_range, mostseriousbias, mostseriousbiastype |
| Known Endpoints | Socrata /resource/cd9v-umhr.json |
| Rate Limit Notes | Use quarterly Socrata group queries or a full aggregate source-row sync with app token; do not call per API request. |
| Source Urls | https://data.sfgov.org/Public-Safety/Police-Department-Reported-Victim-and-Suspect-Demog/cd9v-umhr, https://data.sfgov.org/resource/cd9v-umhr.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_sfpd_victim_suspect_demographics_cd9v_umhrJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_sfpd_victim_suspect_demographics_cd9v_umhr&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON