number of errors=0
number of warnings=0
select countrycode,admincode1,ansiname,geonameid from geoname where geonameid not in (3163480) and featurecode = 'ADM1' and admincode1 is not null and admincode1 <>'00' and countrycode || admincode1 not in (select countrycode || admincode1 from geoname where (featurecode = 'PPLC' or featurecode = 'PPLA' or featurecode='PPLG') and countrycode is not null and admincode1 is not null and admincode1 <>'00') and countrycode in ('AT','CH','DE','DK','ES','FI','FR','GB','IT','NL','NO','SE','US','CA','AU','NZ','JP') order by countrycode,admincode1
AT,CH,DE,DK,ES,FI,FR,GB,IT,NL,NO,SE,US,CA,AU,NZ,JP Exception: Akershus Fylke in Norway has Oslo as seat of admin, which is not part of the county.
countrycode admincode1 ansiname geonameid