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

Surnames > J > JI > JIA

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
JI JIA JIB JIC JIE JIG JIH JIJ JIL JIM JIN JIO JIP JIR JIS JIT JIV JIW

Full Surname List Starting with JIA(Alphabetical)

JIA
JIAN
JIANG
JIAO

Top 100 Surnames in the 2010 US Census starting with JIA

SurnameCountRankWiki?
JIANG 19409 1849 no
JIA 2409 12802 no
JIAO 792 29719 no
JIAN 788 29822 no