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

Surnames > J > JA > JAT

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

JATA
JATCZAK
JATHO
JATIVA
JATTA
JATTAN
JATZLAU

Top 100 Surnames in the 2010 US Census starting with JAT

SurnameCountRankWiki?
JATTA 255 75564 no
JATCZAK 173 103655 no
JATIVA 159 110825 no
JATHO 146 118853 no
JATZLAU 143 120901 no
JATTAN 133 128249 no
JATA 102 158432 no