* Core 2006 PC LA County.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ADDRESS "Address"
CITY "City"
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"
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"
ACTIV "Activity code"
PROGREV "Program service revenue including government fees and contracts (line 2)"
RENTEXP "Rental expenses (Line 6b; subtract from gross rents (line 6a) to calculate rental income (line 6c))"
NETRENT "Net rental income (line 6c)"
INVINC "Total investment income (Sum of lines 4,5, and 7)"
SECUR "Gross amount from sale of assets other than inventory. (line 8a A)"
SALESEXP "Cost or other basis and sales expenses from sale of securities. (Line 8b A; subtract from line 8a A to find gain or loss from sale of securities (line 8a C)"
SALEOTHE "Basis and sales expenses from sale of other (line 8b(b))"
SALEOTHG "Gross sales from other (line 8a(b))"
SALEOTHN "Gain (or loss) from sales of assets - other than securities (line 8c(b))"
SALESECN "Net gain (or loss) from securities"
SPEVTG "Gross revenue from special events and activities (line 9a)"
DIREXP "Direct expense from special events and activities, not fundraising expenses. (line 9b)"
FUNDINC "Net income or loss from special events. (line 9c: gross revenue (line 9a) minus line 9b)"
GOODS "Cost of goods sold. (line 10b)"
GRPROF "Gross profit or loss from sales of inventory. (line 10c; gross sales of inventory less returns and allowances (line 10a) minus line 10b)"
OTHINC "Other income. (line 11: from Part VII, line 103))"
GRREC "Gross receipts (Sum of lines 6b, 8b A, 8b B (Cost or other basis and sales expenses from sale of assets other than inventory or securities),9b,10b, and 12)"
TOTREV2 "Total revenue. (Line 12)"
INVENTG "Gross sales of inventory (Sch A, line 10a)"
EXPS "Total expenses. (Line 17: Sum of lines 16 and 44 A)"
SOLICIT "Fundraising expenses. (line 15: from line 44 D)"
FUNDBAL "Net assets or fund balances at end of year. (line 21: sum of lines 18,19, and 20)"
NETINC "Excess (or deficit) for the year (Net income) (line 18)"
OTHCHGS "Other changes in net assets of fund balances (line 20)"
CONT "Total public support (Line 1d: sum of direct public support (line 1a), indirect public support (line 1b), and government contributions and grants (line 1c))"
DUES "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.)"
COMPENS "Total compensation of officers,directors, etc. (Line 25 A)"
OTHSAL "Other salaries and wages (line 26)"
PAYTAX "Payroll taxes (line 29)"
FUNDFEES "Total professional fundraising fees. (line 30 A)"
ASS_BOY "Total assets, beginning of year. (line 59 A: sum of lines 45 A through 58 A)"
ASS_EOY "Total assets, end of year. (line 59 B: sum of lines 45 B through 58 B)"
BOND_BOY "Tax-exempt bond liabilities, beginning of year (line 64a(a))"
BOND_EOY "Tax-exempt bond liabilities, end of year (line 64a(a))"
MRTG_BOY "Mortgages and other notes payable, beginning of year (line 64a(a))"
MRTG_EOY "Mortgages and other notes payable, end of year (line 64a(a))"
LIAB_BOY "Liabilities, beginning of year. (line 66 A: sum of lines 60 A through 65 A)"
LIAB_EOY "Liabilities, end of year. (line 66 B: sum of lines 60 B through 65 B)"
RETE_BOY "Retained earnings, endowment, accumulated income, or other funds, beginning of year. (line 72 B)"
RETEARN "Retained earnings, endowment, accumulated income, or other funds, end of year. (line 72 B)"
NETA_BOY "Total net assets of fund balances (line 73)"
SAVINT "Interest on savings and temporary cash investment (line 95(d))"
SECINC "Dividends and interest from securities (line 96(d))"
RENTINC "Rental income from financed property (line 97b(d))"
OTHINVST "Other investment income (line 99d)"
CONT4 "Gifts, grants, and contributions received (total of last 4 years) (Sch A, line 15(e))"
DUES4 "Membership fees received (total of last 4 years) (Sch A, line 16(e))"
GRREC4 "Gross receipts from admissions, merchandise sold, or services performed (total of last 4 years) (Sch A, line 17(e))"
INVINC4 "Gross income from interest and dividends (total of last 4 years) (Sch A, line 18(e))"
TAXREV4 "Tax rev. levied for the organization benefit and either paid to it or expended on its behalf (total of last 4 years) (Sch A, line 20(e))"
GVTSRV4 "Value of services or facilities furnished to the organization by a governmental unit without charge (total of last 4 years) (Sch A, line 21(e))"
OTHINC4 "Other income (total of last 4 years) (Sch A, line 22(e))"
INCPURP4 "Income derived from activities related to org exempt purpose (total of last 4 years) (Sch A, line 24(e))"
LEGEXP "Total expenses paid or incurred in connection with lobbying activities to influence national, state, or local legislation, including any attempt to influence public opinion on a legislative matter or referendum. (Sch.A,Pt.III, line 1)"
GRROOT "Grass roots lobbying expenditures to influence public opinion. (line 36b)"
INFLEXP "Total lobbying expenditures to directly influence a legislative body. (line 37b)"
EXGRROOT "Excess grass roots expenditures. (line 43b: line 36b minus grassroots nontaxable amount(line 42b))"
EXLOBEXP "Excess lobbying expenditures. (line 44b: total lobbying expenditures (line 38b: sum of lines 36b and 37b) minus lobbying nontaxable amount (line 41b))"
LOBNOTAX "Lobbying nontaxable amount (Sch A, line 41(b))"
LOBOTH "Other exempt purchase lobbying expenses (Sch A, line 39(b))"
GRTNONTX "Grass roots non-taxable amount (Sch A, line 42(b))"
REASON "Reason why org. not private foundation (Sched. A, Pt.IV)"
Q78A "Unrelated business income of $1,000 or more?, Line 78a"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NTEECC4D "NTEECC Classification - fourth character"
NTEEIRS "NTEE code assigned by IRS (includes NTEE-CC & XP codes)"
DLN "Document Locator Number used by the IRS"
RandNum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS fipsold
"NCCS200211-B" "NCCS verification 11/2002 (confidence=B)"
"NCCS200211-C" "NCCS autocodes, 11/2002"
"bahr1" "Matt Bahr (NCCS), carefully coded (10-2002)."
.
VALUE LABELS LEVEL1
"O" "Other Nonprofits"
"PF" "Private Foundation"
"PC" "Public Charity"
"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"
"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"
"HE" "Health"
"EN" "Environment/animals"
.
VALUE LABELS level4
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"B" "Education"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
.
VALUE LABELS MAJGRPB
"S" "S-Community Improvement"
"D" "D-Animal Related"
"T" "T-Philanthropy, Voluntarism"
"E" "E-Health - General"
"U" "U-Science and Technology"
"EH" "EH-Hospitals"
"V" "V-Social Science"
"F" "F-Mental Health"
"W" "W-Public, Society Benefit"
"G" "G-Health - Disease Specific (general)"
"X" "X-Religion Related"
"H" "H-Health - Disease Specific (research)"
"Y" "Y-Mutual/Membership Benefit"
"I" "I-Crime, Legal Related"
"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"
"O" "O-Youth Development"
"A" "A-Arts, Culture & Humanities"
"P" "P-Human Services, Multipurpose and Other"
"B" "B-Education"
"Q" "Q-International, Foreign Affairs"
"BH" "BH-Higher educ."
"R" "R-Civil Rights/Advocacy"
"C" "C-Environment"
.
VALUE LABELS NTEE1
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"B" "Education"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
.
VALUE LABELS ntmaj10
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
.
VALUE LABELS ntmaj12
"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"
"BH" "Education, higher"
.
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"
"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 Q78A
"Y" "Yes"
"N" "No"
.
VALUE LABELS REASON
"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"
"01" "Church"
"02" "School"
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
"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"
.
VALUE LABELS SOURCE
"I" "IRS Return Transaction Files"
"A" "Unified Database of Arts Organizations"
"SAG" "NTEE Classification based on agreement of 2 or 3 of codes from NCCS, FC or SOI."
"C" "American Churches List"
"SOK" "NTEE Classification based on information from directory, web search or phone call."
"G" "Knight Foundation Grant Applicant Files"
"SQU" "NTEE Classification based on current IRS information or on previous classifications-chosen without c"
"P" "Phone CD"
"U" "United Way"
"D" "Dun & Bradstreet Data Source"
.
VALUE LABELS SUBSECCD
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"22" "22- Multiemployer Pension Plan"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"23" "23- Veterans association formed prior to 1880"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"19" "19- Post or organization of war veterans."
"24" "24-Trust described in Section 4049 of ERISA"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"25" "25- Title Holding Company for Pensions, etc"
"11" "11- Teachers retirement fund associations."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"90" "90- 4947(a)(2) Split Interest Trust"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"80" "80- Farmers' Cooperatives"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"40" "40- Apostolic and religious orgs. - 501(d)"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"92" "92- 4947(a)(1) Private Foundations"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"70" "70- Child Care Organization - 501(k)"
"82" "82- 527 Political Organizations"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"71" "71- Charitable Risk Pool"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"81" "81- Qualified State-Sponsored Tuition Program"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"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.
.