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.

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.

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.

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.

This page is no longer being updated. Please use the UK House Price Index instead. Mix-adjusted house prices, by new/pre-owned dwellings, type of buyer (first time buyer) and region, from February 2002 for London and UK, and average mix-adjusted prices by UK region, and long term Annual House Price Index data since 1969 for London. The ONS House Price Index is mix-adjusted to allow for differences between houses sold (for example type, number of rooms, location) in different months within a year. House prices are modelled using a combination of characteristics to produce a model containing around 100,000 cells (one such cell could be first-time buyer, old dwelling, one bedroom flat purchased in London). Each month estimated prices for all cells are produced by the model and then combined with their appropriate weight to produce mix-adjusted average prices. The index values are based on growth rates in the mix-adjusted average house prices and are annually chain linked. The weights used for mix-adjustment change at the start of each calendar year (i.e. in January). The mix-adjusted prices are therefore not comparable between calendar years, although they are comparable within each calendar year. If you wish to calculate change between years, you should use the mix-adjusted house price index, available in Table 33. The data published in these tables are based on a sub-sample of RMS data. These results will therefore differ from results produced using full sample data. For further information please contact the ONS using the contact details below. House prices, mortgage advances and incomes have been rounded to the nearest £1,000. Data taken from Table 2 and Table 9 of the monthly ONS release. Download from ONS website

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

🇬🇧 United Kingdom English 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.

Through reading this publication you will: • gain an understanding of how house prices are set in economics terms, how they are measured, and why the cost of housing matters for London’s economy and its residents • see whether incomes and earnings in London have kept pace with the costs of home ownership in London, and see how affordability may be affected by future changes in interest rates • find out about the drivers of demand for residential property in London, and how the supply of homes has responded to changing conditions

Annual house price inflation, simple and mix-adjusted average house prices, by dwelling, type of buyer, number of transactions, mortgage advances, distribution of borrowers' ages/incomes, interest rates, land prices, average valuations, Land Registry data

Annual house price inflation, simple and mix-adjusted average house prices, by dwelling, type of buyer, number of transactions, mortgage advances, distribution of borrowers' ages/incomes, interest rates, land prices, average valuations, Land Registry data

Ratios of house prices to annual disposable household incomes, by decile, for countries of the UK and regions of England. Part of our additional measures of housing affordability series.

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 4th of each month.

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

Additional affordable dwellings by local authority district, England 1991-92 to 2016-17

This dataset describes the additions to the stock of affordable housing from the period 1991-92 to 2016-17, broken down by local authority district. Note that over that period, there have been numerous changes to the structure of local government, therefore some districts do not have values for the full series of years, only for those years when the corresponding local authority was in operation. Affordable housing is the sum of affordable rent, social rent, intermediate rent and affordable home ownership. Affordable homes are defined in line with the National Planning Policy Framework, published 27 March 2012, as housing units (or traveller pitches and bed spaces when describing a shared dwelling such as a hostel) provided to specified eligible households whose needs are not met by the market. Eligibility may be determined with regard to local authority allocations policies, local incomes and local house prices depending on the type of affordable housing. Affordable housing should include provisions to remain at an affordable price for future eligible households or for the subsidy to be recycled for alternative affordable housing provision. Affordable rented housing is a new form of social housing, introduced in 2011 as the main type of affordable housing supply. It may only be delivered with grant through the Affordable Homes Programme 2011-17 and other associated and subsequent programmes or without grant by local authority and other providers, where a contract or confirmation of the ability to charge an affordable rent is in place. Affordable rented homes are let by local authorities or private registered providers of social housing to households who are eligible for social rented housing. Affordable rent is subject to rent controls that require a rent of up to 80 per cent of the local market rent (including service charges, where applicable). Social rented housing is rented housing owned and managed by local authorities and private registered providers, for which target rents are determined through the national rent regime. It may also include rented housing managed by other persons and provided under equivalent rental arrangements to the above. Intermediate affordable housing is housing at prices and rents above those of social rent but below market price or rents, and which meet the criteria as set out in the definition for affordable housing. These can include equity loan products, shared ownership and intermediate rent. The data in this dataset were derived from Tables 1006C, 1006aC, 1007C and 1008C of the DCLG 'Live statistical tables', available in the form of Excel spreadsheets here. For further guidance see the Affordable Housing Supply: April 2016 to March 2017 England Statistical Release.

FOCUSONLONDON2011: HOUSING:AGROWINGCITY With the highest average incomes in the country but the least space to grow, demand for housing in London has long outstripped supply, resulting in higher housing costs and rising levels of overcrowding. The pressures of housing demand in London have grown in recent years, in part due to fewer people leaving London to buy homes in other regions. But while new supply during the recession held up better in London than in other regions, it needs to increase significantly in order to meet housing needs and reduce housing costs to more affordable levels. This edition of Focus on London authored by James Gleeson in the Housing Unit looks at housing trends in London, from the demand/supply imbalance to the consequences for affordability and housing need. PRESENTATION: How much pressure is London’s popularity putting on housing provision in the capital? This interactive presentation looks at the effect on housing pressure of demographic changes, and recent new housing supply, shown by trends in overcrowding and house prices. Click on the start button at the bottom of the slide to access. View Focus on London - Housing: A Growing City on Prezi FACTS: Some interesting facts from the data… ● Five boroughs with the highest proportion of households that have lived at their address for less than 12 months in 2009/10:

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).

FOCUSON**LONDON**2010:**INCOME**AND**SPENDING**AT**HOME** Household income in London far exceeds that of any other region in the UK. At £900 per week, London’s gross weekly household income is 15 per cent higher than the next highest region. Despite this, the costs to each household are also higher in the capital. Londoners pay a greater amount of their income in tax and national insurance than the UK average as well as footing a higher bill for housing and everyday necessities. All of which leaves London households less well off than the headline figures suggest. This chapter, authored by Richard Walker in the GLA Intelligence Unit, begins with an analysis of income at both individual and household level, before discussing the distribution and sources of income. This is followed by a look at wealth and borrowing and finally, focuses on expenditure including an insight to the cost of housing in London, compared with other regions in the UK. See other reports from this Focus on London series. REPORT: To view the report online click on the image below. Income and Spending Report PDF https://londondatastore-upload.s3.amazonaws.com/fol/fol10-income-cover-thumb1.png" alt="Alt text"> PRESENTATION: This interactive presentation finds the answer to the question, who really is better off, an average London or UK household? This analysis takes into account available data from all types of income and expenditure. Click on the link to access. PREZI The Prezi in plain text version RANKINGS: https://londondatastore-upload.s3.amazonaws.com/fol/fol10-income-tableau-chart-thumb.jpg" alt="Alt text"> This interactive chart shows some key borough level income and expenditure data. This chart helps show the relationships between five datasets. Users can rank each of the indicators in turn. Borough rankings Tableau Chart MAP: These interactive borough maps help to geographically present a range of income and expenditure data within London. Interactive Maps - Instant Atlas DATA: All the data contained within the Income and Spending at Home report as well as the data used to create the charts and maps can be accessed in this spreadsheet. Report data FACTS: Some interesting facts from the data… ● Five boroughs with the highest median gross weekly pay per person in 2009: -1. Kensington & Chelsea - £809 -2. City of London - £767 -3. Westminster - £675 -4. Wandsworth - £636 -5. Richmond - £623 -32. Brent - £439 -33. Newham - £422 ● Five boroughs with the highest median weekly rent for a 2 bedroom property in October 2010: -1. Kensington & Chelsea - £550 -2. Westminster - £500 -3. City of London - £450 -4. Camden - £375 -5. Islington - £360 -32. Havering - £183 -33. Bexley - £173 ● Five boroughs with the highest percentage of households that own their home outright in 2009: -1. Bexley – 38 per cent -2. Havering – 36 per cent -3. Richmond – 32 per cent -4. Bromley – 31 per cent -5. Barnet – 28 per cent -31. Tower Hamlets – 9 per cent -32. Southwark – 9 per cent

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.