docs/us_corporate/sp500_executives_annual

sp500_executives_annual

Annual CEO identification for each S&P 500 company derived from SEC Form 4 officer filings. Tier A. Grain: one row per (cik, year); CEO resolved as the most-recent filing_date row where is_ceo=TRUE.

tier aTier A: directly from SEC proxy filings. Some companies have fewer than 5 NEOs disclosed.

grain

company-year

years

2015 – 2024

cadence

Annual

overview

~2,200 executive-year rows (named executive officers) for S&P 500 companies, 2015–2024.

current vintage — 2024

history — Yes — 2015–2024

provenance

source & licensing

authority

U.S. Securities and Exchange Commission

dataset

SEC DEF 14A Proxy Statements

source url

https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&type=4

methodology

https://efts.sec.gov/LATEST/search-index?q=DEF+14A

license

Public domain (U.S. Federal Government work)

citation

U.S. Securities and Exchange Commission (2025). DEF 14A Proxy Statement filings via EDGAR.

schema

fields

name	type	definition
accession_number	string	SEC EDGAR accession number of the DEF 14A filing.
ceo_cik	string	SEC CIK of the CEO as reported in the DEF 14A proxy statement.
ceo_filing_date	date	Date the DEF 14A proxy was filed with the SEC.
ceo_name	string	Full name of the CEO as reported in the proxy statement.
ceo_period_of_report	date	Period of report covered by the proxy statement.
ceo_title	string	Job title of the CEO (e.g. Chief Executive Officer, President and CEO).
cikkey	string	10-digit zero-padded SEC CIK identifying the company.
company_name	string	Company name as registered with SEC EDGAR.
country_idkey	string	ISO alpha-2 country code. Always US for S&P 500 members.
county_id	string	5-character FIPS code of the company headquarters county.Joins dim.counties on county_id.
state_id	string	2-char state FIPS of company HQ from SEC submissions.
ticker	string	Stock ticker symbol.
yearkey	int64	Fiscal year of the proxy filing.

relationships

joins

primary key

cik, country_id, year

common joins

sp500_companies on (cik)

sp500_financials on (cik, year)

usage

how to use this table

method

Extracted from SEC EDGAR DEF 14A filings; parsed using structured XML where available.

do not use for

All employees — covers named executive officers (NEOs) only.

← previousus_corporate.sp500_companies next →us_corporate.sp500_financials

last updated · Jul 7, 2026