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

Surnames > Y > YR > YRI

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
YRA YRI YRL YRU

Full Surname List Starting with YRI(Alphabetical)

YRIARTE
YRIBE
YRIGOLLEN
YRIGOYEN

Top 100 Surnames in the 2010 US Census starting with YRI

SurnameCountRankWiki?
YRIGOYEN 323 62045 no
YRIGOLLEN 184 98553 no
YRIBE 132 129047 no
YRIARTE 115 144141 no