Data Population - v5 - 1800 to 2100 World Regions and Countries by Gapminder

	B	C	D	E	G	H
1	Data: Population — v5			Free data from www.gapminder.org	id	version
2	Updated: April 8, 2018			CC BY 4.0 LICENCE	pop	v5

3	Indicator:	Population, total		Are 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 id	18Ep3s1S0cvlT1ovQG9KdipLEoQ1Ktz5LtTTQpDcWbX0
56		Bubbles	Lines	Map	csv	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	Formulas	The 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	Formulas	If you like to integrate Gapmidner's data into your product, it's better if you integrate
68	Source id	GM_POP_V5
69	Dataset id	pop
70
71	used sources	WITHOUT 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