22 October 2017

Putting Yourself in Your Ancestor's Shoes...Historically

Have you had the pleasure of visiting the country your ancestors came from? Those of us who have gone to the old country felt moved, enchanted, and somehow at home.

We found ourselves thinking, "How could they have left this beautiful place?"

But, as Michael Corleone said to his mother in "The Godfather Part II", tempi cambi. Times are changing. The quaint town you visited in recent times may be very different than it was when your ancestor lived there.

your ancestors emigrated from a place that may seem like paradise to you today
It may look like a slice of heaven to you, but your ancestor's hometown gave them reason to emigrate.

Recently I did some research to figure out where one ancestral branch came from. No one living knew if the family was German or Polish. After a bit of historical research, I can now place the family in today's Poland before they left for America. (See Finding Ancestral Homelands That Are No Longer There.)

My direct ancestors all came from Italy, but Italy was not united as a kingdom until 1861. My great great grandmother Marianna Iammucci was born in 1854. That means she wasn't born in the Italy we know today. She was born in the Kingdom of the Two Sicilies.

Marianna's son Adamo Leone fought for Italy in World War I. He came to America and returned to fight for his young country. As a result of that war, Italy became bigger, adding territories in the northeast.

After Italy's unification, there were big differences between northern and southern Italy. My grandfathers and great grandfathers faced poverty and a lack of opportunity. Each of them came to America to find work.

One of my great grandfathers, Francesco Iamarino, came to America at least four times. He stayed and worked for a while. Then he returned home to his wife and children.

His only son, my grandfather Pietro Iamarino, came to America at age 18. Pietro didn't visit his hometown until the 1950s when he was a widow in his fifties. He would have missed his father, who'd passed away by that time. But I can't begin to imagine how happy his mother must have been to see him one more time.

When you're researching your ancestors who left home to find a better life, pay attention to history. What was going on in their hometown when they chose to leave?

Here are two resources published by EmperorTigerstar that show how national borders and ruling powers changed during World War I and World War II. (See EmperorTigerstar's YouTube channel for tons of history.) They're a good illustration of how time changes everything.

World War I: Every Day


World War II in Europe: Every Day


20 October 2017

Add Proof and a Breadcrumb to Family Tree Documents

Has this ever happened to you? You're taking a look at the ship manifest you saved for your ancestor. You had a hard time finding this manifest because your ancestor's name was so badly transcribed.

Suddenly, you realize there's someone on the first line with a last name you know. You need to see who that person is travelling with.

The people you need to see are on the previous page. How can you find that page online again?

We collect so many documents. Can you return to where you found them?
We collect so many documents. Can you return to where you found them?

A Shortcut for Difficult Searches

Here are three options:
  • Perform a search for someone else on the image you have in front of you. Choose someone whose name is written very clearly, and include the first names of the relatives travelling with them.
  • If your relatives' names are written incorrectly, search for the names exactly as they're written.
  • If the top of the ship manifest includes the ship name, the arrival date, and the port of arrival, you can search page-by-page through that particular arrival of that ship.

These tips apply to census forms, too. If you can't find the page again by searching for your relative, search for the easiest-to-read name on the page.

And you can use the information on the top of the census sheet to find the collection that will contain that page.

Search in Vain No More

I'm working on a project that will:
  • Help me instantly find online any document I've downloaded: a ship manifest, census sheet, draft registration card, etc.
  • Allow other genealogists to view my source documents in place, retrace my steps, and see for themselves if my facts can be trusted.

My Family Tree Maker file contains about 2,400 document images. That doesn't count my photographs of people or tombstones.

I'm making my way through each media item, one at a time. I'm adding every important fact and the original web address of the image to its notes.

This annotation lets me—or anyone—return to the original file easily.
This annotation lets me—or anyone—return to the original file easily.

I started with census forms. I try to stick to a format that includes:
  • the lines numbers on which you'll find the family from my tree
  • the town, county and state
  • the enumeration district, supervisor's district, assembly district, block number, page or sheet number
  • the number of the image in the collection, such as image 2 of 45
  • the URL of the original file so I—or other researchers—can return to it

It's an ambitious project. I completed all 623 of my census images before I realized I should include the image number and the web address. So now I'm going through them again, finding each one online to record those two facts. I'm up to 1930, so I can see the light at the end of the tunnel.

Next I'll annotate my 332 ship manifests. Then my 563 birth, marriage, and death records. But I have tons of downloaded Italian vital records I haven't yet added to my tree!

It takes a special kind of devotion to fortify your family tree and make it the best it can be.

But I'm trying.

17 October 2017

Track Your Genealogy Finds and Your Searches

Ten years ago I needed to take control of my family tree digital files. I had a growing collection of census forms, draft registration cards, vital records, and more.

I'd already settled on my preferred way of saving these files:

  • A folder for each type of document
  • A naming convention that groups a person's documents together:
    • LastnameFirstnameYear for a census or ship manifest (I use the head of household's name for a census.)
    • LastnameFirstnameBirthYear for a birth record
    • LastnameFirstnameWW1 for a draft registration card, etc.

But my well-named image files, sitting in all those different folders, didn't show me the big picture.

How could I see at a glance every document I have for a particular ancestor? And how could I quickly see which documents are missing?

Use the Technology You Know

That's when I turned to my old pal, Microsoft Excel.

For years I'd been using Excel spreadsheets on the job. I tracked progress on large-scale projects. I built formulas to show an accurate cross-section of the content on a website I manage. I kept tabs on my freelance hours for invoicing.

Why wouldn't I use Excel to create a genealogy research inventory?

My genealogy "document tracker" has 1540 lines right now. I have one person on each line. There are columns for each type of document I collect. The last column gives me space to note what's missing.

For example, for one of my grandmother's cousins, the "To find" column contains this:

  • 1915 census
  • 1920 census
  • 1925 census

One Spreadsheet Tells the Whole Research Story

Now it's time to get even more value out of my document tracker.

I've been looking at sample research logs on different genealogy sites. A research log is a disciplined way for you to note:

  1. What you're searching for (the 1930 census, a WWII draft registration card, etc.)
  2. Where you searched (National Archives, State Library, Ancestry.com, etc.)
  3. How you searched (by first name only, browsing through the whole census district, etc.)
  4. Your thoughts on what to try next

The research logs I found were much more complicated than I wanted. For starters, I'm satisfied with the list above.

here's how you can get more value out of a genealogy spreadsheet

So I've added a second sheet to my document tracker Excel file and named it Research Notes. The first column is for the person's name. I added four more columns to match the four items in my list.

How to Start Using Your Research Notes

The next time I'm trying to find a specific document—like the elusive 1940 census for the Raffaele Saviano family—I'll add a line to the new Research Notes worksheet.

I might note that I tried searching for the family using only their first names. And that I used Americanized versions of their Italian names. I'll add that I tried this on Ancestry.com and FamilySearch.org.

When I'm ready to call it quits for the moment, I'll add a note about what I think I should try next.

Finally—and this is a cool Excel trick—I'll add a link from this research note to Raffaele Saviano's line on the first worksheet where all of his documents are listed. And I'll add a link from there back to his line on the new Research Notes worksheet.

My favorite thing about linking between the sheets is this: You can reorganize the lines on either worksheet and not break the links. You can sort them, add new lines in the middle, do whatever you need to do, and the links will still work.

Here's how to create a link between the two worksheets in a single Excel spreadsheet file:

  • Make a mental note of which line number holds your ancestor on your new Research Notes worksheet. For example, I have Raffaele Saviano on line 2.
  • Click the empty cell where you want to add the link. You'll want to devote a column to these links. In my example, I'll go to Raffaele Saviano's line (1327) on my Facts worksheet and click in the empty "Link to Notes" column.
  • On the Insert toolbar or ribbon, click Link and choose Insert Link.
  • Click to select the name of your new research notes worksheet.
  • In the field labelled "Type the cell reference" it may say "A1" by default. Change it to A2, or A and whichever line number you need to link to.
  • Click OK and you'll see your link.

Now make a mental note of the line number for this ancestor on the Facts worksheet. Go to the Research Notes worksheet and link back in the same way.

Click the links to see them work.

Now you can have all of these facts at your fingertips. It's 100% searchable, sortable, and update-able. Download a sample spreadsheet to build on.

My favorite thing about Excel: I know it can do a million more things I haven't even thought of yet.

For more detail on the document tracker, see: