Housing in London

  • by user1
  • 05 March, 2022

Historical prices, sales, crimes, resident satisfaction and salaries by borough

LicenseOther (specified in description)

Tagssocial sciencesocial issues and advocacyreal estatecities and urban areashousing

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.


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


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.


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:

Cover photo by Frans Ruiter from Unsplash


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.

Size: 170 KB Price: Free Author: Justinas Cirtautas Data source: kaggle.com