NI House Price Index
OpenDataNI
@ukgov.nihpi_by_propertytype
OpenDataNI
@ukgov.nihpi_by_propertytype
CREATE TABLE ni_house_price_index_by_property_type (
"quarter_year" VARCHAR,
"ni_detached_property_price_index" DOUBLE,
"ni_semidetached_property_price_index" DOUBLE,
"ni_terrace_property_price_index" DOUBLE,
"ni_apartment_price_index" DOUBLE,
"ni_residential_property_price_index" DOUBLE
);
CREATE TABLE standardised_price_and_index_by_lgd (
"quarter_year" VARCHAR,
"antrim_and_newtownabbey_hpi" DOUBLE,
"antrim_and_newtownabbey_standardised_price" DOUBLE,
"ards_and_north_down_hpi" DOUBLE,
"ards_and_north_down_standardised_price" DOUBLE,
"armagh_city_banbridge_and_craigavon_hpi" DOUBLE,
"armagh_city_banbridge_and_craigavon_standardised_price" DOUBLE,
"belfast_hpi" DOUBLE,
"belfast_standardised_price" DOUBLE,
"causeway_coast_and_glens_hpi" DOUBLE,
"causeway_coast_and_glens_standardised_price" DOUBLE,
"derry_city_and_strabane_hpi" DOUBLE,
"derry_city_and_strabane_standardised_price" DOUBLE,
"fermanagh_and_omagh_hpi" DOUBLE,
"fermanagh_and_omagh_standardised_price" DOUBLE,
"lisburn_and_castlereagh_hpi" DOUBLE,
"lisburn_and_castlereagh_standardised_price" DOUBLE,
"mid_and_east_antrim_hpi" DOUBLE,
"mid_and_east_antrim_standardised_price" DOUBLE,
"mid_ulster_hpi" DOUBLE,
"mid_ulster_standardised_price" DOUBLE,
"newry_mourne_and_down_hpi" DOUBLE,
"newry_mourne_and_down_standardised_price" DOUBLE
);
CREATE TABLE standardised_price_and_index_by_nuts3 (
"quarter_year" VARCHAR,
"belfast_rppi" DOUBLE,
"belfast_standardised_price" BIGINT,
"outer_belfast_rppi" DOUBLE,
"outer_belfast_standardised_price" BIGINT,
"east_of_northern_ireland_rppi" DOUBLE,
"east_of_northern_ireland_standardised_price" BIGINT,
"north_of_northern_ireland_rppi" DOUBLE,
"north_of_northern_ireland_standardised_price" BIGINT,
"west_south_of_northern_ireland_rppi" DOUBLE,
"west_south_of_northern_ireland_standardised_price" BIGINT
);
CREATE TABLE standardised_price_and_index_by_urban_rural_classification (
"quarter_year" VARCHAR,
"urban_areas_hpi" DOUBLE,
"urban_areas_standardised_price" DOUBLE,
"rural_areas_hpi" DOUBLE,
"rural_areas_standardised_price" DOUBLE
);
Anyone who has the link will be able to view this.