This data as json, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | 9 | 2011 | 57.93333333 | 84 | 88 | 52 | 67 | 75 | 41 | 62 | 81 | 49 | 28 | 43 | 12 | 86 | 63 | 38 | ||||||||||||||||||||||
| 14 | 14 | 2016 | 73.88235294 | 83 | 84 | 86 | 41 | 58 | 68 | 92 | 58 | 75 | 93 | 79 | 84 | 58 | 78 | 83 | 63 | 73 |
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 );