trump-world-trust/TRUMPWORLD-pres

2 rows where Russia = 41 sorted by South Africa

View and edit SQL

Russia

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
8 2010 62.82352941   87 90         60 69   84 41     67 76   75     26 43   23   95 84       49 56     43    
9 2011 57.93333333   84 88         52 67   75 41     62 81       49 28 43   12   86           63     38    

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