About this Dataset

Police Recorded Injury Road Traffic Collision Statistics Northern Ireland 2022

The PSNI produces statistics on injury road traffic collisions (RTCs) that are reported to the Police. These statistics are collected in accordance with the STATS20 guidance from the Department for Transport (DfT) and are comparable with the statistics in Great Britain (GB). Damage only collisions or those collisions resulting in no injuries are excluded from these statistics.
Publisher name: OpenDataNI
Last updated: 2023-07-27T04:00:02Z

Tables

Casualties 2022

@ukgov.police_recorded_injury_road_traffic_collision_statisti_e4d5dbd1.casualties_2022

67.59 KB
7846 rows
14 columns


CREATE TABLE casualties_2022 (
  "a_year" BIGINT,
  "a_ref" BIGINT,
  "v_id" BIGINT,
  "c_id" BIGINT,
  "c_class" BIGINT,
  "c_sex" BIGINT,
  "c_agegroup" BIGINT,
  "c_sever" BIGINT,
  "c_loc" VARCHAR,
  "c_move" VARCHAR,
  "c_school" BIGINT,
  "c_pcv" VARCHAR,
  "c_pedinj" VARCHAR,
  "c_vtype" VARCHAR
);

Collisions 2022

@ukgov.police_recorded_injury_road_traffic_collision_statisti_e4d5dbd1.collisions_2022

137.55 KB
5116 rows
25 columns


CREATE TABLE collisions_2022 (
  "a_year" BIGINT,
  "a_ref" BIGINT,
  "a_district" VARCHAR,
  "a_type" BIGINT,
  "a_veh" BIGINT,
  "a_cas" BIGINT,
  "a_wkday" VARCHAR,
  "a_day" BIGINT,
  "a_month" BIGINT,
  "a_hour" BIGINT,
  "a_min" BIGINT,
  "a_gd1" BIGINT,
  "a_gd2" BIGINT,
  "a_ctype" BIGINT,
  "a_speed" BIGINT,
  "a_jdet" VARCHAR,
  "a_jcont" VARCHAR,
  "a_pedhum" VARCHAR,
  "a_pedphys" VARCHAR,
  "a_light" VARCHAR,
  "a_weat" VARCHAR,
  "a_roadsc" VARCHAR,
  "a_speccs" VARCHAR,
  "a_chaz" VARCHAR,
  "a_scene" VARCHAR
);

Vehicles 2022

@ukgov.police_recorded_injury_road_traffic_collision_statisti_e4d5dbd1.vehicles_2022

85.52 KB
9570 rows
17 columns


CREATE TABLE vehicles_2022 (
  "a_year" BIGINT,
  "a_ref" BIGINT,
  "v_id" BIGINT,
  "v_type" BIGINT,
  "v_tow" BIGINT,
  "v_man" BIGINT,
  "v_loc" BIGINT,
  "v_junc" VARCHAR,
  "v_skid" VARCHAR,
  "v_hit" VARCHAR,
  "v_leave" VARCHAR,
  "v_hitoff" VARCHAR,
  "v_impact" BIGINT,
  "v_sex" BIGINT,
  "v_agegroup" BIGINT,
  "v_hitr" BIGINT,
  "v_forreg" VARCHAR
);