Crash Record Number (a unique identifier for the crash)

District Number where crash occurred

County Code Number where crash occurred (02 == Allegheny County)

County Municipality Code

Code of the reporting Police Agency

Year when the crash occurred

Month when the crash occurred

Day of the Week code when crash occurred

The time of day when the crash occurred

The hour of Day when the crash occurred

"Code that defines lighting at crash scene 1 – Daylight 2 – Dark – no street lights 3 – Dark – street lights 4 – Dusk 5 – Dawn 6 – Dark – unknown roadway lighting 8 – Other

Code for the first weather condition at time of crash 01 - Blowing Sand, Soil, Dirt 02 - Blowing Snow 03 - Clear 04 - Cloudy 05 - Fog, Smog, Smoke 06 - Freezing Rain or Freezing Drizzle 07 - Rain 08 - Severe Crosswinds 09 - Sleet or Hail 10 - Snow 98 - Other 99 - Unknown

"Roadway Surface Condition Code 0 - Dry 1 - Wet 2 - Sand/ mud/ dirt/ oil/ or gravel 3 - Snow covered 4 - Slush 5 - Ice 6 - Ice Patches 7 - Water - standing or moving 8 - Other 9 - Unknown (expired)"

Collision category that defines the crash 0 - Non collision 1 - Rear-end 2 - Head-on 3 - Rear-to-rear (Backing) 4 - Angle 5 - Sideswipe (same dir.) 6 - Sideswipe (Opposite dir.) 7 - Hit fixed object 8 - Hit pedestrian 9 - Other or Unknown

Code for the crash's relativity to the road 1 - On roadway 2 - Shoulder 3 - Median 4 - Roadside (off trafficway; on vehicle area) 5 - Outside trafficway (in area not meant for vehicles) 6 - In parking lane 7 - Gore (intersection of ramp and highway) 9 - Unknown

Code that defines the Intersection Type 00 - Mid-block 01 - Four way intersection 02 - ""T"" intersection 03 - ""Y"" intersection 04 - Traffic circle or Round About 05 - Multi-leg intersection 06 - On ramp 07 - Off ramp 08 - Crossover 09 - Railroad crossing 10 - Other 99 - Unknown (expired)

Code that defines the Traffic Control Device 0 - Not applicable 1 - Flashing traffic signal 2 - Traffic signal 3 - Stop sign 4 - Yield sign 5 - Active RR crossing controls 6 - Passive RR crossing controls 7 - Police officer or flagman 8 - Other Type TCD 9 - Unknown

Code to classify crash as Urban or Rural based on municipality

Code that defines the crash location 0 - Not applicable 1 - Underpass 2 - Ramp 3 - Bridge 4 - Tunnel 5 - Toll Booth 6 - Cross over related 7 - Driveway or Parking Lot 8 - Ramp and bridge 9 - Unknown

Did the crash involve a School Bus? (Y/N); Y = Yes N = No

Did the crash occur in a School Zone? (Y/N); Y = Yes N = No

Total count of all Vehicles and Pedestrians

Total amount of people involved

Total amount of all vehicles involved

Total Amount of Automobiles Involved

Total amount of Motorcycles Involved

Total amount of Buses involved

Total amount of Small Trucks involved

Total amount of Heavy Trucks involved

Total count of sport utility vehicles involved

Total amount of vans involved

Total amount of Bicycles involved

Total amount of fatalities involved

Total count of all injuries sustained

Major Injury = Incapacitating injury, including bleeding wounds and distorted members (amputations or broken bones), and requires transport of the patient from the scene

Moderate Injury = Non- incapacitating injury, including bruises, abrasions, swelling, and limping. This is an injury that may require some form of medical treatment or hospitalization.

Minor Injury = Possible injury, although there may be no visible injuries, and the patient complains of pain. This is an injury that can be treated by basic first-aid application whether at the scene or in medical facilities.

No. of injuries with unknown severity

No. of people that are unknown if injured

No. of people that are unknown if injured

Total count of all unbelted occupants

No. of people with major injuries not wearing a seatbelt

Total Deaths of belted occupants

No. of people who sustained major injuries wearing a seatbelt

Total amount of Motorcyclist fatalities

No. of people with major injuries of Motorcyclists

Total amount of Bicyclist Fatalities

No. of Bicyclists who sustained a major injury

Total amount of Pedestrians involved

Total amount of Pedestrian fatalities

No. of Pedestrians who sustained a major injury

Total Commercial vehicles involved

Injury severity level of the crash 0 - Not injured 1 - Killed 2 – Suspected Serious injury 3 – Suspected Minor injury 4 – Possible Injury 8 - Injury/ Unknown Severity 9 - Unknown if Injured

Total amount of 16 year old drivers

Total amount of 17 year old drivers

Total amount of 18 year old drivers

Total amount of 19 year old drivers

Total amount of 20 year old drivers

Total amount of 50 to 64 year old drivers

Total amount of 65 to 74 year old drivers

Total amount of drivers ages 75 and up

GPS Coordinates from Police if present; Degrees:Min:Sec.Dec Sec

GPS Coordinates from Police if present; Degrees:Min:Sec.Dec Sec

Decimal Latitude for SR's; Degrees.Decimal Degrees

Decimal Longitude for SR's; Degrees.Decimal Degrees

Estimated hours roadway was closed

Was there a lane closure? (Y/N); 1=Y, 0 = N

"1 - North 2 - South 3 - East 4 - West 5 - North And South 6 - East and West 7 - All (N

PENNDOT highway maintenance notified? 0 = No, 1 = Yes

Code for the Roadway surface type –only for fatal crashes 1 - Concrete 2 - Blacktop 3 - Brick or Block 4 - Slag, Gravel, or Stone 5 - Dirt 8 - Other 9 - Unknown

Code that defines any special jurisdiction – only for fatal crashes
0 - No Special Jurisdiction 1 - National Park 2 - Military 3 - Indian Reservation 4 - College/University Campus 5 - Other Federal Sites 8 - Other 9 - Unknown

0 - No Controls 1 - Device not Functioning 2 - Device Functioning improperly 3 - Device Functioning properly 4 - Emergency Preemptive Signal 9 - Unknown

Was the Traffic Detoured? (Y/N) 0 = No, 1 = Yes

Did the crash occur in a work zone (Y/N) 0 = No, 1 = Yes

Code to define the type of Work Zone 1 - Construction 2 - Maintenance 3 - Utility company

1 - Before the 1st work zone warning sign 2 - Advance warning area 3 - Transition area 4 - Activity area 5 - Termination area 8 - Other

Speed limit for the Construction Zone

Were construction personnel present? (Y/N); 0 = No, 1 = Yes

Was traffic rerouted due to work zone?(Y/N); 0 = No, 1 = Yes

Did Work zone have a flagman? (Y/N) 0 = No, 1 = Yes

Did Work zone have a patrolman? (Y/N) 0 = No, 1 = Yes

Did Work zone have a patrolman? (Y/N) 0 = No, 1 = Yes

Was there moving work in the zone? (Y/N) 0 = No, 1 = Yes

Was this a special type of work zone? (Y/N) 0 = No, 1 = Yes

Was a median/shoulder in the zone?; (Y/N) 0 = No, 1 = Yes

Crash Record Number (a unique identifier for the crash)

Non-Turnpike Interstate Indicator; 0 = No, 1 = Yes

State Road Indicator; 0 = No, 1 = Yes

Local Road Indicator; 0 = No, 1 = Yes

Local Road Only Indicator; 0 = No, 1 = Yes

Turnpike Indicator; 0 = No, 1 = Yes

Wet Road Indicator; 0 = No, 1 = Yes

Snow Slush Road Indicator; 0 = No, 1 = Yes

Icy Road Indicator; 0 = No, 1 = Yes

Sudden Deer Indicator; 0 = No, 1 = Yes

Shoulder Related Indicator; 0 = No, 1 = Yes

Rear End Collision Indicator; 0 = No, 1 = Yes

Head on or Side Swipe Indicator; 0 = No, 1 = Yes

Hit Fixed Object Indicator; 0 = No, 1 = Yes

Single Vehicle Run Off Road Indicator; 0 = No, 1 = Yes

Work Zone Indicator; 0 = No, 1 = Yes

Property Damage Only Indicator; 0 = No, 1 = Yes

The crash has at least one person who was killed or sustained a Major Injury; 0 = No, 1 = Yes

Injury Indicator; 0 = No, 1 = Yes

Fatality Indicator; 0 = No, 1 = Yes

Non Intersection Indicator; 0 = No, 1 = Yes

Intersection Indicator; 0 = No, 1 = Yes

The crash took place at a Signalized Intersection
Signalized Intersection Indicator; 0 = No, 1 = Yes

The crash took place at a Stop Controlled Intersection? 0 = No, 1 = Yes

The crash took place at an unsignalized Intersection Indicator; 0 = No, 1 = Yes

The crash involved at least one School Bus ? 0 = No, 1 = Yes

The crash took place in a School Zone? 0 = No, 1 = Yes

At least one unit Hit a Deer; 0 = No, 1 = Yes

At least one unit hit a Hit Tree or Shrub ?; 0 = No, 1 = Yes

At least one unit Hit Embankment? 0 = No, 1 = Yes

At least one unit Hit a Pole? 0 = No, 1 = Yes

At least one unit hit a guide rail? 0 = No, 1 = Yes

At least one unit hit a guide rail end flag? 0 = No, 1 = Yes

Hit Barrier Indicator; 0 = No, 1 = Yes

Hit Bridge Indicator; 0 = No, 1 = Yes

The crash involved at least one Overturned Vehicle? 0 = No, 1 = Yes

The crash involved at least one Motorcycle? 0 = No, 1 = Yes

A Bicycle was involved? 0 = No, 1 = Yes

At Least one Heavy Truck was involved? 0 = No, 1 = Yes

The crash involve At least one Vehicle Failure that contributed to the crash? 0 = No, 1 = Yes

Train or Trolley Indicator; 0 = No, 1 = Yes

The crash involved at least one Unit that contributed to the crash but did not have any harmful events? 0 = No, 1 = Yes

Alcohol Related Indicator; 0 = No, 1 = Yes

Drinking Driver Indicator; 0 = No, 1 = Yes

Under Age drinking driver Indicator; 0 = No, 1 = Yes

Unlicensed Driver Indicator; 0 = No, 1 = Yes

Driver Using Cell Phone Indicator; 0 = No, 1 = Yes

No Clearance Indicator; 0 = No, 1 = Yes

Driver Running Red Light Indicator; 0 = No, 1 = Yes

Tailgating Indicator; 0 = No, 1 = Yes

Cross Median Indicator; 0 = No, 1 = Yes

Curve in Road Driver Error Indicator; 0 = No, 1 = Yes

The Crash took place on a roadway that had a posted Speed limit of 65 Miles Per Hour

Speeding Indicator; 0 = No, 1 = Yes

Speeding Related Indicator; 0 = No, 1 = Yes

Aggressive Driving Indicator; 0 = No, 1 = Yes

Fatigue or Asleep Indicator; 0 = No, 1 = Yes

Driver is 16 Years of Age Indicator

Driver is 17 Years of Age Indicator

Driver is 65 to 74 Years of Age Indicator; 0 = No, 1 = Yes

Driver is 75 Years or older Age Indicator; 0 = No, 1 = Yes

Anyone in crash unbelted indicator; 0 = No, 1 = Yes

Pedestrian Indicator; 0 = No, 1 = Yes

Distracted Driver Indicator; 0 = No, 1 = Yes

Curved Road; 0 = No, 1 = Yes

Driver is 18 Years of Age Indicator

Driver is 19 Years of Age Indicator; 0 = No, 1 = Yes

Driver is 20 Years of Age Indicator; 0 = No, 1 = Yes

Driver is 50 to 64 Years of Age Indicator; 0 = No, 1 = Yes

Vehicle Towed Indicator; 0 = No, 1 = Yes

At least 1 Vehicle with Fire Damage; 0 = No, 1 = Yes

Hit Parked Vehicle Indicator; 0 = No, 1 = Yes

At least 1 Motorcycle driver has reported or suspected Alcohol Use; 0 = No, 1 = Yes

At least one Driver with Drugs reported or suspected

At least 1 Person Was Injured or Killed in the Crash; 0 = No, 1 = Yes

Crash has at least 1 involved Commercial Vehicle; 0 = No, 1 = Yes

At least One Driver was Impaired by Drugs or Alcohol; 0 = No, 1 = Yes

Deer Related Indicator; 0 = No, 1 = Yes

At least one Heavy Truck carrying Hazardous Material; 0 = No, 1 = Yes

Illegal Drug Related indicator; 0 = No, 1 = Yes

Illumination Indicates that the Crash Scene Lighting was Dark; 0 = No, 1 = Yes

Minor Injury Indicator; 0 = No, 1 = Yes

Moderate Injury Indicator; 0 = No, 1 = Yes

Major Injury Indicator; 0 = No, 1 = Yes

The Crash meets the NHTSA definition of Aggressive Driving

Crash Investigated by the Pennsylvania State Police; 0 = No, 1 = Yes

Driver Running Stop Sign? 0 = No, 1 = Yes

The crash involved a Train? 0 = No, 1 = Yes

The crash involved a Trolley? 0 = No, 1 = Yes

Crash Record Number (a unique identifier for the crash)

Crash Roadway Sequence Number

Adjusted Roadway Sequence Number

Access Control Code- only for state roads

County Code Number where crash occurred (02 == Allegheny County). This has the same value as the CRN_COUNTY field.

Travel Lane Count

E - East N - North S - South U - Unknown W - West

Roadway maintained by state, local, or private jurisdiction.

1 - Interstate - non turnpike 2 - State highway 3 - County road 4 - Local road or street 5 - East-West portion of turnpike 6 - Turnpike spur (extension) 7 - Private Road 9 - Other or Unknown

Route Number only for state roads

Speed Limit of Roadway

Segment Number- only for state roads

Offset (in feet) within the Segment - only for state roads

Name of the Roadway

Total Injuries