Skip to content

🌍 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

Notifications You must be signed in to change notification settings

rer145/countries-states-cities-database

Β 
Β 

Repository files navigation

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 βœ… βœ… βœ… βœ… βœ… βœ…
States βœ… βœ… βœ… βœ… βœ… βœ…
Cities βœ… βœ… βœ… βœ… βœ… βœ…
Country+States βœ… NA βœ… NA βœ… NA
Country+Cities βœ… NA βœ… NA βœ… NA
State+Cities βœ… NA βœ… NA βœ… NA
Country+State+Cities/World βœ… βœ… βœ… NA βœ… NA

Demo

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

Insights

Total Countries : 250
Total States/Regions/Municipalities : 4,871
Total Cities/Towns/Districts : 147,783

Last Updated On : 6th June 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.

About

🌍 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

Resources

Code of conduct

Stars

Watchers

Forks

Packages

No packages published

Languages

  • PHP 97.3%
  • Python 2.7%