2025-03-03     2025-03-04     2025-03-05

international feature does not have an adm2 code

number of errors=0
number of warnings=0

select geonameid,name,featurecode,countrycode,admincode1,admincode2 from geoname where (admincode2 is not null or admincode3 is not null or admincode4 is not null or admincode5 is not null) and length(cc2)>8

geonameid	name	featurecode	countrycode	admincode1	admincode2