cnct_vita_ForestEurope_forest_area_with_damage

SELECT 
  NUTS_CODE,
  country,
  forest,
  other_wooded_land,
  total_forest_and_other_wooded_land,
  units,
  CASE
    WHEN variable='Abiotic agents' THEN 'Abiotic agents \r\n(storm, wind, snow, etc.)'
	WHEN variable LIKE '%insects and disease%' THEN 'Insects and diseases'
	WHEN variable LIKE '%Wildlife and grazing%' THEN 'Wildlife and grazing'
	WHEN variable LIKE '%Forest operations%' THEN 'Forest operations'
	WHEN variable LIKE '%Fire%' THEN 'Fire'
	WHEN variable LIKE '%Other%' THEN 'Other'
	ELSE 'Unspecified'
  END AS variable,
  year
FROM FISE.latest.v_vita_ForestEurope_forest_area_with_damage
WHERE year=2015 AND variable NOT IN ('Fire: Of which human induced','Total area with damage') AND NUTS_CODE='EU27'