About this Dataset

Road Traffic Accidents

Information on accidents across Leeds. Data includes location, number of people and vehicles involved, road surface, weather conditions and severity of any casualties. Please note ----------- * The Eastings and Northings are generated at the roadside where the accident occurred. Sometimes due to poor internet connectivity this data is may not be as accurate as it could be. If you notice any errors please contact accident.studies@leeds.gov.uk. Due to the format of the report a number of figures in the columns are repeated, these are: * Reference Number * Easting * Northing * Number of Vehicles * Accident Date * Time (24hr) * 1st Road Class * Road Surface * Lighting Conditions * Weather Conditions Reference Number Grid Ref: Easting Grid Ref: Northing Number of vehicles Accident Date Time (24hr) 21G0539 427798 426248 5 16/01/2015 1205 21G0539 427798 426248 5 16/01/2015 1205 21G1108 431142 430087 1 16/01/2015 1732 21H0565 434602 436699> 1 17/01/2015 930 21H0638 434254 434318 2 17/01/2015 1315 21H0638 434254 434318 2 17/01/2015 1315 Therefore the number of vehicles involved in accident 21G0539 were 5, and in accident 21H0638 were 2. Overall in the example above a total of 9 vehicles were involved in accidents A useful tool to analyse the data is Excel pivot tables, these help summarise large amounts of data in a easy to view table, for further information on pivot table visit here. Further Information ------------------- * Please see the guidance document for further information on categories.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:49:44Z

Tables

Guidance

@ukgov.road_traffic_accidents.guidance

3.67 KB
76 rows
2 columns


CREATE TABLE guidance (
  "n_1st_road_class" VARCHAR,
  "n_1st_road_class_desc" VARCHAR
);

2009

@ukgov.road_traffic_accidents.n_2009

71.15 KB
3057 rows
15 columns


CREATE TABLE n_2009 (
  "reference_number" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2010

@ukgov.road_traffic_accidents.n_2010

66.6 KB
2765 rows
15 columns


CREATE TABLE n_2010 (
  "reference_number" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2011

@ukgov.road_traffic_accidents.n_2011

63.8 KB
2686 rows
15 columns


CREATE TABLE n_2011 (
  "reference_number" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2012

@ukgov.road_traffic_accidents.n_2012

64.36 KB
2748 rows
15 columns


CREATE TABLE n_2012 (
  "reference_number" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2013

@ukgov.road_traffic_accidents.n_2013

64.42 KB
2433 rows
16 columns


CREATE TABLE n_2013 (
  "reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" BIGINT,
  "unnamed_11" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "unnamed_15" VARCHAR
);

2014

@ukgov.road_traffic_accidents.n_2014

67.66 KB
2533 rows
16 columns


CREATE TABLE n_2014 (
  "reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" BIGINT,
  "unnamed_11" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2015

@ukgov.road_traffic_accidents.n_2015

68.23 KB
2664 rows
15 columns


CREATE TABLE n_2015 (
  "reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" VARCHAR,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2016

@ukgov.road_traffic_accidents.n_2016

68.03 KB
2549 rows
16 columns


CREATE TABLE n_2016 (
  "reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "expr1" VARCHAR,
  "accident_date" TIMESTAMP,
  "time_24hr" BIGINT,
  "n_1st_road_class" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT,
  "type_of_vehicle" VARCHAR
);

2017

@ukgov.road_traffic_accidents.n_2017

62.54 KB
2203 rows
15 columns


CREATE TABLE n_2017 (
  "reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" TIMESTAMP,
  "time_24hr" BIGINT,
  "n_1st_road_class_no" VARCHAR,
  "road_surface" VARCHAR,
  "lighting_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "type_of_vehicle" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_severity" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_of_casualty" BIGINT
);

2018

@ukgov.road_traffic_accidents.n_2018

89.29 KB
1995 rows
21 columns


CREATE TABLE n_2018 (
  "accident_fields_reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" TIMESTAMP,
  "time_24hr" BIGINT,
  "n_1st_road_class" BIGINT,
  "n_1st_road_class_no" VARCHAR,
  "road_surface" BIGINT,
  "lighting_conditions" BIGINT,
  "weather_conditions" BIGINT,
  "local_authority" VARCHAR,
  "vehicle_fields_reference_number" VARCHAR,
  "vehicle_number" BIGINT,
  "type_of_vehicle" BIGINT,
  "casualty_fields_reference_number" VARCHAR,
  "casualty_veh_no" BIGINT,
  "casualty_class" BIGINT,
  "casualty_severity" BIGINT,
  "sex_of_casualty" BIGINT,
  "age_of_casualty" BIGINT
);

2019

@ukgov.road_traffic_accidents.n_2019

59.67 KB
1907 rows
18 columns


CREATE TABLE n_2019 (
  "reference_number" VARCHAR,
  "grid_ref_easting" BIGINT,
  "grid_ref_northing" BIGINT,
  "number_of_vehicles" BIGINT,
  "accident_date" TIMESTAMP,
  "time_24hr" BIGINT,
  "n_1st_road_class" BIGINT,
  "n_1st_road_class_no" VARCHAR,
  "road_surface" BIGINT,
  "lighting_conditions" BIGINT,
  "weather_conditions" BIGINT,
  "local_authority" VARCHAR,
  "vehicle_number" BIGINT,
  "type_of_vehicle" BIGINT,
  "casualty_class" BIGINT,
  "casualty_severity" BIGINT,
  "sex_of_casualty" BIGINT,
  "age_of_casualty" BIGINT
);