World Happiness Report

Happiness scored according to economic production, social support, etc.

@kaggle.unsdsn_world_happiness

Table List

5 tables(107.4 KB)

N 2015

N 2016

N 2017

N 2018

N 2019

N 2017

@kaggle.unsdsn_world_happiness.n_2017

24.34 KB
155 rows
12 columns

country Country	happiness_rank Happiness.Rank	happiness_score Happiness.Score	whisker_high Whisker.high	whisker_low Whisker.low	economy_gdp_per_capita Economy..GDP.per.Capita.	family Family	health_life_expectancy Health..Life.Expectancy.	freedom Freedom	generosity Generosity	trust_government_corruption Trust..Government.Corruption.	dystopia_residual Dystopia.Residual
Norway	1	7.53700017929077	7.59444482058287	7.47955553799868	1.61646318435669	1.53352355957031	0.796666502952576	0.635422587394714	0.36201223731041	0.315963834524155	2.27702665328979
Denmark	2	7.52199983596802	7.58172806486487	7.46227160707116	1.48238301277161	1.55112159252167	0.792565524578094	0.626006722450256	0.355280488729477	0.40077006816864	2.31370735168457
Iceland	3	7.50400018692017	7.62203047305346	7.38596990078688	1.480633020401	1.6105740070343	0.833552122116089	0.627162635326385	0.475540220737457	0.153526559472084	2.32271528244019
Switzerland	4	7.49399995803833	7.56177242040634	7.42622749567032	1.56497955322266	1.51691174507141	0.858131289482117	0.620070576667786	0.290549278259277	0.367007285356522	2.2767162322998
Finland	5	7.4689998626709	7.52754207581282	7.41045764952898	1.44357192516327	1.5402467250824	0.80915766954422	0.617950856685638	0.24548277258873	0.38261154294014	2.4301815032959
Netherlands	6	7.3769998550415	7.42742584124207	7.32657386884093	1.50394463539124	1.42893922328949	0.810696125030518	0.585384488105774	0.470489829778671	0.282661825418472	2.29480409622192
Canada	7	7.31599998474121	7.38440283536911	7.24759713411331	1.47920441627502	1.48134899139404	0.83455765247345	0.611100912094116	0.435539722442627	0.287371516227722	2.18726444244385
New Zealand	8	7.31400012969971	7.3795104418695	7.24848981752992	1.40570604801178	1.54819512367249	0.816759705543518	0.614062130451202	0.500005125999451	0.382816702127457	2.0464563369751
Sweden	9	7.28399991989136	7.34409487739205	7.22390496239066	1.49438726902008	1.47816216945648	0.830875158309937	0.612924098968506	0.385399252176285	0.384398728609085	2.09753799438477
Australia	10	7.28399991989136	7.35665122494102	7.2113486148417	1.484414935112	1.51004195213318	0.84388679265976	0.601607382297516	0.477699249982834	0.301183730363846	2.06521081924438


CREATE TABLE n_2017 (
  "country" VARCHAR,
  "happiness_rank" BIGINT,
  "happiness_score" DOUBLE,
  "whisker_high" DOUBLE,
  "whisker_low" DOUBLE,
  "economy_gdp_per_capita" DOUBLE,
  "family" DOUBLE,
  "health_life_expectancy" DOUBLE,
  "freedom" DOUBLE,
  "generosity" DOUBLE,
  "trust_government_corruption" DOUBLE,
  "dystopia_residual" DOUBLE
);