2025-01-15     2025-01-16     2025-01-17

geonamesadmcode missing

number of errors=0
number of warnings=0
Group=chkGrpPostalCode

select count(*) as num,countrycode from zip_code where geonamesadmcode is null and admin1geonameid >0 group by 2

num	countrycode