* Core 1992 PF.
VARIABLE LABELSEIN "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."
ZIP5 "First 5 digits of zip code"
ZIP "ZIP code (10 digits)"
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)"
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")."
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
Filer "Filed 990 return within 24 months of BMF file? (Y/N)"
ACTIV1 "First activity code."
P1TCONT "Contributions, gifts, grants, etc., received (Part I, line 1(a))"
P1INTREV "Interest on savings and temporary cash investments (Part I, line 3(a))"
P1DIVID "Dividends and interest from securities (Part I, line 4(a))"
P1NGASTS "Net gain from sale of assets not on line 10 (Part I, line 6a(a))"
P1NLASTS "Net loss from sale of assets not on line 10 (Part I, line 6a(a))"
P1GINVPF "Gross profit or (loss) on sales (gross sales less cost of goods sold) (Part I, line 10c(a))"
P1OTHINC "Other income (Part I, line 11(a))"
P1TOTREV "Total revenue as per books (add lines 1 through 11) (Part I, line 12(a))"
P1OFCOMP "Compensation of officers, directors, trustees, etc. (Part I, line 13(a))"
P1CONTPD "Contributions, gifts, grants paid as per books (Part I, line 25(a))"
P1TOTEXP "Total expenses and disbursements as per books (lines 24 and 25) (Part I, line 26(a))"
P1TEXMEX "Total expenses and disbursements for charitable purposes (cash basis) (lines 24 and 25) (Part I, line 26(d))"
P1EXCREV "Excess of revenue over expenses and disbursements as per books (line 12 minus 26) (Part I, line 27a)"
P1NETINV "Net investment income (line 12 minus 26, enter 0 if negative) (Part I, line 27b)"
P1NADINC "Adjusted net income (line 12 minus 26, enter 0 if negative) (Part I, line 27c)"
P2GVTINV "Investments - U.S. and state government obligations, book value end of year (Part II, line 10a(b))"
P2CRPSTK "Investments - corporate stock, book value end of year (Part II, line 10b(b))"
P2CRPBND "Investments - corporate bonds, book value end of year (Part II, line 10c(b))"
P2TINVSC "Total securities investments, book value end of year (Part II, line 10a(b)+10b(b)+10c(b))"
P2TOTAST "Total assets, book value end of year (Part II, line 16(b))"
P2TASFMV "Total assets, fair market value end of year (Part II, line 16(c))"
P2TLIABL "Total liabilities, book value end of year (add lines 17 through 22) (Part II, line 23(b))"
P6EXMPF "Exempt operating foundation described in section 4940(d)(2)? (Part VI, line 1)"
P6DOMORG "Domestic organization that meets section 4940(e) requirements in Part V? (Part VI, line 1)"
P1TEXCTX "Total excise tax based on investment income (Part VI, line 5)"
P7POLIT "During the year, did the organization attempt to influence any national, state, or local legislation or did it participate or intervene in any political campaign? (Part VII-A, line 1a)"
P7LIQUID "Was there a liquidation, termination, dissolution, or substantial contraction during the year? (Part VII-A, line 5)"
P7POFCLM "Is the org. claiming status as a private operating foundation within the meaning of section 4942(j)(3) or 4942(j)(5) for calendar year xxxx or taxable year beginning in xxxx? (Part VII-A, line 9)"
P7DISSAL "During the year did the organization engage in the sale or exchange, or leasing of property with a disqualified person? (Part VII-B, line 1a(1))"
P7DISBOR "During the year did the organization borrow money from, lend money to, or otherwise extend credit to (or accept it from) a disqualified person? (Part VII-B, line 1a(2))"
P7DISSER "During the year did the organization furnish goods, services, or facilities to (or accept them from) a disqualified person? (Part VII-B, line 1a(3))"
P7DISPAY "During the year did the organization pay compensation to or pay or reimburse the expenses of a disqualified person? (Part VII-B, line 1a(4))"
P7DISTRA "During the year did the organization transfer any income or assets to a disqualified person? (Part VII-B, line 1a(5))"
P7PAYGVT "During the year did the organization agree to pay money or property to a government official? (Part VII-B, line 1a(6))"
P7UNDINC "At the end of the tax year, did the organization have any undistributed income for the tax years before the current tax year? (Part VII-B, line 2a)"
P7BUSINT "Did the organization hold more than a 2% direct or indirect interest in any business enterprise at any time during the year? (Part VII-B, line 3a)"
P7JEOINV "Did the organization invest during the year any amount in a manner that would jeaopardize its charitable purposeses? (Part VII-B, line 4a)"
P7PROPAG "Did the organization pay to carry on propaganda, or otherwise attempt to influence legislation? (Part VII-B, line 5a(1))"
P7ELECT "Did the organization influence the outcome of any specific public election or to carry on any voter registration drive? (Part VII-B, line 5a(2))"
P7INDGRT "Did the organization provide a grant to an individual for travel, study, or other similar purposes? (Part VII-B, line 5a(3))"
P7ORGGRT "Did the organization provide a grant to an organization other than charity, etc. described in section 509(a)(1), (2) or (3) or section 4940(d)(2)? (Part VII-B, line 5a(4))"
P7OTHPUR "Did the organization provide for any purpose other than religious, charitable, scientific, literary or educational purposes, or for the prevention of cruelty to children or animals? (Part VII-B, line 5a(5))"
P10MIR "Minimum investment return: 5% of line 5, net value of noncharitable-use assets (Part X, line 6)"
P13UNDST "Undistributed income for xxxx. This amount must be distributed in following year. (Part XIII, line 6f(d))"
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"
REASON "Reason why org. not private foundation (Sched. A, Pt.IV)"
Q78A "Unrelated business income of $1,000 or more?, Line 78a"
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"
"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)"
"0" "Unknown"
.
VALUE LABELS Filer
"Y" "Yes"
"N" "No"
.
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"
"14" "Governmental unit"
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"12" "Hospital or medical research organization"
"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)"
"21" "Supporting Organization 509(a)(3) Type I"
"22" "Supporting Organization 509(a)(3) Type II"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
.
VALUE LABELS FRCD
"00" "Not required to file (all other)"
"14" "Not required to file - State Instrumentality or Political Subdivision"
"13" "Not required to file - Religious Organization"
"06" "Not required to file - Church"
"02" "Required to file 990N (gross receipts less than $25,000)"
"01" "Required to file 990 (all other) or 990EZ"
"07" "Required to file 990 - Government 501 ( c) (1)"
"03" "Required to file 990 - Group Return"
"04" "Required to file 990BL - Black Lung Trust"
.
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 nteeFinal1
"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 P6DOMORG
"Y" "Yes"
"N" "No"
.
VALUE LABELS P6EXMPF
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7BUSINT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISBOR
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISPAY
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISSAL
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISSER
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISTRA
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7ELECT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7INDGRT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7JEOINV
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7LIQUID
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7ORGGRT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7OTHPUR
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7PAYGVT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7POFCLM
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7POLIT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7PROPAG
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7UNDINC
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q78A
"Y" "Yes"
"N" "No"
.
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."
"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"
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
.
VALUE LABELS SUBSEC
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"11" "11- Teachers retirement fund associations."
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"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."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"02" "02- Title holding corporation for a tax-exempt organization."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"19" "19- Post or organization of war veterans."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"22" "22- Multiemployer Pension Plan"
"23" "23- Veterans association formed prior to 1880"
"24" "24-Trust described in Section 4049 of ERISA"
"25" "25- Title Holding Company for Pensions, etc"
"90" "90- 4947(a)(2) Split Interest Trust"
"80" "80- Farmers' Cooperatives"
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"92" "92- 4947(a)(1) Private Foundations"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"40" "40- Apostolic and religious orgs. - 501(d)"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"70" "70- Child Care Organization - 501(k)"
"71" "71- Charitable Risk Pool"
"81" "81- Qualified State-Sponsored Tuition Program"
"82" "82- 527 Political Organizations"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
.
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.
.