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
what is the other location after frisco tx
WP VBD-AUX DT JJ NN IN NNP NNP
CHNShanghai
select c3 from w where c2_parsed > ( select c2_parsed from w where c3 = 'usafrisco tx' ) order by c2_parsed limit 1