About this Dataset

Street Lighting Faults

This dataset shows street light faults maintained by DfI Roads in Northern Ireland that were reported by members of the public.
Publisher name: OpenDataNI
Last updated: 2025-04-15T04:02:29Z

Tables

Lighting Faults 2021/2022

@ukgov.lighting_faults.lighting_faults_2021_2022

1.11 MB
37583 rows
10 columns


CREATE TABLE lighting_faults_2021_2022 (
  "data_uid" BIGINT,
  "instruction_reference" VARCHAR,
  "date_recorded" VARCHAR,
  "section_name" VARCHAR,
  "asset_type" VARCHAR,
  "opertaional_area" VARCHAR,
  "fault_type" VARCHAR,
  "input_source" VARCHAR,
  "status" VARCHAR,
  "cleared_comments" VARCHAR
);

Lighting Faults 2023/2024

@ukgov.lighting_faults.lighting_faults_2023_2024

769.31 KB
25791 rows
10 columns


CREATE TABLE lighting_faults_2023_2024 (
  "data_uid" BIGINT,
  "instruction_reference" VARCHAR,
  "date_recorded" VARCHAR,
  "section_name" VARCHAR,
  "asset_type" VARCHAR,
  "opertaional_area" VARCHAR,
  "fault_type" VARCHAR,
  "input_source" VARCHAR,
  "status" VARCHAR,
  "cleared_comments" VARCHAR
);

Lighting Faults 2024/2025

@ukgov.lighting_faults.lighting_faults_2024_2025

655.02 KB
21403 rows
10 columns


CREATE TABLE lighting_faults_2024_2025 (
  "data_uid" BIGINT,
  "instruction_reference" VARCHAR,
  "date_recorded" VARCHAR,
  "section_name" VARCHAR,
  "asset_type" VARCHAR,
  "opertaional_area" VARCHAR,
  "fault_type" VARCHAR,
  "input_source" VARCHAR,
  "status" VARCHAR,
  "cleared_comments" VARCHAR
);

Lighting Faults 2025 To Date

@ukgov.lighting_faults.lighting_faults_2025_to_date

51.7 KB
1237 rows
10 columns


CREATE TABLE lighting_faults_2025_to_date (
  "data_uid" BIGINT,
  "instruction_reference" VARCHAR,
  "date_recorded" VARCHAR,
  "section_name" VARCHAR,
  "asset_type" VARCHAR,
  "opertaional_area" VARCHAR,
  "fault_type" VARCHAR,
  "input_source" VARCHAR,
  "status" VARCHAR,
  "cleared_comments" VARCHAR
);