Data Population - v5 - 1800 to 2100 World Regions and Countries 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
Data: Population — v5
Free data from www.gapminder.orgidversion
2
Updated: April 8, 2018
CC BY 4.0 LICENCEpopv5
3
Indicator:Population, totalAre you seeing this offline? Please make sure you use the latest version. Here's the permalink:
4
Unit:Inhabitants of a given area of land.gapm.io/datapop
5
Version:v5
6
Download:Excel file »
7
8
About this file
9
Gapminder has combined population data from multiple sources into long trends for the world, four regions and countries all the way from 1800 to 1900. In the following sheets you find the data with years in columns, and then the country and region datasets are duplicated in the two last sheets "pivoted", with years on the first row, to make it easier to draw charts quickly.
10
11
Data source summary
12
— Period 1950 to 2015 : most data comes from UN Population Division World Population Prospects 2017
— Period 2016 to 2100: We use the same UN source forecast medium fertility variant.
— Period 1800 to 1950: Data from hundreds of sources compiled by Mattias Lindgren in Gapminders population series, version 3. The main source is Angus Maddison’s data which is maintained and improved by the CLIO Infra Project. See detailed documentation of v3 at the bottom of page gapm.io/dpop.
13
14
Detailed data source documentation
15
gapm.io/doc_pop
16
17
Related data and info
18
If you're looking for a longer global population trend, reaching back before 1800, look here:
19
gapm.io/datapoplong
20
21
Data Version
22
Author of this version: Ola Rosling
23
Permalink to this version: v5
24
gapm.io/d_pop_v5
25
For previous versions, see the list at the bottom of the documentation page:
26
gapm.io/doc_pop
27
28
Feedback
29
If you find a problem or have a question:
30
Please give feedback here
31
32
Gapminder's Data License
33
Creative Common License CC BY 4.0
34
We produce free data, and most (not all!) sheets here are provided under the open license. You can use, copy, and spread this data, as long as you mention the following:
35
Free data from Gapminder.org: gapm.io/d_pop_v5
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Technical stuff
54
Used for formulas
55
This G doc id18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0
56
Bubbles
Lines
Mapcsv
Import the output sheets from this file into other files with IMPORTRANGE
57
data-world-by-year
https://www.gapminder.org/tools/#$state$time$value=1990;&marker$axis_y$data=data_&which=FILL&domainMin:null&domainMax:null&zoomedMin:null&zoomedMax:null&spaceRef:null;;;&data_$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-world-by-year;&chart-type=bubbles
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=time&scaleType=time;&axis_y$which=FILL;&label$which=geo&scaleType=ordinal;&color$which=_default&use=constant&scaleType=ordinal;;;&data$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-world-by-year;&chart-type=linechart
https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0/gviz/tq?tqx=out:csv&sheet=data-world-by-year
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0", "data-world-by-year!A:D")
58
data-regions-by-year
https://www.gapminder.org/tools/#$state$time$value=1990;&marker$axis_y$data=data_&which=FILL&domainMin:null&domainMax:null&zoomedMin:null&zoomedMax:null&spaceRef:null;;;&data_$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-regions-by-year;&chart-type=bubbles
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=time&scaleType=time;&axis_y$which=FILL;&label$which=geo&scaleType=ordinal;&color$which=_default&use=constant&scaleType=ordinal;;;&data$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-regions-by-year;&chart-type=linechart
https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0/gviz/tq?tqx=out:csv&sheet=data-regions-by-year
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0", "data-regions-by-year!A:D")
59
data-countries-etc-by-year
https://www.gapminder.org/tools/#$state$time$value=1990;&marker$axis_y$data=data_&which=FILL&domainMin:null&domainMax:null&zoomedMin:null&zoomedMax:null&spaceRef:null;;;&data_$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-countries-etc-by-year;&chart-type=bubbles
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=time&scaleType=time;&axis_y$which=FILL;&label$which=geo&scaleType=ordinal;&color$which=_default&use=constant&scaleType=ordinal;;;&data$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-countries-etc-by-year;&chart-type=linechart
https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0/gviz/tq?tqx=out:csv&sheet=data-countries-etc-by-year
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0", "data-countries-etc-by-year!A:D")
60
data-regions-year-columns
https://www.gapminder.org/tools/#$state$time$value=1990;&marker$axis_y$data=data_&which=FILL&domainMin:null&domainMax:null&zoomedMin:null&zoomedMax:null&spaceRef:null;;;&data_$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-regions-year-columns;&chart-type=bubbles
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=time&scaleType=time;&axis_y$which=FILL;&label$which=geo&scaleType=ordinal;&color$which=_default&use=constant&scaleType=ordinal;;;&data$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-regions-year-columns;&chart-type=linechart
https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0/gviz/tq?tqx=out:csv&sheet=data-regions-year-columns
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0", "data-regions-year-columns!A:D")
61
data-countries-etc-by-year-columns
https://www.gapminder.org/tools/#$state$time$value=1990;&marker$axis_y$data=data_&which=FILL&domainMin:null&domainMax:null&zoomedMin:null&zoomedMax:null&spaceRef:null;;;&data_$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-countries-etc-by-year-columns;&chart-type=bubbles
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=time&scaleType=time;&axis_y$which=FILL;&label$which=geo&scaleType=ordinal;&color$which=_default&use=constant&scaleType=ordinal;;;&data$path=https:////docs.google.com//spreadsheets//d//18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0//gviz//tq?tqx=out:csv/&sheet=data-countries-etc-by-year-columns;&chart-type=linechart
https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0/gviz/tq?tqx=out:csv&sheet=data-countries-etc-by-year-columns
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0", "data-countries-etc-by-year-columns!A:D")
62
63
64
These spreadsheets are part of Gapminder's data production and publishing, but there' more to it. Please follow this link to get the bigger picture of our data processes.
65
gapm.io/dataworks
66
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.
67
FormulasIf you like to integrate Gapmidner's data into your product, it's better if you integrate
68
Source idGM_POP_V5
69
Dataset idpop
70
71
used sourcesWITHOUT VERSION
72
No sources
73
74
75
76
77
78
79
80
81
82
83
WITH VERSION
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...