week date opponent time game site tv result/score record bye
week
date
opponent
time
game site
tv
result/score
record
bye
number
number parsed year month day
number hour min
result number number1 number2
number number1 number2
number date text time text text score score text
1 september 6, 2007 indianapolis colts 8:30 pm edt rca dome nbc l 41 - 10 0-1
which opponent was the last opponent to play at the soldier field ?
WDT NN VBD-AUX DT JJ NN TO VB IN DT NN NN .
Chicago Bears
select c3 from w where c5 = 'soldier field' order by c2_parsed desc limit 1