World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
CREATE TABLE owid_income_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,
"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_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,
"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_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,
"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_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_income_gap_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,
"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_mean (
"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_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_middle40_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_mld (
"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_p50_p10_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_p90_p10_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_p90_p50_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_palma_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_pg (
"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_polarization (
"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_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_poverty_gap_index_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,
"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.