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.
The Genealogy Center: Elevenses with Lisa Episode 31
If you’re looking for a wide array of free online genealogical records for your family history, look no further than then Allen County Public Library’s Genealogy Center in Fort Wayne, Indiana. It’s the second largest genealogy library in the country. In addition to the in-house collection, the Genealogy Center offers a vast amount of free digitized resources through their website and partnerships with other websites.
I invited Allison Singleton, Senior Librarian at the Allen County Public Library Genealogy Center in Fort Wayne, Indiana to the show. She is taking us on our tour of the website and sharing her tips and strategies for finding genealogy gems. Watch the video and follow along the highlights with the show notes below:
What is the Genealogy Center?
The Genealogy Center has one of the largest genealogy research collections available, incorporating records from around the world. The staff specializes in genealogy and is always available to help. Visit the Genealogy Center at the Allen County Public Library in Fort Wayne Indiana.
There’s a lot to explore at the Genealogy Center website. Let’s start with the top-level menu on the Home page. Here we’ll find links to important resources such as:
Donations
Genealogy Community
Life StoriesPathfinders
Let’s take a closer look to a few in addition to other free resources available through the large colored buttons on the home page.
Genealogy Community
The Genealogy Community is the place to ask questions, sign up for their e-newsletter, and follow them on social media. They are extremely active on Facebook. You can also learn more about and get in touch with the staff of seasoned family history librarians.
PathFinders
PathFinders is a great place to start your family history search. It provides very small snapshots of what the Genealogy Center has in their collection for any given location or topic. Snapshot categories include:
State Snapshots
Subject Snapshots
International Snapshots
Click on the logo from any page to return to the website’s Home page.
Free Databases at the Genealogy Center Website
The Genealogy Center does not interlibrary loan materials. Their collection is reference only. The website is the perfect place to plan your next visit. That being said, much of their invaluable collection has and is being scanned by Internet Archive and FamilySearch. If it is out of copyright, they work to get it online. So there’s plenty to find from the comfort of your own home.
You can find their Free Databases by clicking Resources on the home page and then Free Databases. These are all searchable and include digitized images that can be viewed from home.
In the Free Databases section you’ll find gateways to other specific areas including African-American and Native American. These provide an excellent place to start your research.
Free databases at the genealogy center
Family Bibles at the Genealogy Center Website
Navigation: Our Resources > Free Databases > Family Bibles The Genealogy Center actively collects scans of family bible records pages.
Learn more about researching family Bibles for family history in Elevenses with Lisaepisode 29.
Watch episode 29 of Elevenses with Lisa to learn how to find and analyze your family bible for genealogy
Donations
You can donate more than just money to the Genealogy Center. They are also looking for research donations. Donating is a great way to make your genealogy research materials easily accessible to your family and other researchers. You’ll find Donations in the main menu on the Home page.
Donated digitized materials are freely available online on their website.
They are actively digitize records.
You can even bring your materials into the library and they will digitize them. You can then keep the originals.
You can also send in your own digitized scans.
Military Records at the Genealogy Center Website
Navigation: Our Resources > Free Databases > Our Military Heritage They are actively collecting military information for inclusion in their collection. The collection includes many unique items donated by other family historians.
Copyright and Usage
The materials on their website are under copyright. You can view one page at a time. However, you can copy and print like you would if you were visiting the library. Include a source citation including the donor name. If in doubt about usage, contact the Genealogy Center.
Searching for Genealogy Center Content
The website is new (in 2020) so Google may not pick up everything in search. Use the website search field to search the entire collection.
Allison’s Catalog Search Tips:
When search the Allen County Public Library catalog, don’t use common words such as county and city.
Also, don’t use the plural form of words. For example, use directory not directories.
After running the search, on the left side of the page under “I only want” filter your results to only the Genealogy Center by clicking Branch and then
If an item is digitized, you will see a Web Link under More Info.
Lisa’s Search Tip: Use Control + F (PC) or Command +F (Mac) to quickly find words in a long list on a results page.
On-Site Databases at the Genealogy Center
You can only access on-site databases while in the library. No library card is required. The library does not offer an online subscription service.
Getting Help Online for Offline Resources
Navigation: On the homepage click Genealogy Community > Ask a Librarian. Here you can send brief questions and requests.
Family History Archives
Navigation: Click Family History Archives on the Home page and you’ll find links to other websites hosting Genealogy Center digitized content. Partners include:
FamilySearch (Public Access)
The Internet Archive (over 110,000 items)
Linkpendium
WeRelate
Over 110,000 Free records at the Internet Archive from the Allen County Public Library Genealogy Center
City Directories at the Genealogy Center
City Directories are a wonderful way to fill in information between census years. The Genealogy Center has the largest collection of city directories in the country. They are in both book form and microfilm.
The city directory collection cover across North American and even includes some international directories.
Compiled Family Histories at the Genealogy Center
Compiled family histories help you stand on the shoulders of other accomplished researchers. They have approximately 70,000 physical books. There are also family histories digitized and on the website. Search for the surname and include the word family. On the results page, filter down to Branch > Genealogy.
Free Consultations and Paid Professional Services
Navigation: Home > Our Services > Consultations. The Genealogy Center offers free (yes, you read that right!) 30-minute consultations with a Genealogy Center librarian. Consultations are held by Zoom, phone or email. You don’t even have to be a library card holder! Prepare well to get the most from your consultation.
You can also hire staff at the Genealogy Center to do more extensive research for you. Another option is to request a list of local professional researchers. Visit Our Services > Forms > Research Form
PERiodical Source Index (PERSI)
Navigation: Home > Our Resources > Onsite Databases > PERiodical Source Index (PERSI) PERSI offers a very wide range of periodicals, some of which are very unique and niche. The PERSI index is hosted by Findmpast. Search the index for free from home at Findmypast. Some of the items require a subscription.
Allison provided some excellent insider strategies for searching PERSI:
Articles are indexed by title.
Don’t search by keyword or “Who”.
Most people aren’t named in the article titles. Focus on location.
You can order the articles from the Genealogy Center. $7.50 for each form which includes up to six articles. Go to Our Services > Forms > Article Fulfillment.
Resources
Get My Free Genealogy Gems Newsletter – click here.
Your local library may offer free genealogy magazines and ebooks. Why choose them over print? So many reasons! No more late fees. Read on the go. Choose your font size. So go ahead: check out digital versions of that Genealogy Gems Book Club title you’ve been meaning to read, or the current issue of Family Tree Magazine. Here’s how.
Here in the U.S., it’s my favorite time of year: back-to-school! The weather slowly cools. My children shake off summer’s mental lethargy. My own schedule resumes a more predictable, productive rhythm. And after months spent outdoors, I rediscover my local library. Top on my library list this fall: free genealogy ebooks and magazines I can check out on my mobile device. It’s on-the-go reading for my favorite hobby–with no searching under my bed when items come due to avoid those pesky late fees.
Free Genealogy eBooks and Magazines
Genealogy Gems Premium Member Autumn feels the same way about free genealogy gems at her local library. Here’s a letter she wrote to Lisa Louise Cooke:
“I’m really enjoying both the Premium and free podcasts. I also like the addition of the Genealogy Gems Book Club. I haven’t read all the books yet but am adding them all to my wishlist on Overdrive, a free app that allows you to check out digital books for free from your local library. They don’t have every book but they have many, many books including some from the book club. Most libraries have a lot of biographies and histories available through Overdrive for free that are of interest to genealogists as well. Some libraries are adding video to their Overdrive offerings too.
Many of these same libraries offer magazines free as well. My library…use[s] Zinio, a magazine app. I only subscribe to a couple of magazines now because I can get so many for free through my library (not to mention keeping my home neater by not having them laying everywhere).”
It makes me happy that Autumn is enjoying the Genealogy Gems Book Club. We hear from many avid readers who love browsing our list of mainstream fiction and nonfiction picks for family history lovers. As part of our book club, we interview every book club author, too–from beloved novelists like Fannie Flagg to acclaimed journalists, memoir writers, and historians who take their own unique approaches to family history themes. Hear excerpts of these interviews on the free Genealogy Gems Podcast; full interviews run on the Genealogy Gems Premium Podcast, available by subscription.
Overdrive and Zinio
At Autumn’s recommendation, I started using Overdrive through my local library. I love it! I’ve listened to several digital audiobooks on the road and at the gym through Overdrive and have read several ebooks, too. (I’m always on the hunt for the next Genealogy Gems Book Club title.) The books just disappear at the end of the lending period (hence the “no late fees” bonus).
Genealogy Gems Service Manager Lacey Cooke loves Overdrive, too. She sent me these four reasons why:
1. Download for Offline Listening: “You can download the ebooks, audiobooks, magazines etc. to your device so that you can enjoy them offline (great for traveling). They’ll still disappear once your lending period expires, but having them available offline is awesome. You don’t have to worry about data charges or slow internet connections.
2. The Wishlist: Autumn briefly mentioned the Wishlist feature. I love this feature because it gives me somewhere to save book titles that I’m interested in reading at some point, but I’m not ready to check out just yet.
3. Bookmark/Syncing:You can bookmark a page, then pick up where you left off. If you have the Overdrive app on multiple devices, the app syncs. I can start reading on one device, and pick up on another right where I left off.
4. Format Adjustments: You can adjust the font style, size, and color to make it easier for you to read. I like to pick a nice, clean font in a big size so there’s no strain on my eyes.”
It’s worth noting that if you don’t already have a library card with your local library, you may be required to sign up in person to get a card, even if you only plan on using the Overdrive app to request items online. New releases or popular titles may have a wait list to check out the ebook or audiobook (especially if the library only possesses one copy). If you do have to place an ebook on hold, you will be notified via email when it becomes available to you, so if you don’t check your email regularly, keep that in mind when you place a hold. Each library system is different, so of course, your experience may vary.
Another helpful tip: not every library offers Overdrive ebook checkouts. But sometimes you can use another library’s Overdrive privileges. Autumn sent a link to these instructions on how to do so. (Thanks, Autumn!)
Autumn also mentioned the Zinio app. My library doesn’t offer Zinio yet, so I spent a little time on its public search portal. That doesn’t have a browsable genealogy category, and searches for the terms family history, genealogy and ancestry came up empty. But I did finally find these titles:
Lisa Louise Cooke, Genealogy Gems DNA expert Diahan Southard, and I are all frequent contributors to Family Tree Magazine, which we {heart} and recommend for its easy-reading research tips, hands-on tech and DNA tutorials, and the eye-candy layout.
More Free Genealogy Resources at Your Local Library
Of course, your local library may offer many additional free genealogy research and reading materials. Of tremendous value is access to Library editions of popular genealogy databases such as Ancestry, Findmypast, Fold3, and MyHeritage, along with institutional versions of historical newspaper databases. (Click here to learn more about the differences between the major genealogy websites.) Call your library or browse its website to see what resources may be available with your library card on site or even remotely from your own home or mobile device. And remember to watch for your library’s e-media options like those recommended by Autumn.
As a special shout-out to all the free genealogy resources at your library, Lisa Louise Cooke has granted free access for everyone to Genealogy Gems Premium Podcast episode #125. In this episode, Lisa has a full discussion about more free genealogy gems at public libraries with Cheryl McClellan. Cheryl is not only my awesome mom, she rocks professionally as the Geauga County, Ohio public library system staff genealogist!
This Premium episode is usually exclusively for Genealogy Gems Premium members. If you love it, and you’re not already a member, consider gifting yourself a “back to school” subscription. It’s the most fun, energizing, apply-it-now genealogy learning experience you may ever have.