27 Feb 15:06

dr5hn

45317db

v3.1 Latest

Latest

Changelog — v3.1

🌍 New Data Added

Add missing cities for Saudi Arabia, Japan, fix data quality issues and remove duplicates
Add population and GDP column in countries and native data
Add population in cities table
Add timezone support for all cities using geographic coordinates
Add translations.csv export for country, region, and subregion name translations
Add DuckDB import script and GitHub Actions integration for database format conversion
Add MCP Server Integration for GitHub Copilot Agents
Add Claude Code GitHub Workflow
Add toon & geojson script

Countries & Regions

Afghanistan — Add missing Wardak province and cities
Angola — Add missing Namibe province and cities with translations (ISO 3166-2:AO)
Azerbaijan — Add 3 missing municipalities with Wikipedia-sourced translations (ISO 3166-2:AZ)
Bahamas — Align districts with ISO 3166-2:BS (42→32 states)
Bangladesh — Add 64 districts with multilingual support and reassign cities (ISO 3166-2:BD)
Botswana — Fix missing districts, towns and cities
Cabo Verde — Add missing São Salvador do Mundo municipality (CV-SS)
Cambodia — Add missing Tboung Khmum province (ISO 3166-2:KH)
Côte d'Ivoire — Restructure administrative divisions per ISO 3166-2:CI
Dominican Republic — Add missing province and 10 regions per ISO 3166-2:DO
Equatorial Guinea — Add missing Djibloho province (GQ-DJ)
Estonia — Add municipalities and update county ISO codes per ISO 3166-2:EE
Ethiopia — Add missing Sidama (ET-SI) and Southwest Ethiopia Peoples (ET-SW) states; reassign 12 cities
France — Add missing Nouvelle-Calédonie (New Caledonia) overseas collectivity
Guinea-Bissau — Add missing Bissau autonomous sector (GW-BS)
Iceland — Add 64 missing municipalities per ISO 3166-2:IS
Indonesia — Add 7 missing geographical units per ISO 3166-2:ID
Iraq — Add missing Kurdistan Region (IQ-KR) per ISO 3166-2:IQ
Italy — Add 15 missing administrative divisions per ISO 3166-2:IT
Libya — Add missing Al Butnan province and cities per ISO 3166-2:LY
Lithuania — Add 7 city municipalities per ISO 3166-2:LT
Maldives — Fix administrative divisions per ISO 3166-2:MV
Malta — Add missing Safi local council (MT-47)
Marshall Islands — Add 24 municipalities per ISO 3166-2:MH
Moldova — Add missing Leova district (ISO 3166-2:MD)
Monaco — Add 14 missing quarters per ISO 3166-2:MC with translations
Montenegro — Add missing municipalities
Niger — Add missing Niamey urban community (NE-8)
North Korea — Add missing metropolitan cities (Nampho, Kaesong)
North Macedonia — Update municipality data
Oman — Fix governorate structure per ISO 3166-2:OM
Pakistan — Remove deprecated FATA state, merge cities into Khyber Pakhtunkhwa (ISO 3166-2:PK)
Panama — Add missing Naso Tjër Di indigenous region (PA-NT)
Paraguay — Add 4 cities to Central department and fix Asuncion
Peru — Add missing PE-LMA (Municipalidad Metropolitana de Lima)
São Tomé and Príncipe — Fix administrative divisions per ISO 3166-2:ST
Serbia — Add missing administrative divisions per ISO 3166-2:RS
Seychelles — Add 3 missing districts per ISO 3166-2:SC
Sierra Leone — Add missing province and cities
Slovenia — Add missing Velenje urban municipality (SI-133)
Somalia — Add missing Sool and Woqooyi Galbeed regions (ISO 3166-2:SO)
Spain — Add 3 missing autonomous communities per ISO 3166-2:ES; fix 474 city name prefixes and apostrophes
Taiwan — Add missing Chiayi County (TW-CYQ) and Hsinchu County (TW-HSQ)
Tajikistan — Add missing capital territory Dushanbe (TJ-DU)
Timor-Leste — Add missing Oecusse-Ambeno special administrative region
Trinidad and Tobago — Fix administrative divisions to match ISO 3166-2
UK — Update countries to include states and cities
Wallis and Futuna Islands — Add missing administrative precincts (ISO 3166-2:WF)
Yemen — Add missing Ad Dali' governorate (YE-DA); fix city timezones, remove duplicates

🐛 Bug Fixes

Fix duplicate states: remove 16 duplicate state records and reassign 30 cities
Fix city assignments: move 130 Irkutsk Oblast cities from Sevastopol to correct state
Fix Åland Islands duplication: remove duplicate state entry from Finland
Fix 178 data integrity issues in contributions JSON files
Fix Poland cities: remove 314 powiats incorrectly classified as cities
Fix Chile: remove comunas incorrectly listed as cities in Región Metropolitana
Fix timezone inconsistencies: add Etc/GMT filtering and update states data
Fix NULL handling in export workflow (Antarctica subregion_id)
Fix DuckDB conversion failure with individual SQLite table files
Fix Bahrain: remove Central governorate
Fix Bosnia and Herzegovina: remove extra cantons
Fix Saint Lucia: remove extra districts
Fix state & city names across multiple countries
Fix currency and currency_symbol for Western Sahara and Congo
Fix Vietnam state codes and The Gambia country name whitespace
Fix Albania states and Greece states and cities
Fix Ivory Coast English and Native Name
Fix French cities native names
Fix state population cast to integer in JSON exporter
Add missing timezones and fix typos
Remove duplicate cities (Shaw/US, Canberra/Australia)

🗄️ Schema & Infrastructure

Refactor world.sql: clean up table drop statements, add timezone field
Fix schema file formats: add PostgreSQL schema export, remove SQL Server schema
Restructure contributions workflow
Streamline README content and improve clarity
Add changelog functionality
Add GitHub Copilot instructions

New Contributors

@Copilot made their first contribution in [#1067](#1067)
@tomaytotomato made their first contribution in [#1106](#1106)
@edyhvh made their first contribution in [#1108](#1108)
@Towbee05 made their first contribution in [#1213](#1213)
@Charles-Chrismann made their first contribution in [#1238](#1238)
@swkim0911 made their first contribution in [#1321](#1321)

Full Changelog: v3.0...v3.1

Contributors

tomaytotomato, edyhvh, and 3 other contributors

Assets 2

02 Aug 11:53

dr5hn

v3.0

4916592

v3.0

!!Breaking Change

BREAKING CHANGE: Updated keys in states.json from 'state_code' to 'iso2' for consistency.

What's Changed

Cities Updates by @Aakash315 in #987
change state name of UAE, Egypt and Kuwait by @Aakash315 in #995
changes some data and also add data by @Aakash315 in #996
add missing states and cities by @Aakash315 in #998
Fix: optimize prisma seeder to reduce DB queries and improve performance by @Khuzaima01 in #999
changes in cities table by @Aakash315 in #1001
update netherland provinces by @Aakash315 in #1003
update france & brazil cities by @Aakash315 in #1021
upadte maxico by @Aakash315 in #1022
Improve Workflow by @dr5hn in #1033
Fix Norway county and cities by @Aakash315 in #1037
Add breton (br) language by @YoruNoHikage in #1035
remove duplicate cities and states or add capital city of mongolia by @Aakash315 in #1046
Fix/json error by @Aakash315 in #1054

New Contributors

@Khuzaima01 made their first contribution in #999
@YoruNoHikage made their first contribution in #1035

Full Changelog: v2.6...v3.0

Contributors

YoruNoHikage, dr5hn, and 2 other contributors

Assets 2

25 Mar 06:37

dr5hn

v2.6

1443c3b

v2.6

What's NEW!

SQL Server support by @dr5hn in #906
MongoDB support by @dr5hn in #967
Added Parent ID and Levels in States table to accomodate different hierarchies of countries with different structures.

What's Changed

fix: Add Missing cities in Isle of Man and Jersey by @Aakash315 in #899
fix: Solve inconsistent languages issue by @Aakash315 in #905
fix: Update Cities And States Of Greece by @Aakash315 in #904
Fix some currencies by @mtsfer in #909
Fix: Update Cities on Banten, Indonesia by @Aakash315 in #911
fix: Insert Missing data in Vietnam by @Aakash315 in #912
fix: Solve cities problem in Argentina by @Aakash315 in #910
Fix: world.sql import error by @souravdutt in #931
update table by @Aakash315 in #928
add states by @Aakash315 in #935
update types by @Aakash315 in #936
add column by @Aakash315 in #943
fix: JSON export region_id type consistency by @gschaer in #957
feat: add if exists flag in postgresql by @dr5hn in #963
fix: #951 INSERT conflicts with FOREIGN KEY by @dr5hn in #964
Correction/telangana by @Aakash315 in #975
Correction/china by @Aakash315 in #976
Correction/srilanka by @Aakash315 in #980
Correction of City and Municipaliy iin Aklan and Antique Provinces, P… by @Aakash315 in #974
Corrections by @Aakash315 in #978
Level/parent by @Aakash315 in #981
Fix/poland by @Aakash315 in #985
Add/cities by @Aakash315 in #986

BREAKING Change

Drop support for additional xml, sqlite, yml combination files by @dr5hn in #907
Removed states+cities.json file. by @dr5hn in b19d5b7
Optimised countries+states.json and countries+cities.json file content with only name of the entities. by @dr5hn in b19d5b7

New Contributors

@souravdutt made their first contribution in #931
@gschaer made their first contribution in #957

Full Changelog: v2.5...v2.6

Contributors

gschaer, dr5hn, and 3 other contributors

Assets 2

13 Oct 13:22

dr5hn

v2.5

660dd0e

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

Contributors

aglundahl, rvtraveller, and 5 other contributors

Assets 2

07 Sep 14:15

dr5hn

v2.4

2e18b2e

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

Contributors

md3e, ACR1209, and 2 other contributors

Assets 2

07 Jul 08:31

dr5hn

v2.3

d75d669

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

Contributors

ymg2006, skpeter, and 7 other contributors

Assets 2

16 Feb 15:11

dr5hn

v2.2

9c89297

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

Contributors

rsenses, dr5hn, and scottgigante

Assets 2

24 Jan 08:36

dr5hn

v2.1

aef9b85

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

Contributors

slackero, adevade, and 7 other contributors

Assets 2

03 Sep 11:25

dr5hn

v2.0

8fa597a

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