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 > JOP

Surnames > J > JO > JOP

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 JOP(Alphabetical)

JOPEK
JOPLIN
JOPLING
JOPP
JOPPA
JOPPY
JOPSON

Top 100 Surnames in the 2010 US Census starting with JOP

SurnameCountRankWiki?
JOPLIN 2107 14233 no
JOPLING 390 53072 no
JOPP 343 59017 no
JOPEK 209 88685 no
JOPSON 176 102197 no
JOPPY 160 110286 no
JOPPA 158 111426 no