Variable pages · IRS 990 Master Concordance

SR_04_RLTD_ORG_CORP_ADDR_L2

Related organization street address line 2

Description
Address Foreign - AddressLine2
Table
SR-P04-T01-ID-RLTD-ORGS-TAXABLE-CORPORATION (many)
Part
Part IV - Identification of Related Organizations Taxable as a Corporation or Trust
Location
SCHED-R-PART-04-COL-A
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
6 / 6
xpaths observed / mapped
7.4k
filings with a value
2009–2024
tax years observed
1 + 2 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers0% of values are numeric
ⓘ infoNo sign of truncationIRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/AddressLine2Txt: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/AddressLine2Txt: longest value is exactly 35 characters

Flags

FlagSeverityXpathDetailReview
INCIDENCE_BREAK▲ warn(variable)990 fill rate changes up to 3.2x year-on-year (in 2018)open
COLLISION⚠ errorIRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/AddressLine2Txt1640 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/AddressLine2Txt ; /Return/ReturnData/IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/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/Form990ScheduleRPartIV/AddressForeign/AddressLine2many-to-one table, but 68% 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 14.3% of 91 filings, max 243/filing, TY2009-2012; repeat_root: ''=68% ; IRS990ScheduleR/Form990ScheduleRPartIV=32%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/AddressLine2SZ2009–20124280.0657%34.1%
x2IRS990ScheduleR/Form990ScheduleRPartIV/AddressForeign/AddressLine2SZ2009–2012910.0139%14.3%
x3IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/AddressLine2SZ2013–20131160.0583%31.0%
x4IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/AddressLine2SZ2013–2013380.0191%26.3%
x5IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/AddressLine2TxtSZ2014–20244,3640.0963%60.3%
x6IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ForeignAddress/AddressLine2TxtSZ2014–20242,3320.0642%33.4%

% 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
x168111131118
x219232425
x3116
x438
x5147165173179475510589596616647267
x642508561320326356354370190178
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

ReturnFilingsAverage lengthLongest
9907,3691335

Most common values

ValueFilingsShare
130 FENCHURCH STREET1,27515.6%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6St Francis Hospital IncClanwilliam PlaceXML
2024990x5St Francis Hospital IncSte 200XML
2013990x4MIDMICHIGAN HEALTH DEVELOPMENTGOVERNORS SQUARE BLDG 4 2ND FLOORXML
2013990x3SCHEURER HOSPITAL170 N CASEVILLE ROADXML
2012990x2MIDMICHIGAN MEDICAL CENTER-GLADWINGOVERNORS SQUARE BLDG 4 2ND FLOORXML
2012990x1FRIENDS OF GOETHE INC1197 PEACHTREE RD NE PLAZA LEVELXML