INSERT INTO lookup_countries 
(id, code_alpha2, name, code_num, status)
VALUES 
(1,'AF','Afghanistan',93,'active'),
(3,'AL','Albania',355,'active'),
(4,'DZ','Algeria',213,'active'),
(6,'AD','Andorra',376,'active'),
(7,'AO','Angola',244,'active'),
(10,'AG','Antigua And Barbuda',-267,'active'),
(11,'AR','Argentina',54,'active'),
(12,'AM','Armenia',374,'active'),
(14,'AU','Australia',61,'active'),
(15,'AT','Austria',43,'active'),
(16,'AZ','Azerbaijan',994,'active'),
(17,'BS','The Bahamas',-241,'active'),
(18,'BH','Bahrain',973,'active'),
(19,'BD','Bangladesh',880,'active'),
(20,'BB','Barbados',-245,'active'),
(21,'BY','Belarus',375,'active'),
(22,'BE','Belgium',32,'active'),
(23,'BZ','Belize',501,'active'),
(24,'BJ','Benin',229,'active'),
(26,'BT','Bhutan',975,'active'),
(27,'BO','Bolivia',591,'active'),
(28,'BA','Bosnia and Herzegovina',387,'active'),
(29,'BW','Botswana',267,'active'),
(31,'BR','Brazil',55,'active'),
(33,'BN','Brunei',673,'active'),
(34,'BG','Bulgaria',359,'active'),
(35,'BF','Burkina Faso',226,'active'),
(36,'BI','Burundi',257,'active'),
(37,'KH','Cambodia',855,'active'),
(38,'CM','Cameroon',237,'active'),
(39,'CA','Canada',1,'active'),
(40,'CV','Cape Verde',238,'active'),
(42,'CF','Central African Republic',236,'active'),
(43,'TD','Chad',235,'active'),
(44,'CL','Chile',56,'active'),
(45,'CN','China',86,'active'),
(48,'CO','Colombia',57,'active'),
(49,'KM','Comoros',269,'active'),
(50,'CG','Congo',242,'active'),
(51,'CD','Democratic Republic of the Congo',243,'active'),
(53,'CR','Costa Rica',506,'active'),
(54,'CI','Cote D\'Ivoire (Ivory Coast)',225,'active'),
(55,'HR','Croatia',385,'active'),
(56,'CU','Cuba',53,'active'),
(57,'CY','Cyprus',357,'active'),
(58,'CZ','Czech Republic',420,'active'),
(59,'DK','Denmark',45,'active'),
(60,'DJ','Djibouti',253,'active'),
(61,'DM','Dominica',-766,'active'),
(62,'DO','Dominican Republic',1,'active'),
(63,'TL','East Timor',670,'active'),
(64,'EC','Ecuador',593,'active'),
(65,'EG','Egypt',20,'active'),
(66,'SV','El Salvador',503,'active'),
(67,'GQ','Equatorial Guinea',240,'active'),
(68,'ER','Eritrea',291,'active'),
(69,'EE','Estonia',372,'active'),
(70,'ET','Ethiopia',251,'active'),
(73,'FJ','Fiji Islands',679,'active'),
(74,'FI','Finland',358,'active'),
(75,'FR','France',33,'active'),
(79,'GA','Gabon',241,'active'),
(80,'GM','Gambia The',220,'active'),
(81,'GE','Georgia',995,'active'),
(82,'DE','Germany',49,'active'),
(83,'GH','Ghana',233,'active'),
(85,'GR','Greece',30,'active'),
(87,'GD','Grenada',-472,'active'),
(90,'GT','Guatemala',502,'active'),
(92,'GN','Guinea',224,'active'),
(93,'GW','Guinea-Bissau',245,'active'),
(94,'GY','Guyana',592,'active'),
(95,'HT','Haiti',509,'active'),
(97,'HN','Honduras',504,'active'),
(99,'HU','Hungary',36,'active'),
(100,'IS','Iceland',354,'active'),
(101,'IN','India',91,'active'),
(102,'ID','Indonesia',62,'active'),
(103,'IR','Iran',98,'active'),
(104,'IQ','Iraq',964,'active'),
(105,'IE','Ireland',353,'active'),
(106,'IL','Israel',972,'active'),
(107,'IT','Italy',39,'active'),
(108,'JM','Jamaica',-875,'active'),
(109,'JP','Japan',81,'active'),
(111,'JO','Jordan',962,'active'),
(112,'KZ','Kazakhstan',7,'active'),
(113,'KE','Kenya',254,'active'),
(114,'KI','Kiribati',686,'active'),
(115,'KP','North Korea',850,'active'),
(116,'KR','South Korea',82,'active'),
(117,'KW','Kuwait',965,'active'),
(118,'KG','Kyrgyzstan',996,'active'),
(119,'LA','Laos',856,'active'),
(120,'LV','Latvia',371,'active'),
(121,'LB','Lebanon',961,'active'),
(122,'LS','Lesotho',266,'active'),
(123,'LR','Liberia',231,'active'),
(124,'LY','Libya',218,'active'),
(125,'LI','Liechtenstein',423,'active'),
(126,'LT','Lithuania',370,'active'),
(127,'LU','Luxembourg',352,'active'),
(129,'MK','Macedonia',389,'active'),
(130,'MG','Madagascar',261,'active'),
(131,'MW','Malawi',265,'active'),
(132,'MY','Malaysia',60,'active'),
(133,'MV','Maldives',960,'active'),
(134,'ML','Mali',223,'active'),
(135,'MT','Malta',356,'active'),
(139,'MR','Mauritania',222,'active'),
(140,'MU','Mauritius',230,'active'),
(142,'MX','Mexico',52,'active'),
(143,'FM','Micronesia',691,'active'),
(144,'MD','Moldova',373,'active'),
(146,'MN','Mongolia',976,'active'),
(147,'ME','Montenegro',382,'active'),
(149,'MA','Morocco',212,'active'),
(150,'MZ','Mozambique',258,'active'),
(151,'MM','Myanmar',95,'active'),
(152,'NA','Namibia',264,'active'),
(153,'NR','Nauru',674,'active'),
(154,'NP','Nepal',977,'active'),
(155,'BQ','Bonaire, Sint Eustatius and Saba',599,'active'),
(156,'NL','Netherlands',31,'active'),
(158,'NZ','New Zealand',64,'active'),
(159,'NI','Nicaragua',505,'active'),
(160,'NE','Niger',227,'active'),
(161,'NG','Nigeria',234,'active'),
(165,'NO','Norway',47,'active'),
(166,'OM','Oman',968,'active'),
(167,'PK','Pakistan',92,'active'),
(168,'PW','Palau',680,'active'),
(170,'PA','Panama',507,'active'),
(171,'PG','Papua new Guinea',675,'active'),
(172,'PY','Paraguay',595,'active'),
(173,'PE','Peru',51,'active'),
(174,'PH','Philippines',63,'active'),
(176,'PL','Poland',48,'active'),
(177,'PT','Portugal',351,'active'),
(179,'QA','Qatar',974,'active'),
(181,'RO','Romania',40,'active'),
(182,'RU','Russia',7,'active'),
(183,'RW','Rwanda',250,'active'),
(185,'KN','Saint Kitts And Nevis',-868,'active'),
(186,'LC','Saint Lucia',-757,'active'),
(188,'VC','Saint Vincent And The Grenadines',-783,'active'),
(191,'WS','Samoa',685,'active'),
(192,'SM','San Marino',378,'active'),
(193,'ST','Sao Tome and Principe',239,'active'),
(194,'SA','Saudi Arabia',966,'active'),
(195,'SN','Senegal',221,'active'),
(196,'RS','Serbia',381,'active'),
(197,'SC','Seychelles',248,'active'),
(198,'SL','Sierra Leone',232,'active'),
(199,'SG','Singapore',65,'active'),
(200,'SK','Slovakia',421,'active'),
(201,'SI','Slovenia',386,'active'),
(202,'SB','Solomon Islands',677,'active'),
(203,'SO','Somalia',252,'active'),
(204,'ZA','South Africa',27,'active'),
(206,'SS','South Sudan',211,'active'),
(207,'ES','Spain',34,'active'),
(208,'LK','Sri Lanka',94,'active'),
(209,'SD','Sudan',249,'active'),
(210,'SR','Suriname',597,'active'),
(212,'SZ','Swaziland',268,'active'),
(213,'SE','Sweden',46,'active'),
(214,'CH','Switzerland',41,'active'),
(215,'SY','Syria',963,'active'),
(216,'TW','Taiwan',886,'active'),
(217,'TJ','Tajikistan',992,'active'),
(218,'TZ','Tanzania',255,'active'),
(219,'TH','Thailand',66,'active'),
(220,'TG','Togo',228,'active'),
(222,'TO','Tonga',676,'active'),
(223,'TT','Trinidad And Tobago',-867,'active'),
(224,'TN','Tunisia',216,'active'),
(225,'TR','Turkey',90,'active'),
(226,'TM','Turkmenistan',993,'active'),
(228,'TV','Tuvalu',688,'active'),
(229,'UG','Uganda',256,'active'),
(230,'UA','Ukraine',380,'active'),
(231,'AE','United Arab Emirates',971,'active'),
(232,'GB','United Kingdom',44,'active'),
(233,'US','United States',1,'active'),
(235,'UY','Uruguay',598,'active'),
(236,'UZ','Uzbekistan',998,'active'),
(237,'VU','Vanuatu',678,'active'),
(239,'VE','Venezuela',58,'active'),
(240,'VN','Vietnam',84,'active'),
(242,'VI','Virgin Islands (US)',-339,'active'),
(245,'YE','Yemen',967,'active'),
(246,'ZM','Zambia',260,'active'),
(247,'ZW','Zimbabwe',263,'active');
