Using Google Books for genealogy is a successful tool to many. A Gem’s reader shares the remarkable story she uncovered using the tips for using Google Books she learned from a recent Genealogy Gems Premium podcast.
From Genealogy Gems Premium member:
“Hi Lisa,
I was just listening to the newest Premium podcast concerning filtering the lists on Google Books (Premium episode 137). I would like to relay my story for using your hints and tips on Google.
My great-grandfather was a Confederate soldier. At the age of 48, he married my great-grandmother and my grandmother was born the next year. I found much to my dismay, that he committed suicide when my grandmother was a few weeks old. It was stated that he had what would be described today as post-traumatic stress disorder, and the burning of the court house where he worked as a county clerk set off something. My Dad was born on what would have been my great-grandfather’s 90th birthday.
I have known for about 30 years that my great-grandfather wrote articles under a pen name. My aunt told me she had been told he wrote articles about the scenery in southern Utah where he lived. I searched and searched and never found any of his articles. Then, I had a breakthrough. I found the pen name by using several tips you mentioned for using Google. The pen name was Lock Melone. It was spelled differently than I had been told.
It turns out, he was a very well-known humorist. One of his stories appears in a publication alongside an article by Mark Twain. (He wrote articles in the 1870s and 1880s.)
Now, back to your tips on Google. I was Googling, checking all the old newspapers I could find to collect his writings. One of the sources continually mentioned in Google Books was a literary magazine called The Californian. These were not all free on Google, but I was not to be deterred after all these years! I used the basic information and time frames listed in Google Books and looked at WorldCat. That led me to e-books and to some of the holdings in universities around the country.
As of today, I have found 69 of his articles! They have made an ancestor who I thought had a rough life with a tragic end, a new person, full of life and laughter! I am sure his stories are based on events that occurred during his “real life” adventures. He lived life to the fullest, traveling a great deal, and saw the world through a light heart.
I am continuing to search for more articles and have begun to compile his writings to give to my children and cousins for a Christmas present this year (if I can figure out how to put it all together!) With my grandmother as his only child, I will have given his life to all his descendants, a very special chore on which I have worked on with great pleasure.
Thanks for the tips on Google and other sites you have given over the years.”
This Gems member is certainly on the right track in many ways. She figured out how to harness the power of Google to search for the proverbial needle in a haystack—not just her grandfather’s articles but articles written under a pseudonym! Good for her for using Google Books and WorldCat. That’s a great combination. You can learn more about using WorldCat for genealogy in my book How to Find Your Family History in Newspapersand in the Premium video Getting the Scoop Part 2: Tech Tools for Newspapers.
Follow-up Ideas for Using Google Books for Genealogy
Here are a few follow-up suggestions relating to finding issues of a literary magazine or another scholarly publication like The Californian:
First, turn to another powerful free tool in the Google toolbox: Google Scholar. It takes Google Books to the next level and you may hit on some things that Google Books may miss. Refer back to Premium Podcast 136 for a discussion of Google Scholar for genealogy, and Chapter 11 in my book The Genealogist’s Google Toolbox, Second Edition.
Second, remember that sometimes serial publications change names, or two different ones may have the same name. Wikipedia’s not the most expert source, but its article on The Californian says something you can follow up on. The Californian was published from 1880 to 1882, as a continuation of the earlier Overland Monthly which had stopped in 1875, and then in 1882 it switched back to its old name. This means you should look for both titles.
A third idea may be to check e-bay for back issues of old magazines and journals. Sometimes, it’s cheaper and easier to buy them than to try to borrow them through inter-library loan. E-bay does happen to have a CD version for sale of The Californian issues from 1880 to 1882. I talk more about finding family history items on e-bay in the Premium Podcast episodes 16, 76, and 131.
Lastly, don’t forget JSTOR. JSTOR is a shared digital library for scholarly journals and the like. It launched in 1995 to serve university and college libraries, running out of space to store old journal issues. Today, it includes over 2,300 journals and thousands of other materials. It’s even started including books. Over 50 million pages are digitized, with another 3 million being added every year.
The nice thing about JSTOR is that you don’t have to be affiliated with a major library to get access now. Individuals can register for free access allowing them to read some materials online. They offer free access to their Early Journal Content collection of scholarly content published before 1923 in the U.S. (and before 1870 in other parts of the world.) That collection alone has nearly a half million articles from over 200 journals.
Unfortunately in this case, JSTOR doesn’t have The Californian or Overland Monthly in its collections. But one can certainly use JSTOR to search for other journals. JSTOR is just a great resource for anyone to use when searching for historical articles, especially those you may come across in Google Scholar without the full article text.
Your Google Books for Genealogy Success Stories
It is so rewarding to hear your success stories in using Google Books for genealogy. Your stories inspire others. Please feel free to share your experiences in the comment section below.
Keep Reading: More Gems on Using Google Books for Genealogy Success
Original air date: 10/8/20 Join me for Elevenses with Lisa, the online video series where we take a break, visit and learn about genealogy and family history.
In this episode we’re going to take many of the things we’ve learned in past episode of Elevenses with Lisa and apply them to one of your genealogical problems. My goal isn’t to find the answer myself, but rather to provide a toolbox of strategies that you can use to experience the joy of the discovery yourself when researching a home or location, as well as in a wide variety of other genealogical situations! Keep reading for notes that accompany this episode.
Cynthia Owens is a regular viewer and participant in the Live chat each week during Elevenses with Lisa. She emailed this photo and wrote “This picture was with my mother’s belongings…photo of a house in Omak, Okanogan, Washington with only an address written on it. 308 S. Main, Omak, WA. I have hundreds of photo’s (B & W) that have no information on them and a lot of people who I don’t know. I have a gold mine and no idea how to mine it.”
The house photo in Cynthia’s family collection.
Cynthia said that so far she has found the names of the last two owners in county records and some directories. She also determined that the house was built in 1928. She writes, “I have a lot of family on both sides of my parents who could have owned it.”
Formulate Your Research Question
The research question in this case boils down to: Who owned the home at 308 S. Main, Omak, WA in the 1930s?
Compile Known Family Names
We start by compiling a list of family surnames that we will be on the lookout for. These are families who are known to have lived in Washington state during that time frame.
Cynthia’s mother’s family names:
Woodhead
Patience
Cynthia’s father’s family names:
Tucker
Stubbs
Tonks
Answer the Question Does the house still exist today?
To answer this question, we turn to the free Google Earth Pro software. By simply searching the for the address and using Street View we are able to determine that yes, it is. Google Earth also allows us to obtain a high-quality image.
The house in Google Earth’s Street View today.
Google for Land Records
I conducted a simple Google search: Okanogan County Land Records
The results:
The Central Regional Branch of the Washington State Archives
“The Central Regional Branch provides archival and records management services to local government agencies throughout Benton, Chelan, Douglas, Franklin, Grant, Kittitas, Klickitat, Okanogan, and Yakima counties.”
Special Guest: Kathy Nielsen, Librarian Kathy Nielsen is a reference librarian and an educator. She has a masters degree in History and in Library Science. Kathy is currently a popular genealogy speaker on California’s Monterey Peninsula. She incorporates her skills as an historian, a storyteller and a librarian in her search for her family’s history. Kathy Nielsen stopped by to offer suggestions on obtaining land records. Watch Elevenses with Lisa episode 20 on House History featuring Kathy Nielsen.
The FamilySearch Wiki
Visit the free FamilySearch Wiki here. Search for the county in the wiki and then click on Land Records.
County Auditors Department
Where land records are located.
You can do a title search.
The records may not be online.
Email or call and inquire what the options are to access the records or have a search done.
Access varies by county.
Follow the chain of ownership back in time:
Grantee = the person who bought the property
Grantor = the person who sold the property.
Real Estate Websites
Trulia.com
Zillow.com
These sites don’t provide owner names but do show you recent transactions.
Result: The house was sold in 1997. It went on the market briefly in 2013.
Assessor’s Office (Tax Records)
These are typically only available to the current owner.
More Places to Look for Real Estate Related Information
City Directories
City directories are usually published yearly. Look also for Reverse Directories that allow you to look up the address in order to find who lived there. Kathy suggests contacting the local public library staff to inquire about City Directories and other records. Many libraries are currently staffing online reference chat.
State Libraries
Kathy recommends expanding out from the local area library to nearby communities, and the state. The Washington State Library is also currently answering questions. They have a genealogy department and city directories.
WorldCat.org
WorldCat is the world’s largest network of library content and services. The online catalog that itemizes the collections of 17,900 libraries in 123 countries and territories.
National Register of Historic Places
According to the website: “The National Register of Historic Places is the official list of the Nation’s historic places worthy of preservation. Authorized by the National Historic Preservation Act of 1966, the National Park Service’s National Register of Historic Places is part of a national program to coordinate and support public and private efforts to identify, evaluate, and protect America’s historic and archeological resource.” Click here to learn more about and search their digital database.
Department of Archaeology and Historic Preservation (Washington State)
From the website: “On this site you will find information on historic buildings, the archaeology of Washington State, how to navigate our regulatory processes and how to nominate properties to the State and National Register of Historic Places.”
Neighbors
Contacting and talking to neighbors is often one of the quickest and easiest ways to gain information. The 411.com website offers a free reverse address lookup. The results will give you the name of the current owner and residents, and even plot nearby neighbors (with names) on a map.
Researching the Home from Home
If you’re unable to research in person, make significant headway with these online resources.
Historical Societies
Google to find the official website of the historical society located in the area where the house is located. These sites may include searchable databases and information on how to contact them for resources and lookups.
Result: The Okanogan County Historical Society features a searchable database.
Facebook
Search Facebook for the name of the county historical society in the area where the house is located. Facebook pages often include more up to date information than the official website.
Old Maps
Depending on the town and area, you may be able to find an old map from the approximate time frame that includes details on homes. Two excellent free resources are:
Davidrumsey.com
Historical maps in the Layers panel of Google Earth Pro
Search at Genealogy Records Websites
Searching for various combinations of the address, town and surnames from the family tree may lead you to an answer. Here are a few examples of searches run at Ancestry.com and FamilySearch. (Your results may vary depending on the date you are searching):
Keyword: (address) 308 Main St, Omak (exact)
Results: 25 (These were not all exact)
Residence: (town) Omak (exact) and Keyword: (address) 308 Main St. (exact)
Results: 5
Search each surname in Okanogan County at Ancestry.
Results for Cynthia’s mother’s family names:
Woodhead (Paul Woodhead married in Okanogan in 1941)
Patience (No results)
Cynthia’s father’s family names:
Stubbs (results from the 1970s)
Tonks (None)
Tucker (8 results)
FamilySearch.org
Run the same at the free FamilySearch.org genealogy website. Search each surname with Omak (exact) & 1920-1940 (restricted to) U.S. On the day I searched, the only surname from the list with results was Tucker. Cynthia’s next step would be to compare the results to her known family tree.
Search the Census Specifically
You can search the census by using the search fields and using variations of names, town, county and specific address. If you don’t find the specific address that way, brown the records of the town, looking for addresses written in the left margin. At Ancestry, look for the link to a map of the location found in a census.
Results: 1930 Census: 104 West First St., Omak (Jess Tucker)
Use Google Earth to determine if the addresses found are the same today. Plot each finding on the map using placemarks.
Result: 1930 Census Address: 104 West First Street, Omak = not there today
A search in the 1940 for Jess Tucker found him still living with his mother. She was recorded as “Frances Write” living at 504 Main St., Omak, close to the house in question. When searching the census be sure to look at the pages on either side of the results page. In this case Jess is found on the next page living at “no number” as a renter at his mother’s home.
1940 Census Enumeration District Maps
Ancestry has a collection of 1940 Enumeration District Maps from the National Archives (where they can also be found here along with additional helpful search strategies.) Enumeration districts are geographic areas that were designed to allow an enumerator (the census taker) to visit every house in the district within a two-week time period. A month was allowed in more wide-spread rural areas. These maps vary in the amount of detail provided. They may or may not indicate house numbers.
Go the Ancestry Card Catalog and search for the 1940 Census Enumeration District Maps collection. In the search fields for this collection, enter the enumeration district number which can be found in the upper corner of the 1940 census page.
State Census
State Censuses were often conducted every ten years in years ending with “5” which makes them a great supplement to the U.S. Federal Census. They also sometimes include information not gathered at the federal level. Therefore, an important question to ask is “was a State Census taken in this approximate time period?”
Here’s a State Census list from the National Archives.
Results for Washington state: No state census taken after 1898.
Card Catalog Include Useful Unique Sources
Not all useful records will surface with a straight-forward search. Dig into the Card Catalog of your favorite genealogy records website to find unique and useful collections that may include addresses.
Example: Search the Ancestry card catalog for Okanogan County, WA Found: Washington, Postmaster Indexes, Prior to 1965 Strategy: Browse the alphabetically organized Okanogan cards for each family name.
Another unique record type that often includes address are Draft Cards. Search by location then surname. Also try Keyword searches. Not all cards include complete addresses but many do.
The Future is Bright
Here’s a summary of the wide variety of genealogical research strategies we’ve covered in this episode:
I really want to hear from you. Did you enjoy this episode? Do you have a question? Please leave a comment on the video page at YouTube or call and leave a voice mail at (925) 272-4021 and I just may answer it on the show!
If you enjoyed this show and learned something new, will you please share it with your friends? Thank you for your support!
Family history can be found in many places. We turn to steadfast repositories such as libraries, archives and historical societies. And these days we can also search online at free genealogy websites like FamilySearch, and subscription websites like MyHeritage and Ancestry. All have something unique to offer.
Most importantly, we start our search at home, talking to our oldest relatives and combing through old family papers. We then turn our attention to the family photo albums and scrapbook on the bookshelf, and old home movies if we are lucky enough to have them.
The great news is that the closets in your home are not the only place where you can potentially find old film footage pertaining to your family’s past. The largest online video repository in the world is YouTube (which is owned by Google), and it is the perfect place to look for film. That’s why I’m so excited to share some of my YouTube search strategies from my new book The Genealogist’s Google Toolbox, 3rd Edition. These strategies can help you find old home movies (from your family or someone else’s family that came in contact with your family), news and newsreel films, documentaries, amateur and professional film footage, and countless other subjects that can shed more light on your family’s history.
How to Find Family History on YouTube in 5 Steps
Does finding your family history on YouTube sound unlikely? Believe me, it’s not. YouTube is a treasure trove if you know how to search it. Here are 5 steps from my Google Search Methodology for Genealogy and how to apply them specifically to YouTube.
Step #1. Create a Search Plan
Just like genealogy research, successful Googling, even on YouTube, requires a plan. Rather than searching willy-nilly, take a few moments to determine what it is you hope to find. Having a search plan will save you a lot of time and frustration!
The key to a good research question and plan is to be specific. This means that instead of just searching for family names or places, you have a specific event, place, and / or time frame in mind.
Below is a great example of searching with a specific plan in mind that I received from one of my Genealogy Gems Podcast listeners a while back. I have bolded the keywords that she incorporated into her YouTube search.
From Carol K.: “I really enjoyed (Genealogy Gems) Podcast (episode) #223, particularly the segment with David Haas MD. (Editor’s note: that episode covers Dr. Haas’ vast collection of old home movies and his quest to upload them all to YouTube.)
I had tried researching YouTube for something about my family, including where they settled in Connecticut. I had not come up with much when I decide to search my dad’s ship, The USS Tuscaloosa (Image 1).
Image 1: Carol’s father, Mario Ponte, served on the USS Tuscaloosa
My dad, Mario Ponte, served in the Navy from 1936-1939 (Image 2).
Image 2: Mario DaRin Ponte beside the USS Tuscaloosa – July 27, 1937
I knew he had been on a Goodwill South American Cruisein1939 (Image 3) as he talked about it often and I even have the Cruise Book from that voyage.
image 3: U.S.S. Tuscaloosa South American Good Will Cruise route April – June 1939
On a goodwill tour of South America in 1939, three US cruisers found little goodwill in this angry sea. Newsreel cameras aboard the USS San Francisco recorded this epic struggle of the ships which included the USS Quincy and USS Tuscaloosa.
I don’t recall my father ever mentioning this to me, but my husband said he had heard the story. I only wish my dad were here to share this memory with me. At least, I have been able to share this treacherous event with many in my family.
When you see the tossing, turning and huge waves in the video, I feel they were lucky to have survived. Just think, if they hadn’t, I wouldn’t be here to tell this story today.
Thanks Lisa and David. I’m now convinced that YouTube can be used for genealogy and to add to our stories.”
Carol’s fascinating success can be directly tied to the fact that she developed a research plan focused on specific information.
2. Craft Your YouTube Search Query
As you can see, Carol didn’t just search YouTube for her Dad’s name. In fact, unless your ancestor was famous in some way, that is likely not a strategy that will pay off.
Instead, she assembled the pertinent information and used that in her query. Here are the keywords and phrases I pulled from her email:
The USS Tuscaloosa
Goodwill South American Cruisein1939
Mario Ponte
Navy from 1936-1939
I included her dad’s name in this list because it never hurts to run your ancestor’s name through a search just in case something pops up. You never know what might be on YouTube. For example, perhaps a childhood friend has uploaded an old home movie to YouTube and named him as being in the movie too!
When conducting your initial YouTube search, include all the important information. If the results are unsatisfactory, you can always remove or add search terms. Since we can’t be sure what if anything is on YouTube pertaining to our research subject, we have to be flexible, and that means expecting to run several variations of our search. We’ll talk more about that in step 3.
In Carol’s case, her research plan was focused on finding a video pertaining to the U.S.S. Tuscaloosa’s Goodwill cruise that her father participated in. She could start with a search such as:
USS Tuscaloosa Goodwill South American Cruise in 1939
The results for this search query are excellent and include the video that Carol found:
Image 4: YouTube search for family history
3. Analyze Your YouTube Search Results
Even though these results successfully delivered the video that satisfied our research plan, we would miss tremendous opportunity if we didn’t take a few extra moments to further analyze the results. You never know what else might be out there!
Here are just a few of the things you should be looking for when reviewing your YouTube results:
LOOK FOR: Should I be more specific in my search query?
Look at our search results (Image 4 above). What stands out to me is that there appear to be many different videos on YouTube about war time ships and cruisers. This is great for family historians, but it means that there are more results to look through than we might have expected.
As you have probably experienced in the past, not all the words in our search query are included in every search result we receive. There is a way to quickly and easily find only videos that specifically mention the words and phrases we want to find. By putting quotation marks around “U.S.S. Tuscaloosa” we can tell YouTube to only give us videos that mention that exact phrase.
When Google searching (and Google is the search engine under the hood of YouTube), quotation marks function as a search operator. They tell Google specific instructions about what to do with our word or phrase. In this case, they tell Google that the phrase is mandatory, and must appear exactly as typed and spelled. The one exception is the periods in U.S.S. Generally speaking, Google disregards punctuation, so it ignores the periods. It doesn’t matter whether you include them or not.
It is important to note that operators don’t always work as consistently in YouTube as they do in regular searches at Google.com. That being said, it’s great to have a variety of tools that we can use to improve our searches, and they are definitely worth a try. My book includes a wide range of additional search operators and how to use them.
Running a second search on “USS Tuscaloosa” opens many new video opportunities (Image 5):
Image 5: Search results for a query containing the quotation marks search operator.
This search not only includes the 1939 tour, but also other videos of the ship that may also be applicable to the family’s history. As you can see, sometimes less words in a search is more!
LOOK FOR: What do the unwanted video results have in common? Sometimes you may notice that you are receiving many results that are not a good match for what you are looking for. When this happens, take a look at your results and try to come up with words that are associated with the unwanted videos, and have no relevance to your goal.
Image 6 (below) is an example of search results in YouTube for the following query:
USS Tuscaloosa Goodwill Cruise in 1939
Image 6: Identify unwanted videos and words in the YouTube search results
While the results page includes a few good matches, it also includes current videos about quarantines on ships which is a viral topic at the time of this writing. Since these are not applicable to our search plan, we will want to eliminate them, and we will do that in Step 4.
4. Improve Upon Your YouTube Search Results
In a case like the one above (Image 6) where you are receiving several video results not applicable to your research goal, you can try literally subtract the unwanted words that you identified in Step 3 from your search. In most cases, this should remove the videos that contain those words in their title or description.
To do this, use the minus sign (-) search operator in conjunction with the word. Here’s an example of how we can do that with this search:
USS Tuscaloosa Goodwill Cruise in 1939 -quarantine
This search will remove the results that mention quarantine.
You can subtract multiple words from your query if you wish. Each word should have a minus sign touching it, and there should be a space between each subtracted word as in this example:
USS Tuscaloosa Goodwill Cruise in 1939 -quarantine -princess -coronavirus
Googling, whether at YouTube, Google.com or any of the other free Google tools, is an art form, not a black and white science. We need to try variations in order to learn from what works and what doesn’t. To reach our goals, we need to try adding in more of what we want, and removing what we don’t want. In this case I would also try adding to my query that that cruise was in South America, and that the phrase USS Tuscaloosa is mandatory. Here’s what that search query would look like:
“USS Tuscaloosa” Goodwill South American Cruise in 1939 -quarantine
Remember, we’re not going for perfect results, we’re mining all the different “veins” in the YouTube gold mine by running multiple versions of the same basic query. Feel free to experiment with mixing and matching keywords and operators. The results may be worth it!
Learn more about Google Search operators in my video:
GOOGLE GURU TIP: Conduct each variation of your search in a new browser tab. This allows you to compare the results side-by-side while retaining each query, making it easy to return to the queries that are performing the best.
You can also potentially improve upon your YouTube search results by using the Tools button to reveal the secondary filter menu. (Image 7)
Image 7: Click “Filter” to reveal the YouTube search filter options
These filters won’t prove useful in every case, but they do offer some handy options for narrowing the scope of your search.
5. Capitalize on Your Results
When you find a video that meets your research goals, there’s a good chance that the person or company that uploaded and published the video (publishers are called “Creators” by YouTube) may have more videos on that subject. Here’s a quick and easy way to find out.
On the video page, you will see the name of the Creator right below the video in the left corner. (Image 9)
Image 9: More videos found on YouTube
Click the YouTube Creator’s name. This will take you to their YouTube channel. Every Creator who has published a video has a YouTube channel. It’s sort of like their own home page for their videos. There you will be able to see and search any additional videos they have published. Click Videos to see all their videos. (Image 10)
Image 10: More videos on the Creator’s YouTube channel
If the channel has a lot of videos, click Playlists in the channel’s menu to see how they are grouped by topic. You can also search the channel for keywords and phrases by clicking the small magnifying glass icon on the far right end of the menu.
A Bright Future for Family History on YouTube
In Step 3 we analyzed the search results for Carol’s YouTube search. Let’s take another look at those results:
Image 8: Over time new videos are uploaded to YouTube waiting to be found.
It’s interesting to note that in addition to the video that Carol found which was published 4 years ago, another video on this topic was published a year later.
It’s estimated that more than 500 hours of video is being uploaded to YouTube every minute. This is up from the 400 hours per minute announced in 2015 by YouTube CEO Susan Wojcicki.
Among that vast storehouse of film footage I’ve found countless videos that have enhanced my family’s story. And readers just like you email me the gems they unearth. I love receiving these success stories. Thank you to Carol for sharing hers! If you make an exciting discovery using these strategies please share them in the Comments. It will inspire us all to continue our search.
The bottom line is that the potential for finding your family history on YouTube grows dramatically minute by minute, so don’t wait another minute!
Lisa’s new book is available at STORE in the menu or go to shopgenealogygems.com
The Google Search Methodology for a New Decade (video class)
1 hour video class and downloadable handout, part of Genealogy Gems Premium Membership. Learn more or subscribe here.
Watch the Premium video class Google Search Methodology for Genealogy
My genealogy research looks a lot like yours. Some family tree lines go back to pre-Revolutionary War. Other lines are richly researched well into the early 19th century.
And then there’s THAT family line. You know the one I mean. The one where the courthouse containing the records we need has burned down, or the records were microfilmed ages ago but are still sitting in the FamilySearch granite vault due to copyright issues. Or worst of all, it appears the needed records just don’t exist.
Don’t let these obstacles allow you to give up hope.
Every day, new records are being discovered and digitized. Records that have been languishing in a copyright stalemate might suddenly be cleared for publication. Or a cousin could contact you out of the blue and has the letters your grandmother sent hers. We never know when the records we’ve been waiting for, searching for, and yearning for, will bubble up to the surface.
Today I’m happy to share my story of a recent breakthrough that I never saw coming. Follow along with me as I take newly unearthed rocks and use tools to turn them into sparkling gems.
This is Almost Embarrassing
My one, agonizing family line that stops short in its tracks ends with my great grandfather Gustave Sporowski.
Gustave and Louise Sporowski (personal collection)
It’s almost embarrassing to admit. I’ve been at this nearly my whole life, and genealogy is my career for goodness sake! But there it is, a family tree with lovely far-reaching limbs except for this little stub of a branch sticking out on my maternal grandmother’s side.
I was about eight years old the first time I asked my grandma about her parents and their families. (Yes, this genealogy obsession goes back that far with me!) I still have the original page of cryptic notes she scratched out for me during that conversation.
Excerpt from Grandma’s original notes. (Personal collection)
She had several nuggets of information about her mother’s family. However, when it came to her father Gustave, she only recalled that he was the youngest of seven brothers. No names came to mind. I’ve always felt that if I could just identify some of the brothers, one of them may have records that provide more details about their parents.
According to his Petition for Naturalization, Gustave Sporowksi and Louise Nikolowski were married in LutgenDortmund, Germany. This indicated that both moved west from East Prussia before emigrating. While I knew Louise’s immediate family were in the LutgenDortmund area as well, I had no idea whether Gustave moved there on his own or with his family.
Gustave Sporowski’s Petition for Naturalization.
Gus (as he was later known) emigrated from Germany in 1910, landing at Ellis Island. He toiled in the coal mines of Gillespie, Illinois, and eventually earned enough money to move his wife and children west to California in 1918.
After filing his papers and years of waiting, he proudly became a U.S. citizen in 1940.
On that paperwork, he clearly states his birthplace as Kotten, Germany. You won’t find this location on a map today. In 1881, the year he was born, the area was East Prussia. I remember the hours I spent with gazeteers many years ago trying to locate that little village nestled just within the border of Kreis Johannisburg. Being so close to the border meant that he could have attended church there or in a neighboring district.
The records in the area are scarce, and today the entire area is in Poland.
Surprisingly, the records situation is quite the opposite with his wife Louise, also from East Prussia. She lived not far away in Kreis Ortelsburg, and the records for the church her family attended in Gruenwald are plentiful. I’ve managed to go many more generations back with her family.
And so, poor Gus alone sits in my family tree.
I periodically search to see if there’s anything new that has surfaced, but to no avail. I even hired a professional genealogical firm to review my work and suggest new avenues. I guess it is good news to hear you’ve pursued all known available leads, but it’s not very rewarding.
Over time, we tend to revisit tough cases like this less frequently. They become quiet. Digital dust begins to settle on the computer files.
And then it all changes.
German Address Books at Ancestry.com
I regularly make the rounds of the various genealogy websites, making note of new additions to their online collections. I typically publish the updates on a weekly basis here on the Genealogy Gems blog. It makes my day when readers like you comment or email, bursting with excitement about how one of the collections I mentioned busted their brick wall. I love my job.
This week I’m the one who is bursting!
It started simply enough. My third stop on my regular records round-up tour was Ancestry.com. The list of new records was particularly robust this week. The word “Germany” always catches my eye, and the second item on the list jumped out at me:
“Recently Added and Updated Collections on Ancestry,” Ancestry.com (http://www.ancestry.com : accessed 05 Sept 2019)
I should have had a healthy dose of skepticism that I would be fortunate enough to find anything. But to be perfectly honest, I felt instinctively that I would! Have you ever just had that feeling that your ancestors are sitting right there ready to be found? If you’ve been researching your family history for a while, then I’m guessing you have. Such a nice feeling, isn’t it?
So, I clicked, and I simply entered Sporowski in the last name field and clicked Search.
Experience has taught me that there haven’t been a lot of folks through history with this surname, so I’m interested in taking a look at anyone who pops up in the results. And yippie aye oh, did they ever pop up!
The results list include 31 people with the surname of Sporowski!
These names came from the pages of address books much like the city directories so common in the U.S. Since this collection was new to me, I took a moment to read up on the history.
______________________________
GENEALOGY RESEARCH TIP: Learning the History of the Genealogy Record Collection
To truly understand what you are looking at when reviewing search results, we need to acquaint ourselves with the history of the collection.
Why was it created?
What does it include?
What does it not include?
Look to the left of the search results and click Learn more about this database.
It’s definitely worth clicking this link because the next page may also include a listing of Related Data Collections, some of which you might not be aware. These could prove very useful, picking up the pace to finding more records.
In the case of foreign language records, look for a link to the Resource Center for that country. There you may find translation help and tips for interpreting handwriting and difficult-to-read script.
Ancestry Help Features
______________________________
On the Learn more about this database page, I learned some important things about these search results.
First, not every citizen was listed. Only heads of households were included. This means that wives and children would not appear. I did find some widows, though, because they were the head of their household.
Second, Optical Character Recognition (OCR) was used on this collection. Ancestry suggests looking for errors and providing corrections. But this information about OCR also implies something even more important to the genealogist. We must keep in mind that OCR is not perfect. In this case, I planned on browsing the collection after reviewing the search results to ensure I didn’t miss anyone. This would include targeting people listed in the “S” section of directories for towns I might expect the family to be.
I was particularly thrilled to see the name “Emil Sporowski” on the list.
Several months ago I found a World War I Casualty list from a newspaper published in 1918.
On it was listed Emil Sporowski and he was from the village of Kotten. This was the first mention of Gustave’s birthplace in the record of another Sporowski that I had ever found. So, you can imagine my delight as I stared at his name in the address book search results.
The icing on that cake was that he was listed in the address book of Bochum. That town name was very familiar to me because I had seen it on a few old family photos in Louise Sporowski’s photo album. Although the photos did not have names written on them, I could easily identify the folks who had the facial characteristics of Louise Nikolowski’s clan, and those sporting the large eyes with heavy lids like Gus.
Photo from Louise Nikolowski’s photo album.
Spreading the German Addresses Out with Spreadsheets
With one and a half pages delivering a total of 31 Sporowski names, I knew I had some work ahead of me to tease them apart. This got me thinking of Genealogy Gems Podcast episode that I’m currently working on, which features a conversation with professional genealogist Cari Taplin. When I asked Cari how she organizes her data, she told me that she uses spreadsheets. I’m not typically a spreadsheet kind of gal, but in this case, I could see the benefits. Spreadsheets offer a way to get everybody on one page. And with the power of Filters and Sorting you slice and dice the data with ease. My first sort was by town.
My Excel spreadsheet tracking German Address Books search results at Ancestry.com
______________________________
GENEALOGY RESEARCH TIP: Free Genealogy Gems Download
Click here to download the simple yet effective spreadsheet I used for this research project. If you find your German ancestors in this collection, it’s ready to use. Otherwise, feel free to modify to suit your needs in a similar situation.
______________________________
As you can see in the spreadsheet, these address books include occupations. For example, Emil was listed both as a Schmied and a Schlosser. A simple way to add the English translation to my spreadsheet was to go to Google.com and search Google Translate. Words and phrases can be translated right from the results page.
Translating the Occupation found in the German Address Books using Google Translate (Available at https://translate.google.com. Accessed 05 Sept 2019)
You can also find several websites listing German occupations by Googling old german occupations.
I quickly ran into abbreviations that were representing German words. For example, Lina Sporowski is listed with as Wwe .
A Google search of german occupations abbreviations didn’t bring a website to the top of the list that actually included abbreviations. However, by adding one of the abbreviations to the search such as “Wwe.” it easily retrieved web pages actually featuring abbreviations.
GENEALOGY RESEARCH TIP: Use Search Operators when Googling
Notice that I placed the abbreviation in quotation marks when adding it to my Google search query. Quotation marks serve as search operators, and they tell Google some very important information about the word or phrase they surround.
The quotation marks tell Google that this word or phrase must appear in every search result. (If you’ve ever googled several words only to find that some results include some of the words, and other results include others, this will solve your problem.)
They also tell Google that the word(s) MUST be spelled exactly the way it appears on each search result. This is particularly helpful when searching an abbreviation like Wwe. which isn’t actually a word. Without the quotation marks, you will likely get a response from Google at the top of the search results page asking you if you meant something else.
Click here to receive my free ebook including all the most common Google search operators when you sign up for my free newsletter (which is always chock full of goodies).
______________________________
Katherine was my guest on Genealogy Gems Premium Podcast Episode #151 available exclusively to our Premium eLearning Members. She’s also written a couple of articles for Genealogy Gems on German translation:
As it turns out, Wwe. stands for Widow. This tells me that Lina’s husband was deceased by 1961.
Finding the German Addresses in Google Earth
The most glorious things found in these old address books are the addresses themselves!
Google Earth is the perfect tool to not only find the locations but clarify the addresses. Many were abbreviated, but Google Earth made quick work of the task.
Unlike other free Google Tools, Google Earth is available in a variety of forms:
Free downloadable software
Google Earth in the Chrome Web browser
A mobile app
Each has powerful geographic features, but I always recommend using the software. The web version and app don’t have all the tools available in the software. All versions require an internet connection. You can download the software here.
In the Google Earth search box I typed in the address. Don’t worry if you don’t have the full address or if you think it may be spelled incorrectly. Google Earth will deliver a results list of all the best options that most closely match.
In my case, reliable Google Earth not only gave me complete addresses, but also the correct German letters.
I went through the entire list. As I found each location in Google Earth, I checked it off on the spreadsheet.
Addresses found in German Address Books at Ancestry.com marked in the spreadsheet
GENEALOGY RESEARCH TIP: Create a Folder in Google Earth
When you have several locations like this to plot, I recommend creating a folder in the Places panel in Google Earth. It’s super easy to do and will help you stay organized. Here’s how:
Right-click (PC) on the MyPlaces icon at the top of the Places panel (left side of the Google Earth screen)
Select Add > Folder in the pop-up menu
A New Folder dialog box will appear
Type the name of your folder
Click OK to close the folder
You can drag and drop the folder wherever you want it in the Places panel
Click to select the folder before placing your Placemarks. That way each placemark will go in that folder. But don’t worry, if you get a placemark in the wrong spot, just drag and drop it into the folder.
The beauty of Google Earth as that you can start to visualize your data in a whole new way. Zooming out reveals these new findings within the context of previous location-based research I had done on related families. As you can see in the image below, all the Sporowskis that I found in the German Address books at Ancestry.com are clustered just five miles from where photos were taken that appear in Louise Sporowski’s photo album.
I’ve Only Just Begun to Discover my German Ancestors at Ancestry.com
We’ve covered a lot of ground today, but this is just the beginning. There are additional sources to track down, timelines to create, photos to match up with locations, and so much more. In many ways, I’ve only scratched the surface of possibilities. But I need to stop writing so I can keep searching! 😊
I hope you’ve enjoyed taking this journey with me. Did you pick up some gems along the way that you are excited to use? Please leave a comment below! Let us all know which tips and tools jumped out at you, and any gems that you found.
I was just listening to the newest Premium podcast concerning filtering the lists on Google Books (Premium episode 137). I would like to relay my story for using your hints and tips on Google.
lating to finding issues of a literary magazine or another scholarly publication like The Californian:
