Skip to content

🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, 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

License

Notifications You must be signed in to change notification settings

SydNS/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, 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
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 Countries : 250
Total States/Regions/Municipalities : 4,990
Total Cities/Towns/Districts : 150,348

Last Updated On : 6th Mar 2023

When's the next API Database Update day?

I usually update API's database once a quarter.

Upcoming API Database Update Date: 1st April 2023

Please Note: Even if you've urgency or you're running this API in Production and you find some data missing, the API Database update dates won't be changed at any circumstances.

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.

Make the world more Greener 🌴

Contribute towards better earth buy the world a tree

Contributions

Contibution Guidelines

As always, thanks to our amazing contributors!

Made with contrib.rocks.

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

That's all Folks. Enjoy.

About

🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, 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

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 97.4%
  • Python 2.6%