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 170 economies around the world.

Tables

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_50_median_1

18.2 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_50_median_2

18.2 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_60_median_1

18.2 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_60_median_2

18.2 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_700_1

18.19 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_700_2

18.19 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_830_1

18.2 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2021_total_shortfall_830_2

18.2 kB
1,535 rows
10 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2011

2.53 MB
2,705 rows
173 columns


CREATE TABLE owid_income_consumption_2011 (
  "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,
  "spl" FLOAT,
  "spr" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_190" UINTEGER,
  "headcount_2000" BIGINT,
  "headcount_3000" BIGINT,
  "headcount_320" UINTEGER,
  "headcount_4000" BIGINT,
  "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" BIGINT,
  "total_shortfall_320" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2011_2017

831.94 kB
2,705 rows
54 columns


CREATE TABLE owid_income_consumption_2011_2017 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2011" UINTEGER,
  "headcount_190_ppp2011" UINTEGER,
  "headcount_320_ppp2011" UINTEGER,
  "headcount_550_ppp2011" UINTEGER,
  "headcount_1000_ppp2011" BIGINT,
  "headcount_2000_ppp2011" BIGINT,
  "headcount_3000_ppp2011" BIGINT,
  "headcount_4000_ppp2011" BIGINT,
  "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" BIGINT,
  "headcount_2000_ppp2017" BIGINT,
  "headcount_3000_ppp2017" BIGINT,
  "headcount_4000_ppp2017" BIGINT,
  "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): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2011_unsmoothed

2.7 MB
2,875 rows
180 columns


CREATE TABLE owid_income_consumption_2011_unsmoothed (
  "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" 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,
  "spl" FLOAT,
  "spr" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_190" UINTEGER,
  "headcount_2000" BIGINT,
  "headcount_3000" BIGINT,
  "headcount_320" UINTEGER,
  "headcount_4000" BIGINT,
  "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
);

Income Consumption 2017–1

@owid.world_bank_pip_legacy.owid_income_consumption_2017_1

2.75 MB
11,801 rows
177 columns


CREATE TABLE owid_income_consumption_2017_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "surveys_past_decade" 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,
  "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,
  "avg_shortfall_4000" FLOAT,
  "avg_shortfall_685" FLOAT,
  "total_shortfall_100" FLOAT,
  "total_shortfall_1000" FLOAT,
  "total_shortfall_2000" FLOAT,
  "total_shortfall_215" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_2

2.89 MB
2,743 rows
198 columns


CREATE TABLE owid_income_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" 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,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "cpi" FLOAT,
  "ppp" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_2000" BIGINT,
  "headcount_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "headcount_500" UINTEGER,
  "headcount_685" BIGINT,
  "headcount_700" BIGINT,
  "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_500" FLOAT,
  "headcount_ratio_685" FLOAT,
  "headcount_ratio_700" 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_500" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "income_gap_ratio_700" 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_500" FLOAT,
  "poverty_gap_index_685" FLOAT,
  "poverty_gap_index_700" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_2000" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_2021_1

957.88 kB
2,743 rows
62 columns


CREATE TABLE owid_income_consumption_2017_2021_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2017" UINTEGER,
  "headcount_215_ppp2017" UINTEGER,
  "headcount_365_ppp2017" UINTEGER,
  "headcount_500_ppp2017" UINTEGER,
  "headcount_685_ppp2017" BIGINT,
  "headcount_700_ppp2017" BIGINT,
  "headcount_1000_ppp2017" BIGINT,
  "headcount_2000_ppp2017" BIGINT,
  "headcount_3000_ppp2017" BIGINT,
  "headcount_4000_ppp2017" BIGINT,
  "headcount_ratio_100_ppp2017" FLOAT,
  "headcount_ratio_215_ppp2017" FLOAT,
  "headcount_ratio_365_ppp2017" FLOAT,
  "headcount_ratio_500_ppp2017" FLOAT,
  "headcount_ratio_685_ppp2017" FLOAT,
  "headcount_ratio_700_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,
  "headcount_100_ppp2021" UINTEGER,
  "headcount_300_ppp2021" UINTEGER,
  "headcount_420_ppp2021" UINTEGER,
  "headcount_500_ppp2021" UINTEGER,
  "headcount_700_ppp2021" UINTEGER,
  "headcount_830_ppp2021" BIGINT,
  "headcount_1000_ppp2021" BIGINT,
  "headcount_2000_ppp2021" BIGINT,
  "headcount_3000_ppp2021" BIGINT,
  "headcount_4000_ppp2021" BIGINT,
  "headcount_ratio_100_ppp2021" FLOAT,
  "headcount_ratio_300_ppp2021" FLOAT,
  "headcount_ratio_420_ppp2021" FLOAT,
  "headcount_ratio_500_ppp2021" FLOAT,
  "headcount_ratio_700_ppp2021" FLOAT,
  "headcount_ratio_830_ppp2021" FLOAT,
  "headcount_ratio_1000_ppp2021" FLOAT,
  "headcount_ratio_2000_ppp2021" FLOAT,
  "headcount_ratio_3000_ppp2021" FLOAT,
  "headcount_ratio_4000_ppp2021" FLOAT,
  "headcount_40_median_ppp2021" UINTEGER,
  "headcount_50_median_ppp2021" UINTEGER,
  "headcount_60_median_ppp2021" UINTEGER,
  "headcount_ratio_40_median_ppp2021" FLOAT,
  "headcount_ratio_50_median_ppp2021" FLOAT,
  "headcount_ratio_60_median_ppp2021" FLOAT,
  "mean_ppp2021" FLOAT,
  "median_ppp2021" FLOAT,
  "decile1_thr_ppp2021" FLOAT,
  "decile9_thr_ppp2021" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_2021_2

955.87 kB
2,743 rows
62 columns


CREATE TABLE owid_income_consumption_2017_2021_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2017" UINTEGER,
  "headcount_215_ppp2017" UINTEGER,
  "headcount_365_ppp2017" UINTEGER,
  "headcount_500_ppp2017" UINTEGER,
  "headcount_685_ppp2017" BIGINT,
  "headcount_700_ppp2017" BIGINT,
  "headcount_1000_ppp2017" BIGINT,
  "headcount_2000_ppp2017" BIGINT,
  "headcount_3000_ppp2017" BIGINT,
  "headcount_4000_ppp2017" BIGINT,
  "headcount_ratio_100_ppp2017" FLOAT,
  "headcount_ratio_215_ppp2017" FLOAT,
  "headcount_ratio_365_ppp2017" FLOAT,
  "headcount_ratio_500_ppp2017" FLOAT,
  "headcount_ratio_685_ppp2017" FLOAT,
  "headcount_ratio_700_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,
  "headcount_100_ppp2021" UINTEGER,
  "headcount_300_ppp2021" UINTEGER,
  "headcount_420_ppp2021" UINTEGER,
  "headcount_500_ppp2021" UINTEGER,
  "headcount_700_ppp2021" UINTEGER,
  "headcount_830_ppp2021" BIGINT,
  "headcount_1000_ppp2021" BIGINT,
  "headcount_2000_ppp2021" BIGINT,
  "headcount_3000_ppp2021" BIGINT,
  "headcount_4000_ppp2021" BIGINT,
  "headcount_ratio_100_ppp2021" FLOAT,
  "headcount_ratio_300_ppp2021" FLOAT,
  "headcount_ratio_420_ppp2021" FLOAT,
  "headcount_ratio_500_ppp2021" FLOAT,
  "headcount_ratio_700_ppp2021" FLOAT,
  "headcount_ratio_830_ppp2021" FLOAT,
  "headcount_ratio_1000_ppp2021" FLOAT,
  "headcount_ratio_2000_ppp2021" FLOAT,
  "headcount_ratio_3000_ppp2021" FLOAT,
  "headcount_ratio_4000_ppp2021" FLOAT,
  "headcount_40_median_ppp2021" UINTEGER,
  "headcount_50_median_ppp2021" UINTEGER,
  "headcount_60_median_ppp2021" UINTEGER,
  "headcount_ratio_40_median_ppp2021" FLOAT,
  "headcount_ratio_50_median_ppp2021" FLOAT,
  "headcount_ratio_60_median_ppp2021" FLOAT,
  "mean_ppp2021" FLOAT,
  "median_ppp2021" FLOAT,
  "decile1_thr_ppp2021" FLOAT,
  "decile9_thr_ppp2021" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_3

2.87 MB
2,743 rows
198 columns


CREATE TABLE owid_income_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" 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,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "cpi" FLOAT,
  "ppp" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_2000" BIGINT,
  "headcount_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "headcount_500" UINTEGER,
  "headcount_685" BIGINT,
  "headcount_700" BIGINT,
  "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_500" FLOAT,
  "headcount_ratio_685" FLOAT,
  "headcount_ratio_700" 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_500" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "income_gap_ratio_700" 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_500" FLOAT,
  "poverty_gap_index_685" FLOAT,
  "poverty_gap_index_700" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT,
  "avg_shortfall_2000" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_100

27.26 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_100 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_1000

30.57 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_1000 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_2000

30.63 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_2000 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_215

29.28 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_215 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_3000

30.63 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_3000 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_365

30.12 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_365 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_4000

30.63 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_4000 (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_40_median

30.5 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_40_median (
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_avg_shortfall_50_median

30.63 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_avg_shortfall_50_median (
  "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
);