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 |
|---|---|---|
| country_idkey | string | ISO alpha-2 country code (always 'US' for domestic tables).Part of primary key. |
| county_idkey | string | 5-character FIPS code identifying the county.Part of primary key. Joins dim.counties on county_id. |
| county_name | string | Human-readable county name corresponding to county_id. |
| state_idkey | string | 2-character FIPS code identifying the state.Part of primary key. Joins dim.states on state_id. |
| total_population | int64 · count | Total resident population of the county for the year, from Census Population Estimates Program (PEP) vintage 2023. Higher values indicate a more populous county. |
| yearkey | int64 | Reference year of the observation.Part of primary key. |
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.