Baselight

UK 2016 Road Safety Data

Data from the UK Department for Transport

@kaggle.bluehorseshoe_uk_2016_road_safety_data

Loading...
Loading...

About this Dataset

UK 2016 Road Safety Data

Context

UK police forces collect data on every vehicle collision in the UK on a form called Stats19. Data from this form ends up at the DfT and is published at https://data.gov.uk/dataset/road-accidents-safety-data

Content

There are 4 CSVs and an Excel file in this set. Accidents is the primary table and has references by Accident_Index to the other tables.

Acknowledgements

Department for Transport and the UK's wonderful Open Gov initiative https://data.gov.uk/

Inspiration

  • Are there patterns for accidents involving different road users?
  • Can we predict the safest / most dangerous times to travel
  • Can this data help route cyclists around accident hotspots taking into account the time of day, weather, route etc
  • Are certain cars more accident prone than others?

Tables

Cas

@kaggle.bluehorseshoe_uk_2016_road_safety_data.cas
  • 1.71 MB
  • 181384 rows
  • 16 columns
Loading...

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
);

Dftroadsafety Accidents 2016

@kaggle.bluehorseshoe_uk_2016_road_safety_data.dftroadsafety_accidents_2016
  • 6.63 MB
  • 136621 rows
  • 32 columns
Loading...

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
);

Makemodel2016

@kaggle.bluehorseshoe_uk_2016_road_safety_data.makemodel2016
  • 3.8 MB
  • 252500 rows
  • 24 columns
Loading...

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
);

Veh

@kaggle.bluehorseshoe_uk_2016_road_safety_data.veh
  • 3.16 MB
  • 252500 rows
  • 23 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.