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_2017_poverty_gap_index_685

30.56 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_poverty_gap_index_685 (
  "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,
  "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_legacy.owid_income_consumption_2017_s80_s20_ratio

30.63 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_s80_s20_ratio (
  "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,
  "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_legacy.owid_income_consumption_2017_spl

29.92 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_spl (
  "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,
  "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_legacy.owid_income_consumption_2017_spr

30.63 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_spr (
  "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,
  "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_legacy.owid_income_consumption_2017_top1_avg

30.62 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_top1_avg (
  "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,
  "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_legacy.owid_income_consumption_2017_top1_share

30.61 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_top1_share (
  "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,
  "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_legacy.owid_income_consumption_2017_top1_thr

30.62 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_top1_thr (
  "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,
  "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_legacy.owid_income_consumption_2017_top90_99_share

30.61 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_top90_99_share (
  "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,
  "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_legacy.owid_income_consumption_2017_total_shortfall_100

28.01 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_100 (
  "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,
  "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_legacy.owid_income_consumption_2017_total_shortfall_1000

32.52 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_1000 (
  "country" VARCHAR,
  "year" INTEGER,
  "consumption_spell_1" FLOAT,
  "consumption_spell_2" BIGINT,
  "consumption_spell_3" BIGINT,
  "consumption_spell_4" BIGINT,
  "consumption_spell_5" BIGINT,
  "consumption_spell_6" BIGINT,
  "consumption_spell_7" BIGINT,
  "income_spell_1" FLOAT,
  "income_spell_2" FLOAT,
  "income_spell_3" UINTEGER,
  "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_2017_total_shortfall_2000

33.24 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_2000 (
  "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,
  "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_2017_total_shortfall_215

29.49 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_215 (
  "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,
  "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_2017_total_shortfall_3000

34.15 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_3000 (
  "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,
  "income_spell_1" BIGINT,
  "income_spell_2" UINTEGER,
  "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_2017_total_shortfall_365

30.14 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_365 (
  "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,
  "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_2017_total_shortfall_4000

35.11 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_4000 (
  "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,
  "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_2017_total_shortfall_40_median

30.37 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_40_median (
  "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" 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_2017_total_shortfall_50_median

30.38 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_50_median (
  "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,
  "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_2017_total_shortfall_60_median

30.32 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_60_median (
  "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,
  "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_2017_total_shortfall_685

30.54 kB
2,369 rows
17 columns

CREATE TABLE owid_income_consumption_2017_total_shortfall_685 (
  "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,
  "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_2017_unsmoothed_1

2.72 MB
2,875 rows
181 columns

CREATE TABLE owid_income_consumption_2017_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,
  "headcount_100" UINTEGER,
  "headcount_1000" BIGINT,
  "headcount_2000" BIGINT,
  "headcount_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_unsmoothed_2

3.11 MB
2,935 rows
205 columns

CREATE TABLE owid_income_consumption_2017_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_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "headcount_500" UINTEGER,
  "headcount_685" BIGINT,
  "headcount_700" BIGINT,
  "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_500" FLOAT,
  "headcount_ratio_685" FLOAT,
  "headcount_ratio_700" 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_500" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "income_gap_ratio_700" 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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_unsmoothed_3

3.1 MB
2,935 rows
205 columns

CREATE TABLE owid_income_consumption_2017_unsmoothed_3 (
  "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_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "headcount_500" UINTEGER,
  "headcount_685" BIGINT,
  "headcount_700" BIGINT,
  "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_500" FLOAT,
  "headcount_ratio_685" FLOAT,
  "headcount_ratio_700" 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_500" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "income_gap_ratio_700" 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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip_legacy.owid_income_consumption_2017_unsmoothed_4

3.26 MB
3,068 rows
205 columns

CREATE TABLE owid_income_consumption_2017_unsmoothed_4 (
  "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_215" UINTEGER,
  "headcount_3000" BIGINT,
  "headcount_365" UINTEGER,
  "headcount_4000" BIGINT,
  "headcount_500" UINTEGER,
  "headcount_685" BIGINT,
  "headcount_700" BIGINT,
  "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_500" FLOAT,
  "headcount_ratio_685" FLOAT,
  "headcount_ratio_700" 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_500" FLOAT,
  "income_gap_ratio_685" FLOAT,
  "income_gap_ratio_700" 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
);

Income Consumption 2021–1

@owid.world_bank_pip_legacy.owid_income_consumption_2021_1

3.12 MB
11,996 rows
201 columns

CREATE TABLE owid_income_consumption_2021_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "surveys_past_decade" 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,
  "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,
  "poverty_gap_index_420" FLOAT,
  "poverty_gap_index_500" FLOAT,
  "poverty_gap_index_700" FLOAT,
  "poverty_gap_index_830" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT
);

Income Consumption 2021–2

@owid.world_bank_pip_legacy.owid_income_consumption_2021_2

3.12 MB
11,996 rows
201 columns

CREATE TABLE owid_income_consumption_2021_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "surveys_past_decade" 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,
  "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,
  "poverty_gap_index_420" FLOAT,
  "poverty_gap_index_500" FLOAT,
  "poverty_gap_index_700" FLOAT,
  "poverty_gap_index_830" FLOAT,
  "avg_shortfall_100" FLOAT,
  "avg_shortfall_1000" FLOAT
);