About this Dataset

Carriageway And Footway Surface Defects

This dataset contains carriageway surface defects (including potholes) recorded on public roads maintained by DfI Roads in Northern Ireland. Surface defects are recorded using a range of defect categories, e.g. pothole, rutted, depressed, cracked, uneven, etc. The defect is also prioritised dependant on severity and risk to the public. This current yearly dataset is automatically updated each evening.
Publisher name: OpenDataNI
Last updated: 2025-04-15T04:02:37Z

Tables

Surface Defects 2008/2009

@ukgov.surface_defects.surface_defects_2008_2009

3.41 MB
159531 rows
9 columns


CREATE TABLE surface_defects_2008_2009 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2009/2010

@ukgov.surface_defects.surface_defects_2009_2010

3.58 MB
198681 rows
9 columns


CREATE TABLE surface_defects_2009_2010 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2010/2011

@ukgov.surface_defects.surface_defects_2010_2011

3.86 MB
216469 rows
9 columns


CREATE TABLE surface_defects_2010_2011 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2011/2012

@ukgov.surface_defects.surface_defects_2011_2012

3.67 MB
196222 rows
9 columns


CREATE TABLE surface_defects_2011_2012 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2012/2013

@ukgov.surface_defects.surface_defects_2012_2013

3.43 MB
179293 rows
9 columns


CREATE TABLE surface_defects_2012_2013 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2013/2014

@ukgov.surface_defects.surface_defects_2013_2014

4.29 MB
167546 rows
9 columns


CREATE TABLE surface_defects_2013_2014 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2014/2015

@ukgov.surface_defects.surface_defects_2014_2015

6.38 MB
137301 rows
9 columns


CREATE TABLE surface_defects_2014_2015 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2015/2016

@ukgov.surface_defects.surface_defects_2015_2016

4.32 MB
125265 rows
9 columns


CREATE TABLE surface_defects_2015_2016 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "section_name" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2016/2017

@ukgov.surface_defects.surface_defects_2016_2017

4.52 MB
137511 rows
9 columns


CREATE TABLE surface_defects_2016_2017 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2017/2018

@ukgov.surface_defects.surface_defects_2017_2018

3.48 MB
103352 rows
9 columns


CREATE TABLE surface_defects_2017_2018 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2018/2019

@ukgov.surface_defects.surface_defects_2018_2019

5.04 MB
159886 rows
9 columns


CREATE TABLE surface_defects_2018_2019 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2019/2020

@ukgov.surface_defects.surface_defects_2019_2020

4.67 MB
123074 rows
9 columns


CREATE TABLE surface_defects_2019_2020 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2020/2021

@ukgov.surface_defects.surface_defects_2020_2021

4.09 MB
108840 rows
9 columns


CREATE TABLE surface_defects_2020_2021 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

Surface Defects 2021/2022

@ukgov.surface_defects.surface_defects_2021_2022

4.59 MB
135855 rows
11 columns


CREATE TABLE surface_defects_2021_2022 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "response_time_name" VARCHAR,
  "actual_completion_date" VARCHAR
);

Surface Defects 2022/2023

@ukgov.surface_defects.surface_defects_2022_2023

5.04 MB
134181 rows
11 columns


CREATE TABLE surface_defects_2022_2023 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "response_time_name" VARCHAR,
  "actual_completion_date" VARCHAR
);

Surface Defects 2024/2025

@ukgov.surface_defects.surface_defects_2024_2025

4.24 MB
122488 rows
12 columns


CREATE TABLE surface_defects_2024_2025 (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "response_time_name" VARCHAR,
  "actual_completion_date" VARCHAR,
  "class_name" VARCHAR
);

Surface Defects 2025 To Date

@ukgov.surface_defects.surface_defects_2025_to_date

629.24 KB
16039 rows
12 columns


CREATE TABLE surface_defects_2025_to_date (
  "instruction_reference" VARCHAR,
  "defect_detail" VARCHAR,
  "section_name" VARCHAR,
  "division" VARCHAR,
  "section_office" VARCHAR,
  "recorded_date" VARCHAR,
  "defect_status" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "response_time_name" VARCHAR,
  "actual_completion_date" VARCHAR,
  "class_name" VARCHAR
);