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.57 MB
159,531 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.75 MB
198,681 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

4.05 MB
216,469 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.85 MB
196,222 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.59 MB
179,293 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.49 MB
167,546 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.69 MB
137,301 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.54 MB
125,265 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.74 MB
137,511 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.65 MB
103,352 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.28 MB
159,886 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.89 MB
123,074 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.28 MB
108,840 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.81 MB
135,855 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.28 MB
134,181 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.45 MB
122,488 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

644.35 kB
16,039 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
);