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 = 'AI' order by rank asc limit 0,100 Surnames > A > AI > AID

Surnames > A > AI > AID

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
AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ
AI AIC AID AIE AIG AIH AIJ AIK AIL AIM AIN AIO AIP AIR AIS AIT AIU AIV AIW AIY AIZ

Full Surname List Starting with AID(Alphabetical)

AID
AIDA
AIDALA
AIDE
AIDEN
AIDOO

Top 100 Surnames in the 2010 US Census starting with AID

SurnameCountRankWiki?
AIDOO 382 54055 no
AIDE 308 64559 no
AIDALA 143 120901 no
AIDA 140 123064 no
AID 123 136449 no
AIDEN 105 154907 no