* SOI 2011 990PF All Years.

VARIABLE LABELS
TaxYr "SOI Sample Tax Year (Records are matched to sub-tables using TaxYr and SCPL) (Top of form - Form Tax Year)
Available Years: All"
EIN "Employer Identification Number (Top of form - Box A)
Available Years: All"
E010 "Accounting Period (Top of form - Accounting Period)
Available Years: All"
NAME "Name of Organization (Top of form - Name of foundation)
Available Years: All"
STATE "State (Top of form - State)
Available Years: All"
zip5 "Zip code (Top of form - Zip Code)
Available Years: All (missing values found 1985-1998)"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
MSA_NECH "Metropolitan Statistical Area (NCCS file) (list)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
E005 "Return Status Code (Top of form - Box G)
Available Years: All"
E050 "Type of Foundation Code (Top of form - Box H)
Available Years: All"
E090 "Accounting Method (Top of form - Box J)
Available Years: 1990 - current"
E070 "507(b)1(A) Termination (Top of form - Box E)
Available Years: All"
E100 "Fair Market Value of Assets (Top of form - Box I)
Available Years: All"
R010 "Contributions, Gifts, Grants, Etc. Received (Part I - Line 1, Column a)
Available Years: All"
R020 "Interest (Part I - Line 3, Column a)
Available Years: All"
R030 "Dividends (Part I - Line 4, Column a)
Available Years: All"
R040 "Gross Rents (Part I - Line 5a, Column a)
Available Years: All"
R050 "Net Gain (Loss) from Sale of Assets (Part I - Line 6a, Column a)
Available Years: All"
R060 "Gross Profit (Loss) from Business Activities (Part I - Line 10c, Column a)
Available Years: All"
R070 "Other Income (Loss) (Part I - Line 11, Column a)
Available Years: All"
R080 "Total Income (Loss) Col. A (Part I - Line 12, Column a)
Available Years: All"
X010 "Compensation of Officers-Col. A (Part I - Line 13, Column a)
Available Years: All"
X020 "Other Salaries and Wages-Col. A (Part I - Line 14, Column a)
Available Years: All"
X030 "Pension Plans-Col. A (Part I - Line 15, Column a)
Available Years: All"
X040 "Legal Fees-Col. A (Part I - Line 16a, Column a)
Available Years: All"
X050 "Accounting Fees-Col. A (Part I - Line 16b, Column a)
Available Years: All"
X060 "Other Professional Fees-Col. A (Part I - Line 16c, Column a)
Available Years: All"
X070 "Interest-Col. A (Part I - Line 17, Column a)
Available Years: All"
X080 "Taxes-Col. A (Part I - Line 18, Column a)
Available Years: All"
X090 "Depreciation & Depletion (Part I - Line 19, Column a)
Available Years: All"
X100 "Occupancy-Col. A (Part I - Line 20, Column a)
Available Years: All"
X110 "Travel, Conferences, Meetings-Col. A (Part I - Line 21, Column a)
Available Years: All"
X120 "Printing and Publications-Col. A (Part I - Line 22, Column a)
Available Years: All"
X130 "Other Expenses-Col. A (Part I - Line 23, Column a)
Available Years: All"
X140 "Contributions, Gifts, Grants Paid-Col. A (Part I - Line 25, Column a)
Available Years: All"
X150 "Total Expenses-Col. A (Part I - Line 26, Column a)
Available Years: All"
X160 "Excess Revenue Over Expenses (Part I - Line 27a, Column a)
Available Years: All"
R090 "Capital Gain Net Income (Part I - Line 7b, Column b)
Available Years: All"
R100 "Total Income (Loss) Col. B (Part I - Line 12, Column b)
Available Years: All"
X170 "Total Expenses-Col. B (Part I - Line 26, Column b)
Available Years: All"
X180 "Net Investment Income (Part I - Line 27b, Column b)
Available Years: All"
X190 "Compensation of Officers-Col. D (Part I - Line 13, Column d)
Available Years: All"
X200 "Other Salaries and Wages-Col. D (Part I - Line 14, Column d)
Available Years: All"
X210 "Pension Plans-Col. D (Part I - Line 15, Column d)
Available Years: All"
X220 "Legal Fees-Col. D (Part I - Line 16a, Column d)
Available Years: All"
X230 "Accounting Fees-Col. D (Part I - Line 16b, Column d)
Available Years: All"
X240 "Other Professional Fees-Col. D (Part I - Line 16c, Column d)
Available Years: All"
X250 "Interest-Col. D (Part I - Line 17, Column d)
Available Years: All"
X260 "Taxes-Col. D (Part I - Line 18, Column d)
Available Years: All"
X270 "Occupancy-Col. D (Part I - Line 20, Column d)
Available Years: All"
X280 "Travel, Conferences, Meetings-Col. D (Part I - Line 21, Column d)
Available Years: All"
X290 "Printing and Publications-Col. D (Part I - Line 22, Column d)
Available Years: All"
X300 "Other Expenses-Col. D (Part I - Line 23, Column d)
Available Years: All"
X310 "Contributions, Gifts, Grants Paid-Col. D (Part I - Line 25, Column d)
Available Years: All"
X320 "Total Expenses-Col. D (Part I - Line 26, Column d)
Available Years: All"
A001 "Cash-Col. A (Part II - Line 1, Column a)
Available Years: 1999 - current"
A002 "Savings-Col. A (Part II - Line 2, Column a)
Available Years: 1999 - current"
A003 "Accounts Receivable-Col. A (Part II - Line 3, Column a)
Available Years: 1999 - current"
A004 "Pledges Receivable-Col. A (Part II - Line 4, Column a)
Available Years: 1999 - current"
A005 "Grants Receivable-Col. A (Part II - Line 5, Column a)
Available Years: 1999 - current"
A006 "Receivables Due from Officers-Col. A (Part II - Line 6, Column a)
Available Years: 1999 - current"
A007 "Other Notes & Loans Receivable-Col. A (Part II - Line 7, Column a)
Available Years: 1999 - current"
A008 "Inventories-Col. A (Part II - Line 8, Column a)
Available Years: 1999 - current"
A009 "Prepaid Expenses-Col. A (Part II - Line 9, Column a)
Available Years: 1999 - current"
A010 "Investments-Government Obligations-Col. A (Part II - Line 10a, Column a)
Available Years: 1990 - current"
A020 "Investments-Corporate Stock-Col. A (Part II - Line 10b, Column a)
Available Years: 1990 - current"
A030 "Investments-Corporate Bonds-Col. A (Part II - Lines 10c, Column a)
Available Years: 1990 - current"
A031 "Investments-Land, Buildings, & Equipment-Col. A (Part II - Line 11, Column a)
Available Years: 1999 - current"
A032 "Investments-Mortgage Loans-Col. A (Part II - Line 12, Column a)
Available Years: 1999 - current"
A033 "Investments-Other-Col. A (Part II - Line 13, Column a)
Available Years: 1999 - current"
A034 "Land, Buildings, and Equipment-Col. A (Part II - Line 14, Column a)
Available Years: 1999 - current"
A035 "Other Assets-Col. A (Part II - Line 15, Column a)
Available Years: 1999 - current"
A040 "Total Assets-Col. A (Part II - Line 16, Column a)
Available Years: All"
L010 "Total Liabilities-Col. A (Part II - Line 23, Column a)
Available Years: All"
N010 "Total Fund Balances/Net Worth-Col. A (Part II - Line 30, Column a)
Available Years: All"
A050 "Cash-Col. B (Part II - Line 1, Column b)
Available Years: All"
A060 "Savings-Col. B (Part II - Line 2, Column b)
Available Years: All"
A070 "Accounts Receivable-Col. B (Part II - Line 3, Column b)
Available Years: All"
A080 "Pledges Receivable-Col. B (Part II - Line 4, Column b)
Available Years: All"
A090 "Grants Receivable-Col. B (Part II - Line 5, Column b)
Available Years: All"
A100 "Receivables Due from Officers-Col. B (Part II - Line 6, Column b)
Available Years: All"
A110 "Other Notes & Loans Receivable-Col. B (Part II - Line 7, Column b)
Available Years: All"
A120 "Inventories-Col. B (Part II - Line 8, Column b)
Available Years: All"
A130 "Prepaid Expenses-Col. B (Part II - Line 9, Column b)
Available Years: All"
A140 "Investments-Government Obligations-Col. B (Part II - Line 10a, Column b)
Available Years: 1990 - current"
A150 "Investments-Corporate Stock-Col. B (Part II - Line 10b, Column b)
Available Years: 1990 - current"
A160 "Investments-Corporate Bonds-Col. B (Part II - Lines 10c, Column b)
Available Years: 1990 - current"
A170 "Investments-Land, Buildings, & Equipment-Col. B (Part II - Line 11, Column b)
Available Years: All"
A180 "Investments-Mortgage Loans-Col. B (Part II - Line 12, Column b)
Available Years: All"
A190 "Investments-Other-Col. B (Part II - Line 13, Column b)
Available Years: All"
A200 "Land, Buildings, and Equipment-Col. B (Part II - Line 14, Column b)
Available Years: All"
A210 "Other Assets-Col. B (Part II - Line 15, Column b)
Available Years: All"
A220 "Total Assets-Col. B (Part II - Line 16, Column b)
Available Years: All"
L020 "Total Liabilities-Col. B (Part II - Line 23, Column b)
Available Years: All"
N020 "Total Fund Balances/Net Worth-Col. B (Part II - Line 30, Column b)
Available Years: All"
A230 "Cash-Col. C (Part II - Line 1, Column c)
Available Years: All"
A240 "Savings-Col. C (Part II - Line 2, Column c)
Available Years: All"
A250 "Accounts Receivable-Col. C (Part II - Line 3, Column c)
Available Years: All"
A260 "Pledges Receivable-Col. C (Part II - Line 4, Column c)
Available Years: All"
A270 "Grants Receivable-Col. C (Part II - Line 5, Column c)
Available Years: All"
A280 "Receivables Due from Officers-Col. C (Part II - Line 6, Column c)
Available Years: All"
A290 "Other Notes & Loans Receivable-Col. C (Part II - Line 7, Column c)
Available Years: All"
A300 "Inventories-Col. C (Part II - Line 8, Column c)
Available Years: All"
A310 "Prepaid Expenses-Col. C (Part II - Line 9, Column c)
Available Years: All"
A320 "Investments-Government Obligations-Col. C (Part II - Line 10a, Column c)
Available Years: 1990 - current"
A330 "Investments-Corporate Stock-Col. C (Part II - Line 10b, Column c)
Available Years: 1990 - current"
A340 "Investments-Corporate Bonds-Col. C (Part II - Line 10c, Column c)
Available Years: 1990 - current"
A350 "Investments-Land, Buildings, & Equipment-Col. C (Part II - Line 11, Column c)
Available Years: All"
A360 "Investments-Mortgage Loans-Col. C (Part II - Line 12, Column c)
Available Years: All"
A370 "Investments-Other-Col. C (Part II - Line 13, Column c)
Available Years: All"
A380 "Land, Buildings, and Equipment-Col. C (Part II - Line 14, Column c)
Available Years: All"
A390 "Other Assets-Col. C (Part II - Line 15, Column c)
Available Years: All"
A400 "Total Assets-Col. C (Part II - Line 16, Column c)
Available Years: All"
B010 "Other Net Worth Increases (Part III - Line 3)
Available Years: All"
B020 "Net Worth Decreases (Part III - Line 5)
Available Years: All"
R190 "Capital Gain Net Income (Part IV - Line 2)
Available Years: 1989 - current"
T010 "Average Payout Ratio (Part V - Line 3)
Available Years: All"
T020 "Net Investment Assets (Part V - Line 4)
Available Years: All"
T030 "Multiply Line 4 by Line 3 (Part V - Line 5)
Available Years: All"
T050 "Section 4940 Code (Part VI - Line 1)
Available Years: All"
T053 "Section 511 Tax (Part VI - Line 2)
Available Years: 2004 - current"
T055 "Subtitle A Income Tax (Part VI - Line 4)
Available Years: 2001 - current"
T060 "Tax on Investment Income (Part VI - Line 5)
Available Years: All"
Q010 "Unrelated business gross income over $1000 question (Part VII-A - Question 4a)
Available Years: All"
Q015 "Filed 990-T question (Part VII-A - Question 4b)
Available Years: 2002 - current"
Q020 "Contraction question (Part VII-A - Question 5)
Available Years: All"
Q030 "Claiming status as private operating foundation question (Part VII-A - Question 9)
Available Years: All"
Q130 "Direct indirect ownership of controlled entity question (Part VII-A - Question 11)
Available Years: 2006 - current"
Q140 "Acquire interest in applicable insurance contract question (Part VII-A - Question 12)
Available Years: 2006 - 2010"
Q150 "Distribution to donor advised fund with advisory privileges question (Part VII-A - Question 12)
Available Years: 2011"
Q032A "Property exchange question (Part VII-B - Question 1a1)
Available Years: 2002 - current"
Q032B "Borrow lend money question (Part VII-B - Question 1a2)
Available Years: 2002 - current"
Q032C "Furnished goods question (Part VII-B - Question 1a3)
Available Years: 2002 - current"
Q032D "Paid compensation question (Part VII-B - Question 1a4)
Available Years: 2002 - current"
Q032E "Transfer question (Part VII-B - Question 1a5)
Available Years: 2002 - current"
Q032F "Agree to make pay question (Part VII-B - Question 1a6)
Available Years: 2002 - current"
Q034 "Acts fail to qualify under section 53.4941(d)-3 question (Part VII-B - Question 1b)
Available Years: 2002 - current"
Q035 "Rely on notice regarding disaster assistance question (Part VII-B - Question 1b checkbox)
Available Years: 2002 - current"
Q036 "Engage in acts in prior year question (Part VII-B - Question 1c)
Available Years: 2002 - current"
Q040 "Undistributed income question (Part VII-B - Question 2a)
Available Years: 1989 - current"
Q045 "Not applying section 4942(a)(2) provisions question (Part VII-B - Question 2b)
Available Years: 2002 - current"
Q048 "Direct indirect interest in business enterprise question (Part VII-B - Question 3a)
Available Years: 2002 - current"
Q050 "Excess business holdings question (Part VII-B - Question 3b)
Available Years: 1989 - current"
Q052 "Jeopardizing investments question (Part VII-B - Question 4a)
Available Years: 2002 - current"
Q054 "Prior year jeopardizing investments question (Part VII-B - Question 4b)
Available Years: 2002 - current"
Q056A "Propaganda question (Part VII-B - Question 5a1)
Available Years: 2002 - current"
Q056B "Influence public election question (Part VII-B - Question 5a2)
Available Years: 2002 - current"
Q056C "Grant individual question (Part VII-B - Question 5a3)
Available Years: 2002 - current"
Q056D "Non-charity grant question (Part VII-B - Question 5a4)
Available Years: 2002 - current"
Q056E "Non-religious purposes question (Part VII-B - Question 5a5)
Available Years: 2002 - current"
Q057 "Transactions fail to qualify under section 53.4945 question (Part VII-B - Question 5b)
Available Years: 2002 - current"
Q058 "Rely on notice regarding disaster assistance question (Part VII-B - Question 5b checkbox)
Available Years: 2002 - current"
Q059 "Expenditure responsibility question (Part VII-B - Question 5c)
Available Years: 2002 - current"
Q060 "Receive funds to pay premiums on personal benefit contract question (Part VII-B - Question 6a)
Available Years: 2000 - current"
Q070 "Pay premiums on personal benefit contract question (Part VII-B - Question 6b)
Available Years: 2000 - current"
C100 "Number of Uncompensated Officers, Directors, etc. (Part VIII - n/a)
Available Years: 1993 - current"
H010 "Average Hours Per Week-Emp1 (Part VIII - Line 2, Column b, Row 1)
Available Years: 1993 - current"
H020 "Compensation-Emp1 (Part VIII - Line 2, Column c, Row 1)
Available Years: 1993 - current"
H030 "Contributions to Employee Benefit Plans-Emp1 (Part VIII - Line 2, Column d, Row 1)
Available Years: 1993 - current"
H040 "Expense Account/Other Allowances-Emp1 (Part VIII - Line 2, Column e, Row 1)
Available Years: 1993 - current"
H110 "Average Hours Per Week-Emp2 (Part VIII - Line 2, Column b, Row 2)
Available Years: 1993 - current"
H120 "Compensation-Emp2 (Part VIII - Line 2, Column c, Row 2)
Available Years: 1993 - current"
H130 "Contributions to Employee Benefit Plans-Emp2 (Part VIII - Line 2, Column d, Row 2)
Available Years: 1993 - current"
H140 "Expense Account/Other Allowances-Emp2 (Part VIII - Line 2, Column e, Row 2)
Available Years: 1993 - current"
H210 "Average Hours Per Week-Emp3 (Part VIII - Line 2, Column b, Row 3)
Available Years: 1993 - current"
H220 "Compensation-Emp3 (Part VIII - Line 2, Column c, Row 3)
Available Years: 1993 - current"
H230 "Contributions to Employee Benefit Plans-Emp3 (Part VIII - Line 2, Column d, Row 3)
Available Years: 1993 - current"
H240 "Expense Account/Other Allowances-Emp3 (Part VIII - Line 2, Column e, Row 3)
Available Years: 1993 - current"
H310 "Average Hours Per Week-Emp4 (Part VIII - Line 2, Column b, Row 4)
Available Years: 1993 - current"
H320 "Compensation-Emp4 (Part VIII - Line 2, Column c, Row 4)
Available Years: 1993 - current"
H330 "Contributions to Employee Benefit Plans-Emp4 (Part VIII - Line 2, Column d, Row 4)
Available Years: 1993 - current"
H340 "Expense Account/Other Allowances-Emp4 (Part VIII - Line 2, Column e, Row 4)
Available Years: 1993 - current"
H410 "Average Hours Per Week-Emp5 (Part VIII - Line 2, Column b, Row 5)
Available Years: 1993 - current"
H420 "Compensation-Emp5 (Part VIII - Line 2, Column c, Row 5)
Available Years: 1993 - current"
H430 "Contributions to Employee Benefit Plans-Emp5 (Part VIII - Line 2, Column d, Row 5)
Available Years: 1993 - current"
H440 "Expense Account/Other Allowances-Emp5 (Part VIII - Line 2, Column e, Row 5)
Available Years: 1993 - current"
H500 "Total Number of Other Employees Paid >$50,000 (Part VIII - Line 2)
Available Years: 1993 - current"
M010 "Line 3 Minus Line 4 (Part X - Line 5)
Available Years: All"
M020 "5% of Line 5 (Part X - Line 6)
Available Years: All"
M030 "Tax on Investment Income (Part XI - Line 2a)
Available Years: All"
M040 "Income Tax Under Subtitle A (Part XI - Line 2b)
Available Years: All"
M050 "Recoveries (Part XI - Line 4)
Available Years: All"
M070 "Deductions from Distributable Amount (Part XI - Line 6)
Available Years: All"
M080 "Distributable Amount as Adjusted (Part XI - Line 7)
Available Years: All"
D010 "Expenses, Contributions, Gifts, Etc. (Part XII - Line 1a)
Available Years: All"
D020 "Program Related Investments (Part XII - Line 1b)
Available Years: All"
D030 "Amount Paid To Acquire Assets (Part XII - Line 2)
Available Years: All"
D040 "Suitability Test (Part XII - Line 3a)
Available Years: All"
D050 "Cash Distribution Test (Part XII - Line 3b)
Available Years: All"
D060 "Total Qualifying Distributions (Part XII - Line 4)
Available Years: All"
U010 "Prior Excess Distributions Carryover (Part XIII - Line 3f, Column a)
Available Years: All"
U020 "Distributions Out of Corpus (Part XIII - Line 4c, Column a)
Available Years: All"
U030 "Remaining Amount Distributed (Part XIII - Line 4e, Column a)
Available Years: All"
U040 "Excess Distributions Carryover Applied (Part XIII - Line 5, Column a)
Available Years: All"
U050 "Total Net Corpus (Part XIII - Line 6a, Column a)
Available Years: All"
U060 "Amounts Treated As Distributions (Part XIII - Line 7a, Column a)
Available Years: All"
U070 "Excess Distributions Carryover From 1st Prior Year (Part XIII - Line 8, Column a)
Available Years: All"
U080 "Excess Distributions Carryover to Next Year (Part XIII - Line 9, Column a)
Available Years: All"
U085 "Undistributed Income - Prior Years (Part XIII - Line 2b, Column b)
Available Years: 2002 - current"
U090 "Applied to Undistributed Income - Prior years (Part XIII - Line 4b, Column b)
Available Years: 1990 - current"
U094 "Prior Years Undistributed Income - Notice issued (Part XIII - Line 6c, Column b)
Available Years: 2002 - current"
U096 "Undistributed Income - Taxable Amount (Part XIII - Line 6d, Column b)
Available Years: 2002 - current"
U100 "Undistributed Income - Previous Year (Part XIII - Line 2a, Column c)
Available Years: 1991 - current"
U110 "Applied to Undistributed Income - Previous Year (Part XIII - Line 4a, Column c)
Available Years: 1990 - current"
U120 "Undistributed Income for Prior Years (Part XIII - Line 6e, Column c)
Available Years: 1991 - current"
U130 "Distributable Amount (Part XIII - Line 1, Column d)
Available Years: All"
U140 "Qualifying Distributions Applied (Part XIII - Line 4d, Column d)
Available Years: All"
U150 "Undistributed Income (Part XIII - Line 6f, Column d)
Available Years: All"
Q100 "Part XIV (Operating Foundation Question) filled out? (Part XIV - n/a)
Available Years: All"
Q200 "Info Re: Transfers/Transactions 1a-c "Yes"? (Part XVII - Question 1)
Available Years: 1990 - current"
Q300 "Info Re: Transfers/Transactions 2a "Yes"? (Part XVII - Question 2a)
Available Years: 1990 - current"
I001 "Program Service (a) Business Code-Col. A (Part XVI-A - Line 1a, Column a)
Available Years: 1999 - current"
I002 "Program Service (a) Amount-Col. B (Part XVI-A - Line 1a, Column b)
Available Years: 1999 - current"
I003 "Program Service (a) Exclusion Code-Col. C (Part XVI-A - Line 1a, Column c)
Available Years: 1999 - current"
I004 "Program Service (a) Amount-Col. D (Part XVI-A - Line 1a, Column d)
Available Years: 1999 - current"
I005 "Program Service (a) Amount-Col. E (Part XVI-A - Line 1a, Column e)
Available Years: 1999 - current"
I011 "Program Service (b) Business Code-Col. A (Part XVI-A - Line 1b, Column a)
Available Years: 1999 - current"
I012 "Program Service (b) Amount-Col. B (Part XVI-A - Line 1b, Column b)
Available Years: 1999 - current"
I013 "Program Service (b) Exclusion Code-Col. C (Part XVI-A - Line 1b, Column c)
Available Years: 1999 - current"
I014 "Program Service (b) Amount-Col. D (Part XVI-A - Line 1b, Column d)
Available Years: 1999 - current"
I015 "Program Service (b) Amount-Col. E (Part XVI-A - Line 1b, Column e)
Available Years: 1999 - current"
I021 "Program Service (c) Business Code-Col. A (Part XVI-A - Line 1c, Column a)
Available Years: 1999 - current"
I022 "Program Service (c) Amount-Col. B (Part XVI-A - Line 1c, Column b)
Available Years: 1999 - current"
I023 "Program Service (c) Exclusion Code-Col. C (Part XVI-A - Line 1c, Column c)
Available Years: 1999 - current"
I024 "Program Service (c) Amount-Col. D (Part XVI-A - Line 1c, Column d)
Available Years: 1999 - current"
I025 "Program Service (c) Amount-Col. E (Part XVI-A - Line 1c, Column e)
Available Years: 1999 - current"
I031 "Program Service (d) Business Code-Col. A (Part XVI-A - Line 1d, Column a)
Available Years: 1999 - current"
I032 "Program Service (d) Amount-Col. B (Part XVI-A - Line 1d, Column b)
Available Years: 1999 - current"
I033 "Program Service (d) Exclusion Code-Col. C (Part XVI-A - Line 1d, Column c)
Available Years: 1999 - current"
I034 "Program Service (d) Amount-Col. D (Part XVI-A - Line 1d, Column d)
Available Years: 1999 - current"
I035 "Program Service (d) Amount-Col. E (Part XVI-A - Line 1d, Column e)
Available Years: 1999 - current"
I041 "Program Service (e) Business Code-Col. A (Part XVI-A - Line 1e, Column a)
Available Years: 1999 - current"
I042 "Program Service (e) Amount-Col. B (Part XVI-A - Line 1e, Column b)
Available Years: 1999 - current"
I043 "Program Service (e) Exclusion Code-Col. C (Part XVI-A - Line 1e, Column c)
Available Years: 1999 - current"
I044 "Program Service (e) Amount-Col. D (Part XVI-A - Line 1e, Column d)
Available Years: 1999 - current"
I045 "Program Service (e) Amount-Col. E (Part XVI-A - Line 1e, Column e)
Available Years: 1999 - current"
I051 "Program Service (f) Business Code-Col. A (Part XVI-A - Line 1f, Column a)
Available Years: 1999 - current"
I052 "Program Service (f) Amount-Col. B (Part XVI-A - Line 1f, Column b)
Available Years: 1999 - current"
I053 "Program Service (f) Exclusion Code-Col. C (Part XVI-A - Line 1f, Column c)
Available Years: 1999 - current"
I054 "Program Service (f) Amount-Col. D (Part XVI-A - Line 1f, Column d)
Available Years: 1999 - current"
I055 "Program Service (f) Amount-Col. E (Part XVI-A - Line 1f, Column e)
Available Years: 1999 - current"
I061 "Program Service (g) Business Code-Col. A (Part XVI-A - Line 1g, Column a)
Available Years: 1999 - current"
I062 "Program Service (g) Amount-Col. B (Part XVI-A - Line 1g, Column b)
Available Years: 1999 - current"
I063 "Program Service (g) Exclusion Code-Col. C (Part XVI-A - Line 1g, Column c)
Available Years: 1999 - current"
I064 "Program Service (g) Amount-Col. D (Part XVI-A - Line 1g, Column d)
Available Years: 1999 - current"
I065 "Program Service (g) Amount-Col. E (Part XVI-A - Line 1g, Column e)
Available Years: 1999 - current"
I071 "Membership Business Code-Col. A (Part XVI-A - Line 2, Column a)
Available Years: 1999 - current"
I072 "Membership Amount-Col. B (Part XVI-A - Line 2, Column b)
Available Years: 1999 - current"
I073 "Membership Exclusion Code-Col. C (Part XVI-A - Line 2, Column c)
Available Years: 1999 - current"
I074 "Membership Amount-Col. D (Part XVI-A - Line 2, Column d)
Available Years: 1999 - current"
I075 "Membership Amount-Col. E (Part XVI-A - Line 2, Column e)
Available Years: 1999 - current"
I081 "Interest-Business Code-Col. A (Part XVI-A - Line 3, Column a)
Available Years: 1990 - current"
I082 "Interest-Amount-Col. B (Part XVI-A - Line 3, Column b)
Available Years: 1990 - current"
I083 "Interest-Exclusion Code-Col. C (Part XVI-A - Line 3, Column c)
Available Years: 1990 - current"
I084 "Interest-Amount-Col. D (Part XVI-A - Line 3, Column d)
Available Years: 1990 - current"
I085 "Interest-Related or Exempt Income-Col. E (Part XVI-A - Line 3, Column e)
Available Years: 1990 - current"
I091 "Dividends-Business Code-Col. A (Part XVI-A - Line 4, Column a)
Available Years: 1990 - current"
I092 "Dividends-Amount-Col. B (Part XVI-A - Line 4, Column b)
Available Years: 1990 - current"
I093 "Dividends-Exclusion Code-Col. C (Part XVI-A - Line 4, Column c)
Available Years: 1990 - current"
I094 "Dividends-Amount-Col. D (Part XVI-A - Line 4, Column d)
Available Years: 1990 - current"
I095 "Dividends-Related or Exempt Income-Col. E (Part XVI-A - Line 4, Column e)
Available Years: 1990 - current"
I101 "Rental Income (RE-DF)-Business Code-Col. A (Part XVI-A - Line 5a, Column a)
Available Years: 1990 - current"
I102 "Rental Income (RE-DF)-Amount-Col. B (Part XVI-A - Line 5a, Column b)
Available Years: 1990 - current"
I103 "Rental Income (RE-DF)-Exclusion Code-Col. C (Part XVI-A - Line 5a, Column c)
Available Years: 1990 - current"
I104 "Rental Income (RE-DF)-Amount-Col. D (Part XVI-A - Line 5a, Column d)
Available Years: 1990 - current"
I105 "Rental Income (RE-DF)-Related or Exempt Income-Col. E (Part XVI-A - Line 5a, Column e)
Available Years: 1990 - current"
I111 "Rental Income (RE-NDF)-Business Code-Col. A (Part XVI-A - Line 5b, Column a)
Available Years: 1990 - current"
I112 "Rental Income (RE-NDF)-Amount-Col. B (Part XVI-A - Line 5b, Column b)
Available Years: 1990 - current"
I113 "Rental Income (RE-NDF)-Exclusion Code-Col. C (Part XVI-A - Line 5b, Column c)
Available Years: 1990 - current"
I114 "Rental Income (RE-NDF)-Amount-Col. D (Part XVI-A - Line 5b, Column d)
Available Years: 1990 - current"
I115 "Rental Income (RE-NDF)-Related or Exempt Income-Col. E (Part XVI-A - Line 5b, Column e)
Available Years: 1990 - current"
I121 "Rental Income (PP)-Business Code-Col. A (Part XVI-A - Line 6, Column a)
Available Years: 1990 - current"
I122 "Rental Income (PP)-Amount-Col. B (Part XVI-A - Line 6, Column b)
Available Years: 1990 - current"
I123 "Rental Income (PP)-Exclusion Code-Col. C (Part XVI-A - Line 6, Column c)
Available Years: 1990 - current"
I124 "Rental Income (PP)-Amount-Col. D (Part XVI-A - Line 6, Column d)
Available Years: 1990 - current"
I125 "Rental Income (PP)-Related or Exempt Income-Col. E (Part XVI-A - Line 6, Column e)
Available Years: 1990 - current"
I131 "Other Investments-Business Code-Col. A (Part XVI-A - Line 7, Column a)
Available Years: 1999 - current"
I132 "Other Investments-Amount-Col. B (Part XVI-A - Line 7, Column b)
Available Years: 1999 - current"
I133 "Other Investments-Exclusion Code-Col. C (Part XVI-A - Line 7, Column c)
Available Years: 1999 - current"
I134 "Other Investments-Amount-Col. D (Part XVI-A - Line 7, Column d)
Available Years: 1999 - current"
I135 "Other Investments-Amount-Col. E (Part XVI-A - Line 7, Column e)
Available Years: 1999 - current"
I141 "Net Gain(Loss)-Sales of Assets-Business Code-Col. A (Part XVI-A - Line 8, Column a)
Available Years: 1990 - current"
I142 "Net Gain(Loss)-Sales of Assets-Amount-Col. B (Part XVI-A - Line 8, Column b)
Available Years: 1990 - current"
I143 "Net Gain(Loss)-Sales of Assets-Exclusion Code-Col. C (Part XVI-A - Line 8, Column c)
Available Years: 1990 - current"
I144 "Net Gain(Loss)-Sales of Assets-Amount-Col. D (Part XVI-A - Line 8, Column d)
Available Years: 1990 - current"
I145 "Net Gain(Loss)-Sales of Assets-Related or Exempt Income-Col. E (Part XVI-A - Line 8, Column e)
Available Years: 1990 - current"
I151 "Special Events-Business Code-Col. A (Part XVI-A - Line 9, Column a)
Available Years: 1999 - current"
I152 "Special Events-Amount-Col. B (Part XVI-A - Line 9, Column b)
Available Years: 1999 - current"
I153 "Special Events-Exclusion Code-Col. C (Part XVI-A - Line 9, Column c)
Available Years: 1999 - current"
I154 "Special Events-Amount-Col. D (Part XVI-A - Line 9, Column d)
Available Years: 1999 - current"
I155 "Special Events-Amount-Col. E (Part XVI-A - Line 9, Column e)
Available Years: 1999 - current"
I161 "Gross Profit (Loss)-Sales of Inventory-Business Code-Col. A (Part XVI-A - Line 10, Column a)
Available Years: 1990 - current"
I162 "Gross Profit (Loss)-Sales of Inventory-Amount-Col. B (Part XVI-A - Line 10, Column b)
Available Years: 1990 - current"
I163 "Gross Profit (Loss)-Sales of Inventory-Exclusion Code-Col. C (Part XVI-A - Line 10, Column c)
Available Years: 1990 - current"
I164 "Gross Profit (Loss)-Sales of Inventory-Amount-Col. D (Part XVI-A - Line 10, Column d)
Available Years: 1990 - current"
I165 "Gross Profit (Loss)-Sales of Inventory-Related or Exempt Income-Col. E (Part XVI-A - Line 10, Column e)
Available Years: 1990 - current"
I171 "Sum--Other Revenue-Business Code-Col. A (Part XVI-A - Line 11e, Column a)
Available Years: 1990 - current"
I172 "Sum--Other Revenue-Amount-Col. B (Part XVI-A - Line 11e, Column b)
Available Years: 1990 - current"
I182 "Subtotal-Amount-Col. B (Part XVI-A - Line 12, Column b)
Available Years: 1990 - current"
I173 "Sum--Other Revenue-Exclusion Code-Col. C (Part XVI-A - Line 11e, Column c)
Available Years: 1990 - current"
I174 "Sum--Other Revenue-Amount-Col. D (Part XVI-A - Line 11e, Column d)
Available Years: 1990 - current"
I184 "Subtotal-Amount-Col. D (Part XVI-A - Line 12, Column d)
Available Years: 1990 - current"
I175 "Sum-lines Other Revenue-Related or Exempt Income-Col. E (Part XVI-A - Line 11e, Column e)
Available Years: 1990 - current"
I185 "Subtotal-Related or Exempt Income-Col. E (Part XVI-A - Line 12, Column e)
Available Years: 1990 - current"
WEIGHT "Weight (Population estimate multiplier, values range between: 1.00 and 999.99) (Assigned by IRS)
Available Years: All"
COMP_CNT "Count of related records in Compensation Data File (Part VIII)
Available Years: 1993 - current"
SCPL "Service Center/Cycle/Page/Line Count (Records are matched to sub-tables using TaxYr and SCPL) (Assigned by IRS)
Available Years: All"
COND "Condition Code (Assigned by IRS)
Available Years: All"
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
NAICS "North American Industrial Classification System"
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS COND
"I" "Imputed values"
"L" "Short-year return"
"S" "Substitute return"
.
VALUE LABELS E005
"F" "F - Final return"
"I" "I - Initial return"
"A" "A - Amended return"
"C" "C - Address Change"
"N" "N - Name Change"
.
VALUE LABELS E050
"E" "E - Private Foundation "
"T" "T - Charitable Trust"
.
VALUE LABELS E070
"Y" "Yes"
"N" "No"
.
VALUE LABELS E090
"C" "Cash"
"A" "Accrual"
"O" "Other"
.
VALUE LABELS LEVEL1
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ZB" "Fundraising within NTEE major group"
"ZA" "Single organization support"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ED" "Education"
"AR" "Arts, culture and humanities"
.
VALUE LABELS level4
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS MAJGRPB
"A" "A-Arts, Culture & Humanities"
"B" "B-Education"
"BH" "BH-Higher educ."
"C" "C-Environment"
"D" "D-Animal Related"
"E" "E-Health - General"
"EH" "EH-Hospitals"
"F" "F-Mental Health"
"G" "G-Health - Disease Specific (general)"
"H" "H-Health - Disease Specific (research)"
"I" "I-Crime, Legal Related"
"J" "J-Employment, Job Related"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"O" "O-Youth Development"
"P" "P-Human Services, Multipurpose and Other"
"Q" "Q-International, Foreign Affairs"
"R" "R-Civil Rights/Advocacy"
"S" "S-Community Improvement"
"T" "T-Philanthropy, Voluntarism"
"U" "U-Science and Technology"
"V" "V-Social Science"
"W" "W-Public, Society Benefit"
"X" "X-Religion Related"
"Y" "Y-Mutual/Membership Benefit"
"Z" "Z-Unknown, Unclassified"
.
VALUE LABELS NTEE1
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS NTEESRC
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"bahrz1" "NCCS - No information found in web search"
"FC" "Foundation Center reclassification"
"ZD" "David Stevenson's reclass. of unclassified"
"ZT" "Temp's review of unclassified, Feb. 97"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"T" "Temps review in Fall 1996 (confidence=B)"
"IV" "Independent verifiers (1996) (confidence=A)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"DS" "David Stevenson's rulings (confidence=A)"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"MD" "Classifcation of Maryland State Attorney General's file"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"KCS" "Classification done for Kansas City newspaper layout"
"SM" "Classification done by ShoShauna Mccoy"
"SOI" "Classification completed during reconciliation of SOI94"
"3YR" "Classification review completed during the data development of the three-year financial project"
"SMP" "Classification review from sampling (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"ALM" "Almanac 2000 edits (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"" "Unknown source (confidence= ?)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZZ" "NCCS expert verified records"
"DD200304-C" "Dig.data auto-coded 4/2003"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"$src" "Auto-generated codes (confidence=C)"
"DD200511" "Digitized data auto-codes"
"Core2004co" "2006 NTEE rules"
.
VALUE LABELS ntmaj10
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
.
VALUE LABELS ntmaj12
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS Q010
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q015
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q020
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q030
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q032A
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q032B
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q032C
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q032D
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q032E
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q032F
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q034
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q035
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q036
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q040
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q045
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q048
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q050
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q052
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q054
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q056A
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q056B
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q056C
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q056D
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q056E
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q057
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q058
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q059
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q060
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q070
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q100
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q130
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q140
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q150
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q200
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q300
"Y" "Yes"
"N" "No"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.