search

mysociety / pombola

GNU Affero General Public License v3.0
65 stars 41 forks source link

KE: Memberships with end date later than associated Place end date #2038

Open tmtmtmtm opened 8 years ago

tmtmtmtm commented 8 years ago

The following memberships have an associated 'Place' that is tied to a session that ends before the membership does:

 id  |           legal_name           | organisation |  end_date  |          area          |  end_date  |            name             
-----+--------------------------------+--------------+------------+------------------------+------------+-----------------------------
   1 | Abdikadir Hussein Mohamed      | Parliament   | 2013-03-04 | Mandera Central        | 2013-01-14 | National Assembly 2007-2013
   3 | Abu Mohamed Chiaba             | Parliament   | 2013-03-04 | Lamu East              | 2013-01-14 | National Assembly 2007-2013
   4 | Evans Bulimo Akula             | Parliament   | 2013-03-04 | Khwisero               | 2013-01-14 | National Assembly 2007-2013
   5 | John Olago Aluoch              | Parliament   | 2013-03-04 | Kisumu Town West       | 2013-01-14 | National Assembly 2007-2013
   6 | Peter Edick Omondi Anyanga     | Parliament   | 2013-03-04 | Nyatike                | 2013-01-14 | National Assembly 2007-2013
   7 | Pollyins Ochieng Anyango       | Parliament   | 2013-03-04 | Nyakach                | 2013-01-14 | National Assembly 2007-2013
   8 | Peter Njoroge Baiya            | Parliament   | 2013-03-04 | Githunguri             | 2013-01-14 | National Assembly 2007-2013
   9 | Najib Mohamed Balala           | Parliament   | 2013-03-04 | Mvita                  | 2013-01-14 | National Assembly 2007-2013
  10 | Francis S. K. Baya             | Parliament   | 2013-03-04 | Ganze                  | 2013-01-14 | National Assembly 2007-2013
  11 | Yusuf Kifuma Chanzu            | Parliament   | 2013-03-04 | Vihiga                 | 2013-01-14 | National Assembly 2007-2013
  12 | Peris Chepchumba               | Parliament   | 2013-03-04 | Eldoret South          | 2013-01-14 | National Assembly 2007-2013
  13 | Lucas Kipkosgei Chepkitony     | Parliament   | 2013-03-04 | Keiyo North            | 2013-01-14 | National Assembly 2007-2013
  14 | Zakayo Kipkemoi Cheruiyot      | Parliament   | 2013-03-04 | Kuresoi                | 2013-01-14 | National Assembly 2007-2013
  15 | Aden Bare Duale                | Parliament   | 2013-03-04 | Dujis                  | 2013-01-14 | National Assembly 2007-2013
  16 | Farah Maalim Mohamed           | Parliament   | 2013-03-04 | Lagdera                | 2013-01-14 | National Assembly 2007-2013
  17 | Nelson Ributhi Gaichuhie       | Parliament   | 2013-03-04 | Subukia                | 2013-01-14 | National Assembly 2007-2013
  18 | Francis Chachu Ganya           | Parliament   | 2013-03-04 | North Horr             | 2013-01-14 | National Assembly 2007-2013
  19 | James Ondicho Gesami           | Parliament   | 2013-03-04 | West Mugirango         | 2013-01-14 | National Assembly 2007-2013
  20 | Peter Njuguna Gitau            | Parliament   | 2013-03-04 | Mwea                   | 2013-01-14 | National Assembly 2007-2013
  21 | Stanley Munga Githunguri       | Parliament   | 2013-03-04 | Kiambaa                | 2013-01-14 | National Assembly 2007-2013
  22 | Gitobu Imanyara                | Parliament   | 2013-03-04 | Central Imenti         | 2013-01-14 | National Assembly 2007-2013
  23 | Dhadho Gaddae Godhana          | Parliament   | 2013-03-04 | Galole                 | 2013-01-14 | National Assembly 2007-2013
  24 | Nicholas Gumbo                 | Parliament   | 2013-03-04 | Rarieda                | 2013-01-14 | National Assembly 2007-2013
  25 | Benedict Fondo Gunda           | Parliament   | 2013-03-04 | Bahari                 | 2013-01-14 | National Assembly 2007-2013
  26 | Yusuf Mohammed Haji            | Parliament   | 2013-03-04 | Ijara                  | 2013-01-14 | National Assembly 2007-2013
  27 | Amason Jeffah Kingi            | Parliament   | 2013-03-04 | Magarini               | 2013-01-14 | National Assembly 2007-2013
  28 | Hellen Jepkemoi Sambili        | Parliament   | 2013-03-04 | Mogotio                | 2013-01-14 | National Assembly 2007-2013
  29 | Cyrus Khwa Shakhalaga Jirongo  | Parliament   | 2013-03-04 | Lugari                 | 2013-01-14 | National Assembly 2007-2013
  30 | Hassan Ali Joho                | Parliament   | 2013-03-04 | Kisauni                | 2013-01-14 | National Assembly 2007-2013
  31 | Kabando wa Kabando             | Parliament   | 2013-03-04 | Mukurweini             | 2013-01-14 | National Assembly 2007-2013
  32 | Boaz Kipchumba Kaino           | Parliament   | 2013-03-04 | Marakwet West          | 2013-01-14 | National Assembly 2007-2013
  33 | Margaret Jepkoech Kamar        | Parliament   | 2013-03-04 | Eldoret East           | 2013-01-14 | National Assembly 2007-2013
  34 | James Maina Kamau              | Parliament   | 2013-03-04 | Kandara                | 2013-01-14 | National Assembly 2007-2013
  35 | Jamleck Irungu Kamau           | Parliament   | 2013-03-04 | Kigumo                 | 2013-01-14 | National Assembly 2007-2013
  36 | Fred Chesebe Kapondi           | Parliament   | 2013-03-04 | Mt Elgon               | 2013-01-14 | National Assembly 2007-2013
  38 | Emilio Mureithi Kathuri        | Parliament   | 2013-03-04 | Manyatta               | 2013-01-14 | National Assembly 2007-2013
  39 | Samuel Kazungu Kambi           | Parliament   | 2013-03-04 | Kaloleni               | 2013-01-14 | National Assembly 2007-2013
  40 | Atanas Manyala Keya            | Parliament   | 2013-03-04 | Lurambi                | 2013-01-14 | National Assembly 2007-2013
  41 | Adan Wehliye Keynan            | Parliament   | 2013-03-04 | Wajir West             | 2013-01-14 | National Assembly 2007-2013
  42 | Alfred Khang'ati               | Parliament   | 2013-03-04 | Kanduyi                | 2013-01-14 | National Assembly 2007-2013
  43 | Emilio Mwai Kibaki             | Parliament   | 2013-03-04 | Othaya                 | 2013-01-14 | National Assembly 2007-2013
  44 | Luka Kipkorir Kigen            | Parliament   | 2013-03-04 | Rongai                 | 2013-01-14 | National Assembly 2007-2013
  45 | Peter L. N. Kiilu              | Parliament   | 2013-03-04 | Makueni                | 2013-01-14 | National Assembly 2007-2013
  46 | Charles Mutavi Kilonzo         | Parliament   | 2013-03-04 | Yatta                  | 2013-01-14 | National Assembly 2007-2013
  47 | Mutula Kilonzo                 | Parliament   | 2013-03-04 | Mbooni                 | 2013-01-14 | National Assembly 2007-2013
  48 | Lee Maiyani Kinyanjui          | Parliament   | 2013-03-04 | Nakuru Town            | 2013-01-14 | National Assembly 2007-2013
  49 | Jeremiah Ngayu Kioni           | Parliament   | 2013-03-04 | Ndaragwa               | 2013-01-14 | National Assembly 2007-2013
  50 | William Cheptumo Kipkiror      | Parliament   | 2013-03-04 | Baringo North          | 2013-01-14 | National Assembly 2007-2013
  51 | Magerer Kiprono Langat         | Parliament   | 2013-03-04 | Kipkelion              | 2013-01-14 | National Assembly 2007-2013
  52 | Jackson Kiplagat Kiptanui      | Parliament   | 2013-03-04 | Keiyo South            | 2013-01-14 | National Assembly 2007-2013
  53 | Julius Kipyegon Kones          | Parliament   | 2013-03-04 | Konoin                 | 2013-01-14 | National Assembly 2007-2013
  54 | Joseph Nganga Kiuna            | Parliament   | 2013-03-04 | Molo                   | 2013-01-14 | National Assembly 2007-2013
  55 | Lenny Maxwell Kivuti           | Parliament   | 2013-03-04 | Siakago                | 2013-01-14 | National Assembly 2007-2013
  56 | David Kibet Koech              | Parliament   | 2013-03-04 | Mosop                  | 2013-01-14 | National Assembly 2007-2013
  57 | Josephat Koli Nanok            | Parliament   | 2013-03-04 | Turkana South          | 2013-01-14 | National Assembly 2007-2013
  58 | Beatrice Pauline Cherono Kones | Parliament   | 2013-03-04 | Bomet                  | 2013-01-14 | National Assembly 2007-2013
  59 | Sally Jepngetich Kosgei        | Parliament   | 2013-03-04 | Aldai                  | 2013-01-14 | National Assembly 2007-2013
  60 | Mohammed Abdi Kuti             | Parliament   | 2013-03-04 | Isiolo North           | 2013-01-14 | National Assembly 2007-2013
  61 | Joshua Serem Kutuny            | Parliament   | 2013-03-04 | Cherangany             | 2013-01-14 | National Assembly 2007-2013
  62 | Philip Kyalo Kaloki            | Parliament   | 2013-03-04 | Kibwezi                | 2013-01-14 | National Assembly 2007-2013
  63 | Joyce Cherono Laboso           | Parliament   | 2013-03-04 | Sotik                  | 2013-01-14 | National Assembly 2007-2013
  64 | Elijah Kiptarbei Lagat         | Parliament   | 2013-03-04 | Emgwen                 | 2013-01-14 | National Assembly 2007-2013
  65 | Lankas ole Nkoidila            | Parliament   | 2013-03-04 | Narok South            | 2013-01-14 | National Assembly 2007-2013
  66 | Joseph Lemasolai Lekuton       | Parliament   | 2013-03-04 | Laisamis               | 2013-01-14 | National Assembly 2007-2013
  67 | Moses Lessonet                 | Parliament   | 2013-03-04 | Eldama Ravine          | 2013-01-14 | National Assembly 2007-2013
  68 | Raphael Lakalei Letimalo       | Parliament   | 2013-03-04 | Samburu East           | 2013-01-14 | National Assembly 2007-2013
  69 | Franklin Mithika Linturi       | Parliament   | 2013-03-04 | Igembe South           | 2013-01-14 | National Assembly 2007-2013
  70 | Wilson Mwotiny Litole          | Parliament   | 2013-03-04 | Sigor                  | 2013-01-14 | National Assembly 2007-2013
  71 | Justus Kizito Mugali           | Parliament   | 2013-03-04 | Shinyalu               | 2013-01-14 | National Assembly 2007-2013
  72 | Ntoitha M'mithiaru             | Parliament   | 2013-03-04 | Igembe North           | 2013-01-14 | National Assembly 2007-2013
  73 | Joseph Oyugi Magwanga          | Parliament   | 2013-03-04 | Kasipul Kabondo        | 2013-01-14 | National Assembly 2007-2013
  74 | Ali Mohamud Mohamed            | Parliament   | 2013-03-04 | Moyale                 | 2013-01-14 | National Assembly 2007-2013
  75 | Ephraim Mwangi Maina           | Parliament   | 2013-03-04 | Mathira                | 2013-01-14 | National Assembly 2007-2013
  76 | Gideon Mung'aro Maitha         | Parliament   | 2013-03-04 | Malindi                | 2013-01-14 | National Assembly 2007-2013
  77 | Esther Murugi Mathenge         | Parliament   | 2013-03-04 | Nyeri Town             | 2013-01-14 | National Assembly 2007-2013
  78 | Cecily Mutitu Mbarire          | Parliament   | 2013-03-04 | Runyenjes              | 2013-01-14 | National Assembly 2007-2013
  79 | Japhet M. Kareke Mbiuki        | Parliament   | 2013-03-04 | Nithi                  | 2013-01-14 | National Assembly 2007-2013
  80 | Gideon Mbuvi                   | Parliament   | 2013-03-04 | Makadara               | 2013-01-14 | National Assembly 2007-2013
  81 | Mohamed Hussein Ali            | Parliament   | 2013-03-04 | Mandera East           | 2013-01-14 | National Assembly 2007-2013
  82 | Mohamed Ibrahim Elmi           | Parliament   | 2013-03-04 | Wajir East             | 2013-01-14 | National Assembly 2007-2013
  83 | Robert Onsare Monda            | Parliament   | 2013-03-04 | Nyaribari Chache       | 2013-01-14 | National Assembly 2007-2013
  84 | Wycliffe Musalia Mudavadi      | Parliament   | 2013-03-04 | Sabatia                | 2013-01-14 | National Assembly 2007-2013
  85 | Beth Wambui Mugo               | Parliament   | 2013-03-04 | Dagoretti              | 2013-01-14 | National Assembly 2007-2013
  86 | Victor Kioko Munyaka           | Parliament   | 2013-03-04 | Machakos Town          | 2013-01-14 | National Assembly 2007-2013
  87 | Isaac Mulatya Muoki            | Parliament   | 2013-03-04 | Kitui South            | 2013-01-14 | National Assembly 2007-2013
  88 | Daniel Mutua Muoki             | Parliament   | 2013-03-04 | Mwala                  | 2013-01-14 | National Assembly 2007-2013
  89 | Erastus Kihara Mureithi        | Parliament   | 2013-03-04 | Ol Kalou               | 2013-01-14 | National Assembly 2007-2013
  90 | Julius Recha Murgor            | Parliament   | 2013-03-04 | Kapenguria             | 2013-01-14 | National Assembly 2007-2013
  91 | Ndiritu Muriithi               | Parliament   | 2013-03-04 | Laikipia West          | 2013-01-14 | National Assembly 2007-2013
  92 | Silas Muriuki Ruteere          | Parliament   | 2013-03-04 | North Imenti           | 2013-01-14 | National Assembly 2007-2013
  93 | Kiraitu Murungi                | Parliament   | 2013-03-04 | South Imenti           | 2013-01-14 | National Assembly 2007-2013
  94 | David Musila                   | Parliament   | 2013-03-04 | Mwingi South           | 2013-01-14 | National Assembly 2007-2013
  95 | Mutava Musyimi                 | Parliament   | 2013-03-04 | Gachoka                | 2013-01-14 | National Assembly 2007-2013
  96 | Johnson Nduya Muthama          | Parliament   | 2013-03-04 | Kangundo               | 2013-01-14 | National Assembly 2007-2013
  97 | John Michael Njenga Mututho    | Parliament   | 2013-03-04 | Naivasha               | 2013-01-14 | National Assembly 2007-2013
  98 | Thomas Ludindi Mwadeghu        | Parliament   | 2013-03-04 | Wundanyi               | 2013-01-14 | National Assembly 2007-2013
  99 | Mwalimu Masoud Mwahima         | Parliament   | 2013-03-04 | Likoni                 | 2013-01-14 | National Assembly 2007-2013
 100 | Sammy Sila Komen Mwaita        | Parliament   | 2013-03-04 | Baringo Central        | 2013-01-14 | National Assembly 2007-2013
 101 | Danson Mwazo Mwakulegwa        | Parliament   | 2013-03-04 | Voi                    | 2013-01-14 | National Assembly 2007-2013
 102 | Barnabas Muturi C. Mwangi      | Parliament   | 2013-03-04 | Kiharu                 | 2013-01-14 | National Assembly 2007-2013
 103 | Andrew Calist Mwatela          | Parliament   | 2013-03-04 | Mwatate                | 2013-01-14 | National Assembly 2007-2013
 104 | Peter Mungai Mwathi            | Parliament   | 2013-03-04 | Limuru                 | 2013-01-14 | National Assembly 2007-2013
 105 | John Harun Mwau                | Parliament   | 2013-03-04 | Kilome                 | 2013-01-14 | National Assembly 2007-2013
 106 | David Njuguna Kiburi Mwaura    | Parliament   | 2013-03-04 | Lari                   | 2013-01-14 | National Assembly 2007-2013
 107 | Alex Muthengi Mburi Mwiru      | Parliament   | 2013-03-04 | Tharaka                | 2013-01-14 | National Assembly 2007-2013
 108 | Ababu Tawfiq Pius Namwamba     | Parliament   | 2013-03-04 | Budalangi              | 2013-01-14 | National Assembly 2007-2013
 109 | Wavinya Ndeti                  | Parliament   | 2013-03-04 | Kathiani               | 2013-01-14 | National Assembly 2007-2013
 110 | John Mbadi Ng'ong'o            | Parliament   | 2013-03-04 | Gwassi                 | 2013-01-14 | National Assembly 2007-2013
 111 | Charity Kaluki Ngilu           | Parliament   | 2013-03-04 | Kitui Central          | 2013-01-14 | National Assembly 2007-2013
 112 | David Mwaniki Ngugi            | Parliament   | 2013-03-04 | Kinangop               | 2013-01-14 | National Assembly 2007-2013
 113 | Lewis Nganga Nguyai            | Parliament   | 2013-03-04 | Kikuyu                 | 2013-01-14 | National Assembly 2007-2013
 114 | Nuh Nassir Abdi                | Parliament   | 2013-03-04 | Bura                   | 2013-01-14 | National Assembly 2007-2013
 115 | Charles Mutisya Nyamai         | Parliament   | 2013-03-04 | Kitui West             | 2013-01-14 | National Assembly 2007-2013
 116 | Walter Enock Osebe Nyambati    | Parliament   | 2013-03-04 | Kitutu Masaba          | 2013-01-14 | National Assembly 2007-2013
 117 | Francis Thombe Nyammo          | Parliament   | 2013-03-04 | Tetu                   | 2013-01-14 | National Assembly 2007-2013
 118 | Christopher Mogere Obure       | Parliament   | 2013-03-04 | Bobasi                 | 2013-01-14 | National Assembly 2007-2013
 119 | Alfred Bwire Odhiambo          | Parliament   | 2013-03-04 | Butula                 | 2013-01-14 | National Assembly 2007-2013
 120 | Martin Otieno Ogindo           | Parliament   | 2013-03-04 | Rangwe                 | 2013-01-14 | National Assembly 2007-2013
 121 | Cyprian Ojwang Omollo          | Parliament   | 2013-03-04 | Uriri                  | 2013-01-14 | National Assembly 2007-2013
 122 | Patrick Ayiecho Olweny         | Parliament   | 2013-03-04 | Muhoroni               | 2013-01-14 | National Assembly 2007-2013
 123 | Wilfred Moriasi Ombui          | Parliament   | 2013-03-04 | North Mugirango Borabu | 2013-01-14 | National Assembly 2007-2013
 124 | Samson Kegeo Ongeri            | Parliament   | 2013-03-04 | Nyaribari Masaba       | 2013-01-14 | National Assembly 2007-2013
 125 | Elizabeth Ongoro Masha         | Parliament   | 2013-03-04 | Kasarani               | 2013-01-14 | National Assembly 2007-2013
 126 | Charles Onyancha               | Parliament   | 2013-03-04 | Bonchari               | 2013-01-14 | National Assembly 2007-2013
 128 | Richard Momoima Onyonka        | Parliament   | 2013-03-04 | Kitutu Chache          | 2013-01-14 | National Assembly 2007-2013
 129 | Aggrey James Orengo            | Parliament   | 2013-03-04 | Ugenya                 | 2013-01-14 | National Assembly 2007-2013
 130 | Dalmas Anyango Otieno          | Parliament   | 2013-03-04 | Rongo                  | 2013-01-14 | National Assembly 2007-2013
 131 | Wilber Ottichilo Khasilwa      | Parliament   | 2013-03-04 | Emuhaya                | 2013-01-14 | National Assembly 2007-2013
 132 | Paul Nyongesa Otuoma           | Parliament   | 2013-03-04 | Funyula                | 2013-01-14 | National Assembly 2007-2013
 133 | Fredrick Otieno Outa           | Parliament   | 2013-03-04 | Nyando                 | 2013-01-14 | National Assembly 2007-2013
 134 | John Dache Pesa                | Parliament   | 2013-03-04 | Migori                 | 2013-01-14 | National Assembly 2007-2013
 135 | James Kwanya Rege              | Parliament   | 2013-03-04 | Karachuonyo            | 2013-01-14 | National Assembly 2007-2013
 136 | Isaac Kiprono Rutto            | Parliament   | 2013-03-04 | Chepalungu             | 2013-01-14 | National Assembly 2007-2013
 137 | Alfred B. Wekesa Sambu         | Parliament   | 2013-03-04 | Webuye                 | 2013-01-14 | National Assembly 2007-2013
 138 | Hussein Tarry Sasura           | Parliament   | 2013-03-04 | Saku                   | 2013-01-14 | National Assembly 2007-2013
 139 | Naomi Namisi Shaban            | Parliament   | 2013-03-04 | Taveta                 | 2013-01-14 | National Assembly 2007-2013
 140 | Ahmed Shakeel Shabbir Ahmed    | Parliament   | 2013-03-04 | Kisumu Town East       | 2013-01-14 | National Assembly 2007-2013
 141 | David Eseli Simiyu             | Parliament   | 2013-03-04 | Kimilili               | 2013-01-14 | National Assembly 2007-2013
 142 | Aden Ahmed Sugow               | Parliament   | 2013-03-04 | Fafi                   | 2013-01-14 | National Assembly 2007-2013
 145 | Yasin Fahim Twaha              | Parliament   | 2013-03-04 | Lamu West              | 2013-01-14 | National Assembly 2007-2013
 146 | Clement Kung'u Waibara         | Parliament   | 2013-03-04 | Gatundu North          | 2013-01-14 | National Assembly 2007-2013
 147 | Ferdinand Ndung'u Waititu      | Parliament   | 2013-03-04 | Embakasi               | 2013-01-14 | National Assembly 2007-2013
 148 | Eugene Ludovic Wamalwa         | Parliament   | 2013-03-04 | Saboti                 | 2013-01-14 | National Assembly 2007-2013
 149 | Clement Muchiri Wambugu        | Parliament   | 2013-03-04 | Mathioya               | 2013-01-14 | National Assembly 2007-2013
 150 | Nemesius Warugongo             | Parliament   | 2013-03-04 | Kieni                  | 2013-01-14 | National Assembly 2007-2013
 151 | Benjamin Jomo Washiali         | Parliament   | 2013-03-04 | Mumias                 | 2013-01-14 | National Assembly 2007-2013
 153 | David Aoko Were                | Parliament   | 2013-03-04 | Matungu                | 2013-01-14 | National Assembly 2007-2013
 154 | Edwin Ochieng Yinda            | Parliament   | 2013-03-04 | Alego                  | 2013-01-14 | National Assembly 2007-2013
 155 | Omar Mbwana Zonga              | Parliament   | 2013-03-04 | Msambweni              | 2013-01-14 | National Assembly 2007-2013
 156 | Abdul Bahari Ali Jillo         | Parliament   | 2013-03-04 | Isiolo South           | 2013-01-14 | National Assembly 2007-2013
 157 | Franklin Kipng'etich Bett      | Parliament   | 2013-03-04 | Bureti                 | 2013-01-14 | National Assembly 2007-2013
 158 | Ekwee David Ethuro             | Parliament   | 2013-03-04 | Turkana Central        | 2013-01-14 | National Assembly 2007-2013
 159 | Robinson Njeru Githae          | Parliament   | 2013-03-04 | Ndia                   | 2013-01-14 | National Assembly 2007-2013
 160 | Fredrick fidelis Omulo Gumo    | Parliament   | 2013-03-04 | Westlands              | 2013-01-14 | National Assembly 2007-2013
 162 | William Kabogo Gitau           | Parliament   | 2013-03-04 | Juja                   | 2013-01-14 | National Assembly 2007-2013
 163 | Ramadhan Seif Kajembe          | Parliament   | 2013-03-04 | Changamwe              | 2013-01-14 | National Assembly 2007-2013
 164 | Gerald Otieno Kajwang          | Parliament   | 2013-03-04 | Mbita                  | 2013-01-14 | National Assembly 2007-2013
 165 | Asman Abongutum Kamama         | Parliament   | 2013-03-04 | Baringo East           | 2013-01-14 | National Assembly 2007-2013
 166 | Martha Wangari Karua           | Parliament   | 2013-03-04 | Gichugu                | 2013-01-14 | National Assembly 2007-2013
 167 | Peter Kenneth                  | Parliament   | 2013-03-04 | Gatanga                | 2013-01-14 | National Assembly 2007-2013
 168 | Uhuru Muigai Kenyatta          | Parliament   | 2013-03-04 | Gatundu South          | 2013-01-14 | National Assembly 2007-2013
 169 | Charles Cheruiyot Keter        | Parliament   | 2013-03-04 | Belgut                 | 2013-01-14 | National Assembly 2007-2013
 170 | Bonny Khalwale                 | Parliament   | 2013-03-04 | Ikolomani              | 2013-01-14 | National Assembly 2007-2013
 171 | George Munyasa khaniri         | Parliament   | 2013-03-04 | Hamisi                 | 2013-01-14 | National Assembly 2007-2013
 172 | Julius Kiema Kilonzo           | Parliament   | 2013-03-04 | Mutito                 | 2013-01-14 | National Assembly 2007-2013
 173 | Linah Jebii Kilimo             | Parliament   | 2013-03-04 | Marakwet East          | 2013-01-14 | National Assembly 2007-2013
 174 | Amos Muhinga Kimunya           | Parliament   | 2013-03-04 | Kipipiri               | 2013-01-14 | National Assembly 2007-2013
 175 | Festus Mwangi Kiunjuri         | Parliament   | 2013-03-04 | Laikipia East          | 2013-01-14 | National Assembly 2007-2013
 177 | Henry Kiprono Kosgey           | Parliament   | 2013-03-04 | Tinderet               | 2013-01-14 | National Assembly 2007-2013
 178 | Simon Saimanga Lesirma         | Parliament   | 2013-03-04 | Samburu West           | 2013-01-14 | National Assembly 2007-2013
 179 | Wilfred Gisuka Machage         | Parliament   | 2013-03-04 | Kuria                  | 2013-01-14 | National Assembly 2007-2013
 181 | Benson Itwiku Mbai             | Parliament   | 2013-03-04 | Masinga                | 2013-01-14 | National Assembly 2007-2013
 182 | Elias Peter Mbau               | Parliament   | 2013-03-04 | Maragwa                | 2013-01-14 | National Assembly 2007-2013
 184 | Washington Jakoyo Midiwo       | Parliament   | 2013-03-04 | Gem                    | 2013-01-14 | National Assembly 2007-2013
 185 | Danson Buya Mungatana          | Parliament   | 2013-03-04 | Garsen                 | 2013-01-14 | National Assembly 2007-2013
 186 | Peter Munya Gatirau            | Parliament   | 2013-03-04 | Tigania East           | 2013-01-14 | National Assembly 2007-2013
 187 | John Kiyonga Munyes            | Parliament   | 2013-03-04 | Turkana North          | 2013-01-14 | National Assembly 2007-2013
 188 | Stephen Kalonzo Musyoka        | Parliament   | 2013-03-04 | Mwingi North           | 2013-01-14 | National Assembly 2007-2013
 189 | Chirau Ali Mwakwere            | Parliament   | 2013-03-04 | Matuga                 | 2013-01-14 | National Assembly 2007-2013
 190 | Valerian Kilemi Mwiria         | Parliament   | 2013-03-04 | Tigania West           | 2013-01-14 | National Assembly 2007-2013
 191 | Gideon Musyoka Ndambuki        | Parliament   | 2013-03-04 | Kaiti                  | 2013-01-14 | National Assembly 2007-2013
 192 | Joseph Kasaine Ole Nkaissery   | Parliament   | 2013-03-04 | Kajiado Central        | 2013-01-14 | National Assembly 2007-2013
 193 | Peter Anyang' Nyong'o          | Parliament   | 2013-03-04 | Kisumu Rural           | 2013-01-14 | National Assembly 2007-2013
 194 | Oburu Ngona Odinga             | Parliament   | 2013-03-04 | Bondo                  | 2013-01-14 | National Assembly 2007-2013
 195 | Raila Amolo Odinga             | Parliament   | 2013-03-04 | Langata                | 2013-01-14 | National Assembly 2007-2013
 196 | Sospeter Odeke Ojaamongson     | Parliament   | 2013-03-04 | Amagoro                | 2013-01-14 | National Assembly 2007-2013
 198 | Chrysanthus Barnabas Okemo     | Parliament   | 2013-03-04 | Nambale                | 2013-01-14 | National Assembly 2007-2013
 199 | Judah Katoo Ole-Metito         | Parliament   | 2013-03-04 | Kajiado South          | 2013-01-14 | National Assembly 2007-2013
 200 | William Ronkorua ole Ntimama   | Parliament   | 2013-03-04 | Narok North            | 2013-01-14 | National Assembly 2007-2013
 201 | Wycliffe Ambetsa Oparanya      | Parliament   | 2013-03-04 | Butere                 | 2013-01-14 | National Assembly 2007-2013
 202 | Samuel Losuron Poghisio        | Parliament   | 2013-03-04 | Kacheliba              | 2013-01-14 | National Assembly 2007-2013
 203 | Samuel Gonzi Rai               | Parliament   | 2013-03-04 | Kinango                | 2013-01-14 | National Assembly 2007-2013
 204 | William Samoei Ruto            | Parliament   | 2013-03-04 | Eldoret North          | 2013-01-14 | National Assembly 2007-2013
 207 | Peter Soita Shitanda           | Parliament   | 2013-03-04 | Malava                 | 2013-01-14 | National Assembly 2007-2013
 208 | Sylvester Wakoli Bifwoli       | Parliament   | 2013-03-04 | Bumula                 | 2013-01-14 | National Assembly 2007-2013
 209 | Noah Mahalang'ang'a Wekesa     | Parliament   | 2013-03-04 | Kwanza                 | 2013-01-14 | National Assembly 2007-2013
 210 | Moses Masika Wetangula         | Parliament   | 2013-03-04 | Sirisia                | 2013-01-14 | National Assembly 2007-2013
 258 | Mohamed Hussein Gabbow         | Parliament   | 2013-03-04 | Wajir North            | 2013-01-14 | National Assembly 2007-2013
 322 | Gideon Sitelu Konchella        | Parliament   | 2013-03-04 | Kilgoris               | 2013-01-14 | National Assembly 2007-2013
 372 | Margaret Wanjiru Kariuki       | Parliament   | 2013-03-04 | Starehe                | 2013-01-14 | National Assembly 2007-2013
 373 | Maalim Mohamud Mohamed         | Parliament   | 2013-03-04 | Mandera West           | 2013-01-14 | National Assembly 2007-2013
 384 | Benjamin Kipkirui Langat       | Parliament   | 2013-03-04 | Ainamoi                | 2013-01-14 | National Assembly 2007-2013
 385 | Simon Ogari Arama              | Parliament   | 2013-03-04 | Bomachoge              | 2013-01-14 | National Assembly 2007-2013
 388 | Joseph Gachoki Gitari          | Parliament   | 2013-03-04 | Kirinyaga Central      | 2013-01-14 | National Assembly 2007-2013
 391 | Manson Oyongo Nyamweya         | Parliament   | 2013-03-04 | South Mugirango        | 2013-01-14 | National Assembly 2007-2013
 392 | Mohamed Mohamud Sirat          | Parliament   | 2013-03-04 | Wajir South            | 2013-01-14 | National Assembly 2007-2013
 398 | Yusuf Hassan Abdi              | Parliament   | 2013-03-04 | Kamukunji              | 2013-01-14 | National Assembly 2007-2013
 409 | Dunson Mutiso                  | Parliament   | 2013-03-00 | Kathiani               | 2013-01-14 | National Assembly 2007-2013
 442 | Moses Somoine ole Sakuda       | Parliament   | 2013-03-04 | Kajiado North          | 2013-01-14 | National Assembly 2007-2013
 443 | Tirus Nyingi Ngahu             | Parliament   | 2013-03-04 | Kangema                | 2013-01-14 | National Assembly 2007-2013
 444 | Augostinho Neto Oyugi          | Parliament   | 2013-03-04 | Ndhiwa                 | 2013-01-14 | National Assembly 2007-2013
(211 rows)

via 

SELECT mp.id, mp.legal_name, o.name AS organisation, p.end_date, a.name AS area, ps.end_date, ps.name
  FROM core_person mp
  LEFT JOIN core_position p ON mp.id = p.person_id
  LEFT JOIN core_positiontitle t ON p.title_id = t.id
  LEFT JOIN core_place a ON a.id = p.place_id
  LEFT JOIN core_placekind pk ON a.kind_id = pk.id
  LEFT JOIN core_organisation o ON p.organisation_id = o.id
  LEFT JOIN core_parliamentarysession ps ON a.parliamentary_session_id = ps.id
 WHERE ps.house_id IS NOT NULL AND ps.house_id = o.id 
   AND p.end_date IS NOT NULL AND p.end_date != '' AND ps.end_date != '9999-12-31'
   AND CAST(p.end_date AS text) > CAST(ps.end_date AS text)
 ORDER BY o.id, ps.house_id, mp.id, mp.legal_name;
tmtmtmtm commented 8 years ago

These all seem to be because the end_date of the Parliamentary Term is set as 2013-01-14, whereas the Memberships of that Term have an end_date of 2013-03-04