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

Surnames > N > NY > NYB

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

NYBAKKEN
NYBECK
NYBERG
NYBLOM
NYBO
NYBOER
NYBORG
NYBURG
NYBY

Top 100 Surnames in the 2010 US Census starting with NYB

SurnameCountRankWiki?
NYBERG 3732 8787 no
NYBORG 506 42790 no
NYBO 386 53538 no
NYBOER 198 92719 no
NYBLOM 162 109258 no
NYBECK 152 115034 no
NYBAKKEN 121 138304 no
NYBURG 100 160975 no
NYBY 100 160975 no