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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 12 | 2014 | 55.0625 | 83 | 71 | 27 | 75 | 55 | 58 | 74 | 15 | 48 | 60 | 60 | 89 | 84 | 67 | 71 | 17 | 35 | 27 | 24 | 60 | 78 | 53 | 73 | 72 | 74 | 31 | 52 | 54 | 56 | 40 | 46 | 33 |
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 );