hpi_cleaned

Data license: Apache License · Data source: Happy Planet Index

1 row where AvrgLifeExpectancy = "79.1" and Region = "Americas"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Country Region AvrgLifeExpectancy AvrgWellBeing HappyLifeYears Footprint Inequality HappyPlanetIndex GDPPerCapita Population G10 cca3 landlocked NumOfficialLanguages NumBorderingCountries area
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);