Variable pages · IRS 990 Master Concordance

SR_02_RLTD_ORG_ADDR_CITY

Related organization city

Description
Foreign Address - City
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
845k
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/City: longest value is exactly 35 characters; IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/CityNm: longest value is exactly 35 characters

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/CityNm6737 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/CityNm ; /Return/ReturnData/IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm✓ 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/CityNmmany-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/Citymany-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/CitySZ2009–2012132,31224.8%51.3%
x2IRS990ScheduleR/Form990ScheduleRPartII/AddressForeign/CitySZ2009–20121,5840.312%29.4%
x3IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CitySZ2013–201347,59623.9%49.2%
x4IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/CitySZ2013–20136430.323%28.6%
x5IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNmSZ2014–2024651,29016.3%47.9%
x6IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ForeignAddress/CityNmSZ2014–202411,7410.322%31.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
x113k34k41k44k
x2156376492560
x348k
x4643
x551k54k55k59k59k61k66k67k67k67k45k
x67348118609761.1k1.1k1.3k1.3k1.3k1.4k894
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
990845,166935

Most common values

ValueFilingsShare
WASHINGTON26,40417.4%
NEW YORK25,53116.8%
COLUMBUS14,1019.3%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6ACCION INTERNATIONALBANGALOREXML
2024990x5RISEWELL COMMUNITY SERVICES INC FKAWEST BABYLONXML
2013990x4Plan International USA IncAbujaXML
2013990x3ST LOUIS VOLUNTEERS OF AMERICAALEXANDRIAXML
2012990x2MAYO CLINIC HEALTH SYSTEM - EAU CLAIREFRANKFURTXML
2012990x1SOL PRICE RETAILINGSERVICE SCHOLARSHIP …SAN DIEGOXML