number of errors=0 number of warnings=0
select countrycode,admincode1,ansiname,geonameid from geoname where featurecode = 'ADM1' and (admincode1 is null or admincode1='') order by countrycode
countrycode admincode1 ansiname geonameid
