Terrorist Attacks Data Since 1970-2023

CREATE TABLE terrorist_attacks (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "terrorist_attacks" BIGINT,
  "terrorism_deaths" BIGINT,
  "attack_method_hijacking" BIGINT  -- Attack Method: Hijacking,
  "attack_method_hostage_taking_barricade_incident" BIGINT  -- Attack Method: Hostage Taking (Barricade Incident),
  "attack_method_unarmed_assault" BIGINT  -- Attack Method: Unarmed Assault,
  "attack_method_facility_infrastructure_attack" BIGINT  -- Attack Method: Facility/Infrastructure Attack,
  "attack_method_hostage_taking_kidnapping" BIGINT  -- Attack Method: Hostage Taking (Kidnapping),
  "attack_method_assassination" BIGINT  -- Attack Method: Assassination,
  "attack_method_armed_assault" BIGINT  -- Attack Method: Armed Assault,
  "attack_method_bombing_explosion" BIGINT  -- Attack Method: Bombing/Explosion,
  "death_age_100" BIGINT  -- Death Age 100+,
  "death_age_51_99" BIGINT  -- Death Age: 51-99,
  "death_age_21_50" BIGINT  -- Death Age : 21-50,
  "death_age_11_20" BIGINT  -- Death Age : 11-20,
  "death_age_6_10" BIGINT  -- Death Age : 6-10,
  "death_age_1_5" BIGINT  -- Death Age : 1-5,
  "terrorist_death_type_suicide" BIGINT  -- Terrorist Death Type : Suicide,
  "terrorist_death_type_killed" BIGINT  -- Terrorist Death Type : Killed
);