Summary statistics for housing transactions by local authority in England and Wales, on an annual basis, updated quarterly using HM Land Registry Price Paid Data. Select values from the Year and Month dimensions for data for a 12-month period ending that month and year (e.g. selecting June and 2018 will return the twelve months to June 2018).

Latest property prices Source: Land Registry Publisher: Land Registry Geographies: Local Authority District (LAD), Postcode Geographic coverage: England

Annual mean and median property prices calculated by the GLA from Price Paid Data published on Land Registry website. Number of property sales also included. Data has been aggregated to Borough, Ward, MSOA, LSOA, Postcode Districts and Postcode Sectors. Caution should be used when analysing figures based on a low number of sales. Price Paid Data provides information on every residential property sale in England and Wales that has been lodged with HM Land Registry for registration. Download full price paid data from the Land Registry. Click on the image below to access an interactive dashboard using some of the data available from this page.

Quarterly house price data based on a sub-sample of the Regulated Mortgage Survey.

Last updated on 22 Feb 2025

Introduction

This dataset provides comprehensive information on property sales in England and Wales, sourced from the UK government's HM Land Registry. Although the government site claims to update on the same day each month, actual updates can vary. To bridge this update variation gap, our fully automated ETL pipeline retrieves the official government data on a daily basis. This ensures that the dataset always reflects the most current transaction data available.

ETL Process

Our ETL (Extract, Transform, Load) process is designed to automate the data update and publishing workflow: 1. Extract:
The pipeline uses web scraping to retrieve the latest data from the official government website. This step is necessary as the site does not offer an API. 2. Transform:
Before loading the data, the ETL pipeline processes the dataset to ensure consistency and usability. As part of the transformation stage, the first column (Transaction_unique_identifier) is removed. This column is dropped during staging to focus on the most relevant transactional information. The column removal successfully reduces the data file size from almost 6GB to 3.1GB, and therefore will greatly increase the data analysis efficiency, and reduces the chance of kernal error/restart. 3. Load:
Finally, the transformed data is loaded into the dataset.

The transformed data is loaded into the dataset in two parts: - Complete Data (pp-complete.csv): This file encompasses all records from January 1995 to the present. The complete data file is replaced during each update to reflect any corrections or additional historical data. The first column is price. - Monthly Data: A separate monthly file is amended each month. This monthly archive ensures a complete record of updates over time, allowing users to track changes and trends more granularly.

Summary of Results

The dataset (pp-complete.csv) contains records of property sales dating back to January 1995, up to the most recent monthly data. It covers various types of transactions—from residential to commercial properties—providing a holistic view of the real estate market in England and Wales.

Column Descriptions

The original data includes the following columns: - Transaction_unique_identifier
- price
- Date_of_Transfer
- postcode
- Property_Type
- Old/New
- Duration
- PAON
- SAON
- Street
- Locality
- Town/City
- District
- County
- PPDCategory_Type
- Record_Status - monthly_file_only

Note: As part of the transformation process, the Transaction_unique_identifier column is removed from the final published pp-complete.csv data file. Therefore the first column of the pp-complete.csv file is price.

Address data Explanation - Postcode: The postal code where the property is located. - PAON (Primary Addressable Object Name): Typically the house number or name. - SAON (Secondary Addressable Object Name): Additional information if the building is divided into flats or sub-buildings. - Street: The street name where the property is located. - Locality: Additional locality information. - Town/City: The town or city where the property is located. - District: The district in which the property resides. - County: The county where the property is located. - Price Paid: The price for which the property was sold.

Legal and Ethical Considerations

Ownership and Attribution This dataset is the property of HM Land Registry and is released under the Open Government Licence (OGL). If you use or publish this dataset, you are required to include the following attribution statement:

>"Contains HM Land Registry data © Crown copyright and database right 2021. This data is licensed under the Open Government Licence v3.0."

Usage Guidelines

The data can be used for both commercial and non-commercial purposes.

The OGL does not cover third-party rights, which HM Land Registry is not authorized to license. For any other use of the Address Data, you must contact Royal Mail.

Suggested Usages

Market Trend Analysis: Understand the ups and downs of the property market over time. Investment Research: Identify potential areas for property investment. Academic Studies: Use the data for economic research and studies related to the housing market. Policy Making: Assist government agencies in making informed decisions regarding housing policies. Real Estate Apps: Integrate the data into apps that provide property price information services.

By using this dataset, you agree to abide by the terms and conditions as specified by HM Land Registry. Failure to do so may result in legal consequences.

introduction

This dataset provides comprehensive information on property sales in England and Wales, as sourced from the UK government's HM Land Registry. It offers valuable insights into property transactions, including sale prices, locations, and types of properties sold. This dataset is particularly useful for analysts, researchers, and businesses looking to understand market trends, property valuations, and investment opportunities in the real estate sector of England and Wales.

Summary of Results

The dataset contains records of property sales dating back to January 1995, up to the most recent monthly data. It covers various types of transactions, from residential to commercial properties, providing a holistic view of the real estate market in England and Wales.

Column Descriptions

colnames=['Transaction_unique_identifier', 'price', 'Date_of_Transfer', 'postcode', 'Property_Type', 'Old/New', 'Duration', 'PAON', 'SAON', 'Street', 'Locality', 'Town/City', 'District', 'County', 'PPDCategory_Type', 'Record_Status - monthly_file_only' ]

Address data Explaination Postcode: The postal code where the property is located. PAON (Primary Addressable Object Name): Typically the house number or name. SAON (Secondary Addressable Object Name): Additional information if the building is divided into flats or sub-buildings. Street: The street name where the property is located. Locality: Additional locality information. Town/City:The town or city where the property is located. District: The district in which the property resides. County:The county where the property is located. Price Paid:The price for which the property was sold.

Legal and Ethical Considerations

Ownership and Attribution

This dataset is the property of HM Land Registry and is released under the Open Government Licence (OGL). If you use or publish this dataset, you are required to include the following attribution statement:

"Contains HM Land Registry data © Crown copyright and database right 2021. This data is licensed under the Open Government Licence v3.0."

Usage Guidelines

The data can be used for both commercial and non-commercial purposes.

The OGL does not cover third-party rights, which HM Land Registry is not authorized to license. For any other use of the Address Data, you must contact Royal Mail.

##Suggested Usages Market Trend Analysis: Understand the ups and downs of the property market over time. Investment Research: Identify potential areas for property investment. Academic Studies: Use the data for economic research and studies related to the housing market. Policy Making: Assist government agencies in making informed decisions regarding housing policies. Real Estate Apps: Integrate the data into apps that provide property price information services.

By using this dataset, you agree to abide by the terms and conditions as specified by HM Land Registry. Failure to do so may result in legal consequences.

Land Registry Price Paid Data (PPD) have been published as open data since 2013. These data have been transformative for house price variation research in the UK as they are a comprehensive record of residential transactions at address level and cover the whole of England and Wales over a period dating back to 1995. Despite the utility of these data, a lack of attribute information relating to the properties, such as total floor area information, is identified as one of the major shortcomings of the PPD data. This means that the impacts of stock mix on broader price patterns cannot be fully accounted for. This research outlines one approach which addresses this deficiency by combining transaction information from the official open Land Registry Price Paid Data (PPD) with property size information form the official open Domestic Energy Performance Certificates (EPCs). A four-stage data linkage is created to generate a new linked dataset, representing 79% of the full market sales in the Land Registry PPD. This new linked dataset details 5,732,838 transactions in England and Wales between 2011 and 2019, along with each property's total floor area and the number of habitable rooms. Codes for other commonly used spatial units from Output Area to Local Authority are also included in the dataset. This offers greater flexibility for the exploration of house price variation in England and Wales at different spatial scales. The data collection includes the scripts used for linkage, as well as the resulting dataset.

Current residential house price variation research in the UK is limited by lack of an open and comprehensive house price database that contains both transaction price alongside dwelling attributes such as size. This research outlines one approach which addresses this deficiency in England and Wales through combining transaction information from the official open Land Registry Price Paid Data (PPD) and property size information form the official open Domestic Energy Performance Certificates (EPCs). A four-stage data linkage is created to generate a new linked data, representing 79% of the full market sales in Land Registry PPD. This new linked dataset offers greater flexibility for the exploration of house price (house price per square metre) variation in England and Wales at different spatial scales over postcode unit between 2011 and 2019.

This house price per square metre dataset is created through complex address-based matching between the Land Registry’s Price Paid Data (LR-PPD) and property size information from the Domestic Energy Performance Certificates (EPC) data published by the Department for Levelling Up, Housing and Communities (DLUHC, formerly MHCLG). Details of the data linkage are published in the UCL Open: Environment along with the related linkage code via the UK Data Service ReShare repository. During this data linkage process, the transactions assigned as category B (Additional Price Paid entry) and other property types are removed. Here we publish our latest limited attribute version of the uncorrected house price per square metre dataset in England and Wales with the LR-PPD data (1/1/1995-26/2/2021) and Domestic EPCs data (the sixth version, up to 20/9/2020) downloaded on 1/4/2021 for non-commercial purpose. This uncorrected version of house price per square metre dataset records over 18 million transactions with 16 variables in England and Wales since 1995. Unlike in our published article, in this uncorrected version we have not removed transactions with any improbable price per square metre values - i.e. where either the transaction price or total floor area values are null, 0 or too low to be realistic. This uncorrected version of the data will offer the most flexibility for researchers. We offer technical validation and data cleaning code via the UKDA ReShare repository to help users evaluate the representation of the linked data for a given time period. The data cleaning code shows our methods for cleaning up unlikely floor size records before using this data in analysis. Users can create their own rules and undertake this clean-up process based on their own experience and research aims. This limited attribute version is published by local authority (2021 version). Details of the 16 variables are described in the explanation file. The National Statistics Postcode Lookup NSPL (May 2021 version) is used to assign the local authority unit for your production of area-based statistics. Users can match historical changes in LA boundaries by choosing appropriate aggregations using, for instance ONSPD, and the postcode variable in our dataset. An extended version of this dataset containing additional variables is available from UK Data Service Reshare service. Users can directly access this full version dataset (tranall_link_01042021.zip) via the following link: https://reshare.ukdataservice.ac.uk/855033/ . Accompanying LR-PPD and EPC data are also supplied through the ReShare service. Users who would like to attach their own additional variables from the LR-PPD data are advised to use the transactionid variable to link to the LR-PPD (LRPPD_01042021.zip). Users who would like to attach additional variables from the EPC data are advised to use the id variable to link to the sixth version Domestic EPCs (epc6_id.zip). The 2024 update

This repository is the fourth updated version of the attribute-linked residential property price dataset in the UK Data Service ReShare (854240) (https://reshare.ukdataservice.ac.uk/854240/). This dataset contains individual property transactions and associated variables from both Land Registry Price Paid Dataset (LR PPD) and the Department for Levelling Up, Housing and Communities (DLUHC, formerly MHCLG) Domestic Energy Performance Certificate (EPC) data. It is a linked dataset produced by address matching between LR PPD data (1/1/1995–31/10/2024) and Domestic EPC data (up to 31/10/2024). It is the full version of the 2024 update of the dataset published in the Greater London Authority (GLA) London Datastore (https://data.london.gov.uk/dataset/house-price-per-square-metre-in-england-and-wales).

The linked dataset (tranall_link_26122024) provided here is the initial, uncleaned version, intended to offer maximum flexibility for users to clean the data according to their research purposes. This linked dataset records over 22 million transactions with 106 variables across England and Wales, covering the period from 01/01/1995 to 31/10/2024. We have provided technical validation and data cleaning code in UKDA ReShare 854240 to help users evaluate the data structure and perform their own cleaning. There is no single way to clean this raw linked dataset, so we encourage users to develop their own cleaning process based on their research needs. This repository also includes the original Land Registry Price Paid Data (LR PPD) and Domestic EPCs used to create the linked dataset (house price per square metre dataset). Unlike previous versions, this updated dataset no longer includes the id variable (created by the authors). Instead, for the first time, both the Domestic EPCs and the linked dataset retain the LMK_KEY variable, which originates from the Domestic EPCs dataset. This change was made because LMK_KEY serves as a unique identifier, with no duplicate records since 2024. Five address-related variables from the original Domestic EPCs dataset(ADDRESS1, ADDRESS2, ADDRESS3, POSTCODE, and ADDRESS) have been removed from the EPC data in this repository. The priceper and classt variables were created by the authors and can be found in the linked dataset (tranall_link_26122024.zip). A detailed explanation of these fields is available on the GLA London Datastore (https://data.london.gov.uk/dataset/house-price-per-square-metre-in-england-and-wales). The lad23cd field originates from the NSPL dataset. Since November 2021, DLUHC has published Domestic EPCs with the Unique Property Reference Number (UPRN). As a result, both the EPC and the full linked dataset in this repository include UPRN information from the Domestic EPCs

This dataset contains a cleaned and enhanced version of publicly available UK housing transaction data, sourced from HM Land Registry. It covers housing sales across England, Wales, Scotland, and Northern Ireland from 2000 to 2023.

The dataset is preprocessed for immediate use in machine learning, statistical analysis, and data storytelling tasks. Here’s your UK Housing Dataset Column Descriptor, followed by where and how to apply it in Hugging Face or Kaggle:

Column Descriptions (for cleaned_uk_housing_prices.csv)

| price_per_sqm | Float | Estimated price per square meter (if available) | | log_price | Float | Log-transformed sale price (useful for ML models) |

Art Presence & London Property Prices

Quantifying Visual Environment at Scale

By [source]

About this dataset

Explore a new and different way to measure the relationship between art presence and property prices in Inner London neighbourhoods. By quantifying the visual environment at scale with geotagged Flickr photos containing the word “art,” this dataset can help us garner an understanding of how aesthetic values translate into its economic value. Using data from the Land Registry of England and Wales, this dataset allows users to spot correlations between property values and art presence through visual analysis of postcode districts plotted against rank change in prices and proportion of “art” photos. Investigate whether aesthetics, particularly within urban neighbourhoods, have a bearing on local house pricing markets – adding a valuable insight into London’s ever-changing social landscape

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset provides a useful tool for determining the correlation between the visual environment in a given neighbourhood and its associated property values. This dataset can be used to gain insights into how art presence in an area affects housing prices.

To work with this dataset, you will first need to download it as a csv file or as an XML file. Once you have downloaded your desired version of the data, open it in your favorite spreadsheet program or text editor for further manipulation and analysis.

The two key columns you will want to focus on are Rank Mean Change and Proportion Art Photos. The Rank Mean Change column indicates how each neighbourhood ranked based on its mean property price change from Jan 1995 to Mar 2017, while Proportion Art Photos denotes the proportion of photographs taken within these areas containing the word “art”. You may also want to take note of Postcode Districts as this indicates which neighbourhood each row corresponds to making it easier for contextualizing results at a place-based level.

From here you can conduct linear regression analysis using Rank Mean Change and Proportion Art Photos as independent variables, allowing you to determine whether there is indeed any correlation between art presence in London neighbourhoods and their property values over time

Research Ideas

• Correlating the value of properties with art presence to inform investment decisions in residential real estate.
• Utilizing Photographs from Flickr as a tool to monitor changes in art presence and creative expression over time.
• Investigating the effects of art preservation/creation initiatives on property values to determine their potential effectiveness

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: London_Prices_Flickr_Art_Agg.csv | Column name | Description | |:--------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | Postcode.District | This column indicates the postcode district of each neighbourhood in Inner London. (String) | | Rank.Mean.Change | This column indicates the rank of each neighbourhood based on its mean change in property prices over time. (Integer) | | Proportion.Art.Photos | This column captures the proportion of photographs containing “art” within each postcode district during a given time period, allowing us to measure art presence at scale across inner London neighbourhoods. (Float) |

Acknowledgements

If you use this dataset in your research, please credit the original authors. ...

If you want to give feedback on this dataset, or wish to request it in another form (e.g csv), please fill out this survey here. We are a not-for-profit research organisation keen to see how others use our open models and tools, so all feedback is appreciated! It's a short form that takes 5 minutes to complete.

Important Note: Before downloading this dataset, please read the License and Software Attribution section at the bottom.

This dataset aligns with the work published in Centre for Net Zero's report "Hitting the Target". In this work, we simulate a range of interventions to model the situations in which we believe the UK will meet its 600,000 heat pump installation per year target by 2028. For full modelling assumptions and findings, read our report on our website.

The code for running our simulation is open source here.

This dataset contains over 9 million households that have been address matched between Energy Performance Certificates (EPC) data and Price Paid Data (PPD). The code for our address matching is here. Since these datasets are Open Government License (OGL), this dataset is too. We basically model specific columns from various datasets, as set out in our methodology section in our report, to simplify and clean up this dataset for academic use. License information is also available in the appendix of our report above.

The EPC data loaders can be found here (the data is here) and the rest of the schemas and data download locations can be found here.

Note that this dataset is not regularly maintained or updated. It is correct as of January 2022. The data was curated and tested using dbt via this Github repository and would be simple to rerun on the latest data.

The schema / data dictionary for this data can be found here.

Our recommended way of loading this data is in Python. After downloading all "parts" of the dataset to a folder. You can run:

import pandas as pd


data = pd.read_parquet("path/to/data/folder/")

Licenses and software attribution:

For EPC, PPD and UK House Price Index data:

For the EPC data, we are permitted to republish this providing we mention that all researchers who download this dataset follow these copyright restrictions. We do not explicitly release any Royal Mail address data, instead we use these fields to generate a pseudonymised "address_cluster_id" which reflects a unique combination of the address lines and postcodes, as well as other metadata. When viewing ICO and GDPR guidelines, this still counts as personal data, but we have gone to measures to pseudonymise as much as possible to fulfil our obligations as a data processor. You must read this carefully before downloading the data, and ensure that you are using it for the research purposes as determined by this copyright notice.

Contains HM Land Registry data © Crown copyright and database right 2021. This data is licensed under the Open Government Licence v3.0.

Contains OS data © Crown copyright and database right 2022.

Contains Office for National Statistics data licensed under the Open Government Licence v.3.0.

The OGL v3.0 license states that we are free to:

copy, publish, distribute and transmit the Information;

adapt the Information;

exploit the Information commercially and non-commercially for example, by combining it with other Information, or by including it in your own product or application.

However we must (where we do any of the above):

acknowledge the source of the Information in your product or application by including or linking to any attribution statement specified by the Information Provider(s) and, where possible, provide a link to this licence;

You can see more information here.

For XOServe Off Gas Postcodes:

This dataset has been released openly for all uses here.

For the address matching:

GNU Parallel: O. Tange (2018): GNU Parallel 2018, March 2018, https://doi.org/10.5281/zenodo.1146014

This dataset contains data from reporting years 2023 & 2024 and is therefore indicative of allocations and lets within the Stirling Council area, rather than an as is indicator. The Allocation Area boundaries are defined by the intersection of Stirling Council properties and postcode geographies (as defined by The National Records of Scotland Scottish Postcode Directory Scottish Postcode Directory (SPD) | National Records of Scotland (nrscotland.gov.uk) )Schema;Allocation Area Number,Allocation Area Name, Property Types and Numbers,Properties by Bedrooms, Percentage Turnover of Lets, and the number of Properties Let in period.