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

5 rows where Approve = 19

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: net_approval, Disapprove, DK/Refused

Link rowid ▼ country net_approval Approve Disapprove DK/Refused
13 13 Australia -58 19 77 4
20 20 Israel -50 19 69 11
21 21 Jordan -53 19 72 9
32 32 Brazil -50 19 69 13
35 35 Mexico -58 19 77 4

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
);