hpi_cleaned
Data license: Apache License · Data source: Happy Planet Index
137 rows sorted by NumOfficialLanguages
This data as json, CSV (advanced)
Link | rowid | Country | Region | AvrgLifeExpectancy | AvrgWellBeing | HappyLifeYears | Footprint | Inequality | HappyPlanetIndex | GDPPerCapita | Population | G10 | cca3 | landlocked | NumOfficialLanguages ▼ | NumBorderingCountries | area |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | Kenya | Sub Saharan Africa | 60.3 | 4.5 | 16.2 | 1.0 | 0.38 | 24.2 | 1185 | 42542978 | 0 | KEN | 0 | 2 | 5 | 580367 |
65 | 65 | Kyrgyzstan | Post-communist | 69.7 | 5.2 | 28.7 | 1.9 | 0.18 | 33.1 | 1178 | 5607200 | 0 | KGZ | 1 | 2 | 4 | 199951 |
67 | 67 | Lebanon | Middle East | 78.8 | 4.6 | 28.2 | 3.8 | 0.19 | 21.9 | 9729 | 4440728 | 0 | LBN | 0 | 2 | 2 | 10452 |
68 | 68 | Lesotho | Sub Saharan Africa | 48.9 | 4.9 | 13.4 | 1.7 | 0.42 | 16.7 | 1159 | 2057331 | 0 | LSO | 1 | 2 | 1 | 30355 |
73 | 73 | Malawi | Sub Saharan Africa | 60.1 | 4.3 | 13.7 | 0.8 | 0.45 | 22.1 | 270 | 15700436 | 0 | MWI | 1 | 2 | 3 | 118484 |
74 | 74 | Malaysia | Asia Pacific | 74.4 | 5.9 | 38.3 | 3.7 | 0.1 | 30.3 | 10835 | 29021940 | 0 | MYS | 0 | 2 | 3 | 330803 |
75 | 75 | Malta | Europe | 80.2 | 6.0 | 40.8 | 4.4 | 0.13 | 29.0 | 21176 | 419455 | 0 | MLT | 0 | 2 | 0 | 316 |
81 | 81 | Morocco | Middle East | 73.4 | 5.0 | 26.7 | 1.7 | 0.25 | 32.7 | 2931 | 32984190 | 0 | MAR | 0 | 2 | 3 | 446550 |
93 | 93 | Pakistan | Asia Pacific | 65.7 | 5.1 | 19.5 | 0.8 | 0.4 | 31.5 | 1266 | 177392252 | 0 | PAK | 0 | 2 | 4 | 881912 |
96 | 96 | Paraguay | Americas | 72.6 | 5.8 | 31.8 | 4.2 | 0.22 | 23.3 | 3858 | 6379162 | 0 | PRY | 1 | 2 | 3 | 406752 |
98 | 98 | Philippines | Asia Pacific | 67.9 | 5.0 | 24.1 | 1.1 | 0.26 | 35.0 | 2605 | 96017322 | 0 | PHL | 0 | 2 | 0 | 342353 |
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 |
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 |
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 |
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 |
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 |
1 | 1 | Afghanistan | Middle East | 59.7 | 3.8 | 12.4 | 0.8 | 0.43 | 20.2 | 691 | 29726803 | 0 | AFG | 1 | 3 | 6 | 652230 |
10 | 10 | Belgium | Europe | 80.4 | 6.9 | 49.5 | 7.4 | 0.09 | 23.7 | 44731 | 11128246 | 1 | BEL | 0 | 3 | 4 | 30528 |
11 | 11 | Belize | Americas | 69.8 | 6.1 | 34.2 | 2.5 | 0.18 | 33.8 | 4674 | 336707 | 0 | BLZ | 0 | 3 | 2 | 22966 |
15 | 15 | Bosnia and Herzegovina | Post-communist | 76.2 | 4.8 | 28.6 | 3.1 | 0.19 | 25.3 | 4495 | 3828419 | 0 | BIH | 0 | 3 | 3 | 51209 |
28 | 28 | Comoros | Sub Saharan Africa | 62.6 | 4.0 | 15.4 | 1.0 | 0.36 | 23.1 | 750 | 733661 | 0 | COM | 0 | 3 | 0 | 1862 |
54 | 54 | India | Asia Pacific | 67.3 | 4.6 | 20.4 | 1.2 | 0.31 | 29.2 | 1450 | 1263589639 | 0 | IND | 0 | 3 | 6 | 3287590 |
57 | 57 | Iraq | Middle East | 69.0 | 4.7 | 22.8 | 1.9 | 0.27 | 26.5 | 6649 | 32780975 | 0 | IRQ | 0 | 3 | 6 | 438317 |
71 | 71 | Luxembourg | Europe | 81.1 | 7.0 | 51.7 | 15.8 | 0.07 | 13.2 | 105447 | 530946 | 0 | LUX | 1 | 3 | 3 | 2586 |
77 | 77 | Mauritius | Sub Saharan Africa | 74.0 | 5.5 | 33.1 | 3.5 | 0.17 | 27.4 | 9114 | 1255882 | 0 | MUS | 0 | 3 | 0 | 2040 |
87 | 87 | New Zealand | Asia Pacific | 81.4 | 7.2 | 52.7 | 5.6 | 0.08 | 31.3 | 39505 | 4408100 | 0 | NZL | 0 | 3 | 0 | 270467 |
91 | 91 | Norway | Europe | 81.3 | 7.7 | 57.1 | 5.0 | 0.07 | 36.8 | 101564 | 5018573 | 0 | NOR | 0 | 3 | 3 | 323802 |
97 | 97 | Peru | Americas | 74.1 | 5.8 | 32.9 | 2.3 | 0.21 | 34.6 | 6389 | 30158768 | 0 | PER | 0 | 3 | 5 | 1285216 |
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 |
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 |
14 | 14 | Bolivia, Plurinational State of | Americas | 67.5 | 6.0 | 25.6 | 3.0 | 0.35 | 23.3 | 2645 | 10238762 | 0 | BOL | 1 | 4 | 5 | 1098581 |
116 | 116 | Switzerland | Europe | 82.6 | 7.8 | 59.3 | 5.8 | 0.06 | 34.3 | 83209 | 7996861 | 1 | CHE | 1 | 4 | 5 | 41284 |
84 | 84 | Namibia | Sub Saharan Africa | 64.0 | 4.7 | 21.3 | 2.5 | 0.26 | 21.6 | 5680 | 2291645 | 0 | NAM | 0 | 9 | 4 | 825615 |
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 |
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 );