Skip to content

changelog.mdx

Latest commit

 

History

History
150 lines (122 loc) · 4.99 KB

changelog.mdx

File metadata and controls

150 lines (122 loc) · 4.99 KB
title Changelog
description Track the latest updates, improvements, and changes to the Country State City ecosystem including API, database, and tools.
icon clock

Changelog

Stay up-to-date with the latest improvements, new features, and changes across the Country State City ecosystem.

This changelog is automatically synced from [GitHub releases](https://github.com/dr5hn/countries-states-cities-database/releases). For detailed technical information, visit the repository.

2025

This release contains breaking changes. Updated keys in `states.json` from 'state_code' to 'iso2' for consistency.

New Features

  • Updated keys in states.json from 'state_code' to 'iso2' for consistency
  • Add breton (br) language support
  • Improved workflow and optimization features
  • Add missing states and cities for various countries

Improvements

  • Cities Updates across multiple regions
  • Change state name of UAE, Egypt and Kuwait
  • Update Netherlands provinces
  • Update France & Brazil cities
  • Update Mexico data
  • Fix Norway county and cities
  • Remove duplicate cities and states, add capital city of Mongolia
  • Optimize Prisma seeder to reduce DB queries and improve performance

Bug Fixes

  • Fix JSON formatting errors
  • Various data corrections and updates
  • Coordinate and naming fixes for multiple regions
## New Features - **SQL Server support**: Complete integration with Microsoft SQL Server - **MongoDB support**: NoSQL database support for flexible geographical queries - **Parent ID and Levels**: Added hierarchical structure in States table to accommodate different country administrative structures

Improvements

  • Add Missing cities in Isle of Man and Jersey
  • Solve inconsistent languages issue
  • Update Cities And States Of Greece
  • Fix some currencies
  • Update Cities on Banten, Indonesia
  • Insert Missing data in Vietnam
  • Solve cities problem in Argentina
  • JSON export region_id type consistency

Bug Fixes

  • Fix world.sql import error
  • Add if exists flag in PostgreSQL
  • Fix INSERT conflicts with FOREIGN KEY
  • Various corrections for Telangana, China, and Sri Lanka

2024

## New Features - Add Turkish translations for country names - Add Baghdad cities

Improvements

  • Change 'br' translations to 'pt-BR' to match i18n mappings
  • Add N'Djamena city under N'Djamena region
  • Fix coordinates of Hunan, China
  • Updated cities of "Pirkanmaa" region
  • Add missing Hillsborough & Montgomery townships to New Jersey

Bug Fixes

  • Removed HongZhou from China
  • Added Nabeul state in Tunisia
  • Add missing cities of the Province of Ravenna
  • Add missing states of Puerto Rico Country
  • Add missing states and cities of the U.S. Virgin Islands
  • Various fixes for Morocco, Egypt, Hungary, Salem, and other regions
## Improvements - Fixes and improves to states and cities from Colombia - Improve Ecuador States and cities - Add lat/lng data for two states in Brazil - Update Mexico State and cities names and improve state code - Fix Brazil states latlng for Bahia and Acre - Add missing Croatian county - Karlovac County

Bug Fixes

  • Add missing neighbourhood in Uruguay-Montevideo
  • Update Odessa city name
  • Trim state type field values
  • Add commands to output other SQL files via GitHub actions
  • Add type to Cambodia's provinces and add missing province
  • Various city and state corrections across multiple countries

Release Information

Our releases follow semantic versioning (SemVer) with the following format: - **Major.Minor.Patch** (e.g., 3.0.0) - **Major**: Breaking changes requiring migration - **Minor**: New features with backward compatibility - **Patch**: Bug fixes and minor improvements

Stay Updated

Get notified about new releases and download assets directly from GitHub. Access the API and get your developer key for integration.

Contributing to Updates

We welcome community contributions to keep our geographical data accurate and up-to-date.

Notice outdated or incorrect geographical information? Check our data against official government sources. Submit changes through our [Update Tool](/tools/update-tool) with proper documentation and sources. Our team reviews all submissions for accuracy and integrates approved changes into the next release. All major data updates are tested extensively before release to ensure accuracy and maintain API compatibility.