mv_crashes_all.RdA dataset containing motorcycle and moped crashes in Florida cities. The data was from two sources: the Florida Department of Transportation (FDOT) and the U.S. Census Bureau. This file shows crash locations for Long-Form-reported crashes within the state of Florida and is subset to those occurring within towns and having a county-city code assigned.
mv_crashes_allA data frame with 2,733,425 rows and 21 variables:
a unique identifier for each crash
calendar year as string
date of crash as date
four character string for time on 12 hour interval
three letter abbreviation for day of week (Mon through Sun)
Florida Department of Transportation county code
county name
four digit string unique city code
four digit string unique county city code
crash in town (Yes) or out of town (No)
injury severity (1 None; 2 Possible; 3 Non-Incapacitating; 4 Incapacitating; 5 Fatal (within 30 days); and 6 Non-traffic Fatality
motorcyle involved (Yes) or not involved (No)
integer number of persons injured
integer number of persons killed
interger number of persons seriously injured
integer number of pedestrians involved
integer number of drivers
integer number of bicyclists
integer number of vehicles
integer number of persons
integer number of impaired drivers (may mean physically or under the influence)
FDOT Open Data Hub: Crashes All
The original dataframe included 158 variables. A code sheet, while available online, did not match column names or responses. A variable like "ALCINVCD" presumably was an abbreviation for "alcohol involved" but it was omitted because no explanation could be found. Additionally, pertinent information on "helmet use" is collected on the uniform long form traffic crash report but could not be found in the variable names.
Florida Department of Highway Safety and Motor Vehicles, Uniform Traffic Crash Report Manual (Rev'd Feb. 2, 2019)