About this Dataset

World Bank Poverty And Inequality Platform (PIP)

The Poverty and Inequality Platform (PIP) is an interactive computational tool that offers users quick access to the World Bank’s estimates of poverty, inequality, and shared prosperity. PIP provides a comprehensive view of global, regional, and country-level trends for more than 160 economies around the world.

Tables

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2011_1

941.6 KB
1001 rows
167 columns


CREATE TABLE owid_consumption_2011_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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,
  "headcount_40_median" UINTEGER,
  "headcount_50_median" UINTEGER,
  "headcount_60_median" UINTEGER,
  "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" UINTEGER,
  "headcount_1000" UINTEGER,
  "headcount_190" UINTEGER,
  "headcount_2000" UINTEGER,
  "headcount_3000" UINTEGER,
  "headcount_320" UINTEGER,
  "headcount_4000" UINTEGER,
  "headcount_550" UINTEGER,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_190" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_320" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_550" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_190" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_320" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_550" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_190" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_320" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_550" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_190" FLOAT,
  "avg_shortfall_2000" FLOAT,
  "avg_shortfall_3000" FLOAT,
  "avg_shortfall_320" FLOAT,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_550" FLOAT,
  "total_shortfall_100" FLOAT,
  "total_shortfall_1000" FLOAT,
  "total_shortfall_190" FLOAT,
  "total_shortfall_2000" FLOAT,
  "total_shortfall_3000" FLOAT,
  "total_shortfall_320" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_550" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2011_2

993.48 KB
1044 rows
167 columns


CREATE TABLE owid_consumption_2011_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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,
  "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_190" FLOAT,
  "headcount_2000" FLOAT,
  "headcount_3000" FLOAT,
  "headcount_320" FLOAT,
  "headcount_4000" FLOAT,
  "headcount_550" FLOAT,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_190" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_320" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_550" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_190" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_320" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_550" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_190" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_320" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_550" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_190" FLOAT,
  "avg_shortfall_2000" FLOAT,
  "avg_shortfall_3000" FLOAT,
  "avg_shortfall_320" FLOAT,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_550" FLOAT,
  "total_shortfall_100" FLOAT,
  "total_shortfall_1000" FLOAT,
  "total_shortfall_190" FLOAT,
  "total_shortfall_2000" FLOAT,
  "total_shortfall_3000" FLOAT,
  "total_shortfall_320" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_550" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2011_2017_1

303.93 KB
1001 rows
54 columns


CREATE TABLE owid_consumption_2011_2017_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2011" UINTEGER,
  "headcount_190_ppp2011" UINTEGER,
  "headcount_320_ppp2011" UINTEGER,
  "headcount_550_ppp2011" UINTEGER,
  "headcount_1000_ppp2011" UINTEGER,
  "headcount_2000_ppp2011" UINTEGER,
  "headcount_3000_ppp2011" UINTEGER,
  "headcount_4000_ppp2011" UINTEGER,
  "headcount_ratio_100_ppp2011" FLOAT,
  "headcount_ratio_190_ppp2011" FLOAT,
  "headcount_ratio_320_ppp2011" FLOAT,
  "headcount_ratio_550_ppp2011" FLOAT,
  "headcount_ratio_1000_ppp2011" FLOAT,
  "headcount_ratio_2000_ppp2011" FLOAT,
  "headcount_ratio_3000_ppp2011" FLOAT,
  "headcount_ratio_4000_ppp2011" FLOAT,
  "headcount_40_median_ppp2011" UINTEGER,
  "headcount_50_median_ppp2011" UINTEGER,
  "headcount_60_median_ppp2011" UINTEGER,
  "headcount_ratio_40_median_ppp2011" FLOAT,
  "headcount_ratio_50_median_ppp2011" FLOAT,
  "headcount_ratio_60_median_ppp2011" FLOAT,
  "mean_ppp2011" FLOAT,
  "median_ppp2011" FLOAT,
  "decile1_thr_ppp2011" FLOAT,
  "decile9_thr_ppp2011" FLOAT,
  "headcount_100_ppp2017" UINTEGER,
  "headcount_215_ppp2017" UINTEGER,
  "headcount_365_ppp2017" UINTEGER,
  "headcount_685_ppp2017" UINTEGER,
  "headcount_1000_ppp2017" UINTEGER,
  "headcount_2000_ppp2017" UINTEGER,
  "headcount_3000_ppp2017" UINTEGER,
  "headcount_4000_ppp2017" UINTEGER,
  "headcount_ratio_100_ppp2017" FLOAT,
  "headcount_ratio_215_ppp2017" FLOAT,
  "headcount_ratio_365_ppp2017" FLOAT,
  "headcount_ratio_685_ppp2017" FLOAT,
  "headcount_ratio_1000_ppp2017" FLOAT,
  "headcount_ratio_2000_ppp2017" FLOAT,
  "headcount_ratio_3000_ppp2017" FLOAT,
  "headcount_ratio_4000_ppp2017" FLOAT,
  "headcount_40_median_ppp2017" UINTEGER,
  "headcount_50_median_ppp2017" UINTEGER,
  "headcount_60_median_ppp2017" UINTEGER,
  "headcount_ratio_40_median_ppp2017" FLOAT,
  "headcount_ratio_50_median_ppp2017" FLOAT,
  "headcount_ratio_60_median_ppp2017" FLOAT,
  "mean_ppp2017" FLOAT,
  "median_ppp2017" FLOAT,
  "decile1_thr_ppp2017" FLOAT,
  "decile9_thr_ppp2017" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2011_2017_2

320.66 KB
1044 rows
54 columns


CREATE TABLE owid_consumption_2011_2017_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2011" FLOAT,
  "headcount_190_ppp2011" FLOAT,
  "headcount_320_ppp2011" FLOAT,
  "headcount_550_ppp2011" FLOAT,
  "headcount_1000_ppp2011" FLOAT,
  "headcount_2000_ppp2011" FLOAT,
  "headcount_3000_ppp2011" FLOAT,
  "headcount_4000_ppp2011" FLOAT,
  "headcount_ratio_100_ppp2011" FLOAT,
  "headcount_ratio_190_ppp2011" FLOAT,
  "headcount_ratio_320_ppp2011" FLOAT,
  "headcount_ratio_550_ppp2011" FLOAT,
  "headcount_ratio_1000_ppp2011" FLOAT,
  "headcount_ratio_2000_ppp2011" FLOAT,
  "headcount_ratio_3000_ppp2011" FLOAT,
  "headcount_ratio_4000_ppp2011" FLOAT,
  "headcount_40_median_ppp2011" FLOAT,
  "headcount_50_median_ppp2011" FLOAT,
  "headcount_60_median_ppp2011" FLOAT,
  "headcount_ratio_40_median_ppp2011" FLOAT,
  "headcount_ratio_50_median_ppp2011" FLOAT,
  "headcount_ratio_60_median_ppp2011" FLOAT,
  "mean_ppp2011" FLOAT,
  "median_ppp2011" FLOAT,
  "decile1_thr_ppp2011" FLOAT,
  "decile9_thr_ppp2011" FLOAT,
  "headcount_100_ppp2017" FLOAT,
  "headcount_215_ppp2017" FLOAT,
  "headcount_365_ppp2017" FLOAT,
  "headcount_685_ppp2017" FLOAT,
  "headcount_1000_ppp2017" FLOAT,
  "headcount_2000_ppp2017" FLOAT,
  "headcount_3000_ppp2017" FLOAT,
  "headcount_4000_ppp2017" FLOAT,
  "headcount_ratio_100_ppp2017" FLOAT,
  "headcount_ratio_215_ppp2017" FLOAT,
  "headcount_ratio_365_ppp2017" FLOAT,
  "headcount_ratio_685_ppp2017" FLOAT,
  "headcount_ratio_1000_ppp2017" FLOAT,
  "headcount_ratio_2000_ppp2017" FLOAT,
  "headcount_ratio_3000_ppp2017" FLOAT,
  "headcount_ratio_4000_ppp2017" FLOAT,
  "headcount_40_median_ppp2017" FLOAT,
  "headcount_50_median_ppp2017" FLOAT,
  "headcount_60_median_ppp2017" FLOAT,
  "headcount_ratio_40_median_ppp2017" FLOAT,
  "headcount_ratio_50_median_ppp2017" FLOAT,
  "headcount_ratio_60_median_ppp2017" FLOAT,
  "mean_ppp2017" FLOAT,
  "median_ppp2017" FLOAT,
  "decile1_thr_ppp2017" FLOAT,
  "decile9_thr_ppp2017" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2011_2017_3

297.97 KB
987 rows
54 columns


CREATE TABLE owid_consumption_2011_2017_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2011" UINTEGER,
  "headcount_190_ppp2011" UINTEGER,
  "headcount_320_ppp2011" UINTEGER,
  "headcount_550_ppp2011" UINTEGER,
  "headcount_1000_ppp2011" UINTEGER,
  "headcount_2000_ppp2011" UINTEGER,
  "headcount_3000_ppp2011" UINTEGER,
  "headcount_4000_ppp2011" UINTEGER,
  "headcount_ratio_100_ppp2011" FLOAT,
  "headcount_ratio_190_ppp2011" FLOAT,
  "headcount_ratio_320_ppp2011" FLOAT,
  "headcount_ratio_550_ppp2011" FLOAT,
  "headcount_ratio_1000_ppp2011" FLOAT,
  "headcount_ratio_2000_ppp2011" FLOAT,
  "headcount_ratio_3000_ppp2011" FLOAT,
  "headcount_ratio_4000_ppp2011" FLOAT,
  "headcount_40_median_ppp2011" FLOAT,
  "headcount_50_median_ppp2011" FLOAT,
  "headcount_60_median_ppp2011" FLOAT,
  "headcount_ratio_40_median_ppp2011" FLOAT,
  "headcount_ratio_50_median_ppp2011" FLOAT,
  "headcount_ratio_60_median_ppp2011" FLOAT,
  "mean_ppp2011" FLOAT,
  "median_ppp2011" FLOAT,
  "decile1_thr_ppp2011" FLOAT,
  "decile9_thr_ppp2011" FLOAT,
  "headcount_100_ppp2017" UINTEGER,
  "headcount_215_ppp2017" UINTEGER,
  "headcount_365_ppp2017" UINTEGER,
  "headcount_685_ppp2017" UINTEGER,
  "headcount_1000_ppp2017" UINTEGER,
  "headcount_2000_ppp2017" UINTEGER,
  "headcount_3000_ppp2017" UINTEGER,
  "headcount_4000_ppp2017" UINTEGER,
  "headcount_ratio_100_ppp2017" FLOAT,
  "headcount_ratio_215_ppp2017" FLOAT,
  "headcount_ratio_365_ppp2017" FLOAT,
  "headcount_ratio_685_ppp2017" FLOAT,
  "headcount_ratio_1000_ppp2017" FLOAT,
  "headcount_ratio_2000_ppp2017" FLOAT,
  "headcount_ratio_3000_ppp2017" FLOAT,
  "headcount_ratio_4000_ppp2017" FLOAT,
  "headcount_40_median_ppp2017" FLOAT,
  "headcount_50_median_ppp2017" FLOAT,
  "headcount_60_median_ppp2017" FLOAT,
  "headcount_ratio_40_median_ppp2017" FLOAT,
  "headcount_ratio_50_median_ppp2017" FLOAT,
  "headcount_ratio_60_median_ppp2017" FLOAT,
  "mean_ppp2017" FLOAT,
  "median_ppp2017" FLOAT,
  "decile1_thr_ppp2017" FLOAT,
  "decile9_thr_ppp2017" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2011_3

966.26 KB
987 rows
173 columns


CREATE TABLE owid_consumption_2011_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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,
  "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,
  "headcount_100" UINTEGER,
  "headcount_1000" UINTEGER,
  "headcount_190" UINTEGER,
  "headcount_2000" UINTEGER,
  "headcount_3000" UINTEGER,
  "headcount_320" UINTEGER,
  "headcount_4000" UINTEGER,
  "headcount_550" UINTEGER,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_190" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_320" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_550" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_190" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_320" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_550" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_190" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_320" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_550" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_190" FLOAT,
  "avg_shortfall_2000" FLOAT,
  "avg_shortfall_3000" FLOAT,
  "avg_shortfall_320" FLOAT,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_550" FLOAT,
  "total_shortfall_100" FLOAT,
  "total_shortfall_1000" BIGINT,
  "total_shortfall_190" FLOAT,
  "total_shortfall_2000" BIGINT,
  "total_shortfall_3000" BIGINT,
  "total_shortfall_320" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_1

941.6 KB
1001 rows
167 columns


CREATE TABLE owid_consumption_2017_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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,
  "headcount_40_median" UINTEGER,
  "headcount_50_median" UINTEGER,
  "headcount_60_median" UINTEGER,
  "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" UINTEGER,
  "headcount_1000" UINTEGER,
  "headcount_2000" UINTEGER,
  "headcount_215" UINTEGER,
  "headcount_3000" UINTEGER,
  "headcount_365" UINTEGER,
  "headcount_4000" UINTEGER,
  "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,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_685" FLOAT,
  "total_shortfall_100" FLOAT,
  "total_shortfall_1000" FLOAT,
  "total_shortfall_2000" FLOAT,
  "total_shortfall_215" FLOAT,
  "total_shortfall_3000" FLOAT,
  "total_shortfall_365" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_685" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_2

993.64 KB
1044 rows
167 columns


CREATE TABLE owid_consumption_2017_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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,
  "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,
  "total_shortfall_1000" FLOAT,
  "total_shortfall_2000" FLOAT,
  "total_shortfall_215" FLOAT,
  "total_shortfall_3000" FLOAT,
  "total_shortfall_365" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_685" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_3

969.65 KB
987 rows
174 columns


CREATE TABLE owid_consumption_2017_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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,
  "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" UINTEGER,
  "headcount_2000" UINTEGER,
  "headcount_215" UINTEGER,
  "headcount_3000" UINTEGER,
  "headcount_365" UINTEGER,
  "headcount_4000" UINTEGER,
  "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,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_685" FLOAT,
  "total_shortfall_100" FLOAT,
  "total_shortfall_1000" FLOAT,
  "total_shortfall_2000" BIGINT,
  "total_shortfall_215" FLOAT,
  "total_shortfall_3000" BIGINT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_1000_1

15.16 KB
1001 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_1000_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_1000_2

15.43 KB
1044 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_1000_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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_1000_3

15.1 KB
987 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_1000_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_100_1

13.97 KB
1001 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_100_2

14.16 KB
1044 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_100_3

13.38 KB
987 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_100_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_2000_1

15.12 KB
1001 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_2000_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_2000_2

15.39 KB
1044 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_2000_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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_2000_3

15.1 KB
987 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_2000_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_215_1

14.93 KB
1001 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_215_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_215_2

15.17 KB
1044 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_215_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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_215_3

14.63 KB
987 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_215_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_3000_1

15.05 KB
1001 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_3000_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_3000_2

15.33 KB
1044 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_3000_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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_3000_3

15.1 KB
987 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_3000_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
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_avg_shortfall_365_1

15.15 KB
1001 rows
9 columns


CREATE TABLE owid_consumption_2017_avg_shortfall_365_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
);