Automated Driving Crashes Dataset
Data from the National Highway Traffic Safety Administration
@kaggle.michaelbryantds_automated_driving_crashes
Data from the National Highway Traffic Safety Administration
@kaggle.michaelbryantds_automated_driving_crashes
CREATE TABLE sgo_2021_01_incident_reports_adas (
"report_id" VARCHAR,
"report_version" BIGINT,
"reporting_entity" VARCHAR,
"report_type" VARCHAR,
"report_month" DOUBLE,
"report_year" DOUBLE,
"report_submission_date" VARCHAR,
"vin" VARCHAR,
"vin_unknown" VARCHAR,
"serial_number" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"model_unknown" VARCHAR,
"model_year" BIGINT,
"model_year_unknown" VARCHAR,
"same_vehicle_id" VARCHAR,
"mileage" DOUBLE,
"mileage_unknown" VARCHAR,
"driver_operator_type" VARCHAR,
"adas_ads_version" VARCHAR,
"adas_ads_version_unknown" VARCHAR,
"adas_ads_version_cbi" VARCHAR,
"ads_equipped" VARCHAR,
"automation_system_engaged" VARCHAR,
"operating_entity" VARCHAR,
"operating_entity_unknown" VARCHAR,
"source_complaint_claim" VARCHAR,
"source_telematics" VARCHAR,
"source_law_enforcement" VARCHAR,
"source_field_report" VARCHAR,
"source_testing" VARCHAR,
"source_media" VARCHAR,
"source_other" VARCHAR,
"source_other_text" VARCHAR,
"incident_date" VARCHAR,
"incident_date_unknown" VARCHAR,
"notice_received_date" VARCHAR,
"incident_time_24_00" VARCHAR,
"incident_time_unknown" VARCHAR,
"same_incident_id" VARCHAR,
"latitude" VARCHAR,
"latitude_unknown" VARCHAR,
"longitude" VARCHAR,
"longitude_unknown" VARCHAR,
"address" VARCHAR,
"address_unknown" VARCHAR,
"city" VARCHAR,
"city_unknown" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"zip_code_unknown" VARCHAR,
"roadway_type" VARCHAR,
"roadway_surface" VARCHAR,
"roadway_description" VARCHAR,
"posted_speed_limit_mph" DOUBLE,
"posted_speed_limit_unknown" VARCHAR,
"lighting" VARCHAR,
"weather_clear" VARCHAR,
"weather_snow" VARCHAR,
"weather_cloudy" VARCHAR,
"weather_fog_smoke" VARCHAR,
"weather_rain" VARCHAR,
"weather_severe_wind" VARCHAR,
"weather_unknown" VARCHAR,
"weather_other" VARCHAR,
"weather_other_text" VARCHAR,
"crash_with" VARCHAR,
"highest_injury_severity" VARCHAR,
"property_damage" VARCHAR,
"cp_pre_crash_movement" VARCHAR,
"cp_any_air_bags_deployed" VARCHAR,
"cp_was_vehicle_towed" VARCHAR,
"cp_contact_area_rear_left" VARCHAR,
"cp_contact_area_left" VARCHAR,
"cp_contact_area_front_left" VARCHAR,
"cp_contact_area_rear" VARCHAR,
"cp_contact_area_top" VARCHAR,
"cp_contact_area_front" VARCHAR,
"cp_contact_area_rear_right" VARCHAR,
"cp_contact_area_right" VARCHAR,
"cp_contact_area_front_right" VARCHAR,
"cp_contact_area_bottom" VARCHAR,
"cp_contact_area_unknown" VARCHAR,
"sv_pre_crash_movement" VARCHAR,
"sv_any_air_bags_deployed" VARCHAR,
"sv_was_vehicle_towed" VARCHAR,
"sv_were_all_passengers_belted" VARCHAR,
"sv_precrash_speed_mph" DOUBLE,
"sv_pre_crash_speed_unknown" VARCHAR,
"sv_contact_area_rear_left" VARCHAR,
"sv_contact_area_left" VARCHAR,
"sv_contact_area_front_left" VARCHAR,
"sv_contact_area_rear" VARCHAR,
"sv_contact_area_top" VARCHAR,
"sv_contact_area_front" VARCHAR,
"sv_contact_area_rear_right" VARCHAR,
"sv_contact_area_right" VARCHAR,
"sv_contact_area_front_right" VARCHAR,
"sv_contact_area_bottom" VARCHAR,
"sv_contact_area_unknown" VARCHAR
);
CREATE TABLE sgo_2021_01_incident_reports_ads (
"report_id" VARCHAR,
"report_version" BIGINT,
"reporting_entity" VARCHAR,
"report_type" VARCHAR,
"report_month" DOUBLE,
"report_year" DOUBLE,
"report_submission_date" VARCHAR,
"vin" VARCHAR,
"vin_unknown" VARCHAR,
"serial_number" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"model_unknown" VARCHAR,
"model_year" DOUBLE,
"model_year_unknown" VARCHAR,
"same_vehicle_id" VARCHAR,
"mileage" DOUBLE,
"mileage_unknown" VARCHAR,
"driver_operator_type" VARCHAR,
"adas_ads_version" VARCHAR,
"adas_ads_version_unknown" VARCHAR,
"adas_ads_version_cbi" VARCHAR,
"ads_equipped" VARCHAR,
"automation_system_engaged" VARCHAR,
"operating_entity" VARCHAR,
"operating_entity_unknown" VARCHAR,
"source_complaint_claim" VARCHAR,
"source_telematics" VARCHAR,
"source_law_enforcement" VARCHAR,
"source_field_report" VARCHAR,
"source_testing" VARCHAR,
"source_media" VARCHAR,
"source_other" VARCHAR,
"source_other_text" VARCHAR,
"incident_date" VARCHAR,
"incident_date_unknown" VARCHAR,
"notice_received_date" VARCHAR,
"incident_time_24_00" VARCHAR,
"incident_time_unknown" VARCHAR,
"same_incident_id" VARCHAR,
"latitude" VARCHAR,
"latitude_unknown" VARCHAR,
"longitude" VARCHAR,
"longitude_unknown" VARCHAR,
"address" VARCHAR,
"address_unknown" VARCHAR,
"city" VARCHAR,
"city_unknown" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"zip_code_unknown" VARCHAR,
"roadway_type" VARCHAR,
"roadway_surface" VARCHAR,
"roadway_description" VARCHAR,
"posted_speed_limit_mph" DOUBLE,
"posted_speed_limit_unknown" VARCHAR,
"lighting" VARCHAR,
"weather_clear" VARCHAR,
"weather_snow" VARCHAR,
"weather_cloudy" VARCHAR,
"weather_fog_smoke" VARCHAR,
"weather_rain" VARCHAR,
"weather_severe_wind" VARCHAR,
"weather_unknown" VARCHAR,
"weather_other" VARCHAR,
"weather_other_text" VARCHAR,
"crash_with" VARCHAR,
"highest_injury_severity" VARCHAR,
"property_damage" VARCHAR,
"cp_pre_crash_movement" VARCHAR,
"cp_any_air_bags_deployed" VARCHAR,
"cp_was_vehicle_towed" VARCHAR,
"cp_contact_area_rear_left" VARCHAR,
"cp_contact_area_left" VARCHAR,
"cp_contact_area_front_left" VARCHAR,
"cp_contact_area_rear" VARCHAR,
"cp_contact_area_top" VARCHAR,
"cp_contact_area_front" VARCHAR,
"cp_contact_area_rear_right" VARCHAR,
"cp_contact_area_right" VARCHAR,
"cp_contact_area_front_right" VARCHAR,
"cp_contact_area_bottom" VARCHAR,
"cp_contact_area_unknown" VARCHAR,
"sv_pre_crash_movement" VARCHAR,
"sv_any_air_bags_deployed" VARCHAR,
"sv_was_vehicle_towed" VARCHAR,
"sv_were_all_passengers_belted" VARCHAR,
"sv_precrash_speed_mph" DOUBLE,
"sv_pre_crash_speed_unknown" VARCHAR,
"sv_contact_area_rear_left" VARCHAR,
"sv_contact_area_left" VARCHAR,
"sv_contact_area_front_left" VARCHAR,
"sv_contact_area_rear" VARCHAR,
"sv_contact_area_top" VARCHAR,
"sv_contact_area_front" VARCHAR,
"sv_contact_area_rear_right" VARCHAR,
"sv_contact_area_right" VARCHAR,
"sv_contact_area_front_right" VARCHAR,
"sv_contact_area_bottom" VARCHAR,
"sv_contact_area_unknown" VARCHAR
);
CREATE TABLE sgo_2021_01_incident_reports_other (
"report_id" VARCHAR,
"report_version" BIGINT,
"reporting_entity" VARCHAR,
"report_type" VARCHAR,
"report_month" DOUBLE,
"report_year" DOUBLE,
"report_submission_date" VARCHAR,
"vin" VARCHAR,
"vin_unknown" VARCHAR,
"serial_number" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"model_unknown" VARCHAR,
"model_year" DOUBLE,
"model_year_unknown" VARCHAR,
"same_vehicle_id" VARCHAR,
"mileage" DOUBLE,
"mileage_unknown" VARCHAR,
"driver_operator_type" VARCHAR,
"adas_ads_version" VARCHAR,
"adas_ads_version_unknown" VARCHAR,
"adas_ads_version_cbi" VARCHAR,
"ads_equipped" VARCHAR,
"automation_system_engaged" VARCHAR,
"operating_entity" VARCHAR,
"operating_entity_unknown" VARCHAR,
"source_complaint_claim" VARCHAR,
"source_telematics" VARCHAR,
"source_law_enforcement" VARCHAR,
"source_field_report" VARCHAR,
"source_testing" VARCHAR,
"source_media" VARCHAR,
"source_other" VARCHAR,
"source_other_text" VARCHAR,
"incident_date" VARCHAR,
"incident_date_unknown" VARCHAR,
"notice_received_date" VARCHAR,
"incident_time_24_00" VARCHAR,
"incident_time_unknown" VARCHAR,
"same_incident_id" VARCHAR,
"latitude" VARCHAR,
"latitude_unknown" VARCHAR,
"longitude" VARCHAR,
"longitude_unknown" VARCHAR,
"address" VARCHAR,
"address_unknown" VARCHAR,
"city" VARCHAR,
"city_unknown" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"zip_code_unknown" VARCHAR,
"roadway_type" VARCHAR,
"roadway_surface" VARCHAR,
"roadway_description" VARCHAR,
"posted_speed_limit_mph" DOUBLE,
"posted_speed_limit_unknown" VARCHAR,
"lighting" VARCHAR,
"weather_clear" VARCHAR,
"weather_snow" VARCHAR,
"weather_cloudy" VARCHAR,
"weather_fog_smoke" VARCHAR,
"weather_rain" VARCHAR,
"weather_severe_wind" VARCHAR,
"weather_unknown" VARCHAR,
"weather_other" VARCHAR,
"weather_other_text" VARCHAR,
"crash_with" VARCHAR,
"highest_injury_severity" VARCHAR,
"property_damage" VARCHAR,
"cp_pre_crash_movement" VARCHAR,
"cp_any_air_bags_deployed" VARCHAR,
"cp_was_vehicle_towed" VARCHAR,
"cp_contact_area_rear_left" VARCHAR,
"cp_contact_area_left" VARCHAR,
"cp_contact_area_front_left" VARCHAR,
"cp_contact_area_rear" VARCHAR,
"cp_contact_area_top" VARCHAR,
"cp_contact_area_front" VARCHAR,
"cp_contact_area_rear_right" VARCHAR,
"cp_contact_area_right" VARCHAR,
"cp_contact_area_front_right" VARCHAR,
"cp_contact_area_bottom" VARCHAR,
"cp_contact_area_unknown" VARCHAR,
"sv_pre_crash_movement" VARCHAR,
"sv_any_air_bags_deployed" VARCHAR,
"sv_was_vehicle_towed" VARCHAR,
"sv_were_all_passengers_belted" VARCHAR,
"sv_precrash_speed_mph" DOUBLE,
"sv_pre_crash_speed_unknown" VARCHAR,
"sv_contact_area_rear_left" VARCHAR,
"sv_contact_area_left" VARCHAR,
"sv_contact_area_front_left" VARCHAR,
"sv_contact_area_rear" VARCHAR,
"sv_contact_area_top" VARCHAR,
"sv_contact_area_front" VARCHAR,
"sv_contact_area_rear_right" VARCHAR,
"sv_contact_area_right" VARCHAR,
"sv_contact_area_front_right" VARCHAR,
"sv_contact_area_bottom" VARCHAR,
"sv_contact_area_unknown" VARCHAR
);
Anyone who has the link will be able to view this.