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

7 rows where DK/Refused = 7

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ country net_approval Approve Disapprove DK/Refused
4 4 Greece -71 11 82 7
17 17 Philippines -43 25 68 7
25 25 Ghana -47 23 70 7
27 27 Nigeria -29 32 61 7
33 33 Chile -65 14 79 7
34 34 Colombia -49 22 71 7
37 37 Venezuela -52 21 73 7

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