number of errors=44
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 Lim-Pendé 12902747 null 21 CF Ouham-Fafa 12902746 null 20 CF Mambéré 12902745 null 19 CK Pukapuka 11695389 null 11695389 CK Atiu 11695126 null 11695126 CK Mangaia 11695127 null 11695127 CK Mitiaro 11695386 null 11695386 CK Mauke 11695385 null 11695385 CK Rarotonga 11695425 null 11695425 CK Aitutaki 11695124 null 11695124 CK Manihiki 11695384 null 11695384 CK Palmerston 11695387 null 11695387 CK Penrhyn 11695388 null 11695388 CK Rakahanga 11695390 null 11695390 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 São Francisco Xavier 11875161 null 11875161 MO São Lázaro 11875156 null 11875156 MO Santo António 11875155 null 11875155 MO São Lourenço 11875158 null 11875158 MO Sé 11875157 null 11875157 MO Nossa Senhora de Fátima 11875154 null 11875154 MO Cotai 11875160 null 11875160 MO Nossa Senhora do Carmo 11875159 null 11875159 NO Akershus 3163480 null 01 NO Troms 3133897 null 18 NO Finnmark 780166 null 05 NO Østfold 3143188 null 13 NO Buskerud 3159665 null 04 NO Telemark 3134723 null 17 NO Vestfold 3132015 null 20 PS West Bank 285153 WE WE PS Gaza Strip 281132 GZ GZ RS Serbia Centrale 785958 null SE ST Sao Tome 2410764 02 02 TW Taiwan 7280291 null 04 TW Taipei 7280290 null 03 TW Fukien 7280288 null 01 TW Kaohsiung 7280289 null 02 TZ Songwe 11124984 32 32