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.
A ton of genealogy and family history research can be done for free. In this episode I’ll share 15 fabulous free websites and what I love about them. These are essential for everyone serious about saving money while climbing their family tree.
(Get your ad-free Show Notes Cheat Sheet at the bottom of this page in the Resources section.)
LISA’S SHOW NOTES: Get your ad-free downloadable handout in the Resources section at the bottom of this page.
Tip: Use the Tools button on the results page to reveal the filter menu. Filter your results down to just full digitized and searchable books by selecting Full View.
Snagit Clipping Tool: Get Snagit with our affiliate link and get a discount for a limited time. (thanks for supporting our free content!) (screen clipping tool) Thank you for using our link. Use coupon code GENEALOGY15to get 15% off. (We will be compensated at no additional cost to you, which makes the free Elevenses with Lisa show and notes possible.)
“Cooperative effort between the National Park Service and several public and private partners whose goal is to increase Americans’ understanding of this decisive era in American history by making information about it widely accessible.
11. Soldiers and Sailors Database
Features:
Men who served in the Union and Confederate armies during the Civil War.
Histories of Union and Confederate regiments.
Links to descriptions of significant battles.
Selected lists of prisoner-of-war records and cemetery records.
Doing genealogy research generates a wide variety of research notes: typed and handwritten, audio, photos, video, and screenshots of information on websites. If you want one tool to pull together your current research projects, Evernote might just be the answer. In this video and article you’ll learn the role that Evernote can play, what it is and how to set it up, and your options for using for free or as a subscriber.
Evernote for Genealogy Video Tutorial
In this video and article Lisa Louise Cooke will discuss:
What Evernote is and the role Evernote can play in your genealogy research
Use it for free or upgrade to get all the bells and whistles like OCR and use on all your devices. (We will be compensated if you use our affiliate link. Thank you for supporting this free show.)
Show Notes
In my recent videos on how to avoid research rabbit holes that keep you from your genealogy goals, I mentioned that I use Evernote to capture BSOs or bright shiny objects that are interesting but not what I’m working on at the moment. So in this video I’m going to explain what Evernote is, and how to get started using it.
Evernote puts all your notes in one place and offers an incredibly fast and easy way to retrieve them.
Evernote is a:
website
software program for your computer (Win & Mac) that you download for free from their website
mobile app (iOS & Android): search for Evernote in your device’s app store
a web clipper for your computer’s web browser
Benefits
Genealogy can get a big messy. Information can be gathered from countless sources and in a variety of forms. You could funnel things through a cloud service like Dropbox. However, because Evernote is a note taking app, it offers unique and super helpful features:
Create all types of notes
From all of your devices. Thanks to Cloud synchronization you can take a note on any device and always have access to the most current version. (Free mobile app)
Web clipping – It allows you to clip items from the Internet (rather than saving entire bulky web pages),
OCR technology makes notes (such as newspaper articles) keyword searchable (subscription)
Data like URLs and the date you created the note is automatically included
No total storage limit, just monthly upload
You can use it for free, and upgrade for all the bells and whistles.
Install the software on your desktop computer (Windows & Mac)
Download the web clipper to your browser (app store or Google it)
Download the free Evernote app to your mobile devices from the iTunes App Store or Google Play
Features & Costs
(Subject to change. Visit evernote.com/compare-plans)
Evernote pricing plans comparison Sept. 2021 – See the website for the most current offer.
Software Home Layout
Evernote’s Home view gives you a summary of what you’ve got going on in Evernote. If Home is new to you and you don’t see it, simply head to the left Navigation menu and click Home.
Home gives you a place to sort of summarize what you’ve got going on in Evernote. It also allows you to add more personalization.
A fun way to personalize Evernote is by adding a background image. Click Customize in the upper right corner, and then click the Change Background button. Here you can add a preset image or add your own.
By default, Home comes with widgets such as:
Notes (highlighting your most recent notes, and Suggested notes based on your activity)
A Scratch Pad
Recently Captured items by type (web clips, images, documents, audio and emails)
While you’re in Customize mode, you’ll see additional available widgets like:
Calendar (allowing you to sync your Google calendar with Evernote)
Filtered Notes
Notebooks
Pinned Notes
An additional Scratch Pad
Shortcuts
Tags
Tasks
We’ll explore some of these further in a moment. But first, let’s create our first note!
All Notes View – SnippetView:
Left column = your files and organization
Center column = search for notes
Right column = the note you are currently working on
Change the layout by clicking the View Options icon (in SnippetView it appears at the top of the search column). This will give you a variety of layout options.
Change what appears or is hidden from view, and whether the view is dark or light by clicking View in the menu.
Notetaking 101
Create a note by clicking the New Note(+) button at the top of the screen.
Creating a new note is as simple as starting to type. Evernote saves your work instantly and without any extra effort on your part. Notes are saved in “the Cloud” on Evernote’s servers. This means all of your notes are automatically backed up. In addition, all of your notes will sync across all of your various computing devices. And Evernote facilitates sharing notes with others for research collaboration.
Click the Info icon at the top of the note to see the meta-data for that note. You can add and edit this information.
Types of Notes:
Typed
Sketched
Photos
Attachments
Video
Audio
Note Info has changed and can now be found by pressing Control + Shift + I on your keyboard, or clicking the More Actions (3 dots icon) in the upper right corner of the note and selecting Note Info.
Tagging is the Key to Organization
Add a tag based on important keywords associated with the note.
Examples of tags for genealogy:
Surnames (Cooke, Moore)
Record types (birth, census, land)
Locations (Indiana, Germany)
Time frames (1900-1909, 1910-1919)
Tasks (pending, add to database, follow up, etc.)
To tag a note, click Add Tag at the top of the note and select a tag from your list or add a new tag. Tags will appear in the left column. Click any tag in the left column to retrieve all notes with that tag.
Evernote Tasks
In June of 2021 Evernote added a Tasks feature. It operates just a little differently than how I’ve been using tasks. Evernote tasks are:
To Do Items
Note Specific (versus a tag which can retrieve all notes with that task)
Often Deadline Driven
Assignable to Others
Searchable
Where is the Trash?
You will find Evernote’s Trash bin at the bottom of the Navigation bar on the left.
Notebooks
Notebooks take organization a step further. I create notebooks sparingly. I use them to divide Evernote up into workspaces: Genealogy, Personal, Business, etc. I also use them for long-term and collaborative research projects that I may want to share with others. You can drag and drop notebooks on top of each other to create Stacks, although Evernote only allows one level of stacking.
How to create a new notebook:
In the menu select: File > New Notebook
Name the new notebook in the pop-up window
Select notebook type – usually you would set it up to synchronize, but you do have the option to have the notebook reside only on the computer it was created by selecting Local
The Cloud and Synchronization
Notes are saved on your computer and in the Cloud on Evernote’s servers. This means all of your notes are automatically backed up, and also accessible from your account on their website. Your notes will sync across all of your computing devices that have Evernote installed. There’s no need to manually sync with the new version. It happens automatically whenever you’re connected to the internet.
Web Clipping
As you visit webpages, you can clip just the portion of the page that you want to remember and keep rather than printing the page or bookmarking it. You can type the source citation directly into the note. Clippings appear as images in the note.
How to clip a screenshot using the computer software:
Right-click on the Evernote icon in your computer task bar.
Select Clip Screenshot.
Use the cross-hairs to draw a box around the desired content.
Release you mouse and you will see a quick flash on the screen indicating the content has been saved as a note in Evernote.
In Evernote click on the note to type additional information if desired.
How to download the free Evernote web clipper for your web browser:
Go to: evernote.com/webclipper
The download page will detect the browser that you are using and offer the correct web clipper. Click the download button.
The Evernote web clipper will install in your web browser (look in the upper right corner of your browser for the elephant icon.)
Sign into your Evernote account in the clipper.
Using the Browser Web Clipper:
When you visit a web page and find something that you want to clip, click the Evernote Web Clipper (elephant) icon in your web browser. The browser web clipper can save:
a full page (even the parts out of view)
an article
a simplified article (removing unwanted graphics and text not pertaining to the article)
a screenshot (where you precision clip with cross hairs)
a bookmark
As you clip you can select which notebook to file the note in and add any desired tags. It will also include the URL in the note header.
Search and Retrieval
Type a keyword into the search box and Evernote will locate and display notes that contain the keyword in the center column. This includes typed text from a website clipping or image, as in the example above. With a subscription, OCR technology makes it possible for you to search for words in Evernote to retrieve notes that include those words, both on the clipped image and in printed handwritten text.
This episode features a special interview with renowned Canadian expert Dave Obee. He shares his favorite tips on researching the Canadian census?his insights are fascinating whether you have Canadian ancestors or not!
Also in this episode: an inspiring adoption discovery, DNA testing news at 23andMe, a tip for incorporating family history into a wedding, and a brand-new resource that can finally help you solve one of genealogy’s most perplexing questions.
NEWS: ATLAS OF HISTORICAL COUNTY BOUNDARIES UPDATE
Click here to watch the presentation that inspired this guide: a popular RootsTech 2017 lecture comparing the four major genealogy records websites: Ancestry.com, FamilySearch.org, Findmypast.com and MyHeritage.com.
This comprehensive quick reference guide explains:
How knowing about all four websites can improve your family history research
How the sites stack up when it comes to the numbers of historical records, names in trees, DNA profiles, site users, site languages and subscription costs
Unique strengths of each website and cautions for using each
What to keep in mind as you evaluate record content between sites
Geographic record strengths: A unique table has an at-a-glance comparison for 30+ countries
How to see what kinds of records are on each site without subscribing
How family trees are structured differently at these websites?and why it matters
Privacy, collaboration and security options at each site
How DNA testing features differ at the two websites that offer it
What you can do with free guest accounts at each website
Subscription and free access options
MAILBOX: LIZ ON FINDING CHUCK’S BIRTH FAMILY
Click here to learn more about Diahan Southard’s genetic genealogy video tutorials?and a special discount price for Genealogy Gems fans.
LINK TO: https://www.yourdnaguide.com/genealogy-gems-dna-tutorial
Lisa Louise Cooke uses and recommends RootsMagic family history software. From within RootsMagic, you can search historical records on FamilySearch.org, Findmypast.com and MyHeritage.com. In the works: soon RootsMagic will be fully integrated with Ancestry.com, too: you’ll be able to sync your RootsMagic trees with your Ancestry.com trees and search records on the site.
Keep your family history research, photos, tree software files, videos and all other computer files safely backed up with Backblaze, the official cloud-based computer backup system for Lisa Louise Cooke’s Genealogy Gems. Learn more at http://www.backblaze.com/Lisa
Continuing our celebration of Canada’s 150th birthday!
Dave Obee is an internationally-renowned Canadian journalist, historian and genealogist. Dave is a columnist for Internet Genealogy and Your Genealogy Today (formerly Family Chronicle). Dave has also written about family history for Canada’s History and Your Family Tree in the United Kingdom.
Start creating fabulous, irresistible videos about your family history with Animoto.com. You don’t need special video-editing skills: just drag and drop your photos and videos, pick a layout and music, add a little text and voila! You’ve got an awesome video! Try this out for yourself at Animoto.com.
If you’re listening through the Genealogy Gems app, your bonus content for this episode is EXTRA special! It’s an exclusive conversation between Your DNA Guide and Cece Moore of DNA Detectives on researching adoption or unknown parentage. Don’t miss it! The Genealogy Gems app is FREE in Google Play and is only $2.99 for Windows, iPhone and iPad users.
GENEALOGY GEMS BOOK CLUB
Our featured genealogy book club author this month is Miss Fannie Flagg!
