Dataset: UK Road Safety: Traffic Accidents And Vehicles

About this Dataset

UK Road Safety: Traffic Accidents And Vehicles

Context

The UK government collects and publishes (usually on an annual basis) detailed information about traffic accidents across the country. This information includes, but is not limited to, geographical locations, weather conditions, type of vehicles, number of casualties and vehicle manoeuvres, making this a very interesting and comprehensive dataset for analysis and research.

The creation of this dataset was inspired by the one previously published by Dave Fisher-Hickey. However, this current dataset features the following significant improvements over its predecessor:

It covers a wider date range of events.
Most of the coded data variables have been transformed to textual strings using relevant lookup tables, enabling more efficient and "human-readable" analysis.
It features detailed information about the vehicles involved in the accidents.

Content

The data come from the Open Data website of the UK government, where they have been published by the Department of Transport.

The dataset comprises of two csv files:

Accident_Information.csv: every line in the file represents a unique traffic accident (identified by the Accident_Index column), featuring various properties related to the accident as columns. Date range: 2005-2017
Vehicle_Information.csv: every line in the file represents the involvement of a unique vehicle in a unique traffic accident, featuring various vehicle and passenger properties as columns. Date range: 2004-2016

The two above-mentioned files/datasets can be linked through the unique traffic accident identifier (Accident_Index column).

The dataset will keep being updated as more data become available by the Department of Transport.

Acknowledgements

Thanks to Dave Fisher-Hickey for previously publishing, what I consider to be, the first solid and structured version of this dataset on Kaggle.

Also thanks to data.gov.uk for making this information publicly available.

Last but not least, thanks to The Data Lab for allocating me some much needed time to assemble this dataset.

Inspiration

Go crazy using the dataset. Don't go crazy while driving.

Tables

Accident Information

@kaggle.tsiaras_uk_road_safety_accidents_and_vehicles.accident_information

92.33 MB
2047256 rows
34 columns


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