ABCDEFGHIJ
1
LIfe expectancy Dataset - v12 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:v12
4
Updated:June 29 2021
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dlex
7
Contributor(s) to this version: Diane I
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1Life expectancy The number of years a newborn infant would live if prevailing patterns of mortality at the time of its birth were to stay the same throughout its life.Life expectancy, at birthpercentlexmeasure2
12
13
Sources
14
Dataset description:Life experience data is compiled by Gapimnder based on multiple sources mainly data from Institute of Health Metrics and Evaluation in their Global Burden Disease studies (GBD 2019), World Population Prospects 2019 and Gapminder-Life expexctancy v.7 which is based on 100 sources and compiled by Mattias Lindgre. The data is combined as follow:- For the period between 1970-2019, we use the data from IHME GBD 2019. To go back in time we have combined the IHME data with our historic data from V7 and adjusted the data for 80 years so that it meets IHME data for the first year it exists. From 2020 up to 2100 we have extended IHME series with UN forecasts. In this version , we capture the impact of covid19 on life expectancy for the year 2020. Based data from Eurostat, Aburto et al. in their research paper and Heuveline & TZen M, most countries has recorded a decrease in life expectancy. A decrease that in all cases is associated to covid deaths and deaths induced by covid19. l A more detailed methodology can be accessed through the link below.
15
Link to documentation:http://gapm.io/dlex
16
Short source summary:GM based on IHME & UN-pop
17
18
#Source idNameLink
19
1lexv7GM_life expectancy v7https://www.gapminder.org/data/documentation/gd004/
20
2wpp17UN-population Division , WPP2019https://population.un.org/wpp/Download/Standard/Interpolated/
21
3gbd2017IHME, GBD2019http://ghdx.healthdata.org/gbd-results-tool
22
Estimating reduction in life expectancy in. 2020.https://docs.google.com/spreadsheets/d/17NMOHItdmhSIAOMx5WNI9CGxO9_Jv3PyxCkdri3D9Z8/edit#gid=0
23
24
License
25
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/dlex
26
License link:Creative Common License CC BY 4.0
27
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.
28
29
VersionsLink
Changes compared to previous
DateContributors
30
v1-First version#BEZUG!#BEZUG!
31
v2--
32
v3--
33
v4---
34
v5--
35
v6--
36
v7-documentation:https://www.gapminder.org/data/documentation/gd004/
37
v8--
38
v9-new data from IHME, GBD 2016--
39
v10
https://docs.google.com/spreadsheets/d/1Dlp0KNDhMrJGf1dlWgvYLln4ZXhP9JwjvmiiTZrhQPA/edit#gid=501532268
new data from IHME, GBD 20172019 May 21Diane I
40
v11
https://docs.google.com/spreadsheets/d/11mulzUH3_cueq-V9D5KIlo9oHE9YYZrUSeVyCin7_rM/edit#gid=501532268
new data from UNPOP,WPP20192020 January 20Diane I
41
v12
https://docs.google.com/spreadsheets/d/11FLBRAKkd0o-EhDXvNWguGkhGfw0STMSHtaqJsDb99Q/edit#gid=501532268
new data from IHME, GBD 2019 & lex reduction due to covid19 in 20202021 June 29Diane I
42
43
Technical stuff
44
Dataset name:LIfe expectancy
45
Dataset id:lex
46
Doc urlhttps://docs.google.com/a/gapminder.org/spreadsheets/d/1RheSon1-q4vFc3AGyupVPH6ptEByE-VtnjOCselU0PE/edit
47
Doc id of work doc spreadsheet1RheSon1-q4vFc3AGyupVPH6ptEByE-VtnjOCselU0PE
48
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.
49
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.
50
Read more:gapm.io/dataworks
51
CHART PREVIEWS
52
[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=Life%20expectancy%20&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//1RheSon1-q4vFc3AGyupVPH6ptEByE-VtnjOCselU0PE//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
53
Life%20expectancy%20
54
DDF mapping:schema for indicator table
55
concept_id6
56
name_short2
57
name4
58
description3
59
unit5
60
type7
61
usage8
62
63
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
64
Life expectancy lexyearGOODGOOD-GOOD
65
66
#Validation
67
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
68
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
69
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)
70
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
71
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)
72
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
73
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)
74
8versionGOOD: Named range 'version' exists
75
9versionGOOD: 'Version:' is filled in
76
10versionGOOD: The version at 'Version:' starts with a v, followed by an integer
77
11dateGOOD: Named range 'date' exists
78
12dateGOOD: 'Updated:' is filled in
79
13gapmioGOOD: Named range 'gapmio' exists
80
14gapmioGOOD: 'Latest version online:' is filled in
81
15contributorsGOOD: Named range 'contributors' exists
82
16contributorsGOOD: 'Contributor(s) to this version:' is filled in
83
17indicator_tableGOOD: Named range 'indicator_table' exists
84
18indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
85
19indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
86
20indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
87
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"
88
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"
89
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"
90
24indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
91
25indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)
92
26indicator_table:row_1GOOD: Indicator 1 has a unit (Column 5)
93
27indicator_table:row_1GOOD: Indicator 1's unit does not start or end with a space
94
28indicator_table:row_1GOOD: Indicator 1 has an ID (Column 6)
95
29indicator_table:row_1GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
96
30indicator_table:row_1GOOD: Indicator 1's ID has less than or equal to 20 characters
97
31indicator_table:row_1GOOD: Indicator 1 has a type set (Column 7)
98
32indicator_table:row_1GOOD: Indicator 1 has a usage level set (Column 8)
99
33dataset_descriptionGOOD: Named range 'dataset_description' exists
100
34dataset_descriptionGOOD: 'Dataset description:' is filled in