* BMF 08/1995 501c3.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ADDRESS "Street address"
CITY "City"
ZIP "ZIP code."
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)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
Filer "Filed 990 return within 24 months of BMF file? (Y/N)"
ORGTYPCD "Org.type (F=private foundation, C=charity, T=trust, O=other exempt org.)"
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"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
INCOME "Gross receipts from most recently filed Form 990"
ASSETS "Total assets (end of year) from most recent Form 990"
cFiler "Filed 990 return within 24 months of BMF file date? (Y/N)"
cTaxPer "Ending date for tax period of NCCS financial data in yyyymm format."
cTotRev "Total Revenue from most recent Form 990 (Part I, line 12 on Form 990; Part I, line 9 on Form 990-EZ; or Part I, line 12(a) on Form 990-PF)"
cAssets "Total Assets (Book Value at end of year) from most recent Form 990 (Part IV, line 59(B) on Form 990; Part II, line 25(B) on Form 990-EZ; or Part II, line 16(b) on Form 990-PF)"
cFinSrc "Source of financial data added by NCCS (primarily the most recent Form 990 filing as of BMF date from NCCS Core files)"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
AFCD "Affiliation code"
SEC_NAME "Secondary organization name"
CONTACT "Contact person (from IRS files)"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
CLASSCD "IRS Classification code"
v_errorCd "Code for possible error"
RandNum "Random number between 0 and 1 used for creating samples"
.

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

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
activ1 a3
ein a9
name a70
sec_name a35
contact a35
address a35
city a22
state a2
zip a10
ruledate a6
classcd a4
afcd a1
fndncd a2
subseccd a2
Assets f15.0
Income f15.0
prfndncd a4
activ2 a3
activ3 a3
zip5 a10
fips a5
msa_nech a4
pmsa a4
NTEECC a5
NteeCC4d a2
NTEEconf a1
ntee1 a1
NTEE a4
zipnew a5
fipsold a5
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
ORGTYPCD a1
ORGCD a1
v_errorCd a1
FILER a1
zFiler a1
NteeDraft a4
taxper a6
cAssets f15.0
cTotRev f15.0
cTaxPer a6
cFinSrc a10
cFiler a1
czFiler a1
NteeOldB a5
Ntee2007a a5
Confidence2007a a1
RandNum f15.0
nteeFinal a5
nteeFinal1 a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.