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