v3.1

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