World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
CREATE TABLE owid_income_consumption_2017_decile10_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_decile10_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_decile1_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_decile1_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_decile1_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_decile2_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_decile2_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_decile2_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_decile3_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_decile3_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_decile3_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_decile4_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_decile4_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_decile4_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_decile5_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_decile5_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_decile5_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_decile6_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_decile6_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_decile6_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_decile7_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_decile7_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_decile7_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_decile8_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_decile8_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
);
Anyone who has the link will be able to view this.