housing_scorecard_county
One row per US county. 9 housing metrics (6 live, 3 stubs) across 5 groups: market prices, affordability ratios, cost burden, tenure/vacancy, supply. Includes national and state percentile ranks for 5 ranked metrics.
tier —composite_index
overview
overview
All 3,222 counties. 9 housing metrics (6 live, 3 stubs) across 5 groups with national + state percentile ranks.
current vintage — Mixed: ACS 2020-2024, FHFA 2025, BEA RPP 2023, IRS 2022
history — Snapshot only
provenance
source & licensing
authority
Federal Housing Finance Agency / U.S. Census Bureau / U.S. Bureau of Economic Analysis
dataset
House Price Index; ACS 5-Year Estimates; Regional Price Parities
source url
license
—
citation
U.S. Census Bureau (ACS 2020-2024) + Federal Housing Finance Agency (HPI) + U.S. Bureau of Economic Analysis (RPP) + IRS SOI.
schema
fields
| name | type | definition |
|---|---|---|
| acs_data_year | int64 | Reference year of the American Community Survey (ACS) data used to populate ACS-derived columns in this row. |
| 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. |
| fhfa_data_year | int64 | Reference year of the Federal Housing Finance Agency (FHFA) House Price Index data used to populate FHFA-derived columns in this row. |
| gross_rent_to_income_ratio | float64 · ratio | Median gross rent divided by median household income, annualized. Higher values indicate renting is less affordable relative to local incomes. |
| home_price_change_20yr_pct | float64 · percent (0–100) | Cumulative percentage change in the FHFA House Price Index over the twenty years ending in the reference year. Higher values indicate stronger long-run home price appreciation. |
| home_price_change_5yr_pct | float64 · percent (0–100) | Cumulative percentage change in the FHFA House Price Index over the five years ending in the reference year. Higher values indicate stronger medium-term home price appreciation. |
| home_price_change_5yr_pct_national_pctile | float64 · percent (0–100) | Percentile rank of the county's 5-year home price change among all US counties nationally. Higher values indicate stronger medium-term price appreciation relative to most counties. |
| home_price_change_5yr_pct_state_pctile | float64 · percent (0–100) | Percentile rank of the county's 5-year home price change among counties within the same state. Higher values indicate stronger medium-term appreciation relative to in-state peers. |
| home_price_change_yoy_pct | float64 · percent (0–100) | Percentage change in the FHFA House Price Index from the prior year to the current year. Positive values indicate year-over-year home price appreciation. |
| home_price_index_current | float64 · index (base year=100) | FHFA all-transactions House Price Index value for the county in the reference year. Higher values indicate home prices have appreciated more relative to the index base period. |
| home_value_to_income_ratio | float64 · ratio | Median home value divided by median household income. Higher values indicate homes are less affordable relative to local incomes. |
| home_value_to_income_ratio_national_pctile | float64 · percent (0–100) | Percentile rank of the county's home-value-to-income ratio among all US counties nationally. Higher values indicate the county is relatively less affordable for homebuyers compared to most counties. |
| home_value_to_income_ratio_state_pctile | float64 · percent (0–100) | Percentile rank of the county's home-value-to-income ratio among counties within the same state. Higher values indicate relatively lower affordability within the state. |
| homeownership_rate | float64 · percent (0–100) | Share of occupied housing units that are owner-occupied, as estimated by the ACS. Higher values indicate a greater prevalence of homeownership relative to renting. |
| housing_affordability_index | float64 · index | Composite index measuring whether a median-income household can qualify for a mortgage on a median-priced home, incorporating home prices, income, and interest rates. Values above 100 indicate the median household has sufficient income to afford the median-priced home; higher is more affordable. |
| housing_affordability_index_national_pctile | float64 · percent (0–100) | Percentile rank of the county's housing affordability index among all US counties nationally. Higher values indicate the county is more affordable relative to most counties nationally. |
| housing_affordability_index_state_pctile | float64 · percent (0–100) | Percentile rank of the county's housing affordability index among counties within the same state. Higher values indicate relatively greater affordability within the state. |
| housing_units_per_1k_pop | float64 · rate per 1,000 population | Total housing units (occupied and vacant) divided by resident population, scaled to 1,000 residents. Higher values indicate relatively more housing supply per capita. |
| median_gross_rent | int64 · dollars (nominal) | Median monthly gross rent (contract rent plus utilities) paid by renter-occupied units in the county, as estimated by the ACS. Higher values indicate a more expensive rental market. |
| median_gross_rent_national_pctile | float64 · percent (0–100) | Percentile rank of the county's median gross rent among all US counties nationally. Higher values indicate relatively more expensive rents. |
| median_gross_rent_state_pctile | float64 · percent (0–100) | Percentile rank of the county's median gross rent among counties within the same state. Higher values indicate relatively more expensive rents within the state. |
| median_home_value | int64 · dollars (nominal) | Median self-reported value of owner-occupied housing units in the county, as estimated by the ACS. Higher values indicate a more expensive owner-occupied housing market. |
| median_home_value_national_pctile | float64 · percent (0–100) | Percentile rank of the county's median home value among all US counties nationally. A value of 90 means the county has a higher median home value than 90 percent of counties. |
| median_home_value_state_pctile | float64 · percent (0–100) | Percentile rank of the county's median home value among counties within the same state. A value of 90 means the county has a higher median home value than 90 percent of in-state counties. |
| mortgage_interest_per_filer | float64 · dollars (nominal) | Average mortgage interest deduction claimed per tax filer who itemized in the county, derived from IRS Statistics of Income data. Higher values indicate greater mortgage debt or higher home values among itemizing filers. |
| pct_filers_itemizing | float64 · percent (0–100) | Share of tax filers in the county who itemized deductions (rather than taking the standard deduction), derived from IRS Statistics of Income data. Higher values may reflect higher home values or greater mortgage prevalence. |
| pct_owners_cost_burdened | float64 · percent (0–100) | Share of owner-occupied households paying 30 percent or more of gross income on housing costs (including mortgage, taxes, and insurance), as estimated by the ACS. Higher values indicate greater ownership affordability stress. |
| pct_owners_cost_burdened_national_pctile | float64 · percent (0–100) | Percentile rank of the county's owner cost-burden rate among all US counties nationally. Higher values indicate a greater share of cost-burdened homeowners relative to most counties. |
| pct_owners_cost_burdened_state_pctile | float64 · percent (0–100) | Percentile rank of the county's owner cost-burden rate among counties within the same state. Higher values indicate relatively more ownership affordability stress within the state. |
| pct_owners_severely_cost_burdened | float64 · percent (0–100) | Share of owner-occupied households paying 50 percent or more of gross income on housing costs, as estimated by the ACS. Higher values indicate severe ownership affordability stress. |
| pct_renters_cost_burdened | float64 · percent (0–100) | Share of renter households paying 30 percent or more of gross income on housing costs, as estimated by the ACS. Higher values indicate greater rental affordability stress. |
| pct_renters_cost_burdened_national_pctile | float64 · percent (0–100) | Percentile rank of the county's renter cost-burden rate among all US counties nationally. Higher values indicate a greater share of cost-burdened renters relative to most counties. |
| pct_renters_cost_burdened_state_pctile | float64 · percent (0–100) | Percentile rank of the county's renter cost-burden rate among counties within the same state. Higher values indicate relatively more rental affordability stress within the state. |
| pct_renters_severely_cost_burdened | float64 · percent (0–100) | Share of renter households paying 50 percent or more of gross income on housing costs, as estimated by the ACS. Higher values indicate severe rental affordability stress. |
| regional_price_parity_national_pctile | float64 · percent (0–100) | Percentile rank of the county's Regional Price Parity among all US counties nationally. Higher values indicate a higher overall price level relative to most counties. |
| regional_price_parity_overall | float64 · index (US average=100) | BEA Regional Price Parity for all goods and services in the county, where 100 represents the national average price level. Values above 100 indicate prices are higher than the national average. |
| regional_price_parity_state_pctile | float64 · percent (0–100) | Percentile rank of the county's Regional Price Parity among counties within the same state. Higher values indicate a higher overall price level relative to in-state peers. |
| rpp_data_year | int64 | Reference year of the Bureau of Economic Analysis Regional Price Parities data used to populate RPP-derived columns in this row. |
| rpp_source | string | Label identifying the source or vintage of the Regional Price Parity estimate (e.g., the BEA release or geographic aggregation method used). |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| vacancy_rate | float64 · percent (0–100) | Share of the total housing stock that is vacant, as estimated by the ACS. Higher values may indicate weak housing demand or an oversupplied market. |
relationships
joins
primary key
county_id
common joins
dim.geographies on county_id
housing_affordability_county_year on (county_id, year)
cost_of_living_scorecard_county on county_id
usage
how to use this table
method
Materialized join of housing tables. 5 ranked metrics get PERCENT_RANK() ranks; 3 stub columns NULL pending raw loads (supply, tenure, vacancy).
do not use for
Time series; mortgage market (HMDA pending); permits (Census Building Permits Survey pending).
known issues
3 of 9 metrics are NULL stubs (supply, tenure, vacancy pending raw load).
last updated · May 5, 2026