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 = 'ZO' order by rank asc limit 0,100 Surnames > Z > ZO > ZOB

Surnames > Z > ZO > ZOB

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
ZA ZB ZD ZE ZG ZH ZI ZL ZM ZN ZO ZR ZS ZU ZV ZW ZY
ZOB ZOC ZOD ZOE ZOF ZOG ZOH ZOI ZOK ZOL ZOM ZON ZOO ZOP ZOQ ZOR ZOS ZOT ZOU ZOV ZOZ

Full Surname List Starting with ZOB(Alphabetical)

ZOBECK
ZOBEL
ZOBELL
ZOBERMAN
ZOBRIST

Top 100 Surnames in the 2010 US Census starting with ZOB

SurnameCountRankWiki?
ZOBEL 1556 17958 no
ZOBRIST 830 28704 no
ZOBELL 286 68770 no
ZOBECK 119 140157 no
ZOBERMAN 108 151532 no