Name: 1.6 Million UK Traffic Accidents
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

1.6 Million UK Traffic Accidents

Context

The UK government amassed traffic data from 2000 and 2016, recording over 1.6 million accidents in the process and making this one of the most comprehensive traffic data sets out there. It's a huge picture of a country undergoing change.

Note that all the contained accident data comes from police reports, so this data does not include minor incidents.

Content

ukTrafficAADF.csv tracks how much traffic there was on all major roads in the given time period (2000 through 2016). AADT, the core statistic included in this file, stands for "Average Annual Daily Flow", and is a measure of how activity a road segment based on how many vehicle trips traverse it. The AADT page on Wikipedia is a good reference on the subject.

Accidents data is split across three CSV files: accidents_2005_to_2007.csv, accidents_2009_to_2011.csv, and accidents_2012_to_2014.csv. These three files together constitute 1.6 million traffic accidents. The total time period is 2005 through 2014, but 2008 is missing.

A data dictionary for the raw dataset at large is available from the UK Department of Transport website here. For descriptions of individual columns, see the column metadata.

Acknowledgements

The license for this dataset is the Open Givernment Licence used by all data on data.gov.uk (here). The raw datasets are available from the UK Department of Transport website here.

Inspiration

How has changing traffic flow impacted accidents?
Can we predict accident rates over time? What might improve accident rates?
Plot interactive maps of changing trends, e.g. How has London has changed for cyclists? Busiest roads in the nation?
Which areas never change and why? Identify infrastructure needs, failings and successes.
How have Rural and Urban areas differed (see RoadCategory)? How about the differences between England, Scotland, and Wales?
The UK government also like to look at miles driven. You can do this by multiplying the AADF by the corresponding length of road (link length) and by the number of days in the years. What does this tell you about UK roads?

Tables

Accidents 2005 To 2007

@kaggle.daveianhickey_2000_16_traffic_flow_england_scotland_wales.accidents_2005_to_2007

23.14 MB
570011 rows
33 columns


CREATE TABLE accidents_2005_to_2007 (
  "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" VARCHAR,
  "speed_limit" BIGINT,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "n_2nd_road_class" BIGINT,
  "n_2nd_road_number" BIGINT,
  "pedestrian_crossing_human_control" VARCHAR,
  "pedestrian_crossing_physical_facilities" VARCHAR,
  "light_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "road_surface_conditions" VARCHAR,
  "special_conditions_at_site" VARCHAR,
  "carriageway_hazards" VARCHAR,
  "urban_or_rural_area" BIGINT,
  "did_police_officer_attend_scene_of_accident" VARCHAR,
  "lsoa_of_accident_location" VARCHAR,
  "year" BIGINT
);

Accidents 2009 To 2011

@kaggle.daveianhickey_2000_16_traffic_flow_england_scotland_wales.accidents_2009_to_2011

19.3 MB
469442 rows
33 columns


CREATE TABLE accidents_2009_to_2011 (
  "accident_index" VARCHAR,
  "location_easting_osgr" BIGINT,
  "location_northing_osgr" BIGINT,
  "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" VARCHAR,
  "speed_limit" BIGINT,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "n_2nd_road_class" BIGINT,
  "n_2nd_road_number" BIGINT,
  "pedestrian_crossing_human_control" VARCHAR,
  "pedestrian_crossing_physical_facilities" VARCHAR,
  "light_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "road_surface_conditions" VARCHAR,
  "special_conditions_at_site" VARCHAR,
  "carriageway_hazards" VARCHAR,
  "urban_or_rural_area" BIGINT,
  "did_police_officer_attend_scene_of_accident" VARCHAR,
  "lsoa_of_accident_location" VARCHAR,
  "year" BIGINT
);

Accidents 2012 To 2014

@kaggle.daveianhickey_2000_16_traffic_flow_england_scotland_wales.accidents_2012_to_2014

19.35 MB
464697 rows
33 columns


CREATE TABLE accidents_2012_to_2014 (
  "accident_index" VARCHAR,
  "location_easting_osgr" BIGINT,
  "location_northing_osgr" BIGINT,
  "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" VARCHAR,
  "speed_limit" BIGINT,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "n_2nd_road_class" BIGINT,
  "n_2nd_road_number" BIGINT,
  "pedestrian_crossing_human_control" VARCHAR,
  "pedestrian_crossing_physical_facilities" VARCHAR,
  "light_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "road_surface_conditions" VARCHAR,
  "special_conditions_at_site" VARCHAR,
  "carriageway_hazards" VARCHAR,
  "urban_or_rural_area" BIGINT,
  "did_police_officer_attend_scene_of_accident" VARCHAR,
  "lsoa_of_accident_location" VARCHAR,
  "year" BIGINT
);

Uktrafficaadf

@kaggle.daveianhickey_2000_16_traffic_flow_england_scotland_wales.uktrafficaadf

10.69 MB
275385 rows
29 columns


CREATE TABLE uktrafficaadf (
  "aadfyear" BIGINT,
  "cp" BIGINT,
  "estimation_method" VARCHAR,
  "estimation_method_detailed" VARCHAR,
  "region" VARCHAR,
  "localauthority" VARCHAR,
  "road" VARCHAR,
  "roadcategory" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "startjunction" VARCHAR,
  "endjunction" VARCHAR,
  "linklength_km" DOUBLE,
  "linklength_miles" DOUBLE,
  "pedalcycles" BIGINT,
  "motorcycles" BIGINT,
  "carstaxis" BIGINT,
  "busescoaches" BIGINT,
  "lightgoodsvehicles" BIGINT,
  "v2axlerigidhgv" BIGINT,
  "v3axlerigidhgv" BIGINT,
  "v4or5axlerigidhgv" BIGINT,
  "v3or4axleartichgv" BIGINT,
  "v5axleartichgv" BIGINT,
  "v6ormoreaxleartichgv" BIGINT,
  "allhgvs" BIGINT,
  "allmotorvehicles" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE
);