Dataset: Northern Ireland New Dwelling Completions

About this Dataset

Northern Ireland New Dwelling Completions

The tables are based on data collected by NI Building Control offices within each council. The tables are updated quarterly.
Publisher name: OpenDataNI
Last updated: 2025-06-03T04:01:08Z

Tables

New Dwelling Completions By Development Type

@ukgov.northern_ireland_new_dwelling_completions.new_dwelling_completions_by_development_type

5.77 KB
81 rows
4 columns


CREATE TABLE new_dwelling_completions_by_development_type (
  "quarter_year" VARCHAR,
  "private_owner_speculative_development" BIGINT,
  "social_housing_development" BIGINT,
  "total_new_dwelling_completions" BIGINT
);

New Dwelling Completions By LGD

@ukgov.northern_ireland_new_dwelling_completions.new_dwelling_completions_by_lgd

29.38 KB
12 rows
41 columns


CREATE TABLE new_dwelling_completions_by_lgd (
  "quarter_year" VARCHAR,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT,
  "q1_2016" BIGINT,
  "q2_2016" BIGINT,
  "q3_2016" BIGINT,
  "q4_2016" BIGINT,
  "q1_2017" BIGINT,
  "q2_2017" BIGINT,
  "q3_2017" BIGINT,
  "q4_2017" BIGINT,
  "q1_2018" BIGINT,
  "q2_2018" BIGINT,
  "q3_2018" BIGINT,
  "q4_2018" BIGINT,
  "q1_2019" BIGINT,
  "q2_2019" BIGINT,
  "q3_2019" BIGINT,
  "q4_2019" BIGINT,
  "q1_2020" BIGINT,
  "q2_2020" BIGINT,
  "q3_2020" BIGINT,
  "q4_2020" BIGINT,
  "q1_2021" BIGINT,
  "q2_2021" BIGINT,
  "q3_2021" BIGINT,
  "q4_2021" BIGINT,
  "q1_2022" BIGINT,
  "q2_2022" BIGINT,
  "q3_2022" BIGINT,
  "q4_2022" BIGINT,
  "q1_2023" BIGINT,
  "q2_2023" BIGINT,
  "q3_2023" BIGINT,
  "q4_2023" BIGINT,
  "q1_2024" BIGINT,
  "q2_2024" BIGINT,
  "q3_2024" BIGINT,
  "q4_2024" BIGINT,
  "q1_2025" BIGINT
);

Private And Speculative New Dwelling Completions By LGD Q2–2015- Q1–2025

@ukgov.northern_ireland_new_dwelling_completions.private_and_speculative_new_dwelling_completions_by_lg_35b48e73

29.35 KB
12 rows
41 columns


CREATE TABLE private_and_speculative_new_dwelling_completions_by_lg_35b48e73 (
  "lgd" VARCHAR,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT,
  "q1_2016" BIGINT,
  "q2_2016" BIGINT,
  "q3_2016" BIGINT,
  "q4_2016" BIGINT,
  "q1_2017" BIGINT,
  "q2_2017" BIGINT,
  "q3_2017" BIGINT,
  "q4_2017" BIGINT,
  "q1_2018" BIGINT,
  "q2_2018" BIGINT,
  "q3_2018" BIGINT,
  "q4_2018" BIGINT,
  "q1_2019" BIGINT,
  "q2_2019" BIGINT,
  "q3_2019" BIGINT,
  "q4_2019" BIGINT,
  "q1_2020" BIGINT,
  "q2_2020" BIGINT,
  "q3_2020" BIGINT,
  "q4_2020" BIGINT,
  "q1_2021" BIGINT,
  "q2_2021" BIGINT,
  "q3_2021" BIGINT,
  "q4_2021" BIGINT,
  "q1_2022" BIGINT,
  "q2_2022" BIGINT,
  "q3_2022" BIGINT,
  "q4_2022" BIGINT,
  "q1_2023" BIGINT,
  "q2_2023" BIGINT,
  "q3_2023" BIGINT,
  "q4_2023" BIGINT,
  "q1_2024" BIGINT,
  "q2_2024" BIGINT,
  "q3_2024" BIGINT,
  "q4_2024" BIGINT,
  "q1_2025" BIGINT
);

Social Housing New Dwelling Completions By LGD Q2–2015 - Q1–2025

@ukgov.northern_ireland_new_dwelling_completions.social_housing_new_dwelling_completions_by_lgd_q2_2015_q1_2025

28.68 KB
12 rows
41 columns


CREATE TABLE social_housing_new_dwelling_completions_by_lgd_q2_2015_q1_2025 (
  "quarter_year" VARCHAR,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT,
  "q1_2016" BIGINT,
  "q2_2016" BIGINT,
  "q3_2016" BIGINT,
  "q4_2016" BIGINT,
  "q1_2017" BIGINT,
  "q2_2017" BIGINT,
  "q3_2017" BIGINT,
  "q4_2017" BIGINT,
  "q1_2018" BIGINT,
  "q2_2018" BIGINT,
  "q3_2018" BIGINT,
  "q4_2018" BIGINT,
  "q1_2019" BIGINT,
  "q2_2019" BIGINT,
  "q3_2019" BIGINT,
  "q4_2019" BIGINT,
  "q1_2020" BIGINT,
  "q2_2020" BIGINT,
  "q3_2020" BIGINT,
  "q4_2020" BIGINT,
  "q1_2021" BIGINT,
  "q2_2021" BIGINT,
  "q3_2021" BIGINT,
  "q4_2021" BIGINT,
  "q1_2022" BIGINT,
  "q2_2022" BIGINT,
  "q3_2022" BIGINT,
  "q4_2022" BIGINT,
  "q1_2023" BIGINT,
  "q2_2023" BIGINT,
  "q3_2023" BIGINT,
  "q4_2023" BIGINT,
  "q1_2024" BIGINT,
  "q2_2024" BIGINT,
  "q3_2024" BIGINT,
  "q4_2024" BIGINT,
  "q1_2025" BIGINT
);

New Dwelling Completions By Property Type

@ukgov.northern_ireland_new_dwelling_completions.new_dwelling_completions_by_property_type

5.35 KB
81 rows
4 columns


CREATE TABLE new_dwelling_completions_by_property_type (
  "quarter_year" VARCHAR,
  "apartments" BIGINT,
  "houses" BIGINT,
  "total_new_dwelling_completions" BIGINT
);