library(dplyr)
library(summarytools)
library(fst)
library(DT)
dat= read.fst("2016_2023_FARS_Crash_Veh_Pers_Lim_norepFin.fst")
dim(dat)
## [1] 713485 194
## [1] "CRASH_NUM1" "STATE" "STATENAME"
## [4] "ST_CASE" "VE_TOTAL" "COUNTY"
## [7] "COUNTYNAME" "CITY" "CITYNAME"
## [10] "DAY" "MONTH" "MONTHNAME"
## [13] "YEAR" "DAY_WEEKNAME" "HOUR"
## [16] "HOURNAME" "NHSNAME" "ROUTENAME"
## [19] "TWAY_ID" "TWAY_ID2" "RUR_URBNAME"
## [22] "FUNC_SYSNAME" "RD_OWNERNAME" "LATITUDE"
## [25] "LATITUDENAME" "LONGITUD" "LONGITUDNAME"
## [28] "SP_JURNAME" "HARM_EVNAME" "MAN_COLLNAME"
## [31] "RELJCT1NAME" "RELJCT2NAME" "TYP_INTNAME"
## [34] "WRK_ZONENAME" "REL_ROADNAME" "LGT_CONDNAME"
## [37] "WEATHER1NAME" "WEATHER2NAME" "WEATHERNAME"
## [40] "SCH_BUSNAME" "RAILNAME" "NOT_HOURNAME"
## [43] "ARR_HOUR" "ARR_HOURNAME" "ARR_MIN"
## [46] "ARR_MINNAME" "HOSP_HR" "HOSP_HRNAME"
## [49] "CF1NAME" "CF2NAME" "CF3NAME"
## [52] "FATALS" "DRUNK_DR" "VEH_NO"
## [55] "CRASH_VEH_NUM1" "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] "PER_NO" "STR_VEH" "MAK_MOD"
## [145] "MOD_YEARNAME" "AGENAME" "SEXNAME"
## [148] "PER_TYPNAME" "INJ_SEVNAME" "SEAT_POSNAME"
## [151] "REST_USENAME" "REST_MISNAME" "AIR_BAGNAME"
## [154] "EJECTIONNAME" "EJ_PATHNAME" "EXTRICATNAME"
## [157] "DRINKINGNAME" "ALC_DETNAME" "ALC_STATUSNAME"
## [160] "ATST_TYPNAME" "ALC_RESNAME" "DRUGSNAME"
## [163] "DRUG_DETNAME" "DSTATUSNAME" "DRUGTST1NAME"
## [166] "DRUGTST2NAME" "DRUGTST3NAME" "DRUGRES1NAME"
## [169] "DRUGRES2NAME" "DRUGRES3NAME" "HOSPITALNAME"
## [172] "DOANAME" "DEATH_DANAME" "DEATH_MONAME"
## [175] "DEATH_YRNAME" "DEATH_HRNAME" "DEATH_MNNAME"
## [178] "DEATH_TMNAME" "LAG_HRSNAME" "LAG_MINSNAME"
## [181] "P_SF1NAME" "P_SF2NAME" "P_SF3NAME"
## [184] "WORK_INJNAME" "HISPANICNAME" "RACENAME"
## [187] "LOCATIONNAME" "HELM_USENAME" "HELM_MISNAME"
## [190] "VPICMAKENAME" "VPICMODEL" "VPICMODELNAME"
## [193] "VPICBODYCLASSNAME" "ICFINALBODYNAME"
dat <- dat %>%
mutate(across(where(is.character), ~ iconv(., from = "", to = "UTF-8", sub = "byte")))
dat1 <- dat %>%
group_by(CRASH_NUM1) %>%
filter(any(SPEEDRELNAME=="Yes, Exceeded Speed Limit"|
SPEEDRELNAME=="Yes, Specifics Unknown"|
SPEEDRELNAME=="Yes, Too Fast for Condition")) %>%
ungroup()
dim(dat1)
## [1] 104772 194
dat1 <- dat1 %>%
group_by(CRASH_NUM1) %>%
filter(any(WEATHERNAME=="Rain")) %>%
ungroup()
dim(dat1)
## [1] 5145 194
dat2= dat1[, c("CRASH_NUM1", "CRASH_VEH_NUM1",
"CRASH_VehPer_NUM1", "YEAR", "STATENAME",
"COUNTYNAME", "CITYNAME", "LATITUDE",
"LONGITUD", "DAY", "MONTHNAME", "DAY_WEEKNAME",
"HOUR", "HOURNAME", "VE_TOTAL", "VEH_NO", "PER_NO",
"NUMOCCS", "ROUTENAME", "RUR_URBNAME", "FUNC_SYSNAME",
"RD_OWNERNAME", "HARM_EVNAME", "MAN_COLLNAME",
"TYP_INTNAME", "LGT_CONDNAME", "WEATHERNAME",
"CF1NAME", "BODY_TYPNAME", "TRAV_SPNAME", "M_HARMNAME",
"L_RESTRINAME", "SPEEDRELNAME", "DR_SF1NAME",
"VTRAFWAYNAME", "VNUM_LANNAME", "VSPD_LIMNAME",
"VALIGNNAME", "VPROFILENAME", "VSURCONDNAME",
"VTRAFCONNAME", "VTCONT_FNAME", "P_CRASH1NAME",
"ACC_TYPENAME", "AGENAME", "SEXNAME", "ALC_RESNAME",
"WORK_INJNAME", "HISPANICNAME", "RACENAME")]
dim(dat2)
## [1] 5145 50
##datatable(
## dat2, extensions = 'Buttons', options = list(
## dom = 'Bfrtip',
## buttons = c('csv', 'excel')
## )
##)
library(openxlsx)
# Create a new workbook
wb <- createWorkbook()
# Add sheets and write data
addWorksheet(wb, "Sheet1")
writeData(wb, "Sheet1", dat1)
addWorksheet(wb, "Sheet2")
writeData(wb, "Sheet2", dat2)
# Save workbook
saveWorkbook(wb, "2016_2023_SpeedingRain_Fatal.xlsx", overwrite = TRUE)
#### DESC STAT
# Step 1: Filter to variables with ≤ 80 unique values
unique_counts <- sapply(dat1, function(x) length(unique(x)))
filtered_vars <- names(unique_counts[unique_counts <= 50])
dat_filtered <- dat1[, filtered_vars]
# Step 2: Reorder all values within each variable by frequency (even numeric treated as categorical)
dat_reordered <- as.data.frame(lapply(dat_filtered, function(x) {
if (is.numeric(x)) {
x <- factor(x) # treat numeric as categorical
}
if (is.factor(x) || is.character(x)) {
freq_order <- names(sort(table(x), decreasing = TRUE))
x <- factor(x, levels = freq_order)
}
return(x)
}))
# Step 3: Show summary
dfSummary(dat_reordered,
style = "grid",
plain.ascii = FALSE,
graph.col = FALSE, max.distinct.values = 50)
## ### Data Frame Summary
## #### dat_reordered
## **Dimensions:** 5145 x 152
## **Duplicates:** 0
##
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | No | Variable | Stats / Values | Freqs (% of Valid) | Valid | Missing |
## +=====+====================+=================================+====================+==========+=========+
## | 1 | VE_TOTAL\ | 1\. 1\ | 2114 (41.1%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 2\ | 2004 (39.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 616 (12.0%)\ | | |
## | | | 4\. 4\ | 195 ( 3.8%)\ | | |
## | | | 5\. 5\ | 130 ( 2.5%)\ | | |
## | | | 6\. 7\ | 44 ( 0.9%)\ | | |
## | | | 7\. 6\ | 16 ( 0.3%)\ | | |
## | | | 8\. 13\ | 15 ( 0.3%)\ | | |
## | | | 9\. 8\ | 8 ( 0.2%)\ | | |
## | | | 10\. 9 | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 2 | DAY\ | 1\. 26\ | 209 (4.1%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 3\ | 205 (4.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 10\ | 203 (3.9%)\ | | |
## | | | 4\. 22\ | 202 (3.9%)\ | | |
## | | | 5\. 2\ | 197 (3.8%)\ | | |
## | | | 6\. 24\ | 194 (3.8%)\ | | |
## | | | 7\. 21\ | 192 (3.7%)\ | | |
## | | | 8\. 28\ | 192 (3.7%)\ | | |
## | | | 9\. 25\ | 187 (3.6%)\ | | |
## | | | 10\. 1\ | 182 (3.5%)\ | | |
## | | | 11\. 17\ | 181 (3.5%)\ | | |
## | | | 12\. 23\ | 177 (3.4%)\ | | |
## | | | 13\. 30\ | 177 (3.4%)\ | | |
## | | | 14\. 5\ | 171 (3.3%)\ | | |
## | | | 15\. 6\ | 170 (3.3%)\ | | |
## | | | 16\. 20\ | 168 (3.3%)\ | | |
## | | | 17\. 9\ | 163 (3.2%)\ | | |
## | | | 18\. 15\ | 161 (3.1%)\ | | |
## | | | 19\. 27\ | 161 (3.1%)\ | | |
## | | | 20\. 4\ | 160 (3.1%)\ | | |
## | | | 21\. 29\ | 159 (3.1%)\ | | |
## | | | 22\. 18\ | 152 (3.0%)\ | | |
## | | | 23\. 7\ | 150 (2.9%)\ | | |
## | | | 24\. 13\ | 146 (2.8%)\ | | |
## | | | 25\. 16\ | 144 (2.8%)\ | | |
## | | | 26\. 8\ | 140 (2.7%)\ | | |
## | | | 27\. 12\ | 136 (2.6%)\ | | |
## | | | 28\. 19\ | 134 (2.6%)\ | | |
## | | | 29\. 11\ | 130 (2.5%)\ | | |
## | | | 30\. 14\ | 112 (2.2%)\ | | |
## | | | 31\. 31 | 90 (1.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 3 | MONTH\ | 1\. 10\ | 590 (11.5%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 12\ | 560 (10.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 5\ | 517 (10.0%)\ | | |
## | | | 4\. 11\ | 439 ( 8.5%)\ | | |
## | | | 5\. 3\ | 418 ( 8.1%)\ | | |
## | | | 6\. 4\ | 405 ( 7.9%)\ | | |
## | | | 7\. 1\ | 403 ( 7.8%)\ | | |
## | | | 8\. 9\ | 379 ( 7.4%)\ | | |
## | | | 9\. 2\ | 378 ( 7.3%)\ | | |
## | | | 10\. 6\ | 378 ( 7.3%)\ | | |
## | | | 11\. 8\ | 341 ( 6.6%)\ | | |
## | | | 12\. 7 | 337 ( 6.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 4 | MONTHNAME\ | 1\. October\ | 590 (11.5%)\ | 5145\ | 0\ |
## | | [factor] | 2\. December\ | 560 (10.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. May\ | 517 (10.0%)\ | | |
## | | | 4\. November\ | 439 ( 8.5%)\ | | |
## | | | 5\. March\ | 418 ( 8.1%)\ | | |
## | | | 6\. April\ | 405 ( 7.9%)\ | | |
## | | | 7\. January\ | 403 ( 7.8%)\ | | |
## | | | 8\. September\ | 379 ( 7.4%)\ | | |
## | | | 9\. February\ | 378 ( 7.3%)\ | | |
## | | | 10\. June\ | 378 ( 7.3%)\ | | |
## | | | 11\. August\ | 341 ( 6.6%)\ | | |
## | | | 12\. July | 337 ( 6.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 5 | YEAR\ | 1\. 2023\ | 749 (14.6%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 2021\ | 675 (13.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2017\ | 641 (12.5%)\ | | |
## | | | 4\. 2018\ | 637 (12.4%)\ | | |
## | | | 5\. 2020\ | 625 (12.1%)\ | | |
## | | | 6\. 2022\ | 620 (12.1%)\ | | |
## | | | 7\. 2019\ | 616 (12.0%)\ | | |
## | | | 8\. 2016 | 582 (11.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 6 | DAY_WEEKNAME\ | 1\. Saturday\ | 977 (19.0%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Sunday\ | 855 (16.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Friday\ | 803 (15.6%)\ | | |
## | | | 4\. Thursday\ | 664 (12.9%)\ | | |
## | | | 5\. Monday\ | 638 (12.4%)\ | | |
## | | | 6\. Tuesday\ | 614 (11.9%)\ | | |
## | | | 7\. Wednesday | 594 (11.5%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 7 | HOUR\ | 1\. 22\ | 365 (7.1%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 1\ | 318 (6.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 20\ | 315 (6.1%)\ | | |
## | | | 4\. 17\ | 295 (5.7%)\ | | |
## | | | 5\. 18\ | 280 (5.4%)\ | | |
## | | | 6\. 2\ | 273 (5.3%)\ | | |
## | | | 7\. 23\ | 271 (5.3%)\ | | |
## | | | 8\. 21\ | 260 (5.1%)\ | | |
## | | | 9\. 19\ | 244 (4.7%)\ | | |
## | | | 10\. 0\ | 236 (4.6%)\ | | |
## | | | 11\. 15\ | 229 (4.5%)\ | | |
## | | | 12\. 16\ | 221 (4.3%)\ | | |
## | | | 13\. 3\ | 216 (4.2%)\ | | |
## | | | 14\. 14\ | 186 (3.6%)\ | | |
## | | | 15\. 13\ | 177 (3.4%)\ | | |
## | | | 16\. 12\ | 162 (3.1%)\ | | |
## | | | 17\. 7\ | 160 (3.1%)\ | | |
## | | | 18\. 10\ | 156 (3.0%)\ | | |
## | | | 19\. 6\ | 145 (2.8%)\ | | |
## | | | 20\. 5\ | 138 (2.7%)\ | | |
## | | | 21\. 4\ | 136 (2.6%)\ | | |
## | | | 22\. 9\ | 136 (2.6%)\ | | |
## | | | 23\. 8\ | 108 (2.1%)\ | | |
## | | | 24\. 11\ | 100 (1.9%)\ | | |
## | | | 25\. 99 | 18 (0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 8 | HOURNAME\ | 1\. 10:00pm-10:59pm\ | 365 (7.1%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 1:00am-1:59am\ | 318 (6.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 8:00pm-8:59pm\ | 315 (6.1%)\ | | |
## | | | 4\. 5:00pm-5:59pm\ | 295 (5.7%)\ | | |
## | | | 5\. 6:00pm-6:59pm\ | 280 (5.4%)\ | | |
## | | | 6\. 2:00am-2:59am\ | 273 (5.3%)\ | | |
## | | | 7\. 11:00pm-11:59pm\ | 271 (5.3%)\ | | |
## | | | 8\. 9:00pm-9:59pm\ | 260 (5.1%)\ | | |
## | | | 9\. 7:00pm-7:59pm\ | 244 (4.7%)\ | | |
## | | | 10\. 0:00am-0:59am\ | 236 (4.6%)\ | | |
## | | | 11\. 3:00pm-3:59pm\ | 229 (4.5%)\ | | |
## | | | 12\. 4:00pm-4:59pm\ | 221 (4.3%)\ | | |
## | | | 13\. 3:00am-3:59am\ | 216 (4.2%)\ | | |
## | | | 14\. 2:00pm-2:59pm\ | 186 (3.6%)\ | | |
## | | | 15\. 1:00pm-1:59pm\ | 177 (3.4%)\ | | |
## | | | 16\. 12:00pm-12:59pm\ | 162 (3.1%)\ | | |
## | | | 17\. 7:00am-7:59am\ | 160 (3.1%)\ | | |
## | | | 18\. 10:00am-10:59am\ | 156 (3.0%)\ | | |
## | | | 19\. 6:00am-6:59am\ | 145 (2.8%)\ | | |
## | | | 20\. 5:00am-5:59am\ | 138 (2.7%)\ | | |
## | | | 21\. 4:00am-4:59am\ | 136 (2.6%)\ | | |
## | | | 22\. 9:00am-9:59am\ | 136 (2.6%)\ | | |
## | | | 23\. 8:00am-8:59am\ | 108 (2.1%)\ | | |
## | | | 24\. 11:00am-11:59am\ | 100 (1.9%)\ | | |
## | | | 25\. Unknown Hours | 18 (0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 9 | NHSNAME\ | 1\. This section IS NOT on th\ | 2595 (50.4%)\ | 5145\ | 0\ |
## | | [factor] | 2\. This section IS ON the NH\ | 1769 (34.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. This Section IS NOT on th\ | 433 ( 8.4%)\ | | |
## | | | 4\. This Section IS ON the NH\ | 315 ( 6.1%)\ | | |
## | | | 5\. Unknown if this section i\ | 32 ( 0.6%)\ | | |
## | | | 6\. Unknown if This Section I | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 10 | ROUTENAME\ | 1\. State Highway\ | 1436 (27.9%)\ | 5145\ | 0\ |
## | | [factor] | 2\. U.S. Highway\ | 824 (16.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Local Street - Municipali\ | 814 (15.8%)\ | | |
## | | | 4\. Interstate\ | 647 (12.6%)\ | | |
## | | | 5\. County Road\ | 629 (12.2%)\ | | |
## | | | 6\. Other\ | 243 ( 4.7%)\ | | |
## | | | 7\. Local Street - Township\ | 181 ( 3.5%)\ | | |
## | | | 8\. Municipal\ | 103 ( 2.0%)\ | | |
## | | | 9\. County\ | 100 ( 1.9%)\ | | |
## | | | 10\. Not Signed\ | 72 ( 1.4%)\ | | |
## | | | 11\. Secondary Route\ | 31 ( 0.6%)\ | | |
## | | | 12\. Local Street - Frontage R\ | 29 ( 0.6%)\ | | |
## | | | 13\. Unknown\ | 15 ( 0.3%)\ | | |
## | | | 14\. Township\ | 10 ( 0.2%)\ | | |
## | | | 15\. Unknown/Not Reported\ | 10 ( 0.2%)\ | | |
## | | | 16\. Trafficway Not in State I | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 11 | RUR_URBNAME\ | 1\. Urban\ | 3236 (62.9%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Rural\ | 1899 (36.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Trafficway Not in State I\ | 7 ( 0.1%)\ | | |
## | | | 4\. Not Reported | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 12 | FUNC_SYSNAME\ | 1\. Principal Arterial - Othe\ | 1306 (25.4%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Minor Arterial\ | 1190 (23.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Major Collector\ | 762 (14.8%)\ | | |
## | | | 4\. Interstate\ | 666 (12.9%)\ | | |
## | | | 5\. Local\ | 617 (12.0%)\ | | |
## | | | 6\. Other Principal Arterial\ | 240 ( 4.7%)\ | | |
## | | | 7\. Principal Arterial - Othe\ | 168 ( 3.3%)\ | | |
## | | | 8\. Minor Collector\ | 158 ( 3.1%)\ | | |
## | | | 9\. Other Freeways and Expres\ | 30 ( 0.6%)\ | | |
## | | | 10\. Trafficway Not in State I\ | 7 ( 0.1%)\ | | |
## | | | 11\. Not Reported | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 13 | RD_OWNERNAME\ | 1\. State Highway Agency\ | 2842 (55.2%)\ | 5145\ | 0\ |
## | | [factor] | 2\. City or Municipal Highway\ | 802 (15.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 600 (11.7%)\ | | |
## | | | 4\. County Highway Agency\ | 596 (11.6%)\ | | |
## | | | 5\. Town or Township Highway \ | 188 ( 3.7%)\ | | |
## | | | 6\. State Toll Road\ | 42 ( 0.8%)\ | | |
## | | | 7\. Unknown\ | 42 ( 0.8%)\ | | |
## | | | 8\. Trafficway Not in State I\ | 7 ( 0.1%)\ | | |
## | | | 9\. National Park Service\ | 6 ( 0.1%)\ | | |
## | | | 10\. Bureau of Indian Affairs\ | 5 ( 0.1%)\ | | |
## | | | 11\. Other Local Agency\ | 5 ( 0.1%)\ | | |
## | | | 12\. Other State Agency\ | 5 ( 0.1%)\ | | |
## | | | 13\. Local Toll Authority\ | 2 ( 0.0%)\ | | |
## | | | 14\. Railroad\ | 2 ( 0.0%)\ | | |
## | | | 15\. Indian Tribe Nation | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 14 | SP_JURNAME\ | 1\. No Special Jurisdiction\ | 5111 (99.3%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Indian Reservation\ | 15 ( 0.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. National Park Service\ | 10 ( 0.2%)\ | | |
## | | | 4\. Unknown\ | 6 ( 0.1%)\ | | |
## | | | 5\. College/University Campus | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 15 | HARM_EVNAME\ | 1\. Motor Vehicle In-Transpor\ | 2630 (51.1%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Tree (Standing Only)\ | 575 (11.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Pedestrian\ | 295 ( 5.7%)\ | | |
## | | | 4\. Curb\ | 209 ( 4.1%)\ | | |
## | | | 5\. Rollover/Overturn\ | 203 ( 3.9%)\ | | |
## | | | 6\. Guardrail Face\ | 181 ( 3.5%)\ | | |
## | | | 7\. Utility Pole/Light Suppor\ | 162 ( 3.1%)\ | | |
## | | | 8\. Ditch\ | 125 ( 2.4%)\ | | |
## | | | 9\. Embankment\ | 120 ( 2.3%)\ | | |
## | | | 10\. Concrete Traffic Barrier\ | 79 ( 1.5%)\ | | |
## | | | 11\. Traffic Sign Support\ | 76 ( 1.5%)\ | | |
## | | | 12\. Culvert\ | 65 ( 1.3%)\ | | |
## | | | 13\. Parked Motor Vehicle\ | 57 ( 1.1%)\ | | |
## | | | 14\. Fence\ | 55 ( 1.1%)\ | | |
## | | | 15\. Other Fixed Object\ | 39 ( 0.8%)\ | | |
## | | | 16\. Mail Box\ | 36 ( 0.7%)\ | | |
## | | | 17\. Guardrail End\ | 25 ( 0.5%)\ | | |
## | | | 18\. Pedalcyclist\ | 25 ( 0.5%)\ | | |
## | | | 19\. Post, Pole or Other Suppo\ | 22 ( 0.4%)\ | | |
## | | | 20\. Bridge Rail (Includes par\ | 15 ( 0.3%)\ | | |
## | | | 21\. Building\ | 15 ( 0.3%)\ | | |
## | | | 22\. Boulder\ | 14 ( 0.3%)\ | | |
## | | | 23\. Bridge Pier or Support\ | 14 ( 0.3%)\ | | |
## | | | 24\. Other Object (not fixed)\ | 11 ( 0.2%)\ | | |
## | | | 25\. Cable Barrier\ | 10 ( 0.2%)\ | | |
## | | | 26\. Ground\ | 10 ( 0.2%)\ | | |
## | | | 27\. Non-Motorist on Personal \ | 10 ( 0.2%)\ | | |
## | | | 28\. Other Traffic Barrier\ | 9 ( 0.2%)\ | | |
## | | | 29\. Traffic Signal Support\ | 8 ( 0.2%)\ | | |
## | | | 30\. Shrubbery\ | 6 ( 0.1%)\ | | |
## | | | 31\. Live Animal\ | 5 ( 0.1%)\ | | |
## | | | 32\. Immersion or Partial Imme\ | 4 ( 0.1%)\ | | |
## | | | 33\. Railway Vehicle\ | 4 ( 0.1%)\ | | |
## | | | 34\. Snow Bank\ | 4 ( 0.1%)\ | | |
## | | | 35\. Other Non-Collision\ | 3 ( 0.1%)\ | | |
## | | | 36\. Pavement Surface Irregula\ | 3 ( 0.1%)\ | | |
## | | | 37\. Wall\ | 3 ( 0.1%)\ | | |
## | | | 38\. Working Motor Vehicle\ | 3 ( 0.1%)\ | | |
## | | | 39\. Fire Hydrant\ | 2 ( 0.0%)\ | | |
## | | | 40\. Motor Vehicle In-Transpor\ | 2 ( 0.0%)\ | | |
## | | | 41\. Ridden Animal or Animal D\ | 2 ( 0.0%)\ | | |
## | | | 42\. Thrown or Falling Object\ | 2 ( 0.0%)\ | | |
## | | | 43\. Unknown Fixed Object\ | 2 ( 0.0%)\ | | |
## | | | 44\. Unknown Object Not Fixed\ | 2 ( 0.0%)\ | | |
## | | | 45\. Bridge Overhead Structure\ | 1 ( 0.0%)\ | | |
## | | | 46\. Fell/Jumped from Vehicle\ | 1 ( 0.0%)\ | | |
## | | | 47\. Jackknife (harmful to thi | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 16 | MAN_COLLNAME\ | 1\. The First Harmful Event w\ | 1588 (30.9%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Angle\ | 1245 (24.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not a Collision with Moto\ | 925 (18.0%)\ | | |
## | | | 4\. Front-to-Front\ | 613 (11.9%)\ | | |
## | | | 5\. Front-to-Rear\ | 497 ( 9.7%)\ | | |
## | | | 6\. Sideswipe - Same Directio\ | 141 ( 2.7%)\ | | |
## | | | 7\. Sideswipe - Opposite Dire\ | 51 ( 1.0%)\ | | |
## | | | 8\. Other\ | 34 ( 0.7%)\ | | |
## | | | 9\. Rear-to-Side\ | 27 ( 0.5%)\ | | |
## | | | 10\. Not Reported\ | 22 ( 0.4%)\ | | |
## | | | 11\. Unknown | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 17 | RELJCT1NAME\ | 1\. No\ | 4908 (95.4%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Yes | 237 ( 4.6%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 18 | RELJCT2NAME\ | 1\. Non-Junction\ | 3563 (69.3%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Intersection\ | 826 (16.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Intersection-Related\ | 426 ( 8.3%)\ | | |
## | | | 4\. Driveway Access Related\ | 110 ( 2.1%)\ | | |
## | | | 5\. Entrance/Exit Ramp Relate\ | 64 ( 1.2%)\ | | |
## | | | 6\. Other location within Int\ | 54 ( 1.0%)\ | | |
## | | | 7\. Through Roadway\ | 47 ( 0.9%)\ | | |
## | | | 8\. Driveway Access\ | 20 ( 0.4%)\ | | |
## | | | 9\. Crossover-Related\ | 12 ( 0.2%)\ | | |
## | | | 10\. Railway Grade Crossing\ | 10 ( 0.2%)\ | | |
## | | | 11\. Entrance/Exit Ramp\ | 5 ( 0.1%)\ | | |
## | | | 12\. Not Reported\ | 5 ( 0.1%)\ | | |
## | | | 13\. Acceleration/Deceleration | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 19 | TYP_INTNAME\ | 1\. Not an Intersection\ | 3888 (75.6%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Four-Way Intersection\ | 837 (16.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. T-Intersection\ | 368 ( 7.2%)\ | | |
## | | | 4\. Y-Intersection\ | 22 ( 0.4%)\ | | |
## | | | 5\. Five Point, or More\ | 14 ( 0.3%)\ | | |
## | | | 6\. Traffic Circle\ | 6 ( 0.1%)\ | | |
## | | | 7\. Not Reported\ | 5 ( 0.1%)\ | | |
## | | | 8\. L-Intersection\ | 3 ( 0.1%)\ | | |
## | | | 9\. Roundabout | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 20 | WRK_ZONENAME\ | 1\. None\ | 5071 (98.6%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Construction\ | 51 ( 1.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Work Zone, Type Unknown\ | 18 ( 0.3%)\ | | |
## | | | 4\. Maintenance | 5 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 21 | REL_ROADNAME\ | 1\. On Roadway\ | 2988 (58.1%)\ | 5145\ | 0\ |
## | | [factor] | 2\. On Roadside\ | 1674 (32.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. On Median\ | 279 ( 5.4%)\ | | |
## | | | 4\. Outside Trafficway\ | 105 ( 2.0%)\ | | |
## | | | 5\. On Shoulder\ | 29 ( 0.6%)\ | | |
## | | | 6\. In Parking Lane/Zone\ | 22 ( 0.4%)\ | | |
## | | | 7\. Gore\ | 15 ( 0.3%)\ | | |
## | | | 8\. Separator\ | 13 ( 0.3%)\ | | |
## | | | 9\. Off Roadway-Location Unkn\ | 11 ( 0.2%)\ | | |
## | | | 10\. Pedestrian Refuge Island \ | 5 ( 0.1%)\ | | |
## | | | 11\. Continuous Left - Turn La\ | 3 ( 0.1%)\ | | |
## | | | 12\. Reported as Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 22 | LGT_CONDNAME\ | 1\. Daylight\ | 1951 (37.9%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Dark - Lighted\ | 1463 (28.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Dark - Not Lighted\ | 1445 (28.1%)\ | | |
## | | | 4\. Dusk\ | 134 ( 2.6%)\ | | |
## | | | 5\. Dawn\ | 105 ( 2.0%)\ | | |
## | | | 6\. Dark - Unknown Lighting\ | 43 ( 0.8%)\ | | |
## | | | 7\. Reported as Unknown\ | 3 ( 0.1%)\ | | |
## | | | 8\. Other | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 23 | WEATHER1NAME\ | 1\. Rain\ | 2435 (98.3%)\ | 2476\ | 2669\ |
## | | [factor] | 2\. Cloudy\ | 39 ( 1.6%)\ | (48.1%) | (51.9%) |
## | | | 3\. Fog, Smog, Smoke | 2 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 24 | WEATHER2NAME\ | 1\. No Additional Atmospheric\ | 2299 (92.9%)\ | 2476\ | 2669\ |
## | | [factor] | 2\. Cloudy\ | 115 ( 4.6%)\ | (48.1%) | (51.9%) |
## | | | 3\. Rain\ | 41 ( 1.7%)\ | | |
## | | | 4\. Fog, Smog, Smoke\ | 20 ( 0.8%)\ | | |
## | | | 5\. Severe Crosswinds | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 25 | WEATHERNAME\ | 1\. Rain | 5145 (100.0%) | 5145\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 26 | SCH_BUSNAME\ | 1\. No\ | 5126 (99.6%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Yes | 19 ( 0.4%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 27 | RAILNAME\ | 1\. Not Applicable\ | 5135 (99.8%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 080046G\ | 3 ( 0.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. 254739M\ | 3 ( 0.1%)\ | | |
## | | | 4\. 540206P\ | 2 ( 0.0%)\ | | |
## | | | 5\. 607425U | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 28 | NOT_HOURNAME\ | 1\. Unknown\ | 2455 (47.7%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 8:00pm-8:59pm\ | 177 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 10:00pm-10:59pm\ | 176 ( 3.4%)\ | | |
## | | | 4\. 5:00pm-5:59pm\ | 171 ( 3.3%)\ | | |
## | | | 5\. 6:00pm-6:59pm\ | 152 ( 3.0%)\ | | |
## | | | 6\. 9:00pm-9:59pm\ | 152 ( 3.0%)\ | | |
## | | | 7\. 1:00am-1:59am\ | 151 ( 2.9%)\ | | |
## | | | 8\. 2:00am-2:59am\ | 151 ( 2.9%)\ | | |
## | | | 9\. 7:00pm-7:59pm\ | 128 ( 2.5%)\ | | |
## | | | 10\. 4:00pm-4:59pm\ | 120 ( 2.3%)\ | | |
## | | | 11\. 3:00pm-3:59pm\ | 112 ( 2.2%)\ | | |
## | | | 12\. 3:00am-3:59am\ | 109 ( 2.1%)\ | | |
## | | | 13\. 0:00am-0:59am\ | 107 ( 2.1%)\ | | |
## | | | 14\. 11:00pm-11:59pm\ | 105 ( 2.0%)\ | | |
## | | | 15\. 10:00am-10:59am\ | 90 ( 1.7%)\ | | |
## | | | 16\. 7:00am-7:59am\ | 88 ( 1.7%)\ | | |
## | | | 17\. 6:00am-6:59am\ | 86 ( 1.7%)\ | | |
## | | | 18\. 2:00pm-2:59pm\ | 81 ( 1.6%)\ | | |
## | | | 19\. 5:00am-5:59am\ | 77 ( 1.5%)\ | | |
## | | | 20\. 9:00am-9:59am\ | 76 ( 1.5%)\ | | |
## | | | 21\. 1:00pm-1:59pm\ | 74 ( 1.4%)\ | | |
## | | | 22\. 12:00pm-12:59pm\ | 69 ( 1.3%)\ | | |
## | | | 23\. 8:00am-8:59am\ | 64 ( 1.2%)\ | | |
## | | | 24\. Not Applicable (Not Notif\ | 60 ( 1.2%)\ | | |
## | | | 25\. 11:00am-11:59am\ | 59 ( 1.1%)\ | | |
## | | | 26\. 4:00am-4:59am | 55 ( 1.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 29 | ARR_HOUR\ | 1\. 99\ | 2514 (48.9%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 20\ | 176 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 17\ | 173 ( 3.4%)\ | | |
## | | | 4\. 18\ | 163 ( 3.2%)\ | | |
## | | | 5\. 22\ | 159 ( 3.1%)\ | | |
## | | | 6\. 2\ | 156 ( 3.0%)\ | | |
## | | | 7\. 21\ | 151 ( 2.9%)\ | | |
## | | | 8\. 1\ | 132 ( 2.6%)\ | | |
## | | | 9\. 16\ | 128 ( 2.5%)\ | | |
## | | | 10\. 3\ | 114 ( 2.2%)\ | | |
## | | | 11\. 23\ | 114 ( 2.2%)\ | | |
## | | | 12\. 19\ | 111 ( 2.2%)\ | | |
## | | | 13\. 0\ | 97 ( 1.9%)\ | | |
## | | | 14\. 10\ | 89 ( 1.7%)\ | | |
## | | | 15\. 14\ | 88 ( 1.7%)\ | | |
## | | | 16\. 7\ | 87 ( 1.7%)\ | | |
## | | | 17\. 6\ | 86 ( 1.7%)\ | | |
## | | | 18\. 9\ | 81 ( 1.6%)\ | | |
## | | | 19\. 13\ | 76 ( 1.5%)\ | | |
## | | | 20\. 15\ | 75 ( 1.5%)\ | | |
## | | | 21\. 4\ | 73 ( 1.4%)\ | | |
## | | | 22\. 8\ | 68 ( 1.3%)\ | | |
## | | | 23\. 12\ | 61 ( 1.2%)\ | | |
## | | | 24\. 88\ | 60 ( 1.2%)\ | | |
## | | | 25\. 5\ | 59 ( 1.1%)\ | | |
## | | | 26\. 11 | 54 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 30 | ARR_HOURNAME\ | 1\. Unknown EMS Scene Arrival\ | 2514 (48.9%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 8:00pm-8:59pm\ | 176 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 5:00pm-5:59pm\ | 173 ( 3.4%)\ | | |
## | | | 4\. 6:00pm-6:59pm\ | 163 ( 3.2%)\ | | |
## | | | 5\. 10:00pm-10:59pm\ | 159 ( 3.1%)\ | | |
## | | | 6\. 2:00am-2:59am\ | 156 ( 3.0%)\ | | |
## | | | 7\. 9:00pm-9:59pm\ | 151 ( 2.9%)\ | | |
## | | | 8\. 1:00am-1:59am\ | 132 ( 2.6%)\ | | |
## | | | 9\. 4:00pm-4:59pm\ | 128 ( 2.5%)\ | | |
## | | | 10\. 11:00pm-11:59pm\ | 114 ( 2.2%)\ | | |
## | | | 11\. 3:00am-3:59am\ | 114 ( 2.2%)\ | | |
## | | | 12\. 7:00pm-7:59pm\ | 111 ( 2.2%)\ | | |
## | | | 13\. 0:00am-0:59am\ | 97 ( 1.9%)\ | | |
## | | | 14\. 10:00am-10:59am\ | 89 ( 1.7%)\ | | |
## | | | 15\. 2:00pm-2:59pm\ | 88 ( 1.7%)\ | | |
## | | | 16\. 7:00am-7:59am\ | 87 ( 1.7%)\ | | |
## | | | 17\. 6:00am-6:59am\ | 86 ( 1.7%)\ | | |
## | | | 18\. 9:00am-9:59am\ | 81 ( 1.6%)\ | | |
## | | | 19\. 1:00pm-1:59pm\ | 76 ( 1.5%)\ | | |
## | | | 20\. 3:00pm-3:59pm\ | 75 ( 1.5%)\ | | |
## | | | 21\. 4:00am-4:59am\ | 73 ( 1.4%)\ | | |
## | | | 22\. 8:00am-8:59am\ | 68 ( 1.3%)\ | | |
## | | | 23\. 12:00pm-12:59pm\ | 61 ( 1.2%)\ | | |
## | | | 24\. Not Applicable\ | 60 ( 1.2%)\ | | |
## | | | 25\. 5:00am-5:59am\ | 59 ( 1.1%)\ | | |
## | | | 26\. 11:00am-11:59am | 54 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 31 | HOSP_HR\ | 1\. 99\ | 2418 (47.0%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 88\ | 1192 (23.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 19\ | 117 ( 2.3%)\ | | |
## | | | 4\. 17\ | 113 ( 2.2%)\ | | |
## | | | 5\. 22\ | 111 ( 2.2%)\ | | |
## | | | 6\. 2\ | 101 ( 2.0%)\ | | |
## | | | 7\. 23\ | 100 ( 1.9%)\ | | |
## | | | 8\. 21\ | 92 ( 1.8%)\ | | |
## | | | 9\. 20\ | 89 ( 1.7%)\ | | |
## | | | 10\. 18\ | 85 ( 1.7%)\ | | |
## | | | 11\. 3\ | 74 ( 1.4%)\ | | |
## | | | 12\. 14\ | 65 ( 1.3%)\ | | |
## | | | 13\. 8\ | 64 ( 1.2%)\ | | |
## | | | 14\. 4\ | 58 ( 1.1%)\ | | |
## | | | 15\. 13\ | 58 ( 1.1%)\ | | |
## | | | 16\. 10\ | 57 ( 1.1%)\ | | |
## | | | 17\. 11\ | 56 ( 1.1%)\ | | |
## | | | 18\. 0\ | 53 ( 1.0%)\ | | |
## | | | 19\. 16\ | 51 ( 1.0%)\ | | |
## | | | 20\. 1\ | 44 ( 0.9%)\ | | |
## | | | 21\. 15\ | 39 ( 0.8%)\ | | |
## | | | 22\. 6\ | 31 ( 0.6%)\ | | |
## | | | 23\. 7\ | 26 ( 0.5%)\ | | |
## | | | 24\. 5\ | 22 ( 0.4%)\ | | |
## | | | 25\. 9\ | 16 ( 0.3%)\ | | |
## | | | 26\. 12 | 13 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 32 | HOSP_HRNAME\ | 1\. Unknown\ | 2418 (47.0%)\ | 5145\ | 0\ |
## | | [factor] | 2\. Not Applicable (Not Trans\ | 1192 (23.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 7:00pm-7:59pm\ | 117 ( 2.3%)\ | | |
## | | | 4\. 5:00pm-5:59pm\ | 113 ( 2.2%)\ | | |
## | | | 5\. 10:00pm-10:59pm\ | 111 ( 2.2%)\ | | |
## | | | 6\. 2:00am-2:59am\ | 101 ( 2.0%)\ | | |
## | | | 7\. 11:00pm-11:59pm\ | 100 ( 1.9%)\ | | |
## | | | 8\. 9:00pm-9:59pm\ | 92 ( 1.8%)\ | | |
## | | | 9\. 8:00pm-8:59pm\ | 89 ( 1.7%)\ | | |
## | | | 10\. 6:00pm-6:59pm\ | 85 ( 1.7%)\ | | |
## | | | 11\. 3:00am-3:59am\ | 74 ( 1.4%)\ | | |
## | | | 12\. 2:00pm-2:59pm\ | 65 ( 1.3%)\ | | |
## | | | 13\. 8:00am-8:59am\ | 64 ( 1.2%)\ | | |
## | | | 14\. 1:00pm-1:59pm\ | 58 ( 1.1%)\ | | |
## | | | 15\. 4:00am-4:59am\ | 58 ( 1.1%)\ | | |
## | | | 16\. 10:00am-10:59am\ | 57 ( 1.1%)\ | | |
## | | | 17\. 11:00am-11:59am\ | 56 ( 1.1%)\ | | |
## | | | 18\. 0:00am-0:59am\ | 53 ( 1.0%)\ | | |
## | | | 19\. 4:00pm-4:59pm\ | 51 ( 1.0%)\ | | |
## | | | 20\. 1:00am-1:59am\ | 44 ( 0.9%)\ | | |
## | | | 21\. 3:00pm-3:59pm\ | 39 ( 0.8%)\ | | |
## | | | 22\. 6:00am-6:59am\ | 31 ( 0.6%)\ | | |
## | | | 23\. 7:00am-7:59am\ | 26 ( 0.5%)\ | | |
## | | | 24\. 5:00am-5:59am\ | 22 ( 0.4%)\ | | |
## | | | 25\. 9:00am-9:59am\ | 16 ( 0.3%)\ | | |
## | | | 26\. 12:00pm-12:59pm | 13 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 33 | CF1NAME\ | 1\. None\ | 2246 (90.7%)\ | 2476\ | 2669\ |
## | | [factor] | 2\. Police Pursuit Involved\ | 68 ( 2.7%)\ | (48.1%) | (51.9%) |
## | | | 3\. Motor Vehicle struck by f\ | 67 ( 2.7%)\ | | |
## | | | 4\. Reported as Unknown\ | 23 ( 0.9%)\ | | |
## | | | 5\. Recent/Previous Crash sce\ | 15 ( 0.6%)\ | | |
## | | | 6\. Speed Limit is a Statutor\ | 14 ( 0.6%)\ | | |
## | | | 7\. Non-occupant struck by fa\ | 10 ( 0.4%)\ | | |
## | | | 8\. Prior Non-Recurring Incid\ | 8 ( 0.3%)\ | | |
## | | | 9\. Backup Due to Prior Crash\ | 7 ( 0.3%)\ | | |
## | | | 10\. Unknown\ | 5 ( 0.2%)\ | | |
## | | | 11\. Indication of a Stalled/D\ | 4 ( 0.2%)\ | | |
## | | | 12\. Date of Crash and Date of\ | 2 ( 0.1%)\ | | |
## | | | 13\. Shoulder Design or Condit\ | 2 ( 0.1%)\ | | |
## | | | 14\. Surface Under Water\ | 2 ( 0.1%)\ | | |
## | | | 15\. Backup Due to Regular Con\ | 1 ( 0.0%)\ | | |
## | | | 16\. Toll Booth/Plaza Related\ | 1 ( 0.0%)\ | | |
## | | | 17\. Unstabilized Situation Be | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 34 | CF2NAME\ | 1\. None\ | 2428 (98.1%)\ | 2476\ | 2669\ |
## | | [factor] | 2\. Reported as Unknown\ | 23 ( 0.9%)\ | (48.1%) | (51.9%) |
## | | | 3\. Backup Due to Prior Crash\ | 7 ( 0.3%)\ | | |
## | | | 4\. Non-occupant struck by fa\ | 6 ( 0.2%)\ | | |
## | | | 5\. Unknown\ | 5 ( 0.2%)\ | | |
## | | | 6\. Speed Limit is a Statutor\ | 4 ( 0.2%)\ | | |
## | | | 7\. Police Pursuit Involved | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 35 | CF3NAME\ | 1\. None\ | 2448 (98.9%)\ | 2476\ | 2669\ |
## | | [factor] | 2\. Reported as Unknown\ | 23 ( 0.9%)\ | (48.1%) | (51.9%) |
## | | | 3\. Unknown | 5 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 36 | FATALS\ | 1\. 1\ | 4353 (84.6%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 2\ | 619 (12.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 116 ( 2.3%)\ | | |
## | | | 4\. 4\ | 51 ( 1.0%)\ | | |
## | | | 5\. 5 | 6 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 37 | DRUNK_DR\ | 1\. 0\ | 1998 (64.4%)\ | 3101\ | 2044\ |
## | | [factor] | 2\. 1\ | 1084 (35.0%)\ | (60.3%) | (39.7%) |
## | | | 3\. 2 | 19 ( 0.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 38 | VEH_NO\ | 1\. 1\ | 3293 (64.0%)\ | 5145\ | 0\ |
## | | [factor] | 2\. 2\ | 1275 (24.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 277 ( 5.4%)\ | | |
## | | | 4\. 0\ | 180 ( 3.5%)\ | | |
## | | | 5\. 4\ | 65 ( 1.3%)\ | | |
## | | | 6\. 5\ | 30 ( 0.6%)\ | | |
## | | | 7\. 6\ | 10 ( 0.2%)\ | | |
## | | | 8\. 7\ | 7 ( 0.1%)\ | | |
## | | | 9\. 8\ | 2 ( 0.0%)\ | | |
## | | | 10\. 13\ | 2 ( 0.0%)\ | | |
## | | | 11\. 9\ | 1 ( 0.0%)\ | | |
## | | | 12\. 10\ | 1 ( 0.0%)\ | | |
## | | | 13\. 11\ | 1 ( 0.0%)\ | | |
## | | | 14\. 12 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 39 | NUMOCCS\ | 1\. 1\ | 2118 (42.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 2\ | 1266 (25.7%)\ | (95.9%) | (4.1%) |
## | | | 3\. 3\ | 606 (12.3%)\ | | |
## | | | 4\. 4\ | 472 ( 9.6%)\ | | |
## | | | 5\. 5\ | 270 ( 5.5%)\ | | |
## | | | 6\. 99\ | 59 ( 1.2%)\ | | |
## | | | 7\. 6\ | 54 ( 1.1%)\ | | |
## | | | 8\. 7\ | 35 ( 0.7%)\ | | |
## | | | 9\. 8\ | 24 ( 0.5%)\ | | |
## | | | 10\. 12\ | 24 ( 0.5%)\ | | |
## | | | 11\. 0 | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 40 | UNITTYPENAME\ | 1\. Motor Vehicle In-Transpor | 4935 (100.0%) | 4935\ | 210\ |
## | | [factor] | | | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 41 | HIT_RUNNAME\ | 1\. No\ | 4771 (96.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Yes | 164 ( 3.3%) | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 42 | OWNERNAME\ | 1\. Driver (in this crash) wa\ | 2337 (47.4%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Driver (in this crash) No\ | 1951 (39.5%)\ | (95.9%) | (4.1%) |
## | | | 3\. Vehicle Registered as Com\ | 205 ( 4.2%)\ | | |
## | | | 4\. Vehicle Registered as Bus\ | 155 ( 3.1%)\ | | |
## | | | 5\. Not Applicable, Vehicle N\ | 125 ( 2.5%)\ | | |
## | | | 6\. Unknown\ | 82 ( 1.7%)\ | | |
## | | | 7\. Vehicle was Stolen (repor\ | 52 ( 1.1%)\ | | |
## | | | 8\. Vehicle Registered as Ren\ | 23 ( 0.5%)\ | | |
## | | | 9\. Driverless/Motor Vehicle | 5 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 43 | MOD_YEAR\ | 1\. 2006\ | 298 (6.0%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 2015\ | 291 (5.9%)\ | (95.9%) | (4.1%) |
## | | | 3\. 2016\ | 273 (5.5%)\ | | |
## | | | 4\. 2004\ | 272 (5.5%)\ | | |
## | | | 5\. 2007\ | 268 (5.4%)\ | | |
## | | | 6\. 2008\ | 264 (5.3%)\ | | |
## | | | 7\. 2005\ | 244 (4.9%)\ | | |
## | | | 8\. 2014\ | 233 (4.7%)\ | | |
## | | | 9\. 2003\ | 214 (4.3%)\ | | |
## | | | 10\. 2017\ | 209 (4.2%)\ | | |
## | | | 11\. 2013\ | 191 (3.9%)\ | | |
## | | | 12\. 2011\ | 188 (3.8%)\ | | |
## | | | 13\. 2009\ | 176 (3.6%)\ | | |
## | | | 14\. 2012\ | 176 (3.6%)\ | | |
## | | | 15\. 2000\ | 174 (3.5%)\ | | |
## | | | 16\. 2002\ | 166 (3.4%)\ | | |
## | | | 17\. 2018\ | 157 (3.2%)\ | | |
## | | | 18\. 2001\ | 148 (3.0%)\ | | |
## | | | 19\. 2019\ | 148 (3.0%)\ | | |
## | | | 20\. 2010\ | 143 (2.9%)\ | | |
## | | | 21\. 2020\ | 101 (2.0%)\ | | |
## | | | 22\. 1999\ | 92 (1.9%)\ | | |
## | | | 23\. 2021\ | 74 (1.5%)\ | | |
## | | | 24\. 1998\ | 71 (1.4%)\ | | |
## | | | 25\. 1997\ | 67 (1.4%)\ | | |
## | | | 26\. 1994\ | 41 (0.8%)\ | | |
## | | | 27\. 1996\ | 40 (0.8%)\ | | |
## | | | 28\. 2022\ | 39 (0.8%)\ | | |
## | | | 29\. 1995\ | 34 (0.7%)\ | | |
## | | | 30\. 9999\ | 33 (0.7%)\ | | |
## | | | 31\. 1993\ | 28 (0.6%)\ | | |
## | | | 32\. 2023\ | 26 (0.5%)\ | | |
## | | | 33\. 1990\ | 10 (0.2%)\ | | |
## | | | 34\. 1991\ | 9 (0.2%)\ | | |
## | | | 35\. 1992\ | 5 (0.1%)\ | | |
## | | | 36\. 1986\ | 4 (0.1%)\ | | |
## | | | 37\. 1988\ | 4 (0.1%)\ | | |
## | | | 38\. 1989\ | 4 (0.1%)\ | | |
## | | | 39\. 1979\ | 3 (0.1%)\ | | |
## | | | 40\. 1987\ | 3 (0.1%)\ | | |
## | | | 41\. 9998\ | 3 (0.1%)\ | | |
## | | | 42\. 1972\ | 2 (0.0%)\ | | |
## | | | 43\. 1978\ | 2 (0.0%)\ | | |
## | | | 44\. 1985\ | 2 (0.0%)\ | | |
## | | | 45\. 2024\ | 2 (0.0%)\ | | |
## | | | 46\. 1964\ | 1 (0.0%)\ | | |
## | | | 47\. 1970\ | 1 (0.0%)\ | | |
## | | | 48\. 1975 | 1 (0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 44 | TOW_VEHNAME\ | 1\. No Trailing Units\ | 3518 (71.3%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No Trailers\ | 1259 (25.5%)\ | (95.9%) | (4.1%) |
## | | | 3\. One Trailing Unit\ | 93 ( 1.9%)\ | | |
## | | | 4\. One Trailer\ | 51 ( 1.0%)\ | | |
## | | | 5\. Vehicle Towing Another Mo\ | 6 ( 0.1%)\ | | |
## | | | 6\. Two Trailing Units\ | 4 ( 0.1%)\ | | |
## | | | 7\. Unknown\ | 2 ( 0.0%)\ | | |
## | | | 8\. Vehicle Towing Another Mo | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 45 | J_KNIFENAME\ | 1\. Not an Articulated Vehicl\ | 4782 (96.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No\ | 128 ( 2.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. Yes - First Event\ | 14 ( 0.3%)\ | | |
## | | | 4\. Yes - Subsequent Event | 11 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 46 | MCARR_I1NAME\ | 1\. Not Applicable\ | 4632 (93.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. US DOT\ | 145 ( 2.9%)\ | (95.9%) | (4.1%) |
## | | | 3\. None\ | 80 ( 1.6%)\ | | |
## | | | 4\. Not Reported\ | 40 ( 0.8%)\ | | |
## | | | 5\. Unknown\ | 26 ( 0.5%)\ | | |
## | | | 6\. Reported as Unknown\ | 2 ( 0.0%)\ | | |
## | | | 7\. South Carolina\ | 2 ( 0.0%)\ | | |
## | | | 8\. Virginia\ | 2 ( 0.0%)\ | | |
## | | | 9\. Alabama\ | 1 ( 0.0%)\ | | |
## | | | 10\. Indiana\ | 1 ( 0.0%)\ | | |
## | | | 11\. Louisiana\ | 1 ( 0.0%)\ | | |
## | | | 12\. Mississippi\ | 1 ( 0.0%)\ | | |
## | | | 13\. North Carolina\ | 1 ( 0.0%)\ | | |
## | | | 14\. Pennsylvania | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 47 | GVWRNAME\ | 1\. Not Applicable\ | 2254 (94.7%)\ | 2381\ | 2764\ |
## | | [factor] | 2\. 26,001 lbs. or more\ | 70 ( 2.9%)\ | (46.3%) | (53.7%) |
## | | | 3\. 10,001 lbs - 26,000 lbs\ | 50 ( 2.1%)\ | | |
## | | | 4\. 10,000 lbs. or less\ | 3 ( 0.1%)\ | | |
## | | | 5\. Reported as Unknown\ | 2 ( 0.1%)\ | | |
## | | | 6\. Not Reported\ | 1 ( 0.0%)\ | | |
## | | | 7\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 48 | V_CONFIGNAME\ | 1\. Not Applicable\ | 4632 (93.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Truck Tractor/Semi-Traile\ | 116 ( 2.4%)\ | (95.9%) | (4.1%) |
## | | | 3\. Single-Unit Truck (2- axl\ | 85 ( 1.7%)\ | | |
## | | | 4\. Bus (seats for more than \ | 28 ( 0.6%)\ | | |
## | | | 5\. Unknown\ | 22 ( 0.4%)\ | | |
## | | | 6\. Single-Unit Truck (3 or m\ | 11 ( 0.2%)\ | | |
## | | | 7\. Truck Pulling Trailer(s)\ | 11 ( 0.2%)\ | | |
## | | | 8\. Truck More Than 10,000 lb\ | 8 ( 0.2%)\ | | |
## | | | 9\. Vehicle More Than 10,000 \ | 7 ( 0.1%)\ | | |
## | | | 10\. Bus/Large Van (seats for \ | 5 ( 0.1%)\ | | |
## | | | 11\. Reported as Unknown\ | 4 ( 0.1%)\ | | |
## | | | 12\. Truck Tractor (Bobtail)\ | 3 ( 0.1%)\ | | |
## | | | 13\. Truck Tractor/Double | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 49 | CARGO_BTNAME\ | 1\. Not Applicable (N/A)\ | 4632 (93.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Van/Enclosed Box\ | 91 ( 1.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. Other\ | 75 ( 1.5%)\ | | |
## | | | 4\. Bus\ | 33 ( 0.7%)\ | | |
## | | | 5\. Flatbed\ | 25 ( 0.5%)\ | | |
## | | | 6\. Unknown\ | 22 ( 0.4%)\ | | |
## | | | 7\. Unknown Cargo Body Type\ | 16 ( 0.3%)\ | | |
## | | | 8\. Dump\ | 13 ( 0.3%)\ | | |
## | | | 9\. Cargo Tank\ | 9 ( 0.2%)\ | | |
## | | | 10\. No Cargo Body Type\ | 8 ( 0.2%)\ | | |
## | | | 11\. Garbage/Refuse\ | 3 ( 0.1%)\ | | |
## | | | 12\. Grain/ Chips/ Gravel\ | 2 ( 0.0%)\ | | |
## | | | 13\. Reported as Unknown\ | 2 ( 0.0%)\ | | |
## | | | 14\. Auto Transporter\ | 1 ( 0.0%)\ | | |
## | | | 15\. Concrete Mixer\ | 1 ( 0.0%)\ | | |
## | | | 16\. Intermodal Container Chas\ | 1 ( 0.0%)\ | | |
## | | | 17\. Log | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 50 | HAZ_INVNAME\ | 1\. No\ | 4930 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Yes | 5 ( 0.1%) | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 51 | HAZ_PLACNAME\ | 1\. Not Applicable\ | 4930 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Yes\ | 4 ( 0.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. No | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 52 | HAZ_IDNAME\ | 1\. Not Applicable\ | 4930 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not Reported\ | 2 ( 0.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. 1075\ | 1 ( 0.0%)\ | | |
## | | | 4\. 1505\ | 1 ( 0.0%)\ | | |
## | | | 5\. 1993 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 53 | HAZ_CNONAME\ | 1\. Not Applicable\ | 4930 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 02\ | 1 ( 0.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. 03\ | 1 ( 0.0%)\ | | |
## | | | 4\. 05\ | 1 ( 0.0%)\ | | |
## | | | 5\. 5\ | 1 ( 0.0%)\ | | |
## | | | 6\. Not Reported | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 54 | HAZ_RELNAME\ | 1\. Not Applicable\ | 4930 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No\ | 2 ( 0.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. Yes\ | 2 ( 0.0%)\ | | |
## | | | 4\. Not Reported | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 55 | BUS_USENAME\ | 1\. Not a Bus\ | 4882 (98.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Reported as Unknown\ | 16 ( 0.3%)\ | (95.9%) | (4.1%) |
## | | | 3\. Transit/ Commuter\ | 12 ( 0.2%)\ | | |
## | | | 4\. School\ | 9 ( 0.2%)\ | | |
## | | | 5\. Charter/Tour\ | 7 ( 0.1%)\ | | |
## | | | 6\. Not Reported\ | 6 ( 0.1%)\ | | |
## | | | 7\. Modified for Personal/Pri | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 56 | SPEC_USENAME\ | 1\. No Special Use\ | 2938 (59.5%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No Special Use Noted\ | 1299 (26.3%)\ | (95.9%) | (4.1%) |
## | | | 3\. No Special Use\<a0\>Noted\ | 639 (12.9%)\ | | |
## | | | 4\. Vehicle Used as Other Bus\ | 19 ( 0.4%)\ | | |
## | | | 5\. Vehicle Used for School T\ | 9 ( 0.2%)\ | | |
## | | | 6\. Police\ | 8 ( 0.2%)\ | | |
## | | | 7\. Ambulance\ | 6 ( 0.1%)\ | | |
## | | | 8\. Taxi\ | 6 ( 0.1%)\ | | |
## | | | 9\. Fire Truck\ | 4 ( 0.1%)\ | | |
## | | | 10\. Reported as Unknown\ | 4 ( 0.1%)\ | | |
## | | | 11\. Mail Carrier\ | 1 ( 0.0%)\ | | |
## | | | 12\. Towing – Incident Respons\ | 1 ( 0.0%)\ | | |
## | | | 13\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 57 | EMER_USENAME\ | 1\. Not Applicable\ | 4922 (99.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not Reported\ | 4 ( 0.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. Emergency Operation, Emer\ | 3 ( 0.1%)\ | | |
## | | | 4\. Non-Emergency, Non-Transp\ | 3 ( 0.1%)\ | | |
## | | | 5\. Emergency Operation, Emer\ | 2 ( 0.0%)\ | | |
## | | | 6\. Reported as Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 58 | UNDERIDENAME\ | 1\. No Underride or Override \ | 2954 (99.2%)\ | 2979\ | 2166\ |
## | | [factor] | 2\. Underriding a Motor Vehic\ | 9 ( 0.3%)\ | (57.9%) | (42.1%) |
## | | | 3\. Underriding a Motor Vehic\ | 7 ( 0.2%)\ | | |
## | | | 4\. Unknown if Underride or O\ | 5 ( 0.2%)\ | | |
## | | | 5\. Overriding a Motor Vehicl\ | 2 ( 0.1%)\ | | |
## | | | 6\. Overriding a Motor Vehicl | 2 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 59 | ROLLOVERNAME\ | 1\. No Rollover\ | 3934 (79.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Rollover, Tripped by Obje\ | 598 (12.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. Rollover\ | 266 ( 5.4%)\ | | |
## | | | 4\. Rollover, Untripped\ | 74 ( 1.5%)\ | | |
## | | | 5\. Not Applicable\ | 34 ( 0.7%)\ | | |
## | | | 6\. Rollover, Unknown Type | 29 ( 0.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 60 | ROLINLOCNAME\ | 1\. No Rollover\ | 3934 (79.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. On Roadside\ | 632 (12.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. On Roadway\ | 137 ( 2.8%)\ | | |
## | | | 4\. Outside of Trafficway\ | 100 ( 2.0%)\ | | |
## | | | 5\. On Median/Separator\ | 71 ( 1.4%)\ | | |
## | | | 6\. Not Applicable\ | 34 ( 0.7%)\ | | |
## | | | 7\. On Shoulder\ | 16 ( 0.3%)\ | | |
## | | | 8\. Unknown\ | 9 ( 0.2%)\ | | |
## | | | 9\. In Gore\ | 1 ( 0.0%)\ | | |
## | | | 10\. In Parking Lane/Zone | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 61 | IMPACT1NAME\ | 1\. 12 Clock Point\ | 2500 (50.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 6 Clock Point\ | 316 ( 6.4%)\ | (95.9%) | (4.1%) |
## | | | 3\. 3 Clock Point\ | 289 ( 5.9%)\ | | |
## | | | 4\. 11 Clock Point\ | 233 ( 4.7%)\ | | |
## | | | 5\. 9 Clock Point\ | 230 ( 4.7%)\ | | |
## | | | 6\. 1 Clock Point\ | 218 ( 4.4%)\ | | |
## | | | 7\. Non-Collision\ | 200 ( 4.1%)\ | | |
## | | | 8\. Not Reported\ | 152 ( 3.1%)\ | | |
## | | | 9\. 7 Clock Point\ | 80 ( 1.6%)\ | | |
## | | | 10\. Right\ | 78 ( 1.6%)\ | | |
## | | | 11\. 2 Clock Point\ | 75 ( 1.5%)\ | | |
## | | | 12\. Left\ | 69 ( 1.4%)\ | | |
## | | | 13\. 10 Clock Point\ | 67 ( 1.4%)\ | | |
## | | | 14\. 4 Clock Point\ | 51 ( 1.0%)\ | | |
## | | | 15\. 5 Clock Point\ | 51 ( 1.0%)\ | | |
## | | | 16\. Left-Front Side\ | 49 ( 1.0%)\ | | |
## | | | 17\. Reported as Unknown\ | 48 ( 1.0%)\ | | |
## | | | 18\. Right-Back Side\ | 45 ( 0.9%)\ | | |
## | | | 19\. Left-Back Side\ | 42 ( 0.9%)\ | | |
## | | | 20\. Right-Front Side\ | 41 ( 0.8%)\ | | |
## | | | 21\. 8 Clock Point\ | 31 ( 0.6%)\ | | |
## | | | 22\. Undercarriage\ | 31 ( 0.6%)\ | | |
## | | | 23\. Unknown\ | 22 ( 0.4%)\ | | |
## | | | 24\. Object Set in Motion, Unk\ | 6 ( 0.1%)\ | | |
## | | | 25\. Top\ | 6 ( 0.1%)\ | | |
## | | | 26\. Other Objects Set-In-Moti\ | 4 ( 0.1%)\ | | |
## | | | 27\. Cargo/Vehicle Parts Set-I | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 62 | DEFORMEDNAME\ | 1\. Disabling Damage\ | 3967 (80.4%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not Reported\ | 369 ( 7.5%)\ | (95.9%) | (4.1%) |
## | | | 3\. Damage Reported, Extent U\ | 197 ( 4.0%)\ | | |
## | | | 4\. Functional Damage\ | 176 ( 3.6%)\ | | |
## | | | 5\. Minor Damage\ | 175 ( 3.5%)\ | | |
## | | | 6\. Reported as Unknown\ | 32 ( 0.6%)\ | | |
## | | | 7\. No Damage\ | 10 ( 0.2%)\ | | |
## | | | 8\. Unknown | 9 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 63 | TOWEDNAME\ | 1\. Towed Due to Disabling Da\ | 2994 (60.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Towed\ | 1216 (24.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. Not Towed\ | 284 ( 5.8%)\ | | |
## | | | 4\. Towed, Unknown Reason\ | 257 ( 5.2%)\ | | |
## | | | 5\. Towed Not Due to Disablin\ | 89 ( 1.8%)\ | | |
## | | | 6\. Towed But Not Due to Disa\ | 55 ( 1.1%)\ | | |
## | | | 7\. Not Reported\ | 35 ( 0.7%)\ | | |
## | | | 8\. Reported as Unknown\ | 4 ( 0.1%)\ | | |
## | | | 9\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 64 | M_HARMNAME\ | 1\. Motor Vehicle In-Transpor\ | 2611 (52.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Tree (Standing Only)\ | 818 (16.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. Rollover/Overturn\ | 517 (10.5%)\ | | |
## | | | 4\. Utility Pole/Light Suppor\ | 201 ( 4.1%)\ | | |
## | | | 5\. Pedestrian\ | 171 ( 3.5%)\ | | |
## | | | 6\. Fire/Explosion\ | 82 ( 1.7%)\ | | |
## | | | 7\. Guardrail Face\ | 58 ( 1.2%)\ | | |
## | | | 8\. Embankment\ | 44 ( 0.9%)\ | | |
## | | | 9\. Building\ | 43 ( 0.9%)\ | | |
## | | | 10\. Concrete Traffic Barrier\ | 37 ( 0.7%)\ | | |
## | | | 11\. Parked Motor Vehicle\ | 35 ( 0.7%)\ | | |
## | | | 12\. Motor Vehicle In-Transpor\ | 33 ( 0.7%)\ | | |
## | | | 13\. Other Fixed Object\ | 30 ( 0.6%)\ | | |
## | | | 14\. Immersion or Partial Imme\ | 25 ( 0.5%)\ | | |
## | | | 15\. Bridge Pier or Support\ | 24 ( 0.5%)\ | | |
## | | | 16\. Culvert\ | 22 ( 0.4%)\ | | |
## | | | 17\. Traffic Sign Support\ | 19 ( 0.4%)\ | | |
## | | | 18\. Ditch\ | 16 ( 0.3%)\ | | |
## | | | 19\. Traffic Signal Support\ | 16 ( 0.3%)\ | | |
## | | | 20\. Guardrail End\ | 15 ( 0.3%)\ | | |
## | | | 21\. Pedalcyclist\ | 14 ( 0.3%)\ | | |
## | | | 22\. Post, Pole or Other Suppo\ | 12 ( 0.2%)\ | | |
## | | | 23\. Bridge Rail (Includes par\ | 11 ( 0.2%)\ | | |
## | | | 24\. Curb\ | 10 ( 0.2%)\ | | |
## | | | 25\. Fence\ | 10 ( 0.2%)\ | | |
## | | | 26\. Wall\ | 8 ( 0.2%)\ | | |
## | | | 27\. Bridge Overhead Structure\ | 6 ( 0.1%)\ | | |
## | | | 28\. Other Object (not fixed)\ | 6 ( 0.1%)\ | | |
## | | | 29\. Fire Hydrant\ | 5 ( 0.1%)\ | | |
## | | | 30\. Non-Motorist on Personal \ | 5 ( 0.1%)\ | | |
## | | | 31\. Boulder\ | 4 ( 0.1%)\ | | |
## | | | 32\. Mail Box\ | 4 ( 0.1%)\ | | |
## | | | 33\. Railway Vehicle\ | 4 ( 0.1%)\ | | |
## | | | 34\. Fell/Jumped from Vehicle\ | 3 ( 0.1%)\ | | |
## | | | 35\. Object That Had Fallen Fr\ | 2 ( 0.0%)\ | | |
## | | | 36\. Other Non-Collision\ | 2 ( 0.0%)\ | | |
## | | | 37\. Other Traffic Barrier\ | 2 ( 0.0%)\ | | |
## | | | 38\. Thrown or Falling Object\ | 2 ( 0.0%)\ | | |
## | | | 39\. Unknown Object Not Fixed\ | 2 ( 0.0%)\ | | |
## | | | 40\. Ground\ | 1 ( 0.0%)\ | | |
## | | | 41\. Live Animal\ | 1 ( 0.0%)\ | | |
## | | | 42\. Ridden Animal or Animal D\ | 1 ( 0.0%)\ | | |
## | | | 43\. Shrubbery\ | 1 ( 0.0%)\ | | |
## | | | 44\. Unknown Fixed Object\ | 1 ( 0.0%)\ | | |
## | | | 45\. Working Motor Vehicle | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 65 | VEH_SC1NAME\ | 1\. None\ | 2364 (99.3%)\ | 2381\ | 2764\ |
## | | [factor] | 2\. Vehicle Registration for \ | 10 ( 0.4%)\ | (46.3%) | (53.7%) |
## | | | 3\. Reconstructed/Altered Veh\ | 3 ( 0.1%)\ | | |
## | | | 4\. Other Working Vehicle (No\ | 2 ( 0.1%)\ | | |
## | | | 5\. Police, Fire, or EMS Vehi | 2 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 66 | VEH_SC2NAME\ | 1\. None | 2381 (100.0%) | 2381\ | 2764\ |
## | | [factor] | | | (46.3%) | (53.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 67 | FIRE_EXPNAME\ | 1\. No or Not Reported\ | 4690 (95.0%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Yes | 245 ( 5.0%) | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 68 | DR_PRESNAME\ | 1\. Yes\ | 4928 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No Driver Present/Not App | 7 ( 0.1%) | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 69 | L_STATUSNAME\ | 1\. Valid\ | 3740 (75.8%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not licensed\ | 494 (10.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. Suspended\ | 369 ( 7.5%)\ | | |
## | | | 4\. Unknown License Status\ | 147 ( 3.0%)\ | | |
## | | | 5\. Expired\ | 81 ( 1.6%)\ | | |
## | | | 6\. Revoked\ | 78 ( 1.6%)\ | | |
## | | | 7\. Canceled or denied\ | 19 ( 0.4%)\ | | |
## | | | 8\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 70 | L_TYPENAME\ | 1\. Full Driver License\ | 4037 (81.8%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not Licensed\ | 494 (10.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. Intermediate Driver Licen\ | 184 ( 3.7%)\ | | |
## | | | 4\. Unknown License Type\ | 147 ( 3.0%)\ | | |
## | | | 5\. Learner`s Permit\ | 31 ( 0.6%)\ | | |
## | | | 6\. Learner's Permit\ | 22 ( 0.4%)\ | | |
## | | | 7\. Temporary License\ | 13 ( 0.3%)\ | | |
## | | | 8\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 71 | CDL_STATNAME\ | 1\. No (CDL)\ | 4378 (88.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Valid\ | 341 ( 6.9%)\ | (95.9%) | (4.1%) |
## | | | 3\. Unknown License Status\ | 146 ( 3.0%)\ | | |
## | | | 4\. Disqualified\ | 26 ( 0.5%)\ | | |
## | | | 5\. Suspended\ | 18 ( 0.4%)\ | | |
## | | | 6\. Expired\ | 11 ( 0.2%)\ | | |
## | | | 7\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 8\. Other Not-Valid\ | 6 ( 0.1%)\ | | |
## | | | 9\. Commercial Learner’s Perm\ | 1 ( 0.0%)\ | | |
## | | | 10\. Revoked | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 72 | L_ENDORSNAME\ | 1\. No Endorsements required \ | 4713 (95.5%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Unknown, if required\ | 143 ( 2.9%)\ | (95.9%) | (4.1%) |
## | | | 3\. Endorsement(s) Required, \ | 36 ( 0.7%)\ | | |
## | | | 4\. Endorsement(s) Required, \ | 34 ( 0.7%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 6\. Endorsement(s) Required, | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 73 | L_COMPLNAME\ | 1\. Valid license for this cl\ | 3659 (74.1%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No valid license for this\ | 618 (12.5%)\ | (95.9%) | (4.1%) |
## | | | 3\. Not licensed\ | 491 ( 9.9%)\ | | |
## | | | 4\. Unknown\ | 147 ( 3.0%)\ | | |
## | | | 5\. No license required for t\ | 11 ( 0.2%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 7\. Unknown If CDL and/or CDL | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 74 | L_RESTRINAME\ | 1\. No Restrictions or Not Ap\ | 3671 (74.4%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Restrictions, Compliance \ | 884 (17.9%)\ | (95.9%) | (4.1%) |
## | | | 3\. Unknown\ | 166 ( 3.4%)\ | | |
## | | | 4\. Restrictions Complied Wit\ | 118 ( 2.4%)\ | | |
## | | | 5\. Restrictions Not Complied\ | 89 ( 1.8%)\ | | |
## | | | 6\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 75 | DR_HGT\ | 1\. 999\ | 894 (18.1%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 69\ | 398 ( 8.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. 71\ | 382 ( 7.7%)\ | | |
## | | | 4\. 72\ | 377 ( 7.6%)\ | | |
## | | | 5\. 70\ | 369 ( 7.5%)\ | | |
## | | | 6\. 66\ | 355 ( 7.2%)\ | | |
## | | | 7\. 68\ | 353 ( 7.2%)\ | | |
## | | | 8\. 67\ | 327 ( 6.6%)\ | | |
## | | | 9\. 73\ | 237 ( 4.8%)\ | | |
## | | | 10\. 65\ | 223 ( 4.5%)\ | | |
## | | | 11\. 64\ | 193 ( 3.9%)\ | | |
## | | | 12\. 63\ | 172 ( 3.5%)\ | | |
## | | | 13\. 74\ | 170 ( 3.4%)\ | | |
## | | | 14\. 62\ | 149 ( 3.0%)\ | | |
## | | | 15\. 75\ | 88 ( 1.8%)\ | | |
## | | | 16\. 60\ | 60 ( 1.2%)\ | | |
## | | | 17\. 61\ | 55 ( 1.1%)\ | | |
## | | | 18\. 76\ | 47 ( 1.0%)\ | | |
## | | | 19\. 77\ | 29 ( 0.6%)\ | | |
## | | | 20\. 78\ | 16 ( 0.3%)\ | | |
## | | | 21\. 59\ | 14 ( 0.3%)\ | | |
## | | | 22\. 998\ | 7 ( 0.1%)\ | | |
## | | | 23\. 79\ | 6 ( 0.1%)\ | | |
## | | | 24\. 57\ | 5 ( 0.1%)\ | | |
## | | | 25\. 58\ | 4 ( 0.1%)\ | | |
## | | | 26\. 56\ | 2 ( 0.0%)\ | | |
## | | | 27\. 82\ | 2 ( 0.0%)\ | | |
## | | | 28\. 83 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 76 | PREV_ACCNAME\ | 1\. None\ | 3585 (72.6%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 1\ | 677 (13.7%)\ | (95.9%) | (4.1%) |
## | | | 3\. Crashes Not Reported on D\ | 236 ( 4.8%)\ | | |
## | | | 4\. Unknown\ | 225 ( 4.6%)\ | | |
## | | | 5\. 2\ | 146 ( 3.0%)\ | | |
## | | | 6\. 3\ | 46 ( 0.9%)\ | | |
## | | | 7\. 4\ | 9 ( 0.2%)\ | | |
## | | | 8\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 9\. 5\ | 2 ( 0.0%)\ | | |
## | | | 10\. 6 | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 77 | PREV_SUSNAME\ | 1\. None\ | 920 (78.4%)\ | 1173\ | 3972\ |
## | | [factor] | 2\. 1\ | 79 ( 6.7%)\ | (22.8%) | (77.2%) |
## | | | 3\. Unknown\ | 41 ( 3.5%)\ | | |
## | | | 4\. 2\ | 39 ( 3.3%)\ | | |
## | | | 5\. 3\ | 30 ( 2.6%)\ | | |
## | | | 6\. 6\ | 15 ( 1.3%)\ | | |
## | | | 7\. 4\ | 13 ( 1.1%)\ | | |
## | | | 8\. 7\ | 10 ( 0.9%)\ | | |
## | | | 9\. 10\ | 9 ( 0.8%)\ | | |
## | | | 10\. 5\ | 9 ( 0.8%)\ | | |
## | | | 11\. No Driver Present/Unknown\ | 4 ( 0.3%)\ | | |
## | | | 12\. 14\ | 2 ( 0.2%)\ | | |
## | | | 13\. 11\ | 1 ( 0.1%)\ | | |
## | | | 14\. 13 | 1 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 78 | PREV_DWINAME\ | 1\. None\ | 4530 (91.8%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Unknown\ | 225 ( 4.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. 1\ | 140 ( 2.8%)\ | | |
## | | | 4\. 2\ | 28 ( 0.6%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 6\. 3 | 5 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 79 | PREV_SPDNAME\ | 1\. None\ | 3792 (76.8%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 1\ | 611 (12.4%)\ | (95.9%) | (4.1%) |
## | | | 3\. Unknown\ | 225 ( 4.6%)\ | | |
## | | | 4\. 2\ | 186 ( 3.8%)\ | | |
## | | | 5\. 3\ | 76 ( 1.5%)\ | | |
## | | | 6\. 4\ | 25 ( 0.5%)\ | | |
## | | | 7\. 5\ | 10 ( 0.2%)\ | | |
## | | | 8\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 9\. 7 | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 80 | PREV_OTHNAME\ | 1\. None\ | 3647 (73.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 1\ | 631 (12.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. Unknown\ | 225 ( 4.6%)\ | | |
## | | | 4\. 2\ | 204 ( 4.1%)\ | | |
## | | | 5\. 3\ | 109 ( 2.2%)\ | | |
## | | | 6\. 4\ | 35 ( 0.7%)\ | | |
## | | | 7\. 6\ | 25 ( 0.5%)\ | | |
## | | | 8\. 5\ | 18 ( 0.4%)\ | | |
## | | | 9\. 7\ | 13 ( 0.3%)\ | | |
## | | | 10\. 8\ | 7 ( 0.1%)\ | | |
## | | | 11\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 12\. 12\ | 6 ( 0.1%)\ | | |
## | | | 13\. 9\ | 3 ( 0.1%)\ | | |
## | | | 14\. 10\ | 2 ( 0.0%)\ | | |
## | | | 15\. 18\ | 2 ( 0.0%)\ | | |
## | | | 16\. 24 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 81 | FIRST_MONAME\ | 1\. No Record\ | 2511 (50.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Unknown\ | 225 ( 4.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. July\ | 221 ( 4.5%)\ | | |
## | | | 4\. February\ | 218 ( 4.4%)\ | | |
## | | | 5\. October\ | 202 ( 4.1%)\ | | |
## | | | 6\. September\ | 198 ( 4.0%)\ | | |
## | | | 7\. March\ | 191 ( 3.9%)\ | | |
## | | | 8\. June\ | 182 ( 3.7%)\ | | |
## | | | 9\. August\ | 178 ( 3.6%)\ | | |
## | | | 10\. May\ | 177 ( 3.6%)\ | | |
## | | | 11\. April\ | 172 ( 3.5%)\ | | |
## | | | 12\. December\ | 156 ( 3.2%)\ | | |
## | | | 13\. November\ | 153 ( 3.1%)\ | | |
## | | | 14\. January\ | 144 ( 2.9%)\ | | |
## | | | 15\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 82 | FIRST_YRNAME\ | 1\. No Record\ | 2511 (50.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 2017\ | 339 ( 6.9%)\ | (95.9%) | (4.1%) |
## | | | 3\. 2018\ | 287 ( 5.8%)\ | | |
## | | | 4\. 2019\ | 241 ( 4.9%)\ | | |
## | | | 5\. 2016\ | 229 ( 4.6%)\ | | |
## | | | 6\. Unknown\ | 225 ( 4.6%)\ | | |
## | | | 7\. 2014\ | 199 ( 4.0%)\ | | |
## | | | 8\. 2015\ | 189 ( 3.8%)\ | | |
## | | | 9\. 2013\ | 160 ( 3.2%)\ | | |
## | | | 10\. 2020\ | 159 ( 3.2%)\ | | |
## | | | 11\. 2021\ | 125 ( 2.5%)\ | | |
## | | | 12\. 2012\ | 114 ( 2.3%)\ | | |
## | | | 13\. 2022\ | 95 ( 1.9%)\ | | |
## | | | 14\. 2011\ | 32 ( 0.6%)\ | | |
## | | | 15\. 2023\ | 23 ( 0.5%)\ | | |
## | | | 16\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 83 | LAST_MONAME\ | 1\. No Record\ | 2511 (50.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. October\ | 229 ( 4.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. Unknown\ | 225 ( 4.6%)\ | | |
## | | | 4\. February\ | 224 ( 4.5%)\ | | |
## | | | 5\. July\ | 214 ( 4.3%)\ | | |
## | | | 6\. August\ | 192 ( 3.9%)\ | | |
## | | | 7\. May\ | 184 ( 3.7%)\ | | |
## | | | 8\. September\ | 174 ( 3.5%)\ | | |
## | | | 9\. April\ | 173 ( 3.5%)\ | | |
## | | | 10\. March\ | 173 ( 3.5%)\ | | |
## | | | 11\. January\ | 160 ( 3.2%)\ | | |
## | | | 12\. December\ | 159 ( 3.2%)\ | | |
## | | | 13\. November\ | 159 ( 3.2%)\ | | |
## | | | 14\. June\ | 151 ( 3.1%)\ | | |
## | | | 15\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 84 | LAST_YRNAME\ | 1\. No Record\ | 2511 (50.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 2017\ | 343 ( 7.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. 2019\ | 301 ( 6.1%)\ | | |
## | | | 4\. 2018\ | 294 ( 6.0%)\ | | |
## | | | 5\. Unknown\ | 225 ( 4.6%)\ | | |
## | | | 6\. 2016\ | 223 ( 4.5%)\ | | |
## | | | 7\. 2020\ | 222 ( 4.5%)\ | | |
## | | | 8\. 2021\ | 206 ( 4.2%)\ | | |
## | | | 9\. 2015\ | 170 ( 3.4%)\ | | |
## | | | 10\. 2022\ | 144 ( 2.9%)\ | | |
## | | | 11\. 2014\ | 107 ( 2.2%)\ | | |
## | | | 12\. 2023\ | 78 ( 1.6%)\ | | |
## | | | 13\. 2013\ | 61 ( 1.2%)\ | | |
## | | | 14\. 2012\ | 31 ( 0.6%)\ | | |
## | | | 15\. 2011\ | 12 ( 0.2%)\ | | |
## | | | 16\. No Driver Present/Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 85 | SPEEDRELNAME\ | 1\. Yes, Exceeded Speed Limit\ | 2146 (43.5%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No\ | 1552 (31.4%)\ | (95.9%) | (4.1%) |
## | | | 3\. Yes, Specifics Unknown\ | 1185 (24.0%)\ | | |
## | | | 4\. Reported as Unknown\ | 28 ( 0.6%)\ | | |
## | | | 5\. Yes, Too Fast for Conditi\ | 13 ( 0.3%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 7 ( 0.1%)\ | | |
## | | | 7\. Unknown | 4 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 86 | DR_SF1NAME\ | 1\. None\ | 1234 (51.8%)\ | 2381\ | 2764\ |
## | | [factor] | 2\. Operating the Vehicle in \ | 201 ( 8.4%)\ | (46.3%) | (53.7%) |
## | | | 3\. Improper Lane Usage\ | 172 ( 7.2%)\ | | |
## | | | 4\. Careless Driving\ | 139 ( 5.8%)\ | | |
## | | | 5\. Failure to Yield Right-of\ | 76 ( 3.2%)\ | | |
## | | | 6\. Failure to Obey Actual Tr\ | 72 ( 3.0%)\ | | |
## | | | 7\. Ice, Snow, Slush, Water, \ | 59 ( 2.5%)\ | | |
## | | | 8\. Overcorrecting\ | 58 ( 2.4%)\ | | |
## | | | 9\. Unknown\ | 45 ( 1.9%)\ | | |
## | | | 10\. Aggressive Driving / Road\ | 44 ( 1.8%)\ | | |
## | | | 11\. Reported as Unknown\ | 37 ( 1.6%)\ | | |
## | | | 12\. Non-Traffic Violation Cha\ | 36 ( 1.5%)\ | | |
## | | | 13\. Improper or Erratic Lane \ | 29 ( 1.2%)\ | | |
## | | | 14\. Police Pursuing this Driv\ | 27 ( 1.1%)\ | | |
## | | | 15\. Driver Has a Driving Reco\ | 17 ( 0.7%)\ | | |
## | | | 16\. Driving on Wrong Side of \ | 17 ( 0.7%)\ | | |
## | | | 17\. Driver has not complied w\ | 12 ( 0.5%)\ | | |
## | | | 18\. Overloading or Improper L\ | 12 ( 0.5%)\ | | |
## | | | 19\. Driver Has Not Complied W\ | 11 ( 0.5%)\ | | |
## | | | 20\. Operator Inexperience\ | 10 ( 0.4%)\ | | |
## | | | 21\. Passing with Insufficient\ | 10 ( 0.4%)\ | | |
## | | | 22\. Following Improperly\ | 9 ( 0.4%)\ | | |
## | | | 23\. Failing to Dim Lights or \ | 7 ( 0.3%)\ | | |
## | | | 24\. Unfamiliar with Roadway\ | 6 ( 0.3%)\ | | |
## | | | 25\. Alcohol and/or Drug Test \ | 5 ( 0.2%)\ | | |
## | | | 26\. Operating without Require\ | 5 ( 0.2%)\ | | |
## | | | 27\. Driving with Tire-Related\ | 4 ( 0.2%)\ | | |
## | | | 28\. Driving Wrong Way on One-\ | 4 ( 0.2%)\ | | |
## | | | 29\. Passing on Right Side\ | 4 ( 0.2%)\ | | |
## | | | 30\. Making Other Improper Tur\ | 3 ( 0.1%)\ | | |
## | | | 31\. Police or Law Enforcement\ | 3 ( 0.1%)\ | | |
## | | | 32\. Slippery or Loose Surface\ | 2 ( 0.1%)\ | | |
## | | | 33\. Stopped in Roadway (Vehic\ | 2 ( 0.1%)\ | | |
## | | | 34\. Tire Blowout or Flat\ | 2 ( 0.1%)\ | | |
## | | | 35\. Vehicle in Road\ | 2 ( 0.1%)\ | | |
## | | | 36\. Leaving Vehicle Unattende\ | 1 ( 0.0%)\ | | |
## | | | 37\. Passing where Prohibited \ | 1 ( 0.0%)\ | | |
## | | | 38\. Pedestrian, Pedal Cyclist\ | 1 ( 0.0%)\ | | |
## | | | 39\. Reaction to or Failure to\ | 1 ( 0.0%)\ | | |
## | | | 40\. Seat Back Not In Normal U | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 87 | DR_SF2NAME\ | 1\. None\ | 1916 (80.5%)\ | 2381\ | 2764\ |
## | | [factor] | 2\. Operating the Vehicle in \ | 69 ( 2.9%)\ | (46.3%) | (53.7%) |
## | | | 3\. Unknown\ | 45 ( 1.9%)\ | | |
## | | | 4\. Overcorrecting\ | 44 ( 1.8%)\ | | |
## | | | 5\. Failure to Obey Actual Tr\ | 39 ( 1.6%)\ | | |
## | | | 6\. Ice, Snow, Slush, Water, \ | 39 ( 1.6%)\ | | |
## | | | 7\. Reported as Unknown\ | 37 ( 1.6%)\ | | |
## | | | 8\. Improper Lane Usage\ | 31 ( 1.3%)\ | | |
## | | | 9\. Non-Traffic Violation Cha\ | 22 ( 0.9%)\ | | |
## | | | 10\. Aggressive Driving / Road\ | 20 ( 0.8%)\ | | |
## | | | 11\. Driving on Wrong Side of \ | 18 ( 0.8%)\ | | |
## | | | 12\. Police Pursuing this Driv\ | 16 ( 0.7%)\ | | |
## | | | 13\. Careless Driving\ | 9 ( 0.4%)\ | | |
## | | | 14\. Passing where Prohibited \ | 9 ( 0.4%)\ | | |
## | | | 15\. Operating without Require\ | 8 ( 0.3%)\ | | |
## | | | 16\. Driver Has Not Complied W\ | 7 ( 0.3%)\ | | |
## | | | 17\. Failure to Yield Right-of\ | 7 ( 0.3%)\ | | |
## | | | 18\. Unfamiliar with Roadway\ | 7 ( 0.3%)\ | | |
## | | | 19\. Driver Has a Driving Reco\ | 6 ( 0.3%)\ | | |
## | | | 20\. Following Improperly\ | 6 ( 0.3%)\ | | |
## | | | 21\. Improper or Erratic Lane \ | 6 ( 0.3%)\ | | |
## | | | 22\. Driver has not complied w\ | 4 ( 0.2%)\ | | |
## | | | 23\. Making Other Improper Tur\ | 4 ( 0.2%)\ | | |
## | | | 24\. Passing with Insufficient\ | 3 ( 0.1%)\ | | |
## | | | 25\. Tire Blowout or Flat\ | 3 ( 0.1%)\ | | |
## | | | 26\. Driving Wrong Way on One-\ | 2 ( 0.1%)\ | | |
## | | | 27\. Stopped in Roadway (Vehic\ | 2 ( 0.1%)\ | | |
## | | | 28\. Police or Law Enforcement\ | 1 ( 0.0%)\ | | |
## | | | 29\. Ruts, Holes, Bumps in Roa | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 88 | DR_SF3NAME\ | 1\. None\ | 2201 (92.4%)\ | 2381\ | 2764\ |
## | | [factor] | 2\. Unknown\ | 45 ( 1.9%)\ | (46.3%) | (53.7%) |
## | | | 3\. Reported as Unknown\ | 37 ( 1.6%)\ | | |
## | | | 4\. Operating the Vehicle in \ | 18 ( 0.8%)\ | | |
## | | | 5\. Ice, Snow, Slush, Water, \ | 14 ( 0.6%)\ | | |
## | | | 6\. Non-Traffic Violation Cha\ | 10 ( 0.4%)\ | | |
## | | | 7\. Failure to Obey Actual Tr\ | 6 ( 0.3%)\ | | |
## | | | 8\. Overcorrecting\ | 6 ( 0.3%)\ | | |
## | | | 9\. Aggressive Driving / Road\ | 5 ( 0.2%)\ | | |
## | | | 10\. Driver has not complied w\ | 5 ( 0.2%)\ | | |
## | | | 11\. Unfamiliar with Roadway\ | 5 ( 0.2%)\ | | |
## | | | 12\. Operating without Require\ | 4 ( 0.2%)\ | | |
## | | | 13\. Careless Driving\ | 3 ( 0.1%)\ | | |
## | | | 14\. Failure to Yield Right-of\ | 3 ( 0.1%)\ | | |
## | | | 15\. Intentional Illegal Drivi\ | 3 ( 0.1%)\ | | |
## | | | 16\. Passing with Insufficient\ | 3 ( 0.1%)\ | | |
## | | | 17\. Police Pursuing this Driv\ | 3 ( 0.1%)\ | | |
## | | | 18\. Driver Has Not Complied W\ | 2 ( 0.1%)\ | | |
## | | | 19\. Driving on Wrong Side of \ | 2 ( 0.1%)\ | | |
## | | | 20\. Operator Inexperience\ | 2 ( 0.1%)\ | | |
## | | | 21\. Improper Lane Usage\ | 1 ( 0.0%)\ | | |
## | | | 22\. Improper or Erratic Lane \ | 1 ( 0.0%)\ | | |
## | | | 23\. Passing where Prohibited \ | 1 ( 0.0%)\ | | |
## | | | 24\. Vehicle in Road | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 89 | DR_SF4NAME\ | 1\. None\ | 2269 (95.3%)\ | 2381\ | 2764\ |
## | | [factor] | 2\. Unknown\ | 45 ( 1.9%)\ | (46.3%) | (53.7%) |
## | | | 3\. Reported as Unknown\ | 37 ( 1.6%)\ | | |
## | | | 4\. Operating the Vehicle in \ | 6 ( 0.3%)\ | | |
## | | | 5\. Driving on Wrong Side of \ | 4 ( 0.2%)\ | | |
## | | | 6\. Improper or Erratic Lane \ | 4 ( 0.2%)\ | | |
## | | | 7\. Driver has not complied w\ | 3 ( 0.1%)\ | | |
## | | | 8\. Driver Has Not Complied W\ | 3 ( 0.1%)\ | | |
## | | | 9\. Overcorrecting\ | 3 ( 0.1%)\ | | |
## | | | 10\. Passing on Right Side\ | 3 ( 0.1%)\ | | |
## | | | 11\. Passing with Insufficient\ | 2 ( 0.1%)\ | | |
## | | | 12\. Failure to Observe Warnin\ | 1 ( 0.0%)\ | | |
## | | | 13\. Ice, Snow, Slush, Water, | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 90 | VTRAFWAYNAME\ | 1\. Two-Way, Not Divided\ | 2835 (57.4%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Two-Way, Divided, Unprote\ | 804 (16.3%)\ | (95.9%) | (4.1%) |
## | | | 3\. Two-Way, Divided, Positi\ | 758 (15.4%)\ | | |
## | | | 4\. Two-Way, Not Divided With\ | 277 ( 5.6%)\ | | |
## | | | 5\. Two-Way, Divided, Unprot\ | 103 ( 2.1%)\ | | |
## | | | 6\. One-Way Trafficway\ | 67 ( 1.4%)\ | | |
## | | | 7\. Entrance/Exit Ramp\ | 59 ( 1.2%)\ | | |
## | | | 8\. Non-Trafficway or Drivewa\ | 16 ( 0.3%)\ | | |
## | | | 9\. Not Reported\ | 14 ( 0.3%)\ | | |
## | | | 10\. Two-Way Divided, Unknown | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 91 | VNUM_LANNAME\ | 1\. Two lanes\ | 3092 (62.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Three lanes\ | 634 (12.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. Four lanes\ | 616 (12.5%)\ | | |
## | | | 4\. Five lanes\ | 354 ( 7.2%)\ | | |
## | | | 5\. Six lanes\ | 65 ( 1.3%)\ | | |
## | | | 6\. Not Reported\ | 59 ( 1.2%)\ | | |
## | | | 7\. One lane\ | 59 ( 1.2%)\ | | |
## | | | 8\. Seven or more lanes\ | 40 ( 0.8%)\ | | |
## | | | 9\. Non-Trafficway or Drivewa | 16 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 92 | VSPD_LIMNAME\ | 1\. 55 MPH\ | 1073 (21.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 45 MPH\ | 808 (16.4%)\ | (95.9%) | (4.1%) |
## | | | 3\. 35 MPH\ | 719 (14.6%)\ | | |
## | | | 4\. 40 MPH\ | 392 ( 7.9%)\ | | |
## | | | 5\. 30 MPH\ | 369 ( 7.5%)\ | | |
## | | | 6\. 70 MPH\ | 350 ( 7.1%)\ | | |
## | | | 7\. 25 MPH\ | 318 ( 6.4%)\ | | |
## | | | 8\. 65 MPH\ | 275 ( 5.6%)\ | | |
## | | | 9\. 50 MPH\ | 206 ( 4.2%)\ | | |
## | | | 10\. Not Reported\ | 129 ( 2.6%)\ | | |
## | | | 11\. 60 MPH\ | 127 ( 2.6%)\ | | |
## | | | 12\. 75 MPH\ | 100 ( 2.0%)\ | | |
## | | | 13\. 20 MPH\ | 19 ( 0.4%)\ | | |
## | | | 14\. No Statutory Limit/Non-Tr\ | 17 ( 0.3%)\ | | |
## | | | 15\. 15 MPH\ | 15 ( 0.3%)\ | | |
## | | | 16\. Reported as Unknown\ | 13 ( 0.3%)\ | | |
## | | | 17\. Unknown\ | 3 ( 0.1%)\ | | |
## | | | 18\. 80 MPH | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 93 | VALIGNNAME\ | 1\. Straight\ | 3426 (69.4%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Curve - Left\ | 362 ( 7.3%)\ | (95.9%) | (4.1%) |
## | | | 3\. Curve Left\ | 344 ( 7.0%)\ | | |
## | | | 4\. Curve - Right\ | 332 ( 6.7%)\ | | |
## | | | 5\. Curve Right\ | 305 ( 6.2%)\ | | |
## | | | 6\. Curve - Unknown Direction\ | 102 ( 2.1%)\ | | |
## | | | 7\. Not Reported\ | 48 ( 1.0%)\ | | |
## | | | 8\. Non-Trafficway or Drivewa | 16 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 94 | VPROFILENAME\ | 1\. Level\ | 3319 (67.3%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Grade, Unknown Slope\ | 633 (12.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. Not Reported\ | 308 ( 6.2%)\ | | |
## | | | 4\. Downhill\ | 303 ( 6.1%)\ | | |
## | | | 5\. Uphill\ | 172 ( 3.5%)\ | | |
## | | | 6\. Hillcrest\ | 162 ( 3.3%)\ | | |
## | | | 7\. Sag (Bottom)\ | 21 ( 0.4%)\ | | |
## | | | 8\. Non-Trafficway or Drivewa\ | 16 ( 0.3%)\ | | |
## | | | 9\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 95 | VPAVETYPNAME\ | 1\. Blacktop, Bituminous, or \ | 3601 (73.0%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not Reported\ | 994 (20.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. Concrete\ | 278 ( 5.6%)\ | | |
## | | | 4\. Slag, Gravel or Stone\ | 17 ( 0.3%)\ | | |
## | | | 5\. Non-Trafficway or Drivewa\ | 16 ( 0.3%)\ | | |
## | | | 6\. Reported as Unknown\ | 13 ( 0.3%)\ | | |
## | | | 7\. Dirt\ | 9 ( 0.2%)\ | | |
## | | | 8\. Brick or Block\ | 4 ( 0.1%)\ | | |
## | | | 9\. Other | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 96 | VSURCONDNAME\ | 1\. Wet\ | 4721 (95.7%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Water (Standing or Moving\ | 86 ( 1.7%)\ | (95.9%) | (4.1%) |
## | | | 3\. Not Reported\ | 40 ( 0.8%)\ | | |
## | | | 4\. Dry\ | 34 ( 0.7%)\ | | |
## | | | 5\. Ice/Frost\ | 30 ( 0.6%)\ | | |
## | | | 6\. Non-Trafficway or Drivewa\ | 16 ( 0.3%)\ | | |
## | | | 7\. Snow\ | 3 ( 0.1%)\ | | |
## | | | 8\. Mud, Dirt or Gravel\ | 2 ( 0.0%)\ | | |
## | | | 9\. Slush\ | 2 ( 0.0%)\ | | |
## | | | 10\. Sand | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 97 | VTRAFCONNAME\ | 1\. No Controls\ | 3612 (73.2%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Traffic control signal(on\ | 450 ( 9.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. Not Reported\ | 445 ( 9.0%)\ | | |
## | | | 4\. Stop Sign\ | 186 ( 3.8%)\ | | |
## | | | 5\. Traffic control signal (o\ | 109 ( 2.2%)\ | | |
## | | | 6\. Warning Sign\ | 37 ( 0.7%)\ | | |
## | | | 7\. Other Regulatory Sign\ | 20 ( 0.4%)\ | | |
## | | | 8\. Other\ | 19 ( 0.4%)\ | | |
## | | | 9\. Flashing Traffic Control \ | 15 ( 0.3%)\ | | |
## | | | 10\. Traffic control signal (o\ | 14 ( 0.3%)\ | | |
## | | | 11\. Railway Crossing Device\ | 10 ( 0.2%)\ | | |
## | | | 12\. Yield Sign\ | 9 ( 0.2%)\ | | |
## | | | 13\. Other Highway Traffic Sig\ | 4 ( 0.1%)\ | | |
## | | | 14\. Reported as Unknown\ | 3 ( 0.1%)\ | | |
## | | | 15\. Person | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 98 | VTCONT_FNAME\ | 1\. No Controls\ | 3612 (73.2%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Device Functioning Proper\ | 866 (17.5%)\ | (95.9%) | (4.1%) |
## | | | 3\. Not Reported\ | 445 ( 9.0%)\ | | |
## | | | 4\. Reported as Unknown\ | 7 ( 0.1%)\ | | |
## | | | 5\. Device Not Functioning | 5 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 99 | P_CRASH1NAME\ | 1\. Going Straight\ | 2877 (58.3%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Negotiating a Curve\ | 1275 (25.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. Turning Left\ | 247 ( 5.0%)\ | | |
## | | | 4\. Passing or Overtaking Ano\ | 135 ( 2.7%)\ | | |
## | | | 5\. Stopped in Roadway\ | 134 ( 2.7%)\ | | |
## | | | 6\. Changing Lanes\ | 75 ( 1.5%)\ | | |
## | | | 7\. Decelerating in Road\ | 56 ( 1.1%)\ | | |
## | | | 8\. Unknown\ | 27 ( 0.5%)\ | | |
## | | | 9\. Accelerating in Road\ | 26 ( 0.5%)\ | | |
## | | | 10\. Making a U-turn\ | 17 ( 0.3%)\ | | |
## | | | 11\. Turning Right\ | 16 ( 0.3%)\ | | |
## | | | 12\. Successful Avoidance Mane\ | 15 ( 0.3%)\ | | |
## | | | 13\. Other(specify:)\ | 12 ( 0.2%)\ | | |
## | | | 14\. Starting in Road\ | 9 ( 0.2%)\ | | |
## | | | 15\. No Driver Present / Unkno\ | 7 ( 0.1%)\ | | |
## | | | 16\. Merging\ | 6 ( 0.1%)\ | | |
## | | | 17\. Disabled or ""Parked"" in | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 100 | P_CRASH3NAME\ | 1\. Unknown/Not Reported\ | 3449 (69.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. No Avoidance Maneuver\ | 792 (16.0%)\ | (95.9%) | (4.1%) |
## | | | 3\. Steering right\ | 207 ( 4.2%)\ | | |
## | | | 4\. Steering left\ | 170 ( 3.4%)\ | | |
## | | | 5\. Braking\ | 131 ( 2.7%)\ | | |
## | | | 6\. Braking and steering righ\ | 54 ( 1.1%)\ | | |
## | | | 7\. Braking and Unknown Steer\ | 52 ( 1.1%)\ | | |
## | | | 8\. Braking and steering left\ | 31 ( 0.6%)\ | | |
## | | | 9\. Other actions (specify:)\ | 22 ( 0.4%)\ | | |
## | | | 10\. Accelerating\ | 12 ( 0.2%)\ | | |
## | | | 11\. Accelerating and steering\ | 7 ( 0.1%)\ | | |
## | | | 12\. No Driver Present / Unkno\ | 7 ( 0.1%)\ | | |
## | | | 13\. Releasing brakes | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 101 | PCRASH4NAME\ | 1\. Tracking\ | 3150 (63.8%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Precrash stability unknow\ | 779 (15.8%)\ | (95.9%) | (4.1%) |
## | | | 3\. Skidding laterally counte\ | 366 ( 7.4%)\ | | |
## | | | 4\. Skidding laterally clockw\ | 310 ( 6.3%)\ | | |
## | | | 5\. Skidding longitudinally \ | 241 ( 4.9%)\ | | |
## | | | 6\. Skidding Laterally, Rotat\ | 82 ( 1.7%)\ | | |
## | | | 7\. No Driver Present / Unkno | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 102 | PCRASH5NAME\ | 1\. Stayed in original travel\ | 2115 (42.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Departed roadway\ | 2026 (41.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. Stayed on roadway, but le\ | 574 (11.6%)\ | | |
## | | | 4\. Stayed on roadway, not kn\ | 113 ( 2.3%)\ | | |
## | | | 5\. Returned to roadway\ | 40 ( 0.8%)\ | | |
## | | | 6\. Unknown\ | 38 ( 0.8%)\ | | |
## | | | 7\. Remained off roadway\ | 13 ( 0.3%)\ | | |
## | | | 8\. Entered roadway\ | 9 ( 0.2%)\ | | |
## | | | 9\. No Driver Present / Unkno | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 103 | DEATHS\ | 1\. 1\ | 2806 (56.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. 0\ | 1656 (33.6%)\ | (95.9%) | (4.1%) |
## | | | 3\. 2\ | 370 ( 7.5%)\ | | |
## | | | 4\. 3\ | 74 ( 1.5%)\ | | |
## | | | 5\. 4 | 29 ( 0.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 104 | DR_DRINKNAME\ | 1\. No\ | 3634 (73.6%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Yes | 1301 (26.4%) | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 105 | TRLR2VINNAME\ | 1\. No Trailing Units\ | 4931 (99.9%)\ | 4935\ | 210\ |
## | | [factor] | 2\. Not Reported\ | 3 ( 0.1%)\ | (95.9%) | (4.1%) |
## | | | 3\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 106 | TRLR3VINNAME\ | 1\. No Trailing Units | 4935 (100.0%) | 4935\ | 210\ |
## | | [factor] | | | (95.9%) | (4.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 107 | PREV_SUS1NAME\ | 1\. None\ | 3553 (94.4%)\ | 3762\ | 1383\ |
## | | [factor] | 2\. Unknown\ | 184 ( 4.9%)\ | (73.1%) | (26.9%) |
## | | | 3\. 1\ | 12 ( 0.3%)\ | | |
## | | | 4\. 2\ | 7 ( 0.2%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 3 ( 0.1%)\ | | |
## | | | 6\. 8\ | 2 ( 0.1%)\ | | |
## | | | 7\. 3 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 108 | PREV_SUS2NAME\ | 1\. None\ | 3520 (93.6%)\ | 3762\ | 1383\ |
## | | [factor] | 2\. Unknown\ | 184 ( 4.9%)\ | (73.1%) | (26.9%) |
## | | | 3\. 1\ | 31 ( 0.8%)\ | | |
## | | | 4\. 2\ | 20 ( 0.5%)\ | | |
## | | | 5\. 3\ | 3 ( 0.1%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 3 ( 0.1%)\ | | |
## | | | 7\. 4 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 109 | PREV_SUS3NAME\ | 1\. None\ | 3067 (81.5%)\ | 3762\ | 1383\ |
## | | [factor] | 2\. 1\ | 233 ( 6.2%)\ | (73.1%) | (26.9%) |
## | | | 3\. Unknown\ | 184 ( 4.9%)\ | | |
## | | | 4\. 2\ | 96 ( 2.6%)\ | | |
## | | | 5\. 3\ | 60 ( 1.6%)\ | | |
## | | | 6\. 4\ | 43 ( 1.1%)\ | | |
## | | | 7\. 5\ | 20 ( 0.5%)\ | | |
## | | | 8\. 6\ | 16 ( 0.4%)\ | | |
## | | | 9\. 7\ | 14 ( 0.4%)\ | | |
## | | | 10\. 10\ | 4 ( 0.1%)\ | | |
## | | | 11\. 11\ | 4 ( 0.1%)\ | | |
## | | | 12\. 12\ | 4 ( 0.1%)\ | | |
## | | | 13\. 15\ | 4 ( 0.1%)\ | | |
## | | | 14\. 8\ | 4 ( 0.1%)\ | | |
## | | | 15\. No Driver Present/Unknown\ | 3 ( 0.1%)\ | | |
## | | | 16\. 13\ | 2 ( 0.1%)\ | | |
## | | | 17\. 9\ | 2 ( 0.1%)\ | | |
## | | | 18\. 16\ | 1 ( 0.0%)\ | | |
## | | | 19\. 19 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 110 | PER_NO\ | 1\. 1\ | 3388 (65.9%)\ | 5138\ | 7\ |
## | | [factor] | 2\. 2\ | 1048 (20.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. 3\ | 395 ( 7.7%)\ | | |
## | | | 4\. 4\ | 192 ( 3.7%)\ | | |
## | | | 5\. 5\ | 73 ( 1.4%)\ | | |
## | | | 6\. 6\ | 19 ( 0.4%)\ | | |
## | | | 7\. 7\ | 10 ( 0.2%)\ | | |
## | | | 8\. 8\ | 5 ( 0.1%)\ | | |
## | | | 9\. 9\ | 2 ( 0.0%)\ | | |
## | | | 10\. 10\ | 2 ( 0.0%)\ | | |
## | | | 11\. 11\ | 2 ( 0.0%)\ | | |
## | | | 12\. 12 | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 111 | STR_VEH\ | 1\. 0\ | 4958 (96.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. 1\ | 174 ( 3.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. 2\ | 5 ( 0.1%)\ | | |
## | | | 4\. 3 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 112 | MOD_YEARNAME\ | 1\. 2006\ | 298 (5.8%)\ | 5138\ | 7\ |
## | | [factor] | 2\. 2015\ | 293 (5.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. 2016\ | 280 (5.4%)\ | | |
## | | | 4\. 2004\ | 274 (5.3%)\ | | |
## | | | 5\. 2007\ | 268 (5.2%)\ | | |
## | | | 6\. 2008\ | 264 (5.1%)\ | | |
## | | | 7\. 2005\ | 244 (4.7%)\ | | |
## | | | 8\. 2014\ | 236 (4.6%)\ | | |
## | | | 9\. 2003\ | 215 (4.2%)\ | | |
## | | | 10\. 2017\ | 210 (4.1%)\ | | |
## | | | 11\. 2013\ | 192 (3.7%)\ | | |
## | | | 12\. 2011\ | 189 (3.7%)\ | | |
## | | | 13\. (Empty string)\ | 180 (3.5%)\ | | |
## | | | 14\. 2009\ | 176 (3.4%)\ | | |
## | | | 15\. 2012\ | 176 (3.4%)\ | | |
## | | | 16\. 2000\ | 174 (3.4%)\ | | |
## | | | 17\. 2002\ | 168 (3.3%)\ | | |
## | | | 18\. 2018\ | 157 (3.1%)\ | | |
## | | | 19\. 2019\ | 149 (2.9%)\ | | |
## | | | 20\. 2001\ | 148 (2.9%)\ | | |
## | | | 21\. 2010\ | 143 (2.8%)\ | | |
## | | | 22\. 2020\ | 102 (2.0%)\ | | |
## | | | 23\. 1999\ | 93 (1.8%)\ | | |
## | | | 24\. 2021\ | 74 (1.4%)\ | | |
## | | | 25\. 1998\ | 71 (1.4%)\ | | |
## | | | 26\. 1997\ | 67 (1.3%)\ | | |
## | | | 27\. 1994\ | 41 (0.8%)\ | | |
## | | | 28\. 1996\ | 40 (0.8%)\ | | |
## | | | 29\. 2022\ | 39 (0.8%)\ | | |
## | | | 30\. 1995\ | 34 (0.7%)\ | | |
## | | | 31\. Unknown\ | 33 (0.6%)\ | | |
## | | | 32\. 1993\ | 28 (0.5%)\ | | |
## | | | 33\. 2023\ | 25 (0.5%)\ | | |
## | | | 34\. 1990\ | 10 (0.2%)\ | | |
## | | | 35\. 1991\ | 10 (0.2%)\ | | |
## | | | 36\. 1992\ | 5 (0.1%)\ | | |
## | | | 37\. 1986\ | 4 (0.1%)\ | | |
## | | | 38\. 1988\ | 4 (0.1%)\ | | |
## | | | 39\. 1989\ | 4 (0.1%)\ | | |
## | | | 40\. 1979\ | 3 (0.1%)\ | | |
## | | | 41\. 1987\ | 3 (0.1%)\ | | |
## | | | 42\. Not Reported\ | 3 (0.1%)\ | | |
## | | | 43\. 1972\ | 2 (0.0%)\ | | |
## | | | 44\. 1978\ | 2 (0.0%)\ | | |
## | | | 45\. 1985\ | 2 (0.0%)\ | | |
## | | | 46\. 2024\ | 2 (0.0%)\ | | |
## | | | 47\. 1964\ | 1 (0.0%)\ | | |
## | | | 48\. 1970\ | 1 (0.0%)\ | | |
## | | | 49\. 1975 | 1 (0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 113 | SEXNAME\ | 1\. Male\ | 3439 (66.9%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Female\ | 1606 (31.3%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 50 ( 1.0%)\ | | |
## | | | 4\. Reported as Unknown\ | 33 ( 0.6%)\ | | |
## | | | 5\. Unknown | 10 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 114 | PER_TYPNAME\ | 1\. Driver of a Motor Vehicle\ | 3198 (62.2%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Passenger of a Motor Vehi\ | 1727 (33.6%)\ | (99.9%) | (0.1%) |
## | | | 3\. Pedestrian\ | 161 ( 3.1%)\ | | |
## | | | 4\. Occupant of a Motor Vehic\ | 30 ( 0.6%)\ | | |
## | | | 5\. Bicyclist\ | 12 ( 0.2%)\ | | |
## | | | 6\. Unknown Occupant Type in \ | 3 ( 0.1%)\ | | |
## | | | 7\. Person on Personal Convey\ | 2 ( 0.0%)\ | | |
## | | | 8\. Occupant of a Non-Motor V\ | 1 ( 0.0%)\ | | |
## | | | 9\. Person In/On a Building\ | 1 ( 0.0%)\ | | |
## | | | 10\. Person on Non-Motorized P\ | 1 ( 0.0%)\ | | |
## | | | 11\. Person on Personal Convey\ | 1 ( 0.0%)\ | | |
## | | | 12\. Persons on Personal Conve | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 115 | INJ_SEVNAME\ | 1\. Fatal Injury (K)\ | 2389 (46.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. No Apparent Injury (O)\ | 823 (16.0%)\ | (99.9%) | (0.1%) |
## | | | 3\. Suspected Serious Injury \ | 658 (12.8%)\ | | |
## | | | 4\. Suspected Minor Injury (B\ | 633 (12.3%)\ | | |
## | | | 5\. Possible Injury (C)\ | 401 ( 7.8%)\ | | |
## | | | 6\. Suspected Minor Injury(B)\ | 82 ( 1.6%)\ | | |
## | | | 7\. Suspected Serious Injury(\ | 77 ( 1.5%)\ | | |
## | | | 8\. Unknown/Not Reported\ | 64 ( 1.2%)\ | | |
## | | | 9\. Injured, Severity Unknown | 11 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 116 | SEAT_POSNAME\ | 1\. Front Seat, Left Side\ | 3213 (62.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Front Seat, Right Side\ | 906 (17.6%)\ | (99.9%) | (0.1%) |
## | | | 3\. Second Seat, Right Side\ | 288 ( 5.6%)\ | | |
## | | | 4\. Second Seat, Left Side\ | 260 ( 5.1%)\ | | |
## | | | 5\. Not a Motor Vehicle Occup\ | 180 ( 3.5%)\ | | |
## | | | 6\. Second Seat, Middle\ | 93 ( 1.8%)\ | | |
## | | | 7\. Reported as Unknown\ | 51 ( 1.0%)\ | | |
## | | | 8\. Other Passenger in enclos\ | 29 ( 0.6%)\ | | |
## | | | 9\. Not Reported\ | 25 ( 0.5%)\ | | |
## | | | 10\. Other Passenger in unencl\ | 18 ( 0.4%)\ | | |
## | | | 11\. Second Seat, Unknown\ | 13 ( 0.3%)\ | | |
## | | | 12\. Third Seat, Left Side\ | 11 ( 0.2%)\ | | |
## | | | 13\. Front Seat, Middle\ | 10 ( 0.2%)\ | | |
## | | | 14\. Sleeper Section of Cab (T\ | 10 ( 0.2%)\ | | |
## | | | 15\. Third Seat, Right Side\ | 9 ( 0.2%)\ | | |
## | | | 16\. Unknown\ | 9 ( 0.2%)\ | | |
## | | | 17\. Riding on Exterior of Veh\ | 3 ( 0.1%)\ | | |
## | | | 18\. Second Seat, Other\ | 3 ( 0.1%)\ | | |
## | | | 19\. Third Seat, Middle\ | 2 ( 0.0%)\ | | |
## | | | 20\. Trailing Unit\ | 2 ( 0.0%)\ | | |
## | | | 21\. Fourth Seat, Unknown\ | 1 ( 0.0%)\ | | |
## | | | 22\. Front Seat, Unknown\ | 1 ( 0.0%)\ | | |
## | | | 23\. Third Seat, Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 117 | REST_USENAME\ | 1\. Shoulder and Lap Belt Use\ | 2347 (45.7%)\ | 5138\ | 7\ |
## | | [factor] | 2\. None Used/Not Applicable\ | 1170 (22.8%)\ | (99.9%) | (0.1%) |
## | | | 3\. Reported as Unknown\ | 424 ( 8.3%)\ | | |
## | | | 4\. None Used / Not Applicabl\ | 396 ( 7.7%)\ | | |
## | | | 5\. Not a Motor Vehicle Occup\ | 180 ( 3.5%)\ | | |
## | | | 6\. None Used\ | 147 ( 2.9%)\ | | |
## | | | 7\. Unknown\ | 145 ( 2.8%)\ | | |
## | | | 8\. Restraint Used - Type Unk\ | 69 ( 1.3%)\ | | |
## | | | 9\. Not Reported\ | 64 ( 1.2%)\ | | |
## | | | 10\. Child Restraint System - \ | 32 ( 0.6%)\ | | |
## | | | 11\. Child Restraint Type Unkn\ | 30 ( 0.6%)\ | | |
## | | | 12\. No Helmet\ | 29 ( 0.6%)\ | | |
## | | | 13\. Lap Belt Only Used\ | 24 ( 0.5%)\ | | |
## | | | 14\. DOT-Compliant Motorcycle \ | 17 ( 0.3%)\ | | |
## | | | 15\. Helmet, Unknown if DOT Co\ | 15 ( 0.3%)\ | | |
## | | | 16\. Child Restraint System - \ | 13 ( 0.3%)\ | | |
## | | | 17\. Shoulder Belt Only Used\ | 12 ( 0.2%)\ | | |
## | | | 18\. Booster Seat\ | 11 ( 0.2%)\ | | |
## | | | 19\. Other\ | 7 ( 0.1%)\ | | |
## | | | 20\. Helmet, Other than DOT-Co\ | 4 ( 0.1%)\ | | |
## | | | 21\. Child Restraint System - | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 118 | REST_MISNAME\ | 1\. No\ | 1786 (34.8%)\ | 5138\ | 7\ |
## | | [factor] | 2\. None Used/Not Applicable\ | 1564 (30.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. No Indication of Misuse\ | 1019 (19.8%)\ | | |
## | | | 4\. No Indication of Mis-Use\ | 556 (10.8%)\ | | |
## | | | 5\. Not a Motor Vehicle Occup\ | 180 ( 3.5%)\ | | |
## | | | 6\. Yes, Indication of Misuse\ | 19 ( 0.4%)\ | | |
## | | | 7\. Yes\ | 7 ( 0.1%)\ | | |
## | | | 8\. Yes, Indication of Mis-Us | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 119 | AIR_BAGNAME\ | 1\. Not Deployed\ | 1831 (35.6%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Deployed- Combination\ | 1049 (20.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. Deployed- Front\ | 879 (17.1%)\ | | |
## | | | 4\. Deployment- Unknown Locat\ | 574 (11.2%)\ | | |
## | | | 5\. Not a Motor Vehicle Occup\ | 180 ( 3.5%)\ | | |
## | | | 6\. Not Reported\ | 179 ( 3.5%)\ | | |
## | | | 7\. Reported as Deployment Un\ | 149 ( 2.9%)\ | | |
## | | | 8\. Deployed- Side (door, sea\ | 116 ( 2.3%)\ | | |
## | | | 9\. Not Applicable\ | 67 ( 1.3%)\ | | |
## | | | 10\. Deployed- Curtain (roof)\ | 56 ( 1.1%)\ | | |
## | | | 11\. Deployment Unknown\ | 53 ( 1.0%)\ | | |
## | | | 12\. Deployed- Other (Knee, ai\ | 4 ( 0.1%)\ | | |
## | | | 13\. Switched Off | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 120 | EJECTIONNAME\ | 1\. Not Ejected\ | 4140 (80.6%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Totally Ejected\ | 483 ( 9.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Applicable\ | 310 ( 6.0%)\ | | |
## | | | 4\. Partially Ejected\ | 130 ( 2.5%)\ | | |
## | | | 5\. Not Reported\ | 31 ( 0.6%)\ | | |
## | | | 6\. Reported as Unknown if Ej\ | 26 ( 0.5%)\ | | |
## | | | 7\. Unknown if Ejected\ | 11 ( 0.2%)\ | | |
## | | | 8\. Ejected - Unknown Degree | 7 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 121 | EJ_PATHNAME\ | 1\. Ejection Path Not Applica\ | 4518 (87.9%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Ejection Path Unknown\ | 473 ( 9.2%)\ | (99.9%) | (0.1%) |
## | | | 3\. Through Side Window\ | 55 ( 1.1%)\ | | |
## | | | 4\. Through Side Door Opening\ | 29 ( 0.6%)\ | | |
## | | | 5\. Other Path (e.g., back of\ | 20 ( 0.4%)\ | | |
## | | | 6\. Through Back Window\ | 16 ( 0.3%)\ | | |
## | | | 7\. Through Windshield\ | 13 ( 0.3%)\ | | |
## | | | 8\. Through Roof Opening (sun\ | 12 ( 0.2%)\ | | |
## | | | 9\. Through roof (convertible | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 122 | EXTRICATNAME\ | 1\. Not Extricated or Not App\ | 4134 (80.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Extricated\ | 786 (15.3%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown | 218 ( 4.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 123 | DRINKINGNAME\ | 1\. Not Reported\ | 2116 (41.2%)\ | 5138\ | 7\ |
## | | [factor] | 2\. No (Alcohol Not Involved)\ | 1772 (34.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Yes (Alcohol Involved)\ | 710 (13.8%)\ | | |
## | | | 4\. Reported as Unknown\ | 412 ( 8.0%)\ | | |
## | | | 5\. Unknown (Police Reported) | 128 ( 2.5%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 124 | ALC_DETNAME\ | 1\. Not Reported\ | 3070 (81.4%)\ | 3772\ | 1373\ |
## | | [factor] | 2\. Evidential Test (breath, \ | 477 (12.6%)\ | (73.3%) | (26.7%) |
## | | | 3\. Observed\ | 182 ( 4.8%)\ | | |
## | | | 4\. Preliminary Breath Test (\ | 28 ( 0.7%)\ | | |
## | | | 5\. Behavioral\ | 7 ( 0.2%)\ | | |
## | | | 6\. Other (e.g., Saliva test)\ | 5 ( 0.1%)\ | | |
## | | | 7\. Standard Field Sobriety T | 3 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 125 | ALC_STATUSNAME\ | 1\. Test Not Given\ | 2641 (51.4%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Test Given\ | 2010 (39.1%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 435 ( 8.5%)\ | | |
## | | | 4\. Reported as Unknown if Te\ | 36 ( 0.7%)\ | | |
## | | | 5\. UnKnown if Tested | 16 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 126 | ATST_TYPNAME\ | 1\. Test Not Given\ | 2641 (51.4%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Blood\ | 1729 (33.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 442 ( 8.6%)\ | | |
## | | | 4\. Vitreous\ | 145 ( 2.8%)\ | | |
## | | | 5\. Unknown Test Type\ | 65 ( 1.3%)\ | | |
## | | | 6\. Reported as Unknown if Te\ | 36 ( 0.7%)\ | | |
## | | | 7\. Preliminary Breath Test (\ | 30 ( 0.6%)\ | | |
## | | | 8\. Unknown if Tested\ | 16 ( 0.3%)\ | | |
## | | | 9\. Breath Test (AC)\ | 14 ( 0.3%)\ | | |
## | | | 10\. Blood Plasma/Serum\ | 6 ( 0.1%)\ | | |
## | | | 11\. Urine\ | 6 ( 0.1%)\ | | |
## | | | 12\. Other Test Type\ | 4 ( 0.1%)\ | | |
## | | | 13\. Breath Test, Unknown Type\ | 3 ( 0.1%)\ | | |
## | | | 14\. Liver | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 127 | DRUGSNAME\ | 1\. Not Reported\ | 2537 (49.4%)\ | 5138\ | 7\ |
## | | [factor] | 2\. No (drugs not involved)\ | 1697 (33.0%)\ | (99.9%) | (0.1%) |
## | | | 3\. Yes (drugs involved)\ | 411 ( 8.0%)\ | | |
## | | | 4\. Reported as Unknown\ | 371 ( 7.2%)\ | | |
## | | | 5\. Unknown | 122 ( 2.4%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 128 | DRUG_DETNAME\ | 1\. Not Reported\ | 3208 (85.0%)\ | 3772\ | 1373\ |
## | | [factor] | 2\. Evidential Test (Blood, U\ | 398 (10.6%)\ | (73.3%) | (26.7%) |
## | | | 3\. Other\ | 110 ( 2.9%)\ | | |
## | | | 4\. Observed Behavior or SFST\ | 35 ( 0.9%)\ | | |
## | | | 5\. Behavioral\ | 15 ( 0.4%)\ | | |
## | | | 6\. Drug Recognition Expert (\ | 5 ( 0.1%)\ | | |
## | | | 7\. Drug Recognition Expert ( | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 129 | DSTATUSNAME\ | 1\. Test Not Given\ | 2777 (54.0%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Test Given\ | 1785 (34.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 524 (10.2%)\ | | |
## | | | 4\. Reported as Unknown if Te\ | 36 ( 0.7%)\ | | |
## | | | 5\. Unknown if Tested | 16 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 130 | DRUGTST1NAME\ | 1\. Test Not Given\ | 707 (58.0%)\ | 1219\ | 3926\ |
## | | [factor] | 2\. Blood\ | 363 (29.8%)\ | (23.7%) | (76.3%) |
## | | | 3\. Not Reported\ | 74 ( 6.1%)\ | | |
## | | | 4\. Urine\ | 26 ( 2.1%)\ | | |
## | | | 5\. Both: Blood and Urine Tes\ | 21 ( 1.7%)\ | | |
## | | | 6\. Unknown if Tested\ | 16 ( 1.3%)\ | | |
## | | | 7\. Unknown Test Type\ | 9 ( 0.7%)\ | | |
## | | | 8\. Other Test Type | 3 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 131 | DRUGTST2NAME\ | 1\. Test Not Given\ | 1121 (92.0%)\ | 1219\ | 3926\ |
## | | [factor] | 2\. Blood\ | 81 ( 6.6%)\ | (23.7%) | (76.3%) |
## | | | 3\. Both: Blood and Urine Tes\ | 9 ( 0.7%)\ | | |
## | | | 4\. Urine | 8 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 132 | DRUGTST3NAME\ | 1\. Test Not Given\ | 1176 (96.5%)\ | 1219\ | 3926\ |
## | | [factor] | 2\. Blood\ | 35 ( 2.9%)\ | (23.7%) | (76.3%) |
## | | | 3\. Both: Blood and Urine Tes\ | 4 ( 0.3%)\ | | |
## | | | 4\. Urine | 4 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 133 | DRUGRES1NAME\ | 1\. Test Not Given\ | 707 (58.0%)\ | 1219\ | 3926\ |
## | | [factor] | 2\. Tested, No Drugs Found/Ne\ | 206 (16.9%)\ | (23.7%) | (76.3%) |
## | | | 3\. Not Reported\ | 67 ( 5.5%)\ | | |
## | | | 4\. Tetrahydrocannabinols (TH\ | 47 ( 3.9%)\ | | |
## | | | 5\. Test For Drug, Results Un\ | 25 ( 2.1%)\ | | |
## | | | 6\. DELTA 9\ | 18 ( 1.5%)\ | | |
## | | | 7\. Other Drug\ | 17 ( 1.4%)\ | | |
## | | | 8\. Unknown if Tested\ | 16 ( 1.3%)\ | | |
## | | | 9\. AMPHETAMINE\ | 15 ( 1.2%)\ | | |
## | | | 10\. MARIJUANA/Marihuana\ | 10 ( 0.8%)\ | | |
## | | | 11\. ""Cannabinoid, Type Unkno\ | 8 ( 0.7%)\ | | |
## | | | 12\. COCAINE\ | 8 ( 0.7%)\ | | |
## | | | 13\. METHAMPHETAMINE\ | 7 ( 0.6%)\ | | |
## | | | 14\. MORPHINE\ | 7 ( 0.6%)\ | | |
## | | | 15\. ALPRAZOLAM\ | 6 ( 0.5%)\ | | |
## | | | 16\. BENZOYLECGONINE\ | 6 ( 0.5%)\ | | |
## | | | 17\. FENTANYL\ | 6 ( 0.5%)\ | | |
## | | | 18\. Midazolam\ | 6 ( 0.5%)\ | | |
## | | | 19\. Tested For Drugs, Drugs F\ | 6 ( 0.5%)\ | | |
## | | | 20\. OXYCODONE\ | 5 ( 0.4%)\ | | |
## | | | 21\. BENZODIAZEPINES\ | 4 ( 0.3%)\ | | |
## | | | 22\. HYDROCODONE\ | 3 ( 0.2%)\ | | |
## | | | 23\. DIAZEPAM\ | 2 ( 0.2%)\ | | |
## | | | 24\. Oxymorphone\ | 2 ( 0.2%)\ | | |
## | | | 25\. Zolpidem\ | 2 ( 0.2%)\ | | |
## | | | 26\. ""Depressants, Type Unkno\ | 1 ( 0.1%)\ | | |
## | | | 27\. ""Narcotics, Type Unknown\ | 1 ( 0.1%)\ | | |
## | | | 28\. ""Stimulants, Type Unknow\ | 1 ( 0.1%)\ | | |
## | | | 29\. Buprenorphine\ | 1 ( 0.1%)\ | | |
## | | | 30\. Chlorphentermine\ | 1 ( 0.1%)\ | | |
## | | | 31\. CODEINE\ | 1 ( 0.1%)\ | | |
## | | | 32\. HYDROMORPHONE\ | 1 ( 0.1%)\ | | |
## | | | 33\. LORAZEPAM\ | 1 ( 0.1%)\ | | |
## | | | 34\. Lormetazepam\ | 1 ( 0.1%)\ | | |
## | | | 35\. METHADONE\ | 1 ( 0.1%)\ | | |
## | | | 36\. Methylenedioxymethampheta\ | 1 ( 0.1%)\ | | |
## | | | 37\. Nordiazepam\ | 1 ( 0.1%)\ | | |
## | | | 38\. PHENCYCLIDINE | 1 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 134 | DRUGRES2NAME\ | 1\. Test Not Given\ | 1122 (92.0%)\ | 1219\ | 3926\ |
## | | [factor] | 2\. Tetrahydrocannabinols (TH\ | 17 ( 1.4%)\ | (23.7%) | (76.3%) |
## | | | 3\. METHAMPHETAMINE\ | 16 ( 1.3%)\ | | |
## | | | 4\. Other Drug\ | 14 ( 1.1%)\ | | |
## | | | 5\. DELTA 9\ | 9 ( 0.7%)\ | | |
## | | | 6\. BENZOYLECGONINE\ | 6 ( 0.5%)\ | | |
## | | | 7\. ""Cannabinoid, Type Unkno\ | 4 ( 0.3%)\ | | |
## | | | 8\. COCAINE\ | 4 ( 0.3%)\ | | |
## | | | 9\. Ketamine\ | 4 ( 0.3%)\ | | |
## | | | 10\. OXYCODONE\ | 4 ( 0.3%)\ | | |
## | | | 11\. MARIJUANA/Marihuana\ | 3 ( 0.2%)\ | | |
## | | | 12\. ALPRAZOLAM\ | 2 ( 0.2%)\ | | |
## | | | 13\. AMPHETAMINE\ | 2 ( 0.2%)\ | | |
## | | | 14\. Clonazepam\ | 2 ( 0.2%)\ | | |
## | | | 15\. Midazolam\ | 2 ( 0.2%)\ | | |
## | | | 16\. Acetaminophen + Codeine\ | 1 ( 0.1%)\ | | |
## | | | 17\. DIHYDROCODEINE\ | 1 ( 0.1%)\ | | |
## | | | 18\. HYDROMORPHONE\ | 1 ( 0.1%)\ | | |
## | | | 19\. MEPERIDINE (Pethidine)\ | 1 ( 0.1%)\ | | |
## | | | 20\. Methylenedioxymethampheta\ | 1 ( 0.1%)\ | | |
## | | | 21\. Nordiazepam\ | 1 ( 0.1%)\ | | |
## | | | 22\. Tested For Drugs, Drugs F\ | 1 ( 0.1%)\ | | |
## | | | 23\. Zolpidem | 1 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 135 | DRUGRES3NAME\ | 1\. Test Not Given\ | 1177 (96.6%)\ | 1219\ | 3926\ |
## | | [factor] | 2\. Other Drug\ | 11 ( 0.9%)\ | (23.7%) | (76.3%) |
## | | | 3\. Tetrahydrocannabinols (TH\ | 5 ( 0.4%)\ | | |
## | | | 4\. METHAMPHETAMINE\ | 3 ( 0.2%)\ | | |
## | | | 5\. ""Cannabinoid, Type Unkno\ | 2 ( 0.2%)\ | | |
## | | | 6\. ALPRAZOLAM\ | 2 ( 0.2%)\ | | |
## | | | 7\. AMPHETAMINE\ | 2 ( 0.2%)\ | | |
## | | | 8\. BENZOYLECGONINE\ | 2 ( 0.2%)\ | | |
## | | | 9\. Clonazepam\ | 2 ( 0.2%)\ | | |
## | | | 10\. DELTA 9\ | 2 ( 0.2%)\ | | |
## | | | 11\. Tested For Drugs, Drugs F\ | 2 ( 0.2%)\ | | |
## | | | 12\. BENZODIAZEPINES\ | 1 ( 0.1%)\ | | |
## | | | 13\. HYDROCODONE\ | 1 ( 0.1%)\ | | |
## | | | 14\. MARIJUANA/Marihuana\ | 1 ( 0.1%)\ | | |
## | | | 15\. METHADONE\ | 1 ( 0.1%)\ | | |
## | | | 16\. Methylenedioxyamphetamine\ | 1 ( 0.1%)\ | | |
## | | | 17\. Methylenedioxymethampheta\ | 1 ( 0.1%)\ | | |
## | | | 18\. MORPHINE\ | 1 ( 0.1%)\ | | |
## | | | 19\. OPIUM\ | 1 ( 0.1%)\ | | |
## | | | 20\. OXYCODONE | 1 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 136 | HOSPITALNAME\ | 1\. EMS Ground\ | 2103 (40.9%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Not Transported for Treat\ | 1384 (26.9%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Transported\ | 1213 (23.6%)\ | | |
## | | | 4\. EMS Unknown Mode\ | 266 ( 5.2%)\ | | |
## | | | 5\. Not Reported\ | 72 ( 1.4%)\ | | |
## | | | 6\. EMS Air\ | 47 ( 0.9%)\ | | |
## | | | 7\. Other\ | 24 ( 0.5%)\ | | |
## | | | 8\. Law Enforcement\ | 14 ( 0.3%)\ | | |
## | | | 9\. Transported Unknown Sour\ | 9 ( 0.2%)\ | | |
## | | | 10\. Reported as Unknown | 6 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 137 | DOANAME\ | 1\. Not Applicable\ | 3620 (70.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Died at Scene\ | 1501 (29.2%)\ | (99.9%) | (0.1%) |
## | | | 3\. Died En Route\ | 13 ( 0.3%)\ | | |
## | | | 4\. Unknown | 4 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 138 | DEATH_DANAME\ | 1\. Not Applicable (Non-Fatal\ | 2749 (53.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. 1\ | 98 ( 1.9%)\ | (99.9%) | (0.1%) |
## | | | 3\. 23\ | 95 ( 1.8%)\ | | |
## | | | 4\. 28\ | 90 ( 1.8%)\ | | |
## | | | 5\. 2\ | 89 ( 1.7%)\ | | |
## | | | 6\. 25\ | 86 ( 1.7%)\ | | |
## | | | 7\. 24\ | 85 ( 1.7%)\ | | |
## | | | 8\. 30\ | 85 ( 1.7%)\ | | |
## | | | 9\. 22\ | 84 ( 1.6%)\ | | |
## | | | 10\. 26\ | 84 ( 1.6%)\ | | |
## | | | 11\. 29\ | 84 ( 1.6%)\ | | |
## | | | 12\. 17\ | 83 ( 1.6%)\ | | |
## | | | 13\. 10\ | 81 ( 1.6%)\ | | |
## | | | 14\. 4\ | 81 ( 1.6%)\ | | |
## | | | 15\. 5\ | 80 ( 1.6%)\ | | |
## | | | 16\. 21\ | 79 ( 1.5%)\ | | |
## | | | 17\. 27\ | 79 ( 1.5%)\ | | |
## | | | 18\. 3\ | 79 ( 1.5%)\ | | |
## | | | 19\. 19\ | 75 ( 1.5%)\ | | |
## | | | 20\. 11\ | 74 ( 1.4%)\ | | |
## | | | 21\. 13\ | 74 ( 1.4%)\ | | |
## | | | 22\. 20\ | 72 ( 1.4%)\ | | |
## | | | 23\. 15\ | 71 ( 1.4%)\ | | |
## | | | 24\. 9\ | 70 ( 1.4%)\ | | |
## | | | 25\. 12\ | 68 ( 1.3%)\ | | |
## | | | 26\. 8\ | 68 ( 1.3%)\ | | |
## | | | 27\. 6\ | 67 ( 1.3%)\ | | |
## | | | 28\. 16\ | 66 ( 1.3%)\ | | |
## | | | 29\. 7\ | 65 ( 1.3%)\ | | |
## | | | 30\. 18\ | 59 ( 1.1%)\ | | |
## | | | 31\. 31\ | 50 ( 1.0%)\ | | |
## | | | 32\. 14\ | 44 ( 0.9%)\ | | |
## | | | 33\. Unknown\ | 14 ( 0.3%)\ | | |
## | | | 34\. Redacted | 10 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 139 | DEATH_MONAME\ | 1\. Not Applicable (Non-Fatal\ | 2749 (53.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. October\ | 267 ( 5.2%)\ | (99.9%) | (0.1%) |
## | | | 3\. December\ | 246 ( 4.8%)\ | | |
## | | | 4\. May\ | 234 ( 4.6%)\ | | |
## | | | 5\. November\ | 214 ( 4.2%)\ | | |
## | | | 6\. January\ | 209 ( 4.1%)\ | | |
## | | | 7\. April\ | 195 ( 3.8%)\ | | |
## | | | 8\. March\ | 188 ( 3.7%)\ | | |
## | | | 9\. September\ | 181 ( 3.5%)\ | | |
## | | | 10\. February\ | 176 ( 3.4%)\ | | |
## | | | 11\. June\ | 168 ( 3.3%)\ | | |
## | | | 12\. July\ | 148 ( 2.9%)\ | | |
## | | | 13\. August\ | 140 ( 2.7%)\ | | |
## | | | 14\. Unknown\ | 13 ( 0.3%)\ | | |
## | | | 15\. Redacted | 10 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 140 | DEATH_YRNAME\ | 1\. Not Applicable (Non-fatal\ | 2749 (53.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. 2021\ | 331 ( 6.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. 2023\ | 324 ( 6.3%)\ | | |
## | | | 4\. 2017\ | 304 ( 5.9%)\ | | |
## | | | 5\. 2020\ | 302 ( 5.9%)\ | | |
## | | | 6\. 2018\ | 290 ( 5.6%)\ | | |
## | | | 7\. 2019\ | 281 ( 5.5%)\ | | |
## | | | 8\. 2022\ | 279 ( 5.4%)\ | | |
## | | | 9\. 2016\ | 259 ( 5.0%)\ | | |
## | | | 10\. Redacted\ | 10 ( 0.2%)\ | | |
## | | | 11\. Unknown\ | 7 ( 0.1%)\ | | |
## | | | 12\. 2024 | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 141 | DEATH_HRNAME\ | 1\. Not Applicable (Non-fatal\ | 2749 (53.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. 1:00-1:59\ | 153 ( 3.0%)\ | (99.9%) | (0.1%) |
## | | | 3\. 23:00-23:59\ | 142 ( 2.8%)\ | | |
## | | | 4\. Unknown\ | 132 ( 2.6%)\ | | |
## | | | 5\. 2:00-2:59\ | 128 ( 2.5%)\ | | |
## | | | 6\. 22:00-22:59\ | 123 ( 2.4%)\ | | |
## | | | 7\. 21:00-21:59\ | 121 ( 2.4%)\ | | |
## | | | 8\. 17:00-17:59\ | 120 ( 2.3%)\ | | |
## | | | 9\. 0:00-0:59\ | 113 ( 2.2%)\ | | |
## | | | 10\. 18:00-18:59\ | 113 ( 2.2%)\ | | |
## | | | 11\. 20:00-20:59\ | 110 ( 2.1%)\ | | |
## | | | 12\. 19:00-19:59\ | 108 ( 2.1%)\ | | |
## | | | 13\. 3:00-3:59\ | 105 ( 2.0%)\ | | |
## | | | 14\. 16:00-16:59\ | 90 ( 1.8%)\ | | |
## | | | 15\. 15:00-15:59\ | 83 ( 1.6%)\ | | |
## | | | 16\. 14:00-14:59\ | 82 ( 1.6%)\ | | |
## | | | 17\. 13:00-13:59\ | 80 ( 1.6%)\ | | |
## | | | 18\. 6:00-6:59\ | 75 ( 1.5%)\ | | |
## | | | 19\. 5:00-5:59\ | 73 ( 1.4%)\ | | |
## | | | 20\. 4:00-4:59\ | 72 ( 1.4%)\ | | |
## | | | 21\. 10:00-10:59\ | 69 ( 1.3%)\ | | |
## | | | 22\. 7:00-7:59\ | 66 ( 1.3%)\ | | |
## | | | 23\. 11:00-11:59\ | 60 ( 1.2%)\ | | |
## | | | 24\. 12:00-12:59\ | 59 ( 1.1%)\ | | |
## | | | 25\. 8:00-8:59\ | 51 ( 1.0%)\ | | |
## | | | 26\. 9:00-9:59\ | 51 ( 1.0%)\ | | |
## | | | 27\. Redacted | 10 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 142 | P_SF1NAME\ | 1\. None\ | 2459 (99.5%)\ | 2472\ | 2673\ |
## | | [factor] | 2\. Non-Driver Flees Scene\ | 4 ( 0.2%)\ | (48.0%) | (52.0%) |
## | | | 3\. Construction/Maintenance/\ | 1 ( 0.0%)\ | | |
## | | | 4\. Default Code Used for Veh\ | 1 ( 0.0%)\ | | |
## | | | 5\. Emergency Services Person\ | 1 ( 0.0%)\ | | |
## | | | 6\. Interfering With Driver\ | 1 ( 0.0%)\ | | |
## | | | 7\. Mother of Dead Fetus/Infa\ | 1 ( 0.0%)\ | | |
## | | | 8\. Person in Ambulance Treat\ | 1 ( 0.0%)\ | | |
## | | | 9\. Rain, Snow, Fog, Smoke, S\ | 1 ( 0.0%)\ | | |
## | | | 10\. Reported as Unknown\ | 1 ( 0.0%)\ | | |
## | | | 11\. Traveling on Prohibited T | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 143 | P_SF2NAME\ | 1\. None\ | 2471 (100.0%)\ | 2472\ | 2673\ |
## | | [factor] | 2\. Reported as Unknown | 1 ( 0.0%) | (48.0%) | (52.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 144 | P_SF3NAME\ | 1\. None\ | 2471 (100.0%)\ | 2472\ | 2673\ |
## | | [factor] | 2\. Reported as Unknown | 1 ( 0.0%) | (48.0%) | (52.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 145 | WORK_INJNAME\ | 1\. Not Applicable (not a fat\ | 2749 (53.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. No\ | 2184 (42.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown\ | 164 ( 3.2%)\ | | |
## | | | 4\. Yes\ | 31 ( 0.6%)\ | | |
## | | | 5\. Redacted | 10 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 146 | HISPANICNAME\ | 1\. Not A Fatality (not Appli\ | 2749 (53.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Non-Hispanic\ | 1751 (34.1%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown\ | 269 ( 5.2%)\ | | |
## | | | 4\. Hispanic, Origin Not Spec\ | 168 ( 3.3%)\ | | |
## | | | 5\. Mexican\ | 136 ( 2.6%)\ | | |
## | | | 6\. Puerto Rican\ | 25 ( 0.5%)\ | | |
## | | | 7\. Central or South American\ | 22 ( 0.4%)\ | | |
## | | | 8\. Redacted\ | 10 ( 0.2%)\ | | |
## | | | 9\. Cuban\ | 7 ( 0.1%)\ | | |
## | | | 10\. European Spanish | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 147 | RACENAME\ | 1\. Not a Fatality (not Appli\ | 1003 (54.0%)\ | 1856\ | 3289\ |
## | | [factor] | 2\. White\ | 569 (30.7%)\ | (36.1%) | (63.9%) |
## | | | 3\. Black\ | 176 ( 9.5%)\ | | |
## | | | 4\. Unknown\ | 50 ( 2.7%)\ | | |
## | | | 5\. All other races\ | 17 ( 0.9%)\ | | |
## | | | 6\. American Indian (includes\ | 8 ( 0.4%)\ | | |
## | | | 7\. Asian Indian\ | 7 ( 0.4%)\ | | |
## | | | 8\. Hawaiian (includes Part-H\ | 7 ( 0.4%)\ | | |
## | | | 9\. American Indian (includes\ | 3 ( 0.2%)\ | | |
## | | | 10\. Asian or Pacific Islander\ | 3 ( 0.2%)\ | | |
## | | | 11\. Korean\ | 3 ( 0.2%)\ | | |
## | | | 12\. Multiple Races (individua\ | 3 ( 0.2%)\ | | |
## | | | 13\. Other Asian or Pacific Is\ | 3 ( 0.2%)\ | | |
## | | | 14\. Filipino\ | 2 ( 0.1%)\ | | |
## | | | 15\. Japanese\ | 1 ( 0.1%)\ | | |
## | | | 16\. Other Indian (includes So | 1 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 148 | LOCATIONNAME\ | 1\. Occupant of a Motor Vehic\ | 4958 (96.5%)\ | 5138\ | 7\ |
## | | [factor] | 2\. Not at Intersection - On \ | 96 ( 1.9%)\ | (99.9%) | (0.1%) |
## | | | 3\. At Intersection - In Mark\ | 20 ( 0.4%)\ | | |
## | | | 4\. At Intersection - Not In \ | 12 ( 0.2%)\ | | |
## | | | 5\. Shoulder/Roadside\ | 12 ( 0.2%)\ | | |
## | | | 6\. Sidewalk\ | 12 ( 0.2%)\ | | |
## | | | 7\. Median/Crossing Island\ | 6 ( 0.1%)\ | | |
## | | | 8\. Not at Intersection - On \ | 6 ( 0.1%)\ | | |
## | | | 9\. At Intersection-Unmarked \ | 3 ( 0.1%)\ | | |
## | | | 10\. Non- Trafficway Area\ | 3 ( 0.1%)\ | | |
## | | | 11\. Not Reported\ | 2 ( 0.0%)\ | | |
## | | | 12\. Parking Lane/Zone\ | 2 ( 0.0%)\ | | |
## | | | 13\. Reported as Unknown Locat\ | 2 ( 0.0%)\ | | |
## | | | 14\. At Intersection - In Unma\ | 1 ( 0.0%)\ | | |
## | | | 15\. At Intersection - In Unma\ | 1 ( 0.0%)\ | | |
## | | | 16\. Bicycle Lane\ | 1 ( 0.0%)\ | | |
## | | | 17\. Other | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 149 | HELM_USENAME\ | 1\. Not Applicable\ | 3081 (93.9%)\ | 3282\ | 1863\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 117 ( 3.6%)\ | (63.8%) | (36.2%) |
## | | | 3\. No Helmet\ | 41 ( 1.2%)\ | | |
## | | | 4\. Helmet, Unknown if DOT-Co\ | 24 ( 0.7%)\ | | |
## | | | 5\. DOT-Compliant Motorcycle \ | 13 ( 0.4%)\ | | |
## | | | 6\. Reported as Unknown if He\ | 5 ( 0.2%)\ | | |
## | | | 7\. Helmet, Other than DOT-Co | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 150 | HELM_MISNAME\ | 1\. None Used/Not Applicable\ | 3127 (95.3%)\ | 3282\ | 1863\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 117 ( 3.6%)\ | (63.8%) | (36.2%) |
## | | | 3\. No Indication of Misuse\ | 28 ( 0.9%)\ | | |
## | | | 4\. No Indication of Mis-Use\ | 8 ( 0.2%)\ | | |
## | | | 5\. Yes, Indication of Mis-Us\ | 1 ( 0.0%)\ | | |
## | | | 6\. Yes, Indication of Misuse | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 151 | VPICBODYCLASSNAME\ | 1\. Sedan/Saloon\ | 928 (34.8%)\ | 2666\ | 2479\ |
## | | [factor] | 2\. Sport Utility Vehicle (SU\ | 631 (23.7%)\ | (51.8%) | (48.2%) |
## | | | 3\. Pickup\ | 402 (15.1%)\ | | |
## | | | 4\. Coupe\ | 126 ( 4.7%)\ | | |
## | | | 5\. (Empty string)\ | 98 ( 3.7%)\ | | |
## | | | 6\. Hatchback/Liftback/Notchb\ | 98 ( 3.7%)\ | | |
## | | | 7\. Truck-Tractor\ | 75 ( 2.8%)\ | | |
## | | | 8\. Minivan\ | 43 ( 1.6%)\ | | |
## | | | 9\. Crossover Utility Vehicle\ | 35 ( 1.3%)\ | | |
## | | | 10\. Van\ | 35 ( 1.3%)\ | | |
## | | | 11\. Convertible/Cabriolet\ | 24 ( 0.9%)\ | | |
## | | | 12\. Motorcycle - Sport\ | 22 ( 0.8%)\ | | |
## | | | 13\. Cargo Van\ | 18 ( 0.7%)\ | | |
## | | | 14\. Truck\ | 16 ( 0.6%)\ | | |
## | | | 15\. Motorcycle - Touring / Sp\ | 12 ( 0.5%)\ | | |
## | | | 16\. Unknown\ | 12 ( 0.5%)\ | | |
## | | | 17\. Wagon\ | 10 ( 0.4%)\ | | |
## | | | 18\. Bus\ | 8 ( 0.3%)\ | | |
## | | | 19\. Motorcycle - Cruiser\ | 8 ( 0.3%)\ | | |
## | | | 20\. Incomplete - Chassis Cab \ | 7 ( 0.3%)\ | | |
## | | | 21\. Incomplete - Cutaway\ | 7 ( 0.3%)\ | | |
## | | | 22\. Incomplete\ | 6 ( 0.2%)\ | | |
## | | | 23\. Motorcycle - Custom\ | 4 ( 0.2%)\ | | |
## | | | 24\. Motorcycle - Standard\ | 4 ( 0.2%)\ | | |
## | | | 25\. Motorcycle - Street\ | 4 ( 0.2%)\ | | |
## | | | 26\. Off-road Vehicle - All Te\ | 4 ( 0.2%)\ | | |
## | | | 27\. Sport Utility Truck (SUT)\ | 4 ( 0.2%)\ | | |
## | | | 28\. Fire Apparatus\ | 3 ( 0.1%)\ | | |
## | | | 29\. Incomplete - Chassis Cab \ | 3 ( 0.1%)\ | | |
## | | | 30\. Not Reported\ | 3 ( 0.1%)\ | | |
## | | | 31\. Off-road Vehicle - Recrea\ | 3 ( 0.1%)\ | | |
## | | | 32\. Incomplete - Chassis Cab \ | 2 ( 0.1%)\ | | |
## | | | 33\. Incomplete - Motor Home C\ | 2 ( 0.1%)\ | | |
## | | | 34\. Motorcycle - Unenclosed T\ | 2 ( 0.1%)\ | | |
## | | | 35\. Bus - School Bus\ | 1 ( 0.0%)\ | | |
## | | | 36\. Incomplete - Glider\ | 1 ( 0.0%)\ | | |
## | | | 37\. Incomplete - School Bus C\ | 1 ( 0.0%)\ | | |
## | | | 38\. Motorcycle - Dual Sport /\ | 1 ( 0.0%)\ | | |
## | | | 39\. Motorcycle - Scooter\ | 1 ( 0.0%)\ | | |
## | | | 40\. Off-road Vehicle - Motocr\ | 1 ( 0.0%)\ | | |
## | | | 41\. Roadster | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 152 | ICFINALBODYNAME\ | 1\. Not Applicable\ | 2539 (95.2%)\ | 2666\ | 2479\ |
## | | [factor] | 2\. (Empty string)\ | 98 ( 3.7%)\ | (51.8%) | (48.2%) |
## | | | 3\. Pickup\ | 11 ( 0.4%)\ | | |
## | | | 4\. Motorhome\ | 4 ( 0.2%)\ | | |
## | | | 5\. Truck\ | 4 ( 0.2%)\ | | |
## | | | 6\. Van\ | 4 ( 0.2%)\ | | |
## | | | 7\. Ambulance\ | 3 ( 0.1%)\ | | |
## | | | 8\. Bus - School Bus\ | 1 ( 0.0%)\ | | |
## | | | 9\. Cargo Van\ | 1 ( 0.0%)\ | | |
## | | | 10\. Truck-Tractor | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
Comparison with All FARS
dat3= dat2[, c("MONTHNAME", "DAY_WEEKNAME", "HOURNAME", "VE_TOTAL", "VEH_NO", "PER_NO",
"NUMOCCS", "ROUTENAME", "RUR_URBNAME", "FUNC_SYSNAME",
"RD_OWNERNAME", "HARM_EVNAME", "MAN_COLLNAME",
"TYP_INTNAME", "LGT_CONDNAME", "WEATHERNAME",
"CF1NAME", "BODY_TYPNAME", "TRAV_SPNAME", "M_HARMNAME",
"L_RESTRINAME", "SPEEDRELNAME", "DR_SF1NAME",
"VTRAFWAYNAME", "VNUM_LANNAME", "VSPD_LIMNAME",
"VALIGNNAME", "VPROFILENAME", "VSURCONDNAME",
"VTRAFCONNAME", "VTCONT_FNAME", "P_CRASH1NAME",
"ACC_TYPENAME", "AGENAME", "SEXNAME", "ALC_RESNAME",
"WORK_INJNAME", "HISPANICNAME", "RACENAME")]
dim(dat3)
## [1] 5145 39
datt= dat[, c("MONTHNAME", "DAY_WEEKNAME", "HOURNAME", "VE_TOTAL", "VEH_NO", "PER_NO",
"NUMOCCS", "ROUTENAME", "RUR_URBNAME", "FUNC_SYSNAME",
"RD_OWNERNAME", "HARM_EVNAME", "MAN_COLLNAME",
"TYP_INTNAME", "LGT_CONDNAME", "WEATHERNAME",
"CF1NAME", "BODY_TYPNAME", "TRAV_SPNAME", "M_HARMNAME",
"L_RESTRINAME", "SPEEDRELNAME", "DR_SF1NAME",
"VTRAFWAYNAME", "VNUM_LANNAME", "VSPD_LIMNAME",
"VALIGNNAME", "VPROFILENAME", "VSURCONDNAME",
"VTRAFCONNAME", "VTCONT_FNAME", "P_CRASH1NAME",
"ACC_TYPENAME", "AGENAME", "SEXNAME", "ALC_RESNAME",
"WORK_INJNAME", "HISPANICNAME", "RACENAME")]
library(dplyr)
library(tidyr)
library(DT)
# Step 1: Select character/factor variables to compare
vars_to_compare <- datt %>%
select(where(~is.character(.x) || is.factor(.x))) %>%
names()
get_count_and_percentage <- function(data, variable) {
data %>%
filter(!is.na(.data[[variable]]) & .data[[variable]] != "") %>% # Exclude NA/blank
count(Value = .data[[variable]]) %>%
mutate(Percentage = 100 * n / sum(n)) %>% # Use `n` before renaming
rename(Count = n)
}
# Step 3: Loop through variables and compare
comparison_list <- lapply(vars_to_compare, function(var) {
orig <- get_count_and_percentage(datt, var) %>%
rename(Orig_Count = Count, Orig_Perc = Percentage)
sub <- get_count_and_percentage(dat3, var) %>%
rename(Sub_Count = Count, Sub_Perc = Percentage)
merged <- full_join(orig, sub, by = "Value") %>%
mutate(Variable = var) %>%
replace_na(list(Orig_Count = 0, Sub_Count = 0, Orig_Perc = 0, Sub_Perc = 0)) %>%
mutate(
Orig_Perc = round(Orig_Perc, 3),
Sub_Perc = round(Sub_Perc, 3),
Diff = round(Sub_Perc - Orig_Perc, 3)
) %>%
arrange(Sub_Perc)
})
# Step 4: Combine into one data frame
comparison_df <- bind_rows(comparison_list) %>%
select(Variable, Value, Orig_Count, Sub_Count, Orig_Perc, Sub_Perc, Diff)
# Step 5: Visualize with colored difference
DT::datatable(comparison_df, options = list(pageLength = 25)) %>%
DT::formatStyle(
'Diff',
color = DT::styleInterval(0, c('red', 'green')) # red for negative, green for positive
)