docs/us_corporate/sp500_companies

sp500_companies

Current S&P 500 companies with SEC submission metadata and HQ state. Tier A. One row per ticker. Grain: company (ticker). Derived from sp500_membership (removed_date IS NULL) joined to sec_submissions on 10-digit zero-padded CIK. Dual-class shares (GOOGL/GOOG, BRK.A/BRK.B) each appear as separate rows with the same CIK. state_id NULL for ~5% of companies with missing or non-US HQ.

tier aTier A: SEC-filed data; ticker list derived from Wikipedia S&P 500 change log.

grain

company

years

2026

cadence

Continuous (SEC filings)

overview

505 current S&P 500 companies with SEC EDGAR metadata. Dual-class shares (GOOGL/GOOG, BRK.A/BRK.B) appear as separate rows.

current vintage — 2025

history — No — point-in-time snapshot of current S&P 500

provenance

source & licensing

authority

U.S. Securities and Exchange Commission

dataset

SEC EDGAR Company Facts

source url

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

methodology

https://efts.sec.gov/LATEST/search-index?q=company+facts

license

Public domain (U.S. Federal Government work)

citation

U.S. Securities and Exchange Commission (2025). EDGAR Company Facts.

schema

fields

name	type	definition
all_tickers	string	All ticker symbols associated with this CIK (comma-separated).
business_city	string	City of headquarters address from SEC EDGAR.
business_state	string	2-char US state abbreviation of headquarters address from SEC EDGAR.
business_zip	string	ZIP code of headquarters address from SEC EDGAR.
category	string	SEC filer category (e.g. Large Accelerated Filer).
cikkey	string	10-digit zero-padded SEC CIK. Not unique — dual-class companies (e.g. Alphabet, Berkshire) have two tickers per CIK.
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.
ein	string	9-digit Employer Identification Number as filed with SEC.
entity_type	string	SEC entity type (e.g. operating company).
exchanges	string	Stock exchanges where this company is listed.
fiscal_year_end	string	Fiscal year end month-day (e.g. 1231 for December 31).
lei	string	Legal Entity Identifier (20-char ISO 17442 code).
sic	string	Standard Industrial Classification code (4 digits).
sic_description	string	Human-readable description of the SIC code.
state_id	string	2-char state FIPS derived from business_state. NULL for ~5% of companies with missing or non-US HQ.
state_of_incorporation	string	US state where the company is legally incorporated.
ticker	string	Primary grain. Stock ticker symbol. One row per ticker currently in the S&P 500.
year	int64	Ingestion year (snapshot has no natural year dimension).

relationships

joins

primary key

cik, country_id

common joins

sp500_financials on (cik)

sp500_membership_periods on (cik, ticker)

usage

how to use this table

method

Filtered from sp500_membership_periods where removed_date IS NULL; joined to sec_submissions on 10-digit zero-padded CIK.

do not use for

Historical S&P 500 composition — use sp500_membership_periods.

← previousus_corporate.private_foundations next →us_corporate.sp500_executives_annual

last updated · Jul 7, 2026