-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `tbl_career`
--

CREATE TABLE IF NOT EXISTS `tbl_career` (
  `CareerID` int(11) NOT NULL auto_increment,
  `JobTitle` varchar(255) NOT NULL,
  `Department` varchar(100) NOT NULL,
  `Company` varchar(30) NOT NULL,
  `Description` varchar(255) NOT NULL,
  `PublishDate` date NOT NULL,
  `LastDate` date NOT NULL,
  `Careerpdf` varchar(255) NOT NULL,
  PRIMARY KEY  (`CareerID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_career`
--


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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE IF NOT EXISTS `tbl_category` (
  `CategoryID` int(11) NOT NULL auto_increment,
  `SectionID` int(11) NOT NULL,
  `CategoryName` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `HeaderImage` varchar(255) NOT NULL,
  `CategoryPDF` varchar(255) NOT NULL,
  `Status` enum('Active','InActive') NOT NULL,
  PRIMARY KEY  (`CategoryID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`CategoryID`, `SectionID`, `CategoryName`, `Description`, `HeaderImage`, `CategoryPDF`, `Status`) VALUES
(1, 1, 'Vision & Mission', '<p><br />\r\n<span style="color: rgb(255, 0, 0);"><strong>Vision</strong></span><br />\r\n&nbsp;<br />\r\nBased on quality and reliability, Vimal group is to become the most preferred brand in the region.&nbsp; <br />\r\n&nbsp;<br />\r\nOur vision is to grow rapidly with the help of newer technologies and tapping latent needs of the consumers. It is our firm belief that if we can provide what consumers need, in a way&nbsp;they need, there is hardly a reason why Vimal brand will not soon become one of the most preferred and trusted brands. For this we will keep re-assessing and build upon our strengths and improve upon our weaknesses. As part of the Vimal group, we, the Promoters &amp; the employees should never compromise on the promises of quality and innovation. And the goals are ours to reach.</p>\r\n<p><span style="color: rgb(255, 0, 0);"><strong>Mission</strong></span><br />\r\n&nbsp;<br />\r\nContinue to provide value added products in an ethical and competitive way to the community. <br />\r\n&nbsp;<br />\r\nBusinesses are to generate profits. The difference with us is how we define profit. We believe that any exchange of goods and services should leave both- the giver and taker- satisfied and pleased. This generates trust. This in turn is, key to the growth and even survival of a company. On the other hand, adapting to changing times &ndash; whether it is new technology or consumer needs makes a business profitable. This profitability allows continuity and growth of the business. In short, it is a two way process. For overall development.&nbsp;<br />\r\n&nbsp; <br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp;</p>', '1.jpg', '', 'Active'),
(2, 1, 'Our Values', '<span style="color: rgb(255, 0, 0);"><strong>Our Values</strong></span><br />\r\n<br />\r\nThe Vimal family of companies shares a set of core values - Harmony, Fraternity &amp; Unity. These set of core values upon which the Vimal group was founded continue to be the guiding force and principals for all business decisions and ventures. The Group and its enterprises have been steadfast and distinctive in their adherence to business ethics and their commitment to the community and society at large.<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />', '2.jpg', '', 'Active'),
(3, 1, 'Quality Policy', '<span style="color: rgb(255, 0, 0);"><strong>Quality Policy</strong></span><br />\r\n<br />\r\nOur all Group companies adhere to national and international quality standards like ISO and highest valued certifications from the government authorities. And continue to update and upgrade with quality commitments and bureau standards issued by competent authorities. <br />\r\n&nbsp; <br />\r\nIt is committed in action to deliver satisfying Products &amp; Services for the present and future requirements of end users. The emphasis is on prevention rather than detection. It is the group&rsquo;s policy to manufacture &amp; market goods, which comply with the customers&rsquo; needs and the product designers&rsquo; specifications. The quality system is so designed that keeps ensuring the maintenance of the product quality standard through the evaluation,&nbsp;Inspection and verification of processes of all stages of manufacture. <br />\r\n<br />\r\nThis has led to a major thrust in the product exports. The fruits of increase in exports are a result of our policy to ensure that supplies adhere to contractual specifications and satisfy the customer in terms of consistent quality and timely delivery.<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />', '3.jpg', '', 'Active'),
(4, 1, 'Milestones', '<p><span style="color: #ff0000"><strong>Milestones</strong></span></p>\r\n<p><span style="color: #ff0000">1972 </span>&ndash; Foundation of the Group Company by Shri C.I.Patel started with Manufacturing of Boosters &amp; Transformers<br />\r\n<br />\r\n<span style="color: #ff0000">1984</span> &ndash; Entered in engineering &amp; Electricals products and started a new division &ndash; Vimal Pumps &amp; Vimal Cables <br />\r\n<br />\r\n<span style="color: #ff0000">1989</span> &ndash; Another diversification &ndash; Started Vimal paints <br />\r\n<br />\r\n<span style="color: #ff0000">1992</span> &ndash; Biggest leap, Diversified in Edible oil business and Foundation of Flagship Company &ndash; Vimal oil &amp; foods Ltd. <br />\r\n<br />\r\n<span style="color: #ff0000">1994 </span>- Reached 100 Cr. Mark <br />\r\n<br />\r\n<span style="color: #ff0000">1994</span> &ndash; Dairy Business Started<br />\r\n<br />\r\n<span style="color: #ff0000">1996</span> - Entered in Micronized minerals <br />\r\n<br />\r\n<span style="color: #ff0000">1998 </span>- Reached 500 Cr. Mark<br />\r\n<br />\r\n<span style="color: #ff0000">2003</span> - Entered in Ceramics and launched a Tile Brand &ndash; Swastik Tiles <br />\r\n<br />\r\n<span style="color: #ff0000">2007 </span>- Reached 1,000 Cr. Mark<br />\r\n<br />\r\n<span style="color: #ff0000">2009 </span>- Reached 1,500 Cr. Mark <br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp;</p>', '4.jpg', '', 'Active'),
(5, 1, 'Network', '<table cellspacing="1" cellpadding="1" border="0" width="98%">\r\n    <tbody>\r\n        <tr>\r\n            <td style="text-align: center;"><img src="http://www.virtuewebstudio.com/vimalgrpnew/userfiles/worldmap.jpg" alt="" /></td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n<br />', '5.jpg', '', 'Active'),
(7, 5, 'Key Financals', '<span style="color: rgb(255, 0, 0);"><strong>Key Financials</strong></span><br />\r\n<br />\r\nGroup Turnover crosses 1,500 cr. mark<br />\r\n<br />\r\nEstimated Turnover - 2,500 cr. by 2012<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />', '7.jpg', '', 'Active'),
(8, 2, 'Edible Oils', '<strong><br />\r\n</strong><span style=\\"color: rgb(255, 0, 0);\\"><strong>Vimal Oil &amp; Foods Ltd</strong></span>.<br />\r\n<br />\r\nIn 1992, the group started Vimal Oil &amp; Foods Limited for manufacturing Refined Edible Oil &amp; De-oiled Cake. Looking at the abundance of raw material and demand of edible oils Vimal brand was introduced. In North Gujarat rapeseeds and mustard seeds&nbsp;are available in bulk &amp; consumption of edible oil is high.<br />\r\n<br />\r\nCottonseed, Groundnut Oil &amp; Rapeseed oil were offered under this brand name. Due to acceptance and growing popularity of the brand, the company planned an expansion. For this public issue in March 1994 was offered. One of the critical objectives of the issue was to part finance the project for setting up a 200 TPD Solvent Extraction and 150 TPD Edible Refined Oil Plant. The Company has at present a 150 TPD Refinery, 200 TPD Solvent Extraction Plant &amp; 200 TPD seed Crushing facility at the oil-processing complex.<br />\r\n<br />\r\nThe main products of the company are<br />\r\n<ul>\r\n    <li>Refined Cottonseed Oil</li>\r\n    <li>Filtered Groundnut Oil</li>\r\n    <li>Refined Groundnut Oil</li>\r\n    <li>Refined Soyabeen Oil</li>\r\n    <li>Refined Sunflower Oil</li>\r\n    <li>Refined&nbsp;Corn Oil</li>\r\n    <li>Filtered Mustard oil</li>\r\n    <li>Kachi Ghani Mustard oil (pungent)</li>\r\n    <li>Rapeseed Oil</li>\r\n    <li>Rapeseed De - Oiled Cake</li>\r\n    <li>Table margarine</li>\r\n</ul>\r\n<a href=\\"http://www.vimaloil.com\\" target=\\"_blank\\">www.vimaloil.com</a><br />', '8.jpg', '', 'Active'),
(9, 2, 'Dairy Products', '<br />\r\n<span style="color: rgb(255, 0, 0);"><strong>Vimal Dairy Ltd.</strong></span><br />\r\n<br />\r\nThe group ventured into Milk Business in 1994. Mehsana District is one of the highest contributors of milk and milk products in the country and is famous for Buffalo breed and its best quality of milk. <br />\r\nUnder the name of&nbsp; &quot;Vimal Dairy Limited&quot;, the group manufactures and processes Milk, Butter, Pure Ghee, Cheese, Butter Milk &amp; Milk Powder. The present capacity of the plant is two lac litres of Milk per day. The company also has a plant for making Milk Powder. The capacity of the same is 15 M.T. Per day.\r\n<ul>\r\n    <li>Milk</li>\r\n    <li>Flavoured Milk</li>\r\n    <li>Pure Ghee</li>\r\n    <li>Butter</li>\r\n    <li>Cheese</li>\r\n    <li>Paneer</li>\r\n    <li>Dahi</li>\r\n    <li>Butter Milk</li>\r\n    <li>Milk powder</li>\r\n</ul>\r\n<a href="http://www.vimaldairy.com" target="_blank">www.vimaldairy.com</a><br />', '9.jpg', '', 'Active'),
(10, 2, 'Paints & Minerals', '<strong><br />\r\n</strong><span style=\\"color: rgb(255,0,0)\\"><strong>Vimal Paints&nbsp;&amp; Vimal Microns Ltd. </strong></span><br />\r\n<br />\r\nLooking at the possibilities of growing housing and infrastructure demand, Vimal Paints was launched in 1989.&nbsp;we started manufacturing different types of Industrial &amp; Decorative Paints, by forming a Partnership Concern under the name of Vimal Paints. <br />\r\n<br />\r\nResin being the raw material for paints, we started manufacturing resin under vim Coats. Alkyd Resin is exported to various countries. <br />\r\n<br />\r\nDecorative Paints<br />\r\nIndustrial Paints<br />\r\nAlkyd Resins<br />\r\n&nbsp;<br />\r\nIn 1996, the group entered into Micro Mineral Business, under the name Vimal Microns Limited started manufacturing of Micro Minerals.<br />\r\n<br />\r\nThese Microns are widely used in Paint, Plasters, Rubber, Cosmetics and more.<br />\r\n<br />\r\nCalcite<br />\r\nBarytes<br />\r\nTalc<br />\r\nDolomites<br />\r\nChina Clay<br />\r\n<br />\r\n<a target=\\"_blank\\" href=\\"http://www.vimalmicrons.com\\">www.vimalmicrons.com</a><br />\r\n<br />\r\n<br />', '10.jpg', '', 'Active'),
(11, 2, 'Electrical', '<span style="color: rgb(255,0,0)"><strong><br />\r\nVimal Flexsol Ltd.</strong></span><br />\r\n<br />\r\nIn 1984, the ancillary item of Submersible Pumps i.e. PVC&nbsp; Winding wires &amp; three core flat cables, power control cables were introduced in the market by forming a Vimal Cables Private Limited, which was subsequently converted in to a Public Limited Company under the name of Vimal Cables Limited. Later the business was transferred in Vimal Flexsol Ltd.&nbsp;<br />\r\n&nbsp; <br />\r\n<strong><br />\r\nProduct range:<br />\r\n</strong>\r\n<ul>\r\n    <li>PVC Winding Wires &amp; cables: PVC Winding wires used in Submersible motor winding. 0.8mm Dia to 3.00mm&nbsp;&nbsp;&nbsp; dia</li>\r\n    <li>Three Core Flat Cables Range : Used in Submersible Pump Sets 1.5 mm to 50sq. mm&nbsp;</li>\r\n    <li>LT Power Control Cables Range : Used in Industries. 1.5 mm to 2.5 mm</li>\r\n    <li>PVC wires for Household wiring.(Domestic) Range: Used in Household Wiring 1.5 sq. mm to 16 sq. mm</li>\r\n</ul>\r\n<br />\r\n<br />', '11.jpg', '', 'Active'),
(12, 2, 'Engineering', '<strong><br />\r\n</strong><span style="color: rgb(255,0,0)"><strong>Vimal Pumps Pvt. Ltd</strong>.</span><br />\r\n<br />\r\nThere was a short supply of water for irrigation. Looking at the opportunity for water drawing equipment, the company introduced Submersible Pumps in the market under the brand name of&nbsp;&quot;Vimal Pumps&quot; by forming a Vimal Pumps Private Limited company.<br />\r\n&nbsp;<br />\r\n<br />\r\n<strong>Product Range</strong><br />\r\n<br />\r\nSubmersible Pumps &amp; Mono-sets <br />\r\n5 H.P.&nbsp; to 100 H.P.Well Size 6, 8 to 10 inch. <br />', '12.jpg', '', 'Active'),
(13, 2, 'Ceramics', '<br />\r\n<strong><font color=\\"#ff0000\\">Akik Tiles Pvt Ltd. <br />\r\n</font></strong><br />\r\n<strong><font color=\\"#ff0000\\">Marbolite Granito India Ltd.&nbsp;<br />\r\n<br />\r\nGladder Ceramics Ltd.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />\r\nAshok Chemical Industries&nbsp;</font><br />\r\n</strong><br />\r\nIn year 2003, Vimal Group entered into ceramic tiles business called&nbsp;Akik Tiles Pvt. Ltd. to manufacture Swastik Brand quality&nbsp;ceramic&nbsp;tiles. It offers beautifully designed range of wall and floor tiles. It is also launching vitrified Tiles for wall.&nbsp; The estimated total capacity of tile plants is 30000 sq m. per day.<br />\r\n<br />\r\nThe Group later started ceramic Floor, Vitrified &amp; porcelain tiles under the Brand - Swastik Tiles<br />\r\n<br />\r\n<a target=\\"_blank\\" href=\\"http://www.swastiktiles.com\\">www.swastiktiles.in</a> <br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />', '13.jpg', '', 'Active'),
(14, 2, 'Solar Panels', '<p><span style="color: rgb(255, 0, 0);"><strong>Topsun Energy Ltd.</strong></span><br />\r\n<br />\r\nTopsun Solar panels with their high power density, refined appearance, best efficiency and premium quality materials are used in both grid-connected and off-grid solution of various applications. Our &ldquo;Shine Series&rdquo; high power, state-of-the-art solar panels ranging from 3 W to 225W designed specifically for residential or commercial applications. Our solar panel is been assemble either by monocrystalline or multicrystalline cells, depending on the customer need.</p>\r\n<p>Our solar panels offer the end-user superior performance and complete peace of mind while providing the utmost in installation flexibility. We are currently working on a range of significant International and national projects from Nodal agencies, OEM&rsquo;s industry, energy providers &amp; auditors, Indian Government, engineering and planning companies, NGO &rsquo; s, architectures and co-operatives.<br />\r\n&nbsp;</p>\r\n<p>The variation in power output is based on the conversion efficiency of the cells used in our solar modules, as well as the types of cells. We also design and produce solar modules based on our customer''s specifications. Our solar modules are sealed, weatherproof and able to withstand high levels of ultraviolet radiation and moisture. We sell our modules under our own brand.</p>\r\n<p>As of March, 2008, we had an annual solar module manufacturing capacity of 5 megawatts (MW), which is updated to 10MW currently. Our plan is to increase solar panel manufacturing capacity 40MW by March 2010.<br />\r\n<br />\r\n<font color="#008000"><a href="http://www.topsunenergy.com" target="_blank">www.topsunenergy.com</a></font><br />\r\n<br />\r\n<br />\r\n&nbsp;</p>', '14.jpg', '', 'Active'),
(15, 1, 'Promoters', '<p><span style="color: rgb(255,0,0)"><strong>Promoters</strong></span></p>\r\n<p><strong>Mr. Chandubhai I. Patel&nbsp;</strong>&nbsp;<br />\r\nAged about 67 years, he is a B.E. Electrical, having experience of 37 years in Industry. He is the <strong>Chairman</strong> of the Vimal Group of Industries and also a promoter of Mehsana Urban Cooperative Bank Limited. He is a member in 9 Executive Committee of Gujarat Chamber of Commerce and Industry. He is a social worker being a Trustee in many educational trust. All the Group &amp; Companies are progressively working under the guidance of Shri Chandubhai I. Patel.</p>\r\n<p><strong>Mr. Jayesh C. Patel </strong><br />\r\nAged about 40 years, He is a B.E. Computer science&nbsp; with 16 years of experience in Edible Oil Industry and Dairy Business. He is the <strong>Managing Director</strong> of&nbsp;Vimal Oil &amp; Foods Limited &amp; Vimal Dairy Limited and also looking after other diverse group companies. He is actively associated with India''s Premium associations; like - SEA, COOIT, GCCI, FICII, IDA &amp;&nbsp;NGONA<br />\r\n&nbsp;<br />\r\n<strong>Mr. Ganpatbhai K. Patel&nbsp;</strong><br />\r\nAged about 55 years is an industrialist having 29 years of experience in Decorative, Industrial and Marine paints. He is <strong>Managing Director</strong> of&nbsp;Vimal Paints, Vimal Microns Limited and Vim Coats.&nbsp;</p>\r\n<p><strong>Mr. Narayanbhai S. Patel&nbsp;<br />\r\n</strong>Aged about 64 years is a Commerce Graduate having 39 years of experience in Submersible Pump Industry. He is looking after Vimal Pumps Private Limited &amp; Vimal Engineering Company.&nbsp;&nbsp;<br />\r\n&nbsp;<br />\r\n<strong>Mr. Girish Patel&nbsp;</strong><br />\r\nAged 39 yrs and started his career with ceramic field in year 1994 and have deep knowledge of this industry and handling ceramic division for Vimal Group and Managing Director for the same. Planning to expand this division to Exterior cladding Tiles,Pavic Tiles,Sanitary Ware,C.P. Fittings and also in Glass Mosaic.<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp;</p>', '15.jpg', '', 'Active');

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE IF NOT EXISTS `tbl_country` (
  `CountryID` int(5) NOT NULL auto_increment,
  `CountryName` varchar(255) NOT NULL,
  PRIMARY KEY  (`CountryID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;

--
-- Dumping data for table `tbl_country`
--

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

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

--
-- Table structure for table `tbl_csr`
--

CREATE TABLE IF NOT EXISTS `tbl_csr` (
  `CSRID` int(11) NOT NULL auto_increment,
  `CSRTitle` varchar(255) NOT NULL,
  `Abstract` blob NOT NULL,
  `CSRpdf` varchar(255) NOT NULL,
  PRIMARY KEY  (`CSRID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_csr`
--

INSERT INTO `tbl_csr` (`CSRID`, `CSRTitle`, `Abstract`, `CSRpdf`) VALUES
(1, 'The Mehsana Urban Co-Operative Bank Ltd.', 0x[BLOB], ''),
(2, 'Lions Hospital', 0x[BLOB], ''),
(3, 'Ganpat University', 0x[BLOB], ''),
(4, 'Transformers Engineering Association', 0x[BLOB], '');

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

--
-- Table structure for table `tbl_highlights`
--

CREATE TABLE IF NOT EXISTS `tbl_highlights` (
  `HighlightID` int(11) NOT NULL auto_increment,
  `HighlightTitle` varchar(255) NOT NULL,
  `Abstract` blob NOT NULL,
  `Highlightpdf` varchar(255) NOT NULL,
  PRIMARY KEY  (`HighlightID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_highlights`
--

INSERT INTO `tbl_highlights` (`HighlightID`, `HighlightTitle`, `Abstract`, `Highlightpdf`) VALUES
(1, 'Group Turnover crossed 1500 cr.', 0x[BLOB], ''),
(2, '15% Dividend Declared', 0x[BLOB], ''),
(3, 'June. 2010 Quarter Result', 0x[BLOB], '');

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

--
-- Table structure for table `tbl_knowledgeclub`
--

CREATE TABLE IF NOT EXISTS `tbl_knowledgeclub` (
  `KnowledgeclubID` int(11) NOT NULL auto_increment,
  `KnowledgeclubTitle` varchar(255) NOT NULL,
  `Abstract` blob NOT NULL,
  `Knowledgepdf` varchar(255) NOT NULL,
  PRIMARY KEY  (`KnowledgeclubID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_knowledgeclub`
--


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

--
-- Table structure for table `tbl_newsevent`
--

CREATE TABLE IF NOT EXISTS `tbl_newsevent` (
  `NewsEventsID` int(10) NOT NULL auto_increment,
  `NewsEvent` varchar(6) NOT NULL,
  `NewsEventsTitle` varchar(255) NOT NULL,
  `FromDate` date NOT NULL,
  `ToDate` date NOT NULL,
  `NewsSource` varchar(255) NOT NULL,
  `Venue` varchar(255) NOT NULL,
  `Abstract` blob NOT NULL,
  `NewsEventsPDF` varchar(255) NOT NULL,
  PRIMARY KEY  (`NewsEventsID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_newsevent`
--

INSERT INTO `tbl_newsevent` (`NewsEventsID`, `NewsEvent`, `NewsEventsTitle`, `FromDate`, `ToDate`, `NewsSource`, `Venue`, `Abstract`, `NewsEventsPDF`) VALUES
(1, 'News', ' Vimal Oil & Foods Limited launched new palm kernel oil', '2009-09-01', '0000-00-00', 'Vimal Oil & Food Ltd.', '', 0x[BLOB], ''),
(2, 'News', 'Swastik Tiles introduces new series TORTOISE', '2009-09-10', '0000-00-00', 'Swastik Tiles', '', 0x5377617374696b2054696c657320696e74726f6475636573206e65772073657269657320544f52544f495345204d756c7469204c6179657220706f7263656c61696e20666c6f6f722074696c657320776974682056494252414e5420436f6c6f727320696e20323078323020706f7263656c61696e2074696c65732e, ''),
(3, 'News', 'Vimal Oil & Foods Limited introduces Vimal Refined Sunflower Oil', '2009-12-04', '0000-00-00', 'Vimal Oil & Foods Ltd.', '', 0x[BLOB], ''),
(4, 'News', 'Vimal Oil & Foods Limited introduces Vimal Refined Corn Oil', '2010-02-12', '0000-00-00', 'Vimal Oil & Foods Ltd.', '', 0x[BLOB], ''),
(5, 'News', 'Vimal Dairy Limited introduces Vimal Cheers', '2010-04-01', '0000-00-00', 'Vimal Dairy Ltd.', '', 0x[BLOB], '');

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

--
-- Table structure for table `tbl_section`
--

CREATE TABLE IF NOT EXISTS `tbl_section` (
  `SectionID` int(11) NOT NULL auto_increment,
  `SectionName` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `HeaderImage` varchar(255) NOT NULL,
  `SectionPDF` varchar(255) NOT NULL,
  PRIMARY KEY  (`SectionID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_section`
--

INSERT INTO `tbl_section` (`SectionID`, `SectionName`, `Description`, `HeaderImage`, `SectionPDF`) VALUES
(1, 'About Us', '<span style="color: rgb(255,0,0)"><strong>The journey called Vimal Group</strong></span><br />\r\n<br />\r\nVimal group has its roots in North Gujarat. One of the most respected groups now, it had its humble beginnings but&nbsp;with a clear vision. And today it has grown to be a conglomerate of 19 group companies. These thriving companies broadly cater to seven categories: Edible Oils, Dairy, Paints &amp; Micronized Minerals, Ceramics tiles, &nbsp;Electricals, Engineering and Real Estate.<br />\r\n<br />\r\nThe days of the group''s inception were challenging. Where private enterprise had to work very ingeniously to overcome bottlenecks of Industrial infrastructure and Investments; <strong>Shri C.I.Patel,</strong> the founder of the Vimal Group took it upon himself to steer the enterprising ambitions to greater heights in the era of regulated Indian markets of the 70s. The ingenious approach thus evolved was to take a route of mass participation and community benefiting businesses. Consequently, Shri C.I.Patel and those who followed him aligned business opportunities with the objective of community building. This approach remains enshrined in the Group''s ethos to this day and will continue to guide the way forward.<br />\r\n<br />\r\nThe rich rewards thus reaped on solid foundation are evident in the year on year growth. The Vimal Group touched Rs 1500 crore revenues landmark in the year 2008-09. The rapid stride it took in the last decade envisions a wider role of the group in the industrial development of the region.<br />\r\n<br />\r\nThe Group''s flagship company is also one of the most successfully publicly listed enterprises ----Vimal Oil &amp; Foods Ltd. It stands apart from the rest.<br />', '1.jpg', ''),
(2, 'Companies', '<span style="color: rgb(255,0,0)"><strong>The Group Companies</strong></span><br />\r\n<br />\r\nThe Vimal Group is conglomerate of 19 group companies.<br />\r\n&nbsp;<br />\r\nThese thriving companies broadly cater to seven categories:&nbsp; Edible Oils, Dairy, Micro Minerals, Electricals, Engineering, Ceramics and Real Estate.<br />\r\n&nbsp;<br />\r\nThe Group''s flagship company Vimal Oil &amp; Foods Ltd is also one of the most successfully publicly listed enterprises.<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />', '2.jpg', ''),
(3, 'Alliances', 'Associates complement each&nbsp;other&rsquo;s&nbsp;&nbsp;capabilities and leveraging each other in the marketplace<br />\r\n<br />\r\nThe companies who want to work with us closely for jointly selling quality products and services.<br />\r\n<br />\r\nThe alliance will be aimed to facilitate our customers and we can jointly pitch for projects and execute it by sharing each&nbsp; other&rsquo;s resources. By following these practices, we can synergize our operations and reap the benefits of working in sync with each other.<br />\r\n&nbsp;<br />\r\nQuality Policy in practice, Vimal Group is well positioned to deliver quality products and prompt services to meet or exceed the customer expectations. It is the passion for quality that kept us growing this far, and motivating us to steer ahead with confidence. The repeat orders, foolproof reliability and trust we emboss in our customers<br />\r\n&nbsp;<br />\r\nThe Vimal Group invite you to get associated with us and ensure the success of organizations that have or plan to invest in our products by selling or supplying.<br />\r\n<br />\r\n<a href="alliances.php">Click here</a> to Get Associated with us<br />\r\n<br />', '3.jpg', ''),
(4, 'Innovations', '<p><br />\r\n<span style="color: #ff0000"><strong>Innovation<br />\r\n</strong></span>&nbsp;<br />\r\nThinking unique is an idea, application of the same idea and creating value out of that idea is &ldquo;Innovation&rdquo; <br />\r\n<br />\r\nWork Force at Vimal is motivated towards creating new ideas that helps them to apply innovation not just to products but also to strategies and processes. <br />\r\n<br />\r\nHere at Vimal we focus on each individual&rsquo;s learning, involvement in the area of his/her choice and is given a platform to share and develop his/her ideas. Position or hierarchies never come in the way of innovation. It is only through such freedom that we continue to add value to the lives of our customers.<br />\r\n<br />\r\n30 years of Success, Growth &amp; Innovations has given us a platform to make our society better and our products and solutions have benefited millions in last three decades.</p>\r\n<p><br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp;</p>', '4.jpg', ''),
(5, 'Investors', '<span style="color: rgb(255,0,0)"><strong>Dear Investors</strong></span><br />\r\n<br />\r\nThe company believes in principle of Corporate Governance and endeavours it''s best to maintain transparency and professionalism with fairness &amp; integrity to enhance the interest of all it&rsquo;s shareholders.<br />\r\n<br />\r\nThis section, along with the sections on Additional shareholder information &amp; Management Discussion &amp; Analysis in the Annual Report, constitutes compliance with Clause 49 of the Listing Agreement.<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />', '5.jpg', '');

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

--
-- Table structure for table `tbl_state`
--

CREATE TABLE IF NOT EXISTS `tbl_state` (
  `StateID` int(5) NOT NULL auto_increment,
  `StateName` varchar(255) NOT NULL,
  `CountryID` int(5) NOT NULL,
  PRIMARY KEY  (`StateID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3363 ;

--
-- Dumping data for table `tbl_state`
--

INSERT INTO `tbl_state` (`StateID`, `StateName`, `CountryID`) VALUES
(1, 'Gagra', 1),
(2, 'Pistunda', 1),
(3, 'Pskhu', 1),
(4, 'Gudauta', 1),
(5, 'Novyy Afon', 1),
(6, 'Sukhumi', 1),
(7, 'Guripush', 1),
(8, 'Lata', 1),
(9, 'Otap', 1),
(10, 'Omarishara', 1),
(11, 'Tqvarcheli', 1),
(12, 'Okhumi', 1),
(13, 'Gali', 1),
(14, 'Pichori', 1),
(15, 'Anaklia', 1),
(16, 'Zugdidi', 1),
(17, 'Tsale', 1),
(18, 'Jvari', 1),
(19, 'Badakhshan', 2),
(20, 'Badghis', 2),
(21, 'Baghlan', 2),
(22, 'Balkh', 2),
(23, 'Bamiyan', 2),
(24, 'Daikondi', 2),
(25, 'Farah', 2),
(26, 'Faryab', 2),
(27, 'Ghazni', 2),
(28, 'Ghowr', 2),
(29, 'Helmand', 2),
(30, 'Herat', 2),
(31, 'Jowzjan', 2),
(32, 'Kabul', 2),
(33, 'Kandahar', 2),
(34, 'Kapisa', 2),
(35, 'Khost', 2),
(36, 'Akrotiri and Dhekelia', 3),
(37, 'Brando', 4),
(38, 'Eckero', 4),
(39, 'Finstrom', 4),
(40, 'Foglo', 4),
(41, 'Geta', 4),
(42, 'Hammarland', 4),
(43, 'Jomala', 4),
(44, 'Kumlinge', 4),
(45, 'Kokar', 4),
(46, 'Lemland', 4),
(47, 'Lumparland', 4),
(48, 'Mariehamn', 4),
(49, 'Saltvik', 4),
(50, 'Sottunga', 4),
(51, 'Sund', 4),
(52, 'Vardo', 4),
(53, 'Berat', 5),
(54, 'Diber', 5),
(55, 'Durres', 5),
(56, 'Elbasan', 5),
(57, 'Fier', 5),
(58, 'Gjirokaster', 5),
(59, 'Korce', 5),
(60, 'Kukes', 5),
(61, 'Lezhe', 5),
(62, 'Shkoder', 5),
(63, 'Tirane', 5),
(64, 'Vlore', 5),
(65, 'Adrar', 6),
(66, 'Ain Defla', 6),
(67, 'Ain Temouchent', 6),
(68, 'Algiers', 6),
(69, 'Annaba', 6),
(70, 'Batna', 6),
(71, 'Bechar', 6),
(72, 'Bejaia', 6),
(73, 'Biskra', 6),
(74, 'Blida', 6),
(75, 'Bordj Bou Arreridj', 6),
(76, 'Bouira', 6),
(77, 'Boumerdes', 6),
(78, 'Chlef', 6),
(79, 'Constantine', 6),
(80, 'Djelfa', 6),
(81, 'El Bayadh', 6),
(82, 'EL Qued', 6),
(83, 'EL Tarf', 6),
(84, 'Ghardaia', 6),
(85, 'Guelma', 6),
(86, 'lllizi', 6),
(87, 'Jijel', 6),
(88, 'Khenchela', 6),
(89, 'Laughouat', 6),
(90, 'Medea', 6),
(91, 'Mila', 6),
(92, 'Mostaganem', 6),
(93, 'M''Sila', 6),
(94, 'Muaskar', 6),
(95, 'Naama', 6),
(96, 'Oran', 6),
(97, 'Ouargla', 6),
(98, 'Oum el-Bouaghi', 6),
(99, 'Relizane', 6),
(100, 'Saida', 6),
(101, 'Setif', 6),
(102, 'Sidi Bel Abbes', 6),
(103, 'Skikda', 6),
(104, 'Souk Ahras', 6),
(105, 'Tamanghasset', 6),
(106, 'Tebessa', 6),
(107, 'Tiaret', 6),
(108, 'Tindouf', 6),
(109, 'Tipasa', 6),
(110, 'Tissemsilt', 6),
(111, 'Tizi Ouzou', 6),
(112, 'Tlemcen', 6),
(113, 'Aasu', 7),
(114, 'Afao', 7),
(115, 'Afono', 7),
(116, 'Agugulu', 7),
(117, 'Alao', 7),
(118, 'Alofau', 7),
(119, 'Alega', 7),
(120, 'Amaluia', 7),
(121, 'Amanave', 7),
(122, 'Amaua', 7),
(123, 'Amouli', 7),
(124, 'Anua', 7),
(125, 'Aoa', 7),
(126, 'Aoloau', 7),
(127, 'Asili', 7),
(128, 'Atu''u', 7),
(129, 'Aua', 7),
(130, 'Auasi', 7),
(131, 'Aumi', 7),
(132, 'Aunu''u', 7),
(133, 'Auto', 7),
(134, 'Avaio', 7),
(135, 'Faga''alu', 7),
(136, 'Faga''itua', 7),
(137, 'Fagali''i', 7),
(138, 'Fagamalo', 7),
(139, 'Faganeanea', 7),
(140, 'Fagasa', 7),
(141, 'Fagatogo', 7),
(142, 'Failolo', 7),
(143, 'Faleniu', 7),
(144, 'Fatumafuti', 7),
(145, 'Futiga', 7),
(146, 'Ili''ili', 7),
(147, 'Leloaloa', 7),
(148, 'Leone', 7),
(149, 'Lauli''i', 7),
(150, 'Malaeimi', 7),
(151, 'Malaeloa/Aitulagi', 7),
(152, 'Malaeloa/Ituau', 7),
(153, 'Maloata', 7),
(154, 'Mapusagafou', 7),
(155, 'Masausi', 7),
(156, 'Masefau', 7),
(157, 'Matu''u', 7),
(158, 'Mesepa', 7),
(159, 'Nu''uuli', 7),
(160, 'Nua', 7),
(161, 'Onenoa', 7),
(162, 'Pago Pago', 7),
(163, 'Pava''ia''i', 7),
(164, 'Poloa', 7),
(165, 'Sa''ilele', 7),
(166, 'Se''etaga', 7),
(167, 'Tafuna', 7),
(168, 'Taputimu', 7),
(169, 'Tula', 7),
(170, 'Utulei', 7),
(171, 'Utumea East', 7),
(172, 'Utumea West', 7),
(173, 'Vailoatai', 7),
(174, 'Vaitogi', 7),
(175, 'Vatia', 7),
(176, 'Faleasao', 7),
(177, 'Leusoali''i', 7),
(178, 'Luma', 7),
(179, 'Maia', 7),
(180, 'Ofu', 7),
(181, 'Olosega', 7),
(182, 'Si''ufaga', 7),
(183, 'Sili', 7),
(184, 'Andorra la Vella', 8),
(185, 'Canillo', 8),
(186, 'Encamp', 8),
(187, 'Escaldes-Engordany', 8),
(188, 'La Massana', 8),
(189, 'Ordino', 8),
(190, 'Sant Julia de Lòria', 8),
(191, 'Bengo', 9),
(192, 'Benguela', 9),
(193, 'Bie', 9),
(194, 'Cabinda', 9),
(195, 'Cuando Cubango', 9),
(196, 'Cuanza Norte', 9),
(197, 'Cuanza Sul', 9),
(198, 'Cunene', 9),
(199, 'Huambo', 9),
(200, 'Huila', 9),
(201, 'Luanda', 9),
(202, 'Lunda Norte', 9),
(203, 'Lunda Sul', 9),
(204, 'Malanje', 9),
(205, 'Moxico', 9),
(206, 'Namibe', 9),
(207, 'Uige', 9),
(208, 'Zaire', 9),
(209, 'Anguillita', 10),
(210, 'Blowing Rock', 10),
(211, 'Cove Cay', 10),
(212, 'Crocus Cay', 10),
(213, 'Deadman''s Cay', 10),
(214, 'Dog Island', 10),
(215, 'East Cay', 10),
(216, 'Hat Island', 10),
(217, 'Little Island', 10),
(218, 'Little Scrub Island', 10),
(219, 'Mid Cay', 10),
(220, 'North Cay', 10),
(221, 'Prickley Pear Cays', 10),
(222, 'Rabbit Island', 10),
(223, 'Sand Island', 10),
(224, 'Scilly Cay', 10),
(225, 'Scrub Island', 10),
(226, 'Seal Island', 10),
(227, 'Sombrero', 10),
(228, 'South Cay', 10),
(229, 'South Wager Island', 10),
(230, 'West Cay', 10),
(231, 'Saint George', 11),
(232, 'Saint John', 11),
(233, 'Saint Mary', 11),
(234, 'Saint Paul', 11),
(235, 'Saint Peter', 11),
(236, 'Saint Philip', 11),
(237, 'Ciudad Autonoma de Buenos Aires', 12),
(238, 'Buenos Aires', 12),
(239, 'Catamarca', 12),
(240, 'Chaco', 12),
(241, 'Chubut', 12),
(242, 'Cordoba', 12),
(243, 'Corrientes', 12),
(244, 'Entre Rios', 12),
(245, 'Formosa', 12),
(246, 'Jujuy', 12),
(247, 'La Pampa', 12),
(248, 'La Rioja', 12),
(249, 'Mendoza', 12),
(250, 'Misiones', 12),
(251, 'Neuquen', 12),
(252, 'Rio Negro', 12),
(253, 'Salta', 12),
(254, 'San Juan', 12),
(255, 'San Luis', 12),
(256, 'Santa Cruz', 12),
(257, 'Santa Fe', 12),
(258, 'Santiago del Estero', 12),
(259, 'Tierra del Fuego', 12),
(260, 'Tucuman', 12),
(261, 'Aragatsotn', 13),
(262, 'Ararat', 13),
(263, 'Armavir', 13),
(264, 'Gegharkunik', 13),
(265, 'Kotayk', 13),
(266, 'Lori', 13),
(267, 'Shirak', 13),
(268, 'Syunik', 13),
(269, 'Tavush', 13),
(270, 'Vayots Dzor', 13),
(271, 'Yerevan', 13),
(272, 'Aruba', 14),
(273, 'Bonaire', 14),
(274, 'Curacao', 14),
(275, 'Ascension Island', 15),
(276, 'New South Wales', 16),
(277, 'Queensland', 16),
(278, 'South Australia', 16),
(279, 'Tasmania', 16),
(280, 'Victoria', 16),
(281, 'Western Australia', 16),
(282, 'Burgenland', 17),
(283, 'Carinthia', 17),
(284, 'Lower Austria', 17),
(285, 'Upper Austria', 17),
(286, 'Salzburg', 17),
(287, 'Styria', 17),
(288, 'Tyrol', 17),
(289, 'Vorarlberg', 17),
(290, 'Vienna', 17),
(291, 'Babek', 18),
(292, 'Julfa', 18),
(293, 'Kangarli', 18),
(294, 'Nakhichevan City', 18),
(295, 'Ordubad', 18),
(296, 'Sadarak', 18),
(297, 'Shakhbuz', 18),
(298, 'Sharur', 18),
(299, 'Bahamas', 19),
(300, 'Bahrain', 20),
(301, 'Barisal', 21),
(302, 'Chittagong', 21),
(303, 'Dhaka', 21),
(304, 'Khulna', 21),
(305, 'Rajshahi', 21),
(306, 'Sylhet', 21),
(307, 'Barbados', 22),
(308, 'Minsk', 23),
(309, 'Brest', 23),
(310, 'Homyel', 23),
(311, 'Hrodna', 23),
(312, 'Mahilyow', 23),
(313, 'Minsk', 23),
(314, 'Vitsebsk Province', 23),
(315, 'Flemish', 24),
(316, 'Walloon', 24),
(317, 'Brussels', 24),
(318, 'Belize District', 25),
(319, 'Cayo District', 25),
(320, 'Corozal District', 25),
(321, 'Orange Walk District', 25),
(322, 'Stann Creek District', 25),
(323, 'Toledo District', 25),
(324, 'Alibori (from north Borgou)', 26),
(325, 'Atakora', 26),
(326, 'Atlantique', 26),
(327, 'Borgou', 26),
(328, 'Collines (from north Zou)', 26),
(329, 'Donga (from south Atakora)', 26),
(330, 'Kouffo (from north Mono)', 26),
(331, 'Littoral (the region of Cotonou, split from Atlantique)', 26),
(332, 'Mono', 26),
(333, 'Oueme', 26),
(334, 'Plateau (from north Oueme)', 26),
(335, 'Zou', 26),
(336, 'Sandys', 27),
(337, 'Southampton', 27),
(338, 'Warwick', 27),
(339, 'Paget', 27),
(340, 'Pembroke', 27),
(341, 'Devonshire', 27),
(342, 'Smith''s', 27),
(343, 'Hamilton', 27),
(344, 'St George''s', 27),
(345, 'Bumthang', 28),
(346, 'Chukha', 28),
(347, 'Dagana', 28),
(348, 'Gasa', 28),
(349, 'Haa', 28),
(350, 'Lhuntse', 28),
(351, 'Mongar', 28),
(352, 'Paro', 28),
(353, 'Pemagatshel', 28),
(354, 'Punakha', 28),
(355, 'Samdrup Jongkhar', 28),
(356, 'Samtse', 28),
(357, 'Sarpang', 28),
(358, 'Thimphu', 28),
(359, 'Trashigang', 28),
(360, 'Trashiyangste', 28),
(361, 'Trongsa', 28),
(362, 'Tsirang', 28),
(363, 'Wangdue Phodrang', 28),
(364, 'Zhemgang', 28),
(365, 'Chuquisaca', 29),
(366, 'Cochabamba', 29),
(367, 'Beni', 29),
(368, 'La Paz', 29),
(369, 'Oruro', 29),
(370, 'Pando', 29),
(371, 'Potosi', 29),
(372, 'Santa Cruz', 29),
(373, 'Tarija', 29),
(374, 'Republika Srpska', 30),
(375, 'Federation of Bosnia', 30),
(376, 'Herzegovina', 30),
(377, 'Central', 31),
(378, 'Ghanzi', 31),
(379, 'Kgalagadi', 31),
(380, 'Kgatleng', 31),
(381, 'Kweneng', 31),
(382, 'North-East', 31),
(383, 'North-West', 31),
(384, 'South-East', 31),
(385, 'Southern', 31),
(386, 'Roraima', 32),
(387, 'Amapa', 32),
(388, 'Amazonas', 32),
(389, 'Para', 32),
(390, 'Tocantins', 32),
(391, 'Acre', 32),
(392, 'Rondonia', 32),
(393, 'Maranhao', 32),
(394, 'Piaui', 32),
(395, 'Ceara', 32),
(396, 'Rio Grande do Norte', 32),
(397, 'Paraiba', 32),
(398, 'Pernambuco', 32),
(399, 'Alagoas', 32),
(400, 'Sergipe', 32),
(401, 'Bahia', 32),
(402, 'Mato Grosso', 32),
(403, 'Goias', 32),
(404, 'Distrito Federal (Brasilia)', 32),
(405, 'Mato Grosso do Sul', 32),
(406, 'Minas Gerais', 32),
(407, 'Espirito Santo', 32),
(408, 'Rio de Janeiro', 32),
(409, 'Sao Paulo', 32),
(410, 'Parana', 32),
(411, 'Santa Catarina', 32),
(412, 'Rio Grande do Sul', 32),
(413, 'Belait', 33),
(414, 'Brunei and Muara', 33),
(415, 'Temburong', 33),
(416, 'Tutong', 33),
(417, 'Blagoevgrad', 34),
(418, 'Burgas', 34),
(419, 'Dobrich', 34),
(420, 'Gabrovo', 34),
(421, 'Haskovo', 34),
(422, 'Kardzhali', 34),
(423, 'Kyustendil', 34),
(424, 'Lovech', 34),
(425, 'Montana', 34),
(426, 'Pazardzhik', 34),
(427, 'Pernik', 34),
(428, 'Pleven', 34),
(429, 'Plovdiv', 34),
(430, 'Razgrad', 34),
(431, 'Ruse', 34),
(432, 'Shumen', 34),
(433, 'Silistra', 34),
(434, 'Sliven', 34),
(435, 'Smolyan', 34),
(436, 'Sofia', 34),
(437, 'Sofia Province', 34),
(438, 'Stara Zagora', 34),
(439, 'Targovishte', 34),
(440, 'Varna', 34),
(441, 'Veliko Tarnovo', 34),
(442, 'Vidin', 34),
(443, 'Vratsa', 34),
(444, 'Yambol', 34),
(445, 'Boucle du Mouhoun', 35),
(446, 'Cascades', 35),
(447, 'Centre', 35),
(448, 'Centre-Est', 35),
(449, 'Centre-Nord', 35),
(450, 'Centre-Ouest', 35),
(451, 'Centre-Sud', 35),
(452, 'Est', 35),
(453, 'Hauts-Bassins', 35),
(454, 'Nord', 35),
(455, 'Plateau-Central', 35),
(456, 'Sahel', 35),
(457, 'Sud-Ouest', 35),
(458, 'Burma', 36),
(459, 'Bubanza', 37),
(460, 'Bujumbura Mairie', 37),
(461, 'Bujumbura Rural', 37),
(462, 'Bururi', 37),
(463, 'Cankuzo', 37),
(464, 'Cibitoke', 37),
(465, 'Gitega', 37),
(466, 'Karuzi', 37),
(467, 'Kayanza', 37),
(468, 'Kirundo', 37),
(469, 'Makamba', 37),
(470, 'Muramvya', 37),
(471, 'Muyinga', 37),
(472, 'Mwaro', 37),
(473, 'Ngozi', 37),
(474, 'Rutana', 37),
(475, 'Ruyigi', 37),
(476, 'Banteay Meanchey', 38),
(477, 'Battambang', 38),
(478, 'Kampong Cham', 38),
(479, 'Kampong Chhnang', 38),
(480, 'Kampong Speu', 38),
(481, 'Kampong Thom', 38),
(482, 'Kampot', 38),
(483, 'Kandal', 38),
(484, 'Koh Kong', 38),
(485, 'Kratie', 38),
(486, 'Mondulkiri', 38),
(487, 'Oddar Meancheay', 38),
(488, 'Pursa', 38),
(489, 'Preah Vihea', 38),
(490, 'Prey Veng', 38),
(491, 'Ratanakiri', 38),
(492, 'Siem Reap', 38),
(493, 'Stung Treng', 38),
(494, 'Svay Rieng', 38),
(495, 'Takeo', 38),
(496, 'Adamawa Province', 39),
(497, 'Centre Province', 39),
(498, 'East Province', 39),
(499, 'Far North Province', 39),
(500, 'Littoral Province', 39),
(501, 'North Province', 39),
(502, 'Northwest Province', 39),
(503, 'West Province', 39),
(504, 'South Province', 39),
(505, 'Southwest Province', 39),
(506, 'Canada', 40),
(507, 'Santo Antao', 41),
(508, 'Sao Vicente', 41),
(509, 'Santa Luzia', 41),
(510, 'Sao Nicolau', 41),
(511, 'Sal', 41),
(512, 'Boa Vista', 41),
(513, 'Sotaventos (southern island group)', 41),
(514, 'Maio', 41),
(515, 'Santiago', 41),
(516, 'Fogo', 41),
(517, 'Brava', 41),
(518, 'Bodden Town', 42),
(519, 'Cayman Brac Island', 42),
(520, 'East End', 42),
(521, 'George Town', 42),
(522, 'Little Cayman Island', 42),
(523, 'North Side', 42),
(524, 'West Bay', 42),
(525, 'Bamingui-Bangoran', 43),
(526, 'Basse-Kotto', 43),
(527, 'Haute-Kotto', 43),
(528, 'Haut-Mbomou', 43),
(529, 'Kemo', 43),
(530, 'Lobaye', 43),
(531, 'Mambere-Kadei', 43),
(532, 'Mbomou', 43),
(533, 'Nana-Mambere', 43),
(534, 'Ombella-M''Poko', 43),
(535, 'Vakaga', 43),
(536, 'Nana-Grebizi', 43),
(537, 'Sangha-Mbaere', 43),
(538, 'Bangui', 43),
(539, 'Batha', 44),
(540, 'Bourkou-Ennedi-Tibest', 44),
(541, 'Chari-Baguirmi', 44),
(542, 'Guera', 44),
(543, 'Hadjer-Lamis', 44),
(544, 'Kanem', 44),
(545, 'Lac', 44),
(546, 'Logone Occidental', 44),
(547, 'Mandoul', 44),
(548, 'Mayo-Kebbi Ouest', 44),
(549, 'Moyen-Chari', 44),
(550, 'Ndjamena', 44),
(551, 'Ouaddai', 44),
(552, 'Tandjile', 44),
(553, 'Wadi Fira', 44),
(554, 'Chile', 45),
(555, 'Anhui', 46),
(556, 'Fujian', 46),
(557, 'Gansu', 46),
(558, 'Gungdong', 46),
(559, 'Guizhou', 46),
(560, 'Hinan', 46),
(561, 'Hebei', 46),
(562, 'Heilongjiang', 46),
(563, 'Henan', 46),
(564, 'Hubei', 46),
(565, 'Hunan', 46),
(566, 'Jiangsu', 46),
(567, 'Jiangxi', 46),
(568, 'Jilin', 46),
(569, 'Liaoning', 46),
(570, 'Qinghi', 46),
(571, 'Shaanxi', 46),
(572, 'Shandong', 46),
(573, 'Shanxi', 46),
(574, 'Sichuan', 46),
(575, 'Yunnan', 46),
(576, 'Zhejiang', 46),
(577, 'Gugxi', 46),
(578, 'Inner Mongolia', 46),
(579, 'Ningxia', 46),
(580, 'Xinjiang', 46),
(581, 'Tibet', 46),
(582, 'Chongqìng', 46),
(583, 'Shanghi', 46),
(584, 'Tianjin', 46),
(585, 'Hong Kong', 46),
(586, 'Macau', 46),
(587, 'Taiwan province', 47),
(588, 'Fujian', 47),
(589, 'Dongsha island', 47),
(590, 'Taiping island', 47),
(591, 'Christmas Island', 48),
(592, 'Cocos (Keeling) Islands', 49),
(593, 'Amazonas', 50),
(594, 'Antioquia', 50),
(595, 'Arauca', 50),
(596, 'Atlantico', 50),
(597, 'Bolivar', 50),
(598, 'Boyaca', 50),
(599, 'Caldas', 50),
(600, 'Caqueta', 50),
(601, 'Casanare', 50),
(602, 'Cauca', 50),
(603, 'Cesar', 50),
(604, 'Choco', 50),
(605, 'Cordoba', 50),
(606, 'Cundinamarca', 50),
(607, 'Guainia', 50),
(608, 'Guaviare', 50),
(609, 'Huila', 50),
(610, 'Guajira', 50),
(611, 'Magdalena', 50),
(612, 'Meta', 50),
(613, 'Narino', 50),
(614, 'Norte de Santander', 50),
(615, 'Putumayo', 50),
(616, 'Quindio', 50),
(617, 'Risaralda', 50),
(618, 'San Andres y Providencia', 50),
(619, 'Santander', 50),
(620, 'Sucre', 50),
(621, 'Tolima', 50),
(622, 'Valle del Cauca', 50),
(623, 'Vaupes', 50),
(624, 'Vichada', 50),
(625, 'Volcanic Comoros archipelago', 51),
(626, 'Grande Comore', 51),
(627, 'Moheli', 51),
(628, 'Anjounan', 51),
(629, 'Kinshasa', 52),
(630, 'Kongo central', 52),
(631, 'Kwango', 52),
(632, 'Kwilu', 52),
(633, 'Mai-Ndombe', 52),
(634, 'Kasai', 52),
(635, 'Lulua', 52),
(636, 'Kasai Oriental', 52),
(637, 'Lomami', 52),
(638, 'Sankuru', 52),
(639, 'Maniema', 52),
(640, 'Sud-Kivu', 52),
(641, 'Nord-Kivu', 52),
(642, 'Ituri', 52),
(643, 'Haut-Uele', 52),
(644, 'Tshopo', 52),
(645, 'Bas-Uele', 52),
(646, 'Nord-Ubangi', 52),
(647, 'Mongala', 52),
(648, 'Sud-Ubangi', 52),
(649, 'Équateur', 52),
(650, 'Tshuapa', 52),
(651, 'Tanganyika', 52),
(652, 'Haut-Lomami', 52),
(653, 'Lualaba', 52),
(654, 'Haut-Katanga', 52),
(655, 'Bouenza', 53),
(656, 'Cuvette', 53),
(657, 'Cuvette-Ouest', 53),
(658, 'Kouilou', 53),
(659, 'Lekoumou', 53),
(660, 'Likouala', 53),
(661, 'Niari', 53),
(662, 'Plateaux', 53),
(663, 'Pool', 53),
(664, 'Sangha (Ouesso)', 53),
(665, 'Aitutaki', 54),
(666, 'Atiu', 54),
(667, 'Mangaia', 54),
(668, 'Mauke', 54),
(669, 'Rarotonga', 54),
(670, 'Manuae', 54),
(671, 'Mitiaro', 54),
(672, 'Takutea', 54),
(673, 'Manihiki', 54),
(674, 'Nassau', 54),
(675, 'Palmerston Island', 54),
(676, 'Penrhyn Island', 54),
(677, 'Pukapuka', 54),
(678, 'Rakahanga', 54),
(679, 'Suwarrow', 54),
(680, 'San Jose', 55),
(681, 'Alajuela', 55),
(682, 'Cartago', 55),
(683, 'Heredia', 55),
(684, 'Guanacaste', 55),
(685, 'Puntarenas', 55),
(686, 'Limon', 55),
(687, 'Agneby', 56),
(688, 'Bafing', 56),
(689, 'Bas-Sassandra', 56),
(690, 'Denguele', 56),
(691, 'Dix-Huit Montagnes', 56),
(692, 'Fromager', 56),
(693, 'Haut-Sassandra', 56),
(694, 'Lacs', 56),
(695, 'Lagunes', 56),
(696, 'Marahoue', 56),
(697, 'Moyen-Cavally', 56),
(698, 'Moyen-Comoe', 56),
(699, 'N''zi-Comoe', 56),
(700, 'Savanes', 56),
(701, 'Sud-Bandama', 56),
(702, 'Sud-Comoe', 56),
(703, 'Vallee du Bandama', 56),
(704, 'Worodougou', 56),
(705, 'Zanzan', 56),
(706, 'Zagreb county', 57),
(707, 'Krapina-Zagorje county', 57),
(708, 'Sisak-Moslavina county', 57),
(709, 'Karlovac county', 57),
(710, 'Varazdin County', 57),
(711, 'Koprivnica', 57),
(712, 'Bjelovar-Bilogora county', 57),
(713, 'Primorje-Gorski Kotar county', 57),
(714, 'Lika-Senj county', 57),
(715, 'Virovitica-Podravina county', 57),
(716, 'Slavonia county', 57),
(717, 'Brod-Posavina county', 57),
(718, 'Zadar county', 57),
(719, 'Osijek-Baranja county', 57),
(720, 'Šibenik-Knin county', 57),
(721, 'Vukovar-Srijem county', 57),
(722, 'Split-Dalmatia county', 57),
(723, 'Istria county', 57),
(724, 'Dubrovnik-Neretva county', 57),
(725, 'Medimurje County', 57),
(726, 'Zagreb', 57),
(727, 'Isla de la Juventud (Isle of Youth)', 58),
(728, 'Pinar del Rio', 58),
(729, 'La Habana (Havana)', 58),
(730, 'Ciudad de la Habana (Havana City)', 58),
(731, 'Matanzas', 58),
(732, 'Cienfuegos', 58),
(733, 'Villa Clara', 58),
(734, 'Sancti Spiritus', 58),
(735, 'Ciego de Avila', 58),
(736, 'Camaguey', 58),
(737, 'Las Tunas', 58),
(738, 'Granma', 58),
(739, 'Holguin', 58),
(740, 'Santiago de Cuba', 58),
(741, 'Guantanamo', 58),
(742, 'Famagusta', 59),
(743, 'Kyrenia', 59),
(744, 'Larnaca', 59),
(745, 'Limassol', 59),
(746, 'Nicosia', 59),
(747, 'Paphos', 59),
(748, 'South Moravian Region', 60),
(749, 'Central Bohemian Region', 60),
(750, 'Hradec Kralove Region', 60),
(751, 'Vyscina Region', 60),
(752, 'Carlsbad Region', 60),
(753, 'Liberec Region', 60),
(754, 'Moravian-Silesian Region', 60),
(755, 'Olomouc Region', 60),
(756, 'Pardubice Region', 60),
(757, 'Plzen Region', 60),
(758, 'Prague', 60),
(759, 'South Bohemian Region', 60),
(760, 'Ústi nad Labem Region', 60),
(761, 'Zlin Region', 60),
(762, 'Copenhagen', 61),
(763, 'Frederiksberg', 61),
(764, 'Copenhagen County', 61),
(765, 'Frederiksborg', 61),
(766, 'Roskilde', 61),
(767, 'West Zealand', 61),
(768, 'Storstrom', 61),
(769, 'Funen', 61),
(770, 'South Jutland', 61),
(771, 'Ribe', 61),
(772, 'Vejle', 61),
(773, 'Ringkjobing', 61),
(774, 'Viborg', 61),
(775, 'North Jutland', 61),
(776, 'Aarhus', 61),
(777, 'Bornholm', 61),
(778, 'Dhekelia', 62),
(779, 'Djibouti', 63),
(780, 'Saint Andrew Parish', 64),
(781, 'Saint David Parish', 64),
(782, 'Saint George Parish', 64),
(783, 'Saint John Parish', 64),
(784, 'Saint Joseph Parish', 64),
(785, 'Saint Luke Parish', 64),
(786, 'Saint Mark Parish', 64),
(787, 'Saint Patrick Parish', 64),
(788, 'Saint Paul Parish', 64),
(789, 'Saint Peter Parish', 64),
(790, 'Azua', 65),
(791, 'Baoruco', 65),
(792, 'Barahona', 65),
(793, 'Dajabon', 65),
(794, 'Duarte', 65),
(795, 'Elias Pina', 65),
(796, 'El Seibo', 65),
(797, 'Espaillat', 65),
(798, 'Hato Mayor', 65),
(799, 'Independencia', 65),
(800, 'La Altagracia', 65),
(801, 'La Romana', 65),
(802, 'La Vega', 65),
(803, 'Maria Trinidad Sanchez', 65),
(804, 'Monsenor Nouel', 65),
(805, 'Monte Cristi', 65),
(806, 'Monte Plata', 65),
(807, 'Pedernales', 65),
(808, 'Peravia', 65),
(809, 'Puerto Plata', 65),
(810, 'Salcedo', 65),
(811, 'Samana', 65),
(812, 'Sanchez Ramirez (Cotui)', 65),
(813, 'San Cristobal', 65),
(814, 'San Jose de Ocoa', 65),
(815, 'San Juan', 65),
(816, 'San Pedro de Macoris', 65),
(817, 'Santiago', 65),
(818, 'Santiago Rodriguez', 65),
(819, 'Santo Domingo', 65),
(820, 'Valverde', 65),
(821, 'Azuay', 66),
(822, 'Bolivar', 66),
(823, 'Canar', 66),
(824, 'Carchi', 66),
(825, 'Chimborazo', 66),
(826, 'Cotopaxi', 66),
(827, 'El Oro', 66),
(828, 'Esmeraldas', 66),
(829, 'Galapagos', 66),
(830, 'Guayas', 66),
(831, 'Imbabura', 66),
(832, 'Loja', 66),
(833, 'Los Rios', 66),
(834, 'Manabi', 66),
(835, 'Morona-Santiago', 66),
(836, 'Napo', 66),
(837, 'Orellana', 66),
(838, 'Pastaza Province', 66),
(839, 'Pichincha', 66),
(840, 'Sucumbios', 66),
(841, 'Tungurahua', 66),
(842, 'Zamora-Chinchipe', 66),
(843, 'Ad Daqahliyah', 67),
(844, 'Al Bahr al Ahmar', 67),
(845, 'Al Buhayrah', 67),
(846, 'Al Fayyum', 67),
(847, 'Al Gharbiyah', 67),
(848, 'Al Iskandariyah', 67),
(849, 'Al Isma''iliyah', 67),
(850, 'Al Jizah', 67),
(851, 'Al Minufiyah', 67),
(852, 'Al Minya', 67),
(853, 'Al Qahirah', 67),
(854, 'Al Qalyubiyah', 67),
(855, 'Al Uqsur', 67),
(856, 'Al Wadi al Jadid', 67),
(857, 'Ash Sharqiyah', 67),
(858, 'As Suways', 67),
(859, 'Aswan', 67),
(860, 'Asyut', 67),
(861, 'Bani Suwayf', 67),
(862, 'Bur Sa''id', 67),
(863, 'Dimyat', 67),
(864, 'Janub Sina', 67),
(865, 'Kafr ash Shaykh', 67),
(866, 'Matruh', 67),
(867, 'Qina', 67),
(868, 'Shamal Sina', 67),
(869, 'Suhaj', 67),
(870, 'Ahuachapan', 68),
(871, 'Cabanas', 68),
(872, 'Chalatenango', 68),
(873, 'Cuscatlan', 68),
(874, 'La Libertad', 68),
(875, 'La Paz', 68),
(876, 'La Union', 68),
(877, 'Morazan', 68),
(878, 'San Miguel', 68),
(879, 'San Salvador', 68),
(880, 'San Vicente', 68),
(881, 'Santa Ana', 68),
(882, 'Sonsonate', 68),
(883, 'Usulutan', 68),
(884, 'Annobon Province', 69),
(885, 'Bioko Norte Province', 69),
(886, 'Bioko Sur Province', 69),
(887, 'Centro Sur Province', 69),
(888, 'Kie-Ntem Province', 69),
(889, 'Litoral Province', 69),
(890, 'Wele-Nzas Province', 69),
(891, 'Anseba', 70),
(892, 'Central Bohemian Region', 70),
(893, 'Gash-Barka', 70),
(894, 'Northern Red Sea', 70),
(895, 'Southern', 70),
(896, 'Southern Red Sea', 70),
(897, 'Harju', 71),
(898, 'Hiiu', 71),
(899, 'Ida-Viru (Eastern Viru)', 71),
(900, 'Jogeva', 71),
(901, 'Järva', 71),
(902, 'Lääne (Western)', 71),
(903, 'Lääne-Viru (Western Viru)', 71),
(904, 'Polva', 71),
(905, 'Pärnu', 71),
(906, 'Rapla', 71),
(907, 'Saare', 71),
(908, 'Tartu', 71),
(909, 'Valga', 71),
(910, 'Viljandi', 71),
(911, 'Voru', 71),
(912, 'Addis Ababa', 72),
(913, 'Afar', 72),
(914, 'Amhara', 72),
(915, 'Benishangul-Gumaz', 72),
(916, 'Dire Dawa', 72),
(917, 'Gambela', 72),
(918, 'Harari', 72),
(919, 'Oromia', 72),
(920, 'Somali', 72),
(921, 'Southern Nations', 72),
(922, 'Tigray', 72),
(923, 'Falkland Islands', 73),
(924, 'Faroe Islands', 74),
(925, 'Suva', 75),
(926, 'Labasa', 75),
(927, 'Levuka', 75),
(928, 'Lautoka', 75),
(929, 'Southern Finland', 76),
(930, 'Western Finland', 76),
(931, 'Eastern Finland', 76),
(932, 'Oulu', 76),
(933, 'Lapland', 76),
(934, 'Åland', 76),
(935, 'Paris', 77),
(936, 'Berry', 77),
(937, 'Orleanais', 77),
(938, 'Normandy', 77),
(939, 'Languedoc', 77),
(940, 'Lyonnais', 77),
(941, 'Dauphine', 77),
(942, 'Champagne', 77),
(943, 'Aunis', 77),
(944, 'Saintonge', 77),
(945, 'Poitou', 77),
(946, 'Guyenne and Gascony', 77),
(947, 'Burgundy', 77),
(948, 'Picardy', 77),
(949, 'Anjou', 77),
(950, 'Angoumois', 77),
(951, 'Bourbonnais', 77),
(952, 'Marche', 77),
(953, 'Brittany', 77),
(954, 'Maine', 77),
(955, 'Touraine', 77),
(956, 'Limousin', 77),
(957, 'Foix', 77),
(958, 'Auvergne', 77),
(959, 'Bearn', 77),
(960, 'Alsace', 77),
(961, 'Artois', 77),
(962, 'Roussillon', 77),
(963, 'Flanders and Hainaut', 77),
(964, 'Franche-Comte (Besancon)', 77),
(965, 'Lorraine (Nancy)', 77),
(966, 'Corsica (off map, Ajaccio)', 77),
(967, 'Nivernais (Nevers)', 77),
(968, 'Comtat Venaissin, a Papal fief', 77),
(969, 'Imperial Free City of Mulhouse', 77),
(970, 'Savoy, a Sardinian fief', 77),
(971, 'Nice, a Sardinian fief', 77),
(972, 'Montbeliard', 77),
(973, 'Windward Islands', 78),
(974, 'Leeward Islands', 78),
(975, 'Marquesas Islands', 78),
(976, 'Austral Islands', 78),
(977, 'Tuamotu-Gambier', 78),
(978, 'Estuaire', 79),
(979, 'Haut-Ogooue', 79),
(980, 'Moyen-Ogooue', 79),
(981, 'Ngounie', 79),
(982, 'Nyanga', 79),
(983, 'Ogooue-Ivindo', 79),
(984, 'Ogooue-Lolo', 79),
(985, 'Ogooue-Maritime', 79),
(986, 'Woleu-Ntem', 79),
(987, 'Lower River', 80),
(988, 'Central River', 80),
(989, 'North Bank', 80),
(990, 'Upper River', 80),
(991, 'Western', 80),
(992, 'Abkhazia', 81),
(993, 'Samegrelo-Zemo Svaneti', 81),
(994, 'Guria', 81),
(995, 'Ajaria', 81),
(996, 'Racha-Lechkhumi', 81),
(997, 'Kvemo Svaneti', 81),
(998, 'Imereti', 81),
(999, 'Samtskhe-Javakheti', 81),
(1000, 'Shida Kartli', 81),
(1001, 'Mtskheta-Mtianeti', 81),
(1002, 'Kvemo Kartli', 81),
(1003, 'Kakheti', 81),
(1004, 'Tbilisi', 81),
(1005, 'Baden-Wurttemberg', 82),
(1006, 'Free State of Bavaria', 82),
(1007, 'Berlin', 82),
(1008, 'Brandenburg', 82),
(1009, 'Free Hanseatic City of Bremen', 82),
(1010, 'Free and Hanseatic City of Hamburg', 82),
(1011, 'Hesse', 82),
(1012, 'Mecklenburg-Western Pomerania', 82),
(1013, 'Lower Saxony', 82),
(1014, 'North Rhine-Westphalia', 82),
(1015, 'Rhineland-Palatinate', 82),
(1016, 'Saarland', 82),
(1017, 'Free State of Saxony', 82),
(1018, 'Saxony-Anhalt', 82),
(1019, 'Schleswig-Holstein', 82),
(1020, 'Free State of Thuringia', 82),
(1021, 'Ashanti Region', 83),
(1022, 'Brong-Ahafo Region', 83),
(1023, 'Cape Coast', 83),
(1024, 'Koforidua', 83),
(1025, 'Accra', 83),
(1026, 'Tamale', 83),
(1027, 'Bolgatanga', 83),
(1028, 'Wa', 83),
(1029, 'Ho', 83),
(1030, 'Sekondi-Takoradi', 83),
(1031, 'Gibraltar', 84),
(1032, 'Thrace', 85),
(1033, 'Macedonia', 85),
(1034, 'Thessaly', 85),
(1035, 'Epirus', 85),
(1036, 'Central Greece', 85),
(1037, 'Attica', 85),
(1038, 'Peloponnese', 85),
(1039, 'Aegean Islands', 85),
(1040, 'Ionian Islands', 85),
(1041, 'Crete', 85),
(1042, 'Greenland', 86),
(1043, 'Saint Andrew', 87),
(1044, 'Saint David', 87),
(1045, 'Saint George', 87),
(1046, 'Saint John', 87),
(1047, 'Saint Mark', 87),
(1048, 'Saint Patrick', 87),
(1049, 'Agana Heights', 88),
(1050, 'Agat', 88),
(1051, 'Asan-Maina', 88),
(1052, 'Barrigada', 88),
(1053, 'Chalan-Pago-Ordot', 88),
(1054, 'Dededo', 88),
(1055, 'Hagåtna', 88),
(1056, 'Inarajan', 88),
(1057, 'Mangilao', 88),
(1058, 'Merizo', 88),
(1059, 'Mongmong-Toto-Maite', 88),
(1060, 'Piti', 88),
(1061, 'Santa Rita', 88),
(1062, 'Sinajana', 88),
(1063, 'Talofofo', 88),
(1064, 'Tamuning', 88),
(1065, 'Tumon', 88),
(1066, 'Umatac', 88),
(1067, 'Yigo', 88),
(1068, 'Yona', 88),
(1069, 'Alta Verapaz', 89),
(1070, 'Baja Verapaz', 89),
(1071, 'Chimaltenango', 89),
(1072, 'Chiquimula', 89),
(1073, 'Peten', 89),
(1074, 'El Progreso', 89),
(1075, 'Quiche', 89),
(1076, 'Escuintla', 89),
(1077, 'Guatemala', 89),
(1078, 'Huehuetenango', 89),
(1079, 'Jalapa', 89),
(1080, 'Jutiapa', 89),
(1081, 'Quetzaltenango', 89),
(1082, 'Retalhuleu', 89),
(1083, 'Sacatepequez', 89),
(1084, 'San Marcos', 89),
(1085, 'Santa Rosa', 89),
(1086, 'Solola', 89),
(1087, 'Suchitepequez', 89),
(1088, 'Totonicapan', 89),
(1089, 'Zacapa', 89),
(1090, 'Castel', 90),
(1091, 'Forest', 90),
(1092, 'St Andrew', 90),
(1093, 'St Martin', 90),
(1094, 'St Peter Port', 90),
(1095, 'St Pierre du Bois', 90),
(1096, 'St Sampson', 90),
(1097, 'St Saviour', 90),
(1098, 'Torteval', 90),
(1099, 'Vale', 90),
(1100, 'Boke Region', 91),
(1101, 'Conakry Region', 91),
(1102, 'Faranah Region', 91),
(1103, 'Kankan Region', 91),
(1104, 'Kindia Region', 91),
(1105, 'Labe Region', 91),
(1106, 'Mamou Region', 91),
(1107, 'Nzerekore Region', 91),
(1108, 'Bafata Region', 92),
(1109, 'Biombo Region', 92),
(1110, 'Bissau Region', 92),
(1111, 'Bolama Region', 92),
(1112, 'Cacheu Region', 92),
(1113, 'Gabu Region', 92),
(1114, 'Oio Region', 92),
(1115, 'Quinara Region', 92),
(1116, 'Tombali Region', 92),
(1117, 'Guyana', 93),
(1118, 'Artibonite', 94),
(1119, 'Centre', 94),
(1120, 'Grand''Anse', 94),
(1121, 'Nippes', 94),
(1122, 'Nord', 94),
(1123, 'Nord-Est', 94),
(1124, 'Nord-Ouest', 94),
(1125, 'Ouest', 94),
(1126, 'Sud', 94),
(1127, 'Sud-Est', 94),
(1128, 'Atlantida', 95),
(1129, 'Choluteca', 95),
(1130, 'Colon', 95),
(1131, 'Comayagua', 95),
(1132, 'Copan', 95),
(1133, 'Cortes', 95),
(1134, 'El Paraiso', 95),
(1135, 'Francisco Morazan', 95),
(1136, 'Gracias a Dios', 95),
(1137, 'Islands', 96),
(1138, 'Kwai Tsing (Kwai Chung and Tsing Yi)', 96),
(1139, 'North', 96),
(1140, 'Sai Kung', 96),
(1141, 'Sha Tin', 96),
(1142, 'Tai Po', 96),
(1143, 'Tsuen Wan', 96),
(1144, 'Tuen Mun', 96),
(1145, 'Yuen Long', 96),
(1146, 'Kowloon City', 96),
(1147, 'Kwun Tong', 96),
(1148, 'Sham Shui Po', 96),
(1149, 'Wong Tai Sin', 96),
(1150, 'Yau Tsim Mong', 96),
(1151, 'Central and Western', 96),
(1152, 'Eastern', 96),
(1153, 'Southern', 96),
(1154, 'Wan Chai', 96),
(1155, 'Bekescsaba', 97),
(1156, 'Debrecen', 97),
(1157, 'Dunaujvaros', 97),
(1158, 'Eger', 97),
(1159, 'Érd', 97),
(1160, 'Gyor', 97),
(1161, 'Hodmezovasarhely', 97),
(1162, 'Kaposvar', 97),
(1163, 'Kecskemet', 97),
(1164, 'Miskolc', 97),
(1165, 'Nagykanizsa', 97),
(1166, 'Nyiregyhaza', 97),
(1167, 'Pecs', 97),
(1168, 'Salgotarjan', 97),
(1169, 'Sopron', 97),
(1170, 'Szeged', 97),
(1171, 'Szekszard', 97),
(1172, 'Szekesfehervar', 97),
(1173, 'Szolnok', 97),
(1174, 'Szombathely', 97),
(1175, 'Tatabanya', 97),
(1176, 'Veszprem', 97),
(1177, 'Zalaegerszeg', 97),
(1178, 'Bacs-Kiskun', 97),
(1179, 'Baranya', 97),
(1180, 'Bekes', 97),
(1181, 'Borsod-Abauj-Zemplen', 97),
(1182, 'Csongrad', 97),
(1183, 'Fejer', 97),
(1184, 'Moson-Sopron', 97),
(1185, 'Hajdu-Bihar', 97),
(1186, 'Heves', 97),
(1187, 'Jasz-Nagykun-Szolnok', 97),
(1188, 'Komarom-Esztergom', 97),
(1189, 'Nograd', 97),
(1190, 'Pest', 97),
(1191, 'Somogy', 97),
(1192, 'Szabolcs-Szatmar-Bereg', 97),
(1193, 'Tolna', 97),
(1194, 'Vas', 97),
(1195, 'Veszprem', 97),
(1196, 'Zala', 97),
(1197, 'Austurland', 98),
(1198, 'Hofuoborgarsvaoi', 98),
(1199, 'Norourland eystra', 98),
(1200, 'Norourland vestra', 98),
(1201, 'Suourland', 98),
(1202, 'Suournes', 98),
(1203, 'Vestfiroir', 98),
(1204, 'Vesturland', 98),
(1205, 'Andhra Pradesh', 99),
(1206, 'Arunachal Pradesh', 99),
(1207, 'Assam', 99),
(1208, 'Bihar', 99),
(1209, 'Chhattisgarh', 99),
(1210, 'Goa', 99),
(1211, 'Gujarat', 99),
(1212, 'Haryana', 99),
(1213, 'Himachal Pradesh', 99),
(1214, 'Jammu and Kashmir', 99),
(1215, 'Jharkhand', 99),
(1216, 'Karnataka', 99),
(1217, 'Kerala', 99),
(1218, 'Madhya Pradesh', 99),
(1219, 'Maharashtra', 99),
(1220, 'Manipur', 99),
(1221, 'Meghalaya', 99),
(1222, 'Mizoram', 99),
(1223, 'Nagaland', 99),
(1224, 'Orissa', 99),
(1225, 'Punjab', 99),
(1226, 'Rajasthan', 99),
(1227, 'Sikkim', 99),
(1228, 'Tamil Nadu', 99),
(1229, 'Tripura', 99),
(1230, 'Uttaranchal', 99),
(1231, 'Uttar Pradesh', 99),
(1232, 'West Bengal', 99),
(1233, 'Andaman and Nicobar Islands', 99),
(1234, 'Chandigarh', 99),
(1235, 'Dadra and Nagar Haveli', 99),
(1236, 'Daman and Diu', 99),
(1237, 'Lakshadweep', 99),
(1238, 'Pondicherry', 99),
(1239, 'National Capital Territory of Delhi', 99),
(1240, 'Nanggroe Aceh Darussalam', 100),
(1241, 'North Sumatra (Sumatera Utara)', 100),
(1242, 'West Sumatra (Sumatera Barat)', 100),
(1243, 'Riau', 100),
(1244, 'Riau Islands (Kepulauan Riau)', 100),
(1245, 'Jambi', 100),
(1246, 'Bengkulu', 100),
(1247, 'South Sumatra', 100),
(1248, 'Bangka-Belitung', 100),
(1249, 'Lampung', 100),
(1250, 'Jakarta Special Capital Region', 100),
(1251, 'Banten', 100),
(1252, 'West Java', 100),
(1253, 'Central Java', 100),
(1254, 'Yogyakarta Special Region', 100),
(1255, 'East Java', 100),
(1256, 'Bali', 100),
(1257, 'West Nusa Tenggara', 100),
(1258, 'East Nusa Tenggara', 100),
(1259, 'West Kalimantan', 100),
(1260, 'Central Kalimantan', 100),
(1261, 'South Kalimantan', 100),
(1262, 'East Kalimantan', 100),
(1263, 'North Sulawesi', 100),
(1264, 'Gorontalo', 100),
(1265, 'Central Sulawesi', 100),
(1266, 'South East Sulawesi', 100),
(1267, 'South Sulawesi', 100),
(1268, 'West Sulawesi', 100),
(1269, 'Maluku', 100),
(1270, 'North Maluku', 100),
(1271, 'Papua', 100),
(1272, 'West Irian Jaya', 100),
(1273, 'Tehran', 101),
(1274, 'Qom', 101),
(1275, 'Markazi', 101),
(1276, 'Qazvin', 101),
(1277, 'Gilan', 101),
(1278, 'Ardabil', 101),
(1279, 'Zanjan', 101),
(1280, 'East Azarbaijan', 101),
(1281, 'West Azarbaijan', 101),
(1282, 'Kurdistan', 101),
(1283, 'Hamedan', 101),
(1284, 'Kermanshah', 101),
(1285, 'Ilam', 101),
(1286, 'Lorestan', 101),
(1287, 'Khuzestan', 101),
(1288, 'Chaharmahal and Bakhtiari', 101),
(1289, 'Kohkiluyeh and Buyer Ahmad', 101),
(1290, 'Bushehr', 101),
(1291, 'Fars', 101),
(1292, 'Hormozgan', 101),
(1293, 'Sistan and Baluchistan', 101),
(1294, 'Kerman', 101),
(1295, 'Yazd', 101),
(1296, 'Esfahan', 101),
(1297, 'Semnan', 101),
(1298, 'Mazandaran', 101),
(1299, 'Golestan', 101),
(1300, 'North Khorasan', 101),
(1301, 'Razavi Khorasan', 101),
(1302, 'South Khorasan', 101),
(1303, 'Baghdad', 102),
(1304, 'Salah ad Din', 102),
(1305, 'Diyala', 102),
(1306, 'Wasit', 102),
(1307, 'Maysan', 102),
(1308, 'Al Basrah', 102),
(1309, 'Dhi Qar', 102),
(1310, 'Al Muthanna', 102),
(1311, 'Al-Quadisiyyah', 102),
(1312, 'Babil', 102),
(1313, 'Karbala', 102),
(1314, 'An Najaf', 102),
(1315, 'Al Anbar', 102),
(1316, 'Ninawa', 102),
(1317, 'Dahuk', 102),
(1318, 'Arbil', 102),
(1319, 'At Ta''mim (Kirkuk)', 102),
(1320, 'As Sulaymaniyah', 102),
(1321, 'Dublin', 103),
(1322, 'Wicklow', 103),
(1323, 'Wexford', 103),
(1324, 'Carlow', 103),
(1325, 'Kildare', 103),
(1326, 'Meath', 103),
(1327, 'Louth', 103),
(1328, 'Monaghan', 103),
(1329, 'Cavan', 103),
(1330, 'Longford', 103),
(1331, 'Westmeath', 103),
(1332, 'Offaly', 103),
(1333, 'Laois', 103),
(1334, 'Kilkenny', 103),
(1335, 'Waterford', 103),
(1336, 'Cork', 103),
(1337, 'Kerry', 103),
(1338, 'Limerick', 103),
(1339, 'Tipperary', 103),
(1340, 'Clare', 103),
(1341, 'Galway', 103),
(1342, 'Mayo', 103),
(1343, 'Roscommon', 103),
(1344, 'Sligo', 103),
(1345, 'Leitrim', 103),
(1346, 'Donegal', 103),
(1347, 'Isle of Man', 104),
(1348, 'Jerusalem district', 105),
(1349, 'North district', 105),
(1350, 'Haifa district', 105),
(1351, 'Center district', 105),
(1352, 'Tel Aviv district', 105),
(1353, 'Southern district', 105),
(1354, 'Judea and Samaria District', 105),
(1355, 'Abruzzo', 106),
(1356, 'Basilicata', 106),
(1357, 'Calabria', 106),
(1358, 'Campania', 106),
(1359, 'Emilia-Romagna', 106),
(1360, 'Friuli-Venezia Giulia', 106),
(1361, 'Latium', 106),
(1362, 'Liguria', 106),
(1363, 'Lombardy', 106),
(1364, 'Marches', 106),
(1365, 'Molise', 106),
(1366, 'Piedmont', 106),
(1367, 'Apulia', 106),
(1368, 'Sardinia', 106),
(1369, 'Aosta Valley', 106),
(1370, 'Tuscany', 106),
(1371, 'Trentino-South Tyro', 106),
(1372, 'Umbria', 106),
(1373, 'Sicily', 106),
(1374, 'Veneto', 106),
(1375, 'Ivory Coast', 107),
(1376, 'Clarendon', 108),
(1377, 'Hanover', 108),
(1378, 'Kingston', 108),
(1379, 'Manchester', 108),
(1380, 'Portland', 108),
(1381, 'Saint Andrew', 108),
(1382, 'Saint Ann', 108),
(1383, 'Saint Catherine', 108),
(1384, 'Saint Elizabeth', 108),
(1385, 'Saint James', 108),
(1386, 'Saint Mary', 108),
(1387, 'Saint Thomas', 108),
(1388, 'Trelawny', 108),
(1389, 'Westmoreland', 108),
(1390, 'Hokkaido', 109),
(1391, 'Tohoku', 109),
(1392, 'Kanto', 109),
(1393, 'Chubu', 109),
(1394, 'Kinki', 109),
(1395, 'Chugoku', 109),
(1396, 'Shikoku', 109),
(1397, 'Kyushu', 109),
(1398, 'Okinawa', 109),
(1399, 'Saint Helier', 110),
(1400, 'Saint Saviour', 110),
(1401, 'Saint Clement', 110),
(1402, 'Grouville', 110),
(1403, 'Saint Martin', 110),
(1404, 'Trinity', 110),
(1405, 'Saint John', 110),
(1406, 'Saint Mary', 110),
(1407, 'Saint Ouen', 110),
(1408, 'Saint Peter', 110),
(1409, 'Saint Brelade', 110),
(1410, 'Saint Lawrence', 110),
(1411, 'Ajlun', 111),
(1412, 'Amman', 111),
(1413, 'Aqaba', 111),
(1414, 'Balqa', 111),
(1415, 'Irbid', 111),
(1416, 'Jerash', 111),
(1417, 'Kerak', 111),
(1418, 'Ma''an', 111),
(1419, 'Madaba', 111),
(1420, 'Mafraq', 111),
(1421, 'Tafilah', 111),
(1422, 'Zarqa', 111),
(1423, 'Almaty', 112),
(1424, 'Aqmola', 112),
(1425, 'Aqtobe', 112),
(1426, 'Astana', 112),
(1427, 'Atyrau', 112),
(1428, 'Baikonur', 112),
(1429, 'East Kazakhstan', 112),
(1430, 'Mangghystau', 112),
(1431, 'North Kazakhstan', 112),
(1432, 'Pavlodar', 112),
(1433, 'Qaraghandy', 112),
(1434, 'Qostanay', 112),
(1435, 'Qyzylorda', 112),
(1436, 'South Kazakhstan', 112),
(1437, 'West Kazakhstan', 112),
(1438, 'Zhambyl', 112),
(1439, 'Central', 113),
(1440, 'Coast', 113),
(1441, 'Eastern', 113),
(1442, 'Nairobi Area', 113),
(1443, 'North Eastern', 113),
(1444, 'Nyanza', 113),
(1445, 'Rift Valley', 113),
(1446, 'Western', 113),
(1447, 'Banaba', 114),
(1448, 'Central Gilberts', 114),
(1449, 'Line Islands', 114),
(1450, 'Northern Gilberts', 114),
(1451, 'Southern Gilberts', 114),
(1452, 'Tarawa', 114),
(1453, 'Chagang Province', 115),
(1454, 'North Hamgyong Province', 115),
(1455, 'South Hamgyong Province', 115),
(1456, 'North Hwanghae Province', 115),
(1457, 'South Hwanghae Province', 115),
(1458, 'Kangwon Province', 115),
(1459, 'North Pyongan Province', 115),
(1460, 'South Pyongan Province', 115),
(1461, 'Ryanggang Province', 115),
(1462, 'Gyeonggi-do', 116),
(1463, 'Gangwon-do', 116),
(1464, 'Gyeongsangbuk-do', 116),
(1465, 'Gyeongsangnam-do', 116),
(1466, 'Jeollanam-do', 116),
(1467, 'Jeollabuk-do', 116),
(1468, 'Chungcheongnam-do', 116),
(1469, 'Chungcheongbuk-do', 116),
(1470, 'Decani', 117),
(1471, 'Dragash', 117),
(1472, 'Ferizaj', 117),
(1473, 'Fushe Kosova', 117),
(1474, 'Gjakova', 117),
(1475, 'Gllogovci', 117),
(1476, 'Gjilani', 117),
(1477, 'Istog', 117),
(1478, 'Kacanik', 117),
(1479, 'Kamenica', 117),
(1480, 'Klina', 117),
(1481, 'Leposaviq', 117),
(1482, 'Lipjan', 117),
(1483, 'Malisheve', 117),
(1484, 'Mitrovice', 117),
(1485, 'Novo Brdo', 117),
(1486, 'Obiliq', 117),
(1487, 'Rahovec', 117),
(1488, 'Peje', 117),
(1489, 'Podujeve', 117),
(1490, 'Prishtine', 117),
(1491, 'Prizren', 117),
(1492, 'Skenderaj', 117),
(1493, 'Štrpce', 117),
(1494, 'Shtime', 117),
(1495, 'Suhareke', 117),
(1496, 'Viti', 117),
(1497, 'Vushtrri', 117),
(1498, 'Zubin Potok', 117),
(1499, 'Zvecan', 117),
(1500, 'Al Ahmadi', 118),
(1501, 'Al Farwaniyah', 118),
(1502, 'Al Asimah', 118),
(1503, 'Al Jahra', 118),
(1504, 'Hawalli', 118),
(1505, 'Mubarak Al-Kabeer', 118),
(1506, 'Bishkek', 119),
(1507, 'Batken Province (Batken)', 119),
(1508, 'Chui Province (Tokmok)', 119),
(1509, 'Jalal-Abad Province (Jalal-Abad)', 119),
(1510, 'Naryn Province (Naryn)', 119),
(1511, 'Osh Province (Osh)', 119),
(1512, 'Talas Province (Talas)', 119),
(1513, 'Issyk Kul Province (Karakol)', 119),
(1514, 'Osh', 119),
(1515, 'Attapu', 120),
(1516, 'Bokeo', 120),
(1517, 'Borikhamxay', 120),
(1518, 'Champassack', 120),
(1519, 'Houaphan', 120),
(1520, 'Khammouane', 120),
(1521, 'Louang Namtha', 120),
(1522, 'Louangphabang', 120),
(1523, 'Oudomxay', 120),
(1524, 'Phongsaly', 120),
(1525, 'Saravane', 120),
(1526, 'Savannakhet', 120),
(1527, 'Vientiane', 120),
(1528, 'Vientiane Province', 120),
(1529, 'Sayaboury', 120),
(1530, 'Saysomboun', 120),
(1531, 'Xekong', 120),
(1532, 'Xieng Khouang', 120),
(1533, 'Aizkraukle District', 121),
(1534, 'Aluksne District', 121),
(1535, 'Balvi District', 121),
(1536, 'Bauska District', 121),
(1537, 'Cesis District', 121),
(1538, 'Daugavpils District', 121),
(1539, 'Dobele District', 121),
(1540, 'Gulbene District', 121),
(1541, 'Kekabpils District', 121),
(1542, 'Jelgava District', 121),
(1543, 'Jurmala', 121),
(1544, 'Kraslava District', 121),
(1545, 'Kuldiga District', 121),
(1546, 'Liepaja District', 121),
(1547, 'Ogre District', 121),
(1548, 'Preliji District', 121),
(1549, 'Rezekne District', 121),
(1550, 'Riga District', 121),
(1551, 'Saldus District', 121),
(1552, 'Talsi District', 121),
(1553, 'Tukums District', 121),
(1554, 'Valka District', 121),
(1555, 'Valmiera District', 121),
(1556, 'Ventspils District', 121),
(1557, 'Beirut', 122),
(1558, 'Mount Lebanon', 122),
(1559, 'Tripoli', 122),
(1560, 'Beqaa', 122),
(1561, 'Nabatiye', 122),
(1562, 'Berea', 123),
(1563, 'Butha-Buthe', 123),
(1564, 'Leribe', 123),
(1565, 'Mafeteng', 123),
(1566, 'Maseru', 123),
(1567, 'Mohale''s Hoek', 123),
(1568, 'Mokhotlong', 123),
(1569, 'Qacha''s Nek', 123),
(1570, 'Quthing', 123),
(1571, 'Thaba-Tseka', 123),
(1572, 'Bomi', 124),
(1573, 'Bong', 124),
(1574, 'Gbarpolu', 124),
(1575, 'Grand Bassa', 124),
(1576, 'Grand Cape Mount', 124),
(1577, 'Grand Gedeh', 124),
(1578, 'Grand Kru', 124),
(1579, 'Lofa', 124),
(1580, 'Margibi', 124),
(1581, 'Maryland', 124),
(1582, 'Montserrado', 124),
(1583, 'Nimba', 124),
(1584, 'River Cess', 124),
(1585, 'River Gee', 124),
(1586, 'Sinoe', 124),
(1587, 'Ajdabiya', 125),
(1588, 'Al Butnan', 125),
(1589, 'Al Hizam Al Akhdar', 125),
(1590, 'Al Jabal al Akhdar', 125),
(1591, 'Al Jfara', 125),
(1592, 'Al Jufrah', 125),
(1593, 'Al Kufrah', 125),
(1594, 'Al Marj', 125),
(1595, 'Al Murgub', 125),
(1596, 'An Nuqat al Khams', 125),
(1597, 'Al Qubah', 125),
(1598, 'Al Wahat', 125),
(1599, 'Az Zawiyah', 125),
(1600, 'Benghazi', 125),
(1601, 'Bani Walid', 125),
(1602, 'Darnah', 125),
(1603, 'Ghat', 125),
(1604, 'Ghadamis', 125),
(1605, 'Gharyan', 125),
(1606, 'Murzuq', 125),
(1607, 'Mizdah', 125),
(1608, 'Misratah', 125),
(1609, 'Nalut', 125),
(1610, 'Tajura Wa Al Nawahi AlArba', 125),
(1611, 'Tarhuna Wa Msalata', 125),
(1612, 'Tarabulus', 125),
(1613, 'Sabha', 125),
(1614, 'Surt', 125),
(1615, 'Sabratha Wa Surman', 125),
(1616, 'Wadi Al Hayaa', 125),
(1617, 'Wadi Al Shatii', 125),
(1618, 'Yafran', 125),
(1619, 'Balzers', 126),
(1620, 'Eschen', 126),
(1621, 'Gamprin', 126),
(1622, 'Mauren', 126),
(1623, 'Planken', 126),
(1624, 'Ruggell', 126),
(1625, 'Schaan', 126),
(1626, 'Schellenberg', 126),
(1627, 'Triesen', 126),
(1628, 'Triesenberg', 126),
(1629, 'Vaduz', 126),
(1630, 'Alytus', 127),
(1631, 'Kaunas', 127),
(1632, 'Klaipeda', 127),
(1633, 'Marijampole', 127),
(1634, 'Panevezys', 127),
(1635, 'Siauliai', 127),
(1636, 'Taurage', 127),
(1637, 'Telsiai', 127),
(1638, 'Utena', 127),
(1639, 'Vilnius', 127),
(1640, 'Diekirch', 128),
(1641, 'Grevenmacher', 128),
(1642, 'Luxembourg', 128),
(1643, 'The Macau Peninsula', 129),
(1644, 'Taipa and Coloane', 129),
(1645, 'Eastern', 130),
(1646, 'NorthEastern', 130),
(1647, 'Pelagonia', 130),
(1648, 'Polog', 130),
(1649, 'Skopje', 130),
(1650, 'Southeastern', 130),
(1651, 'Southwestern', 130),
(1652, 'Vardar', 130),
(1653, 'Antananarivo', 131),
(1654, 'Antsiranana', 131),
(1655, 'Fianarantsoa', 131),
(1656, 'Mahajanga', 131),
(1657, 'Toamasina', 131),
(1658, 'Toliara', 131),
(1659, 'Dedza', 132),
(1660, 'Dowa', 132),
(1661, 'Kasungu', 132),
(1662, 'Lilongwe', 132),
(1663, 'Mchinji', 132),
(1664, 'Nkhotakota', 132),
(1665, 'Ntcheu', 132),
(1666, 'Ntchisi', 132),
(1667, 'Salima', 132),
(1668, 'Chitipa', 132),
(1669, 'Karonga', 132),
(1670, 'Likoma', 132),
(1671, 'Mzimba', 132),
(1672, 'Nkhata Bay', 132),
(1673, 'Rumphi', 132),
(1674, 'Balaka', 132),
(1675, 'Blantyre', 132),
(1676, 'Chikwawa', 132),
(1677, 'Chiradzulu', 132),
(1678, 'Machinga', 132),
(1679, 'Mangochi', 132),
(1680, 'Mulanje', 132),
(1681, 'Mwanza', 132),
(1682, 'Nsanje', 132),
(1683, 'Thyolo', 132),
(1684, 'Phalombe', 132),
(1685, 'Zomba', 132),
(1686, 'Sultanate of Johor', 133),
(1687, 'Sultanate of Kedah', 133),
(1688, 'Sultanate of Kelantan', 133),
(1689, 'Melaka', 133),
(1690, 'Elective Monarchy of Negeri Sembilan', 133),
(1691, 'Sultanate of Pahang', 133),
(1692, 'Sultanate of Perak', 133),
(1693, 'Kingdom of Perlis', 133),
(1694, 'Pulau Pinang', 133),
(1695, 'Sultanate of Selangor', 133),
(1696, 'Sultanate of Terengganu', 133),
(1697, 'Haa Alif', 134),
(1698, 'Haa Dhaalu', 134),
(1699, 'Shaviyani', 134),
(1700, 'Noonu', 134),
(1701, 'Raa', 134),
(1702, 'Baa', 134),
(1703, 'Lhaviyani', 134),
(1704, 'Kaafu', 134),
(1705, 'Alif Alif', 134),
(1706, 'Alif Dhaal', 134),
(1707, 'Vaavu', 134),
(1708, 'Meemu', 134),
(1709, 'Faafu', 134),
(1710, 'Dhaalu', 134),
(1711, 'Thaa', 134),
(1712, 'Laamu', 134),
(1713, 'Gaafu Alif', 134),
(1714, 'Gaafu Dhaalu', 134),
(1715, 'Gnaviyani', 134),
(1716, 'Seenu', 134),
(1717, 'Gao', 135),
(1718, 'Kayes', 135),
(1719, 'Kidal', 135),
(1720, 'Koulikoro', 135),
(1721, 'Mopti', 135),
(1722, 'Segou', 135),
(1723, 'Sikasso', 135),
(1724, 'Tombouctou', 135),
(1725, 'Bamako', 135),
(1726, 'Comino', 136),
(1727, 'Cominotto', 136),
(1728, 'Filfla', 136),
(1729, 'Gozo', 136),
(1730, 'Islands of St. Paul', 136),
(1731, 'Malta Island', 136),
(1732, 'Manoel Island', 136),
(1733, 'Ailinglaplap Atoll', 137),
(1734, 'Ailuk Atoll', 137),
(1735, 'Arno', 137),
(1736, 'Aur Atoll', 137),
(1737, 'Ebon Atoll', 137),
(1738, 'Enewetak Atoll', 137),
(1739, 'Jabat Island', 137),
(1740, 'Jaluit Atoll', 137),
(1741, 'Kili Island', 137),
(1742, 'Kwajalein Atoll', 137),
(1743, 'Lae Atoll', 137),
(1744, 'Lib Island', 137),
(1745, 'Likiep Atoll', 137),
(1746, 'Majuro Atoll', 137),
(1747, 'Maloelap Atoll', 137),
(1748, 'Mejit Island', 137),
(1749, 'Mili Atoll', 137),
(1750, 'Namorik Atoll', 137),
(1751, 'Namu Atoll', 137),
(1752, 'Rongelap Atoll', 137),
(1753, 'Ujae Atoll', 137),
(1754, 'Ujelang Atoll', 137),
(1755, 'Utirik Atoll', 137),
(1756, 'Wotho Atoll', 137),
(1757, 'Wotje Atoll', 137),
(1758, 'Adrar', 138),
(1759, 'Assaba', 138),
(1760, 'Brakna', 138),
(1761, 'Dakhlet Nouadhibou', 138),
(1762, 'Gorgol', 138),
(1763, 'Guidimaka', 138),
(1764, 'Hodh Ech Chargui', 138),
(1765, 'Hodh El Gharbi', 138),
(1766, 'Inchiri', 138),
(1767, 'Tagant', 138),
(1768, 'Tiris Zemmour', 138),
(1769, 'Trarza', 138),
(1770, 'Black River', 139),
(1771, 'Flacq', 139),
(1772, 'Grand Port', 139),
(1773, 'Moka', 139),
(1774, 'Pamplemousses', 139),
(1775, 'Plaines Wilhems', 139),
(1776, 'Port Louis', 139),
(1777, 'Riviere du Rempart', 139),
(1778, 'Savanne', 139),
(1779, 'Chissioua Bandrele', 140),
(1780, 'Chissioua Handrema', 140),
(1781, 'Chissioua Karoni', 140),
(1782, 'Chissioua Kolo Issa', 140),
(1783, 'Chissioua Mbouini', 140),
(1784, 'Chissioua Mbouzi', 140),
(1785, 'Chissioua Mtiti', 140),
(1786, 'Chissioua Mtsamboro', 140),
(1787, 'Chissioua Mtsongoma', 140),
(1788, 'Chissioua Pengoua', 140),
(1789, 'Chissioua Pouhou', 140),
(1790, 'Chissioua Sada', 140),
(1791, 'Ile Andrema', 140),
(1792, 'Ile Blanche', 140),
(1793, 'Ile Kakazou', 140),
(1794, 'Ile Mogte Amiri', 140),
(1795, 'Ile Vatou', 140),
(1796, 'Ile Verte', 140),
(1797, 'Iles Choazil', 140),
(1798, 'Iles Hajangoua', 140),
(1799, 'Ilot De Sable Blanc', 140),
(1800, 'Les Quatre Freres', 140),
(1801, 'Aguascalientes', 141),
(1802, 'Baja California', 141),
(1803, 'Baja California Sur', 141),
(1804, 'Campeche', 141),
(1805, 'Chiapas', 141),
(1806, 'Chihuahua', 141),
(1807, 'Coahuila', 141),
(1808, 'Colima', 141),
(1809, 'Durango', 141),
(1810, 'Guanajuato', 141),
(1811, 'Guerrero', 141),
(1812, 'Hidalgo', 141),
(1813, 'Jalisco', 141),
(1814, 'Mexico', 141),
(1815, 'Michoacan', 141),
(1816, 'Morelos', 141),
(1817, 'Nayarit', 141),
(1818, 'Nuevo Leon', 141),
(1819, 'Oaxaca', 141),
(1820, 'Puebla', 141),
(1821, 'Queretaro', 141),
(1822, 'Quintana Roo', 141),
(1823, 'San Luis Potosi', 141),
(1824, 'Sinaloa', 141),
(1825, 'Sonora', 141),
(1826, 'Tabasco', 141),
(1827, 'Tamaulipas', 141),
(1828, 'Tlaxcala', 141),
(1829, 'Veracruz', 141),
(1830, 'Yucatan', 141),
(1831, 'Zacatecas', 141),
(1832, 'Micronesia', 142),
(1833, 'Anenii Noi', 143),
(1834, 'Basarabeasca', 143),
(1835, 'Briceni', 143),
(1836, 'Cahul', 143),
(1837, 'Cantemir', 143),
(1838, 'Calarasi', 143),
(1839, 'Causeni', 143),
(1840, 'Cimislia', 143),
(1841, 'Criuleni', 143),
(1842, 'Donduseni', 143),
(1843, 'Drochia', 143),
(1844, 'Monaco Ville', 144),
(1845, 'Monte Carlo', 144),
(1846, 'Fontvieille', 144),
(1847, 'Monghetti', 144),
(1848, 'Arhangay', 145),
(1849, 'Bayan', 145),
(1850, 'Bayanhongor', 145),
(1851, 'Bulgan', 145),
(1852, 'Darhan-Uul', 145),
(1853, 'Dornod', 145),
(1854, 'Dornogov', 145),
(1855, 'Dundgov', 145),
(1856, 'Gov-Altay', 145),
(1857, 'Govis', 145),
(1858, 'Hentiy', 145),
(1859, 'Hovd', 145),
(1860, 'Hvsg', 145),
(1861, 'mngovi', 145),
(1862, 'Orhon', 145),
(1863, 'vrhangay', 145),
(1864, 'Selenge', 145),
(1865, 'Shbaatar', 145),
(1866, 'Ulaanbaatar', 145),
(1867, 'Uvs', 145),
(1868, 'Zavhan', 145),
(1869, 'Andrijevica', 146),
(1870, 'Bar', 146),
(1871, 'Berane', 146),
(1872, 'Bijelo Polje', 146),
(1873, 'Budva', 146),
(1874, 'Cetinje', 146),
(1875, 'Danilovgrad', 146),
(1876, 'Herceg Novi', 146),
(1877, 'Kolašin', 146),
(1878, 'Kotor', 146),
(1879, 'Mojkovac', 146),
(1880, 'Niksic', 146),
(1881, 'Plav', 146),
(1882, 'Pluzine', 146),
(1883, 'Pljevlja', 146),
(1884, 'Podgorica', 146),
(1885, 'Golubovci', 146),
(1886, 'Tuzi', 146),
(1887, 'Rozaje', 146),
(1888, 'Šavnik', 146),
(1889, 'Tivat', 146),
(1890, 'Ulcinj', 146),
(1891, 'Zabljak', 146),
(1892, 'Montserrat', 147),
(1893, 'Chaouia-Ouardigha', 148),
(1894, 'Doukkala-Abda', 148),
(1895, 'Fes-Boulemane', 148),
(1896, 'Gharb-Chrarda-Beni Hssen', 148),
(1897, 'Grand Casablanca', 148),
(1898, 'Guelmim-Es Semara', 148),
(1899, 'Laâyoune-Boujdour-Sakia El Hamra', 148),
(1900, 'Marrakech-Tensift-El Haouz', 148),
(1901, 'Cabo Delgado', 149),
(1902, 'Gaza', 149),
(1903, 'Inhambane', 149),
(1904, 'Manica', 149),
(1905, 'Maputo', 149),
(1906, 'Maputo', 149),
(1907, 'Nampula', 149),
(1908, 'Niassa', 149),
(1909, 'Sofala', 149),
(1910, 'Tete', 149),
(1911, 'Zambezia', 149),
(1912, 'Ayeyarwady Division', 150),
(1913, 'Bago Division', 150),
(1914, 'Magway Division', 150),
(1915, 'Mandalay Division', 150),
(1916, 'Sagaing Division', 150),
(1917, 'Tanintharyi Division', 150),
(1918, 'Yangon Division', 150),
(1919, 'Askeran', 151),
(1920, 'Hadrut', 151),
(1921, 'Martakert', 151),
(1922, 'Martuni', 151),
(1923, 'Shahumian', 151),
(1924, 'Shushi', 151),
(1925, 'Caprivi', 152),
(1926, 'Erongo', 152),
(1927, 'Hardap', 152),
(1928, 'Karas', 152),
(1929, 'Okavango', 152),
(1930, 'Khomas', 152),
(1931, 'Kunene', 152),
(1932, 'Ohangwena', 152),
(1933, 'Omaheke', 152),
(1934, 'Omusati', 152),
(1935, 'Oshana', 152),
(1936, 'Oshikoto', 152),
(1937, 'Otjozondjupa', 152),
(1938, 'Aiwo', 153),
(1939, 'Anabar', 153),
(1940, 'Anetan', 153),
(1941, 'Anibare', 153),
(1942, 'Baiti', 153),
(1943, 'Boe', 153),
(1944, 'Buada', 153),
(1945, 'Denigomodu', 153),
(1946, 'Ewa', 153),
(1947, 'Ijuw', 153),
(1948, 'Meneng', 153),
(1949, 'Nibok', 153),
(1950, 'Uaboe', 153),
(1951, 'Yaren', 153),
(1952, 'Bagmati', 154),
(1953, 'Bheri', 154),
(1954, 'Dhawalagiri', 154),
(1955, 'Gandaki', 154),
(1956, 'Janakpur', 154),
(1957, 'Karnali', 154),
(1958, 'Kosi', 154),
(1959, 'Drenthe', 155),
(1960, 'Flevoland', 155),
(1961, 'Friesland', 155),
(1962, 'Gelderland', 155),
(1963, 'Groningen', 155),
(1964, 'Limburg', 155),
(1965, 'North Brabant', 155),
(1966, 'North Holland', 155),
(1967, 'Overijssel', 155),
(1968, 'South Holland', 155),
(1969, 'Utrecht', 155),
(1970, 'Zeeland', 155),
(1971, 'Camia', 156),
(1972, 'Cow and Calf', 156),
(1973, 'Green Island', 156),
(1974, 'Guana Cay', 156),
(1975, 'Hen and Chicken', 156),
(1976, 'Isla Makuka', 156),
(1977, 'Kadoesji', 156),
(1978, 'Little Island', 156),
(1979, 'Little Key', 156),
(1980, 'Mal Aborder', 156),
(1981, 'Meeuwtje', 156),
(1982, 'Mollibeday Rots', 156),
(1983, 'Mona Island', 156),
(1984, 'Pelican Island', 156),
(1985, 'Penso', 156),
(1986, 'Rancho', 156),
(1987, 'Sapate Eliand', 156),
(1988, 'Willemberg', 156),
(1989, 'Belep', 157),
(1990, 'Bouloupari', 157),
(1991, 'Bourail', 157),
(1992, 'Canala', 157),
(1993, 'Dumbea', 157),
(1994, 'Farino', 157),
(1995, 'Hienghene', 157),
(1996, 'Houailou', 157),
(1997, 'L''Île-des-Pins', 157),
(1998, 'Kaala-Gomen', 157),
(1999, 'Kone', 157),
(2000, 'Kouaoua', 157),
(2001, 'Koumac', 157),
(2002, 'La Foa', 157),
(2003, 'Lifou', 157),
(2004, 'Mare', 157),
(2005, 'Moindou', 157),
(2006, 'Le Mont-Dore', 157),
(2007, 'Noumea', 157),
(2008, 'Ouegoa', 157),
(2009, 'Ouvea', 157),
(2010, 'Paita', 157),
(2011, 'Poindimie', 157),
(2012, 'Ponerihouen', 157),
(2013, 'Pouebo', 157),
(2014, 'Pouembout', 157),
(2015, 'Poum', 157),
(2016, 'Poya', 157),
(2017, 'Sarramea', 157),
(2018, 'Thio', 157),
(2019, 'Touho', 157),
(2020, 'Voh', 157),
(2021, 'Yate', 157),
(2022, 'Northland', 158),
(2023, 'Auckland', 158),
(2024, 'Waikato', 158),
(2025, 'Bay of Plenty', 158),
(2026, 'Gisborne - unitary authority', 158),
(2027, 'Hawke''s Bay', 158),
(2028, 'Taranaki', 158),
(2029, 'Manawatu-Wanganui', 158),
(2030, 'Wellington', 158),
(2031, 'Tasman - unitary authority', 158),
(2032, 'Marlborough - unitary authority', 158),
(2033, 'Nelson - unitary authority', 158),
(2034, 'West Coast', 158),
(2035, 'Canterbury', 158),
(2036, 'Otago', 158),
(2037, 'Southland', 158),
(2038, 'Boaco', 159),
(2039, 'Carazo', 159),
(2040, 'Chinandega', 159),
(2041, 'Chontales', 159),
(2042, 'Esteli', 159),
(2043, 'Granada', 159),
(2044, 'Jinotega', 159),
(2045, 'Leon', 159),
(2046, 'Madriz', 159),
(2047, 'Managua', 159),
(2048, 'Masaya', 159),
(2049, 'Matagalpa', 159),
(2050, 'Nueva Segovia', 159),
(2051, 'Rivas', 159),
(2052, 'Rio San Juan', 159),
(2053, 'Region Autonoma del Atlantico Norte', 159),
(2054, 'Region Autonoma del Atlantico Sur', 159),
(2055, 'Agadez', 160),
(2056, 'Diffa', 160),
(2057, 'Dosso', 160),
(2058, 'Maradi', 160),
(2059, 'Tahoua', 160),
(2060, 'Tillaberi', 160),
(2061, 'Zinder', 160),
(2062, 'Abia', 161),
(2063, 'Adamwa', 161),
(2064, 'Akwa Ibom', 161),
(2065, 'Anambra', 161),
(2066, 'Bauchi', 161),
(2067, 'Bayelsa', 161),
(2068, 'Benue', 161),
(2069, 'Borno', 161),
(2070, 'Cross River', 161),
(2071, 'Delta', 161),
(2072, 'Ebonyi', 161),
(2073, 'Edo', 161),
(2074, 'Ekiti', 161),
(2075, 'Enugu', 161),
(2076, 'Gombe', 161),
(2077, 'Imo', 161),
(2078, 'Jigawa', 161),
(2079, 'Kaduna', 161),
(2080, 'Katsina', 161),
(2081, 'Kebbi', 161),
(2082, 'Kogi', 161),
(2083, 'Kwara', 161),
(2084, 'Lagos', 161),
(2085, 'Nassarawa', 161),
(2086, 'Niger', 161),
(2087, 'Ogun', 161),
(2088, 'Ondo', 161),
(2089, 'Osun', 161),
(2090, 'Oyo', 161),
(2091, 'Plateau', 161),
(2092, 'Rivers', 161),
(2093, 'Sokoto', 161),
(2094, 'Taraba', 161),
(2095, 'Yobe', 161),
(2096, 'Zamfara', 161),
(2097, 'Abuja Federal Capital Territory', 161),
(2098, 'Niue', 162),
(2099, 'North Korea', 163),
(2100, 'Norfolk Island', 164),
(2101, 'Famagusta', 165),
(2102, 'Kyrenia', 165),
(2103, 'Limassol', 165),
(2104, 'Larnaca', 165),
(2105, 'Nicosia', 165),
(2106, 'Paphos', 165),
(2107, 'Farallon de Pajaros', 166),
(2108, 'Maug Islands', 166),
(2109, 'Asuncion', 166),
(2110, 'Agrihan', 166),
(2111, 'Pagan', 166),
(2112, 'Alamagan', 166),
(2113, 'Guguan', 166),
(2114, 'Sarigan', 166),
(2115, 'Anatahan', 166),
(2116, 'Farallon de Medinilla', 166),
(2117, 'Saipan', 166),
(2118, 'Tinian', 166),
(2119, 'Aguijan', 166);
INSERT INTO `tbl_state` (`StateID`, `StateName`, `CountryID`) VALUES
(2120, 'Rota', 166),
(2121, 'Akershus', 167),
(2122, 'Aust-Agder', 167),
(2123, 'Buskerud', 167),
(2124, 'Finnmark', 167),
(2125, 'Hedmark', 167),
(2126, 'Hordaland', 167),
(2127, 'More og Romsdal', 167),
(2128, 'Nordland', 167),
(2129, 'Nord-Trondelag', 167),
(2130, 'Oppland', 167),
(2131, 'Oslo', 167),
(2132, 'stfold', 167),
(2133, 'Rogaland', 167),
(2134, 'Sogn og Fjordane', 167),
(2135, 'Sor-Trondelag', 167),
(2136, 'Telemark', 167),
(2137, 'Troms', 167),
(2138, 'Vest-Agder', 167),
(2139, 'Vestfold', 167),
(2140, 'Ad Dakhiliyah', 168),
(2141, 'Al Batinah', 168),
(2142, 'Al Wusta', 168),
(2143, 'Ash Sharqiyah', 168),
(2144, 'Az Zahirah or Ad Dhahirah', 168),
(2145, 'Balochistan', 169),
(2146, 'North-West Frontier Province', 169),
(2147, 'Punjab', 169),
(2148, 'Sindh', 169),
(2149, 'Islamabad Capital Territory', 169),
(2150, 'Federally Administered Tribal Areas', 169),
(2151, 'Azad Kashmir', 169),
(2152, 'Northern Areas', 169),
(2153, 'Aimeliik', 169),
(2154, 'Airai', 170),
(2155, 'Angaur', 170),
(2156, 'Hatohobei', 170),
(2157, 'Kayangel', 170),
(2158, 'Koror', 170),
(2159, 'Melekeok', 170),
(2160, 'Ngaraard', 170),
(2161, 'Ngarchelong', 170),
(2162, 'Ngardmau', 170),
(2163, 'Ngatpang', 170),
(2164, 'Ngchesar', 170),
(2165, 'Ngaremlengui', 170),
(2166, 'Ngiwal', 170),
(2167, 'Peleliu', 170),
(2168, 'Sonsorol', 170),
(2169, 'Palestine', 171),
(2170, 'Chiriqui', 172),
(2171, 'Cocle', 172),
(2172, 'Colon', 172),
(2173, 'Darien', 172),
(2174, 'Herrera', 172),
(2175, 'Los Santos', 172),
(2176, 'Panama', 172),
(2177, 'Veraguas', 172),
(2178, 'Central', 173),
(2179, 'Simbu', 173),
(2180, 'Eastern Highlands', 173),
(2181, 'East New Britain', 173),
(2182, 'East Sepik', 173),
(2183, 'Enga', 173),
(2184, 'Gulf', 173),
(2185, 'Madang', 173),
(2186, 'Manus', 173),
(2187, 'Milne Bay', 173),
(2188, 'Morobe', 173),
(2189, 'New Ireland', 173),
(2190, 'Oro', 173),
(2191, 'North Solomons', 173),
(2192, 'Southern Highlands', 173),
(2193, 'Western', 173),
(2194, 'Western Highlands', 173),
(2195, 'West New Britain', 173),
(2196, 'Sandaun', 173),
(2197, 'National Capital District', 173),
(2198, 'Alto Paraguay', 174),
(2199, 'Alto Parana', 174),
(2200, 'Amambay', 174),
(2201, 'Asuncion Capitol', 174),
(2202, 'Boqueron', 174),
(2203, 'Caaguazu', 174),
(2204, 'Caazapa', 174),
(2205, 'Canindeyu', 174),
(2206, 'Central', 174),
(2207, 'Amazonas', 175),
(2208, 'Ancash', 175),
(2209, 'Arequipa', 175),
(2210, 'Apurimac', 175),
(2211, 'Ayacucho', 175),
(2212, 'Cajamarca', 175),
(2213, 'Cusco', 175),
(2214, 'Huancavelica', 175),
(2215, 'Huanuco', 175),
(2216, 'Ica', 175),
(2217, 'Junin', 175),
(2218, 'La Libertad', 175),
(2219, 'Lambayeque', 175),
(2220, 'Lima', 175),
(2221, 'Madre de Dios', 175),
(2222, 'Loreto', 175),
(2223, 'Moquegua', 175),
(2224, 'Pasco', 175),
(2225, 'Piura', 175),
(2226, 'Puno', 175),
(2227, 'San Martin', 175),
(2228, 'Tacna', 175),
(2229, 'Tumbes', 175),
(2230, 'Ucayali', 175),
(2231, 'Ilocos', 176),
(2232, 'Cagayan Valley', 176),
(2233, 'Central Luzon', 176),
(2234, 'Calbarzon', 176),
(2235, 'Mimaro', 176),
(2236, 'Bicol', 176),
(2237, 'Western Visayas', 176),
(2238, 'Central Visayas', 176),
(2239, 'Eastern Visayas', 176),
(2240, 'Zamboanga Peninsula', 176),
(2241, 'Northern Mindanao', 176),
(2242, 'Davao', 176),
(2243, 'Soccsksargen', 176),
(2244, 'Caraga', 176),
(2245, 'Muslim Mindanao', 176),
(2246, 'Cordillera Administrative', 176),
(2247, 'National Capital', 176),
(2248, 'Pitcairn Islands', 177),
(2249, 'Kujawsko-Pomorskie', 178),
(2250, 'Greater Poland', 178),
(2251, 'Lesser Poland', 178),
(2252, 'Lodz', 178),
(2253, 'Lower Silesian', 178),
(2254, 'Lublin', 178),
(2255, 'Lubusz', 178),
(2256, 'Mazowieckie', 178),
(2257, 'Opole', 178),
(2258, 'Podlaskie', 178),
(2259, 'Pomorskie', 178),
(2260, 'Silesian', 178),
(2261, 'Podkarpackie', 178),
(2262, 'Swietokrzyskie', 178),
(2263, 'Warmian-Masurian', 178),
(2264, 'West Pomeranian', 178),
(2265, 'Alentejo', 179),
(2266, 'Algarve', 179),
(2267, 'Centro', 179),
(2268, 'Lisboa, Region', 179),
(2269, 'Norte', 179),
(2270, 'Camenca', 180),
(2271, 'Dubossary', 180),
(2272, 'Grigoriopol', 180),
(2273, 'Rybnitsa', 180),
(2274, 'Slobozia', 180),
(2275, 'Tiraspol', 180),
(2276, 'Tighina', 180),
(2277, 'Adjuntas', 181),
(2278, 'Aguada', 181),
(2279, 'Aguadilla', 181),
(2280, 'Aguas Buenas', 181),
(2281, 'Aibonito', 181),
(2282, 'Anasco', 181),
(2283, 'Arecibo', 181),
(2284, 'Arroyo', 181),
(2285, 'Barceloneta', 181),
(2286, 'Barranquitas', 181),
(2287, 'Bayamon', 181),
(2288, 'Cabo Rojo', 181),
(2289, 'Caguas', 181),
(2290, 'Camuy', 181),
(2291, 'Canovanas', 181),
(2292, 'Carolina', 181),
(2293, 'Catano', 181),
(2294, 'Cayey', 181),
(2295, 'Ceiba', 181),
(2296, 'Ciales', 181),
(2297, 'Cidra', 181),
(2298, 'Coamo', 181),
(2299, 'Comerio', 181),
(2300, 'Corozal', 181),
(2301, 'Culebra', 181),
(2302, 'Dorado', 181),
(2303, 'Fajardo', 181),
(2304, 'Florida', 181),
(2305, 'Guanica', 181),
(2306, 'Guayama', 181),
(2307, 'Guayanilla', 181),
(2308, 'Guaynabo', 181),
(2309, 'Gurabo', 181),
(2310, 'Hatillo', 181),
(2311, 'Hormigueros', 181),
(2312, 'Humacao', 181),
(2313, 'Isabela', 181),
(2314, 'Jayuya', 181),
(2315, 'Juana Diaz', 181),
(2316, 'Juncos', 181),
(2317, 'Lajas', 181),
(2318, 'Lares', 181),
(2319, 'Las Marias', 181),
(2320, 'Las Piedras', 181),
(2321, 'Loiza', 181),
(2322, 'Luquillo', 181),
(2323, 'Manati', 181),
(2324, 'Maricao', 181),
(2325, 'Maunabo', 181),
(2326, 'Mayaguez', 181),
(2327, 'Moca', 181),
(2328, 'Morovis', 181),
(2329, 'Naguabo', 181),
(2330, 'Naranjito', 181),
(2331, 'Orocovis', 181),
(2332, 'Patillas', 181),
(2333, 'Penuelas', 181),
(2334, 'Ponce', 181),
(2335, 'Quebradillas', 181),
(2336, 'Rincon', 181),
(2337, 'Rio Grande', 181),
(2338, 'Sabana Grande', 181),
(2339, 'Salinas', 181),
(2340, 'San German', 181),
(2341, 'San Juan (capital)', 181),
(2342, 'San Lorenzo', 181),
(2343, 'San Sebastian', 181),
(2344, 'Santa Isabel', 181),
(2345, 'Toa Alta', 181),
(2346, 'Toa Baja', 181),
(2347, 'Trujillo Alto', 181),
(2348, 'Utuado', 181),
(2349, 'Vega Alta', 181),
(2350, 'Vega Baja', 181),
(2351, 'Vieques', 181),
(2352, 'Villalba', 181),
(2353, 'Yabucoa', 181),
(2354, 'Yauco', 181),
(2355, 'Ad Dawhah', 182),
(2356, 'Al Ghuwariyah', 182),
(2357, 'Al Jumaliyah', 182),
(2358, 'Al Khawr', 182),
(2359, 'Al Wakrah', 182),
(2360, 'Ar Rayyan', 182),
(2361, 'Jariyan al Batnah', 182),
(2362, 'Ash Shamal', 182),
(2363, 'Umm Salal', 182),
(2364, 'Mesaieed', 182),
(2365, 'Alba', 183),
(2366, 'Arad', 183),
(2367, 'Arqes', 183),
(2368, 'Bacau', 183),
(2369, 'Bihor', 183),
(2370, 'Bistrita-Nasaud', 183),
(2371, 'Botosani', 183),
(2372, 'Brasov', 183),
(2373, 'Braila', 183),
(2374, 'Buzau', 183),
(2375, 'Severin', 183),
(2376, 'Calarasi', 183),
(2377, 'Cluj', 183),
(2378, 'Constanta', 183),
(2379, 'Covasna', 183),
(2380, 'Dambovita', 183),
(2381, 'Dolj', 183),
(2382, 'Galati', 183),
(2383, 'Giurgiu', 183),
(2384, 'Gorj', 183),
(2385, 'Harghita', 183),
(2386, 'Hunedoara', 183),
(2387, 'Ialomita', 183),
(2388, 'Iasi', 183),
(2389, 'Ilfov', 183),
(2390, 'Maramures', 183),
(2391, 'Mehedinti', 183),
(2392, 'Mures', 183),
(2393, 'Neamt', 183),
(2394, 'Olt', 183),
(2395, 'Prahova', 183),
(2396, 'Satu Mare', 183),
(2397, 'Salaj', 183),
(2398, 'Sibiu', 183),
(2399, 'Suceava', 183),
(2400, 'Teleorman', 183),
(2401, 'Timis', 183),
(2402, 'Tulcea', 183),
(2403, 'Vaslui', 183),
(2404, 'Vâlcea', 183),
(2405, 'Vrancea', 183),
(2406, 'Belgorod Oblast', 184),
(2407, 'Bryansk Oblast', 184),
(2408, 'Ivanovo Oblast', 184),
(2409, 'Kaluga Oblast', 184),
(2410, 'Kostroma Oblast', 184),
(2411, 'Kursk Oblast', 184),
(2412, 'Lipetsk Oblast', 184),
(2413, 'Moscow (federal city)', 184),
(2414, 'Moscow Oblast', 184),
(2415, 'Oryol Oblast', 184),
(2416, 'Ryazan Oblast', 184),
(2417, 'Smolensk Oblast', 184),
(2418, 'Tambov Oblast', 184),
(2419, 'Tver Oblast', 184),
(2420, 'Tula Oblast', 184),
(2421, 'Vladimir Oblast', 184),
(2422, 'Voronezh Oblast', 184),
(2423, 'Yaroslavl Oblast', 184),
(2424, 'Republic of Adygea', 184),
(2425, 'Astrakhan Oblast', 184),
(2426, 'Chechen Republic', 184),
(2427, 'Republic of Dagestan', 184),
(2428, 'Republic of Ingushetia', 184),
(2429, 'Kabardino-Balkar Republic', 184),
(2430, 'Republic of Kalmykia', 184),
(2431, 'Republic of Karachay-Cherkessia', 184),
(2432, 'Krasnodar Krai', 184),
(2433, 'North Ossetia-Alania Republic', 184),
(2434, 'Stavropol Krai', 184),
(2435, 'Rostov Oblast', 184),
(2436, 'Volgograd Oblast', 184),
(2437, 'Arkhangelsk Oblast', 184),
(2438, 'Nenets Autonomous Okrug', 184),
(2439, 'Kaliningrad Oblast', 184),
(2440, 'Leningrad Oblast', 184),
(2441, 'Republic of Karelia', 184),
(2442, 'Komi Republic', 184),
(2443, 'Murmansk Oblast', 184),
(2444, 'Novgorod Oblast', 184),
(2445, 'Pskov Oblast', 184),
(2446, 'St. Petersburg (federal city)', 184),
(2447, 'Vologda Oblast', 184),
(2448, 'Amur Oblast', 184),
(2449, 'Jewish Autonomous Oblast', 184),
(2450, 'Kamchatka Oblast', 184),
(2451, 'Koryak Autonomous Okrug', 184),
(2452, 'Khabarovsk Krai', 184),
(2453, 'Magadan Oblast', 184),
(2454, 'Chukotka Autonomous Okrug', 184),
(2455, 'Primorsky Krai', 184),
(2456, 'Sakha (Yakutia) Republic', 184),
(2457, 'Sakhalin Oblast', 184),
(2458, 'Altai Republic', 184),
(2459, 'Altai Krai', 184),
(2460, 'Buryat Republic', 184),
(2461, 'Chita Oblast', 184),
(2462, 'Agin-Buryat Autonomous Okrug', 184),
(2463, 'Irkutsk Oblast', 184),
(2464, 'Ust-Orda Buryat Autonomous Okrug', 184),
(2465, 'Republic of Khakassia', 184),
(2466, 'Kemerovo Oblast', 184),
(2467, 'Krasnoyarsk Krai', 184),
(2468, 'Taymyr Autonomous Okrug', 184),
(2469, 'Evenk Autonomous Okrug', 184),
(2470, 'Novosibirsk Oblast', 184),
(2471, 'Omsk Oblast', 184),
(2472, 'Tomsk Oblast', 184),
(2473, 'Tuva Republic', 184),
(2474, 'Kurgan Oblast', 184),
(2475, 'Sverdlovsk Oblast', 184),
(2476, 'Tyumen Oblast', 184),
(2477, 'Khanty-Mansi Autonomous Okrug', 184),
(2478, 'Yamalo-Nenets Autonomous Okrug', 184),
(2479, 'Chelyabinsk Oblast', 184),
(2480, 'Republic of Bashkortostan', 184),
(2481, 'Chuvash Republic', 184),
(2482, 'Kirov Oblast', 184),
(2483, 'Mari El Republic', 184),
(2484, 'Republic of Mordovia', 184),
(2485, 'Nizhny Novgorod Oblast', 184),
(2486, 'Orenburg Oblast', 184),
(2487, 'Penza Oblast', 184),
(2488, 'Perm Krai', 184),
(2489, 'Samara Oblast', 184),
(2490, 'Saratov Oblast', 184),
(2491, 'Republic of Tatarstan', 184),
(2492, 'Udmurt Republic', 184),
(2493, 'Ulyanovsk Oblast', 184),
(2494, 'North Province', 185),
(2495, 'East Province', 185),
(2496, 'South Province', 185),
(2497, 'West Province', 185),
(2498, 'Kigali Province', 185),
(2499, 'Saint Helena', 186),
(2500, 'Ascension', 186),
(2501, 'Tristan da Cunha', 186),
(2502, 'Saint George Basseterre', 187),
(2503, 'Saint George Gingerland', 187),
(2504, 'Saint James Windward', 187),
(2505, 'Saint John Figtree', 187),
(2506, 'Saint Thomas Lowland', 187),
(2507, 'Anse-la-Raye', 188),
(2508, 'Castries', 188),
(2509, 'Choiseul', 188),
(2510, 'Dauphin', 188),
(2511, 'Dennery', 188),
(2512, 'Gros Islet', 188),
(2513, 'Laborie', 188),
(2514, 'Micoud', 188),
(2515, 'Praslin', 188),
(2516, 'Soufriere', 188),
(2517, 'Vieux Fort', 188),
(2518, 'Miquelon-Langlade', 189),
(2519, 'Saint-Pierre', 189),
(2520, 'Charlotte', 190),
(2521, 'Grenadines', 190),
(2522, 'Saint Andrew', 190),
(2523, 'Saint David', 190),
(2524, 'Saint George', 190),
(2525, 'Saint Patrick', 190),
(2526, 'A''ana', 191),
(2527, 'Aiga-i-le-Tai', 191),
(2528, 'Atua', 191),
(2529, 'Fa''asaleleaga', 191),
(2530, 'Gaga''emauga', 191),
(2531, 'Gaga''ifomauga', 191),
(2532, 'Palauli', 191),
(2533, 'Satupa''itea', 191),
(2534, 'Tuamasaga', 191),
(2535, 'Va''a-o-Fonoti', 191),
(2536, 'Vaisigano', 191),
(2537, 'Acquaviva', 192),
(2538, 'Borgo Maggiore', 192),
(2539, 'Chiesanuova', 192),
(2540, 'Domagnano', 192),
(2541, 'Faetano', 192),
(2542, 'Fiorentino', 192),
(2543, 'Montegiardino', 192),
(2544, 'Serravalle', 192),
(2545, 'Sao Tome and Principe', 193),
(2546, 'Al Bahah', 194),
(2547, 'Al Hudud ash Shamaliyah', 194),
(2548, 'Al Jawf', 194),
(2549, 'Al Madinah', 194),
(2550, 'Al Gassim', 194),
(2551, 'Ar Riyad', 194),
(2552, 'Ash Sharqiyah', 194),
(2553, 'Asir', 194),
(2554, 'Ha''il', 194),
(2555, 'Jizan', 194),
(2556, 'Makkah', 194),
(2557, 'Najran', 194),
(2558, 'Tabuk', 194),
(2559, 'Dakar', 195),
(2560, 'Diourbel', 195),
(2561, 'Fatick', 195),
(2562, 'Kaolack', 195),
(2563, 'Kolda', 195),
(2564, 'Louga', 195),
(2565, 'Matam', 195),
(2566, 'Saint-Louis', 195),
(2567, 'Tambacounda', 195),
(2568, 'Thies', 195),
(2569, 'Ziguinchor', 195),
(2570, 'Vojvodina', 196),
(2571, 'Kosovo', 196),
(2572, 'Metohija', 196),
(2573, 'Anse aux Pins', 197),
(2574, 'Anse Boileau', 197),
(2575, 'Anse Etoile', 197),
(2576, 'Anse Royale', 197),
(2577, 'Au Cap', 197),
(2578, 'Baie Lazare', 197),
(2579, 'Baie Sainte Anne', 197),
(2580, 'Beau Vallon', 197),
(2581, 'Bel Air', 197),
(2582, 'Bel Ombre', 197),
(2583, 'Cascade', 197),
(2584, 'Glacis', 197),
(2585, 'Mahe', 197),
(2586, 'Praslin', 197),
(2587, 'La Digue', 197),
(2588, 'La Riviere Anglaise', 197),
(2589, 'Les Mamelles', 197),
(2590, 'Mont Buxton', 197),
(2591, 'Mont Fleuri', 197),
(2592, 'Plaisance', 197),
(2593, 'Pointe La Rue', 197),
(2594, 'Port Glaud', 197),
(2595, 'Roche Caiman', 197),
(2596, 'Saint Louis', 197),
(2597, 'Takamaka', 197),
(2598, 'Eastern Province', 198),
(2599, 'Northern Province', 198),
(2600, 'Southern Province', 198),
(2601, 'Western Area', 198),
(2602, 'Central Region, Singapore', 199),
(2603, 'East Region, Singapore', 199),
(2604, 'North Region, Singapore', 199),
(2605, 'North-East Region, Singapore', 199),
(2606, 'West Region, Singapore', 199),
(2607, 'Bratislava Region', 200),
(2608, 'Trnava Region', 200),
(2609, 'Trencin Region', 200),
(2610, 'Nitra Region', 200),
(2611, 'Banska Bystrica Region', 200),
(2612, 'Prešov Region', 200),
(2613, 'Košice Region', 200),
(2614, 'Upper Carniola', 201),
(2615, 'Styria', 201),
(2616, 'Prekmurje', 201),
(2617, 'Carinthia', 201),
(2618, 'Inner Carniola', 201),
(2619, 'Lower Carniola', 201),
(2620, 'Goriška', 201),
(2621, 'Slovenian Istria', 201),
(2622, 'Central', 202),
(2623, 'Choiseul', 202),
(2624, 'Guadalcanal', 202),
(2625, 'Honiara, Town', 202),
(2626, 'Isabel', 202),
(2627, 'Makira-Ulawa', 202),
(2628, 'Malaita', 202),
(2629, 'Rennell and Bellona', 202),
(2630, 'Temotu', 202),
(2631, 'Western', 202),
(2632, 'Awdal', 203),
(2633, 'Bakool', 203),
(2634, 'Banaadir', 203),
(2635, 'Bari', 203),
(2636, 'Bay', 203),
(2637, 'Galguduud', 203),
(2638, 'Gedo', 203),
(2639, 'Hiiraan', 203),
(2640, 'Jubbada Dhexe', 203),
(2641, 'Awdal', 204),
(2642, 'Saaxil', 204),
(2643, 'Sanaag', 204),
(2644, 'Sool', 204),
(2645, 'Togdheer', 204),
(2646, 'Woqooyi Galbeed', 204),
(2647, 'Gauteng', 205),
(2648, 'KwaZulu-Natal', 205),
(2649, 'Mpumalanga', 205),
(2650, 'Limpopo', 205),
(2651, 'Northern Cape', 205),
(2652, 'North West', 205),
(2653, 'Western Cape', 205),
(2654, 'South Korea', 206),
(2655, 'Alava/Araba', 207),
(2656, 'Albacete', 207),
(2657, 'Alicante/Alacant', 207),
(2658, 'Almeria', 207),
(2659, 'Asturias/Asturies', 207),
(2660, 'Avila', 207),
(2661, 'Badajoz', 207),
(2662, 'Barcelona', 207),
(2663, 'Burgos', 207),
(2664, 'Caceres', 207),
(2665, 'Cadiz', 207),
(2666, 'Cantabria', 207),
(2667, 'Castellon/Castello', 207),
(2668, 'Ciudad Real', 207),
(2669, 'Cordoba', 207),
(2670, 'A Coruna', 207),
(2671, 'Cuenca', 207),
(2672, 'Girona', 207),
(2673, 'Granada', 207),
(2674, 'Guadalajara', 207),
(2675, 'Guipuzcoa/Gipuzkoa', 207),
(2676, 'Huelva', 207),
(2677, 'Huesca', 207),
(2678, 'Illes Balears', 207),
(2679, 'Jaen', 207),
(2680, 'La Rioja', 207),
(2681, 'Leon', 207),
(2682, 'Lleida', 207),
(2683, 'Lugo', 207),
(2684, 'Madrid', 207),
(2685, 'Malaga', 207),
(2686, 'Murcia', 207),
(2687, 'Nafarroa/Navarra', 207),
(2688, 'Ourense', 207),
(2689, 'Palencia', 207),
(2690, 'Las Palmas', 207),
(2691, 'Pontevedra', 207),
(2692, 'Salamanca', 207),
(2693, 'Tenerife', 207),
(2694, 'Segovia', 207),
(2695, 'Sevilla', 207),
(2696, 'Soria', 207),
(2697, 'Tarragona', 207),
(2698, 'Teruel', 207),
(2699, 'Toledo', 207),
(2700, 'Valencia/Valencia', 207),
(2701, 'Valladolid', 207),
(2702, 'Vizcaya/Bizkaia', 207),
(2703, 'Zamora', 207),
(2704, 'Zaragoza', 207),
(2705, 'Andalusia', 208),
(2706, 'Aragon', 208),
(2707, 'Balearic Islands', 208),
(2708, 'Basque Country', 208),
(2709, 'Canary Islands', 208),
(2710, 'Cantabria', 208),
(2711, 'Castile-La Mancha', 208),
(2712, 'Castile and Leon', 208),
(2713, 'Catalonia', 208),
(2714, 'Extremadura', 208),
(2715, 'Galicia', 208),
(2716, 'La Rioja', 208),
(2717, 'Madrid', 208),
(2718, 'Murciav', 208),
(2719, 'Navarrev', 208),
(2720, 'Land of Valencia', 208),
(2721, 'Kandy', 209),
(2722, 'Anuradhapura', 209),
(2723, 'Trincomalee', 209),
(2724, 'Kurunegala', 209),
(2725, 'Southern', 209),
(2726, 'Badulla', 209),
(2727, 'Sabaragamuwa', 209),
(2728, 'Western', 209),
(2729, 'Al Jazirah', 210),
(2730, 'Blue Nile/Central', 210),
(2731, 'Sennar', 210),
(2732, 'White Nile', 210),
(2733, 'Darfur', 210),
(2734, 'North Darfur', 210),
(2735, 'South Darfur', 210),
(2736, 'West Darfur', 210),
(2737, 'Equatoria', 210),
(2738, 'Bahr al Ghazal', 210),
(2739, 'Lakes', 210),
(2740, 'North Bahr al Ghazal', 210),
(2741, 'West Bahr al Ghazal', 210),
(2742, 'Warab', 210),
(2743, 'East Equatoria', 210),
(2744, 'Central Equatoria', 210),
(2745, 'East Equatoria', 210),
(2746, 'West Equatoria', 210),
(2747, 'Kassala', 210),
(2748, 'Al Qadarif', 210),
(2749, 'Red Sea', 210),
(2750, 'Khartoum', 210),
(2751, 'Kurdufan', 210),
(2752, 'North Kurdufan', 210),
(2753, 'South Kurdufan', 210),
(2754, 'West Kurdufan', 210),
(2755, 'Northern', 210),
(2756, 'River Nile', 210),
(2757, 'Upper Nile', 210),
(2758, 'Jonglei', 210),
(2759, 'Unity', 210),
(2760, 'Upper Nile', 210),
(2761, 'Brokopondo', 211),
(2762, 'Commewijne', 211),
(2763, 'Coronie', 211),
(2764, 'Marowijne', 211),
(2765, 'Nickerie', 211),
(2766, 'Para', 211),
(2767, 'Paramaribo', 211),
(2768, 'Saramacca', 211),
(2769, 'Sipaliwini', 211),
(2770, 'Wanica', 211),
(2771, 'Brokopondo', 212),
(2772, 'Commewijne', 212),
(2773, 'Coronie', 212),
(2774, 'Marowijne', 212),
(2775, 'Nickerie', 212),
(2776, 'Para', 212),
(2777, 'Paramaribo', 212),
(2778, 'Saramacca', 212),
(2779, 'Sipaliwini', 212),
(2780, 'Wanica', 212),
(2781, 'Hhohho', 213),
(2782, 'Lubombo', 213),
(2783, 'Manzini', 213),
(2784, 'Shiselweni', 213),
(2785, 'Stockholm County', 214),
(2786, 'Västerbotten County', 214),
(2787, 'Norrbotten County', 214),
(2788, 'Uppsala County', 214),
(2789, 'Sodermanland County', 214),
(2790, 'Östergotland County', 214),
(2791, 'Jonkoping County', 214),
(2792, 'Kronoberg County', 214),
(2793, 'Kalmar County', 214),
(2794, 'Gotland County', 214),
(2795, 'Blekinge County', 214),
(2796, 'Skåne County', 214),
(2797, 'Halland County', 214),
(2798, 'Västra Gotaland County', 214),
(2799, 'Värmland County', 214),
(2800, 'Örebro County', 214),
(2801, 'Västmanland County', 214),
(2802, 'Dalarna County', 214),
(2803, 'Gävleborg County', 214),
(2804, 'Västernorrland County', 214),
(2805, 'Jämtland County', 214),
(2806, 'Aargau', 215),
(2807, 'Appenzell Innerrhoden', 215),
(2808, 'Appenzell Ausserrhoden', 215),
(2809, 'Basel-Stadt', 215),
(2810, 'Basel-Landschaft', 215),
(2811, 'Bern', 215),
(2812, 'Fribourg', 215),
(2813, 'Geneva', 215),
(2814, 'Glarus', 215),
(2815, 'Graubunden', 215),
(2816, 'Jura', 215),
(2817, 'Lucerne', 215),
(2818, 'Neuchâtel', 215),
(2819, 'Nidwalden', 215),
(2820, 'Obwalden', 215),
(2821, 'Schaffhausen', 215),
(2822, 'Schwyz', 215),
(2823, 'Solothurn', 215),
(2824, 'St. Gallen', 215),
(2825, 'Thurgau', 215),
(2826, 'Ticino', 215),
(2827, 'Uri', 215),
(2828, 'Valais', 215),
(2829, 'Vaud', 215),
(2830, 'Zug', 215),
(2831, 'Zurich', 215),
(2832, 'Damascus', 216),
(2833, 'Rif Dimashq', 216),
(2834, 'Quneitra', 216),
(2835, 'Dara', 216),
(2836, 'As Suwayda', 216),
(2837, 'Homs', 216),
(2838, 'Tartous', 216),
(2839, 'Latakia', 216),
(2840, 'Hama', 216),
(2841, 'Idlib', 216),
(2842, 'Aleppo', 216),
(2843, 'Ar Raqqah', 216),
(2844, 'Dayr az Zawr', 216),
(2845, 'Al Hasakah', 216),
(2846, 'Taiwan', 217),
(2847, 'Khujand', 218),
(2848, 'Dushanbe', 218),
(2849, 'Khatlon', 218),
(2850, 'Gorno-Badakhshan', 218),
(2851, 'Arusha', 219),
(2852, 'Dar es Salaam', 219),
(2853, 'Dodoma', 219),
(2854, 'Iringa', 219),
(2855, 'Kagera', 219),
(2856, 'Kigoma', 219),
(2857, 'Kilimanjaro', 219),
(2858, 'Lindi', 219),
(2859, 'Manyara', 219),
(2860, 'Mara', 219),
(2861, 'Mbeya', 219),
(2862, 'Morogoro', 219),
(2863, 'Mtwara', 219),
(2864, 'Mwanza', 219),
(2865, 'Wete', 219),
(2866, 'Mkoani', 219),
(2867, 'Kibaha', 219),
(2868, 'Sumbawanga', 219),
(2869, 'Ruvuma', 219),
(2870, 'Shinyanga', 219),
(2871, 'Singida', 219),
(2872, 'Tabora', 219),
(2873, 'Tanga', 219),
(2874, 'Koani', 219),
(2875, 'Mkokotoni', 219),
(2876, 'Zanzibar', 219),
(2877, 'Chiang Mai', 220),
(2878, 'Chiang Rai', 220),
(2879, 'Kamphaeng Phet', 220),
(2880, 'Lampang', 220),
(2881, 'Lamphun', 220),
(2882, 'Mae Hong Son', 220),
(2883, 'Nakhon Sawan', 220),
(2884, 'Phayao', 220),
(2885, 'Phetchabun', 220),
(2886, 'Phitsanulok', 220),
(2887, 'Phrae', 220),
(2888, 'Sukhothai', 220),
(2889, 'Tak', 220),
(2890, 'Uthai Thani', 220),
(2891, 'Uttaradit', 220),
(2892, 'Chanthaburi', 220),
(2893, 'Chon Buri', 220),
(2894, 'Prachin Buri', 220),
(2895, 'Rayong', 220),
(2896, 'Sa Kaeo', 220),
(2897, 'Trat', 220),
(2898, 'Ang Thong', 220),
(2899, 'Phra Nakhon Si Ayutthaya', 220),
(2900, 'Chachoengsao', 220),
(2901, 'Chai Nat', 220),
(2902, 'Kanchanaburi', 220),
(2903, 'Lop Buri', 220),
(2904, 'Nakhon Nayok', 220),
(2905, 'Nakhon Pathom', 220),
(2906, 'Nonthaburi', 220),
(2907, 'Pathum Thani', 220),
(2908, 'Phetchaburi', 220),
(2909, 'Prachuap Khiri Khan', 220),
(2910, 'Ratchaburi', 220),
(2911, 'Samut Prakan', 220),
(2912, 'Samut Sakhon', 220),
(2913, 'Samut Songkhram', 220),
(2914, 'Saraburi', 220),
(2915, 'Sing Buri', 220),
(2916, 'Suphan Buri', 220),
(2917, 'Chumphon', 220),
(2918, 'Krabi', 220),
(2919, 'Nakhon Si Thammara', 220),
(2920, 'Narathiwat', 220),
(2921, 'Phang Nga', 220),
(2922, 'Phatthalung', 220),
(2923, 'Phuke', 220),
(2924, 'Ranong', 220),
(2925, 'Lautem', 221),
(2926, 'Baucau', 221),
(2927, 'Viqueque', 221),
(2928, 'Manatuto', 221),
(2929, 'Dili', 221),
(2930, 'Aileu', 221),
(2931, 'Manufahi', 221),
(2932, 'Liquica', 221),
(2933, 'Ermera', 221),
(2934, 'Ainaro', 221),
(2935, 'Bobonaro', 221),
(2936, 'Cova-Lima', 221),
(2937, 'Oecussi-Ambeno', 221),
(2938, 'Centrale', 222),
(2939, 'Kara', 222),
(2940, 'Maritime', 222),
(2941, 'Plateaux', 222),
(2942, 'Savanes', 222),
(2943, 'Tokelau', 237),
(2944, 'Vavau', 224),
(2945, 'Haapai', 224),
(2946, 'Tongatapu', 224),
(2947, 'Transnistria', 225),
(2948, 'Trinidad and Tobago', 226),
(2949, 'Tristan da Cunha', 227),
(2950, 'Ariana', 228),
(2951, 'Beja', 228),
(2952, 'Ben Arous', 228),
(2953, 'Bizerte', 228),
(2954, 'Gabes', 228),
(2955, 'Gafsa', 228),
(2956, 'Jendouba', 228),
(2957, 'Kairouan', 228),
(2958, 'Kasserine', 228),
(2959, 'Kebili', 228),
(2960, 'Kef', 228),
(2961, 'Mahdia', 228),
(2962, 'Manouba', 228),
(2963, 'Medenine', 228),
(2964, 'Monastir', 228),
(2965, 'Nabeul', 228),
(2966, 'Sfax', 228),
(2967, 'Sidi Bou Said', 228),
(2968, 'Siliana', 228),
(2969, 'Sousse', 228),
(2970, 'Tataouine', 228),
(2971, 'Tozeur', 228),
(2972, 'Tunis', 228),
(2973, 'Zaghouan', 228),
(2974, 'Adana', 229),
(2975, 'Adiyaman', 229),
(2976, 'Afyonkarahisar', 229),
(2977, 'Aqri', 229),
(2978, 'Amasya', 229),
(2979, 'Ankara', 229),
(2980, 'Antalya', 229),
(2981, 'Artvin', 229),
(2982, 'Aydin', 229),
(2983, 'Balikesir', 229),
(2984, 'Bilecik', 229),
(2985, 'Bingol', 229),
(2986, 'Bitlis', 229),
(2987, 'Bolu', 229),
(2988, 'Burdur', 229),
(2989, 'Bursa', 229),
(2990, 'Çanakkale', 229),
(2991, 'Çankiri', 229),
(2992, 'Çorum', 229),
(2993, 'Denizli', 229),
(2994, 'Diyarbakir', 229),
(2995, 'Edirne', 229),
(2996, 'Elaziq', 229),
(2997, 'Erzincan', 229),
(2998, 'Erzurum', 229),
(2999, 'Eskisehir', 229),
(3000, 'Gaziantep', 229),
(3001, 'Giresun', 229),
(3002, 'Gumushane', 229),
(3003, 'Hakkari', 229),
(3004, 'Hatay', 229),
(3005, 'Isparta', 229),
(3006, 'Icel', 229),
(3007, 'Istanbul', 229),
(3008, 'Izmir', 229),
(3009, 'Kars', 229),
(3010, 'Kastamonu', 229),
(3011, 'Kayseri', 229),
(3012, 'Kirklareli', 229),
(3013, 'Kirsehir', 229),
(3014, 'Kocaeli', 229),
(3015, 'Konya', 229),
(3016, 'Kutahya', 229),
(3017, 'Malatya', 229),
(3018, 'Manisa', 229),
(3019, 'Kahramanmaras', 229),
(3020, 'Mardin', 229),
(3021, 'Muqla', 229),
(3022, 'Mus', 229),
(3023, 'Nevsehir', 229),
(3024, 'Niqde', 229),
(3025, 'Ordu', 229),
(3026, 'Rize', 229),
(3027, 'Sakarya', 229),
(3028, 'Samsun', 229),
(3029, 'Siirt', 229),
(3030, 'Sinop', 229),
(3031, 'Sivas', 229),
(3032, 'Tekirdag', 229),
(3033, 'Tokat', 229),
(3034, 'Trabzon', 229),
(3035, 'Tunceli', 229),
(3036, 'Sanliurfa', 229),
(3037, 'Usak', 229),
(3038, 'Van', 229),
(3039, 'Yozgat', 229),
(3040, 'Zonguldak', 229),
(3041, 'Aksaray', 229),
(3042, 'Bayburt', 229),
(3043, 'Karaman', 229),
(3044, 'Kirikkale', 229),
(3045, 'Batman', 229),
(3046, 'Sirnak', 229),
(3047, 'Bartin', 229),
(3048, 'Ardahan', 229),
(3049, 'Iqdir', 229),
(3050, 'Yalova', 229),
(3051, 'Karabuk', 229),
(3052, 'Kilis', 229),
(3053, 'Osmaniye', 229),
(3054, 'Duzce', 229),
(3055, 'Ashgabat', 230),
(3056, 'Ahal Province', 230),
(3057, 'Balkan Province', 230),
(3058, 'Dashhowuz Province', 230),
(3059, 'Lebap Province', 230),
(3060, 'Mary Province', 230),
(3061, 'Turks and Caicos Islands', 231),
(3062, 'Nanumanga', 232),
(3063, 'Niulakita', 232),
(3064, 'Niutao', 232),
(3065, 'Abim', 233),
(3066, 'Adjumani', 233),
(3067, 'Amolatar', 233),
(3068, 'Apac', 233),
(3069, 'Arua', 233),
(3070, 'Dokolo', 233),
(3071, 'Gulu', 233),
(3072, 'Kaabong', 233),
(3073, 'Kilak', 233),
(3074, 'Kitgum', 233),
(3075, 'Koboko', 233),
(3076, 'Kotido', 233),
(3077, 'Lira', 233),
(3078, 'Maracha', 233),
(3079, 'Moroto', 233),
(3080, 'Moyo', 233),
(3081, 'Nakapiripirit', 233),
(3082, 'Nebbi', 233),
(3083, 'Oyam', 233),
(3084, 'Pader', 233),
(3085, 'Yumbe', 233),
(3086, 'Amuria', 233),
(3087, 'Budaka', 233),
(3088, 'Bugiri', 233),
(3089, 'Bukwa', 233),
(3090, 'Busia', 233),
(3091, 'Busiki', 233),
(3092, 'Butaleja', 233),
(3093, 'Iganga', 233),
(3094, 'Jinja', 233),
(3095, 'Kaberamaido', 233),
(3096, 'Kaliro', 233),
(3097, 'Kamuli', 233),
(3098, 'Kapchorwa', 233),
(3099, 'Katakwi', 233),
(3100, 'Kumi', 233),
(3101, 'Manafwa', 233),
(3102, 'Mayuge', 233),
(3103, 'Mbale', 233),
(3104, 'Pallisa', 233),
(3105, 'Sironko', 233),
(3106, 'Soroti', 233),
(3107, 'Tororo', 233),
(3108, 'Kalangala', 233),
(3109, 'Kampala', 233),
(3110, 'Kayunga', 233),
(3111, 'Kiboga', 233),
(3112, 'Luwero', 233),
(3113, 'Masaka', 233),
(3114, 'Mityana', 233),
(3115, 'Mpigi', 233),
(3116, 'Mubende', 233),
(3117, 'Mukono', 233),
(3118, 'Nakaseke', 233),
(3119, 'Nakasongola', 233),
(3120, 'Rakai', 233),
(3121, 'Sembabule', 233),
(3122, 'Wakiso', 233),
(3123, 'Cherkasy', 234),
(3124, 'Chernihiv', 234),
(3125, 'Chernivtsi', 234),
(3126, 'Crimea', 234),
(3127, 'Dnipropetrovsk', 234),
(3128, 'Donetsk', 234),
(3129, 'Ivano-Frankivsk', 234),
(3130, 'Kharkiv', 234),
(3131, 'Kherson', 234),
(3132, 'Khmelnytskyi', 234),
(3133, 'Kirovohrad', 234),
(3134, 'Kiev Oblast', 234),
(3135, 'Luhansk', 234),
(3136, 'Lviv', 234),
(3137, 'Mykolaiv', 234),
(3138, 'Odessa', 234),
(3139, 'Poltava', 234),
(3140, 'Rivne', 234),
(3141, 'Sumy', 234),
(3142, 'Ternopil', 234),
(3143, 'Vinnytsia', 234),
(3144, 'Volyn', 234),
(3145, 'Zakarpattia', 234),
(3146, 'Zaporizhzhia', 234),
(3147, 'Zhytomyr', 234),
(3148, 'United Arab Emirates', 235),
(3149, 'England', 236),
(3150, 'Scotland', 236),
(3151, 'Wales', 236),
(3152, 'Northern Ireland', 236),
(3153, 'Alabama', 223),
(3154, 'Alaska', 223),
(3155, 'Arizona', 223),
(3156, 'Arkansas', 223),
(3157, 'California', 223),
(3158, 'Colorado', 223),
(3159, 'Connecticut', 223),
(3160, 'Delaware', 223),
(3161, 'Florida', 223),
(3162, 'Georgia', 223),
(3163, 'Hawaii', 223),
(3164, 'Idaho', 223),
(3165, 'Illinois', 223),
(3166, 'Indiana', 223),
(3167, 'Iowa', 223),
(3168, 'Kansas', 223),
(3169, 'Kentucky', 223),
(3170, 'Louisiana', 223),
(3171, 'Maine', 223),
(3172, 'Maryland', 223),
(3173, 'Massachusetts', 223),
(3174, 'Michigan', 223),
(3175, 'Minnesota', 223),
(3176, 'Mississippi', 223),
(3177, 'Missouri', 223),
(3178, 'Montana', 223),
(3179, 'Nebraska', 223),
(3180, 'Nevada', 223),
(3181, 'New Hampshire', 223),
(3182, 'New Jersey', 223),
(3183, 'New Mexico', 223),
(3184, 'New York', 223),
(3185, 'North Carolina', 223),
(3186, 'North Dakota', 223),
(3187, 'Ohio', 223),
(3188, 'Oklahoma', 223),
(3189, 'Oregon', 223),
(3190, 'Pennsylvania', 223),
(3191, 'Rhode Island', 223),
(3192, 'South Carolina', 223),
(3193, 'South Dakota', 223),
(3194, 'Tennessee', 223),
(3195, 'Texas', 223),
(3196, 'Utah', 223),
(3197, 'Vermont', 223),
(3198, 'Virginia', 223),
(3199, 'Washington', 223),
(3200, 'West Virginia', 223),
(3201, 'Wisconsin', 223),
(3202, 'Wyoming', 223),
(3203, 'Artigas', 238),
(3204, 'Canelones', 238),
(3205, 'Cerro Largo', 238),
(3206, 'Colonia', 238),
(3207, 'Durazno', 238),
(3208, 'Flores', 238),
(3209, 'Florida', 238),
(3210, 'Lavalleja', 238),
(3211, 'Maldonado', 238),
(3212, 'Montevideo', 238),
(3213, 'Paysandu', 238),
(3214, 'Rio Negro', 238),
(3215, 'Rivera', 238),
(3216, 'Rocha', 238),
(3217, 'Salto', 238),
(3218, 'San Jose', 238),
(3219, 'Soriano', 238),
(3220, 'Tacuarembo', 238),
(3221, 'Treinta y Tres', 238),
(3222, 'Andijon Viloyati', 239),
(3223, 'Buxoro Viloyati', 239),
(3224, 'Farg''ona Viloyati', 239),
(3225, 'Jizzax Viloyati', 239),
(3226, 'Xorazm Viloyati', 239),
(3227, 'Namangan Viloyati', 239),
(3228, 'Navoiy Viloyati', 239),
(3229, 'Qashqadaryo Viloyati', 239),
(3230, 'Qaraqalpaqstan Respublikasi', 239),
(3231, 'Samarqand Viloyati', 239),
(3232, 'Sirdaryo Viloyati', 239),
(3233, 'Surxondaryo Viloyati', 239),
(3234, 'Toshkent Viloyati', 239),
(3235, 'Toshkent Shahri', 239),
(3236, 'Malampa', 240),
(3237, 'Penama', 240),
(3238, 'Sanma', 240),
(3239, 'Shefa', 240),
(3240, 'Tafea', 240),
(3241, 'Torba', 240),
(3242, 'Vatican City', 241),
(3243, 'Amazonas', 242),
(3244, 'Barcelona', 242),
(3245, 'San Fernando de Apure', 242),
(3246, 'Maracay', 242),
(3247, 'Barinas', 242),
(3248, 'Ciudad Bolivar', 242),
(3249, 'Valencia', 242),
(3250, 'San Carlos', 242),
(3251, 'Tucupita', 242),
(3252, 'Coro', 242),
(3253, 'San Juan De Los Morros', 242),
(3254, 'Barquisimeto', 242),
(3255, '1 Merida', 242),
(3256, 'Los Teque', 242),
(3257, 'Maturin', 242),
(3258, 'La Asuncion', 242),
(3259, 'Guanare', 242),
(3260, 'Cumana', 242),
(3261, 'San Cristobal', 242),
(3262, 'Trujillo', 242),
(3263, 'San Felipe', 242),
(3264, 'La Guaira', 242),
(3265, 'Maracaibo', 242),
(3266, 'An Giang', 243),
(3267, 'Bac Giang', 243),
(3268, 'Bac Kan', 243),
(3269, 'Bac Lieu', 243),
(3270, 'Bac Ninh', 243),
(3271, 'Ba Ria-Vung Tau', 243),
(3272, 'Ben Tre', 243),
(3273, 'Binh Dinh', 243),
(3274, 'Binh Duong', 243),
(3275, 'Binh Phuoc', 243),
(3276, 'Binh Thuan', 243),
(3277, 'Ca Mau', 243),
(3278, 'Can Tho', 243),
(3279, 'Cao Bang', 243),
(3280, 'Dak Lak', 243),
(3281, 'Dak Nong', 243),
(3282, 'Da Nang', 243),
(3283, 'Dien Bien', 243),
(3284, 'Dong Nai', 243),
(3285, 'Dong Thap', 243),
(3286, 'Gia Lai', 243),
(3287, 'Ha Giang', 243),
(3288, 'Hai Duong', 243),
(3289, 'Hai Phong', 243),
(3290, 'Ha Nam', 243),
(3291, 'Ha Noi', 243),
(3292, 'Ha Tay', 243),
(3293, 'Ha Tinh', 243),
(3294, 'Hoa Binh', 243),
(3295, 'Ho Chi Minh', 243),
(3296, 'Hau Giang', 243),
(3297, 'Hung Yen', 243),
(3298, 'Khanh Hoa', 243),
(3299, 'Kien Giang', 243),
(3300, 'Kon Tum', 243),
(3301, 'Lai Chau', 243),
(3302, 'Lam Dong', 243),
(3303, 'Lang Son', 243),
(3304, 'Lao Cai', 243),
(3305, 'Long An', 243),
(3306, 'Nam Dinh', 243),
(3307, 'Nghe An', 243),
(3308, 'Ninh Binh', 243),
(3309, 'Ninh Thuan', 243),
(3310, 'Phu Tho', 243),
(3311, 'Phu Yen', 243),
(3312, 'Quang Binh', 243),
(3313, 'Quang Nam', 243),
(3314, 'Quang Ngai', 243),
(3315, 'Quang Ninh', 243),
(3316, 'Quang Tri', 243),
(3317, 'Soc Trang', 243),
(3318, 'Son La', 243),
(3319, 'Tay Ninh', 243),
(3320, 'Thai Binh', 243),
(3321, 'Thai Nguyen', 243),
(3322, 'Thanh Hoa', 243),
(3323, 'Thua Thien-Hue', 243),
(3324, 'Tien Giang', 243),
(3325, 'Tra Vinh', 243),
(3326, 'Tuyen Quang', 243),
(3327, 'Vinh Long', 243),
(3328, 'Vinh Phuc', 243),
(3329, 'Yen Bai', 243),
(3330, 'Anegada', 244),
(3331, 'Jost Van Dyke', 244),
(3332, 'Tortola', 244),
(3333, 'Virgin Gorda', 244),
(3334, 'St. Croix', 245),
(3335, 'St. John', 245),
(3336, 'St. Thomas', 245),
(3337, 'Wallis and Futuna', 246),
(3338, 'Morocco', 247),
(3339, 'Western Sahara', 247),
(3340, 'Ta`izz', 248),
(3341, 'Ta''iz', 248),
(3342, 'Al Bayda''', 248),
(3343, 'Al Dali''', 248),
(3344, 'Kabwe', 249),
(3345, 'Ndola', 249),
(3346, 'Chipata', 249),
(3347, 'Mansa', 249),
(3348, 'Lusaka', 249),
(3349, 'Kasama', 249),
(3350, 'Solwezi', 249),
(3351, 'Livingstone', 249),
(3352, 'Mongu', 249),
(3353, 'Bulawayo', 250),
(3354, 'Harare', 250),
(3355, 'Manicaland', 250),
(3356, 'Mashonaland Central', 250),
(3357, 'Mashonaland East', 250),
(3358, 'Mashonaland West', 250),
(3359, 'Masvingo', 250),
(3360, 'Matabeleland North', 250),
(3361, 'Matabeleland South', 250),
(3362, 'Midlands', 250);

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

--
-- Table structure for table `tbl_subcategory`
--

CREATE TABLE IF NOT EXISTS `tbl_subcategory` (
  `SubCategoryID` int(11) NOT NULL auto_increment,
  `SectionID` int(11) NOT NULL,
  `CategoryID` int(11) NOT NULL,
  `SubCategoryName` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `HeaderImage` varchar(255) NOT NULL,
  `SubCategoryPDF` varchar(255) NOT NULL,
  `Status` enum('Active','InActive') NOT NULL,
  PRIMARY KEY  (`SubCategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_subcategory`
--

