World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip_legacy
@owid.world_bank_pip_legacy
CREATE TABLE owid_consumption_2021_decile8_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
);
CREATE TABLE owid_consumption_2021_decile8_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
);
CREATE TABLE owid_consumption_2021_decile8_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
);
CREATE TABLE owid_consumption_2021_decile8_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
);
CREATE TABLE owid_consumption_2021_decile8_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
);
CREATE TABLE owid_consumption_2021_decile9_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
);
CREATE TABLE owid_consumption_2021_decile9_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
);
CREATE TABLE owid_consumption_2021_decile9_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
);
CREATE TABLE owid_consumption_2021_decile9_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
);
CREATE TABLE owid_consumption_2021_decile9_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
);
CREATE TABLE owid_consumption_2021_decile9_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
);
CREATE TABLE owid_consumption_2021_gini_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
);
CREATE TABLE owid_consumption_2021_gini_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
);
CREATE TABLE owid_consumption_2021_headcount_1000_1 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_1000_2 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_100_1 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_100_2 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_2000_1 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_2000_2 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_3000_1 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_3000_2 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_300_1 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_300_2 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_4000_1 (
"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,
"consumption_spell_8" UINTEGER
);
CREATE TABLE owid_consumption_2021_headcount_4000_2 (
"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,
"consumption_spell_8" UINTEGER
);
Anyone who has the link will be able to view this.