Core 1989-2013 PF Fiscal Year Trend

Number of variables45
Number of records1,690,923

Field Name
Field Type
Description and Values
Basic Info
EIN
Character
(9)
Employer Identification Number
Employer identification number.
FisYr
Character
(4)
Fiscal year
Fiscal year (ending year)
STATE
Character
(2)
State
Two-letter state abbreviation.
zip5
Character
(5)
Zip code, 5 digits
First 5 digits of zip code
FIPS
Character
(5)
State + County FIPS code
2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts.
styear
Character
(4)
Start year
Start year when fiscal year began (yyyy)
TAXPER
Character
(20)
Ending date for tax period
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
Character
(20)
Out of Scope flag
Out-of-scope (IN/OUT) (see OUTREAS doc. for details)
OUTREAS
Character
(20)
Reason why out of scope
Reason why out of scope
No value
44- Not a 501(c)(3)
FF- Foreign organization
GG- Government Entity
II- Coded out of scope by Independent Sector
NN- Coded out of scope by NCCS (e.g. foreign address on Form 990)
SS- Missing geographic information
TT- U.S. Territory or armed forces overseas
Classification
SUBSECCD
Character
(20)
Subsection code
IRS subsection code (03=501(c)(3), etc.)
0101- Corporations originated under Act of Congress, including Federal Credit Unions
0202- Title holding corporation for a tax-exempt organization.
0303- Religious, educational, charitable, scientific, and literary organizations...
0404- Civic leagues, social welfare organizations, and local associations of employees
0505- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps...
0606- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions...
0707- Social and recreational clubs which provide pleasure, recreation, and social activities.
0808- Fraternal beneficiary societies and associations, with lodges providing for payment of life...
0909- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary...
1010- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable...
1111- Teachers retirement fund associations.
1212- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop...
1313- Cemetery companies, providing burial and incidental activities for members.
1414- State-chartered credit unions, mutual reserve funds, offering loans to members...
1515- Mutual insurance cos. ar associations, providing insurance to members substantially at cost...
1616- Cooperative organizations to finance crop operations, in conjunction with activities ...
1717- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp...
1818- Employee funded pension trusts, providing benefits under a pension plan funded by employees...
1919- Post or organization of war veterans.
2020- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans.
2121- Black lung trusts, satisfying claims for compensation under Black Lung Acts.
2222- Multiemployer Pension Plan
2323- Veterans association formed prior to 1880
2424-Trust described in Section 4049 of ERISA
2525- Title Holding Company for Pensions, etc
2626- State-Sponsored High Risk Health Insurance Organizations
2727- State-Sponsored Workers Compensation Reinsurance
4040- Apostolic and religious orgs. - 501(d)
5050- Cooperative Hospital Service Organization - 501(e)
6060- Cooperative Service Org. of Operating Educ. Org.- 501(f)
7070- Child Care Organization - 501(k)
7171- Charitable Risk Pool
8080- Farmers' Cooperatives
8181- Qualified State-Sponsored Tuition Program
8282- 527 Political Organizations
9090- 4947(a)(2) Split Interest Trust
9191- 4947(a)(1) Public Charity (Files 990/990-EZ)
9292- 4947(a)(1) Private Foundations
9393- 1381(a)(2) Taxable Farmers Cooperative
COCO- Unspecified 501(c) Organization Other Than 501(c)(3)
ntmaj5
Character
(20)
Major subsector
Major subsector (5)
ARArts, culture, and humanities
EDEducation
HEHealth
HUHuman services
OTOther
ntmaj10
Character
(20)
NTEE major group (10)
10 NTEE major groups
ARArts, culture, and humanities
EDEducation
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
ntmaj12
Character
(20)
NTEE major group (12)
12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)
ARArts, culture, and humanities
BHEducation, higher
EDEducation
EHHospitals
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
Main Table: Basic Organization Classifications
NAICS
Character
(9)
North American Industrial Clas
North American Industrial Classification System
Classification
MAJGRPB
Character
(9)
Major NTEE group
Major NTEE group plus hospitals and higher education
AA-Arts, Culture & Humanities
BB-Education
BHBH-Higher educ.
CC-Environment
DD-Animal Related
EE-Health - General
EHEH-Hospitals
FF-Mental Health
GG-Health - Disease Specific (general)
HH-Health - Disease Specific (research)
II-Crime, Legal Related
JJ-Employment, Job Related
KK-Food, Agriculture, Nutrition
LL-Housing, Shelter
MM-Public Safety, Disaster Preparedness
NN-Recreation and Sports
OO-Youth Development
PP-Human Services, Multipurpose and Other
QQ-International, Foreign Affairs
RR-Civil Rights/Advocacy
SS-Community Improvement
TT-Philanthropy, Voluntarism
UU-Science and Technology
VV-Social Science
WW-Public, Society Benefit
XX-Religion Related
YY-Mutual/Membership Benefit
ZZ-Unknown, Unclassified
Financial Info
P1INTREV
Numeric
(9)
Interest - Revenue
Interest on savings & temporary investments - Revenue, 990-PF ln.3
P1DIVID
Numeric
(9)
Dividends
Dividends, 990-PF ln.4
P1NGASTS
Numeric
(9)
Net Gain from Sale of Assets
Net Gain from Sale of Assets
P1GINVPF
Numeric
(9)
Gross Profit (Loss)
Gross Profit (Loss)
P1OTHINC
Numeric
(9)
Other Income
Other Income
P1OFCOMP
Numeric
(9)
Compensation of Officers
Compensation of Officers
Part I: Revenue, Expenses, and Changes in Net Assets or Fund Balances
p1tcont
Numeric
(9)
Total contributions
Total contributions, gifts, grants, etc.
p1totrev
Numeric
(9)
Total Revenue
Total revenue
p1totexp
Numeric
(9)
Total expenses
Total expenses
P2TOTAST
Numeric
(9)
Total Assets per Book
Total Assets per Book
P1CONTPD
Numeric
(9)
Contributions Paid
Contributions Paid
P1EXCREV
Numeric
(9)
Net Income Loss Deficit
Net Income Loss Deficit
P1TEXMEX
Numeric
(9)
Total Expenses - Exempt Purpos
Total Expenses - Exempt Purpos
P1NETINV
Numeric
(9)
Net Investment Income
Net Investment Income
P1NADINC
Numeric
(9)
Adjusted Net Income
Adjusted Net Income
P2GVTINV
Numeric
(9)
Investments-US & State Govt Ob
Investments-US & State Govt Ob
P2CRPSTK
Numeric
(9)
Investments - Corporate Stock
Investments - Corporate Stock
P2CRPBND
Numeric
(9)
Investments - Corporate Bonds
Investments - Corporate Bonds
P2TINVSC
Numeric
(9)
Total Investments - Securities
Total Investments - Securities
P2TLIABL
Numeric
(9)
Total Liabilities
Total Liabilities
P2TASFMV
Numeric
(9)
Total Assets at Market
Total Assets at Market
P1ADMEXP
Numeric
(9)
Tot. adm. & operating exp.
Total administrative and operating expenses
Other Descriptive Info
RULEDATE
Character
(6)
Ruling date (YYYYMM) from IRS
Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)
FNDNCD
Character
(6)
Reason for 501(c)(3) status
Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity
00All organizations except 501(c)(3)
02Private operating foundation exempt from paying excise taxes on investment income
03Private operating foundation (other)
04Private non-operating foundation
09Suspense
10Church
11School
12Hospital or medical research organization
13Organization operated for the benefit of a public (government owned or run) college or university
14Governmental unit
15Organization with a substantial portion of support from a governmental unit or the general public
16Organization income is <=1/3 investment or unrelated business and >1/3 donated or related to purpose
17Supporting Organization 509(a)(3) for benefit and in conjunction with organization(s) coded 10-16
18Organization organized and operated to test for public safety
21Supporting Organization 509(a)(3) Type I
22Supporting Organization 509(a)(3) Type II
23Supporting Organization 509(a)(3) Type III functionally integrated
24Supporting Organization 509(a)(3) Type III not functionally integrated
Other Classification
LEVEL1
Character
(6)
Public charity or priv. fndn?
Public charity or private foundation?
OOther Nonprofits
PCPublic Charity
PFPrivate Foundation
UUnknown
LEVEL2
Character
(6)
Reporting public charity group
Reporting public charity groups.
MMutual Benefit Public Charity
OOperating Public Charity
SSupporting Public Charity
level3
Character
(6)
Major NTEE category
Major NTEE category
ARArts, culture and humanities
EDEducation
ENEnvironment/animals
HEHealth
HSHuman Services
INInternational, foreign affairs
MOOther mutual benefit
MRPension and retirement funds
PBPublic, societal benefit
REReligion related
UNUnknown, unclassified
ZASingle organization support
ZBFundraising within NTEE major group
ZCPrivate grantmaking foundations
ZDPublic foundations
ZEGeneral fundraising
ZFOther Supporting Public Benefit
level4
Character
(6)
NTEE-CC Major Group
NTEE-CC Major Group
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
NTEEIRS
Character
(4)
NTEE assigned by IRS
NTEE code assigned by IRS (includes NTEE-CC & XP codes)
Miscellaneous
randnum
Numeric
(4)
Random number between 0 and 1
Random number between 0 and 1 used for creating samples