trump-world-trust/TRUMPWORLD-pres

2 rows where Russia = 41 sorted by Nigeria

View and edit SQL

Germany

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

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