2025-02-05     2025-02-06     2025-02-07

adm1 with admincode1

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