text: -- phpMyAdmin SQL Dump
  -- version 4.8.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Sep 02, 2018 at 10:34 PM
  -- Server version: 10.1.34-MariaDB
  -- PHP Version: 7.2.7
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `ngo`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin`
  --
  
  CREATE TABLE `admin` (
    `id` int(11) NOT NULL,
    `username` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `contact` varchar(255) NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `admin`
  --
  
  INSERT INTO `admin` (`id`, `username`, `password`, `email`, `contact`, `status`) VALUES
  (1, 'dhyey', 'admin123', 'admin@admin.com', '9967313968', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `answers`
  --
  
  CREATE TABLE `answers` (
    `id` int(11) NOT NULL,
    `fk_question_id` int(11) NOT NULL,
    `fk_admin_id` int(11) NOT NULL,
    `answer` text NOT NULL,
    `created_date` datetime NOT NULL,
    `updated_by` int(11) NOT NULL,
    `updated_date` datetime NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `answers`
  --
  
  INSERT INTO `answers` (`id`, `fk_question_id`, `fk_admin_id`, `answer`, `created_date`, `updated_by`, `updated_date`) VALUES
  (21, 4, 1, 'hgghjg', '2018-06-29 23:27:42', 0, '0000-00-00 00:00:00'),
  (22, 4, 1, 'NEER MALAD', '2018-07-20 13:37:50', 0, '0000-00-00 00:00:00'),
  (23, 5, 1, 'fine', '2018-07-20 13:38:39', 0, '0000-00-00 00:00:00'),
  (24, 4, 1, 'Nice blog', '2018-07-21 12:47:20', 0, '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blog`
  --
  
  CREATE TABLE `blog` (
    `id` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `description` text NOT NULL,
    `image` varchar(255) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `tags` varchar(255) NOT NULL,
    `created_date` datetime NOT NULL,
    `created_by` int(11) NOT NULL,
    `comment_count` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `blog`
  --
  
  INSERT INTO `blog` (`id`, `title`, `description`, `image`, `status`, `tags`, `created_date`, `created_by`, `comment_count`) VALUES
  (1, 'Great pleasure to take a trivial example which of us undertakes laborious soprt the orgnization.\n', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Vivamus ac leo pretium faucibus. Vivamus luctus egestas leo. Nullam rhoncus aliquam metus. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sagittis hendrerit ante. Vivamus luctus egestas leo. Fusce tellus odio, dapibus id fermentum quis, suscipit id erat. Nullam sit amet magna in magna gravida vehicula. Morbi leo mi, nonummy eget tristique non, rhoncus non leo. Morbi scelerisque luctus velit. Etiam neque. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Etiam posuere lacus quis dolor.\r\n\r\nDonec quis nibh at felis congue commodo. Aenean placerat. Vivamus luctus egestas leo. Praesent vitae arcu tempor neque lacinia pretium. Phasellus et lorem id felis nonummy placerat. Nullam justo enim, consectetuer nec, ullamcorper ac, vestibulum in, elit. Sed elit dui, pellentesque a, faucibus vel, interdum nec, diam. Nunc tincidunt ante vitae massa. Nulla accumsan, elit sit amet varius semper, nulla mauris mollis quam, tempor suscipit diam nulla vel leo. Nulla non lectus sed nisl molestie malesuada. Pellentesque pretium lectus id turpis. Vestibulum erat nulla, ullamcorper nec, rutrum non, nonummy ac, erat. Etiam ligula pede, sagittis quis, interdum ultricies, scelerisque eu. Nullam faucibus mi quis velit. Integer imperdiet lectus quis justo. Etiam dui sem, fermentum vitae, sagittis id, malesuada in, quam. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam eget nisl. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.\r\n\r\nCurabitur bibendum justo non orci. Phasellus et lorem id felis nonummy placerat. Pellentesque sapien. Etiam egestas wisi a erat. Donec iaculis gravida nulla. Cras pede libero, dapibus nec, pretium sit amet, tempor quis. Mauris metus. Mauris dictum facilisis augue. Morbi leo mi, nonummy eget tristique non, rhoncus non leo. Etiam commodo dui eget wisi. In sem justo, commodo ut, suscipit at, pharetra vitae, orci. Etiam neque. In sem justo, commodo ut, suscipit at, pharetra vitae, orci. Duis viverra diam non justo. Etiam quis quam.', '1970779582b49e43dee94a28b44b1d53.jpg', 1, 'test , hello , new tag , rocks', '2018-07-02 23:01:29', 1, 0),
  (2, 'Generated 5 paragraphs of Lorem ipsum', 'Curabitur bibendum justo non orci. Phasellus et lorem id felis nonummy placerat. Pellentesque sapien. Etiam egestas wisi a erat. Donec iaculis gravida nulla. Cras pede libero, dapibus nec, pretium sit amet, tempor quis. Mauris metus. Mauris dictum facilisis augue. Morbi leo mi, nonummy eget tristique non, rhoncus non leo. Etiam commodo dui eget wisi. In sem justo, commodo ut, suscipit at, pharetra vitae, orci. Etiam neque. In sem justo, commodo ut, suscipit at, pharetra vitae, orci. Duis viverra diam non justo. Etiam quis quam.\r\n\r\nPraesent vitae arcu tempor neque lacinia pretium. Nullam sapien sem, ornare ac, nonummy non, lobortis a enim. Nullam lectus justo, vulputate eget mollis sed, tempor sed magna. In laoreet, magna id viverra tincidunt, sem odio bibendum justo, vel imperdiet sapien wisi sed libero. Nulla non arcu lacinia neque faucibus fringilla. Fusce wisi. Suspendisse nisl. Praesent id justo in neque elementum ultrices. Aliquam id dolor. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Nullam sapien sem, ornare ac, nonummy non, lobortis a enim. Aliquam erat volutpat. Maecenas sollicitudin. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Aliquam id dolor. Maecenas lorem. Aenean fermentum risus id tortor. Pellentesque pretium lectus id turpis. Cras pede libero, dapibus nec, pretium sit amet, tempor quis.\r\n\r\nEtiam neque. Donec iaculis gravida nulla. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quis nibh at felis congue commodo. Integer in sapien. Cras pede libero, dapibus nec, pretium sit amet, tempor quis. Nulla turpis magna, cursus sit amet, suscipit a, interdum id, felis. Vestibulum erat nulla, ullamcorper nec, rutrum non, nonummy ac, erat. Integer lacinia. Duis bibendum, lectus ut viverra rhoncus, dolor nunc faucibus libero, eget facilisis enim ipsum id lacus. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quisque porta. Mauris tincidunt sem sed arcu. Maecenas lorem. Sed vel lectus. Donec odio tempus molestie, porttitor ut, iaculis quis, sem. Vivamus luctus egestas leo. Etiam sapien elit, consequat eget, tristique non, venenatis quis, ante. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Fusce nibh. Phasellus faucibus molestie nisl.', '20fb0b8956e4a00e856fe582ef637b1d.jpg', 1, 'new , hack , love , row  , view  ', '2018-06-13 23:02:45', 1, 0),
  (3, 'Generate Lorem ipsum', 'Maecenas fermentum, sem in pharetra pellentesque, velit turpis volutpat ante, in pharetra metus odio a lectus. Nam sed tellus id magna elementum tincidunt. Mauris elementum mauris vitae tortor. Aliquam id dolor. Curabitur bibendum justo non orci. Aliquam erat volutpat. Aliquam ante. Mauris dolor felis, sagittis at, luctus sed, aliquam non, tellus. Etiam dui sem, fermentum vitae, sagittis id, malesuada in, quam. Integer lacinia. Morbi scelerisque luctus velit. Mauris tincidunt sem sed arcu. Proin pede metus, vulputate nec, fermentum fringilla, vehicula vitae, justo. Aenean vel massa quis mauris vehicula lacinia. Etiam neque. Etiam quis quam. Proin mattis lacinia justo. Nam sed tellus id magna elementum tincidunt. Integer pellentesque quam vel velit.\r\n\r\nDuis risus. Phasellus faucibus molestie nisl. In laoreet, magna id viverra tincidunt, sem odio bibendum justo, vel imperdiet sapien wisi sed libero. Suspendisse nisl. Duis viverra diam non justo. Suspendisse sagittis ultrices augue. Donec iaculis gravida nulla. Etiam sapien elit, consequat eget, tristique non, venenatis quis, ante. Mauris metus. Nulla turpis magna, cursus sit amet, suscipit a, interdum id, felis. Sed ac dolor sit amet purus malesuada congue. Sed convallis magna eu sem. Aliquam erat volutpat. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.\r\n\r\nInteger malesuada. Integer lacinia. Nullam feugiat, turpis at pulvinar vulputate, erat libero tristique tellus, nec bibendum odio risus sit amet ante. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Nam quis nulla. Etiam ligula pede, sagittis quis, interdum ultricies, scelerisque eu. Integer in sapien. Duis sapien nunc, commodo et, interdum suscipit, sollicitudin et, dolor. Aliquam ante. Morbi leo mi, nonummy eget tristique non, rhoncus non leo. Curabitur sagittis hendrerit ante.\r\n\r\nSed ac dolor sit amet purus malesuada congue. Fusce wisi. Phasellus rhoncus. Fusce aliquam vestibulum ipsum. Aenean vel massa quis mauris vehicula lacinia. Aliquam erat volutpat. Aliquam id dolor. Pellentesque sapien. Praesent in mauris eu tortor porttitor accumsan. Integer malesuada.', '8cbecd350f58806209df4688116ee8c9.jpg', 1, 'blog_3 , hack , love rock , view', '2018-07-02 23:04:07', 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blog_comments`
  --
  
  CREATE TABLE `blog_comments` (
    `id` int(11) NOT NULL,
    `fk_blog_id` int(11) NOT NULL,
    `comments` text NOT NULL,
    `user_id` int(11) NOT NULL,
    `created_by` int(11) NOT NULL,
    `created_date` datetime NOT NULL,
    `updated_by` int(11) NOT NULL,
    `updated_date` datetime NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `blog_comments`
  --
  
  INSERT INTO `blog_comments` (`id`, `fk_blog_id`, `comments`, `user_id`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
  (1, 2, 'HEllo', 35, 35, '2018-07-17 13:04:12', 0, '0000-00-00 00:00:00'),
  (2, 2, 'heyA...', 35, 35, '2018-07-17 13:07:38', 0, '0000-00-00 00:00:00'),
  (3, 4, 'SADASDD', 35, 35, '2018-07-17 13:08:14', 0, '0000-00-00 00:00:00'),
  (4, 4, 'sdsadadsad', 35, 35, '2018-07-17 13:11:23', 0, '0000-00-00 00:00:00'),
  (5, 2, 'asdsa dsa dsd sa dsad as dsa dsa dsa dsa', 35, 35, '2018-07-17 13:28:44', 0, '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `category`
  --
  
  CREATE TABLE `category` (
    `id` int(11) NOT NULL,
    `category_name` varchar(255) NOT NULL,
    `created_by` int(11) NOT NULL,
    `created_date` datetime NOT NULL,
    `updated_by` int(11) NOT NULL,
    `updated_date` datetime NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `category`
  --
  
  INSERT INTO `category` (`id`, `category_name`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
  (1, 'category_one', 1, '2018-06-15 00:00:00', 1, '2018-06-15 00:00:00'),
  (2, 'category_two', 1, '2018-06-15 00:00:00', 1, '2018-06-15 00:00:00'),
  (3, 'category_three', 1, '2018-06-15 00:00:00', 1, '2018-06-15 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cities`
  --
  
  CREATE TABLE `cities` (
    `city_id` int(11) NOT NULL,
    `city_name` varchar(50) DEFAULT NULL,
    `state_id` int(11) DEFAULT NULL,
    `status` int(1) DEFAULT NULL,
    `country_id` int(5) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `cities`
  --
  
  INSERT INTO `cities` (`city_id`, `city_name`, `state_id`, `status`, `country_id`) VALUES
  (54, 'Chittoor', 2, 1, 101),
  (90, 'Guntur', 2, 1, 101),
  (133, 'Kurnool', 2, 1, 101),
  (176, 'Nellore', 2, 1, 101),
  (190, 'Panjim', 2, 1, 101),
  (243, 'Sirpur', 2, 1, 101),
  (266, 'Tirupati', 2, 1, 101),
  (285, 'Vijayawada', 2, 1, 101),
  (287, 'Visakhapatnam', 2, 1, 101),
  (371, 'Guwahati', 4, 1, 101),
  (453, 'Aurangabad', 5, 1, 101),
  (465, 'Bariapur', 5, 1, 101),
  (500, 'Gazipur', 5, 1, 101),
  (510, 'Islampur', 5, 1, 101),
  (553, 'Muzaffarpur', 5, 1, 101),
  (563, 'Patna', 5, 1, 101),
  (579, 'Shahpur', 5, 1, 101),
  (606, 'Banarsi', 7, 1, 101),
  (706, 'Delhi', 10, 1, 101),
  (707, 'New Delhi', 10, 1, 101),
  (733, 'Goa', 11, 1, 101),
  (742, 'Margao', 11, 1, 101),
  (749, 'Panaji', 11, 1, 101),
  (756, 'Ponda', 11, 1, 101),
  (783, 'Ahmedabad', 12, 1, 101),
  (790, 'Amroli', 12, 1, 101),
  (795, 'Ankleshwar', 12, 1, 101),
  (796, 'Anklesvar INA', 12, 1, 101),
  (824, 'Bhuj', 12, 1, 101),
  (872, 'Dhoraji', 12, 1, 101),
  (882, 'Dwarka', 12, 1, 101),
  (888, 'Gandhinagar', 12, 1, 101),
  (905, 'Jamnagar', 12, 1, 101),
  (912, 'Junagadh', 12, 1, 101),
  (931, 'Keshod', 12, 1, 101),
  (934, 'Khambhat', 12, 1, 101),
  (974, 'Morbi', 12, 1, 101),
  (986, 'Navsari', 12, 1, 101),
  (993, 'Palanpur', 12, 1, 101),
  (1007, 'Porbandar', 12, 1, 101),
  (1011, 'Rajkot', 12, 1, 101),
  (1041, 'Surat', 12, 1, 101),
  (1075, 'Chandigarh', 12, 1, 101),
  (1122, 'Firozpur Jhirka', 13, 1, 101),
  (1126, 'Gurgaon', 13, 1, 101),
  (1168, 'Panipat', 13, 1, 101),
  (1236, 'Kulu', 14, 1, 101),
  (1237, 'Manali', 14, 1, 101),
  (1248, 'Palampur', 14, 1, 101),
  (1262, 'Shimla', 14, 1, 101),
  (1303, 'Jammu', 15, 1, 101),
  (1305, 'Jammu Tawi', 15, 1, 101),
  (1327, 'Pattan', 15, 1, 101),
  (1425, 'Jamshedpur', 16, 1, 101),
  (1492, 'Ranchi', 16, 1, 101),
  (1554, 'Belluru', 17, 1, 101),
  (1558, 'Bangalore', 17, 1, 101),
  (1725, 'Mangalore', 17, 1, 101),
  (1750, 'Mysore', 17, 1, 101),
  (1930, 'Kochi', 19, 1, 101),
  (2109, 'Balaghat', 21, 1, 101),
  (2145, 'Bhopal', 21, 1, 101),
  (2229, 'Indore', 21, 1, 101),
  (2232, 'Jabalpur', 21, 1, 101),
  (2499, 'Aurangabad', 22, 1, 101),
  (2529, 'Buldhana', 22, 1, 101),
  (2674, 'Mahabaleshwar', 22, 1, 101),
  (2707, 'Mumbai', 22, 1, 101),
  (2715, 'Nagpur', 22, 1, 101),
  (2724, 'Nashik', 22, 1, 101),
  (2726, 'Navi Mumbai', 22, 1, 101),
  (2763, 'Pune', 22, 1, 101),
  (2995, 'Bhubaneswar', 29, 1, 101),
  (3124, 'Pondicherry', 31, 1, 101),
  (3197, 'Hariana', 32, 1, 101),
  (3203, 'Jalandhar', 32, 1, 101),
  (3378, 'Jaipur', 33, 1, 101),
  (3532, 'Udaipur', 33, 1, 101),
  (3540, 'Gangtok', 34, 1, 101),
  (3659, 'Chennai', 35, 1, 101),
  (3683, 'Coimbatore', 35, 1, 101),
  (3925, 'Manali', 35, 1, 101),
  (4318, 'Tirukkattuppalli', 35, 1, 101),
  (4460, 'Hyderabad', 36, 1, 101),
  (4536, 'Agra', 38, 1, 101),
  (4546, 'Allahabad', 38, 1, 101),
  (4861, 'Kanpur', 38, 1, 101),
  (4933, 'Lucknow', 38, 1, 101),
  (5022, 'Noida', 38, 1, 101),
  (5211, 'Varanasi', 38, 1, 101),
  (5304, 'Srinagar', 39, 1, 101),
  (5335, 'Aurangabad', 41, 1, 101),
  (5443, 'Darjiling', 41, 1, 101),
  (5583, 'Kolkata', 41, 1, 101),
  (5708, 'Simla', 41, 1, 101),
  (5749, 'Amritsar', 2728, 1, 166),
  (5812, 'Hariana', 2728, 1, 166),
  (5818, 'Jalandhar', 2728, 1, 166),
  (6486, 'Resistencia', 210, 1, 12),
  (6488, 'Puerto Madryn', 211, 1, 14),
  (6490, 'Trelew', 211, 1, 16),
  (6493, 'Cordoba', 212, 1, 19),
  (6494, 'Rio Cuarto', 212, 1, 20),
  (6495, 'Rio Tercero', 212, 1, 21),
  (6496, 'San Francisco', 212, 1, 22),
  (6497, 'Villa Carlos Paz', 212, 1, 23),
  (6498, 'Villa Maria', 212, 1, 24),
  (6501, 'Mercedes', 213, 1, 27),
  (6502, 'San Lorenzo', 213, 1, 28),
  (6503, 'Formosa', 216, 1, 29),
  (6508, 'Lujan', 220, 1, 34),
  (6509, 'Mendoza', 220, 1, 35),
  (6513, 'Eldorado', 221, 1, 39),
  (6515, 'Posadas', 221, 1, 41),
  (6517, 'Neuquen', 222, 1, 43),
  (6518, 'Salta', 224, 1, 44),
  (6519, 'San Ramon de la Nueva Oran', 224, 1, 45),
  (6843, 'Maria Rain', 281, 1, 14),
  (6847, 'Bad Sankt Leonhard', 282, 1, 14),
  (6868, 'Adelaide', 282, 1, 14),
  (6871, 'Wolfsberg', 282, 1, 14),
  (6874, 'Baden', 285, 1, 14),
  (6887, 'sydney', 285, 1, 14),
  (6899, 'Klosterneuburg', 285, 1, 14),
  (6902, 'Perth', 285, 1, 14),
  (6911, 'Melk', 285, 1, 14),
  (6913, 'Goldcoast', 285, 1, 14),
  (6927, 'Sankt Andra-Wordern', 285, 1, 14),
  (6929, 'Sankt Polten', 285, 1, 14),
  (6936, 'Stockerau', 285, 1, 14),
  (6941, 'Tulln', 285, 1, 14),
  (6944, 'Wiener Neudorf', 285, 1, 14),
  (6945, 'Wiener Neustadt', 285, 1, 14),
  (6952, 'Zwettl', 285, 1, 14),
  (6963, 'Bad Ischl', 286, 1, 14),
  (6964, 'Brisbane', 286, 1, 14),
  (6985, 'Leonding', 286, 1, 14),
  (6990, 'Mauthausen', 286, 1, 14),
  (7010, 'Schwertberg', 286, 1, 14),
  (7014, 'Steyr', 286, 1, 14),
  (7023, 'Wels', 286, 1, 14),
  (7037, 'Canberra', 287, 1, 14),
  (7038, 'Hallwang', 287, 1, 14),
  (7049, 'Saalfelden', 287, 1, 14),
  (7060, 'Zell am See', 287, 1, 14),
  (7066, 'Newcastle', 289, 1, 14),
  (7086, 'Leoben', 289, 1, 14),
  (7097, 'Melbourne', 289, 1, 14),
  (7108, 'Imst', 291, 1, 14),
  (7113, 'Kitzbuhel', 291, 1, 14),
  (7115, 'Kufstein', 291, 1, 14),
  (7122, 'Sankt Johann in Tirol', 291, 1, 14),
  (7124, 'Schwaz', 291, 1, 14),
  (7126, 'Telfs', 291, 1, 14),
  (7137, 'Dornbirn', 293, 1, 14),
  (7138, 'Feldkirch', 293, 1, 14),
  (7155, 'Wolfurt', 293, 1, 14),
  (7156, 'Vienna', 294, 1, 14),
  (7266, 'Barisal', 340, 1, 18),
  (7277, 'Chandpur', 344, 1, 18),
  (7291, 'Dhaka', 348, 1, 18),
  (7302, 'Feni', 351, 1, 18),
  (7304, 'Gazipur', 353, 1, 18),
  (7306, 'Gopalganj', 354, 1, 18),
  (7310, 'Jamalpur', 357, 1, 18),
  (7319, 'Kotchandpur', 360, 1, 18),
  (7324, 'Khulna', 362, 1, 18),
  (7326, 'Bajitpur', 363, 1, 18),
  (7327, 'Bhairab Bazar', 363, 1, 18),
  (7349, 'Muktagachha', 372, 1, 18),
  (7350, 'Trishal', 372, 1, 18),
  (7356, 'Narayanganj', 378, 1, 18),
  (7357, 'Rupganj', 378, 1, 18),
  (7376, 'Pabna', 386, 1, 18),
  (7380, 'Mathbaria', 389, 1, 18),
  (7381, 'Nesarabad', 389, 1, 18),
  (7385, 'Rajshahi', 391, 1, 18),
  (7390, 'Rangpur', 393, 1, 18),
  (7397, 'Sirajganj', 398, 1, 18),
  (7398, 'Chhatak', 399, 1, 18),
  (7399, 'Sunamganj', 399, 1, 18),
  (7400, 'Gopalpur', 400, 1, 18),
  (7403, 'Tangayal', 400, 1, 18),
  (7406, 'Baranavichy', 413, 1, 20),
  (7409, 'Brest', 413, 1, 20),
  (7414, 'Ivanava', 413, 1, 20),
  (7415, 'Kamjenec', 413, 1, 20),
  (7416, 'Kobryn', 413, 1, 20),
  (7417, 'Kosava', 413, 1, 20),
  (7419, 'Luninjec', 413, 1, 20),
  (7429, 'Dobrush', 414, 1, 20),
  (7439, 'Rechyca', 414, 1, 20),
  (7443, 'Zhlobin', 414, 1, 20),
  (7448, 'Lida', 415, 1, 20),
  (7450, 'Navahrudak', 415, 1, 20),
  (7453, 'Slonim', 415, 1, 20),
  (7454, 'Smarhon', 415, 1, 20),
  (7455, 'Vawkavysk', 415, 1, 20),
  (7464, 'Krychaw', 416, 1, 20),
  (7467, 'Shklov', 416, 1, 20),
  (7469, 'Minsk', 418, 1, 20),
  (7470, 'Petrikov', 420, 1, 20),
  (7492, 'Antwerpen', 422, 1, 21),
  (7500, 'Boom', 422, 1, 21),
  (7511, 'Geel', 422, 1, 21),
  (7528, 'Lier', 422, 1, 21),
  (7531, 'Malmdey', 422, 1, 21),
  (7532, 'Mechelen', 422, 1, 21),
  (7555, 'Turnhout', 422, 1, 21),
  (7570, 'Brussels', 424, 1, 21),
  (7583, 'Beaumont', 428, 1, 21),
  (7586, 'Binche', 428, 1, 21),
  (7622, 'Leuven', 428, 1, 21),
  (7630, 'Mons', 428, 1, 21),
  (7648, 'Tournai', 428, 1, 21),
  (7718, 'Spa', 429, 1, 21),
  (7728, 'Verviers', 429, 1, 21),
  (7738, 'Beringen', 430, 1, 21),
  (7745, 'Genk', 430, 1, 21),
  (7750, 'Hasselt', 430, 1, 21),
  (7763, 'Lommel', 430, 1, 21),
  (7774, 'Sint-Truiden', 430, 1, 21),
  (7776, 'Tongeren', 430, 1, 21),
  (7784, 'Bastogne', 431, 1, 21),
  (7787, 'Bouillon', 431, 1, 21),
  (7790, 'Durbuy', 431, 1, 21),
  (7830, 'Beauraing', 432, 1, 21),
  (7835, 'Dinant', 432, 1, 21),
  (7859, 'Rochefort', 432, 1, 21),
  (7870, 'Aalst', 434, 1, 21),
  (7880, 'Dendermonde', 434, 1, 21),
  (7915, 'Ninove', 434, 1, 21),
  (7917, 'Oudenaarde', 434, 1, 21),
  (7924, 'Sint-Niklaas', 434, 1, 21),
  (7961, 'Halle', 436, 1, 21),
  (7969, 'Kortrijk', 436, 1, 21),
  (7998, 'Tienen', 436, 1, 21),
  (8000, 'Vilvoorde', 436, 1, 21),
  (8014, 'Blankenberge', 438, 1, 21),
  (8017, 'Damme', 438, 1, 21),
  (8018, 'De Haan', 438, 1, 21),
  (8035, 'Knokke-Heist', 438, 1, 21),
  (8052, 'Ostend', 438, 1, 21),
  (8058, 'Roeselare', 438, 1, 21),
  (8064, 'Veurne', 438, 1, 21),
  (8139, 'Guayaramerin', 477, 1, 26),
  (8142, 'Riberalta', 477, 1, 26),
  (8143, 'Rurrenabaque', 477, 1, 26),
  (8144, 'San Borja', 477, 1, 26),
  (8147, 'Santa Ana', 477, 1, 26),
  (8149, 'Trinidad', 477, 1, 26),
  (8151, 'Monteagudo', 478, 1, 26),
  (8154, 'Sucre', 478, 1, 26),
  (8156, 'Villa Serano', 478, 1, 26),
  (8176, 'Huanuni', 481, 1, 26),
  (8178, 'Oruro', 481, 1, 26),
  (8182, 'Cobija', 482, 1, 26),
  (8185, 'coroico', 483, 1, 26),
  (8187, 'Potosi', 483, 1, 26),
  (8188, 'Santa Barbara', 483, 1, 26),
  (8189, 'Tupiza', 483, 1, 26),
  (8191, 'Uyuni', 483, 1, 26),
  (8192, 'Villazon', 483, 1, 26),
  (8196, 'Tarija', 485, 1, 26),
  (8198, 'Yacuiba', 485, 1, 26),
  (8513, 'Feijo', 512, 1, 30),
  (8518, 'Porto Walter', 512, 1, 30),
  (8519, 'Rio Branco', 512, 1, 30),
  (8525, 'Agua Branca', 513, 1, 30),
  (8536, 'Canapi', 513, 1, 30),
  (8545, 'Feira Grande', 513, 1, 30),
  (8557, 'Maceio', 513, 1, 30),
  (8574, 'Penedo', 513, 1, 30),
  (8587, 'Sao Luis do Quitunde', 513, 1, 30),
  (8602, 'Santana', 514, 1, 30),
  (8611, 'Borba', 515, 1, 30),
  (8621, 'Guajara', 515, 1, 30),
  (8630, 'Manaquiri', 515, 1, 30),
  (8645, 'Sao Paulo de Olivenca', 515, 1, 30),
  (8680, 'Campo Formoso', 516, 1, 30),
  (8711, 'Feira de Santana', 516, 1, 30),
  (8750, 'Uberlandia', 516, 1, 30),
  (8757, 'Joao Dourado', 516, 1, 30),
  (8789, 'Paratinga', 516, 1, 30),
  (8810, 'Ribeira do Pombal', 516, 1, 30),
  (8813, 'Salvador', 516, 1, 30),
  (8827, 'Sao Goncalo dos Campos', 516, 1, 30),
  (8893, 'Fortaleza', 517, 1, 30),
  (8896, 'Guaraciaba do Norte', 517, 1, 30),
  (8988, 'Goianapolis', 521, 1, 30),
  (9166, 'Belem', 526, 1, 30),
  (9266, 'Campina Grande', 527, 1, 30),
  (9373, 'Curitiba', 528, 1, 30),
  (9378, 'Florestopolis', 528, 1, 30),
  (9379, 'Foz do Iguacu', 528, 1, 30),
  (9390, 'Irati', 528, 1, 30),
  (9400, 'Londrina', 528, 1, 30),
  (9405, 'Maringa', 528, 1, 30),
  (9418, 'Paranagua', 528, 1, 30),
  (9451, 'Siquera Campos', 528, 1, 30),
  (9476, 'Belem de Sao Francisco', 529, 1, 30),
  (9477, 'Belo Jardim', 529, 1, 30),
  (9533, 'Olinda', 529, 1, 30),
  (9548, 'Recife', 529, 1, 30),
  (9617, 'Porto', 530, 1, 30),
  (9651, 'Ouro Preto', 534, 1, 30),
  (9670, 'Aracaju', 538, 1, 30),
  (9743, 'Bansko', 545, 1, 33),
  (9745, 'Blagoevgrad', 545, 1, 33),
  (9750, 'Melnik', 545, 1, 33),
  (9753, 'Sandanski', 545, 1, 33),
  (9763, 'Karnobat', 546, 1, 33),
  (9765, 'Nesebar', 546, 1, 33),
  (9769, 'Sozopol', 546, 1, 33),
  (9773, 'Balchik', 547, 1, 33),
  (9774, 'Dobrich', 547, 1, 33),
  (9781, 'Gabrovo', 548, 1, 33),
  (9785, 'Dimitrovgrad', 549, 1, 33),
  (9787, 'Haskovo', 549, 1, 33),
  (9793, 'Svilengrad', 549, 1, 33),
  (9801, 'Kardzhali', 551, 1, 33),
  (9815, 'Lovech', 553, 1, 33),
  (9825, 'Lom', 554, 1, 33),
  (9826, 'Montana', 554, 1, 33),
  (9832, 'Koprivshtica', 556, 1, 33),
  (9833, 'Panagjurishte', 556, 1, 33),
  (9834, 'Pazardzhik', 556, 1, 33),
  (9839, 'Velingrad', 556, 1, 33),
  (9843, 'Pernik', 557, 1, 33),
  (9858, 'Asenovgrad', 559, 1, 33),
  (9863, 'Karlovo', 559, 1, 33),
  (9875, 'Razgrad', 560, 1, 33),
  (9888, 'Shumen', 562, 1, 33),
  (9894, 'Silistra', 563, 1, 33),
  (9900, 'Sliven', 564, 1, 33),
  (9908, 'Smoljan', 565, 1, 33),
  (9914, 'Targovishte', 569, 1, 33),
  (9924, 'Belogradchik', 572, 1, 33),
  (9931, 'Vidin', 572, 1, 33),
  (10008, 'Kampot', 635, 1, 36),
  (10009, 'Ta Khmau', 636, 1, 36),
  (10010, 'Kracheh', 638, 1, 36),
  (10011, 'Pousat', 645, 1, 36),
  (10012, 'Phumi Takaev', 652, 1, 36),
  (10095, 'Banff', 663, 1, 38),
  (10107, 'Calgary', 663, 1, 38),
  (10115, 'Clairmont', 663, 1, 38),
  (10123, 'Drayton Valley', 663, 1, 38),
  (10125, 'Edmonton', 663, 1, 38),
  (10128, 'Quebec', 663, 1, 38),
  (10137, 'Hanna', 663, 1, 38),
  (10140, 'High River', 663, 1, 38),
  (10148, 'Lamont', 663, 1, 38),
  (10158, 'Morinville', 663, 1, 38),
  (10162, 'Peace River', 663, 1, 38),
  (10170, 'New Brunswick', 663, 1, 38),
  (10174, 'Saint Paul', 663, 1, 38),
  (10180, 'Spruce Grove', 663, 1, 38),
  (10188, 'Three Hills', 663, 1, 38),
  (10191, 'Valleyview', 663, 1, 38),
  (10206, 'Novascotia', 665, 1, 38),
  (10214, 'Killarney', 665, 1, 38),
  (10219, 'Minnedosa', 665, 1, 38),
  (10231, 'Sainte Rose du Lac', 665, 1, 38),
  (10234, 'Snow Lake', 665, 1, 38),
  (10242, 'Thompson', 665, 1, 38),
  (10256, 'Alliston', 671, 1, 38),
  (10273, 'Beeton', 671, 1, 38),
  (10274, 'Belleville', 671, 1, 38),
  (10285, 'Brantford', 671, 1, 38),
  (10288, 'Brockville', 671, 1, 38),
  (10300, 'Alberta', 671, 1, 38),
  (10307, 'Chapleau', 671, 1, 38),
  (10310, 'Chesterville', 671, 1, 38),
  (10319, 'Cookstown', 671, 1, 38),
  (10363, 'Nunavut', 671, 1, 38),
  (10389, 'Kingston', 671, 1, 38),
  (10391, 'Kitchener', 671, 1, 38),
  (10419, 'Mississauga', 671, 1, 38),
  (10487, 'Sault Sainte Marie', 671, 1, 38),
  (10526, 'Vaughan', 671, 1, 38),
  (10533, 'Manitoba', 671, 1, 38),
  (10537, 'Wellesley', 671, 1, 38),
  (10538, 'Wellington', 671, 1, 38),
  (10586, 'Charlesbourg', 673, 1, 38),
  (10647, 'British Columbia', 673, 1, 38),
  (10672, 'Montreal', 673, 1, 38),
  (10692, 'Princeville', 673, 1, 38),
  (10787, 'Trois-Rivieres', 673, 1, 38),
  (10829, 'Langenburg', 674, 1, 38),
  (10847, 'Preeceville', 674, 1, 38),
  (10848, 'Prince Albert', 674, 1, 38),
  (10852, 'Saskatoon', 674, 1, 38),
  (10854, 'Shellbrook', 674, 1, 38),
  (10859, 'Ontario', 674, 1, 38),
  (10865, 'Yorkton', 674, 1, 38),
  (10868, 'Whitehorse', 675, 1, 38),
  (11161, 'Guangde', 731, 1, 44),
  (11181, 'Aomen', 734, 1, 44),
  (11182, 'Beijing', 735, 1, 44),
  (11190, 'Beijing', 736, 1, 44),
  (11199, 'Guangzhou', 737, 1, 44),
  (11210, 'Fujian', 738, 1, 44),
  (11223, 'Nanping', 738, 1, 44),
  (11226, 'Taipei', 738, 1, 44),
  (11260, 'Putian', 739, 1, 44),
  (11307, 'Guangdong', 741, 1, 44),
  (11345, 'Dongguan', 741, 1, 44),
  (11348, 'Hong Kong', 741, 1, 44),
  (11353, 'Shenzhen', 741, 1, 44),
  (11472, 'Guilin', 743, 1, 44),
  (11716, 'Wuhan', 749, 1, 44),
  (11806, 'Nanjing', 751, 1, 44),
  (11818, 'Suzhou', 751, 1, 44),
  (12018, 'Shenyang', 755, 1, 44),
  (12304, 'Shanghai', 763, 1, 44),
  (12323, 'Chengdu', 765, 1, 44),
  (12365, 'Tianjin', 766, 1, 44),
  (12366, 'Xianshuigu', 766, 1, 44),
  (12431, 'Hangzhou', 771, 1, 44),
  (12497, 'Linan City', 772, 1, 44),
  (12532, 'Puerto Narino', 775, 1, 47),
  (12547, 'Armenia', 776, 1, 47),
  (12572, 'Copacabana', 776, 1, 47),
  (12578, 'Envigado', 776, 1, 47),
  (12587, 'Guatape', 776, 1, 47),
  (12595, 'La Estrella', 776, 1, 47),
  (12601, 'Medellin', 776, 1, 47),
  (12633, 'Santa Barbara', 776, 1, 47),
  (12645, 'Turbo', 776, 1, 47),
  (12666, 'Barranquilla', 778, 1, 47),
  (12688, 'Bogota', 779, 1, 47),
  (12694, 'Barranco de Loba', 780, 1, 47),
  (12697, 'Cartagena', 780, 1, 47),
  (12732, 'Villanueva', 780, 1, 47),
  (12789, 'Moniquira', 781, 1, 47),
  (12820, 'Santa Maria', 781, 1, 47),
  (12848, 'Tunja', 781, 1, 47),
  (12882, 'Villamaria', 782, 1, 47),
  (12890, 'Florencia', 783, 1, 47),
  (12918, 'Yopal', 784, 1, 47),
  (12959, 'Villa Rica', 785, 1, 47),
  (13006, 'Quibdo', 787, 1, 47),
  (13129, 'Soacha', 789, 1, 47),
  (13158, 'Zipaquira', 789, 1, 47),
  (13191, 'San Agustin', 792, 1, 47),
  (13243, 'La Macarena', 795, 1, 47),
  (13286, 'Ipiales', 796, 1, 47),
  (13301, 'Pasto', 796, 1, 47),
  (13325, 'Mocoa', 798, 1, 47),
  (13342, 'Filandia', 799, 1, 47),
  (13348, 'Salento', 799, 1, 47),
  (13361, 'Santa Rosa de Cabal', 800, 1, 47),
  (13367, 'Barichara', 802, 1, 47),
  (13371, 'Bucaramanga', 802, 1, 47),
  (13373, 'California', 802, 1, 47),
  (13432, 'San Gil', 802, 1, 47),
  (13471, 'Sincelejo', 803, 1, 47),
  (13496, 'Ibague', 804, 1, 47),
  (14610, 'Limassol', 910, 1, 56),
  (14611, 'Paphos', 912, 1, 56),
  (14912, 'Aalborg', 941, 1, 58),
  (14918, 'Ebeltoft', 941, 1, 58),
  (14928, 'Copenhagen', 941, 1, 58),
  (14936, 'Randers', 941, 1, 58),
  (14942, 'Silkeborg', 941, 1, 58),
  (14963, 'Fredensborg', 943, 1, 58),
  (14970, 'Helsinge', 943, 1, 58),
  (14971, 'Helsingor', 943, 1, 58),
  (14972, 'Hillerod', 943, 1, 58),
  (14974, 'Horsholm', 943, 1, 58),
  (14984, 'Olstykke', 943, 1, 58),
  (14988, 'Stenlose', 943, 1, 58),
  (15001, 'Faaborg', 944, 1, 58),
  (15002, 'Glamsbjerg', 944, 1, 58),
  (15013, 'Odense', 944, 1, 58),
  (15018, 'Seden', 944, 1, 58),
  (15019, 'Sonderso', 944, 1, 58),
  (15022, 'Svendborg', 944, 1, 58),
  (15028, 'Ballerup', 945, 1, 58),
  (15032, 'Dragor', 946, 1, 58),
  (15043, 'Taastrup', 946, 1, 58),
  (15057, 'Frederikshavn', 949, 1, 58),
  (15063, 'Hirtshals', 949, 1, 58),
  (15065, 'Hjorring', 949, 1, 58),
  (15071, 'Norresundby', 949, 1, 58),
  (15076, 'Skagen', 949, 1, 58),
  (15091, 'Billund', 950, 1, 58),
  (15095, 'Rindsted', 950, 1, 58),
  (15100, 'Ribe', 950, 1, 58),
  (15111, 'Herning', 951, 1, 58),
  (15112, 'Holstebro', 951, 1, 58),
  (15140, 'Koge', 953, 1, 58),
  (15143, 'Roskilde', 953, 1, 58),
  (15152, 'Naestved', 955, 1, 58),
  (15154, 'Aabenraa', 957, 1, 58),
  (15163, 'Haderslev', 957, 1, 58),
  (15194, 'Ronnede', 958, 1, 58),
  (15208, 'Fredericia', 961, 1, 58),
  (15211, 'Horsens', 961, 1, 58),
  (15212, 'Jelling', 961, 1, 58),
  (15214, 'Kolding', 961, 1, 58),
  (15221, 'Vejle', 961, 1, 58),
  (15225, 'Frederiksberg', 962, 1, 58),
  (15229, 'Holbaek', 962, 1, 58),
  (15238, 'Slagelse', 962, 1, 58),
  (15239, 'Soro', 962, 1, 58),
  (15252, 'Skive', 963, 1, 58),
  (15256, 'Viborg', 963, 1, 58),
  (15685, 'Parnu', 1104, 1, 68),
  (15686, 'Tartu', 1104, 1, 68),
  (15697, 'Assaku', 1104, 1, 68),
  (15707, 'Harma', 1104, 1, 68),
  (15715, 'Jogisoo', 1104, 1, 68),
  (15721, 'Kallavere', 1104, 1, 68),
  (15761, 'Loksa', 1104, 1, 68),
  (15766, 'Maardu', 1104, 1, 68),
  (15784, 'Paldiski', 1104, 1, 68),
  (15787, 'Patika', 1104, 1, 68),
  (15792, 'Pikva', 1104, 1, 68),
  (15808, 'Saue', 1104, 1, 68),
  (15848, 'Kardla', 1105, 1, 68),
  (15854, 'Suuremoisa', 1105, 1, 68),
  (15863, 'Johvi', 1106, 1, 68),
  (15866, 'Kivioli', 1106, 1, 68),
  (15867, 'Kohtla-Jarve', 1106, 1, 68),
  (15877, 'Narva', 1106, 1, 68),
  (15878, 'Narva-Joesuu', 1106, 1, 68),
  (15883, 'Pussi', 1106, 1, 68),
  (15887, 'Sillamae', 1106, 1, 68),
  (15931, 'Paide', 1107, 1, 68),
  (15944, 'Turi', 1107, 1, 68),
  (15954, 'Jogeva', 1108, 1, 68),
  (15977, 'Mustvee', 1108, 1, 68),
  (15991, 'Poltsamaa', 1108, 1, 68),
  (16013, 'Vohmanomme', 1108, 1, 68),
  (16018, 'Haapsalu', 1109, 1, 68),
  (16026, 'Lihula', 1109, 1, 68),
  (16031, 'Nova', 1109, 1, 68),
  (16033, 'Palli', 1109, 1, 68),
  (16034, 'Panga', 1109, 1, 68),
  (16043, 'Tuudi', 1109, 1, 68),
  (16047, 'Virtsu', 1109, 1, 68),
  (16881, 'Maarianhamina', 1151, 1, 74),
  (16882, 'Imatra', 1152, 1, 74),
  (16884, 'Lappeenranta', 1152, 1, 74),
  (16890, 'Seinajoki', 1153, 1, 74),
  (16891, 'Mikkeli', 1154, 1, 74),
  (16892, 'Savonlinna', 1154, 1, 74),
  (16895, 'Porvoo', 1157, 1, 74),
  (16896, 'Kajaani', 1158, 1, 74),
  (16898, 'Hameenlinna', 1159, 1, 74),
  (16901, 'Kokkola', 1160, 1, 74),
  (16903, 'Jamsa', 1161, 1, 74),
  (16909, 'Hamina', 1162, 1, 74),
  (16910, 'Kotka', 1162, 1, 74),
  (16911, 'Kouvola', 1162, 1, 74),
  (16912, 'Kuusankoski', 1162, 1, 74),
  (16915, 'Kemi', 1164, 1, 74),
  (16917, 'Rovaniemi', 1164, 1, 74),
  (16919, 'Tornio', 1164, 1, 74),
  (16920, 'Jakobstad', 1166, 1, 74),
  (16928, 'Nokia', 1169, 1, 74),
  (16938, 'Vaasa', 1170, 1, 74),
  (16939, 'Joensuu', 1171, 1, 74),
  (16948, 'Raahe', 1172, 1, 74),
  (16954, 'Saarijarvi', 1174, 1, 74),
  (16964, 'Pori', 1175, 1, 74),
  (16965, 'Rauma', 1175, 1, 74),
  (16970, 'Hanko', 1179, 1, 74),
  (16972, 'Hyvinkaa', 1179, 1, 74),
  (16973, 'Jarvenpaa', 1179, 1, 74),
  (16974, 'Kauniainen', 1179, 1, 74),
  (16977, 'Lohja', 1179, 1, 74),
  (16985, 'Kaarina', 1180, 1, 74),
  (16986, 'Naantali', 1180, 1, 74),
  (16989, 'Salo', 1180, 1, 74),
  (17000, 'Paris', 1182, 1, 75),
  (17009, 'Antibes', 1186, 1, 75),
  (17012, 'Cannes', 1186, 1, 75),
  (17034, 'Chambord', 1188, 1, 75),
  (17125, 'Carcassonne', 1194, 1, 75),
  (17128, 'Narbonne', 1194, 1, 75),
  (17155, 'Frenchriviera', 1199, 1, 75),
  (17157, 'Arles', 1199, 1, 75),
  (17170, 'Marseille', 1199, 1, 75),
  (17215, 'La Rochelle', 1209, 1, 75),
  (17303, 'Chartres', 1223, 1, 75),
  (17360, 'Colmar', 1230, 1, 75),
  (17392, 'Fontainebleau', 1236, 1, 75),
  (17397, 'Chamonix-Mont-Blanc', 1236, 1, 75),
  (17411, 'Lourdes', 1239, 1, 75),
  (17467, 'Saint-Malo', 1243, 1, 75),
  (17512, 'Strasbourg', 1255, 1, 75),
  (17523, 'Roche-la-Moliere', 1256, 1, 75),
  (17563, 'Angers', 1264, 1, 75),
  (17723, 'Argentan', 1277, 1, 75),
  (17726, 'Paris', 1278, 1, 75),
  (17736, 'Calais', 1279, 1, 75),
  (17781, 'Biarritz', 1284, 1, 75),
  (17787, 'Pau', 1284, 1, 75),
  (17801, 'Lyon', 1287, 1, 75),
  (17891, 'Rouen', 1294, 1, 75),
  (18068, 'Avignon', 1308, 1, 75),
  (18088, 'Poitiers', 1311, 1, 75),
  (18135, 'Versailles', 1314, 1, 75),
  (18270, 'Atlanta', 1342, 1, 81),
  (18272, 'Macon', 1342, 1, 81),
  (18273, 'Decatur', 1342, 1, 81),
  (18274, 'Norcross', 1342, 1, 81),
  (18275, 'Gainesville', 1342, 1, 81),
  (18276, 'Valdosta', 1342, 1, 81),
  (18277, 'Suwanee', 1342, 1, 81),
  (18278, 'Buford', 1342, 1, 81),
  (18279, 'McDonough', 1343, 1, 81),
  (18280, 'Newnan', 1343, 1, 81),
  (18281, 'Warner Robins', 1343, 1, 81),
  (18282, 'Tybee Island', 1343, 1, 81),
  (18283, 'Douglasville', 1344, 1, 81),
  (18284, 'Sandy Springs', 1344, 1, 81),
  (18285, 'Dahlonega', 1345, 1, 81),
  (18286, 'Acworth', 1345, 1, 81),
  (18287, 'Covington', 1345, 1, 81),
  (18288, 'Snellville', 1345, 1, 81),
  (18289, 'Statesboro', 1345, 1, 81),
  (18290, 'Peachtree City', 1345, 1, 81),
  (18291, 'Helen', 1345, 1, 81),
  (18292, 'Johns Creek', 1345, 1, 81),
  (18293, 'Tifton', 1345, 1, 81),
  (18294, 'Cumming', 1345, 1, 81),
  (18295, 'Milledgeville', 1345, 1, 81),
  (18296, 'Lilburn', 1346, 1, 81),
  (18297, 'Americus', 1346, 1, 81),
  (18298, 'Austell', 1346, 1, 81),
  (18299, 'Loganville', 1346, 1, 81),
  (18300, 'Ellijay', 1346, 1, 81),
  (18301, 'Winder', 1346, 1, 81),
  (18302, 'Mableton', 1346, 1, 81),
  (18303, 'Blairsville', 1346, 1, 81),
  (18304, 'Braselton', 1346, 1, 81),
  (18305, 'Dawsonville', 1348, 1, 81),
  (18306, 'Senoia', 1348, 1, 81),
  (18307, 'Hinesville', 1349, 1, 81),
  (18308, 'Powder Springs', 1349, 1, 81),
  (18309, 'Dacula', 1349, 1, 81),
  (18310, 'East POint', 1351, 1, 81),
  (18311, 'Flowery Branch', 1351, 1, 81),
  (18340, 'Berlin', 1355, 1, 82),
  (18759, 'Munich', 1357, 1, 82),
  (18810, 'Dresden', 1357, 1, 82),
  (18813, 'Leipzig', 1357, 1, 82),
  (18814, 'Heidelberg', 1357, 1, 82),
  (18815, 'Marburg', 1357, 1, 82),
  (18951, 'Hamburg', 1357, 1, 82),
  (18952, 'Cologne', 1357, 1, 82),
  (19011, 'Wurzburg', 1357, 1, 82),
  (19036, 'Frankfurt', 1360, 1, 82),
  (20006, 'Trier', 1390, 1, 82),
  (20433, 'Corinth', 1412, 1, 85),
  (20434, 'Chania', 1413, 1, 85),
  (20435, 'Nafplio', 1413, 1, 85),
  (20436, 'Lindos', 1415, 1, 85),
  (20437, 'Thebes', 1415, 1, 85),
  (20438, 'Rhodes', 1416, 1, 85),
  (20439, 'Sparta', 1417, 1, 85),
  (20440, 'Delphi', 1418, 1, 85),
  (20441, 'Argos', 1418, 1, 85),
  (20442, 'Rethymno', 1418, 1, 85),
  (20443, 'Kalabaka', 1418, 1, 85),
  (20444, 'Kavala', 1418, 1, 85),
  (20445, 'Oia', 1418, 1, 85),
  (20446, 'Chalcis', 1418, 1, 85),
  (20447, 'Volos', 1419, 1, 85),
  (20448, 'Lerapetra', 1419, 1, 85),
  (20449, 'Corfu', 1419, 1, 85),
  (20450, 'Olympia', 1419, 1, 85),
  (20451, 'Sparti', 1419, 1, 85),
  (20452, 'Nafpaktos', 1419, 1, 85),
  (20453, 'Agios Nikolaos', 1419, 1, 85),
  (20454, 'Tripoli', 1419, 1, 85),
  (20455, 'Kalamata', 1419, 1, 85),
  (20456, 'Zogori', 1419, 1, 85),
  (20457, 'Aigio', 1419, 1, 85),
  (20458, 'Agrinio', 1419, 1, 85),
  (20459, 'Mytilene', 1419, 1, 85),
  (20460, 'Veria', 1419, 1, 85),
  (20461, 'Loutraki', 1419, 1, 85),
  (20462, 'Orestiada', 1419, 1, 85),
  (20463, 'Eleusis', 1419, 1, 85),
  (20464, 'Sithonia', 1419, 1, 85),
  (20465, 'Naousa', 1419, 1, 85),
  (20466, 'Rafina', 1419, 1, 85),
  (20467, 'Megara', 1419, 1, 85),
  (20468, 'Edessa', 1419, 1, 85),
  (20469, 'Drama', 1419, 1, 85),
  (20470, 'Acharnes', 1419, 1, 85),
  (20471, 'Xanthi', 1419, 1, 85),
  (20472, 'Loannina', 1419, 1, 85),
  (20473, 'Malia Crete', 1419, 1, 85),
  (20474, 'Lalysos', 1419, 1, 85),
  (20475, 'Missolonghi', 1419, 1, 85),
  (20476, 'Serres', 1419, 1, 85),
  (20477, 'Epidaurus', 1419, 1, 85),
  (20564, 'Thessaloniki', 1468, 1, 85),
  (20918, 'Baja', 1637, 1, 99),
  (20921, 'Dunapataj', 1637, 1, 99),
  (20922, 'Dunavecse', 1637, 1, 99),
  (20929, 'Kalocsa', 1637, 1, 99),
  (20931, 'Kecskemet', 1637, 1, 99),
  (20942, 'Nagybaracska', 1637, 1, 99),
  (20955, 'Dunaszekcso', 1638, 1, 99),
  (20961, 'Pecs', 1638, 1, 99),
  (20969, 'Villany', 1638, 1, 99),
  (20981, 'Gyula', 1639, 1, 99),
  (20997, 'Veszto', 1639, 1, 99),
  (21012, 'Miskolc', 1640, 1, 99),
  (21037, 'Tokaj', 1640, 1, 99),
  (21039, 'Budapest', 1641, 1, 99),
  (21043, 'Hodmezovasarhely', 1642, 1, 99),
  (21047, 'Mako', 1642, 1, 99),
  (21054, 'Szeged', 1642, 1, 99),
  (21056, 'Szekkutas', 1642, 1, 99),
  (21087, 'Szekesfehervar', 1643, 1, 99),
  (21096, 'Gyor', 1644, 1, 99),
  (21102, 'Mosonmagyarovar', 1644, 1, 99),
  (21104, 'Pannonhalma', 1644, 1, 99),
  (21106, 'Sopron', 1644, 1, 99),
  (21114, 'Debrecen', 1645, 1, 99),
  (21118, 'Hajduboszormeny', 1645, 1, 99),
  (21145, 'Eger', 1646, 1, 99),
  (21187, 'Szolnok', 1647, 1, 99),
  (21203, 'Esztergom', 1648, 1, 99),
  (21216, 'Tata', 1648, 1, 99),
  (21217, 'Tatabanya', 1648, 1, 99),
  (21240, 'Budaors', 1650, 1, 99),
  (21254, 'Godollo', 1650, 1, 99),
  (21308, 'Vac', 1650, 1, 99),
  (21312, 'Visegrad', 1650, 1, 99),
  (21316, 'Balatonfoldvar', 1651, 1, 99),
  (21325, 'Fonyod', 1651, 1, 99),
  (21326, 'Kaposvar', 1651, 1, 99),
  (21333, 'Siofok', 1651, 1, 99),
  (21356, 'Nyiregyhaza', 1652, 1, 99),
  (21387, 'Szentgal', 1653, 1, 99),
  (21392, 'Buk', 1654, 1, 99),
  (21399, 'Koszeg', 1654, 1, 99),
  (21400, 'Sarvar', 1654, 1, 99),
  (21402, 'Szombathely', 1654, 1, 99),
  (21417, 'Sumeg', 1655, 1, 99),
  (21418, 'Tapolca', 1655, 1, 99),
  (21424, 'Heviz', 1656, 1, 99),
  (21425, 'Keszthely', 1656, 1, 99),
  (21431, 'Zalaegerszeg', 1656, 1, 99),
  (21468, 'Kuta', 1667, 1, 102),
  (21470, 'Singaraja', 1667, 1, 102),
  (21472, 'Ubud', 1667, 1, 102),
  (21475, 'Pangkal Pinang', 1668, 1, 102),
  (21476, 'Pontianak', 1668, 1, 102),
  (21477, 'Padang', 1668, 1, 102),
  (21478, 'Manado', 1668, 1, 102),
  (21479, 'Bukittinggi', 1669, 1, 102),
  (21480, 'Cirebon', 1669, 1, 102),
  (21481, 'Batam', 1669, 1, 102),
  (21482, 'Kupang', 1669, 1, 102),
  (21483, 'Balikpapan', 1669, 1, 102),
  (21484, 'Semarang', 1669, 1, 102),
  (21485, 'Sabang', 1669, 1, 102),
  (21486, 'Jayapura', 1669, 1, 102),
  (21487, 'Sukabumi', 1669, 1, 102),
  (21488, 'Tomohon', 1669, 1, 102),
  (21489, 'Palu', 1669, 1, 102),
  (21490, 'Bogor', 1669, 1, 102),
  (21493, 'Bekasi', 1670, 1, 102),
  (21497, 'Jakarta', 1673, 1, 102),
  (21503, 'Bandar Lampung', 1683, 1, 102),
  (21504, 'Kota Bumi', 1683, 1, 102),
  (21509, 'Ambon', 1684, 1, 102),
  (21519, 'Sorong', 1688, 1, 102),
  (21524, 'Pekan Baru', 1689, 1, 102),
  (21875, 'Ennis', 1752, 1, 105),
  (21876, 'Kilkee', 1752, 1, 105),
  (21879, 'Shannon', 1752, 1, 105),
  (21881, 'Bantry', 1753, 1, 105),
  (21882, 'Belfast', 1753, 1, 105),
  (21885, 'Clonakilty', 1753, 1, 105),
  (21886, 'Cobh', 1753, 1, 105),
  (21887, 'Cork', 1753, 1, 105),
  (21892, 'Kinsale', 1753, 1, 105),
  (21900, 'Youghal', 1753, 1, 105),
  (21908, 'Letterkenny', 1754, 1, 105),
  (21913, 'Dublin', 1755, 1, 105),
  (21916, 'Malahide', 1755, 1, 105),
  (21917, 'Portrane', 1755, 1, 105),
  (21921, 'Swords', 1755, 1, 105),
  (21924, 'Clifden', 1756, 1, 105),
  (21925, 'Galway', 1756, 1, 105),
  (21932, 'Dingle', 1757, 1, 105),
  (21933, 'Kenmare', 1757, 1, 105),
  (21936, 'Listowel', 1757, 1, 105),
  (21937, 'Tralee', 1757, 1, 105),
  (21944, 'Maynooth', 1758, 1, 105),
  (21950, 'Kilkenny', 1759, 1, 105),
  (21958, 'Carrick-on-Shannon', 1762, 1, 105),
  (21961, 'Limerick', 1763, 1, 105),
  (21968, 'Drogheda', 1766, 1, 105),
  (21970, 'Dundalk', 1766, 1, 105),
  (21977, 'Westport', 1767, 1, 105),
  (21980, 'Dunboyne', 1768, 1, 105),
  (21982, 'Kells', 1768, 1, 105),
  (21985, 'Trim', 1768, 1, 105),
  (21988, 'Clonmel', 1769, 1, 105),
  (21993, 'Edenderry', 1770, 1, 105),
  (22000, 'Sligo', 1772, 1, 105),
  (22002, 'Downpatrick', 1775, 1, 105),
  (22003, 'Dungarvan', 1776, 1, 105),
  (22004, 'Tramore', 1776, 1, 105),
  (22005, 'Waterford', 1776, 1, 105),
  (22006, 'Athlone', 1777, 1, 105),
  (22007, 'Mullingar', 1777, 1, 105),
  (24112, 'Tokyo', 1918, 1, 109),
  (24113, 'Nagasaki', 1918, 1, 109),
  (24118, 'Fujioka', 1918, 1, 109),
  (24160, 'Takahama', 1918, 1, 109),
  (24181, 'Yokote', 1919, 1, 109),
  (24183, 'Aomori', 1920, 1, 109),
  (24198, 'Nagoyo', 1921, 1, 109),
  (24204, 'Kamagaya', 1921, 1, 109),
  (24211, 'Matsudo', 1921, 1, 109),
  (24214, 'Nara', 1921, 1, 109),
  (24215, 'Narita', 1921, 1, 109),
  (24244, 'Matsuyama', 1922, 1, 109),
  (24253, 'Fukui', 1923, 1, 109),
  (24269, 'Fukuoka', 1924, 1, 109),
  (24277, 'Kawasaki', 1924, 1, 109),
  (24278, 'Kitakyushu', 1924, 1, 109),
  (24346, 'Takayama', 1926, 1, 109),
  (24352, 'Fujimi', 1927, 1, 109),
  (24368, 'Shibukawa', 1927, 1, 109),
  (24369, 'Takasaki', 1927, 1, 109),
  (24377, 'Higashihiroshima', 1928, 1, 109),
  (24378, 'Hiroshima', 1928, 1, 109),
  (24404, 'Furano', 1929, 1, 109),
  (24405, 'Hakodate', 1929, 1, 109),
  (24425, 'Osaka', 1929, 1, 109),
  (24428, 'Sapporo', 1929, 1, 109),
  (24431, 'Shizunai', 1929, 1, 109),
  (24447, 'Himeji', 1930, 1, 109),
  (24454, 'Kobe', 1930, 1, 109),
  (24522, 'Kanazawa', 1932, 1, 109),
  (24549, 'Shizukuishi', 1933, 1, 109),
  (24572, 'Kagoshima', 1935, 1, 109),
  (24582, 'Sendai', 1935, 1, 109),
  (24591, 'Fujisawa', 1936, 1, 109),
  (24593, 'Hakone', 1936, 1, 109),
  (24597, 'Kamakura', 1936, 1, 109),
  (24610, 'Yokohama', 1936, 1, 109),
  (24619, 'Kochi', 1938, 1, 109),
  (24656, 'Kyoto', 1940, 1, 109),
  (24666, 'Ise', 1941, 1, 109),
  (25947, 'Aizkraukle', 2117, 1, 120),
  (25948, 'Jaunjelgava', 2117, 1, 120),
  (25950, 'Aluksne', 2118, 1, 120),
  (25951, 'Ape', 2118, 1, 120),
  (25952, 'Balvi', 2119, 1, 120),
  (25954, 'Bauska', 2120, 1, 120),
  (25955, 'Cesis', 2121, 1, 120),
  (25956, 'Ligatne', 2121, 1, 120),
  (25962, 'Dobele', 2124, 1, 120),
  (25963, 'Gulbene', 2125, 1, 120),
  (25965, 'Jekabspils', 2126, 1, 120),
  (25970, 'Kraslava', 2130, 1, 120),
  (25971, 'Kuldiga', 2131, 1, 120),
  (25972, 'Skrunda', 2131, 1, 120),
  (25973, 'Liepaja', 2132, 1, 120),
  (25974, 'Aizpute', 2133, 1, 120),
  (25975, 'Durbe', 2133, 1, 120),
  (25976, 'Grobina', 2133, 1, 120),
  (25977, 'Pavilosta', 2133, 1, 120),
  (25982, 'Salacgriva', 2134, 1, 120),
  (25985, 'Ludza', 2135, 1, 120),
  (25986, 'Zilupe', 2135, 1, 120),
  (25989, 'Madona', 2136, 1, 120),
  (25991, 'Ikskile', 2137, 1, 120),
  (25995, 'Ogre', 2137, 1, 120),
  (25996, 'Livani', 2138, 1, 120),
  (25998, 'Rezekne', 2139, 1, 120),
  (26000, 'Riga', 2141, 1, 120),
  (26112, 'Vilnius', 2218, 1, 126),
  (26114, 'Druskininkai', 2218, 1, 126),
  (26115, 'Lazdijai', 2218, 1, 126),
  (26119, 'Anyksciai', 2219, 1, 126),
  (26121, 'Birshtonas', 2220, 1, 126),
  (26124, 'Garliava', 2220, 1, 126),
  (26126, 'Jonava', 2220, 1, 126),
  (26129, 'Kaunas', 2220, 1, 126),
  (26130, 'Kedainiai', 2220, 1, 126),
  (26133, 'Raseiniai', 2220, 1, 126),
  (26134, 'Vilkija', 2220, 1, 126),
  (26136, 'Gargzhdai', 2221, 1, 126),
  (26137, 'Klaipeda', 2221, 1, 126),
  (26138, 'Kretinga', 2221, 1, 126),
  (26141, 'Palanga', 2221, 1, 126),
  (26142, 'Panemune', 2221, 1, 126),
  (26147, 'Skuodas', 2221, 1, 126),
  (26150, 'Kalvarija', 2222, 1, 126),
  (26152, 'Kudirkos Naumiestis', 2222, 1, 126),
  (26154, 'Marijampole', 2222, 1, 126),
  (26156, 'Vilkavishkis', 2222, 1, 126),
  (26158, 'Birzhai', 2223, 1, 126),
  (26168, 'Rokishkis', 2223, 1, 126),
  (26169, 'Subachius', 2223, 1, 126),
  (26172, 'Akmene', 2225, 1, 126),
  (26175, 'Kurshenai', 2225, 1, 126),
  (26256, 'Mamer', 2231, 1, 127),
  (26277, 'Clervaux', 2232, 1, 127),
  (26296, 'Holler', 2232, 1, 127),
  (26309, 'Niederwampach-Schimpach', 2232, 1, 127),
  (26320, 'Troisvierges', 2232, 1, 127),
  (26334, 'Diekirch', 2233, 1, 127),
  (26338, 'Ettelbruck', 2233, 1, 127),
  (26350, 'Michelau', 2233, 1, 127),
  (26363, 'Trier', 2234, 1, 127),
  (26364, 'Beaufort', 2234, 1, 127),
  (26366, 'Berdorf', 2234, 1, 127),
  (26369, 'Boursdorf', 2234, 1, 127),
  (26372, 'Consdorf', 2234, 1, 127),
  (26375, 'Echternach', 2234, 1, 127),
  (26398, 'Belvaux', 2235, 1, 127),
  (26401, 'Bettembourg', 2235, 1, 127),
  (26404, 'Differdange', 2235, 1, 127),
  (26405, 'Dudelange', 2235, 1, 127),
  (26408, 'Esch-Alzette', 2235, 1, 127),
  (26415, 'Kayl', 2235, 1, 127),
  (26419, 'Leudelange', 2235, 1, 127),
  (26427, 'Petange', 2235, 1, 127),
  (26431, 'Rodange', 2235, 1, 127),
  (26433, 'Roeser', 2235, 1, 127),
  (26434, 'Rumelange', 2235, 1, 127),
  (26436, 'Schifflange', 2235, 1, 127),
  (26454, 'Ehnen', 2236, 1, 127),
  (26459, 'Gonderange', 2236, 1, 127),
  (26462, 'Grevenmacher', 2236, 1, 127),
  (26465, 'Junglinster', 2236, 1, 127),
  (26485, 'Bertrange', 2237, 1, 127),
  (26493, 'Hesperange', 2237, 1, 127),
  (26507, 'Sandweiler', 2237, 1, 127),
  (26513, 'Strassen', 2237, 1, 127),
  (26517, 'Walferdange', 2237, 1, 127),
  (26522, 'Bissen', 2238, 1, 127),
  (26541, 'Larochette', 2238, 1, 127),
  (26545, 'Mersch', 2238, 1, 127),
  (26575, 'Eschette', 2239, 1, 127),
  (26917, 'Bandar Maharani', 2307, 1, 132),
  (26922, 'Johor Bahru', 2307, 1, 132),
  (26925, 'Kota Tinggi', 2307, 1, 132),
  (26930, 'Mersing', 2307, 1, 132),
  (26935, 'Segamat', 2307, 1, 132),
  (26942, 'Alor Setar', 2308, 1, 132),
  (26948, 'Kuala Kedah', 2308, 1, 132),
  (26954, 'Kota Bahru', 2309, 1, 132),
  (26955, 'Kuala Krai', 2309, 1, 132),
  (26956, 'Pangkal Kalong', 2309, 1, 132),
  (26959, 'Tanah Merah', 2309, 1, 132),
  (26966, 'Batu Berendam', 2312, 1, 132),
  (26971, 'Kuala Sungai Baru', 2312, 1, 132),
  (26972, 'Malacca', 2312, 1, 132),
  (26973, 'Masjid Tanah', 2312, 1, 132),
  (26983, 'Kuantan', 2315, 1, 132),
  (26991, 'George Town', 2316, 1, 132),
  (26996, 'Ipoh', 2317, 1, 132),
  (27009, 'Taiping', 2317, 1, 132),
  (27010, 'Tanjong Malim', 2317, 1, 132),
  (27012, 'Teluk Intan', 2317, 1, 132),
  (27013, 'Kangar', 2318, 1, 132),
  (27017, 'Keningau', 2320, 1, 132),
  (27020, 'Kota Kinabalu', 2320, 1, 132),
  (27024, 'Papar', 2320, 1, 132),
  (27027, 'Sandakan', 2320, 1, 132),
  (27028, 'Semporna', 2320, 1, 132),
  (27030, 'Batu Delapan Bazaar', 2321, 1, 132),
  (27033, 'Kota Samarahan', 2321, 1, 132),
  (27034, 'Kuching', 2321, 1, 132),
  (27036, 'Miri', 2321, 1, 132),
  (27260, 'Gharghur', 2357, 1, 135),
  (27261, 'Mellieha', 2357, 1, 135),
  (27262, 'Mgarr', 2357, 1, 135),
  (27263, 'Mosta', 2357, 1, 135),
  (27264, 'Naxxar', 2357, 1, 135),
  (27265, 'San Pawl il-Bahar', 2357, 1, 135),
  (27266, 'L-Iklin', 2360, 1, 135),
  (27267, 'Attard', 2361, 1, 135),
  (27268, 'Balzan', 2361, 1, 135),
  (27269, 'Dingli', 2361, 1, 135),
  (27270, 'Iklin', 2361, 1, 135),
  (27271, 'Lija', 2361, 1, 135),
  (27272, 'Mdina', 2361, 1, 135),
  (27273, 'Rabat', 2361, 1, 135),
  (27274, 'Sighghiewi', 2361, 1, 135),
  (27275, 'Zebbug', 2361, 1, 135),
  (27566, 'Aguascalientes', 2427, 1, 142),
  (27576, 'San Francisco de los Romo', 2427, 1, 142),
  (27602, 'Acapetahua', 2431, 1, 142),
  (27637, 'Ixtapa', 2431, 1, 142),
  (27649, 'Mazatan', 2431, 1, 142),
  (27666, 'Puerto Madero', 2431, 1, 142),
  (27692, 'Tuxtla Chico', 2431, 1, 142),
  (27693, 'Tuxtla Gutierrez', 2431, 1, 142),
  (27709, 'Chihuahua', 2432, 1, 142),
  (27718, 'Hermenegildo Galeana', 2432, 1, 142),
  (27744, 'Allende', 2433, 1, 142),
  (27784, 'Manzanillo', 2434, 1, 142),
  (27793, 'Durango', 2436, 1, 142),
  (27795, 'Guadalupe Victoria', 2436, 1, 142),
  (27838, 'Guanajuato', 2438, 1, 142),
  (29548, 'Fontvieille', 2477, 1, 145),
  (29549, 'Monaco-Ville', 2479, 1, 145),
  (30697, 'Umuahia', 2647, 1, 160),
  (30713, 'Yola', 2649, 1, 160),
  (30717, 'Awka', 2651, 1, 160),
  (30731, 'Bauchi', 2652, 1, 160),
  (30748, 'Katsina-Ala', 2654, 1, 160),
  (30749, 'Makurdi', 2654, 1, 160),
  (30775, 'Asaba', 2657, 1, 160),
  (30783, 'Abakaliki', 2658, 1, 160),
  (30790, 'Benin', 2659, 1, 160),
  (30798, 'Ado', 2660, 1, 160),
  (30822, 'Nsukka', 2661, 1, 160),
  (30840, 'Owerri', 2663, 1, 160),
  (30842, 'Birnin Kudu', 2664, 1, 160),
  (30933, 'Katsina', 2667, 1, 160),
  (30945, 'Birnin Kebbi', 2668, 1, 160),
  (30946, 'Birnin Yauri', 2668, 1, 160),
  (30959, 'Ajaokuta', 2669, 1, 160),
  (30966, 'Lokoja', 2669, 1, 160),
  (30972, 'Ilorin', 2670, 1, 160),
  (30975, 'Lafiagi', 2670, 1, 160),
  (30983, 'Ikeja', 2671, 1, 160),
  (30985, 'Lagos', 2671, 1, 160),
  (30993, 'Lafia', 2672, 1, 160),
  (31006, 'Minna', 2673, 1, 160),
  (31011, 'Suleja', 2673, 1, 160),
  (31028, 'Akure', 2675, 1, 160),
  (31042, 'Ife', 2676, 1, 160),
  (31064, 'Ibadan', 2677, 1, 160),
  (31075, 'Oyo', 2677, 1, 160),
  (31081, 'Jos', 2678, 1, 160),
  (31122, 'Jalingo', 2681, 1, 160),
  (31137, 'Potiskum', 2682, 1, 160),
  (31168, 'Alesund', 2690, 1, 164),
  (31173, 'Lillestrom', 2690, 1, 164),
  (31178, 'Skudeneshavn', 2690, 1, 164),
  (31181, 'Drammen', 2693, 1, 164),
  (31184, 'Kongsberg', 2693, 1, 164),
  (31190, 'Bergen', 2695, 1, 164),
  (31192, 'Hamar', 2695, 1, 164),
  (31194, 'Reine', 2695, 1, 164),
  (31199, 'Fredrikstad', 2696, 1, 164),
  (31202, 'Bodo', 2699, 1, 164),
  (31204, 'Narvik', 2699, 1, 164),
  (31208, 'Steigen', 2699, 1, 164),
  (31211, 'Longyearbyen', 2700, 1, 164),
  (31214, 'Tromso', 2700, 1, 164),
  (31222, 'Egersund', 2703, 1, 164),
  (31226, 'Sola', 2703, 1, 164),
  (31228, 'Stavern', 2706, 1, 164),
  (31230, 'Notodden', 2708, 1, 164),
  (31235, 'Horten', 2711, 1, 164),
  (31237, 'Geiranger', 2711, 1, 164),
  (31273, 'Karachi', 2723, 1, 166),
  (31276, 'Chaman', 2723, 1, 166),
  (31279, 'Dera Allah Yar', 2723, 1, 166),
  (31281, 'Peshawar', 2723, 1, 166),
  (31285, 'Gwadar', 2723, 1, 166),
  (31300, 'Quetta', 2723, 1, 166),
  (31316, 'Ahmedabad', 2728, 1, 166),
  (31323, 'Bahawalnagar', 2728, 1, 166),
  (31324, 'Bahawalpur', 2728, 1, 166),
  (31333, 'Burewala', 2728, 1, 166),
  (31337, 'Chakwal', 2728, 1, 166),
  (31340, 'Chiniot', 2728, 1, 166),
  (31362, 'Faisalabad', 2728, 1, 166),
  (31375, 'Gujranwala', 2728, 1, 166),
  (31419, 'Kasur', 2728, 1, 166),
  (31461, 'Mianwali', 2728, 1, 166),
  (31464, 'Multan', 2728, 1, 166),
  (31496, 'Rawalpindi', 2728, 1, 166),
  (31500, 'Sadiqabad', 2728, 1, 166),
  (31510, 'Sargodha', 2728, 1, 166),
  (31734, 'Boqueron', 2764, 1, 169),
  (31736, 'David', 2764, 1, 169),
  (31738, 'Gualaca', 2764, 1, 169),
  (31741, 'Puerto Armuelles', 2764, 1, 169),
  (31743, 'Rio Sereno', 2764, 1, 169),
  (31745, 'Aguadulce', 2765, 1, 169),
  (31746, 'Anton', 2765, 1, 169),
  (31750, 'Penonome', 2765, 1, 169),
  (31751, 'Colon', 2766, 1, 169),
  (31757, 'La Palma', 2767, 1, 169),
  (31760, 'Chitre', 2769, 1, 169),
  (31763, 'Ocu', 2769, 1, 169),
  (31764, 'Parita', 2769, 1, 169),
  (31769, 'Chame', 2773, 1, 169),
  (31770, 'Chepo', 2773, 1, 169),
  (31772, 'La Chorrera', 2773, 1, 169),
  (31773, 'Panama', 2773, 1, 169),
  (31779, 'Calobre', 2774, 1, 169),
  (31986, 'Bagua Grande', 2812, 1, 172),
  (32004, 'Abancay', 2814, 1, 172),
  (32009, 'Arequipa', 2815, 1, 172),
  (32021, 'Ayacucho', 2816, 1, 172),
  (32024, 'Huanta', 2816, 1, 172),
  (32045, 'Cusco', 2818, 1, 172),
  (32053, 'Urubamba', 2818, 1, 172),
  (32069, 'Nazca', 2821, 1, 172),
  (32071, 'Palpa', 2821, 1, 172),
  (32084, 'Chanchamayo', 2822, 1, 172),
  (32087, 'Huancayo', 2822, 1, 172),
  (32117, 'Lambayeque', 2824, 1, 172),
  (32144, 'Yurimaguas', 2826, 1, 172),
  (32145, 'Ilo', 2828, 1, 172),
  (32146, 'Moquegua', 2828, 1, 172),
  (32149, 'Cerro de Pasco', 2829, 1, 172),
  (32161, 'Catacaos', 2830, 1, 172),
  (32162, 'Chulucanas', 2830, 1, 172),
  (32170, 'La Huaca', 2830, 1, 172),
  (32175, 'Mancora', 2830, 1, 172),
  (32178, 'Paita', 2830, 1, 172),
  (32195, 'Lima', 2831, 1, 172),
  (32213, 'Tumbes', 2834, 1, 172),
  (32258, 'Brzeg Dolny', 2862, 1, 175),
  (32266, 'Jelenia Gora', 2862, 1, 175),
  (32268, 'Klodzko', 2862, 1, 175),
  (32284, 'Swidnica', 2862, 1, 175),
  (32302, 'Bydgoszcz', 2868, 1, 175),
  (32308, 'Inowroclaw', 2868, 1, 175),
  (32321, 'Torun', 2868, 1, 175),
  (32348, 'Wielun', 2869, 1, 175),
  (32352, 'Biala Podlaska', 2870, 1, 175),
  (32362, 'Lublin', 2870, 1, 175),
  (32374, 'Zamosc', 2870, 1, 175),
  (32376, 'Gorzow Wielkopolski', 2871, 1, 175),
  (32394, 'Zielona Gora', 2871, 1, 175),
  (32416, 'Oswiecim', 2873, 1, 175),
  (32425, 'Wieliczka', 2873, 1, 175),
  (32427, 'Zakopane', 2873, 1, 175),
  (32432, 'Gora Kalwaria', 2874, 1, 175),
  (32505, 'Przemysl', 2878, 1, 175),
  (32533, 'Gdansk', 2881, 1, 175),
  (32539, 'Malbork', 2881, 1, 175),
  (32546, 'Slupsk', 2881, 1, 175),
  (32547, 'Sopot', 2881, 1, 175),
  (32575, 'Katowice', 2886, 1, 175),
  (32581, 'Mikolow', 2886, 1, 175),
  (32612, 'Kielce', 2888, 1, 175),
  (32617, 'Sandomierz', 2888, 1, 175),
  (32629, 'Elk', 2889, 1, 175),
  (32630, 'Gizycko', 2889, 1, 175),
  (32633, 'Ketrzyn', 2889, 1, 175),
  (32638, 'Nidzica', 2889, 1, 175),
  (32646, 'Szczytno', 2889, 1, 175),
  (32650, 'Warsaw', 2890, 1, 175),
  (32654, 'Gniezno', 2892, 1, 175),
  (32660, 'Kolo', 2892, 1, 175),
  (32699, 'Goleniow', 2894, 1, 175),
  (32714, 'Swinoujscie', 2894, 1, 175),
  (32721, 'Tramagal', 2896, 1, 176),
  (32724, 'Faja de Baixo', 2897, 1, 176),
  (32727, 'Ponta Delgada', 2897, 1, 176),
  (32728, 'Praia da Vitoria', 2897, 1, 176),
  (32731, 'Rosto do Cao', 2897, 1, 176),
  (32732, 'Vila Franca do Campo', 2897, 1, 176),
  (32733, 'Alcacer do Sal', 2898, 1, 176),
  (32734, 'Aljustrel', 2898, 1, 176),
  (32735, 'Beja', 2898, 1, 176),
  (32736, 'Borba', 2898, 1, 176),
  (32737, 'Caia e Sao Pedro', 2898, 1, 176),
  (32740, 'Cercal', 2898, 1, 176),
  (32741, 'Elvas', 2898, 1, 176),
  (32744, 'Ferreira do Alentejo', 2898, 1, 176),
  (32745, 'Grandola', 2898, 1, 176),
  (32746, 'Montemor-o-Novo', 2898, 1, 176),
  (32747, 'Moura', 2898, 1, 176),
  (32750, 'Portalegre', 2898, 1, 176),
  (32751, 'Redondo', 2898, 1, 176),
  (32752, 'Reguengos de Monsaraz', 2898, 1, 176),
  (32755, 'Sao Teotonio', 2898, 1, 176),
  (32756, 'Serpa', 2898, 1, 176),
  (32757, 'Sines', 2898, 1, 176),
  (32758, 'Vendas Novas', 2898, 1, 176),
  (32761, 'Albufeira', 2899, 1, 176),
  (32762, 'Aljezur', 2899, 1, 176),
  (32763, 'Almancil', 2899, 1, 176),
  (32764, 'Alvor', 2899, 1, 176),
  (32765, 'Armacao de Pera', 2899, 1, 176),
  (32768, 'Estombar', 2899, 1, 176),
  (32769, 'Faro', 2899, 1, 176),
  (32770, 'Ferreiras', 2899, 1, 176),
  (32771, 'Guia', 2899, 1, 176),
  (32772, 'Lagoa', 2899, 1, 176),
  (32775, 'Luz', 2899, 1, 176),
  (32776, 'Moncarapacho', 2899, 1, 176),
  (32777, 'Monchique', 2899, 1, 176),
  (32780, 'Olhao', 2899, 1, 176),
  (32781, 'Portimao', 2899, 1, 176),
  (32782, 'Quarteira', 2899, 1, 176),
  (32783, 'Santa Barbara de Nexe', 2899, 1, 176),
  (32784, 'Sao Bartolomeu de Messines', 2899, 1, 176),
  (32785, 'Sao Bras de Alportel', 2899, 1, 176),
  (32788, 'Vila Real de Santo Antonio', 2899, 1, 176),
  (32789, 'Fafe', 2900, 1, 176),
  (32792, 'Abraveses', 2901, 1, 176),
  (32793, 'Aguada de Cima', 2901, 1, 176),
  (32794, 'Agueda', 2901, 1, 176),
  (32797, 'Alhadas', 2901, 1, 176),
  (32800, 'Arazede', 2901, 1, 176),
  (32801, 'Arcos', 2901, 1, 176),
  (32804, 'Aveiro', 2901, 1, 176),
  (32805, 'Batalha', 2901, 1, 176),
  (32806, 'Beduido', 2901, 1, 176),
  (32807, 'Branca', 2901, 1, 176),
  (32810, 'Cantanhede', 2901, 1, 176),
  (32811, 'Caranguejeira', 2901, 1, 176),
  (32814, 'Castro Daire', 2901, 1, 176),
  (32815, 'Coimbra', 2901, 1, 176),
  (32816, 'Condeixa-A-Nova', 2901, 1, 176),
  (32819, 'Eixo', 2901, 1, 176),
  (32820, 'Esmoriz', 2901, 1, 176),
  (32821, 'Figueira da Foz', 2901, 1, 176),
  (32824, 'Gafanha da Nazare', 2901, 1, 176),
  (32825, 'Guarda', 2901, 1, 176),
  (32828, 'Leiria', 2901, 1, 176),
  (32829, 'Lorvao', 2901, 1, 176),
  (32830, 'Lourical', 2901, 1, 176),
  (32833, 'Mangualde', 2901, 1, 176),
  (32834, 'Marinha Grande', 2901, 1, 176),
  (32837, 'Mira de Aire', 2901, 1, 176),
  (32840, 'Nelas', 2901, 1, 176),
  (32843, 'Oliveira do Hospital', 2901, 1, 176),
  (32844, 'Oliveirinha', 2901, 1, 176),
  (32847, 'Pardilho', 2901, 1, 176),
  (32852, 'Rio de Loba', 2901, 1, 176),
  (32853, 'Salreu', 2901, 1, 176),
  (32856, 'Sao Joao', 2901, 1, 176),
  (32857, 'Sao Pedro do Sul', 2901, 1, 176),
  (32858, 'Satao', 2901, 1, 176),
  (32859, 'Seia', 2901, 1, 176),
  (32862, 'Souto da Carpalhosa', 2901, 1, 176),
  (32867, 'Vagos', 2901, 1, 176),
  (32868, 'Valega', 2901, 1, 176),
  (32869, 'Valongo do Vouga', 2901, 1, 176),
  (32870, 'Vieira de Leiria', 2901, 1, 176),
  (32873, 'Camara de Lobos', 2907, 1, 176),
  (32874, 'Campanario', 2907, 1, 176),
  (32877, 'Machico', 2907, 1, 176),
  (32878, 'Ponta do Sol', 2907, 1, 176),
  (32881, 'Santa Cruz', 2907, 1, 176),
  (32884, 'Aguas Santas', 2908, 1, 176),
  (32885, 'Agucadoura', 2908, 1, 176),
  (32888, 'Amarante', 2908, 1, 176),
  (32891, 'Apulia', 2908, 1, 176),
  (32892, 'Arcozelo', 2908, 1, 176),
  (32895, 'Aroes', 2908, 1, 176),
  (32898, 'Aves', 2908, 1, 176),
  (32899, 'Avintes', 2908, 1, 176),
  (32902, 'Barcelos', 2908, 1, 176),
  (32903, 'Barrosas', 2908, 1, 176),
  (32906, 'Braganca', 2908, 1, 176),
  (32909, 'Caldelas', 2908, 1, 176),
  (32910, 'Calendario', 2908, 1, 176),
  (32911, 'Campo', 2908, 1, 176),
  (32923, 'Ermesinde', 2908, 1, 176),
  (32924, 'Espinho', 2908, 1, 176),
  (32925, 'Fafe', 2908, 1, 176),
  (32926, 'Fanzeres', 2908, 1, 176),
  (32927, 'Feira', 2908, 1, 176),
  (32928, 'Ferreira', 2908, 1, 176),
  (32932, 'Foz do Sousa', 2908, 1, 176),
  (32933, 'Frazao', 2908, 1, 176),
  (32934, 'Freamunde', 2908, 1, 176),
  (32938, 'Godim', 2908, 1, 176),
  (32942, 'Guifoes', 2908, 1, 176),
  (32943, 'Guimaraes', 2908, 1, 176),
  (32944, 'Gulpilhares', 2908, 1, 176),
  (32945, 'Joane', 2908, 1, 176),
  (32949, 'Leca da Palmeira', 2908, 1, 176),
  (32950, 'Leca do Bailio', 2908, 1, 176),
  (32951, 'Lobao', 2908, 1, 176),
  (32955, 'Macedo de Cavaleiros', 2908, 1, 176),
  (32956, 'Macieira de Cambra', 2908, 1, 176),
  (32960, 'Marinhas', 2908, 1, 176),
  (32961, 'Matosinhos', 2908, 1, 176),
  (32965, 'Milheiros de Poiares', 2908, 1, 176),
  (32966, 'Mirandela', 2908, 1, 176),
  (32967, 'Mogadouro', 2908, 1, 176),
  (32971, 'Negrelos', 2908, 1, 176),
  (32972, 'Nogueira', 2908, 1, 176),
  (32973, 'Nogueira da Regedoura', 2908, 1, 176),
  (32974, 'Olival', 2908, 1, 176),
  (32978, 'Pacos de Brandao', 2908, 1, 176),
  (32979, 'Pacos de Ferreira', 2908, 1, 176),
  (32986, 'Ponte', 2908, 1, 176),
  (32987, 'Porto', 2908, 1, 176),
  (32988, 'Povoa de Lanhoso', 2908, 1, 176),
  (32989, 'Povoa de Varzim', 2908, 1, 176),
  (32993, 'Refojos de Basto', 2908, 1, 176),
  (32994, 'Ribeirao', 2908, 1, 176),
  (32998, 'Sande', 2908, 1, 176),
  (33002, 'Santiago da Riba-Ul', 2908, 1, 176),
  (33003, 'Santo Tirso', 2908, 1, 176),
  (33007, 'Sao Mamede de Infesta', 2908, 1, 176),
  (33008, 'Sao Pedro da Cova', 2908, 1, 176),
  (33009, 'Sao Pedro de Casteloes', 2908, 1, 176),
  (33010, 'Sao Roque', 2908, 1, 176),
  (33012, 'Senhora da Hora', 2908, 1, 176),
  (33015, 'Serzedo', 2908, 1, 176),
  (33018, 'Sobreira', 2908, 1, 176),
  (33019, 'Souto', 2908, 1, 176),
  (33022, 'Valadares', 2908, 1, 176),
  (33025, 'Valongo', 2908, 1, 176),
  (33026, 'Valpacos', 2908, 1, 176),
  (33027, 'Viana do Castelo', 2908, 1, 176),
  (33030, 'Vila Nova da Telha', 2908, 1, 176),
  (33031, 'Vila Nova de Famalicao', 2908, 1, 176),
  (33034, 'Vila Real', 2908, 1, 176),
  (33037, 'Vila de Prado', 2908, 1, 176),
  (33038, 'Vila do Conde', 2908, 1, 176),
  (33041, 'Vilarinho', 2908, 1, 176),
  (33042, 'Vilela', 2908, 1, 176),
  (33043, 'Vizela', 2908, 1, 176),
  (33093, 'Doha', 2920, 1, 178),
  (33094, 'Umm Bab', 2921, 1, 178),
  (33095, 'ad-Dawhah', 2923, 1, 178),
  (33096, 'al-Ghuwayriyah', 2924, 1, 178),
  (33097, 'Dukhan', 2925, 1, 178),
  (33098, 'al-Jumayliyah', 2925, 1, 178),
  (33099, 'al-Khawr', 2926, 1, 178),
  (33100, 'Musay\'id', 2927, 1, 178),
  (33101, 'al-Wakrah', 2927, 1, 178),
  (33102, 'al-Wukayr', 2927, 1, 178),
  (33103, 'ar-Rayyan', 2928, 1, 178),
  (33104, 'ash-Shahaniyah', 2928, 1, 178),
  (33105, 'ar-Ruways', 2929, 1, 178),
  (33131, 'Alba Iulia', 2934, 1, 180),
  (33138, 'Bistra', 2934, 1, 180),
  (33191, 'Sebes', 2934, 1, 180),
  (33456, 'Targu Ocna', 2937, 1, 180),
  (33570, 'Ciceu-Giurgesti', 2939, 1, 180),
  (33624, 'Calarasi', 2940, 1, 180),
  (33712, 'Roman', 2941, 1, 180),
  (33735, 'Bran', 2942, 1, 180),
  (33745, 'Fagaras', 2942, 1, 180),
  (33762, 'Predeal', 2942, 1, 180),
  (33765, 'Rasnov', 2942, 1, 180),
  (33784, 'Bucharest', 2943, 1, 180),
  (33803, 'Cernatesti', 2944, 1, 180),
  (34074, 'Turda', 2947, 1, 180),
  (34106, 'Eforie', 2948, 1, 180),
  (34275, 'Bechet', 2951, 1, 180),
  (34314, 'Giurgita', 2951, 1, 180),
  (34575, 'Miercurea-Ciuc', 2955, 1, 180),
  (34629, 'Deva', 2956, 1, 180),
  (34841, 'Otopeni', 2959, 1, 180),
  (35064, 'Sighisoara', 2962, 1, 180),
  (35265, 'Azuga', 2965, 1, 180),
  (35281, 'Busteni', 2965, 1, 180),
  (35339, 'Sinaia', 2965, 1, 180),
  (35415, 'Zalau', 2966, 1, 180),
  (35791, 'Sulina', 2973, 1, 180),
  (35793, 'Tulcea', 2973, 1, 180),
  (36035, 'Omsk', 2980, 1, 181),
  (36277, 'Kazan', 2995, 1, 181),
  (36385, 'Saintpetersburg', 3003, 1, 181),
  (36386, 'Rostov', 3003, 1, 181),
  (36485, 'Novokuzneck', 3012, 1, 181),
  (36486, 'Novokuznetsk', 3012, 1, 181),
  (36718, 'Moscow', 3029, 1, 181),
  (36729, 'Murmansk', 3033, 1, 181),
  (36774, 'Novosibirsk', 3038, 1, 181),
  (36934, 'Rostov', 3048, 1, 181),
  (36935, 'Yekaterinburg', 3048, 1, 181),
  (36997, 'Samara', 3051, 1, 181),
  (37293, 'Suzdal', 3070, 1, 181),
  (37310, 'Nizhny Novgorod', 3071, 1, 181),
  (37541, 'Singapore', 3186, 1, 196),
  (37542, 'Banska Bystrica', 3187, 1, 197),
  (37543, 'Banska Shtiavnica', 3187, 1, 197),
  (37557, 'Rimavska Sobota', 3187, 1, 197),
  (37558, 'Sliach', 3187, 1, 197),
  (37566, 'Zvolen', 3187, 1, 197),
  (37570, 'Malacky', 3188, 1, 197),
  (37571, 'Modra', 3188, 1, 197),
  (37572, 'Pezinok', 3188, 1, 197),
  (37573, 'Senec', 3188, 1, 197),
  (37576, 'Svaty Jur', 3188, 1, 197),
  (37585, 'Michalovce', 3189, 1, 197),
  (37597, 'Hurbanovo', 3190, 1, 197),
  (37598, 'Kolarovo', 3190, 1, 197),
  (37599, 'Komarno', 3190, 1, 197),
  (37601, 'Levice', 3190, 1, 197),
  (37605, 'Nitra', 3190, 1, 197),
  (37606, 'Nove Zamky', 3190, 1, 197),
  (37617, 'Bardejov', 3191, 1, 197),
  (37619, 'Humenne', 3191, 1, 197),
  (37625, 'Poprad', 3191, 1, 197),
  (37627, 'Presov', 3191, 1, 197),
  (37631, 'Spishska Nova Ves', 3191, 1, 197),
  (37632, 'Spishske Podhradie', 3191, 1, 197),
  (37633, 'Stara L\'ubovna', 3191, 1, 197),
  (37641, 'Bojnice', 3192, 1, 197),
  (37656, 'Puchov', 3192, 1, 197),
  (37659, 'Trenchianske Teplice', 3192, 1, 197),
  (37661, 'Trencin', 3192, 1, 197),
  (37663, 'Dunajska Streda', 3193, 1, 197),
  (37671, 'Piesht\'any', 3193, 1, 197),
  (37678, 'Skalica', 3193, 1, 197),
  (37680, 'Trnava', 3193, 1, 197),
  (38028, 'Alberton', 3240, 1, 202),
  (38030, 'Gyeongju', 3240, 1, 202),
  (38032, 'Boksburg', 3240, 1, 202),
  (38035, 'Bronkhorstspruit', 3240, 1, 202),
  (38036, 'Suwon', 3240, 1, 202),
  (38038, 'Centurion', 3240, 1, 202),
  (38040, 'Dainfern', 3240, 1, 202),
  (38043, 'Fourways', 3240, 1, 202),
  (38044, 'Gardenview', 3240, 1, 202),
  (38046, 'Grant Park', 3240, 1, 202),
  (38048, 'Jeonju', 3240, 1, 202),
  (38051, 'Krugersdorp', 3240, 1, 202),
  (38052, 'Linmeyer', 3240, 1, 202),
  (38054, 'Midrand', 3240, 1, 202),
  (38056, 'Northmead', 3240, 1, 202),
  (38059, 'Pretoria', 3240, 1, 202),
  (38060, 'Chuncheon', 3240, 1, 202),
  (38062, 'Randfontein', 3240, 1, 202),
  (38064, 'Rivonia', 3240, 1, 202),
  (38067, 'Gangneung', 3240, 1, 202),
  (38069, 'Tembisa', 3240, 1, 202),
  (38071, 'Vanderbijlpark', 3240, 1, 202),
  (38073, 'Verwoerdburg', 3240, 1, 202),
  (38076, 'Westonaria', 3240, 1, 202),
  (38080, 'Seoul', 3244, 1, 202),
  (38082, 'Giyani', 3244, 1, 202),
  (38084, 'Louis Trichardt', 3244, 1, 202),
  (38087, 'Messina', 3244, 1, 202),
  (38093, 'Pietersburg', 3244, 1, 202),
  (38095, 'Soekmekaar', 3244, 1, 202),
  (38097, 'Thabazimbi', 3244, 1, 202),
  (38100, 'Busan', 3244, 1, 202),
  (38103, 'Embalenhle', 3245, 1, 202),
  (38105, 'Jejudo', 3245, 1, 202),
  (38107, 'Ermelo', 3245, 1, 202),
  (38110, 'Komatipoort', 3245, 1, 202),
  (38116, 'Mashishing', 3245, 1, 202),
  (38118, 'Nelspruit', 3245, 1, 202),
  (38120, 'Sakhile', 3245, 1, 202),
  (38123, 'Siyathemba', 3245, 1, 202),
  (38124, 'Siyathuthuka', 3245, 1, 202),
  (38126, 'Witbank', 3245, 1, 202),
  (38128, 'eLukwatini', 3245, 1, 202),
  (38131, 'ALbatera', 3255, 1, 205),
  (38135, 'Altea', 3255, 1, 205),
  (38137, 'Benidorm', 3255, 1, 205),
  (38180, 'Almeria', 3258, 1, 205),
  (38197, 'Gijon', 3260, 1, 205),
  (38207, 'Seville', 3260, 1, 205),
  (38215, 'Avila', 3261, 1, 205),
  (38221, 'Merida', 3262, 1, 205),
  (38228, 'Alcudia', 3263, 1, 205),
  (38239, 'Pamplona', 3263, 1, 205),
  (38246, 'Soller', 3263, 1, 205),
  (38254, 'Barcelona', 3264, 1, 205),
  (38318, 'Sitges', 3264, 1, 205),
  (38330, 'Vilassar del Mar', 3264, 1, 205),
  (38337, 'Burgos', 3267, 1, 205),
  (38339, 'Caceres', 3268, 1, 205),
  (38347, 'Arcos de la Frontera', 3269, 1, 205),
  (38349, 'Cordoba', 3269, 1, 205),
  (38355, 'Jimena de la Frontera', 3269, 1, 205),
  (38377, 'Santa Cruz de Bezana', 3270, 1, 205),
  (38378, 'Santander', 3270, 1, 205),
  (38390, 'Segorbe', 3271, 1, 205),
  (38394, 'Ceuta', 3273, 1, 205),
  (38414, 'Cuenca', 3282, 1, 205),
  (38422, 'Girona', 3284, 1, 205),
  (38440, 'Granada', 3285, 1, 205),
  (38442, 'Huescar', 3285, 1, 205),
  (38465, 'Donostia', 3287, 1, 205),
  (38559, 'El Escorial', 3297, 1, 205),
  (38567, 'Madrid', 3297, 1, 205),
  (38591, 'Antequera', 3298, 1, 205),
  (38599, 'Malaga', 3298, 1, 205),
  (38600, 'Marbella', 3298, 1, 205),
  (38604, 'Ronda', 3298, 1, 205),
  (38609, 'Melilla', 3299, 1, 205),
  (38689, 'Salamanca', 3306, 1, 205),
  (38692, 'Segovia', 3308, 1, 205),
  (38738, 'Salou', 3311, 1, 205),
  (38740, 'Tarragona', 3311, 1, 205),
  (38756, 'Toledo', 3314, 1, 205),
  (38813, 'Valencia', 3315, 1, 205),
  (38828, 'Bilbao', 3317, 1, 205),
  (38858, 'Badulla', 3322, 1, 206),
  (38859, 'Bandarawela', 3322, 1, 206),
  (38860, 'Haputale', 3322, 1, 206),
  (38863, 'Colombo', 3324, 1, 206),
  (38864, 'Dehiwala-Mount Lavinia', 3324, 1, 206),
  (38865, 'Homagama', 3324, 1, 206),
  (38873, 'Seethawakapura', 3324, 1, 206),
  (38875, 'Ambalamgoda', 3325, 1, 206),
  (38878, 'Gampaha', 3326, 1, 206),
  (38880, 'Jaela', 3326, 1, 206),
  (38883, 'Kelaniya', 3326, 1, 206),
  (38886, 'Peliyagoda', 3326, 1, 206),
  (38888, 'Wattala', 3326, 1, 206),
  (38890, 'Hambantota', 3327, 1, 206),
  (38892, 'Beruwala', 3328, 1, 206),
  (38894, 'Kalutara', 3328, 1, 206),
  (38896, 'Panadraya', 3328, 1, 206),
  (38900, 'Kurunegala', 3331, 1, 206),
  (38906, 'Mannarama', 3335, 1, 206),
  (38908, 'Matale', 3336, 1, 206),
  (38910, 'Matara', 3337, 1, 206),
  (38911, 'Weligama', 3337, 1, 206),
  (38915, 'Polonnaruwa', 3343, 1, 206),
  (38919, 'Ratnapuraya', 3345, 1, 206),
  (38922, 'Vavuniyawa', 3349, 1, 206),
  (38934, 'Maridi', 3359, 1, 211),
  (38936, 'Tambura', 3359, 1, 211),
  (38938, 'Bur', 3362, 1, 211),
  (38941, 'Kassala', 3363, 1, 211),
  (38944, 'Helsingborg', 3363, 1, 211),
  (38946, 'Barbar', 3364, 1, 211),
  (38948, 'Shandi', 3364, 1, 211),
  (38951, 'al-Matammah', 3364, 1, 211),
  (38952, 'Kapoeta', 3368, 1, 211),
  (38954, 'Abu Hijar', 3369, 1, 211),
  (38955, 'Galgani', 3369, 1, 211),
  (38956, 'Hajj \'Abdallah', 3369, 1, 211),
  (38958, 'Mayurnu', 3369, 1, 211),
  (38961, 'Sinnar-at-Tagatu', 3369, 1, 211),
  (38963, 'ad-Dindar', 3369, 1, 211),
  (38964, 'as-Suki', 3369, 1, 211),
  (38966, 'Tonj', 3370, 1, 211);
  INSERT INTO `cities` (`city_id`, `city_name`, `state_id`, `status`, `country_id`) VALUES
  (38967, 'Warab', 3370, 1, 211),
  (38968, 'Bur Sudan', 3372, 1, 211),
  (38970, 'Sawakin', 3372, 1, 211),
  (38973, 'Rumbik', 3373, 1, 211),
  (38975, 'Abu \'Usar', 3374, 1, 211),
  (38977, 'Maharaybah', 3374, 1, 211),
  (38978, 'Miallayab', 3374, 1, 211),
  (38979, 'Rufa\'a', 3374, 1, 211),
  (38980, 'Sharafat', 3374, 1, 211),
  (38981, 'Tabat', 3374, 1, 211),
  (38982, 'Tambul', 3374, 1, 211),
  (38983, 'Wad Madani', 3374, 1, 211),
  (38985, 'al-Hawsh', 3374, 1, 211),
  (38987, 'al-Huda', 3374, 1, 211),
  (38988, 'al-Husayhisah', 3374, 1, 211),
  (38989, 'al-Kamilin', 3374, 1, 211),
  (38990, 'al-Karaymat', 3374, 1, 211),
  (38991, 'al-Manaqil', 3374, 1, 211),
  (38995, 'Umm Durman', 3375, 1, 211),
  (38997, 'al-Khartum Bahri', 3375, 1, 211),
  (38999, 'Qala\'-an-Nahl', 3376, 1, 211),
  (39000, 'Shuwak', 3376, 1, 211),
  (39002, 'al-Hawatah', 3376, 1, 211),
  (39004, 'Bentiu', 3377, 1, 211),
  (39005, 'Ler', 3377, 1, 211),
  (39007, 'Bufi', 3378, 1, 211),
  (39009, 'Kinanah', 3378, 1, 211),
  (39011, 'Marabba', 3378, 1, 211),
  (39013, 'Shabashah', 3378, 1, 211),
  (39015, 'Umm Jarr', 3378, 1, 211),
  (39017, 'ad-Duwaym', 3378, 1, 211),
  (39019, 'al-Kawah', 3378, 1, 211),
  (39021, 'ad-Damazin', 3379, 1, 211),
  (39023, 'al-Quwaysi', 3379, 1, 211),
  (39025, 'Argu', 3380, 1, 211),
  (39027, 'Dunqulah', 3380, 1, 211),
  (39029, 'Karmah-an-Nuzul', 3380, 1, 211),
  (39031, 'Kurti', 3380, 1, 211),
  (39033, 'Tangasi-ar-Ru\'ays', 3380, 1, 211),
  (39035, 'ad-Dabbah', 3380, 1, 211),
  (39037, 'Brownsweg', 3381, 1, 211),
  (39039, 'Meerzorg', 3382, 1, 211),
  (39041, 'Totness', 3383, 1, 211),
  (39043, 'Umea', 3384, 1, 211),
  (39046, 'Onverwacht', 3386, 1, 211),
  (39049, 'Lelydorp', 3389, 1, 211),
  (39051, 'Hornsund', 3390, 1, 211),
  (39052, 'Isfjord Radio', 3390, 1, 211),
  (39054, 'Ny-Alesund', 3390, 1, 211),
  (39057, 'Mbabane', 3391, 1, 211),
  (39059, 'Pigg\'s Peak', 3391, 1, 211),
  (39061, 'Mhlume', 3392, 1, 211),
  (39062, 'Mpaka', 3392, 1, 211),
  (39066, 'Tshaneni', 3392, 1, 211),
  (39068, 'Kwaluseni', 3393, 1, 211),
  (39071, 'Mankayane', 3393, 1, 211),
  (39073, 'Matsapha', 3393, 1, 211),
  (39074, 'Mhlambanyatsi', 3393, 1, 211),
  (39076, 'Hlatikulu', 3394, 1, 211),
  (39077, 'Hluti', 3394, 1, 211),
  (39078, 'Kubuta', 3394, 1, 211),
  (39082, 'Karlstad', 3397, 1, 211),
  (39083, 'Ronneby', 3397, 1, 211),
  (39084, 'Stenungsund', 3398, 1, 211),
  (39085, 'Avesta', 3399, 1, 211),
  (39086, 'Borlange', 3399, 1, 211),
  (39087, 'Falun', 3399, 1, 211),
  (39088, 'Hedemora', 3399, 1, 211),
  (39089, 'Ludvika', 3399, 1, 211),
  (39096, 'Soderhamn', 3400, 1, 211),
  (39101, 'Halmstad', 3403, 1, 211),
  (39103, 'Varberg', 3403, 1, 211),
  (39106, 'Gislaved', 3405, 1, 211),
  (39109, 'Tranas', 3405, 1, 211),
  (39112, 'Blomstermala', 3406, 1, 211),
  (39116, 'Solna', 3406, 1, 211),
  (39122, 'Svedala', 3407, 1, 211),
  (39127, 'Lulea', 3409, 1, 211),
  (39132, 'Orebro', 3410, 1, 211),
  (39137, 'Mjolby', 3411, 1, 211),
  (39140, 'Vadstena', 3411, 1, 211),
  (39143, 'Boras', 3413, 1, 211),
  (39146, 'Hassleholm', 3413, 1, 211),
  (39149, 'Hoganas', 3413, 1, 211),
  (39154, 'Landskrona', 3413, 1, 211),
  (39158, 'Staffanstorp', 3413, 1, 211),
  (39162, 'Markaryd', 3414, 1, 211),
  (39166, 'Katrineholm', 3415, 1, 211),
  (39172, 'Gothenburg', 3416, 1, 211),
  (39175, 'Hallstavik', 3416, 1, 211),
  (39178, 'Lidingo', 3416, 1, 211),
  (39183, 'Rosersberg', 3416, 1, 211),
  (39186, 'Stockholm', 3416, 1, 211),
  (39190, 'Uppsala', 3416, 1, 211),
  (39195, 'Knivsta', 3417, 1, 211),
  (39197, 'Storvreta', 3417, 1, 211),
  (39204, 'Guglingen', 3419, 1, 211),
  (39209, 'Kallered', 3420, 1, 211),
  (39213, 'Ornskoldsvik', 3421, 1, 211),
  (39216, 'Fagersta', 3422, 1, 211),
  (39218, 'Koping', 3422, 1, 211),
  (39223, 'Baden', 3424, 1, 212),
  (39243, 'Lucerne', 3424, 1, 212),
  (39298, 'Bern', 3429, 1, 212),
  (39319, 'Spiez', 3429, 1, 212),
  (39322, 'Thun', 3429, 1, 212),
  (39337, 'Murten', 3431, 1, 212),
  (39361, 'Arosa', 3434, 1, 212),
  (39362, 'Lausanne', 3434, 1, 212),
  (39363, 'Davos', 3434, 1, 212),
  (39381, 'Kriens', 3438, 1, 212),
  (39394, 'Lugano', 3441, 1, 212),
  (39395, 'Saintmoritz', 3441, 1, 212),
  (39408, 'Schaffhausen', 3445, 1, 212),
  (39420, 'Zermatt', 3446, 1, 212),
  (39435, 'Solothurn', 3447, 1, 212),
  (39452, 'Ascona', 3449, 1, 212),
  (39453, 'Bellinzona', 3449, 1, 212),
  (39459, 'Locarno', 3449, 1, 212),
  (39473, 'Brig-Glis', 3451, 1, 212),
  (39478, 'Martigny', 3451, 1, 212),
  (39485, 'Sion', 3451, 1, 212),
  (39488, 'Zurich', 3451, 1, 212),
  (39504, 'Montreux', 3452, 1, 212),
  (39516, 'Vevey', 3452, 1, 212),
  (39824, 'Bangkhen', 3528, 1, 217),
  (39826, 'Phatumthanee', 3528, 1, 217),
  (39827, 'Bang Khla', 3530, 1, 217),
  (39829, 'Bangpakong', 3530, 1, 217),
  (39831, 'Phanom Sarakham', 3530, 1, 217),
  (39833, 'Bamnet Narong', 3532, 1, 217),
  (39835, 'Kaeng Khlo', 3532, 1, 217),
  (39838, 'Chanthaburi', 3534, 1, 217),
  (39840, 'Bangkok', 3534, 1, 217),
  (39842, 'Tha Mai', 3534, 1, 217),
  (39844, 'Lang Suan', 3538, 1, 217),
  (39846, 'Kalasin', 3539, 1, 217),
  (39848, 'Khao Wong', 3539, 1, 217),
  (39850, 'Nong Kung Si', 3539, 1, 217),
  (39852, 'Bo Phloi', 3541, 1, 217),
  (39854, 'Phanom Thuan', 3541, 1, 217),
  (39856, 'Tha Muang', 3541, 1, 217),
  (39858, 'Krabi', 3543, 1, 217),
  (39859, 'Lampang', 3545, 1, 217),
  (39861, 'Lamphun', 3546, 1, 217),
  (39862, 'Mae Tha', 3546, 1, 217),
  (39864, 'Loei', 3547, 1, 217),
  (39866, 'Wang Saphung', 3547, 1, 217),
  (39869, 'Nan', 3558, 1, 217),
  (39872, 'Rangae', 3559, 1, 217),
  (39874, 'Sungai Padi', 3559, 1, 217),
  (39876, 'Bang Bo Thong', 3562, 1, 217),
  (39878, 'Bang Yai', 3562, 1, 217),
  (39880, 'Pak Kret', 3562, 1, 217),
  (39883, 'Pattani', 3564, 1, 217),
  (39885, 'Yaring', 3564, 1, 217),
  (39887, 'Phatthalung', 3566, 1, 217),
  (39889, 'Dok Kham Tai', 3567, 1, 217),
  (39890, 'Phayao', 3567, 1, 217),
  (39892, 'Chon Daen', 3568, 1, 217),
  (39894, 'Nong Phai', 3568, 1, 217),
  (39896, 'Wichian Buri', 3568, 1, 217),
  (39898, 'Chiang Mai', 3569, 1, 217),
  (39900, 'Phetchaburi', 3569, 1, 217),
  (39902, 'Bang Mun Nak', 3570, 1, 217),
  (39904, 'Taphan Hin', 3570, 1, 217),
  (39905, 'Thap Khlo', 3570, 1, 217),
  (39906, 'Bang Krathum', 3571, 1, 217),
  (39908, 'Nakhon Thai', 3571, 1, 217),
  (39910, 'Den Chai', 3573, 1, 217),
  (39912, 'Phrae', 3573, 1, 217),
  (39914, 'Kathu', 3574, 1, 217),
  (39916, 'Ranong', 3577, 1, 217),
  (39917, 'Ban Pong', 3578, 1, 217),
  (39919, 'Chom Bung', 3578, 1, 217),
  (39921, 'Photharam', 3578, 1, 217),
  (39922, 'Ratchaburi', 3578, 1, 217),
  (39924, 'Klaeng', 3579, 1, 217),
  (39926, 'Pattaya', 3586, 1, 217),
  (39928, 'Nong Khae', 3586, 1, 217),
  (39929, 'Phra Phutthabat', 3586, 1, 217),
  (39930, 'Saraburi', 3586, 1, 217),
  (39932, 'Hat Yai', 3590, 1, 217),
  (39934, 'Sadao', 3590, 1, 217),
  (39936, 'Songkhla', 3590, 1, 217),
  (39938, 'Sawankhalok', 3591, 1, 217),
  (39940, 'Sukhothai', 3591, 1, 217),
  (39942, 'Surin', 3594, 1, 217),
  (39944, 'Mae Ramat', 3595, 1, 217),
  (39946, 'Tak', 3595, 1, 217),
  (39948, 'Kantang', 3596, 1, 217),
  (39951, 'Nakhon Ratchasima', 3597, 1, 217),
  (39954, 'Betong', 3602, 1, 217),
  (40253, 'Adana', 3663, 1, 223),
  (40255, 'Ceyhan', 3663, 1, 223),
  (40257, 'Imamoglu', 3663, 1, 223),
  (40259, 'Karatas', 3663, 1, 223),
  (40261, 'Pozanti', 3663, 1, 223),
  (40263, 'Tufanbeyli', 3663, 1, 223),
  (40266, 'Besni', 3664, 1, 223),
  (40268, 'Gerger', 3664, 1, 223),
  (40270, 'Kahta', 3664, 1, 223),
  (40272, 'Sincik', 3664, 1, 223),
  (40274, 'Afyonkarahisar', 3665, 1, 223),
  (40276, 'Bayat', 3665, 1, 223),
  (40278, 'Cay', 3665, 1, 223),
  (40280, 'Dinar', 3665, 1, 223),
  (40282, 'Evciler', 3665, 1, 223),
  (40284, 'Ihsaniye', 3665, 1, 223),
  (40286, 'Kiziloren', 3665, 1, 223),
  (40288, 'Sincanli', 3665, 1, 223),
  (40291, 'Diyadin', 3666, 1, 223),
  (40293, 'Eleskirt', 3666, 1, 223),
  (40295, 'Karakose', 3666, 1, 223),
  (40297, 'Taslicay', 3666, 1, 223),
  (40299, 'Agacoren', 3667, 1, 223),
  (40301, 'Eskil', 3667, 1, 223),
  (40304, 'Ortakoy', 3667, 1, 223),
  (40306, 'Amasya', 3668, 1, 223),
  (40308, 'Gumushacikoy', 3668, 1, 223),
  (40310, 'Merzifon', 3668, 1, 223),
  (40312, 'Tasova', 3668, 1, 223),
  (40314, 'Ankara', 3669, 1, 223),
  (40317, 'Camlidere', 3669, 1, 223),
  (40319, 'Elmadag', 3669, 1, 223),
  (40321, 'Gudul', 3669, 1, 223),
  (40323, 'Kalecik', 3669, 1, 223),
  (40325, 'Kizilcahamam', 3669, 1, 223),
  (40327, 'Polatli', 3669, 1, 223),
  (40331, 'Alanya', 3670, 1, 223),
  (40333, 'Elmali', 3670, 1, 223),
  (40335, 'Gazipasa', 3670, 1, 223),
  (40337, 'Ibradi', 3670, 1, 223),
  (40339, 'Kas', 3670, 1, 223),
  (40341, 'Konya', 3670, 1, 223),
  (40345, 'Serik', 3670, 1, 223),
  (40347, 'Damal', 3671, 1, 223),
  (40349, 'Hanak', 3671, 1, 223),
  (40351, 'Ardanuc', 3672, 1, 223),
  (40353, 'Artvin', 3672, 1, 223),
  (40355, 'Hopa', 3672, 1, 223),
  (40359, 'Aydin', 3673, 1, 223),
  (40361, 'Buharkent', 3673, 1, 223),
  (40363, 'Didim', 3673, 1, 223),
  (40365, 'Incirliova', 3673, 1, 223),
  (40367, 'Karpuzlu', 3673, 1, 223),
  (40369, 'Kosk', 3673, 1, 223),
  (40371, 'Kuyucak', 3673, 1, 223),
  (40373, 'Soke', 3673, 1, 223),
  (40375, 'Yenipazar', 3673, 1, 223),
  (40377, 'Balikesir', 3674, 1, 223),
  (40379, 'Bandirma', 3674, 1, 223),
  (40381, 'Burhaniye', 3674, 1, 223),
  (40385, 'Gomec', 3674, 1, 223),
  (40387, 'Havran', 3674, 1, 223),
  (40389, 'Kepsut', 3674, 1, 223),
  (40391, 'Marmara', 3674, 1, 223),
  (40393, 'Savastepe', 3674, 1, 223),
  (40395, 'Susurluk', 3674, 1, 223),
  (40398, 'Kurucasile', 3675, 1, 223),
  (40400, 'Batman', 3676, 1, 223),
  (40402, 'Gercus', 3676, 1, 223),
  (40404, 'Kozluk', 3676, 1, 223),
  (40406, 'Aydintepe', 3677, 1, 223),
  (40408, 'Demirozu', 3677, 1, 223),
  (40410, 'Bozuyuk', 3678, 1, 223),
  (40412, 'Inhisar', 3678, 1, 223),
  (40414, 'Pazaryeri', 3678, 1, 223),
  (40416, 'Yenipazar', 3678, 1, 223),
  (40418, 'Bingol', 3679, 1, 223),
  (40420, 'Karliova', 3679, 1, 223),
  (40422, 'Solhan', 3679, 1, 223),
  (40424, 'Yedisu', 3679, 1, 223),
  (40426, 'Ahlat', 3680, 1, 223),
  (40428, 'Guroymak', 3680, 1, 223),
  (40430, 'Mutki', 3680, 1, 223),
  (40432, 'Akcakoca', 3681, 1, 223),
  (40434, 'Dortdivan', 3681, 1, 223),
  (40436, 'Goynuk', 3681, 1, 223),
  (40438, 'Mengen', 3681, 1, 223),
  (40440, 'Seben', 3681, 1, 223),
  (40442, 'Aglasun', 3682, 1, 223),
  (40444, 'Bucak', 3682, 1, 223),
  (40450, 'Yesilova', 3682, 1, 223),
  (40452, 'Buyukorhan', 3683, 1, 223),
  (40454, 'Gursu', 3683, 1, 223),
  (40456, 'Inegol', 3683, 1, 223),
  (40458, 'Karacabey', 3683, 1, 223),
  (40460, 'Kestel', 3683, 1, 223),
  (40462, 'Mustafakemalpasa', 3683, 1, 223),
  (40464, 'Orhangazi', 3683, 1, 223),
  (40466, 'Ayvacik', 3684, 1, 223),
  (40468, 'Biga', 3684, 1, 223),
  (40470, 'Can', 3684, 1, 223),
  (40472, 'Eceabat', 3684, 1, 223),
  (40476, 'Lapseki', 3684, 1, 223),
  (40478, 'Atkaracalar', 3685, 1, 223),
  (40480, 'Cankiri', 3685, 1, 223),
  (40482, 'Eldivan', 3685, 1, 223),
  (40484, 'Kizilirmak', 3685, 1, 223),
  (40486, 'Kursunlu', 3685, 1, 223),
  (40490, 'Alaca', 3686, 1, 223),
  (40492, 'Corum', 3686, 1, 223),
  (40494, 'Iskilip', 3686, 1, 223),
  (40496, 'Lacin', 3686, 1, 223),
  (40498, 'Oguzlar', 3686, 1, 223),
  (40500, 'Osmancik', 3686, 1, 223),
  (40503, 'Acipayam', 3687, 1, 223),
  (40505, 'Babadag', 3687, 1, 223),
  (40507, 'Bekilli', 3687, 1, 223),
  (40509, 'Buldan', 3687, 1, 223),
  (40511, 'Civril', 3687, 1, 223),
  (40513, 'Guney', 3687, 1, 223),
  (40515, 'Kale', 3687, 1, 223),
  (40517, 'Serinhisar', 3687, 1, 223),
  (40519, 'Bismil', 3688, 1, 223),
  (40521, 'Cinar', 3688, 1, 223),
  (40523, 'Dicle', 3688, 1, 223),
  (40525, 'Egil', 3688, 1, 223),
  (40527, 'Hani', 3688, 1, 223),
  (40529, 'Kocakoy', 3688, 1, 223),
  (40531, 'Lice', 3688, 1, 223),
  (40533, 'Cumayeri', 3689, 1, 223),
  (40535, 'Golyaka', 3689, 1, 223),
  (40537, 'Kaynasli', 3689, 1, 223),
  (40538, 'Yigilca', 3689, 1, 223),
  (40540, 'Enez', 3690, 1, 223),
  (40542, 'Ipsala', 3690, 1, 223),
  (40544, 'Lalapasa', 3690, 1, 223),
  (40546, 'Suleoglu', 3690, 1, 223),
  (40548, 'Agin', 3691, 1, 223),
  (40550, 'Aricak', 3691, 1, 223),
  (40552, 'Elazig', 3691, 1, 223),
  (40554, 'Keban', 3691, 1, 223),
  (40556, 'Maden', 3691, 1, 223),
  (40558, 'Sivrice', 3691, 1, 223),
  (40560, 'Ilic', 3692, 1, 223),
  (40563, 'Otlukbeli', 3692, 1, 223),
  (40565, 'Tercan', 3692, 1, 223),
  (40567, 'Askale', 3693, 1, 223),
  (40569, 'Hinis', 3693, 1, 223),
  (40571, 'Ilica', 3693, 1, 223),
  (40573, 'Karacoban', 3693, 1, 223),
  (40575, 'Koprukoy', 3693, 1, 223),
  (40577, 'Oltu', 3693, 1, 223),
  (40579, 'Pasinler', 3693, 1, 223),
  (40581, 'Senkaya', 3693, 1, 223),
  (40583, 'Tortum', 3693, 1, 223),
  (40585, 'Alpu', 3694, 1, 223),
  (40587, 'Cifteler', 3694, 1, 223),
  (40589, 'Gunyuzu', 3694, 1, 223),
  (40591, 'Inonu', 3694, 1, 223),
  (40593, 'Mihalgazi', 3694, 1, 223),
  (40595, 'Saricakaya', 3694, 1, 223),
  (40597, 'Sivrihisar', 3694, 1, 223),
  (40599, 'Gaziantep', 3695, 1, 223),
  (40601, 'Karkamis', 3695, 1, 223),
  (40603, 'Nurdagi', 3695, 1, 223),
  (40605, 'Sehitkamil', 3695, 1, 223),
  (40607, 'Aluca', 3696, 1, 223),
  (40609, 'Dereli', 3696, 1, 223),
  (40612, 'Eynesil', 3696, 1, 223),
  (40614, 'Gorele', 3696, 1, 223),
  (40616, 'Kesap', 3696, 1, 223),
  (40618, 'Sebinkarahisar', 3696, 1, 223),
  (40620, 'Yaglidere', 3696, 1, 223),
  (40622, 'Kelkit', 3697, 1, 223),
  (40624, 'Kurtun', 3697, 1, 223),
  (40626, 'Torul', 3697, 1, 223),
  (40628, 'Hakkari', 3698, 1, 223),
  (40630, 'Yuksekova', 3698, 1, 223),
  (40632, 'Antakya', 3699, 1, 223),
  (40634, 'Dortyol', 3699, 1, 223),
  (40636, 'Hassa', 3699, 1, 223),
  (40638, 'Kirikhan', 3699, 1, 223),
  (40640, 'Reyhanli', 3699, 1, 223),
  (40642, 'Yayladagi', 3699, 1, 223),
  (40644, 'Aydincik', 3700, 1, 223),
  (40646, 'Erdemli', 3700, 1, 223),
  (40648, 'Mersin', 3700, 1, 223),
  (40650, 'Silifke', 3700, 1, 223),
  (40652, 'Aralik', 3701, 1, 223),
  (40654, 'Karakoyunlu', 3701, 1, 223),
  (40656, 'Aksu', 3702, 1, 223),
  (40658, 'Egirdir', 3702, 1, 223),
  (40660, 'Gonen', 3702, 1, 223),
  (40662, 'Keciborlu', 3702, 1, 223),
  (40664, 'Senirkent', 3702, 1, 223),
  (40666, 'Uluborlu', 3702, 1, 223),
  (40668, 'Yenisarbademli', 3702, 1, 223),
  (40670, 'Catalca', 3703, 1, 223),
  (40673, 'Istanbul', 3703, 1, 223),
  (40675, 'Sile', 3703, 1, 223),
  (40677, 'Sultanbeyli', 3703, 1, 223),
  (40679, 'Tuzla', 3703, 1, 223),
  (40681, 'Aliaga', 3704, 1, 223),
  (40683, 'Bayindir', 3704, 1, 223),
  (40686, 'Bornova', 3704, 1, 223),
  (40688, 'Digor', 3704, 1, 223),
  (40690, 'Foca', 3704, 1, 223),
  (40692, 'Karaburun', 3704, 1, 223),
  (40694, 'Kinik', 3704, 1, 223),
  (40696, 'Menderes', 3704, 1, 223),
  (40698, 'Merkezi', 3704, 1, 223),
  (40700, 'Odemis', 3704, 1, 223),
  (40702, 'Selcuk', 3704, 1, 223),
  (40704, 'Torbali', 3704, 1, 223),
  (40706, 'Afsin', 3705, 1, 223),
  (40708, 'Caglayancerit', 3705, 1, 223),
  (40710, 'Elbistan', 3705, 1, 223),
  (40712, 'Kahramanmaras', 3705, 1, 223),
  (40714, 'Pazarcik', 3705, 1, 223),
  (40716, 'Eflani', 3706, 1, 223),
  (40718, 'Karabuk', 3706, 1, 223),
  (40720, 'Safranbolu', 3706, 1, 223),
  (40723, 'Basyayla', 3707, 1, 223),
  (40725, 'Karaman', 3707, 1, 223),
  (40727, 'Sariveliler', 3707, 1, 223),
  (40729, 'Arpacay', 3708, 1, 223),
  (40731, 'Kars', 3708, 1, 223),
  (40733, 'Selim', 3708, 1, 223),
  (40735, 'Karsiyaka', 3709, 1, 223),
  (40737, 'Agli', 3710, 1, 223),
  (40739, 'Azdavay', 3710, 1, 223),
  (40741, 'Daday', 3710, 1, 223),
  (40743, 'Doganyurt', 3710, 1, 223),
  (40745, 'Ihsangazi', 3710, 1, 223),
  (40748, 'Kure', 3710, 1, 223),
  (40750, 'Senpazar', 3710, 1, 223),
  (40752, 'Taskopru', 3710, 1, 223),
  (40754, 'Akkisla', 3711, 1, 223),
  (40756, 'Develi', 3711, 1, 223),
  (40758, 'Hacilar', 3711, 1, 223),
  (40760, 'Kayseri', 3711, 1, 223),
  (40762, 'Pinarbasi', 3711, 1, 223),
  (40764, 'Sariz', 3711, 1, 223),
  (40766, 'Tomarza', 3711, 1, 223),
  (40768, 'Yesilhisar', 3711, 1, 223),
  (40770, 'Kilis', 3712, 1, 223),
  (40772, 'Polateli', 3712, 1, 223),
  (40774, 'Baliseyh', 3713, 1, 223),
  (40776, 'Karakecili', 3713, 1, 223),
  (40778, 'Kirikkale', 3713, 1, 223),
  (40780, 'Yahsihan', 3713, 1, 223),
  (40782, 'Demirkoy', 3714, 1, 223),
  (40784, 'Kofcaz', 3714, 1, 223),
  (40786, 'Luleburgaz', 3714, 1, 223),
  (40788, 'Pinarhisar', 3714, 1, 223),
  (40790, 'Akcakent', 3715, 1, 223),
  (40792, 'Boztepe', 3715, 1, 223),
  (40794, 'Kirsehir', 3715, 1, 223),
  (40797, 'Derince', 3716, 1, 223),
  (40799, 'Gebze', 3716, 1, 223),
  (40801, 'Izmit', 3716, 1, 223),
  (40803, 'Karamursel', 3716, 1, 223),
  (40805, 'Korfez', 3716, 1, 223),
  (40807, 'Akoren', 3717, 1, 223),
  (40809, 'Altinekin', 3717, 1, 223),
  (40811, 'Bozkir', 3717, 1, 223),
  (40813, 'Cumra', 3717, 1, 223),
  (40815, 'Derebucak', 3717, 1, 223),
  (40817, 'Emirgazi', 3717, 1, 223),
  (40819, 'Guneysinir', 3717, 1, 223),
  (40821, 'Halkapinar', 3717, 1, 223),
  (40823, 'Ilgin', 3717, 1, 223),
  (40825, 'Karapinar', 3717, 1, 223),
  (40827, 'Kulu', 3717, 1, 223),
  (40829, 'Seydisehir', 3717, 1, 223),
  (40831, 'Tuzlukcu', 3717, 1, 223),
  (40833, 'Yunak', 3717, 1, 223),
  (40835, 'Aslanapa', 3718, 1, 223),
  (40837, 'Dumlupinar', 3718, 1, 223),
  (40839, 'Gediz', 3718, 1, 223),
  (40841, 'Pazarlar', 3718, 1, 223),
  (40843, 'Simav', 3718, 1, 223),
  (40846, 'Akcadag', 3720, 1, 223),
  (40848, 'Arguvan', 3720, 1, 223),
  (40850, 'Darende', 3720, 1, 223),
  (40852, 'Doganyol', 3720, 1, 223),
  (40854, 'Kale', 3720, 1, 223),
  (40856, 'Malatya', 3720, 1, 223),
  (40858, 'Yazihan', 3720, 1, 223),
  (40860, 'Ahmetli', 3721, 1, 223),
  (40862, 'Alasehir', 3721, 1, 223),
  (40864, 'Golmarmara', 3721, 1, 223),
  (40866, 'Kirkagac', 3721, 1, 223),
  (40868, 'Kula', 3721, 1, 223),
  (40871, 'Sarigol', 3721, 1, 223),
  (40873, 'Selendi', 3721, 1, 223),
  (40875, 'Turgutlu', 3721, 1, 223),
  (40877, 'Derik', 3722, 1, 223),
  (40879, 'Mardin', 3722, 1, 223),
  (40881, 'Midyat', 3722, 1, 223),
  (40885, 'Yesilli', 3722, 1, 223),
  (40887, 'Dalaman', 3723, 1, 223),
  (40889, 'Fethiye', 3723, 1, 223),
  (40891, 'Koycegiz', 3723, 1, 223),
  (40893, 'Milas', 3723, 1, 223),
  (40895, 'Ortaca', 3723, 1, 223),
  (40899, 'Haskoy', 3724, 1, 223),
  (40901, 'Malazgirt', 3724, 1, 223),
  (40903, 'Varto', 3724, 1, 223),
  (40905, 'Avanos', 3725, 1, 223),
  (40907, 'Gulsehir', 3725, 1, 223),
  (40909, 'Kozakli', 3725, 1, 223),
  (40914, 'Nigde', 3726, 1, 223),
  (40916, 'Akkus', 3727, 1, 223),
  (40918, 'Camas', 3727, 1, 223),
  (40920, 'Golkoy', 3727, 1, 223),
  (40922, 'Gurgentepe', 3727, 1, 223),
  (40924, 'Kabaduz', 3727, 1, 223),
  (40927, 'Kumru', 3727, 1, 223),
  (40929, 'Ordu', 3727, 1, 223),
  (40931, 'Ulubey', 3727, 1, 223),
  (40933, 'Bahce', 3728, 1, 223),
  (40935, 'Hasanbeyli', 3728, 1, 223),
  (40937, 'Osmaniye', 3728, 1, 223),
  (40941, 'Cayeli', 3729, 1, 223),
  (40943, 'Findikli', 3729, 1, 223),
  (40945, 'Hemsin', 3729, 1, 223),
  (40947, 'Iyidere', 3729, 1, 223),
  (40949, 'Pazar', 3729, 1, 223),
  (40951, 'Adapazari', 3730, 1, 223),
  (40955, 'Hendek', 3730, 1, 223),
  (40957, 'Karasu', 3730, 1, 223),
  (40959, 'Kocaali', 3730, 1, 223),
  (40961, 'Sapanca', 3730, 1, 223),
  (40963, 'Tarakli', 3730, 1, 223),
  (40965, 'Alacam', 3731, 1, 223),
  (40968, 'Bafra', 3731, 1, 223),
  (40970, 'Havza', 3731, 1, 223),
  (40972, 'Ladik', 3731, 1, 223),
  (40974, 'Salipazan', 3731, 1, 223),
  (40976, 'Tekkekoy', 3731, 1, 223),
  (40978, 'Vezirkopru', 3731, 1, 223),
  (40981, 'Bozova', 3732, 1, 223),
  (40983, 'Halfeti', 3732, 1, 223),
  (40985, 'Hilvan', 3732, 1, 223),
  (40987, 'Siverek', 3732, 1, 223),
  (40989, 'Urfa', 3732, 1, 223),
  (40991, 'Aydinlar', 3733, 1, 223),
  (40994, 'Kurtalan', 3733, 1, 223),
  (40996, 'Siirt', 3733, 1, 223),
  (40998, 'Ayancik', 3734, 1, 223),
  (41000, 'Dikmen', 3734, 1, 223),
  (41002, 'Erfelek', 3734, 1, 223),
  (41004, 'Sarayduzu', 3734, 1, 223),
  (41009, 'Guclukonak', 3735, 1, 223),
  (41011, 'Silopi', 3735, 1, 223),
  (41013, 'Uludere', 3735, 1, 223),
  (41015, 'Altinyayla', 3736, 1, 223),
  (41017, 'Dogansar', 3736, 1, 223),
  (41019, 'Golova', 3736, 1, 223),
  (41023, 'Kangal', 3736, 1, 223),
  (41025, 'Sarkisla', 3736, 1, 223),
  (41027, 'Susehri', 3736, 1, 223),
  (41029, 'Yildizeli', 3736, 1, 223),
  (41031, 'Cerkezkoy', 3737, 1, 223),
  (41033, 'Hayrabolu', 3737, 1, 223),
  (41036, 'Muratli', 3737, 1, 223),
  (41038, 'Sarkoy', 3737, 1, 223),
  (41040, 'Almus', 3738, 1, 223),
  (41042, 'Basciftlik', 3738, 1, 223),
  (41044, 'Niksar', 3738, 1, 223),
  (41046, 'Resadiye', 3738, 1, 223),
  (41050, 'Yesilyurt', 3738, 1, 223),
  (41052, 'Akcaabat', 3739, 1, 223),
  (41054, 'Arsin', 3739, 1, 223),
  (41056, 'Caykara', 3739, 1, 223),
  (41058, 'Duzkoy', 3739, 1, 223),
  (41060, 'Koprubasi', 3739, 1, 223),
  (41063, 'Salpazari', 3739, 1, 223),
  (41065, 'Tonya', 3739, 1, 223),
  (41067, 'Vakfikebir', 3739, 1, 223),
  (41069, 'Hozat', 3740, 1, 223),
  (41071, 'Nazimiye', 3740, 1, 223),
  (41073, 'Pertek', 3740, 1, 223),
  (41074, 'Pulumur', 3740, 1, 223),
  (41076, 'Banaz', 3741, 1, 223),
  (41078, 'Karahalli', 3741, 1, 223),
  (41080, 'Ulubey', 3741, 1, 223),
  (41082, 'Bahcesaray', 3742, 1, 223),
  (41084, 'Caldiran', 3742, 1, 223),
  (41088, 'Gurpinar', 3742, 1, 223),
  (41090, 'Ozalp', 3742, 1, 223),
  (41092, 'Van', 3742, 1, 223),
  (41094, 'Armutlu', 3743, 1, 223),
  (41096, 'Cinarcik', 3743, 1, 223),
  (41098, 'Yalova', 3743, 1, 223),
  (41102, 'Candir', 3744, 1, 223),
  (41104, 'Cekerek', 3744, 1, 223),
  (41106, 'Saraykent', 3744, 1, 223),
  (41108, 'Sefaatli', 3744, 1, 223),
  (41110, 'Yenifakili', 3744, 1, 223),
  (41112, 'Yozgat', 3744, 1, 223),
  (41181, 'Bombo', 3762, 1, 227),
  (41184, 'Jinja-Kawempe', 3762, 1, 227),
  (41187, 'Kampala', 3762, 1, 227),
  (41191, 'Kyotera', 3762, 1, 227),
  (41194, 'Luwero', 3762, 1, 227),
  (41197, 'Mityana', 3762, 1, 227),
  (41199, 'Mubende', 3762, 1, 227),
  (41203, 'Njeru', 3762, 1, 227),
  (41205, 'Rakai', 3762, 1, 227),
  (41207, 'Wakiso', 3762, 1, 227),
  (41209, 'Bugembe', 3763, 1, 227),
  (41214, 'Iganga', 3763, 1, 227),
  (41216, 'Kaberamaido', 3763, 1, 227),
  (41219, 'Katakwi', 3763, 1, 227),
  (41221, 'Malaba', 3763, 1, 227),
  (41226, 'Sironko', 3763, 1, 227),
  (41230, 'Amudat', 3764, 1, 227),
  (41232, 'Arua', 3764, 1, 227),
  (41234, 'Kaabong', 3764, 1, 227),
  (41237, 'Kotido', 3764, 1, 227),
  (41239, 'Moroto', 3764, 1, 227),
  (41240, 'Moyo', 3764, 1, 227),
  (41242, 'Nebbi', 3764, 1, 227),
  (41244, 'Paidha', 3764, 1, 227),
  (41271, 'Cherkasy', 3766, 1, 228),
  (41273, 'Uman\'', 3766, 1, 228),
  (41275, 'Nizhyn', 3767, 1, 228),
  (41278, 'Alushta', 3769, 1, 228),
  (41281, 'Dnipropetrovsk', 3770, 1, 228),
  (41284, 'Nikopol\'', 3770, 1, 228),
  (41287, 'Plekhanov', 3770, 1, 228),
  (41289, 'Artemivs\'k', 3771, 1, 228),
  (41291, 'Donetsk', 3771, 1, 228),
  (41293, 'Dymytrov', 3771, 1, 228),
  (41295, 'Horlivka', 3771, 1, 228),
  (41297, 'Kostyantynivka', 3771, 1, 228),
  (41299, 'Krasnoarmiys\'k', 3771, 1, 228),
  (41301, 'Mariupol\'', 3771, 1, 228),
  (41303, 'Slov\'yans\'k', 3771, 1, 228),
  (41305, 'Torez', 3771, 1, 228),
  (41307, 'Ivano-Frankivs\'k', 3772, 1, 228),
  (41310, 'Izyum', 3773, 1, 228),
  (41312, 'Lozova', 3773, 1, 228),
  (41315, 'Nova Kakhovka', 3775, 1, 228),
  (41318, 'Khmel\'nyts\'kyy', 3776, 1, 228),
  (41321, 'Kirovohrad', 3777, 1, 228),
  (41323, 'Svidlovodsk', 3777, 1, 228),
  (41326, 'Kerch', 3778, 1, 228),
  (41329, 'Yevpatoriya', 3778, 1, 228),
  (41331, 'Kyyiv', 3779, 1, 228),
  (41333, 'Boryspil\'', 3780, 1, 228),
  (41336, 'Chervonohrad', 3781, 1, 228),
  (41338, 'L\'viv', 3781, 1, 228),
  (41341, 'Alchevs\'k', 3782, 1, 228),
  (41345, 'Krasnyy Luch', 3782, 1, 228),
  (41348, 'Lysychans\'k', 3782, 1, 228),
  (41350, 'Roven\'ky', 3782, 1, 228),
  (41353, 'Sverdlovs\'k', 3782, 1, 228),
  (41355, 'Mykolayiv', 3783, 1, 228),
  (41357, 'Bilhorod-Dnistrovs\'kyy', 3784, 1, 228),
  (41360, 'Odesa', 3784, 1, 228),
  (41364, 'Lubny', 3786, 1, 228),
  (41367, 'Konotop', 3789, 1, 228),
  (41371, 'Sumy', 3789, 1, 228),
  (41374, 'Luts\'k', 3791, 1, 228),
  (41376, 'Vinnitsa', 3792, 1, 228),
  (41378, 'Mukacheve', 3793, 1, 228),
  (41380, 'Berdyans\'k', 3794, 1, 228),
  (41384, 'Berdychiv', 3795, 1, 228),
  (41447, 'Bourne End', 3816, 1, 230),
  (41457, 'Cambridge', 3817, 1, 230),
  (41460, 'Peterborough', 3817, 1, 230),
  (41523, 'Chesterfield', 3829, 1, 230),
  (41528, 'Derby', 3830, 1, 230),
  (41542, 'Dartmouth', 3831, 1, 230),
  (41544, 'Exeter', 3831, 1, 230),
  (41552, 'Plymouth', 3831, 1, 230),
  (41597, 'Bath', 3842, 1, 230),
  (41613, 'Birmingham', 3842, 1, 230),
  (41617, 'Blackpool', 3842, 1, 230),
  (41625, 'Bournemouth', 3842, 1, 230),
  (41627, 'Bradford', 3842, 1, 230),
  (41636, 'Bristol', 3842, 1, 230),
  (41665, 'Chester', 3842, 1, 230),
  (41702, 'Durham', 3842, 1, 230),
  (41763, 'Hereford', 3842, 1, 230),
  (41777, 'Hove', 3842, 1, 230),
  (41803, 'Leeds', 3842, 1, 230),
  (41804, 'Leicester', 3842, 1, 230),
  (41811, 'Lincoln', 3842, 1, 230),
  (41814, 'Liverpool', 3842, 1, 230),
  (41816, 'London', 3842, 1, 230),
  (41831, 'Manchester', 3842, 1, 230),
  (41851, 'Newcastle upon Tyne', 3842, 1, 230),
  (41863, 'Norwich', 3842, 1, 230),
  (41864, 'Nottingham', 3842, 1, 230),
  (41872, 'Oxford', 3842, 1, 230),
  (41880, 'Portsmouth', 3842, 1, 230),
  (41910, 'Salford', 3842, 1, 230),
  (41916, 'Sheffield', 3842, 1, 230),
  (41927, 'South Shields', 3842, 1, 230),
  (42013, 'Wolverhampton', 3842, 1, 230),
  (42015, 'Worcester', 3842, 1, 230),
  (42021, 'York', 3842, 1, 230),
  (42085, 'South Harting', 3851, 1, 230),
  (42086, 'Southampton', 3851, 1, 230),
  (42154, 'Glasgow', 3861, 1, 230),
  (42272, 'Abergavenny', 3874, 1, 230),
  (42348, 'Aberdeen', 3889, 1, 230),
  (42377, 'Dundee', 3889, 1, 230),
  (42382, 'Edinburgh', 3889, 1, 230),
  (42464, 'Stoke on Trent', 3897, 1, 230),
  (42488, 'Kingston Upon Thames', 3900, 1, 230),
  (42504, 'Brighton', 3901, 1, 230),
  (42520, 'Cardiff', 3906, 1, 230),
  (42553, 'Swansea', 3906, 1, 230),
  (42557, 'Coventry', 3907, 1, 230),
  (42576, 'Salisbury', 3913, 1, 230),
  (42633, 'Jacksonville', 3919, 1, 231),
  (42727, 'Phoenix', 3921, 1, 231),
  (42746, 'Tucson', 3921, 1, 231),
  (42852, 'Bostonia', 3924, 1, 231),
  (43067, 'Long Beach', 3924, 1, 231),
  (43070, 'Los Angeles', 3924, 1, 231),
  (43071, 'Los Angeles East', 3924, 1, 231),
  (43228, 'Sacramento', 3924, 1, 231),
  (43236, 'San Diego', 3924, 1, 231),
  (43242, 'San Jose', 3924, 1, 231),
  (43408, 'Denver', 3926, 1, 231),
  (43432, 'Louisville', 3926, 1, 231),
  (43769, 'Miami', 3930, 1, 231),
  (43809, 'Orlando', 3930, 1, 231),
  (43929, 'Atlanta', 3931, 1, 231),
  (43962, 'Dallas', 3931, 1, 231),
  (43963, 'Dalton', 3931, 1, 231),
  (44039, 'Savannah', 3931, 1, 231),
  (44072, 'Honolulu', 3932, 1, 231),
  (44173, 'Chicago', 3934, 1, 231),
  (44373, 'Washington', 3934, 1, 231),
  (44429, 'Indianapolis', 3935, 1, 231),
  (44545, 'Kansas City', 3937, 1, 231),
  (44555, 'Minneapolis', 3937, 1, 231),
  (44685, 'New Orleans', 3939, 1, 231),
  (44757, 'Baltimore', 3942, 1, 231),
  (44918, 'Boston', 3943, 1, 231),
  (45100, 'Charlotte', 3945, 1, 231),
  (45114, 'Detroit', 3945, 1, 231),
  (45221, 'Saint Louis', 3945, 1, 231),
  (45299, 'Houston', 3946, 1, 231),
  (45568, 'Omaha', 3950, 1, 231),
  (45577, 'Las Vegas', 3951, 1, 231),
  (45645, 'Cincinnati', 3959, 1, 231),
  (45647, 'Cleveland', 3959, 1, 231),
  (45726, 'New Philadelphia', 3959, 1, 231),
  (45850, 'Oklahoma City', 3960, 1, 231),
  (45913, 'Milwaukie', 3962, 1, 231),
  (45923, 'Portland', 3962, 1, 231),
  (45982, 'Columbia', 3963, 1, 231),
  (46113, 'Philadelphia', 3963, 1, 231),
  (46115, 'Phoenixville', 3963, 1, 231),
  (46117, 'Pittsburgh', 3963, 1, 231),
  (46242, 'Memphis', 3969, 1, 231),
  (46322, 'Columbus', 3970, 1, 231),
  (46348, 'El Paso', 3970, 1, 231),
  (46359, 'Fort Worth', 3970, 1, 231),
  (46488, 'San Antonio', 3970, 1, 231),
  (46661, 'Charlottesville', 3974, 1, 231),
  (46875, 'Seattle', 3975, 1, 231),
  (46990, 'Saint Francis', 3977, 1, 231),
  (47668, 'West New York', 3953, 1, 231),
  (47669, 'Washington Township', 3953, 1, 231),
  (48019, 'New York', 3956, 1, 231),
  (48133, 'Raleigh', 3957, 1, 231),
  (48225, 'Charlestown', 3965, 1, 231),
  (51101, 'Dubai', 0, 1, 239),
  (51102, 'Fujairah', 0, 1, 239),
  (51103, 'Sharjah', 0, 1, 239),
  (51104, 'Abudhabi', 0, 1, 239),
  (51105, 'Turin', 0, 1, 242),
  (51106, 'Bergamo', 0, 1, 242),
  (51107, 'Milan', 0, 1, 242),
  (51108, 'Mantua', 0, 1, 242),
  (51109, 'Genoa', 0, 1, 242),
  (51110, 'Parma', 0, 1, 242),
  (51111, 'Trieste', 0, 1, 242),
  (51112, 'Verona', 0, 1, 242),
  (51113, 'Auckland', 0, 1, 243),
  (51114, 'Wellington', 0, 1, 243),
  (51115, 'Christchurch', 0, 1, 243),
  (51116, 'Hamilton', 0, 1, 243),
  (51117, 'Tauranga', 0, 1, 243),
  (51118, 'Dunedin', 0, 1, 243),
  (51119, 'Palmer Stonnorth', 0, 1, 243),
  (51120, 'Nelson', 0, 1, 243),
  (51121, 'Liverpool', 0, 1, 244),
  (51122, 'Manchester', 0, 1, 244),
  (51123, 'Birmingham', 0, 1, 244),
  (51124, 'Bristol', 0, 1, 244),
  (51125, 'Seoul', 0, 1, 245),
  (51126, 'Busan', 0, 1, 245),
  (51127, 'Jejudo', 0, 1, 245),
  (51128, 'Gyeongju', 0, 1, 245),
  (51129, 'Gangneung', 0, 1, 245),
  (51130, 'Chuncheon', 0, 1, 245),
  (51131, 'Jeonju', 0, 1, 245),
  (51132, 'Suwon', 0, 1, 245),
  (51133, 'Manila', 0, 1, 246),
  (51134, 'Tagaytay', 0, 1, 246),
  (51135, 'Bohol', 0, 1, 246),
  (51136, 'Vigan', 0, 1, 246),
  (51137, 'Tuguegarao', 0, 1, 246),
  (51138, 'Santa Rosa', 0, 1, 246),
  (51139, 'Laoag', 0, 1, 246),
  (51140, 'Tagbilaran', 0, 1, 246),
  (51141, 'Amsterdam', 0, 1, 247),
  (51142, 'Utrecht', 0, 1, 247),
  (51143, 'Delft', 0, 1, 247),
  (51144, 'Alkmaar', 0, 1, 247),
  (51145, 'Volendam', 0, 1, 247),
  (51146, 'Leeuwarden', 0, 1, 247),
  (51147, 'Kinderdijk', 0, 1, 247),
  (51148, 'Zandvoort', 0, 1, 247),
  (51149, 'Middelburg', 0, 1, 247),
  (51150, 'Enkhuizen', 0, 1, 247),
  (51151, 'Hoorn', 0, 1, 247),
  (51152, 'Harlingen', 0, 1, 247);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `countries`
  --
  
  CREATE TABLE `countries` (
    `country_id` int(11) NOT NULL,
    `sortname` varchar(10) NOT NULL,
    `country_name` varchar(150) NOT NULL,
    `phonecode` int(11) DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1'
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `countries`
  --
  
  INSERT INTO `countries` (`country_id`, `sortname`, `country_name`, `phonecode`, `status`) VALUES
  (10, 'ar', 'Argentina', 54, 1),
  (14, 'at', 'Austria', 43, 1),
  (18, 'bd', 'Bangladesh', 880, 1),
  (20, 'by', 'Belarus', 375, 1),
  (21, 'be', 'Belgium', 32, 1),
  (26, 'bo', 'Bolivia', 591, 1),
  (30, 'br', 'Brazil', 55, 1),
  (33, 'bg', 'Bulgaria', 359, 1),
  (36, 'kh', 'Cambodia', 855, 1),
  (38, 'ca', 'Canada', 1, 1),
  (44, 'cn', 'China', 86, 1),
  (47, 'co', 'Colombia', 57, 1),
  (56, 'cy', 'Cyprus', 357, 1),
  (58, 'dk', 'Denmark', 45, 1),
  (68, 'ee', 'Estonia', 372, 1),
  (74, 'fi', 'Finland', 358, 1),
  (75, 'fr', 'France', 33, 1),
  (81, 'ge', 'Georgia', 995, 1),
  (82, 'de', 'Germany', 49, 1),
  (85, 'gr', 'Greece', 30, 1),
  (98, 'hk', 'Hong Kong', 852, 1),
  (99, 'hu', 'Hungary', 36, 1),
  (101, 'in', 'India', 91, 1),
  (102, 'id', 'Indonesia', 62, 1),
  (105, 'ie', 'Ireland', 353, 1),
  (107, 'it', 'Italy', 39, 1),
  (109, 'jp', 'Japan', 81, 1),
  (120, 'lv', 'Latvia', 371, 1),
  (126, 'lt', 'Lithuania', 370, 1),
  (127, 'lu', 'Luxembourg', 352, 1),
  (132, 'my', 'Malaysia', 60, 1),
  (135, 'mt', 'Malta', 356, 1),
  (142, 'mx', 'Mexico', 52, 1),
  (145, 'mc', 'Monaco', 377, 1),
  (160, 'ng', 'Nigeria', 234, 1),
  (164, 'no', 'Norway', 47, 1),
  (166, 'pk', 'Pakistan', 92, 1),
  (169, 'pa', 'Panama', 507, 1),
  (172, 'pe', 'Peru', 51, 1),
  (175, 'pl', 'Poland', 48, 1),
  (176, 'pt', 'Portugal', 351, 1),
  (178, 'qa', 'Qatar', 974, 1),
  (180, 'ro', 'Romania', 40, 1),
  (181, 'ru', 'Russia', 70, 1),
  (193, 'rs', 'Serbia', 381, 1),
  (196, 'sg', 'Singapore', 65, 1),
  (197, 'sk', 'Slovakia', 421, 1),
  (202, 'za', 'South Africa', 27, 1),
  (205, 'es', 'Spain', 34, 1),
  (206, 'lk', 'Sri Lanka', 94, 1),
  (211, 'se', 'Sweden', 46, 1),
  (212, 'ch', 'Switzerland', 41, 1),
  (217, 'th', 'Thailand', 66, 1),
  (223, 'tr', 'Turkey', 90, 1),
  (227, 'ug', 'Uganda', 256, 1),
  (228, 'ua', 'Ukraine', 380, 1),
  (230, 'gb', 'United Kingdom', 44, 1),
  (231, 'us', 'United States', 1, 1),
  (238, 'vn', 'Vietnam', 84, 1),
  (239, 'uae', 'UAE', 0, 1),
  (242, 'itl', 'Italy', NULL, 1),
  (243, 'nz', 'New Zealand', NULL, 1),
  (244, 'eng', 'England', NULL, 1),
  (245, 'sk', 'South Korea', NULL, 1),
  (246, 'ph', 'Philippines', NULL, 1),
  (247, 'nth', 'Netherlands', NULL, 1),
  (251, 'dsf h', 'sdfdsf g df', 345, 0),
  (252, 'sam spa', 'sam spa r', 121, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `gallery`
  --
  
  CREATE TABLE `gallery` (
    `id` int(11) NOT NULL,
    `image_name` varchar(255) NOT NULL,
    `fk_category_id` int(11) NOT NULL,
    `created_date` datetime NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `gallery`
  --
  
  INSERT INTO `gallery` (`id`, `image_name`, `fk_category_id`, `created_date`, `status`) VALUES
  (1, '4bc03b977a97c3bb50198d112733f061.jpg', 2, '2018-07-29 15:58:49', 1),
  (2, '330c63152de522a52f71674668387baa.jpg', 2, '2018-07-29 15:59:00', 1),
  (3, 'e61cb1657ba5dfe8cff57e7bdaee06cb.jpg', 3, '2018-07-29 15:59:11', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `members`
  --
  
  CREATE TABLE `members` (
    `id` int(11) NOT NULL,
    `username` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `contact_number` varchar(255) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `registration_date` datetime NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `members`
  --
  
  INSERT INTO `members` (`id`, `username`, `password`, `email`, `contact_number`, `status`, `registration_date`) VALUES
  (34, 'Dhyey Rathod', '12345', 'dhyey@gmail.com', '9967313968', 1, '2018-06-15 00:45:37'),
  (35, 'abhishek', '12345', 'abhishek@gmail.com', '12345', 1, '2018-06-25 21:21:01'),
  (36, 'jitu', '12345', 'jitu@gmail.com', '1234567890', 1, '2018-06-25 21:21:35');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `questions`
  --
  
  CREATE TABLE `questions` (
    `id` int(11) NOT NULL,
    `fk_member_id` int(11) NOT NULL,
    `fk_category_id` int(11) NOT NULL,
    `question` text NOT NULL,
    `fk_responsable_admin_id` int(11) NOT NULL,
    `display_status` tinyint(1) NOT NULL,
    `created_by` int(11) NOT NULL,
    `created_date` datetime NOT NULL,
    `answer_status` tinyint(1) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `questions`
  --
  
  INSERT INTO `questions` (`id`, `fk_member_id`, `fk_category_id`, `question`, `fk_responsable_admin_id`, `display_status`, `created_by`, `created_date`, `answer_status`) VALUES
  (4, 35, 2, 'Where IS Kandivali ?', 1, 0, 35, '2018-06-25 21:22:52', 1),
  (5, 35, 3, 'Hello I am Abhishek ! How are You ?\r\n', 1, 1, 35, '2018-06-25 21:23:18', 1),
  (6, 35, 2, 'Hello ?', 0, 0, 35, '2018-06-29 23:12:20', 0),
  (7, 35, 2, 'asds a dsa sad sa dsa dsad', 0, 1, 35, '2018-06-29 23:12:26', 0),
  (8, 35, 3, 'asdas da sa sa dasd asd sad sad sad ?', 0, 0, 35, '2018-06-29 23:12:33', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `volunteer`
  --
  
  CREATE TABLE `volunteer` (
    `id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `country` int(11) NOT NULL,
    `city` int(11) NOT NULL,
    `phone` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `comments` text NOT NULL,
    `option_json` text NOT NULL,
    `created_date` datetime NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `admin`
  --
  ALTER TABLE `admin`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `answers`
  --
  ALTER TABLE `answers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `blog`
  --
  ALTER TABLE `blog`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `blog_comments`
  --
  ALTER TABLE `blog_comments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `category`
  --
  ALTER TABLE `category`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cities`
  --
  ALTER TABLE `cities`
    ADD PRIMARY KEY (`city_id`);
  
  --
  -- Indexes for table `countries`
  --
  ALTER TABLE `countries`
    ADD PRIMARY KEY (`country_id`);
  
  --
  -- Indexes for table `gallery`
  --
  ALTER TABLE `gallery`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `members`
  --
  ALTER TABLE `members`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `questions`
  --
  ALTER TABLE `questions`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `volunteer`
  --
  ALTER TABLE `volunteer`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `admin`
  --
  ALTER TABLE `admin`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `answers`
  --
  ALTER TABLE `answers`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
  
  --
  -- AUTO_INCREMENT for table `blog`
  --
  ALTER TABLE `blog`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `blog_comments`
  --
  ALTER TABLE `blog_comments`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `category`
  --
  ALTER TABLE `category`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `cities`
  --
  ALTER TABLE `cities`
    MODIFY `city_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51153;
  
  --
  -- AUTO_INCREMENT for table `countries`
  --
  ALTER TABLE `countries`
    MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;
  
  --
  -- AUTO_INCREMENT for table `gallery`
  --
  ALTER TABLE `gallery`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `members`
  --
  ALTER TABLE `members`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
  
  --
  -- AUTO_INCREMENT for table `questions`
  --
  ALTER TABLE `questions`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT for table `volunteer`
  --
  ALTER TABLE `volunteer`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  