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

Surnames > J > JO > JOZ

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

JOZA
JOZEFCZYK
JOZEFIAK
JOZEFOWICZ
JOZSA
JOZWIAK
JOZWICK
JOZWIK

Top 100 Surnames in the 2010 US Census starting with JOZ

SurnameCountRankWiki?
JOZWIAK 2023 14695 no
JOZEFOWICZ 286 68770 no
JOZWIK 257 75069 no
JOZSA 244 78316 no
JOZEFIAK 204 90495 no
JOZEFCZYK 132 129047 no
JOZWICK 128 132206 no
JOZA 116 143149 no