zeeshanahmad4/zip-code-of-all-countries-cities-in-the-world-csv-txt-sql-database

Zip code of all countries in the world along with cities in CSV, TXT, SQL DATABASE

Zip Code Data for All Countries and Cities in the World

This repository contains a comprehensive list of zip codes (postal codes) for countries and cities around the world. The data is available in CSV, TXT, SQL, and database formats, which you can download from Here

Zip Code Headers

The data contains the following headers:

• COUNTRY
• POSTAL_CODE
• CITY
• STATE
• SHORT_STATE
• COUNTY
• SHORT_COUNTY
• COMMUNITY
• SHORT_COMMUNITY
• LATITUDE
• LONGITUDE
• ACCURACY

You can preview the data in the following screenshot:

Feel free to use this data for your projects, If you find my GitHub repository to be useful, I would appreciate it if you could give it a star! 🌟 Your support will help this repository grow, and more people can benefit from it. Also, I love sharing updates about my journey of building products on Twitter, so please feel free to follow me at @Zeeshan_Ahmad6 there. 🐦

Countries Includes:

• Andorra
• Argentina
• American Samoa
• Austria
• Australia
• Aland Islands
• Azerbaijan
• Bangladesh
• Belgium
• Bulgaria
• Bermuda
• Brazil
• Belarus
• Canada
• Switzerland
• Chile
• Colombia
• Costa Rica
• Czech Republic
• Germany
• Denmark
• Dominican Republic
• Algeria
• Estonia
• Spain
• Finland
• Micronesia, Federated States of
• Faroe Islands
• France
• United Kingdom
• French Guiana
• Guernsey
• Greenland
• Guadeloupe
• Guatemala
• Guam
• Croatia
• Hungary
• Ireland
• Isle of Man
• India
• Iceland
• Italy
• Jersey
• Japan
• Korea (South)
• Liechtenstein
• Sri Lanka
• Lithuania
• Luxembourg
• Latvia
• Monaco
• Moldova
• Marshall Islands
• Macedonia, Republic of
• Northern Mariana Islands
• Martinique
• Malta
• Malawi
• Mexico
• Malaysia
• New Caledonia
• Netherlands
• Norway
• New Zealand
• Philippines
• Pakistan
• Poland
• Saint Pierre and Miquelon
• Puerto Rico
• Portugal
• Palau
• Réunion
• Romania
• Russian Federation
• Sweden
• Singapore
• Slovenia
• Svalbard and Jan Mayen Islands
• Slovakia
• San Marino
• Thailand
• Turkey
• Ukraine
• United States of America
• Uruguay
• Holy See (Vatican City State)
• Virgin Islands, US
• Wallis and Futuna Islands
• Mayotte
• South Africa

zip-code-of-all-countries-cities-in-the-world-csv-txt-sql-database's Issues

data feeds?

Can you explain how the file is built?

Incorrect characters sqlite File

In the SQLite DB, specifications with special characters are incorrect. See screenshot. There the characters ÖÄÜ are destroyed. in the TXT file everything is correct
Can u fix it?

Can you tell me what the Accuracy column means and how it works?

Can you tell me what the Accuracy column means and how it works? THANK YOU So much for this data. It is extremely helpful.