date name nationality tonnage
(grt) fate
date
name
nationality
tonnage -lrb- grt -rrb-
fate
number parsed year month day
number
date text text number text
7 october 1941 svend foyn united kingdom 14795 damaged
how many united kingdom ships were sunk after 1941 ?
WRB JJ NNP NNP NNS VBD-AUX VBN IN CD .
3
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.String Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3 = 'united kingdom' and c5 = 'sunk' and c1_year > 1941
Keyword Keyword Literal Literal Column None Literal Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['comp', 'comp_greater']