number of errors=108
number of warnings=0
country=US
select geonameid,countrycode,admincode1,admincode2,ansiname from geoname where featurecode = 'ADM2' and admincode1 is not null and admincode1 <>'00' and admincode2 is not null and countrycode || admincode1 || admincode2 not in (select countrycode || admincode1 || admincode2 from geoname where featurecode in ('PPLC','PPLA','PPLA2') and countrycode is not null and admincode1 is not null and admincode1 <>'00' and admincode2 is not null) and countrycode='US' order by countrycode,admincode1,admincode2
geonameid countrycode admincode1 admincode2 ansiname 5879164 US AK 016 Aleutians West Census Area 5880573 US AK 050 Bethel Census Area 5858042 US AK 060 Bristol Bay Borough 12261502 US AK 063 Chugach Census Area 12261501 US AK 066 Copper River Census Area 5860541 US AK 068 Denali Borough 5860696 US AK 070 Dillingham Census Area 5846893 US AK 100 Haines Borough 7117568 US AK 105 Hoonah-Angoon Census Area 5866071 US AK 122 Kenai Peninsula Borough 11550056 US AK 158 Kusilvak Census Area 5867113 US AK 164 Lake and Peninsula Borough 5870134 US AK 180 Nome Census Area 7117732 US AK 195 Petersburg Borough 11550055 US AK 198 Prince of Wales-Hyder Census Area 7117565 US AK 230 Skagway Municipality 5874863 US AK 240 Southeast Fairbanks Census Area 7117591 US AK 275 City and Borough of Wrangell 5558618 US AK 282 Yakutat City and Borough 5878558 US AK 290 Yukon-Koyukuk Census Area 4087481 US AL 115 St. Clair County 4099679 US AR 001 Arkansas County 4104658 US AR 015 Carroll County 4105899 US AR 021 Clay County 4106979 US AR 031 Craighead County 4111593 US AR 047 Franklin County 4119581 US AR 083 Logan County 4121839 US AR 093 Mississippi County 4127330 US AR 117 Prairie County 4130449 US AR 131 Sebastian County 4137268 US AR 149 Yell County 5323414 US CA 003 Alpine County 5359604 US CA 027 Inyo County 5422448 US CO 043 Fremont County 12809018 US CT 120 Greater Bridgeport Planning Region 12809022 US CT 130 Lower Connecticut River Valley Planning Region 12809019 US CT 140 Naugatuck Valley Planning Region 12809025 US CT 150 Northeastern Connecticut Planning Region 12809026 US CT 160 Northwest Hills Planning Region 12809023 US CT 170 South Central Connecticut Planning Region 12809024 US CT 180 Southeastern Connecticut Planning Region 12809020 US CT 190 Western Connecticut Planning Region 4190530 US GA 083 Dade County 4208544 US GA 191 McIntosh County 4227166 US GA 285 Troup County 4229782 US GA 305 Wayne County 5847795 US HI 005 Kalawao County 4864395 US IA 111 Lee County 5597922 US ID 055 Kootenai County 4259679 US IN 079 Jennings County 4922460 US IN 091 LaPorte County 5445855 US KS 109 Logan County 5446561 US KS 187 Stanton County 4296902 US KY 117 Kenton County 4337452 US LA 075 Plaquemines Parish 4930396 US MA 003 Berkshire County 4935951 US MA 009 Essex County 4937280 US MA 011 Franklin County 4938741 US MA 013 Hampden County 4938757 US MA 015 Hampshire County 4943909 US MA 017 Middlesex County 4947607 US MA 023 Plymouth County 4975418 US ME 021 Piscataquis County 4392183 US MO 095 Jackson County 4407295 US MO 186 Sainte Genevieve County 4419012 US MS 011 Bolivar County 4421449 US MS 017 Chickasaw County 4429197 US MS 047 Harrison County 4431565 US MS 061 Jasper County 4431982 US MS 067 Jones County 4440232 US MS 107 Panola County 4447911 US MS 135 Tallahatchie County 4451779 US MS 161 Yalobusha County 4469393 US NC 081 Guilford County 4499127 US NC 193 Wilkes County 5060009 US ND 045 LaMoure County 5087463 US NH 011 Hillsborough County 5199309 US PA 079 Luzerne County 5201707 US PA 089 Monroe County 5221078 US RI 001 Bristol County 5222961 US RI 003 Kent County 5223601 US RI 005 Newport County 5225535 US RI 009 Washington County 5226588 US SD 017 Buffalo County 5768976 US SD 102 Oglala Lakota County 5769778 US SD 121 Todd County 4613750 US TN 025 Claiborne County 5525131 US TX 295 Lipscomb County 5784339 US UT 051 Wasatch County 5549225 US UT 053 Washington County 4744031 US VA 003 Albemarle County 4744139 US VA 005 Alleghany County 4745015 US VA 015 Augusta County 4758041 US VA 059 Fairfax County 4760052 US VA 069 Frederick County 4761164 US VA 073 Gloucester County 4762246 US VA 081 Greensville County 4763688 US VA 087 Henrico County 4763710 US VA 089 Henry County 4766447 US VA 095 James City County 4776629 US VA 135 Nottoway County 4780384 US VA 153 Prince William County 4782181 US VA 161 Roanoke County 4782531 US VA 163 Rockbridge County 4782579 US VA 165 Rockingham County 5233748 US VT 003 Bennington County 5251040 US WI 033 Dunn County 5840786 US WY 039 Teton County