2025-03-02     2025-03-03     2025-03-04

each adm1 has a link to the corresponding wikipedia article

number of errors=2
number of warnings=0
Group=ckgGrpWP

select geonameid,name,countrycode,admincode1 from geoname where featurecode='ADM1' and admincode1<>'00' and not exists (select 1 from alternatename where geoname.geonameid=alternatename.geonameid and namelocale='link' and name like 'https://en.wikipedia.org/%') order by countrycode

[{key=SC,number=2}]

geonameid	name	countrycode	admincode1	
12200079	Ile Perseverance I	SC	12200079	
12200080	Ile Perseverance II	SC	12200080