UK House Price Index Linked Data
What does the House Price Index Dataset consist of?
The UK House Price Index (UK HPI) captures changes in the value of residential properties.
The UK HPI uses sales data collected on residential housing transactions, whether for cash or with a mortgage. Properties have been included:
- in England and Wales since January 1995,
- in Scotland since January 2004 and
- in Northern Ireland since January 2005.
Data is available at a national and regional level, as well as counties, local authorities and London boroughs
The UK HPI dataset contains information on more than 441 areas in England, Scotland, Northern Ireland and Wales. Please note that we do not publish HPI information for The Isles of Scilly due to its low monthly sales volumes.
For each area we publish a UK House Price Index figure. This was set at a base of 100 in January 2015, and reflects the change in value of residential property since then. We also have figures for the average price of all properties in an area, for each of four property types, sales volumes, and the percentage change from the previous month and year. Please note that sales volume data is not available for the most-recent two months.
Land Registry publish detailed information about UK HPI. This can be found on their web site.
In June 2016 the UK HPI linked data dataset contains approximately four million triples for 441 regions in England, Scotland, Northern Ireland and Wales. The triple store is refreshed in each month with data from the current month and a refresh of the previous two months.
The linked data version of UK HPI dataset is generated from the published files and contains additional information to describe each of the reported regions, this information includes links to linked datasets published by the Ordnance Survey and the Office of National Statistics.
Please note that links to other sources of open, linked data are provided under the Open Government License (ONS data) and Open Data License (OS data). Land Registry is not responsible for the content or reliability of any linked websites.
How is the House Price Index Dataset published?
The UK house price index dataset is available in several forms from the Land Registry:
- interactively, using the Search the UK House Price Index tool. This tool also includes options to download the data in CSV or Turtle and to generate downloadable files from SPARQL queries in JSON, XML, plain text or as a table.
- for download in CSV form or as an Excel Worksheet.
The UK house price index dataset is also available in full as a 5* linked dataset which is free to use under the terms of the OGL.
Linked Data Overview
Each month UK HPI data is updated for all of Great Britain, there is a monthly value for Northern Ireland data which is updated quarterly. The UK HPI data is converted into linked data form and this replaces the previous named graph in the triplestore, graphs are named UKHPI-yyyy-mm. This process runs alongside the normal publication of UK HPI data. Publication dates are available on the Publication timetable
The publication of the House Price Index Dataset as linked data requires the creation of reusable RDFS or OWL vocabularies, one Land Registry vocabulary and two Ordnance Survey vocabularies. In addition, the data is encoded as an RDF data cube.
- Data Cube http://purl.org/linked-data/cube
- A recommendation from the W3C for representing sets of multi-dimensional statistical data in RDF as a hypercube.
- Land Registry HPI http://landregistry.data.gov.uk/def/hpi
- The Land Registry HPI vocabulary is used to describe the House Price Index Dataset produced each month. The vocabulary contains terms that are used by Land Registry to describe things that are used within the House Price Index dataset.
- OS Spatial Relations http://landregistry.data.gov.uk/def/hpi
- This Ordnance Survey vocabulary is used to describe basic spatial relations
- OS Admingeo http://data.ordnancesurvey.co.uk/ontology/admingeo/
- This Ordnance Survey vocabulary is used to describe the administrative and voting area geography of Great Britain.
UKHPI Data is stored as a named graph in a data cube with two dimensions and a variety of measures. The Data Structure Definition (DSD) file defines this structure, and can be used by both data users and programs to understand how the data is structured.
The UK House Price Index reporting tool
The report tool is the easiest way to query the UKHouse Price Index dataset. It allows the easy creation of queries using a form and results can be downloaded in various forms. The report builder can also be used to generate SPARQL queries that can be amended and re-run as required.
Please note that when choosing the CSV option for downloaded data then only the data items shown in the result on screen will be included in the CSV. For Turtle downloads all data items will be included as will the result from the SPARQL query if re-run.
Alongside the report builder we have created a SPARQL query page that you can use to try out some example SPARQL queries or create your own.
We also have made a SPARQL endpoint available. You can use the following URL address in your own scripts, applications and SPARQL query tools:
Via the API
It is possible to query the UKHPI dataset directly through an application programming interface (API). This largely removes the need to know how to use SPARQL as long as the structure of the data is known. Using the example transaction above we know that there is data for the North east of England. With that information we can enter this URL into a web browser
Note that this query will return all data for that region from the current month back to January 1995. Because Land Registry do not publish Sales Volumes with the same frequency as other data there will be no Sales Volume figure for the first two months displayed. By default a count of the results generated for the query is displayed on screen.
There are options to generate the data displayed for download in another format, for example csv, note that the results will be limited to the same number of results displayed on screen.
Similarly other areas can be queried. In the following example, figures for all of England and Wales are shown:
The query can be extended to give specific months:
It is also possible to select ranges and sort the data returned. The following example returns figures for England and Wales where the monthly change is between 1% and 10%, sorted on the reporting period:
It is possible to change the results displayed using the
customise your search
button at the top of the page and the filters on the page allow easy sorting or filtering of results.