To get street-level median house prices in England and Wales, download HM Land Registry Price Paid Data, filter by postcode prefix, group by street and take the median, keeping only streets with enough sales. This tutorial does it with pandas in under 20 lines, then shows why the result needs a minimum sample size and a property-type split.
I run Door Number , which publishes street-level tables built on this data. Checked on 8 November 2026.
What does the Price Paid Data file look like?
The yearly CSV files (pp-2019.csv to pp-2026.csv) have no header row. Each record has 16 fields, in this order: transaction ID, price, date of transfer, postcode, property type (D detached, S semi-detached, T terraced, F flat or maisonette, O other), old or new build (Y or N), tenure (F freehold, L leasehold), PAON (house number or name), SAON (flat number), street, locality, town or city, district, county, PPD category type (A or B) and record status (A added, C changed, D deleted).…