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

Surnames > Y > YB > YBA

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
YBA

Full Surname List Starting with YBA(Alphabetical)

YBANEZ
YBARBO
YBARRA

Top 100 Surnames in the 2010 US Census starting with YBA

SurnameCountRankWiki?
YBARRA 22211 1619 no
YBANEZ 1709 16734 no
YBARBO 687 33280 no