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 = 'OG' order by rank asc limit 0,100 Surnames > O > OG > OGR

Surnames > O > OG > OGR

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
OA OB OC OD OE OF OG OH OI OJ OK OL OM ON OO OP OQ OR OS OT OU OV OW OX OY OZ
OGA OGB OGD OGE OGG OGI OGL OGN OGO OGR OGS OGU OGW

Full Surname List Starting with OGR(Alphabetical)

OGRADY
OGRAM
OGREEN
OGREN
OGRIN
OGRODNICK
OGRODNIK
OGRODNY
OGRODOWSKI

Top 100 Surnames in the 2010 US Census starting with OGR

SurnameCountRankWiki?
OGRADY 7306 4831 no
OGREN 2190 13806 no
OGRODNIK 369 55619 no
OGRODOWSKI 177 101737 no
OGRAM 160 110286 no
OGRODNICK 144 120187 no
OGRIN 126 133863 no
OGRODNY 113 146201 no
OGREEN 102 158432 no