data analysis

profileQAQ474060161
DictionaryFatalMotorVehicleAccidents.xlsx

Fatal Motor Vehicle Accidents

Fatal Motor Vehicle Accidents
Data Attributes Data Type Description
Year of car crash Integer Year when the car crash happened
Month of car crash String month when the car crash happened
Day of car crash Integer day when the car crash happened
State name String name of the state where car crash happened
County name String name of the county where car crash happened
City name/County Name String name of the city or the county
Number of fatalities Integer fatalities occuring in the car accident
number of vehicle involved Integer total number of vehicles affected by the accident
Number of forms submitted for person not in motor vehices Integer forms submitted for person not in the vehicle
Number of person not in motor vehicle in transport(MVIT) Integer number of person during the accident not present in the vehicle
Number of person in motor vehicle in transport(MVIT) Integer number of person during the accident present in the vehicle
Number of forms submitted for person in motor vehices Integer forms submitted for person in the vehicle
Number of drunk drivers involved Integer drunk drivers involved
Trafficway Identifier String The name of the highway or the street
Trafficway Identifier 2 String alternate name of the highway or the street
Milepoint Integer Milepoint present near the time of accident
Latitude Decimal the latitude location of the accident
Longitude Decimal the longitude location of the accident
Day of Week String which day of the week
Crash Hour Integer time of the crash in hours
Crash Minute String time of the crash in minutes
National Highway System String the network of strategic highways within USA
Route Signing String The type of route at which the accident happpened
Special Jurisdiction String does that come under some special jurisdiction(yes or no)
First Harmful Event String the first event to occur
Manner of Collision String the angle at which the vehicles collided
Relation to Junction within interstate name String is it related to the junction(yes or no)
Relation to Junction Specific String If it is related to junction , then what type of a junction
Type of Intersection String At what type of intersection did the accident happen
Work Zone String was that a work zone?
Relation to Trafficway String where did the accident take place.(roadside, shoulder)
Light Condition String light condition at the time of accident
Atmospheric Condition String atmospheric condition at the time of accident
Atmospheric Conditions - Additional String additional atmospheric condition at the time of accident
School Bus Related String was the accident schhl bus related(yes or no)
Hour of EMS Notification String hour at Emergency Medical Service(EMS) was notified
Minute of EMS Notification String Minutes at Emergency Medical Service(EMS) was notified
EMS Arrival Hour String time at which EMS arrived(hours) at the accident spot
EMS Arrival Minute String time at which EMS arrived(Minutes) at the accident spot.
EMS Arrival at Hospital Hour String time at which EMS arrived(Hours) at the hospital
EMS Arrival at Hospital Minute String time at which EMS arrived(minutes) at the hospital
Crash Related Factor 1 String vehicle crash related factor 1
Crash Related Factor 2 String vehicle crash related factor 2
Crash Related Factor 3 String vehicle crash related factor 3
Rail Grade Crossing Identifier Integer the identifier of the rail grade crossing
Number of Motor Vehicles in Transport (MVIT) Integer motor vehiles in transport toal number
Number of Parked/Working Vehicles Integer number of parked/ woring vehicles