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.16 KB
1001 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.43 KB
1044 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.07 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.16 KB
1001 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.43 KB
1044 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.1 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.16 KB
1001 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.43 KB
1044 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.1 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.16 KB
1001 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.43 KB
1044 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.19 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.25 MB
1385 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.31 MB
1452 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

413.57 KB
1385 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

430.86 KB
1452 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

434.28 KB
1468 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.37 MB
1468 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.25 MB
1385 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.31 MB
1452 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.38 MB
1468 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

16.95 KB
1385 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.37 KB
1452 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.48 KB
1468 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

15.92 KB
1385 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
);