06 April 2021

Family Tree Fun for Computer Geeks

I started a project in 2019 and said I would share it with you soon. It was harder than I thought, so I put it aside until now. The results are interesting to see.

The geeky background is this:

  • In Family Tree Maker, I exported my latest GEDCOM file
  • In Family Tree Analyzer (free), I imported the GEDCOM and exported a spreadsheet of all facts
  • In Power BI Desktop (free), I imported the spreadsheet and built different views of my data

A few minutes into reviving this project, I noticed a friend's blog post on a similar topic. He showed all the pie charts he generated from his family tree on MyHeritage. I have only the most basic tree on that website, so I got back to work in Power BI Desktop.

In Power BI Desktop, I created graphs showing:

1. Last name occurrences in my family tree from most to least. Most of the last names in my tree (currently with 27,900 people) come from one town. That's no surprise. Years ago I pieced together my Grandpa Leone's town using 1809–1860 vital records. I added 15,000 people to my family tree.

I also see big numbers for last names from Grandpa Iamarino's town. The name Pozzuto is in the #1 position by far. That's because I made an effort to fit every last Pozzuto from the vital records into my tree. My maiden name is in 10th place because I've spent time pushing to find my closest Iamarino relatives.

Do you know what are the most common names in your family tree? This tool can tell you.
Do you know what are the most common names in your family tree? This tool can tell you.

2. First name occurrences in my family tree from most to least. My family is 100% from southern Italy, from the region called Campania. I'll bet the most common first names in my family tree are almost the same as other Campania family trees.

The most common first names in my family tree are:

  • Giuseppe
  • Angelamaria
  • Giovanni
  • Antonio
  • Francesco
  • Domenico
  • Pasquale
  • Maria

3. Birth locations plotted on a world map. The Power BI software plotted every birth location from my family tree on a map. I love zooming into southern Italy to see how centralized my Italian ancestors were. Draw a straight line from the Bay of Naples to the spur of the Italian boot, and that's where my DNA comes from.

Almost any type of family tree data can be plotted to give you the big picture.
Almost any type of family tree data can be plotted to give you the big picture.

4. Ahnentafel numbers from 1 to 2,691. I created a chart using a custom field in my GEDCOM called Ahnentafel. (Each of my direct ancestors has their Ahnentafel number in this field in Family Tree Maker.) I put the numbers on both the X and Y axis of a scatter plot for an interesting visualization of the gaps.

I know almost all my direct ancestors up to Ahnentafel number 748. Then there's a sprinkling from 999 to 1,392. Finally, I have a gigantic gap with two stragglers at 2,136 and 2,691. It's exciting to see my progress this way.

5. Number of children per marriage. I made a pie chart for the number of children in every marriage in my family tree. More than a third of my marriages have only one child. I'll bet I'm missing a ton of kids. That sounds like something to work on. About a quarter of the marriages in my tree have between 4 and 14 kids!

What do you think is the average number of children per family in your family tree?
What do you think is the average number of children per family in your family tree?

6. Drill-through by type of data. I'm familiar with this type of chart, but I never thought of using it for genealogy. I started with every individual in my family tree. Then I broke them down by last name. Then I broke each last name down by first name. I followed that with birth location, birth date, marriage date, and death date.

It may not be the most useful tool, but it is cool. I can choose any last name in my tree, then a first name and a birth place. I can click each one to see which facts I have in my tree.

This drill-through chart lets you follow anyone in your family tree through a series of events.
This drill-through chart lets you follow anyone in your family tree through a series of events.

For instance, I can click my name of Iamarino, and then the most common first name of Antonio. Now I see all the locations where an Antonio Iamarino was born. Next I'll click the town name (Colle Sannita) where I have 7 Antonio Iamarinos. Next comes the birth dates of the 7 men. I clicked each one until I found an Antonio for whom I have all the basic facts: birth, marriage, and death dates.

If you'd like to see statistics for your family tree, you can:

30 March 2021

4 Steps to Writing Your Own Life Story

My sons know I'm something of a computer guru. I've been working at a computer their whole lives.

But do they know my mother saved my life in a car crash when I was 10? Do they know why I went to 3 colleges for a total of 5 years? Have I told them I starred in several student films in college?

I've written before about an easy way to write your ancestors' life stories. It's based on family lore and all the documents and photos you've collected. But what about your own stories? What about those important memories that exist only in your head?

This project will be a living document. Old memories crop up when we least expect them. If you have a place to capture them, you can add to your life story at any time.

You may want to use a blank book for your living life story. Or you can use a loose leaf binder so you can arrange your memories in chronological order. Me? I prefer an electronic document, like a Word file. Nothing beats cut-and-paste for putting things where they should be.

Once you've chosen where to capture your memories, here's how to get started.

In 4 steps you can return to at any time, you can write your life story for future genealogists.
In 4 steps you can return to at any time, you can write your life story for future genealogists.

Step 1: Create a Timeline

Enter some basic facts, such as:

  • When and where you were born
  • All the schools you attended, plus where and when
  • All the places you worked, where and when
  • All the places you lived, with addresses and years
  • Key life events like marriages and births

The schools, jobs, and homes are a long list for me! Like, crazy long. But they play a big part in my life story.

Step 2: Add Highlights

Think about each of your schools, jobs, and homes one at a time. Take the time to dwell on each one until some memories come bubbling up to the surface.

Write down an experience that crystallizes that time and place for you. I have an unusual anecdote about my childhood home. It's a recurring dream I had about the house itself. I've already told my sons about this weird dinosaur dream. So much so, that one of my sons has had it, too! It seems I've already passed that down.

I'd like to capture the dream, but I won't leave out the real memories of that house, like:

  • Playing "Beatles" when my cousin would visit and we were a group of 4. We'd run around the backyard, pretending a mob of girls was chasing us.
  • All the family and neighborhood parties we had in the basement that my dad turned into a bar and poolroom. I was a child bartender. That's fun.
  • My chemistry set! The memory of it is so important to me. Because it might make a mess, Mom made me set it up in the darkest, scariest corner of our basement, behind the bar. It took courage to go play with it.

I'll bet you can pull up memories about every place you've lived, worked, and gone to school.

Take advantage of the mood when it strikes you. Jot down these basic memories with enough detail for you to remember the whole story and fill it in later. For instance, I can come up with a short list of memories for my homes in:

  • California: I don't remember being a baby in Buena Park, but I did visit the house a few years ago
  • Long Island: our playhouse in the backyard, and seeing the Beatles on the Ed Sullivan show
  • Rockland County: summers by the pool and countless drive-in movies
  • Connecticut: moving ourselves into that house, and the great bee infestation
  • Indiana: driving 60 miles to college twice a week, and seeing every major film of 1982
  • New Jersey: buying my first car, getting my first apartment
  • Pennsylvania: the days my kids were born, and buying 4 houses
  • New York again: building our house on a mountaintop with an awesome view

And I can do the same for each of my many schools and jobs.

Step 3: Bring the Memories to Life

Go back to your list of memories and relive one. Flesh it out for future readers. Write it as if you were watching it in a movie, but don't fuss over the style. Tell why it's important to you. Why do you still remember it? Does that memory lead you to another? Write that down, too.

Of course, there are some memories we don't want to share with our kids, or anyone else. Those will have to stay in our heads. But we can still have our "feels" while reliving them.

Return to your living document whenever an important memory comes back to you in a dream or in a train of thought. It should be therapeutic, and a bit eye-opening. Re-read what you've got to see if more details spring to mind.

Step 4: Mention Your Project

This is the easiest step, but it's crucial. Once you've gotten started, let some family members know about it. You don't have to share it yet, but make them aware it exists, and where it is.

Your family history research tends to focus on your ancestors, right? I know I spend most of my time thinking about my relatives from the 1800s. I wish I had even one anecdote from their lives.

This is your chance to blow the minds of your future relatives when they discover you.

23 March 2021

You, Too, Can Develop a Genealogy Super Power

I have genealogy super powers. I've been doing a massive amount of work to build my research database. I made tens of thousands of Italian vital record images searchable on my computer. I can piece together more of my extended family than ever before.

Recently, I made the Pesco Sannita vital records searchable by name. That's my great grandmother's hometown, and I was eager to find more of her ancestors. Then I remembered a past project of mine. It involved locating documents to fill in missing birth dates in my family tree. Now I can also search for people from Pesco Sannita.

I spent the weekend finding documents and filling in missing birth dates. To do this, I arranged my list of people by birth year in Family Tree Maker and went straight to 1809. That's when the Italian government began recording births.

I'm using my super powers to fill in an many blanks as possible in my family tree.
I'm using my super powers to fill in an many blanks as possible in my family tree.

For many people in my tree, I knew what year they were born based on their age when they had a child. But that isn't reliable. I had to search for their birth or marriage to learn exactly when they were born.

I wanted to speed up my progress. My goal is to add relationships that can tie me to more DNA matches. I decided to break a cardinal rule. I did something drastic. I added dates and names to my family tree WITHOUT adding the document image or source citation.

That isn't as bad as it sounds. My tree has 27,400 people as I write this. I'm related to the majority of the people by marriage, not blood. That's how it was in small towns back then. All the families intermarried. I can return to the document on my computer at any time. Whenever I need to firm-up that family unit, I can do so easily. I can find the documents again, add them to my tree, and create the source citation.

I would never do this fast-paced fact gathering with any other type of document. It would be completely crazy to add, say, facts from a census form without saving the form and its citation info. But I have this unique opportunity to build out dead ends in a hurry.

I set to it, working on each incomplete or estimated birth date from 1809–1847, so far. It's so gratifying. I keep thinking it's like shooting fish in a barrel. And it's addictive.

One by one, I found a person's missing birth date. Sometimes I found their marriage and death record in the same search results. For each marriage record, I added:

  • the dates of their marriage banns, license and church ceremony
  • their spouse's name and birth date
  • both their parents' names and some of their facts.

Many times the right documents proved I could merge together 2 people in my tree with the same name.

You already have the interest. Dive into the genealogy documents and you will learn.
You already have the interest. Dive into the genealogy documents and you will learn.

Aside from finding what I need, there's a great value to examining every document from a town the way I do. Horribly scribbled names do not slow me down. I know the last names from each of my towns well. They're as familiar to me as my own. I can recognize by their name if a spouse is an out-of-towner.

In fact, I taught myself to read these difficult old documents by diving right in. Each time I found an unfamiliar Italian word, I looked it up. Dates were always written in long hand, so I had to memorize the words for months and numbers. I learned exactly where to look for key facts on different types of documents.

My husband doesn't understand how I can look at the scribbles on my computer screen and pull out the facts I want. But we all learn what we need to learn. He can read a schematic diagram because he's an engineer. I can read old Italian vital records because I'm an Italian genealogy researcher.

You can develop your genealogy super power, too. Don't give up and say you can't read another language. Go to the FamilySearch Wiki and find the genealogy keywords for the country you need. You don't need to understand every single word. Then dive in and get familiar with your surroundings. Learn all the names in town. Find your family. Be your family's superhero.