About this Dataset

Northern Ireland Planning Statistics Annual Dataset

These datasets accompany the Northern Ireland planning statistics annual reports, which are usually published in June/July each year. They contain finalised, validated information on received and decided planning applications during the year, as well as pending applications as at the end of the financial year.
Publisher name: OpenDataNI
Last updated: 2025-07-01T04:00:30Z

Tables

Northern Ireland Planning Statistics 2023/24 Annual Dataset

@ukgov.northern_ireland_planning_statistics_annual_dataset.northern_ireland_planning_statistics_2023_24_annual_dataset

2.11 MB
18172 rows
27 columns


CREATE TABLE northern_ireland_planning_statistics_2023_24_annual_dataset (
  "id" VARCHAR,
  "datereceived" TIMESTAMP,
  "receivedq" VARCHAR,
  "datevalid" TIMESTAMP,
  "authority" VARCHAR,
  "lpa19cd" VARCHAR,
  "lpa19nm" VARCHAR,
  "constituency" VARCHAR,
  "apptype" VARCHAR,
  "classification" VARCHAR,
  "statscategory" VARCHAR,
  "urban_rural" VARCHAR,
  "housingtype" VARCHAR,
  "renewabletype" VARCHAR,
  "proposal" VARCHAR,
  "siteaddress" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "status_31mar" VARCHAR,
  "decision_withdrawal" VARCHAR,
  "decisionissueddate" TIMESTAMP,
  "decidedq" VARCHAR,
  "datewithdrawn" TIMESTAMP,
  "withdrawnq" VARCHAR,
  "processingtime_wks" DOUBLE,
  "live_31mar" DOUBLE,
  "timeinsystem" VARCHAR
);

Northern Ireland Planning Statistics 2024/25 Annual Dataset

@ukgov.northern_ireland_planning_statistics_annual_dataset.northern_ireland_planning_statistics_2024_25_annual_dataset

2.03 MB
17428 rows
27 columns


CREATE TABLE northern_ireland_planning_statistics_2024_25_annual_dataset (
  "id" VARCHAR,
  "datereceived" TIMESTAMP,
  "receivedq" VARCHAR,
  "datevalid" TIMESTAMP,
  "authority" VARCHAR,
  "lpa19cd" VARCHAR,
  "lpa19nm" VARCHAR,
  "constituency" VARCHAR,
  "apptype" VARCHAR,
  "classification" VARCHAR,
  "statscategory" VARCHAR,
  "urban_rural" VARCHAR,
  "housingtype" VARCHAR,
  "renewabletype" VARCHAR,
  "proposal" VARCHAR,
  "siteaddress" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "status_31mar" VARCHAR,
  "decision_withdrawal" VARCHAR,
  "decisionissueddate" TIMESTAMP,
  "decidedq" VARCHAR,
  "datewithdrawn" TIMESTAMP,
  "withdrawnq" VARCHAR,
  "processingtime_wks" DOUBLE,
  "live_31mar" DOUBLE,
  "timeinsystem" VARCHAR
);