ABCDEFGHIJ
1
Population Dataset - v7 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:v7
4
Updated:10/19/2022
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dpop
7
Contributor(s) to this version: Hisham N
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1PopulationTotal population counts the number of inhabitants in the territory.PopulationPeoplepopmeasure1
12
13
Sources
14
Dataset description:Our population data is divided into two chunks. One long historic trend for the total global population that goes back all the way to 10,000 BC. And the second chunk is country estimates that only reaches back to 1800. In this spreadsheet we present population data for the period 1800-2100. We use UN population data between 1950 to 2100 from UN Population Division World Population Prospects 2019 and the forecast to year 2100 is using their medium fertility variant. For years before 1950, this version uses the data documented in greater detail by Mattias Lindgren in version 3 . The main source was Angus Maddison’s data which is maintained and improved by CLIO Infra Project.
When combining version 3 with the new UN data, the trends for a few countries didn’t match up in the overlapping year 1950, and small adjustments were made to the years before and after to smooth out the discrepancy between the two sources to avoid sudden jumps in our visualisations.Below there is a link to documentation with detailed methodology used and and the data for back to 10,000BC.
15
Link to documentation:http://gapm.io/dpop
16
Short source summary:Gapminder based on UN-Pop & Maddison
17
18
#Source idNameLink
19
1WPP22UN-Population Division, World Population Prospects 2022https://population.un.org/wpp/
20
2gmgm_population v3 based mainly on Madsison's datahttps://www.gapminder.org/data/documentation/gd003/
21
3CLIO Angus Maddison's datahttps://clio-infra.eu/Indicators/TotalPopulation.html
22
23
License
24
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/dpop
25
License link:Creative Common License CC BY 4.0
26
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.
27
28
VersionsLinkChanges compared to previousDateContributors
29
v1-
Documented here (https://www.gapminder.org/data/documentation/gd003/)
--
30
v2----
31
v3-
Documented here (https://www.gapminder.org/data/documentation/gd003/)
--
32
v4----
33
v5
https://docs.google.com/spreadsheets/d/1fyp3PYym3VWtTH02XCBc0e5lIL0A--MWEckjZH8ry-E/edit#gid=1596123756
Documented here (https://www.gapminder.org/data/documentation/gd003/)
2018 April 8Ola Rosling
34
v6
https://docs.google.com/spreadsheets/d/14_suWY8fCPEXV0MH7ZQMZ-KndzMVsSsA5HdR-7WqAC0/edit#gid=501532268
new data from WPP2019, updated historical data of czech RepublicDecember 10 2019Diane I
35
v7
https://docs.google.com/spreadsheets/d/1c1luQNdpH90tNbMIeU7jD__59wQ0bdIGRFpbMm8ZBTk/edit#gid=501532268
new data from WPP202110/19/2022Hisham N
36
37
Technical stuff
38
Dataset name:Population
39
Dataset id:pop
40
Doc urlhttps://docs.google.com/spreadsheets/d/1c1luQNdpH90tNbMIeU7jD__59wQ0bdIGRFpbMm8ZBTk/edit#gid=501532268
41
Doc id of work doc spreadsheet1c1luQNdpH90tNbMIeU7jD__59wQ0bdIGRFpbMm8ZBTk
42
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.
43
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.
44
Read more:gapm.io/dataworks
45
CHART PREVIEWS
46
[c]
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=Population&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//1c1luQNdpH90tNbMIeU7jD__59wQ0bdIGRFpbMm8ZBTk//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
47
Population
48
DDF mapping:schema for indicator table
49
concept_id6
50
name_short2
51
name4
52
description3
53
unit5
54
type7
55
usage8
56
57
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
58
PopulationpopyearGOODGOOD=GM_DATAPOINT_CATALOG_STATUS($C57,$D57,"world_4level",TRUE)GOOD
59
60
#Validation
61
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
62
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
63
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)
64
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
65
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)
66
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
67
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)
68
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
69
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)
70
10versionGOOD: Named range 'version' exists
71
11versionGOOD: 'Version:' is filled in
72
12versionGOOD: The version at 'Version:' starts with a v, followed by an integer
73
13dateGOOD: Named range 'date' exists
74
14dateGOOD: 'Updated:' is filled in
75
15gapmioGOOD: Named range 'gapmio' exists
76
16gapmioGOOD: 'Latest version online:' is filled in
77
17contributorsGOOD: Named range 'contributors' exists
78
18contributorsGOOD: 'Contributor(s) to this version:' is filled in
79
19indicator_tableGOOD: Named range 'indicator_table' exists
80
20indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
81
21indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
82
22indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
83
23
indicator_table:row_1:data-for-world-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-world-by-year' output sheet in column 4 as "=ABOUT!B11"
84
24
indicator_table:row_1:data-for-regions-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-regions-by-year' output sheet in column 4 as "=ABOUT!B11"
85
25
indicator_table:row_1:data-for-countries-etc-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-countries-etc-by-year' output sheet in column 4 as "=ABOUT!B11"
86
26
indicator_table:row_1:data-for-income-levels-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-income-levels-by-year' output sheet in column 4 as "=ABOUT!B11"
87
27indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
88
28indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)
89
29indicator_table:row_1GOOD: Indicator 1 has a unit (Column 5)
90
30indicator_table:row_1GOOD: Indicator 1's unit does not start or end with a space
91
31indicator_table:row_1GOOD: Indicator 1 has an ID (Column 6)
92
32indicator_table:row_1GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
93
33indicator_table:row_1GOOD: Indicator 1's ID has less than or equal to 20 characters
94
34indicator_table:row_1GOOD: Indicator 1 has a type set (Column 7)
95
35indicator_table:row_1GOOD: Indicator 1 has a usage level set (Column 8)
96
36dataset_descriptionGOOD: Named range 'dataset_description' exists
97
37dataset_descriptionGOOD: 'Dataset description:' is filled in
98
38source_urlGOOD: Named range 'source_url' exists
99
39source_urlGOOD: 'Link to documentation:' is filled in
100
40source_short_textGOOD: Named range 'source_short_text' exists