FHFA House Price Index by state, quarterly
Quarterly purchase-only House Price Index by U.S. state from the Federal Housing Finance Agency master file (https://www.fhfa.gov/hpi/download/monthly/hpi_master.csv). The flagship FHFA HPI: seasonally adjusted purchase-only data from Fannie Mae and Freddie Mac, weighted repeat-sales method, indexed to 1991Q1=100; both the seasonally adjusted and not-seasonally-adjusted series are included. Method: keyless download of the master CSV, filtered to level=State, hpi_flavor=purchase-only, hpi_type=traditional, frequency=quarterly. Units: index points (1991Q1=100). Caveats: the latest quarter is preliminary and revised in later releases; the index measures price change, not price levels, so cross-state level comparisons are meaningless — compare growth rates; 'FHFA House Price Index®' is a registered trademark (branding constraint only). Coverage: 50 states + DC, 1991Q1 to the latest published quarter, quarterly granularity. Provenance: FHFA HPI master file, U.S. public domain - please cite the Federal Housing Finance Agency. Primary key: (state_code, year, quarter). Join keys: state_code, year. Cadence: refreshed quarterly; a new snapshot appears only when FHFA publishes or revises data. Sample use: quarter-over-quarter growth by state for housing market momentum.
- Rows
- 7,242
- Columns
- 6
- Source cadence
- Quarterly
- Last refreshed
- Sep 23, 2026
- Theme
- housing
| Column | Type | Description |
|---|---|---|
| state_code | string | Two-letter U.S. postal code of the state (the master file's 'place_id'); with year and quarter forms the primary key. |
| state_name | string | State name (the master file's 'place_name'). |
| year | integer | Calendar year of the observation quarter. |
| quarter | integer | Calendar quarter (1-4). |
| index_nsa | float | Purchase-only House Price Index, not seasonally adjusted (the master file's 'index_nsa'). (unit: index points (1991Q1=100)) |
| index_sa | float | Purchase-only House Price Index, seasonally adjusted (the master file's 'index_sa') — the flagship FHFA series. (unit: index points (1991Q1=100)) |
First 10 sample rows — a preview, not the complete dataset.
| state_code | state_name | year | quarter | index_nsa | index_sa |
|---|---|---|---|---|---|
| AK | Alaska | 1,991 | 1 | 100 | 100 |
| AK | Alaska | 1,991 | 2 | 100.92 | 100.32 |
| AK | Alaska | 1,991 | 3 | 102.18 | 101.51 |
| AK | Alaska | 1,991 | 4 | 102.45 | 102.63 |
| AK | Alaska | 1,992 | 1 | 103.09 | 103.05 |
| AK | Alaska | 1,992 | 2 | 104.5 | 103.87 |
| AK | Alaska | 1,992 | 3 | 105.28 | 104.59 |
| AK | Alaska | 1,992 | 4 | 104.38 | 104.65 |
| AK | Alaska | 1,993 | 1 | 105.17 | 105.05 |
| AK | Alaska | 1,993 | 2 | 107.36 | 106.68 |
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/fhfa/fhfa_house_price_index_state_quarterly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/fhfa/fhfa_house_price_index_state_quarterly").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/fhfa/fhfa_house_price_index_state_quarterly
Tip: fetch /llms.txt for the full machine-readable catalog.