You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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
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!
The text was updated successfully, but these errors were encountered: