Trump World Trust: TRUMPWORLD-pres.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

2 rows where Israel = 49

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ year avg Canada France Germany Greece Hungary Italy Netherlands Poland Spain Sweden UK Russia Australia India Indonesia Japan Philippines South Korea Vietnam Israel Jordan Lebanon Tunisia Turkey Ghana Kenya Nigeria Senegal South Africa Tanzania Argentina Brazil Chile Colombia Mexico Peru Venezuela
9 9 2011 57.93333333   84 88         52 67   75 41     62 81       49 28 43   12   86           63     38    
13 13 2015 63.16129032 76 83 73     77   64 58   76 11 81 74 64 66 94 88 71 49 14 36   45 82 80 73 77 77 78 40 63 60   49 53 26

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "trump-world-trust/TRUMPWORLD-pres" (
"year" INTEGER,
  "avg" REAL,
  "Canada" INTEGER,
  "France" INTEGER,
  "Germany" INTEGER,
  "Greece" INTEGER,
  "Hungary" INTEGER,
  "Italy" INTEGER,
  "Netherlands" INTEGER,
  "Poland" INTEGER,
  "Spain" INTEGER,
  "Sweden" INTEGER,
  "UK" INTEGER,
  "Russia" INTEGER,
  "Australia" INTEGER,
  "India" INTEGER,
  "Indonesia" INTEGER,
  "Japan" INTEGER,
  "Philippines" INTEGER,
  "South Korea" INTEGER,
  "Vietnam" INTEGER,
  "Israel" INTEGER,
  "Jordan" INTEGER,
  "Lebanon" INTEGER,
  "Tunisia" INTEGER,
  "Turkey" INTEGER,
  "Ghana" INTEGER,
  "Kenya" INTEGER,
  "Nigeria" INTEGER,
  "Senegal" INTEGER,
  "South Africa" INTEGER,
  "Tanzania" INTEGER,
  "Argentina" INTEGER,
  "Brazil" INTEGER,
  "Chile" INTEGER,
  "Colombia" INTEGER,
  "Mexico" INTEGER,
  "Peru" INTEGER,
  "Venezuela" INTEGER
);