-- packages/ref-itu/sql/common/ref-itu-data.sql
--
-- @author jon@jongriffin.com.com
-- @creation-date 2003-02-25
-- @cvs-id $Id: ref-itu-data.sql,v 1.3 2003/09/30 12:10:09 mohanp Exp $
-- first insert the notes
insert into itu_notes values ('a','Assignment of all 0XX codes is feasible since 31 December 2000. Assignment of some of these codes may be possible as soon as 1 January 1997; this question is currently under study');
insert into itu_notes values ('b','Integrated numbering plan.');
insert into itu_notes values ('c','Code shared between Mayotte Island and Comoros (Islamic Federal Republic of the).');
insert into itu_notes values ('d','Will be allocated only after all three-digit codes from groups of ten are exhausted.');
insert into itu_notes values ('e','Associated with shared country code 878 for Universal Personal Telecommunications (UPT), the identification code "10" has been assigned to the network of VISIONng, +878 10.');
insert into itu_notes values ('f','Reserved for future use.');
insert into itu_notes values ('g','Including Australian Antarctic Territory and Norfolk Island.');
insert into itu_notes values ('h','U.A.E.: Abu Dhabi, Ajman, Dubai, Fujeirah, Ras Al Khaimah, Sharjah, Umm Al Qaiwain.');
insert into itu_notes values ('i','Including Christmas Island and Cocos-Keeling Islands.');
insert into itu_notes values ('j','Associated with shared country code 882, the following two-digit identification code reservations or assignments have been made for the international networks of:
Applicant
|
Network
|
Country Code and
Identification Code
|
Status
|
British Telecommunications plc
|
Global Office Application
|
+882 10
|
Assigned
|
ST Telecommunications Pte Ltd
|
Asia Pacific Mobile Telecommunications (APMT)
|
+882 11
|
Reserved
|
MCIWorldCom
|
HyperStream International (HSI) Data Network
|
+882 12
|
Assigned
|
Telespazio S.p.A.
|
EMS Regional Mobile Satellite System
|
+882 13
|
Assigned
|
Verizon
|
Global ATM Network
|
+882 14
|
Assigned
|
Telstra
|
Global international ATM Network
|
+882 15
|
Assigned
|
United Arab Emirates Administration
|
Thuraya RMSS Network
|
+882 16
|
Assigned
|
AT &T
|
AT &T International ATM Network
|
+882 17
|
Reserved
|
Telecom Italia
|
Telecom Italia Global Network
|
+882 19
|
Reserved
|
Asia Cellular Satellite (ACeS)
|
Garuda Mobile Telecommunication Satellite System
|
+882 20
|
Reserved
|
Cable & Wireless plc
|
Cable & Wireless Global Network
|
+882 22
|
Assigned
|
Sita-Equant Joint Venture
|
Sita-Equant Network
|
+882 23
|
Reserved
|
Telia AB
|
Telia multinational ATM Network
|
+882 24
|
Assigned
|
SBC Communications Inc.
|
Global Data Network
|
+882 26
|
Reserved
|
Williams Communications Inc.
|
Williams Communications Network
|
+882 27
|
Reserved
|
Deutsche Telekom
|
Deutsche Telekom multinational ATM network
|
+882 28
|
Reserved
|
Q-Tel (NZ) ltd. (ex-World IT)
|
SkyMessenger International Network
|
+882 29
|
Assigned
|
Singapore Telecom
|
Global Reach Network
|
+882 30
|
Reserved
|
Telekom Malaysia
|
Global International ATM Network
|
+882 31
|
Assigned
|
');
insert into itu_notes values ('k','Associated with shared country code 881, the following one-digit identification codes have been reserved for / assigned to the GMSS networks:
Network | Country Code and Identification Code | Status |
ICO Global Communications | +881 0 and +881 1 | Reserved |
Ellipso | +881 2 and +881 3 | Assigned |
Iridium Satellite LLC | +881 6 and +881 7 | Assigned |
Globalstar | +881 8 and +881 9 | Assigned |
');
insert into itu_notes values ('l','Reserved for the Palestinian Authority.');
insert into itu_notes values ('m','Reserved for Recommendation ITU-T E.164 country code expansion.');
insert into itu_notes values ('n','Associated with shared country code 388 for Group of countries, the following one-digit identification code has been assigned to the network of ETNS (European Telephony Numbering Space) +388 3.');
insert into itu_notes values ('o','Associated with shared country code 991, for trial, the three-digit trial identification code .001. has been temporarily assigned until May 2002 to Neustar for ENUM trials, +991 001.');
------
insert into itu_codes values (acs_object_id_seq.nextval,'0','Reserved','a');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Anguilla','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Antigua and Barbuda','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Bahamas (Commonwealth of the)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Barbados','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Bermuda','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','British Virgin Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Canada','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Cayman Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Dominica (Commonwealth of)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Dominican Republic','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Grenada','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Guam','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Jamaica','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Montserrat','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Northern Mariana Islands (Commonwealth of the)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Puerto Rico','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Saint Kitts and Nevis','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Saint Lucia','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Saint Vincent and the Grenadines','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Trinidad and Tobago','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Turks and Caicos Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','United States of America','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','United States Virgin Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'20','Egypt (Arab Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'210','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'211','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'212','Morocco (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'213','Algeria (People''s Democratic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'214','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'215','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'216','Tunisia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'217','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'218','Libya (Socialist People''s Libyan Arab Jamahiriya)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'219','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'220','Gambia (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'221','Senegal (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'222','Mauritania (Islamic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'223','Mali (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'224','Guinea (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'225','Cte d''Ivoire (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'226','Burkina Faso',null);
insert into itu_codes values (acs_object_id_seq.nextval,'227','Niger (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'228','Togolese Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'229','Benin (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'230','Mauritius (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'231','Liberia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'232','Sierra Leone',null);
insert into itu_codes values (acs_object_id_seq.nextval,'233','Ghana',null);
insert into itu_codes values (acs_object_id_seq.nextval,'234','Nigeria (Federal Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'235','Chad (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'236','Central African Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'237','Cameroon (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'238','Cape Verde (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'239','Sao Tome and Principe (Democratic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'240','Equatorial Guinea (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'241','Gabonese Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'242','Congo (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'243','Democratic Republic of the Congo',null);
insert into itu_codes values (acs_object_id_seq.nextval,'244','Angola (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'245','Guinea-Bissau (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'246','Diego Garcia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'247','Ascension',null);
insert into itu_codes values (acs_object_id_seq.nextval,'248','Seychelles (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'249','Sudan (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'250','Rwandese Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'251','Ethiopia (Federal Democratic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'252','Somali Democratic Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'253','Djibouti (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'254','Kenya (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'255','Tanzania (United Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'256','Uganda (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'257','Burundi (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'258','Mozambique (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'259','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'260','Zambia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'261','Madagascar (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'262','Reunion (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'263','Zimbabwe (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'264','Namibia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'265','Malawi',null);
insert into itu_codes values (acs_object_id_seq.nextval,'266','Lesotho (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'267','Botswana (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'268','Swaziland (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'269','Comoros (Islamic Federal Republic of the)','c');
insert into itu_codes values (acs_object_id_seq.nextval,'269','Mayotte (Collective Territory Republic of France)','c');
insert into itu_codes values (acs_object_id_seq.nextval,'27','South Africa (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'280','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'281','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'282','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'283','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'284','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'285','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'286','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'287','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'288','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'289','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'290','Saint Helena',null);
insert into itu_codes values (acs_object_id_seq.nextval,'291','Eritrea',null);
insert into itu_codes values (acs_object_id_seq.nextval,'292','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'293','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'294','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'295','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'296','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'297','Aruba',null);
insert into itu_codes values (acs_object_id_seq.nextval,'298','Faroe Islands',null);
insert into itu_codes values (acs_object_id_seq.nextval,'299','Greenland (Denmark)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'30','Greece',null);
insert into itu_codes values (acs_object_id_seq.nextval,'31','Netherlands (Kingdom of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'32','Belgium',null);
insert into itu_codes values (acs_object_id_seq.nextval,'33','France',null);
insert into itu_codes values (acs_object_id_seq.nextval,'34','Spain',null);
insert into itu_codes values (acs_object_id_seq.nextval,'350','Gibraltar',null);
insert into itu_codes values (acs_object_id_seq.nextval,'351','Portugal',null);
insert into itu_codes values (acs_object_id_seq.nextval,'352','Luxembourg',null);
insert into itu_codes values (acs_object_id_seq.nextval,'353','Ireland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'354','Iceland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'355','Albania (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'356','Malta',null);
insert into itu_codes values (acs_object_id_seq.nextval,'357','Cyprus (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'358','Finland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'359','Bulgaria (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'36','Hungary (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'370','Lithuania (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'371','Latvia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'372','Estonia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'373','Moldova (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'374','Armenia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'375','Belarus (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'376','Andorra (Principality of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'377','Monaco (Principality of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'378','San Marino (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'379','Vatican City State','f');
insert into itu_codes values (acs_object_id_seq.nextval,'380','Ukraine',null);
insert into itu_codes values (acs_object_id_seq.nextval,'381','Yugoslavia (Federal Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'382','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'383','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'384','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'385','Croatia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'386','Slovenia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'387','Bosnia and Herzegovina',null);
insert into itu_codes values (acs_object_id_seq.nextval,'388','Group of countries,shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'389','The Former Yugoslav Republic of Macedonia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'39','Italy',null);
insert into itu_codes values (acs_object_id_seq.nextval,'39','Vatican City State',null);
insert into itu_codes values (acs_object_id_seq.nextval,'40','Romania',null);
insert into itu_codes values (acs_object_id_seq.nextval,'41','Switzerland (Confederation of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'420','Czech Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'421','Slovak Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'422','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'423','Liechtenstein (Principality of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'424','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'425','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'426','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'427','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'428','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'429','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'43','Austria',null);
insert into itu_codes values (acs_object_id_seq.nextval,'44','United Kingdom of Great Britain and Northern Ireland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'45','Denmark',null);
insert into itu_codes values (acs_object_id_seq.nextval,'46','Sweden',null);
insert into itu_codes values (acs_object_id_seq.nextval,'47','Norway',null);
insert into itu_codes values (acs_object_id_seq.nextval,'48','Poland (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'49','Germany (Federal Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'500','Falkland Islands (Malvinas)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'501','Belize',null);
insert into itu_codes values (acs_object_id_seq.nextval,'502','Guatemala (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'503','El Salvador (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'504','Honduras (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'505','Nicaragua',null);
insert into itu_codes values (acs_object_id_seq.nextval,'506','Costa Rica',null);
insert into itu_codes values (acs_object_id_seq.nextval,'507','Panama (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'508','Saint Pierre and Miquelon (Collectivite territoriale de la Republique francaise)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'509','Haiti (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'51','Peru',null);
insert into itu_codes values (acs_object_id_seq.nextval,'52','Mexico',null);
insert into itu_codes values (acs_object_id_seq.nextval,'53','Cuba',null);
insert into itu_codes values (acs_object_id_seq.nextval,'54','Argentine Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'55','Brazil (Federative Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'56','Chile',null);
insert into itu_codes values (acs_object_id_seq.nextval,'57','Colombia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'58','Venezuela (Bolivarian Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'590','Guadeloupe (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'591','Bolivia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'592','Guyana',null);
insert into itu_codes values (acs_object_id_seq.nextval,'593','Ecuador',null);
insert into itu_codes values (acs_object_id_seq.nextval,'594','French Guiana (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'595','Paraguay (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'596','Martinique (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'597','Suriname (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'598','Uruguay (Eastern Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'599','Netherlands Antilles',null);
insert into itu_codes values (acs_object_id_seq.nextval,'60','Malaysia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'61','Australia','i');
insert into itu_codes values (acs_object_id_seq.nextval,'62','Indonesia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'63','Philippines (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'64','New Zealand',null);
insert into itu_codes values (acs_object_id_seq.nextval,'65','Singapore (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'66','Thailand',null);
insert into itu_codes values (acs_object_id_seq.nextval,'670','East Timor',null);
insert into itu_codes values (acs_object_id_seq.nextval,'671','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'672','Australian External Territories','g');
insert into itu_codes values (acs_object_id_seq.nextval,'673','Brunei Darussalam',null);
insert into itu_codes values (acs_object_id_seq.nextval,'674','Nauru (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'675','Papua New Guinea',null);
insert into itu_codes values (acs_object_id_seq.nextval,'676','Tonga (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'677','Solomon Islands',null);
insert into itu_codes values (acs_object_id_seq.nextval,'678','Vanuatu (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'679','Fiji (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'680','Palau (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'681','Wallis and Futuna (Territoire francais d''outre-mer)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'682','Cook Islands',null);
insert into itu_codes values (acs_object_id_seq.nextval,'683','Niue',null);
insert into itu_codes values (acs_object_id_seq.nextval,'684','American Samoa',null);
insert into itu_codes values (acs_object_id_seq.nextval,'685','Samoa (Independent State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'686','Kiribati (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'687','New Caledonia (Territoire francais d''outre-mer)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'688','Tuvalu',null);
insert into itu_codes values (acs_object_id_seq.nextval,'689','French Polynesia (Territoire francais d''outre-mer)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'690','Tokelau',null);
insert into itu_codes values (acs_object_id_seq.nextval,'691','Micronesia (Federated States of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'692','Marshall Islands (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'693','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'694','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'695','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'696','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'697','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'698','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'699','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'7','Kazakstan (Republic of)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'7','Russian Federation','b');
insert into itu_codes values (acs_object_id_seq.nextval,'800','International Freephone Service',null);
insert into itu_codes values (acs_object_id_seq.nextval,'801','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'802','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'803','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'804','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'805','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'806','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'807','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'808','International Shared Cost Service (ISCS)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'809','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'81','Japan',null);
insert into itu_codes values (acs_object_id_seq.nextval,'82','Korea (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'830','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'831','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'832','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'833','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'834','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'835','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'836','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'837','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'838','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'839','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'84','Viet Nam (Socialist Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'850','Democratic People''s Republic of Korea',null);
insert into itu_codes values (acs_object_id_seq.nextval,'851','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'852','Hongkong,China',null);
insert into itu_codes values (acs_object_id_seq.nextval,'853','Macao,China',null);
insert into itu_codes values (acs_object_id_seq.nextval,'854','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'855','Cambodia (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'856','Lao People''s Democratic Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'857','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'858','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'859','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'86','China (People''s Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'870','Inmarsat SNAC',null);
insert into itu_codes values (acs_object_id_seq.nextval,'871','Inmarsat (Atlantic Ocean-East)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'872','Inmarsat (Pacific Ocean)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'873','Inmarsat (Indian Ocean)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'874','Inmarsat (Atlantic Ocean-West)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'875','Reserved ? Maritime Mobile Service Applications',null);
insert into itu_codes values (acs_object_id_seq.nextval,'876','Reserved ? Maritime Mobile Service Applications',null);
insert into itu_codes values (acs_object_id_seq.nextval,'877','Reserved ? Maritime Mobile Service Applications',null);
insert into itu_codes values (acs_object_id_seq.nextval,'878','Reserved ? Universal Personal Telecommunication Service (UPT)','e');
insert into itu_codes values (acs_object_id_seq.nextval,'879','Reserved for national non-commercial purposes',null);
insert into itu_codes values (acs_object_id_seq.nextval,'880','Bangladesh (People''s Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'881','Global Mobile Satellite System (GMSS),shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'882','International Networks,shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'883','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'884','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'885','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'886','Reserved',null);
insert into itu_codes values (acs_object_id_seq.nextval,'887','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'888','Reserved for future global service',null);
insert into itu_codes values (acs_object_id_seq.nextval,'889','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'890','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'891','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'892','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'893','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'894','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'895','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'896','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'897','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'898','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'899','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'90','Turkey',null);
insert into itu_codes values (acs_object_id_seq.nextval,'91','India (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'92','Pakistan (Islamic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'93','Afghanistan (Islamic State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'94','Sri Lanka (Democratic Socialist Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'95','Myanmar (Union of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'960','Maldives (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'961','Lebanon',null);
insert into itu_codes values (acs_object_id_seq.nextval,'962','Jordan (Hashemite Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'963','Syrian Arab Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'964','Iraq (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'965','Kuwait (State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'966','Saudi Arabia (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'967','Yemen (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'968','Oman (Sultanate of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'969','Reserved - Reservation currently under investigation',null);
insert into itu_codes values (acs_object_id_seq.nextval,'970','Reserved','l');
insert into itu_codes values (acs_object_id_seq.nextval,'971','United Arab Emirates','h');
insert into itu_codes values (acs_object_id_seq.nextval,'972','Israel (State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'973','Bahrain (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'974','Qatar (State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'975','Bhutan (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'976','Mongolia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'977','Nepal',null);
insert into itu_codes values (acs_object_id_seq.nextval,'978','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'979','International Premium Rate Service (IPRS)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'98','Iran (Islamic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'990','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'991','Trial of a proposed new international telecommunication public correspondence service,shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'992','Tajikistan (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'993','Turkmenistan',null);
insert into itu_codes values (acs_object_id_seq.nextval,'994','Azerbaijani Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'995','Georgia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'996','Kyrgyz Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'997','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'998','Uzbekistan (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'999','Spare code',null);