2025-06-25     2025-06-26     2025-06-27

no adm1 has more than one capital

number of errors=1
number of warnings=0

select count(*),countrycode,admincode1 from geoname where featurecode = 'PPLA' and countrycode || admincode1 not in ('ES53','PL76','NO30','NO34','NO38','NO42','NO46','NO54','IN12') group by 2,3 having count(*)>1 order by 2,3

count	countrycode	admincode1	
2	GY	16