district senator party caucus first elected counties represented
district
senator
party
caucus
first elected
counties represented
number
number
list length
number text text text number <c,text>
1 kenneth p. lavalle republican republican 1976 suffolk
how many republicans were elected after 2000 ?
WRB JJ NNPS VBD-AUX VBN IN CD .
17
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.Number
select count ( * ) from w where c3 = 'republican' and c5_number > 2000
Keyword Keyword Literal None Column Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c5_number ['comp', 'comp_greater']