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 = 'AT' order by rank asc limit 0,100 Surnames > A > AT > ATZ

Surnames > A > AT > ATZ

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
AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ
AT ATA ATC ATE ATH ATI ATK ATL ATM ATN ATO ATR ATS ATT ATU ATW ATZ

Full Surname List Starting with ATZ(Alphabetical)

ATZ
ATZERT
ATZINGER

Top 100 Surnames in the 2010 US Census starting with ATZ

SurnameCountRankWiki?
ATZ 380 54296 no
ATZERT 164 108199 no
ATZINGER 141 122314 no