Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
cihanbagdatli opened this issue Feb 4, 2024 · 0 comments

Comments

@cihanbagdatli
Copy link

cihanbagdatli commented Feb 4, 2024

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!

@cihanbagdatli cihanbagdatli changed the title Add to 1 new country and 5 new cities, some data editing information Add to a new country and 5 new cities, some data editing information Feb 4, 2024
Repository owner deleted a comment from dosubot bot Sep 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant