date sub flight dead hurt pax. type perpetrator description
date
sub
flight
dead
hurt
pax .
type
perpetrator
description
number parsed year month day
number
number
number
first second
date number text number number number text text(text) text
18-feb-69 el al - 432
ams → zrh → tlv 1 8 28 grenade & small arms fire pflp (palestinian nationalists) -ground. zurich kloten airport, switzerland
an el al operated boeing 720-058b is attacked by a squad of four armed militants while it was preparing for takeoff at the zurich international airport in kloten. at least 8 passengers and crew were injured during the attack and co-pilot, yoram peres, died of his wounds a month later. the plane was severely damaged. a greater disaster was averted when an undercover israeli security agent stationed on the plane, opened fire at the attackers and killed the squad leader
how many people were killed in total in the attacks in 1973 and 1974 ?
WRB JJ NNS VBD-AUX VBN IN NN IN DT NNS IN CD CC CD .
90
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Literal.Number Keyword Literal.Number Keyword
select sum ( c4_number ) from w where c1_year in ( 1973 , 1974 )
Keyword Keyword None None Column Keyword Keyword None None None Column Literal Keyword Literal None
['agg', 'agg_sum'] ['agg', 'agg_sum'] c4_number ['agg', 'agg_sum'] ['agg', 'agg_sum'] c1_year ['conj', 'conj_or']