date championship location category surface prev. result prev. points new points outcome
date
championship
location
category
surface
prev . result
prev . points
new points
outcome
minimum_number minimum_parsed minimum_day minimum_month minimum_year maximum_number maximum_parsed maximum_day maximum_month maximum_year
first second
first second
number
number
timespan text text(text) text text(text) text number number text
29 december 2013-
5 january 2014 brisbane international brisbane (aus) wta premier hard (i) sf 200 305 final
lost to serena williams 4-6, 5-7
what championship was played just before the us open ?
WDT NN VBD-AUX VBN RB IN DT NNP VB .
Western and Southern Open
Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword
select c2 from w where id = ( select id from w where c2 = 'us open' ) - 1
None Column None None Keyword Keyword None Literal Literal None
c2 ['before', 'before_minus'] ['before', 'before_minus']