🌍 Countries States Cities Database
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.
API 🚀
🎉 Introducing API for Countries States Cities Database.
Available Formats
- JSON
- SQL
- XML
- YAML
- CSV
Distribution Files Info
| 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 |
Demo
https://dr5hn.github.io/countries-states-cities-database/
Insights
Total Countries : 250
Total States/Regions/Municipalities : 5,001
Total Cities/Towns/Districts : 150,889
Last Updated On : 31st Aug 2022
When's the next API Database Update day?
I usually update API's database once a quarter.
Upcoming API Database Update Date: 9th October 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.
License
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.
Make the world more Greener 🌴
Contribute towards better earth buy the world a tree
Contributions
Other Publishings
Find this project on data.world
Follow me at
🙋♂️ Support My Work
Suggestions / Feedbacks
Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com
That's all Folks. Enjoy.