economy_gdp_county_year
BEA real GDP by county and year, chained 2017 dollars (B1). Tier A-.
overview
3,144 counties x 23 years = 74,184 rows. BEA produces a complete county-level GDP series.
current vintage — 2023 (released December 2024)
history — BEA county GDP: 2001 to present (chained 2017 dollars; rebased periodically)
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. |
| note_ref | string | BEA footnote reference code associated with this data point, if any. Non-null values flag county-year cells with special methodology notes in BEA documentation. |
| real_gdp_thousands_2017 | float64 · thousands of dollars (chained 2017) | Real gross domestic product for the county in thousands of chained 2017 dollars, as reported by the BEA GDP by county series (B1). Higher values indicate greater economic output. |
| state_idkey | string | 2-character FIPS code identifying the state.Part of primary key. Joins dim.states on state_id. |
| unit_label | string | Human-readable label for the unit of measure as provided by the BEA source file (e.g., 'Thousands of chained 2017 dollars'). |
| unit_multiplier | string | Multiplier code from the BEA source indicating the scale of reported values (e.g., 'thousands'). Use alongside unit_label to interpret raw figures. |
| yearkey | int64 | Reference year of the observation.Part of primary key. |
joins
how to use this table
BEA distributes national GDP to counties using QCEW wages and salaries, BEA personal income, and Census of Manufactures data. Chained-dollar series uses Fisher index method to remove inflation.
Sub-county geography; high-frequency tracking (annual only); industry-specific contributions (use CAGDP2, not loaded here); welfare/income comparisons (GDP measures production not residents' incomes).
BEA periodically revises and rebases the chained-dollar series; pre/post revision GDP levels are not directly comparable. County GDP for natural-resource-dominant counties is volatile.