Variable pages · IRS 990 Master Concordance

SR_01_DISREG_ENTITY_ADDR_STATE

Disregarded entity state

Description
Province or state
Table
SR-P01-T01-ID-DISREGARDED-ENTITIES (many)
Part
Part I - Identification of Disregarded Entities
Location
SCHED-R-PART-01-COL-A
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
6 / 6
xpaths observed / mapped
116k
filings with a value
2009–2024
tax years observed
0 + 4 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
▲ warnSmall code listup to 101 distinct values per xpath and year
✓ passCodes share one format99% have the shape AA
✓ passConsistent letter case0.0% of values are lower case

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleR/IdDisregardedEntitiesGrp/ForeignAddress/ProvinceOrStateNm411 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdDisregardedEntitiesGrp/ForeignAddress/ProvinceOrStateNm ; /Return/ReturnData/IRS990ScheduleR/IdDisregardedEntitiesGrp/USAddress…✓ accepted
noteFalse positive: counted per filing. Recounted per repeating-element row in the TY2012 and TY2019 DuckDB builds: 0 rows hold both the US and the foreign address xpath (different rows of the table hold different address types). build_evidence() now counts collisions per row.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleR/IdDisregardedEntitiesGrp/USAddress/StateAbbreviationCdmany-to-one table, but 58% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 41.7% of 94,365 filings, max 1024/filing, TY2014-2024; repeat_root: ''=58% ; IRS990ScheduleR/IdDisregardedEntitiesGrp=42%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleR/Form990ScheduleRPartI/AddressUS/Statemany-to-one table, but 58% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 41.7% of 15,198 filings, max 187/filing, TY2009-2012; repeat_root: ''=58% ; IRS990ScheduleR/Form990ScheduleRPartI=42%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleR/IdDisregardedEntitiesGrp/USAddress/Statemany-to-one table, but 58% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 41.6% of 5,674 filings, max 187/filing, TY2013-2013; repeat_root: ''=58% ; IRS990ScheduleR/IdDisregardedEntitiesGrp=42%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleR/Form990ScheduleRPartI/AddressUS/StateSZ2009–201215,1982.87%41.7%
x2IRS990ScheduleR/Form990ScheduleRPartI/AddressForeign/ProvinceOrStateSZ2009–20121320.0206%25.0%
x3IRS990ScheduleR/IdDisregardedEntitiesGrp/USAddress/StateSZ2013–20135,6742.85%41.6%
x4IRS990ScheduleR/IdDisregardedEntitiesGrp/ForeignAddress/ProvinceOrStateSZ2013–2013430.0216%37.2%
x5IRS990ScheduleR/IdDisregardedEntitiesGrp/USAddress/StateAbbreviationCdSZ2014–202494,3652.6%41.7%
x6IRS990ScheduleR/IdDisregardedEntitiesGrp/ForeignAddress/ProvinceOrStateNmSZ2014–20247920.0274%30.4%

% filers: percent of in-scope filers whose return has the xpath, in its latest year. Repeats in: share of filings where the element occurs more than once.

Coverage by tax year

Filings’09’10’11’12’13’14’15’16’17’18’19’20’21’22’23’24
x11.6k3.8k4.6k5.2k
x222363737
x35.7k
x443
x56.4k7.0k7.5k8.2k8.4k8.9k9.7k10k10k11k7.2k
x644525460727681839110376
Fill rate: % of all filings of the return type (largest xpath)
9905333333333333333

Filings with a value, by xpath (rows, numbered as in the xpath table) and tax year. A change of row from one year to the next is usually the IRS renaming the element (most were renamed in 2013). Hover a cell for the exact count.

Values

ValueFilingsShare
CA12,52720.3%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6NRECA INTERNATIONALVICTORIA ISLANDXML
2024990x5THE CLEVELAND CLINIC FOUNDATIONOHXML
2013990x4GLOBAL BUSINESS TRAVEL ASSOCIATION (GBT…BANGKOKXML
2013990x3EAST BALTIMORE COMMUNITY SCHOOL INCMDXML
2012990x2PROJECT MANAGEMENT INSTITUTEBEIJINGXML
2012990x1COMMUNITY MEMORIAL HEALTHCENTERVAXML