NI Housing Stock
OpenDataNI
@ukgov.ni_housing_stock
OpenDataNI
@ukgov.ni_housing_stock
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,
"n_2009_housing_stock" BIGINT,
"n_2010_housing_stock" BIGINT,
"n_2011_housing_stock" BIGINT,
"n_2012_housing_stock" BIGINT,
"n_2013_housing_stock" BIGINT,
"n_2014_housing_stock" BIGINT,
"n_2015_housing_stock" BIGINT,
"n_2016_housing_stock" BIGINT,
"n_2017_housing_stock" BIGINT,
"n_2018_housing_stock" BIGINT,
"n_2019_housing_stock" BIGINT,
"n_2020_housing_stock" BIGINT,
"n_2021_housing_stock" BIGINT,
"n_2022_housing_stock" BIGINT,
"n_2023_housing_stock" BIGINT
);
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.