bluedoor data·SF Superior Court API·bluedoor.sh ↗

HomeSourcesdatasf_police_stop_data

DataSF Police Department Stop Data

Source ID datasf_police_stop_data. Use source caveats and join keys before treating context records as court facts.

Source overview

Source IDdatasf_police_stop_data
NameDataSF Police Department Stop Data
OwnerSan Francisco Police Department / DataSF
Layerstop_enforcement_context
CoverageRIPA-style stop records from 2018-07-01 through 2026-03-31 in profile query; the prototype now loads a checkpointed 1,000-row recent sync slice from 2026-03-22 through 2026-03-31 plus the original 5-row bounded sample into police_stops.
FormatsJSON API, CSV, GeoJSON
Join keysdoj_record_id, lea_record_id, agency_ori, stop_datetime, location, citation_off_statute, cust_arrest_off_statute
CaveatsContains perceived-demographic variables; expose as source-labeled aggregate/context data, not identity facts.

Linked cases

0 matching cases for this source filter.

No matching cases.

Source artifacts

Artifact IDSource IDArtifact TypePathURLCaptured At
-datasf_police_stop_datasocrata_dataset---

Full source record

Access Modesocrata_api
Cadenceopen-data refresh; data_as_of observed 2026-05-28
CoverageRIPA-style stop records from 2018-07-01 through 2026-03-31 in profile query; the prototype now loads a checkpointed 1,000-row recent sync slice from 2026-03-22 through 2026-03-31 plus the original 5-row bounded sample into police_stops.
Government Levellocal_police
IDdatasf_police_stop_data
Layerstop_enforcement_context
NameDataSF Police Department Stop Data
OwnerSan Francisco Police Department / DataSF
Profile Statuspromoted_recent_police_stop_sync_slice
Canonical Recordspolice_stop, agency_action, place_context, source_record
CaveatsContains perceived-demographic variables; expose as source-labeled aggregate/context data, not identity facts.
Evidenceartifacts/source-discovery/datasf-police-stops-ripa.profile.json, artifacts/source-discovery/datasf-police-stops-ubqf-aqzw.view.json, artifacts/source-discovery/datasf-police-stops-ubqf-aqzw.sample.json, artifacts/source-discovery/datasf-police-stops-ubqf-aqzw.profile-query.json, data/police_stops_raw/police_stops.json, data/police_stops_raw/manifest.json, scripts/sync_datasf_police_stops.py
FormatsJSON API, CSV, GeoJSON
Join Keysdoj_record_id, lea_record_id, agency_ori, stop_datetime, location, citation_off_statute, cust_arrest_off_statute
Known EndpointsSocrata /resource/ubqf-aqzw.json
Rate Limit NotesUse Socrata paging/checkpoints; avoid per-request live joins.
Source Urlshttps://data.sfgov.org/Public-Safety/Police-Department-Stop-Data/ubqf-aqzw
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_police_stop_dataJSON
GET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_police_stop_data&division=criminal&limit=25&include_facets=trueJSON
GET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON