Variable pages · IRS 990 Master Concordance

SR_03_RLTD_ORG_PTR_ADDR_L2

Related organization street address line 2

Description: Address Foreign - AddressLine2
Table: SR-P03-T01-ID-RLTD-ORGS-TAXABLE-PARTNERSHIP (many)
Part: Part III - Identification of Related Organizations Taxable as a Partnership
Location: SCHED-R-PART-03-COL-A
Type: text
Scope: PC – 990 only
Database: F990
Forms: SZ

6 / 6

xpaths observed / mapped

4.5k

filings with a value

2009–2024

tax years observed

0 + 5 reviewed

open flags

Checks

Value checks

Result	Value check	Detail
✓ pass	Values are text, not numbers	1% of values are numeric
✓ pass	No sign of truncation	longest values do not sit at a common field limit

Flags

Flag	Severity	Xpath	Detail	Review
`COLLISION`	⚠ error	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/ForeignAddress/AddressLine2Txt`	108 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/ForeignAddress/AddressLine2Txt ; /Return/ReturnData/IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp…	✓ 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/Form990ScheduleRPartIII/AddressUS/AddressLine2`	many-to-one table, but 52% 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 41.9% of 124 filings, max 174/filing, TY2009-2012; repeat_root: ''=52% ; IRS990ScheduleR/Form990ScheduleRPartIII=48%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/USAddress/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 41.5% of 53 filings, max 21/filing, TY2013-2013; repeat_root: ''=53% ; IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp=47%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleR/Form990ScheduleRPartIII/AddressForeign/AddressLine2`	many-to-one table, but 100% of values sit in no repeating element	✓ accepted note Sparse field (address line 2, foreign address, etc.) inside a genuine repeating group; too few filings to observe a repeat. Sibling xpaths of the same group repeat. Evidence: repeats in 0.0% of 2 filings, max 1/filing, TY2012-2012; repeat_root: ''=100%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/ForeignAddress/AddressLine2`	many-to-one table, but 100% of values sit in no repeating element	✓ accepted note Sparse field (address line 2, foreign address, etc.) inside a genuine repeating group; too few filings to observe a repeat. Sibling xpaths of the same group repeat. Evidence: repeats in 0.0% of 2 filings, max 1/filing, TY2013-2013; repeat_root: ''=100%.

Xpaths

	Xpath (under /Return/ReturnData or /Return/ReturnHeader)	Form	Years	Filings	% filers	Repeats in
x1	`IRS990ScheduleR/Form990ScheduleRPartIII/AddressUS/AddressLine2`	SZ	2009–2012	124	0.0234%	41.9%
x2	`IRS990ScheduleR/Form990ScheduleRPartIII/AddressForeign/AddressLine2`	SZ	2012–2012	2	0.00111%
x3	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/USAddress/AddressLine2`	SZ	2013–2013	53	0.0267%	41.5%
x4	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/ForeignAddress/AddressLine2`	SZ	2013–2013	2	0.00101%
x5	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/USAddress/AddressLine2Txt`	SZ	2014–2024	4,144	0.0977%	70.5%
x6	`IRS990ScheduleR/IdRelatedOrgTxblPartnershipGrp/ForeignAddress/AddressLine2Txt`	SZ	2014–2024	135	0.0018%	74.8%

% 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	9	31	42	42
x2				2
x3					53
x4					2
x5						110	110	148	231	598	511	495	488	569	613	271
x6						3	4	11	3	12	21	18	18	19	21	5
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	4,460	11	34

Most common values

Value	Filings	Share
`SUITE 101`	1,483	8.9%

Example filings

Tax year	Return	Xpath	Organization	Value
2024	990	x6	PLANET WATER FOUNDATION	WATTHANA	XML
2024	990	x5	Baptist Health Hospitals	Suite 200	XML
2013	990	x4	University of the Virgin Islands	2 John Brewers Bay	XML
2013	990	x3	AMERICAN FEDERATION OF STATE COUNTY	STE 220	XML
2012	990	x2	Agora Partnerships	One Capital Place	XML
2012	990	x1	WESLEY ACRES	1520 COOPER HILL ROAD	XML