economy_homeownership_finance_county_year
IRS SOI itemizing patterns and mortgage data (G2). Tier A- (itemizer-driven). History 1989-present at source; currently 2022 only.
tier —composite_index
overview
overview
3,142 counties. Itemizer-only sample within IRS SOI.
current vintage — Tax Year 2022
history — IRS SOI: 1989 to present at source; pipeline loads 2022 only
provenance
source & licensing
authority
Federal Housing Finance Agency / U.S. Census Bureau
dataset
House Price Index (HPI); ACS 5-Year Estimates
source url
license
—
citation
U.S. Internal Revenue Service. Statistics of Income (SOI), County-Level Data - mortgage interest and homeownership, Tax Year 2022.
schema
fields
| name | type | definition |
|---|---|---|
| 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. |
| itemized_returns | int64 · count | Number of tax returns in which filers chose to itemize deductions rather than take the standard deduction. |
| mortgage_interest_per_filer | float64 · dollars (nominal) | Average mortgage interest deduction claimed per itemizing filer in the county. Higher values indicate greater average mortgage debt service or higher-value home financing among itemizers. |
| pct_filers_itemizing | float64 · percent (0–100) | Share of total filers who elected to itemize deductions, expressed as a percentage. Higher values indicate a greater proportion of households claiming deductions such as mortgage interest or state and local taxes. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| tax_year | int64 | The calendar year in which the tax returns were filed and reported by the IRS. |
| total_filers | int64 · count | Total number of individual income tax returns filed in the county for the given tax year. |
relationships
joins
primary key
county_id
common joins
dim.geographies on county_id
economy_charitable_giving_county_year on (county_id, year)
housing_tenure_county_year on (county_id, year)
usage
how to use this table
method
Aggregated from individual Form 1040 + Schedule A by county FIPS. Mortgage interest from Schedule A line 8a. Itemizing rate = filers with Schedule A / total returns.
do not use for
Total mortgage interest paid (excludes non-itemizers); homeownership rate (use ACS B25003); pre-TCJA vs post-TCJA comparison without adjustment.
known issues
Post-TCJA (2018+) itemizing rate dropped from ~30% to ~10% - interpret with care.
← previousus_economy.economy_gdp_county_yearnext →us_economy.economy_household_income_distribution_county_year
last updated · May 5, 2026