number of errors=434
number of warnings=0
Group=chkGrpSubdivision
select geonameid,ansiname,countrycode,admincode1,admincode2 from geoname where featurecode='ADM2' and not exists (select 1 from countrysubdivision where geoname.countrycode=countrysubdivision.countrycode and admincode2=geonamesadmcode) and admincode1<>'00' and admincode2 is not null and countrycode in (select countrycode from countrysubdivision where geonameslevel=2) order by countrycode,admincode1,admincode2
Number of countries=13;
[{key=HU,number=197}, {key=NP,number=77}, {key=FI,number=66}, {key=AL,number=61}, {key=AZ,number=14}, {key=BA,number=8}, {key=PH,number=5}, {key=ES,number=1}, {key=FJ,number=1}, {key=GB,number=1}, {key=GN,number=1}, {key=IS,number=1}, {key=ST,number=1}]
geonameid ansiname countrycode admincode1 admincode2 10944368 Bashkia Berat AL 40 10944368 10944369 Bashkia Kucove AL 40 10944369 10944370 Bashkia Polican AL 40 10944370 10944371 Bashkia Skrapar AL 40 10944371 10944372 Bashkia Ura Vajgurore AL 40 10944372 10944373 Bashkia Bulqize AL 41 10944373 10944374 Bashkia Diber AL 41 10944374 10944375 Bashkia Klos AL 41 10944375 10944376 Bashkia Mat AL 41 10944376 10944377 Bashkia Durres AL 42 10944377 10944378 Bashkia Kruje AL 42 10944378 10944379 Bashkia Shijak AL 42 10944379 10944380 Bashkia Elbasan AL 43 10944380 10944381 Bashkia Belsh AL 43 10944381 10944382 Bashkia Cerrik AL 43 10944382 10944383 Bashkia Gramsh AL 43 10944383 10944384 Bashkia Librazhd AL 43 10944384 10944385 Bashkia Peqin AL 43 10944385 10944386 Bashkia Prrenjas AL 43 10944386 10944387 Bashkia Divjake AL 44 10944387 10944388 Bashkia Fier AL 44 10944388 10944389 Bashkia Lushnje AL 44 10944389 10944390 Bashkia Mallakaster AL 44 10944390 10944391 Bashkia Patos AL 44 10944391 10944392 Bashkia Roskovec AL 44 10944392 10944393 Bashkia Dropull AL 45 10944393 10944394 Bashkia Gjirokaster AL 45 10944394 10944395 Bashkia Kelcyre AL 45 10944395 10944396 Bashkia Libohove AL 45 10944396 10944397 Bashkia Memaliaj AL 45 10944397 10944398 Bashkia Permet AL 45 10944398 10944399 Bashkia Tepelene AL 45 10944399 10944400 Bashkia Devoll AL 46 10944400 10944401 Bashkia Kolonje AL 46 10944401 10944402 Bashkia Korce AL 46 10944402 10944403 Bashkia Maliq AL 46 10944403 10944404 Bashkia Pogradec AL 46 10944404 10944405 Bashkia Pustec AL 46 10944405 10944406 Bashkia Has AL 47 10944406 10944407 Bashkia Kukes AL 47 10944407 10944408 Bashkia Tropoje AL 47 10944408 10944409 Bashkia Kurbin AL 48 10944409 10944410 Bashkia Lezhe AL 48 10944410 10944411 Bashkia Mirdite AL 48 10944411 10944412 Bashkia Fushe Arres AL 49 10944412 10944413 Bashkia Malesi e Madhe AL 49 10944413 10944414 Bashkia Puke AL 49 10944414 10944415 Bashkia Shkoder AL 49 10944415 10944416 Bashkia Vau i Dejes AL 49 10944416 10944417 Bashkia Kamez AL 50 10944417 10944418 Bashkia Kavaje AL 50 10944418 10944419 Bashkia Rrogozhine AL 50 10944419 10944420 Bashkia Tirane AL 50 10944420 10944421 Bashkia Vore AL 50 10944421 10944422 Bashkia Delvine AL 51 10944422 10944423 Bashkia Finiq AL 51 10944423 10944424 Bashkia Himare AL 51 10944424 10944425 Bashkia Konispol AL 51 10944425 10944426 Bashkia Sarande AL 51 10944426 10944427 Bashkia Selenice AL 51 10944427 10944428 Bashkia Vlore AL 51 10944428 585638 Leninskiy Rayon AZ 01 585638 585882 Kirovskiy Rayon AZ 01 585882 585039 Shaumyanovskiy Rayon AZ 09 585039 585320 Ordzhonikidzevskiy Rayon AZ 09 585320 585328 Oktyabr'skiy Rayon AZ 09 585328 585358 Nizaminskiy Rayon AZ 09 585358 586209 Garadagh region AZ 09 586209 586342 Imeni Dvadtsati Shesti Bakinskikh Komissarov Rayon AZ 09 586342 7669203 Khatai raion AZ 09 7669203 8572651 Nizami Rayonu AZ 09 8572651 585038 Shaumyan Rayon AZ 21 585038 148412 Nakhchivan City AZ 35 148412 8411069 Nakhchivan AZ 35 8411069 585509 Mirbasir Rayonu AZ 57 585509 11169977 Grad Istocno Sarajevo BA 02 11169977 11170599 Stanari BA 02 11170599 3294911 Opstina Modrica BA 02 3294911 3294915 Opstina Novi Grad BA 02 3294915 3344087 Opstina Krupa na Uni BA 02 3344087 3344090 Opstina Vukosavlje BA 02 3344090 3344099 Mrkonjic Grad Jug Opcina BA 02 3344099 3344119 Skelani Opstina BA 02 3344119 8335120 Melilla ES ML ME 9610677 Helsinki sub-region FI 01 011 9610695 Raaseporin FI 01 014 9610696 Porvoo FI 01 015 9610697 Loviisa FI 01 016 9610642 Aboland-Turunmaa FI 02 021 9610643 Salo FI 02 022 9610674 Turku FI 02 023 9610675 Vakka-Suomi FI 02 024 9610676 Loimaa FI 02 025 9610678 Rauma FI 04 041 9610679 Pori FI 04 043 9610680 Pohjois-Satakunta FI 04 044 9610681 Haemeenlinna FI 05 051 9610682 Riihimaeki FI 05 052 9610683 Forssa FI 05 053 9610684 Luoteis-Pirkanmaa FI 06 061 9610685 Etelae-Pirkanmaa FI 06 063 9610686 Tampere FI 06 064 9610687 Lounais-Pirkanmaa FI 06 068 9610688 Ylae-Pirkanmaa FI 06 069 9610689 Lahti FI 07 071 9610690 Kouvola FI 08 081 9610691 Kotka-Hamina FI 08 082 9610692 Lappeenranta FI 09 091 9610693 Imatra FI 09 093 9610694 Mikkeli FI 10 101 9610644 Savonlinna FI 10 103 9610645 Pieksaemaeki FI 10 105 9610646 Ylae-Savo FI 11 111 9610647 Kuopio FI 11 112 9610648 Koillis-Savo FI 11 113 9610649 Varkaus FI 11 114 9610650 Sisae-Savo FI 11 115 9610651 Joensuu FI 12 122 9610652 Keski-Karjala FI 12 124 9610653 Pielisen Karjala FI 12 125 9610654 Jyvaeskylae FI 13 131 9610655 Joutsa FI 13 132 9610657 Keuruu FI 13 133 9610658 Jaemsae FI 13 134 9610659 AEaenekoski FI 13 135 9610660 Saarijaervi-Viitasaari FI 13 138 9610661 Suupohja FI 14 141 9610663 Seinaejoki FI 14 142 9610664 Kuusiokunnat FI 14 144 9610665 Jaerviseutu FI 14 146 9610668 Vaasa FI 15 152 9610576 Sydosterbotten FI 15 153 9610669 Jakobstadsregionen FI 15 154 9610670 Kaustinen FI 16 161 9610671 Kokkola FI 16 162 9610672 Oulu FI 17 171 9610673 Oulunkaari FI 17 173 9610698 Raahe FI 17 174 9610699 Haapavesi-Siikalatva FI 17 175 9610700 Nivala-Haapajaervi FI 17 176 9610701 Ylivieska FI 17 177 9610702 Koillismaa FI 17 178 9610703 Kehys-Kainuu FI 18 181 9610704 Kajaani FI 18 182 9610705 Rovaniemi FI 19 191 9610706 Kemi-Tornio FI 19 192 9610707 Torniolaakso FI 19 193 9610708 Itae-Lappi FI 19 194 9610709 Tunturi-Lappi FI 19 196 9610712 Pohjois-Lappi FI 19 197 8594939 Rotuma FJ 04 15 2648110 Greater London GB ENG GLA 8335012 Conakry Special Zone GN 04 8335012 9644264 Bacsalmasi Jaras HU 01 034 9644263 Bajai Jaras HU 01 035 9644265 Janoshalmai Jaras HU 01 036 9644268 Kalocsai Jaras HU 01 037 9644271 Kecskemeti Jaras HU 01 038 9644269 Kiskoroesi Jaras HU 01 039 9644273 Kiskunfelegyhazi Jaras HU 01 040 9644266 Kiskunhalasi Jaras HU 01 041 9644267 Kiskunmajsai Jaras HU 01 042 9644270 Kunszentmiklosi Jaras HU 01 043 9644272 Tiszakecskei Jaras HU 01 044 9644192 Bolyi Jaras HU 02 024 9644195 Hegyhati Jaras HU 02 025 9644194 Komloi Jaras HU 02 026 9644191 Mohacsi Jaras HU 02 027 9644190 Pecsi Jaras HU 02 028 9644193 Pecsvaradi Jaras HU 02 029 9644260 Sellyei Jaras HU 02 030 9644189 Siklosi Jaras HU 02 031 9644262 Szentlorinci Jaras HU 02 032 9644261 Szigetvari Jaras HU 02 033 9644287 Bekesi Jaras HU 03 045 9644288 Bekescsabai Jaras HU 03 046 9644289 Gyomaendrodi Jaras HU 03 047 9644283 Gyulai Jaras HU 03 048 9644284 Mezokovacshazai Jaras HU 03 049 9644285 Oroshazi jaras HU 03 050 9644282 Sarkadi Jaras HU 03 051 9644286 Szarvasi Jaras HU 03 052 9644281 Szeghalmi Jaras HU 03 053 9644316 Cigandi Jaras HU 04 054 9644317 Edelenyi Jaras HU 04 055 9644318 Encsi Jaras HU 04 056 9644320 Goenci Jaras HU 04 057 9644321 Kazincbarcikai Jaras HU 04 058 9644322 Mezocsati Jaras HU 04 059 9644323 Mezokoevesdi Jaras HU 04 060 9644324 Miskolci Jaras HU 04 061 9644325 Ozdi Jaras HU 04 062 9644326 Putnoki Jaras HU 04 063 9644327 Sarospataki Jaras HU 04 064 9644328 Satoraljaujhelyi jaras HU 04 065 9644329 Szerencsi Jaras HU 04 066 9644330 Szikszoi Jaras HU 04 067 9644331 Tiszaujvarosi Jaras HU 04 068 9644332 Tokaji Jaras HU 04 069 12059771 Budapest I. HU 05 001 12059754 Budapest II. HU 05 002 12059763 Budapest III. HU 05 003 12059759 Budapest IV. HU 05 004 12059757 Budapest V. HU 05 005 12059772 Budapest VI. HU 05 006 12059775 Budapest VII. HU 05 007 12059761 Budapest VIII. HU 05 008 12059776 Budapest IX. HU 05 009 12059755 Budapest X. HU 05 010 12059760 Budapest XI. HU 05 011 12059758 Budapest XII. HU 05 012 12059773 Budapest XIII. HU 05 013 12059774 Budapest XIV. HU 05 014 12059764 Budapest XV. HU 05 015 12059762 Budapest XVI. HU 05 016 12059770 Budapest XVII. HU 05 017 12059765 Budapest XVIII. HU 05 018 12059756 Budapest XIX. HU 05 019 12059769 Budapest XX. HU 05 020 12059768 Budapest XXI. HU 05 021 12059767 Budapest XXII. HU 05 022 12059766 Budapest XXIII. HU 05 023 9644279 Csongradi Jaras HU 06 070 9644278 Hodmezovasarhelyi Jaras HU 06 071 9644277 Kisteleki Jaras HU 06 072 9644276 Makoi Jaras HU 06 073 9644274 Morahalmi Jaras HU 06 074 9644275 Szegedi Jaras HU 06 075 9644280 Szentesi Jaras HU 06 076 9644763 Bicskei Jaras HU 08 077 9644766 Dunaujvarosi Jaras HU 08 078 9644770 Enyingi Jaras HU 08 079 9644765 Gardonyi Jaras HU 08 080 9644764 Martonvasari Jaras HU 08 081 9644771 Mori Jaras HU 08 082 9644768 Sarbogardi Jaras HU 08 084 9644767 Szekesfehervari Jaras HU 08 085 9644149 Csornai Jaras HU 09 086 9644151 Gyori Jaras HU 09 087 9644148 Kapuvari Jaras HU 09 088 9644150 Mosonmagyarovari jaras HU 09 089 9644153 Pannonhalmi Jaras HU 09 090 9644140 Soproni Jaras HU 09 091 9644152 Teti Jaras HU 09 092 9644296 Balmazujvarosi Jaras HU 10 093 9644294 Berettyoujfalui Jaras HU 10 094 9644292 Debreceni Jaras HU 10 095 9644298 Derecskei Jaras HU 10 096 9644297 Hajduboeszoermenyi Jaras HU 10 097 9644291 Hajduhadhazi Jaras HU 10 098 9644299 Hajdunanasi Jaras HU 10 099 9644295 Hadjuszoboszloi Jaras HU 10 100 9644300 Nyiradonyi Jaras HU 10 101 9644293 Puespoekladanyi Jaras HU 10 102 9644333 Belapatfalvai Jaras HU 11 103 9644334 Egri jaras HU 11 104 9644335 Fuezesabonyi jaras HU 11 105 9644336 Gyoengyoesi Jaras HU 11 106 9644337 Hatvani Jaras HU 11 107 9644338 Hevesi Jaras HU 11 108 9644339 Petervasarai Jaras HU 11 109 9644744 Esztergomi Jaras HU 12 110 9644748 Kisberi Jaras HU 12 111 9644747 Komaromi Jaras HU 12 112 9644749 Oroszlanyi Jaras HU 12 113 9644746 Tatai Jaras HU 12 114 9644745 Tatabanyai Jaras HU 12 115 9644340 Balassagyarmati Jaras HU 14 116 9644341 Batonyterenyei Jaras HU 14 117 9644343 Pasztoi Jaras HU 14 118 9644344 Retsagi Jaras HU 14 119 9644345 Salgotarjani Jaras HU 14 120 9644346 Szecsenyi Jaras HU 14 121 9644348 Aszodi Jaras HU 16 122 9644349 Budakeszi Jaras HU 16 123 9644350 Cegledi Jaras HU 16 124 9644351 Dabasi Jaras HU 16 125 9644352 Dunakeszi Jaras HU 16 126 9644353 Erdi Jaras HU 16 127 9644354 Goedoelloi Jaras HU 16 128 9644355 Gyali Jaras HU 16 129 9644356 Monori Jaras HU 16 130 9644735 Nagykatai Jaras HU 16 131 9644742 Nagykoroesi Jaras HU 16 132 9644739 Pilisvoeroesvari Jaras HU 16 133 9644737 Rackevei Jaras HU 16 134 9644738 Szentendrei Jaras HU 16 135 9644736 Szigetszentmiklosi Jaras HU 16 136 9644740 Szobi Jaras HU 16 137 9644347 Vaci Jaras HU 16 138 9644741 Vecsesi Jaras HU 16 139 9644177 Barcsi Jaras HU 17 140 9644179 Csurgoi Jaras HU 17 141 9644182 Fonyodi Jaras HU 17 142 9644180 Kaposvari Jaras HU 17 143 9644181 Marcali Jaras HU 17 144 9644178 Nagyatadi Jaras HU 17 145 9644187 Siofoki Jaras HU 17 146 9644188 Tabi Jaras HU 17 147 9644307 Baktaloranthazai Jaras HU 18 148 9644313 Csengeri Jaras HU 18 149 9644312 Fehergyarmati Jaras HU 18 150 9644314 Ibranyi Jaras HU 18 151 9644308 Kemecsei Jaras HU 18 152 9644309 Kisvardai Jaras HU 18 153 9644306 Mateszalkai Jaras HU 18 154 9644304 Nagykalloi Jaras HU 18 155 9644305 Nyirbatori Jaras HU 18 156 9644303 Nyiregyhazi Jaras HU 18 157 9644302 Tiszavasvari Jaras HU 18 158 9644311 Vasarosnamenyi Jaras HU 18 159 9644310 Zahonyi Jaras HU 18 160 9644780 Jaszapati Jaras HU 20 161 9644779 Jaszberenyi Jaras HU 20 162 9644785 Karcagi Jaras HU 20 163 9644787 Kunhegyesi Jaras HU 20 164 9644783 Kunszentmartoni Jaras HU 20 165 9644784 Mezoturi Jaras HU 20 166 9644781 Szolnoki Jaras HU 20 167 9644786 Tiszafueredi Jaras HU 20 168 9644782 Toeroekszentmiklosi Jaras HU 20 169 9644774 Bonyhadi jaras HU 21 170 9644773 Dombovari jaras HU 21 171 9644777 Paksi jaras HU 21 172 9644776 Szekszardi jaras HU 21 173 9644772 Tamasi Jaras HU 21 174 9644775 Tolnai jaras HU 21 175 9644160 Celldoemoelki Jaras HU 22 176 9644157 Koermendi Jaras HU 22 177 9644154 Koszegi Jaras HU 22 178 9644159 Sarvari Jaras HU 22 179 9644156 Szentgotthardi Jaras HU 22 180 9644155 Szombathelyi Jaras HU 22 181 9644158 Vasvari Jaras HU 22 182 9644757 Ajkai Jaras HU 23 183 9644753 Balatonalmadi Jaras HU 23 184 9644754 Balatonfueredi Jaras HU 23 185 9644758 Devecseri Jaras HU 23 186 9644750 Papai Jaras HU 23 187 9644756 Suemegi Jaras HU 23 188 9644755 Tapolcai Jaras HU 23 189 9644752 Varpalotai Jaras HU 23 190 9644759 Veszpremi Jaras HU 23 191 9644751 Zirci Jaras HU 23 192 9644171 Keszthelyi Jaras HU 24 193 9644168 Lenti Jaras HU 24 194 9644169 Letenyei Jaras HU 24 195 9644172 Nagykanizsai Jaras HU 24 196 9644167 Zalaegerszegi Jaras HU 24 197 9644170 Zalaszentgroti Jaras HU 24 198 12200082 Sudurnesjabaer IS 43 2507 12095460 Bhojpur NP 1 12095460 12095467 Dhankuta NP 1 12095467 12095475 Ilam NP 1 12095475 12095477 Jhapa NP 1 12095477 12095486 Khotang NP 1 12095486 12095492 Morang NP 1 12095492 12095498 Okhaldhunga NP 1 12095498 12095500 Panchthar NP 1 12095500 12095517 Sankhuwasabha NP 1 12095517 12095523 Solukhumbu NP 1 12095523 12095524 Sunsari NP 1 12095524 12095528 Taplejung NP 1 12095528 12095529 Terathum NP 1 12095529 12095530 Udayapur NP 1 12095530 12095457 Bara NP 2 12095457 12095468 Dhanusa NP 2 12095468 12095489 Mahottari NP 2 12095489 12095502 Parsa NP 2 12095502 12095512 Rautahat NP 2 12095512 12095518 Saptari NP 2 12095518 12095519 Sarlahi NP 2 12095519 12095522 Siraha NP 2 12095522 12095459 Bhaktapur NP 3 12095459 12095461 Chitwan NP 3 12095461 12095466 Dhading NP 3 12095466 12095469 Dolakha NP 3 12095469 12095484 Kathmandu NP 3 12095484 12095485 Kavrepalanchok NP 3 12095485 12095487 Lalitpur NP 3 12095487 12095490 Makwanpur NP 3 12095490 12095497 Nuwakot NP 3 12095497 12095504 Ramechhap NP 3 12095504 12095511 Rasuwa NP 3 12095511 12095520 Sindhuli NP 3 12095520 12095521 Sindhupalchowk NP 3 12095521 12095472 Gorkha NP 4 12095472 12095483 Kaski NP 4 12095483 12095488 Lamjung NP 4 12095488 12095491 Manag NP 4 12095491 12095494 Mustang NP 4 12095494 12095495 Myagdi NP 4 12095495 12095496 Nawalparasi NP 4 12095496 12095501 Parbat NP 4 12095501 12095507 Baglung NP 4 12095507 12095526 Syangja NP 4 12095526 12095527 Tanahun NP 4 12095527 12095456 Banke NP 5 12095456 12095458 Bardiya NP 5 12095458 12095464 Dang NP 5 12095464 12095473 Gulmi NP 5 12095473 12095482 Kapilbastu NP 5 12095482 12095499 Palpa NP 5 12095499 12095503 Pyuthan NP 5 12095503 12095506 Arghakhanchi NP 5 12095506 12095513 Rolpa NP 5 12095513 12095514 Rukum NP 5 12095514 12095515 Rupandehi NP 5 12095515 12095531 Nawalparasi NP 5 12095531 12095463 Dailekh NP 6 12095463 12095470 Dolpa NP 6 12095470 12095474 Humla NP 6 12095474 12095476 Jajarkot NP 6 12095476 12095478 Jumla NP 6 12095478 12095480 Kalikot NP 6 12095480 12095493 Mugu NP 6 12095493 12095516 Salyan NP 6 12095516 12095525 Surkhet NP 6 12095525 12095532 Rukum NP 6 12095532 12095462 Dadeldhura NP 7 12095462 12095465 Darchula NP 7 12095465 12095471 Doti NP 7 12095471 12095479 Kailali NP 7 12095479 12095481 Kanchanpur NP 7 12095481 12095505 Achham NP 7 12095505 12095508 Baitadi NP 7 12095508 12095509 Bajhang NP 7 12095509 12095510 Bajura NP 7 12095510 1716770 Cotabato City PH 12 B8 11395835 Capital District PH NCR 133900000 11395836 Eastern Manila District PH NCR 137400000 11395837 Northern Manila District PH NCR 137500000 11395838 Southern Manila District PH NCR 137600000 11995790 Pague ST 01 11995790