trump-world-trust/TRUMPWORLD-pres

1 row where Germany = 86 sorted by Canada descending

View and edit SQL

Germany

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
14 2016 73.88235294 83 84 86 41 58 68 92 58 75 93 79   84 58   78                   83 63   73                

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 109.967ms