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 Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_40_median_1

15.52 kB
1,001 rows
9 columns


CREATE TABLE owid_consumption_2017_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" FLOAT,
  "consumption_spell_7" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_40_median_2

15.8 kB
1,044 rows
9 columns


CREATE TABLE owid_consumption_2017_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" FLOAT,
  "consumption_spell_7" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_40_median_3

15.43 kB
987 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_50_median_1

15.52 kB
1,001 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_50_median_2

15.8 kB
1,044 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_50_median_3

15.46 kB
987 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_60_median_1

15.52 kB
1,001 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_60_median_2

15.8 kB
1,044 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_60_median_3

15.46 kB
987 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_685_1

15.52 kB
1,001 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_685_2

15.8 kB
1,044 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_consumption_2017_total_shortfall_685_3

15.55 kB
987 rows
9 columns


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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_income_2011_1

1.31 MB
1,385 rows
167 columns


CREATE TABLE owid_income_2011_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,
  "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" FLOAT,
  "total_shortfall_320" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_550" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_income_2011_2

1.37 MB
1,452 rows
167 columns


CREATE TABLE owid_income_2011_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" FLOAT,
  "headcount_50_median" FLOAT,
  "headcount_60_median" FLOAT,
  "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,
  "headcount_100" FLOAT,
  "headcount_1000" FLOAT,
  "headcount_190" FLOAT,
  "headcount_2000" FLOAT,
  "headcount_3000" FLOAT,
  "headcount_320" FLOAT,
  "headcount_4000" FLOAT,
  "headcount_550" FLOAT,
  "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" FLOAT,
  "total_shortfall_320" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_550" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_income_2011_2017_1

423.49 kB
1,385 rows
54 columns


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

@owid.world_bank_pip.owid_income_2011_2017_2

441.2 kB
1,452 rows
54 columns


CREATE TABLE owid_income_2011_2017_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "headcount_100_ppp2011" FLOAT,
  "headcount_190_ppp2011" FLOAT,
  "headcount_320_ppp2011" FLOAT,
  "headcount_550_ppp2011" FLOAT,
  "headcount_1000_ppp2011" FLOAT,
  "headcount_2000_ppp2011" FLOAT,
  "headcount_3000_ppp2011" FLOAT,
  "headcount_4000_ppp2011" FLOAT,
  "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" FLOAT,
  "headcount_50_median_ppp2011" FLOAT,
  "headcount_60_median_ppp2011" FLOAT,
  "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" FLOAT,
  "headcount_215_ppp2017" FLOAT,
  "headcount_365_ppp2017" FLOAT,
  "headcount_685_ppp2017" FLOAT,
  "headcount_1000_ppp2017" FLOAT,
  "headcount_2000_ppp2017" FLOAT,
  "headcount_3000_ppp2017" FLOAT,
  "headcount_4000_ppp2017" FLOAT,
  "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" FLOAT,
  "headcount_50_median_ppp2017" FLOAT,
  "headcount_60_median_ppp2017" FLOAT,
  "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.owid_income_2011_2017_3

444.71 kB
1,468 rows
54 columns


CREATE TABLE owid_income_2011_2017_3 (
  "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" FLOAT,
  "headcount_50_median_ppp2011" FLOAT,
  "headcount_60_median_ppp2011" FLOAT,
  "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" FLOAT,
  "headcount_50_median_ppp2017" FLOAT,
  "headcount_60_median_ppp2017" FLOAT,
  "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.owid_income_2011_3

1.44 MB
1,468 rows
173 columns


CREATE TABLE owid_income_2011_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" FLOAT,
  "headcount_50_median" FLOAT,
  "headcount_60_median" FLOAT,
  "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)

@owid.world_bank_pip.owid_income_2017_1

1.31 MB
1,385 rows
167 columns


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,
  "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" FLOAT,
  "total_shortfall_365" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_685" FLOAT
);

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_income_2017_2

1.37 MB
1,452 rows
167 columns


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" FLOAT,
  "headcount_50_median" FLOAT,
  "headcount_60_median" FLOAT,
  "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,
  "headcount_100" FLOAT,
  "headcount_1000" FLOAT,
  "headcount_2000" FLOAT,
  "headcount_215" FLOAT,
  "headcount_3000" FLOAT,
  "headcount_365" FLOAT,
  "headcount_4000" FLOAT,
  "headcount_685" FLOAT,
  "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" FLOAT,
  "total_shortfall_365" FLOAT,
  "total_shortfall_4000" FLOAT,
  "total_shortfall_685" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_income_2017_3

1.45 MB
1,468 rows
174 columns


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" FLOAT,
  "headcount_50_median" FLOAT,
  "headcount_60_median" FLOAT,
  "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)

@owid.world_bank_pip.owid_income_2017_avg_shortfall_1000_1

17.35 kB
1,385 rows
10 columns


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

@owid.world_bank_pip.owid_income_2017_avg_shortfall_1000_2

17.78 kB
1,452 rows
10 columns


CREATE TABLE owid_income_2017_avg_shortfall_1000_2 (
  "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.owid_income_2017_avg_shortfall_1000_3

17.9 kB
1,468 rows
10 columns


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

@owid.world_bank_pip.owid_income_2017_avg_shortfall_100_1

16.3 kB
1,385 rows
10 columns


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