Still in Progress: Need to Verify Full List and Code Descriptions:

The Roadway Departure filter searches the Crash Table for the following criteria:

First Harmful Event = Overturn/Rollover

OR

First Harmful Event = Impact Attenuator/Crash Cushion

OR

First Harmful Event = Bridge Overhead Structure

OR

First Harmful Event = Bridge Pier or Support

OR

First Harmful Event = Bridge Rail

OR

First Harmful Event = Guardrail Face

OR

First Harmful Event = Guardrail End Terminal

OR

First Harmful Event = Concrete Traffic Barrier

OR

First Harmful Event = Traffic Sign Support

OR

First Harmful Event = Other Post, Pole or Support

OR

First Harmful Event = Utility Pole/Light Support

OR

First Harmful Event = Other Post, Pole or Support

OR

First Harmful Event = Culvert

OR

First Harmful Event = Curb

OR

First Harmful Event = Ditch

OR

First Harmful Event = Embankment

OR

First Harmful Event = Fence

OR

First Harmful Event = Mailbox

OR

First Harmful Event = Tree (standing)

OR

First Harmful Event = Other Fixed Object (wall, building, tunnel, etc.)

OR

First Harmful Event = Work Zone/Maintenance Equipment

OR

First Harmful Event = Unknown Fixed Object

OR

Manner of Collision = Front-To-Front

OR

Manner of Collison = Sideswipe Opposite

The Intersection Related filter searches the Crash Table for the following criteria:

Specific Junction Location = Acceleration/Deceleration Lane

OR

Specific Junction Location = Crossover-Related

OR

Specific Junction Location = Driveway Access or Related

OR

Specific Junction Location = Entrance/Exit Ramp or Related

OR

Specific Junction Location = Intersection or Related

OR

Specific Junction Location = Other Location

OR

Within Interchange Area = Yes

The Young Driver filter searches the Person Table for the following criteria:

Age < 21

AND

Occupant Type = Driver

The Older Driver filter searches the Person Table for the following criteria:

Age >= 65

AND

Occupant Type = Driver

The Impaired Driving filter searches the Crash Table for the following criteria:

Alcohol Involved = Y

OR

Drug Involved = Y

The Seat Belt Usage filter searches the Person Table for the following criteria:

Restraint Use = Booster Seat

OR

Restraint Use = Child Restraint System - Forward Facing

OR

Restraint Use = Child Restraint System - Rear Facing

OR

Restraint Use = Child Restraint System - Type Unknown

OR

Restraint Use = Lap Belt Only Used

OR

Restraint Use = Restraint Used - Type Unknown

OR

Restraint Use = Shoulder & Lap Belt Used

OR

Restraint Use = Shoulder Belt Only Used

The Rural Urban Designation filter searches the Crash Table for the following criteria:

Rural Designation

RRL_URB_CDE = 1

Urban Designation

RRL_URB_CDE = 2, 3, or 4

The Crash Time Category filter searches the Crash Table for the following criteria:

Midnight to 02:59

When Time of Crash is Between 12:00 AM and 2:59 AM

03:00 to 05:59

When Time of Crash Is Between 3:00 AM and 5:59 AM

06:00 to 08:59

When Time of Crash is Between 6:00 AM and 8:59 AM

09:00 to 11:59

When Time of Crash is Between 9:00 AM and 11:59 AM

12:00 to 14:59

When Time of Crash is Between 12:00 PM and 2:59 PM

15:00 to 17:59

When Time of Crash is Between 3:00 PM and 5:59 PM

18:00 to 20:59

When Time of Crash is Between 6:00 PM and 8:59 PM

21:00 to 23:59

When Time of Crash is Between 9:00 PM and 11:59 PM

The Railroad Involvement filter searches the Crash Table for the following criteria:

Specific Location = Rail Grade Crossing

OR

Most Harmful Event = Railway Vehicle (train, engine)

OR

First Harmful Event = Railway Vehicle (train, engine)

OR

Sequence of Events = Railway Vehicle (train, engine)

The Pedestrian Or Cyclist Involvement filter searches the Person Table for the following criteria:

Person Type = Bicyclist

OR

Person Type = Other Cyclist

OR

Person Type = Pedestrian

OR

Person Type = Other Pedestrian (wheelchair, person in a building, parked vehicle, skater, personal conveyance, etc.)

The PM-1 Non-Motorist Performance Measure filter searches the Person Table for the following criteria:

Person Type = Bicyclist

OR

Person Type = Other Cyclist

OR

Person Type = Pedestrian

OR

Person Type = Other Pedestrian (wheelchair, person in a building, parked vehicle, skater, personal conveyance, etc.)

OR

Person Type = Occupant of a Non-Motor Vehicle Transportation Device

OR

Person Type = Unknown Type of Non-Motorist

AND

Injury Status = Fatal Injury

OR

Injury Status = Suspected Serious Injury

The Within Municipal Limits filter searches the Crash Table for the following criteria:

City Name ≠ NULL

The Sewuence of Events filter combines the following fields, displayed as an array:

First Event, Second Event, Third Event, Fourth Event

The Crash Type filter searches the First Harmful Event for the following criteria:

Manner of Collision = Angle

Manner of Collision = Front-to-Rear

Manner of Collision = Sideswipe-Same Direction

Manner of Collision = Sideswipe-Opposite Direction

Manner of Collision = Front-to-Front

Manner of Collision = Other, Not Stated, Unknown, Rear-to-Rear, Rear-to-Side

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Rail Vehicle (train, engine)

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Pedestrian

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Pedalcycle

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Animal (live)

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Parked Motor Vehicle

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Bridge Overhead Structure, Bridge Pier Or Support, Bridge Rail, Cable Barrier, Concrete Traffic Barrier, Culvert, Curb, Ditch, Embankment, Fence, Guardrail End Terminal, Guardrail Face, Impact Attentuator/Crash Cushion, Mailbox, Other Fixed Object (Wall, Building, Tunnel, etc), Other Post Pole or Support, Other Traffic Barrier, Traffic Sign Support, Tree (Standing), Utility Pole/Light Support, Unknown Fixed Object

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Overturn/Rollover

Manner of Collision = Not a Collision Between Two Motor Vehicles

AND

First Harmful Event Not = Rail Vehicle (train, engine), Pedestrian, Pedalcycle, Animal (live), Parked Motor Vehicle, Not a Collision Between Two Motor Vehicles

AND

First Harmful Event = Bridge Overhead Structure, Bridge Pier Or Support, Bridge Rail, Cable Barrier, Concrete Traffic Barrier, Culvert, Curb, Ditch, Embankment, Fence, Guardrail End Terminal, Guardrail Face, Impact Attentuator/Crash Cushion, Mailbox, Other Fixed Object (Wall, Building, Tunnel, etc), Other Post Pole or Support, Other Traffic Barrier, Traffic Sign Support, Tree (Standing), Utility Pole/Light Support, Unknown Fixed Object, Overturn/Rollover

The Societal Collision Cost Type filter searches the First Harmful Event for the following criteria:

Within Municipal Limits = Y

AND

Crash Type = Angle

Within Municipal Limits = Y

AND

Crash Type = Front-to-Rear

Within Municipal Limits = Y

AND

Crash Type = Sideswipe Same

Within Municipal Limits = Y

AND

Crash Type = Sideswipe Opposite

Within Municipal Limits = Y

AND

Crash Type = Front-to-Front

Within Municipal Limits = Y

AND

Crash Type = Other Multi-Vehicle

Within Municipal Limits = Y

AND

Crash Type = Angle

Within Municipal Limits = Y

AND

Crash Type = Front-to-Rear

Within Municipal Limits = Y

AND

Crash Type = Sideswipe Same

Within Municipal Limits = Y

AND

Crash Type = Sideswipe Opposite

AND

Crash Type = Front-to-Front

Within Municipal Limits = Y

AND

Crash Type = Other Multi-Vehicle

Within Municipal Limits = Y

AND

Crash Type = Angle

Within Municipal Limits = Y

AND

Crash Type = Collision With Pedestrian

Within Municipal Limits = Y

AND

Crash Type = Collision With Bicycle

Within Municipal Limits = Y

AND

Crash Type = Collision With Animal

Within Municipal Limits = Y

AND

Crash Type = Collision With Parked Vehicle

Within Municipal Limits = Y

AND

Crash Type = Collision With Fixed Object

Within Municipal Limits = Y

AND

Crash Type = Overturn

Within Municipal Limits = Y

AND

Crash Type = Other Single Vehicle

Within Municipal Limits = N

AND

Crash Type = Angle

Within Municipal Limits = N

AND

Crash Type = Collision With Pedestrian

Within Municipal Limits = N

AND

Crash Type = Collision With Bicycle

Within Municipal Limits = N

AND

Crash Type = Collision With Animal

Within Municipal Limits = N

AND

Crash Type = Collision With Parked Vehicle

Within Municipal Limits = N

AND

Crash Type = Collision With Fixed Object

Within Municipal Limits = N

AND

Crash Type = Overturn

Within Municipal Limits = N

AND

Crash Type = Other Single Vehicle