About this Dataset

Police Recorded Injury Road Traffic Collision Statistics Northern Ireland 2021

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-04-14T06:57:35Z

Tables

Casualties 2021

@ukgov.police_recorded_injury_road_traffic_collision_statisti_dcb2ae74.casualties_2021

62.45 KB
7192 rows
14 columns


CREATE TABLE casualties_2021 (
  "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 2021

@ukgov.police_recorded_injury_road_traffic_collision_statisti_dcb2ae74.collisions_2021

128.64 KB
4704 rows
25 columns


CREATE TABLE collisions_2021 (
  "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 2021

@ukgov.police_recorded_injury_road_traffic_collision_statisti_dcb2ae74.vehicles_2021

78.61 KB
8729 rows
17 columns


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