Dataset: UK 2016 Road Safety Data

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


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


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


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


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