Housing Affordability Data: What the Numbers Actually Show
Housing affordability is one of the most politically charged topics in local government — and one of the most analytically misunderstood. The phrase gets used constantly in council meetings, planning documents, and community conversations, but the underlying data that should anchor those conversations is rarely examined with precision.
This article cuts explains what housing affordability actually measures, which metrics matter most for local government planning purposes, where to find the most reliable data, and how city analysts and planners can use that data to make better decisions — from comprehensive plan updates to infrastructure capacity planning to grant applications.
What Housing Affordability Actually Measures
Housing affordability is not a single number. It is a relationship — specifically the relationship between what housing costs and what households can afford to pay based on their income.
The most widely used standard is the 30% rule: a household is considered housing cost-burdened if it spends more than 30% of its gross income on housing costs including rent or mortgage, insurance, and utilities. Households spending more than 50% are considered severely cost-burdened. These thresholds, established by the Department of Housing and Urban Development, are the standard benchmarks used in federal grant applications, comprehensive plans, and housing needs assessments across the country.
The critical insight for local government planners is that affordability is always relative to local income levels. A median home price of $300,000 is deeply unaffordable in a city where median household income is $40,000 and reasonably manageable in a city where median household income is $90,000. Reporting home prices without income context produces misleading conclusions — and many public conversations about housing affordability make exactly this mistake.
The Four Key Metrics Every City Planner Should Track
1. Housing Cost Burden Rate
The percentage of households spending more than 30% of income on housing is your primary affordability metric. This data is available at the city, county, and census tract level through the American Community Survey — specifically table B25070 for renters and B25091 for homeowners. Tracking this metric over time and broken out by tenure — renter versus owner — tells you whether affordability is improving or deteriorating in your community and which population is most affected.
The Urban Institute's American Affordability Tracker, updated regularly with data at the state and congressional district level, documents that affordability pressures are spreading beyond traditionally high-cost areas. Many previously low-cost regions including parts of Winston-Salem, Columbus, Louisville, and Nashville are now seeing costs for housing, health care, and groceries rise faster than in other areas — a pattern playing out across much of the South and Midwest as migration from higher-cost regions drives up both housing demand and prices.
2. Price-to-Income Ratio
Divide the median home sale price by the median household income for your city. A ratio below 3.0 is generally considered affordable — meaning a median-priced home costs less than three times the annual median household income. A ratio above 5.0 signals a severe affordability problem. Most financial advisors recommend the 28/36 rule — spending no more than 28% of gross income on housing and no more than 36% on total debt — as a practical household-level benchmark that translates directly into this ratio.
The national median home price reached approximately $419,200 in late 2024 and is forecast to reach $426,000 by mid-2026. At the current national median household income of approximately $83,730, that produces a price-to-income ratio of roughly 5.1 — indicating the national housing market is significantly unaffordable by historical standards. Calculating this ratio for your specific city and tracking it year over year gives you a single comparable number that is easy to communicate to council members and residents alike.
3. Rental Vacancy Rate
A rental vacancy rate below 5% indicates a tight rental market where landlords have significant pricing power and renters have limited alternatives. A rate above 8% suggests sufficient supply. This metric matters for affordability analysis because rental market tightness is the primary driver of rent increases — and renters are disproportionately represented among cost-burdened households in most American cities.
HUD User publishes fair market rents annually at the metropolitan area level, and the Census Bureau's ACS provides vacancy rate data at the city and census tract level. Together these two sources give planners a picture of both the supply constraint and the pricing outcome in the local rental market.
4. New Housing Permits Relative to Population Growth
The most forward-looking affordability metric is the relationship between new housing construction and population growth. A city adding residents faster than it is adding housing units is building toward an affordability crisis — regardless of what current price levels look like. A city adding housing faster than residents are arriving will generally see prices moderate over time.
Building permit data is available monthly from the Census Bureau's Building Permits Survey, broken down by unit type — single family, multifamily, and manufactured housing. For a local government analyst, tracking permit activity alongside water service connection applications provides a real-time picture of housing supply growth that Census population estimates will not reflect for another five years. Every new housing development requires a water service account — which means a utility billing department's new account creation rate is actually one of the most current leading indicators of housing growth available at the local level.
The North Carolina Growth Story — A Case Study in Affordability Complexity
North Carolina illustrates the complexity of housing affordability data as well as any state in the country right now. The state's economy is strong by almost any measure — job growth, business formation, population growth, and quality of life rankings consistently place North Carolina among the top performing states. Cities like Raleigh have been identified as among the top emerging job markets in the country, with strong openings in healthcare, technology, and logistics.
But strong economic performance and housing affordability are not the same thing — and in many North Carolina communities they are actively in tension. The same job growth and quality of life advantages that attract new residents and businesses also drive up housing costs, often faster than local incomes grow. The result is a paradox familiar to local government planners across the Sun Belt: a thriving regional economy that increasingly squeezes the long-term residents — particularly those on fixed incomes, renters, and essential workers — who helped build that community in the first place.
This dynamic is not unique to North Carolina. Markets that saw excessive appreciation relative to job growth or local income levels now face more headwinds as affordability tightens, while regions with steadier demand relative to supply tend to retain stronger fundamentals. For local government planners, the practical implication is that affordability analysis cannot focus only on current prices — it must account for the rate of change in both housing costs and local income levels, and whether those two trajectories are converging or diverging. Riskwire
Where to Find Housing Affordability Data
For city planners and data analysts who need reliable, free, regularly updated housing data, these are the most useful sources:
American Community Survey (Census Bureau)
The ACS five-year estimates provide housing cost burden rates, median home values, median gross rents, and vacancy rates at the city and census tract level. Tables B25070, B25091, B25077, and B25064 cover the core housing metrics. The most recent 2020-2024 five-year estimates were released in January 2026 and are the most comprehensive small-area housing dataset currently available.
HUD User
The Department of Housing and Urban Development's research platform publishes fair market rents, housing affordability indexes, income limits for affordable housing programs, and the Comprehensive Housing Affordability Strategy data — which provides city and county level estimates of housing needs broken out by income category and tenure. This is the standard data source for federal housing grant applications.
FRED — Federal Reserve Bank of St. Louis
The Federal Reserve's free economic data platform publishes the Housing Affordability Index at the national and metropolitan level, updated monthly. The index measures whether a median-income family can qualify for a mortgage on a median-priced home under current interest rate conditions. As of mid-2026 the index reflects the combined effect of elevated home prices and mortgage rates that have remained above 6% — significantly constraining affordability compared to the historically low rate environment of 2020-2021.
National Association of Realtors
NAR publishes a quarterly Housing Affordability Index at the metropolitan area level that tracks the relationship between median home prices, median household income, and prevailing mortgage rates. The next quarterly release is scheduled for August 4, 2026. While NAR is a trade organization with a perspective on housing markets, its affordability index methodology is transparent and widely used in planning documents and policy analysis.
Building Permits Survey (Census Bureau)
Monthly building permit data at the city level, available at census.gov, provides the most current indicator of new housing supply entering the market. For analysts tracking housing growth in fast-growing communities, this data combined with local water service connection records provides a real-time supply monitoring capability that Census population estimates cannot match.
Urban Institute American Affordability Tracker
A newer tool providing timely data on housing costs, energy costs, transportation costs, and healthcare costs by state and congressional district — with trend data that shows where cost pressures are accelerating faster than in other areas. Particularly useful for equity-focused affordability analysis.
How Local Government Can Use This Data
Comprehensive Plan Updates
Housing affordability data from the ACS and HUD User provides the demographic and market foundation for the housing element of a comprehensive plan. Cost burden rates by census tract identify which neighborhoods face the most acute affordability pressure. Price-to-income ratios establish whether the overall market is accessible to the median household. Building permit trends indicate whether supply is keeping pace with demand.
Infrastructure Capacity Planning
New housing development creates immediate infrastructure demand — water service connections, sewer capacity, road network impact, stormwater management. A city that tracks building permit trends alongside its utility new account creation rate has an early warning system for infrastructure strain that planning departments relying solely on periodic comprehensive plan updates will miss. The relationship between housing growth and water demand is direct and quantifiable — and Census population projections combined with local permit and connection data give utility planners a more complete picture than either source provides alone.
Grant Applications
Federal housing and community development grants — including Community Development Block Grants, HOME Investment Partnerships Program funds, and HUD Continuum of Care grants — consistently require applicants to document local housing needs using ACS cost burden data, HUD income limits, and fair market rent figures. A city analyst who knows how to pull and format these datasets correctly has a significant advantage in the grant application process over one relying on outdated or general figures.
Equity Analysis
Housing cost burden is not evenly distributed across income levels, age groups, racial and ethnic groups, or geographic areas within a city. ACS data broken down to the census tract level allows planners to identify which specific neighborhoods and populations face the greatest affordability stress — and to make the case for targeted policy interventions with data rather than anecdote.
What the Data Cannot Tell You
Housing affordability data is powerful but incomplete. It measures outcomes — what housing costs relative to incomes — but it does not by itself explain causes or prescribe solutions. Two cities with identical cost burden rates may have arrived there through entirely different paths and require entirely different policy responses.
The data also lags. The most current ACS five-year estimates reflect conditions from 2020 to 2024. In a fast-moving market, conditions on the ground today may diverge significantly from what the most recent published data shows. Local administrative data — building permits, utility connections, tax assessment records — fills some of that gap but requires more analytical work to interpret.
And perhaps most importantly, affordability data captures the average experience of the median household. The residents most severely affected by affordability crises — those on fixed incomes, those in the lowest income quintiles, those with housing instability — are often underrepresented in survey-based datasets. Pairing Census data with local social services data, utility assistance program enrollment, and eviction filing records gives a more complete picture of affordability stress than any single federal dataset can provide.
Final Thoughts
Housing affordability is one of those topics where the gap between public conversation and underlying data is consistently large. Prices are rising — that much is true almost everywhere. But the policy implications depend enormously on why they are rising, at what rate relative to local incomes, in which neighborhoods, affecting which populations, and whether current supply trends suggest the pressure will ease or intensify.
The data sources to answer those questions are free, regularly updated, and accessible to any local government analyst willing to learn how to navigate them. The ACS, HUD User, FRED, and NAR together cover the core metrics. Local permit and utility connection data fills the real-time gap. And the analytical framework — tracking cost burden rates, price-to-income ratios, vacancy rates, and supply trends together rather than in isolation — gives planners and data analysts the complete picture that housing conversations in most cities sorely need.
Once you have the data, the next step is turning it into a dashboard your leadership team can actually use.
Ready to build dashboards for your department?
The Local Government Dashboard Template Pack includes three Excel dashboards built specifically for city analysts and utility managers — call center performance, utility billing, and public works service requests. Each template comes pre-loaded with fictional data so you can see it working immediately.
