{"table":"accident","variable":"accident_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"accident","variable":"accident_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"accident","variable":"accident_severity","type":"character"}
{"table":"accident","variable":"accident_year","type":"numeric"}
{"table":"accident","variable":"carriageway_hazards","type":"character"}
{"table":"accident","variable":"collision_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"accident","variable":"collision_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"accident","variable":"collision_year","type":"numeric"}
{"table":"accident","variable":"date","type":"character"}
{"table":"accident","variable":"day_of_week","type":"character"}
{"table":"accident","variable":"did_police_officer_attend_scene_of_accident","type":"character"}
{"table":"accident","variable":"did_police_officer_attend_scene_of_collision","type":"character"}
{"table":"accident","variable":"enhanced_collision_severity","note":"category introduced where collected in 2023","type":"character"}
{"table":"accident","variable":"first_road_class","type":"character"}
{"table":"accident","variable":"first_road_number","type":"character"}
{"table":"accident","variable":"junction_control","type":"character"}
{"table":"accident","variable":"junction_detail","type":"character"}
{"table":"accident","variable":"latitude","note":"Null if not known","type":"numeric"}
{"table":"accident","variable":"legacy_collision_severity","type":"character"}
{"table":"accident","variable":"light_conditions","type":"character"}
{"table":"accident","variable":"local_authority_district","type":"character"}
{"table":"accident","variable":"local_authority_highway","type":"character"}
{"table":"accident","variable":"local_authority_ons_district","type":"character"}
{"table":"accident","variable":"location_easting_osgr","note":"Null if not known","type":"numeric"}
{"table":"accident","variable":"location_northing_osgr","note":"Null if not known","type":"numeric"}
{"table":"accident","variable":"longitude","note":"Null if not known","type":"numeric"}
{"table":"accident","variable":"lsoa_of_accident_location","note":"England and Wales only. See Office for National Statistics (ONS) guidance: https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeography","type":"character"}
{"table":"accident","variable":"lsoa_of_collision_location","note":"England and Wales only. See Office for National Statistics (ONS) guidance: https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeography","type":"character"}
{"table":"accident","variable":"number_of_casualties","type":"character"}
{"table":"accident","variable":"number_of_vehicles","type":"character"}
{"table":"accident","variable":"pedestrian_crossing_human_control","type":"character"}
{"table":"accident","variable":"pedestrian_crossing_physical_facilities","type":"character"}
{"table":"accident","variable":"police_force","type":"character"}
{"table":"accident","variable":"road_surface_conditions","type":"character"}
{"table":"accident","variable":"road_type","type":"character"}
{"table":"accident","variable":"second_road_class","type":"character"}
{"table":"accident","variable":"second_road_number","type":"character"}
{"table":"accident","variable":"special_conditions_at_site","type":"character"}
{"table":"accident","variable":"speed_limit","note":"20,30,40,50,60,70 are the only valid speed limits on public highways","type":"character"}
{"table":"accident","variable":"time","note":"Null if not known","type":"character"}
{"table":"accident","variable":"trunk_road_flag","type":"character"}
{"table":"accident","variable":"urban_or_rural_area","note":"field introduced in 1994","type":"character"}
{"table":"accident","variable":"weather_conditions","type":"character"}
{"table":"casualty","variable":"accident_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"casualty","variable":"accident_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"casualty","variable":"accident_year","type":"numeric"}
{"table":"casualty","variable":"age_band_of_casualty","type":"character"}
{"table":"casualty","variable":"age_of_casualty","type":"numeric"}
{"table":"casualty","variable":"bus_or_coach_passenger","type":"character"}
{"table":"casualty","variable":"car_passenger","type":"character"}
{"table":"casualty","variable":"casualty_class","type":"character"}
{"table":"casualty","variable":"casualty_distance_banding","note":"field introduced in 2023","type":"character"}
{"table":"casualty","variable":"casualty_home_area_type","note":"field introduced in 1999","type":"character"}
{"table":"casualty","variable":"casualty_imd_decile","note":"field introduced in 2016","type":"character"}
{"table":"casualty","variable":"casualty_reference","note":"unique value for each casualty in a singular accident (historical years may be unique to a singular vehicle in a road accident)","type":"character"}
{"table":"casualty","variable":"casualty_severity","type":"character"}
{"table":"casualty","variable":"casualty_type","type":"character"}
{"table":"casualty","variable":"collision_index","type":"character"}
{"table":"casualty","variable":"collision_reference","type":"character"}
{"table":"casualty","variable":"collision_year","type":"numeric"}
{"table":"casualty","variable":"enhanced_casualty_severity","note":"category introduced where collected in 2023","type":"character"}
{"table":"casualty","variable":"lsoa_of_casualty","note":"England and Wales only. See Office for National Statistics (ONS) guidance: https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeography","type":"character"}
{"table":"casualty","variable":"pedestrian_location","type":"character"}
{"table":"casualty","variable":"pedestrian_movement","type":"character"}
{"table":"casualty","variable":"pedestrian_road_maintenance_worker","type":"character"}
{"table":"casualty","variable":"sex_of_casualty","type":"character"}
{"table":"casualty","variable":"vehicle_reference","note":"unique value for each vehicle in a singular accident. Can be used to join a Casualty to a vehicle","type":"character"}
{"table":"casualty_adjustment","variable":"accident_index","type":"character"}
{"table":"casualty_adjustment","variable":"accident_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"casualty_adjustment","variable":"accident_year","type":"numeric"}
{"table":"casualty_adjustment","variable":"adjusted_serious","note":"unique value for each casualty in a singular accident (historical years may be unique to a singular vehicle in a road accident)","type":"numeric"}
{"table":"casualty_adjustment","variable":"adjusted_slight","type":"numeric"}
{"table":"casualty_adjustment","variable":"casualty_reference","note":"unique value for each vehicle in a singular accident. Can be used to join a Casualty to a vehicle","type":"character"}
{"table":"casualty_adjustment","variable":"injury_based","type":"character"}
{"table":"casualty_adjustment","variable":"vehicle_reference","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"collision_adjustment","variable":"accident_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"collision_adjustment","variable":"accident_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"collision_adjustment","variable":"accident_year","type":"numeric"}
{"table":"collision_adjustment","variable":"adjusted_serious","type":"numeric"}
{"table":"collision_adjustment","variable":"adjusted_slight","type":"numeric"}
{"table":"collision_adjustment","variable":"injury_based","type":"character"}
{"table":"historical_revisions","variable":"accident_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"historical_revisions","variable":"accident_ref_no","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"historical_revisions","variable":"accident_year","type":"numeric"}
{"table":"historical_revisions","variable":"casualty_reference","note":"unique value for each casualty in a singular accident (historical years may be unique to a singular vehicle in a road accident)","type":"character"}
{"table":"historical_revisions","variable":"effective_date_of_change","note":"Date the change was made","type":"character"}
{"table":"historical_revisions","variable":"police_force","note":"(See above)","type":"character"}
{"table":"historical_revisions","variable":"previously_published_value","type":"character"}
{"table":"historical_revisions","variable":"replacement_value","type":"character"}
{"table":"historical_revisions","variable":"variable","note":"(See police_force values in accident listings for values)","type":"character"}
{"table":"historical_revisions","variable":"vehicle_reference","note":"unique value for each vehicle in a singular accident. Can be used to join a Casualty to a vehicle","type":"character"}
{"table":"vehicle","variable":"accident_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"vehicle","variable":"accident_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"vehicle","variable":"accident_year","type":"numeric"}
{"table":"vehicle","variable":"age_band_of_driver","type":"character"}
{"table":"vehicle","variable":"age_of_driver","type":"numeric"}
{"table":"vehicle","variable":"age_of_vehicle","type":"numeric"}
{"table":"vehicle","variable":"collision_index","note":"unique value for each accident. The accident_index combines the accident_year and accident_ref_no to form a unique ID. It can be used to join to Vehicle and Casualty","type":"character"}
{"table":"vehicle","variable":"collision_reference","note":"In year id used by the police to reference a collision. It is not unique outside of the year, use accident_index for linking to other years","type":"character"}
{"table":"vehicle","variable":"collision_year","type":"numeric"}
{"table":"vehicle","variable":"dir_from_e","note":"field introduced in 2023","type":"character"}
{"table":"vehicle","variable":"dir_from_n","note":"field introduced in 2023","type":"character"}
{"table":"vehicle","variable":"dir_to_e","note":"field introduced in 2023","type":"character"}
{"table":"vehicle","variable":"dir_to_n","note":"field introduced in 2023","type":"character"}
{"table":"vehicle","variable":"driver_distance_banding","note":"field introduced in 2023","type":"character"}
{"table":"vehicle","variable":"driver_home_area_type","note":"field introduced in 1999","type":"character"}
{"table":"vehicle","variable":"driver_imd_decile","note":"field introduced in 2016","type":"character"}
{"table":"vehicle","variable":"engine_capacity_cc","type":"numeric"}
{"table":"vehicle","variable":"escooter_flag","note":"field introduced in 2023","type":"character"}
{"table":"vehicle","variable":"first_point_of_impact","type":"character"}
{"table":"vehicle","variable":"generic_make_model","note":"field introduced in 2020","type":"character"}
{"table":"vehicle","variable":"hit_object_in_carriageway","type":"character"}
{"table":"vehicle","variable":"hit_object_off_carriageway","type":"character"}
{"table":"vehicle","variable":"journey_purpose_of_driver","type":"character"}
{"table":"vehicle","variable":"junction_location","type":"character"}
{"table":"vehicle","variable":"lsoa_of_driver","note":"England and Wales only. See Office for National Statistics (ONS) guidance: https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeography","type":"character"}
{"table":"vehicle","variable":"propulsion_code","type":"character"}
{"table":"vehicle","variable":"sex_of_driver","type":"character"}
{"table":"vehicle","variable":"skidding_and_overturning","type":"character"}
{"table":"vehicle","variable":"towing_and_articulation","type":"character"}
{"table":"vehicle","variable":"vehicle_direction_from","note":"both vehicle_direction_from and vehicle_direction_to should be 0","type":"character"}
{"table":"vehicle","variable":"vehicle_direction_to","note":"both vehicle_direction_from and vehicle_direction_to should be 0","type":"character"}
{"table":"vehicle","variable":"vehicle_leaving_carriageway","type":"character"}
{"table":"vehicle","variable":"vehicle_left_hand_drive","type":"character"}
{"table":"vehicle","variable":"vehicle_location_restricted_lane","type":"character"}
{"table":"vehicle","variable":"vehicle_manoeuvre","type":"character"}
{"table":"vehicle","variable":"vehicle_reference","note":"unique value for each vehicle in a singular accident. Can be used to join a Casualty to a vehicle","type":"character"}
{"table":"vehicle","variable":"vehicle_type","type":"character"}