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 = 'ST' order by rank asc limit 0,100 Surnames > S > ST > STJ

Surnames > S > ST > STJ

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
SA SB SC SD SE SF SG SH SI SJ SK SL SM SN SO SP SQ SR ST SU SV SW SY SZ
STA STB STC STD STE STF STG STH STI STJ STL STM STO STP STR STS STT STU STV STW STY

Full Surname List Starting with STJ(Alphabetical)

STJACQUES
STJAMES
STJEAN
STJOHN
STJULES
STJULIAN
STJULIEN
STJUSTE

Top 100 Surnames in the 2010 US Census starting with STJ

SurnameCountRankWiki?
STJOHN 15843 2303 no
STJEAN 3350 9687 no
STJAMES 1099 23205 no
STJULIEN 1093 23300 no
STJUSTE 666 34110 no
STJACQUES 653 34618 no
STJULIAN 398 52169 no
STJULES 176 102197 no