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 -- VIN - Unknown,
"serial_number" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"model_unknown" VARCHAR -- Model - Unknown,
"model_year" BIGINT,
"model_year_unknown" VARCHAR -- Model Year - Unknown,
"same_vehicle_id" VARCHAR,
"mileage" DOUBLE,
"mileage_unknown" VARCHAR -- Mileage - Unknown,
"driver_operator_type" VARCHAR -- Driver / Operator Type,
"adas_ads_version" VARCHAR,
"adas_ads_version_unknown" VARCHAR -- ADAS/ADS Version - Unknown,
"adas_ads_version_cbi" VARCHAR,
"ads_equipped" VARCHAR -- ADS Equipped?,
"automation_system_engaged" VARCHAR -- Automation System Engaged?,
"operating_entity" VARCHAR,
"operating_entity_unknown" VARCHAR -- Operating Entity - Unknown,
"source_complaint_claim" VARCHAR -- Source - Complaint/Claim,
"source_telematics" VARCHAR -- Source - Telematics,
"source_law_enforcement" VARCHAR -- Source - Law Enforcement,
"source_field_report" VARCHAR -- Source - Field Report,
"source_testing" VARCHAR -- Source - Testing,
"source_media" VARCHAR -- Source - Media,
"source_other" VARCHAR -- Source - Other,
"source_other_text" VARCHAR -- Source - Other Text,
"incident_date" VARCHAR,
"incident_date_unknown" VARCHAR -- Incident Date - Unknown,
"notice_received_date" VARCHAR,
"incident_time_24_00" VARCHAR -- Incident Time (24:00),
"incident_time_unknown" VARCHAR -- Incident Time - Unknown,
"same_incident_id" VARCHAR,
"latitude" VARCHAR,
"latitude_unknown" VARCHAR -- Latitude - Unknown,
"longitude" VARCHAR,
"longitude_unknown" VARCHAR -- Longitude - Unknown,
"address" VARCHAR,
"address_unknown" VARCHAR -- Address - Unknown,
"city" VARCHAR,
"city_unknown" VARCHAR -- City - Unknown,
"state" VARCHAR,
"zip_code" VARCHAR,
"zip_code_unknown" VARCHAR -- Zip Code - Unknown,
"roadway_type" VARCHAR,
"roadway_surface" VARCHAR,
"roadway_description" VARCHAR,
"posted_speed_limit_mph" DOUBLE -- Posted Speed Limit (MPH),
"posted_speed_limit_unknown" VARCHAR -- Posted Speed Limit - Unknown,
"lighting" VARCHAR,
"weather_clear" VARCHAR -- Weather - Clear,
"weather_snow" VARCHAR -- Weather - Snow,
"weather_cloudy" VARCHAR -- Weather - Cloudy,
"weather_fog_smoke" VARCHAR -- Weather - Fog/Smoke,
"weather_rain" VARCHAR -- Weather - Rain,
"weather_severe_wind" VARCHAR -- Weather - Severe Wind,
"weather_unknown" VARCHAR -- Weather - Unknown,
"weather_other" VARCHAR -- Weather - Other,
"weather_other_text" VARCHAR -- Weather - Other Text,
"crash_with" VARCHAR,
"highest_injury_severity" VARCHAR,
"property_damage" VARCHAR -- Property Damage?,
"cp_pre_crash_movement" VARCHAR,
"cp_any_air_bags_deployed" VARCHAR -- CP Any Air Bags Deployed?,
"cp_was_vehicle_towed" VARCHAR -- CP Was Vehicle Towed?,
"cp_contact_area_rear_left" VARCHAR -- CP Contact Area - Rear Left,
"cp_contact_area_left" VARCHAR -- CP Contact Area - Left,
"cp_contact_area_front_left" VARCHAR -- CP Contact Area - Front Left,
"cp_contact_area_rear" VARCHAR -- CP Contact Area - Rear,
"cp_contact_area_top" VARCHAR -- CP Contact Area - Top,
"cp_contact_area_front" VARCHAR -- CP Contact Area - Front,
"cp_contact_area_rear_right" VARCHAR -- CP Contact Area - Rear Right,
"cp_contact_area_right" VARCHAR -- CP Contact Area - Right,
"cp_contact_area_front_right" VARCHAR -- CP Contact Area - Front Right,
"cp_contact_area_bottom" VARCHAR -- CP Contact Area - Bottom,
"cp_contact_area_unknown" VARCHAR -- CP Contact Area - Unknown,
"sv_pre_crash_movement" VARCHAR,
"sv_any_air_bags_deployed" VARCHAR -- SV Any Air Bags Deployed?,
"sv_was_vehicle_towed" VARCHAR -- SV Was Vehicle Towed?,
"sv_were_all_passengers_belted" VARCHAR -- SV Were All Passengers Belted?,
"sv_precrash_speed_mph" DOUBLE -- SV Precrash Speed (MPH),
"sv_pre_crash_speed_unknown" VARCHAR -- SV Pre-crash Speed - Unknown,
"sv_contact_area_rear_left" VARCHAR -- SV Contact Area - Rear Left,
"sv_contact_area_left" VARCHAR -- SV Contact Area - Left,
"sv_contact_area_front_left" VARCHAR -- SV Contact Area - Front Left,
"sv_contact_area_rear" VARCHAR -- SV Contact Area - Rear,
"sv_contact_area_top" VARCHAR -- SV Contact Area - Top,
"sv_contact_area_front" VARCHAR -- SV Contact Area - Front,
"sv_contact_area_rear_right" VARCHAR -- SV Contact Area - Rear Right,
"sv_contact_area_right" VARCHAR -- SV Contact Area - Right,
"sv_contact_area_front_right" VARCHAR -- SV Contact Area - Front Right,
"sv_contact_area_bottom" VARCHAR -- SV Contact Area - Bottom,
"sv_contact_area_unknown" VARCHAR -- SV Contact Area - Unknown
);
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 -- VIN - Unknown,
"serial_number" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"model_unknown" VARCHAR -- Model - Unknown,
"model_year" DOUBLE,
"model_year_unknown" VARCHAR -- Model Year - Unknown,
"same_vehicle_id" VARCHAR,
"mileage" DOUBLE,
"mileage_unknown" VARCHAR -- Mileage - Unknown,
"driver_operator_type" VARCHAR -- Driver / Operator Type,
"adas_ads_version" VARCHAR,
"adas_ads_version_unknown" VARCHAR -- ADAS/ADS Version - Unknown,
"adas_ads_version_cbi" VARCHAR,
"ads_equipped" VARCHAR -- ADS Equipped?,
"automation_system_engaged" VARCHAR -- Automation System Engaged?,
"operating_entity" VARCHAR,
"operating_entity_unknown" VARCHAR -- Operating Entity - Unknown,
"source_complaint_claim" VARCHAR -- Source - Complaint/Claim,
"source_telematics" VARCHAR -- Source - Telematics,
"source_law_enforcement" VARCHAR -- Source - Law Enforcement,
"source_field_report" VARCHAR -- Source - Field Report,
"source_testing" VARCHAR -- Source - Testing,
"source_media" VARCHAR -- Source - Media,
"source_other" VARCHAR -- Source - Other,
"source_other_text" VARCHAR -- Source - Other Text,
"incident_date" VARCHAR,
"incident_date_unknown" VARCHAR -- Incident Date - Unknown,
"notice_received_date" VARCHAR,
"incident_time_24_00" VARCHAR -- Incident Time (24:00),
"incident_time_unknown" VARCHAR -- Incident Time - Unknown,
"same_incident_id" VARCHAR,
"latitude" VARCHAR,
"latitude_unknown" VARCHAR -- Latitude - Unknown,
"longitude" VARCHAR,
"longitude_unknown" VARCHAR -- Longitude - Unknown,
"address" VARCHAR,
"address_unknown" VARCHAR -- Address - Unknown,
"city" VARCHAR,
"city_unknown" VARCHAR -- City - Unknown,
"state" VARCHAR,
"zip_code" VARCHAR,
"zip_code_unknown" VARCHAR -- Zip Code - Unknown,
"roadway_type" VARCHAR,
"roadway_surface" VARCHAR,
"roadway_description" VARCHAR,
"posted_speed_limit_mph" DOUBLE -- Posted Speed Limit (MPH),
"posted_speed_limit_unknown" VARCHAR -- Posted Speed Limit - Unknown,
"lighting" VARCHAR,
"weather_clear" VARCHAR -- Weather - Clear,
"weather_snow" VARCHAR -- Weather - Snow,
"weather_cloudy" VARCHAR -- Weather - Cloudy,
"weather_fog_smoke" VARCHAR -- Weather - Fog/Smoke,
"weather_rain" VARCHAR -- Weather - Rain,
"weather_severe_wind" VARCHAR -- Weather - Severe Wind,
"weather_unknown" VARCHAR -- Weather - Unknown,
"weather_other" VARCHAR -- Weather - Other,
"weather_other_text" VARCHAR -- Weather - Other Text,
"crash_with" VARCHAR,
"highest_injury_severity" VARCHAR,
"property_damage" VARCHAR -- Property Damage?,
"cp_pre_crash_movement" VARCHAR,
"cp_any_air_bags_deployed" VARCHAR -- CP Any Air Bags Deployed?,
"cp_was_vehicle_towed" VARCHAR -- CP Was Vehicle Towed?,
"cp_contact_area_rear_left" VARCHAR -- CP Contact Area - Rear Left,
"cp_contact_area_left" VARCHAR -- CP Contact Area - Left,
"cp_contact_area_front_left" VARCHAR -- CP Contact Area - Front Left,
"cp_contact_area_rear" VARCHAR -- CP Contact Area - Rear,
"cp_contact_area_top" VARCHAR -- CP Contact Area - Top,
"cp_contact_area_front" VARCHAR -- CP Contact Area - Front,
"cp_contact_area_rear_right" VARCHAR -- CP Contact Area - Rear Right,
"cp_contact_area_right" VARCHAR -- CP Contact Area - Right,
"cp_contact_area_front_right" VARCHAR -- CP Contact Area - Front Right,
"cp_contact_area_bottom" VARCHAR -- CP Contact Area - Bottom,
"cp_contact_area_unknown" VARCHAR -- CP Contact Area - Unknown,
"sv_pre_crash_movement" VARCHAR,
"sv_any_air_bags_deployed" VARCHAR -- SV Any Air Bags Deployed?,
"sv_was_vehicle_towed" VARCHAR -- SV Was Vehicle Towed?,
"sv_were_all_passengers_belted" VARCHAR -- SV Were All Passengers Belted?,
"sv_precrash_speed_mph" DOUBLE -- SV Precrash Speed (MPH),
"sv_pre_crash_speed_unknown" VARCHAR -- SV Pre-crash Speed - Unknown,
"sv_contact_area_rear_left" VARCHAR -- SV Contact Area - Rear Left,
"sv_contact_area_left" VARCHAR -- SV Contact Area - Left,
"sv_contact_area_front_left" VARCHAR -- SV Contact Area - Front Left,
"sv_contact_area_rear" VARCHAR -- SV Contact Area - Rear,
"sv_contact_area_top" VARCHAR -- SV Contact Area - Top,
"sv_contact_area_front" VARCHAR -- SV Contact Area - Front,
"sv_contact_area_rear_right" VARCHAR -- SV Contact Area - Rear Right,
"sv_contact_area_right" VARCHAR -- SV Contact Area - Right,
"sv_contact_area_front_right" VARCHAR -- SV Contact Area - Front Right,
"sv_contact_area_bottom" VARCHAR -- SV Contact Area - Bottom,
"sv_contact_area_unknown" VARCHAR -- SV Contact Area - Unknown
);
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 -- VIN - Unknown,
"serial_number" VARCHAR,
"make" VARCHAR,
"model" VARCHAR,
"model_unknown" VARCHAR -- Model - Unknown,
"model_year" DOUBLE,
"model_year_unknown" VARCHAR -- Model Year - Unknown,
"same_vehicle_id" VARCHAR,
"mileage" DOUBLE,
"mileage_unknown" VARCHAR -- Mileage - Unknown,
"driver_operator_type" VARCHAR -- Driver / Operator Type,
"adas_ads_version" VARCHAR,
"adas_ads_version_unknown" VARCHAR -- ADAS/ADS Version - Unknown,
"adas_ads_version_cbi" VARCHAR,
"ads_equipped" VARCHAR -- ADS Equipped?,
"automation_system_engaged" VARCHAR -- Automation System Engaged?,
"operating_entity" VARCHAR,
"operating_entity_unknown" VARCHAR -- Operating Entity - Unknown,
"source_complaint_claim" VARCHAR -- Source - Complaint/Claim,
"source_telematics" VARCHAR -- Source - Telematics,
"source_law_enforcement" VARCHAR -- Source - Law Enforcement,
"source_field_report" VARCHAR -- Source - Field Report,
"source_testing" VARCHAR -- Source - Testing,
"source_media" VARCHAR -- Source - Media,
"source_other" VARCHAR -- Source - Other,
"source_other_text" VARCHAR -- Source - Other Text,
"incident_date" VARCHAR,
"incident_date_unknown" VARCHAR -- Incident Date - Unknown,
"notice_received_date" VARCHAR,
"incident_time_24_00" VARCHAR -- Incident Time (24:00),
"incident_time_unknown" VARCHAR -- Incident Time - Unknown,
"same_incident_id" VARCHAR,
"latitude" VARCHAR,
"latitude_unknown" VARCHAR -- Latitude - Unknown,
"longitude" VARCHAR,
"longitude_unknown" VARCHAR -- Longitude - Unknown,
"address" VARCHAR,
"address_unknown" VARCHAR -- Address - Unknown,
"city" VARCHAR,
"city_unknown" VARCHAR -- City - Unknown,
"state" VARCHAR,
"zip_code" VARCHAR,
"zip_code_unknown" VARCHAR -- Zip Code - Unknown,
"roadway_type" VARCHAR,
"roadway_surface" VARCHAR,
"roadway_description" VARCHAR,
"posted_speed_limit_mph" DOUBLE -- Posted Speed Limit (MPH),
"posted_speed_limit_unknown" VARCHAR -- Posted Speed Limit - Unknown,
"lighting" VARCHAR,
"weather_clear" VARCHAR -- Weather - Clear,
"weather_snow" VARCHAR -- Weather - Snow,
"weather_cloudy" VARCHAR -- Weather - Cloudy,
"weather_fog_smoke" VARCHAR -- Weather - Fog/Smoke,
"weather_rain" VARCHAR -- Weather - Rain,
"weather_severe_wind" VARCHAR -- Weather - Severe Wind,
"weather_unknown" VARCHAR -- Weather - Unknown,
"weather_other" VARCHAR -- Weather - Other,
"weather_other_text" VARCHAR -- Weather - Other Text,
"crash_with" VARCHAR,
"highest_injury_severity" VARCHAR,
"property_damage" VARCHAR -- Property Damage?,
"cp_pre_crash_movement" VARCHAR,
"cp_any_air_bags_deployed" VARCHAR -- CP Any Air Bags Deployed?,
"cp_was_vehicle_towed" VARCHAR -- CP Was Vehicle Towed?,
"cp_contact_area_rear_left" VARCHAR -- CP Contact Area - Rear Left,
"cp_contact_area_left" VARCHAR -- CP Contact Area - Left,
"cp_contact_area_front_left" VARCHAR -- CP Contact Area - Front Left,
"cp_contact_area_rear" VARCHAR -- CP Contact Area - Rear,
"cp_contact_area_top" VARCHAR -- CP Contact Area - Top,
"cp_contact_area_front" VARCHAR -- CP Contact Area - Front,
"cp_contact_area_rear_right" VARCHAR -- CP Contact Area - Rear Right,
"cp_contact_area_right" VARCHAR -- CP Contact Area - Right,
"cp_contact_area_front_right" VARCHAR -- CP Contact Area - Front Right,
"cp_contact_area_bottom" VARCHAR -- CP Contact Area - Bottom,
"cp_contact_area_unknown" VARCHAR -- CP Contact Area - Unknown,
"sv_pre_crash_movement" VARCHAR,
"sv_any_air_bags_deployed" VARCHAR -- SV Any Air Bags Deployed?,
"sv_was_vehicle_towed" VARCHAR -- SV Was Vehicle Towed?,
"sv_were_all_passengers_belted" VARCHAR -- SV Were All Passengers Belted?,
"sv_precrash_speed_mph" DOUBLE -- SV Precrash Speed (MPH),
"sv_pre_crash_speed_unknown" VARCHAR -- SV Pre-crash Speed - Unknown,
"sv_contact_area_rear_left" VARCHAR -- SV Contact Area - Rear Left,
"sv_contact_area_left" VARCHAR -- SV Contact Area - Left,
"sv_contact_area_front_left" VARCHAR -- SV Contact Area - Front Left,
"sv_contact_area_rear" VARCHAR -- SV Contact Area - Rear,
"sv_contact_area_top" VARCHAR -- SV Contact Area - Top,
"sv_contact_area_front" VARCHAR -- SV Contact Area - Front,
"sv_contact_area_rear_right" VARCHAR -- SV Contact Area - Rear Right,
"sv_contact_area_right" VARCHAR -- SV Contact Area - Right,
"sv_contact_area_front_right" VARCHAR -- SV Contact Area - Front Right,
"sv_contact_area_bottom" VARCHAR -- SV Contact Area - Bottom,
"sv_contact_area_unknown" VARCHAR -- SV Contact Area - Unknown
);
Anyone who has the link will be able to view this.