What's Fixed

• Fix error in the name of the state 1200 by @rsenses in https://github.com/dr5hn/countries-states-cities-database/pull/751
• fix names of eswatini, timor-leste, PNG, and more by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/748
• fix: Uttarakhand State code from UT to UK by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/752

New Contributors

• @rsenses made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/751

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v2.1...v2.2

What's New

• feat: Add Postgres database migration and export action by @agostinofiscale in https://github.com/dr5hn/countries-states-cities-database/pull/739

What's Changed

• Added new city Perinthalmanna in Kerala -> India by @shabeer-ali-m in https://github.com/dr5hn/countries-states-cities-database/pull/689
• fix: missing escapes in subregions by @slackero in https://github.com/dr5hn/countries-states-cities-database/pull/693
• Add New Caledonia provinces and cities & Add hedehusene, denmark by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/684
• add: Dessau-Roßlau, ST, DE by @slackero in https://github.com/dr5hn/countries-states-cities-database/pull/694
• ISO 3166-2:MX -> changed Ciudad de México CDMX to CMX by @slackero in https://github.com/dr5hn/countries-states-cities-database/pull/697
• fix the name of the city Boa Saúde, in RN, Brazil by @gabrielfs001 in https://github.com/dr5hn/countries-states-cities-database/pull/703
• Update cities benguela by @NzongoPedro in https://github.com/dr5hn/countries-states-cities-database/pull/713
• Update values for Swedish county Blekinge by @adevade in https://github.com/dr5hn/countries-states-cities-database/pull/709
• Sql Upadted Abkhazia name changed by @gchikovanii in https://github.com/dr5hn/countries-states-cities-database/pull/731
• fix mispeling on Capão Bonito, SP, BR. by @jvlomazzi in https://github.com/dr5hn/countries-states-cities-database/pull/742

New Contributors

• @shabeer-ali-m made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/689
• @slackero made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/693
• @gabrielfs001 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/703
• @NzongoPedro made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/713
• @adevade made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/709
• @gchikovanii made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/731
• @agostinofiscale made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/739
• @jvlomazzi made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/742

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v2.0...v2.1

Breaking Change

• Add region_id column in countries table.
• Add subregion_id column in countries table.

What's New!

• feat: add regions database table by @Freelenzer in https://github.com/dr5hn/countries-states-cities-database/pull/657
• feat: add nationality to countries by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/660
• feat: Add cities of Puerto Rico by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/646
• feat: add subregions database table by @Freelenzer in https://github.com/dr5hn/countries-states-cities-database/pull/668

What's Changed

• Fix latlng for Marche, Lazio (Italy) by @joaorb64 in https://github.com/dr5hn/countries-states-cities-database/pull/503
• Added Adra, West Bengal, India in world.sql by @apexdivision in https://github.com/dr5hn/countries-states-cities-database/pull/495
• Correction State OD City Bhubaneswar by @Jayesh-Mahato in https://github.com/dr5hn/countries-states-cities-database/pull/511
• Bangladesh country states table type values updated by @hafijul233 in https://github.com/dr5hn/countries-states-cities-database/pull/514
• fix: Italian data by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/531
• Removed the district suffix from bangladesh districts by @hafijul233 in https://github.com/dr5hn/countries-states-cities-database/pull/524
• fix: turkish character problems for istanbul and umraniye by @oytunyuksel in https://github.com/dr5hn/countries-states-cities-database/pull/537
• fix: Multiple issues by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/539
• fix: added jamtland county for sweden by @Naeralys in https://github.com/dr5hn/countries-states-cities-database/pull/534
• All regions of Turkey have been updated by @w01ki3 in https://github.com/dr5hn/countries-states-cities-database/pull/559
• Update Macedonia to North Macedonia by @bor0 in https://github.com/dr5hn/countries-states-cities-database/pull/568
• Update Sana'a to Amanat Al Asimah by @Tarctic in https://github.com/dr5hn/countries-states-cities-database/pull/570
• Fix #562 and #566 by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/578
• fix: Multiple issue by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/589
• fix: Multiple issues by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/611
• fix: some of cities has wrong state codes by @mowaiskalam in https://github.com/dr5hn/countries-states-cities-database/pull/600
• Tai Po state_code fixed. by @ohk in https://github.com/dr5hn/countries-states-cities-database/pull/620
• Rename Århus to Aarhus by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/634
• Remove duplicate city for Jakarta by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/635
• chore: Added details of Asuncion which is capital of Paraguay by @shriraj221094 in https://github.com/dr5hn/countries-states-cities-database/pull/627
• Add City of Industry, CA, USA by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/632
• Fix venezuelan iso currency code by @pedro757 in https://github.com/dr5hn/countries-states-cities-database/pull/650
• Remove 'Department' from Uruguayan states by @gabiito in https://github.com/dr5hn/countries-states-cities-database/pull/629
• fix: #639 Add missing cities of Aland Island Finland by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/641
• fix: #642 add missing city to crete,greece by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/643
• fix: #638 add canary island and its cities by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/644
• fix: #631 add ceuta and melillia in spain by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/645
• fix Ukraine capital typo by @Gorynych in https://github.com/dr5hn/countries-states-cities-database/pull/649
• Fix incongruent state_code and country_code for cities in Sevastopol by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/633
• fix state Daerah Istimewa Yogyakarta by @syihammusoffa in https://github.com/dr5hn/countries-states-cities-database/pull/655
• Fix city double sleman of yogakarta indonesia by @syihammusoffa in https://github.com/dr5hn/countries-states-cities-database/pull/663
• fix erroneous state code for sevastopol by @scottgigante in https://github.com/dr5hn/countries-states-cities-database/pull/672

New Contributors

• @apexdivision made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/495
• @Jayesh-Mahato made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/511
• @hafijul233 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/514
• @oytunyuksel made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/537
• @Naeralys made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/534
• @w01ki3 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/559
• @bor0 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/568
• @Tarctic made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/570
• @mowaiskalam made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/600
• @ohk made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/620
• @scottgigante made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/634
• @shriraj221094 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/627
• @pedro757 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/650
• @gabiito made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/629
• @Gorynych made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/649
• @syihammusoffa made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/655
• @Freelenzer made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/657

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v1.9...v2.0

What's NEW

• Add Turkish translations for country names by @AykutBuyukkaya in https://github.com/dr5hn/countries-states-cities-database/pull/425
• Add Baghdad cities by @abdo0 in https://github.com/dr5hn/countries-states-cities-database/pull/488

What's Changed

• Change 'br' translations to 'pt-BR' to match i18n mappings by @joaorb64 in https://github.com/dr5hn/countries-states-cities-database/pull/460
• Fix #469 Added N'Djamena city under N'Djamena region
• Fix #474 Removed HongZhou from China
• Fix #480 Added Nabeul state in Tunisia.
• Fix #459 Fix co-ordinates of Hunan, China.
• Fix #478 Updated cities of "Pirkanmaa" region.
• Fix #464 Add missing Hillsborough & Montgomery townships to New Jersey.
• Fix #417 Add missing cities of the Province of Ravenna.
• Fix #380 Add missing states of Puerto Rico Country.
• Fix #438 Add missing states and cities of the U.S. Virgin Islands.
• Fix #422 Thornhill, Ontario, Canada Added.
• Fix #423 Karlovac County state_code Fixed.
• Fix #427 Fill type column for the Morocco States.
• Fix #429 Add missing Egypt Cities.
• Fix #430 Add missing Hungarian County and updated type column.
• Fix #433 Fix Lat Long Infomation of Salem, Tamilnadu.
• Fix #437 Update Nuevo León cities to the latest.
• Fix #435 Remove Netherlands municipality duplicates.
• Fix #439 Add more cities to Mauritania and Update the type column.
• Fix #442 - Add missing cities in Kalimantan Barat by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/448
• Fix: #228 Added missing Iran cities by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/481
• Fix: #211 Remove New york duplicate cities by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/483
• Fix: #209 Spain provinces and cities sorted by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/486

New Contributors

• @AykutBuyukkaya made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/425
• @abdo0 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/488

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v1.8...v1.9

What's Changed

• Fixes and improves to states and cities from Colombia by @cesariverit in https://github.com/dr5hn/countries-states-cities-database/pull/368
• Improve Ecuador States and cities by @fzzio in https://github.com/dr5hn/countries-states-cities-database/pull/366
• Add lat/lng data for two states in Brazil by @joaorb64 in https://github.com/dr5hn/countries-states-cities-database/pull/377
• Fix: #355 Add missing neighbourhood in Uruguay-Montevideo by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/383
• Fix: #374 Update odesa city name by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/383
• Update Mexico State and cities names and improve state code by @NaimGrimaldo in https://github.com/dr5hn/countries-states-cities-database/pull/391
• Fix Brazil states latlng for Bahia and Acre by @joaorb64 in https://github.com/dr5hn/countries-states-cities-database/pull/401
• add missing Croatian county - Karlovac County by @jalandis in https://github.com/dr5hn/countries-states-cities-database/pull/402
• trim state type field values by @jalandis in https://github.com/dr5hn/countries-states-cities-database/pull/403
• Updates in some cities and states from Colombia by @cesariverit in https://github.com/dr5hn/countries-states-cities-database/pull/372
• Update contribution guidelines
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/379 Add commands to output other sql files via github actions
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/375 Add type to Cambodia's provinces and add missing province
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/385 Add Huntingwood and Eagle Farm cities to Australia
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/388 Add Dartmouth in Massachusetts state in the US
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/394 Add missing region Poltava and names fixes
• Update type column of US States
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/392 Add hazlet township in New Jersey
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/393 State's wikiData ID
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/396 Remove duplicate swedene cities with suffix Kommun
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/397 Country name Bahamas The to The Bahamas
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/395 Remove tab character from Data
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/399 Incorrect city name
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/400 Add Morningside to Pennsylvania
• Fix: https://github.com/dr5hn/countries-states-cities-database/issues/405 Add Ranipet in Tamlinadu

New Contributors

• @cesariverit made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/368
• @fzzio made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/366
• @joaorb64 made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/377
• @NaimGrimaldo made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/391
• @jalandis made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/402

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v1.7...v1.8

What's Changed

• Fix: #338 Attach Thika to Kiambu County
• Fix: #339 Add & Update type in states of France
• Fix: #341 Add country_name in states & cities
• Fix: #333 Corrected Karnataka city names
• Fix: #308 Added currency_name
• Fix: #359 Add Sharqiyah and its towns
• Fix: #356 Fill type column for Canadian provinces
• Fix: #345 Add Banksmeadow and Whale Beach of NSW Australia
• Fix: Docs modal issue on the small screen

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v1.6...v1.7

What's Changed

• Fix: renamed cities which has been transformed from districts to counties by @mwaijohn in https://github.com/dr5hn/countries-states-cities-database/pull/303
• Fix: Switzerland had mistakes by @egemasta in https://github.com/dr5hn/countries-states-cities-database/pull/315
• Fix: #309 - Add missing regions Mbeya and Songwe by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/310
• Fix: #306 - Add missing city Gboko in Benue by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/310
• Fix: #317 Istanbul cities by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/320
• Fix: #318 wrong district in cyprus by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/320
• Fix: #312 Add missing town in NJ by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/321
• Fix: #313 Add Missing States in GHANA (GH) by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/323
• Fix: #334 Add missing cities to New South Wales by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/335
• Fix: #325 Remove Keelung from China province and Add it to Taiwan by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/335
• Fix: #325 Add missing Tianjin municipality to China by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/335

What's Removed

• End of support for plist format by @dr5hn in https://github.com/dr5hn/countries-states-cities-database/pull/332

New Contributors

• @mwaijohn made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/303
• @egemasta made their first contribution in https://github.com/dr5hn/countries-states-cities-database/pull/315

Full Changelog: https://github.com/dr5hn/countries-states-cities-database/compare/v1.5...v1.6

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)

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

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

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.

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

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

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)

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)

What's New

• 👌 IMPROVE: ReadMe (#60)
• 📦 NEW: GitHub Actions - Automate updation of JSON Files (#61)
• 👌IMPROVE: JSON Output (#62)
• 📦 NEW: Export to XML (#64)

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

• 🐛 FIX: Missing Oheo (US) States and Cities -- Issue (#38) PR (#39)

• 📦 NEW: Application Demo
• 👌 IMPROVE: ReadMe

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

• 📦 NEW: PHP Unirest Dependency added to Composer
• 👌 IMPROVE: Readme Steps for Better Usage