Name: UK Car Accidents 2005-2015
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

UK Car Accidents 2005-2015

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 3 CSVs in this set. Accidents is the primary one and has references by Accident_Index to the casualties and vehicles tables. This might be better done as a database.

Inspiration

Questions to ask of this data -

combined with population data, how do different areas compare?
what trends are there for accidents involving different road users eg motorcycles, peds, cyclists
are road safety campaigns effective?
likelihood of accidents for different groups / vehicles
many more..

Manifest

dft05-15.tgz - tar of Accidents0515.csv, Casualties0515.csv and Vehicles0515.csv
tidydata.sh - script to get and tidy data.

Tables

Accidents0515

@kaggle.silicon99_dft_accident_data.accidents0515

77.04 MB
1,780,653 rows
32 columns

CREATE TABLE accidents0515 (
  "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" BIGINT,
  "speed_limit" BIGINT,
  "junction_detail" BIGINT,
  "junction_control" BIGINT,
  "n_2nd_road_class" BIGINT  -- 2nd Road Class,
  "n_2nd_road_number" BIGINT  -- 2nd Road Number,
  "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
);