number of errors=78
number of warnings=0
Group=chkGrpISO
select countrycode,name,subdivisionid,fips,geonamesadmcode from countrysubdivision where subdivisionid >0 and iso_3166_2 is null and admlevel=1 and validtill is null and countrycode not in ('AI','AX','FO','GG','GU','IM','JE','KY','MG','MS','PR','TF','XK','YT') order by countrycode
countrycode name subdivisionid fips geonamesadmcode AZ Susa Sahari 409419 56 56 CF Ouham-Fafa 12902746 null 20 CF Lim-Pendé 12902747 null 21 CF Mambéré 12902745 null 19 CK Mitiaro 11695386 null 11695386 CK Mangaia 11695127 null 11695127 CK Mauke 11695385 null 11695385 CK Pukapuka 11695389 null 11695389 CK Aitutaki 11695124 null 11695124 CK Rarotonga 11695425 null 11695425 CK Manihiki 11695384 null 11695384 CK Palmerston 11695387 null 11695387 CK Penrhyn 11695388 null 11695388 CK Rakahanga 11695390 null 11695390 CK Atiu 11695126 null 11695126 ET Central Ethiopia Regional State 12902749 null 55 ET South Ethiopia Regional State 12902766 null 56 IQ Halabja 12218240 19 19 KZ Baykonyr 1538316 08 08 MK Skopje 11398357 F6 F6 MO Cotai 11875160 null 11875160 MO São Lázaro 11875156 null 11875156 MO São Francisco Xavier 11875161 null 11875161 MO Sé 11875157 null 11875157 MO Nossa Senhora de Fátima 11875154 null 11875154 MO São Lourenço 11875158 null 11875158 MO Santo António 11875155 null 11875155 MO Nossa Senhora do Carmo 11875159 null 11875159 NO Troms 3133897 null 18 NO Østfold 3143188 null 13 NO Akershus 3163480 null 01 NO Buskerud 3159665 null 04 NO Telemark 3134723 null 17 NO Vestfold 3132015 null 20 NO Finnmark 780166 null 05 PS Gaza Strip 281132 GZ GZ PS West Bank 285153 WE WE RS Serbia Centrale 785958 null SE ST Sao Tome 2410764 02 02 TW Taipei 7280290 null 03 TW Fukien 7280288 null 01 TW Kaohsiung 7280289 null 02 TW Taiwan 7280291 null 04 TZ Songwe 11124984 32 32 VN Quang Tri 13494350 null 44 VN Quang Ngai 13494352 null 51 VN Gia Lai 13494353 null 52 VN Khanh Hoa 13494354 null 56 VN Dak Lak 13494355 null 66 VN Lam Dong 13494356 null 68 VN Dong Nai 13494357 null 75 VN Tay Ninh 13494359 null 80 VN Dong Thap 13494360 null 82 VN Vinh Long 13494361 null 86 VN An Giang 13494362 null 91 VN Ca Mau 13494364 null 96 VN Tuyen Quang 13494365 null 08 VN Dien Bien 1905099 null 11 VN Lai Chau 1577954 null 12 VN Son La 1567643 null 14 VN Lang Son 1576632 null 20 VN Hai Phong 13494346 null 31 VN Da Nang City 13494351 null 48 VN Ho Chi Minh City (HCMC) 13494358 null 79 VN Can Tho City 13494363 null 92 VN Quang Ninh 1568758 null 22 VN Thanh Hoa 1566165 null 38 VN Nghe An 1559969 null 40 VN Ha Tinh 1580700 null 42 VN Cao Bang 1586182 null 04 VN Hanoi 1581129 null 01 VN Hue 1565033 null 46 VN Lao Cai 13494334 null 15 VN Thai Nguyen 13494335 null 19 VN Bac Ninh 13494344 null 24 VN Phu Tho 13494345 null 25 VN Hung Yen 13494347 null 33 VN Ninh Binh 13494348 null 37