Genealogy at the State Library of Pennsylvania

One thing that many genealogists have in common is a connection to Pennsylvania. Perhaps one of your family tree branches extends back to the early founding of the Pennsylvania colony. Or it may be that one of your ancestors was one of the hundreds of thousands who arrived through the port of Philadelphia. Even if you don’ t have Pennsylvania ancestors the State Library of Pennsylvania has a lot to offer.

State library of Pennsylvania Genealogy

Genealogy at the State library of Pennsylvania 

In this episode I’ll be sharing with you a video of my interview with two librarians from the State Library of Pennsylvania. We’ll discuss their collections and specifically what’s available through their website. After the interview I’ll show you some specific search techniques that you can use at the State Library of Pennsylvania website, including a trick that you can use with any state library website.

Elevenses with Lisa Episode 46 Show Notes

My special Guests from the State Library of Pennsylvania:
Kathy Hale, Government Documents Librarian
Amy Woytovich, Genealogy Librarian

State Library of Pennsylvania Website
Genealogy at the State Library of Pennsylvania

 State Library of Pennsylvania Update

This interview was recorded in December 2020. Here’s the latest update (as of this writing) on the library closure and access:

  • The State Library is currently closed to all visitors. However, staff is teleworking. People may send inquiries to ra-reflib@pa.govand staff will answer questions as best they can. 
  • Renovations have begun on our library in the Forum Building. There may be times we cannot get to the materials requested because of the construction. 
  • Interlibrary loan services are available, but patrons must check if their home library has the equipment and are open for patrons to use that equipment. The Library still ships all over the U.S.
  • Watch their website for instructions on how to access the State Library of Pennsylvania when it does reopen to the public.

The State Library of Pennsylvania Background

The library has been a federal repository library since 1858, and is one of the oldest in the country. The government printing office deposits materials here.

The State Library of Pennsylvania Collection

The State Library of Pennsylvania physical collection includes:

  • 30,000 volumes
  • 100,000 reels of microfilm
  • A million pieces of microfiche

 The State Library of Pennsylvania digitized items include:

  • County and family histories
  • Local histories
  • Small church histories from rural areas
  • City directories
  • Passenger lists
  • Regimental histories (Revolution to Spanish-American War)
  • Pension Lists
  • Pennsylvania Published Archives (collection of military, government, marriage, immigration records from colonial times)
  • The 1940 U.S. Federal Census

Pennsylvania Documents
Example: a report for Pennsylvania of the 25th and 50th anniversaries of the Battle of Gettysburg. Includes information gathered at reunions including names, pictures, and more.

U.S. Government Documents – Serial Set
This collection includes reports to the legislature from agencies and institutions. Example: The Daughters of the American Revolution (DAR) were compelled to provide to Congress a yearly report of the names of people approved by DAR. These can be accessed through many libraries, the federal government or by contacting the State Library of Pennsylvania via email: Ra-reflib@pa.gov

State Library of Pennsylvania Research Guides

Amy discusses research guides available on the website. However, here is the link to the topics she specifically mentions such as Cemeteries and Zeamer collection – recorded information about Cumberland County PA cemeteries. General Research Guides page. These research guide pages include links to additional helpful websites.

State Library of Pennsylvania website’s Genealogy Page

At the top of the page look at the For General Public tab which will take you to all of the genealogy research guides. Visit the Genealogy page at the State Library of Pennsylvania.

Newspapers at the State Library of Pennsylvania

The library’s collection of newspapers includes papers from all 67 Pennsylvania counties on microfilm. They do have a lot of digitized newspapers at the Pennsylvania Photos and Documents Collection at the Power Library.

Newspapers at the Power Library

Newspapers at the Power Library

The Power Library

You can find the Power Library by going to the libraries home page, and under the For General Public tab go to Our Collections > Power Library. Or visit the Power Library website at Powerlibrary.org.

  • Electronic Databases: you have to be a resident with a library card.
  • Digital Documents: you don’t have to be a Pennsylvanian to access this collection.

At the top of the Power Library home page on the right you’ll find Digital Docs and Photos:

Power Library genealogy

Pennsylvania Photos and Documents Collection at the Power Library.

There you will find many materials from Pennsylvania colleges including yearbooks. You can browse by subject area, with Genealogy being one of those areas.

Interlibrary Loan and Lookups

At the time of the interview the library was not open for interlibrary loan and lookups. Check the website for the latest updates.

The library does loan its newspaper microfilm. Up to 5 reels of microfilm per request. Kathy says that if you find a newspaper article at Newspapers.com and you see the title, date and the page that an article is on, you can provide the information to the interlibrary load reference librarian at your local library and place a request for a scan of the article from the State Library of PA microfilm. The article can then be returned to you digitally through interlibrary loan. The digitized scan is yours to keep.

The Librarians Favorite Collections

Amy’s Pick: Historic maps found at the library’s website Home > For General Public > Genealogy and Local History > Maps and Geographic Information. This includes Sanborn Fire Insurance Maps. Note: log in with a library card may be required. Contact the library with questions.

Kathy’s favorite collections include:

  • Map Collection consisting of over 35,000 maps.
  • The 5 generations from the Mayflower collection.

Usage of Materials

Usage rights and copyright are important considerations when utilizing library materials. Usage depends on the individual item’s copyright. It should be researched as much as possible. Check the meta data of digital images for copyright information.

How to Get Research Help from the State Library of Pennsylvania

“Think of Amy and I as your personal librarians.”  Kathy Hale, Librarian

Contact State Library staff by phone at 717-787-2324 or by email at:

Lisa’s Tips for Using the State Library of Pennsylvania Website

Maps for Genealogy

At the website go to Home page > General Public Tab > Our Collections > Search our Resources.

  1. Type in a location and the word map
  2. Use the filters on the right side of the page > Library > State Library
  3. Click to select a map
  4. Try filtering to Full Text Online
  5. Look for the Online Access link, just above Text Item Call Number.

On the map viewer page, click the thumbnail button (looks like a checkerboard) to see multiple pages at a time. You’ll find the Download button in the bottom right-hand corner. The Print button is in the upper right corner.

Cite your source: Go back to the result page, and scroll down. Click the red button called Cite This. This allows you to copy the source citation which you can then paste into other documents and programs.

Newspapers for Genealogy

The Library of Congress Chronicling America website has many Pennsylvania old newspapers, but it doesn’t include all of the newspaper that the library has in its collection. Here’s how to find old Pennsylvania newspapers at the State Library website:

  1. On the State Library website go to General Public > Research Guides > Newspapers
  2. Click the link to the Pennsylvania Newspaper Archive
  3. Browse by title or date, or use the drop-down menus
  4. On the viewer page, zoom into the desired article. Then click Clip/Print Image
  5. Right-click on the clipped image to save it to your hard drive.
  6. The Persistent link is the URL address to your clipping.

Google Site Search Tip 

This tip comes from my book The Genealogist’s Google Toolbox and my Premium Membership video The Genealogist’s Google Search Methodology.

The Genealogist's Google Toolbox Third edition Lisa Louise Cooke

Available at the Genealogy Gems store.

Many websites have their own search engine. However, each search engine is only as good as it was programmed. If you can’t find what you want on a website like the State Library PA website, try using a Google site search. Site search tells Google to search for your search terms only on the website you specify. 

In my example in the video, you can see that Google found the one page mentioning the surname in a listing of microfilms much faster than I would have found it digging around and navigating the website itself. This page was not a card catalog entry so it would not have come up in a search of the catalog on the website.

Learn More About the State Library of PA Collections

In episode 43 of Elevenses with Lisa we discussed genealogy records available for free at the Internet Archive. The State Library of Pennsylvania has been partnering with he Internet Archive to digitize many additional items from their collection. You can access these items for free at the State Library Internet Archive Collection. This collection includes a large number of World War I materials as well as a growing number of 19th and 20th century pamphlet volumes.

How to Use the Internet Archive

Resources

 

 

Premium Podcast Episodes

Premium Podcast Episodes As a Genealogy Gems Premium Member you have access to the entire back catalog of Premium Episodes! Of course, things do change over time, so occasionally you’ll hear about something that is no longer around (like the Premium Message...

Genealogy & Family Tree Video Classes

Choose from our vast catalog of free and Premium genealogy video classes and tutorials. Start by selecting a topic below. Tip: On desktop use Ctrl F (Win) or Cmd F (Mac) to search the entire list of videos by keyword. Note: The search box and Categories menu on the right (desktop) or the bottom of the page (mobile) apply to audio podcast episodes and articles.

Beginner

DNA

Elevenses

Ethnicities

Google

Maps & Geography

Methodology 

Organization & Preservation

Photos & Videos 

Records

Story & Sharing 

Technology Tools

Websites

Videos marked “Premium” require a Premium Membership. Premium Members also have access to the downloadable ad-free show notes handout for all videos. 

Beginner

Home Research – Family History at Home
15 Freebies for Genealogy
Free Genealogy
Inherited Genealogy – How to Deal with It
Data Flow for Genealogy
Getting Started with DNA Testing (Premium)
Google.com Getting Better Search Results (Premium)
Evernote for Genealogy  – Beginner
FamilySearch Strategy Essentials
FamilySearch Wiki Navigation
Take Control of Preserving Your Family History Information (Premium)
RETURN TO TOP OF PAGE

DNA

5 Tips for Understanding DNA Results with Diahan Southard (Premium)
Autosomal DNA Results: Make the Most of Them with Diahan Southard (Premium)
DNA: Glue that Holds Families Together with Diahan Southard (Premium)
DNA Match with No Tree? No Problem! (Premium)
DNA Problem Solving
DNA Q&A with Ancestry’s Crista Cowan
DNA Painter Quick review with Blaine Bettinger
Forensic Genealogist – How to Become One with Dr. Claire Glen
Forensic Genealogy Future and Phenotyping (Premium)
Gedmatch Shared Matches Tool with Diahan Southard (Premium)
Getting Started with DNA Testing with Diahan Southard (Premium)
Organizing Your DNA Matches with Diahan Southard (Premium)
Mitochondrial DNA Quick Introduction with Diahan Southard (Premium)
Mitochondrial DNA Match Page Quick Overview with Diahan Southard (Premium)
MyHeritage DNA Genetic Groups
MyHeritage DNA Results: Get the Most Out of Them (Premium)
YDNA Quick Introduction with Diahan Southard (Premium)
YDNA Haplogroups Quick Overview with Diahan Southard (Premium)

Become a Premium Member
RETURN TO TOP OF PAGE

Elevenses with Lisa (2020: The 1st Year)

  1. Pilot (Premium)
  2. Research Plan (Premium)
  3. BSO Strategies (Premium)
  4. Mobile Organization (Premium)
  5. Online Organization
  6. Organization Paper (Premium)
  7. Organizing Data Q-A (Premium)
  8. Organize Digital (Premium)
  9. Evernote (Premium)
  10. Saving Your Genealogy from Destruction (Premium)
  11. Inspiring Ways to Captivate Non-Genealogists (Premium)
  12. Google Earth (Premium)
  13. Google Search – Get Better Results (Premium)
  14. Creating Family History Videos (Premium)
  15. Learning from History (Premium)
  16. Using Adobe Spark Video (Premium)
  17. Ancestry Top Tips (Premium)
  18. Irish Genealogy Professional Consultation (Premium)
  19. Filling Blanks in Your Research (Premium)
  20. House History
  21. Free Genealogy
  22. Your Ancestor’s Neighborhood (Premium)
  23. Google Photos
  24. Your Online Mindset (Premium)
  25. Elevenses with Lisa Viewers Voices (Premium)
  26. Newspaper Navigator and the Library of Congress
  27. Google Lens for Genealogy
  28. House Photo ID
  29. Family Bible
  30. Google Books
  31. Allen County Genealogy Center
  32. Artificial Intelligence
  33. Early American Genealogy (New England)
  34. Passenger lists
  35. Viewer Voices 2 (Premium)
  36. Rumsey Maps
  37. Provenance of Records
  38. A Cup of Christmas Tea with Tom Hegg (Dec 2020)

RETURN TO TOP OF PAGE

Ethnicities

German Genealogy for Beginners
German Villages – How to find them
Irish Genealogy Expert Solutions Beginner Part 1 (Premium)
Irish Genealogy Filling in the Blanks Intermediate Part 2 (Premium)
Italian Genealogy
Italian Dual Citizenship
Jewish Genealogy
Native American Genealogy
Public Records Office of Ireland

Become a Premium Member
RETURN TO TOP OF PAGE

Google

The Genealogist’s Google Search Methodology (Premium)
Google: Common Surname Search Strategies (Premium)
Google – Getting Better Search Results (Premium)
Google – 5 Genealogy Search Hacks (Premium)
Google – 5 Search Secrets for Genealogy (Premium)
Google – More Search Strategies (Premium)
Google – How to Reconstruct Your Ancestor’s World (Rootstech 2023)
Google Books – Getting Started (Premium)
Google Books – 10 Surprising Finds
Google Books – New Features
Google Drive (Premium)
Google Images Best Search Strategies
Google Lens for Genealogy
Google Photos Introductory Tour
Google Scholar for Genealogy
(Premium) 

Get Lisa’s book: The Genealogist’s Google Toolbox
RETURN TO TOP OF PAGE

Maps & Geography

5 Ways to Use Old Maps in Your Research (Premium)
Best Websites for Finding Old Maps (Premium)
Create a Historic Map Collection for Your Research (Premium)
Davidrumsey.com Free Maps and How to Find Them
Exporting MyMaps to Import into Google Earth 
Google Earth for Genealogy
(Beginner) 
Google Earth – How to Plot Land
Google Earth: Time Travel (Premium)
Google Earth – Ways to Use it for Genealogy (Premium)
House History Research (Premium)
House Photo Identification
Illuminating Locations (Premium)
Neighborhoods in Google Earth (Premium)
Paths – Create Emigration Paths in Google Earth (Premium)
Rural Address – How to Find & Map Them
Sanborn Fire Insurance Maps – Beginner (Premium)
Sanborn Fire Insurance Maps, Applying them to Research – Intermediate (Premium)
Sanborn Fire Insurance Map Collection at LOC
Towns of Origin – 16 Ways to Find Them

Become a Premium Member
RETURN TO TOP OF PAGE

Methodology

Big Picture in Little Details (Premium)
Birthdates Conflict and How to Solve It
Cold Case Strategies (Premium)
Finding Hard-to-Find Records
Free Genealogy
Home Research – Family History at Home
How Alice the Genealogist Avoids Rabbit Holes (Premium)
Living Relatives – How to Find Them (Premium)
Maiden Names 12 Strategies for Finding Them
Newspapers – How to Get the Scoop on Your Ancestors (Premium)
Productivity and BSOs (Premium)
Rate Your Readiness for Genealogy Success
Research Plans (Premium)
Restart Your Genealogy
Source Citations
Story Behind Genealogy Records
Timelines – Beginner (Premium)
Towns of Origin – 16 Ways to Find Them
Transcription and Analysis (Premium)
Witness Research

Become a Premium Member
RETURN TO TOP OF PAGE

Organization & Preservation

Archival Storage Options
Clean Up Your Genealogy Database
(Premium)
DAR – How to Join
Data Organization (Premium)
Digital Organization (Premium)
Digital Preservation Library of Congress Style
Documenting Family History with Shotbox
Evernote Organization (Premium)
Evernote: Organize Your Research (Premium)
Hard Drive Organization Part (Premium)
Heirlooms – Passing Them and Their Stories On (Premium)
How Alice the Genealogist Avoids the Rabbit Hole Parts 1 & 2
How Alice the Genealogist Avoids the Rabbit Hole Parts 3 & 4
Inherited Genealogy – How to Deal with It
Inspiring Relatives’ Interest to Protect the Family History (Premium)
Mobile Computing Organization (Premium)
Online Productivity (Premium)
Organize All this Stuff! (Premium)
Organize Your Online Life
(Premium)
Paper Organization (Premium)
Save Your Research from Destruction (Premium)
Take Control of Preserving Your Family Tree Information (Premium)
5 Family History Holiday Ideas

RETURN TO TOP OF PAGE

Photos & Videos

5 Ways to Improve Old Home Movies
Creating Family History Story Videos (Premium)
Dead Fred – The Secret to Finding Old Family Photos
(Photo) Digital Preservation Library of Congress Style
Edit Your Home Movies
Frith Photo Collection at FindMyPast
Google Images (Photos) Best Search Strategies
Google Photos Introductory Tour
House Photo Identification
How to Make a Video with an Adobe App (Premium)
Solving Unidentified Photo Album Cases (Premium)
Video Magic (Creating Family History Videos) Part 1 (Premium)
Video Magic (Creating Family History Videos) Part 2 (Premium)
Video Magic (Creating Family History Videos) Part 3 (Premium)
Videos – 10 Ways to Add Volume to Family History with Videos (Premium)

Become a Premium Member
RETURN TO TOP OF PAGE

Records

1931 Canada Census – 4 Fast Search Strategies
1950 Census Overview
1950 Census Questions
1950 Census Enumeration District Maps
1950 Census Indexing at FamilySearch
1950 Census Search Strategies (Premium)
1890 Census & Substitute Records
15 Freebies for Genealogy
Cemetery Research & Finding the Stories
Church Record (Premium)
Comparing the Newspaper Giants (with Sunny Morton) (New)
Compiled Family Histories at Ancestry 
Compiled Family Histories & Genealogies
– Best Places to Find Them (Premium
Early American Ancestor Records with NEHGS
Ellis Island Records (Passenger, Customs & Detention LIsts)
Family Bibles (Premium)
Freedmen’s Bureau (Premium)
Institutional Records (Premium)
Marriage Records – 5 Steps for Finding Them
Marriage Records Case Study with J. Mark Lowe
Marriage Records and Gretna Green with J. Mark Lowe
Newspapers – Getting the Scoop on Your Ancestors
Newspapers – 5 Top Research Tips
Newspapers at Google Books 
Newspapers – Finding Family Recipes
Newspapers – Reconstructing Your Ancestor’s Life
Newspaper Navigator at the Library of Congress
Newspapers.com – Digging Deeper (Premium)
Obituaries at Newspapers.com
Ohio Records at Ohio Memory (Premium)
Passenger Lists (Ellis Island Records)
Passenger Lists Deciphering
PERSI Like a Pro! with Allison Singleton (Premium)
School Records
Virginia Early Records

RETURN TO TOP OF PAGE

Story & Sharing

Airplane! Director David Zucker on Family History
Behind the Scenes with Director David Zucker (Premium)
Christmas Cup of Tea with Author Tom Hegg
Creating Family History Story Videos (Premium)
Crime Stories with Author Nathan Dylan Goodwin
Elevenses with Lisa Pilot Episode (Premium)
Emigration Paths Tours in Google Earth) (Premium)
Genealogy Gems Viewer Voices 1 (Premium)
Genealogy Gems Viewer Voices 2 (Premium)
Inspiring Non-Genealogists in Your Life (Premium)
Instagram & Pinterest for Genealogy (Premium)
Interview Questions (Premium)
Learning from History with Daniel Horowitz (Premium)
Family History Narrative Research 
Reconstructing Your Family’s Amazing Stories (Premium)
Self Publish a Book! 
Share Your Life Story in a More Meaningful Way (Premium)
World War II Fallen Stories
Writing and Publishing a Family History Book

Become a Premium Member
RETURN TO TOP OF PAGE

Technology Tools

10 Tech Tools You Can’t Live Without (Premium)
Artificial Intelligence
AI Chatbots and Genealogy – should you use them?
AI Time Machine at MyHeritage
Apps – How to Find Essential Apps for Genealogy (Premium)
Cloud Backup (Premium)
Data Flow for Genealogy
Dropbox (Premium)
Evernote for Genealogy  – Beginner
Evernote: 10 Projects to Enhance Your Genealogy (Premium)
Evernote and Collaborative Genealogy (Premium)
Evernote: Creating a Research Plan in Evernote (Premium)
Evernote Organization (Premium)
Evernote: Organize Your Research (Premium)
Evernote: Making It Effortless to Use for Genealogy (Premium)
Evernote versus Snagit
Future of Technology & Genealogy (Premium)
GEDCOMs
Google Drive (Premium)
iPad – Genealogy on the Go (Premium)
Newspaper Navigator at the Library of Congress
Online Mindset – Take Control of Your Online Activity (Premium)
RootsMagic with Founder Bruce Buzbee
Snagit (Beginner)
Snagit (Intermediate)
Tech Can Wreak Havoc on Genealogy (Premium)
Time Travel Technology (Premium)
VPNs – Why I Use One
YouTube – Find Your Family History

RETURN TO TOP OF PAGE

Websites

Which Genealogy Website Should I Use? (Premium)
Ancestry – Compiled Family Histories 
Ancestry Top Search Tips (Premium)
Ancestry – What’s this Records Hint? Geneanet
ArchiveGrid (Premium) 
Ellis Island Passenger Search
FamilySearch Strategy Essentials
FamilySearch Wiki Navigation(Beginner)
FamilySearch Wiki Deep Dive (Premium)
Genealogy Center at Allen Co Public Library Website
Genealogy Giants – Comparing Ancestry, MyHeritage, FamilySearch, Findmypast (Premium)
Google Scholar for Genealogy (Premium) 
History Hub (NARA) 
Internet Archive – 10 Records You’ll Love to Find
MyHeritage – 10 Don’t Miss Features
Newspaper Navigator at the Library of Congress
Newspapers.com – Digging Deeper (Premium)
One-Step WebPages with Steve Morse
PERSI Like a Pro! with Allison Singleton (Premium)
State Library of Pennsylvania
U.S. National Archives – In Person Access
U.S. National Archives Website
WikiTree (Beginner)
WorldCat – 5 Things You Should Do

How German Address Books at Ancestry.com are Helping Bust Brick Walls

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.

bust brick walls with German Address Books at Ancestry

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.

Gus & Louise Sporan German Genealogy Records Bust Brick Wall

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.

Notes German Address Books at Ancestry Genealogy Records Bust Brick Wall

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.

Naturalization Record German Address Books at Ancestry

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:

Germany and Surrounding Areas, Address Books, 1815-1974

German Address Books Ancestry Bust Brick Wall

“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!

German address books results list at Ancestry.com

“All Germany and Surrounding Areas, Address Books, 1915-1974,” Ancestry.com (http://www.ancestry.com : accessed 05 Sept 2019)

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.

German Genealogy Help at Ancestry.com

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.

German Military Casualty List Ancestry.com

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.

German Address Books at Ancestry.com bust Brick wall

“All Germany and Surrounding Areas, Address Books, 1915-1974,” Ancestry.com (http://www.ancestry.com : accessed 05 Sept 2019)

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.

Sporowski from Bochum Germany photograph

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.

Excel Spreadsheet tracking German Address Books at Ancestry.com

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 German words found in Address Books at Ancestry.com

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.

One of the top results was by friend of the podcast Katherine Schober and her SK Translations blog post called 19 Most Common Abbreviations in German Genealogy.

______________________________

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.

  1. 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.)
  2. 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:

When to Use Google Translate for Genealogy–And Best Translation Websites for When You Don’t

Translating German Genealogy Records: 9 Top German Translation Websites

Deciphering Place Names Just Got Easier

I’ve written an article you may find helpful not only for translation but also to help you with pronunciation called How to Pronounce Names: Google Translate and Name Pronunciation Tools.

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.

Finding the full name of the German address in Google Earth

Finding the full name of the German address. (Map data ©2019 Google Earth software: accessed 6 Sep 2019)

Soon I found myself virtually standing outside their homes thanks to Google Earth’s Street View feature!

House of my Germany ancestor found in Google Earth

Home of my German ancestor found in Google Earth in Street View. (Map data ©2019 Google Earth software: accessed 6 Sep 2019)

Here’s how to use Street View in Google Earth:

  1. Zoom in close to the location
  2. Click on the Street View icon in the upper right corner (near the zoom tool)
  3. Drag the icon over the map and blue lines will appear where Street View is available
  4. Drop the icon directly on the line right next to the house
  5. Use the arrow keys on your keyboard to navigate in Street View or simply use your mouse to drag the screen
Using Google Earth Street View

Using Google Earth Street View. (Map data ©2019 Google Earth software: accessed 6 Sep 2019)

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 marked in 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:

  1. Right-click (PC) on the MyPlaces icon at the top of the Places panel (left side of the Google Earth screen)
  2. Select Add > Folder in the pop-up menu
  3. A New Folder dialog box will appear
  4. Type the name of your folder
  5. Click OK to close the folder
  6. You can drag and drop the folder wherever you want it in the Places panel
  7. 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.
How to Create a Folder

Creating a Folder for the German Addresses found at Ancestry.com (Map data ©2019 Google Earth software: accessed 6 Sep 2019)

It didn’t take long to build quite a nice collection of Sporowski homes in Germany!

German addresses in the Google Earth Places panel

German addresses in the Places panel. (Map data ©2019 Google Earth software: accessed 6 Sep 2019)

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. 

Data Visualization: My German Families found in Address Books

Data Visualization in Google Earth: My German Families found in Address Books. (Map data ©2019 Google Earth software: accessed 6 Sep 2019)

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.

 

Pin It on Pinterest

MENU