It all started with Jeremy Singer-Vine and his co-authors publishing a partial dataset of connections between organizations and people around Donald Trump.
The data was made available as a public Google Document, which we imported into Neo4j so that it became queryable and visualizable.
You can access the TrumpWorld Graph live at https://neo4j.com/sandbox
You can also run the TrumpWorld Guide in any Neo4j Browser by executing :play http://guides.neo4j.com/trumpworld
Which cover the import, queries and visualizations and the extension with the federal contract data.
In this repository you can find the different resources and scripts for imports, querying and visualization.
-
TrumpWorld Import & Queries 01-trumpworld
-
Adding US Government Contracting Data 02-contracts
-
Merging OpenCorporates Records 03-opencorporates
-
The Nonprofits of Trumpworld 04-nonprofit
-
Extending Trumpworld with LittleSis - the involuntary Facebook of the 1% (also contains a lot of FEC data) 05-littlesis
-
Trump Tweet Graph since June 2015 based on buzzfeeds Trump Media article 06-trumptweets
-
Nominees for the different governmental departments and embassies 07-trump-nominees
MATCH network = (:Person {name:"JARED KUSHNER"})-[*..2]-()
RETURN network
MATCH (o:Organization)<-[:INVOLVED_WITH]-(p:Person)-[con:RELATED_TO]->()
WHERE con.connection CONTAINS "Nominee"
RETURN o,p
-
Trumpworld Graph in Neo4j Blog Post by Michael Hunger
-
Adding US Government Contracting Data - USASpending.gov Blog Post by William Lyon
-
TrumpWorld Database Instance (username/pwd - trumpworld/trumpworld)
-
TrumpWorld Graph Visualization by Kim Albrecht FastCo, Wired
-
GraphGist TrumpWorld Advanced (needs APOC procedures installed)
-
Run GraphGists as browser guides:
:play http://portal.graphgist.org/graph_gists/trumpworld-graph/graph_guide -
NICAR Presentation: Finding Insights In Connected Data: Using Graph Databases In Journalism
Collaborate with Brown University, ProPublica, ICIJ, OCCRP, and others to enrich the dataset and find new insights.
