World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip
@owid.world_bank_pip
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 more than 160 economies around the world.
CREATE TABLE owid_consumption_2017_avg_shortfall_365_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
);CREATE TABLE owid_consumption_2017_avg_shortfall_365_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
);CREATE TABLE owid_consumption_2017_avg_shortfall_4000_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_4000_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
);CREATE TABLE owid_consumption_2017_avg_shortfall_4000_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
);CREATE TABLE owid_consumption_2017_avg_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_50_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_50_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_50_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_60_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_60_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_60_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_685_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_avg_shortfall_685_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
);CREATE TABLE owid_consumption_2017_avg_shortfall_685_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
);CREATE TABLE owid_consumption_2017_bottom50_share_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_bottom50_share_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
);CREATE TABLE owid_consumption_2017_bottom50_share_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
);CREATE TABLE owid_consumption_2017_decile10_avg_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_decile10_avg_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
);CREATE TABLE owid_consumption_2017_decile10_avg_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
);CREATE TABLE owid_consumption_2017_decile10_share_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" FLOAT,
"consumption_spell_7" FLOAT
);CREATE TABLE owid_consumption_2017_decile10_share_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
);Anyone who has the link will be able to view this.