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

69.67 kB
7,985 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

140.13 kB
5,058 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

85.81 kB
9,406 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
);