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 = 'CS' order by rank asc limit 0,100 Surnames > C > CS > CSI

Surnames > C > CS > CSI

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
CA CD CE CH CI CL CM CN CO CR CS CU CV CW CY CZ
CSA CSE CSI CSO

Full Surname List Starting with CSI(Alphabetical)

CSIK
CSIKOS
CSILLAG
CSISZAR
CSIZMADIA
CSIZMAR

Top 100 Surnames in the 2010 US Census starting with CSI

SurnameCountRankWiki?
CSIZMADIA 270 72105 no
CSIKOS 139 123796 no
CSISZAR 119 140157 no
CSIK 104 156044 no
CSILLAG 103 157234 no
CSIZMAR 102 158432 no