World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
CREATE TABLE owid_income_2021_1 (
"country" VARCHAR,
"year" INTEGER,
"reporting_level" VARCHAR,
"welfare_type" VARCHAR,
"mean" FLOAT,
"median" FLOAT,
"mld" FLOAT,
"gini" FLOAT,
"polarization" FLOAT,
"decile1_share" FLOAT,
"decile2_share" FLOAT,
"decile3_share" FLOAT,
"decile4_share" FLOAT,
"decile5_share" FLOAT,
"decile6_share" FLOAT,
"decile7_share" FLOAT,
"decile8_share" FLOAT,
"decile9_share" FLOAT,
"decile10_share" FLOAT,
"decile1_thr" FLOAT,
"decile2_thr" FLOAT,
"decile3_thr" FLOAT,
"decile4_thr" FLOAT,
"decile5_thr" FLOAT,
"decile6_thr" FLOAT,
"decile7_thr" FLOAT,
"decile8_thr" FLOAT,
"decile9_thr" FLOAT,
"headcount_40_median" UINTEGER,
"headcount_50_median" UINTEGER,
"headcount_60_median" UINTEGER,
"headcount_ratio_40_median" FLOAT,
"headcount_ratio_50_median" FLOAT,
"headcount_ratio_60_median" FLOAT,
"income_gap_ratio_40_median" FLOAT,
"income_gap_ratio_50_median" FLOAT,
"income_gap_ratio_60_median" FLOAT,
"poverty_gap_index_40_median" FLOAT,
"poverty_gap_index_50_median" FLOAT,
"poverty_gap_index_60_median" FLOAT,
"avg_shortfall_40_median" FLOAT,
"avg_shortfall_50_median" FLOAT,
"avg_shortfall_60_median" FLOAT,
"total_shortfall_40_median" FLOAT,
"total_shortfall_50_median" FLOAT,
"total_shortfall_60_median" FLOAT,
"poverty_severity_40_median" FLOAT,
"poverty_severity_50_median" FLOAT,
"poverty_severity_60_median" FLOAT,
"watts_40_median" FLOAT,
"watts_50_median" FLOAT,
"watts_60_median" FLOAT,
"spl" FLOAT,
"spr" FLOAT,
"pg" FLOAT,
"cpi" FLOAT,
"ppp" FLOAT,
"headcount_100" UINTEGER,
"headcount_1000" UINTEGER,
"headcount_2000" UINTEGER,
"headcount_300" UINTEGER,
"headcount_3000" UINTEGER,
"headcount_4000" UINTEGER,
"headcount_420" UINTEGER,
"headcount_500" UINTEGER,
"headcount_700" UINTEGER,
"headcount_830" UINTEGER,
"headcount_ratio_100" FLOAT,
"headcount_ratio_1000" FLOAT,
"headcount_ratio_2000" FLOAT,
"headcount_ratio_300" FLOAT,
"headcount_ratio_3000" FLOAT,
"headcount_ratio_4000" FLOAT,
"headcount_ratio_420" FLOAT,
"headcount_ratio_500" FLOAT,
"headcount_ratio_700" FLOAT,
"headcount_ratio_830" FLOAT,
"income_gap_ratio_100" FLOAT,
"income_gap_ratio_1000" FLOAT,
"income_gap_ratio_2000" FLOAT,
"income_gap_ratio_300" FLOAT,
"income_gap_ratio_3000" FLOAT,
"income_gap_ratio_4000" FLOAT,
"income_gap_ratio_420" FLOAT,
"income_gap_ratio_500" FLOAT,
"income_gap_ratio_700" FLOAT,
"income_gap_ratio_830" FLOAT,
"poverty_gap_index_100" FLOAT,
"poverty_gap_index_1000" FLOAT,
"poverty_gap_index_2000" FLOAT,
"poverty_gap_index_300" FLOAT,
"poverty_gap_index_3000" FLOAT,
"poverty_gap_index_4000" FLOAT,
"poverty_gap_index_420" FLOAT,
"poverty_gap_index_500" FLOAT,
"poverty_gap_index_700" FLOAT,
"poverty_gap_index_830" FLOAT,
"avg_shortfall_100" FLOAT,
"avg_shortfall_1000" FLOAT,
"avg_shortfall_2000" FLOAT
);
CREATE TABLE owid_income_2021_2 (
"country" VARCHAR,
"year" INTEGER,
"reporting_level" VARCHAR,
"welfare_type" VARCHAR,
"mean" FLOAT,
"median" FLOAT,
"mld" FLOAT,
"gini" FLOAT,
"polarization" FLOAT,
"decile1_share" FLOAT,
"decile2_share" FLOAT,
"decile3_share" FLOAT,
"decile4_share" FLOAT,
"decile5_share" FLOAT,
"decile6_share" FLOAT,
"decile7_share" FLOAT,
"decile8_share" FLOAT,
"decile9_share" FLOAT,
"decile10_share" FLOAT,
"decile1_thr" FLOAT,
"decile2_thr" FLOAT,
"decile3_thr" FLOAT,
"decile4_thr" FLOAT,
"decile5_thr" FLOAT,
"decile6_thr" FLOAT,
"decile7_thr" FLOAT,
"decile8_thr" FLOAT,
"decile9_thr" FLOAT,
"headcount_40_median" UINTEGER,
"headcount_50_median" UINTEGER,
"headcount_60_median" UINTEGER,
"headcount_ratio_40_median" FLOAT,
"headcount_ratio_50_median" FLOAT,
"headcount_ratio_60_median" FLOAT,
"income_gap_ratio_40_median" FLOAT,
"income_gap_ratio_50_median" FLOAT,
"income_gap_ratio_60_median" FLOAT,
"poverty_gap_index_40_median" FLOAT,
"poverty_gap_index_50_median" FLOAT,
"poverty_gap_index_60_median" FLOAT,
"avg_shortfall_40_median" FLOAT,
"avg_shortfall_50_median" FLOAT,
"avg_shortfall_60_median" FLOAT,
"total_shortfall_40_median" FLOAT,
"total_shortfall_50_median" FLOAT,
"total_shortfall_60_median" FLOAT,
"poverty_severity_40_median" FLOAT,
"poverty_severity_50_median" FLOAT,
"poverty_severity_60_median" FLOAT,
"watts_40_median" FLOAT,
"watts_50_median" FLOAT,
"watts_60_median" FLOAT,
"spl" FLOAT,
"spr" FLOAT,
"pg" FLOAT,
"cpi" FLOAT,
"ppp" FLOAT,
"headcount_100" UINTEGER,
"headcount_1000" UINTEGER,
"headcount_2000" UINTEGER,
"headcount_300" UINTEGER,
"headcount_3000" UINTEGER,
"headcount_4000" UINTEGER,
"headcount_420" UINTEGER,
"headcount_500" UINTEGER,
"headcount_700" UINTEGER,
"headcount_830" UINTEGER,
"headcount_ratio_100" FLOAT,
"headcount_ratio_1000" FLOAT,
"headcount_ratio_2000" FLOAT,
"headcount_ratio_300" FLOAT,
"headcount_ratio_3000" FLOAT,
"headcount_ratio_4000" FLOAT,
"headcount_ratio_420" FLOAT,
"headcount_ratio_500" FLOAT,
"headcount_ratio_700" FLOAT,
"headcount_ratio_830" FLOAT,
"income_gap_ratio_100" FLOAT,
"income_gap_ratio_1000" FLOAT,
"income_gap_ratio_2000" FLOAT,
"income_gap_ratio_300" FLOAT,
"income_gap_ratio_3000" FLOAT,
"income_gap_ratio_4000" FLOAT,
"income_gap_ratio_420" FLOAT,
"income_gap_ratio_500" FLOAT,
"income_gap_ratio_700" FLOAT,
"income_gap_ratio_830" FLOAT,
"poverty_gap_index_100" FLOAT,
"poverty_gap_index_1000" FLOAT,
"poverty_gap_index_2000" FLOAT,
"poverty_gap_index_300" FLOAT,
"poverty_gap_index_3000" FLOAT,
"poverty_gap_index_4000" FLOAT,
"poverty_gap_index_420" FLOAT,
"poverty_gap_index_500" FLOAT,
"poverty_gap_index_700" FLOAT,
"poverty_gap_index_830" FLOAT,
"avg_shortfall_100" FLOAT,
"avg_shortfall_1000" FLOAT,
"avg_shortfall_2000" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_1000_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_1000_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_100_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_100_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_2000_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_2000_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_3000_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_3000_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_300_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_300_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_4000_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_4000_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_40_median_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_40_median_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_420_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_420_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_500_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_500_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_50_median_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_50_median_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_60_median_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_60_median_2 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
CREATE TABLE owid_income_2021_avg_shortfall_700_1 (
"country" VARCHAR,
"year" INTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" FLOAT,
"income_spell_6" FLOAT,
"income_spell_7" FLOAT,
"income_spell_8" FLOAT
);
Anyone who has the link will be able to view this.