Friday Faces from the Past

 

Lewis M. Goodwin

born 1831 in Spencer County, Kentucky, USA

died 1914 in Labette County, Kansas, USA

and his wife,

Susan Graham Goodwin
born 1834 in Kentucky, USA
died 1899 in Edna, Labette County, Kansas. USA

Saturday Night Genealogy Fun - How Many Surnames in Your Family Tree Database?

 From Randy (a cousin discovery!!) over at Genea-Musings:

it's Saturday Night - 

time for more Genealogy Fun!!!

Your mission, should you decide to accept it, is to:

(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 or database.

(2)  Tell us which GMP you are 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)  Tell us all about it in your own blog post, in a comment to this post, in a post on Facebook, or on Twitter.  

Here's mine:

I use Family Tree Maker 19 (FTM19) as my GMP.  In FTM19, go to "Publish,", then "Person Reports," and then choose "Surname Report."  I then tweaked the Settings to "All Individuals," "Sort by Surname Count," and "Show Divider Between Surnames."

I have 75 pages of surnames, listed from the most number of instances down to the least number of instances (1).  I did a count of how many surnames on a page (44), multiplied that by 74 pages, and then added the 20 entries on the last page (page 75) and got a total of 3,276 surnames in my family tree.

This is the first page of my report:

Surname Report 05-14-2022

The top 20 are, with birth date ranges:

TAPLEY - 927 from 1691-2010

MNU (Maiden Name Unknown) - 672 from 1531-1984

OZMUN - 300 from 1764-1973

CLAXTON - 299 from 1764-1997

DRAKE - 291 from 1647-2001

PRICE - 272 from 1680-1967

BUSH - 264 from 1589-1971

POWELL - 257 from 1750-1980

SMITH - 249 from 1648-1984

RANNEY - 232 from 1661-1973

HUBBARD - 212 from 1601-1925

WILLIAMS - 145 from 1777-1992

DAVIS - 126 from 1760-1965

GOODWIN - 125 from 1776-1961

DURDEN - 123 from 1775-1960

JOHNSON - 123 from 1681-1974

WILSON - 116 from 1847-1981

BARWICK - 113 from 1731-1957

WHEELER - 108 from 1807-2017

BEASLEY - 97 from 1788-1983

I found surprises in my list.  First of all I would have thought that my number of Tapleys would have been higher.  I also did not realize how high the numbers are for Smith, Johnson, Davis, and Williams.  I had to laugh that Powell was in the top 10 - all of the them married into my family.  I have none in my direct line.  However, my family intertwines with the Powells over and over again to the  point that a fellow Powell researcher I know and I call each other cousins anyway.  I was surprised (and disappointed) that the number of Odoms, Goths, or Schwalls were not higher.  But then I have had a harder time researching those surnames, so it shouldn't be a surprise.  

I am looking forward to see how this changes over the next few years since I am about to dive into the Ranney family records again.

Saturday Night Genealogy Fun - Top 20 Surnames in Your Family Tree

From Randy over at Genea-Musings:

it's Saturday Night - 

time for more Genealogy Fun!!!

Your mission, should you decide to accept it, is to:

(1)  Go into your Genealogy Management Program (either software such as Family Tree Maker (in my case!) 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 what the top 200 surnames are in your database, and, if possible, how many entries for each.  How many different surnames are in your family tree?

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

NOTE:  If you can't figure how to do this in your GMP (Genealogy Management Program), use the Help button in your program and search for "count surnames" or "surname report" then follow the directions.

Here's mine:

I used Family Tree Maker 2019 because that the software I use for my GMP.  In FTM 2019, go to Publish, then Person Reports, then Surname Report.  You can tweak your report and choose to include either Immediate Family, Extended Family, All Individuals, or choose only those individuals you wish.  Of course, for this exercise, I chose All Individuals.

Then you can choose to sort by surname court (I did.), limit counts to included individuals (I'm not sure how this works.), show divider between surnames (makes it easier to read) and include preparer information.

Then click Generate Report.  I got this:

It looks a lot like Randy's report from RootsMagic 7.  It was easy to do and I have 51 pages of surnames.  It doesn't give me a total number of surnames, but if I do the math like Randy did:  24 names per pages 1-50, plus 20 on page 51 = 1,220 surnames in a database of 14,693 people.  

My top 20 surnames, with earliest and most recent dates they occur:

TAPLEY, count 803, from 1691-2010

MNU (Maiden Name Unknown), count 428, from 1592-1970

Drake, count 269, from 1647-1967

Powell, count 268, from 1715-1980

Bush, count 251, from 1655-1966

Ranney, count 214, from 1661-1951

Claxton, count 197, from 1764-1997

Price, count 197, from 1680-1959

Smith, count 197, from 1738-1984

Hubbard, count 181, from 1601-1913

Goodwin, count 125, from 1776-1947

Durden, count 110, from 1775-1960

Flanders, count 109, from 1756-1970

Kight, count 98, from 1775-1983

Wheeler, count 98, from 1807-2017

Russell, count 94, from 1798-1951

Williams, count 91, from 1777-1979

Odom, count 87, from 1798-1966

Davis, count 86 from 1760-1961

Kea, count 86 from 1810-1957

And one bonus one if you don't want to count the MNU:

Beasley, count 85, from 1791-1972

What surprises me is how few of the top surnames (in numbers) are actually direct line ancestors!