MySQL tables with country names, continent names and ISO-3166 codes.

MySQL-countries-continents-ISO-3166-codes

/**
  * Country names, continent names and ISO-3166 codes.
  */
  
CREATE TABLE lookup_continents (
  code_continent ENUM('AF','AN','AS','EU','NA','OC','SA') NOT NULL,		    /* Continent code */
  name_continent VARCHAR(255),
  PRIMARY KEY (code_continent) 
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO lookup_continents VALUES ('AF', 'Africa');
INSERT INTO lookup_continents VALUES ('AS', 'Asia');
INSERT INTO lookup_continents VALUES ('EU', 'Europe');
INSERT INTO lookup_continents VALUES ('NA', 'North America');
INSERT INTO lookup_continents VALUES ('SA', 'South America');
INSERT INTO lookup_continents VALUES ('OC', 'Oceania');
INSERT INTO lookup_continents VALUES ('AN', 'Antarctica');

/* Create Countries table */
CREATE TABLE lookup_countries (
  code_country CHAR(2) NOT NULL, 			/* Two-letter country code (ISO 3166-1 alpha-2) */
  name_country VARCHAR(255) NOT NULL, 		/* English country name */
  namelong_country VARCHAR(255) NOT NULL, 	/* Full English country name */
  code_iso3 CHAR(3) NOT NULL, 				/* Three-letter country code (ISO 3166-1 alpha-3) */
  num_country SMALLINT(3) NOT NULL, 			/* Three-digit country number (ISO 3166-1 numeric) */
  code_continent ENUM('AF','AN','AS','EU','NA','OC','SA') NOT NULL,
  PRIMARY KEY (code_country), 
  FOREIGN KEY fk_code_continent(code_continent)
  REFERENCES lookup_continents(code_continent)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AF', 'AS', 'Afghanistan', 'AFG', '004', 'Islamic Republic of Afghanistan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AX', 'EU', 'Åland Islands', 'ALA', '248', 'Åland Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AL', 'EU', 'Albania', 'ALB', '008', 'Republic of Albania');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('DZ', 'AF', 'Algeria', 'DZA', '012', 'People''s Democratic Republic of Algeria');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AS', 'OC', 'American Samoa', 'ASM', '016', 'American Samoa');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AD', 'EU', 'Andorra', 'AND', '020', 'Principality of Andorra');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AO', 'AF', 'Angola', 'AGO', '024', 'Republic of Angola');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AI', 'NA', 'Anguilla', 'AIA', '660', 'Anguilla');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AQ', 'AN', 'Antarctica', 'ATA', '010', 'Antarctica (the territory South of 60 deg S)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AG', 'NA', 'Antigua and Barbuda', 'ATG', '028', 'Antigua and Barbuda');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AR', 'SA', 'Argentina', 'ARG', '032', 'Argentine Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AM', 'AS', 'Armenia', 'ARM', '051', 'Republic of Armenia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AW', 'NA', 'Aruba', 'ABW', '533', 'Aruba');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AU', 'OC', 'Australia', 'AUS', '036', 'Commonwealth of Australia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AT', 'EU', 'Austria', 'AUT', '040', 'Republic of Austria');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AZ', 'AS', 'Azerbaijan', 'AZE', '031', 'Republic of Azerbaijan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BS', 'NA', 'Bahamas', 'BHS', '044', 'Commonwealth of the Bahamas');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BH', 'AS', 'Bahrain', 'BHR', '048', 'Kingdom of Bahrain');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BD', 'AS', 'Bangladesh', 'BGD', '050', 'People''s Republic of Bangladesh');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BB', 'NA', 'Barbados', 'BRB', '052', 'Barbados');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BY', 'EU', 'Belarus', 'BLR', '112', 'Republic of Belarus');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BE', 'EU', 'Belgium', 'BEL', '056', 'Kingdom of Belgium');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BZ', 'NA', 'Belize', 'BLZ', '084', 'Belize');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BJ', 'AF', 'Benin', 'BEN', '204', 'Republic of Benin');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BM', 'NA', 'Bermuda', 'BMU', '060', 'Bermuda');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BT', 'AS', 'Bhutan', 'BTN', '064', 'Kingdom of Bhutan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BO', 'SA', 'Bolivia', 'BOL', '068', 'Plurinational State of Bolivia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BQ', 'NA', 'Bonaire, Sint Eustatius and Saba', 'BES', '535', 'Bonaire, Sint Eustatius and Saba');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BA', 'EU', 'Bosnia and Herzegovina', 'BIH', '070', 'Bosnia and Herzegovina');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BW', 'AF', 'Botswana', 'BWA', '072', 'Republic of Botswana');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BV', 'AN', 'Bouvet Island (Bouvetoya)', 'BVT', '074', 'Bouvet Island (Bouvetoya)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BR', 'SA', 'Brazil', 'BRA', '076', 'Federative Republic of Brazil');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IO', 'AS', 'British Indian Ocean Territory (Chagos Archipelago)', 'IOT', '086', 'British Indian Ocean Territory (Chagos Archipelago)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VG', 'NA', 'British Virgin Islands', 'VGB', '092', 'British Virgin Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BN', 'AS', 'Brunei Darussalam', 'BRN', '096', 'Brunei Darussalam');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BG', 'EU', 'Bulgaria', 'BGR', '100', 'Republic of Bulgaria');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BF', 'AF', 'Burkina Faso', 'BFA', '854', 'Burkina Faso');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BI', 'AF', 'Burundi', 'BDI', '108', 'Republic of Burundi');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KH', 'AS', 'Cambodia', 'KHM', '116', 'Kingdom of Cambodia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CM', 'AF', 'Cameroon', 'CMR', '120', 'Republic of Cameroon');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CA', 'NA', 'Canada', 'CAN', '124', 'Canada');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CV', 'AF', 'Cape Verde', 'CPV', '132', 'Republic of Cape Verde');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KY', 'NA', 'Cayman Islands', 'CYM', '136', 'Cayman Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CF', 'AF', 'Central African Republic', 'CAF', '140', 'Central African Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TD', 'AF', 'Chad', 'TCD', '148', 'Republic of Chad');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CL', 'SA', 'Chile', 'CHL', '152', 'Republic of Chile');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CN', 'AS', 'China', 'CHN', '156', 'People''s Republic of China');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CX', 'AS', 'Christmas Island', 'CXR', '162', 'Christmas Island');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CC', 'AS', 'Cocos (Keeling) Islands', 'CCK', '166', 'Cocos (Keeling) Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CO', 'SA', 'Colombia', 'COL', '170', 'Republic of Colombia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KM', 'AF', 'Comoros', 'COM', '174', 'Union of the Comoros');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CD', 'AF', 'Congo', 'COD', '180', 'Democratic Republic of the Congo');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CG', 'AF', 'Congo', 'COG', '178', 'Republic of the Congo');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CK', 'OC', 'Cook Islands', 'COK', '184', 'Cook Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CR', 'NA', 'Costa Rica', 'CRI', '188', 'Republic of Costa Rica');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CI', 'AF', 'Cote d''Ivoire', 'CIV', '384', 'Republic of Cote d''Ivoire');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('HR', 'EU', 'Croatia', 'HRV', '191', 'Republic of Croatia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CU', 'NA', 'Cuba', 'CUB', '192', 'Republic of Cuba');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CW', 'NA', 'Curaçao', 'CUW', '531', 'Curaçao');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CY', 'AS', 'Cyprus', 'CYP', '196', 'Republic of Cyprus');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CZ', 'EU', 'Czech Republic', 'CZE', '203', 'Czech Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('DK', 'EU', 'Denmark', 'DNK', '208', 'Kingdom of Denmark');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('DJ', 'AF', 'Djibouti', 'DJI', '262', 'Republic of Djibouti');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('DM', 'NA', 'Dominica', 'DMA', '212', 'Commonwealth of Dominica');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('DO', 'NA', 'Dominican Republic', 'DOM', '214', 'Dominican Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('EC', 'SA', 'Ecuador', 'ECU', '218', 'Republic of Ecuador');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('EG', 'AF', 'Egypt', 'EGY', '818', 'Arab Republic of Egypt');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SV', 'NA', 'El Salvador', 'SLV', '222', 'Republic of El Salvador');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GQ', 'AF', 'Equatorial Guinea', 'GNQ', '226', 'Republic of Equatorial Guinea');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ER', 'AF', 'Eritrea', 'ERI', '232', 'State of Eritrea');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('EE', 'EU', 'Estonia', 'EST', '233', 'Republic of Estonia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ET', 'AF', 'Ethiopia', 'ETH', '231', 'Federal Democratic Republic of Ethiopia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('FO', 'EU', 'Faroe Islands', 'FRO', '234', 'Faroe Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('FK', 'SA', 'Falkland Islands (Malvinas)', 'FLK', '238', 'Falkland Islands (Malvinas)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('FJ', 'OC', 'Fiji', 'FJI', '242', 'Republic of Fiji');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('FI', 'EU', 'Finland', 'FIN', '246', 'Republic of Finland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('FR', 'EU', 'France', 'FRA', '250', 'French Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GF', 'SA', 'French Guiana', 'GUF', '254', 'French Guiana');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PF', 'OC', 'French Polynesia', 'PYF', '258', 'French Polynesia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TF', 'AN', 'French Southern Territories', 'ATF', '260', 'French Southern Territories');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GA', 'AF', 'Gabon', 'GAB', '266', 'Gabonese Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GM', 'AF', 'Gambia', 'GMB', '270', 'Republic of the Gambia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GE', 'AS', 'Georgia', 'GEO', '268', 'Georgia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('DE', 'EU', 'Germany', 'DEU', '276', 'Federal Republic of Germany');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GH', 'AF', 'Ghana', 'GHA', '288', 'Republic of Ghana');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GI', 'EU', 'Gibraltar', 'GIB', '292', 'Gibraltar');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GR', 'EU', 'Greece', 'GRC', '300', 'Hellenic Republic Greece');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GL', 'NA', 'Greenland', 'GRL', '304', 'Greenland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GD', 'NA', 'Grenada', 'GRD', '308', 'Grenada');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GP', 'NA', 'Guadeloupe', 'GLP', '312', 'Guadeloupe');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GU', 'OC', 'Guam', 'GUM', '316', 'Guam');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GT', 'NA', 'Guatemala', 'GTM', '320', 'Republic of Guatemala');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GG', 'EU', 'Guernsey', 'GGY', '831', 'Bailiwick of Guernsey');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GN', 'AF', 'Guinea', 'GIN', '324', 'Republic of Guinea');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GW', 'AF', 'Guinea-Bissau', 'GNB', '624', 'Republic of Guinea-Bissau');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GY', 'SA', 'Guyana', 'GUY', '328', 'Co-operative Republic of Guyana');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('HT', 'NA', 'Haiti', 'HTI', '332', 'Republic of Haiti');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('HM', 'AN', 'Heard Island and McDonald Islands', 'HMD', '334', 'Heard Island and McDonald Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VA', 'EU', 'Holy See (Vatican City State)', 'VAT', '336', 'Holy See (Vatican City State)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('HN', 'NA', 'Honduras', 'HND', '340', 'Republic of Honduras');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('HK', 'AS', 'Hong Kong', 'HKG', '344', 'Hong Kong Special Administrative Region of China');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('HU', 'EU', 'Hungary', 'HUN', '348', 'Hungary');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IS', 'EU', 'Iceland', 'ISL', '352', 'Republic of Iceland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IN', 'AS', 'India', 'IND', '356', 'Republic of India');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ID', 'AS', 'Indonesia', 'IDN', '360', 'Republic of Indonesia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IR', 'AS', 'Iran', 'IRN', '364', 'Islamic Republic of Iran');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IQ', 'AS', 'Iraq', 'IRQ', '368', 'Republic of Iraq');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IE', 'EU', 'Ireland', 'IRL', '372', 'Ireland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IM', 'EU', 'Isle of Man', 'IMN', '833', 'Isle of Man');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IL', 'AS', 'Israel', 'ISR', '376', 'State of Israel');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('IT', 'EU', 'Italy', 'ITA', '380', 'Italian Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('JM', 'NA', 'Jamaica', 'JAM', '388', 'Jamaica');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('JP', 'AS', 'Japan', 'JPN', '392', 'Japan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('JE', 'EU', 'Jersey', 'JEY', '832', 'Bailiwick of Jersey');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('JO', 'AS', 'Jordan', 'JOR', '400', 'Hashemite Kingdom of Jordan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KZ', 'AS', 'Kazakhstan', 'KAZ', '398', 'Republic of Kazakhstan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KE', 'AF', 'Kenya', 'KEN', '404', 'Republic of Kenya');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KI', 'OC', 'Kiribati', 'KIR', '296', 'Republic of Kiribati');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KP', 'AS', 'Korea', 'PRK', '408', 'Democratic People''s Republic of Korea');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KR', 'AS', 'Korea', 'KOR', '410', 'Republic of Korea');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KW', 'AS', 'Kuwait', 'KWT', '414', 'State of Kuwait');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KG', 'AS', 'Kyrgyz Republic', 'KGZ', '417', 'Kyrgyz Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LA', 'AS', 'Lao People''s Democratic Republic', 'LAO', '418', 'Lao People''s Democratic Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LV', 'EU', 'Latvia', 'LVA', '428', 'Republic of Latvia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LB', 'AS', 'Lebanon', 'LBN', '422', 'Lebanese Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LS', 'AF', 'Lesotho', 'LSO', '426', 'Kingdom of Lesotho');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LR', 'AF', 'Liberia', 'LBR', '430', 'Republic of Liberia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LY', 'AF', 'Libya', 'LBY', '434', 'Libya');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LI', 'EU', 'Liechtenstein', 'LIE', '438', 'Principality of Liechtenstein');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LT', 'EU', 'Lithuania', 'LTU', '440', 'Republic of Lithuania');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LU', 'EU', 'Luxembourg', 'LUX', '442', 'Grand Duchy of Luxembourg');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MO', 'AS', 'Macao', 'MAC', '446', 'Macao Special Administrative Region of China');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MK', 'EU', 'Macedonia', 'MKD', '807', 'Republic of Macedonia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MG', 'AF', 'Madagascar', 'MDG', '450', 'Republic of Madagascar');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MW', 'AF', 'Malawi', 'MWI', '454', 'Republic of Malawi');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MY', 'AS', 'Malaysia', 'MYS', '458', 'Malaysia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MV', 'AS', 'Maldives', 'MDV', '462', 'Republic of Maldives');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ML', 'AF', 'Mali', 'MLI', '466', 'Republic of Mali');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MT', 'EU', 'Malta', 'MLT', '470', 'Republic of Malta');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MH', 'OC', 'Marshall Islands', 'MHL', '584', 'Republic of the Marshall Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MQ', 'NA', 'Martinique', 'MTQ', '474', 'Martinique');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MR', 'AF', 'Mauritania', 'MRT', '478', 'Islamic Republic of Mauritania');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MU', 'AF', 'Mauritius', 'MUS', '480', 'Republic of Mauritius');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('YT', 'AF', 'Mayotte', 'MYT', '175', 'Mayotte');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MX', 'NA', 'Mexico', 'MEX', '484', 'United Mexican States');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('FM', 'OC', 'Micronesia', 'FSM', '583', 'Federated States of Micronesia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MD', 'EU', 'Moldova', 'MDA', '498', 'Republic of Moldova');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MC', 'EU', 'Monaco', 'MCO', '492', 'Principality of Monaco');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MN', 'AS', 'Mongolia', 'MNG', '496', 'Mongolia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ME', 'EU', 'Montenegro', 'MNE', '499', 'Montenegro');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MS', 'NA', 'Montserrat', 'MSR', '500', 'Montserrat');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MA', 'AF', 'Morocco', 'MAR', '504', 'Kingdom of Morocco');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MZ', 'AF', 'Mozambique', 'MOZ', '508', 'Republic of Mozambique');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MM', 'AS', 'Myanmar', 'MMR', '104', 'Republic of the Union of Myanmar');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NA', 'AF', 'Namibia', 'NAM', '516', 'Republic of Namibia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NR', 'OC', 'Nauru', 'NRU', '520', 'Republic of Nauru');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NP', 'AS', 'Nepal', 'NPL', '524', 'Federal Democratic Republic of Nepal');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NL', 'EU', 'Netherlands', 'NLD', '528', 'Kingdom of the Netherlands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NC', 'OC', 'New Caledonia', 'NCL', '540', 'New Caledonia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NZ', 'OC', 'New Zealand', 'NZL', '554', 'New Zealand');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NI', 'NA', 'Nicaragua', 'NIC', '558', 'Republic of Nicaragua');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NE', 'AF', 'Niger', 'NER', '562', 'Republic of Niger');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NG', 'AF', 'Nigeria', 'NGA', '566', 'Federal Republic of Nigeria');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NU', 'OC', 'Niue', 'NIU', '570', 'Niue');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NF', 'OC', 'Norfolk Island', 'NFK', '574', 'Norfolk Island');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MP', 'OC', 'Northern Mariana Islands', 'MNP', '580', 'Commonwealth of the Northern Mariana Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('NO', 'EU', 'Norway', 'NOR', '578', 'Kingdom of Norway');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('OM', 'AS', 'Oman', 'OMN', '512', 'Sultanate of Oman');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PK', 'AS', 'Pakistan', 'PAK', '586', 'Islamic Republic of Pakistan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PW', 'OC', 'Palau', 'PLW', '585', 'Republic of Palau');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PS', 'AS', 'Palestine', 'PSE', '275', 'State of Palestine');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PA', 'NA', 'Panama', 'PAN', '591', 'Republic of Panama');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PG', 'OC', 'Papua New Guinea', 'PNG', '598', 'Independent State of Papua New Guinea');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PY', 'SA', 'Paraguay', 'PRY', '600', 'Republic of Paraguay');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PE', 'SA', 'Peru', 'PER', '604', 'Republic of Peru');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PH', 'AS', 'Philippines', 'PHL', '608', 'Republic of the Philippines');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PN', 'OC', 'Pitcairn Islands', 'PCN', '612', 'Pitcairn Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PL', 'EU', 'Poland', 'POL', '616', 'Republic of Poland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PT', 'EU', 'Portugal', 'PRT', '620', 'Portuguese Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PR', 'NA', 'Puerto Rico', 'PRI', '630', 'Commonwealth of Puerto Rico');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('QA', 'AS', 'Qatar', 'QAT', '634', 'State of Qatar');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('RE', 'AF', 'Réunion', 'REU', '638', 'Réunion');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('RO', 'EU', 'Romania', 'ROU', '642', 'Romania');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('RU', 'EU', 'Russian Federation', 'RUS', '643', 'Russian Federation');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('RW', 'AF', 'Rwanda', 'RWA', '646', 'Republic of Rwanda');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('BL', 'NA', 'Saint Barthélemy', 'BLM', '652', 'Saint Barthélemy');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SH', 'AF', 'Saint Helena, Ascension and Tristan da Cunha', 'SHN', '654', 'Saint Helena, Ascension and Tristan da Cunha');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('KN', 'NA', 'Saint Kitts and Nevis', 'KNA', '659', 'Federation of Saint Kitts and Nevis');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LC', 'NA', 'Saint Lucia', 'LCA', '662', 'Saint Lucia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('MF', 'NA', 'Saint Martin', 'MAF', '663', 'Saint Martin (French part)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('PM', 'NA', 'Saint Pierre and Miquelon', 'SPM', '666', 'Saint Pierre and Miquelon');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VC', 'NA', 'Saint Vincent and the Grenadines', 'VCT', '670', 'Saint Vincent and the Grenadines');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('WS', 'OC', 'Samoa', 'WSM', '882', 'Independent State of Samoa');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SM', 'EU', 'San Marino', 'SMR', '674', 'Republic of San Marino');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ST', 'AF', 'Sao Tome and Principe', 'STP', '678', 'Democratic Republic of Sao Tome and Principe');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SA', 'AS', 'Saudi Arabia', 'SAU', '682', 'Kingdom of Saudi Arabia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SN', 'AF', 'Senegal', 'SEN', '686', 'Republic of Senegal');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('RS', 'EU', 'Serbia', 'SRB', '688', 'Republic of Serbia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SC', 'AF', 'Seychelles', 'SYC', '690', 'Republic of Seychelles');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SL', 'AF', 'Sierra Leone', 'SLE', '694', 'Republic of Sierra Leone');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SG', 'AS', 'Singapore', 'SGP', '702', 'Republic of Singapore');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SX', 'NA', 'Sint Maarten (Dutch part)', 'SXM', '534', 'Sint Maarten (Dutch part)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SK', 'EU', 'Slovakia (Slovak Republic)', 'SVK', '703', 'Slovakia (Slovak Republic)');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SI', 'EU', 'Slovenia', 'SVN', '705', 'Republic of Slovenia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SB', 'OC', 'Solomon Islands', 'SLB', '090', 'Solomon Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SO', 'AF', 'Somalia', 'SOM', '706', 'Federal Republic of Somalia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ZA', 'AF', 'South Africa', 'ZAF', '710', 'Republic of South Africa');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GS', 'AN', 'South Georgia and the South Sandwich Islands', 'SGS', '239', 'South Georgia and the South Sandwich Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SS', 'AF', 'South Sudan', 'SSD', '728', 'Republic of South Sudan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ES', 'EU', 'Spain', 'ESP', '724', 'Kingdom of Spain');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('LK', 'AS', 'Sri Lanka', 'LKA', '144', 'Democratic Socialist Republic of Sri Lanka');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SD', 'AF', 'Sudan', 'SDN', '729', 'Republic of Sudan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SR', 'SA', 'Suriname', 'SUR', '740', 'Republic of Suriname');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SJ', 'EU', 'Svalbard & Jan Mayen Islands', 'SJM', '744', 'Svalbard & Jan Mayen Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SZ', 'AF', 'Swaziland', 'SWZ', '748', 'Kingdom of Swaziland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SE', 'EU', 'Sweden', 'SWE', '752', 'Kingdom of Sweden');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('CH', 'EU', 'Switzerland', 'CHE', '756', 'Swiss Confederation');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('SY', 'AS', 'Syrian Arab Republic', 'SYR', '760', 'Syrian Arab Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TW', 'AS', 'Taiwan', 'TWN', '158', 'Taiwan, Province of China');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TJ', 'AS', 'Tajikistan', 'TJK', '762', 'Republic of Tajikistan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TZ', 'AF', 'Tanzania', 'TZA', '834', 'United Republic of Tanzania');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TH', 'AS', 'Thailand', 'THA', '764', 'Kingdom of Thailand');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TL', 'AS', 'Timor-Leste', 'TLS', '626', 'Democratic Republic of Timor-Leste');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TG', 'AF', 'Togo', 'TGO', '768', 'Togolese Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TK', 'OC', 'Tokelau', 'TKL', '772', 'Tokelau');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TO', 'OC', 'Tonga', 'TON', '776', 'Kingdom of Tonga');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TT', 'NA', 'Trinidad and Tobago', 'TTO', '780', 'Republic of Trinidad and Tobago');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TN', 'AF', 'Tunisia', 'TUN', '788', 'Tunisian Republic');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TR', 'AS', 'Turkey', 'TUR', '792', 'Republic of Turkey');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TM', 'AS', 'Turkmenistan', 'TKM', '795', 'Turkmenistan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TC', 'NA', 'Turks and Caicos Islands', 'TCA', '796', 'Turks and Caicos Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('TV', 'OC', 'Tuvalu', 'TUV', '798', 'Tuvalu');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('UG', 'AF', 'Uganda', 'UGA', '800', 'Republic of Uganda');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('UA', 'EU', 'Ukraine', 'UKR', '804', 'Ukraine');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('AE', 'AS', 'United Arab Emirates', 'ARE', '784', 'United Arab Emirates');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('GB', 'EU', 'United Kingdom of Great Britain & Northern Ireland', 'GBR', '826', 'United Kingdom of Great Britain & Northern Ireland');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('US', 'NA', 'United States of America', 'USA', '840', 'United States of America');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('UM', 'OC', 'United States Minor Outlying Islands', 'UMI', '581', 'United States Minor Outlying Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VI', 'NA', 'United States Virgin Islands', 'VIR', '850', 'United States Virgin Islands');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('UY', 'SA', 'Uruguay', 'URY', '858', 'Eastern Republic of Uruguay');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('UZ', 'AS', 'Uzbekistan', 'UZB', '860', 'Republic of Uzbekistan');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VU', 'OC', 'Vanuatu', 'VUT', '548', 'Republic of Vanuatu');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VE', 'SA', 'Venezuela', 'VEN', '862', 'Bolivarian Republic of Venezuela');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('VN', 'AS', 'Vietnam', 'VNM', '704', 'Socialist Republic of Vietnam');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('WF', 'OC', 'Wallis and Futuna', 'WLF', '876', 'Wallis and Futuna');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('EH', 'AF', 'Western Sahara', 'ESH', '732', 'Western Sahara');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('YE', 'AS', 'Yemen', 'YEM', '887', 'Yemen');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ZM', 'AF', 'Zambia', 'ZMB', '894', 'Republic of Zambia');
 INSERT INTO lookup_countries (code_country, code_continent, name_country, code_iso3, num_country, namelong_country) VALUES ('ZW', 'AF', 'Zimbabwe', 'ZWE', '716', 'Republic of Zimbabwe');