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 = 'PU' order by rank asc limit 0,100 Surnames > P > PU > PUB

Surnames > P > PU > PUB

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
PA PE PF PH PI PJ PL PN PO PP PR PS PT PU PY
PU PUA PUB PUC PUD PUE PUF PUG PUH PUI PUJ PUK PUL PUM PUN PUO PUP PUR PUS PUT PUU PUV PUY PUZ

Full Surname List Starting with PUB(Alphabetical)

PUBILL
PUBLIC
PUBLICO
PUBLICOVER
PUBLOW

Top 100 Surnames in the 2010 US Census starting with PUB

SurnameCountRankWiki?
PUBLIC 310 64200 no
PUBLICOVER 252 76275 no
PUBLICO 147 118185 no
PUBILL 103 157234 no
PUBLOW 101 159712 no