It has been some time since I posted about the Charles and Caroline Carson family of New Jersey. I needed to remind myself where I left off with respect to the census information I had collected thus far. I needed a form to see my census data at a glance. With only a bit of searching on Pinterest, I found a promising census comparison worksheet, posted by Jenny Lanctot who writes the “Are My Roots Showing?” genealogy blog.
Jenny has graciously made her census comparison worksheet available for download at this link. Thank you, Jenny. I like this form, in that there is room to record information from up to five different census enumerations for one couple and up to fourteen of their children. It is similar to the way I have previously laid out census extractions in a table in Microsoft Word, but with more columns. More columns equals more data points for correlation, which is a very good thing when you are writing up your research with accepted genealogical standards in mind.
I downloaded her form and began doing the data entry in short order. It did not take me long to realize that I actually wanted to see a bit more detail than the form allowed for, so I began tweaking it just a bit. In the column on the left where the couple’s marriage information is recorded, I added a row to record the marriage officiant by name and role. I added an additional row below Twp. (for Township) to note a smaller jurisdiction, abbreviated as P.O. (for Post Office), since that level of detail is included on some census enumerations. Finally, on the main tab, I also added a row for the street address when known, as this is important for tracking our urban ancestors.
The main table in my census comparison worksheet allows me to visualize 50 years of census data at a glance for one nuclear family (in this case, Charles and Caroline Carson of New Jersey). I have hidden the ribbon (using CTRL+F1 in Excel 2010) and the rows near the bottom for more siblings to make the completed worksheet easier to see in this screenshot.
In my example, I chose to only include United States Federal census information, but you could just as easily create a table that includes state census enumerations or non-population schedules such as agriculture or manufacturing. I also chose to input ages, birthplaces and occupations to improve the ability to compare across census years.
The biggest change I made was to include additional tabs in my workbook, one for each census year extracted on the main page of the form. I renamed each tab to correspond with the year, then I attached an image of the actual census page that I had previously downloaded. Lastly, I included a carefully crafted source citation so that I can simply copy and paste it into other documents or blog posts when needed.
I added more tabs in my workbook to include an image of the census page and a source citation, one tab for every census year on the main table. This image from the 1870 Federal census shows Caroline Carson living with an unidentified male named Lewis Rainier in Mercer County, New Jersey. We have yet to learn what relationship the two shared.
This is a time-consuming process, and one that I am unlikely to do for every family that I am researching, as I normally would simply extract the relevant census information into a note linked to a census “event” in my RootsMagic database. But, for those families that present brick wall problems, or for those families that I am writing about, it is a useful endeavor. If you have a genealogical problem you have worked on for years without a resolution, then I would recommend compiling your data in a format that allows you to visualize and correlate information differently, such as a census worksheet, a timeline or mind map.
Updated 22 March 2018. Follow-up post has link to download the census workbook and instructions for its use.
http://ancestorroundup.com/census-comparison-worksheet-revisited/
I love these additions, Dawn! Thanks for sharing. Any chance you could share the actual file so I don’t have to recreate it myself? If not, no worries… the screenshots alone are incredibly helpful. 🙂
Hi Jen, I am happy you like the expanded worksheet. I created a blank and will send it to you shortly. I think you will find it useful to look at your data this way. My example covered the 1850-1900 time period, but you could do something similar for other years. Having the image and complete source citation on other tabs is a real time-saver. Other examples on my blog (search for “census”) will show other matrices for comparisons of Federal and state census enumerations. Thanks for stopping by and leaving a comment.
Dawn Bingaman
I was also wondering if you share your blank worksheet as well. I would appreciate it!
Hi Hope,
Thanks for stopping by. Check your e-mail.
I would also like one.
Hello Carolyn,
I had a follow-up post with a link to the download and more information about how to use the form here:
Good luck with your research.
Love your expanded worksheet! I would love to have the blank one! Could you share with me? 🙂 Thank you!
Hi Tracey,
Sorry I missed your comment before now. I just sent you a blank worksheet. Thanks for stopping by the blog.
A wonderful and useful worksheet. Could you please share a blank worksheet with me? Thank you.
Hi Barbara,
Thanks for visiting the blog. A copy of the spreadsheet will be in your mailbox momentarily.
I have struggled to organize the tidbits found on numerous family lines. This looks to be the very thing that I need! May I please have a copy of the spreadsheet workbook. It may actually preserve my sanity.
Hi Willie,
My census worksheet is just one way to organize census data, but one that I think helps visualize the family better. I will be sending you a blank workbook shortly. I hope you find it useful. Thanks for visiting the blog.
Dawn, Great form! I was looking for something like this while taking the BU course. Ended up converting a couple of .pdf’s… not pretty, but workable. This one is exactly what I needed. May I please have a copy? Thanks!
Hi Caroline,
I cannot take full credit for it, I just modified someone else’s form as described. But it is a great way to visualize a family over 50 years to make sure you have correctly identified them in the census. Will send you a form in a few minutes.
Is there anyway I might have a copy of the form as well? I need to put ‘learn spreadsheet formatting’ on my to-do list.
Hi Margaret,
I just sent a copy of the worksheet to you via email. I hope it brings you new insights for your family research. Happy Holidays.
Dawn,
Could you please send me a copy of the expanded worksheet?
I’ve got one of those families that needs this.
Thanks!
Claire
Sorry for the delay, Claire. Still recovering from SLIG. Check your inbox for the requested spreadsheet.
Dawn, fantastic form would it be possible to have a copy of the worksheet?
Thank you for a great post!
Alex
Check your mailbox, Alex. Thanks for stopping by. Hope you find the form useful.
Hi Dawn, I would also like a blank form. Thank you
Hi George, I just sent you a copy of the form. Good luck with your research.
Hey Dawn, Would you please send me a copy of the form? I like your additions! Thanks, Judy
Thanks, Judy. I just wrote a follow-up article in the last few days where I provided a download link to it.
http://ancestorroundup.com/wp-content/uploads/2018/03/census-comparison-worksheet-blank.xlsx
Good luck in your research.
You are awesome! Thanks!
In my early days of family history research, I apparently neglected to save critical information for some censuses that I copied. Now I can’t tell what year the census in question was taken just by looking at the heading. It appears to be an early one. I searched Google and I am hoping that your spreadsheet might help me figure this out. Or maybe I can just learn a new skill in my quest. Thank you in advance. ~ Sheryl
Here is a link to the worksheet: http://ancestorroundup.com/wp-content/uploads/2018/03/census-comparison-worksheet-blank.xlsx.
Each census header should say something like Fourteenth Census at the top of the form. The Fourteenth Census would have been the 1920 census. If the census includes a relationship to the head of household, it would be 1880 and after, as the 1880 census is the first to include those details. If it includes specific ages and other household members by name, it is 1850 or later. Good luck!
TIP: Open the download and save it as a template. This way you don’t accidentally overwrite the original blank file when you start filling it out. Excel will automatically save it to your user templates folder or you can save it somewhere else.
Thanks for sharing this. I’ve been looking for key forms to use in my research. This definitely makes the cut!
Thank you, Tammy, for sharing your tip with my readers. Hope you gain some new insights.