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 = 'JA' order by rank asc limit 0,100 Surnames > J > JA > JAJ

Surnames > J > JA > JAJ

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
JA JB JE JH JI JN JO JU JY
JA JAA JAB JAC JAD JAE JAF JAG JAH JAI JAJ JAK JAL JAM JAN JAO JAP JAQ JAR JAS JAT JAU JAV JAW JAX JAY JAZ

Full Surname List Starting with JAJ(Alphabetical)

JAJE
JAJKO
JAJO
JAJOO
JAJOU

Top 100 Surnames in the 2010 US Census starting with JAJ

SurnameCountRankWiki?
JAJO 337 59901 no
JAJOU 211 88020 no
JAJE 179 100791 no
JAJKO 156 112568 no
JAJOO 117 142108 no