-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `talento-dbflush`
--

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

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` varchar(191) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blocks`
--

CREATE TABLE `blocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `district_id` bigint(20) NOT NULL DEFAULT 0,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blocks`
--

INSERT INTO `blocks` (`id`, `name`, `district_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Kattapana', 2, 1, NULL, NULL),
(2, 'Athiyanoor ', 1, 1, NULL, NULL),
(3, 'Chirayinkeezhu ', 1, 1, NULL, NULL),
(4, 'Mallappally', 2, 1, NULL, NULL),
(5, 'Pulikeezhu', 2, 1, NULL, NULL),
(6, 'Pothencode', 1, 1, NULL, NULL),
(7, 'Koipuram', 2, 1, NULL, NULL),
(8, 'Kilimanoor', 1, 1, NULL, NULL),
(9, 'Koipuram', 2, 1, NULL, NULL),
(10, 'Elanthoor', 2, 1, NULL, NULL),
(11, 'Ranni', 2, 1, NULL, NULL),
(12, 'Alangad', 7, 1, NULL, NULL),
(13, 'Konni', 2, 1, NULL, NULL),
(14, ' Erattupetta ', 5, 1, NULL, NULL),
(15, 'Nedumangad ', 1, 1, NULL, NULL),
(16, 'Angamaly', 7, 1, NULL, NULL),
(17, 'Nemom ', 1, 1, NULL, NULL),
(18, 'Ettumannoor ', 5, 1, NULL, NULL),
(19, 'Pandalam', 2, 1, NULL, NULL),
(20, 'Nemom ', 1, 1, NULL, NULL),
(21, 'Kaduthuruthy ', 5, 1, NULL, NULL),
(22, 'Parassala', 1, 1, NULL, NULL),
(23, ' Kanjirappally', 5, 1, NULL, NULL),
(24, 'Parakode', 2, 1, NULL, NULL),
(25, 'Edapally', 7, 1, NULL, NULL),
(26, ' Lalam', 5, 1, NULL, NULL),
(27, 'Perumkadavila ', 1, 1, NULL, NULL),
(28, 'Koovappady', 7, 1, NULL, NULL),
(29, 'Kothamangalam', 7, 1, NULL, NULL),
(30, 'Vamanapuram ', 1, 1, NULL, NULL),
(31, 'Mulanthuruthy', 7, 1, NULL, NULL),
(32, 'Madappally', 5, 1, NULL, NULL),
(33, 'Moovattupuzha', 7, 1, NULL, NULL),
(34, 'Pallom', 5, 1, NULL, NULL),
(35, 'Palluruthy', 7, 1, NULL, NULL),
(36, 'Aryad', 8, 1, NULL, NULL),
(37, 'Vellanad ', 1, 1, NULL, NULL),
(38, 'Pampakuda', 7, 1, NULL, NULL),
(39, 'Varkala', 1, 1, NULL, NULL),
(40, 'Uzhavoor ', 5, 1, NULL, NULL),
(41, 'North Paravur', 7, 1, NULL, NULL),
(42, 'Bharanicavu', 3, 1, NULL, NULL),
(43, 'Vazhoor ', 5, 1, NULL, NULL),
(44, 'Parakadavu', 7, 1, NULL, NULL),
(45, 'Vaikom', 5, 1, NULL, NULL),
(46, 'Anchal ', 127, 1, NULL, NULL),
(47, 'VYPEN', 7, 1, NULL, NULL),
(48, 'Champakulam', 129, 1, NULL, NULL),
(49, 'Champakulam', 3, 1, NULL, NULL),
(50, 'Vazhakulam', 7, 1, NULL, NULL),
(51, 'Chadayamangalam', 2, 1, NULL, NULL),
(52, 'Vadavucode', 7, 1, NULL, NULL),
(53, 'Chavara ', 2, 1, NULL, NULL),
(54, 'Haripad', 3, 1, NULL, NULL),
(55, 'Anthikkad', 8, 1, NULL, NULL),
(56, 'Chittumala ', 2, 1, NULL, NULL),
(57, 'Ithikkara ', 2, 1, NULL, NULL),
(58, 'Kanjikuzhy', 3, 1, NULL, NULL),
(59, 'Adimaly ', 6, 1, NULL, NULL),
(60, 'Chavakkad', 8, 1, NULL, NULL),
(61, 'Kottarakkara ', 2, 1, NULL, NULL),
(62, 'Mavelikara', 3, 1, NULL, NULL),
(63, 'Chalakudy', 8, 1, NULL, NULL),
(64, 'Mughathala ', 2, 1, NULL, NULL),
(65, 'Muthukulam', 3, 1, NULL, NULL),
(66, 'Cherpu', 8, 1, NULL, NULL),
(67, 'Oachira ', 2, 1, NULL, NULL),
(68, 'Pattanakkad', 3, 1, NULL, NULL),
(69, 'Azhutha', 6, 1, NULL, NULL),
(70, 'Chowannur', 8, 1, NULL, NULL),
(71, 'Pathanapuram ', 127, 1, NULL, NULL),
(72, 'Devikulam ', 6, 1, NULL, NULL),
(73, 'Thycattussery', 3, 1, NULL, NULL),
(74, 'Irinjalakuda', 8, 1, NULL, NULL),
(75, 'Sasthamkotta ', 2, 1, NULL, NULL),
(76, 'Kodakara', 8, 1, NULL, NULL),
(77, 'Veliyanad', 3, 1, NULL, NULL),
(78, 'Mala', 8, 1, NULL, NULL),
(79, 'Vettikavala ', 2, 1, NULL, NULL),
(80, 'Mathilakam', 8, 1, NULL, NULL),
(81, 'Mullassery', 8, 1, NULL, NULL),
(82, 'Vellanad', 1, 1, NULL, NULL),
(83, 'Idukki ', 6, 1, NULL, NULL),
(84, 'Pazhayannur', 8, 1, NULL, NULL),
(85, 'Nedumkandam ', 6, 1, NULL, NULL),
(86, 'Vellangallur', 8, 1, NULL, NULL),
(87, 'Wadakkanchery', 8, 1, NULL, NULL),
(88, 'Puzhakkal', 8, 1, NULL, NULL),
(89, 'Areakode ', 10, 1, NULL, NULL),
(90, 'Elamdesam ', 6, 1, NULL, NULL),
(91, 'Kondotty', 10, 1, NULL, NULL),
(92, 'Kattappana', 6, 1, NULL, NULL),
(93, ' Kuttippuram ', 10, 1, NULL, NULL),
(94, ' Kalpetta ', 12, 1, NULL, NULL),
(95, 'Sulthan Bathery ', 12, 1, NULL, NULL),
(96, 'Mananthavady ', 12, 1, NULL, NULL),
(97, 'Panamaram ', 12, 1, NULL, NULL),
(98, 'Manjeswaram ', 14, 1, NULL, NULL),
(99, 'Kasaragod', 14, 1, NULL, NULL),
(100, 'Kanhangad ', 14, 1, NULL, NULL),
(101, 'Edakkad', 13, 1, NULL, NULL),
(102, 'Nileshwaram', 14, 1, NULL, NULL),
(103, 'Kannur', 13, 1, NULL, NULL),
(104, 'Taliparamba', 13, 1, NULL, NULL),
(105, 'Karaduka ', 14, 1, NULL, NULL),
(106, 'Payyannur', 13, 1, NULL, NULL),
(107, 'Payyannur', 13, 1, NULL, NULL),
(108, 'Thalassery', 13, 1, NULL, NULL),
(109, 'Parappa ', 14, 1, NULL, NULL),
(110, 'Kuthuparamba', 13, 1, NULL, NULL),
(111, 'Iritty', 13, 1, NULL, NULL),
(112, 'Balussery', 11, 1, NULL, NULL),
(113, 'Chelannur ', 11, 1, NULL, NULL),
(114, 'Irikkur', 13, 1, NULL, NULL),
(115, 'Koduvally ', 11, 1, NULL, NULL),
(116, 'Kozhikode ', 11, 1, NULL, NULL),
(117, 'Peravoor', 13, 1, NULL, NULL),
(118, 'Kunnamangalam ', 11, 1, NULL, NULL),
(119, 'Kunnummal ', 11, 1, NULL, NULL),
(120, 'Meladi ', 11, 1, NULL, NULL),
(121, 'Panthalayani ', 11, 1, NULL, NULL),
(122, 'Perambra ', 11, 1, NULL, NULL),
(123, 'Iritty', 13, 1, NULL, NULL),
(124, 'Thodannur ', 11, 1, NULL, NULL),
(125, 'Panoor', 13, 1, NULL, NULL),
(126, 'Tuneri ', 11, 1, NULL, NULL),
(127, 'Mankada', 10, 1, NULL, NULL),
(128, 'Vadakara', 11, 1, NULL, NULL),
(129, 'Kalliassery', 13, 1, NULL, NULL),
(130, 'Nilambur', 10, 1, NULL, NULL),
(131, 'Perinthalmanna', 10, 1, NULL, NULL),
(132, 'Perumpadappu', 10, 1, NULL, NULL),
(133, 'Ponnani', 10, 1, NULL, NULL),
(134, 'Thanur', 10, 1, NULL, NULL),
(135, 'Tirur', 10, 1, NULL, NULL),
(136, 'Thirurangadi', 10, 1, NULL, NULL),
(137, 'Vengara', 10, 1, NULL, NULL),
(138, 'Wandoor', 10, 1, NULL, NULL),
(139, 'Kalikavu', 10, 1, NULL, NULL),
(140, 'Alathoor', 9, 1, NULL, NULL),
(141, 'Attappady', 9, 1, NULL, NULL),
(142, 'Kollengode', 9, 1, NULL, NULL),
(143, 'Malappuram', 10, 1, NULL, NULL),
(144, 'Malappuram', 10, 1, NULL, NULL),
(145, 'Malappuram', 10, 1, NULL, NULL),
(146, 'Vengara', 10, 1, NULL, NULL),
(147, 'Wandoor ', 10, 1, NULL, NULL),
(148, ' Chittur', 9, 1, NULL, NULL),
(149, 'Kuzhalmannam', 9, 1, NULL, NULL),
(150, ' Kuzhalmannam', 9, 1, NULL, NULL),
(151, 'Malampuzha', 9, 1, NULL, NULL),
(152, 'Mannarkkad', 9, 1, NULL, NULL),
(153, 'Nenmara ', 9, 1, NULL, NULL),
(154, 'Nenmara', 9, 1, NULL, NULL),
(155, 'Ottappalam', 9, 1, NULL, NULL),
(156, 'Palakkad', 9, 1, NULL, NULL),
(157, 'Pattambi', 9, 1, NULL, NULL),
(158, ' Sreekrishnapuram', 9, 1, NULL, NULL),
(159, 'Thrithala ', 9, 1, NULL, NULL),
(160, 'xx', 186, 1, NULL, NULL),
(1000, 'No Block', 0, 0, NULL, NULL);

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

--
-- Table structure for table `canadidate_interest_course_masters`
--

CREATE TABLE `canadidate_interest_course_masters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `course_master_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_interest_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'India', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Afghanistan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'Albania', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'Algeria', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'American Samoa', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'Andorra', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'Angola', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'Anguilla', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'Antigua and Barbuda', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 'Argentina', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'Armenia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 'Australia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 'Austria', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 'Azerbaijan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 'Bahamas', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 'Bahrain', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 'Bangladesh', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'Barbados', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'Belarus', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 'Belgium', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 'Belize', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 'Bermuda', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 'Bhutan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 'Bolivia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 'Bosnia and Herzegovina', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 'Botswana', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 'Brazil', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 'Brunei Darussalam', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 'Bulgaria', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 'Burkina Faso', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 'Burundi', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 'Cambodia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 'Cameroon', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 'Canada', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 'Cape Verde', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 'Cayman Islands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 'Central African Republic', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 'Chad', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 'Chile', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 'China', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 'Colombia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, 'Comoros', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 'Congo (DRC)', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 'Congo', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, 'Cook Islands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 'Costa Rica', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 'Cote D\'Ivoire', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 'Croatia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, 'Cuba', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, 'Cyprus', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, 'Czech Republic', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(52, 'Denmark', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(53, 'Djibouti', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(54, 'Dominica', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(55, 'Dominican Republic', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, 'East Timor', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(57, 'Ecuador', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(58, 'Egypt', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(59, 'El Salvador', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(60, 'Equatorial Guinea', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(61, 'Eritrea', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(62, 'Estonia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(63, 'Ethiopia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(64, 'Falkland Islands (Malvinas)', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(65, 'Faroe Islands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(66, 'Fiji', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(67, 'Finland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(68, 'France', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(69, 'Gabon', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(70, 'Gambia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(71, 'Georgia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(72, 'Germany', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(73, 'Ghana', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(74, 'Gibraltar', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(75, 'Greece', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(76, 'Greenland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(77, 'Grenada', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(78, 'Guadeloupe', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(79, 'Guam', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(80, 'Guatemala', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(81, 'Guinea', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(82, 'Guinea-Bissau', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(83, 'Guyana', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(84, 'Haiti', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(85, 'Holy See (Vatican City State)', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(86, 'Honduras', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(87, 'Hong Kong', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(88, 'Hungary', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(89, 'Iceland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(90, 'Indonesia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(91, 'Iran', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(92, 'Iraq', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(93, 'Ireland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(94, 'Israel', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(95, 'Italy', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(96, 'Jamaica', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(97, 'Japan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(98, 'Jordan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(99, 'Kazakhstan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(100, 'Kenya', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(101, 'Kiribati', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(102, 'North Korea', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(103, 'South Korea', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(104, 'Kuwait', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(105, 'Kyrgyzstan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(106, 'Laos', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(107, 'Latvia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(108, 'Lebanon', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(109, 'Lesotho', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(110, 'Liberia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(111, 'Libyan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(112, 'Liechtenstein', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(113, 'Lithuania', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(114, 'Luxembourg', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(115, 'Macao', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(116, 'Macedonia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(117, 'Madagascar', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(118, 'Malawi', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(119, 'Malaysia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(120, 'Maldives', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(121, 'Mali', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(122, 'Malta', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(123, 'Martinique', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(124, 'Mauritania', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(125, 'Mauritius', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(126, 'Mayotte', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(127, 'Mexico', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(128, 'Micronesia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(129, 'Moldova', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(130, 'Monaco', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(131, 'Mongolia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(132, 'Montserrat', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(133, 'Morocco', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(134, 'Mozambique', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(135, 'Myanmar', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(136, 'Namibia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(137, 'Nauru', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(138, 'Nepal', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(139, 'Netherlands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(140, 'Netherlands Antilles', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(141, 'New Caledonia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(142, 'New Zealand', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(143, 'Nicaragua', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(144, 'Niger', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(145, 'Nigeria', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(146, 'Niue', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(147, 'Norfolk Island', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(148, 'Norway', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(149, 'Oman', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(150, 'Pakistan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(151, 'Panama', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(152, 'Papua New Guinea', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(153, 'Paraguay', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(154, 'Peru', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(155, 'Philippines', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(156, 'Pitcairn Islands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(157, 'Poland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(158, 'Portugal', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(159, 'Puerto Rico', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(160, 'Qatar', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(161, 'Reunion', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(162, 'Romania', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(163, 'Russia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(164, 'Rwanda', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(165, 'Samoa', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(166, 'San Marino', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(167, 'Sao Tome and Principe', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(168, 'Saudi Arabia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(169, 'Senegal', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(170, 'Serbia and Montenegro', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(171, 'Seychelles', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(172, 'Sierra Leone', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(173, 'Singapore', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(174, 'Slovakia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(175, 'Slovenia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(176, 'Solomon Islands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(177, 'Somalia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(178, 'South Africa', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(179, 'Spain', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(180, 'Sri Lanka', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(181, 'St. Helena', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(182, 'St. Kitts & Nevis', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(183, 'St. Lucia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(184, 'St. Pierre and Miquelon', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(185, 'St. Vincent & Grenadines', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(186, 'Sudan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(187, 'Suriname', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(188, 'Swaziland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(189, 'Sweden', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(190, 'Switzerland', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(191, 'Syria', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(192, 'Taiwan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(193, 'Tajikistan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(194, 'Tanzania', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(195, 'Thailand', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(196, 'Togo', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(197, 'Tokelau', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(198, 'Tonga', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(199, 'Trinidad and Tobago', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(200, 'Tunisia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(201, 'Turkey', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(202, 'Turkmenistan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(203, 'Turks and Caicos Islands', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(204, 'Tuvalu', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(205, 'Uganda', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(206, 'Ukraine', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(207, 'United Arab Emirates', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(208, 'United Kingdom', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(209, 'United States', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(210, 'Uruguay', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(211, 'Uzbekistan', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(212, 'Vanuatu', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(213, 'Venezuela', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(214, 'Vietnam', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(215, 'Virgin Islands, British', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(216, 'Virgin Islands, U.s.', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(217, 'Wallis and Futuna', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(218, 'Yemen', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(219, 'Zambia', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(220, 'Zimbabwe', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(1000, 'No Country', NULL, 1, NULL, NULL);

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `training_name` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `sector_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pia_id` bigint(20) UNSIGNED DEFAULT NULL,
  `district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `block_id` bigint(20) UNSIGNED DEFAULT NULL,
  `localbody_id` bigint(20) UNSIGNED DEFAULT NULL,
  `localbodytype_id` bigint(20) UNSIGNED DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `venue` varchar(191) DEFAULT NULL,
  `duration` varchar(191) DEFAULT NULL,
  `general_seats` int(11) DEFAULT 0,
  `scst_seats` int(11) DEFAULT 0,
  `minority_seats` int(11) DEFAULT 0,
  `no_of_seats` int(11) DEFAULT 0,
  `Remarks` varchar(191) DEFAULT NULL,
  `future_possibilities` varchar(191) DEFAULT NULL,
  `course_status` int(11) DEFAULT 0,
  `coursemaster_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `general_seats_filled` int(11) NOT NULL DEFAULT 0,
  `scst_seats_filled` int(11) NOT NULL DEFAULT 0,
  `minority_seats_filled` int(11) NOT NULL DEFAULT 0,
  `no_of_seats_filled` int(11) NOT NULL DEFAULT 0,
  `training_location` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `course_masters`
--

CREATE TABLE `course_masters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sector_id` bigint(20) UNSIGNED NOT NULL,
  `tradename` varchar(191) NOT NULL,
  `tradecode` varchar(191) DEFAULT NULL,
  `duration` varchar(191) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `qualification` varchar(191) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `course_skill_mappings`
--

CREATE TABLE `course_skill_mappings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `course_id` bigint(20) UNSIGNED NOT NULL,
  `skill_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `name`, `state_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'THIRUVANANTHAPURAM', 32, 1, NULL, NULL),
(2, 'KOLLAM', 32, 1, NULL, NULL),
(3, 'PATHANAMTHITTA', 32, 1, NULL, NULL),
(4, 'ALAPPUZHA', 32, 1, NULL, NULL),
(5, 'KOTTAYAM', 32, 1, NULL, NULL),
(6, 'IDUKKI', 32, 1, NULL, NULL),
(7, 'ERNAKULAM', 32, 1, NULL, NULL),
(8, 'THRISSUR', 32, 1, NULL, NULL),
(9, 'PALAKKAD', 32, 1, NULL, NULL),
(10, 'MALAPPURAM', 32, 1, NULL, NULL),
(11, 'KOZHIKODE', 32, 1, NULL, NULL),
(12, 'WAYANAD', 32, 1, NULL, NULL),
(13, 'KANNUR', 32, 1, NULL, NULL),
(14, 'KASARGOD', 32, 1, NULL, NULL),
(1000, 'No District', 1000, 1, NULL, NULL);

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

--
-- Table structure for table `employer_details_updation_requests`
--

CREATE TABLE `employer_details_updation_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED NOT NULL,
  `building_name` varchar(191) NOT NULL,
  `landmark` varchar(191) NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `district_id` bigint(20) UNSIGNED NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `postOffice` varchar(191) NOT NULL,
  `pincode` varchar(6) NOT NULL,
  `approval_status` int(11) NOT NULL DEFAULT 0,
  `processed_by` bigint(20) UNSIGNED DEFAULT NULL,
  `processed_at` datetime DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `prefered_location` varchar(191) DEFAULT NULL,
  `cover_area` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `employer_job_mappings`
--

CREATE TABLE `employer_job_mappings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobfairs`
--

CREATE TABLE `jobfairs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `venue` varchar(191) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL,
  `file_path` varchar(191) DEFAULT NULL,
  `fair_date` date NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_applications`
--

CREATE TABLE `job_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_id` bigint(20) UNSIGNED NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `application_status` varchar(50) DEFAULT NULL,
  `applied_at` datetime DEFAULT NULL,
  `shortlisted_at` datetime DEFAULT NULL,
  `rejected_at` datetime DEFAULT NULL,
  `placed_at` datetime DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_vacancies`
--

CREATE TABLE `job_vacancies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `location` varchar(191) DEFAULT NULL,
  `qualification` varchar(191) DEFAULT NULL,
  `salary` varchar(191) DEFAULT NULL,
  `description` varchar(191) NOT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_vacancy_skill_mappings`
--

CREATE TABLE `job_vacancy_skill_mappings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `skill_id` bigint(20) UNSIGNED NOT NULL,
  `job_vacancy_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `localbodies`
--

CREATE TABLE `localbodies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_eng` varchar(191) NOT NULL,
  `lb_type_id` bigint(20) UNSIGNED NOT NULL,
  `district_id` bigint(20) UNSIGNED NOT NULL,
  `block_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `localbodies`
--

INSERT INTO `localbodies` (`id`, `name_eng`, `lb_type_id`, `district_id`, `block_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, ' Perumannaclary', 1, 10, 96, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(2, 'Aanakkara', 1, 9, 113, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(3, 'Abdurahiman Nagar', 1, 10, 99, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(4, 'Adat', 1, 8, 145, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(5, 'Adichanalloor', 1, 2, 56, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(6, 'Adimali', 1, 6, 27, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(7, 'Adoor', 2, 3, 0, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(8, 'Agali', 1, 9, 102, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(9, 'Aikaranadu', 1, 7, 24, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:01'),
(10, 'Ajanur', 1, 14, 46, 1, '2020-06-14 03:07:01', '2020-06-14 03:07:02'),
(11, 'Akalakunnam', 1, 5, 70, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(12, 'Akathethara', 1, 9, 106, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(13, 'Alackode', 1, 6, 30, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(14, 'Alagappanagar', 1, 8, 139, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(15, 'Alakode', 1, 13, 44, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(16, 'Alamcode', 1, 10, 94, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(17, 'Alanalur', 1, 9, 107, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(18, 'Alangad', 1, 7, 13, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(19, 'Alappadu', 1, 2, 59, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(20, 'Alappuzha', 2, 4, 0, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(21, 'Alapuzha Ala', 1, 4, 5, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(22, 'Alapuzha Thuravoor', 1, 4, 10, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(23, 'Alathoor', 1, 9, 101, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(24, 'Alayamon', 1, 2, 52, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(25, 'Aliparanmba', 1, 10, 93, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(26, 'Aloor', 1, 8, 140, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(27, 'Aluva', 2, 7, 0, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(28, 'Amarambalam', 1, 10, 87, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(29, 'Ambalappara', 1, 9, 109, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(30, 'Ambalapuzha Thekku', 1, 4, 1, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(31, 'Ambalapuzha Vadakku', 1, 4, 1, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(32, 'Ambalavayal', 1, 12, 152, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(33, 'Amballoor', 1, 7, 18, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(34, 'Amboori', 1, 1, 128, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(35, 'Anad', 1, 1, 125, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(36, 'Anakkayam', 1, 10, 90, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(37, 'Ananganadi', 1, 9, 109, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(38, 'Anchal', 1, 2, 52, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(39, 'Anchuthengu', 1, 1, 123, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(40, 'Andoorkonam', 1, 1, 129, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(41, 'Angadippuram', 1, 10, 93, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(42, 'Angamaly', 2, 7, 0, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(43, 'Anicadu', 1, 3, 117, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(44, 'Anjarakandi', 1, 13, 45, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(45, 'Annamanada', 1, 8, 140, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(46, 'Anthikkad', 1, 8, 133, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(47, 'Anthoor', 2, 13, 0, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:02'),
(48, 'Arakulam', 1, 6, 31, 1, '2020-06-14 03:07:02', '2020-06-14 03:07:03'),
(49, 'Arakuzha', 1, 7, 19, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(50, 'Aralam', 1, 13, 37, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(51, 'Aranmula', 1, 3, 118, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(52, 'Arattupuzha', 1, 4, 9, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(53, 'Areacode', 1, 10, 86, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(54, 'Ariencavu', 1, 2, 52, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(55, 'Arikkulam', 1, 11, 81, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(56, 'Arimboor', 1, 8, 133, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(57, 'Arookutty', 1, 4, 11, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(58, 'Aroor', 1, 4, 10, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(59, 'Arpookara', 1, 5, 64, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(60, 'Aruvappulam', 1, 3, 115, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(61, 'Aruvikkara', 1, 1, 125, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(62, 'Aryad', 1, 4, 2, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(63, 'Aryanad', 1, 1, 132, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(64, 'Aryankode', 1, 1, 128, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(65, 'Assamanoor', 1, 7, 16, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(66, 'Athavanad', 1, 10, 89, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(67, 'Athirampuzha', 1, 5, 64, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(68, 'Athirappilly', 1, 8, 134, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(69, 'Athiyannur', 1, 1, 122, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(70, 'Atholy', 1, 11, 81, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(71, 'Attingal', 2, 1, 0, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(72, 'Avanoor', 1, 8, 145, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(73, 'Avinissery', 1, 8, 136, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(74, 'Avoli', 1, 7, 19, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(75, 'Ayanchery', 1, 11, 83, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(76, 'Ayarkunnam', 1, 5, 69, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(77, 'Ayavana', 1, 7, 19, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(78, 'Ayilur', 1, 9, 108, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(79, 'Ayiroor', 1, 3, 116, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(80, 'Aymanam', 1, 5, 64, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(81, 'Ayyampuzha', 1, 7, 14, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(82, 'Ayyankunnu', 1, 13, 37, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(83, 'Ayyappancovil', 1, 6, 32, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(84, 'Azhikode', 1, 13, 39, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(85, 'Azhiyur', 1, 11, 85, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(86, 'Azhoor', 1, 1, 129, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:03'),
(87, 'Badiadka', 1, 14, 48, 1, '2020-06-14 03:07:03', '2020-06-14 03:07:04'),
(88, 'Balal', 1, 14, 51, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(89, 'Balaramapuram', 1, 1, 126, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(90, 'Balusseri', 1, 11, 74, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(91, 'Bedadka', 1, 14, 47, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(92, 'Bellur', 1, 14, 47, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(93, 'Bharananganam', 1, 5, 67, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(94, 'Bharanikavu', 1, 4, 3, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(95, 'Bhudanoor', 1, 4, 5, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(96, 'Bysonvalley', 1, 6, 27, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(97, 'Chadayamangalam', 1, 2, 53, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(98, 'Chakkittapara', 1, 11, 82, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(99, 'Chakkupallam', 1, 6, 32, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(100, 'Chalakudy', 2, 8, 0, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(101, 'Chalavara', 1, 9, 109, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(102, 'Chalissery', 1, 9, 113, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(103, 'Chaliyar', 1, 10, 92, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(104, 'Champakulam', 1, 4, 4, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(105, 'Changanassery', 2, 5, 0, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(106, 'Changaroth', 1, 11, 82, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(107, 'Chapparapadavu', 1, 13, 44, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(108, 'Chathamangalam', 1, 11, 78, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(109, 'Chathanoor', 1, 2, 56, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(110, 'Chavakkad', 2, 8, 0, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(111, 'Chavara', 1, 2, 54, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(112, 'Chazhoor', 1, 8, 133, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(113, 'Cheekkkode', 1, 10, 86, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(114, 'Chekkiad', 1, 11, 84, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(115, 'Chelakkara', 1, 8, 144, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(116, 'Chelannur', 1, 11, 75, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(117, 'Chelembra', 1, 10, 88, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(118, 'Chellanam', 1, 7, 20, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(119, 'Chemanchery', 1, 11, 81, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(120, 'Chembilode', 1, 13, 35, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(121, 'Chembu', 1, 5, 72, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(122, 'Chemmaruthi', 1, 1, 131, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(123, 'Chemnad', 1, 14, 48, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(124, 'Chendamangalam', 1, 7, 23, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(125, 'Chengala', 1, 14, 48, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(126, 'Chengalayi', 1, 13, 44, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:04'),
(127, 'Chengamanad', 1, 7, 22, 1, '2020-06-14 03:07:04', '2020-06-14 03:07:05'),
(128, 'Chengannur', 2, 4, 0, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(129, 'Chengottukavu', 1, 11, 81, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(130, 'Chenkal', 1, 1, 127, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(131, 'Chennampallipuram', 1, 4, 11, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(132, 'Chenneerkara', 1, 3, 114, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(133, 'Chennithala Thruperunthara', 1, 4, 8, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(134, 'Cheppad', 1, 4, 9, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(135, 'Cheranalloor', 1, 7, 15, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(136, 'Cheriyamundam', 1, 10, 96, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(137, 'Cheriyanad', 1, 4, 5, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(138, 'Cherplassery', 2, 9, 0, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(139, 'Cherpu', 1, 8, 136, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(140, 'Cherthala', 2, 4, 0, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(141, 'Cherthala Thekku', 1, 4, 7, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(142, 'Cherukavu', 1, 10, 88, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(143, 'Cherukole', 1, 3, 114, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(144, 'Cherukunnu', 1, 13, 38, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(145, 'Cherunniyoor', 1, 1, 131, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(146, 'Cherupuzha', 1, 13, 42, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(147, 'Cheruthana', 1, 4, 6, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(148, 'Cheruthazham', 1, 13, 38, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(149, 'Cheruvannur', 1, 11, 82, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(150, 'Cheruvathur', 1, 14, 49, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(151, 'Chettikulangara', 1, 4, 8, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(152, 'Chingoli', 1, 4, 6, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(153, 'Chinnakanal', 1, 6, 29, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(154, 'Chirakkadavu', 1, 5, 73, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(155, 'Chirakkal', 1, 13, 39, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(156, 'Chirakkara', 1, 2, 56, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(157, 'Chirayinkeezhu', 1, 1, 123, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(158, 'Chithara', 1, 2, 53, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(159, 'Chittar', 1, 3, 121, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(160, 'Chittariparamba', 1, 13, 40, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(161, 'Chittattukara', 1, 7, 23, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(162, 'Chittur-Thathamangalam', 2, 9, 0, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(163, 'Chokkade', 1, 10, 87, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(164, 'Chokli', 1, 13, 41, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(165, 'Choondal', 1, 8, 137, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:05'),
(166, 'Choornikkara', 1, 7, 25, 1, '2020-06-14 03:07:05', '2020-06-14 03:07:06'),
(167, 'Chorode', 1, 11, 85, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(168, 'Chottanikara', 1, 7, 18, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(169, 'Chovannur', 1, 8, 137, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(170, 'Chunakkara', 1, 4, 3, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(171, 'Chungathara', 1, 10, 92, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(172, 'Clappana', 1, 2, 59, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(173, 'Delampady', 1, 14, 47, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(174, 'Desamangalam', 1, 8, 148, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(175, 'Devikulam', 1, 6, 29, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(176, 'Devikulangara', 1, 4, 9, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(177, 'Dharmadam', 1, 13, 45, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(178, 'East Eleri', 1, 14, 51, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(179, 'East Kallada', 1, 2, 55, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(180, 'Edachery', 1, 11, 84, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(181, 'Edakkara', 1, 10, 92, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(182, 'Edakkattuvayal', 1, 7, 18, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(183, 'Edamulakkal', 1, 2, 52, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(184, 'Edapatta', 1, 10, 87, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(185, 'Edappal', 1, 10, 95, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(186, 'Edarikkodu', 1, 10, 99, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(187, 'Edathala', 1, 7, 25, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(188, 'Edathiruthy', 1, 8, 141, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(189, 'Edathua', 1, 4, 4, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(190, 'Edava', 1, 1, 131, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(191, 'Edavaka', 1, 12, 150, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(192, 'Edavanakkad', 1, 7, 26, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(193, 'Edavanna', 1, 10, 86, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(194, 'Edavetty', 1, 6, 34, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(195, 'Edavilangu', 1, 8, 141, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(196, 'Edayoor', 1, 10, 89, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(197, 'Elakamon', 1, 1, 131, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(198, 'Elamadu', 1, 2, 53, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(199, 'Elamkulam', 1, 10, 93, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(200, 'Elampaloor', 1, 2, 58, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(201, 'Elanji', 1, 7, 21, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(202, 'Elankunnapuzha', 1, 7, 15, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(203, 'Elanthoor', 1, 3, 114, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(204, 'Elappara', 1, 6, 28, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:06'),
(205, 'Elappulli', 1, 9, 103, 1, '2020-06-14 03:07:06', '2020-06-14 03:07:07'),
(206, 'Elavally', 1, 8, 142, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(207, 'Elavancheri', 1, 9, 108, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(208, 'Elikulam', 1, 5, 70, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(209, 'Eloor', 2, 7, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(210, 'Enadimangalam', 1, 3, 119, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(211, 'Engandiyoor', 1, 8, 146, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(212, 'Enmakaje', 1, 14, 50, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(213, 'Eramala', 1, 11, 85, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(214, 'Eramam Kuttoor', 1, 13, 42, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(215, 'Erathu', 1, 3, 119, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(216, 'Erattayar', 1, 6, 32, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(217, 'Erattupetta', 2, 5, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(218, 'Eraviperoor', 1, 3, 116, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(219, 'Erimayoor', 1, 9, 101, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(220, 'Erinholi', 1, 13, 45, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(221, 'Eriyad', 1, 8, 141, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(222, 'Ernakulam Kalady', 1, 7, 14, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(223, 'Erumapetty', 1, 8, 148, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(224, 'Erumeli', 1, 5, 66, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(225, 'Eruthempathi', 1, 9, 103, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(226, 'Eruvessi', 1, 13, 36, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(227, 'Ettumanoor', 2, 5, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(228, 'Ezhamkulam', 1, 3, 119, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(229, 'Ezhikkara', 1, 7, 23, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(230, 'Ezhome', 1, 13, 38, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(231, 'Ezhukone', 1, 2, 57, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(232, 'Ezhumattur', 1, 3, 116, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(233, 'Ezhupunna', 1, 4, 10, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(234, 'Feroke', 2, 11, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(235, 'Guruvayoor', 2, 8, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(236, 'Haripad', 2, 4, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(237, 'Idukki Kanjikuzhy', 1, 6, 31, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(238, 'Irikkur', 1, 13, 36, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(239, 'Irimbiliyam', 1, 10, 89, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(240, 'Irinjalakuda', 2, 8, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(241, 'Irritty', 2, 13, 0, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:07'),
(242, 'Ittiva', 1, 2, 53, 1, '2020-06-14 03:07:07', '2020-06-14 03:07:08'),
(243, 'Kadakkal', 1, 2, 53, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(244, 'Kadakkarappally', 1, 4, 7, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(245, 'Kadakkavoor', 1, 1, 123, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(246, 'Kadalundy', 1, 11, 77, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(247, 'Kadamakkudy', 1, 7, 15, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(248, 'Kadambazhippuram', 1, 9, 112, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(249, 'Kadambur', 1, 13, 35, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(250, 'Kadampanadu', 1, 3, 119, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(251, 'Kadanad', 1, 5, 67, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(252, 'Kadangod', 1, 8, 137, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(253, 'Kadannappalli Panapuzha', 1, 13, 44, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(254, 'Kadaplamattom', 1, 5, 71, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(255, 'Kadappuram', 1, 8, 135, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(256, 'Kadapra', 1, 3, 120, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(257, 'Kadavallur', 1, 8, 137, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(258, 'Kadinamkolam', 1, 1, 129, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(259, 'Kadirur', 1, 13, 41, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(260, 'Kadukutty', 1, 8, 134, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(261, 'Kadungallor', 1, 7, 13, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(262, 'Kaduthuruthy', 1, 5, 65, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(263, 'Kainakary', 1, 4, 4, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(264, 'Kaiparambu', 1, 8, 145, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(265, 'Kaippamangalam', 1, 8, 141, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(266, 'Kakkodi', 1, 11, 75, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(267, 'Kakkur', 1, 11, 75, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(268, 'Kalady', 1, 10, 95, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(269, 'Kalamassery', 2, 7, 0, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(270, 'Kalanjoor', 1, 3, 119, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(271, 'Kalikavu', 1, 10, 87, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(272, 'Kallar', 1, 14, 51, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(273, 'Kallara', 1, 5, 65, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(274, 'Kalliasseri', 1, 13, 38, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(275, 'Kallikkad', 1, 1, 128, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(276, 'Kalliyoor', 1, 1, 126, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(277, 'Kalloopara', 1, 3, 117, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(278, 'Kalloorkad', 1, 7, 19, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:08'),
(279, 'Kalluvathukkal', 1, 2, 56, 1, '2020-06-14 03:07:08', '2020-06-14 03:07:09'),
(280, 'Kalpakancheri', 1, 10, 89, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(281, 'Kalpetta', 2, 12, 0, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(282, 'Kamakshi', 1, 6, 31, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(283, 'Kanakkari', 1, 5, 71, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(284, 'Kanchiyar', 1, 6, 32, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(285, 'Kandallor', 1, 4, 9, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(286, 'Kandanassery', 1, 8, 137, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(287, 'Kangazha', 1, 5, 73, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(288, 'Kanhangad', 2, 14, 0, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(289, 'Kanhirapuzha', 1, 9, 107, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(290, 'Kanichar', 1, 13, 43, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(291, 'Kaniyanpatta', 1, 12, 151, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(292, 'Kanjikuzhy', 1, 4, 7, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(293, 'Kanjiram Kulam', 1, 1, 122, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(294, 'Kanjirappally', 1, 5, 66, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(295, 'Kanjoor', 1, 7, 14, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(296, 'Kankol Alapadamba', 1, 13, 42, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(297, 'Kannadi', 1, 9, 105, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(298, 'Kannamangalam', 1, 10, 99, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(299, 'Kannampra', 1, 9, 101, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(300, 'Kannapuram', 1, 13, 38, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(301, 'Kannur', 3, 13, 0, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(302, 'Kanthaloor', 1, 6, 29, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(303, 'Kappoor', 1, 9, 113, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(304, 'Karadka', 1, 14, 47, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(305, 'Karakulam', 1, 1, 125, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(306, 'Karakurussi', 1, 9, 112, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(307, 'Karalam', 1, 8, 138, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(308, 'Karassery', 1, 11, 78, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(309, 'Karavaloor', 1, 2, 52, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(310, 'Karavaram', 1, 1, 124, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(311, 'Kareepera', 1, 2, 57, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(312, 'Karimannoor', 1, 6, 30, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(313, 'Karimba', 1, 9, 107, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(314, 'Karimpuzha', 1, 9, 112, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(315, 'Karinkunnam', 1, 6, 34, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(316, 'Karivellur Peralam', 1, 13, 42, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(317, 'Karode', 1, 1, 127, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(318, 'Karoor', 1, 5, 67, 1, '2020-06-14 03:07:09', '2020-06-14 03:07:09'),
(319, 'Karthikapally', 1, 4, 6, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(320, 'Karukachal', 1, 5, 73, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(321, 'Karukutty', 1, 7, 14, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(322, 'Karulayi', 1, 10, 87, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(323, 'Karumallor', 1, 7, 13, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(324, 'Karumkulam', 1, 1, 122, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(325, 'Karunagappally', 2, 2, 0, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(326, 'Karunapuram', 1, 6, 33, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(327, 'Karuvarakundu', 1, 10, 87, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(328, 'Karuvatta', 1, 4, 6, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(329, 'Kasargode', 2, 14, 0, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(330, 'Kattakambal', 1, 8, 137, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(331, 'Kattakkada', 1, 1, 132, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(332, 'Kattapana', 2, 6, 0, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(333, 'Kattippara', 1, 11, 76, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(334, 'Kattoor', 1, 8, 138, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(335, 'Kavalam', 1, 4, 12, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(336, 'Kavalangad', 1, 7, 17, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(337, 'Kavanoor', 1, 10, 86, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(338, 'Kavassery', 1, 9, 101, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(339, 'Kavilumpara', 1, 11, 79, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(340, 'Kaviyoor', 1, 3, 117, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(341, 'Kayakody', 1, 11, 79, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(342, 'Kayamkulam', 2, 4, 0, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(343, 'Kayanna', 1, 11, 82, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(344, 'Kayyur Cheemeny', 1, 14, 49, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(345, 'Keerambara', 1, 7, 17, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(346, 'Keezhallur', 1, 13, 37, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(347, 'Keezhariyur', 1, 11, 80, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(348, 'Keezhattur', 1, 10, 93, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(349, 'Keezhmadu', 1, 7, 25, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(350, 'Kelakam', 1, 13, 43, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(351, 'Keralassery', 1, 9, 110, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(352, 'Kidangoor', 1, 5, 70, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(353, 'Kilimanoor', 1, 1, 124, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:10'),
(354, 'Kinanoor Karinthalam', 1, 14, 51, 1, '2020-06-14 03:07:10', '2020-06-14 03:07:11'),
(355, 'Kizhakambalam', 1, 7, 25, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(356, 'Kizhakkancheri', 1, 9, 101, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(357, 'Kizhakkoth', 1, 11, 76, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(358, 'Kizhuparamba', 1, 10, 86, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(359, 'Kizhuvilam', 1, 1, 123, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(360, 'Kochi', 3, 7, 0, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(361, 'Kodakara', 1, 8, 139, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(362, 'Kodamthuruthu', 1, 4, 10, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(363, 'Kodanchery', 1, 11, 76, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(364, 'Kodassery', 1, 8, 134, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(365, 'Kodikkulam', 1, 6, 30, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(366, 'Kodiyathur', 1, 11, 78, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(367, 'Kodom Belur', 1, 14, 51, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(368, 'Kodumba', 1, 9, 106, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(369, 'Kodumon', 1, 3, 119, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(370, 'Kodungallur', 2, 8, 0, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(371, 'Kodur', 1, 10, 90, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(372, 'Koduvally', 2, 11, 0, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(373, 'Koduvayoor', 1, 9, 104, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(374, 'Kokkyar', 1, 6, 28, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(375, 'Kolacheri', 1, 13, 35, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(376, 'Kolayad', 1, 13, 43, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(377, 'Kolazhy', 1, 8, 145, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(378, 'Kollam', 3, 2, 0, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(379, 'Kollamkode', 1, 9, 104, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(380, 'Kollayil', 1, 1, 128, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(381, 'Kondazhy', 1, 8, 144, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(382, 'Kondotty', 2, 10, 0, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(383, 'Kongad', 1, 9, 110, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(384, 'Konnathadi', 1, 6, 27, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(385, 'Konni', 1, 3, 115, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(386, 'Koodali', 1, 13, 37, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(387, 'Koodaranhi', 1, 11, 76, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(388, 'Koorachundu', 1, 11, 74, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(389, 'Kooropada', 1, 5, 70, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:11'),
(390, 'Koothali', 1, 11, 82, 1, '2020-06-14 03:07:11', '2020-06-14 03:07:12'),
(391, 'KOOTHATUKULAM', 2, 7, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(392, 'Koothuparamba', 2, 13, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(393, 'Koottickal', 1, 5, 66, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(394, 'Koottilangadi', 1, 10, 91, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(395, 'Koovappady', 1, 7, 16, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(396, 'Koppam', 1, 9, 111, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(397, 'Koratty', 1, 8, 134, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(398, 'Koruthodu', 1, 5, 66, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(399, 'Kothamangalam', 2, 7, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(400, 'Kottakkal', 2, 10, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(401, 'Kottanadu', 1, 3, 117, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(402, 'Kottangal', 1, 3, 117, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(403, 'Kottankara', 1, 2, 58, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(404, 'Kottappady', 1, 7, 17, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(405, 'Kottarakkara', 2, 2, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(406, 'Kottathara', 1, 12, 149, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(407, 'Kottayamm', 1, 13, 40, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(408, 'Kottayam', 2, 5, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(409, 'Kottayi', 1, 9, 105, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(410, 'Kottiyoor', 1, 13, 43, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(411, 'Kottoor', 1, 11, 74, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(412, 'Kottoppadam', 1, 9, 107, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(413, 'Kottukal', 1, 1, 122, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(414, 'Kottuvally', 1, 7, 23, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(415, 'Koyipram', 1, 3, 116, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(416, 'Kozhencherry', 1, 3, 114, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(417, 'Kozhikode', 3, 11, 0, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(418, 'Kozhingampara', 1, 9, 103, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(419, 'Kozhuvanal', 1, 5, 67, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(420, 'Krishnapuram', 1, 4, 9, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(421, 'Kudayathoor', 1, 6, 30, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(422, 'Kulakkada', 1, 2, 62, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(423, 'Kulanada', 1, 3, 118, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(424, 'Kulashekarapuram', 1, 2, 59, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(425, 'Kulathoor', 1, 1, 127, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(426, 'Kulathupuzha', 1, 2, 52, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(427, 'Kulukkallur', 1, 9, 111, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(428, 'Kumaly', 1, 6, 28, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:12'),
(429, 'Kumarakom', 1, 5, 64, 1, '2020-06-14 03:07:12', '2020-06-14 03:07:13'),
(430, 'Kumaramangalam', 1, 6, 34, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(431, 'Kumaramputhur', 1, 9, 107, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(432, 'Kumarapuram', 1, 4, 6, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(433, 'Kumbadaje', 1, 14, 47, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(434, 'Kumbalam', 1, 7, 20, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(435, 'Kumbalangy', 1, 7, 20, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(436, 'Kumbla', 1, 14, 48, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(437, 'Kummil', 1, 2, 53, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(438, 'Kundara', 1, 2, 55, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(439, 'Kunhimangalam', 1, 13, 42, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(440, 'Kunnamangalam', 1, 11, 78, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(441, 'Kunnamkulam', 2, 8, 0, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(442, 'Kunnanthanam', 1, 3, 117, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(443, 'Kunnathoor', 1, 2, 61, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(444, 'Kunnathukal', 1, 1, 128, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(445, 'Kunnathunadu', 1, 7, 24, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(446, 'Kunnothuparamba', 1, 13, 40, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(447, 'Kunnukara', 1, 7, 22, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(448, 'Kunnummal', 1, 11, 79, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(449, 'Kuravilangadu', 1, 5, 71, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(450, 'Kurichy', 1, 5, 69, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(451, 'Kurumathur', 1, 13, 44, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(452, 'Kuruva', 1, 10, 91, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(453, 'Kuruvattur', 1, 11, 78, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(454, 'Kuthannoor', 1, 9, 105, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(455, 'Kuthiyathodu', 1, 4, 10, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(456, 'Kuttampuzha', 1, 7, 17, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(457, 'Kuttichal', 1, 1, 132, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(458, 'Kuttikkol', 1, 14, 47, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(459, 'Kuttippuram', 1, 10, 89, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(460, 'Kuttiyattur', 1, 13, 36, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(461, 'Kuttoor', 1, 3, 120, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(462, 'Kuttyadi', 1, 11, 79, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(463, 'Kuzhalmandam', 1, 9, 105, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(464, 'Kuzhimanna', 1, 10, 86, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(465, 'Kuzhoor', 1, 8, 140, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(466, 'Kuzhuppilly', 1, 7, 26, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:13'),
(467, 'Lakkidiperoor', 1, 9, 109, 1, '2020-06-14 03:07:13', '2020-06-14 03:07:14'),
(468, 'Madakkathara', 1, 8, 143, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(469, 'Madappally', 1, 5, 68, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(470, 'Madavoor', 1, 11, 76, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(471, 'Madayi', 1, 13, 38, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(472, 'Madhur', 1, 14, 48, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(473, 'Madikkai', 1, 14, 46, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(474, 'Makkaraparamba', 1, 10, 91, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(475, 'Mala', 1, 8, 140, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(476, 'Malambuzha', 1, 9, 106, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(477, 'Malappattam', 1, 13, 36, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(478, 'Malappuram', 2, 10, 0, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(479, 'Malayalapuzha', 1, 3, 115, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(480, 'Malayattoor Neeleeswaram', 1, 7, 14, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(481, 'Malayinkeezh', 1, 1, 126, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(482, 'Mallappally', 1, 3, 117, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(483, 'Mallapuzhassery', 1, 3, 114, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(484, 'Maloor', 1, 13, 43, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(485, 'Mambad', 1, 10, 100, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(486, 'Manakkadu', 1, 6, 34, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(487, 'Manaloor', 1, 8, 133, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(488, 'Manampoor', 1, 1, 131, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(489, 'Mananthavady', 2, 12, 0, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(490, 'Manarcad', 1, 5, 70, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(491, 'Mandro Thuruthu', 1, 2, 55, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(492, 'Maneed', 1, 7, 18, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(493, 'Mangalam', 1, 10, 98, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(494, 'Mangalapuram', 1, 1, 129, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(495, 'Mangalpadi', 1, 14, 50, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(496, 'Mangattidam', 1, 13, 40, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(497, 'Manickal', 1, 1, 130, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(498, 'Manimala', 1, 5, 66, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(499, 'Maniyur', 1, 11, 83, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(500, 'Manjalloor', 1, 7, 19, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(501, 'Manjapra', 1, 7, 14, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(502, 'Manjeri', 2, 10, 0, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(503, 'Manjeshwar', 1, 14, 50, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(504, 'Manjoor', 1, 5, 71, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(505, 'Mankada', 1, 10, 91, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(506, 'Mankara', 1, 9, 110, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:14'),
(507, 'Mankulam', 1, 6, 29, 1, '2020-06-14 03:07:14', '2020-06-14 03:07:15'),
(508, 'Mannanchery', 1, 4, 2, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(509, 'Mannar', 1, 4, 8, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(510, 'Mannarkad-I', 2, 9, 0, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(511, 'Mannoor', 1, 9, 110, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(512, 'Maradu', 2, 7, 0, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(513, 'Marady', 1, 7, 19, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(514, 'Marakkara', 1, 10, 89, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(515, 'Maranalloor', 1, 1, 126, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(516, 'Maranchery', 1, 10, 94, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(517, 'Marangattupally', 1, 5, 71, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(518, 'Mararikulam Thekku', 1, 4, 2, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(519, 'Mararikulam Vadakku', 1, 4, 7, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(520, 'Maravanthuruthu', 1, 5, 72, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(521, 'Marayoor', 1, 6, 29, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(522, 'Mariyapuram', 1, 6, 31, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(523, 'Marutharoad', 1, 9, 106, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(524, 'Maruthonkara', 1, 11, 79, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(525, 'Mathilakam', 1, 8, 141, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(526, 'Mathoor', 1, 9, 105, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(527, 'Mattannur', 2, 13, 0, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(528, 'Mattathoor', 1, 8, 139, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(529, 'Mattool', 1, 13, 38, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(530, 'Mavelikkara', 2, 4, 0, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(531, 'Mavelikkara Thamarakulam', 1, 4, 3, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(532, 'Mavelikkara Thekkekara', 1, 4, 8, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(533, 'Mavoor', 1, 11, 78, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(534, 'Mayyanad', 1, 2, 58, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(535, 'Mayyil', 1, 13, 36, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(536, 'Mazhuvannoor', 1, 7, 24, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(537, 'Meenachil', 1, 5, 67, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(538, 'Meenadom', 1, 5, 70, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(539, 'Meenagadi', 1, 12, 152, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(540, 'Meenja', 1, 14, 50, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(541, 'Melarkode', 1, 9, 108, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(542, 'Melattur', 1, 10, 93, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(543, 'Melila', 1, 2, 62, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(544, 'Meloor', 1, 8, 134, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:15'),
(545, 'Melukavu', 1, 5, 63, 1, '2020-06-14 03:07:15', '2020-06-14 03:07:16'),
(546, 'Meppadi', 1, 12, 149, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(547, 'Meppayyur', 1, 11, 80, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(548, 'Mezhuveli', 1, 3, 118, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(549, 'Mogral Puthur', 1, 14, 48, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(550, 'Mokeri', 1, 13, 41, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(551, 'Moodady', 1, 11, 81, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(552, 'Moonnilavu', 1, 5, 63, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(553, 'Moonniyur', 1, 10, 97, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(554, 'Moopainad', 1, 12, 149, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(555, 'Moorkanad', 1, 10, 91, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(556, 'Moothedam', 1, 10, 92, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(557, 'Moryur', 1, 10, 90, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(558, 'Mudakkal', 1, 1, 123, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(559, 'Mudakuzha', 1, 7, 16, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(560, 'Muhamma', 1, 4, 2, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(561, 'Mukkannoor', 1, 7, 14, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(562, 'Mukkom', 2, 11, 0, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(563, 'Mulakkuzha', 1, 4, 5, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(564, 'Mulakulam', 1, 5, 65, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(565, 'Mulangunnathu Kavu', 1, 8, 145, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(566, 'Mulanthuruthy', 1, 7, 18, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(567, 'Mulavukkad', 1, 7, 15, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(568, 'Muliyar', 1, 14, 47, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(569, 'Mullankolli', 1, 12, 151, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(570, 'Mullassery', 1, 8, 142, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(571, 'Mullurkkara', 1, 8, 148, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(572, 'Mundakkayam', 1, 5, 66, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(573, 'Munderi', 1, 13, 35, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(574, 'Mundoor', 1, 9, 110, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(575, 'Munnar', 1, 6, 29, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(576, 'Muriyad', 1, 8, 138, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(577, 'Muthalamada', 1, 9, 104, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(578, 'Mutholi', 1, 5, 67, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(579, 'Muthukulam', 1, 4, 9, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(580, 'Muthuthala', 1, 9, 111, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:16'),
(581, 'Muthuvallor', 1, 10, 88, 1, '2020-06-14 03:07:16', '2020-06-14 03:07:17'),
(582, 'Muttar', 1, 4, 12, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(583, 'Muttil', 1, 12, 149, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(584, 'Muttom', 1, 6, 34, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(585, 'Muvattupuzha', 2, 7, 0, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(586, 'Muzhakunnu', 1, 13, 43, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(587, 'Muzhappilangad', 1, 13, 45, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(588, 'Mylapra', 1, 3, 115, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(589, 'Mylom', 1, 2, 62, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(590, 'Mynagappally', 1, 2, 61, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(591, 'Nadapuram', 1, 11, 84, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(592, 'Nadathara', 1, 8, 143, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(593, 'Naduvannoor', 1, 11, 74, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(594, 'Naduvil', 1, 13, 44, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(595, 'Nagalassery', 1, 9, 113, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(596, 'Nagaroor', 1, 1, 124, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(597, 'Nallepilly', 1, 9, 103, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(598, 'Nanminda', 1, 11, 75, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(599, 'Nannambra', 1, 10, 97, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(600, 'Nannammukku', 1, 10, 94, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(601, 'Nanniyode', 1, 1, 130, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(602, 'Naranammoozhy', 1, 3, 121, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(603, 'Naranganam', 1, 3, 114, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(604, 'Narath', 1, 13, 38, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(605, 'Narikkuni', 1, 11, 75, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(606, 'Naripatta', 1, 11, 79, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(607, 'Nattika', 1, 8, 146, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(608, 'Navaikkulam', 1, 1, 124, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(609, 'Nayarambalam', 1, 7, 26, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(610, 'Nedumangad', 2, 1, 0, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(611, 'Nedumbassery', 1, 7, 22, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(612, 'Nedumkandom', 1, 6, 33, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(613, 'Nedumkunnam', 1, 5, 73, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(614, 'Nedumpana', 1, 2, 58, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(615, 'Nedumpram', 1, 3, 120, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(616, 'Nedumudy', 1, 4, 4, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(617, 'Neduvathur', 1, 2, 57, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(618, 'Neelaperoor', 1, 4, 12, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(619, 'Neendakara', 1, 2, 54, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:17'),
(620, 'Neendoor', 1, 5, 64, 1, '2020-06-14 03:07:17', '2020-06-14 03:07:18'),
(621, 'Nellanad', 1, 1, 130, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(622, 'Nellaya', 1, 9, 109, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(623, 'Nellikkuzhy', 1, 7, 17, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(624, 'Nelliyampathy', 1, 9, 108, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(625, 'Nemmara', 1, 9, 108, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(626, 'Nenmanikkara', 1, 8, 139, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(627, 'Nenmeni', 1, 12, 152, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(628, 'New Mahe', 1, 13, 45, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(629, 'Neyyattinkara', 2, 1, 0, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(630, 'Nilambur', 2, 10, 0, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(631, 'Nilamel', 1, 2, 53, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(632, 'Nileswaram', 2, 14, 0, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(633, 'Niramaruthur', 1, 10, 96, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(634, 'Niranam', 1, 3, 120, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(635, 'Njarakkal', 1, 7, 26, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(636, 'Njeezhoor', 1, 5, 65, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(637, 'Nochad', 1, 11, 82, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(638, 'Noolpuzha', 1, 12, 152, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(639, 'Nooranadu', 1, 4, 3, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18');
INSERT INTO `localbodies` (`id`, `name_eng`, `lb_type_id`, `district_id`, `block_id`, `is_active`, `created_at`, `updated_at`) VALUES
(640, 'Oachira', 1, 2, 59, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(641, 'Okkal', 1, 7, 16, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(642, 'Olavanna', 1, 11, 77, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(643, 'Omallur', 1, 3, 114, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(644, 'Omassery', 1, 11, 76, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(645, 'Onchiyam', 1, 11, 85, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(646, 'Ongalloor', 1, 9, 111, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(647, 'Orumanyoor', 1, 8, 135, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(648, 'Othukkungal', 1, 10, 90, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(649, 'Ottappalam', 2, 9, 0, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:18'),
(650, 'Ottasekharamangalam', 1, 1, 128, 1, '2020-06-14 03:07:18', '2020-06-14 03:07:19'),
(651, 'Ottoor', 1, 1, 131, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(652, 'Ozhur', 1, 10, 96, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(653, 'Padanna', 1, 14, 49, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(654, 'Padinjarathara', 1, 12, 149, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(655, 'Padiyoor', 1, 13, 36, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(656, 'Padyoor', 1, 8, 147, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(657, 'Paingottur', 1, 7, 17, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(658, 'Paippad', 1, 5, 68, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(659, 'Paipra', 1, 7, 19, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(660, 'Paivalike', 1, 14, 50, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(661, 'Palai', 2, 5, 0, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(662, 'Palakkad', 2, 9, 0, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(663, 'Palakuzha', 1, 7, 21, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(664, 'Palamel', 1, 4, 3, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(665, 'Pallarimangalam', 1, 7, 17, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(666, 'Pallassana', 1, 9, 108, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(667, 'Pallichal', 1, 1, 126, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(668, 'Pallickal', 1, 3, 119, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(669, 'Pallickathodu', 1, 5, 70, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(670, 'Pallikkal', 1, 10, 88, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(671, 'Pallikkara', 1, 14, 46, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(672, 'Pallippad', 1, 4, 6, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(673, 'Pallipuram', 1, 7, 26, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(674, 'Pallivasal', 1, 6, 27, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(675, 'Pampadumpara', 1, 6, 33, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(676, 'Pampady', 1, 5, 70, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(677, 'Pampakuda', 1, 7, 21, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(678, 'Panachikkad', 1, 5, 69, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(679, 'Panamaram', 1, 12, 151, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(680, 'Pananchery', 1, 8, 143, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(681, 'Panangad', 1, 11, 74, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(682, 'Panathadi', 1, 14, 51, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(683, 'Panavally', 1, 4, 11, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(684, 'Panavoor', 1, 1, 125, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:19'),
(685, 'Panayam', 1, 2, 55, 1, '2020-06-14 03:07:19', '2020-06-14 03:07:20'),
(686, 'Pandalam', 2, 3, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(687, 'Pandalam Thekkekara', 1, 3, 118, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(688, 'Pandanad', 1, 4, 5, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(689, 'Pandikkad', 1, 10, 100, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(690, 'Pangode', 1, 1, 130, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(691, 'Panjal', 1, 8, 144, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(692, 'Panmana', 1, 2, 54, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(693, 'Panniyannur', 1, 13, 41, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(694, 'Panoor', 2, 13, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(695, 'Pappinisseri', 1, 13, 39, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(696, 'Parakkadavu', 1, 7, 22, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(697, 'Paralam', 1, 8, 136, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(698, 'Parali', 1, 9, 110, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(699, 'Parapinangadi', 2, 10, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(700, 'Parapookkara', 1, 8, 138, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(701, 'Parappur', 1, 10, 99, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(702, 'Parassala', 1, 1, 127, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(703, 'Parathodu', 1, 5, 66, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(704, 'Paravoor', 2, 2, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(705, 'Paravur', 2, 7, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(706, 'Pariyaaram', 1, 8, 134, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(707, 'Pariyaram', 1, 13, 44, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(708, 'Paruthoor', 1, 9, 111, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(709, 'Pathanamthitta', 2, 3, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(710, 'Pathanapuram', 1, 2, 60, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(711, 'Pathiyoor', 1, 4, 9, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(712, 'Pattambi', 2, 9, 0, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(713, 'Pattanakkadu', 1, 4, 10, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(714, 'Pattancheri', 1, 9, 104, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(715, 'Pattazhi', 1, 2, 60, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(716, 'Pattazhi North', 1, 2, 60, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(717, 'Pattiam', 1, 13, 40, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(718, 'Pattithara', 1, 9, 113, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:20'),
(719, 'Pattuvam', 1, 13, 44, 1, '2020-06-14 03:07:20', '2020-06-14 03:07:21'),
(720, 'Pavaratty', 1, 8, 142, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(721, 'Pavithreswaram', 1, 2, 62, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(722, 'Payam', 1, 13, 37, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(723, 'Payyannur', 2, 13, 0, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(724, 'Payyavoor', 1, 13, 36, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(725, 'Payyoli', 2, 11, 0, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(726, 'Pazhayakunnummel', 1, 1, 124, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(727, 'Pazhayannoor', 1, 8, 144, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(728, 'Peermade', 1, 6, 28, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(729, 'Peralasseri', 1, 13, 35, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(730, 'Perambra', 1, 11, 82, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(731, 'Peravoor', 1, 13, 43, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(732, 'Perayam', 1, 2, 55, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(733, 'Perinad', 1, 2, 55, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(734, 'Peringammala', 1, 1, 130, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(735, 'Peringara', 1, 3, 120, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(736, 'Peringome Vayakkara', 1, 13, 42, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(737, 'Peringottukurissi', 1, 9, 105, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(738, 'Perinjanam', 1, 8, 141, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(739, 'Perinthalmanna', 2, 10, 0, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(740, 'Perumanna', 1, 11, 78, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(741, 'Perumatti', 1, 9, 103, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(742, 'Perumbalam', 1, 4, 11, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(743, 'Perumbavoor', 2, 7, 0, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(744, 'Perumkadavila', 1, 1, 128, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(745, 'Perumpadappu', 1, 10, 94, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(746, 'Peruvallur', 1, 10, 97, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(747, 'Peruvambu', 1, 9, 104, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(748, 'Peruvanthanam', 1, 6, 28, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(749, 'Peruvayal', 1, 11, 78, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(750, 'Pilicode', 1, 14, 49, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(751, 'Pinarayi', 1, 13, 45, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(752, 'Pindimana', 1, 7, 17, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(753, 'Piravanthoor', 1, 2, 60, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(754, 'Piravom', 2, 7, 0, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(755, 'Pirayiri', 1, 9, 110, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:21'),
(756, 'Polppully', 1, 9, 103, 1, '2020-06-14 03:07:21', '2020-06-14 03:07:22'),
(757, 'Ponmala', 1, 10, 90, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(758, 'Ponmundam', 1, 10, 96, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(759, 'Ponnani', 2, 10, 0, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(760, 'Pookkoottukavu', 1, 9, 112, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(761, 'Pookkottur', 1, 10, 90, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(762, 'Poomangalam', 1, 8, 147, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(763, 'Poonjar', 1, 5, 63, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(764, 'Poonjar Thekkekara', 1, 5, 63, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(765, 'Poothadi', 1, 12, 151, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(766, 'Poothakulam', 1, 2, 56, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(767, 'Poothrikka', 1, 7, 24, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(768, 'Poovachal', 1, 1, 132, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(769, 'Poovar', 1, 1, 127, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(770, 'Pooyapally', 1, 2, 57, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(771, 'Porkulam', 1, 8, 137, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(772, 'Porur', 1, 10, 100, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(773, 'Poruvazhy', 1, 2, 61, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(774, 'Pothanikkad', 1, 7, 17, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(775, 'Pothencode', 1, 1, 129, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(776, 'Pothukal', 1, 10, 92, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(777, 'Poyya', 1, 8, 140, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(778, 'Pozhuthana', 1, 12, 149, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(779, 'Pramadom', 1, 3, 115, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(780, 'Pudukkad', 1, 8, 139, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(781, 'Pulamanthol', 1, 10, 93, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(782, 'Pulikkal', 1, 10, 88, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(783, 'Pulimath', 1, 1, 124, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(784, 'Pulinkunnu', 1, 4, 12, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(785, 'Puliyoor', 1, 4, 5, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(786, 'Pullampara', 1, 1, 130, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(787, 'Pullur Periya', 1, 14, 46, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(788, 'Pulpatta', 1, 10, 86, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(789, 'Pulppalli', 1, 12, 151, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(790, 'Punalur', 2, 2, 0, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(791, 'Punnapra Thekku', 1, 4, 1, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(792, 'Punnapra Vadakku', 1, 4, 1, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:22'),
(793, 'Punnayoor', 1, 8, 135, 1, '2020-06-14 03:07:22', '2020-06-14 03:07:23'),
(794, 'Punnayoorkulam', 1, 8, 135, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(795, 'Purakkadu', 1, 4, 1, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(796, 'Puramattom', 1, 3, 116, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(797, 'Purameri', 1, 11, 84, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(798, 'Purappuzha', 1, 6, 34, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(799, 'Purathur', 1, 10, 98, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(800, 'Puthenchira', 1, 8, 147, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(801, 'Puthenvelikkara', 1, 7, 22, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(802, 'Puthige', 1, 14, 50, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(803, 'Puthoor', 1, 8, 143, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(804, 'Puthukkode', 1, 9, 101, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(805, 'Puthunagaram', 1, 9, 104, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(806, 'Puthupally', 1, 5, 69, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(807, 'Puthuppadi', 1, 11, 76, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(808, 'Puthuppariyaram', 1, 9, 106, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(809, 'Puthur', 1, 9, 102, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(810, 'Puthussery', 1, 9, 106, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(811, 'Puzhakkattiri', 1, 10, 91, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(812, 'Quilandy', 2, 11, 0, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(813, 'Rajakkadu', 1, 6, 33, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(814, 'Rajakumari', 1, 6, 33, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(815, 'Ramamangalam', 1, 7, 21, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(816, 'Ramanattukara', 2, 11, 0, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(817, 'Ramankary', 1, 4, 12, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(818, 'Ramanthali', 1, 13, 42, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(819, 'Ramapuram', 1, 5, 71, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(820, 'Ranni', 1, 3, 121, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(821, 'Ranni Angadi', 1, 3, 121, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(822, 'Ranni Pazhavangadi', 1, 3, 121, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(823, 'Ranni Perunad', 1, 3, 121, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(824, 'Rayamangalam', 1, 7, 16, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(825, 'Santhenpara', 1, 6, 29, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(826, 'Sasthamcotta', 1, 2, 61, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(827, 'Seetha Thodu', 1, 3, 121, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(828, 'Senapathy', 1, 6, 33, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:23'),
(829, 'Sholayur', 1, 9, 102, 1, '2020-06-14 03:07:23', '2020-06-14 03:07:24'),
(830, 'Shoranur', 2, 9, 0, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(831, 'Sooranad South', 1, 2, 61, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(832, 'Sooranadu North', 1, 2, 61, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(833, 'Sreekandapuram', 2, 13, 0, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(834, 'Sreekrishnapuram', 1, 9, 112, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(835, 'Sreemoolanagaram', 1, 7, 22, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(836, 'Sreenarayanapuram', 1, 8, 141, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(837, 'Sulthanbathery', 2, 12, 0, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(838, 'T V Puram', 1, 5, 72, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(839, 'Taliparamba', 2, 13, 0, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(840, 'Tavannur', 1, 10, 95, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(841, 'Teekoy', 1, 5, 63, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(842, 'Thachampara', 1, 9, 107, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(843, 'Thachanattukara', 1, 9, 107, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(844, 'Thakazhy', 1, 4, 4, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(845, 'Thalakkad', 1, 10, 98, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(846, 'Thalakulathur', 1, 11, 75, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(847, 'Thalanadu', 1, 5, 63, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(848, 'Thalapalam', 1, 5, 63, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(849, 'Thalassery', 2, 13, 0, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(850, 'Thalavady', 1, 4, 4, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(851, 'Thalavoor', 1, 2, 60, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(852, 'Thalayazham', 1, 5, 72, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(853, 'Thalayolapparambu', 1, 5, 65, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(854, 'Thalikulam', 1, 8, 146, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(855, 'Thamarassery', 1, 11, 76, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(856, 'Thanalur', 1, 10, 96, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(857, 'Thannermukkom', 1, 4, 7, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(858, 'Thanniam', 1, 8, 133, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(859, 'Thannithodu', 1, 3, 115, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(860, 'Thanur', 2, 10, 0, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(861, 'Thariyode', 1, 12, 149, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(862, 'Tharoor', 1, 9, 101, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(863, 'Thavinjal', 1, 12, 150, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(864, 'Thazhakkara', 1, 4, 8, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(865, 'Thazhava', 1, 2, 59, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:24'),
(866, 'Thazhekode', 1, 10, 93, 1, '2020-06-14 03:07:24', '2020-06-14 03:07:25'),
(867, 'Thekkum Bhagam', 1, 2, 54, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(868, 'Thekkumkara', 1, 8, 148, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(869, 'Thenhippalam', 1, 10, 97, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(870, 'Thenkara', 1, 9, 107, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(871, 'Thenkurissi', 1, 9, 105, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(872, 'Thenmala', 1, 2, 52, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(873, 'Thennala', 1, 10, 99, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(874, 'Thevalakara', 1, 2, 54, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(875, 'Thidanadu', 1, 5, 63, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(876, 'Thikkodi', 1, 11, 80, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(877, 'Thillankeri', 1, 13, 37, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(878, 'Thirumarady', 1, 7, 21, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(879, 'Thirumittacode', 1, 9, 113, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(880, 'Thirunavaya', 1, 10, 98, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(881, 'Thirunelli', 1, 12, 150, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(882, 'Thirupuram', 1, 1, 127, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(883, 'Thiruvali', 1, 10, 100, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(884, 'Thiruvalla', 2, 3, 0, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(885, 'Thiruvallur', 1, 11, 83, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(886, 'Thiruvambady', 1, 11, 76, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(887, 'Thiruvananthapuram', 3, 1, 0, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(888, 'Thiruvaniyoor', 1, 7, 24, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(889, 'Thiruvanvandoor', 1, 4, 5, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(890, 'Thiruvarppu', 1, 5, 64, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(891, 'Thiruvegappura', 1, 9, 111, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(892, 'Thiruvilwamala', 1, 8, 144, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(893, 'Thodiyoor', 1, 2, 59, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(894, 'Thodupuzha', 2, 6, 0, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(895, 'Tholicode', 1, 1, 132, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(896, 'Tholoor', 1, 8, 145, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(897, 'Thondarnad', 1, 12, 150, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(898, 'Thottapuzhassery', 1, 3, 116, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(899, 'Thrikakara', 2, 7, 0, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(900, 'Thrikkaderi', 1, 9, 109, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:25'),
(901, 'Thrikkaripur', 1, 14, 49, 1, '2020-06-14 03:07:25', '2020-06-14 03:07:26'),
(902, 'Thrikkaruva', 1, 2, 55, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(903, 'Thrikkovilvattom', 1, 2, 58, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(904, 'Thrikkunnapuzha', 1, 4, 6, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(905, 'Thrikodithanam', 1, 5, 68, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(906, 'Thrikoor', 1, 8, 139, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(907, 'Thrippangottur', 1, 13, 40, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(908, 'Thrippunithura', 2, 7, 0, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(909, 'Thrissur', 3, 8, 0, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(910, 'Thrithala', 1, 9, 113, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(911, 'Thumpamon', 1, 3, 118, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(912, 'Thuneri', 1, 11, 84, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(913, 'Thuravoor', 1, 7, 14, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(914, 'Thurayoor', 1, 11, 80, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(915, 'Thuvvur', 1, 10, 87, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(916, 'Thycattussery', 1, 4, 11, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(917, 'Tirur', 2, 10, 0, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(918, 'Tirurangadi', 2, 10, 0, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(919, 'Trikkalangode', 1, 10, 100, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(920, 'Tripangode', 1, 10, 98, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(921, 'Trivandrum Kallara', 1, 1, 130, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(922, 'Trivandrum Madavoor', 1, 1, 124, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(923, 'Trivandrum Pallickal', 1, 1, 124, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(924, 'Udayagiri', 1, 13, 44, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(925, 'Udayamperoor', 1, 7, 18, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(926, 'Udayanapuram', 1, 5, 72, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(927, 'Uduma', 1, 14, 46, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(928, 'Udumbanchola', 1, 6, 33, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(929, 'Udumbanoor', 1, 6, 30, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(930, 'Ulikkal', 1, 13, 36, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(931, 'Ulliyery', 1, 11, 74, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(932, 'Ummannoor', 1, 2, 62, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(933, 'Unnikulam', 1, 11, 74, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(934, 'Upputhara', 1, 6, 32, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(935, 'Urakam', 1, 10, 99, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(936, 'Urangattiri', 1, 10, 86, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(937, 'Uzhamalakkal', 1, 1, 132, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(938, 'Uzhavoor', 1, 5, 71, 1, '2020-06-14 03:07:26', '2020-06-14 03:07:26'),
(939, 'Vadakara', 2, 11, 0, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(940, 'Vadakarappathy', 1, 9, 103, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(941, 'Vadakkancheri', 1, 9, 101, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(942, 'Vadakkekara', 1, 7, 23, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(943, 'Vadakkekkad', 1, 8, 135, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(944, 'Vadanappilly', 1, 8, 146, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(945, 'Vadaserikara', 1, 3, 121, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(946, 'Vadavanoor', 1, 9, 104, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(947, 'Vadavucode Puthencruz', 1, 7, 24, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(948, 'Vaikom', 2, 5, 0, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(949, 'Vaithiri', 1, 12, 149, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(950, 'Vakathanam', 1, 5, 68, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(951, 'Vakkom', 1, 1, 123, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(952, 'Valakom', 1, 7, 19, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(953, 'Valanchery', 2, 10, 0, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(954, 'Valapattanam', 1, 13, 39, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(955, 'Valappad', 1, 8, 146, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(956, 'Valavannur', 1, 10, 96, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(957, 'Valayam', 1, 11, 84, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(958, 'Valiyaparamba', 1, 14, 49, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(959, 'Vallachira', 1, 8, 136, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(960, 'Vallappuzha', 1, 9, 109, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(961, 'Vallatholenagar', 1, 8, 144, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(962, 'Vallicode', 1, 3, 115, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(963, 'Vallikunnam', 1, 4, 3, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(964, 'Vallikunnu', 1, 10, 97, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(965, 'Vamanapuram', 1, 1, 130, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(966, 'Vandanmedu', 1, 6, 32, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(967, 'Vandazhi', 1, 9, 108, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(968, 'Vandiperiyar', 1, 6, 28, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(969, 'Vanimel', 1, 11, 84, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(970, 'Vaniyamkulam', 1, 9, 109, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(971, 'Vannapuram', 1, 6, 30, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(972, 'Varantharappilly', 1, 8, 139, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(973, 'Varapetty', 1, 7, 17, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(974, 'Varapuzha', 1, 7, 13, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(975, 'Varavoor', 1, 8, 148, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(976, 'Varkala', 2, 1, 0, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:27'),
(977, 'Vathikudy', 1, 6, 31, 1, '2020-06-14 03:07:27', '2020-06-14 03:07:28'),
(978, 'Vattakulam', 1, 10, 95, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(979, 'Vattavada', 1, 6, 29, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(980, 'Vayalar', 1, 4, 10, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(981, 'Vazhakkad', 1, 10, 88, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(982, 'Vazhakulam', 1, 7, 25, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(983, 'Vazhappally', 1, 5, 68, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(984, 'Vazhathope', 1, 6, 31, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(985, 'Vazhayur', 1, 10, 88, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(986, 'Vazhikadavu', 1, 10, 92, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(987, 'Vazhoor', 1, 5, 73, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(988, 'Vechoor', 1, 5, 72, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(989, 'Vechuchira', 1, 3, 121, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(990, 'Veeyapuram', 1, 4, 6, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(991, 'Velinalloor', 1, 2, 53, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(992, 'Veliyam', 1, 2, 57, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(993, 'Veliyanad', 1, 4, 12, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(994, 'Veliyankode', 1, 10, 94, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(995, 'Veliyannoor', 1, 5, 71, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(996, 'Vellamunda', 1, 12, 150, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(997, 'Vellanad', 1, 1, 132, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(998, 'Vellangallur', 1, 8, 147, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(999, 'Vellarada', 1, 1, 128, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1000, 'Vellathooval', 1, 6, 27, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1001, 'Vellavoor', 1, 5, 73, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1002, 'Vellinezhi', 1, 9, 112, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1003, 'Velliyamattam', 1, 6, 30, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1004, 'Velloor', 1, 5, 65, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1005, 'Velom', 1, 11, 79, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1006, 'Velookkara', 1, 8, 147, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1007, 'Veloor', 1, 8, 137, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1008, 'Vembayam', 1, 1, 125, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1009, 'Vengad', 1, 13, 45, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1010, 'Vengannur', 1, 1, 122, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1011, 'Vengappalli', 1, 12, 149, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1012, 'Vengara', 1, 10, 99, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:28'),
(1013, 'Vengola', 1, 7, 25, 1, '2020-06-14 03:07:28', '2020-06-14 03:07:29'),
(1014, 'Vengoor', 1, 7, 16, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1015, 'Venkitangu', 1, 8, 142, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1016, 'Venmony', 1, 4, 5, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1017, 'Vettathur', 1, 10, 93, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1018, 'Vettikkavala', 1, 2, 62, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1019, 'Vettom', 1, 10, 98, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1020, 'Vettoor', 1, 1, 131, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1021, 'Vijayapuram', 1, 5, 69, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1022, 'Vilakudy', 1, 2, 60, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1023, 'Vilappil', 1, 1, 126, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1024, 'Vilavoorkal', 1, 1, 126, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1025, 'Vilayoor', 1, 9, 111, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1026, 'Villiappalli', 1, 11, 83, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1027, 'Vithura', 1, 1, 132, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1028, 'Vorkadi', 1, 14, 50, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1029, 'Wadakkanchery', 2, 8, 0, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1030, 'Wandoor', 1, 10, 100, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1031, 'West Eleri', 1, 14, 51, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1032, 'West Kallada', 1, 2, 61, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1033, 'Yeroor', 1, 2, 52, 1, '2020-06-14 03:07:29', '2020-06-14 03:07:29'),
(1038, 'Koyilandy', 2, 11, 0, 1, NULL, NULL),
(2000, 'No Localbody', 1000, 0, 0, 0, NULL, NULL);

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

--
-- Table structure for table `localbodytypes`
--

CREATE TABLE `localbodytypes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lb_type` varchar(191) NOT NULL,
  `name_eng` varchar(191) NOT NULL,
  `is_active` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `localbodytypes`
--

INSERT INTO `localbodytypes` (`id`, `lb_type`, `name_eng`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'G', 'GRAMAPANCHAYATH', 1, NULL, NULL),
(2, 'M', 'MUNCIPALITY', 1, NULL, NULL),
(3, 'C', 'CORPORATION', 1, NULL, NULL),
(1000, 'N', 'No Local body Type', 0, NULL, NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(2, '2024_01_04_084015_create_countries_table', 1),
(3, '2024_01_04_084334_create_states_table', 1),
(4, '2024_01_04_084800_create_districts_table', 1),
(5, '2024_01_04_085232_create_blocks_table', 1),
(6, '2024_01_04_085337_create_localbodytypes_table', 1),
(7, '2024_01_04_085424_create_localbodies_table', 1),
(8, '2024_01_04_085819_create_announcements_table', 1),
(9, '2024_01_04_090234_create_sectors_table', 1),
(10, '2024_01_04_090254_create_skills_table', 1),
(11, '2024_01_04_090416_create_user_roles_table', 1),
(12, '2024_01_04_090505_create_statuses_table', 1),
(13, '2024_01_04_090951_create_users_table', 1),
(14, '2024_01_04_091018_create_program_implementation_agencies_table', 1),
(15, '2024_01_04_091039_create_pia_sectors_table', 1),
(16, '2024_01_04_091118_create_jobfairs_table', 1),
(18, '2024_01_04_094133_create_course_masters_table', 1),
(20, '2024_01_04_101404_create_course_skill_mappings_table', 1),
(21, '2024_01_04_105033_create_canadidate_interest_course_masters_table', 1),
(22, '2024_01_04_105312_create_job_vacancies_table', 1),
(23, '2024_01_04_105706_create_job_vacancy_skill_mappings_table', 1),
(24, '2024_01_04_110353_add_course_id', 1),
(25, '2024_01_05_041618_add_created_by_and_statuses', 1),
(26, '2024_01_05_044755_add_approval_status_to_users', 1),
(27, '2024_01_05_080934_update_phone_number', 1),
(28, '2024_01_04_091253_create_candidate_interests_table', 2),
(29, '2024_01_04_101138_create_courses_table', 2),
(30, '2024_01_08_083625_create_employer_details_updation_requests_table', 3),
(31, '2024_01_08_101307_add_registered_at_placed_at_user', 3),
(32, '2024_01_09_151736_add_to_users_table', 3),
(33, '2024_01_10_121939_add_employer_id_to_job_vacancies_table', 3),
(34, '2024_01_10_122809_create_employer_job_mappings_table', 3),
(36, '2024_01_17_050253_add_rejected_by', 4),
(37, '2024_01_15_084015_update_courses_table', 5),
(38, '2024_01_17_042902_create_job_applications_table', 5),
(39, '2024_01_17_100015_create_job_applications_table', 6),
(40, '2024_01_18_120520_create_reset_password_requests_table', 6),
(41, '2024_01_18_143634_update_otp_field', 6),
(42, '2024_01_24_062937_add_fields_to_job_vacancies_table', 7),
(43, '2024_01_29_030123_create_recruitments_table', 8),
(44, '2024_02_01_140338_add_code_field', 9),
(45, '2024_02_02_105827_add_fields_to_recruitments_table', 10),
(46, '2024_02_03_091443_create_notifications_table', 10),
(47, '2024_02_03_093757_add_usercandistatus_users_table', 10),
(48, '2024_02_03_093911_add_job_id', 10),
(49, '2024_02_05_080630_update_employer_id', 10),
(50, '2024_02_05_081120_add_employer_id', 10),
(51, '2024_02_08_072157_add_through_candidate_status_to_recruitments_table', 11),
(56, '2024_02_13_154355_add_placed_at_to_job_applications_table', 12),
(57, '2024_10_17_165641_create_pia_trades_table', 13),
(58, '2024_02_20_213823_add_remarks_to_recruitments_table', 14),
(59, '2024_01_12_034911_create_recruitments_table', 15),
(60, '2024_10_22_110417_add_course_assigned_location_to_program_implementation_agencies_and_users_tables', 15),
(61, '2024_10_22_115052_add_cover_area_prefered_location_to_users_table_and_employer_details_updation_requests', 16),
(62, '2024_10_23_101708_add_qualification_description_to_course_masters_table', 17),
(63, '2024_10_28_181812_add_training_location_to_courses_table', 18);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(30) NOT NULL,
  `description` longtext NOT NULL,
  `job_application_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `notification_type` varchar(30) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `seen_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pia_sectors`
--

CREATE TABLE `pia_sectors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `program_implementation_agency_id` bigint(20) UNSIGNED NOT NULL,
  `sector_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pia_trades`
--

CREATE TABLE `pia_trades` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pia_id` bigint(20) UNSIGNED NOT NULL,
  `sector_id` bigint(20) UNSIGNED NOT NULL,
  `trade_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `program_implementation_agencies`
--

CREATE TABLE `program_implementation_agencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `agency_name` varchar(191) NOT NULL,
  `building_number` varchar(191) NOT NULL,
  `street_name` varchar(191) NOT NULL,
  `district_id` bigint(20) UNSIGNED NOT NULL,
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `post_office` varchar(191) NOT NULL,
  `pincode` varchar(6) NOT NULL,
  `mobile_number` varchar(191) NOT NULL,
  `phone_number` varchar(191) DEFAULT NULL,
  `pan_number` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_assigned_location` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `recruitments`
--

CREATE TABLE `recruitments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `selected_date` timestamp NULL DEFAULT NULL,
  `mobile_number` varchar(191) DEFAULT NULL,
  `msg_to_candidate` text DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `salary` varchar(191) DEFAULT NULL,
  `if_foreign` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `recruitment_status` int(11) DEFAULT 1,
  `if_selected` int(11) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `through_candidate` bigint(20) DEFAULT NULL,
  `remarks` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sectors`
--

CREATE TABLE `sectors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sectors`
--

INSERT INTO `sectors` (`id`, `name`, `is_active`, `created_at`, `updated_at`, `code`) VALUES
(1, 'Aerospace & Aviation', 1, NULL, NULL, ''),
(2, 'Apparel, Made-Ups & Home Furnishing', 1, NULL, NULL, ''),
(3, 'Apparel', 1, NULL, NULL, ''),
(4, 'Automotive', 1, NULL, NULL, ''),
(5, 'Banking, Financial Services and Insurance (BFSI)', 1, NULL, NULL, ''),
(6, 'Beauty & Wellness', 1, NULL, NULL, ''),
(7, 'Construction', 1, NULL, NULL, ''),
(8, 'Rubber', 1, NULL, NULL, ''),
(9, 'Chemicals & Petrochemicals', 1, NULL, NULL, ''),
(10, 'Capital Goods', 1, NULL, NULL, ''),
(11, 'Domestic Worker', 1, NULL, NULL, ''),
(12, 'Electronics & Hardware', 1, NULL, NULL, ''),
(13, 'Electronics', 1, NULL, NULL, ''),
(14, 'Food Processing', 1, NULL, NULL, ''),
(15, 'Gems & Jewellery', 1, NULL, NULL, ''),
(16, 'Healthcare', 1, NULL, NULL, ''),
(17, 'Management - Security', 1, NULL, NULL, ''),
(18, 'Instrumentation, Automation, Surveillance and Communication', 1, NULL, NULL, ''),
(19, 'Infrastructure Equipment', 1, NULL, NULL, ''),
(20, 'Life Sciences', 1, NULL, NULL, ''),
(21, 'Logistics', 1, NULL, NULL, ''),
(22, 'Management and Entrepreneurship & Professional', 1, NULL, NULL, ''),
(23, 'Media & Entertainment', 1, NULL, NULL, ''),
(24, 'Power', 1, NULL, NULL, ''),
(25, 'Retail', 1, NULL, NULL, ''),
(26, 'IT-ITES', 1, NULL, NULL, ''),
(27, 'Telecom', 1, NULL, NULL, ''),
(28, 'Tourism & Hospitality', 1, NULL, NULL, ''),
(29, 'IT', 1, '2024-02-05 01:25:02', '2024-02-05 01:25:02', 'IT0'),
(30, 'Mason & Plumbing', 1, '2024-06-19 11:37:15', '2024-06-19 11:37:15', 'M22');

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

--
-- Table structure for table `skills`
--

CREATE TABLE `skills` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skills`
--

INSERT INTO `skills` (`id`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Social Media Marketing', 1, NULL, NULL),
(2, 'Customer service', 1, NULL, NULL),
(3, 'Safety Practices', 1, NULL, NULL),
(4, 'Network installation', 1, NULL, NULL),
(5, 'Document Sharing', 1, NULL, NULL),
(6, 'Customer service', 1, NULL, NULL),
(7, 'Data Infrastructure Design', 1, NULL, NULL),
(8, 'Configuration and Troubleshooting', 1, NULL, NULL),
(9, 'Content Marketing ', 1, NULL, NULL),
(10, 'Safety & Emergency Procedures', 1, NULL, NULL),
(11, 'Customer service', 1, NULL, NULL),
(12, 'Cabiling & wiring ', 1, NULL, NULL),
(13, 'Design Thinking', 1, NULL, NULL),
(14, 'Inspection Methods', 1, NULL, NULL),
(15, 'Data modelling', 1, NULL, NULL),
(16, 'Camera Installation', 1, NULL, NULL),
(17, 'Digital Advertising', 1, NULL, NULL),
(18, 'Incident Management', 1, NULL, NULL),
(19, 'Mechanical Components & Systems', 1, NULL, NULL),
(20, 'Customer support', 1, NULL, NULL),
(21, 'Food Safety Protocols and Regulations', 1, NULL, NULL),
(22, 'Cloud Platforms', 1, NULL, NULL),
(23, 'CCTV Maintenance', 1, NULL, NULL),
(24, 'Cabling and Wiring Techniques', 1, NULL, NULL),
(25, 'Data Processing', 1, NULL, NULL),
(26, 'Equipment Configuration', 1, NULL, NULL),
(27, 'Team work ', 1, NULL, NULL),
(28, 'C#', 1, '2024-02-02 00:39:12', '2024-02-02 00:43:37'),
(29, 'Adaptability', 1, '2024-03-04 06:53:58', '2024-03-04 06:53:58'),
(30, 'Python', 1, '2024-03-04 07:11:29', '2024-03-04 07:11:29'),
(31, 'Effective learning', 1, '2024-03-13 04:59:48', '2024-03-13 04:59:48');

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`, `country_id`, `is_active`, `created_at`, `updated_at`) VALUES
(32, 'Kerala', 1, 1, NULL, NULL),
(1000, 'No state', 1, 1, NULL, NULL);

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

--
-- Table structure for table `statuses`
--

CREATE TABLE `statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, 'Active', NULL, NULL, NULL),
(2, 'Joined', NULL, NULL, NULL),
(3, 'Completed', NULL, NULL, NULL),
(4, 'Open to Work', NULL, NULL, NULL),
(5, 'Placed', NULL, NULL, NULL),
(6, 'Discontinued', NULL, NULL, NULL),
(7, 'In Progress', NULL, NULL, NULL),
(8, 'Soft Delete', NULL, NULL, NULL),
(9, 'Cancelled', NULL, NULL, NULL),
(10, 'Postponed', NULL, NULL, NULL),
(11, 'Inactive', NULL, NULL, NULL),
(12, 'Through web', NULL, NULL, NULL),
(13, 'Through PIA', NULL, NULL, NULL),
(14, 'New Employer', NULL, NULL, NULL),
(15, 'Shortlist(ed)', NULL, NULL, NULL),
(16, 'Resigned', NULL, NULL, NULL),
(17, 'Terminated', NULL, NULL, NULL),
(18, 'Rejected', NULL, NULL, NULL),
(19, 'Through Candidate', NULL, NULL, NULL),
(20, 'Direct Employer Placement', NULL, NULL, NULL),
(21, 'PIA Placed', NULL, NULL, NULL),
(22, 'Course Pending', NULL, NULL, NULL),
(23, 'Featured', NULL, NULL, NULL);

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role` varchar(191) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`id`, `role`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Super admin', 1, '2024-01-03 15:58:30', '2024-01-03 15:58:30'),
(2, 'District admin', 1, '2024-01-03 15:58:30', '2024-01-03 15:58:30'),
(3, 'Block admin', 1, '2024-01-03 15:58:30', '2024-01-03 15:58:30'),
(4, 'PIA', 1, '2024-01-03 15:58:30', '2024-01-03 15:58:30'),
(5, 'Employer', 1, '2024-01-03 15:58:30', '2024-01-03 15:58:30'),
(6, 'Candidates', 1, '2024-01-03 15:58:30', '2024-01-03 15:58:30');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blocks`
--
ALTER TABLE `blocks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `canadidate_interest_course_masters`
--
ALTER TABLE `canadidate_interest_course_masters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `canadidate_interest_course_masters_course_master_id_foreign` (`course_master_id`),
  ADD KEY `canadidate_interest_course_masters_candidate_interest_id_foreign` (`candidate_interest_id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `courses_sector_id_foreign` (`sector_id`),
  ADD KEY `courses_pia_id_foreign` (`pia_id`),
  ADD KEY `courses_district_id_foreign` (`district_id`),
  ADD KEY `courses_block_id_foreign` (`block_id`),
  ADD KEY `courses_localbody_id_foreign` (`localbody_id`),
  ADD KEY `courses_localbodytype_id_foreign` (`localbodytype_id`),
  ADD KEY `courses_coursemaster_id_foreign` (`coursemaster_id`);

--
-- Indexes for table `course_masters`
--
ALTER TABLE `course_masters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `course_masters_sector_id_foreign` (`sector_id`);

--
-- Indexes for table `course_skill_mappings`
--
ALTER TABLE `course_skill_mappings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `course_skill_mappings_course_id_foreign` (`course_id`),
  ADD KEY `course_skill_mappings_skill_id_foreign` (`skill_id`);

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_state_id_foreign` (`state_id`);

--
-- Indexes for table `employer_details_updation_requests`
--
ALTER TABLE `employer_details_updation_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employer_details_updation_requests_employer_id_foreign` (`employer_id`),
  ADD KEY `employer_details_updation_requests_country_id_foreign` (`country_id`),
  ADD KEY `employer_details_updation_requests_state_id_foreign` (`state_id`),
  ADD KEY `employer_details_updation_requests_district_id_foreign` (`district_id`),
  ADD KEY `employer_details_updation_requests_processed_by_foreign` (`processed_by`),
  ADD KEY `employer_details_updation_requests_created_by_foreign` (`created_by`);

--
-- Indexes for table `employer_job_mappings`
--
ALTER TABLE `employer_job_mappings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employer_job_mappings_employer_id_foreign` (`employer_id`);

--
-- Indexes for table `jobfairs`
--
ALTER TABLE `jobfairs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `job_applications`
--
ALTER TABLE `job_applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_applications_job_id_foreign` (`job_id`),
  ADD KEY `job_applications_candidate_id_foreign` (`candidate_id`),
  ADD KEY `job_applications_created_by_foreign` (`created_by`),
  ADD KEY `job_applications_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `job_vacancies`
--
ALTER TABLE `job_vacancies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_vacancies_employer_id_foreign` (`employer_id`);

--
-- Indexes for table `job_vacancy_skill_mappings`
--
ALTER TABLE `job_vacancy_skill_mappings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_vacancy_skill_mappings_skill_id_foreign` (`skill_id`);

--
-- Indexes for table `localbodies`
--
ALTER TABLE `localbodies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `localbodies_lb_type_id_foreign` (`lb_type_id`),
  ADD KEY `localbodies_district_id_foreign` (`district_id`),
  ADD KEY `localbodies_block_id_foreign` (`block_id`);

--
-- Indexes for table `localbodytypes`
--
ALTER TABLE `localbodytypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_job_application_id_foreign` (`job_application_id`),
  ADD KEY `notifications_candidate_id_foreign` (`candidate_id`),
  ADD KEY `notifications_job_id_foreign` (`job_id`);

--
-- Indexes for table `pia_sectors`
--
ALTER TABLE `pia_sectors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pia_sectors_program_implementation_agency_id_foreign` (`program_implementation_agency_id`),
  ADD KEY `pia_sectors_sector_id_foreign` (`sector_id`);

--
-- Indexes for table `pia_trades`
--
ALTER TABLE `pia_trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pia_trades_pia_id_foreign` (`pia_id`),
  ADD KEY `pia_trades_sector_id_foreign` (`sector_id`),
  ADD KEY `pia_trades_trade_id_foreign` (`trade_id`);

--
-- Indexes for table `program_implementation_agencies`
--
ALTER TABLE `program_implementation_agencies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `program_implementation_agencies_district_id_foreign` (`district_id`),
  ADD KEY `program_implementation_agencies_state_id_foreign` (`state_id`),
  ADD KEY `program_implementation_agencies_user_id_foreign` (`user_id`),
  ADD KEY `program_implementation_agencies_created_by_foreign` (`created_by`),
  ADD KEY `program_implementation_agencies_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `recruitments`
--
ALTER TABLE `recruitments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `recruitments_employer_id_foreign` (`employer_id`),
  ADD KEY `recruitments_candidate_id_foreign` (`candidate_id`),
  ADD KEY `recruitments_job_id_foreign` (`job_id`),
  ADD KEY `recruitments_created_by_foreign` (`created_by`);

--
-- Indexes for table `sectors`
--
ALTER TABLE `sectors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `skills`
--
ALTER TABLE `skills`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `states_country_id_foreign` (`country_id`);

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `announcements`
--
ALTER TABLE `announcements`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blocks`
--
ALTER TABLE `blocks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;

--
-- AUTO_INCREMENT for table `canadidate_interest_course_masters`
--
ALTER TABLE `canadidate_interest_course_masters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `course_masters`
--
ALTER TABLE `course_masters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `course_skill_mappings`
--
ALTER TABLE `course_skill_mappings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;

--
-- AUTO_INCREMENT for table `employer_details_updation_requests`
--
ALTER TABLE `employer_details_updation_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employer_job_mappings`
--
ALTER TABLE `employer_job_mappings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobfairs`
--
ALTER TABLE `jobfairs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_applications`
--
ALTER TABLE `job_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_vacancies`
--
ALTER TABLE `job_vacancies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `job_vacancy_skill_mappings`
--
ALTER TABLE `job_vacancy_skill_mappings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;

--
-- AUTO_INCREMENT for table `localbodies`
--
ALTER TABLE `localbodies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2001;

--
-- AUTO_INCREMENT for table `localbodytypes`
--
ALTER TABLE `localbodytypes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `pia_sectors`
--
ALTER TABLE `pia_sectors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pia_trades`
--
ALTER TABLE `pia_trades`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `program_implementation_agencies`
--
ALTER TABLE `program_implementation_agencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `recruitments`
--
ALTER TABLE `recruitments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sectors`
--
ALTER TABLE `sectors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `skills`
--
ALTER TABLE `skills`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;

--
-- AUTO_INCREMENT for table `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `user_roles`
--
ALTER TABLE `user_roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `canadidate_interest_course_masters`
--
ALTER TABLE `canadidate_interest_course_masters`
  ADD CONSTRAINT `canadidate_interest_course_masters_candidate_interest_id_foreign` FOREIGN KEY (`candidate_interest_id`) REFERENCES `candidate_interests` (`id`),
  ADD CONSTRAINT `canadidate_interest_course_masters_course_master_id_foreign` FOREIGN KEY (`course_master_id`) REFERENCES `course_masters` (`id`);

--
-- Constraints for table `course_masters`
--
ALTER TABLE `course_masters`
  ADD CONSTRAINT `course_masters_sector_id_foreign` FOREIGN KEY (`sector_id`) REFERENCES `sectors` (`id`);
COMMIT;

