SOI 2011 990PF All Years

Number of variables321
Number of records231,834

Field Name
Field Type
Description and Values
Basic Info
TaxYr
Character
(4)
Tax Year (Match records to sub-tables using TaxYr and SCPL)
SOI Sample Tax Year (Records are matched to sub-tables using TaxYr and SCPL) (Top of form - Form Tax Year)
Available Years: All
EIN
Character
(9)
Employer Identification Number
Employer Identification Number (Top of form - Box A)
Available Years: All
E010
Character
(4)
Accounting Period
Accounting Period (Top of form - Accounting Period)
Available Years: All
NAME
Character
(60)
Name of Organization
Name of Organization (Top of form - Name of foundation)
Available Years: All
STATE
Character
(2)
State
State (Top of form - State)
Available Years: All
zip5
Character
(5)
Zip code
Zip code (Top of form - Zip Code)
Available Years: All (missing values found 1985-1998)
FIPS
Character
(5)
State + County FIPS code
2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts.
MSA_NECH
Character
(4)
Metropolitan Statistical Area
Metropolitan Statistical Area (NCCS file) (list)
outnccs
Character
(20)
Out of Scope flag
Out-of-scope (IN/OUT) (see OUTREAS doc. for details)
OUTREAS
Character
(20)
Reason why out of scope
Reason why out of scope
No value
44- Not a 501(c)(3)
FF- Foreign organization
GG- Government Entity
II- Coded out of scope by Independent Sector
NN- Coded out of scope by NCCS (e.g. foreign address on Form 990)
SS- Missing geographic information
TT- U.S. Territory or armed forces overseas
E005
Character
(20)
Return Status Code
Return Status Code (Top of form - Box G)
Available Years: All
AA - Amended return
CC - Address Change
FF - Final return
II - Initial return
NN - Name Change
E050
Character
(20)
Type of Foundation Code
Type of Foundation Code (Top of form - Box H)
Available Years: All
EE - Private Foundation
TT - Charitable Trust
E090
Character
(20)
Accounting Method
Accounting Method (Top of form - Box J)
Available Years: 1990 - current
AAccrual
CCash
OOther
E070
Character
(20)
507(b)1(A) Termination
507(b)1(A) Termination (Top of form - Box E)
Available Years: All
NNo
YYes
E100
Numeric
(20)
Fair Market Value of Assets
Fair Market Value of Assets (Top of form - Box I)
Available Years: All
Part I - Analysis of Revenue and Expenses
R010
Numeric
(20)
Contributions, Gifts, Grants, Etc. Received
Contributions, Gifts, Grants, Etc. Received (Part I - Line 1, Column a)
Available Years: All
R020
Numeric
(20)
Interest
Interest (Part I - Line 3, Column a)
Available Years: All
R030
Numeric
(20)
Dividends
Dividends (Part I - Line 4, Column a)
Available Years: All
R040
Numeric
(20)
Gross Rents
Gross Rents (Part I - Line 5a, Column a)
Available Years: All
R050
Numeric
(20)
Net Gain (Loss) from Sale of Assets
Net Gain (Loss) from Sale of Assets (Part I - Line 6a, Column a)
Available Years: All
R060
Numeric
(20)
Gross Profit (Loss) from Business Activities
Gross Profit (Loss) from Business Activities (Part I - Line 10c, Column a)
Available Years: All
R070
Numeric
(20)
Other Income (Loss)
Other Income (Loss) (Part I - Line 11, Column a)
Available Years: All
R080
Numeric
(20)
Total Income (Loss) Col. A
Total Income (Loss) Col. A (Part I - Line 12, Column a)
Available Years: All
X010
Numeric
(20)
Compensation of Officers-Col. A
Compensation of Officers-Col. A (Part I - Line 13, Column a)
Available Years: All
X020
Numeric
(20)
Other Salaries and Wages-Col. A
Other Salaries and Wages-Col. A (Part I - Line 14, Column a)
Available Years: All
X030
Numeric
(20)
Pension Plans-Col. A
Pension Plans-Col. A (Part I - Line 15, Column a)
Available Years: All
X040
Numeric
(20)
Legal Fees-Col. A
Legal Fees-Col. A (Part I - Line 16a, Column a)
Available Years: All
X050
Numeric
(20)
Accounting Fees-Col. A
Accounting Fees-Col. A (Part I - Line 16b, Column a)
Available Years: All
X060
Numeric
(20)
Other Professional Fees-Col. A
Other Professional Fees-Col. A (Part I - Line 16c, Column a)
Available Years: All
X070
Numeric
(20)
Interest-Col. A
Interest-Col. A (Part I - Line 17, Column a)
Available Years: All
X080
Numeric
(20)
Taxes-Col. A
Taxes-Col. A (Part I - Line 18, Column a)
Available Years: All
X090
Numeric
(20)
Depreciation & Depletion
Depreciation & Depletion (Part I - Line 19, Column a)
Available Years: All
X100
Numeric
(20)
Occupancy-Col. A
Occupancy-Col. A (Part I - Line 20, Column a)
Available Years: All
X110
Numeric
(20)
Travel, Conferences, Meetings-Col. A
Travel, Conferences, Meetings-Col. A (Part I - Line 21, Column a)
Available Years: All
X120
Numeric
(20)
Printing and Publications-Col. A
Printing and Publications-Col. A (Part I - Line 22, Column a)
Available Years: All
X130
Numeric
(20)
Other Expenses-Col. A
Other Expenses-Col. A (Part I - Line 23, Column a)
Available Years: All
X140
Numeric
(20)
Contributions, Gifts, Grants Paid-Col. A
Contributions, Gifts, Grants Paid-Col. A (Part I - Line 25, Column a)
Available Years: All
X150
Numeric
(20)
Total Expenses-Col. A
Total Expenses-Col. A (Part I - Line 26, Column a)
Available Years: All
X160
Numeric
(20)
Excess Revenue Over Expenses
Excess Revenue Over Expenses (Part I - Line 27a, Column a)
Available Years: All
R090
Numeric
(20)
Capital Gain Net Income
Capital Gain Net Income (Part I - Line 7b, Column b)
Available Years: All
R100
Numeric
(20)
Total Income (Loss) Col. B
Total Income (Loss) Col. B (Part I - Line 12, Column b)
Available Years: All
X170
Numeric
(20)
Total Expenses-Col. B
Total Expenses-Col. B (Part I - Line 26, Column b)
Available Years: All
X180
Numeric
(20)
Net Investment Income
Net Investment Income (Part I - Line 27b, Column b)
Available Years: All
X190
Numeric
(20)
Compensation of Officers-Col. D
Compensation of Officers-Col. D (Part I - Line 13, Column d)
Available Years: All
X200
Numeric
(20)
Other Salaries and Wages-Col. D
Other Salaries and Wages-Col. D (Part I - Line 14, Column d)
Available Years: All
X210
Numeric
(20)
Pension Plans-Col. D
Pension Plans-Col. D (Part I - Line 15, Column d)
Available Years: All
X220
Numeric
(20)
Legal Fees-Col. D
Legal Fees-Col. D (Part I - Line 16a, Column d)
Available Years: All
X230
Numeric
(20)
Accounting Fees-Col. D
Accounting Fees-Col. D (Part I - Line 16b, Column d)
Available Years: All
X240
Numeric
(20)
Other Professional Fees-Col. D
Other Professional Fees-Col. D (Part I - Line 16c, Column d)
Available Years: All
X250
Numeric
(20)
Interest-Col. D
Interest-Col. D (Part I - Line 17, Column d)
Available Years: All
X260
Numeric
(20)
Taxes-Col. D
Taxes-Col. D (Part I - Line 18, Column d)
Available Years: All
X270
Numeric
(20)
Occupancy-Col. D
Occupancy-Col. D (Part I - Line 20, Column d)
Available Years: All
X280
Numeric
(20)
Travel, Conferences, Meetings-Col. D
Travel, Conferences, Meetings-Col. D (Part I - Line 21, Column d)
Available Years: All
X290
Numeric
(20)
Printing and Publications-Col. D
Printing and Publications-Col. D (Part I - Line 22, Column d)
Available Years: All
X300
Numeric
(20)
Other Expenses-Col. D
Other Expenses-Col. D (Part I - Line 23, Column d)
Available Years: All
X310
Numeric
(20)
Contributions, Gifts, Grants Paid-Col. D
Contributions, Gifts, Grants Paid-Col. D (Part I - Line 25, Column d)
Available Years: All
X320
Numeric
(20)
Total Expenses-Col. D
Total Expenses-Col. D (Part I - Line 26, Column d)
Available Years: All
Part II - Balance Sheets
A001
Numeric
(20)
Cash-Col. A
Cash-Col. A (Part II - Line 1, Column a)
Available Years: 1999 - current
A002
Numeric
(20)
Savings-Col. A
Savings-Col. A (Part II - Line 2, Column a)
Available Years: 1999 - current
A003
Numeric
(20)
Accounts Receivable-Col. A
Accounts Receivable-Col. A (Part II - Line 3, Column a)
Available Years: 1999 - current
A004
Numeric
(20)
Pledges Receivable-Col. A
Pledges Receivable-Col. A (Part II - Line 4, Column a)
Available Years: 1999 - current
A005
Numeric
(20)
Grants Receivable-Col. A
Grants Receivable-Col. A (Part II - Line 5, Column a)
Available Years: 1999 - current
A006
Numeric
(20)
Receivables Due from Officers-Col. A
Receivables Due from Officers-Col. A (Part II - Line 6, Column a)
Available Years: 1999 - current
A007
Numeric
(20)
Other Notes & Loans Receivable-Col. A
Other Notes & Loans Receivable-Col. A (Part II - Line 7, Column a)
Available Years: 1999 - current
A008
Numeric
(20)
Inventories-Col. A
Inventories-Col. A (Part II - Line 8, Column a)
Available Years: 1999 - current
A009
Numeric
(20)
Prepaid Expenses-Col. A
Prepaid Expenses-Col. A (Part II - Line 9, Column a)
Available Years: 1999 - current
A010
Numeric
(20)
Investments-Government Obligations-Col. A
Investments-Government Obligations-Col. A (Part II - Line 10a, Column a)
Available Years: 1990 - current
A020
Numeric
(20)
Investments-Corporate Stock-Col. A
Investments-Corporate Stock-Col. A (Part II - Line 10b, Column a)
Available Years: 1990 - current
A030
Numeric
(20)
Investments-Corporate Bonds-Col. A
Investments-Corporate Bonds-Col. A (Part II - Lines 10c, Column a)
Available Years: 1990 - current
A031
Numeric
(20)
Investments-Land, Buildings, & Equipment-Col. A
Investments-Land, Buildings, & Equipment-Col. A (Part II - Line 11, Column a)
Available Years: 1999 - current
A032
Numeric
(20)
Investments-Mortgage Loans-Col. A
Investments-Mortgage Loans-Col. A (Part II - Line 12, Column a)
Available Years: 1999 - current
A033
Numeric
(20)
Investments-Other-Col. A
Investments-Other-Col. A (Part II - Line 13, Column a)
Available Years: 1999 - current
A034
Numeric
(20)
Land, Buildings, and Equipment-Col. A
Land, Buildings, and Equipment-Col. A (Part II - Line 14, Column a)
Available Years: 1999 - current
A035
Numeric
(20)
Other Assets-Col. A
Other Assets-Col. A (Part II - Line 15, Column a)
Available Years: 1999 - current
A040
Numeric
(20)
Total Assets-Col. A
Total Assets-Col. A (Part II - Line 16, Column a)
Available Years: All
L010
Numeric
(20)
Total Liabilities-Col. A
Total Liabilities-Col. A (Part II - Line 23, Column a)
Available Years: All
N010
Numeric
(20)
Total Fund Balances/Net Worth-Col. A
Total Fund Balances/Net Worth-Col. A (Part II - Line 30, Column a)
Available Years: All
A050
Numeric
(20)
Cash-Col. B
Cash-Col. B (Part II - Line 1, Column b)
Available Years: All
A060
Numeric
(20)
Savings-Col. B
Savings-Col. B (Part II - Line 2, Column b)
Available Years: All
A070
Numeric
(20)
Accounts Receivable-Col. B
Accounts Receivable-Col. B (Part II - Line 3, Column b)
Available Years: All
A080
Numeric
(20)
Pledges Receivable-Col. B
Pledges Receivable-Col. B (Part II - Line 4, Column b)
Available Years: All
A090
Numeric
(20)
Grants Receivable-Col. B
Grants Receivable-Col. B (Part II - Line 5, Column b)
Available Years: All
A100
Numeric
(20)
Receivables Due from Officers-Col. B
Receivables Due from Officers-Col. B (Part II - Line 6, Column b)
Available Years: All
A110
Numeric
(20)
Other Notes & Loans Receivable-Col. B
Other Notes & Loans Receivable-Col. B (Part II - Line 7, Column b)
Available Years: All
A120
Numeric
(20)
Inventories-Col. B
Inventories-Col. B (Part II - Line 8, Column b)
Available Years: All
A130
Numeric
(20)
Prepaid Expenses-Col. B
Prepaid Expenses-Col. B (Part II - Line 9, Column b)
Available Years: All
A140
Numeric
(20)
Investments-Government Obligations-Col. B
Investments-Government Obligations-Col. B (Part II - Line 10a, Column b)
Available Years: 1990 - current
A150
Numeric
(20)
Investments-Corporate Stock-Col. B
Investments-Corporate Stock-Col. B (Part II - Line 10b, Column b)
Available Years: 1990 - current
A160
Numeric
(20)
Investments-Corporate Bonds-Col. B
Investments-Corporate Bonds-Col. B (Part II - Lines 10c, Column b)
Available Years: 1990 - current
A170
Numeric
(20)
Investments-Land, Buildings, & Equipment-Col. B
Investments-Land, Buildings, & Equipment-Col. B (Part II - Line 11, Column b)
Available Years: All
A180
Numeric
(20)
Investments-Mortgage Loans-Col. B
Investments-Mortgage Loans-Col. B (Part II - Line 12, Column b)
Available Years: All
A190
Numeric
(20)
Investments-Other-Col. B
Investments-Other-Col. B (Part II - Line 13, Column b)
Available Years: All
A200
Numeric
(20)
Land, Buildings, and Equipment-Col. B
Land, Buildings, and Equipment-Col. B (Part II - Line 14, Column b)
Available Years: All
A210
Numeric
(20)
Other Assets-Col. B
Other Assets-Col. B (Part II - Line 15, Column b)
Available Years: All
A220
Numeric
(20)
Total Assets-Col. B
Total Assets-Col. B (Part II - Line 16, Column b)
Available Years: All
L020
Numeric
(20)
Total Liabilities-Col. B
Total Liabilities-Col. B (Part II - Line 23, Column b)
Available Years: All
N020
Numeric
(20)
Total Fund Balances/Net Worth-Col. B
Total Fund Balances/Net Worth-Col. B (Part II - Line 30, Column b)
Available Years: All
A230
Numeric
(20)
Cash-Col. C
Cash-Col. C (Part II - Line 1, Column c)
Available Years: All
A240
Numeric
(20)
Savings-Col. C
Savings-Col. C (Part II - Line 2, Column c)
Available Years: All
A250
Numeric
(20)
Accounts Receivable-Col. C
Accounts Receivable-Col. C (Part II - Line 3, Column c)
Available Years: All
A260
Numeric
(20)
Pledges Receivable-Col. C
Pledges Receivable-Col. C (Part II - Line 4, Column c)
Available Years: All
A270
Numeric
(20)
Grants Receivable-Col. C
Grants Receivable-Col. C (Part II - Line 5, Column c)
Available Years: All
A280
Numeric
(20)
Receivables Due from Officers-Col. C
Receivables Due from Officers-Col. C (Part II - Line 6, Column c)
Available Years: All
A290
Numeric
(20)
Other Notes & Loans Receivable-Col. C
Other Notes & Loans Receivable-Col. C (Part II - Line 7, Column c)
Available Years: All
A300
Numeric
(20)
Inventories-Col. C
Inventories-Col. C (Part II - Line 8, Column c)
Available Years: All
A310
Numeric
(20)
Prepaid Expenses-Col. C
Prepaid Expenses-Col. C (Part II - Line 9, Column c)
Available Years: All
A320
Numeric
(20)
Investments-Government Obligations-Col. C
Investments-Government Obligations-Col. C (Part II - Line 10a, Column c)
Available Years: 1990 - current
A330
Numeric
(20)
Investments-Corporate Stock-Col. C
Investments-Corporate Stock-Col. C (Part II - Line 10b, Column c)
Available Years: 1990 - current
A340
Numeric
(20)
Investments-Corporate Bonds-Col. C
Investments-Corporate Bonds-Col. C (Part II - Line 10c, Column c)
Available Years: 1990 - current
A350
Numeric
(20)
Investments-Land, Buildings, & Equipment-Col. C
Investments-Land, Buildings, & Equipment-Col. C (Part II - Line 11, Column c)
Available Years: All
A360
Numeric
(20)
Investments-Mortgage Loans-Col. C
Investments-Mortgage Loans-Col. C (Part II - Line 12, Column c)
Available Years: All
A370
Numeric
(20)
Investments-Other-Col. C
Investments-Other-Col. C (Part II - Line 13, Column c)
Available Years: All
A380
Numeric
(20)
Land, Buildings, and Equipment-Col. C
Land, Buildings, and Equipment-Col. C (Part II - Line 14, Column c)
Available Years: All
A390
Numeric
(20)
Other Assets-Col. C
Other Assets-Col. C (Part II - Line 15, Column c)
Available Years: All
A400
Numeric
(20)
Total Assets-Col. C
Total Assets-Col. C (Part II - Line 16, Column c)
Available Years: All
Part III - Analysis of Changes in Net Assets or Fund Balances
B010
Numeric
(20)
Other Net Worth Increases
Other Net Worth Increases (Part III - Line 3)
Available Years: All
B020
Numeric
(20)
Net Worth Decreases
Net Worth Decreases (Part III - Line 5)
Available Years: All
Part IV - Capital Gains and Losses for Tax on Investment Income
R190
Numeric
(20)
Capital Gain Net Income
Capital Gain Net Income (Part IV - Line 2)
Available Years: 1989 - current
Part V - Qualification Under Section 4940(e)
T010
Numeric
(20)
Average Payout Ratio
Average Payout Ratio (Part V - Line 3)
Available Years: All
T020
Numeric
(20)
Net Investment Assets
Net Investment Assets (Part V - Line 4)
Available Years: All
T030
Numeric
(20)
Multiply Line 4 by Line 3
Multiply Line 4 by Line 3 (Part V - Line 5)
Available Years: All
Part VI - Excise Tax Based on Investment Income
T050
Character
(1)
Section 4940 Code
Section 4940 Code (Part VI - Line 1)
Available Years: All
T053
Numeric
(1)
Section 511 Tax
Section 511 Tax (Part VI - Line 2)
Available Years: 2004 - current
T055
Numeric
(1)
Subtitle A Income Tax
Subtitle A Income Tax (Part VI - Line 4)
Available Years: 2001 - current
T060
Numeric
(1)
Tax on Investment Income
Tax on Investment Income (Part VI - Line 5)
Available Years: All
Part VII-A and VII-B - Statements Regarding Activities
Q010
Character
(1)
Unrelated business gross income over $1000 question
Unrelated business gross income over $1000 question (Part VII-A - Question 4a)
Available Years: All
NNo
YYes
Q015
Character
(1)
Filed 990-T question
Filed 990-T question (Part VII-A - Question 4b)
Available Years: 2002 - current
NNo
YYes
Q020
Character
(1)
Contraction question
Contraction question (Part VII-A - Question 5)
Available Years: All
NNo
YYes
Q030
Character
(1)
Claiming status as private operating foundation question
Claiming status as private operating foundation question (Part VII-A - Question 9)
Available Years: All
NNo
YYes
Q130
Character
(1)
Direct indirect ownership of controlled entity question
Direct indirect ownership of controlled entity question (Part VII-A - Question 11)
Available Years: 2006 - current
NNo
YYes
Q140
Character
(1)
Acquire interest in applicable insurance contract question
Acquire interest in applicable insurance contract question (Part VII-A - Question 12)
Available Years: 2006 - 2010
NNo
YYes
Q150
Character
(1)
Distribution to donor advised fund with advisory privileges
Distribution to donor advised fund with advisory privileges question (Part VII-A - Question 12)
Available Years: 2011
NNo
YYes
Q032A
Character
(1)
Property exchange question
Property exchange question (Part VII-B - Question 1a1)
Available Years: 2002 - current
NNo
YYes
Q032B
Character
(1)
Borrow lend money question
Borrow lend money question (Part VII-B - Question 1a2)
Available Years: 2002 - current
NNo
YYes
Q032C
Character
(1)
Furnished goods question
Furnished goods question (Part VII-B - Question 1a3)
Available Years: 2002 - current
NNo
YYes
Q032D
Character
(1)
Paid compensation question
Paid compensation question (Part VII-B - Question 1a4)
Available Years: 2002 - current
NNo
YYes
Q032E
Character
(1)
Transfer question
Transfer question (Part VII-B - Question 1a5)
Available Years: 2002 - current
NNo
YYes
Q032F
Character
(1)
Agree to make pay question
Agree to make pay question (Part VII-B - Question 1a6)
Available Years: 2002 - current
NNo
YYes
Q034
Character
(1)
Acts fail to qualify under section 53.4941(d)-3 question
Acts fail to qualify under section 53.4941(d)-3 question (Part VII-B - Question 1b)
Available Years: 2002 - current
NNo
YYes
Q035
Character
(1)
Rely on notice regarding disaster assistance question
Rely on notice regarding disaster assistance question (Part VII-B - Question 1b checkbox)
Available Years: 2002 - current
NNo
YYes
Q036
Character
(1)
Engage in acts in prior year question
Engage in acts in prior year question (Part VII-B - Question 1c)
Available Years: 2002 - current
NNo
YYes
Q040
Character
(1)
Undistributed income question
Undistributed income question (Part VII-B - Question 2a)
Available Years: 1989 - current
NNo
YYes
Q045
Character
(1)
Not applying section 4942(a)(2) provisions question
Not applying section 4942(a)(2) provisions question (Part VII-B - Question 2b)
Available Years: 2002 - current
NNo
YYes
Q048
Character
(1)
Direct indirect interest in business enterprise question
Direct indirect interest in business enterprise question (Part VII-B - Question 3a)
Available Years: 2002 - current
NNo
YYes
Q050
Character
(1)
Excess business holdings question
Excess business holdings question (Part VII-B - Question 3b)
Available Years: 1989 - current
NNo
YYes
Q052
Character
(1)
Jeopardizing investments question
Jeopardizing investments question (Part VII-B - Question 4a)
Available Years: 2002 - current
NNo
YYes
Q054
Character
(1)
Prior year jeopardizing investments question
Prior year jeopardizing investments question (Part VII-B - Question 4b)
Available Years: 2002 - current
NNo
YYes
Q056A
Character
(1)
Propaganda question
Propaganda question (Part VII-B - Question 5a1)
Available Years: 2002 - current
NNo
YYes
Q056B
Character
(1)
Influence public election question
Influence public election question (Part VII-B - Question 5a2)
Available Years: 2002 - current
NNo
YYes
Q056C
Character
(1)
Grant individual question
Grant individual question (Part VII-B - Question 5a3)
Available Years: 2002 - current
NNo
YYes
Q056D
Character
(1)
Non-charity grant question
Non-charity grant question (Part VII-B - Question 5a4)
Available Years: 2002 - current
NNo
YYes
Q056E
Character
(1)
Non-religious purposes question
Non-religious purposes question (Part VII-B - Question 5a5)
Available Years: 2002 - current
NNo
YYes
Q057
Character
(1)
Transactions fail to qualify under section 53.4945 question
Transactions fail to qualify under section 53.4945 question (Part VII-B - Question 5b)
Available Years: 2002 - current
NNo
YYes
Q058
Character
(1)
Rely on notice regarding disaster assistance question
Rely on notice regarding disaster assistance question (Part VII-B - Question 5b checkbox)
Available Years: 2002 - current
NNo
YYes
Q059
Character
(1)
Expenditure responsibility question
Expenditure responsibility question (Part VII-B - Question 5c)
Available Years: 2002 - current
NNo
YYes
Q060
Character
(1)
Receive funds to pay premiums on personal benefit contract
Receive funds to pay premiums on personal benefit contract question (Part VII-B - Question 6a)
Available Years: 2000 - current
NNo
YYes
Q070
Character
(1)
Pay premiums on personal benefit contract question
Pay premiums on personal benefit contract question (Part VII-B - Question 6b)
Available Years: 2000 - current
NNo
YYes
Part VIII - Officers, Directors, Trustees, Foundation Managers, etc.
C100
Character
(3)
Number of Uncompensated Officers, Directors, etc.
Number of Uncompensated Officers, Directors, etc. (Part VIII - n/a)
Available Years: 1993 - current
H010
Character
(2)
Average Hours Per Week-Emp1
Average Hours Per Week-Emp1 (Part VIII - Line 2, Column b, Row 1)
Available Years: 1993 - current
H020
Numeric
(2)
Compensation-Emp1
Compensation-Emp1 (Part VIII - Line 2, Column c, Row 1)
Available Years: 1993 - current
H030
Numeric
(2)
Contributions to Employee Benefit Plans-Emp1
Contributions to Employee Benefit Plans-Emp1 (Part VIII - Line 2, Column d, Row 1)
Available Years: 1993 - current
H040
Numeric
(2)
Expense Account/Other Allowances-Emp1
Expense Account/Other Allowances-Emp1 (Part VIII - Line 2, Column e, Row 1)
Available Years: 1993 - current
H110
Character
(2)
Average Hours Per Week-Emp2
Average Hours Per Week-Emp2 (Part VIII - Line 2, Column b, Row 2)
Available Years: 1993 - current
H120
Numeric
(2)
Compensation-Emp2
Compensation-Emp2 (Part VIII - Line 2, Column c, Row 2)
Available Years: 1993 - current
H130
Numeric
(2)
Contributions to Employee Benefit Plans-Emp2
Contributions to Employee Benefit Plans-Emp2 (Part VIII - Line 2, Column d, Row 2)
Available Years: 1993 - current
H140
Numeric
(2)
Expense Account/Other Allowances-Emp2
Expense Account/Other Allowances-Emp2 (Part VIII - Line 2, Column e, Row 2)
Available Years: 1993 - current
H210
Character
(2)
Average Hours Per Week-Emp3
Average Hours Per Week-Emp3 (Part VIII - Line 2, Column b, Row 3)
Available Years: 1993 - current
H220
Numeric
(2)
Compensation-Emp3
Compensation-Emp3 (Part VIII - Line 2, Column c, Row 3)
Available Years: 1993 - current
H230
Numeric
(2)
Contributions to Employee Benefit Plans-Emp3
Contributions to Employee Benefit Plans-Emp3 (Part VIII - Line 2, Column d, Row 3)
Available Years: 1993 - current
H240
Numeric
(2)
Expense Account/Other Allowances-Emp3
Expense Account/Other Allowances-Emp3 (Part VIII - Line 2, Column e, Row 3)
Available Years: 1993 - current
H310
Character
(2)
Average Hours Per Week-Emp4
Average Hours Per Week-Emp4 (Part VIII - Line 2, Column b, Row 4)
Available Years: 1993 - current
H320
Numeric
(2)
Compensation-Emp4
Compensation-Emp4 (Part VIII - Line 2, Column c, Row 4)
Available Years: 1993 - current
H330
Numeric
(2)
Contributions to Employee Benefit Plans-Emp4
Contributions to Employee Benefit Plans-Emp4 (Part VIII - Line 2, Column d, Row 4)
Available Years: 1993 - current
H340
Numeric
(2)
Expense Account/Other Allowances-Emp4
Expense Account/Other Allowances-Emp4 (Part VIII - Line 2, Column e, Row 4)
Available Years: 1993 - current
H410
Character
(2)
Average Hours Per Week-Emp5
Average Hours Per Week-Emp5 (Part VIII - Line 2, Column b, Row 5)
Available Years: 1993 - current
H420
Numeric
(2)
Compensation-Emp5
Compensation-Emp5 (Part VIII - Line 2, Column c, Row 5)
Available Years: 1993 - current
H430
Numeric
(2)
Contributions to Employee Benefit Plans-Emp5
Contributions to Employee Benefit Plans-Emp5 (Part VIII - Line 2, Column d, Row 5)
Available Years: 1993 - current
H440
Numeric
(2)
Expense Account/Other Allowances-Emp5
Expense Account/Other Allowances-Emp5 (Part VIII - Line 2, Column e, Row 5)
Available Years: 1993 - current
H500
Character
(3)
Total Number of Other Employees Paid >$50,000
Total Number of Other Employees Paid >$50,000 (Part VIII - Line 2)
Available Years: 1993 - current
Part X - Minimum Investment Return
M010
Numeric
(3)
Line 3 Minus Line 4
Line 3 Minus Line 4 (Part X - Line 5)
Available Years: All
M020
Numeric
(3)
5% of Line 5
5% of Line 5 (Part X - Line 6)
Available Years: All
Part XI - Distributable Amount
M030
Numeric
(3)
Tax on Investment Income
Tax on Investment Income (Part XI - Line 2a)
Available Years: All
M040
Numeric
(3)
Income Tax Under Subtitle A
Income Tax Under Subtitle A (Part XI - Line 2b)
Available Years: All
M050
Numeric
(3)
Recoveries
Recoveries (Part XI - Line 4)
Available Years: All
M070
Numeric
(3)
Deductions from Distributable Amount
Deductions from Distributable Amount (Part XI - Line 6)
Available Years: All
M080
Numeric
(3)
Distributable Amount as Adjusted
Distributable Amount as Adjusted (Part XI - Line 7)
Available Years: All
Part XII - Qualifying Distributions
D010
Numeric
(3)
Expenses, Contributions, Gifts, Etc.
Expenses, Contributions, Gifts, Etc. (Part XII - Line 1a)
Available Years: All
D020
Numeric
(3)
Program Related Investments
Program Related Investments (Part XII - Line 1b)
Available Years: All
D030
Numeric
(3)
Amount Paid To Acquire Assets
Amount Paid To Acquire Assets (Part XII - Line 2)
Available Years: All
D040
Numeric
(3)
Suitability Test
Suitability Test (Part XII - Line 3a)
Available Years: All
D050
Numeric
(3)
Cash Distribution Test
Cash Distribution Test (Part XII - Line 3b)
Available Years: All
D060
Numeric
(3)
Total Qualifying Distributions
Total Qualifying Distributions (Part XII - Line 4)
Available Years: All
Part XIII - Undistributed Income
U010
Numeric
(3)
Prior Excess Distributions Carryover
Prior Excess Distributions Carryover (Part XIII - Line 3f, Column a)
Available Years: All
U020
Numeric
(3)
Distributions Out of Corpus
Distributions Out of Corpus (Part XIII - Line 4c, Column a)
Available Years: All
U030
Numeric
(3)
Remaining Amount Distributed
Remaining Amount Distributed (Part XIII - Line 4e, Column a)
Available Years: All
U040
Numeric
(3)
Excess Distributions Carryover Applied
Excess Distributions Carryover Applied (Part XIII - Line 5, Column a)
Available Years: All
U050
Numeric
(3)
Total Net Corpus
Total Net Corpus (Part XIII - Line 6a, Column a)
Available Years: All
U060
Numeric
(3)
Amounts Treated As Distributions
Amounts Treated As Distributions (Part XIII - Line 7a, Column a)
Available Years: All
U070
Numeric
(3)
Excess Distributions Carryover From 1st Prior Year
Excess Distributions Carryover From 1st Prior Year (Part XIII - Line 8, Column a)
Available Years: All
U080
Numeric
(3)
Excess Distributions Carryover to Next Year
Excess Distributions Carryover to Next Year (Part XIII - Line 9, Column a)
Available Years: All
U085
Numeric
(3)
Undistributed Income - Prior Years
Undistributed Income - Prior Years (Part XIII - Line 2b, Column b)
Available Years: 2002 - current
U090
Numeric
(3)
Applied to Undistributed Income - Prior years
Applied to Undistributed Income - Prior years (Part XIII - Line 4b, Column b)
Available Years: 1990 - current
U094
Numeric
(3)
Prior Years Undistributed Income - Notice issued
Prior Years Undistributed Income - Notice issued (Part XIII - Line 6c, Column b)
Available Years: 2002 - current
U096
Numeric
(3)
Undistributed Income - Taxable Amount
Undistributed Income - Taxable Amount (Part XIII - Line 6d, Column b)
Available Years: 2002 - current
U100
Numeric
(3)
Undistributed Income - Previous Year
Undistributed Income - Previous Year (Part XIII - Line 2a, Column c)
Available Years: 1991 - current
U110
Numeric
(3)
Applied to Undistributed Income - Previous Year
Applied to Undistributed Income - Previous Year (Part XIII - Line 4a, Column c)
Available Years: 1990 - current
U120
Numeric
(3)
Undistributed Income for Prior Years
Undistributed Income for Prior Years (Part XIII - Line 6e, Column c)
Available Years: 1991 - current
U130
Numeric
(3)
Distributable Amount
Distributable Amount (Part XIII - Line 1, Column d)
Available Years: All
U140
Numeric
(3)
Qualifying Distributions Applied
Qualifying Distributions Applied (Part XIII - Line 4d, Column d)
Available Years: All
U150
Numeric
(3)
Undistributed Income
Undistributed Income (Part XIII - Line 6f, Column d)
Available Years: All
Part XIV and Part XVII Data Indicators
Q100
Character
(3)
Part XIV (Operating Foundation Question) filled out?
Part XIV (Operating Foundation Question) filled out? (Part XIV - n/a)
Available Years: All
NNo
YYes
Q200
Character
(3)
Info Re: Transfers/Transactions 1a-c "Yes"?
Info Re: Transfers/Transactions 1a-c "Yes"? (Part XVII - Question 1)
Available Years: 1990 - current
NNo
YYes
Q300
Character
(3)
Info Re: Transfers/Transactions 2a "Yes"?
Info Re: Transfers/Transactions 2a "Yes"? (Part XVII - Question 2a)
Available Years: 1990 - current
NNo
YYes
Part XVI-A - Analysis of Income-Producing Activities
I001
Character
(6)
Program Service (a) Business Code-Col. A
Program Service (a) Business Code-Col. A (Part XVI-A - Line 1a, Column a)
Available Years: 1999 - current
I002
Numeric
(6)
Program Service (a) Amount-Col. B
Program Service (a) Amount-Col. B (Part XVI-A - Line 1a, Column b)
Available Years: 1999 - current
I003
Character
(2)
Program Service (a) Exclusion Code-Col. C
Program Service (a) Exclusion Code-Col. C (Part XVI-A - Line 1a, Column c)
Available Years: 1999 - current
I004
Numeric
(2)
Program Service (a) Amount-Col. D
Program Service (a) Amount-Col. D (Part XVI-A - Line 1a, Column d)
Available Years: 1999 - current
I005
Numeric
(2)
Program Service (a) Amount-Col. E
Program Service (a) Amount-Col. E (Part XVI-A - Line 1a, Column e)
Available Years: 1999 - current
I011
Character
(6)
Program Service (b) Business Code-Col. A
Program Service (b) Business Code-Col. A (Part XVI-A - Line 1b, Column a)
Available Years: 1999 - current
I012
Numeric
(6)
Program Service (b) Amount-Col. B
Program Service (b) Amount-Col. B (Part XVI-A - Line 1b, Column b)
Available Years: 1999 - current
I013
Character
(2)
Program Service (b) Exclusion Code-Col. C
Program Service (b) Exclusion Code-Col. C (Part XVI-A - Line 1b, Column c)
Available Years: 1999 - current
I014
Numeric
(2)
Program Service (b) Amount-Col. D
Program Service (b) Amount-Col. D (Part XVI-A - Line 1b, Column d)
Available Years: 1999 - current
I015
Numeric
(2)
Program Service (b) Amount-Col. E
Program Service (b) Amount-Col. E (Part XVI-A - Line 1b, Column e)
Available Years: 1999 - current
I021
Character
(6)
Program Service (c) Business Code-Col. A
Program Service (c) Business Code-Col. A (Part XVI-A - Line 1c, Column a)
Available Years: 1999 - current
I022
Numeric
(6)
Program Service (c) Amount-Col. B
Program Service (c) Amount-Col. B (Part XVI-A - Line 1c, Column b)
Available Years: 1999 - current
I023
Character
(2)
Program Service (c) Exclusion Code-Col. C
Program Service (c) Exclusion Code-Col. C (Part XVI-A - Line 1c, Column c)
Available Years: 1999 - current
I024
Numeric
(2)
Program Service (c) Amount-Col. D
Program Service (c) Amount-Col. D (Part XVI-A - Line 1c, Column d)
Available Years: 1999 - current
I025
Numeric
(2)
Program Service (c) Amount-Col. E
Program Service (c) Amount-Col. E (Part XVI-A - Line 1c, Column e)
Available Years: 1999 - current
I031
Character
(6)
Program Service (d) Business Code-Col. A
Program Service (d) Business Code-Col. A (Part XVI-A - Line 1d, Column a)
Available Years: 1999 - current
I032
Numeric
(6)
Program Service (d) Amount-Col. B
Program Service (d) Amount-Col. B (Part XVI-A - Line 1d, Column b)
Available Years: 1999 - current
I033
Character
(2)
Program Service (d) Exclusion Code-Col. C
Program Service (d) Exclusion Code-Col. C (Part XVI-A - Line 1d, Column c)
Available Years: 1999 - current
I034
Numeric
(2)
Program Service (d) Amount-Col. D
Program Service (d) Amount-Col. D (Part XVI-A - Line 1d, Column d)
Available Years: 1999 - current
I035
Numeric
(2)
Program Service (d) Amount-Col. E
Program Service (d) Amount-Col. E (Part XVI-A - Line 1d, Column e)
Available Years: 1999 - current
I041
Character
(6)
Program Service (e) Business Code-Col. A
Program Service (e) Business Code-Col. A (Part XVI-A - Line 1e, Column a)
Available Years: 1999 - current
I042
Numeric
(6)
Program Service (e) Amount-Col. B
Program Service (e) Amount-Col. B (Part XVI-A - Line 1e, Column b)
Available Years: 1999 - current
I043
Character
(2)
Program Service (e) Exclusion Code-Col. C
Program Service (e) Exclusion Code-Col. C (Part XVI-A - Line 1e, Column c)
Available Years: 1999 - current
I044
Numeric
(2)
Program Service (e) Amount-Col. D
Program Service (e) Amount-Col. D (Part XVI-A - Line 1e, Column d)
Available Years: 1999 - current
I045
Numeric
(2)
Program Service (e) Amount-Col. E
Program Service (e) Amount-Col. E (Part XVI-A - Line 1e, Column e)
Available Years: 1999 - current
I051
Character
(6)
Program Service (f) Business Code-Col. A
Program Service (f) Business Code-Col. A (Part XVI-A - Line 1f, Column a)
Available Years: 1999 - current
I052
Numeric
(6)
Program Service (f) Amount-Col. B
Program Service (f) Amount-Col. B (Part XVI-A - Line 1f, Column b)
Available Years: 1999 - current
I053
Character
(2)
Program Service (f) Exclusion Code-Col. C
Program Service (f) Exclusion Code-Col. C (Part XVI-A - Line 1f, Column c)
Available Years: 1999 - current
I054
Numeric
(2)
Program Service (f) Amount-Col. D
Program Service (f) Amount-Col. D (Part XVI-A - Line 1f, Column d)
Available Years: 1999 - current
I055
Numeric
(2)
Program Service (f) Amount-Col. E
Program Service (f) Amount-Col. E (Part XVI-A - Line 1f, Column e)
Available Years: 1999 - current
I061
Character
(6)
Program Service (g) Business Code-Col. A
Program Service (g) Business Code-Col. A (Part XVI-A - Line 1g, Column a)
Available Years: 1999 - current
I062
Numeric
(6)
Program Service (g) Amount-Col. B
Program Service (g) Amount-Col. B (Part XVI-A - Line 1g, Column b)
Available Years: 1999 - current
I063
Character
(2)
Program Service (g) Exclusion Code-Col. C
Program Service (g) Exclusion Code-Col. C (Part XVI-A - Line 1g, Column c)
Available Years: 1999 - current
I064
Numeric
(2)
Program Service (g) Amount-Col. D
Program Service (g) Amount-Col. D (Part XVI-A - Line 1g, Column d)
Available Years: 1999 - current
I065
Numeric
(2)
Program Service (g) Amount-Col. E
Program Service (g) Amount-Col. E (Part XVI-A - Line 1g, Column e)
Available Years: 1999 - current
I071
Character
(6)
Membership Business Code-Col. A
Membership Business Code-Col. A (Part XVI-A - Line 2, Column a)
Available Years: 1999 - current
I072
Numeric
(6)
Membership Amount-Col. B
Membership Amount-Col. B (Part XVI-A - Line 2, Column b)
Available Years: 1999 - current
I073
Character
(2)
Membership Exclusion Code-Col. C
Membership Exclusion Code-Col. C (Part XVI-A - Line 2, Column c)
Available Years: 1999 - current
I074
Numeric
(2)
Membership Amount-Col. D
Membership Amount-Col. D (Part XVI-A - Line 2, Column d)
Available Years: 1999 - current
I075
Numeric
(2)
Membership Amount-Col. E
Membership Amount-Col. E (Part XVI-A - Line 2, Column e)
Available Years: 1999 - current
I081
Character
(6)
Interest-Business Code-Col. A
Interest-Business Code-Col. A (Part XVI-A - Line 3, Column a)
Available Years: 1990 - current
I082
Numeric
(6)
Interest-Amount-Col. B
Interest-Amount-Col. B (Part XVI-A - Line 3, Column b)
Available Years: 1990 - current
I083
Character
(2)
Interest-Exclusion Code-Col. C
Interest-Exclusion Code-Col. C (Part XVI-A - Line 3, Column c)
Available Years: 1990 - current
I084
Numeric
(2)
Interest-Amount-Col. D
Interest-Amount-Col. D (Part XVI-A - Line 3, Column d)
Available Years: 1990 - current
I085
Numeric
(2)
Interest-Related or Exempt Income-Col. E
Interest-Related or Exempt Income-Col. E (Part XVI-A - Line 3, Column e)
Available Years: 1990 - current
I091
Character
(6)
Dividends-Business Code-Col. A
Dividends-Business Code-Col. A (Part XVI-A - Line 4, Column a)
Available Years: 1990 - current
I092
Numeric
(6)
Dividends-Amount-Col. B
Dividends-Amount-Col. B (Part XVI-A - Line 4, Column b)
Available Years: 1990 - current
I093
Character
(2)
Dividends-Exclusion Code-Col. C
Dividends-Exclusion Code-Col. C (Part XVI-A - Line 4, Column c)
Available Years: 1990 - current
I094
Numeric
(2)
Dividends-Amount-Col. D
Dividends-Amount-Col. D (Part XVI-A - Line 4, Column d)
Available Years: 1990 - current
I095
Numeric
(2)
Dividends-Related or Exempt Income-Col. E
Dividends-Related or Exempt Income-Col. E (Part XVI-A - Line 4, Column e)
Available Years: 1990 - current
I101
Character
(6)
Rental Income (RE-DF)-Business Code-Col. A
Rental Income (RE-DF)-Business Code-Col. A (Part XVI-A - Line 5a, Column a)
Available Years: 1990 - current
I102
Numeric
(6)
Rental Income (RE-DF)-Amount-Col. B
Rental Income (RE-DF)-Amount-Col. B (Part XVI-A - Line 5a, Column b)
Available Years: 1990 - current
I103
Character
(2)
Rental Income (RE-DF)-Exclusion Code-Col. C
Rental Income (RE-DF)-Exclusion Code-Col. C (Part XVI-A - Line 5a, Column c)
Available Years: 1990 - current
I104
Numeric
(2)
Rental Income (RE-DF)-Amount-Col. D
Rental Income (RE-DF)-Amount-Col. D (Part XVI-A - Line 5a, Column d)
Available Years: 1990 - current
I105
Numeric
(2)
Rental Income (RE-DF)-Related or Exempt Income-Col. E
Rental Income (RE-DF)-Related or Exempt Income-Col. E (Part XVI-A - Line 5a, Column e)
Available Years: 1990 - current
I111
Character
(6)
Rental Income (RE-NDF)-Business Code-Col. A
Rental Income (RE-NDF)-Business Code-Col. A (Part XVI-A - Line 5b, Column a)
Available Years: 1990 - current
I112
Numeric
(6)
Rental Income (RE-NDF)-Amount-Col. B
Rental Income (RE-NDF)-Amount-Col. B (Part XVI-A - Line 5b, Column b)
Available Years: 1990 - current
I113
Character
(2)
Rental Income (RE-NDF)-Exclusion Code-Col. C
Rental Income (RE-NDF)-Exclusion Code-Col. C (Part XVI-A - Line 5b, Column c)
Available Years: 1990 - current
I114
Numeric
(2)
Rental Income (RE-NDF)-Amount-Col. D
Rental Income (RE-NDF)-Amount-Col. D (Part XVI-A - Line 5b, Column d)
Available Years: 1990 - current
I115
Numeric
(2)
Rental Income (RE-NDF)-Related or Exempt Income-Col. E
Rental Income (RE-NDF)-Related or Exempt Income-Col. E (Part XVI-A - Line 5b, Column e)
Available Years: 1990 - current
I121
Character
(6)
Rental Income (PP)-Business Code-Col. A
Rental Income (PP)-Business Code-Col. A (Part XVI-A - Line 6, Column a)
Available Years: 1990 - current
I122
Numeric
(6)
Rental Income (PP)-Amount-Col. B
Rental Income (PP)-Amount-Col. B (Part XVI-A - Line 6, Column b)
Available Years: 1990 - current
I123
Character
(2)
Rental Income (PP)-Exclusion Code-Col. C
Rental Income (PP)-Exclusion Code-Col. C (Part XVI-A - Line 6, Column c)
Available Years: 1990 - current
I124
Numeric
(2)
Rental Income (PP)-Amount-Col. D
Rental Income (PP)-Amount-Col. D (Part XVI-A - Line 6, Column d)
Available Years: 1990 - current
I125
Numeric
(2)
Rental Income (PP)-Related or Exempt Income-Col. E
Rental Income (PP)-Related or Exempt Income-Col. E (Part XVI-A - Line 6, Column e)
Available Years: 1990 - current
I131
Character
(6)
Other Investments-Business Code-Col. A
Other Investments-Business Code-Col. A (Part XVI-A - Line 7, Column a)
Available Years: 1999 - current
I132
Numeric
(6)
Other Investments-Amount-Col. B
Other Investments-Amount-Col. B (Part XVI-A - Line 7, Column b)
Available Years: 1999 - current
I133
Character
(2)
Other Investments-Exclusion Code-Col. C
Other Investments-Exclusion Code-Col. C (Part XVI-A - Line 7, Column c)
Available Years: 1999 - current
I134
Numeric
(2)
Other Investments-Amount-Col. D
Other Investments-Amount-Col. D (Part XVI-A - Line 7, Column d)
Available Years: 1999 - current
I135
Numeric
(2)
Other Investments-Amount-Col. E
Other Investments-Amount-Col. E (Part XVI-A - Line 7, Column e)
Available Years: 1999 - current
I141
Character
(6)
Net Gain(Loss)-Sales of Assets-Business Code-Col. A
Net Gain(Loss)-Sales of Assets-Business Code-Col. A (Part XVI-A - Line 8, Column a)
Available Years: 1990 - current
I142
Numeric
(6)
Net Gain(Loss)-Sales of Assets-Amount-Col. B
Net Gain(Loss)-Sales of Assets-Amount-Col. B (Part XVI-A - Line 8, Column b)
Available Years: 1990 - current
I143
Character
(2)
Net Gain(Loss)-Sales of Assets-Exclusion Code-Col. C
Net Gain(Loss)-Sales of Assets-Exclusion Code-Col. C (Part XVI-A - Line 8, Column c)
Available Years: 1990 - current
I144
Numeric
(2)
Net Gain(Loss)-Sales of Assets-Amount-Col. D
Net Gain(Loss)-Sales of Assets-Amount-Col. D (Part XVI-A - Line 8, Column d)
Available Years: 1990 - current
I145
Numeric
(2)
Net Gain(Loss)-Sales of Assets-Related or Exempt Inc-Col. E
Net Gain(Loss)-Sales of Assets-Related or Exempt Income-Col. E (Part XVI-A - Line 8, Column e)
Available Years: 1990 - current
I151
Character
(6)
Special Events-Business Code-Col. A
Special Events-Business Code-Col. A (Part XVI-A - Line 9, Column a)
Available Years: 1999 - current
I152
Numeric
(6)
Special Events-Amount-Col. B
Special Events-Amount-Col. B (Part XVI-A - Line 9, Column b)
Available Years: 1999 - current
I153
Character
(2)
Special Events-Exclusion Code-Col. C
Special Events-Exclusion Code-Col. C (Part XVI-A - Line 9, Column c)
Available Years: 1999 - current
I154
Numeric
(2)
Special Events-Amount-Col. D
Special Events-Amount-Col. D (Part XVI-A - Line 9, Column d)
Available Years: 1999 - current
I155
Numeric
(2)
Special Events-Amount-Col. E
Special Events-Amount-Col. E (Part XVI-A - Line 9, Column e)
Available Years: 1999 - current
I161
Character
(6)
Gross Profit (Loss)-Sales of Inventory-Business Code-Col. A
Gross Profit (Loss)-Sales of Inventory-Business Code-Col. A (Part XVI-A - Line 10, Column a)
Available Years: 1990 - current
I162
Numeric
(6)
Gross Profit (Loss)-Sales of Inventory-Amount-Col. B
Gross Profit (Loss)-Sales of Inventory-Amount-Col. B (Part XVI-A - Line 10, Column b)
Available Years: 1990 - current
I163
Character
(2)
Gross Profit (Loss)-Sales of Inventory-Exclusion Code-Col. C
Gross Profit (Loss)-Sales of Inventory-Exclusion Code-Col. C (Part XVI-A - Line 10, Column c)
Available Years: 1990 - current
I164
Numeric
(2)
Gross Profit (Loss)-Sales of Inventory-Amount-Col. D
Gross Profit (Loss)-Sales of Inventory-Amount-Col. D (Part XVI-A - Line 10, Column d)
Available Years: 1990 - current
I165
Numeric
(2)
Gross Profit(Loss)-Sales of Invntry-Rel or Exempt Inc-Col. E
Gross Profit (Loss)-Sales of Inventory-Related or Exempt Income-Col. E (Part XVI-A - Line 10, Column e)
Available Years: 1990 - current
I171
Character
(6)
Sum--Other Revenue-Business Code-Col. A
Sum--Other Revenue-Business Code-Col. A (Part XVI-A - Line 11e, Column a)
Available Years: 1990 - current
I172
Numeric
(6)
Sum--Other Revenue-Amount-Col. B
Sum--Other Revenue-Amount-Col. B (Part XVI-A - Line 11e, Column b)
Available Years: 1990 - current
I182
Numeric
(6)
Subtotal-Amount-Col. B
Subtotal-Amount-Col. B (Part XVI-A - Line 12, Column b)
Available Years: 1990 - current
I173
Character
(2)
Sum--Other Revenue-Exclusion Code-Col. C
Sum--Other Revenue-Exclusion Code-Col. C (Part XVI-A - Line 11e, Column c)
Available Years: 1990 - current
I174
Numeric
(2)
Sum--Other Revenue-Amount-Col. D
Sum--Other Revenue-Amount-Col. D (Part XVI-A - Line 11e, Column d)
Available Years: 1990 - current
I184
Numeric
(2)
Subtotal-Amount-Col. D
Subtotal-Amount-Col. D (Part XVI-A - Line 12, Column d)
Available Years: 1990 - current
I175
Numeric
(2)
Sum-lines Other Revenue-Related or Exempt Income-Col. E
Sum-lines Other Revenue-Related or Exempt Income-Col. E (Part XVI-A - Line 11e, Column e)
Available Years: 1990 - current
I185
Numeric
(2)
Subtotal-Related or Exempt Income-Col. E
Subtotal-Related or Exempt Income-Col. E (Part XVI-A - Line 12, Column e)
Available Years: 1990 - current
IRS Internal Processing
WEIGHT
Numeric
(2)
Weight (values range between: 1.00 and 999.99)
Weight (Population estimate multiplier, values range between: 1.00 and 999.99) (Assigned by IRS)
Available Years: All
COMP_CNT
Character
(2)
Count of related records in Compensation Data File
Count of related records in Compensation Data File (Part VIII)
Available Years: 1993 - current
SCPL
Character
(12)
SCPL (Match records to sub-tables using TaxYr and SCPL)
Service Center/Cycle/Page/Line Count (Records are matched to sub-tables using TaxYr and SCPL) (Assigned by IRS)
Available Years: All
COND
Character
(12)
Condition Code
Condition Code (Assigned by IRS)
Available Years: All
IImputed values
LShort-year return
SSubstitute return
Classification
NTEE1
Character
(12)
NTEE major group
NTEE major group (A-Z)
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
NTEECC
Character
(4)
NTEECC primary purpose
NTEECC classification
ntmaj5
Character
(4)
Major subsector
Major subsector (5)
ARArts, culture, and humanities
EDEducation
HEHealth
HUHuman services
OTOther
ntmaj10
Character
(4)
NTEE major group (10)
10 NTEE major groups
ARArts, culture, and humanities
EDEducation
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
ntmaj12
Character
(4)
NTEE major group (12)
12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)
ARArts, culture, and humanities
BHEducation, higher
EDEducation
EHHospitals
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
NTEEconf
Character
(1)
NTEE confidence rating
NTEE classification confidence rating (A/B/C)
MAJGRPB
Character
(1)
Major NTEE group
Major NTEE group plus hospitals and higher education
AA-Arts, Culture & Humanities
BB-Education
BHBH-Higher educ.
CC-Environment
DD-Animal Related
EE-Health - General
EHEH-Hospitals
FF-Mental Health
GG-Health - Disease Specific (general)
HH-Health - Disease Specific (research)
II-Crime, Legal Related
JJ-Employment, Job Related
KK-Food, Agriculture, Nutrition
LL-Housing, Shelter
MM-Public Safety, Disaster Preparedness
NN-Recreation and Sports
OO-Youth Development
PP-Human Services, Multipurpose and Other
QQ-International, Foreign Affairs
RR-Civil Rights/Advocacy
SS-Community Improvement
TT-Philanthropy, Voluntarism
UU-Science and Technology
VV-Social Science
WW-Public, Society Benefit
XX-Religion Related
YY-Mutual/Membership Benefit
ZZ-Unknown, Unclassified
Other Classification
NAICS
Character
(9)
North American Industrial Clas
North American Industrial Classification System
level3
Character
(9)
Major NTEE category
Major NTEE category
ARArts, culture and humanities
EDEducation
ENEnvironment/animals
HEHealth
HSHuman Services
INInternational, foreign affairs
MOOther mutual benefit
MRPension and retirement funds
PBPublic, societal benefit
REReligion related
UNUnknown, unclassified
ZASingle organization support
ZBFundraising within NTEE major group
ZCPrivate grantmaking foundations
ZDPublic foundations
ZEGeneral fundraising
ZFOther Supporting Public Benefit
level4
Character
(9)
NTEE-CC Major Group
NTEE-CC Major Group
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
Miscellaneous
randnum
Numeric
(9)
Random number between 0 and 1
Random number between 0 and 1 used for creating samples