Guidance

How to access Land Registry Price Paid Data

Information about Price Paid Data and how you can get it.

Price Paid Data tracks residential property sales in England and Wales that are lodged with Land Registry for registration and is based on the raw data released each month. Because there is a time-lag between the sale of a property and the subsequent registration of this information with Land Registry, the two most recent months are incomplete and do not represent final monthly volumes.

You can download complete files from our price paid data page or build specific reports within our price paid data tool. Alternatively, you can buy standard reports based upon geographic areas.

Download options

Three simple download options allow you to select the data that best meet your requirements:

  • single file: contains all the up to date data from 1995 to the current date
  • monthly file: contains a single monthly file of the transactions received in the period from the first to the last day of the corresponding month, including any changes or deletions to previously downloaded data
  • yearly file: contains annual files of up to date data, ranging from 1995 to the current date. Unlike the monthly files described above, yearly files are collated on the date of the transaction/deed date rather than the date that the information was lodged with Land Registry.

Explanations of column headers in the PPD

The data is published in columns in the order set out below:

Data Item Explanation (where appropriate)
Transaction unique identifier A reference number which is generated automatically recording each published sale. The number is unique and will change each time a sale is recorded.
Price Sale price stated on the transfer deed.
Date of Transfer Date when the sale was completed, as stated on the transfer deed.
Postcode  
Property Type D = Detached, S = Semi-Detached, T = Terraced, F = Flats/Maisonettes
Old/New Y = a newly built property, N = an established residential building
Duration Relates to the tenure: F = Freehold, L-Leasehold etc.
PAON Primary Addressable Object Name. If there is a sub-building for example the building is divided into flats, see Secondary Addressable Object Name (SAON).
SAON Secondary Addressable Object Name. If there is a sub-building, for example the building is divided into flats, there will be a SAON.
Street  
Locality  
Town/City  
District  
County  
Record Status - monthly file only Indicates additions, changes and deletions to the records.(please see guide below).

The date field - the date of the transfer deed lodged with us for registration.

Data excluded from the House Price Index and Price Paid Data.

Our House Price Index and Price Paid Data include information on all residential property sales in England and Wales that are sold for full market value and are lodged with us for registration.

Our House Price Index and Price Paid Data exclude:

  • all commercial transactions. By this we mean any transaction that involves a transfer to a corporate body, company or business
  • sales that have not been lodged with Land Registry.
  • sales that were not for full market value. By this we mean, the sale of part of a property, a share of a property or the sale of a property at a discount. Examples include a repossession sale or a transfer between parties on divorce
  • transfers, conveyances, assignments or leases at a premium with nominal rent which are:
    • ‘Right to buy’ sales at a discount
    • subject to a lease
    • subject to an existing mortgage
    • buy to let (where they can be identified by a mortgage deed)
    • to effect the sale of a share in a property
    • by way of a gift
    • under a compulsory purchase order
    • under a court order
    • to Trustees appointed under Deed of appointment
  • Vesting Deeds Transmissions or Assents of more than one property
  • Leases for seven years or less

Record Status guide csv files

The guide highlights when additions, changes or deletions have been made to a record, this applies to the monthly file only:

  • A - Added records: records added into the price paid dataset in the monthly refresh due to new sales transactions
  • C - Changed records: records changed in the price paid dataset in the monthly refresh. You should replace or update records in any stored data using the unique identifier to recognise them
  • D - Deleted records: records deleted from the price paid dataset in the monthly refresh. You should delete records from any stored data using the unique identifier to recognise them.

Reporting a Price Paid Data error

If you know of an error in price paid information for sales or believe a sale is ‘missing’ from information you have viewed, please use our change a sales record form so that we can update our records and inform third parties. (You will need both the postcode and date of sale to complete the form.)

Complain about Price Paid Data being made publicly available

We are legally required to note the price paid information on a register of the title for all residential properties sold for full market value. The register of title is a public document, so we would be breaking the law if we failed to allow access to the register or excluded the price paid information. The price paid information is released in the form of price paid data under the terms of Open Government Licence.

If you are unhappy with the principle of price paid information being recorded on the register, or the release of this data, please see our complaints procedure. If you wish to report or complain about a discrepancy in the price paid information, please complete our change a sales record form. This will ensure the matter is investigated and appropriate action taken.

How to avoid direct marketing

Under the Open Government Licence, the data is freely available for commercial and non-commercial reuse purposes. The users of the data have an obligation, under the Open Government Licence, to ensure that their use of the data does not breach the Data Protection Act 1998 or the Privacy and Electronic Communication (EC Directive) Regulations 2003. At the moment we do not intend to impose any more restrictions on the use of the data for direct marketing purpose.

If you wish to opt out of receiving direct marketing material, please refer to the website for Information Commissioner’s Office.

Using a single month of Price Paid Data in isolation

The single large file and yearly files have amendments and/or deletions applied to the data, ensuring the data is complete, up to date and accurate. Subsequent monthly files may contain amendments if a record is added, changed or deleted. If an amendment is made a status marker will appear at the end of the record to indicate the type of change. You will need to consider this change if you compare month files.

How the data can be used

The data creates numerous opportunities for individuals and organisations to share it, or combine it with other data to create new applications and services. For example some application developers, data analysts, estate agents and property website owners have used the data to:

  • analyse trends and patterns in the housing market
  • create valuation software and price estimations
  • use insights to develop housing and social policy
  • innovate and grow their business.

Monthly files for previous months

To access previous monthly files, please contact our Add Value Team on 0300 006 0478 or email commercial.services@landregistry.gsi.gov.uk.

Non-disclosure of homeowners’ personal information

Price Paid Data is not personal information about individuals but property related information. The data recorded in the register is open to public inspection and has been provided commercially for many years under the Information Fair Trader Accreditation. This is run by the Office of Public Sector Information, which is part of The National Archives.

Before releasing the data a privacy impact assessment was conducted. We also conducted a review after releasing the data. Neither of which revealed any major adverse impacts or formal legal challenge.

See the Privacy Impact Assessment Review and the Review report: April 2013.

Common problems with Excel

  • The release of the yearly Price Paid Data files from 1995 to 2013 has resulted in the creation of files that contain more than 1 million rows. These files are too large to be processed in older versions of Excel.
  • We are aware that users of Excel have experienced problems when accessing the Price Paid Data CSV file using Excel. A common problem is the auto-conversion of dates to a different format (e.g. “2013-10-04 00:00” to 04/10/2013 00:00) and conversion of fields containing a numeric range to a date value (e.g. “2-7” to 2nd July).

You can avoid these problems by putting an equals (=) sign in front of every field you don’t want auto converted. For example:

“{75520218-C2D9-4926-95E3-00061A7A3784}”,”248000”,=”2013-10-04 00:00”,”CR2 6PB”,”T”,”N”,”F”,”36”,”2 - 7”,”SELSDON ROAD”,””,”SOUTH CROYDON”,”CROYDON”,”GREATER LONDON”,”A”

This will keep the date in the same format instead of converting it to 04/10/2013 00:00

Price Paid Data report builder

Access the report builder

Browser Support

As of April 2014, Land Registry no longer tests new application software releases against Microsoft Windows XP and Microsoft Internet Explorer 8. Microsoft Internet Explorer 9 onwards, Safari 7 onwards and the latest version of any browsers which automatically update, such as Mozilla Firefox and Google Chrome are supported.

Guidance on searching the data

We try to make sure that our public data is as accurate as possible, but cannot guarantee that it is free from errors. Our Price Paid Data reports are based on data collected at the time a property transaction was registered with us and will not necessarily be up to date with the most recent information. Because data is captured at the time of registration, updates to counties or postcodes will not be shown on sales before the changes took effect.

In order to get a more comprehensive report for your location criteria, you may need to try several things:

  • try using your location in both town/city and district. Often a metropolitan district can cover more than one town or city
  • try multiple searches using both the most recent and previously used towns/counties, for example Bristol/City of Bristol?
  • use variations in district in order to reflect changes in administrative areas. Over time district may have changed for an address for a number of reasons. The district name may have changed, the area might have been transferred to another authority or the area might have become a unitary authority. For example, transactions for a property in Saltash, Cornwall dating before April 2009 will be shown as district: Caradon (the former district) whilst more recent transactions will be shown as district: Cornwall (the current unitary authority)
  • use various levels of searches to find specific areas. For example, despite the name, Princetown is a village on Dartmoor in Devon. For postal purposes it’s part of the town of Yelverton. Both are within the Plymouth postcode area and within the postcode district of PL20 which includes several other settlements on and around Dartmoor. If you were to search on a wider definition of the area, (Yelverton or the postcode sector PL20) you can then filter the results by locality in order to find only those referenced as Princetown.

Reason why a search may timeout

We have set a time limit for Price Paid Data queries, and this means that you will see a timeout message if your search takes more than a minute to run. This time limit has been implemented to ensure that the system isn’t slowed down by excessively large queries. This also protects customers from unexpectedly large results sets being returned, with associated delays in system response and possible data download charges from your internet provider. If you have a particular need to run complex queries we suggest that you download the full price paid dataset, as this will give you unrestricted access to that data.

Unable to search for addresses by locality

Addresses used by Land Registry to describe land are mostly derived from Royal Mail address data. Town is the primary identifier for addresses but locality may also be used to identify smaller urban and rural places. However, locality is not consistently used; for example, in an urban area locality may only be included in an address in order to distinguish between multiple streets with the same name in a town. In addition, Land Registry addresses have been collected over many years and over time inconsistencies may have occurred.

This means that searching by locality may not return a complete dataset and we advise that it is safer to search by town. Once you have run your search you have the option to filter your search by locality (click the spyglass button beside a locality name in the results set). You also have the option to download the full price paid dataset, which will give you unrestricted access to that data.

The difference between ‘transactions’ and ‘properties’

Your results provide a statement which tells you how many transactions and properties are being returned. While properties are self explanatory, transactions relate to the number of sales which have been returned. The two numbers will differ as a property can transact more than one in the time period searched. Therefore you may see 100 properties returned with 105 transactions, meaning that one or more of the properties has changed ownership multiple times.

Our data is derived from all residential property transactions registered with Land Registry since January 1995. See the list of exclusions for further information.

The order of displayed search results

In the list of results, individual addresses are grouped together by street. Those streets are in turn grouped by postal town, district and county. So, for example, any results in Gloucestershire would appear before results in Hampshire; within Gloucestershire results from Cheltenham would appear before results from Gloucester; and within Cheltenham addresses on Albert Road would be listed before addresses on Pitville Circus.

Unable to see all search results

When completing the initial screen you are asked to choose how many results you would like back. This has been set to 100 so that you can ensure that your search criteria is correct before requesting the full results. Please note that the sample data returned is a random sample, the order and number of transactions per property can alter when requesting more data.

Full results can be requested from the results page itself or when choosing to download the results. When downloading the results, please note that you have the option to print only those selected as a preview or the full results.

Download search results into a spreadsheet

You can do this by choosing to download the data at the top of the results page. You will be given several options to download your results in csv format.

Unable to see results when downloading the data

When downloading the results, please note that you have the option to print only those selected as a preview or the full results.

Download the data with an explanation of the data attributes

When you download the data as a spreadsheet there are four options available:

  • get selected results as CSV
  • get all results as CSV
  • get selected results as CSV with headers
  • get all results as CSV with headers

By selecting one of the options with headers you will download a spreadsheet with the data attributes above each column. For more information refer to Explanations of column headers in the PPD.

Reason why the downloaded property characteristics data may differ from those shown on the search results page

Price Paid Data is property price information for all single residential property sales in England and Wales sold for full market value, that are lodged with us for registration. The data captured is that at the time of registration and can be subject to change.

Occasionally a property type can change, for example a detached property could be converted into flats between sales and one of these could retain the previous address. In this instance we would only show the most recent property type in our results, however when downloading the data the data you would receive multiple rows which detail the property characteristics at the time of registration for each transaction.

If a property type has been incorrectly identified and we have been notified of the need for a change, we will amend the data. You can notify us of any errors in our data using our Change a sales record form.

The significance of the Beta status?

This Search facility has been developed using customer feedback and user testing and we would like to continue to encourage feedback on these new offerings. The beta status allows us to review the offerings and make changes to the current format.

While we are still in beta there will be a limited Welsh translation of the search facilities. While our main information page will be provided in Welsh language the wording on the search pages will not be while we are still reviewing the pages.

Licences

Terms and conditions, PDF

Publishing or making use of our data

Privacy statement