2025-08-15     2025-08-16     2025-08-17

no adm1 has more than one capital

number of errors=13
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	
3	VN	37	
2	VN	48	
2	VN	52	
2	VN	56	
2	VN	66	
3	VN	68	
2	VN	75	
2	VN	79	
2	VN	80	
2	VN	82	
3	VN	86	
2	VN	91	
3	VN	92