Introduction

The Statewide Integrated Traffic Records System (SWITRS) consists of data collected and maintained by the California Highway Patrol (CHP). SWITRS contains all crashes that were reported to CHP by local and governmental agencies. For more information regarding SWITRS or for detailed summaries by year, please visit the CHP website. You can also download complete datasets and request statistical reports via the I-SWITRS Website provided by CHP.

If you are interested in SWITRS crash rankings of cities or counties without investigating the actual datasets, the California Office of Traffic Safety (OTS) has an excellent resource at: OTS Crash Rankings. Their site allows you to choose a county or city and see crash rankings by total count, vehicle miles travelled, or by average population.


Final vs Provisional

We determine the dataset is final when we process the data after CHP announces the report of the specific year. CHP hasn't released the 2022 SWITRS Annual Report on CHP SWITRS website yet so we say provisional for 2022 and later datasets.


Working with the relational database structure

The data have a hierarchical structure.

  • The CRASH table contains information on each crash, one line per crash. 
  • The PARTY table contains information from all parties involved in the crash, one line per party. Parties are the major players in a traffic crash - drivers, pedestrians, bicyclists, and parked vehicles. The information includes personal descriptors and vehicle descriptors.
  • The VICTIM table contains information about the victims - persons associated with each party.  For example, a motorcyclist and his passenger are each a victim. Injury severity is included in the VICTIM table.

The victims can be thought of as being nested within parties and parties can be thought of as being nested within crashes. Another way to conceptualize the data is to use the entity-relationship model common in relational database management systems. In this data model, CRASH, PARTY, and VICTIM are entities that have very specific relationships to each other. CRASH is a “strong” or “parent” entity because it can exist on its own. PARTY is a “weak” or “child” entity, because it logically depends on an instance of CRASH. In other words, a driver cannot be a party in a crash unless the crash exists and is in the crash table. Likewise, VICTIM is a weak entity, because it depends on PARTY for its existence.

The figure shows an example database with CRASH, PARTY, and VICTIM tables.  The database is tiny – it only contains information on 2 crashes.  CRASH has 3 variables: CASE ID, DAY OF WEEK, and COUNTYPARTY has 4 variables: CASE ID, PARTY NUMBER, PARTY AGE, and VEHICLE MAKER. VICTIM has 7 variables: CASE ID, PARTY NUMBER, VICTIM GENDER, VICTIM AGE, VICTIM ROLE, VICTIM SEATING POSITION, and VICTIM SAFETY EQUIPMENT.

The relationships between each pair of tables are represented below.  It is important to understand the relationships when merging tables.  The rectangles represent data tables; the arrows and accompanying text describe the relationship.  In the CRASH - PARTY relationship, the records are linked with the CASE ID variable and any number of PARTY records can be associated with a crash.  The PARTY - VICTIM relationship tells us that the linkage require two variables, CASE ID and PARTY NUMBER and that any number of victims can be associated with a party.

An important aspect of the relationship between the PARTY and VICTIM tables is that some parties (i.e., drivers, bicyclists, pedestrians) will also appear in the VICTIM table.  Injured parties will appear in the VICTIM table; uninjured parties will not. 

A common way to work with data of this structure is to create a PARTY table or a VICTIM table that has data from all its parents joined to each row.  For example, if you plan to do analyses at the victim-level, you can start with a VICTIM table and join in values from corresponding PARTY and CRASH tables.  In the figure, the CRASH variables and the PARTY variables are joined to the VICTIM table.  Doing so provides a victim-level table that can be summarized (for example, count or sums can be generated), while considering PARTY or CRASH variables.  You must keep in mind that the PARTY and CRASH variable will repeat for as many victims as there are.


Codebook

The SWITRS codebook provides a complete description of all the fields including the variable name and all possible values for the field.

If you want to download a Microsoft Word version of the codebook, please click here.

Last Update: 1/23/2024

New Level of Victim Degree of Injury New

CHP has added three additional classifications of injury status based on the Model Minimum Uniform Crash Criteria (MMUCC) 5th Edition released in 2017. The MMUCC is a standardized method for reporting traffic crashes and the vehicles, persons, and environment involved.

New Victim Degree of InjuryOld Definition of Victim Degree of Injury
5 - Suspected Serious Injury2 - Severe Injury
6 - Suspected Minor Injury3 - Other Visible Injury
7 - Possible Injury4 - Complaint of Pain

For the purpose of analysis across multiple years with old definition (2, 3, and 4), we combined injury status categories using the latest definitions (5, 6 and 7); i.e., all victims coded as "Severe Injury" or "Suspected Serious Injury" are shown as "Suspected Serious Injury" in our tools.

Crash Level

Item Name Variable Name Description Values
Case Id CASE_ID The unique identifier of the crash case(barcode beginning 2002; 19 digit code prior to 2002)
Crash Year ACCIDENT_YEAR The year when the crash occurred
Processing Date PROC_DATE The date that the crash case was last changed (YYYYMMDD)
Jurisdiction JURIS Law enforcement agency that has jurisdiction over the crash. For allied agency, it is a four character subset of the "NCIC number" assigned by the FBI. For the CHP, it is 9 followed by a three-digit area number.
Crash Date COLLISION_DATE The date when the crash occurred (YYYYMMDD)
Crash Time COLLISION_TIME The time when the crash occurred in 24 hour military time. Unknown time is coded as 2500-2559. (24 hour time) Data may appear with no leading zero(s).
Officer Id OFFICER_ID The badge number of the officer who wrote the crash report.
Reporting District REPORTING_DISTRICT Value of the field "reporting district on the crash report.
Day of Week DAY_OF_WEEK The code for the day of the week when the crash occurred
  • 1 - Monday
  • 2 - Tuesday
  • 3 - Wednesday
  • 4 - Thursday
  • 5 - Friday
  • 6 - Saturday
  • 7 - Sunday
CHP Shift CHP_SHIFT CHP shift at the time of the crash
  • 1 - 0600 thru 1359
  • 2 - 1400 thru 2159
  • 3 - 2200 thru 0559
  • 4 - CHP Not Stated
  • 5 - Not CHP
Population POPULATION Deprecated. See notesi.
County City Location CNTY_CITY_LOC The city or unincorporated county where the crash occurred. Data may appear with no leading zero.
Special Condition SPECIAL_COND A computed value. 0 means not private property.
  • 1 - Schoolbus on Public Roadway (CHP Beat or CHP Adm Beat 901)
  • 2 - State University (Also SFIA)
  • 3 - Schoolbus Not on Public Roadway (CHP Adm Beat 903)
  • 4 - Offroad (Unimproved) (CHP Adm Beat 906, 907)
  • 5 - Vista Point or Rest Area (CHP Adm Beat 903) or Scales or Inspection Facility (CHP Com Beat 860-898)
  • 6 - Other Public Access (Improved) (CHP Adm Beat 903)
  • 0 - Not Above
  • - - Not Stated
Beat Type BEAT_TYPE Location of crash based on beat.
  • 1 - CHP State Highway
  • 2 - CHP County RoadLine
  • 3 - CHP County RoadArea
  • 4 - Schoolbus on City Roadway (CHP Adm Beat 901)
  • 5 - Schoolbus not on Public Roadway (CHP Adm Beat 903)
  • 6 - Offroad (Unimproved) (CHP Adm Beat 906, 907)
  • 7 - Vista Point or Rest Area (CHP Adm Beat 903) or Scales or Inspection Facility (CHP Com Beat 860-898)
  • 8 - Other Public Access (Improved) (CHP Adm Beat 903)
  • 0 - Not CHP
CHP Beat Type CHP_BEAT_TYPE Location of crash based on beat.
  • 1 - Interstate
  • 2 - US Highway
  • 3 - State Route
  • 4 - County RoadLine
  • 5 - County RoadArea
  • A - Safety Services Program Beats
  • S - Administrative Beats (900's)
  • 0 - Not CHP
  • Contract City:
  • 6 - US Highway
  • 7 - State Route
  • 8 - County RoadLine
  • 9 - County RoadArea
City Division LAPD CITY_DIVISION_LAPD Deprecated. See notesii.
CHP Beat Class CHP_BEAT_CLASS Location of crash based on beat.
  • 1 - CHP Primary
  • 2 - CHP Other
  • 0 - Not CHP
Beat Number BEAT_NUMBER Beat of the officer who reported the crash.
Primary Rd PRIMARY_RD The name of roadway on which the crash occurred
Secondary Rd SECONDARY_RD The name of the roadway that intersects the primary roadway
Distance DISTANCE Distance of the crash from the intersection with the secondary roadway in feet
Direction DIRECTION Direction of the crash from the intersection with the secondary roadway.
  • N - North
  • E - East
  • S - South
  • W - West
  • - or blank - Not Stated
  • in Intersection
Intersection INTERSECTION A flag that denotes if the crash occurred at the intersection with the secondary roadway
  • Y - Intersection
  • N - Not Intersection
  • Blank - Not stated
Weather 1 WEATHER_1 Weather condition at the time of the crash
  • A - Clear
  • B - Cloudy
  • C - Raining
  • D - Snowing
  • E - Fog
  • F - Other
  • G - Wind
  • - - Not Stated
Weather 2 WEATHER2 Additional weather condition at the time of the crash same as weather 1 above
State Highway Indicator STATE_HWY_IND A flag to indicate whether the crash is on or near a state highway. See notesiii.
  • Y - State Highway
  • N - Not State Highway
  • Blank - Not stated
Caltrans County CALTRANS_COUNTY Deprecated. See notesiv.
Caltrans District CALTRANS_DISTRICT Deprecated. See above.
State Route STATE_ROUTE Deprecated. See above. 0 - Not State Highway
Route Suffix ROUTE_SUFFIX Deprecated. See above.
Postmile Prefix POSTMILE_PREFIX Deprecated. See above.
Postmile POSTMILE Deprecated. See above.
Location Type LOCATION_TYPE Deprecated. See above.
  • H - Highway
  • I - Intersection
  • R - Ramp (or Collector)
  • - or blank - Not State Highway
Ramp Intersection RAMP_INTERSECTION Deprecated. See above.
  • 1 - Ramp Exit, Last 50 Feet
  • 2 - Mid-Ramp
  • 3 - Ramp Entry, First 50 Feet
  • 4 - Not State Highway, Ramp-related, Within 100 Feet
  • 5 - Intersection
  • 6 - Not State Highway, Intersection-related, Within 250 Feet
  • 7 - Highway
  • 8 - Not State Highway
  • - - Not Stated
Side Of Highway SIDE_OF_HWY Code provided by Caltrans Coders; applies to divided highway, based on nominal direction of route; for single vehicle is same as nominal direction of travel, overruled by impact with second vehicle after crossing median
  • N - Northbound
  • S - Southbound
  • E - Eastbound
  • W - Westbound
  • Blank - Not stated/not state highway
Tow Away TOW_AWAY A flag to indicate whether the vehicle was towed away from the crash scene.
  • Y - Yes
  • N - No
Crash Severity COLLISION_SEVERITY The worst injury suffered by any victim in the crash.
  • 1 - Fatal injury
  • 2 - Suspected serious injury or severe injury
  • 3 - Suspected minor injury or visible injury
  • 4 - Possible injury or complaint of pain
  • 0 - No injury, also known as "property damage only" or PDO (PDO crashes not included on TIMS)
Killed victims NUMBER_KILLED Number of killed victims 0 to N for each crash
Injured victims NUMBER_INJURED Number of injured victims 0 to N for each crash
Party Count PARTY_COUNT Number of parties involved in the crash. Note: a vehicle counts as one party regardless of the number of occupants. 1 to N for each crash
Primary Crash Factor PRIMARY_COLL_FACTOR The primary cause of the crash
  • A - (Vehicle) Code Violation
  • B - Other Improper Driving
  • C - Other Than Driver
  • D - Unknown
  • E - Fell Asleep
  • - - Not Stated
PCF Violation Code PCF_CODE_OF_VIOL The law code that was violated and was the primary cause of the crash. Note: Vehicle Code is usually omitted.
  • B - Business and Professions
  • C - Vehicle
  • H - City Health and Safety
  • I - City Ordinance
  • O - County Ordinance
  • P - Penal
  • S - Streets and Highways
  • W - Welfare and Institutions
  • - - Not Stated
PCF Violation Category PCF_VIOL_CATEGORY A value computed from the law section that was given as the primary cause of the crash.
  • 01 - Driving or Bicycling Under the Influence of Alcohol or Drug
  • 02 - Impeding Traffic
  • 03 - Unsafe Speed
  • 04 - Following Too Closely
  • 05 - Wrong Side of Road
  • 06 - Improper Passing
  • 07 - Unsafe Lane Change
  • 08 - Improper Turning
  • 09 - Automobile Right of Way
  • 10 - Pedestrian Right of Way
  • 11 - Pedestrian Violation
  • 12 - Traffic Signals and Signs
  • 13 - Hazardous Parking
  • 14 - Lights
  • 15 - Brakes
  • 16 - Other Equipment
  • 17 - Other Hazardous Violation
  • 18 - Other Than Driver (or Pedestrian)
  • 19 -
  • 20 -
  • 21 - Unsafe Starting or Backing
  • 22 - Other Improper Driving
  • 23 - Pedestrian or "Other" Under the Influence of Alcohol or Drug
  • 24 - Fell Asleep
  • 00 - Unknown
  • - - Not Stated
PCF Violation PCF_VIOLATION The law section given as the primary cause of the crash. The subsection is in the data element pcf_viol_subsection
PCF Violation Subsection PCF_VIOL_SUBSECTION The subsection of the law section given as the primary cause of the crash in the data element pcf_violation Blank if no subsection.
Hit And Run HIT_AND_RUN A flag to indicate the severity of hit -and-run crash. Felony hit-and-run resulted in injury or death to other parties. Misdemeanor hit-and-run did not result in injury or death to other parties.
  • F - Felony
  • M - Misdemeanor
  • N - Not Hit and Run
Type of Crash TYPE_OF_COLLISION The general type of crash as determined by the first injury or damage-causing event.
  • A - Head-On
  • B - Sideswipe
  • C - Rear End
  • D - Broadside
  • E - Hit Object
  • F - Overturned
  • G - Vehicle/Pedestrian
  • H - Other
  • - - Not Stated
Motor Vehicle Involved With MVIW Describes what, in conjunction with a motor vehicle in-transport, produced the first injury or damage-causing event, on or off the road.
  • A - Non-Collision
  • B - Pedestrian
  • C - Other Motor Vehicle
  • D - Motor Vehicle on Other Roadway
  • E - Parked Motor Vehicle
  • F - Train
  • G - Bicycle
  • H - Animal
  • I - Fixed Object
  • J - Other Object
  • 0 - Non-Collision and Additional Object
  • 1 - Pedestrian and Additional Object
  • 2 - Other Motor Vehicle and Additional Object
  • 3 - Motor Vehicle on Other Roadway and Additional Object
  • 4 - Parked Motor Vehicle and Additional Object
  • 5 - Train and Additional Object
  • 6 - Bicycle and Additional Object
  • 7 - Animal and Additional Object
  • 8 - Fixed Object and Additional Object
  • 9 - Other Object and Additional Object
  • - - Not Stated
Ped Action PED_ACTION The action just prior to the crash of the first pedestrian injured or otherwise involved.
  • A - No Pedestrian Involved
  • B - Crossing in Crosswalk at Intersection
  • C - Crossing in Crosswalk Not at Intersection
  • D - Crossing Not in Crosswalk
  • E - In Road, Including Shoulder
  • F - Not in Road
  • G - Approaching/Leaving School Bus
  • - - Not Stated
Road Surface ROAD_SURFACE Roadway surface condition at the time of the crash in the traffic lane(s) involved.
  • A - Dry
  • B - Wet
  • C - Snowy or Icy
  • D - Slippery (Muddy, Oily, etc.)
  • - - Not Stated
Road Condition 1 ROAD_COND_1 Roadway condition at the time of the crash in the traffic lane(s) involved.
  • A - Holes, Deep Ruts
  • B - Loose Material on Roadway
  • C - Obstruction on Roadway
  • D - Construction or Repair Zone
  • E - Reduced Roadway Width
  • F - Flooded
  • G - Other
  • H - No Unusual Condition
  • - - Not Stated
Road Condition 2 ROAD_COND_2 Second roadway condition at the time of the crash in the traffic lane(s) involved. same as road condition 1 above
Lighting LIGHTING Lighting conditions at the crash location and the time of the crash.
  • A - Daylight
  • B - Dusk - Dawn
  • C - Dark - Street Lights
  • D - Dark - No Street Lights
  • E - Dark - Street Lights Not Functioning
  • - - Not Stated
Control Device CONTROL_DEVICE Presence and condition of crash related traffic control devices at the time of the crash. Control devices include regulatory, warning, and construction signs. This excludes striping and officers or other persons directing traffic.
  • A - Functioning
  • B - Not Functioning
  • C - Obscured
  • D - None
  • - - Not Stated
CHP RoadType CHP_ROAD_TYPE Deprecated. See notesv.
Pedestrian Crash PEDESTRIAN_ACCIDENT Indicates whether the crash involved a pedestrian Y or blank
Bicycle Crash BICYCLE_ACCIDENT Indicates whether the crash involved a bicycle Y or blank
Motorcycle Crash MOTORCYCLE_ACCIDENT Indicates whether the crash involved a motorcycle Y or blank
Truck Crash TRUCK_ACCIDENT Indicates whether the crash involved a big truck Y or blank
Not Private Property NOT_PRIVATE_PROPERTY Y indicates that the crash did not occur on private property Y or blank
Alcohol Involved ALCOHOL_INVOLVED Indicates whether the crash involved a party that had been drinking. Note: a passenger does not count as a party. Y or blank
Statewide Vehicle Type At Fault STWD_VEHTYPE_AT_FAULT Indicates the Statewide Vehicle Type of the party who is at fault see Party folder Statewide Vehicle Type item
CHP Vehicle Type At Fault CHP_VEHTYPE_AT_FAULT indicates the CHP Vehicle Type of the party who is at fault see Party folder CHP Vehicle Type Towing item
Severe Injury count COUNT_SEVERE_INJ Number of victims in the crash with suspected serious injury or severe injury 0 to N for each crash
Other Visible Injury count COUNT_VISIBLE_INJ Number of victims in the crash with suspected minor injury or visible injury 0 to N for each crash
Complaint of Pain Injury count COUNT_COMPLAINT_PAIN Number of victims in the crash with possible injury or complaint of pain 0 to N for each crash
Pedestrian Killed count COUNT_PED_KILLED Number of killed pedestrian victims 0 or 1 for each crash
Pedestrian Injured count COUNT_PED_INJURED Number of injured pedestrian victims 0 or 1 for each crash
Bicyclist Killed count COUNT_BICYCLIST_KILLED Number of killed bicyclists 0 to N for each crash
Bicyclist Injured count COUNT_BICYCLIST_INJURED Number of injured bicyclists 0 to N for each crash
Motorcyclist Killed count COUNT_MC_KILLED Number of killed motorcyclists 0 to N for each crash
Motorcyclist Injured count COUNT_MC_INJURED Number of injured motorcyclists 0 to N for each crash
Primary Ramp PRIMARY_RAMP A description of the ramp, if any, on primary roadway. This value is computed by the key operator from information on the crash report.
  • NO-NB On Ramp
  • NF-NB Off Ramp
  • SO-SB On Ramp
  • SF-SB Off Ramp
  • EO-EB On Ramp
  • EF-EB Off Ramp
  • WO-WB On Ramp
  • WF-WB Off Ramp
  • To/From Transition/Collector/Connector
Secondary Ramp SECONDARY_RAMP A description of the ramp, if any, on secondary roadway. This value is computed by the key operator from information on the crash report. Same as primary_ramp
CHP generated GPS latitude coordinate LATITUDE Latitude of the crash location in decimal degrees. The decimal point is included. LATITUDE and LONGITUDE are from the crash report.
CHP generated GPS longitude coordinate LONGITUDE Longitude of the crash location in decimal degrees. The decimal point is included. There is no minus sign. The longitude is understood to be west of meridian. LATITUDE and LONGITUDE are from the crash report.
Local Report Number local_report_number The report number assigned by the reporting agency to the crash report
X Coordinate Location POINT_X The longitude of the geocoded location; uses the World Geodetic System from 1984 (WGS84). POINT_X and POINT_Y are generated using the geocoding process by UC Berkeley SafeTREC
Y Coordinate Location POINT_Y The latitude of the geocoded location; uses the World Geodetic System from 1984 (WGS84). POINT_X and POINT_Y are generated using the geocoding process by UC Berkeley SafeTREC.
City CITY
County COUNTY

Party Level

Item Name Variable Name Description Values
Case Id CASE_ID The unique identifier of the crash case
Party Number PARTY_NUMBER A number that together with the case_id uniquely identifies a party in a crash. 1 to 999
Party Type PARTY_TYPE Involved party type
  • 1 - Driver (including Hit and Run)
  • 2 - Pedestrian
  • 3 - Parked Vehicle
  • 4 - Bicyclist
  • 5 - Other
  • 6 - Operator
  • - - Not Stated
At Fault AT_FAULT Indicates whether the party was at fault in the crash
  • Y - Yes
  • N - No
  • - or blank - Not Stated
Party Sex PARTY_SEX The gender of the party
  • M - Male
  • F - Female
  • X - Nonbinary
  • - - Not Stated
Party Age PARTY_AGE The age of the party at the time of the crash 0 to 125+ (998=UNKNOWN)
Party Sobriety PARTY_SOBRIETY The state of sobriety of the party
  • A - Had Not Been Drinking
  • B - Had Been Drinking, Under Influence
  • C - Had Been Drinking, Not Under Influence
  • D - Had Been Drinking, Impairment Unknown
  • G - Impairment Unknown
  • H - Not Applicable
  • - - Not Stated
Party Drug Physical PARTY_DRUG_PHYSICAL The state of the party with regard to drugs and physical condition
  • E - Under Drug Influence
  • F - Impairment - Physical
  • G - Impairment Unknown
  • H - Not Applicable
  • I - Sleepy/Fatigued
  • - - Not Stated
Direction Of Travel DIR_OF_TRAVEL Direction that the party was traveling at the time of the crash. The direction is the direction of the highway, not the compass direction. For example, I-5 direction is N or S even though near Sacramento International Airport its compass direction is east-west.
  • N - North
  • S - South
  • E - East
  • W - West
  • - - Not Stated
Party Safety Equipment 1 PARTY_SAFETY_EQUIP_1 The safety equipment of the party
  • A - None in Vehicle
  • B - Unknown
  • C - Lap Belt Used
  • D - Lap Belt Not Used
  • E - Shoulder Harness Used
  • F - Shoulder Harness Not Used
  • G - Lap/Shoulder Harness Used
  • H - Lap/Shoulder Harness Not Used
  • J - Passive Restraint Used
  • K - Passive Restraint Not Used
  • L - Air Bag Deployed
  • M - Air Bag Not Deployed
  • N - Other
  • P - Not Required
  • Q - Child Restraint in Vehicle Used
  • R - Child Restraint in Vehicle Not Used
  • S - Child Restraint in Vehicle, Use Unknown
  • T - Child Restraint in Vehicle, Improper Use
  • U - No Child Restraint in Vehicle
  • V - Driver, Motorcycle Helmet Not Used
  • W - Driver, Motorcycle Helmet Used
  • X - Passenger, Motorcycle Helmet Not Used
  • Y - Passenger, Motorcycle Helmet Used
  • - or blank - Not Stated
Party Safety Equipment 2 PARTY_SAFETY_EQUIP_2 The safety equipment of the party same as Party Safety Equipment 1 above
Financial Responsibility FINAN_RESPONS Financial responsibility of the party
  • N - No Proof of Insurance Obtained
  • Y - Yes, Proof of Insurance Obtained
  • O - Not Applicable (used for parked cars, bicyclists, pedestrians, and party type others)
  • E - Used if the officer is called away from the scene of the crash prior to obtaining the insurance information
  • Blank - Not stated
Special Information 1 SP_INFO_1 Value A indicates that the crash involved a vehicle known to be, or believed to be, transporting a hazardous material as defined in CVC Section 353, whether or not the crash involved a Hazardous Material Incidentvi.
  • A - Hazardous Materials
  • - - Not Stated
Special Information 2 SP_INFO_2 Cell phone
  • B - Cell Phone in Use (4/1/01)
  • C - Cell Phone Not in Use (4/1/01)
  • D - No Cell Phone/Unknown (4/1/01)
  • 1 - Cell Phone Handheld in Use
  • 2 - Cell Phone Handsfree in Use
  • 3 - Cell Phone Not in Use
  • 4 - Cell Phone Use Unknown
  • - - Not Stated
Special Information 3 SP_INFO_3 Value E indicates that the crash involved a motor vehicle in-transport passing a stopped school bus with its red signal lamps in operation, pursuant to CVC Section 22112, or reacting to, pursuant to CVC Section 22454vii.
  • E - School Bus Related (1/1/02)
  • - - Not Stated (1/1/02)
OAF Violation Code OAF_VIOLATION_CODE Other associated factor law code violated
  • B - Business and Professions
  • C - Vehicle
  • H - City Health and Safety
  • I - City Ordinance
  • O - County Ordinance
  • P - Penal
  • S - Streets and Highways
  • W - Welfare and Institutions
  • - - Not Stated
OAF Violation Category OAF_VIOL_CAT Category of the factor that contributed to the crash but was not the primary cause of the crash.
  • 01 - Under Influence in Public (647F)
  • 02 - County Ordinance
  • 03 - City Ordinance
  • 05 - Business/Professions Code
  • 06 - Felony Penal Code
  • 08 - Controlled Substances (Felony Health and Safety)
  • 09 - Health/Safety Code (Misdemeanor)
  • 10 - Penal Code (Misdemeanor)
  • 11 - Streets/Highways Code
  • 13 - Welfare/Institutions Code
  • 15 - Manslaughter
  • 16 - Non-Vehicle Code Not Specified Above
  • 17 - Fish & Game Code
  • 18 - Agriculture Code
  • 19 - Hit and Run
  • 20 - Driving or Bicycling Under the Influence of Alcohol or Drug
  • 21 - Improper Lane Change
  • 22 - Impeding Traffic
  • 23 - Failure to Heed Stop Signal
  • 24 - Failure to Heed Stop Sign
  • 25 - Unsafe Speed
  • 26 - Reckless Driving
  • 27 - Wrong Side of Road
  • 28 - Unsafe Lane Change
  • 29 - Improper Passing
  • 30 - Following Too Closely
  • 31 - Improper Turning
  • 33 - Automobile Right-of-Way
  • 34 - Pedestrian Right-of-Way
  • 35 - Pedestrian Violation
  • 37 -
  • 38 - Hazardous Parking
  • 39 - Lights
  • 40 - Brakes
  • 43 - Other Equipment
  • 44 - Other Hazardous Movement
  • 46 - Improper Registration
  • 47 - Other Non-Moving Violation
  • 48 - Excessive Smoke
  • 49 - Excessive Noise
  • 50 - Overweight
  • 51 - Oversize
  • 52 - Over Maximum Speed
  • 53 - Unsafe Starting or Backing
  • 60 - Off-Highway Vehicle Violation
  • 61 - Child Restraint
  • 62 - Seat Belt
  • 63 - Seat Belt (Equipment)
  • 00 or Blank - Not Stated
OAF Violation Section OAF_VIOL_SECTION The CVC section of the secondary violation that contributed to the crash.
OAF Violation Suffix OAF_VIOLATION_SUFFIX The subsection of the CVC section of the secondary violation that contributed to the crash. Blank may appear if no suffix.
Other Associated Factor 1 OAF_1 A factor that contributed to the crash but was not the primary cause of the crash.
  • A - Violation
  • E - Vision Obscurements
  • F - Inattention (beginning 1/1/01; see Inattention Item Name near end of record for A-K, P values)
  • G - Stop and Go Traffic
  • H - Entering/Leaving Ramp
  • I - Previous Collision
  • J - Unfamiliar With Road
  • K - Defective Vehicle Equipment
  • L - Uninvolved Vehicle
  • M - Other
  • N - None Apparent
  • O - Runaway Vehicle
  • P - Inattention, Cell Phone (1/1/01)
  • Q - Inattention, Electronic Equip.(1/1/01)
  • R - Inattention, Radio/CD (1/1/01)
  • S - Inattention, Smoking (1/1/01)
  • T - Inattention, Eating (1/1/01)
  • U - Inattention, Children (1/1/01)
  • V - Inattention, Animal (1/1/01)
  • W - Inattention, Personal Hygiene (1/1/01)
  • X - Inattention, Reading (1/1/01)
  • Y - Inattention, Other (1/1/01)
  • - - Not Stated
Other Associated Factor 2 OAF_2 A factor that contributed to the crash but was not the primary cause of the crash. same as OAF 1 above
Party Number Killed PARTY_NUMBER_KILLED Number of killed victims in the party 0 to N for each party
Party Number Injured PARTY_NUMBER_INJURED Number of injured victims in the party 0 to N for each party
Movement Preceding Crash MOVE_PRE_ACC The action of the vehicle prior to the crash and before evasive action. This movement does not have to correspond with the PCFviii.
  • A - Stopped
  • B - Proceeding Straight
  • C - Ran Off Road
  • D - Making Right Turn
  • E - Making Left Turn
  • F - Making U-Turn
  • G - Backing
  • H - Slowing/Stopping
  • I - Passing Other Vehicle
  • J - Changing Lanes
  • K - Parking Maneuver
  • L - Entering Traffic
  • M - Other Unsafe Turning
  • N - Crossed Into Opposing Lane
  • O - Parked
  • P - Merging
  • Q - Traveling Wrong Way
  • R - Other
  • S - Lane Splitting
  • - - Not Stated
Vehicle Year VEHICLE_YEAR The model year of the party's vehicle 9999 or blank = not stated
Vehicle Make VEHICLE_MAKE The make of the party's vehicle
Statewide Vehicle Type STWD_VEHICLE_TYPE Type of the party's vehicle according to a list called "statewide vehicle type"
  • A - Passenger Car/Station Wagon
  • B - Passenger Car with Trailer
  • C - Motorcycle/Scooter
  • D - Pickup or Panel Truck
  • E - Pickup or Panel Truck with Trailer
  • F - Truck or Truck Tractor
  • G - Truck or Truck Tractor with Trailer
  • H - Schoolbus
  • I - Other Bus
  • J - Emergency Vehicle
  • K - Highway Construction Equipment
  • L - Bicycle
  • M - Other Vehicle
  • N - Pedestrian
  • O - Moped
  • - or blank - Not Stated
CHP Vehicle Type Towing CHP_VEH_TYPE_TOWING The type of the solitary vehicle or the tractor unit according to the CHP manual HPM 110.5 Chapter 3 Annex F Vehicle Type Codes.
  • 01 - Passenger Car, Station Wagon, or Jeep
  • 02 - Motorcycle
  • 03 - Motor-Driven Cycle (< 15 hp)
  • 04 - Bicycle
  • 05 - Motorized Bicycle
  • 06 - All-Terrain Vehicle (ATV)
  • 07 - Sport Utility Vehicle
  • 08 - Minivan
  • 09 - Paratransit Bus
  • 10 - Tour Bus
  • 11 - Other Commercial Bus
  • 12 - Non-Commercial Bus
  • 13 - Schoolbus Without Pupil Passengers (prior to 2002)
  • 13 - Schoolbus Public I (eff. 2002)
  • 14 - Schoolbus Public I (prior to 2002)
  • 14 - Schoolbus Public II (eff. 2002)
  • 15 - Schoolbus Public II (prior to 2002)
  • 15 - Schoolbus Private I (eff. 2002)
  • 16 - Schoolbus Private I (prior to 2002)
  • 16 - Schoolbus Private II (eff. 2002)
  • 17 - Schoolbus Private II (prior to 2002)
  • 17 - Schoolbus Contractual I (eff. 2002)
  • 18 - Schoolbus Contractual I (prior to 2002)
  • 18 - Schoolbus Contractual II (eff. 2002)
  • 19 - Schoolbus Contractual II (prior to 2002)
  • 19 - General Public Paratransit Vehicle (eff. 2002)
  • 20 - Public Transit Authority
  • 21 - Two-Axle Tank Truck
  • 22 - Pickup or Panel Truck
  • 23 - Pickup Truck With Camper
  • 24 - Three-Axle Tank Truck
  • 25 - Truck Tractor
  • 26 - Two-Axle Truck
  • 27 - Three-Axle Truck
  • 28 - Semi-Tank Trailer
  • 29 - Pull-Tank Trailer
  • 30 - Two-Tank Trailer
  • 31 - Semi-Trailer
  • 32 - Pull Trailer (includes dolly)
  • 33 - Two Trailers (includes semi and trailer)
  • 34 - Boat Trailer
  • 35 - Utility Trailer
  • 36 - Trailer Coach
  • 37 - Oversize Vehicle/Load
  • 38 - Pole, Pipe, or Logging Dolly
  • 39 - Three Trailers (includes semi and two trailers)
  • 40 - Semi 48 or Less with King Pin to Trailer Axle of over 38
  • 41 - Ambulance
  • 42 - Dune Buggy
  • 43 - Fire Truck (not rescue)
  • 44 - Forklift
  • 45 - Highway Construction Equipment (only while not in construction area)
  • 46 - Implement of Husbandry
  • 47 - Motor Home (40 ft or less)
  • 48 - CHP, Police, or Sheriff Car (emergency service or not)
  • 49 - CHP, Police, or Sheriff Motorcycle (emergency service or not)
  • 50 - Mobile Equipment
  • 51 - Farm Labor Vehicle (certified)
  • 52 - Federally Legal Double Cargo Combo over 75 ft
  • 53 - 5th Wheel Trailer
  • 54 - Container Chassis
  • 55 - Two-Axle Tow Truck
  • 56 - Three-Axle Tow Truck
  • 57 - Farm Labor Vehicle (non-certified)
  • 58 - Farm Labor Transporter
  • 59 - Motorhome (over 40 ft)
  • 60 - Pedestrian (includes motorized wheelchair)
  • 61 - School Pupil Activity Bus I (prior to 2002)
  • 62 - School Pupil Activity Bus II (prior to 2002)
  • 63 - "Youth" Bus
  • 64 - School Pupil Activity Bus I (eff. 2002)
  • 65 - School Pupil Activity Bus II (eff. 2002)
  • 66 - School Bus Without Pupil Passengers (eff. 2002)
  • 71 - Passenger Car - Hazardous Materials Only
  • 72 - Pickups and Panels - Hazardous Materials Only
  • 73 - Pickups and Campers - Hazardous Materials Only
  • 75 - Truck Tractor - Hazardous Materials Only
  • 76 - Two-Axle Truck - Hazardous Materials Only
  • 77 - Three or More Axle Truck - Hazardous Materials Only
  • 78 - Two-Axle Tank Truck - Hazardous Materials Only
  • 79 - Three-Axle Tank Truck - Hazardous Materials Only
  • 81 - Passenger Car - Hazardous Waste or Waste/Material Combo
  • 82 - Pickups and Panels - Hazardous Waste or Waste/Material Combo
  • 83 - Pickups and Campers - Hazardous Waste or Waste/Material Combo
  • 85 - Truck Tractor - Hazardous Waste or Waste/Material Combo
  • 86 - Two-Axle Truck - Hazardous Waste or Waste/Material Combo
  • 87 - Three or More Axle Truck - Hazardous Waste or Waste/Material Combo
  • 88 - Two-Axle Tank Truck - Hazardous Waste or Waste/Material Combo
  • 89 - Three-Axle Tank Truck - Hazardous Waste or Waste/Material Combo
  • 91 - Electric Bicycle (Class 1, 2, 3)
  • 93 - Electrically Motorized Board
  • 94 - Motorized Transportation Device
  • 95 - Miscellaneous Non-Motorized Vehicle (Ridden Animal, Animal-Drawn Conveyance, Train, Or Building) With Victim
  • 96 - Miscellaneous Motorized Vehicle (Golf Cart)
  • 97 - Low Speed Vehicle
  • 98 - Emergency Vehicle on an Emergency Run
  • 99 or dash - Not Stated or Unknown (Hit and Run)
CHP Vehicle Type Towed CHP_VEH_TYPE_TOWED The type of the first trailer unit according to the CHP manual HPM 110.5 Chapter 3 Annex F Vehicle Type Codes. same as CHP vehicle type towing above
Party Race RACE The party’s race based on the reporting officer's judgment.
  • A - Asian
  • B - Black
  • H - Hispanic
  • O - Other
  • W - White
  • Blank - Not stated
Inattention INATTENTION Type of inattention
  • A - Cell Phone Handheld (7/1/03)
  • B - Cell Phone Handsfree (7/1/03)
  • C - Electronic Equipment (1/1/01)
  • D - Radio/CD (1/1/01)
  • E - Smoking (1/1/01)
  • F - Eating (1/1/01)
  • G - Children (1/1/01)
  • H - Animal (1/1/01)
  • I - Personal Hygiene (1/1/01)
  • J - Reading (1/1/01)
  • K - Other (1/1/01)
  • P - Cell Phone (1/1/01, value prior to 7/03 form revision)
  • - - Not Stated
Special Info F SPECIAL_INFO_F The value F indicates that the party's vehicle is a 75 ft Motor Truck Combo. The current crash report form no longer has a box to indicate this.
  • F - 75 ft Motor Truck Combo
  • - - Not Stated
Special Info G SPECIAL_INFO_G The value G indicates that the party's vehicle is a 32 ft Trailer Combo. The current crash report form no longer has a box to indicate this.
  • G - 32 ft Trailer Combo
  • - - Not Stated
Local Report Number local_report_number The value G indicates that the party's vehicle is a 32 ft Trailer Combo. The current crash report form no longer has a box to indicate this. The report number assigned by the reporting agency to the crash report

Victim Level

Item Name Variable Name Description Values
Case Id CASE_ID The unique identifier of the crash case
Party Number PARTY_NUMBER The unique identifier of the party in the crash that this victim belongs to 1 to 999
Victim Role VICTIM_ROLE The role of the victim
  • 1 - Driver
  • 2 - Passenger (includes non-operator on bicycle or any victim on/in parked vehicle or multiple victims on/in non-motor vehicle)
  • 3 - Pedestrian
  • 4 - Bicyclist
  • 5 - Other (single victim on/in non-motor vehicle; e.g. ridden animal, horse-drawn carriage, train, or building)
  • 6 - Non-Injured Party
Victim Sex VICTIM_SEX The gender of the victim
  • M - Male
  • F - Female
  • X - Nonbinary
  • - - Not Stated
Victim Age VICTIM_AGE The age of the victim at the time of the crash
  • 0 - 125
  • 998 - Not Stated
  • 999 - Fatal Fetus
Victim Degree of Injury VICTIM_DEGREE_OF_INJURY The severity of the injury to the victim
  • 1 - Killed
  • 2 - Severe Injury
  • 3 - Other Visible Injury
  • 4 - Complaint of Pain
  • 5 - Suspected Serious Injury
  • 6 - Suspected Minor Injury
  • 7 - Possible Injury
  • 0 - No Injury
Victim Seating Position VICTIM_SEATING_POSITION The severity of the injury to the victim
  • 1 - Driver
  • 2 thru 6 - Passengers
  • 7 - Station Wagon Rear
  • 8 - Rear Occupant of Truck or Van
  • 9 - Position Unknown
  • 0 - Other Occupants
  • A thru Z - Bus Occupants
  • - - Not Stated
Victim Safety Equipment 1 VICTIM_SAFETY_EQUIP_1 The safety equipment of the victim
  • A - None in Vehicle
  • B - Unknown
  • C - Lap Belt Used
  • D - Lap Belt Not Used
  • E - Shoulder Harness Used
  • F - Shoulder Harness Not Used
  • G - Lap/Shoulder Harness Used
  • H - Lap/Shoulder Harness Not Used
  • J - Passive Restraint Used
  • K - Passive Restraint Not Used
  • L - Air Bag Deployed
  • M - Air Bag Not Deployed
  • N - Other
  • P - Not Required
  • Q - Child Restraint in Vehicle Used
  • R - Child Restraint in Vehicle Not Used
  • S - Child Restraint in Vehicle, Use Unknown
  • T - Child Restraint in Vehicle, Improper Use
  • U - No Child Restraint in Vehicle
  • V - Driver, Motorcycle Helmet Not Used
  • W - Driver, Motorcycle Helmet Used
  • X - Passenger, Motorcycle Helmet Not Used
  • Y - Passenger, Motorcycle Helmet Used
  • - or blank - Not Stated
Victim Safety Equipment 2 VICTIM_SAFETY_EQUIP_2 The safety equipment of the victim same as Victim Safety Equipment 1 above (eff. Jan 2002)
Victim Ejected VICTIM_EJECTED Indicates whether the victim was ejected from the vehicle
  • 0 - Not Ejected
  • 1 - Fully Ejected
  • 2 - Partially Ejected
  • 3 - Unknown
  • - - Not Stated
Victim Number VICTIM_NUMBER The unique identifier of the victim

  • i The data element was intended to be the population count of the city or county at the time of the crash. However, population count is time-dependent. Existing values are computed from a lookup table with no effective dates. Therefore the value cannot be accurate over time.
  • ii The column translates the value of the data element "reporting_district" in crashes reported by LAPD to a single letter. However, LAPD currently has 21 districts but the translation only covers 18 districts. Anyone wanting LAPD district can get it from the last two digits of the data element "reporting_district".
  • iii The officer checks the box "state highway related" if the crash was on or near a state highway. When the box is checked, the data element has the value Y. However, if Caltrans later decides that the crash was not state highway related, the data element is changed to N, for not state highway related.
  • iv These data elements are from Caltrans coding form Card 8. The values are available only on some highway related documents that were received as hardcopy and are meaningful only to Caltrans.
  • v The type of roadway at the location of the crash. This column is deprecated. The value is based on CHP beat and post mile. The post mile is from Caltrans coding form Card 8 but we stopped doing Card 8 on CHP crashes in 2015.
  • vi HPM 110.5 chapter 4 paragraph 28. a.
  • vii HPM 110.5 chapter 4 paragraph 28. f.
  • viii HPM 110.5 chapter 4 paragraph 26