Whale in a suit
Big Corporate Whale Hunting

How connected is the S&P 500?

The 500 largest US public companies are supposed to be competitors, customers and suppliers of one another. They are also, quietly, run by an overlapping cast of people. A director of Procter & Gamble also sits on Medtronic's board; a Microsoft director also sits on Visa's. This site maps every one of those overlaps. This post is about how we rebuilt it on public SEC data over the last few weeks, and what turned up.

9,478directors & officers tracked
1,061sit at two or more S&P 500 companies
466of 500 companies in one connected web
3.9average “handshakes” between any two of them

What we built

The idea is simple: two companies are linked if one person holds a role at both. Put all 500 companies in a network with those links and you can ask how tightly the index is knit together, who the hubs are, and which companies stand alone.

The site now has three views of that network:

How we built it

The first version got its director lists from another source, which stopped working. So we switched to the source the data comes from anyway, the SEC.

Every director and officer of a US public company must file a Form 3 when they join and a Form 4 whenever they trade the company's shares. The SEC publishes all of these as quarterly bulk data sets. For each company we take the people flagged as a director or officer, keep their most recent filing, and record their title. Matching people by their SEC ID rather than by name is what makes the cross-company links trustworthy: two different “John Smith”s stay two people.

The rest of the pipeline is plumbing:

  1. Scrape the current S&P 500 list from Wikipedia, and drop companies that have left the index.
  2. Pull directors and officers from the SEC filings.
  3. Fetch today's market cap for every company from Yahoo Finance.
  4. Export JSON for the tables, and lay out the graph offline in Python so the page just draws it.

What broke along the way

Public data is messy. A few of the problems worth knowing about if you try something similar:

What we found

It's a small world

Of the 500 companies, 466 are joined into a single web by shared people. Between any two of those, the average shortest chain is just 3.9 links, and the longest is 9. Nvidia to ExxonMobil takes three hops: Nvidia shares a person with Intuit, Intuit with Cisco, Cisco with Exxon. From Procter & Gamble you can reach 139 companies in two hops and 346, more than two thirds of the index, in three.

The hubs are household names

The best-connected companies are not tech giants or banks but old-line consumer and industrial brands, whose boards are stocked with sitting and former CEOs from elsewhere.

By contrast, some of the index's most valuable companies are nearly self-contained: Nvidia links to 3 companies and Tesla to 1. Size helps, though: the biggest quarter of the index by market cap averages 7.4 connections, against 3.8 for the smallest quarter.

The people with the most seats

Most people (8,417 of 9,478) hold a role at only one S&P 500 company. 141 hold roles at three or more. Craig Arnold, former CEO of Eaton, sits on five boards: Honeywell, its newly spun-off Honeywell Aerospace, KKR, Medtronic and Procter & Gamble. Thirteen more people sit on four, including Marissa Mayer (AT&T, Hilton, Starbucks, Walmart), Teri List (Danaher, Lululemon, Microsoft, Visa) and Patricia Russo (GM, HPE, KKR, Merck).

Nor is it only outside directors. 189 people who are CEO somewhere in the index also sit on another S&P 500 board. CSX's CEO, Stephen Angel, is a director of GE, GE Vernova and Linde; Nasdaq's CEO, Adena Friedman, sits on Intuit's board.

Spin-offs keep their parents' boards

The heaviest links in the whole network are corporate families, not friendships. Honeywell and Honeywell Aerospace share five directors; FedEx and FedEx Freight share three; GE shares people with both GE HealthCare and GE Vernova. Among unrelated companies, the strongest ties are three shared directors each between Illinois Tool Works and Northern Trust (both Chicago), Vulcan Materials and Regions Financial (both Birmingham, Alabama), and Genuine Parts and Rollins (both Atlanta). Geography, it seems, matters.

Sectors cluster, but not by much

27% of links join two companies in the same sector, against about 11% if people were spread at random. So boards do lean towards their own industry, but nearly three quarters of links cross sectors, which is what makes the web so tightly knit. Consumer staples companies are the most connected sector (6.7 links on average); utilities the least (3.0).

Who stands alone

34 companies share no one with any other S&P 500 company. They include Berkshire Hathaway, Palantir, Las Vegas Sands, Garmin, Schlumberger, CME Group, TransDigm and Interactive Brokers, along with a cluster of regional utilities and energy producers. Several are founder- or family-controlled, which fits.

Money behind the seats

About 400 people work for, or represent, a private-equity, venture or hedge fund, found from their SEC filings and from the director biographies in each company's proxy statement. Silver Lake and Perella Weinberg each have four people across the index; KKR, Greylock and Madison Dearborn three each. This is the most heuristic part of the data: a spot check found about 88% of flagged firms were right. The directors table shows them in its Investment firm column.

Caveats

Explore it yourself

Search for a company or a person in the tables, or open the graph and click a company to see who it is tied to.