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 = 'PI' order by rank asc limit 0,100 Surnames > P > PI > PID

Surnames > P > PI > PID

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
PA PE PF PH PI PJ PL PN PO PP PR PS PT PU PY
PI PIA PIB PIC PID PIE PIF PIG PIH PII PIJ PIK PIL PIM PIN PIO PIP PIQ PIR PIS PIT PIU PIV PIW PIX PIZ

Full Surname List Starting with PID(Alphabetical)

PIDCOCK
PIDDE
PIDDINGTON
PIDGEON
PIDO

Top 100 Surnames in the 2010 US Census starting with PID

SurnameCountRankWiki?
PIDGEON 1785 16188 no
PIDCOCK 326 61585 no
PIDDINGTON 142 121590 no
PIDDE 130 130610 no
PIDO 120 139228 no