Source workbook: Deaths by Natural Disasters __ #MakeoverMonday Week25.twb
Extract file: Data/Extracts/federated_0273qxf163rexv1b60wic0.hyper
Extract table columns: Entity, Code, Year, Pivot Field Names, Pivot Field Values
Disaster group mapping used in workbook: "Flood & Glacial lake outburst flood" =
  - "Deaths - Flood (decadal)"
  - "Deaths - Glacial lake outburst flood (decadal)"

Queried values (sum of the two pivot fields above) by country and year:
Country	1980	1990	2000	2010	2020
Australia	7.1	3.8	3.4	4.9	7.6
Brazil	159.8	38.6	86.6	161.6	184.2
Japan	41.6	10.3	11.3	37.5	20.4
New Zealand	0.6	0.0	0.4	0.1	0.8
United States	14.0	37.4	29.9	27.1	22.8

Detailed component values (Flood vs Glacial lake outburst flood):
Country: Australia
  1980: Deaths - Flood (decadal)=7.1; Deaths - Glacial lake outburst flood (decadal)=0.0
  1990: Deaths - Flood (decadal)=3.8; Deaths - Glacial lake outburst flood (decadal)=0.0
  2000: Deaths - Flood (decadal)=3.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  2010: Deaths - Flood (decadal)=4.9; Deaths - Glacial lake outburst flood (decadal)=0.0
  2020: Deaths - Flood (decadal)=7.6; Deaths - Glacial lake outburst flood (decadal)=0.0

Country: Brazil
  1980: Deaths - Flood (decadal)=159.8; Deaths - Glacial lake outburst flood (decadal)=0.0
  1990: Deaths - Flood (decadal)=38.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  2000: Deaths - Flood (decadal)=86.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  2010: Deaths - Flood (decadal)=161.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  2020: Deaths - Flood (decadal)=184.2; Deaths - Glacial lake outburst flood (decadal)=0.0

Country: Japan
  1980: Deaths - Flood (decadal)=41.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  1990: Deaths - Flood (decadal)=10.3; Deaths - Glacial lake outburst flood (decadal)=0.0
  2000: Deaths - Flood (decadal)=11.3; Deaths - Glacial lake outburst flood (decadal)=0.0
  2010: Deaths - Flood (decadal)=37.5; Deaths - Glacial lake outburst flood (decadal)=0.0
  2020: Deaths - Flood (decadal)=20.4; Deaths - Glacial lake outburst flood (decadal)=0.0

Country: New Zealand
  1980: Deaths - Flood (decadal)=0.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  1990: Deaths - Flood (decadal)=0.0; Deaths - Glacial lake outburst flood (decadal)=0.0
  2000: Deaths - Flood (decadal)=0.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  2010: Deaths - Flood (decadal)=0.1; Deaths - Glacial lake outburst flood (decadal)=0.0
  2020: Deaths - Flood (decadal)=0.8; Deaths - Glacial lake outburst flood (decadal)=0.0

Country: United States
  1980: Deaths - Flood (decadal)=14.0; Deaths - Glacial lake outburst flood (decadal)=0.0
  1990: Deaths - Flood (decadal)=37.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  2000: Deaths - Flood (decadal)=29.9; Deaths - Glacial lake outburst flood (decadal)=0.0
  2010: Deaths - Flood (decadal)=27.1; Deaths - Glacial lake outburst flood (decadal)=0.0
  2020: Deaths - Flood (decadal)=22.8; Deaths - Glacial lake outburst flood (decadal)=0.0