Making a Research Log Spreadsheet

I realised recently that I needed to make a research log. I'm often guilty of getting caught up in the
thrill of the chase and then forgetting to note down the sources that I've been researching and how far I've got.

I wanted to make a spreadsheet that was simple enough to fill in, so it wouldn't feel like a chore I had to do after I've finished researching for the day. However, I wanted it to be comprehensive enough that I could note down:

• enough information to help me understand what I did on a certain date
• the documents and sources I used
• how I came to the results/conclusions I reached at that point in time 
• to use it to document the future research I wanted to do

UK Census Timeline

William the Conqueror ordered a 'Great Survey' to find out who owned what over much of England and parts of Wales. This was completed completed in 1086 and compiled into what became known as the "Domesday Book".

However, it wasn't until the Census Act 1800 which enabled the first Census of England, Scotland and Wales to be undertaken that the census begun proper in the UK.

Since then the census has taken place every 10 years since 1801 – apart from 1941 due to WWII.

The 1841 census was the first British census which aimed to record details about every citizen making it a treasure trove for genealogists.

A register was taken in 1939 shortly after the outbreak of WWII. As it records many personal details of individuals, it has become an invaluable census substitute. Not covered by the 100-year rule it will be available online around 2016.

During December 1942, the 1931 census was destroyed by fire in storage in Hayes, Middlesex meaning that it is gone forever - and thereby increasing the value and importance of the 1939 register.

It's been difficult to get accurate figures for the census before 2011, but I found that the UK population increased by over 42 million between 1841 and 2011.

The data is as follows:
1841
England and Wales - 15,914,148
Scotland - 2,620,184
Northern Ireland - 1,648,945
Total - 20,183,277

2011
England and Wales - 56,075,912
Scotland -5,295,403
Northern Ireland - 1,810,863
Total - 63,182,178

As I wasn't able to access the references within the first two sources, I've linked to the sites I used - therefore we just have to trust that the data has been added to these sites without introduction of error.

Download PDF



Sources:
POPULATION OF GREAT BRITAIN & IRELAND 1570-1931. 2014. POPULATION OF GREAT BRITAIN & IRELAND 1570-1931. [ONLINE] Available at: http://homepage.ntlworld.com/hitch/gendocs/pop.html. [Accessed 21 November 2014].
Demographics of Northern Ireland - Wikipedia, the free encyclopedia. 2014. Demographics of Northern Ireland - Wikipedia, the free encyclopedia. [ONLINE] Available at: http://en.wikipedia.org/wiki/Demographics_of_Northern_Ireland. [Accessed 21 November 2014].
UK Census - ONS . 2014. UK Census - ONS . [ONLINE] Available at: http://www.ons.gov.uk/ons/guide-method/census/2011/uk-census/index.html. [Accessed 21 November 2014].

Web Resources: WieWasWie

The English WieWasWie logo

WieWasWie is the premier site for finding the records of your ancestors in the Netherlands. This site
is exactly what a records search site should be. It's very easy to use, provides relevant search options and allows you to download scans of the records it has available.

Created as the successor to Genlias by STAP with ownership transferring to Centraal Bureau voor Genealogie during November 2014, Wiewaswie has around 10,000 visitors per day and looks to be expanding on a monthly basis.

Common Genealogy Sources

Not all sources are created equal! This post lists just a few of the documentary evidence that you may find during your genealogical adventures. As you'll notice, most pieces of documentary evidence are create due to an event, such as being born or getting married.

Primary
Normally created at or near the actual recorded event and are more likely to be accurate. Originals or copies are normally considered primary sources:
Birth certificate
Marriage License
Death Certificate (Information relating to the person’s death)
Census
Military Records
Naturalisation Records

Secondary
Typically created after the fact – sometimes many years afterwards – and therefore tend to be less reliable:
Delayed Birth Certificate
Marriage Certificate
Death Certificate (Everything but Information relating to the person’s death)
Obituaries
Cemetary Markers

Download PDF

Resolving a name confusion

In this post, I'll be writing about a brick wall that I've faced for some time. I'll write about the method
I used to get past it. While it may not be exactly the same as a name confusion in your family tree, I do hope that it will provide some potential ways you can get past your brick wall.

The Brick Wall

In my family tree I have people called Henri Magermans and Ida Ackermans, but I didn't have their date of birth. When looking online, I could only find a few records. This was odd as I was expecting many more.
I was missing their birth, death, and wedding records as well as the records some of the children I already knew they had. I was also stuck because I didn't have any information on their parents or siblings.
This was 4 years ago in the days of the old site Genlias; so I decided it was time to tackle this again...

What I already knew
I knew that they both lived in the Netherlands. I also knew that Henri was a  joiner as it says this on the marriage record for my great grandparents. I also had a note from 2010 when my Oma told me that there may have been another child called Gonda.
I also knew some of the children they had, including Johannes Joseph Magermans, for whom I had the birth and marriage record.

Next Steps

Using wiewaswie, I found people called Pieter Hendrik Magermans and Johanna Ida Ackermans. They lived at the same time as Henri and Ida and in an area close by.

With this information, I found that Pieter Hendrik Magermans was also a joiner and that he had a child called Hubertina Aldegonda Magermans.

I asked one of the Facebook groups I'm a member of to give me some help with this and they thought that Henri and Ida were also Pieter Hendrik Magermans and Johanna Ida Ackermans, but I wanted a way to be sure. Someone gave me a link to scans of their birth certificates and I saw that this site also linked to scans of the old Netherlands Bevolkingsregisters.

I made a spreadsheet to make a timeline of all the births, marriages, and deaths for ‘both’ couples and their children. I colour-coded the children who had multiple entries, so I could see if the parents name stayed stable for multiple records for individuals. What I found was:

1. The parents names did stay stable for individual children, for example a parents name on the birth record and marriage record for Johannes Joseph were the same. 
2. That each child was born in a different year - if multiple children were born within a year, this would have hinted that I was looking at two couples rather than one.
3. That the main 'name change' seemed to occur after they moved to Oud-Valkenburg from Schin op Geul. But that one birth had the full name and then they went to middle names.

A spreadsheet timeline to understand the individuals I was following.

BUT, importantly, this didn't 'prove' that they were the same couple. So I starting thinking about how to prove whether Henri and Ida were Pieter Hendrik and Joanna Ida.

The solution
At this point, what sprang to mind was that I needed to find the whole family documented at the same place and at the same time. The most obvious thing to do was to check the population records. 

After scrolling through many MANY scanned pages, I finally found the whole family in the Oud-Valkenburg census for 1850-1900.

My ancestors in the Oud-Valkenburg census for 1850-1900

This population register showed the couple as Henri and Ida, but has all of their children, including the children I already knew about and with dates I already had. Finding Henri and Ida's birth records, also led to finding the names of their parents.

So, I’m excited to have found that even though they both decided to go by their middle names in later life, that they are the same people! I had read that this name change was fairly common, but I hadn't come across it before and felt daunted that both of them had opted to use their middle names.

In future posts, I'll be writing about the resources that I used to find out all of this information, so add me to your blog reader, or sign up to receive new posts by email!

Find My Past: Remembrance Weekend Live Broadcast

I just noticed the Find My Past had an epic 2 and a half hour broadcast. It covers:

• How to get started
• Top Tips for Researching Your Family History
• What the Census Tell Us
• Exploring British Newspapers
• Discover Your ancestors in the Military Records
• Tracing Irish Ancestors
• Discovers Ancestors in International Records

It all ends with a Q&A on Facebook with Findmypast experts. More information on the broadcast and the experts involved can be seen on the Findmypast website.

I'm currently watching it myself, and see that while it concentrates on the FindMyPast website, the tips and ideas are relevant regardless of your website of choice.

I've embedded the broadcast below, but it can also be viewed on the LiveStream website.

Hope you enjoy it!

YouTube: Barefoot Genealogist

The first resource I'd like to share is that of the Barefoot Genealogist.  Crista Cowan aka the Barefoot Genealogist has been creating helpful videos via Ancestry.com on YouTube.

Some things to bare in mind are that these videos are created for a US audience and users of Family Tree Maker / Ancestry.com, but saying that most of the tips and methology are relevant for anyone making a family tree regardless of the technology they use.

The videos tend to last between 20 to 30 minutes with topics ranging from 'Back to basics' (see below) to 'Proving Native American Ancestry', so there should be enough for most people to get started and perhaps break through any brick walls they are currently facing.

I've embedded Crista's playlist below starting from Genealogy 101, which is a great video to help you get started or refresh some techniques:

Do you have any great YouTube resources you'd like to share? Let me know in the comments!

Hello and Welcome

Hello and welcome to my little blog!

I first started compiling my family tree in 2010 by asking my Dutch grandparents about their parents, and so on. Then I took a break for a few years due to work and then illness.

I started again around the beginning of the year and have been learning a lot about sources and developing my ideas about how I want to present the information and store it within my family tree application.

I’ve decided to start a blog as a way of sharing what I’m learning about compiling a family tree, and more importantly, things I learn about my ancestors, their occupations, and the places they lived.
As I’m now expecting my own child, I’m hoping that this blog will serve in the long term about my journey back into the past, while looking after the future.

The 12 week scan!
We affectionately call our baby ‘Meeple’ after our love of boardgames.

I’ll be writing about my ancestors, but also about resources such as books and websites that I find useful along the way.

At the moment, my family seems to have roots in England, the Netherlands, and Belgium. So, information I post will be relevant to others trying to find their ancestors in these countries – and if anyone has any great advice, please let me know in the comments!