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,990
Total Cities/Towns/Districts : 150,348
Last Updated On : 6th Mar 2023
I usually update API's database once a quarter.
Upcoming API Database Update Date: 1st April 2023
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.