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 = 'KO' order by rank asc limit 0,100 Surnames > K > KO > KOJ

Surnames > K > KO > KOJ

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
KA KE KF KH KI KJ KL KM KN KO KP KR KS KU KV KW KY
KO KOA KOB KOC KOD KOE KOF KOG KOH KOI KOJ KOK KOL KOM KON KOO KOP KOR KOS KOT KOU KOV KOW KOX KOY KOZ

Full Surname List Starting with KOJ(Alphabetical)

KOJA
KOJETIN
KOJI
KOJIC
KOJIMA
KOJIS
KOJO

Top 100 Surnames in the 2010 US Census starting with KOJ

SurnameCountRankWiki?
KOJIMA 950 25889 no
KOJIS 174 103181 no
KOJA 164 108199 no
KOJIC 146 118853 no
KOJO 123 136449 no
KOJETIN 114 145220 no
KOJI 109 150452 no