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_income_consumption_2021_total_shortfall_4000_1
  • 36.02 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_4000_1 (
  "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,
  "consumption_spell_8" 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_2021_total_shortfall_4000_2
  • 36.02 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_4000_2 (
  "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,
  "consumption_spell_8" 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_2021_total_shortfall_40_median_1
  • 31.29 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" 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_2021_total_shortfall_40_median_2
  • 31.29 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_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" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" 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_2021_total_shortfall_420_1
  • 31.15 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_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" UINTEGER,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" UINTEGER,
  "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" UINTEGER
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2021_total_shortfall_420_2
  • 31.15 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_420_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,
  "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" UINTEGER
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2021_total_shortfall_500_1
  • 31.21 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_500_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,
  "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" UINTEGER,
  "income_spell_8" UINTEGER
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2021_total_shortfall_500_2
  • 31.21 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_500_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,
  "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" UINTEGER,
  "income_spell_8" UINTEGER
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2021_total_shortfall_50_median_1
  • 31.3 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_50_median_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" UINTEGER,
  "consumption_spell_5" FLOAT,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" 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_2021_total_shortfall_50_median_2
  • 31.3 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_50_median_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" FLOAT,
  "consumption_spell_3" FLOAT,
  "consumption_spell_4" UINTEGER,
  "consumption_spell_5" FLOAT,
  "consumption_spell_6" UINTEGER,
  "consumption_spell_7" UINTEGER,
  "consumption_spell_8" 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_2021_total_shortfall_60_median_1
  • 31.27 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_60_median_1 (
  "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,
  "consumption_spell_8" 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_2021_total_shortfall_60_median_2
  • 31.27 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_consumption_2021_total_shortfall_60_median_2 (
  "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,
  "consumption_spell_8" 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_2021_total_shortfall_700_1
  • 31.29 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_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,
  "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_2021_total_shortfall_700_2
  • 31.29 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_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,
  "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_2021_total_shortfall_830_1
  • 31.69 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_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,
  "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_2021_total_shortfall_830_2
  • 31.69 kB
  • 2,415 rows
  • 18 columns
Loading... 

CREATE TABLE owid_income_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,
  "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_2021_unsmoothed_1
  • 3.1 MB
  • 2,935 rows
  • 205 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2021_unsmoothed_2
  • 3.1 MB
  • 2,935 rows
  • 205 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_percentiles_income_consumption_2011
  • 5.96 MB
  • 279,850 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_percentiles_income_consumption_2017_1
  • 5.96 MB
  • 279,850 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_percentiles_income_consumption_2017_2
  • 4.74 MB
  • 286,040 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_percentiles_income_consumption_2017_3
  • 5.92 MB
  • 280,908 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_percentiles_income_consumption_2021_1
  • 4.74 MB
  • 286,040 rows
  • 10 columns
Loading... 

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_percentiles_income_consumption_2021_2
  • 4.74 MB
  • 286,140 rows
  • 10 columns
Loading... 

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

Share link

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