Home › Sources › datasf_traffic_crash_context
DataSF Traffic Crash Injury, Party, and Fatality Context
Source ID datasf_traffic_crash_context. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_traffic_crash_context |
| Name | DataSF Traffic Crash Injury, Party, and Fatality Context |
| Owner | DataSF / San Francisco Municipal Transportation Agency |
| Layer | traffic_crash_context |
| Coverage | Official crash context with 64,694 injury crash rows from 2005-01-01T01:15:00 through 2026-02-28T22:42:00, 136,178 crash-party rows over the same window, and 359 fatal-crash rows from 2014-01-04T18:20:00 through 2026-03-27T07:43:00. All three profile probes observed data_loaded_at on 2026-05-01; the prototype now materializes 25-row bounded samples for injury collisions, crash parties, and fatal crashes into public_safety_events. |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | case_id_pkey, case_id_fkey, unique_id, party_number_ckey, collision_datetime, death_datetime, primary_rd, secondary_rd, location, analysis_neighborhood, police_district, point, vz_pcf_code, oaf_violation_code |
| Caveats | Relevant mostly for DUI, vehicular injury, vehicular manslaughter, hit-and-run, civil personal-injury, and neighborhood/block context., Crash-party fields include age, sex, race, sobriety, fault, and injury/fatality counts; keep source-labeled and do not infer named court-party identity., Traffic crash context is not a court outcome unless joined through a direct incident, citation, DA, or court identifier. |
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_traffic_crash_context | socrata_dataset_group_profile | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | open-data refresh; live profile observed latest data_loaded_at values on 2026-05-01 |
| Coverage | Official crash context with 64,694 injury crash rows from 2005-01-01T01:15:00 through 2026-02-28T22:42:00, 136,178 crash-party rows over the same window, and 359 fatal-crash rows from 2014-01-04T18:20:00 through 2026-03-27T07:43:00. All three profile probes observed data_loaded_at on 2026-05-01; the prototype now materializes 25-row bounded samples for injury collisions, crash parties, and fatal crashes into public_safety_events. |
| Government Level | local_transportation_public_safety |
| ID | datasf_traffic_crash_context |
| Layer | traffic_crash_context |
| Name | DataSF Traffic Crash Injury, Party, and Fatality Context |
| Owner | DataSF / San Francisco Municipal Transportation Agency |
| Profile Status | promoted_bounded_traffic_crash_context_extract |
| Canonical Records | traffic_collision, traffic_collision_party, traffic_fatality, public_safety_event, place_context, source_record |
| Caveats | Relevant mostly for DUI, vehicular injury, vehicular manslaughter, hit-and-run, civil personal-injury, and neighborhood/block context., Crash-party fields include age, sex, race, sobriety, fault, and injury/fatality counts; keep source-labeled and do not infer named court-party identity., Traffic crash context is not a court outcome unless joined through a direct incident, citation, DA, or court identifier. |
| Evidence | artifacts/source-discovery/datasf-traffic-crash-context.profile.json, artifacts/source-discovery/datasf-traffic-injury-crashes-ubvf-ztfx.view.json, artifacts/source-discovery/datasf-traffic-injury-crashes-ubvf-ztfx.sample.json, artifacts/source-discovery/datasf-traffic-crash-parties-8gtc-pjc6.view.json, artifacts/source-discovery/datasf-traffic-crash-parties-8gtc-pjc6.sample.json, artifacts/source-discovery/datasf-traffic-fatal-crashes-dau3-4s8f.view.json, artifacts/source-discovery/datasf-traffic-fatal-crashes-dau3-4s8f.sample.json, scripts/profile_datasf_traffic_crash_context.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | case_id_pkey, case_id_fkey, unique_id, party_number_ckey, collision_datetime, death_datetime, primary_rd, secondary_rd, location, analysis_neighborhood, police_district, point, vz_pcf_code, oaf_violation_code |
| Known Endpoints | Socrata /resource/ubvf-ztfx.json, Socrata /resource/8gtc-pjc6.json, Socrata /resource/dau3-4s8f.json |
| Rate Limit Notes | Use checkpointed Socrata paging with data_loaded_at and collision_datetime checkpoints; do not query live per user request., Crash-party rows are materialized only as a bounded, policy-gated lane and are excluded from default public_safety_events listings unless family=traffic_collision_party is requested. |
| Source Urls | https://data.sfgov.org/Public-Safety/Traffic-Crashes-Resulting-in-Injury/ubvf-ztfx, https://data.sfgov.org/Public-Safety/Traffic-Crashes-Resulting-in-Injury-Parties-Involved/8gtc-pjc6, https://data.sfgov.org/Public-Safety/Traffic-Crashes-Resulting-in-Fatality/dau3-4s8f, https://data.sfgov.org/resource/ubvf-ztfx.json, https://data.sfgov.org/resource/8gtc-pjc6.json, https://data.sfgov.org/resource/dau3-4s8f.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_traffic_crash_contextJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_traffic_crash_context&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON