World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
The Poverty and Inequality Platform (PIP) is an interactive computational tool that offers users quick access to the World Bank’s estimates of poverty, inequality, and shared prosperity. PIP provides a comprehensive view of global, regional, and country-level trends for 170 economies around the world.
CREATE TABLE owid_income_consumption_2021_total_shortfall_100_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" FLOAT,
"consumption_spell_7" FLOAT,
"consumption_spell_8" FLOAT,
"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_consumption_2021_total_shortfall_100_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" FLOAT,
"consumption_spell_7" FLOAT,
"consumption_spell_8" FLOAT,
"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_consumption_2021_total_shortfall_2000_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_2000_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_2000_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" FLOAT,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_3000_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"consumption_spell_8" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" UINTEGER,
"income_spell_3" UINTEGER,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_3000_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"consumption_spell_8" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" UINTEGER,
"income_spell_3" UINTEGER,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_3000_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"consumption_spell_8" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" UINTEGER,
"income_spell_3" UINTEGER,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_300_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_300_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_300_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_4000_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"consumption_spell_8" BIGINT,
"income_spell_1" BIGINT,
"income_spell_2" BIGINT,
"income_spell_3" UINTEGER,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_4000_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"consumption_spell_8" BIGINT,
"income_spell_1" BIGINT,
"income_spell_2" BIGINT,
"income_spell_3" UINTEGER,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_4000_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" BIGINT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"consumption_spell_8" BIGINT,
"income_spell_1" BIGINT,
"income_spell_2" BIGINT,
"income_spell_3" UINTEGER,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_40_median_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_40_median_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_40_median_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" FLOAT,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_420_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_420_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_420_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_500_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_500_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_500_3 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" FLOAT,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"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" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_50_median_1 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"income_spell_1" FLOAT,
"income_spell_2" UINTEGER,
"income_spell_3" FLOAT,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);CREATE TABLE owid_income_consumption_2021_total_shortfall_50_median_2 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" FLOAT,
"consumption_spell_3" FLOAT,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" FLOAT,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER,
"consumption_spell_8" UINTEGER,
"income_spell_1" FLOAT,
"income_spell_2" UINTEGER,
"income_spell_3" FLOAT,
"income_spell_4" UINTEGER,
"income_spell_5" UINTEGER,
"income_spell_6" UINTEGER,
"income_spell_7" UINTEGER,
"income_spell_8" UINTEGER
);Anyone who has the link will be able to view this.