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.37k stars 2.56k forks source link

Kosovo bug #99

Closed AvdiuAndin closed 4 years ago

AvdiuAndin commented 4 years ago

Thanks for the time that it took to build this repo :) I really appreciate it

I just wanted to let you know that Kosovo is not under/part of Serbia. Therefore, states with ids:

  1. 3730
  2. 3739
  3. 3735 Should be removed and Kosovo should be inserted as a new Country
dr5hn commented 4 years ago

@AvdiuAndin Thanks for reporting. 🎉

What about the cities of Kosovo? Did you get any resources, where I can find the info about Kosovo?

AvdiuAndin commented 4 years ago

Wiki data: https://www.wikidata.org/wiki/Q1246 Cities: https://www.citypopulation.de/en/kosovo/cities/ Country code: https://countrycode.org/kosovo

INSERT INTO countries ( name, iso3, iso2, phonecode, capital, currency, native, emoji, emojiU, flag, wikiDataId) VALUES ('Kosovo', 'XKX', 'XK', '383', 'Prishtina', 'EUR', 'Kosova', '🇽🇰', 'U+1F1FD, U+1F1F0', 1, 'Q1246'),

dr5hn commented 4 years ago

@AvdiuAndin Awesome. Thank you so much. 🎉

dr5hn commented 4 years ago

@AvdiuAndin Done. Please Verify. #102