Name: UK Accidents 10 Years History With Many Variables
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

UK Accidents 10 Years History With Many Variables

Context

These files provide detailed road safety data about the circumstances of personal injury road accidents in GB from 2005 to 2014,

Content

Accident file: main data set contains information about accident severity, weather, location, date, hour, day of week, road type...
Vehicle file: contains information about vehicle type, vehicle model, engine size, driver sex, driver age, car age...
Casualty file: contains information about casualty severity, age, sex social class, casualty type, pedestrian or car passenger...
Lookup file: contains the text description of all variable code in the three files

License

OGL:Open Government License
http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

Inspiration

This dataset contains a large amount of rows and features to explore.

Data Wrangling:

Merge different files
Map column code with their text strings fro a lookup table.
How do you map lat/long to a country a city?

Data Explanatory:

How the weather impact the number or severity of an accident?
Does driver age has an effect on the number of accident?
What is the relation between hour, day, week, month with number of fatal accident?
Are certain car models safer than others?
Is the social class of a casualty dependant of the accident severity?

Forecasting:

Can you forecast the future daily/weekly/monthly accidents?
What about fatal accidents can you predict them?
Can you predict if an accident was fatal ?(similar to Titanic prediction but with more row and more variables)

Feel free to suggest other external data to this dataset.

Tables

Accidents0514

@kaggle.benoit72_uk_accidents_10_years_history_with_many_variables.accidents0514

70.67 MB
1,640,597 rows
32 columns

CREATE TABLE accidents0514 (
  "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
);

Casualties0514

@kaggle.benoit72_uk_accidents_10_years_history_with_many_variables.casualties0514

19.01 MB
2,216,720 rows
15 columns

CREATE TABLE casualties0514 (
  "accident_index" VARCHAR,
  "vehicle_reference" BIGINT,
  "casualty_reference" BIGINT,
  "casualty_class" BIGINT,
  "sex_of_casualty" BIGINT,
  "age_of_casualty" BIGINT,
  "age_band_of_casualty" BIGINT,
  "casualty_severity" BIGINT,
  "pedestrian_location" BIGINT,
  "pedestrian_movement" BIGINT,
  "car_passenger" BIGINT,
  "bus_or_coach_passenger" BIGINT,
  "pedestrian_road_maintenance_worker" BIGINT,
  "casualty_type" BIGINT,
  "casualty_home_area_type" BIGINT
);

Vehicles0514

@kaggle.benoit72_uk_accidents_10_years_history_with_many_variables.vehicles0514

36.25 MB
3,004,425 rows
22 columns

CREATE TABLE vehicles0514 (
  "accident_index" VARCHAR,
  "vehicle_reference" BIGINT,
  "vehicle_type" BIGINT,
  "towing_and_articulation" BIGINT,
  "vehicle_manoeuvre" BIGINT,
  "vehicle_location_restricted_lane" BIGINT,
  "junction_location" BIGINT,
  "skidding_and_overturning" BIGINT,
  "hit_object_in_carriageway" BIGINT,
  "vehicle_leaving_carriageway" BIGINT,
  "hit_object_off_carriageway" BIGINT,
  "n_1st_point_of_impact" BIGINT  -- 1st Point Of Impact,
  "was_vehicle_left_hand_drive" BIGINT  -- Was Vehicle Left Hand Drive?,
  "journey_purpose_of_driver" BIGINT,
  "sex_of_driver" BIGINT,
  "age_of_driver" BIGINT,
  "age_band_of_driver" BIGINT,
  "engine_capacity_cc" BIGINT  -- Engine Capacity (CC),
  "propulsion_code" BIGINT,
  "age_of_vehicle" BIGINT,
  "driver_imd_decile" BIGINT,
  "driver_home_area_type" BIGINT
);