economy_income_composition_county_year
Four income-source shares (salaries, business, investment, transfers) from IRS SOI (A4). Tier A- (filer-only). History 1989-present at source; currently 2022 only. Powers transfer_share and investment_share in scorecard.
overview
3,142 counties. Filer-based - captures only tax-filing population.
current vintage — Tax Year 2022
history — IRS SOI: 1989 to present at source; pipeline loads 2022 only
source & licensing
fields
| name | type | definition |
|---|---|---|
| business_share_of_agi | float64 · share (0–1) | Net business income (self-employment, partnerships, S-corporations) as a share of total AGI among tax filers, sourced from IRS SOI Table A4. Higher values indicate greater entrepreneurial or self-employment activity. |
| 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. |
| investment_share_of_agi | float64 · share (0–1) | Investment income (dividends, capital gains, taxable interest) as a share of total AGI among tax filers, sourced from IRS SOI Table A4. Higher values indicate greater concentration of wealth-derived income. |
| salaries_share_of_agi | float64 · share (0–1) | Wages and salaries as a share of total Adjusted Gross Income among tax filers, sourced from IRS SOI Table A4. Higher values indicate greater dependence on wage employment income. |
| state_idkey | string | 2-character FIPS code identifying the state.Part of primary key. Joins dim.states on state_id. |
| tax_year | int64 | IRS tax year for which income was reported. Matches the calendar year of income earned; filing occurs in the following year. |
| transfer_share_of_agi | float64 · share (0–1) | Transfer payments reported on returns (Social Security benefits, unemployment compensation) as a share of total AGI among tax filers, sourced from IRS SOI Table A4. Higher values indicate greater reliance on government transfer income. |
joins
how to use this table
Aggregated Form 1040 line items: salaries (line 1), business income (lines 3, 7-8), investment income (lines 2-6, 9), transfers (proxied via SS taxable line 6, unemployment line 7). Shares = each / AGI.
Non-filer transfer income (~10-15% of population); means-tested transfers without filing requirement (SNAP, Medicaid); pre-tax labor income (this is post-deduction).
Filer-only - does not capture income for households below filing threshold. Post-2018 itemization changes affect interpretation.