Sunday afternoon Genealogy Fun

Sunday Afternoon Genealogy Fun – How Many Surnames In Your Family Tree Database?

Each week on Randy Seaver’s Genea-musings blog he has a post for Saturday night Genealogy fun. Because of the time difference, I have called my series Sunday Afternoon Genealogy Fun. This week the mission was:
1) Go into your Genealogy Management Program (GMP; either software on your computer, or an online family tree) and figure out how to Count how many surnames you have in your family tree database.

2)  Tell us which GMP you’re using and how you did this task.

3)  Tell us how many surnames are in your database and, if possible, which Surname has the most entries.  If this excites you, tell us which surnames are in the top 5!  Or 10!!  Or 20!!!

4)  Write about it in your own blog post, in a comment to this blog post, in a status or comment on Facebook, or in Google Plus Stream post.

NOTE:  If you can’t figure out how to do this in your GMP (Genealogy Management Program), use the Help button in your program and search for “count surnames” then follow directions.

I use Legacy 8, and to find these details I select Tools from the main menu, and Statistics from the ribbon.
statistics
Then it’s just a matter of scrolling down to the Surname section.
Surname statistics
I have 1857 unique surnames, and the top 10 surnames are:

Docwra 737
Meiklejohn 360
Whimpey 305
Campkin 174
Marshall 169
Sell 156
Clyne 155
Leete 146
Slawson 136
Marr 132

With Legacy Statistics I can also show the most popular surnames by date.  Legacy doesn’t show the time frame covered by each surname, though.  Since I also have Rootsmagic 7, I decided to transfer my data into Rootsmagic, to get this information.
rootsmagic statistics

My top 25 surnames are

DOCWRA 737 persons, from 1480 to 2002
MEIKLEJOHN 360 persons, from 1670 to 2008
WHIMPEY 305 persons, from 1540 to 2009
CAMPKIN 174 persons, from 1750 to 1994
MARSHALL 169 persons, from 1760 to 2002

SELL 156 persons, from 1620 to 1934
CLYNE 155 persons, from 1751 to 1989
LEETE 146 persons, from 1500 to 1975
SLAWSON 136 persons, from 1677 to 1984
MARR 132 persons, from 1768 to 2010

MULDER 110 persons, from 1790 to 1994
HARLEY 103 persons, from 1756 to 2004
PRAIN 102 persons, from 1673 to 1955
RUSSELL 101 persons, from 1790 to 2009
OLIVER 97 persons, from 1762 to 1985

SMITH 92 persons, from 1760 to 2002
WILLIAMSON 91 persons, from 1805 to 2004
MONCUR 88 persons, from 1750 to 1965
THEISINGER 84 persons, from 1805 to 2004
LAVER 83 persons, from 1710 to 1980

DANDIE 81 persons, from 1700 to 1990
MALE 76 persons, from 1720 to 1933
HOOTON 72 persons, from 1811 to 1987
SCOTT 67 persons, from 1755 to 1978
SHARP 65 persons, from 1740 to 1980

Since Randy issued this challenge last year, I decided to compare the statistics from last year to this year.
These were last year’s statistics:
RootsMagic surname

The biggest change was the entries without a surname – last year I had 118 entries.  This year, I only have 53.  I also went from 1829 unique surnames to 1857.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s