library(dplyr)
library(summarytools)
library(fst)
library(DT)
dat= read.fst("2016_2023_FARS_Crash_Veh_Pers_Lim_norep.fst")
dim(dat)
## [1] 643010 197
## [1] "STATE" "STATENAME" "ST_CASE"
## [4] "VE_TOTAL" "COUNTY" "COUNTYNAME"
## [7] "CITY" "CITYNAME" "DAY"
## [10] "MONTH" "MONTHNAME" "YEAR"
## [13] "DAY_WEEKNAME" "HOUR" "HOURNAME"
## [16] "NHSNAME" "ROUTENAME" "TWAY_ID"
## [19] "TWAY_ID2" "RUR_URBNAME" "FUNC_SYSNAME"
## [22] "RD_OWNERNAME" "LATITUDE" "LATITUDENAME"
## [25] "LONGITUD" "LONGITUDNAME" "SP_JURNAME"
## [28] "HARM_EVNAME" "MAN_COLLNAME" "RELJCT1NAME"
## [31] "RELJCT2NAME" "TYP_INTNAME" "WRK_ZONENAME"
## [34] "REL_ROADNAME" "LGT_CONDNAME" "WEATHER1NAME"
## [37] "WEATHER2NAME" "WEATHERNAME" "SCH_BUSNAME"
## [40] "RAILNAME" "NOT_HOURNAME" "ARR_HOUR"
## [43] "ARR_HOURNAME" "ARR_MIN" "ARR_MINNAME"
## [46] "HOSP_HR" "HOSP_HRNAME" "CF1NAME"
## [49] "CF2NAME" "CF3NAME" "FATALS"
## [52] "DRUNK_DR" "CRASH_NUM1" "CRASH_VEH_NUM1"
## [55] "VEH_NO" "NUMOCCS" "UNITTYPENAME"
## [58] "HIT_RUNNAME" "REG_STATNAME" "OWNERNAME"
## [61] "MAKENAME" "MAK_MODNAME" "BODY_TYPNAME"
## [64] "MOD_YEAR" "VINNAME" "TOW_VEHNAME"
## [67] "J_KNIFENAME" "MCARR_I1NAME" "MCARR_I2NAME"
## [70] "MCARR_IDNAME" "GVWRNAME" "V_CONFIGNAME"
## [73] "CARGO_BTNAME" "HAZ_INVNAME" "HAZ_PLACNAME"
## [76] "HAZ_IDNAME" "HAZ_CNONAME" "HAZ_RELNAME"
## [79] "BUS_USENAME" "SPEC_USENAME" "EMER_USENAME"
## [82] "TRAV_SPNAME" "UNDERIDENAME" "ROLLOVERNAME"
## [85] "ROLINLOCNAME" "IMPACT1NAME" "DEFORMEDNAME"
## [88] "TOWEDNAME" "M_HARMNAME" "VEH_SC1NAME"
## [91] "VEH_SC2NAME" "FIRE_EXPNAME" "DR_PRESNAME"
## [94] "L_STATENAME" "DR_ZIPNAME" "L_STATUSNAME"
## [97] "L_TYPENAME" "CDL_STATNAME" "L_ENDORSNAME"
## [100] "L_COMPLNAME" "L_RESTRINAME" "DR_HGT"
## [103] "DR_WGTNAME" "PREV_ACCNAME" "PREV_SUSNAME"
## [106] "PREV_DWINAME" "PREV_SPDNAME" "PREV_OTHNAME"
## [109] "FIRST_MONAME" "FIRST_YRNAME" "LAST_MONAME"
## [112] "LAST_YRNAME" "SPEEDRELNAME" "DR_SF1NAME"
## [115] "DR_SF2NAME" "DR_SF3NAME" "DR_SF4NAME"
## [118] "VTRAFWAYNAME" "VNUM_LANNAME" "VSPD_LIMNAME"
## [121] "VALIGNNAME" "VPROFILENAME" "VPAVETYPNAME"
## [124] "VSURCONDNAME" "VTRAFCONNAME" "VTCONT_FNAME"
## [127] "P_CRASH1NAME" "P_CRASH2NAME" "P_CRASH3NAME"
## [130] "PCRASH4NAME" "PCRASH5NAME" "ACC_TYPENAME"
## [133] "DEATHS" "DR_DRINKNAME" "TRLR1VINNAME"
## [136] "TRLR2VINNAME" "TRLR3VINNAME" "PREV_SUS1NAME"
## [139] "PREV_SUS2NAME" "PREV_SUS3NAME" "CRASH_VehPer_NUM1"
## [142] "VE_FORMS" "PER_NO" "STR_VEH"
## [145] "DAYNAME" "MINUTENAME" "MAK_MOD"
## [148] "MOD_YEARNAME" "AGENAME" "SEXNAME"
## [151] "PER_TYPNAME" "INJ_SEVNAME" "SEAT_POSNAME"
## [154] "REST_USENAME" "REST_MISNAME" "AIR_BAGNAME"
## [157] "EJECTIONNAME" "EJ_PATHNAME" "EXTRICATNAME"
## [160] "DRINKINGNAME" "ALC_DETNAME" "ALC_STATUSNAME"
## [163] "ATST_TYPNAME" "ALC_RESNAME" "DRUGSNAME"
## [166] "DRUG_DETNAME" "DSTATUSNAME" "DRUGTST1NAME"
## [169] "DRUGTST2NAME" "DRUGTST3NAME" "DRUGRES1NAME"
## [172] "DRUGRES2NAME" "DRUGRES3NAME" "HOSPITALNAME"
## [175] "DOANAME" "DEATH_DANAME" "DEATH_MONAME"
## [178] "DEATH_YRNAME" "DEATH_HRNAME" "DEATH_MNNAME"
## [181] "DEATH_TMNAME" "LAG_HRSNAME" "LAG_MINSNAME"
## [184] "P_SF1NAME" "P_SF2NAME" "P_SF3NAME"
## [187] "WORK_INJNAME" "HISPANICNAME" "RACENAME"
## [190] "LOCATIONNAME" "HELM_USENAME" "HELM_MISNAME"
## [193] "VPICMAKENAME" "VPICMODEL" "VPICMODELNAME"
## [196] "VPICBODYCLASSNAME" "ICFINALBODYNAME"
dat <- dat %>%
mutate(across(where(is.character), ~ iconv(., from = "", to = "UTF-8", sub = "byte")))
dat1 <- dat %>%
group_by(CRASH_NUM1) %>%
filter(any(DRUGRES1NAME=="Tetrahydrocannabinols (THC)"|
DRUGRES1NAME=="DELTA 9"|
DRUGRES1NAME=="MARIJUANA/Marihuana"|
DRUGRES1NAME=="MARINOL"|
DRUGRES2NAME=="Tetrahydrocannabinols (THC)"|
DRUGRES2NAME=="DELTA 9"|
DRUGRES2NAME=="MARIJUANA/Marihuana"|
DRUGRES2NAME=="MARINOL"|
DRUGRES3NAME=="Tetrahydrocannabinols (THC)"|
DRUGRES3NAME=="DELTA 9"|
DRUGRES3NAME=="MARIJUANA/Marihuana"|
DRUGRES3NAME=="MARINOL")) %>%
ungroup()
dim(dat1)
## [1] 16904 197
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] 16904 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_MarijuanaFatal.xlsx", overwrite = TRUE)
Descriptive 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:** 16904 x 154
## **Duplicates:** 0
##
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | No | Variable | Stats / Values | Freqs (% of Valid) | Valid | Missing |
## +=====+====================+=================================+====================+==========+==========+
## | 1 | STATE\ | 1\. 6\ | 2378 (14.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 48\ | 1245 ( 7.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 39\ | 891 ( 5.3%)\ | | |
## | | | 4\. 17\ | 865 ( 5.1%)\ | | |
## | | | 5\. 29\ | 687 ( 4.1%)\ | | |
## | | | 6\. 26\ | 652 ( 3.9%)\ | | |
## | | | 7\. 13\ | 643 ( 3.8%)\ | | |
## | | | 8\. 21\ | 629 ( 3.7%)\ | | |
## | | | 9\. 47\ | 622 ( 3.7%)\ | | |
## | | | 10\. 45\ | 603 ( 3.6%)\ | | |
## | | | 11\. 1\ | 599 ( 3.5%)\ | | |
## | | | 12\. 8\ | 543 ( 3.2%)\ | | |
## | | | 13\. 53\ | 463 ( 2.7%)\ | | |
## | | | 14\. 12\ | 462 ( 2.7%)\ | | |
## | | | 15\. 22\ | 445 ( 2.6%)\ | | |
## | | | 16\. 34\ | 445 ( 2.6%)\ | | |
## | | | 17\. 36\ | 399 ( 2.4%)\ | | |
## | | | 18\. 55\ | 326 ( 1.9%)\ | | |
## | | | 19\. 32\ | 317 ( 1.9%)\ | | |
## | | | 20\. 25\ | 304 ( 1.8%)\ | | |
## | | | 21\. 18\ | 298 ( 1.8%)\ | | |
## | | | 22\. 42\ | 270 ( 1.6%)\ | | |
## | | | 23\. 51\ | 237 ( 1.4%)\ | | |
## | | | 24\. 9\ | 207 ( 1.2%)\ | | |
## | | | 25\. 35\ | 185 ( 1.1%)\ | | |
## | | | 26\. 30\ | 184 ( 1.1%)\ | | |
## | | | 27\. 49\ | 181 ( 1.1%)\ | | |
## | | | 28\. 28\ | 162 ( 1.0%)\ | | |
## | | | 29\. 54\ | 153 ( 0.9%)\ | | |
## | | | 30\. 27\ | 147 ( 0.9%)\ | | |
## | | | 31\. 40\ | 143 ( 0.8%)\ | | |
## | | | 32\. 4\ | 140 ( 0.8%)\ | | |
## | | | 33\. 20\ | 123 ( 0.7%)\ | | |
## | | | 34\. 15\ | 112 ( 0.7%)\ | | |
## | | | 35\. 16\ | 107 ( 0.6%)\ | | |
## | | | 36\. 33\ | 105 ( 0.6%)\ | | |
## | | | 37\. 2\ | 103 ( 0.6%)\ | | |
## | | | 38\. 41\ | 91 ( 0.5%)\ | | |
## | | | 39\. 31\ | 79 ( 0.5%)\ | | |
## | | | 40\. 50\ | 71 ( 0.4%)\ | | |
## | | | 41\. 44\ | 69 ( 0.4%)\ | | |
## | | | 42\. 10\ | 63 ( 0.4%)\ | | |
## | | | 43\. 56\ | 63 ( 0.4%)\ | | |
## | | | 44\. 11\ | 22 ( 0.1%)\ | | |
## | | | 45\. 5\ | 20 ( 0.1%)\ | | |
## | | | 46\. 37\ | 16 ( 0.1%)\ | | |
## | | | 47\. 19\ | 13 ( 0.1%)\ | | |
## | | | 48\. 23\ | 13 ( 0.1%)\ | | |
## | | | 49\. 46 | 9 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 2 | STATENAME\ | 1\. California\ | 2378 (14.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Texas\ | 1245 ( 7.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Ohio\ | 891 ( 5.3%)\ | | |
## | | | 4\. Illinois\ | 865 ( 5.1%)\ | | |
## | | | 5\. Missouri\ | 687 ( 4.1%)\ | | |
## | | | 6\. Michigan\ | 652 ( 3.9%)\ | | |
## | | | 7\. Georgia\ | 643 ( 3.8%)\ | | |
## | | | 8\. Kentucky\ | 629 ( 3.7%)\ | | |
## | | | 9\. Tennessee\ | 622 ( 3.7%)\ | | |
## | | | 10\. South Carolina\ | 603 ( 3.6%)\ | | |
## | | | 11\. Alabama\ | 599 ( 3.5%)\ | | |
## | | | 12\. Colorado\ | 543 ( 3.2%)\ | | |
## | | | 13\. Washington\ | 463 ( 2.7%)\ | | |
## | | | 14\. Florida\ | 462 ( 2.7%)\ | | |
## | | | 15\. Louisiana\ | 445 ( 2.6%)\ | | |
## | | | 16\. New Jersey\ | 445 ( 2.6%)\ | | |
## | | | 17\. New York\ | 399 ( 2.4%)\ | | |
## | | | 18\. Wisconsin\ | 326 ( 1.9%)\ | | |
## | | | 19\. Nevada\ | 317 ( 1.9%)\ | | |
## | | | 20\. Massachusetts\ | 304 ( 1.8%)\ | | |
## | | | 21\. Indiana\ | 298 ( 1.8%)\ | | |
## | | | 22\. Pennsylvania\ | 270 ( 1.6%)\ | | |
## | | | 23\. Virginia\ | 237 ( 1.4%)\ | | |
## | | | 24\. Connecticut\ | 207 ( 1.2%)\ | | |
## | | | 25\. New Mexico\ | 185 ( 1.1%)\ | | |
## | | | 26\. Montana\ | 184 ( 1.1%)\ | | |
## | | | 27\. Utah\ | 181 ( 1.1%)\ | | |
## | | | 28\. Mississippi\ | 162 ( 1.0%)\ | | |
## | | | 29\. West Virginia\ | 153 ( 0.9%)\ | | |
## | | | 30\. Minnesota\ | 147 ( 0.9%)\ | | |
## | | | 31\. Oklahoma\ | 143 ( 0.8%)\ | | |
## | | | 32\. Arizona\ | 140 ( 0.8%)\ | | |
## | | | 33\. Kansas\ | 123 ( 0.7%)\ | | |
## | | | 34\. Hawaii\ | 112 ( 0.7%)\ | | |
## | | | 35\. Idaho\ | 107 ( 0.6%)\ | | |
## | | | 36\. New Hampshire\ | 105 ( 0.6%)\ | | |
## | | | 37\. Alaska\ | 103 ( 0.6%)\ | | |
## | | | 38\. Oregon\ | 91 ( 0.5%)\ | | |
## | | | 39\. Nebraska\ | 79 ( 0.5%)\ | | |
## | | | 40\. Vermont\ | 71 ( 0.4%)\ | | |
## | | | 41\. Rhode Island\ | 69 ( 0.4%)\ | | |
## | | | 42\. Delaware\ | 63 ( 0.4%)\ | | |
## | | | 43\. Wyoming\ | 63 ( 0.4%)\ | | |
## | | | 44\. District of Columbia\ | 22 ( 0.1%)\ | | |
## | | | 45\. Arkansas\ | 20 ( 0.1%)\ | | |
## | | | 46\. North Carolina\ | 16 ( 0.1%)\ | | |
## | | | 47\. Iowa\ | 13 ( 0.1%)\ | | |
## | | | 48\. Maine\ | 13 ( 0.1%)\ | | |
## | | | 49\. South Dakota | 9 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 3 | VE_TOTAL\ | 1\. 2\ | 7963 (47.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 5675 (33.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 2130 (12.6%)\ | | |
## | | | 4\. 4\ | 625 ( 3.7%)\ | | |
## | | | 5\. 5\ | 318 ( 1.9%)\ | | |
## | | | 6\. 6\ | 110 ( 0.7%)\ | | |
## | | | 7\. 7\ | 39 ( 0.2%)\ | | |
## | | | 8\. 10\ | 17 ( 0.1%)\ | | |
## | | | 9\. 12\ | 12 ( 0.1%)\ | | |
## | | | 10\. 8\ | 11 ( 0.1%)\ | | |
## | | | 11\. 9 | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 4 | DAY\ | 1\. 4\ | 646 (3.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 24\ | 620 (3.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 17\ | 611 (3.6%)\ | | |
## | | | 4\. 2\ | 598 (3.5%)\ | | |
## | | | 5\. 10\ | 598 (3.5%)\ | | |
## | | | 6\. 1\ | 593 (3.5%)\ | | |
## | | | 7\. 5\ | 583 (3.4%)\ | | |
## | | | 8\. 16\ | 576 (3.4%)\ | | |
## | | | 9\. 21\ | 575 (3.4%)\ | | |
## | | | 10\. 23\ | 574 (3.4%)\ | | |
## | | | 11\. 14\ | 570 (3.4%)\ | | |
## | | | 12\. 27\ | 566 (3.3%)\ | | |
## | | | 13\. 19\ | 565 (3.3%)\ | | |
## | | | 14\. 12\ | 563 (3.3%)\ | | |
## | | | 15\. 7\ | 562 (3.3%)\ | | |
## | | | 16\. 25\ | 548 (3.2%)\ | | |
## | | | 17\. 9\ | 545 (3.2%)\ | | |
## | | | 18\. 13\ | 542 (3.2%)\ | | |
## | | | 19\. 15\ | 537 (3.2%)\ | | |
## | | | 20\. 11\ | 536 (3.2%)\ | | |
## | | | 21\. 18\ | 532 (3.1%)\ | | |
## | | | 22\. 29\ | 531 (3.1%)\ | | |
## | | | 23\. 22\ | 529 (3.1%)\ | | |
## | | | 24\. 28\ | 519 (3.1%)\ | | |
## | | | 25\. 8\ | 515 (3.0%)\ | | |
## | | | 26\. 3\ | 514 (3.0%)\ | | |
## | | | 27\. 26\ | 502 (3.0%)\ | | |
## | | | 28\. 30\ | 496 (2.9%)\ | | |
## | | | 29\. 6\ | 493 (2.9%)\ | | |
## | | | 30\. 20\ | 467 (2.8%)\ | | |
## | | | 31\. 31 | 298 (1.8%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 5 | MONTH\ | 1\. 7\ | 1719 (10.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 5\ | 1640 ( 9.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 8\ | 1529 ( 9.0%)\ | | |
## | | | 4\. 6\ | 1493 ( 8.8%)\ | | |
## | | | 5\. 4\ | 1448 ( 8.6%)\ | | |
## | | | 6\. 10\ | 1436 ( 8.5%)\ | | |
## | | | 7\. 3\ | 1393 ( 8.2%)\ | | |
## | | | 8\. 11\ | 1378 ( 8.2%)\ | | |
## | | | 9\. 9\ | 1361 ( 8.1%)\ | | |
## | | | 10\. 1\ | 1197 ( 7.1%)\ | | |
## | | | 11\. 12\ | 1183 ( 7.0%)\ | | |
## | | | 12\. 2 | 1127 ( 6.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 6 | MONTHNAME\ | 1\. July\ | 1719 (10.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. May\ | 1640 ( 9.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. August\ | 1529 ( 9.0%)\ | | |
## | | | 4\. June\ | 1493 ( 8.8%)\ | | |
## | | | 5\. April\ | 1448 ( 8.6%)\ | | |
## | | | 6\. October\ | 1436 ( 8.5%)\ | | |
## | | | 7\. March\ | 1393 ( 8.2%)\ | | |
## | | | 8\. November\ | 1378 ( 8.2%)\ | | |
## | | | 9\. September\ | 1361 ( 8.1%)\ | | |
## | | | 10\. January\ | 1197 ( 7.1%)\ | | |
## | | | 11\. December\ | 1183 ( 7.0%)\ | | |
## | | | 12\. February | 1127 ( 6.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 7 | YEAR\ | 1\. 2017\ | 8670 (51.3%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 2016 | 8234 (48.7%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 8 | DAY_WEEKNAME\ | 1\. Saturday\ | 3420 (20.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Sunday\ | 2976 (17.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Friday\ | 2701 (16.0%)\ | | |
## | | | 4\. Thursday\ | 2056 (12.2%)\ | | |
## | | | 5\. Monday\ | 1998 (11.8%)\ | | |
## | | | 6\. Tuesday\ | 1886 (11.2%)\ | | |
## | | | 7\. Wednesday | 1867 (11.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 9 | HOUR\ | 1\. 16\ | 1031 (6.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 18\ | 1004 (5.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 19\ | 948 (5.6%)\ | | |
## | | | 4\. 20\ | 932 (5.5%)\ | | |
## | | | 5\. 17\ | 921 (5.4%)\ | | |
## | | | 6\. 15\ | 919 (5.4%)\ | | |
## | | | 7\. 23\ | 915 (5.4%)\ | | |
## | | | 8\. 21\ | 869 (5.1%)\ | | |
## | | | 9\. 22\ | 855 (5.1%)\ | | |
## | | | 10\. 2\ | 766 (4.5%)\ | | |
## | | | 11\. 0\ | 759 (4.5%)\ | | |
## | | | 12\. 1\ | 726 (4.3%)\ | | |
## | | | 13\. 14\ | 688 (4.1%)\ | | |
## | | | 14\. 13\ | 675 (4.0%)\ | | |
## | | | 15\. 3\ | 649 (3.8%)\ | | |
## | | | 16\. 12\ | 648 (3.8%)\ | | |
## | | | 17\. 5\ | 528 (3.1%)\ | | |
## | | | 18\. 7\ | 486 (2.9%)\ | | |
## | | | 19\. 6\ | 474 (2.8%)\ | | |
## | | | 20\. 11\ | 463 (2.7%)\ | | |
## | | | 21\. 4\ | 433 (2.6%)\ | | |
## | | | 22\. 10\ | 424 (2.5%)\ | | |
## | | | 23\. 8\ | 371 (2.2%)\ | | |
## | | | 24\. 9\ | 343 (2.0%)\ | | |
## | | | 25\. 99 | 77 (0.5%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 10 | HOURNAME\ | 1\. 4:00pm-4:59pm\ | 1031 (6.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 6:00pm-6:59pm\ | 1004 (5.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 7:00pm-7:59pm\ | 948 (5.6%)\ | | |
## | | | 4\. 8:00pm-8:59pm\ | 932 (5.5%)\ | | |
## | | | 5\. 5:00pm-5:59pm\ | 921 (5.4%)\ | | |
## | | | 6\. 3:00pm-3:59pm\ | 919 (5.4%)\ | | |
## | | | 7\. 11:00pm-11:59pm\ | 915 (5.4%)\ | | |
## | | | 8\. 9:00pm-9:59pm\ | 869 (5.1%)\ | | |
## | | | 9\. 10:00pm-10:59pm\ | 855 (5.1%)\ | | |
## | | | 10\. 2:00am-2:59am\ | 766 (4.5%)\ | | |
## | | | 11\. 0:00am-0:59am\ | 759 (4.5%)\ | | |
## | | | 12\. 1:00am-1:59am\ | 726 (4.3%)\ | | |
## | | | 13\. 2:00pm-2:59pm\ | 688 (4.1%)\ | | |
## | | | 14\. 1:00pm-1:59pm\ | 675 (4.0%)\ | | |
## | | | 15\. 3:00am-3:59am\ | 649 (3.8%)\ | | |
## | | | 16\. 12:00pm-12:59pm\ | 648 (3.8%)\ | | |
## | | | 17\. 5:00am-5:59am\ | 528 (3.1%)\ | | |
## | | | 18\. 7:00am-7:59am\ | 486 (2.9%)\ | | |
## | | | 19\. 6:00am-6:59am\ | 474 (2.8%)\ | | |
## | | | 20\. 11:00am-11:59am\ | 463 (2.7%)\ | | |
## | | | 21\. 4:00am-4:59am\ | 433 (2.6%)\ | | |
## | | | 22\. 10:00am-10:59am\ | 424 (2.5%)\ | | |
## | | | 23\. 8:00am-8:59am\ | 371 (2.2%)\ | | |
## | | | 24\. 9:00am-9:59am\ | 343 (2.0%)\ | | |
## | | | 25\. Unknown Hours | 77 (0.5%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 11 | NHSNAME\ | 1\. This section IS NOT on th\ | 9826 (58.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. This section IS ON the NH\ | 7003 (41.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown if this section i | 75 ( 0.4%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 12 | ROUTENAME\ | 1\. State Highway\ | 5032 (29.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Local Street - Municipali\ | 3003 (17.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. U.S. Highway\ | 2453 (14.5%)\ | | |
## | | | 4\. County Road\ | 2436 (14.4%)\ | | |
## | | | 5\. Interstate\ | 2418 (14.3%)\ | | |
## | | | 6\. Local Street - Township\ | 690 ( 4.1%)\ | | |
## | | | 7\. Other\ | 605 ( 3.6%)\ | | |
## | | | 8\. Unknown\ | 188 ( 1.1%)\ | | |
## | | | 9\. Local Street - Frontage R | 79 ( 0.5%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 13 | RUR_URBNAME\ | 1\. Urban\ | 9438 (55.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Rural\ | 7422 (43.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Trafficway Not in State I\ | 38 ( 0.2%)\ | | |
## | | | 4\. Unknown\ | 5 ( 0.0%)\ | | |
## | | | 5\. Not Reported | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 14 | FUNC_SYSNAME\ | 1\. Principal Arterial - Othe\ | 4942 (29.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Minor Arterial\ | 3688 (21.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Interstate\ | 2486 (14.7%)\ | | |
## | | | 4\. Major Collector\ | 2269 (13.4%)\ | | |
## | | | 5\. Local\ | 1930 (11.4%)\ | | |
## | | | 6\. Principal Arterial - Othe\ | 878 ( 5.2%)\ | | |
## | | | 7\. Minor Collector\ | 650 ( 3.8%)\ | | |
## | | | 8\. Trafficway Not in State I\ | 38 ( 0.2%)\ | | |
## | | | 9\. Not Reported\ | 17 ( 0.1%)\ | | |
## | | | 10\. Unknown | 6 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 15 | RD_OWNERNAME\ | 1\. State Highway Agency\ | 9308 (55.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. City or Municipal Highway\ | 2428 (14.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 2299 (13.6%)\ | | |
## | | | 4\. County Highway Agency\ | 2028 (12.0%)\ | | |
## | | | 5\. Town or Township Highway \ | 587 ( 3.5%)\ | | |
## | | | 6\. State Toll Road\ | 59 ( 0.3%)\ | | |
## | | | 7\. Other Local Agency\ | 52 ( 0.3%)\ | | |
## | | | 8\. Unknown\ | 51 ( 0.3%)\ | | |
## | | | 9\. Trafficway Not in State I\ | 38 ( 0.2%)\ | | |
## | | | 10\. Bureau of Indian Affairs\ | 13 ( 0.1%)\ | | |
## | | | 11\. State Park, Forest, or Re\ | 9 ( 0.1%)\ | | |
## | | | 12\. National Park Service\ | 7 ( 0.0%)\ | | |
## | | | 13\. Indian Tribe Nation\ | 6 ( 0.0%)\ | | |
## | | | 14\. Private (other than Railr\ | 5 ( 0.0%)\ | | |
## | | | 15\. Other State Agency\ | 4 ( 0.0%)\ | | |
## | | | 16\. Local Park, Forest or Res\ | 2 ( 0.0%)\ | | |
## | | | 17\. Other Federal Agency\ | 2 ( 0.0%)\ | | |
## | | | 18\. Other Public Instrumental\ | 2 ( 0.0%)\ | | |
## | | | 19\. Corps of Engineers\ | 1 ( 0.0%)\ | | |
## | | | 20\. Local Toll Authority\ | 1 ( 0.0%)\ | | |
## | | | 21\. Railroad\ | 1 ( 0.0%)\ | | |
## | | | 22\. U.S. Forest Service | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 16 | SP_JURNAME\ | 1\. No Special Jurisdiction\ | 16736 (99.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Indian Reservation\ | 117 ( 0.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. National Park Service\ | 36 ( 0.2%)\ | | |
## | | | 4\. Unknown\ | 12 ( 0.1%)\ | | |
## | | | 5\. Military\ | 2 ( 0.0%)\ | | |
## | | | 6\. Other | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 17 | HARM_EVNAME\ | 1\. Motor Vehicle In-Transpor\ | 10236 (60.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Rollover/Overturn\ | 1220 ( 7.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Tree (Standing Only)\ | 1044 ( 6.2%)\ | | |
## | | | 4\. Curb\ | 606 ( 3.6%)\ | | |
## | | | 5\. Embankment\ | 360 ( 2.1%)\ | | |
## | | | 6\. Guardrail Face\ | 343 ( 2.0%)\ | | |
## | | | 7\. Pedestrian\ | 342 ( 2.0%)\ | | |
## | | | 8\. Ditch\ | 339 ( 2.0%)\ | | |
## | | | 9\. Utility Pole/Light Suppor\ | 318 ( 1.9%)\ | | |
## | | | 10\. Traffic Sign Support\ | 193 ( 1.1%)\ | | |
## | | | 11\. Fence\ | 187 ( 1.1%)\ | | |
## | | | 12\. Parked Motor Vehicle\ | 162 ( 1.0%)\ | | |
## | | | 13\. Post, Pole or Other Suppo\ | 126 ( 0.7%)\ | | |
## | | | 14\. Concrete Traffic Barrier\ | 124 ( 0.7%)\ | | |
## | | | 15\. Culvert\ | 121 ( 0.7%)\ | | |
## | | | 16\. Fell/Jumped from Vehicle\ | 112 ( 0.7%)\ | | |
## | | | 17\. Mail Box\ | 101 ( 0.6%)\ | | |
## | | | 18\. Other Fixed Object\ | 99 ( 0.6%)\ | | |
## | | | 19\. Guardrail End\ | 94 ( 0.6%)\ | | |
## | | | 20\. Bridge Rail (Includes par\ | 75 ( 0.4%)\ | | |
## | | | 21\. Other Object (not fixed)\ | 71 ( 0.4%)\ | | |
## | | | 22\. Pedalcyclist\ | 69 ( 0.4%)\ | | |
## | | | 23\. Boulder\ | 54 ( 0.3%)\ | | |
## | | | 24\. Cable Barrier\ | 48 ( 0.3%)\ | | |
## | | | 25\. Wall\ | 48 ( 0.3%)\ | | |
## | | | 26\. Live Animal\ | 43 ( 0.3%)\ | | |
## | | | 27\. Other Traffic Barrier\ | 43 ( 0.3%)\ | | |
## | | | 28\. Bridge Pier or Support\ | 37 ( 0.2%)\ | | |
## | | | 29\. Impact Attenuator/Crash C\ | 37 ( 0.2%)\ | | |
## | | | 30\. Traffic Signal Support\ | 33 ( 0.2%)\ | | |
## | | | 31\. Railway Vehicle\ | 31 ( 0.2%)\ | | |
## | | | 32\. Ground\ | 30 ( 0.2%)\ | | |
## | | | 33\. Building\ | 22 ( 0.1%)\ | | |
## | | | 34\. Non-Motorist on Personal \ | 19 ( 0.1%)\ | | |
## | | | 35\. Fire Hydrant\ | 16 ( 0.1%)\ | | |
## | | | 36\. Unknown Fixed Object\ | 16 ( 0.1%)\ | | |
## | | | 37\. Motor Vehicle In-Transpor\ | 13 ( 0.1%)\ | | |
## | | | 38\. Pavement Surface Irregula\ | 13 ( 0.1%)\ | | |
## | | | 39\. Snow Bank\ | 12 ( 0.1%)\ | | |
## | | | 40\. Immersion or Partial Imme\ | 10 ( 0.1%)\ | | |
## | | | 41\. Shrubbery\ | 10 ( 0.1%)\ | | |
## | | | 42\. Other Non-Collision\ | 9 ( 0.1%)\ | | |
## | | | 43\. Jackknife (harmful to thi\ | 5 ( 0.0%)\ | | |
## | | | 44\. Working Motor Vehicle\ | 4 ( 0.0%)\ | | |
## | | | 45\. Thrown or Falling Object\ | 3 ( 0.0%)\ | | |
## | | | 46\. Object That Had Fallen Fr\ | 2 ( 0.0%)\ | | |
## | | | 47\. Unknown\ | 2 ( 0.0%)\ | | |
## | | | 48\. Ridden Animal or Animal D\ | 1 ( 0.0%)\ | | |
## | | | 49\. Unknown Object Not Fixed | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 18 | MAN_COLLNAME\ | 1\. Not a Collision with Moto\ | 6653 (39.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Angle\ | 4420 (26.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Front-to-Front\ | 2949 (17.4%)\ | | |
## | | | 4\. Front-to-Rear\ | 1812 (10.7%)\ | | |
## | | | 5\. Sideswipe - Same Directio\ | 548 ( 3.2%)\ | | |
## | | | 6\. Sideswipe - Opposite Dire\ | 356 ( 2.1%)\ | | |
## | | | 7\. Other\ | 69 ( 0.4%)\ | | |
## | | | 8\. Rear-to-Side\ | 41 ( 0.2%)\ | | |
## | | | 9\. Unknown\ | 28 ( 0.2%)\ | | |
## | | | 10\. Not Reported\ | 25 ( 0.1%)\ | | |
## | | | 11\. Rear-to-Rear | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 19 | RELJCT1NAME\ | 1\. No\ | 16095 (95.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes\ | 807 ( 4.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 20 | RELJCT2NAME\ | 1\. Non-Junction\ | 11061 (65.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Intersection\ | 3232 (19.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Intersection-Related\ | 1223 ( 7.2%)\ | | |
## | | | 4\. Driveway Access Related\ | 618 ( 3.7%)\ | | |
## | | | 5\. Entrance/Exit Ramp Relate\ | 260 ( 1.5%)\ | | |
## | | | 6\. Through Roadway\ | 206 ( 1.2%)\ | | |
## | | | 7\. Other location within Int\ | 134 ( 0.8%)\ | | |
## | | | 8\. Driveway Access\ | 60 ( 0.4%)\ | | |
## | | | 9\. Entrance/Exit Ramp\ | 35 ( 0.2%)\ | | |
## | | | 10\. Railway Grade Crossing\ | 34 ( 0.2%)\ | | |
## | | | 11\. Crossover-Related\ | 28 ( 0.2%)\ | | |
## | | | 12\. Acceleration/Deceleration\ | 5 ( 0.0%)\ | | |
## | | | 13\. Not Reported\ | 4 ( 0.0%)\ | | |
## | | | 14\. Unknown | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 21 | TYP_INTNAME\ | 1\. Not an Intersection\ | 12443 (73.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Four-Way Intersection\ | 2898 (17.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. T-Intersection\ | 1421 ( 8.4%)\ | | |
## | | | 4\. Y-Intersection\ | 98 ( 0.6%)\ | | |
## | | | 5\. L-Intersection\ | 15 ( 0.1%)\ | | |
## | | | 6\. Not Reported\ | 10 ( 0.1%)\ | | |
## | | | 7\. Five Point, or More\ | 9 ( 0.1%)\ | | |
## | | | 8\. Unknown\ | 6 ( 0.0%)\ | | |
## | | | 9\. Roundabout | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 22 | WRK_ZONENAME\ | 1\. None\ | 16548 (97.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Construction\ | 260 ( 1.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Work Zone, Type Unknown\ | 70 ( 0.4%)\ | | |
## | | | 4\. Maintenance\ | 15 ( 0.1%)\ | | |
## | | | 5\. Utility | 11 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 23 | REL_ROADNAME\ | 1\. On Roadway\ | 11147 (65.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. On Roadside\ | 4396 (26.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. On Median\ | 657 ( 3.9%)\ | | |
## | | | 4\. Outside Trafficway\ | 303 ( 1.8%)\ | | |
## | | | 5\. On Shoulder\ | 209 ( 1.2%)\ | | |
## | | | 6\. Gore\ | 80 ( 0.5%)\ | | |
## | | | 7\. Separator\ | 39 ( 0.2%)\ | | |
## | | | 8\. In Parking Lane/Zone\ | 31 ( 0.2%)\ | | |
## | | | 9\. Off Roadway-Location Unkn\ | 25 ( 0.1%)\ | | |
## | | | 10\. Continuous Left - Turn La\ | 9 ( 0.1%)\ | | |
## | | | 11\. Unknown\ | 6 ( 0.0%)\ | | |
## | | | 12\. Not Reported | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 24 | LGT_CONDNAME\ | 1\. Daylight\ | 7802 (46.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Dark - Not Lighted\ | 4593 (27.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Dark - Lighted\ | 3653 (21.6%)\ | | |
## | | | 4\. Dusk\ | 406 ( 2.4%)\ | | |
## | | | 5\. Dawn\ | 308 ( 1.8%)\ | | |
## | | | 6\. Dark - Unknown Lighting\ | 105 ( 0.6%)\ | | |
## | | | 7\. Unknown\ | 34 ( 0.2%)\ | | |
## | | | 8\. Not Reported\ | 2 ( 0.0%)\ | | |
## | | | 9\. Other | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 25 | WEATHER1NAME\ | 1\. Clear\ | 11915 (70.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Cloudy\ | 2543 (15.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rain\ | 1101 ( 6.5%)\ | | |
## | | | 4\. Not Reported\ | 881 ( 5.2%)\ | | |
## | | | 5\. Snow\ | 218 ( 1.3%)\ | | |
## | | | 6\. Fog, Smog, Smoke\ | 166 ( 1.0%)\ | | |
## | | | 7\. Unknown\ | 27 ( 0.2%)\ | | |
## | | | 8\. Other\ | 20 ( 0.1%)\ | | |
## | | | 9\. Severe Crosswinds\ | 17 ( 0.1%)\ | | |
## | | | 10\. Sleet or Hail\ | 12 ( 0.1%)\ | | |
## | | | 11\. Blowing Sand, Soil, Dirt\ | 2 ( 0.0%)\ | | |
## | | | 12\. Blowing Snow\ | 1 ( 0.0%)\ | | |
## | | | 13\. Freezing Rain or Drizzle | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 26 | WEATHER2NAME\ | 1\. No Additional Atmospheric\ | 16711 (98.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Cloudy\ | 84 ( 0.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rain\ | 58 ( 0.3%)\ | | |
## | | | 4\. Snow\ | 16 ( 0.1%)\ | | |
## | | | 5\. Blowing Snow\ | 12 ( 0.1%)\ | | |
## | | | 6\. Freezing Rain or Drizzle\ | 6 ( 0.0%)\ | | |
## | | | 7\. Sleet or Hail\ | 5 ( 0.0%)\ | | |
## | | | 8\. Blowing Sand, Soil, Dirt\ | 4 ( 0.0%)\ | | |
## | | | 9\. Fog, Smog, Smoke\ | 4 ( 0.0%)\ | | |
## | | | 10\. Severe Crosswinds\ | 3 ( 0.0%)\ | | |
## | | | 11\. Not Reported | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 27 | WEATHERNAME\ | 1\. Clear\ | 11915 (70.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Cloudy\ | 2469 (14.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rain\ | 1157 ( 6.8%)\ | | |
## | | | 4\. Not Reported\ | 881 ( 5.2%)\ | | |
## | | | 5\. Snow\ | 234 ( 1.4%)\ | | |
## | | | 6\. Fog, Smog, Smoke\ | 166 ( 1.0%)\ | | |
## | | | 7\. Unknown\ | 27 ( 0.2%)\ | | |
## | | | 8\. Severe Crosswinds\ | 19 ( 0.1%)\ | | |
## | | | 9\. Other\ | 18 ( 0.1%)\ | | |
## | | | 10\. Sleet or Hail\ | 10 ( 0.1%)\ | | |
## | | | 11\. Blowing Snow\ | 5 ( 0.0%)\ | | |
## | | | 12\. Freezing Rain or Drizzle | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 28 | SCH_BUSNAME\ | 1\. No\ | 16853 (99.7%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes | 51 ( 0.3%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 29 | RAILNAME\ | 1\. Not Applicable\ | 16865 (99.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 787996H\ | 5 ( 0.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 179791M\ | 4 ( 0.0%)\ | | |
## | | | 4\. 000314W\ | 3 ( 0.0%)\ | | |
## | | | 5\. 251263G\ | 3 ( 0.0%)\ | | |
## | | | 6\. 846922E\ | 3 ( 0.0%)\ | | |
## | | | 7\. 083045K\ | 2 ( 0.0%)\ | | |
## | | | 8\. 174009S\ | 2 ( 0.0%)\ | | |
## | | | 9\. 745870K\ | 2 ( 0.0%)\ | | |
## | | | 10\. 763375U\ | 2 ( 0.0%)\ | | |
## | | | 11\. Unknown\ | 2 ( 0.0%)\ | | |
## | | | 12\. 084764A\ | 1 ( 0.0%)\ | | |
## | | | 13\. 283389B\ | 1 ( 0.0%)\ | | |
## | | | 14\. 329234S\ | 1 ( 0.0%)\ | | |
## | | | 15\. 341219S\ | 1 ( 0.0%)\ | | |
## | | | 16\. 343668N\ | 1 ( 0.0%)\ | | |
## | | | 17\. 387995W\ | 1 ( 0.0%)\ | | |
## | | | 18\. 622076Y\ | 1 ( 0.0%)\ | | |
## | | | 19\. 724930J\ | 1 ( 0.0%)\ | | |
## | | | 20\. 731576W\ | 1 ( 0.0%)\ | | |
## | | | 21\. 804855W\ | 1 ( 0.0%)\ | | |
## | | | 22\. 852612Y | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 30 | NOT_HOURNAME\ | 1\. Unknown\ | 7897 (46.7%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 4:00pm-4:59pm\ | 614 ( 3.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. 5:00pm-5:59pm\ | 546 ( 3.2%)\ | | |
## | | | 4\. 6:00pm-6:59pm\ | 530 ( 3.1%)\ | | |
## | | | 5\. 7:00pm-7:59pm\ | 521 ( 3.1%)\ | | |
## | | | 6\. 3:00pm-3:59pm\ | 496 ( 2.9%)\ | | |
## | | | 7\. 8:00pm-8:59pm\ | 491 ( 2.9%)\ | | |
## | | | 8\. 11:00pm-11:59pm\ | 447 ( 2.6%)\ | | |
## | | | 9\. 10:00pm-10:59pm\ | 424 ( 2.5%)\ | | |
## | | | 10\. 9:00pm-9:59pm\ | 403 ( 2.4%)\ | | |
## | | | 11\. 2:00pm-2:59pm\ | 388 ( 2.3%)\ | | |
## | | | 12\. 12:00pm-12:59pm\ | 368 ( 2.2%)\ | | |
## | | | 13\. 1:00pm-1:59pm\ | 362 ( 2.1%)\ | | |
## | | | 14\. 3:00am-3:59am\ | 339 ( 2.0%)\ | | |
## | | | 15\. 0:00am-0:59am\ | 338 ( 2.0%)\ | | |
## | | | 16\. 2:00am-2:59am\ | 334 ( 2.0%)\ | | |
## | | | 17\. 1:00am-1:59am\ | 318 ( 1.9%)\ | | |
## | | | 18\. 6:00am-6:59am\ | 272 ( 1.6%)\ | | |
## | | | 19\. Not Applicable (Not Notif\ | 264 ( 1.6%)\ | | |
## | | | 20\. 11:00am-11:59am\ | 261 ( 1.5%)\ | | |
## | | | 21\. 7:00am-7:59am\ | 243 ( 1.4%)\ | | |
## | | | 22\. 4:00am-4:59am\ | 232 ( 1.4%)\ | | |
## | | | 23\. 8:00am-8:59am\ | 225 ( 1.3%)\ | | |
## | | | 24\. 5:00am-5:59am\ | 219 ( 1.3%)\ | | |
## | | | 25\. 10:00am-10:59am\ | 212 ( 1.3%)\ | | |
## | | | 26\. 9:00am-9:59am | 160 ( 0.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 31 | ARR_HOUR\ | 1\. 99\ | 7903 (46.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 16\ | 576 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 18\ | 553 ( 3.3%)\ | | |
## | | | 4\. 19\ | 541 ( 3.2%)\ | | |
## | | | 5\. 17\ | 529 ( 3.1%)\ | | |
## | | | 6\. 15\ | 504 ( 3.0%)\ | | |
## | | | 7\. 20\ | 485 ( 2.9%)\ | | |
## | | | 8\. 23\ | 437 ( 2.6%)\ | | |
## | | | 9\. 22\ | 420 ( 2.5%)\ | | |
## | | | 10\. 21\ | 407 ( 2.4%)\ | | |
## | | | 11\. 14\ | 391 ( 2.3%)\ | | |
## | | | 12\. 13\ | 373 ( 2.2%)\ | | |
## | | | 13\. 2\ | 354 ( 2.1%)\ | | |
## | | | 14\. 0\ | 347 ( 2.1%)\ | | |
## | | | 15\. 1\ | 339 ( 2.0%)\ | | |
## | | | 16\. 12\ | 321 ( 1.9%)\ | | |
## | | | 17\. 3\ | 310 ( 1.8%)\ | | |
## | | | 18\. 11\ | 289 ( 1.7%)\ | | |
## | | | 19\. 7\ | 284 ( 1.7%)\ | | |
## | | | 20\. 6\ | 270 ( 1.6%)\ | | |
## | | | 21\. 88\ | 264 ( 1.6%)\ | | |
## | | | 22\. 4\ | 239 ( 1.4%)\ | | |
## | | | 23\. 8\ | 230 ( 1.4%)\ | | |
## | | | 24\. 5\ | 192 ( 1.1%)\ | | |
## | | | 25\. 9\ | 174 ( 1.0%)\ | | |
## | | | 26\. 10 | 172 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 32 | ARR_HOURNAME\ | 1\. Unknown EMS Scene Arrival\ | 7903 (46.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 4:00pm-4:59pm\ | 576 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 6:00pm-6:59pm\ | 553 ( 3.3%)\ | | |
## | | | 4\. 7:00pm-7:59pm\ | 541 ( 3.2%)\ | | |
## | | | 5\. 5:00pm-5:59pm\ | 529 ( 3.1%)\ | | |
## | | | 6\. 3:00pm-3:59pm\ | 504 ( 3.0%)\ | | |
## | | | 7\. 8:00pm-8:59pm\ | 485 ( 2.9%)\ | | |
## | | | 8\. 11:00pm-11:59pm\ | 437 ( 2.6%)\ | | |
## | | | 9\. 10:00pm-10:59pm\ | 420 ( 2.5%)\ | | |
## | | | 10\. 9:00pm-9:59pm\ | 407 ( 2.4%)\ | | |
## | | | 11\. 2:00pm-2:59pm\ | 391 ( 2.3%)\ | | |
## | | | 12\. 1:00pm-1:59pm\ | 373 ( 2.2%)\ | | |
## | | | 13\. 2:00am-2:59am\ | 354 ( 2.1%)\ | | |
## | | | 14\. 0:00am-0:59am\ | 347 ( 2.1%)\ | | |
## | | | 15\. 1:00am-1:59am\ | 339 ( 2.0%)\ | | |
## | | | 16\. 12:00pm-12:59pm\ | 321 ( 1.9%)\ | | |
## | | | 17\. 3:00am-3:59am\ | 310 ( 1.8%)\ | | |
## | | | 18\. 11:00am-11:59am\ | 289 ( 1.7%)\ | | |
## | | | 19\. 7:00am-7:59am\ | 284 ( 1.7%)\ | | |
## | | | 20\. 6:00am-6:59am\ | 270 ( 1.6%)\ | | |
## | | | 21\. Not Applicable\ | 264 ( 1.6%)\ | | |
## | | | 22\. 4:00am-4:59am\ | 239 ( 1.4%)\ | | |
## | | | 23\. 8:00am-8:59am\ | 230 ( 1.4%)\ | | |
## | | | 24\. 5:00am-5:59am\ | 192 ( 1.1%)\ | | |
## | | | 25\. 9:00am-9:59am\ | 174 ( 1.0%)\ | | |
## | | | 26\. 10:00am-10:59am | 172 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 33 | HOSP_HR\ | 1\. 99\ | 7066 (41.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 88\ | 4012 (23.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 17\ | 433 ( 2.6%)\ | | |
## | | | 4\. 19\ | 430 ( 2.5%)\ | | |
## | | | 5\. 20\ | 377 ( 2.2%)\ | | |
## | | | 6\. 18\ | 371 ( 2.2%)\ | | |
## | | | 7\. 16\ | 348 ( 2.1%)\ | | |
## | | | 8\. 0\ | 305 ( 1.8%)\ | | |
## | | | 9\. 15\ | 300 ( 1.8%)\ | | |
## | | | 10\. 13\ | 279 ( 1.7%)\ | | |
## | | | 11\. 22\ | 268 ( 1.6%)\ | | |
## | | | 12\. 21\ | 257 ( 1.5%)\ | | |
## | | | 13\. 23\ | 248 ( 1.5%)\ | | |
## | | | 14\. 3\ | 232 ( 1.4%)\ | | |
## | | | 15\. 2\ | 220 ( 1.3%)\ | | |
## | | | 16\. 14\ | 218 ( 1.3%)\ | | |
## | | | 17\. 1\ | 213 ( 1.3%)\ | | |
## | | | 18\. 8\ | 187 ( 1.1%)\ | | |
## | | | 19\. 12\ | 186 ( 1.1%)\ | | |
## | | | 20\. 4\ | 177 ( 1.0%)\ | | |
## | | | 21\. 7\ | 155 ( 0.9%)\ | | |
## | | | 22\. 5\ | 136 ( 0.8%)\ | | |
## | | | 23\. 11\ | 136 ( 0.8%)\ | | |
## | | | 24\. 9\ | 121 ( 0.7%)\ | | |
## | | | 25\. 6\ | 117 ( 0.7%)\ | | |
## | | | 26\. 10 | 112 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 34 | HOSP_HRNAME\ | 1\. Unknown\ | 7066 (41.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Not Applicable (Not Trans\ | 4012 (23.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 5:00pm-5:59pm\ | 433 ( 2.6%)\ | | |
## | | | 4\. 7:00pm-7:59pm\ | 430 ( 2.5%)\ | | |
## | | | 5\. 8:00pm-8:59pm\ | 377 ( 2.2%)\ | | |
## | | | 6\. 6:00pm-6:59pm\ | 371 ( 2.2%)\ | | |
## | | | 7\. 4:00pm-4:59pm\ | 348 ( 2.1%)\ | | |
## | | | 8\. 0:00am-0:59am\ | 305 ( 1.8%)\ | | |
## | | | 9\. 3:00pm-3:59pm\ | 300 ( 1.8%)\ | | |
## | | | 10\. 1:00pm-1:59pm\ | 279 ( 1.7%)\ | | |
## | | | 11\. 10:00pm-10:59pm\ | 268 ( 1.6%)\ | | |
## | | | 12\. 9:00pm-9:59pm\ | 257 ( 1.5%)\ | | |
## | | | 13\. 11:00pm-11:59pm\ | 248 ( 1.5%)\ | | |
## | | | 14\. 3:00am-3:59am\ | 232 ( 1.4%)\ | | |
## | | | 15\. 2:00am-2:59am\ | 220 ( 1.3%)\ | | |
## | | | 16\. 2:00pm-2:59pm\ | 218 ( 1.3%)\ | | |
## | | | 17\. 1:00am-1:59am\ | 213 ( 1.3%)\ | | |
## | | | 18\. 8:00am-8:59am\ | 187 ( 1.1%)\ | | |
## | | | 19\. 12:00pm-12:59pm\ | 186 ( 1.1%)\ | | |
## | | | 20\. 4:00am-4:59am\ | 177 ( 1.0%)\ | | |
## | | | 21\. 7:00am-7:59am\ | 155 ( 0.9%)\ | | |
## | | | 22\. 11:00am-11:59am\ | 136 ( 0.8%)\ | | |
## | | | 23\. 5:00am-5:59am\ | 136 ( 0.8%)\ | | |
## | | | 24\. 9:00am-9:59am\ | 121 ( 0.7%)\ | | |
## | | | 25\. 6:00am-6:59am\ | 117 ( 0.7%)\ | | |
## | | | 26\. 10:00am-10:59am | 112 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 35 | CF1NAME\ | 1\. None\ | 15071 (89.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Motor Vehicle struck by f\ | 676 ( 4.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Police Pursuit Involved\ | 427 ( 2.5%)\ | | |
## | | | 4\. Unknown\ | 199 ( 1.2%)\ | | |
## | | | 5\. Recent/Previous Crash sce\ | 143 ( 0.8%)\ | | |
## | | | 6\. Indication of a Stalled/D\ | 89 ( 0.5%)\ | | |
## | | | 7\. Speed Limit is a Statutor\ | 83 ( 0.5%)\ | | |
## | | | 8\. Backup Due to Regular Con\ | 49 ( 0.3%)\ | | |
## | | | 9\. Aggressive Driving / Road\ | 31 ( 0.2%)\ | | |
## | | | 10\. Non-occupant struck by fa\ | 30 ( 0.2%)\ | | |
## | | | 11\. Date of Crash and Date of\ | 28 ( 0.2%)\ | | |
## | | | 12\. Other Maintenance or Cons\ | 28 ( 0.2%)\ | | |
## | | | 13\. Backup Due to Prior Crash\ | 11 ( 0.1%)\ | | |
## | | | 14\. Backup Due to Prior Non-R\ | 10 ( 0.1%)\ | | |
## | | | 15\. Unstabalized Situation Be\ | 10 ( 0.1%)\ | | |
## | | | 16\. Toll Booth/Plaza Related\ | 5 ( 0.0%)\ | | |
## | | | 17\. Surface Washed Out(caved-\ | 4 ( 0.0%)\ | | |
## | | | 18\. No or Obscured Pavement M\ | 2 ( 0.0%)\ | | |
## | | | 19\. Non-occupant struck vehic\ | 2 ( 0.0%)\ | | |
## | | | 20\. Shoulder Design or Condit\ | 2 ( 0.0%)\ | | |
## | | | 21\. Surface Under Water\ | 2 ( 0.0%)\ | | |
## | | | 22\. Within Designated School | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 36 | CF2NAME\ | 1\. None\ | 16570 (98.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 199 ( 1.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Indication of a Stalled/D\ | 48 ( 0.3%)\ | | |
## | | | 4\. Backup Due to Prior Crash\ | 26 ( 0.2%)\ | | |
## | | | 5\. Motor Vehicle struck by f\ | 19 ( 0.1%)\ | | |
## | | | 6\. Police Pursuit Involved\ | 9 ( 0.1%)\ | | |
## | | | 7\. Backup Due to Prior Non-R\ | 8 ( 0.0%)\ | | |
## | | | 8\. Non-occupant struck by fa\ | 8 ( 0.0%)\ | | |
## | | | 9\. Recent/Previous Crash sce\ | 8 ( 0.0%)\ | | |
## | | | 10\. No or Obscured Pavement M\ | 6 ( 0.0%)\ | | |
## | | | 11\. Speed Limit is a Statutor\ | 2 ( 0.0%)\ | | |
## | | | 12\. Unstabalized Situation Be | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 37 | CF3NAME\ | 1\. None\ | 16698 (98.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 199 ( 1.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Recent/Previous Crash sce\ | 6 ( 0.0%)\ | | |
## | | | 4\. Indication of a Stalled/D | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 38 | FATALS\ | 1\. 1\ | 13758 (81.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 2\ | 2413 (14.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 489 ( 2.9%)\ | | |
## | | | 4\. 4\ | 183 ( 1.1%)\ | | |
## | | | 5\. 5\ | 46 ( 0.3%)\ | | |
## | | | 6\. 13 | 15 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 39 | DRUNK_DR\ | 1\. 0\ | 9567 (56.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 6907 (40.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 423 ( 2.5%)\ | | |
## | | | 4\. 3 | 7 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 40 | VEH_NO\ | 1\. 1\ | 10631 (62.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 2\ | 4966 (29.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 963 ( 5.7%)\ | | |
## | | | 4\. 4\ | 217 ( 1.3%)\ | | |
## | | | 5\. 5\ | 79 ( 0.5%)\ | | |
## | | | 6\. 6\ | 27 ( 0.2%)\ | | |
## | | | 7\. 7\ | 9 ( 0.1%)\ | | |
## | | | 8\. 8\ | 6 ( 0.0%)\ | | |
## | | | 9\. 9\ | 2 ( 0.0%)\ | | |
## | | | 10\. 10\ | 2 ( 0.0%)\ | | |
## | | | 11\. 11\ | 1 ( 0.0%)\ | | |
## | | | 12\. 12 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 41 | NUMOCCS\ | 1\. 1\ | 7119 (42.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 2\ | 4560 (27.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 2326 (13.8%)\ | | |
## | | | 4\. 4\ | 1464 ( 8.7%)\ | | |
## | | | 5\. 5\ | 785 ( 4.6%)\ | | |
## | | | 6\. 6\ | 294 ( 1.7%)\ | | |
## | | | 7\. 7\ | 126 ( 0.7%)\ | | |
## | | | 8\. 99\ | 56 ( 0.3%)\ | | |
## | | | 9\. 8\ | 48 ( 0.3%)\ | | |
## | | | 10\. 23\ | 25 ( 0.1%)\ | | |
## | | | 11\. 20\ | 21 ( 0.1%)\ | | |
## | | | 12\. 9\ | 18 ( 0.1%)\ | | |
## | | | 13\. 16\ | 16 ( 0.1%)\ | | |
## | | | 14\. 0\ | 15 ( 0.1%)\ | | |
## | | | 15\. 14\ | 14 ( 0.1%)\ | | |
## | | | 16\. 11\ | 11 ( 0.1%)\ | | |
## | | | 17\. 19\ | 3 ( 0.0%)\ | | |
## | | | 18\. 10\ | 1 ( 0.0%)\ | | |
## | | | 19\. 27\ | 1 ( 0.0%)\ | | |
## | | | 20\. 42 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 42 | UNITTYPENAME\ | 1\. Motor Vehicle In-Transpor | 16904 (100.0%) | 16904\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 43 | HIT_RUNNAME\ | 1\. No\ | 16483 (97.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes\ | 386 ( 2.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown | 35 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 44 | OWNERNAME\ | 1\. Driver (in this crash) wa\ | 8198 (48.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Driver (in this crash) No\ | 6556 (38.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Vehicle Registered as Bus\ | 1254 ( 7.4%)\ | | |
## | | | 4\. Not Applicable, Vehicle N\ | 496 ( 2.9%)\ | | |
## | | | 5\. Vehicle Registered as Ren\ | 146 ( 0.9%)\ | | |
## | | | 6\. Unknown\ | 123 ( 0.7%)\ | | |
## | | | 7\. Vehicle was Stolen (repor\ | 107 ( 0.6%)\ | | |
## | | | 8\. Driverless/Motor Vehicle | 24 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 45 | TOW_VEHNAME\ | 1\. No Trailing Units\ | 16294 (96.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. One Trailing Unit\ | 553 ( 3.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Two Trailing Units\ | 25 ( 0.1%)\ | | |
## | | | 4\. Unknown\ | 14 ( 0.1%)\ | | |
## | | | 5\. Vehicle Towing Another Mo\ | 14 ( 0.1%)\ | | |
## | | | 6\. Vehicle Towing Another Mo\ | 3 ( 0.0%)\ | | |
## | | | 7\. Three or More Trailing Un | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 46 | J_KNIFENAME\ | 1\. Not an Articulated Vehicl\ | 16314 (96.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. No\ | 545 ( 3.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Yes - Subsequent Event\ | 43 ( 0.3%)\ | | |
## | | | 4\. Yes - First Event | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 47 | MCARR_I1NAME\ | 1\. Not Applicable\ | 15923 (94.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. US DOT\ | 585 ( 3.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. None\ | 222 ( 1.3%)\ | | |
## | | | 4\. Not Reported\ | 92 ( 0.5%)\ | | |
## | | | 5\. Unknown\ | 26 ( 0.2%)\ | | |
## | | | 6\. California\ | 17 ( 0.1%)\ | | |
## | | | 7\. Florida\ | 5 ( 0.0%)\ | | |
## | | | 8\. Indiana\ | 4 ( 0.0%)\ | | |
## | | | 9\. North Carolina\ | 4 ( 0.0%)\ | | |
## | | | 10\. Hawaii\ | 3 ( 0.0%)\ | | |
## | | | 11\. Illinois\ | 3 ( 0.0%)\ | | |
## | | | 12\. South Carolina\ | 3 ( 0.0%)\ | | |
## | | | 13\. Georgia\ | 2 ( 0.0%)\ | | |
## | | | 14\. Maine\ | 2 ( 0.0%)\ | | |
## | | | 15\. MC/MX (ICC)\ | 2 ( 0.0%)\ | | |
## | | | 16\. Michigan\ | 2 ( 0.0%)\ | | |
## | | | 17\. New Jersey\ | 2 ( 0.0%)\ | | |
## | | | 18\. Arkansas\ | 1 ( 0.0%)\ | | |
## | | | 19\. Louisiana\ | 1 ( 0.0%)\ | | |
## | | | 20\. Maryland\ | 1 ( 0.0%)\ | | |
## | | | 21\. New York\ | 1 ( 0.0%)\ | | |
## | | | 22\. Oklahoma\ | 1 ( 0.0%)\ | | |
## | | | 23\. Tennessee\ | 1 ( 0.0%)\ | | |
## | | | 24\. Texas | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 48 | GVWRNAME\ | 1\. Not Applicable\ | 15921 (94.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 26,001 lbs. or more\ | 634 ( 3.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. 10,001 lbs - 26,000 lbs\ | 307 ( 1.8%)\ | | |
## | | | 4\. 10,000 lbs. or less\ | 26 ( 0.2%)\ | | |
## | | | 5\. Unknown\ | 14 ( 0.1%)\ | | |
## | | | 6\. Not Reported | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 49 | V_CONFIGNAME\ | 1\. Not Applicable\ | 15924 (94.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Truck Tractor/Semi-Traile\ | 406 ( 2.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Single-Unit Truck (2- axl\ | 237 ( 1.4%)\ | | |
## | | | 4\. Bus (seats for more than \ | 111 ( 0.7%)\ | | |
## | | | 5\. Single-Unit Truck (3 or m\ | 63 ( 0.4%)\ | | |
## | | | 6\. Truck Pulling Trailer(s)\ | 57 ( 0.3%)\ | | |
## | | | 7\. Bus/Large Van (seats for \ | 29 ( 0.2%)\ | | |
## | | | 8\. Truck Tractor (Bobtail)\ | 24 ( 0.1%)\ | | |
## | | | 9\. Truck Tractor/Double\ | 24 ( 0.1%)\ | | |
## | | | 10\. Unknown\ | 19 ( 0.1%)\ | | |
## | | | 11\. Truck More Than 10,000 lb\ | 9 ( 0.1%)\ | | |
## | | | 12\. Truck Tractor/Triple | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 50 | CARGO_BTNAME\ | 1\. Not Applicable (N/A)\ | 15924 (94.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Van/Enclosed Box\ | 313 ( 1.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Bus\ | 140 ( 0.8%)\ | | |
## | | | 4\. Other\ | 115 ( 0.7%)\ | | |
## | | | 5\. Flatbed\ | 89 ( 0.5%)\ | | |
## | | | 6\. Cargo Tank\ | 58 ( 0.3%)\ | | |
## | | | 7\. Dump\ | 53 ( 0.3%)\ | | |
## | | | 8\. No Cargo Body Type\ | 53 ( 0.3%)\ | | |
## | | | 9\. Unknown Cargo Body Type\ | 53 ( 0.3%)\ | | |
## | | | 10\. Unknown\ | 19 ( 0.1%)\ | | |
## | | | 11\. Log\ | 17 ( 0.1%)\ | | |
## | | | 12\. Garbage/Refuse\ | 16 ( 0.1%)\ | | |
## | | | 13\. Auto Transporter\ | 13 ( 0.1%)\ | | |
## | | | 14\. Grain/ Chips/ Gravel\ | 13 ( 0.1%)\ | | |
## | | | 15\. Intermodal Container Chas\ | 12 ( 0.1%)\ | | |
## | | | 16\. Vehicle Towing Another Mo\ | 11 ( 0.1%)\ | | |
## | | | 17\. Concrete Mixer | 5 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 51 | HAZ_INVNAME\ | 1\. No\ | 16885 (99.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes | 19 ( 0.1%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 52 | HAZ_PLACNAME\ | 1\. Not Applicable\ | 16885 (99.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes\ | 17 ( 0.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 53 | HAZ_IDNAME\ | 1\. Not Applicable\ | 16885 (99.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1203\ | 5 ( 0.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 3 ( 0.0%)\ | | |
## | | | 4\. 1075\ | 2 ( 0.0%)\ | | |
## | | | 5\. 1263\ | 2 ( 0.0%)\ | | |
## | | | 6\. 1090\ | 1 ( 0.0%)\ | | |
## | | | 7\. 1198\ | 1 ( 0.0%)\ | | |
## | | | 8\. 1209\ | 1 ( 0.0%)\ | | |
## | | | 9\. 1267\ | 1 ( 0.0%)\ | | |
## | | | 10\. 1993\ | 1 ( 0.0%)\ | | |
## | | | 11\. 2013\ | 1 ( 0.0%)\ | | |
## | | | 12\. 3257 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 54 | HAZ_CNONAME\ | 1\. Not Applicable\ | 16885 (99.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 3\ | 6 ( 0.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 03\ | 5 ( 0.0%)\ | | |
## | | | 4\. 01\ | 1 ( 0.0%)\ | | |
## | | | 5\. 02\ | 1 ( 0.0%)\ | | |
## | | | 6\. 09\ | 1 ( 0.0%)\ | | |
## | | | 7\. 2\ | 1 ( 0.0%)\ | | |
## | | | 8\. 4\ | 1 ( 0.0%)\ | | |
## | | | 9\. 5\ | 1 ( 0.0%)\ | | |
## | | | 10\. 9\ | 1 ( 0.0%)\ | | |
## | | | 11\. Not Reported | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 55 | HAZ_RELNAME\ | 1\. Not Applicable\ | 16885 (99.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. No\ | 14 ( 0.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Yes\ | 3 ( 0.0%)\ | | |
## | | | 4\. Not Reported | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 56 | BUS_USENAME\ | 1\. Not a Bus\ | 16750 (99.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. School\ | 37 ( 0.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Shuttle\ | 37 ( 0.2%)\ | | |
## | | | 4\. Transit/ Commuter\ | 29 ( 0.2%)\ | | |
## | | | 5\. Charter/Tour\ | 15 ( 0.1%)\ | | |
## | | | 6\. Unknown\ | 14 ( 0.1%)\ | | |
## | | | 7\. Not Reported\ | 12 ( 0.1%)\ | | |
## | | | 8\. Intercity\ | 9 ( 0.1%)\ | | |
## | | | 9\. Modified for Personal/Pri | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 57 | SPEC_USENAME\ | 1\. No Special Use\ | 16715 (98.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Vehicle Used as Other Bus\ | 91 ( 0.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Vehicle Used for School T\ | 37 ( 0.2%)\ | | |
## | | | 4\. Taxi\ | 15 ( 0.1%)\ | | |
## | | | 5\. Police\ | 13 ( 0.1%)\ | | |
## | | | 6\. Unknown\ | 13 ( 0.1%)\ | | |
## | | | 7\. Fire Truck\ | 10 ( 0.1%)\ | | |
## | | | 8\. Ambulance\ | 6 ( 0.0%)\ | | |
## | | | 9\. Military | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 58 | EMER_USENAME\ | 1\. Not Applicable\ | 16870 (99.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 11 ( 0.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Emergency Operation, Emer\ | 10 ( 0.1%)\ | | |
## | | | 4\. Emergency Operation, Emer\ | 5 ( 0.0%)\ | | |
## | | | 5\. Non-Emergency, Non-Transp\ | 4 ( 0.0%)\ | | |
## | | | 6\. Non-Emergency Transport\ | 3 ( 0.0%)\ | | |
## | | | 7\. Emergency Operation, Emer | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 59 | UNDERIDENAME\ | 1\. No Underride or Override \ | 16714 (98.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Underriding a Motor Vehic\ | 67 ( 0.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Underriding a Motor Vehic\ | 43 ( 0.3%)\ | | |
## | | | 4\. Overriding a Motor Vehicl\ | 37 ( 0.2%)\ | | |
## | | | 5\. Unknown if Underride or O\ | 18 ( 0.1%)\ | | |
## | | | 6\. Underriding a Motor Vehic\ | 9 ( 0.1%)\ | | |
## | | | 7\. Underriding a Motor Vehic\ | 7 ( 0.0%)\ | | |
## | | | 8\. Underriding a Motor Vehic\ | 6 ( 0.0%)\ | | |
## | | | 9\. Underriding a Motor Vehic\ | 2 ( 0.0%)\ | | |
## | | | 10\. Overriding a Motor Vehicl | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 60 | ROLLOVERNAME\ | 1\. No Rollover\ | 13181 (78.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Rollover, Tripped by Obje\ | 2884 (17.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rollover, Untripped\ | 558 ( 3.3%)\ | | |
## | | | 4\. Rollover, Unknown Type | 281 ( 1.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 61 | ROLINLOCNAME\ | 1\. No Rollover\ | 13181 (78.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. On Roadside\ | 2173 (12.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. On Roadway\ | 786 ( 4.6%)\ | | |
## | | | 4\. On Median/Separator\ | 306 ( 1.8%)\ | | |
## | | | 5\. Outside of Trafficway\ | 253 ( 1.5%)\ | | |
## | | | 6\. On Shoulder\ | 75 ( 0.4%)\ | | |
## | | | 7\. Unknown\ | 66 ( 0.4%)\ | | |
## | | | 8\. In Gore\ | 62 ( 0.4%)\ | | |
## | | | 9\. In Parking Lane/Zone | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 62 | IMPACT1NAME\ | 1\. 12 Clock Point\ | 8330 (49.3%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Non-Collision\ | 1233 ( 7.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. 6 Clock Point\ | 1114 ( 6.6%)\ | | |
## | | | 4\. 3 Clock Point\ | 748 ( 4.4%)\ | | |
## | | | 5\. 9 Clock Point\ | 743 ( 4.4%)\ | | |
## | | | 6\. 11 Clock Point\ | 688 ( 4.1%)\ | | |
## | | | 7\. Not Reported\ | 680 ( 4.0%)\ | | |
## | | | 8\. 1 Clock Point\ | 492 ( 2.9%)\ | | |
## | | | 9\. Right\ | 432 ( 2.6%)\ | | |
## | | | 10\. Left\ | 416 ( 2.5%)\ | | |
## | | | 11\. Left-Front Side\ | 245 ( 1.4%)\ | | |
## | | | 12\. 10 Clock Point\ | 232 ( 1.4%)\ | | |
## | | | 13\. 2 Clock Point\ | 224 ( 1.3%)\ | | |
## | | | 14\. Right-Front Side\ | 194 ( 1.1%)\ | | |
## | | | 15\. Unknown\ | 177 ( 1.0%)\ | | |
## | | | 16\. 7 Clock Point\ | 175 ( 1.0%)\ | | |
## | | | 17\. Undercarriage\ | 164 ( 1.0%)\ | | |
## | | | 18\. 8 Clock Point\ | 143 ( 0.8%)\ | | |
## | | | 19\. 5 Clock Point\ | 122 ( 0.7%)\ | | |
## | | | 20\. 4 Clock Point\ | 113 ( 0.7%)\ | | |
## | | | 21\. Left-Back Side\ | 84 ( 0.5%)\ | | |
## | | | 22\. Right-Back Side\ | 81 ( 0.5%)\ | | |
## | | | 23\. Top\ | 48 ( 0.3%)\ | | |
## | | | 24\. Other Objects Set-In-Moti\ | 15 ( 0.1%)\ | | |
## | | | 25\. Cargo/Vehicle Parts Set-I\ | 9 ( 0.1%)\ | | |
## | | | 26\. Object Set in Motion, Unk | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 63 | DEFORMEDNAME\ | 1\. Disabling Damage\ | 13837 (81.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 1045 ( 6.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Functional Damage\ | 1031 ( 6.1%)\ | | |
## | | | 4\. Minor Damage\ | 740 ( 4.4%)\ | | |
## | | | 5\. No Damage\ | 156 ( 0.9%)\ | | |
## | | | 6\. Unknown | 95 ( 0.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 64 | TOWEDNAME\ | 1\. Towed Due to Disabling Da\ | 14562 (86.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Not Towed\ | 1177 ( 7.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Towed Not Due to Disablin\ | 1010 ( 6.0%)\ | | |
## | | | 4\. Not Reported\ | 131 ( 0.8%)\ | | |
## | | | 5\. Unknown | 24 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 65 | M_HARMNAME\ | 1\. Motor Vehicle In-Transpor\ | 10007 (59.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Rollover/Overturn\ | 2420 (14.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Tree (Standing Only)\ | 1464 ( 8.7%)\ | | |
## | | | 4\. Utility Pole/Light Suppor\ | 420 ( 2.5%)\ | | |
## | | | 5\. Pedestrian\ | 374 ( 2.2%)\ | | |
## | | | 6\. Motor Vehicle In-Transpor\ | 228 ( 1.3%)\ | | |
## | | | 7\. Fire/Explosion\ | 216 ( 1.3%)\ | | |
## | | | 8\. Guardrail Face\ | 138 ( 0.8%)\ | | |
## | | | 9\. Parked Motor Vehicle\ | 130 ( 0.8%)\ | | |
## | | | 10\. Fell/Jumped from Vehicle\ | 103 ( 0.6%)\ | | |
## | | | 11\. Embankment\ | 91 ( 0.5%)\ | | |
## | | | 12\. Ditch\ | 89 ( 0.5%)\ | | |
## | | | 13\. Concrete Traffic Barrier\ | 86 ( 0.5%)\ | | |
## | | | 14\. Immersion or Partial Imme\ | 77 ( 0.5%)\ | | |
## | | | 15\. Culvert\ | 74 ( 0.4%)\ | | |
## | | | 16\. Pedalcyclist\ | 74 ( 0.4%)\ | | |
## | | | 17\. Curb\ | 72 ( 0.4%)\ | | |
## | | | 18\. Guardrail End\ | 66 ( 0.4%)\ | | |
## | | | 19\. Wall\ | 66 ( 0.4%)\ | | |
## | | | 20\. Building\ | 65 ( 0.4%)\ | | |
## | | | 21\. Fence\ | 65 ( 0.4%)\ | | |
## | | | 22\. Bridge Pier or Support\ | 61 ( 0.4%)\ | | |
## | | | 23\. Traffic Signal Support\ | 54 ( 0.3%)\ | | |
## | | | 24\. Other Fixed Object\ | 51 ( 0.3%)\ | | |
## | | | 25\. Other Object (not fixed)\ | 48 ( 0.3%)\ | | |
## | | | 26\. Post, Pole or Other Suppo\ | 43 ( 0.3%)\ | | |
## | | | 27\. Traffic Sign Support\ | 43 ( 0.3%)\ | | |
## | | | 28\. Boulder\ | 40 ( 0.2%)\ | | |
## | | | 29\. Railway Vehicle\ | 33 ( 0.2%)\ | | |
## | | | 30\. Live Animal\ | 31 ( 0.2%)\ | | |
## | | | 31\. Bridge Rail (Includes par\ | 26 ( 0.2%)\ | | |
## | | | 32\. Object That Had Fallen Fr\ | 21 ( 0.1%)\ | | |
## | | | 33\. Impact Attenuator/Crash C\ | 20 ( 0.1%)\ | | |
## | | | 34\. Non-Motorist on Personal \ | 20 ( 0.1%)\ | | |
## | | | 35\. Mail Box\ | 19 ( 0.1%)\ | | |
## | | | 36\. Other Traffic Barrier\ | 16 ( 0.1%)\ | | |
## | | | 37\. Fire Hydrant\ | 11 ( 0.1%)\ | | |
## | | | 38\. Ground\ | 11 ( 0.1%)\ | | |
## | | | 39\. Cable Barrier\ | 9 ( 0.1%)\ | | |
## | | | 40\. Working Motor Vehicle\ | 6 ( 0.0%)\ | | |
## | | | 41\. Other Non-Collision\ | 5 ( 0.0%)\ | | |
## | | | 42\. Thrown or Falling Object\ | 3 ( 0.0%)\ | | |
## | | | 43\. Unknown\ | 3 ( 0.0%)\ | | |
## | | | 44\. Bridge Overhead Structure\ | 1 ( 0.0%)\ | | |
## | | | 45\. Injured In Vehicle (Non-C\ | 1 ( 0.0%)\ | | |
## | | | 46\. Pavement Surface Irregula\ | 1 ( 0.0%)\ | | |
## | | | 47\. Ridden Animal or Animal D\ | 1 ( 0.0%)\ | | |
## | | | 48\. Shrubbery | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 66 | VEH_SC1NAME\ | 1\. None\ | 16773 (99.2%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 47 ( 0.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Vehicle Registration for \ | 47 ( 0.3%)\ | | |
## | | | 4\. Other Working Vehicle (No\ | 20 ( 0.1%)\ | | |
## | | | 5\. Police, Fire, or EMS Vehi\ | 6 ( 0.0%)\ | | |
## | | | 6\. Reconstructed/Altered Veh\ | 5 ( 0.0%)\ | | |
## | | | 7\. Adaptive Equipment\ | 3 ( 0.0%)\ | | |
## | | | 8\. Highway Construction, Mai | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 67 | VEH_SC2NAME\ | 1\. None\ | 16857 (99.7%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown | 47 ( 0.3%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 68 | FIRE_EXPNAME\ | 1\. No or Not Reported\ | 16161 (95.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes | 743 ( 4.4%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 69 | DR_PRESNAME\ | 1\. Yes\ | 16876 (99.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. No Driver Present/Not App | 28 ( 0.2%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 70 | L_STATUSNAME\ | 1\. Valid\ | 13180 (78.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Suspended\ | 1449 ( 8.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not licensed\ | 1392 ( 8.2%)\ | | |
## | | | 4\. Revoked\ | 315 ( 1.9%)\ | | |
## | | | 5\. Expired\ | 256 ( 1.5%)\ | | |
## | | | 6\. Unknown License Status\ | 224 ( 1.3%)\ | | |
## | | | 7\. Canceled or denied\ | 60 ( 0.4%)\ | | |
## | | | 8\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 71 | L_TYPENAME\ | 1\. Full Driver License\ | 14533 (86.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Not Licensed\ | 1392 ( 8.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Intermediate Driver Licen\ | 480 ( 2.8%)\ | | |
## | | | 4\. Unknown License Type\ | 225 ( 1.3%)\ | | |
## | | | 5\. Learner`s Permit\ | 189 ( 1.1%)\ | | |
## | | | 6\. Temporary License\ | 57 ( 0.3%)\ | | |
## | | | 7\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 72 | CDL_STATNAME\ | 1\. No (CDL)\ | 15315 (90.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Valid\ | 1099 ( 6.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown License Status\ | 223 ( 1.3%)\ | | |
## | | | 4\. Disqualified\ | 143 ( 0.8%)\ | | |
## | | | 5\. Suspended\ | 31 ( 0.2%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 7\. Cancelled or Denied\ | 22 ( 0.1%)\ | | |
## | | | 8\. Expired\ | 17 ( 0.1%)\ | | |
## | | | 9\. Other Not-Valid\ | 17 ( 0.1%)\ | | |
## | | | 10\. Revoked\ | 8 ( 0.0%)\ | | |
## | | | 11\. Learner`s Permit | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 73 | L_ENDORSNAME\ | 1\. No Endorsements required \ | 16391 (97.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown, if required\ | 218 ( 1.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Endorsement(s) Required, \ | 192 ( 1.1%)\ | | |
## | | | 4\. Endorsement(s) Required, \ | 67 ( 0.4%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 6\. Endorsement(s) Required, | 8 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 74 | L_COMPLNAME\ | 1\. Valid license for this cl\ | 12821 (75.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. No valid license for this\ | 2378 (14.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not licensed\ | 1381 ( 8.2%)\ | | |
## | | | 4\. Unknown\ | 228 ( 1.3%)\ | | |
## | | | 5\. No license required for t\ | 63 ( 0.4%)\ | | |
## | | | 6\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 7\. Unknown If CDL and/or CDL | 5 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 75 | L_RESTRINAME\ | 1\. No Restrictions or Not Ap\ | 12583 (74.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Restrictions, Compliance \ | 3049 (18.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Restrictions Complied Wit\ | 732 ( 4.3%)\ | | |
## | | | 4\. Restrictions Not Complied\ | 264 ( 1.6%)\ | | |
## | | | 5\. Unknown\ | 248 ( 1.5%)\ | | |
## | | | 6\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 76 | DR_HGT\ | 1\. 999\ | 2045 (12.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 70\ | 1530 ( 9.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. 72\ | 1443 ( 8.5%)\ | | |
## | | | 4\. 71\ | 1404 ( 8.3%)\ | | |
## | | | 5\. 69\ | 1245 ( 7.4%)\ | | |
## | | | 6\. 67\ | 1244 ( 7.4%)\ | | |
## | | | 7\. 68\ | 1233 ( 7.3%)\ | | |
## | | | 8\. 66\ | 1126 ( 6.7%)\ | | |
## | | | 9\. 73\ | 941 ( 5.6%)\ | | |
## | | | 10\. 65\ | 828 ( 4.9%)\ | | |
## | | | 11\. 64\ | 766 ( 4.5%)\ | | |
## | | | 12\. 74\ | 676 ( 4.0%)\ | | |
## | | | 13\. 63\ | 539 ( 3.2%)\ | | |
## | | | 14\. 62\ | 496 ( 2.9%)\ | | |
## | | | 15\. 75\ | 402 ( 2.4%)\ | | |
## | | | 16\. 61\ | 276 ( 1.6%)\ | | |
## | | | 17\. 76\ | 199 ( 1.2%)\ | | |
## | | | 18\. 60\ | 198 ( 1.2%)\ | | |
## | | | 19\. 77\ | 118 ( 0.7%)\ | | |
## | | | 20\. 59\ | 76 ( 0.4%)\ | | |
## | | | 21\. 78\ | 35 ( 0.2%)\ | | |
## | | | 22\. 998\ | 28 ( 0.2%)\ | | |
## | | | 23\. 58\ | 15 ( 0.1%)\ | | |
## | | | 24\. 80\ | 12 ( 0.1%)\ | | |
## | | | 25\. 57\ | 11 ( 0.1%)\ | | |
## | | | 26\. 79\ | 10 ( 0.1%)\ | | |
## | | | 27\. 81\ | 4 ( 0.0%)\ | | |
## | | | 28\. 55\ | 2 ( 0.0%)\ | | |
## | | | 29\. 51\ | 1 ( 0.0%)\ | | |
## | | | 30\. 82 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 77 | PREV_ACCNAME\ | 1\. None\ | 11887 (70.3%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 2283 (13.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Crashes Not Reported on D\ | 1515 ( 9.0%)\ | | |
## | | | 4\. 2\ | 588 ( 3.5%)\ | | |
## | | | 5\. Unknown\ | 392 ( 2.3%)\ | | |
## | | | 6\. 3\ | 170 ( 1.0%)\ | | |
## | | | 7\. 4\ | 34 ( 0.2%)\ | | |
## | | | 8\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 9\. 5\ | 4 ( 0.0%)\ | | |
## | | | 10\. 6 | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 78 | PREV_SUSNAME\ | 1\. None\ | 13095 (77.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 1548 ( 9.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 750 ( 4.4%)\ | | |
## | | | 4\. Unknown\ | 392 ( 2.3%)\ | | |
## | | | 5\. 3\ | 333 ( 2.0%)\ | | |
## | | | 6\. 4\ | 238 ( 1.4%)\ | | |
## | | | 7\. 5\ | 147 ( 0.9%)\ | | |
## | | | 8\. 6\ | 81 ( 0.5%)\ | | |
## | | | 9\. 7\ | 62 ( 0.4%)\ | | |
## | | | 10\. 8\ | 57 ( 0.3%)\ | | |
## | | | 11\. 9\ | 37 ( 0.2%)\ | | |
## | | | 12\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 13\. 10\ | 26 ( 0.2%)\ | | |
## | | | 14\. 13\ | 20 ( 0.1%)\ | | |
## | | | 15\. 11\ | 16 ( 0.1%)\ | | |
## | | | 16\. 12\ | 14 ( 0.1%)\ | | |
## | | | 17\. 14\ | 10 ( 0.1%)\ | | |
## | | | 18\. 15\ | 10 ( 0.1%)\ | | |
## | | | 19\. 16\ | 9 ( 0.1%)\ | | |
## | | | 20\. 22\ | 6 ( 0.0%)\ | | |
## | | | 21\. 17\ | 5 ( 0.0%)\ | | |
## | | | 22\. 18\ | 5 ( 0.0%)\ | | |
## | | | 23\. 23\ | 3 ( 0.0%)\ | | |
## | | | 24\. 27\ | 2 ( 0.0%)\ | | |
## | | | 25\. 28\ | 2 ( 0.0%)\ | | |
## | | | 26\. 30\ | 2 ( 0.0%)\ | | |
## | | | 27\. 19\ | 1 ( 0.0%)\ | | |
## | | | 28\. 20\ | 1 ( 0.0%)\ | | |
## | | | 29\. 26\ | 1 ( 0.0%)\ | | |
## | | | 30\. 34\ | 1 ( 0.0%)\ | | |
## | | | 31\. 35\ | 1 ( 0.0%)\ | | |
## | | | 32\. 36 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 79 | PREV_DWINAME\ | 1\. None\ | 15699 (92.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 655 ( 3.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown\ | 392 ( 2.3%)\ | | |
## | | | 4\. 2\ | 96 ( 0.6%)\ | | |
## | | | 5\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 6\. 3\ | 24 ( 0.1%)\ | | |
## | | | 7\. 4\ | 8 ( 0.0%)\ | | |
## | | | 8\. 6 | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 80 | PREV_SPDNAME\ | 1\. None\ | 12793 (75.7%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 2444 (14.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 775 ( 4.6%)\ | | |
## | | | 4\. Unknown\ | 392 ( 2.3%)\ | | |
## | | | 5\. 3\ | 263 ( 1.6%)\ | | |
## | | | 6\. 4\ | 114 ( 0.7%)\ | | |
## | | | 7\. 5\ | 57 ( 0.3%)\ | | |
## | | | 8\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 9\. 6\ | 17 ( 0.1%)\ | | |
## | | | 10\. 7\ | 12 ( 0.1%)\ | | |
## | | | 11\. 8\ | 4 ( 0.0%)\ | | |
## | | | 12\. 10\ | 3 ( 0.0%)\ | | |
## | | | 13\. 14 | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 81 | PREV_OTHNAME\ | 1\. None\ | 12330 (72.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 1\ | 2431 (14.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 895 ( 5.3%)\ | | |
## | | | 4\. Unknown\ | 392 ( 2.3%)\ | | |
## | | | 5\. 3\ | 353 ( 2.1%)\ | | |
## | | | 6\. 4\ | 171 ( 1.0%)\ | | |
## | | | 7\. 5\ | 122 ( 0.7%)\ | | |
## | | | 8\. 7\ | 59 ( 0.3%)\ | | |
## | | | 9\. 6\ | 52 ( 0.3%)\ | | |
## | | | 10\. No Driver Present/Unknown\ | 28 ( 0.2%)\ | | |
## | | | 11\. 8\ | 20 ( 0.1%)\ | | |
## | | | 12\. 9\ | 13 ( 0.1%)\ | | |
## | | | 13\. 10\ | 10 ( 0.1%)\ | | |
## | | | 14\. 11\ | 10 ( 0.1%)\ | | |
## | | | 15\. 13\ | 3 ( 0.0%)\ | | |
## | | | 16\. 15\ | 3 ( 0.0%)\ | | |
## | | | 17\. 16\ | 3 ( 0.0%)\ | | |
## | | | 18\. 12\ | 2 ( 0.0%)\ | | |
## | | | 19\. 14\ | 2 ( 0.0%)\ | | |
## | | | 20\. 20\ | 2 ( 0.0%)\ | | |
## | | | 21\. 59\ | 2 ( 0.0%)\ | | |
## | | | 22\. 19 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 82 | FIRST_MONAME\ | 1\. No Record\ | 8074 (47.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. April\ | 777 ( 4.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. September\ | 748 ( 4.4%)\ | | |
## | | | 4\. March\ | 747 ( 4.4%)\ | | |
## | | | 5\. May\ | 737 ( 4.4%)\ | | |
## | | | 6\. July\ | 733 ( 4.3%)\ | | |
## | | | 7\. August\ | 711 ( 4.2%)\ | | |
## | | | 8\. October\ | 680 ( 4.0%)\ | | |
## | | | 9\. June\ | 679 ( 4.0%)\ | | |
## | | | 10\. February\ | 676 ( 4.0%)\ | | |
## | | | 11\. January\ | 673 ( 4.0%)\ | | |
## | | | 12\. November\ | 634 ( 3.8%)\ | | |
## | | | 13\. December\ | 609 ( 3.6%)\ | | |
## | | | 14\. Unknown\ | 398 ( 2.4%)\ | | |
## | | | 15\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 83 | FIRST_YRNAME\ | 1\. No Record\ | 8074 (47.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 2013\ | 1750 (10.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2014\ | 1631 ( 9.6%)\ | | |
## | | | 4\. 2012\ | 1494 ( 8.8%)\ | | |
## | | | 5\. 2015\ | 1460 ( 8.6%)\ | | |
## | | | 6\. 2016\ | 1148 ( 6.8%)\ | | |
## | | | 7\. 2011\ | 547 ( 3.2%)\ | | |
## | | | 8\. Unknown\ | 393 ( 2.3%)\ | | |
## | | | 9\. 2017\ | 379 ( 2.2%)\ | | |
## | | | 10\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 84 | LAST_MONAME\ | 1\. No Record\ | 8074 (47.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. July\ | 754 ( 4.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. August\ | 753 ( 4.5%)\ | | |
## | | | 4\. April\ | 749 ( 4.4%)\ | | |
## | | | 5\. March\ | 741 ( 4.4%)\ | | |
## | | | 6\. October\ | 722 ( 4.3%)\ | | |
## | | | 7\. January\ | 719 ( 4.3%)\ | | |
## | | | 8\. May\ | 705 ( 4.2%)\ | | |
## | | | 9\. September\ | 687 ( 4.1%)\ | | |
## | | | 10\. June\ | 685 ( 4.1%)\ | | |
## | | | 11\. December\ | 669 ( 4.0%)\ | | |
## | | | 12\. November\ | 637 ( 3.8%)\ | | |
## | | | 13\. February\ | 587 ( 3.5%)\ | | |
## | | | 14\. Unknown\ | 394 ( 2.3%)\ | | |
## | | | 15\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 85 | LAST_YRNAME\ | 1\. No Record\ | 8074 (47.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 2016\ | 2494 (14.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2015\ | 2087 (12.3%)\ | | |
## | | | 4\. 2014\ | 1283 ( 7.6%)\ | | |
## | | | 5\. 2017\ | 1165 ( 6.9%)\ | | |
## | | | 6\. 2013\ | 816 ( 4.8%)\ | | |
## | | | 7\. 2012\ | 456 ( 2.7%)\ | | |
## | | | 8\. Unknown\ | 393 ( 2.3%)\ | | |
## | | | 9\. 2011\ | 108 ( 0.6%)\ | | |
## | | | 10\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 86 | SPEEDRELNAME\ | 1\. No\ | 11725 (69.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes, Exceeded Speed Limit\ | 2023 (12.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Yes, Too Fast for Conditi\ | 1737 (10.3%)\ | | |
## | | | 4\. Unknown\ | 726 ( 4.3%)\ | | |
## | | | 5\. Yes, Specifics Unknown\ | 593 ( 3.5%)\ | | |
## | | | 6\. Yes, Racing\ | 72 ( 0.4%)\ | | |
## | | | 7\. No Driver Present/Unknown | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 87 | DR_SF2NAME\ | 1\. None\ | 14207 (84.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 574 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Operating the Vehicle in \ | 315 ( 1.9%)\ | | |
## | | | 4\. Overcorrecting\ | 250 ( 1.5%)\ | | |
## | | | 5\. Improper Lane Usage\ | 213 ( 1.3%)\ | | |
## | | | 6\. Failure to Obey Actual Tr\ | 180 ( 1.1%)\ | | |
## | | | 7\. Driving on Wrong Side of \ | 147 ( 0.9%)\ | | |
## | | | 8\. Non-Traffic Violation Cha\ | 126 ( 0.7%)\ | | |
## | | | 9\. Failure to Yield Right-of\ | 116 ( 0.7%)\ | | |
## | | | 10\. Careless Driving\ | 90 ( 0.5%)\ | | |
## | | | 11\. Improper or Erratic Lane \ | 75 ( 0.4%)\ | | |
## | | | 12\. Police Pursuing this Driv\ | 73 ( 0.4%)\ | | |
## | | | 13\. Ice, Snow, Slush, Water, \ | 62 ( 0.4%)\ | | |
## | | | 14\. Driver has not complied w\ | 54 ( 0.3%)\ | | |
## | | | 15\. Aggressive Driving / Road\ | 52 ( 0.3%)\ | | |
## | | | 16\. Driver Has Not Complied W\ | 40 ( 0.2%)\ | | |
## | | | 17\. Operating without Require\ | 40 ( 0.2%)\ | | |
## | | | 18\. Making Other Improper Tur\ | 33 ( 0.2%)\ | | |
## | | | 19\. Passing with Insufficient\ | 33 ( 0.2%)\ | | |
## | | | 20\. Passing where Prohibited \ | 32 ( 0.2%)\ | | |
## | | | 21\. Operator Inexperience\ | 29 ( 0.2%)\ | | |
## | | | 22\. Driver Has a Driving Reco\ | 19 ( 0.1%)\ | | |
## | | | 23\. Following Improperly\ | 16 ( 0.1%)\ | | |
## | | | 24\. Phantom Vehicle\ | 14 ( 0.1%)\ | | |
## | | | 25\. Driving Wrong Way on One-\ | 12 ( 0.1%)\ | | |
## | | | 26\. Passing on Right Side\ | 11 ( 0.1%)\ | | |
## | | | 27\. Vehicle in Road\ | 11 ( 0.1%)\ | | |
## | | | 28\. Alcohol and/or Drug Test \ | 10 ( 0.1%)\ | | |
## | | | 29\. Unfamiliar with Roadway\ | 10 ( 0.1%)\ | | |
## | | | 30\. Debris or Objects in Road\ | 6 ( 0.0%)\ | | |
## | | | 31\. Failing to Dim Lights or \ | 6 ( 0.0%)\ | | |
## | | | 32\. Stopped in Roadway (Vehic\ | 5 ( 0.0%)\ | | |
## | | | 33\. Traveling on Prohibited T\ | 5 ( 0.0%)\ | | |
## | | | 34\. Driving with Tire-Related\ | 4 ( 0.0%)\ | | |
## | | | 35\. Making Improper Entry to \ | 4 ( 0.0%)\ | | |
## | | | 36\. Tire Blowout or Flat\ | 4 ( 0.0%)\ | | |
## | | | 37\. Intentional Illegal Drivi\ | 3 ( 0.0%)\ | | |
## | | | 38\. Live Animals in Road\ | 3 ( 0.0%)\ | | |
## | | | 39\. Pedestrian, Pedal Cyclist\ | 3 ( 0.0%)\ | | |
## | | | 40\. Seat Back Not In Normal U\ | 3 ( 0.0%)\ | | |
## | | | 41\. Driving Less than Posted \ | 2 ( 0.0%)\ | | |
## | | | 42\. Overloading or Improper L\ | 2 ( 0.0%)\ | | |
## | | | 43\. Passing Through or Around\ | 2 ( 0.0%)\ | | |
## | | | 44\. Ruts, Holes, Bumps in Roa\ | 2 ( 0.0%)\ | | |
## | | | 45\. Failure to Observe Warnin\ | 1 ( 0.0%)\ | | |
## | | | 46\. Improper Management of Ve\ | 1 ( 0.0%)\ | | |
## | | | 47\. Mentally Challenged\ | 1 ( 0.0%)\ | | |
## | | | 48\. Police or Law Enforcement\ | 1 ( 0.0%)\ | | |
## | | | 49\. Reaction to or Failure to\ | 1 ( 0.0%)\ | | |
## | | | 50\. Slippery or Loose Surface | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 88 | DR_SF3NAME\ | 1\. None\ | 15775 (93.3%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 574 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Operating the Vehicle in \ | 90 ( 0.5%)\ | | |
## | | | 4\. Non-Traffic Violation Cha\ | 69 ( 0.4%)\ | | |
## | | | 5\. Overcorrecting\ | 58 ( 0.3%)\ | | |
## | | | 6\. Failure to Obey Actual Tr\ | 42 ( 0.2%)\ | | |
## | | | 7\. Police Pursuing this Driv\ | 35 ( 0.2%)\ | | |
## | | | 8\. Improper Lane Usage\ | 28 ( 0.2%)\ | | |
## | | | 9\. Driver Has Not Complied W\ | 25 ( 0.1%)\ | | |
## | | | 10\. Driving on Wrong Side of \ | 23 ( 0.1%)\ | | |
## | | | 11\. Operator Inexperience\ | 22 ( 0.1%)\ | | |
## | | | 12\. Aggressive Driving / Road\ | 21 ( 0.1%)\ | | |
## | | | 13\. Improper or Erratic Lane \ | 18 ( 0.1%)\ | | |
## | | | 14\. Driver has not complied w\ | 15 ( 0.1%)\ | | |
## | | | 15\. Failure to Yield Right-of\ | 10 ( 0.1%)\ | | |
## | | | 16\. Following Improperly\ | 9 ( 0.1%)\ | | |
## | | | 17\. Alcohol and/or Drug Test \ | 8 ( 0.0%)\ | | |
## | | | 18\. Ice, Snow, Slush, Water, \ | 8 ( 0.0%)\ | | |
## | | | 19\. Live Animals in Road\ | 8 ( 0.0%)\ | | |
## | | | 20\. Passing with Insufficient\ | 8 ( 0.0%)\ | | |
## | | | 21\. Making Other Improper Tur\ | 7 ( 0.0%)\ | | |
## | | | 22\. Phantom Vehicle\ | 7 ( 0.0%)\ | | |
## | | | 23\. Unfamiliar with Roadway\ | 6 ( 0.0%)\ | | |
## | | | 24\. Passing where Prohibited \ | 5 ( 0.0%)\ | | |
## | | | 25\. Careless Driving\ | 4 ( 0.0%)\ | | |
## | | | 26\. Driver Has a Driving Reco\ | 4 ( 0.0%)\ | | |
## | | | 27\. Driving Wrong Way on One-\ | 3 ( 0.0%)\ | | |
## | | | 28\. Failure to Observe Warnin\ | 3 ( 0.0%)\ | | |
## | | | 29\. Passing Through or Around\ | 3 ( 0.0%)\ | | |
## | | | 30\. Intentional Illegal Drivi\ | 2 ( 0.0%)\ | | |
## | | | 31\. Operating without Require\ | 2 ( 0.0%)\ | | |
## | | | 32\. Passing on Right Side\ | 2 ( 0.0%)\ | | |
## | | | 33\. Starting or Backing Impro\ | 2 ( 0.0%)\ | | |
## | | | 34\. Traveling on Prohibited T\ | 2 ( 0.0%)\ | | |
## | | | 35\. Vehicle in Road\ | 2 ( 0.0%)\ | | |
## | | | 36\. Driving with Tire-Related\ | 1 ( 0.0%)\ | | |
## | | | 37\. Failing to Dim Lights or \ | 1 ( 0.0%)\ | | |
## | | | 38\. Failure to Signal Intenti\ | 1 ( 0.0%)\ | | |
## | | | 39\. Ruts, Holes, Bumps in Roa | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 89 | DR_SF4NAME\ | 1\. None\ | 16205 (95.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Unknown\ | 574 ( 3.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Non-Traffic Violation Cha\ | 20 ( 0.1%)\ | | |
## | | | 4\. Careless Driving\ | 17 ( 0.1%)\ | | |
## | | | 5\. Operating the Vehicle in \ | 16 ( 0.1%)\ | | |
## | | | 6\. Failure to Obey Actual Tr\ | 13 ( 0.1%)\ | | |
## | | | 7\. Police Pursuing this Driv\ | 9 ( 0.1%)\ | | |
## | | | 8\. Ice, Snow, Slush, Water, \ | 7 ( 0.0%)\ | | |
## | | | 9\. Overcorrecting\ | 7 ( 0.0%)\ | | |
## | | | 10\. Driver has not complied w\ | 6 ( 0.0%)\ | | |
## | | | 11\. Overloading or Improper L\ | 6 ( 0.0%)\ | | |
## | | | 12\. Aggressive Driving / Road\ | 3 ( 0.0%)\ | | |
## | | | 13\. Driver Has Not Complied W\ | 2 ( 0.0%)\ | | |
## | | | 14\. Driving on Wrong Side of \ | 2 ( 0.0%)\ | | |
## | | | 15\. Failure to Yield Right-of\ | 2 ( 0.0%)\ | | |
## | | | 16\. Operating without Require\ | 2 ( 0.0%)\ | | |
## | | | 17\. Pedestrian, Pedal Cyclist\ | 2 ( 0.0%)\ | | |
## | | | 18\. Vehicle in Road\ | 2 ( 0.0%)\ | | |
## | | | 19\. Driver Has a Driving Reco\ | 1 ( 0.0%)\ | | |
## | | | 20\. Following Improperly\ | 1 ( 0.0%)\ | | |
## | | | 21\. Improper Management of Ve\ | 1 ( 0.0%)\ | | |
## | | | 22\. Improper or Erratic Lane \ | 1 ( 0.0%)\ | | |
## | | | 23\. Making Improper Entry to \ | 1 ( 0.0%)\ | | |
## | | | 24\. Operator Inexperience\ | 1 ( 0.0%)\ | | |
## | | | 25\. Passing where Prohibited \ | 1 ( 0.0%)\ | | |
## | | | 26\. Passing with Insufficient\ | 1 ( 0.0%)\ | | |
## | | | 27\. Unfamiliar with Roadway | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 90 | VTRAFWAYNAME\ | 1\. Two-Way, Not Divided\ | 9947 (58.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Two-Way, Divided, Positi\ | 2421 (14.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Two-Way, Divided, Unprote\ | 1623 ( 9.6%)\ | | |
## | | | 4\. Two-Way, Divided, Unprot\ | 1401 ( 8.3%)\ | | |
## | | | 5\. Two-Way, Not Divided With\ | 1027 ( 6.1%)\ | | |
## | | | 6\. Entrance/Exit Ramp\ | 232 ( 1.4%)\ | | |
## | | | 7\. One-Way Trafficway\ | 128 ( 0.8%)\ | | |
## | | | 8\. Non-Trafficway or Drivewa\ | 103 ( 0.6%)\ | | |
## | | | 9\. Not Reported\ | 15 ( 0.1%)\ | | |
## | | | 10\. Unknown | 7 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 91 | VNUM_LANNAME\ | 1\. Two lanes\ | 11008 (65.1%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Three lanes\ | 2028 (12.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Four lanes\ | 1767 (10.5%)\ | | |
## | | | 4\. Five lanes\ | 1206 ( 7.1%)\ | | |
## | | | 5\. Six lanes\ | 345 ( 2.0%)\ | | |
## | | | 6\. One lane\ | 194 ( 1.1%)\ | | |
## | | | 7\. Seven or more lanes\ | 193 ( 1.1%)\ | | |
## | | | 8\. Non-Trafficway or Drivewa\ | 103 ( 0.6%)\ | | |
## | | | 9\. Not Reported\ | 47 ( 0.3%)\ | | |
## | | | 10\. Unknown | 13 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 92 | VSPD_LIMNAME\ | 1\. 55 MPH\ | 4507 (26.7%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 45 MPH\ | 2372 (14.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. 35 MPH\ | 2040 (12.1%)\ | | |
## | | | 4\. 65 MPH\ | 1574 ( 9.3%)\ | | |
## | | | 5\. 40 MPH\ | 1195 ( 7.1%)\ | | |
## | | | 6\. 70 MPH\ | 1167 ( 6.9%)\ | | |
## | | | 7\. 50 MPH\ | 876 ( 5.2%)\ | | |
## | | | 8\. 30 MPH\ | 815 ( 4.8%)\ | | |
## | | | 9\. 25 MPH\ | 762 ( 4.5%)\ | | |
## | | | 10\. 60 MPH\ | 551 ( 3.3%)\ | | |
## | | | 11\. Not Reported\ | 338 ( 2.0%)\ | | |
## | | | 12\. 75 MPH\ | 316 ( 1.9%)\ | | |
## | | | 13\. No Statutory Limit/Non-Tr\ | 131 ( 0.8%)\ | | |
## | | | 14\. Unknown\ | 119 ( 0.7%)\ | | |
## | | | 15\. 80 MPH\ | 76 ( 0.4%)\ | | |
## | | | 16\. 20 MPH\ | 44 ( 0.3%)\ | | |
## | | | 17\. 15 MPH\ | 14 ( 0.1%)\ | | |
## | | | 18\. 5 MPH\ | 4 ( 0.0%)\ | | |
## | | | 19\. 10 MPH | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 93 | VALIGNNAME\ | 1\. Straight\ | 12243 (72.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Curve Left\ | 2052 (12.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Curve Right\ | 1775 (10.5%)\ | | |
## | | | 4\. Not Reported\ | 456 ( 2.7%)\ | | |
## | | | 5\. Curve - Unknown Direction\ | 262 ( 1.5%)\ | | |
## | | | 6\. Non-Trafficway or Drivewa\ | 103 ( 0.6%)\ | | |
## | | | 7\. Unknown | 13 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 94 | VPROFILENAME\ | 1\. Level\ | 10804 (63.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Grade, Unknown Slope\ | 1778 (10.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 1667 ( 9.9%)\ | | |
## | | | 4\. Downhill\ | 1233 ( 7.3%)\ | | |
## | | | 5\. Uphill\ | 830 ( 4.9%)\ | | |
## | | | 6\. Hillcrest\ | 417 ( 2.5%)\ | | |
## | | | 7\. Non-Trafficway or Drivewa\ | 103 ( 0.6%)\ | | |
## | | | 8\. Sag (Bottom)\ | 39 ( 0.2%)\ | | |
## | | | 9\. Unknown | 33 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 95 | VPAVETYPNAME\ | 1\. Blacktop, Bituminous, or \ | 12255 (72.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 2869 (17.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Concrete\ | 1411 ( 8.3%)\ | | |
## | | | 4\. Slag, Gravel or Stone\ | 137 ( 0.8%)\ | | |
## | | | 5\. Non-Trafficway or Drivewa\ | 103 ( 0.6%)\ | | |
## | | | 6\. Dirt\ | 101 ( 0.6%)\ | | |
## | | | 7\. Unknown\ | 15 ( 0.1%)\ | | |
## | | | 8\. Other\ | 8 ( 0.0%)\ | | |
## | | | 9\. Brick or Block | 5 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 96 | VSURCONDNAME\ | 1\. Dry\ | 14300 (84.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Wet\ | 1934 (11.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. Ice/Frost\ | 175 ( 1.0%)\ | | |
## | | | 4\. Snow\ | 144 ( 0.9%)\ | | |
## | | | 5\. Non-Trafficway or Drivewa\ | 103 ( 0.6%)\ | | |
## | | | 6\. Not Reported\ | 96 ( 0.6%)\ | | |
## | | | 7\. Mud, Dirt or Gravel\ | 46 ( 0.3%)\ | | |
## | | | 8\. Slush\ | 44 ( 0.3%)\ | | |
## | | | 9\. Unknown\ | 26 ( 0.2%)\ | | |
## | | | 10\. Water (Standing or Moving\ | 17 ( 0.1%)\ | | |
## | | | 11\. Other\ | 16 ( 0.1%)\ | | |
## | | | 12\. Oil\ | 2 ( 0.0%)\ | | |
## | | | 13\. Sand | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 97 | VTRAFCONNAME\ | 1\. No Controls\ | 13440 (79.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Traffic control signal(on\ | 1269 ( 7.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Stop Sign\ | 806 ( 4.8%)\ | | |
## | | | 4\. Traffic control signal (o\ | 480 ( 2.8%)\ | | |
## | | | 5\. Warning Sign\ | 317 ( 1.9%)\ | | |
## | | | 6\. Other Regulatory Sign\ | 176 ( 1.0%)\ | | |
## | | | 7\. Traffic control signal (o\ | 149 ( 0.9%)\ | | |
## | | | 8\. Other\ | 64 ( 0.4%)\ | | |
## | | | 9\. Flashing Traffic Control \ | 48 ( 0.3%)\ | | |
## | | | 10\. Not Reported\ | 44 ( 0.3%)\ | | |
## | | | 11\. Railway Crossing Device\ | 33 ( 0.2%)\ | | |
## | | | 12\. Unknown Regulatory Sign\ | 29 ( 0.2%)\ | | |
## | | | 13\. Yield Sign\ | 25 ( 0.1%)\ | | |
## | | | 14\. Unknown\ | 14 ( 0.1%)\ | | |
## | | | 15\. Person\ | 4 ( 0.0%)\ | | |
## | | | 16\. Other Highway Traffic Sig\ | 2 ( 0.0%)\ | | |
## | | | 17\. School Zone Sign/Device\ | 2 ( 0.0%)\ | | |
## | | | 18\. Lane Use Control Signal\ | 1 ( 0.0%)\ | | |
## | | | 19\. Unknown Highway Traffic S | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 98 | VTCONT_FNAME\ | 1\. No Controls\ | 13440 (79.5%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Device Functioning Proper\ | 3394 (20.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 44 ( 0.3%)\ | | |
## | | | 4\. Unknown\ | 16 ( 0.1%)\ | | |
## | | | 5\. Device Not Functioning\ | 7 ( 0.0%)\ | | |
## | | | 6\. Device Functioning-Functi | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 99 | P_CRASH1NAME\ | 1\. Going Straight\ | 10083 (59.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Negotiating a Curve\ | 3514 (20.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Turning Left\ | 1088 ( 6.4%)\ | | |
## | | | 4\. Stopped in Roadway\ | 568 ( 3.4%)\ | | |
## | | | 5\. Passing or Overtaking Ano\ | 422 ( 2.5%)\ | | |
## | | | 6\. Changing Lanes\ | 336 ( 2.0%)\ | | |
## | | | 7\. Decelerating in Road\ | 245 ( 1.4%)\ | | |
## | | | 8\. Turning Right\ | 135 ( 0.8%)\ | | |
## | | | 9\. Unknown\ | 87 ( 0.5%)\ | | |
## | | | 10\. Starting in Road\ | 68 ( 0.4%)\ | | |
## | | | 11\. Other(specify:)\ | 66 ( 0.4%)\ | | |
## | | | 12\. Accelerating in Road\ | 65 ( 0.4%)\ | | |
## | | | 13\. Making a U-turn\ | 63 ( 0.4%)\ | | |
## | | | 14\. Successful Avoidance Mane\ | 41 ( 0.2%)\ | | |
## | | | 15\. Backing Up (other than fo\ | 33 ( 0.2%)\ | | |
## | | | 16\. Merging\ | 28 ( 0.2%)\ | | |
## | | | 17\. No Driver Present / Unkno\ | 28 ( 0.2%)\ | | |
## | | | 18\. Disabled or ""Parked"" in\ | 26 ( 0.2%)\ | | |
## | | | 19\. Leaving a Parking Positio\ | 6 ( 0.0%)\ | | |
## | | | 20\. Entering a Parking Positi | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 100 | P_CRASH3NAME\ | 1\. Unknown/Not Reported\ | 9514 (56.3%)\ | 16904\ | 0\ |
## | | [factor] | 2\. No Avoidance Maneuver\ | 3822 (22.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Steering right\ | 954 ( 5.6%)\ | | |
## | | | 4\. Steering left\ | 900 ( 5.3%)\ | | |
## | | | 5\. Braking\ | 847 ( 5.0%)\ | | |
## | | | 6\. Braking and steering righ\ | 249 ( 1.5%)\ | | |
## | | | 7\. Braking and steering left\ | 223 ( 1.3%)\ | | |
## | | | 8\. Other actions (specify:)\ | 177 ( 1.0%)\ | | |
## | | | 9\. Braking and Unknown Steer\ | 111 ( 0.7%)\ | | |
## | | | 10\. Accelerating\ | 31 ( 0.2%)\ | | |
## | | | 11\. No Driver Present / Unkno\ | 28 ( 0.2%)\ | | |
## | | | 12\. Releasing brakes\ | 20 ( 0.1%)\ | | |
## | | | 13\. Accelerating and steering\ | 19 ( 0.1%)\ | | |
## | | | 14\. Accelerating and steering | 9 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 101 | PCRASH4NAME\ | 1\. Tracking\ | 11906 (70.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Precrash stability unknow\ | 1994 (11.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Skidding longitudinally \ | 1208 ( 7.1%)\ | | |
## | | | 4\. Skidding laterally counte\ | 865 ( 5.1%)\ | | |
## | | | 5\. Skidding laterally clockw\ | 689 ( 4.1%)\ | | |
## | | | 6\. Skidding Laterally, Rotat\ | 191 ( 1.1%)\ | | |
## | | | 7\. No Driver Present / Unkno\ | 28 ( 0.2%)\ | | |
## | | | 8\. Other vehicle loss-of-con | 23 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 102 | PCRASH5NAME\ | 1\. Stayed in original travel\ | 8524 (50.4%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Departed roadway\ | 5513 (32.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Stayed on roadway, but le\ | 2114 (12.5%)\ | | |
## | | | 4\. Stayed on roadway, not kn\ | 304 ( 1.8%)\ | | |
## | | | 5\. Returned to roadway\ | 223 ( 1.3%)\ | | |
## | | | 6\. Unknown\ | 70 ( 0.4%)\ | | |
## | | | 7\. Entered roadway\ | 69 ( 0.4%)\ | | |
## | | | 8\. Remained off roadway\ | 59 ( 0.3%)\ | | |
## | | | 9\. No Driver Present / Unkno | 28 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 103 | DEATHS\ | 1\. 1\ | 8886 (52.6%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 0\ | 6150 (36.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 1405 ( 8.3%)\ | | |
## | | | 4\. 3\ | 355 ( 2.1%)\ | | |
## | | | 5\. 4\ | 84 ( 0.5%)\ | | |
## | | | 6\. 13\ | 14 ( 0.1%)\ | | |
## | | | 7\. 5 | 10 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 104 | DR_DRINKNAME\ | 1\. No\ | 11807 (69.8%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Yes | 5097 (30.2%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 105 | TRLR2VINNAME\ | 1\. No Trailing Units\ | 16879 (99.9%)\ | 16904\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 10 ( 0.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3H3V281CXHT6\ | 2 ( 0.0%)\ | | |
## | | | 4\. 1BN1B1926WP0\ | 1 ( 0.0%)\ | | |
## | | | 5\. 1BN1B1929TP0\ | 1 ( 0.0%)\ | | |
## | | | 6\. 1GRAA56108K2\ | 1 ( 0.0%)\ | | |
## | | | 7\. 1GRAA56128K2\ | 1 ( 0.0%)\ | | |
## | | | 8\. 1GRAA5612EB7\ | 1 ( 0.0%)\ | | |
## | | | 9\. 1GRAA5618FD4\ | 1 ( 0.0%)\ | | |
## | | | 10\. 1GRAA72216B7\ | 1 ( 0.0%)\ | | |
## | | | 11\. 1KKVA45286L2\ | 1 ( 0.0%)\ | | |
## | | | 12\. 1R9BD2826N10\ | 1 ( 0.0%)\ | | |
## | | | 13\. 3H3V281C2BT0\ | 1 ( 0.0%)\ | | |
## | | | 14\. 558MRAK23JB0\ | 1 ( 0.0%)\ | | |
## | | | 15\. FRC187303\ | 1 ( 0.0%)\ | | |
## | | | 16\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 106 | TRLR3VINNAME\ | 1\. No Trailing Units\ | 16903 (100.0%)\ | 16904\ | 0\ |
## | | [factor] | 2\. 526172813C50 | 1 ( 0.0%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 107 | PREV_SUS1NAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 108 | PREV_SUS2NAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 109 | PREV_SUS3NAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 110 | VE_FORMS\ | 1\. 2\ | 7998 (47.4%)\ | 16889\ | 15\ |
## | | [factor] | 2\. 1\ | 5892 (34.9%)\ | (99.9%) | (0.1%) |
## | | | 3\. 3\ | 2006 (11.9%)\ | | |
## | | | 4\. 4\ | 574 ( 3.4%)\ | | |
## | | | 5\. 5\ | 263 ( 1.6%)\ | | |
## | | | 6\. 6\ | 100 ( 0.6%)\ | | |
## | | | 7\. 7\ | 19 ( 0.1%)\ | | |
## | | | 8\. 10\ | 14 ( 0.1%)\ | | |
## | | | 9\. 12\ | 12 ( 0.1%)\ | | |
## | | | 10\. 8 | 11 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 111 | PER_NO\ | 1\. 1\ | 10835 (64.2%)\ | 16889\ | 15\ |
## | | [factor] | 2\. 2\ | 3663 (21.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. 3\ | 1381 ( 8.2%)\ | | |
## | | | 4\. 4\ | 604 ( 3.6%)\ | | |
## | | | 5\. 5\ | 237 ( 1.4%)\ | | |
## | | | 6\. 6\ | 80 ( 0.5%)\ | | |
## | | | 7\. 7\ | 31 ( 0.2%)\ | | |
## | | | 8\. 8\ | 13 ( 0.1%)\ | | |
## | | | 9\. 9\ | 7 ( 0.0%)\ | | |
## | | | 10\. 10\ | 5 ( 0.0%)\ | | |
## | | | 11\. 11\ | 5 ( 0.0%)\ | | |
## | | | 12\. 12\ | 4 ( 0.0%)\ | | |
## | | | 13\. 13\ | 4 ( 0.0%)\ | | |
## | | | 14\. 14\ | 4 ( 0.0%)\ | | |
## | | | 15\. 15\ | 3 ( 0.0%)\ | | |
## | | | 16\. 16\ | 3 ( 0.0%)\ | | |
## | | | 17\. 17\ | 2 ( 0.0%)\ | | |
## | | | 18\. 18\ | 2 ( 0.0%)\ | | |
## | | | 19\. 19\ | 2 ( 0.0%)\ | | |
## | | | 20\. 20\ | 2 ( 0.0%)\ | | |
## | | | 21\. 21\ | 1 ( 0.0%)\ | | |
## | | | 22\. 22 | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 112 | STR_VEH\ | 1\. 0 | 16889 (100.0%) | 16889\ | 15\ |
## | | [factor] | | | (99.9%) | (0.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 113 | DAYNAME\ | 1\. 4\ | 646 (3.8%)\ | 16889\ | 15\ |
## | | [factor] | 2\. 24\ | 619 (3.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. 17\ | 610 (3.6%)\ | | |
## | | | 4\. 10\ | 598 (3.5%)\ | | |
## | | | 5\. 2\ | 597 (3.5%)\ | | |
## | | | 6\. 1\ | 593 (3.5%)\ | | |
## | | | 7\. 5\ | 583 (3.5%)\ | | |
## | | | 8\. 16\ | 576 (3.4%)\ | | |
## | | | 9\. 21\ | 575 (3.4%)\ | | |
## | | | 10\. 23\ | 574 (3.4%)\ | | |
## | | | 11\. 14\ | 567 (3.4%)\ | | |
## | | | 12\. 27\ | 565 (3.3%)\ | | |
## | | | 13\. 19\ | 564 (3.3%)\ | | |
## | | | 14\. 12\ | 563 (3.3%)\ | | |
## | | | 15\. 7\ | 561 (3.3%)\ | | |
## | | | 16\. 25\ | 548 (3.2%)\ | | |
## | | | 17\. 9\ | 545 (3.2%)\ | | |
## | | | 18\. 13\ | 541 (3.2%)\ | | |
## | | | 19\. 15\ | 537 (3.2%)\ | | |
## | | | 20\. 11\ | 535 (3.2%)\ | | |
## | | | 21\. 18\ | 532 (3.1%)\ | | |
## | | | 22\. 29\ | 531 (3.1%)\ | | |
## | | | 23\. 22\ | 528 (3.1%)\ | | |
## | | | 24\. 28\ | 516 (3.1%)\ | | |
## | | | 25\. 8\ | 515 (3.0%)\ | | |
## | | | 26\. 3\ | 514 (3.0%)\ | | |
## | | | 27\. 26\ | 502 (3.0%)\ | | |
## | | | 28\. 30\ | 496 (2.9%)\ | | |
## | | | 29\. 6\ | 493 (2.9%)\ | | |
## | | | 30\. 20\ | 467 (2.8%)\ | | |
## | | | 31\. 31 | 298 (1.8%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 114 | SEXNAME\ | 1\. Male\ | 11503 (68.1%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Female\ | 5272 (31.2%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown\ | 64 ( 0.4%)\ | | |
## | | | 4\. Not Reported | 50 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 115 | PER_TYPNAME\ | 1\. Driver of a Motor Vehicle\ | 10810 (64.0%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Passenger of a Motor Vehi\ | 6044 (35.8%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown Occupant Type in | 35 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 116 | INJ_SEVNAME\ | 1\. Fatal Injury (K)\ | 7519 (44.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. No Apparent Injury (O)\ | 3160 (18.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. Possible Injury (C)\ | 1496 ( 8.9%)\ | | |
## | | | 4\. Suspected Minor Injury (B\ | 1191 ( 7.1%)\ | | |
## | | | 5\. Suspected Serious Injury \ | 1189 ( 7.0%)\ | | |
## | | | 6\. Suspected Serious Injury(\ | 1089 ( 6.4%)\ | | |
## | | | 7\. Suspected Minor Injury(B)\ | 1043 ( 6.2%)\ | | |
## | | | 8\. Unknown/Not Reported\ | 183 ( 1.1%)\ | | |
## | | | 9\. Injured, Severity Unknown\ | 18 ( 0.1%)\ | | |
## | | | 10\. Died Prior to Crash* | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 117 | SEAT_POSNAME\ | 1\. Front Seat, Left Side\ | 10812 (64.0%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Front Seat, Right Side\ | 3147 (18.6%)\ | (99.9%) | (0.1%) |
## | | | 3\. Second Seat, Right Side\ | 984 ( 5.8%)\ | | |
## | | | 4\. Second Seat, Left Side\ | 977 ( 5.8%)\ | | |
## | | | 5\. Second Seat, Middle\ | 342 ( 2.0%)\ | | |
## | | | 6\. Unknown\ | 167 ( 1.0%)\ | | |
## | | | 7\. Other Passenger in enclos\ | 148 ( 0.9%)\ | | |
## | | | 8\. Front Seat, Middle\ | 46 ( 0.3%)\ | | |
## | | | 9\. Not Reported\ | 46 ( 0.3%)\ | | |
## | | | 10\. Third Seat, Right Side\ | 40 ( 0.2%)\ | | |
## | | | 11\. Second Seat, Unknown\ | 37 ( 0.2%)\ | | |
## | | | 12\. Third Seat, Left Side\ | 37 ( 0.2%)\ | | |
## | | | 13\. Riding on Exterior of Veh\ | 21 ( 0.1%)\ | | |
## | | | 14\. Third Seat, Middle\ | 19 ( 0.1%)\ | | |
## | | | 15\. Other Passenger in unencl\ | 18 ( 0.1%)\ | | |
## | | | 16\. Sleeper Section of Cab (T\ | 14 ( 0.1%)\ | | |
## | | | 17\. Front Seat, Unknown\ | 9 ( 0.1%)\ | | |
## | | | 18\. Second Seat, Other\ | 7 ( 0.0%)\ | | |
## | | | 19\. Trailing Unit\ | 6 ( 0.0%)\ | | |
## | | | 20\. Other Passenger in passen\ | 4 ( 0.0%)\ | | |
## | | | 21\. Front Seat, Other\ | 3 ( 0.0%)\ | | |
## | | | 22\. Third Seat, Unknown\ | 3 ( 0.0%)\ | | |
## | | | 23\. Fourth Seat, Left Side\ | 1 ( 0.0%)\ | | |
## | | | 24\. Third Seat, Other | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 118 | REST_USENAME\ | 1\. Shoulder and Lap Belt Use\ | 8374 (49.6%)\ | 16889\ | 15\ |
## | | [factor] | 2\. None Used / Not Applicabl\ | 2401 (14.2%)\ | (99.9%) | (0.1%) |
## | | | 3\. None Used\ | 2186 (12.9%)\ | | |
## | | | 4\. Unknown\ | 1432 ( 8.5%)\ | | |
## | | | 5\. No Helmet\ | 583 ( 3.5%)\ | | |
## | | | 6\. Helmet, Unknown if DOT Co\ | 480 ( 2.8%)\ | | |
## | | | 7\. DOT-Compliant Motorcycle \ | 368 ( 2.2%)\ | | |
## | | | 8\. Restraint Used - Type Unk\ | 214 ( 1.3%)\ | | |
## | | | 9\. Not Reported\ | 149 ( 0.9%)\ | | |
## | | | 10\. Child Restraint Type Unkn\ | 148 ( 0.9%)\ | | |
## | | | 11\. Child Restraint System - \ | 142 ( 0.8%)\ | | |
## | | | 12\. Lap Belt Only Used\ | 115 ( 0.7%)\ | | |
## | | | 13\. Not Applicable\ | 59 ( 0.3%)\ | | |
## | | | 14\. Booster Seat\ | 57 ( 0.3%)\ | | |
## | | | 15\. Helmet, Other than DOT-Co\ | 56 ( 0.3%)\ | | |
## | | | 16\. Child Restraint System -\ | 43 ( 0.3%)\ | | |
## | | | 17\. Shoulder Belt Only Used\ | 37 ( 0.2%)\ | | |
## | | | 18\. Unknown if Helmet Worn\ | 34 ( 0.2%)\ | | |
## | | | 19\. Other | 11 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 119 | REST_MISNAME\ | 1\. No\ | 16803 (99.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Yes | 86 ( 0.5%) | (99.9%) | (0.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 120 | AIR_BAGNAME\ | 1\. Not Deployed\ | 6703 (39.7%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Deployed- Front\ | 3868 (22.9%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Applicable\ | 1924 (11.4%)\ | | |
## | | | 4\. Deployed- Combination\ | 1888 (11.2%)\ | | |
## | | | 5\. Deployment- Unknown Locat\ | 1155 ( 6.8%)\ | | |
## | | | 6\. Deployment Unknown\ | 644 ( 3.8%)\ | | |
## | | | 7\. Deployed- Side (door, sea\ | 315 ( 1.9%)\ | | |
## | | | 8\. Not Reported\ | 273 ( 1.6%)\ | | |
## | | | 9\. Deployed- Curtain (roof)\ | 99 ( 0.6%)\ | | |
## | | | 10\. Deployed- Other (Knee, ai\ | 19 ( 0.1%)\ | | |
## | | | 11\. Switched Off | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 121 | EJECTIONNAME\ | 1\. Not Ejected\ | 13242 (78.4%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Totally Ejected\ | 1607 ( 9.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Applicable\ | 1499 ( 8.9%)\ | | |
## | | | 4\. Partially Ejected\ | 390 ( 2.3%)\ | | |
## | | | 5\. Unknown if Ejected\ | 71 ( 0.4%)\ | | |
## | | | 6\. Not Reported\ | 53 ( 0.3%)\ | | |
## | | | 7\. Ejected - Unknown Degree | 27 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 122 | EJ_PATHNAME\ | 1\. Ejection Path Not Applica\ | 14865 (88.0%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Ejection Path Unknown\ | 1441 ( 8.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Through Side Window\ | 280 ( 1.7%)\ | | |
## | | | 4\. Through Side Door Opening\ | 107 ( 0.6%)\ | | |
## | | | 5\. Other Path (e.g., back of\ | 56 ( 0.3%)\ | | |
## | | | 6\. Through Back Window\ | 49 ( 0.3%)\ | | |
## | | | 7\. Through Windshield\ | 48 ( 0.3%)\ | | |
## | | | 8\. Through Roof Opening (sun\ | 36 ( 0.2%)\ | | |
## | | | 9\. Through roof (convertible\ | 4 ( 0.0%)\ | | |
## | | | 10\. Through Back Door/Tailgat | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 123 | EXTRICATNAME\ | 1\. Not Extricated or Not App\ | 14334 (84.9%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Extricated\ | 2337 (13.8%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown | 218 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 124 | DRINKINGNAME\ | 1\. No (Alcohol Not Involved)\ | 6388 (37.8%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Not Reported\ | 6075 (36.0%)\ | (99.9%) | (0.1%) |
## | | | 3\. Yes (Alcohol Involved)\ | 2471 (14.6%)\ | | |
## | | | 4\. Unknown (Police Reported) | 1955 (11.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 125 | ALC_DETNAME\ | 1\. Not Reported\ | 12787 (75.7%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Evidential Test (breath, \ | 2692 (15.9%)\ | (99.9%) | (0.1%) |
## | | | 3\. Observed\ | 1109 ( 6.6%)\ | | |
## | | | 4\. Preliminary Breath Test (\ | 158 ( 0.9%)\ | | |
## | | | 5\. Behavioral\ | 93 ( 0.6%)\ | | |
## | | | 6\. Other (e.g., Saliva test)\ | 25 ( 0.1%)\ | | |
## | | | 7\. Passive Alcohol Sensor (P | 25 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 126 | ALC_STATUSNAME\ | 1\. Test Given\ | 9144 (54.1%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Test Not Given\ | 7335 (43.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 331 ( 2.0%)\ | | |
## | | | 4\. UnKnown if Tested\ | 75 ( 0.4%)\ | | |
## | | | 5\. Test Refused | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 127 | ATST_TYPNAME\ | 1\. Blood\ | 8655 (51.2%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Test Not Given\ | 7339 (43.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 362 ( 2.1%)\ | | |
## | | | 4\. Preliminary Breath Test (\ | 177 ( 1.0%)\ | | |
## | | | 5\. Urine\ | 79 ( 0.5%)\ | | |
## | | | 6\. Unknown if Tested\ | 75 ( 0.4%)\ | | |
## | | | 7\. Vitreous\ | 60 ( 0.4%)\ | | |
## | | | 8\. Breath Test (AC)\ | 56 ( 0.3%)\ | | |
## | | | 9\. Unknown Test Type\ | 44 ( 0.3%)\ | | |
## | | | 10\. Other Test Type\ | 20 ( 0.1%)\ | | |
## | | | 11\. Blood Plasma/Serum\ | 11 ( 0.1%)\ | | |
## | | | 12\. Liver\ | 10 ( 0.1%)\ | | |
## | | | 13\. Blood Clot | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 128 | DRUGSNAME\ | 1\. Not Reported\ | 6946 (41.1%)\ | 16889\ | 15\ |
## | | [factor] | 2\. No (drugs not involved)\ | 5285 (31.3%)\ | (99.9%) | (0.1%) |
## | | | 3\. Yes (drugs involved)\ | 2865 (17.0%)\ | | |
## | | | 4\. Unknown | 1793 (10.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 129 | DRUG_DETNAME\ | 1\. Not Reported\ | 13276 (78.6%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Evidential Test (Blood, U\ | 2550 (15.1%)\ | (99.9%) | (0.1%) |
## | | | 3\. Other\ | 892 ( 5.3%)\ | | |
## | | | 4\. Behavioral\ | 114 ( 0.7%)\ | | |
## | | | 5\. Drug Recognition Expert ( | 57 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 130 | DSTATUSNAME\ | 1\. Test Given\ | 9017 (53.4%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Test Not Given\ | 7362 (43.6%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 439 ( 2.6%)\ | | |
## | | | 4\. Unknown if Tested\ | 67 ( 0.4%)\ | | |
## | | | 5\. Test Refused | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 131 | DRUGTST1NAME\ | 1\. Blood\ | 8044 (47.6%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Test Not Given\ | 7366 (43.6%)\ | (99.9%) | (0.1%) |
## | | | 3\. Not Reported\ | 523 ( 3.1%)\ | | |
## | | | 4\. Both: Blood and Urine Tes\ | 440 ( 2.6%)\ | | |
## | | | 5\. Urine\ | 341 ( 2.0%)\ | | |
## | | | 6\. Unknown if Tested\ | 67 ( 0.4%)\ | | |
## | | | 7\. Other Test Type\ | 54 ( 0.3%)\ | | |
## | | | 8\. Unknown Test Type | 54 ( 0.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 132 | DRUGTST2NAME\ | 1\. Test Not Given\ | 12399 (73.4%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Blood\ | 3968 (23.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Both: Blood and Urine Tes\ | 271 ( 1.6%)\ | | |
## | | | 4\. Urine\ | 184 ( 1.1%)\ | | |
## | | | 5\. Not Reported\ | 33 ( 0.2%)\ | | |
## | | | 6\. Other Test Type\ | 21 ( 0.1%)\ | | |
## | | | 7\. Unknown Test Type | 13 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 133 | DRUGTST3NAME\ | 1\. Test Not Given\ | 14807 (87.7%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Blood\ | 1824 (10.8%)\ | (99.9%) | (0.1%) |
## | | | 3\. Both: Blood and Urine Tes\ | 121 ( 0.7%)\ | | |
## | | | 4\. Urine\ | 111 ( 0.7%)\ | | |
## | | | 5\. Not Reported\ | 15 ( 0.1%)\ | | |
## | | | 6\. Other Test Type\ | 7 ( 0.0%)\ | | |
## | | | 7\. Unknown Test Type | 4 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 134 | DRUGRES3NAME\ | 1\. Test Not Given\ | 14814 (87.7%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Tetrahydrocannabinols (TH\ | 725 ( 4.3%)\ | (99.9%) | (0.1%) |
## | | | 3\. DELTA 9\ | 352 ( 2.1%)\ | | |
## | | | 4\. Other Drug\ | 333 ( 2.0%)\ | | |
## | | | 5\. ""Cannabinoid, Type Unkno\ | 183 ( 1.1%)\ | | |
## | | | 6\. METHAMPHETAMINE\ | 62 ( 0.4%)\ | | |
## | | | 7\. MARIJUANA/Marihuana\ | 51 ( 0.3%)\ | | |
## | | | 8\. AMPHETAMINE\ | 42 ( 0.2%)\ | | |
## | | | 9\. BENZOYLECGONINE\ | 36 ( 0.2%)\ | | |
## | | | 10\. ALPRAZOLAM\ | 25 ( 0.1%)\ | | |
## | | | 11\. COCAINE\ | 22 ( 0.1%)\ | | |
## | | | 12\. HYDROCODONE\ | 21 ( 0.1%)\ | | |
## | | | 13\. OXYCODONE\ | 20 ( 0.1%)\ | | |
## | | | 14\. BENZODIAZEPINES\ | 17 ( 0.1%)\ | | |
## | | | 15\. FENTANYL\ | 17 ( 0.1%)\ | | |
## | | | 16\. Tested For Drugs, Drugs F\ | 14 ( 0.1%)\ | | |
## | | | 17\. Midazolam\ | 13 ( 0.1%)\ | | |
## | | | 18\. MORPHINE\ | 13 ( 0.1%)\ | | |
## | | | 19\. DIAZEPAM\ | 12 ( 0.1%)\ | | |
## | | | 20\. Nordiazepam\ | 12 ( 0.1%)\ | | |
## | | | 21\. PHENCYCLIDINE\ | 11 ( 0.1%)\ | | |
## | | | 22\. Ketamine\ | 9 ( 0.1%)\ | | |
## | | | 23\. Clonazepam\ | 8 ( 0.0%)\ | | |
## | | | 24\. Buprenorphine\ | 7 ( 0.0%)\ | | |
## | | | 25\. METHADONE\ | 7 ( 0.0%)\ | | |
## | | | 26\. CODEINE\ | 6 ( 0.0%)\ | | |
## | | | 27\. OPIUM\ | 6 ( 0.0%)\ | | |
## | | | 28\. ""Stimulants, Type Unknow\ | 5 ( 0.0%)\ | | |
## | | | 29\. HYDROMORPHONE\ | 5 ( 0.0%)\ | | |
## | | | 30\. LORAZEPAM\ | 5 ( 0.0%)\ | | |
## | | | 31\. ""Depressants, Type Unkno\ | 4 ( 0.0%)\ | | |
## | | | 32\. Ecgonine\ | 4 ( 0.0%)\ | | |
## | | | 33\. PHENTERMINE\ | 4 ( 0.0%)\ | | |
## | | | 34\. Methylenedioxyamphetamine\ | 3 ( 0.0%)\ | | |
## | | | 35\. Tested, No Drugs Found/Ne\ | 3 ( 0.0%)\ | | |
## | | | 36\. DIHYDROCODEINE\ | 2 ( 0.0%)\ | | |
## | | | 37\. Heroin (Diacetylmorphine)\ | 2 ( 0.0%)\ | | |
## | | | 38\. Methylenedioxymethampheta\ | 2 ( 0.0%)\ | | |
## | | | 39\. OXAZEPAM\ | 2 ( 0.0%)\ | | |
## | | | 40\. Oxymorphone\ | 2 ( 0.0%)\ | | |
## | | | 41\. Chlorphentermine\ | 1 ( 0.0%)\ | | |
## | | | 42\. MEPROBAMATE\ | 1 ( 0.0%)\ | | |
## | | | 43\. Nabilone\ | 1 ( 0.0%)\ | | |
## | | | 44\. Not Reported\ | 1 ( 0.0%)\ | | |
## | | | 45\. Opium extract\ | 1 ( 0.0%)\ | | |
## | | | 46\. Pregabalin\ | 1 ( 0.0%)\ | | |
## | | | 47\. Stimulant compounds previ\ | 1 ( 0.0%)\ | | |
## | | | 48\. Zolpidem | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 135 | HOSPITALNAME\ | 1\. Not Transported\ | 9001 (53.3%)\ | 16889\ | 15\ |
## | | [factor] | 2\. EMS Ground\ | 6531 (38.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. EMS Air\ | 702 ( 4.2%)\ | | |
## | | | 4\. EMS Unknown Mode\ | 191 ( 1.1%)\ | | |
## | | | 5\. Other\ | 153 ( 0.9%)\ | | |
## | | | 6\. Not Reported\ | 132 ( 0.8%)\ | | |
## | | | 7\. Law Enforcement\ | 69 ( 0.4%)\ | | |
## | | | 8\. Transported Unknown Sour\ | 68 ( 0.4%)\ | | |
## | | | 9\. Unknown | 42 ( 0.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 136 | DOANAME\ | 1\. Not Applicable\ | 11724 (69.4%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Died at Scene\ | 5084 (30.1%)\ | (99.9%) | (0.1%) |
## | | | 3\. Died En Route\ | 80 ( 0.5%)\ | | |
## | | | 4\. Unknown | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 137 | DEATH_DANAME\ | 1\. Not Applicable (Non-Fatal\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. 4\ | 294 ( 1.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. 23\ | 266 ( 1.6%)\ | | |
## | | | 4\. 5\ | 266 ( 1.6%)\ | | |
## | | | 5\. 2\ | 265 ( 1.6%)\ | | |
## | | | 6\. 13\ | 263 ( 1.6%)\ | | |
## | | | 7\. 10\ | 262 ( 1.6%)\ | | |
## | | | 8\. 16\ | 262 ( 1.6%)\ | | |
## | | | 9\. 19\ | 256 ( 1.5%)\ | | |
## | | | 10\. 29\ | 256 ( 1.5%)\ | | |
## | | | 11\. 1\ | 255 ( 1.5%)\ | | |
## | | | 12\. 14\ | 255 ( 1.5%)\ | | |
## | | | 13\. 24\ | 254 ( 1.5%)\ | | |
## | | | 14\. 17\ | 253 ( 1.5%)\ | | |
## | | | 15\. 27\ | 249 ( 1.5%)\ | | |
## | | | 16\. 26\ | 244 ( 1.4%)\ | | |
## | | | 17\. 9\ | 244 ( 1.4%)\ | | |
## | | | 18\. 18\ | 243 ( 1.4%)\ | | |
## | | | 19\. 12\ | 242 ( 1.4%)\ | | |
## | | | 20\. 6\ | 242 ( 1.4%)\ | | |
## | | | 21\. 15\ | 232 ( 1.4%)\ | | |
## | | | 22\. 22\ | 232 ( 1.4%)\ | | |
## | | | 23\. 25\ | 232 ( 1.4%)\ | | |
## | | | 24\. 8\ | 232 ( 1.4%)\ | | |
## | | | 25\. 11\ | 231 ( 1.4%)\ | | |
## | | | 26\. 21\ | 231 ( 1.4%)\ | | |
## | | | 27\. 28\ | 231 ( 1.4%)\ | | |
## | | | 28\. 7\ | 231 ( 1.4%)\ | | |
## | | | 29\. 3\ | 228 ( 1.3%)\ | | |
## | | | 30\. 30\ | 222 ( 1.3%)\ | | |
## | | | 31\. 20\ | 214 ( 1.3%)\ | | |
## | | | 32\. 31\ | 129 ( 0.8%)\ | | |
## | | | 33\. Unknown | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 138 | DEATH_MONAME\ | 1\. Not Applicable (Non-Fatal\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. July\ | 744 ( 4.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. August\ | 700 ( 4.1%)\ | | |
## | | | 4\. May\ | 694 ( 4.1%)\ | | |
## | | | 5\. October\ | 671 ( 4.0%)\ | | |
## | | | 6\. June\ | 645 ( 3.8%)\ | | |
## | | | 7\. April\ | 638 ( 3.8%)\ | | |
## | | | 8\. November\ | 630 ( 3.7%)\ | | |
## | | | 9\. September\ | 619 ( 3.7%)\ | | |
## | | | 10\. March\ | 593 ( 3.5%)\ | | |
## | | | 11\. January\ | 543 ( 3.2%)\ | | |
## | | | 12\. December\ | 531 ( 3.1%)\ | | |
## | | | 13\. February\ | 509 ( 3.0%)\ | | |
## | | | 14\. Unknown | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 139 | DEATH_YRNAME\ | 1\. Not Applicable (Non-fatal\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. 2017\ | 3838 (22.7%)\ | (99.9%) | (0.1%) |
## | | | 3\. 2016\ | 3678 (21.8%)\ | | |
## | | | 4\. 2018 | 3 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 140 | DEATH_HRNAME\ | 1\. Not Applicable (Non-fatal\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. 23:00-23:59\ | 408 ( 2.4%)\ | (99.9%) | (0.1%) |
## | | | 3\. 19:00-19:59\ | 390 ( 2.3%)\ | | |
## | | | 4\. 0:00-0:59\ | 380 ( 2.2%)\ | | |
## | | | 5\. 18:00-18:59\ | 378 ( 2.2%)\ | | |
## | | | 6\. 20:00-20:59\ | 374 ( 2.2%)\ | | |
## | | | 7\. 3:00-3:59\ | 363 ( 2.1%)\ | | |
## | | | 8\. 16:00-16:59\ | 359 ( 2.1%)\ | | |
## | | | 9\. 2:00-2:59\ | 357 ( 2.1%)\ | | |
## | | | 10\. 17:00-17:59\ | 356 ( 2.1%)\ | | |
## | | | 11\. 22:00-22:59\ | 356 ( 2.1%)\ | | |
## | | | 12\. 1:00-1:59\ | 347 ( 2.1%)\ | | |
## | | | 13\. 21:00-21:59\ | 346 ( 2.0%)\ | | |
## | | | 14\. 15:00-15:59\ | 314 ( 1.9%)\ | | |
## | | | 15\. Unknown\ | 298 ( 1.8%)\ | | |
## | | | 16\. 14:00-14:59\ | 297 ( 1.8%)\ | | |
## | | | 17\. 13:00-13:59\ | 288 ( 1.7%)\ | | |
## | | | 18\. 12:00-12:59\ | 274 ( 1.6%)\ | | |
## | | | 19\. 5:00-5:59\ | 239 ( 1.4%)\ | | |
## | | | 20\. 7:00-7:59\ | 232 ( 1.4%)\ | | |
## | | | 21\. 4:00-4:59\ | 224 ( 1.3%)\ | | |
## | | | 22\. 6:00-6:59\ | 223 ( 1.3%)\ | | |
## | | | 23\. 11:00-11:59\ | 196 ( 1.2%)\ | | |
## | | | 24\. 8:00-8:59\ | 181 ( 1.1%)\ | | |
## | | | 25\. 10:00-10:59\ | 170 ( 1.0%)\ | | |
## | | | 26\. 9:00-9:59 | 169 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 141 | P_SF1NAME\ | 1\. None\ | 16822 (99.6%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Unknown\ | 24 ( 0.1%)\ | (99.9%) | (0.1%) |
## | | | 3\. Interfering With Driver\ | 16 ( 0.1%)\ | | |
## | | | 4\. Non-Driver Flees Scene\ | 14 ( 0.1%)\ | | |
## | | | 5\. Emergency Services Person\ | 6 ( 0.0%)\ | | |
## | | | 6\. Mother of Dead Fetus/Infa\ | 3 ( 0.0%)\ | | |
## | | | 7\. Police or Law Enforcement\ | 2 ( 0.0%)\ | | |
## | | | 8\. Opening Vehicle Closure i\ | 1 ( 0.0%)\ | | |
## | | | 9\. Seat Back Not in Normal U | 1 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 142 | P_SF2NAME\ | 1\. None\ | 16865 (99.9%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Unknown | 24 ( 0.1%) | (99.9%) | (0.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 143 | P_SF3NAME\ | 1\. None\ | 16865 (99.9%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Unknown | 24 ( 0.1%) | (99.9%) | (0.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 144 | WORK_INJNAME\ | 1\. Not Applicable (not a fat\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. No\ | 7147 (42.3%)\ | (99.9%) | (0.1%) |
## | | | 3\. Unknown\ | 270 ( 1.6%)\ | | |
## | | | 4\. Yes | 102 ( 0.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 145 | HISPANICNAME\ | 1\. Not A Fatality (not Appli\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. Non-Hispanic\ | 6157 (36.5%)\ | (99.9%) | (0.1%) |
## | | | 3\. Mexican\ | 451 ( 2.7%)\ | | |
## | | | 4\. Hispanic, Origin Not Spec\ | 371 ( 2.2%)\ | | |
## | | | 5\. Unknown\ | 360 ( 2.1%)\ | | |
## | | | 6\. Puerto Rican\ | 75 ( 0.4%)\ | | |
## | | | 7\. Central or South American\ | 49 ( 0.3%)\ | | |
## | | | 8\. European Spanish\ | 39 ( 0.2%)\ | | |
## | | | 9\. Cuban | 17 ( 0.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 146 | RACENAME\ | 1\. Not a Fatality (not Appli\ | 9370 (55.5%)\ | 16889\ | 15\ |
## | | [factor] | 2\. White\ | 5416 (32.1%)\ | (99.9%) | (0.1%) |
## | | | 3\. Black\ | 1478 ( 8.8%)\ | | |
## | | | 4\. Unknown\ | 233 ( 1.4%)\ | | |
## | | | 5\. All other races\ | 82 ( 0.5%)\ | | |
## | | | 6\. American Indian (includes\ | 76 ( 0.4%)\ | | |
## | | | 7\. American Indian (includes\ | 57 ( 0.3%)\ | | |
## | | | 8\. Multiple Races (individua\ | 35 ( 0.2%)\ | | |
## | | | 9\. Hawaiian (includes Part-H\ | 27 ( 0.2%)\ | | |
## | | | 10\. Filipino\ | 24 ( 0.1%)\ | | |
## | | | 11\. Asian Indian\ | 20 ( 0.1%)\ | | |
## | | | 12\. Other Indian (includes So\ | 17 ( 0.1%)\ | | |
## | | | 13\. Other Asian or Pacific Is\ | 16 ( 0.1%)\ | | |
## | | | 14\. Asian or Pacific Islander\ | 9 ( 0.1%)\ | | |
## | | | 15\. Japanese\ | 8 ( 0.0%)\ | | |
## | | | 16\. Chinese\ | 7 ( 0.0%)\ | | |
## | | | 17\. Vietnamese\ | 5 ( 0.0%)\ | | |
## | | | 18\. Korean\ | 4 ( 0.0%)\ | | |
## | | | 19\. Guamanian\ | 3 ( 0.0%)\ | | |
## | | | 20\. Samoan | 2 ( 0.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 147 | LOCATIONNAME\ | 1\. Occupant of a Motor Vehic | 16889 (100.0%) | 16889\ | 15\ |
## | | [factor] | | | (99.9%) | (0.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 148 | HELM_USENAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 149 | HELM_MISNAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 150 | VPICMAKENAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 151 | VPICMODEL\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 152 | VPICMODELNAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 153 | VPICBODYCLASSNAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+----------+
## | 154 | ICFINALBODYNAME\ | No levels defined | All NA's | 0\ | 16904\ |
## | | [factor] | | | (0.0%) | (100.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] 16904 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
)