Population - Dataset - v1 - Google Tabellen

	A	B	C	D	E	F	G	H
1		Population by broad age groups Dataset - v1 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:	v1
4		Updated:	April 4 2019
5		Download latest version:	Excel file »
6		Latest version online:	http://gapm.io/d/pop_by_agps
7		Contributor(s) to this version:	Diane I
8		Feedback	Please give feedback here
9
10	#	Indicator(s)	Description	Full name	Unit	ID	type	Usage
11	1	Chidren population, aged 0-14 years	This is the total number of children population, aged 0 to 14 years old.	Number of children population,aged 0-14years	people	child_num	measure	2
12	2	Adult population, aged 15-74 years	This is the total number of adults population, aged 15 to 74 years old.	Number of adults population, aged 15-75 years	people	adult_num	measure	2
13	3	Old population, aged 75+	This is the total number of olds population, aged 75 and more .	Number of old population,aged 75+	people	old_num	measure	2
14
15		Sources
16		Dataset description:	Population by age group data have been imported from World Population Prospects 2017, produced by UN-population division. The Population by age group dataset contains annual estimates of population by five-year age group from1950 to 2015 and annual population by five years age groups projection from 2016 up to 2100. The source of the population estimates are mainly population , censuses, official estimates. The population projections are medium variant. We aggregated different age groups into three groups which are 0-14 years (these constitute children population),15-74 years (these are adults population) and 75 and over ( old poulation) for countries /territories for the period 1950 to 2100. In addition we calculated the regional and global total population by those 3 age groups. The data in this spreadsheet were used to respond two questions in the Global Misconception Survey (GMS 2017), which asked the number of children aged 0-14 years in 2100 compared to today number of children and the main raison of population increase in 2100 ( i.e if there will be more children, more adults or more old people). Accordingly to UN-pop the number of children in 2100 will not be higher than it is today and the main raison of population will result from the fact that they will be more adults.
17		Link to documentation:	http://gapm.io/d/pop_by_agps
18		Short source summary:	Gapminder based on UN-pop
19
20	#	Source id	Name	Link
21	1	UN-pop17	UN, Department of EConomic and Social Affairs, Population Division. World Population Prospects, 2017.	https://population.un.org/wpp/
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/d/pop_by_agps
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	https://docs.google.com/spreadsheets/d/19H3ktTGUN_KZWhjfTIIWREWPZ_f-tP9Pdc8ijO_i8uY/edit#gid=948776007	First version	April 4 2019	Diane I
30
31		Technical stuff
32		Dataset name:	Population by broad age groups
33		Dataset id:	pop_by_agps
34		Doc url	https://docs.google.com/a/gapminder.org/spreadsheets/d/19H3ktTGUN_KZWhjfTIIWREWPZ_f-tP9Pdc8ijO_i8uY/edit
35		Doc id of work doc spreadsheet	19H3ktTGUN_KZWhjfTIIWREWPZ_f-tP9Pdc8ijO_i8uY
36		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.
37		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.
38		Read more:	gapm.io/dataworks
39			CHART PREVIEWS
40	[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=Chidren%20population,%20aged%200-14%20years&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//19H3ktTGUN_KZWhjfTIIWREWPZ_f-tP9Pdc8ijO_i8uY//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
41			Chidren%20population,%20aged%200-14%20years
42		DDF mapping:	schema for indicator table
43		concept_id	6
44		name_short	2
45		name	4
46		description	3
47		unit	5
48		type	7
49		usage	8
50
51		Catalog status	Indicator ID	Time unit	Countries etc	Regions	In. Levels	World
52	1	Chidren population, aged 0-14 years	child_num	year	GOOD	GOOD	-	GOOD
53	2	Adult population, aged 15-74 years	adult_num	year	GOOD	GOOD	-	#FEHLER!
54	3	Old population, aged 75+	old_num	year	GOOD	#FEHLER!	-	GOOD
55
56	#	Validation
57	1	output-sheets	GOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
58	2	output-sheet:data-for-world-by-year	GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
59	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)
60	4	output-sheet:data-for-regions-by-year	GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
61	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)
62	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
63	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)
64	8	version	GOOD: Named range 'version' exists
65	9	version	GOOD: 'Version:' is filled in
66	10	version	GOOD: The version at 'Version:' starts with a v, followed by an integer
67	11	date	GOOD: Named range 'date' exists
68	12	date	GOOD: 'Updated:' is filled in
69	13	gapmio	GOOD: Named range 'gapmio' exists
70	14	gapmio	GOOD: 'Latest version online:' is filled in
71	15	contributors	GOOD: Named range 'contributors' exists
72	16	contributors	GOOD: 'Contributor(s) to this version:' is filled in
73	17	indicator_table	GOOD: Named range 'indicator_table' exists
74	18	indicator_table	GOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
75	19	indicator_table:row_1	GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
76	20	indicator_table:row_1	GOOD: Indicator 1 has a short indicator name (Column 2)
77	21	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"
78	22	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"
79	23	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"
80	24	indicator_table:row_1	GOOD: Indicator 1 has a description (Column 3)
81	25	indicator_table:row_1	GOOD: Indicator 1 has a full name (Column 4)
82	26	indicator_table:row_1	GOOD: Indicator 1 has a unit (Column 5)
83	27	indicator_table:row_1	GOOD: Indicator 1's unit does not start or end with a space
84	28	indicator_table:row_1	GOOD: Indicator 1 has an ID (Column 6)
85	29	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)
86	30	indicator_table:row_1	GOOD: Indicator 1's ID has less than or equal to 20 characters
87	31	indicator_table:row_1	GOOD: Indicator 1 has a type set (Column 7)
88	32	indicator_table:row_1	GOOD: Indicator 1 has a usage level set (Column 8)
89	33	indicator_table:row_2	GOOD: This first column of row '2' in the indicator(s) table is incremental (from 1 and up)
90	34	indicator_table:row_2	GOOD: Indicator 2 has a short indicator name (Column 2)
91	35	indicator_table:row_2:data-for-world-by-year	GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-world-by-year' output sheet in column 5 as "=ABOUT!B12"
92	36	indicator_table:row_2:data-for-regions-by-year	GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-regions-by-year' output sheet in column 5 as "=ABOUT!B12"
93	37	indicator_table:row_2:data-for-countries-etc-by-year	GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-countries-etc-by-year' output sheet in column 5 as "=ABOUT!B12"
94	38	indicator_table:row_2	GOOD: Indicator 2 has a description (Column 3)
95	39	indicator_table:row_2	GOOD: Indicator 2 has a full name (Column 4)
96	40	indicator_table:row_2	GOOD: Indicator 2 has a unit (Column 5)
97	41	indicator_table:row_2	GOOD: Indicator 2's unit does not start or end with a space
98	42	indicator_table:row_2	GOOD: Indicator 2 has an ID (Column 6)
99	43	indicator_table:row_2	GOOD: Indicator 2's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
100	44	indicator_table:row_2	GOOD: Indicator 2's ID has less than or equal to 20 characters