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 > ZIA

Surnames > Z > ZI > ZIA

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 ZIA(Alphabetical)

ZIA
ZIAD
ZIADEH
ZIADIE
ZIAJA
ZIARKO
ZIARNIK
ZIARNO
ZIAS
ZIATS
ZIAUDDIN

Top 100 Surnames in the 2010 US Census starting with ZIA

SurnameCountRankWiki?
ZIA 1495 18486 no
ZIADEH 349 58182 no
ZIARKO 247 77522 no
ZIAJA 204 90495 no
ZIARNIK 182 99378 no
ZIAS 173 103655 no
ZIAD 159 110825 no
ZIATS 127 133048 no
ZIAUDDIN 116 143149 no
ZIADIE 114 145220 no
ZIARNO 107 152628 no