* SOI 2005 990EZ Other.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
NAICS "NAICS Code"
E010 "Accounting Period (year and month)"
E050 "Organization type - IRS subsection code number"
zip5 "First 5 digits of zip code"
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)"
PMSA "Primary Metropolitan Statistical Area"
OutNCCS "Flag for out-of-scope organizations"
OutReas "Reason why out of scope"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
MajGrpB "Major NTEE group plus hospitals and higher education"
level1 "Public charity or private foundation?"
level2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NTEESOI "NTEE assigned by IRS SOI Division"
R040 "Total contributions, (EZ) line 1"
R050 "Program service revenue, (EZ) line 2"
R060 "Membership dues and assessments,line 3. (Includes only portion of dues for which member directly benefits. "Dues" to public charities are often more accurately reported as Contributions.)"
RZ100 "Investment income, (EZ) line 4"
RZ200 "Gross Amt From Sale of Assets, (EZ) line 5a"
RZ300 "Cost or Other Basis, (EZ) line 5b"
R190 "Total gain (or loss), sale of assets other than inventory, (EZ) line 5c"
R200 "Gross revenue from special events, (EZ) line 6a"
R210 "Direct expenses other than fundraising for special events, (EZ) line 6b"
R220 "Net income/loss from special events, (EZ) line 6c"
R230 "Gross sales of inventory less returns and allowances, line (EZ) 7a"
R240 "Cost of goods sold, line (EZ) 7b"
R250 "Gross profit/loss from sales of inventory, (EZ) line 7c"
R260 "Other revenue, (EZ) line 8"
R270 "Total revenue, (EZ) line 9"
XZ100 "Grants and Similar Amounts Paid, (EZ) line 10"
F020 "Benefits paid to or for members, (EZ) line 11"
XZ200 "Salaries, Compensation and Employee Benefits, (EZ) line 12"
XZ300 "Professional fees and other payments, (EZ) line 13"
XZ400 "Occupancy, Rent, Utilitites, Maintenance, (EZ) line 14"
XZ500 "Printing, Publications, Postage, Shipping, (EZ) line 15"
XZ600 "Total Other Expenses, (EZ) line 16"
X050 "Total expenses, (EZ) line 17"
N010 "Net income (excess or deficit) for the year, (EZ) line 18"
N020 "Net assets or fund balance at beginning of year, (EZ) line 19"
N030 "Other changes in net assets or fund balances, (EZ) line 20"
N040 "Net assets or fund balance at end-of-year, (EZ) line 21"
AZ101 "Cash, savings, and investments at beginning-of-year, (EZ) Column A - line 22"
AZ100 "Cash, savings, and investments at end-of-year, (EZ) Column B - line 22"
A023 "Land, buildings, & equipment at beginning-of-year, (EZ) Column A - line 23"
A160 "Land, buildings, & equipment at end-of-year, (EZ) Column B - line 23"
AZ201 "Other Assets at beginning-of-year, (EZ) Column A - line 24"
AZ200 "Other Assets at end-of-year, (EZ) Column B - line 24"
A030 "Total assets at beginning-of-year, (EZ) Column A - line 25"
A180 "Total assets at end-of-year, (EZ) Column B - line 25"
L010 "Total liabilities at beginning-of-year, (EZ) Column A - line 26"
L090 "Total liabilities at end-of-year, (EZ) Column B - line 26"
B010 "Total fund balances or net assets at beginning-of-year, (EZ) Column A - line 27"
B020 "Total fund balances or net assets at end-of-year, (EZ) Column B - line 27"
Q020 "Filed Form 990-T, (EZ) line 35(b)"
Q030 "Liquidation, dissolution, termination, or substantial contraction during the year, (EZ) line 36"
Q050 "Amount of direct and indirect political expenditures, (EZ) line 37a"
Q060 "Filed Form 1120-POL, (EZ) line 37b"
Q150 "501(c)(7): initiation fees and capital contributions, (EZ) line 39a"
Q160 "501(c)(7): gross receipts from public use of facilities, (EZ) line 39b"
Q170 "501(c)(3): tax paid under section 4911, (EZ) line 40a(1)"
Q180 "501(c)(3): tax paid under section 4912, (EZ) line 40a(2)"
Q190 "501(c)(3): tax paid under section 4955, (EZ) line 40a(3)"
Q200 "501(c)(3) or (4): engage in section 4958 excess benefit transaction, (EZ) line 40b"
Q210 "501(c)(3) or (4): tax imposed on managers or disqualified persons under section 4912, 4955, & 4958, (EZ) line 40c"
Q220 "501(c)(3) or (4): amount of 4912, 4955, or 4958 tax reimbursed by organization, (EZ) line 40d"
S001 "Compensation (Sch A, Part I), Column C - line a"
S002 "Contributions to employee benefit plans (Sch A, Part I), Column D - line a"
S003 "Expense account and other allowances (Sch A, Part I), Column E - line a"
S011 "Compensation (Sch A, Part I), Column C - line b"
S012 "Contributions to employee benefit plans (Sch A, Part I), Column D - line b"
S013 "Expense account and other allowances (Sch A, Part I), Column E - line b"
S021 "Compensation (Sch A, Part I), Column C - line c"
S022 "Contributions to employee benefit plans (Sch A, Part I), Column D - line c"
S023 "Expense account and other allowances (Sch A, Part I), Column E - line c"
S031 "Compensation (Sch A, Part I), Column C - line d"
S032 "Contributions to employee benefit plans (Sch A, Part I), Column D - line d"
S033 "Expense account and other allowances (Sch A, Part I), Column E - line d"
S041 "Compensation (Sch A, Part I), Column C - line e"
S042 "Contributions to employee benefit plans (Sch A, Part I), Column D - line e"
S043 "Expense account and other allowances (Sch A, Part I), Column E - line e"
S050 "Number of other employees paid > $30,000 (Sch A, Part I), Column B"
S070 "Expenses paid for legislative activities (Sch A, Part III), line 1"
S100 "Reason for non-private foundation status (Sch A, Part IV)"
S110 "Type of organization that supports organizations described in: 1) lines 5 through 12 above; or 2) sections 501(c)(4),(5) or (6) (Sch A, Part IV, line 13 checkboxes)"
S200 "Gifts, grants, and contributions received (Sch A, Part IV-A), Column A - line 15"
S205 "Gifts, grants, and contributions received (Sch A, Part IV-A), Column E - line 15"
S210 "Membership fees received (Sch A, Part IV-A), Column A - line 16"
S215 "Membership fees received (Sch A, Part IV-A), Column E - line 16"
S220 "Gross receipts related to exempt purpose (Sch A, Part IV-A), Column A - line 17"
S225 "Gross receipts related to exempt purpose (Sch A, Part IV-A), Column E - line 17"
S230 "Gross investment, rent, royalty, and UBIT income (Sch A, Part IV-A), Column A - line 18"
S235 "Gross investment, rent, royalty, and UBIT income (Sch A, Part IV-A), Column E - line 18"
S240 "Net income from unrelated business activities (Sch A, Part IV-A), Column A - line 19"
S245 "Net income from unrelated business activities (Sch A, Part IV-A), Column E - line 19"
S250 "Tax revenues (Sch A, Part IV-A), Column A - line 20"
S255 "Tax revenues (Sch A, Part IV-A), Column E - line 20"
S260 "Value of services furnished by government (Sch A, Part IV-A), Column A - line 21"
S265 "Value of services furnished by government (Sch A, Part IV-A), Column E - line 21"
S270 "Other income (Sch A, Part IV-A), Column A - line 22"
S275 "Other income (Sch A, Part IV-A), Column E - line 22"
S280 "Total (Sch A, Part IV-A), Column A - line 23"
S285 "Total (Sch A, Part IV-A), Column E - line 23"
S290 "Total minus gross receipts (Sch A, Part IV-A), Column A - line 24"
S295 "Total minus gross receipts (Sch A, Part IV-A), Column E - line 24"
S300 "1% of line 24 (Sch A, Part IV-A), Column A - line 25"
S510 "Lobbying to influence public opinion (Sch A, Part VI-A), line 36b"
S520 "Lobbying to influence legislative body (Sch A, Part VI-A), line 37b"
S530 "Total lobbying (Sch A, Part VI-A), line 38b"
S540 "Other exempt purpose expenditures (Sch A, Part VI-A), line 39b"
S550 "Total exempt purpose expenditures (Sch A, Part VI-A), line 40b"
S560 "Lobbying nontaxable amount (Sch A, Part VI-A), line 41b"
S570 "Grassroots nontaxable amount (Sch A, Part VI-A), line 42b"
S580 "Excess grass roots expenditures: line 36b less line 42b (Sch A, Part VI-A), line 43b"
S590 "Excess lobbying expenditures: line 38b less line 41b (Sch A, Part VI-A), line 44b"
GOZA "Gulf Opportunity Zone indicator"
EZ_IND "Form 990-EZ Indicator (Y=EZ)"
SCPL "S.C./Cycle/Page/L.C."
SAMP_CD "Sample code"
DLN "Document Locator Number used by the IRS"
COND "Condition Code"
SAM_CNT "Sample count"
COMP_CNT "Number of rows in compensation sub-table"
POP_CNT "Population count"
WEIGHT "Weight"
RandNum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS COND
"A" "Amended return"
"F" "Final return"
"G" "Group return"
"S" "Separate return "
.
VALUE LABELS EZ_IND
"Y" "Yes"
"N" "No"
.
VALUE LABELS GOZA
"Z" "Z - General GOZA statement"
"H" "H - Specific Hurricane named"
.
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 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 Q020
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q030
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q060
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q200
"Y" "Yes"
"N" "No"
.
VALUE LABELS SAMP_CD
"31" "501(c)(3) Public Charity: Assets under $500,000"
"32" "501(c)(3) Public Charity: Assets $500,000 under $1,000,000"
"33" "501(c)(3) Public Charity: Assets $1,000,000 under $2,500,000"
"34" "501(c)(3) Public Charity: Assets $2,500,000 under $5,000,000"
"35" "501(c)(3) Public Charity: Assets $5,000,000 under $20,000,000"
"36" "501(c)(3) Public Charity: Assets $20,000,000 under $50,000,000"
"37" "501(c)(3) Public Charity: Assets $50,000,000 or more"
"41" "501(c)(4)-(9): Assets under $150,000"
"42" "501(c)(4)-(9): Assets $150,000 under $300,000"
"43" "501(c)(4)-(9): Assets $300,000 under $1,000,000"
"44" "501(c)(4)-(9): Assets $1,000,000 under $4,000,000"
"45" "501(c)(4)-(9): Assets $4,000,000 under $10,000,000"
"46" "501(c)(4)-(9): Assets $10,000,000 or more"
"21" "Charitable Trust: Assets under $100,000"
"22" "Charitable Trust: Assets $100,000 under $1,000,000"
"23" "Charitable Trust: Assets $1,000,000 or more"
"11" "501(c)(3) Private Foundation: Assets under $125,000"
"12" "501(c)(3) Private Foundation: Assets $125,000 under $400,000"
"13" "501(c)(3) Private Foundation: Assets $400,000 under $1,000,000"
"14" "501(c)(3) Private Foundation: Assets $1,000,000 under $2,500,000"
"15" "501(c)(3) Private Foundation: Assets $2,500,000 under $10,000,000"
"16" "501(c)(3) Private Foundation: Assets $10,000,000 under $25,000,000"
"17" "501(c)(3) Private Foundation: Assets $25,000,000 or more"
"38" "501(c)(3) All E-Filed 990 hospital returns (SOI 2009 and later)"
.

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.
.