Mandera East Constituency

Mandera East Constituency is an electoral constituency in Kenya. It is one of six constituencies in Mandera County. The constituency was established for the 1966 elections. The constituency is largely settled by the Murule community.

Members of Parliament

Elections MP [1] Party Notes
1966Sayid Mohamed AminKANU
1969Sayid Mohamed AminKANUOne-party system
1974Mohamed Sheikh AdenKANUOne-party system
1979Mohamed Sheikh AdenKANUOne-party system
1983Adan Mohamed NooruKANUOne-party system.
1988Mohamed Sheikh AdenKANUOne-party system.
1992Abdullahi Sheikh AhmedPICK
1994Isaack Ali ShaabanKANUBy-election
1997Isaack Ali ShaabanKANU
2002Isaack Ali ShaabanKANU
2007Mohamed Hussein AliODM
2013 Abdulaziz Ali arahURP
2017Omar Mohamed - omar sallaEFP

Wards

Wards
Ward Registered Voters Local Authority
Barwako1,045Mandera town
Border Point One1,224Mandera town
Bula Mpya3,005Mandera town
Bulla Jamhuria4,106Mandera town
Neboi750Mandera town
Shaf Shafey1,163Mandera town
Township Kamoro3,372Mandera town
Alango Gof1,162Mandera county
Arabia1,646Mandera county
Bur Abor / Bula Haji1,092Mandera county
Fino809Mandera county
Hareri1,770Mandera county
Kalaliyo East1,962Mandera county
Kalaliyo West2,319Mandera county
Lafey2,348Mandera county
Libehia1,567Mandera county
Waranqara1,739Mandera county
Total31,079
*September 2005.[2]
gollark: Slower, even.
gollark: Oops, it turns out I'm accidentally sorting by it instead of the rank, but it's equally slow after fixing that.
gollark: ```nonlocality=# EXPLAIN ANALYZE SELECT url, ts_rank(fts, query), ts_headline(fts::text, query, 'MaxWords=60') AS rank FROM pages, websearch_to_tsquery('bee') query WHERE fts @@ query ORDER BY rank LIMIT 1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=860.92..860.92 rows=1 width=96) (actual time=8506.425..8506.427 rows=1 loops=1) -> Sort (cost=860.92..861.05 rows=52 width=96) (actual time=8506.423..8506.425 rows=1 loops=1) Sort Key: (ts_headline((pages.fts)::text, query.query, 'MaxWords=60'::text)) Sort Method: top-N heapsort Memory: 25kB -> Nested Loop (cost=688.65..860.66 rows=52 width=96) (actual time=1.362..8505.403 rows=348 loops=1) -> Function Scan on websearch_to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.023..0.025 rows=1 loops=1) -> Bitmap Heap Scan on pages (cost=688.40..846.49 rows=52 width=142) (actual time=0.353..1.502 rows=348 loops=1) Recheck Cond: (fts @@ query.query) Heap Blocks: exact=231 -> Bitmap Index Scan on page_search_index (cost=0.00..688.39 rows=52 width=0) (actual time=0.320..0.320 rows=387 loops=1) Index Cond: (fts @@ query.query) Planning Time: 0.190 ms Execution Time: 8506.463 ms(13 rows)```
gollark: It's not a condition, it's an extra row on the output, and I can see exactly what it does via `EXPLAIN ANALYZE`.
gollark: Maybe I need a better full text search backend?!

References

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.