trump-world-trust/TRUMPWORLD-pres

3 rows where Spain = 7 sorted by Hungary

View and edit SQL

Turkey

Germany

Israel

France

Spain

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
4 2006 17.77777778   15 25           7   30 21     20 32         7     3                          
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  
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

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
);
Powered by Datasette · Query took 57.457ms