World Happiness Reports 2013-2023
A decade worth of happiness!
@kaggle.joebeachcapital_world_happiness_report_2013_2023
A decade worth of happiness!
@kaggle.joebeachcapital_world_happiness_report_2013_2023
CREATE TABLE world_happiness_report_2013 (
"country" VARCHAR,
"region" BIGINT,
"ladder" DOUBLE,
"social_support" DOUBLE,
"freedom" DOUBLE,
"corruption" DOUBLE,
"donation" DOUBLE,
"generosity" DOUBLE,
"positive_affect" DOUBLE,
"negative_affect" DOUBLE,
"happiness_yesterday" DOUBLE,
"gdp_per_capita" DOUBLE,
"healthy_life_expectancy" DOUBLE
);
CREATE TABLE world_happiness_report_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 world_happiness_report_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 world_happiness_report_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 world_happiness_report_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 world_happiness_report_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 world_happiness_report_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 world_happiness_report_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 world_happiness_report_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
);
CREATE TABLE world_happiness_report_2023 (
"country_name" 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 worldhappinessindex2013_2023 (
"country" VARCHAR,
"year" BIGINT,
"index" DOUBLE,
"rank" DOUBLE
);
Anyone who has the link will be able to view this.