| 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 |