countries-states-cities-database

countries-states-cities-database copied to clipboard

I am sharing a few areas that I found that need improvement in the DB: World database. Please let's together apply the all fixes. **SUGGEST 1:** DB: World>Countries>ID:225 name="Türkiye" translations->tr="Türkiye"...

cihanbagdatli

countries.sql -> emoji column has '??'

1

Data missing in emoji column in countries table (sql/countries.sql)

apfromiit

Update states.sql

1

Added Papua New Guinea's East Sepik Province.

RD-PINGEDPNG

2 major cities from Turkey missing (Ankara, Istanbul)

1

1. Ankara 2. Istanbul

harmeet-status

Missing Cities And States Of Greece

2

I don't see Xios here. Also the North Aegean state and its cities seem to be missing. Thank you for your interest.

mertozylmz

Hi, i would like to add city Ulaanbaatar the capital of mongolia. I could not find capital of Mongolia which should be in city inside Tov state

Tsolmonx

Mauritius - duplicate cities

1

[Cities feedback v2.xlsx](https://github.com/dr5hn/countries-states-cities-database/files/13928527/Cities.feedback.v2.xlsx) Hello @dr5hn You will find in the attached document (highlighted in yellow) : (i) duplicate cities to be removed (ii) id 153401 to change state_id, state_code, state_name...

geerishw

city do not change when selected in the dropdown i guess the error is related to values of option the value is same for all options

4

sumiran01

Duplicate Entries in Cities List

3

I've created a php/laravel script to import the Countries, States, Cities and while importing I have found the following duplicates in cities json file Duplicates Entries { "AO_Angola_BGU_Benguela Province_Catumbela": [...

ManojKiranA

France's cities not matching its states code

4

You cannot find the cities of Paris for instance because when you select Paris, you get the state code of '75C' but the cities have the state code 'IDF' for...

romain-sen