About this Dataset

Northern Ireland Annual Descriptive House Price Statistics (Electoral Ward Level)

Annual descriptive price statistics for each calendar year 2005 – 2023 for 462 electoral wards within 11 Local Government Districts. 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/3507dc4149f0780d0b83c66c58dda26e
Last updated: 2024-08-24T04:01:32Z

Tables

Detached Sales For Fermanagh And Omagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_for_fermanagh_and_omagh_council

10.31 KB
760 rows
11 columns


CREATE TABLE detached_sales_for_fermanagh_and_omagh_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales For Lisburn And Castlereagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_for_lisburn_and_castlereagh_council

13.48 KB
760 rows
11 columns


CREATE TABLE detached_sales_for_lisburn_and_castlereagh_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales For Mid And East Antrim Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_for_mid_and_east_antrim_council

12.62 KB
760 rows
11 columns


CREATE TABLE detached_sales_for_mid_and_east_antrim_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales For Mid Ulster Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_for_mid_ulster_council

9.91 KB
760 rows
11 columns


CREATE TABLE detached_sales_for_mid_ulster_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales For Newry, Mourne And Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_for_newry_mourne_and_down_council

11.33 KB
779 rows
11 columns


CREATE TABLE detached_sales_for_newry_mourne_and_down_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales In Antrim And Newtownabbey Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_in_antrim_and_newtownabbey_council

12.65 KB
760 rows
11 columns


CREATE TABLE detached_sales_in_antrim_and_newtownabbey_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales In Ards And North Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_in_ards_and_north_down_council

15.44 KB
760 rows
11 columns


CREATE TABLE detached_sales_in_ards_and_north_down_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Detached Sales In Causeway Coast And Glens Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.detached_sales_in_causeway_coast_and_glens_council

13.2 KB
760 rows
11 columns


CREATE TABLE detached_sales_in_causeway_coast_and_glens_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Antrim And Newtownabbey Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_antrim_and_newtownab_acfc624d

22.35 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_antrim_and_newtownab_acfc624d (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Ards And North Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_ards_and_north_down_council

25.07 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_ards_and_north_down_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Armagh City, Banbridge And Craigavon Council.

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_armagh_city_banbridg_a3d8858e

22.22 KB
779 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_armagh_city_banbridg_a3d8858e (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Belfast Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_belfast_council

32.92 KB
1140 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_belfast_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Causeway Coast And Glens Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_causeway_coast_and_g_10f33431

19.19 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_causeway_coast_and_g_10f33431 (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Derry City And Strabane Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_derry_city_and_strab_5aa0464c

17.35 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_derry_city_and_strab_5aa0464c (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Fermanagh And Omagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_fermanagh_and_omagh_council

13.13 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_fermanagh_and_omagh_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Lisburn And Castlereagh Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_lisburn_and_castlere_ffdf4a9a

22.36 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_lisburn_and_castlere_ffdf4a9a (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Mid And East Antrim Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_mid_and_east_antrim_council

20.74 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_mid_and_east_antrim_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Mid Ulster Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_mid_ulster_council

13.88 KB
760 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_mid_ulster_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

Existing Resold Dwelling Sales In Newry, Mourne And Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.existing_resold_dwelling_sales_in_newry_mourne_and_down_council

18.01 KB
779 rows
11 columns


CREATE TABLE existing_resold_dwelling_sales_in_newry_mourne_and_down_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

New Dwelling Sales In Antrim And Newtownabbey Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.new_dwelling_sales_in_antrim_and_newtownabbey_council

13.32 KB
760 rows
11 columns


CREATE TABLE new_dwelling_sales_in_antrim_and_newtownabbey_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

New Dwelling Sales In Ards And North Down Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.new_dwelling_sales_in_ards_and_north_down_council

12.63 KB
760 rows
11 columns


CREATE TABLE new_dwelling_sales_in_ards_and_north_down_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

New Dwelling Sales In Armagh City, Banbridge And Craigavon Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.new_dwelling_sales_in_armagh_city_banbridge_and_craiga_c77e2dff

14.75 KB
779 rows
11 columns


CREATE TABLE new_dwelling_sales_in_armagh_city_banbridge_and_craiga_c77e2dff (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

New Dwelling Sales In Belfast Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.new_dwelling_sales_in_belfast_council

13.99 KB
1140 rows
11 columns


CREATE TABLE new_dwelling_sales_in_belfast_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

New Dwelling Sales In Causeway Coast And Glens Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.new_dwelling_sales_in_causeway_coast_and_glens_council

12.15 KB
760 rows
11 columns


CREATE TABLE new_dwelling_sales_in_causeway_coast_and_glens_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);

New Dwelling Sales In Derry City And Strabane Council

@ukgov.northern_ireland_annual_descriptive_house_price_statis_cc8cee2e.new_dwelling_sales_in_derry_city_and_strabane_council

12.4 KB
760 rows
11 columns


CREATE TABLE new_dwelling_sales_in_derry_city_and_strabane_council (
  "district" VARCHAR,
  "ward" VARCHAR,
  "saleyr" BIGINT,
  "type" VARCHAR,
  "ward_verifiedsales" BIGINT,
  "reporting_minprice" VARCHAR,
  "reporting_lqprice" VARCHAR,
  "reporting_medianprice" VARCHAR,
  "reporting_meanprice" VARCHAR,
  "reporting_uqprice" VARCHAR,
  "reporting_maxprice" VARCHAR
);