hpi_cleaned
Data license: Apache License · Data source: Happy Planet Index
137 rows
This data as json, CSV (advanced)
Link | rowid ▼ | Country | Region | AvrgLifeExpectancy | AvrgWellBeing | HappyLifeYears | Footprint | Inequality | HappyPlanetIndex | GDPPerCapita | Population | G10 | cca3 | landlocked | NumOfficialLanguages | NumBorderingCountries | area |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | Romania | Post-communist | 74.3 | 5.2 | 30.1 | 2.7 | 0.19 | 28.8 | 8577 | 20058035 | 0 | ROU | 0 | 1 | 5 | 238391 |
102 | 102 | Russian Federation | Post-communist | 69.5 | 5.6 | 31.7 | 5.7 | 0.16 | 18.7 | 14079 | 143201676 | 0 | RUS | 0 | 1 | 14 | 17098242 |
103 | 103 | Rwanda | Sub Saharan Africa | 63.1 | 3.3 | 12.4 | 0.9 | 0.37 | 19.6 | 667 | 10817350 | 0 | RWA | 1 | 3 | 4 | 26338 |
104 | 104 | Senegal | Sub Saharan Africa | 65.4 | 3.7 | 15.5 | 1.2 | 0.33 | 21.9 | 1019 | 13780108 | 0 | SEN | 0 | 1 | 5 | 196722 |
105 | 105 | Serbia | Post-communist | 74.5 | 5.2 | 30.3 | 2.7 | 0.19 | 29.0 | 5659 | 7199077 | 0 | SRB | 1 | 1 | 8 | 88361 |
106 | 106 | Sierra Leone | Sub Saharan Africa | 49.8 | 4.5 | 10.8 | 1.2 | 0.5 | 15.3 | 619 | 6043157 | 0 | SLE | 0 | 1 | 2 | 71740 |
107 | 107 | Slovakia | Post-communist | 75.9 | 5.9 | 37.9 | 4.1 | 0.13 | 28.2 | 17207 | 5407579 | 0 | SVK | 1 | 1 | 5 | 49037 |
108 | 108 | Slovenia | Post-communist | 80.0 | 6.1 | 42.6 | 5.8 | 0.1 | 24.6 | 22478 | 2057159 | 0 | SVN | 0 | 1 | 4 | 20273 |
109 | 109 | South Africa | Sub Saharan Africa | 56.3 | 5.1 | 18.5 | 3.3 | 0.33 | 15.9 | 7592 | 52341695 | 0 | ZAF | 0 | 11 | 6 | 1221037 |
110 | 110 | South Korea | Asia Pacific | 81.3 | 6.0 | 42.2 | 5.7 | 0.11 | 24.8 | 24454 | 50004441 | 0 | KOR | 0 | 1 | 1 | 100210 |
111 | 111 | Spain | Europe | 82.2 | 6.3 | 45.3 | 3.7 | 0.1 | 36.0 | 28648 | 46773055 | 0 | ESP | 0 | 1 | 5 | 505992 |
112 | 112 | Sri Lanka | Asia Pacific | 74.6 | 4.2 | 24.9 | 1.3 | 0.17 | 33.8 | 3351 | 20424000 | 0 | LKA | 0 | 2 | 1 | 65610 |
113 | 113 | Suriname | Americas | 70.8 | 6.3 | 35.2 | 4.3 | 0.19 | 25.4 | 9422 | 528535 | 0 | SUR | 0 | 1 | 3 | 163820 |
114 | 114 | Swaziland | Sub Saharan Africa | 48.9 | 4.9 | 13.6 | 2.0 | 0.41 | 15.5 | 3989 | 1231694 | 0 | SWZ | 1 | 2 | 2 | 17364 |
115 | 115 | Sweden | Europe | 81.8 | 7.6 | 57.4 | 7.3 | 0.06 | 28.0 | 57134 | 9519374 | 1 | SWE | 0 | 1 | 2 | 450295 |
116 | 116 | Switzerland | Europe | 82.6 | 7.8 | 59.3 | 5.8 | 0.06 | 34.3 | 83209 | 7996861 | 1 | CHE | 1 | 4 | 5 | 41284 |
117 | 117 | Syria | Middle East | 70.4 | 3.2 | 14.7 | 1.5 | 0.3 | 19.1 | 2080 | 21427155 | 0 | SYR | 0 | 1 | 5 | 185180 |
118 | 118 | Tajikistan | Post-communist | 69.0 | 4.5 | 22.2 | 0.9 | 0.26 | 34.2 | 962 | 7930929 | 0 | TJK | 1 | 2 | 4 | 143100 |
119 | 119 | Tanzania | Sub Saharan Africa | 63.5 | 4.0 | 16.2 | 1.3 | 0.33 | 22.1 | 828 | 48645709 | 0 | TZA | 0 | 2 | 8 | 945087 |
120 | 120 | Thailand | Asia Pacific | 74.1 | 6.3 | 38.6 | 2.7 | 0.15 | 37.3 | 5918 | 67164130 | 0 | THA | 0 | 1 | 4 | 513120 |
121 | 121 | Togo | Sub Saharan Africa | 58.6 | 2.9 | 9.0 | 1.1 | 0.43 | 13.2 | 580 | 6745581 | 0 | TGO | 0 | 1 | 3 | 56785 |
122 | 122 | Trinidad and Tobago | Americas | 70.1 | 6.4 | 34.4 | 7.9 | 0.21 | 15.7 | 18322 | 1341579 | 0 | TTO | 0 | 1 | 0 | 5130 |
123 | 123 | Tunisia | Middle East | 74.6 | 4.5 | 25.2 | 2.3 | 0.22 | 26.2 | 4188 | 10777500 | 0 | TUN | 0 | 1 | 2 | 163610 |
124 | 124 | Turkey | Middle East | 74.7 | 5.3 | 31.2 | 3.3 | 0.19 | 26.4 | 10646 | 74099255 | 0 | TUR | 0 | 1 | 8 | 783562 |
125 | 125 | Turkmenistan | Post-communist | 65.3 | 5.5 | 24.0 | 5.5 | 0.31 | 14.6 | 6798 | 5172941 | 0 | TKM | 1 | 2 | 4 | 488100 |
126 | 126 | Uganda | Sub Saharan Africa | 57.1 | 4.3 | 13.8 | 1.2 | 0.41 | 19.4 | 656 | 35400620 | 0 | UGA | 1 | 2 | 5 | 241550 |
127 | 127 | Ukraine | Post-communist | 70.3 | 5.0 | 28.3 | 2.8 | 0.17 | 26.4 | 3855 | 45593300 | 0 | UKR | 0 | 1 | 7 | 603500 |
128 | 128 | United Kingdom | Europe | 80.4 | 6.9 | 49.1 | 4.9 | 0.09 | 31.9 | 41295 | 63700300 | 1 | GBR | 0 | 1 | 1 | 242900 |
129 | 129 | United States of America | Americas | 78.8 | 7.0 | 46.8 | 8.2 | 0.13 | 20.7 | 51457 | 314112078 | 1 | USA | 0 | 1 | 2 | 9372610 |
130 | 130 | Uruguay | Americas | 76.9 | 6.4 | 39.4 | 2.9 | 0.18 | 36.1 | 15128 | 3396753 | 0 | URY | 0 | 1 | 2 | 181034 |
131 | 131 | Uzbekistan | Post-communist | 68.2 | 6.0 | 27.9 | 2.3 | 0.3 | 29.1 | 1719 | 29774500 | 0 | UZB | 1 | 2 | 5 | 447400 |
132 | 132 | Vanuatu | Asia Pacific | 71.3 | 6.5 | 34.9 | 1.9 | 0.22 | 40.6 | 3158 | 247498 | 0 | VUT | 0 | 3 | 0 | 12189 |
133 | 133 | Venezuela | Americas | 73.9 | 7.1 | 41.5 | 3.6 | 0.19 | 33.6 | 12772 | 29854238 | 0 | VEN | 0 | 1 | 3 | 916445 |
134 | 134 | Vietnam | Asia Pacific | 75.5 | 5.5 | 32.8 | 1.7 | 0.19 | 40.3 | 1755 | 88809200 | 0 | VNM | 0 | 1 | 3 | 331212 |
135 | 135 | Yemen | Middle East | 63.3 | 4.1 | 15.2 | 1.0 | 0.39 | 22.8 | 1289 | 24882792 | 0 | YEM | 0 | 1 | 2 | 527968 |
136 | 136 | Zambia | Sub Saharan Africa | 58.4 | 5.0 | 16.7 | 1.0 | 0.41 | 25.2 | 1687 | 14786581 | 0 | ZMB | 1 | 1 | 8 | 752612 |
137 | 137 | Zimbabwe | Sub Saharan Africa | 53.7 | 5.0 | 16.4 | 1.4 | 0.37 | 22.1 | 851 | 14565482 | 0 | ZWE | 1 | 15 | 4 | 390757 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "hpi_cleaned" ( "Country" TEXT, "Region" TEXT, "AvrgLifeExpectancy" REAL, "AvrgWellBeing" REAL, "HappyLifeYears" REAL, "Footprint" REAL, "Inequality" REAL, "HappyPlanetIndex" REAL, "GDPPerCapita" INTEGER, "Population" INTEGER, "G10" INTEGER, "cca3" TEXT, "landlocked" INTEGER, "NumOfficialLanguages" INTEGER, "NumBorderingCountries" INTEGER, "area" INTEGER );