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

Surnames > N > NY > NYS

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

NYS
NYSETH
NYSSE
NYSSEN
NYSTEDT
NYSTRAND
NYSTROM
NYSTUEN

Top 100 Surnames in the 2010 US Census starting with NYS

SurnameCountRankWiki?
NYSTROM 4122 8030 no
NYS 281 69793 no
NYSTEDT 203 90853 no
NYSTUEN 198 92719 no
NYSETH 184 98553 no
NYSSEN 140 123064 no
NYSTRAND 124 135593 no
NYSSE 103 157234 no