Baselight
Sign In

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip_legacy

Loading...
Loading...

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_consumption_2021_total_shortfall_700_1
  • 15.95 kB
  • 968 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_consumption_2021_total_shortfall_700_2
  • 15.95 kB
  • 968 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_consumption_2021_total_shortfall_830_1
  • 16.34 kB
  • 968 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_consumption_2021_total_shortfall_830_2
  • 16.34 kB
  • 968 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2011
  • 1.44 MB
  • 1,468 rows
  • 173 columns
Loading... 

CREATE TABLE owid_income_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" 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" BIGINT,
  "total_shortfall_320" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2011_2017
  • 444.52 kB
  • 1,468 rows
  • 54 columns
Loading... 

CREATE TABLE owid_income_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" 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): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_1
  • 1.45 MB
  • 1,468 rows
  • 174 columns
Loading... 

CREATE TABLE owid_income_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,
  "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" FLOAT,
  "total_shortfall_215" FLOAT,
  "total_shortfall_3000" BIGINT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_2
  • 1.71 MB
  • 1,535 rows
  • 198 columns
Loading... 

CREATE TABLE owid_income_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" UINTEGER,
  "headcount_2000" UINTEGER,
  "headcount_215" UINTEGER,
  "headcount_3000" UINTEGER,
  "headcount_365" UINTEGER,
  "headcount_4000" UINTEGER,
  "headcount_500" UINTEGER,
  "headcount_685" UINTEGER,
  "headcount_700" 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_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_2017_2021_1
  • 534.4 kB
  • 1,535 rows
  • 62 columns
Loading... 

CREATE TABLE owid_income_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" UINTEGER,
  "headcount_700_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_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" UINTEGER,
  "headcount_1000_ppp2021" UINTEGER,
  "headcount_2000_ppp2021" UINTEGER,
  "headcount_3000_ppp2021" UINTEGER,
  "headcount_4000_ppp2021" UINTEGER,
  "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_2017_2021_2
  • 532.43 kB
  • 1,535 rows
  • 62 columns
Loading... 

CREATE TABLE owid_income_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" UINTEGER,
  "headcount_700_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_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" UINTEGER,
  "headcount_1000_ppp2021" UINTEGER,
  "headcount_2000_ppp2021" UINTEGER,
  "headcount_3000_ppp2021" UINTEGER,
  "headcount_4000_ppp2021" UINTEGER,
  "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_2017_3
  • 1.7 MB
  • 1,535 rows
  • 198 columns
Loading... 

CREATE TABLE owid_income_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" UINTEGER,
  "headcount_2000" UINTEGER,
  "headcount_215" UINTEGER,
  "headcount_3000" UINTEGER,
  "headcount_365" UINTEGER,
  "headcount_4000" UINTEGER,
  "headcount_500" UINTEGER,
  "headcount_685" UINTEGER,
  "headcount_700" 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_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_2017_avg_shortfall_100
  • 16.43 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_1000
  • 17.9 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_2000
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_215
  • 17.11 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_3000
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_365
  • 17.53 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_4000
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_40_median
  • 17.91 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_50_median
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_60_median
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_avg_shortfall_685
  • 17.84 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_bottom50_share
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_decile10_avg
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_2017_decile10_share
  • 17.96 kB
  • 1,468 rows
  • 10 columns
Loading... 

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

Share link

Anyone who has the link will be able to view this.