number of errors=662
number of warnings=0
select count(*),countrycode,admincode1,admincode2,admincode3 from geoname where featurecode = 'PPLA3' and admincode3 is not null group by 2,3,4,5 having count(*)>1 order by 2,3,4,5
count countrycode admincode1 admincode2 admincode3 2 AL 40 10944368 12501074 2 AL 42 10944377 3185219 2 AL 42 10944378 3185639 2 AL 43 10944384 781976 2 AL 44 10944388 3183626 2 AL 44 10944388 3185816 2 AL 44 10944390 3186197 2 AL 44 10944392 3185032 2 AL 45 10944394 12501100 3 AL 45 10944395 781482 2 AL 46 10944402 783301 2 AL 46 10944403 782038 2 AL 48 10944409 3184703 3 AL 48 10944411 782132 2 AL 49 10944413 3186162 2 AL 49 10944413 3315390 3 AL 49 10944414 3184375 2 AL 49 10944415 3185432 2 AL 50 10944418 12501070 2 AL 50 10944420 3183654 2 AL 50 10944420 3183659 2 AT 02 205 20515 2 AT 02 205 20519 2 AT 02 207 20711 3 AT 02 207 20727 2 AT 02 210 21002 2 AT 02 210 21003 3 AT 02 210 21005 2 AT 03 320 32015 2 AT 03 323 32317 5 AT 04 411 41124 2 AT 05 503 50306 6 AT 06 603 60344 5 AT 06 603 60345 2 AT 06 603 60346 3 AT 06 603 60348 4 AT 06 603 60349 3 AT 06 603 60350 2 AT 06 603 60351 2 AT 06 606 60662 3 AT 06 606 60663 2 AT 06 606 60664 2 AT 06 606 60665 3 AT 06 606 60666 2 AT 06 606 60667 2 AT 06 606 60668 2 AT 06 606 60669 2 AT 06 606 60670 3 AT 06 610 61049 2 AT 06 610 61050 2 AT 06 610 61051 2 AT 06 610 61052 3 AT 06 610 61053 3 AT 06 610 61056 5 AT 06 610 61057 3 AT 06 610 61058 3 AT 06 612 61217 4 AT 06 612 61253 2 AT 06 612 61257 4 AT 06 612 61258 2 AT 06 612 61259 2 AT 06 612 61260 2 AT 06 612 61262 2 AT 06 612 61263 3 AT 06 612 61266 3 AT 06 614 61437 2 AT 06 614 61438 7 AT 06 614 61439 2 AT 06 614 61440 2 AT 06 614 61442 2 AT 06 614 61443 2 AT 06 614 61444 2 AT 06 616 61627 2 AT 06 616 61628 3 AT 06 616 61630 2 AT 06 616 61632 2 AT 06 617 61741 2 AT 06 617 61743 2 AT 06 617 61756 2 AT 06 617 61759 4 AT 06 617 61760 3 AT 06 617 61763 2 AT 06 617 61765 2 AT 06 617 61766 2 AT 06 620 62039 3 AT 06 620 62040 2 AT 06 620 62041 2 AT 06 620 62043 3 AT 06 620 62044 2 AT 06 620 62045 3 AT 06 620 62046 2 AT 06 620 62047 2 AT 06 620 62048 2 AT 06 621 62139 2 AT 06 621 62140 3 AT 06 621 62141 2 AT 06 621 62143 3 AT 06 621 62144 2 AT 06 621 62145 2 AT 06 621 62146 2 AT 06 621 62147 2 AT 06 622 62264 5 AT 06 622 62266 3 AT 06 622 62267 2 AT 06 622 62268 2 AT 06 622 62271 2 AT 06 622 62272 2 AT 06 622 62273 2 AT 06 622 62277 2 AT 06 622 62278 4 AT 06 623 62375 2 AT 06 623 62377 3 AT 06 623 62378 6 AT 06 623 62379 9 AT 06 623 62380 2 AT 06 623 62381 5 AT 06 623 62382 3 AT 06 623 62383 2 AT 06 623 62384 3 AT 06 623 62385 3 AT 06 623 62386 3 AT 06 623 62388 2 AT 06 623 62389 4 AT 06 623 62390 2 BE WAL WHT 54 3 CH GR 1847 3837 2 CH VD 2227 5656 2 DE 06 00 03159 2 DE 13 00 14628 2 EC 08 0710 071050 2 EC 12 1107 110751 2 EC 14 1301 130150 2 EC 18 1701 170150 2 EC 26 2301 230155 2 ES 07 PM 07026 2 ES 07 PM 07046 2 ES 51 AL 04031 2 ES 51 CA 11019 3 ES 51 GR 18105 2 ES 51 GR 18158 2 ES 55 P 34010 2 ES 58 OR 32026 2 FI 01 011 444 2 FI 01 011 753 2 FI 01 016 434 3 FI 02 021 322 4 FI 02 021 445 10 FI 02 022 734 2 FI 02 023 202 3 FI 02 023 481 2 FI 02 023 503 4 FI 02 023 529 2 FI 02 023 704 2 FI 02 024 918 3 FI 02 025 430 3 FI 02 025 636 2 FI 04 041 050 2 FI 04 041 684 2 FI 04 043 102 2 FI 04 044 230 4 FI 05 051 109 2 FI 05 051 165 2 FI 05 052 086 2 FI 06 068 790 2 FI 06 069 508 2 FI 07 071 098 2 FI 07 071 316 2 FI 07 071 560 2 FI 09 091 441 2 FI 10 103 740 2 FI 13 134 182 2 FI 13 138 256 2 FI 13 138 729 4 FI 14 142 233 2 FI 14 142 301 2 FI 15 154 599 2 FI 16 162 272 2 FI 17 174 748 2 FI 17 175 791 2 FR 44 57 573 2 FR 44 57 575 2 FR 44 67 672 2 FR 44 68 686 2 FR 52 44 445 8 GF GF 973 9731 2 GF GF 973 9732 2 GR ESYE13 11 9069 2 GR ESYE25 40 9255 2 GR ESYE31 99 9173 2 GR ESYE31 99 9176 2 IT 01 AQ 066007 2 IT 01 TE 067023 5 IT 03 CS 078156 2 IT 03 CS 078157 2 IT 03 RC 080014 2 IT 03 RC 080034 2 IT 04 AV 064018 2 IT 04 AV 064099 2 IT 04 AV 064116 2 IT 04 AV 064121 2 IT 04 CE 061010 2 IT 04 CE 061026 2 IT 04 CE 061038 2 IT 04 CE 061039 2 IT 04 CE 061040 2 IT 04 NA 063003 2 IT 04 NA 063039 2 IT 04 NA 063054 2 IT 04 SA 065033 2 IT 04 SA 065053 2 IT 04 SA 065056 2 IT 04 SA 065072 2 IT 04 SA 065082 2 IT 04 SA 065110 2 IT 05 BO 037019 2 IT 05 BO 037031 4 IT 05 BO 037061 2 IT 05 BO 037062 2 IT 05 FC 040005 2 IT 05 FC 040031 2 IT 05 FC 040037 2 IT 05 FE 038027 2 IT 05 FE 038028 2 IT 05 FE 038029 2 IT 05 FE 038030 2 IT 05 MO 036033 2 IT 05 PC 033004 3 IT 05 PC 033049 2 IT 05 PR 034049 2 IT 05 PR 034050 3 IT 05 PR 034051 2 IT 05 RE 035022 4 IT 05 RE 035046 2 IT 05 RN 099028 2 IT 05 RN 099029 2 IT 06 PN 093004 2 IT 06 PN 093034 2 IT 06 PN 093053 2 IT 06 TS 032001 2 IT 06 UD 030008 2 IT 06 UD 030009 2 IT 06 UD 030013 2 IT 06 UD 030028 2 IT 06 UD 030041 2 IT 06 UD 030059 2 IT 06 UD 030061 2 IT 06 UD 030102 2 IT 06 UD 030118 2 IT 06 UD 030127 2 IT 06 UD 030138 2 IT 06 UD 030188 2 IT 06 UD 030190 2 IT 06 UD 030191 2 IT 07 FR 060021 2 IT 07 LT 059031 2 IT 07 RM 058047 2 IT 08 GE 010014 2 IT 08 GE 010029 2 IT 08 GE 010034 2 IT 08 GE 010058 2 IT 08 GE 010061 2 IT 08 GE 010063 2 IT 08 IM 008047 2 IT 08 IM 008068 2 IT 08 SP 011003 2 IT 08 SV 009006 2 IT 08 SV 009007 2 IT 08 SV 009023 2 IT 08 SV 009030 2 IT 08 SV 009031 2 IT 08 SV 009040 2 IT 08 SV 009044 2 IT 08 SV 009048 2 IT 08 SV 009054 2 IT 08 SV 009058 2 IT 08 SV 009059 2 IT 08 SV 009063 2 IT 08 SV 009064 2 IT 09 BG 016055 2 IT 09 BG 016062 2 IT 09 BG 016068 2 IT 09 BG 016104 2 IT 09 BG 016116 2 IT 09 BG 016127 2 IT 09 BG 016137 2 IT 09 BG 016148 2 IT 09 BG 016186 2 IT 09 BG 016191 2 IT 09 BG 016203 2 IT 09 BG 016217 2 IT 09 BG 016221 2 IT 09 BG 016243 2 IT 09 BG 016252 2 IT 09 BG 016253 2 IT 09 BS 017014 2 IT 09 BS 017030 2 IT 09 BS 017060 2 IT 09 BS 017062 2 IT 09 BS 017065 2 IT 09 BS 017081 2 IT 09 BS 017082 2 IT 09 BS 017090 2 IT 09 BS 017096 2 IT 09 BS 017102 2 IT 09 BS 017105 2 IT 09 BS 017112 2 IT 09 BS 017116 2 IT 09 BS 017141 2 IT 09 BS 017153 2 IT 09 BS 017156 2 IT 09 BS 017157 2 IT 09 BS 017158 2 IT 09 BS 017160 2 IT 09 BS 017163 2 IT 09 BS 017164 2 IT 09 BS 017193 2 IT 09 CO 013003 2 IT 09 CO 013022 2 IT 09 CO 013071 2 IT 09 CO 013083 2 IT 09 CO 013098 2 IT 09 CO 013099 2 IT 09 CO 013111 2 IT 09 CO 013154 2 IT 09 CO 013183 2 IT 09 CO 013211 2 IT 09 CO 013226 2 IT 09 CO 013229 5 IT 09 CO 013252 3 IT 09 CO 013253 3 IT 09 CO 013254 2 IT 09 CO 013255 2 IT 09 CO 013256 2 IT 09 CR 019013 2 IT 09 CR 019032 2 IT 09 CR 019046 2 IT 09 CR 019048 2 IT 09 CR 019077 2 IT 09 CR 019095 2 IT 09 CR 019107 2 IT 09 CR 019116 2 IT 09 LC 097008 2 IT 09 LC 097019 2 IT 09 LC 097024 2 IT 09 LC 097037 2 IT 09 LC 097054 2 IT 09 LC 097058 2 IT 09 LC 097091 2 IT 09 LC 097092 3 IT 09 LC 097093 2 IT 09 LO 098015 2 IT 09 LO 098057 2 IT 09 LO 098062 2 IT 09 MI 015036 2 IT 09 MI 015042 2 IT 09 MI 015077 2 IT 09 MI 015251 2 IT 09 MN 020057 2 IT 09 MN 020061 2 IT 09 MN 020071 3 IT 09 MN 020072 2 IT 09 MN 020073 2 IT 09 PV 018029 2 IT 09 PV 018038 2 IT 09 PV 018046 2 IT 09 PV 018057 2 IT 09 PV 018077 2 IT 09 PV 018101 2 IT 09 PV 018191 2 IT 09 PV 018192 4 IT 09 PV 018193 2 IT 09 SO 014015 2 IT 09 SO 014024 2 IT 09 SO 014029 3 IT 09 SO 014032 2 IT 09 SO 014050 2 IT 09 SO 014054 2 IT 09 SO 014057 2 IT 09 SO 014072 2 IT 09 SO 014073 2 IT 09 SO 014074 2 IT 09 SO 014077 2 IT 09 VA 012016 2 IT 09 VA 012020 2 IT 09 VA 012045 2 IT 09 VA 012131 3 IT 09 VA 012142 2 IT 09 VA 012143 3 IT 09 VA 012144 2 IT 10 AN 042050 2 IT 10 AP 044011 2 IT 10 MC 043017 2 IT 10 MC 043058 2 IT 10 PU 041068 3 IT 10 PU 041069 4 IT 10 PU 041070 2 IT 10 PU 041071 2 IT 11 IS 094042 2 IT 12 AL 006153 2 IT 12 AL 006191 2 IT 12 AL 006192 2 IT 12 AL 006193 2 IT 12 AT 005001 2 IT 12 AT 005016 2 IT 12 AT 005058 2 IT 12 AT 005059 2 IT 12 AT 005122 2 IT 12 BI 096035 3 IT 12 BI 096042 2 IT 12 BI 096072 2 IT 12 BI 096075 2 IT 12 BI 096087 6 IT 12 BI 096088 2 IT 12 CN 004034 2 IT 12 CN 004126 2 IT 12 CN 004130 2 IT 12 CN 004142 2 IT 12 CN 004148 2 IT 12 CN 004151 2 IT 12 CN 004187 2 IT 12 CN 004189 2 IT 12 CN 004203 2 IT 12 CN 004212 2 IT 12 CN 004213 2 IT 12 CN 004223 2 IT 12 NO 003001 2 IT 12 NO 003082 2 IT 12 NO 003166 2 IT 12 TO 001069 2 IT 12 TO 001088 2 IT 12 TO 001122 2 IT 12 TO 001154 2 IT 12 TO 001252 2 IT 12 TO 001279 2 IT 12 TO 001284 2 IT 12 TO 001294 2 IT 12 TO 001305 3 IT 12 TO 001317 3 IT 12 TO 001318 2 IT 12 VB 103001 2 IT 12 VB 103013 2 IT 12 VB 103039 2 IT 12 VB 103049 2 IT 12 VB 103061 2 IT 12 VB 103078 3 IT 12 VB 103079 2 IT 12 VC 002002 2 IT 12 VC 002116 2 IT 12 VC 002156 2 IT 12 VC 002170 2 IT 12 VC 002171 2 IT 13 LE 075098 2 IT 14 SS 090079 2 IT 14 SU 111011 2 IT 15 CT 087057 2 IT 15 ME 083023 2 IT 15 ME 083055 2 IT 15 ME 083094 2 IT 16 AR 051010 2 IT 16 AR 051016 2 IT 16 AR 051022 2 IT 16 AR 051023 2 IT 16 AR 051040 2 IT 16 AR 051041 2 IT 16 AR 051042 2 IT 16 FI 048014 2 IT 16 FI 048052 2 IT 16 FI 048053 2 IT 16 FI 048054 2 IT 16 GR 053012 2 IT 16 GR 053016 2 IT 16 LI 049021 2 IT 16 LU 046027 2 IT 16 LU 046037 2 IT 16 MS 045011 2 IT 16 MS 045013 2 IT 16 MS 045015 2 IT 16 MS 045017 2 IT 16 PI 050040 2 IT 16 PI 050041 2 IT 16 PO 100003 2 IT 16 PO 100007 2 IT 16 PT 047006 2 IT 16 PT 047021 2 IT 16 PT 047023 2 IT 16 PT 047024 2 IT 16 SI 052019 2 IT 16 SI 052037 2 IT 17 BZ 021007 2 IT 17 BZ 021014 2 IT 17 BZ 021018 2 IT 17 BZ 021023 2 IT 17 BZ 021033 2 IT 17 BZ 021049 2 IT 17 BZ 021057 2 IT 17 BZ 021070 3 IT 17 BZ 021075 2 IT 17 BZ 021087 2 IT 17 BZ 021091 2 IT 17 BZ 021104 2 IT 17 BZ 021108 2 IT 17 BZ 021109 2 IT 17 BZ 021112 2 IT 17 BZ 021114 2 IT 17 BZ 021115 2 IT 17 BZ 021117 2 IT 17 BZ 021118 2 IT 17 TN 022026 2 IT 17 TN 022058 2 IT 17 TN 022092 2 IT 17 TN 022108 2 IT 17 TN 022124 2 IT 17 TN 022167 2 IT 17 TN 022168 2 IT 17 TN 022193 2 IT 17 TN 022203 2 IT 17 TN 022213 5 IT 17 TN 022230 2 IT 17 TN 022231 3 IT 17 TN 022232 3 IT 17 TN 022233 3 IT 17 TN 022234 4 IT 17 TN 022235 4 IT 17 TN 022236 2 IT 17 TN 022237 3 IT 17 TN 022238 2 IT 17 TN 022239 3 IT 17 TN 022240 2 IT 17 TN 022241 3 IT 17 TN 022242 2 IT 17 TN 022243 4 IT 17 TN 022245 4 IT 17 TN 022246 3 IT 17 TN 022247 3 IT 17 TN 022248 3 IT 17 TN 022249 2 IT 17 TN 022250 2 IT 17 TN 022251 3 IT 17 TN 022252 4 IT 17 TN 022253 2 IT 17 TN 022254 2 IT 19 AO 007007 2 IT 19 AO 007011 2 IT 19 AO 007013 2 IT 19 AO 007014 2 IT 19 AO 007027 2 IT 19 AO 007035 2 IT 19 AO 007037 2 IT 19 AO 007043 2 IT 19 AO 007051 2 IT 19 AO 007058 2 IT 19 AO 007064 2 IT 19 AO 007066 2 IT 19 AO 007067 2 IT 19 AO 007071 2 IT 20 BL 025019 2 IT 20 BL 025025 2 IT 20 BL 025040 2 IT 20 BL 025058 2 IT 20 BL 025062 2 IT 20 BL 025067 2 IT 20 BL 025069 3 IT 20 BL 025072 2 IT 20 BL 025073 3 IT 20 BL 025074 4 IT 20 BL 025075 2 IT 20 PD 028106 4 IT 20 PD 028107 3 IT 20 PD 028108 2 IT 20 RO 029027 2 IT 20 RO 029034 2 IT 20 RO 029039 2 IT 20 TV 026014 2 IT 20 TV 026025 2 IT 20 TV 026026 2 IT 20 TV 026034 2 IT 20 TV 026044 2 IT 20 TV 026070 2 IT 20 TV 026076 2 IT 20 TV 026085 3 IT 20 TV 026096 2 IT 20 VE 027003 2 IT 20 VE 027014 2 IT 20 VE 027018 2 IT 20 VE 027030 2 IT 20 VI 024076 2 IT 20 VI 024115 3 IT 20 VI 024123 2 IT 20 VI 024124 4 IT 20 VI 024125 2 IT 20 VI 024126 2 IT 20 VI 024127 2 IT 20 VI 024128 2 IT 20 VR 023013 2 IT 20 VR 023014 2 IT 20 VR 023025 2 IT 20 VR 023042 2 IT 20 VR 023079 2 KR 14 37010 37011 3 KR 14 37010 37012 2 PA 01 0103 010303 2 PA 02 0413 041303 2 PA 03 0202 020209 2 PA 04 0301 030106 2 PA 06 0602 060206 2 PA 06 0604 060401 2 PA 12 1203 120302 3 PA 12 1206 120607 2 PA 13 1307 130716 2 PA 13 1309 130909 2 PE 02 0201 020102 2 PE 02 0201 020109 2 PE 02 0212 021209 2 PE 02 0215 021507 2 PE 02 0216 021601 2 PE 02 0219 021902 2 PE 02 0219 021909 2 PE 04 0401 040104 2 PE 04 0401 040105 2 PE 04 0401 040129 2 PE 06 0606 060610 2 PE 09 0901 090102 2 PE 09 0901 090107 2 PE 09 0901 090108 2 PE 09 0901 090115 2 PE 09 0902 090204 2 PE 09 0902 090208 2 PE 09 0904 090402 2 PE 09 0905 090502 2 PE 09 0905 090507 2 PE 12 1201 120133 2 PE 21 2101 210112 2 PE 23 2302 230203 2 PE 25 2503 250301 2 PH 01 29 012934000 2 PH 03 13 031401000 2 PH 03 13 031405000 2 PH 03 50 035417000 2 PH 03 63 036901000 2 PH 03 63 036913000 2 PH 03 64 037107000 2 PH 05 05 050508000 2 PH 05 58 056216000 2 PH 06 J3 067901000 2 PH 07 11 071210000 2 PH 08 37 083748000 2 PH 08 59 086414000 2 PH 11 25 112401000 2 PH 11 25 112404000 3 PH 11 I6 118209000 3 PH 11 I7 112317000 2 PH 12 71 126511000 2 PH 13 02 160204000 2 PH 14 35 153604000 2 PH 14 35 153624000 2 PH 14 35 153633000 2 PH 14 56 153808000 2 PH 40 33 043406000 2 PL 73 0402 040207 2 PL 74 1010 101008 2 PL 85 2813 281304 2 PT 16 1214 121412