* Core 1997 501(c) others.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
CITY "City."
ZIP "ZIP code (10 digits)"
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 - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)"
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
TAXPER "Ending date for tax period of financial data. Core files for 1997 on are in "yyyymm" format (199412=Dec. 1994). Earlier years use 2-digit year ("9412")."
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
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"
ActivCd1 "IRS Activity Code 1 chosen by organization when it applied for exemption"
ActivCd2 "IRS Activity Code 2 chosen by organization when it applied for exemption"
ActivCd3 "IRS Activity Code 3 chosen by organization when it applied for exemption"
p1tcont "Total contributions"
p1psrev "Program service revenue"
p1dues "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.)"
p1invst "Total invest. inc. (990 lines 4+5+7 OR EZ line 4)"
p1rente "Rental expenses"
p1rentn "Net rental income"
p1invntG "Inventory, gross sales"
p1invntC "Inventory, cost of goods sold"
p1invntN "Inventory, gross profit (net)"
p1securg "Gross amount from sale of assets (securities)"
p1securC "Cost or other basis (securities)"
p1securN "Gain (loss) from sale of securities"
p1othg "Gross amount from sale of assets (other)"
p1othC "Cost or other basis (other)"
p1othN "Net gain (loss) from sale of "other" assets other than inventory"
p1spEvC "Special events - portion of gross reported in line 1a, contributions, & not reported in line 9"
p1spEvE "Special events, direct expenses"
p1spEvN "Special events, net income"
p1othrev "Other revenue"
p1totrev "Total revenue"
p1frexp "Fund-raising expenses"
p1chgas "Other changes in net assets or fund balances"
p1totexp "Total expenses"
p1netInc "Net income ("excess (or deficit) for the year")"
p1naseoy "Net assets or fund balance-end of year"
p2tcomp "Compensation of officers-col. A (total)"
p2twages "Other salaries & wages-col. A (total)"
p2tpytax "Payroll taxes-col. A (total)"
p2tfrfee "Professional fundraising fees-total (col.A)"
p1sales "Sales and receipts, Gross Receipts minus (lines 1d +3)"
p7divrin "Dividends & interest from securities-col. E (related or exempt function income)"
p7estRin "Rental expenses, line 97(d)"
p7intxat "Interest on savings & temp cash invstmt-col. D (excl by s.512,513 or 514, amount)"
p7invRin "Other investment income, line 99(d)"
grossinc "Gross income, Gross Receipts minus (lines 1d + 3 + 8b + 10b)"
grossrec "Gross receipts, Sum of Part I total revenue + 6b + 8b (both columns) + 9b + 10b"
p4b_asst "Total assets- beg. of year"
p4e_asst "Total assets- end of year"
p4b_bond "Tax-exempt bond liabilities- beg. of year"
p4e_bond "Tax-exempt bond liabilities- end of year"
p4b_mort "Mortgages & other notes payable- beg. of year"
p4e_mort "Mortgages & other notes payable- end of year"
p4b_liab "Total liabilities- beg. of year"
p4e_liab "Total liabilities- end of year"
p4e_retn "Retained earns, endowmts, accum. Income- end of year"
p4b_net "Total fund balances or net worth- beginning of year"
p6pubInc "Gross income - general public, line 86b, only for 501(c)(7) organizations"
p6iniFee "Initiation fees, line 86a, only for 501(c)(7) organizations"
p6othInc "Gross income - other sources, line 87b, only for 501(c)(12) organizations"
p6MemInc "Gross income - members, line 87a, only for 501(c)(12) organizations"
p6unrelb "Unrelated business gross income >$1,000 in yr?"
p6polexp "Political expenditures"
a4a_cnT "Gifts, grants, and contributions received (total of last 4 years), Sch A, line 15(e)"
a3lobby "Organization attempted to influence legislation, sch.A.III.1"
a4a_memt "Membership fees received- col. E (total) (Sch.A.IV-A)"
a4a_busT "Gross receipts from business related to charitable purpose- col. E (total) (Sch.A.IV-A,17)"
a4a_ivst "Gross income from investments- col. E (total) (Sch.A.IV-A)"
a4a_taxt "Tax rev. levied on behalf of organization- col. E (total) (Sch.A.IV-A)"
a4a_gvtt "Value of services or facilities furnished by government without charge- col. E (total) (Sch.A.IV-A)"
a4a_otht "Other income- col. E (total) (Sch.A.IV-A)"
a4a_tott "Total of lines 15 to 22- col. E (total) (Sch.A.IV-A)"
a6glbyb "Total grassroots lobbying expenditures- col. B (all elct orgs.)"
a6dlbyb "Total direct lobbying expense- Sch.A.VI-A.37b (all elct orgs.)"
a6tglbb "Subtract line 42 from liine 36 (0 if line 42>line 36)- col. B (all elct orgs.)"
a6nlbeb "Subtract line 38 from line 41 (0 if line 41>line 38)- col. B (all elct orgs.)"
a6nglbb "Maximum grassroots nontaxable amount (25% of line 41)- Sch.A.VI.42b (all elct orgs.)"
a6oexpB "Other exempt purpose expenditures- Sch.A.VI.39b (all elct orgs.)"
a6ntLbb "Maximum nontaxable lobbying amount Sch.A.VI.41b (all elct orgs.)"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
REASON "Reason why org. not private foundation (Sched. A, Pt.IV)"
GEN "Group exemption number"
DISTRICT "IRS District Office"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
LEVEL3 "Major NTEE category"
LEVEL4 "NTEE-CC Major Group"
CLASSCD "IRS Classification code"
ORGCD "Organization code: corporation, trust, association, etc."
RandNum "Random number between 0 and 1 used for creating samples"
ntee2007a "NTEE-CC (2007 draft, v.1)"
.

.
VALUE LABELS LEVEL1
"U" "Unknown"
"O" "Other Nonprofits"
"PF" "Private Foundation"
"PC" "Public Charity"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS LEVEL3
"HE" "Health"
"EN" "Environment/animals"
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ED" "Education"
"ZB" "Fundraising within NTEE major group"
"AR" "Arts, culture and humanities"
"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"
.
VALUE LABELS LEVEL4
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"" "Unknown"
"D" "Animal-Related"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
"L" "Housing, Shelter"
.
VALUE LABELS MAJGRPB
"EH" "EH-Hospitals"
"U" "U-Science and Technology"
"F" "F-Mental Health"
"V" "V-Social Science"
"G" "G-Health - Disease Specific (general)"
"W" "W-Public, Society Benefit"
"H" "H-Health - Disease Specific (research)"
"X" "X-Religion Related"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
"J" "J-Employment, Job Related"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"A" "A-Arts, Culture & Humanities"
"O" "O-Youth Development"
"B" "B-Education"
"P" "P-Human Services, Multipurpose and Other"
"BH" "BH-Higher educ."
"Q" "Q-International, Foreign Affairs"
"C" "C-Environment"
"R" "R-Civil Rights/Advocacy"
"D" "D-Animal Related"
"S" "S-Community Improvement"
"E" "E-Health - General"
"T" "T-Philanthropy, Voluntarism"
.
VALUE LABELS NTEE1
"L" "Housing, Shelter"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"" "Unknown"
"D" "Animal-Related"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
.
VALUE LABELS nteeFinal1
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
"L" "Housing, Shelter"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"" "Unknown"
"D" "Animal-Related"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
.
VALUE LABELS NTEESRC
"$src" "Auto-generated codes (confidence=C)"
"3YR" "Classification review completed during the data development of the three-year financial project"
"DD200511" "Digitized data auto-codes"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"SMP" "Classification review from sampling (confidence=B)"
"" "Unknown source (confidence= ?)"
"Core2004co" "2006 NTEE rules"
"JCC" "Jill Capitani's clean up of the nteelu file"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"ZZ" "NCCS expert verified records"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"CORE02" "Core 2002 codes (04/02/04)"
"DS" "David Stevenson's rulings (confidence=A)"
"DD200304-B" "Dig.data verified 4/2003"
"bahrz1" "NCCS - No information found in web search"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"FC" "Foundation Center reclassification"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"ZD" "David Stevenson's reclass. of unclassified"
"MD" "Classifcation of Maryland State Attorney General's file"
"RTF" "Classification of I.R.S. Return Transaction Files"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"ALM" "Almanac 2000 edits (confidence=A)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
"$src" "Dig.data auto-coded 3/2005"
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
.
VALUE LABELS ntmaj10
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
.
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 ORGCD
"2" "Trust"
"1" "Corporation"
"6" "Non-exempt charitable trust"
"0" "Unknown"
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
.
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"
"T" "T- U.S. Territory or armed forces overseas"
"" "No value"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"4" "4- Not a 501(c)(3)"
.
VALUE LABELS REASON
"01" "Church"
"02" "School"
"03" "Hospital"
"04" "Governmental Unit"
"05" "Medical Research"
"06" "Operated for benefit of college or university owned or operated by governmental unit."
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
"07" "Receives substantial part of support from government unit or general public"
"08" "Community Trust"
"09" "Receives more than 33 1/3% of support from contributions, membership fees"
"10" "Supporting organizations for other exempt orgs"
"11" "Organized and operated to test for public safety"
.
VALUE LABELS SUBSECCD
"23" "23- Veterans association formed prior to 1880"
"71" "71- Charitable Risk Pool"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"24" "24-Trust described in Section 4049 of ERISA"
"81" "81- Qualified State-Sponsored Tuition Program"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"25" "25- Title Holding Company for Pensions, etc"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"19" "19- Post or organization of war veterans."
"90" "90- 4947(a)(2) Split Interest Trust"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"80" "80- Farmers' Cooperatives"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"11" "11- Teachers retirement fund associations."
"82" "82- 527 Political Organizations"
"92" "92- 4947(a)(1) Private Foundations"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"40" "40- Apostolic and religious orgs. - 501(d)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"22" "22- Multiemployer Pension Plan"
"70" "70- Child Care Organization - 501(k)"
"02" "02- Title holding corporation for a tax-exempt organization."
.

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