Saved in:
Bibliographic Details
Main Authors: Lampropoulos, Georgios, Palaiologos, Konstantinos, Raptis, Panagiotis Ioannis
Format: Recurso digital
Language:
Published: Zenodo 2025
Online Access:https://doi.org/10.5281/zenodo.17233353
Tags: Add Tag
No Tags, Be the first to tag this record!
Table of Contents:
  • <p>The following dataset was collected as part of the WP3.2 Quantifying societal impact and responses to weather risks work package of the <a href="https://www.oceanids-project.eu/">Oceanids</a> project. </p> <p>It consists of 3 files.</p> <ol> <li>events.json</li> <li>locations.json</li> <li>event_location.json</li> </ol> <h3>Events data</h3> <p>Events.json file includes a list of events and their corresponding data. The schema of the data is as follows:</p> <div dir="ltr"> <table style="border-collapse: collapse; width: 968px;"><colgroup><col style="width: 250px;"><col style="width: 325px;"><col style="width: 392px;"></colgroup> <tbody> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Field</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Data Type</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Description</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">event_type </p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Enum[flood, hurricane, storm_surge, earthquake, landslide, wildfire, heatwave, tornado, coastal_erosion, other]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The type of the event (e.g., hurricane, storm, flood, etc.).</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">name</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The designated name of the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">start_date</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">ISO-8601 String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The start date of the event in YYYY-MM-DD format.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">end_date</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">ISO-8601 String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The end date of the event in YYYY-MM-DD format (e.g., for hurricanes, this is the date of dissipation).</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">countries</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Array[String]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The list of countries that were directly affected by the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">areas_affected</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Array[String]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The list of specific subnational areas (e.g., provinces, states, districts, cities) that were directly impacted by the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">fatalities</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Integer</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The number of confirmed fatalities caused by the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">people_injured</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Integer</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The number of people who sustained non-fatal injuries due to the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">people_displaced</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Integer</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The number of people who were forced to leave their homes or shelters due to the event.</p> <br><br></td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">people_affected</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Integer</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The number of people who experienced negative consequences from the event (property damage, health impacts, or loss of access to essential services).</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">losses</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The estimated financial losses caused by the event. It contains the numerical value and the currency. All loss values correspond to the date of the event; no adjustment for inflation has been applied.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">infrastructure</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">A description of major infrastructure damage.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">agriculture</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">A description of damages that affected the agriculture sector (e.g., farms, crops) caused by the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">fisheries</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">A description of damages that affected the fisheries (e.g., fish population) caused by the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">tourism</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">A description of the consequences on the tourism sector caused by the event.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">public_health</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">A description of consequences on public health caused by the event(e.g., hospitalization due to illnesses, water contamination, psychological impacts).</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">sources</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Array[String]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The exact source(s) from which the event information was extracted.</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">key</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">A unique event identifier used for internal parsing and referencing.</p> </td> </tr> </tbody> </table> </div> <div dir="ltr"> </div> <h3>Locations Data</h3> <p>As seen in the events schema, a list of locations(countries, areas_affected) is related with it. Geojson data is collected for the locations mentioned in the events.json file and it is stored in the locations.json file.</p> <div dir="ltr"> <table style="border-collapse: collapse; width: 970px;"><colgroup><col style="width: 323px;"><col style="width: 323px;"><col style="width: 323px;"></colgroup> <tbody> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Field</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Datatype</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Description</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">key</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The key to a location</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">name</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The name of a location</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">region</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The region the location belongs to</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">country</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The country the location belongs to</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">coordinates</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Dict[type, coordinates]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">GeoJSON feature for coordinates. The type field’s value is Point</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">polygon</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Dict[type, coordinates]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Geojson feature for polygon, the type field’s value is either Polygon or MultiPolygon</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">multiline</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Dict[type, coordinates]</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Geojson feature for multiline. The type field’s value is either LineString or MultiLinestring.</p> </td> </tr> </tbody> </table> <h3>Event Location Association Table</h3> <p>Each event is associated with a list of locations. This association is done through the event_location.json file.</p> <div dir="ltr"> <table style="border-collapse: collapse; width: 975px;"><colgroup><col style="width: 324.667px;"><col style="width: 324.667px;"><col style="width: 324.667px;"></colgroup> <tbody> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Field</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Datatype</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">Description</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">event_key</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The key to an event</p> </td> </tr> <tr style="height: 0pt;"> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">location_key</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">String</p> </td> <td style="vertical-align: top; padding: 5pt 5pt 5pt 5pt;"> <p dir="ltr">The key to the corresponding location</p> </td> </tr> </tbody> </table> <p> </p> <p>For more info email at <strong><em>piraptis@wtoc.eu</em></strong></p> </div> </div>