Natural Disasters -Dataset V3

	A	B	C	D	E	F	G	H
1		Natural disasters Dataset - v3 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:	v3
4		Updated:	March 24 2020
5		Download latest version:	Excel file »
6		Latest version online:	http://gapm.io/dnatdisasters
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	Natural disaster deaths per year	This is the number of deaths from all natural disasters. The data includes all categories classified as "natural disasters" (distinguished from technological disasters, such as transport, industrial accidents,etc.. and complex disasters which include some major famine situation for which the drought were not the main causal factor). This includes total deaths from animal accident, droughts, earthquake, epidemic, extreme temperature, Flood, Fog, Impact, Insect infestation, Landslide, Mass movement (dry), Storm, Volcanic activity and Wildfire.	number of natural disasters deaths	deaths	ndisasd_tot	measure	2
12	2	Natural disaster deaths excluding epidemics, per year	This is the number of deaths from all natural disasters excluding epidemics.	number of disasters deaths, ecluding epidemics	deaths	ndisasd_noep_tot	measure	2
13	3	Natural disasters death rate per million people per year	This is the number of deaths from all natural disasters per million people	natural disasters deaths rate per million people	deaths	ndisasd_rate	measure	2
14	4	Natural disasters death rate, excluding epidemics per million people per year	This is the number of deaths from all natural disasters , excluding epidemics per million people.	natural disasters death rate, excluding epidemics per million people	deaths	ndisasd_noep_rate	measure	2
15
16		Sources
17		Dataset description:	Gapminder has copied data from EM-DAT The International Disaster Database (http://www.emdat.be/) with estimates of the number of deaths from natural disasters for all countries since 1900. These estimates include the following disaster types (as described here http://www.emdat.be/classification): Animal accident, Drought, Earthquake, Epidemic, Extreme temperature, Flood, Fog, Impact, Insect infestation, Landslide, Mass movement (dry), Storm, Volcanic activity, Wildfire Gapminder summed all death toll from these types of natural disasters for all countries to a world total per year. However as an epidemic may be controlled easily under certain circumstances and thus not turn into a disaster, we have also summed all tool from natural disasters excluding epidemics for all countries ro a wolrld total per year. To create the per capita version of this, we divided the numbers by the world population,average of the period, based on Gapminder Population v6. As disasters don't strike at an equal amount every year, the annual chart looks very uneven. To see the big picture more clearly, we calculated the average disaster deaths per decade, both in terms of death toll and death rate per million people. You can follow these calculations from the sheet to the right to the output in the sheet called Data world decade.
18		Link to documentation:	http://gapm.io/dnatdisasters
19		Short source summary:	GM based on EM-DAT
20
21	#	Source id	Name	Link
22	1	emdat19	EM-DAT's disaster deaths estimates	http://emdat.be/emdat_db/
23	2	GMpop	Gapminder's population estimates version 6	https://www.gapminder.org/data/documentation/gd003/
24
25		License
26		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/dnatdisasters
27		License link:	Creative Common License CC BY 4.0
28		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.
29
30		Versions	Link	Changes compared to previous	Date	Contributors
31		v1	https://docs.google.com/spreadsheets/d/11nRXQ7T_szwJvIrnx8db35P72I7RwwmYLc1MMG4GrQE/edit#gid=1192029559	First version	2018April17	Ola Rosling
32		v2	https://docs.google.com/spreadsheets/d/1v5BSgA2pwU4kKNO0EmkeemV-T5ifH6gbEM6FulDu7JE/edit#gid=1282928700	New data from EM-DAT	2019 February 21	Diane I
33		v3	https://docs.google.com/spreadsheets/d/1puFF7J4Kb_W6PWC1ZTXIwfsQCMBvs4zLRlttYZcJbYQ/edit#gid=1282928700	New data for 2019 from EM-DAT	2020 March 24	Diane I
34
35		Technical stuff
36		Dataset name:	Natural disasters
37		Dataset id:	natdisasters
38		Doc url	https://docs.google.com/spreadsheets/d/1puFF7J4Kb_W6PWC1ZTXIwfsQCMBvs4zLRlttYZcJbYQ/edit#gid=1282928700
39		Doc id of work doc spreadsheet	1puFF7J4Kb_W6PWC1ZTXIwfsQCMBvs4zLRlttYZcJbYQ
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;&marker$axis_x$which=income_per_person_gdppercapita_ppp_inflation_adjusted&scaleType=log&spaceRef:null;&axis_y$data=data_&which=Natural%20disaster%20deaths%20per%20year&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//1puFF7J4Kb_W6PWC1ZTXIwfsQCMBvs4zLRlttYZcJbYQ//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
45			Natural%20disaster%20deaths%20per%20year
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		Natural disaster deaths per year	ndisasd_tot	year	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)	-	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)
57		Natural disaster deaths excluding epidemics, per year	ndisasd_noep_tot	year	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)	-	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)
58		Natural disasters death rate per million people per year	ndisasd_rate	year	-	-	-	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)
59		Natural disasters death rate, excluding epidemics per million people per year	ndisasd_noep_rate	year	-	-	-	BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)
60
61	#	Validation
62	1	output-sheets	GOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
63	2	output-sheet:data-for-world-by-decade	GOOD: The 'data-for-world-by-decade' output sheet has at least 4 header columns
64	3	output-sheet:data-for-world-by-decade	GOOD: The 'data-for-world-by-decade' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
65	4	output-sheet:data-for-world-by-year	GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
66	5	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)
67	6	output-sheet:data-for-regions-by-year	GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
68	7	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)
69	8	output-sheet:data-for-countries-etc-by-year	GOOD: The 'data-for-countries-etc-by-year' output sheet has at least 4 header columns
70	9	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)
71	10	version	GOOD: Named range 'version' exists
72	11	version	GOOD: 'Version:' is filled in
73	12	version	GOOD: The version at 'Version:' starts with a v, followed by an integer
74	13	date	GOOD: Named range 'date' exists
75	14	date	GOOD: 'Updated:' is filled in
76	15	gapmio	GOOD: Named range 'gapmio' exists
77	16	gapmio	GOOD: 'Latest version online:' is filled in
78	17	contributors	GOOD: Named range 'contributors' exists
79	18	contributors	GOOD: 'Contributor(s) to this version:' is filled in
80	19	indicator_table	GOOD: Named range 'indicator_table' exists
81	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)
82	21	indicator_table:row_1	GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
83	22	indicator_table:row_1	GOOD: Indicator 1 has a short indicator name (Column 2)
84	23	indicator_table:row_1:data-for-world-by-decade	GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-world-by-decade' output sheet in column 4 as "=ABOUT!B11"
85	24	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	25	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	26	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	27	indicator_table:row_1	GOOD: Indicator 1 has a description (Column 3)
89	28	indicator_table:row_1	GOOD: Indicator 1 has a full name (Column 4)
90	29	indicator_table:row_1	GOOD: Indicator 1 has a unit (Column 5)
91	30	indicator_table:row_1	GOOD: Indicator 1's unit does not start or end with a space
92	31	indicator_table:row_1	GOOD: Indicator 1 has an ID (Column 6)
93	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)
94	33	indicator_table:row_1	GOOD: Indicator 1's ID has less than or equal to 20 characters
95	34	indicator_table:row_1	GOOD: Indicator 1 has a type set (Column 7)
96	35	indicator_table:row_1	GOOD: Indicator 1 has a usage level set (Column 8)
97	36	indicator_table:row_2	GOOD: This first column of row '2' in the indicator(s) table is incremental (from 1 and up)
98	37	indicator_table:row_2	GOOD: Indicator 2 has a short indicator name (Column 2)
99	38	indicator_table:row_2:data-for-world-by-decade	GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-world-by-decade' output sheet in column 5 as "=ABOUT!B12"
100	39	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"