World Bank Poverty And Inequality Platform (PIP)

CREATE TABLE owid_consumption_2021_top1_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_top90_99_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_top90_99_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_total_shortfall_1000_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_1000_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_100_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_total_shortfall_100_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_total_shortfall_2000_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_2000_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_3000_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" BIGINT,
  "consumption_spell_7" BIGINT,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_3000_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" BIGINT,
  "consumption_spell_7" BIGINT,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_300_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_300_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_4000_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" BIGINT,
  "consumption_spell_7" BIGINT,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_4000_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" BIGINT,
  "consumption_spell_7" BIGINT,
  "consumption_spell_8" BIGINT
);

CREATE TABLE owid_consumption_2021_total_shortfall_40_median_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_40_median_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_420_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_420_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_500_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_500_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_50_median_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" UINTEGER,
  "consumption_spell_5" FLOAT,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_50_median_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" UINTEGER,
  "consumption_spell_5" FLOAT,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);

CREATE TABLE owid_consumption_2021_total_shortfall_60_median_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "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_total_shortfall_60_median_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" UINTEGER,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER
);