API Access
Access dataset files directly from scripts, code, or AI agents.
Browse dataset files
API Access
Access dataset files directly from scripts, code, or AI agents.
Each file has a stable URL (r-link) that you can use directly in scripts, apps, or AI agents. These URLs are permanent and safe to hardcode.
Start with these files — they give you everything you need to understand and access the dataset.
- 1. Fetch datapackage.json to inspect schema and resources
- 2. Download data resources listed in datapackage.json
- 3. Read README.md for full context
Data Views
Data Files
Explore with AIscatter-data
| Field | Type | Description |
|---|---|---|
| company | string | Full company name |
| sector | string | GICS sector classification |
| market_cap_b | number | Market capitalisation in USD billions |
| pe_ratio | number | Trailing price-to-earnings ratio |
Download
Download CSVAbout
- Filtered view of S&P 500 constituents for scatter plot visualisation: companies with positive P/E ratios below 100, with market capitalisation expressed in USD billions.
- Last updated
- 28 May 2026
- Total rows
- ...
- Format
- CSV
- File size
- 23.5 kB
constituents
| Field | Type | Description |
|---|---|---|
| Symbol | string | Stock ticker symbol (e.g. AAPL) |
| Name | string | Full company name |
| Sector | string | GICS sector classification |
Download
Download CSVAbout
- List of all S&P 500 index constituents with ticker symbol, company name, and GICS sector, sourced from Wikipedia.
- Last updated
- 9 February 2026
- Total rows
- ...
- Format
- CSV
- File size
- 22.9 kB
constituents-financials
| Field | Type | Description |
|---|---|---|
| Symbol | string | Stock ticker symbol (e.g. AAPL) |
| Name | string | Full company name |
| Sector | string | GICS sector classification |
| Price | number | Current stock price in USD |
| Price/Earnings | number | Trailing twelve-month price-to-earnings ratio |
| Dividend Yield | number | Annual dividend yield as a decimal (e.g. 0.02 = 2%) |
| Earnings/Share | number | Trailing twelve-month earnings per share in USD |
| 52 Week Low | number | Lowest stock price over the trailing 52 weeks in USD |
| 52 Week High | number | Highest stock price over the trailing 52 weeks in USD |
| Market Cap | integer | Market capitalisation in raw USD (e.g. 83294183424 ≈ $83.3 billion) |
| EBITDA | integer | Earnings before interest, taxes, depreciation, and amortisation in raw USD |
| Price/Sales | number | Price-to-sales ratio (trailing 12 months) |
| Price/Book | number | Price-to-book ratio |
| SEC Filings | string | URL to the company's EDGAR filing page on SEC.gov |
Download
Download CSVAbout
- S&P 500 constituent companies with key financial metrics sourced via Yahoo Finance, including stock price, market capitalisation, earnings, dividends, and valuation ratios.
- Last updated
- 28 May 2026
- Total rows
- ...
- Format
- CSV
- File size
- 96.5 kB
About this dataset
List of companies in the S&P 500 (Standard and Poor's 500). The S&P 500 is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the US (top 500 by market cap). The dataset includes a list of all the stocks contained therein and associated key financials such as price, market capitalization, earnings, price/earnings ratio, price to book etc.
Data
Information on S&P 500 index used to be available on the official S&P website but until they publish it back, Wikipedia is the best up-to-date and open data source.
- Index listing - see
data/constituents.csvextracted from Wikipedia's List of S&P 500 companies - Constituent financials - see
data/constituents-financials.csv(source via Yahoo Finance) - Scatter plot data - see
data/scatter-data.csv(derived fromconstituents-financials.csv; companies with positive P/E ≤ 100, market cap in USD billions)
Notes:
- In
constituents-financials.csv, Market Cap and EBITDA are in raw USD (e.g.83294183424≈ $83.3 billion). Inscatter-data.csv, themarket_cap_bcolumn is in USD billions. - Some financial fields (e.g. Dividend Yield, Earnings/Share, Price/Book) may be absent for certain companies where Yahoo Finance does not report a value.
Note: For aggregate S&P 500 data (dividends, earnings, etc), see the Standard and Poor's 500 Dataset.
Preparation
You can run the script yourself to update the data and publish them to GitHub: see scripts README.
General Financial Notes
Publicly listed US companies are obliged to file various reports on a regular basis with the SEC. Of these 2 types are of especial interest to investors and others interested in their finances and business. These are:
- 10-K = Annual Report
- 10-Q = Quarterly report
License
All data is licensed under the Open Data Commons Public Domain Dedication and License. All code is licensed under the MIT/BSD license.
Note that while no credit is formally required, a link back or credit to Rufus Pollock and the Open Knowledge Foundation is much appreciated.