ABCDEFGHIJ
1
GDP per capita Dataset - v27 via Gapminder
2
About this fileThis 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 underlying sources. The actual data we use, is found in the sheet(s) labeled "data-...".
This file is also a documentation 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:v27
4
Updated:April 30 2021
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dgdpcap_cppp
7
Contributor(s) to this version: Diane I
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1Income per personThis is real GDP per capita (gross domestic product per person adjusted for inflation) converted to international dollars using purchasing power parity rates. An international dollar has the same purchasing power over GDP as the U.S. dollar has in the United States. GDP at purchaser's prices is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources. Data are in constant 2017 international dollars.GDP per capita, PPP (constant 2017 international $)$gdpcapcpppmeasure2
12
2GDP totalThis is real GDP (gross domestic product adjusted for inflation) converted to international dollars using purchasing power parity rates. An international dollar has the same purchasing power over GDP as the U.S. dollar has in the United States. GDP at purchaser's prices is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources. Data are in constant 2017 international dollars.GDP total, PPP (constant 2017 international $)$gdpcpppmeasure2
13
GDP per capita growth (%)Annual percentage growth rate of GDP per capita based on constant interantional dollars. Aggregates are based on PPP, constant 2017 U.S. dollars. GDP per capita is gross domestic product divided by population. GDP at purchaser's prices is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources.
Annual percentage growth rate of GDP per Capita
$gdpcapcppp_gr_pcmeasure2
14
15
Sources
16
Dataset description:This data is compiled by Gapminder mainly from these sources:
a. World Bank: For the period 1990 to 2019, data is identical to The World Bank's indicator: GDP per capita constant PPP 2017, (except for a few countries with no data in World Bank). See: gapm.io/xwb171
b. Maddison Project Database and Penn World Table of the Groningen Growth and Development Centre, University of Groningen: Data before 1990, is based mainly on estimates from i) Maddison Project database (MPD) V2020.The MPD builts on Angus Maddison's original dataset and is revised when there is more and better information available see:https://gapm.io/xmpd2020, ii) Penn World Table v10.0:gapm.io/xpwt and iii) Gapminder's historic estimates by Mattias Lindgren, which mainly uses Maddison data. See: gapm.io/histdata
c. IMF: Data after 2019 uses IMF's forecasts for GDP per capita WEO 2021, April edition: gapm.io/ximf
d. The IMF forecast reaches only to 2026. Beyond that point we have extended the series to 2050, with the hypothetical assumption, that all countries converge to a modest economic growth rate of 2.2%. The forecasts we only use to project how the world would look like About geographic boundaries:
In order to make it easy for people to follow the development of the countries they are familiar with. Our data refer to countries in the past as if they always had the boundaries they have today. Historic territories, such as USSR may sometimes also have estimates in our datatables, so be careful not to sum all rows into a total, as you will then double count many people. See gapm.io/geob
17
Link to documentation:http://gapm.io/dgdpcap_cppp
18
Short source summary:Gapminder based on World Bank, Maddison & IMF
19
20
#Source idNameLink
21
1wbWorld Bank, World Development Indicatorswww.gapm.io/xwb171
22
2mpdThe Maddison Project Database v2020
https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020
23
3pwtPenn Worl Table v10.0
https://www.rug.nl/ggdc/productivity/pwt/
24
4gmhistoric
Data before 1990, is based on Gapminder's historic estimates by Mattias Lindgren, which mainly uses Maddison data
www.gapm.io/histdata
25
5imfWorld Economic Outlook, April 2021
https://www.imf.org/external/pubs/ft/weo/2019/01/weodata/index.aspx
26
27
License
28
Attribution:
We believe in free knowledge and therefor we share free data. Most sheets in this file are provided under the open license, called Creative Commmon Attribution License CC BY 4.0., except those sheets 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/dgdpcap_cppp
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 underlying sources for the specific licenses in these cases.
31
32
VersionsLink
Changes compared to previous
DateContributors
33
v1----
34
v2----
35
v3See bottom of page http://www.gapm.io/ddgdppccpppHistorical estimates for more ocuntries2008Mattias Lindgren
36
v4----
37
v5----
38
v6----
39
v7----
40
v8----
41
v9----
42
v10----
43
v11----
44
v12----
45
v13----
46
v14See bottom of page http://www.gapm.io/ddgdppccppp-2011Mattias Lindgren
47
v15-Aligned end of series with official World Bank estimates2012Ola Rosling
48
v16-For several years we were too busy with other things, and failed to update this documentation. Many versions are simply missing from the list below, but those updates were quite trivial: We just kept updating the end of our long historic trends, with the latest numbers from the World Bank every time they released new data.)--
49
v17----
50
v18----
51
v19----
52
v20----
53
v21----
54
v22----
55
v23----
56
v24----
57
v25
https://docs.google.com/spreadsheets/d/1w8GNDCZ_-4HkDmTxbLNfGQmUjWc8yaDUo1Npl1t174o/edit#gid=501532268
Updated the end of series to align with the latest data form World Bank 20172018 March 7Ola Rosling
58
v26
https://docs.google.com/spreadsheets/d/10vHiHnBQre07TwX75vTc_H1lf-w5-hbe5mZH4ro6QNE/edit#gid=501532268
 updated the gm historical data as more data became available from the Maddison and updated the end of series to align with the latest data form World Bank 20192020 January 20Diane I
59
v27
https://docs.google.com/spreadsheets/d/1gZZ28UiWCVue-tFHMEVOvSO58x7x-w20E23l1wZTR3E/edit#gid=501532268
 updated the gm historical data as more data became available from MPD v2020,PWTv.10.0 and updated the end of series to align with the latest data form World Bank 2020#BEZUG!#BEZUG!
60
61
Technical stuff
62
Dataset name:GDP per capita
63
Dataset id:gdpcap_cppp
64
Doc urlhttps://docs.google.com/a/gapminder.org/spreadsheets/d/1h3z8u0ykcUum8P9FV8EHF9fszDYr7iPDZQ-fgE3ecls/edit
65
Doc id of work doc spreadsheet1h3z8u0ykcUum8P9FV8EHF9fszDYr7iPDZQ-fgE3ecls
66
FormulasThe formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. Search for "named ranges" to see how to use those instead of cell ranges.
67
For developersIf you like the data we use into your own products, it's better if you fetch data from our standardized gitHub repo on https://open-numbers.github.io
These spreadsheets are part of Gapminder's data compilation process and allow end users to track how we combine data.
68
Read more:gapm.io/dataworks
69
CHART PREVIEWS
70
[c] data-for-countries-etc-by-yearhttps://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=GDP%20per%20capita%20growth%20(%)&spaceRef:null;&label$which=name&scaleType=ordinal;&size$which=population_total&use=indicator&scaleType=linear;&color$which=_default&use=constant&scaleType=ordinal;;;&data$reader=ddfbw&service=https:////big-waffle.gapminder.org&dataset=sg-master&translateContributionLink:///crowdin.com//project//systema-globalis;&data_$reader=google_csv&path=https:////docs.google.com//spreadsheets//d//1h3z8u0ykcUum8P9FV8EHF9fszDYr7iPDZQ-fgE3ecls//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
71
GDP%20per%20capita%20growth%20(%)
72
DDF mapping:schema for indicator table
73
concept_id6
74
name_short2
75
name4
76
description3
77
unit5
78
type7
79
usage8
80
81
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
82
Income per persongdpcapcpppyearLoading...Loading...-Loading...
83
GDP totalgdpcpppyearLoading...Loading...-Loading...
84
85
#Validation
86
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
87
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
88
3
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
89
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
90
5
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
91
6
output-sheet:data-for-countries-etc-by-year
GOOD: The 'data-for-countries-etc-by-year' output sheet has at least 4 header columns
92
7
output-sheet:data-for-countries-etc-by-year
GOOD: The 'data-for-countries-etc-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
93
8
output-sheet:data-for-income-levels-by-year
GOOD: The 'data-for-income-levels-by-year' output sheet has at least 4 header columns
94
9
output-sheet:data-for-income-levels-by-year
GOOD: The 'data-for-income-levels-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
95
10versionGOOD: Named range 'version' exists
96
11versionGOOD: 'Version:' is filled in
97
12versionGOOD: The version at 'Version:' starts with a v, followed by an integer
98
13dateGOOD: Named range 'date' exists
99
14dateGOOD: 'Updated:' is filled in
100
15gapmioGOOD: Named range 'gapmio' exists