select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'IP' order by rank asc limit 0,100 Surnames > I > IP > IPA

Surnames > I > IP > IPA

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV IW IX IY IZ
IP IPA IPE IPI IPO IPP IPS

Full Surname List Starting with IPA(Alphabetical)

IPARRAGUIRRE
IPATZI

Top 100 Surnames in the 2010 US Census starting with IPA

SurnameCountRankWiki?
IPARRAGUIRRE 236 80419 no
IPATZI 104 156044 no