Repository files navigation

Full Database of city state country available in JSON, MYSQL, PSQL, SQLITE, XML, YAML, MONGODB & CSV format.All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.

• CSC Platform Ecosystem
• API
• Export Tool
• Available Formats
• Distribution Files Info
• Demo
• Insights
• Next API Database Update
• Import MongoDB
• License
• Contributing
• Repo Activity
• Sponsors
• Other Publishings
• Support My Work
• Suggestions / Feedbacks
• Disclaimer

Easily access all the tools and services in the Countries States Cities platform:

🎉 IntroducingAPI for Countries States Cities Database.

API Documentation

🎯Transform your data with our powerful export tool!

Looking to export the Countries States Cities database in your preferred format? Our dedicated export tool makes it easy to convert and download data in multiple formats with just a few clicks.

Try the Export Tool - Export data in JSON, CSV, XML, YAML, and more!

• Multiple Export Formats: JSON, CSV, XML, YAML, and more
• Flexible Data Selection: Choose specific countries, states, or cities
• Custom Filtering: Filter by regions, subregions, or specific criteria
• Bulk Downloads: Export large datasets efficiently
• Real-time Processing: Get your data instantly
• User-friendly Interface: Simple and intuitive design

Perfect for developers, researchers, and businesses who need clean, structured geographical data for their applications.

• JSON
• MYSQL
• PSQL
• SQLITE
• SQLSERVER
• MONGODB
• XML
• YAML
• CSV

https://dr5hn.github.io/countries-states-cities-database/

Total Regions : 6
Total Sub Regions : 22
Total Countries : 250
Total States/Regions/Municipalities : 5,038
Total Cities/Towns/Districts : 151,024

Last Updated On : 05th Jul 2025

The API database is regularly updated to ensure the latest data is available to users. The next scheduled update is on:

Upcoming API Database Update Date: 8th April 2025

Please note that this date is subject to change based on unforeseen circumstances. Although we strive to adhere to the schedule, there may be instances where the update date is missed. We apologize for any inconvenience caused in such cases.

We appreciate your understanding and patience. Thank you for using the Countries States Cities Database!

How to import MongoDB database?

# First extract the tar.gz filetar -xzvf world-mongodb-dump.tar.gz# Then restore the MongoDB dumpmongorestore --host localhost:27017 --db world mongodb-dump/world

ThisCountries States Cities Database is made available under theOpen Database License. Any rights in individual contents of the database are licensed under theDatabase Contents License.

👍🎉 First off, thanks for your interest in contributing! 🎉👍

We've launched a dedicated web tool to make contributing to this database easier than ever!

CSC Update Tool - Our official tool to submit database change requests

The update tool allows you to:

• Browse and search through all regions, subregions, countries, states, and cities
• Easily identify and correct outdated or inaccurate data
• Submit change requests through a streamlined review process
• Track the status of your submissions

If you prefer to contribute directly through GitHub, you can still follow these steps:

1. Fork the repository and clone it to your local machine
2. Make the necessary changes to the data:
   • To fix cities records, update thesql/world.sql > cities Table
   • To fix states/provinces records, update thesql/world.sql > states Table
   • To fix countries records, update thesql/world.sql > countries Table
   • To fix regions records, update thesql/world.sql > regions Table
   • To fix subregions records, update thesql/world.sql > subregions Table
3. Once you've made the changes, create a pull request with a clear description of the modifications you've made

Please ensure your contributions align with our data standards and formatting. You can find the detailed contribution guidelineshere.

We review all submissions carefully to maintain data quality and appreciate your help in making this database more accurate and comprehensive.

As always, thanks to our amazing contributors!

Made withcontrib.rocks.

Contribute towards better earthbuy the world a tree

Find this project on

• data.world
• kaggle

Suggestions & Feedbacks are Most Welcomegadadarshan[at]gmail[dot]com

Please note that while every effort has been made to ensure the accuracy and completeness of the Countries States Cities Database, it may still contain errors or omissions. The database is continuously being refined and improved based on user feedback and contributions.

Contributors are encouraged to review the Contribution Guidelines and follow the specified guidelines for updating and correcting data in the database. However, due to the collaborative nature of the project, we cannot guarantee the absolute accuracy or reliability of the information provided.

The Countries States Cities Database is made available under the Open Database License, and any rights in individual contents of the database are licensed under the Database Contents License. Users are responsible for independently verifying the data and using it at their own discretion.

We appreciate the efforts of contributors in identifying and addressing issues in the database, and we encourage users to report any inaccuracies or suggest improvements through creating issues. However, please note that the database may not always reflect the latest geopolitical changes or political status.

It is recommended that users consult official sources and corroborate the data from the Countries States Cities Database with other reliable references for critical applications or decision-making processes.

By accessing and using the Countries States Cities Database, users acknowledge and agree to the aforementioned disclaimer and the terms of the Open Database License and the Database Contents License.

That's all Folks. Enjoy.