##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
cr= read.fst("2016_2023_FARS_Crash_CatLim.fst")
vh= read.fst("2016_2023_FARS_Vehicle_CatLim.fst")
pr= read.fst("2016_2023_FARS_Person_CatLim.fst")
df1= cr
df2= vh
df3= pr[,-c(5, 6,7)]
dim(df1)
## [1] 289233 53
## [1] 444719 92
## [1] 711230 79
# Define columns you want to keep even if they are common
keep_cols <- c("CRASH_NUM1")
# Identify all common columns
common_vars <- intersect(names(df1), names(df2))
# Subtract the ones you want to keep
vars_to_remove <- setdiff(common_vars, keep_cols)
# Remove them from df2
df2_clean <- df2 %>%
select(-all_of(vars_to_remove))
df2a= left_join(df1, df2_clean, by="CRASH_NUM1")
dim(df2a)
## [1] 444719 140
# Define columns you want to keep even if they are common
keep_cols <- c("CRASH_NUM1", "CRASH_VEH_NUM1")
# Identify all common columns
common_vars <- intersect(names(df2a), names(df3))
# Subtract the ones you want to keep
vars_to_remove <- setdiff(common_vars, keep_cols)
# Remove them from df2
df3_clean <- df3 %>%
select(-all_of(vars_to_remove))
dim(df3_clean)
## [1] 711230 59
## [1] "CRASH_NUM1" "CRASH_VEH_NUM1" "CRASH_VehPer_NUM1"
## [4] "VE_FORMS" "PER_NO" "STR_VEH"
## [7] "DAYNAME" "MINUTENAME" "MAK_MOD"
## [10] "MOD_YEARNAME" "AGENAME" "SEXNAME"
## [13] "PER_TYPNAME" "INJ_SEVNAME" "SEAT_POSNAME"
## [16] "REST_USENAME" "REST_MISNAME" "AIR_BAGNAME"
## [19] "EJECTIONNAME" "EJ_PATHNAME" "EXTRICATNAME"
## [22] "DRINKINGNAME" "ALC_DETNAME" "ALC_STATUSNAME"
## [25] "ATST_TYPNAME" "ALC_RESNAME" "DRUGSNAME"
## [28] "DRUG_DETNAME" "DSTATUSNAME" "DRUGTST1NAME"
## [31] "DRUGTST2NAME" "DRUGTST3NAME" "DRUGRES1NAME"
## [34] "DRUGRES2NAME" "DRUGRES3NAME" "HOSPITALNAME"
## [37] "DOANAME" "DEATH_DANAME" "DEATH_MONAME"
## [40] "DEATH_YRNAME" "DEATH_HRNAME" "DEATH_MNNAME"
## [43] "DEATH_TMNAME" "LAG_HRSNAME" "LAG_MINSNAME"
## [46] "P_SF1NAME" "P_SF2NAME" "P_SF3NAME"
## [49] "WORK_INJNAME" "HISPANICNAME" "RACENAME"
## [52] "LOCATIONNAME" "HELM_USENAME" "HELM_MISNAME"
## [55] "VPICMAKENAME" "VPICMODEL" "VPICMODELNAME"
## [58] "VPICBODYCLASSNAME" "ICFINALBODYNAME"
df3a= full_join(df2a, df3_clean[,-c(1)], by="CRASH_VEH_NUM1")
dim(df3a)
## [1] 713485 197
## [1] "STATE" "STATENAME" "ST_CASE"
## [4] "VE_TOTAL" "COUNTY" "COUNTYNAME"
## [7] "CITY" "CITYNAME" "DAY"
## [10] "MONTH" "MONTHNAME" "YEAR"
## [13] "DAY_WEEKNAME" "HOUR" "HOURNAME"
## [16] "NHSNAME" "ROUTENAME" "TWAY_ID"
## [19] "TWAY_ID2" "RUR_URBNAME" "FUNC_SYSNAME"
## [22] "RD_OWNERNAME" "LATITUDE" "LATITUDENAME"
## [25] "LONGITUD" "LONGITUDNAME" "SP_JURNAME"
## [28] "HARM_EVNAME" "MAN_COLLNAME" "RELJCT1NAME"
## [31] "RELJCT2NAME" "TYP_INTNAME" "WRK_ZONENAME"
## [34] "REL_ROADNAME" "LGT_CONDNAME" "WEATHER1NAME"
## [37] "WEATHER2NAME" "WEATHERNAME" "SCH_BUSNAME"
## [40] "RAILNAME" "NOT_HOURNAME" "ARR_HOUR"
## [43] "ARR_HOURNAME" "ARR_MIN" "ARR_MINNAME"
## [46] "HOSP_HR" "HOSP_HRNAME" "CF1NAME"
## [49] "CF2NAME" "CF3NAME" "FATALS"
## [52] "DRUNK_DR" "CRASH_NUM1" "CRASH_VEH_NUM1"
## [55] "VEH_NO" "NUMOCCS" "UNITTYPENAME"
## [58] "HIT_RUNNAME" "REG_STATNAME" "OWNERNAME"
## [61] "MAKENAME" "MAK_MODNAME" "BODY_TYPNAME"
## [64] "MOD_YEAR" "VINNAME" "TOW_VEHNAME"
## [67] "J_KNIFENAME" "MCARR_I1NAME" "MCARR_I2NAME"
## [70] "MCARR_IDNAME" "GVWRNAME" "V_CONFIGNAME"
## [73] "CARGO_BTNAME" "HAZ_INVNAME" "HAZ_PLACNAME"
## [76] "HAZ_IDNAME" "HAZ_CNONAME" "HAZ_RELNAME"
## [79] "BUS_USENAME" "SPEC_USENAME" "EMER_USENAME"
## [82] "TRAV_SPNAME" "UNDERIDENAME" "ROLLOVERNAME"
## [85] "ROLINLOCNAME" "IMPACT1NAME" "DEFORMEDNAME"
## [88] "TOWEDNAME" "M_HARMNAME" "VEH_SC1NAME"
## [91] "VEH_SC2NAME" "FIRE_EXPNAME" "DR_PRESNAME"
## [94] "L_STATENAME" "DR_ZIPNAME" "L_STATUSNAME"
## [97] "L_TYPENAME" "CDL_STATNAME" "L_ENDORSNAME"
## [100] "L_COMPLNAME" "L_RESTRINAME" "DR_HGT"
## [103] "DR_WGTNAME" "PREV_ACCNAME" "PREV_SUSNAME"
## [106] "PREV_DWINAME" "PREV_SPDNAME" "PREV_OTHNAME"
## [109] "FIRST_MONAME" "FIRST_YRNAME" "LAST_MONAME"
## [112] "LAST_YRNAME" "SPEEDRELNAME" "DR_SF1NAME"
## [115] "DR_SF2NAME" "DR_SF3NAME" "DR_SF4NAME"
## [118] "VTRAFWAYNAME" "VNUM_LANNAME" "VSPD_LIMNAME"
## [121] "VALIGNNAME" "VPROFILENAME" "VPAVETYPNAME"
## [124] "VSURCONDNAME" "VTRAFCONNAME" "VTCONT_FNAME"
## [127] "P_CRASH1NAME" "P_CRASH2NAME" "P_CRASH3NAME"
## [130] "PCRASH4NAME" "PCRASH5NAME" "ACC_TYPENAME"
## [133] "DEATHS" "DR_DRINKNAME" "TRLR1VINNAME"
## [136] "TRLR2VINNAME" "TRLR3VINNAME" "PREV_SUS1NAME"
## [139] "PREV_SUS2NAME" "PREV_SUS3NAME" "CRASH_VehPer_NUM1"
## [142] "VE_FORMS" "PER_NO" "STR_VEH"
## [145] "DAYNAME" "MINUTENAME" "MAK_MOD"
## [148] "MOD_YEARNAME" "AGENAME" "SEXNAME"
## [151] "PER_TYPNAME" "INJ_SEVNAME" "SEAT_POSNAME"
## [154] "REST_USENAME" "REST_MISNAME" "AIR_BAGNAME"
## [157] "EJECTIONNAME" "EJ_PATHNAME" "EXTRICATNAME"
## [160] "DRINKINGNAME" "ALC_DETNAME" "ALC_STATUSNAME"
## [163] "ATST_TYPNAME" "ALC_RESNAME" "DRUGSNAME"
## [166] "DRUG_DETNAME" "DSTATUSNAME" "DRUGTST1NAME"
## [169] "DRUGTST2NAME" "DRUGTST3NAME" "DRUGRES1NAME"
## [172] "DRUGRES2NAME" "DRUGRES3NAME" "HOSPITALNAME"
## [175] "DOANAME" "DEATH_DANAME" "DEATH_MONAME"
## [178] "DEATH_YRNAME" "DEATH_HRNAME" "DEATH_MNNAME"
## [181] "DEATH_TMNAME" "LAG_HRSNAME" "LAG_MINSNAME"
## [184] "P_SF1NAME" "P_SF2NAME" "P_SF3NAME"
## [187] "WORK_INJNAME" "HISPANICNAME" "RACENAME"
## [190] "LOCATIONNAME" "HELM_USENAME" "HELM_MISNAME"
## [193] "VPICMAKENAME" "VPICMODEL" "VPICMODELNAME"
## [196] "VPICBODYCLASSNAME" "ICFINALBODYNAME"
## STATE STATENAME ST_CASE VE_TOTAL COUNTY COUNTYNAME CITY CITYNAME
## 1 1 Alabama 10001 1 73 JEFFERSON (73) 1716 HOOVER
## 2 1 Alabama 10002 1 73 JEFFERSON (73) 1716 HOOVER
## 3 1 Alabama 10002 1 73 JEFFERSON (73) 1716 HOOVER
## 4 1 Alabama 10003 2 73 JEFFERSON (73) 0 NOT APPLICABLE
## 5 1 Alabama 10004 1 73 JEFFERSON (73) 0 NOT APPLICABLE
## 6 1 Alabama 10005 1 73 JEFFERSON (73) 3125 VESTAVIA HILLS
## DAY MONTH MONTHNAME YEAR DAY_WEEKNAME HOUR HOURNAME
## 1 1 1 January 2016 Friday 9 9:00am-9:59am
## 2 10 1 January 2016 Sunday 19 7:00pm-7:59pm
## 3 10 1 January 2016 Sunday 19 7:00pm-7:59pm
## 4 1 1 January 2016 Friday 2 2:00am-2:59am
## 5 17 1 January 2016 Sunday 21 9:00pm-9:59pm
## 6 26 1 January 2016 Tuesday 20 8:00pm-8:59pm
## NHSNAME ROUTENAME TWAY_ID TWAY_ID2 RUR_URBNAME
## 1 This section IS ON the NHS Interstate I-65 Urban
## 2 This section IS ON the NHS Interstate I-65 I-459 RAMP Urban
## 3 This section IS ON the NHS Interstate I-65 I-459 RAMP Urban
## 4 This section IS ON the NHS Interstate I-59 Urban
## 5 This section IS ON the NHS Interstate I-65 Urban
## 6 This section IS ON the NHS Interstate I-65 Urban
## FUNC_SYSNAME RD_OWNERNAME LATITUDE LATITUDENAME LONGITUD
## 1 Interstate State Highway Agency 33.42646 33.42645833 -86.81973
## 2 Interstate State Highway Agency 33.40031 33.40030556 -86.78723
## 3 Interstate State Highway Agency 33.40031 33.40030556 -86.78723
## 4 Interstate State Highway Agency 33.64924 33.64924444 -86.60726
## 5 Interstate State Highway Agency 33.42996 33.42995556 -86.82221
## 6 Interstate State Highway Agency 33.41205 33.41205 -86.80558
## LONGITUDNAME SP_JURNAME HARM_EVNAME
## 1 -86.81973056 No Special Jurisdiction Tree (Standing Only)
## 2 -86.78723333 No Special Jurisdiction Rollover/Overturn
## 3 -86.78723333 No Special Jurisdiction Rollover/Overturn
## 4 -86.60725833 No Special Jurisdiction Parked Motor Vehicle
## 5 -86.82220556 No Special Jurisdiction Concrete Traffic Barrier
## 6 -86.80557778 No Special Jurisdiction Tree (Standing Only)
## MAN_COLLNAME RELJCT1NAME
## 1 Not a Collision with Motor Vehicle In-Transport No
## 2 Not a Collision with Motor Vehicle In-Transport Yes
## 3 Not a Collision with Motor Vehicle In-Transport Yes
## 4 Not a Collision with Motor Vehicle In-Transport No
## 5 Not a Collision with Motor Vehicle In-Transport No
## 6 Not a Collision with Motor Vehicle In-Transport No
## RELJCT2NAME TYP_INTNAME WRK_ZONENAME
## 1 Non-Junction Not an Intersection None
## 2 Entrance/Exit Ramp Related Not an Intersection None
## 3 Entrance/Exit Ramp Related Not an Intersection None
## 4 Non-Junction Not an Intersection None
## 5 Non-Junction Not an Intersection None
## 6 Non-Junction Not an Intersection None
## REL_ROADNAME LGT_CONDNAME WEATHER1NAME
## 1 Outside Trafficway Daylight Clear
## 2 On Roadside Dark - Lighted Clear
## 3 On Roadside Dark - Lighted Clear
## 4 On Roadside Dark - Lighted Cloudy
## 5 On Median Dark - Lighted Clear
## 6 Outside Trafficway Dark - Lighted Rain
## WEATHER2NAME WEATHERNAME SCH_BUSNAME RAILNAME
## 1 No Additional Atmospheric Conditions Clear No Not Applicable
## 2 No Additional Atmospheric Conditions Clear No Not Applicable
## 3 No Additional Atmospheric Conditions Clear No Not Applicable
## 4 No Additional Atmospheric Conditions Cloudy No Not Applicable
## 5 No Additional Atmospheric Conditions Clear No Not Applicable
## 6 No Additional Atmospheric Conditions Rain No Not Applicable
## NOT_HOURNAME ARR_HOUR ARR_HOURNAME ARR_MIN ARR_MINNAME HOSP_HR
## 1 9:00am-9:59am 9 9:00am-9:59am 36 36 88
## 2 Unknown 20 8:00pm-8:59pm 5 5 99
## 3 Unknown 20 8:00pm-8:59pm 5 5 99
## 4 Unknown 2 2:00am-2:59am 31 31 88
## 5 Unknown 21 9:00pm-9:59pm 57 57 99
## 6 8:00pm-8:59pm 20 8:00pm-8:59pm 10 10 88
## HOSP_HRNAME CF1NAME CF2NAME CF3NAME FATALS DRUNK_DR
## 1 Not Applicable (Not Transported) None None None 1 1
## 2 Unknown None None None 1 1
## 3 Unknown None None None 1 1
## 4 Not Applicable (Not Transported) None None None 1 0
## 5 Unknown None None None 1 1
## 6 Not Applicable (Not Transported) None None None 1 0
## CRASH_NUM1 CRASH_VEH_NUM1 VEH_NO NUMOCCS
## 1 2016_10001 2016_100011 1 1
## 2 2016_10002 2016_100021 1 2
## 3 2016_10002 2016_100021 1 2
## 4 2016_10003 2016_100031 1 1
## 5 2016_10004 2016_100041 1 1
## 6 2016_10005 2016_100051 1 1
## UNITTYPENAME HIT_RUNNAME
## 1 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 2 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 3 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 4 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 5 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 6 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## REG_STATNAME
## 1 Alabama
## 2 Alabama
## 3 Alabama
## 4 Alabama
## 5 Alabama
## 6 Alabama
## OWNERNAME
## 1 Driver (in this crash) Not Registered Owner (Other Private Owner Listed)
## 2 Driver (in this crash) was Registered Owner
## 3 Driver (in this crash) was Registered Owner
## 4 Driver (in this crash) was Registered Owner
## 5 Driver (in this crash) was Registered Owner
## 6 Vehicle Registered as Business/Company/Government Vehicle
## MAKENAME MAK_MODNAME
## 1 Chevrolet Chevrolet S-10 Blazer/TrailBlazer (2002 only; for 2003 on, see 403)
## 2 Honda Honda Civic/CRX, del Sol
## 3 Honda Honda Civic/CRX, del Sol
## 4 Chevrolet Chevrolet C, K, R, V-series pickup/Silverado
## 5 Chevrolet Chevrolet C, K, R, V-series pickup/Silverado
## 6 Chevrolet Chevrolet C, K, R, V-series pickup/Silverado
## BODY_TYPNAME
## 1 Compact Utility (Utility Vehicle Categories ""Small"" and ""Midsize"")
## 2 4-door sedan, hardtop
## 3 4-door sedan, hardtop
## 4 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 5 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 6 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## MOD_YEAR VINNAME TOW_VEHNAME J_KNIFENAME
## 1 2002 1GNDS13S9225 No Trailing Units Not an Articulated Vehicle
## 2 2008 1HGFA15938L0 No Trailing Units Not an Articulated Vehicle
## 3 2008 1HGFA15938L0 No Trailing Units Not an Articulated Vehicle
## 4 2008 2GCEC13C8811 No Trailing Units Not an Articulated Vehicle
## 5 2000 2GCEC19TXY12 No Trailing Units Not an Articulated Vehicle
## 6 1995 1GCEC14Z2SZ2 No Trailing Units Not an Articulated Vehicle
## MCARR_I1NAME MCARR_I2NAME MCARR_IDNAME GVWRNAME V_CONFIGNAME
## 1 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 2 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 3 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 4 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 5 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 6 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## CARGO_BTNAME HAZ_INVNAME HAZ_PLACNAME HAZ_IDNAME HAZ_CNONAME
## 1 Not Applicable (N/A) No Not Applicable Not Applicable Not Applicable
## 2 Not Applicable (N/A) No Not Applicable Not Applicable Not Applicable
## 3 Not Applicable (N/A) No Not Applicable Not Applicable Not Applicable
## 4 Not Applicable (N/A) No Not Applicable Not Applicable Not Applicable
## 5 Not Applicable (N/A) No Not Applicable Not Applicable Not Applicable
## 6 Not Applicable (N/A) No Not Applicable Not Applicable Not Applicable
## HAZ_RELNAME BUS_USENAME SPEC_USENAME EMER_USENAME TRAV_SPNAME
## 1 Not Applicable Not a Bus No Special Use Not Applicable Unknown
## 2 Not Applicable Not a Bus No Special Use Not Applicable Unknown
## 3 Not Applicable Not a Bus No Special Use Not Applicable Unknown
## 4 Not Applicable Not a Bus No Special Use Not Applicable 070 MPH
## 5 Not Applicable Not a Bus No Special Use Not Applicable 080 MPH
## 6 Not Applicable Not a Bus No Special Use Not Applicable Unknown
## UNDERIDENAME ROLLOVERNAME
## 1 No Underride or Override Noted Rollover, Tripped by Object/Vehicle
## 2 No Underride or Override Noted Rollover, Tripped by Object/Vehicle
## 3 No Underride or Override Noted Rollover, Tripped by Object/Vehicle
## 4 No Underride or Override Noted No Rollover
## 5 No Underride or Override Noted No Rollover
## 6 No Underride or Override Noted No Rollover
## ROLINLOCNAME IMPACT1NAME DEFORMEDNAME
## 1 Outside of Trafficway 8 Clock Point Disabling Damage
## 2 On Roadside Non-Collision Disabling Damage
## 3 On Roadside Non-Collision Disabling Damage
## 4 No Rollover 12 Clock Point Disabling Damage
## 5 No Rollover 12 Clock Point Disabling Damage
## 6 No Rollover 9 Clock Point Disabling Damage
## TOWEDNAME M_HARMNAME VEH_SC1NAME
## 1 Towed Due to Disabling Damage Rollover/Overturn None
## 2 Towed Due to Disabling Damage Guardrail End None
## 3 Towed Due to Disabling Damage Guardrail End None
## 4 Towed Due to Disabling Damage Parked Motor Vehicle None
## 5 Towed Due to Disabling Damage Concrete Traffic Barrier None
## 6 Towed Due to Disabling Damage Tree (Standing Only) None
## VEH_SC2NAME FIRE_EXPNAME DR_PRESNAME L_STATENAME DR_ZIPNAME
## 1 None No or Not Reported Yes Alabama 35040
## 2 None No or Not Reported Yes Alabama 35208
## 3 None No or Not Reported Yes Alabama 35208
## 4 None No or Not Reported Yes Alabama 35128
## 5 None No or Not Reported Yes Alabama 35209
## 6 None No or Not Reported Yes Alabama 35127
## L_STATUSNAME L_TYPENAME CDL_STATNAME
## 1 Valid Full Driver License No (CDL)
## 2 Not licensed Not Licensed No (CDL)
## 3 Not licensed Not Licensed No (CDL)
## 4 Valid Full Driver License No (CDL)
## 5 Valid Full Driver License No (CDL)
## 6 Valid Full Driver License Valid
## L_ENDORSNAME
## 1 No Endorsements required for this vehicle
## 2 No Endorsements required for this vehicle
## 3 No Endorsements required for this vehicle
## 4 No Endorsements required for this vehicle
## 5 No Endorsements required for this vehicle
## 6 No Endorsements required for this vehicle
## L_COMPLNAME L_RESTRINAME DR_HGT
## 1 Valid license for this class vehicle No Restrictions or Not Applicable 68
## 2 Not licensed No Restrictions or Not Applicable 62
## 3 Not licensed No Restrictions or Not Applicable 62
## 4 Valid license for this class vehicle No Restrictions or Not Applicable 71
## 5 Valid license for this class vehicle No Restrictions or Not Applicable 72
## 6 Valid license for this class vehicle Restrictions Complied With 70
## DR_WGTNAME PREV_ACCNAME PREV_SUSNAME PREV_DWINAME PREV_SPDNAME PREV_OTHNAME
## 1 140 lbs. None None None 1 None
## 2 135 lbs. None 3 2 None 1
## 3 135 lbs. None 3 2 None 1
## 4 148 lbs. 2 None None 3 None
## 5 225 lbs. None None None 5 None
## 6 210 lbs. None None None None None
## FIRST_MONAME FIRST_YRNAME LAST_MONAME LAST_YRNAME
## 1 November 2012 November 2012
## 2 March 2013 December 2015
## 3 March 2013 December 2015
## 4 April 2011 September 2013
## 5 December 2011 January 2015
## 6 No Record No Record No Record No Record
## SPEEDRELNAME
## 1 No
## 2 Unknown
## 3 Unknown
## 4 No
## 5 No
## 6 Yes, Too Fast for Conditions
## DR_SF1NAME
## 1 Overcorrecting
## 2 None
## 3 None
## 4 None
## 5 Driver Has a Driving Record or Driver`s License From More Than One State
## 6 None
## DR_SF2NAME DR_SF3NAME DR_SF4NAME
## 1 None None None
## 2 None None None
## 3 None None None
## 4 None None None
## 5 None None None
## 6 None None None
## VTRAFWAYNAME VNUM_LANNAME
## 1 Two-Way, Divided, Unprotected (Painted > 4 Feet ) Median Three lanes
## 2 Two-Way, Divided, Positive Median Barrier Three lanes
## 3 Two-Way, Divided, Positive Median Barrier Three lanes
## 4 Two-Way, Divided, Unprotected (Painted > 4 Feet ) Median Two lanes
## 5 Two-Way, Divided, Positive Median Barrier Three lanes
## 6 Two-Way, Divided, Positive Median Barrier Three lanes
## VSPD_LIMNAME VALIGNNAME VPROFILENAME VPAVETYPNAME
## 1 60 MPH Curve Left Downhill Concrete
## 2 60 MPH Straight Level Blacktop, Bituminous, or Asphalt
## 3 60 MPH Straight Level Blacktop, Bituminous, or Asphalt
## 4 70 MPH Straight Level Blacktop, Bituminous, or Asphalt
## 5 60 MPH Curve Left Uphill Blacktop, Bituminous, or Asphalt
## 6 60 MPH Curve Right Uphill Blacktop, Bituminous, or Asphalt
## VSURCONDNAME VTRAFCONNAME VTCONT_FNAME P_CRASH1NAME
## 1 Dry No Controls No Controls Changing Lanes
## 2 Dry No Controls No Controls Going Straight
## 3 Dry No Controls No Controls Going Straight
## 4 Dry No Controls No Controls Going Straight
## 5 Dry No Controls No Controls Negotiating a Curve
## 6 Wet No Controls No Controls Changing Lanes
## P_CRASH2NAME P_CRASH3NAME
## 1 Off the edge of the road on the left side Braking and steering left
## 2 Off the edge of the road on the right side Unknown/Not Reported
## 3 Off the edge of the road on the right side Unknown/Not Reported
## 4 Off the edge of the road on the right side No Avoidance Maneuver
## 5 Off the edge of the road on the left side Unknown/Not Reported
## 6 Traveling too fast for conditions Unknown/Not Reported
## PCRASH4NAME PCRASH5NAME
## 1 Skidding laterally counterclockwise rotation Departed roadway
## 2 Precrash stability unknown Departed roadway
## 3 Precrash stability unknown Departed roadway
## 4 Tracking Departed roadway
## 5 Tracking Departed roadway
## 6 Skidding longitudinally rotation less than 30 degrees Departed roadway
## ACC_TYPENAME
## 1 B8-Single Driver-Left Roadside Departure-Avoid Collision With Veh., Ped., Anim.
## 2 A2-Single Driver-Right Roadside Departure-Control/Traction Loss
## 3 A2-Single Driver-Right Roadside Departure-Control/Traction Loss
## 4 A1-Single Driver-Right Roadside Departure-Drive Off Road
## 5 B6-Single Driver-Left Roadside Departure-Drive Off Road
## 6 A2-Single Driver-Right Roadside Departure-Control/Traction Loss
## DEATHS DR_DRINKNAME TRLR1VINNAME TRLR2VINNAME TRLR3VINNAME
## 1 1 Yes No Trailing Units No Trailing Units No Trailing Units
## 2 1 Yes No Trailing Units No Trailing Units No Trailing Units
## 3 1 Yes No Trailing Units No Trailing Units No Trailing Units
## 4 1 No No Trailing Units No Trailing Units No Trailing Units
## 5 1 Yes No Trailing Units No Trailing Units No Trailing Units
## 6 1 No No Trailing Units No Trailing Units No Trailing Units
## PREV_SUS1NAME PREV_SUS2NAME PREV_SUS3NAME CRASH_VehPer_NUM1 VE_FORMS PER_NO
## 1 <NA> <NA> <NA> 2016_1000111 1 1
## 2 <NA> <NA> <NA> 2016_1000211 1 1
## 3 <NA> <NA> <NA> 2016_1000212 1 2
## 4 <NA> <NA> <NA> 2016_1000311 1 1
## 5 <NA> <NA> <NA> 2016_1000411 1 1
## 6 <NA> <NA> <NA> 2016_1000511 1 1
## STR_VEH DAYNAME MINUTENAME
## 1 0 1 25
## 2 0 10 59
## 3 0 10 59
## 4 0 1 20
## 5 0 17 45
## 6 0 26 7
## MAK_MOD
## 1 Chevrolet S-10 Blazer/TrailBlazer (2002 only; for 2003 on, see 403)
## 2 Honda Civic/CRX, del Sol
## 3 Honda Civic/CRX, del Sol
## 4 Chevrolet C, K, R, V-series pickup/Silverado
## 5 Chevrolet C, K, R, V-series pickup/Silverado
## 6 Chevrolet C, K, R, V-series pickup/Silverado
## MOD_YEARNAME AGENAME SEXNAME PER_TYPNAME
## 1 2002 37 Years Female Driver of a Motor Vehicle In-Transport
## 2 2008 24 Years Male Driver of a Motor Vehicle In-Transport
## 3 2008 22 Years Male Passenger of a Motor Vehicle In-Transport
## 4 2008 22 Years Male Driver of a Motor Vehicle In-Transport
## 5 2000 36 Years Male Driver of a Motor Vehicle In-Transport
## 6 1995 59 Years Male Driver of a Motor Vehicle In-Transport
## INJ_SEVNAME SEAT_POSNAME REST_USENAME
## 1 Fatal Injury (K) Front Seat, Left Side None Used
## 2 Suspected Serious Injury(A) Front Seat, Left Side None Used
## 3 Fatal Injury (K) Front Seat, Right Side None Used
## 4 Fatal Injury (K) Front Seat, Left Side None Used
## 5 Fatal Injury (K) Front Seat, Left Side Unknown
## 6 Fatal Injury (K) Front Seat, Left Side Shoulder and Lap Belt Used
## REST_MISNAME AIR_BAGNAME EJECTIONNAME
## 1 No Not Deployed Partially Ejected
## 2 No Deployed- Combination Not Ejected
## 3 No Deployed- Combination Not Ejected
## 4 No Deployed- Front Not Ejected
## 5 No Deployed- Front Not Ejected
## 6 No Deployed- Front Partially Ejected
## EJ_PATHNAME EXTRICATNAME
## 1 Ejection Path Unknown Not Extricated or Not Applicable
## 2 Ejection Path Not Applicable Not Extricated or Not Applicable
## 3 Ejection Path Not Applicable Not Extricated or Not Applicable
## 4 Ejection Path Not Applicable Not Extricated or Not Applicable
## 5 Ejection Path Not Applicable Not Extricated or Not Applicable
## 6 Ejection Path Unknown Not Extricated or Not Applicable
## DRINKINGNAME ALC_DETNAME
## 1 Yes (Alcohol Involved) Evidential Test (breath, blood, urine)
## 2 Yes (Alcohol Involved) Observed
## 3 Not Reported Not Reported
## 4 Unknown (Police Reported) Not Reported
## 5 Yes (Alcohol Involved) Observed
## 6 No (Alcohol Not Involved) Not Reported
## ALC_STATUSNAME ATST_TYPNAME ALC_RESNAME DRUGSNAME
## 1 Test Given Blood 0.070 % BAC Yes (drugs involved)
## 2 Test Given Blood 0.161 % BAC No (drugs not involved)
## 3 Test Not Given Test Not Given Test Not Given Not Reported
## 4 Test Not Given Test Not Given Test Not Given Unknown
## 5 Test Not Given Test Not Given Test Not Given No (drugs not involved)
## 6 Test Not Given Test Not Given Test Not Given No (drugs not involved)
## DRUG_DETNAME DSTATUSNAME DRUGTST1NAME DRUGTST2NAME
## 1 Evidential Test (Blood, Urine) Test Given Blood Blood
## 2 Not Reported Test Given Blood Test Not Given
## 3 Not Reported Test Not Given Test Not Given Test Not Given
## 4 Not Reported Test Not Given Test Not Given Test Not Given
## 5 Not Reported Test Not Given Test Not Given Test Not Given
## 6 Not Reported Test Not Given Test Not Given Test Not Given
## DRUGTST3NAME DRUGRES1NAME DRUGRES2NAME DRUGRES3NAME
## 1 Test Not Given AMPHETAMINE METHAMPHETAMINE Test Not Given
## 2 Test Not Given Tested, No Drugs Found/Negative Test Not Given Test Not Given
## 3 Test Not Given Test Not Given Test Not Given Test Not Given
## 4 Test Not Given Test Not Given Test Not Given Test Not Given
## 5 Test Not Given Test Not Given Test Not Given Test Not Given
## 6 Test Not Given Test Not Given Test Not Given Test Not Given
## HOSPITALNAME DOANAME DEATH_DANAME
## 1 Not Transported Died at Scene 1
## 2 EMS Ground Not Applicable Not Applicable (Non-Fatal)
## 3 Not Transported Died at Scene 10
## 4 Not Transported Died at Scene 1
## 5 EMS Ground Not Applicable 17
## 6 Not Transported Died at Scene 26
## DEATH_MONAME DEATH_YRNAME
## 1 January 2016
## 2 Not Applicable (Non-Fatal) Not Applicable (Non-fatal)
## 3 January 2016
## 4 January 2016
## 5 January 2016
## 6 January 2016
## DEATH_HRNAME DEATH_MNNAME
## 1 Unknown Unknown
## 2 Not Applicable (Non-fatal) Not Applicable (Non-fatal)
## 3 19:00-19:59 59
## 4 2:00-2:59 20
## 5 22:00-22:59 42
## 6 20:00-20:59 7
## DEATH_TMNAME LAG_HRSNAME LAG_MINSNAME P_SF1NAME P_SF2NAME
## 1 Unknown Unknown Unknown None None
## 2 Not Applicable (Non-fatal) Unknown Unknown None None
## 3 1959 0 0 None None
## 4 220 0 0 None None
## 5 2242 0 57 None None
## 6 2007 0 0 None None
## P_SF3NAME WORK_INJNAME
## 1 None No
## 2 None Not Applicable (not a fatality)
## 3 None No
## 4 None No
## 5 None No
## 6 None No
## HISPANICNAME
## 1 Non-Hispanic
## 2 Not A Fatality (not Applicable)
## 3 Hispanic, Origin Not Specified or Other Origin
## 4 Non-Hispanic
## 5 Hispanic, Origin Not Specified or Other Origin
## 6 Non-Hispanic
## RACENAME LOCATIONNAME HELM_USENAME
## 1 White Occupant of a Motor Vehicle <NA>
## 2 Not a Fatality (not Applicable) Occupant of a Motor Vehicle <NA>
## 3 White Occupant of a Motor Vehicle <NA>
## 4 White Occupant of a Motor Vehicle <NA>
## 5 White Occupant of a Motor Vehicle <NA>
## 6 White Occupant of a Motor Vehicle <NA>
## HELM_MISNAME VPICMAKENAME VPICMODEL VPICMODELNAME VPICBODYCLASSNAME
## 1 <NA> <NA> NA <NA> <NA>
## 2 <NA> <NA> NA <NA> <NA>
## 3 <NA> <NA> NA <NA> <NA>
## 4 <NA> <NA> NA <NA> <NA>
## 5 <NA> <NA> NA <NA> <NA>
## 6 <NA> <NA> NA <NA> <NA>
## ICFINALBODYNAME
## 1 <NA>
## 2 <NA>
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
library(fst)
df3_anti <- df3a %>%
anti_join(df3, by = "CRASH_VehPer_NUM1")
dim(df3_anti)
## [1] 2255 197
## [1] 2255
## STATE STATENAME ST_CASE VE_TOTAL COUNTY COUNTYNAME CITY
## 1 1 Alabama 10283 2 93 MARION (93) 1540
## 2 1 Alabama 10593 2 97 MOBILE (97) 2100
## 3 1 Alabama 10691 2 97 MOBILE (97) 2100
## 4 1 Alabama 10897 2 97 MOBILE (97) 0
## 5 4 Arizona 40710 2 1 APACHE (1) 0
## 6 4 Arizona 40818 2 3 COCHISE (3) 0
## 7 5 Arkansas 50089 2 91 MILLER (91) 3810
## 8 5 Arkansas 50288 3 63 INDEPENDENCE (63) 0
## 9 6 California 60034 2 37 LOS ANGELES (37) 1840
## 10 6 California 60058 3 47 MERCED (47) 0
## CITYNAME DAY MONTH MONTHNAME YEAR DAY_WEEKNAME HOUR HOURNAME
## 1 HAMILTON 23 5 May 2016 Monday 8 8:00am-8:59am
## 2 MOBILE 29 9 September 2016 Thursday 21 9:00pm-9:59pm
## 3 MOBILE 23 10 October 2016 Sunday 13 1:00pm-1:59pm
## 4 NOT APPLICABLE 19 7 July 2016 Tuesday 2 2:00am-2:59am
## 5 NOT APPLICABLE 1 11 November 2016 Tuesday 19 7:00pm-7:59pm
## 6 NOT APPLICABLE 17 12 December 2016 Saturday 19 7:00pm-7:59pm
## 7 TEXARKANA 19 3 March 2016 Saturday 0 0:00am-0:59am
## 8 NOT APPLICABLE 25 8 August 2016 Thursday 7 7:00am-7:59am
## 9 LANCASTER 17 1 January 2016 Sunday 22 10:00pm-10:59pm
## 10 NOT APPLICABLE 23 1 January 2016 Saturday 20 8:00pm-8:59pm
## NHSNAME ROUTENAME TWAY_ID
## 1 This section IS NOT on the NHS U.S. Highway US-SR 171
## 2 This section IS ON the NHS Interstate I-65
## 3 This section IS ON the NHS Interstate I-65
## 4 This section IS NOT on the NHS State Highway SR-193
## 5 This section IS ON the NHS Interstate I-40
## 6 This section IS ON the NHS State Highway SR-80
## 7 This section IS ON the NHS Interstate I-30-11
## 8 This section IS NOT on the NHS State Highway SR-106-01S
## 9 This section IS NOT on the NHS Local Street - Municipality SIERRA HWY
## 10 This section IS NOT on the NHS County Road CR-CENTER AVE
## TWAY_ID2 RUR_URBNAME FUNC_SYSNAME RD_OWNERNAME
## 1 Rural Minor Arterial State Highway Agency
## 2 Urban Interstate State Highway Agency
## 3 Urban Principal Arterial - Other State Highway Agency
## 4 Rural Principal Arterial - Other State Highway Agency
## 5 Rural Interstate State Highway Agency
## 6 Rural Principal Arterial - Other State Highway Agency
## 7 Urban Interstate State Highway Agency
## 8 Rural Minor Collector State Highway Agency
## 9 Urban Principal Arterial - Other Not Reported
## 10 CR-COTTON RD Rural Principal Arterial - Other Not Reported
## LATITUDE LATITUDENAME LONGITUD LONGITUDNAME SP_JURNAME
## 1 34.12881 34.12880556 -87.98989 -87.98989167 No Special Jurisdiction
## 2 30.70692 30.70692222 -88.12232 -88.12231944 No Special Jurisdiction
## 3 30.72535 30.72535278 -88.12013 -88.120125 No Special Jurisdiction
## 4 30.51823 30.51823056 -88.12353 -88.12353056 No Special Jurisdiction
## 5 35.04634 35.04634444 -109.80606 -109.80605556 National Park Service
## 6 31.46664 31.46664444 -109.95893 -109.95892778 No Special Jurisdiction
## 7 33.50781 33.50780833 -93.94886 -93.94886389 No Special Jurisdiction
## 8 35.79131 35.79131111 -91.79044 -91.79043889 No Special Jurisdiction
## 9 34.71693 34.716925 -118.13961 -118.13961111 No Special Jurisdiction
## 10 37.01290 37.0129 -120.85497 -120.85497222 No Special Jurisdiction
## HARM_EVNAME MAN_COLLNAME
## 1 Pedestrian Not a Collision with Motor Vehicle In-Transport
## 2 Pedestrian Not a Collision with Motor Vehicle In-Transport
## 3 Pedestrian Not a Collision with Motor Vehicle In-Transport
## 4 Pedestrian Not a Collision with Motor Vehicle In-Transport
## 5 Motor Vehicle In-Transport Sideswipe - Same Direction
## 6 Motor Vehicle In-Transport Angle
## 7 Fire/Explosion Not a Collision with Motor Vehicle In-Transport
## 8 Motor Vehicle In-Transport Front-to-Rear
## 9 Pedestrian Not a Collision with Motor Vehicle In-Transport
## 10 Motor Vehicle In-Transport Sideswipe - Same Direction
## RELJCT1NAME RELJCT2NAME TYP_INTNAME WRK_ZONENAME REL_ROADNAME
## 1 No Non-Junction Not an Intersection None On Roadway
## 2 No Non-Junction Not an Intersection None On Roadway
## 3 No Non-Junction Not an Intersection None On Roadway
## 4 No Non-Junction Not an Intersection None On Roadway
## 5 No Non-Junction Not an Intersection None On Roadway
## 6 No Non-Junction Not an Intersection None On Roadway
## 7 No Non-Junction Not an Intersection None On Roadway
## 8 No Non-Junction Not an Intersection None On Roadway
## 9 No Non-Junction Not an Intersection None On Roadway
## 10 No Non-Junction Not an Intersection None On Roadway
## LGT_CONDNAME WEATHER1NAME WEATHER2NAME
## 1 Daylight Clear No Additional Atmospheric Conditions
## 2 Dark - Lighted Clear No Additional Atmospheric Conditions
## 3 Daylight Clear No Additional Atmospheric Conditions
## 4 Dark - Not Lighted Clear No Additional Atmospheric Conditions
## 5 Dark - Not Lighted Cloudy No Additional Atmospheric Conditions
## 6 Dark - Not Lighted Clear No Additional Atmospheric Conditions
## 7 Dark - Not Lighted Rain No Additional Atmospheric Conditions
## 8 Daylight Clear No Additional Atmospheric Conditions
## 9 Dark - Lighted Cloudy No Additional Atmospheric Conditions
## 10 Dark - Not Lighted Cloudy No Additional Atmospheric Conditions
## WEATHERNAME SCH_BUSNAME RAILNAME NOT_HOURNAME
## 1 Clear No Not Applicable 8:00am-8:59am
## 2 Clear No Not Applicable 9:00pm-9:59pm
## 3 Clear No Not Applicable 1:00pm-1:59pm
## 4 Clear No Not Applicable Unknown
## 5 Cloudy No Not Applicable 7:00pm-7:59pm
## 6 Clear No Not Applicable 7:00pm-7:59pm
## 7 Rain No Not Applicable Not Applicable (Not Notified)
## 8 Clear No Not Applicable 7:00am-7:59am
## 9 Cloudy No Not Applicable Unknown
## 10 Cloudy No Not Applicable Unknown
## ARR_HOUR ARR_HOURNAME ARR_MIN
## 1 8 8:00am-8:59am 47
## 2 21 9:00pm-9:59pm 16
## 3 13 1:00pm-1:59pm 24
## 4 2 2:00am-2:59am 16
## 5 20 8:00pm-8:59pm 22
## 6 19 7:00pm-7:59pm 46
## 7 88 Not Applicable 88
## 8 7 7:00am-7:59am 28
## 9 99 Unknown EMS Scene Arrival Hour 99
## 10 99 Unknown EMS Scene Arrival Hour 99
## ARR_MINNAME HOSP_HR HOSP_HRNAME
## 1 47 88 Not Applicable (Not Transported)
## 2 16 21 9:00pm-9:59pm
## 3 24 88 Not Applicable (Not Transported)
## 4 16 88 Not Applicable (Not Transported)
## 5 22 88 Not Applicable (Not Transported)
## 6 46 21 9:00pm-9:59pm
## 7 Not Applicable 88 Not Applicable (Not Transported)
## 8 28 8 8:00am-8:59am
## 9 Unknown EMS Scene Arrival Minutes 88 Not Applicable (Not Transported)
## 10 Unknown EMS Scene Arrival Minutes 88 Not Applicable (Not Transported)
## CF1NAME
## 1 None
## 2 Recent/Previous Crash scene Nearby
## 3 None
## 4 Indication of a Stalled/Disabled Vehicle
## 5 Indication of a Stalled/Disabled Vehicle
## 6 Recent/Previous Crash scene Nearby
## 7 Recent/Previous Crash scene Nearby
## 8 Recent/Previous Crash scene Nearby
## 9 None
## 10 None
## CF2NAME
## 1 None
## 2 None
## 3 None
## 4 None
## 5 None
## 6 Indication of a Stalled/Disabled Vehicle
## 7 None
## 8 None
## 9 None
## 10 None
## CF3NAME
## 1 None
## 2 None
## 3 None
## 4 None
## 5 None
## 6 Non-occupant struck by falling cargo, or something that came loose from, or something that was set in motion by a vehicle
## 7 None
## 8 None
## 9 None
## 10 None
## FATALS DRUNK_DR CRASH_NUM1 CRASH_VEH_NUM1 VEH_NO NUMOCCS
## 1 1 0 2016_10283 2016_102832 2 0
## 2 1 0 2016_10593 2016_105932 2 0
## 3 1 0 2016_10691 2016_106911 1 0
## 4 1 0 2016_10897 2016_108972 2 0
## 5 1 0 2016_40710 2016_407101 1 0
## 6 1 0 2016_40818 2016_408182 2 0
## 7 1 0 2016_50089 2016_500892 2 0
## 8 1 0 2016_50288 2016_502882 2 0
## 9 1 0 2016_60034 2016_600341 1 0
## 10 1 1 2016_60058 2016_600582 2 0
## UNITTYPENAME HIT_RUNNAME
## 1 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 2 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 3 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 4 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 5 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 6 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 7 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 8 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 9 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## 10 Motor Vehicle In-Transport (Inside or Outside the Trafficway) No
## REG_STATNAME OWNERNAME
## 1 Alabama Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 2 Mississippi Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 3 Alabama Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 4 Alabama Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 5 Arkansas Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 6 Arizona Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 7 Louisiana Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 8 Arkansas Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 9 No Registration Driverless/Motor Vehicle Parked/Stopped Off Roadway
## 10 California Driverless/Motor Vehicle Parked/Stopped Off Roadway
## MAKENAME MAK_MODNAME
## 1 GMC GMC C, K, R, V-series pickup/ Sierra
## 2 Chevrolet Chevrolet Impala/Caprice (For SS from 2014 on, use 20-021.)
## 3 Ford Ford F-Series pickup
## 4 Chevrolet Chevrolet Avalanche
## 5 Dodge Dodge Ram Pickup
## 6 GMC GMC Fullsize Jimmy/Yukon
## 7 Chevrolet Chevrolet S-10/T-10 Pickup
## 8 Chevrolet Chevrolet C, K, R, V-series pickup/Silverado
## 9 Unknown Make Unknown Make Unknown cc
## 10 Land Rover Land Rover Range Rover
## BODY_TYPNAME
## 1 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 2 4-door sedan, hardtop
## 3 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 4 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 5 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 6 Large utility (ANSI D16.1 Utility Vehicle Categories and ""Full Size"" and ""Large"")
## 7 Compact pickup (GVWR <4,500 lbs.) (D50,Colt P/U, Ram 50, Dakota, Arrow Pickup [foreign], Ranger, ..)
## 8 Standard pickup (GVWR 4,500 to 10,00 lbs.)(Jeep Pickup, Comanche, Ram Pickup, D100-D350,....)
## 9 Other motored cycle type (mini-bikes, motor scooters, pocket motorcycles, ""pocket bikes"")
## 10 Large utility (ANSI D16.1 Utility Vehicle Categories and ""Full Size"" and ""Large"")
## MOD_YEAR VINNAME TOW_VEHNAME J_KNIFENAME
## 1 2003 2GTEK19T3311 No Trailing Units Not an Articulated Vehicle
## 2 2002 2G1WH55K5293 No Trailing Units Not an Articulated Vehicle
## 3 2008 1FTRF12298KE No Trailing Units Not an Articulated Vehicle
## 4 2008 3GNEC12078G2 No Trailing Units Not an Articulated Vehicle
## 5 2010 1D7RV1CT1AS2 One Trailing Unit No
## 6 2008 2GTEK13M5811 No Trailing Units Not an Articulated Vehicle
## 7 2000 1GCCS144XY81 No Trailing Units Not an Articulated Vehicle
## 8 2008 1GCHK39KX8E1 No Trailing Units Not an Articulated Vehicle
## 9 9999 204BG130114 No Trailing Units Not an Articulated Vehicle
## 10 1990 SALHV1243LA4 No Trailing Units Not an Articulated Vehicle
## MCARR_I1NAME MCARR_I2NAME MCARR_IDNAME GVWRNAME V_CONFIGNAME
## 1 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 2 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 3 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 4 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 5 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 6 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 7 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 8 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 9 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## 10 Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable
## CARGO_BTNAME HAZ_INVNAME HAZ_PLACNAME HAZ_IDNAME
## 1 Not Applicable (N/A) No Not Applicable Not Applicable
## 2 Not Applicable (N/A) No Not Applicable Not Applicable
## 3 Not Applicable (N/A) No Not Applicable Not Applicable
## 4 Not Applicable (N/A) No Not Applicable Not Applicable
## 5 Not Applicable (N/A) No Not Applicable Not Applicable
## 6 Not Applicable (N/A) No Not Applicable Not Applicable
## 7 Not Applicable (N/A) No Not Applicable Not Applicable
## 8 Not Applicable (N/A) No Not Applicable Not Applicable
## 9 Not Applicable (N/A) No Not Applicable Not Applicable
## 10 Not Applicable (N/A) No Not Applicable Not Applicable
## HAZ_CNONAME HAZ_RELNAME BUS_USENAME SPEC_USENAME EMER_USENAME
## 1 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 2 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 3 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 4 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 5 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 6 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 7 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 8 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 9 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## 10 Not Applicable Not Applicable Not a Bus No Special Use Not Applicable
## TRAV_SPNAME UNDERIDENAME
## 1 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 2 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 3 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 4 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 5 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 6 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 7 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 8 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## 9 Not Reported No Underride or Override Noted
## 10 Stopped Motor Vehicle In- Transport No Underride or Override Noted
## ROLLOVERNAME ROLINLOCNAME IMPACT1NAME DEFORMEDNAME
## 1 No Rollover No Rollover 6 Clock Point Disabling Damage
## 2 No Rollover No Rollover 3 Clock Point Disabling Damage
## 3 No Rollover No Rollover 6 Clock Point Disabling Damage
## 4 No Rollover No Rollover 9 Clock Point Functional Damage
## 5 No Rollover No Rollover Left-Back Side Disabling Damage
## 6 No Rollover No Rollover Right-Back Side Disabling Damage
## 7 No Rollover No Rollover Non-Collision Disabling Damage
## 8 No Rollover No Rollover 6 Clock Point Disabling Damage
## 9 No Rollover No Rollover Not Reported Disabling Damage
## 10 No Rollover No Rollover 5 Clock Point Disabling Damage
## TOWEDNAME M_HARMNAME VEH_SC1NAME
## 1 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 2 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 3 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 4 Towed Not Due to Disabling Damage Motor Vehicle In-Transport None
## 5 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 6 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 7 Towed Due to Disabling Damage Fire/Explosion None
## 8 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 9 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## 10 Towed Due to Disabling Damage Motor Vehicle In-Transport None
## VEH_SC2NAME FIRE_EXPNAME DR_PRESNAME
## 1 None No or Not Reported No Driver Present/Not Applicable
## 2 None No or Not Reported No Driver Present/Not Applicable
## 3 None No or Not Reported No Driver Present/Not Applicable
## 4 None No or Not Reported No Driver Present/Not Applicable
## 5 None No or Not Reported No Driver Present/Not Applicable
## 6 None No or Not Reported No Driver Present/Not Applicable
## 7 None Yes No Driver Present/Not Applicable
## 8 None No or Not Reported No Driver Present/Not Applicable
## 9 None No or Not Reported No Driver Present/Not Applicable
## 10 None No or Not Reported No Driver Present/Not Applicable
## L_STATENAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## DR_ZIPNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## L_STATUSNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## L_TYPENAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## CDL_STATNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## L_ENDORSNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## L_COMPLNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## L_RESTRINAME DR_HGT
## 1 No Driver Present/Unknown if Driver Present 998
## 2 No Driver Present/Unknown if Driver Present 998
## 3 No Driver Present/Unknown if Driver Present 998
## 4 No Driver Present/Unknown if Driver Present 998
## 5 No Driver Present/Unknown if Driver Present 998
## 6 No Driver Present/Unknown if Driver Present 998
## 7 No Driver Present/Unknown if Driver Present 998
## 8 No Driver Present/Unknown if Driver Present 998
## 9 No Driver Present/Unknown if Driver Present 998
## 10 No Driver Present/Unknown if Driver Present 998
## DR_WGTNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## PREV_ACCNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## PREV_SUSNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## PREV_DWINAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## PREV_SPDNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## PREV_OTHNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## FIRST_MONAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## FIRST_YRNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## LAST_MONAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## LAST_YRNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## SPEEDRELNAME
## 1 No Driver Present/Unknown if Driver Present
## 2 No Driver Present/Unknown if Driver Present
## 3 No Driver Present/Unknown if Driver Present
## 4 No Driver Present/Unknown if Driver Present
## 5 No Driver Present/Unknown if Driver Present
## 6 No Driver Present/Unknown if Driver Present
## 7 No Driver Present/Unknown if Driver Present
## 8 No Driver Present/Unknown if Driver Present
## 9 No Driver Present/Unknown if Driver Present
## 10 No Driver Present/Unknown if Driver Present
## DR_SF1NAME
## 1 None
## 2 None
## 3 None
## 4 None
## 5 Stopped in Roadway (Vehicle Not Abandoned)
## 6 Leaving Vehicle Unattended with Engine Running. Leaving Vehicle Unattended in Roadway
## 7 None
## 8 None
## 9 None
## 10 None
## DR_SF2NAME DR_SF3NAME DR_SF4NAME
## 1 None None None
## 2 None None None
## 3 None None None
## 4 None None None
## 5 None None None
## 6 None None None
## 7 None None None
## 8 None None None
## 9 None None None
## 10 None None None
## VTRAFWAYNAME
## 1 Two-Way, Not Divided With a Continuous Left-Turn Lane
## 2 Two-Way, Divided, Positive Median Barrier
## 3 Two-Way, Divided, Positive Median Barrier
## 4 Non-Trafficway or Driveway Access
## 5 Two-Way, Divided, Unprotected (Painted > 4 Feet ) Median
## 6 Two-Way, Not Divided
## 7 Two-Way, Divided, Positive Median Barrier
## 8 Two-Way, Not Divided
## 9 Two-Way, Not Divided
## 10 Two-Way, Not Divided
## VNUM_LANNAME
## 1 Five lanes
## 2 Four lanes
## 3 Three lanes
## 4 Non-Trafficway or Driveway Access
## 5 Two lanes
## 6 Two lanes
## 7 Two lanes
## 8 Two lanes
## 9 Two lanes
## 10 Two lanes
## VSPD_LIMNAME
## 1 45 MPH
## 2 65 MPH
## 3 65 MPH
## 4 No Statutory Limit/Non-Trafficway or Driveway Access
## 5 75 MPH
## 6 55 MPH
## 7 65 MPH
## 8 40 MPH
## 9 55 MPH
## 10 55 MPH
## VALIGNNAME VPROFILENAME
## 1 Straight Downhill
## 2 Straight Downhill
## 3 Straight Level
## 4 Non-Trafficway or Driveway Access Non-Trafficway or Driveway Access
## 5 Straight Downhill
## 6 Curve Right Downhill
## 7 Straight Level
## 8 Straight Uphill
## 9 Straight Not Reported
## 10 Straight Level
## VPAVETYPNAME VSURCONDNAME
## 1 Blacktop, Bituminous, or Asphalt Dry
## 2 Concrete Dry
## 3 Blacktop, Bituminous, or Asphalt Dry
## 4 Non-Trafficway or Driveway Access Non-Trafficway or Driveway Access
## 5 Blacktop, Bituminous, or Asphalt Dry
## 6 Blacktop, Bituminous, or Asphalt Dry
## 7 Blacktop, Bituminous, or Asphalt Wet
## 8 Blacktop, Bituminous, or Asphalt Dry
## 9 Blacktop, Bituminous, or Asphalt Dry
## 10 Not Reported Dry
## VTRAFCONNAME VTCONT_FNAME P_CRASH1NAME
## 1 No Controls No Controls No Driver Present / Unknown if Driver Present
## 2 No Controls No Controls No Driver Present / Unknown if Driver Present
## 3 No Controls No Controls No Driver Present / Unknown if Driver Present
## 4 No Controls No Controls No Driver Present / Unknown if Driver Present
## 5 No Controls No Controls No Driver Present / Unknown if Driver Present
## 6 No Controls No Controls No Driver Present / Unknown if Driver Present
## 7 No Controls No Controls No Driver Present / Unknown if Driver Present
## 8 No Controls No Controls No Driver Present / Unknown if Driver Present
## 9 No Controls No Controls No Driver Present / Unknown if Driver Present
## 10 No Controls No Controls No Driver Present / Unknown if Driver Present
## P_CRASH2NAME
## 1 Traveling in same direction with higher speed
## 2 From adjacent lane (same direction) over left lane line
## 3 Traveling in same direction with higher speed
## 4 Traveling in same direction with higher speed
## 5 Traveling in same direction with higher speed
## 6 Traveling in same direction with higher speed
## 7 Other critical precrash event (specify:)
## 8 Traveling in same direction with higher speed
## 9 Crossing over (passing through) Junction
## 10 Traveling in same direction with higher speed
## P_CRASH3NAME
## 1 No Driver Present / Unknown if Driver Present
## 2 No Driver Present / Unknown if Driver Present
## 3 No Driver Present / Unknown if Driver Present
## 4 No Driver Present / Unknown if Driver Present
## 5 No Driver Present / Unknown if Driver Present
## 6 No Driver Present / Unknown if Driver Present
## 7 No Driver Present / Unknown if Driver Present
## 8 No Driver Present / Unknown if Driver Present
## 9 No Driver Present / Unknown if Driver Present
## 10 No Driver Present / Unknown if Driver Present
## PCRASH4NAME
## 1 No Driver Present / Unknown if Driver Present
## 2 No Driver Present / Unknown if Driver Present
## 3 No Driver Present / Unknown if Driver Present
## 4 No Driver Present / Unknown if Driver Present
## 5 No Driver Present / Unknown if Driver Present
## 6 No Driver Present / Unknown if Driver Present
## 7 No Driver Present / Unknown if Driver Present
## 8 No Driver Present / Unknown if Driver Present
## 9 No Driver Present / Unknown if Driver Present
## 10 No Driver Present / Unknown if Driver Present
## PCRASH5NAME
## 1 No Driver Present / Unknown if Driver Present
## 2 No Driver Present / Unknown if Driver Present
## 3 No Driver Present / Unknown if Driver Present
## 4 No Driver Present / Unknown if Driver Present
## 5 No Driver Present / Unknown if Driver Present
## 6 No Driver Present / Unknown if Driver Present
## 7 No Driver Present / Unknown if Driver Present
## 8 No Driver Present / Unknown if Driver Present
## 9 No Driver Present / Unknown if Driver Present
## 10 No Driver Present / Unknown if Driver Present
## ACC_TYPENAME DEATHS
## 1 M98-Other Crash Type 0
## 2 M98-Other Crash Type 0
## 3 M98-Other Crash Type 0
## 4 M98-Other Crash Type 0
## 5 F48-Same Trafficway, Same Direction-Angle, Sideswipe-Specifics Other 0
## 6 F48-Same Trafficway, Same Direction-Angle, Sideswipe-Specifics Other 0
## 7 M0-No Impact 0
## 8 D32-Same Trafficway, Same Direction-Rear End-Specifics Other 0
## 9 M98-Other Crash Type 0
## 10 F48-Same Trafficway, Same Direction-Angle, Sideswipe-Specifics Other 0
## DR_DRINKNAME TRLR1VINNAME TRLR2VINNAME TRLR3VINNAME
## 1 No No Trailing Units No Trailing Units No Trailing Units
## 2 No No Trailing Units No Trailing Units No Trailing Units
## 3 No No Trailing Units No Trailing Units No Trailing Units
## 4 No No Trailing Units No Trailing Units No Trailing Units
## 5 No Not Reported No Trailing Units No Trailing Units
## 6 No No Trailing Units No Trailing Units No Trailing Units
## 7 No No Trailing Units No Trailing Units No Trailing Units
## 8 No No Trailing Units No Trailing Units No Trailing Units
## 9 No No Trailing Units No Trailing Units No Trailing Units
## 10 No No Trailing Units No Trailing Units No Trailing Units
## PREV_SUS1NAME PREV_SUS2NAME PREV_SUS3NAME CRASH_VehPer_NUM1 VE_FORMS PER_NO
## 1 <NA> <NA> <NA> <NA> NA NA
## 2 <NA> <NA> <NA> <NA> NA NA
## 3 <NA> <NA> <NA> <NA> NA NA
## 4 <NA> <NA> <NA> <NA> NA NA
## 5 <NA> <NA> <NA> <NA> NA NA
## 6 <NA> <NA> <NA> <NA> NA NA
## 7 <NA> <NA> <NA> <NA> NA NA
## 8 <NA> <NA> <NA> <NA> NA NA
## 9 <NA> <NA> <NA> <NA> NA NA
## 10 <NA> <NA> <NA> <NA> NA NA
## STR_VEH DAYNAME MINUTENAME MAK_MOD MOD_YEARNAME AGENAME SEXNAME PER_TYPNAME
## 1 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 2 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 3 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 4 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 5 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 6 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 7 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 8 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 9 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## 10 NA NA <NA> <NA> <NA> <NA> <NA> <NA>
## INJ_SEVNAME SEAT_POSNAME REST_USENAME REST_MISNAME AIR_BAGNAME EJECTIONNAME
## 1 <NA> <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA> <NA>
## EJ_PATHNAME EXTRICATNAME DRINKINGNAME ALC_DETNAME ALC_STATUSNAME
## 1 <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA>
## ATST_TYPNAME ALC_RESNAME DRUGSNAME DRUG_DETNAME DSTATUSNAME DRUGTST1NAME
## 1 <NA> <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA> <NA>
## DRUGTST2NAME DRUGTST3NAME DRUGRES1NAME DRUGRES2NAME DRUGRES3NAME
## 1 <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA>
## HOSPITALNAME DOANAME DEATH_DANAME DEATH_MONAME DEATH_YRNAME DEATH_HRNAME
## 1 <NA> <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA> <NA>
## DEATH_MNNAME DEATH_TMNAME LAG_HRSNAME LAG_MINSNAME P_SF1NAME P_SF2NAME
## 1 <NA> <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA> <NA>
## P_SF3NAME WORK_INJNAME HISPANICNAME RACENAME LOCATIONNAME HELM_USENAME
## 1 <NA> <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA> <NA>
## 3 <NA> <NA> <NA> <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA> <NA>
## 7 <NA> <NA> <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA> <NA> <NA>
## 10 <NA> <NA> <NA> <NA> <NA> <NA>
## HELM_MISNAME VPICMAKENAME VPICMODEL VPICMODELNAME VPICBODYCLASSNAME
## 1 <NA> <NA> NA <NA> <NA>
## 2 <NA> <NA> NA <NA> <NA>
## 3 <NA> <NA> NA <NA> <NA>
## 4 <NA> <NA> NA <NA> <NA>
## 5 <NA> <NA> NA <NA> <NA>
## 6 <NA> <NA> NA <NA> <NA>
## 7 <NA> <NA> NA <NA> <NA>
## 8 <NA> <NA> NA <NA> <NA>
## 9 <NA> <NA> NA <NA> <NA>
## 10 <NA> <NA> NA <NA> <NA>
## ICFINALBODYNAME
## 1 <NA>
## 2 <NA>
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
### write.fst(df3a, "2016_2023_FARS_Crash_Veh_Pers_Lim_norep.fst")
table(df3a$HELM_USENAME)
##
## DOT-Compliant Motorcycle Helmet
## 9350
## Helmet, Other than DOT-Compliant Motorcycle Helmet
## 913
## Helmet, Unknown if DOT-Compliant
## 9521
## No Helmet
## 14902
## Not a Motor Vehicle Occupant
## 44146
## Not Applicable
## 374038
## Not Reported
## 802
## Reported as Unknown if Helmet Worn
## 900
df_filtered <- df3a %>%
group_by(CRASH_NUM1) %>%
filter(any(HELM_USENAME== "No Helmet")) %>%
ungroup()
dim(df_filtered)
## [1] 95182 197
table(df_filtered$HELM_USENAME)
##
## DOT-Compliant Motorcycle Helmet
## 199
## Helmet, Other than DOT-Compliant Motorcycle Helmet
## 32
## Helmet, Unknown if DOT-Compliant
## 229
## No Helmet
## 14902
## Not a Motor Vehicle Occupant
## 44146
## Not Applicable
## 11264
## Not Reported
## 43
## Reported as Unknown if Helmet Worn
## 50