There are 32 Apple counties not found in counties2/
Out[83]:
{'AguadillaMunicipio_PuertoRico_US_v2.csv',
'AnchorageMunicipality_Alaska_US_v2.csv',
'AreciboMunicipio_PuertoRico_US_v2.csv',
'BayamónMunicipio_PuertoRico_US_v2.csv',
'BoxElder_Utah_US_v2.csv',
'CaguasMunicipio_PuertoRico_US_v2.csv',
'CarolinaMunicipio_PuertoRico_US_v2.csv',
'Carson_Nevada_US_v2.csv',
'DoradoMunicipio_PuertoRico_US_v2.csv',
'DoñaAna_NewMexico_US_v2.csv',
'Dukes_Massachusetts_US_v2.csv',
'FairbanksNorthStarBorough_Alaska_US_v2.csv',
'Guam_Guam_US_v2.csv',
'GuaynaboMunicipio_PuertoRico_US_v2.csv',
'GuraboMunicipio_PuertoRico_US_v2.csv',
'HumacaoMunicipio_PuertoRico_US_v2.csv',
'James_Virginia_US_v2.csv',
'Juab_Utah_US_v2.csv',
'JuneauandBorough_Alaska_US_v2.csv',
'KenaiPeninsulaBorough_Alaska_US_v2.csv',
'Matanuska-SusitnaBorough_Alaska_US_v2.csv',
'MayagüezMunicipio_PuertoRico_US_v2.csv',
'Millard_Utah_US_v2.csv',
'PonceMunicipio_PuertoRico_US_v2.csv',
'RíoGrandeMunicipio_PuertoRico_US_v2.csv',
'SanJuanMunicipio_PuertoRico_US_v2.csv',
'Sevier_Utah_US_v2.csv',
'St.CroixIsland_VirginIslands_US_v2.csv',
'St.ThomasIsland_VirginIslands_US_v2.csv',
'ToaBajaMunicipio_PuertoRico_US_v2.csv',
'TrujilloAltoMunicipio_PuertoRico_US_v2.csv',
'Weber_Utah_US_v2.csv'}Sevier Utah is an unincoporated community.
After remove some "and", "City", "Municipio", "Borough", there are 18 left.
There are 15 Apple counties not found in counties2/Out[13]:{'Bayamón_PuertoRico_US_v2.csv', 'BoxElder_Utah_US_v2.csv', 'Carson_Nevada_US_v2.csv', 'DoñaAna_NewMexico_US_v2.csv', 'Dukes_Massachusetts_US_v2.csv', 'Guam_Guam_US_v2.csv', 'James_Virginia_US_v2.csv', 'Juab_Utah_US_v2.csv', 'Mayagüez_PuertoRico_US_v2.csv', 'Millard_Utah_US_v2.csv', 'RíoGrande_PuertoRico_US_v2.csv', 'Sevier_Utah_US_v2.csv', 'St.CroixIsland_VirginIslands_US_v2.csv', 'St.ThomasIsland_VirginIslands_US_v2.csv', 'Weber_Utah_US_v2.csv'}
Dukes_Massachusetts_US_v2.csv is in Apple.In JHU, this seems to be DukesandNantucket_Massachusetts_US_v2.csv
