Countries States Cities Database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
Alternatives To Countries States Cities Database
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Yq9,41970a day ago126July 12, 2023101mitGo
yq is a portable command-line YAML, JSON, XML, CSV, TOML and properties processor
Structured Text Tools6,759
a day ago3
A list of command line tools for manipulating structured text data
Countries5,7953991006 days ago21April 04, 202018odbl-1.0PHP
World countries in JSON, CSV, XML and Yaml. Any help is welcome!
Countries States Cities Database5,483
5 days ago68odbl-1.0PHP
🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
Tablib4,2761,179969 days ago45July 20, 202334mitPython
Python Module for Tabular Datasets in XLS, CSV, JSON, YAML, &c.
Content2,7591703 days ago53July 25, 2023305mitTypeScript
The file-based CMS for your Nuxt application, powered by Markdown and Vue components.
Luban2,466
5 days agomitC#
luban是一个强大、易用、优雅、稳定的游戏配置解决方案。luban is a powerful, easy-to-use, elegant and stable game configuration solution.
Datamodel Code Generator1,846543 days ago172August 09, 2023110mitPython
Pydantic model and dataclasses.dataclass generator for easy conversion of JSON, OpenAPI, JSON Schema, and YAML data sources.
Jobfunnel1,533
2 years ago1October 02, 202010mitPython
Scrape job websites into a single spreadsheet with no duplicates.
Just Dashboard1,489332 years ago29July 13, 201949mitJavaScript
:bar_chart: :clipboard: Dashboards using YAML or JSON files
Alternatives To Countries States Cities Database
Select To Compare


Alternative Project Comparisons
Readme

banner

🌍 Countries States Cities Database

release size

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.

API Documentation

banner

Available Formats

  • JSON
  • SQL
  • XML
  • YAML
  • CSV

Distribution Files Info

File JSON SQL XML YAML CSV
Regions
Subregions
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 Regions : 6
Total Sub Regions : 22
Total Countries : 250
Total States/Regions/Municipalities : 5,081
Total Cities/Towns/Districts : 150,540

Last Updated On : 3rd Sept 2023

Next API Database Update

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: 1st Sept 2023

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!

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.

Contributing

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

If you want to contribute to the database, please follow the guidelines outlined below:

Contributing Guidelines

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

Please make sure to review the guidelines before making any contributions. They will help ensure that your contributions align with the project's standards and make the process smoother for everyone involved.

You can find the detailed contribution guidelines here.

As always, thanks to our amazing contributors!

Made with contrib.rocks.

Make the world more Greener 🌴

Contribute towards better earth buy the world a tree

Other Publishings

Find this project on data.world

Follow me at

Github @dr5hn Twitter @dr5hn LinkedIn @dr5hn

🙋‍♂️ Support My Work

Github Sponsorship

ko-fi

Suggestions / Feedbacks

Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com

Disclaimer

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.

Popular Csv Projects
Popular Yaml Projects
Popular Data Formats Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Php
Json
Mysql
Sql
Xml
Csv
Yaml
City
Countries
Plist