Variable pages · IRS 990 Master Concordance

SG_01_FUNDRAISER_ADDR_L1

Fundraiser street address line 1

Description
Foreign Address - AddressLine1
Table
SG-P01-T01-FUNDRAISERS-INFO (many)
Part
Part I - Fundraising Activities
Location
SCHED-G-PART-01-LINE-02B-COL-i
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
SZ
6 / 6
xpaths observed / mapped
69k
filings with a value
2010–2024
tax years observed
0 + 4 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers0% of values are numeric
ⓘ infoNo sign of truncationIRS990ScheduleG/FundraiserActivityInfoGrp/ForeignAddress/AddressLine1Txt: longest value is exactly 35 characters; IRS990ScheduleG/FundraiserActivityInfoGrp/USAddress/AddressLine1: longest value is exactly 35 characters; IRS990ScheduleG/FundraiserActivityInfoGrp/USAddress/AddressLine1Txt: longest value is exactly 35 characters; IRS990ScheduleG/FundraiserActivityInformation/AddressUS/AddressLine1: longest value is exactly 35 characters

Flags

FlagSeverityXpathDetailReview
COLLISION⚠ errorIRS990ScheduleG/FundraiserActivityInfoGrp/ForeignAddress/AddressLine1Txt577 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990ScheduleG/FundraiserActivityInfoGrp/ForeignAddress/AddressLine1Txt ; /Return/ReturnData/IRS990ScheduleG/FundraiserActivityInfoGrp/USAddress…✓ 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ⓘ infoIRS990ScheduleG/FundraiserActivityInfoGrp/USAddress/AddressLine1Txtmany-to-one table, but 72% 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 27.1% of 54,332 filings, max 10/filing, TY2014-2024; repeat_root: ''=72% ; IRS990ScheduleG/FundraiserActivityInfoGrp=28%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleG/FundraiserActivityInformation/AddressUS/AddressLine1many-to-one table, but 71% 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 28.5% of 9,547 filings, max 10/filing, TY2010-2012; repeat_root: ''=71% ; IRS990ScheduleG/FundraiserActivityInformation=29%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleG/FundraiserActivityInfoGrp/USAddress/AddressLine1many-to-one table, but 71% 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 27.6% of 4,040 filings, max 10/filing, TY2013-2013; repeat_root: ''=71% ; IRS990ScheduleG/FundraiserActivityInfoGrp=29%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleG/FundraiserActivityInformation/AddressUS/AddressLine1SZ2010–20129,5471.37%28.5%
x2IRS990ScheduleG/FundraiserActivityInformation/AddressForeign/AddressLine1SZ2010–20121010.0135%13.9%
x3IRS990ScheduleG/FundraiserActivityInfoGrp/USAddress/AddressLine1SZ2013–20134,0401.33%27.6%
x4IRS990ScheduleG/FundraiserActivityInfoGrp/ForeignAddress/AddressLine1SZ2013–2013410.0135%9.8%
x5IRS990ScheduleG/FundraiserActivityInfoGrp/USAddress/AddressLine1TxtSZ2014–202454,3320.922%27.1%
x6IRS990ScheduleG/FundraiserActivityInfoGrp/ForeignAddress/AddressLine1TxtSZ2014–20247550.0147%19.1%

% 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
x12.5k3.3k3.7k
x2313337
x34.0k
x441
x54.3k4.5k4.6k5.0k4.9k4.9k4.8k5.3k5.8k6.0k4.2k
x644525756595866821169867
Fill rate: % of all filings of the return type (largest xpath)
990222222222212221
990-EZ<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
99067,3002035
990-EZ1,5161735

Most common values

ValueFilingsShare
155 COMMERCE DRIVE2127.4%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x6PROVEG INTERNATIONAL INCJOAO LUIS DE MOURA 22XML
2024990x5THE CLEVELAND CLINIC FOUNDATION350 TENTH AVE STE 1300XML
2013990x4NATURE CONSERVANCY489 Queen Street EastXML
2013990x3PENNSYLVANIA INTERSCHOLASTIC629 NORTH MARKET STREETXML
2012990x2SEATTLE UNIVERSITY425 University Ave Suite 7XML
2012990x1UNITED STATES AMATEUR BOXING FOUNDATION15000 COMMERCE PARKWAY STE CXML