World Happiness Report Up To 2022

Bliss scored agreeing to financial, social, etc.

@kaggle.mathurinache_world_happiness_report

Table List

8 tables(202.33 KB)

N 2015

N 2016

N 2017

N 2018

N 2019

N 2020

N 2021

N 2022

N 2020

@kaggle.mathurinache_world_happiness_report.n_2020

41.31 KB
153 rows
20 columns

country_name Country Name	regional_indicator Regional Indicator	ladder_score Ladder Score	standard_error_of_ladder_score Standard Error Of Ladder Score	upperwhisker Upperwhisker	lowerwhisker Lowerwhisker	logged_gdp_per_capita Logged GDP Per Capita	social_support Social Support	healthy_life_expectancy Healthy Life Expectancy	freedom_to_make_life_choices Freedom To Make Life Choices	generosity Generosity	perceptions_of_corruption Perceptions Of Corruption	ladder_score_in_dystopia Ladder Score In Dystopia	explained_by_log_gdp_per_capita Explained By: Log GDP Per Capita	explained_by_social_support Explained By: Social Support	explained_by_healthy_life_expectancy Explained By: Healthy Life Expectancy	explained_by_freedom_to_make_life_choices Explained By: Freedom To Make Life Choices	explained_by_generosity Explained By: Generosity	explained_by_perceptions_of_corruption Explained By: Perceptions Of Corruption	dystopia_residual Dystopia + Residual
Finland	Western Europe	7.808700085	0.031156305	7.869766235	7.747633934	10.63926697	0.954329729	71.9008255	0.949172199	-0.059482019	0.195444584	1.972316742	1.285189509	1.499525905	0.961271405	0.66231674	0.159670442	0.477857262	2.762835026
Denmark	Western Europe	7.645599842	0.033492286	7.711244583	7.579955101	10.77400112	0.955990791	72.40250397	0.951444268	0.066201776	0.168489456	1.972316742	1.326948524	1.503449202	0.979332566	0.665039897	0.242793396	0.495260328	2.432740688
Switzerland	Western Europe	7.559899807	0.035014171	7.628527641	7.491271973	10.97993279	0.942846596	74.10244751	0.921336651	0.105911039	0.303728431	1.972316742	1.39077425	1.472403407	1.040533185	0.62895447	0.269055754	0.407945901	2.35026741
Iceland	Western Europe	7.504499912	0.059615862	7.621346951	7.387652874	10.77255917	0.974669576	73	0.948891878	0.246944219	0.711709738	1.972316742	1.326501608	1.547567487	1.000843406	0.661980748	0.362330228	0.144540772	2.460688114
Norway	Western Europe	7.487999916	0.034837384	7.55628109	7.419718742	11.08780384	0.952486575	73.20078278	0.955750287	0.13453263	0.263218194	1.972316742	1.42420733	1.495172501	1.008071899	0.670200884	0.287985086	0.434100568	2.168266296
Netherlands	Western Europe	7.448900223	0.02779175	7.503372192	7.394428253	10.81271172	0.93913883	72.30091858	0.908547819	0.20761244	0.364717126	1.972316742	1.338946342	1.463645935	0.975675344	0.61362648	0.336317569	0.368569762	2.352117062
Sweden	Western Europe	7.353499889	0.036234196	7.424519062	7.282480717	10.75879383	0.926311195	72.60076904	0.939144194	0.111614622	0.250880182	1.972316742	1.322235227	1.433347702	0.986470461	0.650297701	0.272827893	0.442066371	2.246299267
New Zealand	North America and ANZ	7.299600124	0.039465468	7.376952648	7.222247601	10.50094318	0.949118972	73.20262909	0.936217487	0.191598073	0.22113885	1.972316742	1.242317915	1.48721838	1.008138299	0.646789908	0.325726211	0.461268276	2.128108025
Austria	Western Europe	7.294199944	0.033365164	7.359595776	7.228804111	10.7428236	0.928045869	73.00250244	0.899989486	0.085429221	0.499954879	1.972316742	1.317285538	1.437444925	1.000933528	0.603368878	0.255509764	0.281256139	2.398446083
Luxembourg	Western Europe	7.237500191	0.030851794	7.297969818	7.177030563	11.45068073	0.906912208	72.59999847	0.90563643	-0.004620588	0.367084295	1.972316742	1.536676049	1.387528419	0.986442685	0.610137045	0.19595392	0.367041469	2.153700352


CREATE TABLE n_2020 (
  "country_name" VARCHAR,
  "regional_indicator" VARCHAR,
  "ladder_score" DOUBLE,
  "standard_error_of_ladder_score" DOUBLE,
  "upperwhisker" DOUBLE,
  "lowerwhisker" DOUBLE,
  "logged_gdp_per_capita" DOUBLE,
  "social_support" DOUBLE,
  "healthy_life_expectancy" DOUBLE,
  "freedom_to_make_life_choices" DOUBLE,
  "generosity" DOUBLE,
  "perceptions_of_corruption" DOUBLE,
  "ladder_score_in_dystopia" DOUBLE,
  "explained_by_log_gdp_per_capita" DOUBLE,
  "explained_by_social_support" DOUBLE,
  "explained_by_healthy_life_expectancy" DOUBLE,
  "explained_by_freedom_to_make_life_choices" DOUBLE,
  "explained_by_generosity" DOUBLE,
  "explained_by_perceptions_of_corruption" DOUBLE,
  "dystopia_residual" DOUBLE
);