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

37 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Approve, Disapprove, DK/Refused

net_approval 27 ✖

Link rowid ▼ country net_approval Approve Disapprove DK/Refused
1 1 Canada -64 15 79 5
2 2 France -81 9 90 1
3 3 Germany -88 5 93 2
4 4 Greece -71 11 82 7
5 5 Hungary -62 13 75 12
6 6 Italy -49 18 67 15
7 7 Netherlands -83 8 91 2
8 8 Poland -35 17 52 31
9 9 Spain -83 8 91 1
10 10 Sweden -87 6 93 1
11 11 United Kingdom -66 14 80 6
12 12 Russia -22 27 49 24
13 13 Australia -58 19 77 4
14 14 India 7 32 25 43
15 15 Indonesia -16 31 47 22
16 16 Japan -59 13 72 15
17 17 Philippines -43 25 68 7
18 18 South Korea -65 13 78 9
19 19 Vietnam -36 26 62 11
20 20 Israel -50 19 69 11
21 21 Jordan -53 19 72 9
22 22 Lebanon -60 14 74 12
23 23 Tunisia -37 21 58 22
24 24 Turkey -42 15 57 27
25 25 Ghana -47 23 70 7
26 26 Kenya -35 30 65 5
27 27 Nigeria -29 32 61 7
28 28 Senegal -71 10 81 8
29 29 South Africa -14 36 50 14
30 30 Tanzania -36 29 65 6
31 31 Argentina -52 18 70 12
32 32 Brazil -50 19 69 13
33 33 Chile -65 14 79 7
34 34 Colombia -49 22 71 7
35 35 Mexico -58 19 77 4
36 36 Peru -36 29 65 6
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
);