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 = 'NY' order by rank asc limit 0,100 Surnames > N > NY > NYK

Surnames > N > NY > NYK

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
NA NC ND NE NG NH NI NJ NK NN NO NS NT NU NW NY NZ
NY NYA NYB NYC NYD NYE NYF NYG NYH NYI NYK NYL NYM NYO NYP NYQ NYR NYS NYT NYU NYZ

Full Surname List Starting with NYK(Alphabetical)

NYKAMP
NYKANEN
NYKAZA
NYKIEL

Top 100 Surnames in the 2010 US Census starting with NYK

SurnameCountRankWiki?
NYKAMP 432 48800 no
NYKIEL 361 56588 no
NYKAZA 290 67943 no
NYKANEN 161 109758 no