Saturday, October 7, 2023

Saturday Night Genealogy Fun -- Which Ancestor Lived the Shortest Life?

 Calling all Genea-Musings Fans:

It's Saturday Night again -

Time for some more Genealogy Fun!!

Here is your assignment, should you decide to accept it (you ARE reading this, so I assume that you really want to play along - cue the Mission Impossible music!):

1)  Which of your known ancestors lived the shortest life?  Consider only the last eight generations and those ancestors with a known birth and death date.  Do you know the cause of death?  Was there an obituary?  How many children did s/he have?  How did you figure this out?

2)  Write your own blog post, or leave a comment on this post, or write something on Facebook.

Here's mine:

I think my ancestor who lived the shortest life in the recent eight generations is:

#135. Abigail Peirce: born 12 April 1750 in Waltham, Middlesex, Massachusetts, United States; died 2 February 1776 in Lincoln, Middlesex, Massachusetts, United States.  She married Jeremiah Knowlton (1745-1785) on 4 April 1771 in Waltham, Massachusetts.

So 25 years, 9 years, 21 days. 

I don't know the cause of death.  I have not found an obituary.  She had two children, including my 4th great-grandmother Abigail Knowlton (1774-1855).

I found no easy way to determine the answer to this question.  I fail at making Custom Reports in RootsMagic, although I'm sure one could be created to solve this problem.  I can create and add persons to a Group.  I can't export a Group list to a spreadsheet in RootsMagic, only to a GEDCOM file.  I could make a GEDCOM file of just my ancestors, and then try to use Margaret O'Brien's process described in Convert GEDCOM To Spreadsheet - Without Technical KnowhowIf I had a spreadsheet, I could subtract birth from death dates and have a great solution.  I didn't try that but it looks complicated and possible.

In the end, I made an Ahnentafel report in RootsMagic, reviewed it line-by-line and found the shortest lifespan going name by name.


The URL for this post is:

Copyright (c) 2023, Randall J. Seaver

Note that all comments are moderated, so they may not appear immediately.  

Please comment on this post on the website by clicking the URL above and then the "Comments" link at the bottom of each post.  Share it on Twitter, Facebook, or Pinterest using the icons below.  Or contact me by email at 


Janice M. Sellers said...

Here's mine:

Greenhill39 said...

Family Tree Maker has an Age at Depth data field that can be used with their custom reports. It was easy to list all ancestors with the birth, death, and age at death, but I had to look at each one for which generation. Age at death only shows the age in years. I guess I could do the actual math.

Ellen E Curtiss (Nellie) was born 21 Sep 1865 in Woodbury Ct and died 16 Jun 1899 in Washington Depot age 33 of Tuberculosis. She was my Great Grandmother. There are family pictures of her with several sisters and with my grandfather as a child.

Linda Stufflebean said...

Here's mine. I think my married ancestors won this unfortunate challenge: