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.17 MB
37,583 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

787.77 kB
25,791 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

670.74 kB
21,403 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

52.95 kB
1,237 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
);