Missing cities like Sitges in Spain (which is one of the most popular cities)

Good work here,

Just one thing, I have noticed many of the accents are not showing correctly. Is this just me or there is an issue with the encoding? I am referring to the SQL files, for instance, cities.sql.

The SQL database dumps are not correctly encoded. Therefore, special characters are not exported properly. This results in the data files containing strings like these:

AÄ«bak
Montréal
Colón Department

Based on the meta data in the SQL files, it seems that you are using utf8mb4 as your DB encoding. To export the data in the correct format, specify the encoding when exporting the data, as shown here:

mysqldump -u user_name -p database_name --default-character-set=utf8mb4 --result-file=date_file_name.sql

If you re-export the SQL files, I will test them for you.

I've noticed that there are plenty of cities are incorrect, lots of duplicated and added from other countries just check the json file for: "Zirakpur" for example.

Export to plist

Export to XML

• Add Dependent Search Options (#44)

Hello!

For Colombia there aren't some important cities.
Bogotá, is the capital of Colombia.
Medellín, is the capital of Antioquia.

Missing very famous cities like Surat, Rajkot, Bharuch, etc of Gujarat State.

It's missing in the states.json

{
        "id": null,
        "name": "Sinop Province",
        "country_id": 225,
        "country_code": "TR",
        "state_code": "57"
}

Current Spelling is Pathanāmthitta and it is wrong. Correct name is Pathanamthitta.
id=133380

Hi friend!! tnks a lot for this database, only missing the state of Jalisco with its cities... tnks again!

Ladakh a new U.T. was carved out of Jammu & Kashmir state in India. Leh & Kargil are the two cities in Ladakh. Earlier the two cities were in Jammu & Kashmir state

I found that some MySQL city and state characters encoding are wrong can you please fix it and update code.
One example:-
Rožaje Municipality

is there is any paid version of it , to get accurate data

Shanxi 山西

For Morocco the region was correct but the cities doesn't

Algeria and American Samoa with the same states.

Hello, I'm interested to contribute to this project, How about adding feature :
"Getting all cities by country " I can get all the cities listed for the country I will select

The states table contains results for Australia, country ID 14, that are not present in Australia. Will send through an update shortly

Cities are still wrong, there are Italian cities duplicated in multiple countries in the JSON file, about 843 of them. Please look at how often "Acquaviva delle Fonti" repeats for example in the states of Korea "Kyeongsangbuk" it is repeated

Another feature that we can add is adding Map visualization to the project

West Bengal state missing from the country India.
Missing all the cities in West Bengal.

Hi, there are several errors with italian regions and cities. For example: Milan is not a region, but a city and Lombardia and Lombardy are the same things.

Hi!

Guarda District is not in the state table

https://en.wikipedia.org/wiki/Portugal#Administrative_divisions

https://www.wikidata.org/wiki/Q273533

Thanks for your great work!

Some thing is wrong with the United kingdom data. All states have the same cities. Cities and States are also wrong. Check screenshot

Hello Friend! 😁

Checking the countries+states.json I realized that the following states were missing for Venezuela:

• Estate: Apure, Capital: San Fernando de Apure
• Estate: Falcón, Capital: Coro

Also, for the state Federal Dependencies of Venezuela, its correct name would be Distrito Capital, whose capital is Caracas

Looks like the Indian state of West Bengal is missing from the list.

I believe Kosovo is missing?

In cities.sql, I live in id=118291 (a county) and also live in id=121951 (city)

Also, you are missing a Minneapolis listing (KS, MN and NC...) https://en.wikipedia.org/wiki/Minneapolis,_North_Carolina

... and, in countries.sql there are places like Vatican and US Minor Outlying Islands that don't have states/"administration areas" or cities - where I am getting with this is, please add latitude and longitude to records on countries.sql and states.sql

No Data is available about "Pakistan".
Wrong List.

I uploaded this and began to play with it. Since I live in the United States, I see all 50 states and a few of the U.S. Territories, but I am also seeing cities such as Byram in Mississippi and Trimble in Missouri, and other cities before selecting the proper state.

Json of cities does not have the cities of Puerto Rico

Missing Roraima state in Brazil.
https://en.wikipedia.org/wiki/Roraima

Regarding Sri Lanka the dataset is wrong

Pretty much every list of U.S. cities & states I've found on GitHub is missing Lexington, Kentucky.

In your data base, the main data file https://github.com/dr5hn/countries-states-cities-database/blob/master/PHP_Scripts/data/us-cities.json#L335 needs to be updated. There's an empty string where Lexington should be listed:

..."LEWISPORT", "", "LIBERTY",...

Lets say that i also want a slug field, how to do so?
Any help??

First of, I'd like to thank you for this great list. it would be great to add states abbreviations as well as postal/zip codes for each city if applicable. I know the list will grow big, but it can be handled through bunch of API calls to size it down.

Writing in the Issue tab... but I actually just wanted to thank you for the Countries and States database. Obviously a lot of research/work went into it, so... Thanks!

Thanks @tudoranghelina91 , Appreciate your contribution.

Country: Philippines

The cities in Cebu is Bataan Cities.

1. There two states named Rheinland-Pfalz and Rhineland-Palatinate, actually both are same state. One is German name and other one is English name. And the cities belongs to both are different, but it can be included in any one of them(I have done a random check in google maps).
2. Also Niederwerth can be added to Rheinland-Pfalz
3. The same issue there with Baveria and Bayern
   The issue there in country+states+cities, countries+states json and cties, world sql files. Raising this issue to know if it's intentional or a bug.

Thank you.

The state of Ohio and the related cities are missing in the DB.

I noticed that the United States is missing a list of cities. Is there any chance you'll add them? If not, would you be able to recommend somewhere I could easily get a list to programmatically add to the list?

Hong Kong is a country and also a city.