World Bank Poverty And Inequality Platform (PIP)
@owid.world_bank_pip
@owid.world_bank_pip
CREATE TABLE owid_world_bank_pip_percentiles_1 (
"country" VARCHAR,
"year" INTEGER,
"ppp_version" INTEGER,
"welfare_type" VARCHAR,
"reporting_level" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"avg" FLOAT,
"share" FLOAT,
"pop" FLOAT
);
CREATE TABLE owid_world_bank_pip_percentiles_2 (
"country" VARCHAR,
"year" INTEGER,
"ppp_version" INTEGER,
"welfare_type" VARCHAR,
"reporting_level" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"avg" FLOAT,
"share" FLOAT,
"pop" FLOAT
);
CREATE TABLE owid_world_bank_pip_percentiles_3 (
"country" VARCHAR,
"year" INTEGER,
"ppp_version" INTEGER,
"welfare_type" VARCHAR,
"reporting_level" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"avg" FLOAT,
"share" FLOAT,
"pop" FLOAT
);
Anyone who has the link will be able to view this.