name status population district former local authority
name
status
population
district
former local authority
number
list length
text text number text <n,text>
cronton civil parish 1379 knowsley whiston
rural district
how many civil parishes have population counts of at least 10,000 ?
WRB JJ JJ NNS VBD-AUX NN NNS IN IN JJS CD .
4
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.Number
select count ( * ) from w where c2 = 'civil parish' and c3_number >= 10000
Keyword Keyword Literal Literal None Column None None Keyword Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c3_number ['comp', 'comp_gequal'] ['comp', 'comp_gequal']