Variable pages · IRS 990 Master Concordance

SR_02_RLTD_ORG_ADDR_ZIP

Related organization zip

Description
Foreign Address - Postal code
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
840k
filings with a value
2009–2024
tax years observed
0 + 3 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues have the ZIP format99.4% of values match ^(99999|999999999|99999-9999)$
✓ passStored as textdata type is text
▲ warnNo placeholder values5 filings use a placeholder such as 000000000

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/ForeignPostalCd4626 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/ForeignPostalCd ; /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/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/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCdmany-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/ZIPCodemany-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/ZIPCodeSZ2009–2012132,31224.8%51.3%
x2IRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/PostalCodeSZ2009–20129730.188%29.1%
x3IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCodeSZ2013–201347,59623.9%49.2%
x4IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/PostalCodeSZ2013–20133990.201%26.6%
x5IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCdSZ2014–2024651,29016.3%47.9%
x6IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/ForeignPostalCdSZ2014–20247,8080.211%29.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
x2102224309338
x348k
x4399
x551k54k55k59k59k61k66k67k67k67k45k
x6459531585654708757850873896911584
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

FormatFilingsShare
99999792,47192.2%
99999999962,2577.2%
A9A 9A91,6710.2%
9999991,2860.1%
99991,2520.1%
AA9A 9AA7820.1%

Format of the values: 9 a digit, A a letter.

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6ACCION INTERNATIONAL560025XML
2024990x5IAAI FOUNDATION INC21050XML
2013990x4INDEPENDENT DIPLOMAT INCEC4Y 0HAXML
2013990x3SAN MATEO ELECTRICAL WORKERS HEALTH PLAN95119XML
2012990x2THE CARTER CENTER COLLABORATIVE INCPF9 2DFXML
2012990x1SOUTHERN ARIZONA INTERNATIONAL LIVESTOCK857021089XML