NI Housing Stock
OpenDataNI
@ukgov.ni_housing_stock
OpenDataNI
@ukgov.ni_housing_stock
In line with the Rates (Northern Ireland) Order 1977, housing stock is defined as a count of properties which are valued as domestic or mixed for the purposes of rating. This refers to properties in the Valuation list at the start of each financial year which are used (or when next in use, will be used) for the purposes of a private dwelling. This excludes caravans, domestic garages, domestic stores and car parking spaces. Private refers to a self contained dwelling and not the ownership or build type of the dwelling. Housing stock includes both social and private sector dwellings in the Valuation list.
Publisher name: OpenDataNI
Last updated: 2024-09-14T07:34:11Z
CREATE TABLE ni_housing_stock_bu_lgd_april_2009 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2009 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2012 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2013 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2014 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2015 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2016 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2017 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2018 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2019 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2020 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2021 (
"wardcode2014" VARCHAR,
"wardname2014" VARCHAR,
"lgdcode2014" VARCHAR,
"lgdname2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2022 (
"wardcode2014" VARCHAR,
"wardname2014" VARCHAR,
"lgdcode2014" VARCHAR,
"lgdname2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_april_2023 (
"wardcode2014" VARCHAR,
"wardname2014" VARCHAR,
"lgdcode2014" VARCHAR,
"lgdname2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_may_2008 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_may_2010 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_electoral_ward_may_2011 (
"ward_code_2014" VARCHAR,
"ward_name_2014" VARCHAR,
"lgd_code_2014" VARCHAR,
"lgd_name_2014" VARCHAR,
"converted_apartment" BIGINT,
"purpose_built_apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_2008_2023 (
"district_council" VARCHAR,
"n_2008_housing_stock" BIGINT -- 2008 Housing Stock,
"n_2009_housing_stock" BIGINT -- 2009 Housing Stock,
"n_2010_housing_stock" BIGINT -- 2010 Housing Stock,
"n_2011_housing_stock" BIGINT -- 2011 Housing Stock,
"n_2012_housing_stock" BIGINT -- 2012 Housing Stock,
"n_2013_housing_stock" BIGINT -- 2013 Housing Stock,
"n_2014_housing_stock" BIGINT -- 2014 Housing Stock,
"n_2015_housing_stock" BIGINT -- 2015 Housing Stock,
"n_2016_housing_stock" BIGINT -- 2016 Housing Stock,
"n_2017_housing_stock" BIGINT -- 2017 Housing Stock,
"n_2018_housing_stock" BIGINT -- 2018 Housing Stock,
"n_2019_housing_stock" BIGINT -- 2019 Housing Stock,
"n_2020_housing_stock" BIGINT -- 2020 Housing Stock,
"n_2021_housing_stock" BIGINT -- 2021 Housing Stock,
"n_2022_housing_stock" BIGINT -- 2022 Housing Stock,
"n_2023_housing_stock" BIGINT -- 2023 Housing Stock
);CREATE TABLE ni_housing_stock_by_lgd_april_2012 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_april_2013 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_april_2014 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_april_2015 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_april_2016 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_april_2017 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock_april_2017" BIGINT
);CREATE TABLE ni_housing_stock_by_lgd_april_2018 (
"district_council" VARCHAR,
"apartment" BIGINT,
"detached" BIGINT,
"semi_detached" BIGINT,
"terrace" BIGINT,
"total_housing_stock_april_2018" BIGINT
);Anyone who has the link will be able to view this.