Name: 2015 Traffic Fatalities
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

2015 Traffic Fatalities

Quick Start

For a quick introduction to this Dataset, take a look at the Kernel Traffic Fatalities Getting Started.

See the Fatality Analysis Reporting
System FARS User’s Manual for understanding the column abbreviations and possible values.

Also, see the following reference

Original source of this data containing all files can be obtained here

Below are the files released by the (NHTSA) National Highway Traffic Safety Administration, in their original format. Additional files can be found in the extra folder. Reference Traffic Fatalities Getting Started. for how to access this extra folder with contents.

Data Compared to 2014

A few interesting notes about this data compared to 2014

Pedalcyclist fatalities increased by 89 (12.2 percent)
Motorcyclist fatalities increased by 382 (8.3-percent
increase)
Alcohol-impaired driving fatalities increased by 3.2 percent,
from 9,943 in 2014 to 10,265 in 2015
Vehicle miles traveled (VMT) increased by 3.5 percent
from 2014 to 2015, the largest increase since 1992, nearly 25
years ago.

See TRAFFIC SAFETY FACTS for more detail on the above findings.

Tables

Accident

@kaggle.nhtsa_2015_traffic_fatalities.accident

1.78 MB
32,166 rows
52 columns

CREATE TABLE accident (
  "state" BIGINT,
  "st_case" BIGINT,
  "ve_total" BIGINT,
  "ve_forms" BIGINT,
  "pvh_invl" BIGINT,
  "peds" BIGINT,
  "pernotmvit" BIGINT,
  "permvit" BIGINT,
  "persons" BIGINT,
  "county" BIGINT,
  "city" BIGINT,
  "day" BIGINT,
  "month" BIGINT,
  "year" BIGINT,
  "day_week" BIGINT,
  "hour" BIGINT,
  "minute" BIGINT,
  "nhs" BIGINT,
  "rur_urb" BIGINT,
  "func_sys" BIGINT,
  "rd_owner" BIGINT,
  "route" BIGINT,
  "tway_id" VARCHAR,
  "tway_id2" VARCHAR,
  "milept" BIGINT,
  "latitude" DOUBLE,
  "longitud" DOUBLE,
  "sp_jur" BIGINT,
  "harm_ev" BIGINT,
  "man_coll" BIGINT,
  "reljct1" BIGINT,
  "reljct2" BIGINT,
  "typ_int" BIGINT,
  "wrk_zone" BIGINT,
  "rel_road" BIGINT,
  "lgt_cond" BIGINT,
  "weather1" BIGINT,
  "weather2" BIGINT,
  "weather" BIGINT,
  "sch_bus" BIGINT,
  "rail" VARCHAR,
  "not_hour" BIGINT,
  "not_min" BIGINT,
  "arr_hour" BIGINT,
  "arr_min" BIGINT,
  "hosp_hr" BIGINT,
  "hosp_mn" BIGINT,
  "cf1" BIGINT,
  "cf2" BIGINT,
  "cf3" BIGINT,
  "fatals" BIGINT,
  "drunk_dr" BIGINT
);

Cevent

@kaggle.nhtsa_2015_traffic_fatalities.cevent

598.4 kB
97,343 rows
8 columns

CREATE TABLE cevent (
  "state" BIGINT,
  "st_case" BIGINT,
  "eventnum" BIGINT,
  "vnumber1" BIGINT,
  "aoi1" BIGINT,
  "soe" BIGINT,
  "vnumber2" BIGINT,
  "aoi2" BIGINT
);

Damage

@kaggle.nhtsa_2015_traffic_fatalities.damage

415.23 kB
192,730 rows
4 columns

CREATE TABLE damage (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "mdareas" BIGINT
);

Distract

@kaggle.nhtsa_2015_traffic_fatalities.distract

259.5 kB
48,962 rows
4 columns

CREATE TABLE distract (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "mdrdstrd" BIGINT
);

Drimpair

@kaggle.nhtsa_2015_traffic_fatalities.drimpair

259.67 kB
49,088 rows
4 columns

CREATE TABLE drimpair (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "drimpair" BIGINT
);

Factor

@kaggle.nhtsa_2015_traffic_fatalities.factor

249.11 kB
48,985 rows
4 columns

CREATE TABLE factor (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "mfactor" BIGINT
);

Maneuver

@kaggle.nhtsa_2015_traffic_fatalities.maneuver

257.14 kB
48,935 rows
4 columns

CREATE TABLE maneuver (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "mdrmanav" BIGINT
);

Miper

@kaggle.nhtsa_2015_traffic_fatalities.miper

590.58 kB
55,502 rows
13 columns

CREATE TABLE miper (
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "per_no" BIGINT,
  "p1" BIGINT,
  "p2" BIGINT,
  "p3" BIGINT,
  "p4" BIGINT,
  "p5" BIGINT,
  "p6" BIGINT,
  "p7" BIGINT,
  "p8" BIGINT,
  "p9" BIGINT,
  "p10" BIGINT
);

Nmimpair

@kaggle.nhtsa_2015_traffic_fatalities.nmimpair

45.24 kB
6,933 rows
5 columns

CREATE TABLE nmimpair (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "per_no" BIGINT,
  "nmimpair" BIGINT
);

Nmprior

@kaggle.nhtsa_2015_traffic_fatalities.nmprior

46.53 kB
7,153 rows
5 columns

CREATE TABLE nmprior (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "per_no" BIGINT,
  "mpr_act" BIGINT
);

Parkwork

@kaggle.nhtsa_2015_traffic_fatalities.parkwork

90.61 kB
1,133 rows
57 columns

CREATE TABLE parkwork (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "pve_forms" BIGINT,
  "pnumoccs" BIGINT,
  "pday" BIGINT,
  "pmonth" BIGINT,
  "phour" BIGINT,
  "pminute" BIGINT,
  "pharm_ev" BIGINT,
  "pman_coll" BIGINT,
  "ptype" BIGINT,
  "phit_run" BIGINT,
  "preg_stat" BIGINT,
  "powner" BIGINT,
  "pmake" BIGINT,
  "pmodel" BIGINT,
  "pmak_mod" BIGINT,
  "pbodytyp" BIGINT,
  "pmodyear" BIGINT,
  "pvin" VARCHAR,
  "pvin_1" VARCHAR,
  "pvin_2" VARCHAR,
  "pvin_3" VARCHAR,
  "pvin_4" VARCHAR,
  "pvin_5" VARCHAR,
  "pvin_6" VARCHAR,
  "pvin_7" VARCHAR,
  "pvin_8" VARCHAR,
  "pvin_9" VARCHAR,
  "pvin_10" VARCHAR,
  "pvin_11" VARCHAR,
  "pvin_12" VARCHAR,
  "ptrailer" BIGINT,
  "pmcarr_i1" BIGINT,
  "pmcarr_i2" VARCHAR,
  "pmcarr_id" VARCHAR,
  "pgvwr" BIGINT,
  "pv_config" BIGINT,
  "pcargtyp" BIGINT,
  "phaz_inv" BIGINT,
  "phazplac" BIGINT,
  "phaz_id" BIGINT,
  "phaz_cno" BIGINT,
  "phaz_rel" BIGINT,
  "pbus_use" BIGINT,
  "psp_use" BIGINT,
  "pem_use" BIGINT,
  "punderide" BIGINT,
  "pimpact1" BIGINT,
  "pveh_sev" BIGINT,
  "ptowed" BIGINT,
  "pm_harm" BIGINT,
  "pveh_sc1" BIGINT,
  "pveh_sc2" BIGINT,
  "pfire" BIGINT,
  "pdeaths" BIGINT
);

Pbtype

@kaggle.nhtsa_2015_traffic_fatalities.pbtype

106.58 kB
6,814 rows
24 columns

CREATE TABLE pbtype (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "per_no" BIGINT,
  "pbptype" BIGINT,
  "pbage" BIGINT,
  "pbsex" BIGINT,
  "pbcwalk" BIGINT,
  "pbswalk" BIGINT,
  "pbszone" BIGINT,
  "pedctype" BIGINT,
  "bikectype" BIGINT,
  "pedloc" BIGINT,
  "bikeloc" BIGINT,
  "pedpos" BIGINT,
  "bikepos" BIGINT,
  "peddir" BIGINT,
  "bikedir" BIGINT,
  "motdir" BIGINT,
  "motman" BIGINT,
  "pedleg" BIGINT,
  "pedsnr" VARCHAR,
  "pedcgp" BIGINT,
  "bikecgp" BIGINT
);

Person

@kaggle.nhtsa_2015_traffic_fatalities.person

2.46 MB
80,587 rows
68 columns

CREATE TABLE person (
  "state" BIGINT,
  "st_case" BIGINT,
  "ve_forms" BIGINT,
  "veh_no" BIGINT,
  "per_no" BIGINT,
  "str_veh" BIGINT,
  "county" BIGINT,
  "day" BIGINT,
  "month" BIGINT,
  "hour" BIGINT,
  "minute" BIGINT,
  "rur_urb" BIGINT,
  "func_sys" BIGINT,
  "harm_ev" BIGINT,
  "man_coll" BIGINT,
  "sch_bus" BIGINT,
  "make" DOUBLE,
  "mak_mod" DOUBLE,
  "body_typ" DOUBLE,
  "mod_year" DOUBLE,
  "tow_veh" DOUBLE,
  "spec_use" DOUBLE,
  "emer_use" DOUBLE,
  "rollover" DOUBLE,
  "impact1" DOUBLE,
  "fire_exp" DOUBLE,
  "age" BIGINT,
  "sex" BIGINT,
  "per_typ" BIGINT,
  "inj_sev" BIGINT,
  "seat_pos" BIGINT,
  "rest_use" BIGINT,
  "rest_mis" BIGINT,
  "air_bag" BIGINT,
  "ejection" BIGINT,
  "ej_path" BIGINT,
  "extricat" BIGINT,
  "drinking" BIGINT,
  "alc_det" BIGINT,
  "alc_status" BIGINT,
  "atst_typ" BIGINT,
  "alc_res" BIGINT,
  "drugs" BIGINT,
  "drug_det" BIGINT,
  "dstatus" BIGINT,
  "drugtst1" BIGINT,
  "drugtst2" BIGINT,
  "drugtst3" BIGINT,
  "drugres1" BIGINT,
  "drugres2" BIGINT,
  "drugres3" BIGINT,
  "hospital" BIGINT,
  "doa" BIGINT,
  "death_da" BIGINT,
  "death_mo" BIGINT,
  "death_yr" BIGINT,
  "death_hr" BIGINT,
  "death_mn" BIGINT,
  "death_tm" BIGINT,
  "lag_hrs" BIGINT,
  "lag_mins" BIGINT,
  "p_sf1" BIGINT,
  "p_sf2" BIGINT,
  "p_sf3" BIGINT,
  "work_inj" BIGINT,
  "hispanic" BIGINT,
  "race" BIGINT,
  "location" BIGINT
);

Vevent

@kaggle.nhtsa_2015_traffic_fatalities.vevent

760.25 kB
115,275 rows
10 columns

CREATE TABLE vevent (
  "state" BIGINT,
  "st_case" BIGINT,
  "eventnum" BIGINT,
  "veh_no" BIGINT,
  "veventnum" BIGINT,
  "vnumber1" BIGINT,
  "aoi1" BIGINT,
  "soe" BIGINT,
  "vnumber2" BIGINT,
  "aoi2" BIGINT
);

Vindecode

@kaggle.nhtsa_2015_traffic_fatalities.vindecode

2.88 MB
50,056 rows
103 columns

CREATE TABLE vindecode (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "ncicmake" VARCHAR,
  "vinyear" DOUBLE,
  "vehtype" VARCHAR,
  "vehtype_t" VARCHAR,
  "vinmake_t" VARCHAR,
  "vinmodel_t" VARCHAR,
  "vintrim_t" VARCHAR,
  "vintrim1_t" VARCHAR,
  "vintrim2_t" VARCHAR,
  "vintrim3_t" VARCHAR,
  "vintrim4_t" VARCHAR,
  "bodystyl" VARCHAR,
  "bodystyl_t" VARCHAR,
  "doors" DOUBLE,
  "wheels" DOUBLE,
  "drivwhls" DOUBLE,
  "mfg" VARCHAR,
  "mfg_t" VARCHAR,
  "displci" DOUBLE,
  "displcc" DOUBLE,
  "cylndrs" VARCHAR,
  "cycles" DOUBLE,
  "fuel" VARCHAR,
  "fuel_t" VARCHAR,
  "fuelinj" VARCHAR,
  "fuelinj_t" VARCHAR,
  "carbtype" VARCHAR,
  "carbtype_t" VARCHAR,
  "carbbrls" DOUBLE,
  "gvwrange" DOUBLE,
  "gvwrange_t" VARCHAR,
  "whlbsh" DOUBLE,
  "whlblg" DOUBLE,
  "tiredesc_f" VARCHAR,
  "psi_f" DOUBLE,
  "tiresz_f" VARCHAR,
  "tiresz_f_t" VARCHAR,
  "tiredesc_r" VARCHAR,
  "psi_r" DOUBLE,
  "rearsize" DOUBLE,
  "rearsize_t" VARCHAR,
  "tonrating" VARCHAR,
  "shipweight" DOUBLE,
  "msrp" DOUBLE,
  "drivetyp" VARCHAR,
  "drivetyp_t" VARCHAR,
  "salectry" VARCHAR,
  "salectry_t" VARCHAR,
  "abs" VARCHAR,
  "abs_t" VARCHAR,
  "security" VARCHAR,
  "security_t" VARCHAR,
  "drl" VARCHAR,
  "drl_t" VARCHAR,
  "rstrnt" VARCHAR,
  "rstrnt_t" VARCHAR,
  "tkcab" VARCHAR,
  "tkcab_t" VARCHAR,
  "tkaxlef" VARCHAR,
  "tkaxlef_t" VARCHAR,
  "tkaxler" VARCHAR,
  "tkaxler_t" VARCHAR,
  "tkbrak" VARCHAR,
  "tkbrak_t" VARCHAR,
  "engmfg" VARCHAR,
  "engmfg_t" VARCHAR,
  "engmodel" VARCHAR,
  "tkduty" VARCHAR,
  "tkduty_t" VARCHAR,
  "tkbedl" VARCHAR,
  "tkbedl_t" VARCHAR,
  "segmnt" VARCHAR,
  "segmnt_t" VARCHAR,
  "plant" VARCHAR,
  "plntctry_t" VARCHAR,
  "plntcity" VARCHAR,
  "plntctry" VARCHAR,
  "plntstat" VARCHAR,
  "plntstat_t" VARCHAR,
  "origin" VARCHAR,
  "origin_t" VARCHAR,
  "dispclmt" DOUBLE,
  "blocktype" VARCHAR,
  "enghead" VARCHAR,
  "enghead_t" VARCHAR,
  "vlvclndr" DOUBLE,
  "vlvtotal" DOUBLE,
  "engvincd" VARCHAR,
  "incomplt" VARCHAR,
  "battyp" VARCHAR,
  "battyp_t" VARCHAR,
  "batkwrtg" VARCHAR,
  "batvolt" DOUBLE,
  "supchrgr" VARCHAR,
  "supchrgr_t" VARCHAR,
  "turbo" VARCHAR,
  "turbo_t" VARCHAR
);

Vision

@kaggle.nhtsa_2015_traffic_fatalities.vision

248.64 kB
48,959 rows
4 columns

CREATE TABLE vision (
  "state" BIGINT,
  "st_case" BIGINT,
  "veh_no" BIGINT,
  "mvisobsc" BIGINT
);