Variable pages · IRS 990 Master Concordance

SB_01_CONTRIBUTOR_ADDR_STATE

Contributor address - state

Description
Contributor address - state
Table
SB-P01-T01-CONTRIBUTORS (many)
Part
Part I - Contributors
Location
SCHED-B-PART-01
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990, F990PF
Forms
SZ
6 / 6
xpaths observed / mapped
2.5M
filings with a value
2009–2024
tax years observed
2 + 5 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
▲ warnSmall code listup to 257 distinct values per xpath and year
▲ warnCodes share one format88% have the shape AAAAAAAAAA
✓ passConsistent letter case0.0% of values are lower case

Flags

FlagSeverityXpathDetailReview
INCIDENCE_BREAK▲ warn(variable)990 fill rate changes up to 104.5x year-on-year (in 2017-2018)open
INCIDENCE_BREAK▲ warn(variable)990EZ fill rate changes up to 90.1x year-on-year (in 2017-2018)open
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/Statemany-to-one table, but 100% of values sit in no repeating element✓ accepted
noteSchedule B contributors are a repeating group in the schema, but public e-file data is redacted to a single ContributorInformationGrp with values RESTRICTED (max 1/filing), so no repeats can be observed. Keep MANY. Evidence: repeats in 0.0% of 1,939,894 filings, max 1/filing, TY2013-2024; repeat_root: ''=100%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleB/ContributorInfo/ContributorAddressUS/Statemany-to-one table, but 100% of values sit in no repeating element✓ accepted
noteSchedule B contributors are a repeating group in the schema, but public e-file data is redacted to a single ContributorInformationGrp with values RESTRICTED (max 1/filing), so no repeats can be observed. Keep MANY. Evidence: repeats in 0.0% of 310,685 filings, max 1/filing, TY2009-2012; repeat_root: ''=100%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCdmany-to-one table, but 69% of values sit in no repeating element✓ accepted
noteGenuine repeating group (XSD maxOccurs > 1; repeat_root is the group when a filing has several rows); most filings have one instance.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleB/ContributorInfo/ContributorAddressUS/Statemany-to-one table, but 70% of values sit in no repeating element✓ accepted
noteSchedule B contributors are a repeating group in the schema, but public e-file data is redacted to a single ContributorInformationGrp with values RESTRICTED (max 1/filing), so no repeats can be observed. Keep MANY. Evidence: repeats in 0.0% of 310,685 filings, max 1/filing, TY2009-2012; repeat_root: ''=100%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/Statemany-to-one table, but 69% of values sit in no repeating element✓ accepted
noteSchedule B contributors are a repeating group in the schema, but public e-file data is redacted to a single ContributorInformationGrp with values RESTRICTED (max 1/filing), so no repeats can be observed. Keep MANY. Evidence: repeats in 0.0% of 1,939,894 filings, max 1/filing, TY2013-2024; repeat_root: ''=100%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleB/ContributorInfo/ContributorAddressUS/StateSZ2009–2012337,49439.3%2.4%
x2IRS990ScheduleB/ContributorInfo/ContributorAddressForeign/ProvinceOrStateSZ2009–20122090.029%22.0%
x3IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateSZ2013–20241,952,35132.8%0.2%
x4IRS990ScheduleB/ContributorInformationGrp/ContributorForeignAddress/ProvinceOrStateSZ2013–20131040.0298%21.2%
x5IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCdSZ2014–2024255,8514.98%31.0%
x6IRS990ScheduleB/ContributorInformationGrp/ContributorForeignAddress/ProvinceOrStateNmSZ2014–20242,2970.051%22.5%

% 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
x124k82k108k123k
x23466991
x3137k137k147k154k1.6k103k181k205k228k234k238k187k
x4104
x514k16k17k19k19k22k28k31k30k30k28k
x6113133147160168199248254279305291
Fill rate: % of all filings of the return type (largest xpath)
9905949494949494949<132505051515150
990-EZ2725262625252526<110262628282828
990-PF24262527272727282825252526242425

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

ValueFilingsShare
RESTRICTED2,250,62091.2%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x3CHRISTIAN SHANE FONVILLE YOUTHRESTRICTEDXML
2024990PFx5The Brad & Jill Jackson Family Foundati…WAXML
2024990PFx6STEMPOWER INCYAOUNDEXML
2013990PFx4STEVE NASH FOUNDATIONONTARIOXML
2012990EZx1ART FORMS & THEATRE CONCEPTS INCRESTRICTEDXML
2012990PFx2Stone Point Capital Foundation IncONTARIOXML