Elizabeth Ulrich (c 1720 – 1758/1782), Not a Cripe, 52 Ancestors #134

Elizabeth Ulrich, the wife of Stephen Ulrich (Jr.), has been rumored as long as I’ve been researching this family to be a Cripe, supposedly the daughter of Jacob Cripe, but she isn’t.

Unfortunately, we don’t know much about Elizabeth, and most of what we do know, including her name, is because she signed deeds selling land with Stephen, her husband.  Thank goodness for that!

Assuming she was Stephen’s only wife, and he was her only husband, they were likely married about 1740 or so, very probably in York County, Pennsylvania where Stephen lived at the time.  Stephen’s father, Stephen Ulrich Sr. had purchased land there and Ulrich was a surname listed as a founder of the Brethren congregation there in 1738.  At that time, and for some time thereafter, the Brethren met in homes and barns and didn’t build church buildings.

There weren’t a lot of Brethren families in this area early.  Many German families were Lutheran and some were Mennonite.  Elizabeth was almost assuredly Brethren, or Stephen would have been unwelcome in the Brethren Church.  Her family could have been a sister religion, like Mennonite, but when she married Stephen she would have to have converted.  Two Mennonite families related to the Brethren Miller family, who also lived in the area, were Berchtol/Bechtol/Bechtel and Garver/Garber.

If Elizabeth’s family was Brethren, the Brethren families that we are aware of in York County that early, based on the “History of the Church of the Brethren in Southern District Pennsylvania,” are as follows:

  • Leatherman
  • Martin
  • Ulrich
  • Greib/Gripe/Cripe
  • Becker
  • Stutzman
  • Miller (may not have been there in 1738, but arrived shortly thereafter and was related to the Stutzman family)
  • Dierdorff
  • Bigler

Unfortunately, Morgan Edwards, writing in 1770 also added the phrase, “and others.”  Perhaps other Brethren family researchers will know some of those “other” surnames that were in York County before about 1745.

The Brethren men tended to stay out of the record books, out of court, and out of the deed offices.  They didn’t believe in obtaining marriage licenses, and often didn’t have wills.  The Brethren churches didn’t keep membership rosters or other types of minutes.  Brethren didn’t serve in the militias either, but thank Heavens they had to pay taxes because often, that’s our only record that they were living in a particular place and time – if the tax records survived.

Brethren did sometimes register deeds, and they had to have surveys for land grants, warrants and patents.  There was no choice in that matter.  However, Stephen’s surveys for his 1742 land warrants weren’t returned until 1800 and 1802, many years and several owners after his death.

We can presume, and that’s a dangerous word, that Stephen Ulrich was married or marrying in 1742 when he was granted land.  Single men typically didn’t set up housekeeping by themselves.

Our best resource would be a family Bible, but we don’t have one of those either.  If you’re thinking to yourself, Brethren research sure is difficult….yes it is!!!

Based on the fact that Stephen Ulrich, Jr., would sign his name in German script in 1773 when his close friend, Jacob Stutzman wrote his will in German, it’s unlikely that Stephen or Jacob spoke English, or if they did, it was minimal.  This also tells us unquestionably that Stephen’s wife was German as well, and the logic tells us that she was also Brethren, although there was an entire German settlement in York County.

According to the “History of the Church of the Brethren of the Eastern District of Pennsylvania,” in 1770, the Little Conewago Church had 52 families, and Edwards reports the entire Brethren population in all churches to be about 419 families.  By 1770, these should be second or third generation, so if you divide 419 by 5 (children per family) you would have 83 families 30 years earlier in 1735.  Of course, their children all married each other’s children.  If there were a total of 83 families in 1735 or so, or roughly 10 families per congregation, assuming no conversions between 1735 and 1770 and that all congregations were the same size.  Of course, the older churches were certainly larger, so perhaps the only Brethren families in Little Conewago were actually the families mentioned by Edwards.  Maybe there weren’t “others” or, at least, not many “others.”

Prior to 1742, according to Edwards on page 79 of the same book, there were only about 8 congregations, including the following:

cripe-churches-2

That means Elizabeth was likely the daughter of one of those early Brethren families, or maybe the daughter of one of the unnamed “others.”  Perhaps other Brethren researchers can add to the list of Brethren families in York County prior to 1745.  York County was Lancaster County prior to 1749.

The Elizabeth Cripe Confusion?

I do know where some of the confusion arises relative to Elizabeth being a Cripe.

Jacob Greib/Cripe was Elizabeth’s purported father and the only known Greib/Cripe in York County.  Jacob wrote his will in 1779 in Bedford County, Pennsylvania, but it wasn’t probated until 1801.  His wife’s name was Elizabeth and in his will, he thankfully tells us that she was “born Ulrich.” Given Jacob’s age, his wife, Elizabeth would have had to have been the daughter of Stephen Ulrich Sr., and therefore the sister of Stephen Ulrich Jr. whose wife’s name was also Elizabeth.

So we do have Elizabeth Ulrich Cripe.  This family liaison also explains why Jacob Cripe moved to Frederick County, Maryland with or near Stephen Ulrich Jr. in the 1750s.

Jacob Cripe, several of Stephen Ulrich Jr’s children along with Stephen’s two brothers, John and Daniel Ulrich, moved on to Bedford County, Pennsylvania in the 1770s.

What Do We Know About Elizabeth’s Life?

If our Elizabeth was born about 1720, she was probably born overseas, most likely in Germany.  Elizabeth was assuredly German, based on the fact that the German’s didn’t speak English, so to communicate with Stephen, she would have been a German-speaker.

Stephen and Elizabeth probably married about 1742, the year Stephen Jr. bought land in York County.

Stephen’s land was probably located along Narrow Drive, along Indian Run where it intersects with the South Branch of Conewago Creek, according to Stephen’s deeds.

ulrich-york-land

While some of this land is beautifully groomed farmland today, other parts are still wooded and probably look much like they did when Stephen and Elizabeth lived here.  The photo above shows the land along Indian Creek, patented by Stephen Ulrich.  The tree line runs along the creek.

We do know that Elizabeth and Stephen’s land included part of the “Old Conestoga Road,” which is now Hanover Pike, shown below.

ulrich-york-land-2

Then, it would have been nothing more than a wagon trail, and probably only wide enough for one wagon.  There would have been ruts and they would have been mudholes when it rained.  Wouldn’t Elizabeth be surprised to see this land today.  And paved roads.  There weren’t such things in the 1740s.  Only paths and dirt.

We know that Elizabeth had son, David Ulrich, about 1746 while they lived in York County, but we don’t know if he was the first child born to Elizabeth and Stephen Ulrich.  They could have had a child or children that died earlier, or David could have been born earlier than 1746.  It would have been very unusual for a couple to marry in 1742 and not have a child until 1746.

Elizabeth’s son, Stephen the third, was born about 1750.  A 4-year gap between children strongly suggests that at least one child died.

In 1751, Elizabeth and Stephen moved from York County to Frederick County, Maryland, a move of about 50 or 60 miles nearly straight west.

ulrich-hanover-to-frederick

This move would have been made with the hope of escaping the conflict in York County surrounding land and the incessant bickering brought about by the “border war” between Maryland and Pennsylvania.

Daughter Christina was born about 1752 and eventually married Jacob, a son of their neighbor, Jacob Stutzman.

Samuel was born about 1754.

Elizabeth was born about 1755/1757 and she married Daniel Miller, son of Philip Jacob Miller who was about the same age as Stephen Ulrich and wife, Elizabeth. Philip Jacob’s father, Johann Michael Mueller/Miller was also one of the early Brethren settlers in York County.

There could have been another child born between Samuel and Elizabeth.

Mary was born about 1760.

There could have been a child between Elizabeth and Mary.

Hannah was born about 1762 and Lydia about 1764.

Given those birth dates, it’s possible that in about 20 years of child bearing, Elizabeth buried 3 or more children.

It’s actually surprising that they didn’t lose more children, considering the upheaval that surrounded them as they lived in the borderland between whites and Indians.

Not only were they living in a war zone in Pennsylvania – with the border being disputed by both Pennsylvania and Maryland for 30 years, but the ownership of their land was in question as well.

In York County, a murder occurred at their neighbor’s mill.  Stephen had a land grant from Pennsylvania, but a man named Digges had a Maryland land grant for that same area – and he tried to force the Germans who obtained Pennsylvania grants to surrender them to him, or at least repurchase their land. Needless to say, that didn’t go well.  Digges tried to force the miller to surrender his deed, and the miller’s son shot Digges son, Dudley, in the ensuing scuffle.  Danger and violence was ever present – a frightening prospect for a Brethren woman whose religion forbade even self-defense.

Finally, in 1751, the Ulrich family sold their land, packed up and headed for Frederick County with a few other Brethren families as well – namely Leatherman, Martin, Miller and Cripe.  The Brethren were converting other settlers as they went too – and Maryland was becoming a popular location for other German-speaking families because there were other Germans there.  When you don’t speak English, you need a German community.

It’s difficult for us to remember today that these people were at a distinct disadvantage, given that they did not speak English, nor would they have understood American customs well.  Letters written to the governor of Pennsylvania explained that these people, who spoke only German, didn’t understand the circumstances surrounding the land sales at Digges Choice and were being taken advantage of by Digges aggressions.  It didn’t help any, of course, that Digges was a slippery sheister and was very likely targeting the Germans who he felt were opportunistic targets.

The land Stephen and Elizabeth bought in Frederick County may or may not have had “improvements.”  Waggoner, the man they bought the land from sold two halves, and one of the two halves included the following:

One dwelling house 20 by 16 feet made of hewd logs and covered with lap shingles, a stone chimney, one dwelling house 27 by 22 feet of hewd logs and covered with lap shingles, plankd above and below, a stone chimney, a new barn of hewd logs covered with lap shingles, 49 feet by 27, 69 apple trees, 72 peach trees and 6 acres of cultivated land well fenced.

While a house 20 by 16 doesn’t sound very large by today’s standards, it was typical for the time.  Most cabins, even when referenced as the “mansion house,” were not very large.  But the barn, that’s another story indeed.  The husband would have been one very happy man with a barn more than twice the size of the house.  Dare I say he would have been in “hog heaven?”

In 1767, when Stephen and Elizabeth had their property resurveyed to include two new parcels into a homestead they would call Germania, there was only “a quarter acre cleared and 230 old fence posts.” That certainly doesn’t sound like there were many improvements, nor does it reflect “6 acres of cultivated land,” so apparently, Stephen Ulrich didn’t purchase the half with the two houses, peach and apple trees and cleared land.

If their land in 1767 had only one quarter acre cleared, how did they live and how had they lived since 1751?  Clearly, they weren’t farming the way we think of farming today.  If Stephen wasn’t clearing his land, what was he doing with it?  Did they only farm enough to provide food for the table?  How did they earn money for the rest of their needs?

More Issues and Warfare

I’m sure these families believed they had moved far enough south and west to avoid border issues, but ironically, when the Mason-Dixon line was completed in 1767, Stephen’s neighbor Jacob Stutzman’s land would straddle the Pennsylvania/Maryland border, and it’s probable that Stephen’s land did as well, given that a later deed for part of his land that was able to be accurately placed is located just north of the state line.

This picture, below, is take on Fort Loudon Road, which would have been the main and probably the only road at the time Stephen lived there. This land is just north of the Maryland/Pennsylvania border, looking east.  The land on the west side of the road is elevated and truly does begin the mountain range – so this land was literally at the foot of the mountains.  The land to the east is flat.  Perhaps this is what Elizabeth saw, if she could get high enough to see over the trees. Of course, not much was cleared at that time, so maybe all she saw was trees.  And behind the trees….Indians.

ulrich-maryland-pa-border

In 1755, Elizabeth’s life would have been turned upside-down.  When General Braddock was killed after marching his red-coasted soldiers through Frederick County on his way west, those same soldiers were soundly defeated.  The French and Indians saw that defeat as an opportunity to remove the settlers – and by remove, I don’t mean in a friendly way.  The Indians descended upon the settlers with tomahawks and torches, killing settlers and burning homesteads, and the people who would not defend themselves were easy pickings.  Elizabeth must have been terrified.

In 1755, Elizabeth had a 9 year old child, a 5 year old, a 3 year old and a baby.  She and Stephen packed the children, and probably as much as they could take with them, if anything at all, into a wagon and they evacuated – abandoning everything left behind to flames.

They were gone for at least three years.  The only clue we have as to where they went during that time is that in 1758, Stephen and Elizabeth sold land in York County, Pennsylvania from Baltimore County, Maryland.

The war officially ended in 1758, but the attacks didn’t stop at once, but slowly subsided over the next few years.  Taxes weren’t collected in Frederick County until 1762.  We know that at least some of the Brethren returned in 1761 – the Michael Miller family being one.

In 1761, Elizabeth and Stephen were back in Frederick County, rebuilding their home, and they also had at least one baby while they were gone – Elizabeth.  Depending on when they returned, Mary, born in about 1760, was probably born elsewhere as well.

Now Elizabeth is raising 6 children and living in conditions much like camping, minus the fun, while they rebuild their home and farm.  Elizabeth must have cooked over an open fire.  Perhaps they lived in their wagon during this process.  Or they may have lived with others as they rebuilt their homestead.  The Brethren, Mennonite and Amish were well known to have barn and house raisings, even yet when I was growing up 200+ years later.

By early 1761, Elizabeth and Stephen were selling land in York County, again, and they list their residence as Frederick County.  Furthermore, Jacob Stutzman who had bought land in York County from Stephen sells his land there and purchases the land next to Stephen in Frederick County. I wonder if Stephen and Elizabeth returned to York County and stayed with Jacob Stutzman for at least part of the time they were in exile.  Surely those two men welcomed each other’s presence back on the frontier in Frederick County when Jacob moved next door to Stephen in 1761.  Stephen named his land “Good Neighbor” and Jacob named his “Good Luck.”

Hannah, Jacob’s wife would have been good company to Elizabeth as well.  We do know that there were other Brethren in the area, but the Miller family was located further east by at least 5 miles and possibly more – near present day Mauganstown.  The Leatherman and Martin families lived in the area too, but I don’t know where.  Jacob Cripe lived near Stephen Ulrich, as did Daniel and John Ulrich, brothers of Stephen Jr.

As the rhythmic cycle of planting and harvesting resumed after their return in 1761, and some semblance of normalcy returned, it would be short lived.

Just two years later, in 1763, the families had to evacuate again when Pontiac’s Rebellion reached Frederick County.  Reports were that the attacks were even worse than they had been in 1755.  Elizabeth must have been heartsick.  After all, they had just rebuilt and they had to leave the farm to flames once again.

By this time, Elizabeth had born another child, about 1762, and was probably pregnant  again for Lydia who was born about 1764, most likely while the family was once again in refuge elsewhere.

Elizabeth was most assuredly tired.  Tired from taking care of 8 children, tired of burying children, tired of evacuating and living someplace not her home.  Tired of fearing for her life, and the lives of her children, and tired of fleeing in terror.  She would have been tired of her home burning – and it assuredly burned twice from warfare – and that’s assuming it never burned any other time.  Many cabins did.

We know that Elizabeth and Stephen were back in Frederick County by 1766, because Stephen sells land then.  However, Elizabeth does not sign or release her dower, nor does she sign in 1768 when Stephen sells additional land.

It’s tempting to think that perhaps Elizabeth just didn’t sign for some reason, but given the history of Elizabeth signing deeds, that’s unlikely.

The following deed history is extracted from the Stephen Ulrich Jr. article as well as from Dan Olds work.  Unfortunately, sometimes our knowledge of early deeds comes from later deeds that reference unrecorded earlier deeds.  From their reports, Elizabeth signed every deed until 1761, although I am uncertain about 1755.  I feel that all of these deeds actually need to be verified against the original records.

  • 1753 – To Lodowich Miller, son of Johann Michael Miller
  • 1754 – To Lodewick Miller
  • 1754 – To Daniel Ulrich
  • 1755
  • 1758 – Sold land in York County
  • 1761 – Sold to George Wine, probably related to Michael Wine who would marry Lodowich Miller’s daughter. This transcribed record does not show Elizabeth signing. The original record should be checked.  If Elizabeth had children in approximately 1762 and 1764, she was clearly alive in 1761. Since we don’t know the exact birth years of Elizabeth’s last two children, it’s possible that both were born in or before 1761, and Elizabeth had died by the time the deed was signed.
  • 1766 – multiple deeds, none of which include Elizabeth.

We don’t know that Elizabeth didn’t die while they were in exile, and we don’t know that she wasn’t killed.  The commentary from contemporaneous writers was that nearly all families lost someone in the depredations.

In 1766, Stephen Ulrich and Nicholas Martin sold their tract of land that they had patented in 1761, in several pieces, giving Elizabeth several opportunities to sign…but Elizabeth did not seem to be present.  Ironically, they deeded part of the land to another Elizabeth Ulrich, thought to be the sister of Stephen Ulrich Jr.  Is it any wonder that Elizabeth Ulrich, Stephen’s wife, is so confusing and so often confused with other people?

By the way, Nicholas Martin is also rumored to be married to Elizabeth Ulrich, the daughter of Stephen Ulrich Sr., but since the Elizabeth Ulrich who received the 1766 deed married Jacob Snively, who sells that same land two years later, Nicholas Martin certainly can’t be married to her at this time.

If Stephen Ulrich’s wife, Elizabeth, died sometime between about 1764 and 1766, she may well have died in exile, leaving Stephen with children ages 19, 15, 14, 11, 9, 7, 5, 3 and a newborn.

Stephen did not remarry until 1782, to Hannah Stutzman.  How did he raise those children from roughly 1765 to 1782? By 1782, the children would all have been on their own, except for perhaps the very youngest who would have been about 18.  Did he marry between Elizabeth and Hannah?  Or did Elizabeth not die in 1765 or so, and simply fail to sign all of those deeds?

Elizabeth would have been about 45 when she died, assuming she died about 1765 – not old by any measure.  I cannot help but wonder if she died giving birth to a final child, who also died.

If in fact Elizabeth did not die in 1765, but simply stopped signing deeds, for some reason, she was assuredly gone by 1782 when Stephen Ulrich remarried to Hannah Stutzman, Jacob Stutzman’s widow.  In 1782, Elizabeth would have been about 62 – still not elderly.  So we can say with certainty she died between 1758 when she positively signed a deed and 1782 when Stephen remarried.

I wonder if Elizabeth is buried in Frederick County or if she died and was buried while the family was gone?  Did she die in the wagon along the road?  Did she die in childbirth?  Did she succumb to Indian raids?  It’s unusual that there are absolutely no stories about an early death and what happened to the children.  But by the same token, there were absolutely no stories about the Indian raids forcing the residents to remove, twice, and their homesteads burning either.

Did Stephen and the children ride home in that wagon alone – ending their exile.  It would have been a long, joyless, silent ride, punctuated only by the clip-clop of horse hooves as they propelled the family ever closer to home – or what had once been home.

How did the family feel to finally arrive where their home had been to only find charred rubble?  Did they pull up in front of where they had once lived and sit in silence looking at the shadow of what had once been, and now lay before their eyes in ruins?  If Elizabeth was gone, how were they going to survive without a mother?  Their home was gone and their mother was gone.  How could life get any worse?  They must have sat in that wagon feeling utterly dejected, staring at their former home, gone up in smoke and taking with it their hopes and dreams.  Now there were only charred remains, perhaps with weeds and vines growing in the cracks, returning to nature.  Not only did they have to rebuild their homestead, they had to rebuild their lives.  How did they do that?

Fortunately, they had other Brethren families to help them and provide moral support too.  Assuredly, someone helped Stephen with the younger children.  As the older children married, perhaps they took the younger ones under their wing.  Stephen physically could not watch young children and work in the barn and fields.

Elizabeth Was Not Jacob Cripe’s Daughter

The final nail in the coffin that proves that Elizabeth was not the daughter of Jacob Cripe is found in Jacob Cripe’s will, written in 1779 in Bedford County, Pennsylvania.  Marian Corya was kind enough to provide me with this transcribed copy:

Will of Jacob Gripe (1801), Huntingdon County Will Book 1: 195, Huntingdon County Historical Society, Huntingdon, Pennsylvania.

Last Will & Testament of Jacob Gripe Deceased

June 4th 1779

As I live and not know how long and must Die and not know how soon so is this my Will after my decease. My Son Jacob shall have Three hundred Pounds in all in Money of the Piece of Land which I bought in Frankstown he shall have One hundred and fifty Acres where he used to live and it shall be paid out of the Three hundred Pounds and the Remainder of that mentioned Money he shall have from that Money arising of that sold place.

The two Daughters of my Daughter Elizabeth shall have One hundred Acres in Frankstown where their Mother used to live and they shall pay for the Land Thirty Pounds, their Mother & Stepfather shall live unmolested on the Land during their Natural Life and after their Decease the two Daughters of the Elizabeth shall have it free if the thirty Pounds are paid.

Christian Shively shall have Two hundred Acres where he used to live, whereof he shall pay One hundred and fifty Acres.

John Wise shall have One hundred and fifty Acres whereof he shall pay One hundred Acres.

My Daughter Catharine shall have my hundred Acres where John used to live but she must live herself on the Land and shall give to Easter Thirty Pounds.

My Son Daniel shall have One hundred Acres where he used to live and shall give to Easter Thirty Pounds.

My Daughter Hanna shall have One hundred Acres adjoining Daniel and shall pay to Easter Thirty Pounds.

The remainder of the Land shall have my Son Samuel and shall pay to Easter Thirty Pounds.

And my Wife Elizabeth a born Ulrich shall have the right to one half of Samuels Land during her Natural Life for her own Use and Benefit with the House, Garden, Meadows and Improved Land to have it at her own Discretion, further she shall have, One Mare and all the House furniture and the Horn’d Cattle Samuel shall have the Horses, Cooper Tools, Plough, Hoes and Axes and that such shall be kept and done shall my Wife a born Ulrich with her Son Samuel have the Right as Guardian in my Name to give the others Titles according to the Rule of the Country, And herewith all under the Commands of God.

                                                                                                Jacob Gripe

As you can see from this will, Jacob did indeed have a daughter Elizabeth who was clearly living in 1779, and living in Frankstown which is either in Bedford County or the adjacent county.  Furthermore, Elizabeth, the wife of Stephen Ulrich Jr. had 5 daughters, not three, and Elizabeth and Stephen Ulrich never lived in Bedford County.

Elizabeth and Stephen’s first two children were males, as was the fourth.  The third and fifth children were daughters.  The fifth child was Elizabeth who married Daniel Miller.  All of Stephen and Elizabeth’s children mentioned above were accounted for when they sold Stephen’s land in 1785, after his death.  In fact, that’s how we know who his children were and who they married.

Lastly, there is nothing to indicate that Stephen’s wife, Elizabeth, was married twice, but Jacob Cripe in his 1779 will clearly refers to the step-father of the two daughters.  If Stephen’s wife, Elizabeth, was still alive in 1779, she was living in Washington County (formerly Frederick County,) Maryland, not Bedford County, Pennsylvania.  Stephen and Elizabeth never moved to Bedford County.

We can’t say unequivocally that Elizabeth was dead by 1779, but given that she stopped signing deeds, it’s likely.  We know positively, however, that she is gone by 1782 when Stephen remarries and we know that Elizabeth, Stephen’s wife, never lived in Frankstown.

And so ends the myth that Stephen’s wife,  Elizabeth Ulrich, was Jacob Cripe’s daughter.

The challenge here, of course, is that we know who Elizabeth Ulrich isn’t, but we don’t know who she is!

Pure Speculation

Given that most of Stephen Ulrich’s land sales of Germania (later resurveyed as Good Neighbor) were to either Ulrich family members or people in or related to the Miller family, I have always wondered if Elizabeth was a daughter of Johann Michael Miller.  Jacob Stutzman was either Michael Miller’s step-brother of half-brother.  Regardless of the exact relationship, Michael was very close to Jacob, and the two men immigrated together.  Lodowich Miller was Michael’s son.  There is no way to know if Elizabeth was Michael Miller’s daughter, unless Stephen Ulrich’s Bible, or Michael Miller’s Bible shows up on e-bay one day.  Keep in mind that the Bibles of both of these men, unless they managed to be put inside the wagons when evacuating, probably burned when their homes burned in 1755 and 1763.

Again, this is simply thinking out loud and trying to put puzzle pieces together.  Please do NOT list Elizabeth as Michael’s daughter in any trees due to this speculation.  I’m simply hoping that perhaps this line of thought could lead to additional research or a discovery by another researcher down the road as other records become available.

Can Mitochondrial DNA Help?

Mitochondrial DNA is passed intact from a mother to all of her children, but only daughters pass it on.  Fortunately, it’s not admixed with any DNA from the father, so many generations later, it stays the same, except for an occasional mutation.  That means that if Elizabeth is the daughter of Suzanna Berchtol and Michael Miller, her mitochondrial DNA would match exactly to other women who share the same common ancestor.

Michael Miller and his wife, Suzanna Agnes Berchtol, had no proven daughters, so to be able to utilize mitochondrial DNA, which Elizabeth would have inherited from her mother, we need to reach back to Suzanna Berchtol’s sisters in Germany.

To see if Elizabeth’s descendants match Suzanne Berchtol’s mitochondrial DNA, we would have to find a descendant of the sisters of Suzanna Agnes Berchtol, descended through all females to the current generation, where the descendant could be male or female.  Suzanna Berchtol did have two sisters, according to baptismal records in Germany, Barbel (Barbara) born in 1693 and Ursula born about 1696.  We don’t know for sure if these women lived or married, so there may be no descendants today, but hopefully there are.

To prove that Elizabeth is Michael Miller and Suzanna Berchtol’s daughter, or not, we would also need an individual descended from Elizabeth through all females, to the current generation, which can be male or female.

berchtol-miller-mtdna

If Elizabeth is the daughter of Suzanna, the mitochondrial DNA of anyone descended from her through all daughters will match the mitochondrial DNA of anyone descended through all daughters from either Barbel (Barbara) born in 1693 or Ursula born in 1696.

If a descendant of each line tests, and they don’t match (except for perhaps a mutation), then we know that Elizabeth was not the daughter of Suzanna Berchtol Miller, and we can look at the oldest ancestors of other people Elizabeth’s descendant matches to see if any of those matches come from Brethren families.

Fortunately, Elizabeth had 5 daughters who could have had daughters, highlighted below…on down the line to living descendants today.

Elizabeth Ulrich’s children were:

  • David Ulrich born about 1746 and died in 1823, married Barbara and had 7 children. They lived in Montgomery County, Ohio.
  • Stephen Ullery born about 1750 and died in 1835. He married Susan Rench and they lived in Morrison’s Cove in Bedford County, PA and then in Montgomery County, Ohio.
  • Christina Ulrich born about 1752 and died about 1810. She married Jacob Stutzman (Jr.) who later became her step-brother when their widowed parents married. They eventually moved to Montgomery County, Ohio.
  • Samuel Ulrich born about 1754 and died in 1822. He married Mary Brumbaugh and they lived in Bedford County, PA.
  • Elizabeth Ulrich born about 1757 and died in 1832. She married Daniel Miller and they moved first to Bedford County, PA, then to Clermont County Ohio, then to Montgomery County, Ohio.
  • Mary Ulrich born about 1760 and died about 1842. She married George Butterbaugh and they lived in Bedford County, PA.
  • Hannah Ulrich born about 1762 and died in 1798. She married Henry Butterbaugh and they lived in Washington County, Maryland.
  • Lydia Ulrich born about 1764 and died about 1810. She married Jacob Lear, Jr and they lived in Cambria County, PA.

I have a DNA testing scholarship for anyone who descends from either Barbara or Ursula Berchtol, the sisters of Suzanna Agnes BerchtolI in the manner described above, through all females to the current generation which can be male or female.

I also have a DNA testing scholarship for anyone descending from Elizabeth, wife of Stephen Ulrich, through all females to the current generation, which can also be male or female.

Why Can’t Autosomal DNA Solve this Riddle – At Least Not Today?

Many times autosomal DNA can help identify families and parents, but in this case, it’s unlikely.  Why?

To begin with, Elizabeth Ulrich is 7 generations back in time from me.  That’s a long time, genetically speaking.  Autosomal DNA is divided approximately in half in each generation, so I could only expect to carry less than 1% of Elizabeth’s autosomal DNA.

ulrich-direct-line

This doesn’t mean that I can’t match people who also descend from this couple, because I can and do, but it means that I’m unlikely to be able to tell with a combination of both DNA and genealogy who Elizabeth’s parents are.  Obviously, in this case, the genealogy is entirely missing, so we have to rely entirely on DNA.

Also making this even more difficult is that I have one other wife with an unknown surname in this same family grouping, from about the same time and place.

ulrich-unknown-females

Philip Jacob Miller’s wife’s name was Magdalena.  Philip Jacob married Magdalena about 1751, also probably in York County, or possibly in Frederick County, Maryland.  She too would have been Brethren.  Clearly, both Elizabeth and Magdalena could have been from any of the other Brethren families, and they could also have been related to each other, or any number of other Brethren families.  In other words, it’s not impossible or even unlikely that they shared some DNA, then.  The Brethren lines continued to intermarry, and many Brethren carry the DNA of these early founders.  The only family lines we can eliminate, positively, as Elizabeth’s (or Magdalena’s) parents would be Jacob Cripe, Stephen Ulrich Jr. and Sr. and Jacob Stutzman whose will was probated in 1776 and lists his children.  Aside from that, all Brethren families are candidates.

Therefore, if I did receive a “Brethren” match from a line whose genealogy was complete, with no unknown ancestors, and who did not descend from either the Miller, Stutzman or Ulrich lines, I would not be able to tell if the match was from Magdalena’s line or Elizabeth’s line – because I carry DNA from both of those women.  Furthermore, I don’t know if there are any lines out of this area that have not intermarried by this time.  The Brethren moved together, intermarried and founded churches together, for generations, and can still be found living adjacent today.

Still it’s fun to see who I match that is descended from Stephen and Elizabeth Ulrich.  If you descend from these families and have taken an autosomal DNA test, please do let me know.  We might share a segment of Stephen and Elizabeth’s DNA.  I share segments of DNA with other descendants of Stephen and Elizabeth through four of their daughters and one son.

My mother, who is one generation closer than me is at Family Tree DNA under the name of Barbara Jean Ferverda and her kit number at GedMatch is T167724.  She isn’t at Ancestry, because she passed away before Ancestry began autosomal testing, but I’ve tested at Ancestry.

In Summary

I hope that one day we can resolve the question of who Elizabeth’s parents were.  That resolution could happen because of DNA testing, or it could happen as more records become available and indexed at genealogy sites, or some combination of both. Even today, if other Brethren researchers can eliminate a few more York County families as candidates by providing the names of their children, or add some additional Brethren families known to be in York County before 1745, that would be most helpful.

Regardless, of who Elizabeth’s parents were, she was clearly one very brave lady, facing the trepidations of warfare from the time she married in the early 1740s until the mid-1760s.  That could have been her entire adult life, depending on when she died.  I hope that she lived longer than we think.  I so want her to be able to see her children grown to adulthood – to cry at their weddings – and to be able to hold her grandchildren.

I want her to be able to sit in a rocking chair on her porch, overlooking the vistas in the distance, without fear, telling stories from “long ago” to wide-eyed grandchildren about living in the wagon when the Indians came, cooking in a pot over a fire under the starlight when they returned and building houses in the woods where no settlers had lived before.  I want her to be able to pluck peaches and pears and apples from the trees she and Stephen would have planted when they returned in 1766 and bake pies when her grandchildren come to visit.  I so want Elizabeth to have had some good years.

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Concepts – Managing Autosomal DNA Matches – Step 2 – Updating Match Spreadsheets, Bucketed Family Finder Matches and Pileups

We’re going to do three things in this article.

  1. Updating Your DNA Master Spreadsheet With New Matches
  2. Labeling Known Pileup Areas
  3. Utilizing Phased Family Finder Matches

You must do item one above, before you can do item three…just in case you are thinking about taking a “shortcut” and jumping to three. Word to the wise. Don’t.

OK, let’s get started! I promise, after we get the housework done, you’ll have a LOT of fun! Well, fun for a genetic genealogist anyway!

Updating Your Chromosome Browser Spreadsheet

If you haven’t updated your chromosome browser spreadsheet at Family Tree DNA since you originally downloaded your matches, it’s time to do that. You need to do this update so that your DNA Master Spreadsheet is in sync with your current matches before you can add the Family Finder bucketed matches to your master spreadsheet. Just trust me on this and understand that I found out the hard way. You don’t have to traipse through that same mud puddle because I already did and I’m warning you not to.

Let’s get started updating our DNA Master spreadsheet with our latest matches.  It’s a multi-step process and you’re going to be working with three different files:

  • File 1 – Your DNA Master Matches spreadsheet that you have created. This is the file you will be updating with information from the other two files, below.
  • File 2 – A current download of all of your chromosome browser file matches.
  • File 3 – A current download of a list of your matches.

The steps you will take, are as follows:

  1. Download a new Chromosome Browser Spreadsheet, but DO NOT overwrite your existing DNA Master spreadsheet, or you’ll be swearing, guaranteed. This chromosome browser spreadsheet is downloaded from the Family Finder chromosome browser page. Label it with a date and save it as an Excel file.
  2. Download a new Matches spreadsheet. This spreadsheet is downloaded from the bottom of your matches page. Label it with the same date and save it as an Excel file too.
  3. Update your Master DNA Matches spreadsheet utilizing the instructions provided below.

If you need a refresher about downloading spreadsheet information from Family Tree DNA, click here.

Your Matches spreadsheet will include a column labeled “Match Date.”

concepts2-match-date

On your Matches spreadsheet, sort the Match Date column in reverse order (sort Z to A) and print the list of matches that occurred since your last update date – meaning the date you last updated your DNA Master Spreadsheet.

If you need a refresher about how to sort spreadsheets, click here.

concepts2-match-list

This list will be your “picklist” from the new chromosome browser match spreadsheet you downloaded. I removed the middle and last names the matches, above, to protect their privacy, but you’ll have their full name to work with.

After your spreadsheet is sorted by match date, with the most current date at the top, you’ll have a list of the most recent matches, meaning those that happened since your last file download/update. Remember, I told you to record on a secondary page in your DNA Master Spreadsheet the history of the file, including the date you do things? This is why.  You need to know when you last downloaded your matches so that you don’t duplicate existing matches in your spreadsheet.

Why don’t you just want to download a new spreadsheet and start over?

concepts2-headers

Remember the color coding and those pink columns we’ve been adding, at right, above, so you can indicate which side that match is from, if the segment is triangulated, how you are related, the most recent common ancestor, the ancestral line, and other notes? If you overwrite your current DNA Master spreadsheet, all of that research information will be gone and you’ll have to start over. So as inconvenient as it is, you’ll need to go to the trouble of adding only your new matches to your DNA Master spreadsheet and only add new matches.

Utilizing the new Chromosome Browser match spreadsheet, you are going to scroll down (or Ctl+F) and find the names of the people you want to add to your master spreadsheet. Those are the people on your Matches spreadsheet whose test date is since you last downloaded the chromosome browser information.

When you find the person’s name (Amy in this example) on the Chromosome Browser Match spreadsheet, highlight the cells and right click to copy the contents of those cells so that you can paste them at the bottom of your DNA Master Spreadsheet.

concepts2-pick-list

Next, open your Master DNA Spreadsheet, and right click to paste the cells at the very bottom of the spreadsheet, positioning the cursor in the first cell of the first row where you want to paste, shown below.

concepts2-paste

Then click on Paste to paste the cells.

concepts2-paste-position

Repeat this process for every new match, copy/pasting all of their information into your DNA Master Spreadsheet.  I try to remember to do this about once a month.

Housekeeping note – If you’re wondering why some graphics in this article are the spreadsheet itself, and some are pictures of my screen (taken with my handy iPhone,) like the example above, it’s because when you do a screen capture, the screen capture action removes the drop down box that I want you to see in the pictures above. Yes, I know these pictures aren’t wonderful – but they are sufficient for you to see what I’m doing and that’s the goal.

Combined Spreadsheets

In my case, if you recall, I have a combined master spreadsheet with my matches and my mother’s matches in one spreadsheet. You may have this same situation with parents and grandparents or your full siblings if your parents are missing.

You will need to repeat this process for each family member whose entire match list resides in your DNA Master spreadsheet.

I know, I groaned too. And just in case you’re wondering, I’ve commenced begging at Family Tree DNA for a download by date function – but apparently I did not commence begging soon enough, because as of the date of this article, it hasn’t happened yet – although I’m hopeful, very hopeful.

After your spreadsheet is updated, we have a short one-time housekeeping assignment, then we’ll move on to something much more fun.

Known Pileup Regions

I want you to add the following segments into your DNA Master spreadsheet. These are known pileup regions in the human genome, also known as excess IBD (identical by descent) regions. This means that you may well phase against your parents, but the match is not necessarily genealogical in nature, because many individuals match in these areas, by virtue of being human. Having said that, close relationships may match you in these regions. Hopefully they will also match you in other regions as well, because it’s very difficult to tell if matches in these regions are by virtue of descent genealogically or because so many people match in these regions by virtue of being human.

concepts2-known-pileup-regions

You can color code these rows in your spreadsheet so you will notice them.  If you do, be sure to use a color that you’re not using for something else.

I have used several sources for this information, including the ISOGG wiki phasing page and Sue Griffith’s great Genealogy Junkie blog article titled Chromosome Maps Showing Centromeres, Excess IBD Regions and HLA Region. The HLA region on chromosome 6 is the most pronounced. Tim Janzen states that he has seen as many as 2000 SNP segments in this region that are identical by population, or at least they do not appear to be identical by descent, meaning he cannot find the common ancestor. His personal HLA region boundaries are a bit larger too, from 25,000,000 to 35,000,000. Regardless of the exact boundaries that you use, be aware of this very “matchy” region when you are evaluating your matches.  This is exactly why you’re entering these into your DNA Master spreadsheet – so you don’t have to “remember.”.

By the way, Family Tree DNA and GedMatch use Build 36, but eventually they will move to Build 37 of the human genome, so you might as well enter this information now so it will be there when you need it. If your next question is about how that transition will be handled, the answer is that I don’t know, and we will deal with it at that time.

I do not enter the SNP poor regions, because Family Tree DNA does not utilize those regions at all, and they are the greyed out regions of your chromosome map, shown below.

concepts2-snp-poor-regions

On my own spreadsheet, I have a few other things too.

I have indicated chromosomal regions where I carry minority ancestry.  For both my mother and me, chromosome 2 has significant Native admixture.  This Native heritage is also confirmed by mitochondrial and Y DNA tests on relevant family members.

concepts2-native-segments

If you carry any Native American or other minority admixture, where minority is defined as not your majority ethnicity, as determined by any of the testing companies, you can utilize GedMatch ethnicity tools to isolate the segments where your specific admixture occurs. I described how to do this here as part of The Autosomal Me series. I would suggest that you use multiple tools and look for areas that consistently show with that same minority admixture in all or at least most of the tools. Note that some tools are focused towards a specific ethnicity and omit others, so avoid those tools if the ethnicity you seek is not in line with the goals of that specific tool.

Ok, now that our housekeeping is done, we can have fun.

Adding Phased Family Finder Matches to your Spreadsheet

I love the new Family Tree DNA phased Family Finder matches that assign maternal or paternal “sides” to matches based on your matches to either a parent or close relative. If you would like a refresher on parental phasing, click here.

We’re going to utilize that Match spreadsheet you just downloaded once again.

In this case, we’re going to do something a bit different.

This time, we’re going to sort by the last column, “Matching Bucket.” (Please note you can enlarge any image by clicking or double clicking on it.)

concepts2-match-bucket

When you’re done sorting the “Matching Bucket” column , you will have four groups of matches, as follows:

  • Both
  • Maternal
  • N/A
  • Paternal

I delete the N/A rows, which means “not applicable” – in other words, the match did not meet the criterial to be assigned to a “side.” You can read about the criteria for phased Family Finder matches here and here. If you don’t want to delete these rows, you can just ignore them.

The next thing I do is to add a column before the first column on the spreadsheet, so before “Full Name.”

In this case, you can highlight either the entire column or just the column heading, and right click to insert an entire column to the left.

concepts2-insert-column

If these are your matches, add your name in the “Who” column. If these are your parents’ or full siblings’ matches, add their names in this column. When you have a combined spreadsheet, it’s critical to know whose matches are whose.

Then select colors for the maternal, paternal and both buckets, and color the rows on your spreadsheet accordingly.

I use pink and blue, appropriately, but not exactly the same pink and blue I use for the mother and father spreadsheet rows in my DNA Master spreadsheet. I used a slightly darker pink and slightly darker blue so I can see the difference at a glance. The yellow, or gold in this case, indicates a match to both sides.

concepts2-bucket-colors

You’re only going to actually utilize the first two columns of information.

Highlight and copy the first two columns, without the header, as shown below.

concepts2-bucket-columns

Then open your master spreadsheet and paste this information at the very bottom of your spreadsheet in the first two columns.

concepts2-bucket-paste

After the paste, your spreadsheet will look like this.

concepts2-bucket-rows

Next, sort your spreadsheet by match name, this case, RVH is the match (white row).

concepts2-bucket-match-sort

Be still my heart. Look what happens. By color, you can see who matches you on which sides, for those who are assigned to parental buckets.  Now my white RVH match row is accompanied by a gold row as well telling me that RVH matches me on both my maternal and paternal sides.

Let’s look at another example. In the case of Cheryl, she is my mother’s first cousin. Since I have combined both my mother’s and my spreadsheets, you can see that Cheryl matches both me and my mother on chromosome 19 and 20 below. Mother’s match rows are pink and my rows are white.

concepts2-bucket-match-maternal

In this example, you can see that indeed, Cheryl is assigned on my maternal side by Family Tree DNA, based on the dark pink match row that we just added. Indeed, by looking at the spreadsheet itself, you can confirm that Cheryl is a match on my mother’s side. I am only showing chromosome 19 and 20 as examples, but we match on several different locations.

I don’t have as many paternal side matches, because my father is not in the system, but I do have several cousins to phase against.

concepts2-bucket-match-paternal

Here’s my cousin, Buster, assigned paternally, which is accurate. In Buster’s case, I already have him assigned on my Dad’s side, but if I hadn’t already made this assignment, I could make that with confidence now, based on Family Tree DNA’s assignment.  The blessing here is that the usefulness of Buster’s assignment paternally doesn’t end there, but his results, and mine, together will be used to assign other matches to buckets as well.  Cousin matching is the gift that keeps on giving.

Because my DNA Master spreadsheet includes my mother’s information as well, we need to add her phased Family Finder matches too.

Mother’s Family Finder Matches

Because I have my mother’s and my results combined into one DNA Master spreadsheet, I repeat the same process for my mother, except I type her name in the first column I added with the title of “Who.”

concepts2-mother

Continue with the same “Adding Phased Family Finder Matches” instructions above, and when you are finished, you will have a Master DNA Spreadsheet that includes your information, your parent’s information, and anyone who is phased for either of you maternally, paternally or to both sides will be noted in your spreadsheet by match and color coded as well.

Let’s take a look at cousin Cheryl’s matches to both mother and I on our spreadsheet now with our maternal and paternal buckets assigned.

concepts2-cheryl-to-mother

As you can see, my results are the white row, and my Family Finder phased matches indicate that Cheryl is a match on my mother’s side, which is accurate.

Looking at my mother, Barbara’s matches, the pink rows, and then at Barbara’s Family Finder phased match information, it shows us that Cheryl matches mother on the blue, or paternal side, which is also accurate, per the pedigree chart below.

Margaret Lentz chart

You can see that Barbara and Cheryl are in the same generation, first cousins, and Barbara matches Cheryl on her paternal line which is reflected in the Family Finder bucketing.

I have updated the “Side” column to reflect the Family Finder bucketing information, although in this case, I already had the sides assigned based on previous family knowledge.

concepts2-bucket-matching-blended

In this example of viewing my mother and my combined spreadsheet matches, you are seeing the following information:

  • Cheryl matches me – white rows
  • Cheryl matches me on my maternal side – dark pink row imported from Match spreadsheet
  • Cheryl matches mother (Barbara) – light pink rows
  • Cheryl matches mother on her father’s side – blue row imported from Match spreadsheet

I find this combined spreadsheet with the color coding very visual and easy to follow.  Better yet, when other people match mother, Cheryl and I on this same segment, they fall right into this grouping on my DNA Master spreadsheet, so the relationship is impossible to miss.  That’s the beauty of a combined spreadsheet.

You can do a combined spreadsheet with individuals whose DNA is “yours” and they don’t share DNA with anyone that you don’t. Those individuals would be:

  • Either or both parents
  • Grandparents
  • Aunts and Uncles
  • Full siblings
  • Great-aunts and great-uncles

Why not half siblings or half aunts-uncles? Those people have DNA from someone who is not your ancestor. In other words, your half siblings have the DNA from only one of your parents, and you don’t want their matches from their other parent in your spreadsheet. You only want matches that positively descend from your ancestors.

While your grandparents, great-aunts, great-uncles, parents, aunts and uncles will have matches that you don’t, those matches may be critically important to you, because they have DNA from your ancestors that you didn’t inherit. So your combined DNA Master spreadsheet represents your DNA and the DNA of your ancestors found in your relatives who descend directly ONLY from your ancestors. Those relatives have DNA from your ancestors that has washed out by the time it gets to you.

Why can’t your cousins be included in your DNA Master spreadsheet?

I want you to take a minute and think about the answer to this question.

Thinking…..thinking….thinking…. (can you hear the Jeopardy music?)

And the answer is….

If you answered, “Because my aunt or uncle married someone with whom they had children, so my cousins have DNA that is not from an ancestor of mine,” you would be exactly right!!!

The great news is that between a combined spreadsheet and the new Family Finder bucketed matches, you can determine a huge amount about your matches.

After discovering which matches are bucketed, you can then use the other tools at Family Tree DNA, like “in common with” to see who else matches you and your match. The difference between bucketing and ICW is that bucketing means that you match that person (and one of your proven relatives who has DNA tested) on the same segment(s) above the 9cM bucketing threshold.  You can still match on the same segments, but not be reported as a bucketed match because the segments fall below the threshold.  “In common with” means that you both match someone else, but not necessarily on the same segments.

Here’s a nice article about utilizing the 9 tools provided by Family Tree DNA for autosomal matching.

The Beauty of the Beast

The absolutely wonderful aspect of phased Family Finder Matching is that while you do need to know some third cousins or closer, and the more the better, who have DNA tested, you do NOT need access to their family information, their tree or the DNA of your matches. If your matches provide that information, that’s wonderful, but your DNA plus that of your known relatives linked to your tree is doing the heavy lifting for you.

How well does this really work? Let’s take a look and see.

On the chart below, I’ve “bucketed” my information (pardon the pun.) Keep in mind that I do have my mother’s autosomal DNA, but not my fathers. His side is represented by 8 more distant relatives, the closest of which are my half-sister’s granddaughter and my father’s brother’s granddaughter – both of which are the genetic equivalent of 1st cousins once removed. My mother’s side is represented by mother and two first cousins.

Total Matches Maternal Side Bucket Paternal Side Bucket Both Sides Bucket Percent Assigned
Mother 865 13 106 2 14
Me 1585 356 361 3 23

Mother has the above 106 paternal bucketed matches without me doing anything at all except linking the DNA tests of mother to her two first cousins in her tree.  In my case, the combination of mother’s DNA and her two first cousins generated 356 maternal side bucketed matches, just by linking mother and her two first cousins to my tree.

concepts2-tree

Mother does have one third cousin on her mother’s side who generated 13 maternal bucketed matches.  So, while third cousins are distant, they can be very useful in terms of bucketed “sides” to matches.

It’s ironic that even though I have my mother’s DNA tested, I have slightly more paternal matches, without my father, than maternal matches, with my mother. Of course, in my case, that is at least partly a result of the fact that my mother has so many fewer matches herself due to her very recent old world heritage on several lines. Don’t think though, for one minute, that you have to have parents or siblings tested for Family Finder bucketed matching to be useful. You don’t. Even second and third cousins are useful and generate bucketed maternal and paternal matches. My 361 paternal matches, all generated from 8 cousins, are testimony to that fact.

The very best thing you can do for yourself is to test the following relatives that will be used to assign your resulting matches with other people to maternal and paternal sides.

  • Your parents
  • If your parents are not both available, all of your full and half siblings
  • Your grandparents
  • Your aunts and uncles
  • Your great-aunts and great-uncles
  • All first, second and third cousins unless they are children of aunts and uncles who have already tested

The new permanent price of $79 for the Family Finder test will hopefully encourage people to test as many family members as they can find! For autosomal genetic genealogy, it’s absolutely the best gift you can give yourself – after testing yourself of course.

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Concepts – Sorting Spreadsheets for Autosomal DNA

This article covers both sorting in Excel and how to identify an overlapping segment, and what that means to you as a genetic genealogist.

I swore I wasn’t going to teach Excel, but there have been so many questions about sorting Excel spreadsheets that I am going to a very basic “how to sort and not hurt yourself” article. This does NOT replace actually understanding how to use Excel, but it will at least get you through the knothole of sorting for genetic genealogy.

I wrote more about sorting and filtering in the concepts article about assigning parental sides.

There are some advanced ways to accomplish the same thing, and I’m not discussing those. If you already know how to use Excel those are fine, but this article provides the basics for those who don’t.

Sorting

I am going to use, as an example, my matches to only a few people which gives us enough information to sort, but isn’t overwhelming.

When you download your results from Family Tree DNA, your spreadsheet will be in match name order, like the spreadsheet below.

SS Raw

I want you to notice that while the primary order is by match, there is a secondary order too (chromosome), and a third (start location) and fourth (end location) as well.

Within each match, the order is by chromosome, and then by start and end location.

What this means that you can look at Alice and see that chromosome 1 is first, and that the lowest value start location is shown first within chromosome order.

That’s not the order you’ll likely be working with all the time, so let’s take a look at how to sort the spreadsheet in a different way.

The row highlighted in red contain column headers.

SS column headers

When you sort an individual column you will select the header for that column, shown below, if you’re going to sort the Matching SNPs column.

SS Column select

The cell on your spreadsheet won’t be red, but I’ve colored it red here so you can see that I’m selecting this column header and only this column header.

When you select a column header, you put the cursor on that cell and click once.

SS column select 2

The cell you’ve selected will be bordered in black.  A screen shot of my spreadsheet is shown above.

I want you to watch what happens to these two rows colored green when I sort in Matching SNP order.

SS rows green

At this point, you will click on the sort and filter button on the upper right hand side of the toolbar.

SS sort dropdown

Here’s a closeup.

SS sort dropdown closeup

Selecting the “Sort A to Z” option sorts the contents of the entire spreadsheet in Matching SNP order, smallest to largest, because that’s the column header and sort option combination you selected. I use lowest to highest (A-Z) but you can also sort in reverse order, highest to lowest (Z-A) but that isn’t terribly useful for what we will be doing.

SS SNP column sorted

Notice that all of the rows are sorted into smallest to larger order by the Matching SNP column. So while the two green rows were originally together, now the rows all appear in order by the Matching SNPs column values.

The first green row match to Alice on chromosome 3 with 1300 cMs falls between the SNP value of 850 and 1458.  The second green row with a value of 2000 falls between 1638 and 2355.  This is exactly as it should be.  The contents of the entire spreadsheet are sorted by the values in the Matching SNPs column.

The statement “sorts the contents of the entire spreadsheet” is very important, because if you perform this task incorrectly, you will bollux up your entire spreadsheet, as in irrecoverably and forever.  What follows is an example of what NOT TO DO.

DO NOT DO THIS

DO NOT, and I repeat, DO NOT select the entire column to sort.

SS - Do Not Sort

This is an example of WHAT NOT TO DO.

If you select the entire column, as shown above, then sort, here’s what happens.

SS example bad sort

Notice that the green rows are now split apart – in other words they no longer form a row from left to right. That means that ONLY the data in the Matching cM column was sorted, but not rest of the data which is still in the same location on the spreadsheet as it was before the sort. Therefore, Alice’s green row Matching cM value of 1300 is no longer with Alice, since only the data in the Matching SNPs column was sorted. Now Alice’s 1300 cMs connected to Stacy’s red row on chromosome 4. Alice now has 500 SNPs instead, which as you can see, clearly isn’t accurate.

This is what I meant by selecting the entire column instead of just the header will forever ruin your data. If you do this, there is no recovery, unless you JUST did it, SS undo
realize the error, and can selecte the blue backarrow on the top of the toolbar on the left to “undo” your action. If you’re beyond that, the only recovery is to download your data again, or move to a backup if you have one.

What’s even worse if you do this and don’t realize it, so you’re working with incorrect data trying to find overlapping segments.  Of course, everything will be wrong.  I periodically do a sanity check and look at a couple people in the chromosome browser just to make sure that everything is as it should be on my spreadsheet and I haven’t done something like this.

To Sort Correctly – DO This

To use this spreadsheet effectively for genetic genealogy, we need the spreadsheet to be sorted in this viewing order:

  • Chromosome number
  • Start location
  • End location

In other words, we need the spreadsheet to look like this with all of the green cells remaining in their row with their match:

SS example good sort

You’ll notice that all matches on each chromosome are grouped together, with the smallest start location first, as illustrated by the red groupings of chromsomes 1 and 6. I do realize these are small segments, but the process is the same for large or small segments, so for our sorting example, just ignore any genealogical relevance associated with segment size.

You will be looking for overlapping segments. Notice that you have to be cognizatnt of the end location. In the case of chromsome 1, above, there are no overlapping segments for the two chromsome one matches, so they can’t match each other on this segment.

However, on chromsome 6, we have a different situation. Stacy’s segment match with me is quite long, 104cM. Stacy’s segment overlaps with everyone else’s on chromsone 6 that matches to me, either fully or part way. She matches Alice on all of the segments fully except for the last one. Stacy’s match to me ends at 108,000,000. Alice’s last segment matches to me from 107,779,220 which is included in Stacy’s match, but Alice’s match extends beyond Stacys, to 110,175,307.

Keep in mind that we don’t know at this point whether or not Stacy and Alice are from my mother or father’s side, based on matching. In other words, to draw any conclusions, we also have to know if Stacy and Alice match each other on this segment which we can’t tell from this spreadsheet.

Because I have access to Stacy’s account, I can indeed tell you that Stacy and Alice do not match each other on this segment, so they would be from different sides of my family tree. Stacy is a known relative from my father’s side and Alice does match my mother as well, so we now know that Stacy and Alice don’t match each other.

If you don’t have access to the accounts to see if your matches match each other, two tools at Family Tree DNA are partial substitutes.

  • The ICW tool tells you if two of your matches match each other, just not on which segments.
  • The maternal/paternal Family Matching tool, if you have connected the DNA of relatives who have tested, tell you which side your matches are from, maternal or paternal.

You can read about how to use those tools here.

If there are multiple matches with the smallest start location then they will be in order by the smallest end location first, shown in the yellow cells.

Sort Order

The sort order is exactly the opposite of the viewing order. If you want to SEE the data in this order:

  • Chromosome
  • Start
  • End

Then you must sort in this order:

  • End
  • Start
  • Chromosome

The last column you sort will be the primary viewing order.

Let’s look at our spreadsheet utilizing these three steps, in order.

Step 1 – First Sort

Selecting End Location to sort:

SS sort end location

After sorting by end location, below.

SS end location sorted

You will notice that all of the data is now in order by the values in the End Location column – smallest at the top, largest at the bottom.

The data in the other columns is not in any particular order at all.

Step 2 – Second Sort

Now selecting Start Location to sort that column in order, shown below.

SS sort by start location

Having sorted by Start Location, below:

SS sorted by start location

You will notice that now all of the data is sorted by start location. In the case where there is a common start location between two rows, highlighted in red, the end row with the lower end location will show first, noted in yellow, because you sorted first by end location in smallest to largest order.

Step 3 – Third Sort

Last, you’ll select the Chromosome column header to sort in chromosome order.

Sort by chromosome

Below, the result of sorting the third time in chromsome order.  After sorting, I bordered all segments on the same chromosome.

Sorted by chromosome

You can see that the entire spreadsheet is grouped by chromsome, and within chromsome number, the Start Location is grouped smallest to largest. If there are multiple people with the same start location, then the End Location comes into play, with the smallest end location listed first, as shown in the red and yellow rows.

If you want to sort your spreadsheet in another order for some reason, you can do so using the same methodology. Once you understand about sorting spreadsheets, you understand about sorting all spreadsheets.

Now, you’re ready to look for your overlapping segments.

What is an Overlap?

An overlap is two segments of your matches that are partially or completely overlapping each other.  When you have overlapping segments, assuming they are of decent size, that indicates that the two people who match you on your spreadsheet potentially match each other too.  Remember, there are three matching possibilities:

  • Your matches will either match each other, in addition to you, because you and both of them share a common ancestor or…
  • They both match you, but they won’t match each other because one is from your mother’s side and one is from your father’s side or…
  • One or both are identical by chance.  In you need a refresher on what identical by chance, descent and population mean, click here.

Ss no overlap

In this first example, above, there is no overlap between these two people on chromosome 17.  One begins at 31,000,000 and ends at 36,000,000 while the second person’s match with you doesn’t begin until 40,000,000, which is clearly beyond the end of 36,000,000, so there is no possibility of overlaps between these two individuals.  In other words, they cannot match each other on these segments.  However, clearly they both match you because they are both on your matching spreadsheet.

SS overlap 1

In the example above, the overlapping portion of the segment is from 38,000,000 – 40,000,000.  The second person’s match with you extends to 53,000,000, but the area between 40,000,000 and 53,000,000 does not overlap.

SS overlap 2

In the example above, the start number is lower for the top row than the second row, so the overlapping area is still from 38,000,000 – 40,000,000, because the matches don’t match from 36,000,000 to 38,000,000.

SS overlap 3

Occasionally, you have an overlap that is fairly miniscule, which I generally ignore unless they are in a group that has a larger overlap that overlaps or covers both smaller matches, as in the example above. You can see that our red and yellow rows have a very small overlap from 39,500,000 – 40,000,000. However, the top row includes the entire areas of both red and yellow rows, reaching from 33,000,000 to 55,000,000 which begins before either red/yellow row and ends after both red/yellow rows.  So either all 3 individuals will match each other, indicating a common ancestor, or the top row will match one of the red/yellow rows and not the other.

Combining Spreadsheets From Different Sources

The good news is that you can download your matches into a spreadsheet format from  23andMe, Family Tree DNA and GedMatch, but you do need to understand something about the basics of sorting and how to stay out of spreadsheet trouble. I am careful about combining spreadsheets sources for a couple of reasons.

  • First, the formatting is not exactly the same, so you may need to move columns to be in the correct order for your spreadsheet before actually combining them.
  • Second, there may be overlapping people between 23andMe, Family Tree DNA and GedMatch. You’ll need to figure out how you want to deal with that, especially on an ongoing basis when you need to add to or update your spreadsheet without overwriting or eliminating your matching work and notes relative to common ancestors and ancestral lines in the columns you’ll be adding.

I always make a backup file with a date name in the file name before doing combinations, and sometimes before sorting as well.

Learning Excel

If you want to learn more about how to use Excel, here are some additional resources to utilize.

I found some training videos for Excel including “Twenty with Tessa, Tips and Suggestions for Spreadsheets” which is focused on using spreadsheets with one name studies and genetic genealogy, but the principles are the same.  https://www.youtube.com/watch?v=Ll_cfhOZTl0&feature=youtu.be

When discussing this online, one person mentioned that they joined www.lynda.com and took the basic Excel class which she found very useful.

Kitty Cooper has instructions on her blog for how to make a matches spreadsheet as well.

www.DNAadoption.com has some good courses.  Their DNA for beginners covers using spreadsheets and is not just for adoptees!

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Concepts – Match Groups and Triangulation

Today, we’re going to talk about the concepts of autosomal DNA and the differences between:

  • Match groups
  • Mathematical triangulation
  • Genealogical triangulation

Match Groups

At Family Tree DNA, when you download your chromosome matching results, meaning your complete spreadsheet, then sorting into chromosome order (sort by column, end location, start location, then chromosome) your spreadsheet will look like this.

MG1

Of course, your spreadsheet will be a lot longer and will continue with additional matches on chromosome 1, then chromosome 2, etc.

In the example above, we see that this is just one match group, meaning that the segments for all individuals overlap, which indicates that they match me. In fact, I copied the first match group on my spreadsheet to use in this example.

A match group is a group of people that match YOU on the same segment of your chromosome.  You will have many match groups.

Each of these people matches me on chromosome 1 beginning at location 72,017 for some distance. The shortest match is Calvin and he matches on only 3.47 cM, which tells me that I have other matches with Calvin, because this segment is too short to have made it over the match threshold by itself. So I know this is just one of at least two segment matches to Calvin.

I don’t know Calvin, so I don’t know which side of my tree Calvin falls on or how we are related.

The next several matches’ segments are about the same size, 11 or 12 cM, with the final segment being significantly larger, 26.82 cM. If you need a refresher, I wrote a concepts article about centiMorgans and SNPs.

There are two really important things to remember about match groups.

  1. Match groups means that the people who are on this list match YOU. It does NOT means that these people match each other. In fact, if you recall, you have two sides to each chromosome, one from Dad and one from Mom, so it’s very likely that you have matches from Mom and matches from Dad, intermixed, in this and every match group. Without additional information, you have no way to discern who matches you on which side.
  2. Do not be deceived by thinking that the beginning or ending location, or both, is indicative of matching on one side or the other, or that the people who share beginning and/or ending locations match each other too. If I were to fall into this trap, I would PRESUME (and that’s a very dangerous word in DNA matching) that Cheryl through Rutha, inclusive, match each other and are from the same parental side – and I will tell you right now – they aren’t. So just don’t go there because it will trip you up sure as shootin’.

So, the people in a match group match YOU. Don’t read anything more into these matches at this point.

However, let’s move on to mathematical triangulation because there’s more that we can discover.

Mathematical Triangulation

I’ve gone and snuck a new term in on you haven’t I – mathematical triangulation. Sorry folks.

We have talked about autosomal triangulation several times before. You can read about triangulation here.

In a nutshell, triangulation requires three things of all people in a triangulation group:

  • They all match you on the same segment (math), which you know because they are all on your match list
  • They all match each other on the same segment (math), which you may or may not be able to discern by utilizing various tools
  • They have a common ancestor or ancestral line (genealogy), which you may or may not be able to discern through traditional genealogy

Triangulation is two parts math and one part genealogy. Don’t let that math word frighten you, because the math isn’t the hard part as it can be done by sorting a spreadsheet or by vendor tools, but the genealogy has to be done by you.

Mathematical triangulation divides your matches into two groups, one from your mother’s side and one from your father’s side.

Let’s step through this process and see how it works.

On any group of people who match you on a particular segment of a chromosome, when you have enough people, your matches will form two groups, plus possibly an outlier or two.

Why?

Because you have matches from both your father’s side and your mother’s side, assuming enough people have tested.

Let’s look at an example.

If you have 3 matches, it’s possible that all 3 matches are from your mother’s side.  However, as more people test and match you, eventually, you will have two groups of people form, one from each parent’s sides.

How do you know who is in each group?

Good question – and this is what defines a triangulation group versus a match group.

In a triangulation group, all of the people in the group MUST ALSO MATCH EACH OTHER on the same segment.  Yes, I’m shouting because if you forget this, you’re toast!

How do you figure out if they match each other?

In my case, I have access to the kits of the people colored peach below, because I paid for their testing, or put another way, they tested to do me a favor.

MG2

The kit in blue is managed by a cousin with whom I have a many-years long relationship, so while I don’t have direct access to this kit, I do have a great working relationship with the person involved.

So, I can sign in and I can see who matches whom. If you don’t have access to any of the kits, you can look at the ICW (in common with) list, which tells you which of these people also match each other, but the ICW list does not tell you if they match on the same segments, just that they match.  It’s not triangulation, but it is information and if the entire group matches each other utilizing the ICW tool, that’s fairly indicative that you do indeed have a mathematical triangulation group – but it’s not 100%.  You can read about the ICW tool and how to use it in this Nine Autosomal Tools at Family Tree DNA article.

So, let’s see what the two groups look like after I see who matches whom by looking at each person’s matches on this segment of chromosome 1.

MG3

I was able to check each of Cheryl, Don and Rex’s kits and they all match each other along with Jim, so we know that all 4 of these people in the green group all match each other plus me.

I was able to check Lazarus’s kit directly and Amos’s kit through my cousin, and I was also to verify that they match each other and they both also match Rutha, so I know that this purple group all matches each other plus me.

So what happened to Calvin – the uncolored row in the middle?

First, I can’t check Calvin’s kit directly, but the fact that his segments do mathematically overlap BUT he doesn’t match all of the people in either group, in fact, he doesn’t match any of the people in either group whose kits I could check, tells me that his results are zigzagging back and forth between my mother’s and my father’s DNA, from side to side.  I also verified his non-matching status to my matches utilizing the ICW tool.

This is called an identical by chance match. In essence, Calvin doesn’t match either side so it’s what is known as a false positive match – looks to be real but isn’t upon further inspection.  Remember I said that your matches would form two groups that match each other – plus a few outlier?  Calvin is an outlier.

Now, we have all of our matches sorted into two groups, a mother’s group and a father’s group, plus one who doesn’t match either group. The question is which ancestors do these matches come from and which side is mother’s and which side is father’s.

Now it’s time to add the genealogy portion as the third piece of the triangulation pie.  Sometimes, when you don’t have the ability to do mathematical triangulation, per se, by comparing individual kits, you can achieve mathematical triangulation by utilizing genealogical triangulation – so these two actually go hand in hand.

While genealogical triangulation can achieve mathematical triangulation, by organizing people into matching sides, mathematical triangulation cannot replace genealogical triangulation.

But wait, there is actually a shortcut I can take, and it is a way to begin adding genealogy immediately and easily.

Genealogical Triangulation

There are multiple ways to perform the final step in triangulation which takes your matches from mathematically matched groups to genealogically triangulated groups with ancestors or ancestral lines assigned. In fact, sometimes the genealogy will actually be what helps you with the mathematical grouping if you don’t have access to kits to check who your matches match.

Genealogy Triangulation Method 1 – Adding a Parent or Parents

My mother has tested too. In my spreadsheet, I have added her matches into my master spreadsheet so I can easily see who matches both me and my mother. A match to both of us tells me immediately which side the match is on.

MG4

My mother’s matches are colored pink. You can see immediately that Mom and I both match Cheryl, Don, Rex and Jim, so those matches are assigned to my mother’s side.

Genealogical Triangulation Method 2 – Using Known Individuals and Identifying Common Ancestors or Ancestral Lines

As it turns out, I already know who Cheryl, Don and Rex are, so I know that they match on my mother’s side, even without my mother’s DNA test. Cheryl and Don are siblings who are my mother’s first cousins, and Rex is a second cousin. All of these people match both me and Mom on the same segments, which means that these matches come from my mother’s side.  It also means that I received this entire segment intact from my mother, without being divided.  Utilizing close relatives to sort matches into groups is exactly why we encourage everyone to test as many known relatives as you can convince to test, except children of relatives who have already tested, because their children only received a part of the parents’ DNA.

Furthermore, it also means that Jim, whose genealogy I don’t know, is from the same line because he matches Cheryl, Don, Rex and mother as well.

That does not means that Jim necessarily shares the same most recent common ancestors (MRCA) as Cheryl, Don, Rex and mother.

Even if I didn’t have my mother’s information, knowing her relationship to Cheryl, Don and Rex along with mathematical triangulation is enough to assign these relatives and people they all match to my mother’s side.  Even if I don’t have access to their accounts, I still know that they are closely related to my mother, there are multiple of them, and they all match me on the same segment, so I can group these people together, if nothing more.

Margaret Lentz chart

The common ancestors of Barbara (mother), Don and Cheryl are Evaline Miller and Hiram Ferverda.

The common ancestors of Barbara, Don, Cheryl and Rex are Margaret Lentz and John David Miller.

So while these individuals do share a common ancestor, and we can identify who it is, the most recent common ancestor is different between Rex and Cheryl, Don, and Barbara.

We don’t know who Jim is, but I can pretty much tell you that he isn’t a descendant of Evaline Miller and Hiram Ferverda, unless he is through an unknown child. I can be pretty certain that he’s not a direct descendant of Margaret Lentz and John David Miller either.

I can also tell you with equal conviction that he IS descended from either the Margaret Lentz or John David Miller line, because he matches all 4 cousins who descend from that couple – Cheryl, Don, Barbara and Rex – on the same reasonably large segment. So while we can’t identify his common ancestor with the group, at least not yet, we can say with certainly that he descends from either these common ancestors or an ancestor to these ancestors.

Now, if Jim also matched to William Lentz, above, which he doesn’t, but let’s say he did – we would then know which side of the Margaret Lentz and John David Miller line Jim represented. The Lentz line, of course.

This would also tell us that if Jim matched the Lentz line, that the DNA he shares with Barbara, Rex, Don and Cheryl was from Margaret Lentz, so descended from her parents, Jacob Lentz and Fredericka Reuhle. Of course, we don’t know that today – but all it takes is the right “new match” whose genealogy is proven and we can then attribute the individual segments to specific ancestors.

Let’s add mother’s lines into the mathematically matched chart.

MG5

As you can see, just as expected, Mom matches all of the same people that match each other, along with me, in the green match group, which is now a triangulation group because we know which side the match is on – Mom’s.

To add more definition to the triangulation group, we need genealogical information about the people in the group so that we know who their common ancestors are, or their common line. Fortunately, we have that.

You can also see that Mom matches Lisa as well, but neither Cheryl, Don, nor Rex match Lisa, so Lisa must be from Mom’s mother’s side AND I didn’t inherit that DNA from Mom because I don’t match Lisa either. That’s good information to know through deductive reasoning. It’s also possible of course that Lisa’s match to Mom is IBC, identical by chance, but at almost 14 cM, that’s rather unlikely.

I’ve updated the “side” column with what we’ve learned.

Lastly, given that I do know the genealogy of many of these people, I’ve added that information into additional columns on my spreadsheet, along with the fact that these segments do in fact triangulate. Please note that you can click to see a larger image.

MG6

Now, if you’ve just caught the words “these segments do in fact triangulate” and you’re about to ask if each matching segment needs to be triangulated individually – the answer would be yes. You may share multiple ancestors with someone, on both sides of your family. In fact, even worse you can share multiple ancestors on each side of your family. Endogamy will do that to you.

We’ll pause a minute here for the groaning to subside.

One last comment is that when I infer a side, like with Lisa who does not match on Mom’s father’s side on this segments, I don’t assign the side, I just make a note because we really CAN’T say that Lisa matches on my Mom’s mother’s side, because she might be a false positive match.

Also, in the case of Rutha, we know she descends from either one of these common ancestors or an ancestor of an ancestor, so I simply note the group she triangulates with for further reference.  That information about Rutha will come in useful when I work with other match groups that she is a member of – trying to make them into triangulation groups as well.

Genealogical Triangulation Method 3 – Phased Family Matches

You can also check for your phased Family Matches on your match page at Family Tree DNA to see if any of those individuals who match you on your spreadsheet are already assigned to the maternal or paternal sides based on phased matches with qualifying relatives. You can see on the page below that indeed, on my mother’s kit, Cheryl is assigned to her parental bucket, being her third closest match.

MG7

However, you CAN’T assume that because a match doesn’t have a maternal or paternal icon assigned that they aren’t descended from a particular side of your family.

Family Tree DNA only assigns high confidence phased matches so that you can depend on those results.

Remember, each segment needs to be individually triangulated, and the Family Matching algorithm that assigns maternal and paternal icons has a higher threshold and other internal requirements that may cause a parental icon NOT to be displayed when the match IS from that side of the family.  This is not a bug but a design element that assures that only highly confident matches are parentally assigned.

So you can use the parental icon as a great tool to assign a genealogical maternal or paternal side, but you still need to do due diligence in terms of working each segment to identify with whom it triangulates and the common ancestors.

Genealogical Triangulation Method 4 – Don’t Forget the X

While utilizing this trick won’t get you all the way to triangulation, it will help in several cases, at least by assigning parental “sides” to some matches – for males only.  Yes, ladies, I know, it’s not fair.

Because males inherit an X chromosome only from their mother, and a Y from their father, any match that is labeled as an X match:

  • Has to have come from a male’s maternal line if the segment is a valid match.
  • Has to have a segment on chromosomes 1-22 that is over the matching threshold for an X match to be reported.

Aside from that, the X is subject to the same segment size considerations of all other chromosomes and segments.

Any X match of a reasonable size, meaning one that is less likely to be identical by chance, had to have come from a male’s mother’s line – so a match to a male with a reasonably large X segment is an indication of a maternal line match for him, at least on that segment.  For two matching men, an X match has to be a maternal line match for both men.  However, keep in mind that I have seen X segments that match on completely different lines than autosomal matches.

When comparing the X chromosome, in non-endogamous populations, I would certainly note matches over 3cM. I would not assign a maternal “side” unless the match was 7cM or over and 500 SNPs or more.  Lastly, in endogamous populations, I would be even more restrictive in terms of assigning the segment as “real,” but I would make notes because it would help focus where I look.

MG8

As you can see, this gentleman only has 4 X matches, and two of those are quite small, One is near 5cM and one is near 7cM, but none of the 4 is compellingly large – meaning they could be identical by chance. I would make a note for the two larger matches by the names of the people he matches, but I would not assign any of the matches as maternal at this point with given the small segments.  When I make “side” assignments, I want them to be as strong as possible so I don’t have to second guess the assignment later.

I would also look at who else I match on the X on that segment and see if there is anything remarkable about common matches.  In males, if the X match is valid, it HAS to come from mother’s side, so if you see a small segment X match in someone you know is related on your father’s side, that’s an indication that the X match on that segment to that person is IBC or you also share a second ancestor on the maternal side.

Larger X matches are already mathematically triangulated for you, meaning, if you’re a male,  you know what side they come from.  There are no “2 sides” to this chromosome and all you need to add is genealogy.  Women, you still have two sides, because you inherited an X from both your mother and your father, so you are not mathematically triangulated.  Sorry ladies!

If you would like to read more about the X chromosome, inheritance patterns and matching, click here and here. Be sure to utilize the inheritance pattern genealogy charts.

Summary

See how easy and fun this is when you break it down into easy, logical steps.

Even if you can’t mathematically triangulate, if you can find multiple people in the match group that descend from the same known ancestors or ancestral line, you can form smaller groups with these individuals until you have the opportunity to create a larger mathematical match group.

It only takes three people to create a genealogical triangulation group, so long as they aren’t close relatives.  Siblings don’t count, for example, and neither do parents when counting to 3 in a triangulation group.

As long as you can identify who your DNA on a particular segment came from, you really don’t need to fit everyone on your match list into a triangulation group – so if you don’t have access to some accounts, it’s not the end of the world.  You can also use the ICW tool to determine who people match, in general, if not segment specific..

You’re only going to have two ancestral lines, a paternal line and a maternal line that is relevant to any match group – so once you know who those ancestors are, the rest of your matches HAVE to fall into one group or another, or are outliers.  So don’t obsess about not being able to fit everyone into a match group either mathematically or genealogically.  However, if you can find a genealogical connection, by all means do, because one of those matches may well be the person who isolates the DNA to either the male or female of the ancestral couple and allows you to go back another generation or two in time.

Don’t forget about utilizing your Family Matches with assigned paternal and maternal icons.  That’s a great new tool.

It’s fascinating to see which of our ancestors our DNA came from. Finding new cousins by utilizing DNA is exciting as well – and gives us new opportunities to establish family relationships and share research information – opportunities that never existed prior to DNA bringing us together and providing us with that all important introduction.

Have fun.

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Maria Margaretha Grubler (1748-1823), A Woman of Steel Resolve,52 Ancestors #129

Maria Margaretha Grubler or Gribler (present day spelling) was born on May 4th, 1748 and baptized the same day in Beutelsbach, Wurttemberg, Germany to Johann George Grubler and Katharina Nopp, both also of Beutelsbach. This family is indexed incorrectly at Ancestry, under the surname Brabler and a wide variety of other ways as well that don’t remotely resemble their actual surnames.

Maria margaretha Grubler

We don’t know much about Maria Margaretha’s youth, except that she was Lutheran much as everyone else in Beutelsbach, and she was an only child – a rare occurrence in a time when pregnancies routinely occurred every 18-24 months and there was little, if anything, one could do to prevent that aside from abstinence.

Like other German girls, she was likely called by her middle name, Margaretha – an enchanting and beautiful name.

Margaretha may have originally been a Scandinavian name, where it means pearl. It’s found in some format in almost all European languages.

Beutelsbach has provided an invaluable service to genealogists seeking their family by reassembling the historical families from church and other records and providing the information online, and for free.

Maria Margaretha Grubler history

These records allow us to search specifically at Ancestry in their Wurttemberg Germany, Lutheran Baptisms, Marriage and Burials, 1500-1985 (which includes Buetelsbach) records collection for events like baptisms, marriages, births of children and burials. In German families in the 1700s, these are the activities and events that defined your life, especially if you were a female.

Margaretha grew up in this small village of just a few hundred people not far from the Rems River, where the hillsides sloped upwards and were filled with grapevines and vineyards. Beutelsbach is dab smack in the middle of the German wine region and the countryside is dotted with small villages, either within sight of each other or nearly so – scattered just far enough apart to have their own church and for people to walk to the nearby vineyards to work daily. In German villages, people lived centrally and walked a mile or so to their fields, or the fields they rented or worked for the landowners, the gentry. In Beutelsbach, the people who owned the fields would have lived in the Manor House, up on the hillside, overlooking the village. You can see the manor house in the drawing below.  Today, the manor house is a hotel and conference center.  I’d love to visit!

Beutelsbach 1598

This beautiful view of Beutelsbach from 1598 was found in the forest register books created by Andreas Kieser. It probably didn’t look much different in 1748 when Maria Margaretha was born.

Beutelsbach and other nearly small villages have been joined together today administratively as the city of Weinstadt.

Margaretha’s father, Johann Georg Grubler, died on November 27, 1764 when he was 55 and she was 16 years old.  They buried him the next day.  This was probably Maria Margaretha’s first dealing with death up close and personal, as two of her grandparents died before she was born, one died a year after her birth and one when she was 4, so she never knew her grandparents – nor would she remember their funerals.

Grubler, Johann Georg 1764

Church records don’t reflect any additional children for Maria Margaretha’s parents, but it would be highly unusual for a couple in that time who clearly could have children to have only one child. However, information unearthed by my friendly German genealogist, Tom, indicates that Maria Margaretha’s mother didn’t marry until she was 37 years old, on October 26, 1745, had Maria Margaretha in May 1748, at age 40, and never conceived another child. Knowing this, the fact that Maria Margaretha had no siblings makes a lot more sense – but she was probably the only “only child” in the entire village!

Eight years after Margaretha’s father’s death, she married Jakob Lenz, a vinedresser, on November 3, 1772. Given that Jakob’s parents had also lived in Beutelsbach their entire lives, Jakob and Margaretha likely had known each other since they were small children playing in the sunshine. They were only 3 months apart in age and were 24 years old when they married.JakobLenzmarriage

The document above, from the Lutheran church in Beutelsbach shows their marriage record.  It says they were “married the 18th Sunday after Trinity and that Jacob Lenz was the legitimate unmarried son of the citizen and vinedresser, Jacob Lentz from here.  Maria Margaretha is the legitimate unmarried daughter of the late Johann George Grubler, citizen and vinedresser from here.”

So both of their fathers worked in those vineyards above Beutelsbach. Their fathers had probably known each other their entire lives as well.

While Margaretha’s father didn’t join them on their wedding day, he was nearby, most likely buried in the churchyard just outside. The cemetery beside the church was the burial site for the House of Wurttemberg until 1311 when the official burials took place in Stuttgart. Certainly the local people continued to use the church burial ground.

Jakob Lenz and Maria Margaretha Grubler had 9 children, their first child being born just days after their first wedding anniversary.

  • Katharina Barbara Lenz was born November 17, 1773 and died September 4, 1817 in Beutelsbach of epilepsy. She never married. This makes me wonder if she was epileptic for her entire life. I expect she lived with her parents. Perhaps it was a blessing that she died before they did.

Lenz, Katharina Barbara birth

Katharina Barbara’s birth and baptism records are shown above, and death entry in the church records, below.

Lenz, Katharina Barbara death

Katharina Barbara’s parents, now age 69 would have weeped beside their firstborn child’s grave. They buried their first child 44 years after she was born. They buried their second-born within weeks of his birth.

Lenz, Jakob 1775 birth

Jakob’s birth record above, and death entry in the church records, below.

Lenz, Jakob 1775 death

On a late summer’s day, holding their first-born daughter, now 22 months old and perhaps with epilepsy, they would have buried their son, not yet 6 weeks old. This was not a happy family portrait.

  • Maria Magdalena Lenz was born October 1, 1776 and died November 1, 1849 in Beutelsbach of weakness of old age. She too never married.

Lenz, Maria Magdalena birth

Maria Magdalena’s birth is recorded above, and her death in the church records, below.

Lenz, Maria Magdalena death

  • Johannes Lenz was born January 16, 1779 in Beutelsbach and died October 29, 1813 in Beutelsbach. He was single and the cause of death; stickfluss (bronchitis or pneumonia). Occupation not given. Tom indicates that the word gebrachi is used which means frail or infirm, so he may never have been well.

Lenz, Johannes birth

Johannes’ birth record is shown above, and his death entry in the church records, below.

Lenz, Johannes death

Lenz, Philip Jakob birth

Philipp Jakob’s birth is shown in the records above, and his death, below. He lived to be almost 8 years old, past the dangerous first year or two. His parents must have been devastated at his death. His death record doesn’t indicate a cause of death.

Lenz, Philipp Jakob death

Maria Margaretha’s mother, herself a widow, likely lived very close to Margaretha, if not with Margaretha and Jakob. On July 26, 1781, Margaretha’s mother died. Being an only child, Margaretha would have laid her mother to rest beside her father who died 17 years earlier.

Nopp, Katharina death

Given that Maria Margaretha had no siblings, her mother’s death would have been her last immediate family member to pass over. Siblings help to cushion the blow, but with no siblings, Margaretha may have truly felt orphaned at 33.

On the other hand, with 4 living children at home, including a 3 month old infant, Maria Margaretha would have been very busy. Perhaps that was a good thing because she did not have time to dwell upon her mother’s death. On the other hand, in a small village, every time she would have passed by the house where she was raised, she would clearly have remembered her parents. Every Sunday attending church, she would pass by her parents graves. Did that make Maria Margaretha feel comforted that they were close, or sad that they were so close, yet so far away?

Life moved on, and Maria Margaretha continued to have 4 more children.

  • Jakob Lenz was born March 15, 1783 and left to emigrate to America just before his 34th birthday. This is my ancestor whose story is absolutely incredible. So incredible, in fact, that we had to tell the story in two parts, plus a third for his wife, Johanna Friedericka Ruhle whom he married on May 25, 1808 in Beutelsbach. The church records tell us that Jakob left with his family to immigrate on February 12, 1817.
  • Katharina Margaretha Lenz was born November 2, 1785, died January 6, 1858 and married Johann Conrad Gos on April 21, 1807 in Beutelsbach.

Lenz, Katharina Margaretha birth

Katharina Margaretha Lenz’s birth is shown above and her death is shown in the church records below.

Lenz, Katharina Margaretha death

At Katharina Margaretha’s death on January 6, 1858, she is listed as daughter of Jakob Lenz, vinedresser and Maria Griblerin, the trailing “in” often added to maiden names of single women.  Griberlin, the way it’s written, indicates that Gribler was her mother’s maiden, not married, name. Katharina Margaretha is also noted as the wife of Joh. Conrad Gos, bricklayer assistant who emigrated. She died of weakness of old age.

Katharina Margaretha had 5 children. Her husband, Johann Conrad left for Russia in 1817 where he died before the 1823 birth of Katharina’s last child, Jakob Freidrich Gos in Beutelsbach. Jakob Freidrich’s birth record is shown below.

Gos, Jakob Freidrich birth

Jacob Freiderich died in the poorhouse of emaciation and “wasting” in 1857, according to the church record below, which according to Tom, means he had tuberculosis. His occupation was that of a hafner (potter). He died the year before his mother.

Lenz, Jakob Freidrich death

It was initially unclear to me whether Jakob Freidrich was the son of Johann Conrad Goss, perhaps home for a visit, or the son of a different father. However, Tom translated the original records and answered that question, although it’s not exactly forthright.

Jakob Freidrich Gos’s baptismal record states:

Child’s parents: Katharina Margaretha, the late Konrad Gos, citizen and brickmaker, from here surviving widow.

The father according to the record extracts, noch ………..16 January 1824.

According to Tom, Jakob Friedrich Gos was considered illegitimate. His birth entry indicates his father was deceased and his death entry call him Jakob Friedrich Lenz, not Gos.

This is highly suggestive that Katharina Margaretha, while either married or a widow, conceived Jakob Freidrich and perhaps the clergy didn’t quite know what to say. Maybe the village knew Konrad Gos was dead, but didn’t know exactly when he died – and Katherina Margaretha wasn’t telling. Maybe the presumption of illegitimacy was not enough to pronounce Jakob Freidrich illegitimate at his birth.

However, the recording clerk or minister when Jakob Freidrich died 33 years later seemed to have no problem making that distinction by reverting him to his mother’s maiden name and labeling him “spurious,” meaning illegitimate.

In Tom’s words, “his father is clearly a mystery. If the child’s father acknowledged the birth at the time of his baptism or even later (in writing or as an affirmation to the minister), then the child would be considered legitimate. This was not done in this case as far as I can determine.”

We’ll never know for sure, because Jakob Freidrich Gos or Lenz never married, so never had children, at least none that we know about. If he had produced sons, we would have the possibility of Y DNA testing to see if his sons’ direct male descendants match Gos men or men by some other surname. Katharina Margaretha’s secret, if in fact it was a secret at all, has already gone to the grave. In a small village, there may have been very few true secrets.

While Katharina Margaretha was probably a bit scandalous as a widow bearing a child, we always have to consider the possibility that the conception wasn’t consensual and she may not have been the merry widow at all, but a victim. That would also be one reason the father would never have acknowledged the child.

Jakob Freidrich may never have been healthy, and Katharina Margaretha was apparently left to raise him alone. There was no happy ending to this story.

  • Johanna was born June 22, 1788 (although the Beutelsbach history information says July 2) and died October 10, 1788 in Beutelsbach.

Lenz, Johanna birth

Johanna’s birth record is shown above, and her death entry in the church book, below. Her mother only got to love her, in this world anyway, for three and a half months.

Lenz, Johanna death

  • Christina born January 1, 1793, died “8-13” but no year given. The Beutelsbach history information says “probably 1793,” but as it turns out, this was incorrect.

Lenz, Christina birth

Tom found Christina’s actual death record, shown below, on August 13, 1872 in Beutelsbach of cholera nostras, an acute bacterial disease caused by drinking fecally contaminated water.

There were cholera epidemics in Germany in both 1871 and 1873. The 1873 episode was noted as the worst cholera epidemic Germany had ever suffered. No cholera was listed in Germany for 1872, although obviously it was still lurking and was found in both Russia and Hungary in 1872. It’s only 400 miles from Beutelsbach to the border with Hungary, so that’s about the distance from Raleigh, NC to Washington, DC, an easy half day drive today.

Lenz, Christina death

Of Maria Margaretha and Jakob’s nine children:

  • 3 children, 2 boys and 1 girl, died as children at 2 months, 3 months and 8 years of age
  • 2 died as adults, but before their parents, having never married
  • 2 married and had children
  • The son who had children immigrated to America in 1817
  • The husband of the daughter who had children left for Russia in 1817
  • 2 daughters lived to adulthood but never married
  • Only 4 children outlived their parents
  • There were no sons left in Germany to care for either their aging mother or unmarried sisters upon the parents’ deaths
  • Two of Maria Margaretha’s sons were named Jakob. A third was named Philipp Jakob and was probably called Jakob. No confusion there!

It’s not terribly unusual in German records to name a second child the name of a child that died, but I still find that custom a bit disconcerting. In my very 20th Century American way of thinking, each child needs their own name so that you can remember and honor them properly.  How do you differentiate the first child Jakob who died from the second child Jakob who lived?  There were a total of 5 Jakobs in this family; grandfather, father, son who died, son who lived, son Philipp Jakob who would have been called Jakob, who also died, but after the second Jakob was born.  In other words, for a few years, they had two sons who would have been called Jakob.

When you speak about Jakob Lenz, for example, do you speak about the one who was born and died at just over 6 weeks of age in 1775 as “the first Jakob,” His father might have been referred to that way, or even his grandfather who was also Johann Jakob Lenz. Or do you refer to that first child as “the dead baby Jakob,” or do you just never refer to that child that passed? Unlike stillborn children or those who died shortly after death, the first Jakob survived for more than 6 weeks. Not in this family, but I have seen even a third child given that same identical name if the second child died. In this case, I suspect they wanted to have a child named Jakob after his father, and grandfather.

It’s somehow ironic that of 9 births recorded in the church records, only two of Margaretha’s children would give her grandchildren. One of those, Jacob left in 1817 for America, taking his four living children of course, who would have been ages 11, 8, 3 and 6 months old. Maria Margaretha never knew the rest of his children, born in America, and youngest two born in Germany would not have remembered their grandmother.

In 1775, Maria Margaretha buried her second-born child at about 6 weeks of age, in 1781 she buried her mother, then in 1788, she buried a child three months old. The next year, in 1789, another child died just before their 8th birthday. That must have been particularly difficult, because after infancy, you feel somewhat safe that they will survive.

Other than friends and distant family who lived in the village, Maria Margaretha had a reprieve for a few years, but the family deaths began again in October 1813 when her adult son, born in 1779 died of pneumonia.

Maria Margaretha would have stood by the small grave of her grandchild, Johannes, when they buried him five months later, on March 9th, 1814, a baby of 2 years and 3 months old, nearly the same age as one of her own children when she buried them. Another child she loved and lost.

A third grandchild, Elizabeth Katharina Lenz, died on the ship en route to America. In many ways, when Maria Margaretha kissed and hugged her grandchildren goodbye for the last time in the winter of 1817, they would have been functionally dead to her, given that she would never see them again. But receiving the letter that told of Elizabeth’s death, at age 4 or so, would have been devastating news. Maria Margaretha thought she was sending Elizabeth off to a new, better, life, not to a watery grave.

After son Jakob left for America in the later winter or early spring of 1817, he became shipwrecked in Norway in the fall after nearly starving to death on the high seas, and was stranded in Bergen, Norway for nearly another year. Surely, if Jakob was able to get a letter to Germany, Margaretha would have known about his predicament and been worried sick. Jakob and family managed to get themselves on another ship a year later, only to nearly perish on that voyage as well, and then had to sell themselves into indentured servitude to pay for their second passage after arrival in America.

Maybe Margaretha didn’t know those details. Maybe she did, afterwards, and was simply glad they were alive. Where there is life, there is hope. There were other Beutelsbach residents on those ill-fated ships as well, so Margaretha wasn’t alone in her grief.

In September of 1817, while Jakob’s ship was floundering on the high seas, Maria Margaretha buried another child, Katharina Barbara, who died of epilepsy at age 44. I have read accounts of people who died of increasingly worsening epileptic seizures and the reports are horrific. A small part of their brain is destroyed with each seizure and the damage is cumulative over the years, until they are often childlike, then infantile, as adults, ravaged by seizures they dread, terribly, can often feel beginning, and can do nothing to control. Maria Margaretha, after caring for her firstborn for 44 years, may have thanked God for taking her “home” so that she didn’t have to worry about if and how Katharina Barbara would be cared for after Maria Margaretha herself passed over. Maria Margaretha must have been keenly aware of her own mortality.

If Maria Margaretha believed in literal “Heaven,” she would have taken comfort in knowing that she would see her child again, on the other side of the pearly gates and Katharina Barbara would be “whole” in Heaven. That is probably what Maria Margaretha wanted more desperately than anything else in her life. But it was not to be in this world.

I can only imagine the horror Maria Margaretha felt to see her child convulse for the first time, and the second, and the third…for 44 long years. Maria Margaretha obviously took very good care of Katharina Barbara or she would never have lived for those 44 years.

Maria Margaretha’s other child who married and gave her grandchildren, her and her mother’s namesake, Katharina Margaretha, married on April 21, 1807 to Johann Conrad Gos. Katharina Margaretha had children in 1808 and 1812, but then in 1814, the third child died 12 days after birth, just before Christmas, on December 19th. This was the second grandchild that Maria Margaretha buried in 1814 with three burials of children and grandchildren in just over a year.  I have a feeling there was no joy in that Christmas season.

A fourth grandchild was born to Katharina Margaretha in 1817, the same year that her husband immigrated to Russia, leaving Katharina Margaretha and the children behind. This is an odd situation. We don’t know if Katharina Margaretha refused to leave for Russia, so he went without her. We don’t know if she planned to join him later, then didn’t. Did her pregnancy interfere? Did he go for work and perish? Did he return to visit in 1822, hence the conception of Jakob Freidrich?

What we do know is that Katharina Margaretha had another son, Jakob Freidrich, on February 19, 1823, according to the church records, whose surname was Gos at his baptism. She is mentioned as a widow, although the baptism didn’t take place until 1824. However, Jakob Freidrich’s death record shows him as illegitimate and with the surname of Lenz.

On July 2, 1821, Maria Margaetha’s husband, Jakob Lenz died of a fever typically found in people with tuberculosis. In other words, she likely had to take care of Jakob for weeks or months before his death. Maria Margaretha would have been 73 years old, no spring chicken herself, that’s for sure. Perhaps her daughters who never married and lived at home helped their mother.

On July 5, 1823, Maria Margaretha died – two years and 3 days after her husband, Jakob.

Grubler, Maria Margaretha death

Her death record in the church book, above, translates as follows:

Page 25.
Entry 22.
Maria Margarethe Lentz,
Born here 4 May 1748
Evangelical
Parents: the late Johann Georg Grubler, citizen and vinedresser here and Katharina nee Nopp.
Wife of the late Jakob Lentz, citizen and vinedresser here.
Age: 75y2m
Cause of Death: Dropsy or Edema
Place and Time of Death: here, 5 July 1823 at 3 pm
Place and Date of Burial: here, 7 July 1823 at 10 am
Folio 421 (Family Register)
Ist hier geschult und aufgezogen worden. Has been schooled and raised here.

They even tell us what time she died and what time she was buried.  Gotta love those precise Germans.

Dropsy is an old term for edema, which means the collection of fluid in the cavities of the body. Often, this is a symptom of congestive heart failure. People with pulmonary edema often pass away of pneumonia. I hope she died quickly and in her sleep without suffering so that she could see her children, grandchildren, husband and parents once again.

Maria Margaretha’s son, Jakob, was in America. Her daughter Maria Magdalena never married and didn’t die until 1849, so she must have been living at home with her mother, as was her daughter Christina who died in 1872. Perhaps the third daughter, Katharine Margaretha, whose husband left in 1817 and subsequently died, lived in the family home as well, along with her children and infant son born February 19, 1823, just under 5 months before her mother would pass away.

I have to wonder, who took care of these 4 women after Jakob Lenz died in 1821, and the three adult daughters after Maria Margaretha died in 1823? How did they earn money to survive? Did they become charity cases? Their death records don’t mention the poor house.

I’m sure friends attended Maria Margaretha’s funeral, but only three children and four grandchildren stood by her grave. That a very, very low number for a woman born in the mid-1700s in Germany. Of course, Maria Margaretha buried 3 offspring as children, two as adults, waved goodbye to one who emigrated to America and cared for 2 daughters who never married and outlived her. That only leaves one child in Germany having children among 9 who were born.

Maria Margaretha’s DNA

As hard as it is to believe, given the children that Maria Margaretha had, there is only one daughter who had children, and of those children, only one granddaughter. The church records tell us that Friederika Gos was born on January 12, 1817 in Beutelsbach and the Beutelsbach records indicate that she died after 1842 in Steinreinach. We don’t know if she married.

If she married and had daughters, she would have passed Maria Margaretha’s mitochondrial DNA on to them. If that daughter has descendants today who descend from her through all daughters, they would carry Maria Margaretha’s mitochondrial DNA.

You can see how the different kinds of DNA are passed to offspring in this short article.

If one of those descendants, through all daughters, took the mitochondrial DNA test, we could discover additional history for Maria Margaretha Grubler Lenz.

Mitochondrial DNA is passed unmixed with the father’s DNA, so it reaches back in time relatively unchanged, except for an occasional mutation, and we can tell a great deal about population migration and where our ancestors came from. The story of our ancestors is written in our DNA, and the story of Maria Margaretha’s matrilineal ancestors is written in her mitochondrial DNA, if it still exists in descedants today.

If someone does descend from Maria Margaretha through all females to the current generation, which can be a male, I have a DNA testing scholarship available for that person.

I hope that the final chapter for Maria Margaretha has not been written.

In addition to mitochondrial DNA, current descendants could well carry part of Maria Margaretha’s autosomal DNA – passed to her from both of her parents and representing her ancestors, which of course, are our ancestors too.

It’s possible that if someone descended from Maria Margaretha through any child (not just females) would match other descendants today autosomally. I would be fourth cousins with someone in my same generation descended from Maria Margaretha’s daughter, Katherina Margaretha. Some people who are 4th cousins don’t carry any of the same autosomal DNA of their common ancestor, but some do.

I would be third cousins with anyone descended from Jacob Lentz, Maria Margaretha’s son, through a child other than Margaret Lentz (also my ancestor). Third cousins share more DNA than 4th cousins, and I do match two Lentz third cousins.

If anyone else descends from Maria Margaretha Grubler/Gribler or Jakob Lenz, or these lines from Beutelsbach, I’d love to make your acquaintance.

Summary

I’m sure there were moments of great joy in Maria Margaretha’s life. Some of those are recorded as her marriage, her children’s marriages and the births of her children in the church records. Other than that, we don’t know what was joyful in Maria Margaretha’s life and made her smile. What did she like to do? Her favorite food? I wish we knew.

Great griefs and sadness are recorded in those ancient church books as well – the saddest of days were when parents, your spouse and children passed to the other side.

Aside from what is recorded in the church records, we know that beginning in 1803, the Napoleonic Wars spread fear, turbulence and social strife throughout Europe.

In 1816, following the eruption of Mt. Tambora in 1815 in Indonesia, the atmosphere was so full of particulate matter that 1816 was known as “the year without a summer” when the weather was so cold that crops failed throughout Europe and America. Some people starved. Harvests failed, including grapes. Prices skyrocket and riots for food ensued. This was not a good time to be alive and it probably seemed like the Biblical end of the world. Maria Margaretha was taking care of an adult epileptic daughter who clearly would never be able to take care of herself. Maria Margaretha must have worried increasingly about her daughter as she herself aged. Providence would soon step in and take care of that question, but what a grief-filled solution. There was no good outcome possible – only bad and worse.

Life was difficult and sometimes devastating for the last 20 years or so of Maria Margaretha’s life. However, she persevered.

In my mind’s eye, I can see her marching forward, through whatever she had to march through, scratched up, bleeding, perhaps very thin, a tearstained face, but head held high and still marching forward through whatever adversity fate served up next. That is the picture I will always hold of Maria Margaretha Grubler, a woman of steel resolve.

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Concepts – Relationship Predictions

One of the ways people utilize autosomal DNA for genealogical matching is by looking for common segments of DNA that match with known, or unknown, relatives.  When the relationship to the person is unknown, we attempt to utilize how much DNA we share with that person as a predictor of how, or at what level, we’re related to them – so in essence where or how far back we might look in our tree for a common ancestor.

Until recently, the best estimate we had in terms of how much DNA someone of a particular relationship (like first cousin) could be expected to share both in terms of percentages and also cMs (centiMorgans) of DNA was the table on the ISOGG wiki page.  Often, these expected averages didn’t mesh well with what the community was seeing in reality.

Recently, Blaine Bettinger’s crowdsourced Shared cM Project reported the averages for each relationship level, plus the range represented from lowest to highest in a project where more than 10,000 people participated by providing match information.

Additionally, before publication, Blaine worked with a statistician to remove outliers in each category that might represent data entry errors, etc. Not only did Blaine write a nice blog article about this latest data release, he also wrote a corresponding paper that is downloadable that includes tables and histograms not in his blog.

I am constantly looking between the two sources, meaning the ISOGG table and Blaine’s paper, so as an effort in self-preservation, I combined the information I use routinely from the two tables – and did some analysis in the process.  Let’s take a look.

The Combined Expected cM and Actual Shared cM Chart

On the chart below, the two yellow headed columns are the Expected Shared cMs from the ISOGG table and Blaine’s Shared cM Average – which is the average amount of DNA that was actually found. These, along with the percent of shared DNA are the columns I use most often, followed by Blaine’s minimum and maximum which are the ranges of matching DNA found for each category.  As it turns out, the range is incredibly important – perhaps more important than the averages expected or reported – because the ranges are what we actually see in real life.

I’ve also included the number of respondents, because categories with a larger number of respondents are more likely to be more accurate than categories with only a few, like great-great-aunt/uncle with only 6.

It’s interesting that the greatest number of respondents fell into the aunts/uncles niece/nephew category with second cousins once removed a very close contender.

These were followed by the next closest categories being, in order; first cousins, second cousins, first cousins once removed, second cousins once removed and third cousins.

Note:  If you downloaded this chart on August 4, 2016, there was an error in the maximum number of first cousins trice removed.  On August 5, 2016, it was corrected to read 413.

Expected vs shared cM 4

You can see that in reality, all categories except two produced larger than the expected cM value. One category was equal and one was smaller (yes I checked to be sure I hadn’t transcribed incorrectly). Actual numbers with higher values are peach colored, lower is green and white is equal.

Most averages aren’t dramatically different for close relationships, but as you move further out, the difference in the averages is significantly greater.  Beginning with third cousins once removed, and every category below that in the chart, the actual average is more than twice that of the expected average.  In addition, the ranges for all categories are wider than expected, especially the further out you go in terms of relationships.

We often wonder why the relationship predictions, especially beyond first or second cousins vary so widely at the testing companies and GedMatch. In the chart above, you can see that beyond first cousins, the ranges begin to overlap.

Ranges of the same relationship degree should share the same percentages and theoretically, the same amounts of DNA, but they don’t. You can see that the cells marked in red are all 4th degree relatives.  However, half first cousins show a maximum of 580, with the two following rows showing 704 and 580 – all 4th degree relatives. There’s a pretty significant difference between 580 and 704.

Through 5th degree relatives, everyone matched at some level, meaning the minimum is above zero, but beginning with 6th degree relatives, row highlighted in yellow, some people did not match relatives at that level, meaning the minimum is zero.

In the last 4 rows on the chart, 15th, 16th and 17th degree relatives, marked with light aqua, where academically we “should” share 0% of our DNA, we see that the observed average is from 7 to 11 cM and the range is up to 29 cM.

An example of why predictions are so difficult is that if you are on the high end of the 4th cousins range, a 9th degree relative with 91 shared cMs of DNA, you are also right at the average between 6th and 7th degree relatives which fall into the half second cousin or third cousin range.

Without relationship knowledge, the vendor, based on averages, is going to call this relationship a 2nd or 3rd cousin, when in reality, it’s a 4th cousin. Most vendor relationship predictions are based on a combination of total shared cMs and longest block, but still, it’s easy to be outside the norm.  In other words, not only does one size not fit all, it probably doesn’t fit most.

Graphs

For me, graphs help make information understandable because I can see the visual comparison.

These overlapping ranges are much easier to visualize using charts.  Please note that you can click on any image for a larger view.

Expected full range 4

The values and ranges for 1st, 2nd and 3rd degree relatives are so much larger than more distant relatives, that you can’t effectively see the information for more distant relatives, so I’ve broken the charts apart, below.

Expected to third degree

This first chart, above, shows third degree relatives and closer.  Note that the purple maximum for aunts/uncles, nieces/nephews is larger than the minimum for full siblings and greater than the red average or blue expected for half-siblings.

expected 4th to 17th 4

This second chart shows the more distant relationships, meaning 4th degree through 17th degree relatives, but the more distant relationships are still difficult to see, so let’s switch to bar charts and smaller groups.

Expected stacked to third

This first bar chart includes parent/child through first cousins relationships, or 1st through 3rd degree relatives. You can see that the first cousin maximum range (purple) overlaps the aunt/uncle, grandparents and half-sibling minimum ranges (green.) Half sibling max and full sibling minimum are very close.

Expected 4th to 17th stacked 4

The balance of relationships are a bit small to view in one chart, but the ranges do overlap significantly.  Unfortunately, Excel does us the favor of skipping some labels on the left side of the chart.

Expected 4th to 17th no legend 4

Removing the legend helps a bit, but not much.  Please refer to the color legend in the same graph above.  I’ve further divided the groups below.

Expected 4th to 9th 4

The chart above shows 4th degree to 9th degree relatives, meaning great-great-aunts or uncles through 4th cousins.

expected 4th to 9th no legend 4

The same chart, above, with the legend removed to allow for more viewing space.  You’ll notice that at the half second cousins level, and more distant, the green minimum disappears, which means that some people have no matches, so the minimum cM shared is zero for some people with this relationship level.  However, based on the average and maximum, many people do share DNA with people at that relationship level.

Expected 7th to 17th 4

The chart above begins with 7th degree relatives, half second cousins, where you share less than 1% of your DNA.

In many cases, the purple maximum range for one relationship category overlaps Blaine’s average and the expected values for other categories.  For example, in the chart below, you can see that the maximum purple bar for the various 5th cousin ranges is higher than the third cousin, twice removed red shared cM average, and significantly higher than the blue expected shared cM value.  In fact, the 6th cousin purple max is nearly the same as the blue expected cM for third cousins once removed.  Note that Excel showed only every other category on the left hand axis, so you’ll need to refer to the actual data chart from time to time.

expected 7th to 17th no legend

I’ve removed the legend again so you can see the actual stacked ranges more clearly.  All of the 7th degree relatives have a minimum of zero, so there is no green bar.  Furthermore, at 5th cousins twice removed, the expected shared cMs drops to below 1, so the blue bar is nearly indistinguishable.

expected 9th to 17th

This last chart shows the smallest group, 9th through 17th degrees, or 4th through 8th cousins.

expected 9th to 17th no legend

On this final chart, we clearly see that Blaine’s actual red shared cMs and the purple maximum are significantly more pronounced than the blue expected shared cMs.  Some people share no DNA at this level, which is to be expected, but a non-trivial number of people share significantly more than is mathematically expected.  There are no absolutes.

Summary

DNA is not always inherited in the fashion or amount expected, and that wide variance is why we see what people believe are “false positive” relationship predictions. In reality, the best the vendors can do is to work with the averages.  This also explains why it’s so difficult for us to estimate or determine how a person might be connected based just on the relationship or generational prediction.  It’s just that, a prediction based on averages which may or may not reflect reality.

There’s a lot we don’t know yet about inheritance – why certain segments are passed on, often intact, sometimes for many generations, and some segments are not.  We don’t know how segments are “selected” for inheritance and we don’t yet know why some segments appear to be “sticky” meaning they show up more in descendants than other segments.

Close relationships are relatively easy, or easier, to predict, at least by relationship degree, but further distant ones are almost impossible to predict accurately based on either academic inheritance models or Blaine’s crowdsourced average cM information.

Here’s a clean copy of the combined chart for your use.

Note:  If you downloaded this chart on August 4, 2016, there was an error in the maximum number of first cousins trice removed.  On August 5, 2016, it was corrected to read 413.

Expected vs shared clean 4

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Additional Relatives Added to Phased Family Matches at Family Tree DNA

Family Tree DNA has been rolling out updates and upgrades fast and furious.

On July 7th, Family Tree DNA released Phased Family Matches which included phasing to people linked to your tree who have DNA tested who are related to you.  These phased matches allow Family Tree DNA to assign matches to maternal or paternal buckets, or both.  The people that could be utilized for this phased matching were as follows:

  • Parent(s)
  • Aunts
  • Uncles
  • First Cousins
  • Grandparents

Of course, because everyone wants the most people possible in their assigned parental buckets, the first clamor was for the addition of:

  • Half siblings
  • Half “other relatives” such as aunts, uncles, first cousins, etc.
  • Second Cousins
  • Third Cousins

Family Tree DNA said that there would be additional new developments shortly, and exactly 20 days later, they quietly rolled updated capabilities that includes matching to…..you guess it….all of the above, plus more, including:

  • Great-great-grandparents
  • Great-grandparents
  • Grand uncles
  • Grand aunts
  • Great-grandaunts
  • Great-granduncles

I’m certainly envious of anyone who can test their great-grandmother – although my grandchildren have their great-grandmother, grandmother and both parents in the system.

In my case, before this change, the only relative that I had in the system that originally qualified was my mother. I was very excited to have people in my maternal bucket and was wishing for people in my paternal bucket. I do have several cousins who have tested on my paternal side, but none as close as 1st cousins.

Imagine my delight when I signed on to my account and discovered 359 individuals in my paternal bucket and one in both, in addition to my 256 maternal phased matches.

Both Buckets

These 359 phased paternal matches come from the combination of the following 8 individuals that have tested and I had previouisly linked to me in my tree:

  • Half sister’s granddaughter
  • Two first cousins once removed
  • One first cousin twice removed
  • One second cousin
  • One second cousin once removed
  • Two third cousins

Of course, now I’m searching through my DNA matches to see if I have anyone else who qualifies that has tested.

And I’m thinking about any other cousins that would benefit my phased parental bucket assignments if I were to be able to convince them to test.

I unlinked and relinked a few people to see how many people were added to the buckets because of them.

The second cousin once removed added 12 new people. Yet, one of the third cousins added 82, so you really never know. Some of the people who might have been added to a bucket by the second cousin may have already been added to the parental bucket by an earlier match.

Regardless, the more people linked to your tree from third cousins closer, the better your chances for having people assigned to maternal and paternal sides of your tree, even without having your parents.

Keep linking people in your tree when you know where and how they connect to you – regardless of where they are located in your tree.  You never know how that may benefit you – which morning you may wake up and find additional information or more people in your buckets.  What a great surprise!!!

This is a pretty amazing feat if you think about it, given that just a few years ago autosomal testing wasn’t available at all, and even today, no other vendor does phased matching, assigning individuals to maternal or paternal buckets utilizing parents and other relatives when parents aren’t available.

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Catharina Schaeffer (c1775-c1826) and the Invisible Hand of Providence, 52 Ancestors #127

Catharina Schaeffer was born about 1774 to Johann Nicholas Schaeffer and Susanna DeTurk in Berks County, Pennsylvania. While many church records still exist and are available for the genealogist, it appears that none of Nicholas Schaeffer’s children are found in the existing records – at least none that I’ve been able to find.

Although we do have Catharina’s father’s estate documents, there is no final distribution that includes Catharina by her married name, nor a mention of her husband, Peter Gephart.  In fact, there is no final distribution in that estate packet at all.

Catharina didn’t marry until 1799, half way through the estate settlement, so it’s not like she is absent in something where she should be present. However, given this tiny shred of ambiguity, I was very pleased to have autosomal DNA matches to descendants of Catharina’s parents and Schaeffer grandparents through other children.

Catharina’s father, Johann Nicholas Schaeffer, died on November 2, 1796, according to his estate documents.

A petition filed on April 3, 1798 relative to real estate lists Nicholas’s children, as follows:

John Schaeffer, Esther wife of Jacob Miller, Catharine, Daniel, Susanna, Mary, Elizabeth and Jacob, the 4 last of whom are minors. Nicholas’s widow is noted as Susanna.

Catherine is the anglicized version of the German Catharina.  The one document where she signs her name with an X, her name is given as Catharina so that is the name I’m using.

The 1798 document from her father’s estate tells us that Catharina is at least 21 years old, meaning she was born before April 3, 1777. Furthermore, I suspect that these children are listed in age order, given that we know from other estate documents that John is the eldest (born on May 30, 1771) and we know from this document that the youngest are listed last.

If the children were born every 2 years, and none died, then the 4 youngest would have been roughly 19, 17, 15 and 13. By inference Daniel would have been 21 and Catherina 23.   So we can comfortably say that Catherina was born about 1775 and unquestionably between 1773 and 1777, even if the middle three children are listed out of order.

Initially, Susanna, Nicholas’s widow, is awarded executorship, but she petitions the court to find another executor, at which point Valentine Gephart/Gebhart is appointed.

Nicholas’ estate mentions several Gephart men both in the list of accounts and at the estate sale, so these families were closely affiliated and probably near neighbors.

Catharina Schaeffer married Johann Peter Gephart Jr., known as Peter, on March 24, 1799 in Christ Lutheran Church in Berks County, known today as Christ Evangelical Lutheran Church.

Catharina Schaeffer Christ Lutheran

The church, built in 1743, is still functioning today and this beautiful photo is from their Facebook page. I would like to think that Catherina’s memories of this church were glowing and beautiful, full of the freshness and hope of new love.  That chapter in her life wouldn’t last long.

Catharina Schaeffer Christ Lutheran2

Peter was born on June 10, 1771 and was the son of Johann Peter Gebhart and Eva, last name unknown.

On November 2, 1799, Catharina had daughter Elizabeth Gephart followed by son, John Gephart born on February 26, 1801.

It’s likely that Catherina had a child that was born and died in 1803, or perhaps the child didn’t die until 1804 sometime. It would be terribly unusual for a woman to not become pregnant at that age from 1802 through December 1804 without having a child in-between those dates. According to Peter’s estate papers and later guardianship records, there was no child born, that lived, after 1801. Neither was Catherina pregnant when Peter died in December 1804.

The Western Fever

According to research by Kierby Stetler and Gene Mozley:

In the year 1803, four men from Tulpehocken Twp., Berks County, went to Ohio to see the country and if they liked it, planned to buy some property and move their families onto it. They found some land they liked about 60 miles east of Cincinnati which was owned by a man in Virginia. They met with the owners’ agent in Ohio and contracted to purchase 1000 acres, then started for Virginia to close the deal with the owner. However, by the time they arrived at the man’s residence, he had died. Disappointed and exhausted from the trip, they returned to their homes in Berks County.

They gave such glowing accounts of the State of Ohio that the “western ern fever” became an epidemic in the neighborhood. As a result, 24 families decided to sell out and move to Ohio the following spring. A few in the meantime had moved to Center Co, PA but arrangements to join the group were made with them by letter. It was agreed that all would start as such a time as to meet in Pittsburgh on or about the same day. In this group from Berks County were our George Stettler, his children and grandchildren. George was nearly 65 years of age at this time.

The Stettler family would be Catharina and Peter Gephart’s neighbor to the south, in Montgomery County, Ohio.

In 1804, as one of the group of 24 families from Berks County, Catharina and Peter Gephart, along with their 2 young children joined the wagon train and made their way from Berks County, Pennsylvania to Montgomery County, Ohio.

Catharina Schaeffer Berks to Montgomery

The distance between Maiden Creek Township in Berks County and Miamisburg, in Montgomery County, near Peter Gephart’s land, is about 513 miles, which equated to about 51 days in a wagon. I would have been a long and tiresome journey, that’s for sure. However, there was a better route.  The History of German Township, Montgomery County, Ohio tells us more:

The following are the names of those heads of families who came to this valley from Pennsylvania in the 1804 colony, some of whom, however, settled outside the present limits of German Township: Philip Gunckel, Christopher, John and William Emerick (who were brothers), George Kiester, Jacob Bauer, George Moyer, John Gunckel (who subsequently returned to Pennsylvania), John and Christopher Shuppert. Peter Gebhart, George Stettler and his five sons, William, Henry, Daniel. George and Jacob, John Barlet, Abraham Puntius and George Kern (who came with them as far as Cincinnati, where he remained two years, coming to this township in 1806). There were twenty-four families of them when they started from Pennsylvania, but they did not all get to the Twin Valley. Some dropped off on their way hither and settled elsewhere, while others remained so short a time that they cannot be claimed as pioneers of this valley. The names of all such have been omitted.

We can see from the above list that the 24 dwindled to 19, and then to 18 when one family returned to Pennsylvania, then to 17 with the death of Peter Gephart. The following year, in 1805, another group arrived that included Valentine Gephart, among others.

There is actually a very important clue in the History of German Township information, and that is that George Kern came as far as Cincinnati. This tells us that these pioneers only came part way by wagon, likely as far as Pittsburg, where they purchased rafts and floated downriver to Cincinnati. Had they come overland, they would not have dropped south to Cincinnati, as it would have been out of the way.

From Cincinnati, they would have headed north to what is now Montgomery County.

It’s “only” 270 miles to Pittsburg, or 27 days in a wagon, from Berk’s County.

Catharina Schaeffer Berks to Pittsburgh

From Pittsburg, the caravan of German settlers would have floated down the Ohio from Pittsburg to Cincinnati on a flatboat.

flatboat

In Cincinnati they would have unloaded the flatboat and purchased or hired wagons once again in order to head for Montgomery County. It’s only 50 miles or so from Cincinnati to Miamisburg, in Miami Township, only a mile or so from where Catharina and Peter Gephart would settle, beside the Stettlers.

Catharina Schaeffer Cincy to Montgomery

This “Miami Township” article by Jacob Zimmer, probably written in the 1880s, given that John Gephart died in 1887, tells us more:

It was in the spring or summer of 1804, that John Shupert, wife and six children, Christopher, Frederick, Jacob, Eva, Peggy and Tena, came from Berks County, Penn., locating about one mile southwest of “Hole’s Station,” where he and wife lived until death. Christopher was married and had one son, John, when the family located here, the latter of whom is now residing in the township. In the same colony from Berks County, Penn., came Peter Gebhart, wife and two children, John and Elizabeth, settling a short distance southwest of the station, where Peter died the same year. His son, John, now a very old man, is still a resident of Miami Township. Most of this colony from Berks County settled in German Township.

Hole’s Station became Miamisburg in 1818.

Another account of the 1804 journey is given in the book “Twin Valley” b J. P. Hentz, published in 1883:

They set out on their westward journey in the spring of 1804. Such a journey was at that time no small undertaking. It required many weeks for its accomplishment and was attended by no small degree of danger and hardship. The goods, women and children had to be conveyed by wagon over rough mountain roads. The country through which the emigrants had to pass was yet but thinly settled; wild beasts such as wolves, bears and panthers were still abounding in the forests; and Indians, more savage than savage brutes, were still lurking in forest and mountain fastness. At night they usually encamped by some stream, and whilst one party laid down to sleep, another kept watch around the encampment. Exposure and malaria often caused serious illness, and not unfrequently one fell victim to disease and was buried by the wayside. Our friends, on their way through Pennsylvania experienced many of these evils; they arrived however, at the time agreed upon in Pittsburgh without having met with any serious accident. Here they engaged river boats, on which they put their chattels and families, and then paddled down the Ohio River. Cincinnati was their destination by water. After a trip of about a week they landed at the latter place. This event occurred on the 20th day of June, 1804. From Cincinnati they went to New Reading, a hamlet not far distant where they arrived a fortnight, considering what next to do or where to next to direct their steps. A few of them found employment here and remained, but to the majority this did not seem as their Canaan.

They again took up their line of march, this time their course lay northward. They had heard of the Miami Valley and desired to locate in it, but they had no definite objective point in view, trusting rather to fortune and the guiding hand of Providence. Some distance north of Cincinnati they entered this Valley and were delighted with the country. It was so very different from the rugged mountain country which they had left in Pennsylvania. No mountains and rocks were to be seen here. The forests were much taller, the soil was more productive and the surface much more level than in the country from which they came. They passed over many an attractive spot where they might have located, but they moved on, doubtlessly prompted and guided by the invisible hand of Providence, until they reached the vicinity of the present site of Miamisburg. Here lived a wealthy farmer, whose name was Nutz, who spoke German. They were glad to meet a gentleman who spoke their own tongue. With him they stopped to rest and refresh themselves and after forming his acquaintance and finding him a genial and kindhearted man, they concluded to encamp awhile on his farm. It was now midsummer and the weather being warm and pleasant, they took up abode in the woods where they lived in wagons and temporary huts, for about two weeks.

A Mr. Philip Gunckel, being a man of superior intelligence and the only person among them who spoke the English language with any degree of fluency was for these reasons looked upon as a leader of the group. He searched the area looking for a proper location to build a mill, as he was by occupation a miller, “and at last found the object of which he was in search on Big Twin Creek, a branch of the Miami River. The precise point chosen by Mr. Gunckel was about 6 miles from the mouth of this stream, now within the corporate limits of Germantown. When he made known his decision to his companions, they all concluded to settle near around him. Upon this the encampment on the Nutz farm was at once broken up, the immigrants forded the Miami River, crossed over to the western bank ascended the steep bluffs adjoining and then traveled on in the direction of the Twin creek. And here, by the side of this stream, they rested at the end of their long and wearisome journey. Here now was their future home.”

Before winter set in, they had secured land and erected some sort of dwellings. The first winter was a long and lonely one. They had harvested no crops the previous year, nor had they earned anything with which to procure the necessaries of life, having spent nearly the whole summer in their journey. Provisions, even if they had the means would have been difficult to procure, as the settlers were but few and had just begun to clear away the forest, and did not raise more than their own wants required. Game was plenty, however. They did not starve during this winter, but they were obliged to live on a small allowance.

Early the following spring, they went to work to clear away the trees, turn up the soil and sow and plant. Their hardest work such as clearing, log-rolling buildings and harvesting was mostly done by crowds, collected together for the purpose from the entire settlement. They made, as they called it, a frolic of it; that is they united into a sort of one-family arrangement, and did their work by succession, first on one place, then on a second and third, etc., until they had made the round and had got through with all. They continued this habit of mutual assistance for many years and great harmony and good feeling prevailed among them.

Religiously, they were either Lutherans or Reformeds, and as in those days it used to be said that all the difference between the denominations was that in the Lord’s Prayer, the one said, “Vater Unser,” and the other said “Unser Vater.”

Unser Vater translates to “Our Father.”

Catharina’s husband Peter Gephart along with George Moyer filed a joint land claim after their arrival in 1804 and agreed upon how they would divide the land.

Widowed

By December 1804, Peter was dead and Catharina, about age 30, was left in Ohio just months after arriving with 2 small children and few resources.  Losing a husband is tragic, but losing your husband on the frontier just months after arrival and before becoming established, with no food or resources is a disaster. It’s a good thing there was a group of settlers, even though there were only 17 families, otherwise Catharina and her children might not have survived that initial winter.  They obviously shared their food with Catharina and her children. By the winter of 1805, Catharina had remarried.

Were it not for the fact that Catharina was widowed, we would have little information about her life. For that matter, were it not for the fact that she was widowed, she would not be my ancestor.

Daniel Miller was appointed by the court to be the executor of Peter Gephart’s estate. We don’t know why, especially given that Catharina was Lutheran and Daniel was Brethren, but regardless of why, it was a fortuitous turn of events. It could possibly have been because Daniel also spoke German, although so did the rest of the Berks County group, although perhaps the Berk’s county group was not yet considered “established” or could not post the required bond. Furthermore, Daniel Miller may have spoken English as well, an important asset in dealing with the court. Daniel was also an Elder in the Brethren Church, so certainly considered to be a respectable man. And he lived close by.

Daniel’s son, David Miller, was 5 or 6 years younger than Catharina and either unmarried or a widower himself. I’d wager a bet that David set about helping Catharina with clearing her land and farm chores. After all, Catharina had a 3 and 5 year old child and couldn’t leave them alone to go out to chop trees and work the fields.

Catharina Remarries

One thing led to another, and well, let’s say that human nature, being what it is, Catharina became pregnant in September of 1805, followed by Catharina and David’s marriage in Warren County, Ohio on December 13, 1805. Their first child, David B. Miller, was born the following June.   In a small, conservative, community, that must have been somewhat of a scandal, because it’s not like no one would notice. Furthermore, while they were both German, they were religiously “mixed,” she being Lutheran and he being Brethren. That probably didn’t go over well with either group. However, it’s not like there were other Lutherans to choose from in terms of a spouse – the community was quite small, so maybe marrying a German was “the best” they could hope for at that time and both communities were more tolerant than they might otherwise have been.  At least, I hope so.

Subsequently, David Miller was appointed guardian for Catharina’s two children, a very common event for a step-father. This guardianship would have been in relation to the land and any other resources that the children would stand to inherit from their father’s estate when they came of age, in 1820 and 1822, respectively.

The 1806 guardianship order records Elizabeth Gephart as being age 8 and John is noted as being age 5.

Probably about this time, Catharina would have converted to being Brethren from Lutheran. We know that David Miller remained a Brethren, as he would have been dismissed from the church had Catherina not converted. Whether she truly converted, or did so in name only to keep peace in the household and larger community, we’ll never know. One hint might be if we could determine whether or not her Gephart children were Brethren. If they were, she was. If they weren’t, then it’s unlikely that she converted in more than name only.

Given that Catharina’s son, John, is buried in the Stettler (Lutheran) Cemetery just down the road half a mile from Peter Gephart’s land and Elizabeth Gephart Hipple is buried in a non-Brethren Cemetery in Miamisburg, it’s unlikely that either child was Brethren. So, I’d wager that Catharina was technically Brethren, in name if not entirely in spirit.

In 1810, Daniel Miller as executor of Peter Gephart’s estate, Catherina Miller as his former wife and the mother of his 2 children, and David Miller as her current husband and guardian of her children petition the Montgomery County court and tell the court how Peter and George Moyer divided the land they patented together.

I wondered why this was done in 1810, and not before, or not later, for that matter. It turns out that the patent was applied for earlier, but not actually issued until October 1809 and then it was issued in the names of George Moyer and Peter Gephart’s two minor children, precipitating the need for a court order to sign deeds.

Catharina Schaeffer land patent

Montgomery Count court note on page 341 reflect the following:

May term 1810– Daniel Miller and Katharine Miller (late Katherine Gephart) with the consent of her husband David Miller administrators of the estate of Peter Gephart [state] that Peter together with George Moyer were [in] possession of 2 tracts of land as tenants in common in Township 2 range 5, section 9 and fraction of 10…land sold to Daniel Mannbeck, land sold to Christopher Shuppert…land sold to John Shuppert…to Miami River…corner George Moyer’s land…425 acres (Moyers share was 447 acres). Peter surveyed in his lifetime…sold quietly to George Jeaceable. Request to execute deed. Elizabeth and John Gephart are Peter and Catharina’s children. Daniel Miller, David Miller and Catharina Gephart sign.

This land is located on both sides of S. Union Road between Upper Miamisburg Road and Lower Miamisburg Road. Union Road divides sections 9 and 10.

Catharina Schaeffer land

Peter Gebhart/Gephart and George Möyer’s property ran between modern-day Upper Miamisburg Road and Lower Miamisburg Road from Jamaica Road east to the Great Miami River, across the river from Miamisburg. An irregular strip comprising a northern third of nearly 448 acres was allotted to George Moyer. Peter Gephart was allotted the middle third of over 445 acres. The southern third was arranged to be sold to Johannes “John” Shuppert (Shüppart), Christopher Shuppert, and Daniel Mannbeck, in three 106-3/8-acre parcels for $200 each, but Peter Gephart died prior to concluding the transactions, hence the petition to the court to complete the transactions as administrators of Gebhart’s estate.

Christopher and Hannah Shuppert sold their tract, the south-central tract, to Peter’s cousin, Heinrich “Henry” Gebhart, Sr., for $300 later in 1810.

Catharina Schaeffer land close

The middle third is shown above, probably the area roughly demarcated by the brown field to the right of Union Road, if you drew lines east and west on the top and bottom of the field east to the Miami River and west to Jamaica Road. In fact, you can see the field lines, which likely followed the property lines, although the tract was irregularly shaped.

Catharina Schaeffer mound drawing

Interestingly, the Miamisburg Indian mound, attributed to the Adena culture, is located less than a mile away from the Schaeffer land. This would have been a familiar sight to Catharina. While cleared today, shown in a Google street view today, the area would originally have been forested as depicted in the drawing above.

Catharina Schaeffer mound today

1811 – A Year of Change

In 1811, Catharina served as executor for the estate of Peter’s uncle, Valentine Gebhart (1751-1810). This may have been the same Valentine Gephart that served as Catherina’s father’s estate executor, which would explain how Catharine met Peter. It’s unusual that Catharina was chosen to serve as Valentine’s executor. Perhaps she had a particularly close relationship with Valentine. Catharina and Peter’s cousin, Philip Gebhart sold three 160-acres tracts in Township 3, Range 5 East, Section 2 (Jefferson Township) around the town of Drexel. To me, Catharine settling the estate and affairs of Valentine feels like life coming full circle.  Valentine probably functioned somewhat as a parental or favorite uncle role for Catharina.

Catharina’s mother died back in Pennsylvania on September 26, 1811. That sad news would have arrived by letter with the next courier coming to Ohio. It’s hard to imagine not being able to be with your mother at the end to comfort her, and to bury her once she had passed over. There was no closure, no life celebration, only the sad news and grieving alone or with anyone in the group who would have known her mother and shared Catharina’s sadness. To the best of my knowledge, none of Catharina’s siblings settled in Ohio, so other than Peter Gephart’s relative, Valentine, who arrived in 1805, Catharina was without family.

Fortunately, David Miller’s father, Daniel, lived just a couple miles away, so Catharina married into a new Brethren family when she married David.

Life on the Farm

Catharina’s life probably calmed down substantially and began to run much more smoothly after her marriage to David Miller, settling into the seasonal rhythmic routine of sew and reap, cooking and laundry, church on Sundays, marriages, births and burials in the churchyard. That never ending cycle.

From 1806 to 1818, Catharina had 7 children, so she was perpetually busy with 9 children and a husband to look after.

David Miller farmed the land that Peter Gephart owned, probably on behalf of the “orphans,” his step-children, and his wife’s share.

David Miller 1810 tax Montgomery

The 1810 tax list of Miller men shows David paying taxes on land in that same location, and the 1814 tax list is even more specific.

David Miller 1814 Montgomery tax list

On this list, the last column indicates the individual who entered the land, meaning the original grantee. The land David is farming is listed as Moyer and Gephart – confirming that indeed, David is farming the Peter Gephart land.  The second David Miller entry in Randolph Township is David’s uncle.  Millers and Brethren Millers in particular are often very difficult to unravel, so it’s fortuitous that our David Miller did indeed farm Catherina’s land – because the location and land identifies the family uniquely.

That farming arrangement would work fine, until Elizabeth and John came of age, which happened in 1820 and 1823, respectively. At that time, the part of Peter’s land that was not Catharina’s dower right, typically one third of the value of the estate, would have become the property of the children, or would have been sold and the proceeds divided between the children.

That would leave David only to farm one third of the land, if that much, because the house would have been considered in that valuation as well, so the total acreage allotted to Catharina would have been less than one third of the total.

The 1820 census schedule in German Township, Montgomery County, shows us David Miller living beside John Gephart, his step-son.

David Miller has the following household members:

  • Male 0-10 Samuel Miller b 1816
  • Male 0-10 John David born 1812
  • Male 10-16 David B. b 1806
  • Male 26-45 David (the father)
  • Male 45+
  • Female 0-10 Lydia Miller b 1818 or Catharine b 1814
  • Female 10-16 Mary b 1809 or Elizabeth b 1808
  • Female 16-24 Susan b 1802 or Esther
  • Female to 45 Catharina (the mother)

It looks like spaces for 3 daughters are missing, unless Esther has already married.

In 1822, David Miller’s father, Daniel dies. Apparently Peter Gephart’s estate has not yet been finalized, and David Miller along with Catharina both sign a receipt that was found in Daniel Miller’s estate papers.

David Miller 1823 receipt

This one “signature” of Catharina is her only known signature, and it appears that she cannot read and write. Obtaining Valentine Gephart’s estate packet might yield additional information about Catharina and additional signatures of hers as well.

Sadly, Catharina died about 1826, at about age 51, leaving 9 children in total, 7 of which had been born to Catharina and David Miller. Their youngest known child was born in 1818, when Catharina would have been about 44.

For a long time, for some reason, it was assumed that Catharine died in childbirth in 1826 – probably because so many women did. Now, based on her father’s estate records being located, we know that it’s very unlikely that Catharine died in childbirth in 1826, because she would have been roughly age 51, give or take a year. Given that her last child was born in 1818, this reinforces her birth year as about 1775 and reduces the probability that she died in childbirth 8 years later.

Burial

I wish we knew where Catharina was buried, but we don’t.

We can speculate a bit, based on what we know of the history of the area.

David may have buried Catharina near Peter Gephart. Of course, we don’t know where Peter is buried either, but the Gebhart cemetery was in use quite early – at least by 1815 and probably earlier. However, since Peter died so soon after arrival, it’s questionable whether a burial ground had been established in the location that would become the Gephart Church at that time.

David could have buried Catharina in a Brethren Cemetery, and if that is the case, it is likely Happy Corners, then known as Lower Stillwater, although that church was several miles away, in Randolph Township.

David could also have buried Catharina in the old cemetery on the land his father, Daniel owned up through 1815, which was only a couple miles away. It’s possible that if Catharine and David lost any children, they would have been buried there as well. However, since the Miller family no longer owned this land in 1826, this location is questionable as well.

David could have buried Catharina in the Old Lutheran Cemetery in present day Germantown. The cemetery was in use by this time.

David could have buried her in the Schaeffer Cemetery in German Township, although that’s probably not terribly likely either.  It is unclear if and how Catharina would have been related to these Schaeffers.

A Miami Township map drawn in 2001 and copyrighted by Tom Midlam shows an unnamed cemetery on the northern part of section 10 of Miami Township which is the land owned by Moyer and Gephart. If the cemetery “cross” is located accurately, it would appear to be on the Moyer land. This cemetery is not named on the map, nor is it in the Miami County Cemetery Index. Given that information, it’s clear that this cemetery is an old family cemetery about which little information is available.

The area today is wooded, although it was likely cleared at one time. If Catharina was buried here, and the cross on Tom’s map is accurate, the cemetery would have been someplace in the forested area bordered on the northwest by Upper Miamisburg Road and South Union Road, at roughly the arrow below.

Catharina Schaeffer poss cemetery

It’s also possible that Catharina was buried in the Stettler Cemetery, located about a mile to the south of where they lived. The Stettler Lutheran Church was formed when the Berks County group settled in the area and it’s also where Catharina’s son, John, is buried as well.

Catharina Schaeffer Stettler

Hill Grove, where Catharina’s daughter Elizabeth is buried wasn’t established until 1863, so we know Catharina’s not there.

My gut feel would be that either Catharina was buried in the cemetery on the land just north of theirs that was presumably in George Moyer’s portion of the tract, or that she is buried in the Stettler Cemetery, because it was close by and her son is buried there as well. We know that the Stettler church was established very early and the residents would have had to establish a group burying ground as well, with perhaps Peter Gephart being the first – especially if the Gephart church wasn’t established yet.

One thing is for sure – wherever Catharina’s final resting place, it was a very sad day with a long line of stair-stepped children, ages 8 to 27, weeping for their mother.

The Early Churches

The Stettler Family tells about establishing the Stettler Church on the land owned by George Stettler who died in 1815 and is buried in the cemetery at the Stettler Church. This is also where John Gephart was buried in 1887.

There were two church congregations established early, the Lutherans and the Reformeds, commonly referred to as the Gebhardt Church and the Stettler Church, respectively. The land for the Reformed church was donated by the Stettler family in 1808.

The Stettler church is located just a mile south of the land owned by Peter and Catharine Gephart, as shown on the map above.

The Gebhart Church and cemetery is located East of Miamisburg, about 4 miles, and across the Miami River, from where Catharina and David lived.

Catharina Schaeffer Gephart church

There are marked burials here as early as 1833, and likely burials long before that.

It’s possible that Peter Gephart may have been the first burial at the Gephart Church in 1804.

Interestingly enough, according to the History of the City of Dayton and Montgomery County, Ohio, Vol 1, the two churches shared a minister from 1808 until 1813. Lutherans living in Miamisburg declined to join either church, saying that the distance to Gephart Church was too great and the roads too bad, and that they were too poor to be ferried across the Miami River to the west side to attend the Stettler Church.

Catharina’s children with Peter Gephart:

Elizabeth Gebhart/Gephart was born November 2, 1799 in Berk’s County and died on August 29, 1884 in Miamisburg, Montgomery County, Ohio. Elizabeth married William Hipple on April 7, 1820 in Montgomery County, Ohio. She is buried in the Hill Grove Cemetery in Miamisburg, just a couple miles from where she grew up in Miami Township.

Catharina Schaeffer Elizabeth Hipple

Elizabeth Gephart and William Hipple had the following children:

  • Catharine Hipple (1821-1887) married Frederick Kolling (Colling) in 1842 and had 4 sons and one daughter, Mary Kolling/Colling.
  • John William Hipple born October 5, 1822 and died November 20, 1893. He married Elizabeth Sherrits and they had 9 children.
  • Sarah (Salone) Hipple (1824-1916) married John Tobias in 1846 and John Coleman in 1856. She had 2 sons and 3 daughters, Clara Elizabeth, Mary Hannah and Hallie Sue Coleman.
  • Caroline Hipple (1828-1865) married Isaac Weidner and had 2 sons and daughter Amelia Aurora Weidner.
  • Clinton Hipple (1830-1910) married Magdalena Tobias in 1849, Eliza Jane Stettler in 1852 and Catharine Stettler Shade in 1874. He had 14 children between all three wives.
  • Jeremiah Hipple born in June 1834, married Matilda Tobias in 1849 and had 7 children.
  • Rebecca Hipple (1826-1914) married William Roark and had 3 boys and two girls, Laura Jane and Ellen Roark. Rebecca later married Leonard John Dangler.
  • Elizabeth Hipple was born in January 1839, married John Beck and had no children.

John Gebhart/Gephart was born on February 26, 1801 and died on January 19, 1887 in Miami Township, Montgomery County, Ohio. He is reportedly buried in the Stettler Cemetery, according to the family, although he doesn’t seem to have a marker. There are many unmarked graves.

Catharina Schaeffer John Gephart

John Gephart married Julia Ann Brosius in 1819. They had at least three children and probably more. This line is not well researched.

  • Jacob Gebhart (1820-1902) married Sidney Ann Medlar and had 2 children.
  • Peter P. Gebhart (1821-1856) married Sarah Shupert and had 5 children
  • Magdalena Gephart (1823-1889) married George Schmidt Gebhart and had 17 children
  • William Gebhart (1825-1891) married Mary Ann Bebhart and had 8 children.
  • Margaret Gephart born in 1827 married Isaac Loy and died Nov. 23, 1900, age 73 years 6 months 17 days in Greenfield, Hancock County, Indiana. Margaret and Isaac had 9 children.
  • Philip Gebhart (1829-1920)
  • John Gebhart (1832-1904) married Elizabeth Kauffman and had 3 children
  • Sarah Gephart born December 20, 1836 married Jacob Loy, died on June 1, 1913 in Pendleton, Indiana and had 7 children.
  • Henry Gebhart (1837-1907)
  • George B. Gebhart (1839-1907) married Nancy Cramer and had 5 children.
  • Susan Catherine Gebhart (1843-1913) married George Washington Burnett and had 5 children

Indeterminate Children

David Miller had two daughters whose mother is unidentified. We do have an avenue to determine whether their mother was Catharina Schaeffer or a previous, albeit unknown, wife. If a descendant of Esther or Susan Miller through all females from Esther/Susan to the tester, took a mitochondrial DNA test, we could compare it against a mitochondrial DNA test of a descendant of Catherina through all females descended from known daughters. If their mitochondrial DNA matches, they share the same direct maternal ancestor. If not, they don’t. Easy as pie. In the current generation, the tester can be a male but he must descend through all females.

Women contribute their mitochondrial DNA to all of their children, but only the females pass it on. So everyone in the world carries their mother’s mitochondrial DNA that is passed to them directly from the matrilineal line, unmixed with any DNA from the father’s side.

I have a testing scholarship for anyone who descends from Catherina’s known daughters through all females to the current generation. I have bolded the candidate lineages for testing, above and below, through Catherina’s daughters.

The two indeterminate daughters are:

Esther Miller Lear/Leer was deceased at the time that her father David Miller’s estate was distributed in Elkhart County, Indiana beginning in 1853.

If Esther is Catharina’s daughter, she was likely named for Catharine’s sister, Esther Schaeffer. Esther is also a Biblical name.

We don’t know Esther’s birthdate, but one researcher shows her marriage to Abraham Lear (also spelled Leer) on December 30, 1824 and names their source as a DAR record.

We do know that Esther was married before 1827 based on her children’s ages. Unfortunately, these dates do little to narrow the range of her birth from “before 1806” to “after 1806” which is the dividing line in the sand that makes a difference in terms of the identity of her mother.

Esther Miller and Abraham Lear/Leer had the following children:

  • Elizabeth Lear was born December of 1827 and died in August 16, 1913 in Holmesville, Gage Co., Nebraska. Her descendants show her birth date as December 5, 1825. She married Samuel Irvin in Elkhart County on May 11, 1845 and had 8 children including daughters Hilinda and Hettie Irvin.
  • Susan Lear was born April 12, 1832 in Elkhart County, Indiana and died on June 5, 1907 in North Liberty, St. Joseph County, Indiana. She married Israel Irvin on April 23, 1852 in Elkhart County and had 7 children including daughters Mary Catherine, Matilda Jane and Dora Irvin.
  • John W. Lear born in 1838. He married Samantha E. Shafer on September 18, 1872 in Elkhart County, Indiana. They had two children.
  • Sarah Lear born in October 1840 (census indicated both 1840 and 1843 at different times) and died after 1910 in Marion County, Kansas. She married Israel Eliphet B. Riggle on October 2, 1862 in Elkhart County. They had 3 children including daughter Arvilla A. Riggle.
  • Mary Lear was born probably about 1827 and died about 1850. She married John Liveringhouse on November 7, 1847 and had two children, William and Eliza Liveringhouse.
  • Catherine Lear married Isaac Shively on December 26, 1852 in Elkhart County and died in 1886 in Allen County, Kansas. She had 8 childreni ncluding 2 daughters, Mary Alice and Sarah Shively.
  • Hetty Lear married Henry Stutsman on April 30, 1857. They moved to Douglas County, Kansas and had 6 children, including 2 daughter, Mary and Martha Stutzman.

Susan Miller was born June 5, 1802 and married Adam Whitehead on February 17,1825 in Montgomery County, Ohio. She died on July 17, 1876 and is buried in the Whitehead Cemetery in Elkhart County, Indiana. Her birth is calculated from her age on the tombstone. If Susan is Catharina’s daughter, she would have been named for Catharina’s mother and sister, Susanna DeTurk and Susanna Schaeffer.

Susan Miller and Adam Whitehead had the following children:

  • Mary Ann Whitehead (1828-1916) married Samuel R. Miller in 1847 and had 7 children including four daughters, Susan, Eva, Mary Jane and Sarah A. Miller.
  • Elizabeth Whitehead (1829-1853) married Jacob Riggles and apparently had no children that survived.
  • Esther Whitehead (1831-1910) married Daniel Shively in 1852 and had 3 children including 1 daughter, Susan Shively who lived to adulthood.
  • John M. Whitehead (1833-1912) married Sarah Smith and had 6 children.
  • Susana Whitehead (1836-1916) married Jacob B. Riggle and had 8 children, including 3 daughters, Catherine, Mary V. and Etta Riggle.
  • Catherine Whitehead (1838-1919) married John Riggle in 1855 and had 3 children, including Lillian J. and Luna May Riggle.
  • Margaret Whitehead (1841-1851)

Catharina’s Children with David Miller

David B. Miller was born June 3, 1806 in Montgomery County, Ohio, died on September 26, 1881 in Elkhart County, Indiana and is buried in the Baintertown Cemetery that is located on his father, David Miller’s, land. David B. Miller’s stone is 4 sided, with wife Christina buried on one side.

David Miller son David stone

Two of their children are memorialized on one side. The third side is David and the fourth side is an inscription.

David Miller son David closeup

David B. Miller would have been named for his father. No one seems to have any record of what the middle B. stands for.

David B. Miller married Christina Brumbaugh before coming to Elkhart County and had 11 children.

  • Catherine Miller who died before 1893
  • William Miller born November 2, 1831, died November 4, 1831, buried in the Baintertown Cemetery.
  • Jacob Miller (1832-1902) married Catherine Whitehead in 1855 and had 4 children, then married Catherine Harshman in 1871 and had 3 more children.
  • Mary Miller (1835-1893) married Joseph B. Peffley in 1853. She died in 1893 in Manuel, Brazoria, Texas and had 9 children.
  • Eve Miller born July 1836, died April 2, 1838, buried in the Baintertown Cemetery.
  • John B. Miller (1839-1897), buried at Baintertown and was living with his parents in 1880 and was a physician.
  • Michael M. Miller born December 1842 in Elkhart County, died Sept 5, 1854 and is buried in Baintertown.
  • Elizabeth “Betsy” Miller (1844-1925) married Samuel Pagen/Pagin, a physician, in 1899, had no children according to the 1900 census and is buried in Baintertown.
  • Daniel C. Miller (1847-1931) married Mary ? in 1885 and had no children according to the 1900 census. He then married Mary Kintigh in 1913 as a widower and is buried in Baintertown.
  • Susannah Miller (1849-1948) married Josiah Rohrer in 1870 and had 4 children.

Elizabeth Miller was born on April 6, 1808 in Montgomery County, Ohio, died on January 16, 1891 in Elkhart County, Indiana and is buried at Baintertown. She would have been named for Catharina’s sister, Elizabeth Schaeffer.

Elizabeth married Michael Haney in 1827 in Montgomery County, Ohio. They patented land very near David Miller in Elkhart County and had 5 children.

  • Matilda Haney (1834-1934) married John W. Baker in 1853. It appears that she died in Washington State.  Children are unknown.
  • Elizabeth R. Haney (1836-1900) married George Washington Alford and had 9 children including daughters, Eva, Jeanetta and Idealla Alford.
  • Joseph Beane Haney (1838-1920) married Lucinda Whitehead and had 5 children.
  • Mary “Molly” J. Haney (1844-1922) married Allen D. Gilkinson.  Children are unknown.
  • John Michael Haney (1847-1849)

Mary Miller was born in 1809 in Montgomery County, Ohio and married Jeremiah Bright on January 31, 1828 in Montgomery County, Ohio. Mary would have been named for Catharina’s sister, Mary Schaeffer.

According to the Elkhart County Pictorial and Biographical Memoirs, Mary and Jeremiah had five children, but I found evidence of 7 including two children who died young:

  • David Miller Bright (1829-1905) married Elizabeth Rinehart, died in Leelenau County, Michigan and had 9 children.
  • George W. Bright (1830-1852)
  • John Bright (1831-1928), died in Fairfield, Ohio.
  • Mary Bright (1833-1911) married John Garner Hall in and had one daughter, Sarah Jane Hall. Mary then married Jacob Alva Aurand and had 7 children including Mary Ellen Aurand.
  • William Bright (1835-1917) married Catherine Wagner and had 5 children.
  • Susannah Bright (1837-1838)
  • Daniel Bright (1838-1840)

Mary then married Christian Stouder on September 11, 1842 in Elkhart County and had four more children:

  • Lydia Stouder (1843-1893) married Samuel Neff in 1883 and had 6 children including Mary Alice, Anne and Desaline Neff.
  • Christian Stouder (1845-1927) married Elizabeth Hohbein and her sister, Catherine Hohbein and had 6 children between the two wives.
  • Samuel H. Stouder (1850-1891) married Margaret Rummell and had 5 children.
  • Unknown 4th child

David Miller daughter Mary Stouder stone

Mary died on October 22, 1863 and is buried at Union Center Cemetery, although her birth and death information was apparently never inscribed on her stone.

John David Miller was born April 6, 1812 in Montgomery County, Ohio and married Mary Baker there on January 24, 1832. They came to Elkhart County with or near the same time as David Miller. Perhaps John David is named for both Catharina’s father, Johann Nicholas Schaeffer and David Miller, his father.

Mary Baker and John David Miller had 10 children:

  • John Miller – died as a child
  • Catherine Miller – died as a child
  • Samuel Miller – died as a child
  • Unknown child
  • Hester Ann Miller (1833-1917 married Jonas Shively and had 8 children.
  • David B. Miller (1838-1922) married Susan Smith and had 9 children.
  • Mary Ann Miller (1841-1915) married Michael Treesh and had 7 children.
  • Aaron B. Miller (1843-1923) married Sarah Myers and had 5 children.
  • Matilda A. Miller (1844-1935) married John Dubbs and had 6 children.
  • Martha Jane Miller (1847-1935) married David Blough and had 7 children.
  • George Washington Miller (1851-1917) married Lydia Miller and had 6 children.

John David Miller married second to Margaret Elizabeth Lentz, widow of Valentine Whitehead. They had four children:

  • Evaline Louise Miller (1857-1939) married Hiram Ferverda and had 11 children.
  • Ira J. Miller (1859-1948) married Rebecca Rodibaugh and had 2 children.
  • Perry Miller (1862-1906) married Mary Jane Lauer and had 4 children.

Photo of John David Miller with Margaret and 5 of his children.

john david miller family

Catherine Miller was born March 17, 1813 and died September 24, 1876 and is buried at Baintertown. She was named for her mother.

Catherine married Conrad Brumbaugh in 1833 in Elkhart County and they had five children.

  • John W. Brumbaugh (1835-1910) married Sarah Peffley and had 9 children. He then married Mary Kintigh and had 2 additional children.
  • Lydia Brumbaugh (1838-1856)
  • Eve Brumbaugh (1840-1891) married Daniel Riggle in 1857 and had 12 children, including daughters Laura Ann, Anna J., Sarah Lilie, Jennie and Kittie Riggle.
  • Sarah A. Brumbaugh born about 1846, died after 1860.
  • Joseph Brumbaugh (1856-1921) married Ellen Martha Hissong in 1889 and had two children who both died young.

Samuel B. Miller was born in 1816 and married Rose Ann Bowser. He died March 1, 1877 and is buried at Baintertown. They had seven children:

  • Emanuel Miller (1838-1921) married Nancy Maurer and had 8 children.
  • Mary J. Miller born (1840-1920) married James Alford in1857 and had 3 children.
  • William H. Miller (1841-1915) married Delilah J. Alford in 1868 and had 5 children. He then married and Matilda J. Wahmeyer in 1898.
  • Desaline Miller born (1845-1904) married Gustavoius Alonzo Latta in 1870, died of strangulation according to her death certificate, no children reported in the 1900 census.
  • Albert J. Miller born (1846-1924) married Elizabeth Ulery and had 2 children.
  • Charles C. Miller born (1847-1910) married Sarah and had two children.
  • Cephus Miller born 1850, died after 1860.

Lydia Miller was born about 1818 in Montgomery County, Ohio and married John (Jonathan) Collier, also spelled Colyar, on September 18, 1834 in Elkhart County. She died about 1876. They had seven children:

  • David Colyar born in 1837, died in 1916 in Kapowsin, Pierce County, Washington married Susanna and had 2 children
  • Elizabeth Colyar (1838-1920), married Jesse Whitman and had one child, a son.  She died in Lone Star, Douglas County, Kansas.
  • Susan Louise Colyar (1839-1917) married George Jacob Hardtarfer and had 9 children including Lydia, Mary Louise, Minnie Bell and Ida Lenora Hardtarfer. Susan died in Douglas County, Kansas.
  • Mary Colyar born in 1842.
  • John Colyar (1845-1932) married Sarah Josephine Belden and had two children
  • Catherine Colyar born in 1848.
  • Louisa Emaline Adaline Colyar born in 1855.

Catherina Schaeffer’s Mitochondrial DNA

Mitochondrial DNA can provide us with an additional chapter in the life of Catherina Schaeffer Gephart Miller and her ancestors, taking us further back in time. Because mitochondrial DNA does not recombine with the father’s DNA, it’s passed intact from mother to child, but only female children pass it on.  On the pedigree chart below, you can see that the red circles are the path the mitochondrial DNA is passed down to a brother and sister, both of whom will carry the matrilineal line’s mitochondrial DNA, but only the sister will pass it on.  The brother’s children will carry their mother’s mitochondrial DNA.

yline mtdna

In order to view Catherina’s mitochondrial DNA, we have to find someone descended from Catherina through all females to the current generation. In the current generation, the tester can be male, so long as he descends through all females from Catherina.

I have bolded female candidates in her list of children and grandchildren.

I have a DNA testing scholarship for someone who descends from Catherina Schaeffer through all females to the current generation.

Summary

I’m sure that Catharina didn’t mean to live such an adventurous live. Her life probably didn’t start out that way either. From the time she was born in Berks County, Pennsylvania, until she left in 1804 on the wagon train, there’s a good possibility she was never more than a few miles away from home – maybe never even in another county.

That all changed in the spring of 1804 when she set forth on the adventure of a lifetime. By the end of 1804, Catharina’s life had changed entirely – and not in a good way.

The trip to Ohio must have been exhausting, and perhaps exhilarating too. I can’t imagine being on a flatboat with two young children. I would be constantly terrified that one of them would escape from my clutches and perish in a watery grave. Flatboats didn’t have guardrails. The only protection you had in that day and age was common sense and a dose of good luck thrown into the mix.

In general, the group knew where they were going, but not specifically. They knew they were going to Cincinnati, but beyond that, they were waiting on Divine Guidance to give them a sign. Flying by the seat of your pants, or in this case, riding in a wagon directed by the invisible hand of Providence must have been a bit disconcerting for Catharina. Maybe she just didn’t think of the danger. Maybe she didn’t understand the scope of the danger. Maybe she just gritted her teeth and clenched her jaw…and prayed for deliverance.

Regardless, not long after Catharina thought she can literally come through the Valley of the Shadow of Death unscathed and was finally safe, the danger became intensely real when Peter died before year end, leaving her on the frontier to fend for herself. I surely have to wonder how he died. He was a young man. Maybe he stood in the wrong place felling trees, or maybe there was some other type of accident.

A year later, in December 1805, Catharina was remarried and pregnant with her third child. On the frontier, an expeditious marriage was best for everyone. Being single meant survival was in jeopardy. Being a single mother was even worse. The answer was to join forces with another through the bonds of matrimony – and the sooner the better. Catharina did what she needed to do.

Catharina must have been somewhat of a renegade woman to be appointed as the executor of the estate of Valentine Gephart in 1811. The court obviously thought her capable, even though it was a very unusual move.

Catharina had small children in her life, sometimes several, from a few months after her original marriage in 1799 until her death in 1826. Her youngest child then was about 8 years old, but about the time that her own children were no longer toddlers, Catharina’s oldest children began blessing her with grandchildren. This could well have been the highlight of her life. Her golden years, so to speak, but they didn’t last long and there weren’t entirely golden either.

The blank spaces in-between known children’s birth years testifies to the 4 grandchildren Catharina likely buried. Two of those grandchildren were also probably born in 1826, which makes me wonder if there was some type of illness within the community that may have claimed Catharine’s life as well as two or more of her grandchildren.

It also appears that Esther Miller who married Abraham Lear and Susan Miller who married Adam Whitehead also lost children in or about 1826 as well. Esther may have lost two children. It wouldn’t have mattered if Esther and Susan were Catharina’s children or step-children, she raised them from the time they were toddlers one way or the other, and their children were assuredly her grandchildren as well.

If 1804 was tragic, 1826 was a grief filled year for the Miller and Gephart families as well, losing Catharine and four or five grandchildren in that timeframe in addition.

At the time of Catharina’s death she had 4 living grandchildren, three from daughter Elizabeth and one from son John. Additionally, it appears that Esther and Susan would have had three between them in the same time period, if they didn’t pass away at or immediately after birth. Catharina’s grandchildren fit right in at the end of her own stair-stepped children. There were always babies in her household, I’m sure. Laughing, giggling, lifting the spirits of the adults. There is nothing so infectious as a baby’s laughter.

Although Catharina didn’t know them, eventually she would have at least 78 grandchildren and 14 step-grandchildren through Susan and Esther, if they weren’t her biological grandchildren.

Get ready for a shocker here, because Catharina had more than 300 great-grandchildren and another 63 either step-great-grandchildren or bio ones, if Susan and Esther were her daughters. Wouldn’t Catharina, who only knew 4 of her grandchildren, briefly, be surprised. It’s sad that her grandchildren never knew her with her undauntable pioneer spirit.

As I reflect on Catharina’s life, I’m struck by both the tragedy and the tenacity that tragedy must have built in the young Pennsylvania Dutch wife in a foreign wilderness who didn’t even speak English. Whatever she had to do, she did it. Adversity separates those who would fail from those who would succeed, but success doesn’t mitigate either sorrow or fear, both of which had to be present on the Ohio frontier on a daily basis as she looked at her two children and wondered what would happen to them.

I’m sure Catharina wondered if she had made the wrong decision leaving Pennsylvania, whether they had let their heads full of dreams of the land tempt them into harm’s way, and whether she should go back to Pennsylvania and return home to her mother. Going back wasn’t nearly as easy as traveling westward, because there was no river to float down – the entire trip was by wagon. Men who went back typically just rode a horse, which was far faster but not an option for a woman with two children. For whatever the circumstances the future would bring, Catherina was firmly planted on the land above the bluffs near the Miami River here she would create a new life on the frontier, with a new husband, and build a family that would lay the foundation for the future of hundreds of her descendants.

Perhaps Catharina coped with tragedy by letting that “Invisible Hand of Providence” guide and comfort her not just during the trip to Montgomery County, but throughout her life and ultimately, through the experience of death.

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Nine Autosomal Tools at Family Tree DNA

The introduction of the Phased Family Finder Matches has added a new way to view autosomal DNA results at Family Tree DNA and a powerful new tool to the genealogists toolbox.

The Phased Family Finder Matches are the 9th tool provided for autosomal test results by Family Tree DNA. Did you know where were 9?

Each of the different methodologies provides us with information in a unique way to assist in our relentless search for cousins, ancestors and our quests to break down brick walls.

That’s the good news.

The not-so-good news is that sometimes options are confusing, so I’d like to review each tool for viewing autosomal match information, including:

  • When to use each tool
  • How to use each tool
  • What the results mean to you
  • The unique benefits of each tool
  • The cautions and things you need to know about each tool including what they are not

The tools are:

  1. Regular Matching
  2. ICW (In Common With)
  3. Not ICW (Not In Common With)
  4. The Matrix
  5. Chromosome Browser
  6. Phased Family Matching
  7. Combined Advanced Matching
  8. MyOrigins Matching
  9. Spreadsheet Matching

You Have Options

Family Tree DNA provides their clients with options, for which I am eternally grateful. I don’t want any company deciding for me which matches are and are not important based on population phasing (as opposed to parental phasing), and then removing matches they feel are unimportant. For people who are not fully endogamous, but have endogamous lines, matches to those lines, which are valid matches, tend to get stripped away when a company employs population based phasing – and once those matches are gone, there is no recovery unless your match happens to transfer their results to either Family Tree DNA or GedMatch.

The great news is that the latest new option, Phased Family Matching, is focused on making easy visual comparisons of high quality parental matches which is especially useful for those who don’t want to dig deeply.

There are good options for everyone at all ranges of expertise, from beginners to those who like to work with spreadsheets and extract every teensy bit of information.

So let’s take a look at all of your matching options at Family Tree DNA. If you’re not taking advantage of all of them, you’re missing out. Each option is unique and offers something the other options don’t offer.

In case you’re curious, I’ll be bouncing back and forth between my kit, my mother’s kit and another family member’s kit because, based on their matches utilizing the various tools, different kits illustrate different points better.

Also, please note that you can click on any image to see a larger version.

Selecting Options

FF9 options

Your selection options for Family Finder are available on both your Dashboard page under the Family Finder heading, right in the middle of the page, and the dropdown myFTDNA menu, on the upper left, also under Family Finder.

Ok, let’s get started. 

#1 – Regular Matching

By regular matching, I’m referring to the matches you see when you click on the “Matches” tab on your main screen under Family Finder or in the dropdown box.

FF9 regular matching

Everyone uses this tool, but not everyone knows about the finer points of various options provided.

There’s a lot of information here folks. Are you systematically using this information to its full advantage?

Your matches are displayed in the highest match first order. All of the information we utilize regularly (or should) is present, including:

  • Relationship Range
  • Match Date
  • Shared CentiMorgans
  • Longest (shared) Block
  • X-Match
  • Known Relationship
  • Ancestral Surnames (double click to see entire list)
  • Notes
  • E-mail envelope icon
  • Family Tree
  • Parental “side” icon

The Expansion “+” at the right side of each match, shown below, shows us:

  • Tests Taken
  • mtDNA haplogroup
  • Y haplogroup

Clicking on your match’s profile (their picture) provides additional information, if they have provided that information:

  • Most distant maternal ancestor
  • Most distant paternal ancestor
  • Additional information in the “about me” field, sometimes including a website link

On the match page, you can search for matches either by their full name, first name, last name or click on the “Advanced Search” to search for ancestral surname. These search boxes can be found at the top right.

FF9 advanced search

The Advanced Search feature, underneath the search boxes at right, also provides you with the option of combining search criteria, by opening two drop down boxes at the top left of the screen.

FF9 search combo

Let’s say I want to see all of my matches on the X chromosome. I make that selection and the only people displayed as matches are those whom I match on the X chromosome.

You can see that in this case, there are 280 matches. If I have any Phased Family Matches, then you will see how many X matches I have on those tabs too.

The first selection box works in combination with the second selection box.

FF9 search combo 2

Now, let’s say I want to sort in Longest Block Order. That section sorts and displays the people who match me on the X chromosome in Longest Block Order.

FF9 longest block

Prerequisites

  • Take the Family Finder test or transfer your results from either 23andMe (V3 only) or Ancestry (V1 only, currently.)
  • Match must be over the matching threshold of 9cM if shared cM are less than 20, or, the longest block must be at least 7.69 cM if the total shared cM is 20 or greater.

Power Features

  • The ability to customize your view by combining search, match and sort criteria.

Cautions

  • It’s easy to forget that you’re ONLY working with X matches, for example, once you sort, and not all of your matches. Note the Reset Filter button above your matches which clears all of the sort and search criteria. Always reset, just to be on the safe side, before you initiate another sort.

FF9 reset filter

  • Please note that the search boxes and logic are in the process of being redesigned, per a conversation Michael Davila, Director of Product Development, on 7-20-2016. Currently, if you search for the name “Donald,” for example, and then do an “in common with” match to someone on the Donald match list, you’ll only see those individuals who are in common with “Donald,” meaning anyone without “Donald” as one of their names won’t show as a match. The logic will be revised shortly so that you will see everyone “in common with,” not just “Donald.” Just be aware of this today and don’t do an ICW with someone you’ve searched for in the search box until this is revised.

#2 – In Common With (ICW)

You can select anyone from your match list to see who you match in common with them.

This is an important feature because it gives me a very good clue as to who else may match me on that same genealogical line.

For example, cousin Donald is related on the paternal line. I can select Donald by clicking the box to the left of his profile which highlights his row in yellow. I can then select what I want to do with Don’s match.

FF9 ICW

You will see that Don is selected in the match selection box on the lower left, and the options for what I can do with Don are above the matches. Those options are:

  • Chromosome Browser
  • In Common With
  • Not in Common With

Let’s select “In Common With.”

Now, the matches displayed will ONLY be those that I match in common with Don, meaning that Donald and I both match these people.

FF9 ICW matches

As you can see, I’m displaying my matches in common with Don in longest block order. You can click on any of the header columns to display in reverse order.

There are a total of 82 matches in common with Don and of those, 50 are paternally assigned. We’ll talk about how parental “side” assignments happen in a minute.

Prerequisites

  • None

Power Features

  • Can see at a glance which matches warrant further inspection and may (or may not) be from a common genealogical line.

Cautions

  • An ICW match does NOT mean that the matching individual IS from the same common line – only genealogical research can provide that information.
  • An ICW matches does NOT mean that these three people, you, your match and someone who matches both of you is triangulated – meaning matching on the same segment. Only individual matching with each other provides that information.
  • It’s easy to forget that you’re not working with your entire match list, but a subset. You can see that Donald’s name appears in the box at the upper left, along with the function you performed (ICW) and the display order if you’ve selected any options from the second box.

# 3 – Not In Common With

Now, let’s say I want to see all of my X matches that are not in common with my mother, who is in the data base, which of course suggests that they are either on my father’s side or identical by chance. My father is not in the data base, and given that he died in 1963, there is no chance of testing him.

Keep in mind though that because X matches aren’t displayed unless you have another qualifying autosomal segment, that they are more likely to be valid matches than if they were displayed without another matching segment that qualifies as a match.

For those who don’t know, X matches have a unique inheritance pattern which can yield great clues as to which side of your tree (if you’re a male), and which ancestors on various sides of your tree X matches MUST come from (males and females both.) I wrote about this here, along with some tools to help you work with X matches.

To utilize the “Not In Common With” feature, I would select my mother and then select the “Not In Common With” option, above the matches.

FF9 NICW

I would then sort the results to see the X matches by clicking on the top of the column for X-Match – or by any other column that I wanted to see.

FF9 NICW X

I have one very interesting not in common with match – and that’s with a Miller male that I would have assumed, based on the surname, was a match from my mother’s side. He’s obviously not, at least based on that X match. No assuming allowed!

Prerequisites

  • None

Power Features

  • Can see at a glance which matches warrant further inspection and may be from a common genealogical line – or are NOT in common with a particular person.

Cautions

  • Be sure to understand that “not in common with” means that you, the person you match and the list of people shown as a result of the “Not ICW” do not all match each other.  You DO match the person on your match list, but the list of “not in common with” matches are the people who DON’T match both of you.  Not in common with is the opposite of “in common with” where your match list does match you and the person you’re matching in common with.
  • The X and other chromosome matches may be inherited from different ancestors. Every matching segment needs to be analyzed separately.

#4 – The Matrix

Let’s say that I have a list of matches, perhaps a list of individuals that I found doing an ICW with my cousin, and I wonder if these people match each other. I can utilize the Matrix grid to see.

Going back to the ICW list with cousin Donald, let’s see if some of those people match each other on the Matrix.

Let’s pick 5 people.

I’m selecting Cheryl, Rex, Charles, Doug and Harold.

Margaret Lentz chart

I’m making these particular selections because I know that all of these people, except Harold, are related to my mother, Barbara, shown on the bottom row of the chart above.  This chart, borrowed from another article (William is not in this comparison), shows how Cheryl, Rex, Charles and Barbara who have all DNA tested are related to each other.  Some are related through the Miller line, some through the dual Lentz/Miller line, and some just from the Lentz line.  Doug is related through the Miller line only, and at least 4 generations upstream. Doug may also be related through multiple lines, but is not descended from the Lentz line.

The people I’ve selected for the matrix are not all related to each other, and they don’t all share one common ancestral line.

Harold is a wild card – I have no idea how he is related or who he is related to, so let’s see what we can determine.

FF9 Matrix choices

As you make selections on the Matrix page, up to 10 selections are added to the grid.

FF9 Matrix grid

You can see that Charles matches Cheryl and Harold.

You can see that Rex matches Charles and Cheryl and Harold.

You can see that Doug matches only Cheryl, but this isn’t surprising as the common line between Doug and the known cousins is at least 4 generations further back in time on the Miller line.

The known relationship are:

  • Don and Cheryl are siblings, descended from the Lentz/Miller.
  • Rex is a known cousin on the Miller/Lentz line
  • Charles is a known cousin on the Lentz line only
  • Doug is a known cousin on the Miller line only

Let me tell you what these matches indicate to me.

Given that Harold matches Rex and Charles and Cheryl, IF and that’s a very big IF, he descends from the same lines, then he would be related to both sides of this family, meaning both the Miller and Lentz lines.

  • He could be a downstream cousin after the Lentz and Miller lines married, meaning a descendant of Margaret Lentz and John David Miller, or other Miller/Lentz couples
  • He could be independently related to both lines upstream. They did intermarry.
  • He could be related to Charles or Rex through an entirely separate line that has nothing to do with Lentz or Miller.

So I have no exact answer, but this does tell me where to look. Maybe I could find additional known Lentz or Miller line descendants to add to the Matrix which would provide additional information.

Prerequisites

  • None

Power Features

  • Can see at a glance which matches match each other as well.

Cautions

  • Matrix matches do NOT mean that these individuals match on the same segments, it just means they do match on some segment. A matrix match is not triangulation.
  • Matrix matches can easily be from different lines to different ancestors. For example, Harold could match each one of three individuals that he matches on different ancestral lines that have nothing to do with their common Lentz or Miller line.

#5 – Chromosome Browser

I want to know if the 5 individuals that I selected to compare in the Matrix match me on any of the same segments.

I’m going back to my ICW list with cousin Donald.

I’ve selected my 5 individuals by clicking the box to the left of their profiles, and I’m going to select the chromosome browser.

FF9 chromosome browser choices

The chromosome browser shows you where these individuals match you.

Overlapping segments mean the people who overlap all match you on that segment, but overlapping segments do NOT mean they also match each other on these same segments.

Translated, this means they could be matching you on different sides of your family or are identical by chance. Remember, you have two sides to your chromosome, a Mom’s side and a Dad’s side, which are intermingled, and some people will match you by chance. You can read more about this here.

The chromosome browser shows you THAT they match you – it doesn’t tell you HOW they match you or if they match each other.

FF9 chromosome browser view2

The default view shows matches of 5cM or greater. You can select different thresholds at the top of the comparison list.

You’ll notice that all 5 of these people match me, but that only two of them match me on overlapping segments, on chromosome 3. Among those 5 people, only those who match me on the same segments have the opportunity to triangulate.

This gives you the opportunity to ask those two individuals if they also match each other on this same chromosome. In this case, I have access to both of those kits, and I can tell you that they do match each other on those segments, so they do triangulate mathematically. Since I know the common ancestor between myself, Cheryl and Rex, I can assign this segment to John David Miller and Margaret Lentz. That, of course, is the goal of autosomal matching – to identify the common ancestor of the individuals who match.

You also have the option to download the results of this chromosome browser match into a spreadsheet. That’s the left-most download option at the top of the chromosomes. We’ll talk about how to utilize spreadsheets last.

The middle option, “view in a table” shows you these results, one pair of individuals at a time, in a table.

This is me compared to Rex. You will have a separate table for each one of the individuals as compared to you. You switch between them at the bottom right.

FF9 chromosome browser table2

The last download option at the furthest right is for your entire list of matches and where they match you on your chromosomes.

Prerequisites

  • None

Power Features

  • Can visually see where individuals and multiple people match you on your chromosomes, and where they overlap which suggests they may triangulate.

Cautions

  • When two people match you on the same chromosome segment, this does not mean that they also match each other on that segment. Matching on overlapping segments is not triangulation, although it’s the first step to triangulation.
  • For triangulation, you will need to contact your matches to determine if they also match each other on the same segment where they both match you. You may also be able to deduce some family matching based on other known individuals from the same line that you also match on that same segment, if your match matches them on that segment too.
  • The chromosome browser is limited to 5 people at a time, compared to you. By utilizing spreadsheet matching, you can see all of your matches on a particular segment, together.

#6 – Phased Family Matching

Phased Family Matching is the newest tool introduced by Family Tree DNA. I wrote about it here. The icons assigned to matches make it easy to see at a glance which side of your family, maternal or paternal, or both, a match derives from.

ff9 parental iconPhased Family Matching allows you to link the DNA results of qualified relatives to your tree and by doing so, Family Tree DNA assigns matches to maternal or paternal buckets, or sometimes, both, as shown in the icon above.

This phased matching utilizes both parental phasing in addition to a slightly higher threshold to assure that the matches they assign to parental sides can be done so with confidence. In order to be assigned a maternal or paternal icon, your match must match you and your qualifying relative at 9cM or greater on at least one of the same segments over the matching threshold. This is different than an ICW match, which only tells you that you do match, not how you match or that it’s on the same segment.

Qualifying relatives, at this time, are parents, grandparents, uncles, aunts and first cousins. Additional relatives are planned in the near future.

Icons are ONLY placed based on phased match results that meet the criteria.

These icons are important because they indicate which side of your family a match is from with a great deal of precision and confidence – beyond that of regular matching.

This is best illustrated by an example.

Phased FF2

In this example, this individual has their father and mother both in the system. You can see that their father’s side is assigned a blue icon and their mother’s side is assigned a pink (red) icon. This means they match this person on only one side of their family.  A purple icon with both a male and female image means that this person is related to you on both sides of your family.  Full siblings, when both parents are in the system to phase against, would receive both icons.

This sibling is showing as matching them on both sides of their family, because both parents are available for phasing.

If only one parent was available, the father, for example, then the sibling would only shows the paternal icon. The maternal icon is NOT added by inference. In Phased Family Matching, nothing is added by inference – only by exact allele by allele matching on the same segment – which is the definition of parentally phased matching.

These icons are ONLY added as a result of a high quality phased matches at or above the phased match threshold of 9cM.

You can read more about the Family Matching System in the Family Tree DNA Learning Center, here.

Prerequisites

  • You must have tested (or transferred a kit) for a qualifying relative. At this time qualifying relatives parents, grandparents, aunts, uncles and first cousins.
  • You must have uploaded a GEDCOM file or created a tree.
  • You must link the DNA of qualifying kits to that person your tree. I provided instructions for how to do this in this article.
  • You must match at the normal matching threshold to be on the match list, AND then match at or above the Phased Family Match threshold in the way described to be assigned an icon.
  • You must match on at least one full segment at or above 9cM.

Power Features

  • Can visually see which side of your family an individual is related to. You can be confident this match is by descent because they are phased to your parent or qualifying family member.

Cautions

  • If someone does not have an icon assigned, it does NOT mean they are not related on that particular side of the family. It only means that the match is not strong enough to generate an icon.
  • If someone DOES match on a particular side of the family, you will still need to do additional matching and genealogy work to determine which ancestor they descend from.
  • If someone is assigned to one side of your family, it does NOT preclude the possibility that they have a smaller or weaker match to your other side of the family.
  • If you upload a new Gedcom file after linking DNA to people in your tree, you will overwrite your DNA links and will have to relink individuals.
  • Having an icon assigned indicates mathematical triangulation for the person who tested, their parents or close relative against whom they were phased and their match with the icon.  However, technically, it’s not triangulation in cases where very close relatives are involved.  For example, parents, aunts, uncles and siblings are too closely related to be considered the third leg of the triangulation stool.  First cousins, however, in my opinion, could be considered the third leg of the three needed for triangulation.  Of course when triangulation is involved, more than three is always better – the more the merrier and the more certain you can be that you have identified the correct ancestor, ancestral couple, or ancestral line to assign that particular triangulated segment to.

# 7 – Combined Advanced Matching

One of the comparison tools often missed by people is Combined Advanced Matching.

Combined matching is available through the “Tools and Apps” button, then select “Advanced Matching.”

Advanced Matching allows you to select various options in combination with each other.

For example, one of my favorites is to compare people within a project.

You can do this a number of ways.

In the case of my mother, I’ll select everyone she matches on the Family Finder test in the Miller-Brethren project. This is a very focused project with the goal of sorting the Miller families who were of the Brethren faith.

FF9 combined matching

You can see that she has several matches in that project.

You can select a variety of combinations, including any level of Y or mtDNA testing, Family Finder, X matching, projects and “last name begins with.”

One of the ways I utilize this feature often is within a surname project, for males in particular, I select one Y level of matching at a time, combined with Family Finder, “show only people I match on all tests” and then the project name. This is a quick way to determine whether someone matches someone on Family Finder that is also in a particular surname project. And when your surname is Smith, this tool is extremely valuable. This provides a least a hint as to the possible distance to a common ancestor between individuals.

Another favorite way to utilize this feature is for non-surname projects like the American Indian project. This is perfect for people who are hunting for others with Native roots that they match – and you can see their Y and mtDNA haplogroups as a bonus!

Prerequisites

  • Must have joined the particular project if you want to use the project match feature within that project.

Power Features

  • The ability to combine matching criteria across products.
  • The ability to match within projects.
  • The ability to specify partial surnames.

Cautions

  • If you match someone on both Family Finder and either Y or mtDNA haplogroups, this does NOT mean that your common Family Finder ancestor is on that haplogroup line. It might be a good place to begin looking. Check to see if you match on the Y or mtDNA products as well.
  • All matches have their haplogroup displayed, not just IF you also match that haplogroup, unless you’ve specified the Y or mtDNA options and then you would only see the people you match which would be in the same major haplogroup, although not always the same subgroup because not everyone tests at the same level.
  • Not all surname project administrators allow people who do not carry that surname in the present generation to join their projects.

# 8 – MyOrigins Matching

One tool missed by many is the MyOrigins matching by ethnicity. For many, especially if you have all European, for example, this tool isn’t terribly useful, but if you are of mixed heritage, this tool can be a wonderful source of information.

Your matches (who have authorized this type of matching) will be displayed, showing only if they match you on your major world categories.  Only your matching categories will show.  For example, if my match, Frances, also has African heritage and I do not, I won’t see Frances’s African percentage and vice versa.

FF9 myOrigins

In this example, the person who tested falls into the major categories of European and Middle Eastern. Their matches who fall into either of these same categories will be displayed in the Shared Origins box. You may not be terribly excited about this – unless you are mixed African, Asian, European and Native American – and you have “lost ancestors” you can’t find. In that case, you may be very excited to contact other matches with the same ethnic heritage.

When you first open your myOrigins page, you will be greeted with a choice to opt in (by clicking) or to opt out (by doing nothing) of allowing your ethnic matches to view the same ethnic groups you carry. Your matches will not be able to see your ethnic groups that they don’t have in common with you.

FF9 myorigins opt in

You can also access those options to view or change by clicking on Account Settings, Privacy and Sharing, and then you can view or change your selection under “My DNA Results.”

FF9 myorigins security

Prerequisites

  • Must authorize Shared Origins matching.

Power Features

  • The ability to discern who among your matches shares a particular ethnicity, and to what degree.

Cautions

  • Just because you share a particular ethnicity does NOT mean you match on the shared ethnic line. Your common ancestor with that person may be on an entirely unrelated line.

# 9 – Spreadsheet Matching

Family Tree DNA offers you the ability to download your entire list of matches, including the specific segments where your matches match you, to a spreadsheet.

This is the granddaddy of the tools and it’s a tool used by all serious genetic genealogists. It’s requires the most investment from you both in terms of understanding and work, but it also yields the most information.

The power of spreadsheet comparisons isn’t in the 5 people I pushed through to the chromosome browser, in and of themselves, but in the power of looking at the locations where all of your matches match you and known relatives on particular segments.

Utilizing the chromosome browser, we saw that chromosome 3 had an overlap match between Rex (green) and Cheryl (blue) as compared to my mother (background chromosome.)

FF9 chr 3

We see that same overlap between Cheryl and Rex when we download the match spreadsheet for those 5 people.

However, when we download all of my mother’s matches, we have a much more powerful view of that segment, below. The 2 segments we saw overlapping on the chromosome browser are shown in green. All of these people colored pink match my mother on some part of the 37cM segment she shares with Rex.

FF9 spreadsheet match

This small part of my master spreadsheet combines my own results, rows in white, with those of my mother, rows in pink.

In this case, I only match one of these individuals that mother also matches on the same segment – Rex. That’s fine. It just means that I didn’t receive the rest of that DNA from mother – meaning the portions of the segments that match Sam, Cheryl, Don, Christina and Sharon.

On the first two rows, I did receive part of that DNA from mother, 7.64 of the 37cMs that Rex matches to Mom at a threshold of 5cM.

We know that Cheryl, Don and Rex all share a common ancestor on mother’s father’s side three generations removed – meaning John David Miller and Margaret Lentz. By looking at Cheryl, Don and Rex’s matches as well, I know that several of her matches do triangulate with Cheryl, Don and/or Rex.

What I didn’t know was how Christina fit into the picture. She is a new match. Before the new Phased Family Matching, I would have had to go into each account, those of Rex, Cheryl and Don, all of which I manage, to be sure that Christina matched all of them individually in addition to Mom’s kit.

I don’t have to do that now, because I can utilize the phased Family Matching instead. The addition of the Family Matching tool has taken this from three additional steps, assuming I have access to all kits, which most people don’t, to one quick definitive step.

Cheryl and Don are both mother’s first cousins, so matches can be phased against them. I have linked both of them to mother’s kit so she how has several individuals who are phased to Don and Cheryl which generate paternal icons since Don and Cheryl are related to mother on her father’s side.

Now, instead of looking at all of the accounts individually, my first step is to see if Christina has a paternal icon, which, in this case, means she phased against either Don and/or Cheryl since those are the only two people linked to mother who qualify for phasing, today.

FF9 parental phased match

Look, Christina does have a paternal icon, so I can add “Dad” into the side column for Christine in the spreadsheet for mother’s matches AND I know Christina triangulates to Mom and either Cheryl or Don, which ever cousin she phased against.

FF9 Christina chr 3

I can see which cousin she phased against by looking at the chromosome browser and comparing mother against Cheryl, Don and Christina.  As it turns out, Christina, in green, above, phased against both Cheryl and Don whose results are in orange and blue.

It’s a great day in the neighborhood to be able to use these tools together.

Prerequisites

  • Must download matches spreadsheet through the chromosome browser, adding new matches to your spreadsheet as they occur.
  • Must have a familiarity with Excel or another spreadsheet.
  • Must learn about matching, match groups and triangulation.

Power Features

  • The ability to control the threshold you wish to work with. For matches over the match threshold, Family Tree DNA provides all segment matches to 1cM with a total of 500 SNPs.
  • The ability to see trends and groups together.
  • The ability to view kits from all of your matches for more powerful matching.
  • The ability to combine your results with those of a parent (or sibling if parents not available) to see joint matching where it occurs.

Cautions

  • There is a comparatively steep learning curve if you’re not familiar with using spreadsheets, but it’s well worth the effort if you are serious about proving ancestors through triangulation.

Summary

I’m extremely grateful for the full complement of tools available at Family Tree DNA.

They provide a range of solutions for users at all levels – people who just want to view their ethnicity or to utilize matches at the vendor site as well as those who want tools like a chromosome browser, projects, ICW, not ICW, the Matrix, ethnicity matching, combined advanced matching and chromosome browser downloads for those of us who want actual irrefutable proof.  No one has to use the more advanced tools, but they are there for those of us who want to utilize them.

I’m sorry, I’m not from Missouri, but I still want to see it for myself. I don’t want any vendor taking the “trust me” approach or doing me any favors by stripping out my data. I’m glad that Family Tree DNA gives us multiple options and doesn’t make one size fit all by using a large hammer and chisel.

The easier, more flexible and informative Family Tree DNA makes the tools, the easier it will be to convince people to test or download their data from other vendors. The more testers, the better our opportunity to find those elusive matches and through them, ancestors.

The Concepts Series

I’ve been writing a “Concepts” series of articles. Recent articles have been about how to utilize and work with autosomal matches on a spreadsheet.

You might want to read these Concepts articles if you’re serious about working with autosomal DNA.

Concepts – How Your Autosomal DNA Identifies Your Ancestors

Concepts – Identical by…Descent, State, Population and Chance

Concepts – CentiMorgans, SNPs and Pickin’ Crab

Concepts – Parental Phasing

Concepts – Downloading Autosomal Data from Family Tree DNA

Concepts – Managing Autosomal DNA Matches – Step 1 – Assigning Parental Sides

Please join me shortly for the next Concepts article – Step 2 – Who’s Related to Whom?

In the meantime:

  • Make full use of the autosomal tools available at Family Tree DNA.
  • Test additional relatives meaning parents, grandparents, aunts, uncles, half-siblings, siblings, any cousin you can identify and talk into testing.
  • Take test kits to family reunions and holiday gatherings. No, I’m not kidding.
  • Don’t forget Y or mtDNA which can provide valuable tools to identify which line you might have in common, or to quickly eliminate some lines that you don’t have in common. Some cousins will carry valuable Y or mtDNA of your direct ancestral lines – and that DNA is full of valuable and unique information as well.
  • Link the DNA kits of those individuals you know to their place in your tree.
  • Transfer family kits from other vendors.

The more relatives you can identify and link in the system, the better your chances for meaningful matches, confirming ancestral relations, and solving puzzles.

Have fun!!!

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research

Family Tree DNA Introduces Phased Family Finder Matches

Family Tree DNA has released a first of its kind tool that sorts your matches into parental buckets by utilizing tests performed on parents and close relatives.

Phased FF2

On your matches page, if your parents or other close relatives have tested, and their tests are linked on your tree, your matches will be grouped into maternal or paternal buckets, or both, utilizing a proprietary matching and phasing algorithm.  You can see the appropriate bucket icon beside the match photo, as well as new tabs at the top to allow you to view your paternal, maternal or matches to both parents.

If your parents haven’t tested, or aren’t linked, your maternal, paternal and both tabs at the top of your page will reflect “0” and they won’t be relevant to you.  However, if your parents or other close relatives have tested, your tab, after processing, will show the number of individuals that fall into maternal, paternal or both match buckets.  Close relatives, at this point, are defined as parents, aunts and uncles, grandparents and first cousins.

This is not just a sorting of matches, based on names of who matches you and a parent, like the “In Common With” tool, but true parental phasing. Each person deposited into a maternal or paternal bucket as a match must match you and your parent or otherwise designated individual in a prescribed way including:

  • On the same segment
  • At a specific threshold

The Phasing Threshold is Higher

The threshold to be indicated as a maternal or paternal match is higher than the normal matching threshold – so some people who do match you and a parent won’t be assigned to a bucket.

Why?

Acting conservatively, Family Tree DNA wants to be positive that this person really does fall into that bucket. You’ll notice that the example individual has 3 people that match both parents. At a lower threshold, there were a lot more dual matches when the product was in testing. At higher threshold levels, people tend to distinctly fall into one bucket or the other in non-endogamous populations. It was actually surprising how many people do legitimately match both parents.

So, to be clear, there are two thresholds in play here:

You will notice that some people who do match both you and a parent do not have a maternal or paternal indicator. That does NOT mean they don’t match you and a parent, but it does mean that the match was at a lower level, or not on the same segment, so Family Tree DNA feels that they can’t positively be assigned to a bucket. That doesn’t mean you should disregard them, but you probably should utilize the stronger matches first and scrutinize non-assigned matches closely by downloading your Chromosome Browser results.

Roughly 10-15 percent of your matches tend to be identical by either chance or population, and that percentage is higher in endogamous groups.  The dual thresholds are meant to minimize those ambiguous matches, yet leave them on your match list for you to analyze.  This is the best approach that provides an intuitive easy visual for those who want that type of approach, but allowing thorough analysis for those who prefer that methodology.  Personally, I like using them together.  The buckets are an easy way to quickly see which side your strongest matches are assigned to.  Given the dual threshold approach, the fact that a match is assigned to a bucket immediately indicates the strength of the match – so it’s a quick and easy gauge.

ICW is Improved

Additionally, you can now utilize the ICW (In Common With) tool, which has moved to the top of the match list, by clicking on the check on the left of the match and then clicking on either “In Common With” or “Not In Common With” to see who else matches, or doesn’t.

You may be very surprised to see that your “in common with” list for a match from your father’s side also includes people from your mother’s side. This is, of course, a red flag as to the validity of that particular paternal ICW match – and it’s so easy to spot now with the parental icons.

Please note that if you utilize the ICW tool when you are on your “All” tab, you will see all ICW matches, but if you are on the paternal, maternal or both tab, and utilize the ICW tool, you will ONLY see people that are ICW on that side of your tree.

So, for example, John Doe, a paternal cousin, matches me and my father and has the blue paternal icon assigned. On my “All” tab, utilizing he ICW tool, I see that John Doe and I have two matches in common. One of those matches is from my father’s side and one from my mothers. It’s easy to see looking at the blue and red icons. Now, if I go to my “Paternal” tab and then perform the ICW comparison with John Doe, ONLY the ICW match from the paternal side will show. You need to be cognizant of where you are on the tabs in terms of what the ICW tool matches mean.

Eligibility

In order for an individual to be eligible for maternal or paternal matching, they must have linked themselves to their parent or other close relative on their tree, not only in terms of name, but in terms of having DNA tested. In other words, the individual on your tree has to be linked to a tested individual in the system.

The Family Tree DNA Learning Center shows how to do this here. Please read this information in the Matches Section before linking people to learn about link hints.

Phased FF link hint

In some cases, if names are different, you won’t have a link hint. For example, my mother is in my tree with her maiden name, but she tested under her married name, so I didn’t have a link hint.  Link hints only work when Family Tree DNA can recognize the same names.  When I linked the two, meaning my mother’s kit to her name in my tree, the software changed her name to the name on her test kit.  So, I’ll be changing the name on her test kit to her maiden name:)

Phased FF4

By going to your tree and clicking on DNA matches in the upper left hand corner, you will see a list of your matches and you can select an individual and drag them to the same person in your tree. In this case, I’ve already done that with my mother, so the link is blue and I see the “already in your tree” message, but if that person wasn’t linked, the link wouldn’t show and I would see a “click and drag to your tree” message instead.

Phased FF3

Not Just Parents

In my case, my mother has tested, but my father is long deceased, so there is no testing for him. If I have uncles or even 1st cousins, I can link them to the paternal side of my tree and if matches match both me and my paternal family member utilizing the phasing criteria, they will be displayed as paternal matches.

Summary

This is a great new tool and the first of its kind in the industry that is actually performing parental phasing as well as utilizing other family members to replace missing parents.

Family Tree DNA has been preparing for this release for some time behind the scenes with the recently revamped tree user interface and the matching update released a month or so ago. This is very exciting, especially for people who want to see at a glance without having to download a chromosome browser spreadsheet who is maternal and paternal.

Additionally, the new software allows us to link people tested to our tree. In my case, I had an ancestor only tree, so I’ve been busy expanding my paternal side of the tree to accommodate all of those cousins I’ve recruited to test because I want those easy-to-see paternal buckets and I can’t test my father.

Family Tree DNA isn’t done either, so do expand your tree and link all of the people of KNOWN heritage, meaning known cousins, who have tested, to take full advantage of this new phasing feature and in preparation for future developments yet to come!

Woohoo!!!  Good job Family Tree DNA!

______________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Services

Genealogy Research