# date venue opponent score result competition
#
date
venue
opponent
score
result
competition
number
number parsed year month day
address
number number1 number2
number number1 number2
number date address text score score text
1 16 november 2005 tehelne pole, bratislava, slovakia spain 1-0 1-1 2006 fifa world cup play-offs
how many goals were scored against spain on november 2005 ?
WRB JJ NNS VBD-AUX VBN IN NNP IN NNP CD .
1
Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.String
select c5_number1 from w where c2 = '16 november 2005' and c4 = 'spain'
Column Column Column None None Column Literal Column Literal Literal None
c5_number1 c5_number1 c5_number1 c4 c2