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): Percentiles

@owid.world_bank_pip.owid_income_consumption_2017_total_shortfall_4000_3

34.67 kB
2,369 rows
17 columns

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

@owid.world_bank_pip.owid_income_consumption_2017_total_shortfall_40_median_1

29.71 kB
2,309 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_40_median_2

30.79 kB
2,412 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_40_median_3

30.56 kB
2,369 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_50_median_1

29.71 kB
2,309 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_50_median_2

30.79 kB
2,412 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_50_median_3

30.63 kB
2,369 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_60_median_1

29.71 kB
2,309 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_60_median_2

30.79 kB
2,412 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_60_median_3

30.63 kB
2,369 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_685_1

29.66 kB
2,309 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_685_2

30.83 kB
2,412 rows
17 columns

CREATE TABLE owid_income_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,
  "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_consumption_2017_total_shortfall_685_3

30.53 kB
2,369 rows
17 columns

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

@owid.world_bank_pip.owid_income_consumption_2017_unsmoothed_1

2.51 MB
2,782 rows
174 columns

CREATE TABLE owid_income_consumption_2017_unsmoothed_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "reporting_level" VARCHAR,
  "welfare_type" VARCHAR,
  "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" 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
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_income_consumption_2017_unsmoothed_2

2.72 MB
2,875 rows
181 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" 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" 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.owid_percentiles_income_consumption_2011_1

4.34 MB
267,229 rows
9 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_percentiles_income_consumption_2011_2

4.72 MB
285,582 rows
9 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_percentiles_income_consumption_2011_3

5.96 MB
279,850 rows
10 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_percentiles_income_consumption_2017_1

4.34 MB
267,329 rows
9 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_percentiles_income_consumption_2017_2

4.72 MB
285,582 rows
9 columns

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

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_percentiles_income_consumption_2017_3

5.96 MB
279,850 rows
10 columns

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

World Bank Poverty And Inequality Platform (PIP)

@owid.world_bank_pip.owid_world_bank_pip_1

1.25 MB
2,363 rows
91 columns

CREATE TABLE owid_world_bank_pip_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "dollar1_share_of_population_above_poverty_line" FLOAT  -- Dollar1, Share Of Population Above Poverty Line,
  "dollar1_total_number_of_people_above_poverty_line" BIGINT  -- Dollar1, Total Number Of People Above Poverty Line,
  "dollar1_total_number_of_people_below_poverty_line" UINTEGER  -- Dollar1, Total Number Of People Below Poverty Line,
  "dollar1_a_day_poverty_gap_index" FLOAT  -- Dollar1 A Day, Poverty Gap Index,
  "dollar1_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar1 A Day, Share Of Population Below Poverty Line,
  "dollar1_a_day_total_shortfall" FLOAT  -- Dollar1 A Day, Total Shortfall,
  "dollar1_dollar2_15_share_of_population_between_poverty_lines" FLOAT  -- Dollar1 Dollar2–15, Share Of Population Between Poverty Lines,
  "dollar1_dollar2_15_total_number_of_people_between_poverty_lines" UINTEGER  -- Dollar1 Dollar2–15, Total Number Of People Between Poverty Lines,
  "dollar10_share_of_population_above_poverty_line" FLOAT  -- Dollar10, Share Of Population Above Poverty Line,
  "dollar10_total_number_of_people_above_poverty_line" UINTEGER  -- Dollar10, Total Number Of People Above Poverty Line,
  "dollar10_total_number_of_people_below_poverty_line" BIGINT  -- Dollar10, Total Number Of People Below Poverty Line,
  "dollar10_a_day_poverty_gap_index" FLOAT  -- Dollar10 A Day, Poverty Gap Index,
  "dollar10_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar10 A Day, Share Of Population Below Poverty Line,
  "dollar10_a_day_total_shortfall" FLOAT  -- Dollar10 A Day, Total Shortfall,
  "dollar10_dollar20_share_of_population_between_poverty_lines" FLOAT  -- Dollar10 Dollar20, Share Of Population Between Poverty Lines,
  "dollar10_dollar20_total_number_of_people_between_poverty_lines" UINTEGER  -- Dollar10 Dollar20, Total Number Of People Between Poverty Lines,
  "dollar10_dollar30_share_of_population_between_poverty_lines" FLOAT  -- Dollar10 Dollar30, Share Of Population Between Poverty Lines,
  "dollar10_dollar30_total_number_of_people_between_poverty_lines" UINTEGER  -- Dollar10 Dollar30, Total Number Of People Between Poverty Lines,
  "dollar2_15_share_of_population_above_poverty_line" FLOAT  -- Dollar2–15, Share Of Population Above Poverty Line,
  "dollar2_15_total_number_of_people_above_poverty_line" BIGINT  -- Dollar2–15, Total Number Of People Above Poverty Line,
  "dollar2_15_total_number_of_people_below_poverty_line" UINTEGER  -- Dollar2–15, Total Number Of People Below Poverty Line,
  "dollar2_15_a_day_poverty_gap_index" FLOAT  -- Dollar2–15 A Day, Poverty Gap Index,
  "dollar2_15_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar2–15 A Day, Share Of Population Below Poverty Line,
  "dollar2_15_a_day_total_shortfall" FLOAT  -- Dollar2–15 A Day, Total Shortfall,
  "dollar2_15_dollar10_share_of_population_between_poverty_lines" FLOAT  -- Dollar2–15 Dollar10, Share Of Population Between Poverty Lines,
  "dollar2_15_dollar10_total_number_of_people_between_pov_40c8c1b7" UINTEGER  -- Dollar2–15 Dollar10, Total Number Of People Between Poverty Lines,
  "dollar2_15_dollar3_65_share_of_population_between_poverty_lines" FLOAT  -- Dollar2–15 Dollar3–65, Share Of Population Between Poverty Lines,
  "dollar2_15_dollar3_65_total_number_of_people_between_p_19723ef2" UINTEGER  -- Dollar2–15 Dollar3–65, Total Number Of People Between Poverty Lines,
  "dollar20_share_of_population_above_poverty_line" FLOAT  -- Dollar20, Share Of Population Above Poverty Line,
  "dollar20_total_number_of_people_above_poverty_line" UINTEGER  -- Dollar20, Total Number Of People Above Poverty Line,
  "dollar20_total_number_of_people_below_poverty_line" BIGINT  -- Dollar20, Total Number Of People Below Poverty Line,
  "dollar20_a_day_poverty_gap_index" FLOAT  -- Dollar20 A Day, Poverty Gap Index,
  "dollar20_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar20 A Day, Share Of Population Below Poverty Line,
  "dollar20_a_day_total_shortfall" FLOAT  -- Dollar20 A Day, Total Shortfall,
  "dollar20_dollar30_share_of_population_between_poverty_lines" FLOAT  -- Dollar20 Dollar30, Share Of Population Between Poverty Lines,
  "dollar20_dollar30_total_number_of_people_between_poverty_lines" UINTEGER  -- Dollar20 Dollar30, Total Number Of People Between Poverty Lines,
  "dollar24_35_share_of_population_above_poverty_line" FLOAT  -- Dollar24–35, Share Of Population Above Poverty Line,
  "dollar24_35_total_number_of_people_above_poverty_line" UINTEGER  -- Dollar24–35, Total Number Of People Above Poverty Line,
  "dollar24_35_total_number_of_people_below_poverty_line" BIGINT  -- Dollar24–35, Total Number Of People Below Poverty Line,
  "dollar24_35_a_day_poverty_gap_index" FLOAT  -- Dollar24–35 A Day, Poverty Gap Index,
  "dollar24_35_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar24–35 A Day, Share Of Population Below Poverty Line,
  "dollar24_35_a_day_total_shortfall" FLOAT  -- Dollar24–35 A Day, Total Shortfall,
  "dollar3_65_share_of_population_above_poverty_line" FLOAT  -- Dollar3–65, Share Of Population Above Poverty Line,
  "dollar3_65_total_number_of_people_above_poverty_line" BIGINT  -- Dollar3–65, Total Number Of People Above Poverty Line,
  "dollar3_65_total_number_of_people_below_poverty_line" UINTEGER  -- Dollar3–65, Total Number Of People Below Poverty Line,
  "dollar3_65_a_day_poverty_gap_index" FLOAT  -- Dollar3–65 A Day, Poverty Gap Index,
  "dollar3_65_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar3–65 A Day, Share Of Population Below Poverty Line,
  "dollar3_65_a_day_total_shortfall" FLOAT  -- Dollar3–65 A Day, Total Shortfall,
  "dollar3_65_dollar6_85_share_of_population_between_poverty_lines" FLOAT  -- Dollar3–65 Dollar6–85, Share Of Population Between Poverty Lines,
  "dollar3_65_dollar6_85_total_number_of_people_between_p_4c861a0c" UINTEGER  -- Dollar3–65 Dollar6–85, Total Number Of People Between Poverty Lines,
  "dollar30_share_of_population_above_poverty_line" FLOAT  -- Dollar30, Share Of Population Above Poverty Line,
  "dollar30_total_number_of_people_above_poverty_line" UINTEGER  -- Dollar30, Total Number Of People Above Poverty Line,
  "dollar30_total_number_of_people_below_poverty_line" BIGINT  -- Dollar30, Total Number Of People Below Poverty Line,
  "dollar30_a_day_poverty_gap_index" FLOAT  -- Dollar30 A Day, Poverty Gap Index,
  "dollar30_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar30 A Day, Share Of Population Below Poverty Line,
  "dollar30_a_day_total_shortfall" FLOAT  -- Dollar30 A Day, Total Shortfall,
  "dollar30_dollar40_share_of_population_between_poverty_lines" FLOAT  -- Dollar30 Dollar40, Share Of Population Between Poverty Lines,
  "dollar30_dollar40_total_number_of_people_between_poverty_lines" UINTEGER  -- Dollar30 Dollar40, Total Number Of People Between Poverty Lines,
  "dollar40_share_of_population_above_poverty_line" FLOAT  -- Dollar40, Share Of Population Above Poverty Line,
  "dollar40_total_number_of_people_above_poverty_line" UINTEGER  -- Dollar40, Total Number Of People Above Poverty Line,
  "dollar40_total_number_of_people_below_poverty_line" BIGINT  -- Dollar40, Total Number Of People Below Poverty Line,
  "dollar40_a_day_poverty_gap_index" FLOAT  -- Dollar40 A Day, Poverty Gap Index,
  "dollar40_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar40 A Day, Share Of Population Below Poverty Line,
  "dollar40_a_day_total_shortfall" FLOAT  -- Dollar40 A Day, Total Shortfall,
  "dollar6_85_share_of_population_above_poverty_line" FLOAT  -- Dollar6–85, Share Of Population Above Poverty Line,
  "dollar6_85_total_number_of_people_above_poverty_line" UINTEGER  -- Dollar6–85, Total Number Of People Above Poverty Line,
  "dollar6_85_total_number_of_people_below_poverty_line" UINTEGER  -- Dollar6–85, Total Number Of People Below Poverty Line,
  "dollar6_85_a_day_poverty_gap_index" FLOAT  -- Dollar6–85 A Day, Poverty Gap Index,
  "dollar6_85_a_day_share_of_population_below_poverty_line" FLOAT  -- Dollar6–85 A Day, Share Of Population Below Poverty Line,
  "dollar6_85_a_day_total_shortfall" FLOAT  -- Dollar6–85 A Day, Total Shortfall,
  "dollar6_85_dollar10_share_of_population_between_poverty_lines" FLOAT  -- Dollar6–85 Dollar10, Share Of Population Between Poverty Lines,
  "dollar6_85_dollar10_total_number_of_people_between_pov_2e4891d5" UINTEGER  -- Dollar6–85 Dollar10, Total Number Of People Between Poverty Lines,
  "n__40pct_of_median_share_of_population_below_poverty_line" FLOAT  -- 40pct Of Median, Share Of Population Below Poverty Line,
  "n__40pct_of_median_total_number_of_people_below_poverty_line" UINTEGER  -- 40pct Of Median, Total Number Of People Below Poverty Line,
  "n__50pct_of_median_share_of_population_below_poverty_line" FLOAT  -- 50pct Of Median, Share Of Population Below Poverty Line,
  "n__50pct_of_median_total_number_of_people_below_poverty_line" UINTEGER  -- 50pct Of Median, Total Number Of People Below Poverty Line,
  "n__60pct_of_median_share_of_population_below_poverty_line" FLOAT  -- 60pct Of Median, Share Of Population Below Poverty Line,
  "n__60pct_of_median_total_number_of_people_below_poverty_line" UINTEGER  -- 60pct Of Median, Total Number Of People Below Poverty Line,
  "gini_coefficient" FLOAT,
  "mean_income_or_expenditure_per_day" FLOAT,
  "median_income_or_expenditure_per_day" FLOAT,
  "p10" FLOAT,
  "p90" FLOAT,
  "share_of_the_2nd_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_3rd_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_4th_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_poorest_quintile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_richest_decile_in_total_income_or_expenditure" FLOAT,
  "share_of_the_richest_quintile_in_total_income_or_expenditure" FLOAT
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_world_bank_pip_2

10.08 MB
662,181 rows
44 columns

CREATE TABLE owid_world_bank_pip_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "poverty_line" VARCHAR,
  "welfare_type" VARCHAR,
  "decile" INTEGER,
  "table" VARCHAR,
  "survey_comparability" VARCHAR,
  "headcount_ratio" FLOAT,
  "poverty_gap_index" FLOAT,
  "poverty_severity" FLOAT,
  "watts" FLOAT,
  "headcount" BIGINT,
  "total_shortfall" FLOAT,
  "avg_shortfall" FLOAT,
  "income_gap_ratio" FLOAT,
  "headcount_above" BIGINT,
  "headcount_ratio_above" FLOAT,
  "headcount_between" UINTEGER,
  "headcount_ratio_between" FLOAT,
  "share" FLOAT,
  "thr" FLOAT,
  "avg" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "bottom50_share" FLOAT,
  "middle40_share" FLOAT,
  "palma_ratio" FLOAT,
  "s80_s20_ratio" FLOAT,
  "p90_p10_ratio" FLOAT,
  "p90_p50_ratio" FLOAT,
  "p50_p10_ratio" FLOAT,
  "top1_thr" FLOAT,
  "top1_share" FLOAT,
  "top1_avg" FLOAT,
  "top90_99_share" FLOAT,
  "surveys_past_decade" INTEGER,
  "region_name" VARCHAR
);

World Bank Poverty And Inequality Platform (PIP): Percentiles

@owid.world_bank_pip.owid_world_bank_pip_3

12.01 MB
781,244 rows
46 columns

CREATE TABLE owid_world_bank_pip_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "poverty_line" VARCHAR,
  "welfare_type" VARCHAR,
  "decile" INTEGER,
  "table" VARCHAR,
  "survey_comparability" VARCHAR,
  "headcount_ratio" FLOAT,
  "poverty_gap_index" FLOAT,
  "poverty_severity" FLOAT,
  "watts" FLOAT,
  "headcount" BIGINT,
  "total_shortfall" FLOAT,
  "avg_shortfall" FLOAT,
  "income_gap_ratio" FLOAT,
  "headcount_above" BIGINT,
  "headcount_ratio_above" FLOAT,
  "headcount_between" UINTEGER,
  "headcount_ratio_between" FLOAT,
  "share" FLOAT,
  "thr" FLOAT,
  "avg" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "cpi" FLOAT,
  "ppp" FLOAT,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "bottom50_share" FLOAT,
  "middle40_share" FLOAT,
  "palma_ratio" FLOAT,
  "s80_s20_ratio" FLOAT,
  "p90_p10_ratio" FLOAT,
  "p90_p50_ratio" FLOAT,
  "p50_p10_ratio" FLOAT,
  "top1_thr" FLOAT,
  "top1_share" FLOAT,
  "top1_avg" FLOAT,
  "top90_99_share" FLOAT,
  "surveys_past_decade" INTEGER,
  "region_name" VARCHAR
);

World Bank Poverty And Inequality Platform (PIP): Regional Definitions

@owid.world_bank_pip.owid_world_bank_pip_4

23.5 MB
1,365,884 rows
46 columns

CREATE TABLE owid_world_bank_pip_4 (
  "country" VARCHAR,
  "year" INTEGER,
  "ppp_version" INTEGER,
  "poverty_line" VARCHAR,
  "welfare_type" VARCHAR,
  "decile" INTEGER,
  "table" VARCHAR,
  "survey_comparability" VARCHAR,
  "headcount_ratio" FLOAT,
  "poverty_gap_index" FLOAT,
  "poverty_severity" FLOAT,
  "watts" FLOAT,
  "headcount" BIGINT,
  "total_shortfall" FLOAT,
  "avg_shortfall" FLOAT,
  "income_gap_ratio" FLOAT,
  "headcount_above" BIGINT,
  "headcount_ratio_above" FLOAT,
  "headcount_between" UINTEGER,
  "headcount_ratio_between" FLOAT,
  "share" FLOAT,
  "thr" FLOAT,
  "avg" FLOAT,
  "mean" FLOAT,
  "median" FLOAT,
  "mld" FLOAT,
  "gini" FLOAT,
  "polarization" FLOAT,
  "cpi" FLOAT,
  "ppp" FLOAT,
  "spl" FLOAT,
  "spr" FLOAT,
  "pg" FLOAT,
  "bottom50_share" FLOAT,
  "middle40_share" FLOAT,
  "palma_ratio" FLOAT,
  "s80_s20_ratio" FLOAT,
  "p90_p10_ratio" FLOAT,
  "p90_p50_ratio" FLOAT,
  "p50_p10_ratio" FLOAT,
  "top1_thr" FLOAT,
  "top1_share" FLOAT,
  "top1_avg" FLOAT,
  "top90_99_share" FLOAT,
  "surveys_past_decade" INTEGER,
  "region_name" VARCHAR
);