Real US Home Price Index: Case-Shiller Deflated by CPI, Monthly Since 1987

The Real US Home Price Index is an Eco3min monthly composite that strips CPI-U inflation out of the S&P CoreLogic Case-Shiller National Home Price Index, isolating genuine housing appreciation from generalized price-level changes. Built by dividing CSUSHPINSA by CPIAUCSL and rebasing to a common reference period, the Real US Home Price Index runs monthly from January 1987 to the most recent Case-Shiller release. The 2006 peak, the 2012 trough, and the post-2020 surge become visually unambiguous once inflation is removed — making real prices the correct measure for assessing affordability dynamics, wealth-effect transmission, and the credit cycle.

Dataset: Real US Home Price Index (1987–2026) · Updated —

Source: FRED series CSUSHPINSA · S&P CoreLogic Case-Shiller (CSUSHPINSA) & BLS (CPIAUCSL) via FRED

Macro Takeaway

Construction & Components

The Real US Home Price Index deflates the nominal Case-Shiller National Home Price Index by the CPI-U to produce a constant-purchasing-power housing-price series. Both inputs are level indices, not growth rates, so the composite uses index-on-index division rather than nominal-minus-inflation subtraction. Related coverage: How REIT prices track cap rates.

Formula:

Real Housing Index = (CSUSHPINSA / CPIAUCSL) × C
                     where C is a rebasing constant
                     (both series rebased to a common reference period)

Components:

• S&P CoreLogic Case-Shiller National Home Price Index — FRED series CSUSHPINSA, monthly with a ~2-month publication lag. Three-month moving average of repeat-sales transaction pairs. The numerator: nominal home prices.
• CPI-U, All Items — FRED series CPIAUCSL, BLS source, monthly with a ~2-week publication lag. The denominator: the price level by which nominal home prices are deflated.

Frequency reconciliation: Both components are monthly. CPI-U publishes earlier in the month for the prior period; Case-Shiller publishes later for a period that lags by another month. The composite is computed only once both observations for a given month are available, producing a clean monthly real-index series with no interpolation.

Coverage: January 1987 to present. The start date is set by the historical extent of the Case-Shiller National series on FRED, which itself begins in January 1987. The 20-City Case-Shiller variant starts only in 2000; the National version provides the longest coherent national history available from this source.

Dataset Overview

Dataset Variables

The CSV and Excel files contain the following columns.

Column names match the CSV headers exactly.

Download the Complete Dataset

The full dataset is available in CSV and Excel formats.

Source FRED Series Used for This Composite

Both components of the Real US Home Price Index are publicly available from FRED. The composite itself is not — it requires the joint pull, alignment, and rebasing step performed by the Eco3min pipeline.

Case-Shiller National (numerator):

https://fred.stlouisfed.org/graph/fredgraph.csv?id=CSUSHPINSA

CPI-U All Items (denominator):

https://fred.stlouisfed.org/graph/fredgraph.csv?id=CPIAUCSL

Direct CSV Access — Eco3min Structured Dataset

https://eco3min.fr/dataset/real-housing-price.csv

This URL returns the complete pre-computed real index in CSV format. It can be used directly in pandas, R, curl, or any data tool.

Using the Dataset in Python

import pandas as pd

url = "https://eco3min.fr/dataset/real-housing-price.csv"
df = pd.read_csv(url, parse_dates=["date"])

print(df.head())
print(df["real_housing_index"].describe())

Using the Dataset in R

library(readr)

url <- "https://eco3min.fr/dataset/real-housing-price.csv"
df <- read_csv(url)

head(df)
summary(df$real_housing_index)

Both examples load the dataset directly from the URL — no download or API key required.

Methodology

The Real US Home Price Index is recomputed monthly by an Eco3min pipeline that pulls CSUSHPINSA and CPIAUCSL from the FRED API once the latest Case-Shiller observation is published (typically the last Tuesday of each month for the month T-2). The two series are aligned by month-end timestamp and rebased so that a common reference period equals 100, yielding a clean comparable real index. The pipeline runs after each Case-Shiller release and back-stamps any prior-period revisions from either source.

The deflator is the full CPI-U (CPIAUCSL), not the shelter-only component, by deliberate design — using shelter to deflate housing prices would create a partially circular adjustment.

Data Quality & Provider Notes

Latency for the Real US Home Price Index is dictated by the slower of the two components, which is Case-Shiller (~2-month publication lag). Even when CPI-U for the most recent month is already available, the composite cannot be computed until the matching Case-Shiller observation is released.

Both components are routinely revised. S&P revises Case-Shiller for several months after first publication as additional repeat-sales pairs are recorded; BLS revises CPI seasonally adjusted figures during the annual benchmark cycle. The Eco3min pipeline back-stamps revisions to keep the composite consistent with the latest FRED snapshot.

Alternative real housing indices exist (FHFA House Price Index deflated by CPI, BLS Owners’ Equivalent Rent series, OECD real house price index) but use different geographic coverage, weighting methodologies, or reference baselines. The Case-Shiller National repeat-sales methodology has the longest coherent national history on FRED and is the most widely cited in academic and policy work.

What This Index Captures (And What It Doesn’t)

The Real US Home Price Index answers a precise question — has the relative price of US housing versus a representative basket of consumer goods changed over a given period? It does not answer broader questions about affordability, regional disparity, or housing-market causation, and conflating the two is the most common misreading of the data.

What it captures:

• Genuine appreciation or depreciation of the US housing stock in constant purchasing-power terms
• The real component of household wealth effects transmitted by housing
• The pure-housing channel of credit-cycle dynamics, separate from generalized inflation
• Long-horizon comparability — the 1989 peak and the 2006 peak are directly comparable in real terms once both are deflated

What it does NOT capture (common misinterpretations):

• Affordability in absolute terms. A flat real index does not mean housing is affordable — it only means the relative price has not changed. Affordability also depends on mortgage rates and household income, which the index does not include.
• Regional dynamics. The National series is a single number that masks enormous geographic variation. Real prices in San Francisco, Phoenix, and Pittsburgh have followed completely different trajectories across the same time window.
• Transaction-level prices. Case-Shiller is a repeat-sales index that smooths month-to-month volatility by construction. It lags actual transaction prices at turning points and does not reflect new-construction prices at all.
• Causation toward consumer inflation. The CPI shelter component is itself influenced by lagged housing prices, creating a partial feedback loop. The real index removes the level effect of CPI but cannot fully eliminate the dynamic interaction between housing and the rest of CPI.

The Real US Home Price Index is best used as a long-horizon valuation gauge and as one input among several when assessing the housing cycle — not as a standalone affordability indicator. On the near-term side, that gauge connects to how the 2024-2026 rate path is feeding through to housing.

Historical Regimes

The Real US Home Price Index spans nearly four decades and captures several distinct housing regimes, each defined by a specific configuration of real rates, credit availability, and demographic demand.

• 1987–1990 — Late-1980s coastal boom. The series opens near 189 and the Real US Home Price Index peaked around 202 in 1989, a modest real expansion concentrated in coastal metros before the early-1990s slowdown.
• 1990–1997 — Real soft patch. Real prices drifted lower through the early-1990s recession and its aftermath, bottoming at roughly 173 in early 1997 — the lowest point in the entire series.
• 1997–2006 — The historic real bull market. The Real US Home Price Index rose roughly 75% in real terms from the 1997 low to a real peak above 300 in mid-2006, an unprecedented expansion. Coincided with sustained negative real mortgage rates after 2003, expansion of subprime lending, and a global decline in long-term real yields. See the real interest rates dataset for the parallel rate dynamic.
• 2006–2012 — The real bear market. Real prices fell roughly 36% peak-to-trough — the most severe US real housing drawdown in the series. Bottomed in early 2012, with the trough lasting around 18 months.
• 2012–2020 — Slow real recovery. Real prices rose at a moderate pace, returning to roughly mid-2000s levels by 2017; the 2006 real peak was not surpassed until 2021. Recovery was supported by sustained low real rates and constrained supply.
• 2020–2022 — Post-pandemic real surge. The Real US Home Price Index gained roughly 28% in real terms in under 24 months, reaching an all-time high near 347 in mid-2022 — the steepest real appreciation in the series. Coincided with the most negative real mortgage rates on record.
• 2022–2026 — Real correction with nominal stickiness. Real prices declined modestly from the 2022 peak as CPI inflation continued while nominal prices stagnated, the first real correction without a sustained nominal decline since 2012.

For analytical context on housing affordability as the interaction between real prices and real mortgage rates, see the rates vs prices housing affordability study.

Related Macroeconomic Datasets

Real housing prices sit at the intersection of the credit cycle and real rates. The real-rate regime determines whether housing is in a structural appreciation or correction phase; credit conditions determine the amplitude of the response.

Related Research

Housing affordability is the joint outcome of real prices and real rates; the trade-off between the two defines what households actually pay each month. To be read alongside the ratio of French home prices to household income.

Macroeconomic Dataset Hub

This dataset is part of the Eco3min macro-financial data repository.

Explore the Eco3min Dataset Hub

Sources

• S&P CoreLogic Case-Shiller National Home Price Index (FRED: CSUSHPINSA)
• US Bureau of Labor Statistics, Consumer Price Index for All Urban Consumers (FRED: CPIAUCSL)

Dataset Reference

Eco3min Research. (2026). Real US Home Price Index (1987–2026).<br> https://eco3min.fr/en/us-real-housing-price-index-dataset/