Desc Stat
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(VTRAFWAYNAME=="Entrance/Exit Ramp")) %>%
ungroup()
dim(dat1)
## [1] 12502 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] 12502 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_Ramp_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:** 12502 x 148
## **Duplicates:** 150
##
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | No | Variable | Stats / Values | Freqs (% of Valid) | Valid | Missing |
## +=====+====================+==================================+====================+==========+=========+
## | 1 | VE_TOTAL\ | 1\. 1\ | 6157 (49.2%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2\ | 4392 (35.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 1175 ( 9.4%)\ | | |
## | | | 4\. 4\ | 428 ( 3.4%)\ | | |
## | | | 5\. 5\ | 145 ( 1.2%)\ | | |
## | | | 6\. 6\ | 69 ( 0.6%)\ | | |
## | | | 7\. 7\ | 63 ( 0.5%)\ | | |
## | | | 8\. 10\ | 42 ( 0.3%)\ | | |
## | | | 9\. 8 | 31 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 2 | DAY\ | 1\. 19\ | 510 (4.1%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2\ | 494 (4.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 12\ | 459 (3.7%)\ | | |
## | | | 4\. 15\ | 459 (3.7%)\ | | |
## | | | 5\. 30\ | 459 (3.7%)\ | | |
## | | | 6\. 4\ | 431 (3.4%)\ | | |
## | | | 7\. 13\ | 429 (3.4%)\ | | |
## | | | 8\. 3\ | 417 (3.3%)\ | | |
## | | | 9\. 11\ | 416 (3.3%)\ | | |
## | | | 10\. 16\ | 416 (3.3%)\ | | |
## | | | 11\. 20\ | 416 (3.3%)\ | | |
## | | | 12\. 22\ | 413 (3.3%)\ | | |
## | | | 13\. 18\ | 411 (3.3%)\ | | |
## | | | 14\. 1\ | 409 (3.3%)\ | | |
## | | | 15\. 5\ | 409 (3.3%)\ | | |
## | | | 16\. 6\ | 401 (3.2%)\ | | |
## | | | 17\. 7\ | 400 (3.2%)\ | | |
## | | | 18\. 28\ | 394 (3.2%)\ | | |
## | | | 19\. 14\ | 393 (3.1%)\ | | |
## | | | 20\. 8\ | 390 (3.1%)\ | | |
## | | | 21\. 9\ | 390 (3.1%)\ | | |
## | | | 22\. 10\ | 390 (3.1%)\ | | |
## | | | 23\. 26\ | 389 (3.1%)\ | | |
## | | | 24\. 29\ | 386 (3.1%)\ | | |
## | | | 25\. 17\ | 385 (3.1%)\ | | |
## | | | 26\. 25\ | 381 (3.0%)\ | | |
## | | | 27\. 23\ | 378 (3.0%)\ | | |
## | | | 28\. 21\ | 374 (3.0%)\ | | |
## | | | 29\. 27\ | 373 (3.0%)\ | | |
## | | | 30\. 24\ | 371 (3.0%)\ | | |
## | | | 31\. 31 | 159 (1.3%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 3 | MONTH\ | 1\. 10\ | 1181 (9.4%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 8\ | 1150 (9.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 7\ | 1129 (9.0%)\ | | |
## | | | 4\. 5\ | 1107 (8.9%)\ | | |
## | | | 5\. 9\ | 1085 (8.7%)\ | | |
## | | | 6\. 11\ | 1084 (8.7%)\ | | |
## | | | 7\. 12\ | 1016 (8.1%)\ | | |
## | | | 8\. 3\ | 993 (7.9%)\ | | |
## | | | 9\. 6\ | 975 (7.8%)\ | | |
## | | | 10\. 1\ | 955 (7.6%)\ | | |
## | | | 11\. 4\ | 946 (7.6%)\ | | |
## | | | 12\. 2 | 881 (7.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 4 | MONTHNAME\ | 1\. October\ | 1181 (9.4%)\ | 12502\ | 0\ |
## | | [factor] | 2\. August\ | 1150 (9.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. July\ | 1129 (9.0%)\ | | |
## | | | 4\. May\ | 1107 (8.9%)\ | | |
## | | | 5\. September\ | 1085 (8.7%)\ | | |
## | | | 6\. November\ | 1084 (8.7%)\ | | |
## | | | 7\. December\ | 1016 (8.1%)\ | | |
## | | | 8\. March\ | 993 (7.9%)\ | | |
## | | | 9\. June\ | 975 (7.8%)\ | | |
## | | | 10\. January\ | 955 (7.6%)\ | | |
## | | | 11\. April\ | 946 (7.6%)\ | | |
## | | | 12\. February | 881 (7.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 5 | YEAR\ | 1\. 2022\ | 2005 (16.0%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2023\ | 1781 (14.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2021\ | 1635 (13.1%)\ | | |
## | | | 4\. 2019\ | 1561 (12.5%)\ | | |
## | | | 5\. 2020\ | 1538 (12.3%)\ | | |
## | | | 6\. 2018\ | 1433 (11.5%)\ | | |
## | | | 7\. 2017\ | 1301 (10.4%)\ | | |
## | | | 8\. 2016 | 1248 (10.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 6 | DAY_WEEKNAME\ | 1\. Saturday\ | 2259 (18.1%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Sunday\ | 2207 (17.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. Friday\ | 1891 (15.1%)\ | | |
## | | | 4\. Monday\ | 1609 (12.9%)\ | | |
## | | | 5\. Thursday\ | 1601 (12.8%)\ | | |
## | | | 6\. Tuesday\ | 1548 (12.4%)\ | | |
## | | | 7\. Wednesday | 1387 (11.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 7 | HOUR\ | 1\. 2\ | 700 (5.6%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 1\ | 683 (5.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. 20\ | 643 (5.1%)\ | | |
## | | | 4\. 21\ | 632 (5.1%)\ | | |
## | | | 5\. 23\ | 625 (5.0%)\ | | |
## | | | 6\. 15\ | 615 (4.9%)\ | | |
## | | | 7\. 0\ | 612 (4.9%)\ | | |
## | | | 8\. 18\ | 604 (4.8%)\ | | |
## | | | 9\. 22\ | 603 (4.8%)\ | | |
## | | | 10\. 19\ | 591 (4.7%)\ | | |
## | | | 11\. 3\ | 560 (4.5%)\ | | |
## | | | 12\. 14\ | 558 (4.5%)\ | | |
## | | | 13\. 17\ | 554 (4.4%)\ | | |
## | | | 14\. 16\ | 548 (4.4%)\ | | |
## | | | 15\. 13\ | 497 (4.0%)\ | | |
## | | | 16\. 5\ | 486 (3.9%)\ | | |
## | | | 17\. 6\ | 468 (3.7%)\ | | |
## | | | 18\. 9\ | 386 (3.1%)\ | | |
## | | | 19\. 12\ | 384 (3.1%)\ | | |
## | | | 20\. 4\ | 372 (3.0%)\ | | |
## | | | 21\. 10\ | 351 (2.8%)\ | | |
## | | | 22\. 11\ | 334 (2.7%)\ | | |
## | | | 23\. 7\ | 322 (2.6%)\ | | |
## | | | 24\. 8\ | 290 (2.3%)\ | | |
## | | | 25\. 99 | 84 (0.7%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 8 | HOURNAME\ | 1\. 2:00am-2:59am\ | 700 (5.6%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 1:00am-1:59am\ | 683 (5.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. 8:00pm-8:59pm\ | 643 (5.1%)\ | | |
## | | | 4\. 9:00pm-9:59pm\ | 632 (5.1%)\ | | |
## | | | 5\. 11:00pm-11:59pm\ | 625 (5.0%)\ | | |
## | | | 6\. 3:00pm-3:59pm\ | 615 (4.9%)\ | | |
## | | | 7\. 0:00am-0:59am\ | 612 (4.9%)\ | | |
## | | | 8\. 6:00pm-6:59pm\ | 604 (4.8%)\ | | |
## | | | 9\. 10:00pm-10:59pm\ | 603 (4.8%)\ | | |
## | | | 10\. 7:00pm-7:59pm\ | 591 (4.7%)\ | | |
## | | | 11\. 3:00am-3:59am\ | 560 (4.5%)\ | | |
## | | | 12\. 2:00pm-2:59pm\ | 558 (4.5%)\ | | |
## | | | 13\. 5:00pm-5:59pm\ | 554 (4.4%)\ | | |
## | | | 14\. 4:00pm-4:59pm\ | 548 (4.4%)\ | | |
## | | | 15\. 1:00pm-1:59pm\ | 497 (4.0%)\ | | |
## | | | 16\. 5:00am-5:59am\ | 486 (3.9%)\ | | |
## | | | 17\. 6:00am-6:59am\ | 468 (3.7%)\ | | |
## | | | 18\. 9:00am-9:59am\ | 386 (3.1%)\ | | |
## | | | 19\. 12:00pm-12:59pm\ | 384 (3.1%)\ | | |
## | | | 20\. 4:00am-4:59am\ | 372 (3.0%)\ | | |
## | | | 21\. 10:00am-10:59am\ | 351 (2.8%)\ | | |
## | | | 22\. 11:00am-11:59am\ | 334 (2.7%)\ | | |
## | | | 23\. 7:00am-7:59am\ | 322 (2.6%)\ | | |
## | | | 24\. 8:00am-8:59am\ | 290 (2.3%)\ | | |
## | | | 25\. Unknown Hours | 84 (0.7%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 9 | NHSNAME\ | 1\. This section IS ON the NH\ | 9416 (75.3%)\ | 12502\ | 0\ |
## | | [factor] | 2\. This Section IS ON the NH\ | 1552 (12.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. This section IS NOT on th\ | 1296 (10.4%)\ | | |
## | | | 4\. This Section IS NOT on th\ | 224 ( 1.8%)\ | | |
## | | | 5\. Unknown if this section i\ | 9 ( 0.1%)\ | | |
## | | | 6\. Unknown if This Section I | 5 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 10 | ROUTENAME\ | 1\. Interstate\ | 7084 (56.7%)\ | 12502\ | 0\ |
## | | [factor] | 2\. State Highway\ | 3055 (24.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. U.S. Highway\ | 1406 (11.2%)\ | | |
## | | | 4\. Local Street - Municipali\ | 339 ( 2.7%)\ | | |
## | | | 5\. Other\ | 203 ( 1.6%)\ | | |
## | | | 6\. Local Street - Frontage R\ | 125 ( 1.0%)\ | | |
## | | | 7\. County Road\ | 113 ( 0.9%)\ | | |
## | | | 8\. Municipal\ | 50 ( 0.4%)\ | | |
## | | | 9\. Not Signed\ | 36 ( 0.3%)\ | | |
## | | | 10\. Unknown\ | 35 ( 0.3%)\ | | |
## | | | 11\. County\ | 23 ( 0.2%)\ | | |
## | | | 12\. Unknown/Not Reported\ | 18 ( 0.1%)\ | | |
## | | | 13\. Local Street - Township | 15 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 11 | RUR_URBNAME\ | 1\. Urban\ | 10452 (83.6%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Rural\ | 2040 (16.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Trafficway Not in State I\ | 6 ( 0.0%)\ | | |
## | | | 4\. Not Reported\ | 2 ( 0.0%)\ | | |
## | | | 5\. Unknown | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 12 | FUNC_SYSNAME\ | 1\. Interstate\ | 7226 (57.8%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Principal Arterial - Othe\ | 2152 (17.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Principal Arterial - Othe\ | 1554 (12.4%)\ | | |
## | | | 4\. Minor Arterial\ | 533 ( 4.3%)\ | | |
## | | | 5\. Other Freeways and Expres\ | 333 ( 2.7%)\ | | |
## | | | 6\. Major Collector\ | 289 ( 2.3%)\ | | |
## | | | 7\. Other Principal Arterial\ | 273 ( 2.2%)\ | | |
## | | | 8\. Local\ | 95 ( 0.8%)\ | | |
## | | | 9\. Minor Collector\ | 34 ( 0.3%)\ | | |
## | | | 10\. Not Reported\ | 6 ( 0.0%)\ | | |
## | | | 11\. Trafficway Not in State I\ | 6 ( 0.0%)\ | | |
## | | | 12\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 13 | RD_OWNERNAME\ | 1\. State Highway Agency\ | 10994 (87.9%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 753 ( 6.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. City or Municipal Highway\ | 313 ( 2.5%)\ | | |
## | | | 4\. State Toll Road\ | 227 ( 1.8%)\ | | |
## | | | 5\. County Highway Agency\ | 135 ( 1.1%)\ | | |
## | | | 6\. Unknown\ | 22 ( 0.2%)\ | | |
## | | | 7\. Town or Township Highway \ | 17 ( 0.1%)\ | | |
## | | | 8\. State Park, Forest, or Re\ | 13 ( 0.1%)\ | | |
## | | | 9\. Other State Agency\ | 12 ( 0.1%)\ | | |
## | | | 10\. Trafficway Not in State I\ | 6 ( 0.0%)\ | | |
## | | | 11\. Other Local Agency\ | 4 ( 0.0%)\ | | |
## | | | 12\. Other Federal Agency\ | 3 ( 0.0%)\ | | |
## | | | 13\. National Park Service\ | 2 ( 0.0%)\ | | |
## | | | 14\. Local Toll Authority | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 14 | SP_JURNAME\ | 1\. No Special Jurisdiction\ | 12465 (99.7%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Indian Reservation\ | 25 ( 0.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. National Park Service\ | 10 ( 0.1%)\ | | |
## | | | 4\. Military | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 15 | HARM_EVNAME\ | 1\. Motor Vehicle In-Transpor\ | 4526 (36.2%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Pedestrian\ | 1751 (14.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rollover/Overturn\ | 1095 ( 8.8%)\ | | |
## | | | 4\. Concrete Traffic Barrier\ | 747 ( 6.0%)\ | | |
## | | | 5\. Curb\ | 604 ( 4.8%)\ | | |
## | | | 6\. Guardrail Face\ | 602 ( 4.8%)\ | | |
## | | | 7\. Tree (Standing Only)\ | 433 ( 3.5%)\ | | |
## | | | 8\. Parked Motor Vehicle\ | 345 ( 2.8%)\ | | |
## | | | 9\. Traffic Sign Support\ | 327 ( 2.6%)\ | | |
## | | | 10\. Embankment\ | 255 ( 2.0%)\ | | |
## | | | 11\. Impact Attenuator/Crash C\ | 225 ( 1.8%)\ | | |
## | | | 12\. Ditch\ | 200 ( 1.6%)\ | | |
## | | | 13\. Pedalcyclist\ | 166 ( 1.3%)\ | | |
## | | | 14\. Utility Pole/Light Suppor\ | 156 ( 1.2%)\ | | |
## | | | 15\. Post, Pole or Other Suppo\ | 133 ( 1.1%)\ | | |
## | | | 16\. Bridge Pier or Support\ | 103 ( 0.8%)\ | | |
## | | | 17\. Bridge Rail (Includes par\ | 103 ( 0.8%)\ | | |
## | | | 18\. Guardrail End\ | 92 ( 0.7%)\ | | |
## | | | 19\. Fell/Jumped from Vehicle\ | 77 ( 0.6%)\ | | |
## | | | 20\. Wall\ | 77 ( 0.6%)\ | | |
## | | | 21\. Other Object (not fixed)\ | 71 ( 0.6%)\ | | |
## | | | 22\. Other Traffic Barrier\ | 64 ( 0.5%)\ | | |
## | | | 23\. Other Fixed Object\ | 61 ( 0.5%)\ | | |
## | | | 24\. Fence\ | 47 ( 0.4%)\ | | |
## | | | 25\. Culvert\ | 29 ( 0.2%)\ | | |
## | | | 26\. Traffic Signal Support\ | 29 ( 0.2%)\ | | |
## | | | 27\. Shrubbery\ | 28 ( 0.2%)\ | | |
## | | | 28\. Non-Motorist on Personal \ | 23 ( 0.2%)\ | | |
## | | | 29\. Motor Vehicle In-Transpor\ | 19 ( 0.2%)\ | | |
## | | | 30\. Ground\ | 18 ( 0.1%)\ | | |
## | | | 31\. Other Non-Collision\ | 15 ( 0.1%)\ | | |
## | | | 32\. Immersion or Partial Imme\ | 12 ( 0.1%)\ | | |
## | | | 33\. Snow Bank\ | 11 ( 0.1%)\ | | |
## | | | 34\. Boulder\ | 9 ( 0.1%)\ | | |
## | | | 35\. Cable Barrier\ | 9 ( 0.1%)\ | | |
## | | | 36\. Working Motor Vehicle\ | 7 ( 0.1%)\ | | |
## | | | 37\. Building\ | 4 ( 0.0%)\ | | |
## | | | 38\. Cargo/Equipment Loss or S\ | 4 ( 0.0%)\ | | |
## | | | 39\. Object That Had Fallen Fr\ | 4 ( 0.0%)\ | | |
## | | | 40\. Pavement Surface Irregula\ | 4 ( 0.0%)\ | | |
## | | | 41\. Unknown Fixed Object\ | 4 ( 0.0%)\ | | |
## | | | 42\. Live Animal\ | 3 ( 0.0%)\ | | |
## | | | 43\. Cargo/Equipment Loss, Shi\ | 2 ( 0.0%)\ | | |
## | | | 44\. Mail Box\ | 2 ( 0.0%)\ | | |
## | | | 45\. Thrown or Falling Object\ | 2 ( 0.0%)\ | | |
## | | | 46\. Unknown\ | 2 ( 0.0%)\ | | |
## | | | 47\. Jackknife (harmful to thi\ | 1 ( 0.0%)\ | | |
## | | | 48\. Reported as Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 16 | MAN_COLLNAME\ | 1\. The First Harmful Event w\ | 5477 (43.8%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Not a Collision with Moto\ | 2477 (19.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Angle\ | 2259 (18.1%)\ | | |
## | | | 4\. Front-to-Rear\ | 1053 ( 8.4%)\ | | |
## | | | 5\. Sideswipe - Same Directio\ | 579 ( 4.6%)\ | | |
## | | | 6\. Front-to-Front\ | 512 ( 4.1%)\ | | |
## | | | 7\. Other\ | 52 ( 0.4%)\ | | |
## | | | 8\. Sideswipe - Opposite Dire\ | 49 ( 0.4%)\ | | |
## | | | 9\. Not Reported\ | 16 ( 0.1%)\ | | |
## | | | 10\. Rear-to-Side\ | 16 ( 0.1%)\ | | |
## | | | 11\. Reported as Unknown\ | 10 ( 0.1%)\ | | |
## | | | 12\. Unknown | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 17 | RELJCT1NAME\ | 1\. Yes\ | 10787 (86.3%)\ | 12502\ | 0\ |
## | | [factor] | 2\. No\ | 1703 (13.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 11 ( 0.1%)\ | | |
## | | | 4\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 18 | RELJCT2NAME\ | 1\. Entrance/Exit Ramp Relate\ | 7235 (57.9%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Entrance/Exit Ramp\ | 2714 (21.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. Intersection\ | 1420 (11.4%)\ | | |
## | | | 4\. Intersection-Related\ | 757 ( 6.1%)\ | | |
## | | | 5\. Other location within Int\ | 179 ( 1.4%)\ | | |
## | | | 6\. Non-Junction\ | 81 ( 0.6%)\ | | |
## | | | 7\. Through Roadway\ | 79 ( 0.6%)\ | | |
## | | | 8\. Acceleration/Deceleration\ | 34 ( 0.3%)\ | | |
## | | | 9\. Driveway Access Related | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 19 | TYP_INTNAME\ | 1\. Not an Intersection\ | 10325 (82.6%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Four-Way Intersection\ | 1229 ( 9.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. T-Intersection\ | 713 ( 5.7%)\ | | |
## | | | 4\. Y-Intersection\ | 153 ( 1.2%)\ | | |
## | | | 5\. Not Reported\ | 24 ( 0.2%)\ | | |
## | | | 6\. Five Point, or More\ | 22 ( 0.2%)\ | | |
## | | | 7\. Roundabout\ | 17 ( 0.1%)\ | | |
## | | | 8\. Other Intersection Type\ | 11 ( 0.1%)\ | | |
## | | | 9\. L-Intersection\ | 5 ( 0.0%)\ | | |
## | | | 10\. Traffic Circle | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 20 | WRK_ZONENAME\ | 1\. None\ | 12092 (96.7%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Construction\ | 242 ( 1.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Work Zone, Type Unknown\ | 157 ( 1.3%)\ | | |
## | | | 4\. Maintenance | 11 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 21 | REL_ROADNAME\ | 1\. On Roadway\ | 6794 (54.3%)\ | 12502\ | 0\ |
## | | [factor] | 2\. On Roadside\ | 3589 (28.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. Gore\ | 1129 ( 9.0%)\ | | |
## | | | 4\. On Shoulder\ | 344 ( 2.8%)\ | | |
## | | | 5\. On Median\ | 298 ( 2.4%)\ | | |
## | | | 6\. Separator\ | 159 ( 1.3%)\ | | |
## | | | 7\. Outside Trafficway\ | 121 ( 1.0%)\ | | |
## | | | 8\. Pedestrian Refuge Island \ | 30 ( 0.2%)\ | | |
## | | | 9\. Off Roadway-Location Unkn\ | 29 ( 0.2%)\ | | |
## | | | 10\. Reported as Unknown\ | 5 ( 0.0%)\ | | |
## | | | 11\. Not Reported | 4 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 22 | LGT_CONDNAME\ | 1\. Daylight\ | 5247 (42.0%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Dark - Lighted\ | 4053 (32.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Dark - Not Lighted\ | 2590 (20.7%)\ | | |
## | | | 4\. Dawn\ | 224 ( 1.8%)\ | | |
## | | | 5\. Dusk\ | 216 ( 1.7%)\ | | |
## | | | 6\. Dark - Unknown Lighting\ | 123 ( 1.0%)\ | | |
## | | | 7\. Reported as Unknown\ | 25 ( 0.2%)\ | | |
## | | | 8\. Not Reported\ | 19 ( 0.2%)\ | | |
## | | | 9\. Unknown\ | 3 ( 0.0%)\ | | |
## | | | 10\. Other | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 23 | WEATHER1NAME\ | 1\. Clear\ | 3777 (68.1%)\ | 5543\ | 6959\ |
## | | [factor] | 2\. Cloudy\ | 862 (15.6%)\ | (44.3%) | (55.7%) |
## | | | 3\. Rain\ | 407 ( 7.3%)\ | | |
## | | | 4\. Not Reported\ | 331 ( 6.0%)\ | | |
## | | | 5\. Fog, Smog, Smoke\ | 95 ( 1.7%)\ | | |
## | | | 6\. Snow\ | 24 ( 0.4%)\ | | |
## | | | 7\. Sleet or Hail\ | 17 ( 0.3%)\ | | |
## | | | 8\. Unknown\ | 12 ( 0.2%)\ | | |
## | | | 9\. Reported as Unknown\ | 7 ( 0.1%)\ | | |
## | | | 10\. Freezing Rain or Drizzle\ | 4 ( 0.1%)\ | | |
## | | | 11\. Severe Crosswinds\ | 4 ( 0.1%)\ | | |
## | | | 12\. Blowing Snow\ | 2 ( 0.0%)\ | | |
## | | | 13\. Other | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 24 | WEATHER2NAME\ | 1\. No Additional Atmospheric\ | 5475 (98.8%)\ | 5543\ | 6959\ |
## | | [factor] | 2\. Rain\ | 30 ( 0.5%)\ | (44.3%) | (55.7%) |
## | | | 3\. Cloudy\ | 29 ( 0.5%)\ | | |
## | | | 4\. Blowing Snow\ | 3 ( 0.1%)\ | | |
## | | | 5\. Severe Crosswinds\ | 2 ( 0.0%)\ | | |
## | | | 6\. Sleet or Hail\ | 2 ( 0.0%)\ | | |
## | | | 7\. Snow | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 25 | WEATHERNAME\ | 1\. Clear\ | 8959 (71.7%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Cloudy\ | 1709 (13.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rain\ | 883 ( 7.1%)\ | | |
## | | | 4\. Not Reported\ | 613 ( 4.9%)\ | | |
## | | | 5\. Fog, Smog, Smoke\ | 144 ( 1.2%)\ | | |
## | | | 6\. Snow\ | 64 ( 0.5%)\ | | |
## | | | 7\. Sleet or Hail\ | 43 ( 0.3%)\ | | |
## | | | 8\. Reported as Unknown\ | 33 ( 0.3%)\ | | |
## | | | 9\. Severe Crosswinds\ | 21 ( 0.2%)\ | | |
## | | | 10\. Unknown\ | 12 ( 0.1%)\ | | |
## | | | 11\. Other\ | 10 ( 0.1%)\ | | |
## | | | 12\. Blowing Snow\ | 7 ( 0.1%)\ | | |
## | | | 13\. Freezing Rain or Drizzle | 4 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 26 | SCH_BUSNAME\ | 1\. No\ | 12479 (99.8%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Yes | 23 ( 0.2%) | (100.0%) | (0.0%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 27 | RAILNAME\ | 1\. Not Applicable | 12502 (100.0%) | 12502\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 28 | NOT_HOURNAME\ | 1\. Unknown\ | 6781 (54.2%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2:00am-2:59am\ | 336 ( 2.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 6:00pm-6:59pm\ | 298 ( 2.4%)\ | | |
## | | | 4\. 1:00am-1:59am\ | 295 ( 2.4%)\ | | |
## | | | 5\. 4:00pm-4:59pm\ | 283 ( 2.3%)\ | | |
## | | | 6\. 8:00pm-8:59pm\ | 276 ( 2.2%)\ | | |
## | | | 7\. 2:00pm-2:59pm\ | 272 ( 2.2%)\ | | |
## | | | 8\. 11:00pm-11:59pm\ | 271 ( 2.2%)\ | | |
## | | | 9\. 9:00pm-9:59pm\ | 267 ( 2.1%)\ | | |
## | | | 10\. 3:00pm-3:59pm\ | 258 ( 2.1%)\ | | |
## | | | 11\. 7:00pm-7:59pm\ | 255 ( 2.0%)\ | | |
## | | | 12\. 0:00am-0:59am\ | 252 ( 2.0%)\ | | |
## | | | 13\. 3:00am-3:59am\ | 251 ( 2.0%)\ | | |
## | | | 14\. 10:00pm-10:59pm\ | 248 ( 2.0%)\ | | |
## | | | 15\. 5:00pm-5:59pm\ | 248 ( 2.0%)\ | | |
## | | | 16\. 1:00pm-1:59pm\ | 232 ( 1.9%)\ | | |
## | | | 17\. 12:00pm-12:59pm\ | 226 ( 1.8%)\ | | |
## | | | 18\. 6:00am-6:59am\ | 226 ( 1.8%)\ | | |
## | | | 19\. 9:00am-9:59am\ | 204 ( 1.6%)\ | | |
## | | | 20\. 10:00am-10:59am\ | 167 ( 1.3%)\ | | |
## | | | 21\. 7:00am-7:59am\ | 162 ( 1.3%)\ | | |
## | | | 22\. 8:00am-8:59am\ | 161 ( 1.3%)\ | | |
## | | | 23\. 5:00am-5:59am\ | 160 ( 1.3%)\ | | |
## | | | 24\. 11:00am-11:59am\ | 158 ( 1.3%)\ | | |
## | | | 25\. 4:00am-4:59am\ | 150 ( 1.2%)\ | | |
## | | | 26\. Not Applicable (Not Notif | 65 ( 0.5%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 29 | ARR_HOUR\ | 1\. 99\ | 6969 (55.7%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2\ | 350 ( 2.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. 14\ | 283 ( 2.3%)\ | | |
## | | | 4\. 20\ | 275 ( 2.2%)\ | | |
## | | | 5\. 16\ | 266 ( 2.1%)\ | | |
## | | | 6\. 18\ | 264 ( 2.1%)\ | | |
## | | | 7\. 15\ | 261 ( 2.1%)\ | | |
## | | | 8\. 19\ | 259 ( 2.1%)\ | | |
## | | | 9\. 23\ | 257 ( 2.1%)\ | | |
## | | | 10\. 17\ | 256 ( 2.0%)\ | | |
## | | | 11\. 21\ | 255 ( 2.0%)\ | | |
## | | | 12\. 1\ | 251 ( 2.0%)\ | | |
## | | | 13\. 22\ | 243 ( 1.9%)\ | | |
## | | | 14\. 0\ | 235 ( 1.9%)\ | | |
## | | | 15\. 3\ | 226 ( 1.8%)\ | | |
## | | | 16\. 13\ | 219 ( 1.8%)\ | | |
## | | | 17\. 6\ | 216 ( 1.7%)\ | | |
## | | | 18\. 9\ | 212 ( 1.7%)\ | | |
## | | | 19\. 12\ | 203 ( 1.6%)\ | | |
## | | | 20\. 11\ | 165 ( 1.3%)\ | | |
## | | | 21\. 7\ | 157 ( 1.3%)\ | | |
## | | | 22\. 8\ | 157 ( 1.3%)\ | | |
## | | | 23\. 4\ | 156 ( 1.2%)\ | | |
## | | | 24\. 5\ | 152 ( 1.2%)\ | | |
## | | | 25\. 10\ | 150 ( 1.2%)\ | | |
## | | | 26\. 88 | 65 ( 0.5%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 30 | ARR_HOURNAME\ | 1\. Unknown EMS Scene Arrival\ | 6969 (55.7%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2:00am-2:59am\ | 350 ( 2.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2:00pm-2:59pm\ | 283 ( 2.3%)\ | | |
## | | | 4\. 8:00pm-8:59pm\ | 275 ( 2.2%)\ | | |
## | | | 5\. 4:00pm-4:59pm\ | 266 ( 2.1%)\ | | |
## | | | 6\. 6:00pm-6:59pm\ | 264 ( 2.1%)\ | | |
## | | | 7\. 3:00pm-3:59pm\ | 261 ( 2.1%)\ | | |
## | | | 8\. 7:00pm-7:59pm\ | 259 ( 2.1%)\ | | |
## | | | 9\. 11:00pm-11:59pm\ | 257 ( 2.1%)\ | | |
## | | | 10\. 5:00pm-5:59pm\ | 256 ( 2.0%)\ | | |
## | | | 11\. 9:00pm-9:59pm\ | 255 ( 2.0%)\ | | |
## | | | 12\. 1:00am-1:59am\ | 251 ( 2.0%)\ | | |
## | | | 13\. 10:00pm-10:59pm\ | 243 ( 1.9%)\ | | |
## | | | 14\. 0:00am-0:59am\ | 235 ( 1.9%)\ | | |
## | | | 15\. 3:00am-3:59am\ | 226 ( 1.8%)\ | | |
## | | | 16\. 1:00pm-1:59pm\ | 219 ( 1.8%)\ | | |
## | | | 17\. 6:00am-6:59am\ | 216 ( 1.7%)\ | | |
## | | | 18\. 9:00am-9:59am\ | 212 ( 1.7%)\ | | |
## | | | 19\. 12:00pm-12:59pm\ | 203 ( 1.6%)\ | | |
## | | | 20\. 11:00am-11:59am\ | 165 ( 1.3%)\ | | |
## | | | 21\. 7:00am-7:59am\ | 157 ( 1.3%)\ | | |
## | | | 22\. 8:00am-8:59am\ | 157 ( 1.3%)\ | | |
## | | | 23\. 4:00am-4:59am\ | 156 ( 1.2%)\ | | |
## | | | 24\. 5:00am-5:59am\ | 152 ( 1.2%)\ | | |
## | | | 25\. 10:00am-10:59am\ | 150 ( 1.2%)\ | | |
## | | | 26\. Not Applicable | 65 ( 0.5%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 31 | HOSP_HR\ | 1\. 99\ | 5228 (41.8%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 88\ | 4254 (34.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 15\ | 195 ( 1.6%)\ | | |
## | | | 4\. 17\ | 179 ( 1.4%)\ | | |
## | | | 5\. 16\ | 174 ( 1.4%)\ | | |
## | | | 6\. 21\ | 172 ( 1.4%)\ | | |
## | | | 7\. 18\ | 160 ( 1.3%)\ | | |
## | | | 8\. 20\ | 157 ( 1.3%)\ | | |
## | | | 9\. 19\ | 156 ( 1.2%)\ | | |
## | | | 10\. 14\ | 148 ( 1.2%)\ | | |
## | | | 11\. 0\ | 143 ( 1.1%)\ | | |
## | | | 12\. 22\ | 129 ( 1.0%)\ | | |
## | | | 13\. 3\ | 127 ( 1.0%)\ | | |
## | | | 14\. 13\ | 125 ( 1.0%)\ | | |
## | | | 15\. 11\ | 122 ( 1.0%)\ | | |
## | | | 16\. 10\ | 121 ( 1.0%)\ | | |
## | | | 17\. 4\ | 113 ( 0.9%)\ | | |
## | | | 18\. 23\ | 112 ( 0.9%)\ | | |
## | | | 19\. 2\ | 110 ( 0.9%)\ | | |
## | | | 20\. 12\ | 98 ( 0.8%)\ | | |
## | | | 21\. 1\ | 91 ( 0.7%)\ | | |
## | | | 22\. 8\ | 91 ( 0.7%)\ | | |
## | | | 23\. 7\ | 84 ( 0.7%)\ | | |
## | | | 24\. 9\ | 82 ( 0.7%)\ | | |
## | | | 25\. 6\ | 76 ( 0.6%)\ | | |
## | | | 26\. 5 | 55 ( 0.4%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 32 | HOSP_HRNAME\ | 1\. Unknown\ | 5228 (41.8%)\ | 12502\ | 0\ |
## | | [factor] | 2\. Not Applicable (Not Trans\ | 4254 (34.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3:00pm-3:59pm\ | 195 ( 1.6%)\ | | |
## | | | 4\. 5:00pm-5:59pm\ | 179 ( 1.4%)\ | | |
## | | | 5\. 4:00pm-4:59pm\ | 174 ( 1.4%)\ | | |
## | | | 6\. 9:00pm-9:59pm\ | 172 ( 1.4%)\ | | |
## | | | 7\. 6:00pm-6:59pm\ | 160 ( 1.3%)\ | | |
## | | | 8\. 8:00pm-8:59pm\ | 157 ( 1.3%)\ | | |
## | | | 9\. 7:00pm-7:59pm\ | 156 ( 1.2%)\ | | |
## | | | 10\. 2:00pm-2:59pm\ | 148 ( 1.2%)\ | | |
## | | | 11\. 0:00am-0:59am\ | 143 ( 1.1%)\ | | |
## | | | 12\. 10:00pm-10:59pm\ | 129 ( 1.0%)\ | | |
## | | | 13\. 3:00am-3:59am\ | 127 ( 1.0%)\ | | |
## | | | 14\. 1:00pm-1:59pm\ | 125 ( 1.0%)\ | | |
## | | | 15\. 11:00am-11:59am\ | 122 ( 1.0%)\ | | |
## | | | 16\. 10:00am-10:59am\ | 121 ( 1.0%)\ | | |
## | | | 17\. 4:00am-4:59am\ | 113 ( 0.9%)\ | | |
## | | | 18\. 11:00pm-11:59pm\ | 112 ( 0.9%)\ | | |
## | | | 19\. 2:00am-2:59am\ | 110 ( 0.9%)\ | | |
## | | | 20\. 12:00pm-12:59pm\ | 98 ( 0.8%)\ | | |
## | | | 21\. 1:00am-1:59am\ | 91 ( 0.7%)\ | | |
## | | | 22\. 8:00am-8:59am\ | 91 ( 0.7%)\ | | |
## | | | 23\. 7:00am-7:59am\ | 84 ( 0.7%)\ | | |
## | | | 24\. 9:00am-9:59am\ | 82 ( 0.7%)\ | | |
## | | | 25\. 6:00am-6:59am\ | 76 ( 0.6%)\ | | |
## | | | 26\. 5:00am-5:59am | 55 ( 0.4%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 33 | CF1NAME\ | 1\. None\ | 4785 (86.3%)\ | 5543\ | 6959\ |
## | | [factor] | 2\. Motor Vehicle struck by f\ | 326 ( 5.9%)\ | (44.3%) | (55.7%) |
## | | | 3\. Police Pursuit Involved\ | 182 ( 3.3%)\ | | |
## | | | 4\. Indication of a Stalled/D\ | 100 ( 1.8%)\ | | |
## | | | 5\. Recent/Previous Crash sce\ | 66 ( 1.2%)\ | | |
## | | | 6\. Non-occupant struck by fa\ | 25 ( 0.5%)\ | | |
## | | | 7\. Reported as Unknown\ | 14 ( 0.3%)\ | | |
## | | | 8\. Unknown\ | 12 ( 0.2%)\ | | |
## | | | 9\. Backup Due to Regular Con\ | 11 ( 0.2%)\ | | |
## | | | 10\. Date of Crash and Date of\ | 7 ( 0.1%)\ | | |
## | | | 11\. Other Maintenance or Cons\ | 6 ( 0.1%)\ | | |
## | | | 12\. Inadequate Construction o\ | 2 ( 0.0%)\ | | |
## | | | 13\. Non-occupant struck vehic\ | 2 ( 0.0%)\ | | |
## | | | 14\. Toll Booth/Plaza Related\ | 2 ( 0.0%)\ | | |
## | | | 15\. Backup Due to Prior Non-R\ | 1 ( 0.0%)\ | | |
## | | | 16\. Regular Congestion\ | 1 ( 0.0%)\ | | |
## | | | 17\. Shoulder Design or Condit | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 34 | CF2NAME\ | 1\. None\ | 5426 (97.9%)\ | 5543\ | 6959\ |
## | | [factor] | 2\. Indication of a Stalled/D\ | 30 ( 0.5%)\ | (44.3%) | (55.7%) |
## | | | 3\. Police Pursuit Involved\ | 20 ( 0.4%)\ | | |
## | | | 4\. Non-occupant struck by fa\ | 19 ( 0.3%)\ | | |
## | | | 5\. Reported as Unknown\ | 14 ( 0.3%)\ | | |
## | | | 6\. Recent/Previous Crash sce\ | 13 ( 0.2%)\ | | |
## | | | 7\. Unknown\ | 12 ( 0.2%)\ | | |
## | | | 8\. Motor Vehicle struck by f\ | 4 ( 0.1%)\ | | |
## | | | 9\. Backup Due to Regular Con\ | 3 ( 0.1%)\ | | |
## | | | 10\. Unstabilized Situation Be | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 35 | CF3NAME\ | 1\. None\ | 5504 (99.3%)\ | 5543\ | 6959\ |
## | | [factor] | 2\. Reported as Unknown\ | 14 ( 0.3%)\ | (44.3%) | (55.7%) |
## | | | 3\. Indication of a Stalled/D\ | 13 ( 0.2%)\ | | |
## | | | 4\. Unknown | 12 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 36 | FATALS\ | 1\. 1\ | 11257 (90.0%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2\ | 991 ( 7.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 182 ( 1.5%)\ | | |
## | | | 4\. 4\ | 52 ( 0.4%)\ | | |
## | | | 5\. 5 | 20 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 37 | DRUNK_DR\ | 1\. 0\ | 5032 (71.1%)\ | 7081\ | 5421\ |
## | | [factor] | 2\. 1\ | 2011 (28.4%)\ | (56.6%) | (43.4%) |
## | | | 3\. 2 | 38 ( 0.5%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 38 | VEH_NO\ | 1\. 1\ | 8106 (64.8%)\ | 12502\ | 0\ |
## | | [factor] | 2\. 2\ | 2657 (21.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. 0\ | 965 ( 7.7%)\ | | |
## | | | 4\. 3\ | 518 ( 4.1%)\ | | |
## | | | 5\. 4\ | 153 ( 1.2%)\ | | |
## | | | 6\. 5\ | 48 ( 0.4%)\ | | |
## | | | 7\. 6\ | 23 ( 0.2%)\ | | |
## | | | 8\. 7\ | 17 ( 0.1%)\ | | |
## | | | 9\. 8\ | 8 ( 0.1%)\ | | |
## | | | 10\. 9\ | 4 ( 0.0%)\ | | |
## | | | 11\. 10 | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 39 | NUMOCCS\ | 1\. 1\ | 5640 (49.4%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 2\ | 2778 (24.3%)\ | (91.3%) | (8.7%) |
## | | | 3\. 3\ | 1101 ( 9.7%)\ | | |
## | | | 4\. 4\ | 740 ( 6.5%)\ | | |
## | | | 5\. 5\ | 445 ( 3.9%)\ | | |
## | | | 6\. 99\ | 200 ( 1.8%)\ | | |
## | | | 7\. 6\ | 174 ( 1.5%)\ | | |
## | | | 8\. 7\ | 84 ( 0.7%)\ | | |
## | | | 9\. 57\ | 57 ( 0.5%)\ | | |
## | | | 10\. 0\ | 49 ( 0.4%)\ | | |
## | | | 11\. 47\ | 47 ( 0.4%)\ | | |
## | | | 12\. 8\ | 40 ( 0.4%)\ | | |
## | | | 13\. 9\ | 18 ( 0.2%)\ | | |
## | | | 14\. 21\ | 15 ( 0.1%)\ | | |
## | | | 15\. 11\ | 11 ( 0.1%)\ | | |
## | | | 16\. 10 | 10 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 40 | UNITTYPENAME\ | 1\. Motor Vehicle In-Transpor | 11409 (100.0%) | 11409\ | 1093\ |
## | | [factor] | | | (91.3%) | (8.7%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 41 | HIT_RUNNAME\ | 1\. No\ | 11046 (96.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Yes\ | 359 ( 3.1%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown | 4 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 42 | OWNERNAME\ | 1\. Driver (in this crash) wa\ | 5885 (51.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Driver (in this crash) No\ | 3370 (29.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. Vehicle Registered as Com\ | 705 ( 6.2%)\ | | |
## | | | 4\. Vehicle Registered as Bus\ | 608 ( 5.3%)\ | | |
## | | | 5\. Unknown\ | 290 ( 2.5%)\ | | |
## | | | 6\. Not Applicable, Vehicle N\ | 276 ( 2.4%)\ | | |
## | | | 7\. Vehicle Registered as Ren\ | 151 ( 1.3%)\ | | |
## | | | 8\. Vehicle was Stolen (repor\ | 70 ( 0.6%)\ | | |
## | | | 9\. Driverless/Motor Vehicle | 54 ( 0.5%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 43 | TOW_VEHNAME\ | 1\. No Trailing Units\ | 7470 (65.5%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No Trailers\ | 3213 (28.2%)\ | (91.3%) | (8.7%) |
## | | | 3\. One Trailing Unit\ | 465 ( 4.1%)\ | | |
## | | | 4\. One Trailer\ | 182 ( 1.6%)\ | | |
## | | | 5\. Unknown\ | 38 ( 0.3%)\ | | |
## | | | 6\. Two Trailing Units\ | 17 ( 0.1%)\ | | |
## | | | 7\. Vehicle Towing Another Mo\ | 10 ( 0.1%)\ | | |
## | | | 8\. Two Trailers\ | 8 ( 0.1%)\ | | |
## | | | 9\. Vehicle Towing Another Mo | 6 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 44 | J_KNIFENAME\ | 1\. Not an Articulated Vehicl\ | 10728 (94.0%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No\ | 656 ( 5.7%)\ | (91.3%) | (8.7%) |
## | | | 3\. Yes - Subsequent Event\ | 20 ( 0.2%)\ | | |
## | | | 4\. Yes - First Event | 5 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 45 | MCARR_I1NAME\ | 1\. Not Applicable\ | 10193 (89.3%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. US DOT\ | 721 ( 6.3%)\ | (91.3%) | (8.7%) |
## | | | 3\. None\ | 163 ( 1.4%)\ | | |
## | | | 4\. Unknown\ | 130 ( 1.1%)\ | | |
## | | | 5\. Not Reported\ | 80 ( 0.7%)\ | | |
## | | | 6\. Reported as Unknown\ | 26 ( 0.2%)\ | | |
## | | | 7\. Florida\ | 25 ( 0.2%)\ | | |
## | | | 8\. California\ | 19 ( 0.2%)\ | | |
## | | | 9\. Texas\ | 15 ( 0.1%)\ | | |
## | | | 10\. Indiana\ | 5 ( 0.0%)\ | | |
## | | | 11\. Louisiana\ | 4 ( 0.0%)\ | | |
## | | | 12\. Georgia\ | 3 ( 0.0%)\ | | |
## | | | 13\. North Carolina\ | 3 ( 0.0%)\ | | |
## | | | 14\. Pennsylvania\ | 3 ( 0.0%)\ | | |
## | | | 15\. Alabama\ | 2 ( 0.0%)\ | | |
## | | | 16\. Arizona\ | 2 ( 0.0%)\ | | |
## | | | 17\. MC/MX (ICC)\ | 2 ( 0.0%)\ | | |
## | | | 18\. Ohio\ | 2 ( 0.0%)\ | | |
## | | | 19\. Canada\ | 1 ( 0.0%)\ | | |
## | | | 20\. Iowa\ | 1 ( 0.0%)\ | | |
## | | | 21\. Minnesota\ | 1 ( 0.0%)\ | | |
## | | | 22\. Nevada\ | 1 ( 0.0%)\ | | |
## | | | 23\. New Jersey\ | 1 ( 0.0%)\ | | |
## | | | 24\. New Mexico\ | 1 ( 0.0%)\ | | |
## | | | 25\. Oklahoma\ | 1 ( 0.0%)\ | | |
## | | | 26\. South Carolina\ | 1 ( 0.0%)\ | | |
## | | | 27\. Virginia\ | 1 ( 0.0%)\ | | |
## | | | 28\. West Virginia\ | 1 ( 0.0%)\ | | |
## | | | 29\. Wisconsin | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 46 | GVWRNAME\ | 1\. Not Applicable\ | 4555 (89.3%)\ | 5101\ | 7401\ |
## | | [factor] | 2\. 26,001 lbs. or more\ | 417 ( 8.2%)\ | (40.8%) | (59.2%) |
## | | | 3\. 10,001 lbs - 26,000 lbs\ | 88 ( 1.7%)\ | | |
## | | | 4\. Reported as Unknown\ | 25 ( 0.5%)\ | | |
## | | | 5\. Unknown\ | 13 ( 0.3%)\ | | |
## | | | 6\. Not Reported | 3 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 47 | V_CONFIGNAME\ | 1\. Not Applicable\ | 10193 (89.3%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Truck Tractor/Semi-Traile\ | 533 ( 4.7%)\ | (91.3%) | (8.7%) |
## | | | 3\. Single-Unit Truck (2- axl\ | 183 ( 1.6%)\ | | |
## | | | 4\. Bus (seats for more than \ | 161 ( 1.4%)\ | | |
## | | | 5\. Unknown\ | 124 ( 1.1%)\ | | |
## | | | 6\. Single-Unit Truck (3 or m\ | 54 ( 0.5%)\ | | |
## | | | 7\. Truck Pulling Trailer(s)\ | 54 ( 0.5%)\ | | |
## | | | 8\. Reported as Unknown\ | 24 ( 0.2%)\ | | |
## | | | 9\. Truck Tractor/Double\ | 21 ( 0.2%)\ | | |
## | | | 10\. Bus/Large Van (seats for \ | 17 ( 0.1%)\ | | |
## | | | 11\. Truck Tractor (Bobtail)\ | 15 ( 0.1%)\ | | |
## | | | 12\. Truck More Than 10,000 lb\ | 12 ( 0.1%)\ | | |
## | | | 13\. Vehicle More Than 10,000 \ | 9 ( 0.1%)\ | | |
## | | | 14\. Qualifying Vehicle, Unkno\ | 6 ( 0.1%)\ | | |
## | | | 15\. Vehicle\<a0\>More Than 10,0 | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 48 | CARGO_BTNAME\ | 1\. Not Applicable (N/A)\ | 10193 (89.3%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Van/Enclosed Box\ | 423 ( 3.7%)\ | (91.3%) | (8.7%) |
## | | | 3\. Bus\ | 178 ( 1.6%)\ | | |
## | | | 4\. Unknown\ | 125 ( 1.1%)\ | | |
## | | | 5\. Other\ | 118 ( 1.0%)\ | | |
## | | | 6\. Flatbed\ | 109 ( 1.0%)\ | | |
## | | | 7\. Cargo Tank\ | 55 ( 0.5%)\ | | |
## | | | 8\. Dump\ | 51 ( 0.4%)\ | | |
## | | | 9\. No Cargo Body Type\ | 36 ( 0.3%)\ | | |
## | | | 10\. Unknown Cargo Body Type\ | 34 ( 0.3%)\ | | |
## | | | 11\. Reported as Unknown\ | 23 ( 0.2%)\ | | |
## | | | 12\. Grain/ Chips/ Gravel\ | 15 ( 0.1%)\ | | |
## | | | 13\. Intermodal Container Chas\ | 11 ( 0.1%)\ | | |
## | | | 14\. Garbage/Refuse\ | 10 ( 0.1%)\ | | |
## | | | 15\. Auto Transporter\ | 8 ( 0.1%)\ | | |
## | | | 16\. Concrete Mixer\ | 8 ( 0.1%)\ | | |
## | | | 17\. Vehicle Towing Another Mo\ | 7 ( 0.1%)\ | | |
## | | | 18\. Pole-Trailer\ | 4 ( 0.0%)\ | | |
## | | | 19\. Log | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 49 | HAZ_INVNAME\ | 1\. No\ | 11385 (99.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Yes | 24 ( 0.2%) | (91.3%) | (8.7%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 50 | HAZ_PLACNAME\ | 1\. Not Applicable\ | 11385 (99.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Yes\ | 23 ( 0.2%)\ | (91.3%) | (8.7%) |
## | | | 3\. No | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 51 | HAZ_IDNAME\ | 1\. Not Applicable\ | 11385 (99.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 1203\ | 8 ( 0.1%)\ | (91.3%) | (8.7%) |
## | | | 3\. 1993\ | 5 ( 0.0%)\ | | |
## | | | 4\. Not Reported\ | 4 ( 0.0%)\ | | |
## | | | 5\. 1760\ | 1 ( 0.0%)\ | | |
## | | | 6\. 1791\ | 1 ( 0.0%)\ | | |
## | | | 7\. 1830\ | 1 ( 0.0%)\ | | |
## | | | 8\. 1987\ | 1 ( 0.0%)\ | | |
## | | | 9\. 306\ | 1 ( 0.0%)\ | | |
## | | | 10\. 3082\ | 1 ( 0.0%)\ | | |
## | | | 11\. 3257 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 52 | HAZ_CNONAME\ | 1\. Not Applicable\ | 11385 (99.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 03\ | 16 ( 0.1%)\ | (91.3%) | (8.7%) |
## | | | 3\. 08\ | 3 ( 0.0%)\ | | |
## | | | 4\. 09\ | 2 ( 0.0%)\ | | |
## | | | 5\. Not Reported\ | 2 ( 0.0%)\ | | |
## | | | 6\. 01 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 53 | HAZ_RELNAME\ | 1\. Not Applicable\ | 11385 (99.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No\ | 11 ( 0.1%)\ | (91.3%) | (8.7%) |
## | | | 3\. Yes\ | 11 ( 0.1%)\ | | |
## | | | 4\. Not Reported | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 54 | BUS_USENAME\ | 1\. Not a Bus\ | 11096 (97.3%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Reported as Unknown\ | 124 ( 1.1%)\ | (91.3%) | (8.7%) |
## | | | 3\. Charter/Tour\ | 108 ( 0.9%)\ | | |
## | | | 4\. Transit/ Commuter\ | 21 ( 0.2%)\ | | |
## | | | 5\. Not Reported\ | 19 ( 0.2%)\ | | |
## | | | 6\. Intercity\ | 15 ( 0.1%)\ | | |
## | | | 7\. Unknown\ | 11 ( 0.1%)\ | | |
## | | | 8\. Shuttle\ | 8 ( 0.1%)\ | | |
## | | | 9\. School\ | 5 ( 0.0%)\ | | |
## | | | 10\. Bus, Unknown Use | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 55 | SPEC_USENAME\ | 1\. No Special Use\ | 6307 (55.3%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No Special Use Noted\ | 3337 (29.2%)\ | (91.3%) | (8.7%) |
## | | | 3\. No Special Use\<a0\>Noted\ | 1466 (12.8%)\ | | |
## | | | 4\. Vehicle Used as Other Bus\ | 152 ( 1.3%)\ | | |
## | | | 5\. Reported as Unknown\ | 62 ( 0.5%)\ | | |
## | | | 6\. Motor Vehicle Used for El\ | 17 ( 0.1%)\ | | |
## | | | 7\. Unknown\ | 14 ( 0.1%)\ | | |
## | | | 8\. Police\ | 11 ( 0.1%)\ | | |
## | | | 9\. Ambulance\ | 10 ( 0.1%)\ | | |
## | | | 10\. Taxi\ | 7 ( 0.1%)\ | | |
## | | | 11\. Fire Truck\ | 6 ( 0.1%)\ | | |
## | | | 12\. Towing - Incident Respons\ | 5 ( 0.0%)\ | | |
## | | | 13\. Vehicle Used for Electron\ | 5 ( 0.0%)\ | | |
## | | | 14\. Vehicle Used for School T\ | 5 ( 0.0%)\ | | |
## | | | 15\. Towing – Incident Respons\ | 2 ( 0.0%)\ | | |
## | | | 16\. Incident Response\ | 1 ( 0.0%)\ | | |
## | | | 17\. Public Utility\ | 1 ( 0.0%)\ | | |
## | | | 18\. Rental Truck over 10,000 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 56 | EMER_USENAME\ | 1\. Not Applicable\ | 11333 (99.3%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Reported as Unknown\ | 42 ( 0.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Emergency Operation, Emer\ | 13 ( 0.1%)\ | | |
## | | | 4\. Unknown\ | 13 ( 0.1%)\ | | |
## | | | 5\. Non-Emergency Transport\ | 4 ( 0.0%)\ | | |
## | | | 6\. Not Reported\ | 3 ( 0.0%)\ | | |
## | | | 7\. Emergency Operation, Emer | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 57 | UNDERIDENAME\ | 1\. No Underride or Override \ | 6444 (99.2%)\ | 6498\ | 6004\ |
## | | [factor] | 2\. Underriding a Motor Vehic\ | 16 ( 0.2%)\ | (52.0%) | (48.0%) |
## | | | 3\. Unknown if Underride or O\ | 13 ( 0.2%)\ | | |
## | | | 4\. Overriding a Motor Vehicl\ | 8 ( 0.1%)\ | | |
## | | | 5\. Underriding a Motor Vehic\ | 6 ( 0.1%)\ | | |
## | | | 6\. Underriding a Motor Vehic\ | 4 ( 0.1%)\ | | |
## | | | 7\. Underriding a Motor Vehic\ | 4 ( 0.1%)\ | | |
## | | | 8\. Overriding a Motor Vehicl\ | 2 ( 0.0%)\ | | |
## | | | 9\. Underriding a Motor Vehic | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 58 | ROLLOVERNAME\ | 1\. No Rollover\ | 8408 (73.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Rollover, Tripped by Obje\ | 1309 (11.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. Rollover\ | 773 ( 6.8%)\ | | |
## | | | 4\. Not Applicable\ | 379 ( 3.3%)\ | | |
## | | | 5\. Rollover, Untripped\ | 352 ( 3.1%)\ | | |
## | | | 6\. Rollover, Unknown Type | 188 ( 1.6%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 59 | ROLINLOCNAME\ | 1\. No Rollover\ | 8408 (73.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. On Roadside\ | 1367 (12.0%)\ | (91.3%) | (8.7%) |
## | | | 3\. On Roadway\ | 492 ( 4.3%)\ | | |
## | | | 4\. Not Applicable\ | 379 ( 3.3%)\ | | |
## | | | 5\. In Gore\ | 372 ( 3.3%)\ | | |
## | | | 6\. On Median/Separator\ | 180 ( 1.6%)\ | | |
## | | | 7\. Outside of Trafficway\ | 128 ( 1.1%)\ | | |
## | | | 8\. On Shoulder\ | 59 ( 0.5%)\ | | |
## | | | 9\. Unknown\ | 22 ( 0.2%)\ | | |
## | | | 10\. In Parking Lane/Zone | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 60 | IMPACT1NAME\ | 1\. 12 Clock Point\ | 5087 (44.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Non-Collision\ | 1117 ( 9.8%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not Reported\ | 779 ( 6.8%)\ | | |
## | | | 4\. 6 Clock Point\ | 671 ( 5.9%)\ | | |
## | | | 5\. 11 Clock Point\ | 532 ( 4.7%)\ | | |
## | | | 6\. 9 Clock Point\ | 479 ( 4.2%)\ | | |
## | | | 7\. 1 Clock Point\ | 385 ( 3.4%)\ | | |
## | | | 8\. Left\ | 322 ( 2.8%)\ | | |
## | | | 9\. 3 Clock Point\ | 309 ( 2.7%)\ | | |
## | | | 10\. Right\ | 272 ( 2.4%)\ | | |
## | | | 11\. Left-Front Side\ | 196 ( 1.7%)\ | | |
## | | | 12\. 10 Clock Point\ | 161 ( 1.4%)\ | | |
## | | | 13\. Undercarriage\ | 156 ( 1.4%)\ | | |
## | | | 14\. Right-Front Side\ | 150 ( 1.3%)\ | | |
## | | | 15\. 7 Clock Point\ | 135 ( 1.2%)\ | | |
## | | | 16\. 8 Clock Point\ | 95 ( 0.8%)\ | | |
## | | | 17\. 2 Clock Point\ | 88 ( 0.8%)\ | | |
## | | | 18\. Reported as Unknown\ | 84 ( 0.7%)\ | | |
## | | | 19\. 4 Clock Point\ | 80 ( 0.7%)\ | | |
## | | | 20\. Left-Back Side\ | 73 ( 0.6%)\ | | |
## | | | 21\. Right-Back Side\ | 70 ( 0.6%)\ | | |
## | | | 22\. 5 Clock Point\ | 60 ( 0.5%)\ | | |
## | | | 23\. Top\ | 49 ( 0.4%)\ | | |
## | | | 24\. Unknown\ | 29 ( 0.3%)\ | | |
## | | | 25\. Other Objects or Person S\ | 14 ( 0.1%)\ | | |
## | | | 26\. Cargo/Vehicle Parts Set-I\ | 11 ( 0.1%)\ | | |
## | | | 27\. Other Objects Set-In-Moti | 5 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 61 | DEFORMEDNAME\ | 1\. Disabling Damage\ | 7996 (70.1%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Functional Damage\ | 941 ( 8.2%)\ | (91.3%) | (8.7%) |
## | | | 3\. Minor Damage\ | 864 ( 7.6%)\ | | |
## | | | 4\. Not Reported\ | 750 ( 6.6%)\ | | |
## | | | 5\. Damage Reported, Extent U\ | 546 ( 4.8%)\ | | |
## | | | 6\. No Damage\ | 166 ( 1.5%)\ | | |
## | | | 7\. Reported as Unknown\ | 109 ( 1.0%)\ | | |
## | | | 8\. Unknown | 37 ( 0.3%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 62 | TOWEDNAME\ | 1\. Towed Due to Disabling Da\ | 5807 (50.9%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Towed\ | 2917 (25.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not Towed\ | 1359 (11.9%)\ | | |
## | | | 4\. Towed Not Due to Disablin\ | 452 ( 4.0%)\ | | |
## | | | 5\. Towed, Unknown Reason\ | 448 ( 3.9%)\ | | |
## | | | 6\. Towed But Not Due to Disa\ | 255 ( 2.2%)\ | | |
## | | | 7\. Not Reported\ | 147 ( 1.3%)\ | | |
## | | | 8\. Reported as Unknown\ | 19 ( 0.2%)\ | | |
## | | | 9\. Unknown | 5 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 63 | M_HARMNAME\ | 1\. Motor Vehicle In-Transpor\ | 4639 (40.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Rollover/Overturn\ | 2102 (18.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Pedestrian\ | 1060 ( 9.3%)\ | | |
## | | | 4\. Tree (Standing Only)\ | 579 ( 5.1%)\ | | |
## | | | 5\. Concrete Traffic Barrier\ | 482 ( 4.2%)\ | | |
## | | | 6\. Guardrail Face\ | 401 ( 3.5%)\ | | |
## | | | 7\. Motor Vehicle In-Transpor\ | 283 ( 2.5%)\ | | |
## | | | 8\. Utility Pole/Light Suppor\ | 162 ( 1.4%)\ | | |
## | | | 9\. Parked Motor Vehicle\ | 152 ( 1.3%)\ | | |
## | | | 10\. Fire/Explosion\ | 150 ( 1.3%)\ | | |
## | | | 11\. Impact Attenuator/Crash C\ | 131 ( 1.1%)\ | | |
## | | | 12\. Bridge Pier or Support\ | 129 ( 1.1%)\ | | |
## | | | 13\. Embankment\ | 120 ( 1.1%)\ | | |
## | | | 14\. Traffic Sign Support\ | 113 ( 1.0%)\ | | |
## | | | 15\. Fell/Jumped from Vehicle\ | 88 ( 0.8%)\ | | |
## | | | 16\. Pedalcyclist\ | 88 ( 0.8%)\ | | |
## | | | 17\. Wall\ | 87 ( 0.8%)\ | | |
## | | | 18\. Curb\ | 82 ( 0.7%)\ | | |
## | | | 19\. Ditch\ | 71 ( 0.6%)\ | | |
## | | | 20\. Bridge Rail (Includes par\ | 64 ( 0.6%)\ | | |
## | | | 21\. Guardrail End\ | 64 ( 0.6%)\ | | |
## | | | 22\. Immersion or Partial Imme\ | 52 ( 0.5%)\ | | |
## | | | 23\. Other Object (not fixed)\ | 41 ( 0.4%)\ | | |
## | | | 24\. Other Traffic Barrier\ | 35 ( 0.3%)\ | | |
## | | | 25\. Ground\ | 34 ( 0.3%)\ | | |
## | | | 26\. Other Fixed Object\ | 34 ( 0.3%)\ | | |
## | | | 27\. Post, Pole or Other Suppo\ | 30 ( 0.3%)\ | | |
## | | | 28\. Traffic Signal Support\ | 30 ( 0.3%)\ | | |
## | | | 29\. Culvert\ | 24 ( 0.2%)\ | | |
## | | | 30\. Building\ | 20 ( 0.2%)\ | | |
## | | | 31\. Fence\ | 15 ( 0.1%)\ | | |
## | | | 32\. Non-Motorist on Personal \ | 12 ( 0.1%)\ | | |
## | | | 33\. Cable Barrier\ | 5 ( 0.0%)\ | | |
## | | | 34\. Working Motor Vehicle\ | 5 ( 0.0%)\ | | |
## | | | 35\. Object That Had Fallen Fr\ | 4 ( 0.0%)\ | | |
## | | | 36\. Boulder\ | 3 ( 0.0%)\ | | |
## | | | 37\. Cargo/Equipment Loss or S\ | 3 ( 0.0%)\ | | |
## | | | 38\. Live Animal\ | 3 ( 0.0%)\ | | |
## | | | 39\. Other Non-Collision\ | 2 ( 0.0%)\ | | |
## | | | 40\. Pavement Surface Irregula\ | 2 ( 0.0%)\ | | |
## | | | 41\. Unknown Fixed Object\ | 2 ( 0.0%)\ | | |
## | | | 42\. Bridge Overhead Structure\ | 1 ( 0.0%)\ | | |
## | | | 43\. Injured In Vehicle (Non-C\ | 1 ( 0.0%)\ | | |
## | | | 44\. Motor Vehicle in Motion O\ | 1 ( 0.0%)\ | | |
## | | | 45\. Reported as Unknown\ | 1 ( 0.0%)\ | | |
## | | | 46\. Shrubbery\ | 1 ( 0.0%)\ | | |
## | | | 47\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 64 | VEH_SC1NAME\ | 1\. None\ | 4975 (97.5%)\ | 5101\ | 7401\ |
## | | [factor] | 2\. Other Working Vehicle (No\ | 56 ( 1.1%)\ | (40.8%) | (59.2%) |
## | | | 3\. Vehicle Registration for \ | 29 ( 0.6%)\ | | |
## | | | 4\. Reported as Unknown\ | 17 ( 0.3%)\ | | |
## | | | 5\. Unknown\ | 17 ( 0.3%)\ | | |
## | | | 6\. Highway Construction, Mai\ | 3 ( 0.1%)\ | | |
## | | | 7\. Adaptive Equipment\ | 2 ( 0.0%)\ | | |
## | | | 8\. Police, Fire, or EMS Vehi\ | 1 ( 0.0%)\ | | |
## | | | 9\. Vehicle Being Pushed by N | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 65 | VEH_SC2NAME\ | 1\. None\ | 5067 (99.3%)\ | 5101\ | 7401\ |
## | | [factor] | 2\. Reported as Unknown\ | 17 ( 0.3%)\ | (40.8%) | (59.2%) |
## | | | 3\. Unknown | 17 ( 0.3%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 66 | FIRE_EXPNAME\ | 1\. No or Not Reported\ | 10943 (95.9%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Yes | 466 ( 4.1%) | (91.3%) | (8.7%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 67 | DR_PRESNAME\ | 1\. Yes\ | 11343 (99.4%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No Driver Present/Not App\ | 65 ( 0.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 68 | L_STATUSNAME\ | 1\. Valid\ | 8983 (78.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Not licensed\ | 887 ( 7.8%)\ | (91.3%) | (8.7%) |
## | | | 3\. Suspended\ | 690 ( 6.0%)\ | | |
## | | | 4\. Unknown License Status\ | 414 ( 3.6%)\ | | |
## | | | 5\. Expired\ | 192 ( 1.7%)\ | | |
## | | | 6\. Revoked\ | 140 ( 1.2%)\ | | |
## | | | 7\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 8\. Canceled or denied | 37 ( 0.3%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 69 | L_TYPENAME\ | 1\. Full Driver License\ | 9815 (86.0%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Not Licensed\ | 887 ( 7.8%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown License Type\ | 415 ( 3.6%)\ | | |
## | | | 4\. Intermediate Driver Licen\ | 134 ( 1.2%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 6\. Learner's Permit\ | 56 ( 0.5%)\ | | |
## | | | 7\. Learner`s Permit\ | 21 ( 0.2%)\ | | |
## | | | 8\. Temporary License | 15 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 70 | CDL_STATNAME\ | 1\. No (CDL)\ | 9562 (83.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Valid\ | 1215 (10.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown License Status\ | 417 ( 3.7%)\ | | |
## | | | 4\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 5\. Disqualified\ | 49 ( 0.4%)\ | | |
## | | | 6\. Suspended\ | 33 ( 0.3%)\ | | |
## | | | 7\. Other Not-Valid\ | 25 ( 0.2%)\ | | |
## | | | 8\. Expired\ | 23 ( 0.2%)\ | | |
## | | | 9\. Cancelled or Denied\ | 9 ( 0.1%)\ | | |
## | | | 10\. Revoked\ | 5 ( 0.0%)\ | | |
## | | | 11\. Commercial Learner`s Perm\ | 2 ( 0.0%)\ | | |
## | | | 12\. Commercial Learner’s Perm\ | 2 ( 0.0%)\ | | |
## | | | 13\. Learner`s Permit | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 71 | L_ENDORSNAME\ | 1\. No Endorsements required \ | 10577 (92.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Unknown, if required\ | 426 ( 3.7%)\ | (91.3%) | (8.7%) |
## | | | 3\. Endorsement(s) Required, \ | 227 ( 2.0%)\ | | |
## | | | 4\. Endorsement(s) Required, \ | 107 ( 0.9%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 6\. Endorsement(s) Required, | 6 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 72 | L_COMPLNAME\ | 1\. Valid license for this cl\ | 8722 (76.4%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No valid license for this\ | 1300 (11.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not licensed\ | 888 ( 7.8%)\ | | |
## | | | 4\. Unknown\ | 423 ( 3.7%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 6\. Unknown If CDL and/or CDL\ | 6 ( 0.1%)\ | | |
## | | | 7\. No license required for t | 4 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 73 | L_RESTRINAME\ | 1\. No Restrictions or Not Ap\ | 7894 (69.2%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Restrictions, Compliance \ | 2583 (22.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown\ | 459 ( 4.0%)\ | | |
## | | | 4\. Restrictions Complied Wit\ | 319 ( 2.8%)\ | | |
## | | | 5\. Restrictions Not Complied\ | 88 ( 0.8%)\ | | |
## | | | 6\. No Driver Present/Unknown | 66 ( 0.6%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 74 | DR_HGT\ | 1\. 999\ | 2170 (19.0%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 72\ | 946 ( 8.3%)\ | (91.3%) | (8.7%) |
## | | | 3\. 67\ | 919 ( 8.1%)\ | | |
## | | | 4\. 69\ | 851 ( 7.5%)\ | | |
## | | | 5\. 71\ | 851 ( 7.5%)\ | | |
## | | | 6\. 70\ | 848 ( 7.4%)\ | | |
## | | | 7\. 68\ | 812 ( 7.1%)\ | | |
## | | | 8\. 66\ | 648 ( 5.7%)\ | | |
## | | | 9\. 65\ | 511 ( 4.5%)\ | | |
## | | | 10\. 73\ | 465 ( 4.1%)\ | | |
## | | | 11\. 64\ | 424 ( 3.7%)\ | | |
## | | | 12\. 74\ | 415 ( 3.6%)\ | | |
## | | | 13\. 63\ | 385 ( 3.4%)\ | | |
## | | | 14\. 62\ | 313 ( 2.7%)\ | | |
## | | | 15\. 75\ | 226 ( 2.0%)\ | | |
## | | | 16\. 61\ | 145 ( 1.3%)\ | | |
## | | | 17\. 76\ | 117 ( 1.0%)\ | | |
## | | | 18\. 60\ | 102 ( 0.9%)\ | | |
## | | | 19\. 998\ | 66 ( 0.6%)\ | | |
## | | | 20\. 77\ | 47 ( 0.4%)\ | | |
## | | | 21\. 59\ | 41 ( 0.4%)\ | | |
## | | | 22\. 78\ | 28 ( 0.2%)\ | | |
## | | | 23\. 79\ | 22 ( 0.2%)\ | | |
## | | | 24\. 58\ | 15 ( 0.1%)\ | | |
## | | | 25\. 57\ | 11 ( 0.1%)\ | | |
## | | | 26\. 56\ | 8 ( 0.1%)\ | | |
## | | | 27\. 55\ | 6 ( 0.1%)\ | | |
## | | | 28\. 82\ | 6 ( 0.1%)\ | | |
## | | | 29\. 54\ | 4 ( 0.0%)\ | | |
## | | | 30\. 49\ | 2 ( 0.0%)\ | | |
## | | | 31\. 80\ | 2 ( 0.0%)\ | | |
## | | | 32\. 81\ | 2 ( 0.0%)\ | | |
## | | | 33\. 41 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 75 | PREV_ACCNAME\ | 1\. None\ | 8465 (74.2%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 1\ | 1315 (11.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. Crashes Not Reported on D\ | 617 ( 5.4%)\ | | |
## | | | 4\. Unknown\ | 525 ( 4.6%)\ | | |
## | | | 5\. 2\ | 306 ( 2.7%)\ | | |
## | | | 6\. 3\ | 77 ( 0.7%)\ | | |
## | | | 7\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 8\. 4\ | 27 ( 0.2%)\ | | |
## | | | 9\. 5\ | 10 ( 0.1%)\ | | |
## | | | 10\. 6 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 76 | PREV_SUSNAME\ | 1\. None\ | 1868 (79.6%)\ | 2348\ | 10154\ |
## | | [factor] | 2\. 1\ | 148 ( 6.3%)\ | (18.8%) | (81.2%) |
## | | | 3\. 2\ | 82 ( 3.5%)\ | | |
## | | | 4\. Unknown\ | 79 ( 3.4%)\ | | |
## | | | 5\. 3\ | 56 ( 2.4%)\ | | |
## | | | 6\. 4\ | 44 ( 1.9%)\ | | |
## | | | 7\. 5\ | 23 ( 1.0%)\ | | |
## | | | 8\. 7\ | 10 ( 0.4%)\ | | |
## | | | 9\. No Driver Present/Unknown\ | 10 ( 0.4%)\ | | |
## | | | 10\. 9\ | 5 ( 0.2%)\ | | |
## | | | 11\. 22\ | 4 ( 0.2%)\ | | |
## | | | 12\. 8\ | 4 ( 0.2%)\ | | |
## | | | 13\. 15\ | 3 ( 0.1%)\ | | |
## | | | 14\. 10\ | 2 ( 0.1%)\ | | |
## | | | 15\. 14\ | 2 ( 0.1%)\ | | |
## | | | 16\. 16\ | 2 ( 0.1%)\ | | |
## | | | 17\. 11\ | 1 ( 0.0%)\ | | |
## | | | 18\. 13\ | 1 ( 0.0%)\ | | |
## | | | 19\. 17\ | 1 ( 0.0%)\ | | |
## | | | 20\. 20\ | 1 ( 0.0%)\ | | |
## | | | 21\. 26\ | 1 ( 0.0%)\ | | |
## | | | 22\. 6 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 77 | PREV_DWINAME\ | 1\. None\ | 10457 (91.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Unknown\ | 525 ( 4.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. 1\ | 309 ( 2.7%)\ | | |
## | | | 4\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 5\. 2\ | 45 ( 0.4%)\ | | |
## | | | 6\. 3\ | 6 ( 0.1%)\ | | |
## | | | 7\. 4 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 78 | PREV_SPDNAME\ | 1\. None\ | 8858 (77.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 1\ | 1366 (12.0%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown\ | 525 ( 4.6%)\ | | |
## | | | 4\. 2\ | 383 ( 3.4%)\ | | |
## | | | 5\. 3\ | 124 ( 1.1%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 7\. 4\ | 51 ( 0.4%)\ | | |
## | | | 8\. 5\ | 20 ( 0.2%)\ | | |
## | | | 9\. 6\ | 14 ( 0.1%)\ | | |
## | | | 10\. 7\ | 1 ( 0.0%)\ | | |
## | | | 11\. 9 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 79 | PREV_OTHNAME\ | 1\. None\ | 8871 (77.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 1\ | 1236 (10.8%)\ | (91.3%) | (8.7%) |
## | | | 3\. Unknown\ | 525 ( 4.6%)\ | | |
## | | | 4\. 2\ | 420 ( 3.7%)\ | | |
## | | | 5\. 3\ | 157 ( 1.4%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 7\. 4\ | 60 ( 0.5%)\ | | |
## | | | 8\. 5\ | 38 ( 0.3%)\ | | |
## | | | 9\. 6\ | 17 ( 0.1%)\ | | |
## | | | 10\. 7\ | 8 ( 0.1%)\ | | |
## | | | 11\. 8\ | 5 ( 0.0%)\ | | |
## | | | 12\. 9\ | 3 ( 0.0%)\ | | |
## | | | 13\. 11\ | 2 ( 0.0%)\ | | |
## | | | 14\. 27 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 80 | FIRST_MONAME\ | 1\. No Record\ | 6226 (54.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Unknown\ | 525 ( 4.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. October\ | 420 ( 3.7%)\ | | |
## | | | 4\. May\ | 419 ( 3.7%)\ | | |
## | | | 5\. April\ | 402 ( 3.5%)\ | | |
## | | | 6\. July\ | 388 ( 3.4%)\ | | |
## | | | 7\. June\ | 388 ( 3.4%)\ | | |
## | | | 8\. January\ | 386 ( 3.4%)\ | | |
## | | | 9\. March\ | 384 ( 3.4%)\ | | |
## | | | 10\. November\ | 376 ( 3.3%)\ | | |
## | | | 11\. August\ | 368 ( 3.2%)\ | | |
## | | | 12\. February\ | 363 ( 3.2%)\ | | |
## | | | 13\. September\ | 354 ( 3.1%)\ | | |
## | | | 14\. December\ | 344 ( 3.0%)\ | | |
## | | | 15\. No Driver Present/Unknown | 66 ( 0.6%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 81 | FIRST_YRNAME\ | 1\. No Record\ | 6226 (54.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 2018\ | 606 ( 5.3%)\ | (91.3%) | (8.7%) |
## | | | 3\. 2016\ | 593 ( 5.2%)\ | | |
## | | | 4\. 2017\ | 543 ( 4.8%)\ | | |
## | | | 5\. 2019\ | 543 ( 4.8%)\ | | |
## | | | 6\. Unknown\ | 526 ( 4.6%)\ | | |
## | | | 7\. 2015\ | 505 ( 4.4%)\ | | |
## | | | 8\. 2014\ | 402 ( 3.5%)\ | | |
## | | | 9\. 2020\ | 321 ( 2.8%)\ | | |
## | | | 10\. 2021\ | 310 ( 2.7%)\ | | |
## | | | 11\. 2013\ | 245 ( 2.1%)\ | | |
## | | | 12\. 2022\ | 183 ( 1.6%)\ | | |
## | | | 13\. 2012\ | 181 ( 1.6%)\ | | |
## | | | 14\. 2023\ | 81 ( 0.7%)\ | | |
## | | | 15\. 2011\ | 78 ( 0.7%)\ | | |
## | | | 16\. No Driver Present/Unknown | 66 ( 0.6%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 82 | LAST_MONAME\ | 1\. No Record\ | 6226 (54.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Unknown\ | 525 ( 4.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. July\ | 425 ( 3.7%)\ | | |
## | | | 4\. June\ | 409 ( 3.6%)\ | | |
## | | | 5\. March\ | 405 ( 3.5%)\ | | |
## | | | 6\. October\ | 389 ( 3.4%)\ | | |
## | | | 7\. May\ | 387 ( 3.4%)\ | | |
## | | | 8\. April\ | 382 ( 3.3%)\ | | |
## | | | 9\. November\ | 382 ( 3.3%)\ | | |
## | | | 10\. August\ | 374 ( 3.3%)\ | | |
## | | | 11\. February\ | 374 ( 3.3%)\ | | |
## | | | 12\. January\ | 373 ( 3.3%)\ | | |
## | | | 13\. September\ | 348 ( 3.1%)\ | | |
## | | | 14\. December\ | 344 ( 3.0%)\ | | |
## | | | 15\. No Driver Present/Unknown | 66 ( 0.6%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 83 | LAST_YRNAME\ | 1\. No Record\ | 6226 (54.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 2018\ | 628 ( 5.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. 2019\ | 617 ( 5.4%)\ | | |
## | | | 4\. 2016\ | 590 ( 5.2%)\ | | |
## | | | 5\. 2017\ | 555 ( 4.9%)\ | | |
## | | | 6\. Unknown\ | 526 ( 4.6%)\ | | |
## | | | 7\. 2021\ | 477 ( 4.2%)\ | | |
## | | | 8\. 2020\ | 444 ( 3.9%)\ | | |
## | | | 9\. 2015\ | 406 ( 3.6%)\ | | |
## | | | 10\. 2022\ | 338 ( 3.0%)\ | | |
## | | | 11\. 2014\ | 185 ( 1.6%)\ | | |
## | | | 12\. 2023\ | 171 ( 1.5%)\ | | |
## | | | 13\. 2013\ | 107 ( 0.9%)\ | | |
## | | | 14\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 15\. 2012\ | 61 ( 0.5%)\ | | |
## | | | 16\. 2011 | 12 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 84 | SPEEDRELNAME\ | 1\. No\ | 7598 (66.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Yes, Too Fast for Conditi\ | 1885 (16.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. Yes, Exceeded Speed Limit\ | 813 ( 7.1%)\ | | |
## | | | 4\. Yes, Specifics Unknown\ | 578 ( 5.1%)\ | | |
## | | | 5\. Reported as Unknown\ | 337 ( 3.0%)\ | | |
## | | | 6\. Unknown\ | 108 ( 0.9%)\ | | |
## | | | 7\. No Driver Present/Unknown\ | 66 ( 0.6%)\ | | |
## | | | 8\. Yes, Racing | 24 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 85 | DR_SF2NAME\ | 1\. None\ | 4408 (86.4%)\ | 5101\ | 7401\ |
## | | [factor] | 2\. Unknown\ | 122 ( 2.4%)\ | (40.8%) | (59.2%) |
## | | | 3\. Reported as Unknown\ | 91 ( 1.8%)\ | | |
## | | | 4\. Failure to Obey Actual Tr\ | 74 ( 1.5%)\ | | |
## | | | 5\. Overcorrecting\ | 60 ( 1.2%)\ | | |
## | | | 6\. Operating the Vehicle in \ | 57 ( 1.1%)\ | | |
## | | | 7\. Police Pursuing this Driv\ | 36 ( 0.7%)\ | | |
## | | | 8\. Improper Lane Usage\ | 31 ( 0.6%)\ | | |
## | | | 9\. Careless Driving\ | 23 ( 0.5%)\ | | |
## | | | 10\. Failure to Yield Right-of\ | 19 ( 0.4%)\ | | |
## | | | 11\. Ice, Snow, Slush, Water, \ | 19 ( 0.4%)\ | | |
## | | | 12\. Aggressive Driving / Road\ | 18 ( 0.4%)\ | | |
## | | | 13\. Driver Has Not Complied W\ | 16 ( 0.3%)\ | | |
## | | | 14\. Non-Traffic Violation Cha\ | 16 ( 0.3%)\ | | |
## | | | 15\. Improper or Erratic Lane \ | 14 ( 0.3%)\ | | |
## | | | 16\. Driving on Wrong Side of \ | 10 ( 0.2%)\ | | |
## | | | 17\. Making Other Improper Tur\ | 10 ( 0.2%)\ | | |
## | | | 18\. Making Improper Entry to \ | 9 ( 0.2%)\ | | |
## | | | 19\. Driving Wrong Way on One-\ | 7 ( 0.1%)\ | | |
## | | | 20\. Operator Inexperience\ | 7 ( 0.1%)\ | | |
## | | | 21\. Driver has not complied w\ | 6 ( 0.1%)\ | | |
## | | | 22\. Slippery or Loose Surface\ | 6 ( 0.1%)\ | | |
## | | | 23\. Unfamiliar with Roadway\ | 5 ( 0.1%)\ | | |
## | | | 24\. Alcohol and/or Drug Test \ | 4 ( 0.1%)\ | | |
## | | | 25\. Driver Has a Driving Reco\ | 4 ( 0.1%)\ | | |
## | | | 26\. Emergency Services Person\ | 3 ( 0.1%)\ | | |
## | | | 27\. Following Improperly\ | 3 ( 0.1%)\ | | |
## | | | 28\. Operating without Require\ | 3 ( 0.1%)\ | | |
## | | | 29\. Passing with Insufficient\ | 3 ( 0.1%)\ | | |
## | | | 30\. Tire Blowout or Flat\ | 3 ( 0.1%)\ | | |
## | | | 31\. Driving with Tire-Related\ | 2 ( 0.0%)\ | | |
## | | | 32\. Overloading or Improper L\ | 2 ( 0.0%)\ | | |
## | | | 33\. Passing on Right Side\ | 2 ( 0.0%)\ | | |
## | | | 34\. Failing to Dim Lights or \ | 1 ( 0.0%)\ | | |
## | | | 35\. Failure to Observe Warnin\ | 1 ( 0.0%)\ | | |
## | | | 36\. Failure to Signal Intenti\ | 1 ( 0.0%)\ | | |
## | | | 37\. Intentional Illegal Drivi\ | 1 ( 0.0%)\ | | |
## | | | 38\. Passing Through or Around\ | 1 ( 0.0%)\ | | |
## | | | 39\. Passing where Prohibited \ | 1 ( 0.0%)\ | | |
## | | | 40\. Severe Crosswind\ | 1 ( 0.0%)\ | | |
## | | | 41\. Stopped in Roadway (Vehic | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 86 | DR_SF3NAME\ | 1\. None\ | 4774 (93.6%)\ | 5101\ | 7401\ |
## | | [factor] | 2\. Unknown\ | 122 ( 2.4%)\ | (40.8%) | (59.2%) |
## | | | 3\. Reported as Unknown\ | 91 ( 1.8%)\ | | |
## | | | 4\. Operating the Vehicle in \ | 20 ( 0.4%)\ | | |
## | | | 5\. Failure to Obey Actual Tr\ | 16 ( 0.3%)\ | | |
## | | | 6\. Non-Traffic Violation Cha\ | 15 ( 0.3%)\ | | |
## | | | 7\. Police Pursuing this Driv\ | 14 ( 0.3%)\ | | |
## | | | 8\. Driver Has Not Complied W\ | 5 ( 0.1%)\ | | |
## | | | 9\. Failure to Yield Right-of\ | 5 ( 0.1%)\ | | |
## | | | 10\. Aggressive Driving / Road\ | 4 ( 0.1%)\ | | |
## | | | 11\. Driving with Tire-Related\ | 4 ( 0.1%)\ | | |
## | | | 12\. Improper Lane Usage\ | 4 ( 0.1%)\ | | |
## | | | 13\. Overcorrecting\ | 4 ( 0.1%)\ | | |
## | | | 14\. Driver has not complied w\ | 3 ( 0.1%)\ | | |
## | | | 15\. Alcohol and/or Drug Test \ | 2 ( 0.0%)\ | | |
## | | | 16\. Driving on Wrong Side of \ | 2 ( 0.0%)\ | | |
## | | | 17\. Driving Wrong Way on One-\ | 2 ( 0.0%)\ | | |
## | | | 18\. Improper or Erratic Lane \ | 2 ( 0.0%)\ | | |
## | | | 19\. Making Improper Entry to \ | 2 ( 0.0%)\ | | |
## | | | 20\. Passing with Insufficient\ | 2 ( 0.0%)\ | | |
## | | | 21\. Ice, Snow, Slush, Water, \ | 1 ( 0.0%)\ | | |
## | | | 22\. Improper Management of Ve\ | 1 ( 0.0%)\ | | |
## | | | 23\. Intentional Illegal Drivi\ | 1 ( 0.0%)\ | | |
## | | | 24\. Making Other Improper Tur\ | 1 ( 0.0%)\ | | |
## | | | 25\. Operator Inexperience\ | 1 ( 0.0%)\ | | |
## | | | 26\. Passing on Right Side\ | 1 ( 0.0%)\ | | |
## | | | 27\. Passing where Prohibited \ | 1 ( 0.0%)\ | | |
## | | | 28\. Unfamiliar with Roadway | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 87 | DR_SF4NAME\ | 1\. None\ | 4878 (95.6%)\ | 5101\ | 7401\ |
## | | [factor] | 2\. Unknown\ | 122 ( 2.4%)\ | (40.8%) | (59.2%) |
## | | | 3\. Reported as Unknown\ | 91 ( 1.8%)\ | | |
## | | | 4\. Failure to Obey Actual Tr\ | 2 ( 0.0%)\ | | |
## | | | 5\. Failure to Yield Right-of\ | 2 ( 0.0%)\ | | |
## | | | 6\. Overcorrecting\ | 2 ( 0.0%)\ | | |
## | | | 7\. Driver Has Not Complied W\ | 1 ( 0.0%)\ | | |
## | | | 8\. Failing to Dim Lights or \ | 1 ( 0.0%)\ | | |
## | | | 9\. Operating the Vehicle in \ | 1 ( 0.0%)\ | | |
## | | | 10\. Passing where Prohibited | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 88 | VTRAFWAYNAME\ | 1\. Entrance/Exit Ramp\ | 9424 (82.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Two-Way, Divided, Positi\ | 781 ( 6.8%)\ | (91.3%) | (8.7%) |
## | | | 3\. Two-Way, Divided, Unprote\ | 602 ( 5.3%)\ | | |
## | | | 4\. Two-Way, Not Divided\ | 392 ( 3.4%)\ | | |
## | | | 5\. One-Way Trafficway\ | 79 ( 0.7%)\ | | |
## | | | 6\. Two-Way, Divided, Unprot\ | 59 ( 0.5%)\ | | |
## | | | 7\. Two-Way, Not Divided With\ | 48 ( 0.4%)\ | | |
## | | | 8\. Not Reported\ | 18 ( 0.2%)\ | | |
## | | | 9\. Non-Trafficway or Drivewa\ | 3 ( 0.0%)\ | | |
## | | | 10\. Two-Way Divided, Unknown | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 89 | VNUM_LANNAME\ | 1\. One lane\ | 5027 (44.1%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Two lanes\ | 4374 (38.3%)\ | (91.3%) | (8.7%) |
## | | | 3\. Three lanes\ | 1003 ( 8.8%)\ | | |
## | | | 4\. Four lanes\ | 505 ( 4.4%)\ | | |
## | | | 5\. Five lanes\ | 257 ( 2.3%)\ | | |
## | | | 6\. Not Reported\ | 131 ( 1.1%)\ | | |
## | | | 7\. Six lanes\ | 89 ( 0.8%)\ | | |
## | | | 8\. Seven or more lanes\ | 12 ( 0.1%)\ | | |
## | | | 9\. Unknown\ | 5 ( 0.0%)\ | | |
## | | | 10\. Non-Trafficway or Drivewa\ | 3 ( 0.0%)\ | | |
## | | | 11\. Reported as Unknown | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 90 | VSPD_LIMNAME\ | 1\. 65 MPH\ | 2952 (25.9%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 55 MPH\ | 1666 (14.6%)\ | (91.3%) | (8.7%) |
## | | | 3\. 45 MPH\ | 1187 (10.4%)\ | | |
## | | | 4\. 70 MPH\ | 1185 (10.4%)\ | | |
## | | | 5\. Not Reported\ | 923 ( 8.1%)\ | | |
## | | | 6\. 35 MPH\ | 766 ( 6.7%)\ | | |
## | | | 7\. 60 MPH\ | 760 ( 6.7%)\ | | |
## | | | 8\. 40 MPH\ | 488 ( 4.3%)\ | | |
## | | | 9\. 50 MPH\ | 387 ( 3.4%)\ | | |
## | | | 10\. 25 MPH\ | 362 ( 3.2%)\ | | |
## | | | 11\. 30 MPH\ | 284 ( 2.5%)\ | | |
## | | | 12\. 75 MPH\ | 197 ( 1.7%)\ | | |
## | | | 13\. 20 MPH\ | 88 ( 0.8%)\ | | |
## | | | 14\. Reported as Unknown\ | 68 ( 0.6%)\ | | |
## | | | 15\. Unknown\ | 41 ( 0.4%)\ | | |
## | | | 16\. 15 MPH\ | 27 ( 0.2%)\ | | |
## | | | 17\. 80 MPH\ | 17 ( 0.1%)\ | | |
## | | | 18\. 5 MPH\ | 5 ( 0.0%)\ | | |
## | | | 19\. No Statutory Limit/Non-Tr\ | 5 ( 0.0%)\ | | |
## | | | 20\. 10 MPH | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 91 | VALIGNNAME\ | 1\. Straight\ | 5768 (50.6%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Curve Right\ | 1751 (15.3%)\ | (91.3%) | (8.7%) |
## | | | 3\. Curve - Right\ | 1673 (14.7%)\ | | |
## | | | 4\. Curve Left\ | 836 ( 7.3%)\ | | |
## | | | 5\. Curve - Left\ | 825 ( 7.2%)\ | | |
## | | | 6\. Not Reported\ | 364 ( 3.2%)\ | | |
## | | | 7\. Curve - Unknown Direction\ | 183 ( 1.6%)\ | | |
## | | | 8\. Non-Trafficway or Drivewa\ | 3 ( 0.0%)\ | | |
## | | | 9\. Reported as Unknown\ | 3 ( 0.0%)\ | | |
## | | | 10\. Unknown | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 92 | VPROFILENAME\ | 1\. Level\ | 5237 (45.9%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Grade, Unknown Slope\ | 1986 (17.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not Reported\ | 1689 (14.8%)\ | | |
## | | | 4\. Downhill\ | 1155 (10.1%)\ | | |
## | | | 5\. Uphill\ | 1141 (10.0%)\ | | |
## | | | 6\. Hillcrest\ | 161 ( 1.4%)\ | | |
## | | | 7\. Sag (Bottom)\ | 24 ( 0.2%)\ | | |
## | | | 8\. Unknown\ | 7 ( 0.1%)\ | | |
## | | | 9\. Reported as Unknown\ | 6 ( 0.1%)\ | | |
## | | | 10\. Non-Trafficway or Drivewa | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 93 | VPAVETYPNAME\ | 1\. Blacktop, Bituminous, or \ | 5921 (51.9%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Not Reported\ | 3134 (27.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. Concrete\ | 2337 (20.5%)\ | | |
## | | | 4\. Reported as Unknown\ | 7 ( 0.1%)\ | | |
## | | | 5\. Slag, Gravel or Stone\ | 5 ( 0.0%)\ | | |
## | | | 6\. Non-Trafficway or Drivewa\ | 3 ( 0.0%)\ | | |
## | | | 7\. Other\ | 1 ( 0.0%)\ | | |
## | | | 8\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 94 | VSURCONDNAME\ | 1\. Dry\ | 9699 (85.0%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Wet\ | 1298 (11.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not Reported\ | 179 ( 1.6%)\ | | |
## | | | 4\. Ice/Frost\ | 105 ( 0.9%)\ | | |
## | | | 5\. Reported as Unknown\ | 32 ( 0.3%)\ | | |
## | | | 6\. Snow\ | 32 ( 0.3%)\ | | |
## | | | 7\. Slush\ | 28 ( 0.2%)\ | | |
## | | | 8\. Other\ | 13 ( 0.1%)\ | | |
## | | | 9\. Mud, Dirt or Gravel\ | 7 ( 0.1%)\ | | |
## | | | 10\. Oil\ | 6 ( 0.1%)\ | | |
## | | | 11\. Water (Standing or Moving\ | 4 ( 0.0%)\ | | |
## | | | 12\. Non-Trafficway or Drivewa\ | 3 ( 0.0%)\ | | |
## | | | 13\. Unknown | 3 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 95 | VTRAFCONNAME\ | 1\. No Controls\ | 7548 (66.2%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Traffic control signal(on\ | 1088 ( 9.5%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not Reported\ | 1045 ( 9.2%)\ | | |
## | | | 4\. Stop Sign\ | 561 ( 4.9%)\ | | |
## | | | 5\. Warning Sign\ | 369 ( 3.2%)\ | | |
## | | | 6\. Traffic control signal (o\ | 224 ( 2.0%)\ | | |
## | | | 7\. Other Regulatory Sign\ | 175 ( 1.5%)\ | | |
## | | | 8\. Yield Sign\ | 157 ( 1.4%)\ | | |
## | | | 9\. Traffic control signal (o\ | 123 ( 1.1%)\ | | |
## | | | 10\. Other\ | 54 ( 0.5%)\ | | |
## | | | 11\. Flashing Traffic Control \ | 25 ( 0.2%)\ | | |
## | | | 12\. Lane Use Control Signal\ | 11 ( 0.1%)\ | | |
## | | | 13\. Unknown Regulatory Sign\ | 10 ( 0.1%)\ | | |
## | | | 14\. Reported as Unknown\ | 9 ( 0.1%)\ | | |
## | | | 15\. Other Highway Traffic Sig\ | 5 ( 0.0%)\ | | |
## | | | 16\. Person | 5 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 96 | VTCONT_FNAME\ | 1\. No Controls\ | 7548 (66.2%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Device Functioning Proper\ | 2789 (24.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Not Reported\ | 1049 ( 9.2%)\ | | |
## | | | 4\. Reported as Unknown\ | 12 ( 0.1%)\ | | |
## | | | 5\. Device Functioning-Functi\ | 6 ( 0.1%)\ | | |
## | | | 6\. Device Not Functioning\ | 4 ( 0.0%)\ | | |
## | | | 7\. Device Not Functioning or | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 97 | P_CRASH1NAME\ | 1\. Going Straight\ | 4413 (38.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Negotiating a Curve\ | 4308 (37.8%)\ | (91.3%) | (8.7%) |
## | | | 3\. Turning Left\ | 620 ( 5.4%)\ | | |
## | | | 4\. Stopped in Roadway\ | 461 ( 4.0%)\ | | |
## | | | 5\. Merging\ | 396 ( 3.5%)\ | | |
## | | | 6\. Changing Lanes\ | 357 ( 3.1%)\ | | |
## | | | 7\. Decelerating in Road\ | 153 ( 1.3%)\ | | |
## | | | 8\. Unknown\ | 147 ( 1.3%)\ | | |
## | | | 9\. Turning Right\ | 142 ( 1.2%)\ | | |
## | | | 10\. Passing or Overtaking Ano\ | 104 ( 0.9%)\ | | |
## | | | 11\. Other(specify:)\ | 73 ( 0.6%)\ | | |
## | | | 12\. No Driver Present / Unkno\ | 66 ( 0.6%)\ | | |
## | | | 13\. Starting in Road\ | 57 ( 0.5%)\ | | |
## | | | 14\. Accelerating in Road\ | 43 ( 0.4%)\ | | |
## | | | 15\. Making a U-turn\ | 28 ( 0.2%)\ | | |
## | | | 16\. Disabled or ""Parked"" in\ | 16 ( 0.1%)\ | | |
## | | | 17\. Successful Avoidance Mane\ | 10 ( 0.1%)\ | | |
## | | | 18\. Leaving a Parking Positio\ | 9 ( 0.1%)\ | | |
## | | | 19\. Backing Up (other than fo\ | 4 ( 0.0%)\ | | |
## | | | 20\. Entering a Parking Positi | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 98 | P_CRASH3NAME\ | 1\. Unknown/Not Reported\ | 7660 (67.1%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. No Avoidance Maneuver\ | 2099 (18.4%)\ | (91.3%) | (8.7%) |
## | | | 3\. Braking\ | 535 ( 4.7%)\ | | |
## | | | 4\. Steering left\ | 321 ( 2.8%)\ | | |
## | | | 5\. Steering right\ | 315 ( 2.8%)\ | | |
## | | | 6\. Braking and steering left\ | 136 ( 1.2%)\ | | |
## | | | 7\. Braking and steering righ\ | 84 ( 0.7%)\ | | |
## | | | 8\. Braking and Unknown Steer\ | 76 ( 0.7%)\ | | |
## | | | 9\. No Driver Present / Unkno\ | 66 ( 0.6%)\ | | |
## | | | 10\. Other actions (specify:)\ | 65 ( 0.6%)\ | | |
## | | | 11\. Accelerating\ | 25 ( 0.2%)\ | | |
## | | | 12\. Accelerating and steering\ | 12 ( 0.1%)\ | | |
## | | | 13\. Accelerating and steering\ | 11 ( 0.1%)\ | | |
## | | | 14\. Releasing brakes | 4 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 99 | PCRASH4NAME\ | 1\. Tracking\ | 7685 (67.4%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Precrash stability unknow\ | 2187 (19.2%)\ | (91.3%) | (8.7%) |
## | | | 3\. Skidding longitudinally \ | 608 ( 5.3%)\ | | |
## | | | 4\. Skidding laterally clockw\ | 394 ( 3.5%)\ | | |
## | | | 5\. Skidding laterally counte\ | 327 ( 2.9%)\ | | |
## | | | 6\. Skidding Laterally, Rotat\ | 122 ( 1.1%)\ | | |
## | | | 7\. No Driver Present / Unkno\ | 66 ( 0.6%)\ | | |
## | | | 8\. Other vehicle loss-of-con | 20 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 100 | PCRASH5NAME\ | 1\. Stayed in original travel\ | 5211 (45.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Departed roadway\ | 5004 (43.9%)\ | (91.3%) | (8.7%) |
## | | | 3\. Stayed on roadway, but le\ | 582 ( 5.1%)\ | | |
## | | | 4\. Stayed on roadway, not kn\ | 154 ( 1.3%)\ | | |
## | | | 5\. Returned to roadway\ | 126 ( 1.1%)\ | | |
## | | | 6\. Unknown\ | 124 ( 1.1%)\ | | |
## | | | 7\. Entered roadway\ | 94 ( 0.8%)\ | | |
## | | | 8\. No Driver Present / Unkno\ | 66 ( 0.6%)\ | | |
## | | | 9\. Remained off roadway | 48 ( 0.4%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 101 | DEATHS\ | 1\. 1\ | 6351 (55.7%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. 0\ | 4189 (36.7%)\ | (91.3%) | (8.7%) |
## | | | 3\. 2\ | 685 ( 6.0%)\ | | |
## | | | 4\. 3\ | 129 ( 1.1%)\ | | |
## | | | 5\. 4\ | 39 ( 0.3%)\ | | |
## | | | 6\. 5 | 16 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 102 | DR_DRINKNAME\ | 1\. No\ | 8796 (77.1%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Yes | 2613 (22.9%) | (91.3%) | (8.7%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 103 | TRLR2VINNAME\ | 1\. No Trailing Units\ | 11385 (99.8%)\ | 11409\ | 1093\ |
## | | [factor] | 2\. Not Reported\ | 12 ( 0.1%)\ | (91.3%) | (8.7%) |
## | | | 3\. 1A9240649500\ | 1 ( 0.0%)\ | | |
## | | | 4\. 1G9B21209F10\ | 1 ( 0.0%)\ | | |
## | | | 5\. 1GRAA56197K2\ | 1 ( 0.0%)\ | | |
## | | | 6\. 1GRAP5619CK2\ | 1 ( 0.0%)\ | | |
## | | | 7\. 1JJV281D3CL5\ | 1 ( 0.0%)\ | | |
## | | | 8\. 1S9SS3123GL4\ | 1 ( 0.0%)\ | | |
## | | | 9\. 1UYFF2249SA7\ | 1 ( 0.0%)\ | | |
## | | | 10\. 1UYFS1298FA3\ | 1 ( 0.0%)\ | | |
## | | | 11\. 1UYVS1280CU2\ | 1 ( 0.0%)\ | | |
## | | | 12\. 4BUD1A1B1TB9\ | 1 ( 0.0%)\ | | |
## | | | 13\. 7F21A2813N20\ | 1 ( 0.0%)\ | | |
## | | | 14\. 7F21C2813H20 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 104 | TRLR3VINNAME\ | 1\. No Trailing Units | 11409 (100.0%) | 11409\ | 1093\ |
## | | [factor] | | | (91.3%) | (8.7%) |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 105 | PREV_SUS1NAME\ | 1\. None\ | 8550 (94.4%)\ | 9061\ | 3441\ |
## | | [factor] | 2\. Unknown\ | 448 ( 4.9%)\ | (72.5%) | (27.5%) |
## | | | 3\. No Driver Present/Unknown\ | 56 ( 0.6%)\ | | |
## | | | 4\. 1\ | 5 ( 0.1%)\ | | |
## | | | 5\. 2\ | 1 ( 0.0%)\ | | |
## | | | 6\. 3 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 106 | PREV_SUS2NAME\ | 1\. None\ | 8369 (92.4%)\ | 9061\ | 3441\ |
## | | [factor] | 2\. Unknown\ | 448 ( 4.9%)\ | (72.5%) | (27.5%) |
## | | | 3\. 1\ | 126 ( 1.4%)\ | | |
## | | | 4\. No Driver Present/Unknown\ | 56 ( 0.6%)\ | | |
## | | | 5\. 2\ | 32 ( 0.4%)\ | | |
## | | | 6\. 3\ | 15 ( 0.2%)\ | | |
## | | | 7\. 4\ | 8 ( 0.1%)\ | | |
## | | | 8\. 12\ | 2 ( 0.0%)\ | | |
## | | | 9\. 18\ | 2 ( 0.0%)\ | | |
## | | | 10\. 5\ | 2 ( 0.0%)\ | | |
## | | | 11\. 6 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 107 | PREV_SUS3NAME\ | 1\. None\ | 7423 (81.9%)\ | 9061\ | 3441\ |
## | | [factor] | 2\. 1\ | 558 ( 6.2%)\ | (72.5%) | (27.5%) |
## | | | 3\. Unknown\ | 448 ( 4.9%)\ | | |
## | | | 4\. 2\ | 279 ( 3.1%)\ | | |
## | | | 5\. 3\ | 115 ( 1.3%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 56 ( 0.6%)\ | | |
## | | | 7\. 4\ | 48 ( 0.5%)\ | | |
## | | | 8\. 5\ | 47 ( 0.5%)\ | | |
## | | | 9\. 6\ | 29 ( 0.3%)\ | | |
## | | | 10\. 10\ | 12 ( 0.1%)\ | | |
## | | | 11\. 7\ | 11 ( 0.1%)\ | | |
## | | | 12\. 8\ | 9 ( 0.1%)\ | | |
## | | | 13\. 12\ | 5 ( 0.1%)\ | | |
## | | | 14\. 14\ | 5 ( 0.1%)\ | | |
## | | | 15\. 22\ | 4 ( 0.0%)\ | | |
## | | | 16\. 9\ | 3 ( 0.0%)\ | | |
## | | | 17\. 15\ | 2 ( 0.0%)\ | | |
## | | | 18\. 11\ | 1 ( 0.0%)\ | | |
## | | | 19\. 17\ | 1 ( 0.0%)\ | | |
## | | | 20\. 18\ | 1 ( 0.0%)\ | | |
## | | | 21\. 20\ | 1 ( 0.0%)\ | | |
## | | | 22\. 21\ | 1 ( 0.0%)\ | | |
## | | | 23\. 26\ | 1 ( 0.0%)\ | | |
## | | | 24\. 50 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 108 | STR_VEH\ | 1\. 0\ | 11487 (92.3%)\ | 12452\ | 50\ |
## | | [factor] | 2\. 1\ | 917 ( 7.4%)\ | (99.6%) | (0.4%) |
## | | | 3\. 2\ | 39 ( 0.3%)\ | | |
## | | | 4\. 3\ | 8 ( 0.1%)\ | | |
## | | | 5\. 4 | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 109 | SEXNAME\ | 1\. Male\ | 8544 (68.6%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Female\ | 3640 (29.2%)\ | (99.6%) | (0.4%) |
## | | | 3\. Reported as Unknown\ | 121 ( 1.0%)\ | | |
## | | | 4\. Not Reported\ | 114 ( 0.9%)\ | | |
## | | | 5\. Unknown | 33 ( 0.3%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 110 | PER_TYPNAME\ | 1\. Driver of a Motor Vehicle\ | 7895 (63.4%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Passenger of a Motor Vehi\ | 3438 (27.6%)\ | (99.6%) | (0.4%) |
## | | | 3\. Pedestrian\ | 878 ( 7.1%)\ | | |
## | | | 4\. Occupant of a Motor Vehic\ | 128 ( 1.0%)\ | | |
## | | | 5\. Bicyclist\ | 73 ( 0.6%)\ | | |
## | | | 6\. Unknown Occupant Type in \ | 26 ( 0.2%)\ | | |
## | | | 7\. Person on a Personal Conv\ | 4 ( 0.0%)\ | | |
## | | | 8\. Occupant of a Non-Motor V\ | 3 ( 0.0%)\ | | |
## | | | 9\. Person on Personal Convey\ | 3 ( 0.0%)\ | | |
## | | | 10\. Person on Personal Convey\ | 2 ( 0.0%)\ | | |
## | | | 11\. Person on Non-Motorized P\ | 1 ( 0.0%)\ | | |
## | | | 12\. Persons on Personal Conve | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 111 | INJ_SEVNAME\ | 1\. Fatal Injury (K)\ | 6100 (49.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. No Apparent Injury (O)\ | 2904 (23.3%)\ | (99.6%) | (0.4%) |
## | | | 3\. Suspected Serious Injury \ | 1066 ( 8.6%)\ | | |
## | | | 4\. Suspected Minor Injury (B\ | 1050 ( 8.4%)\ | | |
## | | | 5\. Possible Injury (C)\ | 851 ( 6.8%)\ | | |
## | | | 6\. Unknown/Not Reported\ | 175 ( 1.4%)\ | | |
## | | | 7\. Suspected Minor Injury(B)\ | 133 ( 1.1%)\ | | |
## | | | 8\. Suspected Serious Injury(\ | 104 ( 0.8%)\ | | |
## | | | 9\. Injured, Severity Unknown\ | 68 ( 0.5%)\ | | |
## | | | 10\. Died Prior to Crash* | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 112 | SEAT_POSNAME\ | 1\. Front Seat, Left Side\ | 7955 (63.9%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Front Seat, Right Side\ | 1746 (14.0%)\ | (99.6%) | (0.4%) |
## | | | 3\. Not a Motor Vehicle Occup\ | 965 ( 7.7%)\ | | |
## | | | 4\. Second Seat, Left Side\ | 565 ( 4.5%)\ | | |
## | | | 5\. Second Seat, Right Side\ | 512 ( 4.1%)\ | | |
## | | | 6\. Other Passenger in enclos\ | 175 ( 1.4%)\ | | |
## | | | 7\. Second Seat, Middle\ | 167 ( 1.3%)\ | | |
## | | | 8\. Reported as Unknown\ | 57 ( 0.5%)\ | | |
## | | | 9\. Sleeper Section of Cab (T\ | 56 ( 0.4%)\ | | |
## | | | 10\. Not Reported\ | 52 ( 0.4%)\ | | |
## | | | 11\. Third Seat, Left Side\ | 41 ( 0.3%)\ | | |
## | | | 12\. Third Seat, Right Side\ | 34 ( 0.3%)\ | | |
## | | | 13\. Unknown\ | 26 ( 0.2%)\ | | |
## | | | 14\. Front Seat, Middle\ | 23 ( 0.2%)\ | | |
## | | | 15\. Second Seat, Unknown\ | 23 ( 0.2%)\ | | |
## | | | 16\. Third Seat, Middle\ | 18 ( 0.1%)\ | | |
## | | | 17\. Other Passenger in unencl\ | 11 ( 0.1%)\ | | |
## | | | 18\. Riding on Exterior of Veh\ | 8 ( 0.1%)\ | | |
## | | | 19\. Front Seat, Other\ | 4 ( 0.0%)\ | | |
## | | | 20\. Front Seat, Unknown\ | 4 ( 0.0%)\ | | |
## | | | 21\. Other Passenger in passen\ | 3 ( 0.0%)\ | | |
## | | | 22\. Third Seat, Unknown\ | 3 ( 0.0%)\ | | |
## | | | 23\. Second Seat, Other\ | 2 ( 0.0%)\ | | |
## | | | 24\. Fourth Seat, Middle\ | 1 ( 0.0%)\ | | |
## | | | 25\. Fourth Seat, Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 113 | REST_USENAME\ | 1\. Shoulder and Lap Belt Use\ | 5838 (46.9%)\ | 12452\ | 50\ |
## | | [factor] | 2\. None Used/Not Applicable\ | 2885 (23.2%)\ | (99.6%) | (0.4%) |
## | | | 3\. Not a Motor Vehicle Occup\ | 965 ( 7.7%)\ | | |
## | | | 4\. Reported as Unknown\ | 810 ( 6.5%)\ | | |
## | | | 5\. None Used / Not Applicabl\ | 499 ( 4.0%)\ | | |
## | | | 6\. None Used\ | 240 ( 1.9%)\ | | |
## | | | 7\. Helmet, Unknown if DOT Co\ | 200 ( 1.6%)\ | | |
## | | | 8\. Unknown\ | 199 ( 1.6%)\ | | |
## | | | 9\. No Helmet\ | 147 ( 1.2%)\ | | |
## | | | 10\. Not Reported\ | 134 ( 1.1%)\ | | |
## | | | 11\. DOT-Compliant Motorcycle \ | 122 ( 1.0%)\ | | |
## | | | 12\. Restraint Used - Type Unk\ | 90 ( 0.7%)\ | | |
## | | | 13\. Child Restraint Type Unkn\ | 76 ( 0.6%)\ | | |
## | | | 14\. Lap Belt Only Used\ | 63 ( 0.5%)\ | | |
## | | | 15\. Child Restraint System - \ | 62 ( 0.5%)\ | | |
## | | | 16\. Shoulder Belt Only Used\ | 25 ( 0.2%)\ | | |
## | | | 17\. Booster Seat\ | 23 ( 0.2%)\ | | |
## | | | 18\. Child Restraint System - \ | 20 ( 0.2%)\ | | |
## | | | 19\. Helmet, Other than DOT-Co\ | 14 ( 0.1%)\ | | |
## | | | 20\. Not Applicable\ | 12 ( 0.1%)\ | | |
## | | | 21\. Unknown if Helmet Worn\ | 12 ( 0.1%)\ | | |
## | | | 22\. Other\ | 10 ( 0.1%)\ | | |
## | | | 23\. Child Restraint System - | 6 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 114 | REST_MISNAME\ | 1\. No\ | 3673 (29.5%)\ | 12452\ | 50\ |
## | | [factor] | 2\. None Used/Not Applicable\ | 3648 (29.3%)\ | (99.6%) | (0.4%) |
## | | | 3\. No Indication of Misuse\ | 2598 (20.9%)\ | | |
## | | | 4\. No Indication of Mis-Use\ | 1467 (11.8%)\ | | |
## | | | 5\. Not a Motor Vehicle Occup\ | 965 ( 7.7%)\ | | |
## | | | 6\. Yes, Indication of Misuse\ | 52 ( 0.4%)\ | | |
## | | | 7\. Yes, Indication of Mis-Us\ | 36 ( 0.3%)\ | | |
## | | | 8\. Yes | 13 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 115 | AIR_BAGNAME\ | 1\. Not Deployed\ | 6065 (48.7%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Deployed- Combination\ | 1742 (14.0%)\ | (99.6%) | (0.4%) |
## | | | 3\. Deployment- Unknown Locat\ | 1272 (10.2%)\ | | |
## | | | 4\. Deployed- Front\ | 1167 ( 9.4%)\ | | |
## | | | 5\. Not a Motor Vehicle Occup\ | 965 ( 7.7%)\ | | |
## | | | 6\. Reported as Deployment Un\ | 303 ( 2.4%)\ | | |
## | | | 7\. Not Applicable\ | 290 ( 2.3%)\ | | |
## | | | 8\. Not Reported\ | 255 ( 2.0%)\ | | |
## | | | 9\. Deployed- Side (door, sea\ | 191 ( 1.5%)\ | | |
## | | | 10\. Deployment Unknown\ | 100 ( 0.8%)\ | | |
## | | | 11\. Deployed- Curtain (roof)\ | 96 ( 0.8%)\ | | |
## | | | 12\. Deployed- Other (Knee, ai | 6 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 116 | EJECTIONNAME\ | 1\. Not Ejected\ | 8649 (69.5%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Not Applicable\ | 2365 (19.0%)\ | (99.6%) | (0.4%) |
## | | | 3\. Totally Ejected\ | 1057 ( 8.5%)\ | | |
## | | | 4\. Partially Ejected\ | 203 ( 1.6%)\ | | |
## | | | 5\. Not Reported\ | 95 ( 0.8%)\ | | |
## | | | 6\. Reported as Unknown if Ej\ | 59 ( 0.5%)\ | | |
## | | | 7\. Ejected - Unknown Degree\ | 18 ( 0.1%)\ | | |
## | | | 8\. Unknown if Ejected | 6 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 117 | EJ_PATHNAME\ | 1\. Ejection Path Not Applica\ | 11174 (89.7%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Ejection Path Unknown\ | 968 ( 7.8%)\ | (99.6%) | (0.4%) |
## | | | 3\. Through Side Window\ | 166 ( 1.3%)\ | | |
## | | | 4\. Through Side Door Opening\ | 46 ( 0.4%)\ | | |
## | | | 5\. Through Windshield\ | 36 ( 0.3%)\ | | |
## | | | 6\. Through Roof Opening (sun\ | 27 ( 0.2%)\ | | |
## | | | 7\. Through Back Window\ | 19 ( 0.2%)\ | | |
## | | | 8\. Other Path (e.g., back of\ | 10 ( 0.1%)\ | | |
## | | | 9\. Through roof (convertible\ | 5 ( 0.0%)\ | | |
## | | | 10\. Through Back Door/Tailgat | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 118 | EXTRICATNAME\ | 1\. Not Extricated or Not App\ | 11154 (89.6%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Extricated\ | 1036 ( 8.3%)\ | (99.6%) | (0.4%) |
## | | | 3\. Unknown | 262 ( 2.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 119 | DRINKINGNAME\ | 1\. Not Reported\ | 4867 (39.1%)\ | 12452\ | 50\ |
## | | [factor] | 2\. No (Alcohol Not Involved)\ | 4502 (36.2%)\ | (99.6%) | (0.4%) |
## | | | 3\. Yes (Alcohol Involved)\ | 1506 (12.1%)\ | | |
## | | | 4\. Reported as Unknown\ | 1217 ( 9.8%)\ | | |
## | | | 5\. Unknown (Police Reported) | 360 ( 2.9%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 120 | ALC_DETNAME\ | 1\. Not Reported\ | 6921 (79.7%)\ | 8682\ | 3820\ |
## | | [factor] | 2\. Evidential Test (breath, \ | 1161 (13.4%)\ | (69.4%) | (30.6%) |
## | | | 3\. Observed\ | 456 ( 5.3%)\ | | |
## | | | 4\. Preliminary Breath Test (\ | 57 ( 0.7%)\ | | |
## | | | 5\. Standard Field Sobriety T\ | 34 ( 0.4%)\ | | |
## | | | 6\. Behavioral\ | 31 ( 0.4%)\ | | |
## | | | 7\. Other (e.g., Saliva test)\ | 17 ( 0.2%)\ | | |
## | | | 8\. Passive Alcohol Sensor (P\ | 4 ( 0.0%)\ | | |
## | | | 9\. Breath Test, Unknown Type | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 121 | ALC_STATUSNAME\ | 1\. Test Not Given\ | 6546 (52.6%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Test Given\ | 4741 (38.1%)\ | (99.6%) | (0.4%) |
## | | | 3\. Not Reported\ | 1044 ( 8.4%)\ | | |
## | | | 4\. Reported as Unknown if Te\ | 97 ( 0.8%)\ | | |
## | | | 5\. UnKnown if Tested | 24 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 122 | ATST_TYPNAME\ | 1\. Test Not Given\ | 6546 (52.6%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Blood\ | 4032 (32.4%)\ | (99.6%) | (0.4%) |
## | | | 3\. Not Reported\ | 1072 ( 8.6%)\ | | |
## | | | 4\. Vitreous\ | 353 ( 2.8%)\ | | |
## | | | 5\. Unknown Test Type\ | 115 ( 0.9%)\ | | |
## | | | 6\. Reported as Unknown if Te\ | 97 ( 0.8%)\ | | |
## | | | 7\. Preliminary Breath Test (\ | 67 ( 0.5%)\ | | |
## | | | 8\. Breath Test (AC)\ | 39 ( 0.3%)\ | | |
## | | | 9\. Urine\ | 35 ( 0.3%)\ | | |
## | | | 10\. Other Test Type\ | 29 ( 0.2%)\ | | |
## | | | 11\. Unknown if Tested\ | 24 ( 0.2%)\ | | |
## | | | 12\. Breath Test, Unknown Type\ | 23 ( 0.2%)\ | | |
## | | | 13\. Blood Plasma/Serum\ | 12 ( 0.1%)\ | | |
## | | | 14\. Liver | 8 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 123 | DRUGSNAME\ | 1\. Not Reported\ | 6089 (48.9%)\ | 12452\ | 50\ |
## | | [factor] | 2\. No (drugs not involved)\ | 4147 (33.3%)\ | (99.6%) | (0.4%) |
## | | | 3\. Reported as Unknown\ | 1012 ( 8.1%)\ | | |
## | | | 4\. Yes (drugs involved)\ | 859 ( 6.9%)\ | | |
## | | | 5\. Unknown | 345 ( 2.8%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 124 | DRUG_DETNAME\ | 1\. Not Reported\ | 7348 (84.6%)\ | 8682\ | 3820\ |
## | | [factor] | 2\. Evidential Test (Blood, U\ | 902 (10.4%)\ | (69.4%) | (30.6%) |
## | | | 3\. Other\ | 242 ( 2.8%)\ | | |
## | | | 4\. Observed Behavior or SFST\ | 133 ( 1.5%)\ | | |
## | | | 5\. Behavioral\ | 27 ( 0.3%)\ | | |
## | | | 6\. Drug Recognition Expert (\ | 16 ( 0.2%)\ | | |
## | | | 7\. Drug Recognition Expert ( | 14 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 125 | DSTATUSNAME\ | 1\. Test Not Given\ | 6906 (55.5%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Test Given\ | 4238 (34.0%)\ | (99.6%) | (0.4%) |
## | | | 3\. Not Reported\ | 1183 ( 9.5%)\ | | |
## | | | 4\. Reported as Unknown if Te\ | 103 ( 0.8%)\ | | |
## | | | 5\. Unknown if Tested | 22 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 126 | DRUGTST1NAME\ | 1\. Test Not Given\ | 1510 (59.4%)\ | 2541\ | 9961\ |
## | | [factor] | 2\. Blood\ | 835 (32.9%)\ | (20.3%) | (79.7%) |
## | | | 3\. Not Reported\ | 86 ( 3.4%)\ | | |
## | | | 4\. Both: Blood and Urine Tes\ | 33 ( 1.3%)\ | | |
## | | | 5\. Urine\ | 32 ( 1.3%)\ | | |
## | | | 6\. Unknown if Tested\ | 22 ( 0.9%)\ | | |
## | | | 7\. Unknown Test Type\ | 12 ( 0.5%)\ | | |
## | | | 8\. Other Test Type | 11 ( 0.4%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 127 | DRUGTST2NAME\ | 1\. Test Not Given\ | 2304 (90.7%)\ | 2541\ | 9961\ |
## | | [factor] | 2\. Blood\ | 223 ( 8.8%)\ | (20.3%) | (79.7%) |
## | | | 3\. Both: Blood and Urine Tes\ | 8 ( 0.3%)\ | | |
## | | | 4\. Urine\ | 5 ( 0.2%)\ | | |
## | | | 5\. Unknown Test Type | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 128 | DRUGTST3NAME\ | 1\. Test Not Given\ | 2419 (95.2%)\ | 2541\ | 9961\ |
## | | [factor] | 2\. Blood\ | 109 ( 4.3%)\ | (20.3%) | (79.7%) |
## | | | 3\. Both: Blood and Urine Tes\ | 8 ( 0.3%)\ | | |
## | | | 4\. Urine\ | 4 ( 0.2%)\ | | |
## | | | 5\. Unknown Test Type | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 129 | DRUGRES1NAME\ | 1\. Test Not Given\ | 1510 (59.4%)\ | 2541\ | 9961\ |
## | | [factor] | 2\. Tested, No Drugs Found/Ne\ | 482 (19.0%)\ | (20.3%) | (79.7%) |
## | | | 3\. Not Reported\ | 82 ( 3.2%)\ | | |
## | | | 4\. Tetrahydrocannabinols (TH\ | 61 ( 2.4%)\ | | |
## | | | 5\. AMPHETAMINE\ | 54 ( 2.1%)\ | | |
## | | | 6\. DELTA 9\ | 52 ( 2.0%)\ | | |
## | | | 7\. Other Drug\ | 34 ( 1.3%)\ | | |
## | | | 8\. Test For Drug, Results Un\ | 33 ( 1.3%)\ | | |
## | | | 9\. BENZOYLECGONINE\ | 27 ( 1.1%)\ | | |
## | | | 10\. COCAINE\ | 24 ( 0.9%)\ | | |
## | | | 11\. Unknown if Tested\ | 22 ( 0.9%)\ | | |
## | | | 12\. Tested For Drugs, Drugs F\ | 19 ( 0.7%)\ | | |
## | | | 13\. ALPRAZOLAM\ | 13 ( 0.5%)\ | | |
## | | | 14\. ""Cannabinoid, Type Unkno\ | 11 ( 0.4%)\ | | |
## | | | 15\. METHAMPHETAMINE\ | 11 ( 0.4%)\ | | |
## | | | 16\. OXYCODONE\ | 10 ( 0.4%)\ | | |
## | | | 17\. MARIJUANA/Marihuana\ | 9 ( 0.4%)\ | | |
## | | | 18\. BENZODIAZEPINES\ | 8 ( 0.3%)\ | | |
## | | | 19\. CODEINE\ | 7 ( 0.3%)\ | | |
## | | | 20\. DIAZEPAM\ | 7 ( 0.3%)\ | | |
## | | | 21\. FENTANYL\ | 7 ( 0.3%)\ | | |
## | | | 22\. MORPHINE\ | 7 ( 0.3%)\ | | |
## | | | 23\. HYDROCODONE\ | 6 ( 0.2%)\ | | |
## | | | 24\. ""Depressants, Type Unkno\ | 5 ( 0.2%)\ | | |
## | | | 25\. METHADONE\ | 5 ( 0.2%)\ | | |
## | | | 26\. Midazolam\ | 5 ( 0.2%)\ | | |
## | | | 27\. PHENCYCLIDINE\ | 4 ( 0.2%)\ | | |
## | | | 28\. Nordiazepam\ | 3 ( 0.1%)\ | | |
## | | | 29\. ""Stimulants, Type Unknow\ | 2 ( 0.1%)\ | | |
## | | | 30\. Buprenorphine\ | 2 ( 0.1%)\ | | |
## | | | 31\. Ketamine\ | 2 ( 0.1%)\ | | |
## | | | 32\. LORAZEPAM\ | 2 ( 0.1%)\ | | |
## | | | 33\. OPIUM\ | 2 ( 0.1%)\ | | |
## | | | 34\. BARBITURATES\ | 1 ( 0.0%)\ | | |
## | | | 35\. BUTABARBITAL\ | 1 ( 0.0%)\ | | |
## | | | 36\. DIHYDROCODEINE\ | 1 ( 0.0%)\ | | |
## | | | 37\. Dihydrocodeine combinatio\ | 1 ( 0.0%)\ | | |
## | | | 38\. Levorphanol\ | 1 ( 0.0%)\ | | |
## | | | 39\. MARINOL\ | 1 ( 0.0%)\ | | |
## | | | 40\. MEPERIDINE (Pethidine)\ | 1 ( 0.0%)\ | | |
## | | | 41\. Methylenedioxymethampheta\ | 1 ( 0.0%)\ | | |
## | | | 42\. METHYLPHENIDATE\ | 1 ( 0.0%)\ | | |
## | | | 43\. Opium extract\ | 1 ( 0.0%)\ | | |
## | | | 44\. PHENOBARBITAL\ | 1 ( 0.0%)\ | | |
## | | | 45\. PHENTERMINE\ | 1 ( 0.0%)\ | | |
## | | | 46\. Zolpidem | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 130 | DRUGRES2NAME\ | 1\. Test Not Given\ | 2304 (90.7%)\ | 2541\ | 9961\ |
## | | [factor] | 2\. METHAMPHETAMINE\ | 42 ( 1.7%)\ | (20.3%) | (79.7%) |
## | | | 3\. Tetrahydrocannabinols (TH\ | 41 ( 1.6%)\ | | |
## | | | 4\. Other Drug\ | 28 ( 1.1%)\ | | |
## | | | 5\. COCAINE\ | 22 ( 0.9%)\ | | |
## | | | 6\. ""Cannabinoid, Type Unkno\ | 14 ( 0.6%)\ | | |
## | | | 7\. HYDROCODONE\ | 11 ( 0.4%)\ | | |
## | | | 8\. BENZOYLECGONINE\ | 8 ( 0.3%)\ | | |
## | | | 9\. DELTA 9\ | 8 ( 0.3%)\ | | |
## | | | 10\. AMPHETAMINE\ | 7 ( 0.3%)\ | | |
## | | | 11\. BENZODIAZEPINES\ | 5 ( 0.2%)\ | | |
## | | | 12\. MORPHINE\ | 5 ( 0.2%)\ | | |
## | | | 13\. ALPRAZOLAM\ | 4 ( 0.2%)\ | | |
## | | | 14\. DIAZEPAM\ | 4 ( 0.2%)\ | | |
## | | | 15\. Nordiazepam\ | 4 ( 0.2%)\ | | |
## | | | 16\. CODEINE\ | 3 ( 0.1%)\ | | |
## | | | 17\. METHADONE\ | 3 ( 0.1%)\ | | |
## | | | 18\. OXYCODONE\ | 3 ( 0.1%)\ | | |
## | | | 19\. Clonazepam\ | 2 ( 0.1%)\ | | |
## | | | 20\. FENTANYL\ | 2 ( 0.1%)\ | | |
## | | | 21\. Heroin (Diacetylmorphine)\ | 2 ( 0.1%)\ | | |
## | | | 22\. LORAZEPAM\ | 2 ( 0.1%)\ | | |
## | | | 23\. MARIJUANA/Marihuana\ | 2 ( 0.1%)\ | | |
## | | | 24\. Midazolam\ | 2 ( 0.1%)\ | | |
## | | | 25\. Oxymorphone\ | 2 ( 0.1%)\ | | |
## | | | 26\. ""Depressants, Type Unkno\ | 1 ( 0.0%)\ | | |
## | | | 27\. ""Narcotics, Type Unknown\ | 1 ( 0.0%)\ | | |
## | | | 28\. ""Stimulants, Type Unknow\ | 1 ( 0.0%)\ | | |
## | | | 29\. Acetaminophen + Codeine\ | 1 ( 0.0%)\ | | |
## | | | 30\. BARBITURATES\ | 1 ( 0.0%)\ | | |
## | | | 31\. Methylenedioxymethampheta\ | 1 ( 0.0%)\ | | |
## | | | 32\. OPIUM\ | 1 ( 0.0%)\ | | |
## | | | 33\. Parafluorofentanyl\ | 1 ( 0.0%)\ | | |
## | | | 34\. PHENTERMINE\ | 1 ( 0.0%)\ | | |
## | | | 35\. TEMAZEPAM\ | 1 ( 0.0%)\ | | |
## | | | 36\. Tested For Drugs, Drugs F | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 131 | DRUGRES3NAME\ | 1\. Test Not Given\ | 2417 (95.1%)\ | 2541\ | 9961\ |
## | | [factor] | 2\. Other Drug\ | 33 ( 1.3%)\ | (20.3%) | (79.7%) |
## | | | 3\. Tetrahydrocannabinols (TH\ | 15 ( 0.6%)\ | | |
## | | | 4\. ""Cannabinoid, Type Unkno\ | 10 ( 0.4%)\ | | |
## | | | 5\. DELTA 9\ | 9 ( 0.4%)\ | | |
## | | | 6\. METHAMPHETAMINE\ | 8 ( 0.3%)\ | | |
## | | | 7\. COCAINE\ | 6 ( 0.2%)\ | | |
## | | | 8\. BENZOYLECGONINE\ | 5 ( 0.2%)\ | | |
## | | | 9\. MORPHINE\ | 4 ( 0.2%)\ | | |
## | | | 10\. OXYCODONE\ | 4 ( 0.2%)\ | | |
## | | | 11\. AMPHETAMINE\ | 3 ( 0.1%)\ | | |
## | | | 12\. Ecgonine\ | 3 ( 0.1%)\ | | |
## | | | 13\. Tested For Drugs, Drugs F\ | 3 ( 0.1%)\ | | |
## | | | 14\. BENZODIAZEPINES\ | 2 ( 0.1%)\ | | |
## | | | 15\. FENTANYL\ | 2 ( 0.1%)\ | | |
## | | | 16\. HYDROCODONE\ | 2 ( 0.1%)\ | | |
## | | | 17\. HYDROMORPHONE\ | 2 ( 0.1%)\ | | |
## | | | 18\. MARIJUANA/Marihuana\ | 2 ( 0.1%)\ | | |
## | | | 19\. Nordiazepam\ | 2 ( 0.1%)\ | | |
## | | | 20\. CHLORDIAZEPROXIDE\ | 1 ( 0.0%)\ | | |
## | | | 21\. Clonazepam\ | 1 ( 0.0%)\ | | |
## | | | 22\. CODEINE\ | 1 ( 0.0%)\ | | |
## | | | 23\. DIAZEPAM\ | 1 ( 0.0%)\ | | |
## | | | 24\. DIHYDROCODEINE\ | 1 ( 0.0%)\ | | |
## | | | 25\. Methylenedioxymethampheta\ | 1 ( 0.0%)\ | | |
## | | | 26\. OPIUM\ | 1 ( 0.0%)\ | | |
## | | | 27\. Opium extract\ | 1 ( 0.0%)\ | | |
## | | | 28\. PHENCYCLIDINE | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 132 | HOSPITALNAME\ | 1\. EMS Ground\ | 4514 (36.3%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Not Transported for Treat\ | 4138 (33.2%)\ | (99.6%) | (0.4%) |
## | | | 3\. Not Transported\ | 3071 (24.7%)\ | | |
## | | | 4\. EMS Unknown Mode\ | 292 ( 2.3%)\ | | |
## | | | 5\. EMS Air\ | 203 ( 1.6%)\ | | |
## | | | 6\. Not Reported\ | 103 ( 0.8%)\ | | |
## | | | 7\. Transported Unknown Sour\ | 45 ( 0.4%)\ | | |
## | | | 8\. Other\ | 40 ( 0.3%)\ | | |
## | | | 9\. Law Enforcement\ | 30 ( 0.2%)\ | | |
## | | | 10\. Reported as Unknown\ | 12 ( 0.1%)\ | | |
## | | | 11\. Unknown | 4 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 133 | DOANAME\ | 1\. Not Applicable\ | 8785 (70.6%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Died at Scene\ | 3634 (29.2%)\ | (99.6%) | (0.4%) |
## | | | 3\. Died En Route\ | 32 ( 0.3%)\ | | |
## | | | 4\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 134 | DEATH_DANAME\ | 1\. Not Applicable (Non-Fatal\ | 6352 (51.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. 19\ | 239 ( 1.9%)\ | (99.6%) | (0.4%) |
## | | | 3\. 15\ | 228 ( 1.8%)\ | | |
## | | | 4\. 12\ | 223 ( 1.8%)\ | | |
## | | | 5\. 4\ | 223 ( 1.8%)\ | | |
## | | | 6\. 2\ | 222 ( 1.8%)\ | | |
## | | | 7\. 18\ | 214 ( 1.7%)\ | | |
## | | | 8\. 25\ | 208 ( 1.7%)\ | | |
## | | | 9\. 26\ | 207 ( 1.7%)\ | | |
## | | | 10\. 11\ | 205 ( 1.6%)\ | | |
## | | | 11\. 30\ | 204 ( 1.6%)\ | | |
## | | | 12\. 24\ | 203 ( 1.6%)\ | | |
## | | | 13\. 7\ | 203 ( 1.6%)\ | | |
## | | | 14\. 1\ | 202 ( 1.6%)\ | | |
## | | | 15\. 14\ | 199 ( 1.6%)\ | | |
## | | | 16\. 29\ | 199 ( 1.6%)\ | | |
## | | | 17\. 8\ | 198 ( 1.6%)\ | | |
## | | | 18\. 3\ | 192 ( 1.5%)\ | | |
## | | | 19\. 6\ | 192 ( 1.5%)\ | | |
## | | | 20\. 13\ | 191 ( 1.5%)\ | | |
## | | | 21\. 23\ | 191 ( 1.5%)\ | | |
## | | | 22\. 5\ | 191 ( 1.5%)\ | | |
## | | | 23\. 22\ | 189 ( 1.5%)\ | | |
## | | | 24\. 27\ | 189 ( 1.5%)\ | | |
## | | | 25\. 9\ | 188 ( 1.5%)\ | | |
## | | | 26\. 16\ | 186 ( 1.5%)\ | | |
## | | | 27\. 28\ | 185 ( 1.5%)\ | | |
## | | | 28\. 17\ | 184 ( 1.5%)\ | | |
## | | | 29\. 10\ | 180 ( 1.4%)\ | | |
## | | | 30\. 21\ | 172 ( 1.4%)\ | | |
## | | | 31\. 20\ | 171 ( 1.4%)\ | | |
## | | | 32\. 31\ | 76 ( 0.6%)\ | | |
## | | | 33\. Redacted\ | 27 ( 0.2%)\ | | |
## | | | 34\. Unknown | 19 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 135 | DEATH_MONAME\ | 1\. Not Applicable (Non-Fatal\ | 6352 (51.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. August\ | 593 ( 4.8%)\ | (99.6%) | (0.4%) |
## | | | 3\. October\ | 579 ( 4.6%)\ | | |
## | | | 4\. September\ | 551 ( 4.4%)\ | | |
## | | | 5\. July\ | 536 ( 4.3%)\ | | |
## | | | 6\. May\ | 530 ( 4.3%)\ | | |
## | | | 7\. June\ | 519 ( 4.2%)\ | | |
## | | | 8\. December\ | 489 ( 3.9%)\ | | |
## | | | 9\. November\ | 485 ( 3.9%)\ | | |
## | | | 10\. March\ | 458 ( 3.7%)\ | | |
## | | | 11\. January\ | 444 ( 3.6%)\ | | |
## | | | 12\. April\ | 441 ( 3.5%)\ | | |
## | | | 13\. February\ | 431 ( 3.5%)\ | | |
## | | | 14\. Redacted\ | 27 ( 0.2%)\ | | |
## | | | 15\. Unknown | 17 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 136 | DEATH_YRNAME\ | 1\. Not Applicable (Non-fatal\ | 6352 (51.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. 2022\ | 954 ( 7.7%)\ | (99.6%) | (0.4%) |
## | | | 3\. 2023\ | 849 ( 6.8%)\ | | |
## | | | 4\. 2021\ | 824 ( 6.6%)\ | | |
## | | | 5\. 2020\ | 793 ( 6.4%)\ | | |
## | | | 6\. 2019\ | 742 ( 6.0%)\ | | |
## | | | 7\. 2018\ | 663 ( 5.3%)\ | | |
## | | | 8\. 2017\ | 624 ( 5.0%)\ | | |
## | | | 9\. 2016\ | 617 ( 5.0%)\ | | |
## | | | 10\. Redacted\ | 27 ( 0.2%)\ | | |
## | | | 11\. Unknown | 7 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 137 | DEATH_HRNAME\ | 1\. Not Applicable (Non-fatal\ | 6352 (51.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. 2:00-2:59\ | 392 ( 3.1%)\ | (99.6%) | (0.4%) |
## | | | 3\. 1:00-1:59\ | 352 ( 2.8%)\ | | |
## | | | 4\. 0:00-0:59\ | 322 ( 2.6%)\ | | |
## | | | 5\. 3:00-3:59\ | 312 ( 2.5%)\ | | |
## | | | 6\. 23:00-23:59\ | 304 ( 2.4%)\ | | |
## | | | 7\. 21:00-21:59\ | 285 ( 2.3%)\ | | |
## | | | 8\. 22:00-22:59\ | 285 ( 2.3%)\ | | |
## | | | 9\. 18:00-18:59\ | 272 ( 2.2%)\ | | |
## | | | 10\. 20:00-20:59\ | 272 ( 2.2%)\ | | |
## | | | 11\. 19:00-19:59\ | 261 ( 2.1%)\ | | |
## | | | 12\. 16:00-16:59\ | 257 ( 2.1%)\ | | |
## | | | 13\. Unknown\ | 251 ( 2.0%)\ | | |
## | | | 14\. 17:00-17:59\ | 240 ( 1.9%)\ | | |
## | | | 15\. 4:00-4:59\ | 236 ( 1.9%)\ | | |
## | | | 16\. 15:00-15:59\ | 234 ( 1.9%)\ | | |
## | | | 17\. 14:00-14:59\ | 225 ( 1.8%)\ | | |
## | | | 18\. 13:00-13:59\ | 214 ( 1.7%)\ | | |
## | | | 19\. 6:00-6:59\ | 205 ( 1.6%)\ | | |
## | | | 20\. 5:00-5:59\ | 190 ( 1.5%)\ | | |
## | | | 21\. 7:00-7:59\ | 172 ( 1.4%)\ | | |
## | | | 22\. 9:00-9:59\ | 168 ( 1.3%)\ | | |
## | | | 23\. 12:00-12:59\ | 161 ( 1.3%)\ | | |
## | | | 24\. 8:00-8:59\ | 160 ( 1.3%)\ | | |
## | | | 25\. 11:00-11:59\ | 159 ( 1.3%)\ | | |
## | | | 26\. 10:00-10:59\ | 144 ( 1.2%)\ | | |
## | | | 27\. Redacted | 27 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 138 | P_SF1NAME\ | 1\. None\ | 5453 (98.7%)\ | 5523\ | 6979\ |
## | | [factor] | 2\. Traveling on Prohibited T\ | 41 ( 0.7%)\ | (44.2%) | (55.8%) |
## | | | 3\. Non-Driver Flees Scene\ | 5 ( 0.1%)\ | | |
## | | | 4\. Emergency Services Person\ | 4 ( 0.1%)\ | | |
## | | | 5\. Non-Motorist Pushing a Ve\ | 4 ( 0.1%)\ | | |
## | | | 6\. Reported as Unknown\ | 4 ( 0.1%)\ | | |
## | | | 7\. Unknown\ | 3 ( 0.1%)\ | | |
## | | | 8\. Interfering With Driver\ | 2 ( 0.0%)\ | | |
## | | | 9\. Mentally Challenged\ | 2 ( 0.0%)\ | | |
## | | | 10\. Construction/Maintenance/\ | 1 ( 0.0%)\ | | |
## | | | 11\. Mother of Dead Fetus/Infa\ | 1 ( 0.0%)\ | | |
## | | | 12\. Motor Vehicle (including \ | 1 ( 0.0%)\ | | |
## | | | 13\. Other Visual Obstruction\ | 1 ( 0.0%)\ | | |
## | | | 14\. Parked Vehicle | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 139 | P_SF2NAME\ | 1\. None\ | 5515 (99.9%)\ | 5523\ | 6979\ |
## | | [factor] | 2\. Reported as Unknown\ | 4 ( 0.1%)\ | (44.2%) | (55.8%) |
## | | | 3\. Unknown\ | 3 ( 0.1%)\ | | |
## | | | 4\. Alcohol and/or Drug Test | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 140 | P_SF3NAME\ | 1\. None\ | 5516 (99.9%)\ | 5523\ | 6979\ |
## | | [factor] | 2\. Reported as Unknown\ | 4 ( 0.1%)\ | (44.2%) | (55.8%) |
## | | | 3\. Unknown | 3 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 141 | WORK_INJNAME\ | 1\. Not Applicable (not a fat\ | 6352 (51.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. No\ | 5281 (42.4%)\ | (99.6%) | (0.4%) |
## | | | 3\. Unknown\ | 619 ( 5.0%)\ | | |
## | | | 4\. Yes\ | 173 ( 1.4%)\ | | |
## | | | 5\. Redacted | 27 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 142 | HISPANICNAME\ | 1\. Not A Fatality (not Appli\ | 6352 (51.0%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Non-Hispanic\ | 4097 (32.9%)\ | (99.6%) | (0.4%) |
## | | | 3\. Unknown\ | 692 ( 5.6%)\ | | |
## | | | 4\. Hispanic, Origin Not Spec\ | 627 ( 5.0%)\ | | |
## | | | 5\. Mexican\ | 465 ( 3.7%)\ | | |
## | | | 6\. Puerto Rican\ | 62 ( 0.5%)\ | | |
## | | | 7\. Central or South American\ | 57 ( 0.5%)\ | | |
## | | | 8\. Cuban\ | 40 ( 0.3%)\ | | |
## | | | 9\. European Spanish\ | 33 ( 0.3%)\ | | |
## | | | 10\. Redacted | 27 ( 0.2%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 143 | RACENAME\ | 1\. Not a Fatality (not Appli\ | 2064 (52.0%)\ | 3969\ | 8533\ |
## | | [factor] | 2\. White\ | 1370 (34.5%)\ | (31.7%) | (68.3%) |
## | | | 3\. Black\ | 333 ( 8.4%)\ | | |
## | | | 4\. Unknown\ | 79 ( 2.0%)\ | | |
## | | | 5\. All other races\ | 32 ( 0.8%)\ | | |
## | | | 6\. American Indian (includes\ | 16 ( 0.4%)\ | | |
## | | | 7\. Other Asian or Pacific Is\ | 12 ( 0.3%)\ | | |
## | | | 8\. Chinese\ | 8 ( 0.2%)\ | | |
## | | | 9\. American Indian (includes\ | 7 ( 0.2%)\ | | |
## | | | 10\. Filipino\ | 7 ( 0.2%)\ | | |
## | | | 11\. Korean\ | 7 ( 0.2%)\ | | |
## | | | 12\. Vietnamese\ | 7 ( 0.2%)\ | | |
## | | | 13\. Asian Indian\ | 6 ( 0.2%)\ | | |
## | | | 14\. Other Indian (includes So\ | 6 ( 0.2%)\ | | |
## | | | 15\. Multiple Races (individua\ | 5 ( 0.1%)\ | | |
## | | | 16\. Hawaiian (includes Part-H\ | 3 ( 0.1%)\ | | |
## | | | 17\. Samoan\ | 3 ( 0.1%)\ | | |
## | | | 18\. Asian or Pacific Islander\ | 2 ( 0.1%)\ | | |
## | | | 19\. Japanese | 2 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 144 | LOCATIONNAME\ | 1\. Occupant of a Motor Vehic\ | 11487 (92.3%)\ | 12452\ | 50\ |
## | | [factor] | 2\. Not at Intersection - On \ | 645 ( 5.2%)\ | (99.6%) | (0.4%) |
## | | | 3\. Shoulder/Roadside\ | 126 ( 1.0%)\ | | |
## | | | 4\. Not at Intersection - On \ | 49 ( 0.4%)\ | | |
## | | | 5\. At Intersection - In Mark\ | 45 ( 0.4%)\ | | |
## | | | 6\. Non- Trafficway Area\ | 25 ( 0.2%)\ | | |
## | | | 7\. Not at Intersection - In \ | 14 ( 0.1%)\ | | |
## | | | 8\. At Intersection - Not In \ | 11 ( 0.1%)\ | | |
## | | | 9\. Other\ | 11 ( 0.1%)\ | | |
## | | | 10\. Sidewalk\ | 11 ( 0.1%)\ | | |
## | | | 11\. Reported as Unknown Locat\ | 7 ( 0.1%)\ | | |
## | | | 12\. At Intersection-Unmarked \ | 5 ( 0.0%)\ | | |
## | | | 13\. Not Reported\ | 5 ( 0.0%)\ | | |
## | | | 14\. Median/Crossing Island\ | 4 ( 0.0%)\ | | |
## | | | 15\. Bicycle Lane\ | 3 ( 0.0%)\ | | |
## | | | 16\. At Intersection - In Unma\ | 1 ( 0.0%)\ | | |
## | | | 17\. At Intersection - In Unma\ | 1 ( 0.0%)\ | | |
## | | | 18\. At Intersection - Unknown\ | 1 ( 0.0%)\ | | |
## | | | 19\. Unknown Location | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 145 | HELM_USENAME\ | 1\. Not Applicable\ | 6884 (81.2%)\ | 8483\ | 4019\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 682 ( 8.0%)\ | (67.9%) | (32.1%) |
## | | | 3\. DOT-Compliant Motorcycle \ | 306 ( 3.6%)\ | | |
## | | | 4\. Helmet, Unknown if DOT-Co\ | 281 ( 3.3%)\ | | |
## | | | 5\. No Helmet\ | 268 ( 3.2%)\ | | |
## | | | 6\. Reported as Unknown if He\ | 30 ( 0.4%)\ | | |
## | | | 7\. Helmet, Other than DOT-Co\ | 22 ( 0.3%)\ | | |
## | | | 8\. Not Reported | 10 ( 0.1%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 146 | HELM_MISNAME\ | 1\. None Used/Not Applicable\ | 7192 (84.8%)\ | 8483\ | 4019\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 682 ( 8.0%)\ | (67.9%) | (32.1%) |
## | | | 3\. No Indication of Misuse\ | 379 ( 4.5%)\ | | |
## | | | 4\. No Indication of Mis-Use\ | 225 ( 2.7%)\ | | |
## | | | 5\. Yes, Indication of Mis-Us\ | 3 ( 0.0%)\ | | |
## | | | 6\. Yes, Indication of Misuse | 2 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 147 | VPICBODYCLASSNAME\ | 1\. Sedan/Saloon\ | 1796 (25.9%)\ | 6929\ | 5573\ |
## | | [factor] | 2\. Sport Utility Vehicle (SU\ | 1534 (22.1%)\ | (55.4%) | (44.6%) |
## | | | 3\. Pickup\ | 809 (11.7%)\ | | |
## | | | 4\. (Empty string)\ | 568 ( 8.2%)\ | | |
## | | | 5\. Truck-Tractor\ | 348 ( 5.0%)\ | | |
## | | | 6\. Motorcycle - Sport\ | 248 ( 3.6%)\ | | |
## | | | 7\. Motorcycle - Touring / Sp\ | 227 ( 3.3%)\ | | |
## | | | 8\. Hatchback/Liftback/Notchb\ | 222 ( 3.2%)\ | | |
## | | | 9\. Coupe\ | 216 ( 3.1%)\ | | |
## | | | 10\. Minivan\ | 143 ( 2.1%)\ | | |
## | | | 11\. Motorcycle - Custom\ | 105 ( 1.5%)\ | | |
## | | | 12\. Truck\ | 89 ( 1.3%)\ | | |
## | | | 13\. Unknown\ | 87 ( 1.3%)\ | | |
## | | | 14\. Crossover Utility Vehicle\ | 63 ( 0.9%)\ | | |
## | | | 15\. Motorcycle - Cruiser\ | 62 ( 0.9%)\ | | |
## | | | 16\. Van\ | 55 ( 0.8%)\ | | |
## | | | 17\. Convertible/Cabriolet\ | 45 ( 0.6%)\ | | |
## | | | 18\. Cargo Van\ | 43 ( 0.6%)\ | | |
## | | | 19\. Motorcycle - Street\ | 37 ( 0.5%)\ | | |
## | | | 20\. Wagon\ | 30 ( 0.4%)\ | | |
## | | | 21\. Bus\ | 28 ( 0.4%)\ | | |
## | | | 22\. Incomplete - Cutaway\ | 25 ( 0.4%)\ | | |
## | | | 23\. Motorcycle - Standard\ | 23 ( 0.3%)\ | | |
## | | | 24\. Incomplete - Chassis Cab \ | 20 ( 0.3%)\ | | |
## | | | 25\. Not Reported\ | 16 ( 0.2%)\ | | |
## | | | 26\. Motorcycle - Trike\ | 15 ( 0.2%)\ | | |
## | | | 27\. Incomplete - Chassis Cab \ | 9 ( 0.1%)\ | | |
## | | | 28\. Motorcycle - Unenclosed T\ | 9 ( 0.1%)\ | | |
## | | | 29\. Incomplete - Motor Home C\ | 8 ( 0.1%)\ | | |
## | | | 30\. Sport Utility Truck (SUT)\ | 7 ( 0.1%)\ | | |
## | | | 31\. Incomplete\ | 6 ( 0.1%)\ | | |
## | | | 32\. Motorcycle - Dual Sport /\ | 6 ( 0.1%)\ | | |
## | | | 33\. Motorcycle - Unknown Body\ | 6 ( 0.1%)\ | | |
## | | | 34\. Incomplete - School Bus C\ | 5 ( 0.1%)\ | | |
## | | | 35\. Motorcycle - Scooter\ | 5 ( 0.1%)\ | | |
## | | | 36\. Incomplete - Glider\ | 4 ( 0.1%)\ | | |
## | | | 37\. Fire Apparatus\ | 3 ( 0.0%)\ | | |
## | | | 38\. Step Van / Walk-in Van\ | 3 ( 0.0%)\ | | |
## | | | 39\. Bus - School Bus\ | 2 ( 0.0%)\ | | |
## | | | 40\. Incomplete - Chassis Cab \ | 1 ( 0.0%)\ | | |
## | | | 41\. Motorcycle - Moped | 1 ( 0.0%) | | |
## +-----+--------------------+----------------------------------+--------------------+----------+---------+
## | 148 | ICFINALBODYNAME\ | 1\. Not Applicable\ | 6278 (90.6%)\ | 6929\ | 5573\ |
## | | [factor] | 2\. (Empty string)\ | 568 ( 8.2%)\ | (55.4%) | (44.6%) |
## | | | 3\. Truck\ | 29 ( 0.4%)\ | | |
## | | | 4\. Motorhome\ | 10 ( 0.1%)\ | | |
## | | | 5\. Pickup\ | 10 ( 0.1%)\ | | |
## | | | 6\. Bus\ | 6 ( 0.1%)\ | | |
## | | | 7\. Bus - School Bus\ | 5 ( 0.1%)\ | | |
## | | | 8\. Not Reported\ | 4 ( 0.1%)\ | | |
## | | | 9\. Step Van / Walk-in Van\ | 4 ( 0.1%)\ | | |
## | | | 10\. Truck-Tractor\ | 4 ( 0.1%)\ | | |
## | | | 11\. Van\ | 4 ( 0.1%)\ | | |
## | | | 12\. Fire Apparatus\ | 3 ( 0.0%)\ | | |
## | | | 13\. Cargo Van\ | 2 ( 0.0%)\ | | |
## | | | 14\. Truck - Tractor | 2 ( 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] 12502 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
)