I love the Bureau of Land Management’ s General Land Office Records. I do lot of research is in the state of Mississippi which is a public land state so the BLM records are invaluable. I am working on a FAN* project involving my favorite brick wall, James Simmons (1764-1843). James’ first known land purchase in the Mississippi Territory was in 1816 (the BLM records show 1820 because that is when the note was paid off but the transaction was in 1816). I want to to see who bought land in the same township/range as James but I want to narrow it to the same time period. James’ property was in T5NR11W. I can easily do a search for everyone in that township/range but I get a list that is 6 pages long. I can get a consolidated list by clicking the Printer Friendly button in the upper right corner which is better but the list is alphabetical and not in date order. It is easy to miss something when you just scan the list. Here is what it looks like:
This table is screaming, “Put me in a spreadsheet!” I simply copied and pasted the table straight into an Open Office spreadsheet. MS Excel is my normal go to but in this case no because of the dates (MS Excel does not recognize pre 1901 dates). It pasted beautifully. I had to do two things first.
1) Format > Merge Cells
2) Highlight the date column and then Format > Cells. Change the date so that you can see a 4 digit year.
Now I can sort. Highlight the entire spreadsheet and then go to Data > Sort. Sort by Column C (the date column) and choose Ascending.
And here is what it looks like now:
My James is right at the top. I can cross reference this against everyone that was in the same section or the adjacent sections if I wanted to. It is important to know that Section 33 happens to be on the border between townships so I need to do the same thing for T4NR11W to pick up those sections to the south that border Section 33, namely Section 4 of T4NR11W. I am a visual person so once I have my names and dates I use History Geo to show my the layouts and the proximity of the plats. You can see that the dates are on the map but I prefer to have the names and dates in my hand up front because again, if I just scan the map I might miss something.
Screenshot from History Geo
* FAN = Friends, Associates, Neighbors. This acronym was coined by Elizabeth Shown Mills. It is a research technique where you look to the people that surround your ancestor in hopes of finding out information about your ancestor. You can read more about it HERE.
Copyright © 2017 Michèle Simmons Lewis