year competition venue position notes
year
competition
venue
position
notes
number
address
number
number text address rank text
1994 commonwealth games victoria, canada 6th 400 m h
what venue came before gothenburg , sweden ?
WDT NN VBD IN NNP , NNP .
Victoria, Canada
Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword
select c3 from w where id = ( select id from w where c3 = 'gothenburg, sweden' ) - 1
None Column Keyword Keyword Literal Literal Literal None
c3 ['before', 'before_minus'] ['before', 'before_minus']