Variable pages · IRS 990 Master Concordance

SI_02_GRANT_US_ORG_ADDR_L2

Grantee street address line 2

Description
Address Foreign - AddressLine2
Table
SI-P02-T01-GRANTS-US-ORGS-GOVTS (many)
Part
Part II - Grants and Other Assistance to Domestic Organizations and Domestic Governments
Location
SCHED-I-PART-02-LINE-01-COL-A
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
6 / 8
xpaths observed / mapped
41k
filings with a value
2009–2024
tax years observed
0 + 1 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers15% of values are numeric
ⓘ infoNo sign of truncationIRS990ScheduleI/RecipientTable/AddressForeign/AddressLine2: longest value is exactly 35 characters; IRS990ScheduleI/RecipientTable/AddressUS/AddressLine2: longest value is exactly 35 characters; IRS990ScheduleI/RecipientTable/ForeignAddress/AddressLine2Txt: longest value is exactly 35 characters; IRS990ScheduleI/RecipientTable/USAddress/AddressLine2: longest value is exactly 35 characters; IRS990ScheduleI/RecipientTable/USAddress/AddressLine2Txt: longest value is exactly 35 characters

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleI/RecipientTable/ForeignAddress/AddressLine2Txt108 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleI/RecipientTable/ForeignAddress/AddressLine2Txt ; /Return/ReturnData/IRS990ScheduleI/RecipientTable/USAddress/AddressLine2Txt✓ 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.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleI/RecipientTable/AddressUS/AddressLine2SZ2009–20125,4671.01%46.1%
x2IRS990ScheduleI/RecipientTable/AddressForeign/AddressLine2SZ2009–2012100.00167%30.0%
x3IRS990ScheduleI/RecipientTable/USAddress/AddressLine2SZ2013–20132,0481.03%42.8%
x4IRS990ScheduleI/RecipientTable/ForeignAddress/AddressLine2SZ2013–201360.00302%
x5IRS990ScheduleI/RecipientTable/USAddress/AddressLine2TxtSZ2014–202433,4591.07%42.7%
x6IRS990ScheduleI/RecipientTable/ForeignAddress/AddressLine2TxtSZ2014–20241480.00397%15.5%
x7IRS990ScheduleI/Form990ScheduleIPartII/RecipientTable/AddressForeign/AddressLine2SZnot observed0
x8IRS990ScheduleI/Form990ScheduleIPartII/RecipientTable/AddressUS/AddressLine2SZnot observed0

% 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
x15171.4k1.8k1.8k
x21153
x32.0k
x46
x52.3k2.4k2.6k2.8k3.0k3.1k3.5k3.4k3.6k3.9k3.0k
x66812205102221151811
Fill rate: % of all filings of the return type (largest xpath)
9902111111111111111

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
99041,1381135

Most common values

ValueFilingsShare
FLOOR1,89018.2%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6EDUCATIONAL CREDIT523XML
2024990x5JAMESTOWN FOUNDATION INCVONFURSTENBERG BLDGXML
2013990x4INSTITUTE OF HEARTMATHCASERMA EDERLE BLDG 28XML
2013990x3Mary Hitchcock Memorial Hospital1 Lane DriveXML
2012990x2THE GLOBAL FUND FOR WOMEN INCSUITE 140XML
2012990x1Phoenix Children's HospitalSUITE 825XML