World Country ZIP codes, Country ZIP & GPS

This file consists of ZIP / Postal codes of 85 countries with according GPS locations
Different countries have a different system of postal codes
Some have space (” “), hyphen (“-“), or letters in ZIP code

Dataset is free for download from the link above.

Dataset is under Creative Commons license
Note: This dataset is Huge – 1.048.576 rows, filesize 91 MB

Special cases about ZIP codes
Postal codes are not globally unique. For example, the same postal code 1003 is used in countries AU, DK, CH, NO, PH
To gain the unique code, you need to join together 2-char country code and ZIP code, like AU_1003

Our CDS experience in ZIP & GPS locations
During our work with ZIP & GPS locations, we have found, that ZIP code is often not written incorrect format
For example country SK – Slovakia has official format 010 01, but in database were often incorrect 01001
Due to that is easier to remove spaces (” “) and hyphen (“-“) from codes than to add them,
we have created special column joining 2-char Country code & “_” & ZIP code (example SK_01001)
and removed all spaces (” “) and hyphen (“-“) from it except codes for Brazil (BR_69960-000)

CDS contribution – Adding Country ZIP with extracted characters
Country ZIP format
Country & “_” & ZIP code (with extracted spaces and “-“)
To use Country ZIP extract (spaces ” ” and “-” for all countries except Brazil (BR))
For Brazil (BR) we recommend shortening the ZIP code to the first 5 digits (Original BR code has 8 numeric digits, but only 5 are used for GEO)

List of special formatted ZIP codes

French codes (France & provinces of France)
France have often CEDEX word behind ZIP code. CEDEX means “business mail with special delivery”, designed for recipients of large volumes of mail.
CEDEX may have forms CEDEX or CEDEX with number
France also uses codes AIR, SP 07 and CITYSSIMO behind ZIP code

This dataset on CoronaDataSource consist
Sheets & tables:
Main – About data
Data – Main Data sheets
CountryCodesUsed – List of used country codes
tbl_CountryZipGPS – table name of Data sheet (In XLSX only)
tbl_CountryCodesUsed – table name of country codes (In XLSX only)
tbl_ExceptionsZIPcodes – table name of Exceptions in ZIP Codes (In XLSX only)
tbl_ExceptionFrenchCodes – table name of exceptions in French codes (In XLSX only)

Type of structure of DATA table: Classic table

ZIP codes of countries used in this dataset

Created by CDS – CoronaDataSource specialists by cleaning opendatasoft.com sources

Original data source:
https://data.opendatasoft.com/

Original data downloaded from:
https://data.opendatasoft.com/explore/dataset/geonames-postal-code%40public-us/export/?sort=place_name