Population, Jobs, and Supply: Data Framework for Market Entry
A reproducible data set for evaluating a market from free public sources — which series to pull, at what geography, and the three ratios that do most of the work.
Everything you need to evaluate a market's fundamentals is published free by the federal government. The difficulty is not access — it is knowing which series, at which geography, and what to divide by what.
This is the reproducible version: the same pulls, in the same order, every time, so changes in the output reflect the market rather than a change in your method.
Get the geography right first
This decision matters more than any individual series, and it is where most amateur market analysis goes wrong.
- Metropolitan Statistical Area (MSA) — the right unit for labour markets and migration. People commute across county lines; employment data at the county level will mislead you in a multi-county metro.
- County — the right unit for permits, property tax and most public records. Also the finest geography with reliable annual population estimates.
- Census tract or ZIP — the right unit for demographics and income at submarket level, but the sampling error on small-area estimates is large. Use for texture, not for decisions.
A common error is mixing them: MSA job growth against county permits against tract-level income, producing ratios that mean nothing. Pick a level per question and be consistent.
Layer 1: Population and households
What to pull
| Series | Source | Geography |
|---|---|---|
| Population estimates, annual | Census Population Estimates | County, MSA |
| Components of change: net domestic migration, net international migration, natural increase | Census PEP components | County |
| Households and household size | American Community Survey | County, tract |
| Age distribution | ACS | County |
What matters
Households, not people. A household rents a unit. A market adding population through larger household sizes adds fewer renters than the headline suggests.
Components, not the total. Population growth from natural increase is not the same as growth from net domestic in-migration. The first is demographic momentum; the second is a revealed preference for the market and is the more meaningful signal.
Pull five years, not one. Single-year estimates are noisy at county level, and one good year is not a trend.
Layer 2: Employment and income
What to pull
| Series | Source | Geography |
|---|---|---|
| Total employment, monthly | BLS State and Area Employment | MSA |
| Employment by sector (NAICS) | BLS QCEW | County, MSA |
| Average weekly wages | BLS QCEW | County |
| Unemployment rate | BLS LAUS | County, MSA |
| Median household income | ACS | County, tract |
What matters
Sector concentration. Compute each sector's share of total employment. A market where one sector exceeds roughly a quarter of employment carries concentration risk that a headline growth rate hides entirely. Model that sector contracting.
Employer concentration inside the sector. Public data will not name the employer; local economic development authorities and news coverage will. In small metros, one hospital system, one university, one base or one plant frequently is the sector.
Wage growth versus rent growth. If rents have grown faster than wages for several years, the market has been consuming its affordability cushion. Rent-to-income above roughly 30% at the median is where resistance and delinquency start showing up.
Layer 3: Supply
The layer most often skipped, and the one that most reliably explains disappointing outcomes.
What to pull
| Series | Source | Geography |
|---|---|---|
| Building permits, units, monthly | Census Building Permits Survey | County, MSA |
| Permits split single-family vs multifamily (5+) | Census BPS | County |
| Housing units total | ACS | County |
| Rental vacancy | Census Housing Vacancy Survey | MSA, state |
What matters
Permits per 1,000 households, against that market's own ten-year average and against household formation. This single ratio does more work than any other number in the framework.
The multifamily split. A market permitting heavily in single-family and lightly in multifamily is a different competitive picture from the reverse.
The lag. A permit today is a delivery in 18–30 months for multifamily. You are not underwriting today's supply; you are underwriting what has already been approved and is coming.
The three ratios that do most of the work
Everything above condenses into three numbers. Compute them for every market on your list and compare across markets, not in isolation.
1. Household formation ÷ permitted units
Above 1.0, demand exceeds new supply. Below 1.0, you are competing with new product. Compute over a trailing three years to smooth permit lumpiness.
2. Employment growth ÷ national employment growth
Above 1.0, the market is outperforming. Below 1.0, whatever else is true, it is losing relative ground.
3. Median rent ÷ median household income
The affordability ceiling. Rising toward and past 30% means future rent growth faces resistance regardless of demand.
Free versus paid data
The federal series above will tell you whether a market is growing, whether supply is responding, and whether affordability has room. That is most of the market-selection decision.
What they will not give you is submarket-level asking rents, concessions and absorption, which is where commercial data providers earn their fee. Two practical substitutes: listing observation over time, which is tedious and genuinely informative, and property managers, who will usually tell you what is actually leasing if you ask specifically.
Cadence and discipline
- Refresh monthly for permits and employment, which update monthly.
- Refresh annually for population and ACS.
- Keep the same pull order every time, and timestamp the file.
- Record the value and the date, so you can see the direction later. The level tells you where a market is; the trend tells you where it is going, and only the second one is actionable.
What to do next
- Convert the data into a comparable ranking with how to score secondary cities for rental demand.
- Check it against the qualitative indicators in 12 signals a secondary city is entering a growth window.
- See the wider source list in top 10 data sources for emerging market underwriting.
- Format it for committee with the emerging market scorecard template for investment committees.
Sources
Related Resources
1031 Exchange vs Capital Recycling for Portfolio Reallocation
The 45-day identification clock is a much harder constraint in a thin market. When deferring the tax is worth the deadline risk, and the three alternatives.
Best Rebalancing Models for Multi-Market CRE Portfolios
Real estate cannot be rebalanced like a stock portfolio — you cannot sell 8% of a building. Three models that work within that constraint, and when each applies.
Exit and Rebalancing Strategy for Emerging Market Portfolios
Most portfolios have an acquisition strategy and no exit strategy. Writing the sell criteria at purchase, and the sequence that follows when they trigger.
Get Real Estate Insights
Join other investors receiving actionable strategies and market analysis