# Countries States Cities Database   Full Database of city state country available in JSON, SQL, XML, PLIST, YAML & CSV format. All Countries, States & Cities are Covered & Populated with Different Combinations & Versions. ## API Introducing **API** for Countries States Cities Database. [API Documentation](https://countrystatecity.in/) [](https://countrystatecity.in/) ## Formats Available - JSON - SQL - XML - PLIST - YAML - CSV ## Distribution Files Info File | JSON | SQL | XML | PLIST | YAML | CSV :------------ | :-------------| :-------------| :------------- |:-------------|:-------------|:------------- Countries | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: States | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: Cities | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: Country+States | :white_check_mark: | NA | :white_check_mark: | NA | :white_check_mark: | NA Country+Cities | :white_check_mark: | NA | :white_check_mark: | NA | :white_check_mark: | NA State+Cities | :white_check_mark: | NA | :white_check_mark: | NA | :white_check_mark: | NA Country+State+Cities/World | :white_check_mark: | :white_check_mark: | :white_check_mark: | NA | :white_check_mark: | NA ## Demo https://dr5hn.github.io/countries-states-cities-database/ ## Insights Total Countries : 250
Total States/Regions/Municipalities : 4,892
Total Cities/Towns/Districts : 146,028
Last Updated On : 20th February 2021 ## Notes ``` This Free database does not guarantee for the complete list of world countries, states & cities. You can manually change the spelling mistakes, duplicates or add/edit any records, which are incorrect. Reason behind making this repo: I ran through many websites to get perfect combination of state, city & countries. Some were with missing states while others with large filesize. So I thought to get it done on my own using PHP Script. ``` ## Contributions [Contibution Guidelines](https://github.com/dr5hn/countries-states-cities-database/blob/master/.github/CONTRIBUTING.md) ## Follow me at ## Suggestions / Feedbacks ``` Suggestions & Feedbacks are Most Welcome gadadarshan[at]gmail[dot]com ``` That's all Folks. Enjoy.