Awesome Open Source
Awesome Open Source

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,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.


Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
php (16,075) 
api (1,650) 
json (1,153) 
mysql (999) 
sql (683) 
xml (327) 
csv (268) 
yaml (215) 
state (115) 
countries (43) 
city (36) 
country (26) 
plist (26) 
region (17) 
states (17) 

Find Open Source By Browsing 7,000 Topics Across 59 Categories

Advertising 📦 10
All Projects
Application Programming Interfaces 📦 124
Applications 📦 192
Artificial Intelligence 📦 78
Blockchain 📦 73
Build Tools 📦 113
Cloud Computing 📦 80
Code Quality 📦 28
Collaboration 📦 32
Command Line Interface 📦 49
Community 📦 83
Companies 📦 60
Compilers 📦 63
Computer Science 📦 80
Configuration Management 📦 42
Content Management 📦 175
Control Flow 📦 213
Data Formats 📦 78
Data Processing 📦 276
Data Storage 📦 135
Economics 📦 64
Frameworks 📦 215
Games 📦 129
Graphics 📦 110
Hardware 📦 152
Integrated Development Environments 📦 49
Learning Resources 📦 166
Legal 📦 29
Libraries 📦 129
Lists Of Projects 📦 22
Machine Learning 📦 347
Mapping 📦 64
Marketing 📦 15
Mathematics 📦 55
Media 📦 239
Messaging 📦 98
Networking 📦 315
Operating Systems 📦 89
Operations 📦 121
Package Managers 📦 55
Programming Languages 📦 245
Runtime Environments 📦 100
Science 📦 42
Security 📦 396
Social Media 📦 27
Software Architecture 📦 72
Software Development 📦 72
Software Performance 📦 58
Software Quality 📦 133
Text Editors 📦 49
Text Processing 📦 136
User Interface 📦 330
User Interface Components 📦 514
Version Control 📦 30
Virtualization 📦 71
Web Browsers 📦 42
Web Servers 📦 26
Web User Interface 📦 210