private_foundations
All ~90K private foundations from IRS Exempt Organizations Business Master File. Tier A. One row per EIN. Filter: pf_filing_req_cd = 1. Includes org name, NTEE code, state, and asset/income/revenue summary amounts. Point-in-time snapshot — does not include annual filing history.
tier aTier A: IRS administrative data. Excludes organizations not yet filed or revoked.
overview
overview
~90,000 private foundations (pf_filing_req_cd=1). Includes NTEE code, state, and asset/income/revenue summary amounts.
current vintage — 2025
history — No — point-in-time snapshot; does not include annual filing history
provenance
source & licensing
authority
U.S. Internal Revenue Service
dataset
IRS Exempt Organizations Business Master File (EO BMF)
source url
methodology
license
Public domain (U.S. Federal Government work)
citation
U.S. Internal Revenue Service (2025). Exempt Organizations Business Master File Extract.
schema
fields
| name | type | definition |
|---|---|---|
| asset_amt | float64 | Total assets from most recent return on file. May be several years stale. |
| city | string | City of the organization mailing address. |
| classification | string | IRS classification code for the organization type. |
| country_idkey | string | ISO alpha-2 country code. Always US. |
| einkey | string | 9-digit Employer Identification Number (no dashes). Primary key. |
| foundation | string | IRS foundation type code. 15 = private operating foundation; other codes identify non-operating private foundations. |
| income_amt | float64 | Total income from most recent return on file. |
| ntee_cd | string | National Taxonomy of Exempt Entities code. |
| org_name | string | Organization name as registered with the IRS. |
| revenue_amt | float64 | Total revenue from most recent return on file. |
| state_abbr | string | 2-char US state abbreviation from IRS. |
| state_id | string | 2-char state FIPS derived from state_abbr via dim.state_codes. NULL if state_abbr missing. |
| status | string | IRS exemption status code. |
| subsection | string | IRS subsection code (e.g. 03 for 501(c)(3)). |
| tax_period | string | Most recent tax period on file in YYYYMM format. |
| year | int64 | Ingestion year (BMF is a point-in-time snapshot). |
| zip | string | ZIP code of the organization mailing address. |
relationships
joins
primary key
ein, country_id
common joins
foundation_giving on (ein)
corporate_foundation_crosswalk on (ein)
usage
how to use this table
method
Filtered to pf_filing_req_cd=1 (private foundation filers) from the full EO BMF download.
do not use for
Annual giving trends — use foundation_giving for annual 990-PF data.
last updated · Jul 7, 2026