housing_home_values_county_year
Home value index by county and year, 1975–2025. FHFA House Price Index (HPI) tracks average house price appreciation using repeat-sales methodology on conforming-loan transactions.
overview
~2,300 counties x 51 years = 106,252 rows. FHFA HPI covers counties with sufficient repeat-sale conforming-loan transactions.
current vintage — 2025 Q4 / annual
history — FHFA county HPI: 1975-present
source & licensing
fields
| name | type | definition |
|---|---|---|
| _ingested_at | timestamp | Timestamp when this record was written to BigQuery.Pipeline metadata field. |
| _ingestor_version | string | Version of the ingestor script that produced this record.Pipeline metadata field. |
| _reliability_tier | string | Data quality tier (A/B/C) assigned at ingestion.Pipeline metadata field. |
| _source_dataset_id | string | Internal dataset identifier linking to meta.datasets.Pipeline metadata field. |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_idkey | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| county_name | string | Human-readable county name corresponding to county_id. |
| home_price_change_20yr_pct | float64 · percent | Percentage change in the county's home price index over the trailing twenty-year window ending in the current year. Captures long-run structural appreciation or depreciation trends in the local housing market. |
| home_price_change_5yr_pct | float64 · percent | Percentage change in the county's home price index over the trailing five-year window ending in the current year. Captures medium-term price trends; positive values indicate appreciation over the period. |
| home_price_change_yoy_pct | float64 · percent | Percentage change in the county's home price index from the prior year to the current year. Positive values indicate year-over-year appreciation; negative values indicate depreciation. |
| hpi | float64 · index | Federal Housing Finance Agency (FHFA) House Price Index for the county, measuring single-family home price levels relative to a reference period. Higher values indicate higher home prices relative to the index base. |
| hpi_1990_base | float64 · index (1990=100) | FHFA House Price Index rebased so that the county's home price level in 1990 equals 100. Enables long-run comparisons anchored to 1990 price levels; values above 100 indicate appreciation since 1990. |
| hpi_2000_base | float64 · index (2000=100) | FHFA House Price Index rebased so that the county's home price level in 2000 equals 100. Values above 100 indicate appreciation since 2000; below 100 indicate depreciation. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| yearkey | int64 | Reference year of the observation. |
joins
how to use this table
Repeat-sales index from Fannie Mae/Freddie Mac conforming-loan acquisitions. County-level requires sufficient transaction volume (small counties may be missing or volatile).
Cash-only transactions (FHFA covers conforming loans only); luxury-segment properties above conforming limit; counties with thin transaction volume.
Conforming-loan-only - undercounts cash buyers and jumbos. Index is unitless; cannot infer dollar levels without anchoring.