Variable pages · IRS 990 Master Concordance

SR_02_RLTD_ORG_ADDR_L2

Related organization street address line 2

Description: Address Foreign - AddressLine2
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

13k

filings with a value

2009–2024

tax years observed

0 + 4 reviewed

open flags

Checks

Value checks

Result	Value check	Detail
✓ pass	Values are text, not numbers	0% of values are numeric
ⓘ info	No sign of truncation	IRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/AddressLine2: longest value is exactly 35 characters; IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine2: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine2Txt: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine2: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine2Txt: longest value is exactly 35 characters

Flags

Flag	Severity	Xpath	Detail	Review
`COLLISION`	⚠ error	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine2Txt`	155 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine2Txt ; /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/A…	✓ accepted note False 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`	ⓘ info	`IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine2`	many-to-one table, but 55% of values sit in no repeating element	✓ accepted note Genuine 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 35.8% of 1,325 filings, max 24/filing, TY2009-2012; repeat_root: ''=55% ; IRS990ScheduleR/Form990ScheduleRPartII=45%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine2`	many-to-one table, but 64% of values sit in no repeating element	✓ accepted note Genuine 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 27.2% of 464 filings, max 19/filing, TY2013-2013; repeat_root: ''=64% ; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp=36%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine2`	many-to-one table, but 53% of values sit in no repeating element	✓ accepted note Genuine 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 23.3% of 30 filings, max 8/filing, TY2013-2013; repeat_root: ''=53% ; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp=47%.

Xpaths

	Xpath (under /Return/ReturnData or /Return/ReturnHeader)	Form	Years	Filings	% filers	Repeats in
x1	`IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine2`	SZ	2009–2012	1,325	0.24%	35.8%
x2	`IRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/AddressLine2`	SZ	2009–2012	64	0.0117%	31.2%
x3	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine2`	SZ	2013–2013	464	0.233%	27.2%
x4	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine2`	SZ	2013–2013	30	0.0151%	23.3%
x5	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine2Txt`	SZ	2014–2024	10,490	0.316%	45.2%
x6	`IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/AddressLine2Txt`	SZ	2014–2024	657	0.0238%	30.7%

% 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
x1	170	332	391	432
x2	5	16	22	21
x3					464
x4					30
x5						547	597	626	730	967	971	1.1k	1.2k	1.3k	1.5k	875
x6						42	41	49	42	44	57	80	81	77	78	66
Fill rate: % of all filings of the return type (largest xpath)
990	1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1

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

Return	Filings	Average length	Longest
990	13,030	12	35

Most common values

Value	Filings	Share
`SUITE 300`	1,545	23.9%

Example filings

Tax year	Return	Xpath	Organization	Value
2024	990	x6	PARTNERS IN HEALTH A NONPROFIT CORPORAT…	Suite 603	XML
2024	990	x5	Iowa Federation of Labor AFL-CIO	Suite A	XML
2013	990	x4	NATURE CONSERVANCY	Loka 246 Asa Sul	XML
2013	990	x3	KERSHAW COUNTY PUBLIC	2029 WEST DEKALB STREET	XML
2012	990	x2	CREATION MINISTRIES INTERNATIONAL	PO BOX 195	XML
2012	990	x1	BOYS & GIRLS CLUB OF SUFFOLK COUNTY	1275 PEACHTREE STREET NE	XML