Countries States Cities Database Versions Save

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities

v2.2

2 months ago

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

v2.1

3 months ago

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

v2.0

8 months ago

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

v1.9

1 year ago

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

v1.8

2 years ago

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

v1.7

2 years ago

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

v1.6

2 years ago

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

v1.5

2 years ago

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)

v1.4

2 years ago

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

v1.3

3 years ago

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