World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
CREATE TABLE owid_income_consumption_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_poverty_gap_index_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,
"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_2017_s80_s20_ratio (
"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,
"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_2017_spl (
"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,
"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_2017_spr (
"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,
"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_2017_top1_avg (
"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,
"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_2017_top1_share (
"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,
"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_2017_top1_thr (
"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,
"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_2017_top90_99_share (
"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,
"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_2017_total_shortfall_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,
"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_2017_total_shortfall_1000 (
"country" VARCHAR,
"year" INTEGER,
"consumption_spell_1" FLOAT,
"consumption_spell_2" BIGINT,
"consumption_spell_3" BIGINT,
"consumption_spell_4" BIGINT,
"consumption_spell_5" BIGINT,
"consumption_spell_6" BIGINT,
"consumption_spell_7" BIGINT,
"income_spell_1" FLOAT,
"income_spell_2" FLOAT,
"income_spell_3" UINTEGER,
"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_2017_total_shortfall_2000 (
"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,
"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_2017_total_shortfall_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" UINTEGER,
"consumption_spell_7" 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_2017_total_shortfall_3000 (
"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,
"income_spell_1" BIGINT,
"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_2017_total_shortfall_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" UINTEGER,
"consumption_spell_7" 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_2017_total_shortfall_4000 (
"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,
"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_2017_total_shortfall_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" 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_2017_total_shortfall_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" UINTEGER,
"consumption_spell_7" 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.