number of errors=76
number of warnings=0
Group=ckgGrpPopulation
select countrycode,name,geonameid from geoname where featurecode='PPLA' and not population >0 order by countrycode
countrycode name geonameid AI Sandy Hill 11205445 AI George Hill 3573466 AI Island Harbour 3573456 AI North Hill Village 3573420 AI North Side 3573418 AI South Hill Village 3573385 AI The Quarter 3573375 AI West End Village 3573364 AI Farrington 3573378 AI Stoney Ground 3573380 BB Welchman Hall 3373430 BB Four Cross Roads 3373877 BB Checker Hall 3373993 BS Governor’s Harbour 3572313 BS Hard Bargain 3572233 BS Masons Bay 3571908 BS Black Point 3572796 BT Lungtenzampa 10172752 CG Loango 2258375 DZ Djanet 2500275 DZ In Guezzam 2493273 FJ Ahau 2205310 GG Torteval 3042274 GG Saint Andrew 6692240 GG Saint Saviour 6424194 GG St Martin 6696773 GG Castel 6692239 GG St Anne 3042289 GH Sefwi Wiawso 2294056 GQ Djibloho 12226438 GY Fort Wellington 8314122 IM Kirk Braddan 3042221 IM Maughold 3042210 IM Lezayre 3042213 IM Jurby 3042224 IM Crosby 3042245 IM Bride 3042259 IM Kirkmichael 3042220 IM Port Saint Mary 3042195 IM Ballaugh 8468983 IM Ballasalla 3042264 IM Ballabeg 3042267 IM Santon 3042182 IM Patrick 3042199 IM Andreas 3042271 IM Onchan 3042201 IN Amarāvati 12465603 JE Le Hocq 10942508 KE Kathwana 11764747 KW Mubārak al Kabīr 7329411 KY Little Cayman 9294258 LV Berģi 461064 ME Petnjica 3220594 MH Loen 7306521 MH Airuk 7306515 MH Taroa 4039539 MH Enewetak 7306511 MR Arafat 9222766 MS Saint Peters 3578038 NR Yangor 2110419 NR Anibare 2110447 PA Llano Tugrí 3705678 PG Buka 8714539 PG Kurumul 2092952 PW Ngereklmadel 1559820 QA Az̧ Z̧a‘āyin 289847 QA Umm Şalāl ‘Alī 289524 SB Taro 11423653 SC La Passe 11103219 SD El Fula 11003055 UZ Amir Timur 1514027 VN Thành Phố Bà Rịa 8594709 VU Saratamata 8581458 WS Satupa‘itea 4035045 WS Safotulafai 4035117 YE Al Jabīn 401043