GC Insights Data Dictionary

	A	B	C	D	E	F
1	Name	Field	Type	Description	Source	Example
2	Organization EIN	organization_ein	String	Employer Identification Number (EIN) - unique federal tax ID	IRS	237825575
3	Organization Name	organization_name	String	Official registered name of the organization	IRS	NATIONAL PHILANTHROPIC TRUST
4	Organization Alt Name	organization_alt_name	String	Alternative or doing business as (DBA) name	IRS
5	Organization URL	organization_url	String	Organization's website URL	IRS/GC AI/Manual	www.nptrust.org
6	Organization Street Address	organization_street_address	String	Street address of organization's principal office	IRS	165 TOWNSHIP LINE ROAD SUITE 1200
7	Organization City	organization_city	String	City of organization's principal office	IRS	JENKINTOWN
8	Organization State	organization_state	String	State of organization's principal office	IRS	PA
9	Organization Address County	organization_address_county	String	County of organization's principal office	IRS	Montgomery
10	Organization Zip Code 5	organization_zip_code5	String	5-digit ZIP code of organization's principal office	IRS	19046
11	Organization Filing Year	organization_filing_year	INTEGER	Tax year for which the return was filed	IRS	2022
12	Organization Filing Date	organization_filing_date	STRING	Date the tax return was filed	IRS	2024-05-21T15:25:03-05:00
13	Organization Expenses Grand Total	organization_expenses_grand_total	FLOAT	Total expenses reported on tax return	IRS	4551288607
14	Organization Revenue Grand Total	organization_revenue_grand_total	FLOAT	Total revenue reported on tax return	IRS	10049957919
15	Organization Net Assets	organization_net_assets	FLOAT	Net assets or fund balances at end of year	IRS	27919223352
16	Organization Employees	organization_employees	Integer	Number of employees reported	IRS	228
17	Organization Form	organization_form	String	Type of tax form filed (990, 990-EZ, etc.)	IRS	Corporation
18	Organization Type	organization_type	String	Type of nonprofit organization	IRS	501(C)(3)
19	Year Founded	year_founded	Integer	Year the organization was established	IRS	1996
20	Principal Officer Name	principal_officer_name	String	Name of the principal officer/CEO	IRS	CHRISTINA HACK
21	Business Officer Name	business_officer_name	String	Name of the business/financial officer	IRS
22	Form Type	form_type	String	Specific IRS form type designation	IRS	990
23	NTEE	ntee	String	National Taxonomy of Exempt Entities primary code	IRS	T500
24	NTEE 1	ntee_1	String	NTEE primary classification category	IRS	T50
25	NTEE 2	ntee_2	String	NTEE secondary classification category	IRS	T00
26	SDGs	sdgs	String	UN Sustainable Development Goals alignment	GC	[17]
27	X4I Issue Area	x4i_issue_area	String	Issue area classification system	GC	Philanthropy, Charity & Voluntarism Promotion
28	X4I Category Group	x4i_category_group	String	Category grouping for issue areas	GC	Public, Societal Benefit
29	Exclude Tags	exclude_tags	String	Tags indicating data exclusion reasons	GC
30	Inactive	inactive	Boolean	Whether organization is currently inactive	IRS	FALSE
31	Foundation	foundation	Boolean	Whether organization is classified as a foundation	IRS	TRUE
32	GC Vetted	gc_vetted	Boolean	Whether vetted by GuideStar/Candid	GC	FALSE
33	GC Video URL	gc_video_url	String	profile video URL	GC AI
34	GC Donation URL	gc_donation_url	String	donation page URL	GC AI
35	GC Impact URL	gc_impact_url	String	annual report URL	GC AI
36	IRS Filing URL	irs_filing_url	String	URL to IRS filing document	Manual
37	IRS Ruling Date	irs_ruling_date	Date	Date of IRS tax-exempt status ruling	IRS	1996-07-01
38	BMF ICO	bmf_ico	String	Initial Classification Organization code	IRS	% PITCAIRN TRUST CO
39	BMF Group	bmf_group	String	Group exemption number	IRS	0
40	BMF Subsection Code	bmf_subsection_code	String	IRC subsection granting exemption	IRS	3
41	BMF Affiliation	bmf_affiliation	String	Group affiliation code	IRS	3
42	BMF Classification	bmf_classification	String	Classification code from Business Master File	IRS	1000
43	BMF Ruling	bmf_ruling	String	Ruling or determination letter date	IRS	199607
44	BMF Deductibility	bmf_deductibility	String	Deductibility status code	IRS	1
45	BMF Foundation	bmf_foundation	String	Foundation status code	IRS	15
46	BMF Activity	bmf_activity	String	Activity codes describing organization's work	IRS	994602000
47	BMF Organization	bmf_organization	String	Organization code from Business Master File	IRS	1
48	BMF Status	bmf_status	String	Current exempt organization status	IRS	1
49	BMF Tax Period	bmf_tax_period	String	Tax period from Business Master File	IRS	202306
50	BMF Asset CD	bmf_asset_cd	String	Asset amount code	IRS	9
51	BMF Income CD	bmf_income_cd	String	Income amount code	IRS	9
52	BMF Filing Req CD	bmf_filing_req_cd	String	Filing requirement code	IRS	1
53	BMF PF Filing Req CD	bmf_pf_filing_req_cd	String	Private foundation filing requirement code	IRS	0
54	BMF Income Amount	bmf_income_amt	FLOAT	Income amount in bmf	IRS	10049957919
55	Organization Summary	organization_summary	STRING	AI Standardized summary from the IRS Mission statement	GC AI	National Philanthropic Trust (NPT) is a public charity dedicated to increasing philanthropy in society. They offer various giving vehicles and philanthropic guidance to help individuals, families, and companies maximize their charitable impact worldwide. NPT also provides information on philanthropic issues and trends. In 2021, NPT awarded approximately 104,000 grants totaling $5.55 billion to charitable organizations and served over 14,000 individual donors. Since its inception in 1996, NPT has made over $23 billion in grants to qualified charities in 89 countries. They continuously enhance their offerings and services to better meet the needs of donors and advisors.
56	Latitude	lat	FLOAT	latitude of address	GC	40.0909498
57	Longitude	lng	FLOAT	longitude of address	GC	-75.1360234
58	Data Sources	sources	JSON	Object containing meta information about the source of fields	IRS, AI, Manual	{"ai":{"impact_report_url":{"date_updated":"2025-07-30T16:22:50.597377Z","reasoning":null,"source":null,"value":null}},"irs":null,"manual":null}
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100