nigeria_lga_districts.sql

-- phpMyAdmin SQL Dump
-- version 4.8.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 28, 2019 at 08:57 AM
-- Server version: 10.1.33-MariaDB
-- PHP Version: 7.2.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `nigeria_lga_districts`
--

-- --------------------------------------------------------

--
-- Table structure for table `lga_tbl`
--

CREATE TABLE `lga_tbl` (
  `lga_id` int(11) NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  `senatorial_district_id` int(11) DEFAULT NULL,
  `representative_district_id` int(11) DEFAULT NULL,
  `lga_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lga_tbl`
--

INSERT INTO `lga_tbl` (`lga_id`, `state_id`, `senatorial_district_id`, `representative_district_id`, `lga_name`) VALUES
(1, 1, 3, 7, 'Aba North'),
(2, 1, 3, 7, 'Aba South'),
(3, 1, 4, 6, 'Arochukwu'),
(4, 1, 4, 4, 'Bende'),
(5, 1, 2, 3, 'Ikwuano'),
(6, 1, 2, 9, 'Isiala Ngwa North'),
(7, 1, 2, 9, 'Isiala Ngwa South'),
(8, 1, 4, 5, 'Isuikwuato'),
(9, 1, 3, 10, 'Obingwa'),
(10, 1, 4, 6, 'Ohafia'),
(11, 1, 3, 10, 'Osisioma'),
(12, 1, 3, 10, 'Ugwunagbo'),
(13, 1, 3, 8, 'Ukwa East'),
(14, 1, 3, 8, 'Ukwa West'),
(15, 1, 2, 3, 'Umuahia North'),
(16, 1, 2, 3, 'Umuahia South'),
(17, 1, 4, 5, 'Umunneochi'),
(18, 2, 7, 17, 'Demsa'),
(19, 2, 6, 15, 'Fufore'),
(20, 2, 7, 11, 'Ganye'),
(21, 2, 7, 12, 'Guyuk'),
(22, 2, 6, 13, 'Gombi'),
(23, 2, 6, 18, 'Girei'),
(24, 2, 6, 13, 'Hong'),
(25, 2, 7, 11, 'Jada'),
(26, 2, 7, 17, 'Lamurde'),
(27, 2, 5, 16, 'Madagali'),
(28, 2, 5, 14, 'Maiha'),
(29, 2, 7, 11, 'Mayo Belwa'),
(30, 2, 5, 16, 'Michika'),
(31, 2, 5, 14, 'Mubi North'),
(32, 2, 5, 14, 'Mubi South'),
(33, 2, 7, 17, 'Numan'),
(34, 2, 7, 12, 'Shelleng'),
(35, 2, 6, 15, 'Song'),
(36, 2, 7, 11, 'Toungo'),
(37, 2, 6, 18, 'Yola North'),
(38, 2, 6, 18, 'Yola South'),
(39, 3, 9, 24, 'Abak'),
(40, 3, 10, 27, 'Eastern Obolo'),
(41, 3, 10, 22, 'Eket'),
(42, 3, 10, 22, 'Esit Eket'),
(43, 3, 9, 23, 'Essien Udim'),
(44, 3, 9, 24, 'Etim Ekpo'),
(45, 3, 8, 20, 'Etinan'),
(46, 3, 10, 22, 'Ibeno'),
(47, 3, 8, 28, 'Ibeskip Asutan'),
(48, 3, 8, 21, 'Ibiono Ibom'),
(49, 3, 9, 24, 'Ika'),
(50, 3, 9, 25, 'Ikono'),
(51, 3, 10, 27, 'Ikot Abasi'),
(52, 3, 9, 23, 'Ikot Ekpene'),
(53, 3, 9, 25, 'Ini'),
(54, 3, 8, 21, 'Itu'),
(55, 3, 10, 26, 'Mbo'),
(56, 3, 10, 27, 'Mkpat Enin'),
(57, 3, 8, 28, 'Nsit Ata'),
(58, 3, 8, 20, 'Nsit Ibom'),
(59, 3, 8, 20, 'Nsit Ubium'),
(60, 3, 9, 23, 'Obot Akara'),
(61, 3, 10, 26, 'Okobo'),
(62, 3, 10, 22, 'Onna'),
(63, 3, 10, 26, 'Oron'),
(64, 3, 9, 19, 'Orukanam'),
(65, 3, 10, 26, 'Udung-Uko'),
(66, 3, 9, 19, 'Ukanafun'),
(67, 3, 8, 28, 'Uruan'),
(68, 3, 10, 26, 'UrueOffong/Oruko'),
(69, 3, 8, 28, 'Uyo'),
(70, 4, 12, 31, 'Aguta'),
(71, 4, 13, 29, 'Anambra East'),
(72, 4, 13, 29, 'Anambra West'),
(73, 4, 11, 30, 'Anaocha'),
(74, 4, 11, 34, 'Awka North'),
(75, 4, 11, 34, 'Awka South'),
(76, 4, 13, 37, 'Ayamelum'),
(77, 4, 11, 30, 'Dunukofia'),
(78, 4, 12, 32, 'Ekwusigo'),
(79, 4, 11, 38, 'Idemili North'),
(80, 4, 11, 38, 'Idemili South'),
(81, 4, 12, 36, 'Ihiala'),
(82, 4, 11, 30, 'Njikoka'),
(83, 4, 12, 32, 'Nnewi North'),
(84, 4, 12, 32, 'Nnewi South'),
(85, 4, 13, 39, 'Ogbaru'),
(86, 4, 13, 33, 'Onitsha North'),
(87, 4, 13, 33, 'Onitsha South'),
(88, 4, 12, 35, 'Orumba North'),
(89, 4, 12, 35, 'Orumba South'),
(90, 4, 13, 37, 'Oyi'),
(91, 5, 14, 513, 'Alkaleri'),
(92, 5, 14, 46, 'Bauchi'),
(93, 5, 14, 43, 'Bogoro'),
(94, 5, 15, 40, 'Dambam'),
(95, 5, 15, 47, 'Darazo'),
(96, 5, 14, 43, 'Dass'),
(97, 5, 16, 44, 'Gamawa'),
(98, 5, 15, 47, 'Gunjuwa'),
(99, 5, 16, 49, 'Giade'),
(100, 5, 16, 45, 'Itas-Gadau'),
(101, 5, 16, 45, 'Jama\'are'),
(102, 5, 16, 42, 'Katagum'),
(103, 5, 14, 513, 'Kirfi'),
(104, 5, 15, 40, 'Misau'),
(105, 5, 15, 48, 'Ningi'),
(106, 5, 16, 49, 'Shira'),
(107, 5, 14, 43, 'Tafawa Balewa'),
(108, 5, 14, 50, 'Toro'),
(109, 5, 15, 48, 'Warji'),
(110, 5, 16, 41, 'Zaki'),
(111, 6, 18, 55, 'Brass'),
(112, 6, 19, 53, 'Ekeremor'),
(113, 6, 17, 51, 'Kolokuma/Opokuma'),
(114, 6, 18, 55, 'Nembe'),
(115, 6, 18, 52, 'Ogbia'),
(116, 6, 19, 53, 'Sagbama'),
(117, 6, 17, 54, 'Southern Ijaw'),
(118, 6, 17, 51, 'Yenagoa'),
(119, 7, 20, 56, 'Agatu'),
(120, 7, 20, 56, 'Apa'),
(121, 7, 20, 61, 'Ado'),
(122, 7, 22, 60, 'Buruku'),
(123, 7, 22, 63, 'Gboko'),
(124, 7, 22, 64, 'Guma'),
(125, 7, 22, 65, 'Gwer East'),
(126, 7, 22, 65, 'Gwer West'),
(127, 7, 21, 62, 'Katsina-Ala'),
(128, 7, 21, 59, 'Konshisha'),
(129, 7, 21, 57, 'Kwande'),
(130, 7, 21, 62, 'Logo'),
(131, 7, 22, 64, 'Makurdi'),
(132, 7, 20, 67, 'Obi'),
(133, 7, 20, 61, 'Obadigbo'),
(134, 7, 20, 66, 'Ohimini'),
(135, 7, 20, 67, 'Oju'),
(136, 7, 20, 61, 'Opkokwu'),
(137, 7, 20, 66, 'Otukpo'),
(138, 7, 22, 63, 'Tarka'),
(139, 7, 21, 62, 'Ukum'),
(140, 7, 21, 57, 'Ushongo'),
(141, 7, 21, 59, 'Vandeikya'),
(142, 8, 24, 72, 'Abadam'),
(143, 8, 25, 70, 'Askira-Uba'),
(144, 8, 23, 69, 'Bama'),
(145, 8, 25, 75, 'Bayo'),
(146, 8, 25, 75, 'Biu'),
(147, 8, 25, 73, 'Chibok'),
(148, 8, 25, 73, 'Damboa'),
(149, 8, 23, 71, 'Dikwa'),
(150, 8, 24, 77, 'Gubio'),
(151, 8, 24, 72, 'Guzamala'),
(152, 8, 25, 73, 'Gwoza'),
(153, 8, 25, 70, 'Hawul'),
(154, 8, 23, 68, 'Jere'),
(155, 8, 23, 77, 'Kaga'),
(156, 8, 23, 69, 'Kalabalge'),
(157, 8, 23, 71, 'Konduga'),
(158, 8, 24, 72, 'Kukawa'),
(159, 8, 25, 75, 'Kwaya Kusar'),
(160, 8, 23, 71, 'Mafaf'),
(161, 8, 24, 77, 'Magumeri'),
(162, 8, 23, 76, 'Maiduguri'),
(163, 8, 24, 74, 'Marte'),
(164, 8, 24, 72, 'Mobbar'),
(165, 8, 24, 74, 'Monguno'),
(166, 8, 23, 69, 'Ngala'),
(167, 8, 24, 74, 'Nganzai'),
(168, 8, 25, 75, 'Shani'),
(169, 9, 28, 81, 'Abi'),
(170, 9, 27, 84, 'Akamkpa'),
(171, 9, 27, 83, 'Akpabuyo'),
(172, 9, 27, 83, 'Bakassi'),
(173, 9, 26, 82, 'Bekwarra'),
(174, 9, 26, 84, 'Biase'),
(175, 9, 28, 80, 'Boki'),
(176, 9, 27, 78, 'Calabar Municipal'),
(177, 9, 27, 83, 'Calabar South'),
(178, 9, 28, 85, 'Etung'),
(179, 9, 28, 80, 'Ikom'),
(180, 9, 26, 82, 'Obanliku'),
(181, 9, 28, 85, 'Obubra'),
(182, 9, 26, 82, 'Obudu'),
(183, 9, 27, 78, 'Odukpani'),
(184, 9, 26, 79, 'Ogoja'),
(185, 9, 28, 81, 'Yakurr'),
(186, 9, 26, 79, 'Yala'),
(187, 10, 31, 94, 'Aniocha North'),
(188, 10, 31, 94, 'Aniocha South'),
(189, 10, 30, 95, 'Bomadi'),
(190, 10, 30, 91, 'Burutu'),
(191, 10, 29, 86, 'Ethiope East'),
(192, 10, 29, 86, 'Ethiope West'),
(193, 10, 31, 93, 'Ika North East'),
(194, 10, 31, 93, 'Ika South'),
(195, 10, 30, 90, 'Isoko North'),
(196, 10, 30, 90, 'Isoko South'),
(197, 10, 31, 88, 'Ndokwa East'),
(198, 10, 31, 88, 'Ndokwa West'),
(199, 10, 29, 89, 'Opke'),
(200, 10, 31, 94, 'Oshimili North'),
(201, 10, 31, 94, 'Oshimili South'),
(202, 10, 30, 95, 'Patani'),
(203, 10, 29, 89, 'Sapele'),
(204, 10, 29, 87, 'Udu'),
(205, 10, 29, 87, 'Ughelli North'),
(206, 10, 29, 87, 'Ughelli South'),
(207, 10, 31, 88, 'Ukwani'),
(208, 10, 29, 89, 'Uvwie'),
(209, 10, 30, 92, 'Warri North'),
(210, 10, 30, 92, 'Warri South'),
(211, 10, 30, 92, 'Warri South West'),
(212, 11, 32, 101, 'Abakaliki'),
(213, 11, 33, 100, 'Afikpo North'),
(214, 11, 33, 100, 'Afikpo South'),
(215, 11, 32, 97, 'Ebonyi'),
(216, 11, 34, 98, 'Ezza North'),
(217, 11, 34, 96, 'Ezza South'),
(218, 11, 34, 96, 'Ikwo'),
(219, 11, 34, 98, 'Ishielu'),
(220, 11, 33, 99, 'Ivo'),
(221, 11, 32, 101, 'Izzi'),
(222, 11, 34, 99, 'Ohaozara'),
(223, 11, 32, 97, 'Ohaukwu'),
(224, 11, 33, 99, 'Onicha'),
(225, 12, 37, 107, 'Akoko-Edo'),
(226, 12, 36, 102, 'Egor'),
(227, 12, 35, 105, 'Esan Central'),
(228, 12, 35, 104, 'Esan North-East'),
(229, 12, 35, 104, 'Esan South-East'),
(230, 12, 35, 105, 'Esan West'),
(231, 12, 37, 108, 'Etsako Central'),
(232, 12, 37, 108, 'Etsako East'),
(233, 12, 37, 108, 'Etsako West'),
(234, 12, 35, 105, 'Igueben'),
(235, 12, 36, 102, 'Ikpoba-Okha'),
(236, 12, 36, 109, 'Orhionmwon'),
(237, 12, 36, 110, 'Oredo'),
(238, 12, 36, 106, 'Ovia North-East'),
(239, 12, 36, 106, 'Ovia South-West'),
(240, 12, 37, 103, 'Owan East'),
(241, 12, 37, 103, 'Owan West'),
(242, 12, 36, 109, 'Uhunmwode'),
(243, 13, 40, 115, 'Ado Ekiti'),
(244, 13, 40, 114, 'Efon'),
(245, 13, 39, 112, 'Ekiti East'),
(246, 13, 39, 116, 'Ekiti South West'),
(247, 13, 40, 114, 'Ekiti West'),
(248, 13, 39, 112, 'Emure'),
(249, 13, 39, 112, 'Gbonyin'),
(250, 13, 38, 111, 'Ido/Osi'),
(251, 13, 40, 114, 'Ijero'),
(252, 13, 39, 116, 'Ikere'),
(253, 13, 38, 113, 'Ikole'),
(254, 13, 38, 111, 'Ilejeme'),
(255, 13, 40, 115, 'Irepodun-Ifelodun'),
(256, 13, 39, 116, 'Ise/Orun'),
(257, 13, 38, 111, 'Moba'),
(258, 13, 38, 113, 'Oye'),
(259, 14, 43, 120, 'Aninri'),
(260, 14, 43, 120, 'Agwu'),
(261, 14, 42, 118, 'Enugu East'),
(262, 14, 42, 117, 'Enugu North'),
(263, 14, 42, 117, 'Enugu South'),
(264, 14, 43, 119, 'Ezeagu'),
(265, 14, 41, 121, 'Igbo-Etiti'),
(266, 14, 41, 514, 'Igboeze North'),
(267, 14, 41, 123, 'Igbo-Eze South'),
(268, 14, 42, 118, 'Isi-Uzo'),
(269, 14, 42, 122, 'Nkanu East'),
(270, 14, 42, 122, 'Nkanu West'),
(271, 14, 41, 123, 'Nsukka'),
(272, 14, 43, 120, 'Oji-Uzo'),
(273, 14, 41, 514, 'Udenu'),
(274, 14, 43, 119, 'Udi'),
(275, 14, 41, 121, 'Uzo-Uwani'),
(276, 15, 1, 1, 'Abaji'),
(277, 15, 1, 2, 'Bwari'),
(278, 15, 1, 1, 'Gwagwalada'),
(279, 15, 1, 1, 'Kuje'),
(280, 15, 1, 1, 'Kwali'),
(281, 15, 1, 2, 'Abuja Municipal'),
(282, 16, 44, 124, 'Akko'),
(283, 16, 46, 130, 'Balanga'),
(284, 16, 46, 130, 'Billiri'),
(285, 16, 45, 129, 'Dukku'),
(286, 16, 45, 126, 'Funakaye'),
(287, 16, 45, 126, 'Gombe'),
(288, 16, 46, 127, 'Kaltungo'),
(289, 16, 45, 126, 'Kwami'),
(290, 16, 45, 129, 'Nafada'),
(291, 16, 46, 127, 'Shongom'),
(292, 16, 44, 125, 'Yamaltu-Deba'),
(293, 17, 48, 131, 'Aboh Mbaise'),
(294, 17, 48, 136, 'Ahiazu Mbaise'),
(295, 17, 47, 140, 'Ehimembano'),
(296, 17, 48, 136, 'Ezinihitte'),
(297, 17, 49, 138, 'Ideato North'),
(298, 17, 49, 138, 'Ideato South'),
(299, 17, 47, 140, 'Ihitte Uboma'),
(300, 17, 48, 133, 'Ikeduru'),
(301, 17, 47, 135, 'Isiala Mbano'),
(302, 17, 49, 134, 'Isu'),
(303, 17, 48, 133, 'Mbaitolu'),
(304, 17, 48, 131, 'Ngor Okpala'),
(305, 17, 49, 134, 'Njaba'),
(306, 17, 49, 134, 'Nkwerre'),
(307, 17, 49, 134, 'Nwangele'),
(308, 17, 47, 140, 'Obowo'),
(309, 17, 49, 132, 'Oguta'),
(310, 17, 49, 132, 'Ohaji-Egbema'),
(311, 17, 47, 135, 'Okigwe'),
(312, 17, 49, 137, 'Orlu'),
(313, 17, 49, 137, 'Orsu'),
(314, 17, 49, 137, 'Oru East'),
(315, 17, 49, 132, 'Oru West'),
(316, 17, 48, 139, 'Owerri Municipal'),
(317, 17, 48, 139, 'Owerri North'),
(318, 17, 48, 139, 'Owerri West'),
(319, 17, 47, 135, 'Onuimo'),
(320, 18, 50, 141, 'Auyo'),
(321, 18, 51, 148, 'Babura'),
(322, 18, 50, 149, 'Birniwa'),
(323, 18, 52, 143, 'Birnin-Kudu'),
(324, 18, 52, 143, 'Buji'),
(325, 18, 52, 144, 'Dutse'),
(326, 18, 51, 150, 'Gagara'),
(327, 18, 51, 148, 'Garki'),
(328, 18, 51, 150, 'Gumel'),
(329, 18, 50, 149, 'Guri'),
(330, 18, 52, 147, 'Gwaram'),
(331, 18, 51, 145, 'Gwiwa'),
(332, 18, 50, 141, 'Hadejia'),
(333, 18, 52, 512, 'Jahun'),
(334, 18, 50, 141, 'Kafin Hausa'),
(335, 18, 51, 145, 'Kazaure'),
(336, 18, 50, 149, 'Kiri-Kasamma'),
(337, 18, 52, 144, 'Kiyawa'),
(338, 18, 50, 142, 'Kaugama'),
(339, 18, 51, 150, 'Maigatar'),
(340, 18, 50, 142, 'Mallam Madori'),
(341, 18, 52, 512, 'Miga'),
(342, 18, 51, 146, 'Ringim'),
(343, 18, 51, 145, 'Roni'),
(344, 18, 51, 150, 'Sule Tankarkar'),
(345, 18, 51, 146, 'Taura'),
(346, 18, 51, 145, 'Yankwashi'),
(347, 19, 53, 164, 'Birnin-Gwari'),
(348, 19, 53, 153, 'Chikun'),
(349, 19, 53, 164, 'Giwa'),
(350, 19, 53, 163, 'Igabi'),
(351, 19, 54, 156, 'Ikara'),
(352, 19, 55, 162, 'Jaba'),
(353, 19, 55, 161, 'Jemaa'),
(354, 19, 55, 155, 'Kachia'),
(355, 19, 53, 160, 'Kaduna North'),
(356, 19, 53, 154, 'Kaduna South'),
(357, 19, 55, 155, 'Kagarko'),
(358, 19, 53, 153, 'Kajuru'),
(359, 19, 55, 159, 'Kaura'),
(360, 19, 55, 151, 'Kauru'),
(361, 19, 54, 156, 'Kubau'),
(362, 19, 54, 158, 'Kudan'),
(363, 19, 54, 166, 'Lere'),
(364, 19, 54, 158, 'Makarfi'),
(365, 19, 54, 157, 'Sabon Gari'),
(366, 19, 55, 161, 'Sanga'),
(367, 19, 54, 152, 'Soba'),
(368, 19, 56, 162, 'Zangon Kataf'),
(369, 19, 54, 165, 'Zaria'),
(370, 20, 56, 170, 'Ajingi'),
(371, 20, 56, 170, 'Alabasu'),
(372, 20, 57, 167, 'Bagwai'),
(373, 20, 56, 181, 'Bebeji'),
(374, 20, 57, 184, 'Bichi'),
(375, 20, 56, 168, 'Bunkure'),
(376, 20, 58, 186, 'Dala'),
(377, 20, 57, 172, 'Dambatta'),
(378, 20, 58, 190, 'Dawakin Kudu'),
(379, 20, 57, 189, 'Dawakin-Tofa'),
(380, 20, 56, 176, 'Doguwa'),
(381, 20, 58, 178, 'Fagge'),
(382, 20, 57, 169, 'Gabasawa'),
(383, 20, 56, 175, 'Garko'),
(384, 20, 58, 182, 'Garun Malam'),
(385, 20, 56, 170, 'Gaya'),
(386, 20, 58, 169, 'Gezawa'),
(387, 20, 58, 174, 'Gwale'),
(388, 20, 57, 180, 'Gwarzo'),
(389, 20, 54, 180, 'Ikabo'),
(390, 20, 58, 179, 'Kano Municipal'),
(391, 20, 54, 185, 'Karaye'),
(392, 20, 56, 168, 'Kibiya'),
(393, 20, 56, 181, 'Kiru'),
(394, 20, 58, 183, 'Kumbotso'),
(395, 20, 57, 177, 'Kunchi'),
(396, 20, 58, 182, 'Kura'),
(397, 20, 58, 182, 'Madobi'),
(398, 20, 57, 172, 'Makoda'),
(399, 20, 58, 188, 'Minjibir'),
(400, 20, 58, 173, 'Nasarawa'),
(401, 20, 56, 168, 'Rano'),
(402, 20, 57, 189, 'Rimin Gado'),
(403, 20, 56, 185, 'Rogo'),
(404, 20, 57, 167, 'Shanono'),
(405, 20, 56, 187, 'Sumaila'),
(406, 20, 56, 187, 'Takai'),
(407, 20, 58, 171, 'Tarauni'),
(408, 20, 57, 189, 'Tofa'),
(409, 20, 57, 177, 'Tsanyawa'),
(410, 20, 56, 176, 'Tudun-Wada'),
(411, 20, 58, 188, 'Ungogo'),
(412, 20, 58, 190, 'Warawa'),
(413, 20, 56, 175, 'Wudil'),
(414, 21, 59, 194, 'Bakori'),
(415, 21, 60, 197, 'Batagarawa'),
(416, 21, 60, 200, 'Batsari'),
(417, 21, 61, 204, 'Baure'),
(418, 21, 61, 192, 'Bindawa'),
(419, 21, 60, 197, 'Charanchi'),
(420, 21, 59, 198, 'Dandume'),
(421, 21, 59, 194, 'Danja'),
(422, 21, 60, 200, 'Dan Musa'),
(423, 21, 61, 196, 'Daura'),
(424, 21, 61, 193, 'Dutsi'),
(425, 21, 60, 201, 'Dutsin-Ma'),
(426, 21, 59, 195, 'Faskari'),
(427, 21, 59, 198, 'Funtua'),
(428, 21, 61, 199, 'Ingawa'),
(429, 21, 60, 203, 'Jibia'),
(430, 21, 59, 202, 'Kafur'),
(431, 21, 60, 203, 'Kaita'),
(432, 21, 59, 195, 'Kankara'),
(433, 21, 61, 199, 'Kankia'),
(434, 21, 60, 515, 'Katsina'),
(435, 21, 60, 201, 'Kurfi'),
(436, 21, 61, 199, 'Kusada'),
(437, 21, 61, 196, 'MaiAdua'),
(438, 21, 59, 202, 'MalumFashi'),
(439, 21, 61, 192, 'Mani'),
(440, 21, 61, 193, 'Mashi'),
(441, 21, 59, 191, 'Matazu'),
(442, 21, 59, 191, 'Musawa'),
(443, 21, 60, 197, 'Rimi'),
(444, 21, 59, 195, 'Sabuwa'),
(445, 21, 60, 200, 'Safana'),
(446, 21, 61, 196, 'Sandamu'),
(447, 21, 61, 204, 'Zango'),
(448, 22, 62, 209, 'Aliero'),
(449, 22, 64, 211, 'Arewa/Dandi'),
(450, 22, 64, 206, 'Argungu'),
(451, 22, 64, 206, 'Augie'),
(452, 22, 64, 205, 'Bagudo'),
(453, 22, 62, 207, 'Birnin Kebbi'),
(454, 22, 62, 207, 'Bunza'),
(455, 22, 64, 211, 'Dandi'),
(456, 22, 63, 212, 'Fakai'),
(457, 22, 62, 209, 'Gwandu'),
(458, 22, 64, 209, 'Jega'),
(459, 22, 62, 207, 'Kalgo'),
(460, 22, 62, 210, 'Koko/Besse'),
(461, 22, 62, 210, 'Maiyama'),
(462, 22, 63, 208, 'Ngaski'),
(463, 22, 63, 212, 'Sakaba'),
(464, 22, 63, 208, 'Shanga'),
(465, 22, 64, 205, 'Suru'),
(466, 22, 63, 212, 'Wasagu'),
(467, 22, 63, 208, 'Yauri'),
(468, 22, 63, 212, 'Zuru'),
(469, 23, 65, 218, 'Adavi'),
(470, 23, 65, 216, 'Ajaokuta'),
(471, 23, 66, 219, 'Ankpa'),
(472, 23, 66, 213, 'Bassa'),
(473, 23, 66, 213, 'Dekina'),
(474, 23, 66, 220, 'Ibaji'),
(475, 23, 66, 220, 'Idah'),
(476, 23, 66, 220, 'Igalamela'),
(477, 23, 67, 221, 'Ijumu'),
(478, 23, 67, 221, 'Kabba/Bunu'),
(479, 23, 67, 215, 'Kogi'),
(480, 23, 67, 215, 'Lokoja'),
(481, 23, 67, 214, 'Mopa-Muro'),
(482, 23, 66, 220, 'Ofu'),
(483, 23, 65, 217, 'Ogori-Magogo'),
(484, 23, 65, 218, 'Okehi'),
(485, 23, 65, 217, 'Okene'),
(486, 23, 66, 219, 'Olamaboro'),
(487, 23, 66, 219, 'Omala'),
(488, 23, 67, 214, 'Yagba East'),
(489, 23, 67, 214, 'Yagba West'),
(490, 24, 68, 223, 'Asa'),
(491, 24, 70, 227, 'Baruten'),
(492, 24, 70, 222, 'Edu'),
(493, 24, 69, 226, 'Ekiti'),
(494, 24, 69, 224, 'Ifelodun'),
(495, 24, 68, 225, 'Ilorin East'),
(496, 24, 68, 225, 'Ilorin South'),
(497, 24, 68, 223, 'Ilorin West'),
(498, 24, 69, 226, 'Irepodun'),
(499, 24, 69, 226, 'Isin'),
(500, 24, 70, 227, 'Kaiama'),
(501, 24, 70, 222, 'Moro'),
(502, 24, 68, 224, 'Offa'),
(503, 24, 69, 226, 'Oke-ero'),
(504, 24, 69, 224, 'Oyun'),
(505, 24, 70, 222, 'Patigi'),
(506, 25, 73, 235, 'Agege'),
(507, 25, 73, 244, 'Ajeromi-Ifelodun'),
(508, 25, 73, 240, 'Alimosho'),
(509, 25, 73, 247, 'Amuwo Odofin'),
(510, 25, 71, 248, 'Apapa'),
(511, 25, 73, 242, 'Badagry'),
(512, 25, 72, 234, 'Epe'),
(513, 25, 71, 237, 'Eti-Osa'),
(514, 25, 72, 241, 'Ibeju-Lekki'),
(515, 25, 73, 231, 'Ifako-Ijaiye'),
(516, 25, 73, 228, 'Ikeja'),
(517, 25, 72, 229, 'Ikorodu'),
(518, 25, 72, 238, 'Kosofe'),
(519, 25, 71, 243, 'Lagos Island'),
(520, 25, 71, 232, 'Lagos Mainland'),
(521, 25, 73, 230, 'Mushin'),
(522, 25, 73, 239, 'Ojo'),
(523, 25, 73, 233, 'Oshodi-Isolo'),
(524, 25, 72, 245, 'Somolu'),
(525, 25, 71, 236, 'Surulere'),
(526, 26, 75, 254, 'Akwanga'),
(527, 26, 76, 255, 'Awe'),
(528, 26, 76, 255, 'Doma'),
(529, 26, 74, 252, 'Karu'),
(530, 26, 76, 255, 'Keana'),
(531, 26, 74, 252, 'Keffi'),
(532, 26, 74, 252, 'Kokona'),
(533, 26, 76, 251, 'Lafia'),
(534, 26, 74, 253, 'Nasarawa'),
(535, 26, 75, 254, 'Nasarawa Eggon'),
(536, 26, 76, 251, 'Obi'),
(537, 26, 74, 253, 'Toto'),
(538, 26, 75, 254, 'Wamba'),
(539, 27, 79, 264, 'Agaie'),
(540, 27, 78, 258, 'Agwara'),
(541, 27, 79, 257, 'Bida'),
(542, 27, 78, 258, 'Borgu'),
(543, 27, 77, 262, 'Bosso'),
(544, 27, 77, 265, 'Chanchaga'),
(545, 27, 79, 259, 'Edati'),
(546, 27, 79, 257, 'Gbako'),
(547, 27, 77, 263, 'Gurara'),
(548, 27, 79, 257, 'Katcha'),
(549, 27, 78, 260, 'Kontagora'),
(550, 27, 79, 264, 'Lapai'),
(551, 27, 79, 259, 'Lavun'),
(552, 27, 78, 256, 'Magama'),
(553, 27, 78, 260, 'Mariga'),
(554, 27, 78, 260, 'Mashe'),
(555, 27, 79, 259, 'Mokwa'),
(556, 27, 77, 261, 'Munya'),
(557, 27, 77, 262, 'Paikoro'),
(558, 27, 77, 261, 'Rafi'),
(559, 27, 78, 256, 'Rijau'),
(560, 27, 77, 261, 'Shiroro'),
(561, 27, 77, 263, 'Suleja'),
(562, 27, 77, 263, 'Tafa'),
(563, 27, 78, 260, 'Wushishi'),
(564, 28, 80, 266, 'Abeokuta North'),
(565, 28, 80, 268, 'Abeokuta South'),
(566, 28, 82, 270, 'Ado-Odo/Ota'),
(567, 28, 82, 274, 'Egbado North'),
(568, 28, 82, 267, 'Egbado South'),
(569, 28, 80, 273, 'Ewekoro'),
(570, 28, 80, 273, 'Ifo'),
(571, 28, 81, 269, 'Ijebu East'),
(572, 28, 81, 269, 'Ijebu North'),
(573, 28, 81, 272, 'Ijebu North East'),
(574, 28, 81, 272, 'Ijebu Ode'),
(575, 28, 81, 271, 'Ikenne'),
(576, 28, 82, 274, 'Imeko Afon'),
(577, 28, 82, 267, 'Ipokia'),
(578, 28, 80, 266, 'Obafemi-Owode'),
(579, 28, 80, 266, 'Odeda'),
(580, 28, 81, 272, 'Odogbolu'),
(581, 28, 81, 269, 'Ogun Waterside'),
(582, 28, 81, 271, 'Remo North'),
(583, 28, 81, 271, 'Shagamu'),
(584, 29, 83, 279, 'Akoko North East'),
(585, 29, 83, 279, 'Akoko North West'),
(586, 29, 83, 278, 'Akoko South West'),
(587, 29, 83, 278, 'Akoko South East'),
(588, 29, 84, 275, 'Akure North'),
(589, 29, 84, 275, 'Akure South'),
(590, 29, 85, 283, 'Eseodo'),
(591, 29, 84, 282, 'Idanre'),
(592, 29, 84, 282, 'Ifedore'),
(593, 29, 85, 283, 'Ilaje'),
(594, 29, 85, 281, 'Ileoluji-Okeigbo'),
(595, 29, 85, 280, 'Irele'),
(596, 29, 85, 281, 'Odigbo'),
(597, 29, 85, 280, 'Okitipupa'),
(598, 29, 84, 277, 'Ondo East'),
(599, 29, 84, 277, 'Ondo West'),
(600, 29, 83, 276, 'Ose'),
(601, 29, 83, 276, 'Owo'),
(602, 30, 87, 292, 'Atakunmosa East'),
(603, 30, 87, 292, 'Atakunmosa West'),
(604, 30, 88, 287, 'Ayedaade'),
(605, 30, 88, 288, 'Ayedire'),
(606, 30, 86, 286, 'Boluwaduro'),
(607, 30, 86, 291, 'Boripe'),
(608, 30, 88, 285, 'Ede North'),
(609, 30, 88, 285, 'Ede South'),
(610, 30, 87, 290, 'Ife Central'),
(611, 30, 87, 290, 'Ife East'),
(612, 30, 87, 290, 'Ife North'),
(613, 30, 87, 290, 'Ife South'),
(614, 30, 88, 285, 'Egbedore'),
(615, 30, 88, 285, 'Ejigbo'),
(616, 30, 86, 286, 'Ifedayo'),
(617, 30, 86, 291, 'Ifelodun'),
(618, 30, 86, 286, 'Illa'),
(619, 30, 87, 292, 'Ilesha East'),
(620, 30, 87, 292, 'Ilesha West'),
(621, 30, 86, 293, 'Irepodun'),
(622, 30, 88, 287, 'Irewole'),
(623, 30, 88, 287, 'Isokan'),
(624, 30, 88, 288, 'Iwo'),
(625, 30, 87, 294, 'Obokun'),
(626, 30, 86, 291, 'Odo-Otin'),
(627, 30, 88, 288, 'Ola-Oluwa'),
(628, 30, 86, 293, 'Olorunda'),
(629, 30, 87, 294, 'Oriade'),
(630, 30, 86, 293, 'Orolu'),
(631, 30, 86, 293, 'Osogbo'),
(632, 31, 89, 295, 'Afijio'),
(633, 31, 89, 301, 'Akinyele'),
(634, 31, 89, 295, 'Atiba'),
(635, 31, 90, 296, 'Atigbo'),
(636, 31, 89, 299, 'Egbeda'),
(637, 31, 91, 298, 'Ibadan North'),
(638, 31, 91, 297, 'Ibadan North-East'),
(639, 31, 91, 304, 'Ibadan North West'),
(640, 31, 91, 297, 'Ibadan South-East'),
(641, 31, 91, 304, 'Ibadan South West'),
(642, 31, 91, 305, 'Ibarapa Central'),
(643, 31, 91, 302, 'Ibarapa East'),
(644, 31, 91, 305, 'Ibarapa North'),
(645, 31, 91, 302, 'Ido'),
(646, 31, 90, 308, 'Irepo'),
(647, 31, 90, 300, 'Iseyin'),
(648, 31, 90, 300, 'Itesiwaju'),
(649, 31, 90, 300, 'Iwajowa'),
(650, 31, 90, 300, 'Kajola'),
(651, 31, 89, 301, 'Lagelu'),
(652, 31, 90, 307, 'Ogbomosho North'),
(653, 31, 90, 307, 'Ogbomosho South'),
(654, 31, 89, 306, 'Ogo-Oluwa'),
(655, 31, 90, 308, 'Olorunsogo'),
(656, 31, 89, 303, 'Oluyole'),
(657, 31, 89, 299, 'Ona-Ara'),
(658, 31, 90, 308, 'Orelope'),
(659, 31, 90, 307, 'Orire'),
(660, 31, 89, 295, 'Oyo West'),
(661, 31, 89, 295, 'Oyo East'),
(662, 31, 90, 296, 'Saki East'),
(663, 31, 90, 296, 'Saki West'),
(664, 31, 89, 306, 'Surulere'),
(665, 32, 93, 316, 'Bokkos'),
(666, 32, 94, 314, 'Barkin Ladi'),
(667, 32, 94, 310, 'Bassa'),
(668, 32, 94, 312, 'Jos East'),
(669, 32, 94, 310, 'Jos North'),
(670, 32, 94, 312, 'Jos South'),
(671, 32, 93, 309, 'Kanam'),
(672, 32, 93, 309, 'Kanke'),
(673, 32, 92, 313, 'Langtang South'),
(674, 32, 92, 313, 'Langtang North'),
(675, 32, 93, 316, 'Mangu'),
(676, 32, 92, 311, 'Mikang'),
(677, 32, 93, 309, 'Pankshin'),
(678, 32, 92, 311, 'Qua\'an Pan'),
(679, 32, 94, 314, 'Riyom'),
(680, 32, 92, 311, 'Shendam'),
(681, 32, 92, 315, 'Wase'),
(682, 33, 96, 326, 'Abua/Odual'),
(683, 33, 96, 326, 'Ahoada East'),
(684, 33, 96, 320, 'Ahoada-West'),
(685, 33, 96, 322, 'Akuku-Toru'),
(686, 33, 97, 329, 'Andoni'),
(687, 33, 96, 322, 'Asari-Toru'),
(688, 33, 96, 317, 'Bonny'),
(689, 33, 96, 317, 'Degema'),
(690, 33, 97, 325, 'Eleme'),
(691, 33, 95, 319, 'Emohua'),
(692, 33, 95, 324, 'Etche'),
(693, 33, 97, 323, 'Gokana'),
(694, 33, 95, 319, 'Ikwerre'),
(695, 33, 97, 323, 'Khana'),
(696, 33, 95, 327, 'Obio/Akpor'),
(697, 33, 96, 320, 'Ogba-Egbema-Ndoni'),
(698, 33, 95, 318, 'Ogu-Bolo'),
(699, 33, 95, 318, 'Okrika'),
(700, 33, 95, 324, 'Omuma'),
(701, 33, 97, 329, 'Opobo/Nkoro'),
(702, 33, 97, 325, 'Oyigbo'),
(703, 33, 95, 321, 'Port Harcourt'),
(704, 33, 97, 325, 'Tai'),
(705, 34, 98, 331, 'Binji'),
(706, 34, 100, 339, 'Bodinga'),
(707, 34, 100, 339, 'Dange-Shuni'),
(708, 34, 99, 338, 'Gada'),
(709, 34, 99, 338, 'Goronyo'),
(710, 34, 98, 336, 'Gudu'),
(711, 34, 99, 334, 'Gwadabawa'),
(712, 34, 99, 334, 'Ilella'),
(713, 34, 99, 333, 'Isa'),
(714, 34, 100, 337, 'Kebbe'),
(715, 34, 98, 335, 'Kware'),
(716, 34, 99, 332, 'Rabah'),
(717, 34, 99, 333, 'Sabon-Birni'),
(718, 34, 100, 340, 'Shagari'),
(719, 34, 98, 331, 'Silame'),
(720, 34, 98, 330, 'Sokoto North'),
(721, 34, 98, 330, 'Sokoto South'),
(722, 34, 100, 337, 'Tambuwa'),
(723, 34, 98, 336, 'Tangaza'),
(724, 34, 100, 339, 'Tureta'),
(725, 34, 98, 335, 'Wamakko'),
(726, 34, 99, 332, 'Wurno'),
(727, 34, 100, 340, 'Yabo'),
(728, 35, 101, 345, 'Ardo-Kola'),
(729, 35, 102, 346, 'Bali'),
(730, 35, 103, 341, 'Donga'),
(731, 35, 102, 342, 'Gashaka'),
(732, 35, 102, 346, 'Gassol'),
(733, 35, 103, 344, 'Ibi'),
(734, 35, 101, 343, 'Jalingo'),
(735, 35, 101, 345, 'Karim-Lamido'),
(736, 35, 102, 342, 'Kurmi'),
(737, 35, 101, 345, 'Lau'),
(738, 35, 102, 342, 'Sardauna'),
(739, 35, 103, 341, 'Takum'),
(740, 35, 103, 341, 'Ussa'),
(741, 35, 103, 344, 'Wukari'),
(742, 35, 101, 343, 'Yorro'),
(743, 35, 101, 343, 'Zing'),
(744, 36, 104, 352, 'Bade'),
(745, 36, 106, 349, 'Bursari'),
(746, 36, 105, 350, 'Damaturu'),
(747, 36, 105, 348, 'Fika'),
(748, 36, 105, 348, 'Fune'),
(749, 36, 106, 349, 'Geidam'),
(750, 36, 106, 350, 'Gujba'),
(751, 36, 106, 350, 'Gulani'),
(752, 36, 104, 352, 'Jakusko'),
(753, 36, 104, 347, 'Karasuwa'),
(754, 36, 104, 347, 'Machina'),
(755, 36, 105, 351, 'Nangere'),
(756, 36, 104, 347, 'Nguru'),
(757, 36, 105, 351, 'Potiskum'),
(758, 36, 106, 350, 'Tarmuwa'),
(759, 36, 106, 349, 'Yunusari'),
(760, 36, 104, 347, 'Yusufari'),
(761, 37, 107, 353, 'Anka'),
(762, 37, 107, 356, 'Bakura'),
(763, 37, 109, 357, 'Birnin-Magaji'),
(764, 37, 107, 359, 'Bukkuyum'),
(765, 37, 108, 354, 'Bungudu'),
(766, 37, 107, 359, 'Gummi'),
(767, 37, 108, 358, 'Gusau'),
(768, 37, 109, 357, 'Kaura-Namoda'),
(769, 37, 107, 356, 'Maradun'),
(770, 37, 108, 354, 'Maru'),
(771, 37, 109, 355, 'Shinkafi'),
(772, 37, 109, 353, 'Talata Marafa'),
(773, 37, 108, 358, 'Tsafe'),
(774, 37, 109, 355, 'Zurmi');

-- --------------------------------------------------------

--
-- Table structure for table `representative_district_tbl`
--

CREATE TABLE `representative_district_tbl` (
  `district_id` int(11) NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  `district_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `representative_district_tbl`
--

INSERT INTO `representative_district_tbl` (`district_id`, `state_id`, `district_name`) VALUES
(1, 15, 'Kuje/Abaji/Gwagwalada/Kwali'),
(2, 15, 'Abuja Municipal/Bwari'),
(3, 1, 'Ikwuano/Umuahia North/Umuahia South'),
(4, 1, 'Bende'),
(5, 1, 'Isuikwuato/Umunneochi'),
(6, 1, 'Arochukwu/Ohafia'),
(7, 1, 'Aba North/Aba South'),
(8, 1, 'Ukwa East/Ukwa West'),
(9, 1, 'Isiala Ngwa North/Isiala Ngwa South'),
(10, 1, 'Obingwa/Osisioma/Ugwunagbo'),
(11, 2, 'Jada/Ganye/Mayo Belwa/Toungo'),
(12, 2, 'Guyuk/Shelleng'),
(13, 2, 'Hong/Gombi'),
(14, 2, 'Mubi North/Mubi South/Maiha'),
(15, 2, 'Fufore/Song'),
(16, 2, 'Michika/Madagali'),
(17, 2, 'Demsa/Numan/Lamurde'),
(18, 2, 'Yola North/Yola South/Girei'),
(19, 3, 'Ukanafun/Orukanam'),
(20, 3, 'Etinan/Nsit Ibom/Nsit Ubium'),
(21, 3, 'Itu/Ibiono Ibom'),
(22, 3, 'Eket/Esit Eket/Onna/Ibeno'),
(23, 3, 'Ikot Ekpene/Essien Udim/Obot Akara'),
(24, 3, 'Abak/Etim Ekpo/Ika'),
(25, 3, 'Ikono/Ini'),
(26, 3, 'Oron/Mbo/Okobo/UrueOffong/Oruko/Udung-Uko'),
(27, 3, 'Ikot Abasi/Mkpat Enin/Eastern Obolo'),
(28, 3, 'Uyo/Uruan/Nsit Ata/Ibeskip Asutan'),
(29, 4, 'Anambra East/Anambra West'),
(30, 4, 'Anaocha/Njikoka/Dunukofia'),
(31, 4, 'Aguta'),
(32, 4, 'Nnewi North/Nnewi South/Ekwusigo'),
(33, 4, 'Onitsha North/Onitsha South'),
(34, 4, 'Awka North/Awka South'),
(35, 4, 'Orumba North/Orumba South'),
(36, 4, 'Ihiala'),
(37, 4, 'Oyi/Ayamelum'),
(38, 4, 'Idemili North/Idemili South'),
(39, 4, 'Ogbaru'),
(40, 5, 'Misau/Dambam'),
(41, 5, 'Zaki'),
(42, 5, 'Katagum'),
(43, 5, 'Bogoro/Dass/Tafawa Balewa'),
(44, 5, 'Gamawa'),
(45, 5, 'Jama\'are/Itas-Gadau'),
(46, 5, 'Bauchi'),
(47, 5, 'Darazo/Gunjuwa'),
(48, 5, 'Ningi/Warji'),
(49, 5, 'Shira/Giade'),
(50, 5, 'Toro'),
(51, 6, 'Yenagoa/Kolokuma/Opokuma'),
(52, 6, 'Ogbia'),
(53, 6, 'Sagbama/Ekeremor'),
(54, 6, 'Southern Ijaw'),
(55, 6, 'Brass/Nembe'),
(56, 7, 'Apa/Agatu'),
(57, 7, 'Kwande/Ushongo'),
(58, 7, 'Igede'),
(59, 7, 'Vandeikya/Konshisha'),
(60, 7, 'Buruku'),
(61, 7, 'Ado/Obadigbo/Opkokwu'),
(62, 7, 'Katsina-Ala/Ukum/Logo'),
(63, 7, 'Gboko/Tarka'),
(64, 7, 'Makurdi/Guma'),
(65, 7, 'Gwer East/Gwer West'),
(66, 7, 'Otukpo/Ohimini'),
(67, 7, 'Oju/Obi'),
(68, 8, 'Jere'),
(69, 8, 'Bama/Ngala/Kalabalge'),
(70, 8, 'Askira-Uba/Hawul'),
(71, 8, 'Dikwa/Mafaf/Konduga'),
(72, 8, 'Kukawa/Mobbar/Abadam/Guzamala'),
(73, 8, 'Damboa/Gwoza/Chibok'),
(74, 8, 'Monguno/Marte/Nganzai'),
(75, 8, 'Biu/Bayo/Shani/Kwaya Kusar'),
(76, 8, 'Maiduguri (Metropolitan)'),
(77, 8, 'Kaga/Gubio/Magumeri'),
(78, 9, 'Calabar Municipal/Odukpani'),
(79, 9, 'Ogoja/Yala'),
(80, 9, 'Ikom/Boki'),
(81, 9, 'Yakurr/Abi'),
(82, 9, 'Bekwarra/Obudu/Obanliku'),
(83, 9, 'Akpabuyo/Bakassi/Calabar South'),
(84, 9, 'Akamkpa/Biase'),
(85, 9, 'Obubra/Etung'),
(86, 10, 'Ethiope East/Ethiope West'),
(87, 10, 'Ughelli North/Ughelli South/Udu'),
(88, 10, 'Ndokwa East/Ndokwa West/Ukwani'),
(89, 10, 'Opke/Sapele/Uvwie'),
(90, 10, 'Isoko North/Isoko South'),
(91, 10, 'Burutu'),
(92, 10, 'Warri'),
(93, 10, 'Ika North East/Ika South'),
(94, 10, 'Aniocha North/Aniocha South/Oshimili North/Oshimili South'),
(95, 10, 'Bomadi/Patani'),
(96, 11, 'Ikwo/Ezza South'),
(97, 11, 'Ohaukwu/Ebonyi'),
(98, 11, 'Ezza North/Ishielu'),
(99, 11, 'Ivo/Ohaozara/Onicha'),
(100, 11, 'Afikpo North/Afikpo South'),
(101, 11, 'Abakaliki/Izzi'),
(102, 12, 'Egor/Ikpoba-okha'),
(103, 12, 'Owan West/Owan East'),
(104, 12, 'Esan North-East/Esan South-East'),
(105, 12, 'Esan Central/Esan West/Igueben'),
(106, 12, 'Ovia South-West/Ovia North-East'),
(107, 12, 'Akoko-Edo'),
(108, 12, 'Etsako East/Etsako West/Etsako Central'),
(109, 12, 'Orhionmwon/Uhunmwode'),
(110, 12, 'Oredo'),
(111, 13, 'Ido/Osi/Moba/Ilejeme '),
(112, 13, 'Emure/Gbonyin/Ekiti East'),
(113, 13, 'Ikole/Oye'),
(114, 13, 'Ijero/Ekiti West/Efon'),
(115, 13, 'Ado Ekiti/Irepodun-Ifelodun'),
(116, 13, 'Ekiti South West/Ikere/Ise/Orun'),
(117, 14, 'Enugu North/Enugu South'),
(118, 14, 'Enugu East/Isi-Uzo'),
(119, 14, 'Ezeagu/Udi'),
(120, 14, 'Aninri/Agwu/Oji-uzo'),
(121, 14, 'Igbo-Etiti/Uzo-Uwani'),
(122, 14, 'Nkanu East/Nkanu West'),
(123, 14, 'Nsukka/Igbo-Eze South'),
(124, 16, 'Akko'),
(125, 16, 'Yamaltu-Deba'),
(126, 16, 'Gombe/Kwami/Funakaye'),
(127, 16, 'Kaltungo/Shongom'),
(128, 16, 'Akko Federal Constituency'),
(129, 16, 'Dukku/Nafada'),
(130, 16, 'Balanga/Billiri'),
(131, 17, 'Aboh Mbaise/Ngor Okpala'),
(132, 17, 'Oguta/Ohaji-Egbema/Oru West'),
(133, 17, 'Mbaitolu/ikeduru'),
(134, 17, 'Isu/Njaba/Nkwerre/Nwangele'),
(135, 17, 'Isiala Mbano/Okigwe/Onuimo'),
(136, 17, 'Ahiazu Mbaise/Ezinihitte'),
(137, 17, 'Orlu/Oru East/Orsu'),
(138, 17, 'Ideato North/Ideato South'),
(139, 17, 'Owerri Municipal/Owerri North/Owerri West'),
(140, 17, 'Ehimembano/Ihitte Uboma/Obowo'),
(141, 18, 'Hadejia/Kafin Hausa/Auyo'),
(142, 18, 'Mallam Madori/Kaugama'),
(143, 18, 'Birnin-Kudu/Buji'),
(144, 18, 'Dutse/Kiyawa'),
(145, 18, 'Kazaure/Roni/Gwiwa/Yankwashi'),
(146, 18, 'Ringim/Taura'),
(147, 18, 'Gwaram'),
(148, 18, 'Babura/Garki'),
(149, 18, 'Birniwa/Guri/Kiri-Kasamma'),
(150, 18, 'Gumel/Maigatari/Sule Tankarkar/Gagarawa'),
(151, 19, 'Kauru'),
(152, 19, 'Soba'),
(153, 19, 'Chikun/Kajuru'),
(154, 19, 'Kaduna South'),
(155, 19, 'Kachia/Kagarko'),
(156, 19, 'Ikara/Kubau'),
(157, 19, 'Sabon Gari'),
(158, 19, 'Makarfi/Kudan'),
(159, 19, 'Kaura'),
(160, 19, 'Kaduna North'),
(161, 19, 'Jemaa/Sanga'),
(162, 19, 'Zangon Kataf/Jaba'),
(163, 19, 'Igabi'),
(164, 19, 'Birnin-Gwari/Giwa'),
(165, 19, 'Zaria'),
(166, 19, 'Lere'),
(167, 20, 'Bagwai/Shanono'),
(168, 20, 'Rano/Bunkure/Kibiya'),
(169, 20, 'Gezawa/Gabasawa'),
(170, 20, 'Alabasu/Gaya/Ajingi'),
(171, 20, 'Tarauni'),
(172, 20, 'Dambatta/Makoda'),
(173, 20, 'Nassarawa'),
(174, 20, 'Gwale'),
(175, 20, 'Wudil/Garko'),
(176, 20, 'Tudun-Wada/Doguwa'),
(177, 20, 'Tsanyawa/Kunchi'),
(178, 20, 'Fagge'),
(179, 20, 'Kano Municipal'),
(180, 20, 'Gwarzo/Ikabo'),
(181, 20, 'Bebeji/Kiru'),
(182, 20, 'Kura/Madobi/Garun Malam'),
(183, 20, 'Kumbotso'),
(184, 20, 'Bichi'),
(185, 20, 'Karaye/Rogo'),
(186, 20, 'Dala'),
(187, 20, 'Sumaila/Takai'),
(188, 20, 'Minjibir/Ungogo'),
(189, 20, 'Dawakin-Tofa/Tofa/Rimin Gado'),
(190, 20, 'Dawakin Kudu/Warawa'),
(191, 21, 'Musawa/Matazu'),
(192, 21, 'Mani/Bindawa'),
(193, 21, 'Mashi/Dutsi'),
(194, 21, 'Bakori/Danja'),
(195, 21, 'Kankara/Sabuwa/Faskari'),
(196, 21, 'Daura/Sandamu/MaiAdua'),
(197, 21, 'Rimi/Charanchi/Batagarawa'),
(198, 21, 'Funtua/Dandume'),
(199, 21, 'Kankia/Ingawa/Kusada'),
(200, 21, 'Safana/Dan musa/Batsari'),
(201, 21, 'Dutsin-ma/Kurfi'),
(202, 21, 'MalumFashi/Kafur'),
(203, 21, 'Kaita/Jibia'),
(204, 21, 'Baure/Zango'),
(205, 22, 'Bagudo/Suru'),
(206, 22, 'Argungu/Augie'),
(207, 22, 'Birnin Kebbi/Kalgo/Bunza'),
(208, 22, 'Yauri/Shanga/Ngaski'),
(209, 22, 'Gwandu/Aliero/Jega'),
(210, 22, 'Maiyama/Koko/Besse'),
(211, 22, 'Arewa/Dandi'),
(212, 22, 'Zuru/Fakai/Sakaba/D/Wasagu'),
(213, 23, 'Dekina/Bassa'),
(214, 23, 'Yagba East/Yagba West/Mopa-muro'),
(215, 23, 'Lokoja/Koton Karfe/Kogi'),
(216, 23, 'Ajaokuta'),
(217, 23, 'Okene/Ogori-Magogo'),
(218, 23, 'Adavi/Okehi'),
(219, 23, 'Ankpa/Omala/Olamaboro'),
(220, 23, 'Idah/Ibaji/Igalamela/Ofu'),
(221, 23, 'Kabba/Bunu/Ijumu'),
(222, 24, 'Edu/Moro/Patigi'),
(223, 24, 'Asa/Ilorin West'),
(224, 24, 'Offa/Oyun/Ifelodun'),
(225, 24, 'Ilorin East/Ilorin South'),
(226, 24, 'Ekiti/Isin/Irepodun/Oke-ero'),
(227, 24, 'Baruten/Kaiama'),
(228, 25, 'Ikeja'),
(229, 25, 'Ikorodu'),
(230, 25, 'Mushin I'),
(231, 25, 'Ifako-Ijaiye'),
(232, 25, 'Lagos Mainland'),
(233, 25, 'Oshodi-Isolo II'),
(234, 25, 'Epe'),
(235, 25, 'Agege'),
(236, 25, 'Surulere I'),
(237, 25, 'Eti-Osa'),
(238, 25, 'Kosofe'),
(239, 25, 'Ojo'),
(240, 25, 'Alimosho'),
(241, 25, 'Ibeju-Lekki'),
(242, 25, 'Badagry'),
(243, 25, 'Lagos Island I'),
(244, 25, 'Ajeromi-Ifelodun'),
(245, 25, 'Somolu'),
(246, 25, 'Surulere II'),
(247, 25, 'Amuwo Odofin'),
(248, 25, 'Apapa'),
(249, 25, 'Oshodi-Isolo I'),
(250, 25, 'Mushin II'),
(251, 26, 'Lafia/Obi'),
(252, 26, 'Karu/Keffi/Kokona'),
(253, 26, 'Nasarawa/Toto'),
(254, 26, 'Akwanga/Nasarawa Eggon/Wamba'),
(255, 26, 'Awe/Doma/Keana'),
(256, 27, 'Magama/Rijau'),
(257, 27, 'Bida/Gbako/Katcha'),
(258, 27, 'Agwara/Borgu'),
(259, 27, 'Lavun/Mokwa/Edati'),
(260, 27, 'Kontagora/Wushishi/Mariga/Mashe/Gukgora'),
(261, 27, 'Shiroro/Rafi/Munya'),
(262, 27, 'Bosso/Paikoro'),
(263, 27, 'Gurara/Suleja/Tafa'),
(264, 27, 'Agaie/Lapai'),
(265, 27, 'Chanchaga'),
(266, 28, 'Abeokuta North/Obafemi-Owode/Odeda'),
(267, 28, 'Egbado South/Ipokia'),
(268, 28, 'Abeokuta South'),
(269, 28, 'Ijebu North/Ijebu East/Ogun Waterside'),
(270, 28, 'Ado-Odo/Ota'),
(271, 28, 'Ikenne/Shagamu/Remo North'),
(272, 28, 'Ijebu Ode/Odogbolu/Ijebu North East'),
(273, 28, 'Ifo/Ewekoro'),
(274, 28, 'Imeko Afon/Egbado North'),
(275, 29, 'Akure North/Akure South'),
(276, 29, 'Owo/Ose'),
(277, 29, 'Ondo East/Ondo West'),
(278, 29, 'Akoko South East/Akoko South West'),
(279, 29, 'Akoko North East/Akoko North West'),
(280, 29, 'Okitipupa/Irele'),
(281, 29, 'Ileoluji-Okeigbo/Odigbo'),
(282, 29, 'Idanre/Ifedore'),
(283, 29, 'Eseodo/Ilaje'),
(285, 30, 'Ede North/Ede South/Egbedore/Ejigbo'),
(286, 30, 'Boluwaduro/Ifedayo/Illa'),
(287, 30, 'Ayedaade/Irewole/Isokan'),
(288, 30, 'Ayedire/Iwo/Ola-Oluwa'),
(289, 30, 'Ife Federal Constituency'),
(290, 30, 'Ife Central/Ife East/Ife North/Ife South'),
(291, 30, 'Odo-Otin/Ifelodun/Boripe'),
(292, 30, 'Atakunmosa East/Atakunmosa West/Ilesha East/Ilesha West'),
(293, 30, 'Irepodun/Olorunda/Osogbo/Orolu'),
(294, 30, 'Obokun/Oriade'),
(295, 31, 'Afijio/Atiba/Oyo East/Oyo West'),
(296, 31, 'Atigbo/Saki East/Saki West'),
(297, 31, 'Ibadan North-East/Ibadan South-East'),
(298, 31, 'Ibadan North'),
(299, 31, 'Ona-Ara/Egbeda'),
(300, 31, 'Iseyin/Kajola/Iwajowa/Itesiwaju'),
(301, 31, 'Lagelu/Akinyele'),
(302, 31, 'Ibarapa East/Ido'),
(303, 31, 'Oluyole'),
(304, 31, 'Ibadan North West/Ibadan South West'),
(305, 31, 'Ibarapa Central/Ibarapa North'),
(306, 31, 'Ogo-Oluwa/Surulere/Oluyole'),
(307, 31, 'Ogbomosho North/Ogbomosho South/Orire'),
(308, 31, 'Irepo/Olorunsogo/Orelope'),
(309, 32, 'Pankshin/Kanke/Kanam'),
(310, 32, 'Bassa/Jos North'),
(311, 32, 'Mikang/Qua\'an Pan/Shendam'),
(312, 32, 'Jos South/Jos East'),
(313, 32, 'Langtang North/Langtang South'),
(314, 32, 'Barkin Ladi/Riyom'),
(315, 32, 'Wase'),
(316, 32, 'Mangu/Bokkos'),
(317, 33, 'Degema/Bonny'),
(318, 33, 'Okrika/Ogu-Bolo'),
(319, 33, 'Ikwerre/Emohua'),
(320, 33, 'Ahoada-West/Ogba-Egbema-Ndoni'),
(321, 33, 'Port Harcourt I'),
(322, 33, 'Akuku-Toru/Asari-Toru'),
(323, 33, 'Khana/Gokana'),
(324, 33, 'Etche/Omuma'),
(325, 33, 'Tai/Eleme/Oyigbo'),
(326, 33, 'Abua/Odual/Ahoada East'),
(327, 33, 'Obio/Akpor'),
(328, 33, 'Port Harcourt II'),
(329, 33, 'Andoni/Opobo/Nkoro'),
(330, 34, 'Sokoto North/Sokoto South'),
(331, 34, 'Binji/Silame'),
(332, 34, 'Wurno/Rabah'),
(333, 34, 'Sabon-Birni/Isa'),
(334, 34, 'Gwadabawa/Ilella'),
(335, 34, 'Kware/Wamakko'),
(336, 34, 'Gudu/Tangaza'),
(337, 34, 'Kebbe/Tambuwal'),
(338, 34, 'Goronyo/Gada'),
(339, 34, 'Bodinga/Dange-Shuni/Tureta'),
(340, 34, 'Shagari/Yabo'),
(341, 35, 'Donga/Ussa/Takum/Special Area'),
(342, 35, 'Gashaka/Kurmi/Sardauna'),
(343, 35, 'Jalingo/Yorro/Zing'),
(344, 35, 'Ibi/Wukari'),
(345, 35, 'Lau/Karim-Lamido/Ardo-Kola'),
(346, 35, 'Bali/Gassol'),
(347, 36, 'Machina/Nguru/Karasuwa/Yusufari'),
(348, 36, 'Fika/Fune'),
(349, 36, 'Bursari/Geidam/Yunusari'),
(350, 36, 'Damaturu/Gujba/Gulani/Tarmuwa'),
(351, 36, 'Nangere/Potiskum'),
(352, 36, 'Bade/Jakusko'),
(353, 37, 'Anka/Talata Marafa'),
(354, 37, 'Bungudu/Maru'),
(355, 37, 'Shinkafi/Zurmi'),
(356, 37, 'Bakura/Maradun'),
(357, 37, 'Kaura-Namoda/Birnin-Magaji'),
(358, 37, 'Gusau/Tsafe'),
(359, 37, 'Gummi/Bukkuyum'),
(512, 18, 'Miga/Jahun'),
(513, 5, 'Alkaleri/Kirfi'),
(514, 14, 'Udenu/Igboeze North'),
(515, 21, 'Katsina Central');

-- --------------------------------------------------------

--
-- Table structure for table `senatorial_district_tbl`
--

CREATE TABLE `senatorial_district_tbl` (
  `district_id` int(11) NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  `district_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `senatorial_district_tbl`
--

INSERT INTO `senatorial_district_tbl` (`district_id`, `state_id`, `district_name`) VALUES
(1, 15, 'Abuja'),
(2, 1, 'Abia Central'),
(3, 1, 'Abia South'),
(4, 1, 'Abia North'),
(5, 2, 'Adamawa North'),
(6, 2, 'Adamawa Central'),
(7, 2, 'Adamawa South'),
(8, 3, 'Akwa Ibom North-East'),
(9, 3, 'Akwa Ibom North-West'),
(10, 3, 'Akwa Ibom South'),
(11, 4, 'Anambra Central'),
(12, 4, 'Anambra South'),
(13, 4, 'Anambra North'),
(14, 5, 'Bauchi South'),
(15, 5, 'Bauchi Central'),
(16, 5, 'Bauchi North'),
(17, 6, 'Bayelsa Central'),
(18, 6, 'Bayelsa East'),
(19, 6, 'Bayelsa West'),
(20, 7, 'Benue South'),
(21, 7, 'Benue North-East'),
(22, 7, 'Benue North-West'),
(23, 8, 'Borno Central'),
(24, 8, 'Borno North'),
(25, 8, 'Borno South'),
(26, 8, 'Cross River North'),
(27, 8, 'Cross River South'),
(28, 8, 'Cross River Central'),
(29, 10, 'Delta Central'),
(30, 10, 'Delta South'),
(31, 10, 'Delta North'),
(32, 11, 'Ebonyi North'),
(33, 11, 'Ebonyi South'),
(34, 11, 'Ebonyi Central'),
(35, 12, 'Edo Central'),
(36, 12, 'Edo South'),
(37, 12, 'Edo North'),
(38, 13, 'Ekiti North'),
(39, 13, 'Ekiti South'),
(40, 13, 'Ekiti Central'),
(41, 14, 'Enugu North'),
(42, 14, 'Enugu East'),
(43, 14, 'Enugu West'),
(44, 16, 'Gombe Central'),
(45, 16, 'Gombe North'),
(46, 16, 'Gombe South'),
(47, 17, 'Imo North'),
(48, 17, 'Imo East'),
(49, 17, 'Imo West'),
(50, 18, 'Jigawa North-East'),
(51, 18, 'Jigawa North-West'),
(52, 18, 'Jigawa South-West'),
(53, 19, 'Kaduna Central'),
(54, 19, 'Kaduna North'),
(55, 19, 'Kaduna South'),
(56, 20, 'Kano South'),
(57, 20, 'Kano North'),
(58, 20, 'Kano Central'),
(59, 21, 'Katsina South'),
(60, 21, 'Katsina Central'),
(61, 21, 'Katsina North'),
(62, 22, 'Kebbi Central'),
(63, 22, 'Kebbi South'),
(64, 22, 'Kebbi North'),
(65, 23, 'Kogi Central'),
(66, 23, 'Kogi East'),
(67, 23, 'Kogi West'),
(68, 24, 'Kwara Central'),
(69, 24, 'Kwara South'),
(70, 24, 'Kwara North'),
(71, 25, 'Lagos Central'),
(72, 25, 'Lagos East'),
(73, 25, 'Lagos West'),
(74, 26, 'Nasarawa West'),
(75, 26, 'Nasarawa North'),
(76, 26, 'Nasarawa South'),
(77, 27, 'Niger East'),
(78, 27, 'Niger North'),
(79, 27, 'Niger South'),
(80, 28, 'Ogun Central'),
(81, 28, 'Ogun East'),
(82, 28, 'Ogun West'),
(83, 29, 'Ondo North'),
(84, 29, 'Ondo Central'),
(85, 29, 'Ondo South'),
(86, 30, 'Osun Central'),
(87, 30, 'Osun East'),
(88, 30, 'Osun West'),
(89, 31, 'Oyo Central'),
(90, 31, 'Oyo North'),
(91, 31, 'Oyo South'),
(92, 32, 'Plateau South'),
(93, 32, 'Plateau Central'),
(94, 32, 'Plateau North'),
(95, 33, 'Rivers East'),
(96, 33, 'Rivers West'),
(97, 33, 'Rivers South-East'),
(98, 34, 'Sokoto North'),
(99, 34, 'Sokoto East'),
(100, 34, 'Sokoto South'),
(101, 35, 'Taraba North'),
(102, 35, 'Taraba Central'),
(103, 35, 'Taraba South'),
(104, 36, 'Yobe North'),
(105, 36, 'Yobe South'),
(106, 36, 'Yobe East'),
(107, 37, 'Zamfara West'),
(108, 37, 'Zamfara Central'),
(109, 37, 'Zamfara North');

-- --------------------------------------------------------

--
-- Table structure for table `state_tbl`
--

CREATE TABLE `state_tbl` (
  `state_id` int(11) NOT NULL,
  `state_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `state_tbl`
--

INSERT INTO `state_tbl` (`state_id`, `state_name`) VALUES
(1, 'Abia'),
(2, 'Adamawa'),
(3, 'Akwa Ibom'),
(4, 'Anambra'),
(5, 'Bauchi'),
(6, 'Bayelsa'),
(7, 'Benue'),
(8, 'Borno'),
(9, 'Cross River'),
(10, 'Delta'),
(11, 'Ebonyi'),
(12, 'Edo'),
(13, 'Ekiti'),
(14, 'Enugu'),
(15, 'Federal Capital Territory'),
(16, 'Gombe'),
(17, 'Imo'),
(18, 'Jigawa'),
(19, 'Kaduna'),
(20, 'Kano'),
(21, 'Katsina'),
(22, 'Kebbi'),
(23, 'Kogi'),
(24, 'Kwara'),
(25, 'Lagos'),
(26, 'Nasarawa'),
(27, 'Niger'),
(28, 'Ogun'),
(29, 'Ondo'),
(30, 'Osun'),
(31, 'Oyo'),
(32, 'Plateau'),
(33, 'Rivers'),
(34, 'Sokoto'),
(35, 'Taraba'),
(36, 'Yobe'),
(37, 'Zamfara');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `lga_tbl`
--
ALTER TABLE `lga_tbl`
  ADD PRIMARY KEY (`lga_id`),
  ADD KEY `IDX_B38063DE5D83CC1` (`state_id`),
  ADD KEY `IDX_B38063DE15BE918D` (`senatorial_district_id`),
  ADD KEY `IDX_B38063DE7E9E6A9E` (`representative_district_id`);

--
-- Indexes for table `representative_district_tbl`
--
ALTER TABLE `representative_district_tbl`
  ADD PRIMARY KEY (`district_id`),
  ADD KEY `IDX_C36B75725D83CC1` (`state_id`);

--
-- Indexes for table `senatorial_district_tbl`
--
ALTER TABLE `senatorial_district_tbl`
  ADD PRIMARY KEY (`district_id`),
  ADD KEY `IDX_47BE14575D83CC1` (`state_id`);

--
-- Indexes for table `state_tbl`
--
ALTER TABLE `state_tbl`
  ADD PRIMARY KEY (`state_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `lga_tbl`
--
ALTER TABLE `lga_tbl`
  MODIFY `lga_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=775;

--
-- AUTO_INCREMENT for table `representative_district_tbl`
--
ALTER TABLE `representative_district_tbl`
  MODIFY `district_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=516;

--
-- AUTO_INCREMENT for table `senatorial_district_tbl`
--
ALTER TABLE `senatorial_district_tbl`
  MODIFY `district_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `state_tbl`
--
ALTER TABLE `state_tbl`
  MODIFY `state_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;