About this Dataset

Road Safety

Detailed data about personal injury accidents on public roads in York that are reported to the police and subsequently recorded, using the STATS19 accident reporting form, from 2005 onwards. The Accident_Index attribute gives a unique index for each accident and links to Vehicle and Casualty data. Casualties are linked to vehicles by the “VEHREF” attribute. The Longitude and Latitude data is based on WGS 1984. The key for all of the coded values of the data is provided within the "Road Safety Key" resource. For more information such as casualties, details on vehicles or breath-test or blood alcohol content, please visit Road Safety data for GB Data extracted from publication by Department for Transport, licensed under Open Government Licence
Publisher name: City of York Council
Last updated: 2024-09-14T14:52:29Z

Tables

Accidents

@ukgov.road_safety.accidents

275.99 KB
6515 rows
32 columns


CREATE TABLE accidents (
  "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" BIGINT,
  "speed_limit" BIGINT,
  "junction_detail" BIGINT,
  "junction_control" BIGINT,
  "n_2nd_road_class" BIGINT,
  "n_2nd_road_number" BIGINT,
  "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
);

Casualties

@ukgov.road_safety.casualties

49.17 KB
8203 rows
16 columns


CREATE TABLE casualties (
  "acc_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_maenance_worker" BIGINT,
  "casualty_type" BIGINT,
  "casualty_home_area_type" BIGINT,
  "casualty_imd_decile" DOUBLE
);

Road Safety Key

@ukgov.road_safety.road_safety_key

23.5 KB
1240 rows
5 columns


CREATE TABLE road_safety_key (
  "id" BIGINT,
  "attribute" VARCHAR,
  "code" BIGINT,
  "label" VARCHAR,
  "dataset" VARCHAR
);

Vehicles

@ukgov.road_safety.vehicles

117.87 KB
12101 rows
23 columns


CREATE TABLE vehicles (
  "acc_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_po_of_impact" BIGINT,
  "was_vehicle_left_hand_drive" BIGINT,
  "journey_purpose_of_driver" BIGINT,
  "sex_of_driver" BIGINT,
  "age_of_driver" BIGINT,
  "age_band_of_driver" BIGINT,
  "engine_capacity_cc" BIGINT,
  "propulsion_code" BIGINT,
  "age_of_vehicle" BIGINT,
  "driver_imd_decile" BIGINT,
  "driver_home_area_type" BIGINT,
  "vehicle_imd_decile" DOUBLE
);