Variable pages · IRS 990 Master Concordance

F9_03_PROG_GRANT

Program accomplishment grants and allocations to others

Description
Program Accomplishment Grants
Table
F9-P03-T00-PROGRAM-ONE (one)
F9-P03-T00-PROGRAM-THREE (one)
F9-P03-T00-PROGRAM-TWO (one)
F9-P03-T01-PROGRAMS-OTHER (many)
F9-P03-T02-PROGRAMS-EZ (many)
Part
Part III - Statement of Program Service Accomplishments
Location
F990-PC-PART-03-LINE-04-ABCD
Type
numeric
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
EZ, PC
10 / 20
xpaths observed / mapped
2.9M
filings with a value
2009–2024
tax years observed
3 + 4 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues parse as numbers100.0% of values are numeric
▲ warnNo sudden change in the median between adjacent yearslargest change 13.0x (IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt, 990EZ, TY2018)
▲ warnPooled xpaths are on the same scale (same return type)medians differ 8.7x (990: IRS990/Grants vs IRS990/ProgSrvcAccomActyOtherGrp/GrantAmt)
ⓘ infoSign convention0.0% of values are negative (fine for net amounts)

Flags

FlagSeverityXpathDetailReview
INCIDENCE_BREAK▲ warn(variable)990 fill rate changes up to 10.2x year-on-year (in 2010-2024)open
INCIDENCE_BREAK▲ warn(variable)990 fill rate changes up to 5.4x year-on-year (in 2009-2024)open
INCIDENCE_BREAK▲ warn(variable)990 fill rate changes up to 3.1x year-on-year (in 2022-2023)open
MANY_NOT_REPEATINGⓘ infoIRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmtmany-to-one table, but 70% 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 26.5% of 990,979 filings, max 74/filing, TY2013-2024; repeat_root: ''=70% ; IRS990EZ/ProgramSrvcAccomplishmentGrp=30%.
MANY_NOT_REPEATINGⓘ infoIRS990EZ/ProgramServiceAccomplishment/GrantsAndAllocationsmany-to-one table, but 70% 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 26.0% of 130,484 filings, max 83/filing, TY2009-2012; repeat_root: ''=70% ; IRS990EZ/ProgramServiceAccomplishment=30%.
MANY_NOT_REPEATINGⓘ infoIRS990/ProgSrvcAccomActyOtherGrp/GrantAmtmany-to-one table, but 76% 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 17.5% of 105,724 filings, max 124/filing, TY2013-2024; repeat_root: ''=76% ; IRS990/ProgSrvcAccomActyOtherGrp=24%.
MANY_NOT_REPEATINGⓘ infoIRS990/ActivityOther/Grantsmany-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 19.1% of 14,275 filings, max 72/filing, TY2009-2012; repeat_root: ''=71% ; IRS990/ActivityOther=29%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990EZ/ProgramServiceAccomplishment/GrantsAndAllocationsEZ2009–2012130,48449.1%26.0%
x2IRS990/GrantsPC2009–2012111,68022.9%
x3IRS990/Activity2/GrantsPC2009–201234,0796.73%
x4IRS990/Activity3/GrantsPC2009–201223,1314.49%
x5IRS990/ActivityOther/GrantsPC2009–201214,2752.93%19.1%
x6IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmtEZ2013–2024990,97949.4%26.5%
x7IRS990/GrantAmtPC2013–2024954,39332.2%
x8IRS990/ProgSrvcAccomActy2Grp/GrantAmtPC2013–2024288,64710.6%
x9IRS990/ProgSrvcAccomActy3Grp/GrantAmtPC2013–2024199,7987.84%
x10IRS990/ProgSrvcAccomActyOtherGrp/GrantAmtPC2013–2024105,7243.54%17.5%
x11IRS990/Form990PartIII/Activity2/GrantsPCnot observed0
x12IRS990/Form990PartIII/Activity3/GrantsPCnot observed0
x13IRS990/Form990PartIII/ActivityOther/GrantsPCnot observed0
x14IRS990/Form990PartIII/GrantsPCnot observed0
x15IRS990/ProgramServiceAccomplishments/GrantsAndAllocationsPCnot observed0
x16IRS990EZ/GrantAmtEZnot observed0
x17IRS990EZ/GrantsEZnot observed0
x18IRS990EZ/ProgSrvcAccomActy2Grp/GrantAmtEZnot observed0
x19IRS990EZ/ProgSrvcAccomActy3Grp/GrantAmtEZnot observed0
x20IRS990EZ/ProgSrvcAccomActyOtherGrp/GrantAmtEZnot 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
x19.5k33k42k46k
x29.2k27k34k41k
x33.0k8.6k10k12k
x42.2k5.9k7.0k8.1k
x51.4k3.5k4.1k5.3k
x657k63k67k68k71k85k87k97k107k100k101k88k
x746k51k54k58k63k79k84k99k106k111k115k89k
x813k15k16k16k18k22k24k30k33k35k37k29k
x98.9k9.8k10k11k12k15k16k21k23k25k27k22k
x105.7k6.3k6.7k6.9k7.4k8.7k9.1k10k11k12k12k9.8k
Fill rate: % of all filings of the return type (largest xpath)
99028222123232323242429303131323232
990-EZ61525149545453525157575753494949

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

ReturnFilings% numeric% zero% negativeP25MedianP75P99
9901,731,716100.0%28.6%0.0%16220,000150,49012,570,194
990-EZ1,121,461100.0%54.0%0.0%008,000137,311

Percentiles are the median over tax years of each year's percentile.

Example filings

Tax yearReturnXpathOrganizationValue
2024990x7IAAI FOUNDATION INC0XML
2024990x9The Family YMCA14270XML
2024990x8IAAI FOUNDATION INC11566XML
2024990x10UNITED WAY OF KNOX COUNTY INC0XML
2024990EZx6Science & Technology Education Project17648XML
2012990x2GodsKidsorg351480XML
2012990x4ARAB AMERICAN INSTITUTE FOUNDATION0XML
2012990x3ANITA BORG INSTITUTE FOR WOMEN AND TECH…912XML