v2.5

What's Changed

• Add Marshall city in Alaska. by @rvtraveller in #848
• Fix Croatia currency by @mtsfer in #856
• Fix mispelling on Bodh Gaya by @mtsfer in #860
• Adds missing city Berlin, Connecticut, USA by @scottgigante in #862
• Update regions.json Americas 'fa' translation by @ErfanBahramali in #865
• Update countries.json Add Kosovo 'fa' translation by @ErfanBahramali in #866
• Fix countries.json 'fa' translation by @ErfanBahramali in #867
• Move Haizhou and Jingjiang to Jiangsu by @mtsfer in #870
• Update countries.json by @aashahin in #851
• fix: add Stratford city in New Zealand. by @Aakash315 in #874
• fix: Solve Duplicate cities in Indonesia by @Aakash315 in #875
• fix: Rename city by @Aakash315 in #878
• Add Walling, Tennessee, USA by @mtsfer in #881
• Fix Zambia subregion by @mtsfer in #880
• Remove Lisbon & Sintra cities from Guarda District by @Aakash315 in #879
• Add Bavla, Gujarat, India by @mtsfer in #882
• Fix the states.iso2 and states.type values for Jämtland County in Sweden by @aglundahl in #885
• Fix pt-BR and some pt translations by @mtsfer in #884
• fix: Add Missing cities in Hampshire by @Aakash315 in #886
• fix: Add Missing states for Aruba, Cayman Islands and Guam Countries by @Aakash315 in #888
• fix: Add Mauritania Cities by @Aakash315 in #889
• Fix translations languages by @mtsfer in #883
• Fix Luxembourg, Wallonia, Belgium coordinates by @mtsfer in #894
• Fix RD Congo locations by @mtsfer in #895
• Fix multiple issues by @Aakash315 in #893

New Contributors

• @rvtraveller made their first contribution in #848
• @mtsfer made their first contribution in #856
• @ErfanBahramali made their first contribution in #865
• @aashahin made their first contribution in #851
• @aglundahl made their first contribution in #885

Full Changelog: v2.4...v2.5

v2.4

What's Changed

• New cli console && rename directory by @tigran90 in #808
• adding 4 new states in Indonesia by @md3e in #826
• fix: #824 add zacapa department in guatemala by @Aakash315 in #827
• fix: Tanzania States & Cities by @Aakash315 in #828
• fix: Add Rosenthal am Rennsteig city in the state of Thuringia Germany by @Aakash315 in #830
• fix: Multiple Issues by @Aakash315 in #835
• fix: add city Friedensburg in the state Pennsylvania, US by @Aakash315 in #834
• fix: list of countries/states/cities not reappering when cleared by @ACR1209 in #837
• fix: Add Nepal Provinces by @Aakash315 in #839
• fix: Bhutan States & Cities by @Aakash315 in #842
• fix: Bangladesh Cities Added by @Aakash315 in #844
• fix: Mauritius cities update by @Aakash315 in #846

New Contributors

• @tigran90 made their first contribution in #808
• @md3e made their first contribution in #826
• @Aakash315 made their first contribution in #827
• @ACR1209 made their first contribution in #837

Full Changelog: v2.3...v2.4

v2.3

What's New 🚀

• [Feature] Add SQLite database support in the export workflow by @navicraft in #781
• [Feature] Improve PostgreSQL Data Export @dr5hn

What's Changed 🔧 🔨

• rename 'Ar Ruways' to wikidata accepted name 'Ruwais' by @scottgigante in #757
• fix: add alimosho city to lagos state, nigeria by @laurentcodes in #756
• update: add major lagos cities by @laurentcodes in #762
• Vallensbæk in Denmark has Strand at the end by @ymg2006 in #775
• Remove non-existent Uruguay cities, update existing ones & add missing ones by @juandidasilva in #777
• Add Cities For Malaysia by @hachirobei in #779
• Remove invalid "Campinas" brazilian city from database by @skpeter in #800
• add 19 cities and edit 11 city names for Malta by @ryanvelbon in #782
• fix: #795 Poland State Code Changes by @dr5hn in #802
• fix: Duplicate Entries in Cities List #735 by @dr5hn in #803
• fix: Remove the "+" symbol from all instances of country "phone_code"… by @dr5hn in #805
• fixes #769 Wrong city name showing for below information by @dr5hn in #806
• closes Missing cities of Faroe Islands #666 by @dr5hn in #807

New Contributors

• @laurentcodes made their first contribution in #756
• @ymg2006 made their first contribution in #775
• @juandidasilva made their first contribution in #777
• @hachirobei made their first contribution in #779
• @navicraft made their first contribution in #781
• @skpeter made their first contribution in #800
• @ryanvelbon made their first contribution in #782

Full Changelog: v2.2...v2.3

v2.2

What's Fixed

• Fix error in the name of the state 1200 by @rsenses in #751
• fix names of eswatini, timor-leste, PNG, and more by @scottgigante in #748
• fix: Uttarakhand State code from UT to UK by @dr5hn in #752

New Contributors

• @rsenses made their first contribution in #751

Full Changelog: v2.1...v2.2

v2.1

What's New

• feat: Add Postgres database migration and export action by @agostinofiscale in #739

What's Changed

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

New Contributors

• @shabeer-ali-m made their first contribution in #689
• @slackero made their first contribution in #693
• @gabrielfs001 made their first contribution in #703
• @NzongoPedro made their first contribution in #713
• @adevade made their first contribution in #709
• @gchikovanii made their first contribution in #731
• @agostinofiscale made their first contribution in #739
• @jvlomazzi made their first contribution in #742

Full Changelog: v2.0...v2.1

v2.0

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 #657
• feat: add nationality to countries by @dr5hn in #660
• feat: Add cities of Puerto Rico by @scottgigante in #646
• feat: add subregions database table by @Freelenzer in #668

What's Changed

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

New Contributors

• @apexdivision made their first contribution in #495
• @Jayesh-Mahato made their first contribution in #511
• @hafijul233 made their first contribution in #514
• @oytunyuksel made their first contribution in #537
• @Naeralys made their first contribution in #534
• @w01ki3 made their first contribution in #559
• @bor0 made their first contribution in #568
• @Tarctic made their first contribution in #570
• @mowaiskalam made their first contribution in #600
• @ohk made their first contribution in #620
• @scottgigante made their first contribution in #634
• @shriraj221094 made their first contribution in #627
• @pedro757 made their first contribution in #650
• @gabiito made their first contribution in #629
• @Gorynych made their first contribution in #649
• @syihammusoffa made their first contribution in #655
• @Freelenzer made their first contribution in #657

Full Changelog: v1.9...v2.0

v1.9

What's NEW

• Add Turkish translations for country names by @AykutBuyukkaya in #425
• Add Baghdad cities by @abdo0 in #488

What's Changed

• Change 'br' translations to 'pt-BR' to match i18n mappings by @joaorb64 in #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 #448
• Fix: #228 Added missing Iran cities by @dr5hn in #481
• Fix: #211 Remove New york duplicate cities by @dr5hn in #483
• Fix: #209 Spain provinces and cities sorted by @dr5hn in #486

New Contributors

• @AykutBuyukkaya made their first contribution in #425
• @abdo0 made their first contribution in #488

Full Changelog: v1.8...v1.9

v1.8

What's Changed

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

New Contributors

• @cesariverit made their first contribution in #368
• @fzzio made their first contribution in #366
• @joaorb64 made their first contribution in #377
• @NaimGrimaldo made their first contribution in #391
• @jalandis made their first contribution in #402

Full Changelog: v1.7...v1.8

v1.7

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: v1.6...v1.7

v1.6

What's Changed

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

What's Removed

• End of support for plist format by @dr5hn in #332

New Contributors

• @mwaijohn made their first contribution in #303
• @egemasta made their first contribution in #315

Full Changelog: v1.5...v1.6