_IHME-Suicides- Dataset - v1

	A	B	C	D	E	F	G	H
1		Suicides 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:	January 12 2021
5		Download latest version:	Excel file »
6		Latest version online:	http://gapm.io/dsuide
7		Contributor(s) to this version:	Jean U.
8		Feedback	Please give feedback here
9
10	#	Indicator(s)	Description	Full name	Unit	ID	type	Usage
11	1	Suicide rate	It is a mortality rate due to self-halm per 100 thousand standard population. This rate is estimated as if all countries have the same age composition of population.	Deaths from self-halm per 100 thousand people	Death rate	suirate	measure	2
12	2	Suicide rate 95% LUI (GBD)	Lower bound with 95% uncertainiy interval of the rate of suicide deaths.	Suicide rate 95% Uncertainty Interval - Lower Bound	Death rate	lb_suirate	measure	2
13	3	Suicide rate 95% UUI (GBD)	Upper bound with 95% uncertainiy interval of the rate of suicide deaths.	Suicide rate 95% Uncertainty Interval - Lower Bound	Death rate	ub_suirate	measure	2
14	4	Suicide deaths	It is a total number of mortality from self-halm per 100 thousand lives population.	Number of suicide deaths.	Deaths	suinum	measure	2
15	5	Suicide deaths 95% LUI (GBD)	Lower bound with 95% uncertainiy interval of suicide deaths.	Number of suicide deaths 95% Uncertainty Interval-Lower Bound	Deaths	lb_suinum	measure	2
16	6	Suicide deaths 95% UUI (GBD)	Upper bound with 95% uncertainiy interval of suicide deaths.	Number of suicide deaths 95% Uncertainty Interval- Upper Bound	Deaths	ub_suinum	measure	2
17
18		Sources
19		Dataset description:	The data is dowloaded from the Global Burden of Diseases study 2019 (GBD2019) that collected a bulk data on different causes of death for countries,regions and global. This data includes mortarity rate from self-halm per 100 thousand standard population and the total number of suicide deaths. It covers 2014 countries and territories from 1990 until 2019. All analyses are at the first level of administrative organization within each countriy. Gapminder presented the data for countries and territories on deaths from suicide per 100 thousand people and number of suicide deaths according to its geo-ids and names. The GBD 2019 estimated the 95% uncertaintainty interval (lower and upper uncertainty bounds) for the suicide rate and number of suicide deaths. We calculated number of suicides for four regions by aggregating data for countries' suicide deaths and the suicide rates for regions are computed as the average rates using total regional population. The data for the wolrd is presented from GBD with no changes.
20		Link to documentation:	http://gapm.io/dsuide
21		Short source summary:	IHME_GBD
22
23	#	Source id	Name	Link
24	1	gbd20	Global Burden of Diseases (GBD)- Institute for Health Metrics and Evaluation (IHME).	http://ghdx.healthdata.org
25	2	gppopv6	Gapminder-populationV6	https://docs.google.com/spreadsheets/d/1pxdiX93KuGUBVf1Oc4o0VME7T8uHst1jMErQupEXF3g/edit#gid=501532268
26
27		License
28		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/dsuide
29		License link:	Creative Common License CC BY 4.0
30		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.
31
32		Versions	Link	Changes compared to previous	Date	Contributors
33		v1	https://docs.google.com/spreadsheets/d/1S3lzH59UyWDPMNgtpyIlRDRudy7VVYuBGO10kuXZ7nk/edit#gid=501532268	First version	2021 January 12	Jean U.
34
35		Technical stuff
36		Dataset name:	Suicides
37		Dataset id:	suide
38		Doc url	https://docs.google.com/spreadsheets/d/1OCh0usKeo8n1cJIEkSyYK29Us761W9yi0Cb47AMMJqs/edit?ouid=114605220718412447890&urlBuilderDomain=gapminder.org
39		Doc id of work doc spreadsheet	1OCh0usKeo8n1cJIEkSyYK29Us761W9yi0Cb47AMMJqs
40		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.
41		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.
42		Read more:	gapm.io/dataworks
43			CHART PREVIEWS
44	[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=Suicide%20rate&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//1OCh0usKeo8n1cJIEkSyYK29Us761W9yi0Cb47AMMJqs//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
45			Suicide%20rate
46		DDF mapping:	schema for indicator table
47		concept_id	6
48		name_short	2
49		name	4
50		description	3
51		unit	5
52		type	7
53		usage	8
54
55		Catalog status	Indicator ID	Time unit	Countries etc	Regions	In. Levels	World
56		Suicide rate	suirate	year	GOOD	GOOD	-	GOOD
57
58	#	Validation
59	1	output-sheets	GOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
60	2	output-sheet:data-for-world-by-year	GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
61	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)
62	4	output-sheet:data-for-regions-by-year	GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
63	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)
64	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
65	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)
66	8	output-sheet:data-for-4ilevels-by-year	GOOD: The 'data-for-4ilevels-by-year' output sheet has at least 4 header columns
67	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)
68	10	version	GOOD: Named range 'version' exists
69	11	version	GOOD: 'Version:' is filled in
70	12	version	GOOD: The version at 'Version:' starts with a v, followed by an integer
71	13	date	GOOD: Named range 'date' exists
72	14	date	GOOD: 'Updated:' is filled in
73	15	gapmio	GOOD: Named range 'gapmio' exists
74	16	gapmio	GOOD: 'Latest version online:' is filled in
75	17	contributors	GOOD: Named range 'contributors' exists
76	18	contributors	GOOD: 'Contributor(s) to this version:' is filled in
77	19	indicator_table	GOOD: Named range 'indicator_table' exists
78	20	indicator_table	GOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
79	21	indicator_table:row_1	GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
80	22	indicator_table:row_1	GOOD: Indicator 1 has a short indicator name (Column 2)
81	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"
82	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"
83	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"
84	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"
85	27	indicator_table:row_1	GOOD: Indicator 1 has a description (Column 3)
86	28	indicator_table:row_1	GOOD: Indicator 1 has a full name (Column 4)
87	29	indicator_table:row_1	GOOD: Indicator 1 has a unit (Column 5)
88	30	indicator_table:row_1	GOOD: Indicator 1's unit does not start or end with a space
89	31	indicator_table:row_1	GOOD: Indicator 1 has an ID (Column 6)
90	32	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)
91	33	indicator_table:row_1	GOOD: Indicator 1's ID has less than or equal to 20 characters
92	34	indicator_table:row_1	GOOD: Indicator 1 has a type set (Column 7)
93	35	indicator_table:row_1	GOOD: Indicator 1 has a usage level set (Column 8)
94	36	indicator_table:row_2	GOOD: This first column of row '2' in the indicator(s) table is incremental (from 1 and up)
95	37	indicator_table:row_2	GOOD: Indicator 2 has a short indicator name (Column 2)
96	38	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"
97	39	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"
98	40	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"
99	41	indicator_table:row_2:data-for-4ilevels-by-year	GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-4ilevels-by-year' output sheet in column 5 as "=ABOUT!B12"
100	42	indicator_table:row_2	GOOD: Indicator 2 has a description (Column 3)