Human Development Report - UNDP (2021-22)
@owid.undp_hdr
@owid.undp_hdr
CREATE TABLE owid_undp_hdr_1 (
"country" VARCHAR,
"year" INTEGER,
"abr" FLOAT,
"co2_prod" FLOAT,
"coef_ineq" FLOAT,
"diff_hdi_phdi" FLOAT,
"eys" FLOAT,
"eys_f" FLOAT,
"eys_m" FLOAT,
"gdi" FLOAT,
"gdi_group" INTEGER,
"gii" FLOAT,
"gii_rank" INTEGER,
"gni_pc_f" FLOAT,
"gni_pc_m" FLOAT,
"gnipc" FLOAT,
"hdi" FLOAT,
"hdi_f" FLOAT,
"hdi_m" FLOAT,
"hdi_rank" INTEGER,
"ihdi" FLOAT,
"ineq_edu" FLOAT,
"ineq_inc" FLOAT,
"ineq_le" FLOAT,
"le" FLOAT,
"le_f" FLOAT,
"le_m" FLOAT,
"lfpr_f" FLOAT,
"lfpr_m" FLOAT,
"loss" FLOAT,
"mf" FLOAT,
"mmr" FLOAT,
"mys" FLOAT,
"mys_f" FLOAT,
"mys_m" FLOAT,
"phdi" FLOAT,
"pr_f" FLOAT,
"pr_m" FLOAT,
"rankdiff_hdi_phdi" INTEGER,
"se_f" FLOAT,
"se_m" FLOAT
);
CREATE TABLE owid_undp_hdr_2 (
"country" VARCHAR,
"year" INTEGER,
"abr" FLOAT,
"co2_prod" FLOAT,
"coef_ineq" FLOAT,
"diff_hdi_phdi" FLOAT,
"eys" FLOAT,
"eys_f" FLOAT,
"eys_m" FLOAT,
"gdi" FLOAT,
"gdi_group" INTEGER,
"gii" FLOAT,
"gii_rank" INTEGER,
"gni_pc_f" FLOAT,
"gni_pc_m" FLOAT,
"gnipc" FLOAT,
"hdi" FLOAT,
"hdi_f" FLOAT,
"hdi_m" FLOAT,
"hdi_rank" INTEGER,
"ihdi" FLOAT,
"ineq_edu" FLOAT,
"ineq_inc" FLOAT,
"ineq_le" FLOAT,
"le" FLOAT,
"le_f" FLOAT,
"le_m" FLOAT,
"lfpr_f" FLOAT,
"lfpr_m" FLOAT,
"loss" FLOAT,
"mf" FLOAT,
"mmr" FLOAT,
"mys" FLOAT,
"mys_f" FLOAT,
"mys_m" FLOAT,
"phdi" FLOAT,
"pop_total" FLOAT,
"pr_f" FLOAT,
"pr_m" FLOAT,
"rankdiff_hdi_phdi" INTEGER,
"se_f" FLOAT,
"se_m" FLOAT
);
CREATE TABLE owid_undp_hdr_3 (
"country" VARCHAR,
"year" INTEGER,
"abr" FLOAT,
"co2_prod" FLOAT,
"coef_ineq" FLOAT,
"diff_hdi_phdi" FLOAT,
"gdi" FLOAT,
"gdi_group" INTEGER,
"gii" FLOAT,
"gii_rank" INTEGER,
"hdi_rank" INTEGER,
"ihdi" FLOAT,
"ineq_edu" FLOAT,
"ineq_inc" FLOAT,
"ineq_le" FLOAT,
"loss" FLOAT,
"mf" FLOAT,
"mmr" FLOAT,
"phdi" FLOAT,
"pop_total" FLOAT,
"rankdiff_hdi_phdi" INTEGER
);
CREATE TABLE owid_undp_hdr_sex (
"country" VARCHAR,
"year" INTEGER,
"sex" VARCHAR,
"eys" FLOAT,
"gni_pc" FLOAT,
"hdi" FLOAT,
"le" FLOAT,
"lfpr" FLOAT,
"mys" FLOAT,
"pr" FLOAT,
"se" FLOAT
);
Anyone who has the link will be able to view this.