On January 15, BuzzFeed released a large dataset of Donald Trump’s connections, including people, organizations and the nature of their relationships.
In their article “Help Us Map TrumpWorld”, the four authors of the investigation, John Templon, Anthony Cormier, Alex Campbell and Jeremy Singer-Vine, asked the public to help them understand and analyse the data.
Now we are asking the public to use our data to find connections we may have missed, and to give us context we don’t currently understand. We hope you will help us — and the public — learn more about TrumpWorld and how this unprecedented array of businesses might affect public policy.”
So we decided to see what it would looks like in Linkurious, our graph analysis and visualization tool.
The result is a graph of 770 nodes and 611 edges. We then connected Linkurious to this dataset to start exploring it. Following, are some visual representations of the TrumpWorld dataset in Linkurious:
To clarify the visualization, we added some custom labels. All nodes are organizations. The ones whose name contains the word “bank” are half orange. The ones whose name contains the word “hotel” are half-blue. And the ones whose name contains “Trump” or “DT” are half pink. The other ones are entirely green.
As reported by Forbes in May 2016, Trump’s Personal Financial Disclosure (PFD) listed the future President as being associated with 515 different organizations. Among his most valuable assets were the Trump Tower Commercial LLC and the 40 Wall Street LLC. Let’s look up the connections between those two entities.
The Trump Tower Commercial LLc and 40 Wall Street Commercial LLC have seven connections in common. Both companies share a “owns collateralized debt” with investment funds and assess management companies such as The Vanguard Group or Russell Investments.
We can also look into details in DJT Holdings LLC, one of Donald Trump’s most important asset:
The visualization shows that DJT Holding LLC is connected to a lot of others companies via a “ownership” relationship. The companies owns more than 30 other organizations, working as a corporate umbrella for the Trump Empire. DJT Holdings is itself owned by the Donald J. Trump Revocable Trust.
Finally if you look into the famous Trump Hotel & Casino Resorts incorporation, we get the following result:
Around thirty organisation gravitate around the Trump Hotel & Casino Resorts Incorporation as “Subsidiaries”. Once again it confirms the taste of Donald Trump for complicated corporate structures.
Graph visualization tools help understand complex connections within large datasets. TrumpWorld dataset was turned into a clear view of the network of organisations around Donald Trump. We can identify key organizations and scheme quickly.
We will soon update this case with more data, notably the network and connections of people.
If you want to visualize and investigate the TrumpWorld data in Linkurious, simply download the database here, connect it to Neo4j and use Linkurious to visualize it.