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_consumption_2017_gini (
"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_headcount_100 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_1000 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_2000 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_215 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_3000 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_365 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_4000 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_40_median (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_50_median (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_60_median (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_685 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" UINTEGER,
"consumption_spell_2" UINTEGER,
"consumption_spell_3" UINTEGER,
"consumption_spell_4" UINTEGER,
"consumption_spell_5" UINTEGER,
"consumption_spell_6" UINTEGER,
"consumption_spell_7" UINTEGER
);CREATE TABLE owid_consumption_2017_headcount_ratio_100 (
"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_headcount_ratio_1000 (
"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_headcount_ratio_2000 (
"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_headcount_ratio_215 (
"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_headcount_ratio_3000 (
"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_headcount_ratio_365 (
"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_headcount_ratio_4000 (
"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_headcount_ratio_40_median (
"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_headcount_ratio_50_median (
"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_headcount_ratio_60_median (
"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_headcount_ratio_685 (
"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_income_gap_ratio_100 (
"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_income_gap_ratio_1000 (
"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.