* Museum Core FY 2006.

VARIABLE LABELS
990type "Type of Form 990"
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEECC "NTEECC classification"
ADDRESS "Address"
CITY "City"
zip5 "First 5 digits of zip code"
BMF_CONTACT "Contact person (from IRS BMF)"
PtV_Name "Primary Contact Person Name from Part V of Form 990"
PtV_Title "Primary Contact Person Title from Part V of Form 990"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
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")."
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
p1contFund "Contributions to donor advised funds"
p1dirsup "Direct public support"
p1indsup "Indirect public support"
p1govgt "Government grants"
p1cash "Cash contributions"
p1noncsh "Noncash contributions"
CONT "Total public support (Line 1d: sum of direct public support (1a), indirect public support (1b), and government contributions and grants (1c))"
PROGREV "Program service revenue, line 2"
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.)"
INVINC "Total investment income (Sum of lines 4, 5, and 7)"
SAVINT "Interest on savings and temporary cash investment, line 4"
SECINC "Dividends and interest from securities, line 5"
RENTINC "Gross rents, line 6a"
RENTEXP "Rental expenses, line 6b"
NETRENT "Net rental income, line 6c"
OTHINVST "Other investment income, line 7"
SECUR "Gross amount from sale of securities, Column A - line 8a"
SALESEXP "Cost or other basis of securities and sales expenses, Column A - line 8b"
SALESECN "Net gain/loss from sale of securities, Column A - line 8c"
SALEOTHG "Gross amount from sale of assets other than inventory, Column B - line 8a"
SALEOTHE "Cost or other basis of other assets and sales expenses, Column B - line 8b"
SALEOTHN "Net gain/loss from sale of other assets, Column B - line 8c"
SPEVTG "Gross revenue from special events, line 9a"
DIREXP "Direct expenses other than fundraising for special events, line 9b"
FUNDINC "Net income/loss from special events, line 9c"
INVENTG "Gross sales of inventory less returns and allowances, line 10a"
GOODS "Cost of goods sold, line 10b"
GRPROF "Gross profit/loss from sales of inventory, line 10c"
OTHINC "Other revenue, line 11"
TOTREV2 "Total revenue, line 12"
GRREC "Gross receipts (Sum of lines 6b, 8b (Columns A and B), 9b, 10b, and 12)"
p1pExp "Program service expenses"
p1mExp "Management & general expenses"
p1frexp "Fund-raising expenses"
p1affil "Payments to affiliates"
EXPS "Total expenses, line 17"
NETINC "Net income (excess or deficit) for the year, line 18"
OTHCHGS "Other changes in net assets or fund balances, line 20"
FUNDBAL "Net assets or fund balance at end-of-year, line 21"
COMPENS "Compensation of officers, directors, etc. - Total, Column A - line 25 (excludes compensation for 990-EZ filers)"
OTHSAL "Other salaries and wages - Total, Column A - line 26 (excludes other salaries and wages for 990-EZ filers)"
PAYTAX "Payroll taxes - Total, Column A - line 29 (excludes payroll taxes for 990-EZ filers)"
FUNDFEES "Professional fundraising fees - Total, Column A - line 30"
ASS_BOY "Total assets at beginning-of-year, Column A - line 59"
ASS_EOY "Total assets at end-of-year, Column B - line 59"
p4e_ilnd "Investments-land, buildings & equipment minus accumulated depreciation - end of year"
BOND_BOY "Tax-exempt bond liabilities at beginning-of-year, Column A - line 64a"
p4e_land "Land, building & equip. minus accum. deprec.- end of year"
BOND_EOY "Tax-exempt bond liabilities at end-of-year, Column B - line 64a"
MRTG_BOY "Mortgages and other notes payable at beginning-of-year, Column A - line 64b"
MRTG_EOY "Mortgages and other notes payable at end-of-year, Column B - line 64b"
LIAB_BOY "Total liabilities at beginning-of-year, Column A - line 66"
LIAB_EOY "Total liabilities at end-of-year, Column B - line 66"
RETE_BOY "Retained earnings, endowment, accumulated income, or other funds at beginning-of-year, Column A - line 72"
RETEARN "Retained earnings, endowment, accumulated income, or other funds at end-of-year, Column B - line 72"
NETA_BOY "Total fund balances or net assets at beginning-of-year, Column A - line 73"
p4e_unre "Unrestricted net assets or fund balances- end of year"
p4e_temp "Temporarily restricted net assets- end of year"
p4e_perm "Permanently restricted net assets- end of year"
p4e_net "Total fund balances or net worth- end of year"
Q78A "Unrelated business income of $1,000 or more?, Line 78a"
POLPURP "Political expenditures (direct or indirect), line 81a"
INITFEES "501(c)(7) Organizations initiation fees and capital contributions included on line 12, line 86a"
GRRECPUB "501(c)(7) Organizations gross receipts on line 12 for public use of facilities, line 86b"
GRRECMEM "501(c)(12) Organizations gross income from members or shareholders, line 87a"
GRRECOTH "501(c)(12) Organizations gross income from other sources, line 87b"
p6numEmp "Number of employees employed in pay period including 3/12/xx"
a3lbyex "Total lobbying expenses ((Sch.A.III.1)"
a3lobby "Organization attempted to influence legislation, sch.A.III.1"
LEGEXP "Expenses paid for legislative activities (Sch A, Part III), line 1"
CONT4 "Gifts, grants, and contributions received (Sch A, Part IV-A), Column E - line 15"
DUES4 "Membership fees received (Sch A, Part IV-A), Column E - line 16"
GRREC4 "Gross receipts related to exempt purpose (Sch A, Part IV-A), Column E - line 17"
INVINC4 "Gross investment, rent, royalty, and UBIT income (Sch A, Part IV-A), Column E - line 18"
TAXREV4 "Tax revenues (Sch A, Part IV-A), Column E - line 20"
GVTSRV4 "Value of services furnished by government (Sch A, Part IV-A), Column E - line 21"
OTHINC4 "Other income (Sch A, Part IV-A), Column E - line 22"
INCPURP4 "Total minus gross receipts (Sch A, Part IV-A), Column E - line 24"
GRROOT "Lobbying to influence public opinion (Sch A, Part VI-A), line 36b"
INFLEXP "Lobbying to influence legislative body (Sch A, Part VI-A), line 37b"
LOBOTH "Other exempt purpose expenditures (Sch A, Part VI-A), line 39b"
LOBNOTAX "Lobbying nontaxable amount (Sch A, Part VI-A), line 41b"
GRTNONTX "Grassroots nontaxable amount (Sch A, Part VI-A), line 42b"
EXGRROOT "Excess grass roots expenditures: line 36b less line 42b (Sch A, Part VI-A), line 43b"
EXLOBEXP "Excess lobbying expenditures: line 38b less line 41b (Sch A, Part VI-A), line 44b"
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"
SEC_NAME "Secondary organization name"
p7govamt "Fees & contracts from govt agencies (g)-col. B (unrelated business income, amount)"
p7medamt "Medicare/medicaid payments (f)- col. B (unrelated business income, amount)"
p7govrin "Fees & contracts from govt agencies (g)-col. E (related or exempt function income)"
p7govxat "Fees & contracts from govt agencies (g)-col. D (excl by s.512,513 or 514)"
p7medxat "Medicare/medicaid payments (f)- col. D (excl by s.512,513 or 514, amount)"
p7medrin "Medicare/medicaid payments (f)- col. E (related or exempt function income)"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS FNDNCD
"09" "Suspense"
"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"
"00" "All organizations except 501(c)(3)"
"04" "Private non-operating foundation"
"03" "Private operating foundation (other)"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"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"
"18" "Organization organized and operated to test for public safety"
.
VALUE LABELS Q78A
"N" "No"
"Y" "Yes"
.
VALUE LABELS SUBSECCD
"70" "70- Child Care Organization - 501(k)"
"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)"
"23" "23- Veterans association formed prior to 1880"
"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)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"11" "11- Teachers retirement fund associations."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"02" "02- Title holding corporation for a tax-exempt organization."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"25" "25- Title Holding Company for Pensions, etc"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"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"
"24" "24-Trust described in Section 4049 of ERISA"
.

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