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

Surnames > A > AT > ATR

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

ATRI
ATRIA
ATRIAN
ATRISCO

Top 100 Surnames in the 2010 US Census starting with ATR

SurnameCountRankWiki?
ATRIAN 194 94311 no
ATRIA 138 124548 no
ATRI 138 124548 no
ATRISCO 112 147253 no