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

Surnames > J > JO > JOA

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
JO JOA JOB JOC JOD JOE JOF JOG JOH JOI JOJ JOK JOL JOM JON JOO JOP JOR JOS JOU JOV JOW JOY JOZ

Full Surname List Starting with JOA(Alphabetical)

JOA
JOACHIM
JOACHIN
JOAN
JOANIS
JOANN
JOANNIDES
JOANNOU
JOANS
JOAO
JOAQUIM
JOAQUIN
JOAS
JOASSAINT

Top 100 Surnames in the 2010 US Census starting with JOA

SurnameCountRankWiki?
JOAQUIN 3559 9172 no
JOACHIM 2395 12856 no
JOA 495 43584 no
JOACHIN 414 50467 no
JOANIS 407 51176 no
JOAQUIM 305 65066 no
JOAS 286 68770 no
JOAO 264 73464 no
JOAN 224 83834 no
JOANN 220 85049 no
JOANNIDES 168 106096 no
JOASSAINT 132 129047 no
JOANS 128 132206 no
JOANNOU 127 133048 no