INSERT INTO Country VALUES ('US','N','UNITED STATES',1);
INSERT INTO Country VALUES ('CA','N','CANADA',7);
INSERT INTO Country VALUES ('CH','N','SWITZERLAND',8);
INSERT INTO Country VALUES ('IT','N','ITALY',9);
INSERT INTO Country VALUES ('DE','N','GERMANY',11);
INSERT INTO Country VALUES ('AU','N','AUSTRALIA',12);
INSERT INTO Country VALUES ('DK','Y','DENMARK',13);
INSERT INTO Country VALUES ('FI','Y','FINLAND',14);
INSERT INTO Country VALUES ('MX','N','MEXICO',16);
INSERT INTO Country VALUES ('CN','Y','CHINA',17);
INSERT INTO Country VALUES ('JP','N','JAPAN',18);
INSERT INTO Country VALUES ('KW','Y','KUWAIT',19);
INSERT INTO Country VALUES ('MY','N','MALAYSIA',20);
INSERT INTO Country VALUES ('ES','Y','SPAIN',22);
INSERT INTO Country VALUES ('BE','N','BELGIUM',24);
INSERT INTO Country VALUES ('OM','N','OMAN',25);
INSERT INTO Country VALUES ('AE','N','UNITED ARAB EMIRATES',26);
INSERT INTO Country VALUES ('FR','Y','FRANCE',27);
INSERT INTO Country VALUES ('BH','N','BAHRAIN',29);
INSERT INTO Country VALUES ('IE','N','IRELAND',30);
INSERT INTO Country VALUES ('PT','Y','PORTUGAL',33);
INSERT INTO Country VALUES ('AT','Y','AUSTRIA',34);
INSERT INTO Country VALUES ('NO','N','NORWAY',35);
INSERT INTO Country VALUES ('SE','Y','SWEDEN',36);
INSERT INTO Country VALUES ('AR','Y','ARGENTINA',37);
INSERT INTO Country VALUES ('BM','Y','BERMUDA',38);
INSERT INTO Country VALUES ('BR','Y','BRAZIL',40);
INSERT INTO Country VALUES ('HK','N','HONG KONG',41);
INSERT INTO Country VALUES ('PH','N','PHILIPPINES',43);
INSERT INTO Country VALUES ('PR','Y','PUERTO RICO',44);
INSERT INTO Country VALUES ('SA','N','SAUDI ARABIA',45);
INSERT INTO Country VALUES ('SG','Y','SINGAPORE',46);
INSERT INTO Country VALUES ('TH','Y','THAILAND',48);
INSERT INTO Country VALUES ('TR','Y','TURKEY',49);
INSERT INTO Country VALUES ('CL','Y','CHILE',50);
INSERT INTO Country VALUES ('ID','N','INDONESIA',51);
INSERT INTO Country VALUES ('GR','Y','GREECE',52);
INSERT INTO Country VALUES ('PK','Y','PAKISTAN',53);
INSERT INTO Country VALUES ('PA','Y','PANAMA',54);
INSERT INTO Country VALUES ('BO','Y','BOLIVIA',55);
INSERT INTO Country VALUES ('LU','Y','LUXEMBOURG',58);
INSERT INTO Country VALUES ('BB','Y','BARBADOS',59);
INSERT INTO Country VALUES ('TW','Y','TAIWAN',60);
INSERT INTO Country VALUES ('HT','Y','HAITI',62);
INSERT INTO Country VALUES ('JO','N','JORDAN',63);
INSERT INTO Country VALUES ('WS','Y','SAMOA',64);
INSERT INTO Country VALUES ('CR','Y','COSTA RICA',65);
INSERT INTO Country VALUES ('AW','Y','ARUBA',66);
INSERT INTO Country VALUES ('NL','Y','NETHERLANDS',68);
INSERT INTO Country VALUES ('QA','Y','QATAR',69);
INSERT INTO Country VALUES ('IN','Y','INDIA',71);
INSERT INTO Country VALUES ('EG','Y','EGYPT',72);
INSERT INTO Country VALUES ('GU','Y','GUAM',73);
INSERT INTO Country VALUES ('AF','Y','AFGHANISTAN',74);
INSERT INTO Country VALUES ('AL','Y','ALBANIA',75);
INSERT INTO Country VALUES ('DZ','Y','ALGERIA',76);
INSERT INTO Country VALUES ('AS','Y','AMERICAN SAMOA',77);
INSERT INTO Country VALUES ('AD','Y','ANDORRA',78);
INSERT INTO Country VALUES ('AO','Y','ANGOLA',79);
INSERT INTO Country VALUES ('AI','Y','ANGUILLA',80);
INSERT INTO Country VALUES ('AQ','Y','ANTARCTICA',81);
INSERT INTO Country VALUES ('AG','Y','ANTIGUA AND BARBUDA',82);
INSERT INTO Country VALUES ('AM','Y','ARMENIA',83);
INSERT INTO Country VALUES ('AZ','Y','AZERBAIJAN',84);
INSERT INTO Country VALUES ('BS','Y','BAHAMAS',85);
INSERT INTO Country VALUES ('BD','Y','BANGLADESH',86);
INSERT INTO Country VALUES ('BY','Y','BELARUS',87);
INSERT INTO Country VALUES ('BZ','Y','BELIZE',88);
INSERT INTO Country VALUES ('BJ','Y','BENIN',89);
INSERT INTO Country VALUES ('BT','Y','BHUTAN',90);
INSERT INTO Country VALUES ('BA','Y','BOSNIA AND HERZEGOVINA',91);
INSERT INTO Country VALUES ('BW','Y','BOTSWANA',92);
INSERT INTO Country VALUES ('BV','Y','BOUVET ISLAND',93);
INSERT INTO Country VALUES ('IO','Y','BRITISH INDIAN OCEAN TERRITORY',94);
INSERT INTO Country VALUES ('BN','Y','BRUNEI DARUSSALAM',95);
INSERT INTO Country VALUES ('BG','Y','BULGARIA',96);
INSERT INTO Country VALUES ('BF','Y','BURKINA FASO',97);
INSERT INTO Country VALUES ('BI','Y','BURUNDI',98);
INSERT INTO Country VALUES ('KH','Y','CAMBODIA',99);
INSERT INTO Country VALUES ('CM','Y','CAMEROON',100);
INSERT INTO Country VALUES ('CV','Y','CAPE VERDE',101);
INSERT INTO Country VALUES ('KY','Y','CAYMAN ISLANDS',102);
INSERT INTO Country VALUES ('CF','Y','CENTRAL AFRICAN REPUBLIC',103);
INSERT INTO Country VALUES ('TD','Y','CHAD',104);
INSERT INTO Country VALUES ('CX','Y','CHRISTMAS ISLAND',105);
INSERT INTO Country VALUES ('CC','Y','COCOS (KEELING ISLANDS)',106);
INSERT INTO Country VALUES ('CO','Y','COLOMBIA',107);
INSERT INTO Country VALUES ('KM','Y','COMOROS',108);
INSERT INTO Country VALUES ('CG','Y','CONGO',109);
INSERT INTO Country VALUES ('CK','Y','COOK ISLANDS',110);
INSERT INTO Country VALUES ('CI','Y','COTE D''IVOIRE (IVORY COAST)',111);
INSERT INTO Country VALUES ('HR','Y','CROATIA (HRVATSKA)',112);
INSERT INTO Country VALUES ('CU','Y','CUBA',113);
INSERT INTO Country VALUES ('CY','Y','CYPRUS',114);
INSERT INTO Country VALUES ('CZ','Y','CZECH REPUBLIC',115);
INSERT INTO Country VALUES ('DJ','Y','DJIBOUTI',116);
INSERT INTO Country VALUES ('DM','Y','DOMINICA',117);
INSERT INTO Country VALUES ('DO','Y','DOMINICAN REPUBLIC',118);
INSERT INTO Country VALUES ('TP','Y','EAST TIMOR',119);
INSERT INTO Country VALUES ('EC','Y','ECUADOR',120);
INSERT INTO Country VALUES ('SV','Y','EL SALVADOR',121);
INSERT INTO Country VALUES ('GQ','Y','EQUATORIAL GUINEA',122);
INSERT INTO Country VALUES ('ER','Y','ERITREA',123);
INSERT INTO Country VALUES ('EE','Y','ESTONIA',124);
INSERT INTO Country VALUES ('ET','Y','ETHIOPIA',125);
INSERT INTO Country VALUES ('FK','Y','FALKLAND ISLANDS (MALVINAS)',126);
INSERT INTO Country VALUES ('FO','Y','FAROE ISLANDS',127);
INSERT INTO Country VALUES ('FJ','Y','FIJI',128);
INSERT INTO Country VALUES ('FX','Y','FRANCE, METROPOLITAN',129);
INSERT INTO Country VALUES ('GF','Y','FRENCH GUIANA',130);
INSERT INTO Country VALUES ('PF','Y','FRENCH POLYNESIA',131);
INSERT INTO Country VALUES ('TF','Y','FRENCH SOUTHERN TERRITORIES',132);
INSERT INTO Country VALUES ('GA','Y','GABON',133);
INSERT INTO Country VALUES ('GM','Y','GAMBIA',134);
INSERT INTO Country VALUES ('GE','Y','GEORGIA',135);
INSERT INTO Country VALUES ('GH','Y','GHANA',136);
INSERT INTO Country VALUES ('GI','Y','GIBRALTAR',137);
INSERT INTO Country VALUES ('GL','Y','GREENLAND',138);
INSERT INTO Country VALUES ('GD','Y','GRENADA',139);
INSERT INTO Country VALUES ('GP','Y','GUADELOUPE',140);
INSERT INTO Country VALUES ('GT','Y','GUATEMALA',141);
INSERT INTO Country VALUES ('GN','Y','GUINEA',142);
INSERT INTO Country VALUES ('GW','Y','GUINEA-BISSAU',143);
INSERT INTO Country VALUES ('GY','Y','GUYANA',144);
INSERT INTO Country VALUES ('HM','Y','HEARD AND MCDONALD ISLANDS',145);
INSERT INTO Country VALUES ('HN','Y','HONDURAS',146);
INSERT INTO Country VALUES ('HU','N','HUNGARY',147);
INSERT INTO Country VALUES ('IS','Y','ICELAND',148);
INSERT INTO Country VALUES ('IR','Y','IRAN',149);
INSERT INTO Country VALUES ('IQ','Y','IRAQ',150);
INSERT INTO Country VALUES ('IL','N','ISRAEL',151);
INSERT INTO Country VALUES ('JM','Y','JAMAICA',152);
INSERT INTO Country VALUES ('KZ','Y','KAZAKHSTAN',153);
INSERT INTO Country VALUES ('KE','Y','KENYA',154);
INSERT INTO Country VALUES ('KI','Y','KIRIBATI',155);
INSERT INTO Country VALUES ('KP','Y','KOREA (NORTH)',156);
INSERT INTO Country VALUES ('KR','Y','KOREA (SOUTH)',157);
INSERT INTO Country VALUES ('KG','Y','KYRGYZSTAN',158);
INSERT INTO Country VALUES ('LA','Y','LAOS',159);
INSERT INTO Country VALUES ('LV','Y','LATVIA',160);
INSERT INTO Country VALUES ('LB','Y','LEBANON',161);
INSERT INTO Country VALUES ('LS','Y','LESOTHO',162);
INSERT INTO Country VALUES ('LR','Y','LIBERIA',163);
INSERT INTO Country VALUES ('LY','Y','LIBYA',164);
INSERT INTO Country VALUES ('LI','Y','LIECHTENSTEIN',165);
INSERT INTO Country VALUES ('LT','Y','LITHUANIA',166);
INSERT INTO Country VALUES ('MO','Y','MACAU',167);
INSERT INTO Country VALUES ('MK','Y','MACEDONIA',168);
INSERT INTO Country VALUES ('MG','Y','MADAGASCAR',169);
INSERT INTO Country VALUES ('MW','Y','MALAWI',170);
INSERT INTO Country VALUES ('MV','Y','MALDIVES',171);
INSERT INTO Country VALUES ('ML','Y','MALI',172);
INSERT INTO Country VALUES ('MT','Y','MALTA',173);
INSERT INTO Country VALUES ('MH','Y','MARSHALL ISLANDS',174);
INSERT INTO Country VALUES ('MQ','Y','MARTINIQUE',175);
INSERT INTO Country VALUES ('MR','Y','MAURITANIA',176);
INSERT INTO Country VALUES ('MU','Y','MAURITIUS',177);
INSERT INTO Country VALUES ('YT','Y','MAYOTTE',178);
INSERT INTO Country VALUES ('FM','Y','MICRONESIA',179);
INSERT INTO Country VALUES ('MD','Y','MOLDOVA',180);
INSERT INTO Country VALUES ('MC','Y','MONACO',181);
INSERT INTO Country VALUES ('MN','Y','MONGOLIA',182);
INSERT INTO Country VALUES ('MS','Y','MONTSERRAT',183);
INSERT INTO Country VALUES ('MA','Y','MOROCCO',184);
INSERT INTO Country VALUES ('MZ','Y','MOZAMBIQUE',185);
INSERT INTO Country VALUES ('MM','Y','MYANMAR',186);
INSERT INTO Country VALUES ('NA','Y','NAMIBIA',187);
INSERT INTO Country VALUES ('NR','Y','NAURU',188);
INSERT INTO Country VALUES ('NP','Y','NEPAL',189);
INSERT INTO Country VALUES ('AN','Y','NETHERLANDS ANTILLES',190);
INSERT INTO Country VALUES ('NC','Y','NEW CALEDONIA',191);
INSERT INTO Country VALUES ('NZ','Y','NEW ZEALAND',192);
INSERT INTO Country VALUES ('NI','Y','NICARAGUA',193);
INSERT INTO Country VALUES ('NE','Y','NIGER',194);
INSERT INTO Country VALUES ('NG','Y','NIGERIA',195);
INSERT INTO Country VALUES ('NU','Y','NIUE',196);
INSERT INTO Country VALUES ('NF','Y','NORFOLK ISLAND',197);
INSERT INTO Country VALUES ('MP','Y','NORTHERN MARIANA ISLANDS',198);
INSERT INTO Country VALUES ('PW','Y','PALAU',199);
INSERT INTO Country VALUES ('PG','Y','PAPUA NEW GUINEA',200);
INSERT INTO Country VALUES ('PY','Y','PARAGUAY',201);
INSERT INTO Country VALUES ('PE','Y','PERU',202);
INSERT INTO Country VALUES ('PN','Y','PITCAIRN',203);
INSERT INTO Country VALUES ('PL','Y','POLAND',204);
INSERT INTO Country VALUES ('RE','Y','REUNION',205);
INSERT INTO Country VALUES ('RO','Y','ROMANIA',206);
INSERT INTO Country VALUES ('RU','Y','RUSSIAN FEDERATION',207);
INSERT INTO Country VALUES ('RW','Y','RWANDA',208);
INSERT INTO Country VALUES ('KN','Y','SAINT KITTS AND NEVIS',209);
INSERT INTO Country VALUES ('LC','Y','SAINT LUCIA',210);
INSERT INTO Country VALUES ('VC','Y','SAINT VINCENT AND THE GRENADINES',211);
INSERT INTO Country VALUES ('SM','Y','SAN MARINO',212);
INSERT INTO Country VALUES ('ST','Y','SAO TOME AND PRINCIPE',213);
INSERT INTO Country VALUES ('SN','Y','SENEGAL',214);
INSERT INTO Country VALUES ('SC','Y','SEYCHELLES',215);
INSERT INTO Country VALUES ('SL','Y','SIERRA LEONE',216);
INSERT INTO Country VALUES ('SK','Y','SLOVAK REPUBLIC',217);
INSERT INTO Country VALUES ('SI','Y','SLOVENIA',218);
INSERT INTO Country VALUES ('SB','Y','SOLOMON ISLANDS',219);
INSERT INTO Country VALUES ('SO','Y','SOMALIA',220);
INSERT INTO Country VALUES ('ZA','Y','SOUTH AFRICA',221);
INSERT INTO Country VALUES ('GS','Y','S. GEORGIA AND S. SANDWICH ISLS.',222);
INSERT INTO Country VALUES ('LK','Y','SRI LANKA',223);
INSERT INTO Country VALUES ('SH','Y','ST. HELENA',224);
INSERT INTO Country VALUES ('PM','Y','ST. PIERRE AND MIQUELON',225);
INSERT INTO Country VALUES ('SD','Y','SUDAN',226);
INSERT INTO Country VALUES ('SR','Y','SURINAME',227);
INSERT INTO Country VALUES ('SJ','Y','SVALBARD AND JAN MAYEN ISLANDS',228);
INSERT INTO Country VALUES ('SZ','Y','SWAZILAND',229);
INSERT INTO Country VALUES ('SY','Y','SYRIA',230);
INSERT INTO Country VALUES ('TJ','Y','TAJIKISTAN',231);
INSERT INTO Country VALUES ('TZ','Y','TANZANIA',232);
INSERT INTO Country VALUES ('TG','Y','TOGO',233);
INSERT INTO Country VALUES ('TK','Y','TOKELAU',234);
INSERT INTO Country VALUES ('TO','Y','TONGA',235);
INSERT INTO Country VALUES ('TT','Y','TRINIDAD AND TOBAGO',236);
INSERT INTO Country VALUES ('TN','Y','TUNISIA',237);
INSERT INTO Country VALUES ('TM','Y','TURKMENISTAN',238);
INSERT INTO Country VALUES ('TC','Y','TURKS AND CAICOS ISLANDS',239);
INSERT INTO Country VALUES ('TV','Y','TUVALU',240);
INSERT INTO Country VALUES ('UG','Y','UGANDA',241);
INSERT INTO Country VALUES ('UA','Y','UKRAINE',242);
INSERT INTO Country VALUES ('UK','N','UNITED KINGDOM',243);
INSERT INTO Country VALUES ('UM','N','US MINOR OUTLYING ISLANDS',244);
INSERT INTO Country VALUES ('UY','Y','URUGUAY',245);
INSERT INTO Country VALUES ('UZ','Y','UZBEKISTAN',246);
INSERT INTO Country VALUES ('VU','Y','VANUATU',247);
INSERT INTO Country VALUES ('VA','Y','VATICAN CITY STATE (HOLY SEE)',248);
INSERT INTO Country VALUES ('VE','Y','VENEZUELA',249);
INSERT INTO Country VALUES ('VN','Y','VIET NAM',250);
INSERT INTO Country VALUES ('VG','Y','VIRGIN ISLANDS (BRITISH)',251);
INSERT INTO Country VALUES ('VI','Y','VIRGIN ISLANDS (US)',252);
INSERT INTO Country VALUES ('WF','Y','WALLIS AND FUTUNA ISLANDS',253);
INSERT INTO Country VALUES ('EH','Y','WESTERN SAHARA',254);
INSERT INTO Country VALUES ('YE','Y','YEMEN',255);
INSERT INTO Country VALUES ('YU','Y','YUGOSLAVIA',256);
INSERT INTO Country VALUES ('ZR','Y','ZAIRE',257);
INSERT INTO Country VALUES ('ZM','Y','ZAMBIA',258);
INSERT INTO Country VALUES ('ZW','Y','ZIMBABWE',259);
INSERT INTO Country VALUES ('GB','N','GREAT BRITAIN',260);
INSERT INTO Country VALUES ('','N','ENGLAND',10);