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_consumption_2017_total_shortfall_4000

35.11 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_total_shortfall_4000 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" BIGINT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" BIGINT,
  "consumption_spell_7" BIGINT,
  "income_spell_1" BIGINT,
  "income_spell_2" BIGINT,
  "income_spell_3" UINTEGER,
  "income_spell_4" UINTEGER,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_total_shortfall_40_median

30.37 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_total_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" UINTEGER,
  "income_spell_1" FLOAT,
  "income_spell_2" FLOAT,
  "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_consumption_2017_total_shortfall_50_median

30.38 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_total_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "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_consumption_2017_total_shortfall_60_median

30.32 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_total_shortfall_60_median (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" UINTEGER,
  "consumption_spell_5" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "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_consumption_2017_total_shortfall_685

30.54 kB
2,369 rows
17 columns


CREATE TABLE owid_income_consumption_2017_total_shortfall_685 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "income_spell_1" FLOAT,
  "income_spell_2" FLOAT,
  "income_spell_3" FLOAT,
  "income_spell_4" FLOAT,
  "income_spell_5" UINTEGER,
  "income_spell_6" UINTEGER,
  "income_spell_7" UINTEGER,
  "income_spell_8" UINTEGER
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_unsmoothed_1

2.72 MB
2,875 rows
181 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_unsmoothed_2

3.11 MB
2,935 rows
205 columns


CREATE TABLE owid_income_consumption_2017_unsmoothed_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "ppp_version" INTEGER,
  "survey_comparability" INTEGER,
  "comparable_spell" VARCHAR,
  "reporting_pop" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "decile1_share" FLOAT,
  "decile2_share" FLOAT,
  "decile3_share" FLOAT,
  "decile4_share" FLOAT,
  "decile5_share" FLOAT,
  "decile6_share" FLOAT,
  "decile7_share" FLOAT,
  "decile8_share" FLOAT,
  "decile9_share" FLOAT,
  "decile10_share" FLOAT,
  "decile1_thr" FLOAT,
  "decile2_thr" FLOAT,
  "decile3_thr" FLOAT,
  "decile4_thr" FLOAT,
  "decile5_thr" FLOAT,
  "decile6_thr" FLOAT,
  "decile7_thr" FLOAT,
  "decile8_thr" FLOAT,
  "decile9_thr" FLOAT,
  "is_interpolated" INTEGER,
  "distribution_type" VARCHAR,
  "estimation_type" VARCHAR,
  "headcount_40_median" 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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_unsmoothed_3

3.1 MB
2,935 rows
205 columns


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

Income Consumption 2021–1

@owid.world_bank_pip_legacy.owid_income_consumption_2021_1

3.12 MB
11,996 rows
201 columns


CREATE TABLE owid_income_consumption_2021_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,
  "cpi" FLOAT,
  "ppp" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_2000" BIGINT,
  "headcount_300" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_4000" BIGINT,
  "headcount_420" UINTEGER,
  "headcount_500" UINTEGER,
  "headcount_700" UINTEGER,
  "headcount_830" BIGINT,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_300" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_420" FLOAT,
  "headcount_ratio_500" FLOAT,
  "headcount_ratio_700" FLOAT,
  "headcount_ratio_830" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_300" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_420" FLOAT,
  "income_gap_ratio_500" FLOAT,
  "income_gap_ratio_700" FLOAT,
  "income_gap_ratio_830" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_300" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_420" FLOAT,
  "poverty_gap_index_500" FLOAT,
  "poverty_gap_index_700" FLOAT,
  "poverty_gap_index_830" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT
);

Income Consumption 2021–2

@owid.world_bank_pip_legacy.owid_income_consumption_2021_2

3.12 MB
11,996 rows
201 columns


CREATE TABLE owid_income_consumption_2021_2 (
  "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,
  "cpi" FLOAT,
  "ppp" FLOAT,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_2000" BIGINT,
  "headcount_300" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_4000" BIGINT,
  "headcount_420" UINTEGER,
  "headcount_500" UINTEGER,
  "headcount_700" UINTEGER,
  "headcount_830" BIGINT,
  "headcount_ratio_100" FLOAT,
  "headcount_ratio_1000" FLOAT,
  "headcount_ratio_2000" FLOAT,
  "headcount_ratio_300" FLOAT,
  "headcount_ratio_3000" FLOAT,
  "headcount_ratio_4000" FLOAT,
  "headcount_ratio_420" FLOAT,
  "headcount_ratio_500" FLOAT,
  "headcount_ratio_700" FLOAT,
  "headcount_ratio_830" FLOAT,
  "income_gap_ratio_100" FLOAT,
  "income_gap_ratio_1000" FLOAT,
  "income_gap_ratio_2000" FLOAT,
  "income_gap_ratio_300" FLOAT,
  "income_gap_ratio_3000" FLOAT,
  "income_gap_ratio_4000" FLOAT,
  "income_gap_ratio_420" FLOAT,
  "income_gap_ratio_500" FLOAT,
  "income_gap_ratio_700" FLOAT,
  "income_gap_ratio_830" FLOAT,
  "poverty_gap_index_100" FLOAT,
  "poverty_gap_index_1000" FLOAT,
  "poverty_gap_index_2000" FLOAT,
  "poverty_gap_index_300" FLOAT,
  "poverty_gap_index_3000" FLOAT,
  "poverty_gap_index_4000" FLOAT,
  "poverty_gap_index_420" FLOAT,
  "poverty_gap_index_500" FLOAT,
  "poverty_gap_index_700" FLOAT,
  "poverty_gap_index_830" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2021_avg_shortfall_1000_1

31.54 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_1000_2

31.54 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_100_1

27.85 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_100_2

27.85 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_2000_1

31.62 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_2000_2

31.62 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_3000_1

31.62 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_3000_2

31.62 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_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,
  "consumption_spell_8" 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_2021_avg_shortfall_300_1

30.65 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_300_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,
  "consumption_spell_8" 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_2021_avg_shortfall_300_2

30.65 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_300_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,
  "consumption_spell_8" 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_2021_avg_shortfall_4000_1

31.62 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_4000_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,
  "consumption_spell_8" 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_2021_avg_shortfall_4000_2

31.62 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_4000_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,
  "consumption_spell_8" 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_2021_avg_shortfall_40_median_1

31.5 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_40_median_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" FLOAT,
  "consumption_spell_6" FLOAT,
  "consumption_spell_7" FLOAT,
  "consumption_spell_8" 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_2021_avg_shortfall_40_median_2

31.5 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_40_median_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" FLOAT,
  "consumption_spell_5" FLOAT,
  "consumption_spell_6" FLOAT,
  "consumption_spell_7" FLOAT,
  "consumption_spell_8" 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_2021_avg_shortfall_420_1

31.16 kB
2,415 rows
18 columns


CREATE TABLE owid_income_consumption_2021_avg_shortfall_420_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,
  "consumption_spell_8" 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
);