S&P 500 Companies with Financial Information - constituents
Dataset published by qri-coredata 

No description provided

1 commit505 rows18.7KBcsv
HEAD AzPRHhH  created dataset from meta.json
7 days ago

S&P 500 Companies with Financial Information - constituents

Original Readme

The original readme below was copied from this dataset’s core data github repo.

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.


Information on S&P 500 index used to be available on the official webpage on the Standard and Poor’s website but until they publish it back, Wikipedia is the best up-to-date and open data source.

  • Index listing - see extracted from Wikipedia’s SP500 list of companies
  • Constituent financials - see (source via Yahoo Finance)

Detailed information on the S&P 500 (primarily in XLS format) used to be obtained from its official webpage on the Standard and Poor’s website - it was free but registration was required. * Index listing - see used to be extracted from source Excel file on S&P website (Note this Excel is actually S&P 500 EPS estimates but on sheet 4 it has list of members - [previous file][sp-lsting] was just members but that 404s as of Dec 2014) (Note: but note you have to register and login to access - no longer true as of August 2013) * Historical performance (source XLS on S&P website)


  • Market Capitalization and EBIDTA are in Billions.

Note: For aggregate information on the S&P (dividends, earnings, etc), see Standard and Poor’s 500 Dataset.


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


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.

About the Import

This dataset is part of the Core Data collection of curated datasets maintained by dataopian and other community contributors. It was brought into qri via an automated import from the core data github org that pulls in the CSV and attempts to convert as much of the information stored in the Data Package standard into the qri dataset specification.

Code for the automated import can be found on github at qri-io/data-stories-scripts.

The import is run periodically, and will result in new versions of this dataset in qri if the original CSV or metadata has been changed.

18.24 KB

CSV Configuration

This table contains a header row
This table uses different quotes to indicate strings


Body Preview
1MMM3M CompanyIndustrials
2AOSA.O. Smith CorpIndustrials
3ABTAbbott LaboratoriesHealth Care
4ABBVAbbVie Inc.Health Care
5ACNAccenture plcInformation Technology
6ATVIActivision BlizzardInformation Technology
7AYIAcuity Brands IncIndustrials
8ADBEAdobe Systems IncInformation Technology
9AAPAdvance Auto PartsConsumer Discretionary
10AMDAdvanced Micro Devices IncInformation Technology
11AESAES CorpUtilities
12AETAetna IncHealth Care
13AMGAffiliated Managers Group IncFinancials
14AFLAFLAC IncFinancials
15AAgilent Technologies IncHealth Care
16APDAir Products & Chemicals IncMaterials
17AKAMAkamai Technologies IncInformation Technology
18ALKAlaska Air Group IncIndustrials
19ALBAlbemarle CorpMaterials
20AREAlexandria Real Estate Equities IncReal Estate
21ALXNAlexion PharmaceuticalsHealth Care
22ALGNAlign TechnologyHealth Care
24AGNAllergan, PlcHealth Care
25ADSAlliance Data SystemsInformation Technology
26LNTAlliant Energy CorpUtilities
27ALLAllstate CorpFinancials
28GOOGLAlphabet Inc Class AInformation Technology
29GOOGAlphabet Inc Class CInformation Technology
30MOAltria Group IncConsumer Staples
31AMZNAmazon.com IncConsumer Discretionary
32AEEAmeren CorpUtilities
33AALAmerican Airlines GroupIndustrials
34AEPAmerican Electric PowerUtilities
35AXPAmerican Express CoFinancials
36AIGAmerican International Group, Inc.Financials
37AMTAmerican Tower Corp AReal Estate
38AWKAmerican Water Works Company IncUtilities
39AMPAmeriprise FinancialFinancials
40ABCAmerisourceBergen CorpHealth Care
41AMEAMETEK IncIndustrials
42AMGNAmgen IncHealth Care
43APHAmphenol CorpInformation Technology
44APCAnadarko Petroleum CorpEnergy
45ADIAnalog Devices, Inc.Information Technology
47ANSSANSYSInformation Technology
48ANTMAnthem Inc.Health Care
49AONAon plcFinancials
50APAApache CorporationEnergy
51AIVApartment Investment & ManagementReal Estate
52AAPLApple Inc.Information Technology
53AMATApplied Materials IncInformation Technology
54APTVAptiv PlcConsumer Discretionary
55ADMArcher-Daniels-Midland CoConsumer Staples
56ARNCArconic IncIndustrials
57AJGArthur J. Gallagher & Co.Financials
58AIZAssurant IncFinancials
59TAT&T IncTelecommunication Services
60ADSKAutodesk IncInformation Technology
61ADPAutomatic Data ProcessingInformation Technology
62AZOAutoZone IncConsumer Discretionary
63AVBAvalonBay Communities, Inc.Real Estate
64AVYAvery Dennison CorpMaterials
65BHGEBaker Hughes, a GE CompanyEnergy
66BLLBall CorpMaterials
67BACBank of America CorpFinancials
68BAXBaxter International Inc.Health Care
69BBTBB&T CorporationFinancials
70BDXBecton DickinsonHealth Care
71BRK.BBerkshire HathawayFinancials
72BBYBest Buy Co. Inc.Consumer Discretionary
73BIIBBiogen Inc.Health Care
75HRBBlock H&RFinancials
76BABoeing CompanyIndustrials
77BWABorgWarnerConsumer Discretionary
78BXPBoston PropertiesReal Estate
79BSXBoston ScientificHealth Care
80BHFBrighthouse Financial IncFinancials
81BMYBristol-Myers SquibbHealth Care
82AVGOBroadcomInformation Technology
83BF.BBrown-Forman Corp.Consumer Staples
84CHRWC. H. Robinson WorldwideIndustrials
85CACA, Inc.Information Technology
86COGCabot Oil & GasEnergy
87CDNSCadence Design SystemsInformation Technology
88CPBCampbell SoupConsumer Staples
89COFCapital One FinancialFinancials
90CAHCardinal Health Inc.Health Care
91KMXCarmax IncConsumer Discretionary
92CCLCarnival Corp.Consumer Discretionary
93CATCaterpillar Inc.Industrials
94CBOECBOE HoldingsFinancials
95CBGCBRE GroupReal Estate
96CBSCBS Corp.Consumer Discretionary
97CELGCelgene Corp.Health Care
98CNCCentene CorporationHealth Care
99CNPCenterPoint EnergyUtilities
100CTLCenturyLink IncTelecommunication Services
Previewing 100 of 505 rows