AI-Enhanced Disaster And Health Threats Storylines by European Commission Joint Research Centre (JRC) | Academic Research

About this Dataset

AI-Enhanced Disaster And Health Threats Storylines

This dataset complements Health Threats and Disaster event data through generative AI techniques, including the use of Retrieval Augmented Generation (RAG) with the Europe Media Monitoring (EMM) service (https://emm.newsbrief.eu/overview.html), and Large Language Models (LLMs) from the GPT@JRC portfolio (https://gpt.jrc.ec.europa.eu/). It draws from sources like the EM-DAT database (https://www.emdat.be/), augmenting each event with news-derived information in a storytelling fashion. The dataset has been constructed using the EMM RAG service to retrieve relevant news chunks for each event data, transforming the unstructured news chunks into structured narratives and causal knowledge graphs using LLMs and text-to-graph techniques, linking health threats and disaster events to their causes and impacts. The dataset enables decision-makers to better explore health threats and disaster dynamics, identify patterns, and simulate scenarios for improved response and readiness.
Publisher name: Joint Research Centre
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/joint-research-centre
Last updated: 2025-02-12T09:38:15Z

Tables

AI-Enhanced Disaster And Health Threats Storylines

@ecjrc.n_747cf15b_87b4_4b92_a1be_10465c972929.ai_enhanced_disaster_and_health_threats_storylines

3.7 MB
2103 rows
58 columns


CREATE TABLE ai_enhanced_disaster_and_health_threats_storylines (
  "disno" VARCHAR,
  "historic" VARCHAR,
  "classification_key" VARCHAR,
  "disaster_group" VARCHAR,
  "disaster_subgroup" VARCHAR,
  "disaster_type" VARCHAR,
  "disaster_subtype" VARCHAR,
  "external_ids" VARCHAR,
  "event_name" VARCHAR,
  "iso" VARCHAR,
  "country" VARCHAR,
  "subregion" VARCHAR,
  "region" VARCHAR,
  "location" VARCHAR,
  "origin" VARCHAR,
  "associated_types" VARCHAR,
  "ofda_bha_response" VARCHAR,
  "appeal" VARCHAR,
  "declaration" VARCHAR,
  "aid_contribution_000_us" DOUBLE,
  "magnitude" DOUBLE,
  "magnitude_scale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "river_basin" VARCHAR,
  "start_year" BIGINT,
  "start_month" DOUBLE,
  "start_day" DOUBLE,
  "end_year" BIGINT,
  "end_month" DOUBLE,
  "end_day" DOUBLE,
  "total_deaths" DOUBLE,
  "no_injured" DOUBLE,
  "no_affected" DOUBLE,
  "no_homeless" DOUBLE,
  "total_affected" DOUBLE,
  "reconstruction_costs_000_us" DOUBLE,
  "reconstruction_costs_adjusted_000_us" DOUBLE,
  "insured_damage_000_us" DOUBLE,
  "insured_damage_adjusted_000_us" DOUBLE,
  "total_damage_000_us" DOUBLE,
  "total_damage_adjusted_000_us" DOUBLE,
  "cpi" DOUBLE,
  "admin_units" VARCHAR,
  "entry_date" TIMESTAMP,
  "last_update" TIMESTAMP,
  "start_dt" TIMESTAMP,
  "key_information" VARCHAR,
  "severity" VARCHAR,
  "key_drivers" VARCHAR,
  "main_impacts_exposure_and_vulnerability" VARCHAR,
  "likelihood_of_multi_hazard_risks" VARCHAR,
  "best_practices_for_managing_this_risk" VARCHAR,
  "recommendations_and_supportive_measures_for_recovery" VARCHAR,
  "causal_graph" VARCHAR,
  "llama_graph" VARCHAR,
  "mixtral_graph" VARCHAR,
  "ensemble_graph" VARCHAR
);