demographics_population_county_year
Census PEP county population estimates (A1). Single year (2023), total only. Annual time series and components-of-change blocked on PEP re-pull. Tier A-.
overview
All 3,222 US counties + DC + PR. PEP is a complete administrative model - every county has an estimate.
current vintage — Vintage 2023 (July 1, 2023 reference)
history — PEP from 1969 forward; current load is 2023 only - annual time series and components-of-change blocked on re-pull
source & licensing
fields
| name | type | definition |
|---|---|---|
| births | int64 · count | Number of live births occurring to residents of the county during the reference year. Higher values reflect greater natural population increase from fertility. |
| 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. |
| deaths | int64 · count | Number of deaths among residents of the county during the reference year. Higher values reflect greater natural population decrease from mortality. |
| net_domestic_migration | int64 · count | Net movement of people into or out of the county from other U.S. counties during the reference year, calculated as in-migrants minus out-migrants. Positive values indicate net domestic population gain. |
| net_international_migration | int64 · count | Net movement of people into or out of the county from foreign countries during the reference year, calculated as in-migrants minus out-migrants. Positive values indicate net international population gain. |
| population_change_5yr_pct | float64 · percent (0–100) | Percentage change in total population over the five-year period ending in the reference year. Positive values indicate sustained growth; negative values indicate sustained decline. |
| population_change_yoy_pct | float64 · percent (0–100) | Percentage change in total population from the prior year to the reference year. Positive values indicate population growth; negative values indicate decline. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| total_population | int64 · count | Total resident population of the county as of the reference year. Higher values indicate larger population size. |
| yearkey | int64 | Reference year of the observation. |
joins
how to use this table
PEP starts from decennial baseline and rolls forward by adding births, subtracting deaths, and adding net migration (domestic + international) using administrative records.
Sub-county estimates (use ACS); racial/age detail (current load is total only - pending re-pull); years before decennial baseline change without bridging.
Currently single-year (2023) and total-only. Annual time series and components of change pending PEP re-pull.