Field | Type | Description | Key |
---|---|---|---|
ISO | varchar(2) | ISO-3166-1 country code | PK |
Country | nvarchar(45) | Country name | |
Format | varchar(10) | Format | |
Denomination | nvarchar(30) | Denomination | |
Regex | varchar(150) | Regular expression |
ISO | Country | Format | Single | Denomination | |
---|---|---|---|---|---|
AF | Afghanistan | 9999 | Post code | ||
AX | Åland Islands | 99999 | Postcode | ||
AL | Albania | 9999 | Kodi postar | ||
DZ | Algeria | 99999 | Code postal | ||
AS | American Samoa | 99999 | Zip Code (US) | ||
AD | Andorra | AA999 | Código postal | ||
AO | Angola | - | |||
AI | Anguilla | AI-9999 | AI-2640 | Post code | |
AQ | Antarctica | 9999 | 7151 | Postcode | |
AG | Antigua and Barbuda | 99999 | Post code | ||
AR | Argentine | A9999AAA | CPA | ||
AM | Armenia | 9999 | Postal index | ||
AW | Aruba | 9999 AW | 0000 AW | postcode (NL) | |
AU | Australia | 9999 | Postcode | ||
AT | Austria | 9999 | PLZ | ||
AZ | Azerbaijan | AA 9999 | İndeks | ||
BS | Bahamas | - | |||
BH | Bahrain | 9999 | Post code | ||
BD | Bangladesh | 9999 | Post code | ||
BB | Barbados | AA99999 | Postal code | ||
BY | Belarus | 999999 | Индекс | ||
BE | Belgium | 9999 | Code postal | ||
BZ | Belize | - | |||
BJ | Benin | - | |||
BM | Bermuda | AA 99 | Post codes | ||
BT | Bhutan | 99999 | Post code | ||
BO | Bolivia | - | |||
BQ | Bonaire, Sint Eustatius, Saba | 9999 AA | 0000 BQ | Postcode | |
BA | Bosnia and Herzegovina | 99999 | Poštanski broj | ||
BW | Botswana | - | |||
BV | Bouvet Island | - | |||
BR | Brazil | 99999-999 | CEP | ||
IO | British Indian Ocean Territory | AA9A 1AA | BB9D ZZ1 | Postcode | |
VG | British Virgin Islands | AA9999 | Postal code | ||
BN | Brunei Darussalam | AA9999 | Kod | ||
BG | Bulgaria | 9999 | Пощенски код | ||
BF | Burkina Faso | - | |||
BI | Burundi | - | |||
KH | Cambodia | 99999 | Postal code | ||
CM | Cameroon | - | |||
CA | Canada | A9A 9A9 | Post code | ||
CV | Cape Verde | 9999 | CIP | ||
KY | Cayman Islands | AA9-9999 | Postcode (UK) | ||
CF | Central African Republic | - | |||
TD | Chad | 99999 | Postal code | ||
CL | Chile | 9999999 | Código postal | ||
CN | China | 999999 | 郵政編碼 | ||
CX | Christmas Island | 9999 | 6978 | Postcode | |
CP | Clipperton Island | 99999 | 98799 | Code postal | |
CC | Cocos (Keeling) Islands | 9999 AA | 9799 W3 | Post code | |
CO | Colombia | 999999 | Código postal | ||
KM | Comoros | - | |||
CG | Congo (Brazzville) | - | |||
CD | Congo DR | - | |||
CK | Cook Islands | - | |||
CR | Costa Rica | 99999 | Código postal | ||
HR | Croatia | 99999 | Zip | ||
CU | Cuba | 99999 | Código postal | ||
CW | Curacao | 9999 AA | 0000 CW | Postcode (NL) | |
CY | Cyprus | 9999 | Postcode | ||
CZ | Czech Republic | 999 99 | PSČ | ||
DK | Denmark | 9999 | Postnumre | ||
DJ | Djibouti | - | |||
DM | Dominica | - | |||
DO | Dominican Republic | 99999 | Código postal | ||
TL | East Timor | - | PCode | ||
EC | Ecuador | 999999 | Código postal | ||
EG | Egypt | 99999 | الرمز البريدي | ||
SV | El Salvador | 9999 | Código postal | ||
GQ | Equatorial Guinea | - | |||
ER | Eritrea | - | |||
EE | Estonia | 99999 | Postiindeks | ||
SZ | Eswatini | A999 | Postal code | ||
ET | Ethiopia | 9999 | Postal code | ||
FK | Falkland Islands (Malvinas) | AAAA 9AA | FIQQ 1ZZ | Postcode | |
FO | Faroe Islands | 999 | Postnumre (DK) | ||
FJ | Fiji | - | |||
FI | Finland | 99999 | Postinumero | ||
FR | France | 99999 | Code postal | ||
GF | French Guiana | 99999 | 97399 | Code postal (FR) | |
PF | French Polynesia | 99999 | 98799 | Code postal (FR) | |
TF | French Southern Territories | 99999 | Code postal | ||
GA | Gabon | - | |||
GM | Gambia | - | |||
GE | Georgia | 9999 | Post code | ||
DE | Germany | 99999 | PLZ | ||
GH | Ghana | - | |||
GI | Gibraltar | AA99 9AA | GX11 1AA | Postcode (UK) | |
GR | Greece | 999 99 | T.K. | ||
GL | Greenland | 9999 | Postnumre (DK) | ||
GD | Grenada | - | |||
GP | Guadeloupe | 99999 | Code postal (FR) | ||
GU | Guam | 99999 | Zip Code (US) | ||
GT | Guatemala | 99999 | Código postal | ||
GG | Guernsey | AA9 9AA | GY9 9AA | Postcode (UK) | |
GN | Guinea | 999 | Code postal | ||
GW | Guinea-Bissau | 9999 | Código postal | ||
GY | Guyana | - | |||
HT | Haiti | 9999 | Code postal | ||
HM | Heard and McDonald | 9999 | 7151 | Postcode | |
HN | Honduras | 99999 | Código postal | ||
HK | Hong Kong | 999999 | 999077 | 郵政編碼 | |
HU | Hungary | 9999 | Irányítószám | ||
IS | Iceland | 999 | Póstnúmer | ||
IN | India | 999999 | PIN code | ||
ID | Indonesia | 99999 | Kodepos | ||
IR | Iran | 99999 | کد پستی | ||
IQ | Iraq | 99999 | Postal code | ||
IE | Ireland | - | |||
IM | Isle of Man | AA99 9AA | IM99 9AA | Postcode (UK) | |
IL | Israel | 9999999 | Postal code | ||
IT | Italy | 99999 | CAP | ||
CI | Ivory Coast | - | |||
JM | Jamaica | AAAAA99 | Postal code | ||
JP | Japan | 999-9999 | 郵便番号 | ||
JE | Jersey | AA9 9AA | JE9 9AA | Postcode (UK) | |
JO | Jordan | 99999 | Postal code | ||
KZ | Kazakhstan | 999999 | Почтового индекса | ||
KE | Kenya | 99999 | Postal code | ||
KI | Kiribati | - | |||
XK | Kosovo | 99999 | Поштански код | ||
KW | Kuwait | 99999 | Postal code | ||
KG | Kyrgyzstan | 999999 | Почтовый индекс | ||
LA | Laos | 99999 | Postal code | ||
LV | Latvia | AA-9999 | Pasta indekss | ||
LB | Lebanon | 9999 | Code postal | ||
LS | Lesotho | 999 | Postal code | ||
LR | Liberia | 9999 | Postal code | ||
LY | Libya | 99999 | Postal code | ||
LI | Liechtenstein | 9999 | PLZ (CH) | ||
LT | Lithuania | 99999 | Pašto kodas | ||
LU | Luxembourg | 9999 | Code postal | ||
MO | Macau | 999999 | 999078 | $郵政編碼 | |
MK | Macedonia | 9999 | Поштенски код | ||
MG | Madagascar | 999 | Code postal | ||
MW | Malawi | - | |||
MY | Malaysia | 99999 | Postal code | ||
MV | Maldives | 99999 | Post code | ||
ML | Mali | - | |||
MT | Malta | AAA 9999 | Kodiċi Postali | ||
MH | Marshall Islands | 99999 | ZIP code (US) | ||
MQ | Martinique | 99999 | Code postal (FR) | ||
MR | Mauritania | - | |||
MU | Mauritius | A9999 | Post code | ||
YT | Mayotte | 99999 | Code postal (FR) | ||
MX | Mexico | 99999 | Código postal | ||
FM | Micronesia | 99999 | Zip code (US) | ||
MD | Moldova | 9999 | Coduri poştale | ||
MC | Monaco | 99999 | Code postal (FR) | ||
MN | Mongolia | 99999 | Zipcode | ||
ME | Montenegro | 99999 | Поштански код | ||
MS | Montserrat | AAA9999 | Post code | ||
MA | Morocco | 99999 | Code postal | ||
MZ | Mozambique | 9999 | Código postal | ||
MM | Myanmar | 99999 | Postal code | ||
NA | Namibia | - | |||
NR | Nauru | - | |||
NP | Nepal | 99999 | Postal code | ||
NL | Netherlands | 9999 AA | Postcode | ||
AN | Netherlands Antilles | - | |||
NC | New Caledonia | 99999 | Code postal (FR) | ||
NZ | New Zealand | 9999 | Postcode | ||
NI | Nicaragua | 99999 | Código postal | ||
NE | Niger | 9999 | Code postal | ||
NG | Nigeria | 999999 | Postal code | ||
NU | Niue | - | |||
NF | Norfolk Island | 9999 | 2899 | Post code | |
KP | North Korea | - | |||
MP | Northern Mariana Islands | 99999 | Zip Code (US) | ||
NO | Norway | 9999 | Postnummer | ||
OM | Oman | 999 | Postal code | ||
PK | Pakistan | 99999 | Post code | ||
PW | Palau | 99999 | 96940 | Postal code | |
PS | Palestine | P9990000 | Post code | ||
PA | Panama | - | |||
PG | Papua New Guinea | 999 | Postal code | ||
PY | Paraguay | 9999 | Código postal | ||
PE | Peru | 99999 | Código postal | ||
PH | Philippines | 9999 | Zipcode | ||
PN | Pitcairn | AAA9 1AA | PCR9 1ZZ | Post code | |
PL | Poland | 99-999 | Kod pocztowy | ||
PT | Portugal | 9999-999 | Código postal | ||
PR | Puerto Rico | 99999 | ZIP code (US) | ||
QA | Qatar | - | |||
RE | Réunion | 99999 | Code postal (FR) | ||
RO | Romania | 999999 | Cod poştal | ||
RU | Russia | 999999 | Почтовый индекс | ||
RW | Rwanda | - | |||
EH | Sahrawi Arab | 99999 | Code postal (MA) | ||
BL | Saint Barthelme | 99999 | Code postal (FR) | ||
KN | Saint Kitts and Nevis | - | |||
LC | Saint Lucia | - | |||
MF | Saint Martin | 99999 | Code postal (FR) | ||
PM | Saint Pierre And Miquelon | 99999 | Code postal (FR) | ||
VC | Saint Vincent and the Grenadines | AA9999 | Postal code | ||
WS | Samoa | 99999 | Postal code | ||
SM | San Marino | 99999 | CAP (IT) | ||
SH | Santa Helena, Ascension and Tristan Da Cunha | AAAA 1AA | ASCN 1ZZ | Postcode (UK) | |
ST | São Tomé and Príncipe | - | |||
SA | Saudi Arabia | 99999-9999 | Postal code | ||
SN | Senegal | 99999 | Code postal | ||
RS | Serbia | 99999 | Поштански код | ||
SC | Seychelles | - | |||
SL | Sierra Leone | - | |||
SG | Singapore | 999999 | Postal code | ||
SX | Sint Maarten | 9999 AA | 0000 AA | Post code | |
SK | Slovakia | 999 99 | PSČ | ||
SI | Slovenia | 9999 | Poštna številka | ||
SB | Solomon Islands | - | |||
SO | Somalia | - | |||
ZA | South Africa | 9999 | Postal code | ||
GS | South Georgia & Sandwich | AAAA 9AA | SIQQ 1ZZ | Post code | |
KR | South Korea | 99999 | 우편번호 | ||
SS | South Sudan | 99999 | Postal code | ||
ES | Spain | 99999 | Código postal | ||
LK | Sri Lanka | 99999 | Postcode | ||
SD | Sudan | 99999 | Postal code | ||
SR | Suriname | - | |||
SJ | Svalbard and Jan Mayen | 9999 | Postnummer (NO) | ||
SE | Sweden | 999 99 | Postnummer | ||
CH | Switzerland | 9999 | PLZ / Code postal | ||
SY | Syria | - | |||
TW | Taiwan | 99999 | 郵遞區號 | ||
TJ | Tajikistan | 999 | Нишонаи почта | ||
TZ | Tanzania | 99999 | Postal code | ||
TH | Thailand | 99999 | รหัสไปรษณีย์ | ||
TG | Togo | - | |||
TK | Tokelau | - | |||
TO | Tonga | - | |||
TT | Trinidad and Tobago | - | |||
TN | Tunisia | 9999 | Code postal | ||
TR | Turkey | 99999 | Posta kodu | ||
TM | Turkmenistan | 999999 | Почтовый индекс | ||
TC | Turks and Caicos Islands | AAAA 1AA | TKCA 1ZZ | Postcode (UK) | |
TV | Tuvalu | - | |||
VI | U.S. Virgin Islands | 99999 | Zip Code (US) | ||
UG | Uganda | - | |||
UA | Ukraine | 99999 | Поштовий індекс | ||
AE | United Arab Emirates | - | |||
GB | United Kingdom | A?99 9AA | Postcode | ||
US | United States | 99999-9999 | ZIP code | ||
UY | Uruguay | 99999 | Código postal | ||
UM | US Minor Outlying Islands | 96898 | |||
UZ | Uzbekistan | 999999 | Почтовый индекс | ||
VU | Vanuatu | - | |||
VA | Vatican City State | 999 | 120 | CAP (IT) | |
VE | Venezuela | 9999 | Código postal | ||
VN | Viet Nam | 999999 | Mã bưu chính | ||
WF | Wallis and Futuna | 99999 | Code postal (FR) | ||
YE | Yemen | - | |||
ZM | Zambia | 99999 | Postal code | ||
ZW | Zimbabwe | - |
Reference data |
---|
Administrative divisions |
Countries |
Countries names |
Currencies |
Languages |
Postal codes format |
Time Zones |
Formulas & samples |
---|
Distance between points |
Locate points in a radius |
Find postal code of a point |