Home › Sources › datasf_police_incidents_historical
DataSF Police Department Incident Reports Historical 2003 to May 2018
Source ID datasf_police_incidents_historical. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_police_incidents_historical |
| Name | DataSF Police Department Incident Reports Historical 2003 to May 2018 |
| Owner | San Francisco Police Department / DataSF |
| Layer | incident_context |
| Coverage | Historical SFPD incident records from 2003-01-01 through 2018-05-15; the prototype now loads a checkpointed 1,000-row recent historical slice from 2018-05-09 through 2018-05-15 plus the original 1-row official sample into police_incidents. |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | incidntnum, incident_code, pdid, date, time, category, descript, pddistrict, address, x, y |
| Caveats | Legacy category/descript labels should be preserved alongside any normalized category mapping. |
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_historical | socrata_dataset | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | historical; not updated |
| Coverage | Historical SFPD incident records from 2003-01-01 through 2018-05-15; the prototype now loads a checkpointed 1,000-row recent historical slice from 2018-05-09 through 2018-05-15 plus the original 1-row official sample into police_incidents. |
| Government Level | local_police |
| ID | datasf_police_incidents_historical |
| Layer | incident_context |
| Name | DataSF Police Department Incident Reports Historical 2003 to May 2018 |
| Owner | San Francisco Police Department / DataSF |
| Profile Status | promoted_recent_historical_sfpd_sync_slice |
| Canonical Records | incident, place_context, agency_action, source_record |
| Caveats | Legacy category/descript labels should be preserved alongside any normalized category mapping. |
| Evidence | artifacts/source-discovery/datasf-police-incidents-historical-tmnf-yvry.view.json, artifacts/source-discovery/datasf-police-incidents-historical-tmnf-yvry.sample.json, artifacts/source-discovery/datasf-aggregate-profile-stats.json, artifacts/source-discovery/datasf-catalog-gap-scan.profile.json, data/reference_raw/datasf-police-incident-code-crosswalk.json, data/police_incidents_historical_raw/police_incidents_historical.json, data/police_incidents_historical_raw/manifest.json, scripts/sync_datasf_historical_police_incidents.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | incidntnum, incident_code, pdid, date, time, category, descript, pddistrict, address, x, y |
| Known Endpoints | Socrata /resource/tmnf-yvry.json |
| Rate Limit Notes | Use Socrata paging with checkpointed offsets or row-id/date partitions; historical dataset is large but stable. |
| Source Urls | https://data.sfgov.org/Public-Safety/Police-Department-Incident-Reports-Historical-2003-to-May-2018/tmnf-yvry |
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_historicalJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_police_incidents_historical&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON