_Gini Data - v3 - by Gapminder
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJK
1
Gini Data—v3
2
About this datasetThis file has multiple sheets with data for one or more indicators used by Gapminder. In this sheet below you'll first find an overview of the indicators (measures) and the list of underlaying sources. The actual data we use, is found in the sheet(s) labeled "data-...".
This file is also a documentaiotn of the data process. To follow how the data was transformed from the original sources, start in the sheet to the far right, which holds the input data. You can then follow the process step by step, by looking at the formulas in the sheets from right to left, until you reach the output in the "data-..." sheets.
3
Version:v3
4
Updated:2018 December 5
5
Download:Excel file »
6
Link to latest version:http://www.gapm.io/dgini
7
Contributor(s) to this version:
Ola Rosling
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDTypeUsage
11
1GiniGini shows income inequality in a society. A higher number means more inequality.Gini coefficientCoefficientginimeasure3
12
13
Sources
14
Dataset description:Gapminder has combined gini data from multiple sources into long trends for all countries (and some other territories) betwee, for the period 1800 to 2040. The uncertainty is large for most countries. Comparing income across countries, with different tax levels, social welfare and subsidies systems, is not trivial. We only think these numbers are useful to draw big pictures of income inequalities, and we use them primaraley for our income mountains: www.gapm.io/incm. The numbers should not be used for numerica analysis. We are sharing these numbers for transparency purpose, to enable others to replicate our visualizations. For our long Gini-series, we have aligned all trends to the earliest year in PovcalNet, which is the source with the most comparable and broad coverage. Some Ginis from WDI were used, when WDI had more data than PovcalNet18dec, E.g. USA. For different coutneis the trends in PovcalNet starts in different years, and we have linked from those years back to 1800, based on whatever source had data, in the priority order : LIS, CBEI, Chartbook Of Economic Inequality, CLIO Infra and then vanZanden et. al. 2014. When data was missing, we used the closest year with data and just extended the time-series back to 1800. A few small countries had no data historically form any of these sources, in case they were assigned the Gini value 40, to not miss out in out charts.
For years beyond 2015 we have reused the latest available gini (often a number for between 2010 and 2017 from PovcalNet) and continued applying it into the future. We have no way of predicting how income distributios in countries will evolve in the future. We use these static forecasts, only to draw the "if-scenario" described at the bottom of this page: gapm.io/incm
We strongly recommend against using our ginis for numeric analysis. Gapminder uses them only to create global Income Mountains, to confront the false worldview of a divided world. For this purpose, the uncertainty of specific countries has minor effect on the big picture. In most cases, even a huge difference of gini estimates between 30 or 40 for a single country, will not change even a single pixel in the global picture on your screen.
15
Link to documentation:http://gapm.io/ddgini
16
Short source summary:Gapminder, PovcalNet, LIS, CLIO, and more
17
18
#Source idNameLink
19
1WDI
World Development Indicators, December 1, 2018, by the World Bank.
http://iresearch.worldbank.org/PovcalNet/povOnDemand.aspx
20
2PovcalNet
PovcalNet, December 1, 2018, by the World Bank has Ginis for average monthly per capita income, based on on 1500 household surveys spanning 1979-2015 and 163 countries. Almost all countries have data for several years between 2000 and 2013. Half the countries have data back to 1985. This is what we use as benchmark for our longer time-series.
http://iresearch.worldbank.org/PovcalNet/povOnDemand.aspx
21
3
PovcalNet2018march
PovcalNet, March 28, 2018, by the World Bank has Ginis for average monthly per capita income, based on on 1500 household surveys spanning 1979-2015 and 163 countries. Almost all countries have data for several years between 2000 and 2013. Half the countries have data back to 1985. This is what we use as benchmark for our longer time-series.
http://iresearch.worldbank.org/PovcalNet/povOnDemand.aspx
22
4LIS
LIS: Luxembourg Income Study Database provide Gini’s for disposable household income (DHI) for 47 countries, where some of them reach back to 1970’s.
http://www.lisdatacenter.org/lis-ikf-webapp/app/search-ikf-figures
23
5CBEI
Chartbook: The Chartbook of Economic Inequality has gathered trends for different kinds of Ginis and other inequality measures but they are not standardized. Those trends guide our guesstimations in a few cases.
https://www.chartbookofeconomicinequality.com/
24
6CLIOCLIO Infra: (including a few estimates from Bas van Leuven et. al.)
https://www.clio-infra.eu/Indicators/IncomeInequality.html
25
7vanZanden
van Zanden et. al. (2014) In our data we also have included a few estimates we got sent to us, directly from Bas van Leuven , which were part of his calculations published by OECD here: Income inequality since 1820. In Jan Luiten van Zanden, Joerg Baten, Marco Mira d'Ercole, Auke Rijpma, Conal Smith & Marcel Timmer (Eds.), How Was Life? Global Well-being since 1820 (pp. 199–215). OECD Publishing.
https://www.researchgate.net/publication/283578011_Income_inequality_since_1820
26
27
License
28
Attribution:
We believe in free knowledge and therefor we produce free data. Most sheets in this file are provided under the open license, called Creative Commmon Attribution License CC BY 4.0., except those mentioned in the exceptions section below. This means you can freely use, copy, and spread the data in those sheets, as long as you mention the following: 'Free data from Gapminder.org'.
You should also mention the underlaying data sources listed above and include this link: http://gapm.io/ddgini
29
License link:Creative Common License CC BY 4.0
30
Exceptions:The sheets starting with the word "data" are covered by this license. Other sheets are included for documentation purpose, and may include data that is governed by other licenses. Check the underlaying sources for the specific licenses in these cases.
31
32
VersionsLinkChanges compared to previousDate
Contributors
33
v1Combining World Bank Ginis with Van Zanden data provided by Bas v Lauven. For the many countries missing historical estimates. A rough assumption was made a standard gini of 37.2014 SeptemberOla Rosling
34
v2Anchored the series to PovCalNet for many additional countries that didn't have data for recent years i the preivous verison.
Improved the rough estimates of historic data by including data from LIS, and estimates based on the Chartbook of Economic Inequality.
2018 MarchOla Rosling
35
v3
https://docs.google.com/spreadsheets/d/1g3x_nUa9lFyu1SlKSmq8YB2ZknGco-jTQU80Jz3Reok/edit#gid=501532268
Updated previous version with the latest data from PovCalNet
2018 December 5Ola Rosling
36
v4
37
v5
38
39
Technical stuff
40
Dataset nameGini
41
Dataset idgini
42
The Google id of this spreadsheet1g3x_nUa9lFyu1SlKSmq8YB2ZknGco-jTQU80Jz3Reok
43
FormulasThe formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. If a spreadsheet is broken in the tree of formulas, we avoid other formulas to get broken, by always linking to the output data sheets, which are manually copied and pasted form the formula outputs in the sheets to the right of DATA_PREP sheet.
44
For developersIf you like to integrate Gapmidner's data into your product, it's better if you integrate
These spreadsheets are part of Gapminder's data production and publishing, but there's more to it. Please follow this link to get the bigger picture of our data processes.
45
Read more:gapm.io/dataworks
46
CHART PREVIEWS
47
data-for-countries-etc-by-year
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=income_per_person_gdppercapita_ppp_inflation_adjusted&scaleType=log&spaceRef:null;&axis_y$data=data_&which=Gini&spaceRef:null;&label$which=name&scaleType=ordinal;&size$which=aged_15_24_employment_rate_percent&use=indicator&scaleType=linear;&color$which=_default&use=constant&scaleType=ordinal;;;&data$reader=waffle&path=https:////waffle-server.gapminder.org//api//ddf//ql&assetsPath=https:////import-waffle-server.gapminder.org//api//ddf//assets//;&data_wdi$reader=waffle&path=https:////waffle-server.gapminder.org//api//ddf//ql&dataset=open-numbers//ddf--open_numbers--world_development_indicators&assetsPath=https:////import-waffle-server.gapminder.org//api//ddf//assets//;&data_$reader=csv&path=https:////docs.google.com//spreadsheets//d//1g3x_nUa9lFyu1SlKSmq8YB2ZknGco-jTQU80Jz3Reok//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
48
Gini
49
DDF mapping:schema for indicator table
50
concept_id6
51
name_short2
52
name4
53
description3
54
unit5
55
type7
56
usage8
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...