About this Dataset

NHTSA's Office Of Defects Investigation (ODI) - Technical Service Bulletins System (TSBS) - Downloadable File

The Technical Service Bulletins data contains summaries of the Manufacturers' Technical Service Bulletins by single year, make and model. An optional item of Vehicle Component may be also available. (The data does not contain all the service bulletins generated by a manufacturer. Bulletins for safety recalls in general are not included, and also bulletins which may not pertain to a defect may not be included.)
Organization: Department of Transportation
Last updated: 2020-11-12T12:48:28.038730
Tags: bulletin, defect, safercar-gov, safety, service, summaries, technical, vehicle

Tables

Downloadable File

@usgov.dot_gov_nhtsas_office_of_defects_investigation_odi_tec_8d15f6ff.downloadable_file

721.25 kB
11,772 rows
128 columns

CREATE TABLE downloadable_file (
  "make" VARCHAR,
  "model" VARCHAR,
  "model_yr" BIGINT,
  "body_style" VARCHAR,
  "vehicle_type" VARCHAR,
  "drive_train" VARCHAR,
  "production_release" BIGINT,
  "vehicle_class" VARCHAR,
  "body_frame" VARCHAR,
  "num_of_seating" VARCHAR,
  "seat_loc" VARCHAR,
  "seat_loc_comments" VARCHAR,
  "min_gross_weight" DOUBLE,
  "max_gross_weight" DOUBLE,
  "upper_belt_anchorage" VARCHAR,
  "upper_belt_anchorage_loc" VARCHAR,
  "seat_belt_pretensioner" VARCHAR,
  "seat_belt_pretensioner_loc" VARCHAR,
  "load_limiters" VARCHAR,
  "load_limiters_loc" VARCHAR,
  "frnt_belt_indicator" VARCHAR,
  "frnt_belt_loc" VARCHAR,
  "rear_belt_indicator" VARCHAR,
  "latch_rear_position" VARCHAR,
  "head_sab" VARCHAR,
  "head_sab_type" VARCHAR,
  "head_sab_loc" VARCHAR,
  "head_sab_mount_loc" VARCHAR,
  "head_sab_meet_requirements" VARCHAR,
  "head_sab_deploy_in_rollover" VARCHAR,
  "torso_sab" VARCHAR,
  "torso_sab_type" VARCHAR,
  "torso_sab_loc" VARCHAR,
  "torso_sab_mount_loc" VARCHAR,
  "knee_bolsters" VARCHAR,
  "knee_bolsters_loc" VARCHAR,
  "adl" VARCHAR,
  "head_restraint_ind" VARCHAR,
  "dynamic_head_restraint_ind" VARCHAR,
  "beti" VARCHAR,
  "blind_spot_detection" VARCHAR,
  "day_run_lights" VARCHAR,
  "adaptive_cruise_control" VARCHAR,
  "abs" VARCHAR,
  "ars" VARCHAR,
  "ars_loc" VARCHAR,
  "auto_crash_notification" VARCHAR,
  "crash_data_recorder" VARCHAR,
  "anti_theft_device" VARCHAR,
  "anti_theft_device_type" VARCHAR,
  "frnt_collision_warning" VARCHAR,
  "nhtsa_frnt_collision_warning" VARCHAR,
  "nhtsa_fcw_evaluation" VARCHAR,
  "lane_departure_warning" VARCHAR,
  "nhtsa_lane_departure_warning" VARCHAR,
  "nhtsa_ldw_evaluation" VARCHAR,
  "crash_imminent_brake" VARCHAR,
  "nhtsa_crash_imminent_brake" VARCHAR,
  "nhtsa_cib_evaluation" VARCHAR,
  "dynamic_brake_support" VARCHAR,
  "nhtsa_dynamic_brake_support" VARCHAR,
  "nhtsa_dbs_evaluation" VARCHAR,
  "nhtsa_esc" VARCHAR,
  "pelvis_sab" VARCHAR,
  "pelvis_sab_type" VARCHAR,
  "pelvis_sab_loc" VARCHAR,
  "pelvis_sab_mount_loc" VARCHAR,
  "overall_stars" DOUBLE,
  "frnt_test_no" DOUBLE,
  "frnt_vin" VARCHAR,
  "frnt_driv_stars" DOUBLE,
  "frnt_pass_stars" DOUBLE,
  "frnt_safety_concern_driv" VARCHAR,
  "frnt_safety_concern_pass" VARCHAR,
  "frnt_foot_notes" VARCHAR,
  "frnt_foot_notes_pass" VARCHAR,
  "overall_frnt_stars" DOUBLE,
  "curb_weight" DOUBLE,
  "frnt_tested_with" VARCHAR,
  "hic15_driv" DOUBLE,
  "chest_defl_driv" DOUBLE,
  "left_femur_driv" DOUBLE,
  "right_femur_driv" DOUBLE,
  "nij_driv" DOUBLE,
  "neck_tens_driv" DOUBLE,
  "net_comp_driv" DOUBLE,
  "hic15_pass" DOUBLE,
  "chest_defl_pass" DOUBLE,
  "left_femur_pass" DOUBLE,
  "right_femur_pass" DOUBLE,
  "nij_pass" DOUBLE,
  "neck_tens_pass" DOUBLE,
  "net_comp_pass" DOUBLE,
  "side_test_no" DOUBLE,
  "side_vin" VARCHAR,
  "side_driv_stars" DOUBLE,
  "side_pass_stars" DOUBLE,
  "side_barrier_star" DOUBLE,
  "comb_frnt_star" DOUBLE,
  "comb_rear_star" DOUBLE
);