3.3.1. Data

A comprehensive analysis of 378 records of properties damaged by floods at a national level was carried out. These records come from the actual damage assessed by a flood expert surveyor and include the CCS compensation and the floodwater depth inside the property when available. The source of this data is from a number of floods that occurred during the period 2012 to 2018 and affected Spanish municipalities of different economic levels located across the Mediterranean (pluvial floods) and Cantabrian (fluvial floods) areas. Records from pluvial floods include damage caused by medium and lower water depths (up to 50 cm for ground floors), while those from fluvial floods contain losses originating from high floodwater depths (up to 100 cm) inside the properties. Among the available information was the type of asset damaged: a) building, b) furniture and household furnishings, and c) inventory. It has to be noted that not all insurance policies cover both the structure (building) and the contents (furniture and household furnishings, and inventory). For instance, the tenant may pay only for the coverage of furniture and household furnishings, and there could be no inventory to insure. Therefore, not all 378 records provide data for the three types of assets that are "potentially insurable." In this way, the useful data can be classified into: 354 records for buildings, 242 records for furniture and household furnishings, and 98 records for the inventory. Regarding the floodwater depth inside the property, 52 different depths from 1 cm to 280 cm were available. Water depths were distributed as follows: 43% (163) up to 10 cm, 46% (147) between 10 and 50 cm, 8% (30) between 50 and 100 cm, and 3% (11) corresponding to depths higher to 100 cm. Table 3 presents a summary of the records available, grouped by type of asset and property.
