goal date location opponent lineup min assist/pass score result competition
goal
date
location
opponent
lineup
min
assist\\/pass
score
result
competition
number
number parsed year month day
number
number number1 number2
number number1 number2
number date text text text number text score score text
1 may 9, 2004 usaalbuquerque nm mexico on 70' (off lilly) 19 tarpley 3-0 3-0 friendly
who was the opponent faced when the first goal was scored in 2004 ?
WP VBD-AUX DT NN VBN WRB DT JJ NN VBD-AUX VBN IN CD .
Mexico
Keyword Column Keyword Keyword Keyword Column Keyword Literal.Number
select c4 from w where c1_number = 1
None None None Column None None None Literal Column None None None None None
c4 c1_number