Skip to content

Column Definitions for Dataset

Jump to bottom
Heidi Landenberger edited this page Mar 18, 2018 · 4 revisions

Source: Label Information from Original Data Source

Column Definitions for our Cleaned Data:

  • 'Accident Index': Unique index of the accident
  • 'Longitude': Longitude
  • 'Latitude' : Latitude
  • 'Police_Force' : which police force was the accident reported to
    • 1 = Metropolitan Police
    • 3 = Cumbria
    • 4 = Lancashire
    • 5 = Merseyside
    • 6 = Greater Manchester
    • 7 = Cheshire
    • 10 = Northumbria
    • 11 = Durham
    • 12 = North Yorkshire
    • 13 = West Yorkshire
    • 14 = South Yorkshire
    • 16 = Humberside
    • 17 = Cleveland
    • 20 = West Midlands
    • 21 = Staffordshire
    • 22 = West Mercia
    • 23 = Warwickshire
    • 30 = Derbyshire
    • 31 = Nottinghamshire
    • 32 = Lincolnshire
    • 33 = Leicestershire
    • 34 = Northamptonshire
    • 35 = Cambridgeshire
    • 36 = Norfolk
    • 37 = Suffolk
    • 40 = Bedfordshire
    • 41 = Hertfordshire
    • 42 = Essex
    • 43 = Thames Valley
    • 44 = Hampshire
    • 45 = Surrey
    • 46 = Kent
    • 47 = Sussex
    • 48 = City of London
    • 50 = Devon and Cornwall
    • 52 = Avon and Somerset
    • 53 = Gloucestershire
    • 54 = Wiltshire
    • 55 = Dorset
    • 60 = North Wales
    • 61 = Gwent
    • 62 = South Wales
    • 63 = Dyfed-Powys
    • 91 = Northern
    • 92 = Grampian
    • 93 = Tayside
    • 94 = Fife
    • 95 = Lothian and Borders
    • 96 = Central
    • 97 = Strathclyde
    • 98 = Dumfries and Galloway
  • 'Accident_Severity' :
    • 1 = Fatal
    • 2 = Serious
    • 3 = Minor
  • 'Number_of_Vehicles' : Number of vehicles involved in the accident
  • 'Number_of_Casualties' : Total number of injuries (as reported to the police)
  • 'Date' : Date of the accident in Day/Month/Year format
  • 'Day_of_Week' : Integer from 1-7 where 1 is Sunday, 2 is Monday, and so on
  • 'Time' : Time the accident was reported, in UTC+0.
  • 'Local_Authority_(District)' : 'Local Authority District',
  • 'Local_Authority_(Highway)' : 'Local Authority Highway',
  • '1st_Road_Class' : '1st Road Class',
  • '1st_Road_Number' : '1st Road Number',
  • 'Road_Type' : 'Road Type',
  • 'Speed_limit' : 'Speed Limit',
  • 'Junction_Control' : 'Junction Control',
  • '2nd_Road_Class' : '2nd Road Class',
  • '2nd_Road_Number' : '2nd Road Number',
  • 'Pedestrian_Crossing-Human_Control' : 'Pedestrian Crossing Human Control',
  • 'Pedestrian_Crossing-Physical_Facilities' : 'Pedestrian Crossing Physical Facilities',
  • 'Light_Conditions' : 'Light Conditions',
  • 'Weather_Conditions' : 'Weather Conditions',
  • 'Road_Surface_Conditions' : 'Road Surface Conditions',
  • 'Special_Conditions_at_Site' : 'Special Conditions at Site',
  • 'Carriageway_Hazards' : 'Carriageway Hazards',
  • 'Urban_or_Rural_Area' : 1 is Urban and 2 is Rural
  • 'Did_Police_Officer_Attend_Scene_of_Accident' : 'Police Attended Scene of Accident',
  • 'LSOA_of_Accident_Location' : 'LSOA of Accident Location',
  • 'Year' : Year
Clone this wiki locally