UK Road Safety: Traffic Accidents And Vehicles
Detailed dataset of road accidents and involved vehicles in the UK (2005-2017)
@kaggle.tsiaras_uk_road_safety_accidents_and_vehicles
Detailed dataset of road accidents and involved vehicles in the UK (2005-2017)
@kaggle.tsiaras_uk_road_safety_accidents_and_vehicles
CREATE TABLE accident_information (
"accident_index" VARCHAR,
"n_1st_road_class" VARCHAR,
"n_1st_road_number" DOUBLE,
"n_2nd_road_class" VARCHAR,
"n_2nd_road_number" DOUBLE,
"accident_severity" VARCHAR,
"carriageway_hazards" VARCHAR,
"date" TIMESTAMP,
"day_of_week" VARCHAR,
"did_police_officer_attend_scene_of_accident" DOUBLE,
"junction_control" VARCHAR,
"junction_detail" VARCHAR,
"latitude" DOUBLE,
"light_conditions" VARCHAR,
"local_authority_district" VARCHAR,
"local_authority_highway" VARCHAR,
"location_easting_osgr" DOUBLE,
"location_northing_osgr" DOUBLE,
"longitude" DOUBLE,
"lsoa_of_accident_location" VARCHAR,
"number_of_casualties" BIGINT,
"number_of_vehicles" BIGINT,
"pedestrian_crossing_human_control" DOUBLE,
"pedestrian_crossing_physical_facilities" DOUBLE,
"police_force" VARCHAR,
"road_surface_conditions" VARCHAR,
"road_type" VARCHAR,
"special_conditions_at_site" VARCHAR,
"speed_limit" DOUBLE,
"time" VARCHAR,
"urban_or_rural_area" VARCHAR,
"weather_conditions" VARCHAR,
"year" BIGINT,
"inscotland" VARCHAR
);
Anyone who has the link will be able to view this.