Affordability ratios calculated by dividing house prices by gross annual residence-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

Affordability ratios calculated by dividing house prices for newly-built dwellings, by gross annual workplace-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

Affordability ratios calculated by dividing house prices by gross annual residence-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

Context

Demand for houses has exploded in the UK in the last two years due to the pandemic. As a result, it feels like it is becoming more difficult for young people to afford to buy a house in the near future. I wanted to collect data to see if this sentiment is backed up by numbers.

Content

In this folder you will find the average house price in the UK between between 1975 and 2020, the median wage in the UK between 1999 and 2020. Both of these metrics have been adjusted by inflation up to 2020.

This folder also contains a table containing data on the wage gap in 2021, in the UK and by age group.

Sources

Statista: https://www.statista.com/statistics/802183/annual-pay-employees-in-the-uk/ and https://www.statista.com/statistics/1002964/average-full-time-annual-earnings-in-the-uk/.

allAgents: https://www.allagents.co.uk/house-prices-adjusted/.

Bank of England: https://www.bankofengland.co.uk/monetary-policy/inflation/inflation-calculator.

This table shows the average House Price/Earnings ratio, which is an important indicator of housing affordability. Ratios are calculated by dividing house price by the median earnings of a borough. The Annual Survey of Hours and Earnings (ASHE) is based on a 1 per cent sample of employee jobs. Information on earnings and hours is obtained in confidence from employers. It does not cover the self-employed nor does it cover employees not paid during the reference period. Information is as at April each year. The statistics used are workplace based full-time individual earnings. Pre-2013 Land Registry housing data are for the first half of the year only, so that they are comparable to the ASHE data which are as at April. This is no longer the case from 2013 onwards as this data uses house price data from the ONS House Price Statistics for Small Areas statistical release. Prior to 2006 data are not available for Inner and Outer London. The lowest 25 per cent of prices are below the lower quartile; the highest 75 per cent are above the lower quartile. The "lower quartile" property price/income is determined by ranking all property prices/incomes in ascending order. The 'median' property price/income is determined by ranking all property prices/incomes in ascending order. The point at which one half of the values are above and one half are below is the median. Regional data has not been published by DCLG since 2012. Data for regions has been calculated by the GLA. Data since 2014 has been calculated by the GLA using Land Registry house prices and ONS Earnings data. Link to DCLG Live Tables An interactive map showing the affordability ratios by local authority for 2013, 2014 and 2015 is also available.

This dataset contains the ratio of lower quartile/median house price to lower quartile/median earnings in England This dataset uses the median/lower quartile house price data sourced from ONS House Price Statistics for Small Areas (HPSSA) statistical release for years 2013-2015 and house price data sourced directly from Land Registry prior to 2013. This leads to slight differences in the distribution of affordability ratios before and after 2013 which should be noted if the dataset is used as a time series. It is planned to update the ratios with the HPSSA dataset for all years in the future. The house price data is then compared to the median/lower quartile income data of full time workers from the Annual Survey of Hours and Earnings (ASHE) produced by the ONS. This data was derived from Table 576 and 577, available for download as an Excel spreadsheet from the Live tables page (https://www.gov.uk/government/statistical-data-sets/live-tables-on-housing-market-and-house-prices). More details about the data sources are also available in the link provided.

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.

Ratio of median quartile workplace earnings to median quartile house prices. The statistics used are workplace based full-time individual earnings. Source: Land Registry/Annual Survey of Hours and Earnings Publisher: Communities and Local Government (CLG) Geographies: Local Authority District (LAD), County/Unitary Authority, Government Office Region (GOR), National Geographic coverage: England Time coverage: 1997 to 2009 Type of data: Survey

Housing affordability (house prices to earnings ratio) *This indicator has been discontinued

This dataset contains the ratio of median house price to median earnings by district from 1997 to 2012. This data set uses the median house price data from Land Registry on residential house price transactions at full market value, this means it excludes all: commercial transactions, transfer, conveyances, assignments or lease at a premium with nominal rent which are: Right to Buy sales at a discount, subject to a lease, subject to an existing mortgage, by way of a gift or exchange or under a court order or Compulsory Purchase Order. This is compared to the median income data of full time workers from the Annual Survey of Hours and Earnings (ASHE) produced by the ONS. This data was derived from Table 577, available for download as an Excel spreadsheet.

This dataset contains the indices of UK hourly Construction Wage Costs (quarterly; not seasonally adjusted; 2000 = 100) and UK Construction Material Prices for New Housing, Other New Work, Repair and Maintenance, and All Work (monthly; 2010 = 100).

Ratio of lower quartile house price to lower quartile earnings, England, from 1996 (quarterly) Ratio of lower quartile house price to lower quartile earnings by district, from 1997

Ratio of lower quartile workplace earnings to lower quartile house prices. The statistics used are workplace based full-time individual earnings. The ""lower quartile"" property price/income is determined by ranking all property prices/incomes in ascending order. The lowest 25 per cent of prices are below the lower quartile; the highest 75 per cent are above the lower quartile." Source: Land Registry/Annual Survey of Hours and Earnings Publisher: Communities and Local Government (CLG) Geographies: Local Authority District (LAD), County/Unitary Authority, Government Office Region (GOR), National Geographic coverage: England Time coverage: 1997 to 2009 Type of data: Survey

Affordability ratios calculated by dividing house prices for existing dwellings, by gross annual residence-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

The StatXplore Children in low-income families' local area statistics (CiLIF) provides information on the number of children living in Relative low income by local area across the United Kingdom.The summary Statistical Release and tables which also show the proportions of children living in low income families are available here: Children in low income families: local area statistics - GOV.UK (www.gov.uk)Statistics on the number of children (by age) in low income families by financial year are published on Stat-Xplore. Figures are calibrated to the Households Below Average Income (HBAI) survey regional estimates of children in low income but provide more granular local area information not available from the HBAI, for example by Local Authority, Westminster Parliamentary Constituency and Ward.

Relative low-income is defined as a family in low income Before Housing Costs (BHC) in the reference year. A family must have claimed Child Benefit and at least one other household benefit (Universal Credit, tax credits, or Housing Benefit) at any point in the year to be classed as low income in these statistics. Gross income measure is Before Housing Costs (BHC) and includes contributions from earnings, state support and pensions.

Affordability ratios calculated by dividing house prices by gross annual workplace-based earnings for former local authorities.

Introduction This note summarises trends in pay in London and the UK since 2010 and compares them to inflation trends. The focus is on median gross weekly earnings for all employees (full- and part-time) working in London. The counterfactual analysis is based on annual pay estimates. ### Notes on the data * The employee pay estimates in this note do not cover self-employed jobs and come from a survey of UK businesses. There are, moreover, several discontinuities in the ONS ASHE series (e.g. in 2004, 2006, 2011 and 2021). The growth rates calculated over these periods are illustrative, not precise figures. * During the pandemic earnings estimates were affected by compositional changes and the furlough scheme, making interpretation more difficult. Data collection disruption and lower response rates also mean that estimates for 2020 and 2021 are subject to greater uncertainty. * Real earnings (earnings adjusted for inflation) have been calculated by adjusting nominal (unadjusted) earnings using the Consumer Prices Index including owner occupiers’ housing costs (CPIH). The CPIH is the most comprehensive measure of inflation in the UK.

This is the proportion of children aged under 16 (0-15) living in families in absolute low income during the year. The figures are based on the count of children aged under 16 (0-15) living in the area derived from ONS mid-year population estimates. The count of children refers to the age of the child at 30 June of each year.

Low income is a family whose equivalised income is below 60 per cent of median household incomes. Gross income measure is Before Housing Costs (BHC) and includes contributions from earnings, state support, and pensions. Equivalisation adjusts incomes for household size and composition, taking an adult couple with no children as the reference point. For example, the process of equivalisation would adjust the income of a single person upwards, so their income can be compared directly to the standard of living for a couple.

Absolute low income is income Before Housing Costs (BHC) in the reference year in comparison with incomes in 2010/11 adjusted for inflation. A family must have claimed one or more of Universal Credit, Tax Credits, or Housing Benefit at any point in the year to be classed as low income in these statistics. Children are dependent individuals aged under 16; or aged 16 to 19 in full-time non-advanced education. The count of children refers to the age of the child at 31 March of each year.

Data are calibrated to the Households Below Average Income (HBAI) survey regional estimates of children in low income but provide more granular local area information not available from the HBAI. For further information and methodology on the construction of these statistics, visit this link. Totals may not sum due to rounding.

Data is Powered by LG Inform Plus and automatically checked for new data on the 3rd of each month.

Affordability ratios calculated by dividing house prices by gross annual workplace-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.