Item Name

Datatype(Length)

Description

Possible Values

Case Id

Varchar2(19)

the unique identifier of the collision report (barcode beginning 2002; 19 digit code prior to 2002)

Collision Year

Number(4)

the year when the collision occurred

Process Date

Number(8)

(YYYYMMDD)

Jurisdiction

Number(4)

Four numerics assigned by DOJ

Collision Date

Number(8)

the date when the collision occurred (YYYYMMDD)

Collision Time

Number(4)

the time when the collision occurred (24 hour time)

Data may appear with no leading zero(s).

Officer Id

Varchar2(8)

Reporting District

Varchar2(5)

Day of Week

Char(1)

the code for the day of the week when the collision occurred

1 - Monday2 - Tuesday3 - Wednesday4 - Thursday5 - Friday6 - Saturday7 - Sunday

CHP Shift

Char(1)

1 - 0600 thru 13592 - 1400 thru 21593 - 2200 thru 05594 - CHP Not Stated5 - Not CHP

Population

Char(1)

1 - Incorporated (less than 2500)2 - Incorporated (2500 - 10000)3 - Incorporated (10000 - 25000)4 - Incorporated (25000 - 50000)5 - Incorporated (50000 - 100000)6 - Incorporated (100000 - 250000)7 - Incorporated (over 250000)9 - Unincorporated (Rural)0 - University (Private Property)-  - Not Stated

CountyCityLocation

Varchar2(4)

the location code of where the collision occurred

Data may appear with no leading zero.

Special Condition

Char(1)

1 - Schoolbus on Public Roadway (CHP Beat or CHP Adm Beat 901)2 -StateUniversity(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

Char(1)

1 -CHP State Highway2 - CHP County RoadLine3 - CHP County RoadArea4 - 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

Char(1)

1 - Interstate2 - US Highway3 - State Route4 - County RoadLine5 - County RoadAreaA - Safety Services Program BeatsS - Administrative Beats (900’s)0 - Not CHPContractCity:6 - US Highway7 - State Route8 - County RoadLine9 - County RoadArea

City Division LAPD

Char(1)

Includes blanks and dashes as not stated.

CHP Beat Class

Char(1)

1 - CHP Primary2 - CHP Other0 - Not CHP

Beat Number

Varchar2(6)

Primary Rd

Varchar2(50)

Secondary Rd

Varchar2(50)

Distance

Number(9,2)

distance converted to feet

Direction

Char(1)

N - NorthE - EastS - SouthW - West- or blank  - Not Stated, in Intersection

Intersection

Char(1)

Y - IntersectionN - Not IntersectionBlank - Not stated

Weather 1

Char(1)

the weather condition at the time of the collision

A - ClearB - CloudyC - RainingD - SnowingE - FogF - OtherG - Wind -  - Not Stated

Weather 2

Char(1)

the weather condition at the time of the collision, if a second description is necessary

same as weather 1 above

State Highway Indicator

Char(1)

Y - State HighwayN -Not State HighwayBlank - Not stated

CaltransCounty

Char(3)

Includes blanks and nulls

Caltrans District

Number(2)

State Route

Number(3)

0 =Not State Highway

Route Suffix

Char(1)

Postmile Prefix

Char(1)

Postmile

Number(6,3)

Location Type

Char(1)

H - HighwayI   - IntersectionR - Ramp (or Collector)- or blank  -Not State Highway

Ramp Intersection

Char(1)

1 - Ramp Exit, Last 50 Feet2 - Mid-Ramp3 - Ramp Entry, First 50 Feet4 -Not State Highway, Ramp-related, Within 100 Feet5 - Intersection6 -Not State Highway, Intersection-related, Within 250 Feet7 - Highway8 -Not State Highway-  - Not Stated

Side Of Highway

Char(1)

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 - NorthboundS - SouthboundE - EastboundW - WestboundBlank - Not stated/not state highway

Tow Away

Char(1)

Y - YesN - No

Collision Severity

Char(1)

the injury level severity of the collision(highest level of injury in collision)

1 - Fatal2 - Injury (Severe)3 - Injury (Other Visible)4 - Injury (Complaint of Pain)0 - PDO

Killed victims

Number(3)

counts victims in the collision with degree of injury of 1

0 to N for each collision

Injured victims

Number(3)

counts victims in the collision with degree of injury of 2, 3, or 4

0 to N for each collision

Party Count

Number(3)

counts total parties in the collision

1 to N for each collision

Primary Collision Factor

Char(1)

A - (Vehicle) Code ViolationB - Other Improper DrivingC - Other Than DriverD - UnknownE - Fell Asleep-  - Not Stated

PCF Violation Code

Char(1)

B - Business and ProfessionsC - VehicleH - City Health and SafetyI - City OrdinanceO -CountyOrdinanceP - PenalS - Streets and HighwaysW - Welfare and Institutions-   - Not Stated

PCF Violation Category

Char(2)

01 - Driving or Bicycling Under the Influence of Alcohol or Drug02 - Impeding Traffic03 - Unsafe Speed04 - Following Too Closely05 - Wrong Side of Road06 - Improper Passing07 - Unsafe Lane Change08 - Improper Turning09 - Automobile Right of Way10 - Pedestrian Right of Way11 - Pedestrian Violation12 - Traffic Signals and Signs13 - Hazardous Parking14 - Lights15 - Brakes16 - Other Equipment17 - Other Hazardous Violation18 - Other Than Driver (or Pedestrian)19 -20 -21 - Unsafe Starting or Backing22 - Other Improper Driving23 - Pedestrian or "Other" Under the Influence of Alcohol or Drug24 - Fell Asleep00 - Unknown-   - Not Stated

PCF Violation

Number (5)

PCF Violation Subsection

Char(1)

Blank if no subsection.

Hit And Run

Char(1)

F - FelonyM - MisdemeanorN - Not Hit and Run

Type of Collision

Char(1)

A - Head-OnB - SideswipeC - Rear EndD - BroadsideE - Hit ObjectF - OverturnedG - Vehicle/PedestrianH - Other-  - Not Stated

Motor Vehicle Involved With

Char(1)

A - Non-CollisionB - PedestrianC - Other Motor VehicleD - Motor Vehicle on Other RoadwayE - Parked Motor VehicleF - TrainG - BicycleH - AnimalI - Fixed ObjectJ - Other Object-  - Not Stated

Ped Action

Char(1)

A - No Pedestrian InvolvedB - Crossing in Crosswalk at IntersectionC - Crossing in Crosswalk Not at IntersectionD - Crossing Not in CrosswalkE - In Road, Including ShoulderF - Not in RoadG - Approaching/Leaving School Bus-  - Not Stated

Road Surface

Char(1)

A - DryB - WetC - Snowy or IcyD - Slippery (Muddy, Oily, etc.)-  - Not Stated

Road Condition 1

Char(1)

A - Holes, Deep RutsB - Loose Material on RoadwayC - Obstruction on RoadwayD - Construction or Repair ZoneE - Reduced Roadway WidthF - FloodedG - OtherH - No Unusual Condition-  - Not Stated

Road Condition 2

Char(1)

same as road condition 1 above

Lighting

Char(1)

A - DaylightB - Dusk - DawnC - Dark - Street LightsD - Dark -No StreetLightsE - Dark - Street Lights Not Functioning-  - Not Stated

Control Device

Char(1)

A - FunctioningB - Not FunctioningC - ObscuredD - None-  - Not Stated

CHP RoadType

Char(1)

May be blank

Pedestrian Collision

Char(1)

indicates whether the collision involved a pedestrian

Y or blank

Bicycle Collision

Char(1)

indicates whether the collision involved a bicycle

Y or blank

Motorcycle Collision

Char(1)

indicates whether the collision involved a motorcycle

Y or blank

Truck Collision

Char(1)

indicates whether the collision involved a big truck

Y or blank

Not Private Property

Char(1)

indicates whether the collision occurred on private property

Y or blank

Alcohol Involved

Char(1)

indicates whether the collision involved a party that had been drinking

Y or blank

Statewide Vehicle Type At Fault

Char(1)

indicates the Statewide Vehicle Type of the party who is at fault

see Party folder Statewide Vehicle Type item

CHP Vehicle Type At Fault

Char(2)

indicates the CHP Vehicle Type of the party who is at fault

see Party folder CHP Vehicle Type Towing item

Severe Injury count

Number(3)

counts victims in the collision with degree of injury of 2

0 to N for each collision

Other Visible Injury count

Number(3)

counts victims in the collision with degree of injury of 3

0 to N for each collision

Complaint of Pain Injury count

Number(3)

counts victims in the collision with degree of injury of 4

0 to N for each collision

Pedestrian Killed count

Number(3)

Counts the victims in the collision with party type of 2 and degree of injury is 1

0 or 1 for each collision

Pedestrian Injured count

Number(3)

Counts the victims in the collision with party type of 2 and degree of injury is 2, 3, or 4

0 or 1 for each collision

Bicyclist Killed count

Number(3)

Counts the victims in the collision with party type of 4 and degree of injury is 1

0 to N for each collision

Bicyclist Injured count

Number(3)

Counts the victims in the collision with party type of 4 and degree of injury is 2, 3, or 4

0 to N for each collision

Motorcyclist Killed count

Number(3)

counts victims in the collision with statewide vehicle type of C or O and degree of injury of 1

0 to N for each collision

Motorcyclist Injured count

Number(3)

counts victims in the collision with statewide vehicle type of C or O and degree of injury of 2, 3, or 4

0 to N for each collision

Primary Ramp

Varchar2(2)

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 & blank

Secondary Ramp

Varchar2(2)

Same as above

Latitude

Longitude

Case Id

Varchar2(19)

the unique identifier of the collision report (barcode beginning 2002; 19 digit code prior to 2002)

Party Number

Number(3)

1 to 999

Party Type

Char(1)

1 - Driver (including Hit and Run)2 - Pedestrian3 - Parked Vehicle4 - Bicyclist5 - Other-  - Not Stated

At Fault

Char(1)

indicates whether the party was at fault in the collision

Y

Party Sex

Char(1)

the code of the sex of the party

M - MaleF - Female-  - Not Stated

Party Age

Number(3)

the age of the party at the time of the collision

0 to 100+ (0 & blank = Not Stated)

Party Sobriety

Char(1)

A - Had Not Been DrinkingB - Had Been Drinking, Under InfluenceC - Had Been Drinking, Not Under InfluenceD - Had Been Drinking, Impairment UnknownG - Impairment UnknownH - Not Applicable-  - Not Stated

Party Drug Physical

Char(1)

E - Under Drug InfluenceF - Impairment - PhysicalH - Not ApplicableI  - Sleepy/Fatigued-  - Not Stated

Direction Of Travel

Char(1)

N - NorthS - SouthE - EastW - West-   - Not Stated

Party Safety Equipment 1

Char(1)

A - None in VehicleB - UnknownC - Lap Belt UsedD - Lap Belt Not UsedE - Shoulder Harness UsedF - Shoulder Harness Not UsedG - Lap/Shoulder Harness UsedH - Lap/Shoulder Harness Not UsedJ - Passive Restraint UsedK - Passive Restraint Not UsedL - Air Bag DeployedM - Air Bag Not DeployedN - OtherP - Not RequiredQ - Child Restraint in Vehicle UsedR - Child Restraint in Vehicle Not UsedS - Child Restraint in Vehicle, Use UnknownT - Child Restraint in Vehicle, Improper UseU - No Child Restraint in VehicleV - Driver, Motorcycle Helmet Not UsedW - Driver, Motorcycle Helmet UsedX - Passenger, Motorcycle Helmet Not UsedY - Passenger, Motorcycle Helmet Used-  or blank - Not Stated

Party Safety Equipment 2

Char(1)

same as Party Safety Equipment 1 above

Financial Responsibility

Char(1)

N - No Proof of Insurance ObtainedY - Yes, Proof of Insurance ObtainedO - 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 collision prior to obtaining the insurance informationBlank - not stated

Special Information 1

Char(1)

A - Hazardous Materials- - Not Stated

Special Information 2

Char(1)

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)-  - Not Stated (4/1/01)

Special Information3

Char(1)

E - School Bus Related (1/1/02)-  - Not Stated (1/1/02)

OAF Violation Code

Char(1)

B - Business and ProfessionsC - VehicleH - City Health and SafetyI - City OrdinanceO -CountyOrdinanceP - PenalS - Streets and HighwaysW - Welfare and Institutions- - Not Stated

OAF Violation Category

Char(2)

01 - Under Influence in Public (647F)02 -CountyOrdinance03 - City Ordinance05 - Business/Professions Code06 - Felony Penal Code08 - Controlled Substances (Felony Health and Safety)09 - Health/Safety Code (Misdemeanor)10 - Penal Code (Misdemeanor)11 - Streets/Highways Code13 - Welfare/Institutions Code15 - Manslaughter16 - Non-Vehicle Code Not Specified Above17 - Fish & Game Code18 - Agriculture Code19 - Hit and Run20 - Driving or Bicycling Under the Influence of Alcohol or Drug21 - Improper Lane Change22 - Impeding Traffic23 - Failure to Heed Stop Signal24 - Failure to Heed Stop Sign25 - Unsafe Speed26 - Reckless Driving27 - Wrong Side of Road28 - Unsafe Lane Change29 - Improper Passing30 - Following Too Closely31 - Improper Turning33 - Automobile Right-of-Way34 - Pedestrian Right-of-Way35 - Pedestrian Violation37 -38 - Hazardous Parking39 - Lights40 - Brakes43 - Other Equipment44 - Other Hazardous Movement46 - Improper Registration47 - Other Non-Moving Violation48 - Excessive Smoke49 - Excessive Noise50 - Overweight51 - Oversize52 - Over Maximum Speed53 - Unsafe Starting or Backing60 - Off-Highway Vehicle Violation61 - Child Restraint62 - Seat Belt63 - Seat Belt (Equipment)00  or Blank - Not Stated

OAF Violation Section

Number(5)

OAF Violation Suffix

Char(1)

Blank may appear if no suffix.

Other Associated Factor 1

Char(1)

A - ViolationE - Vision ObscurementsF - Inattention (beginning1/1/01, inattention not stated)G - Stop and Go TrafficH - Entering/Leaving RampI - Previous CollisionJ - Unfamiliar With RoadK - Defective Vehicle EquipmentL - Uninvolved VehicleM - OtherN - None ApparentO - Runaway VehicleP - 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

Char(1)

same as OAF 1 above

Party Number Killed

Number(3)

counts victims in the party with degree of injury of 1

0 to N for each party

Party Number Injured

Number(3)

counts victims in the party with degree of injury of 2, 3, or 4

0 to N for each party

Movement Preceding Collision

Char(1)

A - StoppedB - Proceeding StraightC - Ran Off RoadD - Making Right TurnE - Making Left TurnF - Making U-TurnG - BackingH - Slowing/StoppingI - Passing Other VehicleJ - Changing LanesK - Parking ManeuverL - Entering TrafficM - Other Unsafe TurningN - Crossed Into Opposing LaneO - ParkedP - MergingQ - TravelingWrong WayR - Other-  - Not Stated

Vehicle Year

Number(4)

the model year of the party's vehicle

9999 or blank = not stated

Vehicle Make

Varchar2(50)

the full description of the make of the party's vehicle

Statewide Vehicle Type

Char(1)

A - Passenger Car/Station WagonB - Passenger Car with TrailerC - Motorcycle/ScooterD - Pickup or Panel TruckE - Pickup or Panel Truck with TrailerF - Truck or Truck TractorG - Truck or Truck Tractor with TrailerH - SchoolbusI - Other BusJ - Emergency VehicleK - Highway Construction EquipmentL - BicycleM - Other VehicleN - PedestrianO - Moped- or blank - Not Stated

CHP Vehicle Type Towing

Char(2)

01 - Passenger Car, Station Wagon, or Jeep02 - Motorcycle03 - Motor-Driven Cycle (< 15 hp)04 - Bicycle05 - Motorized Bicycle06 - All-Terrain Vehicle (ATV)07 - Sport Utility Vehicle08 - Minivan09 - Paratransit Bus10 - Tour Bus11 - Other Commercial Bus12 - Non-Commercial Bus13 - Schoolbus Public I (eff. 2002)14 - Schoolbus Public II (eff. 2002)15 - Schoolbus Private I (eff. 2002)16 - Schoolbus Private II (eff. 2002)17 - Schoolbus Contractual I (eff. 2002)18 - Schoolbus Contractual II (eff. 2002 19 – General Public Paratransit Vehicle (eff 200220 - Public Transit Authority21 - Two-Axle Tank Truck22 - Pickup or Panel Truck23 - Pickup Truck With Camper24 - Three-Axle Tank Truck25 - Truck Tractor26 - Two-Axle Truck27 - Three-Axle Truck41 - Ambulance42 - Dune Buggy43 - Fire Truck (not rescue)44 - Forklift45 - Highway Construction Equipment (only while not in construction area)46 - Implement of Husbandry47 - 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 Equipment51 - Farm Labor Vehicle (certified)55 - Two-Axle Tow Truck56 - Three-Axle Tow Truck57 - Farm Labor Vehicle (non-certified)58 - Farm Labor Transporter59 - 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 200263 - "Youth" Bus64 - School Pupil Activity Bus I (eff. 2002)65 - School Pupil Activity Bus II (eff. 2002)66 – School Bus – No Pupils on Board (eff 2002)71 - Passenger Car - Hazardous Materials Only72 - Pickups and Panels - Hazardous Materials Only73 - Pickups and Campers - Hazardous Materials Only75 - Truck Tractor - Hazardous Materials Only76 - Two-Axle Truck - Hazardous Materials Only77 - Three or More Axle Truck - Hazardous Materials Only78 - Two-Axle Tank Truck - Hazardous Materials Only79 - Three-Axle Tank Truck - Hazardous Materials Only81 - Passenger Car - Hazardous Waste or Waste/Material Combo82 - Pickups and Panels - Hazardous Waste or Waste/Material Combo83 - Pickups and Campers - Hazardous Waste or Waste/Material Combo85 - Truck Tractor - Hazardous Waste or Waste/Material Combo86 - Two-Axle Truck - Hazardous Waste or Waste/Material Combo87 - Three or More Axle Truck - Hazardous Waste or Waste/Material Combo88 - Two-Axle Tank Truck - Hazardous Waste or Waste/Material Combo89 - Three-Axle Tank Truck - Hazardous Waste or Waste/Material Combo94 - Motorized Transportation Device95 - Miscellaneous Non-Motorized Vehicle(Ridden Animal, Animal-Drawn Conveyance, Train, Or Building) With Victim96 - Miscellaneous Motorized Vehicle (Golf Cart)97 - Low Speed Vehicle99 or dash - Not Stated or Unknown (Hit and Run)

CHP Vehicle Type Towed

Char(2)

same as CHP vehicle type towing above with the following additions:28 - Semi-Tank Trailer29 - Pull-Tank Trailer30 - Two-Tank Trailer31 - Semi-Trailer32 - Pull Trailer (includes dolly)33 - Two Trailers (or 31 + 32)34 - Boat Trailer35 - Utility Trailer36 - Trailer Coach37 - Extralegal Permit Load38 - Pole, Pipe, or Logging Dolly39 - Three Trailers (or 31 + 33)40 - Federally Legal Semi-Trailer52 - Federally Legal Double Cargo Combo (over 75 ft)53 - Fifth Wheel Trailer54 - Container Chassis98 – Emergency Vehicle on an Emergency Run

Party Race

Char(1)

A - Asian           O - OtherB - Black           W - WhiteH - Hispanic      Blank - Not stated     Eff.1/1/2002 

Case Id

Varchar2(19)

the unique identifier of the collision report (barcode beginning 2002; 19 digit code prior to 2002)

Party Number

Number (3)

1 to 999

Victim Role

Char(1)

1 - Driver2 - Passenger (includes non-operator on bicycle or any victim on/in parked vehicle or multiple victims on/in non-motor vehicle)3 - Pedestrian4 - Bicyclist5 - Other (single victim on/in non-motor vehicle; e.g. ridden animal, horse-drawn carriage, train, or building)6 - Non-Injured Party

Victim Sex

Char(1)

M - MaleF - Female-  - Not Stated

Victim Age

Number(3)

the age of the victim at the time of the collision

0 – 125998 – Not Stated999 – Fatal Fetus 

Victim Degree of Injury

Char(1)

1 - Killed2 - Severe Injury3 - Other Visible Injury4 - Complaint of Pain0 - No Injury

Victim Seating Position

Char(1)

1 - Driver2 thru 6 - Passengers7 - Station Wagon Rear8 - Rear Occupant of Truck or Van9 - Position Unknown0 - Other OccupantsA thru Z - Bus Occupants-  - Not Stated

Victim Safety Equipment 1

Char(1)

A - None in VehicleB - UnknownC - Lap Belt UsedD - Lap Belt Not UsedE - Shoulder Harness UsedF - Shoulder Harness Not UsedG - Lap/Shoulder Harness UsedH - Lap/Shoulder Harness Not UsedJ - Passive Restraint UsedK - Passive Restraint Not UsedL - Air Bag DeployedM - Air Bag Not DeployedN - OtherP - Not RequiredQ - Child Restraint in Vehicle UsedR - Child Restraint in Vehicle Not UsedS - Child Restraint in Vehicle, Use UnknownT - Child Restraint in Vehicle, Improper UseU - No Child Restraint in VehicleV - Driver, Motorcycle Helmet Not UsedW - Driver, Motorcycle Helmet UsedX - Passenger, Motorcycle Helmet Not UsedY - Passenger, Motorcycle Helmet Used- or blank -  Not Stated

Victim Safety Equipment 2

Char(1)

same as Victim Safety Equipment 1 above(eff. Jan 2002)

Victim Ejected

Char(1)

0 - Not Ejected1 - Fully Ejected2 - Partially Ejected3 - Unknown-  - Not Stated