search

dr5hn / countries-states-cities-database

🌍 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
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.3k stars 2.54k forks source link

fix: some of cities has wrong state codes #600

Closed mowaiskalam closed 1 year ago

mowaiskalam commented 1 year ago

Hi, firstly thank you for this database, this help a lot when working with country, state and cities in our applications

I was trying to create migration in our system using the csv files and find out that the cities.csv file has some wrong information of state code, verified that records from live demo find out that it has wrong state code

Just fixed those states codes

dr5hn commented 1 year ago

@mowaiskalam Thanks for your efforts. Much Appreciated.

Can you please make those updates in world.sql? As the cities.csv file is auto generated.

Thanks again!

mowaiskalam commented 1 year ago

@dr5hn Thanks for the review I have fixed both cities.sql and world.sql files

dr5hn commented 1 year ago

@mowaiskalam can you please remove the cities.csv and cities.sql from this PR and keep only world.sql?

mowaiskalam commented 1 year ago

@dr5hn Removed cities.csv and cities.sql from the PR