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 a-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. Internal Revenue Service|U.S. Census Bureau
dataset
BEA REIS + BLS QCEW/LAUS + IRS SOI + Census ACS/CBP/Nonemployer
source url
license
Public domain (U.S. Federal Government work)
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 |
|---|---|---|
| average_annual_pay | int64 · dollars (nominal) | Mean annual wages and salaries per covered employee. Higher values indicate higher average compensation for workers in the county. |
| charitable_giving_per_filer | float64 · dollars (nominal) | Total charitable contributions claimed by itemizing filers divided by all filers. Higher values indicate greater average philanthropic giving per household in the county. |
| construction_employment_share | float64 · share (0–1) | Construction industry employment as a share of total county employment (HFAW industry group). Higher values may reflect active development cycles or persistent construction-sector reliance. |
| 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. |
| economic_concentration_hhi | float64 · index (0–1) | Herfindahl-Hirschman Index calculated from industry employment shares (Σsᵢ²), where 0 = perfectly diversified and 1 = entirely concentrated in one sector. Higher values indicate greater economic dependence on a single industry. |
| economic_concentration_hhi_national_pctile | float64 · percent (0–100) | National percentile rank of the county's HHI economic concentration index. Higher values indicate greater industry concentration relative to other counties nationally (higher rank = less diversified). |
| economic_concentration_hhi_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's HHI economic concentration index. Higher values indicate greater industry concentration relative to other counties in the same state. |
| education_private_employment_share | float64 · share (0–1) | Private educational services employment as a share of total county employment (HFAW industry group). Higher values indicate a larger private education sector, such as universities or private K–12 institutions. |
| eitc_claim_rate | float64 · percent (0–100) | Percentage of tax filers who claimed the Earned Income Tax Credit. Higher values indicate a greater share of low-to-moderate-income working households receiving this wage subsidy. |
| employment_to_population_ratio | float64 · percent (0–100) | Employed persons as a percentage of the civilian noninstitutional population. Higher values indicate broader labor force participation and stronger attachment to work. |
| employment_to_population_ratio_national_pctile | float64 · percent (0–100) | National percentile rank of the county's employment-to-population ratio. Higher values indicate broader labor force participation relative to other counties nationally. |
| employment_to_population_ratio_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's employment-to-population ratio. Higher values indicate broader labor force participation relative to other counties in the same state. |
| establishments_per_1k_pop | float64 · establishments per 1,000 residents | Number of business establishments divided by population (per 1,000). Higher values indicate a denser business environment and greater entrepreneurial activity relative to population size. |
| finance_employment_share | float64 · share (0–1) | Finance, insurance, and real estate employment as a share of total county employment (HFAW industry group). Higher values indicate greater reliance on financial sector jobs. |
| gdp_per_capita | float64 · dollars (chained 2017) | Real GDP divided by county resident population, providing an inflation-adjusted measure of average economic output per person. Higher values indicate greater productivity or output per resident. |
| gdp_per_capita_national_pctile | float64 · percent (0–100) | National percentile rank of the county's real GDP per capita. Higher values indicate greater economic output per resident relative to other counties nationally. |
| gdp_per_capita_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's real GDP per capita. Higher values indicate greater economic output per resident relative to other counties in the same state. |
| gini_coefficient | float64 · index (0–1) | Standard Gini coefficient measuring income inequality across all households, where 0 = perfect equality and 1 = perfect inequality. Higher values indicate greater dispersion of income. |
| gini_coefficient_national_pctile | float64 · percent (0–100) | National percentile rank of the county's Gini coefficient. Higher values indicate greater income inequality relative to other counties nationally. |
| gini_coefficient_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's Gini coefficient. Higher values indicate greater income inequality relative to other counties in the same state. |
| healthcare_employment_share | float64 · share (0–1) | Healthcare and social assistance employment as a share of total county employment (HFAW industry group). Higher values indicate a larger healthcare sector, which can reflect both an aging population and institutional health employment anchors. |
| hh_income_p20 | int64 · dollars (nominal) | Household income at the 20th percentile — the threshold below which the lowest-income quintile falls. Higher values indicate greater income floor for low-income households. |
| high_or_higher_ai_exposure_share | float64 · share (0–1) | Share of county employment in occupations rated 'high' or above on the E4 AI exposure index. Higher values indicate a larger fraction of jobs with significant potential for AI-driven task displacement or augmentation. |
| industry_group_data_year | int64 | Reference year for the industry group employment share and AI exposure columns. Identifies the vintage of the underlying employment data used to compute sector shares. |
| investment_share_of_agi | float64 · share (0–1) | Capital gains, dividends, and interest income as a share of total adjusted gross income. Higher values indicate that investment income is a larger component of the local income base, often correlated with wealthier populations. |
| knowledge_economy_employment_share | float64 · share (0–1) | Knowledge-economy industries (e.g., professional services, tech, information) as a share of total county employment (HFAW industry group). Higher values indicate greater concentration of high-skill, high-wage sectors. |
| knowledge_economy_employment_share_national_pctile | float64 · percent (0–100) | National percentile rank of the county's knowledge-economy employment share. Higher values indicate a larger concentration of high-skill sectors relative to other counties nationally. |
| knowledge_economy_employment_share_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's knowledge-economy employment share. Higher values indicate a larger concentration of high-skill sectors relative to other counties in the same state. |
| large_establishment_share | float64 · share (0–1) | Share of total establishments classified as large (typically 500+ employees). Higher values indicate that employment is concentrated in a small number of large firms rather than distributed across small businesses. |
| logistics_retail_employment_share | float64 · share (0–1) | Logistics, transportation, warehousing, and retail trade employment as a share of total county employment (HFAW industry group). Higher values indicate greater reliance on goods-movement and consumer-facing commerce jobs. |
| manufacturing_employment_share | float64 · share (0–1) | Manufacturing industry employment as a share of total county employment (HFAW industry group). Higher values indicate a more manufacturing-dependent local economy. |
| manufacturing_employment_share_national_pctile | float64 · percent (0–100) | National percentile rank of the county's manufacturing employment share. Higher values indicate a larger manufacturing sector relative to other counties nationally. |
| manufacturing_employment_share_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's manufacturing employment share. Higher values indicate a larger manufacturing sector relative to other counties in the same state. |
| 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 prosperous middle of the income distribution. |
| median_household_income_national_pctile | float64 · percent (0–100) | National percentile rank of the county's median household income among all US counties. Higher values indicate the county ranks above more counties nationally on this measure. |
| median_household_income_state_pctile | float64 · percent (0–100) | Percentile rank of the county's median household income within its state. Higher values indicate the county ranks above more in-state counties on this measure. |
| medium_or_higher_ai_exposure_share | float64 · share (0–1) | Share of county employment in occupations rated 'medium' or above on the E4 AI exposure index. Higher values indicate broader workforce exposure to AI-related labor market change relative to the high-only threshold. |
| medium_or_higher_ai_exposure_share_national_pctile | float64 · percent (0–100) | National percentile rank of the county's medium-or-higher AI exposure share. Higher values indicate broader workforce AI exposure relative to other counties nationally. |
| medium_or_higher_ai_exposure_share_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's medium-or-higher AI exposure share. Higher values indicate broader workforce AI exposure relative to other counties in the same state. |
| nonemployer_share_of_workforce | float64 · share (0–1) | Nonemployer establishments (sole proprietors and self-employed with no paid employees) as a share of total workforce. Higher values indicate a greater prevalence of gig, freelance, or solo-operator work arrangements. |
| pcpi_to_mhi_ratio | float64 · ratio | Per capita personal income divided by median household income. Values above 1.0 suggest the distribution is skewed upward by high earners; values below 1.0 suggest most income is earned in multi-person households. |
| pcpi_to_mhi_ratio_national_pctile | float64 · percent (0–100) | National percentile rank of the county's per capita personal income to median household income ratio. Higher values indicate a more top-heavy income distribution relative to other counties nationally. |
| pcpi_to_mhi_ratio_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's PCPI-to-MHI ratio. Higher values indicate a more top-heavy income distribution relative to other counties in the same state. |
| 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-income filer populations with larger mortgage interest, state/local tax, or charitable deduction amounts. |
| per_capita_personal_income | float64 · dollars (nominal) | Bureau of Economic Analysis personal income divided by county resident population. Higher values indicate greater average income received per resident, including wages, proprietors' income, and transfer payments. |
| per_capita_personal_income_national_pctile | float64 · percent (0–100) | National percentile rank of the county's per capita personal income among all US counties. Higher values indicate the county ranks above more counties nationally on this measure. |
| per_capita_personal_income_state_pctile | float64 · percent (0–100) | Percentile rank of the county's per capita personal income within its state. Higher values indicate the county ranks above more in-state counties on this measure. |
| personal_local_services_employment_share | float64 · share (0–1) | Personal and local services employment (e.g., food service, hospitality, personal care) as a share of total county employment (HFAW industry group). Higher values indicate greater dependence on lower-wage, locally consumed service work. |
| population | int64 · count | Total resident population of the county. Used as the denominator for per-capita and rate calculations throughout the scorecard. |
| predominant_sector | string | Name of the industry sector with the largest employment share in the county. Identifies the single largest employer group among the nine HFAW industry groupings. |
| predominant_sector_share | float64 · share (0–1) | Employment share of the predominant sector. Higher values indicate greater economic reliance on that single sector. |
| real_gdp_thousands_2017 | float64 · thousands of dollars (chained 2017) | Total real gross domestic product produced in the county, expressed in inflation-adjusted chained 2017 dollars. Higher values indicate greater overall economic output. |
| resource_economy_employment_share | float64 · share (0–1) | Resource-extraction industries (agriculture, mining, forestry, fishing) as a share of total county employment (HFAW industry group). Higher values indicate greater dependence on natural-resource-based economic activity. |
| state_idkey | string | 2-character FIPS code identifying the state.Part of primary key. Joins dim.states on state_id. |
| top_to_bottom_quintile_mean_ratio | float64 · ratio | Mean income of the top quintile divided by mean income of the bottom quintile. Higher values indicate greater income inequality between the top and bottom fifths of the distribution. |
| top_to_bottom_quintile_mean_ratio_national_pctile | float64 · percent (0–100) | National percentile rank of the county's top-to-bottom quintile ratio. Higher values indicate greater inequality relative to other counties nationally (higher rank = more unequal). |
| top_to_bottom_quintile_mean_ratio_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's top-to-bottom quintile ratio. Higher values indicate greater inequality relative to other counties in the same state. |
| total_employment | int64 · workers | Total number of employed persons in the county, typically measured as jobs (place-of-work basis). Higher values indicate a larger labor market. |
| transfer_share_of_agi | float64 · share (0–1) | Government transfer payments (Social Security, Medicare, unemployment, etc.) as a share of total adjusted gross income reported to the IRS. Higher values indicate greater income dependence on government transfers relative to market income. |
| unemployment_rate | float64 · percent (0–100) | Share of the civilian labor force that is jobless and actively seeking work. Higher values indicate weaker labor market conditions. |
| unemployment_rate_national_pctile | float64 · percent (0–100) | National percentile rank of the county's unemployment rate. Higher values indicate a higher unemployment rate relative to other counties nationally (higher rank = worse labor market conditions). |
| unemployment_rate_state_pctile | float64 · percent (0–100) | Within-state percentile rank of the county's unemployment rate. Higher values indicate a higher unemployment rate relative to other counties in the same state. |
relationships
joins
primary key
county_id, state_id, country_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_poverty_county_yearnext →us_economy.economy_self_employment_county_year
last updated · Jul 7, 2026