economy_tax_filer_income_county_year
IRS SOI full line-item view: filer counts, income concepts, deductions, credits (A3). Tier A- (filer-only). History 1989-present at source; currently 2022 only.
tier —admin_record
overview
overview
3,142 counties. IRS SOI full line-item view of tax-filing population.
current vintage — Tax Year 2022
history — IRS SOI: 1989 to present at source; pipeline loads 2022 only
provenance
source & licensing
authority
U.S. Internal Revenue Service
dataset
Statistics of Income (SOI) County-Level Data
license
—
citation
U.S. Internal Revenue Service. Statistics of Income (SOI), County-Level Data - full line items, Tax Year 2022.
schema
fields
| name | type | definition |
|---|---|---|
| agi_per_filer | float64 · dollars (nominal) | Average adjusted gross income per tax return filed, in nominal dollars. Computed as agi_thousands × 1000 ÷ total_filers. Higher values indicate greater average income. |
| agi_thousands | int64 · thousands of dollars | Aggregate adjusted gross income across all filers in the county, in thousands of nominal dollars. Higher values indicate greater total reported income. |
| business_income_thousands | float64 · thousands of dollars | Aggregate net business income or loss from sole proprietorships (Schedule C) reported across returns, in thousands of nominal dollars. Positive values indicate net profit; negative values indicate net loss. |
| charitable_contributions_thousands | float64 · thousands of dollars | Aggregate charitable contribution deductions claimed across itemized returns, in thousands of nominal dollars. Higher values indicate greater philanthropic giving among filers. |
| 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. |
| efiled_returns | int64 · count | Number of returns submitted electronically rather than by paper. Higher values indicate greater adoption of electronic filing. |
| eitc_returns | int64 · count | Number of returns claiming the Earned Income Tax Credit. Higher values indicate a greater concentration of lower-to-moderate income working households. |
| filers_per_capita | float64 · rate per 100k | Number of tax filers per 100,000 residents in the county. Useful for comparing filing rates across counties of different sizes. |
| hoh_returns | int64 · count | Number of returns filed with head-of-household filing status. A subset of total_filers. |
| itemized_returns | int64 · count | Number of returns on which filers chose to itemize deductions rather than take the standard deduction. A subset of total_filers. |
| joint_returns | int64 · count | Number of returns filed as married filing jointly. A subset of total_filers. |
| mortgage_interest_thousands | float64 · thousands of dollars | Aggregate mortgage interest deduction claimed across itemized returns, in thousands of nominal dollars. Higher values reflect greater homeownership and mortgage debt levels. |
| ordinary_dividends_thousands | float64 · thousands of dollars | Aggregate ordinary dividend income reported across returns, in thousands of nominal dollars. Includes both qualified and non-qualified dividends. |
| salaries_wages_thousands | float64 · thousands of dollars | Aggregate wages, salaries, and tips reported on returns in the county, in thousands of nominal dollars. Represents the largest income component for most filers. |
| single_returns | int64 · count | Number of returns filed with single filing status. A subset of total_filers. |
| social_security_thousands | float64 · thousands of dollars | Aggregate taxable Social Security benefits reported across returns, in thousands of nominal dollars. Only the taxable portion of benefits is included. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| tax_exempt_interest_thousands | float64 · thousands of dollars | Aggregate tax-exempt interest income (e.g., from municipal bonds) reported across returns, in thousands of nominal dollars. Not included in AGI but reported for informational purposes. |
| tax_year | int64 | Tax filing year for which the IRS Statistics of Income data were reported. Identifies the annual period covered by the returns in this row. |
| taxable_interest_thousands | float64 · thousands of dollars | Aggregate taxable interest income reported across returns, in thousands of nominal dollars. Includes interest from bank accounts, bonds, and other taxable instruments. |
| total_filers | int64 · count | Total number of individual income tax returns filed in the county for the tax year. Higher values indicate a larger tax-filing population. |
| total_income_thousands | float64 · thousands of dollars | Sum of all income line items reported across returns before certain above-the-line deductions, in thousands of nominal dollars. May exceed AGI due to inclusion of excluded items. |
| unemployment_comp_thousands | float64 · thousands of dollars | Aggregate unemployment compensation reported as taxable income across returns, in thousands of nominal dollars. Higher values may reflect elevated joblessness in the county during the tax year. |
relationships
joins
primary key
county_id
common joins
dim.geographies on geo_id
economy_household_income_distribution_county_year on (county_id, year)
economy_income_composition_county_year on (county_id, year)
usage
how to use this table
method
Aggregated Form 1040 line items by 5-digit county FIPS. Includes filer counts, AGI, salaries, business income, investment income, deductions, credits.
do not use for
Non-filer households (~10-15%); income below filing threshold; pre-tax compensation (line items reflect post-deduction definitions).
known issues
Filer-only. SOI suppresses small-county detail. Post-TCJA itemizing changes affect related fields.
← previousus_economy.economy_self_employment_county_yearnext →us_economy.economy_unemployment_county_year
last updated · May 5, 2026