I publish two free tables on data.yappman.com, both built from public UK data and offered under the Open Government Licence v3.0. This post says what is in them, how the yield is worked out, and where they stop.
- Median sold prices by postcode district, England and Wales: https://data.yappman.com/sold-prices/
- Gross rental yield by local authority, England and Wales: https://data.yappman.com/rental-yield/
Both are statistics, not advice and not a valuation.
Median sold prices by postcode district
The table is updated monthly from HM Land Registry Price Paid Data. It uses standard sales (category A) by transfer date, over the 12 months ending three months before the latest monthly file. It also gives the 3-month median and the change from the 12 months before.
Medians and quartiles are left blank where a period has fewer than 5 sales, which is too few for a meaningful figure.
Two things to know:
- It is not an index. The mix of homes sold changes from period to period.
- Sales are registered weeks or months after the transfer date, so the newest months start low and rise in later tables, the 3-month figures most of all. Figures are also revised as HM Land Registry corrects its data.
The table for 2026-10 covers sales from 2025-08 to 2026-07: 11,377 rows for 2,526 districts. It was built on 5 November 2026. Each dated file stays as it was first published, and there are CSV and JSON downloads.
Gross rental yield by local authority
This table is updated monthly. For each local authority and property type (all homes, detached, semi-detached, terraced, flat) it gives:
- the average monthly rent, from the ONS Price Index of Private Rents (PIPR);
- the number of sales and the median price of standard sales (category A) from HM Land Registry, for the same type and the same 12 months;
- the gross yield: the average monthly rent times 12, divided by the median price, as a percentage to one decimal place.
The rent is the mean of PIPR's 12 monthly figures for the same 12 months as the sales. It covers new and existing tenancies. Bedroom rents appear on the all-homes row only, as context. HM Land Registry has no bedroom counts, so there is no bedroom yield.
The table for 2026-10 uses rents and sales from 2025-08 to 2026-07 and the PIPR edition of 2026-10-21. It has 316 local authorities (294 in England, 22 in Wales) and 1,580 rows. 1,552 rows have a yield and 27 type yields are withheld. It was built on 6 November 2026.
For example, the all-homes rows show Leeds at 5.4% (a rent of £1,121 a month against a median price of £250,000, from 8,964 sales) and Cardiff at 5.1%. The same rows show Manchester at 6.2% and Westminster at 4.7%.
Read this before you use the yields
- It is gross. It is before costs, voids, tax and finance. It is not advice.
- The two sides are different homes. The rent is a mean and the price a median, and the homes that are rented are not the homes that sold. These are area averages, not a valuation.
- PIPR is statistics in development. The ONS labels these figures that way. They are not seasonally adjusted.
- Some areas are left out. Scotland and Northern Ireland are not covered: PIPR publishes them by Broad Rental Market Area, and HM Land Registry has no data for them. City of London and the Isles of Scilly are not covered either, because PIPR does not publish them.
When a yield is withheld
On a property-type row, the yield is shown as a dash in two cases.
- The type has fewer than 20 sales in the 12 months. 14 rows are withheld for this reason.
- The yield is below half of that authority's all-homes yield. I take that as a sign that the rented homes and the sold homes of that type are not alike. 13 rows are withheld for this reason. In the cases I checked when I reviewed the first table, these were inner London house types, where the rent PIPR gives for a house type is close to the area's flat rent while the median sale price for that type is very high.
The rent, sales and median are still shown on a withheld row, with a footnote giving the reason. A plain dash with no note means there is no figure: fewer than 5 sales, or a rent PIPR does not publish for all 12 months. The all-homes row is never withheld.
If you need outcode and bedroom level
These tables are by local authority. For outcode and bedroom level from current listings, the UK Property Listings Scraper Actor has a rentalYield summary, which gives yields per outcode from advertised asking prices (not valuations) and bedroom count (0 to 5+). It is a paid pay-per-event Actor on the Apify Store: https://apify.com/yappman/uk-property-listings
On the Free plan a listing costs $0.00125 and each run $0.005. The summary itself is free; the listing rows it reads are charged as usual. Paid plans pay less. Check the Store page for current prices.
Licence and sources
Contains HM Land Registry data © Crown copyright and database right 2026. This data is licensed under the Open Government Licence v3.0. Rents and local authority codes: Source: Office for National Statistics licensed under the Open Government Licence v3.0. Contains OS data © Crown copyright and database right 2026. Contains Royal Mail data © Royal Mail copyright and database right 2026.
Top comments (0)