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 = 'YA' order by rank asc limit 0,100 Surnames > Y > YA > YAT

Surnames > Y > YA > YAT

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
YA YB YC YD YE YG YH YI YL YM YN YO YP YR YS YT YU YV YZ
YA YAA YAB YAC YAD YAE YAF YAG YAH YAI YAJ YAK YAL YAM YAN YAO YAP YAQ YAR YAS YAT YAU YAV YAW YAX YAY YAZ

Full Surname List Starting with YAT(Alphabetical)

YAT
YATA
YATACO
YATCO
YATER
YATES
YATH
YATOOMA
YATSENKO
YATSKO
YATTAW
YATTEAU

Top 100 Surnames in the 2010 US Census starting with YAT

SurnameCountRankWiki?
YATES 63254 535 no
YATSKO 691 33121 no
YATER 351 57914 no
YAT 245 78040 no
YATTAW 194 94311 no
YATOOMA 190 95955 no
YATH 149 116829 no
YATCO 143 120901 no
YATA 131 129825 no
YATACO 128 132206 no
YATSENKO 113 146201 no
YATTEAU 100 160975 no