Sometimes in our research, we come across an ancestor who did a lot of land deals. And you may want to understand what he was up to in more detail. Putting those land records into a timeline can really help. These are sometimes called “in and out” tables and may not necessarily be intended as timelines, but if you set up your spreadsheet or table in a way that allows you to sort by date, that’s exactly what you’ve created. You can follow a particular piece of land AND you can follow a person’s land transactions.

While working on my George Long project, I needed to disambiguate two George Longs in Hancock County, Ohio. One bought and sold land frequently in that county, the other owned one piece of land. (Can you guess which one mine was?)

Here is the table. The first image shows each piece of land next to each other, color coded to match. You’ll notice that in some cases, there’s only one entry. That means I did not find the “in” or “out” deed for that land in the timeframe I was working in. The land could have been inherited or disposed by will rather than in the deed books I was looking through. More research could be done to find those. (However, this is NOT my George Long, so I don’t think I’ll be doing that research.)

The above table is organized by piece of land. However, because of how I captured the data, one click turns this into a timeline.

If you are paying attention, and have read this far, you may have noticed that the first table is in fact NOT entered such that it will sort properly on the date. And if so, you get a gold star for the day. I had to go fix that for this blog post. It sorts alphabetically, essentially, so if you type of the names of the months, they will not be in proper month order. I had to go back and put the dates in by number instead of name so it would sort properly.

Couldn’t “they” have named the months in some kind of alphabetical order? I prefer the names over the numbers, myself, but that doesn’t sort right, so humbug.