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

populated places must have a country code

number of errors=0
number of warnings=0

select geonameid,ansiname,featurecode from geoname where featureclass = 'P' and countrycode is null

geonameid	ansiname	featurecode