corporate_foundation_crosswalk
Confirmed links between S&P 500 companies and their private foundations. Tier A. Grain: company-foundation pair (cik + ein). Populated only after operator sets confirmed = TRUE in raw.corporate_foundation_crosswalk_candidates.
tier aTier A: operator-confirmed pairs. Only confirmed=TRUE records from the candidates table are included.
overview
overview
339 confirmed company-foundation pairs linking S&P 500 companies to their private foundations.
current vintage — 2025
history — No — confirmed pairs only
provenance
source & licensing
authority
Point Luna (operator-curated)
dataset
Operator-confirmed S&P 500 company–foundation pairs
license
Public domain (U.S. Federal Government work)
citation
U.S. Securities and Exchange Commission (2025). EDGAR Full-Text Search (https://efts.sec.gov). Candidate pairs generated programmatically; confirmed by Point Luna operator review.
schema
fields
| name | type | definition |
|---|---|---|
| business_state | string | 2-char state abbreviation of company HQ. |
| cikkey | string | 10-digit zero-padded SEC CIK of the S&P 500 parent company. |
| company_name | string | Name of the S&P 500 parent company. |
| country_idkey | string | ISO alpha-2 country code. Always US. |
| einkey | string | 9-digit EIN of the affiliated private foundation (no dashes). |
| foundation_name | string | Name of the private foundation as registered in the IRS EO BMF. |
| match_type | string | Algorithm that produced this candidate pair: name_exact, name_start, name_contains_foundation, ticker_start, or name_contains. |
| notes | string | Operator notes added during review. |
| sic | string | SIC code of the parent company. |
| sic_description | string | Human-readable SIC description of the parent company. |
| state_id | string | 2-char state FIPS from company HQ (sec_submissions). |
| ticker | string | Stock ticker of the S&P 500 parent company. |
| year | int64 | Ingestion year of the crosswalk candidates. |
relationships
joins
primary key
cik, ein, country_id
common joins
sp500_companies on (cik)
private_foundations on (ein)
foundation_giving on (ein)
usage
how to use this table
method
Generated from SEC EDGAR full-text search; candidates manually confirmed by operator.
do not use for
Unconfirmed candidate pairs — only confirmed records are included.
← previous—next →us_corporate.foundation_giving
last updated · Jul 7, 2026