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 |
Total Countries : 250
Total States/Regions/Municipalities : 4,964
Total Cities/Towns/Districts : 148,040
Last Updated On : 28th March 2022
I usually update API's database once a quarter.
Upcoming API Database Update Date: 17th April 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
Find this project on data.world
Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com
That's all Folks. Enjoy.