GM-Child Mortality - Dataset - v11

	A	B	C	D	E	F	G	H
1		Under-five Mortality Dataset - v11 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:	v11
4		Updated:	January 30 2020
5		Download latest version:	Excel file »
6		Latest version online:	http://gapm.io/du5mr
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	Child mortality	This is the probability of dying between birth and exactly five years of age expressed per 1,000 live births	Under-five mortlality rate	deaths per 1000 live births	u5mr	measure	2
12
13		Sources
14		Dataset description:	This file contains data on child mortality rates compiled by Gapminder, based on multiple sources: — 1800 to 1950: Gapminder v7 ( In some cases this is also used for years after 1950, see below.) This was compiled and documented by Mattias Lindgren from many sources, but mainly based on www.mortality.org and the series of books called International Historical Statistics by Brian R Mitchell, which often have historic estimates of Infant mortality rate which were converted to Child mortality through regression. See detailed documentation of v7 below. — 1950 to 2018: UNIGME, is a data collaboration project between UNICEF, WHO, UN Population Division and the World Bank. They released new estimates of child mortality for countries and a global estimate on September 19, 2019, which is available at www.childmortality.org. In this dataset 70% of all countries have estimates between 1970 and 2016, while roughly half the countries also reach back to 1950. — 1950 to 2100: UN WPP, World Population Prospects 2019 provides annual data for Child mortality rate for all countries in the annually interpolated demographic indicators, called WPP2019_INT_F01_ANNUAL_DEMOGRAPHIC_INDICATORS.xlsx In In general, We connected our historic estimates from Gapminder v7 to the earliest available year with data in UNIGME or if it didn’t have data, we used UN POP from 1950 and on, until UNIGME had data. Depending on data availability, different countries are moving between sources at different points in the period 1930-1980.After 2018, we have extended the UN IGME series with the UN POP numbers. But we haven't extended it with the UN POP actual numbers but instead, we extended it with the UN POP expected change. The data is part of Gapminder effort to build a fact-based worldview by showing the big picture of global development. When we find multiple data sources that haven't been combined we combine them into one consistent timeseries. This often results in large data uncertainty, as the underlaying data-sources use different methodologies etc. But we still dare to combine data that hasn't been combined, as we find it extremely important to visualize the big picture, which people otherwise tend to get absolutely wrong. Before using our data for any other purpose though, please read the documentation to make sure you are aware of our levels of doubts in the data.
15		Link to documentation:	http://gapm.io/du5mr
16		Short source summary:	GN based on IGME & UNPOP
17
18	#	Source id	Name	Link
19	1	gm2015	GM- child Mortality v7	https://www.gapminder.org/data/documentation/gd005/
20	2	igme2019	UN IGME, Child Mortality estimates,2018	https://childmortality.org
21	3	wpp2019	UN POP, World Population Prospects 2019	https://population.un.org/wpp/Download/Standard/Interpolated/
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/du5mr
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	-	First version	-	-
30		v2	-	-	-	-
31		v3	-	-	-	-
32		v4	-	-	-	-
33		v5	-	-	-	-
34		v6	-	-	-	-
35		v7	https://www.gapminder.org/data/documentation/gd005/	Mattias Lindgren	2015 January 1	Mattias Lindgren
36		v8	-	-	-	-
37		v9	-	-	-	-
38		v10	https://www.gapminder.org/data/documentation/gd005/	New data from IGME 2017 and UNPOP, WPP2017	-	-
39		v11	https://docs.google.com/spreadsheets/d/1Av7eps_zEK73-AdbFYEmtTrwFKlfruBYXdrnXAOFVpM/edit#gid=501532268	New data from IGME 2019 and UNPOP, WPP2019	2020 January 30	Diane I
40
41		Technical stuff
42		Dataset name:	Under-five Mortality
43		Dataset id:	u5mr
44		Doc url	https://docs.google.com/spreadsheets/d/1Av7eps_zEK73-AdbFYEmtTrwFKlfruBYXdrnXAOFVpM/edit#gid=501532268
45		Doc id of work doc spreadsheet	1Av7eps_zEK73-AdbFYEmtTrwFKlfruBYXdrnXAOFVpM
46		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.
47		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.
48		Read more:	gapm.io/dataworks
49			CHART PREVIEWS
50	[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=Child%20mortality&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//1Av7eps_zEK73-AdbFYEmtTrwFKlfruBYXdrnXAOFVpM//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
51			Child%20mortality
52		DDF mapping:	schema for indicator table
53		concept_id	6
54		name_short	2
55		name	4
56		description	3
57		unit	5
58		type	7
59		usage	8
60
61		Catalog status	Indicator ID	Time unit	Countries etc	Regions	In. Levels	World
62		Child mortality	u5mr	year	#NAME?	#NAME?	-	#NAME?
63
64	#	Validation
65	1	output-sheets	GOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
66	2	output-sheet:data-for-world-by-year	GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
67	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)
68	4	output-sheet:data-for-regions-by-year	GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
69	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)
70	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
71	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)
72	8	version	GOOD: Named range 'version' exists
73	9	version	GOOD: 'Version:' is filled in
74	10	version	GOOD: The version at 'Version:' starts with a v, followed by an integer
75	11	date	GOOD: Named range 'date' exists
76	12	date	GOOD: 'Updated:' is filled in
77	13	gapmio	GOOD: Named range 'gapmio' exists
78	14	gapmio	GOOD: 'Latest version online:' is filled in
79	15	contributors	GOOD: Named range 'contributors' exists
80	16	contributors	GOOD: 'Contributor(s) to this version:' is filled in
81	17	indicator_table	GOOD: Named range 'indicator_table' exists
82	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)
83	19	indicator_table:row_1	GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
84	20	indicator_table:row_1	GOOD: Indicator 1 has a short indicator name (Column 2)
85	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"
86	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"
87	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"
88	24	indicator_table:row_1	GOOD: Indicator 1 has a description (Column 3)
89	25	indicator_table:row_1	GOOD: Indicator 1 has a full name (Column 4)
90	26	indicator_table:row_1	GOOD: Indicator 1 has a unit (Column 5)
91	27	indicator_table:row_1	GOOD: Indicator 1's unit does not start or end with a space
92	28	indicator_table:row_1	GOOD: Indicator 1 has an ID (Column 6)
93	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)
94	30	indicator_table:row_1	GOOD: Indicator 1's ID has less than or equal to 20 characters
95	31	indicator_table:row_1	GOOD: Indicator 1 has a type set (Column 7)
96	32	indicator_table:row_1	GOOD: Indicator 1 has a usage level set (Column 8)
97	33	dataset_description	GOOD: Named range 'dataset_description' exists
98	34	dataset_description	GOOD: 'Dataset description:' is filled in
99	35	source_url	GOOD: Named range 'source_url' exists
100	36	source_url	GOOD: 'Link to documentation:' is filled in