About this Dataset

Pothole Enquiries

This dataset shows public enquiries and complaints of potholes recorded on public roads maintained by DfI Roads in Northern Ireland.
Publisher name: OpenDataNI
Last updated: 2025-04-15T04:02:34Z

Tables

Pothole Enquiries 2014/2015

@ukgov.pothole_enquiries.pothole_enquiries_2014_2015

32.98 kB
1,250 rows
8 columns

CREATE TABLE pothole_enquiries_2014_2015 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2015/2016

@ukgov.pothole_enquiries.pothole_enquiries_2015_2016

183.04 kB
6,403 rows
8 columns

CREATE TABLE pothole_enquiries_2015_2016 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2016/2017

@ukgov.pothole_enquiries.pothole_enquiries_2016_2017

173.73 kB
5,929 rows
8 columns

CREATE TABLE pothole_enquiries_2016_2017 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2017/2018

@ukgov.pothole_enquiries.pothole_enquiries_2017_2018

524.48 kB
18,334 rows
8 columns

CREATE TABLE pothole_enquiries_2017_2018 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2018/2019

@ukgov.pothole_enquiries.pothole_enquiries_2018_2019

392.44 kB
13,776 rows
8 columns

CREATE TABLE pothole_enquiries_2018_2019 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2019/2020

@ukgov.pothole_enquiries.pothole_enquiries_2019_2020

368.12 kB
12,788 rows
8 columns

CREATE TABLE pothole_enquiries_2019_2020 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2020/2021

@ukgov.pothole_enquiries.pothole_enquiries_2020_2021

472.86 kB
16,622 rows
8 columns

CREATE TABLE pothole_enquiries_2020_2021 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2021/2022

@ukgov.pothole_enquiries.pothole_enquiries_2021_2022

377.1 kB
12,933 rows
8 columns

CREATE TABLE pothole_enquiries_2021_2022 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR
);

Pothole Enquiries 2023/2024

@ukgov.pothole_enquiries.pothole_enquiries_2023_2024

887.73 kB
28,097 rows
9 columns

CREATE TABLE pothole_enquiries_2023_2024 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR,
  "section_name" VARCHAR
);

Pothole Enquiries 2024/2025

@ukgov.pothole_enquiries.pothole_enquiries_2024_2025

734.31 kB
23,016 rows
9 columns

CREATE TABLE pothole_enquiries_2024_2025 (
  "enquiry_type" VARCHAR,
  "enquiry_category" VARCHAR,
  "date_recorded" VARCHAR,
  "division" VARCHAR,
  "client_office_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "approval_status_name" VARCHAR,
  "section_name" VARCHAR
);