Updated

UPDATE_SCRIPT_MAINTENANCE_REPORT

DataHub
DataHub
171.8K

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 data...

API Access

Access dataset files directly from scripts, code, or AI agents.

Browse dataset files
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
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
https://datahub.io/core/s-and-p-500-companies/_r/-/datapackage.yaml
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. 1. Fetch datapackage.json to inspect schema and resources
  2. 2. Download data resources listed in datapackage.json
  3. 3. Read README.md for full context

Data Views

Data Previews

sector-counts

Loading data...

Schema

nametypedescription
sectorstring
countintegerNumber of S&P 500 constituent companies

constituents

Loading data...

Schema

nametype
Symbolstring
Securitystring
GICS Sectorstring
GICS Sub-Industrystring
Headquarters Locationstring
Date addedstring
CIKstring
Foundedstring

Data Files

FileDescriptionSizeLast modifiedDownload
sector-counts
218 Babout 1 month ago
sector-counts
constituents
53.6 kB10 days ago
constituents
FilesSizeFormatCreatedUpdatedLicenseSource
253.9 kBcsv10 days agoOpen Data Commons Public Domain Dedication and License v1.0
Read more

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 requests with 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.