Data Training Courses

Price Paid SW12 Dataset

The Land Registry provide details of all the properties sold in England and Wales since 1995. This data is publicly available from HM Land Registry Price Paid Data website here.

This dataset contains a small subset of this data, about 20,000 property sales in the London SW12 post code, available as a CSV file on a public website and a database table. The data is available from a GitHub repo here and can be imported directly into Power BI using the links below.

The most important fields in PricePaidSW12 are:

TransactionID, a unique surrogate key
Price, the price paid for the property in pounds (£)
Date, the date of the transaction
PropertyTypeCode, which must be one of five values, D, S, T, F, O. (D = Detached, F = Flat, S = Semi-detached, T = Terraced, O = Other)
IsNew, which must be either Y or N. Yes indicates a new build property.
Duration, which must be either L or F. L indicates Leasehold, F indicates Freehold.
Postcode. This is in the format with a space between the two parts e.g. SW12 0AA. About 20 – 30 properties have the same postcode but the combination of postcode and PAON (house number) is nearly always unique

The data also contains several other fields about the address:

PAON Primary Addressable Object Name (typically the house number or name)
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

The PropertyTypeLookup data has a row for each property type and maps the single letter code in the PricePaid data to the name e.g. D maps to Detached

The PostCodeSW12 has a row for each postcode in SW12, with various attributes such as the latitude, Longitude and some political and sociological values, e.g. ward, local authority IMD decile. The pcds column on PostCodeSW12 matches the Postcode column on PricePaidSW12