🌍 Countries States Cities Database

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

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

Last Updated On : 20th February 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

Suggestions / Feedbacks

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

That's all Folks. Enjoy.