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.21 KB
1250 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

178.75 KB
6403 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

169.66 KB
5929 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

512.19 KB
18334 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

383.24 KB
13776 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

359.49 KB
12788 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

461.78 KB
16622 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

368.26 KB
12933 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

866.92 KB
28097 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

717.1 KB
23016 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
);