San Francisco Traffic Crash Injury Victims, 2013 to Present

Victims injured in traffic crashes in San Francisco, sourced from police reports and medical examiner records. Data is aggregated quarterly and includes injury severity, with records from 2013 to the present. The dataset is maintained by the San Francisco Department of Public Health, Police Department, and Municipal Transportation Agency.

Use Cases

• Analyze injury severity trends over time based on quarterly aggregation.
• Model geographic patterns of traffic injuries based on geocoded crash locations.
• Study relational data structures between crashes, parties, and victims mentioned in the description.
• Assess the impact of Vision Zero protocols on fatality and injury rates.

Strengths

• Data is sourced from authoritative systems including SWITRS, police reports, and the Office of the Chief Medical Examiner.
• Relational structure connects crash, party, and victim information for detailed analysis.
• Quarterly update process with public release approximately one month after each quarter.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Highway crashes and complex intersections are excluded or simplified in mapping.
• Row count is unknown, which may limit suitability assessment.

Provenance

Source

City of San Francisco (SFDPH, SFPD, SFMTA)

Collection Method

Extracted from California Highway Patrol 555 Crash Reports, de-identified, geocoded, and loaded into TransBASE.

Time Range

Data from years prior to 2013 to present, with specific systems (SWITRS, Crossroads, Interim Collision System) used for different periods.

Freshness

Last updated 2026-03-08 03:00:39.224132; freshness should be verified.

Geography

City of San Francisco, excluding highways.