There are three main data tables providing crash data to Crash Query. The Crash, Vehicle, and People data sources.

Because each of these data tables contains unique fields of data, a list of the data fields associated with each data table is provided below.

To find out more about how these unique data sources can be displayed in Crash Query, see the UDOT Crash Query - Accessing Crash Data From Multiple Data Tables article.

A complete explanation of each field can be found in the Utah Crash Report Data Dictionary.

Adverse Roadway Surf Condition

Aggressive Driving Involved

Animal Involved

Area Type

City

Collision with Fixed Object

Commercial Vehicle Involved

County

Countermeasures

Crash Attributes

Crash Date & Time (Hour of Day)

Crash Date & Time (Day of Week)

Crash Date & Time (Day of Month)

Crash Date & Time (Month of Year)

Crash Date & Time (Year)

Crash ID

Disregard Traffic Control Device Involved

Distracted Driving Involved

Domestic Animal Involved

Drowsy Driving Involved

DUI Involved

Exit Number

First Harmful Event of Crash

Functional Class

Full Route Name

Heavy Truck Involved

Holiday Crash

Horizontal Alignment

Hundred Deadliest Days

Intersection Involved

Interstate Highway

Left or U-Turn Involved

Light Condition

Location of First Harmful Event of Crash

Main Road Name

Manner of Collision

Metro Area

Milepoint

Motorcycle Involved

MPO

Near-School Crashes

Number of Fatalities

Older Driver Involved

Overturn/Rollover Involved

Pedestrian Involved

Ramp ID

Region

Right Turn Involved

Roadway Contributing Circumstances

Roadway Departure Involved

Roadway Geometry Involved

Roadway Junction Type

Roadway Surface Condition

Route Direction

Route Type

Severity

Speed Involved

Teenage Driver Involved

Train Involved

Transit Vehicle Involved

UDOT Crash Summary

Unrestrained Involved

Vertical Alignment

Weather Condition

Work Zone Involved

Wrong Way Driving Involved

All Events

Crash Date & Time (Hour of Day)

Crash Date & Time (Day of Week)

Crash Date & Time (Day of Month)

Crash Date & Time (Month of Year)

Crash Date & Time (Year)

Estimated Travel Speed

Event Sequence 1, 2, 3, & 4

Most Harmful Event

Motor Vehicle Body Type

Roadway Description

Traffic Control Device

Travel Direction

Vehicle Maneuver

Vehicle Number

Age Group

Age

Air Bag

Alcohol Drug Suspected

Alcohol Drug Test

Alcohol Drug Test Results

Crash Date & Time (Hour of Day)

Crash Date & Time (Day of Week)

Crash Date & Time (Day of Month)

Crash Date & Time (Month of Year)

Driver Condition

Driver Contributing Circumstances 1

Driver Contributing Circumstances 2

Driver Distraction

Ejection

Ejection Path

Extrication

Injury Area

Injury Cause

Injury Level

Non-Motorist Action

Non-Motorist Contributing Circumstances

Non-Motorist Location

Person Type

Safety Equipment

Seating Position

Sex

Transport By

Restraints Used Properly