_dta: 1. f990pf2012 set up by Jean Roth , jroth@nber.org , 9 May 2015 2. by Jean Roth , jroth@nber.org , 9 May 2015 3. Data Items on Form 990-PF Annual Masterfile Extract ein: 1. location = 990-PF Header tax_pd: 1. location = 990-PF Header eostatus: 1. location = n/a (IRS-Coded) 2. 1 Unconditional exemption - active 3. 12 Formal exemption not granted (Form 990-PF under IRC 4947(a)(1)) tax_yr: 1. location = 990-PF Header operatingcd: 1. location = n/a (IRS-Coded) 2. Y Operating Foundation 3. N Nonoperating Foundation operatingcdstr: 1. location = n/a (IRS-Coded) assetcdgen: 1. location = Generated based on value of total assets transinccd: 1. location = Generated based on value of total gross receipts subcd: 1. location = n/a (IRS-Coded) 2. 03 Charitable Corporation 3. Educational Organization 4. Literary Organization 5. Organization to Prevent Cruelty to Animals 6. Organization to Prevent Cruelty to Children 7. Organization for Public Safety Testing 8. Religious Organization 9. Scientific Organization 10. 92 Nonexempt Charitable Trust (Treated as Private Foundation) grscontrgifts: 1. location = 990-PF Pt I Line 1, column (a) intrstrvnue: 1. location = 990-PF Pt I Line 3, column (a) dividndsamt: 1. location = 990-PF Pt I Line 4, column (a) totexcapgn: 1. location = 990-PF Part IV, Line 2 > 0 totexcapls: 1. location = 990-PF Part IV, Line 2 < 0 grsprofitbus: 1. location = 990-PF Pt I, Line 10c, column (a) otherincamt: 1. location = 990-PF Pt I, Line 11, column (a) compofficers: 1. location = 990-PF Pt I, Line 13, column (a) contrpdpbks: 1. location = 990-PF Pt I, Line 25, column (a) totrcptperbks: 1. location = 990-PF Pt I, Line 12, column (a) totexpnspbks: 1. location = 990-PF Pt I, Line 26, column (a) excessrcpts: 1. location = 990-PF Pt I, Line 27a totexpnsexempt: 1. location = 990-PF Pt I, Line 26, column (d) netinvstinc: 1. location = 990-PF Pt I, Line 27b totaxpyr: 1. location = 990-PF Pt IV, Line 5 adjnetinc: 1. location = 990-PF Pt I, Line 27c totassetsend: 1. location = 990-PF Pt II, Line 16, column (b) invstgovtoblig: 1. location = 990-PF Pt II, Line 10a, column (b) invstcorpstk: 1. location = 990-PF Pt II, Line 10b, column (b) invstcorpbnd: 1. location = 990-PF Pt II, Line 10c, column (b) totinvstsec: 1. location = 990-PF Pt II, Lines 10a+10b+10c, column (b) totliabend: 1. location = 990-PF Pt II, Line 23, column (b) fairmrktvalamt: 1. location = 990-PF Header, Item I undistribincyr: 1. location = 990-PF Pt XIII, Line 6f, column (d) cmpmininvstret: 1. location = 990-PF Pt X, Line 6 sec4940notxcd: 1. location = 990-PF Pt VI, Line 1b not checked sec4940redtxcd: 1. location = 990-PF Pt VI, Line 1b checked infleg: 1. location = 990-PF Pt VII-A, Line 1a contractncd: 1. location = 990-PF Pt VII-A, Line 5 claimstatcd: 1. location = 990-PF Pt VII-A, Line 9 propexchcd: 1. location = 990-PF Pt VII-B, Line 1a(1) brwlndmnycd: 1. location = 990-PF Pt VII-B, Line 1a(2) furngoodscd: 1. location = 990-PF Pt VII-B, Line 1a(3) paidcmpncd: 1. location = 990-PF Pt VII-B, Line 1a(4) trnsothasstscd: 1. location = 990-PF Pt VII-B, Line 1a(5) agremkpaycd: 1. location = 990-PF Pt VII-B, Line 1a(6) undistrinccd: 1. location = 990-PF Pt VII-B, Line 2a dirindirintcd: 1. location = 990-PF Pt VII-B, Line 3a invstjexmptcd: 1. location = 990-PF Pt VII-B, Line 4a propgndacd: 1. location = 990-PF Pt VII-B, Line 5a(1) excesshldcd: 1. location = 990-PF Pt VII-B, Line 5a(2) grntindivcd: 1. location = 990-PF Pt VII-B, Line 5a(3) nchrtygrntcd: 1. location = 990-PF Pt VII-B, Line 5a(4) nreligiouscd: 1. location = 990-PF Pt VII-B, Line 5a(5) grsrents: 1. location = 990-PF Pt I, Line 5a, column (a) costsold: 1. location = 990-PF Pt I, Line 10b totrcptnetinc: 1. location = 990-PF Pt I, Line 12, column (b) trcptadjnetinc: 1. location = 990-PF Pt I, Line 12, column (c) topradmnexpnsa: 1. location = 990-PF Pt I, Line 24, column (a) topradmnexpnsb: 1. location = 990-PF Pt I, Line 24, column (b) topradmnexpnsd: 1. location = 990-PF Pt I, Line 24, column (d) totexpnsnetinc: 1. location = 990-PF Pt I, Line 26, column (b) totexpnsadjnet: 1. location = 990-PF Pt I, Line 26, column (c) othrcashamt: 1. location = 990-PF Pt I, Line 24, column (d) mrtgloans: 1. location = 990-PF Pt II, Line 12, column (b) othrinvstend: 1. location = 990-PF Pt II, Line 13, column (b) fairmrktvaleoy: 1. location = 990-PF Pt II, Line 16, column (c) mrtgnotespay: 1. location = 990-PF Pt II, Line 21, column (b) tfundnworth: 1. location = 990-PF Pt II, Line 31, column (b) invstexcisetx: 1. location = 990-PF Pt IV, Line 5 sect511tx: 1. location = 990-PF Pt IV, Line 2 subtitleatx: 1. location = 990-PF Pt IV, Line 4 esttaxcr: 1. location = 990-PF Pt IV, Line 6a txwithldsrc: 1. location = 990-PF Pt IV, Line 6b txpaidf2758: 1. location = 990-PF Pt IV, Line 6c erronbkupwthld: 1. location = 990-PF Pt IV, Line 6d estpnlty: 1. location = 990-PF Pt IV, Line 8 balduopt: 1. location = 990-PF Pt IV, Line 9 or Line 10 - Balance due if positive; overpayment if negative crelamt: 1. location = 990-PF Pt IV, Line 11 tfairmrktunuse: 1. location = 990-PF Pt X, Line 1d distribamt: 1. location = 990-PF Pt XI, Line 7 and Part XIII, Line 1, column (d) adjnetinccola: 1. location = 990-PF Pt XIV, Line 2a, column (a) adjnetinccolb: 1. location = 990-PF Pt XIV, Line 2a, column (b) adjnetinccolc: 1. location = 990-PF Pt XIV, Line 2a, column (c) adjnetinccold: 1. location = 990-PF Pt XIV, Line 2a, column (d) adjnetinctot: 1. location = 990-PF Pt XIV, Line 2a, column (e) qlfydistriba: 1. location = 990-PF Pt XIV, Line 2e, column (a) qlfydistribb: 1. location = 990-PF Pt XIV, Line 2e, column (b) qlfydistribc: 1. location = 990-PF Pt XIV, Line 2e, column (c) qlfydistribd: 1. location = 990-PF Pt XIV, Line 2e, column (d) qlfydistribtot: 1. location = 990-PF Pt XIV, Line 2e, column (e) valassetscola: 1. location = 990-PF Pt XIV, Line 3a(1), column (a) valassetscolb: 1. location = 990-PF Pt XIV, Line 3a(1), column (b) valassetscolc: 1. location = 990-PF Pt XIV, Line 3a(1), column (c) valassetscold: 1. location = 990-PF Pt XIV, Line 3a(1), column (d) valassetstot: 1. location = 990-PF Pt XIV, Line 3a(1), column (e) qlfyasseta: 1. location = 990-PF Pt XIV, Line 3a(2), column (a) qlfyassetb: 1. location = 990-PF Pt XIV, Line 3a(2), column (b) qlfyassetc: 1. location = 990-PF Pt XIV, Line 3a(2), column (c) qlfyassetd: 1. location = 990-PF Pt XIV, Line 3a(2), column (d) qlfyassettot: 1. location = 990-PF Pt XIV, Line 3a(2), column (e) endwmntscola: 1. location = 990-PF Pt XIV, Line 3b, column (a) endwmntscolb: 1. location = 990-PF Pt XIV, Line 3b, column (b) endwmntscolc: 1. location = 990-PF Pt XIV, Line 3b, column (c) endwmntscold: 1. location = 990-PF Pt XIV, Line 3b, column (d) endwmntstot: 1. location = 990-PF Pt XIV, Line 3b, column (e) totsuprtcola: 1. location = 990-PF Pt XIV, Line 3c(1), column (a) totsuprtcolb: 1. location = 990-PF Pt XIV, Line 3c(1), column (b) totsuprtcolc: 1. location = 990-PF Pt XIV, Line 3c(1), column (c) totsuprtcold: 1. location = 990-PF Pt XIV, Line 3c(1), column (d) totsuprttot: 1. location = 990-PF Pt XIV, Line 3c(1), column (e) pubsuprtcola: 1. location = 990-PF Pt XIV, Line 3c(2), column (a) pubsuprtcolb: 1. location = 990-PF Pt XIV, Line 3c(2), column (b) pubsuprtcolc: 1. location = 990-PF Pt XIV, Line 3c(2), column (c) pubsuprtcold: 1. location = 990-PF Pt XIV, Line 3c(2), column (d) pubsuprttot: 1. location = 990-PF Pt XIV, Line 3c(2), column (e) grsinvstinca: 1. location = 990-PF Pt XIV, Line 3c(4), column (a) grsinvstincb: 1. location = 990-PF Pt XIV, Line 3c(4), column (b) grsinvstincc: 1. location = 990-PF Pt XIV, Line 3c(4), column (c) grsinvstincd: 1. location = 990-PF Pt XIV, Line 3c(4), column (d) grsinvstinctot: 1. location = 990-PF Pt XIV, Line 3c(4), column (e) obs: 98,948 vars: 122 9 May 2015 16:55 size: 48,286,624 (_dta has notes) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ein long %12.0g * Employer Identification Number tax_pd long %12.0g * Tax period eostatus byte %63.0g eostatus * EO Status Code tax_yr int %8.0g * SOI Year operatingcd byte %27.0g operatingcd * Record code operatingcdstr str1 %9s * Record code assetcdgen byte %29.0g assetcdgen * Asset code transinccd byte %29.0g transinccd * Income code subcd byte %77.0g subcd * Subsection code grscontrgifts double %10.0g * Contributions received intrstrvnue long %12.0g * Interest revenue dividndsamt long %12.0g * Dividends totexcapgn double %10.0g * Net gain -- sales of assets totexcapls long %12.0g * Net loss -- sales of assets grsprofitbus long %12.0g * Gross profit otherincamt long %12.0g * Other income compofficers long %12.0g * Compensation of officers contrpdpbks double %10.0g * Contributions paid totrcptperbks double %10.0g * Total revenue totexpnspbks double %10.0g * Total expenses excessrcpts double %10.0g * Net income less deficit totexpnsexempt double %10.0g * Total expenses -- exempt purpose netinvstinc double %10.0g * Net investment income totaxpyr long %12.0g * Total excise tax adjnetinc long %12.0g * Adjusted net income totassetsend double %10.0g * Total assets -- e-o-y book value invstgovtoblig long %12.0g * Investments in U.S. & state government obligations -- e-o-y book value invstcorpstk double %10.0g * Investments in corporate stock -- e-o-y book value invstcorpbnd long %12.0g * Investments in corporate bonds-- e-o-y book value totinvstsec double %10.0g * Total investments in securities -- e-o-y book value totliabend double %10.0g * Total liabilities -- e-o-y book value fairmrktvalamt double %10.0g * Total assets -- e-o-y fair market value undistribincyr long %12.0g * Undistributed income cmpmininvstret long %12.0g * Minimum investment return sec4940notxcd str1 %9s * 4940 -- no tax sec4940redtxcd str1 %9s * 4940 -- 1 % tax infleg str1 %9s * Influence legislation question contractncd str1 %9s * Contraction question claimstatcd str1 %9s * Claiming status question propexchcd str1 %9s * Property exchange question brwlndmnycd str1 %9s * Borrow lend money question furngoodscd str1 %9s * Furnished goods question paidcmpncd str1 %9s * Paid compensation question trnsothasstscd str1 %9s * Transfer question agremkpaycd str1 %9s * Agree to make pay question undistrinccd str1 %9s * Undistributed income question dirindirintcd str1 %9s * Direct indirect interest question invstjexmptcd str1 %9s * Jeopardizing investments question propgndacd str1 %9s * Propaganda question excesshldcd str1 %9s * Influence public election question grntindivcd str1 %9s * Grant individual question nchrtygrntcd str1 %9s * Non-charity grant question nreligiouscd str1 %9s * Non-religious question grsrents long %12.0g * Gross rents costsold long %12.0g * Cost-of-goods-sold totrcptnetinc double %10.0g * Total receipts net investment income trcptadjnetinc long %12.0g * Total receipts adjusted net income topradmnexpnsa double %10.0g * Total operating and administrative expenses column a topradmnexpnsb long %12.0g * Total operating and administrative expenses column b topradmnexpnsd long %12.0g * Total operating and administrative expenses column d totexpnsnetinc long %12.0g * Total expenses net investment income totexpnsadjnet long %12.0g * Total expenses adjusted net income othrcashamt long %12.0g * Cash non-interest-bearing -- e-o-y book value mrtgloans long %12.0g * Investments mortgage loans -- e-o-y book value othrinvstend double %10.0g * Other investments -- e-o-y book value fairmrktvaleoy double %10.0g * Total assets -- e-o-y fair market value mrtgnotespay long %12.0g * Mortgage loans payable -- e-o-y book value tfundnworth double %10.0g * Total fund net worth -- e-o-y book value invstexcisetx long %12.0g * Excise tax on net investment income sect511tx int %8.0g * Section 511 tax subtitleatx long %12.0g * Subtitle A tax esttaxcr long %12.0g * Estimated tax credit txwithldsrc long %12.0g * Tax withheld at source txpaidf2758 long %12.0g * Tax paid with Form 2758 (filing extension) erronbkupwthld long %12.0g * Erroneous backup withholding credit amount estpnlty long %12.0g * Estimated tax penalty balduopt long %12.0g * Balance due or overpayment crelamt long %12.0g * Credit elect amount tfairmrktunuse double %10.0g * Fair market value of assets not used for charitable purposes distribamt long %12.0g * Distributable amount adjnetinccola long %12.0g * Adjusted net income column a adjnetinccolb long %12.0g * Adjusted net income column b adjnetinccolc long %12.0g * Adjusted net income column c adjnetinccold long %12.0g * Adjusted net income column d adjnetinctot long %12.0g * Adjusted net income total qlfydistriba long %12.0g * Qualifying distributions column a qlfydistribb long %12.0g * Qualifying distributions column b qlfydistribc long %12.0g * Qualifying distributions column c qlfydistribd long %12.0g * Qualifying distributions column d qlfydistribtot long %12.0g * Qualifying distributions total valassetscola long %12.0g * Value assets column a valassetscolb long %12.0g * Value assets column b valassetscolc long %12.0g * Value assets column c valassetscold long %12.0g * Value assets column d valassetstot double %10.0g * Value assets total qlfyasseta long %12.0g * Qualifying assets column a qlfyassetb long %12.0g * Qualifying assets column b qlfyassetc long %12.0g * Qualifying assets column c qlfyassetd long %12.0g * Qualifying assets column d qlfyassettot double %10.0g * Qualifying assets total endwmntscola long %12.0g * Endowments column a endwmntscolb long %12.0g * Endowments column b endwmntscolc long %12.0g * Endowments column c endwmntscold long %12.0g * Endowments column d endwmntstot long %12.0g * Endowments total totsuprtcola long %12.0g * Total support column a totsuprtcolb long %12.0g * Total support column b totsuprtcolc long %12.0g * Total support column c totsuprtcold long %12.0g * Total support column d totsuprttot long %12.0g * Total support total pubsuprtcola long %12.0g * Public support column a pubsuprtcolb long %12.0g * Public support column b pubsuprtcolc long %12.0g * Public support column c pubsuprtcold long %12.0g * Public support column d pubsuprttot long %12.0g * Public support total grsinvstinca long %12.0g * Gross investment income column a grsinvstincb long %12.0g * Gross investment income column b grsinvstincc long %12.0g * Gross investment income column c grsinvstincd long %12.0g * Gross investment income column d grsinvstinctot long %12.0g * Gross investment income total tax_year int %10.0g Tax Year from Tax Period tax_month byte %10.0g Tax Month from Tax Period * indicated variables have notes ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sorted by: ein tax_year tax_month eostatus: 1 Unconditional exemption - active 12 Formal exemption not granted (Form 990-PF under IRC 4947(a)(1)) operatingcd: 0 No, Nonoperating Foundation 1 Yes, Operating Foundation assetcdgen: 0 $0 1 $1 under $10,000 2 $10,000 under $25,000 3 $25,000 under $100,000 4 $100,000 under $500,000 5 $500,000 under $1,000,000 6 $1,000,000 under $5,000,000 7 $5,000,000 under $10,000,000 8 $10,000,000 under $50,000,000 9 $50,000,000 and over transinccd: 0 $0 1 $1 under $10,000 2 $10,000 under $25,000 3 $25,000 under $100,000 4 $100,000 under $500,000 5 $500,000 under $1,000,000 6 $1,000,000 under $5,000,000 7 $5,000,000 under $10,000,000 8 $10,000,000 under $50,000,000 9 $50,000,000 and over subcd: 3 Charitable Corporation... 4 Social welfare organizations 5 Labor and agriculture organizations 6 Business leagues 7 Social and recreation clubs 8 Fraternal beneficiary societies 9 Voluntary employees' beneficiary associations 10 Domestic fraternal beneficiary societies 11 Teachers' retirement fund associations 12 Benevolent life insurance associations 13 Cemetery companies 14 State-chartered credit unions 15 Mutual insurance companies 16 Corporations organized to finance crop operations 17 Supplemental unemployment compensation trusts 18 Employee-funded pension trusts 19 Veterans' organizations 20 Group legal services plans 21 Black lung benefit trusts 22 Withdrawal liability payment funds 23 Associations of past and present members of the armed services 24 Trusts (described in section 4049 of ERIS74) 25 Holding companies for pensions and other entities 26 State-sponsored high-risk health insurance plans 27 State-sponsored workers' compensation reinsurance plans 92 Section 4947(a)(1) Nonexempt Charitable Trust (Treated as Private Foundation)