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.
Dataset Files
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.
/core/s-and-p-500-companies/
https://datahub.io/core/s-and-p-500-companies/_r/-/.devcontainer/devcontainer.json
https://datahub.io/core/s-and-p-500-companies/_r/-/.gitignore
├ Makefile
https://datahub.io/core/s-and-p-500-companies/_r/-/Makefile
https://datahub.io/core/s-and-p-500-companies/_r/-/README.md
https://datahub.io/core/s-and-p-500-companies/_r/-/UPDATE_SCRIPT_MAINTENANCE_REPORT.md
https://datahub.io/core/s-and-p-500-companies/_r/-/data/constituents.csv
https://datahub.io/core/s-and-p-500-companies/_r/-/data/sector-counts.csv
https://datahub.io/core/s-and-p-500-companies/_r/-/datapackage.json
Key Files
Start with these files — they give you everything you need to understand and access the dataset.
datapackage.json— metadata & schema
https://datahub.io/core/s-and-p-500-companies/_r/-/datapackage.json
README.md— documentation
https://datahub.io/core/s-and-p-500-companies/_r/-/README.md
Typical Usage
- 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 AIsector-counts
| Field | Type | Description |
|---|---|---|
| sector | string | GICS (Global Industry Classification Standard) sector name |
| count | integer | Number of S&P 500 constituent companies |
Download
Download CSVAbout
- Aggregated count of S&P 500 constituent companies by GICS sector, derived from the constituents resource. The total may exceed 500 because a small number of companies have multiple share classes listed in the index.
- Last updated
- 8 May 2026
- Total rows
- ...
- Format
- CSV
- File size
- 206 B
constituents
| Field | Type | Description |
|---|---|---|
| Symbol | string | Stock ticker symbol as listed on the exchange |
| Security | string | Company name as listed in the index |
| GICS Sector | string | GICS (Global Industry Classification Standard) sector to which the company belongs |
| GICS Sub-Industry | string | GICS sub-industry classification, a finer-grained grouping within the sector |
| Headquarters Location | string | City and state (or country) where the company's headquarters is located |
| Date added | date | Date the company was added to the S&P 500 index, in YYYY-MM-DD format |
| CIK | string | SEC Central Index Key — the unique identifier assigned by the US Securities and Exchange Commission |
| Founded | string | Year the company was founded. Some entries include a parenthetical note, e.g. '2013 (1888)', indicating the year of the current legal entity followed by the predecessor organisation's founding year |
Download
Download CSVAbout
- Full list of S&P 500 constituent companies as sourced from Wikipedia. Each row represents one listed security (ticker symbol). A small number of companies appear twice with different symbols due to multiple share classes.
- Last updated
- 11 May 2026
- Total rows
- ...
- Format
- CSV
- File size
- 53.7 kB
About this dataset
Update Script Maintenance Report
Date: 2026-03-04
- Root cause: Wikipedia fetch via direct
pandas.read_html(url)hit HTTP 403 in automation. - Fixes made: switched scraper to
requestswith explicit User-Agent and parsed HTML from response content; modernized workflow with explicit write permission. - Validation: local run reproduces and addresses the fetch path issue; workflow now commits only when output changes.
- Known blockers: none identified in this remediation pass.