World Bank Poverty And Inequality Platform (PIP)

CREATE TABLE owid_income_2017_decile6_share (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile6_thr (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile7_avg (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile7_share (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile7_thr (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile8_avg (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile8_share (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile8_thr (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile9_avg (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile9_share (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_decile9_thr (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_gini (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_headcount_100 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_1000 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_2000 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_215 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_3000 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_365 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_4000 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_40_median (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_50_median (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_60_median (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_685 (
  "country" VARCHAR,
  "year" INTEGER,
  "income_spell_1" UINTEGER,
  "income_spell_2" UINTEGER,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_2017_headcount_ratio_100 (
  "country" VARCHAR,
  "year" INTEGER,
  "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_2017_headcount_ratio_1000 (
  "country" VARCHAR,
  "year" INTEGER,
  "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
);