hpi_cleaned
Data license: Apache License · Data source: Happy Planet Index
137 rows sorted by Population
This data as json, CSV (advanced)
Link | rowid | Country | Region | AvrgLifeExpectancy | AvrgWellBeing | HappyLifeYears | Footprint | Inequality | HappyPlanetIndex | GDPPerCapita | Population ▼ | G10 | cca3 | landlocked | NumOfficialLanguages | NumBorderingCountries | area |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
23 | 23 | Canada | Americas | 81.7 | 7.4 | 53.9 | 8.2 | 0.09 | 23.9 | 52738 | 34751476 | 1 | CAN | 0 | 2 | 1 | 9984670 |
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 |
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 |
99 | 99 | Poland | Post-communist | 76.9 | 5.9 | 39.2 | 4.4 | 0.11 | 27.5 | 13142 | 38063164 | 0 | POL | 0 | 1 | 7 | 312679 |
4 | 4 | Argentina | Americas | 75.9 | 6.5 | 40.2 | 3.1 | 0.16 | 35.2 | 14357 | 42095224 | 0 | ARG | 0 | 2 | 5 | 2780400 |
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 |
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 |
111 | 111 | Spain | Europe | 82.2 | 6.3 | 45.3 | 3.7 | 0.1 | 36.0 | 28648 | 46773055 | 0 | ESP | 0 | 1 | 5 | 505992 |
27 | 27 | Colombia | Americas | 73.7 | 6.4 | 35.1 | 1.9 | 0.24 | 40.7 | 7885 | 46881018 | 0 | COL | 0 | 1 | 5 | 1141748 |
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 |
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 |
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 |
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 |
60 | 60 | Italy | Europe | 82.7 | 5.8 | 41.1 | 4.6 | 0.12 | 28.1 | 34844 | 59539717 | 1 | ITA | 0 | 1 | 6 | 301336 |
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 |
41 | 41 | France | Europe | 81.8 | 6.6 | 48.1 | 5.1 | 0.09 | 30.4 | 40850 | 65639975 | 1 | FRA | 0 | 1 | 8 | 551695 |
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 |
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 |
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 |
44 | 44 | Germany | Europe | 80.6 | 6.7 | 48.2 | 5.3 | 0.08 | 29.8 | 44011 | 80425823 | 1 | DEU | 0 | 1 | 9 | 357114 |
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 |
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 |
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 |
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 |
78 | 78 | Mexico | Americas | 76.4 | 7.3 | 44.3 | 2.9 | 0.19 | 40.7 | 9703 | 122070963 | 0 | MEX | 0 | 1 | 3 | 1964375 |
62 | 62 | Japan | Asia Pacific | 83.2 | 6.0 | 44.0 | 5.0 | 0.09 | 28.3 | 46679 | 127561489 | 1 | JPN | 0 | 1 | 0 | 377930 |
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 |
8 | 8 | Bangladesh | Asia Pacific | 70.8 | 4.7 | 23.3 | 0.7 | 0.27 | 38.4 | 859 | 155257387 | 0 | BGD | 0 | 1 | 2 | 147570 |
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 |
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 |
17 | 17 | Brazil | Americas | 73.9 | 6.9 | 39.0 | 3.1 | 0.22 | 34.3 | 12157 | 202401584 | 0 | BRA | 0 | 1 | 10 | 8515767 |
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 |
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 |
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 |
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 |
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 );