Name: Threshold Income
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Threshold Income

in Data
Browse by topic
Latest
Resources
About

Search for a topic, chart or article...

Donate
Incomes Across the Distribution - Luxembourg Income Study Data Explorer
Explore Luxembourg Income Study data on the distribution of incomes.
Indicator
Decile thresholds
Decile
9 (richest)
Income measure
After tax
Period
Day
Month
Year
Adjust for cost sharing within households (equivalized income)
Done
Type to add a country or region...
Customize chart
Threshold income per year marking the richest decile (after tax), 2022
The level of income per year below which 90% of the population falls. Income here is measured after taxes and benefits.

World
No data
$0
$10,000
$20,000
$50,000
$100,000

Play time-lapse
Data source: Luxembourg Income Study (2024) – Learn more about this data

Note: This data is measured in international-$ at 2017 prices to account for inflation and differences in the cost of living between countries.

CC BY

Richest decile (after tax)
The level of income per year below which 90% of the population falls.

Income is ‘post-tax’ — measured after taxes have been paid and most government benefits have been received.

Income is per capita, which means that household income is divided by the total number of household members.

The data is measured in international-$ at 2017 prices – this adjusts for inflation and for differences in the cost of living between countries.

NOTES ON HOW WE PROCESSED THIS INDICATOR

We create the Luxembourg Income Study data from standardized household survey microdata available in their LISSY platform. The estimations follow the methodology available in LIS, Key Figures and DART platform.

We obtain after tax income by using the disposable household income variable (dhi).

We estimate before tax income by calculating the sum of income from labor and capital (variable hifactor), cash transfers and in-kind goods and services from privates (hiprivate) and private pensions (hi33). We do this only for surveys where tax and contributions are fully captured, collected or imputed.

We convert income data from local currency into international-$ by dividing by the LIS PPP factor, available as an additional database in the LISSY platform.

We top and bottom-code incomes by replacing negative values with zeros and setting boundaries for extreme values of log income: at the top Q3 plus 3 times the interquartile range (Q3-Q1), and at the bottom Q1 minus 3 times the interquartile range.

We equivalize incomes by dividing each household observation by the square root of the number of household members (nhhmem). Per capita estimates are calculated by dividing incomes by the number of household members.

Income shares and thresholds by decile are obtained by using Stata’s sumdist function. We set weights as the product between the number of household members (nhhmem) and the normalized household weight (hwgt) and the number of quantile groups as 10. We estimate threshold ratios, share ratios and averages by decile in Python after processing in the LISSY platform.

Source
Luxembourg Income Study (2024) – processed by Our World in Data.

Tables

Incomes Across Distribution Lis

@kaggle.willianoliveiragibin_threshold_income.incomes_across_distribution_lis

4.08 MB
881 rows
726 columns


CREATE TABLE incomes_across_distribution_lis (
  "country" VARCHAR,
  "year" BIGINT,
  "mean_income_after_tax" DOUBLE,
  "median_income_after_tax" DOUBLE,
  "poorest_decile_after_tax" DOUBLE,
  "n_2nd_decile_after_tax" DOUBLE,
  "n_3rd_decile_after_tax" DOUBLE,
  "n_4th_decile_after_tax" DOUBLE,
  "n_5th_decile_median_after_tax" DOUBLE,
  "n_6th_decile_after_tax" DOUBLE,
  "n_7th_decile_after_tax" DOUBLE,
  "n_8th_decile_after_tax" DOUBLE,
  "richest_decile_after_tax" DOUBLE,
  "poorest_decile_after_tax_1" DOUBLE,
  "n_2nd_decile_after_tax_1" DOUBLE,
  "n_3rd_decile_after_tax_1" DOUBLE,
  "n_4th_decile_after_tax_1" DOUBLE,
  "n_5th_decile_after_tax" DOUBLE,
  "n_6th_decile_after_tax_1" DOUBLE,
  "n_7th_decile_after_tax_1" DOUBLE,
  "n_8th_decile_after_tax_1" DOUBLE,
  "n_9th_decile_after_tax" DOUBLE,
  "richest_decile_after_tax_1" DOUBLE,
  "poorest_decile_after_tax_2" DOUBLE,
  "n_2nd_decile_after_tax_2" DOUBLE,
  "n_3rd_decile_after_tax_2" DOUBLE,
  "n_4th_decile_after_tax_2" DOUBLE,
  "n_5th_decile_after_tax_1" DOUBLE,
  "n_6th_decile_after_tax_2" DOUBLE,
  "n_7th_decile_after_tax_2" DOUBLE,
  "n_8th_decile_after_tax_2" DOUBLE,
  "n_9th_decile_after_tax_1" DOUBLE,
  "richest_decile_after_tax_2" DOUBLE,
  "mean_income_after_tax_1" DOUBLE,
  "median_income_after_tax_1" DOUBLE,
  "poorest_decile_after_tax_3" DOUBLE,
  "n_2nd_decile_after_tax_3" DOUBLE,
  "n_3rd_decile_after_tax_3" DOUBLE,
  "n_4th_decile_after_tax_3" DOUBLE,
  "n_5th_decile_median_after_tax_1" DOUBLE,
  "n_6th_decile_after_tax_3" DOUBLE,
  "n_7th_decile_after_tax_3" DOUBLE,
  "n_8th_decile_after_tax_3" DOUBLE,
  "richest_decile_after_tax_3" DOUBLE,
  "poorest_decile_after_tax_4" DOUBLE,
  "n_2nd_decile_after_tax_4" DOUBLE,
  "n_3rd_decile_after_tax_4" DOUBLE,
  "n_4th_decile_after_tax_4" DOUBLE,
  "n_5th_decile_after_tax_2" DOUBLE,
  "n_6th_decile_after_tax_4" DOUBLE,
  "n_7th_decile_after_tax_4" DOUBLE,
  "n_8th_decile_after_tax_4" DOUBLE,
  "n_9th_decile_after_tax_2" DOUBLE,
  "richest_decile_after_tax_4" DOUBLE,
  "mean_income_after_tax_2" DOUBLE,
  "median_income_after_tax_2" DOUBLE,
  "poorest_decile_after_tax_5" DOUBLE,
  "n_2nd_decile_after_tax_5" DOUBLE,
  "n_3rd_decile_after_tax_5" DOUBLE,
  "n_4th_decile_after_tax_5" DOUBLE,
  "n_5th_decile_median_after_tax_2" DOUBLE,
  "n_6th_decile_after_tax_5" DOUBLE,
  "n_7th_decile_after_tax_5" DOUBLE,
  "n_8th_decile_after_tax_5" DOUBLE,
  "richest_decile_after_tax_5" DOUBLE,
  "poorest_decile_after_tax_6" DOUBLE,
  "n_2nd_decile_after_tax_6" DOUBLE,
  "n_3rd_decile_after_tax_6" DOUBLE,
  "n_4th_decile_after_tax_6" DOUBLE,
  "n_5th_decile_after_tax_3" DOUBLE,
  "n_6th_decile_after_tax_6" DOUBLE,
  "n_7th_decile_after_tax_6" DOUBLE,
  "n_8th_decile_after_tax_6" DOUBLE,
  "n_9th_decile_after_tax_3" DOUBLE,
  "richest_decile_after_tax_6" DOUBLE,
  "mean_income_after_tax_3" DOUBLE,
  "median_income_after_tax_3" DOUBLE,
  "poorest_decile_after_tax_7" DOUBLE,
  "n_2nd_decile_after_tax_7" DOUBLE,
  "n_3rd_decile_after_tax_7" DOUBLE,
  "n_4th_decile_after_tax_7" DOUBLE,
  "n_5th_decile_median_after_tax_3" DOUBLE,
  "n_6th_decile_after_tax_7" DOUBLE,
  "n_7th_decile_after_tax_7" DOUBLE,
  "n_8th_decile_after_tax_7" DOUBLE,
  "richest_decile_after_tax_7" DOUBLE,
  "poorest_decile_after_tax_8" DOUBLE,
  "n_2nd_decile_after_tax_8" DOUBLE,
  "n_3rd_decile_after_tax_8" DOUBLE,
  "n_4th_decile_after_tax_8" DOUBLE,
  "n_5th_decile_after_tax_4" DOUBLE,
  "n_6th_decile_after_tax_8" DOUBLE,
  "n_7th_decile_after_tax_8" DOUBLE,
  "n_8th_decile_after_tax_8" DOUBLE,
  "n_9th_decile_after_tax_4" DOUBLE,
  "richest_decile_after_tax_8" DOUBLE,
  "mean_income_after_tax_4" DOUBLE,
  "median_income_after_tax_4" DOUBLE,
  "poorest_decile_after_tax_9" DOUBLE,
  "n_2nd_decile_after_tax_9" DOUBLE
);