Baselight
Sign In

1.6 Million UK Traffic Accidents

Visualise and analyse traffic demographics

@kaggle.daveianhickey_2000_16_traffic_flow_england_scotland_wales

Loading...
Loading...

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
  • 24.27 MB
  • 570,011 rows
  • 33 columns
Loading... 
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 (District),
  "local_authority_highway" VARCHAR  -- Local Authority (Highway),
  "n_1st_road_class" BIGINT  -- 1st Road Class,
  "n_1st_road_number" BIGINT  -- 1st Road Number,
  "road_type" VARCHAR,
  "speed_limit" BIGINT,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "n_2nd_road_class" BIGINT  -- 2nd Road Class,
  "n_2nd_road_number" BIGINT  -- 2nd Road Number,
  "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
  • 20.24 MB
  • 469,442 rows
  • 33 columns
Loading... 
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 (District),
  "local_authority_highway" VARCHAR  -- Local Authority (Highway),
  "n_1st_road_class" BIGINT  -- 1st Road Class,
  "n_1st_road_number" BIGINT  -- 1st Road Number,
  "road_type" VARCHAR,
  "speed_limit" BIGINT,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "n_2nd_road_class" BIGINT  -- 2nd Road Class,
  "n_2nd_road_number" BIGINT  -- 2nd Road Number,
  "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
  • 20.29 MB
  • 464,697 rows
  • 33 columns
Loading... 
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 (District),
  "local_authority_highway" VARCHAR  -- Local Authority (Highway),
  "n_1st_road_class" BIGINT  -- 1st Road Class,
  "n_1st_road_number" BIGINT  -- 1st Road Number,
  "road_type" VARCHAR,
  "speed_limit" BIGINT,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "n_2nd_road_class" BIGINT  -- 2nd Road Class,
  "n_2nd_road_number" BIGINT  -- 2nd Road Number,
  "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
  • 11.21 MB
  • 275,385 rows
  • 29 columns
Loading... 
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
);

Share link

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