Countries States Cities Database Versions Save

🌍 Discover our global repository of countries, states, and cities! πŸ™οΈ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities

v1.2

3 years ago
Screenshot 2021-01-23 at 7 13 34 PM

What's New

  • #106 Add translations to countries.
  • #169 Add Currency symbols to countries for an Ecommerce use case.

What's Fixed

  • Fix #140 Northern Ireland Cities Added to North Yorkshire
  • Fix #165 Table cities column name is updated_on instead updated_at
  • Fix #165 Add Shumen as a City
  • Fix #78 Add Hongkong Districts
  • Fix states with empty ISO Code.

v1.1

3 years ago

What's New

  • Added Region & Subregion to Country.
  • Added Timezones to Country.
  • Added Latitude & Longitude to States & Cities.
  • Added Missing countries.
  • Added one more combination of JSON (countries+cities.json)

What's Changed/Fixed

  • Fix contribution guidelines link in readme (#133) - @patrickdaze
  • Fix Missing Cities of Colombo & Kandy District (#143)
  • Remove unwanted data (#145)
  • Fix #146 Add missing Reghin City in Romania
  • Fix #147 Add missing Schumen Region in Bulgaria

v1.0

3 years ago

What's New

πŸ†• Improved version of DEMO πŸš€

Screenshot 2020-09-06 at 4 24 14 PM Screenshot 2020-09-06 at 4 25 20 PM

Introduced API πŸš€ API Documentation

api

What's Changed/Fixed

  • πŸ› Fix #76 Venezuela state #79 Gujarat Cities (#81)
  • πŸ› FIX: #36 Missing Jalisco state & its Cities of Mexico (#83)
  • πŸ› FIX: Missing Roraima state in Brazil #41 (#84)
  • πŸ› FIX: Puerto Rico cities are missing #50 & Missing Guarda District in Portugal #82 (#85)
  • Add & Fix Some Cities in Punjab of Pakistan & India (#87)
  • πŸ› FIX: "Neufahrn in Niederbayern" is not a state - Thanks to @skrollme
  • πŸ› FIX & ADD: Austria Cities #95 & #88 (#96)
  • πŸ› Fix state_code for South Africa states Gauteng and Kwazulu-Natal (#97)
  • Added states (parishes) of Bermuda (#97)
  • πŸ› FIX: Lima and Lima's province are the same (#97)
  • πŸ› FIX: #99 Add Kosovo as Country
  • πŸ› FIX: #90 Add Buenos Aires City as a State
  • πŸ› FIX: #63 City Bogota is the Capital of Colombia
  • πŸ› FIX: #101 Currencies
  • πŸ› FIX: remove not existing LTU cities - Thanks to @minved
  • πŸ› FIX: #119 Nassau missing in the Bahamas (#120)
  • πŸ› FIX: #107 - Add missing cities of Provinces in the Philippines (#126)

Deprecated

  • Few PLIST Formats of
    • countries+states.plist
    • states+cities.plist
    • countries+states+cities.plist

v0.9

3 years ago

What's New

  • πŸ› FIX: #72 WestBengal India & #74 Sinop Turkey (#75)
  • πŸ› FIX: #76 Venezuela state #79 Gujarat Cities (#81)
  • πŸ› FIX: #36 Missing Jalisco state & its Cities of Mexico (#83)
  • πŸ› FIX: Missing Roraima state in Brazil #41 (#84)
  • πŸ› FIX: Puerto Rico cities are missing #50 & Missing Guarda District in Portugal #82 (#85)

v0.8

4 years ago

What's New

  • πŸ‘Œ IMPROVE: #70 Add State Ladakh & Cities (#71)
  • πŸ“¦ NEW: #58 Add Country Flag (#71)
  • πŸ› FIX: #49 Spelling of the city pathanamthitta is wrong (#69)
  • πŸ“¦ NEW: Export to CSV (#68)
  • πŸ“¦ NEW: Export to YAML (#67)
  • πŸ“¦ NEW: Export to PLIST (#65)

v0.7

4 years ago

What's New

  • πŸ‘Œ IMPROVE: ReadMe (#60)
  • πŸ“¦ NEW: GitHub Actions - Automate updation of JSON Files (#61)
  • πŸ‘ŒIMPROVE: JSON Output (#62)
  • πŸ“¦ NEW: Export to XML (#64)

v0.6

4 years ago
  • πŸ‘Œ IMPROVE: Script Reusablity & UTF8 Preservance
  • πŸ› FIX: #46 SQL Encoding Issue & #37 UK Wrong Data

v0.5

4 years ago
  • πŸ› FIX: Missing Oheo (US) States and Cities -- Issue (#38) PR (#39)

v0.4

4 years ago
  • πŸ“¦ NEW: Application Demo
  • πŸ‘Œ IMPROVE: ReadMe

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

v0.3

4 years ago
  • πŸ“¦ NEW: PHP Unirest Dependency added to Composer
  • πŸ‘Œ IMPROVE: Readme Steps for Better Usage