World Bank Poverty And Inequality Platform (PIP)

CREATE TABLE owid_income_consumption_2017_total_shortfall_4000_3 (
  "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,
  "income_spell_1" BIGINT,
  "income_spell_2" BIGINT,
  "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_consumption_2017_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" 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_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" 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_total_shortfall_40_median_3 (
  "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_total_shortfall_50_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" 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_total_shortfall_50_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" 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_total_shortfall_50_median_3 (
  "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_total_shortfall_60_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" 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_total_shortfall_60_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" 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_total_shortfall_60_median_3 (
  "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_total_shortfall_685_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,
  "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_total_shortfall_685_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,
  "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_total_shortfall_685_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "income_spell_1" FLOAT,
  "income_spell_2" FLOAT,
  "income_spell_3" FLOAT,
  "income_spell_4" FLOAT,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

CREATE TABLE owid_income_consumption_2017_unsmoothed_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "survey_comparability" INTEGER,
  "comparable_spell" VARCHAR,
  "reporting_pop" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "decile1_share" FLOAT,
  "decile2_share" FLOAT,
  "decile3_share" FLOAT,
  "decile4_share" FLOAT,
  "decile5_share" FLOAT,
  "decile6_share" FLOAT,
  "decile7_share" FLOAT,
  "decile8_share" FLOAT,
  "decile9_share" FLOAT,
  "decile10_share" FLOAT,
  "decile1_thr" FLOAT,
  "decile2_thr" FLOAT,
  "decile3_thr" FLOAT,
  "decile4_thr" FLOAT,
  "decile5_thr" FLOAT,
  "decile6_thr" FLOAT,
  "decile7_thr" FLOAT,
  "decile8_thr" FLOAT,
  "decile9_thr" FLOAT,
  "is_interpolated" INTEGER,
  "distribution_type" VARCHAR,
  "estimation_type" VARCHAR,
  "headcount_40_median" FLOAT,
  "headcount_50_median" FLOAT,
  "headcount_60_median" FLOAT,
  "headcount_ratio_40_median" FLOAT,
  "headcount_ratio_50_median" FLOAT,
  "headcount_ratio_60_median" FLOAT,
  "income_gap_ratio_40_median" FLOAT,
  "income_gap_ratio_50_median" FLOAT,
  "income_gap_ratio_60_median" FLOAT,
  "poverty_gap_index_40_median" FLOAT,
  "poverty_gap_index_50_median" FLOAT,
  "poverty_gap_index_60_median" FLOAT,
  "avg_shortfall_40_median" FLOAT,
  "avg_shortfall_50_median" FLOAT,
  "avg_shortfall_60_median" FLOAT,
  "total_shortfall_40_median" FLOAT,
  "total_shortfall_50_median" FLOAT,
  "total_shortfall_60_median" FLOAT,
  "poverty_severity_40_median" FLOAT,
  "poverty_severity_50_median" FLOAT,
  "poverty_severity_60_median" FLOAT,
  "watts_40_median" FLOAT,
  "watts_50_median" FLOAT,
  "watts_60_median" FLOAT,
  "headcount_100" FLOAT,
  "headcount_1000" FLOAT,
  "headcount_2000" FLOAT,
  "headcount_215" FLOAT,
  "headcount_3000" FLOAT,
  "headcount_365" FLOAT,
  "headcount_4000" FLOAT,
  "headcount_685" FLOAT,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_215" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_365" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_685" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_215" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_365" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_215" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_365" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_685" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_2000" FLOAT,
  "avg_shortfall_215" FLOAT,
  "avg_shortfall_3000" FLOAT,
  "avg_shortfall_365" FLOAT,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_685" FLOAT,
  "total_shortfall_100" FLOAT
);

CREATE TABLE owid_income_consumption_2017_unsmoothed_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "ppp_version" INTEGER,
  "survey_comparability" INTEGER,
  "comparable_spell" VARCHAR,
  "reporting_pop" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "decile1_share" FLOAT,
  "decile2_share" FLOAT,
  "decile3_share" FLOAT,
  "decile4_share" FLOAT,
  "decile5_share" FLOAT,
  "decile6_share" FLOAT,
  "decile7_share" FLOAT,
  "decile8_share" FLOAT,
  "decile9_share" FLOAT,
  "decile10_share" FLOAT,
  "decile1_thr" FLOAT,
  "decile2_thr" FLOAT,
  "decile3_thr" FLOAT,
  "decile4_thr" FLOAT,
  "decile5_thr" FLOAT,
  "decile6_thr" FLOAT,
  "decile7_thr" FLOAT,
  "decile8_thr" FLOAT,
  "decile9_thr" FLOAT,
  "is_interpolated" INTEGER,
  "distribution_type" VARCHAR,
  "estimation_type" VARCHAR,
  "headcount_40_median" FLOAT,
  "headcount_50_median" FLOAT,
  "headcount_60_median" FLOAT,
  "headcount_ratio_40_median" FLOAT,
  "headcount_ratio_50_median" FLOAT,
  "headcount_ratio_60_median" FLOAT,
  "income_gap_ratio_40_median" FLOAT,
  "income_gap_ratio_50_median" FLOAT,
  "income_gap_ratio_60_median" FLOAT,
  "poverty_gap_index_40_median" FLOAT,
  "poverty_gap_index_50_median" FLOAT,
  "poverty_gap_index_60_median" FLOAT,
  "avg_shortfall_40_median" FLOAT,
  "avg_shortfall_50_median" FLOAT,
  "avg_shortfall_60_median" FLOAT,
  "total_shortfall_40_median" FLOAT,
  "total_shortfall_50_median" FLOAT,
  "total_shortfall_60_median" FLOAT,
  "poverty_severity_40_median" FLOAT,
  "poverty_severity_50_median" FLOAT,
  "poverty_severity_60_median" FLOAT,
  "watts_40_median" FLOAT,
  "watts_50_median" FLOAT,
  "watts_60_median" FLOAT,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_2000" BIGINT,
  "headcount_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "headcount_685" UINTEGER,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_215" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_365" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_685" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_215" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_365" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_215" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_365" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_685" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_2000" FLOAT,
  "avg_shortfall_215" FLOAT,
  "avg_shortfall_3000" FLOAT,
  "avg_shortfall_365" FLOAT
);

CREATE TABLE owid_percentiles_income_consumption_2011_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "percentile" INTEGER,
  "ppp_version" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT
);

CREATE TABLE owid_percentiles_income_consumption_2011_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "percentile" INTEGER,
  "ppp_version" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT
);

CREATE TABLE owid_percentiles_income_consumption_2011_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "percentile" INTEGER,
  "ppp_version" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT,
  "pop" FLOAT
);

CREATE TABLE owid_percentiles_income_consumption_2017_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "percentile" INTEGER,
  "ppp_version" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT
);

CREATE TABLE owid_percentiles_income_consumption_2017_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "percentile" INTEGER,
  "ppp_version" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT
);

CREATE TABLE owid_percentiles_income_consumption_2017_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "percentile" INTEGER,
  "ppp_version" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT,
  "pop" FLOAT
);

CREATE TABLE owid_world_bank_pip_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "dollar1_share_of_population_above_poverty_line" FLOAT,
  "dollar1_total_number_of_people_above_poverty_line" BIGINT,
  "dollar1_total_number_of_people_below_poverty_line" UINTEGER,
  "dollar1_a_day_poverty_gap_index" FLOAT,
  "dollar1_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar1_a_day_total_shortfall" FLOAT,
  "dollar1_dollar2_15_share_of_population_between_poverty_lines" FLOAT,
  "dollar1_dollar2_15_total_number_of_people_between_poverty_lines" UINTEGER,
  "dollar10_share_of_population_above_poverty_line" FLOAT,
  "dollar10_total_number_of_people_above_poverty_line" UINTEGER,
  "dollar10_total_number_of_people_below_poverty_line" BIGINT,
  "dollar10_a_day_poverty_gap_index" FLOAT,
  "dollar10_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar10_a_day_total_shortfall" FLOAT,
  "dollar10_dollar20_share_of_population_between_poverty_lines" FLOAT,
  "dollar10_dollar20_total_number_of_people_between_poverty_lines" UINTEGER,
  "dollar10_dollar30_share_of_population_between_poverty_lines" FLOAT,
  "dollar10_dollar30_total_number_of_people_between_poverty_lines" UINTEGER,
  "dollar2_15_share_of_population_above_poverty_line" FLOAT,
  "dollar2_15_total_number_of_people_above_poverty_line" BIGINT,
  "dollar2_15_total_number_of_people_below_poverty_line" UINTEGER,
  "dollar2_15_a_day_poverty_gap_index" FLOAT,
  "dollar2_15_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar2_15_a_day_total_shortfall" FLOAT,
  "dollar2_15_dollar10_share_of_population_between_poverty_lines" FLOAT,
  "dollar2_15_dollar10_total_number_of_people_between_pov_40c8c1b7" UINTEGER,
  "dollar2_15_dollar3_65_share_of_population_between_poverty_lines" FLOAT,
  "dollar2_15_dollar3_65_total_number_of_people_between_p_19723ef2" UINTEGER,
  "dollar20_share_of_population_above_poverty_line" FLOAT,
  "dollar20_total_number_of_people_above_poverty_line" UINTEGER,
  "dollar20_total_number_of_people_below_poverty_line" BIGINT,
  "dollar20_a_day_poverty_gap_index" FLOAT,
  "dollar20_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar20_a_day_total_shortfall" FLOAT,
  "dollar20_dollar30_share_of_population_between_poverty_lines" FLOAT,
  "dollar20_dollar30_total_number_of_people_between_poverty_lines" UINTEGER,
  "dollar24_35_share_of_population_above_poverty_line" FLOAT,
  "dollar24_35_total_number_of_people_above_poverty_line" UINTEGER,
  "dollar24_35_total_number_of_people_below_poverty_line" BIGINT,
  "dollar24_35_a_day_poverty_gap_index" FLOAT,
  "dollar24_35_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar24_35_a_day_total_shortfall" FLOAT,
  "dollar3_65_share_of_population_above_poverty_line" FLOAT,
  "dollar3_65_total_number_of_people_above_poverty_line" BIGINT,
  "dollar3_65_total_number_of_people_below_poverty_line" UINTEGER,
  "dollar3_65_a_day_poverty_gap_index" FLOAT,
  "dollar3_65_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar3_65_a_day_total_shortfall" FLOAT,
  "dollar3_65_dollar6_85_share_of_population_between_poverty_lines" FLOAT,
  "dollar3_65_dollar6_85_total_number_of_people_between_p_4c861a0c" UINTEGER,
  "dollar30_share_of_population_above_poverty_line" FLOAT,
  "dollar30_total_number_of_people_above_poverty_line" UINTEGER,
  "dollar30_total_number_of_people_below_poverty_line" BIGINT,
  "dollar30_a_day_poverty_gap_index" FLOAT,
  "dollar30_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar30_a_day_total_shortfall" FLOAT,
  "dollar30_dollar40_share_of_population_between_poverty_lines" FLOAT,
  "dollar30_dollar40_total_number_of_people_between_poverty_lines" UINTEGER,
  "dollar40_share_of_population_above_poverty_line" FLOAT,
  "dollar40_total_number_of_people_above_poverty_line" UINTEGER,
  "dollar40_total_number_of_people_below_poverty_line" BIGINT,
  "dollar40_a_day_poverty_gap_index" FLOAT,
  "dollar40_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar40_a_day_total_shortfall" FLOAT,
  "dollar6_85_share_of_population_above_poverty_line" FLOAT,
  "dollar6_85_total_number_of_people_above_poverty_line" UINTEGER,
  "dollar6_85_total_number_of_people_below_poverty_line" UINTEGER,
  "dollar6_85_a_day_poverty_gap_index" FLOAT,
  "dollar6_85_a_day_share_of_population_below_poverty_line" FLOAT,
  "dollar6_85_a_day_total_shortfall" FLOAT,
  "dollar6_85_dollar10_share_of_population_between_poverty_lines" FLOAT,
  "dollar6_85_dollar10_total_number_of_people_between_pov_2e4891d5" UINTEGER,
  "n__40pct_of_median_share_of_population_below_poverty_line" FLOAT,
  "n__40pct_of_median_total_number_of_people_below_poverty_line" UINTEGER,
  "n__50pct_of_median_share_of_population_below_poverty_line" FLOAT,
  "n__50pct_of_median_total_number_of_people_below_poverty_line" UINTEGER,
  "n__60pct_of_median_share_of_population_below_poverty_line" FLOAT,
  "n__60pct_of_median_total_number_of_people_below_poverty_line" UINTEGER,
  "gini_coefficient" FLOAT,
  "mean_income_or_expenditure_per_day" FLOAT,
  "median_income_or_expenditure_per_day" FLOAT,
  "p10" FLOAT,
  "p90" FLOAT,
  "share_of_the_2nd_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_3rd_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_4th_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_poorest_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_richest_decile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_richest_quintile_in_total_income_or_expenditure" FLOAT
);

CREATE TABLE owid_world_bank_pip_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "poverty_line" VARCHAR,
  "welfare_type" VARCHAR,
  "decile" INTEGER,
  "table" VARCHAR,
  "survey_comparability" VARCHAR,
  "headcount_ratio" FLOAT,
  "poverty_gap_index" FLOAT,
  "poverty_severity" FLOAT,
  "watts" FLOAT,
  "headcount" BIGINT,
  "total_shortfall" FLOAT,
  "avg_shortfall" FLOAT,
  "income_gap_ratio" FLOAT,
  "headcount_above" BIGINT,
  "headcount_ratio_above" FLOAT,
  "headcount_between" UINTEGER,
  "headcount_ratio_between" FLOAT,
  "share" FLOAT,
  "thr" FLOAT,
  "avg" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "bottom50_share" FLOAT,
  "middle40_share" FLOAT,
  "palma_ratio" FLOAT,
  "s80_s20_ratio" FLOAT,
  "p90_p10_ratio" FLOAT,
  "p90_p50_ratio" FLOAT,
  "p50_p10_ratio" FLOAT,
  "top1_thr" FLOAT,
  "top1_share" FLOAT,
  "top1_avg" FLOAT,
  "top90_99_share" FLOAT,
  "surveys_past_decade" INTEGER,
  "region_name" VARCHAR
);

CREATE TABLE owid_world_bank_pip_percentiles (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "welfare_type" VARCHAR,
  "reporting_level" VARCHAR,
  "percentile" INTEGER,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT,
  "pop" FLOAT
);