Core 1989-2013 Other Fiscal Year Trend

Number of variables42
Number of records3,605,006

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)
NAME
Character
(60)
Name of organization
Organization name.
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.
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
(3)
Out of Scope flag
Out-of-scope (IN/OUT) (see OUTREAS doc. for details)
OUTREAS
Character
(3)
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
(3)
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)
nteeFinal
Character
(5)
NTEE code
NTEE primary purpose classification
ntmaj5
Character
(5)
Major subsector
Major subsector (5)
ARArts, culture, and humanities
EDEducation
HEHealth
HUHuman services
OTOther
ntmaj10
Character
(5)
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
(5)
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
MAJGRPB
Character
(5)
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
Revenues, Expenses, and Change in Net Assets
CONT
Numeric
(5)
Total Contributions
Total contributions, gifts, and grants
Old 990 (DocCD=90): Part I, Line 1e
New 990 (DocCD=93): Part VIII Line 1h
990EZ (DocCD=09 and 92): Part I, Line 1
PROGREV
Numeric
(5)
Program Service & Dues Revenue
Program service revenue plus Dues revenue
Old 990 (DocCD=90): Part I, Line 2 + Line 3
New 990 (DocCD=93): Part VIII Line 2g (A)
990EZ (DocCD=09 and 92): Part I, Line 2 + Line 3
INVINC
Numeric
(5)
Total Investment Income
Total investment income
Old 990 (DocCD=90): Sum of Part I, Lines 4, 5, & 7
New 990 (DocCD=93): Part VIII Line 3A
990EZ (DocCD=09 and 92): Part I, Line 4
FUNDINC
Numeric
(5)
Special Events Net Income
Net income from special events and activities
Old 990 (DocCD=90): Part I, Line 9c
New 990 (DocCD=93): Sum of Part VIII Line 8c (A) and 9c (A)
990EZ (DocCD=09 and 92): Part I, Line 6c
GRPROF
Numeric
(5)
Inventory Gross Profit
Gross profit/loss from sales of inventory
Old 990 (DocCD=90): Part I, Line 10c
New 990 (DocCD=93): Part VIII Line 10c (A)
990EZ (DocCD=09 and 92): Part I, Line 7c
OTHINC
Numeric
(5)
Other Income
Other income
Old 990 (DocCD=90): Part I, Line 11
New 990 (DocCD=93): Part VIII Line 11e (A)
990EZ (DocCD=09 and 92): Part I, Line 8
TOTREV
Numeric
(5)
Total Revenue (calculated)
Calculation of total revenue is based on version of Form 990/990EZ (see DocCD)
Old 990 (DocCD=90) and Old 990EZ (DocCD=09): calculated as (CONT + PROGREV + DUES + INVINC + NETRENT + SALESECN + SALEOTHN + FUNDINC + GRPROF + OTHINC)
New 990 (DocCD=93) and New 990EZ (DocCD=92): calculated as (EXPS + NETINC)
GRREC
Numeric
(5)
Total Gross Receipts (calculated)
Calculation of total gross receipts is based on version of Form 990/990EZ (see DocCD)
Old 990 (DocCD=90): Part I, Line 8b(A), plus Line 8b(B), plus Line 6b, plus Line 9b, plus Line 10b, plus Line 12
New 990 (DocCD=93): Part VIII, Line 12, plus Line 6b(i), plus Line 6b(ii), plus Line 7b(i), plus Line 7b(ii), plus Line 8b, plus Line 9b, plus Line 10b
990EZ (DocCD=09 and 92): Part I, Line 5b, plus Line 6b, plus Line 7b, plus Line 9
EXPS
Numeric
(5)
Total Expenses
Total expenses
Old 990 (DocCD=90): Part I, Line 17
New 990 (DocCD=93): Part IX Line 25 (A)
990EZ (DocCD=09 and 92): Part I, Line 17
NETINC
Numeric
(5)
Net Income/Deficit
Net income (loss) for the year
Old 990 (DocCD=90): Part I, Line 18
New 990 (DocCD=93): Part I Line 19 (Current Year)
990EZ (DocCD=09 and 92): Part I, Line 18
FUNDBAL
Numeric
(5)
Net Assets - EOY
Net assets or fund balances at end of year
Old 990 (DocCD=90): Part I, Line 21
New 990 (DocCD=93): Part I Line 22 (End of Year)
990EZ (DocCD=09 and 92): Part II, Line 27, Col (B)
Balance Sheet
ASS_BOY
Numeric
(5)
Total Assets - BOY
Total assets at beginning of year
Old 990 (DocCD=90): Part IV, Line 59, Col (A)
New 990 (DocCD=93): Part X Line 16 (A)
990EZ (DocCD=09 and 92): Part II, Line 25, Col (A)
ASS_EOY
Numeric
(5)
Total Assets - EOY
Total assets at end of year
Old 990 (DocCD=90): Part IV, Line 59, Col (B)
New 990 (DocCD=93): Part X Line 16 (B)
990EZ (DocCD=09 and 92): Part II, Line 25, Col (B)
LIAB_BOY
Numeric
(5)
Total Liabilities - BOY
Total liabilities at beginning of year
Old 990 (DocCD=90): Part IV, Line 66, Col (A)
New 990 (DocCD=93): Part X Line 26 (A)
990EZ (DocCD=09 and 92): Part II, Line 26, Col (A)
LIAB_EOY
Numeric
(5)
Total Liabilities - EOY
Total liabilities at end of year
Old 990 (DocCD=90): Part IV, Line 66, Col (B)
New 990 (DocCD=93): Part X Line 26 (B)
990EZ (DocCD=09 and 92): Part II, Line 26, Col (B)
NETA_BOY
Numeric
(5)
Net Assets - BOY
Net assets or fund balances at beginning of year
Old 990 (DocCD=90): Part IV, Line 73, Col (A)
New 990 (DocCD=93): Part X line 33 (A)
990EZ (DocCD=09 and 92): Part II, Line 27, Col (A)
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)
NAICS
Character
(9)
NAICS Code
North American Industrial Classification System
Miscellaneous
DocCD
Character
(9)
990 Document Type Code
A 2-digit code identifying type of Form 990 (990, 990-EZ, or 990-PF), and form revision (form revision 2007 and earlier vs. 2008 and later).
Document Code is the 4th and 5th digits of the DLN assigned by the IRS.
09Form 990-EZ revision 2007 and earlier
90Form 990 revision 2007 and earlier
91Form 990-PF
92Form 990-EZ revision 2008 and later
93Form 990 revision 2008 and later
CoreSrc
Character
(10)
Core File Source
Record Core file source
randnum
Numeric
(10)
Random number between 0 and 1
Random number between 0 and 1 used for creating samples