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

Surnames > Z > ZA > ZAT

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
ZA ZAA ZAB ZAC ZAD ZAE ZAF ZAG ZAH ZAI ZAJ ZAK ZAL ZAM ZAN ZAO ZAP ZAR ZAS ZAT ZAU ZAV ZAW ZAY ZAZ

Full Surname List Starting with ZAT(Alphabetical)

ZATAR
ZATARAIN
ZATEZALO
ZATKO
ZATOPEK
ZATOR
ZATORSKI
ZATS
ZATTA
ZATZ

Top 100 Surnames in the 2010 US Census starting with ZAT

SurnameCountRankWiki?
ZATARAIN 1162 22201 no
ZATORSKI 415 50362 no
ZATEZALO 234 80926 no
ZATZ 197 93125 no
ZATOPEK 179 100791 no
ZATAR 158 111426 no
ZATOR 149 116829 no
ZATKO 145 119508 no
ZATTA 108 151532 no
ZATS 103 157234 no