About this Dataset

Historical Poverty Estimates (World Bank And Maddison)

This dataset combines modern income distribution data from the World Bank's Poverty and Inequality Platform with historical GDP per capita data from the Maddison Project Database to generate long-run poverty estimates from 1820 to the present.

The methodology extrapolates income distributions backwards from 1990 (when detailed distributional data becomes available) to 1820, using actual historical GDP growth rates to adjust income levels while maintaining the shape of the income distribution.

Tables

1000 Binned Global Distribution

@owid.historical_poverty.owid_comparison

35.55 kB
850 rows
9 columns

CREATE TABLE owid_comparison (
  "country" VARCHAR,
  "year" INTEGER,
  "poverty_line" VARCHAR,
  "diff_quantiles_vs_constant" DOUBLE,
  "diff_ginis_vs_constant" DOUBLE,
  "diff_quantiles_vs_ginis" DOUBLE,
  "diff_random_vs_constant" DOUBLE,
  "diff_random_vs_ginis" FLOAT,
  "diff_random_vs_quantiles" DOUBLE
);

Constant Inequality

@owid.historical_poverty.owid_constant_inequality

68.19 kB
1,030 rows
21 columns

CREATE TABLE owid_constant_inequality (
  "country" VARCHAR,
  "year" INTEGER,
  "poverty_line" VARCHAR,
  "headcount" DOUBLE,
  "headcount_ratio" DOUBLE,
  "headcount_benchmark" DOUBLE,
  "headcount_ratio_benchmark" DOUBLE,
  "headcount_ratio_rolling_avg" DOUBLE,
  "headcount_rolling_avg" DOUBLE,
  "headcount_above" DOUBLE,
  "headcount_ratio_above" DOUBLE,
  "headcount_above_benchmark" DOUBLE,
  "headcount_ratio_above_benchmark" DOUBLE,
  "headcount_above_rolling_avg" DOUBLE,
  "headcount_ratio_above_rolling_avg" DOUBLE,
  "headcount_between" DOUBLE,
  "headcount_ratio_between" DOUBLE,
  "headcount_between_benchmark" DOUBLE,
  "headcount_ratio_between_benchmark" DOUBLE,
  "headcount_between_rolling_avg" DOUBLE,
  "headcount_ratio_between_rolling_avg" DOUBLE
);

Maddison Project Database

@owid.historical_poverty.owid_gini_mean

1.04 MB
36,874 rows
6 columns

CREATE TABLE owid_gini_mean (
  "country" VARCHAR,
  "year" INTEGER,
  "mean" DOUBLE,
  "gini" DOUBLE,
  "gini_random" DOUBLE,
  "mean_benchmark" DOUBLE
);

1000 Binned Global Distribution

@owid.historical_poverty.owid_interpolated_ginis

49.77 kB
1,030 rows
21 columns

CREATE TABLE owid_interpolated_ginis (
  "country" VARCHAR,
  "year" INTEGER,
  "poverty_line" VARCHAR,
  "headcount" FLOAT,
  "headcount_ratio" FLOAT,
  "headcount_benchmark" FLOAT,
  "headcount_ratio_benchmark" FLOAT,
  "headcount_ratio_rolling_avg" DOUBLE,
  "headcount_rolling_avg" DOUBLE,
  "headcount_above" FLOAT,
  "headcount_ratio_above" FLOAT,
  "headcount_above_benchmark" FLOAT,
  "headcount_ratio_above_benchmark" FLOAT,
  "headcount_above_rolling_avg" DOUBLE,
  "headcount_ratio_above_rolling_avg" DOUBLE,
  "headcount_between" FLOAT,
  "headcount_ratio_between" FLOAT,
  "headcount_between_benchmark" FLOAT,
  "headcount_ratio_between_benchmark" FLOAT,
  "headcount_between_rolling_avg" DOUBLE,
  "headcount_ratio_between_rolling_avg" DOUBLE
);

1000 Binned Global Distribution

@owid.historical_poverty.owid_interpolated_quantiles

68.19 kB
1,030 rows
21 columns

CREATE TABLE owid_interpolated_quantiles (
  "country" VARCHAR,
  "year" INTEGER,
  "poverty_line" VARCHAR,
  "headcount" DOUBLE,
  "headcount_ratio" DOUBLE,
  "headcount_benchmark" DOUBLE,
  "headcount_ratio_benchmark" DOUBLE,
  "headcount_ratio_rolling_avg" DOUBLE,
  "headcount_rolling_avg" DOUBLE,
  "headcount_above" DOUBLE,
  "headcount_ratio_above" DOUBLE,
  "headcount_above_benchmark" DOUBLE,
  "headcount_ratio_above_benchmark" DOUBLE,
  "headcount_above_rolling_avg" DOUBLE,
  "headcount_ratio_above_rolling_avg" DOUBLE,
  "headcount_between" DOUBLE,
  "headcount_ratio_between" DOUBLE,
  "headcount_between_benchmark" DOUBLE,
  "headcount_ratio_between_benchmark" DOUBLE,
  "headcount_between_rolling_avg" DOUBLE,
  "headcount_ratio_between_rolling_avg" DOUBLE
);

Population Constant Inequality

@owid.historical_poverty.owid_population_constant_inequality

15.98 kB
206 rows
7 columns

CREATE TABLE owid_population_constant_inequality (
  "country" VARCHAR,
  "year" INTEGER,
  "population" DOUBLE,
  "population_omm" DOUBLE,
  "population_diff" DOUBLE,
  "population_diff_pct" DOUBLE,
  "population_share_of_omm" DOUBLE
);

1000 Binned Global Distribution

@owid.historical_poverty.owid_population_interpolated_ginis

14.71 kB
206 rows
7 columns

CREATE TABLE owid_population_interpolated_ginis (
  "country" VARCHAR,
  "year" INTEGER,
  "population" FLOAT,
  "population_omm" DOUBLE,
  "population_diff" DOUBLE,
  "population_diff_pct" DOUBLE,
  "population_share_of_omm" DOUBLE
);

1000 Binned Global Distribution

@owid.historical_poverty.owid_population_interpolated_quantiles

15.98 kB
206 rows
7 columns

CREATE TABLE owid_population_interpolated_quantiles (
  "country" VARCHAR,
  "year" INTEGER,
  "population" DOUBLE,
  "population_omm" DOUBLE,
  "population_diff" DOUBLE,
  "population_diff_pct" DOUBLE,
  "population_share_of_omm" DOUBLE
);

1000 Binned Global Distribution

@owid.historical_poverty.owid_randomized_ginis

52 kB
1,030 rows
22 columns

CREATE TABLE owid_randomized_ginis (
  "country" VARCHAR,
  "year" INTEGER,
  "poverty_line" VARCHAR,
  "population" FLOAT,
  "headcount" FLOAT,
  "headcount_ratio" FLOAT,
  "headcount_benchmark" FLOAT,
  "headcount_ratio_benchmark" FLOAT,
  "headcount_ratio_rolling_avg" DOUBLE,
  "headcount_rolling_avg" DOUBLE,
  "headcount_above" FLOAT,
  "headcount_ratio_above" FLOAT,
  "headcount_above_benchmark" FLOAT,
  "headcount_ratio_above_benchmark" FLOAT,
  "headcount_above_rolling_avg" DOUBLE,
  "headcount_ratio_above_rolling_avg" DOUBLE,
  "headcount_between" FLOAT,
  "headcount_ratio_between" FLOAT,
  "headcount_between_benchmark" FLOAT,
  "headcount_ratio_between_benchmark" FLOAT,
  "headcount_between_rolling_avg" DOUBLE,
  "headcount_ratio_between_rolling_avg" DOUBLE
);

1000 Binned Global Distribution

@owid.historical_poverty.owid_thousand_bins_interpolated_ginis

228.95 MB
36,408,000 rows
7 columns

CREATE TABLE owid_thousand_bins_interpolated_ginis (
  "country" VARCHAR,
  "year" INTEGER,
  "region" VARCHAR,
  "region_old" VARCHAR,
  "quantile" INTEGER,
  "avg" FLOAT,
  "pop" FLOAT
);

Thousand Bins Interpolated Ginis All Lognormal

@owid.historical_poverty.owid_thousand_bins_interpolated_ginis_all_lognormal

217.87 MB
34,608,000 rows
7 columns

CREATE TABLE owid_thousand_bins_interpolated_ginis_all_lognormal (
  "country" VARCHAR,
  "year" INTEGER,
  "region" VARCHAR,
  "region_old" VARCHAR,
  "quantile" INTEGER,
  "avg" FLOAT,
  "pop" FLOAT
);