Dataset: Automobile Recalls Dataset

About this Dataset

Automobile Recalls Dataset

In the US, the National Highway Traffic Safety Administration oversees all recalls of vehicles, tires, child safety seats, and other auto equipment. Through the agency’s recall portal, you can search by vehicle identification number, make, model, and year; for other types of recalls, you can search by brand and model. The agency also provides a dataset of all 26,000+ recalls since 1966. It lists the recall type, manufacturer’s name, component, number of units potentially affected, and date the manufacturer notified NHTSA, plus descriptions of the problem, recall action, and remedy.

Source: https://datahub.transportation.gov/Automobiles/Recalls-Data/6axg-epim

Tables

Recalls

@kaggle.michaelbryantds_automobile_recalls_dataset.recalls

6.65 MB
26590 rows
12 columns


CREATE TABLE recalls (
  "report_received_date" TIMESTAMP,
  "nhtsa_id" VARCHAR,
  "recall_link" VARCHAR,
  "manufacturer" VARCHAR,
  "subject" VARCHAR,
  "component" VARCHAR,
  "mfr_campaign_number" VARCHAR,
  "recall_type" VARCHAR,
  "potentially_affected" DOUBLE,
  "recall_description" VARCHAR,
  "consequence_summary" VARCHAR,
  "corrective_action" VARCHAR
);