About this Dataset

Northern Ireland Annual Descriptive House Price Statistics (LGD Level)

Annual descriptive price statistics for each calendar year 2005 – 2023 for 11 Local Government Districts in Northern Ireland. The statistics include: • Minimum sale price • Lower quartile sale price • Median sale price • Simple Mean sale price • Upper Quartile sale price • Maximum sale price • Number of verified sales Prices are available where at least 30 sales were recorded in the area within the calendar year which could be included in the regression model i.e. the following sales are excluded: • Non Arms-Length sales • sales of properties where the habitable space are less than 30m2 or greater than 1000m2 • sales less than £20,000. Annual median or simple mean prices should not be used to calculate the property price change over time. The quality (where quality refers to the combination of all characteristics of a residential property, both physical and locational) of the properties that are sold may differ from one time period to another. For example, sales in one quarter could be disproportionately skewed towards low-quality properties, therefore producing a biased estimate of average price. The median and simple mean prices are not ‘standardised’ and so the varying mix of properties sold in each quarter could give a false impression of the actual change in prices. In order to calculate the pure property price change over time it is necessary to compare like with like, and this can only be achieved if the ‘characteristics-mix’ of properties traded is standardised. To calculate pure property change over time please use the standardised prices in the NI House Price Index Detailed Statistics file.
Publisher name: OpenDataNI
Publisher URL: http://data.europa.eu/88u/.well-known/genid/803747ae3a9982dcb118148df9489892
Last updated: 2024-08-24T04:01:32Z

Tables

All Sales In Antrim And Newtownabbey Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_antrim_and_newtownabbey_council

8.82 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Ards And North Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_ards_and_north_down_council

8.78 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Armagh City, Banbridge And Craigavon Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_armagh_city_banbridge_and_craigavon_council

8.89 KB
19 rows
10 columns


CREATE TABLE all_sales_in_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
);

All Sales In Belfast Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_belfast_council

8.66 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Causeway Coast And Glens Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_causeway_coast_and_glens_council

8.79 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Derry City And Strabane Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_derry_city_and_strabane_council

8.76 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Fermanagh And Omagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_fermanagh_and_omagh_council

8.75 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Lisburn And Castlereagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_lisburn_and_castlereagh_council

8.83 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Mid And East Antrim Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_mid_and_east_antrim_council

8.78 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Mid Ulster Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_mid_ulster_council

8.71 KB
19 rows
10 columns


CREATE TABLE all_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
);

All Sales In Newry, Mourne And Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.all_sales_in_newry_mourne_and_down_council

8.76 KB
19 rows
10 columns


CREATE TABLE all_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
);

Apartment Sales Causeway Coast And Glens Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_causeway_coast_and_glens_council

8.74 KB
19 rows
10 columns


CREATE TABLE apartment_sales_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
);

Apartment Sales Derry City And Strabane Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_derry_city_and_strabane_council

8.26 KB
19 rows
10 columns


CREATE TABLE apartment_sales_derry_city_and_strabane_council (
  "district" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "lgd_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Apartment Sales For Antrim And Newtownabbey Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_antrim_and_newtownabbey_council

8.72 KB
19 rows
10 columns


CREATE TABLE apartment_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
);

Apartment Sales For Ards And North Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_ards_and_north_down_council

8.68 KB
19 rows
10 columns


CREATE TABLE apartment_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
);

Apartment Sales For Armagh City, Banbridge And Craigavon Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_armagh_city_banbridge_and_craigavon_council

8.18 KB
19 rows
10 columns


CREATE TABLE apartment_sales_for_armagh_city_banbridge_and_craigavon_council (
  "district" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "lgd_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Apartment Sales For Belfast Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_belfast_council

8.64 KB
19 rows
10 columns


CREATE TABLE apartment_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
);

Apartment Sales For Fermanagh And Omagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_fermanagh_and_omagh_council

7.95 KB
19 rows
10 columns


CREATE TABLE apartment_sales_for_fermanagh_and_omagh_council (
  "district" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "lgd_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Apartment Sales For Lisburn And Castlereagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_lisburn_and_castlereagh_council

8.75 KB
19 rows
10 columns


CREATE TABLE apartment_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
);

Apartment Sales For Mid And East Antrim Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_mid_and_east_antrim_council

8.72 KB
19 rows
10 columns


CREATE TABLE apartment_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
);

Apartment Sales For Mid Ulster Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_mid_ulster_council

7.56 KB
19 rows
10 columns


CREATE TABLE apartment_sales_for_mid_ulster_council (
  "district" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "lgd_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Apartment Sales For Newry, Mourne And Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.apartment_sales_for_newry_mourne_and_down_council

8.28 KB
19 rows
10 columns


CREATE TABLE apartment_sales_for_newry_mourne_and_down_council (
  "district" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "lgd_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales For Antrim And Newtownabbey Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.detached_sales_for_antrim_and_newtownabbey_council

8.75 KB
19 rows
10 columns


CREATE TABLE detached_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
);

Detached Sales For Ards And North Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.detached_sales_for_ards_and_north_down_council

8.71 KB
19 rows
10 columns


CREATE TABLE detached_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
);

Detached Sales For Armagh City, Banbridge And Craigavon Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_8e54c046.detached_sales_for_armagh_city_banbridge_and_craigavon_council

8.84 KB
19 rows
10 columns


CREATE TABLE detached_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
);