Team200_Scraping S_P 500 companies.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping S&P500 companies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "url='https://en.wikipedia.org/wiki/List_of_S%26P_500_companies'### wikipedia url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "###using selenium to scrape data\n",
    "from bs4 import BeautifulSoup as bs\n",
    "\n",
    "from selenium import webdriver\n",
    "\n",
    "path_to_chromedriver = 'C:\\\\Users\\\\swapn\\\\Desktop\\\\chromedriver_win32_2.27\\\\chromedriver.exe' # change path as needed\n",
    "browser = webdriver.Chrome(executable_path = path_to_chromedriver)\n",
    "\n",
    "\n",
    "browser.get(url) # Start the browser and open 'url'\n",
    "assert 'List of S&P 500 companies - Wikipedia' in browser.title # Wait for the page to load\n",
    "html = browser.page_source # Get the html of the page\n",
    "browser.quit() # Close the browser\n",
    "soup = bs(html, 'html.parser')\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "##reading table from html\n",
    "import pandas as pd\n",
    "table=soup.find('table',class_=\"wikitable sortable jquery-tablesorter\")\n",
    "rows=[]\n",
    "for row in table.find_all('tr'):\n",
    "    rows.append([val.text.encode('utf8') for val in row.find_all('td')])\n",
    "   \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[u'Ticker symbol',\n",
       "  u'Security',\n",
       "  u'SEC filings',\n",
       "  u'GICS Sector',\n",
       "  u'GICS Sub Industry',\n",
       "  u'Address of Headquarters',\n",
       "  u'Date first added',\n",
       "  u'CIK'],\n",
       " ['MMM',\n",
       "  '3M Company',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Conglomerates',\n",
       "  'St. Paul, Minnesota',\n",
       "  '',\n",
       "  '0000066740'],\n",
       " ['ABT',\n",
       "  'Abbott Laboratories',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'North Chicago, Illinois',\n",
       "  '1964-03-31',\n",
       "  '0000001800'],\n",
       " ['ABBV',\n",
       "  'AbbVie Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'North Chicago, Illinois',\n",
       "  '2012-12-31',\n",
       "  '0001551152'],\n",
       " ['ACN',\n",
       "  'Accenture plc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'IT Consulting & Other Services',\n",
       "  'Dublin, Ireland',\n",
       "  '2011-07-06',\n",
       "  '0001467373'],\n",
       " ['ATVI',\n",
       "  'Activision Blizzard',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Home Entertainment Software',\n",
       "  'Santa Monica, California',\n",
       "  '2015-08-31',\n",
       "  '0000718877'],\n",
       " ['AYI',\n",
       "  'Acuity Brands Inc',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Electrical Components & Equipment',\n",
       "  'Atlanta, Georgia',\n",
       "  '2016-05-03',\n",
       "  '0001144215'],\n",
       " ['ADBE',\n",
       "  'Adobe Systems Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'San Jose, California',\n",
       "  '1997-05-05',\n",
       "  '0000796343'],\n",
       " ['AMD',\n",
       "  'Advanced Micro Devices Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Sunnyvale, California',\n",
       "  '2017-03-20',\n",
       "  '0000002488'],\n",
       " ['AAP',\n",
       "  'Advance Auto Parts',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Automotive Retail',\n",
       "  'Roanoke, Virginia',\n",
       "  '2015-07-09',\n",
       "  '0001158449'],\n",
       " ['AES',\n",
       "  'AES Corp',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Independent Power Producers & Energy Traders',\n",
       "  'Arlington, Virginia',\n",
       "  '',\n",
       "  '0000874761'],\n",
       " ['AET',\n",
       "  'Aetna Inc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Managed Health Care',\n",
       "  'Hartford, Connecticut',\n",
       "  '1976-06-30',\n",
       "  '0001122304'],\n",
       " ['AMG',\n",
       "  'Affiliated Managers Group Inc',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'Beverly, Massachusetts',\n",
       "  '2014-07-01',\n",
       "  '0001004434'],\n",
       " ['AFL',\n",
       "  'AFLAC Inc',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'Columbus, Georgia',\n",
       "  '',\n",
       "  '0000004977'],\n",
       " ['A',\n",
       "  'Agilent Technologies Inc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Santa Clara, California',\n",
       "  '2000-06-05',\n",
       "  '0001090872'],\n",
       " ['APD',\n",
       "  'Air Products & Chemicals Inc',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Industrial Gases',\n",
       "  'Allentown, Pennsylvania',\n",
       "  '1985-04-30',\n",
       "  '0000002969'],\n",
       " ['AKAM',\n",
       "  'Akamai Technologies Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Cambridge, Massachusetts',\n",
       "  '2007-07-12',\n",
       "  '0001086222'],\n",
       " ['ALK',\n",
       "  'Alaska Air Group Inc',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Airlines',\n",
       "  'Seattle, Washington',\n",
       "  '2016-05-13',\n",
       "  '0000766421'],\n",
       " ['ALB',\n",
       "  'Albemarle Corp',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Specialty Chemicals',\n",
       "  'Baton Rouge, Louisiana',\n",
       "  '2016-07-01',\n",
       "  '0000915913'],\n",
       " ['ARE',\n",
       "  'Alexandria Real Estate Equities Inc',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Office REITs',\n",
       "  'Pasadena, California',\n",
       "  '2017-03-20',\n",
       "  '0001035443'],\n",
       " ['ALXN',\n",
       "  'Alexion Pharmaceuticals',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Cheshire, Connecticut',\n",
       "  '2012-05-25',\n",
       "  '0000899866'],\n",
       " ['ALGN',\n",
       "  'Align Technology',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Supplies',\n",
       "  'San Jose, California',\n",
       "  '2017-06-19',\n",
       "  '0001097149'],\n",
       " ['ALLE',\n",
       "  'Allegion',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Building Products',\n",
       "  'Dublin, Ireland',\n",
       "  '2013-12-02',\n",
       "  '0001579241'],\n",
       " ['AGN',\n",
       "  'Allergan, Plc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'Dublin, Ireland',\n",
       "  '',\n",
       "  '0000884629'],\n",
       " ['ADS',\n",
       "  'Alliance Data Systems',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Data Processing & Outsourced Services',\n",
       "  'Plano, Texas',\n",
       "  '2013-12-23',\n",
       "  '0001101215'],\n",
       " ['LNT',\n",
       "  'Alliant Energy Corp',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Madison, Wisconsin',\n",
       "  '2016-07-01',\n",
       "  '0000352541'],\n",
       " ['ALL',\n",
       "  'Allstate Corp',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'Northfield Township, Illinois',\n",
       "  '',\n",
       "  '0000899051'],\n",
       " ['GOOGL',\n",
       "  'Alphabet Inc Class A',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Mountain View, California',\n",
       "  '2014-04-03',\n",
       "  '0001652044'],\n",
       " ['GOOG',\n",
       "  'Alphabet Inc Class C',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Mountain View, California',\n",
       "  '',\n",
       "  '0001652044'],\n",
       " ['MO',\n",
       "  'Altria Group Inc',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Tobacco',\n",
       "  'Richmond, Virginia',\n",
       "  '',\n",
       "  '0000764180'],\n",
       " ['AMZN',\n",
       "  'Amazon.com Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Internet & Direct Marketing Retail',\n",
       "  'Seattle, Washington',\n",
       "  '2005-11-18',\n",
       "  '0001018724'],\n",
       " ['AEE',\n",
       "  'Ameren Corp',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'St. Louis, Missouri',\n",
       "  '1991-09-19',\n",
       "  '0001002910'],\n",
       " ['AAL',\n",
       "  'American Airlines Group',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Airlines',\n",
       "  'Fort Worth, Texas',\n",
       "  '2015-03-23',\n",
       "  '0000006201'],\n",
       " ['AEP',\n",
       "  'American Electric Power',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Columbus, Ohio',\n",
       "  '',\n",
       "  '0000004904'],\n",
       " ['AXP',\n",
       "  'American Express Co',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Consumer Finance',\n",
       "  'New York, New York',\n",
       "  '1976-06-30',\n",
       "  '0000004962'],\n",
       " ['AIG',\n",
       "  'American International Group, Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'New York, New York',\n",
       "  '1980-03-31',\n",
       "  '0000005272'],\n",
       " ['AMT',\n",
       "  'American Tower Corp A',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Boston, Massachusetts',\n",
       "  '2007-11-19',\n",
       "  '0001053507'],\n",
       " ['AWK',\n",
       "  'American Water Works Company Inc',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Water Utilities',\n",
       "  'Voorhees, New Jersey',\n",
       "  '2016-03-04',\n",
       "  '0001410636'],\n",
       " ['AMP',\n",
       "  'Ameriprise Financial',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'Minneapolis, Minnesota',\n",
       "  '2005-10-03',\n",
       "  '0000820027'],\n",
       " ['ABC',\n",
       "  'AmerisourceBergen Corp',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'Chesterbrook, Pennsylvania',\n",
       "  '2001-08-30',\n",
       "  '0001140859'],\n",
       " ['AME',\n",
       "  'AMETEK Inc',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Electrical Components & Equipment',\n",
       "  'Berwyn, Pennsylvania',\n",
       "  '2013-09-23',\n",
       "  '0001037868'],\n",
       " ['AMGN',\n",
       "  'Amgen Inc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Thousand Oaks, California',\n",
       "  '1992-01-02',\n",
       "  '0000318154'],\n",
       " ['APH',\n",
       "  'Amphenol Corp',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Electronic Components',\n",
       "  'Wallingford, Connecticut',\n",
       "  '2008-09-30',\n",
       "  '0000820313'],\n",
       " ['APC',\n",
       "  'Anadarko Petroleum Corp',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'The Woodlands, Texas',\n",
       "  '',\n",
       "  '0000773910'],\n",
       " ['ADI',\n",
       "  'Analog Devices, Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Norwood, Massachusetts',\n",
       "  '',\n",
       "  '0000006281'],\n",
       " ['ANDV',\n",
       "  'Andeavor',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Refining & Marketing',\n",
       "  'San Antonio, Texas',\n",
       "  '2007-09-27',\n",
       "  '0000050104'],\n",
       " ['ANSS',\n",
       "  'ANSYS',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'Canonsburg, Pennsylvania',\n",
       "  '2017-06-19',\n",
       "  '0001013462'],\n",
       " ['ANTM',\n",
       "  'Anthem Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Managed Health Care',\n",
       "  'Indianapolis, Indiana',\n",
       "  '',\n",
       "  '0001156039'],\n",
       " ['AON',\n",
       "  'Aon plc',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Insurance Brokers',\n",
       "  'London, United Kingdom',\n",
       "  '',\n",
       "  '0000315293'],\n",
       " ['AOS',\n",
       "  'A.O. Smith Corp',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Building Products',\n",
       "  'Milwaukee, Wisconsin',\n",
       "  '2017-07-26',\n",
       "  '0000091142'],\n",
       " ['APA',\n",
       "  'Apache Corporation',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '',\n",
       "  '0000006769'],\n",
       " ['AIV',\n",
       "  'Apartment Investment & Management',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Residential REITs',\n",
       "  'Denver, Colorado',\n",
       "  '',\n",
       "  '0000922864'],\n",
       " ['AAPL',\n",
       "  'Apple Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Technology Hardware, Storage & Peripherals',\n",
       "  'Cupertino, California',\n",
       "  '1982-11-30',\n",
       "  '0000320193'],\n",
       " ['AMAT',\n",
       "  'Applied Materials Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductor Equipment',\n",
       "  'Santa Clara, California',\n",
       "  '',\n",
       "  '0000006951'],\n",
       " ['ADM',\n",
       "  'Archer-Daniels-Midland Co',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Agricultural Products',\n",
       "  'Decatur, Illinois',\n",
       "  '1981-07-29',\n",
       "  '0000007084'],\n",
       " ['ARNC',\n",
       "  'Arconic Inc',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'New York, New York',\n",
       "  '1964-03-31',\n",
       "  '0000004281'],\n",
       " ['AJG',\n",
       "  'Arthur J. Gallagher & Co.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Insurance Brokers',\n",
       "  'Itasca, Illinois',\n",
       "  '2016-05-31',\n",
       "  '0000354190'],\n",
       " ['AIZ',\n",
       "  'Assurant Inc',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Multi-line Insurance',\n",
       "  'New York, New York',\n",
       "  '2007-04-10',\n",
       "  '0001267238'],\n",
       " ['T',\n",
       "  'AT&T Inc',\n",
       "  'reports',\n",
       "  'Telecommunication Services',\n",
       "  'Integrated Telecommunication Services',\n",
       "  'Dallas, Texas',\n",
       "  '1983-11-30',\n",
       "  '0000732717'],\n",
       " ['ADSK',\n",
       "  'Autodesk Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'San Rafael, California',\n",
       "  '1989-12-01',\n",
       "  '0000769397'],\n",
       " ['ADP',\n",
       "  'Automatic Data Processing',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Roseland, New Jersey',\n",
       "  '1981-03-31',\n",
       "  '0000008670'],\n",
       " ['AZO',\n",
       "  'AutoZone Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Memphis, Tennessee',\n",
       "  '',\n",
       "  '0000866787'],\n",
       " ['AVB',\n",
       "  'AvalonBay Communities, Inc.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Residential REITs',\n",
       "  'Arlington, Virginia[3]',\n",
       "  '2007-01-10',\n",
       "  '0000915912'],\n",
       " ['AVY',\n",
       "  'Avery Dennison Corp',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Paper Packaging',\n",
       "  'Glendale, California',\n",
       "  '1987-12-31',\n",
       "  '0000008818'],\n",
       " ['BHGE',\n",
       "  'Baker Hughes, a GE Company',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Equipment & Services',\n",
       "  'Houston, Texas',\n",
       "  '',\n",
       "  '0001701605'],\n",
       " ['BLL',\n",
       "  'Ball Corp',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Metal & Glass Containers',\n",
       "  'Broomfield, Colorado',\n",
       "  '1984-10-31',\n",
       "  '0000009389'],\n",
       " ['BAC',\n",
       "  'Bank of America Corp',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Diversified Banks',\n",
       "  'Charlotte, North Carolina',\n",
       "  '1976-06-30',\n",
       "  '0000070858'],\n",
       " ['BK',\n",
       "  'The Bank of New York Mellon Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001390777'],\n",
       " ['BCR',\n",
       "  'Bard (C.R.) Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Murray Hill, New Jersey',\n",
       "  '1975-06-30',\n",
       "  '0000009892'],\n",
       " ['BAX',\n",
       "  'Baxter International Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Deerfield, Illinois',\n",
       "  '1972-09-30',\n",
       "  '0000010456'],\n",
       " ['BBT',\n",
       "  'BB&T Corporation',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Winston-Salem, North Carolina',\n",
       "  '',\n",
       "  '0000092230'],\n",
       " ['BDX',\n",
       "  'Becton Dickinson',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Franklin Lakes, New Jersey',\n",
       "  '1972-09-30',\n",
       "  '0000010795'],\n",
       " ['BRK.B',\n",
       "  'Berkshire Hathaway',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Multi-Sector Holdings',\n",
       "  'Omaha, Nebraska',\n",
       "  '2010-02-16',\n",
       "  '0001067983'],\n",
       " ['BBY',\n",
       "  'Best Buy Co. Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Computer & Electronics Retail',\n",
       "  'Richfield, Minnesota',\n",
       "  '1999-06-29',\n",
       "  '0000764478'],\n",
       " ['BIIB',\n",
       "  'Biogen Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Weston, Massachusetts',\n",
       "  '',\n",
       "  '0000875045'],\n",
       " ['BLK',\n",
       "  'BlackRock',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'New York, New York',\n",
       "  '2011-04-04',\n",
       "  '0001364742'],\n",
       " ['HRB',\n",
       "  'Block H&R',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Consumer Finance',\n",
       "  'Kansas City, Missouri',\n",
       "  '1986-11-30',\n",
       "  '0000012659'],\n",
       " ['BA',\n",
       "  'Boeing Company',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Chicago, Illinois',\n",
       "  '',\n",
       "  '0000012927'],\n",
       " ['BWA',\n",
       "  'BorgWarner',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Auto Parts & Equipment',\n",
       "  'Auburn Hills, Michigan',\n",
       "  '2011-12-19',\n",
       "  '0000908255'],\n",
       " ['BXP',\n",
       "  'Boston Properties',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Office REITs',\n",
       "  'Boston, Massachusetts',\n",
       "  '2006-04-03',\n",
       "  '0001037540'],\n",
       " ['BSX',\n",
       "  'Boston Scientific',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Marlborough, Massachusetts[4]',\n",
       "  '1995-02-24',\n",
       "  '0000885725'],\n",
       " ['BHF',\n",
       "  'Brighthouse Financial Inc',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'Charlotte, North Carolina',\n",
       "  '2017-08-08',\n",
       "  '0001685040'],\n",
       " ['BMY',\n",
       "  'Bristol-Myers Squibb',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000014272'],\n",
       " ['AVGO',\n",
       "  'Broadcom',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'San Jose, California',\n",
       "  '2014-05-08',\n",
       "  '0001441634'],\n",
       " ['BF.B',\n",
       "  'Brown-Forman Corp.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Distillers & Vintners',\n",
       "  'Louisville, Kentucky',\n",
       "  '1982-10-31',\n",
       "  '0000014693'],\n",
       " ['CHRW',\n",
       "  'C. H. Robinson Worldwide',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Air Freight & Logistics',\n",
       "  'Eden Prairie, Minnesota',\n",
       "  '2007-03-02',\n",
       "  '0001043277'],\n",
       " ['CA',\n",
       "  'CA, Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Systems Software',\n",
       "  'Islandia, New York',\n",
       "  '1987-07-31',\n",
       "  '0000356028'],\n",
       " ['COG',\n",
       "  'Cabot Oil & Gas',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '2008-06-23',\n",
       "  '0000858470'],\n",
       " ['CDNS',\n",
       "  'Cadence Design Systems',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'San Jose, California',\n",
       "  '2017-09-18',\n",
       "  '0000813672'],\n",
       " ['CPB',\n",
       "  'Campbell Soup',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Camden, New Jersey',\n",
       "  '',\n",
       "  '0000016732'],\n",
       " ['COF',\n",
       "  'Capital One Financial',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Consumer Finance',\n",
       "  'Tysons Corner, Virginia',\n",
       "  '',\n",
       "  '0000927628'],\n",
       " ['CAH',\n",
       "  'Cardinal Health Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'Dublin, Ohio',\n",
       "  '',\n",
       "  '0000721371'],\n",
       " ['CBOE',\n",
       "  'CBOE Holdings',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Financial Exchanges & Data',\n",
       "  'Chicago, Illinois',\n",
       "  '2017-03-01',\n",
       "  '0001374310'],\n",
       " ['KMX',\n",
       "  'Carmax Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Richmond, Virginia',\n",
       "  '2010-06-28',\n",
       "  '0001170010'],\n",
       " ['CCL',\n",
       "  'Carnival Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Hotels, Resorts & Cruise Lines',\n",
       "  'Miami, Florida',\n",
       "  '',\n",
       "  '0000815097'],\n",
       " ['CAT',\n",
       "  'Caterpillar Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Construction Machinery & Heavy Trucks',\n",
       "  'Peoria, Illinois',\n",
       "  '',\n",
       "  '0000018230'],\n",
       " ['CBG',\n",
       "  'CBRE Group',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Real Estate Services',\n",
       "  'Los Angeles, California',\n",
       "  '2006-11-10',\n",
       "  '0001138118'],\n",
       " ['CBS',\n",
       "  'CBS Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Broadcasting',\n",
       "  'New York, New York',\n",
       "  '1994-09-01',\n",
       "  '0000813828'],\n",
       " ['CELG',\n",
       "  'Celgene Corp.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Summit, New Jersey',\n",
       "  '2006-11-06',\n",
       "  '0000816284'],\n",
       " ['CNC',\n",
       "  'Centene Corporation',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Managed Health Care',\n",
       "  'St Louis, Missouri',\n",
       "  '2016-03-30',\n",
       "  '0001071739'],\n",
       " ['CNP',\n",
       "  'CenterPoint Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Houston, Texas',\n",
       "  '1985-07-31',\n",
       "  '0001130310'],\n",
       " ['CTL',\n",
       "  'CenturyLink Inc',\n",
       "  'reports',\n",
       "  'Telecommunication Services',\n",
       "  'Integrated Telecommunication Services',\n",
       "  'Monroe, Louisiana',\n",
       "  '',\n",
       "  '0000018926'],\n",
       " ['CERN',\n",
       "  'Cerner',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Technology',\n",
       "  'North Kansas City, Missouri',\n",
       "  '2010-04-30',\n",
       "  '0000804753'],\n",
       " ['CF',\n",
       "  'CF Industries Holdings Inc',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Fertilizers & Agricultural Chemicals',\n",
       "  'Deerfield, Illinois',\n",
       "  '2008-08-27',\n",
       "  '0001324404'],\n",
       " ['SCHW',\n",
       "  'Charles Schwab Corporation',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Investment Banking & Brokerage',\n",
       "  'San Francisco, California',\n",
       "  '',\n",
       "  '0000316709'],\n",
       " ['CHTR',\n",
       "  'Charter Communications',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Stamford, Connecticut',\n",
       "  '2016-09-08',\n",
       "  '0001091667'],\n",
       " ['CHK',\n",
       "  'Chesapeake Energy',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Oklahoma City, Oklahoma',\n",
       "  '',\n",
       "  '0000895126'],\n",
       " ['CVX',\n",
       "  'Chevron Corp.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Integrated Oil & Gas',\n",
       "  'San Ramon, California',\n",
       "  '',\n",
       "  '0000093410'],\n",
       " ['CMG',\n",
       "  'Chipotle Mexican Grill',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Restaurants',\n",
       "  'Denver, Colorado',\n",
       "  '2011-04-28',\n",
       "  '0001058090'],\n",
       " ['CB',\n",
       "  'Chubb Limited',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'Zurich, Switzerland',\n",
       "  '2010-07-15',\n",
       "  '0000896159'],\n",
       " ['CHD',\n",
       "  'Church & Dwight',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Household Products',\n",
       "  'Ewing, New Jersey',\n",
       "  '2015-12-29',\n",
       "  '0000313927'],\n",
       " ['CI',\n",
       "  'CIGNA Corp.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Managed Health Care',\n",
       "  'Philadelphia, Pennsylvania',\n",
       "  '1976-06-30',\n",
       "  '0000701221'],\n",
       " ['XEC',\n",
       "  'Cimarex Energy',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Denver, Colorado',\n",
       "  '2014-06-21',\n",
       "  '0001168054'],\n",
       " ['CINF',\n",
       "  'Cincinnati Financial',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'Fairfield, Ohio',\n",
       "  '',\n",
       "  '0000020286'],\n",
       " ['CTAS',\n",
       "  'Cintas Corporation',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Diversified Support Services',\n",
       "  'Mason, Ohio',\n",
       "  '2001-03-01',\n",
       "  '0000723254'],\n",
       " ['CSCO',\n",
       "  'Cisco Systems',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Communications Equipment',\n",
       "  'San Jose, California',\n",
       "  '1993-12-01',\n",
       "  '0000858877'],\n",
       " ['C',\n",
       "  'Citigroup Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Diversified Banks',\n",
       "  'New York, New York',\n",
       "  '1988-05-31',\n",
       "  '0000831001'],\n",
       " ['CFG',\n",
       "  'Citizens Financial Group',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Providence, Rhode Island',\n",
       "  '2016-01-29',\n",
       "  '0000759944'],\n",
       " ['CTXS',\n",
       "  'Citrix Systems',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Fort Lauderdale, Florida',\n",
       "  '',\n",
       "  '0000877890'],\n",
       " ['CLX',\n",
       "  'The Clorox Company',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Household Products',\n",
       "  'Oakland, California',\n",
       "  '1969-03-31',\n",
       "  '0000021076'],\n",
       " ['CME',\n",
       "  'CME Group Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Financial Exchanges & Data',\n",
       "  'Chicago, Illinois',\n",
       "  '',\n",
       "  '0001156375'],\n",
       " ['CMS',\n",
       "  'CMS Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Jackson, Michigan',\n",
       "  '',\n",
       "  '0000811156'],\n",
       " ['KO',\n",
       "  'Coca-Cola Company (The)',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Soft Drinks',\n",
       "  'Atlanta, Georgia',\n",
       "  '',\n",
       "  '0000021344'],\n",
       " ['CTSH',\n",
       "  'Cognizant Technology Solutions',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'IT Consulting & Other Services',\n",
       "  'Teaneck, New Jersey',\n",
       "  '2006-11-17',\n",
       "  '0001058290'],\n",
       " ['CL',\n",
       "  'Colgate-Palmolive',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Household Products',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000021665'],\n",
       " ['CMCSA',\n",
       "  'Comcast Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Philadelphia, Pennsylvania',\n",
       "  '2015-09-18',\n",
       "  '0001166691'],\n",
       " ['CMA',\n",
       "  'Comerica Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Diversified Banks',\n",
       "  'Dallas, Texas',\n",
       "  '',\n",
       "  '0000028412'],\n",
       " ['CAG',\n",
       "  'Conagra Brands',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Chicago, Illinois',\n",
       "  '1983-08-31',\n",
       "  '0000023217'],\n",
       " ['CXO',\n",
       "  'Concho Resources',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Midland, Texas',\n",
       "  '2016-02-22',\n",
       "  '0001358071'],\n",
       " ['COP',\n",
       "  'ConocoPhillips',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '',\n",
       "  '0001163165'],\n",
       " ['ED',\n",
       "  'Consolidated Edison',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001047862'],\n",
       " ['STZ',\n",
       "  'Constellation Brands',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Distillers & Vintners',\n",
       "  'Victor, New York',\n",
       "  '2005-07-05',\n",
       "  '0000016918'],\n",
       " ['COO',\n",
       "  'The Cooper Companies',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Supplies',\n",
       "  'Pleasanton, California',\n",
       "  '2016-09-23',\n",
       "  '0000711404'],\n",
       " ['GLW',\n",
       "  'Corning Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Electronic Components',\n",
       "  'Corning, New York',\n",
       "  '',\n",
       "  '0000024741'],\n",
       " ['COST',\n",
       "  'Costco Wholesale Corp.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Hypermarkets & Super Centers',\n",
       "  'Issaquah, Washington',\n",
       "  '1993-10-01',\n",
       "  '0000909832'],\n",
       " ['COTY',\n",
       "  'Coty, Inc',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Personal Products',\n",
       "  'New York, NY',\n",
       "  '2016-10-03',\n",
       "  '0001024305'],\n",
       " ['CCI',\n",
       "  'Crown Castle International Corp.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Houston, Texas',\n",
       "  '2012-03-14',\n",
       "  '0001051470'],\n",
       " ['CSRA',\n",
       "  'CSRA Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'IT Consulting & Other Services',\n",
       "  'Falls Church, Virginia',\n",
       "  '2015-12-01',\n",
       "  '0001646383'],\n",
       " ['CSX',\n",
       "  'CSX Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Railroads',\n",
       "  'Jacksonville, Florida',\n",
       "  '1967-09-30',\n",
       "  '0000277948'],\n",
       " ['CMI',\n",
       "  'Cummins Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Columbus, Indiana',\n",
       "  '1965-03-31',\n",
       "  '0000026172'],\n",
       " ['CVS',\n",
       "  'CVS Health',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Drug Retail',\n",
       "  'Woonsocket, Rhode Island',\n",
       "  '',\n",
       "  '0000064803'],\n",
       " ['DHI',\n",
       "  'D. R. Horton',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Homebuilding',\n",
       "  'Fort Worth, Texas',\n",
       "  '',\n",
       "  '0000882184'],\n",
       " ['DHR',\n",
       "  'Danaher Corp.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Washington, D.C.',\n",
       "  '',\n",
       "  '0000313616'],\n",
       " ['DRI',\n",
       "  'Darden Restaurants',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Restaurants',\n",
       "  'Orlando, Florida',\n",
       "  '',\n",
       "  '0000940944'],\n",
       " ['DVA',\n",
       "  'DaVita Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Facilities',\n",
       "  'Denver, Colorado',\n",
       "  '2008-07-31',\n",
       "  '0000927066'],\n",
       " ['DE',\n",
       "  'Deere & Co.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Agricultural & Farm Machinery',\n",
       "  'Moline, Illinois',\n",
       "  '',\n",
       "  '0000315189'],\n",
       " ['DLPH',\n",
       "  'Delphi Automotive PLC',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Auto Parts & Equipment',\n",
       "  'Gillingham, Kent, United Kingdom',\n",
       "  '2012-12-24',\n",
       "  '0001521332'],\n",
       " ['DAL',\n",
       "  'Delta Air Lines Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Airlines',\n",
       "  'Atlanta, Georgia',\n",
       "  '2013-09-11',\n",
       "  '0000027904'],\n",
       " ['XRAY',\n",
       "  'Dentsply Sirona',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Supplies',\n",
       "  'York, Pennsylvania',\n",
       "  '2008-11-14',\n",
       "  '0000818479'],\n",
       " ['DVN',\n",
       "  'Devon Energy Corp.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Oklahoma City, Oklahoma',\n",
       "  '2000-08-30',\n",
       "  '0001090012'],\n",
       " ['DLR',\n",
       "  'Digital Realty Trust Inc',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'San Francisco, California',\n",
       "  '2016-05-18',\n",
       "  '0001297996'],\n",
       " ['DFS',\n",
       "  'Discover Financial Services',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Consumer Finance',\n",
       "  'Riverwoods, Illinois',\n",
       "  '2007-07-02',\n",
       "  '0001393612'],\n",
       " ['DISCA',\n",
       "  'Discovery Communications-A',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Silver Spring, Maryland',\n",
       "  '2010-03-01',\n",
       "  '0001437107'],\n",
       " ['DISCK',\n",
       "  'Discovery Communications-C',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Silver Spring, Maryland',\n",
       "  '2014-08-07',\n",
       "  '0001437107'],\n",
       " ['DISH',\n",
       "  'Dish Network',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Meridian, Colorado',\n",
       "  '2017-03-13',\n",
       "  '0001001082'],\n",
       " ['DG',\n",
       "  'Dollar General',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'General Merchandise Stores',\n",
       "  'Goodlettsville, Tennessee',\n",
       "  '2012-12-03',\n",
       "  '0000029534'],\n",
       " ['DLTR',\n",
       "  'Dollar Tree',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'General Merchandise Stores',\n",
       "  'Chesapeake, Virginia',\n",
       "  '2011-12-19',\n",
       "  '0000935703'],\n",
       " ['D',\n",
       "  'Dominion Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Richmond, Virginia',\n",
       "  '',\n",
       "  '0000715957'],\n",
       " ['DOV',\n",
       "  'Dover Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Downers Grove, Illinois',\n",
       "  '1985-10-31',\n",
       "  '0000029905'],\n",
       " ['DWDP',\n",
       "  'DowDuPont',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Diversified Chemicals',\n",
       "  'Midland, Michigan',\n",
       "  '',\n",
       "  '0001666700'],\n",
       " ['DPS',\n",
       "  'Dr Pepper Snapple Group',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Soft Drinks',\n",
       "  'Plano, Texas',\n",
       "  '2008-10-07',\n",
       "  '0001418135'],\n",
       " ['DTE',\n",
       "  'DTE Energy Co.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Detroit, Michigan',\n",
       "  '',\n",
       "  '0000936340'],\n",
       " ['DRE',\n",
       "  'Duke Realty Corp',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Industrial REITs',\n",
       "  'Indianapolis, Indiana',\n",
       "  '2017-07-26',\n",
       "  '0000783280'],\n",
       " ['DUK',\n",
       "  'Duke Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Charlotte, North Carolina',\n",
       "  '1976-06-30',\n",
       "  '0001326160'],\n",
       " ['DXC',\n",
       "  'DXC Technology',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'IT Consulting & Other Services',\n",
       "  'Tysons Corner, Virginia',\n",
       "  '2017-04-04',\n",
       "  '0001688568'],\n",
       " ['ETFC',\n",
       "  'E*Trade',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Investment Banking & Brokerage',\n",
       "  'New York, New York',\n",
       "  '2004-03-31',\n",
       "  '0001015780'],\n",
       " ['EMN',\n",
       "  'Eastman Chemical',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Diversified Chemicals',\n",
       "  'Kingsport, Tennessee',\n",
       "  '1994-01-01',\n",
       "  '0000915389'],\n",
       " ['ETN',\n",
       "  'Eaton Corporation',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Electrical Components & Equipment',\n",
       "  'Dublin, Ireland',\n",
       "  '',\n",
       "  '0001551182'],\n",
       " ['EBAY',\n",
       "  'eBay Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'San Jose, California',\n",
       "  '',\n",
       "  '0001065088'],\n",
       " ['ECL',\n",
       "  'Ecolab Inc.',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Specialty Chemicals',\n",
       "  'St. Paul, Minnesota',\n",
       "  '1989-01-31',\n",
       "  '0000031462'],\n",
       " ['EIX',\n",
       "  \"Edison Int'l\",\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Rosemead, California',\n",
       "  '',\n",
       "  '0000827052'],\n",
       " ['EW',\n",
       "  'Edwards Lifesciences',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Irvine, California',\n",
       "  '2011-04-01',\n",
       "  '0001099800'],\n",
       " ['EA',\n",
       "  'Electronic Arts',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Home Entertainment Software',\n",
       "  'Redwood City, California',\n",
       "  '2002-07-22',\n",
       "  '0000712515'],\n",
       " ['EMR',\n",
       "  'Emerson Electric Company',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Electrical Components & Equipment',\n",
       "  'Ferguson, Missouri',\n",
       "  '1965-03-31',\n",
       "  '0000032604'],\n",
       " ['ETR',\n",
       "  'Entergy Corp.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'New Orleans, Louisiana',\n",
       "  '',\n",
       "  '0000065984'],\n",
       " ['EVHC',\n",
       "  'Envision Healthcare',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Services',\n",
       "  'Nashville, Tennessee',\n",
       "  '2016-12-02',\n",
       "  '0000895930'],\n",
       " ['EOG',\n",
       "  'EOG Resources',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '2000-11-02',\n",
       "  '0000821189'],\n",
       " ['EQT',\n",
       "  'EQT Corporation',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Pittsburgh, Pennsylvania',\n",
       "  '2008-12-19',\n",
       "  '0000033213'],\n",
       " ['EFX',\n",
       "  'Equifax Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Research & Consulting Services',\n",
       "  'Atlanta, Georgia',\n",
       "  '1997-06-19',\n",
       "  '0000033185'],\n",
       " ['EQIX',\n",
       "  'Equinix',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Redwood City, California',\n",
       "  '2015-03-20',\n",
       "  '0001101239'],\n",
       " ['EQR',\n",
       "  'Equity Residential',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Residential REITs',\n",
       "  'Chicago, Illinois',\n",
       "  '2001-12-03',\n",
       "  '0000906107'],\n",
       " ['ESS',\n",
       "  'Essex Property Trust, Inc.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Residential REITs',\n",
       "  'Palo Alto, California',\n",
       "  '2014-04-02',\n",
       "  '0000920522'],\n",
       " ['EL',\n",
       "  'Estee Lauder Cos.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Personal Products',\n",
       "  'New York, New York',\n",
       "  '2006-01-05',\n",
       "  '0001001250'],\n",
       " ['ES',\n",
       "  'Eversource Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Springfield, Massachusetts',\n",
       "  '',\n",
       "  '0000072741'],\n",
       " ['RE',\n",
       "  'Everest Re Group Ltd',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Reinsurance',\n",
       "  'Hamilton, Bermuda',\n",
       "  '2017-06-19',\n",
       "  '0001095073'],\n",
       " ['EXC',\n",
       "  'Exelon Corp.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Chicago, Illinois',\n",
       "  '',\n",
       "  '0001109357'],\n",
       " ['EXPE',\n",
       "  'Expedia Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Internet & Direct Marketing Retail',\n",
       "  'Bellevue, Washington',\n",
       "  '2007-10-02',\n",
       "  '0001324424'],\n",
       " ['EXPD',\n",
       "  'Expeditors International',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Air Freight & Logistics',\n",
       "  'Seattle, Washington',\n",
       "  '2007-10-10',\n",
       "  '0000746515'],\n",
       " ['ESRX',\n",
       "  'Express Scripts',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'Cool Valley, Missouri',\n",
       "  '2003-09-25',\n",
       "  '0001532063'],\n",
       " ['EXR',\n",
       "  'Extra Space Storage',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Salt Lake City, Utah',\n",
       "  '2016-01-19',\n",
       "  '0001289490'],\n",
       " ['XOM',\n",
       "  'Exxon Mobil Corp.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Integrated Oil & Gas',\n",
       "  'Irving, Texas',\n",
       "  '',\n",
       "  '0000034088'],\n",
       " ['FFIV',\n",
       "  'F5 Networks',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Communications Equipment',\n",
       "  'Seattle, Washington',\n",
       "  '2010-12-20',\n",
       "  '0001048695'],\n",
       " ['FB',\n",
       "  'Facebook, Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Menlo Park, California',\n",
       "  '2013-12-23',\n",
       "  '0001326801'],\n",
       " ['FAST',\n",
       "  'Fastenal Co',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Building Products',\n",
       "  'Winona, Minnesota',\n",
       "  '2009-09-15',\n",
       "  '0000815556'],\n",
       " ['FRT',\n",
       "  'Federal Realty Investment Trust',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'Rockville, Maryland',\n",
       "  '2016-02-01',\n",
       "  '0000034903'],\n",
       " ['FDX',\n",
       "  'FedEx Corporation',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Air Freight & Logistics',\n",
       "  'Memphis, Tennessee',\n",
       "  '1980-12-31',\n",
       "  '0001048911'],\n",
       " ['FIS',\n",
       "  'Fidelity National Information Services',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Jacksonville, Florida',\n",
       "  '2006-11-10',\n",
       "  '0001136893'],\n",
       " ['FITB',\n",
       "  'Fifth Third Bancorp',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Cincinnati, Ohio',\n",
       "  '',\n",
       "  '0000035527'],\n",
       " ['FE',\n",
       "  'FirstEnergy Corp',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Akron, Ohio',\n",
       "  '',\n",
       "  '0001031296'],\n",
       " ['FISV',\n",
       "  'Fiserv Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Brookfield, Wisconsin',\n",
       "  '2001-04-02',\n",
       "  '0000798354'],\n",
       " ['FLIR',\n",
       "  'FLIR Systems',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Electronic Equipment & Instruments',\n",
       "  'Wilsonville, Oregon',\n",
       "  '2009-01-02',\n",
       "  '0000354908'],\n",
       " ['FLS',\n",
       "  'Flowserve Corporation',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Irving, Texas',\n",
       "  '2008-10-02',\n",
       "  '0000030625'],\n",
       " ['FLR',\n",
       "  'Fluor Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Construction & Engineering',\n",
       "  'Irving, Texas',\n",
       "  '1980-03-31',\n",
       "  '0001124198'],\n",
       " ['FMC',\n",
       "  'FMC Corporation',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Fertilizers & Agricultural Chemicals',\n",
       "  'Philadelphia, Pennsylvania',\n",
       "  '2009-08-19',\n",
       "  '0000037785'],\n",
       " ['FL',\n",
       "  'Foot Locker Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel Retail',\n",
       "  'New York, New York',\n",
       "  '2016-04-04',\n",
       "  '0000850209'],\n",
       " ['F',\n",
       "  'Ford Motor',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Automobile Manufacturers',\n",
       "  'Dearborn, Michigan',\n",
       "  '',\n",
       "  '0000037996'],\n",
       " ['FTV',\n",
       "  'Fortive Corp',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Everett, Washington',\n",
       "  '2016-07-01',\n",
       "  '0001659166'],\n",
       " ['FBHS',\n",
       "  'Fortune Brands Home & Security',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Building Products',\n",
       "  'Deerfield, Illinois',\n",
       "  '2016-06-22',\n",
       "  '0001519751'],\n",
       " ['BEN',\n",
       "  'Franklin Resources',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'San Mateo, California',\n",
       "  '',\n",
       "  '0000038777'],\n",
       " ['FCX',\n",
       "  'Freeport-McMoRan Inc.',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Copper',\n",
       "  'Phoenix, Arizona',\n",
       "  '',\n",
       "  '0000831259'],\n",
       " ['GPS',\n",
       "  'Gap Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel Retail',\n",
       "  'San Francisco, California',\n",
       "  '1986-08-31',\n",
       "  '0000039911'],\n",
       " ['GRMN',\n",
       "  'Garmin Ltd.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Consumer Electronics',\n",
       "  'Schaffhausen, Switzerland',\n",
       "  '2012-12-12',\n",
       "  '0001121788'],\n",
       " ['IT',\n",
       "  'Gartner Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'IT Consulting & Other Services',\n",
       "  'Stamford, Connecticut',\n",
       "  '2017-04-05',\n",
       "  '0000749251'],\n",
       " ['GD',\n",
       "  'General Dynamics',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Falls Church, Virginia',\n",
       "  '',\n",
       "  '0000040533'],\n",
       " ['GE',\n",
       "  'General Electric',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Conglomerates',\n",
       "  'Fairfield, Connecticut',\n",
       "  '',\n",
       "  '0000040545'],\n",
       " ['GGP',\n",
       "  'General Growth Properties Inc.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'Chicago, Illinois',\n",
       "  '2013-12-10',\n",
       "  '0000895648'],\n",
       " ['GIS',\n",
       "  'General Mills',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Golden Valley, Minnesota',\n",
       "  '1969-03-31',\n",
       "  '0000040704'],\n",
       " ['GM',\n",
       "  'General Motors',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Automobile Manufacturers',\n",
       "  'Detroit, Michigan',\n",
       "  '2013-06-06',\n",
       "  '0001467858'],\n",
       " ['GPC',\n",
       "  'Genuine Parts',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Atlanta, Georgia',\n",
       "  '1973-12-31',\n",
       "  '0000040987'],\n",
       " ['GILD',\n",
       "  'Gilead Sciences',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Foster City, California',\n",
       "  '2004-07-01',\n",
       "  '0000882095'],\n",
       " ['GPN',\n",
       "  'Global Payments Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Data Processing & Outsourced Services',\n",
       "  'Atlanta, Georgia',\n",
       "  '2016-04-25',\n",
       "  '0001123360'],\n",
       " ['GS',\n",
       "  'Goldman Sachs Group',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Investment Banking & Brokerage',\n",
       "  'New York, New York',\n",
       "  '2002-07-22',\n",
       "  '0000886982'],\n",
       " ['GT',\n",
       "  'Goodyear Tire & Rubber',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Tires & Rubber',\n",
       "  'Akron, Ohio',\n",
       "  '',\n",
       "  '0000042582'],\n",
       " ['GWW',\n",
       "  'Grainger (W.W.) Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Lake Forest, Illinois',\n",
       "  '1981-06-30',\n",
       "  '0000277135'],\n",
       " ['HAL',\n",
       "  'Halliburton Co.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Equipment & Services',\n",
       "  'Houston, Texas',\n",
       "  '',\n",
       "  '0000045012'],\n",
       " ['HBI',\n",
       "  'Hanesbrands Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'Winston-Salem, North Carolina',\n",
       "  '2015-03-20',\n",
       "  '0001359841'],\n",
       " ['HOG',\n",
       "  'Harley-Davidson',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Motorcycle Manufacturers',\n",
       "  'Milwaukee, Wisconsin',\n",
       "  '',\n",
       "  '0000793952'],\n",
       " ['HRS',\n",
       "  'Harris Corporation',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Communications Equipment',\n",
       "  'Melbourne, Florida',\n",
       "  '2008-09-22',\n",
       "  '0000202058'],\n",
       " ['HIG',\n",
       "  'Hartford Financial Svc.Gp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'Hartford, Connecticut',\n",
       "  '',\n",
       "  '0000874766'],\n",
       " ['HAS',\n",
       "  'Hasbro Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Leisure Products',\n",
       "  'Pawtucket, Rhode Island',\n",
       "  '1984-09-30',\n",
       "  '0000046080'],\n",
       " ['HCA',\n",
       "  'HCA Holdings',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Facilities',\n",
       "  'Nashville, Tennessee',\n",
       "  '2015-01-27',\n",
       "  '0000860730'],\n",
       " ['HCP',\n",
       "  'HCP Inc.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Health Care REITs',\n",
       "  'Long Beach, California',\n",
       "  '2008-03-31',\n",
       "  '0000765880'],\n",
       " ['HP',\n",
       "  'Helmerich & Payne',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Drilling',\n",
       "  'Tulsa, Oklahoma[5]',\n",
       "  '2010-03-01',\n",
       "  '0000046765'],\n",
       " ['HSIC',\n",
       "  'Henry Schein',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'Melville, New York',\n",
       "  '2015-03-17',\n",
       "  '0001000228'],\n",
       " ['HSY',\n",
       "  'The Hershey Company',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Hershey, Pennsylvania',\n",
       "  '',\n",
       "  '0000047111'],\n",
       " ['HES',\n",
       "  'Hess Corporation',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Integrated Oil & Gas',\n",
       "  'New York, New York',\n",
       "  '1984-05-31',\n",
       "  '0000004447'],\n",
       " ['HPE',\n",
       "  'Hewlett Packard Enterprise',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Technology Hardware, Storage & Peripherals',\n",
       "  'Palo Alto, California',\n",
       "  '2015-11-02',\n",
       "  '0001645590'],\n",
       " ['HLT',\n",
       "  'Hilton Worldwide Holdings Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Hotels, Resorts & Cruise Lines',\n",
       "  'Tysons Corner, Virginia',\n",
       "  '2017-06-19',\n",
       "  '0001585689'],\n",
       " ['HOLX',\n",
       "  'Hologic',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Marlborough, Massachusetts',\n",
       "  '2016-03-30',\n",
       "  '0000859737'],\n",
       " ['HD',\n",
       "  'Home Depot',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Home Improvement Retail',\n",
       "  'Atlanta, Georgia',\n",
       "  '1988-03-31',\n",
       "  '0000354950'],\n",
       " ['HON',\n",
       "  \"Honeywell Int'l Inc.\",\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Conglomerates',\n",
       "  'Morristown, New Jersey',\n",
       "  '1964-03-31',\n",
       "  '0000773840'],\n",
       " ['HRL',\n",
       "  'Hormel Foods Corp.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Austin, Minnesota',\n",
       "  '2009-03-04',\n",
       "  '0000048465'],\n",
       " ['HST',\n",
       "  'Host Hotels & Resorts',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Hotel & Resort REITs',\n",
       "  'Bethesda, Maryland',\n",
       "  '2007-03-20',\n",
       "  '0001070750'],\n",
       " ['HPQ',\n",
       "  'HP Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Technology Hardware, Storage & Peripherals',\n",
       "  'Palo Alto, California',\n",
       "  '1974-12-31',\n",
       "  '0000047217'],\n",
       " ['HUM',\n",
       "  'Humana Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Managed Health Care',\n",
       "  'Louisville, Kentucky',\n",
       "  '',\n",
       "  '0000049071'],\n",
       " ['HBAN',\n",
       "  'Huntington Bancshares',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Columbus, Ohio',\n",
       "  '',\n",
       "  '0000049196'],\n",
       " ['IDXX',\n",
       "  'IDEXX Laboratories',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Westbrook, Maine',\n",
       "  '2017-01-05',\n",
       "  '0000874716'],\n",
       " ['INFO',\n",
       "  'IHS Markit Ltd.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Research & Consulting Services',\n",
       "  'London, United Kingdom',\n",
       "  '2017-06-02',\n",
       "  '0001598014'],\n",
       " ['ITW',\n",
       "  'Illinois Tool Works',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Glenview, Illinois',\n",
       "  '1986-02-28',\n",
       "  '0000049826'],\n",
       " ['ILMN',\n",
       "  'Illumina Inc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Life Sciences Tools & Services',\n",
       "  'San Diego, California',\n",
       "  '2015-11-19',\n",
       "  '0001110803'],\n",
       " ['IR',\n",
       "  'Ingersoll-Rand PLC',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Dublin, Ireland',\n",
       "  '2010-11-17',\n",
       "  '0001466258'],\n",
       " ['INTC',\n",
       "  'Intel Corp.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Santa Clara, California',\n",
       "  '1976-12-31',\n",
       "  '0000050863'],\n",
       " ['ICE',\n",
       "  'Intercontinental Exchange',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Financial Exchanges & Data',\n",
       "  'Atlanta, Georgia',\n",
       "  '2007-09-26',\n",
       "  '0001571949'],\n",
       " ['IBM',\n",
       "  'International Business Machines',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'IT Consulting & Other Services',\n",
       "  'Armonk, New York',\n",
       "  '',\n",
       "  '0000051143'],\n",
       " ['INCY',\n",
       "  'Incyte',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Wilmington, Delaware',\n",
       "  '2017-02-28',\n",
       "  '0000879169'],\n",
       " ['IP',\n",
       "  'International Paper',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Paper Packaging',\n",
       "  'Memphis, Tennessee',\n",
       "  '',\n",
       "  '0000051434'],\n",
       " ['IPG',\n",
       "  'Interpublic Group',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Advertising',\n",
       "  'New York, New York',\n",
       "  '1992-10-01',\n",
       "  '0000051644'],\n",
       " ['IFF',\n",
       "  'Intl Flavors & Fragrances',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Specialty Chemicals',\n",
       "  'New York, New York',\n",
       "  '1976-03-31',\n",
       "  '0000051253'],\n",
       " ['INTU',\n",
       "  'Intuit Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Mountain View, California',\n",
       "  '2000-12-05',\n",
       "  '0000896878'],\n",
       " ['ISRG',\n",
       "  'Intuitive Surgical Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Sunnyvale, California',\n",
       "  '2008-06-02',\n",
       "  '0001035267'],\n",
       " ['IVZ',\n",
       "  'Invesco Ltd.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'Atlanta, Georgia',\n",
       "  '2008-08-21',\n",
       "  '0000914208'],\n",
       " ['IQV',\n",
       "  'IQVIA Holdings Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Life Sciences Tools & Service',\n",
       "  'Durham, North Carolina',\n",
       "  '2017-08-29',\n",
       "  '0001478242'],\n",
       " ['IRM',\n",
       "  'Iron Mountain Incorporated',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Boston, Massachusetts',\n",
       "  '2009-01-06',\n",
       "  '0001020569'],\n",
       " ['JEC',\n",
       "  'Jacobs Engineering Group',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Construction & Engineering',\n",
       "  'Pasadena, California',\n",
       "  '2007-10-26',\n",
       "  '0000052988'],\n",
       " ['JBHT',\n",
       "  'J. B. Hunt Transport Services',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Trucking',\n",
       "  'Lowell, Arkansas',\n",
       "  '2015-07-01',\n",
       "  '0000728535'],\n",
       " ['SJM',\n",
       "  'JM Smucker',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Orrville, Ohio',\n",
       "  '2008-11-06',\n",
       "  '0000091419'],\n",
       " ['JNJ',\n",
       "  'Johnson & Johnson',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'New Brunswick, New Jersey',\n",
       "  '1973-06-30',\n",
       "  '0000200406'],\n",
       " ['JCI',\n",
       "  'Johnson Controls International',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Building Products',\n",
       "  'Cork, Ireland',\n",
       "  '2010-08-27',\n",
       "  '0000833444'],\n",
       " ['JPM',\n",
       "  'JPMorgan Chase & Co.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Diversified Banks',\n",
       "  'New York, New York',\n",
       "  '1975-06-30',\n",
       "  '0000019617'],\n",
       " ['JNPR',\n",
       "  'Juniper Networks',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Communications Equipment',\n",
       "  'Sunnyvale, California',\n",
       "  '',\n",
       "  '0001043604'],\n",
       " ['KSU',\n",
       "  'Kansas City Southern',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Railroads',\n",
       "  'Kansas City, Missouri',\n",
       "  '2013-05-24',\n",
       "  '0000054480'],\n",
       " ['K',\n",
       "  'Kellogg Co.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Battle Creek, Michigan',\n",
       "  '',\n",
       "  '0000055067'],\n",
       " ['KEY',\n",
       "  'KeyCorp',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Cleveland, Ohio',\n",
       "  '1994-03-01',\n",
       "  '0000091576'],\n",
       " ['KMB',\n",
       "  'Kimberly-Clark',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Household Products',\n",
       "  'Irving, Texas',\n",
       "  '',\n",
       "  '0000055785'],\n",
       " ['KIM',\n",
       "  'Kimco Realty',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'New Hyde Park, New York',\n",
       "  '2006-04-04',\n",
       "  '0000879101'],\n",
       " ['KMI',\n",
       "  'Kinder Morgan',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Storage & Transportation',\n",
       "  'Houston, Texas',\n",
       "  '2012-05-25',\n",
       "  '0001506307'],\n",
       " ['KLAC',\n",
       "  'KLA-Tencor Corp.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductor Equipment',\n",
       "  'Milpitas, California',\n",
       "  '',\n",
       "  '0000319201'],\n",
       " ['KSS',\n",
       "  \"Kohl's Corp.\",\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'General Merchandise Stores',\n",
       "  'Menomonee Falls, Wisconsin',\n",
       "  '',\n",
       "  '0000885639'],\n",
       " ['KHC',\n",
       "  'Kraft Heinz Co',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Pittsburgh, Pennsylvania',\n",
       "  '2015-07-06',\n",
       "  '0001637459'],\n",
       " ['KR',\n",
       "  'Kroger Co.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Food Retail',\n",
       "  'Cincinnati, Ohio',\n",
       "  '',\n",
       "  '0000056873'],\n",
       " ['LB',\n",
       "  'L Brands Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel Retail',\n",
       "  'Columbus, Ohio',\n",
       "  '1983-09-30',\n",
       "  '0000701985'],\n",
       " ['LLL',\n",
       "  'L-3 Communications Holdings',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001056239'],\n",
       " ['LH',\n",
       "  'Laboratory Corp. of America Holding',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Services',\n",
       "  'Burlington, North Carolina',\n",
       "  '2004-11-01',\n",
       "  '0000920148'],\n",
       " ['LRCX',\n",
       "  'Lam Research',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductor Equipment',\n",
       "  'Fremont, California',\n",
       "  '2012-06-29',\n",
       "  '0000707549'],\n",
       " ['LEG',\n",
       "  'Leggett & Platt',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Home Furnishings',\n",
       "  'Carthage, Missouri',\n",
       "  '',\n",
       "  '0000058492'],\n",
       " ['LEN',\n",
       "  'Lennar Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Homebuilding',\n",
       "  'Miami, Florida',\n",
       "  '2005-10-04',\n",
       "  '0000920760'],\n",
       " ['LUK',\n",
       "  'Leucadia National Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Multi-Sector Holdings',\n",
       "  'New York, New York',\n",
       "  '2007-08-27',\n",
       "  '0000096223'],\n",
       " ['LLY',\n",
       "  'Lilly (Eli) & Co.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'Indianapolis, Indiana',\n",
       "  '1970-12-31',\n",
       "  '0000059478'],\n",
       " ['LNC',\n",
       "  'Lincoln National',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Multi-line Insurance',\n",
       "  'Radnor, Pennsylvania',\n",
       "  '1976-06-30',\n",
       "  '0000059558'],\n",
       " ['LKQ',\n",
       "  'LKQ Corporation',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Distributors',\n",
       "  'Chicago, Illinois',\n",
       "  '2016-05-23',\n",
       "  '0001065696'],\n",
       " ['LMT',\n",
       "  'Lockheed Martin Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Bethesda, Maryland',\n",
       "  '1984-07-31',\n",
       "  '0000936468'],\n",
       " ['L',\n",
       "  'Loews Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Multi-line Insurance',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000060086'],\n",
       " ['LOW',\n",
       "  \"Lowe's Cos.\",\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Home Improvement Retail',\n",
       "  'Mooresville, North Carolina',\n",
       "  '1984-02-29',\n",
       "  '0000060667'],\n",
       " ['LYB',\n",
       "  'LyondellBasell',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Specialty Chemicals',\n",
       "  'Rotterdam, Netherlands',\n",
       "  '2012-09-05',\n",
       "  '0001489393'],\n",
       " ['MTB',\n",
       "  'M&T Bank Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Buffalo, New York',\n",
       "  '',\n",
       "  '0000036270'],\n",
       " ['MAC',\n",
       "  'Macerich',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'Santa Monica, California',\n",
       "  '2013-05-09',\n",
       "  '0000912242'],\n",
       " ['M',\n",
       "  \"Macy's Inc.\",\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Department Stores',\n",
       "  'Cincinnati, Ohio',\n",
       "  '',\n",
       "  '0000794367'],\n",
       " ['MRO',\n",
       "  'Marathon Oil Corp.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '1991-05-01',\n",
       "  '0000101778'],\n",
       " ['MPC',\n",
       "  'Marathon Petroleum',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Refining & Marketing',\n",
       "  'Findlay, Ohio',\n",
       "  '2011-07-01',\n",
       "  '0001510295'],\n",
       " ['MAR',\n",
       "  \"Marriott Int'l.\",\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Hotels, Resorts & Cruise Lines',\n",
       "  'Bethesda, Maryland',\n",
       "  '',\n",
       "  '0001048286'],\n",
       " ['MMC',\n",
       "  'Marsh & McLennan',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Insurance Brokers',\n",
       "  'New York, New York',\n",
       "  '1987-08-31',\n",
       "  '0000062709'],\n",
       " ['MLM',\n",
       "  'Martin Marietta Materials',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Construction Materials',\n",
       "  'Raleigh, North Carolina',\n",
       "  '2014-07-02',\n",
       "  '0000916076'],\n",
       " ['MAS',\n",
       "  'Masco Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Building Products',\n",
       "  'Taylor, Michigan',\n",
       "  '1981-06-30',\n",
       "  '0000062996'],\n",
       " ['MA',\n",
       "  'Mastercard Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Harrison, New York',\n",
       "  '2008-07-18',\n",
       "  '0001141391'],\n",
       " ['MAT',\n",
       "  'Mattel Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Leisure Products',\n",
       "  'El Segundo, California',\n",
       "  '1982-03-31',\n",
       "  '0000063276'],\n",
       " ['MKC',\n",
       "  'McCormick & Co.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Sparks, Maryland',\n",
       "  '',\n",
       "  '0000063754'],\n",
       " ['MCD',\n",
       "  \"McDonald's Corp.\",\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Restaurants',\n",
       "  'Oak Brook, Illinois',\n",
       "  '1970-06-30',\n",
       "  '0000063908'],\n",
       " ['MCK',\n",
       "  'McKesson Corp.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'San Francisco, California',\n",
       "  '',\n",
       "  '0000927653'],\n",
       " ['MDT',\n",
       "  'Medtronic plc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Dublin, Ireland',\n",
       "  '1986-10-31',\n",
       "  '0000064670'],\n",
       " ['MRK',\n",
       "  'Merck & Co.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'Whitehouse Station, New Jersey',\n",
       "  '',\n",
       "  '0000310158'],\n",
       " ['MET',\n",
       "  'MetLife Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001099219'],\n",
       " ['MTD',\n",
       "  'Mettler Toledo',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Life Sciences Tools & Services',\n",
       "  'Columbus, Ohio',\n",
       "  '2016-09-06',\n",
       "  '0001037646'],\n",
       " ['MGM',\n",
       "  'MGM Resorts International',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Casinos & Gaming',\n",
       "  'Paradise, Nevada',\n",
       "  '2017-07-26',\n",
       "  '0000789570'],\n",
       " ['KORS',\n",
       "  'Michael Kors Holdings',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'New York, New York',\n",
       "  '2013-11-13',\n",
       "  '0001530721'],\n",
       " ['MCHP',\n",
       "  'Microchip Technology',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Chandler, Arizona',\n",
       "  '2007-09-07',\n",
       "  '0000827054'],\n",
       " ['MU',\n",
       "  'Micron Technology',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Boise, Idaho',\n",
       "  '1994-09-27',\n",
       "  '0000723125'],\n",
       " ['MSFT',\n",
       "  'Microsoft Corp.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Systems Software',\n",
       "  'Redmond, Washington',\n",
       "  '1994-06-01',\n",
       "  '0000789019'],\n",
       " ['MAA',\n",
       "  'Mid-America Apartments',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Residential REITs',\n",
       "  'Memphis, Tennessee',\n",
       "  '2016-12-02',\n",
       "  '0000912595'],\n",
       " ['MHK',\n",
       "  'Mohawk Industries',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Home Furnishings',\n",
       "  'Amsterdam, New York',\n",
       "  '2013-12-23',\n",
       "  '0000851968'],\n",
       " ['TAP',\n",
       "  'Molson Coors Brewing Company',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Brewers',\n",
       "  'Denver, Colorado',\n",
       "  '1976-06-30',\n",
       "  '0000024545'],\n",
       " ['MDLZ',\n",
       "  'Mondelez International',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Northfield, Illinois',\n",
       "  '2012-10-02',\n",
       "  '0001103982'],\n",
       " ['MON',\n",
       "  'Monsanto Co.',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Fertilizers & Agricultural Chemicals',\n",
       "  'Creve Coeur, Missouri',\n",
       "  '2002-08-07',\n",
       "  '0001110783'],\n",
       " ['MNST',\n",
       "  'Monster Beverage',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Soft Drinks',\n",
       "  'Corona, California',\n",
       "  '2012-06-28',\n",
       "  '0000865752'],\n",
       " ['MCO',\n",
       "  \"Moody's Corp\",\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Financial Exchanges & Data',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001059556'],\n",
       " ['MS',\n",
       "  'Morgan Stanley',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Investment Banking & Brokerage',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000895421'],\n",
       " ['MOS',\n",
       "  'The Mosaic Company',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Fertilizers & Agricultural Chemicals',\n",
       "  'Plymouth, Minnesota',\n",
       "  '2011-09-26',\n",
       "  '0001285785'],\n",
       " ['MSI',\n",
       "  'Motorola Solutions Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Communications Equipment',\n",
       "  'Schaumburg, Illinois',\n",
       "  '',\n",
       "  '0000068505'],\n",
       " ['MYL',\n",
       "  'Mylan N.V.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'Amsterdam, Netherlands',\n",
       "  '2004-04-23',\n",
       "  '0000069499'],\n",
       " ['NDAQ',\n",
       "  'Nasdaq, Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Financial Exchanges & Data',\n",
       "  'New York, New York',\n",
       "  '2008-10-22',\n",
       "  '0001120193'],\n",
       " ['NOV',\n",
       "  'National Oilwell Varco Inc.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Equipment & Services',\n",
       "  'Houston, Texas',\n",
       "  '2005-03-14',\n",
       "  '0001021860'],\n",
       " ['NAVI',\n",
       "  'Navient',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Consumer Finance',\n",
       "  'Wilmington, Delaware',\n",
       "  '2014-05-01',\n",
       "  '0001593538'],\n",
       " ['NTAP',\n",
       "  'NetApp',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Sunnyvale, California',\n",
       "  '1999-06-25',\n",
       "  '0001002047'],\n",
       " ['NFLX',\n",
       "  'Netflix Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Los Gatos, California',\n",
       "  '2010-12-20',\n",
       "  '0001065280'],\n",
       " ['NWL',\n",
       "  'Newell Brands',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Housewares & Specialties',\n",
       "  'Sandy Springs, Georgia',\n",
       "  '1989-04-30',\n",
       "  '0000814453'],\n",
       " ['NFX',\n",
       "  'Newfield Exploration Co',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '2010-12-20',\n",
       "  '0000912750'],\n",
       " ['NEM',\n",
       "  'Newmont Mining Corporation',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Gold',\n",
       "  'Denver, Colorado',\n",
       "  '1969-06-30',\n",
       "  '0001164727'],\n",
       " ['NWSA',\n",
       "  'News Corp. Class A',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Publishing',\n",
       "  'New York, New York',\n",
       "  '2013-08-01',\n",
       "  '0001564708'],\n",
       " ['NWS',\n",
       "  'News Corp. Class B',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Publishing',\n",
       "  'New York, New York',\n",
       "  '2015-09-18',\n",
       "  '0001564708'],\n",
       " ['NEE',\n",
       "  'NextEra Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Juno Beach, Florida',\n",
       "  '1976-06-30',\n",
       "  '0000753308'],\n",
       " ['NLSN',\n",
       "  'Nielsen Holdings',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Research & Consulting Services',\n",
       "  'New York, New York',\n",
       "  '2013-07-09',\n",
       "  '0001492633'],\n",
       " ['NKE',\n",
       "  'Nike',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'Washington County, Oregon',\n",
       "  '1988-11-30',\n",
       "  '0000320187'],\n",
       " ['NI',\n",
       "  'NiSource Inc.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Merrillville, Indiana',\n",
       "  '',\n",
       "  '0001111711'],\n",
       " ['NBL',\n",
       "  'Noble Energy Inc',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Houston, Texas',\n",
       "  '2007-10-08',\n",
       "  '0000072207'],\n",
       " ['JWN',\n",
       "  'Nordstrom',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Department Stores',\n",
       "  'Seattle, Washington',\n",
       "  '1986-08-31',\n",
       "  '0000072333'],\n",
       " ['NSC',\n",
       "  'Norfolk Southern Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Railroads',\n",
       "  'Norfolk, Virginia',\n",
       "  '',\n",
       "  '0000702165'],\n",
       " ['NTRS',\n",
       "  'Northern Trust Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'Chicago, Illinois',\n",
       "  '',\n",
       "  '0000073124'],\n",
       " ['NOC',\n",
       "  'Northrop Grumman Corp.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'West Falls Church, Virginia',\n",
       "  '1985-06-30',\n",
       "  '0001133421'],\n",
       " ['NCLH',\n",
       "  'Norwegian Cruise Line',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Hotels, Resorts & Cruise Lines',\n",
       "  'Miami, Florida',\n",
       "  '2017-10-13',\n",
       "  '0001513761'],\n",
       " ['NRG',\n",
       "  'NRG Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Independent Power Producers & Energy Traders',\n",
       "  'Princeton, New Jersey',\n",
       "  '2010-01-29',\n",
       "  '0001013871'],\n",
       " ['NUE',\n",
       "  'Nucor Corp.',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Steel',\n",
       "  'Charlotte, North Carolina',\n",
       "  '1985-04-30',\n",
       "  '0000073309'],\n",
       " ['NVDA',\n",
       "  'Nvidia Corporation',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Santa Clara, California',\n",
       "  '2001-11-30',\n",
       "  '0001045810'],\n",
       " ['ORLY',\n",
       "  \"O'Reilly Automotive\",\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Springfield, Missouri',\n",
       "  '2009-03-27',\n",
       "  '0000898173'],\n",
       " ['OXY',\n",
       "  'Occidental Petroleum',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Los Angeles, California',\n",
       "  '1982-12-31',\n",
       "  '0000797468'],\n",
       " ['OMC',\n",
       "  'Omnicom Group',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Advertising',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000029989'],\n",
       " ['OKE',\n",
       "  'ONEOK',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Storage & Transportation',\n",
       "  'Tulsa, Oklahoma',\n",
       "  '2010-03-15',\n",
       "  '0001039684'],\n",
       " ['ORCL',\n",
       "  'Oracle Corp.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'Redwood Shores, California',\n",
       "  '1989-08-31',\n",
       "  '0001341439'],\n",
       " ['PCAR',\n",
       "  'PACCAR Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Construction Machinery & Heavy Trucks',\n",
       "  'Bellevue, Washington',\n",
       "  '1980-12-31',\n",
       "  '0000075362'],\n",
       " ['PKG',\n",
       "  'Packaging Corporation of America',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Paper Packaging',\n",
       "  'Lake Forest, Illinois',\n",
       "  '2017-07-26',\n",
       "  '0000075677'],\n",
       " ['PH',\n",
       "  'Parker-Hannifin',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Cleveland, Ohio',\n",
       "  '1985-11-30',\n",
       "  '0000076334'],\n",
       " ['PDCO',\n",
       "  'Patterson Companies',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Supplies',\n",
       "  'St. Paul, Minnesota',\n",
       "  '2005-10-11',\n",
       "  '0000891024'],\n",
       " ['PAYX',\n",
       "  'Paychex Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Penfield, New York',\n",
       "  '',\n",
       "  '0000723531'],\n",
       " ['PYPL',\n",
       "  'PayPal',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Data Processing & Outsourced Services',\n",
       "  'San Jose, California',\n",
       "  '2015-07-20',\n",
       "  '0001633917'],\n",
       " ['PNR',\n",
       "  'Pentair Ltd.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'Worsley, UK',\n",
       "  '2012-10-01',\n",
       "  '0000077360'],\n",
       " ['PBCT',\n",
       "  \"People's United Financial\",\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Thrifts & Mortgage Finance',\n",
       "  'Bridgeport, Connecticut',\n",
       "  '2008-11-13',\n",
       "  '0001378946'],\n",
       " ['PEP',\n",
       "  'PepsiCo Inc.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Soft Drinks',\n",
       "  'Purchase, New York',\n",
       "  '',\n",
       "  '0000077476'],\n",
       " ['PKI',\n",
       "  'PerkinElmer',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Waltham, Massachusetts',\n",
       "  '1985-05-31',\n",
       "  '0000031791'],\n",
       " ['PRGO',\n",
       "  'Perrigo',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'Dublin, Ireland',\n",
       "  '2011-12-19',\n",
       "  '0001585364'],\n",
       " ['PFE',\n",
       "  'Pfizer Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000078003'],\n",
       " ['PCG',\n",
       "  'PG&E Corp.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'San Francisco, California',\n",
       "  '',\n",
       "  '0001004980'],\n",
       " ['PM',\n",
       "  'Philip Morris International',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Tobacco',\n",
       "  'New York, New York',\n",
       "  '2008-03-31',\n",
       "  '0001413329'],\n",
       " ['PSX',\n",
       "  'Phillips 66',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Refining & Marketing',\n",
       "  'Houston, Texas',\n",
       "  '2012-05-01',\n",
       "  '0001534701'],\n",
       " ['PNW',\n",
       "  'Pinnacle West Capital',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Phoenix, Arizona',\n",
       "  '',\n",
       "  '0000764622'],\n",
       " ['PXD',\n",
       "  'Pioneer Natural Resources',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Irving, Texas',\n",
       "  '2008-09-24',\n",
       "  '0001038357'],\n",
       " ['PNC',\n",
       "  'PNC Financial Services',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Pittsburgh, Pennsylvania',\n",
       "  '1988-04-30',\n",
       "  '0000713676'],\n",
       " ['RL',\n",
       "  'Polo Ralph Lauren Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'New York, New York',\n",
       "  '2007-02-02',\n",
       "  '0001037038'],\n",
       " ['PPG',\n",
       "  'PPG Industries',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Specialty Chemicals',\n",
       "  'Pittsburgh, Pennsylvania',\n",
       "  '',\n",
       "  '0000079879'],\n",
       " ['PPL',\n",
       "  'PPL Corp.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Allentown, Pennsylvania',\n",
       "  '',\n",
       "  '0000922224'],\n",
       " ['PX',\n",
       "  'Praxair Inc.',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Industrial Gases',\n",
       "  'Danbury, Connecticut',\n",
       "  '1992-07-01',\n",
       "  '0000884905'],\n",
       " ['PCLN',\n",
       "  'Priceline.com Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Internet & Direct Marketing Retail',\n",
       "  'Norwalk, Connecticut',\n",
       "  '2009-11-06',\n",
       "  '0001075531'],\n",
       " ['PFG',\n",
       "  'Principal Financial Group',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'Des Moines, Iowa',\n",
       "  '2002-07-22',\n",
       "  '0001126328'],\n",
       " ['PG',\n",
       "  'Procter & Gamble',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Personal Products',\n",
       "  'Cincinnati, Ohio',\n",
       "  '',\n",
       "  '0000080424'],\n",
       " ['PGR',\n",
       "  'Progressive Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'Mayfield Village, Ohio',\n",
       "  '1997-08-04',\n",
       "  '0000080661'],\n",
       " ['PLD',\n",
       "  'Prologis',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Industrial REITs',\n",
       "  'San Francisco, California',\n",
       "  '2003-07-17',\n",
       "  '0001045609'],\n",
       " ['PRU',\n",
       "  'Prudential Financial',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'Newark, New Jersey',\n",
       "  '2002-07-22',\n",
       "  '0001137774'],\n",
       " ['PEG',\n",
       "  'Public Serv. Enterprise Inc.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Newark, New Jersey',\n",
       "  '',\n",
       "  '0000788784'],\n",
       " ['PSA',\n",
       "  'Public Storage',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Glendale, California',\n",
       "  '2005-08-19',\n",
       "  '0001393311'],\n",
       " ['PHM',\n",
       "  'Pulte Homes Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Homebuilding',\n",
       "  'Atlanta, Georgia',\n",
       "  '1984-04-30',\n",
       "  '0000822416'],\n",
       " ['PVH',\n",
       "  'PVH Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'New York, New York',\n",
       "  '2013-02-15',\n",
       "  '0000078239'],\n",
       " ['QRVO',\n",
       "  'Qorvo',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Greensboro, North Carolina',\n",
       "  '2015-06-11',\n",
       "  '0001604778'],\n",
       " ['PWR',\n",
       "  'Quanta Services Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Construction & Engineering',\n",
       "  'Houston, Texas',\n",
       "  '2009-07-01',\n",
       "  '0001050915'],\n",
       " ['QCOM',\n",
       "  'QUALCOMM Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'San Diego, California',\n",
       "  '',\n",
       "  '0000804328'],\n",
       " ['DGX',\n",
       "  'Quest Diagnostics',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Services',\n",
       "  'Madison, New Jersey',\n",
       "  '2002-12-12',\n",
       "  '0001022079'],\n",
       " ['RRC',\n",
       "  'Range Resources Corp.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Exploration & Production',\n",
       "  'Fort Worth, Texas',\n",
       "  '2007-12-21',\n",
       "  '0000315852'],\n",
       " ['RJF',\n",
       "  'Raymond James Financial Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Investment Banking & Brokerage',\n",
       "  'St. Petersburg, Florida',\n",
       "  '2017-03-20',\n",
       "  '0000720005'],\n",
       " ['RTN',\n",
       "  'Raytheon Co.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Waltham, Massachusetts',\n",
       "  '',\n",
       "  '0001047122'],\n",
       " ['O',\n",
       "  'Realty Income Corporation',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'San Diego, California',\n",
       "  '2015-04-07',\n",
       "  '0000726728'],\n",
       " ['RHT',\n",
       "  'Red Hat Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Systems Software',\n",
       "  'Raleigh, North Carolina',\n",
       "  '2009-07-27',\n",
       "  '0001087423'],\n",
       " ['REG',\n",
       "  'Regency Centers Corporation',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'Jacksonville, Florida',\n",
       "  '2017-03-02',\n",
       "  '0000910606'],\n",
       " ['REGN',\n",
       "  'Regeneron',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Tarrytown, New York',\n",
       "  '2013-05-01',\n",
       "  '0000872589'],\n",
       " ['RF',\n",
       "  'Regions Financial Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Birmingham, Alabama',\n",
       "  '1998-08-28',\n",
       "  '0001281761'],\n",
       " ['RSG',\n",
       "  'Republic Services Inc',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Environmental & Facilities Services',\n",
       "  'Phoenix, Arizona',\n",
       "  '2008-12-05',\n",
       "  '0001060391'],\n",
       " ['RMD',\n",
       "  'ResMed',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'San Diego, California',\n",
       "  '2017-07-26',\n",
       "  '0000943819'],\n",
       " ['RHI',\n",
       "  'Robert Half International',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Human Resource & Employment Services',\n",
       "  'Menlo Park, California',\n",
       "  '2000-12-05',\n",
       "  '0000315213'],\n",
       " ['ROK',\n",
       "  'Rockwell Automation Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Electrical Components & Equipment',\n",
       "  'Milwaukee, Wisconsin',\n",
       "  '',\n",
       "  '0001024478'],\n",
       " ['COL',\n",
       "  'Rockwell Collins',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Cedar Rapids, Iowa',\n",
       "  '2001-07-02',\n",
       "  '0001137411'],\n",
       " ['ROP',\n",
       "  'Roper Technologies',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Conglomerates',\n",
       "  'Sarasota, Florida',\n",
       "  '2009-12-23',\n",
       "  '0000882835'],\n",
       " ['ROST',\n",
       "  'Ross Stores',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel Retail',\n",
       "  'Pleasanton, California',\n",
       "  '2009-12-21',\n",
       "  '0000745732'],\n",
       " ['RCL',\n",
       "  'Royal Caribbean Cruises Ltd',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Hotels, Resorts & Cruise Lines',\n",
       "  'Miami, Florida',\n",
       "  '2014-12-05',\n",
       "  '0000884887'],\n",
       " ['CRM',\n",
       "  'Salesforce.com',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'San Francisco, California',\n",
       "  '2008-09-15',\n",
       "  '0001108524'],\n",
       " ['SBAC',\n",
       "  'SBA Communications',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Boca Raton, Florida',\n",
       "  '2017-09-01',\n",
       "  '0001034054'],\n",
       " ['SCG',\n",
       "  'SCANA Corp',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Cayce, South Carolina',\n",
       "  '2009-01-02',\n",
       "  '0000754737'],\n",
       " ['SLB',\n",
       "  'Schlumberger Ltd.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Equipment & Services',\n",
       "  'Cura\\xc3\\xa7ao, Kingdom of the Netherlands',\n",
       "  '1965-03-31',\n",
       "  '0000087347'],\n",
       " ['SNI',\n",
       "  'Scripps Networks Interactive Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Cincinnati, Ohio',\n",
       "  '2008-07-01',\n",
       "  '0001430602'],\n",
       " ['STX',\n",
       "  'Seagate Technology',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Technology Hardware, Storage & Peripherals',\n",
       "  'Dublin, Ireland',\n",
       "  '2012-07-02',\n",
       "  '0001137789'],\n",
       " ['SEE',\n",
       "  'Sealed Air',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Paper Packaging',\n",
       "  'Elmwood Park, New Jersey',\n",
       "  '',\n",
       "  '0001012100'],\n",
       " ['SRE',\n",
       "  'Sempra Energy',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'San Diego, California',\n",
       "  '',\n",
       "  '0001032208'],\n",
       " ['SHW',\n",
       "  'Sherwin-Williams',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Specialty Chemicals',\n",
       "  'Cleveland, Ohio',\n",
       "  '1964-06-30',\n",
       "  '0000089800'],\n",
       " ['SIG',\n",
       "  'Signet Jewelers',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Hamilton, Bermuda',\n",
       "  '2015-07-29',\n",
       "  '0000832988'],\n",
       " ['SPG',\n",
       "  'Simon Property Group Inc',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Retail REITs',\n",
       "  'Indianapolis, Indiana',\n",
       "  '2002-06-26',\n",
       "  '0001063761'],\n",
       " ['SWKS',\n",
       "  'Skyworks Solutions',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Woburn, Massachusetts',\n",
       "  '2015-03-12',\n",
       "  '0000004127'],\n",
       " ['SLG',\n",
       "  'SL Green Realty',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Office REITs',\n",
       "  'New York, New York',\n",
       "  '2015-03-20',\n",
       "  '0001040971'],\n",
       " ['SNA',\n",
       "  'Snap-On Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Household Appliances',\n",
       "  'Kenosha, Wisconsin',\n",
       "  '1982-09-30',\n",
       "  '0000091440'],\n",
       " ['SO',\n",
       "  'Southern Co.',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Atlanta, Georgia',\n",
       "  '',\n",
       "  '0000092122'],\n",
       " ['LUV',\n",
       "  'Southwest Airlines',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Airlines',\n",
       "  'Dallas, Texas',\n",
       "  '1994-07-01',\n",
       "  '0000092380'],\n",
       " ['SPGI',\n",
       "  'S&P Global, Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Financial Exchanges & Data',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000064040'],\n",
       " ['SWK',\n",
       "  'Stanley Black & Decker',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Household Appliances',\n",
       "  'New Britain, Connecticut',\n",
       "  '1982-09-30',\n",
       "  '0000093556'],\n",
       " ['SBUX',\n",
       "  'Starbucks Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Restaurants',\n",
       "  'Seattle, Washington',\n",
       "  '',\n",
       "  '0000829224'],\n",
       " ['STT',\n",
       "  'State Street Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'Boston, Massachusetts',\n",
       "  '',\n",
       "  '0000093751'],\n",
       " ['SRCL',\n",
       "  'Stericycle Inc',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Environmental & Facilities Services',\n",
       "  'Lake Forest, Illinois',\n",
       "  '2008-11-19',\n",
       "  '0000861878'],\n",
       " ['SYK',\n",
       "  'Stryker Corp.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Kalamazoo, Michigan',\n",
       "  '2000-12-12',\n",
       "  '0000310764'],\n",
       " ['STI',\n",
       "  'SunTrust Banks',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Atlanta, Georgia',\n",
       "  '1988-05-31',\n",
       "  '0000750556'],\n",
       " ['SYMC',\n",
       "  'Symantec Corp.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'Mountain View, California',\n",
       "  '2003-03-25',\n",
       "  '0000849399'],\n",
       " ['SYF',\n",
       "  'Synchrony Financial',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Consumer Finance',\n",
       "  'Stamford, Connecticut',\n",
       "  '2015-11-18',\n",
       "  '0001601712'],\n",
       " ['SNPS',\n",
       "  'Synopsys Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Application Software',\n",
       "  'Mountain View, California',\n",
       "  '2017-03-16',\n",
       "  '0000883241'],\n",
       " ['SYY',\n",
       "  'Sysco Corp.',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Food Distributors',\n",
       "  'Houston, Texas',\n",
       "  '1986-12-31',\n",
       "  '0000096021'],\n",
       " ['TROW',\n",
       "  'T. Rowe Price Group',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Asset Management & Custody Banks',\n",
       "  'Baltimore, Maryland',\n",
       "  '',\n",
       "  '0001113169'],\n",
       " ['TPR',\n",
       "  'Tapestry, Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001116132'],\n",
       " ['TGT',\n",
       "  'Target Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'General Merchandise Stores',\n",
       "  'Minneapolis, Minnesota',\n",
       "  '1976-12-31',\n",
       "  '0000027419'],\n",
       " ['TEL',\n",
       "  'TE Connectivity Ltd.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Electronic Manufacturing Services',\n",
       "  'Schaffhausen, Switzerland',\n",
       "  '2011-10-17',\n",
       "  '0001385157'],\n",
       " ['FTI',\n",
       "  'TechnipFMC',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Equipment & Services',\n",
       "  'London, United Kingdom',\n",
       "  '2009-06-05',\n",
       "  '0001681459'],\n",
       " ['TXN',\n",
       "  'Texas Instruments',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'Dallas, Texas',\n",
       "  '',\n",
       "  '0000097476'],\n",
       " ['TXT',\n",
       "  'Textron Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Providence, Rhode Island',\n",
       "  '1978-12-31',\n",
       "  '0000217346'],\n",
       " ['TMO',\n",
       "  'Thermo Fisher Scientific',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Waltham, Massachusetts',\n",
       "  '',\n",
       "  '0000097745'],\n",
       " ['TIF',\n",
       "  'Tiffany & Co.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'New York, New York',\n",
       "  '2000-06-21',\n",
       "  '0000098246'],\n",
       " ['TWX',\n",
       "  'Time Warner Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001105705'],\n",
       " ['TJX',\n",
       "  'TJX Companies Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel Retail',\n",
       "  'Framingham, Massachusetts',\n",
       "  '1985-09-30',\n",
       "  '0000109198'],\n",
       " ['TMK',\n",
       "  'Torchmark Corp.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'McKinney, Texas',\n",
       "  '1989-04-30',\n",
       "  '0000320335'],\n",
       " ['TSS',\n",
       "  'Total System Services',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Columbus, Georgia',\n",
       "  '2008-01-02',\n",
       "  '0000721683'],\n",
       " ['TSCO',\n",
       "  'Tractor Supply Company',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Brentwood, Tennessee',\n",
       "  '2014-01-24',\n",
       "  '0000916365'],\n",
       " ['TDG',\n",
       "  'TransDigm Group',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Cleveland, Ohio',\n",
       "  '2016-06-03',\n",
       "  '0001260221'],\n",
       " ['TRV',\n",
       "  'The Travelers Companies Inc.',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'New York, New York',\n",
       "  '2002-08-21',\n",
       "  '0000086312'],\n",
       " ['TRIP',\n",
       "  'TripAdvisor',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Internet & Direct Marketing Retail',\n",
       "  'Newton, Massachusetts',\n",
       "  '2011-12-21',\n",
       "  '0001526520'],\n",
       " ['FOXA',\n",
       "  'Twenty-First Century Fox Class A',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Publishing',\n",
       "  'New York, New York',\n",
       "  '2013-07-01',\n",
       "  '0001308161'],\n",
       " ['FOX',\n",
       "  'Twenty-First Century Fox Class B',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Publishing',\n",
       "  'New York, New York',\n",
       "  '2015-09-18',\n",
       "  '0001308161'],\n",
       " ['TSN',\n",
       "  'Tyson Foods',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Packaged Foods & Meats',\n",
       "  'Springdale, Arkansas',\n",
       "  '',\n",
       "  '0000100493'],\n",
       " ['UDR',\n",
       "  'UDR Inc',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Residential REITs',\n",
       "  'Highlands Ranch, Colorado',\n",
       "  '2016-03-07',\n",
       "  '0000074208'],\n",
       " ['ULTA',\n",
       "  'Ulta Salon Cosmetics & Fragrance Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Specialty Stores',\n",
       "  'Bolingbrook, Illinois',\n",
       "  '2016-04-18',\n",
       "  '0001403568'],\n",
       " ['USB',\n",
       "  'U.S. Bancorp',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Diversified Banks',\n",
       "  'Minneapolis, Minnesota',\n",
       "  '',\n",
       "  '0000036104'],\n",
       " ['UA',\n",
       "  'Under Armour Class C',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'Baltimore, Maryland',\n",
       "  '2014-05-01',\n",
       "  '0001336917'],\n",
       " ['UAA',\n",
       "  'Under Armour Class A',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'Baltimore, Maryland',\n",
       "  '2016-03-25',\n",
       "  '0001336917'],\n",
       " ['UNP',\n",
       "  'Union Pacific',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Railroads',\n",
       "  'Omaha, Nebraska',\n",
       "  '',\n",
       "  '0000100885'],\n",
       " ['UAL',\n",
       "  'United Continental Holdings',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Airlines',\n",
       "  'Chicago, Illinois',\n",
       "  '2015-09-03',\n",
       "  '0000100517'],\n",
       " ['UNH',\n",
       "  'United Health Group Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Managed Health Care',\n",
       "  'Minnetonka, Minnesota',\n",
       "  '1994-07-01',\n",
       "  '0000731766'],\n",
       " ['UPS',\n",
       "  'United Parcel Service',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Air Freight & Logistics',\n",
       "  'Atlanta, Georgia',\n",
       "  '2002-07-22',\n",
       "  '0001090727'],\n",
       " ['URI',\n",
       "  'United Rentals, Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Trading Companies & Distributors',\n",
       "  'Stamford, Connecticut',\n",
       "  '2014-09-20',\n",
       "  '0001067701'],\n",
       " ['UTX',\n",
       "  'United Technologies',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Aerospace & Defense',\n",
       "  'Hartford, Connecticut',\n",
       "  '',\n",
       "  '0000101829'],\n",
       " ['UHS',\n",
       "  'Universal Health Services, Inc.',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Facilities',\n",
       "  'King of Prussia, Pennsylvania',\n",
       "  '2014-09-20',\n",
       "  '0000352915'],\n",
       " ['UNM',\n",
       "  'Unum Group',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Life & Health Insurance',\n",
       "  'Chattanooga, Tennessee',\n",
       "  '1994-03-01',\n",
       "  '0000005513'],\n",
       " ['VFC',\n",
       "  'V.F. Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Apparel, Accessories & Luxury Goods',\n",
       "  'Greensboro, North Carolina',\n",
       "  '1979-06-30',\n",
       "  '0000103379'],\n",
       " ['VLO',\n",
       "  'Valero Energy',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Refining & Marketing',\n",
       "  'San Antonio, Texas',\n",
       "  '',\n",
       "  '0001035002'],\n",
       " ['VAR',\n",
       "  'Varian Medical Systems',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Palo Alto, California',\n",
       "  '2007-02-12',\n",
       "  '0000203527'],\n",
       " ['VTR',\n",
       "  'Ventas Inc',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Health Care REITs',\n",
       "  'Chicago, Illinois',\n",
       "  '2009-03-04',\n",
       "  '0000740260'],\n",
       " ['VRSN',\n",
       "  'Verisign Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Dulles, Virginia',\n",
       "  '2006-02-01',\n",
       "  '0001014473'],\n",
       " ['VRSK',\n",
       "  'Verisk Analytics',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Research & Consulting Services',\n",
       "  'Jersey City, New Jersey',\n",
       "  '2015-10-08',\n",
       "  '0001442145'],\n",
       " ['VZ',\n",
       "  'Verizon Communications',\n",
       "  'reports',\n",
       "  'Telecommunication Services',\n",
       "  'Integrated Telecommunication Services',\n",
       "  'New York, New York',\n",
       "  '1983-11-30',\n",
       "  '0000732712'],\n",
       " ['VRTX',\n",
       "  'Vertex Pharmaceuticals Inc',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Biotechnology',\n",
       "  'Cambridge, Massachusetts',\n",
       "  '2013-09-23',\n",
       "  '0000875320'],\n",
       " ['VIAB',\n",
       "  'Viacom Inc.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0001339947'],\n",
       " ['V',\n",
       "  'Visa Inc.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'San Francisco, California',\n",
       "  '2009-12-21',\n",
       "  '0001403161'],\n",
       " ['VNO',\n",
       "  'Vornado Realty Trust',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Office REITs',\n",
       "  'New York, New York',\n",
       "  '',\n",
       "  '0000899689'],\n",
       " ['VMC',\n",
       "  'Vulcan Materials',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Construction Materials',\n",
       "  'Birmingham, Alabama',\n",
       "  '1999-06-30',\n",
       "  '0001396009'],\n",
       " ['WMT',\n",
       "  'Wal-Mart Stores',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Hypermarkets & Super Centers',\n",
       "  'Bentonville, Arkansas',\n",
       "  '1982-08-31',\n",
       "  '0000104169'],\n",
       " ['WBA',\n",
       "  'Walgreens Boots Alliance',\n",
       "  'reports',\n",
       "  'Consumer Staples',\n",
       "  'Drug Retail',\n",
       "  'Deerfield, Illinois',\n",
       "  '1979-12-31',\n",
       "  '0001618921'],\n",
       " ['DIS',\n",
       "  'The Walt Disney Company',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Cable & Satellite',\n",
       "  'Burbank, California',\n",
       "  '1976-06-30',\n",
       "  '0001001039'],\n",
       " ['WM',\n",
       "  'Waste Management Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Environmental & Facilities Services',\n",
       "  'Houston, Texas',\n",
       "  '',\n",
       "  '0000823768'],\n",
       " ['WAT',\n",
       "  'Waters Corporation',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Distributors',\n",
       "  'Milford, Massachusetts',\n",
       "  '',\n",
       "  '0001000697'],\n",
       " ['WEC',\n",
       "  'Wec Energy Group Inc',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Electric Utilities',\n",
       "  'Milwaukee, Wisconsin',\n",
       "  '2008-10-31',\n",
       "  '0000783325'],\n",
       " ['WFC',\n",
       "  'Wells Fargo',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Diversified Banks',\n",
       "  'San Francisco, California',\n",
       "  '1976-06-30',\n",
       "  '0000072971'],\n",
       " ['HCN',\n",
       "  'Welltower Inc.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Health Care REITs',\n",
       "  'Toledo, Ohio',\n",
       "  '2009-01-30',\n",
       "  '0000766704'],\n",
       " ['WDC',\n",
       "  'Western Digital',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Technology Hardware, Storage & Peripherals',\n",
       "  'Irvine, California',\n",
       "  '2009-07-01',\n",
       "  '0000106040'],\n",
       " ['WU',\n",
       "  'Western Union Co',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Internet Software & Services',\n",
       "  'Englewood, Colorado',\n",
       "  '',\n",
       "  '0001365135'],\n",
       " ['WRK',\n",
       "  'WestRock Company',\n",
       "  'reports',\n",
       "  'Materials',\n",
       "  'Paper Packaging',\n",
       "  'Richmond, Virginia',\n",
       "  '',\n",
       "  '0001636023'],\n",
       " ['WY',\n",
       "  'Weyerhaeuser Corp.',\n",
       "  'reports',\n",
       "  'Real Estate',\n",
       "  'Specialized REITs',\n",
       "  'Federal Way, Washington',\n",
       "  '',\n",
       "  '0000106535'],\n",
       " ['WHR',\n",
       "  'Whirlpool Corp.',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Household Appliances',\n",
       "  'Benton Harbor, Michigan',\n",
       "  '',\n",
       "  '0000106640'],\n",
       " ['WMB',\n",
       "  'Williams Cos.',\n",
       "  'reports',\n",
       "  'Energy',\n",
       "  'Oil & Gas Storage & Transportation',\n",
       "  'Tulsa, Oklahoma',\n",
       "  '1975-03-31',\n",
       "  '0000107263'],\n",
       " ['WLTW',\n",
       "  'Willis Towers Watson',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Insurance Brokers',\n",
       "  'London, United Kingdom',\n",
       "  '2016-01-05',\n",
       "  '0001140536'],\n",
       " ['WYN',\n",
       "  'Wyndham Worldwide',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Hotels, Resorts & Cruise Lines',\n",
       "  'Parsippany, New Jersey',\n",
       "  '',\n",
       "  '0001361658'],\n",
       " ['WYNN',\n",
       "  'Wynn Resorts Ltd',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Casinos & Gaming',\n",
       "  'Paradise, Nevada',\n",
       "  '2008-11-14',\n",
       "  '0001174922'],\n",
       " ['XEL',\n",
       "  'Xcel Energy Inc',\n",
       "  'reports',\n",
       "  'Utilities',\n",
       "  'Multi-Utilities',\n",
       "  'Minneapolis, Minnesota',\n",
       "  '',\n",
       "  '0000072903'],\n",
       " ['XRX',\n",
       "  'Xerox Corp.',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Technology Hardware, Storage & Peripherals',\n",
       "  'Norwalk, Connecticut',\n",
       "  '',\n",
       "  '0000108772'],\n",
       " ['XLNX',\n",
       "  'Xilinx Inc',\n",
       "  'reports',\n",
       "  'Information Technology',\n",
       "  'Semiconductors',\n",
       "  'San Jose, California',\n",
       "  '1999-11-08',\n",
       "  '0000743988'],\n",
       " ['XL',\n",
       "  'XL Capital',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Property & Casualty Insurance',\n",
       "  'Hamilton, Bermuda',\n",
       "  '',\n",
       "  '0000875159'],\n",
       " ['XYL',\n",
       "  'Xylem Inc.',\n",
       "  'reports',\n",
       "  'Industrials',\n",
       "  'Industrial Machinery',\n",
       "  'White Plains, New York',\n",
       "  '2011-11-01',\n",
       "  '0001524472'],\n",
       " ['YUM',\n",
       "  'Yum! Brands Inc',\n",
       "  'reports',\n",
       "  'Consumer Discretionary',\n",
       "  'Restaurants',\n",
       "  'Louisville, Kentucky',\n",
       "  '1997-10-06',\n",
       "  '0001041061'],\n",
       " ['ZBH',\n",
       "  'Zimmer Biomet Holdings',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Health Care Equipment',\n",
       "  'Warsaw, Indiana',\n",
       "  '2001-08-07',\n",
       "  '0001136869'],\n",
       " ['ZION',\n",
       "  'Zions Bancorp',\n",
       "  'reports',\n",
       "  'Financials',\n",
       "  'Regional Banks',\n",
       "  'Salt Lake City, Utah',\n",
       "  '',\n",
       "  '0000109380'],\n",
       " ['ZTS',\n",
       "  'Zoetis',\n",
       "  'reports',\n",
       "  'Health Care',\n",
       "  'Pharmaceuticals',\n",
       "  'Florham Park, New Jersey',\n",
       "  '2013-06-21',\n",
       "  '0001555280']]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "##exporting csv\n",
    "import csv\n",
    "\n",
    "with open(\"SP_500.csv\", \"wb\") as f:\n",
    "    writer = csv.writer(f)\n",
    "    writer.writerows(rows)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}