Variable pages · IRS 990 Master Concordance

SR_02_RLTD_ORG_ADDR_STATE

Related organization state

Description
Province or state
Table
SR-P02-T01-ID-RLTD-TAX-EXEMPED-ORGS (many)
Part
Part II - Identification of Related Tax-Exempt Organizations
Location
SCHED-R-PART-02-COL-A
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
6 / 6
xpaths observed / mapped
839k
filings with a value
2009–2024
tax years observed
0 + 3 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
▲ warnSmall code listup to 606 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/IdRelatedTaxExemptOrgGrp/ForeignAddress/ProvinceOrStateNm3749 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/ProvinceOrStateNm ; /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddres…✓ 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/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCdmany-to-one table, but 52% 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 47.9% of 651,290 filings, max 993/filing, TY2014-2024; repeat_root: ''=52% ; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp=48%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/Statemany-to-one table, but 50% 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 49.2% of 47,596 filings, max 835/filing, TY2013-2013; repeat_root: ''=50% ; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp=50%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/StateSZ2009–2012132,31224.8%51.3%
x2IRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/ProvinceOrStateSZ2009–20127170.14%29.3%
x3IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateSZ2013–201347,59623.9%49.2%
x4IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/ProvinceOrStateSZ2013–20132930.147%28.3%
x5IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCdSZ2014–2024651,29016.3%47.9%
x6IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/ProvinceOrStateNmSZ2014–20246,3550.166%23.1%

% 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
x113k34k41k44k
x280166219252
x348k
x4293
x551k54k55k59k59k61k66k67k67k67k45k
x6334427446506555632698732776790459
Fill rate: % of all filings of the return type (largest xpath)
99040272625242323232322212020191916

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
NY92,37617.1%
CA82,23915.2%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6AIDS HEALTHCARE FOUNDATIONESWATINIXML
2024990x5APPALACHIAN CENTER FOR EXCELLENCE INVAXML
2013990x4INDEPENDENT DIPLOMAT INCLondonXML
2013990x3ST LOUIS VOLUNTEERS OF AMERICAVAXML
2012990x2SARAH LAWRENCE COLLEGEEndlandXML
2012990x1SOUTHERN ARIZONA INTERNATIONAL LIVESTOCKAZXML