2025-02-07     2025-02-08     2025-02-09

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