library(dplyr)
library(summarytools)
library(fst)
library(DT)
dat= read.fst("2016_2023_FARS_Crash_Veh_Pers_Lim_norepFin.fst")
dim(dat)
## [1] 713485 194
## [1] "CRASH_NUM1" "STATE" "STATENAME"
## [4] "ST_CASE" "VE_TOTAL" "COUNTY"
## [7] "COUNTYNAME" "CITY" "CITYNAME"
## [10] "DAY" "MONTH" "MONTHNAME"
## [13] "YEAR" "DAY_WEEKNAME" "HOUR"
## [16] "HOURNAME" "NHSNAME" "ROUTENAME"
## [19] "TWAY_ID" "TWAY_ID2" "RUR_URBNAME"
## [22] "FUNC_SYSNAME" "RD_OWNERNAME" "LATITUDE"
## [25] "LATITUDENAME" "LONGITUD" "LONGITUDNAME"
## [28] "SP_JURNAME" "HARM_EVNAME" "MAN_COLLNAME"
## [31] "RELJCT1NAME" "RELJCT2NAME" "TYP_INTNAME"
## [34] "WRK_ZONENAME" "REL_ROADNAME" "LGT_CONDNAME"
## [37] "WEATHER1NAME" "WEATHER2NAME" "WEATHERNAME"
## [40] "SCH_BUSNAME" "RAILNAME" "NOT_HOURNAME"
## [43] "ARR_HOUR" "ARR_HOURNAME" "ARR_MIN"
## [46] "ARR_MINNAME" "HOSP_HR" "HOSP_HRNAME"
## [49] "CF1NAME" "CF2NAME" "CF3NAME"
## [52] "FATALS" "DRUNK_DR" "VEH_NO"
## [55] "CRASH_VEH_NUM1" "NUMOCCS" "UNITTYPENAME"
## [58] "HIT_RUNNAME" "REG_STATNAME" "OWNERNAME"
## [61] "MAKENAME" "MAK_MODNAME" "BODY_TYPNAME"
## [64] "MOD_YEAR" "VINNAME" "TOW_VEHNAME"
## [67] "J_KNIFENAME" "MCARR_I1NAME" "MCARR_I2NAME"
## [70] "MCARR_IDNAME" "GVWRNAME" "V_CONFIGNAME"
## [73] "CARGO_BTNAME" "HAZ_INVNAME" "HAZ_PLACNAME"
## [76] "HAZ_IDNAME" "HAZ_CNONAME" "HAZ_RELNAME"
## [79] "BUS_USENAME" "SPEC_USENAME" "EMER_USENAME"
## [82] "TRAV_SPNAME" "UNDERIDENAME" "ROLLOVERNAME"
## [85] "ROLINLOCNAME" "IMPACT1NAME" "DEFORMEDNAME"
## [88] "TOWEDNAME" "M_HARMNAME" "VEH_SC1NAME"
## [91] "VEH_SC2NAME" "FIRE_EXPNAME" "DR_PRESNAME"
## [94] "L_STATENAME" "DR_ZIPNAME" "L_STATUSNAME"
## [97] "L_TYPENAME" "CDL_STATNAME" "L_ENDORSNAME"
## [100] "L_COMPLNAME" "L_RESTRINAME" "DR_HGT"
## [103] "DR_WGTNAME" "PREV_ACCNAME" "PREV_SUSNAME"
## [106] "PREV_DWINAME" "PREV_SPDNAME" "PREV_OTHNAME"
## [109] "FIRST_MONAME" "FIRST_YRNAME" "LAST_MONAME"
## [112] "LAST_YRNAME" "SPEEDRELNAME" "DR_SF1NAME"
## [115] "DR_SF2NAME" "DR_SF3NAME" "DR_SF4NAME"
## [118] "VTRAFWAYNAME" "VNUM_LANNAME" "VSPD_LIMNAME"
## [121] "VALIGNNAME" "VPROFILENAME" "VPAVETYPNAME"
## [124] "VSURCONDNAME" "VTRAFCONNAME" "VTCONT_FNAME"
## [127] "P_CRASH1NAME" "P_CRASH2NAME" "P_CRASH3NAME"
## [130] "PCRASH4NAME" "PCRASH5NAME" "ACC_TYPENAME"
## [133] "DEATHS" "DR_DRINKNAME" "TRLR1VINNAME"
## [136] "TRLR2VINNAME" "TRLR3VINNAME" "PREV_SUS1NAME"
## [139] "PREV_SUS2NAME" "PREV_SUS3NAME" "CRASH_VehPer_NUM1"
## [142] "PER_NO" "STR_VEH" "MAK_MOD"
## [145] "MOD_YEARNAME" "AGENAME" "SEXNAME"
## [148] "PER_TYPNAME" "INJ_SEVNAME" "SEAT_POSNAME"
## [151] "REST_USENAME" "REST_MISNAME" "AIR_BAGNAME"
## [154] "EJECTIONNAME" "EJ_PATHNAME" "EXTRICATNAME"
## [157] "DRINKINGNAME" "ALC_DETNAME" "ALC_STATUSNAME"
## [160] "ATST_TYPNAME" "ALC_RESNAME" "DRUGSNAME"
## [163] "DRUG_DETNAME" "DSTATUSNAME" "DRUGTST1NAME"
## [166] "DRUGTST2NAME" "DRUGTST3NAME" "DRUGRES1NAME"
## [169] "DRUGRES2NAME" "DRUGRES3NAME" "HOSPITALNAME"
## [172] "DOANAME" "DEATH_DANAME" "DEATH_MONAME"
## [175] "DEATH_YRNAME" "DEATH_HRNAME" "DEATH_MNNAME"
## [178] "DEATH_TMNAME" "LAG_HRSNAME" "LAG_MINSNAME"
## [181] "P_SF1NAME" "P_SF2NAME" "P_SF3NAME"
## [184] "WORK_INJNAME" "HISPANICNAME" "RACENAME"
## [187] "LOCATIONNAME" "HELM_USENAME" "HELM_MISNAME"
## [190] "VPICMAKENAME" "VPICMODEL" "VPICMODELNAME"
## [193] "VPICBODYCLASSNAME" "ICFINALBODYNAME"
dat <- dat %>%
mutate(across(where(is.character), ~ iconv(., from = "", to = "UTF-8", sub = "byte")))
dat1 <- dat %>%
group_by(CRASH_NUM1) %>%
filter(any(RELJCT2NAME=="Shared-Use Path Crossing")) %>%
ungroup()
dim(dat1)
## [1] 152 194
dat2= dat1[, c("CRASH_NUM1", "CRASH_VEH_NUM1",
"CRASH_VehPer_NUM1", "YEAR", "STATENAME",
"COUNTYNAME", "CITYNAME", "LATITUDE",
"LONGITUD", "DAY", "MONTHNAME", "DAY_WEEKNAME",
"HOUR", "HOURNAME", "VE_TOTAL", "VEH_NO", "PER_NO",
"NUMOCCS", "ROUTENAME", "RUR_URBNAME", "FUNC_SYSNAME",
"RD_OWNERNAME", "HARM_EVNAME", "MAN_COLLNAME",
"TYP_INTNAME", "LGT_CONDNAME", "WEATHERNAME",
"CF1NAME", "BODY_TYPNAME", "TRAV_SPNAME", "M_HARMNAME",
"L_RESTRINAME", "SPEEDRELNAME", "DR_SF1NAME",
"VTRAFWAYNAME", "VNUM_LANNAME", "VSPD_LIMNAME",
"VALIGNNAME", "VPROFILENAME", "VSURCONDNAME",
"VTRAFCONNAME", "VTCONT_FNAME", "P_CRASH1NAME",
"ACC_TYPENAME", "AGENAME", "SEXNAME", "ALC_RESNAME",
"WORK_INJNAME", "HISPANICNAME", "RACENAME")]
dim(dat2)
## [1] 152 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:** 152 x 178
## **Duplicates:** 0
##
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | No | Variable | Stats / Values | Freqs (% of Valid) | Valid | Missing |
## +=====+====================+=================================+====================+==========+=========+
## | 1 | STATE\ | 1\. 6\ | 27 (17.8%)\ | 152\ | 0\ |
## | | [factor] | 2\. 12\ | 17 (11.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 26\ | 15 ( 9.9%)\ | | |
## | | | 4\. 34\ | 13 ( 8.6%)\ | | |
## | | | 5\. 17\ | 12 ( 7.9%)\ | | |
## | | | 6\. 48\ | 10 ( 6.6%)\ | | |
## | | | 7\. 55\ | 10 ( 6.6%)\ | | |
## | | | 8\. 37\ | 6 ( 3.9%)\ | | |
## | | | 9\. 8\ | 4 ( 2.6%)\ | | |
## | | | 10\. 11\ | 4 ( 2.6%)\ | | |
## | | | 11\. 25\ | 4 ( 2.6%)\ | | |
## | | | 12\. 36\ | 4 ( 2.6%)\ | | |
## | | | 13\. 39\ | 4 ( 2.6%)\ | | |
## | | | 14\. 49\ | 4 ( 2.6%)\ | | |
## | | | 15\. 10\ | 3 ( 2.0%)\ | | |
## | | | 16\. 53\ | 3 ( 2.0%)\ | | |
## | | | 17\. 13\ | 2 ( 1.3%)\ | | |
## | | | 18\. 29\ | 2 ( 1.3%)\ | | |
## | | | 19\. 35\ | 2 ( 1.3%)\ | | |
## | | | 20\. 41\ | 2 ( 1.3%)\ | | |
## | | | 21\. 42\ | 2 ( 1.3%)\ | | |
## | | | 22\. 45 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 2 | STATENAME\ | 1\. California\ | 27 (17.8%)\ | 152\ | 0\ |
## | | [factor] | 2\. Florida\ | 17 (11.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Michigan\ | 15 ( 9.9%)\ | | |
## | | | 4\. New Jersey\ | 13 ( 8.6%)\ | | |
## | | | 5\. Illinois\ | 12 ( 7.9%)\ | | |
## | | | 6\. Texas\ | 10 ( 6.6%)\ | | |
## | | | 7\. Wisconsin\ | 10 ( 6.6%)\ | | |
## | | | 8\. North Carolina\ | 6 ( 3.9%)\ | | |
## | | | 9\. Colorado\ | 4 ( 2.6%)\ | | |
## | | | 10\. District of Columbia\ | 4 ( 2.6%)\ | | |
## | | | 11\. Massachusetts\ | 4 ( 2.6%)\ | | |
## | | | 12\. New York\ | 4 ( 2.6%)\ | | |
## | | | 13\. Ohio\ | 4 ( 2.6%)\ | | |
## | | | 14\. Utah\ | 4 ( 2.6%)\ | | |
## | | | 15\. Delaware\ | 3 ( 2.0%)\ | | |
## | | | 16\. Washington\ | 3 ( 2.0%)\ | | |
## | | | 17\. Georgia\ | 2 ( 1.3%)\ | | |
## | | | 18\. Missouri\ | 2 ( 1.3%)\ | | |
## | | | 19\. New Mexico\ | 2 ( 1.3%)\ | | |
## | | | 20\. Oregon\ | 2 ( 1.3%)\ | | |
## | | | 21\. Pennsylvania\ | 2 ( 1.3%)\ | | |
## | | | 22\. South Carolina | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 3 | VE_TOTAL\ | 1\. 1\ | 104 (68.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 2\ | 39 (25.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 4\ | 5 ( 3.3%)\ | | |
## | | | 4\. 3 | 4 ( 2.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 4 | COUNTY\ | 1\. 1\ | 15 (9.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 73\ | 10 (6.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. 31\ | 7 (4.6%)\ | | |
## | | | 4\. 67\ | 7 (4.6%)\ | | |
## | | | 5\. 43\ | 5 (3.3%)\ | | |
## | | | 6\. 61\ | 5 (3.3%)\ | | |
## | | | 7\. 453\ | 5 (3.3%)\ | | |
## | | | 8\. 13\ | 4 (2.6%)\ | | |
## | | | 9\. 17\ | 4 (2.6%)\ | | |
## | | | 10\. 55\ | 4 (2.6%)\ | | |
## | | | 11\. 75\ | 4 (2.6%)\ | | |
## | | | 12\. 85\ | 4 (2.6%)\ | | |
## | | | 13\. 86\ | 4 (2.6%)\ | | |
## | | | 14\. 127\ | 4 (2.6%)\ | | |
## | | | 15\. 5\ | 3 (2.0%)\ | | |
## | | | 16\. 29\ | 3 (2.0%)\ | | |
## | | | 17\. 69\ | 3 (2.0%)\ | | |
## | | | 18\. 89\ | 3 (2.0%)\ | | |
## | | | 19\. 93\ | 3 (2.0%)\ | | |
## | | | 20\. 121\ | 3 (2.0%)\ | | |
## | | | 21\. 11\ | 2 (1.3%)\ | | |
## | | | 22\. 15\ | 2 (1.3%)\ | | |
## | | | 23\. 37\ | 2 (1.3%)\ | | |
## | | | 24\. 39\ | 2 (1.3%)\ | | |
## | | | 25\. 45\ | 2 (1.3%)\ | | |
## | | | 26\. 49\ | 2 (1.3%)\ | | |
## | | | 27\. 51\ | 2 (1.3%)\ | | |
## | | | 28\. 59\ | 2 (1.3%)\ | | |
## | | | 29\. 63\ | 2 (1.3%)\ | | |
## | | | 30\. 65\ | 2 (1.3%)\ | | |
## | | | 31\. 71\ | 2 (1.3%)\ | | |
## | | | 32\. 81\ | 2 (1.3%)\ | | |
## | | | 33\. 83\ | 2 (1.3%)\ | | |
## | | | 34\. 87\ | 2 (1.3%)\ | | |
## | | | 35\. 91\ | 2 (1.3%)\ | | |
## | | | 36\. 95\ | 2 (1.3%)\ | | |
## | | | 37\. 99\ | 2 (1.3%)\ | | |
## | | | 38\. 103\ | 2 (1.3%)\ | | |
## | | | 39\. 129\ | 2 (1.3%)\ | | |
## | | | 40\. 139\ | 2 (1.3%)\ | | |
## | | | 41\. 155\ | 2 (1.3%)\ | | |
## | | | 42\. 161\ | 2 (1.3%)\ | | |
## | | | 43\. 183\ | 2 (1.3%)\ | | |
## | | | 44\. 189\ | 2 (1.3%)\ | | |
## | | | 45\. 197\ | 2 (1.3%)\ | | |
## | | | 46\. 439 | 2 (1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 5 | CITY\ | 1\. 0\ | 39 (25.7%)\ | 152\ | 0\ |
## | | [factor] | 2\. 110\ | 5 ( 3.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2640\ | 5 ( 3.3%)\ | | |
## | | | 4\. 5325\ | 5 ( 3.3%)\ | | |
## | | | 5\. 7165\ | 5 ( 3.3%)\ | | |
## | | | 6\. 10\ | 4 ( 2.6%)\ | | |
## | | | 7\. 90\ | 4 ( 2.6%)\ | | |
## | | | 8\. 660\ | 4 ( 2.6%)\ | | |
## | | | 9\. 1972\ | 3 ( 2.0%)\ | | |
## | | | 10\. 3260\ | 3 ( 2.0%)\ | | |
## | | | 11\. 3940\ | 3 ( 2.0%)\ | | |
## | | | 12\. 6090\ | 3 ( 2.0%)\ | | |
## | | | 13\. 9180\ | 3 ( 2.0%)\ | | |
## | | | 14\. 130\ | 2 ( 1.3%)\ | | |
## | | | 15\. 150\ | 2 ( 1.3%)\ | | |
## | | | 16\. 200\ | 2 ( 1.3%)\ | | |
## | | | 17\. 460\ | 2 ( 1.3%)\ | | |
## | | | 18\. 570\ | 2 ( 1.3%)\ | | |
## | | | 19\. 906\ | 2 ( 1.3%)\ | | |
## | | | 20\. 940\ | 2 ( 1.3%)\ | | |
## | | | 21\. 1270\ | 2 ( 1.3%)\ | | |
## | | | 22\. 1300\ | 2 ( 1.3%)\ | | |
## | | | 23\. 1345\ | 2 ( 1.3%)\ | | |
## | | | 24\. 1360\ | 2 ( 1.3%)\ | | |
## | | | 25\. 1410\ | 2 ( 1.3%)\ | | |
## | | | 26\. 1550\ | 2 ( 1.3%)\ | | |
## | | | 27\. 1650\ | 2 ( 1.3%)\ | | |
## | | | 28\. 1850\ | 2 ( 1.3%)\ | | |
## | | | 29\. 2010\ | 2 ( 1.3%)\ | | |
## | | | 30\. 2200\ | 2 ( 1.3%)\ | | |
## | | | 31\. 2285\ | 2 ( 1.3%)\ | | |
## | | | 32\. 2360\ | 2 ( 1.3%)\ | | |
## | | | 33\. 2569\ | 2 ( 1.3%)\ | | |
## | | | 34\. 2660\ | 2 ( 1.3%)\ | | |
## | | | 35\. 2700\ | 2 ( 1.3%)\ | | |
## | | | 36\. 2800\ | 2 ( 1.3%)\ | | |
## | | | 37\. 2922\ | 2 ( 1.3%)\ | | |
## | | | 38\. 2940\ | 2 ( 1.3%)\ | | |
## | | | 39\. 3340\ | 2 ( 1.3%)\ | | |
## | | | 40\. 3430\ | 2 ( 1.3%)\ | | |
## | | | 41\. 3750\ | 2 ( 1.3%)\ | | |
## | | | 42\. 4240\ | 2 ( 1.3%)\ | | |
## | | | 43\. 4980\ | 2 ( 1.3%)\ | | |
## | | | 44\. 5660\ | 2 ( 1.3%)\ | | |
## | | | 45\. 9300\ | 2 ( 1.3%)\ | | |
## | | | 46\. 9997 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 6 | CITYNAME\ | 1\. NOT APPLICABLE\ | 39 (25.7%)\ | 152\ | 0\ |
## | | [factor] | 2\. PFLUGERVILLE\ | 5 ( 3.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. PLEASANTVILLE\ | 5 ( 3.3%)\ | | |
## | | | 4\. PROSPECT HEIGHTS\ | 5 ( 3.3%)\ | | |
## | | | 5\. ATLANTIC CITY\ | 4 ( 2.6%)\ | | |
## | | | 6\. MALDEN\ | 4 ( 2.6%)\ | | |
## | | | 7\. WASHINGTON, DC\ | 4 ( 2.6%)\ | | |
## | | | 8\. BELLINGHAM\ | 3 ( 2.0%)\ | | |
## | | | 9\. LOOMIS\ | 3 ( 2.0%)\ | | |
## | | | 10\. PRESCOTT\ | 3 ( 2.0%)\ | | |
## | | | 11\. SAN ANTONIO\ | 3 ( 2.0%)\ | | |
## | | | 12\. SAN DIEGO\ | 3 ( 2.0%)\ | | |
## | | | 13\. WEST CHICAGO\ | 3 ( 2.0%)\ | | |
## | | | 14\. ANN ARBOR\ | 2 ( 1.3%)\ | | |
## | | | 15\. AVON PARK\ | 2 ( 1.3%)\ | | |
## | | | 16\. BERNALILLO\ | 2 ( 1.3%)\ | | |
## | | | 17\. BOULDER\ | 2 ( 1.3%)\ | | |
## | | | 18\. CHOCOWINITY\ | 2 ( 1.3%)\ | | |
## | | | 19\. CLEARWATER\ | 2 ( 1.3%)\ | | |
## | | | 20\. DURHAM\ | 2 ( 1.3%)\ | | |
## | | | 21\. ELMIRA\ | 2 ( 1.3%)\ | | |
## | | | 22\. FARMINGTON\ | 2 ( 1.3%)\ | | |
## | | | 23\. FOLSOM\ | 2 ( 1.3%)\ | | |
## | | | 24\. GAINESVILLE\ | 2 ( 1.3%)\ | | |
## | | | 25\. GRAND PRAIRIE\ | 2 ( 1.3%)\ | | |
## | | | 26\. HAMMONTON\ | 2 ( 1.3%)\ | | |
## | | | 27\. HASTINGS\ | 2 ( 1.3%)\ | | |
## | | | 28\. HIALEAH GARDENS\ | 2 ( 1.3%)\ | | |
## | | | 29\. HOLLY HILL\ | 2 ( 1.3%)\ | | |
## | | | 30\. KENILWORTH\ | 2 ( 1.3%)\ | | |
## | | | 31\. KIRKWOOD\ | 2 ( 1.3%)\ | | |
## | | | 32\. LANSING\ | 2 ( 1.3%)\ | | |
## | | | 33\. LEHI\ | 2 ( 1.3%)\ | | |
## | | | 34\. MIAMI\ | 2 ( 1.3%)\ | | |
## | | | 35\. MIDDLEFIELD\ | 2 ( 1.3%)\ | | |
## | | | 36\. MODESTO\ | 2 ( 1.3%)\ | | |
## | | | 37\. MOKENA\ | 2 ( 1.3%)\ | | |
## | | | 38\. ORLANDO\ | 2 ( 1.3%)\ | | |
## | | | 39\. Other\ | 2 ( 1.3%)\ | | |
## | | | 40\. PALO ALTO\ | 2 ( 1.3%)\ | | |
## | | | 41\. PORTLAND\ | 2 ( 1.3%)\ | | |
## | | | 42\. RALEIGH\ | 2 ( 1.3%)\ | | |
## | | | 43\. RANCHO CUCAMONGA\ | 2 ( 1.3%)\ | | |
## | | | 44\. SAN JOSE\ | 2 ( 1.3%)\ | | |
## | | | 45\. SANTA BARBARA\ | 2 ( 1.3%)\ | | |
## | | | 46\. TALLAHASSEE\ | 2 ( 1.3%)\ | | |
## | | | 47\. WHEELING | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 7 | DAY\ | 1\. 12\ | 15 (9.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 27\ | 14 (9.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 17\ | 13 (8.6%)\ | | |
## | | | 4\. 18\ | 13 (8.6%)\ | | |
## | | | 5\. 14\ | 9 (5.9%)\ | | |
## | | | 6\. 22\ | 9 (5.9%)\ | | |
## | | | 7\. 26\ | 8 (5.3%)\ | | |
## | | | 8\. 16\ | 7 (4.6%)\ | | |
## | | | 9\. 13\ | 6 (3.9%)\ | | |
## | | | 10\. 8\ | 5 (3.3%)\ | | |
## | | | 11\. 2\ | 4 (2.6%)\ | | |
## | | | 12\. 3\ | 4 (2.6%)\ | | |
## | | | 13\. 4\ | 4 (2.6%)\ | | |
## | | | 14\. 9\ | 4 (2.6%)\ | | |
## | | | 15\. 10\ | 4 (2.6%)\ | | |
## | | | 16\. 15\ | 4 (2.6%)\ | | |
## | | | 17\. 21\ | 4 (2.6%)\ | | |
## | | | 18\. 23\ | 4 (2.6%)\ | | |
## | | | 19\. 24\ | 4 (2.6%)\ | | |
## | | | 20\. 25\ | 4 (2.6%)\ | | |
## | | | 21\. 30\ | 4 (2.6%)\ | | |
## | | | 22\. 29\ | 3 (2.0%)\ | | |
## | | | 23\. 7\ | 2 (1.3%)\ | | |
## | | | 24\. 28\ | 2 (1.3%)\ | | |
## | | | 25\. 31 | 2 (1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 8 | MONTH\ | 1\. 8\ | 28 (18.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 1\ | 20 (13.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 9\ | 16 (10.5%)\ | | |
## | | | 4\. 10\ | 15 ( 9.9%)\ | | |
## | | | 5\. 2\ | 13 ( 8.6%)\ | | |
## | | | 6\. 5\ | 13 ( 8.6%)\ | | |
## | | | 7\. 3\ | 12 ( 7.9%)\ | | |
## | | | 8\. 11\ | 11 ( 7.2%)\ | | |
## | | | 9\. 6\ | 10 ( 6.6%)\ | | |
## | | | 10\. 7\ | 8 ( 5.3%)\ | | |
## | | | 11\. 4\ | 4 ( 2.6%)\ | | |
## | | | 12\. 12 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 9 | MONTHNAME\ | 1\. August\ | 28 (18.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. January\ | 20 (13.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. September\ | 16 (10.5%)\ | | |
## | | | 4\. October\ | 15 ( 9.9%)\ | | |
## | | | 5\. February\ | 13 ( 8.6%)\ | | |
## | | | 6\. May\ | 13 ( 8.6%)\ | | |
## | | | 7\. March\ | 12 ( 7.9%)\ | | |
## | | | 8\. November\ | 11 ( 7.2%)\ | | |
## | | | 9\. June\ | 10 ( 6.6%)\ | | |
## | | | 10\. July\ | 8 ( 5.3%)\ | | |
## | | | 11\. April\ | 4 ( 2.6%)\ | | |
## | | | 12\. December | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 10 | YEAR\ | 1\. 2023\ | 33 (21.7%)\ | 152\ | 0\ |
## | | [factor] | 2\. 2018\ | 24 (15.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2017\ | 23 (15.1%)\ | | |
## | | | 4\. 2020\ | 22 (14.5%)\ | | |
## | | | 5\. 2019\ | 18 (11.8%)\ | | |
## | | | 6\. 2022\ | 16 (10.5%)\ | | |
## | | | 7\. 2016\ | 10 ( 6.6%)\ | | |
## | | | 8\. 2021 | 6 ( 3.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 11 | DAY_WEEKNAME\ | 1\. Thursday\ | 32 (21.1%)\ | 152\ | 0\ |
## | | [factor] | 2\. Saturday\ | 22 (14.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. Tuesday\ | 22 (14.5%)\ | | |
## | | | 4\. Sunday\ | 21 (13.8%)\ | | |
## | | | 5\. Monday\ | 20 (13.2%)\ | | |
## | | | 6\. Wednesday\ | 18 (11.8%)\ | | |
## | | | 7\. Friday | 17 (11.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 12 | HOUR\ | 1\. 19\ | 21 (13.8%)\ | 152\ | 0\ |
## | | [factor] | 2\. 18\ | 19 (12.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. 7\ | 11 ( 7.2%)\ | | |
## | | | 4\. 12\ | 11 ( 7.2%)\ | | |
## | | | 5\. 14\ | 10 ( 6.6%)\ | | |
## | | | 6\. 17\ | 10 ( 6.6%)\ | | |
## | | | 7\. 13\ | 9 ( 5.9%)\ | | |
## | | | 8\. 8\ | 8 ( 5.3%)\ | | |
## | | | 9\. 9\ | 8 ( 5.3%)\ | | |
## | | | 10\. 11\ | 8 ( 5.3%)\ | | |
## | | | 11\. 20\ | 8 ( 5.3%)\ | | |
## | | | 12\. 22\ | 8 ( 5.3%)\ | | |
## | | | 13\. 6\ | 6 ( 3.9%)\ | | |
## | | | 14\. 15\ | 5 ( 3.3%)\ | | |
## | | | 15\. 23\ | 4 ( 2.6%)\ | | |
## | | | 16\. 3\ | 2 ( 1.3%)\ | | |
## | | | 17\. 16\ | 2 ( 1.3%)\ | | |
## | | | 18\. 21 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 13 | HOURNAME\ | 1\. 7:00pm-7:59pm\ | 21 (13.8%)\ | 152\ | 0\ |
## | | [factor] | 2\. 6:00pm-6:59pm\ | 19 (12.5%)\ | (100.0%) | (0.0%) |
## | | | 3\. 12:00pm-12:59pm\ | 11 ( 7.2%)\ | | |
## | | | 4\. 7:00am-7:59am\ | 11 ( 7.2%)\ | | |
## | | | 5\. 2:00pm-2:59pm\ | 10 ( 6.6%)\ | | |
## | | | 6\. 5:00pm-5:59pm\ | 10 ( 6.6%)\ | | |
## | | | 7\. 1:00pm-1:59pm\ | 9 ( 5.9%)\ | | |
## | | | 8\. 10:00pm-10:59pm\ | 8 ( 5.3%)\ | | |
## | | | 9\. 11:00am-11:59am\ | 8 ( 5.3%)\ | | |
## | | | 10\. 8:00am-8:59am\ | 8 ( 5.3%)\ | | |
## | | | 11\. 8:00pm-8:59pm\ | 8 ( 5.3%)\ | | |
## | | | 12\. 9:00am-9:59am\ | 8 ( 5.3%)\ | | |
## | | | 13\. 6:00am-6:59am\ | 6 ( 3.9%)\ | | |
## | | | 14\. 3:00pm-3:59pm\ | 5 ( 3.3%)\ | | |
## | | | 15\. 11:00pm-11:59pm\ | 4 ( 2.6%)\ | | |
## | | | 16\. 3:00am-3:59am\ | 2 ( 1.3%)\ | | |
## | | | 17\. 4:00pm-4:59pm\ | 2 ( 1.3%)\ | | |
## | | | 18\. 9:00pm-9:59pm | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 14 | NHSNAME\ | 1\. This section IS NOT on th\ | 84 (55.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. This section IS ON the NH\ | 35 (23.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. This Section IS NOT on th\ | 18 (11.8%)\ | | |
## | | | 4\. This Section IS ON the NH | 15 ( 9.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 15 | ROUTENAME\ | 1\. State Highway\ | 38 (25.0%)\ | 152\ | 0\ |
## | | [factor] | 2\. Local Street - Municipali\ | 27 (17.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. U.S. Highway\ | 24 (15.8%)\ | | |
## | | | 4\. Other\ | 20 (13.2%)\ | | |
## | | | 5\. County Road\ | 18 (11.8%)\ | | |
## | | | 6\. Unknown\ | 10 ( 6.6%)\ | | |
## | | | 7\. Local Street - Frontage R\ | 5 ( 3.3%)\ | | |
## | | | 8\. Local Street - Township\ | 4 ( 2.6%)\ | | |
## | | | 9\. County\ | 2 ( 1.3%)\ | | |
## | | | 10\. Municipal\ | 2 ( 1.3%)\ | | |
## | | | 11\. Not Signed | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 16 | TWAY_ID2\ | 1\. (Empty string)\ | 148 (97.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. JEFFERSON AVE\ | 2 ( 1.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. SR-430 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 17 | RUR_URBNAME\ | 1\. Urban\ | 125 (82.2%)\ | 152\ | 0\ |
## | | [factor] | 2\. Rural\ | 23 (15.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Trafficway Not in State I | 4 ( 2.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 18 | FUNC_SYSNAME\ | 1\. Principal Arterial - Othe\ | 42 (27.6%)\ | 152\ | 0\ |
## | | [factor] | 2\. Minor Arterial\ | 30 (19.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. Major Collector\ | 27 (17.8%)\ | | |
## | | | 4\. Local\ | 24 (15.8%)\ | | |
## | | | 5\. Other Principal Arterial\ | 18 (11.8%)\ | | |
## | | | 6\. Minor Collector\ | 7 ( 4.6%)\ | | |
## | | | 7\. Trafficway Not in State I | 4 ( 2.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 19 | RD_OWNERNAME\ | 1\. State Highway Agency\ | 57 (37.5%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 41 (27.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. City or Municipal Highway\ | 31 (20.4%)\ | | |
## | | | 4\. County Highway Agency\ | 13 ( 8.6%)\ | | |
## | | | 5\. Town or Township Highway \ | 4 ( 2.6%)\ | | |
## | | | 6\. Trafficway Not in State I\ | 4 ( 2.6%)\ | | |
## | | | 7\. Other State Agency | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 20 | SP_JURNAME\ | 1\. No Special Jurisdiction\ | 150 (98.7%)\ | 152\ | 0\ |
## | | [factor] | 2\. Indian Reservation | 2 ( 1.3%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 21 | HARM_EVNAME\ | 1\. Pedestrian\ | 58 (38.2%)\ | 152\ | 0\ |
## | | [factor] | 2\. Pedalcyclist\ | 55 (36.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Motor Vehicle In-Transpor | 39 (25.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 22 | MAN_COLLNAME\ | 1\. The First Harmful Event w\ | 78 (51.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Angle\ | 35 (23.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not a Collision with Moto\ | 35 (23.0%)\ | | |
## | | | 4\. Sideswipe - Same Directio | 4 ( 2.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 23 | RELJCT1NAME\ | 1\. No | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 24 | RELJCT2NAME\ | 1\. Shared-Use Path Crossing | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 25 | TYP_INTNAME\ | 1\. Not an Intersection | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 26 | WRK_ZONENAME\ | 1\. None\ | 150 (98.7%)\ | 152\ | 0\ |
## | | [factor] | 2\. Work Zone, Type Unknown | 2 ( 1.3%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 27 | REL_ROADNAME\ | 1\. On Roadway | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 28 | LGT_CONDNAME\ | 1\. Daylight\ | 97 (63.8%)\ | 152\ | 0\ |
## | | [factor] | 2\. Dark - Lighted\ | 23 (15.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Dark - Not Lighted\ | 19 (12.5%)\ | | |
## | | | 4\. Dusk\ | 8 ( 5.3%)\ | | |
## | | | 5\. Dark - Unknown Lighting\ | 3 ( 2.0%)\ | | |
## | | | 6\. Dawn | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 29 | WEATHER1NAME\ | 1\. Clear\ | 65 (86.7%)\ | 75\ | 77\ |
## | | [factor] | 2\. Cloudy\ | 8 (10.7%)\ | (49.3%) | (50.7%) |
## | | | 3\. Not Reported | 2 ( 2.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 30 | WEATHER2NAME\ | 1\. No Additional Atmospheric | 75 (100.0%) | 75\ | 77\ |
## | | [factor] | | | (49.3%) | (50.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 31 | WEATHERNAME\ | 1\. Clear\ | 121 (79.6%)\ | 152\ | 0\ |
## | | [factor] | 2\. Cloudy\ | 20 (13.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Rain\ | 7 ( 4.6%)\ | | |
## | | | 4\. Not Reported | 4 ( 2.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 32 | SCH_BUSNAME\ | 1\. No | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 33 | RAILNAME\ | 1\. Not Applicable | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 34 | NOT_HOURNAME\ | 1\. Unknown\ | 72 (47.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 7:00am-7:59am\ | 11 ( 7.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2:00pm-2:59pm\ | 8 ( 5.3%)\ | | |
## | | | 4\. 6:00pm-6:59pm\ | 8 ( 5.3%)\ | | |
## | | | 5\. 5:00pm-5:59pm\ | 7 ( 4.6%)\ | | |
## | | | 6\. 8:00pm-8:59pm\ | 6 ( 3.9%)\ | | |
## | | | 7\. 9:00am-9:59am\ | 6 ( 3.9%)\ | | |
## | | | 8\. 7:00pm-7:59pm\ | 5 ( 3.3%)\ | | |
## | | | 9\. 10:00pm-10:59pm\ | 4 ( 2.6%)\ | | |
## | | | 10\. 11:00am-11:59am\ | 4 ( 2.6%)\ | | |
## | | | 11\. 11:00pm-11:59pm\ | 4 ( 2.6%)\ | | |
## | | | 12\. 12:00pm-12:59pm\ | 4 ( 2.6%)\ | | |
## | | | 13\. 8:00am-8:59am\ | 4 ( 2.6%)\ | | |
## | | | 14\. Not Applicable (Not Notif\ | 3 ( 2.0%)\ | | |
## | | | 15\. 3:00pm-3:59pm\ | 2 ( 1.3%)\ | | |
## | | | 16\. 6:00am-6:59am\ | 2 ( 1.3%)\ | | |
## | | | 17\. 9:00pm-9:59pm | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 35 | ARR_HOUR\ | 1\. 99\ | 72 (47.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 18\ | 10 ( 6.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. 7\ | 9 ( 5.9%)\ | | |
## | | | 4\. 14\ | 8 ( 5.3%)\ | | |
## | | | 5\. 8\ | 6 ( 3.9%)\ | | |
## | | | 6\. 20\ | 6 ( 3.9%)\ | | |
## | | | 7\. 17\ | 5 ( 3.3%)\ | | |
## | | | 8\. 19\ | 5 ( 3.3%)\ | | |
## | | | 9\. 9\ | 4 ( 2.6%)\ | | |
## | | | 10\. 11\ | 4 ( 2.6%)\ | | |
## | | | 11\. 12\ | 4 ( 2.6%)\ | | |
## | | | 12\. 22\ | 4 ( 2.6%)\ | | |
## | | | 13\. 23\ | 4 ( 2.6%)\ | | |
## | | | 14\. 88\ | 3 ( 2.0%)\ | | |
## | | | 15\. 6\ | 2 ( 1.3%)\ | | |
## | | | 16\. 10\ | 2 ( 1.3%)\ | | |
## | | | 17\. 15\ | 2 ( 1.3%)\ | | |
## | | | 18\. 21 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 36 | ARR_HOURNAME\ | 1\. Unknown EMS Scene Arrival\ | 72 (47.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 6:00pm-6:59pm\ | 10 ( 6.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. 7:00am-7:59am\ | 9 ( 5.9%)\ | | |
## | | | 4\. 2:00pm-2:59pm\ | 8 ( 5.3%)\ | | |
## | | | 5\. 8:00am-8:59am\ | 6 ( 3.9%)\ | | |
## | | | 6\. 8:00pm-8:59pm\ | 6 ( 3.9%)\ | | |
## | | | 7\. 5:00pm-5:59pm\ | 5 ( 3.3%)\ | | |
## | | | 8\. 7:00pm-7:59pm\ | 5 ( 3.3%)\ | | |
## | | | 9\. 10:00pm-10:59pm\ | 4 ( 2.6%)\ | | |
## | | | 10\. 11:00am-11:59am\ | 4 ( 2.6%)\ | | |
## | | | 11\. 11:00pm-11:59pm\ | 4 ( 2.6%)\ | | |
## | | | 12\. 12:00pm-12:59pm\ | 4 ( 2.6%)\ | | |
## | | | 13\. 9:00am-9:59am\ | 4 ( 2.6%)\ | | |
## | | | 14\. Not Applicable\ | 3 ( 2.0%)\ | | |
## | | | 15\. 10:00am-10:59am\ | 2 ( 1.3%)\ | | |
## | | | 16\. 3:00pm-3:59pm\ | 2 ( 1.3%)\ | | |
## | | | 17\. 6:00am-6:59am\ | 2 ( 1.3%)\ | | |
## | | | 18\. 9:00pm-9:59pm | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 37 | ARR_MIN\ | 1\. 99\ | 66 (43.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 23\ | 8 ( 5.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. 22\ | 7 ( 4.6%)\ | | |
## | | | 4\. 52\ | 6 ( 3.9%)\ | | |
## | | | 5\. 98\ | 6 ( 3.9%)\ | | |
## | | | 6\. 30\ | 5 ( 3.3%)\ | | |
## | | | 7\. 31\ | 4 ( 2.6%)\ | | |
## | | | 8\. 48\ | 4 ( 2.6%)\ | | |
## | | | 9\. 54\ | 4 ( 2.6%)\ | | |
## | | | 10\. 58\ | 4 ( 2.6%)\ | | |
## | | | 11\. 14\ | 3 ( 2.0%)\ | | |
## | | | 12\. 26\ | 3 ( 2.0%)\ | | |
## | | | 13\. 50\ | 3 ( 2.0%)\ | | |
## | | | 14\. 88\ | 3 ( 2.0%)\ | | |
## | | | 15\. 0\ | 2 ( 1.3%)\ | | |
## | | | 16\. 2\ | 2 ( 1.3%)\ | | |
## | | | 17\. 7\ | 2 ( 1.3%)\ | | |
## | | | 18\. 10\ | 2 ( 1.3%)\ | | |
## | | | 19\. 12\ | 2 ( 1.3%)\ | | |
## | | | 20\. 19\ | 2 ( 1.3%)\ | | |
## | | | 21\. 24\ | 2 ( 1.3%)\ | | |
## | | | 22\. 28\ | 2 ( 1.3%)\ | | |
## | | | 23\. 35\ | 2 ( 1.3%)\ | | |
## | | | 24\. 40\ | 2 ( 1.3%)\ | | |
## | | | 25\. 53\ | 2 ( 1.3%)\ | | |
## | | | 26\. 57\ | 2 ( 1.3%)\ | | |
## | | | 27\. 97 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 38 | ARR_MINNAME\ | 1\. Unknown EMS Scene Arrival\ | 66 (43.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 23\ | 8 ( 5.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. 22\ | 7 ( 4.6%)\ | | |
## | | | 4\. 52\ | 6 ( 3.9%)\ | | |
## | | | 5\. Unknown if Arrived\ | 6 ( 3.9%)\ | | |
## | | | 6\. 30\ | 5 ( 3.3%)\ | | |
## | | | 7\. 31\ | 4 ( 2.6%)\ | | |
## | | | 8\. 48\ | 4 ( 2.6%)\ | | |
## | | | 9\. 54\ | 4 ( 2.6%)\ | | |
## | | | 10\. 58\ | 4 ( 2.6%)\ | | |
## | | | 11\. 14\ | 3 ( 2.0%)\ | | |
## | | | 12\. 26\ | 3 ( 2.0%)\ | | |
## | | | 13\. 50\ | 3 ( 2.0%)\ | | |
## | | | 14\. Not Applicable\ | 3 ( 2.0%)\ | | |
## | | | 15\. 0\ | 2 ( 1.3%)\ | | |
## | | | 16\. 10\ | 2 ( 1.3%)\ | | |
## | | | 17\. 12\ | 2 ( 1.3%)\ | | |
## | | | 18\. 19\ | 2 ( 1.3%)\ | | |
## | | | 19\. 2\ | 2 ( 1.3%)\ | | |
## | | | 20\. 24\ | 2 ( 1.3%)\ | | |
## | | | 21\. 28\ | 2 ( 1.3%)\ | | |
## | | | 22\. 35\ | 2 ( 1.3%)\ | | |
## | | | 23\. 40\ | 2 ( 1.3%)\ | | |
## | | | 24\. 53\ | 2 ( 1.3%)\ | | |
## | | | 25\. 57\ | 2 ( 1.3%)\ | | |
## | | | 26\. 7\ | 2 ( 1.3%)\ | | |
## | | | 27\. Officially Cancelled | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 39 | HOSP_HR\ | 1\. 99\ | 80 (52.6%)\ | 152\ | 0\ |
## | | [factor] | 2\. 88\ | 39 (25.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 15\ | 6 ( 3.9%)\ | | |
## | | | 4\. 7\ | 5 ( 3.3%)\ | | |
## | | | 5\. 19\ | 5 ( 3.3%)\ | | |
## | | | 6\. 11\ | 4 ( 2.6%)\ | | |
## | | | 7\. 14\ | 4 ( 2.6%)\ | | |
## | | | 8\. 20\ | 3 ( 2.0%)\ | | |
## | | | 9\. 8\ | 2 ( 1.3%)\ | | |
## | | | 10\. 10\ | 2 ( 1.3%)\ | | |
## | | | 11\. 18 | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 40 | HOSP_HRNAME\ | 1\. Unknown\ | 80 (52.6%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not Applicable (Not Trans\ | 39 (25.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3:00pm-3:59pm\ | 6 ( 3.9%)\ | | |
## | | | 4\. 7:00am-7:59am\ | 5 ( 3.3%)\ | | |
## | | | 5\. 7:00pm-7:59pm\ | 5 ( 3.3%)\ | | |
## | | | 6\. 11:00am-11:59am\ | 4 ( 2.6%)\ | | |
## | | | 7\. 2:00pm-2:59pm\ | 4 ( 2.6%)\ | | |
## | | | 8\. 8:00pm-8:59pm\ | 3 ( 2.0%)\ | | |
## | | | 9\. 10:00am-10:59am\ | 2 ( 1.3%)\ | | |
## | | | 10\. 6:00pm-6:59pm\ | 2 ( 1.3%)\ | | |
## | | | 11\. 8:00am-8:59am | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 41 | CF1NAME\ | 1\. None\ | 68 (90.7%)\ | 75\ | 77\ |
## | | [factor] | 2\. Speed Limit is a Statutor\ | 5 ( 6.7%)\ | (49.3%) | (50.7%) |
## | | | 3\. Unknown | 2 ( 2.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 42 | CF2NAME\ | 1\. None\ | 73 (97.3%)\ | 75\ | 77\ |
## | | [factor] | 2\. Unknown | 2 ( 2.7%) | (49.3%) | (50.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 43 | CF3NAME\ | 1\. None\ | 73 (97.3%)\ | 75\ | 77\ |
## | | [factor] | 2\. Unknown | 2 ( 2.7%) | (49.3%) | (50.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 44 | FATALS\ | 1\. 1 | 152 (100.0%) | 152\ | 0\ |
## | | [factor] | | | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 45 | DRUNK_DR\ | 1\. 0\ | 86 (88.7%)\ | 97\ | 55\ |
## | | [factor] | 2\. 1 | 11 (11.3%) | (63.8%) | (36.2%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 46 | VEH_NO\ | 1\. 1\ | 80 (52.6%)\ | 152\ | 0\ |
## | | [factor] | 2\. 0\ | 50 (32.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 19 (12.5%)\ | | |
## | | | 4\. 3\ | 2 ( 1.3%)\ | | |
## | | | 5\. 4 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 47 | NUMOCCS\ | 1\. 1\ | 63 (61.8%)\ | 102\ | 50\ |
## | | [factor] | 2\. 2\ | 30 (29.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. 99\ | 5 ( 4.9%)\ | | |
## | | | 4\. 4 | 4 ( 3.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 48 | UNITTYPENAME\ | 1\. Motor Vehicle In-Transpor | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 49 | HIT_RUNNAME\ | 1\. No\ | 93 (91.2%)\ | 102\ | 50\ |
## | | [factor] | 2\. Yes | 9 ( 8.8%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 50 | REG_STATNAME\ | 1\. California\ | 12 (11.8%)\ | 102\ | 50\ |
## | | [factor] | 2\. Florida\ | 11 (10.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Illinois\ | 10 ( 9.8%)\ | | |
## | | | 4\. Michigan\ | 9 ( 8.8%)\ | | |
## | | | 5\. New Jersey\ | 7 ( 6.9%)\ | | |
## | | | 6\. Texas\ | 7 ( 6.9%)\ | | |
## | | | 7\. Wisconsin\ | 5 ( 4.9%)\ | | |
## | | | 8\. North Carolina\ | 4 ( 3.9%)\ | | |
## | | | 9\. New York\ | 3 ( 2.9%)\ | | |
## | | | 10\. Not Applicable\ | 3 ( 2.9%)\ | | |
## | | | 11\. Alaska\ | 2 ( 2.0%)\ | | |
## | | | 12\. Colorado\ | 2 ( 2.0%)\ | | |
## | | | 13\. Delaware\ | 2 ( 2.0%)\ | | |
## | | | 14\. District of Columbia\ | 2 ( 2.0%)\ | | |
## | | | 15\. Georgia\ | 2 ( 2.0%)\ | | |
## | | | 16\. Minnesota\ | 2 ( 2.0%)\ | | |
## | | | 17\. Nevada\ | 2 ( 2.0%)\ | | |
## | | | 18\. No Registration\ | 2 ( 2.0%)\ | | |
## | | | 19\. Ohio\ | 2 ( 2.0%)\ | | |
## | | | 20\. Unknown\ | 2 ( 2.0%)\ | | |
## | | | 21\. Utah\ | 2 ( 2.0%)\ | | |
## | | | 22\. Virginia\ | 2 ( 2.0%)\ | | |
## | | | 23\. Washington\ | 2 ( 2.0%)\ | | |
## | | | 24\. Indiana\ | 1 ( 1.0%)\ | | |
## | | | 25\. New Mexico\ | 1 ( 1.0%)\ | | |
## | | | 26\. Oregon\ | 1 ( 1.0%)\ | | |
## | | | 27\. Reported as Unknown\ | 1 ( 1.0%)\ | | |
## | | | 28\. South Carolina | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 51 | OWNERNAME\ | 1\. Driver (in this crash) wa\ | 62 (60.8%)\ | 102\ | 50\ |
## | | [factor] | 2\. Driver (in this crash) No\ | 19 (18.6%)\ | (67.1%) | (32.9%) |
## | | | 3\. Not Applicable, Vehicle N\ | 7 ( 6.9%)\ | | |
## | | | 4\. Vehicle Registered as Bus\ | 6 ( 5.9%)\ | | |
## | | | 5\. Vehicle Registered as Com\ | 4 ( 3.9%)\ | | |
## | | | 6\. Unknown\ | 3 ( 2.9%)\ | | |
## | | | 7\. Vehicle Registered as Ren | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 52 | MAKENAME\ | 1\. Ford\ | 17 (16.7%)\ | 102\ | 50\ |
## | | [factor] | 2\. Toyota\ | 13 (12.7%)\ | (67.1%) | (32.9%) |
## | | | 3\. Chevrolet\ | 12 (11.8%)\ | | |
## | | | 4\. Other Make\ | 7 ( 6.9%)\ | | |
## | | | 5\. Honda\ | 6 ( 5.9%)\ | | |
## | | | 6\. Nissan/Datsun\ | 5 ( 4.9%)\ | | |
## | | | 7\. Dodge\ | 4 ( 3.9%)\ | | |
## | | | 8\. Volkswagen\ | 4 ( 3.9%)\ | | |
## | | | 9\. Yamaha\ | 4 ( 3.9%)\ | | |
## | | | 10\. Datsun/Nissan\ | 3 ( 2.9%)\ | | |
## | | | 11\. Mazda\ | 3 ( 2.9%)\ | | |
## | | | 12\. Unknown Make\ | 3 ( 2.9%)\ | | |
## | | | 13\. Freightliner\ | 2 ( 2.0%)\ | | |
## | | | 14\. GMC\ | 2 ( 2.0%)\ | | |
## | | | 15\. Harley-Davidson\ | 2 ( 2.0%)\ | | |
## | | | 16\. Jeep / Kaiser-Jeep / Will\ | 2 ( 2.0%)\ | | |
## | | | 17\. KIA\ | 2 ( 2.0%)\ | | |
## | | | 18\. Mercedes-Benz\ | 2 ( 2.0%)\ | | |
## | | | 19\. Acura\ | 1 ( 1.0%)\ | | |
## | | | 20\. BMW\ | 1 ( 1.0%)\ | | |
## | | | 21\. Buick / Opel\ | 1 ( 1.0%)\ | | |
## | | | 22\. Cadillac\ | 1 ( 1.0%)\ | | |
## | | | 23\. Chrysler\ | 1 ( 1.0%)\ | | |
## | | | 24\. Mack\ | 1 ( 1.0%)\ | | |
## | | | 25\. Peterbilt\ | 1 ( 1.0%)\ | | |
## | | | 26\. Pontiac\ | 1 ( 1.0%)\ | | |
## | | | 27\. Saturn | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 53 | BODY_TYPNAME\ | 1\. 4-door sedan, hardtop\ | 31 (30.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. Compact Utility (Utility \ | 17 (16.7%)\ | (67.1%) | (32.9%) |
## | | | 3\. Light Pickup\ | 10 ( 9.8%)\ | | |
## | | | 4\. 5-door/4-door hatchback\ | 5 ( 4.9%)\ | | |
## | | | 5\. Snowmobile\ | 5 ( 4.9%)\ | | |
## | | | 6\. Minivan (Chrysler Town an\ | 4 ( 3.9%)\ | | |
## | | | 7\. Station Wagon (excluding \ | 4 ( 3.9%)\ | | |
## | | | 8\. Two Wheel Motorcycle (exc\ | 4 ( 3.9%)\ | | |
## | | | 9\. Large utility (ANSI D16.1\ | 3 ( 2.9%)\ | | |
## | | | 10\. Truck-tractor (Cab only, \ | 3 ( 2.9%)\ | | |
## | | | 11\. ATV/ATC [All-Terrain Cycl\ | 2 ( 2.0%)\ | | |
## | | | 12\. Convertible(excludes sun-\ | 2 ( 2.0%)\ | | |
## | | | 13\. Motor Scooter\ | 2 ( 2.0%)\ | | |
## | | | 14\. Single-unit straight truc\ | 2 ( 2.0%)\ | | |
## | | | 15\. Standard pickup (GVWR 4,5\ | 2 ( 2.0%)\ | | |
## | | | 16\. Unknown body type\ | 2 ( 2.0%)\ | | |
## | | | 17\. Golf Cart\ | 1 ( 1.0%)\ | | |
## | | | 18\. Large Van-Includes van-ba\ | 1 ( 1.0%)\ | | |
## | | | 19\. Single-unit straight truc\ | 1 ( 1.0%)\ | | |
## | | | 20\. Unknown light vehicle typ | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 54 | MOD_YEAR\ | 1\. 2013\ | 11 (10.8%)\ | 102\ | 50\ |
## | | [factor] | 2\. 2009\ | 10 ( 9.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. 2004\ | 8 ( 7.8%)\ | | |
## | | | 4\. 2017\ | 7 ( 6.9%)\ | | |
## | | | 5\. 2012\ | 6 ( 5.9%)\ | | |
## | | | 6\. 2014\ | 6 ( 5.9%)\ | | |
## | | | 7\. 2006\ | 5 ( 4.9%)\ | | |
## | | | 8\. 2003\ | 4 ( 3.9%)\ | | |
## | | | 9\. 2005\ | 4 ( 3.9%)\ | | |
## | | | 10\. 2008\ | 4 ( 3.9%)\ | | |
## | | | 11\. 2010\ | 4 ( 3.9%)\ | | |
## | | | 12\. 2015\ | 4 ( 3.9%)\ | | |
## | | | 13\. 2016\ | 4 ( 3.9%)\ | | |
## | | | 14\. 1998\ | 3 ( 2.9%)\ | | |
## | | | 15\. 1999\ | 3 ( 2.9%)\ | | |
## | | | 16\. 2011\ | 3 ( 2.9%)\ | | |
## | | | 17\. 2000\ | 2 ( 2.0%)\ | | |
## | | | 18\. 2001\ | 2 ( 2.0%)\ | | |
## | | | 19\. 2019\ | 2 ( 2.0%)\ | | |
## | | | 20\. 9999\ | 2 ( 2.0%)\ | | |
## | | | 21\. 1991\ | 1 ( 1.0%)\ | | |
## | | | 22\. 1994\ | 1 ( 1.0%)\ | | |
## | | | 23\. 1997\ | 1 ( 1.0%)\ | | |
## | | | 24\. 2002\ | 1 ( 1.0%)\ | | |
## | | | 25\. 2007\ | 1 ( 1.0%)\ | | |
## | | | 26\. 2018\ | 1 ( 1.0%)\ | | |
## | | | 27\. 2020\ | 1 ( 1.0%)\ | | |
## | | | 28\. 2022 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 55 | TOW_VEHNAME\ | 1\. No Trailing Units\ | 67 (65.7%)\ | 102\ | 50\ |
## | | [factor] | 2\. No Trailers\ | 31 (30.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. One Trailing Unit\ | 3 ( 2.9%)\ | | |
## | | | 4\. Two Trailing Units | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 56 | J_KNIFENAME\ | 1\. Not an Articulated Vehicl\ | 98 (96.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. No | 4 ( 3.9%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 57 | MCARR_I1NAME\ | 1\. Not Applicable\ | 96 (94.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. US DOT\ | 5 ( 4.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Reported as Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 58 | MCARR_I2NAME\ | 1\. Not Applicable\ | 96 (94.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. 386074\ | 2 ( 2.0%)\ | (67.1%) | (32.9%) |
## | | | 3\. 00083642\ | 1 ( 1.0%)\ | | |
## | | | 4\. 2154496\ | 1 ( 1.0%)\ | | |
## | | | 5\. 471318\ | 1 ( 1.0%)\ | | |
## | | | 6\. Reported as Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 59 | MCARR_IDNAME\ | 1\. Not Applicable\ | 96 (94.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. 57386074\ | 2 ( 2.0%)\ | (67.1%) | (32.9%) |
## | | | 3\. 5700083642\ | 1 ( 1.0%)\ | | |
## | | | 4\. 572154496\ | 1 ( 1.0%)\ | | |
## | | | 5\. 57471318\ | 1 ( 1.0%)\ | | |
## | | | 6\. Reported as Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 60 | GVWRNAME\ | 1\. Not Applicable\ | 50 (94.3%)\ | 53\ | 99\ |
## | | [factor] | 2\. 26,001 lbs. or more | 3 ( 5.7%) | (34.9%) | (65.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 61 | V_CONFIGNAME\ | 1\. Not Applicable\ | 96 (94.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. Single-Unit Truck (2- axl\ | 2 ( 2.0%)\ | (67.1%) | (32.9%) |
## | | | 3\. Truck Tractor/Semi-Traile\ | 2 ( 2.0%)\ | | |
## | | | 4\. Single-Unit Truck (3 or m\ | 1 ( 1.0%)\ | | |
## | | | 5\. Truck Tractor/Double | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 62 | CARGO_BTNAME\ | 1\. Not Applicable (N/A)\ | 96 (94.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. Unknown Cargo Body Type\ | 2 ( 2.0%)\ | (67.1%) | (32.9%) |
## | | | 3\. Van/Enclosed Box\ | 2 ( 2.0%)\ | | |
## | | | 4\. Grain/ Chips/ Gravel\ | 1 ( 1.0%)\ | | |
## | | | 5\. No Cargo Body Type | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 63 | HAZ_INVNAME\ | 1\. No | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 64 | HAZ_PLACNAME\ | 1\. Not Applicable | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 65 | HAZ_IDNAME\ | 1\. Not Applicable | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 66 | HAZ_CNONAME\ | 1\. Not Applicable | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 67 | HAZ_RELNAME\ | 1\. Not Applicable | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 68 | BUS_USENAME\ | 1\. Not a Bus | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 69 | SPEC_USENAME\ | 1\. No Special Use\ | 66 (64.7%)\ | 102\ | 50\ |
## | | [factor] | 2\. No Special Use Noted\ | 31 (30.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. No Special Use\<a0\>Noted | 5 ( 4.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 70 | EMER_USENAME\ | 1\. Not Applicable | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 71 | TRAV_SPNAME\ | 1\. Not Reported\ | 52 (51.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. Unknown\ | 6 ( 5.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. 055 MPH\ | 5 ( 4.9%)\ | | |
## | | | 4\. Reported as Unknown\ | 5 ( 4.9%)\ | | |
## | | | 5\. 045 MPH\ | 4 ( 3.9%)\ | | |
## | | | 6\. 050 MPH\ | 4 ( 3.9%)\ | | |
## | | | 7\. 040 MPH\ | 3 ( 2.9%)\ | | |
## | | | 8\. 015 MPH\ | 2 ( 2.0%)\ | | |
## | | | 9\. 025 MPH\ | 2 ( 2.0%)\ | | |
## | | | 10\. 048 MPH\ | 2 ( 2.0%)\ | | |
## | | | 11\. 060 MPH\ | 2 ( 2.0%)\ | | |
## | | | 12\. Stopped Motor Vehicle In-\ | 2 ( 2.0%)\ | | |
## | | | 13\. 003 MPH\ | 1 ( 1.0%)\ | | |
## | | | 14\. 008 MPH\ | 1 ( 1.0%)\ | | |
## | | | 15\. 010 MPH\ | 1 ( 1.0%)\ | | |
## | | | 16\. 012 MPH\ | 1 ( 1.0%)\ | | |
## | | | 17\. 020 MPH\ | 1 ( 1.0%)\ | | |
## | | | 18\. 026 MPH\ | 1 ( 1.0%)\ | | |
## | | | 19\. 030 MPH\ | 1 ( 1.0%)\ | | |
## | | | 20\. 033 MPH\ | 1 ( 1.0%)\ | | |
## | | | 21\. 035 MPH\ | 1 ( 1.0%)\ | | |
## | | | 22\. 042 MPH\ | 1 ( 1.0%)\ | | |
## | | | 23\. 053 MPH\ | 1 ( 1.0%)\ | | |
## | | | 24\. 058 MPH\ | 1 ( 1.0%)\ | | |
## | | | 25\. 072 MPH | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 72 | UNDERIDENAME\ | 1\. No Underride or Override | 66 (100.0%) | 66\ | 86\ |
## | | [factor] | | | (43.4%) | (56.6%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 73 | ROLLOVERNAME\ | 1\. No Rollover\ | 100 (98.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Applicable | 2 ( 2.0%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 74 | ROLINLOCNAME\ | 1\. No Rollover\ | 100 (98.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Applicable | 2 ( 2.0%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 75 | IMPACT1NAME\ | 1\. 12 Clock Point\ | 69 (67.6%)\ | 102\ | 50\ |
## | | [factor] | 2\. 1 Clock Point\ | 7 ( 6.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. 11 Clock Point\ | 6 ( 5.9%)\ | | |
## | | | 4\. 5 Clock Point\ | 4 ( 3.9%)\ | | |
## | | | 5\. 9 Clock Point\ | 3 ( 2.9%)\ | | |
## | | | 6\. 3 Clock Point\ | 2 ( 2.0%)\ | | |
## | | | 7\. Left\ | 2 ( 2.0%)\ | | |
## | | | 8\. Right\ | 2 ( 2.0%)\ | | |
## | | | 9\. 10 Clock Point\ | 1 ( 1.0%)\ | | |
## | | | 10\. 4 Clock Point\ | 1 ( 1.0%)\ | | |
## | | | 11\. 8 Clock Point\ | 1 ( 1.0%)\ | | |
## | | | 12\. Left-Back Side\ | 1 ( 1.0%)\ | | |
## | | | 13\. Left-Front Side\ | 1 ( 1.0%)\ | | |
## | | | 14\. Right-Back Side\ | 1 ( 1.0%)\ | | |
## | | | 15\. Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 76 | DEFORMEDNAME\ | 1\. Disabling Damage\ | 34 (33.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Minor Damage\ | 32 (31.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. Functional Damage\ | 16 (15.7%)\ | | |
## | | | 4\. Not Reported\ | 10 ( 9.8%)\ | | |
## | | | 5\. Damage Reported, Extent U\ | 5 ( 4.9%)\ | | |
## | | | 6\. No Damage\ | 3 ( 2.9%)\ | | |
## | | | 7\. Reported as Unknown\ | 1 ( 1.0%)\ | | |
## | | | 8\. Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 77 | TOWEDNAME\ | 1\. Not Towed\ | 41 (40.2%)\ | 102\ | 50\ |
## | | [factor] | 2\. Towed Due to Disabling Da\ | 23 (22.5%)\ | (67.1%) | (32.9%) |
## | | | 3\. Towed\ | 21 (20.6%)\ | | |
## | | | 4\. Towed Not Due to Disablin\ | 10 ( 9.8%)\ | | |
## | | | 5\. Towed But Not Due to Disa\ | 6 ( 5.9%)\ | | |
## | | | 6\. Towed, Unknown Reason | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 78 | M_HARMNAME\ | 1\. Motor Vehicle In-Transpor\ | 37 (36.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Pedalcyclist\ | 32 (31.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. Pedestrian\ | 30 (29.4%)\ | | |
## | | | 4\. Utility Pole/Light Suppor\ | 2 ( 2.0%)\ | | |
## | | | 5\. Motor Vehicle In-Transpor | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 79 | VEH_SC1NAME\ | 1\. None | 53 (100.0%) | 53\ | 99\ |
## | | [factor] | | | (34.9%) | (65.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 80 | VEH_SC2NAME\ | 1\. None | 53 (100.0%) | 53\ | 99\ |
## | | [factor] | | | (34.9%) | (65.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 81 | FIRE_EXPNAME\ | 1\. No or Not Reported\ | 100 (98.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. Yes | 2 ( 2.0%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 82 | DR_PRESNAME\ | 1\. Yes | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 83 | L_STATENAME\ | 1\. California\ | 16 (15.7%)\ | 102\ | 50\ |
## | | [factor] | 2\. Florida\ | 11 (10.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. New Jersey\ | 10 ( 9.8%)\ | | |
## | | | 4\. Michigan\ | 9 ( 8.8%)\ | | |
## | | | 5\. Illinois\ | 8 ( 7.8%)\ | | |
## | | | 6\. Wisconsin\ | 8 ( 7.8%)\ | | |
## | | | 7\. Texas\ | 7 ( 6.9%)\ | | |
## | | | 8\. District of Columbia\ | 4 ( 3.9%)\ | | |
## | | | 9\. North Carolina\ | 4 ( 3.9%)\ | | |
## | | | 10\. New York\ | 3 ( 2.9%)\ | | |
## | | | 11\. Washington\ | 3 ( 2.9%)\ | | |
## | | | 12\. Alaska\ | 2 ( 2.0%)\ | | |
## | | | 13\. Colorado\ | 2 ( 2.0%)\ | | |
## | | | 14\. Delaware\ | 2 ( 2.0%)\ | | |
## | | | 15\. Georgia\ | 2 ( 2.0%)\ | | |
## | | | 16\. Massachusetts\ | 2 ( 2.0%)\ | | |
## | | | 17\. Ohio\ | 2 ( 2.0%)\ | | |
## | | | 18\. Indiana\ | 1 ( 1.0%)\ | | |
## | | | 19\. New Mexico\ | 1 ( 1.0%)\ | | |
## | | | 20\. Oregon\ | 1 ( 1.0%)\ | | |
## | | | 21\. Reported as Unknown\ | 1 ( 1.0%)\ | | |
## | | | 22\. South Carolina\ | 1 ( 1.0%)\ | | |
## | | | 23\. Unknown\ | 1 ( 1.0%)\ | | |
## | | | 24\. Utah | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 84 | L_STATUSNAME\ | 1\. Valid\ | 85 (83.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Suspended\ | 6 ( 5.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Not licensed\ | 5 ( 4.9%)\ | | |
## | | | 4\. Expired\ | 4 ( 3.9%)\ | | |
## | | | 5\. Unknown License Status | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 85 | L_TYPENAME\ | 1\. Full Driver License\ | 95 (93.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Licensed\ | 5 ( 4.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Unknown License Type | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 86 | CDL_STATNAME\ | 1\. No (CDL)\ | 91 (89.2%)\ | 102\ | 50\ |
## | | [factor] | 2\. Valid\ | 7 ( 6.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Unknown License Status\ | 2 ( 2.0%)\ | | |
## | | | 4\. Disqualified\ | 1 ( 1.0%)\ | | |
## | | | 5\. Expired | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 87 | L_ENDORSNAME\ | 1\. No Endorsements required \ | 97 (95.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. Endorsement(s) Required, \ | 3 ( 2.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Endorsement(s) Required, \ | 1 ( 1.0%)\ | | |
## | | | 4\. Unknown, if required | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 88 | L_COMPLNAME\ | 1\. Valid license for this cl\ | 80 (78.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. No valid license for this\ | 8 ( 7.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. No license required for t\ | 7 ( 6.9%)\ | | |
## | | | 4\. Not licensed\ | 5 ( 4.9%)\ | | |
## | | | 5\. Unknown | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 89 | L_RESTRINAME\ | 1\. No Restrictions or Not Ap\ | 67 (65.7%)\ | 102\ | 50\ |
## | | [factor] | 2\. Restrictions, Compliance \ | 30 (29.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. Restrictions Complied Wit\ | 3 ( 2.9%)\ | | |
## | | | 4\. Unknown | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 90 | DR_HGT\ | 1\. 999\ | 13 (12.7%)\ | 102\ | 50\ |
## | | [factor] | 2\. 68\ | 11 (10.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. 66\ | 10 ( 9.8%)\ | | |
## | | | 4\. 67\ | 10 ( 9.8%)\ | | |
## | | | 5\. 62\ | 8 ( 7.8%)\ | | |
## | | | 6\. 69\ | 8 ( 7.8%)\ | | |
## | | | 7\. 70\ | 7 ( 6.9%)\ | | |
## | | | 8\. 71\ | 6 ( 5.9%)\ | | |
## | | | 9\. 73\ | 5 ( 4.9%)\ | | |
## | | | 10\. 63\ | 4 ( 3.9%)\ | | |
## | | | 11\. 72\ | 4 ( 3.9%)\ | | |
## | | | 12\. 65\ | 3 ( 2.9%)\ | | |
## | | | 13\. 74\ | 3 ( 2.9%)\ | | |
## | | | 14\. 60\ | 2 ( 2.0%)\ | | |
## | | | 15\. 64\ | 2 ( 2.0%)\ | | |
## | | | 16\. 76\ | 2 ( 2.0%)\ | | |
## | | | 17\. 77\ | 2 ( 2.0%)\ | | |
## | | | 18\. 61\ | 1 ( 1.0%)\ | | |
## | | | 19\. 80 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 91 | DR_WGTNAME\ | 1\. Unknown\ | 41 (40.2%)\ | 102\ | 50\ |
## | | [factor] | 2\. 210 lbs.\ | 4 ( 3.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. 220 lbs.\ | 4 ( 3.9%)\ | | |
## | | | 4\. 130 lbs.\ | 3 ( 2.9%)\ | | |
## | | | 5\. 140 lbs.\ | 3 ( 2.9%)\ | | |
## | | | 6\. 165 lbs.\ | 3 ( 2.9%)\ | | |
## | | | 7\. 180 lbs.\ | 3 ( 2.9%)\ | | |
## | | | 8\. 190 lbs.\ | 3 ( 2.9%)\ | | |
## | | | 9\. 260 lbs.\ | 3 ( 2.9%)\ | | |
## | | | 10\. 125 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 11\. 135 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 12\. 155 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 13\. 160 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 14\. 175 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 15\. 184 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 16\. 198 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 17\. 290 lbs.\ | 2 ( 2.0%)\ | | |
## | | | 18\. 100 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 19\. 110 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 20\. 118 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 21\. 121 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 22\. 145 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 23\. 169 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 24\. 170 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 25\. 183 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 26\. 185 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 27\. 195 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 28\. 199 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 29\. 200 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 30\. 204 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 31\. 205 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 32\. 207 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 33\. 225 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 34\. 235 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 35\. 256 lbs.\ | 1 ( 1.0%)\ | | |
## | | | 36\. 330 lbs. | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 92 | PREV_ACCNAME\ | 1\. None\ | 79 (77.5%)\ | 102\ | 50\ |
## | | [factor] | 2\. 1\ | 10 ( 9.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Unknown\ | 8 ( 7.8%)\ | | |
## | | | 4\. 2\ | 3 ( 2.9%)\ | | |
## | | | 5\. Crashes Not Reported on D | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 93 | PREV_SUSNAME\ | 1\. None\ | 16 (66.7%)\ | 24\ | 128\ |
## | | [factor] | 2\. Unknown\ | 5 (20.8%)\ | (15.8%) | (84.2%) |
## | | | 3\. 1 | 3 (12.5%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 94 | PREV_DWINAME\ | 1\. None\ | 89 (87.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Unknown\ | 8 ( 7.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. 1\ | 4 ( 3.9%)\ | | |
## | | | 4\. 2 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 95 | PREV_SPDNAME\ | 1\. None\ | 85 (83.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Unknown\ | 8 ( 7.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. 1\ | 6 ( 5.9%)\ | | |
## | | | 4\. 7\ | 2 ( 2.0%)\ | | |
## | | | 5\. 2 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 96 | PREV_OTHNAME\ | 1\. None\ | 75 (73.5%)\ | 102\ | 50\ |
## | | [factor] | 2\. 1\ | 10 ( 9.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Unknown\ | 8 ( 7.8%)\ | | |
## | | | 4\. 2\ | 6 ( 5.9%)\ | | |
## | | | 5\. 3\ | 1 ( 1.0%)\ | | |
## | | | 6\. 4\ | 1 ( 1.0%)\ | | |
## | | | 7\. 8 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 97 | FIRST_MONAME\ | 1\. No Record\ | 51 (50.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. September\ | 10 ( 9.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. March\ | 9 ( 8.8%)\ | | |
## | | | 4\. Unknown\ | 8 ( 7.8%)\ | | |
## | | | 5\. January\ | 4 ( 3.9%)\ | | |
## | | | 6\. May\ | 4 ( 3.9%)\ | | |
## | | | 7\. April\ | 3 ( 2.9%)\ | | |
## | | | 8\. August\ | 3 ( 2.9%)\ | | |
## | | | 9\. November\ | 3 ( 2.9%)\ | | |
## | | | 10\. February\ | 2 ( 2.0%)\ | | |
## | | | 11\. June\ | 2 ( 2.0%)\ | | |
## | | | 12\. December\ | 1 ( 1.0%)\ | | |
## | | | 13\. July\ | 1 ( 1.0%)\ | | |
## | | | 14\. October | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 98 | FIRST_YRNAME\ | 1\. No Record\ | 51 (50.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. 2015\ | 11 (10.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. 2013\ | 9 ( 8.8%)\ | | |
## | | | 4\. Unknown\ | 8 ( 7.8%)\ | | |
## | | | 5\. 2019\ | 6 ( 5.9%)\ | | |
## | | | 6\. 2016\ | 5 ( 4.9%)\ | | |
## | | | 7\. 2017\ | 3 ( 2.9%)\ | | |
## | | | 8\. 2020\ | 3 ( 2.9%)\ | | |
## | | | 9\. 2018\ | 2 ( 2.0%)\ | | |
## | | | 10\. 2012\ | 1 ( 1.0%)\ | | |
## | | | 11\. 2014\ | 1 ( 1.0%)\ | | |
## | | | 12\. 2022\ | 1 ( 1.0%)\ | | |
## | | | 13\. 2023 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 99 | LAST_MONAME\ | 1\. No Record\ | 51 (50.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. September\ | 13 (12.7%)\ | (67.1%) | (32.9%) |
## | | | 3\. Unknown\ | 8 ( 7.8%)\ | | |
## | | | 4\. April\ | 5 ( 4.9%)\ | | |
## | | | 5\. January\ | 5 ( 4.9%)\ | | |
## | | | 6\. November\ | 5 ( 4.9%)\ | | |
## | | | 7\. February\ | 4 ( 3.9%)\ | | |
## | | | 8\. August\ | 3 ( 2.9%)\ | | |
## | | | 9\. July\ | 2 ( 2.0%)\ | | |
## | | | 10\. May\ | 2 ( 2.0%)\ | | |
## | | | 11\. October\ | 2 ( 2.0%)\ | | |
## | | | 12\. December\ | 1 ( 1.0%)\ | | |
## | | | 13\. June | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 100 | LAST_YRNAME\ | 1\. No Record\ | 51 (50.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. Unknown\ | 8 ( 7.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. 2016\ | 7 ( 6.9%)\ | | |
## | | | 4\. 2017\ | 7 ( 6.9%)\ | | |
## | | | 5\. 2013\ | 6 ( 5.9%)\ | | |
## | | | 6\. 2021\ | 6 ( 5.9%)\ | | |
## | | | 7\. 2018\ | 5 ( 4.9%)\ | | |
## | | | 8\. 2019\ | 5 ( 4.9%)\ | | |
## | | | 9\. 2020\ | 2 ( 2.0%)\ | | |
## | | | 10\. 2012\ | 1 ( 1.0%)\ | | |
## | | | 11\. 2014\ | 1 ( 1.0%)\ | | |
## | | | 12\. 2015\ | 1 ( 1.0%)\ | | |
## | | | 13\. 2022\ | 1 ( 1.0%)\ | | |
## | | | 14\. 2023 | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 101 | SPEEDRELNAME\ | 1\. No\ | 87 (85.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Yes, Specifics Unknown\ | 5 ( 4.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Yes, Too Fast for Conditi\ | 4 ( 3.9%)\ | | |
## | | | 4\. Reported as Unknown\ | 3 ( 2.9%)\ | | |
## | | | 5\. Unknown | 3 ( 2.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 102 | DR_SF1NAME\ | 1\. None\ | 29 (54.7%)\ | 53\ | 99\ |
## | | [factor] | 2\. Failure to Yield Right-of\ | 11 (20.8%)\ | (34.9%) | (65.1%) |
## | | | 3\. Failure to Obey Actual Tr\ | 4 ( 7.5%)\ | | |
## | | | 4\. Operating the Vehicle in \ | 3 ( 5.7%)\ | | |
## | | | 5\. Improper or Erratic Lane \ | 2 ( 3.8%)\ | | |
## | | | 6\. Unknown\ | 2 ( 3.8%)\ | | |
## | | | 7\. Careless Driving\ | 1 ( 1.9%)\ | | |
## | | | 8\. Pedestrian, Pedal Cyclist | 1 ( 1.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 103 | DR_SF2NAME\ | 1\. None\ | 44 (83.0%)\ | 53\ | 99\ |
## | | [factor] | 2\. Failure to Yield Right-of\ | 2 ( 3.8%)\ | (34.9%) | (65.1%) |
## | | | 3\. Operating the Vehicle in \ | 2 ( 3.8%)\ | | |
## | | | 4\. Unknown\ | 2 ( 3.8%)\ | | |
## | | | 5\. Careless Driving\ | 1 ( 1.9%)\ | | |
## | | | 6\. Failure to Obey Actual Tr\ | 1 ( 1.9%)\ | | |
## | | | 7\. Unfamiliar with Roadway | 1 ( 1.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 104 | DR_SF3NAME\ | 1\. None\ | 50 (94.3%)\ | 53\ | 99\ |
## | | [factor] | 2\. Unknown\ | 2 ( 3.8%)\ | (34.9%) | (65.1%) |
## | | | 3\. Alcohol and/or Drug Test | 1 ( 1.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 105 | DR_SF4NAME\ | 1\. None\ | 51 (96.2%)\ | 53\ | 99\ |
## | | [factor] | 2\. Unknown | 2 ( 3.8%) | (34.9%) | (65.1%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 106 | VTRAFWAYNAME\ | 1\. Two-Way, Not Divided\ | 55 (53.9%)\ | 102\ | 50\ |
## | | [factor] | 2\. Two-Way, Divided, Unprote\ | 16 (15.7%)\ | (67.1%) | (32.9%) |
## | | | 3\. Non-Trafficway or Drivewa\ | 12 (11.8%)\ | | |
## | | | 4\. Two-Way, Divided, Positi\ | 10 ( 9.8%)\ | | |
## | | | 5\. Two-Way, Not Divided With\ | 5 ( 4.9%)\ | | |
## | | | 6\. One-Way Trafficway\ | 3 ( 2.9%)\ | | |
## | | | 7\. Two-Way, Divided, Unprot | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 107 | VNUM_LANNAME\ | 1\. Two lanes\ | 60 (58.8%)\ | 102\ | 50\ |
## | | [factor] | 2\. Four lanes\ | 12 (11.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Non-Trafficway or Drivewa\ | 12 (11.8%)\ | | |
## | | | 4\. Three lanes\ | 9 ( 8.8%)\ | | |
## | | | 5\. Five lanes\ | 6 ( 5.9%)\ | | |
## | | | 6\. One lane | 3 ( 2.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 108 | VSPD_LIMNAME\ | 1\. 35 MPH\ | 20 (19.6%)\ | 102\ | 50\ |
## | | [factor] | 2\. 55 MPH\ | 17 (16.7%)\ | (67.1%) | (32.9%) |
## | | | 3\. 45 MPH\ | 16 (15.7%)\ | | |
## | | | 4\. No Statutory Limit/Non-Tr\ | 14 (13.7%)\ | | |
## | | | 5\. 30 MPH\ | 9 ( 8.8%)\ | | |
## | | | 6\. 25 MPH\ | 7 ( 6.9%)\ | | |
## | | | 7\. 40 MPH\ | 7 ( 6.9%)\ | | |
## | | | 8\. Not Reported\ | 4 ( 3.9%)\ | | |
## | | | 9\. 50 MPH\ | 3 ( 2.9%)\ | | |
## | | | 10\. 65 MPH\ | 3 ( 2.9%)\ | | |
## | | | 11\. 10 MPH | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 109 | VALIGNNAME\ | 1\. Straight\ | 86 (84.3%)\ | 102\ | 50\ |
## | | [factor] | 2\. Non-Trafficway or Drivewa\ | 12 (11.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Curve - Left\ | 1 ( 1.0%)\ | | |
## | | | 4\. Curve - Right\ | 1 ( 1.0%)\ | | |
## | | | 5\. Curve Right\ | 1 ( 1.0%)\ | | |
## | | | 6\. Not Reported | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 110 | VPROFILENAME\ | 1\. Level\ | 56 (54.9%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Reported\ | 14 (13.7%)\ | (67.1%) | (32.9%) |
## | | | 3\. Grade, Unknown Slope\ | 13 (12.7%)\ | | |
## | | | 4\. Non-Trafficway or Drivewa\ | 12 (11.8%)\ | | |
## | | | 5\. Uphill\ | 4 ( 3.9%)\ | | |
## | | | 6\. Downhill\ | 2 ( 2.0%)\ | | |
## | | | 7\. Sag (Bottom) | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 111 | VPAVETYPNAME\ | 1\. Blacktop, Bituminous, or \ | 55 (53.9%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Reported\ | 29 (28.4%)\ | (67.1%) | (32.9%) |
## | | | 3\. Non-Trafficway or Drivewa\ | 12 (11.8%)\ | | |
## | | | 4\. Concrete\ | 5 ( 4.9%)\ | | |
## | | | 5\. Other | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 112 | VSURCONDNAME\ | 1\. Dry\ | 84 (82.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. Non-Trafficway or Drivewa\ | 12 (11.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Wet\ | 4 ( 3.9%)\ | | |
## | | | 4\. Snow | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 113 | VTRAFCONNAME\ | 1\. No Controls\ | 45 (44.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. Traffic control signal (o\ | 12 (11.8%)\ | (67.1%) | (32.9%) |
## | | | 3\. Stop Sign\ | 11 (10.8%)\ | | |
## | | | 4\. Other Regulatory Sign\ | 9 ( 8.8%)\ | | |
## | | | 5\. Traffic control signal(on\ | 7 ( 6.9%)\ | | |
## | | | 6\. Flashing Traffic Control \ | 6 ( 5.9%)\ | | |
## | | | 7\. Other\ | 5 ( 4.9%)\ | | |
## | | | 8\. Not Reported\ | 3 ( 2.9%)\ | | |
## | | | 9\. Warning Sign\ | 2 ( 2.0%)\ | | |
## | | | 10\. Yield Sign | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 114 | VTCONT_FNAME\ | 1\. Device Functioning Proper\ | 48 (47.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. No Controls\ | 45 (44.1%)\ | (67.1%) | (32.9%) |
## | | | 3\. Device Not Functioning or\ | 4 ( 3.9%)\ | | |
## | | | 4\. Not Reported\ | 3 ( 2.9%)\ | | |
## | | | 5\. Device Not Functioning | 2 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 115 | P_CRASH1NAME\ | 1\. Going Straight\ | 82 (80.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. Changing Lanes\ | 5 ( 4.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Turning Left\ | 4 ( 3.9%)\ | | |
## | | | 4\. Negotiating a Curve\ | 3 ( 2.9%)\ | | |
## | | | 5\. Turning Right\ | 3 ( 2.9%)\ | | |
## | | | 6\. Making a U-turn\ | 2 ( 2.0%)\ | | |
## | | | 7\. Stopped in Roadway\ | 2 ( 2.0%)\ | | |
## | | | 8\. Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 116 | P_CRASH2NAME\ | 1\. Pedalcyclist or other non\ | 29 (28.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. Pedestrian in road\ | 28 (27.5%)\ | (67.1%) | (32.9%) |
## | | | 3\. Other critical precrash e\ | 8 ( 7.8%)\ | | |
## | | | 4\. Crossing Over (Passing Th\ | 5 ( 4.9%)\ | | |
## | | | 5\. Crossing over (passing th\ | 4 ( 3.9%)\ | | |
## | | | 6\. From opposite direction \ | 4 ( 3.9%)\ | | |
## | | | 7\. From Parking Lane/Shoulde\ | 4 ( 3.9%)\ | | |
## | | | 8\. Over the lane line on lef\ | 4 ( 3.9%)\ | | |
## | | | 9\. From crossing street, acr\ | 3 ( 2.9%)\ | | |
## | | | 10\. In crossover\ | 3 ( 2.9%)\ | | |
## | | | 11\. Turning Left\ | 3 ( 2.9%)\ | | |
## | | | 12\. Making a U-Turn\ | 2 ( 2.0%)\ | | |
## | | | 13\. Pedalcyclist or other non\ | 2 ( 2.0%)\ | | |
## | | | 14\. Encroachment by other veh\ | 1 ( 1.0%)\ | | |
## | | | 15\. Pedestrian unknown locati\ | 1 ( 1.0%)\ | | |
## | | | 16\. Traveling in same directi | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 117 | P_CRASH3NAME\ | 1\. Unknown/Not Reported\ | 45 (44.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. No Avoidance Maneuver\ | 38 (37.3%)\ | (67.1%) | (32.9%) |
## | | | 3\. Braking\ | 10 ( 9.8%)\ | | |
## | | | 4\. Steering left\ | 3 ( 2.9%)\ | | |
## | | | 5\. Steering right\ | 3 ( 2.9%)\ | | |
## | | | 6\. Braking and steering left\ | 2 ( 2.0%)\ | | |
## | | | 7\. Braking and steering righ | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 118 | PCRASH4NAME\ | 1\. Tracking\ | 93 (91.2%)\ | 102\ | 50\ |
## | | [factor] | 2\. Precrash stability unknow\ | 5 ( 4.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Skidding longitudinally | 4 ( 3.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 119 | PCRASH5NAME\ | 1\. Stayed in original travel\ | 81 (79.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. Stayed on roadway, but le\ | 7 ( 6.9%)\ | (67.1%) | (32.9%) |
## | | | 3\. Entered roadway\ | 6 ( 5.9%)\ | | |
## | | | 4\. Stayed on roadway, not kn\ | 3 ( 2.9%)\ | | |
## | | | 5\. Returned to roadway\ | 2 ( 2.0%)\ | | |
## | | | 6\. Unknown\ | 2 ( 2.0%)\ | | |
## | | | 7\. Departed roadway | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 120 | ACC_TYPENAME\ | 1\. C13-Single Driver-Forward\ | 48 (59.3%)\ | 81\ | 71\ |
## | | [factor] | 2\. L88-Intersecting Paths-St\ | 6 ( 7.4%)\ | (53.3%) | (46.7%) |
## | | | 3\. L86-Intersecting Paths-St\ | 4 ( 4.9%)\ | | |
## | | | 4\. L89-Intersecting Paths-St\ | 4 ( 4.9%)\ | | |
## | | | 5\. M98-Other Crash Type\ | 4 ( 4.9%)\ | | |
## | | | 6\. L87-Intersecting Paths-St\ | 3 ( 3.7%)\ | | |
## | | | 7\. F45-Same Trafficway, Same\ | 2 ( 2.5%)\ | | |
## | | | 8\. F47-Same Trafficway, Same\ | 2 ( 2.5%)\ | | |
## | | | 9\. J68-Trafficway Vehicle Tu\ | 2 ( 2.5%)\ | | |
## | | | 10\. J69-Trafficway Vehicle Tu\ | 2 ( 2.5%)\ | | |
## | | | 11\. L90-Intersecting Paths-St\ | 2 ( 2.5%)\ | | |
## | | | 12\. J70-Trafficway Vehicle Tu\ | 1 ( 1.2%)\ | | |
## | | | 13\. J71-Trafficway Vehicle Tu | 1 ( 1.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 121 | DEATHS\ | 1\. 0\ | 84 (82.4%)\ | 102\ | 50\ |
## | | [factor] | 2\. 1 | 18 (17.6%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 122 | DR_DRINKNAME\ | 1\. No\ | 93 (91.2%)\ | 102\ | 50\ |
## | | [factor] | 2\. Yes | 9 ( 8.8%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 123 | TRLR1VINNAME\ | 1\. No Trailing Units\ | 98 (96.1%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Reported\ | 2 ( 2.0%)\ | (67.1%) | (32.9%) |
## | | | 3\. 1TTF502S2H39\ | 1 ( 1.0%)\ | | |
## | | | 4\. Unknown | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 124 | TRLR2VINNAME\ | 1\. No Trailing Units\ | 101 (99.0%)\ | 102\ | 50\ |
## | | [factor] | 2\. Not Reported | 1 ( 1.0%) | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 125 | TRLR3VINNAME\ | 1\. No Trailing Units | 102 (100.0%) | 102\ | 50\ |
## | | [factor] | | | (67.1%) | (32.9%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 126 | PREV_SUS1NAME\ | 1\. None\ | 75 (96.2%)\ | 78\ | 74\ |
## | | [factor] | 2\. Unknown | 3 ( 3.8%) | (51.3%) | (48.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 127 | PREV_SUS2NAME\ | 1\. None\ | 75 (96.2%)\ | 78\ | 74\ |
## | | [factor] | 2\. Unknown | 3 ( 3.8%) | (51.3%) | (48.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 128 | PREV_SUS3NAME\ | 1\. None\ | 62 (79.5%)\ | 78\ | 74\ |
## | | [factor] | 2\. 1\ | 4 ( 5.1%)\ | (51.3%) | (48.7%) |
## | | | 3\. 14\ | 4 ( 5.1%)\ | | |
## | | | 4\. 2\ | 4 ( 5.1%)\ | | |
## | | | 5\. Unknown\ | 3 ( 3.8%)\ | | |
## | | | 6\. 6 | 1 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 129 | PER_NO\ | 1\. 1\ | 133 (87.5%)\ | 152\ | 0\ |
## | | [factor] | 2\. 2\ | 17 (11.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 3\ | 1 ( 0.7%)\ | | |
## | | | 4\. 4 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 130 | STR_VEH\ | 1\. 0\ | 102 (67.1%)\ | 152\ | 0\ |
## | | [factor] | 2\. 1 | 50 (32.9%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 131 | MOD_YEARNAME\ | 1\. (Empty string)\ | 50 (32.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 2013\ | 11 ( 7.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2009\ | 10 ( 6.6%)\ | | |
## | | | 4\. 2004\ | 8 ( 5.3%)\ | | |
## | | | 5\. 2017\ | 7 ( 4.6%)\ | | |
## | | | 6\. 2012\ | 6 ( 3.9%)\ | | |
## | | | 7\. 2014\ | 6 ( 3.9%)\ | | |
## | | | 8\. 2006\ | 5 ( 3.3%)\ | | |
## | | | 9\. 2003\ | 4 ( 2.6%)\ | | |
## | | | 10\. 2005\ | 4 ( 2.6%)\ | | |
## | | | 11\. 2008\ | 4 ( 2.6%)\ | | |
## | | | 12\. 2010\ | 4 ( 2.6%)\ | | |
## | | | 13\. 2015\ | 4 ( 2.6%)\ | | |
## | | | 14\. 2016\ | 4 ( 2.6%)\ | | |
## | | | 15\. 1998\ | 3 ( 2.0%)\ | | |
## | | | 16\. 1999\ | 3 ( 2.0%)\ | | |
## | | | 17\. 2011\ | 3 ( 2.0%)\ | | |
## | | | 18\. 2000\ | 2 ( 1.3%)\ | | |
## | | | 19\. 2001\ | 2 ( 1.3%)\ | | |
## | | | 20\. 2019\ | 2 ( 1.3%)\ | | |
## | | | 21\. Unknown\ | 2 ( 1.3%)\ | | |
## | | | 22\. 1991\ | 1 ( 0.7%)\ | | |
## | | | 23\. 1994\ | 1 ( 0.7%)\ | | |
## | | | 24\. 1997\ | 1 ( 0.7%)\ | | |
## | | | 25\. 2002\ | 1 ( 0.7%)\ | | |
## | | | 26\. 2007\ | 1 ( 0.7%)\ | | |
## | | | 27\. 2018\ | 1 ( 0.7%)\ | | |
## | | | 28\. 2020\ | 1 ( 0.7%)\ | | |
## | | | 29\. 2022 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 132 | SEXNAME\ | 1\. Male\ | 96 (63.2%)\ | 152\ | 0\ |
## | | [factor] | 2\. Female\ | 55 (36.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Reported as Unknown | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 133 | PER_TYPNAME\ | 1\. Driver of a Motor Vehicle\ | 84 (55.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Pedestrian\ | 27 (17.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Bicyclist\ | 23 (15.1%)\ | | |
## | | | 4\. Passenger of a Motor Vehi | 18 (11.8%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 134 | INJ_SEVNAME\ | 1\. No Apparent Injury (O)\ | 76 (50.0%)\ | 152\ | 0\ |
## | | [factor] | 2\. Fatal Injury (K)\ | 64 (42.1%)\ | (100.0%) | (0.0%) |
## | | | 3\. Suspected Serious Injury \ | 4 ( 2.6%)\ | | |
## | | | 4\. Suspected Minor Injury (B\ | 3 ( 2.0%)\ | | |
## | | | 5\. Unknown/Not Reported\ | 3 ( 2.0%)\ | | |
## | | | 6\. Possible Injury (C) | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 135 | SEAT_POSNAME\ | 1\. Front Seat, Left Side\ | 84 (55.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 50 (32.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Front Seat, Right Side\ | 12 ( 7.9%)\ | | |
## | | | 4\. Second Seat, Left Side\ | 3 ( 2.0%)\ | | |
## | | | 5\. Second Seat, Right Side\ | 2 ( 1.3%)\ | | |
## | | | 6\. Second Seat, Middle | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 136 | REST_USENAME\ | 1\. Shoulder and Lap Belt Use\ | 75 (49.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 50 (32.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. None Used/Not Applicable\ | 9 ( 5.9%)\ | | |
## | | | 4\. Reported as Unknown\ | 6 ( 3.9%)\ | | |
## | | | 5\. No Helmet\ | 3 ( 2.0%)\ | | |
## | | | 6\. Child Restraint System - \ | 2 ( 1.3%)\ | | |
## | | | 7\. Helmet, Unknown if DOT Co\ | 2 ( 1.3%)\ | | |
## | | | 8\. None Used / Not Applicabl\ | 2 ( 1.3%)\ | | |
## | | | 9\. DOT-Compliant Motorcycle \ | 1 ( 0.7%)\ | | |
## | | | 10\. Not Reported\ | 1 ( 0.7%)\ | | |
## | | | 11\. Unknown | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 137 | REST_MISNAME\ | 1\. Not a Motor Vehicle Occup\ | 50 (32.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. No\ | 41 (27.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. No Indication of Misuse\ | 25 (16.4%)\ | | |
## | | | 4\. No Indication of Mis-Use\ | 20 (13.2%)\ | | |
## | | | 5\. None Used/Not Applicable\ | 15 ( 9.9%)\ | | |
## | | | 6\. Yes, Indication of Mis-Us | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 138 | AIR_BAGNAME\ | 1\. Not Deployed\ | 91 (59.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 50 (32.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Deployment Unknown\ | 3 ( 2.0%)\ | | |
## | | | 4\. Deployed- Combination\ | 2 ( 1.3%)\ | | |
## | | | 5\. Reported as Deployment Un\ | 2 ( 1.3%)\ | | |
## | | | 6\. Deployed- Front\ | 1 ( 0.7%)\ | | |
## | | | 7\. Deployed- Side (door, sea\ | 1 ( 0.7%)\ | | |
## | | | 8\. Deployment- Unknown Locat\ | 1 ( 0.7%)\ | | |
## | | | 9\. Not Reported | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 139 | EJECTIONNAME\ | 1\. Not Ejected\ | 90 (59.2%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not Applicable\ | 56 (36.8%)\ | (100.0%) | (0.0%) |
## | | | 3\. Totally Ejected\ | 4 ( 2.6%)\ | | |
## | | | 4\. Not Reported | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 140 | EJ_PATHNAME\ | 1\. Ejection Path Not Applica\ | 148 (97.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. Ejection Path Unknown\ | 2 ( 1.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Other Path (e.g., back of | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 141 | EXTRICATNAME\ | 1\. Not Extricated or Not App\ | 151 (99.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Unknown | 1 ( 0.7%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 142 | DRINKINGNAME\ | 1\. No (Alcohol Not Involved)\ | 92 (60.5%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 39 (25.7%)\ | (100.0%) | (0.0%) |
## | | | 3\. Reported as Unknown\ | 11 ( 7.2%)\ | | |
## | | | 4\. Yes (Alcohol Involved)\ | 8 ( 5.3%)\ | | |
## | | | 5\. Unknown (Police Reported) | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 143 | ALC_DETNAME\ | 1\. Not Reported\ | 88 (85.4%)\ | 103\ | 49\ |
## | | [factor] | 2\. Evidential Test (breath, \ | 9 ( 8.7%)\ | (67.8%) | (32.2%) |
## | | | 3\. Preliminary Breath Test (\ | 4 ( 3.9%)\ | | |
## | | | 4\. Behavioral\ | 1 ( 1.0%)\ | | |
## | | | 5\. Observed | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 144 | ALC_STATUSNAME\ | 1\. Test Not Given\ | 69 (45.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. Test Given\ | 58 (38.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 24 (15.8%)\ | | |
## | | | 4\. Reported as Unknown if Te | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 145 | ATST_TYPNAME\ | 1\. Test Not Given\ | 69 (45.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. Blood\ | 41 (27.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 25 (16.4%)\ | | |
## | | | 4\. Preliminary Breath Test (\ | 4 ( 2.6%)\ | | |
## | | | 5\. Unknown Test Type\ | 4 ( 2.6%)\ | | |
## | | | 6\. Urine\ | 3 ( 2.0%)\ | | |
## | | | 7\. Breath Test, Unknown Type\ | 2 ( 1.3%)\ | | |
## | | | 8\. Vitreous\ | 2 ( 1.3%)\ | | |
## | | | 9\. Breath Test (AC)\ | 1 ( 0.7%)\ | | |
## | | | 10\. Reported as Unknown if Te | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 146 | ALC_RESNAME\ | 1\. Test Not Given\ | 69 (45.4%)\ | 152\ | 0\ |
## | | [factor] | 2\. 0.000 % BAC\ | 46 (30.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 24 (15.8%)\ | | |
## | | | 4\. Positive Reading with No \ | 2 ( 1.3%)\ | | |
## | | | 5\. 0.035 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 6\. 0.062 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 7\. 0.070 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 8\. 0.096 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 9\. 0.226 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 10\. 0.238 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 11\. 0.239 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 12\. 0.261 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 13\. 0.270 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 14\. 0.280 % BAC\ | 1 ( 0.7%)\ | | |
## | | | 15\. Reported as Unknown if Te | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 147 | DRUGSNAME\ | 1\. No (drugs not involved)\ | 78 (51.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not Reported\ | 55 (36.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Reported as Unknown\ | 8 ( 5.3%)\ | | |
## | | | 4\. Yes (drugs involved)\ | 8 ( 5.3%)\ | | |
## | | | 5\. Unknown | 3 ( 2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 148 | DRUG_DETNAME\ | 1\. Not Reported\ | 92 (89.3%)\ | 103\ | 49\ |
## | | [factor] | 2\. Evidential Test (Blood, U\ | 9 ( 8.7%)\ | (67.8%) | (32.2%) |
## | | | 3\. Behavioral\ | 1 ( 1.0%)\ | | |
## | | | 4\. Drug Recognition Expert ( | 1 ( 1.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 149 | DSTATUSNAME\ | 1\. Test Not Given\ | 78 (51.3%)\ | 152\ | 0\ |
## | | [factor] | 2\. Test Given\ | 47 (30.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not Reported\ | 26 (17.1%)\ | | |
## | | | 4\. Reported as Unknown if Te | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 150 | DRUGTST1NAME\ | 1\. Test Not Given\ | 22 (66.7%)\ | 33\ | 119\ |
## | | [factor] | 2\. Blood\ | 6 (18.2%)\ | (21.7%) | (78.3%) |
## | | | 3\. Not Reported\ | 3 ( 9.1%)\ | | |
## | | | 4\. Urine | 2 ( 6.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 151 | DRUGTST2NAME\ | 1\. Test Not Given\ | 32 (97.0%)\ | 33\ | 119\ |
## | | [factor] | 2\. Blood | 1 ( 3.0%) | (21.7%) | (78.3%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 152 | DRUGTST3NAME\ | 1\. Test Not Given | 33 (100.0%) | 33\ | 119\ |
## | | [factor] | | | (21.7%) | (78.3%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 153 | DRUGRES1NAME\ | 1\. Test Not Given\ | 22 (66.7%)\ | 33\ | 119\ |
## | | [factor] | 2\. Tested, No Drugs Found/Ne\ | 4 (12.1%)\ | (21.7%) | (78.3%) |
## | | | 3\. Not Reported\ | 3 ( 9.1%)\ | | |
## | | | 4\. BENZODIAZEPINES\ | 1 ( 3.0%)\ | | |
## | | | 5\. METHAMPHETAMINE\ | 1 ( 3.0%)\ | | |
## | | | 6\. Midazolam\ | 1 ( 3.0%)\ | | |
## | | | 7\. MORPHINE | 1 ( 3.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 154 | DRUGRES2NAME\ | 1\. Test Not Given\ | 32 (97.0%)\ | 33\ | 119\ |
## | | [factor] | 2\. Other Drug | 1 ( 3.0%) | (21.7%) | (78.3%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 155 | DRUGRES3NAME\ | 1\. Test Not Given | 33 (100.0%) | 33\ | 119\ |
## | | [factor] | | | (21.7%) | (78.3%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 156 | HOSPITALNAME\ | 1\. Not Transported for Treat\ | 52 (34.2%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not Transported\ | 48 (31.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. EMS Ground\ | 45 (29.6%)\ | | |
## | | | 4\. EMS Air\ | 3 ( 2.0%)\ | | |
## | | | 5\. EMS Unknown Mode\ | 2 ( 1.3%)\ | | |
## | | | 6\. Law Enforcement\ | 1 ( 0.7%)\ | | |
## | | | 7\. Transported Unknown Sour | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 157 | DOANAME\ | 1\. Not Applicable\ | 134 (88.2%)\ | 152\ | 0\ |
## | | [factor] | 2\. Died at Scene | 18 (11.8%) | (100.0%) | (0.0%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 158 | DEATH_DANAME\ | 1\. Not Applicable (Non-Fatal\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 14\ | 6 ( 3.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 27\ | 6 ( 3.9%)\ | | |
## | | | 4\. 17\ | 5 ( 3.3%)\ | | |
## | | | 5\. 22\ | 4 ( 2.6%)\ | | |
## | | | 6\. 25\ | 4 ( 2.6%)\ | | |
## | | | 7\. 12\ | 3 ( 2.0%)\ | | |
## | | | 8\. 18\ | 3 ( 2.0%)\ | | |
## | | | 9\. 26\ | 3 ( 2.0%)\ | | |
## | | | 10\. 13\ | 2 ( 1.3%)\ | | |
## | | | 11\. 15\ | 2 ( 1.3%)\ | | |
## | | | 12\. 21\ | 2 ( 1.3%)\ | | |
## | | | 13\. 23\ | 2 ( 1.3%)\ | | |
## | | | 14\. 24\ | 2 ( 1.3%)\ | | |
## | | | 15\. 29\ | 2 ( 1.3%)\ | | |
## | | | 16\. 6\ | 2 ( 1.3%)\ | | |
## | | | 17\. 8\ | 2 ( 1.3%)\ | | |
## | | | 18\. 9\ | 2 ( 1.3%)\ | | |
## | | | 19\. Unknown\ | 2 ( 1.3%)\ | | |
## | | | 20\. 1\ | 1 ( 0.7%)\ | | |
## | | | 21\. 10\ | 1 ( 0.7%)\ | | |
## | | | 22\. 16\ | 1 ( 0.7%)\ | | |
## | | | 23\. 2\ | 1 ( 0.7%)\ | | |
## | | | 24\. 28\ | 1 ( 0.7%)\ | | |
## | | | 25\. 3\ | 1 ( 0.7%)\ | | |
## | | | 26\. 30\ | 1 ( 0.7%)\ | | |
## | | | 27\. 31\ | 1 ( 0.7%)\ | | |
## | | | 28\. 4\ | 1 ( 0.7%)\ | | |
## | | | 29\. 7 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 159 | DEATH_MONAME\ | 1\. Not Applicable (Non-Fatal\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. August\ | 11 ( 7.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. January\ | 7 ( 4.6%)\ | | |
## | | | 4\. June\ | 7 ( 4.6%)\ | | |
## | | | 5\. February\ | 6 ( 3.9%)\ | | |
## | | | 6\. November\ | 6 ( 3.9%)\ | | |
## | | | 7\. September\ | 6 ( 3.9%)\ | | |
## | | | 8\. March\ | 5 ( 3.3%)\ | | |
## | | | 9\. May\ | 4 ( 2.6%)\ | | |
## | | | 10\. October\ | 4 ( 2.6%)\ | | |
## | | | 11\. July\ | 3 ( 2.0%)\ | | |
## | | | 12\. April\ | 2 ( 1.3%)\ | | |
## | | | 13\. Unknown\ | 2 ( 1.3%)\ | | |
## | | | 14\. December | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 160 | DEATH_YRNAME\ | 1\. Not Applicable (Non-fatal\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 2023\ | 11 ( 7.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2018\ | 10 ( 6.6%)\ | | |
## | | | 4\. 2020\ | 10 ( 6.6%)\ | | |
## | | | 5\. 2017\ | 9 ( 5.9%)\ | | |
## | | | 6\. 2019\ | 7 ( 4.6%)\ | | |
## | | | 7\. 2022\ | 7 ( 4.6%)\ | | |
## | | | 8\. 2016\ | 5 ( 3.3%)\ | | |
## | | | 9\. 2021\ | 3 ( 2.0%)\ | | |
## | | | 10\. Unknown | 2 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 161 | DEATH_HRNAME\ | 1\. Not Applicable (Non-fatal\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 18:00-18:59\ | 6 ( 3.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 19:00-19:59\ | 6 ( 3.9%)\ | | |
## | | | 4\. 15:00-15:59\ | 5 ( 3.3%)\ | | |
## | | | 5\. 12:00-12:59\ | 4 ( 2.6%)\ | | |
## | | | 6\. 3:00-3:59\ | 4 ( 2.6%)\ | | |
## | | | 7\. Unknown\ | 4 ( 2.6%)\ | | |
## | | | 8\. 13:00-13:59\ | 3 ( 2.0%)\ | | |
## | | | 9\. 14:00-14:59\ | 3 ( 2.0%)\ | | |
## | | | 10\. 16:00-16:59\ | 3 ( 2.0%)\ | | |
## | | | 11\. 20:00-20:59\ | 3 ( 2.0%)\ | | |
## | | | 12\. 21:00-21:59\ | 3 ( 2.0%)\ | | |
## | | | 13\. 23:00-23:59\ | 3 ( 2.0%)\ | | |
## | | | 14\. 8:00-8:59\ | 3 ( 2.0%)\ | | |
## | | | 15\. 9:00-9:59\ | 3 ( 2.0%)\ | | |
## | | | 16\. 10:00-10:59\ | 2 ( 1.3%)\ | | |
## | | | 17\. 2:00-2:59\ | 2 ( 1.3%)\ | | |
## | | | 18\. 22:00-22:59\ | 2 ( 1.3%)\ | | |
## | | | 19\. 1:00-1:59\ | 1 ( 0.7%)\ | | |
## | | | 20\. 11:00-11:59\ | 1 ( 0.7%)\ | | |
## | | | 21\. 17:00-17:59\ | 1 ( 0.7%)\ | | |
## | | | 22\. 5:00-5:59\ | 1 ( 0.7%)\ | | |
## | | | 23\. 7:00-7:59 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 162 | DEATH_MNNAME\ | 1\. Not Applicable (Non-fatal\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. 30\ | 5 ( 3.3%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown\ | 4 ( 2.6%)\ | | |
## | | | 4\. 15\ | 3 ( 2.0%)\ | | |
## | | | 5\. 28\ | 3 ( 2.0%)\ | | |
## | | | 6\. 29\ | 3 ( 2.0%)\ | | |
## | | | 7\. 57\ | 3 ( 2.0%)\ | | |
## | | | 8\. 0\ | 2 ( 1.3%)\ | | |
## | | | 9\. 19\ | 2 ( 1.3%)\ | | |
## | | | 10\. 22\ | 2 ( 1.3%)\ | | |
## | | | 11\. 25\ | 2 ( 1.3%)\ | | |
## | | | 12\. 27\ | 2 ( 1.3%)\ | | |
## | | | 13\. 42\ | 2 ( 1.3%)\ | | |
## | | | 14\. 47\ | 2 ( 1.3%)\ | | |
## | | | 15\. 50\ | 2 ( 1.3%)\ | | |
## | | | 16\. 54\ | 2 ( 1.3%)\ | | |
## | | | 17\. 9\ | 2 ( 1.3%)\ | | |
## | | | 18\. 10\ | 1 ( 0.7%)\ | | |
## | | | 19\. 13\ | 1 ( 0.7%)\ | | |
## | | | 20\. 16\ | 1 ( 0.7%)\ | | |
## | | | 21\. 18\ | 1 ( 0.7%)\ | | |
## | | | 22\. 20\ | 1 ( 0.7%)\ | | |
## | | | 23\. 21\ | 1 ( 0.7%)\ | | |
## | | | 24\. 23\ | 1 ( 0.7%)\ | | |
## | | | 25\. 24\ | 1 ( 0.7%)\ | | |
## | | | 26\. 31\ | 1 ( 0.7%)\ | | |
## | | | 27\. 33\ | 1 ( 0.7%)\ | | |
## | | | 28\. 34\ | 1 ( 0.7%)\ | | |
## | | | 29\. 37\ | 1 ( 0.7%)\ | | |
## | | | 30\. 4\ | 1 ( 0.7%)\ | | |
## | | | 31\. 40\ | 1 ( 0.7%)\ | | |
## | | | 32\. 41\ | 1 ( 0.7%)\ | | |
## | | | 33\. 43\ | 1 ( 0.7%)\ | | |
## | | | 34\. 45\ | 1 ( 0.7%)\ | | |
## | | | 35\. 46\ | 1 ( 0.7%)\ | | |
## | | | 36\. 48\ | 1 ( 0.7%)\ | | |
## | | | 37\. 49\ | 1 ( 0.7%)\ | | |
## | | | 38\. 53\ | 1 ( 0.7%)\ | | |
## | | | 39\. 59\ | 1 ( 0.7%)\ | | |
## | | | 40\. 6 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 163 | LAG_HRSNAME\ | 1\. Unknown\ | 92 (60.5%)\ | 152\ | 0\ |
## | | [factor] | 2\. 0\ | 28 (18.4%)\ | (100.0%) | (0.0%) |
## | | | 3\. 2\ | 5 ( 3.3%)\ | | |
## | | | 4\. 1\ | 4 ( 2.6%)\ | | |
## | | | 5\. 4\ | 3 ( 2.0%)\ | | |
## | | | 6\. 26\ | 2 ( 1.3%)\ | | |
## | | | 7\. 7\ | 2 ( 1.3%)\ | | |
## | | | 8\. 126\ | 1 ( 0.7%)\ | | |
## | | | 9\. 128\ | 1 ( 0.7%)\ | | |
## | | | 10\. 16\ | 1 ( 0.7%)\ | | |
## | | | 11\. 18\ | 1 ( 0.7%)\ | | |
## | | | 12\. 184\ | 1 ( 0.7%)\ | | |
## | | | 13\. 218\ | 1 ( 0.7%)\ | | |
## | | | 14\. 234\ | 1 ( 0.7%)\ | | |
## | | | 15\. 274\ | 1 ( 0.7%)\ | | |
## | | | 16\. 308\ | 1 ( 0.7%)\ | | |
## | | | 17\. 326\ | 1 ( 0.7%)\ | | |
## | | | 18\. 46\ | 1 ( 0.7%)\ | | |
## | | | 19\. 511\ | 1 ( 0.7%)\ | | |
## | | | 20\. 54\ | 1 ( 0.7%)\ | | |
## | | | 21\. 73\ | 1 ( 0.7%)\ | | |
## | | | 22\. 86\ | 1 ( 0.7%)\ | | |
## | | | 23\. 97 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 164 | LAG_MINSNAME\ | 1\. Unknown\ | 92 (60.5%)\ | 152\ | 0\ |
## | | [factor] | 2\. 0\ | 9 ( 5.9%)\ | (100.0%) | (0.0%) |
## | | | 3\. 10\ | 4 ( 2.6%)\ | | |
## | | | 4\. 33\ | 4 ( 2.6%)\ | | |
## | | | 5\. 7\ | 4 ( 2.6%)\ | | |
## | | | 6\. 1\ | 3 ( 2.0%)\ | | |
## | | | 7\. 4\ | 3 ( 2.0%)\ | | |
## | | | 8\. 12\ | 2 ( 1.3%)\ | | |
## | | | 9\. 24\ | 2 ( 1.3%)\ | | |
## | | | 10\. 34\ | 2 ( 1.3%)\ | | |
## | | | 11\. 37\ | 2 ( 1.3%)\ | | |
## | | | 12\. 41\ | 2 ( 1.3%)\ | | |
## | | | 13\. 6\ | 2 ( 1.3%)\ | | |
## | | | 14\. 11\ | 1 ( 0.7%)\ | | |
## | | | 15\. 13\ | 1 ( 0.7%)\ | | |
## | | | 16\. 16\ | 1 ( 0.7%)\ | | |
## | | | 17\. 17\ | 1 ( 0.7%)\ | | |
## | | | 18\. 19\ | 1 ( 0.7%)\ | | |
## | | | 19\. 20\ | 1 ( 0.7%)\ | | |
## | | | 20\. 26\ | 1 ( 0.7%)\ | | |
## | | | 21\. 27\ | 1 ( 0.7%)\ | | |
## | | | 22\. 29\ | 1 ( 0.7%)\ | | |
## | | | 23\. 30\ | 1 ( 0.7%)\ | | |
## | | | 24\. 36\ | 1 ( 0.7%)\ | | |
## | | | 25\. 38\ | 1 ( 0.7%)\ | | |
## | | | 26\. 42\ | 1 ( 0.7%)\ | | |
## | | | 27\. 44\ | 1 ( 0.7%)\ | | |
## | | | 28\. 46\ | 1 ( 0.7%)\ | | |
## | | | 29\. 49\ | 1 ( 0.7%)\ | | |
## | | | 30\. 5\ | 1 ( 0.7%)\ | | |
## | | | 31\. 55\ | 1 ( 0.7%)\ | | |
## | | | 32\. 57\ | 1 ( 0.7%)\ | | |
## | | | 33\. 8\ | 1 ( 0.7%)\ | | |
## | | | 34\. 9 | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 165 | P_SF1NAME\ | 1\. None | 75 (100.0%) | 75\ | 77\ |
## | | [factor] | | | (49.3%) | (50.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 166 | P_SF2NAME\ | 1\. None | 75 (100.0%) | 75\ | 77\ |
## | | [factor] | | | (49.3%) | (50.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 167 | P_SF3NAME\ | 1\. None | 75 (100.0%) | 75\ | 77\ |
## | | [factor] | | | (49.3%) | (50.7%) |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 168 | WORK_INJNAME\ | 1\. Not Applicable (not a fat\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. No\ | 58 (38.2%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown | 6 ( 3.9%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 169 | HISPANICNAME\ | 1\. Not A Fatality (not Appli\ | 88 (57.9%)\ | 152\ | 0\ |
## | | [factor] | 2\. Non-Hispanic\ | 51 (33.6%)\ | (100.0%) | (0.0%) |
## | | | 3\. Unknown\ | 5 ( 3.3%)\ | | |
## | | | 4\. Hispanic, Origin Not Spec\ | 4 ( 2.6%)\ | | |
## | | | 5\. Mexican\ | 2 ( 1.3%)\ | | |
## | | | 6\. Central or South American\ | 1 ( 0.7%)\ | | |
## | | | 7\. Cuban | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 170 | RACENAME\ | 1\. Not a Fatality (not Appli\ | 33 (57.9%)\ | 57\ | 95\ |
## | | [factor] | 2\. White\ | 18 (31.6%)\ | (37.5%) | (62.5%) |
## | | | 3\. Black\ | 3 ( 5.3%)\ | | |
## | | | 4\. Chinese\ | 1 ( 1.8%)\ | | |
## | | | 5\. Korean\ | 1 ( 1.8%)\ | | |
## | | | 6\. Vietnamese | 1 ( 1.8%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 171 | LOCATIONNAME\ | 1\. Occupant of a Motor Vehic\ | 102 (67.1%)\ | 152\ | 0\ |
## | | [factor] | 2\. Not at Intersection - In \ | 41 (27.0%)\ | (100.0%) | (0.0%) |
## | | | 3\. Not at Intersection - On \ | 6 ( 3.9%)\ | | |
## | | | 4\. At Intersection - In Mark\ | 1 ( 0.7%)\ | | |
## | | | 5\. Driveway Access\ | 1 ( 0.7%)\ | | |
## | | | 6\. Not at Intersection - On | 1 ( 0.7%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 172 | HELM_USENAME\ | 1\. Not Applicable\ | 54 (56.8%)\ | 95\ | 57\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 34 (35.8%)\ | (62.5%) | (37.5%) |
## | | | 3\. Reported as Unknown if He\ | 4 ( 4.2%)\ | | |
## | | | 4\. Helmet, Unknown if DOT-Co\ | 2 ( 2.1%)\ | | |
## | | | 5\. DOT-Compliant Motorcycle | 1 ( 1.1%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 173 | HELM_MISNAME\ | 1\. None Used/Not Applicable\ | 58 (61.1%)\ | 95\ | 57\ |
## | | [factor] | 2\. Not a Motor Vehicle Occup\ | 34 (35.8%)\ | (62.5%) | (37.5%) |
## | | | 3\. No Indication of Misuse | 3 ( 3.2%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 174 | VPICMAKENAME\ | 1\. (Empty string)\ | 28 (36.4%)\ | 77\ | 75\ |
## | | [factor] | 2\. Ford\ | 12 (15.6%)\ | (50.7%) | (49.3%) |
## | | | 3\. Chevrolet\ | 5 ( 6.5%)\ | | |
## | | | 4\. Honda\ | 5 ( 6.5%)\ | | |
## | | | 5\. Toyota\ | 4 ( 5.2%)\ | | |
## | | | 6\. Volkswagen\ | 4 ( 5.2%)\ | | |
## | | | 7\. Nissan\ | 3 ( 3.9%)\ | | |
## | | | 8\. Jeep\ | 2 ( 2.6%)\ | | |
## | | | 9\. Kia\ | 2 ( 2.6%)\ | | |
## | | | 10\. KYMCO\ | 2 ( 2.6%)\ | | |
## | | | 11\. Acura\ | 1 ( 1.3%)\ | | |
## | | | 12\. BMW\ | 1 ( 1.3%)\ | | |
## | | | 13\. Buick\ | 1 ( 1.3%)\ | | |
## | | | 14\. Dodge\ | 1 ( 1.3%)\ | | |
## | | | 15\. Harley Davidson\ | 1 ( 1.3%)\ | | |
## | | | 16\. Mack\ | 1 ( 1.3%)\ | | |
## | | | 17\. Other\ | 1 ( 1.3%)\ | | |
## | | | 18\. Polaris\ | 1 ( 1.3%)\ | | |
## | | | 19\. Unknown\ | 1 ( 1.3%)\ | | |
## | | | 20\. Yamaha | 1 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 175 | VPICMODEL\ | 1\. 1798\ | 3 (6.1%)\ | 49\ | 103\ |
## | | [factor] | 2\. 1801\ | 3 (6.1%)\ | (32.2%) | (67.8%) |
## | | | 3\. 1861\ | 3 (6.1%)\ | | |
## | | | 4\. 3137\ | 3 (6.1%)\ | | |
## | | | 5\. 1780\ | 2 (4.1%)\ | | |
## | | | 6\. 1807\ | 2 (4.1%)\ | | |
## | | | 7\. 1904\ | 2 (4.1%)\ | | |
## | | | 8\. 1943\ | 2 (4.1%)\ | | |
## | | | 9\. 2469\ | 2 (4.1%)\ | | |
## | | | 10\. 10978\ | 2 (4.1%)\ | | |
## | | | 11\. 25406\ | 2 (4.1%)\ | | |
## | | | 12\. 1779\ | 1 (2.0%)\ | | |
## | | | 13\. 1835\ | 1 (2.0%)\ | | |
## | | | 14\. 1842\ | 1 (2.0%)\ | | |
## | | | 15\. 1847\ | 1 (2.0%)\ | | |
## | | | 16\. 1853\ | 1 (2.0%)\ | | |
## | | | 17\. 1865\ | 1 (2.0%)\ | | |
## | | | 18\. 1874\ | 1 (2.0%)\ | | |
## | | | 19\. 1894\ | 1 (2.0%)\ | | |
## | | | 20\. 2030\ | 1 (2.0%)\ | | |
## | | | 21\. 2208\ | 1 (2.0%)\ | | |
## | | | 22\. 2460\ | 1 (2.0%)\ | | |
## | | | 23\. 2467\ | 1 (2.0%)\ | | |
## | | | 24\. 2769\ | 1 (2.0%)\ | | |
## | | | 25\. 3267\ | 1 (2.0%)\ | | |
## | | | 26\. 4167\ | 1 (2.0%)\ | | |
## | | | 27\. 5959\ | 1 (2.0%)\ | | |
## | | | 28\. 8508\ | 1 (2.0%)\ | | |
## | | | 29\. 10358\ | 1 (2.0%)\ | | |
## | | | 30\. 13827\ | 1 (2.0%)\ | | |
## | | | 31\. 14832\ | 1 (2.0%)\ | | |
## | | | 32\. 32005\ | 1 (2.0%)\ | | |
## | | | 33\. 99997\ | 1 (2.0%)\ | | |
## | | | 34\. 99999 | 1 (2.0%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 176 | VPICMODELNAME\ | 1\. (Empty string)\ | 28 (36.4%)\ | 77\ | 75\ |
## | | [factor] | 2\. Accord\ | 3 ( 3.9%)\ | (50.7%) | (49.3%) |
## | | | 3\. Escape\ | 3 ( 3.9%)\ | | |
## | | | 4\. F-150\ | 3 ( 3.9%)\ | | |
## | | | 5\. Jetta\ | 3 ( 3.9%)\ | | |
## | | | 6\. Altima\ | 2 ( 2.6%)\ | | |
## | | | 7\. Camry\ | 2 ( 2.6%)\ | | |
## | | | 8\. F-450\ | 2 ( 2.6%)\ | | |
## | | | 9\. Fusion\ | 2 ( 2.6%)\ | | |
## | | | 10\. GMT-400\ | 2 ( 2.6%)\ | | |
## | | | 11\. Like 50 (4T) / Like 150\ | 2 ( 2.6%)\ | | |
## | | | 12\. Wrangler\ | 2 ( 2.6%)\ | | |
## | | | 13\. 430i\ | 1 ( 1.3%)\ | | |
## | | | 14\. Corolla\ | 1 ( 1.3%)\ | | |
## | | | 15\. CR-V\ | 1 ( 1.3%)\ | | |
## | | | 16\. Encore\ | 1 ( 1.3%)\ | | |
## | | | 17\. Eos\ | 1 ( 1.3%)\ | | |
## | | | 18\. Equinox\ | 1 ( 1.3%)\ | | |
## | | | 19\. Fiesta\ | 1 ( 1.3%)\ | | |
## | | | 20\. Focus\ | 1 ( 1.3%)\ | | |
## | | | 21\. Grand Caravan\ | 1 ( 1.3%)\ | | |
## | | | 22\. GU\ | 1 ( 1.3%)\ | | |
## | | | 23\. Other\ | 1 ( 1.3%)\ | | |
## | | | 24\. Passport\ | 1 ( 1.3%)\ | | |
## | | | 25\. PRO X\ | 1 ( 1.3%)\ | | |
## | | | 26\. Road King\ | 1 ( 1.3%)\ | | |
## | | | 27\. RX-1 ER\ | 1 ( 1.3%)\ | | |
## | | | 28\. Sonic\ | 1 ( 1.3%)\ | | |
## | | | 29\. Sorento\ | 1 ( 1.3%)\ | | |
## | | | 30\. Soul\ | 1 ( 1.3%)\ | | |
## | | | 31\. Traverse\ | 1 ( 1.3%)\ | | |
## | | | 32\. TSX\ | 1 ( 1.3%)\ | | |
## | | | 33\. Tundra\ | 1 ( 1.3%)\ | | |
## | | | 34\. Unknown\ | 1 ( 1.3%)\ | | |
## | | | 35\. Versa | 1 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 177 | VPICBODYCLASSNAME\ | 1\. (Empty string)\ | 28 (36.4%)\ | 77\ | 75\ |
## | | [factor] | 2\. Sedan/Saloon\ | 19 (24.7%)\ | (50.7%) | (49.3%) |
## | | | 3\. Sport Utility Vehicle (SU\ | 12 (15.6%)\ | | |
## | | | 4\. Pickup\ | 6 ( 7.8%)\ | | |
## | | | 5\. Off-road Vehicle - Snowmo\ | 3 ( 3.9%)\ | | |
## | | | 6\. Incomplete - Chassis Cab \ | 2 ( 2.6%)\ | | |
## | | | 7\. Motorcycle - Scooter\ | 2 ( 2.6%)\ | | |
## | | | 8\. Convertible/Cabriolet\ | 1 ( 1.3%)\ | | |
## | | | 9\. Minivan\ | 1 ( 1.3%)\ | | |
## | | | 10\. Motorcycle - Touring / Sp\ | 1 ( 1.3%)\ | | |
## | | | 11\. Truck\ | 1 ( 1.3%)\ | | |
## | | | 12\. Unknown | 1 ( 1.3%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
## | 178 | ICFINALBODYNAME\ | 1\. Not Applicable\ | 47 (61.0%)\ | 77\ | 75\ |
## | | [factor] | 2\. (Empty string)\ | 28 (36.4%)\ | (50.7%) | (49.3%) |
## | | | 3\. Truck | 2 ( 2.6%) | | |
## +-----+--------------------+---------------------------------+--------------------+----------+---------+
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] 152 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
)