国际标准之国家编码 - ISO 3166

ISO 3166定义了各个国家的英文名字的字母缩写,2个大写字母。

而且小写的2个字母用来表示html网页的顶级域名。

ISO

Country

AD

Andorra

AE

United Arab Emirates

AF

Afghanistan

AG

Antigua And Barbuda

AI

Anguilla

AL

Albania

AM

Armenia

AN

Netherlands Antilles

AO

Angola

AQ

Antarctica

AR

Argentina

AS

American Samoa

AT

Austria

AU

Australia

AW

Aruba

AX

land Islands

AZ

Azerbaijan

BA

Bosnia and Herzegovina

BB

Barbados

BD

Bangladesh

BE

Belgium

BF

Burkina Faso

BG

Bulgaria

BH

Bahrain

BI

Burundi

BJ

Benin

BL

Saint BarthŽlemy

BM

Bermuda

BN

Brunei Darussalam

BO

Bolivia, Plurinational State of

BR

Brazil

BS

Bahamas

BT

Bhutan

BV

Bouvet Island

BW

Botswana

BY

Belarus

BZ

Belize

CA

Canada

CC

Cocos (Keeling) Islands

CD

Congo, The Democratic Republic of The

CF

Central African Republic

CG

Congo

CH

Switzerland

CI

C™te d'Ivoire

CK

Cook Islands

CL

Chile

CM

Cameroon

CN

China

CO

Colombia

CR

Costa Rica

CU

Cuba

CV

Cape Verde

CX

Christmas Island

CY

Cyprus

CZ

Czech Republic

DE

Germany

DJ

Djibouti

DK

Denmark

DM

Dominica

DO

Dominican Republic

DZ

Algeria

EC

Ecuador

EE

Estonia

EG

Egypt

EH

Western Sahara

ER

Eritrea

ES

Spain

ET

Ethiopia

EU

Europe (SSGFI only)

FI

Finland

FJ

Fiji

FK

Falkland Islands (Malvinas)

FM

Micronesia, Federated States of

FO

Faroe Islands

FR

France

GA

Gabon

GB

United Kingdom

GD

Grenada

GE

Georgia

GF

French Guiana

GG

Guernsey

GH

Ghana

GI

Gibraltar

GL

Greenland

GM

Gambia

GN

Guinea

GP

Guadeloupe

GQ

Equatorial Guinea

GR

Greece

GS

South Georgia And The South Sandwich Islands

GT

Guatemala

GU

Guam

GW

Guinea-Bissau

GY

Guyana

HK

Hong Kong

HM

Heard Island and Mcdonald Islands

HN

Honduras

HR

Croatia

HT

Haiti

HU

Hungary

ID

Indonesia

IE

Ireland

II

International (SSGFI only)

IL

Israel

IM

Isle of Man

IN

India

IO

British Indian Ocean Territory

IQ

Iraq

IR

Iran, Islamic Republic of

IS

Iceland

IT

Italy

JE

Jersey

JM

Jamaica

JO

Jordan

JP

Japan

KE

Kenya

KG

Kyrgyzstan

KH

Cambodia

KI

Kiribati

KM

Comoros

KN

Saint Kitts And Nevis

KP

Korea, Democratic People's Republic of

KR

Korea, Republic of

KW

Kuwait

KY

Cayman Islands

KZ

Kazakhstan

LA

Lao People's Democratic Republic

LB

Lebanon

LC

Saint Lucia

LI

Liechtenstein

LK

Sri Lanka

LR

Liberia

LS

Lesotho

LT

Lithuania

LU

Luxembourg

LV

Latvia

LY

Libyan Arab Jamahiriya

MA

Morocco

MC

Monaco

MD

Moldova, Republic of

ME

Montenegro

MF

Saint Martin

MG

Madagascar

MH

Marshall Islands

MK

Macedonia, The Former Yugoslav Republic of

ML

Mali

MM

Myanmar

MN

Mongolia

MO

Macao

MP

Northern Mariana Islands

MQ

Martinique

MR

Mauritania

MS

Montserrat

MT

Malta

MU

Mauritius

MV

Maldives

MW

Malawi

MX

Mexico

MY

Malaysia

MZ

Mozambique

NA

Namibia

NC

New Caledonia

NE

Niger

NF

Norfolk Island

NG

Nigeria

NI

Nicaragua

NL

Netherlands

NO

Norway

NP

Nepal

NR

Nauru

NU

Niue

NZ

New Zealand

OM

Oman

PA

Panama

PE

Peru

PF

French Polynesia

PG

Papua New Guinea

PH

Philippines

PK

Pakistan

PL

Poland

PM

Saint Pierre And Miquelon

PN

Pitcairn

PR

Puerto Rico

PS

Palestinian Territory, Occupied

PT

Portugal

PW

Palau

PY

Paraguay

QA

Qatar

RE

Réunion

RO

Romania

RS

Serbia

RU

Russian Federation

RW

Rwanda

SA

Saudi Arabia

SB

Solomon Islands

SC

Seychelles

SD

Sudan

SE

Sweden

SG

Singapore

SH

Saint Helena

SI

Slovenia

SJ

Svalbard and Jan Mayen

SK

Slovakia

SL

Sierra Leone

SM

San Marino

SN

Senegal

SO

Somalia

SR

Suriname

ST

Sao Tome And Principe

SV

El Salvador

SY

Syrian Arab Republic

SZ

Swaziland

TC

Turks And Caicos Islands

TD

Chad

TF

French Southern Territories

TG

Togo

TH

Thailand

TJ

Tajikistan

TK

Tokelau

TL

Timor-Leste

TM

Turkmenistan

TN

Tunisia

TO

Tonga

TR

Turkey

TT

Trinidad And Tobago

TV

Tuvalu

TW

Taiwan, Province of China

TZ

Tanzania, United Republic of

UA

Ukraine

UG

Uganda

UM

United States Minor Outlying Islands

US

United States

UY

Uruguay

UZ

Uzbekistan

VA

Holy See (Vatican City State)

VC

Saint Vincent And The Grenadines

VE

Venezuela, Bolivarian Republic of

VG

Virgin Islands, British

VI

Virgin Islands, U.S.

VN

Viet Nam

VU

Vanuatu

WF

Wallis and Futuna

WS

Samoa

YE

Yemen

YT

Mayotte

ZA

South Africa

ZM

Zambia

ZW

Zimbabwe

 

  • 2
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
最新最完整的中英法文ISO3166世界行政区划MySQL级联表,包含中国 -- -- 表的结构 `API_location_country` -- CREATE TABLE `API_location_country` ( `id` int(11) NOT NULL, `name_en` varchar(255) DEFAULT NULL COMMENT '英文名', `name_zh-Hans` varchar(255) DEFAULT NULL COMMENT '简体中文名', `name_fr` varchar(255) NOT NULL COMMENT ‘法文名', `a2code` varchar(2) NOT NULL, `a3code` varchar(3) NOT NULL COMMENT 'alpha3 code', `numberic` int(3) NOT NULL, `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='国家'; -- -- 转存表中的数据 `API_location_country` -- INSERT INTO `API_location_country` (`id`, `name_en`, `name_zh-Hans`, `name_fr`, `a2code`, `a3code`, `numberic`, `last_modified`) VALUES (1, 'Afghanistan', '阿富汗', 'Afghanistan (l\')', 'AF', 'AFG', 4, '2017-11-06 16:48:14'); -- -- -- 表的结构 `API_location_state` -- CREATE TABLE `API_location_state` ( `id` int(11) NOT NULL, `name_en` varchar(50) DEFAULT NULL COMMENT '英文名', `name_zh-Hans` varchar(255) DEFAULT NULL COMMENT '简体中文名', `code` varchar(50) DEFAULT NULL COMMENT '代号', `countryId` int(11) DEFAULT NULL COMMENT '所属国家', `checked` int(1) DEFAULT '0' COMMENT '是否有子类0表示有1表示无' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='二级行政区'; -- -- 转存表中的数据 `API_location_state` -- INSERT INTO `API_location_state` (`id`, `name_en`, `name_zh-Hans`, `code`, `countryId`, `checked`) VALUES (1, 'Herat', '赫拉特', 'HEA', 1, 1), (2, 'Kabul', '喀布尔', 'KBL', 1, 1), (3, 'Kandahar', '坎大哈', 'KDH', 1, 1), (4, 'Mazar-i Sharif', '马扎里沙里夫', 'MZR', 1, 1), (5, 'Berat', '培拉特', 'BR', 3, 1), (6, 'Diber', '迪勃拉', 'DI', 3, 1), (7, 'Durres', '都拉斯', 'DR', 3, 1), (8, 'Elbasan', '爱尔巴桑', 'EL', 3, 1), (9, 'Fier', '费里', 'FR', 3, 1), (10, 'Gjirokaster', '吉诺卡斯特', 'GJ', 3, 1);

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

夜流冰

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值