Northern Ireland Annual Descriptive House Price Statistics (LGD Level)
OpenDataNI
@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046
OpenDataNI
@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046
CREATE TABLE semi_detached_sales_in_ards_and_north_down_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE semi_detached_sales_mid_and_east_antrim_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_antrim_and_newtownabbey_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_ards_and_north_down_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_armagh_city_banbridge_and_craigavon_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_belfast_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_causeway_coast_and_glens_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_derry_city_and_strabane_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_fermanagh_and_omagh_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_lisburn_and_castlereagh_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_mid_and_east_antrim_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_mid_ulster_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE terrace_sales_for_newry_mourne_and_down_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_antrim_and_newtownabbey_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_ards_and_north_down_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_armagh_city_banbridge_and_crai_8d5d0d33 (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_belfast_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_causeway_coast_and_glens_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_derry_city_and_strabane_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_fermanagh_and_omagh_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_lisburn_and_castlereagh_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_mid_and_east_antrim_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_mid_ulster_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
CREATE TABLE urban_property_sales_in_newry_mourne_and_down_council (
"district" VARCHAR,
"saleyr" BIGINT,
"type" VARCHAR,
"lgd_verifiedsales" BIGINT,
"reporting_minprice" BIGINT,
"reporting_lqprice" BIGINT,
"reporting_medianprice" BIGINT,
"reporting_meanprice" BIGINT,
"reporting_uqprice" BIGINT,
"reporting_maxprice" BIGINT
);
Anyone who has the link will be able to view this.