Harnessing Airtable for Tax Record Analysis

In Episode #339 of Research Like a Pro, Nicole and Diana discuss customizing an Airtable research log for tax research. Tax records are invaluable for genealogy research because they were taken annually, filling in the gaps between federal censuses. The challenge is finding a good way to track and analyze the data. Airtable is a favorite research log tool, and by adding a linked table to the log, researchers can tame tax data and make it work for them.

Diana shares a case study using her ancestor, Henderson Weatherford, who resided in Dallas County in 1860 and appeared on a tax list that same year. She wanted to track the Weatherfords who showed up in Dallas County by 1850 to see if there was any connection to her ancestor. Nicole explains the technical setup in Airtable, starting with the RLP with DNA 4.0 (2024) Airtable base template and adding a new table by matching the headings in the new table to the headings on a tax list. Diana explains how she analyzes the data in the Airtable research log by grouping the tax table by an individual to view their economic status. She gives practical applications of her research process and concludes that tax records are valuable in genealogy research. Listeners will learn how to use Airtable to track and analyze tax data to further their genealogy research.

This summary was generated by Google Gemini.

Links

Customizing an Airtable Research Log for Tax Research - https://familylocket.com/customing-an-airtable-research-log-for-tax-research/

Back to the Basics with Tax Records -  https://familylocket.com/back-to-the-basics-with-tax-records-part-1/

RLP with DNA 4.0 (2024) Airtable base template - https://www.airtable.com/universe/creator/usrsBSDhwHyLNnP4O/nicole-dyer

Sponsor – Newspapers.com

For listeners of this podcast, Newspapers.com is offering new subscribers 20% off a Publisher Extra subscription so you can start exploring today. Just use the code “FamilyLocket” at checkout. 

Research Like a Pro Resources

Airtable Universe - Nicole's Airtable Templates - https://www.airtable.com/universe/creator/usrsBSDhwHyLNnP4O/nicole-dyer

Airtable Research Logs Quick Reference - by Nicole Dyer - https://familylocket.com/product-tag/airtable/

Research Like a Pro: A Genealogist's Guide book by Diana Elder with Nicole Dyer on Amazon.com - https://amzn.to/2x0ku3d

14-Day Research Like a Pro Challenge Workbook - digital - https://familylocket.com/product/14-day-research-like-a-pro-challenge-workbook-digital-only/ and spiral bound - https://familylocket.com/product/14-day-research-like-a-pro-challenge-workbook-spiral-bound/

Research Like a Pro Webinar Series - monthly case study webinars including documentary evidence and many with DNA evidence - https://familylocket.com/product-category/webinars/

Research Like a Pro eCourse - independent study course -  https://familylocket.com/product/research-like-a-pro-e-course/

RLP Study Group - upcoming group and email notification list - https://familylocket.com/services/research-like-a-pro-study-group/

Research Like a Pro with DNA Resources

Research Like a Pro with DNA: A Genealogist's Guide to Finding and Confirming Ancestors with DNA Evidence book by Diana Elder, Nicole Dyer, and Robin Wirthlin - https://amzn.to/3gn0hKx

Research Like a Pro with DNA eCourse - independent study course -  https://familylocket.com/product/research-like-a-pro-with-dna-ecourse/

RLP with DNA Study Group - upcoming group and email notification list - https://familylocket.com/services/research-like-a-pro-with-dna-study-group/

Thank you

Thanks for listening! We hope that you will share your thoughts about our podcast and help us out by doing the following:

Write a review on iTunes or Apple Podcasts. If you leave a review, we will read it on the podcast and answer any questions that you bring up in your review. Thank you!

Leave a comment in the comment or question in the comment section below.

Share the episode on Twitter, Facebook, or Pinterest.

Subscribe on iTunes or your favorite podcast app.

Sign up for our newsletter to receive notifications of new episodes - https://familylocket.com/sign-up/

Check out this list of genealogy podcasts from Feedspot: Best Genealogy Podcasts - https://blog.feedspot.com/genealogy_podcasts/