v1.5

What's NEW

• Add LICENSE
• Translate country name into Korean. (#249) -- Thanks to @ragubyun
• Translate country name into Simplified Chinese (#257) -- Thanks to @mayuko2012
• Add missing Nigeria state - River and its cities (#274)
• Add missing morocco states (#276)
• Rename COD to the Democratic Republic of the Congo
• Update country names and add missing phone codes (#278)
• Add numeric_code to countries
• Add script to pull up DROP commands at the top (#286)
• Add type column to states (#300)
• Add missing Thailand state and its cities (#282)

What's Fixed

• Fix #219: Add missing cities in India (#222)
• Remove district word from Portugal states (#225)
• Fix translations JSON for Guam (#263) -- Thanks to @alexandru-bagu
• Updated NCR state code to match with states iso2 (#261) -- Thanks to @SeanErvinson
• Fix Chilean Cities Updated .XLSX (#255)
• Fix Missing Kōchi Prefecture in Japan (#262)
• Fix Prague weird names (#254)
• Fix Missing Loreto state in Perú Country (#253)
• Fix Missing Bogota state in Colombia country (#252)
• Fix States latitude, longitude missing in countries+states+cities.json file. (#242)
• Fix Eastern Visayas State (Philippines) don't have any countries, which is wrong. (#240)
• Fix Duplicate cities (#230)
• Fix comprehensive list of possible duplicates (#236)
• Fix Portugal Error Cities in Viana do Castelo (#217)
• Fix state_code of cities of Iran & Daman (#268)
• Fix states of the Democratic Republic of the Congo (#280)
• Partial Fix cities of Italy (#229)
• Fix Data Administrative Subdivisions of Indonesia (#295) -- Thanks to @zhiephie
• Fix Add type column to states (#229)
• Fix Very long city name in France (#294)
• Fix Add more cities to states of Saudi Arabia (#291)
• Fix Native name of Saudi Arabia (#271)
• Fix Brazil state name (#287)

v1.4

What's NEW

• Add: #188 Add 10 new Algeria's states
• Add: #198 Add missing state Maramureș County & Mures County Cities
• Add: #204 Russia - Add missing state and its cities
• Add: #201 Add Monaco countries states
• Add: #205 Iran - Add missing state and its cities

What's Fixed

• Fix #184: Removed duplicated Spain's provinces
• Fix #187: Removed city listed in states of Poland
• Fix: #205 Iran states ISO codes
• Fix: #208 Switzerland Capital Typo Fix
• Fix: #213 - Fix India's State and Cities Namings

v1.3

What's NEW

• Add: #180 Add top level domain (tld) to countries

What's Fixed

• Fix currency_symbol NULL issue
• Skip translations in csv
• Fix: #177 Wrong column mapping in countries.csv
• Fix: #178 India's duplicate cities
• Fix: #181 Duplicate city names in India

v1.2

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

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 [Major Release]

What's New

🆕 Improved version of DEMO 🚀

Introduced API 🚀 API Documentation

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

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

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

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

• 👌 IMPROVE: Script Reusablity & UTF8 Preservance
• 🐛 FIX: #46 SQL Encoding Issue & #37 UK Wrong Data