sp500_financials
Annual XBRL financial facts for S&P 500 companies. Tier A. One row per CIK + fiscal_year. Coverage approximately 2009-2023. Includes revenue, net income, operating income, total assets, liabilities, stockholders equity, EPS, and shares outstanding. state_id joined from sec_submissions (HQ state).
tier aTier A: direct from SEC XBRL filings. Coverage gaps exist where companies did not report specific XBRL tags consistently.
overview
overview
~9,000 company-year rows. XBRL facts: revenue, net income, operating income, assets, liabilities, equity, EPS, shares outstanding.
current vintage — 2024
history — Yes — annual 2009–2024
provenance
source & licensing
authority
U.S. Securities and Exchange Commission
dataset
SEC EDGAR XBRL Company Facts
methodology
license
Public domain (U.S. Federal Government work)
citation
U.S. Securities and Exchange Commission (2025). EDGAR XBRL Company Facts API.
schema
fields
| name | type | definition |
|---|---|---|
| business_state | string | 2-char US state abbreviation of HQ from SEC EDGAR submissions. |
| cikkey | string | 10-digit zero-padded SEC CIK. |
| company_name | string | Company name from SEC EDGAR submissions. |
| country_idkey | string | ISO alpha-2 country code. Always US. |
| eps_basic | float64 | Basic earnings per share in USD. |
| eps_diluted | float64 | Diluted earnings per share in USD. |
| net_income_usd | float64 | Net income (loss) in USD for the fiscal year. |
| operating_income_usd | float64 | Operating income (loss) in USD for the fiscal year. |
| period_end_date | date | Fiscal year end date for this reporting period. |
| revenue_usd | float64 | Annual revenue in USD. NULL if not reported in XBRL. Revenue concept varies by company (GAAP allows multiple revenue line items). |
| shares_outstanding | int64 | Common shares outstanding at fiscal year end. |
| state_id | string | 2-char state FIPS from HQ state (sec_submissions). NULL if HQ state unknown. |
| stockholders_equity_usd | float64 | Total stockholders equity in USD at fiscal year end. |
| total_assets_usd | float64 | Total assets in USD at fiscal year end. |
| total_liabilities_usd | float64 | Total liabilities in USD at fiscal year end. |
| yearkey | int64 | Fiscal year (4-digit integer). |
relationships
joins
primary key
cik, country_id, year
common joins
sp500_companies on (cik)
sp500_membership_periods on (cik)
usage
how to use this table
method
us-gaap XBRL facts extracted from SEC JSON API, filtered to S&P 500 CIKs, pivoted to annual fiscal year grain.
do not use for
Quarterly analysis; intra-year breakdowns not available.
last updated · Jul 7, 2026