0

Hi

I am new database designer. I am wondering if there is ready-made standard Nationality lookup table, I think I will find those entries in some txt file since Every DBMS can load a text file. and I think there must be a standard schema for that table something like
CountryCode, CountryName where CountryCode is PK

Please help me finding those standards or verify that there is no such standard so I will create my own table and backup it for reusing.

I there is a pool for standard tables?

Note: I am using MS SQL Server 2005

Thanks

3
Contributors
4
Replies
6
Views
9 Years
Discussion Span
Last Post by pritaeas
0

Hi
maybe you would be able to create such table from below list by writing small Python program?

Country 	Code
----------------------
Afghanistan 	93
Albania 	355
Algeria 	213
American Samoa 	+1-684*
Andorra 	376
Angola 	244
Anguilla 	+1-264*
Antigua 	+1-268*
Argentina 	54
Armenia 	374
Aruba 	297
Ascension 	247
Australia 	61
Australian External Territories 	672
Austria 	43
Azerbaijan 	994
Bahamas 	+1-242*
Bahrain 	973
Bangladesh 	880
Barbados 	+1-246*
Barbuda 	+1-268*
Belarus 	375
Belgium 	32
Belize 	501
Benin 	229
Bermuda 	+1-441*
Bhutan 	975
Bolivia 	591
Bosnia & Herzegovina 	387
Botswana 	267
Brazil 	55
British Virgin Islands 	+1-284*
Brunei Darussalam 	673
Bulgaria 	359
Burkina Faso 	226
Burundi 	257
Cambodia 	855
Cameroon 	237
Canada 	1
Cape Verde Islands 	238
Cayman Islands 	+1-345*
Central African Republic 	236
Chad 	235
Chatham Island (New Zealand) 	64
Chile 	56
China (PRC) 	86
Christmas Island 	61
Cocos-Keeling Islands 	61
Colombia 	57
Comoros 	269
Congo 	242
Congo, Dem. Rep. of (Zaire) 	243
Cook Islands 	682
Costa Rica 	506
Côte d'Ivoire (Ivory Coast) 	225
Croatia 	385
Cuba 	53
Cuba (Guantanamo Bay) 	5399
Curaçao 	599
Cyprus 	357
Czech Republic 	420
Denmark 	45
Diego Garcia 	246
Djibouti 	253
Dominica 	+1-767*
Dominican Republic 	+1-809* and +1-829*
East Timor 	670
Easter Island 	56
Ecuador 	593
Egypt 	20
El Salvador 	503
Ellipso (Mobile Satellite service) 	17625
EMSAT (Mobile Satellite service) 	88213
Equatorial Guinea 	240
Eritrea 	291
Estonia 	372
Ethiopia 	251
Falkland Islands (Malvinas) 	500
Faroe Islands 	298
Fiji Islands 	679
Finland 	358
France 	33
French Antilles 	596
French Guiana 	594
French Polynesia 	689
Gabonese Republic 	241
Gambia 	220
Georgia 	995
Germany 	49
Ghana 	233
Gibraltar 	350
Global Mobile Satellite System (GMSS) 	881
Globalstar 	8818, 8819
Globalstar (Mobile Satellite Service) 	17637
Greece 	30
Greenland 	299
Grenada 	+1-473*
Guadeloupe 	590
Guam 	+1-671*
Guantanamo Bay 	5399
Guatemala 	502
Guinea-Bissau 	245
Guinea 	224
Guyana 	592
Haiti 	509
Honduras 	504
Hong Kong 	852
Hungary 	36
ICO Global (Mobile Satellite Service) 	17621
Iceland 	354
India 	91
Indonesia 	62
Inmarsat (Atlantic Ocean - East) 	871
Inmarsat (Atlantic Ocean - West) 	874
Inmarsat (Indian Ocean) 	873
Inmarsat (Pacific Ocean) 	872
International Freephone Service 	800
International Shared Cost Service (ISCS) 	808
Iran 	98
Iraq 	964
Ireland 	353
Iridium (Mobile Satellite service) 	8816
Iridium (Mobile Satellite service) 	8817
Israel 	972
Italy 	39
Jamaica 	+1-876*
Japan 	81
Jordan 	962
Kazakhstan 	7
Kenya 	254
Kiribati 	686
Korea (North) 	850
Korea (South) 	82
Kuwait 	965
Kyrgyz Republic 	996
Laos 	856
Latvia 	371
Lebanon 	961
Lesotho 	266
Liberia 	231
Libya 	218
Liechtenstein 	423
Lithuania 	370
Luxembourg 	352
Macao 	853
Macedonia (Former Yugoslav Rep of.) 	389
Madagascar 	261
Malawi 	265
Malaysia 	60
Maldives 	960
Mali Republic 	223
Malta 	356
Marshall Islands 	692
Martinique 	596
Mauritania 	222
Mauritius 	230
Mayotte Island 	262
Mexico 	52
Micronesia, (Federal States of) 	691
Midway Island 	+1-808*
Moldova 	373
Monaco 	377
Mongolia 	976
Montenegro 	382
Montserrat 	+1-664*
Morocco 	212
Mozambique 	258
Myanmar 	95
Namibia 	264
Nauru 	674
Nepal 	977
Netherlands 	31
Netherlands Antilles 	599
Nevis 	+1-869*
New Caledonia 	687
New Zealand 	64
Nicaragua 	505
Niger 	227
Nigeria 	234
Niue 	683
Norfolk Island 	672
Northern Marianas Islands 	+1-670*
Norway 	47
Oman 	968
Pakistan 	92
Palau 	680
Palestine 	970
Panama 	507
Papua New Guinea 	675
Paraguay 	595
Peru 	51
Philippines 	63
Poland 	48
Portugal 	351
Puerto Rico 	+1-787* or +1-939*
Qatar 	974
Réunion Island 	262
Romania 	40
Russia 	7
Rwandese Republic 	250
St. Helena 	290
St. Kitts/Nevis 	+1-869*
St. Lucia 	+1-758*
St. Pierre & Miquelon 	508
St. Vincent & Grenadines 	+1-784*
Samoa 	685
San Marino 	378
São Tomé and Principe 	239
Saudi Arabia 	966
Senegal 	221
Serbia 	381
Seychelles Republic 	248
Sierra Leone 	232
Singapore 	65
Slovak Republic 	421
Slovenia 	386
Solomon Islands 	677
Somali Democratic Republic 	252
South Africa 	27
Spain 	34
Sri Lanka 	94
Sudan 	249
Suriname 	597
Swaziland 	268
Sweden 	46
Switzerland 	41
Syria 	963
Taiwan 	886
Tajikistan 	992
Tanzania 	255
Thailand 	66
Thuraya (Mobile Satellite service) 	88216
Timor Leste 	670
Togolese Republic 	228
Tokelau 	690
Tonga Islands 	676
Trinidad & Tobago 	+1-868*
Tunisia 	216
Turkey 	90
Turkmenistan 	993
Turks and Caicos Islands 	+1-649*
Tuvalu 	688
Uganda 	256
Ukraine 	380
United Arab Emirates 	971
United Kingdom 	44
United States of America 	1
US Virgin Islands 	+1-340*
Universal Personal Telecommunications (UPT) 	878
Uruguay 	598
Uzbekistan 	998
Vanuatu 	678
Vatican City 	39; 379
Venezuela 	58
Vietnam 	84
Wake Island 	808
Wallis and Futuna Islands 	681
Yemen 	967
Zambia 	260
Zanzibar 	255
Zimbabwe 	263

krs,
tesu

1

AFAIK there is no ISO table for nationalities.

Sure there are country codes standardized by ISO 3166, look here:

Some codes from ISO 3166 
#
Updated by the RIPE Network Coordination Centre.
#
Source: ISO 3166 Maintenance Agency 
#
Latest change: Thu Aug  7 17:59:51 MET DST 1997
#
#
Country                                         A 2     A 3     Number
----------------------------------------------------------------------
AFGHANISTAN                                     AF      AFG     004
ALBANIA                                         AL      ALB     008
ALGERIA                                         DZ      DZA     012
AMERICAN SAMOA                                  AS      ASM     016
ANDORRA                                         AD      AND     020
ANGOLA                                          AO      AGO     024
ANGUILLA                                        AI      AIA     660
ANTARCTICA                                      AQ      ATA     010
ANTIGUA AND BARBUDA                             AG      ATG     028
ARGENTINA                                       AR      ARG     032
ARMENIA                                         AM      ARM     051  
ARUBA                                           AW      ABW     533
AUSTRALIA                                       AU      AUS     036
AUSTRIA                                         AT      AUT     040
AZERBAIJAN                                      AZ      AZE     031  
BAHAMAS                                         BS      BHS     044
BAHRAIN                                         BH      BHR     048
BANGLADESH                                      BD      BGD     050
BARBADOS                                        BB      BRB     052
BELARUS                                         BY      BLR     112  
BELGIUM                                         BE      BEL     056
BELIZE                                          BZ      BLZ     084
BENIN                                           BJ      BEN     204
BERMUDA                                         BM      BMU     060
BHUTAN                                          BT      BTN     064
BOLIVIA                                         BO      BOL     068
BOSNIA AND HERZEGOWINA                          BA      BIH     070
BOTSWANA                                        BW      BWA     072
BOUVET ISLAND                                   BV      BVT     074
BRAZIL                                          BR      BRA     076
BRITISH INDIAN OCEAN TERRITORY                  IO      IOT     086
BRUNEI DARUSSALAM                               BN      BRN     096
BULGARIA                                        BG      BGR     100
BURKINA FASO                                    BF      BFA     854
BURUNDI                                         BI      BDI     108
CAMBODIA                                        KH      KHM     116
CAMEROON                                        CM      CMR     120
CANADA                                          CA      CAN     124
CAPE VERDE                                      CV      CPV     132
CAYMAN ISLANDS                                  KY      CYM     136
CENTRAL AFRICAN REPUBLIC                        CF      CAF     140
CHAD                                            TD      TCD     148
CHILE                                           CL      CHL     152
CHINA                                           CN      CHN     156
CHRISTMAS ISLAND                                CX      CXR     162
COCOS (KEELING) ISLANDS                         CC      CCK     166
COLOMBIA                                        CO      COL     170
COMOROS                                         KM      COM     174
CONGO                                           CG      COG     178
CONGO, THE DEMOCRATIC REPUBLIC OF THE           CD      COD     180
COOK ISLANDS                                    CK      COK     184
COSTA RICA                                      CR      CRI     188
COTE D'IVOIRE                                   CI      CIV     384
CROATIA (local name: Hrvatska)                  HR      HRV     191      
CUBA                                            CU      CUB     192
CYPRUS                                          CY      CYP     196
CZECH REPUBLIC                                  CZ      CZE     203  
DENMARK                                         DK      DNK     208
DJIBOUTI                                        DJ      DJI     262
DOMINICA                                        DM      DMA     212
DOMINICAN REPUBLIC                              DO      DOM     214
EAST TIMOR                                      TP      TMP     626
ECUADOR                                         EC      ECU     218
EGYPT                                           EG      EGY     818
EL SALVADOR                                     SV      SLV     222
EQUATORIAL GUINEA                               GQ      GNQ     226
ERITREA                                         ER      ERI     232
ESTONIA                                         EE      EST     233  
ETHIOPIA                                        ET      ETH     231
FALKLAND ISLANDS (MALVINAS)                     FK      FLK     238
FAROE ISLANDS                                   FO      FRO     234
FIJI                                            FJ      FJI     242
FINLAND                                         FI      FIN     246
FRANCE                                          FR      FRA     250
FRANCE, METROPOLITAN                            FX      FXX     249  
FRENCH GUIANA                                   GF      GUF     254
FRENCH POLYNESIA                                PF      PYF     258
FRENCH SOUTHERN TERRITORIES                     TF      ATF     260
GABON                                           GA      GAB     266
GAMBIA                                          GM      GMB     270
GEORGIA                                         GE      GEO     268  
GERMANY                                         DE      DEU     276
GHANA                                           GH      GHA     288
GIBRALTAR                                       GI      GIB     292
GREECE                                          GR      GRC     300
GREENLAND                                       GL      GRL     304
GRENADA                                         GD      GRD     308
GUADELOUPE                                      GP      GLP     312
GUAM                                            GU      GUM     316
GUATEMALA                                       GT      GTM     320
GUINEA                                          GN      GIN     324
GUINEA-BISSAU                                   GW      GNB     624
GUYANA                                          GY      GUY     328
HAITI                                           HT      HTI     332
HEARD AND MC DONALD ISLANDS                     HM      HMD     334
HOLY SEE (VATICAN CITY STATE)                   VA      VAT     336
HONDURAS                                        HN      HND     340
HONG KONG                                       HK      HKG     344
HUNGARY                                         HU      HUN     348
ICELAND                                         IS      ISL     352
INDIA                                           IN      IND     356
INDONESIA                                       ID      IDN     360
IRAN (ISLAMIC REPUBLIC OF)                      IR      IRN     364
IRAQ                                            IQ      IRQ     368
IRELAND                                         IE      IRL     372
ISRAEL                                          IL      ISR     376
ITALY                                           IT      ITA     380
JAMAICA                                         JM      JAM     388
JAPAN                                           JP      JPN     392
JORDAN                                          JO      JOR     400
KAZAKHSTAN                                      KZ      KAZ     398  
KENYA                                           KE      KEN     404
KIRIBATI                                        KI      KIR     296
KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF          KP      PRK     408
KOREA, REPUBLIC OF                              KR      KOR     410
KUWAIT                                          KW      KWT     414
KYRGYZSTAN                                      KG      KGZ     417  
LAO PEOPLE'S DEMOCRATIC REPUBLIC                LA      LAO     418
LATVIA                                          LV      LVA     428  
LEBANON                                         LB      LBN     422
LESOTHO                                         LS      LSO     426
LIBERIA                                         LR      LBR     430
LIBYAN ARAB JAMAHIRIYA                          LY      LBY     434
LIECHTENSTEIN                                   LI      LIE     438
LITHUANIA                                       LT      LTU     440  
LUXEMBOURG                                      LU      LUX     442
MACAU                                           MO      MAC     446
MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF      MK      MKD     807 
MADAGASCAR                                      MG      MDG     450
MALAWI                                          MW      MWI     454
MALAYSIA                                        MY      MYS     458
MALDIVES                                        MV      MDV     462
MALI                                            ML      MLI     466
MALTA                                           MT      MLT     470
MARSHALL ISLANDS                                MH      MHL     584
MARTINIQUE                                      MQ      MTQ     474
MAURITANIA                                      MR      MRT     478
MAURITIUS                                       MU      MUS     480
MAYOTTE                                         YT      MYT     175  
MEXICO                                          MX      MEX     484
MICRONESIA, FEDERATED STATES OF                 FM      FSM     583
MOLDOVA, REPUBLIC OF                            MD      MDA     498  
MONACO                                          MC      MCO     492
MONGOLIA                                        MN      MNG     496
MONTSERRAT                                      MS      MSR     500
MOROCCO                                         MA      MAR     504
MOZAMBIQUE                                      MZ      MOZ     508
MYANMAR                                         MM      MMR     104
NAMIBIA                                         NA      NAM     516
NAURU                                           NR      NRU     520
NEPAL                                           NP      NPL     524
NETHERLANDS                                     NL      NLD     528
NETHERLANDS ANTILLES                            AN      ANT     530
NEW CALEDONIA                                   NC      NCL     540
NEW ZEALAND                                     NZ      NZL     554
NICARAGUA                                       NI      NIC     558
NIGER                                           NE      NER     562
NIGERIA                                         NG      NGA     566
NIUE                                            NU      NIU     570
NORFOLK ISLAND                                  NF      NFK     574
NORTHERN MARIANA ISLANDS                        MP      MNP     580
NORWAY                                          NO      NOR     578
OMAN                                            OM      OMN     512
PAKISTAN                                        PK      PAK     586
PALAU                                           PW      PLW     585
PANAMA                                          PA      PAN     591
PAPUA NEW GUINEA                                PG      PNG     598
PARAGUAY                                        PY      PRY     600
PERU                                            PE      PER     604
PHILIPPINES                                     PH      PHL     608
PITCAIRN                                        PN      PCN     612
POLAND                                          PL      POL     616
PORTUGAL                                        PT      PRT     620
PUERTO RICO                                     PR      PRI     630
QATAR                                           QA      QAT     634
REUNION                                         RE      REU     638
ROMANIA                                         RO      ROM     642
RUSSIAN FEDERATION                              RU      RUS     643
RWANDA                                          RW      RWA     646
SAINT KITTS AND NEVIS                           KN      KNA     659
SAINT LUCIA                                     LC      LCA     662
SAINT VINCENT AND THE GRENADINES                VC      VCT     670
SAMOA                                           WS      WSM     882
SAN MARINO                                      SM      SMR     674
SAO TOME AND PRINCIPE                           ST      STP     678
SAUDI ARABIA                                    SA      SAU     682
SENEGAL                                         SN      SEN     686
SEYCHELLES                                      SC      SYC     690
SIERRA LEONE                                    SL      SLE     694
SINGAPORE                                       SG      SGP     702
SLOVAKIA (Slovak Republic)                      SK      SVK     703  
SLOVENIA                                        SI      SVN     705  
SOLOMON ISLANDS                                 SB      SLB     090
SOMALIA                                         SO      SOM     706
SOUTH AFRICA                                    ZA      ZAF     710
SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS    GS      SGS     239
SPAIN                                           ES      ESP     724
SRI LANKA                                       LK      LKA     144
ST. HELENA                                      SH      SHN     654
ST. PIERRE AND MIQUELON                         PM      SPM     666
SUDAN                                           SD      SDN     736
SURINAME                                        SR      SUR     740
SVALBARD AND JAN MAYEN ISLANDS                  SJ      SJM     744
SWAZILAND                                       SZ      SWZ     748
SWEDEN                                          SE      SWE     752
SWITZERLAND                                     CH      CHE     756
SYRIAN ARAB REPUBLIC                            SY      SYR     760
TAIWAN, PROVINCE OF CHINA                       TW      TWN     158
TAJIKISTAN                                      TJ      TJK     762  
TANZANIA, UNITED REPUBLIC OF                    TZ      TZA     834
THAILAND                                        TH      THA     764
TOGO                                            TG      TGO     768
TOKELAU                                         TK      TKL     772
TONGA                                           TO      TON     776
TRINIDAD AND TOBAGO                             TT      TTO     780
TUNISIA                                         TN      TUN     788
TURKEY                                          TR      TUR     792
TURKMENISTAN                                    TM      TKM     795  
TURKS AND CAICOS ISLANDS                        TC      TCA     796
TUVALU                                          TV      TUV     798
UGANDA                                          UG      UGA     800
UKRAINE                                         UA      UKR     804
UNITED ARAB EMIRATES                            AE      ARE     784
UNITED KINGDOM                                  GB      GBR     826
UNITED STATES                                   US      USA     840
UNITED STATES MINOR OUTLYING ISLANDS            UM      UMI     581
URUGUAY                                         UY      URY     858
UZBEKISTAN                                      UZ      UZB     860  
VANUATU                                         VU      VUT     548
VENEZUELA                                       VE      VEN     862
VIET NAM                                        VN      VNM     704
VIRGIN ISLANDS (BRITISH)                        VG      VGB     092
VIRGIN ISLANDS (U.S.)                           VI      VIR     850
WALLIS AND FUTUNA ISLANDS                       WF      WLF     876
WESTERN SAHARA                                  EH      ESH     732
YEMEN                                           YE      YEM     887
YUGOSLAVIA                                      YU      YUG     891
ZAMBIA                                          ZM      ZMB     894
ZIMBABWE                                        ZW      ZWE     716

----------------------------------------------------------------------

List of changes applied, as specified in registration newsletters:

Newsletter III-1, 1989-12-5:
  Burma deleted, Myanmar added (same numeric value, change of country name)

Newsletter III-2, 1990-07-16
  Namibia, changing information not included in this file

Newsletter III-3, 1990-08-14
  Afghanistan, changing information not included in this file

Newsletter III-4, 1990-08-14
  Ethiopia, changing information not included in this file

Newsletter III-5, 1990-08-14
  Fiji, changing information not included in this file

Newsletter III-6, 1990-08-14
  Hungary, changing information not included in this file

Newsletter III-7, 1990-08-14
  Unification of Yemen, under new numeric code

Newsletter III-8, 1990-08-14
  Romania, changing information not included in this file

Newsletter III-9, 1990-08-14
  Poland, changing information not included in this file

Newsletter III-10, 1990-08-14
  Kampuchea deleted, Cambodia added (same numeric value, change of name)

Newsletter III-11, 1990-08-14
  Benin, changing information not included in this file

Newsletter III-12, 1990-12-04
  Czechoslovakia, changing information not included in this file

Newsletter III-13, 1990-10-30
  Germany unified (DDR deleted, new name and numeric code for unified Germany)

Newsletter III-14 1991-02-10
  Mozambique, changing information not included in this file

Newsletter III-15 1991-02-10
  Bulgaria, changing information not included in this file

Newsletter III-16 1992-06-15
  ESTONIA added (EE, EST, 233)

Newsletter III-17 1992-06-15
  LATVIA added (LV, LVA, 428)

Newsletter III-18 1992-06-15
  Lithuania added

Newsletter III-19 1992-06-15
  Belarus, named and 3c changed

Newsletter III-20 1992-04-06
  Albania, changing information not included in this file

Newsletter III-21 1992-04-06
  Congo, changing information not included in this file

Newsletter III-22 1992-04-19
  Micronesia, name changed to Micronesia (Federated States of)

Newsletter III-23 1992-04-19
  Ukraine, name changed

Newsletter III-24 1993-06-18
  France, Metropolitan (FX) added (European part of France thus excluding:
                GF, GP, MQ, NC, PF, PM, RE, TF, WF, YT)

Newsletter III-25, 1991-12-18
  Pitcairn, changing information not included in this file

Newsletter III-26, 1992-06-15
  Croatia, added NR, HRV, 191

Newsletter III-27, 1992-06-15
  Armenia, added AM, ARM, 051

Newsletter III-28, 1992-08-28
  Georgia added

Newsletter III-29, 1992-06-15
  Russian Federation added

Newsletter III-30, 1992-06-15
  Turkmenistan added

Newsletter III-31, 1992-06-15
  Kazakhstan added

Newsletter III-32, 1992-06-15
  Kyrgyzstan added

Newsletter III-33, 1992-06-15
  Tajikistan added

Newsletter III-34, 1992-06-15
  Uzbekistan added

Newsletter III-35, 1992-06-15
  Azerbaijan added

Newsletter III-36 1992-06-15
  MOLDOVA, REPUBLIC OF added (MD, MDA, 498)

Newsletter III-37 1992-08-30
  USSR deleted

Newsletter III-38, 1993-06-15
  Slovenia, number code 705 assigned

Newsletter III-39 (undated)
  BOSNIA AND HERZEGOWINA added (BA, BIH, 070)

Newsletter III-40 1993-07-12
  YEMEN, REPUBLIC OF changed to YEMEN

Newsletter III-41 1993-07-28
  MAURITIUS, changes outside this document

Newletter III-42 1993-07-12
  SAINT VINCENT AND THE GRENADINES, changes outside this document

Newsletter III-43 1993-07-12
  MONGOLIA, changes outside this document

Newsletter III-44 1993-07-22
  PANAMA, changed numeric code from 590 to 591

Newsletter III-45 1993-07-28
  YUGOSLAVIA changed numeric code from 890 to 891

Newsletter III-46 1993-07-12
  NEUTRAL ZONE deleted

Newsletter III-47 1993-07-12
  NETHERLANDS ANTILLES changed numeric code from 532 to 530

Newsletter III-48, 1993-07-12
  Added MAYOTTE

Newsletter III-49, 1993-06-15
  Slovakia added

Newsletter III-50, 1993-06-15
  Czech Republic added

Newsletter III-51, 1993-06-15
  Czechoslovakia officially deleted

Newsletter III-52, 1993-07-02
  Angola, changing information not included in this file. Offical name
  change to Republic of Angola

Newsletter III-53, 1993-07-12
  Madagascar, changing information not included in this file. Official 
  name change to Republic of Madagascar

Newsletter III-54, 1993-07-23
  South Georgia and the South Sandwich Islands, previously covered by 
  Falkland Islands

Newsletter III-55, 1993-07-16
  Ethiopia, numeric code change to 231

Newsletter III-56, 1993-07-16
  Eritrea, changing information not included in this file
  Previously covered by the entry ET

Newsletter III-57, 1993-07-16
  Macedonia, the former Yugolslav Republic of,
  Previously covered by the entry YU  
  
Newsletter III-58, 1993-07-16
  Afghanistan, changing information not included in this file
  Official name change to Islamic State of Afghanistan  

Newsletter III-32, 1993-07-25 ammendment
  Kyrgyzstan, changing information not included in this file. Offical name
  change to Kyrgyz Republic

Newsletter III-59, 1994-01-26
  Andorra, changing information not included in this file. Offical name
  change to Pricipality of Andorra

Newsletter III-60, 1994-01-26
  Cambodia, changing information not included in this file. Offical name
  change to Kingdom of Cambodia

Announcement, 1994-02-02
  At this point the fourth edition of ISO 3166 appears. It can *now* be
  ordered from national standards institutions. 
  The RIPE NCC will continue tracking changes.

Newsletter IV-1, 1996-04-03
  Vatican, change name from VATICAN CITY STATE (HOLY SEE) to
  HOLY SEE (VATICAN CITY STATE)

Annual Report 1996, 1996-12-20
  No further changes have been made to 3166-IV.

  The fifth edition will consist of three parts:
  3166-1 country codes / DIS published April 96 / IS expected summer|fall 97
  "The list of country names remains basically unchanged."
  3166-2 country subdivision code / DIS published November 1996
  3166-3 Code for formerly used names of countries / DIS expected spring 97

  Quote: We are delighted to notice that the acceptance of ISO3166 among
  users of country codes is growing.  However, the use of ISO3166 e.g. in
  the Internet confronts ISO3166/MA with formerly unknown problems.  One
  among these problems is that more and more "non-country-entities" as
  e.g. organisations, interest groups or groupings of countries request
  ISO3166 code elements.  The scope of the standard does not allow for
  allocation of code elements to such "groups". 

Newsletter IV-2 1997-07-14
  ZAIRE (ZA) changed to CONGO, THE DEMOCRATIC REPUBLIC OF THE  (CD)
  change of name, alpha-2 and alpha-3, numeric remains 180

  3166-1 is now expected to be published by August/September 1997

Above is older one, latest edition is from 16-10-2006.

Kind regards,
tesu

Votes + Comments
Good work
0

Those are country codes, he was asking for nationalities. My country is The Netherlands but my nationality is Dutch. Also, the nationality is different in each language. This is probably the reason that there is no standard yet.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.