World Happiness Report Up To 2022
Bliss scored agreeing to financial, social, etc.
@kaggle.mathurinache_world_happiness_report
Bliss scored agreeing to financial, social, etc.
@kaggle.mathurinache_world_happiness_report
CREATE TABLE n_2015 (
"country" VARCHAR,
"region" VARCHAR,
"happiness_rank" BIGINT,
"happiness_score" DOUBLE,
"standard_error" DOUBLE,
"economy_gdp_per_capita" DOUBLE,
"family" DOUBLE,
"health_life_expectancy" DOUBLE,
"freedom" DOUBLE,
"trust_government_corruption" DOUBLE,
"generosity" DOUBLE,
"dystopia_residual" DOUBLE
);
CREATE TABLE n_2016 (
"country" VARCHAR,
"region" VARCHAR,
"happiness_rank" BIGINT,
"happiness_score" DOUBLE,
"lower_confidence_interval" DOUBLE,
"upper_confidence_interval" DOUBLE,
"economy_gdp_per_capita" DOUBLE,
"family" DOUBLE,
"health_life_expectancy" DOUBLE,
"freedom" DOUBLE,
"trust_government_corruption" DOUBLE,
"generosity" DOUBLE,
"dystopia_residual" DOUBLE
);
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
);
CREATE TABLE n_2018 (
"overall_rank" BIGINT,
"country_or_region" VARCHAR,
"score" DOUBLE,
"gdp_per_capita" DOUBLE,
"social_support" DOUBLE,
"healthy_life_expectancy" DOUBLE,
"freedom_to_make_life_choices" DOUBLE,
"generosity" DOUBLE,
"perceptions_of_corruption" DOUBLE
);
CREATE TABLE n_2019 (
"overall_rank" BIGINT,
"country_or_region" VARCHAR,
"score" DOUBLE,
"gdp_per_capita" DOUBLE,
"social_support" DOUBLE,
"healthy_life_expectancy" DOUBLE,
"freedom_to_make_life_choices" DOUBLE,
"generosity" DOUBLE,
"perceptions_of_corruption" DOUBLE
);
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
);
CREATE TABLE n_2021 (
"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
);
CREATE TABLE n_2022 (
"rank" BIGINT,
"country" VARCHAR,
"happiness_score" DOUBLE,
"whisker_high" DOUBLE,
"whisker_low" DOUBLE,
"dystopia_1_83_residual" DOUBLE,
"explained_by_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
);
Anyone who has the link will be able to view this.