hpi_cleaned
Data license: Apache License · Data source: Happy Planet Index
137 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | Country | Region | AvrgLifeExpectancy | AvrgWellBeing | HappyLifeYears | Footprint | Inequality | HappyPlanetIndex | GDPPerCapita | Population | G10 | cca3 | landlocked | NumOfficialLanguages | NumBorderingCountries | area |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37 | 37 | El Salvador | Americas | 72.5 | 5.9 | 32.2 | 2.1 | 0.22 | 35.6 | 3922 | 6072233 | 0 | SLV | 0 | 1 | 2 | 21041 |
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 |
35 | 35 | Ecuador | Americas | 75.4 | 6.0 | 34.3 | 2.2 | 0.22 | 37.0 | 5702 | 15419493 | 0 | ECU | 0 | 1 | 2 | 276841 |
34 | 34 | Dominican Republic | Americas | 73.1 | 4.8 | 23.7 | 1.5 | 0.3 | 30.3 | 5967 | 10155036 | 0 | DOM | 0 | 1 | 1 | 48671 |
33 | 33 | Djibouti | Sub Saharan Africa | 61.3 | 4.4 | 15.1 | 2.2 | 0.42 | 16.4 | 1587 | 853069 | 0 | DJI | 0 | 2 | 3 | 23200 |
32 | 32 | Denmark | Europe | 79.8 | 7.5 | 54.4 | 5.5 | 0.07 | 32.7 | 57636 | 5591572 | 0 | DNK | 0 | 1 | 1 | 43094 |
31 | 31 | Cyprus | Europe | 79.8 | 6.2 | 42.3 | 4.2 | 0.12 | 30.7 | 28868 | 1129303 | 0 | CYP | 0 | 2 | 0 | 9251 |
30 | 30 | Croatia | Post-communist | 77.0 | 6.0 | 39.6 | 3.9 | 0.12 | 30.2 | 13236 | 4267558 | 0 | HRV | 0 | 1 | 5 | 56594 |
29 | 29 | Costa Rica | Americas | 79.1 | 7.3 | 48.2 | 2.8 | 0.15 | 44.7 | 9733 | 4654148 | 0 | CRI | 0 | 1 | 2 | 51100 |
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 |
27 | 27 | Colombia | Americas | 73.7 | 6.4 | 35.1 | 1.9 | 0.24 | 40.7 | 7885 | 46881018 | 0 | COL | 0 | 1 | 5 | 1141748 |
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 |
25 | 25 | Chile | Americas | 81.1 | 6.6 | 44.7 | 4.4 | 0.14 | 31.7 | 15253 | 17388437 | 0 | CHL | 0 | 1 | 3 | 756102 |
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 |
23 | 23 | Canada | Americas | 81.7 | 7.4 | 53.9 | 8.2 | 0.09 | 23.9 | 52738 | 34751476 | 1 | CAN | 0 | 2 | 1 | 9984670 |
22 | 22 | Cameroon | Sub Saharan Africa | 54.6 | 4.2 | 11.6 | 1.2 | 0.47 | 16.7 | 1222 | 21659488 | 0 | CMR | 0 | 2 | 6 | 475442 |
21 | 21 | Cambodia | Asia Pacific | 67.5 | 3.9 | 18.2 | 1.2 | 0.28 | 25.6 | 946 | 14832255 | 0 | KHM | 0 | 1 | 3 | 181035 |
20 | 20 | Burundi | Sub Saharan Africa | 55.8 | 3.4 | 9.5 | 0.8 | 0.48 | 15.6 | 244 | 10124572 | 0 | BDI | 1 | 2 | 3 | 27834 |
19 | 19 | Burkina Faso | Sub Saharan Africa | 58.0 | 4.0 | 12.6 | 1.2 | 0.43 | 17.9 | 673 | 16590813 | 0 | BFA | 1 | 1 | 6 | 272967 |
18 | 18 | Bulgaria | Post-communist | 73.9 | 4.2 | 24.0 | 3.3 | 0.19 | 20.4 | 7333 | 7305888 | 0 | BGR | 0 | 1 | 5 | 110879 |
17 | 17 | Brazil | Americas | 73.9 | 6.9 | 39.0 | 3.1 | 0.22 | 34.3 | 12157 | 202401584 | 0 | BRA | 0 | 1 | 10 | 8515767 |
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 |
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 |
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 |
13 | 13 | Bhutan | Asia Pacific | 68.7 | 5.6 | 27.4 | 2.3 | 0.27 | 28.6 | 2452 | 743711 | 0 | BTN | 1 | 1 | 2 | 38394 |
12 | 12 | Benin | Sub Saharan Africa | 59.2 | 3.2 | 9.9 | 1.4 | 0.44 | 13.4 | 808 | 10049792 | 0 | BEN | 0 | 1 | 4 | 112622 |
11 | 11 | Belize | Americas | 69.8 | 6.1 | 34.2 | 2.5 | 0.18 | 33.8 | 4674 | 336707 | 0 | BLZ | 0 | 3 | 2 | 22966 |
10 | 10 | Belgium | Europe | 80.4 | 6.9 | 49.5 | 7.4 | 0.09 | 23.7 | 44731 | 11128246 | 1 | BEL | 0 | 3 | 4 | 30528 |
9 | 9 | Belarus | Post-communist | 70.9 | 5.7 | 34.0 | 5.1 | 0.13 | 21.7 | 6722 | 9464000 | 0 | BLR | 1 | 2 | 5 | 207600 |
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 |
7 | 7 | Austria | Europe | 81.0 | 7.4 | 54.4 | 6.1 | 0.07 | 30.5 | 48324 | 8429991 | 0 | AUT | 1 | 1 | 8 | 83871 |
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 |
5 | 5 | Armenia | Post-communist | 74.4 | 4.3 | 24.0 | 2.2 | 0.22 | 25.7 | 3566 | 2978339 | 0 | ARM | 1 | 1 | 4 | 29743 |
4 | 4 | Argentina | Americas | 75.9 | 6.5 | 40.2 | 3.1 | 0.16 | 35.2 | 14357 | 42095224 | 0 | ARG | 0 | 2 | 5 | 2780400 |
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 |
2 | 2 | Albania | Post-communist | 77.3 | 5.5 | 34.4 | 2.2 | 0.17 | 36.8 | 4247 | 2900489 | 0 | ALB | 0 | 1 | 4 | 28748 |
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 |
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 );