Trump World Trust: TRUMPWORLD-issue-2.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: net_approval, Approve, Disapprove, DK/Refused

Link rowid ▼ country net_approval Approve Disapprove DK/Refused
1 1 Canada -71 13 84 3
2 2 France -79 10 89 1
3 3 Germany -81 8 89 3
4 4 Greece -60 18 78 5
5 5 Hungary -14 35 49 16
6 6 Italy -56 17 73 10
7 7 Netherlands -79 9 88 2
8 8 Poland -45 18 63 19
9 9 Spain -85 7 92 1
10 10 Sweden -89 5 94 1
11 11 United Kingdom -71 12 83 4
12 12 Russia -12 35 47 17
13 13 Australia -59 19 78 3
14 14 India -4 25 29 47
15 15 Indonesia -38 19 57 23
16 16 Japan -63 15 78 7
17 17 Philippines -33 28 61 12
18 18 South Korea -71 12 83 6
19 19 Vietnam -14 35 49 17
20 20 Israel -2 42 44 13
21 21 Jordan -2 44 46 10
22 22 Lebanon -52 14 66 20
23 23 Tunisia -40 20 60 21
24 24 Turkey -51 12 63 24
25 25 Ghana -35 29 64 6
26 26 Kenya -28 33 61 6
27 27 Nigeria -12 38 50 12
28 28 Senegal -65 12 77 10
29 29 South Africa -23 32 55 13
30 30 Tanzania -30 31 61 8
31 31 Argentina -72 11 83 6
32 32 Brazil -61 15 76 9
33 33 Chile -76 10 86 5
34 34 Colombia -81 8 89 2
35 35 Mexico -89 5 94 2
36 36 Peru -62 16 78 7
37 37 Venezuela -65 14 79 7

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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