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 = 'UB' order by rank asc limit 0,100 Surnames > U > UB > UBA

Surnames > U > UB > UBA

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
UB UC UD UE UF UG UH UI UJ UK UL UM UN UO UP UQ UR US UT UV UW UY UZ
UBA UBB UBE UBI UBL UBR UBU

Full Surname List Starting with UBA(Alphabetical)

UBA
UBALDI
UBALDO
UBALLE
UBANDO
UBANI

Top 100 Surnames in the 2010 US Census starting with UBA

SurnameCountRankWiki?
UBALDO 957 25751 no
UBALLE 500 43206 no
UBA 292 67519 no
UBANDO 185 98099 no
UBANI 143 120901 no
UBALDI 103 157234 no