code county former province area (km2) population
census 2009 capital
code
county
former province
area -lrb- km2 -rrb-
population census 2009
capital
number
number
number
number text text number number text
1 mombasa coast 212.5 939370 mombasa (city)
how many counties have a population greater than 500,000 ?
WRB JJ NNS VBD-AUX DT NN JJR IN CD .
3
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c5_number > 500000
Keyword Keyword Column None None Column Keyword Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c5_number ['comp', 'comp_greater'] ['comp', 'comp_greater']