/countries-states-cities-database

🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, PLIST, YAML, and CSV. All Countries, States, Cities with ISO2, ISO3, Country Code, Phone Code, Capital, Native Language, Timezones, Latitude, Longitude, Region, Subregion, Flag Emoji, and Currency. #countries #states #cities

Primary LanguagePHP

banner

🌍 Countries States Cities Database

release size

Full Database of city state country available in JSON, SQL, XML, PLIST, YAML & CSV format. All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.

API 🚀

🎉 Introducing API for Countries States Cities Database.

API Documentation

banner

Formats Available

  • JSON
  • SQL
  • XML
  • PLIST
  • YAML
  • CSV

Distribution Files Info

File JSON SQL XML PLIST YAML CSV
Countries ✅ ✅ ✅ ✅ ✅ ✅
States ✅ ✅ ✅ ✅ ✅ ✅
Cities ✅ ✅ ✅ ✅ ✅ ✅
Country+States ✅ NA ✅ NA ✅ NA
Country+Cities ✅ NA ✅ NA ✅ NA
State+Cities ✅ NA ✅ NA ✅ NA
Country+State+Cities/World ✅ ✅ ✅ NA ✅ NA

Demo

https://dr5hn.github.io/countries-states-cities-database/

Insights

Total Countries : 250
Total States/Regions/Municipalities : 4,892
Total Cities/Towns/Districts : 146,157

Last Updated On : 23rd January 2021

Notes

This Free database does not guarantee for the complete list of world
countries, states & cities.
You can manually change the spelling mistakes, duplicates
or add/edit any records, which are incorrect.

Reason behind making this repo: I ran through many websites to get
perfect combination of state, city & countries.
Some were with missing states while others with large filesize.
So I thought to get it done on my own using PHP Script.

Contributions

Contibution Guidelines

Follow me at

Github @dr5hn Twitter @dr5hn LinkedIn @dr5hn

Suggestions / Feedbacks

Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com

That's all Folks. Enjoy.