{"action":"created","issue":{"url":"https://api.github.com/repos/mysociety/pombola/issues/1988","repository_url":"https://api.github.com/repos/mysociety/pombola","labels_url":"https://api.github.com/repos/mysociety/pombola/issues/1988/labels{/name}","comments_url":"https://api.github.com/repos/mysociety/pombola/issues/1988/comments","events_url":"https://api.github.com/repos/mysociety/pombola/issues/1988/events","html_url":"https://github.com/mysociety/pombola/issues/1988","id":135769075,"number":1988,"title":"KE: Educational Positions should be at Educational Organisations","user":{"login":"tmtmtmtm","id":57483,"avatar_url":"https://avatars.githubusercontent.com/u/57483?v=3","gravatar_id":"","url":"https://api.github.com/users/tmtmtmtm","html_url":"https://github.com/tmtmtmtm","followers_url":"https://api.github.com/users/tmtmtmtm/followers","following_url":"https://api.github.com/users/tmtmtmtm/following{/other_user}","gists_url":"https://api.github.com/users/tmtmtmtm/gists{/gist_id}","starred_url":"https://api.github.com/users/tmtmtmtm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmtmtmtm/subscriptions","organizations_url":"https://api.github.com/users/tmtmtmtm/orgs","repos_url":"https://api.github.com/users/tmtmtmtm/repos","events_url":"https://api.github.com/users/tmtmtmtm/events{/privacy}","received_events_url":"https://api.github.com/users/tmtmtmtm/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mysociety/pombola/labels/bug","name":"bug","color":"e10c02"},{"url":"https://api.github.com/repos/mysociety/pombola/labels/data","name":"data","color":"0b02e1"},{"url":"https://api.github.com/repos/mysociety/pombola/labels/Difficulty%201","name":"Difficulty 1","color":"207de5"},{"url":"https://api.github.com/repos/mysociety/pombola/labels/KE","name":"KE","color":"009800"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-02-23T15:32:27Z","updated_at":"2016-03-02T16:40:29Z","closed_at":null,"body":"Most of the following organisations should presumably be marked as being of kind 'educational'. Some of the other memberships are simply mis-set:\r\n\r\n```\r\n  id  |                         organisation                          |      kind       |                 role                  | howmany \r\n------+---------------------------------------------------------------+-----------------+---------------------------------------+---------\r\n 2418 | Arid Lands Development Focus                                  | Unknown         |                                       |       1\r\n  178 | Bandari College                                               | Unknown         | Student                               |       1\r\n 2205 | Chartered Institute of Arbitrators, Kenya Chapter             | Unknown         | Student                               |       1\r\n 1289 | Defence staff college                                         | Governmental    | Student                               |       1\r\n  255 | Egerton University                                            | Unknown         | Undergraduate Student                 |      14\r\n  255 | Egerton University                                            | Unknown         | Student                               |       5\r\n  255 | Egerton University                                            | Unknown         | Graduate Student                      |       1\r\n  262 | Faculty of Law University of Nairobi                          | Unknown         | Undergraduate Student                 |       7\r\n  262 | Faculty of Law University of Nairobi                          | Unknown         | Graduate Student                      |       2\r\n 1968 | Freight International (FIATA)                                 | Unknown         | Student                               |       1\r\n 1618 | Githiga Secondary School                                      | Unknown         | Secondary School Student              |       1\r\n 1040 | Institute of Certified Public Accountants of Kenya (ICPAK)    | Unknown         | Fellow                                |       1\r\n  700 | Institution of Surveyors of Kenya                             | Unknown         | Student                               |       1\r\n 1114 | Insurance Institute of Kenya (IIK)                            | Unknown         | Student                               |       1\r\n  297 | International Academy of Trial Lawyers ( U.S.A. )             | Unknown         | Fellow                                |       1\r\n 2217 | J. S. Khakula & Company Advocates, Bungoma                    | Unknown         |                                       |       1\r\n 1967 | JICA/ Kenya Revenue Authority                                 | Unknown         | Student                               |       1\r\n  308 | Jomo Kenyatta University of Agriculture and Technology        | Unknown         | Graduate Student                      |       2\r\n  308 | Jomo Kenyatta University of Agriculture and Technology        | Unknown         | Undergraduate Student                 |       1\r\n 2166 | KASNEB                                                        | Unknown         | Student                               |       2\r\n 2166 | KASNEB                                                        | Unknown         |                                       |       1\r\n  317 | Kagumo High School                                            | Unknown         | Secondary School Student              |       7\r\n  317 | Kagumo High School                                            | Unknown         | Primary School Student                |       1\r\n  318 | Kagumo Teachers' College                                      | Unknown         | Student                               |       4\r\n 2431 | Kapsabet Teachers Training College                            | Unknown         | Student                               |       1\r\n 2169 | Kaptumo High School                                           | Unknown         | Secondary School Student              |       1\r\n  333 | Kenya Institute of Administration;                            | Unknown         | Student                               |       6\r\n  333 | Kenya Institute of Administration;                            | Unknown         |                                       |       1\r\n 1207 | Kenya Institute of Water, Nairobi                             | Unknown         | Student                               |       2\r\n  334 | Kenya Medical Training College                                | Unknown         | Student                               |       2\r\n  334 | Kenya Medical Training College                                | Unknown         | Lecturer                              |       1\r\n 2220 | Kenya National Examinations Council                           | Unknown         |                                       |       1\r\n  346 | Kenya School of Law                                           | Unknown         | Graduate Student                      |      19\r\n  346 | Kenya School of Law                                           | Unknown         | Student                               |      12\r\n  346 | Kenya School of Law                                           | Unknown         | Advocate                              |       2\r\n  346 | Kenya School of Law                                           | Unknown         | Undergraduate Student                 |       1\r\n  346 | Kenya School of Law                                           | Unknown         | Advocate of the High Court of Kenya   |       1\r\n  353 | Kenya institute of Management                                 | Unknown         | Graduate Student                      |       1\r\n  353 | Kenya institute of Management                                 | Unknown         | Student                               |       1\r\n  360 | Kenyatta University Council                                   | Unknown         | Undergraduate Student                 |       1\r\n  370 | Kipsigak high school                                          | Unknown         | Secondary School Student              |       1\r\n  383 | Law Society of Kenya                                          | Unknown         | Member                                |       1\r\n  388 | Logisa Primary School                                         | Unknown         | Primary School Student                |       1\r\n  396 | Makerere University                                           | Unknown         | Undergraduate Student                 |       1\r\n  396 | Makerere University                                           | Unknown         | Student                               |       1\r\n 2262 | Makomboki Primary School                                      | Unknown         | Primary School Student                |       1\r\n 1398 | Me Katalili revolutionary movement (MEKAREMO)                 | Political Party | Founding member                       |       1\r\n 1227 | Metal Joining Technology, Lundy, Sweden                       | Unknown         | Student                               |       1\r\n 1349 | Ministry of roads and public works                            | Governmental    | architect                             |       1\r\n  434 | Mombasa Polytechnic                                           | Unknown         | Student                               |       2\r\n  434 | Mombasa Polytechnic                                           | Unknown         | Secondary School Student              |       1\r\n 1632 | Nairobi People’s Convention Party                             | Political Party | Secretary General                     |       1\r\n 1375 | National Youth Service                                        | Governmental    | Student                               |       1\r\n  472 | Nyadogo Primary School                                        | Unknown         | Primary School Student                |       1\r\n  485 | Osogo Primary School,                                         | Unknown         | Primary School Student                |       1\r\n  515 | Rapogi Primary School                                         | Unknown         | Primary School Student                |       1\r\n 2427 | Students' Organization of Nairobi University                  | Unknown         | Student leader                        |       1\r\n 2195 | Thika Primary School for the Blind                            | Unknown         | Primary School Student                |       1\r\n 2315 | Umu-Salam                                                     | Unknown         | Secondary School Student              |       1\r\n 2192 | United Disabled Persons of Kenya                              | Unknown         | Program Officer                       |       1\r\n 1711 | United State Bureau Statistics and Census                     | Unknown         | Student                               |       1\r\n  569 | United States International University                        | Unknown         | Graduate Student                      |       5\r\n  569 | United States International University                        | Unknown         | Undergraduate Student                 |       5\r\n  569 | United States International University                        | Unknown         | University Student                    |       1\r\n 1288 | United state army war college international fellow programmes | Governmental    | Student                               |       1\r\n  574 | University of Dar-es-Salaam                                   | Unknown         | Undergraduate Student                 |       4\r\n  574 | University of Dar-es-Salaam                                   | Unknown         | Graduate Student                      |       1\r\n  575 | University of East Africa                                     | Unknown         | Undergraduate Student                 |       1\r\n  576 | University of Georgia Law School                              | Unknown         | Graduate Student                      |       1\r\n  578 | University of Nairobi                                         | Unknown         | Undergraduate Student                 |     198\r\n  578 | University of Nairobi                                         | Unknown         | Graduate Student                      |      64\r\n  578 | University of Nairobi                                         | Unknown         | Student                               |      10\r\n  578 | University of Nairobi                                         | Unknown         | Vice President - Student Organisation |       1\r\n  578 | University of Nairobi                                         | Unknown         |                                       |       1\r\n  581 | Unknown - USA                                                 | Unknown         | Student                               |       1\r\n 1888 | Zablon Mokua & Company Advocates                              | Unknown         | Principal Partner                     |       1\r\n```\r\n\r\nvia\r\n```sql\r\nSELECT o.id, o.name AS organisation, ok.name AS kind, COUNT(*) AS howmany\r\n  FROM core_position p \r\n  LEFT JOIN core_organisation o ON p.organisation_id = o.id\r\n  LEFT JOIN core_organisationkind ok ON o.kind_id = ok.id\r\n WHERE p.category = 'education'\r\n   AND ok.name != 'Educational'\r\n GROUP BY o.id, o.name, ok.name\r\n ORDER BY o.name, howmany DESC;\r\n\r\n``` "},"comment":{"url":"https://api.github.com/repos/mysociety/pombola/issues/comments/191318861","html_url":"https://github.com/mysociety/pombola/issues/1988#issuecomment-191318861","issue_url":"https://api.github.com/repos/mysociety/pombola/issues/1988","id":191318861,"user":{"login":"duncanparkes","id":56265,"avatar_url":"https://avatars.githubusercontent.com/u/56265?v=3","gravatar_id":"","url":"https://api.github.com/users/duncanparkes","html_url":"https://github.com/duncanparkes","followers_url":"https://api.github.com/users/duncanparkes/followers","following_url":"https://api.github.com/users/duncanparkes/following{/other_user}","gists_url":"https://api.github.com/users/duncanparkes/gists{/gist_id}","starred_url":"https://api.github.com/users/duncanparkes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/duncanparkes/subscriptions","organizations_url":"https://api.github.com/users/duncanparkes/orgs","repos_url":"https://api.github.com/users/duncanparkes/repos","events_url":"https://api.github.com/users/duncanparkes/events{/privacy}","received_events_url":"https://api.github.com/users/duncanparkes/received_events","type":"User","site_admin":false},"created_at":"2016-03-02T16:40:29Z","updated_at":"2016-03-02T16:40:29Z","body":"Bulk update command above has now been run on staging and live."}}