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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | 7 | 2009 | 67.17647059 | 88 | 91 | 93 | 62 | 72 | 86 | 37 | 71 | 85 | 81 | 56 | 31 | 46 | 33 | 94 | 61 | 55 |
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 );