economy_scorecard_county
Economy scorecard: one row per county, 39 primary metrics across 10 analytical groups plus 26 ranking columns (national percentile + state rank for 13 HFAW thesis metrics). Includes 9 HFAW industry group shares + 3 AI exposure aggregates from E4. No housing metrics (housing domain is separate).
tier —composite_index
overview
overview
All 3,222 US counties. Aggregates QCEW, BEA, IRS SOI, and CBP into ~30 columns including national and state percentile ranks.
current vintage — 2024 (employment, income); 2023 (CBP); 2022 (IRS SOI)
history — Snapshot only; rebuilt per vintage
provenance
source & licensing
authority
U.S. Bureau of Economic Analysis / U.S. Bureau of Labor Statistics / U.S. Census Bureau
dataset
Regional Personal Income; QCEW; ACS 5-Year Estimates
source url
license
—
citation
U.S. Bureau of Labor Statistics (QCEW) + U.S. Bureau of Economic Analysis (Personal Income, GDP) + U.S. Internal Revenue Service (SOI) + U.S. Census Bureau (CBP).
schema
fields
| name | type | definition |
|---|---|---|
| agg_income_share_top_5pct | float64 · share (0–1) | Fraction of total aggregate household income received by the top 5% of earners in the county. Higher values indicate greater concentration of income at the very top. |
| average_annual_pay | int64 · dollars (nominal) | Average total annual wages and salaries per covered employee. Higher values indicate higher overall compensation levels in the county. |
| charitable_giving_per_filer | float64 · dollars (nominal) | Average charitable contribution deduction per tax filer who itemized. Higher values indicate greater philanthropic activity, though the measure is limited to itemizers and may understate giving among non-itemizers. |
| construction_employment_share | float64 · share (0–1) | Fraction of total county employment in construction industries (NAICS 23). Higher values indicate stronger building and real-estate development activity. |
| 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. |
| economic_concentration_hhi | float64 · index (0–10000) | Herfindahl-Hirschman Index computed over industry employment shares, ranging from 0 (perfectly diversified) to 10,000 (single-industry economy). Higher values indicate a more concentrated, less diversified local economy. |
| economic_concentration_hhi_national_pctile | float64 · percent (0–100) | Percentile rank of the county's HHI among all US counties. Higher values indicate greater industry concentration relative to the national distribution. |
| economic_concentration_hhi_state_pctile | float64 · percent (0–100) | Percentile rank of the county's HHI among counties within the same state. Higher values indicate greater industry concentration relative to in-state peers. |
| education_private_employment_share | float64 · share (0–1) | Fraction of total county employment in private educational services (NAICS 61). Excludes public school employment, which is captured in government sector counts. |
| eitc_claim_rate | float64 · percent (0–100) | Share of tax filers who claimed the Earned Income Tax Credit. Higher values indicate a greater concentration of low-to-moderate income working households in the county. |
| employment_to_population_ratio | float64 · percent (0–100) | Employed workers as a share of the total working-age civilian population. Higher values indicate broader labor market participation. |
| employment_to_population_ratio_national_pctile | float64 · percent (0–100) | Percentile rank of the county's employment-to-population ratio among all US counties. Higher values indicate broader labor market participation relative to the national distribution. |
| employment_to_population_ratio_state_pctile | float64 · percent (0–100) | Percentile rank of the county's employment-to-population ratio among counties within the same state. Higher values indicate broader labor market participation relative to in-state peers. |
| establishments_per_1k_pop | float64 · establishments | Number of business establishments per 1,000 residents. Higher values indicate a denser business environment and greater entrepreneurial activity relative to population. |
| finance_employment_share | float64 · share (0–1) | Fraction of total county employment in finance and insurance industries (NAICS 52). Higher values indicate greater reliance on financial sector jobs. |
| gdp_per_capita | float64 · dollars (chained 2017) | Real GDP divided by the county population. Higher values indicate greater economic output per resident, a proxy for labor productivity and economic development. |
| gdp_per_capita_national_pctile | float64 · percent (0–100) | Percentile rank of the county's real GDP per capita among all US counties. Higher values indicate greater economic output per resident relative to the national distribution. |
| gdp_per_capita_state_pctile | float64 · percent (0–100) | Percentile rank of the county's real GDP per capita among counties within the same state. Higher values indicate greater economic output per resident relative to in-state peers. |
| gini_coefficient | float64 · index (0–1) | A summary measure of income inequality across all households, ranging from 0 (perfect equality) to 1 (maximum inequality). Higher values indicate greater income concentration. |
| gini_coefficient_national_pctile | float64 · percent (0–100) | Percentile rank of the county's Gini coefficient among all US counties. Higher values indicate greater income inequality relative to the national distribution. |
| gini_coefficient_state_pctile | float64 · percent (0–100) | Percentile rank of the county's Gini coefficient among counties within the same state. Higher values indicate greater income inequality relative to in-state peers. |
| healthcare_employment_share | float64 · share (0–1) | Fraction of total county employment in healthcare and social assistance industries (NAICS 62). Higher values indicate a larger health services sector relative to the local economy. |
| hh_income_p20 | int64 · dollars (nominal) | Household income at the 20th percentile — the threshold below which the bottom quintile of households falls. Lower values indicate greater low-end income deprivation. |
| high_or_higher_ai_exposure_share | float64 · share (0–1) | Fraction of county employment in occupations rated as having high or very high AI exposure based on task-level automation assessments. Higher values indicate greater near-term workforce disruption risk from AI adoption. |
| industry_group_data_year | int64 · years | Reference year for the industry employment share and AI exposure data. Used to flag vintage differences when comparing counties across time. |
| investment_share_of_agi | float64 · share (0–1) | Capital gains, dividends, and interest income as a fraction of total adjusted gross income. Higher values indicate a greater role of investment income, often associated with wealthier filer populations. |
| knowledge_economy_employment_share | float64 · share (0–1) | Fraction of total county employment in knowledge-intensive industries such as professional services, information, and finance. Higher values indicate a more skill- and technology-intensive economy. |
| knowledge_economy_employment_share_national_pctile | float64 · percent (0–100) | Percentile rank of the county's knowledge economy employment share among all US counties. Higher values indicate a more skill- and technology-intensive workforce relative to the national distribution. |
| knowledge_economy_employment_share_state_pctile | float64 · percent (0–100) | Percentile rank of the county's knowledge economy employment share among counties within the same state. Higher values indicate a more skill- and technology-intensive workforce relative to in-state peers. |
| large_establishment_share | float64 · share (0–1) | Fraction of all establishments classified as large (typically 500 or more employees). Higher values indicate an economy dominated by large employers rather than small businesses. |
| logistics_retail_employment_share | float64 · share (0–1) | Fraction of total county employment in trade, transportation, and warehousing industries (NAICS 42–49). Higher values indicate a larger goods-movement and retail footprint. |
| manufacturing_employment_share | float64 · share (0–1) | Fraction of total county employment in manufacturing industries (NAICS 31–33). Higher values indicate a more production-oriented local economy. |
| manufacturing_employment_share_national_pctile | float64 · percent (0–100) | Percentile rank of the county's manufacturing employment share among all US counties. Higher values indicate a larger manufacturing presence relative to the national distribution. |
| manufacturing_employment_share_state_pctile | float64 · percent (0–100) | Percentile rank of the county's manufacturing employment share among counties within the same state. Higher values indicate a larger manufacturing presence relative to in-state peers. |
| median_household_income | float64 · dollars (nominal) | The income level at which half of county households earn more and half earn less. Higher values indicate a more affluent median household. |
| median_household_income_national_pctile | float64 · percent (0–100) | Percentile rank of the county's median household income among all US counties nationally. Higher values indicate a more affluent median household relative to the national distribution. |
| median_household_income_state_pctile | float64 · percent (0–100) | Percentile rank of the county's median household income among counties within the same state. Higher values indicate a more affluent median household within the state. |
| medium_or_higher_ai_exposure_share | float64 · share (0–1) | Fraction of county employment in occupations rated as having medium, high, or very high AI exposure. Higher values indicate a broader share of jobs with meaningful AI substitution potential. |
| medium_or_higher_ai_exposure_share_national_pctile | float64 · percent (0–100) | Percentile rank of the county's medium-or-higher AI exposure share among all US counties. Higher values indicate a larger fraction of jobs at risk of AI-driven automation relative to the national distribution. |
| medium_or_higher_ai_exposure_share_state_pctile | float64 · percent (0–100) | Percentile rank of the county's medium-or-higher AI exposure share among counties within the same state. Higher values indicate a larger fraction of jobs at risk of AI-driven automation relative to in-state peers. |
| net_migration_agi_dollars | int64 · dollars (nominal) | Net adjusted gross income associated with IRS-tracked migration flows into minus out of the county. Positive values indicate a net inflow of taxable income from movers, negative values indicate a net outflow. |
| net_migration_irs_filers | int64 · count | Net number of tax filer exemptions moving into minus moving out of the county based on year-over-year IRS address changes. Positive values indicate net in-migration; negative values indicate net out-migration. |
| nonemployer_share_of_workforce | float64 · share (0–1) | Fraction of the workforce composed of nonemployer businesses (sole proprietors and self-employed with no paid employees). Higher values indicate a more freelance- or gig-oriented local economy. |
| pcpi_to_mhi_ratio | float64 · ratio | Per capita personal income divided by median household income. Values above 1 suggest income skew toward high earners, since PCPI is sensitive to top incomes while MHI reflects the typical household. |
| pcpi_to_mhi_ratio_national_pctile | float64 · percent (0–100) | Percentile rank of the county's PCPI-to-MHI ratio among all US counties. Higher values indicate greater income skew toward top earners relative to the national distribution. |
| pcpi_to_mhi_ratio_state_pctile | float64 · percent (0–100) | Percentile rank of the county's PCPI-to-MHI ratio among counties within the same state. Higher values indicate greater income skew toward top earners relative to in-state peers. |
| pct_filers_itemizing | float64 · percent (0–100) | Percentage of tax filers who itemized deductions rather than taking the standard deduction. Higher values generally indicate higher incomes or greater deductible expenses (mortgage interest, property taxes, charitable giving). |
| per_capita_personal_income | float64 · dollars (nominal) | Total personal income received by all residents divided by the county population. Higher values indicate greater average income per resident. |
| per_capita_personal_income_national_pctile | float64 · percent (0–100) | Percentile rank of the county's per capita personal income among all US counties nationally. Higher values indicate relatively higher income compared to the national distribution. |
| per_capita_personal_income_state_pctile | float64 · percent (0–100) | Percentile rank of the county's per capita personal income among counties within the same state. Higher values indicate relatively higher income within the state. |
| personal_local_services_employment_share | float64 · share (0–1) | Fraction of total county employment in personal and local service industries such as accommodation, food service, and other consumer services (NAICS 71–72, 81). Higher values indicate a more service-oriented, locally-anchored economy. |
| population | int64 · count | Total resident population of the county. Higher values indicate larger counties by headcount. |
| predominant_sector | string | Name of the NAICS sector with the largest employment share in the county. Identifies the single industry group that most defines the local economy. |
| predominant_sector_share | float64 · share (0–1) | Employment share of the predominant sector as a fraction of total county employment. Higher values indicate greater dependence on that single sector. |
| real_gdp_thousands_2017 | float64 · thousands of dollars (chained 2017) | Inflation-adjusted gross domestic product for the county, expressed in chained 2017 dollars. Higher values indicate greater total economic output. |
| resource_economy_employment_share | float64 · share (0–1) | Fraction of total county employment in resource-extractive industries including agriculture, forestry, fishing, hunting, and mining (NAICS 11, 21). Higher values indicate greater dependence on natural-resource industries. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| top_to_bottom_quintile_mean_ratio | float64 · ratio | Mean household income of the top quintile divided by mean household income of the bottom quintile. Higher values indicate greater income inequality between the richest and poorest households. |
| top_to_bottom_quintile_mean_ratio_national_pctile | float64 · percent (0–100) | Percentile rank of the county's top-to-bottom quintile income ratio among all US counties. Higher values indicate greater inequality relative to the national distribution. |
| top_to_bottom_quintile_mean_ratio_state_pctile | float64 · percent (0–100) | Percentile rank of the county's top-to-bottom quintile income ratio among counties within the same state. Higher values indicate greater inequality relative to in-state peers. |
| total_employment | int64 · workers | Total number of employed workers residing or working in the county. Higher values indicate a larger labor market. |
| transfer_share_of_agi | float64 · share (0–1) | Government transfer payments (e.g., Social Security, Medicare, unemployment) as a fraction of total adjusted gross income reported on tax returns. Higher values indicate greater dependence on government transfers relative to market income. |
| unemployment_rate | float64 · percent (0–100) | Share of the labor force that is jobless and actively seeking work. Higher values indicate weaker labor market conditions. |
| unemployment_rate_national_pctile | float64 · percent (0–100) | Percentile rank of the county's unemployment rate among all US counties. Higher values indicate worse labor market conditions relative to the national distribution. |
| unemployment_rate_state_pctile | float64 · percent (0–100) | Percentile rank of the county's unemployment rate among counties within the same state. Higher values indicate worse labor market conditions relative to in-state peers. |
| wage_growth_real_5yr_pct | float64 · percent (0–100) | Inflation-adjusted percentage change in average annual pay over the prior five-year period. Positive values indicate real wage gains; negative values indicate wage erosion. |
relationships
joins
primary key
county_id
common joins
dim.geographies on county_id
demographics_scorecard_county on county_id
scorecard_health_county on county_id
usage
how to use this table
method
Materialized join of latest available per-county metrics from underlying economy tables. Percentile columns computed via PERCENT_RANK() over national and within-state partitions.
do not use for
Time series analysis (snapshot only); cross-vintage trend (component vintages differ).
known issues
Mixed vintages within scorecard (2024 employment vs 2022 IRS) - interpret as 'latest available' not 'aligned year'.
← previousus_economy.economy_personal_income_county_yearnext →us_economy.economy_self_employment_county_year
last updated · May 5, 2026