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 = 'YS' order by rank asc limit 0,100 Surnames > Y > YS > YSA

Surnames > Y > YS > YSA

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
YA YB YC YD YE YG YH YI YL YM YN YO YP YR YS YT YU YV YZ
YSA YSL YSQ

Full Surname List Starting with YSA(Alphabetical)

YSAGUIRRE
YSAIS
YSASAGA
YSASI
YSASSI

Top 100 Surnames in the 2010 US Census starting with YSA

SurnameCountRankWiki?
YSAGUIRRE 452 47006 no
YSASI 274 71265 no
YSAIS 257 75069 no
YSASSI 146 118853 no
YSASAGA 129 131379 no