Full Database of city state country available in JSON & SQL Format All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.
- JSON
- SQL
- Countries
countries.json OR countries.sql - States
states.json OR states.sql - Cities
cities.json OR cities.sql - Country + States
countries+states.json - State + Cities
states+cities.json - Country + State + Cities
countries+states+cities.json OR world.sql
https://dr5hn.github.io/countries-states-cities-database/
Total Countries : 247
Total States/Regions : 4,851
Total Cities/Towns : 141,851
Last Updated On : 13th November 2019
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, some with large filesize.
So I thought to get it done on my own using PHP Script.
Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com
That's all Folks. Enjoy.