2015 Traffic Fatalities

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
);

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

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

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

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

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

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

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
);

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

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

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
);

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
);

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
);

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
);

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
);

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