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.
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.
Do you use Google for genealogy? This free, powerful web browser will scan over 30 trillion webpages for information we request: our ancestors’ names, messages from those with common ancestors, or pictures and stories relating to our relatives’ lives.
However, it’s all too easy to run a Google search for an ancestor’s name–and then become discouraged when we see a quarter million search results. Especially if the first few results don’t seem relevant at all! We may give up, unaware that the gem we’re after is among our results, but much further down the list.
Certain Google keyword search tips and tricks can help you get exactly the types of search results you’re after. Once you learn Google search strategies for genealogy, you’ll find yourself using the same strategies to find other things online, from recipes to how-tos to old car manuals or anything else you need!
Here’s how to get started
1. Go to the Google home page and enter a few keywords relating to a piece of information you hope to find online. Say, an ancestor’s full name and hometown such as Andrew Larsen Scranton PA. Or a type of record you need and the location (probate records Lackawanna County PA). As you see from these examples, you don’t need commas in between your words or any other punctuation, at least to begin with. After entering a few keywords, hit Enter.
2. Look at your search results. The first few may be sponsored search results, or results that appear on websites that are paying for you to see them first. These results may or may not be what you’re looking for. Scan them, but keep looking!
3. Do you see too many search results? Too few? Not quite on target? Add or subtract keywords as needed, and search again. For example, if your search for probate records Lackawanna County PA just brings up current probate records, add the word genealogy. If Andrew Larsen Scranton PA doesn’t bring up any relevant results, try omitting his first name from the search. Then results for anyone with that surname will come up.
4. Still not quite right? It may be time to start adding little codes to tell Google exactly what you want.
5 Google Search Strategies That Get Better Results
Search operators are symbols and words that instruct Google on what to do with the keywords you provide in your search query. Get ready to talk Google’s language with these 5 strategies:
1. Quotation Marks (“ ”). One of the quickest ways to improve your search results is to use quotation marks.Using quotation marks around a phrase ensures that this exact phrase appears in each and every result. For example: “U.S. Federal Census” returns websites featuring that exact phrase, and no variation. “Jehu Burkhart” returns only webpages that include the exact name Jehu Burkhart somewhere on the page. Keep in mind though that if Jehu’s name appears as Burkhart, Jehu on a web page it will not appear in your results list.
2. OR. Use this to provide for more options in Google search results. For example, we can solve the last name first, first name last problem like this: “Jehu Burkhart” OR “Burkart, Jehu”. Not be sure whether Great Grandmother Smith is buried in Manhattan or Brooklyn? Search for cemeteries in either city: Cemeteries Manhattan OR Brooklyn.
3. Minus Sign (-). Let’s say that you are searching a Harold Carter from Springfield, Ohio and there happens to be a prominent man named Harold Carter from Springfield, Missouri who keeps popping up in your search results. Ask yourself: “what’s unique about this other person that I could eliminate from my Google search?” If the unwanted Mr. Carter was married to Mabel and owned a steel factory, you could try this approach:“Harold Carter” “Springfield” Missouri -Mabel -Steel. By using the minus sign operator you can sweep this Mr. Carter from Missouri out of the way and off your results page.
4. Numrange (00..18). The numrange command adds a range of numbers to your search parameters. To enter the command, type the beginning number, then two periods (no spaces), then the ending number. Use this feature to include the timeframe of your ancestor’s life in your online search. “Harold Carter” “Springfield” 1865..1934.
Google Search Example
5. Mix and Match. As you can already see in the above examples, it is perfectly acceptable to mix and match search operators. Here’s a search query that makes use of our first four strategies: “Harold Carter” OR “Carter Harold” “Springfield” Missouri -Mabel -Steel 1865..1934
The Genealogist’s Google Toolbox has become the “Google bible for genealogists.” Now in its second edition, the book was fully revised and updated in 2015. A lot has changed since the first edition was published in 2011, and it’s all documented step-by-step in this new edition.
This brand new edition includes:
Brand new chapters on Google Scholar and Google Patents
It’s Nice to Share. Do youhave friends who would benefit from this article on using Google for genealogy and Google keyword search tips. Please share this article with them. You will find handy sharing buttons on this page, or just copy and paste the URL for this article into a Facebook post or email. Thanks!
Who doesn’t love a good genealogical surprise? Sometimes we discover something we overlooked the first time around. Other times we find gems in places we never expected. Google Books is one of those places full of unexpected surprises.
with Lisa Louise Cooke
What is Google Books
Google Books is a free online catalog of over 25 million books, 10 million of which are digitized and searchable. The collection is international in scope.
You can search at the stand-alone website. You can also start your search at Google.com and then select Books results on the search results page.
While you would expect to find books at Google Books, you may be surprised to discover there it also includes many other types of published materials. Here are 10 surprising things you can find at Google Books. Watch the video and follow along in the article below.
10 Surprising Things at Google Books
The final issue of Ancestry magazine was published in 2010. Though times and technology change, core genealogical methodology stays much the same. Browse or search past issues spanning 1994 through 2010 at Google Books for free. You’ll also find countless other magazine titles including Life magazine (1953-1972).
An ideal way to fill in between census enumerations is with city directories. Typically published yearly but sometimes irregularly, they are an invaluable source for information about your ancestors. You might find listed their place of employment and spouse’s name in addition to address and phone number.
Search Tip: Target city directories specifically by searching for the name of the city in quotation marks. Google interprets quotation marks to mean that you want that word exactly as written to appear in each returned result. Next add the phrase city directory, again in quotes. To ensure you don’t miss directories that include additional words between city and directory, place an asterisk between the words.
Here’s how your search will look: “Nashville” “city * directory”
This search operator tells Google that the phrase may also include a word or two between city and directory. An example might be The Nashville City and Business Directory.
When we hear the word almanac we often automatically think of the yearly Old Farmer’s Almanac. However, almanacs of the 19th century and earlier sometimes also included information on local residents and businesses. It’s worth taking a look to see if your ancestor’s community published almanacs. Businesses and other organizations also published almanacs.
4. Governmental Publications
It’s not uncommon for every person at some point in their life to interact with the government. Those interactions create paperwork, and that paperwork may have been published. In Google books, search for probate documents, hearings and other types of government generated works in combination with the names of your ancestors, their businesses, and other organizations with which they were associated.
5. County Histories
The digitized items on Google Books are often there because they either fall within the public domain (published prior to 1924). Consequently, there is a very good chance that the county history published in your ancestor’s area is digitized and available on Google Books. These books are a wealth of historical information about families and communities.
6. Compiled Family Histories
There’s a good chance that sometime in the past someone has researched a family line that connects to your family tree. These genealogies may be published in a compiled family history. Since the phrase compiled family history will probably not be in the title of the book, try this search approach:
1. Search for the word genealogy (no quotation marks) and a surname (with quotation marks)
2. Filter to Free Google eBooks
3. Filter by time frame (for example 19th century)
The Google News Archive was a newspaper digitization project that was discontinued several years ago. The archive remains but is very difficult to search. The good news is that those digitized newspapers are now included in Google Books with its powerful search engine. Start by running a search and then on the results page filter Document Type to Newspapers. Use the Share a Clip clipping tool (found in the three stacked dots button on the digitized book page) to clip articles.
Newspapers may appear in the old Classic View of Google Books (as they do at the time of this writing.) If so, use the search box in the column on the left side of the page to search within the newspaper.
Search Tip: Save time by visiting the Google News Archive to see which newspapers are included and the years that they cover.
8. Genealogy Journals
The oldest genealogy journal has been published quarterly by the New England Historical and Genealogical Society since 1847. Since then many other societies such as the Genealogical Society of Utah have regularly published journals. These journals often list families and sources and are an invaluable resource to genealogists today. Family Associations also often publish journals.
Try a simple search of genealogy journal to start browsing. Then try adding a surname, state, or country or combination of those. Filter down to Free Google eBooks to view only free digitized publications.
The Historical Journal of the More Family. United States: John More Association, 1892.
Old maps can be found in many of the surprising items we’ve found so far. County Histories in particular are a wonderful resource of old maps. Many times, they will include plat maps that even include the owners name written on the property. Many maps may be one-of-a-kind.
A quick and easy way to spot maps within a book is to use ThumbnailView. You’ll find the ThumbnailView button (which looks like a checkerboard or collection of six squares) at the top of the screen when viewing a digitized book. Once clicked, your view will change from a single page to many pages at once. This makes it very easy to scroll and spot maps. You can also try looking through the Contents menu for Maps.
Use the Share a Clip feature (mentioned in #7) to clip the map. In the pop-up box, click the Copy button next to the image link. Paste the link in a new browser tab and hit Enter on your keyboard. On a PC, right-click the image and save it to your computer by selecting Save Image As.
Like old maps, there are many photographs and images in old digitized books at Google Books. These could include photos, engravings and drawings of your ancestors, their homes or other items relating to your family history. Follow the directions in #9 to find and save photos and images.
Tips for using Google Books
When reviewing a digitized book, look for the Contents menu at the top of the screen. Here you’ll find addition options to jump to different parts of the book such as topics or chapters.
In the new Google Books user interface, you will find the digitized book is overlayed over the catalog entry for the book. The search box at the top of the screen is for searching only within that book. To close the book and view the catalog entry, click the X in the upper right corner of the screen.
To remove the yellow highlighted items, you searched for from a book and start a new search, click the Clear Search button.
Translate foreign language text by using the clipping tool. While viewing a digitized page, click the three stacked dots and select Share a Clip. Using your mouse, draw a box around the text you want to translate. In the Share this Clip pop-up window click the Translate button.
How to filter your search results down to only free digitized book: On the search results page you should see that the Tools button is greyed out (if it is not, click it) and in the drop down menu click Any Books and select Free Google eBooks.
How to cite books in Google Books: Close the digitized book to reveal the book’s catalog entry page. In the About this edition click the Create Citation button. Copy the desired source citation.
Book:The Genealogist’s Google Toolbox by Lisa Louise Cooke. Learn everything you need to know about effective searching as well as using Google Books and the Google News Archive.
Premium Members: Watch my Premium video class Google books the Tool I Use Every Day for many more specific and effective strategies for using Google Books for genealogy.
One of the advantages of tuning into the live broadcast of each Elevenses with Lisa show is participating in the Live Chat and asking your questions.
From Carolyn: Can you put in a year range for the city directory search From Lisa: Yes, you can use the numrange search operator when searching Google Books. Example: “Nashville” “city * directory” 1850..1900
From Regina: What if you have a really common surname?
From Lisa: Common names pose a challenge but you can find them too! It takes a bit more strategy, and I cover that extensively in my book The Genealogist’s Google Toolbox.
From Mary: Could you find diaries, journals, and manuscripts? What would it be under? From Lisa: If the items were formally published then there is definitely a possibility of finding them in Google Books. Run a search on diary and filter down to Free Google eBooks and you will see many examples. From there, you can try adding names, places, etc.
From Kathryn: When you clip a map or image, how can you add the citation of the book? From Lisa: Click the X to close the digitized book. This will reveal the book’s catalog entry page. In the About this edition click the Create Citation button. Copy the desired source citation. You can then paste it into the document where you are using the clipping, or paste it into the meta data (Properties) of the image file.
From Georgiann: Sometimes I get so overwhelmed with the ALL of this good information. Lisa, are you cloned so I can have you sit next to me to calm me down as I start? From Lisa: Well, as you heard in this episode it turns out I don’t have a twin, LOL! However, Premium Membership is the next best thing. Then you can have me “on demand” all year long.