In January 2025, the average monthly rent in Greater London reached 2,227 British pounds, confirming its position as the most expensive area for private tenants. Rental prices across England stood at 1,375 British pounds, while the average for Great Britain was recorded at 1,332 British pounds. The North East remains the most affordable region, with rents at 710 British pounds. According to the UK Price Index of Private Rents (PIPR), rental growth has accelerated since 2021, with the cost of rental properties rising by nearly nine percent annually in January 2025.

Update 29-04-2020: The data is now split into two files based on the variable collection frequency (monthly and yearly). Additional variables added: area size in hectares, number of jobs in the area, number of people living in the area.

Context

I have been inspired by Xavier and his work on Barcelona to explore the city of London! 🇬🇧 💂

Content

The datasets is primarily centered around the housing market of London. However, it contains a lot of additional relevant data: - Monthly average house prices - Yearly number of houses - Yearly number of houses sold - Yearly percentage of households that recycle - Yearly life satisfaction - Yearly median salary of the residents of the area - Yearly mean salary of the residents of the area - Monthly number of crimes committed - Yearly number of jobs - Yearly number of people living in the area - Area size in hectares

The data is split by areas of London called boroughs (a flag exists to identify these), but some of the variables have other geographical UK regions for reference (like England, North East, etc.). There have been no changes made to the data except for melting it into a long format from the original tables.

Acknowledgements

The data has been extracted from London Datastore. It is released under UK Open Government License v2 and v3. The underlining datasets can be found here: https://data.london.gov.uk/dataset/uk-house-price-index https://data.london.gov.uk/dataset/number-and-density-of-dwellings-by-borough https://data.london.gov.uk/dataset/subjective-personal-well-being-borough https://data.london.gov.uk/dataset/household-waste-recycling-rates-borough https://data.london.gov.uk/dataset/earnings-place-residence-borough https://data.london.gov.uk/dataset/recorded_crime_summary https://data.london.gov.uk/dataset/jobs-and-job-density-borough https://data.london.gov.uk/dataset/ons-mid-year-population-estimates-custom-age-tables

Cover photo by Frans Ruiter from Unsplash

Inspiration

The dataset lends itself for extensive exploratory data analysis. It could also be a great supervised learning regression problem to predict house price changes of different boroughs over time.

In the five-year period between 2024 and 2028, the prime residential rent for existing properties in Greater London is expected to increase by over 19 percent. The highest percentage change is expected to occur in 2024, when rents are to rise by 5.5 percent. In the UK. rental growth has accelerated notably since 2021, with March 2024 experiencing a decade-high annual percentage growth. The trend reflects the complex interplay between housing affordability, mortgage rates, and supply of rental homes, as the UK housing market navigates a period of transition.

London is the most expensive city for office real estate in Europe. In 2023, the per square foot cost of office space in London was higher than in any other European city. In West End, a Grade A office cost about 90 British pounds per square foot in 2023. Prime offices were even more expensive, at 135 British pounds per square meter. Office yields Prime yields in Central London fluctuate depending on the district, but West End areas tend to have lower yields compared to other areas, such as Stratford or Canary Wharf. The prime office yield in Mayfair/St. James' in 2023 was the lowest among the major London office submarkets. In real estate, yields measure the potential return of a rental property and are calculated as the ratio of the property's rental income to the investment cost. Typically, prime office yields in London are lower than the rest of the UK, which is mostly due to the highly competitive market and high investment costs. Vacancy rates Despite the high office rental costs in England’s capital city, vacancy rates in many of London's main office markets were below seven percent in 2023. This is good news for the office sector, as during the coronavirus (COVID-19) pandemic, the share of vacant office space across all Central London districts spiked dramatically. Compared to other European cities, London was in the middle of the ranking, alongside Frankfurt and Lisbon.

Housing Index in the United Kingdom decreased to 511.60 points in June from 511.80 points in May of 2025. This dataset provides - United Kingdom House Price Index - actual values, historical data, forecast, chart, statistics, economic calendar and news.

The monthly house price index in London has been steadily increasing in recent years. In June 2024, the index reached 129.9, up from 129 a year before. Nevertheless, prices widely varied in different London boroughs, with Kensington and Chelsea being the priciest boroughs for an apartment purchase.

Housing Inventory: Median Days on Market in New London County, CT was 56.00000 Level in December of 2024, according to the United States Federal Reserve. Historically, Housing Inventory: Median Days on Market in New London County, CT reached a record high of 100.00000 in January of 2019 and a record low of 19.00000 in May of 2022. Trading Economics provides the current actual value, an historical data chart and related indicators for Housing Inventory: Median Days on Market in New London County, CT - last updated from the United States Federal Reserve on July of 2025.

Housing Inventory: Median Days on Market in Norwich-New London, CT (CBSA) was 31.00000 Level in April of 2025, according to the United States Federal Reserve. Historically, Housing Inventory: Median Days on Market in Norwich-New London, CT (CBSA) reached a record high of 111.00000 in February of 2019 and a record low of 18.00000 in May of 2022. Trading Economics provides the current actual value, an historical data chart and related indicators for Housing Inventory: Median Days on Market in Norwich-New London, CT (CBSA) - last updated from the United States Federal Reserve on May of 2025.

The house price index in London reached 129.9 index points in June 2024, which was an increase from a year ago, despite a mild correction. The house price index (HPI) is an easy way of illustrating trends in the house sales market and help simplify house purchase decisions. By using hedonic regression, the index models property price data for all dwellings and shows how much the price has changed since January 2015. How have regional house prices in the UK developed? House prices in other UK regions have risen even more than in London. In the North West, the house price index exceeded 160 index points, ranking it among the regions with the highest property appreciation. The UK house price index stood at 151 index points, suggesting an increase of 51 percent since 2015. Average house prices Location plays a huge role in the price of a home. Kensington and Chelsea and City of Westminster are undoubtedly the most expensive boroughs in London, with an average house price that can exceed one million British pounds. In comparison, a house in Barking and Dagenham cost approximately one third. Nevertheless, the housing market is the busiest in the boroughs with average house prices.

The average monthly home rental payment in the United Kingdom (UK) increased steadily since 2008, reaching 1, 258 British pounds in December 2023. In comparison, the average home buying costs amounted to 1,231 British Pounds that year, meaning that homeowners saved 27 British pounds monthly from the difference.

These National Statistics provide monthly estimates of the number of residential and non-residential property transactions in the UK and its constituent countries. National Statistics are accredited official statistics.

England and Northern Ireland statistics are based on information submitted to the HM Revenue and Customs (HMRC) Stamp Duty Land Tax (SDLT) database by taxpayers on SDLT returns.

Land and Buildings Transaction Tax (LBTT) replaced SDLT in Scotland from 1 April 2015 and this data is provided to HMRC by https://www.revenue.scot/" class="govuk-link">Revenue Scotland to continue the time series.

Land Transaction Tax (LTT) replaced SDLT in Wales from 1 April 2018. To continue the time series, the https://gov.wales/welsh-revenue-authority" class="govuk-link">Welsh Revenue Authority (WRA) have provided HMRC with a monthly data feed of LTT transactions since July 2021.

LTT figures for the latest month are estimated using a grossing factor based on data for the most recent and complete financial year. Until June 2021, LTT transactions for the latest month were estimated by HMRC based upon year on year growth in line with other UK nations.

LTT transactions up to the penultimate month are aligned with LTT statistics.

Go to Stamp Duty Land Tax guidance for the latest rates and information.

Go to Stamp Duty Land Tax rates from 1 December 2003 to 22 September 2022 and Stamp Duty: rates on land transfers before December 2003 for historic rates.

The latest release was published 09:30 27 June 2025 and was updated with provisional data from completed transactions during May 2025.

The next release will be published 09:30 31 July 2025 and will be updated with provisional data from completed transactions during June 2025.

https://webarchive.nationalarchives.gov.uk/ukgwa/20240320184933/https://www.gov.uk/government/statistics/monthly-property-transactions-completed-in-the-uk-with-value-40000-or-above" class="govuk-link">Archive versions of the Monthly property transactions completed in the UK with value of £40,000 or above are available via the UK Government Web Archive, from the National Archives.

The average mix-adjusted house price in London, England, peaked in August 2022, followed by a slight correction in 2023. In June 2024, the average house price amounted to about ******* British pounds, up from ******* British pounds a year ago. These recent fluctuations have also been observed by other measures, such as the house price index. The house price index is an important measure for the residential real estate market and is used to show changes in the value of residential properties.

Market Hotness: Listing Views per Property in New London County, CT was 1.16234 % Chg. in December of 2024, according to the United States Federal Reserve. Historically, Market Hotness: Listing Views per Property in New London County, CT reached a record high of 60.42180 in January of 2020 and a record low of -14.62787 in December of 2019. Trading Economics provides the current actual value, an historical data chart and related indicators for Market Hotness: Listing Views per Property in New London County, CT - last updated from the United States Federal Reserve on July of 2025.

Quarterly house price data based on a sub-sample of the Regulated Mortgage Survey.

Market Hotness: Listing Views per Property in Norwich-New London, CT (CBSA) was -11.72934 % Chg. from Yr. Ago in May of 2025, according to the United States Federal Reserve. Historically, Market Hotness: Listing Views per Property in Norwich-New London, CT (CBSA) reached a record high of 195.62966 in March of 2021 and a record low of -24.21746 in July of 2024. Trading Economics provides the current actual value, an historical data chart and related indicators for Market Hotness: Listing Views per Property in Norwich-New London, CT (CBSA) - last updated from the United States Federal Reserve on July of 2025.

Market Hotness: Listing Views per Property in Norwich-New London, CT (CBSA) was 3.10606 % Chg. in May of 2025, according to the United States Federal Reserve. Historically, Market Hotness: Listing Views per Property in Norwich-New London, CT (CBSA) reached a record high of 61.85646 in January of 2020 and a record low of -14.61474 in December of 2019. Trading Economics provides the current actual value, an historical data chart and related indicators for Market Hotness: Listing Views per Property in Norwich-New London, CT (CBSA) - last updated from the United States Federal Reserve on July of 2025.

Between 2008 and 2024, the average weekly rent for private renters in England has shown a significant increase. In the 2009, the average rent was 153 British pounds, and by 2024, it had risen to 237 British pounds. Excluding London, the average rent started at 130 British pounds in 2009 and reached 191 British pounds in 2024, demonstrating a similar upward trend but at a lower rate compared to the overall average in England. Rental households in England Renting is common in England. Nearly one in five households occupied a dwelling that was privately rented in 2024. While the majority of households in the country live in an owner-occupied home, this percentage has declined since the early 2000s. Meanwhile, the share of households occupying a private rental has doubled over the past decade. This shows a growing rental sector and a shift in tenure trends in the country. Buying vs renting costs For a long time, the average monthly costs of buying a home were lower than renting. In 2021, housing costs started to increase steeply, closely followed by rental costs. This resulted in the gap nearly closing in 2023. This trend can also be observed through the house price to rent ratio - an index that follows the development of house prices relative to rents, with 2015 as a baseline year. Between 2015 and 2022, the ratio grew steadily, indicating that property prices rise faster than rents. However, with rental growth accelerating and catching up with property prices in 2022, the index declined notably.