World Happiness Report 2015-2022
World Happiness score based on various economic and social parameter
@kaggle.shivkumarganesh_world_happiness_report_20152022
World Happiness score based on various economic and social parameter
@kaggle.shivkumarganesh_world_happiness_report_20152022
The World Happiness Report is a publication of the United Nations Sustainable Development Solutions Network. It contains articles and rankings of national happiness, based on respondent ratings of their own lives, which the report also correlates with various (quality of) life factors. As of March 2022, Finland had been ranked the happiest country in the world five times in a row.
The report primarily uses data from the Gallup World Poll. Each annual report is available to the public to download on the World Happiness Report website.[7] The Editors of the 2020 report are John F. Helliwell, Richard Layard, Jeffrey D. Sachs, and Jan-Emmanuel De Neve. Associate Editors are Lara Aknin, Shun Wang, and Haifang Huang. Source : Wikipedia
NOTE: Certain Data Points are available for Certain Years and others are not. So you may find a lot of Columns with plenty of empty data.
CREATE TABLE output (
"unnamed_0" BIGINT -- Unnamed: 0,
"country" VARCHAR,
"region" VARCHAR,
"happiness_rank" DOUBLE,
"happiness_score" DOUBLE,
"standard_error" DOUBLE,
"economy_gdp_per_capita" DOUBLE -- Economy (GDP Per Capita),
"family" DOUBLE,
"health_life_expectancy" DOUBLE -- Health (Life Expectancy),
"freedom" DOUBLE,
"trust_government_corruption" DOUBLE -- Trust (Government Corruption),
"generosity" DOUBLE,
"dystopia_residual" DOUBLE,
"year" BIGINT,
"lower_confidence_interval" DOUBLE,
"upper_confidence_interval" DOUBLE,
"happiness_rank_9bd36f" DOUBLE -- Happiness.Rank,
"happiness_score_0ee1b1" DOUBLE -- Happiness.Score,
"whisker_high" DOUBLE,
"whisker_low" DOUBLE,
"economy_gdp_per_capita_540a0f" DOUBLE -- Economy..GDP.per.Capita.,
"health_life_expectancy_9e40cf" DOUBLE -- Health..Life.Expectancy.,
"trust_government_corruption_293552" DOUBLE -- Trust..Government.Corruption.,
"dystopia_residual_675985" DOUBLE -- Dystopia.Residual,
"overall_rank" DOUBLE,
"country_or_region" VARCHAR,
"score" DOUBLE,
"gdp_per_capita" DOUBLE,
"social_support" DOUBLE,
"healthy_life_expectancy" DOUBLE,
"freedom_to_make_life_choices" DOUBLE,
"perceptions_of_corruption" DOUBLE,
"country_name" VARCHAR,
"regional_indicator" VARCHAR,
"ladder_score" DOUBLE,
"standard_error_of_ladder_score" DOUBLE,
"upperwhisker" DOUBLE,
"lowerwhisker" DOUBLE,
"logged_gdp_per_capita" DOUBLE,
"ladder_score_in_dystopia" DOUBLE,
"explained_by_log_gdp_per_capita" DOUBLE -- Explained By: Log GDP Per Capita,
"explained_by_social_support" DOUBLE -- Explained By: Social Support,
"explained_by_healthy_life_expectancy" DOUBLE -- Explained By: Healthy Life Expectancy,
"explained_by_freedom_to_make_life_choices" DOUBLE -- Explained By: Freedom To Make Life Choices,
"explained_by_generosity" DOUBLE -- Explained By: Generosity,
"explained_by_perceptions_of_corruption" DOUBLE -- Explained By: Perceptions Of Corruption,
"dystopia_residual_f82d49" DOUBLE -- Dystopia + Residual,
"rank" DOUBLE,
"happiness_score_236e54" DOUBLE -- Happiness Score,
"whisker_high_62bb16" DOUBLE -- Whisker-high,
"whisker_low_9ca4e4" DOUBLE -- Whisker-low,
"dystopia_1_83_residual" DOUBLE -- Dystopia (1.83) + Residual,
"explained_by_gdp_per_capita" DOUBLE -- Explained By: GDP Per Capita
);Anyone who has the link will be able to view this.