search

mysociety / pombola

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

KE: data report — missing legislative Area #1970

Open tmtmtmtm opened 8 years ago

tmtmtmtm commented 8 years ago

The following people have no Area set on their legislative membership (and are not a Nominated member):

  id   |            legal_name            | start_date |  end_date  |     subtitle     |                  organisation                  |         role         | area | area_kind 
-------+----------------------------------+------------+------------+------------------+------------------------------------------------+----------------------+------+-----------
   362 | Julia Auma Ojiambo               | 1979-00-00 | 1983-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   394 | Hussein Maalim Mohamed           | 1983-00-00 | 1988-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   394 | Hussein Maalim Mohamed           | 1988-00-00 | 1992-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   416 | Martin Shikuku                   | 1992-00-00 | 1997-00-00 |                  | Parliament                                     | Member of Parliament |      | 
  2069 | Shaaban Ali Isaack               | 1992-00-00 | 2007-00-00 |                  | Mandera East Constituency                      | Member of Parliament |      | 
   311 | Kipruto Rono Kirwa               | 1993-00-00 | 1997-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   136 | Isaac Kiprono Rutto              | 1997-00-00 | 2002-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   311 | Kipruto Rono Kirwa               | 1998-00-00 | 2002-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   221 | Maina Kamanda                    | 1998-00-00 | 2002-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   171 | George Munyasa khaniri           | 2003-00-00 | 2007-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   311 | Kipruto Rono Kirwa               | 2003-00-00 | 2007-00-00 |                  | Parliament                                     | Member of Parliament |      | 
   484 | Augustine Chemonges Loile Lotodo | 2007-00-00 | 2012-00-00 |                  | East Africa Legislative Assembly (EALA), Kenya | Member of Parliament |      | 
 13158 | Ben Njoroge                      | 2013-10-00 | future     | Nominated member | Parliament                                     | Senator              |      | 
 13157 | Godliver Nanjira Omondi          | 2013-10-00 | future     | Nominated member | Parliament                                     | Senator              |      | 
 13153 | Emma Mbura Getrude               | 2013-03-21 | future     | nominated        | Parliament                                     | Senator              |      | 
 13127 | Judith Achieng Sijeny            | 2013-03-21 | future     | nominated        | Parliament                                     | Senator              |      |

via 

SELECT mp.id, mp.legal_name, p.start_date, p.end_date, p.subtitle, o.name AS organisation, t.name AS role, a.name AS area, pk.name AS area_kind
  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
 WHERE t.id IN (1, 851, 849) 
   AND pk.name IS NULL
   AND p.subtitle != 'Nominated'
 ORDER BY t.name, p.subtitle, p.start_date, mp.legal_name;
tmtmtmtm commented 8 years ago

The final four rows look like they correctly have no area, but their 'subtitle' should really be set to 'Nominated' for consistency with all the others.

tmtmtmtm commented 8 years ago

I have corrected the 'Nominated' members via the Admin