UK 2016 Road Safety Data
Data from the UK Department for Transport
@kaggle.bluehorseshoe_uk_2016_road_safety_data
Data from the UK Department for Transport
@kaggle.bluehorseshoe_uk_2016_road_safety_data
CREATE TABLE cas (
"accident_index" VARCHAR,
"vehicle_reference" BIGINT,
"casualty_reference" BIGINT,
"casualty_class" BIGINT,
"sex_of_casualty" BIGINT,
"age_of_casualty" BIGINT,
"age_band_of_casualty" BIGINT,
"casualty_severity" BIGINT,
"pedestrian_location" BIGINT,
"pedestrian_movement" BIGINT,
"car_passenger" BIGINT,
"bus_or_coach_passenger" BIGINT,
"pedestrian_road_maintenance_worker" BIGINT,
"casualty_type" BIGINT,
"casualty_home_area_type" BIGINT,
"casualty_imd_decile" BIGINT
);
CREATE TABLE dftroadsafety_accidents_2016 (
"accident_index" VARCHAR,
"location_easting_osgr" DOUBLE,
"location_northing_osgr" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"police_force" BIGINT,
"accident_severity" BIGINT,
"number_of_vehicles" BIGINT,
"number_of_casualties" BIGINT,
"date" TIMESTAMP,
"day_of_week" BIGINT,
"time" VARCHAR,
"local_authority_district" BIGINT,
"local_authority_highway" VARCHAR,
"n_1st_road_class" BIGINT,
"n_1st_road_number" BIGINT,
"road_type" BIGINT,
"speed_limit" DOUBLE,
"junction_detail" BIGINT,
"junction_control" BIGINT,
"n_2nd_road_class" BIGINT,
"n_2nd_road_number" BIGINT,
"pedestrian_crossing_human_control" BIGINT,
"pedestrian_crossing_physical_facilities" BIGINT,
"light_conditions" BIGINT,
"weather_conditions" BIGINT,
"road_surface_conditions" BIGINT,
"special_conditions_at_site" BIGINT,
"carriageway_hazards" BIGINT,
"urban_or_rural_area" BIGINT,
"did_police_officer_attend_scene_of_accident" BIGINT,
"lsoa_of_accident_location" VARCHAR
);
CREATE TABLE makemodel2016 (
"accident_index" VARCHAR,
"accyr" BIGINT,
"vehicle_reference" BIGINT,
"vehicle_type" BIGINT,
"towing_and_articulation" BIGINT,
"vehicle_manoeuvre" BIGINT,
"vehicle_location_restricted_lane" BIGINT,
"junction_location" BIGINT,
"skidding_and_overturning" BIGINT,
"hit_object_in_carriageway" BIGINT,
"vehicle_leaving_carriageway" BIGINT,
"hit_object_off_carriageway" BIGINT,
"n_1st_point_of_impact" BIGINT,
"was_vehicle_left_hand_drive" BIGINT,
"journey_purpose_of_driver" BIGINT,
"sex_of_driver" BIGINT,
"age_band_of_driver" BIGINT,
"engine_capacity_cc" BIGINT,
"propulsion_code" BIGINT,
"age_of_vehicle" BIGINT,
"driver_imd_decile" BIGINT,
"driver_home_area_type" BIGINT,
"make" VARCHAR,
"model" VARCHAR
);
CREATE TABLE veh (
"accident_index" VARCHAR,
"vehicle_reference" BIGINT,
"vehicle_type" BIGINT,
"towing_and_articulation" BIGINT,
"vehicle_manoeuvre" BIGINT,
"vehicle_location_restricted_lane" BIGINT,
"junction_location" BIGINT,
"skidding_and_overturning" BIGINT,
"hit_object_in_carriageway" BIGINT,
"vehicle_leaving_carriageway" BIGINT,
"hit_object_off_carriageway" BIGINT,
"n_1st_point_of_impact" BIGINT,
"was_vehicle_left_hand_drive" BIGINT,
"journey_purpose_of_driver" BIGINT,
"sex_of_driver" BIGINT,
"age_of_driver" BIGINT,
"age_band_of_driver" BIGINT,
"engine_capacity_cc" BIGINT,
"propulsion_code" BIGINT,
"age_of_vehicle" BIGINT,
"driver_imd_decile" BIGINT,
"driver_home_area_type" BIGINT,
"vehicle_imd_decile" BIGINT
);
Anyone who has the link will be able to view this.