Full Database of city state country available in JSON, SQL, XML, YAML & CSV format. All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.
🎉 Introducing API for Countries States Cities Database.
- JSON
- SQL
- XML
- YAML
- CSV
File | JSON | SQL | XML | YAML | CSV |
---|---|---|---|---|---|
Countries | ✅ | ✅ | ✅ | ✅ | ✅ |
States | ✅ | ✅ | ✅ | ✅ | ✅ |
Cities | ✅ | ✅ | ✅ | ✅ | ✅ |
Country+States | ✅ | NA | ✅ | ✅ | NA |
Country+Cities | ✅ | NA | ✅ | ✅ | NA |
State+Cities | ✅ | NA | ✅ | ✅ | NA |
Country+State+Cities/World | ✅ | ✅ | ✅ | ✅ | NA |
https://dr5hn.github.io/countries-states-cities-database/
Total Countries : 250
Total States/Regions/Municipalities : 4,989
Total Cities/Towns/Districts : 150,710
Last Updated On : 13th Nov 2022
I usually update API's database once a quarter.
Upcoming API Database Update Date: 3rd December 2022
Please Note: Even if you've urgency or you're running this API in Production and you find some data missing, the API Database update dates won't be changed at any circumstances.
This Countries States Cities Database is made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.
Contribute towards better earth buy the world a tree
As always, thanks to our amazing contributors!
Made with contrib.rocks.
Find this project on data.world
Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com
That's all Folks. Enjoy.