fivethirtyeight: trump-world-trust/TRUMPWORLD-pres: 15 rows

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)

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

15 rows

descending

✎ 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
1	1	2001	33.5		20	51			33					30
2	2	2003	34.15384615	59	20	33			43			26		51	8	59					36		83	1	17		8
3	3	2005	26.33333333	40	25	30				39	47	18		38	28			19						1	23		8
4	4	2006	17.77777778		15	25						7		30	21			20	32					7			3
5	5	2007	27.56521739	28	14	19			30		29	7	21	24	18			14	35		22		57	8	34		2	69	72				40	5		29		28	29
6	6	2008	21.88235294		13	14					41	8		16	22	23		23	25		30			7	33		2					32	60	7				16
7	7	2009	67.17647059	88	91	93					62	72		86	37			71	85		81		56	31	46		33		94					61				55
8	8	2010	62.82352941		87	90					60	69		84	41			67	76		75			26	43		23		95	84				49	56			43
9	9	2011	57.93333333		84	88					52	67		75	41			62	81				49	28	43		12		86						63			38
10	10	2012	53.33333333		86	87	30		73		50	61		80	36				74					22	39	28	24								68			42
11	11	2013	58.1	81	83	88	35		76		49	54		72	29	77	53	53	70	84	77		61	24	37	24	29	55	81	53	78	74		44	69	56		49		28
12	12	2014	55.0625		83	71	27		75		55	58		74	15		48	60	60	89	84	67	71	17	35	27	24	60	78	53	73	72	74	31	52	54	56	40	46	33
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
14	14	2016	73.88235294	83	84	86	41	58	68	92	58	75	93	79		84	58		78										83	63		73
15	15	2017	26.78378378	22	14	11	19	29	25	17	23	7	10	22	53	29	40	23	24	69	17	58	56	9	15	18	11	49	51	58	26	39	51	13	14	12	15	5	17	20

Advanced export

JSON shape: default, array, newline-delimited

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

Trump World Trust: TRUMPWORLD-pres.csv

15 rows

Advanced export