Traffic Crashes — Crashes

Crash rows keyed by crash_record_id directly emit reporting-officer determinations for trafficway type, street alignment, intersection relation, traffic-control device and condition, active work-zone status and type, lighting, weather, roadway-surface condition, and road defect. These are crash-recorded roadway and environmental circumstances, not an inferred weather reconstruction. Retain CPD/Chicago scope, coverage boundary, and extraction/metadata timestamp because rows can be amended and no row-level release vintage or code-list version is exposed.

Anonymous crash-grain SODA/full-file rows identify each event by crash_record_id and emit the officer-entered crash date/time, street and coordinates, first_crash_type, crash_type, and num_units. This establishes recorded occurrence, location, first-collision/manner classification, and unit count for CPD-jurisdiction Chicago crashes. It does not emit involved-unit classes or a detailed ordered event sequence; retain crash_record_id, the partial-2015/citywide-from-September-2017 coverage boundary, and the extraction/metadata timestamp because no row-level release-vintage or coded-field-version field is exposed.