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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 5 | 2007 | 27.56521739 | 28 | 14 | 19 | 30 | 29 | 7 | 21 | 24 | 18 | 14 | 35 | 22 | 57 | 8 | 34 | 2 | 69 | 72 | 40 | 5 | 29 | 28 | 29 | ||||||||||||||
| 15 | 15 | 2017 | 26.78378378 | 22 | 14 | 11 | 19 | 29 | 25 | 17 | 23 | 7 | 10 | 22 | 53 | 29 | 40 | 23 | 24 | 69 | 17 | 58 | 56 | 9 | 15 | 18 | 11 | 49 | 51 | 58 | 26 | 39 | 51 | 13 | 14 | 12 | 15 | 5 | 17 | 20 |
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 );