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
6.81k stars 2.44k forks source link

Add to a new country and 5 new cities, some data editing information #747

Open cihanbagdatli opened 4 months ago

cihanbagdatli commented 4 months ago

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"

It was previously used as "Turkey", but now the name of the country is officially used as "Türkiye" in the United Nations (UN) and throughout the global arena.

SUGGEST 2: DB: World>Countries>ID:57 name="South Cyprus" translations->tr="Güney Kıbrıs"

SUGGEST 3: DB: World>Countries> +NEW INSERT INTO countries (id, name, iso3, numeric_code, iso2, phonecode, capital, currency, currency_name, currency_symbol, tld, native, region, region_id, subregion, subregion_id, nationality, timezones, translations, latitude, longitude, emoji, emojiU, created_at, updated_at, flag, wikiDataId) VALUES (251, 'North Cyprus', 'NCY', 'NULL', 'CT', '90', 'Lefkoşa', 'TRY', 'Turkish lira', '₺', 'ct.tr', 'Kuzey Kıbrıs', 'Europe', '3', 'Southern Europe', '16', 'Turkish Cypriot','[{\"zoneName\":\"Asia/Nicosia\",\"gmtOffset\":7200,\"gmtOffsetName\":\"UTC+02:00\",\"abbreviation\":\"EET\",\"tzName\":\"Eastern European Time\"}]','{\"kr\":\"북키프로스\",\"pt-BR\":\"Norte do Chipre\",\"pt\":\"Norte do Chipre\",\"nl\":\"Noord Cyprus\",\"hr\":\"Sjeverni Cipar\",\"fa\":\"قبرس شمالی\",\"de\":\"Nord Zypern\",\"es\":\"El norte de Chipre\",\"fr\":\"Chypre du Nord\",\"ja\":\"北キプロス・トルコ共和国\",\"it\":\"Cipro Nord\",\"cn\":\"北塞浦路斯土耳其共和国\",\"tr\":\"Kuzey Kıbrıs\"}', '35.19000000', '33.35000000', 'NULL', 'NULL', '2024-02-04 00:14:53', '2024-02-05 00:14:53', '1', 'Q23681');

DB: World>States> +NEW Cities of North Cyprus INSERT INTO states (id, name, country_id, country_code, fips_code, iso2, type, latitude, longitude, created_at, updated_at, flag, wikiDataId) VALUES ('NULL', 'Girne', '251', 'CT', '99', '350', 'province', '35.33000000', '33.31000000', '2024-02-05 00:14:53', '2024-02-05 00:14:53', '1', 'Q206760');

INSERT INTO states (id, name, country_id, country_code, fips_code, iso2, type, latitude, longitude, created_at, updated_at, flag, wikiDataId) VALUES ('NULL', 'Gazimağusa', '251', 'CT', '99', '520', 'province', '35.11000000', '33.89000000', '2024-02-05 00:14:53', '2024-02-05 00:14:53', '1', 'Q554671');

INSERT INTO states (id, name, country_id, country_code, fips_code, iso2, type, latitude, longitude, created_at, updated_at, flag, wikiDataId) VALUES ('NULL', 'Güzelyurt', '251', 'CT', '99', '800', 'province', '35.2100000', '32.9000000', '2024-02-05 00:14:53', '2024-02-05 00:53:41', '1', 'Q830638');

INSERT INTO states (id, name, country_id, country_code, fips_code, iso2, type, latitude, longitude, created_at, updated_at, flag, wikiDataId) VALUES ('NULL', 'İskele', '251', 'CT', '99', '870', 'province', '35.2800000', '33.8500000', '2024-02-05 00:14:53', '2024-02-05 00:53:41', '1', 'Q344055');

INSERT INTO states (id, name, country_id, country_code, fips_code, iso2, type, latitude, longitude, created_at, updated_at, flag, wikiDataId) VALUES ('NULL','Lefkoşa', '251', 'CT', '99', '280', 'province', '35.1900000', '33.3500000', '2024-02-05 00:14:53', '2024-02-05 00:52:36', '1', 'Q556055');

INSERT INTO states (id, name, country_id, country_code, fips_code, iso2, type, latitude, longitude, created_at, updated_at, flag, wikiDataId) VALUES ('NULL','Lefke', '251', 'CT', '99', '790', 'province', '35.1098723', '32.8413462', '2024-02-05 00:14:53', '2024-02-05 00:52:36', '1', 'Q967211');

Thanks to all the developers for their efforts!

dr5hn commented 4 months ago

@dosubot Please help me raise a PR for this.

dosubot[bot] commented 4 months ago

Thank you for your efforts in identifying these areas for improvement in the database. It's great to see your dedication to enhancing the data. Your proposed changes look comprehensive and well-documented. I encourage you to go ahead and raise a pull request for these updates. Your contributions will be valuable to the project. Keep up the good work!

#### About Dosu This response is meant to be useful and save you time. It is **not meant to be a precise solution**, but rather a starting point for your own research. Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant. If you want to continue the conversation, start your reply with @dosu-bot.