Name: World Inequality Database (WID, 2023)
Creator: Our World In Data
License: https://creativecommons.org/publicdomain/

About this Dataset

World Inequality Database (WID, 2023)

The World Inequality Database (WID) is an extensive database on the distribution of income and wealth, both between and within countries. It is primarily maintained by the World Inequality Lab (WIL), located at the Paris School of Economics (PSE). But it is fundamentally the result of a coordinated, collaborative effort involving hundreds of researchers throughout the world over the past twenty years.

In recent years, the WIL has been leading efforts in creating “distributional national accounts” (DINA). The goal is to provide estimates of the distribution of income and wealth that are harmonized over time and across countries, that are consistent with the macroeconomic aggregates produced by national statistical institutes, and that can therefore be viewed as a distributional extension of the existing international System of National Accounts (SNA).

The WID provides extensive data on the distribution of pretax income, post-tax income and wealth, on top of a detailed decomposition of macroeconomic aggregates of income and wealth. This dataset uploaded to Our World in Data contains pretax income data only.

WID seeks to distribute the entirety of national income among resident households (including all income flowing to corporations, the government, and to and from the foreign sector). In this way it accounts for 100% of macroeconomic growth coming from GDP statistics. WID also presents results for numerous concepts across granular percentile groups reaching small fractiles at the very top of the distribution.

WID CONVENTIONS
Unit of observation

“Equal-split adults” series, which distribute income to all adult individuals (over 20 years old), while splitting income equally within a couple or a household. It is the benchmark series to deal with the lack of homogeneity in the unit of observation for tax records. Equal-split series can be split income and wealth within the couple (narrow equal-split) or within the household (broad equal-split). For now, DINA series have relied on narrow equal-split measures in countries that primarily rely on tax microdata (France, United States), and broad equal-split in countries that rely more heavily on surveys (China). This should be kept in mind when making comparisons between countries. Moving forward, whenever the data allow, researchers should try to provide both series.

Equivalence scales

The DINA project does not use equivalence scales for two reasons. The first one is practical. Equivalence scales introduces nonlinearities that make it harder to connect aggregate levels of income and wealth with their distribution. If equivalized income is attributed to each individual, then the sum of all incomes across all individuals no longer sums up to aggregate income. Equivalence scales therefore prevent from cleanly breaking down national income and its growth across population groups. In WID’s view, it negatively impacts the readability and ease of use of indicators, and somewhat defeats the purpose of connecting micro and macroeconomic estimates in the first place. The second reason is conceptual. The primary aim of DINA is to measure income, wealth and their distribution. In contrast, equivalence scales are meant to approximate an individual “welfare” concept. While this distribution of “welfare” is related to income and wealth, it also incorporates many other dimensions that are outside of the project’s scope. Indeed, the DINA project does not explicitly attempt to measure how well the income of individuals suits their needs — which depend not only on their household’s size, but also on their location, their tastes, their health status, etc., all of which are partly endogenous to distribution of income and wealth themselves.

Price index

WID uses the GDP deflator as its preferred price index, following Piketty and Zucman (2014), although it resorts to the CPI when no other data is available. WID calls it the national income price index, and use it to deflate all the monetary series. Over long periods of time, comparing quantities that are independent of the price level (wealth/income ratios, share) can be more informative. Comparing income or wealth levels between time periods that are centuries apart is fraught with conceptual difficulties, and it could be argued that such comparisons do not always make sense. While WID provides some price indexes over very long time periods for convenience, users should be aware of these issues.

Purchasing power parities

Though a large number of indicators provided by the WID (such as the share of income received by various groups) are not sensitive to the overall price level, WID provides purchasing power parities (PPPs) to convert the local currency units provided by default in averages and thresholds. This dataset uses 2017 PPPs to account for inflation and for differences in the cost of living between countries. Regional aggregations provided by WID are by default using PPPs and also include market exchange rates conversions, but they are dropped for this dataset.

Measures of the distribution

In WID’s view, to focus on a single indicator — for example the well-known Gini coefficient — is not sufficient to provide an adequate picture of inequality. WID stresses that the problem is not specifically about the Gini, or about any other indicator. The problem is that inequality cannot be reduced to a single number. This is why they prefer to describe distributions in their entirety, and then let users use whatever level of detail and whatever indicator suits their needs. In terms of presenting the results, WID favors showing the income shares of three main groups (the bottom 50%, the middle 40% and the top 10%). These three groups map relatively well to the idea of a lower, middle and upper class. They summarize changes happening to the overall distribution fairly well. In practice, synthetic indicators can be approximated quite precisely by a weighted average of these three shares. WID also emphasizes using the very top groups (top 1%, top 0.1%, etc.) since they can represent a macroeconomically significant share of income and wealth. Gini coefficients are provided in the database as a convenience but encourage users to look further. WID provides distributional data by generating synthetic microfiles (synthetic microdata representative of the distribution of income and wealth for the entire population) and summarizing it in generalized percentiles, which are series with thresholds, averages and shares for 127 fractiles:

• 99 percentiles from p = 0% to p = 99%,
• 9 tenths of a percentile from p = 99% to p = 99.9%,
• 9 hundredths of a percentile from p = 99.9% to p = 99.99%,
• 10 thousandths of a percentile from p = 99.99% to p = 100%.

INCOME CONCEPTS
Income series

DINA income series distribute the entirety of net national income using concepts that are consistent with the SNA. Therefore, they include certain types of income (like the undistributed profits of corporations or indirect taxes) that are traditionally overlooked by other sources.
WID defines four broad types of series:
• Pretax factor corresponds to the distribution of income before any redistribution, be it through social insurance systems of social assistance.
• Pretax post-replacement income (often referred to as “pretax income”) includes redistribution that occurs through social insurance schemes (pension and sometimes unemployment benefits), but not social assistance. The main difference with pretax factor income and is the treatment of pensions, which are counted on a contribution basis by pretax factor income and on a distribution basis by pretax national income. The key reason “pretax national income” series is preferred is that it is less sensitive than pretax factor income inequality to the age structure of the population.
• Post-tax disposable income includes all cash redistribution through the tax and transfer system, but does not include in-kind benefits and therefore does not add up to national income.
• Finally, post-tax national income redistributes all in-kind transfers (i.e., government consumption expenditures) to individuals.

Undistributed profits

The undistributed profits of corporations are distributed to the shareholders of these corporations. Direct taxes and benefits are distributed to the people that pay the tax or receive the benefit. The corporate tax is paid by the shareholders. Sales taxes and VATs are distributed proportionally to factor income for pretax concepts, and are removed proportionally to consumption in post-tax concepts.

In-kind transfers

For in-kind transfers, three variants are considered: allocation proportional to post-tax disposable income, lump-sum allocation, and proportional allocation except for health spending which we distribute lump sum. That last concept is used as WID’s benchmark for post-tax national income.

INCOME DISTRIBUTION METHODS
When there is exhaustive tax microdata

Preferably, to compute income DINA, WID constructs microfiles that combine information from both tax and survey data. In countries with sufficiently exhaustive tax microdata, they only start from these files, and use survey data to add information about non-filers and certain tax-exempt incomes. To produce a representative dataset, WID recommends using population statistics to impute observations along characteristics such as age, marital status, gender and possibly region of residence. This is important as certain population groups may not be represented equally in income tax statistics (pensioners and young persons: small taxable incomes).

When tax data is limited
In countries where the tax data is too limited (because they only provide tax tabulations or because the informal sector is too large), WID uses the tax data to correct the surveys at the top using the approach of Blanchet, Flores, and Morgan (2019). The motive for doing so is that surveys tend to underrepresent high incomes as compared to what appears in register data. This is even more true when the survey has not been matched to administrative records (e.g., social security data on wages). The arbitrary brackets used in tax tabulations are interpolated using the generalized Pareto interpolation method, known as gpinter, which allows the distribution to have a flexible form.
The method to incorporate tax information into surveys has three stages:
• The choice of the merging point: the highest income where the ratio of the density functions of both survey and tax records coincides with the respective ratio of cumulative density functions.
• The reweighting of survey observations above and below this point: below are uniformly reweighted (assuming relative probability of response constant over this part of the distribution)
• The expansion of the survey’s support by including the highest incomes from tax data: after the merging point the survey distribution is replaced by the tax distribution

Finally, income components are rescaled to SNA aggregates. Several levels of aggregation may be used depending on the quality and the precision of the data.

More information is available at https://wid.world/methodology/

Tables

World Inequality Database 1

@owid.world_inequality_database.owid_world_inequality_database_1

7.21 MB
9927 rows
450 columns


CREATE TABLE owid_world_inequality_database_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "p0p100_gini_pretax" FLOAT,
  "p0p100_gini_posttax_dis" FLOAT,
  "p0p100_gini_posttax_nat" FLOAT,
  "p0p100_gini_wealth" FLOAT,
  "palma_ratio_pretax" FLOAT,
  "s80_s20_ratio_pretax" FLOAT,
  "p90_p10_ratio_pretax" FLOAT,
  "p90_p50_ratio_pretax" FLOAT,
  "p50_p10_ratio_pretax" FLOAT,
  "palma_ratio_posttax_dis" FLOAT,
  "s80_s20_ratio_posttax_dis" FLOAT,
  "p90_p10_ratio_posttax_dis" FLOAT,
  "p90_p50_ratio_posttax_dis" FLOAT,
  "p50_p10_ratio_posttax_dis" FLOAT,
  "palma_ratio_posttax_nat" FLOAT,
  "s80_s20_ratio_posttax_nat" FLOAT,
  "p90_p10_ratio_posttax_nat" FLOAT,
  "p90_p50_ratio_posttax_nat" FLOAT,
  "p50_p10_ratio_posttax_nat" FLOAT,
  "palma_ratio_wealth" FLOAT,
  "s80_s20_ratio_wealth" FLOAT,
  "p90_p10_ratio_wealth" FLOAT,
  "p90_p50_ratio_wealth" FLOAT,
  "p50_p10_ratio_wealth" FLOAT,
  "p0p10_share_pretax" FLOAT,
  "p0p50_share_pretax" FLOAT,
  "p10p20_share_pretax" FLOAT,
  "p20p30_share_pretax" FLOAT,
  "p30p40_share_pretax" FLOAT,
  "p40p50_share_pretax" FLOAT,
  "p50p60_share_pretax" FLOAT,
  "p60p70_share_pretax" FLOAT,
  "p70p80_share_pretax" FLOAT,
  "p80p90_share_pretax" FLOAT,
  "p90p100_share_pretax" FLOAT,
  "p99_999p100_share_pretax" FLOAT,
  "p99_99p100_share_pretax" FLOAT,
  "p99_9p100_share_pretax" FLOAT,
  "p99p100_share_pretax" FLOAT,
  "p90p99_share_pretax" FLOAT,
  "p50p90_share_pretax" FLOAT,
  "p0p10_share_posttax_dis" FLOAT,
  "p0p50_share_posttax_dis" FLOAT,
  "p10p20_share_posttax_dis" FLOAT,
  "p20p30_share_posttax_dis" FLOAT,
  "p30p40_share_posttax_dis" FLOAT,
  "p40p50_share_posttax_dis" FLOAT,
  "p50p60_share_posttax_dis" FLOAT,
  "p60p70_share_posttax_dis" FLOAT,
  "p70p80_share_posttax_dis" FLOAT,
  "p80p90_share_posttax_dis" FLOAT,
  "p90p100_share_posttax_dis" FLOAT,
  "p99_999p100_share_posttax_dis" FLOAT,
  "p99_99p100_share_posttax_dis" FLOAT,
  "p99_9p100_share_posttax_dis" FLOAT,
  "p99p100_share_posttax_dis" FLOAT,
  "p90p99_share_posttax_dis" FLOAT,
  "p50p90_share_posttax_dis" FLOAT,
  "p0p10_share_posttax_nat" FLOAT,
  "p0p50_share_posttax_nat" FLOAT,
  "p10p20_share_posttax_nat" FLOAT,
  "p20p30_share_posttax_nat" FLOAT,
  "p30p40_share_posttax_nat" FLOAT,
  "p40p50_share_posttax_nat" FLOAT,
  "p50p60_share_posttax_nat" FLOAT,
  "p60p70_share_posttax_nat" FLOAT,
  "p70p80_share_posttax_nat" FLOAT,
  "p80p90_share_posttax_nat" FLOAT,
  "p90p100_share_posttax_nat" FLOAT,
  "p99_999p100_share_posttax_nat" FLOAT,
  "p99_99p100_share_posttax_nat" FLOAT,
  "p99_9p100_share_posttax_nat" FLOAT,
  "p99p100_share_posttax_nat" FLOAT,
  "p90p99_share_posttax_nat" FLOAT,
  "p50p90_share_posttax_nat" FLOAT,
  "p0p10_share_wealth" FLOAT,
  "p0p50_share_wealth" FLOAT,
  "p10p20_share_wealth" FLOAT,
  "p20p30_share_wealth" FLOAT,
  "p30p40_share_wealth" FLOAT,
  "p40p50_share_wealth" FLOAT,
  "p50p60_share_wealth" FLOAT,
  "p60p70_share_wealth" FLOAT,
  "p70p80_share_wealth" FLOAT,
  "p80p90_share_wealth" FLOAT,
  "p90p100_share_wealth" FLOAT,
  "p99_999p100_share_wealth" FLOAT,
  "p99_99p100_share_wealth" FLOAT,
  "p99_9p100_share_wealth" FLOAT,
  "p99p100_share_wealth" FLOAT,
  "p90p99_share_wealth" FLOAT,
  "p50p90_share_wealth" FLOAT,
  "p0p100_avg_pretax" FLOAT,
  "p0p10_avg_pretax" FLOAT,
  "p10p20_avg_pretax" FLOAT,
  "p20p30_avg_pretax" FLOAT,
  "p30p40_avg_pretax" FLOAT,
  "p40p50_avg_pretax" FLOAT
);

World Inequality Database (WID)

@owid.world_inequality_database.owid_world_inequality_database_2

11.77 MB
11886 rows
450 columns


CREATE TABLE owid_world_inequality_database_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "p0p100_gini_pretax" FLOAT,
  "p0p100_gini_posttax_dis" FLOAT,
  "p0p100_gini_posttax_nat" FLOAT,
  "p0p100_gini_wealth" FLOAT,
  "palma_ratio_pretax" FLOAT,
  "s80_s20_ratio_pretax" FLOAT,
  "p90_p10_ratio_pretax" FLOAT,
  "p90_p50_ratio_pretax" FLOAT,
  "p50_p10_ratio_pretax" FLOAT,
  "palma_ratio_posttax_dis" FLOAT,
  "s80_s20_ratio_posttax_dis" FLOAT,
  "p90_p10_ratio_posttax_dis" FLOAT,
  "p90_p50_ratio_posttax_dis" FLOAT,
  "p50_p10_ratio_posttax_dis" FLOAT,
  "palma_ratio_posttax_nat" FLOAT,
  "s80_s20_ratio_posttax_nat" FLOAT,
  "p90_p10_ratio_posttax_nat" FLOAT,
  "p90_p50_ratio_posttax_nat" FLOAT,
  "p50_p10_ratio_posttax_nat" FLOAT,
  "palma_ratio_wealth" FLOAT,
  "s80_s20_ratio_wealth" FLOAT,
  "p90_p10_ratio_wealth" FLOAT,
  "p90_p50_ratio_wealth" FLOAT,
  "p50_p10_ratio_wealth" FLOAT,
  "p0p10_share_pretax" FLOAT,
  "p0p50_share_pretax" FLOAT,
  "p10p20_share_pretax" FLOAT,
  "p20p30_share_pretax" FLOAT,
  "p30p40_share_pretax" FLOAT,
  "p40p50_share_pretax" FLOAT,
  "p50p60_share_pretax" FLOAT,
  "p60p70_share_pretax" FLOAT,
  "p70p80_share_pretax" FLOAT,
  "p80p90_share_pretax" FLOAT,
  "p90p100_share_pretax" FLOAT,
  "p99_999p100_share_pretax" FLOAT,
  "p99_99p100_share_pretax" FLOAT,
  "p99_9p100_share_pretax" FLOAT,
  "p99p100_share_pretax" FLOAT,
  "p90p99_share_pretax" FLOAT,
  "p50p90_share_pretax" FLOAT,
  "p0p10_share_posttax_dis" FLOAT,
  "p0p50_share_posttax_dis" FLOAT,
  "p10p20_share_posttax_dis" FLOAT,
  "p20p30_share_posttax_dis" FLOAT,
  "p30p40_share_posttax_dis" FLOAT,
  "p40p50_share_posttax_dis" FLOAT,
  "p50p60_share_posttax_dis" FLOAT,
  "p60p70_share_posttax_dis" FLOAT,
  "p70p80_share_posttax_dis" FLOAT,
  "p80p90_share_posttax_dis" FLOAT,
  "p90p100_share_posttax_dis" FLOAT,
  "p99_999p100_share_posttax_dis" FLOAT,
  "p99_99p100_share_posttax_dis" FLOAT,
  "p99_9p100_share_posttax_dis" FLOAT,
  "p99p100_share_posttax_dis" FLOAT,
  "p90p99_share_posttax_dis" FLOAT,
  "p50p90_share_posttax_dis" FLOAT,
  "p0p10_share_posttax_nat" FLOAT,
  "p0p50_share_posttax_nat" FLOAT,
  "p10p20_share_posttax_nat" FLOAT,
  "p20p30_share_posttax_nat" FLOAT,
  "p30p40_share_posttax_nat" FLOAT,
  "p40p50_share_posttax_nat" FLOAT,
  "p50p60_share_posttax_nat" FLOAT,
  "p60p70_share_posttax_nat" FLOAT,
  "p70p80_share_posttax_nat" FLOAT,
  "p80p90_share_posttax_nat" FLOAT,
  "p90p100_share_posttax_nat" FLOAT,
  "p99_999p100_share_posttax_nat" FLOAT,
  "p99_99p100_share_posttax_nat" FLOAT,
  "p99_9p100_share_posttax_nat" FLOAT,
  "p99p100_share_posttax_nat" FLOAT,
  "p90p99_share_posttax_nat" FLOAT,
  "p50p90_share_posttax_nat" FLOAT,
  "p0p10_share_wealth" FLOAT,
  "p0p50_share_wealth" FLOAT,
  "p10p20_share_wealth" FLOAT,
  "p20p30_share_wealth" FLOAT,
  "p30p40_share_wealth" FLOAT,
  "p40p50_share_wealth" FLOAT,
  "p50p60_share_wealth" FLOAT,
  "p60p70_share_wealth" FLOAT,
  "p70p80_share_wealth" FLOAT,
  "p80p90_share_wealth" FLOAT,
  "p90p100_share_wealth" FLOAT,
  "p99_999p100_share_wealth" FLOAT,
  "p99_99p100_share_wealth" FLOAT,
  "p99_9p100_share_wealth" FLOAT,
  "p99p100_share_wealth" FLOAT,
  "p90p99_share_wealth" FLOAT,
  "p50p90_share_wealth" FLOAT,
  "p0p100_avg_pretax" FLOAT,
  "p0p10_avg_pretax" FLOAT,
  "p10p20_avg_pretax" FLOAT,
  "p20p30_avg_pretax" FLOAT,
  "p30p40_avg_pretax" FLOAT,
  "p40p50_avg_pretax" FLOAT
);

World Inequality Database (WID)

@owid.world_inequality_database.owid_world_inequality_database_3

12.51 MB
11528 rows
450 columns


CREATE TABLE owid_world_inequality_database_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "p0p100_gini_pretax" FLOAT,
  "p0p100_gini_posttax_dis" FLOAT,
  "p0p100_gini_posttax_nat" FLOAT,
  "p0p100_gini_wealth" FLOAT,
  "palma_ratio_pretax" FLOAT,
  "s80_s20_ratio_pretax" FLOAT,
  "p90_p10_ratio_pretax" FLOAT,
  "p90_p50_ratio_pretax" FLOAT,
  "p50_p10_ratio_pretax" FLOAT,
  "palma_ratio_posttax_dis" FLOAT,
  "s80_s20_ratio_posttax_dis" FLOAT,
  "p90_p10_ratio_posttax_dis" FLOAT,
  "p90_p50_ratio_posttax_dis" FLOAT,
  "p50_p10_ratio_posttax_dis" FLOAT,
  "palma_ratio_posttax_nat" FLOAT,
  "s80_s20_ratio_posttax_nat" FLOAT,
  "p90_p10_ratio_posttax_nat" FLOAT,
  "p90_p50_ratio_posttax_nat" FLOAT,
  "p50_p10_ratio_posttax_nat" FLOAT,
  "palma_ratio_wealth" FLOAT,
  "s80_s20_ratio_wealth" FLOAT,
  "p90_p10_ratio_wealth" FLOAT,
  "p90_p50_ratio_wealth" FLOAT,
  "p50_p10_ratio_wealth" FLOAT,
  "p0p10_share_pretax" FLOAT,
  "p0p50_share_pretax" FLOAT,
  "p10p20_share_pretax" FLOAT,
  "p20p30_share_pretax" FLOAT,
  "p30p40_share_pretax" FLOAT,
  "p40p50_share_pretax" FLOAT,
  "p50p60_share_pretax" FLOAT,
  "p60p70_share_pretax" FLOAT,
  "p70p80_share_pretax" FLOAT,
  "p80p90_share_pretax" FLOAT,
  "p90p100_share_pretax" FLOAT,
  "p99_999p100_share_pretax" FLOAT,
  "p99_99p100_share_pretax" FLOAT,
  "p99_9p100_share_pretax" FLOAT,
  "p99p100_share_pretax" FLOAT,
  "p90p99_share_pretax" FLOAT,
  "p50p90_share_pretax" FLOAT,
  "p0p10_share_posttax_dis" FLOAT,
  "p0p50_share_posttax_dis" FLOAT,
  "p10p20_share_posttax_dis" FLOAT,
  "p20p30_share_posttax_dis" FLOAT,
  "p30p40_share_posttax_dis" FLOAT,
  "p40p50_share_posttax_dis" FLOAT,
  "p50p60_share_posttax_dis" FLOAT,
  "p60p70_share_posttax_dis" FLOAT,
  "p70p80_share_posttax_dis" FLOAT,
  "p80p90_share_posttax_dis" FLOAT,
  "p90p100_share_posttax_dis" FLOAT,
  "p99_999p100_share_posttax_dis" FLOAT,
  "p99_99p100_share_posttax_dis" FLOAT,
  "p99_9p100_share_posttax_dis" FLOAT,
  "p99p100_share_posttax_dis" FLOAT,
  "p90p99_share_posttax_dis" FLOAT,
  "p50p90_share_posttax_dis" FLOAT,
  "p0p10_share_posttax_nat" FLOAT,
  "p0p50_share_posttax_nat" FLOAT,
  "p10p20_share_posttax_nat" FLOAT,
  "p20p30_share_posttax_nat" FLOAT,
  "p30p40_share_posttax_nat" FLOAT,
  "p40p50_share_posttax_nat" FLOAT,
  "p50p60_share_posttax_nat" FLOAT,
  "p60p70_share_posttax_nat" FLOAT,
  "p70p80_share_posttax_nat" FLOAT,
  "p80p90_share_posttax_nat" FLOAT,
  "p90p100_share_posttax_nat" FLOAT,
  "p99_999p100_share_posttax_nat" FLOAT,
  "p99_99p100_share_posttax_nat" FLOAT,
  "p99_9p100_share_posttax_nat" FLOAT,
  "p99p100_share_posttax_nat" FLOAT,
  "p90p99_share_posttax_nat" FLOAT,
  "p50p90_share_posttax_nat" FLOAT,
  "p0p10_share_wealth" FLOAT,
  "p0p50_share_wealth" FLOAT,
  "p10p20_share_wealth" FLOAT,
  "p20p30_share_wealth" FLOAT,
  "p30p40_share_wealth" FLOAT,
  "p40p50_share_wealth" FLOAT,
  "p50p60_share_wealth" FLOAT,
  "p60p70_share_wealth" FLOAT,
  "p70p80_share_wealth" FLOAT,
  "p80p90_share_wealth" FLOAT,
  "p90p100_share_wealth" FLOAT,
  "p99_999p100_share_wealth" FLOAT,
  "p99_99p100_share_wealth" FLOAT,
  "p99_9p100_share_wealth" FLOAT,
  "p99p100_share_wealth" FLOAT,
  "p90p99_share_wealth" FLOAT,
  "p50p90_share_wealth" FLOAT,
  "p0p100_avg_pretax" FLOAT,
  "p0p10_avg_pretax" FLOAT,
  "p10p20_avg_pretax" FLOAT,
  "p20p30_avg_pretax" FLOAT,
  "p30p40_avg_pretax" FLOAT,
  "p40p50_avg_pretax" FLOAT
);

World Inequality Database Distribution 1

@owid.world_inequality_database.owid_world_inequality_database_distribution_1

51.16 MB
2554219 rows
11 columns


CREATE TABLE owid_world_inequality_database_distribution_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "welfare" VARCHAR,
  "p" FLOAT,
  "percentile" VARCHAR,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT,
  "thr_extrapolated" FLOAT,
  "avg_extrapolated" FLOAT,
  "share_extrapolated" FLOAT
);

World Inequality Database (WID)

@owid.world_inequality_database.owid_world_inequality_database_distribution_2

90.28 MB
3678104 rows
11 columns


CREATE TABLE owid_world_inequality_database_distribution_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "welfare" VARCHAR,
  "p" FLOAT,
  "percentile" VARCHAR,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT,
  "thr_extrapolated" FLOAT,
  "avg_extrapolated" FLOAT,
  "share_extrapolated" FLOAT
);

World Inequality Database (WID)

@owid.world_inequality_database.owid_world_inequality_database_distribution_3

88.6 MB
4018179 rows
11 columns


CREATE TABLE owid_world_inequality_database_distribution_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "welfare" VARCHAR,
  "p" FLOAT,
  "percentile" VARCHAR,
  "thr" FLOAT,
  "avg" FLOAT,
  "share" FLOAT,
  "thr_extrapolated" FLOAT,
  "avg_extrapolated" FLOAT,
  "share_extrapolated" FLOAT
);

World Inequality Database (WID)

@owid.world_inequality_database.owid_world_inequality_database_fiscal_1

17.7 KB
2472 rows
5 columns


CREATE TABLE owid_world_inequality_database_fiscal_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "p99p100_share_fiscal992i" FLOAT,
  "p99p100_share_fiscal992j" FLOAT,
  "p99p100_share_fiscal992t" FLOAT
);

World Inequality Database (WID)

@owid.world_inequality_database.owid_world_inequality_database_fiscal_2

17.33 KB
2396 rows
5 columns


CREATE TABLE owid_world_inequality_database_fiscal_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "p99p100_share_fiscal992i" FLOAT,
  "p99p100_share_fiscal992j" FLOAT,
  "p99p100_share_fiscal992t" FLOAT
);