Trump World Trust: TRUMPWORLD-issue-1.csv

Table actions

This table contains data behind the story What The World Thinks Of Trump.

Two of the datasets concern the share of different countries' populations that:

  • Have a favorable view of the U.S. (TRUMPWORLD-us.csv)
  • Trust the U.S. president when it comes to world affairs (TRUMPWORLD-pres.csv)

The other five are approval ratings across countries for five of President Trump's proposed policies:

  • Withdraw support for international climate change agreements (TRUMPWORLD-issue-1.csv)
  • Build a wall on the border between the U. S. and Mexico (TRUMPWORLD-issue-2.csv)
  • Withdraw U.S. support from the Iran nuclear weapons agreement (TRUMPWORLD-issue-3.csv)
  • Withdraw U.S. support for major trade agreements (TRUMPWORLD-issue-4.csv)
  • Introduce tighter restrictions on those entering the U.S. from some majority-Muslim countries (TRUMPWORLD-issue-5.csv)

Source: Pew Research Center

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

3 rows where net_approval = "-36"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Approve, Disapprove, DK/Refused

Link rowid ▼ country net_approval Approve Disapprove DK/Refused
19 19 Vietnam -36 26 62 11
30 30 Tanzania -36 29 65 6
36 36 Peru -36 29 65 6

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "trump-world-trust/TRUMPWORLD-issue-1" (
"country" TEXT,
  "net_approval" INTEGER,
  "Approve" INTEGER,
  "Disapprove" INTEGER,
  "DK/Refused" INTEGER
);