Need help with countries-states-cities-database?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

dr5hn
1.2K Stars 673 Forks 192 Commits 13 Opened issues

Description

🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, PLIST, YAML, and CSV. All Countries, States, Cities with ISO2, ISO3, Country Code, Phone Code, Capital, Native Language, Timezones, Latitude, Longitude, Region, Subregion, Flag Emoji, and Currency. #countries #states #cities

Services available

!
?

Need anything else?

Contributors list

# 19,308
XML
countri...
MySQL
SQL
105 commits
# 34,215
XML
countri...
MySQL
SQL
43 commits
# 102,628
webcons...
Symfony
kibana
nginx
4 commits
# 213,477
XML
countri...
MySQL
SQL
1 commit
# 199,950
XML
countri...
MySQL
SQL
1 commit
# 213,977
XML
countri...
MySQL
SQL
1 commit
# 214,586
XML
countri...
MySQL
SQL
1 commit
# 214,650
XML
countri...
MySQL
SQL
1 commit
# 212,406
Laravel
nova
XML
MySQL
1 commit
# 214,207
game-mo...
Shell
XML
MySQL
1 commit

banner

🌍 Countries States Cities Database

release size

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

banner

Formats Available

  • JSON
  • SQL
  • XML
  • PLIST
  • YAML
  • CSV

Distribution Files Info

File

JSON SQL XML PLIST YAML CSV
Countries :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark:
States :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark:
Cities :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark: :whitecheckmark:
Country+States :whitecheckmark: NA :whitecheckmark: NA :whitecheckmark: NA
Country+Cities :whitecheckmark: NA :whitecheckmark: NA :whitecheckmark: NA
State+Cities :whitecheckmark: NA :whitecheckmark: NA :whitecheckmark: NA
Country+State+Cities/World :whitecheckmark: :whitecheckmark: :whitecheckmark: NA :whitecheckmark: 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

Follow me at

Github @dr5hn Twitter @dr5hn LinkedIn @dr5hn

Suggestions / Feedbacks

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

That's all Folks. Enjoy.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.