About this Dataset

World Bank Poverty And Inequality Platform (PIP)

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

Tables

World Bank Pip 5

@owid.world_bank_pip.owid_world_bank_pip_5

27.8 MB
1,319,082 rows
45 columns

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

World Bank Pip Complete Series

@owid.world_bank_pip.owid_world_bank_pip_complete_series

7.23 MB
215,064 rows
42 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_world_bank_pip_percentiles_1

10.01 MB
559,700 rows
10 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_world_bank_pip_percentiles_2

8.82 MB
572,080 rows
10 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_world_bank_pip_percentiles_3

10.55 MB
567,048 rows
10 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_world_bank_pip_percentiles_4

9.02 MB
582,480 rows
11 columns

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