/countries-states-cities-database

🌍 World countries, states/regions, cities in JSON, SQL, XML, PLIST, YAML and CSV. All Countries, Cities, States with ISO2, ISO3, Country Code, Phone Code, Capital and Currency [Linked with Each Other By ID] [Countries-States-Cities-Database]

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.

🔍 Actively Looking for Remote Job Opportunity (Full Stack Developer with 6+ years exp.)

  • Preferred Remote location (America/Europe). Ready to work in 75% sync with Remote timezone.
  • Looking forward to grow in one of the stack [MEAN/MERN/LAMP]
  • Technologies -- (Proficient): PHP, NodeJS, AngularJS (Familiar): ReactJS, Python, Dart, Android
  • Database -- (Proficient): MySQL, MongoDB, Redis (Familiar): PostgreSQL
  • My Resume
  • Projects

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
State+Cities ✅ NA ✅ NA ✅ NA
Country+State+Cities/World ✅ ✅ ✅ NA ✅ NA

Demo

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

Insights

Total Countries : 249
Total States/Regions/Municipalities : 4,873
Total Cities/Towns/Districts : 146,155

Last Updated On : 29th November 2020

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.