How to Create Your Ancestral Hometown Database

What genealogy fan wouldn't be thrilled to find their ancestor's hometown records online?

That moment came for me when I learned about the Italian website, Antenati. Antenati has birth, marriage and death records for my handful of ancestral towns in Italy. Other genealogists are finding their ancestor's records on FamilySearch.org.

A free computer program called GetLinks (no longer works with Antenati) makes it easy to download these digitized records from both FamilySearch.org and the Antenati site. It's written in Portuguese, but don't let that worry you. I've written several times about using these records and the program. See:

• How to Use the Online Italian Genealogy Archives
• Collect Whole Set!
• Where Have You Been All My Life?
• Step-by-Step Discovery of My 5th Great Grandparents
• Finding the Siblings Your Ancestor Never Mentioned

If you've downloaded documents from your ancestral hometown, you may have hundreds or thousands of images on your computer.

Now what?

Once you download all the records from your town, imagine how many of your relatives are in these folders!

If you're looking only at each year's index and finding what you know you need, you're missing the boat. And that boat is overloaded with your ancestors!

My recommendation: Make a spreadsheet database of every important fact in each document.

My database-in-progress for several towns' birth, marriage and death records.

What's the point? With a spreadsheet of facts, you can sort an entire town's birth records by last name. If you sort by last name and father's name, you will see all the children born to your ancestor.

There will no doubt be ancestors in your spreadsheet that you never knew existed.

Here are 5 steps to creating your ancestral hometown database from your downloaded files:

1. Examine the records for the fields you want to capture. For example, birth records may contain the baby's name and birth date; father's name, age and occupation; mother's name and age; the address where the baby was born or where the father lived (not always the same); and the baby's baptism date. Death records will contain different facts, and so will marriage records.
2. Create columns in your spreadsheet to hold all the facts. I keep birth, death and marriage records on different sheets in my Excel file so they can have different column headings.
   
   TIP: The best way to be able to sort your records by date is to keep the year, month and day in separate columns.
3. Enter information from the documents into your spreadsheet. This takes time, but I found shortcuts as I did this last night.
   
   • I went through one year's birth records, entering only the baby's name into the spreadsheet. I put the baby's last name in one column and first name in another. (I record parents' names as last-name-first to help with sorting.)
   • On my second pass through the records, I entered the birth and baptism dates.
   • On my third pass, I entered the mother and father's information.
   Why is this better? I was always looking in one specific spot on the page for the information I wanted. It felt faster than going one document at a time, picking out facts from all over the page.
4. Sort the data by any column to uncover hidden facts. You may find an unknown sibling. You may find that a man had several wives over the years. You may find several siblings for your ancestor who died young.
   
   See Dr. Daniel Soper's YouTube channel for tips on using Excel. Many tips will apply to other spreadsheet software.
5. Share your database! Years ago I documented the facts from the vital records for my grandfather's hometown. I gathered these facts while sitting at a microfilm viewer in a Family History Center (for years!), so I used a simple text file. You can't sort a text file, but at least you can search it. I shared this file, as well as a GEDCOM for the whole town, with other descendants of that town.
   
   Your spreadsheet can be a valuable resource to other family tree researchers. Once you're done, I encourage you to share it everywhere you can think of.

I documented two years of records while watching the Yankees slaughter the Orioles last night. I expect to get much further tonight because of the shortcuts I found.

When you have your database, find an appropriate Facebook group or other place, and put the data out there. Genealogy is a collaborative sport!

Today I Demolished My Family Tree's Only Brick Wall

You know that guardedly ecstatic feeling when you think you're looking at the answer to your biggest family tree mystery?

Should you shout EUREKA! or keep reading the document you've found to make sure you've got it right?

This happened to me a few times today, and I was giggling with joy!

I had his death photo. Now I have his birth and marriage records!

Recently, I filled out my chart of direct ancestors, color-coding the names to correspond to each of my four grandparents. That's when I realized I hadn't gotten further than my third great grandparents on my maternal grandmother's branch. And those names were from an unreliable source.

I needed to find Italian documents for my grandmother's grandparents: Antonio Saviano and Colomba Consolazio. Only then could I be sure of their parents' names. And maybe I'd learn their grandparents' names.

My great great grandfather Antonio Saviano presented me with another problem besides his ancestors' names. I didn't know where he was born, and he seemed to move a few times before coming to America. I haven't found any other Italian family in my tree that moved more than once in 1800s Italy.

The Saviano and Consolazio origins were my only brick wall.

How I Broke Through…Slowly

First I found Antonio and most of his family on an 1898 ship manifest coming to New York. They stated they were from Sant'Angelo a Cupolo. That's a little town in the province of Benevento. But I'd always heard they were from Avellino.

Next I found the World War II draft registration card for Antonio and Colomba's son, Semplicio Saviano. It said he was born in Tufo, Avellino, Italy. Great! Now I was onto something.

Then I ordered microfilm of Tufo vital records to view at my nearest Family History Center. I found that Antonio Saviano and Colomba Consolazio had a son before Semplicio named Raffaele.

I looked in the Tufo microfilms for Antonio and Colomba's births and marriage. But they weren't there!

Thanks to Colomba's brother's marriage records, I discovered that the Consolazio family came from the neighboring town of Santa Paolina.

So, with only days left to order microfilm, I ordered four reels from Santa Paolina, Avellino, Italy. Today I went to see them.

I immediately set out to find Antonio Saviano's 1843 birth record. It wasn't there, and I was disappointed. but I continued looking.

And then it happened.

I wasn't sure at first, so I kept quiet. But there I was, looking at Colomba Consolazio's birth record. My great great grandmother was not born on the date I saw on her death record. She was born three years earlier, and her name was Vittoria Colomba Consolazio.

There was an extra paragraph in the center of the birth record. It stated that Vittoria Colomba Consolazio married Antonio Luigi Saviano on 1 June 1871 in Santa Paolina!

I rewound that reel of film faster than I thought possible. I had to get to the 1871 marriage records ASAP.

And the bricks came tumbling down.

When I found the marriage banns and marriage record, I had an answer I never expected. Antonio Luigi Saviano was born on 7 July 1843 in Pastene.

Pastene is a small section of Sant'Angelo a Cupolo in Benevento! That's where the family was living before they came to America. That's where my great grandmother and her younger siblings were born.

So Antonio was born in Pastene, moved to Santa Paolina to marry Vittoria Colomba, had one baby who died at four days of age, moved to Tufo to have two more children, and moved back to Pastene to complete his family.

I learned Antonio's parents' names were not what I saw on his death certificate. They were Raffaele Saviano and Grazia Ucci. Grazia died before 1871. I learned Antonio's birth date and his town of birth.

I learned Vittoria Colomba's real name, real birth date, and her parents' full names. These facts were almost entirely wrong on her death certificate. Her father was Sembricio Fiorentino Consolazio, son of Gaetano who was the son of Saverio. Sembricio's mother was Colomba Ricciardella.

Finally, I learned about Vittoria Colomba's mother. On her death record, her mother was Rafina Zinzaro. In the Tufo documents, she was Rufina Zullo.

But on an 1818 birth record I discovered Rafina Zinzaro / Rufina Zullo was born Rubina Maria Consullo (sometimes written as Conzullo). Her parents were Simone Consullo and Domenica Iacobellis.

During my visit today I jotted down the facts for every Consolazio I could find, and I will go back to finish that work. Suddenly my family is much bigger thanks to the Consolazio ancestors that had been hiding behind that brick wall.

Now it's time to scour the Pastene and Sant'Angelo a Cupolo records I downloaded to get the facts on every Saviano and Ucci.

Can I shout EUREKA now? EUREKA!!!!

You may also enjoy:

• Why You Need Your Ancestors Draft Registration Cards
• How to Use the Online Italian Genealogy Archives
• 5 Steps to Grow Your Italian Family Tree

Find Your Happy Place in Your Favorite Genealogy Tasks

One of my favorite parts of my day job—those hours when I'm not doing genealogy research—is tackling projects I can do alone.

You say you need 300 web pages edited because of a new product name? No problem. You say you need a bunch of high-resolution images optimized for the web using Photoshop? No problem.

I enjoy handling organizational projects and projects where I need to find the best solution to a specific problem.

Looking at that description of the types of work I enjoy, it's blatantly obvious I was meant to be a family tree researcher.

A photo like this is all the inspiration I need to work on my family tree.

As I'm thinking about it, there are a handful of big projects I need to complete for my family tree. How many of these can you relate to?

• Enhancing the citations for the documents in my family tree.
  
• Capturing the facts from the tons of Italian birth, marriage and death records I've downloaded.
  
• Adding images of these documents to my tree.
• Find the missing census forms for people in my tree.
• Requesting the birth and death records I'm missing.

It is ironic that I've written about this idea before. I've encouraged you to Divide and Conquer Your Family Tree Research Tasks. I've tried to inspire you to Organize Your Genealogy Research By Choosing Your Style. I've urged you to Work in Batches to Strengthen Your Family Tree.

But I haven't always been able to live up to these goals.

Life gets in the way of genealogy, and that's fine. Maybe we need to be a bit less demanding of ourselves.

If I didn't have that day job, I might spent at least four or five hours a day on genealogy. But for now, I'm going to divide those tasks above into manageable chunks. I'll knock them off, bit by bit, and gain the same satisfaction I get from my job.

If you're reading this blog, you must feel a devotion to genealogy as I do. Remember this:

• We've all got a lot of individual genealogy tasks to tackle.
• When we put all the pieces together and do our research well, we rejoice in the result.

So here's my recommendation to you—and to me. Figure out what's needed to get your family tree in tip-top shape. Decide which family tree tasks you enjoy the most.

Then kill two birds with one stone: Fortify your family tree while making yourself a happy, joyous genealogist.

Spinning Genealogical Facts into Your Family Story

I have a love/hate relationship with the TV show "Who Do You Think You Are?". I love seeing others experience the joy of finding an important genealogical document. But I hate that every celebrity is the direct descendant of a king or a patriot.

Where does that leave a descendant of peasants like me?

Whether you're the great great grandchild of powerful people or humble railroad workers, you do have an interesting story to tell.

You just have to find it.

Where to Look for Your Story

How could this character NOT be interesting?

Take a look at what you've discovered about your grandparents and great grandparents. Check their census forms, immigration records, naturalization papers, and more.

• Did anyone have an unusual job? My great grandfather seemed to go from bartender to apartment building owner overnight.
• Did the two sides of your family converge before your parents were married? My two grandfathers lived in neighboring towns in Italy before winding up one block apart in New York City. They could see each other's town from their childhood home.
• Did someone famous come from one of your ancestral hometowns? Hmmm. Well, my dad was in Regis Philbin's high school class at Cardinal Hayes in the Bronx, and George Carlin was expelled from there. But that's more of an anecdote than a story.
• Is someone famous on the same ship as your ancestor or living on their street? I have found unrelated people from my maternal and paternal families on the same ship. That fits better with the "family convergence" idea.
• Do you have an amusing six-degrees-of-separation story? I can connect myself to my favorite movie director, John Huston (1). His daughter Anjelica (2) was in the movie "Daddy Day Care" with Eddie Murphy (3) who was in "Shrek" with Mike Meyers (4) who was in "Austin Powers: The Spy Who Shagged Me" with Fred Savage (5) who was in "The Wonder Years" with Josh Saviano (6) who is my third cousin. It's a fun parlor game, anyway.

For me, the story of my entrepreneurial great grandfather Giovanni Sarracino rises to the top of the list.

Where to Start Writing Your Story

One technique for crafting your story is to write out what you know as if it's a movie plot.

• Where are the plot holes, and where should you search for what's missing?
• What was going on at that time in history in the place where your ancestor lived?
• What effect did any historical facts have on your ancestor?

Lots of census forms and directory listings pointed to Giovanni's evolving career path. Using the Fulton History website, I discovered real estate transaction notices in New York newspapers. Giovanni and his brother-in-law Semplicio were working as agents of a local brewery or two. First they were buying and selling buildings for the breweries. Then they were buying buildings for themselves.

Exactly what happened is still a bit of a muddle to me. There is more to learn about these defunct breweries. A visit to the Bronx Historical Society might be what I need.

It's going to take discipline, but you can do it. Put aside some of your research threads for a few days. Find your interesting nugget of a story. Write it down, gather some facts, and see where it takes you.

If you're not a celebrity, you won't be featured in an episode of "Who Do You Think You Are?" or "Finding Your Roots". But you will become an instant celebrity within your family.

You may also enjoy:

• Where Did I Find This?
• Haven't I Seen You Before?
• What if There's No There There?

Finding the Siblings Your Ancestor Never Mentioned

My grandfather Adamo Leone (right)
and his younger brother Noé.

When I started my family tree research, I knew nothing about my maternal grandfather's ancestry.

Nothing.

In conversations with my mother and aunt, I learned that my grandfather had a brother Noah (Noé in Italian) and a sister Eve (Eva in Italian). That was good for a chuckle because my grandfather was Adam (Adamo in Italian).

Adam and Eve and Noah? Come on!

This lack of detail made me want to research Adamo's hometown of Basélice in Benevento, Italy, more than anyplace else. (See "Why I Recorded More Than 30,000 Documents".)

The Specifics of Your Ancestral Hometown

As I began to document the vital records from Basélice for the years 1809 through 1860, I spotted some patterns:

• Most couples married at an average age of 25 years.
• Most couples had their first child within one year of marriage.
• Most couples continued to have children every two or three years until the woman was roughly 45 years old.
• The average number of children per couple was six to eight.
• If a man was widowed, he was likely to marry a much younger woman, and father another six to eight children.

Something's Not Logical

Recently I was able to access and download Basélice vital records for years beyond 1860. When I located my grandfather's 1891 birth record and his parents' 1881 marriage record, something didn't add up.

How could his parents, Giovanni Leone and Marianna Iammucci, have been married for 10 years without having a child? Adamo, Noé and Eva were born in 1891, 1895 and 1898, respectively. Their mother Marianna was 42 in 1898.

It seems fine that she had her last child a little while before her childbearing years ended. But the 1881 to 1891 childless gap made no sense based on my knowledge of their hometown.

So I began searching. The other night I found them!

My surprise great uncle Giuseppe Leone's 1883 birth record. See his marriage annotation in the right column.

My grandfather never mentioned them. But now I know he had an older brother Giuseppe (born in January 1883) and an older sister Maria Grazia (born in July 1889).

My mother can't believe it! She said he never spoke about his life in Italy, and he only mentioned his siblings Eva and Noé.

In the column of Giuseppe's birth record a note says he married Maria Castaldi in August 1914. I have no further details, but I do know Giuseppe did not die in World War I. (Here is a website where you can search for Italian casualties of WWI.)

My surprise great aunt Maria Grazia Leone's 1889 birth record.

Maria Grazia may have married, or she may have died in her youth. The vital records are not available online for me to find out her fate.

I'll never know why my grandfather didn't mention these siblings. Maybe Maria Grazia died when my grandfather was a little boy or before he was born. But what about big brother Giuseppe? I do hope I'll find out what became of him.

Many times in this blog I've encouraged you to gather every document you can from your ancestral hometowns. (See the links at the bottom of this article.) You could be related by blood or marriage to most of the town.

Use This To Your Advantage

The Giuseppe and Maria Grazia Leone story is another reason to look closely at every genealogy record from your ancestor's hometown.

• Find out at what age couples married and had children.
• See if your ancestral family has a big gap in years between children's births.
• Look in the town's birth and death records for babies who were stillborn or died as infants.

Maybe you'll find a shocking, previously unknown great uncle or aunt for your family tree, too!

You may also enjoy:

• How to Use the Online Italian Genealogy Archives
• Step-by-Step Discovery of My 5th Great Grandparents
• Where Have You Been All My Life?

The Out-of-Wedlock Child in Your Family Tree

1809 birth record for foundling Maria Giuseppa.
I had the wrong image here before!

When I began researching Italian birth records from the 1800s, I noticed something curious.

In one small town, a few babies were born each year to:

• padre incerto (father uncertain)
• madre ignoto (mother unknown)
• genitori ignoti (parents unknown)

These babies were often listed separately from the other births and labelled projetti. I asked my friend to explain this to me. He is an expert in Italian genealogy who comes from one of my ancestral towns.

He told me the projetti were babies abandoned at birth. The father's identity was unknown, and the mother's identity was known only to the midwife.

What's an Unwed 1800s Mother To Do?

Try to imagine a young woman in Roman Catholic Italy in the 1800s who finds herself pregnant and unmarried. Maybe the man refuses to marry her. Maybe he refuses to acknowledge that he is the father of the baby.

What does this young woman do to avoid bringing dishonor to herself and her family?

Angelamaria Biferno is named after a river in the area.

First she would have to hide her pregnancy, possibly leaving town for made-up reasons. Then she could deliver her baby with the help of a midwife who would keep her identity a secret. The midwife (levatrice in Italian) would report the birth to the mayor without naming the baby's mother or father.

If you are the descendant of an abandoned infant, you may find the birth record in the town where the baby was raised. The baby might have been raised in a foundling home, a foster home, or a monastery.

This was a system that saved the pregnant woman from shame and gave the baby a chance at life.

A Sign to Identify the Baby

There was a way for a mother to reclaim her abandoned infant. At the time of birth, she could leave with the baby some item that only she could identify. It might be something as simple as a piece of cloth or a blanket.

She could later claim the baby by describing the item and the date of birth. This rarely happened.

A Unique Name for the Baby

The midwife or the mayor himself named the abandoned babies. They used a last name (cognome in Italian) that was different than the names in that town. Sometimes it was a geographical name. A handful of names commonly used for projetti include:

• Innocenti, meaning innocent one
• Projetti, the same as the registry of abandoned baby birth records
• Esposito, meaning abandoned
• Incogniti, meaning unknown

This can lead to confusion for family tree researchers because the baby kept this name for life. A man named Esposito, abandoned at birth, would pass the name Esposito on to his children, and his sons would pass it on to their children.

Don't assume that your Esposito ancestor was an abandoned baby.

In my grandfather's hometown of Baselice, Italy, they preferred to name abandoned babies after rivers and towns. They did not give them a name that marked them for life as abandoned.

Or Maybe It's Not an Illegitimate Birth

Now let me throw a monkey wrench into your family tree research. Sometimes the abandoned baby was not born out of wedlock.

The book "Sacrificed for Honor: Italian Infant Abandonment and the Politics of Reproductive Control" by David I. Kertzer states the following:

It is known that in Milan and Florence ... the majority of abandoned children were legitimate.

We can guess: poverty, deformity, severe illness. Imagine how heartbreaking that must have been for the woman giving birth.

Two Examples

The images in this article include two examples of projetti from the rural town of Baselice. I found a handful of projetti recorded each year from 1809 through 1860.

The first image does not give the foundling a last name. Since the document explains how my fifth great grandfather, Nicola Pisciotti, found the baby, I thought he and his wife had raised her.

The document says my ancestor, age 60, found the baby girl outside his door. She had no identifying item that the mother could use to reclaim her baby.

The mayor names the baby Maria Giuseppa and turns her over to a nurse. So the baby girl is probably raised in a foundling home or in the monastery along with many other projetti.

The second image is the birth record of Angelamaria Biferno in 1815. Biferno is not a last name found in the town of Baselice, but it is the name of a nearby river. Dorodea Colucci was the midwife who delivered Angelamaria and most of the babies in this town. She goes to the mayor and presents the baby, wrapped in a black rag, but without any other sign from its mother.

Angelamaria Biferno grew up in the same town and married there. Unfortunately she died at age 28 and had no children.

Angelamaria Biferno is a big puzzle for me. Marriage records from 1843 include another Angelamaria Biferno, born about the same time, and in the same town. She was also an abandoned baby. She married a man in Baselice the same year the first Angelamaria Biferno died. They had at least six children together.

The confusing, overlapping case of the two Angelamaria Biferno's needs detailed examination. Let's save that for another day.

To learn more about the Italian Infant Abandonment system, see the FamilySearch Research Wiki.

You may also enjoy:

• My 5th Great Grandfather: A Random Act of Kindness?
• Can Genealogy Research Be Painful?
• What's Napoleon Got To Do With Italy?