Mapping the Trump World

Data Sources

This data set was largely compiled from the Buzzfeed Trumpworld Dataset. This dataset contains relationships between people and organizations in the Trump network, as found in legal filings and news articles. Each element, or node, in that data set has an accompanying reference for where that relationship was identified, and are displayed in the "Search" and "Learn More About" results.

We further enriched the Buzzfeed data by adding in 3 other sources - we'd love to get to more! This was inspired by and heavily leveraged the great work that the Neo4j community has contributed, and can all be found at the Neo4j Trumpworld Github.

First, we matched the companies in the Buzzfeed dataset against all US Federal Contracts that were awarded in 2016. This identified companies in the network that were awarded contracts, and created a connection between the awarding federal agency and the company.

Next, we joined all of the people and organizations in the dataset against information found in LittleSis.org. LittleSis is a watchdog organization which doucments relationsihps between powerful individuals and orgnaizations. This added hundreds of connections to our original network.

Finally, we merged in all of the nominees for President Trump's administration positions, as documented in the Tracker Database of the Washington Post. This data is current as of Feb 18, 2017. This again created new relationships between people and the federal aganecies that they were nominated to work at.

All data was loaded and merged using Neo4j community edition, exported into a graphML file, manipulated into JSON and built using cytoscape.js.

Goals

• Create a searchable network,
• Help journalists and curious citizens with their research,
• Allow exploration of complex relationships between the many businesses, federal agencies and associates in the Trump network

Graph Representation

We also have an adjacency matrix representation of the Trump World data for those who would like a more academic perspective. You can view that here.

Authors

This website was created by Sharmila Velamur (sharmila.velamur@berkeley.edu) and Chandler McCann (chandler.mccann@berkeley.edu) as their class project for W209 Data Visualization and Communication at The University of California, Berkeley Data Science Program.