ABCDEFGHIJ
1
WHR-Happiness score Dataset - v2 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:v2
4
Updated:April 16 2021
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dhapiscore_whr
7
Contributor(s) to this version: Jean U
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1Happiness score (WHR)This is the national average response to the question of life evaluations asking the following “Please imagine a ladder, with steps numbered from 0 at the bottom to 10 at the top. The top of the ladder represents the best possible life for you and the bottom of the ladder represents the worst possible life for you. On which step of the ladder would you say you personally feel you stand at this time?” This measure is also referred to as Cantril life ladder. Gapminder has converted this indicator's scale from 0 to 100 to easly communicate it in terms of percentage. Happiness score (WHR)Percenthapiscore_whrmeasure2
12
13
Sources
14
Dataset description:Happiness data is published in the World Happiness Report of the Sustainable Development Solutions Network using data collected by Gallup World Poll. Gallup is a set of national representative surveys undertaken in more than 160 countries in over 140 languages. The main life evaluation question asked in the poll is: “Please imagine a ladder, with steps numbered from 0 at the bottom to 10 at the top. The top of the ladder represents the best possible life for you and the bottom of the ladder represents the worst possible life for you. On which step of the ladder would you say you personally feel you stand at this time?” (Also known as the “Cantril Ladder”.). Gapminder imported times series data from the period 2005 until 2020 from World Happiness Report, 2021. The 2018-2020 ranking of happiness scores includes 149 countries/territories; only two third of them (95 to be precise) have survey information in 2020. The remaining countries’ ranking are based on surveys in 2018 and 2019. We converted countries-etc' happiness score from a scale of 0-10 to scale 0-100. In addition, we calculated the weighted average happiness score using countries-etc' population as weights for four regions (as defined by Gapminder) and global.
15
Link to documentation:http://gapm.io/dhapiscore_whr
16
Short source summary:WHR,OWID & GM
17
18
#Source idNameLink
19
1whr2021World Happiness Report 2021https://happiness-report.s3.amazonaws.com/2021/WHR+21.pdf
20
2gmpopv6Gapminder-population v6https://docs.google.com/spreadsheets/d/14_suWY8fCPEXV0MH7ZQMZ-KndzMVsSsA5HdR-7WqAC0/edit#gid=501532268
21
22
License
23
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/dhapiscore_whr
24
License link:Creative Common License CC BY 4.0
25
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.
26
27
VersionsLink
Changes compared to previous
DateContributors
28
v1
https://docs.google.com/spreadsheets/d/1xjj60QRp8o7NA0w5TDdYXNej7kaTnubAYHZbhKLnSV0/edit#gid=501532268
First version2020 December 23Jean U. & Diane I.
29
v2https://docs.google.com/spreadsheets/d/1zDOE-mIFctafOi_6ya6aF4yZNL0IxLBJNedHesgHEqY/edit#gid=501532268Second version 2021 April 16Jean U
30
31
Technical stuff
32
Dataset name:WHR-Happiness score
33
Dataset id:hapiscore_whr
34
Doc urlhttps://docs.google.com/spreadsheets/d/1s4ryFpYS1AQAhI2E1XaQyZ0ikj6oF8YlwISrKkyNj6c/edit#gid=501532268
35
Doc id of work doc spreadsheet1s4ryFpYS1AQAhI2E1XaQyZ0ikj6oF8YlwISrKkyNj6c
36
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.
37
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.
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;&marker$axis_x$which=income_per_person_gdppercapita_ppp_inflation_adjusted&scaleType=log&spaceRef:null;&axis_y$data=data_&which=Happiness%20score%20(WHR)&spaceRef:null;&label$which=name&scaleType=ordinal;&size$which=population_total&use=indicator&scaleType=linear&spaceRef:null;&color$data=data_fasttrack&which=world_4region&use=property&scaleType=ordinal&spaceRef=entities;;;&data$reader=ddfbw&dataset=sg-master&service=https:////big-waffle.gapminder.org;&data_$reader=google_csv&path=https:////docs.google.com//spreadsheets//d//1s4ryFpYS1AQAhI2E1XaQyZ0ikj6oF8YlwISrKkyNj6c//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&data_wdi$reader=ddfbw&dataset=wdi-master&service=https:////big-waffle.gapminder.org;&data_fasttrack$reader=ddfbw&dataset=fasttrack&service=https:////big-waffle.gapminder.org;&chart-type=bubbles
41
Happiness%20score%20(WHR)
42
DDF mapping:schema for indicator table
43
concept_id6
44
name_short2
45
name4
46
description3
47
unit5
48
type7
49
usage8
50
51
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
52
Happiness score (WHR)
hapiscore_whryearGOODBAD: Not allowed to access the requested Google Spreadsheet resource at "https://spreadsheets.google.com/feeds/worksheets/1zDOE-mIFctafOi_6ya6aF4yZNL0IxLBJNedHesgHEqY/public/values?alt=json". Double-check that the spreadsheet is published.BAD: No concept matches concept_id "hapiscore_whr", time_unit "year", fasttrackCatalogGeography "income-levels" in the fasttrack catalogBAD: Not allowed to access the requested Google Spreadsheet resource at "https://spreadsheets.google.com/feeds/worksheets/1zDOE-mIFctafOi_6ya6aF4yZNL0IxLBJNedHesgHEqY/public/values?alt=json". Double-check that the spreadsheet is published.
53
54
#Validation
55
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
56
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
57
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)
58
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
59
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)
60
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
61
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)
62
8
output-sheet:data-for-4ilevels-by-year
GOOD: The 'data-for-4ilevels-by-year' output sheet has at least 4 header columns
63
9
output-sheet:data-for-4ilevels-by-year
GOOD: The 'data-for-4ilevels-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
64
10versionGOOD: Named range 'version' exists
65
11versionGOOD: 'Version:' is filled in
66
12versionGOOD: The version at 'Version:' starts with a v, followed by an integer
67
13dateGOOD: Named range 'date' exists
68
14dateGOOD: 'Updated:' is filled in
69
15gapmioGOOD: Named range 'gapmio' exists
70
16gapmioGOOD: 'Latest version online:' is filled in
71
17contributorsGOOD: Named range 'contributors' exists
72
18contributorsGOOD: 'Contributor(s) to this version:' is filled in
73
19indicator_tableGOOD: Named range 'indicator_table' exists
74
20indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
75
21indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
76
22indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
77
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"
78
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"
79
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"
80
26
indicator_table:row_1:data-for-4ilevels-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-4ilevels-by-year' output sheet in column 4 as "=ABOUT!B11"
81
27indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
82
28indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)
83
29indicator_table:row_1GOOD: Indicator 1 has a unit (Column 5)
84
30indicator_table:row_1GOOD: Indicator 1's unit does not start or end with a space
85
31indicator_table:row_1GOOD: Indicator 1 has an ID (Column 6)
86
32indicator_table:row_1GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
87
33indicator_table:row_1GOOD: Indicator 1's ID has less than or equal to 20 characters
88
34indicator_table:row_1GOOD: Indicator 1 has a type set (Column 7)
89
35indicator_table:row_1GOOD: Indicator 1 has a usage level set (Column 8)
90
36dataset_descriptionGOOD: Named range 'dataset_description' exists
91
37dataset_descriptionGOOD: 'Dataset description:' is filled in
92
38source_urlGOOD: Named range 'source_url' exists
93
39source_urlGOOD: 'Link to documentation:' is filled in
94
40source_short_textGOOD: Named range 'source_short_text' exists
95
41source_short_textGOOD: 'Short source summary:' is filled in
96
42source_short_textGOOD: 'Short source summary:' has less than or equal to 45 characters
97
43source_tableGOOD: Named range 'source_table' exists
98
44source_tableGOOD: The named range 'source_table' covers the whole Sources table (the rows immediately above and below the table are empty)
99
45source_table:row_1GOOD: This first column of row '1' in the sources table is incremental (from 1 and up)
100
46source_table:row_1GOOD: Source 1 has a source id (Column 2)