GM-Population - Dataset - v8

	A	B	C	D	E	F	G	H
1		Population Dataset - v8 via Gapminder

2		About this file	This 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:	v8
4		Updated:	7/29/2024
5		Download latest version:	Excel file »
6		Latest version online:	http://gapm.io/dpop
7		Contributor(s) to this version:	Hisham N
8		Feedback	Please give feedback here
9
10	#	Indicator(s)	Description	Full name	Unit	ID	type	Usage
11	1	Population	Total population counts the number of inhabitants in the territory.	Population	People	pop	measure	1
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 id	Name	Link
19	1	WPP22	UN-Population Division, World Population Prospects 2024	https://population.un.org/wpp/
20	2	gm	gm_population v3 based mainly on Madsison's data	https://www.gapminder.org/data/documentation/gd003/
21	3	CLIO	Angus Maddison's data	https://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		Versions	Link	Changes compared to previous	Date	Contributors
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 8	Ola 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 Republic	December 10 2019	Diane I
35		v7	https://docs.google.com/spreadsheets/d/1c1luQNdpH90tNbMIeU7jD__59wQ0bdIGRFpbMm8ZBTk/edit#gid=501532268	new data from WPP2021	10/19/2022	Hisham N
36		v8	https://docs.google.com/spreadsheets/d/11qDjnPu2BlFFegwpPl3CcyZtfiYT4R2seU_IcIcJkHM/edit?gid=501532268#gid=501532268	new data from WPP 2024	7/29/2024	Hisham N
37
38		Technical stuff
39		Dataset name:	Population
40		Dataset id:	pop
41		Doc url	https://docs.google.com/spreadsheets/d/11qDjnPu2BlFFegwpPl3CcyZtfiYT4R2seU_IcIcJkHM/edit?gid=501532268#gid=501532268
42		Doc id of work doc spreadsheet	11qDjnPu2BlFFegwpPl3CcyZtfiYT4R2seU_IcIcJkHM
43		Formulas	The 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.
44		For developers	If 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.
45		Read more:	gapm.io/dataworks
46			CHART PREVIEWS
47	[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//11qDjnPu2BlFFegwpPl3CcyZtfiYT4R2seU_IcIcJkHM//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
48			Population
49		DDF mapping:	schema for indicator table
50		concept_id	6
51		name_short	2
52		name	4
53		description	3
54		unit	5
55		type	7
56		usage	8
57
58		Catalog status	Indicator ID	Time unit	Countries etc	Regions	In. Levels	World
59		Population	pop	year	GOOD	GOOD	=GM_DATAPOINT_CATALOG_STATUS($C57,$D57,"world_4level",TRUE)	GOOD
60
61	#	Validation
62	1	output-sheets	GOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
63	2	output-sheet:data-for-world-by-year	GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
64	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)
65	4	output-sheet:data-for-regions-by-year	GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
66	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)
67	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
68	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)
69	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
70	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)
71	10	version	GOOD: Named range 'version' exists
72	11	version	GOOD: 'Version:' is filled in
73	12	version	GOOD: The version at 'Version:' starts with a v, followed by an integer
74	13	date	GOOD: Named range 'date' exists
75	14	date	GOOD: 'Updated:' is filled in
76	15	gapmio	GOOD: Named range 'gapmio' exists
77	16	gapmio	GOOD: 'Latest version online:' is filled in
78	17	contributors	GOOD: Named range 'contributors' exists
79	18	contributors	GOOD: 'Contributor(s) to this version:' is filled in
80	19	indicator_table	GOOD: Named range 'indicator_table' exists
81	20	indicator_table	GOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
82	21	indicator_table:row_1	GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
83	22	indicator_table:row_1	GOOD: Indicator 1 has a short indicator name (Column 2)
84	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"
85	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"
86	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"
87	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"
88	27	indicator_table:row_1	GOOD: Indicator 1 has a description (Column 3)
89	28	indicator_table:row_1	GOOD: Indicator 1 has a full name (Column 4)
90	29	indicator_table:row_1	GOOD: Indicator 1 has a unit (Column 5)
91	30	indicator_table:row_1	GOOD: Indicator 1's unit does not start or end with a space
92	31	indicator_table:row_1	GOOD: Indicator 1 has an ID (Column 6)
93	32	indicator_table:row_1	GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
94	33	indicator_table:row_1	GOOD: Indicator 1's ID has less than or equal to 20 characters
95	34	indicator_table:row_1	GOOD: Indicator 1 has a type set (Column 7)
96	35	indicator_table:row_1	GOOD: Indicator 1 has a usage level set (Column 8)
97	36	dataset_description	GOOD: Named range 'dataset_description' exists
98	37	dataset_description	GOOD: 'Dataset description:' is filled in
99	38	source_url	GOOD: Named range 'source_url' exists
100	39	source_url	GOOD: 'Link to documentation:' is filled in