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

Surnames > N > NG > NGI

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
NG NGA NGE NGH NGI NGO NGU NGW NGY

Full Surname List Starting with NGI(Alphabetical)

NGIGI
NGIM
NGIN

Top 100 Surnames in the 2010 US Census starting with NGI

SurnameCountRankWiki?
NGIN 295 66931 no
NGIGI 125 134712 no
NGIM 123 136449 no