« Table Of Contents
Overview
Record Layout
Data Element Definitions
County Codes [New Window]
State Abbreviations [New Window]
|
CRASH MASTER TABLE
|
CRASH_ID
|
CRASH ID
|
8
|
|
|
|---|
|
REPORT_STATE
|
REPORT STATE
|
2
|
A
|
See Appendix A
[Opens in New Window]
|
|---|
|
REPORT_NUMBER
|
REPORT NUMBER
|
12
|
A
|
State Abbreviation + 10 characters. No Blank spaces.
|
|---|
|
REPORT_DATE
|
REPORT DATE
|
8
|
N
|
CCYYMMDD
|
|---|
|
REPORT_TIME
|
REPORT TIME
|
4
|
N
|
|
|---|
|
REPORT_SEQ_NO
|
CRASH SEQUENCE NUMBER
|
2
|
N
|
|
|---|
|
DOT_NUMBER
|
CENSUS NUMBER
|
8
|
A
|
|
|---|
|
CI_STATUS_CD
|
STATUS CODE
|
1
|
A
|
U=Initial Upload
T=Sent to Census Search
C=Complete
N=Non-Match
H=FMCSA Hold
I=Intrastate
|
|---|
|
FINAL_STATUS_DATE
|
FINAL STATUS DATE
|
8
|
N
|
|
|---|
|
LOCATION
|
LOCATION
|
50
|
A/N
|
|
|---|
|
CITY_CODE
|
CITY CODE
|
5
|
A
|
Can be blank (See PIPS PUB 55-22)
|
|---|
|
CITY
|
CITY
|
25
|
A
|
|
|---|
|
STATE
|
STATE
|
2
|
A
|
|
|---|
|
COUNTY_CODE
|
COUNTY CODE
|
3
|
N
|
|
|---|
|
TRUCK_BUS_IND
|
TRUCK/BUS
|
1
|
A
|
T=Truck, B=Bus
|
|---|
|
TRAFFICWAY_ID
|
ROAD TRAFFIC WAY
|
8
|
A
|
1=Two-way, not divided
2=Two-way, divided, unprotected median
3=Two-way, divided, positive median barrier
4=One-way, not divided
8=Not reported
9=Unknown
|
|---|
|
ACCESS_CONTROL_ID
|
ROAD ACCESS CONTROL
|
8
|
A
|
1=Full Access Control
2=Partial Access Control
3=No Access Control
|
|---|
|
ROAD_SURFACE_CONDITION_ID
|
ROAD SURFACE CONDITION
|
8
|
A
|
1=Dry
2=Wet
3=Water (standing, moving)
4=Snow
5=Slush
6=Ice
7=Sand, Mud, Dirt, Oil or Gravel
8=Other
9=Unknown or Blank
|
|---|
|
AXLES
|
NUMBER OF AXLES
|
2
|
A
|
|
|---|
|
CARGO_BODY_TYPE_ID
|
CARGO BODY TYPE
|
8
|
A
|
1=Bus (seats for 9-15 people, including driver)
2=Bus (seats more than 15 people, including driver)
3=Van/Enclosed Box
4=Cargo Tank
5=Flatbed
6=Dump
7=Concrete Mixer
8=Auto Transporter
9=Garbage/Refuse
10=Grain, chips, gravel
11=Pole
12=Not applicable
13=Intermodal
14=Logging
15=Vehicle Towing another Vehicle
98=Other
|
|---|
|
GVWR
|
GROSS VEHICLE WEIGHT RANGE
|
6
|
A
|
1= 0 - 10,000
2= 10,001 - 26,000
3= 26,001 and over or blank
|
|---|
|
GVW_RATING_ID
|
GROSS VEHICLE WEIGHT RATING ID
|
8
|
A
|
|
|---|
|
VEHICLE_IDENTIFICATION_NUMBER
|
VEHICLE IDENTIFICATION NUMBER (VIN)
|
17
|
A
|
|
|---|
|
VEHICLE_LICENSE_NUMBER
|
VEHICLE LICENSE NUMBER
|
9
|
A
|
|
|---|
|
VEHICLE_LIC_STATE
|
VEHICLE LICENSE STATE
|
2
|
A
|
|
|---|
|
VEHICLE_HAZMAT_PLACARD
|
VEHICLE HAZMAT PLACARD
|
1
|
A
|
Y or N
|
|---|
|
VEHICLE_HAZMAT_NUMBER
|
HAZARDOUS MATERIALS4-DIGIT NUMBER
|
4
|
A
|
0001-9999 (Reference 49CFR-172.336 and 172. 101 Hazardous Materials Table)
|
|---|
|
VEHICLE_HAZMAT_MATERIAL
|
HAZARDOUS MATERIALS NAME
|
17
|
A
|
|
|---|
|
VEHICLE_HAZMAT_CLASS_ID
|
HAZARDOUS MATERIALS CLASS 1-DIGIT NUMBER
|
8
|
A
|
1=Explosives
2=Gases-Compressed, Dissolved or Refrigerated
3=Flammable Liquids
4=Flammable Solids-Combustible, Water Reactive
5=Oxidizing Substances-Organic Peroxides
6=Poisonous (Toxic) and Infectious Substances
7=Radioactive Material
8=Corrosives
9=Miscellaneous Dangerous Goods or Blank
|
|---|
|
CENSUS_SOURCE_ID
|
CENSUS SOURCE
|
8
|
A
|
Blank = Uploaded and not changed
1 = matched using Matchware
2 = Manual Census Search
3 = Matching Algorithm
4 = Pen-based (not used on crashes)
5 = SafetyNet Uploaded and not changed
|
|---|
|
WEATHER_CONDITION_ID
|
WEATHER CONDITION
|
8
|
A
|
1=No Adverse Condition
2=Rain
3=Sleet, Hail
4=Snow
5=Fog
6=Blowing Sand, Soil, Dirt, or Snow
7=Severe Crosswinds
8=Other
9=Unknown or Blank
|
|---|
|
VEHICLE_CONFIGURATION_ID
|
VEHICLE CONFIGURATION
|
8
|
A
|
1- Passenger Car (Only if Vehicle displays HM Placard)
2- Light Truck (Only if Vehicle displays HM Placard)
3- Bus (Seats for 9-15 People, Including Driver)
4- Bus (Seats for > 15 People, Including Driver)
5- Single-Unit Truck (2-Axle, 6-Tire)
6- Single-Unit Truck (3 or More Axles)
7- Truck/Trailer
8- Truck Tractor (Bobtail)
9- Tractor/Semitrailer
10- Tractor/Double
11- Tractor/Triple
99- Unknown Heavy Truck > 10000 lbs, Cannot Classify
|
|---|
|
LIGHT_CONDITION_ID
|
LIGHT CONDITION
|
8
|
A
|
1=Daylight
2=Dark-Not Lighted
3=Dark-Lighted
4=Dark-Unknown Roadway Lighting
5=Dawn
6=Dusk
8=Other
9=Unknown or Blank
|
|---|
|
DRIVER_CONDITION_CODE
|
APPARENT DRIVER CONDITION
|
1
|
A
|
1=Appeared Normal
2=Had Been Drinking
3=Illegal Drug Use
4=Sick
5=Fatigue
6=Asleep
7=Medication
8=Unknown or Blank
|
|---|
|
HAZMAT_RELEASED
|
RELEASE OF HAZARDOUS MATERIALS CARGO
|
1
|
A
|
"Y" or "N"
|
|---|
|
AGENCY
|
REPORTING AGENCY
|
35
|
A
|
|
|---|
|
OFFICER_BADGE
|
OFFICER BADGE NUMBER
|
5
|
A
|
|
|---|
|
VEHICLES_IN_ACCIDENT
|
VEHICLES IN ACCIDENT
|
2
|
N
|
|
|---|
|
FATALITIES
|
NUMBER OF FATALITIES
|
3
|
N
|
|
|---|
|
INJURIES
|
NUMBER OF INJURIES
|
3
|
N
|
|
|---|
|
TOW_AWAY
|
TOW AWAY
|
1
|
A
|
"Y" or "N"
|
|---|
|
FEDERAL_RECORDABLE
|
FEDERALLY RECORDABLE
|
1
|
A
|
"Y" or "N"
|
|---|
|
STATE_RECORDABLE
|
STATE RECORDABLE
|
1
|
A
|
"Y" or "N"
|
|---|
|
SNET_VERSION_NUMBER
|
SAFETYNET VERSION NUMBER
|
10
|
A
|
|
|---|
|
SNET_SEARCH_DATE
|
SAFETYNET SEARCH DATE
|
8
|
A
|
CCYYMMDD
|
|---|
|
SNET_SEQUENCE_ID
|
SAFETYNET SEQUENCE ID
|
10
|
A
|
|
|---|
|
ORIG_REPORT_STATE
|
ORIGINAL REPORT STATE
|
2
|
A
|
|
|---|
|
ORIG_REPORT_NUMBER
|
ORIGINAL REPORT NUMBER
|
12
|
A/N
|
|
|---|
|
ORIG_REPORT_DATE
|
ORIGINAL REPORT DATE
|
8
|
N
|
CCYYMMDD
|
|---|
|
ORIG_REPORT_TIME
|
ORIGINAL REPORT TIME
|
4
|
N
|
|
|---|
|
TRANSACTION_CODE
|
TRANSACTION CODE
|
1
|
A
|
A=Add, or C=Change
|
|---|
|
TRANSACTION_DATE
|
TRANSACTION DATE
|
8
|
A
|
CCYYMMDD
|
|---|
|
UPLOAD_FIRST_BYTE
|
UPLOAD CENSUS FIRST BYTE
|
1
|
A
|
|
|---|
|
UPLOAD_DOT_NUMBER
|
UPLOAD USDOT NUMBER
|
8
|
A
|
|
|---|
|
UPLOAD_SEARCH_INDICATOR
|
UPLOAD SEARCH INDICATOR
|
1
|
A
|
|
|---|
|
UPLOAD_DATE
|
DATE UPLOADED
|
8
|
A
|
CCYYMMDD
|
|---|
|
RELATED FACTOR
|
RELATED FACTORS
|
16
|
A
|
|
|---|
|
FROM_FARS_FLAG
|
FARS FLAG
|
1
|
A
|
'F' or Blank
|
|---|
|
CENSUS_SEARCH_DATE
|
CENSUS SEARCH DATE
|
8
|
A
|
CCYYMMDD
|
|---|
|
ADD_DATE
|
ADD DATE
|
8
|
A
|
CCYYMMDD
|
|---|
|
CHANGE_DATE
|
LAST CHANGE DATE
|
8
|
A
|
CCYYMMDD
|
|---|
|
CHANGE_BY_USER
|
CHANGED BY USER
|
30
|
A/N
|
|
|---|
|
CHANGE_BY_APPL
|
CHANGED BY APPLICATION
|
61
|
A
|
|
|---|
|
SNET_INPYT_DATE
|
SAFETYNET INPUT DATE
|
8
|
N
|
CCYYMMDD
|
|---|
CRASH CARRIER TABLE | Top
|
CRASH_CARRIER_ID
|
CRASH CARRIER ID
|
8
|
N
|
|
|---|
|
CRASH_ID
|
CRASH ID
|
8
|
N
|
|
|---|
|
CARRIER_SOURCE_CODE
|
CARRIER NAME SOURCE
|
1
|
A
|
1=Side of Vehicle
2=Shipping Papers (Truck) or Trip Manifest (Bus)
3=Driver
4=Log Book or Blank
|
|---|
|
CRASH_CARRIER_NAME
|
CARRIER NAME
|
120
|
A
|
|
|---|
|
CRASH_CARRIER_STREET
|
CARRIER ADDRESS/STREET
|
50
|
A
|
|
|---|
|
CRASH_CARRIER_CITY
|
CARRIER ADDRESS/CITY NAME
|
25
|
A
|
|
|---|
|
CRASH_CARRIER_CITY_CODE
|
CARRIER ADDRESS/CITY CODE
|
5
|
A
|
Can be Blank
|
|---|
|
CRASH_CARRIER_STATE
|
CARRIER ADDRESS/STATE
|
2
|
A
|
See Appendix A
[Opens in a New Window]
|
|---|
|
CRASH_CARRIER_ZIP_CODE
|
CARRIER ADDRESS/ZIP CODE
|
10
|
A
|
|
|---|
|
CRASH_COLONIA
|
CARRIER ADDRESS/MEXICAN COLONIA
|
25
|
N/A
|
|
|---|
|
PREFIX
|
PREFIX
|
2
|
A
|
MC, MX, FF
|
|---|
|
DOCKET_NUMBER
|
DOCKET NUMBER
|
8
|
N
|
|
|---|
|
CRASH_CARRIER_INTERSTATE
|
INTERSTATE
|
1
|
N
|
0 = No (Intrastate)
1 = Yes (Interstate)
2 = Non Motor carrier
|
|---|
|
NO_ID_FLAG
|
NO CENSUS NUMBER
|
1
|
A
|
"Y" or "N"
|
|---|
|
STATE_NUMBER
|
STATE CENSUS NUMBER
|
12
|
A/N
|
|
|---|
|
STATE_ISSUING_NUMBER
|
STATE ISSUING STATE CENSUS NUMBER
|
2
|
A
|
See Appendix A
[Opens in New Window]
|
|---|
CRASH EVENT TABLE | Top
|
CRASH_EVENT_ID
|
CRASH EVENT ID
|
8
|
N
|
|
|---|
|
CRASH_ID
|
CRASH ID
|
8
|
N
|
|
|---|
|
SEQ_NO
|
SEQUENCE NUMBER
|
1
|
N
|
|
|---|
|
EVENT_ID
|
EVENT ID
|
8
|
N
|
1 - Non collision ran off road
2 - Non collision jackknife
3 - Non collision overturn (rollover)
4 - Non collision downhill runaway
5 - Non collision cargo loss or shift
6 - Non collision explosion or fire
7 - Non collision separation of units
8 - Non collision cross median/centerline
9 - Non collision equipment failure (brake failure, blown tires, etc.)
10- Non collision other
11- Non collision unknown
12- Collision involving pedestrian
13- Collision involving motor vehicle in transport
14- Collision involving parked motor vehicle
15- Collision involving train
16- Collision involving pedalcycle
17- Collision involving animal
18- Collision involving fixed object
19- Collision with work zone maintenance equipment
20- Collision with other movable object (Substitutes for previous "Collision involving other object")
21- Collision with unknown movable object
98- Other
|
|---|
|
EVENT_OTHER_DESC
|
OTHER DECSRIPTION
|
50
|
A/N
|
|
|---|
CRASH DRIVER TABLE | Top
|
CRASH_DRIVER_ID
|
CRASH DRIVER ID
|
8
|
N
|
|
|---|
|
CRASH_ID
|
CRASH ID
|
8
|
N
|
|
|---|
|
DRIVER_LAST_NAME
|
DRIVER/LAST NAME
|
20
|
A
|
|
|---|
|
DRIVER_FIRST_NAME
|
DRIVER/FIRST NAME
|
20
|
A
|
|
|---|
|
DRIVER _MI
|
DRIVER/MIDDLE INITIAL
|
1
|
A
|
|
|---|
|
DRIVER_DATE_OF_BIRTH
|
DRIVER/DATE OF BIRTH
|
8
|
A
|
CCYYMMDD
|
|---|
|
DRIVER_LICENSE_STATE
|
DRIVER/LICENSE STATE
|
2
|
A
|
|
|---|
|
DRIVER_LICENSE_NUMBER
|
DRIVER/LICENSE NUMBER
|
25
|
A
|
|
|---|
|
VALID_DRIVER_LICENSE_FLAG
|
DRIVER/LICENSE VALID
|
1
|
A
|
Y-Yes N-No
|
|---|
|
DRIVER_LICENSE_CLASS_ID
|
DRIVER/LICENSE CLASS
|
8
|
A
|
Lettrr corresponds to Class-A, B, C, D, M, or blank
|
|---|
|
CITATION_ISSUED_CODE_ID
|
CITATION ISSUED
|
8
|
A
|
Y-Yes, N-No, P-Pending, U-Unknown
|
|---|
|
U.S. DOT Home |
FMCSA Home |
Accessibility |
Feedback |
Privacy Policy