hpi_cleaned
Data license: Apache License · Data source: Happy Planet Index
137 rows sorted by area
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 |
16 | 16 | Botswana | Sub Saharan Africa | 64.2 | 4.8 | 21.3 | 3.8 | 0.28 | 16.6 | 6936 | 2132822 | 0 | BWA | 1 | 2 | 4 | 582000 |
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 |
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 |
83 | 83 | Myanmar | Asia Pacific | 65.5 | 4.4 | 18.8 | 1.4 | 0.32 | 24.7 | 1421 | 52543841 | 0 | MMR | 0 | 1 | 5 | 676578 |
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 |
25 | 25 | Chile | Americas | 81.1 | 6.6 | 44.7 | 4.4 | 0.14 | 31.7 | 15253 | 17388437 | 0 | CHL | 0 | 1 | 3 | 756102 |
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 |
82 | 82 | Mozambique | Sub Saharan Africa | 54.3 | 5.0 | 15.0 | 0.9 | 0.43 | 23.7 | 565 | 25732928 | 0 | MOZ | 0 | 1 | 6 | 801590 |
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 |
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 |
133 | 133 | Venezuela | Americas | 73.9 | 7.1 | 41.5 | 3.6 | 0.19 | 33.6 | 12772 | 29854238 | 0 | VEN | 0 | 1 | 3 | 916445 |
90 | 90 | Nigeria | Sub Saharan Africa | 52.1 | 5.5 | 15.5 | 1.2 | 0.44 | 22.2 | 2740 | 168240403 | 0 | NGA | 0 | 1 | 4 | 923768 |
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 |
36 | 36 | Egypt | Middle East | 70.7 | 4.2 | 21.8 | 2.2 | 0.23 | 23.8 | 3226 | 85660902 | 0 | EGY | 0 | 1 | 4 | 1002450 |
76 | 76 | Mauritania | Sub Saharan Africa | 62.6 | 4.7 | 18.0 | 2.5 | 0.37 | 18.0 | 1283 | 3777067 | 0 | MRT | 0 | 1 | 4 | 1030700 |
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 |
39 | 39 | Ethiopia | Sub Saharan Africa | 62.8 | 4.6 | 17.8 | 1.0 | 0.36 | 26.7 | 470 | 92191211 | 0 | ETH | 1 | 1 | 6 | 1104300 |
27 | 27 | Colombia | Americas | 73.7 | 6.4 | 35.1 | 1.9 | 0.24 | 40.7 | 7885 | 46881018 | 0 | COL | 0 | 1 | 5 | 1141748 |
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 |
89 | 89 | Niger | Sub Saharan Africa | 60.0 | 3.8 | 13.1 | 1.6 | 0.4 | 16.8 | 394 | 17635782 | 0 | NER | 1 | 1 | 7 | 1267000 |
24 | 24 | Chad | Sub Saharan Africa | 50.8 | 4.0 | 9.6 | 1.5 | 0.51 | 12.8 | 973 | 12715465 | 0 | TCD | 1 | 2 | 6 | 1284000 |
97 | 97 | Peru | Americas | 74.1 | 5.8 | 32.9 | 2.3 | 0.21 | 34.6 | 6389 | 30158768 | 0 | PER | 0 | 3 | 5 | 1285216 |
79 | 79 | Mongolia | Asia Pacific | 68.6 | 4.9 | 25.3 | 6.1 | 0.22 | 14.3 | 4377 | 2808339 | 0 | MNG | 1 | 1 | 2 | 1564110 |
56 | 56 | Iran | Middle East | 74.8 | 4.6 | 25.4 | 2.8 | 0.23 | 24.0 | 7711 | 76156975 | 0 | IRN | 0 | 1 | 7 | 1648195 |
55 | 55 | Indonesia | Asia Pacific | 68.5 | 5.4 | 28.4 | 1.6 | 0.21 | 35.7 | 3701 | 248037853 | 0 | IDN | 0 | 1 | 3 | 1904569 |
78 | 78 | Mexico | Americas | 76.4 | 7.3 | 44.3 | 2.9 | 0.19 | 40.7 | 9703 | 122070963 | 0 | MEX | 0 | 1 | 3 | 1964375 |
3 | 3 | Algeria | Middle East | 74.3 | 5.6 | 30.5 | 2.1 | 0.24 | 33.3 | 5584 | 37439427 | 0 | DZA | 0 | 1 | 7 | 2381741 |
63 | 63 | Kazakhstan | Post-communist | 68.6 | 5.8 | 31.7 | 5.6 | 0.18 | 19.1 | 12120 | 16791425 | 0 | KAZ | 1 | 2 | 5 | 2724900 |
4 | 4 | Argentina | Americas | 75.9 | 6.5 | 40.2 | 3.1 | 0.16 | 35.2 | 14357 | 42095224 | 0 | ARG | 0 | 2 | 5 | 2780400 |
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 |
6 | 6 | Australia | Asia Pacific | 82.1 | 7.2 | 53.1 | 9.3 | 0.08 | 21.2 | 67646 | 22728254 | 0 | AUS | 0 | 1 | 0 | 7692024 |
17 | 17 | Brazil | Americas | 73.9 | 6.9 | 39.0 | 3.1 | 0.22 | 34.3 | 12157 | 202401584 | 0 | BRA | 0 | 1 | 10 | 8515767 |
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 |
26 | 26 | China | Asia Pacific | 75.4 | 5.1 | 30.6 | 3.4 | 0.17 | 25.7 | 6265 | 1350695000 | 0 | CHN | 0 | 1 | 16 | 9706961 |
23 | 23 | Canada | Americas | 81.7 | 7.4 | 53.9 | 8.2 | 0.09 | 23.9 | 52738 | 34751476 | 1 | CAN | 0 | 2 | 1 | 9984670 |
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 |
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 );