Home › Sources › datasf_police_incidents_2018_present
DataSF Police Department Incident Reports 2018 to Present
Source ID datasf_police_incidents_2018_present. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_police_incidents_2018_present |
| Name | DataSF Police Department Incident Reports 2018 to Present |
| Owner | San Francisco Police Department / DataSF |
| Layer | incident_context |
| Coverage | Current SFPD incident reports from 2018-01-01 through at least 2026-05-29; live profile counted 1,034,340 rows through 2026-05-28, and the 2026-05-30 bounded sync observed latest data_as_of 2026-05-30 and latest data_loaded_at 2026-05-30. The prototype loads 23 DA-bridged linked rows across 9 incident numbers plus a checkpointed recent-sync slice of 1,000 current incident rows into police_incidents. |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | incident_number, incident_code, incident_date, incident_time, category, description, police_district, latitude, longitude |
| Caveats | Court records usually do not contain incident_number; exact joins usually require SFSC case_number to DA court_number to SFPD incident_number bridge., Incident reports are police context, not charging, prosecution, guilt, or court outcome evidence., Sensitive incident categories require product-level display rules before broad public facets. |
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_police_incidents_2018_present | socrata_dataset | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | operational/open-data refresh |
| Coverage | Current SFPD incident reports from 2018-01-01 through at least 2026-05-29; live profile counted 1,034,340 rows through 2026-05-28, and the 2026-05-30 bounded sync observed latest data_as_of 2026-05-30 and latest data_loaded_at 2026-05-30. The prototype loads 23 DA-bridged linked rows across 9 incident numbers plus a checkpointed recent-sync slice of 1,000 current incident rows into police_incidents. |
| Government Level | local_police |
| ID | datasf_police_incidents_2018_present |
| Layer | incident_context |
| Name | DataSF Police Department Incident Reports 2018 to Present |
| Owner | San Francisco Police Department / DataSF |
| Profile Status | promoted_recent_sfpd_incident_sync_slice |
| Canonical Records | police_incident, place_context, agency_action, source_record |
| Caveats | Court records usually do not contain incident_number; exact joins usually require SFSC case_number to DA court_number to SFPD incident_number bridge., Incident reports are police context, not charging, prosecution, guilt, or court outcome evidence., Sensitive incident categories require product-level display rules before broad public facets. |
| Evidence | official DataSF dataset URL, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.profile.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.view.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.sample.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.profile-query.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.category-counts.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.resolution-counts.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.year-counts.json, artifacts/source-discovery/datasf-police-incidents-current-wg3w-h783.linked-rows.json, artifacts/source-discovery/datasf-catalog-gap-scan.profile.json, data/reference_raw/datasf-police-incident-code-crosswalk.json, data/enrichment_raw/police_incidents.json, data/police_incidents_raw/police_incidents_2018_present.json, data/police_incidents_raw/manifest.json, scripts/sync_datasf_police_incidents.py, scripts/profile_datasf_current_police_incidents.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | incident_number, incident_code, incident_date, incident_time, category, description, police_district, latitude, longitude |
| Known Endpoints | Socrata /resource/wg3w-h783.json |
| Rate Limit Notes | Use Socrata paging with app token for production; maintain checkpoint by data_loaded_at plus row_id. |
| Source Urls | https://data.sfgov.org/Public-Safety/Police-Department-Incident-Reports-2018-to-Present/wg3w-h783 |
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_incidents_2018_presentJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_police_incidents_2018_present&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON