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

282.62 kB
6,515 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 (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
);

Casualties

@ukgov.road_safety.casualties

50.34 kB
8,203 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

24.06 kB
1,240 rows
5 columns

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

Vehicles

@ukgov.road_safety.vehicles

120.7 kB
12,101 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  -- 1st Po 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,
  "vehicle_imd_decile" DOUBLE
);