Automobile Recalls Dataset
A dataset of all 26,000+ recalls since 1966
@kaggle.michaelbryantds_automobile_recalls_dataset
A dataset of all 26,000+ recalls since 1966
@kaggle.michaelbryantds_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
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
);
Anyone who has the link will be able to view this.