Name: NIHPI Mean Median And Standardised Price By Property Type
Creator: UK Government
License: https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

About this Dataset

NIHPI Mean Median And Standardised Price By Property Type

The mean, median and standardised price of properties sold each quarter presented by property type from Q1 (January-March) 2005.
Publisher name: OpenDataNI
Last updated: 2025-02-25T04:01:11Z

Tables

Mean, Median And Standardised Price

@ukgov.nihpi_mean_median_standardisded_price.mean_median_and_standardised_price

23.99 KB
80 rows
18 columns


CREATE TABLE mean_median_and_standardised_price (
  "quarter_year" VARCHAR,
  "detached_mean_price" DOUBLE,
  "detached_median_price" DOUBLE,
  "detached_standardised_price" DOUBLE,
  "semi_detached_mean_price" DOUBLE,
  "semi_detached_median_price" DOUBLE,
  "semi_detached_standardised_price" DOUBLE,
  "terrace_mean_price" DOUBLE,
  "terrace_median_price" BIGINT,
  "terrace_standardised_price" DOUBLE,
  "apartment_mean_price" DOUBLE,
  "apartment_median_price" DOUBLE,
  "apartment_standardised_price" DOUBLE,
  "all_properties_mean_price" DOUBLE,
  "all_properties_median_price" DOUBLE,
  "all_properties_standardised_price" DOUBLE,
  "sale_year" BIGINT,
  "sale_qtr" VARCHAR
);