Affordability ratios calculated by dividing house prices for newly-built dwellings, 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.

Land Registry housing data are for the first half of the year only, so that they comparable to the ASHE data which are as at April.
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 for 2014 has been calculated by the GLA.

Link to DCLG Live Tables

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.

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 dataset contains the ratio of lower quartile/median house price to lower quartile/median earnings in England

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.

EnhancedHousingMarketData.csv is an auxiliary dataset for the "Housing Prices" competition, containing key economic and demographic indicators vital for real estate market analysis. It includes data on non-farm employment, housing price index, per capita income, total quarterly wages, quantitative indexes of real GDP, total GDP, real GDP, stable population, employed individuals, and the average weekly wage in the private sector, along with the unemployment rate. This dataset aids in better understanding the factors influencing housing prices and allows for a more in-depth analysis of the real estate market.

"**TotalNonfarmEmployees**" - reflects the total number of employees working outside the agricultural sector. This figure includes workers in industries such as manufacturing, construction, trade, transportation, education, healthcare, and other non-agricultural sectors, making it a key indicator of economic activity and employment in the region.

"**HousingPriceIndex**" - represents a housing price index, reflecting changes in real estate prices in a specific region for a given month. This index can be used to analyze trends in the real estate market and assess the overall economic conditions.

"**AnnualPerCapitaIncome**" - represents the annual per capita income, measured yearly. This indicator reflects the average income per resident in a specific region over a year, serving as an important measure of the population's economic well-being.

"**QuarterlyTotalWages**" - represents the total quarterly wages, measured in dollars and adjusted for seasonal variations. This metric reflects the sum of wages paid by employers insured for unemployment insurance over a calendar quarter. It includes components such as vacation pay, bonuses, and tips.

"**TotalRealGDPChainIndex**" - represents the total annual quantitative index of real GDP, encompassing data from all private sectors and the government. It is based on the Fisher chain-weighted method, tracking changes in production volume or expenditures while eliminating the effects of price changes. This index is useful for comparing the volumes of production or expenditures across different time periods.

"**TotalGDP**" - describes the total Gross Domestic Product (GDP), measured in millions of dollars and calculated annually without seasonal adjustments. This metric encompasses all private sectors and the government, reflecting the market value of all final goods and services produced within an agglomeration. The agglomeration GDP represents the gross output minus intermediate costs, serving as a key indicator of economic activity and production volume.

"**TotalRealGDP**" - represents the total real Gross Domestic Product, measured in millions of chained 2012 dollars and calculated annually without seasonal adjustments. This metric includes data from all private sectors and the government. The real GDP for agglomerations is a measure of the gross product of each agglomeration, adjusted for inflation, and based on national prices for goods and services produced in the agglomeration.

"**StablePopulation**" - reflects the stable population, measured in thousands of people and calculated annually without seasonal adjustments. This metric represents population estimates as of July 1st each year, providing reliable data for analyzing demographic trends and planning purposes.

"**EmployedIndividuals**" - represents the number of employed individuals, measured in persons without seasonal adjustment and updated monthly. The data are derived from the Current Population Survey (CPS). Employed individuals include those who did any paid work, owned a business or farm, worked 15 hours or more as unpaid workers in a family business, or were temporarily absent from their job for various reasons. This metric is important for analyzing employment levels and the economic activity of the population.

"**AverageWeeklyWagePrivate**" - denotes the average weekly wage of private enterprise employees, measured in dollars per week and calculated quarterly without seasonal adjustment. It includes payments made by employers insured against unemployment over the quarter, encompassing vacation pay, bonuses, stock options, tips, and other components. This metric is important for assessing the level of wages in the private sector.

"**UnemploymentRate**" - represents the unemployment rate, measured in percentages and calculated monthly without seasonal adjustments. This metric indicates the proportion of the unemployed within the total labor force, providing key information about the labor market's condition and the population's economic activity.

Analysis of ‘Boston House Prices-Advanced Regression Techniques’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/fedesoriano/the-boston-houseprice-data on 13 February 2022.

--- Dataset description provided by original source is as follows ---

Similar Datasets

• Gender Pay Gap Dataset: LINK
• California Housing Prices Data (5 new features!): LINK
• Company Bankruptcy Prediction: LINK

Context

The Boston house-price data of Harrison, D. and Rubinfeld, D.L. 'Hedonic prices and the demand for clean air', J. Environ. Economics & Management, vol.5, 81-102, 1978.

Attribute Information

Input features in order: 1) CRIM: per capita crime rate by town 2) ZN: proportion of residential land zoned for lots over 25,000 sq.ft. 3) INDUS: proportion of non-retail business acres per town 4) CHAS: Charles River dummy variable (1 if tract bounds river; 0 otherwise) 5) NOX: nitric oxides concentration (parts per 10 million) [parts/10M] 6) RM: average number of rooms per dwelling 7) AGE: proportion of owner-occupied units built prior to 1940 8) DIS: weighted distances to five Boston employment centres 9) RAD: index of accessibility to radial highways 10) TAX: full-value property-tax rate per $10,000 [$/10k] 11) PTRATIO: pupil-teacher ratio by town 12) B: The result of the equation B=1000(Bk - 0.63)^2 where Bk is the proportion of blacks by town 13) LSTAT: % lower status of the population

Output variable: 1) MEDV: Median value of owner-occupied homes in $1000's [k$]

Source

StatLib - Carnegie Mellon University

Relevant Papers

Harrison, David & Rubinfeld, Daniel. (1978). Hedonic housing prices and the demand for clean air. Journal of Environmental Economics and Management. 5. 81-102. 10.1016/0095-0696(78)90006-2. LINK

Belsley, David A. & Kuh, Edwin. & Welsch, Roy E. (1980). Regression diagnostics: identifying influential data and sources of collinearity. New York: Wiley LINK

--- Original source retains full ownership of the source dataset ---

🇬🇧 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.

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

Japan JP: Standardised Price-Income Ratio: sa data was reported at 87.536 Ratio in 2024. This records a decrease from the previous number of 89.289 Ratio for 2023. Japan JP: Standardised Price-Income Ratio: sa data is updated yearly, averaging 113.262 Ratio from Dec 1960 (Median) to 2024, with 65 observations. The data reached an all-time high of 163.202 Ratio in 1973 and a record low of 73.471 Ratio in 2009. Japan JP: Standardised Price-Income Ratio: sa data remains active status in CEIC and is reported by Organisation for Economic Co-operation and Development. The data is categorized under Global Database’s Japan – Table JP.OECD.AHPI: House Price Index: Seasonally Adjusted: OECD Member: Annual. Nominal house prices divided by nominal disposable income per head. Net household disposable income is used. The population data come from the OECD national accounts database. The long-term average is calculated over the whole period available when the indicator begins after 1980 or after 1980 if the indicator is longer. This value is used as a reference value. The ratio is calculated by dividing the indicator source on this long-term average, and indexed to a reference value equal to 100.

Housing affordability (house prices to earnings ratio)

*This indicator has been discontinued

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 dataset provides a comprehensive view of the Portuguese housing market, integrating both listing and official transaction data. Initially compiled from historical reports by Idealista, it includes €/m² prices for sales and rentals across various Portuguese regions.

Now, this dataset has been significantly enhanced with official transaction data from the Instituto Nacional de Estatística (INE) of Portugal. This addition includes quarterly values and counts of housing transactions at a national level, providing a crucial perspective on actual market activity beyond listing prices.

This consolidated dataset is a core component of a broader case study exploring housing affordability, investment potential, and regional development across Portugal. It enables a more robust analysis by allowing comparison between asking prices and actual transaction values, as well as insights into market volume.

Additional socioeconomic data will be gradually integrated to further enrich the analysis, such as:

• Minimum and average wages (INE)
• New construction volume (INE)
• Migration and population trends
• Interest rates (Banco de Portugal)

🔗 Full pipeline and source files, including data cleaning scripts and analysis notebooks, are available on GitHub: https://github.com/igor-marques/portugal-housing-market-capstone

Data Sources Included: * Idealista: Historical listing prices (€/m²) for sales and rentals across Portuguese regions. * Instituto Nacional de Estatística (INE): Official quarterly data on housing transaction values and counts for Portugal (from Q1 2009 to Q1 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.

🇬🇧 영국

🇬🇧 영국

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

Construction Material Prices

The construction market intelligence (CMI) unit publication, ‘Monthly statistics of building materials and components’, presents the latest detailed information on selected building materials and contains monthly data on price indices, bricks, cement and concrete blocks. It also contains quarterly data on sand and gravel, slate, concrete roofing tiles, ready-mixed concrete and imports and exports of construction products.

Data are derived from a Department for Business, Innovation & Skills monthly Building Materials and Components statistical release.

Construction Wage Costs

The Index of Labour Costs per Hour (ILCH) is a measure of the cost of having an employee for an hour of work. It represents the total cost of employing an individual, which is primarily the earnings of the employee, but also includes non-wage costs. It is also known as the Labour Cost Index (LCI); the index is produced by all member countries of the EU and collated by Eurostat.

Data are derived from ONS data releases found here.

This project was designed to isolate the effects that individual crimes have on wage rates and housing prices, as gauged by individuals' and households' decisionmaking preferences changing over time. Additionally, this project sought to compute a dollar value that individuals would bear in their wages and housing costs to reduce the rates of specific crimes. The study used multiple decades of information obtained from counties across the United States to create a panel dataset. This approach was designed to compensate for the problem of collinearity by tracking how housing and occupation choices within particular locations changed over the decade considering all amenities or disamenities, including specific crime rates. Census data were obtained for this project from the Integrated Public Use Microdata Series (IPUMS) constructed by Ruggles and Sobek (1997). Crime data were obtained from the Federal Bureau of Investigation's Uniform Crime Reports (UCR). Other data were collected from the American Chamber of Commerce Researchers Association, County and City Data Book, National Oceanic and Atmospheric Administration, and Environmental Protection Agency. Independent variables for the Wages Data (Part 1) include years of education, school enrollment, sex, ability to speak English well, race, veteran status, employment status, and occupation and industry. Independent variables for the Housing Data (Part 2) include number of bedrooms, number of other rooms, building age, whether unit was a condominium or detached single-family house, acreage, and whether the unit had a kitchen, plumbing, public sewers, and water service. Both files include the following variables as separating factors: census geographic division, cost-of-living index, percentage unemployed, percentage vacant housing, labor force employed in manufacturing, living near a coastline, living or working in the central city, per capita local taxes, per capita intergovernmental revenue, per capita property taxes, population density, and commute time to work. Lastly, the following variables measured amenities or disamenities: average precipitation, temperature, windspeed, sunshine, humidity, teacher-pupil ratio, number of Superfund sites, total suspended particulate in air, and rates of murder, rape, robbery, aggravated assault, burglary, larceny, auto theft, violent crimes, and property crimes.

This is the median housing affordability ratio (residence-based) and is calculated by dividing house prices by gross annual earnings, based on the median of both house prices and earnings.

This measure of affordability shows what the people who live in a given area earn in relation to that area's house prices, even if they work elsewhere. This measure does not consider that people may be getting higher earnings from working in other areas.

A higher ratio indicates that on average, it is less affordable for a resident to purchase a house. Conversely, a lower ratio indicates higher affordability in a local authority.

The earnings data are from the Annual Survey of Hours and Earnings which provides a snapshot of earnings at April in each year. Earnings relate to gross full-time individual earnings on a place of work basis. The house price statistics come from the House Price Statistics for Small Areas, which report the median and lower quartile price paid for residential property and refer to a 12-month period with April in the middle (year ending September).

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