Context

The dataset has been downloaded from a BuzzFeed news article that was posted on Jan 15, 2017. The link to the original source can be checked in the Acknowledgements section.

The authors have created a database of more than 1500 people/organization who have a connection with the Trump family, his top advisors or his cabinet picks.

The dataset can help us to capture how policy decisions may be impacted by these varied connections.

**Please Up Vote if you find it useful!**

Content

You have three datasets to play with.

Person_Person.csv: Each row represents a connection between a person and another person (eg. Charles Kushner and Alan Hammer)
Person_Org.csv: Each row represents a connection between a person and an organization (eg. 401 NORTH WABASH VENTURE LLC. and Donald J. Trump)
Org_Org.csv: Each row represents a connection between an organization and another organization (eg. TRUMP COMMERCIAL CHICAGO LLC and 401 NORTH WABASH VENTURE LLC. )

All the three files are in the following format:

Column1: Person or Organization (A)
Column2: Person or Organization (B)
Column3: Connection between (A) and (B)
Column4: Source url from which the connection is derived

Acknowledgements

Source: https://www.buzzfeed.com/johntemplon/help-us-map-trumpworld

Inspiration

https://github.com/BuzzFeedNews/trumpworld

This is an incomplete database, and you are free to add more connections.

Tables

Approval Polllist

@kaggle.skylord_trumpworld.approval_polllist

466.92 KB
11579 rows
22 columns


CREATE TABLE approval_polllist (
  "president" VARCHAR,
  "subgroup" VARCHAR,
  "modeldate" TIMESTAMP,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "pollster" VARCHAR,
  "grade" VARCHAR,
  "samplesize" DOUBLE,
  "population" VARCHAR,
  "weight" DOUBLE,
  "influence" DOUBLE,
  "approve" DOUBLE,
  "disapprove" DOUBLE,
  "adjusted_approve" DOUBLE,
  "adjusted_disapprove" DOUBLE,
  "multiversions" VARCHAR,
  "tracking" VARCHAR,
  "url" VARCHAR,
  "poll_id" BIGINT,
  "question_id" BIGINT,
  "createddate" TIMESTAMP,
  "timestamp" VARCHAR
);