About this Dataset

Police Recorded Injury Road Traffic Collision Statistics Northern Ireland 2023

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 broadly 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: 2024-07-29T22:13:29Z

Tables

Casualties 2023

@ukgov.police_recorded_injury_road_traffic_collision_statisti_b74d55ea.casualties_2023

68.04 KB
7985 rows
14 columns


CREATE TABLE casualties_2023 (
  "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 2023

@ukgov.police_recorded_injury_road_traffic_collision_statisti_b74d55ea.collisions_2023

136.85 KB
5058 rows
25 columns


CREATE TABLE collisions_2023 (
  "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 2023

@ukgov.police_recorded_injury_road_traffic_collision_statisti_b74d55ea.vehicles_2023

83.8 KB
9406 rows
17 columns


CREATE TABLE vehicles_2023 (
  "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
);