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 = 'ID' order by rank asc limit 0,100 Surnames > I > ID > IDZ

Surnames > I > ID > IDZ

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
IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV IW IX IY IZ
IDA IDD IDE IDI IDL IDN IDO IDR IDS IDZ

Full Surname List Starting with IDZ(Alphabetical)

IDZIAK
IDZIK
IDZIKOWSKI

Top 100 Surnames in the 2010 US Census starting with IDZ

SurnameCountRankWiki?
IDZIK 162 109258 no
IDZIAK 157 111988 no
IDZIKOWSKI 127 133048 no