Housing in London
- by user1
- 05 March, 2022
Historical prices, sales, crimes, resident satisfaction and salaries by borough
LicenseOther (specified in description)
Tagssocial science, social issues and advocacy, real estate, cities and urban areas, housing
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.
Size: 170 KB Price: Free Author: Justinas Cirtautas Data source: kaggle.com