Format: dataset has 108 columns and 4878 rows.

Note: Use pip_codebook.csv file for column details.

Description:

A global dataset of poverty and inequality measures prepared by Our World in Data from the World Bank's Poverty and Inequality Platform (PIP) database. The World Bank’s PIP data is a large collection of household surveys where steps have been taken by the World Bank to harmonize definitions and methods across countries and over time.

Tables

Pip Codebook

@kaggle.utkarshx27_global_poverty_and_inequality_dataset.pip_codebook

9.85 KB
108 rows
2 columns


CREATE TABLE pip_codebook (
  "column" VARCHAR,
  "description" VARCHAR
);

Pip Dataset

@kaggle.utkarshx27_global_poverty_and_inequality_dataset.pip_dataset

3.83 MB
4877 rows
108 columns


CREATE TABLE pip_dataset (
  "country" VARCHAR,
  "year" BIGINT,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "ppp_version" BIGINT,
  "survey_year" DOUBLE,
  "survey_comparability" DOUBLE,
  "headcount_ratio_international_povline" DOUBLE,
  "headcount_ratio_lower_mid_income_povline" DOUBLE,
  "headcount_ratio_upper_mid_income_povline" DOUBLE,
  "headcount_ratio_100" DOUBLE,
  "headcount_ratio_1000" DOUBLE,
  "headcount_ratio_2000" DOUBLE,
  "headcount_ratio_3000" DOUBLE,
  "headcount_ratio_4000" DOUBLE,
  "headcount_ratio_40_median" DOUBLE,
  "headcount_ratio_50_median" DOUBLE,
  "headcount_ratio_60_median" DOUBLE,
  "headcount_international_povline" DOUBLE,
  "headcount_lower_mid_income_povline" DOUBLE,
  "headcount_upper_mid_income_povline" DOUBLE,
  "headcount_100" DOUBLE,
  "headcount_1000" DOUBLE,
  "headcount_2000" DOUBLE,
  "headcount_3000" DOUBLE,
  "headcount_4000" DOUBLE,
  "headcount_40_median" DOUBLE,
  "headcount_50_median" DOUBLE,
  "headcount_60_median" DOUBLE,
  "avg_shortfall_international_povline" DOUBLE,
  "avg_shortfall_lower_mid_income_povline" DOUBLE,
  "avg_shortfall_upper_mid_income_povline" DOUBLE,
  "avg_shortfall_100" DOUBLE,
  "avg_shortfall_1000" DOUBLE,
  "avg_shortfall_2000" DOUBLE,
  "avg_shortfall_3000" DOUBLE,
  "avg_shortfall_4000" DOUBLE,
  "avg_shortfall_40_median" DOUBLE,
  "avg_shortfall_50_median" DOUBLE,
  "avg_shortfall_60_median" DOUBLE,
  "total_shortfall_international_povline" DOUBLE,
  "total_shortfall_lower_mid_income_povline" DOUBLE,
  "total_shortfall_upper_mid_income_povline" DOUBLE,
  "total_shortfall_100" DOUBLE,
  "total_shortfall_1000" DOUBLE,
  "total_shortfall_2000" DOUBLE,
  "total_shortfall_3000" DOUBLE,
  "total_shortfall_4000" DOUBLE,
  "total_shortfall_40_median" DOUBLE,
  "total_shortfall_50_median" DOUBLE,
  "total_shortfall_60_median" DOUBLE,
  "income_gap_ratio_international_povline" DOUBLE,
  "income_gap_ratio_lower_mid_income_povline" DOUBLE,
  "income_gap_ratio_upper_mid_income_povline" DOUBLE,
  "income_gap_ratio_100" DOUBLE,
  "income_gap_ratio_1000" DOUBLE,
  "income_gap_ratio_2000" DOUBLE,
  "income_gap_ratio_3000" DOUBLE,
  "income_gap_ratio_4000" DOUBLE,
  "income_gap_ratio_40_median" DOUBLE,
  "income_gap_ratio_50_median" DOUBLE,
  "income_gap_ratio_60_median" DOUBLE,
  "poverty_gap_index_international_povline" DOUBLE,
  "poverty_gap_index_lower_mid_income_povline" DOUBLE,
  "poverty_gap_index_upper_mid_income_povline" DOUBLE,
  "poverty_gap_index_100" DOUBLE,
  "poverty_gap_index_1000" DOUBLE,
  "poverty_gap_index_2000" DOUBLE,
  "poverty_gap_index_3000" DOUBLE,
  "poverty_gap_index_4000" DOUBLE,
  "mean" DOUBLE,
  "median" DOUBLE,
  "decile1_avg" DOUBLE,
  "decile2_avg" DOUBLE,
  "decile3_avg" DOUBLE,
  "decile4_avg" DOUBLE,
  "decile5_avg" DOUBLE,
  "decile6_avg" DOUBLE,
  "decile7_avg" DOUBLE,
  "decile8_avg" DOUBLE,
  "decile9_avg" DOUBLE,
  "decile10_avg" DOUBLE,
  "decile1_share" DOUBLE,
  "decile2_share" DOUBLE,
  "decile3_share" DOUBLE,
  "decile4_share" DOUBLE,
  "decile5_share" DOUBLE,
  "decile6_share" DOUBLE,
  "decile7_share" DOUBLE,
  "decile8_share" DOUBLE,
  "decile9_share" DOUBLE,
  "decile10_share" DOUBLE,
  "decile1_thr" DOUBLE,
  "decile2_thr" DOUBLE,
  "decile3_thr" DOUBLE,
  "decile4_thr" DOUBLE,
  "decile6_thr" DOUBLE,
  "decile7_thr" DOUBLE,
  "decile8_thr" DOUBLE,
  "decile9_thr" DOUBLE
);