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

Surnames > K > KI > KIY

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
KI KIA KIB KIC KID KIE KIF KIG KIH KIJ KIK KIL KIM KIN KIO KIP KIR KIS KIT KIV KIW KIX KIY KIZ

Full Surname List Starting with KIY(Alphabetical)

KIYABU
KIYAN
KIYOHARA
KIYONAGA
KIYONO
KIYOTA
KIYUNA

Top 100 Surnames in the 2010 US Census starting with KIY

SurnameCountRankWiki?
KIYABU 342 59171 no
KIYOTA 197 93125 no
KIYAN 146 118853 no
KIYUNA 144 120187 no
KIYOHARA 131 129825 no
KIYONAGA 107 152628 no
KIYONO 100 160975 no