Untitled

From Anonymous, 1 Day ago, written in Plain Text, viewed 3 times. This paste will bite the big one in 3 Weeks.
URL https://paste.intergen.online/view/6a41b512 Embed
Download Paste or View Raw
  1. Source workbook: Deaths by Natural Disasters __ #MakeoverMonday Week25.twb
  2. Extract file: Data/Extracts/federated_0273qxf163rexv1b60wic0.hyper
  3. Extract table columns: Entity, Code, Year, Pivot Field Names, Pivot Field Values
  4. Disaster group mapping used in workbook: "Flood & Glacial lake outburst flood" =
  5.   - "Deaths - Flood (decadal)"
  6.   - "Deaths - Glacial lake outburst flood (decadal)"
  7.  
  8. Queried values (sum of the two pivot fields above) by country and year:
  9. Country 1980    1990    2000    2010    2020
  10. Australia       7.1     3.8     3.4     4.9     7.6
  11. Brazil  159.8   38.6    86.6    161.6   184.2
  12. Japan   41.6    10.3    11.3    37.5    20.4
  13. New Zealand     0.6     0.0     0.4     0.1     0.8
  14. United States   14.0    37.4    29.9    27.1    22.8
  15.  
  16. Detailed component values (Flood vs Glacial lake outburst flood):
  17. Country: Australia
  18.   1980: Deaths - Flood (decadal)=7.1; Deaths - Glacial lake outburst flood (decadal)=0.0
  19.   1990: Deaths - Flood (decadal)=3.8; Deaths - Glacial lake outburst flood (decadal)=0.0
  20.   2000: Deaths - Flood (decadal)=3.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  21.   2010: Deaths - Flood (decadal)=4.9; Deaths - Glacial lake outburst flood (decadal)=0.0
  22.   2020: Deaths - Flood (decadal)=7.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  23.  
  24. Country: Brazil
  25.   1980: Deaths - Flood (decadal)=159.8; Deaths - Glacial lake outburst flood (decadal)=0.0
  26.   1990: Deaths - Flood (decadal)=38.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  27.   2000: Deaths - Flood (decadal)=86.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  28.   2010: Deaths - Flood (decadal)=161.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  29.   2020: Deaths - Flood (decadal)=184.2; Deaths - Glacial lake outburst flood (decadal)=0.0
  30.  
  31. Country: Japan
  32.   1980: Deaths - Flood (decadal)=41.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  33.   1990: Deaths - Flood (decadal)=10.3; Deaths - Glacial lake outburst flood (decadal)=0.0
  34.   2000: Deaths - Flood (decadal)=11.3; Deaths - Glacial lake outburst flood (decadal)=0.0
  35.   2010: Deaths - Flood (decadal)=37.5; Deaths - Glacial lake outburst flood (decadal)=0.0
  36.   2020: Deaths - Flood (decadal)=20.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  37.  
  38. Country: New Zealand
  39.   1980: Deaths - Flood (decadal)=0.6; Deaths - Glacial lake outburst flood (decadal)=0.0
  40.   1990: Deaths - Flood (decadal)=0.0; Deaths - Glacial lake outburst flood (decadal)=0.0
  41.   2000: Deaths - Flood (decadal)=0.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  42.   2010: Deaths - Flood (decadal)=0.1; Deaths - Glacial lake outburst flood (decadal)=0.0
  43.   2020: Deaths - Flood (decadal)=0.8; Deaths - Glacial lake outburst flood (decadal)=0.0
  44.  
  45. Country: United States
  46.   1980: Deaths - Flood (decadal)=14.0; Deaths - Glacial lake outburst flood (decadal)=0.0
  47.   1990: Deaths - Flood (decadal)=37.4; Deaths - Glacial lake outburst flood (decadal)=0.0
  48.   2000: Deaths - Flood (decadal)=29.9; Deaths - Glacial lake outburst flood (decadal)=0.0
  49.   2010: Deaths - Flood (decadal)=27.1; Deaths - Glacial lake outburst flood (decadal)=0.0
  50.   2020: Deaths - Flood (decadal)=22.8; Deaths - Glacial lake outburst flood (decadal)=0.0
  51.  

Reply to "Untitled"

Here you can reply to the paste above