Data Training Courses

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

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.

• Price Paid SW12
• Postcode SW12
• Property Type Lookup
• Ward Lookup

The most important fields in PricePaidSW12 are:

• unique_id, a unique surrogate key
• price_paid, the price paid for the property in pounds (£)
• deed_date, the date of the transaction
• 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
• property_type, which must be one of five values, D, S, T, F, O. (D = Detached, F = Flat, S = Semi-detached, T = Terraced, O = Other)
• new_build, which must be either Y or N. Yes indicates a new build property.
• estate_type, which is almost always L or F. L indicates Leasehold, F indicates Freehold.
• linked_date_uri, a URL (web link) that shows a page of data about this property - generated by the Land Registry. This incorporates the unique_id into a web URL.

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, flat name or number if a building is divided into flats
• street
• locality
• town
• district
• county

There is also a transaction_category field with a value of either A or B. Here is the description from the Land Registry.

• A = Standard Price Paid entry, includes single residential property sold for value.
• B = Additional Price Paid entry including transfers under a power of sale/repossessions, buy-to-lets (where they can be identified by a Mortgage), transfers to non-private individuals and sales where the property type is classed as ‘Other’.

The PropertyType Lookup table 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 PostCode SW12 table has a row for each postcode in SW12, with various attributes such as the latitude, longitude and some political and sociological values, e.g. the ONS code for the ward and local authority and the IMD decile. The pcds column on PostCodeSW12 matches the Postcode column on PricePaidSW12.

The Ward Lookup table maps the ward ONS code to the ward name and local authority name.