team outgoing manager manner of departure date of vacancy replaced by date of appointment position in table
team
outgoing manager
manner of departure
date of vacancy
replaced by
date of appointment
position in table
first second
number parsed year month day
number parsed year month day
number
text text text(text) date text date rank
crystal palace peter taylor mutual consent (hired by bolton wanderers) 8 october 2007 neil warnock 11 october 2007 19th
how long was there a vacancy at crystal palace ?
WRB RB VBD-AUX EX DT NN IN NN NN .
3 days
Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword
select ( select julianday ( c6_parsed ) from w where c1 = 'crystal palace' ) - ( select julianday ( c4_parsed ) from w where c1 = 'crystal palace' )
Column Column None None None Column None Literal Literal None
c4_parsed c4_parsed c4_parsed