Tool - 全球國家列表

同事跟我要「全球國家」的資料,剛好有整理過這方面的資料,應該其他人也會有這方面的需求,就分享給大家,此資料參考 http://en.wikipedia.org/wiki/ISO_3166-1 製作。

全球國家列表(含2簡碼,3簡碼,3數字碼)
CountryId Name Alpha2 Alpha3 Numeric3
1 Afghanistan AF AFG 004
2 Åland Islands AX ALA 248
3 Albania AL ALB 008
4 Algeria DZ DZA 012
5 American Samoa AS ASM 016
6 Andorra AD AND 020
7 Angola AO AGO 024
8 Anguilla AI AIA 660
9 Antarctica AQ ATA 010
10 Antigua and Barbuda AG ATG 028
11 Argentina AR ARG 032
12 Armenia AM ARM 051
13 Aruba AW ABW 533
14 Australia AU AUS 036
15 Austria AT AUT 040
16 Azerbaijan AZ AZE 031
17 Bahamas BS BHS 044
18 Bahrain BH BHR 048
19 Bangladesh BD BGD 050
20 Barbados BB BRB 052
21 Belarus BY BLR 112
22 Belgium BE BEL 056
23 Belize BZ BLZ 084
24 Benin BJ BEN 204
25 Bermuda BM BMU 060
26 Bhutan BT BTN 064
27 Bolivia, Plurinational State of BO BOL 068
28 Bonaire, Saint Eustatius and Saba BQ BES 535
29 Bosnia and Herzegovina BA BIH 070
30 Botswana BW BWA 072
31 Bouvet Island BV BVT 074
32 Brazil BR BRA 076
33 British Indian Ocean Territory IO IOT 086
34 Brunei Darussalam BN BRN 096
35 Bulgaria BG BGR 100
36 Burkina Faso BF BFA 854
37 Burundi BI BDI 108
38 Cambodia KH KHM 116
39 Cameroon CM CMR 120
40 Canada CA CAN 124
41 Cape Verde CV CPV 132
42 Cayman Islands KY CYM 136
43 Central African Republic CF CAF 140
44 Chad TD TCD 148
45 Chile CL CHL 152
46 China CN CHN 156
47 Christmas Island CX CXR 162
48 Cocos (Keeling) Islands CC CCK 166
49 Colombia CO COL 170
50 Comoros KM COM 174
51 Congo CG COG 178
52 Congo, the Democratic Republic of the CD COD 180
53 Cook Islands CK COK 184
54 Costa Rica CR CRI 188
55 Côte d'Ivoire CI CIV 384
56 Croatia HR HRV 191
57 Cuba CU CUB 192
58 Curaçao CW CUW 531
59 Cyprus CY CYP 196
60 Czech Republic CZ CZE 203
61 Denmark DK DNK 208
62 Djibouti DJ DJI 262
63 Dominica DM DMA 212
64 Dominican Republic DO DOM 214
65 Ecuador EC ECU 218
66 Egypt EG EGY 818
67 El Salvador SV SLV 222
68 Equatorial Guinea GQ GNQ 226
69 Eritrea ER ERI 232
70 Estonia EE EST 233
71 Ethiopia ET ETH 231
72 Falkland Islands (Malvinas) FK FLK 238
73 Faroe Islands FO FRO 234
74 Fiji FJ FJI 242
75 Finland FI FIN 246
76 France FR FRA 250
77 French Guiana GF GUF 254
78 French Polynesia PF PYF 258
79 French Southern Territories TF ATF 260
80 Gabon GA GAB 266
81 Gambia GM GMB 270
82 Georgia GE GEO 268
83 Germany DE DEU 276
84 Ghana GH GHA 288
85 Gibraltar GI GIB 292
86 Greece GR GRC 300
87 Greenland GL GRL 304
88 Grenada GD GRD 308
89 Guadeloupe GP GLP 312
90 Guam GU GUM 316
91 Guatemala GT GTM 320
92 Guernsey GG GGY 831
93 Guinea GN GIN 324
94 Guinea-Bissau GW GNB 624
95 Guyana GY GUY 328
96 Haiti HT HTI 332
97 Heard Island and McDonald Islands HM HMD 334
98 Holy See (Vatican City State) VA VAT 336
99 Honduras HN HND 340
100 Hong Kong HK HKG 344
101 Hungary HU HUN 348
102 Iceland IS ISL 352
103 India IN IND 356
104 Indonesia ID IDN 360
105 Iran, Islamic Republic of IR IRN 364
106 Iraq IQ IRQ 368
107 Ireland IE IRL 372
108 Isle of Man IM IMN 833
109 Israel IL ISR 376
110 Italy IT ITA 380
111 Jamaica JM JAM 388
112 Japan JP JPN 392
113 Jersey JE JEY 832
114 Jordan JO JOR 400
115 Kazakhstan KZ KAZ 398
116 Kenya KE KEN 404
117 Kiribati KI KIR 296
118 Korea, Democratic People's Republic of KP PRK 408
119 Korea, Republic of KR KOR 410
120 Kuwait KW KWT 414
121 Kyrgyzstan KG KGZ 417
122 Lao People's Democratic Republic LA LAO 418
123 Latvia LV LVA 428
124 Lebanon LB LBN 422
125 Lesotho LS LSO 426
126 Liberia LR LBR 430
127 Libyan Arab Jamahiriya LY LBY 434
128 Liechtenstein LI LIE 438
129 Lithuania LT LTU 440
130 Luxembourg LU LUX 442
131 Macao MO MAC 446
132 Macedonia, the former Yugoslav Republic of MK MKD 807
133 Madagascar MG MDG 450
134 Malawi MW MWI 454
135 Malaysia MY MYS 458
136 Maldives MV MDV 462
137 Mali ML MLI 466
138 Malta MT MLT 470
139 Marshall Islands MH MHL 584
140 Martinique MQ MTQ 474
141 Mauritania MR MRT 478
142 Mauritius MU MUS 480
143 Mayotte YT MYT 175
144 Mexico MX MEX 484
145 Micronesia, Federated States of FM FSM 583
146 Moldova, Republic of MD MDA 498
147 Monaco MC MCO 492
148 Mongolia MN MNG 496
149 Montenegro ME MNE 499
150 Montserrat MS MSR 500
151 Morocco MA MAR 504
152 Mozambique MZ MOZ 508
153 Myanmar MM MMR 104
154 Namibia NA NAM 516
155 Nauru NR NRU 520
156 Nepal NP NPL 524
157 Netherlands NL NLD 528
158 New Caledonia NC NCL 540
159 New Zealand NZ NZL 554
160 Nicaragua NI NIC 558
161 Niger NE NER 562
162 Nigeria NG NGA 566
163 Niue NU NIU 570
164 Norfolk Island NF NFK 574
165 Northern Mariana Islands MP MNP 580
166 Norway NO NOR 578
167 Oman OM OMN 512
168 Pakistan PK PAK 586
169 Palau PW PLW 585
170 Palestinian Territory, Occupied PS PSE 275
171 Panama PA PAN 591
172 Papua New Guinea PG PNG 598
173 Paraguay PY PRY 600
174 Peru PE PER 604
175 Philippines PH PHL 608
176 Pitcairn PN PCN 612
177 Poland PL POL 616
178 Portugal PT PRT 620
179 Puerto Rico PR PRI 630
180 Qatar QA QAT 634
181 Réunion RE REU 638
182 Romania RO ROU 642
183 Russian Federation RU RUS 643
184 Rwanda RW RWA 646
185 Saint Barthélemy BL BLM 652
186 Saint Helena, Ascension and Tristan da Cunha SH SHN 654
187 Saint Kitts and Nevis KN KNA 659
188 Saint Lucia LC LCA 662
189 Saint Martin (French part) MF MAF 663
190 Saint Pierre and Miquelon PM SPM 666
191 Saint Vincent and the Grenadines VC VCT 670
192 Samoa WS WSM 882
193 San Marino SM SMR 674
194 Sao Tome and Principe ST STP 678
195 Saudi Arabia SA SAU 682
196 Senegal SN SEN 686
197 Serbia RS SRB 688
198 Seychelles SC SYC 690
199 Sierra Leone SL SLE 694
200 Singapore SG SGP 702
201 Sint Maarten (Dutch part) SX SXM 534
202 Slovakia SK SVK 703
203 Slovenia SI SVN 705
204 Solomon Islands SB SLB 090
205 Somalia SO SOM 706
206 South Africa ZA ZAF 710
207 South Georgia and the South Sandwich Islands GS SGS 239
208 Spain ES ESP 724
209 Sri Lanka LK LKA 144
210 Sudan SD SDN 736
211 Suriname SR SUR 740
212 Svalbard and Jan Mayen SJ SJM 744
213 Swaziland SZ SWZ 748
214 Sweden SE SWE 752
215 Switzerland CH CHE 756
216 Syrian Arab Republic SY SYR 760
217 Taiwan, Province of China TW TWN 158
218 Tajikistan TJ TJK 762
219 Tanzania, United Republic of TZ TZA 834
220 Thailand TH THA 764
221 Timor-Leste TL TLS 626
222 Togo TG TGO 768
223 Tokelau TK TKL 772
224 Tonga TO TON 776
225 Trinidad and Tobago TT TTO 780
226 Tunisia TN TUN 788
227 Turkey TR TUR 792
228 Turkmenistan TM TKM 795
229 Turks and Caicos Islands TC TCA 796
230 Tuvalu TV TUV 798
231 Uganda UG UGA 800
232 Ukraine UA UKR 804
233 United Arab Emirates AE ARE 784
234 United Kingdom GB GBR 826
235 United States US USA 840
236 United States Minor Outlying Islands UM UMI 581
237 Uruguay UY URY 858
238 Uzbekistan UZ UZB 860
239 Vanuatu VU VUT 548
240 Venezuela, Bolivarian Republic of VE VEN 862
241 Viet Nam VN VNM 704
242 Virgin Islands, British VG VGB 092
243 Virgin Islands, U.S. VI VIR 850
244 Wallis and Futuna WF WLF 876
245 Western Sahara EH ESH 732
246 Yemen YE YEM 887
247 Zambia ZM ZMB 894
248 Zimbabwe ZW ZWE 716

另外我也幫各位準備好Excel檔:


內含 Excel 2003, Excel 2007 兩個格式的檔案,方便各方直接「匯入」資料庫使用。有需要者,請自行取用。

參考:

2 則留言:

  1. 序號217是怎麼回事?

    回覆刪除
    回覆
    1. 我有列出資料來源,有問題請自行修改。
      我只是整理成 Excel。

      刪除

感謝您的留言,如果我的文章你喜歡或對你有幫助,按個「讚」或「分享」它,我會很高興的。