728x90 AdSpace

Saturday, 28 December 2013

SQL Query for All State list for 237 Countries

This tutorial contains all the state list for 237 countries.Refer  Country List tutorial for country list  SQL query.
Create State table
CREATE TABLE `state` (
`STATE_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`STATE_NAME` varchar(75) NOT NULL,
`COUNTRY_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`STATE_ID`),
KEY `FK_state_COUNTRY_ID` (`COUNTRY_ID`),
CONSTRAINT `FK_state_COUNTRY_ID` FOREIGN KEY (`COUNTRY_ID`) REFERENCES `country` (`COUNTRY_ID`)
);

SQL Query for State list of First 80 Countries

INSERT INTO `state` (`STATE_ID`,`STATE_NAME`,`COUNTRY_ID`) VALUES 
(1,'Californi',1),
(2,'Alaska',1),
(3,'Georgia',1),
(4,'Alabama',1),
(5,'Arkansas',1),
(6,'Arizona',1),
(7,'Colorado',1),
(8,'Connecticut',1),
(9,'District of Columbia',1),
(10,'Delaware',1),
(11,'Florida',1),
(12,'Hawaii',1),
(13,'Iowa',1),
(14,'Idaho',1),
(15,'Illinois',1),
(16,'Indiana',1),
(17,'Kansas',1),
(18,'Kentucky',1),
(19,'Louisiana',1),
(20,'Massachusetts',1),
(21,'Maryland',1),
(22,'Maine',1),
(23,'Michigan',1),
(24,'Minnesota',1),
(25,'Missouri',1),
(26,'Mississippi',1),
(27,'Montana',1),
(28,'North Carolina',1),
(29,'North Dakota',1),
(30,'Nebraska',1),
(31,'New Hampshire',1),
(32,'New Jersey',1),
(33,'New Mexico',1),
(34,'Nevada',1),
(35,'New York',1),
(36,'Ohio',1),
(37,'Oklahoma',1),
(38,'Oregon',1),
(39,'Pennsylvania',1),
(40,'Rhode Island',1),
(41,'South Carolina',1),
(42,'South Dakota',1),
(43,'Tennessee',1),
(44,'Texas',1),
(45,'Utah',1),
(46,'Virginia',1),
(47,'Vermont',1),
(48,'Washington',1),
(49,'Wisconsin',1),
(50,'West Virginia',1),
(51,'Wyoming',1),
(52,'Alberta',2),
(53,'British Columbia',2),
(54,'Manitoba',2),
(55,'New Brunswick',2),
(56,'Newfoundland and Labrador',2),
(57,'Northwest Territories',2),
(58,'Nova Scotia',2),
(59,'Nunavut',2),
(60,'Ontario',2),
(61,'Prince Edward Island',2),
(62,'Quebec',2),
(63,'Saskatchewan',2),
(64,'Yukon Territory',2),
(65,'Badakhshan',3),
(66,'Badghis',3),
(67,'Farah',3),
(68,'Faryab',3),
(69,'Herat',3),
(70,'Kabul',3),
(71,'Kunduz',3),
(72,'Uruzgan',3),
(73,'Paktia',3),
(74,'Khowst',3),
(75,'Nuristan',3),
(76,'Baghlan',3),
(77,'Balkh',3),
(78,'Bamyan',3),
(79,'Ghazni',3),
(80,'Ghowr',3),
(81,'Helmand',3),
(82,'Jowzjan',3),
(83,'Kandahar',3),
(84,' Kapisa',3),
(85,' Konar',3),
(86,' Laghman',3),
(87,' Lowgar',3),
(88,' Nangarhar',3),
(89,' Nimruz',3),
(90,' Paktika',3),
(91,' Parvan',3),
(92,' Samangan',3),
(93,' Sar-e Pol',3),
(94,' Takhar',3),
(95,'Vardak',3),
(96,'Zabul',3),
(97,'Beratit',4),
(98,'Dibres',4),
(99,'Durresit',4),
(100,'Elbasanit',4),
(101,'Fierit',4),
(102,'Gjirokastres',4),
(103,'Korces',4),
(104,'Kukesit',4),
(105,'Lezhes',4),
(106,'Shkodres',4),
(107,'Tiranes',4),
(108,'Vlores',4),
(109,'Adrar',5),
(110,'Alger',5),
(111,'Annaba',5),
(112,'El Bayadh',5),
(113,'El Oued',5),
(114,'El Tarf',5),
(115,'Illizi',5),
(116,'Oran',5),
(117,'Oum el Bouaghi',5),
(118,'Bejaia',5),
(119,'Biskra',5),
(120,'Blida',5),
(121,'Bordj Bou Arreridj',5),
(122,'Bouira',5),
(123,'Boumerdes',5),
(124,'Chlef',5),
(125,'Constantine',5),
(126,'Djelfa',5),
(127,'Ghardaïa',5),
(128,'Guelma',5),
(129,'Jijel',5),
(130,'Khenchela',5),
(131,'Laghouat',5),
(132,'Mascara',5),
(133,'Medea',5),
(134,'Mila',5),
(135,'Mostaganem',5),
(136,'MSila',5),
(137,'Naama',5),
(138,'Ouargla',5),
(139,'Relizane',5),
(140,'Saïda',5),
(141,'Setif',5),
(142,'Sidi Bel Abbes',5),
(143,'Skikda',5),
(144,'Souk Ahras',5),
(145,'Tamanghasset',5),
(146,'Tebessa',5),
(147,'Tiaret',5),
(148,'Tindouf',5),
(149,'Tipaza',5),
(150,'Tissemsilt',5),
(151,'Tizi Ouzou',5),
(152,'Tlemcen',5),
(153,'Eastern',6),
(154,'Manua',6),
(155,'Unorganized',6),
(156,'Western',6),
(157,'Andorra la Vella',7),
(158,'Canillo',7),
(159,'La Massana',7),
(160,'Sant Julia de Loria',7),
(161,'Encamp',7),
(162,'Escaldes-Engordany',7),
(163,'Ordino',7),
(164,'Huíla',8),
(165,'Lunda Norte',8),
(166,'Lunda Sul',8),
(167,'Benguela',8),
(168,'Cabinda',8),
(169,'Luanda',8),
(170,'Malanje',8),
(171,'Namibe',8),
(172,'Bengo',8),
(173,'Bie',8),
(174,'Cuando Cubango',8),
(175,'Cuanza Norte',8),
(176,'Cuanza Sul',8),
(177,'Cunene',8),
(178,'Huambo',8),
(179,'Huambo',8),
(180,'Moxico',8),
(181,'Uige',8),
(182,'Zaire',8),
(183,'Blowing Point',9),
(184,'East End',9),
(185,'Geroge Hill',9),
(186,'Island Harbour',9),
(187,'North Hill',9),
(188,'North Side',9),
(189,'Sandy Ground',9),
(190,'Sandy Hill',9),
(191,'South Hill',9),
(192,'Stoney Ground',9),
(193,'The Farrington',9),
(194,'The Quarter',9),
(195,'The Valley',9),
(196,'West End',9),
(197,'Argentina/UK Claim',10),
(198,'Australia Claim',10),
(199,'Chile Claim',10),
(200,'Chile/UK Claim',10),
(201,'Chile/UK/Argentina Claim',10),
(202,'France Claim',10),
(203,'New Zealand Claim',10),
(204,'Norway Claim',10),
(205,'Unclaimed',10),
(206,'United Kingdom Claim',10),
(207,'Barbuda',11),
(208,'Redonda',11),
(209,'Saint George',11),
(210,'Saint John',11),
(211,'Saint Mary',11),
(212,'Saint Paul',11),
(213,'Saint Peter',11),
(214,'Saint Philip',11),
(215,'Antartica e Islas del Atlantico Sur',12),
(216,'Buenos Aires',12),
(217,'Catamarca',12),
(218,'Chaco',12),
(219,'Chubut',12),
(220,'Ciudad de Buenos Aires',12),
(221,'Cordoba',12),
(222,'Corrientes',12),
(223,'Entre Rios',12),
(224,'Formosa',12),
(225,'Jujuy',12),
(226,'La Pampa',12),
(227,'La Rioja',12),
(228,'Mendoza',12),
(229,'Misiones',12),
(230,'Neuquen',12),
(231,'Rio Negro',12),
(232,'Salta',12),
(233,'San Juan',12),
(234,'San Luis',12),
(235,'Santa Cruz',12),
(236,'Santa Fe',12),
(237,'Santiago del Estero',12),
(238,'Tierra del Fuego',12),
(239,'Tucuman',12),
(240,'Aragatsotni',13),
(241,'Ararati',13),
(242,'Armaviri',13),
(243,'Gegharkuniki',13),
(244,'Kotayki',13),
(245,'Lorri',13),
(246,'Shiraki',13),
(247,'Syuniki',13),
(248,'Tavushi',13),
(249,'VayotsDzori',13),
(250,'Aruba',14),
(251,'Australian Capital Territory',15),
(252,'New South Wales',15),
(253,'Northern Territory',15),
(254,'Queensland',15),
(255,'South Australia',15),
(256,'Tasmania',15),
(257,'Victoria',15),
(258,'Western Australia',15),
(259,'Burgenland',16),
(260,'Karnten',16),
(261,'Niederoesterreich',16),
(262,'Oberoesterreich',16),
(263,'Salzburg',16),
(264,'Steiermark',16),
(265,'Tirol',16),
(266,'Vorarlberg',16),
(267,'Absheron',17),
(268,'Aghdam',17),
(269,'Aghdash',17),
(270,'Aghjabedi',17),
(271,'Aghstafa',17),
(272,'Aghsu',17),
(273,'Astara',17),
(274,'Babek',17),
(275,'Baku',17),
(276,'Balaken',17),
(277,'Barda',17),
(278,'Beilagan',17),
(279,'Bilasuvar',17),
(280,'Dashkesan',17),
(281,'Fizuli',17),
(282,'Gabala',17),
(283,'Gadabey',17),
(284,'Gakh',17),
(285,'Ganja',17),
(286,'Gazakh',17),
(287,'Geranboy',17),
(288,'Gobustan',17),
(289,'Goychay',17),
(290,'Goygol',17),
(291,'Guba',17),
(292,'Gubadly',17),
(293,'Gusar',17),
(294,'Hacuqabul',17),
(295,'Imishli',17),
(296,'Ismailly',17),
(297,'Jalilabad',17),
(298,'Jebrail',17),
(299,'Julfa',17),
(300,'Kangarli',17),
(301,'Kelbajar',17),
(302,'Khankendy',17),
(303,'Khojaly',17),
(304,'Khojavend',17),
(305,'Khyzy',17),
(306,'Kyurdamir',17),
(307,'Lachin',17),
(308,'Lenkaran',17),
(309,'Lerik',17),
(310,'Masally',17),
(311,'Mingechevir',17),
(312,'Naftalan',17),
(313,'Nakhchivan',17),
(314,'Neftchala',17),
(315,'Oghuz',17),
(316,'Ordubad',17),
(317,'Saatly',17),
(318,'Sabirabad',17),
(319,'Salyan',17),
(320,'Samuh',17),
(321,'Sedarak',17),
(322,'Shabran',17),
(323,'Shamakhy',17),
(324,'Shamkir',17),
(325,'Sheki',17),
(326,'Shirvan',17),
(327,'Shusha',17),
(328,'Siazan',17),
(329,'Sumgayit',17),
(330,'Teter',17),
(331,'Tovuz',17),
(332,'Ujar',17),
(333,'Yardymly',17),
(334,'Yevlakh',17),
(335,'Zagatala',17),
(336,'Zangilan',17),
(337,'Zerdab',17),
(338,'Abaco',18),
(339,'Acklins Island',18),
(340,'Andros',18),
(341,'Bimini Islands',18),
(342,'Cat Island',18),
(343,'Crooked Island',18),
(344,'Eleuthera',18),
(345,'Exuma',18),
(346,'Grand Bahama',18),
(347,'Harbour Island',18),
(348,'Inagua',18),
(349,'Long Island',18),
(350,'Mayaguana',18),
(351,'New Providence',18),
(352,'Ragged Islands',18),
(353,'San Salvador',18),
(354,'Al Hadd',19),
(355,'Al Manamah',19),
(356,'Al Mintaqah al Gharbiyah',19),
(357,'Al Mintaqah al Wusta',19),
(358,'Al Mintaqah ash Shamaliyah',19),
(359,'Ar Rifawa al Mintaqah al Janubiya',19),
(360,'Jidd Hafs',19),
(361,'Madinat Hamad',19),
(362,'Madinat `Isa',19),
(363,'Mintaqat Juzur Hawar',19),
(364,'Al Muharraq',19),
(365,'Sitrah',19),
(366,'Barisal',20),
(367,'Chittagong',20),
(368,'Dhaka',20),
(369,'Khulna',20),
(370,'Rajshahi',20),
(371,'Christ Church',21),
(372,'Saint Andrew',21),
(373,'Saint George',21),
(374,'Saint James',21),
(375,'Saint John',21),
(376,'Saint Joseph',21),
(377,'Saint Lucy',21),
(378,'Saint Michael',21),
(379,'Saint Peter',21),
(380,'Saint Philip',21),
(381,'Saint Thomas',21),
(382,'Brestskaya',22),
(383,'Homyel Skaya',22),
(384,'Hrodzyenskaya',22),
(385,'Mahilyowskaya',22),
(386,'Menskaya',22),
(387,'Vitsyebsksya',22),
(388,'Antwerpen',23),
(389,'East Flanders',23),
(390,'Flemish Brabant',23),
(391,'Hainaut',23),
(392,'Liege',23),
(393,'Limburg',23),
(394,'Luxembourg',23),
(395,'Namur',23),
(396,'West Flanders',23),
(397,'Belize',24),
(398,'Cayo',24),
(399,'Corozal',24),
(400,'Orange Walk',24),
(401,'Stann Creek',24),
(402,'Toledo',24),
(403,'Alibori',25),
(404,'Atacora',25),
(405,'Atlantique',25),
(406,'Borgou',25),
(407,'Collins',25),
(408,'Couffo',25),
(409,'Donga',25),
(410,'Littoral',25),
(411,'Mono',25),
(412,'Oueme',25),
(413,'Plateau',25),
(414,'Zou',25),
(415,'Devonshire',26),
(416,'Hamilton',26),
(417,'Hamilton Municipality',26),
(418,'Paget',26),
(419,'Pembroke',26),
(420,'Saint George Municipality',26),
(421,'Saint Georges',26),
(422,'Sandys',26),
(423,'Smiths',26),
(424,'Southampton',26),
(425,'Warwick',26),
(426,'Bumthang',27),
(427,'Chhukha',27),
(428,'Dagana',27),
(429,'Gasa',27),
(430,'Haa',27),
(431,'Lhuentse',27),
(432,'Mongar',27),
(433,'Paro',27),
(434,'Perma Gatshel',27),
(435,'Punakha',27),
(436,'Samdrup Jongkhar',27),
(437,'Samtse',27),
(438,'Sarpang',27),
(439,'Thimphu',27),
(440,'Trashi Gang',27),
(441,'Trashi Yangtse',27),
(442,'Trongsa',27),
(443,'Tsirang',27),
(444,'Wangdue Phodrang',27),
(445,'Zhemgang',27),
(446,'Beni',28),
(447,'Chuquisaca',28),
(448,'Cochabamba',28),
(449,'La Paz',28),
(450,'Oruro',28),
(451,'Pando',28),
(452,'Potosi',28),
(453,'Santa Cruz',28),
(454,'Tarija',28),
(455,'Brcko District',29),
(456,'Federation of Bosnia & Herzegovina',29),
(457,'Serbian Republic',29),
(458,'Central',30),
(459,'Ghanzi',30),
(460,'Kgalagadi',30),
(461,'Kgaleng',30),
(462,'Kweneng',30),
(463,'North-East',30),
(464,'North-West',30),
(465,'South-East',30),
(466,'Southern',30),
(467,'Bouvet Island',31),
(468,'Acre',32),
(469,'Alagoas',32),
(470,'Amapa',32),
(471,'Amazonas',32),
(472,'Bahia',32),
(473,'Ceara',32),
(474,'Distrito Federal',32),
(475,'Espirito Santo',32),
(476,'Goias',32),
(477,'Maranhao',32),
(478,'Mato Grosso',32),
(479,'Mato Grosso do Sul',32),
(480,'Minas Gerais',32),
(481,'Para',32),
(482,'Parana',32),
(483,'Pernambuco',32),
(484,'Piaui',32),
(485,'Rio de Janeiro',32),
(486,'Rio Grande do Norte',32),
(487,'Rio Grande do Sul',32),
(488,'Rondonia',32),
(489,'Roraima',32),
(490,'Santa Catarina',32),
(491,'Sao Paulo',32),
(492,'Sergipe',32),
(493,'Tocantins',32),
(494,'British Indian Ocean Territoy',33),
(495,'Belait',34),
(496,'Brunei and Muara',34),
(497,'Temburong',34),
(498,'Tutong',34),
(499,'Burgas',35),
(500,'Khaskovo',35),
(501,'Lovech',35),
(502,'Montana',35),
(503,'Plovdiv',35),
(504,'Ruse',35),
(505,'Sofiya',35),
(506,'Sofiya-Grad',35),
(507,'Varna',35),
(508,'Boucle du Mouhoun',36),
(509,'Cascades',36),
(510,'Centre',36),
(511,'Centre East',36),
(512,'Centre Nord',36),
(513,'Centre Ouest',36),
(514,'Centre Sud',36),
(515,'Est',36),
(516,'Hauts Bassins',36),
(517,'Nord',36),
(518,'Plateau Central',36),
(519,'Sahel',36),
(520,'Tsirang',36),
(521,'Sud-Ouest',36),
(522,'Bubanza',37),
(523,'Bujumbura Mairie',37),
(524,'Bujumbura Rural',37),
(525,'Bururi',37),
(526,'Cankuzo',37),
(527,'Cibitoke',37),
(528,'Gitega',37),
(529,'Karuzi',37),
(530,'Kayanza',37),
(531,'Kirundo',37),
(532,'Makamba',37),
(533,'Muramvya',37),
(534,'Muyinga',37),
(535,'Mwaro',37),
(536,'Ngozi',37),
(537,'Rutana',37),
(538,'Ruyigi',37),
(539,'Banteay Meanchey',38),
(540,'Battambang',38),
(541,'Kampong Cham',38),
(542,'Kampong Chhnang',38),
(543,'Kampong Speu',38),
(544,'Kampong Thum',38),
(545,'Kampot',38),
(546,'Kandal',38),
(547,'Kep',38),
(548,'Koh Kong',38),
(549,'Kratie',38),
(550,'Mondolkiri',38),
(551,'Oddar Meanchey',38),
(552,'Pailin Province',38),
(553,'Phnom Penh',38),
(554,'Preah Nihear',38),
(555,'Preah Sihanouk Province',38),
(556,'Prey Veng',38),
(557,'Pursat',38),
(558,'Ratanakiri',38),
(559,'Siem Reap',38),
(560,'Stung Treng',38),
(561,'Svay Rieng',38),
(562,'Takeo',38),
(563,'Adamaoua',39),
(564,'Centre',39),
(565,'Est',39),
(566,'Extreme-Nord',39),
(567,'Littoral',39),
(568,'Nord',39),
(569,'Nord-Ouest',39),
(570,'Ouest',39),
(571,'Sud',39),
(572,'Sud-Ouest',39),
(573,'Boa Vista',40),
(574,'Brava',40),
(575,'Maio',40),
(576,'Mosteiros',40),
(577,'Paul',40),
(578,'Porto Novo',40),
(579,'Praia',40),
(580,'Ribeira Grande',40),
(581,'Sal',40),
(582,'Santa Catarina',40),
(583,'Santa Cruz',40),
(584,'Sao Domingos',40),
(585,'Sao Filipe',40),
(586,'Sao Miguel',40),
(587,'Sao Vicente',40),
(588,'Tarrafal',40),
(589,'Tarrafal de Sao Nicolau',40),
(590,'Bodden Town',41),
(591,'East End',41),
(592,'George Town',41),
(593,'North Side',41),
(594,'Sister Islands',41),
(595,'West Bay',41),
(596,'Bamingui-Bangoran',42),
(597,'Bangui',42),
(598,'Basse-Kotto',42),
(599,'Haut-Mbomou',42),
(600,'Haute-Koto',42),
(601,'Kemo',42),
(602,'Lobaye',42),
(603,'Mambere-Kadei',42),
(604,'Nana-Grebizi',42),
(605,'Nana-Mambere',42),
(606,'Ombella-MPoko',42),
(607,'Ouaka',42),
(608,'Ouham',42),
(609,'Ouham-Pende',42),
(610,'Sangha-Mbaere',42),
(611,'Vakaga',42),
(612,'Batha',43),
(613,'Borkou-Ennedi-Tibesti',43),
(614,'Chari-Baguirmi',43),
(615,'Guera',43),
(616,'Hadjer-Lamis',43),
(617,'Kanem',43),
(618,'Lac',43),
(619,'Logone Occidental',43),
(620,'Logone Oriental',43),
(621,'Mandoul',43),
(622,'Mayo-Kebbi Est',43),
(623,'Mayo-Kebbi Ouest',43),
(624,'Moyen-Chari',43),
(625,'Ouaddai',43),
(626,'Salamat',43),
(627,'Tandjile',43),
(628,'Ville de N Djamena',43),
(629,'Wadi Fira',43),
(630,'Aisen del General Carlos Ibanez del',44),
(631,'Antofagasta',44),
(632,'Araucania',44),
(633,'Arica and Parinacota',44),
(634,'Atacama',44),
(635,'Bio-Bio',44),
(636,'Coquimbo',44),
(637,'Libertador G.B. O Higgins',44),
(638,'Los Lagos',44),
(639,'Los Rios',44),
(640,'Magallanes y de la Antartica Chilen',44),
(641,'Maule',44),
(642,'Region Metropolitana de Santiago',44),
(643,'Tarapaca',44),
(644,'Valparaiso',44),
(645,'Anhui',45),
(646,'Beijing Shi',45),
(647,'Chongqing Shi',45),
(648,'Fujian',45),
(649,'Gansu',45),
(650,'Guangdong',45),
(651,'Guangxi Zhuangzu',45),
(652,'Guizhou',45),
(653,'Hainan',45),
(654,'Hebei',45),
(655,'Heilongjiang',45),
(656,'Henan',45),
(657,'Hubei',45),
(658,'Hunan',45),
(659,'Inner Mongolia',45),
(660,'Jiangsu',45),
(661,'Jiangxi',45),
(662,'Jilin',45),
(663,'Liaoning',45),
(664,'Ningxia',45),
(665,'Qinghai',45),
(666,'Shaangxi',45),
(667,'Shandong',45),
(668,'Shangxi',45),
(669,'Sichuan',45),
(670,'Tianjin',45),
(671,'Xinjiang Uygur',45),
(672,'Xizang (Tibet)',45),
(673,'Yunnan',45),
(674,'Zhejiang',45),
(675,'Christmas Island',46),
(676,'Cocos Keeling Islands',47),
(677,'Amazonas',48),
(678,'Antioquia',48),
(679,'Arauca',48),
(680,'Atlantico',48),
(681,'Bolivar',48),
(682,'Boyaca',48),
(683,'Caldas',48),
(684,'Caqueta',48),
(685,'Casanare',48),
(686,'Cauca',48),
(687,'Cesar',48),
(688,'Choco',48),
(689,'Cordoba',48),
(690,'Cundinamarca',48),
(691,'Distrito Capital',48),
(692,'Guainia',48),
(693,'Huila',48),
(694,'La Guajira',48),
(695,'Magdalena',48),
(696,'Meta',48),
(697,'Narino',48),
(698,'Norte de Santander',48),
(699,'Putumayo',48),
(700,'Quindio',48),
(701,'Risaralda',48),
(702,'Santander',48),
(703,'Sucre',48),
(704,'Tolima',48),
(705,'Valle del Cauca',48),
(706,'Vaupes',48),
(707,'Vichada',48),
(708,'Anjouan',49),
(709,'Grende Comore',49),
(710,'Moheli',49),
(711,'Kivu',50),
(712,'Bandundu',50),
(713,'Equator',50),
(714,'Bas-Congo',50),
(715,'Kasaï-Occidental',50),
(716,'Kasaï-Oriental',50),
(717,'Katanga',50),
(718,'Nord-Kivu',50),
(719,'Sud-Kivu',50),
(720,'Province Oriental',50),
(721,'Kinshasa',50),
(722,'Cook Islands',51),
(723,'Aajuela',52),
(724,'Cartago',52),
(725,'Guanacaste',52),
(726,'Heredia',52),
(727,'Limon',52),
(728,'Puntarenas',52),
(729,'San Jose',52),
(730,'Bjelovarsko-Bilogorska',53),
(731,'Brodsko-Posavska',53),
(732,'Dubrovacko-Neretvanska',53),
(733,'Grad Zagreb',53),
(734,'Istarska',53),
(735,'Karlovacka',53),
(736,'Koprivnicko-Krizevacka',53),
(737,'Krapinsko-Zagorska',53),
(738,'Licko-Senjska',53),
(739,'Medimurska',53),
(740,'Osjecko-Baranjska',53),
(741,'Pozesko-Slavonska',53),
(742,'Primorsko-Goranska',53),
(743,'Sibensko-Kninska',53),
(744,'Sisacko-Moslavacka',53),
(745,'Splitsko-Dalmatinska',53),
(746,'Varazdinska',53),
(747,'Viroviticko-Podravska',53),
(748,'Vukovarsko-Srijemska',53),
(749,'Zadarska',53),
(750,'Zagrebacka',53),
(751,'Artemisa',54),
(752,'Camaguey',54),
(753,'Ciego de Avila',54),
(754,'Cienfuegos',54),
(755,'Granma',54),
(756,'Guantanamo',54),
(757,'Holguin',54),
(758,'Isla de la Juventud',54),
(759,'La Habana',54),
(760,'Las Tunas',54),
(761,'Matanzas',54),
(762,'Pinar del Rio',54),
(763,'Sancti Spiritus',54),
(764,'Santiago de Cuba',54),
(765,'Villa Clara',54),
(766,'Famagusta',55),
(767,'Kyrenia',55),
(768,'Larnaca',55),
(769,'Limassol',55),
(770,'Nicosia',55),
(771,'Paphos',55),
(772,'Jihcesky',56),
(773,'Jihomoravsky',56),
(774,'Karlovarsky',56),
(775,'Kralovehradecky',56),
(776,'Liberecky',56),
(777,'Moravskoslizsky',56),
(778,'Olomoucky',56),
(779,'Pardubicky',56),
(780,'Plzensky',56),
(781,'Praha',56),
(782,'Stredocesky',56),
(783,'Ustecky',56),
(784,'Vysocina',56),
(785,'Zlinsky',56),
(786,'Capital',57),
(787,'Central Jutland',57),
(788,'North Jutland',57),
(789,'South Denmark',57),
(790,'Zealand',57),
(791,'Ali Sabieh',58),
(792,'Dikhil',58),
(793,'Djibouti',58),
(794,'Obock',58),
(795,'Tadjourah',58),
(796,'Saint Andrew',59),
(797,'Saint David',59),
(798,'Saint George',59),
(799,'Saint John',59),
(800,'Saint Joseph',59),
(801,'Saint Luke',59),
(802,'Saint Mark',59),
(803,'Saint Patrick',59),
(804,'Saint Paul',59),
(805,'Saint Peter',59),
(806,'Azua',60),
(807,'Baoruco',60),
(808,'Barahona',60),
(809,'Dajabon',60),
(810,'Distrito Nacional',60),
(811,'Duarte',60),
(812,'El Seibo',60),
(813,'Elias Pina',60),
(814,'Espaillat',60),
(815,'Hato Mayor',60),
(816,'Independencia',60),
(817,'La Altagracia',60),
(818,'La Romana',60),
(819,'La Vega',60),
(820,'Maria Trinidad Sanchez',60),
(821,'Monsenor Nouel',60),
(822,'Monte Cristi',60),
(823,'Monte Plata',60),
(824,'Pedernales',60),
(825,'Peravia',60),
(826,'Puerto Plata',60),
(827,'Salcedo',60),
(828,'Samana',60),
(829,'San Cristobal',60),
(830,'San Jose do Ocoa',60),
(831,'San Juan',60),
(832,'San Pedro de Macoris',60),
(833,'Sanchez Ramirez',60),
(834,'Santiago',60),
(835,'Santiago Rodriguez',60),
(836,'Santo Domingo',60),
(837,'Valverde',60),
(838,'Aileu',61),
(839,'Ainaro',61),
(840,'Baucau',61),
(841,'Bobonaro',61),
(842,'Cova Lima',61),
(843,'Dili',61),
(844,'Ermera',61),
(845,'Lautem',61),
(846,'Liquica',61),
(847,'Manatuto',61),
(848,'Manufahi',61),
(849,'Oecussi',61),
(850,'Viqueque',61),
(851,'Azuay',62),
(852,'Bolivar',62),
(853,'Canar',62),
(854,'Carchi',62),
(855,'Chimborazo',62),
(856,'Cotopaxi',62),
(857,'El Oro',62),
(858,'Esmeraldas',62),
(859,'Galapagos',62),
(860,'Guayas',62),
(861,'Imbabura',62),
(862,'Loja',62),
(863,'Los Rios',62),
(864,'Manabi',62),
(865,'Morona-Santiago',62),
(866,'Napo',62),
(867,'Orellana',62),
(868,'Pastaza',62),
(869,'Pichincha',62),
(870,'Santa Elena',62),
(871,'Santo Domingo de las Tsachilas',62),
(872,'Sucumbios',62),
(873,'Tungurahua',62),
(874,'Zamora-Chinchipe',62),
(875,'Ad-Daqahiyah',63),
(876,'Al-Bahr al-Ahmar',63),
(877,'Al-Buhayrah',63),
(878,'Al-Fayyum',63),
(879,'Al-Gharbiyah',63),
(880,'Al-Iskandariyah',63),
(881,'Al-Isma iliyah',63),
(882,'Al-Jizah',63),
(883,'Al-Minufiyah',63),
(884,'Al-Minya',63),
(885,'Al-Qahirah',63),
(886,'Al-Qalyubyah',63),
(887,'Al-Uqsur',63),
(888,'Al-Wadi al-Jadid',63),
(889,'As-Suways',63),
(890,'Ash-Sharqiyah',63),
(891,'Aswan',63),
(892,'Asyut',63),
(893,'Bani Suwayf',63),
(894,'Bur Sa id',63),
(895,'Dumyat',63),
(896,'Janub Sina',63),
(897,'Kafr ash-Shaykh',63),
(898,'Marsa Matruh',63),
(899,'Qina',63),
(900,'Shamal Sina',63),
(901,'Suhaj',63),
(902,'Ahuachapan',64),
(903,'Cabanas',64),
(904,'Chalatenango',64),
(905,'Cuscatlan',64),
(906,'La Libertad',64),
(907,'La Paz',64),
(908,'La Union',64),
(909,'Morazan',64),
(910,'San Miguel',64),
(911,'San Salvador',64),
(912,'San Vicente',64),
(913,'Santa Ana',64),
(914,'Sonsonate',64),
(915,'Usulutan',64),
(916,'Annobon',65),
(917,'Bioko Norte',65),
(918,'Bioko Sur',65),
(919,'Centro Sur',65),
(920,'Kie-Ntem',65),
(921,'Litoral',65),
(922,'Wele-Nzas',65),
(923,'Anseba',66),
(924,'Debub',66),
(925,'Debubawi Keyih Bahri',66),
(926,'Gash Barka',66),
(927,'Maekel',66),
(928,'Semenawi Keyih Bahri',66),
(929,'Harju',67),
(930,'Hiiu',67),
(931,'Ida-Viru',67),
(932,'Jarva',67),
(933,'Jogeva',67),
(934,'Laane',67),
(935,'Laane-Viru',67),
(936,'Parnu',67),
(937,'Polva',67),
(938,'Rapla',67),
(939,'Saare',67),
(940,'Tartu',67),
(941,'Valga',67),
(942,'Viljandi',67),
(943,'Voru',67),
(944,'Addis Ababa',68),
(945,'Afar',68),
(946,'Amhara',68),
(947,'Benshngul-Gumaz',68),
(948,'Dire Dawa',68),
(949,'Gambela Peoples',68),
(950,'Harari Peoples',68),
(951,'Oromia',68),
(952,'So Nations',68),
(953,'Somali',68),
(954,'Tigray',68),
(955,'Falkland Islands',69),
(956,'Norderoerne',70),
(957,'Ostero',70),
(958,'Sando',70),
(959,'Stromo',70),
(960,'Sudero',70),
(961,'Vago',70),
(962,'Central',71),
(963,'Eastern',71),
(964,'Northern',71),
(965,'Rotuna',71),
(966,'Western',71),
(967,'Central Finland',72),
(968,'Central Ostrobothnia',72),
(969,'Kainuu',72),
(970,'Kymenlaakso',72),
(971,'Lapland',72),
(972,'North Karelia',72),
(973,'North Ostrobothnia',72),
(974,'North Savo',72),
(975,'Ostrobothnia',72),
(976,'Paijat-Hame',72),
(977,'Satakunta',72),
(978,'South Karelia',72),
(979,'South Ostrobothnia',72),
(980,'South Savo',72),
(981,'Southwest Finland',72),
(982,'Alsace',73),
(983,'Aquitaine',73),
(984,'Auvergne',73),
(985,'Basse-Normandie',73),
(986,'Bourgogne',73),
(987,'Bretagne',73),
(988,'Centre',73),
(989,'Champagne-Ardenne',73),
(990,'Corse',73),
(991,'Franche-Comte',73),
(992,'Haute-Normandie',73),
(993,'Ile-de-France',73),
(994,'Languedoc-Roussillon',73),
(995,'Limousin',73),
(996,'Lorraine',73),
(997,'Midi-Pyrenees',73),
(998,'Nord-Pas-de-Calais',73),
(999,'Pays-de-la Loire',73),
(1000,'Picardie',73),
(1001,'Poitou-Charentes',73),
(1002,'Provence-Alpes-Cote d Azur',73),
(1003,'Rhooe-Alpes',73),
(1004,'Cayenna',74),
(1005,'Saint-Laurent-du-Maroni',74),
(1006,'Clipperton Island',75),
(1007,'eeward Islands',75),
(1008,'Marquesas Islands',75),
(1009,'Tuamotu and Gambier Islands',75),
(1010,'Tubuai Islands',75),
(1011,'Windward Islands',75),
(1012,'Adelie Land',76),
(1013,'Amsterdam & Saint Paul',76),
(1014,'Crozet Archipelago',76),
(1015,'Iles Eparses',76),
(1016,'Kerguelen',76),
(1017,'Estuaire',77),
(1018,'Haut-Ogooue',77),
(1019,'Moyen-Ogooue',77),
(1020,'Ngounie',77),
(1021,'Nyanga',77),
(1022,'Ogooue-Ivindo',77),
(1023,'Ogooue-Lolo',77),
(1024,'Ogooue-Maritime',77),
(1025,'Woleu-Ntem',77),
(1026,'Banjul',78),
(1027,'Central River',78),
(1028,'Lower River',78),
(1029,'North Bank',78),
(1030,'Upper River',78),
(1031,'West Coast',78),
(1032,'Abkhazia',79),
(1033,'Ajaria',79),
(1034,'Guria',79),
(1035,'Imereti',79),
(1036,'Kakheti',79),
(1037,'Kvemo Kartli',79),
(1038,'Mtskheta-Mhaneti',79),
(1039,'Rach-Lochkhumi-Kvemo Svaneti',79),
(1040,'Samegrelo-Zemo Svaneti',79),
(1041,'Samtskhe-Javakheti',79),
(1042,'Shida Kartli',79),
(1043,'Tbilisi',79),
(1044,'Baden-Wurttemberg',80),
(1045,'Bavaria',80),
(1046,'Berlin',80),
(1047,'Brandenburg',80),
(1048,'Bremen',80),
(1049,'Hamburg',80),
(1050,'Hessen',80),
(1051,'Mecklenburg-Vorpommern',80),
(1052,'Niedersachsen',80),
(1053,'Nordrhein-Westfalen',80),
(1054,'Rheinland-Pfalz',80),
(1055,'Saarland',80),
(1056,'Sachsen',80),
(1057,'Sachsen-Anhalt',80),
(1058,'Schleswig-Holstein',80),
(1059,'Thuringen',80);

SQL Query for State list of 81 to 160 Countries

INSERT INTO `state` (`STATE_ID`,`STATE_NAME`,`COUNTRY_ID`) VALUES 
(1060,'Ashanti',81),
(1061,'Brong-Ahafo',81),
(1062,'Central',81),
(1063,'Eastern',81),
(1064,'Greater Accra',81),
(1065,'Northern',81),
(1066,'Upper East',81),
(1067,'Upper West',81),
(1068,'Volta',81),
(1069,'Western',81),
(1070,'Gibraltar',82),
(1071,'Attiki',83),
(1072,'Central Greece',83),
(1073,'Crete',83),
(1074,'Epirus',83),
(1075,'Ionia Islands',83),
(1076,'Macedonia Central',83),
(1077,'Macedonia East and Thrace',83),
(1078,'Macedonia West',83),
(1079,'Peloponnesus',83),
(1080,'Thessalia',83),
(1081,'West Greece',83),
(1082,'Aegean Islands',83),
(1083,'Kujalleq',84),
(1084,'Qaasuitsup',84),
(1085,'Qeqqata',84),
(1086,'Sermersooq',84),
(1087,'Unorganized',84),
(1088,'Carriacou',85),
(1089,'Saint Andrew',85),
(1090,'Saint David',85),
(1091,'Saint George',85),
(1092,'Saint John',85),
(1093,'Saint Mark',85),
(1094,'Saint Patrick',85),
(1095,'Basse-Terre',86),
(1096,'Pointe-A-Pitre',86),
(1097,'Agana Heights',87),
(1098,'Agat',87),
(1099,'Asan',87),
(1100,'Barrigada',87),
(1101,'Chalan-Pago-Ordot',87),
(1102,'Dededo',87),
(1103,'Hagatna',87),
(1104,'Inarajan',87),
(1105,'Mangilao',87),
(1106,'Merizo',87),
(1107,'Mongmong-Toto-Maite',87),
(1108,'Piti',87),
(1109,'Santa Rita',87),
(1110,'Sinajana',87),
(1111,'Talofofo',87),
(1112,'Tamuning',87),
(1113,'Umatac',87),
(1114,'Yigo',87),
(1115,'Yona',87),
(1116,'Alta Verapaz',88),
(1117,'Baja Verapaz',88),
(1118,'Chimaltenango',88),
(1119,'Chiquimula',88),
(1120,'El Progreso',88),
(1121,'Escuintla',88),
(1122,'Guatemala',88),
(1123,'Huehuetenango',88),
(1124,'Izabel',88),
(1125,'Jalapa',88),
(1126,'Jutiapa',88),
(1127,'Peten',88),
(1128,'Quetzaltenango',88),
(1129,'Quiche',88),
(1130,'Retalhuleu',88),
(1131,'Sacatepequez',88),
(1132,'San Marcos',88),
(1133,'Santa Rosa',88),
(1134,'Solola',88),
(1135,'Suchitepequez',88),
(1136,'Totonicapan',88),
(1137,'Zacapa',88),
(1138,'Boke',89),
(1139,'Conakry',89),
(1140,'Faranah',89),
(1141,'Kankan',89),
(1142,'Kindia',89),
(1143,'Labe',89),
(1144,'Mamou',89),
(1145,'Nzere Kore',89),
(1146,'Bafata',90),
(1147,'Biombo',90),
(1148,'Bissau',90),
(1149,'Bolama',90),
(1150,'Cacheu',90),
(1151,'Gabu',90),
(1152,'Oio',90),
(1153,'Quinara',90),
(1154,'Tombali',90),
(1155,'Barima-Waini',91),
(1156,'Cuyuni-Mazaruni',91),
(1157,'Demerara-Mahaica',91),
(1158,'East Bergice-Corentyne',91),
(1159,'Essequibo Islands-West Demerara',91),
(1160,'Mahaica-Berbice',91),
(1161,'Pomeroon-Supenaam',91),
(1162,'Potaro-Siparuni',91),
(1163,'Upper Demerara-Berbice',91),
(1164,'Upper Takutu-Upper Essequibo',91),
(1165,'Centre',92),
(1166,'Grand Anse',92),
(1167,'L Artibonite',92),
(1168,'Nippes',92),
(1169,'Nord',92),
(1170,'Nord-Est',92),
(1171,'Nord-Ouest',92),
(1172,'Ouest',92),
(1173,'Sud',92),
(1174,'Sud-Est',92),
(1175,'Heard and Mcdonald Islands',93),
(1176,'Atlantida',94),
(1177,'Choluteca',94),
(1178,'Colon',94),
(1179,'Comayagua',94),
(1180,'Copan',94),
(1181,'Cortes',94),
(1182,'El Paraiso',94),
(1183,'Francisco Morazan',94),
(1184,'Gracias a Dios',94),
(1185,'Intibuca',94),
(1186,'Islas de la Bahia',94),
(1187,'La Paz',94),
(1188,'Lempira',94),
(1189,'Ocotepeque',94),
(1190,'Olancho',94),
(1191,'Santa Barbara',94),
(1192,'Valle',94),
(1193,'Yoro',94),
(1194,'Central & Western District',95),
(1195,'Eastern District',95),
(1196,'Islands District',95),
(1197,'Kowloon City District',95),
(1198,'Kwai Tsing District',95),
(1199,'Kwun Tong District',95),
(1200,'North District',95),
(1201,'Sai Kung District',95),
(1202,'Sha Tin District',95),
(1203,'Sham Shui Po District',95),
(1204,'Southern District',95),
(1205,'Tai Po District',95),
(1206,'Tsuen Wan District',95),
(1207,'Tuen Mun District',95),
(1208,'Wan Chai District',95),
(1209,'Wong Tai Sin District',95),
(1210,'Yau Tsim Mong District',95),
(1211,'Yuen Long District',95),
(1212,'Bacs-Kiskun Megye',96),
(1213,'Baranya Megye',96),
(1214,'Bekes Megye',96),
(1215,'Borsod-Abauj-Zemplen Megye',96),
(1216,'Budapest Fovaros',96),
(1217,'Csongrad Megye',96),
(1218,'Fejer Megye',96),
(1219,'Gyor-Moson-Sopron Megye',96),
(1220,'Hajdu-Bihar Megye',96),
(1221,'Heves Megye',96),
(1222,'Jasz-Nagykun-Szolnok Megye',96),
(1223,'Komarom-Esztergom Megye',96),
(1224,'Nograd Megye',96),
(1225,'Pest Megye',96),
(1226,'Somogy Megye',96),
(1227,'Szabolcs-Szatmar-Bereg Megye',96),
(1228,'Tolna Megye',96),
(1229,'Vas Megye',96),
(1230,'Veszprem Megye',96),
(1231,'Zala Megye',96),
(1232,'Arnessysla ',97),
(1233,'Austur-Bardhastrandarsysla ',97),
(1234,'Austur-Hunavatnssysla ',97),
(1235,'Austur-Skaftafellssysla ',97),
(1236,'Borgarfjardharsysla ',97),
(1237,'Dalasysla ',97),
(1238,'Eyjafjardharsysla ',97),
(1239,'Gullbringusysla ',97),
(1240,'Kjosarsysla ',97),
(1241,'Myrasysla ',97),
(1242,'Nordhur-Isafjardharsysla ',97),
(1243,'Nordhur-Mulasysla ',97),
(1244,'Nordhur-Thingeyjarsysla ',97),
(1245,'Rangarvallasysla ',97),
(1246,'Skagafjardharsysla ',97),
(1247,'Snaefellsnessysla- og Hnappadalssys ',97),
(1248,'Strandasysla ',97),
(1249,'Sudhur-Mulasysla ',97),
(1250,'Sudhur-Thingeijjar ',97),
(1251,'Vestur-Bardhastrandarsysla ',97),
(1252,'Vestur-Hunavatnssysla ',97),
(1253,'Vestur-Isafjardharsysla ',97),
(1254,'Vestur-Skaftafellssysla ',97),
(1255,'Andhra Pradesh ',98),
(1256,'Arunachal Pradesh ',98),
(1257,'Assam ',98),
(1258,'Bihar ',98),
(1259,'Chhattisgarh ',98),
(1260,'Goa ',98),
(1261,'Gujarat ',98),
(1262,'Haryana ',98),
(1263,'Himachal Pradesh ',98),
(1264,'Jammu and Kashmir ',98),
(1265,'Jharkhand ',98),
(1266,'Karnataka ',98),
(1267,'Kerala ',98),
(1268,'Madhya Pradesh ',98),
(1269,'Maharashtra ',98),
(1270,'Manipur ',98),
(1271,'Meghalaya ',98),
(1272,'Mizoram ',98),
(1273,'Nagaland ',98),
(1274,'Orissa ',98),
(1275,'Punjab ',98),
(1276,'Rajasthan ',98),
(1277,'Sikkim ',98),
(1278,'Tamil Nadu ',98),
(1279,'Tripura ',98),
(1280,'Uttar Preadesh ',98),
(1281,'Uttaranchal ',98),
(1282,'West Bengal ',98),
(1283,'Aceh ',99),
(1284,'Bali ',99),
(1285,'Bengkulu ',99),
(1286,'Jakarta Raya ',99),
(1287,'Jawa Barat ',99),
(1288,'Jawa Tengah ',99),
(1289,'Jawa Timur ',99),
(1290,'Kalimantan Barat ',99),
(1291,'Kalimantan Selatan ',99),
(1292,'Kalimantan Timur ',99),
(1293,'Lampung ',99),
(1294,'Papua ',99),
(1295,'Riau ',99),
(1296,'Sulawesi Utara ',99),
(1297,'Sumatera Barat ',99),
(1298,'Yogyakarta ',99),
(1299,'Ardebil ',100),
(1300,'Chahar Malall and Bakhtiari ',100),
(1301,'East Azarbaijan ',100),
(1302,'Esfahan ',100),
(1303,'Fars ',100),
(1304,'Hamadan ',100),
(1305,'Hormozgan ',100),
(1306,'Ilam ',100),
(1307,'Kerman ',100),
(1308,'Kermanshah ',100),
(1309,'Khuzestan ',100),
(1310,'Kohgiluyehand Buyer Ahmad ',100),
(1311,'Kordestan ',100),
(1312,'Lorestan ',100),
(1313,'Markazi ',100),
(1314,'Razavi Khorasan ',100),
(1315,'Semnan ',100),
(1316,'Sistanand Baluchestan ',100),
(1317,'Tehran ',100),
(1318,'West Azarbaijan ',100),
(1319,'Zanjan ',100),
(1320,'Anbar ',101),
(1321,'Arbil ',101),
(1322,'Babil ',101),
(1323,'Baghdad ',101),
(1324,'Basrah ',101),
(1325,'Dahuk ',101),
(1326,'Dhi Qar ',101),
(1327,'Diyala ',101),
(1328,'Karbala ',101),
(1329,'Maysan ',101),
(1330,'Muthanna ',101),
(1331,'Najaf ',101),
(1332,'Ninawa ',101),
(1333,'Qadisiyah ',101),
(1334,'Salah ad Din ',101),
(1335,'Sulaymaniyah ',101),
(1336,'Ta mim ',101),
(1337,'Wasit ',101),
(1338,'Carlow ',102),
(1339,'Cavan ',102),
(1340,'Clare ',102),
(1341,'Cork ',102),
(1342,'Donegal ',102),
(1343,'Dublin ',102),
(1344,'Galway ',102),
(1345,'Kerry ',102),
(1346,'Kildare ',102),
(1347,'Kilkenny ',102),
(1348,'Laois ',102),
(1349,'Leitrim ',102),
(1350,'Limerick ',102),
(1351,'Longford ',102),
(1352,'Louth ',102),
(1353,'Mayo ',102),
(1354,'Meath ',102),
(1355,'Monaghan ',102),
(1356,'Offaly ',102),
(1357,'Roscommon ',102),
(1358,'Sligo ',102),
(1359,'Tepperary ',102),
(1360,'Waterford ',102),
(1361,'Westmeath ',102),
(1362,'Wexford ',102),
(1363,'Wicklow ',102),
(1364,'HaDarom ',103),
(1365,'Haifa ',103),
(1366,'HaMerkaz ',103),
(1367,'HaZafon ',103),
(1368,'Jerusalem ',103),
(1369,'Tel Aviv ',103),
(1370,'Abruzzi ',104),
(1371,'Basilicata ',104),
(1372,'Calabria ',104),
(1373,'Campania ',104),
(1374,'Emilia-Romagna ',104),
(1375,'Friuli-Venezia Giulia ',104),
(1376,'Lazio ',104),
(1377,'Liguria ',104),
(1378,'Lombardia ',104),
(1379,'Marche ',104),
(1380,'Molise ',104),
(1381,'Piemonte ',104),
(1382,'Puglia ',104),
(1383,'Sardinia ',104),
(1384,'Sicilia ',104),
(1385,'Toscana ',104),
(1386,'Trentino-Alto Adige ',104),
(1387,'Umbria ',104),
(1388,'Valle d Aosta ',104),
(1389,'Veneto ',104),
(1390,'Agneby ',105),
(1391,'Marahoue ',105),
(1392,'Bandama ',105),
(1393,'Dix-Huit Montagnes ',105),
(1394,'Lacs ',105),
(1395,'Lagunes ',105),
(1396,'Savanes ',105),
(1397,'Bafing ',105),
(1398,'Bas-Sassandra ',105),
(1399,'Denguele ',105),
(1400,'Fromager ',105),
(1401,'Haut-Sassandra ',105),
(1402,'Moyen-Cavally ',105),
(1403,'Moyen-Comoe ',105),
(1404,'Nzi-Comoe ',105),
(1405,'Sud-Bandama ',105),
(1406,'Sud-Comoe ',105),
(1407,'Worodougou ',105),
(1408,'Zanzan ',105),
(1409,'Clarendon ',106),
(1410,'Hanover ',106),
(1411,'Kingston ',106),
(1412,'Manchester ',106),
(1413,'Portland ',106),
(1414,'Saint Andrews ',106),
(1415,'Saint Ann ',106),
(1416,'Saint Catherine ',106),
(1417,'Saint Elizabeth ',106),
(1418,'Saint James ',106),
(1419,'Saint Mary ',106),
(1420,'Saint Thomas ',106),
(1421,'Trelawny ',106),
(1422,'Westmoreland ',106),
(1423,'Aichi ',107),
(1424,'Akita ',107),
(1425,'Aomori ',107),
(1426,'Chiba ',107),
(1427,'Ehime ',107),
(1428,'Fukui ',107),
(1429,'Fukuoka ',107),
(1430,'Fukushima ',107),
(1431,'Gifu ',107),
(1432,'Gumma ',107),
(1433,'Hiroshima ',107),
(1434,'Hokkaido ',107),
(1435,'Hyogo ',107),
(1436,'Ibaraki ',107),
(1437,'Ishikawa ',107),
(1438,'Iwate ',107),
(1439,'Kagawa ',107),
(1440,'Kagoshima ',107),
(1441,'Kanagawa ',107),
(1442,'Kochi ',107),
(1443,'Kumamoto ',107),
(1444,'Kyoto ',107),
(1445,'Mie ',107),
(1446,'Miyagi ',107),
(1447,'Miyazaki ',107),
(1448,'Nagano ',107),
(1449,'Nagasaki ',107),
(1450,'Nara ',107),
(1451,'Niigata ',107),
(1452,'Oita ',107),
(1453,'Okayama ',107),
(1454,'Okinawa ',107),
(1455,'Osaka ',107),
(1456,'Saga ',107),
(1457,'Saitama ',107),
(1458,'Shiga ',107),
(1459,'Shimane ',107),
(1460,'Shizuoka ',107),
(1461,'Tochigi ',107),
(1462,'Tokushima ',107),
(1463,'Tokyo ',107),
(1464,'Tottori ',107),
(1465,'Toyama ',107),
(1466,'Wakayama ',107),
(1467,'Yamagata ',107),
(1468,'Yamaguchi ',107),
(1469,'Yamanashi ',107),
(1470,'Ajlun ',108),
(1471,'Amman',108),
(1472,'Aqaba ',108),
(1473,'Balqa ',108),
(1474,'Irbid ',108),
(1475,'Jarash ',108),
(1476,'Karak ',108),
(1477,'Ma an ',108),
(1478,'Madaba ',108),
(1479,'Mafraq ',108),
(1480,'Tafilah ',108),
(1481,'Zarqa ',108),
(1482,'Almaty Province ',109),
(1483,'Aqmola ',109),
(1484,'Aqtobe ',109),
(1485,'Astana ',109),
(1486,'Atyrau ',109),
(1487,'East Kazakhstan ',109),
(1488,'Magghystau ',109),
(1489,'North Kazakhstan ',109),
(1490,'Pavlodar ',109),
(1491,'Qaraghandy ',109),
(1492,'Qostanay ',109),
(1493,'Qysylorda ',109),
(1494,'South Kazakhstan ',109),
(1495,'West Kazakhstan ',109),
(1496,'Zhambyl ',109),
(1497,'Central ',110),
(1498,'Coast ',110),
(1499,'Eastern ',110),
(1500,'Nairobi ',110),
(1501,'North Eastern ',110),
(1502,'Nyanza ',110),
(1503,'Rift Valley ',110),
(1504,'Western ',110),
(1505,'Gilbert Islands ',111),
(1506,'Line Islands ',111),
(1507,'Phoenix Islands ',111),
(1508,'Chagang-do ',112),
(1509,'Gangwon ',112),
(1510,'Hamgyong-bukto ',112),
(1511,'Hamgyong-namdo ',112),
(1512,'Hwanghae-bukto ',112),
(1513,'Hwanghae-namdo ',112),
(1514,'Kaesong-si ',112),
(1515,'Najin Sonbong-si ',112),
(1516,'Nampo-si ',112),
(1517,'Pyongan-bukto ',112),
(1518,'Pyongan-namdo ',112),
(1519,'Pyongyang-si ',112),
(1520,'Yanggang-do ',112),
(1521,'Busan ',113),
(1522,'Daegu ',113),
(1523,'Daejeon ',113),
(1524,'Gangwon ',113),
(1525,'Gwangju ',113),
(1526,'Gyeonggi ',113),
(1527,'Incheon ',113),
(1528,'Jeju ',113),
(1529,'North Chungcheong ',113),
(1530,'North Gyeongsang ',113),
(1531,'North Jeolla ',113),
(1532,'Seoul ',113),
(1533,'South Chungcheong ',113),
(1534,'South Gyeongsang ',113),
(1535,'South Jeolla ',113),
(1536,'Ulsan ',113),
(1537,'Al-Ahmadi ',114),
(1538,'Al-Farwaniyah ',114),
(1539,'Al-Jahrah ',114),
(1540,'Al-Kuwayt ',114),
(1541,'Hawalli ',114),
(1542,'Mubarak Al-Kabir ',114),
(1543,'Batken ',115),
(1544,'Bishkek ',115),
(1545,'Chuy ',115),
(1546,'Jalal-Abad ',115),
(1547,'Naryn ',115),
(1548,'Osh ',115),
(1549,'Talas ',115),
(1550,'Ysyk-kol ',115),
(1551,'Attapu ',116),
(1552,'Bokeo ',116),
(1553,'Bolikhamxai ',116),
(1554,'Champasak ',116),
(1555,'Houaphan ',116),
(1556,'Khammouan ',116),
(1557,'Louang Namtha ',116),
(1558,'Louangphrabang ',116),
(1559,'Oudomzai ',116),
(1560,'Phongsali ',116),
(1561,'Saravan ',116),
(1562,'Savannakhet ',116),
(1563,'Vientiane ',116),
(1564,'Xaingnabouri ',116),
(1565,'Xekong ',116),
(1566,'Xiangkhoang ',116),
(1567,'Aizkraukle ',117),
(1568,'Aluksne ',117),
(1569,'Balvi ',117),
(1570,'Bauska ',117),
(1571,'Cesis ',117),
(1572,'Daugavpils ',117),
(1573,'Dobele ',117),
(1574,'Gulbene ',117),
(1575,'Jekabpils ',117),
(1576,'Jelgava ',117),
(1577,'Jurmala ',117),
(1578,'Kraslava ',117),
(1579,'Kuldiga ',117),
(1580,'Liepaja ',117),
(1581,'Limbazi ',117),
(1582,'Ludza ',117),
(1583,'Madona ',117),
(1584,'Ogre ',117),
(1585,'Preili ',117),
(1586,'Rezekne ',117),
(1587,'Riga ',117),
(1588,'Saldus ',117),
(1589,'Talsi ',117),
(1590,'Tukums ',117),
(1591,'Valka',117),
(1592,'Valmiera ',117),
(1593,'Ventspils ',117),
(1594,'Aakkar ',118),
(1595,'An Nabatiyah ',118),
(1596,'Baalbek-Hermel ',118),
(1597,'Beirut ',118),
(1598,'Beqaa ',118),
(1599,'Mount Lebanon ',118),
(1600,'North Lebanon ',118),
(1601,'South Lebanon ',118),
(1602,'Berea ',119),
(1603,'Butha-Buthe ',119),
(1604,'Leribe ',119),
(1605,'Maeteng ',119),
(1606,'Maseru ',119),
(1607,'Mohale s Hoek ',119),
(1608,'Mokhotlong ',119),
(1609,'Qacha s Nek ',119),
(1610,'Quthing ',119),
(1611,'Thaba-Tseka ',119),
(1612,'Bomi ',120),
(1613,'Bong ',120),
(1614,'Brand Cape Mount ',120),
(1615,'Gbarpulu ',120),
(1616,'Grand Bassa ',120),
(1617,'Grand Gedeh ',120),
(1618,'Grand Kru ',120),
(1619,'Lofa ',120),
(1620,'Margibi ',120),
(1621,'Maryland ',120),
(1622,'Montserrado ',120),
(1623,'Nimba ',120),
(1624,'River GEE ',120),
(1625,'Rivercess ',120),
(1626,'Sinoe ',120),
(1627,'Al Butnan ',121),
(1628,'Al Jabal al Akhdar ',121),
(1629,'Al Jabal al Gharbi ',121),
(1630,'Al Jifarah ',121),
(1631,'Al Jufrah ',121),
(1632,'Al Kufrah ',121),
(1633,'Al Marj ',121),
(1634,'Al Marqab ',121),
(1635,'Al Wahat ',121),
(1636,'An Nuqat al Khams ',121),
(1637,'AZ Zawiyah ',121),
(1638,'Benghazi ',121),
(1639,'Darnah ',121),
(1640,'Ghat ',121),
(1641,'Misratah ',121),
(1642,'Murzuq ',121),
(1643,'Nalut ',121),
(1644,'Sabha ',121),
(1645,'Surt ',121),
(1646,'Tripoli ',121),
(1647,'Wadi al Hayat ',121),
(1648,'Wadi ash Shati ',121),
(1649,'Balzers ',122),
(1650,'Eschen ',122),
(1651,'Gamprin ',122),
(1652,'Mauren ',122),
(1653,'Planken ',122),
(1654,'Ruggell ',122),
(1655,'Schaan ',122),
(1656,'Schellenberg ',122),
(1657,'Triesen ',122),
(1658,'Triesenberg ',122),
(1659,'Vaduz ',122),
(1660,'Alytus ',123),
(1661,'Kaunas ',123),
(1662,'Klaipeda ',123),
(1663,'Marijampole ',123),
(1664,'Panevezys ',123),
(1665,'Siauliai ',123),
(1666,'Taurage ',123),
(1667,'Telsiai ',123),
(1668,'Utena ',123),
(1669,'Vilnius ',123),
(1670,'Diekirch ',124),
(1671,'Grevenmacher ',124),
(1672,'Luxembourg ',124),
(1673,' Ilhas ',125),
(1674,'Macau Peninsula ',125),
(1675,'Berovo ',126),
(1676,'Bitola ',126),
(1677,'Brod ',126),
(1678,'Debar ',126),
(1679,'Delcevo ',126),
(1680,'Demir Hisar ',126),
(1681,'Gevgelija ',126),
(1682,'Gostivar ',126),
(1683,'Kavadarci ',126),
(1684,'Kicevo ',126),
(1685,'Kocani ',126),
(1686,'Kratovo ',126),
(1687,'Kriva Palanka ',126),
(1688,'Krusevo ',126),
(1689,'Kumanovo ',126),
(1690,'Negotino ',126),
(1691,'Ohrid ',126),
(1692,'Priliep ',126),
(1693,'Probistip ',126),
(1694,'Radovis ',126),
(1695,'Resen ',126),
(1696,'Skopje ',126),
(1697,'Stip ',126),
(1698,'Struga ',126),
(1699,'Strumica ',126),
(1700,'Sveti Nikole ',126),
(1701,'Tetovo ',126),
(1702,'Titov Veles ',126),
(1703,'Valandovo ',126),
(1704,'Vinica ',126),
(1705,'Antananarivo ',127),
(1706,'Antsiranana ',127),
(1707,'Fianarantsoa ',127),
(1708,'Mahajanga ',127),
(1709,'Toamasina ',127),
(1710,'Toliary ',127),
(1711,'Balaka ',128),
(1712,'Blantyre ',128),
(1713,'Chikwawa ',128),
(1714,'Chiradzulu ',128),
(1715,'Chitipa ',128),
(1716,'Dedza ',128),
(1717,'Dowa ',128),
(1718,'Karonga ',128),
(1719,'Kasungu ',128),
(1720,'Likoma ',128),
(1721,'Lilongwe ',128),
(1722,'Machinga ',128),
(1723,'Mangochi ',128),
(1724,'Mchinji ',128),
(1725,'Mulanje ',128),
(1726,'Mwanza ',128),
(1727,'Mzimba ',128),
(1728,'Neno ',128),
(1729,'Nkhata Bay ',128),
(1730,'Nkhotakota ',128),
(1731,'Nsanje ',128),
(1732,'Ntcheu ',128),
(1733,'Ntchisi ',128),
(1734,'Phalombe ',128),
(1735,'Rumphi ',128),
(1736,'Salima ',128),
(1737,'Thyolo ',128),
(1738,'Zomba ',128),
(1739,'Johor ',129),
(1740,'Kedah ',129),
(1741,'Kelantan ',129),
(1742,'Melaka ',129),
(1743,'Negeri Sembilan ',129),
(1744,'Pahang ',129),
(1745,'Penang ',129),
(1746,'Perak ',129),
(1747,'Perlis ',129),
(1748,'Sabah ',129),
(1749,'Sarawak ',129),
(1750,'Selangor ',129),
(1751,'Terengganu ',129),
(1752,'Capital ',130),
(1753,'Central ',130),
(1754,'North ',130),
(1755,'North Central ',130),
(1756,'South ',130),
(1757,'South Central ',130),
(1758,'Upper North ',130),
(1759,'Upper South ',130),
(1760,'Bamako ',131),
(1761,'Gao ',131),
(1762,'Kayes ',131),
(1763,'Kidal ',131),
(1764,'Koulikoro ',131),
(1765,'Mopti ',131),
(1766,'Segou ',131),
(1767,'Sikasso ',131),
(1768,'Timpuktu ',131),
(1769,'Central ',132),
(1770,'Gozo ',132),
(1771,'Northern ',132),
(1772,'South Eastern ',132),
(1773,'Southern ',132),
(1774,'Marshall Islands ',133),
(1775,'Fort de France ',134),
(1776,'La Marin ',134),
(1777,'La Trinite ',134),
(1778,'Saint Pierre ',134),
(1779,'Adrar ',135),
(1780,'Assaba ',135),
(1781,'Brakna ',135),
(1782,'Dakhlet Nouadhibou ',135),
(1783,'Gorgol ',135),
(1784,'Guidimaka ',135),
(1785,'Hodh ech Chargui ',135),
(1786,'Hodh el Gharbi ',135),
(1787,'Inchiri ',135),
(1788,'Nouakchott ',135),
(1789,'Tagant ',135),
(1790,'Tiris Zemmour ',135),
(1791,'Trarza ',135),
(1792,'Agalega Islands ',136),
(1793,'Black River ',136),
(1794,'Cargado Carajos ',136),
(1795,'Flacq ',136),
(1796,'Grand Port ',136),
(1797,'Moka ',136),
(1798,'Pamplemousses ',136),
(1799,'Plaines Wilhems ',136),
(1800,'Port Louis ',136),
(1801,'Riviere du Rempart ',136),
(1802,'Rodrigues ',136),
(1803,'Savanne ',136),
(1804,'Mayotte ',137),
(1805,'Aguascalientes ',138),
(1806,'Baja California ',138),
(1807,'Baja California Sur ',138),
(1808,'Campeche ',138),
(1809,'Chiapas ',138),
(1810,'Chihuahua ',138),
(1811,'Coahuila ',138),
(1812,'Colima ',138),
(1813,'Distrito Federal ',138),
(1814,'Durango ',138),
(1815,'Guanajuato ',138),
(1816,'Guerrero ',138),
(1817,'Hidalgo ',138),
(1818,'Jalisco ',138),
(1819,'Mexico State ',138),
(1820,'Micohancan ',138),
(1821,'Morelos ',138),
(1822,'Nayarit ',138),
(1823,'Nuevo Leon ',138),
(1824,'Oaxaca ',138),
(1825,'Puebla ',138),
(1826,'Queretaro ',138),
(1827,'Quintana Roo ',138),
(1828,'San Luis Potosi ',138),
(1829,'Sinaloa ',138),
(1830,'Sonora ',138),
(1831,'Tabasco ',138),
(1832,'Tamaulipas ',138),
(1833,'Tlaxcala ',138),
(1834,'Veracruz ',138),
(1835,'Yucatan ',138),
(1836,'Zacatecas ',138),
(1837,'Chuuk ',139),
(1838,'Kosrae ',139),
(1839,'Pohnpei ',139),
(1840,'Yap ',139),
(1841,'Cahul ',140),
(1842,'Chisinau ',140),
(1843,'Chisnaul ',140),
(1844,'Dubasari ',140),
(1845,'Edinet ',140),
(1846,'Gagauzia ',140),
(1847,'Lapusna ',140),
(1848,'Orhei ',140),
(1849,'Soroca ',140),
(1850,'Tighina ',140),
(1851,'Ungheni ',140),
(1852,'Balti ',140),
(1853,'Monaco ',141),
(1854,'Arhangay ',142),
(1855,'Bayan-Olgiy ',142),
(1856,'Bayanhongor ',142),
(1857,'Bulgan ',142),
(1858,'Dornod ',142),
(1859,'Dornogovi ',142),
(1860,'Dundgovi ',142),
(1861,'Dzavhan ',142),
(1862,'Govi-Altay ',142),
(1863,'Hentiy ',142),
(1864,'Hovd ',142),
(1865,'Hovsgol ',142),
(1866,'Omnogovi ',142),
(1867,'Ovorhangay ',142),
(1868,'Selenge ',142),
(1869,'Suhbaatar ',142),
(1870,'Ulaanbaatar ',142),
(1871,'Uvs ',142),
(1872,'Saint Anthony ',143),
(1873,'Saint Georges ',143),
(1874,'Saint Peter',143),
(1875,'Chaouia-Ouardigha ',144),
(1876,'Doukkala-Abda ',144),
(1877,'Fes-Boulemane ',144),
(1878,'Gharb-Chrarda-Beni Hsen ',144),
(1879,'Grand Casablanca ',144),
(1880,'Laayoune-Boujdour-Sakia El Hamra ',144),
(1881,'Marrakech-Tensift-El Haouz ',144),
(1882,'Meknes-Tafilalt ',144),
(1883,'Oriental ',144),
(1884,'Oued Ed-Dahab-Lagouira ',144),
(1885,'Rabat-Sale-Zemmour-Zaer ',144),
(1886,'Sous-Massa-Draa ',144),
(1887,'Tadla-Azilal ',144),
(1888,'Tanger-Tetouan ',144),
(1889,'Taza-Al Hoceima-Taounate ',144),
(1890,'Cabo Delgado ',145),
(1891,'Gaza ',145),
(1892,'Inhambane ',145),
(1893,'Manica ',145),
(1894,'Maputo ',145),
(1895,'Nampula ',145),
(1896,'Niassa ',145),
(1897,'Sofala ',145),
(1898,'Tete ',145),
(1899,'Zambezia ',145),
(1900,'Chin ',146),
(1901,'Kachin ',146),
(1902,'Kayah ',146),
(1903,'Kayin ',146),
(1904,'Mon ',146),
(1905,'Rakhine ',146),
(1906,'Shan ',146),
(1907,'Caprivi ',147),
(1908,'Erongo ',147),
(1909,'Hardap ',147),
(1910,'Karas ',147),
(1911,'Khomas ',147),
(1912,'Kunene ',147),
(1913,'Ohangwena ',147),
(1914,'Okavango ',147),
(1915,'Omaheke ',147),
(1916,'Oshana ',147),
(1917,'Oshikoto ',147),
(1918,'Otjozondjupa ',147),
(1919,'Aiwo ',148),
(1920,'Anabar ',148),
(1921,'Anetan ',148),
(1922,'Anibare ',148),
(1923,'Baiti ',148),
(1924,'Boe ',148),
(1925,'Buada ',148),
(1926,'Denigomodu ',148),
(1927,'Ewa ',148),
(1928,'Ijuw ',148),
(1929,'Meneng ',148),
(1930,'Nibok ',148),
(1931,'Uaboe ',148),
(1932,'Yaren ',148),
(1933,'Bagmati Zone ',149),
(1934,'Bheri Zone ',149),
(1935,'Dhawalagiri Zone ',149),
(1936,'Gandaki Zone ',149),
(1937,'Janakpur Zone ',149),
(1938,'Karnali Zone ',149),
(1939,'Kosi Zone ',149),
(1940,'Lumbini Zone ',149),
(1941,'Mahakali Zone ',149),
(1942,'Mechi Zone ',149),
(1943,'Narayani Zone ',149),
(1944,'Rapti Zone ',149),
(1945,'Sagarmatha Zone ',149),
(1946,'Seti Zone ',149),
(1947,'North Brabant ',150),
(1948,'North Holland ',150),
(1949,'Drenthe ',150),
(1950,'Flevoland ',150),
(1951,'Friesland ',150),
(1952,'Gelderland ',150),
(1953,'Groningen ',150),
(1954,'Limburg ',150),
(1955,'Overijssel ',150),
(1956,'Utrecht ',150),
(1957,'Zeeland ',150),
(1958,'South Holland ',150),
(1959,'Netherlands Antilles ',151),
(1960,'Iles Loyaute ',152),
(1961,'Nord ',152),
(1962,'Sub ',152),
(1963,'Auckland ',153),
(1964,'Bay of Plenty ',153),
(1965,'Canterbury ',153),
(1966,'Chatham Islands ',153),
(1967,'Gisborne ',153),
(1968,'Hawke s Bay ',153),
(1969,'Manawatu-Wanganui ',153),
(1970,'Nelson ',153),
(1971,'Northland ',153),
(1972,'Otago ',153),
(1973,'Southland ',153),
(1974,'Taranaki ',153),
(1975,'Tasman ',153),
(1976,'Waikato ',153),
(1977,'Wellington ',153),
(1978,'West Coast ',153),
(1979,'Atlantico Norte ',154),
(1980,'Atlantico Sur ',154),
(1981,'Boaco ',154),
(1982,'Carazo ',154),
(1983,'Chinandega ',154),
(1984,'Chontales ',154),
(1985,'Esteli ',154),
(1986,'Granada ',154),
(1987,'Jinotega ',154),
(1988,'Leon ',154),
(1989,'Madriz ',154),
(1990,'Managua ',154),
(1991,'Masaya ',154),
(1992,'Matagalpa ',154),
(1993,'Nueva Segovia ',154),
(1994,'Rio San Juan ',154),
(1995,'Rivas ',154),
(1996,'Agadez ',155),
(1997,'Diffa ',155),
(1998,'Dosso ',155),
(1999,'Maradi ',155),
(2000,'Niamey ',155),
(2001,'Tahoua ',155),
(2002,'Tillaberi ',155),
(2003,'Zinder ',155),
(2004,' Nassarawa ',156),
(2005,'Abia ',156),
(2006,'Abuja ',156),
(2007,'Adamawa ',156),
(2008,'Akwa Ibom ',156),
(2009,'Anambra ',156),
(2010,'Bauchi ',156),
(2011,'Bayelsa ',156),
(2012,'Benue ',156),
(2013,'Borno ',156),
(2014,'Cross River ',156),
(2015,'Delta ',156),
(2016,'Ebonyi ',156),
(2017,'Edo ',156),
(2018,'Ekiti ',156),
(2019,'Enugu ',156),
(2020,'Gombe ',156),
(2021,'Imo ',156),
(2022,'Jigawa ',156),
(2023,'Kaduna ',156),
(2024,'Kano ',156),
(2025,'Katsina ',156),
(2026,'Kebbi ',156),
(2027,'Kogi ',156),
(2028,'Kwara ',156),
(2029,'Lagos ',156),
(2030,'Niger ',156),
(2031,'Ogun ',156),
(2032,'Osun ',156),
(2033,'Oyo ',156),
(2034,'Plateau ',156),
(2035,'Rivers ',156),
(2036,'Sokoto ',156),
(2037,'Taraba ',156),
(2038,'Yobe ',156),
(2039,'Zamfara ',156),
(2040,'Niue ',157),
(2041,'Norfolk Island ',158),
(2042,'Northern Islands ',159),
(2043,'Rota ',159),
(2044,'Saipan ',159),
(2045,'Tinian ',159),
(2046,'Akershus ',160),
(2047,'Aust-Agder ',160),
(2048,'Buskerud ',160),
(2049,'Finnmark ',160),
(2050,'Hedmark ',160),
(2051,'Hordaland ',160),
(2052,'More og Romsdal ',160),
(2053,'Nord-Trondelag ',160),
(2054,'Nordland ',160),
(2055,'Oppland ',160),
(2056,'Oslo ',160),
(2057,'Ostfold ',160),
(2058,'Rogaland ',160),
(2059,'Sogn og Fjordane ',160),
(2060,'Sor-Trondelag ',160),
(2061,'Telemark ',160),
(2062,'Troms ',160),
(2063,'Vest-Agder ',160),
(2064,'Vestfold ',160);
SQL Query for State list of 161 to 237 Countries

INSERT INTO `state` (`STATE_ID`,`STATE_NAME`,`COUNTRY_ID`) VALUES 
(2065,'Ad Dakjliyah ',161),
(2066,'Adh Dhahirah ',161),
(2067,'Al Batinah North ',161),
(2068,'Al Batinah South ',161),
(2069,'Al Buraymi ',161),
(2070,'Al Wusta ',161),
(2071,'Ash Sharqiyah North ',161),
(2072,'Ash Sharqiyah South ',161),
(2073,'Dhofar ',161),
(2074,'Musandam ',161),
(2075,'Muscat ',161),
(2076,'Azad Kashmir ',162),
(2077,'Balochistan ',162),
(2078,'Federally Administered Tribal Areas ',162),
(2079,'Gilgit-Baltistan ',162),
(2080,'Islamabad ',162),
(2081,'Khyber-Pakhtunkhwa ',162),
(2082,'Punjab ',162),
(2083,'Sind ',162),
(2084,'Aimeliik ',163),
(2085,'Airai ',163),
(2086,'Hatohobei ',163),
(2087,'Kayangel ',163),
(2088,'Koror ',163),
(2089,'Melekeok ',163),
(2090,'Ngaraard ',163),
(2091,'Ngarchelong ',163),
(2092,'Ngardmau ',163),
(2093,'Ngatpang ',163),
(2094,'Ngchesar ',163),
(2095,'Ngeremlengui ',163),
(2096,'Ngiwal ',163),
(2097,'Pelepiu ',163),
(2098,'Sonsorol ',163),
(2099,'Bocas del Toro ',164),
(2100,'Chiriqui ',164),
(2101,'Cocle ',164),
(2102,'Colon ',164),
(2103,'Darien ',164),
(2104,'Embera ',164),
(2105,'Herrera ',164),
(2106,'Kuna Yala ',164),
(2107,'Los Santos ',164),
(2108,'Nagbe Bugle ',164),
(2109,'Panama ',164),
(2110,'Veraguas ',164),
(2111,'Bougainville ',165),
(2112,'Central ',165),
(2113,'Chimbu ',165),
(2114,'East New Britain ',165),
(2115,'East Sepik ',165),
(2116,'Eastern Highlands ',165),
(2117,'Enga ',165),
(2118,'Gulf ',165),
(2119,'Madang ',165),
(2120,'Manus ',165),
(2121,'Milne Bay ',165),
(2122,'Morobe ',165),
(2123,'National Capital District ',165),
(2124,'New Ireland ',165),
(2125,'Northern ',165),
(2126,'Sandaun ',165),
(2127,'Southern Highlands ',165),
(2128,'West New Britain ',165),
(2129,'Western ',165),
(2130,'Western Highlands ',165),
(2131,'Alto Paraguay ',166),
(2132,'Alto Parana ',166),
(2133,'Amambay ',166),
(2134,'Asuncion ',166),
(2135,'Boqueron ',166),
(2136,'Caaguazu ',166),
(2137,'Caazapa ',166),
(2138,'Canindeyu ',166),
(2139,'Central ',166),
(2140,'Concepcion ',166),
(2141,'Cordillera ',166),
(2142,'Guaira ',166),
(2143,'Itapua ',166),
(2144,'Misiones ',166),
(2145,'Neembucu ',166),
(2146,'Paraguari ',166),
(2147,'Presidente Hayes ',166),
(2148,'San Pedro ',166),
(2149,'Amazonas ',167),
(2150,'Ancash ',167),
(2151,'Apurimac ',167),
(2152,'Arequipa ',167),
(2153,'Ayacucho ',167),
(2154,'Cajamarca ',167),
(2155,'Cusco ',167),
(2156,'Huancavelica ',167),
(2157,'Huanuco ',167),
(2158,'Ica ',167),
(2159,'Junin ',167),
(2160,'La Libertad ',167),
(2161,'Lambayeque ',167),
(2162,'Lima ',167),
(2163,'Loreto ',167),
(2164,'Madre de Dios ',167),
(2165,'Moquegua ',167),
(2166,'Pasco ',167),
(2167,'Piura ',167),
(2168,'Puno ',167),
(2169,'San Martin ',167),
(2170,'Tacna ',167),
(2171,'Tumbes ',167),
(2172,'Ucayali ',167),
(2173,'Abra ',168),
(2174,'Agusan Del Norte ',168),
(2175,'Agusan del Sur ',168),
(2176,'Aklan ',168),
(2177,'Albay ',168),
(2178,'Antique ',168),
(2179,'Apayao ',168),
(2180,'Aurora ',168),
(2181,'Basilan ',168),
(2182,'Bataan ',168),
(2183,'Batanes ',168),
(2184,'Batangas ',168),
(2185,'Benguet ',168),
(2186,'Biliran ',168),
(2187,'Bohol ',168),
(2188,'Bukidnon ',168),
(2189,'Bulacan ',168),
(2190,'Cagayan ',168),
(2191,'Camarines Norte ',168),
(2192,'Camarines Sur ',168),
(2193,'Camiguin ',168),
(2194,'Capiz ',168),
(2195,'Catanduanes ',168),
(2196,'Cavite ',168),
(2197,'Cebu ',168),
(2198,'Compostela Valley ',168),
(2199,'Cotabato ',168),
(2200,'Davao del Norte ',168),
(2201,'Davao del Sur ',168),
(2202,'Davao Oriental ',168),
(2203,'Dinagat Islands ',168),
(2204,'Eastern Samar ',168),
(2205,'Guimaras ',168),
(2206,'Ifugao ',168),
(2207,'Ilocos Norte ',168),
(2208,'Ilocos Sur ',168),
(2209,'Iloilo ',168),
(2210,'Isabela ',168),
(2211,'Kalinga ',168),
(2212,'La Union ',168),
(2213,'Laguna ',168),
(2214,'Lanao del Norte ',168),
(2215,'Lanao del Sur ',168),
(2216,'Leyte ',168),
(2217,'Maguindanao ',168),
(2218,'Marinduque ',168),
(2219,'Masbate ',168),
(2220,'Metropolitan Manila ',168),
(2221,'Misamis Occidental ',168),
(2222,'Misamis Oriental ',168),
(2223,'Mountain ',168),
(2224,'Negros Occidental ',168),
(2225,'Negros Oriental ',168),
(2226,'Northern Samar ',168),
(2227,'Nueva Ecija ',168),
(2228,'Nueva Vizcaya ',168),
(2229,'Occidental Mindoro ',168),
(2230,'Oriental Mindoro ',168),
(2231,'Palawan ',168)
(2232,'Pampanga ',168),
(2233,'Pangasinan ',168),
(2234,'Quezon ',168),
(2235,'Quirino ',168),
(2236,'Rizal ',168),
(2237,'Romblon ',168),
(2238,'Samar ',168),
(2239,'Sarangani ',168),
(2240,'Siquijor ',168),
(2241,'Sorsogon ',168),
(2242,'South Cotabato ',168),
(2243,'Southern Leyte ',168),
(2244,'Sultan Kudarat ',168),
(2245,'Sulu ',168),
(2246,'Surigao del Norte ',168),
(2247,'Surigao del Sur ',168),
(2248,'Tarlac ',168),
(2249,'Tawi-Tawi ',168),
(2250,'Zambales ',168),
(2251,'Zamboanga del Norte ',168),
(2252,'Zamboanga del Sur ',168),
(2253,'Zamboanga-Sibugay ',168),
(2254,'Pitcairn Islands ',169),
(2255,'Dolnoslaskie ',170),
(2256,'Kujawsko-Pomorskie ',170),
(2257,'Lodzkie ',170),
(2258,'Lubelskie ',170),
(2259,'Lubuskie ',170),
(2260,'Malopolskie ',170),
(2261,'Mazowieckie ',170),
(2262,'Opolskie ',170),
(2263,'Podkarpackie ',170),
(2264,'Podlaskie ',170),
(2265,'Pomorskie ',170),
(2266,'Slaskie ',170),
(2267,'Swietokrzyskie ',170),
(2268,'Warminsko-Mazurskie ',170),
(2269,'Wielkopolskie ',170),
(2270,'Zachodniopomorskie ',170),
(2271,'Aveiro ',171),
(2272,'Azores ',171),
(2273,'Beja ',171),
(2274,'Braga ',171),
(2275,'Braganca ',171),
(2276,'Castelo Branco ',171),
(2277,'Coimbra ',171),
(2278,'Evora ',171),
(2279,'Faro ',171),
(2280,'Guarda ',171),
(2281,'Leiria ',171),
(2282,'Lisboa ',171),
(2283,'Madeira ',171),
(2284,'Portalegre ',171),
(2285,'Porto ',171),
(2286,'Santarem ',171),
(2287,'Setubal ',171),
(2288,'Viana do Castelo ',171),
(2289,'Vila Real ',171),
(2290,'Viseu ',171),
(2291,'Aguadilla ',172),
(2292,'Arecibo ',172),
(2293,'Bayamon ',172),
(2294,'Caguas ',172),
(2295,'Carolina ',172),
(2296,'Cayey ',172),
(2297,'Fajardo ',172),
(2298,'Guayama ',172),
(2299,'Guaynabo ',172),
(2300,'Humacao ',172),
(2301,'Mayaguez ',172),
(2302,'Ponce ',172),
(2303,'San Juan ',172),
(2304,'Trujillo Alto ',172),
(2305,'Utuado ',172),
(2306,'Vieques ',172),
(2307,'Yauco ',172),
(2308,'Ad Dawhah ',173),
(2309,'Al Daayen ',173),
(2310,'Al Khawr ',173),
(2311,'Al Wakrah ',173),
(2312,'Ar Rayyan ',173),
(2313,'Madinat ach Shamal ',173),
(2314,'Saint Benoit ',174),
(2315,'Saint Denis ',174),
(2316,'Saint Paul ',174),
(2317,'Saint Pierre ',174),
(2318,'Alba ',175),
(2319,'Arad ',175),
(2320,'Arges ',175),
(2321,'Bacau ',175),
(2322,'Bihor ',175),
(2323,'Bistrita-Nasaud ',175),
(2324,'Botosani ',175),
(2325,'Braila ',175),
(2326,'Brasov ',175),
(2327,'Buzau ',175),
(2328,'Calarasi ',175),
(2329,'Caras-Severin ',175),
(2330,'Cluj ',175),
(2331,'Constanta ',175),
(2332,'Covasna ',175),
(2333,'Dambovita ',175),
(2334,'Dolj ',175),
(2335,'Galati ',175),
(2336,'Giurgiu ',175),
(2337,'Gorj ',175),
(2338,'Harghita ',175),
(2339,'Hunedoara ',175),
(2340,'Ialomita ',175),
(2341,'Iasi ',175),
(2342,'Maramures ',175),
(2343,'Mehedinti ',175),
(2344,'Municipiul Bucuresti ',175),
(2345,'Mures ',175),
(2346,'Neamt ',175),
(2347,'Olt ',175),
(2348,'Prahova ',175),
(2349,'Salaj ',175),
(2350,'Satu Mare ',175),
(2351,'Sibiu ',175),
(2352,'Suceava ',175),
(2353,'Teleorman ',175),
(2354,'Timis ',175),
(2355,'Tulcea ',175),
(2356,'Valcea ',175),
(2357,'Vaslui ',175),
(2358,'Vrancea ',175),
(2359,'Adyget ',176),
(2360,'Altay ',176),
(2361,'Amur ',176),
(2362,'Arkhangel sk ',176),
(2363,'Astrakhan ',176),
(2364,'Bashkortostan ',176),
(2365,'Belgorod ',176),
(2366,'Bryansk ',176),
(2367,'Buryat ',176),
(2368,'Chechnya ',176),
(2369,'Chelyabinsk ',176),
(2370,'Chukot ',176),
(2371,'Chuvash ',176),
(2372,'Dagestan ',176),
(2373,'Gorno-Altay ',176),
(2374,'Ingush ',176),
(2375,'Irkutsk ',176),
(2376,'Ivanovo ',176),
(2377,'Kabardin-Balkar ',176),
(2378,'Kaliningrad ',176),
(2379,'Kalmyk ',176),
(2380,'Kaluga ',176),
(2381,'Kamchatka ',176),
(2382,'Karachay-Cherkess ',176),
(2383,'Karelia ',176),
(2384,'Kemerovo ',176),
(2385,'Khabarovsk ',176),
(2386,'Khakass ',176),
(2387,'Khaty-Mansiy ',176),
(2388,'Kirov ',176),
(2389,'Komi ',176),
(2390,'Kostroma ',176),
(2391,'Krasnodar ',176),
(2392,'Krasnoyarsk ',176),
(2393,'Kurgan ',176),
(2394,'Kursk ',176),
(2395,'Leningrad ',176),
(2396,'Lipetsk ',176),
(2397,'Magada ',176),
(2398,'Mariy-El ',176),
(2399,'Mordovia ',176),
(2400,'Moscow City ',176),
(2401,'Moskva ',176),
(2402,'Murmansk ',176),
(2403,'Nenets ',176),
(2404,'Nizhegorod ',176),
(2405,'North Ossetia ',176),
(2406,'Novgorod ',176),
(2407,'Novosibirsk ',176),
(2408,'Omsk ',176),
(2409,'Oreburg ',176),
(2410,'Orel ',176),
(2411,'Penza ',176),
(2412,'Perm ',176),
(2413,'Primor ye ',176),
(2414,'Pskov ',176),
(2415,'Rostov ',176),
(2416,'Ryazan ',176),
(2417,'Saint Petersburg City ',176),
(2418,'Sakha ',176),
(2419,'Samara ',176),
(2420,'Saratov ',176),
(2421,'Smolensk ',176),
(2422,'Stavropol ',176),
(2423,'Sverdlovsk ',176),
(2424,'Tambov ',176),
(2425,'Tatarstan ',176),
(2426,'Tomsk ',176),
(2427,'Tula ',176),
(2428,'Tver ',176),
(2429,'Tyumen ',176),
(2430,'Udmurt ',176),
(2431,'Ul yanovsk ',176),
(2432,'Vladimir ',176),
(2433,'Volgograd ',176),
(2434,'Vologda ',176),
(2435,'Voronezh ',176),
(2436,'Yamal-Nenets ',176),
(2437,'Yaroslavl ',176),
(2438,'Yevrey ',176),
(2439,'Zabaykal ye ',176),
(2440,'Eastern ',177),
(2441,'Kigali City ',177),
(2442,'Northern ',177),
(2443,'Southern ',177),
(2444,'Western ',177),
(2445,'Christ Church Nichola Town ',178),
(2446,'Saint Anne Sandy Point ',178),
(2447,'Saint George Basseterre ',178),
(2448,'Saint George Gingerland ',178),
(2449,'Saint James Windward ',178),
(2450,'Saint John Capisterre ',178),
(2451,'Saint John Figtree ',178),
(2452,'Saint Mary Cayon ',178),
(2453,'Saint Paul Capisterre ',178),
(2454,'Saint Paul Charlestown ',178),
(2455,'Saint Peter Basseterre ',178),
(2456,'Saint Thomas Lowland ',178),
(2457,'Saint Thomas Middle Island ',178),
(2458,'Trinity Palmetto Point ',178),
(2459,'Anse-la-Raye ',179),
(2460,'Canaries ',179),
(2461,'Castries ',179),
(2462,'Choiseul ',179),
(2463,'Dennery ',179),
(2464,'Gros Islet ',179),
(2465,'Laborie ',179),
(2466,'Micoud ',179),
(2467,'Soufriere ',179),
(2468,'Vieux Fort ',179),
(2469,'Charlotte ',180),
(2470,'Grenadines ',180),
(2471,'Saint Andrew ',180),
(2472,'Saint David ',180),
(2473,'Saint George ',180),
(2474,'Saint Patrick ',180),
(2475,'A ana ',181),
(2476,'Aiga-i-le-Tai ',181),
(2477,'Atua ',181),
(2478,'Fa asaleleaga ',181),
(2479,'Gaga emauga ',181),
(2480,'Gagaifomauga ',181),
(2481,'Palauli ',181),
(2482,'Satupa itea ',181),
(2483,'Tuamasaga ',181),
(2484,'Va a-o-Fonoti ',181),
(2485,'Vaisigano ',181),
(2486,'Acauaviva ',182),
(2487,'Borgo Maggiore ',182),
(2488,'Chiesanuova ',182),
(2489,'Domagnano ',182),
(2490,'Faetano ',182),
(2491,'Fiorentino ',182),
(2492,'Montegiardino ',182),
(2493,'San Marino ',182),
(2494,'Serravalle ',182),
(2495,'Principe ',183),
(2496,'Sao Tome ',183),
(2497,'Al Bahah ',184),
(2498,'Al Hudud ash Shamaliyah ',184),
(2499,'Al Madinah ',184),
(2500,'Al Mintaqah ash Sharqiyah ',184),
(2501,'Al Qasim ',184),
(2502,'Al-Jawf ',184),
(2503,'Ar Riyad ',184),
(2504,'Asir ',184),
(2505,'Ha il ',184),
(2506,'Jizan ',184),
(2507,'Makkah ',184),
(2508,'Najran ',184),
(2509,'Tabuk ',184),
(2510,'Dakar ',185),
(2511,'Diourbel ',185),
(2512,'Fatick ',185),
(2513,'Kaffrine ',185),
(2514,'Kaolack ',185),
(2515,'Kedougou ',185),
(2516,'Kolda ',185),
(2517,'Louga ',185),
(2518,'Matam ',185),
(2519,'Saint-Louis ',185),
(2520,'Sedhiou ',185),
(2521,'Tambacounda ',185),
(2522,'Thies ',185),
(2523,'Ziguinchor ',185),
(2524,'Anse aux Pins ',186),
(2525,'Anse Boileau ',186),
(2526,'Anse Etoile ',186),
(2527,'Anse Royale ',186),
(2528,'Au Cap ',186),
(2529,'Baie Lazare ',186),
(2530,'Baie Sainte Anne ',186),
(2531,'Beau Vallon ',186),
(2532,'Bel Air ',186),
(2533,'Belombre ',186),
(2534,'Cascade ',186),
(2535,'English River ',186),
(2536,'Glascis ',186),
(2537,'Grand Anse (Mahe) ',186),
(2538,'Grand Anse (Praslin)',186),
(2539,'La Digue and Inner Islands ',186),
(2540,'Les Mamelles ',186),
(2541,'Mont Buxton ',186),
(2542,'Mont Fleuri ',186),
(2543,'Outer Islands ',186),
(2544,'Plaisance ',186),
(2545,'Pointe La Rue ',186),
(2546,'Port Glaud ',186),
(2547,'Roche Caiman ',186),
(2548,'Saint Louis ',186),
(2549,'Takamaka ',186),
(2550,'Eastern Province ',187),
(2551,'Northern Province ',187),
(2552,'Southern Province ',187),
(2553,'Western Area ',187),
(2554,'Central Singapore ',188),
(2555,'North East ',188),
(2556,'North West ',188),
(2557,'South East ',188),
(2558,'South West ',188),
(2559,'Banska Bystrica ',189),
(2560,'Bratislava ',189),
(2561,'Kosice ',189),
(2562,'Nitra ',189),
(2563,'Presov ',189),
(2564,'Trencin ',189),
(2565,'Trnava ',189),
(2566,'Zilina ',189),
(2567,'Dolenjska ',190),
(2568,'Gorenjska ',190),
(2569,'Goriska ',190),
(2570,'Koroska ',190),
(2571,'Notranjsko-kraska ',190),
(2572,'Obalno-kraska ',190),
(2573,'Osrednjeslovenska ',190),
(2574,'Podravska ',190),
(2575,'Pomurska ',190),
(2576,'Savinjska ',190),
(2577,'Spodnjeposavsak ',190),
(2578,'Zasavska ',190),
(2579,'Capital Territory ',191),
(2580,'Central ',191),
(2581,'Choiseul ',191),
(2582,'Guadalcanal ',191),
(2583,'Isabel ',191),
(2584,'Makira ',191),
(2585,'Malaita ',191),
(2586,'Rennell and Bellona ',191),
(2587,'Temotu ',191),
(2588,'Western ',191),
(2589,'Awdal ',192),
(2590,'Bakool ',192),
(2591,'Banaadir ',192),
(2592,'Bari ',192),
(2593,'Bay ',192),
(2594,'Galguduud ',192),
(2595,'Gedo ',192),
(2596,'Hiiraan ',192),
(2597,'Jubbada Dhexe ',192),
(2598,'Jubbada Hoose ',192),
(2599,'Mudug ',192),
(2600,'Nugaal ',192),
(2601,'Sanaag ',192),
(2602,'Shabeellaha Dhexe ',192),
(2603,'Shabeellaha Hoose ',192),
(2604,'Sool ',192),
(2605,'Togdheer ',192),
(2606,'Woqooyi Galbeed ',192),
(2607,'Eastern Cape ',193),
(2608,'Free State ',193),
(2609,'Gauteng ',193),
(2610,'KwaZulu-Natal ',193),
(2611,'Limpopo ',193),
(2612,'Mpumalanga ',193),
(2613,'North-West ',193),
(2614,'Northern Cape ',193),
(2615,'Western Cape ',193),
(2616,'South Georgia and South Sandwich Is ',194),
(2617,'Andalucia ',195),
(2618,'Aragon ',195),
(2619,'Asturias ',195),
(2620,'Baleares ',195),
(2621,'Basque Country ',195),
(2622,'Canarias ',195),
(2623,'Cantabria ',195),
(2624,'Castilla y Leon ',195),
(2625,'Castilla-La Mancha ',195),
(2626,'Cataluna ',195),
(2627,'Ceuta y Melilla ',195),
(2628,'Extremadura ',195),
(2629,'Galicia ',195),
(2630,'La Rioja ',195),
(2631,'Madrid ',195),
(2632,'Murcia ',195),
(2633,'Navarra ',195),
(2634,'Valencia ',195),
(2635,'Anuradhapura ',196),
(2636,'Badulla ',196),
(2637,'Batticaloa ',196),
(2638,'Colombo ',196),
(2639,'Galle ',196),
(2640,'Jaffna ',196),
(2641,'Kandy ',196),
(2642,'Kurunegala ',196),
(2643,'Ratnapura ',196),
(2644,'Saint Helena ',197),
(2645,'Tristan da Cunha ',197),
(2646,'Ascension ',197),
(2647,'Miquelon-Langlade ',198),
(2648,'Saint-Pierre ',198),
(2649,'Blue Nile ',199),
(2650,'Gedarif ',199),
(2651,'Gezira ',199),
(2652,'Kassala ',199),
(2653,'Khartoum ',199),
(2654,'North Darfur ',199),
(2655,'North Kordufan ',199),
(2656,'Northern ',199),
(2657,'Red Sea ',199),
(2658,'River Nile ',199),
(2659,'Sennar ',199),
(2660,'South Darfur ',199),
(2661,'South Kordufan ',199),
(2662,'West Darfur ',199),
(2663,'White Nile ',199),
(2664,'Brokopondo ',200),
(2665,'Commewijne ',200),
(2666,'Coronie ',200),
(2667,'Marowijne ',200),
(2668,'Nickeie ',200),
(2669,'Paramaribo ',200),
(2670,'Para ',200),
(2671,'Para ',200),
(2672,'Sipaliwini ',200),
(2673,'Wanica ',200),
(2674,'Jay Mayen Islands ',201),
(2675,'Savlbard ',201),
(2676,'Hhohho ',202),
(2677,'Lubombo ',202),
(2678,'Manzini ',202),
(2679,'Shiselweni ',202),
(2680,'Blekinge ',203),
(2681,'Dalarna ',203),
(2682,'Gavleborg ',203),
(2683,'Gotland ',203),
(2684,'Halland ',203),
(2685,'Jamtland ',203),
(2686,'Jonkoping ',203),
(2687,'Kalmar ',203),
(2688,'Kronoberg ',203),
(2689,'Norrbotten ',203),
(2690,'Orebro ',203),
(2691,'Ostergotland ',203),
(2692,'Skane ',203),
(2693,'Sodermanland ',203),
(2694,'Stockholm ',203),
(2695,'Uppsala ',203),
(2696,'Varmland ',203),
(2697,'Vasterbotten ',203),
(2698,'Vasternorrland ',203),
(2699,'Vastmanland ',203),
(2700,'Vastra Gotaland ',203),
(2701,'Aargau ',204),
(2702,'Appenzell Inner Rhodes ',204),
(2703,'Appenzell Outer Rhodes ',204),
(2704,'Basel-Landschaft ',204),
(2705,'Basel-Stadt ',204),
(2706,'Bern ',204),
(2707,'Fribourg ',204),
(2708,'Geneva ',204),
(2709,'Glarus ',204),
(2710,'Graubunden ',204),
(2711,'Jura ',204),
(2712,'Lucerne ',204),
(2713,'Neuchatel ',204),
(2714,'Nidwalden ',204),
(2715,'Obwalden ',204),
(2716,'Sankt Gallen ',204),
(2717,'Schaffhausen ',204),
(2718,'Schwyz ',204),
(2719,'Solothurn ',204),
(2720,'Thurgau ',204),
(2721,'Ticino ',204),
(2722,'Uri ',204),
(2723,'Valais ',204),
(2724,'Vaud ',204),
(2725,'Zug ',204),
(2726,'Zurich ',204),
(2727,'Al Dasakah ',205),
(2728,'Aleppo ',205),
(2729,'Ar Raqqah ',205),
(2730,'Damascus ',205),
(2731,'Dar a ',205),
(2732,'Dayr az Zawr ',205),
(2733,'Hama ',205),
(2734,'Hims ',205),
(2735,'Idlib ',205),
(2736,'Latakia ',205),
(2737,'Quneitra ',205),
(2738,'Rif Dimashq ',205),
(2739,'Tartus ',205),
(2740,'Fukien ',206),
(2741,'Kaohsiung ',206),
(2742,'Taipei ',206),
(2743,'Taiwan ',206),
(2744,'Gorniy-Badakhshan ',207),
(2745,'Khatlon ',207),
(2746,'Regions of Republican Subordination ',207),
(2747,'Sogd ',207),
(2748,'Arusha ',208),
(2749,'Dar es Salaam ',208),
(2750,'Dodoma ',208),
(2751,'Iringa ',208),
(2752,'Kagera ',208),
(2753,'Kigoma ',208),
(2754,'Kilimanjaro ',208),
(2755,'Lindi ',208),
(2756,'Manyara ',208),
(2757,'Mara ',208),
(2758,'Mbeya ',208),
(2759,'Morogoro ',208),
(2760,'Mtwara ',208),
(2761,'Mwanza ',208),
(2762,'Pemba North ',208),
(2763,'Pemba South ',208),
(2764,'Pwani ',208),
(2765,'Rukwa ',208),
(2766,'Ruvuma ',208),
(2767,'Shinyanga ',208),
(2768,'Singida ',208),
(2769,'Tabora ',208),
(2770,'Tanga ',208),
(2771,'Zanzibar North ',208),
(2772,'Zanzibar South and Central ',208),
(2773,'Zanzibar West ',208),
(2774,'Amnat Charoen ',209),
(2775,'Ang Thong ',209),
(2776,'Bangkok Metropolis ',209),
(2777,'Bueng Kan ',209),
(2778,'Chachoengsao ',209),
(2779,'Chai Nat ',209),
(2780,'Chaiyaphum ',209),
(2781,'Chnthaburi ',209),
(2782,'Kamphaeng Phet ',209),
(2783,'Lamphun ',209),
(2784,'Lop Buri ',209),
(2785,'Maha Sarakham ',209),
(2786,'Mukdahan ',209),
(2787,'Nakhon Nayok ',209),
(2788,'Nong Bua Lam Phu ',209),
(2789,'Nonthaburi ',209),
(2790,'Pathum Thani ',209),
(2791,'Phangnga ',209),
(2792,'Phatthalung ',209),
(2793,'Phichit ',209),
(2794,'Phra Nakhon Si Ayutthaya ',209),
(2795,'Phrae ',209),
(2796,'Prachin Buri ',209),
(2797,'Sa Kaeo ',209),
(2798,'Samut Sakhon ',209),
(2799,'Samut Songkhram ',209),
(2800,'Saraburi ',209),
(2801,'Satun ',209),
(2802,'Si Sa Ket ',209),
(2803,'Sing Buri ',209),
(2804,'Centrale ',210),
(2805,'Kara ',210),
(2806,'Maritime ',210),
(2807,'Plateaux ',210),
(2808,'Savanes ',210),
(2809,'Atafu ',211),
(2810,'Fakaofo ',211),
(2811,'Nukunonu ',211),
(2812,'Ha apai ',212),
(2813,'Tongatapu ',212),
(2814,'Vava u ',212),
(2815,'Arima bor ',213),
(2816,'Chaguanas bor ',213),
(2817,'Couva/Tabaquite/Talparo reg ',213),
(2818,'Diego Martin ',213),
(2819,'Eastern Tobago ',213),
(2820,'Mayaro/Rio Claro ',213),
(2821,'Penal/Debe ',213),
(2822,'Point Fortin bor ',213),
(2823,'Port of Spain ',213),
(2824,'Princes Town ',213),
(2825,'San Fernando ',213),
(2826,'San Juan/Laventille ',213),
(2827,'Sangre Grande ',213),
(2828,'Siparia ',213),
(2829,'Tunapuna/Piarco ',213),
(2830,'Wester Tobago ',213),
(2831,'Ariana ',214),
(2832,'Beja ',214),
(2833,'Ben Arous ',214),
(2834,'Bizerte ',214),
(2835,'Gabes ',214),
(2836,'Gafsa ',214),
(2837,'Jendouba ',214),
(2838,'Kairouan ',214),
(2839,'Kasserine ',214),
(2840,'Kebili ',214),
(2841,'Le Kef ',214),
(2842,'Mahdia ',214),
(2843,'Manouba ',214),
(2844,'Medenine ',214),
(2845,'Monastir ',214),
(2846,'Nabeul ',214),
(2847,'Sfax ',214),
(2848,'Sidi Bou Zid ',214),
(2849,'Siliana ',214),
(2850,'Sousse ',214),
(2851,'Tataouine ',214),
(2852,'Tozeur ',214),
(2853,'Tunis ',214),
(2854,'Zaghouan ',214),
(2855,'Agri ',215),
(2856,'Ankara ',215),
(2857,'Giresun ',215),
(2858,'Istanbul ',215),
(2859,'Kayseri ',215),
(2860,'Osmaniye ',215),
(2861,'Siirt ',215),
(2862,'Usak ',215),
(2863,'Ahal ',216),
(2864,'Balkan ',216),
(2865,'Dasoguz ',216),
(2866,'Lebap ',216),
(2867,'Mary ',216),
(2868,'Turks and Caicos Islands ',217),
(2869,'Funafuti ',218),
(2870,'Nanumanga ',218),
(2871,'Nanumea ',218),
(2872,'Niutao ',218),
(2873,'Nui ',218),
(2874,'Nukufetau ',218),
(2875,'Nukulaelae ',218),
(2876,'Vaitupu ',218),
(2877,'Abim ',219),
(2878,'Adjumani ',219),
(2879,'Agago ',219),
(2880,'Albebtong ',219),
(2881,'Amolatar ',219),
(2882,'Amudat ',219),
(2883,'Amuria ',219),
(2884,'Amuru ',219),
(2885,'Apac ',219),
(2886,'Arua ',219),
(2887,'Budaka ',219),
(2888,'Bududa ',219),
(2889,'Bugiri ',219),
(2890,'Buhweju ',219),
(2891,'Buikwe ',219),
(2892,'Bukedea ',219),
(2893,'Bukomansimbi ',219),
(2894,'Bulambuli ',219),
(2895,'Buliisa ',219),
(2896,'Bundibugyo ',219),
(2897,'Bushenyi ',219),
(2898,'Busia ',219),
(2899,'Butaleja ',219),
(2900,'Butambala ',219),
(2901,'Buvuma ',219),
(2902,'Buyende ',219),
(2903,'Dokolo ',219),
(2904,'Gomba ',219),
(2905,'Gulu ',219),
(2906,'Hoima ',219),
(2907,'Ibanada ',219),
(2908,'Iganga ',219),
(2909,'Isingiro ',219),
(2910,'Jinja ',219),
(2911,'Kaabong ',219),
(2912,'Kabale ',219),
(2913,'Kabarole ',219),
(2914,'Kaberamaido ',219),
(2915,'Kalangala ',219),
(2916,'Kaliro ',219),
(2917,'Kalungu ',219),
(2918,'Kampala ',219),
(2919,'Kamuli ',219),
(2920,'Kamwenge ',219),
(2921,'Kanungu ',219),
(2922,'Kapchorwa ',219),
(2923,'Kasese ',219),
(2924,'Katawi ',219),
(2925,'Kayunga ',219),
(2926,'Kibaale ',219),
(2927,'Kiboga ',219),
(2928,'Kibuku ',219),
(2929,'Kiruhuura ',219),
(2930,'Kiryandongo ',219),
(2931,'Kisoro ',219),
(2932,'Kitgum ',219),
(2933,'Koboko ',219),
(2934,'Kole ',219),
(2935,'Kotido ',219),
(2936,'Kumi ',219),
(2937,'Kween ',219),
(2938,'Kyankwanzi ',219),
(2939,'Kyegegwa ',219),
(2940,'Kyenjojo ',219),
(2941,'Lamwo ',219),
(2942,'Lira ',219),
(2943,'Luuka ',219),
(2944,'Lwengo ',219),
(2945,'Lyantonde ',219),
(2946,'Manafwa ',219),
(2947,'Masaka ',219),
(2948,'Masindi ',219),
(2949,'Mayuge ',219),
(2950,'Mbale ',219),
(2951,'Mbarara ',219),
(2952,'Mitoma ',219),
(2953,'Mityana ',219),
(2954,'Moroto ',219),
(2955,'Moyo ',219),
(2956,'Mpigi ',219),
(2957,'Mubende ',219),
(2958,'Mukono ',219),
(2959,'Nakapiripirit ',219),
(2960,'Nakaseke ',219),
(2961,'Nakasongola ',219),
(2962,'Namayingo ',219),
(2963,'Namutumba ',219),
(2964,'Napak ',219),
(2965,'Nebbi ',219),
(2966,'Ngora ',219),
(2967,'Ntoroko ',219),
(2968,'Ntungamo ',219),
(2969,'Nwoya ',219),
(2970,'Nyadro ',219),
(2971,'Otuke ',219),
(2972,'Oyam ',219),
(2973,'Pader ',219),
(2974,'Pallisa ',219),
(2975,'Rubirizi ',219),
(2976,'Rukungiri ',219),
(2977,'Sembabule ',219),
(2978,'Serere ',219),
(2979,'Sheema ',219),
(2980,'Sironko ',219),
(2981,'Soroti ',219),
(2982,'Tororo ',219),
(2983,'Wakiso ',219),
(2984,'Yumbe ',219),
(2985,'Zombo ',219),
(2986,'Cherkasy ',220),
(2987,'Chernihiv',220),
(2988,'Chernivtsi ',220),
(2989,'Dnipropetrovs k ',220),
(2990,'Donets k ',220),
(2991,'Ivano-Frankivs k ',220),
(2992,'Kharkiv ',220),
(2993,'Kheme nyts kyy ',220),
(2994,'Kherson ',220),
(2995,'Kiev ',220),
(2996,'Kirovohrd ',220),
(2997,'L viv ',220),
(2998,'Luhans k ',220),
(2999,'Mykolayiv ',220),
(3000,'Odessa ',220),
(3001,'Poltava ',220),
(3002,'Rivne ',220),
(3003,'Sumy ',220),
(3004,'Ternopil ',220),
(3005,'Vinnytsya ',220),
(3006,'Volyn ',220),
(3007,'Zakarpattia ',220),
(3008,'Zaporizhzhya ',220),
(3009,'Zhytomyr ',220),
(3010,'Abu Dhabi ',221),
(3011,'Ajman ',221),
(3012,'Dubay ',221),
(3013,'Fujayrah ',221),
(3014,'Ras al Khaymah ',221),
(3015,'Sharjah ',221),
(3016,'Umm al Qaywayn ',221),
(3017,'England ',222),
(3018,'Northern Ireland ',222),
(3019,'Scotland ',222),
(3020,'Wales ',222),
(3021,'Baker Island ',223),
(3022,'Howland Island ',223),
(3023,'Jarvis Island ',223),
(3024,'Johnston Atoll ',223),
(3025,'Kingman Reef ',223),
(3026,'Midway Islands ',223),
(3027,'Navassa Island ',223),
(3028,'Palmyra Atoll ',223),
(3029,'Wake Island ',223),
(3030,'Artigas ',224),
(3031,'Canelones ',224),
(3032,'Cerro Largo ',224),
(3033,'Colonia ',224),
(3034,'Durazno ',224),
(3035,'Florida ',224),
(3036,'Lavalleja ',224),
(3037,'Maldonado ',224),
(3038,'Montevideo ',224),
(3039,'Paysandu ',224),
(3040,'Rio Negro ',224),
(3041,'Rivera ',224),
(3042,'Rocha ',224),
(3043,'Salto ',224),
(3044,'San Jose ',224),
(3045,'Soriano ',224),
(3046,'Tacuarembo ',224),
(3047,'Treinta y Tres ',224),
(3048,'Andijon ',225),
(3049,'Buxoro ',225),
(3050,'Farg ona ',225),
(3051,'Jizzax ',225),
(3052,'Karakalpakstan ',225),
(3053,'Kashkadarya ',225),
(3054,'Namangan ',225),
(3055,'Navoi ',225),
(3056,'Samarkand ',225),
(3057,'Sirdaryo ',225),
(3058,'Surxondaryo ',225),
(3059,'Tashkent ',225),
(3060,'Tashkent City ',225),
(3061,'Xorazm ',225),
(3062,'Malampa ',226),
(3063,'Penama ',226),
(3064,'Sanma ',226),
(3065,'Shefa ',226),
(3066,'Tafea ',226),
(3067,'Torba ',226),
(3068,'Vatican City (Holy See) ',227),
(3069,'Amazonas ',228),
(3070,'Anzoategui ',228),
(3071,'Apure ',228),
(3072,'Aragua ',228),
(3073,'Barinas ',228),
(3074,'Bolivar ',228),
(3075,'Carabobo ',228),
(3076,'Delta Amacuro ',228),
(3077,'Falcon ',228),
(3078,'Guarico ',228),
(3079,'Lara ',228),
(3080,'Merida ',228),
(3081,'Miranda ',228),
(3082,'Monagas ',228),
(3083,'Nueva Esparta ',228),
(3084,'Portuguesa ',228),
(3085,'Sucre ',228),
(3086,'Tachira ',228),
(3087,'Trujillo ',228),
(3088,'Vargas ',228),
(3089,'Yaracuy ',228),
(3090,'Zulia ',228),
(3091,'An Giang ',229),
(3092,'Ba Ria-Vung ',229),
(3093,'Bac Can ',229),
(3094,'Bac Giang ',229),
(3095,'Bac Lieu ',229),
(3096,'Bac Ninh ',229),
(3097,'Ben Tre ',229),
(3098,'Binh Dinh ',229),
(3099,'Binh Doung ',229),
(3100,'Binh Phouc ',229),
(3101,'Binh Thuan ',229),
(3102,'Ca Mau ',229),
(3103,'Can Tho ',229),
(3104,'Cao Bang ',229),
(3105,'Da Nang ',229),
(3106,'Dac Lac ',229),
(3107,'Dac Nong ',229),
(3108,'Dien Bien ',229),
(3109,'Dong Nai ',229),
(3110,'Dong Thap ',229),
(3111,'Gia Lai ',229),
(3112,'Ha Giang ',229),
(3113,'Ha Nam ',229),
(3114,'Ha Tinh ',229),
(3115,'Hai Doung ',229),
(3116,'Haiphong ',229),
(3117,'Hanoi ',229),
(3118,'Hau Ginag ',229),
(3119,'Hoa Binh ',229),
(3120,'Hung Yen ',229),
(3121,'Khanh Hoa ',229),
(3122,'Kien Giang ',229),
(3123,'Kon Tum ',229),
(3124,'Lai Chau ',229),
(3125,'Lam Dong ',229),
(3126,'Lang Son ',229),
(3127,'Lao Cai ',229),
(3128,'Long An ',229),
(3129,'Nam Dinh ',229),
(3130,'Nghe An ',229),
(3131,'Ninh Binh ',229),
(3132,'Ninh Thuan ',229),
(3133,'Phu Tho ',229),
(3134,'Phu Yen ',229),
(3135,'Quang Binh ',229),
(3136,'Quang Nam ',229),
(3137,'Quang Ngai ',229),
(3138,'Quang Ninh ',229),
(3139,'Quang Tri ',229),
(3140,'Soc Trang ',229),
(3141,'Son La ',229),
(3142,'Tay Ninh ',229),
(3143,'Thai Binh ',229),
(3144,'Thai Nguyen ',229),
(3145,'Thanh Hoa ',229),
(3146,'Thua Thien-Hue ',229),
(3147,'Tien Giang ',229),
(3148,'Tra Vinh ',229),
(3149,'Tuyen Quang ',229),
(3150,'Vinh Long ',229),
(3151,'Vinh Phuc ',229),
(3152,'Yen Bai ',229),
(3153,'Virigan Islands ',230),
(3154,'Virgin Islands',231),
(3155,'Alo ',232),
(3156,'Sigave ',232),
(3157,'Uvea ',232),
(3158,'Boujdour ',233),
(3159,'Bued el Dahab ',233),
(3160,'EsSemara ',233),
(3161,'Laayoune ',233),
(3162,'Al Bayda ',234),
(3163,'Al Hudaydah ',234),
(3164,'Al Jawf ',234),
(3165,'Al Mahrah ',234),
(3166,'Al Mahwit ',234),
(3167,'Ataq ',234),
(3168,'Dhamar ',234),
(3169,'Hadramaut ',234),
(3170,'Hajjah ',234),
(3171,'Ibb ',234),
(3172,'Lahij ',234),
(3173,'Ma rib ',234),
(3174,'Sa dah ',234),
(3175,'San a ',234),
(3176,'Ta izz ',234),
(3177,'Croatia ',235),
(3178,'Kosovo ',235),
(3179,'Macedonia ',235),
(3180,'Montenegro ',235),
(3181,'Serbia ',235),
(3182,'Slovenia ',235),
(3183,'Central ',236),
(3184,'Copperbelt ',236),
(3185,'Eastern ',236),
(3186,'Luapula ',236),
(3187,'Lusaka ',236),
(3188,'North-Western ',236),
(3189,'Northern ',236),
(3190,'Southern ',236),
(3191,'Western ',236),
(3192,'Bulawayo ',237),
(3193,'Harare ',237),
(3194,'Manicaland ',237),
(3195,'Mashonaland Central ',237),
(3196,'Mashonaland East ',237),
(3197,'Mashonaland West ',237),
(3198,'Masvingo ',237),
(3199,'Matabeleland North ',237),
(3200,'Matabeleland South ',237),
(3201,'Midlands ',237);
Annamalai Thangaraj

Annamalai is working as Technical Lead in Leading Telecom company with 5+ years experience in Identity and Access Management , Telecom and Networks, BigData, Java, Spring, Struts, Hibernate, AngularJS, and Enterprise Web Application Development.

Website: Java Tutorials Corner

Shop and help us

Flipkart Offer Snapdeal offer Amazon.in offer Amazon.com offer
  • Blogger Comments
  • Facebook Comments
  • Disqus Comments

0 comments:

Post a Comment

Item Reviewed: SQL Query for All State list for 237 Countries Rating: 5 Reviewed By: Annamalai Thangaraj