Data Training from Zomalex

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

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:

The data also contains several other fields about the address:

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