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

Surnames > Z > ZI > ZID

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
ZI ZIA ZIB ZIC ZID ZIE ZIF ZIG ZIH ZII ZIK ZIL ZIM ZIN ZIO ZIP ZIR ZIS ZIT ZIU ZIV ZIY ZIZ

Full Surname List Starting with ZID(Alphabetical)

ZIDAN
ZIDAR
ZIDE
ZIDEK
ZIDEL
ZIDELL
ZIDOR

Top 100 Surnames in the 2010 US Census starting with ZID

SurnameCountRankWiki?
ZIDEK 531 41038 no
ZIDAN 285 68949 no
ZIDE 232 81458 no
ZIDAR 229 82317 no
ZIDELL 127 133048 no
ZIDOR 118 141140 no
ZIDEL 102 158432 no