Variable pages · IRS 990 Master Concordance

SR_04_RLTD_ORG_CORP_ADDR_STATE

Related organization state

Description
Province or state
Table
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION (many)
Part
Part IV - Identification of Related Organizations Taxable as a Corporation or Trust
Location
SCHED-R-PART-04-COL-A
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
6 / 6
xpaths observed / mapped
255k
filings with a value
2009–2024
tax years observed
0 + 1 reviewed
open flags

Checks

Value checks

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

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/ProvinceOrStateNm14854 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/ProvinceOrStateNm ; /Return/ReturnData/IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAdd…✓ 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.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/StateSZ2009–201240,9447.46%51.8%
x2IRS990ScheduleR/Form990ScheduleRPartIV/AddressForeign/ProvinceOrStateSZ2009–20123,2580.641%24.2%
x3IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/StateSZ2013–201314,1147.1%50.3%
x4IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/ProvinceOrStateSZ2013–20131,1690.588%23.0%
x5IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/StateAbbreviationCdSZ2014–2024182,3434.19%51.0%
x6IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/ProvinceOrStateNmSZ2014–202412,8170.211%47.2%

% 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
x14.2k11k13k13k
x22698519861.2k
x314k
x41.2k
x515k15k16k17k17k17k18k19k19k18k12k
x69509941.0k1.1k1.4k1.3k1.4k1.4k1.3k1.3k585
Fill rate: % of all filings of the return type (largest xpath)
99013987777666666554

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
NY34,03515.9%
CA25,80812.1%
PA21,75010.2%
OH20,2779.5%
TX18,8758.8%
MI16,2757.6%
IL15,7387.4%
FL14,0406.6%
MD11,6495.5%
MA7,3523.4%
GRAND CAYMAN5,9982.8%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6CONCUSSION LEGACY FOUNDATION INCWALESXML
2024990x5PENNSYLVANIA INSTITUTE OF TECHNOLOGYPAXML
2013990x4KENNESTONE HOSPITAL INCGrand CaymanXML
2013990x3NCS Community Development CorpNYXML
2012990x2Essentia Health FoundationCayman IslandsXML
2012990x1Mercy Health System of Southeastern Pen…NYXML