World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
CREATE TABLE owid_income_consumption_2021_decile2_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,
"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_decile2_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,
"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_decile2_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,
"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_decile2_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,
"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_decile2_thr_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,
"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_decile2_thr_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_decile3_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,
"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_decile3_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,
"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_decile3_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,
"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_decile3_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,
"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_decile3_thr_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,
"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_decile3_thr_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_decile4_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,
"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_decile4_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,
"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_decile4_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,
"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_decile4_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,
"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_decile4_thr_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,
"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_decile4_thr_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_decile5_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,
"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_decile5_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,
"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_decile5_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,
"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_decile5_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,
"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_decile5_thr_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,
"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_decile5_thr_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_decile6_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,
"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
);
Anyone who has the link will be able to view this.