Variable pages · IRS 990 Master Concordance

SF_02_FRGN_ORG_GRANT_PURPOSE

Purpose of grant

Description
Purpose of the grant to the organization outside the US
Table
SF-P02-T01-FRGN-ORG-GRANTS (many)
Part
Part II - Grants and Other Assistance to Organizations or Entities Outside the United States
Location
SCHED-F-PART-02-LINE-01-COL-D
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
2 / 3
xpaths observed / mapped
94k
filings with a value
2009–2024
tax years observed
0 + 2 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers1% of values are numeric
ⓘ infoNo sign of truncationIRS990ScheduleF/GrantsToOrgOutsideUSGrp/PurposeOfGrantTxt: longest value is exactly 1000 characters; IRS990ScheduleF/GrantsToOrgsOutsideUS/PurposeOfGrant: longest value is exactly 1000 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleF/GrantsToOrgOutsideUSGrp/PurposeOfGrantTxtmany-to-one table, but 53% 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 46.7% of 84,027 filings, max 3950/filing, TY2013-2024; repeat_root: ''=53% ; IRS990ScheduleF/GrantsToOrgOutsideUSGrp=47%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleF/GrantsToOrgsOutsideUS/PurposeOfGrantmany-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.6% of 9,607 filings, max 4420/filing, TY2009-2012; repeat_root: ''=50% ; IRS990ScheduleF/GrantsToOrgsOutsideUS=50%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleF/GrantsToOrgsOutsideUS/PurposeOfGrantSZ2009–20129,6072.01%49.6%
x2IRS990ScheduleF/GrantsToOrgOutsideUSGrp/PurposeOfGrantTxtSZ2013–202484,0272.95%46.7%
x3IRS990ScheduleF/Form990ScheduleFPartII/GrantsToOrgsOutsideUS/PurposeOfGrantSZnot 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
x15432.4k3.1k3.6k
x24.2k4.8k5.4k5.7k6.3k6.6k7.1k8.1k8.7k9.3k9.6k8.2k
Fill rate: % of all filings of the return type (largest xpath)
9902222222222233333

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
99093,634321,000

Most common values

ValueFilingsShare
GENERAL SUPPORT3,32025.9%
EDUCATION2,30718.0%
RESEARCH1,44511.3%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2THE CLEVELAND CLINIC FOUNDATIONRESEARCHXML
2012990x1CARITAS WONJU INTERNATIONAL RELIEFSUPPORTXML