no. in
series no. in
season title directed by written by original air date production
code u.s. viewers
(millions)
no . in series
no . in season
title
directed by
written by
original air date
production code
u.s. viewers -lrb- millions -rrb-
number
number
list length
number parsed year month day
number
number number text text <t,text> date text number
1 1 "pilot" jace alexander matt nix june 28, 2007 bn100 4
when was a title aired previous to july 5 , 2007 ?
WRB VBD-AUX DT NN VBD JJ TO NNP CD , CD .
June 28, 2007
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c3 from w where c6_parsed < ( select c6_parsed from w where c6 = 'july 5, 2007' ) order by c6_parsed desc limit 1
None None None Column Column Keyword Keyword Literal Literal Literal Literal None
c3 c6_parsed ['sort', 'sort_desc'] ['sort', 'sort_desc']