A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | LIfe expectancy 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 20 2020 | ||||||||
5 | Download latest version: | Excel file ยป | ||||||||
6 | Latest version online: | http://gapm.io/dlex | ||||||||
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 | Life 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 birth | percent | lex | measure | 2 | ||
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 2016 & GBD 2017), World Population Prospects 2019 and our own version 7 which is based on 100 sources compiled by Mattias Lindgre.For the period between 1970-2017 , we used the data from IHME GBD 2017 wherever available otherwise we used the data from GBD 2016. To go back in time we have combined the IHME data with our historic data from V7 and adjusted the data for 100 years so that it meets IHME data for the first year it exists. From 2018 up to 2100 we have extended IHME series with UN forecasts. 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 id | Name | Link | ||||||
19 | 1 | lexv7 | GM_life expectancy v7 | https://www.gapminder.org/data/documentation/gd004/ | ||||||
20 | 2 | wpp17 | UN-population Division , WPP2019 | https://population.un.org/wpp/Download/Standard/Interpolated/ | ||||||
21 | 3 | gbd2017 | IHME, GBD2017 | http://ghdx.healthdata.org/gbd-results-tool | ||||||
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/dlex | ||||||||
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 | #REF! | #REF! | |||||
30 | v2 | - | - | |||||||
31 | v3 | - | - | |||||||
32 | v4 | -- | - | |||||||
33 | v5 | - | - | |||||||
34 | v6 | - | - | |||||||
35 | v7 | - | documentation:https://www.gapminder.org/data/documentation/gd004/ | |||||||
36 | v8 | - | - | |||||||
37 | v9 | - | new data from IHME, GBD 2016 | - | - | |||||
38 | v10 | https://docs.google.com/spreadsheets/d/1Dlp0KNDhMrJGf1dlWgvYLln4ZXhP9JwjvmiiTZrhQPA/edit#gid=501532268 | new data from IHME, GBD 2017 | 2019 May 21 | Diane I | |||||
39 | v11 | https://docs.google.com/spreadsheets/d/11mulzUH3_cueq-V9D5KIlo9oHE9YYZrUSeVyCin7_rM/edit#gid=501532268 | new data from UNPOP,WPP2019 | 2020 January 20 | Diane I | |||||
40 | ||||||||||
41 | Technical stuff | |||||||||
42 | Dataset name: | LIfe expectancy | ||||||||
43 | Dataset id: | lex | ||||||||
44 | Doc url | https://docs.google.com/spreadsheets/d/11mulzUH3_cueq-V9D5KIlo9oHE9YYZrUSeVyCin7_rM/edit#gid=501532268 | ||||||||
45 | Doc id of work doc spreadsheet | 11mulzUH3_cueq-V9D5KIlo9oHE9YYZrUSeVyCin7_rM | ||||||||
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=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//11mulzUH3_cueq-V9D5KIlo9oHE9YYZrUSeVyCin7_rM//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles | |||||||
51 | Life%20expectancy%20 | |||||||||
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 | Life expectancy | lex | 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 |