search

mysociety / pombola

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

NG: Educational Positions should be at Educational Organisations #1989

Closed tmtmtmtm closed 8 years ago

tmtmtmtm commented 8 years ago

Most of the following organisations should presumably be marked as being of kind 'Educational Institution'. Some of the other memberships are simply mis-set:

 id  |                               organisation                               |         kind          |   role    | howmany 
-----+--------------------------------------------------------------------------+-----------------------+-----------+---------
 619 | A.T.C AKWANGA                                                            | Political Institution | Student   |       1
 276 | AAAMC OKENE                                                              | Political Institution | Student   |       1
 624 | ABU Staff School Zaria                                                   | Political Institution | Student   |       1
 634 | ABU, Zaria                                                               | Political Institution | Student   |       8
 286 | ADO GRAMMER SCH                                                          | Political Institution | Student   |       1
 494 | AFM Univ, Huntsville, Alabama, USA                                       | Political Institution | Student   |       1
 792 | AHMADIYYA COLLEG AGEGE                                                   | Political Institution | Student   |       1
 775 | AKKOYEL PRIMARY SCHOOL, KUMO                                             | Political Institution | Student   |       1
 793 | ANSAR-UD-DEEN GRAMMAR SCH.                                               | Political Institution | Student   |       1
 497 | ARMY CHIL.SCH KANO                                                       | Political Institution | Student   |       1
 579 | Abdu Gusau Polytechnic, Talata Mafara, Kano State                        | Political Institution | Student   |       1
 477 | Abdul Aziz Atta Memorial College Okene                                   | Political Institution | Student   |       1
 396 | Abia State University                                                    | Political Institution | Student   |       2
 250 | Abubakar Tafawa Balewa University                                        | Political Institution | Student   |       4
 251 | Administrative Staff College of Nigeria(ASCON)                           | Political Institution | Student   |       1
 638 | African Church Comprehensive High School, Ikere Ekiti                    | Political Institution | Student   |       1
 133 | Ahmadu Bello University, Zaria                                           | Political Institution | Student   |      34
 500 | Air-Force Military School Jos                                            | Political Institution | Student   |       1
 564 | Ajegunle Baptist Day School, Saki, Oyo State                             | Political Institution | Student   |       1
 472 | Ajuwa Grammar School Okeagbe                                             | Political Institution | Student   |       1
 724 | Akoko-Edo Gram. Schl                                                     | Political Institution | Student   |       1
 139 | Akpor  Grammar School Ozuoba                                             | Political Institution | Student   |       1
 435 | Akwa Ibom Uyo State Polytechnic, Ikot Osurua                             | Political Institution | Student   |       1
 307 | All Saint Primary School Agbado                                          | Political Institution | Student   |       1
 693 | All Saints Nursery, Enugu                                                | Political Institution | Student   |       1
 159 | All Saints University of the USA                                         | Political Institution | Student   |       1
 403 | Ambros Alli University Ekpoma                                            | Political Institution | Student   |       2
 167 | Ambrose Ali Uni. Ekpoma                                                  | Political Institution | Student   |       1
 299 | Ambrose Ali University Ekpoma                                            | Political Institution | Student   |       1
 667 | Aminu Kano Comm College                                                  | Political Institution | Student   |       1
 720 | Anambra State University                                                 | Political Institution | Student   |       1
 764 | Anambra State University Of Technology                                   | Political Institution | Student   |       1
 711 | Anglican Commercial Grammar School                                       | Political Institution | Student   |       1
 308 | Anglican Primary School Okenla Ifo                                       | Political Institution | Student   |       1
 582 | Anka Township Primary School, Anka                                       | Political Institution | Student   |       1
 784 | Ansar-Ud-Deen College, Isolo, Lagos                                      | Political Institution | Student   |       1
 338 | Ansar-Ud-Deen Pry School Alakoro Lagos                                   | Political Institution | Student   |       1
 563 | Ansar-Ur-Deen High School, Saki, Oyo State                               | Political Institution | Student   |       1
 176 | Associate Chartered Institute of Bankers (London) ACIB                   | Political Institution | Student   |       1
 687 | Auchi Polytechnic Auchi                                                  | Political Institution | Student   |       2
 360 | Ayedaade Grammar School, Ikire                                           | Political Institution | Student   |       1
 612 | BAPTIST ACADEMY OBANIKORO LAGOS                                          | Political Institution | Student   |       1
 773 | BAUCHI STATE COLLEGE FOR LEGAL STUDIES, BAUCHI STATE                     | Political Institution | Student   |       1
 356 | BENUE POLYTECNIC                                                         | Political Institution | Student   |       1
 553 | BENUE STATE UNIVERSITY                                                   | Political Institution | Student   |       2
 734 | BOLA MEMORIAL PRI.SCH IKEJA                                              | Political Institution | Student   |       1
 633 | BSS New-Bussa                                                            | Political Institution | Student   |       1
 708 | BURLEIGH COLLEGE                                                         | Political Institution | Student   |       1
 670 | Bagauda Technical College                                                | Political Institution | Student   |       1
 394 | Baptist High School Port Harcourt                                        | Political Institution | Student   |       1
 354 | Barewa College Zaria                                                     | Political Institution | Student   |       4
 542 | Basawa Teachers College Zaria                                            | Political Institution | Student   |       1
 208 | Bayero University                                                        | Political Institution | Student   |       3
 301 | Bayero University, Kano                                                  | Political Institution | Student   |      20
 441 | Bishop Clerk's Primary School                                            | Political Institution | Student   |       1
 209 | Bishop Dimeari Grammar School                                            | Political Institution | Student   |       1
 799 | Borgu Sec. School N/Bussa.                                               | Political Institution | Student   |       1
 598 | Borno College of Agriculture                                             | Political Institution | Student   |       1
 597 | Borno College of Basic Studies Bama                                      | Political Institution | Student   |       1
 393 | Boys State School Okrika, Rivers State                                   | Political Institution | Student   |       1
 153 | Boys’ High School Awkunanaw                                              | Political Institution | Student   |       1
 447 | Bristow Secondary School                                                 | Political Institution | Student   |       1
 210 | Bristow Secondary School Gboko                                           | Political Institution | Student   |       1
 211 | Brunel University                                                        | Political Institution | Student   |       1
 272 | Bwari Secondary School, Abuja                                            | Political Institution | Student   |       1
 469 | C.A.S.T ZARIA                                                            | Political Institution | Student   |       1
 673 | CAMBRIDGE CENTRE FOR SIX FORM STUDIES                                    | Political Institution | Student   |       1
 675 | CAPITALSCHOOL KADUNA                                                     | Political Institution | Student   |       1
 260 | CEN.PRI.SCH.GUNI                                                         | Political Institution | Student   |       1
 294 | CHARTED INSTITUTE OF  ARBITRATORS                                        | Political Institution | Associate |       1
 455 | CHARTERED INST. OF PUR. & SUPP. LONDON                                   | Political Institution | Student   |       1
 287 | CHRIST SCH ADO EKITI                                                     | Political Institution | Student   |       1
 421 | COLL.OF EDU AKAMKPA                                                      | Political Institution | Student   |       1
 345 | COLL.OF EDU GINDIRI                                                      | Political Institution | Student   |       1
 442 | COMM.SEC.SCH MARKURDI                                                    | Political Institution | Student   |       1
 387 | COSTAIN PRIMARY SCH. ONDO STATE                                          | Political Institution | Student   |       1
 738 | Calabar Preparation School                                               | Political Institution | Student   |       1
 488 | Carnegie Mellon Univ. USA                                                | Political Institution | Student   |       2
 172 | Caroline Christian University                                            | Political Institution | Student   |       1
 364 | Central Primary School School,                                           | Political Institution | Student   |       1
 796 | Central Primary School, Ikara                                            | Political Institution | Student   |       1
 490 | Central Primary School, Mutun-Biyu                                       | Political Institution | Student   |       1
 518 | Central Primary school, Serti                                            | Political Institution | Student   |       1
 705 | Chartered Institute Of Taxation Of Nigeria                               | Political Institution | Student   |       1
 178 | Chartered Institute of Bankers of Nigeria                                | Political Institution | Student   |       1
 164 | Cheltenham College                                                       | Political Institution | Student   |       1
 586 | Chiranci Primary School, Bichi                                           | Political Institution | Student   |       1
 213 | City University London                                                   | Political Institution | Student   |       1
 527 | Clan School, Itu Mbonuso                                                 | Political Institution | Student   |       1
 605 | College Of Agriculture, Jalingo, Taraba State                            | Political Institution | Student   |       1
 302 | College Of Education Jalingo                                             | Political Institution | Student   |       1
 725 | College Of Education Warri                                               | Political Institution | Student   |       1
 395 | College Of Education, Port Harcourt                                      | Political Institution | Student   |       1
 182 | College of Advance Studies, Kano                                         | Political Institution | Student   |       1
 265 | College of Arts and Islamic Studies, Sokoto.                             | Political Institution | Student   |       1
 362 | College of Education, Maiduguri                                          | Political Institution | Student   |       1
 516 | College of Preliminary Studies, Yola, Adamawa State                      | Political Institution | Student   |       1
 214 | College of Printing, Elephant & Castle, London                           | Political Institution | Student   |       1
 271 | Command Children's School Jaji                                           | Political Institution | Student   |       1
 491 | Command Sec. School, Kaduna                                              | Political Institution | Student   |       1
 215 | Command and Staff College Jaji                                           | Political Institution | Student   |       1
 722 | Community High School, Amagu Agba                                        | Political Institution | Student   |       1
 152 | Community Primary School Amoji Nike                                      | Political Institution | Student   |       1
 762 | Community Primary School Ngene-Ugbo                                      | Political Institution | Student   |       1
 378 | Community School, Akpu                                                   | Political Institution | Student   |       1
 504 | Community Secondary School Igbomotoru Town, Southern Ijaw                | Political Institution | Student   |       1
 789 | Cont Teachers College, Daji                                              | Political Institution | Student   |       1
 162 | Corona School, Victoria Island, Lagos                                    | Political Institution | Student   |       1
 566 | County Grammar School, Ikwerre-Etche                                     | Political Institution | Student   |       3
 436 | Cross River State School Of Basic Studies                                | Political Institution | Student   |       1
 168 | Delta State Uni. Abraka                                                  | Political Institution | Student   |       1
 726 | Delta State University                                                   | Political Institution | Student   |       1
 398 | Dennis Mem. Grammar Sch. Onitsha, Anambra                                | Political Institution | Student   |       1
 678 | EDO STATE UNIVERSITY                                                     | Political Institution | Student   |       2
 537 | ENUGU STATE UNI. OF SCI. AND TECH                                        | Political Institution | Student   |       1
 381 | East Tennessee State Univ. USA                                           | Political Institution | Student   |       2
 216 | Ebonyi State University                                                  | Political Institution | Student   |       1
 217 | Edda Central School                                                      | Political Institution | Student   |       1
 322 | Ede Muslim Grammar School                                                | Political Institution | Student   |       1
 736 | Edo College Benin City                                                   | Political Institution | Student   |       1
 735 | Eghosa Grammar School                                                    | Political Institution | Student   |       1
 686 | Eghosa Grammar School, Benin City                                        | Political Institution | Student   |       1
 766 | Enugu State Univ Of Sci & Tech                                           | Political Institution | Student   |       1
 218 | Enugu State University of Science and Technology                         | Political Institution | Student   |       1
 631 | F.G.C.,Jos                                                               | Political Institution | Student   |       1
 259 | FED GOVT.COLL. AZARE                                                     | Political Institution | Student   |       1
 593 | FED.GOVT. COLLEGE MINNA                                                  | Political Institution | Student   |       1
 411 | FED.GOVT.COLLEGE PORT-HARCOURT                                           | Political Institution | Student   |       1
 538 | FED.POLY IDAH                                                            | Political Institution | Student   |       1
 495 | FED.SCH OF ART &SCI.SULEJA                                               | Political Institution | Student   |       1
 366 | FED.UNI. OF TECH. AKURE                                                  | Political Institution | Student   |       1
 610 | FRANKLIN PIERCE LAW CENTER,USA                                           | Political Institution | Student   |       1
 643 | FSLC BRININ TUDU PRI SCH                                                 | Political Institution | Student   |       1
 628 | FSLC KIRFI/CHELEDI PRI.SCH.                                              | Political Institution | Student   |       1
 652 | FSLC, IDI Primary School                                                 | Political Institution | Student   |       1
 651 | Farm Training Centre                                                     | Political Institution | Student   |       1
 583 | Federal College of Education, Kano State                                 | Political Institution | Student   |       1
 650 | Federal College of Fisheries                                             | Political Institution | Student   |       1
 676 | Federal Government College Kano                                          | Political Institution | Student   |       1
 520 | Federal Government College Kwali, Abuja                                  | Political Institution | Student   |       1
 281 | Federal Government College Maiduguri                                     | Political Institution | Student   |       1
 618 | Federal Government College Sokoto                                        | Political Institution | Student   |       1
 684 | Federal Government Girls College, Owerri, Imo State, 1979-               | Political Institution | Student   |       1
 376 | Federal Polytechnic Oko                                                  | Political Institution | Student   |       1
 547 | Federal Polytechnic, Mubi, Adamawa State                                 | Political Institution | Student   |       1
 414 | Federal Polytecnic Bauchi                                                | Political Institution | Student   |       1
 744 | Federal University Of Technology Akure                                   | Political Institution | Student   |       1
 519 | Federal University Of Technology Minna                                   | Political Institution | Student   |       1
 146 | Federal University of Technology, Owerri                                 | Political Institution | Student   |       2
 219 | Federal University of Technology, Yola                                   | Political Institution | Student   |       3
 546 | Federal University of Technology, Yola, Adamawa State                    | Political Institution | Student   |       1
 160 | Florida State University                                                 | Political Institution | Student   |       1
 523 | Florida University                                                       | Political Institution | Student   |       1
 389 | G. s. s Opobo Town                                                       | Political Institution | Student   |       1
 627 | G.C.E GOVT.SEC.SCH KAFIN-MADAKI                                          | Political Institution | Student   |       1
 752 | G.S.S Fadan Kaje                                                         | Political Institution | Student   |       1
 797 | G.S.S Ikara                                                              | Political Institution | Student   |       1
 621 | G.S.S LAFIYA                                                             | Political Institution | Student   |       1
 346 | G.S.S Yola                                                               | Political Institution | Student   |       1
 774 | G.S.S.S. KUMO                                                            | Political Institution | Student   |       1
 620 | G.T.C JOS                                                                | Political Institution | Student   |       1
 334 | GOVT COLLEGE BAUCHI                                                      | Political Institution | Student   |       1
 352 | GOVT SEC. SCH. RIJAU                                                     | Political Institution | Student   |       1
 425 | GOVT.COLLEGE KEFFI                                                       | Political Institution | Student   |       1
 496 | GOVT.COMP.SEC.SCH. OTUKPO                                                | Political Institution | Student   |       1
 466 | GOVT.SEC SCH.OBUDU                                                       | Political Institution | Student   |       1
 470 | GOVT.SEC. SCH DAURA                                                      | Political Institution | Student   |       1
 306 | GOVT.SEC.SCH.OTUKPO                                                      | Political Institution | Student   |       1
 642 | GOVT.TEACHERS COLLEGE, GUSAU                                             | Political Institution | Student   |       1
 525 | GRS School of Basic Studies, Akamkpa                                     | Political Institution | Student   |       1
 370 | GSCS Ibaa                                                                | Political Institution | Student   |       1
 222 | GSS Ilorin                                                               | Political Institution | Student   |       2
 548 | GSS Jalingo, Taraba State                                                | Political Institution | Student   |       1
 531 | GSS Kukawa/ GSSSS Mowguwo                                                | Political Institution | Student   |       1
 596 | GSS Monguno                                                              | Political Institution | Student   |       1
 615 | GSTS, Kano State                                                         | Political Institution | Student   |       1
 614 | GTTS Kano State                                                          | Political Institution | Student   |       1
 669 | Gandun Nasarawa Primary School                                           | Political Institution | Student   |       1
 672 | Garo Central Primary School                                              | Political Institution | Student   |       1
 671 | Garo Junior Secondary School                                             | Political Institution | Student   |       1
 339 | Gaskiya College Lagos                                                    | Political Institution | Student   |       1
 180 | Gaya Central Primary School                                              | Political Institution | Student   |       1
 363 | General Certificate in Education, Government Secondary School, Maiduguri | Political Institution | Student   |       1
 333 | George Washington Law School (USA)                                       | Political Institution | Student   |       1
 420 | Georgia State University, Atlanta, USA                                   | Political Institution | Student   |       1
 266 | Giginya Memorial College, Sokoto.                                        | Political Institution | Student   |       1
 754 | Girls' Secondary School Ngwo Enugu                                       | Political Institution | Student   |       1
 280 | Government College Keffi                                                 | Political Institution | Student   |       1
 659 | Government College, B/Kudu                                               | Political Institution | Student   |       1
 132 | Government College, Umuahia                                              | Political Institution | Student   |       2
 646 | Government Junior Secondary School, Warure                               | Political Institution | Student   |       1
 581 | Government Secondary School                                              | Political Institution | Student   |       2
 606 | Government Secondary School, Bali,                                       | Political Institution | Student   |       1
 517 | Government Secondary School, Gembu                                       | Political Institution | Student   |       1
 135 | Government Secondary School, Ilorin                                      | Political Institution | Student   |       1
 485 | Government Secondary School, Kano State                                  | Political Institution | Student   |       1
 585 | Government Secondary School, Karaye, Kano State                          | Political Institution | Student   |       1
 489 | Government Secondary School, M/Biu                                       | Political Institution | Student   |       1
 526 | Government Secondary School, Ntonesk                                     | Political Institution | Student   |       1
 645 | Government Secondary School, Panshekara                                  | Political Institution | Student   |       1
 584 | Government Secondary School, Tofa                                        | Political Institution | Student   |       1
 329 | Government TIC, Keffi                                                    | Political Institution | Student   |       2
 557 | Govt College M/guri                                                      | Political Institution | Student   |       1
 220 | Govt college Keffi                                                       | Political Institution | Student   |       1
 181 | Govt. College, Birnin-Kudu                                               | Political Institution | Student   |       1
 511 | Govt. Sec. Tech. School Soba                                             | Political Institution | Student   |       1
 221 | Govt. Secondary School, Ogu                                              | Political Institution | Student   |       1
 247 | Govt. Teacher's Coll Dako                                                | Political Institution | Student   |       1
 560 | Gvt. College Bida                                                        | Political Institution | Student   |       1
 559 | Gvt. College Kaduna                                                      | Political Institution | Student   |       1
 427 | Gvt. Comprehensive School PH                                             | Political Institution | Student   |       1
 343 | Gvt. Sec. Schl. D/Gori                                                   | Political Institution | Student   |       1
 647 | Gwale Special Primary school                                             | Political Institution | Student   |       1
 743 | Gyel Comm. College                                                       | Political Institution | Student   |       1
 549 | HOLY GHOST COLLEGE                                                       | Political Institution | Student   |       1
 274 | Harvard Business School, US                                              | Political Institution | Student   |       1
 284 | Harvard University Kennedy School of Govt                                | Political Institution | Student   |       1
 332 | Harvard University Law School (USA)                                      | Political Institution | Student   |       1
 406 | Harvard University, USA                                                  | Political Institution | Student   |       2
 572 | Headington School, Oxford, UK                                            | Political Institution | Student   |       1
 665 | Hove Davies College                                                      | Political Institution | Student   |       1
 341 | Hunter College Of The City University Of Newyork                         | Political Institution | Student   |       1
 712 | I.M.G. Primary School, Ose, Ibadan, Oyo State                            | Political Institution | Student   |       1
 700 | ICAN , INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA                     | Political Institution | Student   |       1
 778 | Ihie High School, Ihie                                                   | Political Institution | Student   |       1
 289 | Ilusin Grammar School                                                    | Political Institution | Student   |       1
 223 | Immaculate Heart Secondary School, Aba                                   | Political Institution | Student   |       1
 680 | Imo State University, Imo State                                          | Political Institution | Student   |       1
 779 | Imo State University, Uturu                                              | Political Institution | Student   |       1
 625 | Institude of Admin ABU Zaria                                             | Political Institution | Student   |       1
 626 | Institude of Islamic Banking & Insurance London                          | Political Institution | Student   |       1
 171 | Institute of Chartered Accountants of Nigeria   ICAN                     | Political Institution | Student   |       4
 635 | Institute of Journalism, Jos                                             | Political Institution | Student   |       1
 224 | Institute of Quantity Surveyors                                          | Political Institution | Student   |       1
 439 | International Institute of Journalism                                    | Political Institution | Student   |       1
 721 | Izzi High School, Abakaliki                                              | Political Institution | Student   |       1
 541 | Jos ECWA Seminary                                                        | Political Institution | Student   |       1
 225 | Junior Primary School, Mahuta                                            | Political Institution | Student   |       1
 256 | KEBBI STATE POLYTECHNIC                                                  | Political Institution | Student   |       2
 353 | KETARE PRI.SCH                                                           | Political Institution | Student   |       1
 335 | KOBI PRI.SCH                                                             | Political Institution | Student   |       1
 317 | KOGI STATE UNIVERSITY                                                    | Political Institution | Student   |       1
 275 | KWARA COLL.OF TECH ILORIN                                                | Political Institution | Student   |       1
 758 | KWARA COLLEGE OF TECH                                                    | Political Institution | Student   |       1
 480 | Kaduna Captial School                                                    | Political Institution | Student   |       1
 226 | Kaduna Polytechnic                                                       | Political Institution | Student   |      15
 481 | Kaduna Polytechnic Barewa College                                        | Political Institution | Student   |       1
 580 | Kaduna State Polytechnic, Zaria                                          | Political Institution | Student   |       2
 668 | Kanaji Government Secondary School, Kano State                           | Political Institution | Student   |       1
 677 | Kano Capital School                                                      | Political Institution | Student   |       1
 578 | Kano State Polytechnic                                                   | Political Institution | Student   |       2
 655 | Katsina College of Arts and Science,Zaira                                | Political Institution | Student   |       1
 163 | King College, Lagos                                                      | Political Institution | Student   |       1
 530 | Kingarwa Primary School                                                  | Political Institution | Student   |       1
 314 | Kisi Comm Grammar School                                                 | Political Institution | Student   |       1
 227 | Kontagora Senior Primary School                                          | Political Institution | Student   |       1
 543 | Kubacha                                                                  | Political Institution | Student   |       1
 492 | Kufena College, Wusasa, Zaria                                            | Political Institution | Student   |       1
 313 | Kwara State University, Ilorin                                           | Political Institution | Student   |       1
 601 | Kwara State University, Kwara State                                      | Political Institution | Student   |       1
 800 | Kwara Tech. Ilorin,                                                      | Political Institution | Student   |       1
 801 | L. E. A Pry. Agwara                                                      | Political Institution | Student   |       1
 267 | L. E. A. Primary School Certificate, Salame, Gwadabawa Local Gov't.      | Political Institution | Student   |       1
 622 | L.E.A PRI.SCH. DOMA                                                      | Political Institution | Student   |       1
 471 | LA Primary School Surulere Irun                                          | Political Institution | Student   |       1
 367 | LAGOS BAPTIST SEC. SCHOOL                                                | Political Institution | Student   |       1
 760 | LEA PRI.SCH.                                                             | Political Institution | Student   |       1
 246 | LEA Pri Sch Ebbo                                                         | Political Institution | Student   |       1
 751 | LEA Primary School                                                       | Political Institution | Student   |       1
 330 | LEA School Kaduna                                                        | Political Institution | Student   |       1
 288 | LG Pry Sch Ita-Otu                                                       | Political Institution | Student   |       1
 358 | LGEA OKETE OKPIKWU OGIEWU                                                | Political Institution | Student   |       1
 555 | LGEAGBOKO SOUTH                                                          | Political Institution | Student   |       1
 674 | LINDISFORNE COLLEGE RUNBON (UK)                                          | Political Institution | Student   |       1
 318 | LOCAL GOVT.SEC SCH                                                       | Political Institution | Student   |       1
 277 | LSMB CENTRAL SCH OKENE                                                   | Political Institution | Student   |       1
 600 | Ladoke Akintola University                                               | Political Institution | Student   |       1
 551 | Lagos State Polytechnic                                                  | Political Institution | Student   |       1
 290 | Lagos State University                                                   | Political Institution | Student   |       7
 769 | Lea Primary Schls, Wale                                                  | Political Institution | Student   |       1
 709 | Lead City University, Ibadan, Oyo State                                  | Political Institution | Student   |       1
 273 | London Business School                                                   | Political Institution | Student   |       1
 165 | London Hospital Medical College, London (University of London)           | Political Institution | Student   |       1
 714 | London School Of Economics                                               | Political Institution | Student   |       1
 567 | London School Of Economics (University Of London)                        | Political Institution | Student   |       1
 568 | Lutheran High School, Uyo, Akwa Ibom State                               | Political Institution | Student   |       1
 342 | M/Gandu Pri. School                                                      | Political Institution | Student   |       1
 591 | MAYO  SCH. OF CHARTERERD ACCOUNTANCY YABA LAGOS                          | Political Institution | Student   |       1
 554 | MBAWAWUAR SEC.SCH.                                                       | Political Institution | Student   |       1
 727 | MCIPS Chetered Inst. Purc. & Supply                                      | Political Institution | Student   |       1
 742 | MT CARMEL SEC. SCH                                                       | Political Institution | Student   |       1
 407 | Madonna High School                                                      | Political Institution | Student   |       1
 595 | Mafa Central Primary School                                              | Political Institution | Student   |       1
 404 | Magbon - Alade Mem.School, Ibeju, Lagos                                  | Political Institution | Student   |       1
 177 | Manchester business school                                               | Political Institution | Student   |       1
 632 | Marafa Primary School                                                    | Political Institution | Student   |       1
 450 | Marmara Government Secondary School Wukari                               | Political Institution | Student   |       2
 476 | Marmara Primary LEA School Sabon Gari                                    | Political Institution | Student   |       1
 457 | Marshall Law School, USA                                                 | Political Institution | Student   |       1
 482 | Matori Grammar School Okoto, Isolo                                       | Political Institution | Student   |       1
 325 | Mayflower School, Ikenne, Ogun State                                     | Political Institution | Student   |       1
 493 | Memphis State Univ. Memphis, Tenn, USA                                   | Political Institution | Student   |       1
 309 | Methodist High School                                                    | Political Institution | Student   |       1
 228 | Military College of Telecommunication, Molow and Poona.                  | Political Institution | Student   |       1
 617 | Model Primary School, Sokoto                                             | Political Institution | Student   |       1
 639 | Moremi High School O.A.U Ile-Ife                                         | Political Institution | Student   |       1
 522 | Morgan State University                                                  | Political Institution | Student   |       1
 304 | Mubi 1 Primary School                                                    | Political Institution | Student   |       1
 449 | N.K.ST. Primary School Pevikaa Benue State                               | Political Institution | Student   |       1
 536 | NATIONAL OPEN UNIVERSITY LOKOJA                                          | Political Institution | Student   |       1
 679 | NCRIB                                                                    | Political Institution | Student   |       1
 592 | NIG.ARMY SCHOOL OF FINANCE AND ADMINISTRATION                            | Political Institution | Student   |       1
 344 | NIG.LAW SCH. ABUJA                                                       | Political Institution | Student   |       1
 611 | NIG.LAW SCH. LAGOS                                                       | Political Institution | Student   |       1
 498 | NIPPS KURU JOS                                                           | Political Institution | Student   |       1
 728 | NIPSS Kuru Jos                                                           | Political Institution | Student   |       1
 446 | NKST Primary School                                                      | Political Institution | Student   |       1
 739 | NORTH WESTERN POLY.CAMDEN TOWN LONDON                                    | Political Institution | Student   |       1
 319 | NURU/ISLAMIC SCH OKENE                                                   | Political Institution | Student   |       1
 710 | National Teachers Institute                                              | Political Institution | Student   |       1
 641 | National Youth Service Corps                                             | Political Institution | Student   |       1
 262 | National service, National Youth Service corps. (NYSC) Akwa Ibom.        | Political Institution | Student   |       1
 459 | Nembe National Grammar School                                            | Political Institution | Student   |       1
 331 | New York Bar                                                             | Political Institution | Student   |       1
 706 | Nig. Army School Of Finance                                              | Political Institution | Student   |       1
 501 | Nig. Law School Bwari                                                    | Political Institution | Student   |       1
 229 | Niger Provincial Secondary School                                        | Political Institution | Student   |       1
 231 | Nigeria Law School Lagos                                                 | Political Institution | Student   |       1
 230 | Nigeria institute of journalism Jos                                      | Political Institution | Student   |       1
 550 | Nigerian Air Force                                                       | Political Institution | Student   |       1
 786 | Nigerian Institute Of Journalism (NIJ) Ogba, Lagos                       | Political Institution | Student   |       1
 137 | Nigerian Law School                                                      | Political Institution | Student   |      21
 649 | Northern Business School                                                 | Political Institution | Student   |       1
 556 | Northwestern Univ.                                                       | Political Institution | Student   |       1
 701 | O.G.S ODOGBOLU                                                           | Political Institution | Student   |       1
 794 | OMAR AHMADIYYA SCH JANKARA LAGOS                                         | Political Institution | Student   |       1
 327 | ONDO ANGLICAN GRANMMAR SCH                                               | Political Institution | Student   |       1
 292 | Oba Akinyele Memorial High School                                        | Political Institution | Student   |       1
 552 | Oba Seku High School, Eruwa.                                             | Political Institution | Student   |       1
 134 | Obafemi Awolowo University                                               | Political Institution | Student   |       2
 283 | Obafemi Awolowo University, Ile Ife                                      | Political Institution | Student   |       5
 405 | Obi Anazonwu Primary School, Onitsha                                     | Political Institution | Student   |       1
 399 | Obi-Okosi Mem. Pri. Sch. Onitsha Anambra.                                | Political Institution | Student   |       1
 707 | Okaka Admin Grammar School, Okaka                                        | Political Institution | Student   |       1
 402 | Okongwu Mem. Grammar Sch. Nnewi                                          | Political Institution | Student   |       1
 419 | Okrika Grammer School                                                    | Political Institution | Student   |       1
 604 | Okun Omoni Grammar School, Ife, Osun State                               | Political Institution | Student   |       1
 473 | Ondo State Polytechnic                                                   | Political Institution | Student   |       3
 640 | Ondo State University, Ado-Ekiti                                         | Political Institution | Student   |       1
 340 | Oriwu College Ikorodu Lagos                                              | Political Institution | Student   |       1
 768 | Our Lady Of Schls, Anyigba                                               | Political Institution | Student   |       1
 321 | Oyo State College of Arts, Oyo State                                     | Political Institution | Student   |       1
 660 | PSLC, Kofar Naisa Primary School                                         | Political Institution | Student   |       1
 571 | Padworth College, Reading, UK                                            | Political Institution | Student   |       1
 232 | Polytechnic of South Bank, London                                        | Political Institution | Student   |       1
 561 | Polytechnic of central London                                            | Political Institution | Student   |       1
 528 | Presbyterian School, Ibiono Emero                                        | Political Institution | Student   |       1
 369 | Primary School Koroma                                                    | Political Institution | Student   |       1
 141 | Primary school Bedwell  street                                           | Political Institution | Student   |       1
 656 | Queen Amina College                                                      | Political Institution | Student   |       1
 440 | Queen of Apostle                                                         | Political Institution | Student   |       1
 233 | Ramat polytechnic Maiduguri                                              | Political Institution | Student   |       3
 433 | Regina Coeli Secondary School, Essene Ik Abasi                           | Political Institution | Student   |       1
 391 | Rivers College Of Education Port Harcourt                                | Political Institution | Student   |       1
 460 | Rivers State College Of Education                                        | Political Institution | Student   |       1
 505 | Rivers State College Of Education Port Harcourt                          | Political Institution | Student   |       1
 371 | Rivers State University Of Science & Technology                          | Political Institution | Student   |       8
 138 | Rivers State University of Science and Technology                        | Political Institution | Student   |       3
 392 | Rivers UOE Port Harcourt                                                 | Political Institution | Student   |       1
 384 | Rumfa College                                                            | Political Institution | Student   |       2
 385 | SCH.OF MGT AND ACCT. STUDIES JOS                                         | Political Institution | Student   |       1
 717 | SENTON SEC.SCH                                                           | Political Institution | Student   |       1
 747 | SSRD Polytechnic                                                         | Political Institution | Student   |       1
 412 | ST Annes Primary Boarding Sch. Kaduna                                    | Political Institution | Student   |       1
 467 | ST COLMANS PRI.SCH. UJUGWANG OBUDU                                       | Political Institution | Student   |       1
 422 | ST LOUIS PRI.SCH                                                         | Political Institution | Student   |       1
 368 | ST MARY'S PRI SCH.ADO EKITI                                              | Political Institution | Student   |       1
 443 | ST WILLIAMS PRI. SCH. KEFFI                                              | Political Institution | Student   |       1
 361 | ST. AUGUSTINE'S COLLEGE KABBA                                            | Political Institution | Student   |       1
 357 | ST. PAUL SEC. SCH. OTUKPO                                                | Political Institution | Student   |       1
 539 | ST. PETER'S COLLEGE IDAH                                                 | Political Institution | Student   |       1
 413 | ST. Peters Sec. Sch. Achina                                              | Political Institution | Student   |       1
 737 | Saint Patrick's College, Calabar                                         | Political Institution | Student   |       1
 248 | Sch of Health Tech Minna                                                 | Political Institution | Student   |       1
 767 | Schl Of Basic Std. - Makurdi                                             | Political Institution | Student   |       1
 753 | School Of Basic Studies / ABU Zaria                                      | Political Institution | Student   |       1
 310 | School Of Basic Studies Ogun State College Of Education                  | Political Institution | Student   |       1
 390 | School Of Basic Studies Port Harcourt                                    | Political Institution | Student   |       1
 448 | School Of Basic Studies, Makurdi                                         | Political Institution | Student   |       1
 603 | School of Basic Studies, Birnin Kebbi, Kebbi State                       | Political Institution | Student   |       1
 515 | School of General Studies, BUK, Kano State                               | Political Institution | Student   |       1
 658 | Science Secondary School, B/Kudu                                         | Political Institution | Student   |       1
 756 | Senior Secondary School                                                  | Political Institution | Student   |       1
 416 | Seventh Day Adventist School                                             | Political Institution | Student   |       1
 637 | Seventh Day Primary School, Ile-Ife                                      | Political Institution | Student   |       1
 279 | Shehu Garbai School Maiduguri                                            | Political Institution | Student   |       1
 263 | Shehu Shagari College of Education, Sokoto.                              | Political Institution | Student   |       2
 297 | St Columbanus Roman Catholic Sch., Imiegba                               | Political Institution | Student   |       1
 685 | St Matthew's Primary School Ekiadolor                                    | Political Institution | Student   |       1
 377 | St Micheal's College, Nimo                                               | Political Institution | Student   |       1
 140 | St Patrick college, Ikot Ansar, Calabar                                  | Political Institution | Student   |       1
 483 | St Pauls Anglican School, Isaga Isolo                                    | Political Institution | Student   |       1
 298 | St Thomas's College Ibusa                                                | Political Institution | Student   |       1
 763 | St Vincent's sec. Sch. Agbogugu                                          | Political Institution | Student   |       1
 388 | St. Andrew's State School Idiobv                                         | Political Institution | Student   |       1
 657 | St. Anne's Primary School Kaduna                                         | Political Institution | Student   |       1
 434 | St. Joseph Catholic Primary School, Lwukem, Etm Ekpo LGA                 | Political Institution | Student   |       1
 136 | St. Louis Nursery & Primary School                                       | Political Institution | Student   |       1
 235 | St. Martins State School, Ogu                                            | Political Institution | Student   |       1
 565 | St. Paul's Anglican School, Diobu, Port Harcourt                         | Political Institution | Student   |       1
 236 | St. Paul’s L.E.A School, Isapa,                                          | Political Institution | Student   |       1
 437 | St. Plus Primary School Ikot Itle Udung                                  | Political Institution | Student   |       1
 503 | State Primary School I Ibadan St. Port Harcourt                          | Political Institution | Student   |       1
 574 | State SchooI Oruebum Port Harcourt                                       | Political Institution | Student   |       1
 458 | State School, Nembe                                                      | Political Institution | Student   |       1
 575 | Stella Maris College Port Harcourt                                       | Political Institution | Student   |       1
 237 | Stockholm University, Sweden                                             | Political Institution | Student   |       1
 410 | Student Union, University of Nigeria, Nsukka                             | Political Institution | Student   |       1
 757 | Sumaila Gabas Primary School, Kano State                                 | Political Institution | Student   |       1
 347 | T.C Bauchi                                                               | Political Institution | Student   |       1
 590 | THE EMILE WOLF COLLEGE OF ACCOUNTANCY LONDON                             | Political Institution | Student   |       1
 351 | THE POLY.BIRNIN KEBBI                                                    | Political Institution | Student   |       1
 759 | TITCOMBE COLLEGE                                                         | Political Institution | Student   |       1
 315 | Teacher College Rumbotso                                                 | Political Institution | Student   |       1
 303 | Teachers College Numan                                                   | Political Institution | Student   |       1
 264 | The Polytechnic of Sokoto State.                                         | Political Institution | Student   |       1
 602 | The Polytechnic, Birnin Kebbi                                            | Political Institution | Student   |       1
 695 | The Polytechnic, Calabar                                                 | Political Institution | Student   |       1
 291 | The Polytechnic, Ibadan                                                  | Political Institution | Student   |       5
 785 | Times Journalism Institute (TJI) Iganmu, Lagos                           | Political Institution | Student   |       2
 569 | Tinu School, Surelere, Lagos State                                       | Political Institution | Student   |       1
 790 | Town Primary School, Tambuwal,                                           | Political Institution | Student   |       1
 417 | Town School, Mbutu                                                       | Political Institution | Student   |       1
 694 | Township School, Moscow Road, Port Harcourt                              | Political Institution | Student   |       1
 630 | UDUS                                                                     | Political Institution | Student   |       1
 465 | UNI. OF CROSS RIVERS STATE UYO                                           | Political Institution | Student   |       1
 285 | UNI.OF ILORIN                                                            | Political Institution | Student   |       1
 355 | UNI.OG AGRIC.MARKUDI                                                     | Political Institution | Student   |       1
 683 | UNION Secondary School                                                   | Political Institution | Student   |       1
 428 | UNIVERSITY OF EAST ANGLIA                                                | Political Institution | Student   |       1
 514 | UNIVERSITY OF LANCASTER (UK)                                             | Political Institution | Student   |       1
 426 | UPE Model Pri. School PH                                                 | Political Institution | Student   |       1
 243 | US Army War College                                                      | Political Institution | Student   |       1
 415 | Uboma Secondary School, Ikperejere                                       | Political Institution | Student   |       1
 777 | Umousu Central School, Umuosu Nsulu                                      | Political Institution | Student   |       1
 401 | Umunnealam Pri. Sch. Umudun Nnewi                                        | Political Institution | Student   |       1
 156 | University Of Science And Technology, Portharcourt                       | Political Institution | Student   |       1
 255 | University of Abuja                                                      | Political Institution | Student   |       8
 131 | University of Benin                                                      | Political Institution | Student   |      11
 238 | University of Calabar                                                    | Political Institution | Student   |      11
 150 | University of Florida                                                    | Political Institution | Student   |       1
 149 | University of Georgia                                                    | Political Institution | Student   |       1
 170 | University of Ghana Legon                                                | Political Institution | Student   |       1
 324 | University of Greenwich, UK                                              | Political Institution | Student   |       2
 151 | University of Ibadan                                                     | Political Institution | Student   |      17
 239 | University of Illinois                                                   | Political Institution | Student   |       1
 636 | University of Ilorin                                                     | Political Institution | Student   |       3
 249 | University of Jos                                                        | Political Institution | Student   |      16
 241 | University of Lagos                                                      | Political Institution | Student   |      28
 648 | University of London, (Thames Valley)                                    | Political Institution | Student   |       1
 383 | University of Maiduguri                                                  | Political Institution | Student   |       8
 161 | University of Missouri                                                   | Political Institution | Student   |       1
 499 | University of New England, Australia                                     | Political Institution | Student   |       1
 375 | University of Nigeria                                                    | Political Institution | Student   |      11
 154 | University of Nigeria Nsukka                                             | Political Institution | Student   |       2
 372 | University of Port Harcourt                                              | Political Institution | Student   |      10
 242 | University of Port Harcourt, Choba                                       | Political Institution | Student   |       2
 323 | University of Reading, UK                                                | Political Institution | Student   |       1
 320 | University of Southampton, UK                                            | Political Institution | Student   |       1
 570 | University of Surrey UK                                                  | Political Institution | Student   |       1
 682 | University of Sussex                                                     | Political Institution | Student   |       1
 424 | University of Uyo                                                        | Political Institution | Student   |       3
 312 | University of Wales, Cardiff                                             | Political Institution | Student   |       2
 258 | Usman Danfodiyo University, Sokoto                                       | Political Institution | Student   |      12
 244 | Usmanu Dan Fodiyo University                                             | Political Institution | Student   |       1
 733 | VICTORY HIGH SCH.IKEJA                                                   | Political Institution | Student   |       1
 666 | Victory College, Alexandria                                              | Political Institution | Student   |       1
 382 | W.M Bristow Sec. School Gboko                                            | Political Institution | Student   |       1
 386 | W.T.C BAJOGA                                                             | Political Institution | Student   |       1
 257 | WAMMAKO PRI.SCH                                                          | Political Institution | Student   |       1
 513 | WASHINGTON INTERNATIONAL UNIVERSITY(USA)                                 | Political Institution | Student   |       2
 740 | WATFORD COLLEGE OF TECH. WARTFORD HERTS.                                 | Political Institution | Student   |       1
 664 | West London College                                                      | Political Institution | Student   |       1
 616 | Wudil Primary School, Kano State                                         | Political Institution | Student   |       1
 326 | YABA COLL.OF TECH.                                                       | Political Institution | Student   |       1
 486 | Yakasai Primary School, Kano State                                       | Political Institution | Student   |       1
 316 | Zarewa Central Primary school                                            | Political Institution | Student   |       1
 521 | Zarumai Primary School Minna                                             | Political Institution | Student   |       1
 704 | hartered Institute Of Bankers Of Nigeria                                 | Political Institution | Student   |       1
(489 rows)

via

SELECT o.id, o.name AS organisation, ok.name AS kind, COUNT(*) AS howmany
  FROM core_position p 
  LEFT JOIN core_organisation o ON p.organisation_id = o.id
  LEFT JOIN core_organisationkind ok ON o.kind_id = ok.id
 WHERE p.category = 'education'
   AND ok.name != 'Educational Institution'
 GROUP BY o.id, o.name, ok.name
 ORDER BY o.name, howmany DESC;
tmtmtmtm commented 8 years ago

screen shot 2016-02-23 at 16 41 55

tmtmtmtm commented 8 years ago

It looks it it'd be better to fix all of these to be Educational, and then manually tidy up anything that looks odd.

duncanparkes commented 8 years ago

Run the following commands in python manage.py shell:

from pombola.core.models import Organisation
from pombola.core.models import OrganisationKind

edu_org_kind = OrganisationKind.objects.get(slug='educational-institution')
orgs = Organisation.objects.filter(kind__slug='political-institution').filter(position__category='education').distinct()
for org in orgs:
    org.kind = edu_org_kind
    org.save()

# Check that there are now no organisations with kind Unknown and
# a position with category 'education'
Organisation.objects.filter(kind__slug='political-institution').filter(position__category='education').distinct().count()
duncanparkes commented 8 years ago

Commands now done on staging and live.