* SOI 2006 990EZ c3.

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)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
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"
GOZA "Gulf Opportunity Zone indicator"
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"
Q222 "The organization was a party to a prohibited tax shelter transaction, (EZ) line 40e"
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"
S072 "The organization received or held an easement for conservation purposes, including easements to preserve open space, the environment, historic land areas or historic structures (Sch A, Part III), line 3c"
S074 "The organization provided credit counseling, debt management, credit repair, or debt negotiation services (Sch A, Part III), line 3d"
S076 "The organization maintained any donor advised funds (Sch A, Part III), line 4a"
S078 "The organization made any taxable distributions under section 4966 (Sch A, Part III), line 4b"
S080 "The organization made a distribution to a donor, donor advisor, or related person (4958 distributions) (Sch A, Part III), line 4c"
S090 "Total number of donor advised funds owned at the end of the tax year (Sch A, Part III), line 4d"
S092 "Aggregate value of assets held in all donor advised funds owned at the end of the tax year (Sch A, Part III), line 4e"
S094 "Total number of separate funds or accounts owned at the end of the tax year (excluding donor advised funds included on line 4d) where donors have the right to provide advice on the distribution or investment of amounts in such funds or accounts (Sch A, Part III), line 4f"
S096 "Aggregate value of assets held in all funds or accounts included on line 4f at the end of the tax year (Sch A, Part III), line 4g"
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)"
S120 "Total amount of support from supporting organization to supported organizations (Sch A, Part IV, line 13 Support Schedule, sum of column (e) - total)"
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"
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 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 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.
.