About this Dataset

Police Recorded Injury Road Traffic Collision Statistics Northern Ireland 2024

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: 2025-04-15T04:02:25Z

Tables

Casualties 2024

@ukgov.police_recorded_injury_road_traffic_collision_statisti_46cdf139.casualties_2024

68.06 kB
7,494 rows
14 columns

CREATE TABLE casualties_2024 (
  "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 2024

@ukgov.police_recorded_injury_road_traffic_collision_statisti_46cdf139.collisions_2024

133.61 kB
4,753 rows
25 columns

CREATE TABLE collisions_2024 (
  "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 2024

@ukgov.police_recorded_injury_road_traffic_collision_statisti_46cdf139.vehicles_2024

82.31 kB
8,822 rows
17 columns

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