game day date kickoff opponent results
score results
record location attendance
game
day
date
kickoff
opponent
results score
results record
location
attendance
number
parsed year month day
number parsed year month day
number hour min
raw home
first second first_result first_number first_number1 first_number2
number number1 number2
number
number date date time text score(score) score text number
1 saturday november 9 7:05pm at detroit waza w 8-7 (ot) 1-0 melvindale civic center 545
what was the location before tri county soccerplex ?
WP VBD-AUX DT NN IN NNP NNP NNP .
Farm Show Arena
select c8 from w where id = ( select id from w where c8 = 'tri-county soccerplex' ) - 1