Home › Sources › datasf_sfpd_investigated_hate_crimes
DataSF SFPD Investigated Hate Crimes
Source ID datasf_sfpd_investigated_hate_crimes. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_sfpd_investigated_hate_crimes |
| Name | DataSF SFPD Investigated Hate Crimes |
| Owner | San Francisco Police Department / DataSF |
| Layer | hate_crime_public_safety_context |
| Coverage | SFPD hate-crime incidents reported to California DOJ, 1,813 rows from 2001-01 through 2026-03, latest data_as_of 2026-05-15 and data_loaded_at 2026-05-20. The full small table loads into public_safety_events as hate_crime_incident context. |
| Formats | JSON API, CSV |
| Join keys | record_id, occurence_month, ncic, most_serious_ucr, most_serious_bias, most_serious_bias_type |
| Caveats | Rows are public-safety incident context, not charges, prosecutions, guilt findings, or court outcomes., The dataset includes monthly occurrence buckets, offense/bias labels, and victim/suspect counts, but no names, exact addresses, or coordinates., Use record_id as a possible incident bridge only after matching against DA/SFPD/court source evidence. |
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_investigated_hate_crimes | socrata_full_small_public_safety_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | monthly per source metadata |
| Coverage | SFPD hate-crime incidents reported to California DOJ, 1,813 rows from 2001-01 through 2026-03, latest data_as_of 2026-05-15 and data_loaded_at 2026-05-20. The full small table loads into public_safety_events as hate_crime_incident context. |
| Government Level | local_police |
| ID | datasf_sfpd_investigated_hate_crimes |
| Layer | hate_crime_public_safety_context |
| Name | DataSF SFPD Investigated Hate Crimes |
| Owner | San Francisco Police Department / DataSF |
| Profile Status | promoted_full_small_public_safety_extract |
| Canonical Records | public_safety_event, source_record |
| Caveats | Rows are public-safety incident context, not charges, prosecutions, guilt findings, or court outcomes., The dataset includes monthly occurrence buckets, offense/bias labels, and victim/suspect counts, but no names, exact addresses, or coordinates., Use record_id as a possible incident bridge only after matching against DA/SFPD/court source evidence. |
| Evidence | artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes.profile.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.view.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.sample.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.rows.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.profile-query.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.bias-type-counts.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.offense-counts.json, artifacts/source-discovery/datasf-sfpd-investigated-hate-crimes-huqr-9p9x.monthly-counts.json, scripts/profile_datasf_hate_crime_context.py |
| Formats | JSON API, CSV |
| Join Keys | record_id, occurence_month, ncic, most_serious_ucr, most_serious_bias, most_serious_bias_type |
| Known Endpoints | Socrata /resource/huqr-9p9x.json |
| Rate Limit Notes | The full table is small enough for scheduled complete Socrata refreshes keyed by record_id and data_loaded_at., Do not call upstream live per API request. |
| Source Urls | https://data.sfgov.org/Public-Safety/Police-Department-Investigated-Hate-Crimes/huqr-9p9x, https://data.sfgov.org/resource/huqr-9p9x.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_investigated_hate_crimesJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_sfpd_investigated_hate_crimes&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON