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 : 5,001
Total Cities/Towns/Districts : 150,890
Last Updated On : 6th Oct 2022
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.
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.