Variable pages · IRS 990 Master Concordance

SR_02_RLTD_ORG_ADDR_L1

Related organization street address line 1

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

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers0% of values are numeric
ⓘ infoNo sign of truncationIRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/AddressLine1: longest value is exactly 35 characters; IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine1: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine1: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine1Txt: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt: longest value is exactly 35 characters

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine1Txt7037 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine1Txt ; /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/AddressLine1Txtmany-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/AddressLine1many-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/AddressLine1SZ2009–2012132,31224.8%51.3%
x2IRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/AddressLine1SZ2009–20121,6820.333%31.0%
x3IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1SZ2013–201347,59623.9%49.2%
x4IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine1SZ2013–20136830.343%30.0%
x5IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1TxtSZ2014–2024651,29016.3%47.9%
x6IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine1TxtSZ2014–202412,4540.342%31.6%

% 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
x2158405521598
x348k
x4683
x551k54k55k59k59k61k66k67k67k67k45k
x67758579081.0k1.1k1.2k1.3k1.4k1.4k1.4k947
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

ReturnFilingsAverage lengthLongest
990846,0172035

Most common values

ValueFilingsShare
PO BOX 14473,77610.6%
PO BOX 91841,3703.8%
301 HENRY STREET1,2643.5%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6ACCION INTERNATIONAL9/3 KAISER-E-HIND 1 FL RICHMOXML
2024990x5APPALACHIAN CENTER FOR EXCELLENCE INPO BOX 7070XML
2013990x4THE ANNA FREUD FOUNDATION21 MARESFIELD GARDENSXML
2013990x3SAN MATEO ELECTRICAL WORKERS HEALTH PLAN6800 SANTA TERESA BOULEVARD SUITE 1XML
2012990x2SARAH LAWRENCE COLLEGEWadham CollegeXML
2012990x1BAPTIST HEALTH AMBULATORY SERVICES INC800 PRUDENTIAL DRXML