Skip to content

All Countries, Cities, States with ISO2, ISO3, Country Code, Phone Code, Capital and Currency [countries.json, country.json, city.json, cities.json, state.json, states.json] [Linked with Each Other By ID] [Countries-States-Cities-database]

Notifications You must be signed in to change notification settings

syaacob/countries-states-cities-database

 
 

Repository files navigation

Countries States Cities Database (JSON + SQL + PHP Export JSON Script)

Full Database of city state country available in JSON & SQL Format All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.

  1. Countries countries.json OR countries.sql
  2. States states.json OR states.sql
  3. Cities cities.json OR cities.sql
  4. Country + States countries+states.json
  5. State + Cities states+cities.json
  6. Country + State + Cities countries+states+cities.json OR world.sql

Demo

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

Insights

Total Countries : 247
Total States/Regions : 4,851
Total Cities/Towns : 141,851

Last Updated On : 13th November 2019

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, some with large filesize. So I thought to get it done on my own using PHP Script.

Contributions / Suggestions / Feedbacks

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

That's all Folks. Enjoy.

About

All Countries, Cities, States with ISO2, ISO3, Country Code, Phone Code, Capital and Currency [countries.json, country.json, city.json, cities.json, state.json, states.json] [Linked with Each Other By ID] [Countries-States-Cities-database]

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • TSQL 100.0%