National and Metro Housing Market Indicators

One row per metropolitan area or national aggregate, housing-market segment, and quarter with AEI Housing Center measures of U.S. home sales, median sale price, mortgage default stress, housing supply, new construction, and home price appreciation. Coverage runs quarterly from 2012:Q1 through 2025:Q4 for the National aggregate and major U.S. metros. The table mixes the National aggregate with metro rows, and metrics should be filtered or grouped by segment before comparison.

american-enterprise-institute-housing-market-indicators·15 columns·861 KB·AEI.org and AEImarkettrends.com Terms of Use·updated 2mo ago
American Enterprise Institute

Source: American Enterprise Institute · connector code

Schema

metroVARCHAR
metro_groupVARCHAR
year_quarterVARCHAR
yearINTEGER
quarterINTEGER
segmentVARCHAR
segment_share_of_salesDOUBLE
median_sale_priceDOUBLE
stressed_mortgage_default_rateDOUBLE
months_supplyDOUBLE
new_construction_share_of_salesDOUBLE
new_construction_contribution_existing_stockDOUBLE
hpa_yoyDOUBLE
hpa_qoqDOUBLE
cumulative_hpa_since_2012DOUBLE

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small # or medium, or large
subsets serve # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →
Bash
subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"american-enterprise-institute-housing-market-indicators\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.